/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $teachUpload = new Upload(); if (Request::hasFile('upload')) { $file = Request::file('upload'); $file = $file->move(public_path() . '/uploads/dates', time() . '-' . $file->getClientOriginalName()); $teachUpload->file_path = $file->getRealPath(); $teachUpload->save(); $csvPath = $teachUpload->file_path; $reader = Reader::createFromPath($csvPath); $reader->setFlags(SplFileObject::READ_AHEAD | SplFileObject::SKIP_EMPTY); $reader->setOffset(1); $pattern = '/([(A-Z)|A-Z]* - .+)/'; $courses = DB::table('courses')->get(); foreach ($reader as $index => $row) { if ($index != 0) { $courseNo = $row[1]; $teachDate = $row[5]; $startTime = $row[6]; $endTime = $row[7]; foreach ($courses as $course) { if ($courseNo == $course->course_no) { DB::table('dates')->insert(array('course_id' => $course->id, 'teach_date' => $teachDate, 'session_start' => $startTime, 'session_end' => $endTime)); } } } } } $teachUpload->save(); return redirect()->route('admin_dates_index')->with('status', 'Teach dates uploaded'); }
/** * Upload the file and store * the file path in the DB. */ public function store() { // Rules $rules = array('name' => 'required', 'file' => 'required|max:20000'); $messages = array('max' => 'Please make sure the file size is not larger then 20MB'); // Create validation $validator = Validator::make(Input::all(), $rules, $messages); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } $directory = "uploads/files/"; // Before anything let's make sure a file was uploaded if (Input::hasFile('file') && Request::file('file')->isValid()) { $current_file = Input::file('file'); $filename = Auth::id() . '_' . $current_file->getClientOriginalName(); $current_file->move($directory, $filename); $file = new Upload(); $file->user_id = Auth::id(); $file->project_id = Input::get('project_id'); $file->name = Input::get('name'); $file->path = $directory . $filename; $file->save(); return Redirect::back(); } $upload = new Upload(); $upload->user_id = Auth::id(); $upload->project_id = Input::get('project_id'); $upload->name = Input::get('name'); $upload->path = $directory . $filename; $upload->save(); return Redirect::back(); }
protected function saveLogo($_user_id, $_file, $_base64_data = false) { $uid = intval($_user_id); if ($uid <= 0) { xplog('Invalid user id given', __METHOD__); return false; } $user_company_details = $this->getDetailsByUserId($uid); // If logo already exists then delete the file first // if (!!$user_company_details && trim($user_company_details->logo) !== '') { if (App\Files::isFile($this->logo_dir . '/' . $user_company_details->logo)) { App\Cb\Files::deleteAllInstance($this->logo_dir . '/' . $user_company_details->logo); } } if (!$_base64_data) { $uploaded_image_details = App\Upload::save($_file, ['destination' => $this->logo_dir . '/']); } else { $uploaded_image_details = App\Upload::saveBase64($_file->base64, ['destination' => $this->logo_dir . '/', 'extension' => $_file->extension]); } if (!is_object($uploaded_image_details)) { xplog('Unable to save logo', __METHOD__); return false; } // Save in the database // $res = DB::table('user_company_details')->where('users_id', $uid)->update(['logo' => $uploaded_image_details->coded_name]); if ($res === false) { xplog('Unable to save logo in the database', __METHOD__); return false; } return $uploaded_image_details->coded_name; }
/** * Generate unique name based on the * uniqid() function * * @param $file requested file to upload */ public static function put($file) { if ($file->isValid()) { $name = uniqid() . '.' . $file->guessExtension(); $fileInfo = ['name' => $name, 'type' => $file->getMimeType(), 'size' => $file->getClientSize()]; $file->move(public_path() . '/uploads', $name); $upload = new Upload(); $upload->name = $fileInfo['name']; $upload->type = $fileInfo['type']; $upload->size = $fileInfo['size']; $upload->save($fileInfo); //dd($upload->id); return [$upload->id]; } else { return $file->getErrorMessage(); } }
protected function save($_property_id, $_files_array = [], $_type = 'doc') { $pid = intval($_property_id); $type = trim(strtolower($_type)); if ($pid <= 0) { xplog('Invalid property id given', __METHOD__); return false; } $insert_data = []; $uploaded_file_details = []; $destination_dir = $type === 'doc' ? $this->docs_dir . '/' : $this->images_dir . '/'; foreach ($_files_array as $file) { $file = (array) $file; $name = isset($file['filename']) ? $file['filename'] : $file['name']; if (trim($name) === '') { continue; } if (!isset($file['base64'])) { // Web $uploaded_file_details = App\Upload::save($file, ['destination' => $destination_dir]); } else { // Mobile $uploaded_file_details = App\Upload::saveBase64($file['base64'], ['destination' => $destination_dir, 'extension' => $file['extension']]); } if (!is_object($uploaded_file_details)) { xplog('Unable to save file "' . $name . '" for property "' . $pid . '"', __METHOD__); continue; } // Gather details for the database // $insert_data[] = ['properties_id' => $pid, 'type' => $type === 'doc' ? 'doc' : 'image', 'codedname' => $uploaded_file_details->coded_name, 'filename' => $uploaded_file_details->filename, 'extension' => $uploaded_file_details->extension]; } if (count($insert_data)) { // Make sure that their are data to save. return is_numeric(DB::table('property_files')->insert($insert_data)); // Insert the file data to the database } return true; }
private function uploadFile($request, $name_input) { $application_id = $request->input('request_id', 0); $file = $request->file($name_input, null); $filetype = intval(str_replace('file_', '', $name_input)); print $filetype; $upload = Upload::where('application_id', $application_id)->where('filetype', $filetype)->first(); if (!$upload) { $upload = new Upload(); } if ($request->hasFile($name_input)) { if ($upload->file_path) { // Remove old file from directory if (file_exists($upload->file_path)) { unlink($upload->file_path); } } // Copy new file to directory $hash = md5(microtime()); $fileName = $hash . '.' . $file->getClientOriginalExtension(); $file->move('file/', $fileName); $upload->file_path = 'file/' . $fileName; $upload->status = 'uploaded'; $upload->filetype = $filetype; $upload->application_id = $application_id; $upload->save(); } }
public function storeAll() { $upload = new Upload(); if (Request::hasFile('upload')) { // Gets uploaded file move to courses directory store contents in $reader $file = Request::file('upload'); $file = $file->move(public_path() . '/uploads/courses', time() . '-' . $file->getClientOriginalName()); $upload->file_path = $file->getRealPath(); $upload->save(); $csvPath = $upload->file_path; $reader = Reader::createFromPath($csvPath); $reader->setFlags(SplFileObject::READ_AHEAD | SplFileObject::SKIP_EMPTY); $reader->setOffset(1); /** * Get data from Centres / Qualifications / Sittings / Papers tables * Regex CSV data with exising table data - create new row in Courses * */ $pattern = '/([(A-Z)|A-Z]* - .+)/'; $qualPattern = '/\\b(ACCA|CIMA)\\b/'; $paperPattern = '/(.)(\\d)/'; $elementPattern = '/(Tuition|QB Day|QB Evening|Revision|Full Time Short|Full Time Long)/i'; $methodPattern = '/(Classroom|Live Online|Distance Learning)/i'; $levelPattern = '/(Skills|Essentials|Options)/i'; $weekPattern = '/(Weekday|Weekend)/i'; $centres = DB::table('centres')->get(); $courses = DB::table('courses')->get(); $qualifications = DB::table('qualifications')->get(); $sittings = DB::table('sittings')->get(); $papers = DB::table('papers')->get(); foreach ($reader as $index => $row) { if ($index != 0) { $centreCode = $row[0]; $courseNo = $row[1]; $courseName = $row[2]; $sittingDate = $row[3]; $startDate = $row[5]; $courseMethod = $row[8]; $status = $row[9]; $price = $row[10]; $centreId; $sittingId; //Get Course title $courseTitle = preg_match($pattern, $courseName, $courseMatch); //Get qualification Id $courseQual = preg_match($qualPattern, $courseName, $qualMatch); $qual = DB::table('qualifications')->where('qualification_name', $qualMatch[0])->get(); $qualId = $qual[0]->id; // Get Paper Id $coursePaper = preg_match($paperPattern, $courseName, $paperMatch); $paper = DB::table('papers')->where('paper_name', $paperMatch[0])->get(); $paperId = $paper[0]->id; // Get Method Id $courseMethod = preg_match($methodPattern, $courseMethod, $methodMatch); $method = DB::table('methods')->where('method_name', $methodMatch[0])->get(); $methodId = $method[0]->id; // Get Element Id $courseElement = preg_match($elementPattern, $courseName, $elementMatch); $element = DB::table('elements')->where('element_name', $elementMatch[0])->get(); $elementId = $element[0]->id; //Get Level Id $courseLevel = preg_match($levelPattern, $courseName, $levelMatch); $level = DB::table('levels')->where('level_name', $levelMatch[0])->get(); $levelId = $level[0]->id; //Get Week Id $courseWeek = preg_match($weekPattern, $courseName, $weekMatch); if ($courseWeek != 0) { $week = DB::table('weektimes')->where('name', $weekMatch[0])->get(); $weekId = $week[0]->id; } else { $weekId = null; } //Get centre Id foreach ($centres as $centre) { if ($centreCode == $centre->centre_code) { $centreId = $centre->id; } } // Get Sitting Id foreach ($sittings as $sitting) { $sittingVal = $sitting->year . $sitting->month; if ($sittingDate == $sittingVal) { $sittingId = $sitting->id; } } // Insert data into Courses DB::table('courses')->insert(array('course_no' => $courseNo, 'name' => $courseMatch[0], 'start_date' => $startDate, 'price' => $price, 'status' => $status, 'qualification_id' => $qualId, 'centre_id' => $centreId, 'sitting_id' => $sittingId, 'paper_id' => $paperId, 'method_id' => $methodId, 'level_id' => $levelId, 'element_id' => $elementId, 'weektime_id' => $weekId)); } } } $upload->save(); }