model = model('ShortDomain'); $this->view->assign("statusList", $this->model->getStatusList()); } /** * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个方法 * 因此在当前控制器中可不用编写增删改查的代码,如果需要自己控制这部分逻辑 * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改 */ /** * 添加/支持批量 * * @author liues@dianzhong.com * @date 2018-08-17 18:43:13 * @return html|json */ public function add() { if ($this->request->isPost()) { $hosts = trim($this->request->post("row.host")); $status = $this->request->post("row.status") ?? '1'; if($hosts) { $params = array(); $hosts = explode("\r\n", $hosts); $hosts = array_unique(array_filter($hosts)); if(count($hosts) > 50){ $this->error('单次批量添加上限50条'); } foreach($hosts as $key => $host) { if(!empty($host)) { if(mb_strlen($host) > 150) { $this->error("每条域名长度不能超过150字符\r\n".$host); } $exists = model('ShortDomain')->getByHost($host); if(empty($exists)) { $params[] = array('host' => $host, 'status' => $status); } } } try { //是否采用模型验证 if ($this->modelValidate) { $name = basename(str_replace('\\', '/', get_class($this->model))); $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.add' : true) : $this->modelValidate; $this->model->validate($validate); } $result = $this->model->allowField(true)->saveAll($params); if ($result !== false) { $this->success(); } else { $this->error($this->model->getError()); } } catch (\think\exception\PDOException $e) { $this->error($e->getMessage()); } $this->error(__('Parameter %s can not be empty', '')); } } return $this->view->fetch(); } /** * 编辑 */ public function edit($ids = NULL) { $row = $this->model->get($ids); if (!$row) $this->error(__('No Results were found')); $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { if (!in_array($row[$this->dataLimitField], $adminIds)) { $this->error(__('You have no permission')); } } if ($this->request->isPost()) { $params = $this->request->post("row/a"); if ($params) { /* * 已经弃用,如果为了兼容老版可取消注释 foreach ($params as $k => &$v) { $v = is_array($v) ? implode(',', $v) : $v; } */ try { //是否采用模型验证 if ($this->modelValidate) { $name = basename(str_replace('\\', '/', get_class($this->model))); $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.edit' : true) : $this->modelValidate; $row->validate($validate); } if(!$params['status']){ $this->close($row['id']); } $whereMap['host'] = $params['host']; $whereMap['id'] = ['neq',$row['id']]; $params['updatetime'] = time(); if($this->model->where($whereMap)->find()){ $this->error('域名已存在,请保持域名唯一性'); } $result = $row->allowField(true)->save($params); if ($result !== false) { $this->success(); } else { $this->error($row->getError()); } } catch (\think\exception\PDOException $e) { $this->error($e->getMessage()); } } $this->error(__('Parameter %s can not be empty', '')); } $this->view->assign("row", $row); return $this->view->fetch(); } /** * 删除 * * @author liues@dianzhong.com * @date 2018-08-18 10:16:29 * @param string $ids * @return json */ public function del($ids = "") { //严禁删除 $this->error(__('No rows were deleted')); } /** * 启用 * * @author liues@dianzhong.com * @date 2018-08-17 18:44:02 * @param null $ids * @return html|json */ public function open($ids = NULL){ if ($ids) { $pk = $this->model->getPk(); $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { $count = $this->model->where($this->dataLimitField, 'in', $adminIds); } $list = $this->model->where($pk, 'in', $ids)->select(); $count = 0; foreach ($list as $k => $v) { $count += $v->where($pk, $v->id)->update(['status'=>'1','updatetime'=>time()]); } if ($count) { $this->success(); } else { $this->error(__('No rows were updated')); } } $this->error(__('Parameter %s can not be empty', 'ids')); } /** * 关闭 * * @author liues@dianzhong.com * @date 2018-08-17 18:44:02 * @param null $ids * @return html|json */ public function close($ids = NULL){ if ($ids) { $pk = $this->model->getPk(); $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { $count = $this->model->where($this->dataLimitField, 'in', $adminIds); } $list = $this->model->where($pk, 'in', $ids)->select(); $count = 0; foreach ($list as $k => $v) { try{ $count += $v->where($pk, $v->id)->update(['status'=>'0','updatetime'=>time()]); $relations = model('ShortRelation')->where('domain_id',$v->id)->column('admin_id'); //查询当前所有关联 if(!empty($relations)){ foreach ($relations as $val){ if(!model('ShortRelation')->where(['admin_id'=>$val])->where('domain_id','<>',$v['id'])->find()){ //除此短链外,没有任何其他短链了 model('AdminConfig')->where(['admin_id'=>$val])->update(['guide_domain'=>'0']); model('AdminConfig')->delAdminInfoAllCache($val); } } } model('ShortRelation')->where('domain_id',$v['id'])->delete(); //禁用后解除绑定关系 }catch (Exception $e){ } } if ($count) { $this->success(); } else { $this->error(__('No rows were updated')); } } $this->error(__('Parameter %s can not be empty', 'ids')); } }