public function destroy() { General::storeevents(NGUOI_DUNG_LOGOUT); Session::flush(); Auth::logout(); return Redirect::route("login"); }
public function store() { if (Input::has('btnThem')) { $nhomquyen = Input::get('quyen'); $mst = str_replace(" ", "", Input::get('txtMaSoThe')); $pass = Hash::make(General::randomPassword()); $hoten = str_replace(" ", " ", trim(Input::get('txtHoTen'))); $gioitinh = Input::get('gioiTinh'); $ngaysinh = Input::get('txtNgaySinh'); $email = str_replace(" ", "", Input::get('txtEmail')); $ngaycapthe = Input::get('txtNgayCapThe'); $ngayhethan = null; if (Input::get('txtNgayHetHan') != "") { $ngayhethan = Input::get('txtNgayHetHan'); } $tthoatdong = 0; if (Input::get('checkHoatDong') == "hoatdong") { $tthoatdong = 1; } else { $tthoatdong = 0; } $result = DB::table('nguoi_dung')->insert(array('id_nhom_quyen_han' => $nhomquyen, 'ma_so_the' => $mst, 'password' => $pass, 'ho_ten' => $hoten, 'gioi_tinh' => $gioitinh, 'ngay_sinh' => $ngaysinh, 'email' => $email, 'ngay_cap_the' => $ngaycapthe, 'ngay_het_han' => $ngayhethan, 'trang_thai_hoat_dong' => $tthoatdong)); General::storeevents(QUAN_LY_THEM_NGUOI_DUNG . " có mã số thẻ " . $mst); return Redirect::back()->with('message', 'Thêm người dùng thành công!'); } }
public function index() { $tinhtrang = 6; $idnm = Auth::user()->id; if (Input::has('tinhtrang')) { $tinhtrang = trim(Input::get('tinhtrang')); if ($tinhtrang != 0 && $tinhtrang != 1 && $tinhtrang != 2 && $tinhtrang != 3 && $tinhtrang != 4 && $tinhtrang != 5) { $tinhtrang = 6; } } $quyensachs = DB::select(DB::raw("CALL tra_cuu_muon_tra(" . $tinhtrang . "," . $idnm . ");")); General::storeevents(NGUOI_MUON_TRA_CUU_MUON_TRA); return View::make('nguoimuon_muontra.index_muontra')->with('title', 'Tra cứu mượn - trả trong thư viện')->with('quyensachs', $quyensachs); }
public function create() { $CacSachMuon = null; $IdPhieuMuon = General::getIdPhieu(ThuThuQuanLyMuonTra::getMaSoVuaNhap()); $CacSachMuon = QuyenSach::join('chi_tiet_phieu_muon_sach', function ($join) { $join->on('chi_tiet_phieu_muon_sach.id_quyen_sach', '=', 'quyen_sach.id'); })->join('phieu_muon_sach', function ($join) { $join->on('chi_tiet_phieu_muon_sach.id_phieu_muon', '=', 'phieu_muon_sach.id'); })->join('dau_sach', function ($join) { $join->on('dau_sach.id', '=', 'quyen_sach.id_dau_sach'); })->select('quyen_sach.id', 'quyen_sach.ma_bar_code', 'chi_tiet_phieu_muon_sach.id_quyen_sach', 'chi_tiet_phieu_muon_sach.id_phieu_muon', 'chi_tiet_phieu_muon_sach.ghi_chu_sach_muon', 'chi_tiet_phieu_muon_sach.id_nguoi_cap_nhat', 'chi_tiet_phieu_muon_sach.tg_cap_nhat_trang_thai', 'chi_tiet_phieu_muon_sach.trang_thai_sach_muon', 'phieu_muon_sach.id', 'dau_sach.id', 'quyen_sach.id_dau_sach', 'dau_sach.ten_dau_sach', 'phieu_muon_sach.id_nguoi_muon', 'chi_tiet_phieu_muon_sach.thoi_gian_hen_tra', 'chi_tiet_phieu_muon_sach.thoi_gian_muon', 'phieu_muon_sach.ma_so_phieu', 'chi_tiet_phieu_muon_sach.id')->where('chi_tiet_phieu_muon_sach.id_phieu_muon', $IdPhieuMuon); $CacSachMuon = $CacSachMuon->paginate(QUAN_LY_SO_PHIEU_MUON_TREN_TRANG); General::storeevents(THU_THU_THEM_PHIEU_MUON_TRA); return View::make('thuthu_quanlymuontra.create')->with('title', 'Thêm phiếu mượn')->with('CacSachMuon', $CacSachMuon); }
public function index1() { $dsSachMuonChuaTra = null; $dsSachMuonChuaTra = QuyenSach::join('chi_tiet_phieu_muon_sach', function ($join) { $join->on('chi_tiet_phieu_muon_sach.id_quyen_sach', '=', 'quyen_sach.id'); })->join('phieu_muon_sach', function ($join) { $join->on('chi_tiet_phieu_muon_sach.id_phieu_muon', '=', 'phieu_muon_sach.id'); })->join('dau_sach', function ($join) { $join->on('dau_sach.id', '=', 'quyen_sach.id_dau_sach'); })->join('nguoi_dung', function ($join) { $join->on('nguoi_dung.id', '=', 'phieu_muon_sach.id_nguoi_muon'); })->select('quyen_sach.id', 'chi_tiet_phieu_muon_sach.id_quyen_sach', 'chi_tiet_phieu_muon_sach.id_phieu_muon', 'phieu_muon_sach.id', 'dau_sach.id', 'quyen_sach.id_dau_sach', 'dau_sach.ten_dau_sach', 'dau_sach.ngon_ngu_sach', 'phieu_muon_sach.id_nguoi_muon', 'nguoi_dung.id', 'nguoi_dung.ma_so_the', 'chi_tiet_phieu_muon_sach.thoi_gian_hen_tra', 'quyen_sach.ma_bar_code')->where('chi_tiet_phieu_muon_sach.trang_thai_sach_muon', 1, 'or')->where('chi_tiet_phieu_muon_sach.trang_thai_sach_muon', 2, 'or')->where('chi_tiet_phieu_muon_sach.trang_thai_sach_muon', 3)->orderBy('chi_tiet_phieu_muon_sach.thoi_gian_hen_tra', 'desc'); $dsSachMuonChuaTra = $dsSachMuonChuaTra->paginate(QUAN_LY_SO_PHIEU_MUON_TREN_TRANG); General::storeevents(QUAN_LY_THANH_TOAN_SV_NGHI_HOC); return View::make('thuthu_thanhtoanratruong.index_nghihoc')->with('title', 'Thanh toán sinh viên nghỉ học')->with('dsSachMuonChuaTra', $dsSachMuonChuaTra); }
/** * Display a listing of the resource. * * @return Response */ public function index() { General::storeevents(NGUOI_DUNG_DOI_MAT_KHAU); return View::make('nguoidung_canhan.index_doimatkhau')->with('title', 'Đổi mật khẩu'); }
public function create() { General::storeevents(QUAN_LY_QUAN_LY_THEM_MOI_SACH); return View::make('quanly_quanlysach.create')->with('title', 'Thêm mới sách'); }
public function index1() { General::storeevents(THU_THU_THONG_KE_SACH_MUON_NHIEU); return View::make('thuthu_thongke.index_report2')->with('title', 'Thống kê sách mượn nhiều'); }
public function destroy() { $id = Input::get('txtIdThread'); BaiViet::find($id)->delete(); General::storeevents(QUAN_LY_XOA_BAI_VIET . " id số " . $id); return Redirect::back()->with('message', 'Xóa thành công!'); }
/** * Display a listing of the resource. * * @return Response */ public function index() { General::storeevents(NGUOI_DUNG_THONG_BAO); return View::make('nguoidung_canhan.index_thongbao')->with('title', 'Thông báo'); }
public function index() { if (Input::has('loai')) { $flag = Input::get('loai'); if ($flag == 'stk') { $tensach = str_replace(" ", " ", trim(Input::get('tenSach'))); $namxb = trim(Input::get('namxb')); $nhaxb = trim(Input::get('nhaxb')); $ngonngu = trim(Input::get('ngonngu')); if ($tensach == "") { $tensach = "null"; } if ($namxb == "") { $namxb = 0; } if ($nhaxb == "") { $nhaxb = 0; } $id_dau_sach = DB::select(DB::raw("CALL tim_tai_lieu_tham_khao('" . $tensach . "'," . $namxb . "," . $nhaxb . ",'" . $ngonngu . "');")); $array = array(); foreach ($id_dau_sach as $key) { array_push($array, $key->id); } $dstailieus = $this->getDauSachNguoiMuon($array); } else { if ($flag == 'lv') { $tensach = str_replace(" ", " ", trim(Input::get('tenSach'))); $namth = trim(Input::get('namth')); $lvcaohoc = trim(Input::get('loailv')); $svth = trim(Input::get('svth')); $gvhd = trim(Input::get('gvhd')); if ($lvcaohoc == "tn") { $lvcaohoc = 0; } else { if ($lvcaohoc == "caohoc") { $lvcaohoc = 1; } else { $lvcaohoc = 2; } } if ($tensach == "") { $tensach = "null"; } if ($namth == "") { $namth = 0; } if ($svth == "") { $svth = 0; } if ($gvhd == "") { $gvhd = 0; } $id_dau_sach = DB::select(DB::raw("CALL tim_kiem_luan_van('" . $tensach . "'," . $lvcaohoc . "," . $namth . "," . $svth . "," . $gvhd . ");")); $array = array(); foreach ($id_dau_sach as $key) { array_push($array, $key->id); } $dstailieus = $this->getDauSachNguoiMuon($array); } else { $tenSach = trim(Input::get('tenSach')); $dstailieus = $this->getAllDauSach($tenSach); } } } else { $tenSach = trim(Input::get('tenSach')); $dstailieus = $this->getAllDauSach($tenSach); } General::storeevents(NGUOI_MUON_TRA_CUU_SACH); return View::make('nguoimuon_muontra.index_tracuu')->with('title', 'Tra cứu sách trong thư viện')->with('dstailieus', $dstailieus); }