PHP Lesson::find方法代码示例

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show($id)
 {
     $lesson = Lesson::find($id);
     if (!$lesson) {
         return $this->respondNotFound('Lesson does not exist.');
     }
     return $this->respond(['data' => $this->lessonTransformer->transform($lesson)]);
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show($id)
 {
     $lesson = Lesson::find($id);
     if (!$lesson) {
         return $this->respondNotFound('Lesson Not Exist');
         /*return Response::json([
         			'error' => [
         				'message' => 'Lesson not found'
         			]
         		],404);*/
     }
     return $this->respond(['data' => $this->lessonTransformer->transform($lesson)]);
 }

 /**
  * 查询用户详细信息
  * @method userDetailInfo
  * @param  number           $id 用户ID
  * @return Json             包含用户详情, 订单信息, 登录信息
  */
 public function show($id)
 {
     //通过用户ID查询详细信息, 且包含订单信息(usertype=1的为学生)
     $teacherInfo = StudentUser::where('uid', $id)->with('orders')->first();
     /**
      * 对查出来的结果添加 teacher_uid 和 teacher_nickname 两个字段
      * 以便在表格显示时, 显示出课程中教师相关的信息
      */
     foreach ($teacherInfo['orders'] as $order) {
         /**
          * 通过课程lid查询用户信息
          */
         $user = Lesson::find($order->lid)->user()->select('uid as teacher_uid', 'nickname as teacher_nickname')->first();
         /**
          * 给 $teacherInfo 数组添加教师信息
          */
         $order->teacher_uid = $user->teacher_uid;
         $order->teacher_nickname = $user->teacher_nickname;
     }
     /**
      * 用户登录信息
      * 因表结构中只有用户最后一次登录的数据, 只能提供这个
      * @var string
      */
     $loginInfo = $teacherInfo->lastlogin;
     /**
      * 用户投诉历史
      * 因没有相关数据表结构, 暂时无法提供这个数据.
      */
     /**
      * 将用户详情, 订单信息, 登录信息组合为同一个数组
      */
     $data['teacherInfo'] = $teacherInfo;
     $data['loginInfo'] = $loginInfo;
     //以Json形式返回
     return view('teacherdetail')->with('data', $data);
 }

 function testFind()
 {
     $name = "John Doe";
     $password = "password";
     $email = "johndoe@osa.biz";
     $signed_in = 0;
     $test_user = new User($name, $password, $email, $signed_in);
     $test_user->save();
     $course_title = "Literature";
     $subject = "English";
     $course_description = "Deconstructing English literature.";
     $user_id = $test_user->getId();
     $test_course = new Course($course_title, $subject, $course_description, $user_id);
     $test_course->save();
     $unit_title = "Into the Wild";
     $unit_description = "The life and death of Chris McCandless.";
     $course_id = $test_course->getId();
     $test_unit = new Unit($unit_title, $unit_description, $course_id);
     $test_unit->save();
     $lesson_title = "Into the Wild: Chapter 1";
     $objective = "Students will read and discuss Chapter 1";
     $materials = "Books, discussion packets, pencils";
     $body = "Lorem ipsum etc etc blah blah blah blah...";
     $unit_id = $test_unit->getId();
     $test_lesson = new Lesson($lesson_title, $objective, $materials, $body, $unit_id);
     $test_lesson->save();
     $lesson_title2 = "The Catcher in the Rye: Chapter 3";
     $objective2 = "Students will read and discuss Chapter 3";
     $materials2 = "Books, essay prompts, pens";
     $body2 = "Blah blah blah etc etc lorem ipsum...";
     $test_lesson2 = new Lesson($lesson_title2, $objective2, $materials2, $body, $unit_id);
     $test_lesson2->save();
     $result = Lesson::find($test_lesson->getId());
     $this->assertEquals($test_lesson, $result);
 }

    $course_id = $unit->getCourseId();
    $course = Course::find($course_id);
    $user_id = $course->getUserId();
    return $app['twig']->render("edit_lesson.html.twig", array('lesson' => $lesson, 'unit' => $unit, 'course' => $course, 'user' => User::find($user_id)));
});
$app->patch("/show_lesson_edit/edit_lesson/{id}", function ($id) use($app) {
    $lesson = Lesson::find($id);
    $new_title = $_POST['new_title'];
    $new_objective = $_POST['new_objective'];
    $new_materials = $_POST['new_materials'];
    $new_body = $_POST['new_body'];
    $lesson->updateLesson($new_title, $new_objective, $new_materials, $new_body);
    $unit_id = $lesson->getUnitId();
    $unit = Unit::find($unit_id);
    $course_id = $unit->getCourseId();
    $course = Course::find($course_id);
    $user_id = $course->getUserId();
    return $app['twig']->render("lesson.html.twig", array('lesson' => $lesson, 'unit' => $unit, 'course' => $course, 'user' => User::find($user_id)));
});
//Delete a lesson
$app->get("/delete_lesson/{unit_id}/{lesson_id}", function ($unit_id, $lesson_id) use($app) {
    $lesson = Lesson::find($lesson_id);
    $unit_id = $lesson->getUnitId();
    $unit = Unit::find($unit_id);
    $course_id = $unit->getCourseId();
    $course = Course::find($course_id);
    $user_id = $course->getUserId();
    $lesson->delete();
    return $app['twig']->render("unit.html.twig", array('lesson' => $lesson, 'unit' => $unit, 'lessons' => $unit->getLessons(), 'course' => $course, 'user' => User::find($user_id)));
});
return $app;

 function getLessons()
 {
     $returned_lessons = $GLOBALS['DB']->query("SELECT * FROM lessons WHERE unit_id = {$this->getId()};");
     $unit_lessons = array();
     foreach ($returned_lessons as $lesson) {
         $lesson_id = $lesson['id'];
         $found_lesson = Lesson::find($lesson_id);
         array_push($unit_lessons, $found_lesson);
     }
     return $unit_lessons;
 }