Order.php 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. use think\Exception;
  6. class Order extends Api
  7. {
  8. protected $noNeedLogin = [];
  9. protected $noNeedRight = '*';
  10. protected $model = null;
  11. public function _initialize()
  12. {
  13. parent::_initialize();
  14. $this->model = Db::name('order');
  15. }
  16. /**
  17. * 列表
  18. * @return void
  19. */
  20. public function getList(){
  21. try {
  22. $status = input('status',0);//状态:1=待支付,2=待处理,3=已完成,4=已取消
  23. $where['user_id'] = $this->auth->id;
  24. if (!empty($status)) {
  25. $where['status'] = $status;
  26. }
  27. $o = 'order';
  28. $st = 'servicetype';
  29. $field = $o.'.id,orderno,server_info,server_images,status,user_mobile,'.$o.'.user_car_number,'.
  30. $o.'.createtime,cancel_time,cancel_reason,pay_fee,appen_fee,finish_time,'.$st.'.title as `service_title`,paytype';
  31. $result = $this->model->alias($o)->field($field)
  32. ->join($st,$st.'.id = '.$o.'.servicetype_id','LEFT')
  33. ->where($where)->order($o.'.createtime desc')->autopage()->select();
  34. if (!empty($result)) {
  35. $statusArr = [2=>'待处理',3=>'已完成',4=>'已取消'];
  36. $paytypeArr = [1=>'线下',2=>'余额',3=>'微信'];
  37. $timeArr = ['createtime','cancel_time','finish_time'];
  38. foreach ($result as $key => &$value) {
  39. foreach ($timeArr as $k => $v) {
  40. $value[$v] = !empty($value[$v]) ? date('Y年m月d日 H:i:s', $value[$v]) : '';
  41. }
  42. $value['total_amounts'] = bcadd($value['pay_fee'],$value['appen_fee'],2);
  43. $value['status_text'] = isset($statusArr[$value['status']]) ? $statusArr[$value['status']] : '';
  44. $value['paytype_text'] = isset($paytypeArr[$value['paytype']]) ? $paytypeArr[$value['paytype']] : '';
  45. }
  46. $result = list_domain_image($result,['server_images']);
  47. }
  48. $this->success('获取成功', $result);
  49. } catch (Exception $e) {
  50. $this->error($e->getMessage());
  51. }
  52. }
  53. /**
  54. * 详情
  55. * @return void
  56. */
  57. public function getInfo(){
  58. try {
  59. $id = input('id',0);
  60. $payOrderId = input('pay_order_id',0);
  61. if (!empty($payOrderId)) {
  62. $orderWhere['pay_order_id'] = $payOrderId;
  63. $order = Db::name('order')->field('id')->where($orderWhere)->find();
  64. $id = isset($order['id']) ? $order['id'] : 0;
  65. }
  66. $o = 'order';
  67. $st = 'servicetype';
  68. $where[$o.'.user_id'] = $this->auth->id;
  69. $where[$o.'.id'] = $id;
  70. $field = $o.'.id,orderno,server_info,server_images,status,user_mobile,'.$o.'.user_car_number,'.
  71. $o.'.createtime,cancel_time,cancel_reason,pay_fee,appen_fee,finish_time,'.$st.'.title as `service_title`,paytype';
  72. $result = $this->model->alias($o)->field($field)
  73. ->join($st,$st.'.id = '.$o.'.servicetype_id','LEFT')
  74. ->where($where)->find();
  75. if (!empty($result)) {
  76. $statusArr = [2=>'待处理',3=>'已完成',4=>'已取消'];
  77. $paytypeArr = [1=>'线下',2=>'余额',3=>'微信'];
  78. $timeArr = ['createtime','cancel_time','finish_time'];
  79. foreach ($timeArr as $k => $v) {
  80. $result[$v] = !empty($result[$v]) ? date('Y年m月d日 H:i:s', $result[$v]) : '';
  81. }
  82. $result['total_amounts'] = bcadd($result['pay_fee'],$result['appen_fee'],2);
  83. $result['status_text'] = isset($statusArr[$result['status']]) ? $statusArr[$result['status']] : '';
  84. $result['paytype_text'] = isset($paytypeArr[$result['paytype']]) ? $paytypeArr[$result['paytype']] : '';
  85. $orderAppenWhere['order_id'] = $id;
  86. $orderAppen = Db::name('order_appen')->where($orderAppenWhere)->select();
  87. $appenList = [];
  88. if (!empty($orderAppen)) {
  89. foreach ($orderAppen as $key => $value) {
  90. $appenList[] = [
  91. 'name' => $value['name'],
  92. 'price' => $value['price'],
  93. ];
  94. }
  95. }
  96. $result['appen_list'] = $appenList;
  97. $result = info_domain_image($result,['server_images']);
  98. }
  99. $this->success('获取成功', $result);
  100. } catch (Exception $e) {
  101. $this->error($e->getMessage());
  102. }
  103. }
  104. /**
  105. * 核销码
  106. * @return void
  107. */
  108. public function writeOff()
  109. {
  110. try {
  111. $id = $this->request->param('id',0);
  112. $payOrderId = input('pay_order_id',0);
  113. if (!empty($payOrderId)) {
  114. $orderWhere['pay_order_id'] = $payOrderId;
  115. $order = Db::name('order')->field('id')->where($orderWhere)->find();
  116. $id = isset($order['id']) ? $order['id'] : 0;
  117. }
  118. $companyId = $this->auth->company_id;
  119. $userId = $this->auth->id;
  120. $where['id'] = $id;
  121. $where['company_id'] = $companyId;
  122. $where['user_id'] = $userId;
  123. $where['status'] = 2;
  124. $modelData = $this->model->where($where)->find();
  125. if (empty($modelData)) {
  126. throw new Exception('未找到相关信息');
  127. }
  128. $text = 'hexiaoorder_'.$id;
  129. $logo = '';
  130. $filRoute = '/uploads/temp/';
  131. $saveDir = ROOT_PATH.'public/uploads/temp'.DS;
  132. $fileStr = md5('order_'.$id);
  133. $localpng = $saveDir.$fileStr.'.png';
  134. //验证存在直接返回
  135. $userCouponsUrl = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST'].$filRoute.$fileStr.'.png';
  136. if (!file_exists($localpng)) {
  137. build_qrcode($text, $logo, $saveDir,$fileStr);
  138. }
  139. $result = [
  140. 'url' => $userCouponsUrl,
  141. ];
  142. $this->success('获取成功',$result);
  143. } catch (Exception $e) {
  144. $this->error($e->getMessage());
  145. }
  146. }
  147. /**
  148. * 保养列表
  149. * @return void
  150. */
  151. public function upkeepList()
  152. {
  153. try {
  154. $serviceTypeId = input('servicetype_id',0);
  155. $carId = input('car_id',0);
  156. $carNumber = input('car_number','');
  157. $o = 'order';
  158. $st = 'servicetype';
  159. if (!empty($serviceTypeId)) {
  160. $where[$o.'.servicetype_id'] = $serviceTypeId;
  161. }
  162. if (!empty($carId)) {
  163. $where[$o.'.user_car_id'] = $carId;
  164. }
  165. if (empty($carNumber)) {
  166. $where[$o.'.user_car_number'] = $carNumber;
  167. }
  168. $where[$o.'.user_id'] = $this->auth->id;
  169. $where[$o.'.status'] = ['in',[2,3]];//状态:2=待处理,3=已完成,4=已取消
  170. $where[$st.'.baoyang_switch'] = 1;//弹出保养时间:1=是,0=否
  171. $field = $o.'.id,servicetype_id,server_info,finish_time,next_date,next_carlicheng,pay_fee,appen_fee,'.$st.'.title as `service_title`';
  172. $result = $this->model->alias($o)->field($field)
  173. ->join($st,$st.'.id = '.$o.'.servicetype_id','LEFT')
  174. ->where($where)->order($o.'.finish_time desc')->autopage()->select();
  175. if (!empty($result)) {
  176. $timeArr = ['finish_time'];
  177. foreach ($result as $key => &$value) {
  178. foreach ($timeArr as $k => $v) {
  179. $value[$v] = !empty($value[$v]) ? date('Y-m-d', $value[$v]) : '';
  180. }
  181. $value['total_amounts'] = bcadd($value['pay_fee'],$value['appen_fee'],2);
  182. }
  183. }
  184. $this->success('获取成功',$result);
  185. } catch (Exception $e) {
  186. $this->error($e->getMessage());
  187. }
  188. }
  189. }