';
if ($_GET['S_ADDRESS_STREET']) ZAP_SQL("SELECT * FROM USERS2_MARKETING where S_ADDRESS_STREET='".$_GET['S_ADDRESS_STREET']."' limit 1 ");
while ($DWA = mysql_fetch_array($result)) {
//echo "I_OPER to $DWA[I_OPER] ";
//print_r($_GET);
$NAME="I_BAD_DATE";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="I_OPER";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="I_OPER_ZAD";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="I_OPER_FIN";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="I_OPER_ZAINT";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="S_OTHER_INFO";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="T_BAD_DATE";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="T_OPER";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="T_OPER_ZAD";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="T_OPER_FIN";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="T_OPER_ZAINT";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="TV_BAD_DATE";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="TV_OPER";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="TV_OPER_ZAD";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="TV_OPER_FIN";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="TV_OPER_ZAINT";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="P_NAME";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="P_PHONE";$VALUE=$DWA[$NAME];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo " |
";
$NAME="T_WORKPOINTS_USER";$VALUE=$_SESSION['USERS2_MARKETING_COLUMN']['EDITRECORD']['T_WORKPOINTS_USER'];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
//$_SESSION[USERS2_MARKETING_COLUMN][EDITRECORD][T_WORKPOINTS_USER]=$DWA[$NAME];
echo "| $DESC_TO_LANG | ";T_WORKPOINTS_USER_SELECT();;echo "(DANE SUGEROWANE!) |
";
$NAME="T_WORKPOINTS_TYPE";$VALUE=$_SESSION['USERS2_MARKETING_COLUMN']['EDITRECORD']['T_WORKPOINTS_TYPE'];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo "(DANE SUGEROWANE!) |
";
$NAME="T_WORKPOINTS_DATE";$VALUE=$_SESSION['USERS2_MARKETING_COLUMN']['EDITRECORD']['T_WORKPOINTS_DATE'];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
echo "| $DESC_TO_LANG | ";GETFORMITEM($VALUE,$TYPE,$NAME);echo "(DANE SUGEROWANE!) |
";
{// kolor dywanu
$NAME="P_FLOOR_CONTROL";$VALUE=$_SESSION['USERS2_MARKETING_COLUMN']['EDITRECORD']['T_WORKPOINTS_TYPE'];$TYPE=$_SESSION['USERS2_MARKETING_COLUMN']['TYPE'][$NAME];$DESC_TO_LANG=$_SESSION['USERS2_MARKETING_COLUMN']['DESC_TO_LANG'][$NAME];
if (empty($DESC_TO_LANG)) $DESC_TO_LANG = "Kolor dywanu";
echo '| ' . $DESC_TO_LANG . ' | ';
GETFORMITEM($VALUE, $TYPE, $NAME);
echo ' |
';
}
echo " |
";
if ($_GET['ADD_VERIFIED']) {
$ZAP_UPD_VAL="update USERS2_MARKETING set ID=ID , A_RECORD_UPDATE_AUTHOR='".$_SESSION['AUTHORIZE_USER']."', A_RECORD_UPDATE_DATE=now() ";
$ZAP_UPD_HIST_FIELD="A_RECORD_UPDATE_DATE , A_RECORD_UPDATE_AUTHOR , ID_USERS2 ";
$ZAP_UPD_HIST_VAL=" now() , '".$_SESSION['AUTHORIZE_USER']."' , ID ";
foreach ($_GET as $GET_KEY => $GET_VAL) {
// echo " KEY: $GET_KEY VAL: $GET_VAL
\n";
if (!in_array($GET_KEY, $_SESSION['USERS2_MARKETING_COLUMN']['DESC'])) {
continue;
}
$ZAP_UPD_VAL.=" , $GET_KEY='$GET_VAL' ";
if ((!strstr($DWA[$GET_KEY],"$GET_VAL")) || ($GET_KEY == "T_WORKPOINTS_USER") || ($GET_KEY == "T_WORKPOINTS_TYPE") ) {
// echo "!strstr($DWA[$GET_KEY],$GET_VAL)";
$ZAP_UPD_HIST_FIELD.=", $GET_KEY ";
$ZAP_UPD_HIST_VAL.=", '$GET_VAL' ";
}
}
$ZAP_UPD_VAL.=" where S_ADDRESS_STREET='".$_GET['S_ADDRESS_STREET']."' limit 1 ; " ;
$ZAP_UPD_HIST="insert into USERS2_MARKETING_HIST ( $ZAP_UPD_HIST_FIELD ) select $ZAP_UPD_HIST_VAL from USERS2_MARKETING where S_ADDRESS_STREET='".$_GET['S_ADDRESS_STREET']."' limit 1 ; " ;
//ZAP_SQL(" $ZAP_UPD_VAL ");
ZAP_SQL(" $ZAP_UPD_VAL ");
//echo "
UPDATE: $ZAP_UPD_VAL \n";
//echo "
HISTORY: $ZAP_UPD_HIST \n";
ZAP_SQL(" $ZAP_UPD_HIST ");
if (mysql_affected_rows($result)) {
echo "
AKTUALIZOWANO ". mysql_affected_rows($result) ." REKORDOW EOL
";
}
else {
echo "
ZAKTUALIZOWANO lub NIE REKORD, dla $_GET[S_ADDRESS_STREET] ???
";
}
}
}
echo "
";