'; echo''.$r->DEST.'
'; echo''.$r->A_CREATE_DATE.'
'; echo''.DB_Image::show_size($r->SIZE).' '.$r->WIDTH.'x'.$r->HEIGHT.'
'; echo'
';
echo "Error wrong ID";
echo'
';
//echo App::link();// TODO: link do ???
echo'
'."Usunieto zdjecie ID=".$req['ID'].'
'; } else { $erros[] = ''."Wystapil blad podczas usuwania zdjecia ID=".$req['ID'].'
'; } } } // check if a file was submitted if (!isset($_FILES['userfile'])) { //echo 'Please select a file
'; } else { $errors = DB_Image::uploadImage($remote_table, $remote_id, $_FILES['userfile']); // give praise and thanks to the php gods if (empty($errors)) { $msgs[] = 'Thank you for submitting
'; } else { $msgs[] = '' . "Sorry, could not upload file:" . '
' . implode('
', $errors) .'
'."Brak obrazkow".'
'; } else { echo'| ';
echo''.$r->NAME.' '; echo''.$r->DEST.' '; echo''.$r->A_CREATE_DATE.' '; echo''.DB_Image::show_size($r->SIZE).' '.$r->WIDTH.'x'.$r->HEIGHT.' '; echo' | ';
echo'
| '; echo''; echo''; echo' | '; echo'
cnf (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($cnf);echo''; } if (!empty($cnf)) { $external_ids = array(); foreach ($cnf as $k_table_name => $v_cnf) { $cur_cnf = new stdClass(); $cur_cnf->id_col = V::get('id_col', 'ID', $v_cnf); $cur_cnf->search_col = V::get('search_col', 'CRM_LISTA_ZASOBOW_ID', $v_cnf); $cur_cnf->search_col_regex = V::get('search_col_regex', '', $v_cnf); $sql_id_col = $cur_cnf->id_col; $sql_where = ""; if ($cur_cnf->search_col_regex) { $sql_where = "`{$cur_cnf->search_col}` like '".str_replace('$ID', $zasob->ID, $cur_cnf->search_col_regex)."'"; } else { $sql_where = "`{$cur_cnf->search_col}`='{$zasob->ID}'"; } $sql = "select t.`ID`, {$sql_id_col} as id_col from `{$k_table_name}` as t where {$sql_where} "; if($DBG){ echo'
sql (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo''; } $db = DB::getDB(); $res = $db->query($sql); while ($r = $db->fetch($res)) { if ('ID' != $sql_id_col) { $external_ids[] = "{$r->ID}({$r->id_col})"; } else { $external_ids[] = "{$r->id_col}"; } } } } $out_link = ''; if (empty($external_ids)) { $out_link = ''."Brak danych".''; } else { $out_link = implode(', ', $external_ids); } echo ''; /* $cnf_ids_tabl_TODO_MOVE_TO_CONFIG=array('REWIR'=>'MK_Rewiry', 'URZADZENIE'=>'DEVICES','DOSTEP-ZAMEK-ELEKTRONICZNY'=>'DEVICES', 'OZNACZENIE_LOKALIZACJI'=>'DEVICES', 'APLIKACJA'=>'DEVICES', 'SOFTWARE'=>'DEVICES', 'ALARM-SATEL'=>'DEVICES', 'SZAFA'=>'DEVICES', 'SEJF'=>'DEVICES', 'SEGREGATOR'=>'DEVICES', 'KUWETA'=>'DEVICES', 'NARZEDZIE'=>'DEVICES', 'DOSTEP-KLUCZ'=>'DEVICES', 'DOSTEP-KARTA'=>'DEVICES', 'DOSTEP-ZAMEK'=>'DEVICES', 'MATERIAL_REKLAMOWY'=>'DEVICES', 'SERWER'=>'DEVICES', 'MATERIAL_EKSPLOATACYJNY'=>'DEVICES', 'PIECZATKA'=>'DEVICES', 'PLYTA_CD'=>'DEVICES', 'KOMPUTER'=>'DEVICES', 'URZADZENIA_I_OZNACZENIA_BHP'=>'DEVICES', 'LOKALIZACJA'=>'TELBOXES', 'OBSZAR'=>'TELBOXES', 'POLKA'=>'TELBOXES', 'MAGAZYN'=>'TELBOXES', 'POMIESZCZENIE'=>'TELBOXES', 'SZAFA'=>'TELBOXES', 'DOKUMENTY'=>'IN7_DZIENNIK_KORESP', 'DOSTEP-UPRAWNIENIA'=>'REMOTE_ACCESS_ACCOUNTS','SHARED_IMAP_MAILBOX'=>'REMOTE_ACCESS_ACCOUNTS', 'PODMIOT'=>'BILLING_OWNER', 'PROJEKT'=>'IN7_MK_BAZA_DYSTRYBUCJI','SPRAWA'=>'IN7_MK_BAZA_DYSTRYBUCJI', 'SERVICE_POINT'=>'USERS2_MARKETING','LOKALIZACJA_USLUGI'=>'USERS2_MARKETING', 'OFFER_GROUP'=>'USERS2_OFFERS_GROUPS', 'OFFER'=>'USERS2_OFFERS', 'OFFER_COSTS_GROUP'=>'USERS2_OFFERS_COSTS_GROUPS', 'OFFER_COST'=>'USERS2_OFFERS_COSTS', 'SES_PROCESY5_A'=>'SES_PROCESY5_A' ); */ require_once 'php_classes_ajax_php__cnf_ids_tabl.php'; echo $out_link; echo " "; if( $cnf_ids_tabl_TODO_MOVE_TO_CONFIG[$zasob->TYPE]) { echo App::link("dodaj", "index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=".ProcesHelper::getZasobTableID($cnf_ids_tabl_TODO_MOVE_TO_CONFIG[$zasob->TYPE])."&ff_A_STATUS=WAITING&ff_T_DEVICE_SERIAL=".date('Y-m-d')."-".$zasob->ID."&ff_T_DEVICE_INFO=".urlencode($zasob->OPIS)."&ff_T_DEVICE_TYPE=".urlencode($zasob->DESC)."&ff_CRM_LISTA_ZASOBOW_ID=".$zasob->ID."&ff_ID_ZASOB=".$zasob->ID."#CREATE", array('class'=>'btn-p5', 'title'=>'Dodaj zapotrzebowanie', 'onclick'=>null)); echo App::link("szukaj", "index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=".ProcesHelper::getZasobTableID($cnf_ids_tabl_TODO_MOVE_TO_CONFIG[$zasob->TYPE])."&ff_CRM_LISTA_ZASOBOW_ID=".$zasob->ID, array('class'=>'btn-p5', 'title'=>'szukaj', 'onclick'=>null)); } echo App::link_ajax("refresh", "ajax_zasob_search_external_ids", array('zasob_id'=>$zasob->ID), array('js_result_type'=>'override_parent', 'js_result'=>'', 'title'=>'refresh IDS', 'ico'=>"refresh.png")); echo ''; // TODO: add link to CRM_EXT_IDS - rysuj strukture } function ajax_zasob_stanowisko_search_kontakty() { header('Content-Type: text/html; charset=utf8'); $zasob_id = V::get('zasob_id', '', $_REQUEST, 'int'); if ($zasob_id <= 0) { echo'Error: Bad request';// TODO: header return; } $DBG = ('123' == V::get('DBG', '', $_REQUEST)); $zasob = DB::get_by_id('CRM_LISTA_ZASOBOW', $zasob_id); if (!$zasob) { echo'Error: 404 not found';// TODO: header return; } $external_ids = array(); $mailto_links = array(); $db = DB::getDB(); $sql = "select u.`ID`, u.`ADM_ACCOUNT`, u.`ADM_NAME`, u.`EMAIL` from `CRM_AUTH_PROFILE` as up left join `ADMIN_USERS` as u on (u.`ID`=up.`REMOTE_ID`) where up.`ID_ZASOB`='{$zasob->ID}' and up.`REMOTE_TABLE`='ADMIN_USERS' and up.`A_STATUS` in('WAITING', 'NORMAL') and u.`A_STATUS` in('WAITING', 'NORMAL') group by u.`ID` "; if($DBG){ echo'
sql (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo''; } $res = $db->query($sql); while ($r = $db->fetch($res)) { $external_ids[] = "{$r->ADM_ACCOUNT}({$r->ADM_NAME})"; if (!empty($r->EMAIL)) { $mailto_links[$r->EMAIL] = true; } } if($DBG){ echo'
external_ids (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($external_ids);echo''; } $out_link = ''; if (empty($external_ids)) { $out_link = ''."Brak danych".''; } else { $out_link = implode(', ', $external_ids); } echo ''; echo $out_link; echo " "; echo App::link_ajax("refresh", "ajax_zasob_stanowisko_search_kontakty", array('zasob_id'=>$zasob->ID), array('js_result_type'=>'override_parent', 'js_result'=>'', 'title'=>'refresh IDS', 'ico'=>"refresh.png")); echo " "; if (!empty($mailto_links)) { $mailto_links = array_keys($mailto_links); echo '
';
echo " ";
}
echo App::link(" więcej » ", array('task'=>"USERS", '_group'=>$zasob_id), array('target'=>"_blank"));
echo '';
// TODO: add link to CRM_EXT_IDS - rysuj strukture
}
function ajax_zasob_get_obowiazki() {
$zasob_id = V::get('zasob_id', '', $_REQUEST, 'int');
if ($zasob_id <= 0) {
echo'Error: Bad request';// TODO: header
return;
}
$zasob = DB::get_by_id('CRM_LISTA_ZASOBOW', $zasob_id);
if (!$zasob) {
echo'Error: 404 not found';// TODO: header
return;
}
$external_ids = array();
$db = DB::getDB();
$sql = "select t.`ID_PROCES` as ext_id
from `CRM_WSKAZNIK` as t
join `CRM_PROCES` as p on(p.`ID`=t.`ID_PROCES`)
where
t.`ID_ZASOB`='{$zasob->ID}'
and t.`A_STATUS` in('WAITING','NORMAL')
and p.`A_STATUS` in('WAITING','NORMAL')
";
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$external_ids[] = $r->ext_id;
}
$out_link_ids_limit = 5;
$out_link = '';
$out_link_add = '';
if (empty($external_ids)) {
$out_link = ''."Brak danych".'';
} else {
$cnt = count($external_ids);
if ($cnt > $out_link_ids_limit) {
$external_ids_tmp = array();
for ($i = 0; $i < $out_link_ids_limit; $i++) {
$external_ids_tmp[] = $external_ids[$i];
}
$out_link_add .= implode(' ', $external_ids_tmp);
$out_link_add .= ' ... ';
$out_link_add .= App::link("({$cnt})", "?task=CRM_WYSWIETL_OBOWIAZKI&CLZ_ID={$zasob->ID}", array('target'=>'_blank', 'title'=>'Procesy powiazane z tym zasobem'));
} else {
$out_link_add .= implode(' ', $external_ids);
$out_link_add .= ' ';
$out_link_add .= App::link("(OB)", "?task=CRM_WYSWIETL_OBOWIAZKI&CLZ_ID={$zasob->ID}", array('target'=>'_blank', 'title'=>'Procesy powiazane z tym zasobem'));
}
}
if ($out_link) {
echo App::link_ajax($out_link, "ajax_zasob_get_obowiazki", array('zasob_id'=>$zasob->ID), array('js_result_type'=>'override', 'js_result'=>'', 'title'=>'refresh OB'));
}
if ($out_link_add) {
echo $out_link_add;
}
}
function ajax_show_images() {
$remote_table = V::get('tbl', '', $_REQUEST);
$remote_id = V::get('id', '', $_REQUEST, 'int');
$thiss = new stdClass();
$thiss->DETECT_TABLE_NAME = $remote_table;
// check remote id
if ($remote_id <= 0) {
header('HTTP/1.1 400: Bad Request');
header('Warning: wrong ID L.' . __LINE__);
exit;
}
// check remote table
$remote_tables = DB_Image::conf_get('remote_tables');
if (!in_array($remote_table, $remote_tables)) {
header('HTTP/1.1 400: Bad Request');
header('Warning: table not allowed L.' . __LINE__);
exit;
}
$images = DB_Image::getImages($remote_table, $remote_id);
if (!$images) {
header('HTTP/1.1 400: Bad Request');
header('Warning: images not found in db L.' . __LINE__);
exit;
}
echo''."Zdjecia dla rekordu {$remote_id} z tabeli {$remote_table}".'
'; foreach ($images as $r) { $src = "?function_init=fun_SHOW_IMAGE&image_id={$r->ID}"; echo'';print_r($db);echo''; } } // conn ok, check if table exists $sql = "show tables like '{$zasob->DESC}' ; "; $res = $db->query($sql); if ($db->num_rows($res) == 1) { echo'TABLE NAME OK;';// TODO: msg OK } else { echo''."Niepoprawna nazwa tabeli {$zasob->DESC}".''; return; } // conn ok, table exists, check table fields $fields = array(); $sql = "describe `{$zasob->DESC}` ; "; $res = $db->query($sql); // Field, Type, Null, Key, Default, Extra // ID, int(10), NO, PRI, NULL, auto_increment // A_RECORD_CREATE_DATE, varchar(30), NO while ($r = $db->fetch($res)) { $params = new stdClass(); // TODO: analyze field parameters: Type,Length,Default,Null? $params->Type = $r->Type; if (substr($r->Type, 0, 3) == 'int') { $params->Type = 'int'; $params->Length = substr(substr($r->Type, 3), 1, -1); } else if (substr($r->Type, 0, 7) == 'varchar') { $params->Type = 'varchar'; $params->Length = substr(substr($r->Type, 7), 1, -1); } else if (substr($r->Type, 0, 4) == 'enum') { $params->Type = 'enum'; $params->Values = substr(substr($r->Type, 4), 1, -1);// TODO: add DANE under KOMORKA } else if (substr($r->Type, 0, 4) == 'date') { $params->Type = 'date'; } else if (substr($r->Type, 0, 4) == 'text') { $params->Type = 'text'; } else { $params->Type = 'unknown'; } // TODO: ... if ($r->Default) $params->Default = $r->Default; else if ($r->Null == 'YES') $params->Default = 'Null'; $fields[$r->Field] = $params; } echo'
fields=';
foreach ($fields as $f_name => $f_params) {
echo"\n".'['.$f_name.']='.json_encode($f_params);
}
echo'';
$komorki = array();
$db = DB::getDB();
$sql = "select
`ID`, `TYPE`, `DESC`
-- TODO: , `PARAMS`
from `CRM_LISTA_ZASOBOW`
where `PARENT_ID`='{$zasob->ID}'
";
$res = $db->query($sql);
// Field, Type, Null, Key, Default, Extra
// ID, int(10), NO, PRI, NULL, auto_increment
// A_RECORD_CREATE_DATE, varchar(30), NO
while ($r = $db->fetch($res)) {
$komorki[$r->DESC] = $r;
}
$errors = array();
foreach ($komorki as $z_name => $z) {
if ($z->TYPE != 'KOMORKA') {
$errors[$z->ID] = "Wrong type ({$z->TYPE},{$z->DESC})";
} else if (!array_key_exists($z->DESC, $fields)) {
$errors[$z->ID] = "Not exists ({$z->DESC})";
} else {
}
}
echo'1 ';print_r($errors);echo''; $errors = array(); foreach ($fields as $f_name => $f_params) { if (!array_key_exists($f_name, $komorki)) { $errors[$f_name] = 'Not exists ('.json_encode($f_params).')'; } else { } } echo'
2 ';print_r($errors);echo''; } function ajax_get_proces() { echo'
TODO: test ajax function L' . __LINE__ . '
'; }