column('name,value'); $csr_config = Db::name('kefu_csr_config') ->alias('c') ->field('c.id,c.admin_id,c.ceiling,a.username') ->join('admin a', 'c.admin_id=a.id') ->select(); $this->view->assign('config_list', $config); $this->view->assign('csr_config', $csr_config); return $this->view->fetch(); } /* * 保存修改 */ public function update() { if ($this->request->isPost()) { $config = Db::name('kefu_config')->column('name,value'); $csr_config = Db::name('kefu_csr_config') ->alias('c') ->field('c.id,c.admin_id,c.ceiling,a.username') ->join('admin a', 'c.admin_id=a.id') ->select(); $csr_config_admin_ids = array_column($csr_config, 'admin_id'); $params = $this->request->post("row/a"); if ($params) { // 配置更新-只更新有修改的 foreach ($params as $key => $value) { if ($params[$key] != $config[$key]) { Db::name('kefu_config')->where('name', $key)->update(['value' => $value]); } } $this->success(); } $this->error(); } return; } }