Ejemplo n.º 1
4
 /**
  * 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();
 }
Ejemplo n.º 2
0
 public function postCategoryCreate(Request $request)
 {
     $category = Category::firstOrCreate($request->only('name'));
     $category->description = $request->description ?: null;
     $category->save();
     return redirect()->back();
 }
Ejemplo n.º 3
0
 /**
  * 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']]);
     }
 }
Ejemplo n.º 4
0
 /**
  * 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!']);
 }
Ejemplo n.º 5
0
 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("&apos;", "'", $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;
 }
Ejemplo n.º 6
0
 /**
  * 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();
 }
Ejemplo n.º 7
0
 /**
  * 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');
 }