idsci/application/admin/controller/kefu/Config.php

<?php

namespace app\admin\controller\kefu;

use app\common\controller\Backend;
use think\Db;

/*
 * KeFu配置
 */

class Config extends Backend
{

    public function _initialize()
    {
        parent::_initialize();
    }

    /*
     * 查看
     */
    public function index()
    {
        $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();

        $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;
    }
}