' . "Wrong param proces tbl or id!" . ''; return; } $allowedTbls = array(); $allowedTbls[] = 'SES_USERS2_A'; $allowedTbls[] = 'SES_TV_A'; $allowedTbls[] = 'SES_VOIP_A'; $tblOut = htmlspecialchars($tbl); if (!in_array($tbl, $allowedTbls)) { echo '

' . "Table {$tblOut} not allowed!" . '

'; return; } Lib::loadClass('ProcesHelper'); $zasobID = ProcesHelper::getZasobTableID($tbl); if ($zasobID <= 0) { echo '

' . "Can't find table {$tblOut} zasob id!" . '

'; return; } $zasobObj = ProcesHelper::getZasobTableInfo($zasobID); if (!$zasobObj) { echo '

' . "Zasob id = {$zasobID} (tabela {$tlbOut}) nie istnieje" . '

'; return; } $userAcl = User::getAcl(); $userAcl->fetchGroups(); if (!$userAcl->hasTableAcl($zasobObj->ID)) { echo '

' . "Brak uprawnień do tabeli {$tblOut} (id zasobu: {$zasobObj->ID})" . '

'; return; } $tblAcl = $userAcl->getTableAcl($zasobObj->ID); $forceTblAclInit = ('1' == V::get('_force', '', $_GET)); $tblAcl->init($forceTblAclInit); echo'

$tblAcl (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($tblAcl);echo'

'; $problemFldsList = array(); $problemFldsList[] = 'A_PROBLEM'; $problemFldsList[] = 'A_PROBLEM_DATE'; $problemFldsList[] = 'A_PROBLEM_DESC'; $problemFldsList[] = 'T_WORKPOINTS_TYPE'; $problemFldsList[] = 'T_WORKPOINTS_DATE'; // P_ACCOUNT // Obciazenie Abonenta / P_ACCOUNT // DO_APPOITMENT_CLEAR // Skasowanie danych o spotkaniach APPOITMENTS / APPOITMENTS var CLEAR // ID_BILLING_USERS // DO_DISCONNECT_REPORT // DO_DISCONNECT_REPORT_FROM } //function A_PROBLEM($ID,$A_PROBLEM) { if (0) {// TODO: RMME - OLD VERSION global $thiss,$ARG1,$ARG1_VAL,$result,$error; if ($_SESSION['CURRENT_MENU'] == $thiss->DETECT_EDIT_FUNCTION || $_SESSION['LAST_MENU'] == $thiss->DETECT_EDIT_FUNCTION) { if ($_SESSION[$thiss->DETECT_TABLE_COLUMN]['WIEVID'] == $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID']) { // show action links if (strlen($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM']) > 0) { CREATE_MENUFUNC_INIT_2('A_PROBLEM', 'A_PROBLEM', 'REMOVE', 'USUN PROBLEM'); echo "

"; echo " | " ; if ($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'] == 'UNVERIFIED') { CREATE_MENUFUNC_INIT_2('A_PROBLEM', 'A_PROBLEM', 'ADD', 'USTAW_PROBLEM'); } if ($_SESSION['CURRENT_MENU'] == 'A_PROBLEM') CREATE_MENUFUNC_INIT_2('A_PROBLEM', 'ORDERER', 'POST', 'PRZESLIJ_ZLECENIE_MAIL'); if ($_SESSION['CURRENT_MENU'] == 'A_PROBLEM') echo " | " ; if ($_SESSION['CURRENT_MENU'] == 'A_PROBLEM') echo "DRUKUJ_ZLECENIE"; if ($_SESSION['CURRENT_MENU'] == 'A_PROBLEM') echo " | " ; } else { CREATE_MENUFUNC_INIT_2('A_PROBLEM', 'A_PROBLEM', 'ADD', 'DODAJ PROBLEM'); } // run action if (($_SESSION['CURRENT_MENU'] == 'A_PROBLEM') && (!($ARG1=='ORDERER'))) { echo "

"; if ($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'] == 'UNVERIFIED') { echo ""; } else if (strlen($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM']) > 0) { echo ""; } else { echo ""; } echo ""; if ((strlen($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM']) > 0) && (!($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'] == 'UNVERIFIED')) ) { echo ""; echo ""; echo ""; echo ""; if(substr($thiss->DETECT_TABLE_NAME,0,4)=='SES_' && substr($thiss->DETECT_TABLE_NAME,-2)=='_A') { echo ""; } echo ""; if(substr($thiss->DETECT_TABLE_NAME,0,4)=='SES_' && substr($thiss->DETECT_TABLE_NAME,-2)=='_A') { //wykrycie ID_BILLING_USERS jeżeli tabela SES_ ZAP_SQL("select ID_BILLING_USERS from SERVICES where ID='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID_SERVICES']."'"); list($ID_BILLING_USERS)=mysql_fetch_row($result); if(strlen($ID_BILLING_USERS)<1) { $error.=" Nie znaleziono ID_BILLING_USERS!!! "; } echo ""; echo ""; } } else { echo ""; } echo "

MENU ZGLASZANIA / USUWANIA PROBLEMOW
Rodzaj Problemu / Problem Level	"; GETFORMITEM($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'], $_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPE']['A_PROBLEM'], 'A_PROBLEM'); echo "(obecnie " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'] . ")
Rodzaj Problemu / Problem Level	"; echo ""; echo "Problem usuwany (obecnie " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'] . ")
Rodzaj Problemu / Problem Level	"; GETFORMITEM($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'], $_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPE']['A_PROBLEM'], 'A_PROBLEM'); echo "(obecnie " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'] . ")
Opis Problemu/Problem Description:	" ; GETFORMITEM($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM_DESC'], $_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPE']['A_PROBLEM_DESC'], 'A_PROBLEM_DESC'); echo "
Typ pracy / T_WORKPOINTS_TYPE	"; T_WORKPOINTS_TYPE_TYPES(); if (0) {//function T_WORKPOINTS_TYPE_TYPES() { $T_WORKPOINTS_TYPE_TYPES[1]['TYPE']='Technik_w_dyzurze'; $T_WORKPOINTS_TYPE_TYPES[2]['TYPE']='Administrator_w_godzinach'; $T_WORKPOINTS_TYPE_TYPES[3]['TYPE']='Technik_w_akordzie'; $T_WORKPOINTS_TYPE_TYPES[4]['TYPE']='Naprawa_gwarancyjna'; $T_WORKPOINTS_TYPE_TYPES[1]['VALUE']="TECH_AT_DUTY"; $T_WORKPOINTS_TYPE_TYPES[2]['VALUE']="ADMIN_AT_WORK"; $T_WORKPOINTS_TYPE_TYPES[3]['VALUE']="TECH_AT_CONTRACT"; $T_WORKPOINTS_TYPE_TYPES[4]['VALUE']="GUARANTY_SERVICE"; echo ""; // CREATE_MENU_NOTD_INIT_3(TEMPEDIT_EVAL,T_WORKPOINTS_TYPE,$value[VALUE],$value[TYPE]); // echo " \| "; } echo "
Data pracy / T_WORKPOINTS_DATE (YYYY-MM-DD)	"; GETFORMITEM($_SESSION[$thiss->DETECT_TABLE_COLUMN]['TEMPEDITRECORD']['T_WORKPOINTS_DATE'], $_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPE']['T_WORKPOINTS_DATE'], 'T_WORKPOINTS_DATE'); echo ""; T_WORKPOINTS_DATE_SELECT(); echo ""; echo "
Wykonawca pracy / T_WORKPOINTS_USER	"; T_WORKPOINTS_USER_SELECT(); echo "
Wartosc pracy / T_WORKPOINTS_VALUE	"; GETFORMITEM($_SESSION[$thiss->DETECT_TABLE_COLUMN]['TEMPEDITRECORD']['T_WORKPOINTS_VALUE'], $_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPE']['T_WORKPOINTS_VALUE'], 'T_WORKPOINTS_VALUE'); echo ""; T_WORKPOINTS_VALUE_TYPES(); if(0) {//function T_WORKPOINTS_VALUE_TYPES() { $T_WORKPOINTS_VALUE_TYPES[1]['TYPE']='BEZPLATNIE'; $T_WORKPOINTS_VALUE_TYPES[2]['TYPE']='USTERKA'; $T_WORKPOINTS_VALUE_TYPES[3]['TYPE']='USTERKA_PLATNA'; $T_WORKPOINTS_VALUE_TYPES[4]['TYPE']='PRZELACZENIE'; $T_WORKPOINTS_VALUE_TYPES[1]['VALUE']="0"; $T_WORKPOINTS_VALUE_TYPES[2]['VALUE']="16"; $T_WORKPOINTS_VALUE_TYPES[3]['VALUE']="19"; $T_WORKPOINTS_VALUE_TYPES[4]['VALUE']="20"; foreach ($T_WORKPOINTS_VALUE_TYPES as $value) { CREATE_MENU_NOTD_INIT_3('TEMPEDIT_EVAL', 'T_WORKPOINTS_VALUE', $value['VALUE'], $value['TYPE']); echo " \| "; } } echo ""; echo "
Obciazenie Abonenta / P_ACCOUNT	"; echo "";// $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_ACCOUNT'] echo ""; P_ACCOUNT_TYPES(); if(0) {//function P_ACCOUNT_TYPES() { $P_ACCOUNT_TYPES[1]['TYPE']='BEZPLATNIE'; $P_ACCOUNT_TYPES[2]['TYPE']='USTERKA_PLATNA_do_1g'; $P_ACCOUNT_TYPES[3]['TYPE']='USTERKA_PLATNA_do_2g'; $P_ACCOUNT_TYPES[1]['VALUE']=""; $P_ACCOUNT_TYPES[2]['VALUE']="30"; $P_ACCOUNT_TYPES[3]['VALUE']="60"; foreach ($P_ACCOUNT_TYPES as $value) { CREATE_MENU_NOTD_INIT_3('TEMPEDIT_EVAL', 'P_ACCOUNT', $value['VALUE'], $value['TYPE']); echo " \| "; } } echo ""; echo "
Skasowanie danych o spotkaniach APPOITMENTS / APPOITMENTS var CLEAR	"; echo ""; echo "
Uznanie dni niedzialania uslugi zgodnie z datą zgłoszenia i usunięcia usterki (YYYY-MM-DD HH-MM)	"; echo "OD:DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM_DATE']."\">, do dnia wykonania pracy"; echo "
Data Problemu / A_PROBLEM_DATE	"; if( (strlen($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM']) > 1) && (strlen($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM_DATE']) > 1)) { $TEMP_A_PROBLEM_DATE = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM_DATE']; } else { $TEMP_A_PROBLEM_DATE = date('Y-m-d-H:i'); } GETFORMITEM($TEMP_A_PROBLEM_DATE, $_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPE']['A_PROBLEM_DATE'], 'A_PROBLEM_DATE'); // 2011-11-23: pole nieuzywane, problem z odpisywaniem maila przez klientow // @see superedit-UPDATEDB.php //if (strlen($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM']) < 1) { // echo "
Przeslanie wiadomosci dla abonenta umozliwiajacej anulowanie problemu	"; //} echo "

"; CREATE_MENUFUNC_NOTD_INIT($_SESSION['LAST_MENU'], 'POWROT

'); echo "

"; } } } if(isset($error)) echo "ERROR($RESULT,$ERROR ".$error.")"; } // @from superedit-UPDATEDB.php if(0){// if($_SESSION['CURRENT_MENU']=="A_PROBLEM") { // echo "CURRENT A_PROBLEM"; 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" ; 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 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))) && 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" ; $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'] ; 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."
"; } } 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'] . "'"; ZAP_SQL_UPDATE($ZAP_SQL_HIST); $RESULT=$_SESSION['MYSQL_UPDATE_NUM_ROWS']; ZAP_SQL_UPDATE($ZAP_SQL); $RESULT=$RESULT + $_SESSION['MYSQL_UPDATE_NUM_ROWS']; } } }