Order.php 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411
  1. <?php
  2. namespace Factory\Admin;
  3. use Dever;
  4. class Order extends Core
  5. {
  6. # 获取概览数据
  7. public function getData()
  8. {
  9. # 待处理订单
  10. $where['status'] = 3;
  11. $where['source_type'] = 3;
  12. $where['source_id'] = $this->id;
  13. # 待处理订单
  14. $data['order_num'] = Dever::db('shop/buy_order')->getOrderNum($where);
  15. # 超时待处理订单:72小时
  16. $where['end_o'] = time() - 72*3600;
  17. $data['cs_order_num'] = Dever::db('shop/buy_order')->getOrderNum($where);
  18. return $data;
  19. }
  20. # 订单列表
  21. public function getList()
  22. {
  23. $data = Dever::load('mshop/lib/buy')->set(13, 1)->getList($this->id);
  24. $html = '';
  25. if ($data && $data['order']) {
  26. $out_status = Dever::db('shop/buy_order')->config['out_status'];
  27. $excel = Dever::input('excel', 1);
  28. if ($excel == 2) {
  29. Dever::load('factory/admin/excel')->out($this->id, $this->user, $data['order']);
  30. die;
  31. return;
  32. }
  33. foreach ($data['order'] as $k => $v) {
  34. if ($v['ps_info']) {
  35. $ps_date = $v['ps_info']['cdate'];
  36. } else {
  37. $ps_date = '-';
  38. }
  39. $view = Dever::url('order_view?type=2&order_id=' . $v['id'] . '&cash=2', 'factory');
  40. $send = Dever::url('order_send?id=' . $v['id'], 'factory');
  41. $button = '<a href="'.$view.'"><button type="button" class="btn btn-info btn-rounded waves-effect waves-light m-b-5 layui-btn layui-btn-xs">查看详情</button></a>';
  42. if ($v['status'] < 5) {
  43. $print = Dever::url('admin/order.print?id=' . $v['id'] . '&type=1', 'factory');
  44. $button .= '&nbsp;&nbsp;<a href="'.$print.'" id="print_'.$v['id'].'" target="_blank"><button type="button" class="btn btn-info btn-rounded waves-effect waves-light m-b-5 layui-btn layui-btn-xs">打印备货单</button></a>';
  45. }
  46. if ($v['status'] == 3) {
  47. $button .= '&nbsp;&nbsp;<a href="javascript:;" id="send_'.$v['id'].'" onclick="fastEdit($(this), \''.$send.'\', \'配送发货\', \'\', 1)"><button type="button" class="btn btn-info btn-rounded waves-effect waves-light m-b-5 layui-btn layui-btn-xs">配送发货</button></a>';
  48. }
  49. if ($v['refund_status'] == 2 && $v['status'] != 8) {
  50. $v['status_name'] .= '[缺货报损中]';
  51. }
  52. $order = array();
  53. if ($v['parent_type'] == 2) {
  54. $order = Dever::db('shop/sell_order')->find($v['parent_order_id']);
  55. if ($order && $order['uid']) {
  56. if ($order['address_id']) {
  57. $order['address'] = Dever::load('passport/address')->getOne($order['uid'], $order['address_id']);
  58. if ($order['address']) {
  59. $v['type_info']['name'] = $order['address']['contact'];
  60. } else {
  61. $user = Dever::db('passport/user')->find($order['uid']);
  62. $v['type_info']['name'] = $user['username'];
  63. }
  64. } else {
  65. $user = Dever::db('passport/user')->find($order['uid']);
  66. $v['type_info']['name'] = $user['username'];
  67. }
  68. }
  69. } elseif ($v['parent_type'] == 3) {
  70. $order = Dever::db('agent/dh_order')->find($v['parent_order_id']);
  71. if ($order && $order['mid']) {
  72. if ($order['address_id']) {
  73. $order['address'] = Dever::load('agent/address')->getOne($order['mid'], $order['address_id']);
  74. $v['type_info']['name'] = $order['address']['contact'];
  75. } else {
  76. $user = Dever::db('agent/member')->find($order['mid']);
  77. $v['type_info']['name'] = $user['name'];
  78. }
  79. }
  80. }
  81. $v['out_status_name'] = $out_status[$v['source_out_status']];
  82. $dao_date = '-';
  83. if ($v['source_out_date']) {
  84. $dao_date = date('Y-m-d H:i', $v['source_out_date']);
  85. }
  86. $html .= '<tr><td>'.$v['order_num'].'</td><td>'.$v['operdate'].'</td><td>'.$v['type_info']['name'].'</td><td>'.$ps_date.'</td><td>'.$v['p_price'].'</td><td>'.$v['status_name'].'</td><td>'.$v['out_status_name'].'</td><td>'.$dao_date.'</td><td>'.$button.'</td></tr>';
  87. }
  88. }
  89. return $html;
  90. }
  91. # 获取列表页搜索信息
  92. public function getSearch()
  93. {
  94. $config = array
  95. (
  96. array('value' => '0', 'name' => '全部'),
  97. array('value' => 3, 'name' => '待生产发货'),
  98. array('value' => 4, 'name' => '已发货'),
  99. array('value' => '5,6', 'name' => '已到货'),
  100. array('value' => '7,8,11', 'name' => '已取消'),
  101. array('value' => 'refund', 'name' => '缺货与报损'),
  102. );
  103. $status = Dever::input('status');
  104. $html = '';
  105. foreach ($config as $k => $v) {
  106. $selected = '';
  107. if ((!$status && $k == 0) || $status == $v['value']) {
  108. $selected = 'selected=""';
  109. }
  110. $html .= '<option value="'.$v['value'].'" '.$selected.'>'.$v['name'].'</option>';
  111. }
  112. return $html;
  113. }
  114. # 获取列表页搜索信息
  115. public function getSearchOutStatus()
  116. {
  117. $config = array
  118. (
  119. array('value' => '0', 'name' => '全部'),
  120. array('value' => 1, 'name' => '未导出'),
  121. array('value' => 2, 'name' => '已导出'),
  122. );
  123. $status = Dever::input('source_out_status');
  124. $html = '';
  125. foreach ($config as $k => $v) {
  126. $selected = '';
  127. if ((!$status && $k == 0) || $status == $v['value']) {
  128. $selected = 'selected=""';
  129. }
  130. $html .= '<option value="'.$v['value'].'" '.$selected.'>'.$v['name'].'</option>';
  131. }
  132. return $html;
  133. }
  134. # 获取列表页搜索信息
  135. public function getService()
  136. {
  137. $service = Dever::db('shop/service')->select();
  138. $html = '';
  139. foreach ($service as $k => $v) {
  140. $selected = '';
  141. if ($k == 0) {
  142. $selected = 'selected=""';
  143. }
  144. $html .= '<option value="'.$v['id'].'" '.$selected.'>'.$v['name'].'</option>';
  145. }
  146. return $html;
  147. }
  148. # 获取基本信息
  149. public function getConfig()
  150. {
  151. $data['search'] = Dever::url('order', 'factory');
  152. # 发货
  153. $data['send'] = Dever::url('admin/order.send', 'factory');
  154. # 退款
  155. $data['tui'] = Dever::url('lib/buy.refund_apply_info_one_commit?json=1', 'mshop');
  156. # 导入物流单号
  157. $data['import'] = Dever::load('upload/import.url', 'factory/admin/order.import', 10);
  158. return $data;
  159. }
  160. # 导入物流单号
  161. public function import($file)
  162. {
  163. $file = Dever::local($file);
  164. $data = Dever::excelImport($file, 0);
  165. if ($data) {
  166. $psinfo = array();
  167. foreach ($data as $k => $v) {
  168. if ($k >= 2) {
  169. $order_num = $v['A'];
  170. if ($order_num) {
  171. $order = Dever::db('shop/buy_order')->find(array('order_num' => $order_num));
  172. if ($order && $order['status'] == 3) {
  173. if (!isset($psinfo[$order['id']])) {
  174. $psinfo[$order['id']] = array();
  175. }
  176. $psinfo[$order['id']][] = array($v['B'], $v['C'], $v['D']);
  177. }
  178. }
  179. }
  180. }
  181. if ($psinfo) {
  182. foreach ($psinfo as $k => $v) {
  183. $update = array();
  184. $update['order_id'] = $k;
  185. $service = array();
  186. foreach ($v as $k1 => $v1) {
  187. if ($v1[2] && strstr($v1[2], '-')) {
  188. $update['cdate'] = Dever::maketime($v1[2]);
  189. } else {
  190. $update['cdate'] = time();
  191. }
  192. $service_info = Dever::db('shop/service')->find($v1[1]);
  193. if (!$service_info) {
  194. $service_id = Dever::db('shop/service')->insert(array('name' => $v1[1], 'type' => 1));
  195. } else {
  196. $service_id = $service_info['id'];
  197. }
  198. $service[] = array
  199. (
  200. 'order' => $k1,
  201. 'service_id' => $service_id,
  202. 'order_num' => $v1[0],
  203. );
  204. }
  205. if ($service) {
  206. $update['service'] = $service;
  207. }
  208. $this->send_action($update);
  209. }
  210. }
  211. }
  212. }
  213. # 发货
  214. public function send_api()
  215. {
  216. $input = Dever::input();
  217. $service = array();
  218. $order_id = Dever::input('update_where_id');
  219. foreach ($input as $k => $v) {
  220. if (strpos($k, '_c_') !== false) {
  221. if ($v == 'null') {
  222. $v = '';
  223. }
  224. $temp = explode('_c_', $k);
  225. $k = str_replace('update_', '', $temp[0]);
  226. if (!isset($c[$k])) {
  227. $c[$k] = array();
  228. }
  229. if (strpos($temp[1], '_i_') !== false) {
  230. $temp = explode('_i_', $temp[1]);
  231. if (!isset($c[$k][$temp[1]])) {
  232. $c[$k][$temp[1]] = 0;
  233. } else {
  234. $c[$k][$temp[1]]++;
  235. }
  236. $num = $c[$k][$temp[1]];
  237. $service[$k][$num][$temp[1]] = $v;
  238. }
  239. }
  240. }
  241. $update = array();
  242. $update['order_id'] = $order_id;
  243. if ($service) {
  244. $update['service'] = $service;
  245. }
  246. $update['cdate'] = $input['update_cdate'];
  247. /*
  248. $update['service_id'] = $input['update_service_id'];
  249. $update['order_num'] = $input['update_order_num'];
  250. $update['num'] = $input['update_num'];
  251. $update['phy'] = $input['update_phy'];
  252. $update['dby'] = $input['update_dby'];
  253. $update['zl'] = $input['update_zl'];
  254. $update['tj'] = $input['update_tj'];
  255. $update['price'] = $input['update_price'];
  256. */
  257. return $this->send_action($update);
  258. }
  259. private function send_action($update = array())
  260. {
  261. $info = Dever::db('shop/buy_order_ps')->find(array('order_id' => $update['order_id']));
  262. if (isset($update['service'])) {
  263. $update['service'] = Dever::array_encode($update['service']);
  264. }
  265. if ($info) {
  266. $update['where_id'] = $info['id'];
  267. Dever::db('shop/buy_order_ps')->update($update);
  268. } else {
  269. Dever::db('shop/buy_order_ps')->insert($update);
  270. }
  271. Dever::db('shop/buy_order')->update(array('status' => 4, 'where_id' => $update['order_id']));
  272. # 检测是否是关联订单
  273. $order = Dever::db('shop/buy_order')->find($update['order_id']);
  274. if ($order && $order['parent_type'] > 1) {
  275. $data = Dever::db('shop/buy_order')->find(array('status' => 3, 'parent_type' => $order['parent_type'], 'parent_order_id' => $order['parent_order_id']));
  276. if (!$data) {
  277. # 更改关联订单状态
  278. if ($order['parent_type'] == 2) {
  279. Dever::db('shop/sell_order')->update(array('where_id' => $order['parent_order_id'], 'status' => 4));
  280. $data = Dever::db('shop/buy_order')->getDataToId(array('parent_type' => $order['parent_type'], 'parent_order_id' => $order['parent_order_id']));
  281. $data = array_keys($data);
  282. $ps_info = Dever::db('shop/buy_order_ps')->getData(array('order_id' => $data));
  283. if ($ps_info) {
  284. $sell_order = array('id' => $order['parent_order_id']);
  285. foreach ($ps_info as $k => $v) {
  286. $v['service'] = Dever::array_decode($v['service']);
  287. foreach ($v['service'] as $k1 => $v1) {
  288. if (isset($v1['order_num']) && $v1['order_num']) {
  289. Dever::load('shop/lib/sell')->updatePs($sell_order, 2, $v1['service_id'], $v1['order_num']);
  290. }
  291. }
  292. }
  293. }
  294. } elseif ($order['parent_type'] == 3) {
  295. Dever::db('agent/dh_order')->update(array('where_id' => $order['parent_order_id'], 'status' => 4));
  296. $data = Dever::db('shop/buy_order')->getDataToId(array('parent_type' => $order['parent_type'], 'parent_order_id' => $order['parent_order_id']));
  297. $data = array_keys($data);
  298. $ps_info = Dever::db('shop/buy_order_ps')->getData(array('order_id' => $data));
  299. if ($ps_info) {
  300. $dh_order = array('id' => $order['parent_order_id']);
  301. foreach ($ps_info as $k => $v) {
  302. $v['service'] = Dever::array_decode($v['service']);
  303. foreach ($v['service'] as $k1 => $v1) {
  304. if (isset($v1['order_num']) && $v1['order_num']) {
  305. Dever::load('agent/lib/dhorder')->updatePs($dh_order, 2, $v1['service_id'], $v1['order_num']);
  306. }
  307. }
  308. }
  309. }
  310. }
  311. }
  312. }
  313. # 给仓库发消息
  314. if (Dever::project('message') && $order && $order['type'] == 2) {
  315. $msg_param['type'] = 3;//消息头类型3是入库订单消息
  316. $msg_param['id'] = $order['id'];
  317. $msg_param = Dever::json_encode($msg_param);
  318. $msg = '您有新的入库订货单已发货,请及时查收后确认。';
  319. Dever::load('message/lib/data')->push(-1, $order['type_id'], '入库订货单通知', $msg, 7, 3, false, $msg_param);
  320. }
  321. return 'reload';
  322. }
  323. # 打印订单单
  324. public function print_api()
  325. {
  326. return Dever::load('mshop/lib/buy')->printer($this->user);
  327. }
  328. # 获取报损信息
  329. public function refund()
  330. {
  331. $data = Dever::load('mshop/lib/buy')->refund_apply_info_one_info();
  332. if (isset($data['tui_price'])) {
  333. $data['tui_price_info'] = '¥' . $data['tui_price'];
  334. } else {
  335. $data['tui_price_info'] = '¥0';
  336. }
  337. return $data;
  338. }
  339. }