sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo'';}
$res = $db->query($sql);
if (!$res) {
if ($db->has_errors()) {
echo'DB Errors: (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($db->get_errors());echo'';
}
}
while ($r = $db->fetch($res)) {
foreach ($projTodo[$r->ID_PROJECT] as $kRowId => $vType) {
if ($vType == 'projekt') {
if (isset($this->_data['projekt'][$kRowId])) {
if (!empty($r->L_APPOITMENT_USER)) {
$this->_data['projekt'][$kRowId]->_l_app = $r->L_APPOITMENT_USER;
}
} else {
//echo ''."Error not set \$this->_data['projekt'][$kRowId]".'
'; } } else if ($vType == 'koresp') { if (!empty($r->L_APPOITMENT_USER)) { $this->_data['koresp'][$kRowId]->_l_app = $r->L_APPOITMENT_USER; if (!empty($r->L_APPOITMENT_DATE) && empty($this->_data['koresp'][$kRowId]->_l_app_date)) { //$this->_data['koresp'][$kRowId]->_l_app_date = $r->L_APPOITMENT_DATE; $this->_data['koresp'][$kRowId]->_l_app_date = '0000-00-00'; } } } } } } private function _fetchLAppUsersRec() { $projTodo = array(); $db = DB::getDB(); $loopLimit = $this->_deepRecurseLimit; $firstLoop = true; do { if(V::get('DBG_P', '', $_GET) > 2){echo'loop(' . ($this->_deepRecurseLimit - $loopLimit) . ') start projTodo (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($projTodo);echo'';}
foreach ($this->_data['projekt'] as $kID => $vProj) {
if (empty($vProj->_l_app)) {
if ($vProj->_acl_proj_id > 0) {
if (isset($this->_data['projekt'][$vProj->_acl_proj_id])) {// already fetched from DB
if (!empty($this->_data['projekt'][$vProj->_acl_proj_id]->_l_app)) {
$this->_data['projekt'][$vProj->ID]->_l_app = $this->_data['projekt'][$vProj->_acl_proj_id]->_l_app;
} else {
$this->_data['projekt'][$vProj->ID]->_acl_proj_id = $this->_data['projekt'][$vProj->_acl_proj_id]->_acl_proj_id;
}
} else {
$projTodo[$vProj->_acl_proj_id][$vProj->ID] = 'projekt';
}
} else if (!$vProj->_acl_proj_id) {
//if ($firstLoop) echo ''."Error: Projekt {$vProj->ID} nie ma P_ID ani L_APPOITMENT_USER! Autor: {$vProj->A_RECORD_CREATE_AUTHOR} / {$vProj->A_RECORD_CREATE_DATE}".'
'; $this->_data['projekt'][$kID]->_acl_proj_id = -1;// set error } else if ($vProj->_acl_proj_id < 0) { //if ($firstLoop) echo ''."Error: Projekt {$vProj->ID} ma P_ID = -1, brak L_APPOITMENT_USER! Autor: {$vProj->A_RECORD_CREATE_AUTHOR} / {$vProj->A_RECORD_CREATE_DATE}".'
'; $this->_data['projekt'][$kID]->_acl_proj_id = -1;// set error } } } foreach ($this->_data['koresp'] as $kID => $vKoresp) { if (empty($vKoresp->_l_app)) { if ($vKoresp->_acl_proj_id > 0) { if (!empty($this->_data['projekt'][$vKoresp->_acl_proj_id]->_l_app)) { $this->_data['koresp'][$vKoresp->ID]->_l_app = $this->_data['projekt'][$vKoresp->_acl_proj_id]->_l_app; } else { $this->_data['koresp'][$vKoresp->ID]->_acl_proj_id = $this->_data['projekt'][$vKoresp->_acl_proj_id]->_acl_proj_id; if ($vKoresp->_acl_proj_id > 0) { $projTodo[$vKoresp->_acl_proj_id][$vKoresp->ID] = 'koresp'; } else { //echo ''."Error: brak l_app w projektach dla Koresp {$vKoresp->ID}".'
'; } } } else { //if ($firstLoop) echo ''."Error: Korespondencja {$vKoresp->ID} ma ID_PROJECT = {$vKoresp->_acl_proj_id}, brak L_APPOITMENT_USER! Autor: {$vKoresp->A_RECORD_CREATE_AUTHOR} / {$vKoresp->A_RECORD_CREATE_DATE}".'
'; $this->_data['koresp'][$kID]->_acl_proj_id = -1;// set error } } } if ($firstLoop) $firstLoop = false; if (empty($projTodo)) { if(V::get('DBG_P', '', $_GET) > 2){echo'loop(' . ($this->_deepRecurseLimit - $loopLimit) . ') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r("break loop " . ($this->_deepRecurseLimit - $loopLimit));echo'';}
break;
}
if(V::get('DBG_P', '', $_GET) > 2){echo'loop(' . ($this->_deepRecurseLimit - $loopLimit) . ') $projTodo (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($projTodo);echo'';}
$projIds = array_keys($projTodo);
$sql = "select `ID`, `P_ID`, `L_APPOITMENT_USER`, `L_APPOITMENT_USER`
from `IN7_MK_BAZA_DYSTRYBUCJI`
where `ID` in(" . implode(",", $projIds) . ")
";
if(V::get('DBG_P', '', $_GET) > 2){echo'loop(' . ($this->_deepRecurseLimit - $loopLimit) . ') sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo'';}
$res = $db->query($sql);
if (!$res) {
if ($db->has_errors()) {
echo'DB Errors: (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($db->get_errors());echo'';
}
}
while ($r = $db->fetch($res)) {
//if(V::get('DBG_P', '', $_GET) > 2){echo'loop(' . ($this->_deepRecurseLimit - $loopLimit) . ') r [isset($projTodo[$r->ID]) = '.isset($projTodo[$r->ID]).'] (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($r);echo'';}
foreach ($projTodo[$r->ID] as $kRowId => $vType) {
if ($vType == 'projekt') {
if (isset($this->_data['projekt'][$kRowId])) {
$this->_data['projekt'][$kRowId]->_acl_proj_id = (int)$r->P_ID;
if (!empty($r->L_APPOITMENT_USER)) {
$this->_data['projekt'][$kRowId]->_l_app = $r->L_APPOITMENT_USER;
//if (!empty($r->L_APPOINTMENT_DATE)) {
// $this->_data['projekt'][$kRowId]->_l_app = $r->L_APPOITMENT_USER;
//}
}
} else {
echo ''."Error not set \$this->_data['projekt'][$kRowId]".'
'; } } else if ($vType == 'koresp') { $this->_data['koresp'][$kRowId]->_acl_proj_id = (int)$r->P_ID; if (!empty($r->L_APPOITMENT_USER)) { $this->_data['koresp'][$kRowId]->_l_app = $r->L_APPOITMENT_USER; //if (!empty($r->L_APPOINTMENT_DATE)) { // $this->_data['projekt'][$kRowId]->_l_app = $r->L_APPOITMENT_USER; //} } } } unset($projTodo[$r->ID]); } if(V::get('DBG_P', '', $_GET) > 2){echo'loop(' . ($this->_deepRecurseLimit - $loopLimit) . ') this->_data (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->_data);echo'';}
} while (--$loopLimit);
}
public function getAllowedUsersList() {
$allowedUsers = array();
$db = DB::getDB();
$sql = "select distinct `L_APPOITMENT_USER` from `IN7_MK_BAZA_DYSTRYBUCJI` where `L_APPOITMENT_USER`!='' and `A_STATUS` not in ('OFF_HARD','DELETED') ";
// TODO: $zap_sql = "SELECT DISTINCT `L_APPOITMENT_USER` FROM `IN7_MK_BAZA_DYSTRYBUCJI` WHERE `L_APPOITMENT_USER` != '' and ( A_CLASSIFIED in ('".implode( "','" , $_SESSION['AUTH_LDAP_CLIENT__LDAP_USERS'][$_SESSION['ADM_ACCOUNT']])."') or A_CLASSIFIED='' ) ";
$res = $db->query($sql) or die("blad zapytania do bazy {$sql}");
while ($r = $db->fetch($res)) {
$allowedUsers[$r->L_APPOITMENT_USER] = true;
}
$sql = "select distinct `L_APPOITMENT_USER` from `IN7_DZIENNIK_KORESP` where `L_APPOITMENT_USER`!='' and `A_STATUS` not in ('OFF_HARD','DELETED') ";
//TODO: $zap_sql = "SELECT DISTINCT `L_APPOITMENT_USER` FROM `IN7_DZIENNIK_KORESP` WHERE `L_APPOITMENT_USER` != '' and ( A_CLASSIFIED in ('".implode( "','" , $_SESSION['AUTH_LDAP_CLIENT__LDAP_USERS'][$_SESSION['ADM_ACCOUNT']])."') or A_CLASSIFIED='' ) ; ";
$res = $db->query($sql) or die("blad zapytania do bazy {$sql}");
while ($r = $db->fetch($res)) {
$allowedUsers[$r->L_APPOITMENT_USER] = true;
}
$sql = "select distinct `L_APPOITMENT_USER` from `CRM_PROCES` where `L_APPOITMENT_USER`!='' and `A_STATUS` not in ('OFF_HARD','DELETED') ";
//TODO: $zap_sql = "SELECT DISTINCT `L_APPOITMENT_USER` FROM `IN7_DZIENNIK_KORESP` WHERE `L_APPOITMENT_USER` != '' and ( A_CLASSIFIED in ('".implode( "','" , $_SESSION['AUTH_LDAP_CLIENT__LDAP_USERS'][$_SESSION['ADM_ACCOUNT']])."') or A_CLASSIFIED='' ) ; ";
$res = $db->query($sql) or die("blad zapytania do bazy {$sql}");
while ($r = $db->fetch($res)) {
$allowedUsers[$r->L_APPOITMENT_USER] = true;
}
$sql = "select distinct `L_APPOITMENT_USER` from `CRM_LISTA_ZASOBOW` where `L_APPOITMENT_USER`!='' and `A_STATUS` not in ('OFF_HARD','DELETED') ";
//TODO: $zap_sql = "SELECT DISTINCT `L_APPOITMENT_USER` FROM `IN7_DZIENNIK_KORESP` WHERE `L_APPOITMENT_USER` != '' and ( A_CLASSIFIED in ('".implode( "','" , $_SESSION['AUTH_LDAP_CLIENT__LDAP_USERS'][$_SESSION['ADM_ACCOUNT']])."') or A_CLASSIFIED='' ) ; ";
$res = $db->query($sql) or die("blad zapytania do bazy {$sql}");
while ($r = $db->fetch($res)) {
$allowedUsers[$r->L_APPOITMENT_USER] = true;
}
ksort($allowedUsers);
return $allowedUsers;
}
private function _createCacheTable() {
$db = DB::getDB();
$sql = "CREATE TABLE IF NOT EXISTS `_PRZYPOMNIJ_CACHE` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`ID_PROJECT` int(11) NOT NULL,
`_l_app_user` varchar(40) NOT NULL DEFAULT '',
`P_ID` varchar(20) NOT NULL DEFAULT '0',
`A_RECORD_CREATE_DATE` datetime NOT NULL,
`A_RECORD_CREATE_AUTHOR` varchar(40) NOT NULL DEFAULT '',
`A_RECORD_UPDATE_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`A_RECORD_UPDATE_AUTHOR` varchar(40) NOT NULL DEFAULT '',
`L_APPOITMENT_DATE` varchar(30) NOT NULL DEFAULT '',
`L_APPOITMENT_USER` varchar(40) NOT NULL DEFAULT '',
`L_APPOITMENT_INFO` varchar(200) NOT NULL DEFAULT '',
`L_CALENDAR` enum('NO','YES') NOT NULL DEFAULT 'NO',
`A_STATUS` enum('WAITING','NORMAL','MONITOR','WARNING','OFF_SOFT','OFF_HARD','DELETED') NOT NULL DEFAULT 'WAITING',
`M_DIST_DATE` date NOT NULL DEFAULT '0000-00-00',
`M_DIST_TYPE` varchar(64) NOT NULL DEFAULT 'INNE',
`M_DIST_DESC` varchar(255) NOT NULL DEFAULT '',
`M_DISTRIBUTOR` varchar(200) NOT NULL DEFAULT '',
PRIMARY KEY (`ID`),
KEY `P_ID` (`P_ID`),
KEY `ID_PROJECT` (`ID_PROJECT`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
";
if(V::get('DBG_P', '', $_GET) > 3){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo'';}
$db->query($sql);
}
private function _updateCacheTable() {
$db = DB::getDB();
$sql = "truncate table `_PRZYPOMNIJ_CACHE`; ";
$db->query($sql);
$sql = "insert into `_PRZYPOMNIJ_CACHE` (`ID_PROJECT`,`P_ID`,`_l_app_user`,`L_APPOITMENT_USER`,`L_APPOITMENT_DATE`)
select `ID`,`P_ID`,`L_APPOITMENT_USER`,`L_APPOITMENT_USER`,`L_APPOITMENT_DATE`
from `IN7_MK_BAZA_DYSTRYBUCJI`
where 1=1
";
$db->query($sql);
// test recurse update l_app
$sql = "select c._l_app_user
, p.L_APPOITMENT_USER
, p1.L_APPOITMENT_USER
, p2.L_APPOITMENT_USER
, p3.L_APPOITMENT_USER
, p4.L_APPOITMENT_USER
, p5.L_APPOITMENT_USER
, p.ID
, p1.ID
, p2.ID
, p3.ID
, p4.ID
, p5.ID
from `_PRZYPOMNIJ_CACHE` as c
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p on (p.ID=c.ID_PROJECT)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p1 on (p1.ID=p.P_ID)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p2 on (p2.ID=p1.P_ID)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p3 on (p3.ID=p2.P_ID)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p4 on (p4.ID=p3.P_ID)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p5 on (p5.ID=p4.P_ID)
where c.`_l_app_user`=''
";
// for i to recurse limit
$sql = "update `_PRZYPOMNIJ_CACHE` as c
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p on (p.ID=c.ID_PROJECT)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p1 on (p1.ID=p.P_ID)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p2 on (p2.ID=p1.P_ID)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p3 on (p3.ID=p2.P_ID)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p4 on (p4.ID=p3.P_ID)
left join `IN7_MK_BAZA_DYSTRYBUCJI` as p5 on (p5.ID=p4.P_ID)
set
c.`_l_app_user`=IF(p.`L_APPOITMENT_USER`!='', p.`L_APPOITMENT_USER`
, IF(p1.`L_APPOITMENT_USER`!='', p1.`L_APPOITMENT_USER`
, IF(p2.`L_APPOITMENT_USER`!='', p2.`L_APPOITMENT_USER`
, IF(p3.`L_APPOITMENT_USER`!='', p3.`L_APPOITMENT_USER`
, IF(p4.`L_APPOITMENT_USER`!='', p4.`L_APPOITMENT_USER`
, IF(p5.`L_APPOITMENT_USER`!='', p5.`L_APPOITMENT_USER`
, ''
)
)
)
)
)
)
where c.`_l_app_user`=''
";
$db->query($sql);
}
public function orderByDateAsc($t1, $t2) {
return $this->orderByDate($t1, $t2, true);
}
public function orderByDateDesc($t1, $t2) {
return $this->orderByDate($t1, $t2, false);
}
public function orderByDate($t1, $t2, $asc = true) {
$a = $t1->_l_app_date;
$b = $t2->_l_app_date;
if ($a == $b) {
return 0;
}
if ($asc) {
return ($a > $b)? 1 : -1;
} else {
return ($a < $b)? 1 : -1;
}
}
public function getTasksByDate($asc = true) {
$tasks = array();
foreach ($this->_data as $kType => $vTasks) {
foreach ($vTasks as $kId => $vTask) {
$tasks[] = $vTask;
}
}
if ($asc) {
usort($tasks, array($this, 'orderByDateAsc'));
} else {
usort($tasks, array($this, 'orderByDateDesc'));
}
return $tasks;
}
public function getZasobIdByType($type) {
if (!isset($this->_tblIdCache[$type])) {
$this->_tblIdCache[$type] = null;
$allowedTypes = array('projekt', 'proces', 'koresp');
if (empty($type) || !in_array($type, $allowedTypes)) {
echo 'Rekord ID; ?> typugetFieldIdByName($fieldName); if (!$fieldID) { if ($DBG) echo "404: No field by name ({$fieldName})"; continue; } if ($DBG) echo "fieldID: {$fieldID}\n"; if (!$tblAcl->isAllowed($fieldID, 'R', $row)) { if ($DBG) echo " R not allowed\n"; } else { if ($DBG) echo " R allowed\n"; } if (!$tblAcl->isAllowed($fieldID, 'W', $row)) { if ($DBG) echo " W not allowed\n"; } else { if ($DBG) echo " W allowed\n"; } $fieldVal = ''; if ($tblAcl->isAllowed($fieldID, 'R', $row)) { $fieldVal = V::get($fieldName, $fieldVal, $row); } $fieldVal = V::get("f{$fieldID}", $fieldVal, $_POST); $vCol = $tblAcl->getField($fieldID); $vCol['label'] = (!empty($vCol['label']))? $vCol['label'] : $vCol['name']; $tsValues = array(); Lib::loadClass('Typespecial'); $typeSpecial = Typespecial::getInstance($fieldID, $vCol['name']); if ($typeSpecial) { if($DBG){echo'
Typespecial('.$fieldID.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($typeSpecial);echo'';}
$specialValues = $typeSpecial->getEditSelectedValuesByIds($zasobID, $row->ID, $fieldName, V::get($fieldName, $fieldVal, $row));
if($DBG){echo'Typespecial('.$fieldID.') specialValues (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($specialValues);echo'';}
if (!empty($specialValues)) {
$tsValues[$row->ID] = implode('TODO: save type ('.$type.') ID(' . $rowid . ') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sqlObj);echo'';}
$sqlObj->ID = $row->ID;
$dbID = $tblAcl->getDB();
$db = DB::getDB($dbID);
if (!$db) {
header('HTTP/1.0 406 Not Acceptable');
exit;
}
$tblName = $tblAcl->getName();
$sqlObj->ID = $rowID;
if($DBG){echo'TODO: Save ('.$tblName.') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sqlObj);echo'';}
$allData = array();
$allData['L_APPOITMENT_DATE'] = $sqlObj->L_APPOITMENT_DATE;
$allData['L_APPOITMENT_USER'] = $sqlObj->L_APPOITMENT_USER;
$allData['L_APPOITMENT_INFO'] = $sqlObj->L_APPOITMENT_INFO;
$ret = $db->UPDATE_OBJ($tblName, $sqlObj);
if ($ret > 0) {
echo '