0) {
$_GET['EDIT'] = $edit_id;
}
$tbl = 'CRM_LISTA_ZASOBOW';
$DBG_TIME = ('1' == V::get('DBG_TIME', '', $_GET));
$dbgExecTime = new DebugExecutionTime();
if ($DBG_TIME) $dbgExecTime->activate();
$dbgExecTime->log('start');
// form decorators:
$tbl_search_params = array();
$tbl_search_params['ID'] = 'ID';
$tbl_search_params['PARENT_ID'] = 'P_ID';
$tbl_search_params['PARENT_ID_ACCESS'] = 'P_ID2';
$tbl_search_params['PARENT_ID_MAP'] = 'P_ID3';
$tbl_search_params['ALIAS_ID'] = 'ALIAS_ID';
$tbl_search_params['TYPE'] = 'TYPE';
$tbl_search_params['DESC'] = 'DESC';
$tbl_search_params['DESC_PL'] = 'DESC_PL';
$tbl_search_params['OPIS'] = 'OPIS';
$tbl_search_params['A_STATUS'] = 'A_STATUS';
$tbl_search_params['L_APPOITMENT_USER'] = 'L_APPOITMENT_USER';
$tbl_search_params['L_APPOITMENT_DATE'] = 'L_APPOITMENT_DATE';
$tbl_search_params['L_APPOITMENT_INFO'] = 'L_APPOITMENT_INFO';
$tbl_search_params['LOCALIZATION_INCLUDE'] = 'LOCALIZATION_INCLUDE';
$tbl_search_params['A_RECORD_CREATE_AUTHOR'] = 'A_RECORD_CREATE_AUTHOR';
$tbl_search_params['A_RECORD_CREATE_DATE'] = 'A_RECORD_CREATE_DATE';
$tbl_search_params['A_RECORD_UPDATE_AUTHOR'] = 'A_RECORD_UPDATE_AUTHOR';
$tbl_search_params['A_RECORD_UPDATE_DATE'] = 'A_RECORD_UPDATE_DATE';
$tbl_search_params['EXPORT_PARAM'] = 'EXPORT_PARAM';
Lib::loadClass('FilterLast');
$filter_last = new FilterLast( $_REQUEST, $tbl, 'session');
$filter_last->add_filter( 'last_id', array('filtr_id','filtr_search_id','ID','EDIT'), "Ostatnio uzywane ID", 'int' );
$filter_last->_save_args();// save args from request
{// TABLE - Filter
$tbl = 'CRM_LISTA_ZASOBOW';
$tbl_filter = new stdClass();
$tbl_filter->key = 'tbl-'.$tbl;
$tbl_filter->filters = array();
// TODO: stronicowanie $tbl_filter->filters: _page_nr, _limit, _total (need sql - only after change params)
// read args from session, or get dafault values
foreach ($tbl_search_params as $k => $req_field_name) {
$tbl_filter->filters[$req_field_name] = V::get($req_field_name, '%', $_SESSION[$tbl_filter->key]);
}
// read args from $_GET if isset
foreach ($tbl_search_params as $k => $req_field_name) {
if (isset($_GET[$req_field_name])) {
$tbl_filter->filters[$req_field_name] = $_GET[$req_field_name];
}
}
// save args in session and $_GET
foreach ($tbl_filter->filters as $req_field_name => $v) {
$_SESSION[$tbl_filter->key][$req_field_name] = $v;
$_GET[$req_field_name] = $v;
}
echo'';
foreach ($tbl_filter->filters as $req_field_name => $v) {
echo'
arg['.$req_field_name.'] = '.$v;
}
echo'
';
}// TABLE - Filter
{// TREE - Filter
$tbl = 'CRM_LISTA_ZASOBOW';
Lib::loadClass('FilterFactory');
$tree_zasoby_filter = FilterFactory::build($tbl);
$tree_zasoby_filter->setArgs($_GET);
$tree_zasoby_filter->set_trash('filtr_id', -1);
{// zapisz stan - ajax function to save filters stan and opened tree nodes, etc.
$filtr_ses_key = $tree_zasoby_filter->_key;
$cookie_key = 'TREE_'.$tbl;
$profile_key = 'Filtr_'.$filtr_ses_key;
if (V::get('save_profile', '', $_REQUEST)) {
$profile_val = array();
$profile_val['filtr'] = $_SESSION[$filtr_ses_key];
$profile_val['tree'] = $_COOKIE[$cookie_key];// cookie key from Tree class - 'TREE_'. $tbl @see __construct
User::setProfile($profile_key, $profile_val);
$ret = User::saveProfile();
}
else if (V::get('load_profile', '', $_REQUEST)) {
//User::loadProfile();// proile is loaded in USERS_COLUMN_INIT after login
$profile_val = User::getProfile($profile_key);
$_COOKIE[$cookie_key] = $profile_val['tree'];
echo'';
$_SESSION[$filtr_ses_key] = $profile_val['filtr'];
$tree_zasoby_filter->_read_args( true );// force load args from session
}
}// zapisz stan - ajax function to save filters stan and opened tree nodes, etc.
$tree_zasoby_filter->_save_args();// force save_args (executet at the end of show_filters)
echo'';
foreach ($tree_zasoby_filter->filters as $arg => $v) {
echo'
arg['.$arg.'] = '.$tree_zasoby_filter->get_arg($arg);
}
echo'
';
}// TREE - Filter
echo'';
echo App::link("Zasoby", array('task'=>App::get_task(), 'filtr_id'=>''));
if ($tree_zasoby_filter->is_trash()) {//$_GET['filtr_id'] == -1) {
echo ' » '."Kosz";
echo " " . App::link("czyść", array('task'=>App::get_task(), 'function_init'=>"fun_CRM_LISTA_ZASOBOW_clean_trash"), array('title'=>"Ustaw status rekordw w koszu na DELETED", 'class'=>'btn-p5', 'style'=>'font-size:13px;'));
} else if ($tree_zasoby_filter->get_arg('filtr_id') > 0) {//$_GET['filtr_id'] > 0) {
echo ' » '."Zasob [".$tree_zasoby_filter->get_arg('filtr_id')."]";
}
echo'
';
$userAcl = User::getAcl();
$tblAcl = $userAcl->getTableAcl(ProcesHelper::getZasobTableID('CRM_LISTA_ZASOBOW'));
if ($tblAcl && $tblAcl->hasFieldPerm($tblAcl->getFieldIdByName('ID'),'R')) {
UI::startTag('ul', ['class' => "breadcrumb"]);
UI::startTag('li');
UI::tag('a', ['href'=>"index.php?_route=ViewTableAjax&namespace=default_db/CRM_LISTA_ZASOBOW"], "Tabela Zasoby (CRM_LISTA_ZASOBOW)");
UI::endTag('li');
UI::startTag('li');
UI::tag('a', ['href'=>"index.php?_route=ViewTableAjax&namespace=default_db/CRM_LISTA_ZASOBOW#CREATE"], " Dodaj nowy rekord");
UI::endTag('li');
UI::endTag('ul');
}
echo'';
$dbgExecTime->log('show...');
//if (isset($_SESSION['USER_PARAMS']['ZASOBY_TREE_TYPE_HTML']) && $_SESSION['USER_PARAMS']['ZASOBY_TREE_TYPE_HTML']) {
if ($tree_zasoby_filter->get_arg('filtr_view') == 'NOWY') {
$filter_last->show_filters();
echo'';
echo'';
echo'
';// .filters
$filter_hist = (isset($_SESSION['TREE-PROCESY']['filter_hist']))? $_SESSION['TREE-PROCESY']['filter_hist'] : array();
if (!empty($filter_hist)) {
echo'';
}
$tree = new Tree( $tbl );
$tree->setProfiler($dbgExecTime);
$clbk = 'tree_callback__show_item_from_'.$tbl;
$tree->set_param('show_item_callback', $clbk);
//TODO: add all filters from Filter - $tree_zasoby_filter
$tree->set_param('rozwin', ($tree_zasoby_filter->get_arg('filtr_drzewo') == 'ROZWIN'));
$tree->set_param('filtr_ob', ($tree_zasoby_filter->get_arg('filtr_ob') == '+'));
$tree->set_param('filtr_img', ($tree_zasoby_filter->get_arg('filtr_img') == '+'));
$tree->set_param('rozwin_opis', ($tree_zasoby_filter->get_arg('filtr_opis') == '+'));
$tree->set_param('filtr_ids', ($tree_zasoby_filter->get_arg('filtr_ids') == '+'));
$tree->set_param('search_id', $tree_zasoby_filter->get_arg('filtr_search_id'));
//TODO: editable tylko dla userow ktorzy maja uprawnienia
$tree->set_param('getZasobTableID', ProcesHelper::getZasobTableID('CRM_LISTA_ZASOBOW'));
$tree->set_param('editable', ($tree_zasoby_filter->get_arg('filtr_edit') == 'TAK'));
//wykrywamy czy ma dostepny proces do jakiejs komorki w tej tabeli
$userAcl = User::getAcl();
$tblAcl = $userAcl->getTableAcl(ProcesHelper::getZasobTableID('CRM_LISTA_ZASOBOW'));
if ($tblAcl && $tblAcl->hasFieldPerm($tblAcl->getFieldIdByName('ID'),'R')) $tree->set_param('hasFieldPerm__ID', true);
if ($tree_zasoby_filter->is_trash()) $tree->set_param('is_trash', true);
if ($tree_zasoby_filter->get_arg('filtr_ajax') == 'TAK') {
$tree->_limit = 300;
$tree->_deep_limit = 2;
}
if ($tree_zasoby_filter->get_arg('filtr_id') != 0) {
$tree->showSubTree( $tree_zasoby_filter->get_arg('filtr_id') );
} else if ($tree_zasoby_filter->get_arg('filtr_search_id') > 0) {
$tree->showSearchNode( $tree_zasoby_filter->get_arg('filtr_search_id') );
} else {
$tree->show();
}
}
else {
echo'';
echo "DRZEWO ";
if ($_SESSION['ZWIN_DRZEWO']) {
echo App::link("ROZWIN", "?ROZWIN_DRZEWO=1#tree");
} else {
echo App::link("ZWIN", "?ZWIN_DRZEWO=1#tree");
}
echo " / ";
if ($filter_show_sort_prio = V::get('TREE_ZASOBY_SORT_PRIO', '', $_REQUEST)) {
if ($filter_show_sort_prio == 'SHOW') {
$_SESSION['TREE-ZASOBY']['SORT_PRIO'] = 1;
} else if ($filter_show_sort_prio == 'HIDE') {
$_SESSION['TREE-ZASOBY']['SORT_PRIO'] = 0;
}
}
echo "SORT PRIO ";
if (V::get('SORT_PRIO', '', $_SESSION['TREE-ZASOBY'])) {
echo App::link("UKRYJ", "?TREE_ZASOBY_SORT_PRIO=HIDE#tree");
} else {
echo App::link("POKAZ", "?TREE_ZASOBY_SORT_PRIO=SHOW#tree");
}
echo " / ";
if ($filter_show_ids = V::get('TREE_ZASOBY_EXTERNAL_IDS', '', $_REQUEST)) {
if ($filter_show_ids == 'SHOW') {
$_SESSION['TREE-ZASOBY']['EXTERNAL_IDS'] = 1;
} else if ($filter_show_ids == 'HIDE') {
$_SESSION['TREE-ZASOBY']['EXTERNAL_IDS'] = 0;
}
}
echo "IDS ";
if (V::get('EXTERNAL_IDS', '', $_SESSION['TREE-ZASOBY'])) {
echo App::link("UKRYJ", "?TREE_ZASOBY_EXTERNAL_IDS=HIDE#tree");
} else {
echo App::link("POKAZ", "?TREE_ZASOBY_EXTERNAL_IDS=SHOW#tree");
}
echo " / ";
$show_filter_type = 0;
if ($show_filter_type) {
$selected_type = V::get('TREE_ZASOBY_FILTER_TYPE', V::get('FILTER_TYPE', '', $_SESSION['TREE-ZASOBY']), $_REQUEST);
$_SESSION['TREE-ZASOBY']['FILTER_TYPE'] = $selected_type;
$types = $_SESSION['CRM_LISTA_ZASOBOW_COLUMN']['TYPE']['TYPE'];
$types = explode(',', str_replace(array("enum(",")","'"), '', $types));
sort($types);
array_unshift($types, '%');
//echo'';print_r($types);echo'
';
echo"TYP: ";
echo'';
echo " / ";
}
$js = "window.location.href='#TREE'+this.form.id.value;return false;";
echo '';
echo " / ";
echo'Widok ';
echo App::link("NOWY", "?filtr_view=NOWY");
{
echo " / ";
echo'';
}
echo "\n";
tree_listuj_zasoby(0,0,0);
echo'';
}
if($DBG_TIME){
$dbgExecTime->log('end');
$dbgExecTime->printDebug();
}
}
function fun_CRM_LISTA_ZASOBOW_clean_trash() {
$db = DB::getDB();
if (!$db) {
echo '' . "No DB!" . '
';
return;
} else if ($db->has_errors()) {
echo '' . "Error DB: " . implode('
', $db->get_errors()) . '
';
return;
}
$affected_total = 0;
// remove all root trash items
$sql = "update `CRM_LISTA_ZASOBOW` as z
set z.`A_STATUS`='DELETED', z.`A_RECORD_UPDATE_AUTHOR`='TrashRemoveRec', z.`A_RECORD_UPDATE_DATE`=NOW()
where z.`PARENT_ID`=-1 and z.`A_STATUS`!='DELETED'
";
$db->query($sql);
$affected = $db->affected_rows();
if ($affected) {
$affected_total += $affected;
}
// remove all child trash items - run X times
$loop_limit = 50;
do {
$sql = "update `CRM_LISTA_ZASOBOW` as z, `CRM_LISTA_ZASOBOW` as zz
set z.`A_STATUS`='DELETED', z.`A_RECORD_UPDATE_AUTHOR`='TrashRemoveRec', z.`A_RECORD_UPDATE_DATE`=NOW()
where z.`PARENT_ID`=zz.`ID` and (zz.`PARENT_ID`=-1 or zz.`A_STATUS`='DELETED') and z.`A_STATUS`!='DELETED'
";
$db->query($sql);
$affected = $db->affected_rows();
if ($affected) {
$affected_total += $affected;
}
} while ($affected > 0 && --$loop_limit >= 0);
echo '' . "Usunięto " . $affected_total . " rekordów." . '
';
}