123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124 |
- <?php
- namespace app\api\controller;
- use app\common\controller\Api;
- use think\Db;
- /**
- * 用户学生
- */
- class Student extends Api
- {
- protected $noNeedLogin = [];
- protected $noNeedRight = '*';
- public function lists(){
- $list = 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.user_id',$this->auth->id)->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);
- 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,
- ];
- $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);
- $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,
- ];
- $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);
- }
- }
|