Dhorder.php 58 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536
  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_udate');
  1154. $end = Dever::input('search_option_end_udate');
  1155. $fstart = Dever::input('search_option_start_dever_auth');
  1156. $fend = Dever::input('search_option_end_dever_auth');
  1157. if($start && $end){
  1158. $where['start'] = $start;
  1159. $where['end'] = $end;
  1160. }else{
  1161. $where['start']=Dever::maketime(date('Y-m-01') . ' 00:00:00');
  1162. $where['end'] = strtotime(date('Y-m-d 23:59:59',
  1163. strtotime(date('Y-m-01')."+1 month - 1 day")));
  1164. }
  1165. $w = array();
  1166. if ($fstart) {
  1167. $w['start'] = $fstart;
  1168. }
  1169. if ($fend) {
  1170. $w['end'] = $fend;
  1171. }
  1172. $where['type'] = '1,2';
  1173. $res = $this->head(1);
  1174. $header = array('基础信息', '', '', '', '','', '', '', '');
  1175. $body = array();
  1176. $pg = Dever::input('pg');
  1177. if ($pg == 1) {
  1178. $body[] = array('代理商姓名', '角色', '电话', '区域','应收合计', '代理费', '产品费(商品)', '产品费(电器卡)','产品费(菜卡)');
  1179. }
  1180. $i = 0;
  1181. foreach ($res[0] as $k => $v) {
  1182. if ($i == 0) {
  1183. $header[] = '发放权益';
  1184. } else {
  1185. $header[] = '';
  1186. }
  1187. isset($body[0]) && $body[0][] = $v[0];
  1188. if ($v[1]) {
  1189. isset($body[0]) && $body[0][] = $v[1];
  1190. $header[] = '';
  1191. }
  1192. $i++;
  1193. }
  1194. $i = 0;
  1195. foreach ($res[1] as $k => $v) {
  1196. isset($body[0]) && $body[0][] = $v;
  1197. if ($i == 0) {
  1198. $header[] = '兑换权益';
  1199. } else {
  1200. $header[] = '';
  1201. }
  1202. $i++;
  1203. }
  1204. $i = 0;
  1205. foreach ($res[2] as $k => $v) {
  1206. isset($body[0]) && $body[0][] = $v;
  1207. if ($i == 0) {
  1208. $header[] = '使用金额';
  1209. } else {
  1210. $header[] = '';
  1211. }
  1212. $i++;
  1213. }
  1214. $body_member = array();
  1215. // $data = Dever::db('agent/member_goods')->getSearchAll($where);
  1216. foreach ($data as $k => $v) {
  1217. $member_goods[] = Dever::db('agent/member_goods')->getTOne(array('mid'=>$v['id'],'type'=>'1,2'));
  1218. }
  1219. foreach($member_goods as $k => $v){
  1220. if($v){
  1221. $body_member[] = $v;
  1222. }
  1223. }
  1224. foreach ($body_member as $k => $v) {
  1225. $month = date('Y-m',$v['cdate']);
  1226. $member = Dever::db('agent/member')->find($v['mid']);
  1227. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1228. $area = '';
  1229. if($member['area']){
  1230. $area = Dever::load("area/api.string", $member['area']);
  1231. }
  1232. $order = Dever::db('agent/order')->find(array('mid'=>$v['mid']));
  1233. $heji = 0;
  1234. $product_cash = 0;
  1235. $dianqi_cash = 0;
  1236. $caipin_cash = 0;
  1237. $d = array
  1238. (
  1239. $member['name'],
  1240. $role['name'],
  1241. $member['mobile'],
  1242. $area,
  1243. $order['agent_cash'],
  1244. // $month,
  1245. 0,
  1246. 0,
  1247. 0,
  1248. 0,
  1249. );
  1250. $i = count($d);
  1251. $goods = array();
  1252. foreach ($res[0] as $k1 => $v1) {
  1253. list($type, $type_id) = explode('_', $k1);
  1254. $goods[$k1] = Dever::db('agent/member_goods')->getTotal(array('end'=>$where['end'],'mid'=>$v['mid'],'type'=>$type, 'type_id' => $type_id));
  1255. $d[$i] = 0;
  1256. if ($goods[$k1]) {
  1257. if(strstr($v1[0],'卡')){
  1258. $d[$i] = $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1259. }else{
  1260. $d[$i] = $goods[$k1]['total_num'] ? $goods[$k1]['total_num'] : 0;
  1261. }
  1262. }
  1263. if ($v1[1]) {
  1264. $i++;
  1265. $d[$i] = 0;
  1266. if ($goods[$k1]) {
  1267. $d[$i] = $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1268. }
  1269. }
  1270. if ($type == 1) {
  1271. $product_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1272. }
  1273. if ($type == 2 ) {
  1274. if(strstr($v1[0], '器具')){
  1275. $dianqi_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1276. } else {
  1277. $caipin_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
  1278. }
  1279. }
  1280. $i++;
  1281. }
  1282. // $heji = $order['agent_cash'] + $product_cash + $dianqi_cash + $caipin_cash;
  1283. $d[5] = $order['agent_cash'] - $product_cash - $dianqi_cash - $caipin_cash;
  1284. $d[6] = $product_cash;
  1285. $d[7] = $dianqi_cash;
  1286. $d[8] = $caipin_cash;
  1287. foreach ($res[1] as $k1 => $v1) {
  1288. $d[$i] = 0;
  1289. if ($goods[$k1]) {
  1290. if (strstr($v1,'卡')) {
  1291. $d[$i] = $goods[$k1]['cash']*$goods[$k1]['sell_num'] ? $goods[$k1]['cash']*$goods[$k1]['sell_num'] : 0;
  1292. } else {
  1293. $w1 = $w;
  1294. $w1['mid'] = $v['mid'];
  1295. $order_ps[$k1] = Dever::db('agent/dh_order_ps')->getDui($w1);
  1296. foreach($order_ps as $a => $b){
  1297. $pc_order = Dever::db('shop/sell_order')->getSellDui(array('id'=>$b['order_id']));
  1298. if($pc_order){
  1299. $d[$i] += $pc_order['num'];
  1300. }
  1301. }
  1302. // $d[$i] = $goods[$k1]['sell_num'] ? $goods[$k1]['sell_num'] : 0;
  1303. }
  1304. }
  1305. $i++;
  1306. }
  1307. foreach ($res[2] as $k1 => $v1) {
  1308. list($type, $type_id) = explode('_', $k1);
  1309. $w1 = array();
  1310. $w1['mid'] = $v['mid'];
  1311. $w1['type'] = $type;
  1312. $w1['type_id'] = $type_id;
  1313. $sku = Dever::db('agent/member_goods')->getCardAll($w1);
  1314. $array = array_column($sku, 'sku_id');
  1315. $sku_id = implode(",",$array);
  1316. if($sku_id){
  1317. $w1 = $w;
  1318. $w1['card_code_id'] = $sku_id;
  1319. $sell_order[$k1] = Dever::db('shop/sell_order')->getCardAlls($w1);
  1320. }else{
  1321. $sell_order[$k1]['total'] = 0;
  1322. }
  1323. if($sell_order[$k1]){
  1324. $d[$i] = $sell_order[$k1]['total'] ? $sell_order[$k1]['total'] : 0 ;
  1325. }
  1326. $i++;
  1327. }
  1328. $body[] = $d;
  1329. }
  1330. $file = Dever::input('excel_name');
  1331. return Dever::excelExport($body, $header, $file);
  1332. }
  1333. }