Dhorder.php 64 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660
  1. <?php
  2. namespace Agent\Lib;
  3. use Dever;
  4. class Dhorder
  5. {
  6. # 获取配置
  7. public $config = array();
  8. # table
  9. public $table = 'agent/dh_order';
  10. public function __construct()
  11. {
  12. $this->config = Dever::db($this->table)->config;
  13. }
  14. # 设置订单的类型
  15. public function set($type, $view)
  16. {
  17. return $this;
  18. }
  19. # 获取公共的where
  20. public function where($id)
  21. {
  22. $where = array();
  23. $where['mid'] = $id;
  24. if (!$where) {
  25. Dever::alert('参数错误');
  26. }
  27. return $where;
  28. }
  29. # 获取订单列表
  30. public function getList($id)
  31. {
  32. $result = array();
  33. $where = $this->where($id);
  34. $mobile = Dever::input('mobile');
  35. if ($mobile) {
  36. $where['mobile'] = $mobile;
  37. }
  38. $status = Dever::input('status');
  39. if ($status) {
  40. $where['status'] = $status;
  41. }
  42. $result['order'] = Dever::db($this->table)->getAll($where);
  43. if ($result['order']) {
  44. foreach ($result['order'] as $k => $v) {
  45. $result['order'][$k] = $this->getInfo($v, false);
  46. }
  47. }
  48. return $result;
  49. }
  50. # 查看详情
  51. public function getView($id, $order_id, $show = true)
  52. {
  53. $where = $this->where($id);
  54. $where['id'] = $order_id;
  55. $result = Dever::db($this->table)->find($where);
  56. if (!$result) {
  57. Dever::alert('订单不存在');
  58. }
  59. if ($show) {
  60. $result = $this->getInfo($result);
  61. }
  62. return $result;
  63. }
  64. # 获取订单详细信息
  65. public function getInfo($info, $view = true)
  66. {
  67. $info['status_name'] = Dever::status($this->config['status'], $info['status']);
  68. $info['cdate'] = date('Y-m-d H:i', $info['cdate']);
  69. if ($info['operdate']) {
  70. $info['operdate'] = date('Y-m-d H:i', $info['operdate']);
  71. } else {
  72. $info['operdate'] = '';
  73. }
  74. if ($info['fdate']) {
  75. $info['fdate'] = date('Y-m-d H:i', $info['fdate']);
  76. } else {
  77. $info['fdate'] = '';
  78. }
  79. if ($view && $info['type'] == 1) {
  80. $info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
  81. if ($info['ps_info']) {
  82. $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
  83. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  84. if ($info['ps_info']['qu_date']) {
  85. $info['ps_info']['qu_date'] = date('Y-m-d H:i', $info['ps_info']['qu_date']);
  86. }
  87. if ($info['ps_info']['qs_date']) {
  88. $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
  89. }
  90. $status = Dever::db('agent/dh_order_ps')->config['status'];
  91. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  92. if ($info['ps_info']['service']) {
  93. foreach ($info['ps_info']['service'] as $k => $v) {
  94. if (isset($v['order_num']) && $v['order_num']) {
  95. $info['ps_info']['service'][$k]['service_name'] = '商家自送';
  96. if ($v['service_id'] > 0) {
  97. $service = Dever::db('shop/service')->find($v['service_id']);
  98. $info['ps_info']['service'][$k]['service_name'] = $service['name'];
  99. }
  100. } else {
  101. unset($info['ps_info']['service'][$k]);
  102. }
  103. }
  104. }
  105. }
  106. $goods_status = Dever::db('agent/dh_order_goods')->config['status'];
  107. if ($info['address_id']) {
  108. $info['address'] = Dever::db('agent/member_address')->find($info['address_id']);
  109. }
  110. $info['goods'] = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
  111. foreach ($info['goods'] as $k => $v) {
  112. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  113. if (isset($goods_info['sku'])) {
  114. $sku = $goods_info['sku']['string'];
  115. } else {
  116. $sku = '';
  117. }
  118. $info['goods'][$k] += array
  119. (
  120. 'pic' => $goods_info['cover'],
  121. 'name' => $goods_info['name'],
  122. 'sku' => $sku,
  123. 'price' => $goods_info['price'],
  124. );
  125. }
  126. }
  127. if ($info['type'] == 2) {
  128. $info['card'] = Dever::db('card/info')->find($info['type_id']);
  129. }
  130. if ($info['type'] == 3) {
  131. $info['prize'] = Dever::db('setting/prize')->find($info['type_id']);
  132. }
  133. return $info;
  134. }
  135. # 取消订单
  136. public function cancel($id, $order_id)
  137. {
  138. $data = $this->getView($id, $order_id, false);
  139. if ($data['status'] == 1) {
  140. $state = Dever::db('agent/dh_order')->update(array('where_id' => $data['id'], 'status' => 7, 'operdate' => time()));
  141. if ($state) {
  142. $this->updateSell($data, 2);
  143. }
  144. return 'ok';
  145. } else {
  146. Dever::alert('当前订单状态不允许取消');
  147. }
  148. }
  149. # 得到商品和总价
  150. public function goods($mid)
  151. {
  152. $goods_id = Dever::input('goods_id');
  153. if (!$goods_id) {
  154. Dever::alert('请传入商品');
  155. }
  156. $goods_id = explode(',', $goods_id);
  157. $num = Dever::input('num');
  158. if (!$num) {
  159. Dever::alert('请传入商品数量');
  160. }
  161. $num = explode(',', $num);
  162. $data['price'] = 0;
  163. $data['num'] = 0;
  164. $data['name'] = array();
  165. $count = count($goods_id);
  166. $data['list'] = array();
  167. $i = 0;
  168. foreach ($goods_id as $k => $v) {
  169. $n = isset($num[$k]) ? $num[$k] : 1;
  170. $data['list'][$i] = Dever::db('agent/member_goods')->find(array('mid' => $mid, 'id' => $v));
  171. if ($data['list'][$i]) {
  172. $data['list'][$i]['num'] = $n;
  173. # 2是库存不足
  174. $data['list'][$i]['ku_state'] = 1;
  175. $total = $data['list'][$i]['total_num'] - $data['list'][$i]['sell_num'];
  176. if ($total >= $n) {
  177. $data['list'][$i]['buy_num'] = $n;
  178. } else {
  179. $data['list'][$i]['buy_num'] = $total;
  180. }
  181. if ($data['list'][$i]['buy_num'] <= 0) {
  182. $data['list'][$i]['ku_state'] = 2;
  183. $data['list'][$i]['buy_num'] = 0;
  184. }
  185. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($data['list'][$i]['type_id'], $data['list'][$i]['sku_id']);
  186. if (isset($goods_info['sku'])) {
  187. $sku = $goods_info['sku']['string'];
  188. } else {
  189. $sku = '';
  190. }
  191. $data['list'][$i] += array
  192. (
  193. 'pic' => $goods_info['cover'],
  194. 'name' => $goods_info['name'],
  195. 'sku' => $sku,
  196. 'price' => $goods_info['price'],
  197. );
  198. if ($data['list'][$i]['ku_state'] == 1) {
  199. $data['num'] += $data['list'][$i]['buy_num'];
  200. $data['price'] += $goods_info['price'] * $data['list'][$i]['buy_num'];
  201. $data['name'] = '兑换商品';
  202. }
  203. $i++;
  204. }
  205. }
  206. if ($data['num'] <= 0) {
  207. Dever::alert('没有商品可以兑换');
  208. }
  209. return $data;
  210. }
  211. # 确认兑换
  212. public function action($user, $name, $num, $price, $goods, $address_id, $dh_type, $type, $type_id, $info, $refer = '')
  213. {
  214. # 获取平台店
  215. $shop = Dever::db('shop/info')->find(array('type' => 10));
  216. if (!$shop) {
  217. Dever::alert('没有平台店');
  218. }
  219. $order_data['shop_id'] = $shop['id'];
  220. $order_data['mid'] = $user['id'];
  221. $order_data['mobile'] = $user['mobile'];
  222. $order_data['address_id'] = $address_id;
  223. $order_data['name'] = $name;
  224. $order_data['num'] = $num;
  225. $order_data['info'] = $info;
  226. $order_data['price'] = $price;
  227. $order_data['dh_type'] = $dh_type;
  228. $order_data['type'] = $type;
  229. if ($type_id) {
  230. $order_data['type_id'] = $type_id;
  231. }
  232. if ($dh_type == 2) {
  233. $order_data['status'] = 5;
  234. } else {
  235. $order_data['status'] = 2;
  236. }
  237. $order_data['refund_cash'] = 0;
  238. $order_data['audit'] = 2;
  239. if ($type == 1) {
  240. $time = time();
  241. $order_data_where = $order_data;
  242. $order_data_where['start'] = $time - 60;
  243. $order_data_where['end'] = $time;
  244. $order_data_where['option']['start'] = array('yes-cdate', '>=');
  245. $order_data_where['option']['end'] = array('yes-cdate', '<=');
  246. $info = Dever::db('agent/dh_order')->find($order_data_where);
  247. } else {
  248. $info = false;
  249. }
  250. $order_data['order_num'] = $this->getOrderId();
  251. if (!$info) {
  252. $id = Dever::db('agent/dh_order')->insert($order_data);
  253. } else {
  254. return array
  255. (
  256. 'order' => '',
  257. 'order_num' => $info['order_num'],
  258. 'order_id' => $info['id'],
  259. 'type' => 'test',
  260. );
  261. }
  262. if (!$id) {
  263. Dever::alert('兑换失败');
  264. }
  265. if ($goods) {
  266. foreach($goods as $k => $v) {
  267. if ($v['ku_state'] == 1) {
  268. $data['mid'] = $user['id'];
  269. $data['order_id'] = $id;
  270. $data['shop_id'] = $shop['id'];
  271. $data['goods_id'] = $v['type_id'];
  272. $data['sku_id'] = $v['sku_id'];
  273. $data['price'] = $v['price'];
  274. $data['num'] = $v['buy_num'];
  275. Dever::db('agent/dh_order_goods')->insert($data);
  276. }
  277. }
  278. }
  279. # 减少库存 增加销量
  280. $order_data['id'] = $id;
  281. $this->updateSell($order_data);
  282. return array
  283. (
  284. 'order_num' => $order_data['order_num'],
  285. 'order_id' => $id,
  286. 'type' => 'dh',
  287. );
  288. }
  289. # 添加配送信息
  290. public function updatePs($order, $status = 1, $service_id = -1, $order_num = '', $cdate = false)
  291. {
  292. $order = Dever::db('agent/dh_order')->find($order['id']);
  293. $where['order_id'] = $order['id'];
  294. $where['clear'] = true;
  295. $data = Dever::db('agent/dh_order_ps')->find($where);
  296. $service = array();
  297. if ($service_id) {
  298. $service['service_id'] = $service_id;
  299. }
  300. if ($order_num) {
  301. $service['order_num'] = $order_num;
  302. }
  303. if (!$data) {
  304. $insert = $where;
  305. if ($service) {
  306. $insert['service'][] = $service;
  307. $insert['service'] = Dever::array_encode($insert['service']);
  308. }
  309. $insert['status'] = $status;
  310. if ($status == 2) {
  311. $insert['qu_date'] = time();
  312. }
  313. $insert['mid'] = $order['mid'];
  314. if ($cdate) {
  315. $insert['cdate'] = $cdate;
  316. }
  317. Dever::db('agent/dh_order_ps')->insert($insert);
  318. } else {
  319. $update = $where;
  320. $update['where_id'] = $data['id'];
  321. $update['status'] = $status;
  322. if ($status == 2) {
  323. $update['qu_date'] = time();
  324. }
  325. if ($status == 3) {
  326. $update['qs_date'] = time();
  327. }
  328. if ($service) {
  329. $data['service'] = Dever::array_decode($data['service']);
  330. $update['service'] = $data['service'];
  331. $update['service'][] = $service;
  332. $update['service'] = Dever::array_encode($update['service']);
  333. }
  334. $update['mid'] = $order['mid'];
  335. if ($cdate) {
  336. $update['cdate'] = $cdate;
  337. }
  338. Dever::db('agent/dh_order_ps')->update($update);
  339. }
  340. }
  341. # 减少库存,增加销量
  342. public function updateSell($order, $type = 1)
  343. {
  344. $method = 'incSell';
  345. $name = '兑换商品';
  346. $name_3 = '兑换名额';
  347. if ($type == 2) {
  348. $method = 'decSell';
  349. $name = '退回商品';
  350. $name_3 = '退回名额';
  351. }
  352. if ($order['type'] == 1) {
  353. $where['order_id'] = $order['id'];
  354. //$where['status'] = 3;
  355. $data = Dever::db('agent/dh_order_goods')->select($where);
  356. if ($data) {
  357. foreach ($data as $k => $v) {
  358. $up = array();
  359. $up['where_mid'] = $order['mid'];
  360. $up['where_type'] = $order['type'];
  361. $up['where_type_id'] = $v['goods_id'];
  362. $up['where_sku_id'] = $v['sku_id'];
  363. $up['clear'] = true;
  364. $info = Dever::db('agent/member_goods')->findData($up);
  365. $up['set_sell_num'] = $v['num'];
  366. Dever::db('agent/member_goods')->$method($up);
  367. if ($type == 2) {
  368. Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']+$up['set_sell_num'], $info['name'], $name);
  369. } else {
  370. Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']-$up['set_sell_num'], $info['name'], $name);
  371. }
  372. }
  373. }
  374. } elseif ($order['type'] == 3) {
  375. $up['where_mid'] = $order['mid'];
  376. $up['where_type'] = $order['type'];
  377. $up['where_type_id'] = $order['type_id'];
  378. $up['where_sku_id'] = -1;
  379. $info = Dever::db('agent/member_goods')->findData($up);
  380. $up['set_sell_num'] = $order['num'];
  381. Dever::db('agent/member_goods')->$method($up);
  382. if ($type == 2) {
  383. Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']+$up['set_sell_num'], $info['name'], $name_3);
  384. } else {
  385. Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']-$up['set_sell_num'], $info['name'], $name_3);
  386. }
  387. }
  388. }
  389. # 完成
  390. public function finish($info, $shop_id)
  391. {
  392. if ($info && $info['shop_id'] == $shop_id && $info['status'] <= 4) {
  393. $status = 5;
  394. $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => $status, 'fdate' => time()));
  395. $this->updatePs($info, 3);
  396. $w['parent_type'] = 3;
  397. $w['parent_order_id'] = $info['id'];
  398. $w['status'] = 4;
  399. $buy_order = Dever::db('shop/buy_order')->select($w);
  400. if ($buy_order) {
  401. foreach ($buy_order as $k => $v) {
  402. Dever::load('mshop/lib/buy')->set(1,1)->finish($shop_id, $v['id']);
  403. }
  404. }
  405. return 'ok';
  406. } else {
  407. Dever::alert('您没有权限核销');
  408. }
  409. }
  410. # 平台订单已收货
  411. public function yes_api()
  412. {
  413. $shop_id = Dever::input('shop_id');
  414. $order_id = Dever::input('order_id');
  415. $info = Dever::db('agent/dh_order')->find(array('id' => $order_id));
  416. if ($info && $info['type'] == 10) {
  417. $this->finish($info, $shop_id);
  418. } else {
  419. Dever::alert('您没有权限核销');
  420. }
  421. return 'reload';
  422. }
  423. # 生成订单号
  424. public function getOrderId()
  425. {
  426. $where['order_num'] = Dever::order('DH');
  427. $state = Dever::db('agent/dh_order')->one($where);
  428. if (!$state) {
  429. return $where['order_num'];
  430. } else {
  431. return $this->getOrderId();
  432. }
  433. }
  434. # 展示订单详情
  435. public function show()
  436. {
  437. $id = Dever::input('order_id');
  438. $config = Dever::db('agent/dh_order')->config;
  439. $info = Dever::db('agent/dh_order')->one($id);
  440. if ($info['type'] > 1) {
  441. return;
  442. }
  443. $tk_status = Dever::db('agent/dh_order_refund')->config['status'];
  444. $tk_process = Dever::db('agent/dh_order_refund')->config['process'];
  445. $status = $config['status'][$info['status']];
  446. $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'type' => 1));
  447. $shop = Dever::db('shop/info')->find($info['shop_id']);
  448. $user = Dever::db('agent/member')->find($info['mid']);
  449. $cdate = date('Y-m-d H:i', $info['cdate']);
  450. if ($info['operdate']) {
  451. $opertime = date('Y-m-d H:i', $info['operdate']);
  452. } else {
  453. $opertime = '';
  454. }
  455. if ($info['fdate']) {
  456. $fdate = date('Y-m-d H:i', $info['fdate']);
  457. } else {
  458. $fdate = '';
  459. }
  460. if (!$user) {
  461. $user['username'] = '无';
  462. }
  463. if (!isset($user['name'])) {
  464. $user['truename'] = $user['name'];
  465. }
  466. if ($tk && $tk['process'] == 1) {
  467. $status = '申请' . $tk_status[$tk['status']];
  468. $process = $tk_process[$tk['process']];
  469. $process = '';
  470. }
  471. $time = array();
  472. $time[] = array('下单时间', $cdate);
  473. if ($opertime) {
  474. if ($info['status'] == 2) {
  475. $time[] = array('通知时间', $opertime);
  476. }
  477. if ($info['status'] == 7) {
  478. $time[] = array('取消时间', $opertime);
  479. }
  480. }
  481. if ($fdate) {
  482. $time[] = array('完成时间', $fdate);
  483. }
  484. $time[] = array('审核备注', $info['audit_desc']);
  485. $result = array();
  486. $result[$info['order_num']] = array
  487. (
  488. 'type' => 'info',
  489. 'content' => array
  490. (
  491. array
  492. (
  493. array('订单状态', $status),
  494. array('代理商姓名', $user['name']),
  495. array('联系电话', $info['mobile']),
  496. ),
  497. $time,
  498. )
  499. );
  500. if ($info['address_id'] > 0) {
  501. $address = Dever::load('agent/address')->getOne($info['mid'], $info['address_id']);
  502. if ($address) {
  503. $result['收货地址'] = array
  504. (
  505. 'type' => 'info',
  506. 'content' => array
  507. (
  508. array
  509. (
  510. array('联系人', $address['contact']),
  511. array('联系电话', $address['mobile']),
  512. ),
  513. array
  514. (
  515. array('收货地址', $address['address_info']),
  516. array('门牌号', $address['house_number']),
  517. ),
  518. ),
  519. );
  520. }
  521. }
  522. $info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
  523. if ($info['ps_info']) {
  524. $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
  525. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  526. if ($info['ps_info']['qs_date']) {
  527. $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
  528. } else {
  529. $info['ps_info']['qs_date'] = '无';
  530. }
  531. $status = Dever::db('agent/dh_order_ps')->config['status'];
  532. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  533. $service = array();
  534. if ($info['ps_info']['service']) {
  535. foreach ($info['ps_info']['service'] as $k => $v) {
  536. if (isset($v['order_num']) && $v['order_num']) {
  537. $info['ps_info']['service'][$k]['service_name'] = '商家自送';
  538. if ($v['service_id'] > 0) {
  539. $service_info = Dever::db('shop/service')->find($v['service_id']);
  540. $info['ps_info']['service'][$k]['service_name'] = $service_info['name'];
  541. }
  542. $service[] = array
  543. (
  544. array('名称', $info['ps_info']['service'][$k]['service_name']),
  545. array('单号', isset($v['order_num']) ? $v['order_num'] : ''),
  546. );
  547. }
  548. }
  549. }
  550. $result['物流信息'] = array
  551. (
  552. 'type' => 'info',
  553. 'content' => array
  554. (
  555. array
  556. (
  557. array('发货时间', $info['ps_info']['cdate']),
  558. array('收货时间', $info['ps_info']['qs_date']),
  559. array('查单', '<a href="https://www.kuaidi100.com/?from=openv" target="_blank">点此手动查单</a>'),
  560. ),
  561. ),
  562. );
  563. $result['物流信息']['content'] = array_merge($result['物流信息']['content'], $service);
  564. }
  565. if (!$info['refund_cash']) {
  566. $info['refund_cash'] = 0;
  567. }
  568. if ($info['refund_cash'] > 0 && $tk) {
  569. $process = $tk_process[$tk['process']];
  570. $tk['cdate'] = date('Y-m-d H:i', $tk['cdate']);
  571. $result['退款信息'] = array
  572. (
  573. 'type' => 'info',
  574. 'content' => array
  575. (
  576. array
  577. (
  578. array('退款金额', $info['refund_cash']),
  579. array('数量', $info['num']),
  580. array('退款进度', $process),
  581. ),
  582. array
  583. (
  584. array('申请时间', $tk['cdate']),
  585. array('退款原因', $tk['desc']),
  586. ),
  587. ),
  588. );
  589. }
  590. $body = $refund_body = array();
  591. $body_total = array();
  592. $body_total['price'] = 0;
  593. $body_total['num'] = 0;
  594. $refund_body_total = array();
  595. $refund_body_total['price'] = 0;
  596. $refund_body_total['num'] = 0;
  597. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
  598. $goods_status = Dever::db('agent/dh_order_goods')->config['status'];
  599. foreach ($goods as $k => $v) {
  600. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  601. $status = Dever::status($goods_status, $v['status']);
  602. $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
  603. if ($tk && $tk['process'] == 1) {
  604. $status = '申请' . $tk_status[$tk['status']];
  605. //$status .= '&nbsp;&nbsp;[' . $tk_process[$tk['process']] . ']';
  606. }
  607. if (isset($goods_info['sku'])) {
  608. $sku = $goods_info['sku']['string'];
  609. } else {
  610. $sku = '无';
  611. }
  612. if ($info['status'] > 1 && $info['status'] < 7) {
  613. $tui = Dever::url('buy_order_tui?shop_id='.$v['shop_id'].'&order_goods_id=' . $v['id'] . '&order_id=' . $info['id'] . '&cash=' . $v['price'], 'shop');
  614. $status = '<a href="javascript:;" onclick="fastEdit($(this), \''.$tui.'\', \'退款\', \'\', 1)" class="layui-btn">退款</a>';
  615. $status = '';
  616. }
  617. $d = array
  618. (
  619. 'pic' => $goods_info['cover'],
  620. 'name' => $goods_info['name'],
  621. 'sku' => $sku,
  622. 'price' => $v['price'],
  623. 'num' => $v['num'],
  624. 'status' => $status,
  625. );
  626. if ($tk && $v['status'] == 3) {
  627. $d['status'] = $tk_status[$tk['status']];
  628. $refund_body[] = $d;
  629. $price = $v['price']*$v['num'];
  630. $refund_body_total['price'] += $price;
  631. $refund_body_total['num'] += $v['num'];
  632. } else {
  633. $body[] = $d;
  634. $price = $v['price']*$v['num'];
  635. $body_total['price'] += $price;
  636. $body_total['num'] += $v['num'];
  637. }
  638. }
  639. if ($body) {
  640. if ($refund_body_total['price']) {
  641. $body_total['set_price'] = $body_total['price'] - $refund_body_total['price'];
  642. }
  643. if ($refund_body_total['num']) {
  644. $body_total['set_num'] = $body_total['num'] - $refund_body_total['num'];
  645. }
  646. $result['商品清单'] = array
  647. (
  648. 'type' => 'list',
  649. 'content' => $body,
  650. 'total' => $body_total,
  651. );
  652. }
  653. if ($refund_body) {
  654. $result['退款商品'] = array
  655. (
  656. 'type' => 'list',
  657. 'content' => $refund_body,
  658. 'total' => $refund_body_total,
  659. );
  660. }
  661. # 平台门店采购单
  662. $buy_order = Dever::db('shop/buy_order')->getDataToId(array('type' => 1, 'type_id' => $info['shop_id'], 'parent_type' => 3, 'parent_order_id' => $info['id']));
  663. $source_order_id = array();
  664. if ($buy_order) {
  665. $source_order_id = array_keys($buy_order);
  666. }
  667. # 平台门店结算单
  668. if ($source_order_id) {
  669. $cash_order = Dever::db('cash/order')->getDataByOrderId(array('source_order_id' => $source_order_id));
  670. $col = 'cash';
  671. }
  672. if (isset($cash_order) && $cash_order) {
  673. $head = array('序号', '结算单号', '数量', '金额', '结算类型', '入账状态', '审核状态', '结算时间', '审核备注', '管理');
  674. $body = array();
  675. $config = Dever::db('cash/order')->config;
  676. foreach ($cash_order as $k => $v) {
  677. $cdate = date('Y-m-d H:i', $v['cdate']);
  678. $fdate = $v['fdate'] ? date('Y-m-d H:i', $v['fdate']) : '';
  679. $operdate = $v['operdate'] ? date('Y-m-d H:i', $v['operdate']) : '';
  680. $cash = $v[$col];
  681. $url = Dever::url('project/database/list?project=shop&table=buy_order_goods&order_id='.$v['source_order_id'].'&page_type=1', 'manage');
  682. $v['source_order_num'] = '<a href="'.$url.'" style="color:blue">'.$v['source_order_num'].'</a>';
  683. $m = '';
  684. if ($v['audit'] == 1 && $v['audit_type'] == 2) {
  685. $url = Dever::url('project/database/update?project=cash&table=order&where_id='.$v['id'].'&col=audit,desc', 'manage');
  686. $m = '<a href="javascript:;" onclick="fastEdit($(this), \''.$url.'\', \'审核\', \'\', 1)" class="layui-btn">审核</a>';
  687. }
  688. $d = array
  689. (
  690. $k+1,
  691. $v['order_num'],
  692. $v['num'],
  693. $cash,
  694. $config['config_jstype'][$v['jstype']],
  695. $config['config_status'][$v['status']],
  696. $config['config_audit'][$v['audit']],
  697. $operdate,
  698. $v['desc'],
  699. $m,
  700. );
  701. $body[] = $d;
  702. }
  703. $result['对账清单'] = array
  704. (
  705. 'type' => 'table',
  706. 'content' => array
  707. (
  708. 'head' => $head,
  709. 'body' => $body,
  710. )
  711. );
  712. }
  713. $head_btn[] = array
  714. (
  715. 'type' => 'link',
  716. 'link' => Dever::url('project/database/list?project=agent&table=dh_order&menu=agent&search_option_state=1', 'manage'),
  717. 'name' => '返回上一页',
  718. );
  719. $audit = Dever::input('audit');
  720. if($audit==1){
  721. # 审核信息
  722. $this->show_audit($info, $result);
  723. }
  724. $head = array
  725. (
  726. 'name' => '基本信息',
  727. 'btn' => $head_btn,
  728. );
  729. $html = Dever::show($head, $result);
  730. return $html;
  731. }
  732. private function show_audit($info, &$result)
  733. {
  734. $info['type'] = 3;
  735. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id'], 'status' => 1));
  736. $shop = Dever::db('shop/info')->find($info['shop_id']);
  737. list($data, $source) = Dever::load('mshop/lib/buy')->assign($goods, $info, $shop, true);
  738. // print_R($data);die;
  739. if ($info) {
  740. $head = array('序号', '商品编号', '商品名称', '供货商', '订货总数量', '商品计量单位', '订货单总金额');
  741. $body = array();
  742. $i = 0;
  743. if ($data) {
  744. foreach ($data as $k => $v) {
  745. foreach ($v as $v1) {
  746. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  747. if (isset($goods_info['sku'])) {
  748. $sku = '[' . $goods_info['sku']['string'] . ']';
  749. } else {
  750. $sku = '';
  751. }
  752. $d = array
  753. (
  754. $i+1,
  755. $goods_info['code'],
  756. $goods_info['name'] . $sku,
  757. Dever::load('mshop/lib/buy')->getSelect($source, $v1['source_id'], $v1['order_goods_id']),
  758. $v1['num'],
  759. $goods_info['unit'],
  760. $v1['price'] * $v1['num'],
  761. );
  762. $body[] = $d;
  763. $i++;
  764. }
  765. }
  766. }
  767. if ($goods) {
  768. foreach ($goods as $k => $v) {
  769. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  770. if (isset($goods_info['sku'])) {
  771. $sku = '[' . $goods_info['sku']['string'] . ']';
  772. } else {
  773. $sku = '';
  774. }
  775. $d = array
  776. (
  777. $i+1,
  778. $goods_info['code'],
  779. $goods_info['name'] . $sku,
  780. Dever::load('mshop/lib/buy')->getSelect($source, false, $v['id']),
  781. $v['num'],
  782. $goods_info['unit'],
  783. $v['price'] * $v['num'],
  784. );
  785. $body[] = $d;
  786. $i++;
  787. }
  788. }
  789. $btn = array();
  790. $btn[] = array(
  791. 'type' => 'click',
  792. 'content' => 'setAudit()',
  793. 'name' => '全部调整<script>function setAudit(){layer.confirm(\'确定进行此项操作吗?\', function(){var audit = $(\'.audit_set\').val();$(\'.audit\').each(function(){$(this).val(audit);layui.form.render();layer.closeAll()})})}</script>'
  794. );
  795. $result['商品拆单'] = array
  796. (
  797. 'type' => 'table',
  798. 'head' => array('name' => '供货商:' . Dever::load('mshop/lib/buy')->getSelect($source, false, false), 'btn' => $btn),
  799. 'content' => array
  800. (
  801. 'head' => $head,
  802. 'body' => $body,
  803. )
  804. );
  805. $url = Dever::url('lib/dhorder.audit_set_commit?json=1&order_id=' . $info['id'], 'agent');
  806. // print_R($url);die;
  807. $result['审核结果'] = array
  808. (
  809. 'type' => 'html',
  810. 'content' => '<script>function saveAudit(){var goods = [];var audit = 1; var audit_text = $(".update_audit_text").val();$(".update_audit").each(function(){if ($(this).get(0).checked){audit = $(this).val()}});$(\'.audit\').each(function(){var v = $(this).val();var id = $(this).attr("id");goods.push(v + "_" + id);});layer.confirm(\'确定进行此项操作吗?\', function(){layui.form.render();var send = {};send.goods = goods.join(",");send.audit = audit;send.audit_text = audit_text;console.info(send);$.post("'.$url.'", send, function(t){t = JSON.parse(t);showYes(t)})})}</script><style>.layui-form-radio{padding-right: 0px;margin: 0px 0px 0 0;margin-left:40px}</style><div class="layui-form-item show_input"><div classs="layui-col-lg6"><div><label style="font-size:14px;font-weight:bold;" class="">审核状态</label><div style="display:inline" class="am-btn-group"><input update_type="checked" class="checkbox-checkall-0_update_audit update_audit update_value validate[required]" type="radio" name="update_audit[]" value="2" checked="" show_id="audit" autocomplete="off" id="form-validation-field-1"> 审核通过 &nbsp;&nbsp;<input update_type="checked" class="autoload checkbox-checkall-0_update_audit update_audit update_value validate[required]" type="radio" name="update_audit[]" value="3" autocomplete="off" id="form-validation-field-0"> 审核未通过 &nbsp;&nbsp;</div></div></div></div><div class="layui-form-item" style="display: block;"><div classs="layui-col-lg6"><div><label style="font-size:14px;font-weight:bold;" class="">审核备注</label></div><div><textarea style="height:100px;" update_type="value" class="update_value update_audit_text form-control layui-input validate[required]" name="update_desc"></textarea></div></div></div> <div style="text-align:left" class="layui-layer-btn layui-layer-btn-"><a class="layui-btn layui-btn-primary" onclick="saveAudit()">保存</a><a class="layui-layer-btn1" style="display:none">取消</a></div>',
  811. );
  812. }
  813. }
  814. # 采购订单审核 手动拆单
  815. public function audit_set_commit_api()
  816. {
  817. Dever::config('base')->hook = true;
  818. //{goods: "2_4_audit_615,2_4_audit_614,-1_-1_audit_617,-1_-1_audit_616,-1_-1_audit_613", audit: "1", audit_text: "1231"}
  819. $id = Dever::input('order_id');
  820. $goods = Dever::input('goods');
  821. $audit = Dever::input('audit');
  822. $audit_text = Dever::input('audit_text');
  823. $info = Dever::db('agent/dh_order')->one($id);
  824. if ($audit > 1 && $info && $info['status'] == 2) {
  825. $shop = Dever::db('shop/info')->find($info['shop_id']);
  826. if ($audit == 2) {
  827. Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
  828. # 成功
  829. if (strstr($info['order_num'], '_')) {
  830. $temp = explode('_', $info['order_num']);
  831. $info['order_num'] = $temp[0];
  832. $info['order_index'] = $temp[1];
  833. } else {
  834. $info['order_index'] = 0;
  835. }
  836. $goods = explode(',', $goods);
  837. $data = $other = array();
  838. foreach ($goods as $k => $v) {
  839. list($source_type, $source_id, $name, $goods_id) = explode('_', $v);
  840. $gv = Dever::db('agent/dh_order_goods')->find($goods_id);
  841. if ($source_id > 0) {
  842. $key = $source_type . '_' . $source_id;
  843. $data[$key][] = array
  844. (
  845. 'area' => $shop['area'],
  846. 'order_id' => $info['id'],
  847. 'order_type' => 3,
  848. 'order_num' => $info['order_num'],
  849. 'order_index' => $info['order_index'],
  850. 'type' => 1,
  851. 'type_id' => $shop['id'],
  852. 'source_type' => $source_type,
  853. 'source_id' => $source_id,
  854. 'order_goods_id' => $gv['id'],
  855. 'goods_id' => $gv['goods_id'],
  856. 'sku_id' => $gv['sku_id'],
  857. 'price' => $gv['price'],
  858. 'p_price' => $gv['price'],
  859. 'num' => $gv['num'],
  860. );
  861. } else {
  862. $other[] = $gv;
  863. }
  864. }
  865. $this->audit_action($data, $other, $info, $shop, 1);
  866. } else {
  867. Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text, 'status' => 7));
  868. Dever::load('agent/lib/dhorder')->updateSell($info, 2);
  869. if (Dever::project('sms')) {
  870. $member = Dever::db('agent/member')->find($info['mid']);
  871. Dever::load('sms/api')->send('daili_goods_no', $member['mobile'], array('name' => $member['name'], 'content' => $audit_text));
  872. }
  873. }
  874. }
  875. return Dever::url('project/database/list&project=agent&table=dh_order&menu=agent&search_option_state=1&search_option_shop_type=2&menu_id=218', 'manage');
  876. }
  877. # 采购订单审核 拆单
  878. public function audit_commit()
  879. {
  880. $order_id = Dever::input('order_id');
  881. $order = Dever::db('agent/dh_order')->find($order_id);
  882. if (!$order || ($order && $order['status'] != 2)) {
  883. Dever::alert('当前订单状态无法拆单');
  884. }
  885. // if ($order['shop_type'] != 2) {
  886. // Dever::alert('这不是平台店的订单');
  887. // }
  888. $order['type'] = 3;
  889. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
  890. $shop = Dever::db('shop/info')->find($order['shop_id']);
  891. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  892. $this->audit_action($data, $goods, $order, $shop);
  893. return 'ok';
  894. }
  895. private function audit_action($data, $goods, $order, $shop, $state = 2)
  896. {
  897. $send = array();
  898. if (!$goods && $data) {
  899. # 开始生成订单
  900. $i = $order['order_index'];
  901. foreach ($data as $k => $v) {
  902. foreach ($v as $k1 => $v1) {
  903. $v1['order_num'] .= '_' . $i;
  904. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  905. $send[$state] = $v1;
  906. }
  907. $i++;
  908. }
  909. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
  910. } else {
  911. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  912. if ($goods) {
  913. $string = array();
  914. foreach ($goods as $k => $v) {
  915. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  916. if ($info['sku_name']) {
  917. $info['name'] .= '('.$info['sku_name'].')';
  918. }
  919. $string[] = $info['name'];
  920. }
  921. $string = implode('、', $string);
  922. if ($state == 1) {
  923. Dever::alert('商品:'.$string.'未选择供货商');
  924. } else {
  925. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  926. }
  927. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  928. } else {
  929. if ($state == 1) {
  930. Dever::alert('未选择供货商,该订单进入重新审核状态');
  931. } else {
  932. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  933. }
  934. }
  935. }
  936. if ($send) {
  937. foreach ($send as $k => $v) {
  938. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  939. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  940. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  941. }
  942. }
  943. }
  944. # 第三方确认
  945. public function tixian()
  946. {
  947. $param = array();
  948. ksort($param);
  949. $string = array();
  950. foreach ($param as $k => $v) {
  951. if (strstr($v, '&') || strstr($v, '@')) {
  952. $v = urlencode($v);
  953. }
  954. $string[] = $k . '=' . $v;
  955. }
  956. }
  957. # 发货
  958. public function notice($info)
  959. {
  960. $config = Dever::db('agent/dh_order')->config;
  961. $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => 3, 'operdate' => time()));
  962. }
  963. # 采购订单审核 拆单
  964. /*
  965. public function audit_commit()
  966. {
  967. $order_id = Dever::input('order_id');
  968. $order = Dever::db('agent/dh_order')->find($order_id);
  969. if (!$order || ($order && $order['status'] != 2)) {
  970. Dever::alert('当前订单状态无法拆单');
  971. }
  972. $order['type'] = 3;
  973. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
  974. $shop = Dever::db('shop/info')->find($order['shop_id']);
  975. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  976. $send = array();
  977. if (!$goods && $data) {
  978. # 开始生成订单
  979. $i = $order['order_index'];
  980. foreach ($data as $k => $v) {
  981. foreach ($v as $k1 => $v1) {
  982. $v1['order_num'] .= '_' . $i;
  983. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  984. $send[$state] = $v1;
  985. }
  986. $i++;
  987. }
  988. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
  989. } else {
  990. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  991. if ($goods) {
  992. $string = array();
  993. foreach ($goods as $k => $v) {
  994. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  995. if ($info['sku_name']) {
  996. $info['name'] .= '('.$info['sku_name'].')';
  997. }
  998. $string[] = $info['name'];
  999. }
  1000. $string = implode('、', $string);
  1001. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  1002. } else {
  1003. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  1004. }
  1005. }
  1006. if ($send) {
  1007. foreach ($send as $k => $v) {
  1008. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  1009. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  1010. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  1011. }
  1012. }
  1013. return 'ok';
  1014. }
  1015. */
  1016. public function goodsd_api($id){
  1017. $name = '';
  1018. $goods = Dever::db('agent/dh_order_goods')->state(array('order_id'=>$id));
  1019. foreach($goods as $k1 => $v1){
  1020. $goods_info[] = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  1021. }
  1022. if(isset($goods_info)){
  1023. foreach($goods_info as $v2){
  1024. $goods_name[] = $v2['name'];
  1025. }
  1026. $name = implode(',',$goods_name);
  1027. }
  1028. return $name;
  1029. }
  1030. #权益订单导出
  1031. public function out_dhorder_api($data){
  1032. $header = array('订单编号', '会员姓名', '会员等级', '会员手机号', '收货姓名(或自提人)', '联系电话', '收货地址', '商品名称', '商品数量', '商品原价','订单状态','下单时间', '付款时间', '发货时间','完成时间','卖家订单备注','权益发放时间','代理商终审时间');
  1033. $body = array();
  1034. foreach($data as $k => $v){
  1035. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  1036. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1037. $address = $res = array();
  1038. if ($v['address_id'] && $v['address_id'] > 0) {
  1039. $address = Dever::db('agent/member_address')->find(array('id'=>$v['address_id']));
  1040. if ($address) {
  1041. $res=Dever::load('agent/address')->getOne($address['mid'],$address['id']);
  1042. }
  1043. }
  1044. $fhdate = '';
  1045. $buy_order = Dever::db('shop/buy_order')->find(array('parent_id' => 3, 'parent_order_id' => $v['id']));
  1046. if ($buy_order) {
  1047. $ps = Dever::db('shop/buy_order_ps')->find(array('order_id' => $buy_order['id']));
  1048. $fhdate = ($ps && $ps['cdate']) ? date('Y-m-d H:i', $ps['cdate']) : '-';
  1049. }
  1050. $fdate = '';
  1051. if($v['fdate']){
  1052. $fdate = date('Y-m-d H:i',$v['fdate']);
  1053. }
  1054. $quanyi = '';
  1055. $member_goods = Dever::db('agent/member_goods')->getQone(array('type'=>$v['type'],'type_id'=>$v['type_id']));
  1056. if($member_goods && $member_goods['cdate']){
  1057. $quanyi = date('Y-m-d H:i',$member_goods['cdate']);
  1058. }
  1059. $order = Dever::db('agent/order')->find(array('mid'=>$member['id']));
  1060. $zhongshen = '';
  1061. $process = Dever::db('agent/order_process')->state(array('order_id'=>$order['id']));
  1062. foreach($process as $k1 => $v1){
  1063. if($v1['status'] == 2){
  1064. $zhongshen = date('Y-m-d H:i',$v1['cdate']);
  1065. }
  1066. }
  1067. $name = '';
  1068. if($v['type'] == 1){
  1069. $name = $this->goodsd_api($v['id']);
  1070. }elseif($v['type'] == 2){
  1071. $goods = Dever::db('card/info')->find(array('id'=>$v['type_id']));
  1072. if($goods){
  1073. $name = $goods['name'];
  1074. }
  1075. }elseif($v['type'] == 3){
  1076. $goods = Dever::db('setting/prize')->find(array('id'=>$v['type_id']));
  1077. if($goods){
  1078. $name = $goods['name'];
  1079. }
  1080. }
  1081. $goods_status = Dever::db('agent/dh_order')->config['status'];
  1082. $status = Dever::status($goods_status, $v['status']);
  1083. $d = array
  1084. (
  1085. $v['order_num'],
  1086. $member['name'],
  1087. $role['name'],
  1088. $member['mobile'],
  1089. isset($address['contact']) ? $address['contact'] : '',
  1090. isset($address['mobile']) ? $address['mobile'] : '',
  1091. (isset($res['address_info']) ? $res['address_info'] : '').(isset($address['house_number']) ? $address['house_number'] : ''),
  1092. $name,
  1093. $v['num'],
  1094. $v['price'],
  1095. $status,
  1096. date('Y-m-d H:i',$v['cdate']),
  1097. date('Y-m-d H:i',$v['cdate']),
  1098. $fhdate,
  1099. $fdate,
  1100. $v['audit_desc'],
  1101. $quanyi,
  1102. $zhongshen,
  1103. );
  1104. $body[] = $d;
  1105. }
  1106. $file = Dever::input('excel_name');
  1107. return Dever::excelExport($body, $header, $file);
  1108. }
  1109. #权益管理导出'5月已用面值',
  1110. public function out_member_goods_api($data){
  1111. $header = array('权益名称', '会员等级', '姓名', '手机号', '卡号','剩余数量', '总数量', '单件价值', '未兑换价值', '已兑换价值', '已用面值','备注','获取方式', '获取时间','代理商注册时间','礼品卡有效期');
  1112. $body = array();
  1113. foreach($data as $k => $v){
  1114. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  1115. $member_cdate = '-';
  1116. if($member && $member['cdate']){
  1117. $member_cdate = date('Y-m-d H:i',$member['cdate']);
  1118. }
  1119. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1120. $wd = ($v['total_num'] - $v['sell_num'])*$v['price'];
  1121. $yd = $v['sell_num']*$v['price'];
  1122. $card = '-';
  1123. $mianzhi = '-';
  1124. $money = '-';
  1125. $youxiao = '';
  1126. if($v['type'] == 2){
  1127. $code = Dever::db('card/code')->find($v['sku_id']);
  1128. $start = '1651334400';
  1129. $end = '1654012799';
  1130. if($code){
  1131. $card_info = Dever::db('card/info')->find($code['card_id']);
  1132. if ($card_info && $card_info['end_dh_day']) {
  1133. $youxiao = date('Y-m-d H:i',strtotime(+ $card_info['end_dh_day'].'day',$code['bdate']));
  1134. }
  1135. // $sell_order = Dever::db('shop/sell_order')->getSumCdate(array('start'=>$start,'end'=>$end,'card_code_id'=>$code['id'],'state'=>1));
  1136. // if($sell_order && $sell_order['total']){
  1137. // $money = $sell_order['total'];
  1138. // }
  1139. $card = $code['card']."\t";
  1140. $mianzhi = $code['use_cash'];
  1141. }
  1142. }
  1143. $desc = '';
  1144. $member_goods_log = Dever::db('agent/member_goods_log')->getOne(array('type'=>$v['type'],'type_id'=>$v['type_id'],'sku_id'=>$v['sku_id'],'state'=>1));
  1145. if($member_goods_log && $member_goods_log['desc']){
  1146. $desc = $member_goods_log['desc'];
  1147. }
  1148. $d = array
  1149. (
  1150. $v['name'],
  1151. $role['name'],
  1152. $member['name'],
  1153. $member['mobile'],
  1154. $card,
  1155. $v['total_num']-$v['sell_num'],
  1156. $v['total_num'],
  1157. $v['price'],
  1158. $wd,
  1159. $yd,
  1160. $mianzhi,
  1161. // $money,
  1162. $desc,
  1163. '',
  1164. date('Y-m-d H:i',$v['cdate']),
  1165. $member_cdate,
  1166. $youxiao,
  1167. );
  1168. $body[] = $d;
  1169. }
  1170. $file = Dever::input('excel_name');
  1171. return Dever::excelExport($body, $header, $file);
  1172. }
  1173. #未使用数据导出
  1174. public function out_member_nogoods($data)
  1175. {
  1176. $header = array('权益名称', '会员等级', '姓名', '手机号', '卡号','剩余数量', '总数量', '单件价值', '未兑换价值', '已兑换价值', '已用面值','备注','获取方式', '获取时间','代理商注册时间','礼品卡有效期');
  1177. $body = array();
  1178. foreach ($data as $k => $v) {
  1179. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  1180. $member_cdate = '-';
  1181. if($member && $member['cdate']){
  1182. $member_cdate = date('Y-m-d H:i',$member['cdate']);
  1183. }
  1184. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1185. $wd = ($v['total_num'] - $v['sell_num'])*$v['price'];
  1186. $yd = $v['sell_num']*$v['price'];
  1187. $card = '-';
  1188. $mianzhi = '-';
  1189. $money = '-';
  1190. $youxiao = '';
  1191. if ($v['type'] == 1) {
  1192. if ($v['total_num'] - $v['sell_num'] == 0) {
  1193. continue;
  1194. }
  1195. }
  1196. if($v['type'] == 2){
  1197. $code = Dever::db('card/code')->find($v['sku_id']);
  1198. if($code){
  1199. if ($code['use_cash'] == $yd && $v['sell_num'] != 0){
  1200. continue;
  1201. }
  1202. $card_info = Dever::db('card/info')->find($code['card_id']);
  1203. if ($card_info && $card_info['end_dh_day']) {
  1204. $youxiao = date('Y-m-d H:i',strtotime(+ $card_info['end_dh_day'].'day',$code['bdate']));
  1205. }
  1206. $card = $code['card']."\t";
  1207. $mianzhi = $code['use_cash'];
  1208. }
  1209. }
  1210. $desc = '';
  1211. $member_goods_log = Dever::db('agent/member_goods_log')->getOne(array('type'=>$v['type'],'type_id'=>$v['type_id'],'sku_id'=>$v['sku_id'],'state'=>1));
  1212. if($member_goods_log && $member_goods_log['desc']){
  1213. $desc = $member_goods_log['desc'];
  1214. }
  1215. $d = array
  1216. (
  1217. $v['name'],
  1218. $role['name'],
  1219. $member['name'],
  1220. $member['mobile'],
  1221. $card,
  1222. $v['total_num']-$v['sell_num'],
  1223. $v['total_num'],
  1224. $v['price'],
  1225. $wd,
  1226. $yd,
  1227. $mianzhi,
  1228. $desc,
  1229. '',
  1230. date('Y-m-d H:i',$v['cdate']),
  1231. $member_cdate,
  1232. $youxiao,
  1233. );
  1234. $body[] = $d;
  1235. }
  1236. $file = Dever::input('excel_name');
  1237. return Dever::excelExport($body, $header, $file);
  1238. }
  1239. public function head($type=false){
  1240. $data = Dever::db('agent/member_goods')->getProduct(array('type'=>'1,2','state'=>1));
  1241. $res = array();
  1242. foreach($data as $k => $v){
  1243. if($v['name'] && $v['total_num']>0 && $v['type_id']!=8){
  1244. $key = $v['type'] . '_' . $v['type_id'];
  1245. if ($v['type'] == 2) {
  1246. $card = Dever::db('card/info')->find($v['type_id']);
  1247. $v['name'] = $card['name'];
  1248. }
  1249. if ($v['type'] == 1) {
  1250. $res[0][$key] = array($v['name'], '价值');
  1251. } else {
  1252. $res[0][$key] = array($v['name'], '');
  1253. $res[2][$key] = $v['name'];
  1254. }
  1255. $res[1][$key] = $v['name'];
  1256. }
  1257. }
  1258. return $res;
  1259. }
  1260. public function out_equity_api($data){
  1261. $start = Dever::input('search_option_start_udate');
  1262. $end = Dever::input('search_option_end_udate');
  1263. $fstart = Dever::input('search_option_start_dever_auth');
  1264. $fend = Dever::input('search_option_end_dever_auth');
  1265. if($start && $end){
  1266. $where['start'] = $start;
  1267. $where['end'] = $end;
  1268. }else{
  1269. $where['start']=Dever::maketime(date('Y-m-01') . ' 00:00:00');
  1270. $where['end'] = strtotime(date('Y-m-d 23:59:59',
  1271. strtotime(date('Y-m-01')."+1 month - 1 day")));
  1272. }
  1273. $w = array();
  1274. if ($fstart) {
  1275. $w['start'] = $fstart;
  1276. }
  1277. if ($fend) {
  1278. $w['end'] = $fend;
  1279. }
  1280. $where['type'] = '1,2';
  1281. $res = $this->head(1);
  1282. $header = array('基础信息', '', '', '', '','', '', '', '');
  1283. $body = array();
  1284. $pg = Dever::input('pg');
  1285. if ($pg == 1) {
  1286. $body[] = array('代理商姓名', '角色', '电话', '区域','应收合计', '代理费', '产品费(商品)', '产品费(电器卡)','产品费(菜卡)');
  1287. }
  1288. // print_R($res[0]);die;
  1289. $i = 0;
  1290. foreach ($res[0] as $k => $v) {
  1291. if ($i == 0) {
  1292. $header[] = '发放权益';
  1293. } else {
  1294. $header[] = '';
  1295. }
  1296. isset($body[0]) && $body[0][] = $v[0];
  1297. if ($v[1]) {
  1298. isset($body[0]) && $body[0][] = $v[1];
  1299. $header[] = '';
  1300. }
  1301. $i++;
  1302. }
  1303. $i = 0;
  1304. foreach ($res[1] as $k => $v) {
  1305. isset($body[0]) && $body[0][] = $v;
  1306. if ($i == 0) {
  1307. $header[] = '兑换权益';
  1308. } else {
  1309. $header[] = '';
  1310. }
  1311. $i++;
  1312. }
  1313. $i = 0;
  1314. foreach ($res[2] as $k => $v) {
  1315. isset($body[0]) && $body[0][] = $v;
  1316. if ($i == 0) {
  1317. $header[] = '使用金额';
  1318. } else {
  1319. $header[] = '';
  1320. }
  1321. $i++;
  1322. }
  1323. $body_member = array();
  1324. // $data = Dever::db('agent/member_goods')->getSearchAll($where);
  1325. foreach ($data as $k => $v) {
  1326. $member_goods[] = Dever::db('agent/member_goods')->getTOne(array('mid'=>$v['id'],'type'=>'1,2'));
  1327. }
  1328. foreach($member_goods as $k => $v){
  1329. if($v){
  1330. $body_member[] = $v;
  1331. }
  1332. }
  1333. foreach ($body_member as $k => $v) {
  1334. $month = date('Y-m',$v['cdate']);
  1335. $member = Dever::db('agent/member')->find($v['mid']);
  1336. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1337. $area = '';
  1338. if($member['area']){
  1339. $area = Dever::load("area/api.string", $member['area']);
  1340. }
  1341. $order = Dever::db('agent/order')->getOrder(array('mid'=>$v['mid']));
  1342. // print_R($order);die;
  1343. // $order = Dever::db('agent/order')->find(array('mid'=>$v['mid']));
  1344. $heji = 0;
  1345. $product_cash = 0;
  1346. $dianqi_cash = 0;
  1347. $caipin_cash = 0;
  1348. $d = array
  1349. (
  1350. $member['name'],
  1351. $role['name'],
  1352. $member['mobile'],
  1353. $area,
  1354. 0,
  1355. // $order['agent_cash'],
  1356. // $month,
  1357. 0,
  1358. 0,
  1359. 0,
  1360. 0,
  1361. );
  1362. $i = count($d);
  1363. $goods = array();
  1364. foreach ($res[0] as $k1 => $v1) {
  1365. list($type, $type_id) = explode('_', $k1);
  1366. $goods[$k1] = Dever::db('agent/member_goods')->getTotal(array('end'=>$where['end'],'mid'=>$v['mid'],'type'=>$type, 'type_id' => $type_id));
  1367. $d[$i] = 0;
  1368. if ($goods[$k1]) {
  1369. if(strstr($v1[0],'卡')){
  1370. $d[$i] = $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1371. }else{
  1372. $d[$i] = $goods[$k1]['total_num'] ? $goods[$k1]['total_num'] : 0;
  1373. }
  1374. }
  1375. if ($v1[1]) {
  1376. $i++;
  1377. $d[$i] = 0;
  1378. if ($goods[$k1]) {
  1379. $d[$i] = $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1380. }
  1381. }
  1382. if ($type == 1) {
  1383. $product_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1384. }
  1385. if ($type == 2 ) {
  1386. if(strstr($v1[0], '器具')){
  1387. $dianqi_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1388. } else {
  1389. $caipin_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1390. }
  1391. }
  1392. $i++;
  1393. }
  1394. // $heji = $order['agent_cash'] + $product_cash + $dianqi_cash + $caipin_cash;
  1395. $d[4] = $order['agent_cash'] - $product_cash - $dianqi_cash - $caipin_cash;
  1396. $d[5] = $order['agent_cash'];
  1397. $d[6] = $product_cash;
  1398. $d[7] = $dianqi_cash;
  1399. $d[8] = $caipin_cash;
  1400. $w1 = $w;
  1401. $w1['mid'] = $v['mid'];
  1402. $dh_order_ps = Dever::db('agent/dh_order_ps')->getDui($w1);
  1403. foreach ($res[1] as $k1 => $v1) {
  1404. $d[$i] = 0;
  1405. list($type, $type_id) = explode('_', $k1);
  1406. if ($goods[$k1]) {
  1407. if ($type == 2 && strstr($v1,'卡')) {
  1408. $n = $w;
  1409. $n['mid'] = $v['mid'];
  1410. $n['type'] = $type;
  1411. $n['type_id'] = $type_id;
  1412. $dh_goods = Dever::db('agent/member_goods')->getDhTotal($n);
  1413. $d[$i] = $dh_goods['sell_num'] ? $dh_goods['cash']*$dh_goods['sell_num'] : 0;
  1414. } elseif($type == 1) {
  1415. if ($dh_order_ps) {
  1416. foreach($dh_order_ps as $a => $b) {
  1417. $dh_order_goods = Dever::db('agent/dh_order_goods')->find(array('order_id'=>$b['order_id'], 'goods_id' => $type_id, 'status' => 1));
  1418. if($dh_order_goods){
  1419. $d[$i] += $dh_order_goods['num'];
  1420. }
  1421. }
  1422. }
  1423. // $d[$i] = $goods[$k1]['sell_num'] ? $goods[$k1]['sell_num'] : 0;
  1424. }
  1425. }
  1426. $i++;
  1427. }
  1428. foreach ($res[2] as $k1 => $v1) {
  1429. list($type, $type_id) = explode('_', $k1);
  1430. $w1 = array();
  1431. $w1['mid'] = $v['mid'];
  1432. $w1['type'] = $type;
  1433. $w1['type_id'] = $type_id;
  1434. $sku = Dever::db('agent/member_goods')->getCardAll($w1);
  1435. $array = array_column($sku, 'sku_id');
  1436. $sku_id = implode(",",$array);
  1437. if($sku_id){
  1438. $w1 = $w;
  1439. $w1['card_code_id'] = $sku_id;
  1440. $w1['status'] = '4,5,6';
  1441. $sell_order[$k1] = Dever::db('shop/sell_order')->getCardAlls($w1);
  1442. }else{
  1443. $sell_order[$k1]['total'] = 0;
  1444. }
  1445. if($sell_order[$k1]){
  1446. $d[$i] = $sell_order[$k1]['total'] ? $sell_order[$k1]['total'] : 0 ;
  1447. }
  1448. $i++;
  1449. }
  1450. $body[] = $d;
  1451. }
  1452. $file = Dever::input('excel_name');
  1453. return Dever::excelExport($body, $header, $file);
  1454. }
  1455. }