getSetData(); $this->assign('set', $setData['setList']); $this->assignconfig('set',$setData['setList']); $this->assign('nowmenu', $setData['nowmenu']); $this->model = new \app\admin\model\kuerp\KuerpUser; $this->view->assign("StatusList", $this->model->getStatusList()); $this->view->assign("payStatusList", $this->model->getPayStatusList()); } 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(); $where = []; $searchdata = json_decode(input('filter'),true); if($searchdata){ foreach ($searchdata as $k => &$v) { if(!empty($v)){ if($k=='keyword'){ $where['username|mobile'] = ["LIKE", "%{$v}%"]; } } } } $list = $this->model ->where($where) ->order($sort, $order) ->paginate($limit); $lists = []; foreach ($list as $list_k=>$list_v){ $list_v['customers'] = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_id']])->find(); $lists[] = $list_v; } $result = array("total" => $list->total(), "rows" => $lists); return json($result); } return $this->view->fetch(); } /** * 删除 */ 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(); foreach ($list as $list_k=>$list_v){ $order = Db::name('kuerp_user_order')->where(['user_id'=>$list_v['id']])->find(); if($order){ $this->error('此用户有关联订单,不可删除'); } } $count = 0; Db::startTrans(); try { foreach ($list as $k => $v) { $count += $v->delete(); $where = []; $where['user_id'] = $v['id']; Db::name('kuerp_user_address')->where($where)->delete(); Db::name('kuerp_user_cart')->where($where)->delete(); Db::name('kuerp_user_history')->where($where)->delete(); } Db::commit(); }catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($count) { $this->success(); } else { $this->error(__('No rows were deleted')); } } $this->error(__('Parameter %s can not be empty', 'ids')); } }