1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264 |
- <?php
- namespace Agent\Lib;
- use Dever;
- class Dhorder
- {
- # 获取配置
- public $config = array();
- # table
- public $table = 'agent/dh_order';
- public function __construct()
- {
- $this->config = Dever::db($this->table)->config;
- }
- # 设置订单的类型
- public function set($type, $view)
- {
- return $this;
- }
- # 获取公共的where
- public function where($id)
- {
- $where = array();
- $where['mid'] = $id;
- if (!$where) {
- Dever::alert('参数错误');
- }
- return $where;
- }
- # 获取订单列表
- public function getList($id)
- {
- $result = array();
- $where = $this->where($id);
- $mobile = Dever::input('mobile');
- if ($mobile) {
- $where['mobile'] = $mobile;
- }
- $status = Dever::input('status');
- if ($status) {
- $where['status'] = $status;
- }
- $result['order'] = Dever::db($this->table)->getAll($where);
- if ($result['order']) {
- foreach ($result['order'] as $k => $v) {
- $result['order'][$k] = $this->getInfo($v, false);
- }
- }
- return $result;
- }
- # 查看详情
- public function getView($id, $order_id, $show = true)
- {
- $where = $this->where($id);
- $where['id'] = $order_id;
- $result = Dever::db($this->table)->find($where);
- if (!$result) {
- Dever::alert('订单不存在');
- }
- if ($show) {
- $result = $this->getInfo($result);
- }
- return $result;
- }
- # 获取订单详细信息
- public function getInfo($info, $view = true)
- {
- $info['status_name'] = Dever::status($this->config['status'], $info['status']);
- $info['cdate'] = date('Y-m-d H:i', $info['cdate']);
- if ($info['operdate']) {
- $info['operdate'] = date('Y-m-d H:i', $info['operdate']);
- } else {
- $info['operdate'] = '';
- }
- if ($info['fdate']) {
- $info['fdate'] = date('Y-m-d H:i', $info['fdate']);
- } else {
- $info['fdate'] = '';
- }
- if ($view && $info['type'] == 1) {
- $info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
- if ($info['ps_info']) {
- $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
- $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
- if ($info['ps_info']['qu_date']) {
- $info['ps_info']['qu_date'] = date('Y-m-d H:i', $info['ps_info']['qu_date']);
- }
- if ($info['ps_info']['qs_date']) {
- $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
- }
- $status = Dever::db('agent/dh_order_ps')->config['status'];
- $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
- if ($info['ps_info']['service']) {
- foreach ($info['ps_info']['service'] as $k => $v) {
- if (isset($v['order_num']) && $v['order_num']) {
- $info['ps_info']['service'][$k]['service_name'] = '商家自送';
- if ($v['service_id'] > 0) {
- $service = Dever::db('shop/service')->find($v['service_id']);
- $info['ps_info']['service'][$k]['service_name'] = $service['name'];
- }
- } else {
- unset($info['ps_info']['service'][$k]);
- }
- }
- }
- }
- $goods_status = Dever::db('agent/dh_order_goods')->config['status'];
- if ($info['address_id']) {
- $info['address'] = Dever::db('agent/member_address')->find($info['address_id']);
- }
- $info['goods'] = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
- foreach ($info['goods'] as $k => $v) {
- $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
- if (isset($goods_info['sku'])) {
- $sku = $goods_info['sku']['string'];
- } else {
- $sku = '';
- }
- $info['goods'][$k] += array
- (
- 'pic' => $goods_info['cover'],
- 'name' => $goods_info['name'],
- 'sku' => $sku,
- 'price' => $goods_info['price'],
- );
- }
- }
- if ($info['type'] == 2) {
- $info['card'] = Dever::db('card/info')->find($info['type_id']);
- }
- if ($info['type'] == 3) {
- $info['prize'] = Dever::db('setting/prize')->find($info['type_id']);
- }
- return $info;
- }
- # 取消订单
- public function cancel($id, $order_id)
- {
- $data = $this->getView($id, $order_id, false);
- if ($data['status'] == 1) {
- $state = Dever::db('agent/dh_order')->update(array('where_id' => $data['id'], 'status' => 7, 'operdate' => time()));
- if ($state) {
- $this->updateSell($data, 2);
- }
- return 'ok';
- } else {
- Dever::alert('当前订单状态不允许取消');
- }
- }
- # 得到商品和总价
- public function goods($mid)
- {
- $goods_id = Dever::input('goods_id');
- if (!$goods_id) {
- Dever::alert('请传入商品');
- }
- $goods_id = explode(',', $goods_id);
-
- $num = Dever::input('num');
- if (!$num) {
- Dever::alert('请传入商品数量');
- }
- $num = explode(',', $num);
- $data['price'] = 0;
- $data['num'] = 0;
- $data['name'] = array();
- $count = count($goods_id);
- $data['list'] = array();
- $i = 0;
- foreach ($goods_id as $k => $v) {
- $n = isset($num[$k]) ? $num[$k] : 1;
- $data['list'][$i] = Dever::db('agent/member_goods')->find(array('mid' => $mid, 'id' => $v));
- if ($data['list'][$i]) {
- $data['list'][$i]['num'] = $n;
- # 2是库存不足
- $data['list'][$i]['ku_state'] = 1;
- $total = $data['list'][$i]['total_num'] - $data['list'][$i]['sell_num'];
- if ($total >= $n) {
- $data['list'][$i]['buy_num'] = $n;
- } else {
- $data['list'][$i]['buy_num'] = $total;
- }
- if ($data['list'][$i]['buy_num'] <= 0) {
- $data['list'][$i]['ku_state'] = 2;
- $data['list'][$i]['buy_num'] = 0;
- }
- $goods_info = Dever::load('goods/lib/info')->getInfoBySku($data['list'][$i]['type_id'], $data['list'][$i]['sku_id']);
- if (isset($goods_info['sku'])) {
- $sku = $goods_info['sku']['string'];
- } else {
- $sku = '';
- }
- $data['list'][$i] += array
- (
- 'pic' => $goods_info['cover'],
- 'name' => $goods_info['name'],
- 'sku' => $sku,
- 'price' => $goods_info['price'],
- );
- if ($data['list'][$i]['ku_state'] == 1) {
- $data['num'] += $data['list'][$i]['buy_num'];
- $data['price'] += $goods_info['price'] * $data['list'][$i]['buy_num'];
- $data['name'] = '兑换商品';
- }
- $i++;
- }
- }
- if ($data['num'] <= 0) {
- Dever::alert('没有商品可以兑换');
- }
- return $data;
- }
- # 确认兑换
- public function action($user, $name, $num, $price, $goods, $address_id, $dh_type, $type, $type_id, $info, $refer = '')
- {
- # 获取平台店
- $shop = Dever::db('shop/info')->find(array('type' => 10));
- if (!$shop) {
- Dever::alert('没有平台店');
- }
- $order_data['shop_id'] = $shop['id'];
- $order_data['mid'] = $user['id'];
- $order_data['mobile'] = $user['mobile'];
- $order_data['address_id'] = $address_id;
- $order_data['name'] = $name;
- $order_data['num'] = $num;
- $order_data['info'] = $info;
- $order_data['price'] = $price;
- $order_data['dh_type'] = $dh_type;
- $order_data['type'] = $type;
- if ($type_id) {
- $order_data['type_id'] = $type_id;
- }
- if ($dh_type == 2) {
- $order_data['status'] = 5;
- } else {
- $order_data['status'] = 2;
- }
-
- $order_data['refund_cash'] = 0;
- $order_data['audit'] = 2;
- $order_data['order_num'] = $this->getOrderId();
- $id = Dever::db('agent/dh_order')->insert($order_data);
- if (!$id) {
- Dever::alert('兑换失败');
- }
- if ($goods) {
- foreach($goods as $k => $v) {
- if ($v['ku_state'] == 1) {
- $data['mid'] = $user['id'];
- $data['order_id'] = $id;
- $data['shop_id'] = $shop['id'];
- $data['goods_id'] = $v['type_id'];
- $data['sku_id'] = $v['sku_id'];
- $data['price'] = $v['price'];
- $data['num'] = $v['buy_num'];
- Dever::db('agent/dh_order_goods')->insert($data);
- }
- }
- }
- # 减少库存 增加销量
- $order_data['id'] = $id;
- $this->updateSell($order_data);
- return array
- (
- 'order_num' => $order_data['order_num'],
- 'order_id' => $id,
- 'type' => 'dh',
- );
- }
- # 添加配送信息
- public function updatePs($order, $status = 1, $service_id = -1, $order_num = '')
- {
- $where['order_id'] = $order['id'];
- $where['clear'] = true;
- $data = Dever::db('agent/dh_order_ps')->find($where);
- $service = array();
- if ($service_id) {
- $service['service_id'] = $service_id;
- }
- if ($order_num) {
- $service['order_num'] = $order_num;
- }
- if (!$data) {
- $insert = $where;
- if ($service) {
- $insert['service'][] = $service;
- $insert['service'] = Dever::array_encode($insert['service']);
- }
- $insert['status'] = $status;
- if ($status == 2) {
- $insert['qu_date'] = time();
- }
-
- Dever::db('agent/dh_order_ps')->insert($insert);
- } else {
- $update = $where;
- $update['where_id'] = $data['id'];
- $update['status'] = $status;
- if ($status == 2) {
- $update['qu_date'] = time();
- }
- if ($status == 3) {
- $update['qs_date'] = time();
- }
- if ($service) {
- $data['service'] = Dever::array_decode($data['service']);
- $update['service'] = $data['service'];
- $update['service'][] = $service;
- $insert['service'] = Dever::array_encode($update['service']);
- }
- Dever::db('agent/dh_order_ps')->update($update);
- }
- }
- # 减少库存,增加销量
- public function updateSell($order, $type = 1)
- {
- $method = 'incSell';
- $name = '兑换商品';
- $name_3 = '兑换名额';
- if ($type == 2) {
- $method = 'decSell';
- $name = '退回商品';
- $name_3 = '退回名额';
- }
- if ($order['type'] == 1) {
- $where['order_id'] = $order['id'];
- //$where['status'] = 3;
- $data = Dever::db('agent/dh_order_goods')->select($where);
- if ($data) {
- foreach ($data as $k => $v) {
- $up['where_mid'] = $order['mid'];
- $up['where_type'] = $order['type'];
- $up['where_type_id'] = $v['goods_id'];
- $up['where_sku_id'] = $v['sku_id'];
- $info = Dever::db('agent/member_goods')->findData($up);
- $up['set_sell_num'] = $v['num'];
- Dever::db('agent/member_goods')->$method($up);
- if ($type == 2) {
- 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);
- } else {
- 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);
- }
-
- }
- }
- } elseif ($order['type'] == 3) {
- $up['where_mid'] = $order['mid'];
- $up['where_type'] = $order['type'];
- $up['where_type_id'] = $order['type_id'];
- $up['where_sku_id'] = -1;
- $info = Dever::db('agent/member_goods')->findData($up);
- $up['set_sell_num'] = $order['num'];
- Dever::db('agent/member_goods')->$method($up);
- if ($type == 2) {
- 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);
- } else {
- 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);
- }
-
- }
- }
- # 完成
- public function finish($info, $shop_id)
- {
- if ($info && $info['shop_id'] == $shop_id && $info['status'] <= 4) {
- $status = 5;
- $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => $status, 'fdate' => time()));
- $this->updatePs($info, 3);
- $w['parent_type'] = 3;
- $w['parent_order_id'] = $info['id'];
- $w['status'] = 4;
- $buy_order = Dever::db('shop/buy_order')->select($w);
- if ($buy_order) {
- foreach ($buy_order as $k => $v) {
- Dever::load('mshop/lib/buy')->set(1,1)->finish($shop_id, $v['id']);
- }
- }
- return 'ok';
- } else {
- Dever::alert('您没有权限核销');
- }
- }
- # 平台订单已收货
- public function yes_api()
- {
- $shop_id = Dever::input('shop_id');
- $order_id = Dever::input('order_id');
- $info = Dever::db('agent/dh_order')->find(array('id' => $order_id));
- if ($info && $info['type'] == 10) {
- $this->finish($info, $shop_id);
- } else {
- Dever::alert('您没有权限核销');
- }
- return 'reload';
- }
- # 生成订单号
- public function getOrderId()
- {
- $where['order_num'] = Dever::order('DH');
- $state = Dever::db('agent/dh_order')->one($where);
- if (!$state) {
- return $where['order_num'];
- } else {
- return $this->getOrderId();
- }
- }
- # 展示订单详情
- public function show()
- {
- $id = Dever::input('order_id');
- $config = Dever::db('agent/dh_order')->config;
- $info = Dever::db('agent/dh_order')->one($id);
- if ($info['type'] > 1) {
- return;
- }
- $tk_status = Dever::db('agent/dh_order_refund')->config['status'];
- $tk_process = Dever::db('agent/dh_order_refund')->config['process'];
- $status = $config['status'][$info['status']];
- $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'type' => 1));
- $shop = Dever::db('shop/info')->find($info['shop_id']);
- $user = Dever::db('agent/member')->find($info['mid']);
- $cdate = date('Y-m-d H:i', $info['cdate']);
- if ($info['operdate']) {
- $opertime = date('Y-m-d H:i', $info['operdate']);
- } else {
- $opertime = '';
- }
- if ($info['fdate']) {
- $fdate = date('Y-m-d H:i', $info['fdate']);
- } else {
- $fdate = '';
- }
- if (!$user) {
- $user['username'] = '无';
- }
- if (!isset($user['name'])) {
- $user['truename'] = $user['name'];
- }
- if ($tk && $tk['process'] == 1) {
- $status = '申请' . $tk_status[$tk['status']];
- $process = $tk_process[$tk['process']];
- $process = '';
- }
- $time = array();
- $time[] = array('下单时间', $cdate);
- if ($opertime) {
- if ($info['status'] == 2) {
- $time[] = array('通知时间', $opertime);
- }
- if ($info['status'] == 7) {
- $time[] = array('取消时间', $opertime);
- }
- }
- if ($fdate) {
- $time[] = array('完成时间', $fdate);
- }
- $time[] = array('审核备注', $info['audit_desc']);
- $result = array();
- $result[$info['order_num']] = array
- (
- 'type' => 'info',
- 'content' => array
- (
- array
- (
- array('订单状态', $status),
- array('代理商姓名', $user['name']),
- array('联系电话', $info['mobile']),
- ),
- $time,
- )
- );
- if ($info['address_id'] > 0) {
- $address = Dever::load('agent/address')->getOne($info['mid'], $info['address_id']);
- if ($address) {
- $result['收货地址'] = array
- (
- 'type' => 'info',
- 'content' => array
- (
- array
- (
- array('联系人', $address['contact']),
- array('联系电话', $address['mobile']),
- ),
- array
- (
- array('收货地址', $address['address_info']),
- array('门牌号', $address['house_number']),
- ),
- ),
- );
- }
- }
- $info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
- if ($info['ps_info']) {
- $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
- $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
- if ($info['ps_info']['qs_date']) {
- $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
- } else {
- $info['ps_info']['qs_date'] = '无';
- }
- $status = Dever::db('agent/dh_order_ps')->config['status'];
- $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
-
- $service = array();
- if ($info['ps_info']['service']) {
- foreach ($info['ps_info']['service'] as $k => $v) {
- if (isset($v['order_num']) && $v['order_num']) {
- $info['ps_info']['service'][$k]['service_name'] = '商家自送';
- if ($v['service_id'] > 0) {
- $service_info = Dever::db('shop/service')->find($v['service_id']);
- $info['ps_info']['service'][$k]['service_name'] = $service_info['name'];
- }
- $service[] = array
- (
- array('名称', $info['ps_info']['service'][$k]['service_name']),
- array('单号', isset($v['order_num']) ? $v['order_num'] : ''),
- );
- }
- }
- }
- $result['物流信息'] = array
- (
- 'type' => 'info',
- 'content' => array
- (
- array
- (
- array('发货时间', $info['ps_info']['cdate']),
- array('收货时间', $info['ps_info']['qs_date']),
- array('查单', '<a href="https://www.kuaidi100.com/?from=openv" target="_blank">点此手动查单</a>'),
- ),
- ),
- );
- $result['物流信息']['content'] = array_merge($result['物流信息']['content'], $service);
- }
- if (!$info['refund_cash']) {
- $info['refund_cash'] = 0;
- }
- if ($info['refund_cash'] > 0 && $tk) {
- $process = $tk_process[$tk['process']];
- $tk['cdate'] = date('Y-m-d H:i', $tk['cdate']);
- $result['退款信息'] = array
- (
- 'type' => 'info',
- 'content' => array
- (
- array
- (
- array('退款金额', $info['refund_cash']),
- array('数量', $info['num']),
- array('退款进度', $process),
- ),
- array
- (
- array('申请时间', $tk['cdate']),
- array('退款原因', $tk['desc']),
- ),
- ),
- );
- }
- $body = $refund_body = array();
- $body_total = array();
- $body_total['price'] = 0;
- $body_total['num'] = 0;
- $refund_body_total = array();
- $refund_body_total['price'] = 0;
- $refund_body_total['num'] = 0;
- $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
- $goods_status = Dever::db('agent/dh_order_goods')->config['status'];
- foreach ($goods as $k => $v) {
- $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
- $status = Dever::status($goods_status, $v['status']);
- $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
- if ($tk && $tk['process'] == 1) {
- $status = '申请' . $tk_status[$tk['status']];
- //$status .= ' [' . $tk_process[$tk['process']] . ']';
- }
- if (isset($goods_info['sku'])) {
- $sku = $goods_info['sku']['string'];
- } else {
- $sku = '无';
- }
- if ($info['status'] > 1 && $info['status'] < 7) {
- $tui = Dever::url('buy_order_tui?shop_id='.$v['shop_id'].'&order_goods_id=' . $v['id'] . '&order_id=' . $info['id'] . '&cash=' . $v['price'], 'shop');
- $status = '<a href="javascript:;" onclick="fastEdit($(this), \''.$tui.'\', \'退款\', \'\', 1)" class="layui-btn">退款</a>';
- $status = '';
- }
- $d = array
- (
- 'pic' => $goods_info['cover'],
- 'name' => $goods_info['name'],
- 'sku' => $sku,
- 'price' => $v['price'],
- 'num' => $v['num'],
- 'status' => $status,
- );
- if ($tk && $v['status'] == 3) {
- $d['status'] = $tk_status[$tk['status']];
- $refund_body[] = $d;
- $price = $v['price']*$v['num'];
- $refund_body_total['price'] += $price;
- $refund_body_total['num'] += $v['num'];
- } else {
- $body[] = $d;
- $price = $v['price']*$v['num'];
- $body_total['price'] += $price;
- $body_total['num'] += $v['num'];
- }
- }
- if ($body) {
- if ($refund_body_total['price']) {
- $body_total['set_price'] = $body_total['price'] - $refund_body_total['price'];
- }
- if ($refund_body_total['num']) {
- $body_total['set_num'] = $body_total['num'] - $refund_body_total['num'];
- }
- $result['商品清单'] = array
- (
- 'type' => 'list',
- 'content' => $body,
- 'total' => $body_total,
- );
- }
- if ($refund_body) {
- $result['退款商品'] = array
- (
- 'type' => 'list',
- 'content' => $refund_body,
- 'total' => $refund_body_total,
- );
- }
- # 平台门店采购单
- $buy_order = Dever::db('shop/buy_order')->getDataToId(array('type' => 1, 'type_id' => $info['shop_id'], 'parent_type' => 3, 'parent_order_id' => $info['id']));
- $source_order_id = array();
- if ($buy_order) {
- $source_order_id = array_keys($buy_order);
- }
- # 平台门店结算单
- if ($source_order_id) {
- $cash_order = Dever::db('cash/order')->getDataByOrderId(array('source_order_id' => $source_order_id));
- $col = 'cash';
- }
- if (isset($cash_order) && $cash_order) {
- $head = array('序号', '结算单号', '数量', '金额', '结算类型', '入账状态', '审核状态', '结算时间', '审核备注', '管理');
- $body = array();
- $config = Dever::db('cash/order')->config;
- foreach ($cash_order as $k => $v) {
- $cdate = date('Y-m-d H:i', $v['cdate']);
- $fdate = $v['fdate'] ? date('Y-m-d H:i', $v['fdate']) : '';
- $operdate = $v['operdate'] ? date('Y-m-d H:i', $v['operdate']) : '';
- $cash = $v[$col];
- $url = Dever::url('project/database/list?project=shop&table=buy_order_goods&order_id='.$v['source_order_id'].'&page_type=1', 'manage');
- $v['source_order_num'] = '<a href="'.$url.'" style="color:blue">'.$v['source_order_num'].'</a>';
- $m = '';
- if ($v['audit'] == 1 && $v['audit_type'] == 2) {
- $url = Dever::url('project/database/update?project=cash&table=order&where_id='.$v['id'].'&col=audit,desc', 'manage');
- $m = '<a href="javascript:;" onclick="fastEdit($(this), \''.$url.'\', \'审核\', \'\', 1)" class="layui-btn">审核</a>';
- }
- $d = array
- (
- $k+1,
- $v['order_num'],
- $v['num'],
- $cash,
- $config['config_jstype'][$v['jstype']],
- $config['config_status'][$v['status']],
- $config['config_audit'][$v['audit']],
- $operdate,
- $v['desc'],
- $m,
- );
- $body[] = $d;
- }
- $result['对账清单'] = array
- (
- 'type' => 'table',
- 'content' => array
- (
- 'head' => $head,
- 'body' => $body,
- )
- );
-
- }
- $head_btn[] = array
- (
- 'type' => 'link',
- 'link' => Dever::url('project/database/list?project=agent&table=dh_order&menu=agent&search_option_state=1', 'manage'),
- 'name' => '返回上一页',
- );
- $audit = Dever::input('audit');
- if($audit==1){
- # 审核信息
- $this->show_audit($info, $result);
- }
- $head = array
- (
- 'name' => '基本信息',
- 'btn' => $head_btn,
- );
- $html = Dever::show($head, $result);
- return $html;
- }
- private function show_audit($info, &$result)
- {
- $info['type'] = 3;
- $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id'], 'status' => 1));
- $shop = Dever::db('shop/info')->find($info['shop_id']);
- list($data, $source) = Dever::load('mshop/lib/buy')->assign($goods, $info, $shop, true);
- // print_R($data);die;
- if ($info) {
- $head = array('序号', '商品编号', '商品名称', '供货商', '订货总数量', '商品计量单位', '订货单总金额');
- $body = array();
- $i = 0;
- if ($data) {
- foreach ($data as $k => $v) {
- foreach ($v as $v1) {
- $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
- if (isset($goods_info['sku'])) {
- $sku = '[' . $goods_info['sku']['string'] . ']';
- } else {
- $sku = '';
- }
- $d = array
- (
- $i+1,
- $goods_info['code'],
- $goods_info['name'] . $sku,
- Dever::load('mshop/lib/buy')->getSelect($source, $v1['source_id'], $v1['order_goods_id']),
- $v1['num'],
- $goods_info['unit'],
- $v1['price'] * $v1['num'],
- );
- $body[] = $d;
- $i++;
- }
- }
- }
-
- if ($goods) {
- foreach ($goods as $k => $v) {
- $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
- if (isset($goods_info['sku'])) {
- $sku = '[' . $goods_info['sku']['string'] . ']';
- } else {
- $sku = '';
- }
- $d = array
- (
- $i+1,
- $goods_info['code'],
- $goods_info['name'] . $sku,
- Dever::load('mshop/lib/buy')->getSelect($source, false, $v['id']),
- $v['num'],
- $goods_info['unit'],
- $v['price'] * $v['num'],
- );
- $body[] = $d;
- $i++;
- }
- }
- $btn = array();
- $btn[] = array(
- 'type' => 'click',
- 'content' => 'setAudit()',
- 'name' => '全部调整<script>function setAudit(){layer.confirm(\'确定进行此项操作吗?\', function(){var audit = $(\'.audit_set\').val();$(\'.audit\').each(function(){$(this).val(audit);layui.form.render();layer.closeAll()})})}</script>'
- );
- $result['商品拆单'] = array
- (
- 'type' => 'table',
- 'head' => array('name' => '供货商:' . Dever::load('mshop/lib/buy')->getSelect($source, false, false), 'btn' => $btn),
- 'content' => array
- (
- 'head' => $head,
- 'body' => $body,
- )
- );
- $url = Dever::url('lib/dhorder.audit_set_commit?json=1&order_id=' . $info['id'], 'agent');
- // print_R($url);die;
- $result['审核结果'] = array
- (
- 'type' => 'html',
- '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"> 审核通过 <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"> 审核未通过 </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>',
- );
- }
- }
- # 采购订单审核 手动拆单
- public function audit_set_commit_api()
- {
- Dever::config('base')->hook = true;
- //{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"}
- $id = Dever::input('order_id');
- $goods = Dever::input('goods');
- $audit = Dever::input('audit');
- $audit_text = Dever::input('audit_text');
- $info = Dever::db('agent/dh_order')->one($id);
- if ($audit > 1 && $info && $info['status'] == 2) {
- $shop = Dever::db('shop/info')->find($info['shop_id']);
- if ($audit == 2) {
- Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
- # 成功
- if (strstr($info['order_num'], '_')) {
- $temp = explode('_', $info['order_num']);
- $info['order_num'] = $temp[0];
- $info['order_index'] = $temp[1];
- } else {
- $info['order_index'] = 0;
- }
- $goods = explode(',', $goods);
- $data = $other = array();
- foreach ($goods as $k => $v) {
- list($source_type, $source_id, $name, $goods_id) = explode('_', $v);
- $gv = Dever::db('agent/dh_order_goods')->find($goods_id);
- if ($source_id > 0) {
- $key = $source_type . '_' . $source_id;
- $data[$key][] = array
- (
- 'area' => $shop['area'],
- 'order_id' => $info['id'],
- 'order_type' => 3,
- 'order_num' => $info['order_num'],
- 'order_index' => $info['order_index'],
- 'type' => 1,
- 'type_id' => $shop['id'],
- 'source_type' => $source_type,
- 'source_id' => $source_id,
- 'order_goods_id' => $gv['id'],
- 'goods_id' => $gv['goods_id'],
- 'sku_id' => $gv['sku_id'],
- 'price' => $gv['price'],
- 'p_price' => $gv['price'],
- 'num' => $gv['num'],
- );
- } else {
- $other[] = $gv;
- }
- }
- $this->audit_action($data, $other, $info, $shop, 1);
- } else {
- Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text, 'status' => 7));
- Dever::load('agent/lib/dhorder')->updateSell($info, 2);
- if (Dever::project('sms')) {
- $member = Dever::db('agent/member')->find($info['mid']);
- Dever::load('sms/api')->send('daili_goods_no', $member['mobile'], array('name' => $member['name'], 'content' => $audit_text));
- }
- }
- }
- 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');
- }
- # 采购订单审核 拆单
- public function audit_commit()
- {
- $order_id = Dever::input('order_id');
- $order = Dever::db('agent/dh_order')->find($order_id);
- if (!$order || ($order && $order['status'] != 2)) {
- Dever::alert('当前订单状态无法拆单');
- }
- // if ($order['shop_type'] != 2) {
- // Dever::alert('这不是平台店的订单');
- // }
- $order['type'] = 3;
- $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
- $shop = Dever::db('shop/info')->find($order['shop_id']);
- $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
- $this->audit_action($data, $goods, $order, $shop);
- return 'ok';
- }
- private function audit_action($data, $goods, $order, $shop, $state = 2)
- {
- $send = array();
- if (!$goods && $data) {
- # 开始生成订单
- $i = $order['order_index'];
- foreach ($data as $k => $v) {
- foreach ($v as $k1 => $v1) {
- $v1['order_num'] .= '_' . $i;
- $state = Dever::load('mshop/lib/buy')->createOrder($v1);
- $send[$state] = $v1;
- }
- $i++;
- }
- Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
- } else {
- Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
- if ($goods) {
- $string = array();
- foreach ($goods as $k => $v) {
- $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
-
- if ($info['sku_name']) {
- $info['name'] .= '('.$info['sku_name'].')';
- }
- $string[] = $info['name'];
- }
- $string = implode('、', $string);
- if ($state == 1) {
- Dever::alert('商品:'.$string.'未选择供货商');
- } else {
- Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
- }
- Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
- } else {
- if ($state == 1) {
- Dever::alert('未选择供货商,该订单进入重新审核状态');
- } else {
- Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
- }
-
- }
- }
- if ($send) {
- foreach ($send as $k => $v) {
- Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
- $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
- Dever::load('cash/lib/order')->up($order_info, 1, 1);
- }
- }
- }
- # 第三方确认
- public function tixian()
- {
- $param = array();
- ksort($param);
- $string = array();
- foreach ($param as $k => $v) {
- if (strstr($v, '&') || strstr($v, '@')) {
- $v = urlencode($v);
- }
- $string[] = $k . '=' . $v;
- }
- }
-
- # 发货
- public function notice($info)
- {
- $config = Dever::db('agent/dh_order')->config;
- $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => 3, 'operdate' => time()));
- }
- # 采购订单审核 拆单
- /*
- public function audit_commit()
- {
- $order_id = Dever::input('order_id');
- $order = Dever::db('agent/dh_order')->find($order_id);
- if (!$order || ($order && $order['status'] != 2)) {
- Dever::alert('当前订单状态无法拆单');
- }
- $order['type'] = 3;
- $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
- $shop = Dever::db('shop/info')->find($order['shop_id']);
- $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
- $send = array();
- if (!$goods && $data) {
- # 开始生成订单
- $i = $order['order_index'];
- foreach ($data as $k => $v) {
- foreach ($v as $k1 => $v1) {
- $v1['order_num'] .= '_' . $i;
- $state = Dever::load('mshop/lib/buy')->createOrder($v1);
- $send[$state] = $v1;
- }
- $i++;
- }
- Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
- } else {
- Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
- if ($goods) {
- $string = array();
- foreach ($goods as $k => $v) {
- $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
-
- if ($info['sku_name']) {
- $info['name'] .= '('.$info['sku_name'].')';
- }
- $string[] = $info['name'];
- }
- $string = implode('、', $string);
- Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
- } else {
- Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
- }
- }
- if ($send) {
- foreach ($send as $k => $v) {
- Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
- $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
- Dever::load('cash/lib/order')->up($order_info, 1, 1);
- }
- }
- return 'ok';
- }
- */
- #权益订单导出
- public function out_dhorder_api(){
- $start = Dever::input('search_option_start_cdate');
- $end = Dever::input('search_option_end_cdate');
- if($start){
- $starts=strtotime($start);
- }
- if($end){
- $ends=strtotime($end);
- }
- $header = array('订单编号', '会员姓名', '会员等级', '会员手机号', '收货姓名(或自提人)', '联系电话', '收货地址', '商品名称', '商品规格', '商品数量', '商品原价','订单状态','下单时间', '付款时间','完成时间','卖家订单备注','权益发放时间','代理商终审时间');
- if(isset($starts) && $starts && isset($ends) && $ends){
- $data = Dever::db('agent/dh_order')->getExcelAll(array('start'=>$starts,'end'=>$ends,'state'=>1));
- }else{
- $data = Dever::db('agent/dh_order')->getExcelAll(array('state'=>1));
- }
- $body = array();
- foreach($data as $k => $v){
- $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
- $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
- $address = Dever::db('agent/member_address')->find(array('id'=>$v['address_id']));
- $res=Dever::load('agent/address')->getOne($address['mid'],$address['id']);
- $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $v['id']));
- foreach ($goods as $k1 => $v1) {
- $num = $v1['num'];
- $price = $v1['price'];
- $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
- if (isset($goods_info['sku'])) {
- $sku = $goods_info['sku']['string'];
- } else {
- $sku = '';
- }
- }
- $fdate = '';
- if($v['fdate']){
- $fdate = date('Y-m-d H:i',$v['fdate']);
- }
- $quanyi = '';
- $member_goods = Dever::db('agent/member_goods')->getQone(array('type'=>$v['type'],'type_id'=>$v['type_id']));
- if($member_goods['cdate']){
- $quanyi = date('Y-m-d H:i',$member_goods['cdate']);
- }
-
- $goods_status = Dever::db('agent/dh_order')->config['status'];
- $status = Dever::status($goods_status, $v['status']);
- $d = array
- (
- $v['order_num'],
- $member['name'],
- $role['name'],
- $member['mobile'],
- $address['contact'],
- $address['mobile'],
- $res['address_info'].$address['house_number'],
- $goods_info['name'],
- $sku,
- $num,
- $price,
- $status,
- date('Y-m-d H:i',$v['cdate']),
- date('Y-m-d H:i',$v['cdate']),
- $fdate,
- $v['audit_desc'],
- $quanyi,
- $quanyi,
- );
- $body[] = $d;
- }
- $file = '权益订单';
- Dever::excelExport($body, $header, $file);
- }
- #权益管理导出
- public function out_member_goods_api(){
- $status = Dever::input('search_option_status');
- if( $status){
- $data = Dever::db('agent/member_goods')->getExcelAll(array('status'=>$status,'state'=>1));
- }else{
- $data = Dever::db('agent/member_goods')->getExcelAll(array('state'=>1));
- }
- $header = array('权益名称', '会员等级', '姓名', '手机号', '获取方式', '获取时间', '使用时间', '使用单号');
- $body = array();
- foreach($data as $k => $v){
- $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
- $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
- $dhorder = Dever::db('agent/dh_order')->find(array('mid'=>$v['mid']));
- $d = array
- (
- $v['name'],
- $role['name'],
- $member['name'],
- $member['mobile'],
- '',
- date('Y-m-d H:i',$v['cdate']),
- date('Y-m-d H:i',$dhorder['cdate']),
- $dhorder['order_num'],
- );
- $body[] = $d;
- }
- $file = '权益管理';
- Dever::excelExport($body, $header, $file);
- }
- }
|