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);
}
}
