public function run() { DB::table('inspols')->delete(); $policies = [['loan_id' => 1, 'agent_id' => 1, 'county_id' => 1317, 'crop_id' => 1, 'practice' => 'NI', 'plc' => false, 'type' => 'RP', 'unit' => 'EU', 'options' => 'PFSE', 'ins_level' => 70, 'planting_days' => 0, 'ins_price' => 4.25, 'ins_share' => 80, 'premium' => 11.88, 'stax_loss_trigger' => 0, 'stax_desired_range' => 0, 'stax_protection_factor' => 0], ['loan_id' => 1, 'agent_id' => 1, 'county_id' => 1317, 'crop_id' => 2, 'practice' => 'NI', 'plc' => false, 'type' => 'RP', 'unit' => 'EU', 'options' => 'SE', 'ins_level' => 70, 'planting_days' => 0, 'ins_price' => 11.25, 'ins_share' => 80, 'premium' => 14.35, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 1, 'agent_id' => 1, 'county_id' => 1317, 'crop_id' => 6, 'practice' => 'NI', 'plc' => true, 'type' => 'RP', 'unit' => 'EU', 'options' => 'STAX', 'ins_level' => 70, 'ins_share' => 80, 'planting_days' => 0, 'ins_price' => 0.63, 'premium' => 19.82, 'exp_yield' => 858, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 1, 'agent_id' => 1, 'county_id' => 1317, 'crop_id' => 1, 'practice' => 'IR', 'plc' => false, 'type' => 'YP', 'unit' => 'EU', 'options' => 'PFSE', 'ins_level' => 70, 'ins_share' => 80, 'planting_days' => 0, 'ins_price' => 4.25, 'exp_yield' => 858, 'premium' => 11.88, 'stax_loss_trigger' => 0, 'stax_desired_range' => 0, 'stax_protection_factor' => 0], ['loan_id' => 1, 'agent_id' => 1, 'county_id' => 1317, 'crop_id' => 6, 'practice' => 'IR', 'plc' => false, 'type' => 'RPHPE', 'unit' => 'EU', 'options' => 'SCO', 'ins_level' => 70, 'ins_share' => 80, 'planting_days' => 0, 'ins_price' => 0.63, 'exp_yield' => 1192, 'premium' => 19.82, 'exp_yield' => 858, 'stax_loss_trigger' => 90, 'stax_desired_range' => 35, 'stax_protection_factor' => 120], ['loan_id' => 1, 'agent_id' => 2, 'county_id' => 1310, 'crop_id' => 1, 'practice' => 'NI', 'plc' => false, 'type' => 'RPHPE', 'unit' => 'EU', 'options' => 'SE', 'ins_level' => 75, 'ins_share' => 100, 'planting_days' => 0, 'ins_price' => 4.25, 'exp_yield' => 1192, 'premium' => 11.88, 'stax_loss_trigger' => 0, 'stax_desired_range' => 0, 'stax_protection_factor' => 0], ['loan_id' => 1, 'agent_id' => 2, 'county_id' => 1310, 'crop_id' => 2, 'practice' => 'NI', 'plc' => false, 'type' => 'RPHPE', 'unit' => 'EU', 'options' => 'SE', 'ins_level' => 70, 'planting_days' => 0, 'ins_price' => 11.25, 'ins_share' => 100, 'exp_yield' => 1192, 'premium' => 14.35, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 1, 'agent_id' => 2, 'county_id' => 1310, 'crop_id' => 6, 'practice' => 'NI', 'plc' => true, 'type' => 'RPHPE', 'unit' => 'EU', 'options' => 'SCO', 'ins_level' => 70, 'ins_share' => 80, 'planting_days' => 0, 'ins_price' => 0.63, 'premium' => 19.82, 'exp_yield' => 1142, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 1, 'agent_id' => 2, 'county_id' => 1310, 'crop_id' => 1, 'practice' => 'IR', 'plc' => false, 'type' => 'YP', 'unit' => 'EU', 'options' => 'SE', 'ins_level' => 75, 'ins_share' => 80, 'planting_days' => 0, 'ins_price' => 4.25, 'premium' => 11.88, 'stax_loss_trigger' => 0, 'stax_desired_range' => 0, 'stax_protection_factor' => 0], ['loan_id' => 1, 'agent_id' => 2, 'county_id' => 1310, 'crop_id' => 2, 'practice' => 'IR', 'plc' => false, 'type' => 'YP', 'unit' => 'EU', 'options' => 'SE', 'ins_level' => 70, 'planting_days' => 0, 'ins_price' => 11.25, 'ins_share' => 80, 'premium' => 14.35, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 1, 'agent_id' => 2, 'county_id' => 1310, 'crop_id' => 6, 'practice' => 'IR', 'plc' => true, 'type' => 'RP', 'unit' => 'EU', 'options' => 'SCO', 'ins_level' => 70, 'ins_share' => 80, 'planting_days' => 0, 'ins_price' => 0.63, 'exp_yield' => 1142, 'premium' => 19.82, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 2, 'agent_id' => 2, 'county_id' => 1317, 'crop_id' => 6, 'practice' => 'NI', 'plc' => true, 'type' => 'RP', 'unit' => 'EU', 'options' => 'STAX', 'ins_level' => 70, 'ins_share' => 80, 'planting_days' => 0, 'ins_price' => 0.63, 'premium' => 19.82, 'exp_yield' => 858, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 2, 'agent_id' => 2, 'county_id' => 1317, 'crop_id' => 1, 'practice' => 'NI', 'plc' => false, 'type' => 'RP', 'unit' => 'EU', 'options' => 'PFSE', 'ins_level' => 70, 'planting_days' => 0, 'ins_price' => 4.25, 'ins_share' => 80, 'premium' => 11.88, 'stax_loss_trigger' => 0, 'stax_desired_range' => 0, 'stax_protection_factor' => 0], ['loan_id' => 2, 'agent_id' => 2, 'county_id' => 1317, 'crop_id' => 2, 'practice' => 'NI', 'plc' => false, 'type' => 'RP', 'unit' => 'EU', 'options' => 'SE', 'ins_level' => 70, 'planting_days' => 0, 'ins_price' => 11.25, 'ins_share' => 80, 'premium' => 14.35, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 2, 'agent_id' => 2, 'county_id' => 1317, 'crop_id' => 4, 'practice' => 'NI', 'plc' => false, 'type' => 'RP', 'unit' => 'EU', 'options' => 'SE', 'ins_level' => 75, 'planting_days' => 0, 'ins_price' => 3.97, 'ins_share' => 80, 'premium' => 20.0, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120], ['loan_id' => 2, 'agent_id' => 2, 'county_id' => 1317, 'crop_id' => 7, 'practice' => 'NI', 'plc' => false, 'type' => 'RP', 'unit' => 'EU', 'options' => 'SE', 'ins_level' => 75, 'planting_days' => 0, 'ins_price' => 0.1125, 'ins_share' => 80, 'premium' => 20.0, 'stax_loss_trigger' => 90, 'stax_desired_range' => 15, 'stax_protection_factor' => 120]]; foreach ($policies as $policy) { Inspol::create($policy); } }
public function update($id) { // save updated $record = $this->records->find($id); if (!$record) { Inspol::create(Input::all()); return $this->respond($record); } $record->fill(Input::all())->save(); return $this->respond($record); }