Blad w tworzeniu funkcji widoku/edycji (".$filename.").";
DEBUG_S(-2, "Blad w tworzeniu funkcji widoku/edycji (".$filename.")",'',__FILE__, __FUNCTION__, __LINE__);
exit;
}
*/
// echo "
Stworzono funkcje do edycji/widoku tabeli ".$filename.".";
DEBUG_S(2, "Stworzono funkcje do edycji/widoku tabeli: " ,$string_funkcji,__FILE__, __FUNCTION__, __LINE__);
} //eof if function_exists
SEF($INIT_TABLE."_HIST");
if(!function_exists($INIT_TABLE."_HIST")) {
/* $filename="column_init/superedit-".$INIT_TABLE."_HIST.php";
if (!$handle = fopen($filename, 'x+')) {
echo "Cannot open file (".$filename.")";
exit;
}
*/
$string_funkcji="
function ".$INIT_TABLE."_HIST() {
// init columns if not set
if (empty(\$_SESSION['".$INIT_TABLE."_COLUMN']['ID'])) {
SEF('USERS_COLUMN_INIT2');
USERS_COLUMN_INIT2('".$INIT_TABLE."', '".$EXTRACOLUMN."', '".$PERM_MASK."');
}
SEF('WIEVTABLE_HIST');
WIEVTABLE_HIST();
}
";
$_SESSION['INIT_TABLE_FILE'][$INIT_TABLE."_HIST"]=$string_funkcji;
/* if (fwrite($handle, $string_funkcji) === FALSE) {
echo "
Blad w tworzeniu funkcji widoku/edycji (".$filename.").";
exit;
}
echo "
Stworzono funkcje do edycji/widoku tabeli ".$filename.".";
*/
} //eof if function_exists
SEF($INIT_TABLE."_EDIT");
if(!function_exists($INIT_TABLE."_EDIT")) {
/* $filename="column_init/superedit-".$INIT_TABLE."_EDIT.php";
if (!$handle = fopen($filename, 'x+')) {
echo "Cannot open file (".$filename.")";
exit;
}
*/
$string_funkcji="
function ".$INIT_TABLE."_EDIT() {
// init columns if not set
if (empty(\$_SESSION['".$INIT_TABLE."_COLUMN']['ID'])) {
SEF('USERS_COLUMN_INIT2');
USERS_COLUMN_INIT2('".$INIT_TABLE."', '".$EXTRACOLUMN."', '".$PERM_MASK."');
}
SEF('EDIT_TABLE_RECORD');
EDIT_TABLE_RECORD();
}
";
$_SESSION['INIT_TABLE_FILE'][$INIT_TABLE."_EDIT"]=$string_funkcji;
/*
if (fwrite($handle, $string_funkcji) === FALSE) {
echo "
Blad w tworzeniu funkcji widoku/edycji (".$filename.").";
exit;
}
echo "
Stworzono funkcje do edycji/widoku tabeli ".$filename.".";
*/
} //eof if function_exists
if(empty($GENCONF)) { //jezeli tylko byla opcja zrobienia konfiga, to wychodzimy
echo ".".$INIT_TABLE." ";
$COLUMN = $INIT_TABLE;
// clean session data
$_SESSION[$COLUMN."_COLUMN"]['DESC'] = array();
$_SESSION[$COLUMN."_COLUMN"]['TYPE'] = array();
$_SESSION[$COLUMN."_COLUMN"]['ID'] = array();
$_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY'] = array();
$_SESSION[$COLUMN."_COLUMN"]['HIDE'] = array();
//$EXTRACOLUMN=" ";
$EXTRACOLUMN = (!empty($EXTRACOLUMN))? explode(" ", $EXTRACOLUMN) : array();
//TODO2006-03 zapytanie w foreach
//inicjalizacja podrecznikowych zapytan do tabel dla jednej sesji
//jezeli nie zostalo to anulowane przy logowaniu:
if (!isset($_REQUEST['NOPREINIT'])) {
if (isset($_SESSION[$COLUMN."_COLUMN"]['RELATIVEDB']) && isset($_SESSION[$COLUMN."_COLUMN"]['RELATIVEDB']['SQL_QUERY'][0])) {
foreach ($_SESSION[$COLUMN."_COLUMN"]['RELATIVEDB']['SQL_QUERY'] as $value_key => $value) {
// echo "
Zainicjalizowano EXTRACOLUMN zapytanie value $value key $value_key
";
ZAP_SQL($value);
}
}
}
ZAP_SQL("show fields from $COLUMN");
$KEY = 0;
$_SESSION[$COLUMN."_COLUMN"]['PERMEDIT']['ID'] = "R";
$_SESSION[$COLUMN."_COLUMN"]['PERMEDIT']['A_RECORD_CREATE_DATE'] = "R";
$_SESSION[$COLUMN."_COLUMN"]['PERMEDIT']['A_RECORD_UPDATE_DATE'] = "R";
$_SESSION[$COLUMN."_COLUMN"]['PERMEDIT']['A_RECORD_UPDATE_AUTHOR'] = "R";
$_SESSION[$COLUMN."_COLUMN"]['PERMEDIT']['A_RECORD_CREATE_AUTHOR'] = "R";
while ($h = mysql_fetch_array($result)) {
$_SESSION[$COLUMN."_COLUMN"]['DESC']["$KEY"] = $h[0];
$_SESSION[$COLUMN."_COLUMN"]['TYPE'][$_SESSION[$COLUMN."_COLUMN"]['DESC']["$KEY"]] = $h[1];
if (!isset($_SESSION[$COLUMN."_COLUMN"]['PERMEDIT'][$h[0]])) {
$_SESSION[$COLUMN."_COLUMN"]['PERMEDIT'][$h[0]] = $PERM_MASK;
}
$_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY'][$h[0]] = $KEY;
$_SESSION[$COLUMN."_COLUMN"]['Default'][$h[0]] = $h['Default'];
$USERS_COLUMN_INIT2['DESC_TO_KEY'][$h[0]] = $KEY; // prawdziwe kolumny
$_SESSION[$COLUMN."_COLUMN"]['ID']["$KEY"] = $KEY;
if(isset($_SESSION['USER_PROFILE'][$COLUMN."_COLUMN"]["$KEY"]))
if (isset($_SESSION['USER_PROFILE'][$COLUMN."_COLUMN"]) && $_SESSION['USER_PROFILE'][$COLUMN."_COLUMN"]["$KEY"] == "HIDE") {
$_SESSION[$COLUMN."_COLUMN"]['HIDE']["$KEY"] = 'HIDE';
}
$KEY++;
}
foreach ($EXTRACOLUMN as $h) {
if (in_array($h,$_SESSION[$COLUMN."_COLUMN"]['DESC'])) {
continue; //@2013-01-21 blad podwojnej kolumny
}
$_SESSION[$COLUMN."_COLUMN"]['DESC']["$KEY"] = $h;
$_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY'][$h] = $KEY;
if (!isset($_SESSION[$COLUMN."_COLUMN"]['PERMEDIT'][$h])) {
$_SESSION[$COLUMN."_COLUMN"]['PERMEDIT'][$h] = "N";
}
$_SESSION[$COLUMN."_COLUMN"]['ID']["$KEY"] = $KEY;
$TEMP1=$_SESSION[$COLUMN."_COLUMN"]['DESC']["$KEY"];
$_SESSION[$COLUMN."_COLUMN"]['TYPE'][$_SESSION[$COLUMN."_COLUMN"]['DESC']["$KEY"]] = "varchar(245)";
if(isset($_SESSION['USER_PROFILE'][$COLUMN."_COLUMN"]["$KEY"]))
if (isset($_SESSION['USER_PROFILE'][$COLUMN."_COLUMN"]) && $_SESSION['USER_PROFILE'][$COLUMN."_COLUMN"]["$KEY"] == "HIDE") {
$_SESSION[$COLUMN."_COLUMN"]['HIDE']["$KEY"] = 'HIDE';
}
$KEY++;
}
//@2012-10-17 jezeli tabela jest SES_XXX_A to T_WHEN_CONNECTED oraz inne powinno byc TYPESPECIAL
if(substr($COLUMN,0,4)=='SES_' && substr($COLUMN,-2)=='_A') {
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['T_WHEN_CONNECTED']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['T_WHEN_CONNECTED'] = 'T_WHEN_CONNECTED';
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['A_STATUS']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['A_STATUS']="A_STATUS";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['A_STATUS_CURRENT']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['A_STATUS_CURRENT']="A_STATUS_CURRENT";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['A_ADM_COMPANY']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['A_ADM_COMPANY']="A_ADM_COMPANY";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['P_SERVICE_QUOTA_PROFILE']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['P_SERVICE_QUOTA_PROFILE']="P_SERVICE_QUOTA_PROFILE";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['P_SERVICE_QUOTA']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['P_SERVICE_QUOTA']="P_SERVICE_QUOTA";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['T_NETWORK_SERVER']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['T_NETWORK_SERVER']="T_NETWORK_SERVER";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['T_TELBOX_ADDRESS']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['T_TELBOX_ADDRESS']="T_TELBOX_ADDRESS";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['P_SERVICE']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['P_SERVICE']="P_SERVICE";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['N_AVG_TRAFFIC']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['N_AVG_TRAFFIC']="N_AVG_TRAFFIC";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['A_PROBLEM']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['A_PROBLEM']="A_PROBLEM";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['T_WHO_CONNECTED']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['T_WHO_CONNECTED']="T_WHO_CONNECTED";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['L_APPOITMENT_USER']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['L_APPOITMENT_USER']="L_APPOITMENT_USER";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['L_APPOITMENT_DATE']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['L_APPOITMENT_DATE']="L_APPOITMENT_DATE";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['A_STATUS_CURRENT']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['L_APPOITMENT_PERIOD']="L_APPOITMENT_PERIOD";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['P_DEALNUMBER']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['P_DEALNUMBER']="P_DEALNUMBER";
if(isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['S_HW']))
$_SESSION[$COLUMN."_COLUMN"]['TYPESPECIAL']['S_HW']="S_HW";
}
//@2012-10-15 test czy sa odpowiednie kolumny w tabeli :
$USERS_COLUMN_INIT2['REQUEST_COLUMN']=array(
'A_RECORD_CREATE_DATE'=>'varchar(30)','A_RECORD_CREATE_AUTHOR'=>'varchar(100) not null',
'A_RECORD_UPDATE_DATE'=>'varchar(30)','A_RECORD_UPDATE_AUTHOR'=>'varchar(100) not null',
'L_APPOITMENT_DATE'=>'varchar(30) not null',
'L_APPOITMENT_USER'=>"varchar(100) not null",
'L_APPOITMENT_PERIOD'=>"varchar(4) not null",
'L_APPOITMENT_INFO'=>"varchar(255) not null",
'L_APPOITMENT_TYPE'=>"enum('', 'ARRANGED', 'TO_ARRANGE', 'CANCELLED', 'TO_CANCEL', 'RELATE', 'WAIT')",
'A_PROBLEM'=>"enum('', 'WARNING', 'PROBLEM', 'SERIOUS', 'UNVERIFIED')",
'A_PROBLEM_DESC'=>'varchar(255) not null',
'A_PROBLEM_DATE'=>'varchar(30) not null',
'A_STATUS'=>"enum('WAITING', 'NORMAL', 'MONITOR', 'WARNING', 'OFF_SOFT', 'OFF_HARD', 'DELETED')",
'A_STATUS_INFO'=>"varchar(255) not null",
'A_ADM_COMPANY'=>'varchar(100) not null',
'T_WORKPOINTS'=>"varchar(100) not null",
'T_WORKPOINTS_VALUE'=>"varchar(100) not null",
'T_WORKPOINTS_TYPE'=>"varchar(100) not null",
'T_WORKPOINTS_USER'=>"varchar(100) not null",
'T_WORKPOINTS_DATE'=>"varchar(100) not null",
'P_ACCOUNT'=>"varchar(40) not null"
);
if(!in_array($COLUMN,$special_tables_ignore_fields)) { //ignorowanie specjalnych kolumn
foreach($USERS_COLUMN_INIT2['REQUEST_COLUMN'] as $tst_column=>$tst_type) {
if(!isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY'][$tst_column])) {
if(!isset($ZAP_SQL_upd_struct)) settype($ZAP_SQL_upd_struct,"string");
$ZAP_SQL_upd_struct.="\n alter table ".$INIT_TABLE." add ".$tst_column." ".$tst_type." ; " ;
echo "
Brak Kolumny: ".$tst_column." w tabeli: ".$COLUMN." ." ;
}
}
$COLUMN = $INIT_TABLE."_HIST";
//sprawdzam czy jest tabela historyczna
ZAP_SQL("show tables like '".$COLUMN."'");
if(mysql_num_rows($result)!=1) { echo "
Brak tabeli historycznej!: ".$COLUMN." ";
if(!isset($ZAP_SQL_upd_struct)) settype($ZAP_SQL_upd_struct,"string");
$ZAP_SQL_upd_struct.="\n CREATE TABLE `".$COLUMN."` (
`ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`ID_USERS2` INT( 11 ) NOT NULL ,
PRIMARY KEY ( `ID` ) ,
INDEX ( `ID_USERS2` )
) TYPE = MYISAM ;";
} else { //jest tabela historyczna
// echo "
Jest tabela ".$COLUMN;
ZAP_SQL("show fields from $COLUMN");
$KEY = 0;
while ($h = mysql_fetch_row($result)) {
$_SESSION[$COLUMN."_COLUMN"]['DESC']["$KEY"] = $h[0];
$_SESSION[$COLUMN."_COLUMN"]['TYPE'][$_SESSION[$COLUMN."_COLUMN"]['DESC']["$KEY"]] = $h[1];
if (!isset($_SESSION[$COLUMN."_COLUMN"]['PERMEDIT'][$h[0]])) {
$_SESSION[$COLUMN."_COLUMN"]['PERMEDIT'][$h[0]] = "RW";
}
$_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY'][$h[0]] = $KEY;
$_SESSION[$COLUMN."_COLUMN"]['ID']["$KEY"] = $KEY;
if (isset($_SESSION['USER_PROFILE'][$COLUMN."_COLUMN"]) && $_SESSION['USER_PROFILE'][$COLUMN."_COLUMN"]["$KEY"] == "HIDE") {
$_SESSION[$COLUMN."_COLUMN"]['HIDE']["$KEY"] = 'HIDE';
}
$KEY++;
}
}
//uzupelnienie tabeli Historycznej!
foreach($USERS_COLUMN_INIT2['DESC_TO_KEY'] as $tst_column=>$tst_index) {
if(!isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY'][$tst_column])) {
if(!isset($ZAP_SQL_upd_struct)) settype($ZAP_SQL_upd_struct,"string");
$ZAP_SQL_upd_struct.="\n alter table ".$COLUMN." add ".$tst_column." varchar(255) default 'N/S;' ; " ;
echo "
Brak Kolumny: ".$tst_column." w tabeli: ".$COLUMN." ." ;
}
}
//czy jest odniesienie do ID_USERS2
if(!isset($_SESSION[$COLUMN."_COLUMN"]['DESC_TO_KEY']['ID_USERS2'])) {
if(!isset($ZAP_SQL_upd_struct)) settype($ZAP_SQL_upd_struct,"string");
$ZAP_SQL_upd_struct.="\n alter table ".$COLUMN." add ID_USERS2 int(11) ; " ;
$ZAP_SQL_upd_struct.="\n alter table ".$COLUMN." add INDEX(ID_USERS2) ; " ;
}
} //eof if $special_tables_ignore_fields
if(isset($ZAP_SQL_upd_struct)) echo "
W celu aktualizacji struktury wyzwol zapytanie: ".$ZAP_SQL_upd_struct ."
";
}
}