Order.php 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193
  1. <?php
  2. namespace Cash\Lib;
  3. use Dever;
  4. class Order
  5. {
  6. # 更新结算单
  7. public function up($order, $jstype = 1, $audit = 1, $refund = false, $pay_type = 1, $operdate = false)
  8. {
  9. Dever::config('base')->hook = true;
  10. if (!$order) {
  11. return false;
  12. }
  13. if ($audit == 2) {
  14. $status = 2;
  15. } else {
  16. $status = 1;
  17. }
  18. if ($jstype == 2) {
  19. $audit_type = 2;
  20. } else {
  21. $audit_type = 1;
  22. }
  23. $where['source_order_id'] = $order['id'];
  24. $where['jstype'] = $jstype;
  25. if (!$refund) {
  26. $where['refund_id'] = -1;
  27. } else {
  28. $where['refund_id'] = $refund['id'];
  29. }
  30. $where['clear'] = true;
  31. $info = Dever::db('cash/order')->find($where);
  32. $update = $where;
  33. $update['pay_type'] = $pay_type;
  34. $update['status'] = $status;
  35. $update['audit'] = $audit;
  36. $update['audit_type'] = $audit_type;
  37. if ($update['status'] == 2) {
  38. $update['operdate'] = $operdate ? $operdate : time();
  39. $update['fdate'] = $update['operdate'];
  40. if (isset($order['fdate']) && $order['fdate'] && ($order['status'] == 5 || $order['status'] == 6)) {
  41. $update['fdate'] = $order['fdate'];
  42. }
  43. }
  44. if ($info && $jstype == 3) {
  45. } else {
  46. $update['type'] = $order['type'];
  47. $update['type_id'] = $order['type_id'];
  48. if ($order['source_type']) {
  49. $update['source_type'] = $order['source_type'];
  50. $update['source_id'] = $order['source_id'];
  51. }
  52. $update['source_order_num'] = $order['order_num'];
  53. $update['num'] = $order['num'];
  54. if ($refund) {
  55. $update['cash'] = $refund['cash'];
  56. $update['p_cash'] = isset($refund['p_cash']) ? $refund['p_cash'] : 0;
  57. } else {
  58. $update['cash'] = $order['price'];
  59. $update['p_cash'] = $order['p_price'];
  60. }
  61. if ($jstype == 2) {
  62. $update['cash'] = -1*$update['cash'];
  63. $update['p_cash'] = -1*$update['p_cash'];
  64. $update['num'] = -1*$update['num'];
  65. }
  66. }
  67. if (isset($update['cash']) && $update['cash'] <= 0) {
  68. return;
  69. }
  70. if ($info) {
  71. $update['where_id'] = $info['id'];
  72. $state = Dever::db('cash/order')->update($update);
  73. } else {
  74. $update['order_num'] = $this->getOrderId();
  75. $state = Dever::db('cash/order')->insert($update);
  76. }
  77. if ($state && $jstype == 2 && $status == 2 && isset($order['status']) && $order['status'] == 8) {
  78. # 如果是退款结算,同时要把主订单也结算
  79. $where = array();
  80. $where['source_order_id'] = $order['id'];
  81. if ($pay_type > 1) {
  82. $where['jstype'] = 3;
  83. } else {
  84. $where['jstype'] = 1;
  85. }
  86. $where['audit'] = 1;
  87. $where['clear'] = true;
  88. $info = Dever::db('cash/order')->find($where);
  89. if ($info) {
  90. $set['status'] = 2;
  91. $set['audit'] = 2;
  92. $set['where_id'] = $info['id'];
  93. $set['operdate'] = $operdate ? $operdate : time();
  94. $set['fdate'] = $operdate ? $operdate : time();
  95. Dever::db('cash/order')->update($set);
  96. }
  97. }
  98. }
  99. # 生成订单号
  100. public function getOrderId()
  101. {
  102. $where['order_num'] = Dever::order('JS');
  103. $state = Dever::db('cash/order')->one($where);
  104. if (!$state) {
  105. return $where['order_num'];
  106. } else {
  107. return $this->getOrderId();
  108. }
  109. }
  110. #导出Excel
  111. public function out_order_api($data){
  112. $header = array('ID', '结算单号', '结算门店', '订货单编号', '数量', '结算金额', '结算类型', '入账状态', '审核状态', '支付类型', '结算时间','审核备注','生成时间', '礼品卡卡号');
  113. $body = array();
  114. foreach($data as $k => $v){
  115. $type_info = Dever::db('shop/info')->find(array('id'=>$v['type_id']));
  116. $config_jstype = Dever::db('cash/order')->config['config_jstype'];
  117. if(isset($v['jstype']) && $v['jstype']){
  118. $jstype = Dever::status($config_jstype,$v['jstype']);
  119. }
  120. $config_status = Dever::db('cash/order')->config['config_status'];
  121. if(isset($v['status']) && $v['status']){
  122. $status = Dever::status($config_status,$v['status']);
  123. }
  124. $config_audit = Dever::db('cash/order')->config['config_audit'];
  125. if(isset($v['audit']) && $v['audit']){
  126. $audit = Dever::status($config_audit,$v['audit']);
  127. }
  128. if(isset($v['pay_type']) && $v['pay_type']){
  129. if($v['pay_type'] == 1){
  130. $pay_type_name = '在线支付';
  131. }elseif($v['pay_type'] == 2){
  132. $pay_type_name = '礼品卡支付';
  133. }else{
  134. $pay_type_name = '钱包支付';
  135. }
  136. }
  137. $operdate = '-';
  138. if(isset($v['operdate']) && $v['operdate']){
  139. $operdate = date('Y-m-d H:i',$v['operdate']);
  140. }
  141. $cdate = '-';
  142. if(isset($v['cdate']) && $v['cdate']){
  143. $cdate = date('Y-m-d H:i',$v['cdate']);
  144. }
  145. $card_code_card = '';
  146. if ($v['pay_type'] == 2) {
  147. $sell_order = Dever::db('shop/sell_order')->find($v['source_order_id']);
  148. if ($sell_order) {
  149. $card_code_card = $sell_order['card_code_card']."\n";
  150. }
  151. }
  152. $d = array
  153. (
  154. $v['id'],
  155. $v['order_num'],
  156. $type_info['name'],
  157. $v['source_order_num'],
  158. $v['num'],
  159. $v['cash'],
  160. $jstype,
  161. $status,
  162. $audit,
  163. $pay_type_name,
  164. $operdate,
  165. $v['desc'],
  166. $cdate,
  167. $card_code_card,
  168. );
  169. $body[] = $d;
  170. }
  171. $file = Dever::input('excel_name');
  172. return Dever::excelExport($body, $header, $file);
  173. }
  174. }