Out.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605
  1. <?php
  2. namespace Mshop\Lib;
  3. use Dever;
  4. class Out
  5. {
  6. # 1是门店,2是仓库
  7. public $type = 1;
  8. # 1是列表,2是详情
  9. public $view = 1;
  10. # 获取配置
  11. public $config = array();
  12. # table
  13. public $table = 'shop/out_order';
  14. public function __construct()
  15. {
  16. $this->config = Dever::db($this->table)->config;
  17. }
  18. # 设置订单的类型
  19. public function set($type, $view)
  20. {
  21. $this->type = $type;
  22. $this->view = $view;
  23. return $this;
  24. }
  25. # 获取公共的where
  26. public function where($id)
  27. {
  28. $where = array();
  29. $where['type'] = $this->type;
  30. $where['type_id'] = $id;
  31. if (!$where) {
  32. Dever::alert('参数错误');
  33. }
  34. return $where;
  35. }
  36. # 采购订单列表
  37. public function getList($id)
  38. {
  39. $where = $this->where($id);
  40. $data['search_value'] = $where;
  41. $data['search_value']['day'] = $day = Dever::input('day');
  42. if ($day) {
  43. $where['start'] = Dever::maketime($day . ' 00:00:00');
  44. $where['end'] = Dever::maketime($day . ' 23:59:59');
  45. }
  46. $result['search_value']['start'] = $start = Dever::input('start');
  47. $result['search_value']['end'] = $end = Dever::input('end');
  48. if ($start && $end) {
  49. $where['start'] = Dever::maketime($start);
  50. $where['end'] = Dever::maketime($end);
  51. }
  52. $order_num = Dever::input('order_num');
  53. if ($order_num) {
  54. $where['order_num'] = $order_num;
  55. }
  56. $status = Dever::input('status');
  57. if ($status) {
  58. $where['status'] = $status;
  59. }
  60. $out_type = Dever::input('out_type');
  61. if ($out_type) {
  62. $where['out_type'] = $out_type;
  63. }
  64. $excel = Dever::input('excel', 1);
  65. if ($excel == 2) {
  66. $data['order'] = Dever::db('shop/out_order')->getData($where);
  67. } else {
  68. $data['order'] = Dever::db('shop/out_order')->getAll($where);
  69. }
  70. if ($data['order']) {
  71. foreach ($data['order'] as $k => $v) {
  72. $data['order'][$k] = $this->getInfo($v);
  73. }
  74. }
  75. return $data;
  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 action($type_id, $name, $num, $goods, $price, $member_id, $out_type, $info, $status = 2, $area = '')
  93. {
  94. $order_data = $this->where($type_id);
  95. if ($area) {
  96. $order_data['area'] = $area . ',' . $type_id;
  97. }
  98. $order_data['name'] = $name;
  99. $order_data['num'] = $num;
  100. $order_data['info'] = $info;
  101. $order_data['out_type'] = $out_type;
  102. $order_data['price'] = $price;
  103. $order_data['member_id'] = $member_id;
  104. $order_data['status'] = $status;
  105. $order_data['order_num'] = $this->getOrderId();
  106. $id = Dever::db('shop/out_order')->insert($order_data);
  107. if (!$id) {
  108. Dever::alert('出库失败');
  109. }
  110. foreach($goods as $k => $v) {
  111. if ($v['ku_state'] == 1) {
  112. $data['order_id'] = $id;
  113. $data['goods_id'] = $v['id'];
  114. $data['sku_id'] = $v['sku_id'];
  115. $data['price'] = $v['price'];
  116. $data['num'] = $v['buy_num'];
  117. $state = Dever::db('shop/out_order_goods')->insert($data);
  118. if ($state) {
  119. # 出库成功 去掉库存
  120. Dever::load('shop/lib/goods')->oper($order_data, 2, 1, array($data));
  121. }
  122. }
  123. }
  124. return array('order_id' => $id);
  125. }
  126. # 生成订单号
  127. public function getOrderId()
  128. {
  129. $where['order_num'] = Dever::order('OUT');
  130. $state = Dever::db('shop/out_order')->one($where);
  131. if (!$state) {
  132. return $where['order_num'];
  133. } else {
  134. return $this->getOrderId();
  135. }
  136. }
  137. # 审核出库单
  138. public function yes_api()
  139. {
  140. $id = Dever::input('id');
  141. $order_id = Dever::input('order_id');
  142. $this->set(2, 1);
  143. $info = $this->getView($id, $order_id, false);
  144. if ($info && $info['status'] == 1) {
  145. $where['where_id'] = $info['id'];
  146. $where['status'] = 2;
  147. $state = Dever::db('shop/out_order')->update($where);
  148. }
  149. return 'reload';
  150. }
  151. # 取消出库单
  152. public function cancel($id, $order_id)
  153. {
  154. $info = $this->getView($id, $order_id, false);
  155. if ($info && $info['status'] == 1) {
  156. $where['where_id'] = $info['id'];
  157. $where['status'] = 3;
  158. $state = Dever::db('shop/out_order')->update($where);
  159. if ($state) {
  160. # 取消成功,恢复库存
  161. $goods = Dever::db('shop/out_order_goods')->select(array('order_id' => $info['id']));
  162. if ($goods) {
  163. Dever::load('shop/lib/goods')->oper($info, 1, 1, $goods);
  164. }
  165. }
  166. }
  167. return 'ok';
  168. }
  169. # 获取订单详细信息
  170. private function getInfo($info, $view = false)
  171. {
  172. $info['goods'] = Dever::db('shop/out_order_goods')->select(array('order_id' => $info['id']));
  173. $info['cdate'] = date('Y-m-d H:i', $info['cdate']);
  174. $type = Dever::db('shop/out_order')->config['config_type'];
  175. $type = $type();
  176. $info['type_name'] = $type[$info['out_type']]['name'];
  177. $status = Dever::db('shop/out_order')->config['config_status'];
  178. $info['status_name'] = $status[$info['status']];
  179. if ($view || $this->view == 2) {
  180. foreach ($info['goods'] as $k => $v) {
  181. $info['goods'][$k]['info'] = Dever::load('goods/lib/info')->getPayInfo($v['goods_id'], $v['sku_id']);
  182. }
  183. $info['member'] = Dever::db('shop/member')->find($info['member_id']);
  184. }
  185. return $info;
  186. }
  187. # 展示订单详情
  188. public function show()
  189. {
  190. $id = Dever::input('order_id');
  191. $type = Dever::input('type', 1);
  192. $config = Dever::db('shop/out_order')->config;
  193. $info = Dever::db('shop/out_order')->one($id);
  194. $status = $config['config_status'][$info['status']];
  195. $config_type = $config['config_type'];
  196. $config_type = $config_type();
  197. if (isset($config_type[$info['out_type']])) {
  198. $out_type = $config_type[$info['out_type']]['name'];
  199. } else {
  200. $out_type = '其他';
  201. }
  202. $cdate = date('Y-m-d H:i', $info['cdate']);
  203. if ($info['type'] == 1) {
  204. $type_info = Dever::db('shop/info')->find($info['type_id']);
  205. $member = Dever::db('shop/member')->find($info['member_id']);
  206. $name = '门店名称';
  207. } elseif ($info['type'] == 2) {
  208. $type_info = Dever::db('store/info')->find($info['type_id']);
  209. $member = Dever::db('store/member')->find($info['member_id']);
  210. $name = '仓库名称';
  211. }
  212. $result = array();
  213. $result[$info['order_num']] = array
  214. (
  215. 'type' => 'info',
  216. 'content' => array
  217. (
  218. array
  219. (
  220. array($name, $type_info['name']),
  221. array('出库单状态', $status),
  222. array('填单时间', $cdate),
  223. ),
  224. array
  225. (
  226. array('填单人', $member['name']),
  227. array('出库类别', $out_type),
  228. array('原因备注', $info['info']),
  229. ),
  230. )
  231. );
  232. $button = array();
  233. if ($type == 2) {
  234. $config = Dever::load('store/admin/auth.config');
  235. if ($info['status'] == 1) {
  236. $button[] = array
  237. (
  238. 'type' => 'action',
  239. 'link' => Dever::url('admin/out.cancel?order_id='.$info['id'], 'store'),
  240. 'name' => '取消',
  241. );
  242. }
  243. $config['phone'] = '您的专属客服:' . $config['kf_name'] . ',联系电话:' . $config['phone'];
  244. $button[] = array
  245. (
  246. 'type' => 'link',
  247. 'link' => Dever::url('admin/out.print?id=' . $info['id'] . '&type=2', 'store'),
  248. 'name' => '打印出库单',
  249. );
  250. $button[] = array
  251. (
  252. 'type' => 'link',
  253. 'link' => Dever::url('lib/out.excel_one?show=2&type='.$info['type'].'&id='.$info['id'], 'mshop'),
  254. 'name' => '导出',
  255. );
  256. $button[] = array
  257. (
  258. 'type' => 'alert',
  259. 'content' => $config['phone'],
  260. 'name' => '联系平台',
  261. );
  262. } elseif ($info['status'] == 1) {
  263. $button[] = array
  264. (
  265. 'type' => 'action',
  266. 'link' => Dever::url('lib/out.yes?id='.$info['type_id'].'&order_id='.$info['id'], 'mshop'),
  267. 'name' => '审核',
  268. );
  269. $button[] = array
  270. (
  271. 'type' => 'link',
  272. 'link' => Dever::url('lib/out.excel_one?type='.$info['type'].'&id='.$info['id'], 'mshop'),
  273. 'name' => '导出',
  274. );
  275. }
  276. $body = array();
  277. $body_total = array();
  278. $body_total['price'] = 0;
  279. $body_total['num'] = 0;
  280. $goods = Dever::db('shop/out_order_goods')->select(array('order_id' => $info['id']));
  281. $goods_status = Dever::db('shop/out_order_goods')->config['status'];
  282. foreach ($goods as $k => $v) {
  283. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  284. $status = $goods_status[$v['status']];
  285. if (isset($goods_info['sku'])) {
  286. $sku = $goods_info['sku']['string'];
  287. } else {
  288. $sku = '无';
  289. }
  290. $d = array
  291. (
  292. 'pic' => $goods_info['cover'],
  293. 'name' => $goods_info['name'],
  294. 'sku' => $sku,
  295. 'price' => $v['price'],
  296. 'num' => $v['num'],
  297. );
  298. if ($info['type'] == 2) {
  299. unset($d['price']);
  300. }
  301. $body[] = $d;
  302. $price = $v['price']*$v['num'];
  303. $body_total['price'] += $price;
  304. $body_total['num'] += $v['num'];
  305. }
  306. if ($body) {
  307. if ($info['type'] == 2) {
  308. unset($body_total['price']);
  309. }
  310. $result['出库商品清单'] = array
  311. (
  312. 'type' => 'list',
  313. 'content' => $body,
  314. 'total' => $body_total,
  315. );
  316. }
  317. $head = array
  318. (
  319. 'name' => '基本信息',
  320. 'btn' => $button,
  321. );
  322. $html = Dever::show($head, $result);
  323. return $html;
  324. }
  325. public function printer($user)
  326. {
  327. $id = Dever::input('id');
  328. $type = Dever::input('type', 2);
  329. $factory_config = Dever::db('main/factory_config')->find();
  330. $main_config = Dever::db('main/config')->find();
  331. $config = Dever::db('main/config')->find();
  332. $config = Dever::db('shop/out_order')->config;
  333. $info = Dever::db('shop/out_order')->one($id);
  334. if ($info['type'] == 1) {
  335. $type_info = Dever::db('shop/info')->find($info['type_id']);
  336. $member = Dever::db('shop/member')->find($info['member_id']);
  337. } elseif ($info['type'] == 2) {
  338. $type_info = Dever::db('store/info')->find($info['type_id']);
  339. $member = Dever::db('store/member')->find($info['member_id']);
  340. }
  341. $status = $config['config_status'][$info['status']];
  342. $config_type = $config['config_type'];
  343. $config_type = $config_type();
  344. if (isset($config_type[$info['out_type']])) {
  345. $out_type = $config_type[$info['out_type']]['name'];
  346. } else {
  347. $out_type = '其他';
  348. }
  349. $cdate = date('Y-m-d H:i', $info['cdate']);
  350. $pdf = Dever::load('pdf/lib/base')->init();
  351. $pdf->hr('-', $main_config['name']);
  352. $pdf->br()->font(20)->center('出库单号:' . $info['order_num']);
  353. $pdf->font(10);
  354. $pdf->br(2);
  355. $pdf->br()->left('仓库名称:' . $type_info['name'], 80)->left('制单人:' . $user['name'], 60)->left('制单时间:' . date('Y-m-d H:i'), 40);
  356. $pdf->hr();
  357. $pdf->br()->left('出库单状态:' . $status, 140)->left('出库填单时间:' . $cdate, 40);
  358. $pdf->left('出库类别:' . $out_type);
  359. $pdf->left('原因备注:' . $info['info']);
  360. $pdf->hr();
  361. $head = array(array('商品编号', 40), array('商品名称', 70), array('商品属性', 60), array('出库数量', 20));
  362. $data = Dever::db('shop/out_order_goods')->select(array('order_id' => $info['id']));
  363. if ($data) {
  364. $body = array();
  365. $body_total = array();
  366. $body_total['num'] = 0;
  367. foreach ($data as $k => $v) {
  368. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  369. if (isset($goods_info['sku'])) {
  370. $sku = $goods_info['sku']['string'];
  371. } else {
  372. $sku = '';
  373. }
  374. $body[] = array
  375. (
  376. $goods_info['id'],
  377. $goods_info['name'],
  378. $sku,
  379. 'x ' . $v['num'],
  380. );
  381. $body_total['num'] += $v['num'];
  382. }
  383. $pdf->br();
  384. foreach ($head as $k => $v) {
  385. $pdf->left($v[0], $v[1]);
  386. }
  387. foreach ($body as $k => $v) {
  388. $pdf->br();
  389. foreach ($head as $k1 => $v1) {
  390. $pdf->left($v[$k1], $v1[1]);
  391. }
  392. }
  393. $pdf->br();
  394. $pdf->right('共'.$body_total['num'].'件商品');
  395. $pdf->hr();
  396. }
  397. $pdf->br(1);
  398. $pdf->right('如遇任何问题请致电客服');
  399. $pdf->br();
  400. $pdf->font(20);
  401. $pdf->left($main_config['name'], 160);
  402. $pdf->font(10);
  403. $pdf->right('电话:' . $factory_config['phone'], 30);
  404. $pdf->br();
  405. $pdf->left($main_config['site'], 160);
  406. $pdf->font(10);
  407. $pdf->right($main_config['worktime'], 30);
  408. $pdf->out('库存清单');
  409. }
  410. # 导出单个订单
  411. public function excel_one_api()
  412. {
  413. $this->type = Dever::input('type');
  414. $id = Dever::input('id');
  415. $data = Dever::db('shop/out_order')->select($id);
  416. $this->excel($data);
  417. }
  418. # 导出订单
  419. public function excel($data)
  420. {
  421. if (!$data) {
  422. Dever::alert('无导出数据');
  423. }
  424. $file = '出库订单';
  425. $type = Dever::input('search_option_type', $this->type);
  426. $header = array('所属仓库', '出库单号', '商品名称', '商品规格属性', '商品采购价格', '商品出库数量', '采购总价格', '出库类型', '出库状态', '出库时间');
  427. $table = 'store/info';
  428. if ($type == 1) {
  429. $header[0] = '所属门店';
  430. $header[4] = '商品销售价格';
  431. $header[6] = '销售总价格';
  432. $table = 'shop/info';
  433. }
  434. $show = Dever::input('show', 1);
  435. if ($type == 2) {
  436. unset($header[4]);
  437. unset($header[6]);
  438. }
  439. $body = array();
  440. $out_type = Dever::db('shop/out_type')->getAll();
  441. $status = Dever::db('shop/out_order')->config['config_status'];
  442. foreach ($data as $k => $v) {
  443. if (!is_array($v)) {
  444. continue;
  445. }
  446. $type_info = Dever::db($table)->find($v['type_id']);
  447. $goods = Dever::db('shop/out_order_goods')->select(array('order_id' => $v['id']));
  448. if (isset($out_type[$v['out_type']]) && $out_type[$v['out_type']]) {
  449. $out_type_name = $out_type[$v['out_type']]['name'];
  450. } else {
  451. $out_type_name = '其他';
  452. }
  453. $status_name = $status[$v['status']];
  454. $cdate = strstr($v['cdate'], '-') ? $v['cdate'] : date('Y-m-d H:i', $v['cdate']);
  455. foreach ($goods as $k1 => $v1) {
  456. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  457. if (isset($goods_info['sku'])) {
  458. $sku = $goods_info['sku']['string'];
  459. } else {
  460. $sku = '';
  461. }
  462. $d = array
  463. (
  464. $type_info['name'],
  465. $v['order_num'],
  466. $goods_info['name'],
  467. $sku,
  468. $v1['price'],
  469. $v1['num'],
  470. $v1['price']*$v1['num'],
  471. $out_type_name,
  472. $status_name,
  473. $cdate,
  474. );
  475. if ($type == 2) {
  476. unset($d[4]);
  477. unset($d[6]);
  478. }
  479. $body[] = $d;
  480. }
  481. }
  482. Dever::excelExport($body, $header, $file);
  483. }
  484. }