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