太阳成游戏网站

琉惗

类型：太阳成游戏网站CMS 更新时间：2020-05-27 07:30:48

        这段话的意思是把数据填入表格具体看layui手册
    

js部分

//这段js是用来显示表格中的按钮，也可以自己定义，我这里是用的layui组件

    {{#  if(d.reserve == '{$member.name}'){ }}
    回复
    {{#  } }}
    {{#  if(d.reservepeo == '{$member.name}'){ }}
    取消
    {{#  } }}

php部分，这部分代码只是作为参考，具体方法，还是要看你应用场景去做，只能告诉你怎么去做，不要用代码，自己写接口跟方法去应用

public function memberlist() {
        \Phpcmf\Service::V()->display('module_member.html');
    }

    public function memberinfo () {
        $id = $this->request->getGet('id');
        $page = $this->request->getGet('page');
        $size = $this->request->getGet('limit');
        $up = ($page-1)*$size;
        if (!empty($id)) {
            $total = count(\Phpcmf\Service::M()->db->query('SELECT id,email,phone,"name" FROM dr_member WHERE id IN (SELECT DISTINCT uid FROM dr_admin_role_index WHERE roleid IN (SELECT roleid FROM dr_admin_role_index WHERE uid = '.$id.'))')->getResultArray());
            $info = \Phpcmf\Service::M()->db->query('SELECT id,email,phone,`name` FROM dr_member WHERE id IN (SELECT DISTINCT uid FROM dr_admin_role_index WHERE roleid IN (SELECT roleid FROM dr_admin_role_index WHERE uid = '.$id.')) LIMIT '.$up.','.$size.'')->getResultArray();

            return json_encode([
                'code' => 0,
                'msg' => '',
                'count' => $total,
                'data' => $info
            ]);
        }else{
            return json_encode([
                'code' => 0,
                'msg' => '',
                'count' => 0,
                'data' => ''
            ]);
        }
    }

    public function yuyue() {
        $uid = $this->request->getPost('uid');
        $id = $this->request->getPost('id');
        $author = $this->request->getPost('author');
        $sumbitInfo = $this->request->getPost('sumbitInfo');

        $info = \Phpcmf\Service::M()->db->query("SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA. TABLES WHERE TABLE_NAME = 'dr_".SITE_ID."_reserve'");
        foreach ($info->getResultArray() as $da){}
        $lastid = $da['AUTO_INCREMENT'];

        foreach ($sumbitInfo as $sumbit){
            if ($sumbit['name'] == 'time'){
                $data[$sumbit['name']] = strtotime($sumbit['value']);
            }else{
                $data[$sumbit['name']] = $sumbit['value'];
            }
        }
        $data['uid'] = $uid;
        $data['catid'] = 1;
        $data['status'] = 9;
        $data['author'] = $author;
        $data['url'] = '/index.php?c=show&id='.$lastid;
        $data['inputip'] = \Phpcmf\Service::L('input')->ip_address();
        $data['inputtime'] = SYS_TIME;
        $data['updatetime'] = SYS_TIME;
        $data['reserve'] = $id;
        $data['reservepeo'] = $uid;
        $data['state'] = 1;

        $fdata['uid'] = $uid;
        $fdata['catid'] = 1;
        $fdata['id'] = $lastid;
        $fdata['content'] = '';


        $add = \Phpcmf\Service::M()->db->table(SITE_ID.'_reserve')->insert($data);
        \Phpcmf\Service::M()->db->table(SITE_ID.'_reserve_data_0')->insert($fdata);
        if ($add){
            return json_encode(['code' => 1]);
        }else{
            return json_encode(['code' => 0]);
        }
    }

    public function content () {
        $id = $this->request->getGet('id');
        $page = $this->request->getGet('page');
        $size = $this->request->getGet('limit');
        $day = dr_field_options(9);
        $state = dr_field_options(15);
        $up = ($page-1)*$size;
        if (!empty($id)) {
            $total = count(\Phpcmf\Service::M()->db->query('SELECT id,url,`day`,time,remark,reserve,reservepeo,remark1,state FROM dr_1_reserve WHERE uid = '.$id.' OR reserve = '.$id.'')->getResultArray());
            $info = \Phpcmf\Service::M()->db->query('SELECT id,url,`day`,time,remark,reserve,reservepeo,remark1,state FROM dr_1_reserve WHERE uid = '.$id.' OR reserve = '.$id.'')->getResultArray();
            foreach ($info as $key=>$in) {
                $info[$key]['day'] = $day[$in['day']];
                $info[$key]['state'] = $state[$in['state']];
                $info[$key]['time'] = date('Y-m-d H:i:s',$in['time']);
                if (!empty($in['reserve'])){
                    $reserve = dr_member_info($in['reserve']);
                    $info[$key]['reserve'] = $reserve['name'];
                }
                if (!empty($in['reservepeo'])){
                    $reserve = dr_member_info($in['reservepeo']);
                    $info[$key]['reservepeo'] = $reserve['name'];
                }
            }
            return json_encode([
                'code' => 0,
                'msg' => '',
                'count' => $total,
                'data' => $info
            ]);
        }else{
            return json_encode([
                'code' => 0,
                'msg' => '',
                'count' => 0,
                'data' => ''
            ]);
        }
    }

    public function huifu() {
        $id = $this->request->getPost('id');
        $sumbitInfo = $this->request->getPost('sumbitInfo');

        foreach ($sumbitInfo as $sumbit){
            $data[$sumbit['name']] = $sumbit['value'];
        }

        $update = \Phpcmf\Service::M()->db->table(SITE_ID.'_reserve')->where('id',$id)->update($data);
        if ($update){
            return json_encode(['code' => 1]);
        }else{
            return json_encode(['code' => 0]);
        }
    }

    public function quxiao() {
        $id = $this->request->getPost('id');

        $update = \Phpcmf\Service::M()->db->table(SITE_ID.'_reserve')->where('id',$id)->update(['state'=> 3]);
        if ($update){
            return json_encode(['code' => 1]);
        }else{
            return json_encode(['code' => 0]);
        }
    }