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);
}
