Buy.php 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943
  1. <?php
  2. # 支付
  3. namespace Mshop\Lib;
  4. use Dever;
  5. class Buy
  6. {
  7. # 1是门店,2是仓库,3是工厂,1,2,3是查看采购人的订单,11,12,13是查看供货商的订单
  8. public $type = 1;
  9. # 1是列表,2是详情
  10. public $view = 1;
  11. # 获取配置
  12. public $config = array();
  13. # table
  14. public $table = 'shop/buy_order';
  15. public function __construct()
  16. {
  17. $this->config = Dever::db($this->table)->config;
  18. }
  19. # 设置订单的类型
  20. public function set($type, $view)
  21. {
  22. $this->type = $type;
  23. $this->view = $view;
  24. return $this;
  25. }
  26. # 获取公共的where
  27. public function where($id)
  28. {
  29. $where = array();
  30. if ($this->type > 10) {
  31. $type = $this->type - 10;
  32. $where['source_type'] = $type;
  33. $where['source_type_id'] = $id;
  34. } else {
  35. $where['type'] = $this->type;
  36. $where['type_id'] = $id;
  37. }
  38. if (!$where) {
  39. Dever::alert('参数错误');
  40. }
  41. return $where;
  42. }
  43. # 获取订单列表
  44. public function getList($id)
  45. {
  46. $result = array();
  47. $where = $this->where($id);
  48. $status = Dever::input('status');
  49. if ($status) {
  50. $where['status'] = $status;
  51. }
  52. $result['search_value'] = $where;
  53. $result['search_value']['day'] = $day = Dever::input('day');
  54. if ($day) {
  55. $where['start'] = Dever::maketime($day . ' 00:00:00');
  56. $where['end'] = Dever::maketime($day . ' 23:59:59');
  57. }
  58. $result['order'] = Dever::db($this->table)->getAll($where);
  59. if ($result['order']) {
  60. foreach ($result['order'] as $k => $v) {
  61. $result['order'][$k] = $this->getInfo($v);
  62. }
  63. }
  64. $result['search'] = array();
  65. $result['search']['status'] = array
  66. (
  67. array('value' => 1, 'name' => '待支付'),
  68. array('value' => 2, 'name' => '待审核'),
  69. array('value' => 3, 'name' => '待发货'),
  70. array('value' => 4, 'name' => '待收货确认'),
  71. array('value' => 5, 'name' => '已完成'),
  72. array('value' => 6, 'name' => '已完成(有退款)'),
  73. array('value' => '7,8,11', 'name' => '已取消'),
  74. );
  75. return $result;
  76. }
  77. # 查看详情
  78. public function getView($id, $order_id, $show = true)
  79. {
  80. $where = $this->where($id);
  81. $where['id'] = $order_id;
  82. $result = Dever::db($this->table)->find($where);
  83. if (!$result) {
  84. Dever::alert('订单不存在');
  85. }
  86. if ($show) {
  87. $result = $this->getInfo($result, true);
  88. }
  89. return $result;
  90. }
  91. # 查看退款详情
  92. public function getRefund($id, $order_id)
  93. {
  94. $data = $this->getView($id, $order_id, false);
  95. $data['refund'] = Dever::db('shop/buy_order_refund')->select(array('order_id' => $info['id']));
  96. return $data;
  97. }
  98. # 获取订单详细信息
  99. public function getInfo($info, $view = false)
  100. {
  101. if ($info['status'] == 1) {
  102. # 15分钟内支付,900秒
  103. $m = 9000;
  104. # 支付倒计时
  105. $info['time'] = time() - $info['cdate'];
  106. if ($info['time'] >= $m) {
  107. # 已过期,自动取消
  108. $info['time'] = -1;
  109. Dever::db($this->table)->update(array('where_id' => $info['id'], 'status' => 11));
  110. $info['status'] = 11;
  111. } else {
  112. $info['time'] = $m - $info['time'];
  113. }
  114. }
  115. $info['status_name'] = $this->config['status'][$info['status']];
  116. $info['goods'] = Dever::db('shop/buy_order_goods')->select(array('order_id' => $info['id']));
  117. if ($info['type'] == 1) {
  118. $info['type_info'] = Dever::db('shop/info')->getOne($info['type_id']);
  119. } elseif ($info['type'] == 2) {
  120. $info['type_info'] = Dever::db('store/info')->find($info['type_id']);
  121. } elseif ($info['type'] == 3) {
  122. $info['type_info'] = Dever::db('factory/info')->find($info['type_id']);
  123. }
  124. if ($info['source_type'] == 1) {
  125. $info['source_info'] = Dever::db('shop/info')->getOne($info['source_id']);
  126. } elseif ($info['source_type'] == 2) {
  127. $info['source_info'] = Dever::db('store/info')->find($info['source_id']);
  128. } elseif ($info['source_type'] == 3) {
  129. $info['source_info'] = Dever::db('factory/info')->find($info['source_id']);
  130. }
  131. $info['cdate'] = date('Y-m-d H:i', $info['cdate']);
  132. if ($info['operdate']) {
  133. $info['operdate'] = date('Y-m-d H:i', $info['operdate']);
  134. }
  135. $goods_status = Dever::db('shop/buy_order_goods')->config['status'];
  136. $goods_process = Dever::db('shop/buy_order_refund')->config['process'];
  137. if ($view || $this->view == 2) {
  138. foreach ($info['goods'] as $k => $v) {
  139. $info['goods'][$k]['info'] = Dever::load('goods/lib/info')->getPayInfo($v['goods_id'], $v['sku_id']);
  140. $info['goods'][$k]['status_name'] = $goods_status[$v['status']];
  141. }
  142. } else {
  143. foreach ($info['goods'] as $k => $v) {
  144. $goods = Dever::db('goods/info')->one($v['goods_id']);
  145. $info['goods'][$k]['name'] = $goods['name'];
  146. $info['goods'][$k]['cover'] = $goods['cover'];
  147. $info['goods'][$k]['status_name'] = $goods_status[$v['status']];
  148. }
  149. }
  150. if (!$info['refund_cash']) {
  151. $info['refund_cash'] = 0;
  152. }
  153. # 配送信息
  154. $info['ps_info'] = Dever::db('shop/buy_order_ps')->find(array('order_id' => $info['id']));
  155. if ($info['ps_info']) {
  156. $info['ps_info']['service_name'] = '商家自送';
  157. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  158. if ($info['ps_info']['ydate']) {
  159. $info['ps_info']['ydate'] = date('Y-m-d H:i', $info['ps_info']['ydate']);
  160. }
  161. $status = Dever::db('shop/buy_order_ps')->config['status'];
  162. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  163. if ($info['ps_info']['service_id'] > 0) {
  164. //暂时还没有
  165. $service = Dever::db('shop/service')->find($info['ps_info']['service_id']);
  166. $info['ps_info']['service_name'] = $service['name'];
  167. }
  168. }
  169. return $info;
  170. }
  171. # 发起支付
  172. public function action($type, $type_id, $name, $num, $goods, $price, $info, $refer = '')
  173. {
  174. $order_data['type'] = $type;
  175. $order_data['type_id'] = $type_id;
  176. $order_data['name'] = $name;
  177. $order_data['num'] = $num;
  178. $order_data['info'] = $info;
  179. $order_data['price'] = $price;
  180. $order_data['order_num'] = $this->getOrderId();
  181. $id = Dever::db('shop/buy_order')->insert($order_data);
  182. if (!$id) {
  183. Dever::alert('支付失败');
  184. }
  185. foreach($goods as $k => $v) {
  186. $data['order_id'] = $id;
  187. $data['goods_id'] = $v['id'];
  188. $data['sku_id'] = $v['sku_id'];
  189. $data['price'] = $v['price'] * $v['buy_num'];
  190. $data['num'] = $v['buy_num'];
  191. Dever::db('shop/buy_order_goods')->insert($data);
  192. }
  193. if ($price <= 0) {
  194. $param['pay_product_id'] = $id;
  195. $param['pay_order_id'] = $order_data['order_num'];
  196. $param['pay_status'] = 2;
  197. $param['pay_cash'] = $price;
  198. $param['pay_msg'] = '';
  199. $this->success($param);
  200. return array
  201. (
  202. 'order' => '',
  203. 'order_num' => $order_data['order_num'],
  204. 'order_id' => $id,
  205. 'type' => 'pay',
  206. );
  207. }
  208. $param = array
  209. (
  210. 'project_id' => 2,
  211. 'channel_id' => 1,
  212. 'system_source' => 5,
  213. 'uid' => -1,
  214. 'name' => $order_data['name'],
  215. 'cash' => $price,
  216. 'product_id' => $id,
  217. 'order_id' => $order_data['order_num'],
  218. 'refer' => $refer,
  219. );
  220. $receipt = Dever::input('receipt');
  221. if ($receipt) {
  222. $param['receipt'] = $receipt;
  223. }
  224. //$result = Dever::load('pay/api.pay', $param);
  225. $result['type'] = 'test';
  226. $result['order'] = '';
  227. $result['order_num'] = $order_data['order_num'];
  228. $result['order_id'] = $id;
  229. return $result;
  230. }
  231. # 再次发起支付
  232. public function raction($id, $refer = '')
  233. {
  234. $order = Dever::db('shop/buy_order')->find($id);
  235. if (!$order) {
  236. Dever::alert('订单信息错误');
  237. }
  238. if ($order['status'] > 1) {
  239. Dever::alert('订单已支付或已取消');
  240. }
  241. $param = array
  242. (
  243. 'project_id' => 2,
  244. 'channel_id' => 1,
  245. 'system_source' => 5,
  246. 'uid' => -1,
  247. 'name' => $order['name'],
  248. 'cash' => $order['price'],
  249. 'product_id' => $id,
  250. 'order_id' => $order['order_num'],
  251. 'refer' => $refer,
  252. );
  253. $receipt = Dever::input('receipt');
  254. if ($receipt) {
  255. $param['receipt'] = $receipt;
  256. }
  257. $result = Dever::load('pay/api.pay', $param);
  258. $result['order_num'] = $order['order_num'];
  259. $result['order_id'] = $id;
  260. return $result;
  261. }
  262. # 支付成功回调 安全加密 设置token
  263. public function success_secure_api_token()
  264. {
  265. $project_id = Dever::input('pay_project_id');
  266. $info = Dever::db('pay/project')->one($project_id);
  267. if ($info) {
  268. return $info['key'];
  269. }
  270. return 'shop_buy_dever_2020';
  271. }
  272. # 支付成功回调 安全加密
  273. public function success_secure_api($param = array())
  274. {
  275. $this->success($param);
  276. }
  277. # 支付成功回调
  278. public function success($param = array())
  279. {
  280. $send = $param ? $param : Dever::preInput('pay_');
  281. $product_id = $send['pay_product_id'];
  282. $order_id = $send['pay_order_id'];
  283. $status = $send['pay_status'];
  284. $cash = $send['pay_cash'];
  285. $msg = $send['pay_msg'];
  286. $order = Dever::db('shop/buy_order')->one(array('id' => $product_id, 'time' => time()));
  287. if ($order && $order['status'] == 1) {
  288. if ($status == 2) {
  289. }
  290. $update['status'] = 2;
  291. $update['where_id'] = $order['id'];
  292. Dever::db('shop/buy_order')->update($update);
  293. }
  294. return 'ok';
  295. }
  296. # 生成订单号
  297. public function getOrderId()
  298. {
  299. $where['order_num'] = Dever::order('C');
  300. $state = Dever::db('shop/buy_order')->one($where);
  301. if (!$state) {
  302. return $where['order_num'];
  303. } else {
  304. return $this->getOrderId();
  305. }
  306. }
  307. # 添加配送信息
  308. public function updatePs($order, $status = 1)
  309. {
  310. $where['order_id'] = $order['id'];
  311. $data = Dever::db('shop/buy_order_ps')->find($where);
  312. if ($data) {
  313. $update['where_id'] = $data['id'];
  314. $update['status'] = $status;
  315. $update['ydate'] = time();
  316. Dever::db('shop/buy_order_ps')->update($update);
  317. }
  318. }
  319. # 确认收货
  320. public function finish($id, $order_id)
  321. {
  322. $data = $this->getView($id, $order_id, false);
  323. if ($data['status'] <= 4) {
  324. if ($data['refund_cash'] > 0) {
  325. $status = 6;
  326. } else {
  327. $status = 5;
  328. }
  329. $state = Dever::db('shop/buy_order')->update(array('where_id' => $data['id'], 'status' => $status));
  330. if ($state) {
  331. $this->updatePs($data, 3);
  332. # 增加库存
  333. $where['order_id'] = $data['id'];
  334. $where['status'] = 1;
  335. $goods = Dever::db('shop/buy_order_goods')->select($where);
  336. if ($goods) {
  337. Dever::load('shop/lib/goods')->oper($data, 1, 1, $goods);
  338. }
  339. }
  340. return 'ok';
  341. } else {
  342. Dever::alert('您没有权限');
  343. }
  344. }
  345. # 取消订单
  346. public function cancel($id, $order_id)
  347. {
  348. $data = $this->getView($id, $order_id, false);
  349. if ($data['status'] == 1) {
  350. $state = Dever::db('shop/buy_order')->update(array('where_id' => $data['id'], 'status' => 7, 'operdate' => time()));
  351. return 'ok';
  352. } else {
  353. Dever::alert('当前订单状态不允许取消');
  354. }
  355. }
  356. # 查看订单状态
  357. public function orderStatus($id)
  358. {
  359. $config = Dever::db('shop/buy_order')->config;
  360. $info = Dever::db('shop/buy_order')->one($id);
  361. $tk = Dever::db('shop/buy_order_refund')->find(array('order_id' => $info['id'], 'process' => 1));
  362. $status = $config['status'][$info['status']];
  363. if ($tk) {
  364. $status = '申请退款中';
  365. }
  366. return $status;
  367. }
  368. # 后台审核退款
  369. public function refund_api()
  370. {
  371. $id = Dever::input('id');
  372. $process = Dever::input('process');
  373. return Dever::load('shop/lib/refund')->set('buy')->action($id, $process, false);
  374. }
  375. # 展示订单详情
  376. public function show()
  377. {
  378. $id = Dever::input('order_id');
  379. $config = Dever::db('shop/buy_order')->config;
  380. $info = Dever::db('shop/buy_order')->one($id);
  381. $tk_status = Dever::db('shop/buy_order_refund')->config['status'];
  382. $tk_process = Dever::db('shop/buy_order_refund')->config['process'];
  383. $status = $config['status'][$info['status']];
  384. $tk = Dever::db('shop/buy_order_refund')->find(array('order_id' => $info['id'], 'type' => 1));
  385. $html = '[基本信息]:<table class="layui-table"><thead><tr><th style="width:20%">项目</th><th style="width:80%">详情</th></tr> </thead><tbody>';
  386. $html .= '<tr>
  387. <td>订单号</td>
  388. <td>'.$this->table(false, array(array($info['order_num']))).'</td>
  389. </tr>';
  390. if ($info['type'] == 1) {
  391. $type_info = Dever::db('shop/info')->find($info['type_id']);
  392. $html .= '<tr>
  393. <td>门店信息</td>
  394. <td>'.$this->table(false, array(array('门店名称:' . $type_info['name'], '联系人:' . $type_info['truename'], '联系电话:' . $type_info['mobile']))).'</td>
  395. </tr>';
  396. } elseif ($info['type'] == 2) {
  397. $type_info = Dever::db('store/info')->find($info['type_id']);
  398. $html .= '<tr>
  399. <td>仓库信息</td>
  400. <td>'.$this->table(false, array(array('仓库名称:' . $type_info['name'], '联系人:' . $type_info['truename'], '联系电话:' . $type_info['mobile']))).'</td>
  401. </tr>';
  402. } elseif ($info['type'] == 3) {
  403. $type_info = Dever::db('store/info')->find($info['type_id']);
  404. $html .= '<tr>
  405. <td>工厂信息</td>
  406. <td>'.$this->table(false, array(array('工厂名称:' . $type_info['name'], '联系人:' . $type_info['truename'], '联系电话:' . $type_info['mobile']))).'</td>
  407. </tr>';
  408. }
  409. if ($info['source_id'] > 0) {
  410. if ($info['source_type'] == 2) {
  411. # 仓库
  412. $store = Dever::db('store/info')->find($info['source_id']);
  413. $html .= '<tr>
  414. <td>供应商信息</td>
  415. <td>'.$this->table(false, array(array('仓库名称:' . $store['name'], '联系人:' . $store['truename'], '联系电话:' . $store['mobile']))).'</td>
  416. </tr>';
  417. } elseif ($info['source_type'] == 3) {
  418. # 工厂
  419. $factory = Dever::db('factory/info')->find($info['source_id']);
  420. $html .= '<tr>
  421. <td>供应商信息</td>
  422. <td>'.$this->table(false, array(array('工厂名称:' . $factory['name'], '联系人:' . $factory['truename'], '联系电话:' . $factory['mobile']))).'</td>
  423. </tr>';
  424. }
  425. }
  426. if ($info['info']) {
  427. $html .= '<tr>
  428. <td>订单备注</td>
  429. <td>'.$this->table(false, array(array($info['info']))).'</td>
  430. </tr>';
  431. }
  432. $url = Dever::url('lib/buy.refund', 'mshop');
  433. if (!$info['refund_cash']) {
  434. $info['refund_cash'] = 0;
  435. }
  436. if ($info['refund_cash'] > 0) {
  437. if ($tk) {
  438. $process = $tk_process[$tk['process']];
  439. $process = '';
  440. if ($tk['process'] == 1) {
  441. $status = '申请' . $tk_status[$tk['status']];
  442. $process .= '&nbsp;&nbsp;<a href="javascript:;" onclick="audit('.$tk['id'].', 2, \''.$url.'\')" class="layui-btn">通过</a><a href="javascript:;" onclick="audit('.$tk['id'].', 3, \''.$url.'\')" class="layui-btn layui-btn-danger">驳回</a>';
  443. }
  444. $desc = array();
  445. $desc['原因'] = $tk['desc'];
  446. if ($tk['pic']) {
  447. $desc['图片'] = '';
  448. $pic = explode(',', $tk['pic']);
  449. foreach ($pic as $k => $v) {
  450. $desc['图片'] .= '<a href="'.$v.'" target="_blank"><img src="'.$v.'" width="100"/></a>';
  451. }
  452. }
  453. $tk['desc'] = '<a href="javascript:layer.alert($(\'#desc_content\').html());">查看</a><span id="desc_content" style="display:none">'.Dever::table($desc).'</span>';
  454. }
  455. $html .= '<tr>
  456. <td>订单信息</td>
  457. <td>'.$this->table(array('金额', '数量', '订单状态', '退款金额', '退款原因', '退款审核'), array(array($info['price'], $info['num'], $status, $info['refund_cash'], $tk['desc'], $process))).'</td>
  458. </tr>';
  459. } else {
  460. $html .= '<tr>
  461. <td>订单信息</td>
  462. <td>'.$this->table(array('金额', '数量', '订单状态'), array(array($info['price'], $info['num'], $status))).'</td>
  463. </tr>';
  464. }
  465. $html .= '</tbody></table>';
  466. $info['ps_info'] = Dever::db('shop/buy_order_ps')->find(array('order_id' => $info['id']));
  467. if ($info['ps_info']) {
  468. $info['ps_info']['service_name'] = '商家自送';
  469. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  470. if ($info['ps_info']['ydate']) {
  471. $info['ps_info']['ydate'] = date('Y-m-d H:i', $info['ps_info']['ydate']);
  472. }
  473. $status = Dever::db('shop/buy_order_ps')->config['status'];
  474. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  475. if ($info['ps_info']['service_id'] > 0) {
  476. //暂时还没有
  477. $service = Dever::db('shop/service')->find($info['ps_info']['service_id']);
  478. $info['ps_info']['service_name'] = $service['name'];
  479. }
  480. $html .= '[配送信息]:';
  481. $head = array('名称', '单号', '费用', '数量', '重量', '体积', '配货员', '打包员', '状态');
  482. $body = array(array($info['ps_info']['service_name'], $info['ps_info']['order_num'], $info['ps_info']['price'], $info['ps_info']['num'], $info['ps_info']['zl'], $info['ps_info']['tj'], $info['ps_info']['phy'], $info['ps_info']['dby'], $info['ps_info']['status_name']));
  483. $html .= $this->table($head, $body);
  484. }
  485. $html .= '[商品清单]:';
  486. $head = array('名称', '属性', '价格', '数量', '状态');
  487. $body = array();
  488. $goods = Dever::db('shop/buy_order_goods')->select(array('order_id' => $info['id']));
  489. $goods_status = Dever::db('shop/buy_order_goods')->config['status'];
  490. foreach ($goods as $k => $v) {
  491. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  492. $status = $goods_status[$v['status']];
  493. $tk = Dever::db('shop/buy_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
  494. if ($tk && $tk['process'] == 1) {
  495. $status = '申请' . $tk_status[$tk['status']];
  496. $desc = array();
  497. $desc['原因'] = $tk['desc'];
  498. if ($tk['pic']) {
  499. $desc['图片'] = '';
  500. $pic = explode(',', $tk['pic']);
  501. foreach ($pic as $k => $v) {
  502. $desc['图片'] .= '<a href="'.$v.'" target="_blank"><img src="'.$v.'" width="100"/></a>';
  503. }
  504. }
  505. $status .= '&nbsp;&nbsp;<a href="javascript:layer.alert($(\'#desc_content\').html());">查看原因</a><span id="desc_content" style="display:none">'.Dever::table($desc).'</span>';
  506. if ($tk['process'] == 1) {
  507. $status .= '&nbsp;&nbsp;<a href="javascript:;" onclick="audit('.$tk['id'].', 2, \''.$url.'\')" class="layui-btn">通过</a><a href="javascript:;" onclick="audit('.$tk['id'].', 3, \''.$url.'\')" class="layui-btn layui-btn-danger">驳回</a>';
  508. }
  509. }
  510. if (isset($goods_info['sku'])) {
  511. $sku = $goods_info['sku']['string'];
  512. } else {
  513. $sku = '无';
  514. }
  515. $body[$k] = array
  516. (
  517. $goods_info['name'],
  518. $sku,
  519. $v['price'],
  520. $v['num'],
  521. $status,
  522. );
  523. }
  524. $html .= $this->table($head, $body);
  525. return $html;
  526. }
  527. private function table($head, $data)
  528. {
  529. $html = '';
  530. if ($head) {
  531. $html = '<table class="layui-table">';
  532. $html .= '<thead><tr>';
  533. foreach ($head as $k => $v) {
  534. $html .= '<th>'.$v.'</th>';
  535. }
  536. $html .= '</tr></thead>';
  537. $html .= '<tbody>';
  538. foreach ($data as $k => $v) {
  539. $html .= '<tr>';
  540. foreach ($v as $k1 => $v1) {
  541. $html .= '<td>'.$v1.'</td>';
  542. }
  543. $html .= '</tr>';
  544. }
  545. $html .= '</tbody>';
  546. $html .= '</table>';
  547. } else {
  548. foreach ($data as $k => $v) {
  549. $html .= '';
  550. foreach ($v as $k1 => $v1) {
  551. $html .= $v1 . '&nbsp;&nbsp;&nbsp;&nbsp;';
  552. }
  553. $html .= '';
  554. }
  555. }
  556. return $html;
  557. }
  558. # 发货
  559. /*
  560. public function send_commit()
  561. {
  562. $order_id = Dever::input('order_id');
  563. $order = Dever::db('shop/buy_order')->find($order_id);
  564. if (!$order || ($order && $order['status'] != 3)) {
  565. Dever::alert('当前订单状态无法发货');
  566. }
  567. $state = Dever::db('shop/buy_order')->update(array('where_id' => $order['id'], 'status' => 4));
  568. if ($state) {
  569. $this->updatePs($order, 1);
  570. }
  571. return 'reload';
  572. }*/
  573. # 采购订单审核 拆单
  574. public function audit_commit()
  575. {
  576. $order_id = Dever::input('order_id');
  577. $order = Dever::db('shop/buy_order')->find($order_id);
  578. if (!$order || ($order && $order['status'] != 2)) {
  579. Dever::alert('当前订单状态无法拆单');
  580. }
  581. if ($order['type'] != 1) {
  582. Dever::alert('这不是门店的订单');
  583. }
  584. $goods = Dever::db('shop/buy_order_goods')->select(array('order_id' => $order_id));
  585. $shop = Dever::db('shop/info')->find($order['type_id']);
  586. # 获取门店分配的仓库和工厂
  587. $shop_store = Dever::db('shop/store')->select(array('shop_id' => $shop['id']));
  588. $store = array();
  589. $distance = array();
  590. # 按照距离排序
  591. foreach ($shop_store as $k => $v) {
  592. $info = Dever::db('store/info')->find($v['store_id']);
  593. if ($info && $info['status'] == 1) {
  594. $distance[] = $info['distance'] = Dever::distance($shop['lng'], $shop['lat'], $info['lng'], $info['lat']);
  595. $store[] = $info;
  596. }
  597. }
  598. if (!$store) {
  599. Dever::alert('未分配仓库');
  600. }
  601. array_multisort($distance, SORT_ASC, SORT_NUMERIC, $store);
  602. $shop_factory = Dever::db('shop/factory')->select(array('shop_id' => $shop['id']));
  603. $factory = array();
  604. $distance = array();
  605. # 按照距离排序
  606. foreach ($shop_factory as $k => $v) {
  607. $info = Dever::db('factory/info')->find($v['factory_id']);
  608. if ($info && $info['status'] == 1) {
  609. $distance[] = $info['distance'] = Dever::distance($shop['lng'], $shop['lat'], $info['lng'], $info['lat']);
  610. $factory[] = $info;
  611. }
  612. }
  613. if (!$factory) {
  614. Dever::alert('未分配工厂');
  615. }
  616. array_multisort($distance, SORT_ASC, SORT_NUMERIC, $factory);
  617. $this->order_num = 0;
  618. foreach ($goods as $k => $v) {
  619. # 开始找仓库
  620. $find = $this->store($order['id'], $order['order_num'] . '_' . $this->order_num, $shop, $store, $v);
  621. if (!$find[1]) {
  622. # 仓库没有,找厂家
  623. if ($factory) {
  624. $find = $this->factory($order['id'], $order['order_num'] . '_' . $this->order_num, $shop, $factory, $v);
  625. }
  626. }
  627. }
  628. if ($this->order_num > 0) {
  629. if ($this->order_num == 1) {
  630. Dever::db('shop/buy_order')->update(array('where_id' => $order['id'], 'status' => 3, 'source_type' => $find[0], 'source_id' => implode('', $find[1])));
  631. Dever::db('shop/buy_order')->delete($find[2][0]);
  632. Dever::db('shop/buy_order_goods')->delete(array('order_id' => $find[2][0]));
  633. } else {
  634. Dever::db('shop/buy_order')->update(array('where_id' => $order['id'], 'state' => 2));
  635. }
  636. } else {
  637. # 没有找到,退款
  638. Dever::db('shop/buy_order')->update(array('where_id' => $order['id'], 'status' => 8));
  639. Dever::load('shop/lib/refund')->set('buy')->apply(2, $shop['id'], $order_id, false, 3, 0);
  640. }
  641. return 'ok';
  642. }
  643. private function store($order_id, $order_num, $shop, $store, $goods, $state = 2)
  644. {
  645. $find = array();
  646. $type_id = array();
  647. $id = array();
  648. if (!$store) {
  649. return array(2, $type_id, $id);
  650. }
  651. foreach ($store as $k => $v) {
  652. $where['store_id'] = $v['id'];
  653. $where['goods_id'] = $goods['goods_id'];
  654. $where['sku_id'] = ($goods['sku_id'] && $goods['sku_id'] > 0) ? $goods['sku_id'] : -1;
  655. $sku = Dever::db('store/goods_sku')->getOne($where);
  656. if ($sku) {
  657. if ($goods['num'] <= $sku['total']) {
  658. # 如果库存符合,直接下单即可,生成仓库订单
  659. $state = $this->createOrder($order_id, $order_num, 1, $shop['id'], 2, $where['store_id'], $goods['price'], $goods['num'], $where['goods_id'], $where['sku_id']);
  660. if ($state) {
  661. $type_id[] = $where['store_id'];
  662. $id[] = $state;
  663. break;
  664. }
  665. } elseif ($state == 1 && $sku['total'] > 0) {
  666. # 如果库存不够,从这个仓库扣下一部分,剩余的从另外仓库处理
  667. $goods['num'] = $goods['num'] - $sku['total'];
  668. # 生成仓库订单
  669. $state = $this->createOrder($order_id, $order_num, 1, $shop['id'], 2, $where['store_id'], $goods['price'], $sku['total'], $where['goods_id'], $where['sku_id']);
  670. if (!$state) {
  671. $goods['num'] = $goods['num'] + $sku['total'];
  672. } else {
  673. $type_id[] = $where['store_id'];
  674. $id[] = $state;
  675. }
  676. continue;
  677. } else {
  678. # 直接切换到下一个仓库处理
  679. continue;
  680. }
  681. }
  682. }
  683. return array(2, $type_id, $id);
  684. }
  685. private function factory($order_id, $order_num, $shop, $factory, $goods)
  686. {
  687. $find = array();
  688. $type_id = array();
  689. $id = array();
  690. if (!$factory) {
  691. return array(3, $type_id, $id);
  692. }
  693. foreach ($factory as $k => $v) {
  694. $where['factory_id'] = $v['id'];
  695. $where['goods_id'] = $goods['goods_id'];
  696. $where['sku_id'] = ($goods['sku_id'] && $goods['sku_id'] > 0) ? $goods['sku_id'] : -1;
  697. $sku = Dever::db('factory/goods_sku')->select($where);
  698. if ($sku) {
  699. $state = $this->createOrder($order_id, $order_num, 1, $shop['id'], 3, $where['factory_id'], $goods['price'], $goods['num'], $where['goods_id'], $where['sku_id']);
  700. if ($state) {
  701. $type_id[] = $where['factory_id'];
  702. $id[] = $state;
  703. break;
  704. }
  705. } else {
  706. continue;
  707. }
  708. }
  709. return array(3, $type_id, $id);
  710. }
  711. # 生成拆单的订单
  712. private function createOrder($order_id, $order_num, $type, $type_id, $source_type, $source_id, $price, $num, $goods_id, $sku_id)
  713. {
  714. $where['parent_order_id'] = $order_id;
  715. $where['type'] = $type;
  716. $where['type_id'] = $type_id;
  717. $where['source_type'] = $source_type;
  718. $where['source_id'] = $source_id;
  719. $where['r'] = $goods_id;
  720. $info = Dever::db('shop/buy_order')->find($where);
  721. if (!$info) {
  722. $this->order_num++;
  723. $data = $where;
  724. $data['name'] = $order_id;
  725. $data['order_num'] = $order_num;
  726. $data['operdate'] = time();
  727. $data['status'] = 3;
  728. $data['price'] = $price;
  729. $data['num'] = $num;
  730. $id = $state = Dever::db('shop/buy_order')->insert($data);
  731. } else {
  732. $id = $info['id'];
  733. $data['where_id'] = $id;
  734. $data['price'] = $info['price'] + $price;
  735. $data['num'] = $info['num'] + $num;
  736. $state = Dever::db('shop/buy_order')->update($data);
  737. }
  738. if ($state && $id > 0) {
  739. $goods_info = Dever::db('shop/buy_order_goods')->find(array('order_id' => $id));
  740. if (!$goods_info) {
  741. $goods['order_id'] = $id;
  742. $goods['goods_id'] = $goods_id;
  743. $goods['sku_id'] = $sku_id;
  744. $goods['price'] = $price;
  745. $goods['num'] = $num;
  746. Dever::db('shop/buy_order_goods')->insert($goods);
  747. }
  748. //$state = $this->updateSell($source_type, $source_id, $goods_id, $sku_id, $num);
  749. return $id;
  750. }
  751. return false;
  752. }
  753. # 减少库存,增加销量
  754. public function updateSell($source_type, $source_id, $goods_id, $sku_id, $num)
  755. {
  756. if ($source_type == 2) {
  757. $data['store_id'] = $source_id;
  758. $data['goods_id'] = $goods_id;
  759. $data['sku_id'] = $sku_id;
  760. $data['num'] = $num;
  761. return Dever::load('store/lib/goods')->oper($source_id, 1, 2, array($data));
  762. } else {
  763. $up = array();
  764. $up['where_factory_id'] = $source_id;
  765. $up['where_goods_id'] = $goods_id;
  766. $up['sell_num'] = $num;
  767. $state = Dever::db('factory/goods')->incSell($up);
  768. if ($state) {
  769. if ($sku_id > 0) {
  770. } else {
  771. $sku_id = -1;
  772. }
  773. $upSku = $up;
  774. $upSku['where_sku_id'] = $sku_id;
  775. $state = Dever::db('factory/goods_sku')->incSell($upSku);
  776. }
  777. return $state;
  778. }
  779. }
  780. }