1260 -> IN7_DZIENNIK_KORESP.ID_PROJECT
* PARAM_OUT
* DANE ALIAS do komórki z innej tabeli
*
*** TODO: new struct, TODO: remove above
* TYPESPECIAL
* PARAM_OUT format: dla PARAM_IN = vcol pokzać listę, a dla PARAM_IN = col i perm W pokazać select/search
* PARAM_IN alias do komórki dla której ma się pokazać PARAM_OUT
* DANE alias do komórki/zmiennej z danymi do podstawienia
* PARAM_WHERE sql params - join tables
*
* $_SESSION['Typespecial_Cache'] = array(
* map = array(
* fieldID => typesiecialID
* ),
* typesiecialID => Typespecial Data
* )
*
* Typespecial types:
* - typespecial function for form fields in edit, create
* - typespecial view function for virtual fields
*
* $_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SRC_COLUMN']['INTERNET_STATUS']="temp_USERS2_INTERNET_STATUS";
* $_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['TRG_COLUMN']['INTERNET_STATUS']="temp_USERS2_INTERNET_STATUS.USERS2_INTERNET_STATUS";
* $_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['INTERNET_STATUS']="temp_USERS2_INTERNET_STATUS.USERS2_INTERNET_STATUS";
* $_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['JOINQUERY']['temp_USERS2_INTERNET_STATUS']="LEFT JOIN temp_USERS2_INTERNET_STATUS as temp_USERS2_INTERNET_STATUS on temp_USERS2_INTERNET_STATUS.S_ADDRESS_STREET=USERS2_MARKETING.S_ADDRESS_STREET ";
*
* used `CRM_LISTA_ZASOBOW`.`TYPE`:
'TYPESPECIAL'
'PARAM_IN'
'PARAM_OUT'
'PARAM_WHERE'
'SQL_LIKE' => "`fld` LIKE '{param}'"
'SQL_LIKE_PR' => "`fld` LIKE '%{param}%'"
'SQL_NOT_LIKE' => "`fld` NOT LIKE '{param}'"
'SQL_EQUAL' => "`fld`='{param}'"
'SQL_NOT_EQUAL' => "`fld`!='{param}'"
'SQL_IS_EMPTY' => "`fld`=''"
'SQL_IS_NOT_EMPTY' => "`fld`!=''"
'SQL_IS_NULL' => "`fld` IS NULL"
'SQL_IS_NOT_NULL' => "`fld` IS NOT NULL"
'SQL_IN' => "`fld` IN({params})"
'SQL_NOT_IN' => "`fld` NOT IN({params})"
'SQL_BETWEEN' => "`fld` BETWEEN {params1} AND {params2}"
'SQL_NOT_BETWEEN' => "`fld` NOT BETWEEN {params1} AND {params2}"
*
*
'TYPESPECIAL','PARAM_IN','PARAM_OUT','PARAM_WHERE','SQL_LIKE','SQL_LIKE_PR','SQL_NOT_LIKE','SQL_EQUAL','SQL_NOT_EQUAL','SQL_IS_EMPTY','SQL_IS_NOT_EMPTY','SQL_IS_NULL','SQL_IS_NOT_NULL','SQL_IN','SQL_NOT_IN','SQL_BETWEEN','SQL_NOT_BETWEEN'
'KONTO-KSIEGOWE-OLD','KONTO-KSIEGOWE-ZESPOL','KONTO-KSIEGOWE','KONTO-KSIEGOWE-GRUPA','DANE','WYNIK_ZAPYTANIA','NARZEDZIE','PLIK','ZASOB_PLIKOW','TABELA','KOMORKA','BAZA_DANYCH','DATABASE_MYSQL','TRIGGER','SERWER','SERWER_PORT','DOKUMENTY','MAGAZYN','SEGREGATOR','POMIESZCZENIE','MATERIAL_REKLAMOWY','DZIAL','STANOWISKO','INNE','CZYNNOSC','PODMIOT','ALARM-SATEL','DOSTEP-ZAMEK','DOSTEP-KLUCZ','NOTATKA','URZADZENIE','TELBOX','SZAFA','REJESTRATOR','KAMERA','PIECZATKA','URL','URL_REQUEST_RESPOND','TYPESPECIAL','PARAM_IN','PARAM_OUT','PARAM_WHERE','SQL_LIKE','SQL_LIKE_PR','SQL_NOT_LIKE','SQL_EQUAL','SQL_NOT_EQUAL','SQL_IS_EMPTY','SQL_IS_NOT_EMPTY','SQL_IS_NULL','SQL_IS_NOT_NULL','SQL_IN','SQL_NOT_IN','SQL_BETWEEN','SQL_NOT_BETWEEN',''
*/
class Typespecial extends TypespecialBase {
public $fldID;
public $param_out;
public $filters;
public $fldAliasList;
public $tblAliasList;
public $sqlQuery;
private $_fldName;// @use getFieldName()
public function __construct($fldID, $fldName = '', $cacheData = array()) {
$this->fldID = $fldID;
$this->param_out = V::get('param_out', null, $cacheData);
$this->sqlQuery = V::get('sqlQuery', null, $cacheData);
$this->tblAliasList = V::get('tblAliasList', null, $cacheData);
if(V::get('DBG_TS', 0, $_GET) > 3){echo'Typespecial cacheData (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($cacheData);echo' ';}
$this->_fldName = $fldName;
}
public function validate() {
// TODO: validate cache data
// TODO: check if has parse errors
// TODO: try to run sql and check if has error
return true;
}
/**
* @returns virtual fields id list
*/
public static function initFields($fieldIds) {
if (empty($fieldIds)) {
return;
}
$db = DB::getDB();
$typeSpecials = array();
$sql = "select z.`ID`
, z.`ALIAS_ID` as fieldID
, zpp.`ID` as TYPE_ID
from `CRM_LISTA_ZASOBOW` as z
join `CRM_LISTA_ZASOBOW` as zp on(zp.`ID`=z.`PARENT_ID`)
join `CRM_LISTA_ZASOBOW` as zpp on(zpp.`ID`=zp.`PARENT_ID`)
where zpp.`TYPE`='TYPESPECIAL'
and zpp.`A_STATUS` in('WAITING','NORMAL')
and zp.`TYPE`='PARAM_OUT'
and z.`TYPE`='PARAM_IN'
and z.`ALIAS_ID` in(" . implode(",", $fieldIds) . ")
";
if(V::get('DBG_TS', 0, $_GET) > 0){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo' ';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$r->params_out = array();
$r->filters = array();
$typeSpecials[$r->TYPE_ID] = $r;
$typeSpecials_2[$r->fieldID] = $r;
$_SESSION['Typespecial_Cache']['map'][$r->fieldID] = $r->TYPE_ID;
$_SESSION['Typespecial_Cache']['map_param_out'][$r->fieldID] = $r->TYPE_ID;
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'typeSpecials (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($typeSpecials);echo' ';}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'typeSpecials_2 (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($typeSpecials_2);echo' ';}
if (empty($typeSpecials)) {
return;
}
$sql = "select z.`ID`
, z.`ALIAS_ID`
, z.`TYPE`
, z.`DESC`
, za.`DESC` as ALIAS_DESC
, za.`PARENT_ID` as ALIAS_PARENT_ID
, zp.`ID` as PARAM_ID
, zp.`ALIAS_ID` as ALIAS_ID_RETURN
, zp.`DESC` as PARAM_DESC
, zp.`PARENT_ID` as TYPE_ID
, zp.`TYPE` as TYPE_TYPE
, za.`TYPE` as ALIAS_TYPE
from `CRM_LISTA_ZASOBOW` as z
join `CRM_LISTA_ZASOBOW` as zp on(zp.`ID`=z.`PARENT_ID`)
left join `CRM_LISTA_ZASOBOW` as za on(za.`ID`=z.`ALIAS_ID`)
where zp.`TYPE` in('PARAM_OUT', 'PARAM_WHERE')
and z.`TYPE` not in('PARAM_IN')
and zp.`PARENT_ID` in(" . implode(",", array_keys($typeSpecials)) . ")
";
if(V::get('DBG_TS', 0, $_GET) > 0){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo' ';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
if ($r->TYPE_TYPE == 'PARAM_OUT') {
$typeSpecials[$r->TYPE_ID]->params_out[$r->PARAM_ID][] = $r;
}
else {
if (!array_key_exists($r->PARAM_ID, $typeSpecials[$r->TYPE_ID]->filters)) {
/*
(
[ID] => 4526
[ALIAS_ID] => 1123
[TYPE] => DANE
[DESC] => IN
[ALIAS_DESC] => A_STATUS
[PARAM_ID] => 4531
[ALIAS_ID_RETURN] => 0
[PARAM_DESC] => AND
[TYPE_ID] => 4519
[TYPE_TYPE] => PARAM_WHERE
)
*/
$typeSpecials[$r->TYPE_ID]->filters[$r->PARAM_ID] = new stdClass();
$typeSpecials[$r->TYPE_ID]->filters[$r->PARAM_ID]->filtersByID = array();
$typeSpecials[$r->TYPE_ID]->filters[$r->PARAM_ID]->treeFlat = array();
$typeSpecials[$r->TYPE_ID]->filters[$r->PARAM_ID]->ID = $r->PARAM_ID;
$typeSpecials[$r->TYPE_ID]->filters[$r->PARAM_ID]->ALIAS_ID = $r->ALIAS_ID_RETURN;
$typeSpecials[$r->TYPE_ID]->filters[$r->PARAM_ID]->PARAM_DESC = $r->PARAM_DESC;
$typeSpecials[$r->TYPE_ID]->filters[$r->PARAM_ID]->FLTR_ID = $r->ID;
}
$param = new stdClass();
$param->ID = $r->ID;
$param->PARENT_ID = 0;
$param->ALIAS_ID = $r->ALIAS_ID;
$param->ALIAS_PARENT_ID = $r->ALIAS_PARENT_ID;
$param->ALIAS_TYPE = $r->ALIAS_TYPE;
$param->TYPE = $r->TYPE;
$param->DESC = $r->DESC;
$param->ALIAS_DESC = $r->ALIAS_DESC;
$typeSpecials[$r->TYPE_ID]->filters[$r->PARAM_ID]->filtersByID[$r->ID] = $param;
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'typeSpecials (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($typeSpecials);echo' ';}
$typeSpecialsByField = array();// table, db info
$aliasesMap = array();
$filtersByField = array();// filters info
// create sql by params, filters
/*
[ID] => 4527
[ALIAS_ID] => 0
[TYPE] => DANE
[DESC] => NORMAL
[ALIAS_DESC] =>
[PARAM_ID] => 4526
[PARAM_DESC] => IN
[TYPE_ID] => 4519
[TYPE_TYPE] => DANE
*/
foreach ($typeSpecials as $kTypeID => $vType) {
$typeSpecialsByField[$vType->fieldID] = new Typespecial($vType->fieldID);
$params = $vType->params_out;
foreach ($params as $kParamID => $vParams) {
$vParam = reset($vParams);
$typeSpecialsByField[$vType->fieldID]->param_out = new stdClass();
$typeSpecialsByField[$vType->fieldID]->param_out->format = $vParam->PARAM_DESC;
$typeSpecialsByField[$vType->fieldID]->param_out->retID = $vParam->ALIAS_ID_RETURN;
$typeSpecialsByField[$vType->fieldID]->param_out->values = array();
$typeSpecialsByField[$vType->fieldID]->param_out->alias = array();
$typeSpecialsByField[$vType->fieldID]->param_out->exports = array();
}
foreach ($params as $kParamID => $vParams) {
foreach ($vParams as $vParam) {
if ($vParam->TYPE == 'PARAM_EXPORT') {
$typeSpecialsByField[$vType->fieldID]->param_out->exports[$vParam->ALIAS_ID] = $vParam->DESC;
} else {
$typeSpecialsByField[$vType->fieldID]->param_out->values[$vParam->DESC] = $vParam->ALIAS_ID;
$typeSpecialsByField[$vType->fieldID]->param_out->alias[$vParam->ALIAS_ID] = $vParam->ALIAS_DESC;
}
}
}
foreach ($typeSpecialsByField[$vType->fieldID]->param_out->alias as $kParam => $vParam) {
$aliasesMap[$kParam] = $vParam;
}
$filters = $vType->filters;
foreach ($filters as $kFilterID => $vFilters) {
$typeSpecialsByField[$vType->fieldID]->filters[$kFilterID] = $vFilters;
}
}
{// fetch filters recursive
if(V::get('DBG_TS', 0, $_GET) > 0){echo'typeSpecialsByField update by filtersTodoIds (F.' . __FUNCTION__ . ':' . __LINE__ . '): '."\n";}
$filtersTodoIds = array();
foreach ($typeSpecialsByField as $kFldID => $vType) {
if (!empty($vType->filters)) {
foreach ($vType->filters as $kFltrID => $vFltr) {
foreach ($vFltr->filtersByID as $kId => $v) {
$filtersTodoIds[$kId] = array('type' => $kFldID, 'filter' => $kFltrID);
}
}
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo "filtersTodoIds: [" . implode(",", array_keys($filtersTodoIds)) . "]\n";}
$deepLimit = 3;
for ($i = 0; $i < $deepLimit; $i++) {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "loop i({$i}) filtersTodoIds[" . implode(",", array_keys($filtersTodoIds)) . "] \n";}
if (empty($filtersTodoIds)) {
break;
}
$newFiltersTodoIds = array();
$sql = "select z.`ID`
, z.`ALIAS_ID`
, z.`TYPE`
, z.`DESC`
, z.`PARENT_ID`
, za.`DESC` as ALIAS_DESC
, za.`TYPE` as ALIAS_TYPE
, za.`PARENT_ID` as ALIAS_PARENT_ID
from `CRM_LISTA_ZASOBOW` as z
left join `CRM_LISTA_ZASOBOW` as za on(za.`ID`=z.`ALIAS_ID`)
where
z.`PARENT_ID` in(" . implode(",", array_keys($filtersTodoIds)) . ")
";
if(V::get('DBG_TS', 0, $_GET) > 0){echo'sql (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo' ';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$fltr = $filtersTodoIds[$r->PARENT_ID];
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\tr: {" . json_encode($r) . "}\n";}
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\t\tfltr: {" . json_encode($fltr) . "}\n";}
$typeSpecialsByField[$fltr['type']]->filters[$fltr['filter']]->filtersByID[$r->ID] = $r;
$newFiltersTodoIds[$r->ID] = array('type' => $fltr['type'], 'filter' => $fltr['filter']);
if ($r->ALIAS_ID > 0) {
$aliasesMap[$r->ALIAS_ID] = $r->ALIAS_DESC;
}
}
$filtersTodoIds = $newFiltersTodoIds;
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo ' ';}
}
foreach ($typeSpecialsByField as $kFieldID => $vType) {
$vType->filters = Typespecial::convertFilters($vType->filters);
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'typeSpecialsByField (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($typeSpecialsByField);echo' ';}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'aliasesMap (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($aliasesMap);echo' ';}
$sqlTables = array();
if (!isset($_SESSION['Typespecial_Cache']['sqlTablesInfo'])) $_SESSION['Typespecial_Cache']['sqlTablesInfo'] = array();
$sql = "select z.`ID`
, z.`PARENT_ID`
, z.`ALIAS_ID`
, z.`TYPE`
, z.`DESC`
, zp.`ID` as TBL_ID
, zp.`PARENT_ID` as DB_ID
, zp.`DESC` as TBL_NAME
-- , zpp.`ID` as DB_ID
-- , zpp.`DESC` as DB_DESC
from `CRM_LISTA_ZASOBOW` as z
join `CRM_LISTA_ZASOBOW` as zp on(zp.`ID`=z.`PARENT_ID`)
-- join `CRM_LISTA_ZASOBOW` as zpp on(zpp.`ID`=zp.`PARENT_ID`)
where zp.`TYPE`='TABELA'
and z.`TYPE`='KOMORKA'
-- and zpp.`TYPE` in('DATABASE', 'DATABASE_MYSQL')
and z.`ID` in(" . implode(",", array_keys($aliasesMap)) . ")
";
if(V::get('DBG_TS', 0, $_GET) > 0){echo'sql (C.' . __CLASS__ . ':C.' . __CLASS__ . ':F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo' ';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$_SESSION['Typespecial_Cache']['sqlTablesInfo'][$r->ID] = (object)array('tbl_id'=>$r->TBL_ID, 'db_id'=>$r->DB_ID, 'tbl_name'=>$r->TBL_NAME);
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'sqlTablesInfo (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_SESSION['Typespecial_Cache']['sqlTablesInfo']);echo' ';}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'typeSpecialsByField update by sqlTablesInfo (F.' . __FUNCTION__ . ':' . __LINE__ . '): '."\n";}
foreach ($typeSpecialsByField as $kFieldID => $vType) {
if(V::get('DBG_TS', 0, $_GET) > 0){ echo "loop: {$kFieldID}\n";}
$vType->fldAliasList = array();// [tblID][fldID] = fldName
$vType->tblAliasList = array();
foreach ($vType->param_out->values as $kName => $vZasobID) {
if(V::get('DBG_TS', 0, $_GET) > 0){ echo "\t value: {$kName}=>{$vZasobID} (" . (array_key_exists($vZasobID, $_SESSION['Typespecial_Cache']['sqlTablesInfo'])) . ") \n";}
if (array_key_exists($vZasobID, $_SESSION['Typespecial_Cache']['sqlTablesInfo'])) {
$vTbl = $_SESSION['Typespecial_Cache']['sqlTablesInfo'][$vZasobID];
if(V::get('DBG_TS', 0, $_GET) > 0){ echo "\t\t tbl({$vTbl->tbl_id}:{$vTbl->tbl_name}), db({$vTbl->db_id}) (info: " . '' . json_encode($vTbl) . ' ' . ") \n";}
$vType->fldAliasList[$vTbl->tbl_id][$vZasobID] = $aliasesMap[$vZasobID];
$vType->tblAliasList[$vTbl->tbl_id] = $vTbl->tbl_name;
}
}
// TODO: add tblAliasList, fldAliasList by filters (PARAM_WHERE)
if (!empty($vType->filters)) foreach ($vType->filters as $kFltr => $vFltrs) {
foreach ($vFltrs->filtersByID as $kFltrId => $vFltr) {
if ($vFltr->ALIAS_ID > 0) {
$vZasobID = $vFltr->ALIAS_ID;
if (array_key_exists($vZasobID, $_SESSION['Typespecial_Cache']['sqlTablesInfo'])) {
$vTbl = $_SESSION['Typespecial_Cache']['sqlTablesInfo'][$vZasobID];
if(V::get('DBG_TS', 0, $_GET) > 0){ echo "\t\t filters tbl({$vTbl->tbl_id}:{$vTbl->tbl_name}), db({$vTbl->db_id}) (info: " . '' . json_encode($vTbl) . ' ' . ") \n";}
if (!empty($aliasesMap[$vZasobID])) {
$vType->fldAliasList[$vTbl->tbl_id][$vZasobID] = $aliasesMap[$vZasobID];
}
$vType->tblAliasList[$vTbl->tbl_id] = $vTbl->tbl_name;
}
}
}
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo' ';}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'typeSpecialsByField-2 (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($typeSpecialsByField);echo' ';}
foreach ($typeSpecialsByField as $kFieldID => $vType) {
$vType->buildSqlQuery();
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'typeSpecialsByField-3 (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($typeSpecialsByField);echo' ';}
foreach ($typeSpecialsByField as $kFieldID => $vType) {
$vType->saveCache();
}
return array_keys($typeSpecialsByField);
}
public static function convertFilters($filters) {
if (empty($filters)) {
return $filters;
}
foreach ($filters as $kFltrID => $vFltrRoot) {
foreach ($vFltrRoot->filtersByID as $vFltr) {
$vFltrRoot->treeFlat[$vFltr->PARENT_ID][] = $vFltr->ID;
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){ echo'filters (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($filters);echo' ';}
return $filters;
}
private function buildSqlWhere($fltrRoot, $fltr) {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "buildSqlWhere({$fltr->ID}) {" . json_encode($fltr) . "}\n";}
if (in_array($fltr->TYPE, array('SQL_IN', 'SQL_NOT_IN'))) {
$sqlValues = array();
foreach ($fltrRoot->treeFlat[$fltr->ID] as $vFltrID) {
$vFltr = $fltrRoot->filtersByID[$vFltrID];
$sqlValues[] = "'{$vFltr->DESC}'";
}
if (!empty($sqlValues)) {
$sqlSign = 'in';
if ($fltr->TYPE == 'SQL_NOT_IN') {
$sqlSign = 'not in';
}
return "`t_{$fltr->ALIAS_PARENT_ID}`.`{$fltr->ALIAS_DESC}` {$sqlSign}(" . implode(", ", $sqlValues) . ")";
} else {
return null;// TODO: add parse error - use in validate
}
}
else if ($fltr->TYPE == 'SQL_EQUAL') {
if(V::get('DBG_TS', 0, $_GET) > 0){print_r($fltrRoot);echo "\n";}
$sqlValues = array();
if (count($fltrRoot->treeFlat[$fltr->ID]) == 1) {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_EQUAL count(" . count($fltrRoot->treeFlat[$fltr->ID]) . ") < 2\n";}
foreach ($fltrRoot->filtersByID as $vFltr) {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: [" . reset($fltrRoot->treeFlat[0]) . "] vFltr=";print_r($vFltr);}
if ($vFltr->ALIAS_ID > 0) {
$sqlValues[] = "`t_{$vFltr->ALIAS_PARENT_ID}`.`{$vFltr->ALIAS_DESC}`";
} else if (!empty($vFltr->DESC)) {
$sqlValues[] = "'{$vFltr->DESC}'";
}
}
}
else {
foreach ($fltrRoot->treeFlat[$fltr->ID] as $vFltrID) {
$vFltr = $fltrRoot->filtersByID[$vFltrID];
// TODO: $vFltr->TYPE == 'PARAM_IN' - use like {fltr_name} and add to special fields in sql to generate by given data
$sqlValues[] = "`t_{$vFltr->ALIAS_PARENT_ID}`.`{$vFltr->ALIAS_DESC}`";
}
}
if (count($sqlValues) == 2) {
return "{$sqlValues[0]}={$sqlValues[1]}";
} else if (count($sqlValues) > 2) {// TODO: multiple '='
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_EQUAL count(sqlValues) > 2\n";}
return null;
} else {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_EQUAL count(sqlValues) < 2\n";}
return null;// TODO: add parse error - use in validate
}
}
else if ($fltr->TYPE == 'SQL_LIKE') {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_LIKE\n";print_r($fltrRoot);echo "\n";}
$fltrs = array();
$fltrs[] = $fltr;
foreach ($fltrRoot->treeFlat[$fltr->ID] as $vFltrID) {
$vFltr = $fltrRoot->filtersByID[$vFltrID];
$fltrs[] = $vFltr;
}
if (count($fltrs) == 2) {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_LIKE count(fltrs) == 1; fltrs = ";print_r($fltrs);echo"\n";}
$sqlValues = array();
foreach ($fltrs as $vFltr) {
if ($vFltr->ALIAS_TYPE == 'KOMORKA') {
$sqlValues[] = "`t_{$vFltr->ALIAS_PARENT_ID}`.`{$vFltr->ALIAS_DESC}`";
} else if ($vFltr->ALIAS_TYPE == 'VARIABLE') {
switch ($vFltr->ALIAS_DESC) {
case 'ADM_COMPANY':
$sqlValues[] = "'{$_SESSION['ADM_COMPANY']}'";
break;
default:
}
} else {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_LIKE unknown ALIAS_DESC ($vFltr->ALIAS_DESC) \n";}
}
}
if (count($sqlValues) == 2) {
$sql = "{$sqlValues[0]} LIKE {$sqlValues[1]}";
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_LIKE count(sqlValues) == 2; return {$sql}\n";}
return $sql;
} else {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_LIKE count(sqlValues) != 2\n";}
return null;// TODO: add parse error - use in validate
}
} else {
if(V::get('DBG_TS', 0, $_GET) > 0){echo "\nTODO: SQL_LIKE count(fltrs) != 2\n";}
return null;// TODO: add parse error - use in validate
}
}
return null;// TODO: add parse error - use in validate
}
/**
* Create sql query by given filters
*
* @requires before $this->convertFilters();
* @uses $this->filters
* @uses $this->fldAliasList
* @uses $this->buildSqlWhere($vFltrRoot, $fltr);
*/
public function buildSqlQuery() {
$this->sqlQuery = new stdClass();
$this->sqlQuery->select = array();
$this->sqlQuery->form = array();
$this->sqlQuery->where = '';
$this->sqlQuery->orderBy = '';
$this->sqlQuery->limit = '';
foreach ($this->fldAliasList as $kTblID => $vFields) {
$this->sqlQuery->form[] = "`{$this->tblAliasList[$kTblID]}` as t_{$kTblID}";
foreach ($vFields as $kFldID => $vFldName) {
$this->sqlQuery->select[] = "`t_{$kTblID}`.`{$vFldName}` as f_{$kFldID}";
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'buildSqlWhere by filters (F.' . __FUNCTION__ . ':' . __LINE__ . '): '."\n";}
$sql_where_and = array();
if (!empty($this->filters)) {
foreach ($this->filters as $kFltrID => $vFltrRoot) {
foreach ($vFltrRoot->treeFlat[0] as $fltrID) {
$fltr = $vFltrRoot->filtersByID[$fltrID];//$vFltrRoot->FLTR_ID];
if(V::get('DBG_TS', 0, $_GET) > 0){echo "kFltrID: {$kFltrID} fltrID({$fltr->ID})\n";}
$sqlPart = $this->buildSqlWhere($vFltrRoot, $fltr);
if ($sqlPart) {
$sql_where_and[] = $sqlPart;
}
}
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo' ';}
$sql_where = (!empty($sql_where_and))? implode("\n and ", $sql_where_and) : "1=1";
$this->sqlQuery->where = $sql_where;
}
public function getFieldName() {
if (empty($this->_fldName)) {
$db = DB::getDB();
$sql = "select z.`DESC` from `CRM_LISTA_ZASOBOW` as z where z.`ID`='{$this->fldID}' ";
$res = $db->query($sql);
if ($r = $db->fetch($res)) {
$this->_fldName = $r->DESC;
}
}
return $this->_fldName;
}
/*
* TODO: RMME - use Typeahead plugin
*/
public function showFormItem__OLD($tblID, $fName, $selValue = '', $params = array(), $record = null) {
$out = '';
//if(V::get('DBG_TS', 0, $_GET) > 1){echo'showFormItem (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r(array('tblID'=>$tblID,'fName'=>$fName,'selValue'=>$selValue));echo' ';}
// TODO: set value = $selValue to typespecial search field to load data from ajax?
$tsValue = V::get('typespecialValue', '', $params);
if (!empty($selValue) && !empty($tsValue)) {
$tsValue = "{$selValue}: {$tsValue}";
}
$out = '
';
return $out;
}
public function showFormItem($tblID, $fName, $selValue = '', $params = array(), $record = null) {
$out = '';
$jsonAllowCreate = 'true';
switch ($this->getFieldName()) {
case 'L_APPOITMENT_USER':
case 'T_TELBOX_NEIGHBOUR_IN_ID':
case 'CRM_LISTA_ZASOBOW_ID':
case 'ID_ZASOB':
case 'ID_BILLING_USERS':
case 'ID_PROJECT':
case 'ID_DEVICE':
$jsonAllowCreate = 'false';
break;
default:
$jsonAllowCreate = 'true';
}
$tsValue = V::get('typespecialValue', '', $params);
if (!empty($selValue) && !empty($tsValue)) {
//$tsValue = "{$selValue}: {$tsValue}";
}
$optionsJson = 'null';
$out .= '';
$out .= '';
if (!empty($selValue)) {
$tsSelectedItemLabel = (!empty($tsValue))? $tsValue : $selValue;
//$out .= '' . $tsSelectedItemLabel . ' ';
{// fix prefix
$prefix = "{$selValue}";
$prefixLen = strlen($prefix);
if (strlen($tsSelectedItemLabel) > $prefixLen && $prefix != substr($tsSelectedItemLabel, 0, $prefixLen)) {
if (' ' == substr($tsSelectedItemLabel, 0, 1)) {
$tsSelectedItemLabel = "{$prefix}{$tsSelectedItemLabel}";
} else {
$tsSelectedItemLabel = "{$prefix}: {$tsSelectedItemLabel}";
}
}
}
$out .= '' . $tsSelectedItemLabel . ' ';
$optionsJson = new stdClass();
$optionsJson->id = $selValue;
$optionsJson->name = $tsSelectedItemLabel;
$optionsJson = array($optionsJson);
$optionsJson = json_encode($optionsJson);
}
$out .= ' ';
$out .= '
';
$out .= '';
return $out;
}
public function _getValues($query) {
$rows = array();
$db = DB::getDB();// TODO: get from DB by zasoby ID
if(V::get('DBG_TS', 0, $_GET) > 1){echo'sqlTablesInfo (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_SESSION['Typespecial_Cache']['sqlTablesInfo']);echo' ';}// TODO: RMME
if(V::get('DBG_TS', 0, $_GET) > 1){echo'this (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this);echo' ';}// TODO: RMME
$query = trim($query);
$sqlWhereAdd = "";
if (!empty($query)) {
$qArr = array();
$queryArr = explode(' ', $query);
foreach ($queryArr as $q) {
$q = trim($q);
if (!empty($q)) {
$qArr[] = $q;
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'qArr (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($qArr);echo' ';}// TODO: RMME
if (!empty($qArr)) {
$sqlWhereAnd = array();
foreach ($qArr as $q) {
$dbQ = $db->_($q);
if (is_numeric($dbQ)) {
$dbQ = "{$dbQ}%";
} else {
$dbQ = "%{$dbQ}%";
}
$sqlWhereOr = array();
foreach ($this->param_out->alias as $fldID => $fldName) {
$tblInfo = V::get($fldID, null, $_SESSION['Typespecial_Cache']['sqlTablesInfo']);
if ($tblInfo) {
$sqlWhereOr[] = "`t_{$tblInfo->tbl_id}`.`{$fldName}` like '{$dbQ}'";
}
}
if (!empty($sqlWhereOr)) {
$sqlWhereAnd[] = "(" . implode(" or ", $sqlWhereOr) . ")";
}
}
if (!empty($sqlWhereAnd)) {
$sqlWhereAdd = " and (" . implode(" and ", $sqlWhereAnd) . ")";
}
}
}
$sqlLimit = V::get('limit', 0, $this->sqlQuery, 'int');
if ($sqlLimit <= 0) {
$sqlLimit = 20;
}
$sqlLimit = "limit {$sqlLimit}";
$sql = "select " . implode("\n\t\t,", $this->sqlQuery->select) . "
from " . implode(", ", $this->sqlQuery->form) . "
where {$this->sqlQuery->where}
{$sqlWhereAdd}
{$sqlLimit}
";
if(V::get('DBG_TS', 0, $_GET) > 0){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo' ';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$retID = V::get("f_{$this->param_out->retID}", '', $r);
$rows[$retID] = $r;
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'rows (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($rows);echo' ';}
return $rows;
}
public function getValues($query) {
$rows = $this->_getValues($query);
if(V::get('DBG_TS', 0, $_GET) > 0){echo'param_out (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->param_out);echo' ';}
{// convert param_out
$format = $this->param_out->format;
foreach ($this->param_out->values as $kFldName => $vFldID) {
$format = str_replace("{{$kFldName}}", "{f_{$vFldID}}", $format);
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'format (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($format);echo' ';}
}
$rows_out = array();
foreach ($rows as $ind => $r) {
$row_out = $format;
foreach ($r as $kFldName => $vVal) {
$row_out = str_replace("{{$kFldName}}", "{$vVal}", $row_out);
}
$rows_out[$ind] = $row_out;
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'rows_out (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($rows_out);echo' ';}
return $rows_out;
}
public function getValuesWithExports($query) {
$rows = $this->_getValues($query);
if(V::get('DBG_TS', 0, $_GET) > 0){echo'param_out (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->param_out);echo' ';}
{// convert param_out
$format = $this->param_out->format;
foreach ($this->param_out->values as $kFldName => $vFldID) {
$format = str_replace("{{$kFldName}}", "{f_{$vFldID}}", $format);
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'format (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($format);echo' ';}
}
$retObjList = array();
foreach ($rows as $ind => $r) {
$vObj = new stdClass();
$vObj->id = $ind;
$vObj->param_out = $format;
foreach ($r as $kFldName => $vVal) {
$vObj->param_out = str_replace("{{$kFldName}}", "{$vVal}", $vObj->param_out);
}
if (!empty($this->param_out->exports)) {
$vObj->exports = array();
foreach ($this->param_out->exports as $kExportID => $vExportOut) {
$vObj->exports[$kExportID] = new stdClass();
foreach ($this->param_out->values as $kFldName => $vFldID) {
$vExportOut = str_replace("{{$kFldName}}", "{f_{$vFldID}}", $vExportOut);
}
foreach ($r as $kFldName => $vVal) {
$vExportOut = str_replace("{{$kFldName}}", "{$vVal}", $vExportOut);
}
$vObj->exports[$kExportID] = $vExportOut;
}
}
$retObjList[$ind] = $vObj;
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'retObjList (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($retObjList);echo' ';}
return $retObjList;
}
public function getEditSelectedValuesByIds($tblId, $rowId, $fieldName, $fieldValue = '') {
$rows = array();
$db = DB::getDB();// TODO: get from DB by zasoby ID
if(V::get('DBG_TS', 0, $_GET) > 1){echo'args (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r(array('tblId'=>$tblId, 'rowId'=>$rowId, 'fieldName'=>$fieldName, 'fieldValue'=>$fieldValue));echo' ';}// TODO: RMME
if(V::get('DBG_TS', 0, $_GET) > 1){echo'sqlTablesInfo (tblId:'.$tblId.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_SESSION['Typespecial_Cache']['sqlTablesInfo']);echo' ';}// TODO: RMME
if(V::get('DBG_TS', 0, $_GET) > 1){echo'this->tblAliasList (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->tblAliasList);echo' ';}// TODO: RMME
if(V::get('DBG_TS', 0, $_GET) > 1){echo'this (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this);echo' ';}// TODO: RMME
$retFldName = '';
$sqlWhereAdd = array();
$tblFound = null;
foreach ($_SESSION['Typespecial_Cache']['sqlTablesInfo'] as $vTblInfo) {
if ($vTblInfo->tbl_id == $tblId) {
$tblFound = $vTblInfo;
break;
}
}
if (!$tblFound) {
$db = DB::getDB();
$sql = "select z.`ID` as tbl_id
, z.`PARENT_ID` as db_id
, z.`DESC` as tbl_name
from `CRM_LISTA_ZASOBOW` as z
where z.`ID`={$tblId}
";
$res = $db->query($sql);
if ($r = $db->fetch($res)) {
$tblFound = $r;
if(V::get('DBG_TS', 0, $_GET) > 1){echo'Found 2 tblFound ('.$tblId.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($tblFound);echo' ';}// TODO: RMME
}
}
if (!$tblFound) {
if(V::get('DBG_TS', 0, $_GET) > 1){echo'No tblFound! ('.$tblId.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_SESSION['Typespecial_Cache']['sqlTablesInfo']);echo' ';}// TODO: RMME
return false;
}
//echo'$vTblInfo (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($vTblInfo);echo' ';
$sqlFrom = $this->sqlQuery->form;
$sqlSelect = $this->sqlQuery->select;
if ($this->param_out->retID > 0) {
$sqlWhereAdd[] = "`tr_{$tblId}`.`ID`={$rowId}";
if (array_key_exists($this->param_out->retID, $_SESSION['Typespecial_Cache']['sqlTablesInfo'])) {
$retTblId = $_SESSION['Typespecial_Cache']['sqlTablesInfo'][$this->param_out->retID]->tbl_id;
$retName = $this->param_out->alias[$this->param_out->retID];
$sqlWhereAdd[] = "`t_{$retTblId}`.`{$retName}`=`tr_{$tblId}`.`{$fieldName}`";
} else {
return false;
}
$sqlSelect[] = "`tr_{$tblId}`.`ID`";
$sqlFrom[] = "`{$tblFound->tbl_name}` as tr_{$tblFound->tbl_id}";
$retFldName = "f_{$this->param_out->retID}";
$foundInSelect = false;
foreach ($sqlSelect as $vSelectStr) {
if (false !== strpos($vSelectStr, $retFldName)) {
$foundInSelect = true;
}
}
if (!$foundInSelect) $retFldName = '';
}
else {// if no retID then TYPESPECIAL is link
$sqlWhereAdd[] = "`t_{$tblId}`.`ID`={$rowId}";
$sqlSelect[] = "`t_{$tblId}`.`ID`";
}
$sqlWhereAdd = (!empty($sqlWhereAdd))? " and " . implode(" and ", $sqlWhereAdd) : "";
$sqlLimit = V::get('limit', 0, $this->sqlQuery, 'int');
if ($sqlLimit <= 0) {
$sqlLimit = 20;
}
$sqlLimit = "limit {$sqlLimit}";
$sqlFrom = implode(", ", $sqlFrom);
$sql = "select " . implode("\n\t\t,", $sqlSelect) . "
from {$sqlFrom}
where {$this->sqlQuery->where}
{$sqlWhereAdd}
{$sqlLimit}
";
if(V::get('DBG_TS', 0, $_GET) > 0){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo' ';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$rows[] = $r;
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'rows (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($rows);echo' ';}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'param_out (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->param_out);echo' ';}
{// convert param_out
$format = $this->param_out->format;
foreach ($this->param_out->values as $kFldName => $vFldID) {
$format = str_replace("{{$kFldName}}", "{f_{$vFldID}}", $format);
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'format (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($format);echo' ';}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'retFldName:'.$retFldName.' (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($rows);echo' ';}
$rowsOut = array();
foreach ($rows as $r) {
$rowOut = $format;
foreach ($r as $kFldName => $vVal) {
$rowOut = str_replace("{{$kFldName}}", "{$vVal}", $rowOut);
}
if ($retFldName) {
$rowsOut[$r->{$retFldName}] = $rowOut;
} else {
$rowsOut[] = $rowOut;
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'rowsOut (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($rowsOut);echo' ';}
return $rowsOut;
}
public function getValuesByIds($tblId, $ids) {
$rows = array();
$db = DB::getDB();// TODO: get from DB by zasoby ID
if(V::get('DBG_TS', 0, $_GET) > 1){echo'sqlTablesInfo (tblId:'.$tblId.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_SESSION['Typespecial_Cache']['sqlTablesInfo']);echo' ';}// TODO: RMME
if(V::get('DBG_TS', 0, $_GET) > 1){echo'this->tblAliasList (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->tblAliasList);echo' ';}// TODO: RMME
if(V::get('DBG_TS', 0, $_GET) > 1){echo'this (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this);echo' ';}// TODO: RMME
$sqlWhereAdd = array();
$tblFound = null;
foreach ($_SESSION['Typespecial_Cache']['sqlTablesInfo'] as $vTblInfo) {
if ($vTblInfo->tbl_id == $tblId) {
$tblFound = $vTblInfo;
break;
}
}
if (!$tblFound) {
return false;
}
$sqlWhereAdd[] = "`t_{$tblId}`.`ID` in(" . implode(",", $ids) . ")";
$sqlWhereAdd = (!empty($sqlWhereAdd))? " and " . implode(" and ", $sqlWhereAdd) : "";
$sqlLimit = V::get('limit', 0, $this->sqlQuery, 'int');
if ($sqlLimit <= 0) {
$sqlLimit = 20;
}
$sqlLimit = "limit {$sqlLimit}";
$sql = "select " . implode("\n\t\t,", $this->sqlQuery->select) . "
, `t_{$tblId}`.`ID`
from " . implode(", ", $this->sqlQuery->form) . "
where {$this->sqlQuery->where}
{$sqlWhereAdd}
{$sqlLimit}
";
if(V::get('DBG_TS', 0, $_GET) > 0){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo' ';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$rows[$r->ID][] = $r;
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'rows (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($rows);echo' ';}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'param_out (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->param_out);echo' ';}
{// convert param_out
$format = $this->param_out->format;
foreach ($this->param_out->values as $kFldName => $vFldID) {
$format = str_replace("{{$kFldName}}", "{f_{$vFldID}}", $format);
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'format (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($format);echo' ';}
}
$rowsOut = array();
foreach ($rows as $id => $vRows) {
foreach ($vRows as $r) {
$rowOut = $format;
foreach ($r as $kFldName => $vVal) {
$rowOut = str_replace("{{$kFldName}}", "{$vVal}", $rowOut);
}
$rowsOut[$id][] = $rowOut;
}
}
if(V::get('DBG_TS', 0, $_GET) > 0){echo'rowsOut (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($rowsOut);echo' ';}
return $rowsOut;
}
public function getTblAliasList() {
return $this->tblAliasList;
}
public static function getCache() {
if (!array_key_exists('Typespecial_Cache', $_SESSION)) {
$_SESSION['Typespecial_Cache'] = array();
}
return $_SESSION['Typespecial_Cache'];
}
private function saveCache() {
if(V::get('DBG_TS', 0, $_GET) > 3){echo'Typespecial_Cache (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_SESSION['Typespecial_Cache']);echo' ';}
$typeSpecialID = $_SESSION['Typespecial_Cache']['map'][$this->fldID];
$_SESSION['Typespecial_Cache'][$typeSpecialID] = array('param_out'=>$this->param_out, 'sqlQuery'=>$this->sqlQuery, 'tblAliasList'=>$this->tblAliasList);
}
public static function getInstance($fieldID, $colName) {
if(V::get('DBG_TS', 0, $_GET) > 2){echo'Typespecial('.$fieldID.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($colName);echo' ';}
if (!empty($colName)) {
Lib::loadClass('Config');
$LIB_CLASS_NAME_PREFIX = Config::get('LIB_CLASS_NAME_PREFIX');
if (!empty($LIB_CLASS_NAME_PREFIX)) {
$clsName = "{$LIB_CLASS_NAME_PREFIX}_TypespecialVariable";
if (Lib::tryLoadClass($clsName)) {
//$typeSpecial = $clsName::getInstance($fieldID, $colName);
$typeSpecial = call_user_func(array($clsName, 'getInstance'), $fieldID, $colName);
if ($typeSpecial) {
return $typeSpecial;
}
}
}
Lib::loadClass('TypespecialVariable');
if(V::get('DBG_TS', 0, $_GET) > 2){echo'Typespecial2('.$fieldID.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($colName);echo' ';}
$typeSpecial = TypespecialVariable::getInstance($fieldID, $colName);
if(V::get('DBG_TS', 0, $_GET) > 2){echo'Typespecial('.$fieldID.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($typeSpecial);echo' ';}
if ($typeSpecial) {
return $typeSpecial;
}
}
$cache = self::getCache();
$map = V::get('map', '', $cache);
if (!empty($map) && array_key_exists($fieldID, $map)) {
$typespecialID = $map[$fieldID];
if (array_key_exists($typespecialID, $cache)) {
$typeSpecial = new Typespecial($fieldID, $colName, $cache[$typespecialID]);
if ($typeSpecial->validate()) {
return $typeSpecial;
}
}
}
return null;
}
public function getReturnId() {
if (!isset($this->param_out)) return null;
if (!isset($this->param_out->retID)) return null;
return $this->param_out->retID;
}
public function getReturnData($tblId, $rowId, $fieldName) {
if (!isset($this->param_out)) return null;
if (!isset($this->param_out->retID)) return null;
if ($this->param_out->retID <= 0) return null;
$retData = new stdClass();
$retData->tbl_id = 0;
$retData->fld_name = null;
$retData->tbl_name = null;
$retData->tbl_label = null;
$spValues = $this->getEditSelectedValuesByIds($tblId, $rowId, $fieldName, '');
if(V::get('DBG_TS', 0, $_GET) > 1){echo'getEditSelectedValuesByIds (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($spValues);echo' ';}
if (empty($spValues)) return null;
$itemsJson = array();
foreach ($spValues as $kID => $val) {
$itemJson = new stdClass();
$itemJson->id = $kID;
$itemJson->label = $val;
$itemsJson[] = $itemJson;
}
if (empty($itemsJson)) return null;
$retData->items = $itemsJson;
$db = DB::getDB();
$sql = "select z.`ID`
, z.`DESC` as fld_name
, tbl.`ID` as tbl_id
, tbl.`DESC` as tbl_name
, tbl.`DESC_PL` as tbl_label
from `CRM_LISTA_ZASOBOW` as z
join `CRM_LISTA_ZASOBOW` tbl on (tbl.`ID`=z.`PARENT_ID`)
where
z.`ID`='{$this->param_out->retID}'
and z.`TYPE`='KOMORKA'
and tbl.`TYPE`='TABELA'
";
if(V::get('DBG_TS', 0, $_GET) > 2){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo' ';}
$res = $db->query($sql);
if ($r = $db->fetch($res)) {
$retData->fld_name = $r->fld_name;
$retData->tbl_id = $r->tbl_id;
$retData->tbl_name = $r->tbl_name;
$retData->tbl_label = $r->tbl_label;
}
if(V::get('DBG_TS', 0, $_GET) > 1){echo'retData (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($retData);echo' ';}
if ($retData->tbl_id > 0) {
return $retData;
}
return null;
}
}