public static function findManyWithConfig($updatedIds) { $pdContractTemplateAttribute = PdContractTemplateAttribute::getTableName(); $pdCodeContractAttribute = PdCodeContractAttribute::getTableName(); $dataSet = PdContractTemplateAttribute::join($pdCodeContractAttribute, "{$pdContractTemplateAttribute}.ATTRIBUTE", '=', "{$pdCodeContractAttribute}.ID")->whereIn("{$pdContractTemplateAttribute}.ID", $updatedIds)->where("{$pdContractTemplateAttribute}.ACTIVE", '=', 1)->select("{$pdContractTemplateAttribute}.ID as DT_RowId", "{$pdContractTemplateAttribute}.ID", "{$pdContractTemplateAttribute}.ID as {$pdCodeContractAttribute}", "{$pdContractTemplateAttribute}.CONTRACT_TEMPLATE", "{$pdContractTemplateAttribute}.ATTRIBUTE", "{$pdCodeContractAttribute}.NAME", "{$pdCodeContractAttribute}.CODE")->get(); return $dataSet; }
function contract_attr($formulaId, $code, $year = '') { global $contractIdGlobal; global $yearGlobal; if ($year != '') { $year = $yearGlobal - 1; $sSQL = " SELECT a.FORMULA_VALUE FROM pd_contract_year a ,pd_contract_calculation b WHERE b.ID = a.CALCULATION_ID AND" . " a.CONTRACT_ID = " . $contractIdGlobal . " AND a.YEAR = '" . $year . "'" . " AND b.FORMULA_ID = '" . $formulaId . "'"; $pdContractYear = PdContractYear::getTableName(); $pdContractCalculation = PdContractCalculation::getTableName(); $contractYear = PdContractYear::join($pdContractCalculation, "{$pdContractYear}.CALCULATION_ID", '=', "{$pdContractCalculation}.ID")->where("{$pdContractYear}.CONTRACT_ID", '=', $contractIdGlobal)->where("{$pdContractYear}.YEAR", '=', $year)->where("{$pdContractCalculation}.FORMULA_ID", '=', $formulaId)->select("{$pdContractYear}.FORMULA_VALUE as ATTRIBUTE_VALUE")->first(); } else { $sSQL = " SELECT ATTRIBUTE_VALUE \n\t\t\t\tFROM pd_code_contract_attribute a\n\t\t\t\t,pd_contract_data b\n\t\t\t\tWHERE b.ATTRIBUTE_ID = a.ID AND" . " b.CONTRACT_ID = " . $contractIdGlobal . " \n\t\t\t\t\t\tAND a.CODE = '" . $code . "'"; $pdContractData = PdContractData::getTableName(); $pdCodeContractAttribute = PdCodeContractAttribute::getTableName(); $contractYear = PdCodeContractAttribute::join($pdContractData, "{$pdContractData}.ATTRIBUTE_ID", '=', "{$pdCodeContractAttribute}.ID")->where("{$pdCodeContractAttribute}.CODE", '=', $code)->where("{$pdContractData}.CONTRACT_ID", '=', $contractIdGlobal)->select("ATTRIBUTE_VALUE")->first(); } /* $result=mysql_query($sSQL) or die("fail: ".$sSQL."-> error:".mysql_error()); while($row=mysql_fetch_array($result)) { return $row['ATTRIBUTE_VALUE']; } */ if ($contractYear) { return $contractYear->ATTRIBUTE_VALUE; } return 0; }
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; }
public function contracttemplate() { $filterGroups = array('productionFilterGroup' => ['Facility' => 'Storage'], 'dateFilterGroup' => array(['id' => 'date_begin', 'name' => 'From date'], ['id' => 'date_end', 'name' => 'To date'])); $contractAttributes = PdCodeContractAttribute::all(); return view('front.contract.contracttemplate', ['filters' => $filterGroups, 'contractAttributes' => $contractAttributes]); }