public function getDetailData($id, $postData, $properties) { $templateId = $postData['templateId']; $pdContractData = PdContractData::getTableName(); $pdContractTemplateAttribute = PdContractTemplateAttribute::getTableName(); $pdCodeContractAttribute = PdCodeContractAttribute::getTableName(); $pdContractQtyFormula = PdContractQtyFormula::getTableName(); $contractDataSet = PdContractData::join($pdCodeContractAttribute, "{$pdContractData}.ATTRIBUTE_ID", '=', "{$pdCodeContractAttribute}.ID")->leftJoin($pdContractQtyFormula, "{$pdCodeContractAttribute}.FORMULA_ID", '=', "{$pdContractQtyFormula}.ID")->where("{$pdContractData}.CONTRACT_ID", '=', $id)->select("{$pdContractData}.*", "{$pdContractData}.CONTRACT_ID as CONTRACT_ID_INDEX", "{$pdContractData}.ATTRIBUTE_ID as ATTRIBUTE_ID_INDEX", "{$pdCodeContractAttribute}.ID as DT_RowId", "{$pdCodeContractAttribute}.ID as {$pdContractData}", "{$pdCodeContractAttribute}.NAME as CONTRACT_ID", "{$pdCodeContractAttribute}.CODE as ATTRIBUTE_ID", "{$pdCodeContractAttribute}.ID as ID", "{$pdContractQtyFormula}.NAME as FORMULA")->get(); $selects = ["{$pdCodeContractAttribute}.ID as DT_RowId", "{$pdCodeContractAttribute}.ID as {$pdContractData}", "{$pdCodeContractAttribute}.NAME as CONTRACT_ID", "{$pdCodeContractAttribute}.CODE as ATTRIBUTE_ID", "{$pdCodeContractAttribute}.ID", "{$pdCodeContractAttribute}.FORMULA_ID as FORMULA", "{$pdCodeContractAttribute}.ID as ATTRIBUTE_ID_INDEX", "{$pdContractQtyFormula}.NAME as FORMULA", \DB::raw("{$id} as CONTRACT_ID_INDEX")]; foreach ($properties as $property) { $columnName = $property['data']; if ($columnName != 'CONTRACT_ID' && $columnName != 'ATTRIBUTE_ID' && $columnName != 'ID') { $selects[] = \DB::raw("null as {$columnName}"); } } $templateQuery = PdContractTemplateAttribute::join($pdCodeContractAttribute, "{$pdContractTemplateAttribute}.ATTRIBUTE", '=', "{$pdCodeContractAttribute}.ID")->leftJoin($pdContractQtyFormula, "{$pdCodeContractAttribute}.FORMULA_ID", '=', "{$pdContractQtyFormula}.ID")->where("{$pdContractTemplateAttribute}.CONTRACT_TEMPLATE", '=', $templateId)->where("{$pdContractTemplateAttribute}.ACTIVE", '=', 1)->select($selects); // ->get(); $existAttributes = $contractDataSet->pluck('DT_RowId'); if (count($existAttributes) > 0) { $templateQuery->whereNotIn("{$pdCodeContractAttribute}.ID", $existAttributes); } $templateDataSet = $templateQuery->get(); $dataSet = $contractDataSet->merge($templateDataSet); return $dataSet; }
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); }
public static function findManyWithConfig($updatedIds) { $pdContractData = static::getTableName(); $pdCodeContractAttribute = PdCodeContractAttribute::getTableName(); $pdContractQtyFormula = PdContractQtyFormula::getTableName(); $result = PdContractData::join($pdCodeContractAttribute, "{$pdContractData}.ATTRIBUTE_ID", '=', "{$pdCodeContractAttribute}.ID")->leftJoin($pdContractQtyFormula, "{$pdCodeContractAttribute}.FORMULA_ID", '=', "{$pdContractQtyFormula}.ID")->whereIn("{$pdContractData}.ID", $updatedIds)->select("{$pdContractData}.*", "{$pdContractData}.CONTRACT_ID as CONTRACT_ID_INDEX", "{$pdContractData}.ATTRIBUTE_ID as ATTRIBUTE_ID_INDEX", "{$pdCodeContractAttribute}.ID as DT_RowId", "{$pdCodeContractAttribute}.ID as {$pdContractData}", "{$pdCodeContractAttribute}.NAME as CONTRACT_ID", "{$pdCodeContractAttribute}.CODE as ATTRIBUTE_ID", "{$pdCodeContractAttribute}.ID as ID", "{$pdContractQtyFormula}.NAME as FORMULA")->get(); return $result; }