Buy.php 57 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576
  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_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. if ($status == 'refund') {
  51. $where['refund_status'] = 2;
  52. } else {
  53. $where['status'] = $status;
  54. }
  55. }
  56. $order_num = Dever::input('order_num');
  57. if ($order_num) {
  58. $where['order_num'] = $order_num;
  59. }
  60. $refund_status = Dever::input('refund_status');
  61. if ($refund_status) {
  62. $where['refund_status'] = $refund_status;
  63. }
  64. $result['search_value'] = $where;
  65. $result['search_value']['day'] = $day = Dever::input('day');
  66. if ($day) {
  67. if ($this->type > 10) {
  68. $where['start_o'] = Dever::maketime($day . ' 00:00:00');
  69. $where['end_o'] = Dever::maketime($day . ' 23:59:59');
  70. } elseif ($this->type == 2) {
  71. $where['start_f'] = Dever::maketime($day . ' 00:00:00');
  72. $where['end_f'] = Dever::maketime($day . ' 23:59:59');
  73. } else {
  74. $where['start'] = Dever::maketime($day . ' 00:00:00');
  75. $where['end'] = Dever::maketime($day . ' 23:59:59');
  76. }
  77. }
  78. $result['search_value']['start'] = $start = Dever::input('start');
  79. $result['search_value']['end'] = $end = Dever::input('end');
  80. if ($start && $end) {
  81. if ($this->type > 10) {
  82. $where['start_o'] = Dever::maketime($start);
  83. $where['end_o'] = Dever::maketime($end);
  84. } elseif ($this->type == 2) {
  85. $where['start_f'] = Dever::maketime($start);
  86. $where['end_f'] = Dever::maketime($end);
  87. } else {
  88. $where['start'] = Dever::maketime($start);
  89. $where['end'] = Dever::maketime($end);
  90. }
  91. }
  92. $result['order'] = Dever::db($this->table)->getAll($where);
  93. if ($result['order']) {
  94. foreach ($result['order'] as $k => $v) {
  95. $result['order'][$k] = $this->getInfo($v);
  96. }
  97. }
  98. $result['search'] = array();
  99. $result['search']['status'] = array
  100. (
  101. array('value' => 1, 'name' => '待支付'),
  102. array('value' => 2, 'name' => '待审核'),
  103. array('value' => 3, 'name' => '待发货'),
  104. array('value' => 4, 'name' => '待收货确认'),
  105. array('value' => 5, 'name' => '已完成'),
  106. array('value' => 6, 'name' => '已完成(有退款)'),
  107. array('value' => '7,8,11', 'name' => '已取消'),
  108. );
  109. $result['config'] = Dever::db('main/manage_config')->find();
  110. return $result;
  111. }
  112. # 查看详情
  113. public function getView($id, $order_id, $show = true)
  114. {
  115. $where = $this->where($id);
  116. $where['id'] = $order_id;
  117. $result = Dever::db($this->table)->find($where);
  118. if (!$result) {
  119. Dever::alert('订单不存在');
  120. }
  121. if ($show) {
  122. $result = $this->getInfo($result, true);
  123. }
  124. $result['config'] = Dever::db('main/manage_config')->find();
  125. return $result;
  126. }
  127. # 查看退款详情
  128. public function getRefund($id, $order_id)
  129. {
  130. $data = $this->getView($id, $order_id, false);
  131. $data['refund'] = Dever::db('shop/buy_order_refund')->select(array('order_id' => $info['id']));
  132. return $data;
  133. }
  134. # 获取订单详细信息
  135. public function getInfo($info, $view = false)
  136. {
  137. if ($info['status'] == 1) {
  138. # 15分钟内支付,900秒
  139. $m = 900;
  140. # 支付倒计时
  141. $info['time'] = time() - $info['cdate'];
  142. if ($info['time'] >= $m) {
  143. # 已过期,自动取消
  144. $info['time'] = -1;
  145. Dever::db($this->table)->update(array('where_id' => $info['id'], 'status' => 11));
  146. $info['status'] = 11;
  147. } else {
  148. $info['time'] = $m - $info['time'];
  149. }
  150. }
  151. $info['status_name'] = $this->config['status'][$info['status']];
  152. $info['goods'] = Dever::db('shop/buy_order_goods')->select(array('order_id' => $info['id']));
  153. if ($info['type'] == 1) {
  154. $info['type_info'] = Dever::db('shop/info')->getOne($info['type_id']);
  155. } elseif ($info['type'] == 2) {
  156. $info['type_info'] = Dever::db('store/info')->find($info['type_id']);
  157. } elseif ($info['type'] == 3) {
  158. $info['type_info'] = Dever::db('factory/info')->find($info['type_id']);
  159. }
  160. if ($info['source_type'] == 1) {
  161. $info['source_info'] = Dever::db('shop/info')->getOne($info['source_id']);
  162. } elseif ($info['source_type'] == 2) {
  163. $info['source_info'] = Dever::db('store/info')->find($info['source_id']);
  164. } elseif ($info['source_type'] == 3) {
  165. $info['source_info'] = Dever::db('factory/info')->find($info['source_id']);
  166. }
  167. $info['cdate'] = date('Y-m-d H:i', $info['cdate']);
  168. if ($info['operdate']) {
  169. $info['operdate'] = date('Y-m-d H:i', $info['operdate']);
  170. } else {
  171. $info['operdate'] = $info['cdate'];
  172. }
  173. $goods_status = Dever::db('shop/buy_order_goods')->config['status'];
  174. $goods_process = Dever::db('shop/buy_order_refund')->config['process'];
  175. if ($view || $this->view == 2) {
  176. foreach ($info['goods'] as $k => $v) {
  177. $info['goods'][$k]['info'] = Dever::load('goods/lib/info')->getPayInfo($v['goods_id'], $v['sku_id']);
  178. $info['goods'][$k]['status_name'] = $goods_status[$v['status']];
  179. }
  180. } else {
  181. foreach ($info['goods'] as $k => $v) {
  182. $goods = Dever::db('goods/info')->one($v['goods_id']);
  183. $info['goods'][$k]['name'] = $goods['name'];
  184. $info['goods'][$k]['cover'] = $goods['cover'];
  185. $info['goods'][$k]['status_name'] = $goods_status[$v['status']];
  186. }
  187. }
  188. if (!$info['refund_cash']) {
  189. $info['refund_cash'] = 0;
  190. }
  191. # 配送信息
  192. $info['ps_info'] = Dever::db('shop/buy_order_ps')->find(array('order_id' => $info['id']));
  193. if ($info['ps_info']) {
  194. $info['ps_info']['service_name'] = '商家自送';
  195. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  196. if ($info['ps_info']['ydate']) {
  197. $info['ps_info']['ydate'] = date('Y-m-d H:i', $info['ps_info']['ydate']);
  198. }
  199. $status = Dever::db('shop/buy_order_ps')->config['status'];
  200. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  201. if ($info['ps_info']['service_id'] > 0) {
  202. //暂时还没有
  203. $service = Dever::db('shop/service')->find($info['ps_info']['service_id']);
  204. $info['ps_info']['service_name'] = $service['name'];
  205. }
  206. }
  207. return $info;
  208. }
  209. # 发起支付
  210. public function action($type, $type_id, $name, $num, $goods, $price, $info, $refer = '')
  211. {
  212. $order_data['type'] = $type;
  213. $order_data['type_id'] = $type_id;
  214. $order_data['name'] = $name;
  215. $order_data['num'] = $num;
  216. $order_data['info'] = $info;
  217. $order_data['price'] = $price;
  218. $order_data['order_num'] = $this->getOrderId();
  219. $order_data['refund_cash'] = 0;
  220. $order_data['refund_p_cash'] = 0;
  221. $id = Dever::db('shop/buy_order')->insert($order_data);
  222. if (!$id) {
  223. Dever::alert('支付失败');
  224. }
  225. foreach($goods as $k => $v) {
  226. $data['order_id'] = $id;
  227. $data['goods_id'] = $v['id'];
  228. $data['sku_id'] = $v['sku_id'];
  229. $data['price'] = $v['price'];
  230. $data['num'] = $v['buy_num'];
  231. Dever::db('shop/buy_order_goods')->insert($data);
  232. }
  233. if ($price <= 0) {
  234. $param['pay_product_id'] = $id;
  235. $param['pay_order_id'] = $order_data['order_num'];
  236. $param['pay_status'] = 2;
  237. $param['pay_cash'] = $price;
  238. $param['pay_msg'] = '';
  239. $this->success($param);
  240. return array
  241. (
  242. 'order' => '',
  243. 'order_num' => $order_data['order_num'],
  244. 'order_id' => $id,
  245. 'type' => 'pay',
  246. );
  247. }
  248. $param = array
  249. (
  250. 'project_id' => 2,
  251. 'channel_id' => 1,
  252. 'system_source' => 5,
  253. 'uid' => -1,
  254. 'name' => $order_data['name'],
  255. 'cash' => $price,
  256. 'product_id' => $id,
  257. 'order_id' => $order_data['order_num'],
  258. 'refer' => $refer,
  259. );
  260. $receipt = Dever::input('receipt');
  261. if ($receipt) {
  262. $param['receipt'] = $receipt;
  263. }
  264. //$result = Dever::load('pay/api.pay', $param);
  265. $result['type'] = 'test';
  266. $result['order'] = '';
  267. $result['order_num'] = $order_data['order_num'];
  268. $result['order_id'] = $id;
  269. return $result;
  270. }
  271. # 再次发起支付
  272. public function raction($id, $refer = '')
  273. {
  274. $order = Dever::db('shop/buy_order')->find($id);
  275. if (!$order) {
  276. Dever::alert('订单信息错误');
  277. }
  278. if ($order['status'] > 1) {
  279. Dever::alert('订单已支付或已取消');
  280. }
  281. $param = array
  282. (
  283. 'project_id' => 2,
  284. 'channel_id' => 1,
  285. 'system_source' => 5,
  286. 'uid' => -1,
  287. 'name' => $order['name'],
  288. 'cash' => $order['price'],
  289. 'product_id' => $id,
  290. 'order_id' => $order['order_num'],
  291. 'refer' => $refer,
  292. );
  293. $receipt = Dever::input('receipt');
  294. if ($receipt) {
  295. $param['receipt'] = $receipt;
  296. }
  297. $result = Dever::load('pay/api.pay', $param);
  298. $result['order_num'] = $order['order_num'];
  299. $result['order_id'] = $id;
  300. return $result;
  301. }
  302. # 支付成功回调 安全加密 设置token
  303. public function success_secure_api_token()
  304. {
  305. $project_id = Dever::input('pay_project_id');
  306. $info = Dever::db('pay/project')->one($project_id);
  307. if ($info) {
  308. return $info['key'];
  309. }
  310. return 'shop_buy_dever_2020';
  311. }
  312. # 支付成功回调 安全加密
  313. public function success_secure_api($param = array())
  314. {
  315. $this->success($param);
  316. }
  317. # 支付成功回调
  318. public function success($param = array())
  319. {
  320. $send = $param ? $param : Dever::preInput('pay_');
  321. $product_id = $send['pay_product_id'];
  322. $order_id = $send['pay_order_id'];
  323. $status = $send['pay_status'];
  324. $cash = $send['pay_cash'];
  325. $msg = $send['pay_msg'];
  326. $order = Dever::db('shop/buy_order')->one(array('id' => $product_id, 'time' => time()));
  327. if ($order && $order['status'] == 1 && $status == 2) {
  328. $update['status'] = 2;
  329. $update['where_id'] = $order['id'];
  330. Dever::db('shop/buy_order')->update($update);
  331. # 生成结算单
  332. Dever::load('cash/lib/order')->up($order, 1, 1);
  333. }
  334. return 'ok';
  335. }
  336. # 生成订单号
  337. public function getOrderId()
  338. {
  339. $where['order_num'] = Dever::order('C');
  340. $state = Dever::db('shop/buy_order')->one($where);
  341. if (!$state) {
  342. return $where['order_num'];
  343. } else {
  344. return $this->getOrderId();
  345. }
  346. }
  347. # 添加配送信息
  348. public function updatePs($order, $status = 1)
  349. {
  350. $where['order_id'] = $order['id'];
  351. $data = Dever::db('shop/buy_order_ps')->find($where);
  352. if ($data) {
  353. $update['where_id'] = $data['id'];
  354. $update['status'] = $status;
  355. $update['ydate'] = time();
  356. Dever::db('shop/buy_order_ps')->update($update);
  357. }
  358. }
  359. # 确认收货
  360. public function finish($id, $order_id)
  361. {
  362. $data = $this->getView($id, $order_id, false);
  363. if ($data['status'] <= 4) {
  364. if ($data['refund_cash'] > 0) {
  365. $status = 6;
  366. } else {
  367. $status = 5;
  368. }
  369. $state = Dever::db('shop/buy_order')->update(array('where_id' => $data['id'], 'status' => $status, 'fdate' => time()));
  370. if ($state) {
  371. $this->updatePs($data, 3);
  372. # 增加库存
  373. $where['order_id'] = $data['id'];
  374. $where['status'] = 1;
  375. $goods = Dever::db('shop/buy_order_goods')->select($where);
  376. if ($goods) {
  377. Dever::load('shop/lib/goods')->oper($data, 1, 1, $goods);
  378. }
  379. # 生成结算单
  380. Dever::load('cash/lib/order')->up($data, 1, 2);
  381. }
  382. return 'ok';
  383. } else {
  384. Dever::alert('您没有权限');
  385. }
  386. }
  387. # 取消订单
  388. public function cancel($id, $order_id)
  389. {
  390. $data = $this->getView($id, $order_id, false);
  391. if ($data['status'] == 1) {
  392. $state = Dever::db('shop/buy_order')->update(array('where_id' => $data['id'], 'status' => 7, 'operdate' => time()));
  393. # 生成结算单
  394. if ($state) {
  395. //Dever::load('cash/lib/order')->up($data, 1, 3);
  396. }
  397. return 'ok';
  398. } else {
  399. Dever::alert('当前订单状态不允许取消');
  400. }
  401. }
  402. # 查看订单状态
  403. public function orderStatus($id)
  404. {
  405. $config = Dever::db('shop/buy_order')->config;
  406. $info = Dever::db('shop/buy_order')->one($id);
  407. $tk = Dever::db('shop/buy_order_refund')->find(array('order_id' => $info['id'], 'process' => 1));
  408. $status = $config['status'][$info['status']];
  409. if ($tk) {
  410. $status = '申请退款中';
  411. }
  412. return $status;
  413. }
  414. # 后台审核退款
  415. public function refund_commit_api()
  416. {
  417. $id = Dever::input('id');
  418. $process = Dever::input('process');
  419. return Dever::load('shop/lib/refund')->set('buy')->action($id, $process, false);
  420. }
  421. # 货物未发出,仅退款
  422. public function refund_apply_commit_api()
  423. {
  424. $order_id = Dever::input('order_id');
  425. $type = Dever::input('type');
  426. $type_id = Dever::input('type_id');
  427. $desc = Dever::input('desc');
  428. $pic = Dever::input('pic');
  429. return Dever::load('shop/lib/refund')->set('buy')->apply($type, $type_id, $order_id, false, 3, 0, $desc, $pic, 2);
  430. }
  431. # 货物已收到 全部退款 报损 需要审核
  432. public function refund_apply_info_commit_api()
  433. {
  434. $order_id = Dever::input('order_id');
  435. $status = Dever::input('status');
  436. $desc = Dever::input('desc');
  437. $pic = Dever::input('pic');
  438. $type = Dever::input('type');
  439. $type_id = Dever::input('type_id');
  440. return Dever::load('shop/lib/refund')->set('buy')->apply($type, $type_id, $order_id, false, $status, 0, $desc, $pic, 1);
  441. }
  442. # 部分退款 报损
  443. public function refund_apply_info_one_commit_api()
  444. {
  445. $order_id = Dever::input('order_id');
  446. $order_goods_id = Dever::input('order_goods_id');
  447. $num = Dever::input('num', 0);
  448. $status = Dever::input('status');
  449. $desc = Dever::input('desc');
  450. $pic = Dever::input('pic');
  451. $type = Dever::input('type');
  452. $type_id = Dever::input('type_id');
  453. return Dever::load('shop/lib/refund')->set('buy')->apply($type, $type_id, $order_id, $order_goods_id, $status, $num, $desc, $pic, 1);
  454. }
  455. # 展示订单详情
  456. public function show()
  457. {
  458. $id = Dever::input('order_id');
  459. $type = Dever::input('type', 1);
  460. $cash_type = Dever::input('cash', 1);
  461. $config = Dever::db('shop/buy_order')->config;
  462. $info = Dever::db('shop/buy_order')->one($id);
  463. $tk_status = Dever::db('shop/buy_order_refund')->config['status'];
  464. $tk_process = Dever::db('shop/buy_order_refund')->config['process'];
  465. $status = $config['status'][$info['status']];
  466. $tk = Dever::db('shop/buy_order_refund')->find(array('order_id' => $info['id'], 'type' => 1));
  467. $cdate = date('Y-m-d H:i', $info['cdate']);
  468. if ($info['operdate']) {
  469. $operdate = date('Y-m-d H:i', $info['operdate']);
  470. } else {
  471. $operdate = '';
  472. }
  473. if ($info['fdate']) {
  474. $fdate = date('Y-m-d H:i', $info['fdate']);
  475. } else {
  476. $fdate = '';
  477. }
  478. $html = '<div class="layui-col-md12"><div class="layui-card"><div class="layui-card-header">基本信息</div><div class="layui-card-body">';
  479. $html .= '<table class="layui-table"><thead><tr><th style="width:20%">项目</th><th style="width:80%">详情</th></tr> </thead><tbody>';
  480. if ($type == 2 || $info['type'] == 2) {
  481. $info['price'] = $info['p_price'];
  482. }
  483. if ($type == 3) {
  484. $html .= '<tr>
  485. <td>订单信息</td>
  486. <td>'.$this->table(false, array(array('订单号:' . $info['order_num'], '数量:' . $info['num'], '状态:' . $status))).'</td>
  487. </tr>';
  488. } else {
  489. $html .= '<tr>
  490. <td>订单信息</td>
  491. <td>'.$this->table(false, array(array('订单号:' . $info['order_num'], '金额:' . $info['price'], '数量:' . $info['num'], '状态:' . $status))).'</td>
  492. </tr>';
  493. }
  494. if ($type == 1 && $tk && $tk['process'] == 1) {
  495. $status = '申请' . $tk_status[$tk['status']];
  496. }
  497. if ($type == 1) {
  498. $time = array('下单时间:' . $cdate, '订货时间:' . $operdate);
  499. } else {
  500. $time = array('订货时间:' . $operdate);
  501. }
  502. if ($fdate) {
  503. $time[] = '完成时间:' . $fdate;
  504. }
  505. $html .= '<tr>
  506. <td>订单时间</td>
  507. <td>'.$this->table(false, array($time)).'</td>
  508. </tr>';
  509. if ($info['type'] == 1) {
  510. $type_info = Dever::db('shop/info')->find($info['type_id']);
  511. } elseif ($info['type'] == 2) {
  512. $type_info = Dever::db('store/info')->find($info['type_id']);
  513. } elseif ($info['type'] == 3) {
  514. $type_info = Dever::db('store/info')->find($info['type_id']);
  515. }
  516. $html .= '<tr>
  517. <td>配送信息</td>
  518. <td>'.$this->table(false, array(array($type_info['name'] . ',' . $type_info['truename'] . ',' . $type_info['mobile'] . ',' . $type_info['address']))).'</td>
  519. </tr>';
  520. if ($type == 1 && $info['source_id'] > 0) {
  521. if ($info['source_type'] == 2) {
  522. # 仓库
  523. $source_info = Dever::db('store/info')->find($info['source_id']);
  524. } elseif ($info['source_type'] == 3) {
  525. # 工厂
  526. $source_info = Dever::db('factory/info')->find($info['source_id']);
  527. }
  528. $html .= '<tr>
  529. <td>供应商信息</td>
  530. <td>'.$this->table(false, array(array($source_info['name'] . ',' . $source_info['truename'] . ',' . $source_info['mobile']))).'</td>
  531. </tr>';
  532. }
  533. if ($info['info']) {
  534. $html .= '<tr>
  535. <td>订单备注</td>
  536. <td>'.$this->table(false, array(array($info['info']))).'</td>
  537. </tr>';
  538. }
  539. if ($type == 2) {
  540. $config = Dever::load('factory/admin/auth.config');
  541. $button = array();
  542. if ($info['status'] < 5) {
  543. $print = Dever::url('admin/order.print?id=' . $info['id'] . '&type=1', 'factory');
  544. $button[] = '<a class="layui-btn layui-btn-primary" href="'.$print.'" target="_blank">打印货单</a>';
  545. }
  546. if ($info['status'] == 3) {
  547. $send = Dever::url('order_send?id=' . $info['id'], 'factory');
  548. $cancel = Dever::url('lib/buy.refund_apply_commit?json=1', 'mshop');
  549. $button[] = '<button class="layui-btn layui-btn-primary" onclick="fastEdit($(this), \''.$send.'\', \'配送发货\', \'\', 1)">配送发货</button>';
  550. $button[] = '<button class="layui-btn layui-btn-primary" onclick="cancel('.$info['id'].','.$info['source_id'].', \''.$cancel.'\')">取消订单</button>';
  551. }
  552. $config['phone'] = '您的专属客服:' . $config['kf_name'] . ',联系电话:' . $config['phone'];
  553. $button[] = '<button class="layui-btn layui-btn-primary" onclick="showAlert(\''.$config['phone'].'\')">联系平台</button>';
  554. $html .= '<tr>
  555. <td>功能按钮</td>
  556. <td>'.$this->table(false, array($button)).'</td>
  557. </tr>';
  558. } elseif ($type == 3) {
  559. $config = Dever::load('factory/admin/auth.config');
  560. $button = array();
  561. $print = Dever::url('admin/order.print?id=' . $info['id'] . '&type=2', 'store');
  562. $button[] = '<a class="layui-btn layui-btn-primary" href="'.$print.'" target="_blank">打印货单</a>';
  563. if ($info['status'] == 3) {
  564. $send = Dever::url('order_send?id=' . $info['id'] . '&type=2', 'store');
  565. $button[] = '<button class="layui-btn layui-btn-primary" onclick="fastEdit($(this), \''.$send.'\', \'配送发货\', \'\', 1)">配送发货</button>';
  566. }
  567. if ($info['status'] == 4 && $info['type'] == 2) {
  568. $url = Dever::url('admin/factory_order.action?order_id='.$info['id'], 'store');
  569. $button[] = '<button class="layui-btn layui-btn-primary" onclick="load(\''.$url.'\')">确认收货</button>';
  570. }
  571. $config['phone'] = '您的专属客服:' . $config['kf_name'] . ',联系电话:' . $config['phone'];
  572. $button[] = '<button class="layui-btn layui-btn-primary" onclick="showAlert(\''.$config['phone'].'\')">联系平台</button>';
  573. $html .= '<tr>
  574. <td>功能按钮</td>
  575. <td>'.$this->table(false, array($button)).'</td>
  576. </tr>';
  577. }
  578. $html .= '</tbody></table></div></div>';
  579. $url = Dever::url('lib/buy.refund_commit?json=1', 'mshop');
  580. if (!$info['refund_cash']) {
  581. $info['refund_cash'] = 0;
  582. }
  583. if ($info['refund_cash'] > 0 && $tk) {
  584. if ($tk['process'] == 1) {
  585. $process = '<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>';
  586. } else {
  587. $process = $tk_process[$tk['process']];
  588. }
  589. $desc = array();
  590. $desc['退款原因'] = $tk['desc'];
  591. $desc['退款图片'] = '暂无';
  592. if ($tk['pic']) {
  593. $desc['退款图片'] = '';
  594. $pic = explode(',', $tk['pic']);
  595. foreach ($pic as $k => $v) {
  596. $desc['退款图片'] .= '<a href="'.$v.'" target="_blank"><img src="'.$v.'" width="100"/></a>';
  597. }
  598. }
  599. $tk['desc'] = '<a href="javascript:showAlert($(\'#desc_content\').html());">查看</a><span id="desc_content" style="display:none">'.Dever::table($desc).'</span>';
  600. $head = array('退款金额', '数量', '退款原因', '退款进度');
  601. $body = array(array($info['refund_cash'], $info['num'], $tk['desc'], $process));
  602. $html .= '<div class="layui-card"><div class="layui-card-header">退款信息</div><div class="layui-card-body">' . $this->table($head, $body) . '</div></div>';
  603. }
  604. $info['ps_info'] = Dever::db('shop/buy_order_ps')->find(array('order_id' => $info['id']));
  605. if ($info['ps_info']) {
  606. $info['ps_info']['service_name'] = '供应商自送';
  607. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  608. if ($info['ps_info']['ydate']) {
  609. $info['ps_info']['ydate'] = date('Y-m-d H:i', $info['ps_info']['ydate']);
  610. } else {
  611. $info['ps_info']['ydate'] = '无';
  612. }
  613. $status = Dever::db('shop/buy_order_ps')->config['status'];
  614. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  615. if ($info['ps_info']['service_id'] > 0) {
  616. //暂时还没有
  617. $service = Dever::db('shop/service')->find($info['ps_info']['service_id']);
  618. $info['ps_info']['service_name'] = $service['name'];
  619. }
  620. $info['ps_info']['order_num'] = str_replace("\r\n", ',', $info['ps_info']['order_num']);
  621. if ($type == 3) {
  622. $head = array('名称', '单号', '数量', '重量', '体积', '发货时间', '收货时间');
  623. $body = array(array($info['ps_info']['service_name'], $info['ps_info']['order_num'], $info['ps_info']['num'], $info['ps_info']['zl'], $info['ps_info']['tj'], $info['ps_info']['cdate'], $info['ps_info']['ydate']));
  624. } else {
  625. $head = array('名称', '单号', '费用', '数量', '重量', '体积', '配货员', '打包员', '发货时间', '收货时间');
  626. $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']['cdate'], $info['ps_info']['ydate']));
  627. }
  628. $html .= '<div class="layui-card"><div class="layui-card-header">物流信息</div><div class="layui-card-body">' . $this->table($head, $body) . '</div></div>';
  629. }
  630. $body = array();
  631. $body_total = array();
  632. $body_total['price'] = 0;
  633. $body_total['num'] = 0;
  634. $goods = Dever::db('shop/buy_order_goods')->select(array('order_id' => $info['id']));
  635. $goods_status = Dever::db('shop/buy_order_goods')->config['status'];
  636. $refund_body = array();
  637. $refund_body_total = array();
  638. $refund_body_total['price'] = 0;
  639. $refund_body_total['num'] = 0;
  640. foreach ($goods as $k => $v) {
  641. if ($type == 2 || $info['type'] == 2) {
  642. $v['price'] = $v['p_price'];
  643. }
  644. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  645. $status = $goods_status[$v['status']];
  646. $tk = Dever::db('shop/buy_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
  647. if ($tk && $tk['process'] == 1) {
  648. if ($type == 1) {
  649. $status = '申请' . $tk_status[$tk['status']];
  650. } else {
  651. $status = '已上报';
  652. }
  653. if ($type == 1) {
  654. $desc = array();
  655. $desc['退款原因'] = $tk['desc'];
  656. $desc['退款图片'] = '暂无';
  657. if ($tk['pic']) {
  658. $desc['退款图片'] = '';
  659. $pic = explode(',', $tk['pic']);
  660. foreach ($pic as $k1 => $v1) {
  661. $desc['退款图片'] .= '<a href="'.$v1.'" target="_blank"><img src="'.$v1.'" width="100"/></a>';
  662. }
  663. }
  664. $status .= '&nbsp;&nbsp;<a href="javascript:showAlert($(\'#desc_content\').html());">查看原因</a><span id="desc_content" style="display:none">'.Dever::table($desc).'</span>';
  665. $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>';
  666. }
  667. } elseif ($type > 1 && (!$tk || ($tk && $tk['process'] == 3))) {
  668. $tui = Dever::url('lib/buy.refund_apply_info_one_commit?json=1', 'mshop');
  669. if ($info['status'] == 3) {
  670. $status = '<a href="javascript:;" onclick="tui('.$v['id'].','.$info['id'].','.$info['source_id'].', 2, \''.$tui.'\')" class="layui-btn">缺货退款</a>';
  671. } elseif ($info['status'] == 4) {
  672. $status = '<a href="javascript:;" onclick="tui('.$v['id'].','.$info['id'].','.$info['source_id'].', 1, \''.$tui.'\')" class="layui-btn">报损退款</a>';
  673. }
  674. }
  675. if (isset($goods_info['sku'])) {
  676. $sku = '[' . $goods_info['sku']['string'] . ']';
  677. } else {
  678. $sku = '';
  679. }
  680. if ($tk && $v['status'] == 3 && $tk['status'] != 3) {
  681. $d = array
  682. (
  683. $goods_info['name'] . ' ' . $sku,
  684. $v['price'],
  685. $v['num'],
  686. $tk_status[$tk['status']],
  687. );
  688. if ($type == 3) {
  689. unset($d[1]);
  690. }
  691. $refund_body[] = $d;
  692. $refund_body_total['price'] += $v['price'];
  693. $refund_body_total['num'] += $v['num'];
  694. } else {
  695. $d = array
  696. (
  697. $goods_info['name'] . ' ' . $sku,
  698. $v['price'],
  699. $v['num'],
  700. $status,
  701. );
  702. if ($type == 3) {
  703. unset($d[1]);
  704. }
  705. $body[] = $d;
  706. $body_total['price'] += $v['price'];
  707. $body_total['num'] += $v['num'];
  708. }
  709. }
  710. if ($body) {
  711. $head = array('名称', '单价', '数量', '状态');
  712. $d = array
  713. (
  714. '合计',
  715. $body_total['price'],
  716. $body_total['num'],
  717. '-'
  718. );
  719. if ($type == 3) {
  720. unset($head[1]);
  721. unset($d[1]);
  722. }
  723. $body[] = $d;
  724. $html .= '<div class="layui-card"><div class="layui-card-header">商品清单</div><div class="layui-card-body" style="max-heights: 500px;overflow: auto;">' . $this->table($head, $body) . '</div></div>';
  725. }
  726. if ($refund_body) {
  727. $head = array('名称', '单价', '数量', '状态');
  728. $d = array
  729. (
  730. '合计',
  731. $refund_body_total['price'],
  732. $refund_body_total['num'],
  733. '-'
  734. );
  735. if ($type == 3) {
  736. unset($head[1]);
  737. unset($d[1]);
  738. }
  739. $refund_body[] = $d;
  740. $html .= '<div class="layui-card"><div class="layui-card-header">缺货与报损商品</div><div class="layui-card-body" style="max-heights: 300px;overflow: auto;">' . $this->table($head, $refund_body) . '</div></div>';
  741. }
  742. if ($cash_type == 1) {
  743. if ($type == 1) {
  744. # 门店结算单
  745. $cash_order = Dever::db('cash/order')->select(array('type' => $info['type'], 'type_id' => $info['type_id'], 'source_order_id' => $info['id']));
  746. } elseif ($type == 2) {
  747. # 工厂结算单
  748. $cash_order = Dever::db('cash/order')->select(array('source_type' => $info['source_type'], 'source_id' => $info['source_id'], 'source_order_id' => $info['id']));
  749. }
  750. }
  751. if (isset($cash_order) && $cash_order) {
  752. $head = array('序号', '结算单号', '数量', '金额', '结算类型', '入账状态', '审核状态', '结算时间', '审核未通过原因', '管理');
  753. if ($type == 3) {
  754. unset($head[3]);
  755. }
  756. $body = array();
  757. $config = Dever::db('cash/order')->config;
  758. foreach ($cash_order as $k => $v) {
  759. $cdate = date('Y-m-d H:i', $v['cdate']);
  760. $fdate = $v['fdate'] ? date('Y-m-d H:i', $v['fdate']) : '';
  761. $operdate = $v['operdate'] ? date('Y-m-d H:i', $v['operdate']) : '';
  762. $cash = $v['cash'];
  763. $url = Dever::url('project/database/list?project=shop&table=buy_order_goods&order_id='.$v['source_order_id'].'&page_type=1', 'manage');
  764. $v['source_order_num'] = '<a href="'.$url.'" style="color:blue">'.$v['source_order_num'].'</a>';
  765. $m = '';
  766. if ($v['audit'] == 1 && $v['audit_type'] == 2) {
  767. $url = Dever::url('project/database/update?project=cash&table=order&where_id='.$v['id'].'&col=audit,desc', 'manage');
  768. $m = '<a href="javascript:;" onclick="fastEdit($(this), \''.$url.'\', \'审核\', \'\', 1)" class="layui-btn">审核</a>';
  769. }
  770. $d = array
  771. (
  772. $k+1,
  773. $v['order_num'],
  774. $v['num'],
  775. $cash,
  776. $config['config_jstype'][$v['jstype']],
  777. $config['config_status'][$v['status']],
  778. $config['config_audit'][$v['audit']],
  779. $operdate,
  780. $v['desc'],
  781. $m,
  782. );
  783. if ($type == 3) {
  784. unset($d[3]);
  785. }
  786. $body[] = $d;
  787. }
  788. $html .= '<div class="layui-card"><div class="layui-card-header">对账清单</div><div class="layui-card-body" style="max-heights: 500px;overflow: auto;">' . $this->table($head, $body) . '</div></div>';
  789. }
  790. $html .= '</div>';
  791. return '<div class="layui-card-body">' . $html . '</div>';
  792. }
  793. private function table($head, $data)
  794. {
  795. $html = '';
  796. if ($head) {
  797. $html = '<table class="layui-table">';
  798. $html .= '<thead><tr>';
  799. foreach ($head as $k => $v) {
  800. $html .= '<th>'.$v.'</th>';
  801. }
  802. $html .= '</tr></thead>';
  803. $html .= '<tbody>';
  804. foreach ($data as $k => $v) {
  805. $html .= '<tr>';
  806. foreach ($v as $k1 => $v1) {
  807. $html .= '<td>'.$v1.'</td>';
  808. }
  809. $html .= '</tr>';
  810. }
  811. $html .= '</tbody>';
  812. $html .= '</table>';
  813. } else {
  814. foreach ($data as $k => $v) {
  815. $html .= '';
  816. foreach ($v as $k1 => $v1) {
  817. $html .= $v1 . '&nbsp;&nbsp;&nbsp;&nbsp;';
  818. }
  819. $html .= '';
  820. }
  821. }
  822. return $html;
  823. }
  824. # 发货
  825. /*
  826. public function send_commit()
  827. {
  828. $order_id = Dever::input('order_id');
  829. $order = Dever::db('shop/buy_order')->find($order_id);
  830. if (!$order || ($order && $order['status'] != 3)) {
  831. Dever::alert('当前订单状态无法发货');
  832. }
  833. $state = Dever::db('shop/buy_order')->update(array('where_id' => $order['id'], 'status' => 4));
  834. if ($state) {
  835. $this->updatePs($order, 1);
  836. }
  837. return 'reload';
  838. }*/
  839. # 采购订单审核 拆单
  840. public function audit_commit()
  841. {
  842. $order_id = Dever::input('order_id');
  843. $order = Dever::db('shop/buy_order')->find($order_id);
  844. if (!$order || ($order && $order['status'] != 2)) {
  845. Dever::alert('当前订单状态无法拆单');
  846. }
  847. if ($order['type'] != 1) {
  848. Dever::alert('这不是门店的订单');
  849. }
  850. $goods = Dever::db('shop/buy_order_goods')->select(array('order_id' => $order_id));
  851. $shop = Dever::db('shop/info')->find($order['type_id']);
  852. # 获取门店分配的仓库和工厂
  853. $shop_store = Dever::db('shop/store')->select(array('shop_id' => $shop['id']));
  854. $store = array();
  855. $distance = array();
  856. # 按照距离排序
  857. foreach ($shop_store as $k => $v) {
  858. $info = Dever::db('store/info')->find($v['store_id']);
  859. if ($info && $info['status'] == 1) {
  860. $distance[] = $info['distance'] = Dever::distance($shop['lng'], $shop['lat'], $info['lng'], $info['lat']);
  861. $store[] = $info;
  862. }
  863. }
  864. if (!$store) {
  865. Dever::alert('未分配仓库');
  866. }
  867. array_multisort($distance, SORT_ASC, SORT_NUMERIC, $store);
  868. $shop_factory = Dever::db('shop/factory')->select(array('shop_id' => $shop['id']));
  869. $factory = array();
  870. $distance = array();
  871. # 按照距离排序
  872. foreach ($shop_factory as $k => $v) {
  873. $info = Dever::db('factory/info')->find($v['factory_id']);
  874. if ($info && $info['status'] == 1) {
  875. $distance[] = $info['distance'] = Dever::distance($shop['lng'], $shop['lat'], $info['lng'], $info['lat']);
  876. $factory[] = $info;
  877. }
  878. }
  879. if (!$factory) {
  880. Dever::alert('未分配工厂');
  881. }
  882. array_multisort($distance, SORT_ASC, SORT_NUMERIC, $factory);
  883. $this->order_num = 0;
  884. $this->order_id = array();
  885. $delete = array();
  886. $yes = array();
  887. foreach ($goods as $k => $v) {
  888. # 开始找仓库
  889. $find = $this->store($order['id'], $order['order_num'] . '_' . $this->order_num, $shop, $store, $v);
  890. if (!$find[1]) {
  891. # 仓库没有,找厂家
  892. if ($factory) {
  893. $find = $this->factory($order['id'], $order['order_num'] . '_' . $this->order_num, $shop, $factory, $v);
  894. }
  895. }
  896. if ($find[1]) {
  897. $delete[$v['id']] = $v;
  898. } else {
  899. $yes[$v['id']] = $v;
  900. }
  901. }
  902. $num = count($this->order_id);
  903. if ($num > 0) {
  904. if ($num == 1) {
  905. $key = array_keys($this->order_id);
  906. $key = $key[0];
  907. Dever::db('shop/buy_order')->delete($key);
  908. $goods = Dever::db('shop/buy_order_goods')->select(array('order_id' => $key));
  909. $p_price = 0;
  910. foreach ($goods as $k => $v) {
  911. $goods_info = Dever::db('shop/buy_order_goods')->find(array('order_id' => $order['id'], 'goods_id' => $v['goods_id']));
  912. if ($goods_info) {
  913. Dever::db('shop/buy_order_goods')->update(array('where_id' => $goods_info['id'], 'set_p_price' => $v['p_price']));
  914. $p_price += $v['p_price'];
  915. }
  916. }
  917. Dever::db('shop/buy_order')->update(array('where_id' => $order['id'], 'status' => 3, 'source_type' => $this->order_id[$key][0], 'source_id' => $this->order_id[$key][1], 'p_price' => $p_price, 'operdate' => time()));
  918. Dever::db('shop/buy_order_goods')->delete(array('order_id' => $key));
  919. $this->order_id[$order['id']] = array($this->order_id[$key][0], $this->order_id[$key][1]);
  920. unset($this->order_id[$key]);
  921. } else {
  922. if (!$yes) {
  923. Dever::db('shop/buy_order')->update(array('where_id' => $order['id'], 'state' => 2));
  924. Dever::load('cash/lib/order')->up($order, 1, 3);
  925. } else {
  926. $price = 0;
  927. $num = 0;
  928. foreach ($delete as $k => $v) {
  929. Dever::db('shop/buy_order_goods')->delete(array('where_id' => $v['id']));
  930. $price += $v['price'];
  931. $num += $v['num'];
  932. }
  933. $order['price'] = $order['price'] - $price;
  934. $order['num'] = $order['num'] - $num;
  935. Dever::db('shop/buy_order')->update(array('where_id' => $order['id'], 'price' => $order['price'], 'num' => $order['num']));
  936. Dever::load('shop/lib/refund')->set('buy')->apply(1, $shop['id'], $order_id, false, 3, 0, '供货商库存不足');
  937. Dever::load('cash/lib/order')->up($order, 1, 3);
  938. }
  939. }
  940. } else {
  941. # 没有找到,退款
  942. Dever::load('shop/lib/refund')->set('buy')->apply(1, $shop['id'], $order_id, false, 3, 0, '供货商库存不足');
  943. }
  944. if ($this->order_id) {
  945. foreach ($this->order_id as $k => $v) {
  946. $this->sendMsg($v[0], $v[1], $k);
  947. if ($k != $order['id']) {
  948. $order_info = Dever::db('shop/buy_order')->find($k);
  949. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  950. }
  951. }
  952. }
  953. return 'ok';
  954. }
  955. private function store($order_id, $order_num, $shop, $store, $goods, $state = 2)
  956. {
  957. $find = array();
  958. $type_id = array();
  959. $id = array();
  960. if (!$store) {
  961. return array(2, $type_id, $id);
  962. }
  963. foreach ($store as $k => $v) {
  964. $where['store_id'] = $v['id'];
  965. $where['goods_id'] = $goods['goods_id'];
  966. $where['sku_id'] = ($goods['sku_id'] && $goods['sku_id'] > 0) ? $goods['sku_id'] : -1;
  967. $sku = Dever::db('store/goods_sku')->getOne($where);
  968. if ($sku) {
  969. if ($goods['num'] <= $sku['total']) {
  970. # 如果库存符合,直接下单即可,生成仓库订单
  971. $state = $this->createOrder($order_id, $order_num, 1, $shop['id'], 2, $where['store_id'], $goods['price'], $goods['price'], $goods['num'], $where['goods_id'], $where['sku_id']);
  972. if ($state) {
  973. $type_id[] = $where['store_id'];
  974. $id[] = $state;
  975. $this->order_id[$state] = array(2, $where['store_id']);
  976. break;
  977. }
  978. } elseif ($state == 1 && $sku['total'] > 0) {
  979. # 如果库存不够,从这个仓库扣下一部分,剩余的从另外仓库处理
  980. $goods['num'] = $goods['num'] - $sku['total'];
  981. # 生成仓库订单
  982. $state = $this->createOrder($order_id, $order_num, 1, $shop['id'], 2, $where['store_id'], $goods['price'], $goods['price'], $sku['total'], $where['goods_id'], $where['sku_id']);
  983. if (!$state) {
  984. $goods['num'] = $goods['num'] + $sku['total'];
  985. } else {
  986. $type_id[] = $where['store_id'];
  987. $id[] = $state;
  988. $this->order_id[$state] = array(2, $where['store_id']);
  989. }
  990. continue;
  991. } else {
  992. # 直接切换到下一个仓库处理
  993. continue;
  994. }
  995. }
  996. }
  997. return array(2, $type_id, $id);
  998. }
  999. private function factory($order_id, $order_num, $shop, $factory, $goods)
  1000. {
  1001. $find = array();
  1002. $type_id = array();
  1003. $id = array();
  1004. if (!$factory) {
  1005. return array(3, $type_id, $id);
  1006. }
  1007. foreach ($factory as $k => $v) {
  1008. $where['factory_id'] = $v['id'];
  1009. $where['goods_id'] = $goods['goods_id'];
  1010. $where['sku_id'] = ($goods['sku_id'] && $goods['sku_id'] > 0) ? $goods['sku_id'] : -1;
  1011. $sku = Dever::db('factory/goods_sku')->getOne($where);
  1012. if ($sku && $sku['p_price'] > 0) {
  1013. $state = $this->createOrder($order_id, $order_num, 1, $shop['id'], 3, $where['factory_id'], $goods['price'], $sku['p_price'], $goods['num'], $where['goods_id'], $where['sku_id']);
  1014. if ($state) {
  1015. $type_id[] = $where['factory_id'];
  1016. $id[] = $state;
  1017. $this->order_id[$state] = array(3, $where['factory_id']);
  1018. break;
  1019. }
  1020. } else {
  1021. continue;
  1022. }
  1023. }
  1024. return array(3, $type_id, $id);
  1025. }
  1026. # 发送消息
  1027. private function sendMsg($source_type, $source_id, $id)
  1028. {
  1029. if (Dever::project('message')) {
  1030. $msg_param['type'] = 1;//消息类型1是订单消息
  1031. $msg_param['id'] = $id;
  1032. $msg_param['source_id'] = $source_id;
  1033. $msg_param['source_type'] = $source_type;
  1034. $msg_param = Dever::json_encode($msg_param);
  1035. $project = $source_type + 1;
  1036. $msg = '您有一个新的订货单,请及时处理。';
  1037. Dever::load('message/lib/data')->push(-1, $source_id, '订货通知', $msg, 2, $project, false, $msg_param);
  1038. }
  1039. }
  1040. # 生成拆单的订单
  1041. private function createOrder($order_id, $order_num, $type, $type_id, $source_type, $source_id, $price, $p_price, $num, $goods_id, $sku_id)
  1042. {
  1043. $where['parent_order_id'] = $order_id;
  1044. $where['type'] = $type;
  1045. $where['type_id'] = $type_id;
  1046. $where['source_type'] = $source_type;
  1047. $where['source_id'] = $source_id;
  1048. $where['r'] = $goods_id;
  1049. $info = Dever::db('shop/buy_order')->find($where);
  1050. if (!$info) {
  1051. $this->order_num++;
  1052. $data = $where;
  1053. $data['name'] = $order_id;
  1054. $data['order_num'] = $order_num;
  1055. $data['operdate'] = time();
  1056. $data['status'] = 3;
  1057. $data['price'] = $price * $num;
  1058. $data['p_price'] = $p_price * $num;
  1059. $data['num'] = $num;
  1060. $data['refund_cash'] = 0;
  1061. $data['refund_p_cash'] = 0;
  1062. $id = $state = Dever::db('shop/buy_order')->insert($data);
  1063. } else {
  1064. $id = $info['id'];
  1065. $data['where_id'] = $id;
  1066. $data['price'] = $info['price'] + ($price * $num);
  1067. $data['p_price'] = $info['p_price'] + ($p_price * $num);
  1068. $data['num'] = $info['num'] + $num;
  1069. $state = Dever::db('shop/buy_order')->update($data);
  1070. }
  1071. if ($state && $id > 0) {
  1072. $goods_info = Dever::db('shop/buy_order_goods')->find(array('order_id' => $id));
  1073. if (!$goods_info) {
  1074. $goods['order_id'] = $id;
  1075. $goods['goods_id'] = $goods_id;
  1076. $goods['sku_id'] = $sku_id;
  1077. $goods['price'] = $price;
  1078. $goods['p_price'] = $p_price;
  1079. $goods['num'] = $num;
  1080. Dever::db('shop/buy_order_goods')->insert($goods);
  1081. }
  1082. //$state = $this->updateSell($source_type, $source_id, $goods_id, $sku_id, $num);
  1083. return $id;
  1084. }
  1085. return false;
  1086. }
  1087. # 减少库存,增加销量
  1088. public function updateSell($source_type, $source_id, $goods_id, $sku_id, $num)
  1089. {
  1090. if ($source_type == 2) {
  1091. $data['store_id'] = $source_id;
  1092. $data['goods_id'] = $goods_id;
  1093. $data['sku_id'] = $sku_id;
  1094. $data['num'] = $num;
  1095. return Dever::load('store/lib/goods')->oper($source_id, 1, 2, array($data));
  1096. } else {
  1097. $up = array();
  1098. $up['where_factory_id'] = $source_id;
  1099. $up['where_goods_id'] = $goods_id;
  1100. $up['sell_num'] = $num;
  1101. $state = Dever::db('factory/goods')->incSell($up);
  1102. if ($state) {
  1103. if ($sku_id > 0) {
  1104. } else {
  1105. $sku_id = -1;
  1106. }
  1107. $upSku = $up;
  1108. $upSku['where_sku_id'] = $sku_id;
  1109. $state = Dever::db('factory/goods_sku')->incSell($upSku);
  1110. }
  1111. return $state;
  1112. }
  1113. }
  1114. # 打印订单单
  1115. public function printer($user)
  1116. {
  1117. $id = Dever::input('id');
  1118. $type = Dever::input('type', 1);
  1119. $factory_config = Dever::db('main/factory_config')->find();
  1120. $main_config = Dever::db('main/config')->find();
  1121. $config = Dever::db('shop/buy_order')->config;
  1122. $info = Dever::db('shop/buy_order')->one($id);
  1123. $source_info = Dever::db('factory/info')->find($info['source_id']);
  1124. if ($type == 2) {
  1125. # 仓库
  1126. $member = Dever::db('store/member')->find($user['id']);
  1127. $name = '仓库名称';
  1128. } else {
  1129. # 工厂
  1130. $member = Dever::db('factory/member')->find($user['id']);
  1131. $name = '工厂名称';
  1132. }
  1133. if ($info['type'] == 1) {
  1134. $type_info = Dever::db('shop/info')->find($info['type_id']);
  1135. } elseif ($info['type'] == 2) {
  1136. $type_info = Dever::db('store/info')->find($info['type_id']);
  1137. } elseif ($info['type'] == 3) {
  1138. $type_info = Dever::db('store/info')->find($info['type_id']);
  1139. }
  1140. $cdate = date('Y-m-d H:i', $info['cdate']);
  1141. if ($info['operdate']) {
  1142. $operdate = date('Y-m-d H:i', $info['operdate']);
  1143. } else {
  1144. $operdate = '';
  1145. }
  1146. if ($info['fdate']) {
  1147. $fdate = date('Y-m-d H:i', $info['fdate']);
  1148. } else {
  1149. $fdate = '';
  1150. }
  1151. $status = $config['status'][$info['status']];
  1152. $info['ps_info'] = Dever::db('shop/buy_order_ps')->find(array('order_id' => $info['id']));
  1153. if ($info['ps_info']) {
  1154. $info['ps_info']['service_name'] = '供应商自送';
  1155. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  1156. if ($info['ps_info']['ydate']) {
  1157. $info['ps_info']['ydate'] = date('Y-m-d H:i', $info['ps_info']['ydate']);
  1158. } else {
  1159. $info['ps_info']['ydate'] = '无';
  1160. }
  1161. $ps_status = Dever::db('shop/buy_order_ps')->config['status'];
  1162. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  1163. if ($info['ps_info']['service_id'] > 0) {
  1164. //暂时还没有
  1165. $service = Dever::db('shop/service')->find($info['ps_info']['service_id']);
  1166. $info['ps_info']['service_name'] = $service['name'];
  1167. }
  1168. $info['ps_info']['order_num'] = str_replace("\r\n", ',', $info['ps_info']['order_num']);
  1169. }
  1170. $pdf = Dever::load('pdf/lib/base')->init();
  1171. $pdf->hr('-', $main_config['name']);
  1172. $pdf->br()->font(20)->center('订货单号:' . $info['order_num']);
  1173. $pdf->font(10);
  1174. $pdf->br();
  1175. $pdf->br()->left($name . ':' . $type_info['name'], 80)->left('制单人:' . $member['name'], 60)->left('制单时间:' . date('Y-m-d H:i'), 40);
  1176. $pdf->hr();
  1177. if ($type == 2 && $info['type'] == 2) {
  1178. $pdf->br()->left('订单状态:' . $status, 140)->left('订货时间:' . $operdate, 40);
  1179. $pdf->hr();
  1180. $pdf->br()->left('发货供应商:' . $source_info['name'], 140)->left('发货时间:' . $info['ps_info']['cdate'], 40);
  1181. if ($info['ps_info']) {
  1182. $pdf->br()->left('物流信息:' . $info['ps_info']['service_name'] . ' 物流单号:' . $info['ps_info']['order_num'], 140)->left('确认收货时间:' . $info['ps_info']['ydate'], 40);
  1183. }
  1184. $pdf->hr();
  1185. } else {
  1186. $pdf->br()->left('订单状态:' . $status, 80)->left('订货人:' . $type_info['truename'], 60)->left('订货时间:' . $operdate, 40);
  1187. $pdf->hr();
  1188. $pdf->br()->left('配送至:' . $type_info['name'], 150)->right('收件人联系方式:' . $type_info['truename'] . ',' . $type_info['mobile'], 40);
  1189. $pdf->left('配送地址:' . $type_info['address']);
  1190. $pdf->hr();
  1191. if ($info['ps_info']) {
  1192. $pdf->br()->left('发货时间:' . $info['ps_info']['cdate'], 80)->left('配货员::' . $info['ps_info']['phy'], 70)->left('打包员:' . $info['ps_info']['dby'], 40);
  1193. $pdf->br()->left('包裹重量:' . $info['ps_info']['zl'] . '克', 80)->left('包裹体积:' . $info['ps_info']['tj'] . '立方厘米', 70)->left('包裹数量:' . $info['ps_info']['num'], 40);
  1194. $pdf->br()->left('物流信息:' . $info['ps_info']['service_name'], 40);
  1195. if ($info['ps_info']['order_num']) {
  1196. $pdf->left('物流单号:' . $info['ps_info']['order_num'], 70);
  1197. }
  1198. $pdf->left('到货确认时间:' . $info['ps_info']['ydate']);
  1199. $pdf->hr();
  1200. }
  1201. }
  1202. $body = array();
  1203. $body_total = array();
  1204. $body_total['price'] = 0;
  1205. $body_total['num'] = 0;
  1206. $goods = Dever::db('shop/buy_order_goods')->select(array('order_id' => $info['id']));
  1207. $goods_status = Dever::db('shop/buy_order_goods')->config['status'];
  1208. $refund_body = array();
  1209. $refund_body_total = array();
  1210. $refund_body_total['price'] = 0;
  1211. $refund_body_total['num'] = 0;
  1212. foreach ($goods as $k => $v) {
  1213. if ($type == 1) {
  1214. $v['price'] = $v['p_price'];
  1215. }
  1216. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  1217. $status = $goods_status[$v['status']];
  1218. $tk = Dever::db('shop/buy_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
  1219. if (isset($goods_info['sku'])) {
  1220. $sku = $goods_info['sku']['string'];
  1221. } else {
  1222. $sku = '无';
  1223. }
  1224. $d = array
  1225. (
  1226. $goods_info['id'],
  1227. $goods_info['name'],
  1228. $sku,
  1229. $v['price'],
  1230. 'x ' . $v['num'],
  1231. );
  1232. if ($type == 2) {
  1233. unset($d[3]);
  1234. }
  1235. if ($tk && $v['status'] == 3 && $tk['status'] != 3) {
  1236. $refund_body[] = $d;
  1237. $refund_body_total['price'] += $v['price'];
  1238. $refund_body_total['num'] += $v['num'];
  1239. } else {
  1240. $body[] = $d;
  1241. $body_total['price'] += $v['price'];
  1242. $body_total['num'] += $v['num'];
  1243. }
  1244. }
  1245. $head = array(array('商品编号', 40), array('商品名称', 60), array('商品属性', 40), array('单价', 40), array('数量', 20));
  1246. if ($type == 2) {
  1247. unset($head[3]);
  1248. $head[1][1] = 70;
  1249. $head[2][1] = 60;
  1250. }
  1251. if ($body) {
  1252. $pdf->center('订单商品');
  1253. $pdf->br();
  1254. foreach ($head as $k => $v) {
  1255. $pdf->left($v[0], $v[1]);
  1256. }
  1257. foreach ($body as $k => $v) {
  1258. $pdf->br();
  1259. foreach ($head as $k1 => $v1) {
  1260. $pdf->left($v[$k1], $v1[1]);
  1261. }
  1262. }
  1263. $pdf->br();
  1264. $pdf->right('共'.$body_total['num'].'件商品,合计金额¥' . $body_total['price'] . '元');
  1265. $pdf->hr();
  1266. }
  1267. if ($refund_body) {
  1268. $pdf->center('缺货与报损商品');
  1269. $pdf->br();
  1270. foreach ($head as $k => $v) {
  1271. $pdf->left($v[0], $v[1]);
  1272. }
  1273. foreach ($refund_body as $k => $v) {
  1274. $pdf->br();
  1275. foreach ($head as $k1 => $v1) {
  1276. $pdf->left($v[$k1], $v1[1]);
  1277. }
  1278. }
  1279. $pdf->br();
  1280. if ($type == 2) {
  1281. $pdf->right('共'.$body_total['num'].'件商品');
  1282. } else {
  1283. $pdf->right('共'.$body_total['num'].'件商品,合计金额¥' . $body_total['price'] . '元');
  1284. }
  1285. $pdf->hr();
  1286. }
  1287. $pdf->br(1);
  1288. $pdf->right('如遇任何问题请致电客服');
  1289. $pdf->br();
  1290. $pdf->font(20);
  1291. $pdf->left($main_config['name'], 160);
  1292. $pdf->font(10);
  1293. $pdf->right('电话:' . $factory_config['phone'], 30);
  1294. $pdf->br();
  1295. $pdf->left($main_config['site'], 160);
  1296. $pdf->font(10);
  1297. $pdf->right($main_config['worktime'], 30);
  1298. $pdf->out('订货单');
  1299. }
  1300. }