public function run() { DB::table('crops')->delete(); $collection = [['crop' => 'corn', 'name' => 'Corn', 'sort_order' => 1, 'tea' => 750, 'measurement' => 'bu', 'rebate_measurement' => 'bu', 'arm_default_price' => 5.11, 'arm_default_ins_price' => 4.92], ['crop' => 'soybeans', 'name' => 'Soybeans', 'sort_order' => 2, 'tea' => 450, 'measurement' => 'bu', 'rebate_measurement' => 'bu', 'arm_default_price' => 11.0, 'arm_default_ins_price' => 9.699999999999999], ['crop' => 'beansFAC', 'name' => 'Soybeans FAC', 'sort_order' => 3, 'tea' => 450, 'measurement' => 'bu', 'rebate_measurement' => 'bu', 'arm_default_price' => 11.0, 'arm_default_ins_price' => 9.699999999999999], ['crop' => 'sorghum', 'name' => 'Sorghum', 'sort_order' => 4, 'tea' => 375, 'measurement' => 'bu', 'rebate_measurement' => 'bu', 'arm_default_price' => 4.21, 'arm_default_ins_price' => 4.0], ['crop' => 'wheat', 'name' => 'Wheat', 'sort_order' => 9, 'tea' => 360, 'measurement' => 'bu', 'rebate_measurement' => 'bu', 'arm_default_price' => 6.64, 'arm_default_ins_price' => 5.75], ['crop' => 'cotton', 'name' => 'Cotton', 'sort_order' => 5, 'tea' => 540, 'measurement' => 'lb', 'rebate_measurement' => 'lb', 'arm_default_price' => 93, 'arm_default_ins_price' => 90], ['crop' => 'rice', 'name' => 'Rice', 'sort_order' => 6, 'tea' => 750, 'measurement' => 'lb', 'rebate_measurement' => 'bu', 'arm_default_price' => 0.135, 'arm_default_ins_price' => 0.14], ['crop' => 'peanuts', 'name' => 'Peanuts', 'sort_order' => 7, 'tea' => 750, 'measurement' => 'bu', 'rebate_measurement' => 'bu', 'arm_default_price' => 2.3, 'arm_default_ins_price' => 2.8], ['crop' => 'sugarcane', 'name' => 'Sugar Cane', 'sort_order' => 8, 'tea' => 750, 'measurement' => 'ton', 'rebate_measurement' => 'ton', 'arm_default_price' => 0.28, 'arm_default_ins_price' => 0.16], ['crop' => 'sunflowers', 'name' => 'Sunflowers', 'sort_order' => 10, 'tea' => 0, 'measurement' => 'lb', 'rebate_measurement' => 'lb', 'arm_default_price' => 217.4, 'arm_default_ins_price' => 124.22]]; foreach ($collection as $record) { Crop::create($record); } }
public function handle(LoanWasCreated $event) { if ((int) $event->loan->loan_type_id < 4) { return; } $crops = Crop::all(); foreach ($crops as $crop) { Plannedcrop::create(['loan_id' => $event->loan->id, 'crop_id' => $crop->id, 'crop' => $crop->name, 'acres' => 0, 'tea' => (double) getPlannedCropTea($crop->id)]); } }
public function update($id) { // save updated $record = $this->records->find($id); if (!$record) { Crop::create(Input::all()); return $this->respond($record); } $record->fill(Input::all())->save(); return $this->respond($record); }
function getPlannedCrops($loan) { $retro = []; $crops = Crop::get(['id', 'crop', 'name']); // loop and get acres foreach ($crops as $crop) { $newbie = ['id' => $crop->id, 'crop' => $crop->crop, 'name' => $crop->name, 'acres' => (double) getCropAcres($loan->id, $crop->id), 'tea' => (double) getPlannedCropTea($crop->id)]; array_push($retro, $newbie); } return $retro; }
function getAllCropAcres($loanID) { $retro = []; $crops = Crop::get(['id', 'crop']); // loop and get acres foreach ($crops as $crop) { $newbie = ['id' => $crop->id, 'crop' => $crop->crop, 'acres' => (double) getCropAcres($loanID, $crop->id)]; array_push($retro, $newbie); } return $retro; }