public function run()
{
DB::table('loanpractices')->delete();
//123 NI CORN
Loanpractice::create(['loan_id' => 1, 'farm_id' => 1, 'farmunit_id' => 2, 'crop_id' => 1, 'loancrop_id' => 1, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'SE', 'ins_unit' => 'EU', 'ins_price' => 4.05, 'ins_level' => 75, 'ins_share' => 100, 'aph' => 150, 'ins_premium' => 20, 'acres' => 1000, 'prod_price' => 4.25, 'prod_share' => 100, 'prod_yield' => 161]);
//123 NI BEANS
Loanpractice::create(['loan_id' => 1, 'farm_id' => 1, 'farmunit_id' => 2, 'crop_id' => 2, 'loancrop_id' => 2, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'SE', 'ins_unit' => 'EU', 'ins_price' => 9.619999999999999, 'ins_level' => 80, 'aph' => 50, 'ins_premium' => 20, 'acres' => 1000, 'ins_share' => 80, 'prod_price' => 9.25, 'prod_share' => 80, 'prod_yield' => 50]);
//123 NI COTTON
Loanpractice::create(['loan_id' => 1, 'farm_id' => 1, 'farmunit_id' => 2, 'crop_id' => 6, 'loancrop_id' => 3, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'HPE SE', 'ins_unit' => 'EU', 'ins_price' => 0.63, 'ins_level' => 70, 'aph' => 850, 'ins_premium' => 19.82, 'acres' => 350, 'ins_share' => 80, 'prod_price' => 0.6, 'prod_share' => 80, 'prod_yield' => 842]);
//123 IR COTTON
Loanpractice::create(['loan_id' => 1, 'farm_id' => 1, 'farmunit_id' => 1, 'crop_id' => 6, 'loancrop_id' => 3, 'practice' => 'IR', 'ins_type' => 'RP', 'ins_option' => 'HPE SE', 'ins_unit' => 'EU', 'ins_price' => 0.63, 'ins_level' => 75, 'aph' => 925, 'ins_premium' => 19.82, 'acres' => 1000, 'ins_share' => 80, 'prod_price' => 0.6, 'prod_share' => 80, 'prod_yield' => 912]);
//345 NI COTTON
Loanpractice::create(['loan_id' => 1, 'farm_id' => 2, 'farmunit_id' => 3, 'crop_id' => 6, 'loancrop_id' => 3, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'SE', 'ins_unit' => 'EU', 'ins_price' => 0.63, 'ins_level' => 75, 'aph' => 900, 'ins_premium' => 21.0, 'acres' => 50, 'ins_share' => 100, 'prod_price' => 0.6, 'prod_share' => 100, 'prod_yield' => 889]);
//567 IR COTTON
Loanpractice::create(['loan_id' => 1, 'farm_id' => 3, 'farmunit_id' => 4, 'crop_id' => 6, 'loancrop_id' => 3, 'practice' => 'IR', 'ins_type' => 'RP', 'ins_option' => 'SE', 'ins_unit' => 'EU', 'ins_price' => 0.63, 'ins_level' => 75, 'aph' => 950, 'ins_premium' => 21, 'acres' => 200, 'ins_share' => 100, 'prod_price' => 0.6, 'prod_share' => 100, 'prod_yield' => 943]);
//789 IR COTTON
Loanpractice::create(['loan_id' => 1, 'farm_id' => 4, 'farmunit_id' => 5, 'crop_id' => 6, 'loancrop_id' => 3, 'practice' => 'IR', 'ins_type' => 'RP', 'ins_option' => 'SE', 'ins_unit' => 'EU', 'ins_price' => 0.63, 'ins_level' => 75, 'aph' => 1000, 'ins_premium' => 20, 'acres' => 400, 'ins_share' => 100, 'prod_price' => 0.6, 'prod_share' => 100, 'prod_yield' => 1004]);
//321 NI CORN
Loanpractice::create(['loan_id' => 2, 'farm_id' => 5, 'farmunit_id' => 6, 'crop_id' => 1, 'loancrop_id' => 4, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'SE', 'ins_unit' => 'EU', 'ins_price' => 4.2, 'ins_level' => 75, 'ins_share' => 80, 'aph' => 152, 'ins_premium' => 20, 'acres' => 347.4, 'prod_price' => 4.2, 'prod_share' => 80, 'prod_yield' => 152]);
//321 NI BEANS
Loanpractice::create(['loan_id' => 2, 'farm_id' => 5, 'farmunit_id' => 6, 'crop_id' => 2, 'loancrop_id' => 5, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'SE', 'ins_unit' => 'EU', 'ins_price' => 9.25, 'ins_level' => 80, 'aph' => 50, 'ins_premium' => 20, 'acres' => 1000, 'ins_share' => 80, 'prod_price' => 9.25, 'prod_share' => 80, 'prod_yield' => 50]);
//321 NI COTTON
Loanpractice::create(['loan_id' => 2, 'farm_id' => 5, 'farmunit_id' => 6, 'crop_id' => 6, 'loancrop_id' => 6, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'HPE SE', 'ins_unit' => 'EU', 'ins_price' => 0.63, 'ins_level' => 75, 'aph' => 850, 'ins_premium' => 20.0, 'acres' => 1000, 'ins_share' => 80, 'prod_price' => 0.6, 'prod_share' => 80, 'prod_yield' => 850]);
// 321 NI SORGHUM
Loanpractice::create(['loan_id' => 2, 'farm_id' => 5, 'farmunit_id' => 6, 'crop_id' => 4, 'loancrop_id' => 7, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'HPE SE', 'ins_unit' => 'EU', 'ins_price' => 3.97, 'ins_level' => 75, 'aph' => 135, 'ins_premium' => 20.0, 'acres' => 1000, 'ins_share' => 80, 'prod_price' => 3.25, 'prod_share' => 80, 'prod_yield' => 135]);
//321 NI RICE
Loanpractice::create(['loan_id' => 2, 'farm_id' => 5, 'farmunit_id' => 6, 'crop_id' => 7, 'loancrop_id' => 8, 'practice' => 'NI', 'ins_type' => 'RP', 'ins_option' => 'HPE SE', 'ins_unit' => 'EU', 'ins_price' => 0.11, 'ins_level' => 75, 'aph' => 700, 'ins_premium' => 19.82, 'acres' => 1000, 'ins_share' => 80, 'prod_price' => 0.11, 'prod_share' => 80, 'prod_yield' => 780]);
}
public function acresOfCrop($loanID, $cropID)
{
$acres = Loanpractice::select(DB::raw('SUM(acres) AS acres'))->where('loan_id', $loanID)->where('crop_id', $cropID)->get();
return $this->respond($acres);
}
