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] ." "; L_APPOITMENT_RESULT($zapSQL); if($_SESSION[DEBUG]) echo "
*ZAPSQL $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); $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][FINDSQL] . " ". $_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_SORTER_SQL] ." ".$_SESSION[$thiss->DETECT_TABLE_COLUMN][SQL_WIEV_CURR_SQL].""; //echo "$zapSQL"; //$result = mysql_query($zapSQL,$conn) or die("Blad zapytania2!"); L_APPOITMENT_RESULT($zapSQL); $num_rows = mysql_num_rows($result); 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,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_MENUFUNC_INIT(USERS_COLUMN_MENU,'WYBIERZ_KOLUMNY'); echo "
"; NAVIGATOR(); if(strstr($_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''; echo''; //echo "\n
"; echo ""; //echo "
HERE".$_SESSION[$thiss->DETECT_TABLE_COLUMN][ID]."*".$thiss->DETECT_TABLE_COLUMN."*"; foreach ($_SESSION[$thiss->DETECT_TABLE_COLUMN][ID] as $value) { if(!$_SESSION[$thiss->DETECT_TABLE_COLUMN][HIDE][$value]==HIDE) { echo ""; } } echo " \n"; //SECOND_ROW if($_SESSION[$thiss->DETECT_TABLE_COLUMN][MENU_FIND]==ENABLE) { echo ""; foreach ($_SESSION[$thiss->DETECT_TABLE_COLUMN][ID] as $value) { if(!$_SESSION[$thiss->DETECT_TABLE_COLUMN][HIDE][$value]==HIDE) { 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) 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 "" ; if($_SESSION[$thiss->DETECT_TABLE_COLUMN][SORTED][$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value]]==PRI) $border=1; else $border=0; // echo "sortuj"; CREATE_MENU_NOTD_INIT_2(USERS_SORTER,USERS_SORTER,USERS_SORTER1,$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value],'SORTUJSORTUJ') ; if($_SESSION[$thiss->DETECT_TABLE_COLUMN][USERS_SORTER_SQL]) { if($_SESSION[$thiss->DETECT_TABLE_COLUMN][SORTED][$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value]]==SEC) $border=1; else $border=0; // echo "sortuj"; CREATE_MENU_NOTD_INIT_2(USERS_SORTER,USERS_SORTER,USERS_SORTER2,$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value],'sortuj') ; } CREATE_MENU_NOTD_INIT_3(USERS_COLUMN,$value,HIDE,'sortuj') ; echo "
" . $_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value] . "
"; CREATE_MENU_NOTD_INIT_3(FILTER_SEARCH,MENU_FIND,'','X'); echo ""; echo "
" ; GETFORMITEM($_SESSION[$thiss->DETECT_TABLE_COLUMN][FIND][$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value]],$_SESSION[$thiss->DETECT_TABLE_COLUMN][TYPE][$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value]],$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value]); echo "
Brak Danych" ; else { $t = 0; echo''; while ($h=mysql_fetch_row($result)) { echo ''; echo ''; //TODO funkcje wykryte specyfuiczne dla tego menu // echo "DETECT_HIST_FUNCTION) CREATE_MENUFUNC_INIT_2($thiss->DETECT_HIST_FUNCTION,HISTORY,$h[$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC_TO_KEY][ID]],'HISTORIA') ; if($thiss->DETECT_EDIT_FUNCTION) CREATE_MENUFUNC_INIT_2($thiss->DETECT_EDIT_FUNCTION,EDIT,$h[$_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC_TO_KEY][ID]],'EDYCJA') ; echo ""; foreach ($_SESSION[$thiss->DETECT_TABLE_COLUMN][ID] as $value) { if(!$_SESSION[$thiss->DETECT_TABLE_COLUMN][HIDE][$value]==HIDE) { echo "DETECT_TABLE_COLUMN][DESC][$value],$h[$value],bgcolor); echo ">"; echo "$h[$value]";// . $_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value]; echo ""; } } echo "\n"; } echo''; } echo ""; return; }