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>"; }
public function findModel() { if (Request::ajax()) { $data = Input::all(); $serial = $data['serial']; $findserial = Serial::where('serial', '=', $serial)->first(); if (is_null($findserial)) { //Not Found $data = array('serial' => $serial, 'model' => ''); } else { $data = array('serial' => $findserial->serial, 'model' => $findserial->model_id); } echo json_encode($data); } }