Manage.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780
  1. <?php
  2. namespace Stats\Lib;
  3. use Dever;
  4. Class Manage
  5. {
  6. public function index_api()
  7. {
  8. $data = array();
  9. $start = Dever::input('start');
  10. $end = Dever::input('end');
  11. if (!$start && !$end) {
  12. $start=Dever::maketime(date('Y-m-01') . ' 00:00:00');
  13. $end = strtotime(date('Y-m-d 23:59:59',
  14. strtotime(date('Y-m-01')."+1 month - 1 day")));
  15. $data['start'] = date('Y-m-d',$start);
  16. $data['end'] = date('Y-m-d',$end);
  17. } else {
  18. $data['start'] = date('Y-m-d',$start);
  19. $data['end'] = date('Y-m-d',$end);
  20. }
  21. $fastart = Dever::input('fastart');
  22. $faend = Dever::input('faend');
  23. if (!$fastart && !$faend) {
  24. $fastart=Dever::maketime(date('Y-m-01') . ' 00:00:00');
  25. $faend = strtotime(date('Y-m-d 23:59:59',
  26. strtotime(date('Y-m-01')."+1 month - 1 day")));
  27. $data['fastart'] = date('Y-m-d',$fastart);
  28. $data['faend'] = date('Y-m-d',$faend);
  29. } else {
  30. $data['fastart'] = date('Y-m-d',$fastart);
  31. $data['faend'] = date('Y-m-d',$faend);
  32. }
  33. $fstart = Dever::input('fstart');
  34. $fend = Dever::input('fend');
  35. if (!$fstart && !$fend) {
  36. $fstart=Dever::maketime(date('Y-m-01') . ' 00:00:00');
  37. $fend = strtotime(date('Y-m-d 23:59:59',
  38. strtotime(date('Y-m-01')."+1 month - 1 day")));
  39. $data['fstart'] = date('Y-m-d',$fstart);
  40. $data['fend'] = date('Y-m-d',$fend);
  41. } else {
  42. $data['fstart'] = date('Y-m-d',$fstart);
  43. $data['fend'] = date('Y-m-d',$fend);
  44. }
  45. $data['type'] = array(1 => '体验店',2 => '零售店',10 => '平台商城');
  46. return Dever::render('out', $data);
  47. }
  48. public function list_api()
  49. {
  50. $header = array('门店类型', '门店编号', '门店名称', '订单号', '商品编码', '存货编码', '商品名称', '规格型号', '税率', '商品单价', '购买数量', '商品合计金额', '代理优惠金额', '商品实付金额', '礼品卡金额', '钱包金额','商品支付金额', '礼品卡名称', '礼品卡卡号', '代理商注册时间', '下单时间', '付款时间', '发货时间', '完成时间', '订单总数量', '订单总金额', '订单实付金额', '礼品卡金额', '钱包金额', '优惠券金额', '代理优惠金额', '订单状态', '退款状态', '退款时间', '退款金额','退卡金额','退现金金额', '收件人', '收件人手机', '收件人地址');
  51. $body = array();
  52. $status = Dever::db('shop/sell_order')->config['status_manage'];
  53. $start = Dever::input('start');
  54. $end = Dever::input('end');
  55. $fastart = Dever::input('fastart');
  56. $faend = Dever::input('faend');
  57. $fstart = Dever::input('fstart');
  58. $fend = Dever::input('fend');
  59. $cate = Dever::input('cate');
  60. $name = Dever::input('goods_name');
  61. $shop_name = Dever::input('shop_name');
  62. $order_num = Dever::input('order_num');
  63. if ($start) {
  64. $where['start'] = strtotime($start);
  65. }
  66. if ($end) {
  67. $where['end'] = strtotime($end);
  68. }
  69. if ($fastart) {
  70. $where['fastart'] = strtotime($fastart);
  71. }
  72. if ($faend) {
  73. $where['faend'] = strtotime($faend);
  74. }
  75. if ($fstart) {
  76. $where['fstart'] = strtotime($fstart);
  77. }
  78. if ($fend) {
  79. $where['fend'] = strtotime($fend);
  80. }
  81. if ($cate && $cate>0) {
  82. $where['shop_type'] = $cate;
  83. }
  84. if ($name) {
  85. $where['name'] = $name;
  86. }
  87. if ($shop_name) {
  88. $shop = Dever::db('shop/info')->find(array('name'=>$name));
  89. if ($shop) {
  90. $where['shop_id'] = $shop['id'];
  91. }
  92. }
  93. if ($order_num) {
  94. $where['order_num'] = $order_num;
  95. }
  96. $where['state'] = 1;
  97. $data = Dever::db('shop/sell_order')->getExcel($where);
  98. // print_R($data);die;
  99. if ($data) {
  100. foreach ($data as $k => $v) {
  101. $v['card'] = '';
  102. $v['card_code'] = '';
  103. if ($v['card_code_id']) {
  104. $code = Dever::db('card/code')->find($v['card_code_id']);
  105. if ($code) {
  106. $card_info = Dever::db('card/info')->find($code['card_id']);
  107. if ($card_info) {
  108. if (!$code['total_cash']) {
  109. $code['total_cash'] = $card_info['value'];
  110. }
  111. $v['card'] = $card_info['name'];
  112. $v['card_code'] = $code['card'];
  113. }
  114. }
  115. }
  116. if ($v['shop_type'] == 1) {
  117. $v['shop_type_name'] = '体验店';
  118. } elseif ($v['shop_type'] == 2) {
  119. $v['shop_type_name'] = '平台商城';
  120. }
  121. $shop = Dever::db('shop/info')->find(Array('id'=>$v['shop_id']));
  122. if (isset($shop) && $shop) {
  123. $data[$k]['shop_sid'] = $shop['sid'];
  124. $data[$k]['shop_name'] = $shop['name'];
  125. }
  126. $zhuce = '';
  127. $address_contact = '';
  128. $address_mobile = '';
  129. $address_info = '';
  130. if ($v['address_id'] > 0) {
  131. $address = Dever::load('passport/address')->getOne($v['uid'], $v['address_id']);
  132. if($address) {
  133. $address_contact = $address['contact'];
  134. $address_mobile = $address['mobile'];
  135. $address_info = $address['address_info'];
  136. $member = Dever::db('agent/member')->find(array('mobile'=>$address['mobile']));
  137. if ($member) {
  138. $zhuce = date('Y-m-d H:i',$member['cdate']);
  139. }
  140. }
  141. }
  142. $ps = Dever::db('shop/sell_order_ps')->find(array('order_id' => $v['id']));
  143. $cdate = strstr($v['cdate'], '-') ? $v['cdate'] : date('Y-m-d H:i', $v['cdate']);
  144. $paydate = isset($v['paydate']) && $v['paydate'] ? date('Y-m-d H:i', $v['paydate']) : '-';
  145. $operdate = ($ps && $ps['cdate']) ? date('Y-m-d H:i', $ps['cdate']) : '-';
  146. $goods = Dever::db('shop/sell_order_goods')->select(Array('order_id'=>$v['id']));
  147. $fdate = '';
  148. if ($v['fdate']) {
  149. $fdate = date('Y-m-d H:i',$v['fdate']);
  150. }
  151. // print_R($v);die;
  152. foreach ($goods as $k1 => $v1) {
  153. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  154. // print_R($goods_info);die;
  155. if (isset($goods_info['sku'])) {
  156. $sku = $goods_info['sku']['string'];
  157. } else {
  158. $sku = '';
  159. }
  160. $goods_price = $v1['price']*$v1['num'];
  161. #代理优惠金额
  162. $dl_discount_cash = round($v1['discount_cash'],2);
  163. // $discount_cash = round($v['discount_cash'],2);
  164. #商品实付金额
  165. $price = round(($goods_price-$dl_discount_cash),2);
  166. // round(($goods_price/$v['oprice']*$v['price']),2);
  167. //round(($v['price']/$goods_price),2);
  168. #礼品卡金额
  169. $card_code_cash = round($v['card_code_cash'],2);
  170. #钱包金额
  171. $wallet_cash = round($v['wallet_cash'],2);
  172. #商品支付金额
  173. #
  174. if ($k1 == 0) {
  175. $total_cash = Dever::load("shop/lib/manage.getTotalCash", $v['id']);
  176. } else {
  177. $total_cash = 0;
  178. }
  179. $ka = 0;
  180. $money = 0;
  181. if ($v['status'] == 8 || $v['status'] == 6) {
  182. $num = $v1['num'];
  183. $refund_cash = $v1['price']*$v1['num'];
  184. if ($v['status'] == 8) {
  185. if ($v['refund_cash'] && $v['refund_cash']>0) {
  186. $money = $v['refund_cash'];
  187. }
  188. if ($v['card_code_cash'] && $v['card_code_cash'] >0) {
  189. $ka = $v['card_code_cash'];
  190. }
  191. } elseif ($v['status'] == 6) {
  192. if ($v['card_code_id'] && $v['card_code_id']>0 ) {
  193. $ka = $v['refund_cash'];
  194. } else {
  195. $money = $v['refund_cash'];
  196. }
  197. }
  198. if ($k1 == 0) {
  199. $ka = $ka;
  200. $money = $money;
  201. } else {
  202. $ka = 0;
  203. $money = 0;
  204. }
  205. $refund_status = '已退款';
  206. $refund_cdate = '';
  207. if ($v['shop_type'] == 1) {
  208. $refund = Dever::db('shop/sell_order_refund')->find(array('order_id'=>$v['id']));
  209. if ($refund) {
  210. $refund_cdate = date('Y-m-d H:i',$refund['cdate']);
  211. }
  212. }
  213. } else {
  214. #有退款的情况
  215. if ($v['refund_status'] == 3 && $v1['status'] == 3) {
  216. $refund_status = '有退款';
  217. $refund_cash = $v1['num']*$v1['price'];
  218. if ($v['refund_cash']>$refund_cash) {
  219. if ($k1 == 0) {
  220. if ($v['card_code_cash'] && $v['card_code_cash'] >0) {
  221. $ka = $v['refund_cash'];
  222. } else {
  223. $money = $v['refund_cash'];
  224. }
  225. }else {
  226. $ka = 0;
  227. $money = 0;
  228. }
  229. } else {
  230. if ($v['card_code_cash'] && $v['card_code_cash'] >0) {
  231. $ka = $v['refund_cash'];
  232. } else {
  233. $money = $v['refund_cash'];
  234. }
  235. }
  236. $refund_cdate = '';
  237. if ($v['shop_type'] == 1) {
  238. $refund = Dever::db('shop/sell_order_refund')->find(array('order_id'=>$v['id']));
  239. if ($refund) {
  240. $refund_cdate = date('Y-m-d H:i',$refund['cdate']);
  241. }
  242. }
  243. } else {
  244. $refund_cdate = '';
  245. $num = '0';
  246. $refund_cash = '0';
  247. $refund_status = '未退款';
  248. }
  249. }
  250. // if ($v['status'] >=7) {
  251. // $v['price'] = 0;
  252. // }
  253. if ($k1 == 0) {
  254. $v['num'] = $v['num'];
  255. $zhifu = round($v['price'],2);
  256. $coupon_cash = round($v['coupon_cash'],2);#优惠券金额
  257. $card_code_cash = round($v['card_code_cash'],2);#礼品卡金额
  258. $wallet_cash = round($v['wallet_cash'],2);#钱包金额
  259. $discount_cash = round($v['discount_cash'],2);
  260. } else {
  261. $v['num'] = 0;
  262. $zhifu = 0;
  263. $v['wallet_cash'] = 0;
  264. $coupon_cash = 0;
  265. $card_code_cash = 0;
  266. $wallet_cash = 0;
  267. $discount_cash = 0;
  268. }
  269. // print_R($v['price']);die;
  270. $d = array
  271. (
  272. $v['shop_type_name'],
  273. $data[$k]['shop_sid'],
  274. $data[$k]['shop_name'],
  275. $v['order_num'],
  276. $goods_info['code'] . "\t",
  277. $goods_info['cunhuo_code'] . "\t",
  278. $goods_info['name'],
  279. $sku,
  280. $goods_info['tax'],
  281. round($v1['price'], 2),//商品单价
  282. round($v1['num'],2),//商品数量
  283. round($v1['price']*$v1['num'], 2),//商品合计金额
  284. $dl_discount_cash,//代理商优惠金额
  285. $price,//商品实付金额
  286. $card_code_cash,//礼品卡
  287. $wallet_cash, //钱包
  288. $zhifu,//商品支付
  289. $v['card'],
  290. $v['card_code']."\t",
  291. $zhuce,
  292. $cdate,
  293. $paydate,
  294. $operdate,
  295. $fdate,
  296. $v['num'],//订单总量
  297. sprintf('%01.2f',$total_cash),//订单总金额
  298. $zhifu,//订单实付
  299. $card_code_cash,//礼品卡
  300. $wallet_cash,//钱包
  301. $coupon_cash,//优惠券
  302. $discount_cash,//代理优惠
  303. $status[$v['status']],
  304. $refund_status,
  305. $refund_cdate,
  306. round($refund_cash, 2),
  307. round($ka,2),
  308. round($money,2),
  309. $address_contact,
  310. $address_mobile,
  311. $address_info,
  312. );
  313. // $body[] = $d;
  314. if ($goods_info['price_type'] > 2 && isset($goods_info['goods']) && is_array($goods_info['goods'])) {
  315. foreach ($goods_info['goods'] as $k2 => $v2) {
  316. if ($v2['code']) {
  317. //$v2['code'] = '-' . $v2['code'];
  318. }
  319. $p = $v2['price'];
  320. if (is_numeric($v2['num']) && is_numeric($v2['price'])) {
  321. $p = $v2['price']*$v2['num'];
  322. }
  323. $goods_price1 = 0;
  324. $d = array
  325. (
  326. $v['shop_type_name'],
  327. $data[$k]['shop_sid'],
  328. $data[$k]['shop_name'],
  329. $v['order_num'],
  330. $v2['code'] . "\t",
  331. $goods_info['cunhuo_code'] . "\t",
  332. $goods_info['name'],
  333. $sku,
  334. $goods_info['tax'],
  335. round($goods_info['price'], 2),#单价
  336. round($v1['num'],2),#数量
  337. round(($goods_info['price']*$v1['num']),2),#商品合计金额
  338. $dl_discount_cash,//代理商优惠金额
  339. $price,#实付金额
  340. $card_code_cash,#礼品卡金额
  341. $wallet_cash,#钱包金额
  342. $zhifu,#商品支付金额
  343. $v['card'],
  344. $v['card_code']."\t",
  345. $zhuce,
  346. $cdate,
  347. $paydate,
  348. $operdate,
  349. $fdate,
  350. $v['num'],
  351. sprintf('%01.2f',$total_cash),
  352. $zhifu,//订单实付
  353. $card_code_cash,//礼品卡
  354. $wallet_cash,//钱包
  355. $coupon_cash,//优惠券
  356. $discount_cash,//代理优惠
  357. $status[$v['status']],
  358. $refund_status,
  359. $refund_cdate,
  360. round($refund_cash, 2),
  361. round($ka,2),
  362. round($money,2),
  363. $address_contact,
  364. $address_mobile,
  365. $address_info,
  366. );
  367. }
  368. }
  369. $body[] = $d;
  370. }
  371. }
  372. }
  373. if (!$body) {
  374. Dever::alert('此时段没有数据,请重新选择条件');
  375. }
  376. $file = '商品销售相关数据';
  377. return Dever::excelExport($body, $header, $file);
  378. }
  379. public function memberGoods_api()
  380. {
  381. $name = Dever::input('name');
  382. $member_name = Dever::input('member_name');
  383. $card_num = Dever::input('card_num');
  384. $mobile = Dever::input('mobile');
  385. $start = Dever::input('start');
  386. $end = Dever::input('end');
  387. $rstart = Dever::input('rstart');
  388. $rend = Dever::input('end');
  389. $cstart = Dever::input('cstart');
  390. $cend = Dever::input('cend');
  391. if ($card_num) {
  392. $code = Dever::db('card/code')->find(array('card'=>$card_num));
  393. if ($code){
  394. $where['sku_id'] = "t_1.sku_id=".$code['id'];
  395. }
  396. }
  397. if ($name) {
  398. $where['name'] = "t_1.name like '%$name%'";
  399. }
  400. if ($cstart) {
  401. $where['cstart'] = 't_1.cdate+(360*86400)>='. strtotime($cstart);
  402. }
  403. if ($cend) {
  404. $where['cend'] = 't_1.cdate+(360*86400)<='.strtotime($cend);
  405. }
  406. if ($start) {
  407. $where['start'] = 't_1.cdate>='.strtotime($start);
  408. }
  409. if ($end) {
  410. $where['end'] = 't_1.cdate<='.strtotime($end);
  411. }
  412. if ($member_name) {
  413. $where['member_name'] = "t_2.name like '%$member_name%'";
  414. }
  415. if ($mobile) {
  416. $where['mobile'] = 't_2.mobile='.$mobile;
  417. }
  418. if ($rstart) {
  419. $where['rstart'] = 't_2.cdate>='.strtotime($rstart);
  420. }
  421. if ($rend) {
  422. $where['rend'] = 't_2.cdate<='.strtotime($rend);
  423. }
  424. $where['t_1.state'] = 't_1.state=1';
  425. $where['t_1.type'] = "t_1.type in (1,2)";
  426. $header = array('权益名称','会员等级','姓名','手机号','卡号','类型','数量','单件价值','总价值','已兑换价值','已使用价值','未兑换价值','未使用价值','备注','获取方式','获取时间','代理商注册时间','礼品卡有效期');
  427. $body = array();
  428. if ($where) {
  429. $where = implode(' and ', $where);
  430. $data = Dever::db('agent/member_goods')->fetchAll("select t_1.*,t_2.id as aid from churen_agent_member_goods as t_1 left join churen_agent_member as t_2 on t_1.mid = t_2.id where " . $where,array(),array(20, 'list'));
  431. if ($data) {
  432. foreach ($data as $k => $v) {
  433. $role_name = '';
  434. $member_name = '';
  435. $member_mobile = '';
  436. $member = Dever::db('agent/member')->find($v['mid']);
  437. if ($member) {
  438. $member_cdate = '-';
  439. if($member['cdate']){
  440. $member_cdate = date('Y-m-d H:i',$member['cdate']);
  441. }
  442. $member_name = $member['name'];
  443. $member_mobile = $member['mobile'];
  444. $role = Dever::db('setting/role')->find($member['role']);
  445. if ($role) {
  446. $role_name = $role['name'];
  447. }
  448. }
  449. $wd = ($v['total_num'] - $v['sell_num'])*$v['price'];
  450. $yd = $v['sell_num']*$v['price'];
  451. $card = '-';
  452. $mianzhi = '0';
  453. $money = '-';
  454. $youxiao = '';
  455. $leitype = '发放权益';
  456. if($v['type'] == 2){
  457. $code = Dever::db('card/code')->find($v['sku_id']);
  458. if($code){
  459. $card_info = Dever::db('card/info')->find($code['card_id']);
  460. if ($card_info && $card_info['end_dh_day']) {
  461. $youxiao = date('Y-m-d H:i',strtotime(+ $card_info['end_dh_day'].'day',$code['bdate']));
  462. }
  463. $card = $code['card']."\t";
  464. $mianzhi = $code['use_cash'];
  465. }
  466. }
  467. $wy = $v['cash'] - $mianzhi;
  468. $desc = '';
  469. $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));
  470. if($member_goods_log && $member_goods_log['desc']){
  471. $desc = $member_goods_log['desc'];
  472. }
  473. $d = array
  474. (
  475. $v['name'],
  476. $role_name,
  477. $member_name,
  478. $member_mobile,
  479. $card,
  480. $leitype,
  481. $v['total_num'],
  482. $v['price'],
  483. $v['cash'],
  484. $yd,
  485. $mianzhi,
  486. $wd,
  487. $wy,
  488. $desc,
  489. '',
  490. date('Y-m-d H:i',$v['cdate']),
  491. $member_cdate,
  492. $youxiao,
  493. );
  494. $body[] = $d;
  495. }
  496. }
  497. }
  498. if (!$body) {
  499. Dever::alert('此时段没有数据,请重新选择条件');
  500. }
  501. $file = '代理商权益';
  502. return Dever::excelExport($body, $header, $file);
  503. }
  504. #代理商权益发放使用兑换明细
  505. public function mingxi_api()
  506. {
  507. $name = Dever::input('name');
  508. $mobile = Dever::input('mobile');
  509. $card_num = Dever::input('card_num');
  510. $shop_name = Dever::input('shop_name');
  511. $shop_num = Dever::input('shop_num');
  512. $order_num = Dever::input('order_num');
  513. $start = Dever::input('start');
  514. $end = Dever::input('end');
  515. $type = Dever::input('type');
  516. if ($name) {
  517. $where['name'] = $name;
  518. }
  519. if ($mobile) {
  520. $where['mobile'] = $mobile;
  521. }
  522. if ($card_num) {
  523. $code = Dever::db('card/code')->find(array('card'=>$card_num));
  524. if ($code){
  525. $where['sku_id'] = $code['id'];
  526. }
  527. }
  528. if ($shop_name) {
  529. $shop = Dever::db('shop/info')->find(array('name'=>$shop_name));
  530. $where['shop_id'] = $shop['id'];
  531. }
  532. if ($shop_num) {
  533. $shop = Dever::db('shop/info')->fetch('select * from churen_shop_info where sid = '.$shop_num.' and state = 1');
  534. $where['shop_id'] = $shop['id'];
  535. }
  536. // print_R($where['shop_id']);die;
  537. if ($order_num) {
  538. $sell_order = Dever::db('shop/sell_order')->find(array('order_num'=>$order_num));
  539. $where['sku_id'] = $sell_order['card_code_id'];
  540. }
  541. if ($start) {
  542. $where['start'] = strtotime($start);
  543. }
  544. if ($end) {
  545. $where['end'] = strtotime($end);
  546. }
  547. if ($type) {
  548. $where['types'] = $type;
  549. }
  550. $header = array('日期','权益名称','会员等级','姓名','手机号','卡号','类型','数量','单件价值','总价值','门店类型','门店编号','门店名称','关联平台商城订单号','备注','获取方式','获取时间','代理商注册时间','礼品卡有效期');
  551. $body = array();
  552. $where['type'] = '1,2';
  553. $data = Dever::db('agent/member_goods')->getMingxi($where);
  554. $res = array('发放权益','兑换权益','使用权益');
  555. // print_R($data);die;
  556. $rest = array();
  557. if ($where['types'] == -1) {
  558. foreach ($res as $a => $b ){
  559. foreach ($data as $k => $v) {
  560. $v['leixing'] = $b;
  561. $rest[] = $v;
  562. }
  563. }
  564. } elseif ($where['types'] == 1) {
  565. foreach ($data as $k => $v) {
  566. $v['leixing'] = '发放权益';
  567. $rest[] = $v;
  568. }
  569. } elseif ($where['types'] == 2) {
  570. foreach ($data as $k => $v) {
  571. $v['leixing'] = '兑换权益';
  572. $rest[] = $v;
  573. }
  574. } elseif ($where['types'] == 3) {
  575. foreach ($data as $k => $v) {
  576. $v['leixing'] = '使用权益';
  577. $rest[] = $v;
  578. }
  579. }
  580. foreach ($rest as $k => $v) {
  581. $data[$k]['cdate'] = date('Y-m-d H:i',$v['cdate']);
  582. // foreach ($res as $a => $b) {
  583. // $data[$k]['leixing'] = $b;
  584. $member_goods_name = '';
  585. if (isset($v['name']) && $v['name']) {
  586. $member_goods_name = $v['name'];
  587. }
  588. $total_num = '';
  589. if(isset($v['total_num']) && $v['total_num']) {
  590. $total_num = $v['total_num'];
  591. }
  592. $price = '';
  593. if (isset($v['price']) && $v['price']) {
  594. $price = $v['price'];
  595. }
  596. $cash = '';
  597. if (isset($v['cash']) && $v['cash']) {
  598. $cash = $v['cash'];
  599. }
  600. $role_name = '';
  601. $member_name = '';
  602. $member_mobile = '';
  603. $member_cdate = '-';
  604. $member = Dever::db('agent/member')->find($v['mid']);
  605. if ($member) {
  606. if($member['cdate']){
  607. $member_cdate = date('Y-m-d H:i',$member['cdate']);
  608. }
  609. $member_name = $member['name'];
  610. $member_mobile = $member['mobile'];
  611. $role = Dever::db('setting/role')->find($member['role']);
  612. if ($role) {
  613. $role_name = $role['name'];
  614. }
  615. }
  616. $card = '';
  617. $youxiao = '';
  618. if ($v['type'] == 2){
  619. $code = Dever::db('card/code')->find($v['sku_id']);
  620. if($code){
  621. $card_info = Dever::db('card/info')->find($code['card_id']);
  622. if ($card_info && $card_info['end_dh_day']) {
  623. $youxiao = date('Y-m-d H:i',strtotime(+ $card_info['end_dh_day'].'day',$code['bdate']));
  624. }
  625. $card = $code['card']."\t";
  626. }
  627. }
  628. $desc = '';
  629. $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));
  630. if($member_goods_log && $member_goods_log['desc']){
  631. $desc = $member_goods_log['desc'];
  632. }
  633. $dui['mid'] = $v['mid'];
  634. if (isset($where['start']) && $where['start']) {
  635. $dui['start'] = $where['start'];
  636. }
  637. if (isset($where['end']) && $where['end']) {
  638. $dui['end'] = $where['end'];
  639. }
  640. $dh_order_ps = Dever::db('agent/dh_order_ps')->getDui($dui);
  641. if ($where['types'] == 2 || $where['types'] == -1) {
  642. // $v['leixing'] = ''
  643. if ($dh_order_ps) {
  644. // $data[$k]['leixing'] = '兑换权益';
  645. foreach ($dh_order_ps as $k =>$v) {
  646. $dh_order = Dever::db('agent/dh_order')->find($v['order_id']);
  647. if ($dh_order && isset($dh_order['info']) && $dh_order['info']){
  648. $desc = $dh_order['info'];
  649. }
  650. }
  651. }
  652. }
  653. $shop_name = '';
  654. $shop_type = '';
  655. $shop_sid = '';
  656. $order_num = '';
  657. if (isset($where['shop_id']) && $where['shop_id']) {
  658. $where['types'] = 3;
  659. $w2['shop_id'] = $where['shop_id'];
  660. if (isset($where['start']) && $where['start']) {
  661. $w2['start'] = $where['start'];
  662. }
  663. if (isset($where['end']) && $where['end']) {
  664. $w2['end'] = $where['end'];
  665. }
  666. $sell_order = Dever::db('shop/sell_order')->getOutOne($w2);
  667. if ($sell_order) {
  668. if ($where['types'] == 3 || $where['types'] == -1){
  669. $w = $this->common($sell_order);
  670. if ($w) {
  671. $shop_name = $w['shop_name'];
  672. $shop_type = $w['shop_type'];
  673. $shop_sid = $w['shop_sid'];
  674. $order_num = $w['order_num'];
  675. }
  676. }
  677. }
  678. } else {
  679. if (isset($v['sku_id']) && $v['sku_id']){
  680. $w1['card_code_id'] = $v['sku_id'];
  681. if (isset($where['start']) && $where['start']) {
  682. $w1['start'] = $where['start'];
  683. }
  684. if (isset($where['end']) && $where['end']) {
  685. $w1['end'] = $where['end'];
  686. }
  687. $sell_order = Dever::db('shop/sell_order')->getOutOne($w1);
  688. if ($sell_order) {
  689. if ($where['types'] == 3 || $where['types'] == -1) {
  690. $w = $this->common($sell_order);
  691. if ($w) {
  692. $shop_name = $w['shop_name'];
  693. $shop_type = $w['shop_type'];
  694. $shop_sid = $w['shop_sid'];
  695. $order_num = $w['order_num'];
  696. }
  697. }
  698. }
  699. }
  700. }
  701. $d = array
  702. (
  703. $data[$k]['cdate'],
  704. $member_goods_name,
  705. $role_name,
  706. $member_name,
  707. $member_mobile,
  708. $card,
  709. $v['leixing'],
  710. $total_num,
  711. $price,
  712. $cash,
  713. $shop_type,
  714. $shop_sid,
  715. $shop_name,
  716. $order_num,
  717. $desc,
  718. '',
  719. $data[$k]['cdate'],
  720. $member_cdate,
  721. $youxiao,
  722. );
  723. $body[] = $d;
  724. }
  725. if (!$body) {
  726. Dever::alert('此时段没有数据,请重新选择条件');
  727. }
  728. $file = '代理商权益明细';
  729. return Dever::excelExport($body, $header, $file);
  730. }
  731. public function common($sell_order)
  732. {
  733. $w = array();
  734. $w['order_num'] = $sell_order['order_num'];
  735. $shop = Dever::db('shop/info')->find($sell_order['shop_id']);
  736. if ($shop) {
  737. $w['shop_name'] = $shop['name'];
  738. $w['shop_sid'] = $shop['sid'];
  739. if ($shop['type'] = 1) {
  740. $w['shop_type'] = '体验店';
  741. } elseif ($shop['type'] = 2) {
  742. $w['shop_type'] = '零售店';
  743. } elseif ($shop['type'] = 10) {
  744. $w['shop_type'] = '平台商城';
  745. }
  746. }
  747. return $w;
  748. }
  749. }