public function getAllCSDPricing()
{
$returnArr = ["crops" => []];
$slugObj = \App\CrowdsourcedDataProduceTypes::all();
foreach ($slugObj as $cK => $cV) {
$corr = DB::table('csdPrice_csdProduceType')->where('produceType_id', $cV->id)->get();
$priceIDs = [];
foreach ($corr as $k => $v) {
$priceIDs[] = $v->price_id;
}
$prices = DB::table('csdPrices')->select(DB::raw('YEAR(created_at) AS year, priceUnit, stateAbrv, AVG(price) AS price'))->whereIn('id', $priceIDs)->groupBy('stateAbrv')->get();
foreach ($prices as $pK => $pV) {
//$yearArr = date('Y', $pV->created_at);
$year = $pV->year;
$returnArr["units"][$cV->slug] = $pV->priceUnit;
$returnArr["crops"][$year][$cV->slug]["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
