/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$student = Student::find($id);
if ($student == NULL) {
throw new Exception('Invalid Student ID');
}
$student->year = (int) substr($student->year, 2, 4);
$student_category = StudentCategories::find($student->category);
$student->category = $student_category->category;
$student_branch = Branch::find($student->branch);
$student->branch = $student_branch->branch;
if ($student->rejected == 1) {
unset($student->approved);
unset($student->books_issued);
$student->rejected = (bool) $student->rejected;
return $student;
}
if ($student->approved == 0) {
unset($student->rejected);
unset($student->books_issued);
$student->approved = (bool) $student->approved;
return $student;
}
unset($student->rejected);
unset($student->approved);
$student_issued_books = Logs::select('book_issue_id', 'issued_at')->where('student_id', '=', $id)->orderBy('time_stamp', 'desc')->take($student->books_issued)->get();
foreach ($student_issued_books as $issued_book) {
$issue = Issue::find($issued_book->book_issue_id);
$book = Books::find($issue->book_id);
$issued_book->name = $book->title;
$issued_book->issued_at = date('d-M', $issued_book->issued_at);
}
$student->issued_books = $student_issued_books;
return $student;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$issue = Issue::find($id);
if ($issue == NULL) {
throw new Exception('Invalid Book ID');
}
$issue->added_at_timestamp = date('d-M-y h:i A', strtotime($issue->added_at_timestamp));
$book = Books::find($issue->book_id);
$issue->book_name = $book->title;
$issue->author = $book->author;
$issue->category = Categories::find($book->category_id)->category;
$issue->available_status = (bool) $issue->available_status;
if ($issue->available_status == 1) {
return $issue;
}
$conditions = array('return_time' => 0, 'book_issue_id' => $id);
$book_issue_log = Logs::where($conditions)->take(1)->get();
foreach ($book_issue_log as $log) {
$student_id = $log->student_id;
}
$student_data = Student::find($student_id);
unset($student_data->email_id);
unset($student_data->books_issued);
unset($student_data->approved);
unset($student_data->rejected);
$student_branch = Branch::find($student_data->branch)->branch;
$roll_num = $student_data->roll_num . '/' . $student_branch . '/' . substr($student_data->year, 2, 4);
unset($student_data->roll_num);
unset($student_data->branch);
unset($student_data->year);
$student_data->roll_num = $roll_num;
$student_data->category = StudentCategories::find($student_data->category)->category;
$issue->student = $student_data;
return $issue;
}
