public function getCSDPricing($year, $cropSlug)
{
$returnArr = ["crops" => [$year => [$cropSlug => []]]];
$cropObj = \App\CrowdsourcedDataProduceTypes::findBySlug($cropSlug);
$corr = DB::table('csdPrice_csdProduceType')->where('produceType_id', $cropObj->id)->whereRaw('YEAR(created_at) = "' . $year . '"')->get();
$priceIDs = [];
foreach ($corr as $k => $v) {
$priceIDs[] = $v->price_id;
}
$prices = DB::table('csdPrices')->select(DB::raw('stateAbrv, AVG(price) AS price'))->whereIn('id', $priceIDs)->groupBy('stateAbrv')->get();
foreach ($prices as $pK => $pV) {
$returnArr["crops"][$year][$cropSlug]["US-" . $pV->stateAbrv] = round($pV->price, 2);
}
return json_encode($returnArr);
}
<div class="ibox-content">
<div class="row">
<div class="col-lg-8">
<div id="world-map" style="width: 100%; height: 460px">
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Year</label>
<select class="form-control" id="yearSelector">
<option value="2015">2015</option>
</select>
</div>
<div class="form-group">
<label>Crop</label>
<select class="form-control" id="cropSelector">
<option value="" selected="selected">Select a crop</option>
<?php
$crops = \App\CrowdsourcedDataProduceTypes::all();
foreach ($crops as $crop => $value) {
echo '<option value="' . $value->slug . '">' . $value->produceName . '</option>';
}
?>
</select>
</div>
</div>
</div>
</div>
</div>
<div id="tester"></div>
@stop
