public function generate() { $serial = new Serial(); $serial->serial = $this->serial; $serial->duration = $this->duration; $serial->save(); for ($number = 1; $number <= $this->quantity; $number++) { $card = new Card(); $card->serial_id = $serial->id; $card->number = $number; $card->save(); } }
public function import($name) { // echo $name; // exit; $file = '../laravel/app/storage/csv/' . $name . '.csv'; // echo $file; // exit; $allowedfilenames = array("serials", "installers"); if (in_array($name, $allowedfilenames)) { //Parse into array $array = $this->csvtoarray($file); switch ($name) { case 'serials': foreach ($array as $item) { $serial = new Serial(); $find = $serial->where('serial', '=', $item['serial'])->first(); if (!$find) { $serial->model_id = $item['model_id']; $serial->serial = $item['serial']; $serial->save(); } } break; case 'installers': // echo "<pre>"; // print_r($array); // echo "</pre>"; // exit; $insertcount = 0; $updatecount = 0; foreach ($array as $item) { $installer = new Installer(); $find = $installer->where('account_number', '=', $item['account_number'])->first(); if ($find->id) { $installer = Installer::find($find->id); } $installer->account_number = trim($item['account_number']); $installer->business_name = trim($item['business_name']); $installer->address = trim($item['address']); $installer->city = trim($item['city']); $installer->state = trim($item['state']); $installer->zip = trim($item['zip']); $installer->phone = trim($item['phone']); if ($installer->save()) { if ($find->id) { $updatecount++; } else { $insertcount++; } } else { echo "Whoops"; exit; } } echo "Updated: " . $updatecount . "<br />"; echo "Inserted: " . $insertcount . "<br />"; break; } } // echo "<pre>"; // print_r($array); // echo "</pre>"; }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $units = $_POST['unit']; $i = 1; foreach ($units as $unit) { $units_array['unit_' . $i] = $unit; $i++; } Input::merge($units_array); $numunits = array('numunits' => sizeof($units_array)); Input::merge($numunits); // echo "<pre>"; // print_r(Input::all()); // echo "</pre>"; // exit; $rules = array('first_name' => 'required', 'last_name' => 'required', 'email' => 'required|email', 'unit_1' => 'required|digits:10|numeric', 'unit_2' => 'digits:10|numeric', 'unit_3' => 'digits:10|numeric', 'unit_4' => 'digits:10|numeric', 'unit_5' => 'digits:10|numeric', 'unit_6' => 'digits:10|numeric', 'unit_7' => 'digits:10|numeric', 'unit_8' => 'digits:10|numeric', 'unit_9' => 'digits:10|numeric', 'unit_10' => 'digits:10|numeric', 'address' => 'required', 'city' => 'required', 'state' => 'required', 'zip' => 'required', 'installer_id' => 'required'); $messages = array('unit_1.required' => 'You must enter at least one serial number.', 'unit_1.digits' => 'Your serial number must be 10 digits.', 'unit_1.exists' => 'That serial number doesn\'t exist in our database.', 'installer_id.required' => 'You must choose an installer.'); $validator = Validator::make(Input::all(), $rules, $messages); // process the login if ($validator->fails()) { return Redirect::to('register')->withErrors($validator)->withInput(Input::all()); } else { // echo "<pre>"; // print_r($_POST); // echo "</pre>"; // exit; // store $user = new User(); $user->first_name = Input::get('first_name'); $user->last_name = Input::get('last_name'); $user->address = Input::get('address'); $user->address_2 = Input::get('address_2'); $user->city = Input::get('city'); $user->state = Input::get('state'); $user->zip = Input::get('zip'); $user->country = Input::get('country'); $user->phone = Input::get('phone'); $user->email = Input::get('email'); $user->comments = Input::get('comments'); $user->installer_id = Input::get('installer_id'); //$user->password = Hash::make('test'); $user->save(); $units = $_POST['unit']; foreach ($units as $unit) { if ($unit) { $serial = new Serial(); // $serials = $serial->where('serial','=',$unit)->first(); $serial->serial = $unit; $serial->save(); $serialid = $serial->id; $user->serials()->attach($user->id, array('serial_id' => $serialid)); } } // //Find Serial Outdoor // $serial_input = Input::get('serial_outdoor'); // $serial = new Serial; // $serials = $serial->where('serial','=',$serial_input)->first(); // if($serials) { // $user->serials()->attach($user->id,array('serial_id' => $serials->id )); // } // $serial_indoor_coil = Input::get('serial_indoor_coil'); // if($serial_indoor_coil) { // $serial_2 = new Serial; // $serials_2 = $serial_2->where('serial','=',$serial_indoor_coil)->first(); // if($serials_2) { // $user->serials()->attach($user->id,array('serial_id' => $serials_2->id )); // } // } // $serial_indoor_furnace = Input::get('serial_indoor_furnace'); // if($serial_indoor_furnace) { // $serial_3 = new Serial; // $serials_3 = $serial_3->where('serial','=',$serial_indoor_coil)->first(); // if($serials_2) { // $user->serials()->attach($user->id,array('serial_id' => $serials_3->id )); // } // } //Review // $rating = new Rating(); // $rating->user_id = $user->id; // $rating->timeliness_rating = Input::get('timeliness_rating'); // $rating->cleanliness_rating = Input::get('cleanliness_rating'); // $rating->courteous_rating = Input::get('courteous_rating'); // $rating->answer_rating = Input::get('answer_rating'); // $rating->recommend = Input::get('recommend'); // $rating->review = Input::get('review'); // if( !$rating->save() ) { // echo "Whoops"; // exit; // } $data = Input::all(); //Mail Mail::send('emails.thankyouregister', $data, function ($message) { $username = Input::get('first_name') . " " . Input::get('last_name'); $message->from(Config::get('site.mail_from'), Config::get('site.mail_from_name')); $message->to(Input::get('email'), $username)->subject(Input::get('first_name') . ', Thank You for Registering your Product!'); }); Mail::send('emails.adminregister', $data, function ($message) { // $username = Input::get('first_name')." ".Input::get('last_name'); $message->from(Config::get('site.mail_from'), Config::get('site.mail_from_name')); $message->to(Config::get('site.mail_from'), Config::get('site.mail_from_name'))->subject('New Registration: ' . Input::get('email')); }); // redirect Session::flash('message', 'Successfully registered!'); Session::put('user_id', $user->id); Session::put('units', $units); return Redirect::action('UserController@confirm'); //return Redirect::route('register.confirm')->with('user', $user->id); } }