model = new \app\admin\model\live\Courseware; } /** * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法 * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑 * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改 */ /** * 查看 */ public function index() { //当前是否为关联查询 $this->relationSearch = true; //设置过滤方法 $this->request->filter(['strip_tags', 'trim']); //如果发送的来源是Selectpage,则转发到Selectpage if ($this->request->request('keyField')) { return $this->selectpage(); } list($where, $sort, $order, $offset, $limit) = $this->buildparams(); $list = $this->model ->with(['course']) ->where($where) ->order($sort, $order) ->paginate($limit); $ids = $this->model->with(['course'])->where($where)->field('file_id')->column('file_id'); $result = array("total" => $list->total(), "rows" => $list->items(),"ids"=>$ids); return $this->success("获取成功",$result); } /** * 添加 * @return string * @throws \think\Exception */ public function add() { if (false === $this->request->isPost()) { return $this->view->fetch(); } $rows = $this->request->post('row/a'); $courseId = $this->request->post('course_id'); if (empty($rows) || !$courseId) { $this->error(__('Parameter %s can not be empty', '')); } $data = []; foreach ($rows as $item){ $item['uniacid'] = UNIACID; $item['createtime'] = time(); $item['course_id'] = $courseId; $data[] = $item; } $result = false; Db::startTrans(); try { $result = $this->model->allowField(true)->saveAll($data); Db::commit(); } catch (ValidateException|PDOException|Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($result === false) { $this->error(__('No rows were inserted')); } $this->success("提交成功"); } }