getSetData(); $this->assign('set', $setData['setList']); $this->assignconfig('set',$setData['setList']); $this->assign('nowmenu', $setData['nowmenu']); $this->model = new \app\admin\model\kuerp\UserOrder; $this->view->assign("StatusList", $this->model->getStatusList()); $this->view->assign("payStatusList", $this->model->getPayStatusList()); $pay_status = Db::name('kuerp_user_config')->where(['name'=>'pay_status'])->value('value'); $driver = Db::name('kuerp_driver')->where(['status'=>'1'])->field('name,id')->select(); $del = (new Auth())->check($setData['nowmenu'].'/del'); $this->assignconfig('del_status',$del); $this->assignconfig('pay_status',$pay_status); $this->assignconfig('driver_list',$driver); } public function index() { //当前是否为关联查询 $this->relationSearch = true; //设置过滤方法 $this->request->filter(['strip_tags', 'trim']); if ($this->request->isAjax()) { //如果发送的来源是Selectpage,则转发到Selectpage if ($this->request->request('keyField')) { return $this->selectpage(); } list($where, $sort, $order, $offset, $limit) = $this->buildparams(); $list = $this->model ->where($where) ->order($sort, $order) ->paginate($limit); $lists = []; foreach ($list as $list_k=>$list_v){ $sales_id = Db::name('kuerp_user_ordersale')->where(['order_id'=>$list_v['id']])->value('sales_id'); if($list_v['diver_type']==2 && !empty($list_v['store_id'])){ $address = Db::name('kuerp_address')->where(['id'=>$list_v['store_id']])->value('detail_address'); $list_v['address'] = $address.'(自提)'; } $list_v['diver_name'] = Db::name('kuerp_driver')->where(['id'=>$list_v['diver_id']])->value('name'); $goods_list = Db::name('kuerp_user_orderinfo')->where(['order_id'=>$list_v['id']]) ->select(); foreach ($goods_list as $goods_list_k=>$goods_list_v){ $goods_code = Db::name('kuerp_goods')->where(['id'=>$goods_list_v['goods_id']])->value('goods_code'); $lists[] = [ 'id' => $list_v['id'], 'sales_id' => $sales_id, 'name' => $list_v['name'], 'phone' => $list_v['phone'], 'address' => $list_v['address'], 'order_num' => $list_v['order_num'], 'order_price' => $list_v['order_price'], 'status' => $list_v['status'], 'createtime' => $list_v['createtime'], 'goods_code' => $goods_code, 'goods_name' => $goods_list_v['goods_name'], 'goods_image' => $goods_list_v['goods_image'], 'unit_name' => $goods_list_v['unit_name'], 'attr_name' => $goods_list_v['attr_name'], 'number' => $goods_list_v['number'], 'price' => $goods_list_v['price'], 'money' => $goods_list_v['money'], 'pay_status' => $list_v['pay_status'], 'diver_type' => $list_v['diver_type'], 'diver_id' => $list_v['diver_id'], 'diver_name' => $list_v['diver_name'], ]; } } $result = array("total" => $list->total(), "rows" => $lists); return json($result); } return $this->view->fetch(); } /** * 审核 */ public function examine($ids = null){ if (!$this->request->isPost()) { $this->error(__("Invalid parameters")); } $ids = $ids ? $ids : $this->request->post("ids"); if ($ids) { $pk = $this->model->getPk(); $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { $this->model->where($this->dataLimitField, 'in', $adminIds); } $list = $this->model->where($pk, 'in', $ids)->select(); $count = 0; Db::startTrans(); try { foreach ($list as $k => $v) { (new Index())->Message('sh',$v['order_num']); $count += $this->model->where(['id'=>$v['id']])->update(['status'=>'2','updatetime'=>time()]); } Db::commit(); }catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($count) { $this->success(); } else { $this->error(__('审核失败')); } } $this->error(__('请选择要审核的数据', 'ids')); } /** * 发货 */ public function deliver($ids = null){ if (!$this->request->isPost()) { $this->error(__("Invalid parameters")); } $ids = $ids ? $ids : $this->request->post("ids"); if ($ids) { $pk = $this->model->getPk(); $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { $this->model->where($this->dataLimitField, 'in', $adminIds); } $diver_id = input("diver_id"); $list = $this->model->where($pk, 'in', $ids)->select(); foreach ($list as $k => $v) { switch ($v['status']){ case 0: $this->error($v['order_num'].'未审核,不可发货'); break; case 2: $sales_id = Db::name('kuerp_user_ordersale')->where(['order_id'=>$v['id']])->value('sales_id'); if(empty($sales_id)){ $this->error($v['order_num'].'未生成销货单,不可发货'); } $pay_status = Db::name('kuerp_user_config')->where(['name'=>'pay_status'])->value('value'); if($pay_status==1 && $v['pay_status']!=1){ $this->error($v['order_num'].'未支付,不可发货'); } break; case 3: $this->error($v['order_num'].'已发货,不可重复发货'); break; case 4: $this->error($v['order_num'].'已收货,不可重复发货'); break; default: $this->error($v['order_num'].'状态异常,不可发货'); break; } } $count = 0; Db::startTrans(); try { foreach ($list as $k => $v) { (new Index())->Message('fh',$v['order_num']); $data = []; $data['status'] = '3'; if($v['diver_type']==1){ $data['diver_id'] = (int)$diver_id; } $count += $this->model->where(['id'=>$v['id']])->update($data); } Db::commit(); }catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($count) { $this->success(); } else { $this->error(__('审核失败')); } } $this->error(__('请选择要审核的数据', 'ids')); } /** * 删除 */ public function del($ids = "") { if (!$this->request->isPost()) { $this->error(__("Invalid parameters")); } $ids = $ids ? $ids : $this->request->post("ids"); if ($ids) { $pk = $this->model->getPk(); $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { $this->model->where($this->dataLimitField, 'in', $adminIds); } $list = $this->model->where($pk, 'in', $ids)->select(); $count = 0; Db::startTrans(); try { foreach ($list as $k => $v) { $count += $v->delete(); } Db::commit(); }catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($count) { $this->success(); } else { $this->error(__('删除失败')); } } $this->error(__('请选择要删除的数据', 'ids')); } }