public function loadData($contractId, $postData) { $pdContractYear = PdContractYear::getTableName(); $pdContractCalculation = PdContractCalculation::getTableName(); $contractYears = PdContractYear::join($pdContractCalculation, "{$pdContractYear}.CALCULATION_ID", '=', "{$pdContractCalculation}.ID")->where("{$pdContractYear}.CONTRACT_ID", '=', $contractId)->select("{$pdContractYear}.FORMULA_VALUE", "{$pdContractYear}.YEAR", "{$pdContractCalculation}.FORMULA_ID")->orderBy("{$pdContractYear}.YEAR", 'desc')->get(); $propertiesArray = [(object) ['data' => 'NAME', 'title' => 'Contract Quantity', 'width' => 150], (object) ['data' => 'DESCRIPTION', 'title' => 'Description', 'width' => 400]]; $pdContractQtyFormula = PdContractQtyFormula::getTableName(); $data = PdContractQtyFormula::select("ID as DT_RowId", "{$pdContractQtyFormula}.*")->get(); $years = $contractYears->groupBy("YEAR"); if ($years->count() > 0) { foreach ($years as $year => $set) { $yearField = "year{$year}"; $propertiesArray[] = (object) ['data' => $yearField, 'title' => "{$year}", 'DATA_METHOD' => 0, 'INPUT_TYPE' => 2]; $formulaGroups = $set->groupBy("FORMULA_ID"); $data = $data->each(function ($item, $key) use($yearField, $formulaGroups) { $item->{$yearField} = $formulaGroups[$item->ID][0]->FORMULA_VALUE; }); } } $properties = collect($propertiesArray); $results['properties'] = $properties; $results['dataSet'] = $data; $results['postData'] = $postData; return $results; }