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