public function addyear(Request $request)
{
$postData = $request->all();
$contractId = $postData['PdContract'];
$year = $postData['year'];
$qltyFormulas = PdContractQtyFormula::all();
$formulaValues = \FormulaHelpers::getDataFormulaContract($qltyFormulas, $contractId, $year);
$resultTransaction = \DB::transaction(function () use($qltyFormulas, $formulaValues, $contractId, $year) {
$attributes = ['CONTRACT_ID' => $contractId];
$yAttributes = ['CONTRACT_ID' => $contractId, 'YEAR' => $year];
$yValues = ['CONTRACT_ID' => $contractId, 'YEAR' => $year];
// PdContractYear::where($yAttributes)->delete();
foreach ($qltyFormulas as $key => $qltyFormula) {
$attributes['FORMULA_ID'] = $qltyFormula->ID;
$values = $attributes;
$calculation = PdContractCalculation::updateOrCreate($attributes, $values);
/* $sql = "INSERT INTO pd_contract_calculation(FORMULA_ID,CONTRACT_ID) "
. "VALUE(".$aryRequest['FORMULA_ID'.$id].",".$aryRequest['CONTRACT_ID'].")"; */
$formulaValue = (int) $formulaValues[$qltyFormula->ID];
$yAttributes['CALCULATION_ID'] = $calculation->ID;
$yValues['CALCULATION_ID'] = $calculation->ID;
$yValues['FORMULA_VALUE'] = $formulaValue;
$contractYear = PdContractYear::updateOrCreate($yAttributes, $yValues);
/* $val = (int) $aryValue[$formulaId[$key]]; // abc($id,$contractId) se thay bang cong thuc
$sql2 = "INSERT INTO pd_contract_year(CALCULATION_ID,YEAR,FORMULA_VALUE,CONTRACT_ID) VALUE($id,$year,'$val',$contractId)";
$sql2=str_replace("''", "NULL", $sql2); */
}
});
$results = $this->loadData($contractId, $postData);
return response()->json($results);
}
