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');
//Column::init($tbl, true);// $tbl, force = true
$tbl_conf = Column::getInstance($tbl);
if (!$tbl_conf) {
echo''."Brak konfiguracji dla {$tbl}!".'
';
return;
}
$dbgExecTime->log('Column::getInstance');
$visible_cols = $tbl_conf->getVisibleFieldList();
// 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'
';
}// 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'
';
}// 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)
if($tblAcl->hasFieldPerm($tblAcl->getFieldIdByName('ID'),'R')) {
echo App::link("Pokaz Tabele", "index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=".ProcesHelper::getZasobTableID('CRM_LISTA_ZASOBOW'));
echo "'."P_ID".' ';
$table_view['head']['PARENT_ID_ACCESS']= '';
$table_view['head']['PARENT_ID_ACCESS'] .= 'P_ID2 ';
if ($_SESSION['TREE_SHOW_P_ID2']) {
$table_view['head']['PARENT_ID_ACCESS'] .= App::link("-", "?TREE_HIDE_P_ID2=1", array('title'=>"Ukryj na drzewie", 'class'=>"btn-p5 btn-sm"));
} else {
$table_view['head']['PARENT_ID_ACCESS'] .= App::link("+", "?TREE_SHOW_P_ID2=1", array('title'=>"Pokaz na drzewie", 'class'=>"btn-p5 btn-sm"));
}
$table_view['head']['PARENT_ID_ACCESS'] .= ' ';
$table_view['head']['PARENT_ID_MAP']= '';
$table_view['head']['PARENT_ID_MAP'] .= 'P_ID3 ';
if ($_SESSION['TREE_SHOW_P_ID3']) {
$table_view['head']['PARENT_ID_MAP'] .= App::link("-", "?TREE_HIDE_P_ID3=1", array('title'=>"Ukryj na drzewie", 'class'=>"btn-p5 btn-sm"));
} else {
$table_view['head']['PARENT_ID_MAP'] .= App::link("+", "?TREE_SHOW_P_ID3=1", array('title'=>"Pokaz na drzewie", 'class'=>"btn-p5 btn-sm"));
}
$table_view['head']['PARENT_ID_MAP'] .= ' ';
$table_view['head']['ALIAS_ID']= 'ALIAS ';
$table_view['head']['TYPE']= 'TYPE';
$table_view['head']['DESC']= 'DESC';
$table_view['head']['DESC_PL']= 'DESC_PL';
$table_view['head']['OPIS']= 'OPIS';
$table_view['head']['A_STATUS'] = 'A_STATUS';
$table_view['head']['L_APPOITMENT_USER'] = 'L_APP_USER';
$table_view['head']['L_APPOITMENT_DATE'] = 'L_APP_DATE';
$table_view['head']['L_APPOITMENT_INFO'] = 'L_APP_INFO';
$table_view['head']['SORT_PRIO']= 'Sort Prio';
$table_view['head']['EXPORT_PARAM']= 'Export?';
$table_view['find']['ID']= App::field_search( 'ID', "varchar(255)", $_GET['ID'], array('class'=>'i', 'size'=>5) );
$table_view['find']['PARENT_ID']= App::field_search( 'P_ID', "varchar(255)", $_GET['P_ID'], array('class'=>'i', 'size'=>5) );
$table_view['find']['PARENT_ID_ACCESS']= App::field_search( 'P_ID2', "varchar(255)", $_GET['P_ID2'], array('class'=>'i', 'size'=>5) );
$table_view['find']['PARENT_ID_MAP']= App::field_search( 'P_ID3', "varchar(255)", $_GET['P_ID3'], array('class'=>'i', 'size'=>5) );
$table_view['find']['ALIAS_ID']= App::field_search( 'ALIAS_ID', "varchar(255)", $_GET['ALIAS_ID'], array('class'=>'i', 'size'=>5) );
$table_view['find']['TYPE']= App::field_search( 'TYPE', $tbl_conf->type('TYPE'), $_GET['TYPE'], array('class'=>'i') );
$table_view['find']['DESC']= App::field_search( 'DESC', "varchar(255)", $_GET['DESC'], array('class'=>'i', 'size'=>5) );
$table_view['find']['DESC_PL']= App::field_search( 'DESC_PL', "varchar(255)", $_GET['DESC_PL'], array('class'=>'i', 'size'=>5) );
$table_view['find']['OPIS']= App::field_search( 'OPIS', "varchar(255)", $_GET['OPIS'], array('class'=>'i', 'size'=>5) );
$table_view['find']['SORT_PRIO']= ' ';
$table_view['find']['A_STATUS'] = App::field_search( 'A_STATUS', $tbl_conf->type('A_STATUS'), $_GET['A_STATUS'], array('class'=>'i') );
$table_view['find']['L_APPOITMENT_USER']= App::field_search( 'L_APPOITMENT_USER', $tbl_conf->type('L_APPOITMENT_USER'), $_GET['L_APPOITMENT_USER'], array('class'=>'i', 'size'=>5) );
$table_view['find']['L_APPOITMENT_DATE']= App::field_search( 'L_APPOITMENT_DATE', $tbl_conf->type('L_APPOITMENT_DATE'), $_GET['L_APPOITMENT_DATE'], array('class'=>'i', 'size'=>5) );
$table_view['find']['L_APPOITMENT_INFO'] = App::field_search( 'L_APPOITMENT_INFO', $tbl_conf->type('L_APPOITMENT_INFO'), $_GET['L_APPOITMENT_INFO'], array('class'=>'i', 'size'=>5) );
$table_view['find']['LOCALIZATION_INCLUDE'] = App::field_search( 'LOCALIZATION_INCLUDE', $tbl_conf->type('LOCALIZATION_INCLUDE'), $_GET['LOCALIZATION_INCLUDE'], array('class'=>'i', 'size'=>5) );
//$table_view['find']['A_ADM_COMPANY'] = App::field_search( 'A_ADM_COMPANY', $tbl_conf->type('A_ADM_COMPANY'), $_GET['A_ADM_COMPANY'], array('class'=>'i', 'size'=>5) );
$table_view['find']['A_RECORD_CREATE_AUTHOR']= App::field_search( 'A_RECORD_CREATE_AUTHOR', $tbl_conf->type('A_RECORD_CREATE_AUTHOR'), $_GET['A_RECORD_CREATE_AUTHOR'], array('class'=>'i') );
$table_view['find']['A_RECORD_CREATE_DATE']= App::field_search( 'A_RECORD_CREATE_DATE', $tbl_conf->type('A_RECORD_CREATE_DATE'), $_GET['A_RECORD_CREATE_DATE'], array('class'=>'i') );
$table_view['find']['A_RECORD_UPDATE_AUTHOR']= App::field_search( 'A_RECORD_UPDATE_AUTHOR', $tbl_conf->type('A_RECORD_UPDATE_AUTHOR'), $_GET['A_RECORD_UPDATE_AUTHOR'], array('class'=>'i') );
$table_view['find']['A_RECORD_UPDATE_DATE']= App::field_search( 'A_RECORD_UPDATE_DATE', $tbl_conf->type('A_RECORD_UPDATE_DATE'), $_GET['A_RECORD_UPDATE_DATE'], array('class'=>'i') );
$table_view['find']['EXPORT_PARAM']= App::field_search( 'EXPORT_PARAM', $tbl_conf->type('EXPORT_PARAM'), $_GET['EXPORT_PARAM'], array('class'=>'i') );
$table_view['foot']['PARENT_ID'] = App::field( 'ADD_'.'PARENT_ID', "varchar(255)", V::get('ADD_'.'PARENT_ID', '', $_POST), array('class'=>'i', 'size'=>4) );
$table_view['foot']['PARENT_ID_ACCESS'] = App::field( 'ADD_'.'PARENT_ID_ACCESS', "varchar(255)", V::get('ADD_'.'PARENT_ID_ACCESS', '', $_POST), array('class'=>'i', 'size'=>4) );
$table_view['foot']['PARENT_ID_MAP'] = App::field( 'ADD_'.'PARENT_ID_MAP', "varchar(255)", V::get('ADD_'.'PARENT_ID_MAP', '', $_POST), array('class'=>'i', 'size'=>4) );
$table_view['foot']['ALIAS_ID'] = App::field( 'ADD_'.'ALIAS_ID', "varchar(255)", V::get('ADD_'.'ALIAS_ID', '', $_POST), array('class'=>'i', 'size'=>4) );
$table_view['foot']['TYPE'] = App::field( 'ADD_'.'TYPE', $tbl_conf->type('TYPE'), V::get('ADD_'.'TYPE', '', $_POST), array('class'=>'i') );
$table_view['foot']['DESC'] = App::field( 'ADD_'.'DESC', "varchar(255)", V::get('ADD_'.'DESC', '', $_POST), array('class'=>'i', 'size'=>14) );
$table_view['foot']['DESC_PL'] = App::field( 'ADD_'.'DESC_PL', "varchar(255)", V::get('ADD_'.'DESC_PL', '', $_POST), array('class'=>'i', 'size'=>14) );
$table_view['foot']['OPIS'] = App::field( 'ADD_'.'OPIS', "varchar(255)", V::get('ADD_'.'OPIS', '', $_POST), array('class'=>'i', 'size'=>20) );
$table_view['foot']['EXPORT_PARAM'] = App::field( 'ADD_'.'EXPORT_PARAM', $tbl_conf->type('EXPORT_PARAM'), V::get('ADD_'.'EXPORT_PARAM', '', $_POST), array('class'=>'i', 'size'=>1) );
//$table_view['foot']['SORT_PRIO'] = '';
echo'';
echo''."\n";
echo'';
echo App::link("C", array('function_init'=>"fun_USERS_COLUMN", 'arg'=>"edit"), array('title'=>"Ustawienia", 'ico'=>'excel.gif', 'ico_height'=>'12'));
echo' ';
foreach ($visible_cols as $field_id => $field_name) {
$v = V::get($field_name, str_replace('_', ' ', $field_name), $table_view['head']);
echo'';
echo $v;
if ($field_name != 'ID') {
echo ' ';
echo App::link("X", array('function_init'=>"fun_USERS_COLUMN", 'arg'=>"hide", 'col_id'=>$field_id), array('title'=>"Ukryj kolumne", 'ico'=>'shutdown.gif', 'ico_height'=>11));
}
echo' '."\n";
}
echo' '."\n";
echo''."\n";
echo'';
echo' '."\n";
echo' ';
echo'';
{// fetch data
$sql_limit = 1500;// TODO: stronicowanie
if ($_SESSION['HIDE_ZASOBY']) $sql_limit = "3";
$sql_where = array();
if ($_GET['EDIT']) {
$sql_where[] = "CP.`ID`='".$_GET['EDIT']."'";
} else {
foreach ($tbl_search_params as $k => $req_field_name) {
// TODO: FILTER_SEARCH <, >, <=, >=, !
$sql_where[] = "CP.`".$k."` like '".$_GET[$req_field_name]."'";
}
}
$sql_where = implode(" and ", $sql_where);
$query = "SELECT
CP.*
FROM `CRM_LISTA_ZASOBOW` as CP
where
".$sql_where."
order by CP.`ID` desc, CP.`PARENT_ID`, CP.`TYPE`, CP.`DESC`
limit ".$sql_limit."
";
$res = DB::query( $query );
}
$t = 0;
while ($r = DB::fetch( $res )) {
if ($_GET['EDIT'] == $r->ID) {
echo'';
}
else {// not EDIT
echo "\n".'';
echo'';
if (User_is_admin()) {
echo App::link("Edit", "?EDIT=".$r->ID, array('id'=>$r->ID, 'title'=>"Edytuj", 'ico'=>'edit.png'));
}
echo' ';
foreach ($visible_cols as $field_id => $field_name) {
if ($field_name == 'ID') {
echo'';
if (User_is_admin()) {
echo App::link($r->ID, "?EDIT=".$r->ID."#".$r->ID, array('id'=>$r->ID, 'title'=>'Edytuj'));
} else {
echo $r->ID;
}
echo ' ';
} else if ($field_name == 'PARENT_ID') {
echo'';
if (User_is_admin()) {
echo App::link(' '.$r->PARENT_ID, "?EDIT=".$r->PARENT_ID."#".$r->PARENT_ID, array('title'=>'Edytuj'));
} else {
echo $r->PARENT_ID;
}
echo' ';
} else if ($field_name == 'PARENT_ID_ACCESS') {
echo'';
$p_id2_links = array();
$p_id2 = explode(',', $r->PARENT_ID_ACCESS);
foreach ($p_id2 as $p_id) {
$p_id2_links[] = App::link($p_id, "?EDIT=".$p_id."#".$p_id);
}
if (!empty($p_id2_links)) echo implode(', ', $p_id2_links);
echo' ';
} else if ($field_name == 'PARENT_ID_MAP') {
echo'';
$p_id3_links = array();
$p_id3 = explode(',', $r->PARENT_ID_MAP);
foreach ($p_id3 as $p_id) {
$p_id3_links[] = App::link($p_id, "?EDIT=".$p_id."#".$p_id);
}
if (!empty($p_id3_links)) echo implode(', ', $p_id3_links);
echo' ';
} else {
echo' '.$r->$field_name.' ';
}
}
echo' ';
}
}
echo' ';
if (User_is_admin()) {
echo'';
echo'';
echo' ';
}
echo'
';
}
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)
if($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_ADD() {
$redirect = "?task=".App::get_task();
$msg = '';
$sql_obj = new stdClass();
$tbl_name = 'CRM_LISTA_ZASOBOW';
Lib::loadClass('Column');
$tbl_conf = Column::getInstance($tbl_name);
if (!$tbl_conf) {
return;
}
foreach ($tbl_conf->getFieldList() as $field_id => $field_name) {
if ($tbl_conf->allowCreate($field_name)) {
$post_arg_name = 'ADD_' . $field_name;
if (isset($_POST[$post_arg_name])) {
$sql_obj->$field_name = $_POST[$post_arg_name];
}
}
}
// nowy na koniec listy
$sql = "select max(t.`SORT_PRIO`) as MAX_SORT_PRIO
from `CRM_LISTA_ZASOBOW` as t
where
t.`PARENT_ID`='".$sql_obj->PARENT_ID."'
";
$res = DB::query( $sql );
while ($r = DB::fetch( $res )) {
$sql_obj->SORT_PRIO = $r->MAX_SORT_PRIO + 1;
}
//TODO: post verify
$new_id = DB::ADD_NEW_OBJ('CRM_LISTA_ZASOBOW', $sql_obj);
if (V::get('DEBUG', '', $_SESSION)) App::add_msg("PASSED(1) NEW RECORD ID($new_id)");
if ($new_id > 0) {
App::add_msg("Dodano nowy rekord (ID ".$new_id.")");
$redirect .= "&EDIT=".$new_id;
}
else {
App::add_error("Error przy dodawaniu rekordu!");
}
App::redirect($redirect, $msg);
}
/**
* @param $_POST['EDIT_ID'] - ID rekordu
* function_init - params in $_POST, ends with redirect to task
*/
function fun_CRM_LISTA_ZASOBOW_EDIT() {
$redirect = "?task=".App::get_task();
$msg = '';
$sql_obj = new stdClass();
$tbl_name = 'CRM_LISTA_ZASOBOW';
$sql_obj->ID = V::get('EDIT_ID', '', $_POST, 'int');
// TODO: fields can be hidden
Lib::loadClass('Column');
$tbl_conf = Column::getInstance($tbl_name);
if (!$tbl_conf) {
return;
}
foreach ($tbl_conf->getFieldList() as $field_id => $field_name) {
if ($tbl_conf->allowWrite($field_name)) {
$post_arg_name = 'EDIT_' . $field_name;
if (isset($_POST[$post_arg_name])) {
// TODO: convert field types? EDIT_ALIAS_ID must be INT
$sql_obj->$field_name = $_POST[$post_arg_name];
}
}
}
$redirect .= "&EDIT=".$sql_obj->ID;
//TODO: post verify
$id = $sql_obj->ID;
$affected = DB::UPDATE_OBJ( 'CRM_LISTA_ZASOBOW', $sql_obj );
if (V::get('DEBUG', '', $_SESSION)) App::add_msg("PASSED($affected)");
if ($affected == 2) {
App::add_msg("Zmieniono rekord (ID ".$id.")");
}
else if ($affected == 1) {
App::add_msg("Zmieniono rekord (ID ".$id.") (Error: nie zapisano hostorii)");
}
else if ($affected < 0) {
App::add_error("Blad podczas edytowania rekordu - nic nie zmieniono");
}
App::redirect($redirect, $msg);
}
/**
* @param $_GET['EDIT_ID'] - ID rekordu
*/
function task_CRM_LISTA_ZASOBOW_EDIT() {
User_procesy5_check_access();
global $error;
$id = V::get('EDIT_ID', '', $_GET, 'int');
if ($id <= 0) {
echo''."Wrong ID".'
';
return;
}
$r = DB::get_by_id( 'CRM_LISTA_ZASOBOW', $id );
if (!$r) {
echo''."Wrong ID - not exists".'
';
return;
}
//echo'';print_r($r);echo' ';
echo'';
echo App::link("LISTA ZASOBOW", "?task=CRM_LISTA_ZASOBOW");
echo' - ';
echo "Edycja zasobu [".$r->ID."]";
echo' ';
echo App::link("IMG", "?function_init=fun_IMAGE_ADD&tbl=".'CRM_LISTA_ZASOBOW'."&id=".$r->ID, array('target'=>'_blank', 'title'=>"Dodaj zdjecia"));
echo ' '.App::link("OB", "?task=CRM_WYSWIETL_OBOWIAZKI&CLZ_ID=".$r->ID, array('target'=>'_blank', 'title'=>"Powiazania z procesami"));
echo '' . "No DB!" . '
';
return;
} else if ($db->has_errors()) {
echo '' . "Error DB: " . implode('
';
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 . " rekordw." . '
';
}