query($sql);
while ($r = $db->fetch($res)) {
if ($r->ID_ZASOB > 0) {
$workerToStanowisko[$r->ID][] = $r->ID_ZASOB;
}
unset($r->ID_ZASOB);
$activeWorkers[$r->ID] = $r;
}
}// fetch activeWorkers, workerToStanowisko
{// fetch zasobyStanowiska
$db = DB::getDB();
$sql = "select z.`ID`
, z.`DESC`
from `CRM_LISTA_ZASOBOW` as z
where z.`A_STATUS` in('WAITING', 'NORMAL')
and z.`TYPE` in('STANOWISKO')
";
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$zasobyStanowiska[$r->ID] = $r;
}
}// fetch zasobyStanowiska
{// fetch procesy
$db = DB::getDB();
$sql = "select p.`ID`
, p.`DESC`
from `CRM_PROCES` as p
where p.`A_STATUS` in('WAITING', 'NORMAL')
and p.`TYPE` in('PROCES_INIT')
";
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$procesy[$r->ID] = $r;
}
}// fetch procesy
{// fetch procesToStanowisko
$db = DB::getDB();
$sql = "select w.`ID_PROCES`
, w.`ID_ZASOB`
from `CRM_WSKAZNIK` as w
join `CRM_PROCES` as p on(p.`ID`=w.`ID_PROCES`)
join `CRM_LISTA_ZASOBOW` as z on(z.`ID`=w.`ID_ZASOB`)
where w.`A_STATUS` in('WAITING', 'NORMAL')
and p.`A_STATUS` in('WAITING', 'NORMAL')
and z.`A_STATUS` in('WAITING', 'NORMAL')
";
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$procesToStanowisko[$r->ID_ZASOB][] = $r->ID_PROCES;
}
}// fetch procesToStanowisko
if(V::get('DBG', '', $_GET)) {
echo'activeWorkers (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($activeWorkers);echo'';
echo'workerToStanowisko (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($workerToStanowisko);echo'';
echo'procesy('.count($procesy).') (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($procesy);echo'';
}
?>