/** * [getlinkfilebyid description] * @param [type] $filedown [description] * @return [type] [description] */ public function getlinkfilebyid($filedown) { $user_id = Auth::user()->id; $filedown_id = File::getIdByFileName($filedown); $is_download = Mymail_User::join('file_mails', 'mail_users.mail_id', '=', 'file_mails.mail_id')->where('mail_users.user_id', $user_id)->where('file_mails.file_id', $filedown_id)->first(); if ($is_download) { $file = storage_path() . '/uploads/' . $filedown; return response()->download($file); } else { return \Redirect::to('/')->with('error', 'Không có quyền truy cập'); } }
/** * check cong van di file is download by user * @param $filedown * @param $user * @return mixed */ public static function downloadcongvandibyusername($filedown, $user) { $filedown_id = File::getIdByFileName($filedown); $is_download = Congvandi::join('file_congvandis', 'congvandis.id', '=', 'file_congvandis.congvandi_id')->leftjoin('congvandi_danhmucphongs', 'congvandis.id', '=', 'congvandi_danhmucphongs.congvandi_id')->leftjoin('congvandi_danhmucdois', 'congvandis.id', '=', 'congvandi_danhmucdois.congvandi_id')->leftjoin('congvandi_users', 'congvandis.id', '=', 'congvandi_users.congvandi_id')->where('congvandis.nguoitao_id', $user->id)->orWhere('congvandi_danhmucphongs.danhmucphong_id', $user->phong_id)->orWhere('congvandi_danhmucdois.danhmucdoi_id', $user->doi_id)->orWhere('congvandi_users.user_id', $user->id)->where('file_congvandis.file_id', $filedown_id)->first(); return $is_download; }