Buy.php 33 KB

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