function store(Request $request) { $input = $request->all(); $testArr = array(); $getParam = Parameter::where('name', '=', $input['parameter'])->first(); if (!empty($getParam)) { $testArr['parameter_id'] = $getParam->id; } else { $parameter = new Parameter(); $parameter->create(array('name' => $input['parameter'])); $testArr['parameter_id'] = DB::getPdo()->lastInsertId(); } $getState = Parameter::where('name', '=', $input['state'])->first(); if (!empty($getState)) { $testArr['state_id'] = $getState->id; } else { $state = new State(); $state->create(array('name' => $input['state'])); $testArr['state_id'] = DB::getPdo()->lastInsertId(); } $getMethod = Method::where('name', '=', $input['method'])->first(); if (!empty($getMethod)) { $testArr['method_id'] = $getMethod->id; } else { $method = new Method(); $method->create(array('name' => $input['method'])); $testArr['method_id'] = DB::getPdo()->lastInsertId(); } $getTestMethod = TestMethod::where('name', '=', $input['test_method'])->first(); if (!empty($getTestMethod)) { $testArr['test_method_id'] = $getTestMethod->id; } else { $tmethod = new TestMethod(); $tmethod->create(array('name' => $input['test_method'])); $testArr['test_method_id'] = DB::getPdo()->lastInsertId(); } $checkTest = Test::where('parameter_id', '=', $testArr['parameter_id'])->where('parameter_id', '=', $testArr['state_id'])->where('parameter_id', '=', $testArr['method_id'])->where('parameter_id', '=', $testArr['test_method_id'])->first(); if ($checkTest) { $test_id = $checkTest->id; Session::flash('flash_message', 'Test already exist.'); } else { $testArr['price'] = 147; $test = new Test(); $test::create($testArr); $test_id = DB::getPdo()->lastInsertId(); Session::flash('flash_message', 'Test created successfully.'); } if ($test_id) { DB::table('test_processes')->where('test_id', '=', $test_id)->delete(); if ($request->has('test_item')) { $items = $request->get('test_item'); foreach ($items as $key => $value) { $process = new Process(); $process::create(array('test_id' => $test_id, 'item_id' => $value, 'status' => 1)); } } } Session::flash('flash_type', 'alert-success'); return redirect('admin/tests'); }
public function run() { DB::table('states')->delete(); State::create(['abr' => 'AL', 'state' => 'Alabama']); State::create(['abr' => 'AK', 'state' => 'Alaska']); State::create(['abr' => 'AZ', 'state' => 'Arizona']); State::create(['abr' => 'AR', 'state' => 'Arkansas']); State::create(['abr' => 'CA', 'state' => 'California']); State::create(['abr' => 'CO', 'state' => 'Colorado']); State::create(['abr' => 'CT', 'state' => 'Connecticut']); State::create(['abr' => 'DE', 'state' => 'Deleware']); State::create(['abr' => 'DC', 'state' => 'District of Columbia']); State::create(['abr' => 'FL', 'state' => 'Florida']); State::create(['abr' => 'GA', 'state' => 'Georgia']); State::create(['abr' => 'HI', 'state' => 'Hawaii']); State::create(['abr' => 'ID', 'state' => 'Idaho']); State::create(['abr' => 'IL', 'state' => 'Illinois']); State::create(['abr' => 'IN', 'state' => 'Indiana']); State::create(['abr' => 'IA', 'state' => 'Iowa']); State::create(['abr' => 'KS', 'state' => 'Kansas']); State::create(['abr' => 'KY', 'state' => 'Kentucky']); State::create(['abr' => 'LA', 'state' => 'Louisiana']); State::create(['abr' => 'ME', 'state' => 'Maine']); State::create(['abr' => 'MD', 'state' => 'Maryland']); State::create(['abr' => 'MA', 'state' => 'Massachusetts']); State::create(['abr' => 'MI', 'state' => 'Michgan']); State::create(['abr' => 'MN', 'state' => 'Minnesota']); State::create(['abr' => 'MS', 'state' => 'Mississippi']); State::create(['abr' => 'MO', 'state' => 'Missouri']); State::create(['abr' => 'MT', 'state' => 'Montana']); State::create(['abr' => 'NE', 'state' => 'Nebraska']); State::create(['abr' => 'NV', 'state' => 'Nevada']); State::create(['abr' => 'NH', 'state' => 'New Hampshire']); State::create(['abr' => 'NJ', 'state' => 'New Jersey']); State::create(['abr' => 'NM', 'state' => 'New Mexico']); State::create(['abr' => 'NY', 'state' => 'New York']); State::create(['abr' => 'NC', 'state' => 'North Carolina']); State::create(['abr' => 'ND', 'state' => 'North Dakota']); State::create(['abr' => 'OH', 'state' => 'Ohio']); State::create(['abr' => 'OK', 'state' => 'Oklahoma']); State::create(['abr' => 'OR', 'state' => 'Oregon']); State::create(['abr' => 'PA', 'state' => 'Pennsylvania']); State::create(['abr' => 'RI', 'state' => 'Rhode Island']); State::create(['abr' => 'SC', 'state' => 'South Carolina']); State::create(['abr' => 'SD', 'state' => 'South Dakota']); State::create(['abr' => 'TN', 'state' => 'Tennessee']); State::create(['abr' => 'TX', 'state' => 'Texas']); State::create(['abr' => 'UT', 'state' => 'Utah']); State::create(['abr' => 'VT', 'state' => 'Vermont']); State::create(['abr' => 'VA', 'state' => 'Virginia']); State::create(['abr' => 'WA', 'state' => 'Washington']); State::create(['abr' => 'WV', 'state' => 'West Virginia']); State::create(['abr' => 'WI', 'state' => 'Wisconsin']); State::create(['abr' => 'WY', 'state' => 'Wyoming']); State::create(['abr' => 'USA', 'state' => 'United States of America']); }
public function update($id) { // save updated $record = $this->records->find($id); if (!$record) { State::create(Input::all()); return $this->respond($record); } $record->fill(Input::all())->save(); return $this->respond($record); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(Request $request) { $this->validate($request, ['name' => 'required|max:255']); $input = $request->all(); $input['company_id'] = Auth::user()->company_id; $input['user_id'] = Auth::user()->id; $input['account_year_id'] = session('account'); State::create($input); flash()->success('State Created Successfully !'); return redirect('state'); }
/** * Run the database seeds. * * @return void */ public function run() { State::create(['country_id' => '', 'name' => '']); State::create(['country_id' => 859, 'id' => 50, 'name' => 'Republica Dominicana']); State::create(['country_id' => 858, 'id' => 33, 'name' => 'Montevideo']); State::create(['country_id' => 840, 'id' => 34, 'name' => 'Utah']); State::create(['country_id' => 840, 'id' => 43, 'name' => 'San Francisco']); State::create(['country_id' => 724, 'id' => 39, 'name' => 'España']); State::create(['country_id' => 604, 'id' => 44, 'name' => 'Lima']); State::create(['country_id' => 604, 'id' => 47, 'name' => 'Lima']); State::create(['country_id' => 600, 'id' => 42, 'name' => 'Asunción']); State::create(['country_id' => 591, 'id' => 37, 'name' => 'Panamá']); State::create(['country_id' => 484, 'id' => 1, 'name' => 'Aguascalientes']); State::create(['country_id' => 484, 'id' => 2, 'name' => 'Baja California']); State::create(['country_id' => 484, 'id' => 3, 'name' => 'Baja California Sur']); State::create(['country_id' => 484, 'id' => 4, 'name' => 'Campeche']); State::create(['country_id' => 484, 'id' => 5, 'name' => 'Coahuila']); State::create(['country_id' => 484, 'id' => 6, 'name' => 'Colima']); State::create(['country_id' => 484, 'id' => 7, 'name' => 'Chiapas']); State::create(['country_id' => 484, 'id' => 8, 'name' => 'Chihuahua']); State::create(['country_id' => 484, 'id' => 9, 'name' => 'Distrito Federal']); State::create(['country_id' => 484, 'id' => 10, 'name' => 'Durango']); State::create(['country_id' => 484, 'id' => 11, 'name' => 'Guanajuato']); State::create(['country_id' => 484, 'id' => 12, 'name' => 'Guerrero']); State::create(['country_id' => 484, 'id' => 13, 'name' => 'Hidalgo']); State::create(['country_id' => 484, 'id' => 14, 'name' => 'Jalisco']); State::create(['country_id' => 484, 'id' => 15, 'name' => 'México']); State::create(['country_id' => 484, 'id' => 16, 'name' => 'Michoacán']); State::create(['country_id' => 484, 'id' => 17, 'name' => 'Morelos']); State::create(['country_id' => 484, 'id' => 18, 'name' => 'Nayarit']); State::create(['country_id' => 484, 'id' => 19, 'name' => 'Nuevo León']); State::create(['country_id' => 484, 'id' => 20, 'name' => 'Oaxaca']); State::create(['country_id' => 484, 'id' => 21, 'name' => 'Puebla']); State::create(['country_id' => 484, 'id' => 22, 'name' => 'Querétaro']); State::create(['country_id' => 484, 'id' => 23, 'name' => 'Quintana Roo']); State::create(['country_id' => 484, 'id' => 24, 'name' => 'San Luis Potosí']); State::create(['country_id' => 484, 'id' => 25, 'name' => 'Sinaloa']); State::create(['country_id' => 484, 'id' => 26, 'name' => 'Sonora']); State::create(['country_id' => 484, 'id' => 27, 'name' => 'Tabasco']); State::create(['country_id' => 484, 'id' => 28, 'name' => 'Tamaulipas']); State::create(['country_id' => 484, 'id' => 29, 'name' => 'Tlaxcala']); State::create(['country_id' => 484, 'id' => 30, 'name' => 'Veracruz']); State::create(['country_id' => 484, 'id' => 31, 'name' => 'Yucatán']); State::create(['country_id' => 484, 'id' => 32, 'name' => 'Zacatecas']); State::create(['country_id' => 340, 'id' => 38, 'name' => 'Francisco Morazán']); State::create(['country_id' => 320, 'id' => 36, 'name' => 'Guatemala']); State::create(['country_id' => 222, 'id' => 40, 'name' => 'San Salvador']); State::create(['country_id' => 218, 'id' => 49, 'name' => 'Pichincha']); State::create(['country_id' => 188, 'id' => 35, 'name' => 'San José']); State::create(['country_id' => 152, 'id' => 48, 'name' => 'Santiago']); State::create(['country_id' => 76, 'id' => 41, 'name' => 'Brasilia']); }
/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); $filename = base_path('public/nigeria.json'); $data = json_decode(file_get_contents($filename), TRUE); foreach ($data as $key => $value) { $state = State::create(array('state' => $key, 'capital' => $value['capital'], 'population' => $value['population'], 'area' => $value['land_area'], 'nickname' => $value['nick_name'], 'date_created' => $value['date_created'], 'preceding_entity' => $value['preceding_entity'], 'lg_count' => $value['lg_count'])); for ($i = 1; $i < count($value['lga']); $i++) { $lga = Lga::create(array('state_id' => $state->id, 'lg_name' => $value['lga'][$i])); } } // $this->call('UserTableSeeder'); Model::reguard(); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('states', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->timestamps(); }); State::create(['name' => 'En demande']); State::create(['name' => 'En cours de traitement']); State::create(['name' => 'Déjà traité']); State::create(['name' => 'Disponible']); State::create(['name' => 'Hors sujet']); State::create(['name' => 'Fermé']); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('states')->delete(); $json = File::get(storage_path() . '/json/states.json'); $data = json_decode($json); foreach ($data as $k => $v) { if ($k == 'RestResponse') { foreach ($v as $key => $value) { if ($key == 'result') { foreach ($value as $object) { State::create(['country_code' => $object->country, 'state_code' => $object->abbr, 'name' => $object->name, 'capital' => $object->capital]); } } } } } }
/** * Store newly created State in storage. * @param MyConfigRequest $request * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector */ public function storeState(MyConfigRequest $request) { State::create($request->all()); Session::flash('success_message', 'State has been inserted!'); return redirect('config'); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(CreateStateRequest $request) { State::create(Request::all()); return redirect()->route('settings.state.index'); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('states')->truncate(); State::create(['name' => 'Alaska', 'code' => 'AK']); State::create(['name' => 'Alabama', 'code' => 'AL']); State::create(['name' => 'American Samoa', 'code' => 'AS']); State::create(['name' => 'Arizona', 'code' => 'AZ']); State::create(['name' => 'Arkansas', 'code' => 'AR']); State::create(['name' => 'California', 'code' => 'CA']); State::create(['name' => 'Colorado', 'code' => 'CO']); State::create(['name' => 'Connecticut', 'code' => 'CT']); State::create(['name' => 'Delaware', 'code' => 'DE']); State::create(['name' => 'District of Columbia', 'code' => 'DC']); State::create(['name' => 'Federated States of Micronesia', 'code' => 'FM']); State::create(['name' => 'Florida', 'code' => 'FL']); State::create(['name' => 'Georgia', 'code' => 'GA']); State::create(['name' => 'Guam', 'code' => 'GU']); State::create(['name' => 'Hawaii', 'code' => 'HI']); State::create(['name' => 'Idaho', 'code' => 'ID']); State::create(['name' => 'Illinois', 'code' => 'IL']); State::create(['name' => 'Indiana', 'code' => 'IN']); State::create(['name' => 'Iowa', 'code' => 'IA']); State::create(['name' => 'Kansas', 'code' => 'KS']); State::create(['name' => 'Kentucky', 'code' => 'KY']); State::create(['name' => 'Louisiana', 'code' => 'LA']); State::create(['name' => 'Maine', 'code' => 'ME']); State::create(['name' => 'Marshall Islands', 'code' => 'MH']); State::create(['name' => 'Maryland', 'code' => 'MD']); State::create(['name' => 'Massachusetts', 'code' => 'MA']); State::create(['name' => 'Michigan', 'code' => 'MI']); State::create(['name' => 'Minnesota', 'code' => 'MN']); State::create(['name' => 'Mississippi', 'code' => 'MS']); State::create(['name' => 'Missouri', 'code' => 'MO']); State::create(['name' => 'Montana', 'code' => 'MT']); State::create(['name' => 'Nebraska', 'code' => 'NE']); State::create(['name' => 'Nevada', 'code' => 'NV']); State::create(['name' => 'New Hampshire', 'code' => 'NH']); State::create(['name' => 'New Jersey', 'code' => 'NJ']); State::create(['name' => 'New Mexico', 'code' => 'NM']); State::create(['name' => 'New York', 'code' => 'NY']); State::create(['name' => 'North Carolina', 'code' => 'NC']); State::create(['name' => 'North Dakota', 'code' => 'ND']); State::create(['name' => 'Northern Mariana Islands', 'code' => 'MP']); State::create(['name' => 'Ohio', 'code' => 'OH']); State::create(['name' => 'Oklahoma', 'code' => 'OK']); State::create(['name' => 'Oregon', 'code' => 'OR']); State::create(['name' => 'Palau', 'code' => 'PW']); State::create(['name' => 'Pennsylvania', 'code' => 'PA']); State::create(['name' => 'Puerto Rico', 'code' => 'PR']); State::create(['name' => 'Rhode Island', 'code' => 'RI']); State::create(['name' => 'South Carolina', 'code' => 'SC']); State::create(['name' => 'South Dakota', 'code' => 'SD']); State::create(['name' => 'Tennessee', 'code' => 'TN']); State::create(['name' => 'Texas', 'code' => 'TX']); State::create(['name' => 'Utah', 'code' => 'UT']); State::create(['name' => 'Vermont', 'code' => 'VT']); State::create(['name' => 'Virgin Islands', 'code' => 'VI']); State::create(['name' => 'Virginia', 'code' => 'VA']); State::create(['name' => 'Washington', 'code' => 'WA']); State::create(['name' => 'West Virginia', 'code' => 'WV']); State::create(['name' => 'Wisconsin', 'code' => 'WI']); State::create(['name' => 'Wyoming', 'code' => 'WY']); State::create(['name' => 'Armed Forces Africa', 'code' => 'AE']); State::create(['name' => 'Armed Forces Americas (except Canada)', 'code' => 'AA']); State::create(['name' => 'Armed Forces Canada', 'code' => 'AE']); State::create(['name' => 'Armed Forces Europe', 'code' => 'AE']); State::create(['name' => 'Armed Forces Middle East', 'code' => 'AE']); State::create(['name' => 'Armed Forces Pacific', 'code' => 'AP']); }