tuku/application/api/controller/Student.php

<?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);
    }


}