yuanchengpasc/application/manage/controller/Examproject.php

<?php

namespace app\manage\controller;

use think\Controller;
use think\Db;
use think\Session;
use think\Config;
use think\Cookie;
use think\Request;
use app\common\library\SysLogs;
use app\common\library\UUIDs;

/**
 * 检查项目
 */
class ExamProject extends Base {

    public function index() {
        return $this->fetch();
    }

    public function datas() {
        
        $request = Request::instance();
        $params = $request->param();

        $wheres = array();
        $insid = isset($params["insid"]) ? $params["insid"] : null;
        if ($insid != null && $insid != "") {
            $wheres["exam_class.institution_id"] = $insid;
        }
        $classid = isset($params["class_id"]) ? $params["class_id"] : null;
        if ($classid != null && $classid != "") {
            $wheres["exam_class.id"] = $classid;
        }
        $name = isset($params["name"]) ? $params["name"] : null;
        if ($name != null && $name != "") {
            $wheres["exam_project.name"] = array("like", "%" . $name . "%");
        }
        
        $page = empty($params["page"]) ? 1 : $params["page"];
        $pagesize = empty($params["rows"]) ? 1 : $params["rows"];
        if (empty($page) || $page < 1) {
            $page = 1;
        }
        if (empty($pagesize) || $pagesize < 1) {
            $pagesize = 30;
        }
        $info = DB::view('exam_project','id, name, exam_class_id, status ')
                ->view("exam_class", "name as claName ", "exam_class.id=exam_project.exam_class_id")
                ->where($wheres)
                ->page($page, $pagesize)->select();
        foreach ($info as $k => $v) {
            $name = DB::table('exam_class')->where('id', $v['exam_class_id'])->field('name')->find();
            $info[$k]['class_name'] = $name['name'];
        }
        $num = DB::view('exam_project','id, name, exam_class_id, status ')
                ->view("exam_class", "name as claName ", "exam_class.id=exam_project.exam_class_id")
                ->where($wheres)
                ->count();
        $data = array();
        $data['total'] = $num;
        $data['rows'] = $info;
        echo json_encode($data);
    }

    /**
     * 编辑窗口
     * @return type
     */
    public function edit() {
        if (isset($_GET["id"])) {
            $id = $_GET["id"];
            if ($id != null) {
                $exam_project = Db::table("exam_project")->where("id", $id)->select();
                if (count($exam_project) > 0) {
                    $this->assign("exam_project", $exam_project[0]);
                }
            }
        }
        $class = DB::view('exam_class', 'id, institution_id, name ')
                ->view("institution", "name as insName", "exam_class.institution_id=institution.id")
                ->order(array("institution.id","1"))
                ->select();
        $this->assign("class", $class);
        return $this->fetch('edit');
    }

    public function save() {
        if (empty($_GET['id'])) {
            unset($_GET['id']);
            $id = UUIDs::uuid16();
            $info = $_GET;
            $info['id'] = $id;
            $a = DB::table('exam_project')->insert($info);
            SysLogs::log("exam_project", "C", json_encode($info));
            return 'insert_ok;' . $id;
        } else {
            $a = DB::table('exam_project')->where('id', $_GET['id'])->update($_GET);
            SysLogs::log("exam_project", "U", "id = " . $_GET['id'] . " --> " . json_encode($_GET));
            return 'update_ok';
        }
    }

    /**
     * 软删除记录
     */
    public function delete() {
        if (isset($_GET["ids"])) {
            $ids = $_GET["ids"];
            if (!empty($ids)) {
                $idArr = explode(",", $ids);
                if (count($idArr) > 0) {
                    Db::table("exam_project")->where("id", "in", $idArr)->delete();
                }
                echo "delete_ok";
                SysLogs::log("exam_project", "D", $ids);
                return;
            }
        }
        echo "fail";
    }

}