Student.php 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. /**
  6. * 用户学生
  7. */
  8. class Student extends Api
  9. {
  10. protected $noNeedLogin = [];
  11. protected $noNeedRight = '*';
  12. public function lists(){
  13. $list = Db::name('user_student')->alias('us')
  14. ->field('us.*,school.schoolname,grade.gradename,classes.classname')
  15. ->join('school','us.school_id = school.id','LEFT')
  16. ->join('grade','us.grade_id = grade.id','LEFT')
  17. ->join('classes','us.classes_id = classes.id','LEFT')
  18. ->where('us.user_id',$this->auth->id)->autopage()->select();
  19. $this->success(1,$list);
  20. }
  21. public function add() {
  22. $realname = input('realname','');
  23. $gender = input('gender',1);
  24. $age = input('age',1);
  25. $school_id = input('school_id',0);
  26. $grade_id = input('grade_id',0);
  27. $classes_id = input('classes_id',0);
  28. $idcard = input('idcard', '');
  29. $stu_mobile = input('stu_mobile', '');
  30. $is_default = input('is_default', 0);
  31. if($is_default == 1){
  32. Db::name('user_student')->where('user_id',$this->auth->id)->update(['is_default'=>0]);
  33. }
  34. //添加
  35. $data = [
  36. 'user_id' => $this->auth->id,
  37. 'realname' => $realname,
  38. 'gender' => $gender,
  39. 'age' => $age,
  40. 'school_id' => $school_id,
  41. 'grade_id' => $grade_id,
  42. 'classes_id' => $classes_id,
  43. 'idcard' => $idcard,
  44. 'stu_mobile' => $stu_mobile,
  45. 'is_default' => $is_default,
  46. ];
  47. $rs = Db::name('user_student')->insertGetId($data);
  48. if (!$rs) {
  49. $this->error('添加失败');
  50. }
  51. $this->success('添加成功',$rs);
  52. }
  53. public function edit(){
  54. $id = input('id', 0, 'intval');
  55. $realname = input('realname','');
  56. $gender = input('gender',1);
  57. $age = input('age',1);
  58. $school_id = input('school_id',0);
  59. $grade_id = input('grade_id',0);
  60. $classes_id = input('classes_id',0);
  61. $idcard = input('idcard', '');
  62. $stu_mobile = input('stu_mobile', '');
  63. $is_default = input('is_default', 0);
  64. $info = Db::name('user_student')->where(['id' => $id, 'user_id' => $this->auth->id])->find();
  65. if (!$info) {
  66. $this->error('该学生不存在');
  67. }
  68. if($is_default == 1){
  69. Db::name('user_student')->where('user_id',$this->auth->id)->update(['is_default'=>0]);
  70. }
  71. //添加
  72. $data = [
  73. 'realname' => $realname,
  74. 'gender' => $gender,
  75. 'age' => $age,
  76. 'school_id' => $school_id,
  77. 'grade_id' => $grade_id,
  78. 'classes_id' => $classes_id,
  79. 'idcard' => $idcard,
  80. 'stu_mobile' => $stu_mobile,
  81. 'is_default' => $is_default,
  82. ];
  83. $rs = Db::name('user_student')->where(['id' => $id])->update($data);
  84. if ($rs === false) {
  85. $this->error('修改失败');
  86. }
  87. $this->success('修改成功',$id);
  88. }
  89. public function info() {
  90. $id = input('id', 0, 'intval');
  91. $info = Db::name('user_student')->alias('us')
  92. ->field('us.*,school.schoolname,grade.gradename,classes.classname')
  93. ->join('school','us.school_id = school.id','LEFT')
  94. ->join('grade','us.grade_id = grade.id','LEFT')
  95. ->join('classes','us.classes_id = classes.id','LEFT')
  96. ->where(['us.id' => $id, 'us.user_id' => $this->auth->id])->find();
  97. if (!$info) {
  98. $info = (object)[];
  99. }
  100. $this->success(1, $info);
  101. }
  102. }