Dhorder.php 58 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510
  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. $order_data['order_num'] = $this->getOrderId();
  240. $id = Dever::db('agent/dh_order')->insert($order_data);
  241. if (!$id) {
  242. Dever::alert('兑换失败');
  243. }
  244. if ($goods) {
  245. foreach($goods as $k => $v) {
  246. if ($v['ku_state'] == 1) {
  247. $data['mid'] = $user['id'];
  248. $data['order_id'] = $id;
  249. $data['shop_id'] = $shop['id'];
  250. $data['goods_id'] = $v['type_id'];
  251. $data['sku_id'] = $v['sku_id'];
  252. $data['price'] = $v['price'];
  253. $data['num'] = $v['buy_num'];
  254. Dever::db('agent/dh_order_goods')->insert($data);
  255. }
  256. }
  257. }
  258. # 减少库存 增加销量
  259. $order_data['id'] = $id;
  260. $this->updateSell($order_data);
  261. return array
  262. (
  263. 'order_num' => $order_data['order_num'],
  264. 'order_id' => $id,
  265. 'type' => 'dh',
  266. );
  267. }
  268. # 添加配送信息
  269. public function updatePs($order, $status = 1, $service_id = -1, $order_num = '')
  270. {
  271. $where['order_id'] = $order['id'];
  272. $where['clear'] = true;
  273. $data = Dever::db('agent/dh_order_ps')->find($where);
  274. $service = array();
  275. if ($service_id) {
  276. $service['service_id'] = $service_id;
  277. }
  278. if ($order_num) {
  279. $service['order_num'] = $order_num;
  280. }
  281. if (!$data) {
  282. $insert = $where;
  283. if ($service) {
  284. $insert['service'][] = $service;
  285. $insert['service'] = Dever::array_encode($insert['service']);
  286. }
  287. $insert['status'] = $status;
  288. if ($status == 2) {
  289. $insert['qu_date'] = time();
  290. }
  291. Dever::db('agent/dh_order_ps')->insert($insert);
  292. } else {
  293. $update = $where;
  294. $update['where_id'] = $data['id'];
  295. $update['status'] = $status;
  296. if ($status == 2) {
  297. $update['qu_date'] = time();
  298. }
  299. if ($status == 3) {
  300. $update['qs_date'] = time();
  301. }
  302. if ($service) {
  303. $data['service'] = Dever::array_decode($data['service']);
  304. $update['service'] = $data['service'];
  305. $update['service'][] = $service;
  306. $insert['service'] = Dever::array_encode($update['service']);
  307. }
  308. Dever::db('agent/dh_order_ps')->update($update);
  309. }
  310. }
  311. # 减少库存,增加销量
  312. public function updateSell($order, $type = 1)
  313. {
  314. $method = 'incSell';
  315. $name = '兑换商品';
  316. $name_3 = '兑换名额';
  317. if ($type == 2) {
  318. $method = 'decSell';
  319. $name = '退回商品';
  320. $name_3 = '退回名额';
  321. }
  322. if ($order['type'] == 1) {
  323. $where['order_id'] = $order['id'];
  324. //$where['status'] = 3;
  325. $data = Dever::db('agent/dh_order_goods')->select($where);
  326. if ($data) {
  327. foreach ($data as $k => $v) {
  328. $up = array();
  329. $up['where_mid'] = $order['mid'];
  330. $up['where_type'] = $order['type'];
  331. $up['where_type_id'] = $v['goods_id'];
  332. $up['where_sku_id'] = $v['sku_id'];
  333. $up['clear'] = true;
  334. $info = Dever::db('agent/member_goods')->findData($up);
  335. $up['set_sell_num'] = $v['num'];
  336. Dever::db('agent/member_goods')->$method($up);
  337. if ($type == 2) {
  338. 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);
  339. } else {
  340. 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);
  341. }
  342. }
  343. }
  344. } elseif ($order['type'] == 3) {
  345. $up['where_mid'] = $order['mid'];
  346. $up['where_type'] = $order['type'];
  347. $up['where_type_id'] = $order['type_id'];
  348. $up['where_sku_id'] = -1;
  349. $info = Dever::db('agent/member_goods')->findData($up);
  350. $up['set_sell_num'] = $order['num'];
  351. Dever::db('agent/member_goods')->$method($up);
  352. if ($type == 2) {
  353. 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);
  354. } else {
  355. 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);
  356. }
  357. }
  358. }
  359. # 完成
  360. public function finish($info, $shop_id)
  361. {
  362. if ($info && $info['shop_id'] == $shop_id && $info['status'] <= 4) {
  363. $status = 5;
  364. $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => $status, 'fdate' => time()));
  365. $this->updatePs($info, 3);
  366. $w['parent_type'] = 3;
  367. $w['parent_order_id'] = $info['id'];
  368. $w['status'] = 4;
  369. $buy_order = Dever::db('shop/buy_order')->select($w);
  370. if ($buy_order) {
  371. foreach ($buy_order as $k => $v) {
  372. Dever::load('mshop/lib/buy')->set(1,1)->finish($shop_id, $v['id']);
  373. }
  374. }
  375. return 'ok';
  376. } else {
  377. Dever::alert('您没有权限核销');
  378. }
  379. }
  380. # 平台订单已收货
  381. public function yes_api()
  382. {
  383. $shop_id = Dever::input('shop_id');
  384. $order_id = Dever::input('order_id');
  385. $info = Dever::db('agent/dh_order')->find(array('id' => $order_id));
  386. if ($info && $info['type'] == 10) {
  387. $this->finish($info, $shop_id);
  388. } else {
  389. Dever::alert('您没有权限核销');
  390. }
  391. return 'reload';
  392. }
  393. # 生成订单号
  394. public function getOrderId()
  395. {
  396. $where['order_num'] = Dever::order('DH');
  397. $state = Dever::db('agent/dh_order')->one($where);
  398. if (!$state) {
  399. return $where['order_num'];
  400. } else {
  401. return $this->getOrderId();
  402. }
  403. }
  404. # 展示订单详情
  405. public function show()
  406. {
  407. $id = Dever::input('order_id');
  408. $config = Dever::db('agent/dh_order')->config;
  409. $info = Dever::db('agent/dh_order')->one($id);
  410. if ($info['type'] > 1) {
  411. return;
  412. }
  413. $tk_status = Dever::db('agent/dh_order_refund')->config['status'];
  414. $tk_process = Dever::db('agent/dh_order_refund')->config['process'];
  415. $status = $config['status'][$info['status']];
  416. $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'type' => 1));
  417. $shop = Dever::db('shop/info')->find($info['shop_id']);
  418. $user = Dever::db('agent/member')->find($info['mid']);
  419. $cdate = date('Y-m-d H:i', $info['cdate']);
  420. if ($info['operdate']) {
  421. $opertime = date('Y-m-d H:i', $info['operdate']);
  422. } else {
  423. $opertime = '';
  424. }
  425. if ($info['fdate']) {
  426. $fdate = date('Y-m-d H:i', $info['fdate']);
  427. } else {
  428. $fdate = '';
  429. }
  430. if (!$user) {
  431. $user['username'] = '无';
  432. }
  433. if (!isset($user['name'])) {
  434. $user['truename'] = $user['name'];
  435. }
  436. if ($tk && $tk['process'] == 1) {
  437. $status = '申请' . $tk_status[$tk['status']];
  438. $process = $tk_process[$tk['process']];
  439. $process = '';
  440. }
  441. $time = array();
  442. $time[] = array('下单时间', $cdate);
  443. if ($opertime) {
  444. if ($info['status'] == 2) {
  445. $time[] = array('通知时间', $opertime);
  446. }
  447. if ($info['status'] == 7) {
  448. $time[] = array('取消时间', $opertime);
  449. }
  450. }
  451. if ($fdate) {
  452. $time[] = array('完成时间', $fdate);
  453. }
  454. $time[] = array('审核备注', $info['audit_desc']);
  455. $result = array();
  456. $result[$info['order_num']] = array
  457. (
  458. 'type' => 'info',
  459. 'content' => array
  460. (
  461. array
  462. (
  463. array('订单状态', $status),
  464. array('代理商姓名', $user['name']),
  465. array('联系电话', $info['mobile']),
  466. ),
  467. $time,
  468. )
  469. );
  470. if ($info['address_id'] > 0) {
  471. $address = Dever::load('agent/address')->getOne($info['mid'], $info['address_id']);
  472. if ($address) {
  473. $result['收货地址'] = array
  474. (
  475. 'type' => 'info',
  476. 'content' => array
  477. (
  478. array
  479. (
  480. array('联系人', $address['contact']),
  481. array('联系电话', $address['mobile']),
  482. ),
  483. array
  484. (
  485. array('收货地址', $address['address_info']),
  486. array('门牌号', $address['house_number']),
  487. ),
  488. ),
  489. );
  490. }
  491. }
  492. $info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
  493. if ($info['ps_info']) {
  494. $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
  495. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  496. if ($info['ps_info']['qs_date']) {
  497. $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
  498. } else {
  499. $info['ps_info']['qs_date'] = '无';
  500. }
  501. $status = Dever::db('agent/dh_order_ps')->config['status'];
  502. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  503. $service = array();
  504. if ($info['ps_info']['service']) {
  505. foreach ($info['ps_info']['service'] as $k => $v) {
  506. if (isset($v['order_num']) && $v['order_num']) {
  507. $info['ps_info']['service'][$k]['service_name'] = '商家自送';
  508. if ($v['service_id'] > 0) {
  509. $service_info = Dever::db('shop/service')->find($v['service_id']);
  510. $info['ps_info']['service'][$k]['service_name'] = $service_info['name'];
  511. }
  512. $service[] = array
  513. (
  514. array('名称', $info['ps_info']['service'][$k]['service_name']),
  515. array('单号', isset($v['order_num']) ? $v['order_num'] : ''),
  516. );
  517. }
  518. }
  519. }
  520. $result['物流信息'] = array
  521. (
  522. 'type' => 'info',
  523. 'content' => array
  524. (
  525. array
  526. (
  527. array('发货时间', $info['ps_info']['cdate']),
  528. array('收货时间', $info['ps_info']['qs_date']),
  529. array('查单', '<a href="https://www.kuaidi100.com/?from=openv" target="_blank">点此手动查单</a>'),
  530. ),
  531. ),
  532. );
  533. $result['物流信息']['content'] = array_merge($result['物流信息']['content'], $service);
  534. }
  535. if (!$info['refund_cash']) {
  536. $info['refund_cash'] = 0;
  537. }
  538. if ($info['refund_cash'] > 0 && $tk) {
  539. $process = $tk_process[$tk['process']];
  540. $tk['cdate'] = date('Y-m-d H:i', $tk['cdate']);
  541. $result['退款信息'] = array
  542. (
  543. 'type' => 'info',
  544. 'content' => array
  545. (
  546. array
  547. (
  548. array('退款金额', $info['refund_cash']),
  549. array('数量', $info['num']),
  550. array('退款进度', $process),
  551. ),
  552. array
  553. (
  554. array('申请时间', $tk['cdate']),
  555. array('退款原因', $tk['desc']),
  556. ),
  557. ),
  558. );
  559. }
  560. $body = $refund_body = array();
  561. $body_total = array();
  562. $body_total['price'] = 0;
  563. $body_total['num'] = 0;
  564. $refund_body_total = array();
  565. $refund_body_total['price'] = 0;
  566. $refund_body_total['num'] = 0;
  567. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
  568. $goods_status = Dever::db('agent/dh_order_goods')->config['status'];
  569. foreach ($goods as $k => $v) {
  570. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  571. $status = Dever::status($goods_status, $v['status']);
  572. $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
  573. if ($tk && $tk['process'] == 1) {
  574. $status = '申请' . $tk_status[$tk['status']];
  575. //$status .= '&nbsp;&nbsp;[' . $tk_process[$tk['process']] . ']';
  576. }
  577. if (isset($goods_info['sku'])) {
  578. $sku = $goods_info['sku']['string'];
  579. } else {
  580. $sku = '无';
  581. }
  582. if ($info['status'] > 1 && $info['status'] < 7) {
  583. $tui = Dever::url('buy_order_tui?shop_id='.$v['shop_id'].'&order_goods_id=' . $v['id'] . '&order_id=' . $info['id'] . '&cash=' . $v['price'], 'shop');
  584. $status = '<a href="javascript:;" onclick="fastEdit($(this), \''.$tui.'\', \'退款\', \'\', 1)" class="layui-btn">退款</a>';
  585. $status = '';
  586. }
  587. $d = array
  588. (
  589. 'pic' => $goods_info['cover'],
  590. 'name' => $goods_info['name'],
  591. 'sku' => $sku,
  592. 'price' => $v['price'],
  593. 'num' => $v['num'],
  594. 'status' => $status,
  595. );
  596. if ($tk && $v['status'] == 3) {
  597. $d['status'] = $tk_status[$tk['status']];
  598. $refund_body[] = $d;
  599. $price = $v['price']*$v['num'];
  600. $refund_body_total['price'] += $price;
  601. $refund_body_total['num'] += $v['num'];
  602. } else {
  603. $body[] = $d;
  604. $price = $v['price']*$v['num'];
  605. $body_total['price'] += $price;
  606. $body_total['num'] += $v['num'];
  607. }
  608. }
  609. if ($body) {
  610. if ($refund_body_total['price']) {
  611. $body_total['set_price'] = $body_total['price'] - $refund_body_total['price'];
  612. }
  613. if ($refund_body_total['num']) {
  614. $body_total['set_num'] = $body_total['num'] - $refund_body_total['num'];
  615. }
  616. $result['商品清单'] = array
  617. (
  618. 'type' => 'list',
  619. 'content' => $body,
  620. 'total' => $body_total,
  621. );
  622. }
  623. if ($refund_body) {
  624. $result['退款商品'] = array
  625. (
  626. 'type' => 'list',
  627. 'content' => $refund_body,
  628. 'total' => $refund_body_total,
  629. );
  630. }
  631. # 平台门店采购单
  632. $buy_order = Dever::db('shop/buy_order')->getDataToId(array('type' => 1, 'type_id' => $info['shop_id'], 'parent_type' => 3, 'parent_order_id' => $info['id']));
  633. $source_order_id = array();
  634. if ($buy_order) {
  635. $source_order_id = array_keys($buy_order);
  636. }
  637. # 平台门店结算单
  638. if ($source_order_id) {
  639. $cash_order = Dever::db('cash/order')->getDataByOrderId(array('source_order_id' => $source_order_id));
  640. $col = 'cash';
  641. }
  642. if (isset($cash_order) && $cash_order) {
  643. $head = array('序号', '结算单号', '数量', '金额', '结算类型', '入账状态', '审核状态', '结算时间', '审核备注', '管理');
  644. $body = array();
  645. $config = Dever::db('cash/order')->config;
  646. foreach ($cash_order as $k => $v) {
  647. $cdate = date('Y-m-d H:i', $v['cdate']);
  648. $fdate = $v['fdate'] ? date('Y-m-d H:i', $v['fdate']) : '';
  649. $operdate = $v['operdate'] ? date('Y-m-d H:i', $v['operdate']) : '';
  650. $cash = $v[$col];
  651. $url = Dever::url('project/database/list?project=shop&table=buy_order_goods&order_id='.$v['source_order_id'].'&page_type=1', 'manage');
  652. $v['source_order_num'] = '<a href="'.$url.'" style="color:blue">'.$v['source_order_num'].'</a>';
  653. $m = '';
  654. if ($v['audit'] == 1 && $v['audit_type'] == 2) {
  655. $url = Dever::url('project/database/update?project=cash&table=order&where_id='.$v['id'].'&col=audit,desc', 'manage');
  656. $m = '<a href="javascript:;" onclick="fastEdit($(this), \''.$url.'\', \'审核\', \'\', 1)" class="layui-btn">审核</a>';
  657. }
  658. $d = array
  659. (
  660. $k+1,
  661. $v['order_num'],
  662. $v['num'],
  663. $cash,
  664. $config['config_jstype'][$v['jstype']],
  665. $config['config_status'][$v['status']],
  666. $config['config_audit'][$v['audit']],
  667. $operdate,
  668. $v['desc'],
  669. $m,
  670. );
  671. $body[] = $d;
  672. }
  673. $result['对账清单'] = array
  674. (
  675. 'type' => 'table',
  676. 'content' => array
  677. (
  678. 'head' => $head,
  679. 'body' => $body,
  680. )
  681. );
  682. }
  683. $head_btn[] = array
  684. (
  685. 'type' => 'link',
  686. 'link' => Dever::url('project/database/list?project=agent&table=dh_order&menu=agent&search_option_state=1', 'manage'),
  687. 'name' => '返回上一页',
  688. );
  689. $audit = Dever::input('audit');
  690. if($audit==1){
  691. # 审核信息
  692. $this->show_audit($info, $result);
  693. }
  694. $head = array
  695. (
  696. 'name' => '基本信息',
  697. 'btn' => $head_btn,
  698. );
  699. $html = Dever::show($head, $result);
  700. return $html;
  701. }
  702. private function show_audit($info, &$result)
  703. {
  704. $info['type'] = 3;
  705. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id'], 'status' => 1));
  706. $shop = Dever::db('shop/info')->find($info['shop_id']);
  707. list($data, $source) = Dever::load('mshop/lib/buy')->assign($goods, $info, $shop, true);
  708. // print_R($data);die;
  709. if ($info) {
  710. $head = array('序号', '商品编号', '商品名称', '供货商', '订货总数量', '商品计量单位', '订货单总金额');
  711. $body = array();
  712. $i = 0;
  713. if ($data) {
  714. foreach ($data as $k => $v) {
  715. foreach ($v as $v1) {
  716. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  717. if (isset($goods_info['sku'])) {
  718. $sku = '[' . $goods_info['sku']['string'] . ']';
  719. } else {
  720. $sku = '';
  721. }
  722. $d = array
  723. (
  724. $i+1,
  725. $goods_info['code'],
  726. $goods_info['name'] . $sku,
  727. Dever::load('mshop/lib/buy')->getSelect($source, $v1['source_id'], $v1['order_goods_id']),
  728. $v1['num'],
  729. $goods_info['unit'],
  730. $v1['price'] * $v1['num'],
  731. );
  732. $body[] = $d;
  733. $i++;
  734. }
  735. }
  736. }
  737. if ($goods) {
  738. foreach ($goods as $k => $v) {
  739. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  740. if (isset($goods_info['sku'])) {
  741. $sku = '[' . $goods_info['sku']['string'] . ']';
  742. } else {
  743. $sku = '';
  744. }
  745. $d = array
  746. (
  747. $i+1,
  748. $goods_info['code'],
  749. $goods_info['name'] . $sku,
  750. Dever::load('mshop/lib/buy')->getSelect($source, false, $v['id']),
  751. $v['num'],
  752. $goods_info['unit'],
  753. $v['price'] * $v['num'],
  754. );
  755. $body[] = $d;
  756. $i++;
  757. }
  758. }
  759. $btn = array();
  760. $btn[] = array(
  761. 'type' => 'click',
  762. 'content' => 'setAudit()',
  763. 'name' => '全部调整<script>function setAudit(){layer.confirm(\'确定进行此项操作吗?\', function(){var audit = $(\'.audit_set\').val();$(\'.audit\').each(function(){$(this).val(audit);layui.form.render();layer.closeAll()})})}</script>'
  764. );
  765. $result['商品拆单'] = array
  766. (
  767. 'type' => 'table',
  768. 'head' => array('name' => '供货商:' . Dever::load('mshop/lib/buy')->getSelect($source, false, false), 'btn' => $btn),
  769. 'content' => array
  770. (
  771. 'head' => $head,
  772. 'body' => $body,
  773. )
  774. );
  775. $url = Dever::url('lib/dhorder.audit_set_commit?json=1&order_id=' . $info['id'], 'agent');
  776. // print_R($url);die;
  777. $result['审核结果'] = array
  778. (
  779. 'type' => 'html',
  780. '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>',
  781. );
  782. }
  783. }
  784. # 采购订单审核 手动拆单
  785. public function audit_set_commit_api()
  786. {
  787. Dever::config('base')->hook = true;
  788. //{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"}
  789. $id = Dever::input('order_id');
  790. $goods = Dever::input('goods');
  791. $audit = Dever::input('audit');
  792. $audit_text = Dever::input('audit_text');
  793. $info = Dever::db('agent/dh_order')->one($id);
  794. if ($audit > 1 && $info && $info['status'] == 2) {
  795. $shop = Dever::db('shop/info')->find($info['shop_id']);
  796. if ($audit == 2) {
  797. Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
  798. # 成功
  799. if (strstr($info['order_num'], '_')) {
  800. $temp = explode('_', $info['order_num']);
  801. $info['order_num'] = $temp[0];
  802. $info['order_index'] = $temp[1];
  803. } else {
  804. $info['order_index'] = 0;
  805. }
  806. $goods = explode(',', $goods);
  807. $data = $other = array();
  808. foreach ($goods as $k => $v) {
  809. list($source_type, $source_id, $name, $goods_id) = explode('_', $v);
  810. $gv = Dever::db('agent/dh_order_goods')->find($goods_id);
  811. if ($source_id > 0) {
  812. $key = $source_type . '_' . $source_id;
  813. $data[$key][] = array
  814. (
  815. 'area' => $shop['area'],
  816. 'order_id' => $info['id'],
  817. 'order_type' => 3,
  818. 'order_num' => $info['order_num'],
  819. 'order_index' => $info['order_index'],
  820. 'type' => 1,
  821. 'type_id' => $shop['id'],
  822. 'source_type' => $source_type,
  823. 'source_id' => $source_id,
  824. 'order_goods_id' => $gv['id'],
  825. 'goods_id' => $gv['goods_id'],
  826. 'sku_id' => $gv['sku_id'],
  827. 'price' => $gv['price'],
  828. 'p_price' => $gv['price'],
  829. 'num' => $gv['num'],
  830. );
  831. } else {
  832. $other[] = $gv;
  833. }
  834. }
  835. $this->audit_action($data, $other, $info, $shop, 1);
  836. } else {
  837. Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text, 'status' => 7));
  838. Dever::load('agent/lib/dhorder')->updateSell($info, 2);
  839. if (Dever::project('sms')) {
  840. $member = Dever::db('agent/member')->find($info['mid']);
  841. Dever::load('sms/api')->send('daili_goods_no', $member['mobile'], array('name' => $member['name'], 'content' => $audit_text));
  842. }
  843. }
  844. }
  845. 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');
  846. }
  847. # 采购订单审核 拆单
  848. public function audit_commit()
  849. {
  850. $order_id = Dever::input('order_id');
  851. $order = Dever::db('agent/dh_order')->find($order_id);
  852. if (!$order || ($order && $order['status'] != 2)) {
  853. Dever::alert('当前订单状态无法拆单');
  854. }
  855. // if ($order['shop_type'] != 2) {
  856. // Dever::alert('这不是平台店的订单');
  857. // }
  858. $order['type'] = 3;
  859. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
  860. $shop = Dever::db('shop/info')->find($order['shop_id']);
  861. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  862. $this->audit_action($data, $goods, $order, $shop);
  863. return 'ok';
  864. }
  865. private function audit_action($data, $goods, $order, $shop, $state = 2)
  866. {
  867. $send = array();
  868. if (!$goods && $data) {
  869. # 开始生成订单
  870. $i = $order['order_index'];
  871. foreach ($data as $k => $v) {
  872. foreach ($v as $k1 => $v1) {
  873. $v1['order_num'] .= '_' . $i;
  874. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  875. $send[$state] = $v1;
  876. }
  877. $i++;
  878. }
  879. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
  880. } else {
  881. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  882. if ($goods) {
  883. $string = array();
  884. foreach ($goods as $k => $v) {
  885. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  886. if ($info['sku_name']) {
  887. $info['name'] .= '('.$info['sku_name'].')';
  888. }
  889. $string[] = $info['name'];
  890. }
  891. $string = implode('、', $string);
  892. if ($state == 1) {
  893. Dever::alert('商品:'.$string.'未选择供货商');
  894. } else {
  895. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  896. }
  897. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  898. } else {
  899. if ($state == 1) {
  900. Dever::alert('未选择供货商,该订单进入重新审核状态');
  901. } else {
  902. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  903. }
  904. }
  905. }
  906. if ($send) {
  907. foreach ($send as $k => $v) {
  908. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  909. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  910. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  911. }
  912. }
  913. }
  914. # 第三方确认
  915. public function tixian()
  916. {
  917. $param = array();
  918. ksort($param);
  919. $string = array();
  920. foreach ($param as $k => $v) {
  921. if (strstr($v, '&') || strstr($v, '@')) {
  922. $v = urlencode($v);
  923. }
  924. $string[] = $k . '=' . $v;
  925. }
  926. }
  927. # 发货
  928. public function notice($info)
  929. {
  930. $config = Dever::db('agent/dh_order')->config;
  931. $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => 3, 'operdate' => time()));
  932. }
  933. # 采购订单审核 拆单
  934. /*
  935. public function audit_commit()
  936. {
  937. $order_id = Dever::input('order_id');
  938. $order = Dever::db('agent/dh_order')->find($order_id);
  939. if (!$order || ($order && $order['status'] != 2)) {
  940. Dever::alert('当前订单状态无法拆单');
  941. }
  942. $order['type'] = 3;
  943. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
  944. $shop = Dever::db('shop/info')->find($order['shop_id']);
  945. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  946. $send = array();
  947. if (!$goods && $data) {
  948. # 开始生成订单
  949. $i = $order['order_index'];
  950. foreach ($data as $k => $v) {
  951. foreach ($v as $k1 => $v1) {
  952. $v1['order_num'] .= '_' . $i;
  953. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  954. $send[$state] = $v1;
  955. }
  956. $i++;
  957. }
  958. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
  959. } else {
  960. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  961. if ($goods) {
  962. $string = array();
  963. foreach ($goods as $k => $v) {
  964. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  965. if ($info['sku_name']) {
  966. $info['name'] .= '('.$info['sku_name'].')';
  967. }
  968. $string[] = $info['name'];
  969. }
  970. $string = implode('、', $string);
  971. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  972. } else {
  973. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  974. }
  975. }
  976. if ($send) {
  977. foreach ($send as $k => $v) {
  978. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  979. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  980. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  981. }
  982. }
  983. return 'ok';
  984. }
  985. */
  986. public function goodsd_api($id){
  987. $name = '';
  988. $goods = Dever::db('agent/dh_order_goods')->state(array('order_id'=>$id));
  989. foreach($goods as $k1 => $v1){
  990. $goods_info[] = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  991. }
  992. if(isset($goods_info)){
  993. foreach($goods_info as $v2){
  994. $goods_name[] = $v2['name'];
  995. }
  996. $name = implode(',',$goods_name);
  997. }
  998. return $name;
  999. }
  1000. #权益订单导出
  1001. public function out_dhorder_api($data){
  1002. $header = array('订单编号', '会员姓名', '会员等级', '会员手机号', '收货姓名(或自提人)', '联系电话', '收货地址', '商品名称', '商品数量', '商品原价','订单状态','下单时间', '付款时间', '发货时间','完成时间','卖家订单备注','权益发放时间','代理商终审时间');
  1003. $body = array();
  1004. foreach($data as $k => $v){
  1005. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  1006. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1007. $address = $res = array();
  1008. if ($v['address_id'] && $v['address_id'] > 0) {
  1009. $address = Dever::db('agent/member_address')->find(array('id'=>$v['address_id']));
  1010. if ($address) {
  1011. $res=Dever::load('agent/address')->getOne($address['mid'],$address['id']);
  1012. }
  1013. }
  1014. $fhdate = '';
  1015. $buy_order = Dever::db('shop/buy_order')->find(array('parent_id' => 3, 'parent_order_id' => $v['id']));
  1016. if ($buy_order) {
  1017. $ps = Dever::db('shop/sell_order_ps')->find(array('order_id' => $buy_order['id']));
  1018. $fhdate = ($ps && $ps['cdate']) ? date('Y-m-d H:i', $ps['cdate']) : '-';
  1019. }
  1020. $fdate = '';
  1021. if($v['fdate']){
  1022. $fdate = date('Y-m-d H:i',$v['fdate']);
  1023. }
  1024. $quanyi = '';
  1025. $member_goods = Dever::db('agent/member_goods')->getQone(array('type'=>$v['type'],'type_id'=>$v['type_id']));
  1026. if($member_goods && $member_goods['cdate']){
  1027. $quanyi = date('Y-m-d H:i',$member_goods['cdate']);
  1028. }
  1029. $order = Dever::db('agent/order')->find(array('mid'=>$member['id']));
  1030. $zhongshen = '';
  1031. $process = Dever::db('agent/order_process')->state(array('order_id'=>$order['id']));
  1032. foreach($process as $k1 => $v1){
  1033. if($v1['status'] == 2){
  1034. $zhongshen = date('Y-m-d H:i',$v1['cdate']);
  1035. }
  1036. }
  1037. $name = '';
  1038. if($v['type'] == 1){
  1039. $name = $this->goodsd_api($v['id']);
  1040. }elseif($v['type'] == 2){
  1041. $goods = Dever::db('card/info')->find(array('id'=>$v['type_id']));
  1042. if($goods){
  1043. $name = $goods['name'];
  1044. }
  1045. }elseif($v['type'] == 3){
  1046. $goods = Dever::db('setting/prize')->find(array('id'=>$v['type_id']));
  1047. if($goods){
  1048. $name = $goods['name'];
  1049. }
  1050. }
  1051. $goods_status = Dever::db('agent/dh_order')->config['status'];
  1052. $status = Dever::status($goods_status, $v['status']);
  1053. $d = array
  1054. (
  1055. $v['order_num'],
  1056. $member['name'],
  1057. $role['name'],
  1058. $member['mobile'],
  1059. isset($address['contact']) ? $address['contact'] : '',
  1060. isset($address['mobile']) ? $address['mobile'] : '',
  1061. (isset($res['address_info']) ? $res['address_info'] : '').(isset($address['house_number']) ? $address['house_number'] : ''),
  1062. $name,
  1063. $v['num'],
  1064. $v['price'],
  1065. $status,
  1066. date('Y-m-d H:i',$v['cdate']),
  1067. date('Y-m-d H:i',$v['cdate']),
  1068. $fhdate,
  1069. $fdate,
  1070. $v['audit_desc'],
  1071. $quanyi,
  1072. $zhongshen,
  1073. );
  1074. $body[] = $d;
  1075. }
  1076. $file = Dever::input('excel_name');
  1077. return Dever::excelExport($body, $header, $file);
  1078. }
  1079. #权益管理导出
  1080. public function out_member_goods_api($data){
  1081. $header = array('权益名称', '会员等级', '姓名', '手机号', '卡号','剩余数量', '总数量', '单件价值', '未兑换价值', '已用面值','5月已用面值','备注','获取方式', '获取时间','代理商注册时间');
  1082. $body = array();
  1083. foreach($data as $k => $v){
  1084. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  1085. $member_cdate = '-';
  1086. if($member && $member['cdate']){
  1087. $member_cdate = date('Y-m-d H:i',$member['cdate']);
  1088. }
  1089. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1090. $wd = ($v['total_num'] - $v['sell_num'])*$v['price'];
  1091. $card = '-';
  1092. $mianzhi = '-';
  1093. $money = '-';
  1094. if($v['type'] == 2){
  1095. $code = Dever::db('card/code')->find($v['sku_id']);
  1096. $start = '1651334400';
  1097. $end = '1654012799';
  1098. if($code){
  1099. $sell_order = Dever::db('shop/sell_order')->getSumCdate(array('start'=>$start,'end'=>$end,'card_code_id'=>$code['id'],'state'=>1));
  1100. if($sell_order && $sell_order['total']){
  1101. $money = $sell_order['total'];
  1102. }
  1103. }
  1104. $card = $code['card']."\t";
  1105. $mianzhi = $code['total_cash'] - $code['use_cash'];
  1106. }
  1107. $desc = '';
  1108. $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));
  1109. if($member_goods_log && $member_goods_log['desc']){
  1110. $desc = $member_goods_log['desc'];
  1111. }
  1112. $d = array
  1113. (
  1114. $v['name'],
  1115. $role['name'],
  1116. $member['name'],
  1117. $member['mobile'],
  1118. $card,
  1119. $v['total_num']-$v['sell_num'],
  1120. $v['total_num'],
  1121. $v['price'],
  1122. $wd,
  1123. $mianzhi,
  1124. $money,
  1125. $desc,
  1126. '',
  1127. date('Y-m-d H:i',$v['cdate']),
  1128. $member_cdate,
  1129. );
  1130. $body[] = $d;
  1131. }
  1132. $file = Dever::input('excel_name');
  1133. return Dever::excelExport($body, $header, $file);
  1134. }
  1135. public function head($type=false){
  1136. $data = Dever::db('agent/member_goods')->getProduct(array('type'=>'1,2','state'=>1));
  1137. $res = array();
  1138. foreach($data as $k => $v){
  1139. if($v['name'] && $v['total_num']>0 && $v['type_id']!=8){
  1140. $key = $v['type'] . '_' . $v['type_id'];
  1141. if ($v['type'] == 1) {
  1142. $res[0][$key] = array($v['name'], '价值');
  1143. } else {
  1144. $res[0][$key] = array($v['name'], '');
  1145. $res[2][$key] = $v['name'];
  1146. }
  1147. $res[1][$key] = $v['name'];
  1148. }
  1149. }
  1150. return $res;
  1151. }
  1152. public function out_equity_api($data){
  1153. $start = Dever::input('search_option_start_rdate');
  1154. $end = Dever::input('search_option_end_rdate');
  1155. if($start && $end){
  1156. $where['start'] = $start;
  1157. $where['end'] = $end;
  1158. }else{
  1159. $where['start']=Dever::maketime(date('Y-m-01') . ' 00:00:00');
  1160. $where['end'] = strtotime(date('Y-m-d 23:59:59',
  1161. strtotime(date('Y-m-01')."+1 month - 1 day")));
  1162. }
  1163. $where['type'] = '1,2';
  1164. $res = $this->head(1);
  1165. $header = array('基础信息', '', '', '', '','', '', '', '', '');
  1166. $body = array();
  1167. $pg = Dever::input('pg');
  1168. if ($pg == 1) {
  1169. $body[] = array('代理商姓名', '角色', '电话', '区域','应收合计', '月份', '代理费', '产品费(商品)', '产品费(电器卡)','产品费(菜卡)');
  1170. }
  1171. $i = 0;
  1172. foreach ($res[0] as $k => $v) {
  1173. if ($i == 0) {
  1174. $header[] = '发放权益';
  1175. } else {
  1176. $header[] = '';
  1177. }
  1178. isset($body[0]) && $body[0][] = $v[0];
  1179. if ($v[1]) {
  1180. isset($body[0]) && $body[0][] = $v[1];
  1181. $header[] = '';
  1182. }
  1183. $i++;
  1184. }
  1185. $i = 0;
  1186. foreach ($res[1] as $k => $v) {
  1187. isset($body[0]) && $body[0][] = $v;
  1188. if ($i == 0) {
  1189. $header[] = '兑换权益';
  1190. } else {
  1191. $header[] = '';
  1192. }
  1193. $i++;
  1194. }
  1195. $i = 0;
  1196. foreach ($res[2] as $k => $v) {
  1197. isset($body[0]) && $body[0][] = $v;
  1198. if ($i == 0) {
  1199. $header[] = '使用金额';
  1200. } else {
  1201. $header[] = '';
  1202. }
  1203. $i++;
  1204. }
  1205. $body_member = array();
  1206. // $data = Dever::db('agent/member_goods')->getSearchAll($where);
  1207. foreach ($data as $k => $v) {
  1208. $member_goods[] = Dever::db('agent/member_goods')->getTOne(array('mid'=>$v['id'],'type'=>'1,2'));
  1209. }
  1210. foreach($member_goods as $k => $v){
  1211. if($v){
  1212. $body_member[] = $v;
  1213. }
  1214. }
  1215. foreach ($body_member as $k => $v) {
  1216. $month = date('Y-m',$v['cdate']);
  1217. $member = Dever::db('agent/member')->find($v['mid']);
  1218. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1219. $area = '';
  1220. if($member['area']){
  1221. $area = Dever::load("area/api.string", $member['area']);
  1222. }
  1223. $order = Dever::db('agent/order')->find(array('mid'=>$v['mid']));
  1224. $heji = 0;
  1225. $product_cash = 0;
  1226. $dianqi_cash = 0;
  1227. $caipin_cash = 0;
  1228. $d = array
  1229. (
  1230. $member['name'],
  1231. $role['name'],
  1232. $member['mobile'],
  1233. $area,
  1234. $order['agent_cash'],
  1235. $month,
  1236. 0,
  1237. 0,
  1238. 0,
  1239. 0,
  1240. );
  1241. $i = count($d);
  1242. $goods = array();
  1243. foreach ($res[0] as $k1 => $v1) {
  1244. list($type, $type_id) = explode('_', $k1);
  1245. $goods[$k1] = Dever::db('agent/member_goods')->getTotal(array('start'=>$where['start'],'end'=>$where['end'],'mid'=>$v['mid'],'type'=>$type, 'type_id' => $type_id));
  1246. $d[$i] = 0;
  1247. if ($goods[$k1]) {
  1248. if(strstr($v1[0],'卡')){
  1249. $d[$i] = $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1250. }else{
  1251. $d[$i] = $goods[$k1]['total_num'] ? $goods[$k1]['total_num'] : 0;
  1252. }
  1253. }
  1254. if ($v1[1]) {
  1255. $i++;
  1256. $d[$i] = 0;
  1257. if ($goods[$k1]) {
  1258. $d[$i] = $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1259. }
  1260. }
  1261. if ($type == 1) {
  1262. $product_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1263. }
  1264. if ($type == 2 ) {
  1265. if(strstr($v1[0], '器具')){
  1266. $dianqi_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1267. } else {
  1268. $caipin_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1269. }
  1270. // if ($v)
  1271. }
  1272. $i++;
  1273. }
  1274. // $heji = $order['agent_cash'] + $product_cash + $dianqi_cash + $caipin_cash;
  1275. $d[6] = $order['agent_cash'] - $product_cash - $dianqi_cash - $caipin_cash;
  1276. $d[7] = $product_cash;
  1277. $d[8] = $dianqi_cash;
  1278. $d[9] = $caipin_cash;
  1279. foreach ($res[1] as $k1 => $v1) {
  1280. $d[$i] = 0;
  1281. if ($goods[$k1]) {
  1282. if (strstr($v1,'卡')) {
  1283. $d[$i] = $goods[$k1]['cash']*$goods[$k1]['sell_num'] ? $goods[$k1]['cash']*$goods[$k1]['sell_num'] : 0;
  1284. } else {
  1285. $d[$i] = $goods[$k1]['sell_num'] ? $goods[$k1]['sell_num'] : 0;
  1286. }
  1287. }
  1288. $i++;
  1289. }
  1290. foreach ($res[2] as $k1 => $v1) {
  1291. list($type, $type_id) = explode('_', $k1);
  1292. $sku = Dever::db('agent/member_goods')->getCardAll(array('start'=>$where['start'],'end'=>$where['end'],'type_id'=>$type_id,'type'=>$type,'mid'=>$v['mid']));
  1293. $array = array_column($sku, 'sku_id');
  1294. $sku_id = implode(",",$array);
  1295. if($sku_id){
  1296. $sell_order[$k1] = Dever::db('shop/sell_order')->getCardAll(array('start'=>$where['start'],'end'=>$where['end'],'card_code_id'=>$sku_id));
  1297. }else{
  1298. $sell_order[$k1]['total'] = 0;
  1299. }
  1300. if($sell_order[$k1]){
  1301. $d[$i] = $sell_order[$k1]['total'] ? $sell_order[$k1]['total'] : 0 ;
  1302. }
  1303. $i++;
  1304. }
  1305. $body[] = $d;
  1306. }
  1307. $file = Dever::input('excel_name');
  1308. return Dever::excelExport($body, $header, $file);
  1309. }
  1310. }