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); }
public function printdetail() { $IdDetail = Input::get('txtIdDetail'); $dsPhieuMuon = 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('phieu_muon_sach.id', 'quyen_sach.id', 'chi_tiet_phieu_muon_sach.id_quyen_sach', 'chi_tiet_phieu_muon_sach.id_phieu_muon', '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', 'chi_tiet_phieu_muon_sach.thoi_gian_muon', 'nguoi_dung.id_nhom_quyen_han', 'phieu_muon_sach.ma_so_phieu', 'phieu_muon_sach.trang_thai_phieu', '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', 'quyen_sach.ma_bar_code', 'chi_tiet_phieu_muon_sach.id')->where('chi_tiet_phieu_muon_sach.id_phieu_muon', $IdDetail); $dsPhieuMuon = $dsPhieuMuon->paginate(QUAN_LY_SO_PHIEU_MUON_TREN_TRANG); return View::make('thuthu_quanlymuontra.printdetail')->with('title', 'Bảng in chi tiết phiếu mượn')->with('dsPhieuMuon', $dsPhieuMuon); }
public static function getIdDauSach($idQuyenSach) { $idDauSach = QuyenSach::select('id_dau_sach')->where('id', $idQuyenSach)->get(); return $idDauSach[0]->id_dau_sach; }
public function printt2() { $now = date('Y-m-d', time()); $NgonNgu = Input::get('txtNgonNgu'); $dsSachMuon = null; if ($NgonNgu == null || $NgonNgu == 'allNN') { $dsSachMuon = 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')->orderBy('chi_tiet_phieu_muon_sach.thoi_gian_hen_tra', 'desc'); } else { $dsSachMuon = 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('dau_sach.ngon_ngu_sach', $NgonNgu)->orderBy('chi_tiet_phieu_muon_sach.thoi_gian_hen_tra', 'desc'); } $dsSachMuon = $dsSachMuon->get(); return View::make('thuthu_thongke.print2')->with('title', 'In danh sách các sách mượn nhiều')->with('dsSachMuon', $dsSachMuon); }