DETECT_TABLE_COLUMN][EDITRECORD][ID]==$_SESSION[$thiss->DETECT_TABLE_COLUMN]['WIEVID'])) $ERROR=$ERROR . " BRAK_AUTORYZACJI_DLA_ID" ; if(!(strstr($_SESSION[$thiss->DETECT_TABLE_COLUMN]['FUNCPERMEDIT']['A_PROBLEM'],'W'))) $ERROR=$ERROR . " BRAK_UPRAWNIEN_DO [$thiss->DETECT_TABLE_COLUMN][FUNCPERMEDIT][A_PROBLEM]=W" ; if((strlen($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'])>0) && (!($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM']=="UNVERIFIED"))) { ZAP_SQL("select ADM_ACCOUNT from ADMIN_USERS where ADM_ACCOUNT='$_POST[T_WORKPOINTS_USER]' and A_STATUS='NORMAL' and ADM_TECH_WORKER!='NO' and ADM_COMPANY like '$_SESSION[ADM_COMPANY]'"); if($_SESSION[MYSQL_NUM_ROWS]==1) $T_WORKPOINTS_USER_VAL="1"; //echo "HERE"; if((!(isset($ERROR))) && isset($_POST['A_PROBLEM']) && ($T_WORKPOINTS_USER_VAL==1) && (!($_POST['A_PROBLEM'])) && ($_POST['A_PROBLEM_DESC']) && ($_POST['T_WORKPOINTS_USER']) && ($_POST['T_WORKPOINTS_DATE']) && (isset($_POST['T_WORKPOINTS_VALUE'])) ) { if(!($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'])) $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM']="0" ; if(!($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_ACCOUNT']) || ($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_ACCOUNT']=="N/S;") ) $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_ACCOUNT']="0" ; $T_WORKPOINTS_VALUE = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_WORKPOINTS_VALUE'] + $_POST['T_WORKPOINTS_VALUE'] ; $P_ACCOUNT = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_ACCOUNT'] + $_POST['P_ACCOUNT'] ; if(!($_POST['P_ACCOUNT'])) $_POST['P_ACCOUNT'] = "N/S;" ; if(isset($_POST['DO_APPOITMENT_CLEAR'])) $ZAP_SQL_APPOITMENT = "L_APPOITMENT_DATE='', L_APPOITMENT_USER='', L_APPOITMENT_PERIOD='', L_APPOITMENT_TYPE='', L_APPOITMENT_INFO=''"; $A_PROBLEM_DATE=date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i) ; unset($ZAP_FIELD); unset($ZAP_VAL) ; unset($ZAP_UPD) ; //zapisanie dodatkowego info do bazy technicznej, ze wystawiono platny problem lub dano upust @2012-09-25 if((isset($_POST['DO_DISCONNECT_REPORT']))&&(strlen($_POST['DO_DISCONNECT_REPORT_FROM'])>8) && (strlen($_POST['T_WORKPOINTS_DATE'])>8) ) { $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM_DESC'].="(sys : DO_DISCONNECT_REPORT_FROM ".$_POST['DO_DISCONNECT_REPORT_FROM'].")"; $_POST['A_PROBLEM_DESC'].="(sys : DO_DISCONNECT_REPORT_FROM ".$_POST['DO_DISCONNECT_REPORT_FROM'].")"; } if((isset($_POST['T_WORKPOINTS_DATE']))&&(strlen($_POST['P_ACCOUNT'])>0)&&($_POST['P_ACCOUNT']<>"N/S;")) { $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM_DESC'].="(sys : P_ACCOUNT ".$_POST['P_ACCOUNT'].")"; $_POST['A_PROBLEM_DESC'].="(sys : P_ACCOUNT ".$_POST['P_ACCOUNT'].")"; } if($_SESSION[$thiss->DETECT_TABLE_COLUMN]['DESC_TO_KEY']['P_ACCOUNT']) { $ZAP_FIELD.=" , P_ACCOUNT "; $ZAP_VAL.=" , '".$_POST['P_ACCOUNT']."' "; $ZAP_UPD.=" , P_ACCOUNT='".$P_ACCOUNT."' " ; } $ZAP_SQL_HIST = "insert into ".$thiss->DETECT_TABLE_NAME."_HIST (ID, ID_USERS2, A_RECORD_UPDATE_DATE, A_RECORD_UPDATE_AUTHOR , A_PROBLEM, A_PROBLEM_DESC, T_WORKPOINTS_USER, T_WORKPOINTS_VALUE, T_WORKPOINTS_DATE, T_WORKPOINTS_TYPE $ZAP_FIELD ) values ('','" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID'] . "', '".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."', '".$_SESSION['ADM_ACCOUNT']."', '$_POST[A_PROBLEM]', '$_POST[A_PROBLEM_DESC] ($_SESSION[ADM_ACCOUNT])', '$_POST[T_WORKPOINTS_USER]', '$_POST[T_WORKPOINTS_VALUE]', '$_POST[T_WORKPOINTS_DATE]','$_POST[T_WORKPOINTS_TYPE]' $ZAP_VAL )"; $ZAP_SQL = "update ".$thiss->DETECT_TABLE_NAME." SET $ZAP_SQL_APPOITMENT, A_RECORD_UPDATE_DATE='".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."', A_RECORD_UPDATE_AUTHOR='".$_SESSION[ADM_ACCOUNT]."' , A_PROBLEM='$_POST[A_PROBLEM]', A_PROBLEM_DESC='$_POST[A_PROBLEM_DESC] ($_SESSION[ADM_ACCOUNT])', A_PROBLEM_DATE='$A_PROBLEM_DATE', T_WORKPOINTS_USER='$_POST[T_WORKPOINTS_USER]',T_WORKPOINTS_VALUE='$T_WORKPOINTS_VALUE', T_WORKPOINTS_DATE='$_POST[T_WORKPOINTS_DATE]',T_WORKPOINTS_TYPE='$_POST[T_WORKPOINTS_TYPE]' $ZAP_UPD where ID='" . $_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][ID] . "'"; ZAP_SQL_UPDATE($ZAP_SQL_HIST); $RESULT=$_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; ZAP_SQL_UPDATE($ZAP_SQL); $RESULT=$RESULT + $_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; //TYP 14 - reklamacja //Wykrycie tabeli nazwy tabeli SES_X_C if(substr($thiss->DETECT_TABLE_NAME,0,4)=='SES_' && substr($thiss->DETECT_TABLE_NAME,-2)=='_A') { // echo "

Detect table name=:".$thiss->DETECT_TABLE_NAME."

"; $SES_C_COLUMN=substr($thiss->DETECT_TABLE_NAME,0,(strlen($thiss->DETECT_TABLE_NAME)-1))."C" ; //$SES_C_COLUMN.="___C"; //echo "

SES_C_COLUMN_TO:: ".$SES_C_COLUMN."

"; if((isset($_POST['DO_DISCONNECT_REPORT']))&&(strlen($_POST['DO_DISCONNECT_REPORT_FROM'])>8) && (strlen($_POST['T_WORKPOINTS_DATE'])>8) ) { ZAP_SQL_UPDATE("insert into ".$SES_C_COLUMN." (ID,ID_SERVICES,ID_BILLING_USERS,TYPE,VALUE1,VALUE2) values ('','".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID_SERVICES']."','".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID_BILLING_USERS']."','14','".$_POST['DO_DISCONNECT_REPORT_FROM']."','".$_POST['T_WORKPOINTS_DATE']."')") ;$RESULT+=$_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; } if((isset($_POST['T_WORKPOINTS_DATE']))&&(strlen($_POST['P_ACCOUNT'])>0)&&($_POST['P_ACCOUNT']<>"N/S;")) { ZAP_SQL_UPDATE("insert into ".$SES_C_COLUMN." (ID,ID_SERVICES,ID_BILLING_USERS,TYPE,VALUE1,VALUE2) values ('','".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID_SERVICES']."','".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID_BILLING_USERS']."','15','".$_POST['T_WORKPOINTS_DATE']."','".$_POST['P_ACCOUNT']."')") ;$RESULT+=$_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; } } echo "PASSED($RESULT)
"; } else { echo "

Podano zle zmienne lub nie wypelniono wszystkich pol(1)


Errory: $ERROR
"; print_r($_POST) ; } echo "
USUWAM PROBLEM
"; } else if(strlen($_POST['A_PROBLEM'])>1) { //EOF if(strlen($_SESSION[USERS_COLUMN][EDITRECORD][A_PROBLEM])>0) if(!($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID']==$_SESSION[$thiss->DETECT_TABLE_COLUMN]['WIEVID'])) $ERROR=$ERROR . " BRAK_AUTORYZACJI_DLA_ID" ; if(!(strstr($_SESSION[$thiss->DETECT_TABLE_COLUMN]['FUNCPERMEDIT']['A_PROBLEM'],'W'))) $ERROR=$ERROR . " BRAK_UPRAWNIEN_DO [$thiss->DETECT_TABLE_COLUMN][FUNCPERMEDIT][A_PROBLEM]=W" ; // ZAP_SQL("select ADM_ACCOUNT from ADMIN_USERS where ADM_ACCOUNT='$_POST[T_WORKPOINTS_USER]' and ADM_STATUS='NORMAL' and ADM_TECH_WORKER!='NO' and ADM_COMPANY like '$_SESSION[ADM_COMPANY]'"); //if($_SESSION[MYSQL_NUM_ROWS]==1) $T_WORKPOINTS_USER_VAL="1"; if((!(isset($ERROR))) && ($T_WORKPOINTS_USER_VAL==1) && ($_POST['A_PROBLEM']) && ($_POST['A_PROBLEM_DESC']) && ($_POST['A_PROBLEM_DATE'])) { $A_PROBLEM_DATE=date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i) ; $ZAP_SQL_HIST = "insert into ".$thiss->DETECT_TABLE_NAME."_HIST (ID, ID_USERS2, A_RECORD_UPDATE_DATE, A_RECORD_UPDATE_AUTHOR , A_PROBLEM, A_PROBLEM_DESC ) values ('','" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID'] . "', '".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."', '".$_SESSION['ADM_ACCOUNT']."', '".$_POST['A_PROBLEM']."', '".$_POST['A_PROBLEM_DESC']." (".$_SESSION['ADM_ACCOUNT'].")')"; $ZAP_SQL = "update ".$thiss->DETECT_TABLE_NAME." SET A_RECORD_UPDATE_DATE='".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."', A_RECORD_UPDATE_AUTHOR='".$_SESSION['ADM_ACCOUNT']."' , A_PROBLEM='".$_POST['A_PROBLEM']."', A_PROBLEM_DESC='".$_POST['A_PROBLEM_DESC']." (".$_SESSION['ADM_ACCOUNT'].")', A_PROBLEM_DATE='".$A_PROBLEM_DATE."' where ID='" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID'] . "'"; // echo "
$ZAP_SQL_HIST
$ZAP_SQL
"; ZAP_SQL_UPDATE($ZAP_SQL_HIST); $RESULT=$_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; ZAP_SQL_UPDATE($ZAP_SQL); $RESULT=$RESULT + $_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; //$_SESSION[USERS_COLUMN][EDITRECORD][S_ALIAS] if(isset($_POST['A_DB_USER_PROBLEM_REPORT_S_ALIAS_INFO'])) { $A_DB_USER_PROBLEM_REPORT_S_ALIAS_INFO="Zostal zgloszony problem dla Twojego adresu, Typ problemu to ".$_POST['A_PROBLEM']." (".$_POST['A_PROBLEM_DESC']."). Jezeli z jakichs przyczyn chcial(a)bys go odwolac - np. usluga zaczela poprawnie funkcjonowac, odpowiedz na tego maila, kasujac cala tresc (mozesz dodatkowo umiescic opis, uzywajac zwrotu ^opis problemu^), pozostawiajac jedynie: Odwoluje problem z dnia $A_PROBLEM_DATE ."; mail($_SESSION['USERS_COLUMN']['EDITRECORD']['S_ALIAS'], 'Potwierdzenie zgloszenia problemu, Odwolaj go, jezeli zaczelo wszystko dzialac poprawnie.', $A_DB_USER_PROBLEM_REPORT_S_ALIAS_INFO, "From: $AUTOBOK_EMAIL Automatyczne Biuro Obslugi <$AUTOBOK_EMAIL> Reply-To: $AUTOBOK_EMAIL") ; echo "
DODATKOWO WYSLANO WIADOMOSC UMOZLIWIAJACA SKASOWANIE PROBLEMU NA ". $_SESSION['USERS_COLUMN']['EDITRECORD']['S_ALIAS']."
"; } echo "PASSED(".$RESULT.")
"; } else { echo "

Podano zle zmienne lub nie wypelniono wszystkich pol


Errory: ".$ERROR."
"; // print_r($_POST); } //echo "DODAJE PROBLEM"; } else if((strlen($_POST['A_PROBLEM'])==0) && ($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM']=="UNVERIFIED")) { echo "KASOWANIE PROBLEMU UNVERIFIED"; if((!(isset($ERROR))) && (isset($_POST['A_PROBLEM'])) && ($_POST['A_PROBLEM_DESC']) && ($_POST['A_PROBLEM_DATE'])) { $ZAP_SQL_HIST = "insert into ".$thiss->DETECT_TABLE_NAME."_HIST (ID, ID_USERS2, A_RECORD_UPDATE_DATE, A_RECORD_UPDATE_AUTHOR , A_PROBLEM, A_PROBLEM_DESC ) values ('','" . $_SESSION['USERS_COLUMN']['EDITRECORD']['ID'] . "', '".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."', '".$_SESSION['ADM_ACCOUNT']."', '".$_POST['A_PROBLEM']."', '".$_POST['A_PROBLEM_DESC']."')"; $ZAP_SQL = "update ".$thiss->DETECT_TABLE_NAME." SET A_PROBLEM='".$_POST['A_PROBLEM']."', A_PROBLEM_DESC='".$_POST['A_PROBLEM_DESC']." (".$_SESSION['ADM_ACCOUNT'].")', A_PROBLEM_DATE='" . date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."' where ID='" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID'] . "'"; // echo "
$ZAP_SQL_HIST
$ZAP_SQL
"; ZAP_SQL_UPDATE($ZAP_SQL_HIST); $RESULT=$_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; ZAP_SQL_UPDATE($ZAP_SQL); $RESULT=$RESULT + $_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; } } //EOF else if(strlen($_SESSION[USERS_COLUMN][EDITRECORD][A_PROBLEM])>0) } /* else if($_SESSION['CURRENT_MENU']=="USERS_EDIT") { //EOF if($_SESSION[CURRENT_MENU]==A_PROBLEM) if($_POST) { $ZAP_SQL_UPDATE = "update USERS2 set A_RECORD_UPDATE_DATE='".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."',A_RECORD_UPDATE_AUTHOR='".$_SESSION[ADM_ACCOUNT]."'"; $ZAP_SQL_HISTORY_F = "insert into USERS2_HIST (ID,A_RECORD_UPDATE_DATE,A_RECORD_UPDATE_AUTHOR,ID_USERS2"; $ZAP_SQL_HISTORY_V = ") values ('','".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."','".$_SESSION['ADM_ACCOUNT']."','".$_SESSION[USERS_COLUMN][WIEVID]."'"; foreach ($_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC] as $value) { if(strstr($_SESSION[$thiss->DETECT_TABLE_COLUMN][PERMEDIT]["$value"],W)) $_SESSION[$thiss->DETECT_TABLE_COLUMN][EDIT_TEMPLATE][$value]=$_POST[$value]; if(($_SESSION[$thiss->DETECT_TABLE_COLUMN][WIEVID]==$_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][ID]) && (isset($_POST["$value"])) && (!($_POST["$value"]==$_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][$value]))) { if(($_SESSION[$thiss->DETECT_TABLE_COLUMN][TYPESPECIAL][$value])) { $_SESSION[$thiss->DETECT_TABLE_COLUMN][TYPESPECIAL][$value](POST_VERIFY) ; } } } foreach ($_SESSION[USERS_COLUMN]['DESC'] as $value) { if(($_SESSION[USERS_COLUMN][WIEVID]==$_SESSION[USERS_COLUMN][EDITRECORD][ID]) &&(isset($_POST["$value"])) && ($_POST["$value"]!=$_SESSION[USERS_COLUMN][EDITRECORD]["$value"]) && (strstr($_SESSION[USERS_COLUMN][PERMEDIT]["$value"],'W'))) { $ZAP_SQL_UPDATE = $ZAP_SQL_UPDATE . ",$value='".$_POST["$value"]."' "; $ZAP_SQL_HISTORY_F = $ZAP_SQL_HISTORY_F . ",$value"; $ZAP_SQL_HISTORY_V = $ZAP_SQL_HISTORY_V . ",'". $_POST["$value"]. "'"; // $_SESSION[USERS_COLUMN][FIND]["$value"] = $_POST[$value] ; // $_SESSION[USERS_COLUMN][FINDSQL] = $_SESSION[USERS_COLUMN][FINDSQL] . " and $value like '$_POST[$value]' "; } } //EOF foreach1 } //EOF post $ZAP_SQL_HISTORY = $ZAP_SQL_HISTORY_F . $ZAP_SQL_HISTORY_V . ");" ; $ZAP_SQL_UPDATE = $ZAP_SQL_UPDATE . " where ID='" . $_SESSION['USERS_COLUMN']['WIEVID'] . "' " ; //echo "
$ZAP_SQL_UPDATE
$ZAP_SQL_HISTORY
"; if(!($error)) { ZAP_SQL_UPDATE($ZAP_SQL_HISTORY); $RESULT=$_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; ZAP_SQL_UPDATE($ZAP_SQL_UPDATE); $RESULT=$RESULT + $_SESSION['MYSQL_UPDATE_NUM_ROWS'] ; echo "PASSED($RESULT)
"; } } */ else if(($_SESSION['CURRENT_MENU']=="NEW_EXTRA_SERVICES")) { //EOF if($_SESSION[CURRENT_MENU]==USERS_EDIT) echo "AKTUALIZACJA DLA [CURRENT_MENU]==NEW_EXTRA_SERVICES"; $ZAP_SQL_INSERT_F = "insert into $thiss->DETECT_TABLE_NAME (ID,A_RECORD_UPDATE_DATE,A_RECORD_UPDATE_AUTHOR,A_RECORD_CREATE_DATE,A_RECORD_CREATE_AUTHOR"; $ZAP_SQL_INSERT_V = ") values ('','".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."','".$_SESSION[ADM_ACCOUNT]."','".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."','".$_SESSION[ADM_ACCOUNT]."'"; foreach ($_SESSION[$thiss->DETECT_TABLE_COLUMN]['DESC'] as $value) { // echo ""; if(isset($_POST[$value])) { $_SESSION[$thiss->DETECT_TABLE_COLUMN]['NEWDEAL'][$value]=$_POST[$value]; $ZAP_SQL_INSERT_F = $ZAP_SQL_INSERT_F . ",$value"; $ZAP_SQL_INSERT_V = $ZAP_SQL_INSERT_V . ",'". $_POST["$value"]. "'"; } } $ZAP_SQL_INSERT = $ZAP_SQL_INSERT_F . $ZAP_SQL_INSERT_V . ");" ; echo "**** $ZAP_SQL_INSERT *** TODO ***"; // ZAP_SQL_UPDATE($ZAP_SQL_INSERT); $RESULT=$_SESSION[MYSQL_UPDATE_NUM_ROWS] ; } else if ($_SESSION['CURRENT_MENU'] == 'M_DIST_DESC_HTML') { //echo'
edit - thiss: ';print_r($thiss);echo'
'; if ($thiss->DETECT_TABLE_NAME == 'IN7_MK_BAZA_DYSTRYBUCJI' // aktualna tabela to IN7_MK_BAZA_DYSTRYBUCJI && array_key_exists('M_DIST_DESC_HTML', $_REQUEST) // sa dane w requescie && $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID'] > 0 // jest ID edytowanego rekordu ) { global $thiss, $conn; $obj = new stdClass(); $obj->ID = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID']; $obj->A_RECORD_CREATE_DATE = date('Y')."-".date('m')."-".date('d')."-".date('H').":".date('i'); $obj->A_RECORD_CREATE_AUTHOR = $_SESSION['ADM_ACCOUNT']; $obj->A_RECORD_UPDATE_DATE = date('Y')."-".date('m')."-".date('d')."-".date('H').":".date('i'); $obj->A_RECORD_UPDATE_AUTHOR = $_SESSION['ADM_ACCOUNT']; $field = 'M_DIST_DESC_HTML'; $obj->M_DIST_DESC_HTML = $_REQUEST[$field]; $obj->M_DIST_DESC_HTML = addslashes($_REQUEST[$field]); //$obj->M_DIST_DESC_HTML = mysql_real_escape_string($_REQUEST[$field], $conn); if ($_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPESPECIAL'][$field]) { $_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPESPECIAL'][$field]('POST_VERIFY', $obj->M_DIST_DESC_HTML); } $sql_set = array();// update $sql_set []= "`M_DIST_DESC_HTML`='" . $obj->M_DIST_DESC_HTML . "'"; $sql_set []= "`A_RECORD_UPDATE_DATE`='" . $obj->A_RECORD_UPDATE_DATE . "'"; $sql_set []= "`A_RECORD_UPDATE_AUTHOR`='" . $obj->A_RECORD_UPDATE_AUTHOR . "'"; $sql_arr_hist = array();// insert into HIST table $sql_arr_hist['ID'] = "''"; $sql_arr_hist['ID_USERS2'] = "'" . $obj->ID . "'"; $sql_arr_hist['A_RECORD_CREATE_DATE'] = "'" . $obj->A_RECORD_CREATE_DATE . "'"; $sql_arr_hist['A_RECORD_CREATE_AUTHOR'] = "'" . $obj->A_RECORD_CREATE_AUTHOR . "'"; $sql_arr_hist['A_RECORD_UPDATE_DATE'] = "'" . $obj->A_RECORD_UPDATE_DATE . "'"; $sql_arr_hist['A_RECORD_UPDATE_AUTHOR'] = "'" . $obj->A_RECORD_UPDATE_AUTHOR . "'"; $sql_arr_hist['M_DIST_DESC_HTML'] = "'" . $obj->M_DIST_DESC_HTML . "'"; if (!$error) { $ZAP_SQL_INSERT = "insert into `" . $thiss->DETECT_TABLE_NAME . "_HIST` (".implode(",", array_keys($sql_arr_hist)).") values(".implode(",", array_values($sql_arr_hist))."); "; $ZAP_SQL = "update `" . $thiss->DETECT_TABLE_NAME . "` set ".implode(",", $sql_set)." where `ID`='" . $obj->ID . "' limit 1; "; //echo'
ZAP_SQL_INSERT: ';print_r($ZAP_SQL_INSERT);echo'
'; //echo'
ZAP_SQL: ';print_r($ZAP_SQL);echo'
'; ZAP_SQL_UPDATE($ZAP_SQL); $RESULT = $_SESSION['MYSQL_UPDATE_NUM_ROWS']; ZAP_SQL_UPDATE($ZAP_SQL_INSERT); $RESULT = $RESULT + $_SESSION['MYSQL_UPDATE_NUM_ROWS']; if ($RESULT > 0) {// data saved $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['M_DIST_DESC_HTML'] = $obj->M_DIST_DESC_HTML; } } } else { // TODO: error } } //echo " Fnction UPDATEDB "; //print_r($_POST); //CREATE_MENU_INIT(USERS_FILTER_PROBLEM,PROBLEM,PROBLEMY); echo "

AKTUALIZACJA DANYCH: "; $WYMAGANY_RESULT=2 ; if(isset($_POST['DO_DISCONNECT_REPORT'])) $WYMAGANY_RESULT++ ; if((isset($_POST['T_WORKPOINTS_DATE']))&&(strlen($_POST['P_ACCOUNT'])>0)&&($_POST['P_ACCOUNT']<>"N/S;")) $WYMAGANY_RESULT++ ; if($RESULT==$WYMAGANY_RESULT) echo "OK($RESULT)"; else { echo "ERROR($RESULT,$ERROR ".$error.")"; // print_r($_POST); // print_r($_SESSION); } echo "

"; CREATE_MENUFUNC_NOTD_INIT($_SESSION['LAST_MENU'],'POWROT DO ' . $_SESSION['LAST_MENU']); echo " | "; CREATE_MENUFUNC_NOTD_INIT($_SESSION['CURRENT_MENU'],'POWROT DO ' . $_SESSION['CURRENT_MENU']); if(!($RESULT==2)) { echo " | "; CREATE_MENUFUNC_INIT_2($_SESSION['CURRENT_MENU'],'','RESTORE','POWROT_I_POPRAWA_DANYCH') ; } echo "
"; $MENU_INIT='MENU'; }