f.WIEVTABLE "; } SEF("MENU"); MENU(); DETECT_TABLE_COLUMN(); if($_SESSION[DEBUG]) echo "USERS WIEV FUNCTION USED l 14431 "; if($USERS_FILTER_PROBLEM) USERS_FILTER_PROBLEM(); if(!$_SESSION[$thiss->DETECT_TABLE_COLUMN]['SQL_WIEV_CURR_SQL']) SQL_WIEV(); $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(); // if($_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC_TO_KEY][L_APPOITMENT_DATE]) $_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_FILTER_APPOINTMENT_SQL]=$_SESSION[USERS_FILTER_APPOINTMENT_SQL]; // if($_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC_TO_KEY][A_STATUS]) $_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_FILTER_STATUS_SQL]=$_SESSION[USERS_FILTER_STATUS_SQL]; //$_SESSION[USERS_FILTER_STATUS_SQL] //$zapSQL="SELECT * from $thiss->DETECT_TABLE_NAME where A_ADM_COMPANY like '$_SESSION[ADM_COMPANY]' $_SESSION[USERS_FILTER_PROBLEM_SQL] ".$_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_FILTER_STATUS_SQL]." ".$_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_FILTER_APPOINTMENT_SQL]." ".$_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_FILTER_STATUS_SQL]." " . $_SESSION[$thiss->DETECT_TABLE_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_NIECORRECT $zapSQL ***
".$_SESSION[$thiss->DETECT_TABLE_COLUMN][FINDSQL]."***"; $result = mysql_query($zapSQL,$conn) or die("Blad zapytania1!"); $_SESSION[$thiss->DETECT_TABLE_COLUMN][MYSQL_NUM_ROWS_TOTAL] = mysql_num_rows($result); $num_rows = mysql_num_rows($result); $zapSQL="SELECT $GETZAPSQL[WHAT_SQL] from $GETZAPSQL[FROM_SQL] where $GETZAPSQL[WHERE2] ;"; if($_SESSION[DEBUG]) echo "
*ZAPSQL_CORRECT $zapSQL ***
".$_SESSION[$thiss->DETECT_TABLE_COLUMN][FINDSQL]."***"; $result = mysql_query($zapSQL,$conn) or die("Blad zapytania2!"); //$_SESSION[MYSQL_NUM_ROWS] = $num_rows; //TODO po co to ? 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"); if($_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC_TO_KEY][A_STATUS]) { 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"); } if($_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC_TO_KEY][L_APPOITMENT_DATE]) { CREATE_MENU_INIT(USERS_FILTER_APPOINTMENT,OLD,A_STARE); CREATE_MENU_INIT(USERS_FILTER_APPOINTMENT,NOW,A_ZARAZ); CREATE_MENU_INIT(USERS_FILTER_APPOINTMENT,TODAY,A_DZISIAJ); if($_SESSION[USERS_FILTER_APPOINTMENT_SQL]) $FILTER_BOLD="*"; else $FILTER_BOLD=""; CREATE_MENU_INIT(USERS_FILTER_APPOINTMENT,'',$FILTER_BOLD."APP_ALL"); } CREATE_MENUFUNC_INIT(USERS_COLUMN_MENU,'WYBIERZ_KOLUMNY'); echo "
"; NAVIGATOR(); if($_SESSION[$thiss->DETECT_TABLE_COLUMN][FUNCPERMEDIT][P_NEW_DEAL]=="RW") { CREATE_MENUFUNC_INIT_2(USERS_NEWDEAL,NEWDEAL,'','NOWA_UMOWA') ; } if(strstr($_SESSION[$thiss->DETECT_TABLE_COLUMN][FUNCPERMEDIT][NEW_RECORD],"X")) { CREATE_MENUFUNC_INIT_2(NEW_RECORD,NEW_RECORD,'','( NOWY_REKORDNOWY_REKORD )') ; } echo "\n"; echo ""; //echo "
HERE".$_SESSION[$thiss->DETECT_TABLE_COLUMN][ID]."*".$thiss->DETECT_TABLE_COLUMN."*"; if($_SESSION[DEBUG]) print_r($GETZAPSQL); foreach ($GETZAPSQL[ID] as $value) { if(true) { echo ""; echo "
" .str_replace('_',' ',$GETZAPSQL[WHAT_DESC][$value]) . ""; } } echo " \n"; //SECOND_ROW if($_SESSION[$thiss->DETECT_TABLE_COLUMN][MENU_FIND]==ENABLE) { echo ""; foreach ($GETZAPSQL[ID] as $value) { if(true) { echo ""; } //EOF if(!$thiss->DETECT_TABLE_COLUMN[HIDE][$value]==HIDE) } //EOF foreach ($thiss->DETECT_TABLE_COLUMN[ID] as $value) echo " \n"; } //EOF if($_SESSION[$thiss->DETECT_TABLE_COLUMN][MENU_FIND]==ENABLE) 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[$thiss->DETECT_TABLE_COLUMN][SORTED][$GETZAPSQL[WHAT_DESC][$value]]==PRI) $border=1; else $border=0; // echo "sortuj"; CREATE_MENU_NOTD_INIT_2(USERS_SORTER,USERS_SORTER,USERS_SORTER1,$GETZAPSQL[WHAT_DESC][$value],'.$ALT.SORTUJ') ; if($_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_SORTER_SQL]) { if($_SESSION[$thiss->DETECT_TABLE_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],''.$ALT.'') ; } CREATE_MENU_NOTD_INIT_3(USERS_COLUMN,$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC_TO_KEY][$GETZAPSQL[WHAT_DESC][$value]],HIDE,''.$ALT.' WYLACZ_KOLUMNE') ; // echo "
" .substr($GETZAPSQL[WHAT_DESC][$value],0,8) . "
"; CREATE_MENU_NOTD_INIT_3(FILTER_SEARCH,MENU_FIND,'','X'); echo ""; echo "
" ; GETFORMITEM($_SESSION[$thiss->DETECT_TABLE_COLUMN][FIND][$GETZAPSQL[WHAT_DESC][$value]],$_SESSION[$thiss->DETECT_TABLE_COLUMN][TYPE][$GETZAPSQL[WHAT_DESC][$value]],$GETZAPSQL[WHAT_DESC][$value]); echo "
Brak Danych" ; else { while ($h=mysql_fetch_row($result)) { echo ""; //TODO funkcje wykryte specyfuiczne dla tego menu // echo "DETECT_HIST_FUNCTION,HISTORY,$h[$GETZAPSQL[DESC_TO_KEY][ID]],'HISTORIA') ; CREATE_MENUFUNC_INIT_2($thiss->DETECT_EDIT_FUNCTION,EDIT,$h[$GETZAPSQL[DESC_TO_KEY][ID]],'EDYCJA') ; echo ""; if($_SESSION[DEBUG]) print_r($h); foreach ($GETZAPSQL[ID] as $value) { if(true) { echo ""; echo "$h[$value]";// . $_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value]; echo ""; } } echo "\n"; } } echo ""; return; } ?>