DETECT_TABLE_COLUMN]['SQL_WIEV_CURR_SQL']) SQL_WIEV(); //USERS_HIDECOLUMN(); //USERS_SORTER(); $conn=mysql_pconnect($INTERFACE_ADDR,$SQL_USER,$SQL_USER_PASS); if (!$conn) die("ERROR podczas tworzenia polaczenia do bazy $SQL_DATABASE !\n"); mysql_select_db($SQL_DATABASE) or die("ERROR podczas wyboru bazy R50!"); GETZAPSQL(); //$zapSQL="SELECT * from USERS2 where A_ADM_COMPANY like '$_SESSION[ADM_COMPANY]' $_SESSION[USERS_FILTER_PROBLEM_SQL] $_SESSION[USERS_FILTER_STATUS_SQL] $_SESSION[USERS_FILTER_APPOINTMENT_SQL] " . $_SESSION[USERS_COLUMN][FINDSQL] ." ". $_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_SORTER_SQL] ." ;"; $zapSQL="SELECT $GETZAPSQL[WHAT_SQL] from $GETZAPSQL[FROM_SQL] where $GETZAPSQL[WHERE] ;"; if($_SESSION['DEBUG']) { echo "zapSQL is $zapSQL
".$_SESSION['USERS_COLUMN']['FINDSQL']."
"; echo "
GETZAPSQL[SQL] $GETZAPSQL[SQL]
"; } //EOF GETZAPSQL TESTS $result = mysql_query($zapSQL,$conn) or die("Blad $zapSQL zapytania2!"); $_SESSION['MYSQL_NUM_ROWS_TOTAL']['USERS'] = mysql_num_rows($result); //TO_REMOVE_VARIABLE TODO $_SESSION[$thiss->DETECT_TABLE_COLUMN]['MYSQL_NUM_ROWS_TOTAL'] = mysql_num_rows($result); //$zapSQL="SELECT * from USERS2 where A_ADM_COMPANY like '$_SESSION[ADM_COMPANY]' $_SESSION[USERS_FILTER_PROBLEM_SQL] $_SESSION[USERS_FILTER_STATUS_SQL] $_SESSION[USERS_FILTER_APPOINTMENT_SQL] " . $_SESSION[USERS_COLUMN][FINDSQL] . " ". $_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_SORTER_SQL] ." ".$_SESSION[$thiss->DETECT_TABLE_COLUMN][SQL_WIEV_CURR_SQL]." ;"; $zapSQL="SELECT $GETZAPSQL[WHAT_SQL] from $GETZAPSQL[FROM_SQL] where $GETZAPSQL[WHERE2] ;"; //$zapSQL="SELECT * from USERS2 group by S_HWSTAT ;"; if($_SESSION['DEBUG']) echo "
CORRECT_SQL_ZAPYTANIE **/*/* $thiss->DETECT_TABLE_COLUMN $zapSQL **/*"; $result = mysql_query($zapSQL,$conn) or die("Blad zapytania2 $zapSQL!"); $num_rows = mysql_num_rows($result); $_SESSION['MYSQL_NUM_ROWS'] = $num_rows; //echo "
LICZBA_WIERSZY $num_rows
"; echo ""; CREATE_MENU_INIT('USERS_FILTER_PROBLEM','PROBLEM','PROBLEMY'); CREATE_MENU_INIT('USERS_FILTER_PROBLEM','WARNING','OSTRZEZENIA'); CREATE_MENU_INIT('USERS_FILTER_PROBLEM','NORMAL','BEZ_PROBLEM.'); if($_SESSION['USERS_FILTER_PROBLEM_SQL']) $FILTER_BOLD="*"; else $FILTER_BOLD=""; CREATE_MENU_INIT('USERS_FILTER_PROBLEM','',"".$FILTER_BOLD."KASUJ-FILTR"); CREATE_MENU_INIT('USERS_FILTER_STATUS','WAITING','OCZEKUJACY'); CREATE_MENU_INIT('USERS_FILTER_STATUS','AKTYWNI','AKTYWNI'); if($_SESSION['USERS_FILTER_STATUS_SQL']) $FILTER_BOLD="*"; else $FILTER_BOLD=""; CREATE_MENU_INIT('USERS_FILTER_STATUS','',"".$FILTER_BOLD."KASUJ-FILTR"); CREATE_MENU_INIT('USERS_FILTER_APPOINTMENT','OLD','A_STARE'); CREATE_MENU_INIT('USERS_FILTER_APPOINTMENT','TODAY','APP_DZISIAJ'); if($_SESSION['USERS_FILTER_APPOINTMENT_SQL']) $FILTER_BOLD="*"; else $FILTER_BOLD=""; CREATE_MENU_INIT('USERS_FILTER_APPOINTMENT','',$FILTER_BOLD."APP_ALL"); //CREATE_MENU_INIT(SQL_WIEV,NEXT,NASTEPNE); //CREATE_MENU_INIT(SQL_WIEV,PREV,POPRZEDNIE); CREATE_MENUFUNC_INIT('USERS_COLUMN_MENU','WYBIERZ_KOLUMNY'); //CREATE_MENUFUNC_INIT(USERS_COLUMN_MENU,POKAZ_KOLUMNY); echo "
"; NAVIGATOR(); if(strstr($_SESSION['USERS_COLUMN']['FUNCPERMEDIT']['P_NEW_DEAL'],'RW')) { CREATE_MENUFUNC_INIT_2('USERS_NEWDEAL','NEWDEAL','','( NOWA_UMOWANOWA_UMOWA )') ; // echo "NOWA_UMOWA"; // if(strstr($_SESSION[USERS_COLUMN][FUNCPERMEDIT][P_NEW_DEAL],'R')) echo "DRUKUJ_UMOWY"; } echo''; echo''; //echo "\n
"; echo ""; foreach ($GETZAPSQL['ID'] as $value) { if(true) { echo ""; //echo "
" . $GETZAPSQL[WHAT_DESC][$value] . ""; } } echo " \n"; //SECOND_ROW if($_SESSION['USERS_COLUMN']['MENU_FIND']=='ENABLE') { echo ""; foreach ($GETZAPSQL['ID'] as $value) { if(true) { echo ""; } //EOF if(!$USERS_COLUMN[HIDE][$value]==HIDE) } //EOF foreach ($USERS_COLUMN[ID] as $value) echo " \n"; } //EOF if($_SESSION[USERS_COLUMN][MENU_FIND]==ENABLE) echo''; if( $num_rows == 0 ) echo "
"; //CREATE_MENU_NOTD_INIT_3(USERS_COLUMN,$value,HIDE,'X') ; CREATE_MENU_NOTD_INIT_3('FILTER_SEARCH','MENU_FIND','ENABLE','SZUKAJ'); echo "" ; $ALT=$_SESSION[$thiss->DETECT_TABLE_COLUMN]['DESC_TO_LANG'][$GETZAPSQL['WHAT_DESC'][$value]]; if($_SESSION['USERS_COLUMN']['SORTED'][$GETZAPSQL['WHAT_DESC'][$value]]=='PRI') $border=1; else $border=0; // echo "sortuj"; //echo "$value"; CREATE_MENU_NOTD_INIT_2('USERS_SORTER','USERS_SORTER','USERS_SORTER1',$GETZAPSQL['WHAT_DESC'][$value],'SORTUJSORTUJ') ; if(($_SESSION[$thiss->DETECT_TABLE_COLUMN]['USERS_SORTER_SQL']) || ($_SESSION['USERS_SORTER_SQL'])) { //TODO remove second extra cond. if($_SESSION['USERS_COLUMN']['SORTED'][$GETZAPSQL['WHAT_DESC'][$value]]=='SEC') $border=1; else $border=0; // echo "sortuj"; CREATE_MENU_NOTD_INIT_2('USERS_SORTER','USERS_SORTER','USERS_SORTER2',$GETZAPSQL['WHAT_DESC'][$value],'sortuj') ; } CREATE_MENU_NOTD_INIT_3('USERS_COLUMN',$_SESSION[$thiss->DETECT_TABLE_COLUMN]['DESC_TO_KEY'][$GETZAPSQL['WHAT_DESC'][$value]],'HIDE','WYLACZ_KOLUMNE '.$ALT.'') ; echo "
" .str_replace('_',' ',$GETZAPSQL['WHAT_DESC'][$value]) . "
"; CREATE_MENU_NOTD_INIT_3('FILTER_SEARCH','MENU_FIND','','X'); echo ""; echo "
" ; GETFORMITEM($_SESSION['USERS_COLUMN']['FIND'][$GETZAPSQL['WHAT_DESC'][$value]],$_SESSION['USERS_COLUMN']['TYPE'][$GETZAPSQL['WHAT_DESC'][$value]],$GETZAPSQL['WHAT_DESC'][$value]); echo "
Brak Danych" ; else { // $USERS_COLUMN = array("0","1","2","3","4"); // $USERS_COLUMN_DESC = array("JEDEN","DWA","TRZY","CZTERY","PIEC"); // reset ($USERS_COLUMN); // reset ($USERS_COLUMN_DESC); $t = 0; echo''; while ($h=mysql_fetch_row($result)) { // echo "$h->S_IP $h->A_STATUS $h->A_PROBLEM
"; echo ''; echo ''; // echo ""; // echo $h[$_SESSION[USERS_COLUMN][DESC_TO_KEY][ID]]; CREATE_MENUFUNC_INIT_2('USERS_HISTORY','HISTORY',$h[$GETZAPSQL['DESC_TO_KEY']['ID']],'HISTORIA') ; //echo " |  "; CREATE_MENUFUNC_INIT_2('USERS_EDIT','EDIT',$h[$GETZAPSQL['DESC_TO_KEY']['ID']],'EDYCJA') ; echo ""; //print_r($h); //print_r($GETZAPSQL['DESC_TO_KEY']['T_NETWORK_SERVER']); foreach ($GETZAPSQL['ID'] as $value) { if(true) { echo ""; echo "$h[$value]";// . $_SESSION[USERS_COLUMN][DESC][$value]; echo ""; } } echo "\n"; } echo''; } echo ""; return; }