public function run() { DB::table('borrow')->truncate(); for ($i = 0; $i < 10; $i++) { $book = new Borrow(); $book->book_id = rand(1, 10); $book->username = str_random(10); $book->userno = rand(10000, 99999); $book->phone = rand(13100000000, 15100000000); $book->return_at = \Carbon\Carbon::now(); $book->status = rand(0, 1); $book->save(); } }
public function borrow2() { //$user = user::where('email', '=', Input::get('bemail'))->firstOrFail(); $returnData = ""; $name = Input::get("name"); $email = Input::get("email"); if (Request::ajax()) { $userCount = User::where('email', '=', Input::get('email'))->count(); $bookCount = Book::where('barcode', '=', Input::get('barcode'))->count(); if ($userCount == 1) { $returnData = $returnData . " user existed "; $user = User::where('email', '=', Input::get('email'))->find(1); } if ($userCount == 0) { $name = Input::get("name"); $email = Input::get("email"); $user = user::create(array('email' => $email, 'name' => $name)); $returnData = $returnData . " user is created "; } if ($bookCount == 1) { $returnData = $returnData . " book existed "; $book = Book::where('barcode', '=', Input::get('barcode'))->find(1); } if ($bookCount == 0) { $title = Input::get('title'); $author = Input::get('author'); $barcode = Input::get('barcode'); $book = book::create(array('title' => $title, 'author' => $author, 'barcode' => $barcode)); $returnData = $returnData . " book is created "; } $borrow = Borrow::create(array('user_id' => $user->id, 'book_id' => $book->id)); $returnData = $returnData . " borrowing is successful user id =" . $user->id . " book id =" . $book->id; } return $returnData; }
public function overTime(Request $request) { $num = 10; $username = $request->session()->get("username"); $borrows = Borrow::where("date-should-return", "<", DB::raw("curdate()"))->paginate($num); return view("/admin/OverTime", ['username' => $username, "borrows" => $borrows]); }
public function history(Request $request) { $num = 10; $username = $request->session()->get("username"); $user = User::where('username', '=', $username)->first(); if ($user == null) { return redirect('/reader/home'); } $borrows = Borrow::where('reader-id', '=', $user['reader-id'])->orderBy('id')->paginate($num); return view('/reader/history', ['username' => $username, 'borrows' => $borrows]); }
public function back($id) { $data = array('errNum' => 0, 'errMsg' => '', 'errDate' => ''); $borrow = Borrow::find($id); $borrow->status = 1; $book = Book::find($borrow->book_id); $book->book_res = $book->book_res + 1; $book->save(); if ($borrow->update()) { $data['errMsg'] = "归还成功"; return json_encode($data); } else { $data['errMsg'] = "归还失败"; return json_encode($data); } }
public function bookLossAction(Request $request) { $reader_id = $request->input("reader-id"); $isbn = $request->input("isbn"); $book = Book::where("isbn", '=', $isbn)->first(); if ($book == null) { return redirect('/admin/bookLoss')->with("msg", "读者证编号有误,请检查!"); } if ($book['quantity-out'] + $book['quantity-loss'] + 1 > $book['quantity-in']) { return redirect('/admin/bookLoss')->with("msg", "图书信息有误,请检查!"); } $borrow = Borrow::where("reader-id", '=', $reader_id)->where("book-id", '=', $book['book-id'])->where("returned", '=', 0)->first(); if ($borrow == null) { return redirect('/admin/bookLoss')->with("msg", "信息有误,请检查!"); } $book['quantity-out'] = $book['quantity-out'] - 1; $book['quantity-Loss'] += 1; $book->save(); $borrow['loss'] = true; $borrow->save(); return redirect('/admin/bookLoss')->with("msg", "图书挂失成功!"); }