alias('us') ->field('us.*,school.schoolname,grade.gradename,classes.classname') ->join('school','us.school_id = school.id','LEFT') ->join('grade','us.grade_id = grade.id','LEFT') ->join('classes','us.classes_id = classes.id','LEFT') ->where('us.user_id',$this->auth->id)->order('is_default desc')->autopage()->select(); $this->success(1,$list); } public function add() { $realname = input('realname',''); $gender = input('gender',1); $age = input('age',1); $school_id = input('school_id',0); $grade_id = input('grade_id',0); $classes_id = input('classes_id',0); $idcard = input('idcard', ''); $stu_mobile = input('stu_mobile', ''); $is_default = input('is_default', 0); $remark = input('remark', ''); if($is_default == 1){ Db::name('user_student')->where('user_id',$this->auth->id)->update(['is_default'=>0]); } //添加 $data = [ 'user_id' => $this->auth->id, 'realname' => $realname, 'gender' => $gender, 'age' => $age, 'school_id' => $school_id, 'grade_id' => $grade_id, 'classes_id' => $classes_id, 'idcard' => $idcard, 'stu_mobile' => $stu_mobile, 'is_default' => $is_default, 'remark' => $remark, ]; $rs = Db::name('user_student')->insertGetId($data); if (!$rs) { $this->error('添加失败'); } $this->success('添加成功',$rs); } public function edit(){ $id = input('id', 0, 'intval'); $realname = input('realname',''); $gender = input('gender',1); $age = input('age',1); $school_id = input('school_id',0); $grade_id = input('grade_id',0); $classes_id = input('classes_id',0); $idcard = input('idcard', ''); $stu_mobile = input('stu_mobile', ''); $is_default = input('is_default', 0); $remark = input('remark', ''); $info = Db::name('user_student')->where(['id' => $id, 'user_id' => $this->auth->id])->find(); if (!$info) { $this->error('该学生不存在'); } if($is_default == 1){ Db::name('user_student')->where('user_id',$this->auth->id)->update(['is_default'=>0]); } //添加 $data = [ 'realname' => $realname, 'gender' => $gender, 'age' => $age, 'school_id' => $school_id, 'grade_id' => $grade_id, 'classes_id' => $classes_id, 'idcard' => $idcard, 'stu_mobile' => $stu_mobile, 'is_default' => $is_default, 'remark' => $remark, ]; $rs = Db::name('user_student')->where(['id' => $id])->update($data); if ($rs === false) { $this->error('修改失败'); } $this->success('修改成功',$id); } public function info() { $id = input('id', 0, 'intval'); $info = Db::name('user_student')->alias('us') ->field('us.*,school.schoolname,grade.gradename,classes.classname') ->join('school','us.school_id = school.id','LEFT') ->join('grade','us.grade_id = grade.id','LEFT') ->join('classes','us.classes_id = classes.id','LEFT') ->where(['us.id' => $id, 'us.user_id' => $this->auth->id])->find(); if (!$info) { $info = (object)[]; } $this->success(1, $info); } public function delete(){ $id = input('id', 0, 'intval'); Db::name('user_student')->where('id',$id)->delete(); $this->success('删除成功'); } }