technician/app/back/controller/JsCourseOrderController.php

<?php
    /**
     * Created by PhpStorm.
     * User: Administrator
     * Date: 2020-09-24
     * Time: 17:13
     */
    
    namespace app\back\controller;
    
    
    
    use app\back\model\JsCourseOrderModel;
    use cmf\controller\AdminBaseController;
    use app\back\model\JsProjectModel;
    use app\back\model\UserModel;
    class JsCourseOrderController extends AdminBaseController
    {
        public function index()
        {
            $JsCourseOrderModel = new JsCourseOrderModel();
            $where = [];
            $pw = [];
            $page = $this->request->param('page',1);
            $project_id = $this->request->param('project_id');
            $keyword = $this->request->param('keyword');
            if($keyword){
                $user_ids = UserModel::where('user_nickname|mobile','like','%'.$keyword.'%')->field('id')->select();
                $user_new_ids = [];
                foreach ($user_ids as $vo){
                    $user_new_ids[] = $vo['id'];
                }
                $where['user_id'] = $user_new_ids;
                $this->assign('keyword',$keyword);
            }
            if($project_id){
                $where['project_id'] = $project_id;
                $pw['project_id'] = $project_id;
                $this->assign('project_id',$project_id);
            }
            $order_sn = $this->request->param('order_sn');
            if($order_sn){
                $this->assign('order_sn',$order_sn);
                $pw['order_sn'] = $order_sn;
            }
            $list = $JsCourseOrderModel->getList($where,$pw,$page,$order_sn);
            $this->assign('list',$list);
            $this->assign('page',$list->render());
            $JsProjectModel = new JsProjectModel();
            $js_project_list = $JsProjectModel::field('id,name')->select();
            $this->assign('js_project_list',$js_project_list);
            return $this->fetch();
        }
        
        public function delete()
        {
            $id = $this->request->param('id');
            JsCourseOrderModel::destroy($id);
            $this->success('删除成功!');
        }
    }