/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('divisions')->truncate(); DB::table('categories')->truncate(); DB::table('sub_categories')->truncate(); DB::table('brands')->truncate(); DB::table('skus')->truncate(); $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $filePath = 'database/seeds/seed_files/Items.xlsx'; $reader->open($filePath); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'SKU Data') { $rowcnt = 0; foreach ($sheet->getRowIterator() as $row) { if ($rowcnt > 1) { if (!is_null($row[0])) { $division = Division::firstOrCreate(['division' => $row[8]]); $category = Category::firstOrCreate(['category_short' => strtoupper($row[1]), 'category_long' => strtoupper($row[0])]); $sub_category = SubCategory::firstOrCreate(['subcategory' => strtoupper($row[6])]); $brand = Brand::firstOrCreate(['brand' => strtoupper($row[7])]); $sku = Sku::firstOrCreate(['division_id' => $division->id, 'category_id' => $category->id, 'sub_category_id' => $sub_category->id, 'brand_id' => $brand->id, 'sku_code' => $row[2], 'item_desc' => $row[3], 'sku_desc' => $row[4], 'conversion' => $row[5]]); } } $rowcnt++; } } } $reader->close(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
public function postCategoryCreate(Request $request) { $category = Category::firstOrCreate($request->only('name')); $category->description = $request->description ?: null; $category->save(); return redirect()->back(); }
/** * Parse excel data and insert it in database * * @param array $excelData * @return void */ protected function parseExcelData($excelData) { foreach ($excelData as $key => $data) { /* Skip first row */ if (1 == $key) { continue; } $Category = Category::firstOrCreate(['parent_id' => null, 'name' => $data['A']]); $SubCategory = Category::firstOrCreate(['parent_id' => (int) $Category->id, 'name' => $data['B']]); Catalog::create(['category_id' => $SubCategory->id, 'part_number' => $data['C'], 'description' => $data['D']]); } }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $data = $request->except('_token'); $category = Category::firstOrCreate(['name' => $data['name']]); $category->description = $data['description']; $category->type = $data['type']; $category->status = (int) $data['status']; $path = 'images/categories/'; $destinationPath = public_path($path); if ($request->hasFile('image_url')) { $name = $request->file('image_url')->getClientOriginalName(); $request->file('image_url')->move($destinationPath, $name); $category->image_url = $path . $name; } $category->save(); return redirect()->route('admin.categories.show', $category->id)->with(['message' => 'success!']); }
private static function prepareJobRecord($data) { $currentRecord = []; // VALIDATE DATA if (empty($data->external_job_id)) { ExportRecordFailure::create(['job_info' => json_encode($data), 'reason' => '[ external_job_id is missing ]', 'action' => '[ exiting process ]', 'calling_function' => __FUNCTION__]); return null; } if (empty($data->job_title)) { ExportRecordFailure::create(['external_job_id' => $data->external_job_id, 'job_info' => json_encode($data), 'reason' => '[ title is missing ]', 'action' => '[ exiting process ]', 'calling_function' => __FUNCTION__]); return null; } $end_date = null; if (preg_match("/^([0-9]{4})-([0-9]{2})-([0-9]{2})T.*\$/", $data->job_end_date, $end_date_matches)) { $end_date_mm = $end_date_matches[2]; $end_date_dd = $end_date_matches[3]; $end_date_yyyy = $end_date_matches[1]; $end_date = $end_date_yyyy . '-' . $end_date_mm . "-" . $end_date_dd; } if (empty($end_date)) { ExportRecordFailure::create(['external_job_id' => $data->external_job_id, 'job_info' => json_encode($data), 'reason' => '[ end date is missing ]', 'action' => '[ exiting process ]', 'calling_function' => __FUNCTION__]); return null; } else { $jobObj = Job::firstOrNew(['external_job_id' => $data->external_job_id, 'source_id' => 1]); if (strtotime($end_date) < strtotime(date('Y-m-d'))) { if (!empty($jobObj->id)) { $record_id = $jobObj->id; $jobObj->delete(); ExportRecordFailure::create(['external_job_id' => $data->external_job_id, 'job_info' => json_encode($data), 'reason' => '[ expired job ]', 'action' => '[ record deleted ][ record id: ' . $record_id . ' ] [ exiting process ]', 'calling_function' => __FUNCTION__]); return $record_id; } else { ExportRecordFailure::create(['external_job_id' => $data->external_job_id, 'job_info' => json_encode($data), 'reason' => '[ expired job ] ', 'action' => '[ will not create a record ] [ exiting process ]', 'calling_function' => __FUNCTION__]); $jobObj = null; return 1; } } } if (!empty($data->job_state) && $data->job_state == 'expired') { if (!empty($jobObj->id)) { $record_id = $jobObj->id; $jobObj->delete(); ExportRecordFailure::create(['external_job_id' => $data->external_job_id, 'job_info' => json_encode($data), 'reason' => '[ expired job ]', 'action' => '[ record deleted ][ record id: ' . $record_id . ' ] [ exiting process ]', 'calling_function' => __FUNCTION__]); return $record_id; } else { ExportRecordFailure::create(['external_job_id' => $data->external_job_id, 'job_info' => json_encode($data), 'reason' => '[ expired job ] ', 'action' => '[ will not create a record ] [ exiting process ]', 'calling_function' => __FUNCTION__]); $jobObj = null; return 1; } } // END OF DATA VALIDATION if (!empty($jobObj->id)) { $currentRecord = Job::getInfo($jobObj->id, ['JobState', 'JobCity', 'JobCompany', 'JobCategory', 'JobIndustry']); } $jobObj->source_id = 1; $jobObj->external_job_id = $data->external_job_id; if (!empty($data->job_name)) { $jobObj->name = self::cleanUpStr($data->job_name); } if (!empty($data->job_title)) { $jobObj->title = self::cleanUpStr($data->job_title); } if (!empty($data->org_name)) { $company_name = trim(str_replace("'", "'", $data->org_name)); } else { $company_name = 'Confidential'; } if (empty($currentRecord) || $currentRecord['JobCompany'] != $company_name) { $company_obj = Company::saveInstance(['name' => $company_name]); $jobObj->company_id = $company_obj->id; } $jobObj->apply_url = 'http://jobview.monster.com/getjob.aspx?jobid=' . $data->external_job_id; if ($company_name == 'Comcast Cable Communications Management, LLC') { if (!empty($data->apply_url)) { $jobObj->apply_url = $data->apply_url; } } if (preg_match("/^([0-9]{4})-([0-9]{2})-([0-9]{2})T.*\$/", $data->job_begin_date, $begin_date_matches)) { $begin_date_mm = $begin_date_matches[2]; $begin_date_dd = $begin_date_matches[3]; $begin_date_yyyy = $begin_date_matches[1]; $jobObj->begin_date = $begin_date_yyyy . '-' . $begin_date_mm . '-' . $begin_date_dd; } $jobObj->end_date = $end_date; if (preg_match("/^([0-9]{4})-([0-9]{2})-([0-9]{2})T.*\$/", $data->job_post_date, $post_date_matches)) { $post_date_mm = $post_date_matches[2]; $post_date_dd = $post_date_matches[3]; $post_date_yyyy = $post_date_matches[1]; $jobObj->post_date = $post_date_yyyy . '-' . $post_date_mm . '-' . $post_date_dd; } if (!empty($data->job_category)) { if (empty($currentRecord) || $currentRecord['JobCategory'] != $data->job_category) { $cat_obj = Category::firstOrCreate(['name' => $data->job_category]); $jobObj->category_id = $cat_obj->id; } } if (!empty($data->job_industries[0])) { if (empty($currentRecord) || $currentRecord['JobIndustry'] != $data->job_industries[0]) { $ind_obj = Industry::firstOrCreate(['name' => $data->job_industries[0]]); $jobObj->industry_id = $ind_obj->id; } } if (isset($data->location) && !empty($data->location)) { $location = $data->location; if (!empty(trim($location->city))) { $jobObj->city = trim($location->city); } if (!empty(trim($location->state))) { $jobObj->state = trim($location->state); } if (!empty(trim($location->country))) { $jobObj->country = trim($location->country); } if (isset($location->zip) && !empty(trim($location->zip))) { if (trim($location->zip) == '00000') { $jobObj->zip = null; } else { $jobObj->zip = trim($location->zip); } } if (!empty($jobObj->city) && !empty($jobObj->state)) { if (empty($currentRecord) || $currentRecord['JobCity'] != $jobObj->city || $currentRecord['JobState'] != $jobObj->state) { $dma_obj = DmaMap::where(['city' => $jobObj->city, 'state_abbr' => $jobObj->state])->first(); if (!empty($dma_obj)) { $jobObj->dma_code = $dma_obj->code; } } } } return $jobObj; }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update($id, Request $request) { $book = \App\Book::findOrFail($id); // $book->update(\Input::all()); // return \Redirect::back()->with('message','Book updated.'); // if($book){ // $rules = \App\Book::$rules; //$rules['name'] = 'required|min:2'; // $validator = \Validator::make(\Input::all(), $rules); // if($validator->passes()) // { $book->description = $request->description; $book->publisher_id = \App\Publisher::firstOrCreate(['name' => ucfirst($request->publisher)])->id; $book->category_id = \App\Category::firstOrCreate(['name' => ucfirst($request->category)])->id; $book->language_id = \App\Language::firstOrCreate(['name' => ucfirst($request->language)])->id; $book->release_date = $request->release_date; $book->save(); //going over author names build up array of author ids by getting author ids and creating author if does not exist $authorIds = []; $authors = $request->authors; if ($authors) { foreach ($authors as $author) { $authorIds[] = App\Author::firstOrCreate(['name' => ucfirst($author)])->id; } //atached book to authors $book->authors()->sync($authorIds); // $book->authors()->attach($authorIds); } if ($request->hasFile('image')) { $this->setBookImage($book, $request); } flash('Book updated.'); return \Redirect::back(); // } // return \Redirect::back() // //->with('message','There were some errors. Please try again later..') // ->withInput() // ->withErrors($validator); // } // // flash()->error('Book does not exist.'); // return \Redirect::back(); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(ArticleRequest $request, Guard $auth, $slug) { // find or create category $category = Category::firstOrCreate(['name' => e($request->input('category')), 'slug' => e(str_slug(pinyin($request->input('category')))), 'user_id' => $auth->user()->id]); // find or create tags foreach ($request->input('tags') as $tag) { $tagids[] = Tag::firstOrCreate(['name' => e($tag), 'slug' => e(str_slug(pinyin($tag))), 'user_id' => $auth->user()->id])->id; } // create article $article = Article::where('slug', $slug)->firstOrFail(); $article->fill($request->all()); $article->slug = empty($article->slug) ? str_slug(pinyin($article->title)) : $article->slug; $article->cover = $this->saveCover($request, $article); $article->user_id = $auth->user()->id; $article->category_id = $category->id; $article->public = $request->has('public') ? 1 : 0; $article->published_at = Carbon::now(); $article->update(); $article->tags()->sync($tagids); flash()->success(trans('flash_messages.article_update_success')); return redirect('admin/articles/hub'); }