Manage.php 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665
  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. if ($start) {
  63. $where['start'] = strtotime($start);
  64. }
  65. if ($end) {
  66. $where['end'] = strtotime($end);
  67. }
  68. if ($fastart) {
  69. $where['fastart'] = strtotime($fastart);
  70. }
  71. if ($faend) {
  72. $where['faend'] = strtotime($faend);
  73. }
  74. if ($fstart) {
  75. $where['fstart'] = strtotime($fstart);
  76. }
  77. if ($fend) {
  78. $where['fend'] = strtotime($fend);
  79. }
  80. if ($cate && $cate>0) {
  81. $where['shop_type'] = $cate;
  82. }
  83. if ($name) {
  84. $where['name'] = $name;
  85. }
  86. if ($shop_name) {
  87. $shop = Dever::db('shop/info')->find(array('name'=>$name));
  88. if ($shop) {
  89. $where['shop_id'] = $shop['id'];
  90. }
  91. }
  92. $where['state'] = 1;
  93. $data = Dever::db('shop/sell_order')->getExcel($where);
  94. if ($data) {
  95. foreach ($data as $k => $v) {
  96. $v['card'] = '';
  97. $v['card_code'] = '';
  98. if ($v['card_code_id']) {
  99. $code = Dever::db('card/code')->find($v['card_code_id']);
  100. if ($code) {
  101. $card_info = Dever::db('card/info')->find($code['card_id']);
  102. if ($card_info) {
  103. if (!$code['total_cash']) {
  104. $code['total_cash'] = $card_info['value'];
  105. }
  106. $v['card'] = $card_info['name'];
  107. $v['card_code'] = $code['card'];
  108. }
  109. }
  110. }
  111. if ($v['shop_type'] == 1) {
  112. $v['shop_type_name'] = '体验店';
  113. } elseif ($v['shop_type'] == 2) {
  114. $v['shop_type_name'] = '平台商城';
  115. }
  116. $shop = Dever::db('shop/info')->find(Array('id'=>$v['shop_id']));
  117. if (isset($shop) && $shop) {
  118. $data[$k]['shop_sid'] = $shop['sid'];
  119. $data[$k]['shop_name'] = $shop['name'];
  120. }
  121. $zhuce = '';
  122. $address_contact = '';
  123. $address_mobile = '';
  124. $address_info = '';
  125. if ($v['address_id'] > 0) {
  126. $address = Dever::load('passport/address')->getOne($v['uid'], $v['address_id']);
  127. if($address) {
  128. $address_contact = $address['contact'];
  129. $address_mobile = $address['mobile'];
  130. $address_info = $address['address_info'];
  131. $member = Dever::db('agent/member')->find(array('mobile'=>$address['mobile']));
  132. if ($member) {
  133. $zhuce = date('Y-m-d H:i',$member['cdate']);
  134. }
  135. }
  136. }
  137. $ps = Dever::db('shop/sell_order_ps')->find(array('order_id' => $v['id']));
  138. $cdate = strstr($v['cdate'], '-') ? $v['cdate'] : date('Y-m-d H:i', $v['cdate']);
  139. $paydate = isset($v['paydate']) && $v['paydate'] ? date('Y-m-d H:i', $v['paydate']) : '-';
  140. $operdate = ($ps && $ps['cdate']) ? date('Y-m-d H:i', $ps['cdate']) : '-';
  141. $goods = Dever::db('shop/sell_order_goods')->select(Array('order_id'=>$v['id']));
  142. $fdate = '';
  143. if ($v['fdate']) {
  144. $fdate = date('Y-m-d H:i',$v['fdate']);
  145. }
  146. foreach ($goods as $k1 => $v1) {
  147. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  148. if (isset($goods_info['sku'])) {
  149. $sku = $goods_info['sku']['string'];
  150. } else {
  151. $sku = '';
  152. }
  153. $goods_price = $v1['price']*$v1['num'];
  154. #代理优惠金额
  155. $discount_cash = round($v['discount_cash']/$goods_price,2);
  156. #商品实付金额
  157. $price = round(($v['price']/$goods_price),2);
  158. #礼品卡金额
  159. $card_code_cash = round(($v['card_code_cash']/$goods_price),2);
  160. #钱包金额
  161. $wallet_cash = round(($v['wallet_cash']/$goods_price),2);
  162. #商品支付金额
  163. if ($k1 == 0) {
  164. $total_cash = Dever::load("shop/lib/manage.getTotalCash", $v['id']);
  165. } else {
  166. $total_cash = 0;
  167. }
  168. if ($v['status'] == 8 || $v1['status'] == 3) {
  169. $num = $v1['num'];
  170. $v['refund_cash'] = $v1['price']*$v1['num'];
  171. $refund_status = '已退款';
  172. $refund_cdate = '';
  173. if ($v['shop_type'] == 1) {
  174. $refund = Dever::db('shop/sell_order_refund')->find(array('order_id'=>$v['id']));
  175. if ($refund) {
  176. $refund_cdate = date('Y-m-d H:i',$refund['cdate']);
  177. }
  178. }
  179. } else {
  180. $refund_cdate = '';
  181. $num = '0';
  182. $v['refund_cash'] = '0';
  183. $refund_status = '未退款';
  184. }
  185. if ($v['status'] >=7) {
  186. $v['price'] = 0;
  187. }
  188. if ($k1 == 0) {
  189. $v['num'] = $v['num'];
  190. $v['card_code_cash'] = $v['card_code_cash'];
  191. $v['price'] = $v['price'];
  192. $v['wallet_cash'] = $v['wallet_cash'];
  193. $v['coupon_cash'] = $v['coupon_cash'];
  194. $v['discount_cash'] = $v['discount_cash'];
  195. } else {
  196. $v['num'] = 0;
  197. $v['card_code_cash'] = 0;
  198. $v['price'] = 0;
  199. $v['wallet_cash'] = 0;
  200. $v['coupon_cash'] = 0;
  201. $v['discount_cash'] = 0;
  202. }
  203. $d = array
  204. (
  205. $v['shop_type_name'],
  206. $data[$k]['shop_sid'],
  207. $data[$k]['shop_name'],
  208. $v['order_num'],
  209. $goods_info['code'] . "\t",
  210. $goods_info['cunhuo_code'] . "\t",
  211. $goods_info['name'],
  212. $sku,
  213. $goods_info['tax'],
  214. round($v1['price'], 2),
  215. round($v1['num'],2),
  216. round($v1['price']*$v1['num'], 2),
  217. $discount_cash,
  218. $price,
  219. $card_code_cash,
  220. $wallet_cash,
  221. $price,
  222. $v['card'],
  223. $v['card_code'],
  224. $zhuce,
  225. $cdate,
  226. $paydate,
  227. $operdate,
  228. $fdate,
  229. $v['num'],
  230. round($total_cash, 2),
  231. round($v['price'], 2),
  232. round($v['card_code_cash'], 2),
  233. round($v['wallet_cash'], 2),
  234. round($v['coupon_cash'], 2),
  235. round($v['discount_cash'], 2),
  236. $status[$v['status']],
  237. $refund_status,
  238. $refund_cdate,
  239. round($v['refund_cash'], 2),
  240. $address_contact,
  241. $address_mobile,
  242. $address_info,
  243. );
  244. $body[] = $d;
  245. if ($goods_info['price_type'] > 2 && isset($goods_info['goods']) && is_array($goods_info['goods'])) {
  246. foreach ($goods_info['goods'] as $k2 => $v2) {
  247. if ($v2['code']) {
  248. //$v2['code'] = '-' . $v2['code'];
  249. }
  250. $p = $v2['price'];
  251. if (is_numeric($v2['num']) && is_numeric($v2['price'])) {
  252. $p = $v2['price']*$v2['num'];
  253. }
  254. $goods_price1 = 0;
  255. $d = array
  256. (
  257. $v['shop_type_name'],
  258. $data[$k]['shop_sid'],
  259. $data[$k]['shop_name'],
  260. $v['order_num'],
  261. $goods_info['code'] . "\t",
  262. $goods_info['cunhuo_code'] . "\t",
  263. $goods_info['name'],
  264. $sku,
  265. $goods_info['tax'],
  266. round($v1['price'], 2),
  267. round($v1['num'],2),
  268. round($v1['price']*$v1['num'], 2),
  269. $discount_cash,
  270. $price,
  271. $card_code_cash,
  272. $wallet_cash,
  273. $price,
  274. $v['card'],
  275. $v['card_code'],
  276. $zhuce,
  277. $cdate,
  278. $paydate,
  279. $operdate,
  280. $fdate,
  281. '',
  282. '',
  283. '',
  284. '',
  285. '',
  286. '',
  287. '',
  288. $status[$v['status']],
  289. '',
  290. '',
  291. '',
  292. $address_contact,
  293. $address_mobile,
  294. $address_info,
  295. );
  296. $body[] = $d;
  297. }
  298. }
  299. }
  300. }
  301. }
  302. $file = '商品销售相关数据';
  303. return Dever::excelExport($body, $header, $file);
  304. }
  305. public function memberGoods_api()
  306. {
  307. $name = Dever::input('name');
  308. $member_name = Dever::input('member_name');
  309. $card_num = Dever::input('card_num');
  310. $mobile = Dever::input('mobile');
  311. $start = Dever::input('start');
  312. $end = Dever::input('end');
  313. $rstart = Dever::input('rstart');
  314. $rend = Dever::input('end');
  315. $cstart = Dever::input('cstart');
  316. $cend = Dever::input('cend');
  317. if ($card_num) {
  318. $code = Dever::db('card/code')->find(array('card'=>$card_num));
  319. if ($code){
  320. $where['sku_id'] = "t_1.sku_id=".$code['id'];
  321. }
  322. }
  323. if ($name) {
  324. $where['name'] = "t_1.name like '%$name%'";
  325. }
  326. if ($cstart) {
  327. $where['cstart'] = 't_1.cdate+(360*86400)>='. strtotime($cstart);
  328. }
  329. if ($cend) {
  330. $where['cend'] = 't_1.cdate+(360*86400)<='.strtotime($cend);
  331. }
  332. if ($start) {
  333. $where['start'] = 't_1.cdate>='.strtotime($start);
  334. }
  335. if ($end) {
  336. $where['end'] = 't_1.cdate<='.strtotime($end);
  337. }
  338. if ($member_name) {
  339. $where['member_name'] = "t_2.name like '%$member_name%'";
  340. }
  341. if ($mobile) {
  342. $where['mobile'] = 't_2.mobile='.$mobile;
  343. }
  344. if ($rstart) {
  345. $where['rstart'] = 't_2.cdate>='.strtotime($rstart);
  346. }
  347. if ($rend) {
  348. $where['rend'] = 't_2.cdate<='.strtotime($rend);
  349. }
  350. $where['t_1.state'] = 't_1.state=1';
  351. $header = array('权益名称','会员等级','姓名','手机号','卡号','类型','数量','单件价值','总价值','已兑换价值','已使用价值','未兑换价值','未使用价值','备注','获取方式','获取时间','代理商注册时间','礼品卡有效期');
  352. $body = array();
  353. if ($where) {
  354. $where = implode(' and ', $where);
  355. $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);
  356. // $data = Dever::db('agent/member_goods')->getJoinAll($where);
  357. // echo Dever::sql();die;
  358. // print_R($data);die;
  359. if ($data) {
  360. foreach ($data as $k => $v) {
  361. $role_name = '';
  362. $member_name = '';
  363. $member_mobile = '';
  364. $member = Dever::db('agent/member')->find($v['mid']);
  365. if ($member) {
  366. $member_cdate = '-';
  367. if($member['cdate']){
  368. $member_cdate = date('Y-m-d H:i',$member['cdate']);
  369. }
  370. $member_name = $member['name'];
  371. $member_mobile = $member['mobile'];
  372. $role = Dever::db('setting/role')->find(array($member['role']));
  373. if ($role) {
  374. $role_name = $role['name'];
  375. }
  376. }
  377. $wd = ($v['total_num'] - $v['sell_num'])*$v['price'];
  378. $yd = $v['sell_num']*$v['price'];
  379. $card = '-';
  380. $mianzhi = '0';
  381. $money = '-';
  382. $youxiao = '';
  383. $leitype = '发放权益';
  384. if($v['type'] == 2){
  385. $code = Dever::db('card/code')->find($v['sku_id']);
  386. if($code){
  387. $card_info = Dever::db('card/info')->find($code['card_id']);
  388. if ($card_info && $card_info['end_dh_day']) {
  389. $youxiao = date('Y-m-d H:i',strtotime(+ $card_info['end_dh_day'].'day',$code['bdate']));
  390. }
  391. $card = $code['card']."\t";
  392. $mianzhi = $code['use_cash'];
  393. }
  394. }
  395. $wy = $v['cash'] - $mianzhi;
  396. $desc = '';
  397. $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));
  398. if($member_goods_log && $member_goods_log['desc']){
  399. $desc = $member_goods_log['desc'];
  400. }
  401. $d = array
  402. (
  403. $v['name'],
  404. $role_name,
  405. $member_name,
  406. $member_mobile,
  407. $card,
  408. $leitype,
  409. $v['total_num'],
  410. $v['price'],
  411. $v['cash'],
  412. $yd,
  413. $mianzhi,
  414. $wd,
  415. $wy,
  416. $desc,
  417. '',
  418. date('Y-m-d H:i',$v['cdate']),
  419. $member_cdate,
  420. $youxiao,
  421. );
  422. $body[] = $d;
  423. }
  424. }
  425. }
  426. $file = '代理商权益';
  427. return Dever::excelExport($body, $header, $file);
  428. }
  429. #代理商权益发放使用兑换明细
  430. public function mingxi_api()
  431. {
  432. $name = Dever::input('name');
  433. $mobile = Dever::input('mobile');
  434. $card_num = Dever::input('card_num');
  435. $shop_name = Dever::input('shop_name');
  436. $shop_num = Dever::input('shop_num');
  437. $order_num = Dever::input('order_num');
  438. $start = Dever::input('start');
  439. $end = Dever::input('end');
  440. $type = Dever::input('type');
  441. if ($name) {
  442. $where['name'] = $name;
  443. }
  444. if ($mobile) {
  445. $where['mobile'] = $mobile;
  446. }
  447. if ($card_num) {
  448. $code = Dever::db('card/code')->find(array('card'=>$card_num));
  449. if ($code){
  450. $where['sku_id'] = $code['id'];
  451. }
  452. }
  453. if ($shop_name) {
  454. $shop = Dever::db('shop/info')->find(array('name'=>$shop_name));
  455. $where['shop_id'] = $shop['id'];
  456. }
  457. if ($shop_num) {
  458. $shop = Dever::db('shop/info')->fetch('select * from churen_shop_info where sid = '.$shop_num.' and state = 1');
  459. $where['shop_id'] = $shop['id'];
  460. }
  461. // print_R($where['shop_id']);die;
  462. if ($order_num) {
  463. $sell_order = Dever::db('shop/sell_order')->find(array('order_num'=>$order_num));
  464. $where['sku_id'] = $sell_order['card_code_id'];
  465. }
  466. if ($start) {
  467. $where['start'] = strtotime($start);
  468. }
  469. if ($end) {
  470. $where['end'] = strtotime($end);
  471. }
  472. if ($type) {
  473. $where['types'] = $type;
  474. }
  475. $header = array('日期','权益名称','会员等级','姓名','手机号','卡号','类型','数量','单件价值','总价值','门店类型','门店编号','门店名称','关联平台商城订单号','备注','获取方式','获取时间','代理商注册时间','礼品卡有效期');
  476. $body = array();
  477. $where['type'] = '1,2';
  478. $data = Dever::db('agent/member_goods')->getMingxi($where);
  479. if ($data) {
  480. foreach ($data as $k =>$v) {
  481. $cdata = '';
  482. if ($v['cdate']) {
  483. $cdate = date('Y-m-d H:i',$v['cdate']);
  484. }
  485. $type = '发放权益';
  486. $role_name = '';
  487. $member_name = '';
  488. $member_mobile = '';
  489. $member_cdate = '-';
  490. $member = Dever::db('agent/member')->find($v['mid']);
  491. if ($member) {
  492. if($member['cdate']){
  493. $member_cdate = date('Y-m-d H:i',$member['cdate']);
  494. }
  495. $member_name = $member['name'];
  496. $member_mobile = $member['mobile'];
  497. $role = Dever::db('setting/role')->find(array($member['role']));
  498. if ($role) {
  499. $role_name = $role['name'];
  500. }
  501. }
  502. $card = '';
  503. $youxiao = '';
  504. if ($v['type'] == 2){
  505. $code = Dever::db('card/code')->find($v['sku_id']);
  506. if($code){
  507. $card_info = Dever::db('card/info')->find($code['card_id']);
  508. if ($card_info && $card_info['end_dh_day']) {
  509. $youxiao = date('Y-m-d H:i',strtotime(+ $card_info['end_dh_day'].'day',$code['bdate']));
  510. }
  511. $card = $code['card']."\t";
  512. }
  513. }
  514. $desc = '';
  515. $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));
  516. if($member_goods_log && $member_goods_log['desc']){
  517. $desc = $member_goods_log['desc'];
  518. }
  519. $dh_order_ps = Dever::db('agent/dh_order_ps')->getDui($v['mid']);
  520. if ($dh_order_ps) {
  521. $type = '兑换权益';
  522. foreach ($dh_order_ps as $k =>$v) {
  523. $dh_order = Deverr::db('agent/dh_order_ps')->find($v['order_id']);
  524. if ($dh_order && isset($dh_order['info']) && $dh_order['info']){
  525. $desc = $dh_order['info'];
  526. }
  527. }
  528. }
  529. if ($where['types'] == 2) {
  530. if (!$dh_order_ps) {
  531. $file = '代理商权益明细';
  532. return Dever::excelExport($body, $header, $file);
  533. }
  534. }
  535. $shop_name = '';
  536. $shop_type = '';
  537. $shop_sid = '';
  538. $order_num = '';
  539. if (isset($where['shop_id']) && $where['shop_id']) {
  540. // print_R($where['shop_id']);die;
  541. $where['types'] = 3;
  542. $sell_order = Dever::db('shop/sell_order')->find(array('shop_id'=>$where['shop_id']));
  543. if ($sell_order) {
  544. $w = $this->common($sell_order);
  545. $type = '使用权益';
  546. if ($w) {
  547. $shop_name = $w['shop_name'];
  548. $shop_type = $w['shop_type'];
  549. $shop_sid = $w['shop_sid'];
  550. $order_num = $w['order_num'];
  551. $d = array
  552. (
  553. $cdate,
  554. $v['name'],
  555. $role_name,
  556. $member_name,
  557. $member_mobile,
  558. $card,
  559. $type,
  560. $v['total_num'],
  561. $v['price'],
  562. $v['cash'],
  563. $shop_type,
  564. $shop_sid,
  565. $shop_name,
  566. $order_num,
  567. $desc,
  568. '',
  569. date('Y-m-d H:i',$v['cdate']),
  570. $member_cdate,
  571. $youxiao,
  572. );
  573. $body[] = $d;
  574. }
  575. $file = '代理商权益明细';
  576. return Dever::excelExport($body, $header, $file);
  577. }
  578. } else {
  579. $sell_order = Dever::db('shop/sell_order')->find(array('card_code_id'=>$v['sku_id']));
  580. }
  581. if ($where['types'] == 3) {
  582. if (!$sell_order) {
  583. $file = '代理商权益明细';
  584. return Dever::excelExport($body, $header, $file);
  585. }
  586. }
  587. if ($sell_order) {
  588. $type = '使用权益';
  589. $w = $this->common($sell_order);
  590. if ($w) {
  591. $shop_name = $w['shop_name'];
  592. $shop_type = $w['shop_type'];
  593. $shop_sid = $w['shop_sid'];
  594. $order_num = $w['order_num'];
  595. }
  596. }
  597. $d = array
  598. (
  599. $cdate,
  600. $v['name'],
  601. $role_name,
  602. $member_name,
  603. $member_mobile,
  604. $card,
  605. $type,
  606. $v['total_num'],
  607. $v['price'],
  608. $v['cash'],
  609. $shop_type,
  610. $shop_sid,
  611. $shop_name,
  612. $order_num,
  613. $desc,
  614. '',
  615. date('Y-m-d H:i',$v['cdate']),
  616. $member_cdate,
  617. $youxiao,
  618. );
  619. $body[] = $d;
  620. }
  621. }
  622. $file = '代理商权益明细';
  623. // Dever::input('excel_name');
  624. return Dever::excelExport($body, $header, $file);
  625. }
  626. public function common($sell_order)
  627. {
  628. $w = array();
  629. $w['order_num'] = $sell_order['order_num'];
  630. $shop = Dever::db('shop/info')->find($sell_order['shop_id']);
  631. if ($shop) {
  632. $w['shop_name'] = $shop['name'];
  633. $w['shop_sid'] = $shop['sid'];
  634. if ($shop['type'] = 1) {
  635. $w['shop_type'] = '体验店';
  636. } elseif ($shop['type'] = 2) {
  637. $w['shop_type'] = '零售店';
  638. } elseif ($shop['type'] = 10) {
  639. $w['shop_type'] = '平台商城';
  640. }
  641. }
  642. return $w;
  643. }
  644. }