. */ $core_tools = new core_tools(); $core_tools->test_user(); $core_tools->load_lang(); $core_tools->test_service('reports', 'reports'); require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); require_once("apps".DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_list_show.php"); $func = new functions(); $what = "all"; $where = ""; $_SESSION['chosen_user'] = ''; $arrayPDO = array(); if(isset($_GET['what']) && !empty($_GET['what'])) { if($_GET['what'] == "all") { $what = "all"; } else { $where = "(lower(".$_SESSION['tablename']['users'].".lastname) like lower(:what) " . "or lower(".$_SESSION['tablename']['users'].".lastname) like lower(:what)) "; $arrayPDO = array(":what" => $what.'%'); } } $select[$_SESSION['tablename']['users']] = array(); array_push($select[$_SESSION['tablename']['users']],"user_id","lastname","firstname" ); $req = new request(); $list=new list_show(); $order = 'asc'; if(isset($_REQUEST['order']) && !empty($_REQUEST['order'])) { $order = trim($_REQUEST['order']); } $field = 'lastname'; if(isset($_REQUEST['order_field']) && !empty($_REQUEST['order_field'])) { $field = trim($_REQUEST['order_field']); } $orderstr = $list->define_order($order, $field); $tab = $req->PDOselect($select, $where, $arrayPDO, $orderstr, $_SESSION['config']['databasetype'], $limit="500",false); for ($i=0;$ishow_string($tab[$i][$j]['value']); $tab[$i][$j]['lastname']= $tab[$i][$j]['value']; $tab[$i][$j]["label"]=_LASTNAME; $tab[$i][$j]["size"]="30"; $tab[$i][$j]["label_align"]="left"; $tab[$i][$j]["align"]="left"; $tab[$i][$j]["valign"]="bottom"; $tab[$i][$j]["show"]=true; $tab[$i][$j]["order"]='lastname'; } if($tab[$i][$j][$value]=="firstname") { $tab[$i][$j]['value']= $req->show_string($tab[$i][$j]['value']); $tab[$i][$j]["info"]= $tab[$i][$j]['value']; $tab[$i][$j]["label"]=_FIRSTNAME; $tab[$i][$j]["size"]="30"; $tab[$i][$j]["label_align"]="left"; $tab[$i][$j]["align"]="left"; $tab[$i][$j]["valign"]="bottom"; $tab[$i][$j]["show"]=true; $tab[$i][$j]["order"]='firstname'; } } } } if(isset($_REQUEST['field']) && !empty($_REQUEST['field'])) { ?> load_html(); //here we building the header $core_tools->load_header(_CHOOSE_USER2, true, false); $time = $core_tools->get_session_time_expire(); ?> list_doc($tab, $nb, _USERS_LIST,'user_id',$name = "select_user_report",'user_id','',false,true,'get',$_SESSION['config']['businessappurl'].'index.php?dipslay=true&dir=reports&page=select_user_report',_CHOOSE_USER2, false, true, true,false, true, true, true, false, '', '', false, _ALL_USERS,_USER, 'listing spec', '&dir=reports', false, false, array(), ''); //$core_tools->load_js(); ?>