DETECT_TABLE_COLUMN]['SQL_WIEV_CURR_SQL'])) SQL_WIEV(); // connect to DB $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!"); // generate $GETZAPSQL 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!:.".htmlspecialchars($zapSQL)); $num_rows = mysql_num_rows($result); $_SESSION[$thiss->DETECT_TABLE_COLUMN]['MYSQL_NUM_ROWS_TOTAL'] = $num_rows; $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; 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(!empty($_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(!empty($_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(!empty($_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(isset($_SESSION[$thiss->DETECT_TABLE_COLUMN]['FUNCPERMEDIT']['NEW_RECORD']) && strstr($_SESSION[$thiss->DETECT_TABLE_COLUMN]['FUNCPERMEDIT']['NEW_RECORD'], "X")) { CREATE_MENUFUNC_INIT_2('NEW_RECORD', 'NEW_RECORD', '', '( NOWY_REKORDNOWY_REKORD )') ; } if (!empty($params['toolbar'])) { $sep_out = "  |  "; echo $sep_out . implode($sep_out, $params['toolbar']); } echo "\n" . ''; echo''; //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 //@2012-10-12 warning clearing by sqix if(isset($_SESSION[$thiss->DETECT_TABLE_COLUMN]['MENU_FIND'])) 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) echo''; 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 = (isset($_SESSION[$thiss->DETECT_TABLE_COLUMN]['DESC_TO_LANG'][$GETZAPSQL['WHAT_DESC'][$value]]))? $_SESSION[$thiss->DETECT_TABLE_COLUMN]['DESC_TO_LANG'][$GETZAPSQL['WHAT_DESC'][$value]] : ''; if(isset($_SESSION[$thiss->DETECT_TABLE_COLUMN]['SORTED'][$GETZAPSQL['WHAT_DESC'][$value]]) && $_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(isset($_SESSION[$thiss->DETECT_TABLE_COLUMN]['USERS_SORTER_SQL']) && $_SESSION[$thiss->DETECT_TABLE_COLUMN]['USERS_SORTER_SQL']) { if(isset($_SESSION[$thiss->DETECT_TABLE_COLUMN]['SORTED'][$GETZAPSQL['WHAT_DESC'][$value]]))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) . "
"; echo '' . '' . ' . ''; echo ""; 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], array('multiple'=>true)); echo "
'."Brak Danych"; return; } $t = 0; while ($h = mysql_fetch_row( $result )) { echo ''; echo ''; //TODO funkcje wykryte specyfuiczne dla tego menu // echo "DETECT_TABLE_COLUMN]['FUNCPERMEDIT']['NEW_RECORD']) && strstr($_SESSION[$thiss->DETECT_TABLE_COLUMN]['FUNCPERMEDIT']['NEW_RECORD'], "X")) { $js = "return confirm('Czy na pewno chcesz utworzyć nowy rekord na podstawie danych z rekordu ID = ".$h[$GETZAPSQL['DESC_TO_KEY']['ID']]."?');"; echo ''."CP".''."  "; } CREATE_MENUFUNC_INIT_2($thiss->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) { echo ''; echo $h[$value];// . $_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC][$value]; echo ''; } echo ''."\n"; } echo''; echo ''; }