0) {
$do_it_txt = "Preise kopieren ";
for ($i = 0; $i < count($prices_src); $i++) {
$msgTxtJobs .= ($i+1) . ": " . $prices_src[$i][6] . " -> " . $prices_src[$i][7] . "
\n";
exec_query("INSERT INTO serviceplzcustomer (srvp_id, srvp2_id, hq_id, cs_id, srvpc_price, srvpc_discount)" .
" VALUES (" . $prices_src[$i][0] . ", " . $prices_src[$i][1] . ", " . $hq_id_dest . ", " . $cs_id_dest . ", " . $prices_src[$i][4] . ", " . $prices_src[$i][5] . ");");
exec_query("INSERT INTO serviceplzhistory (srvp_id, srvp2_id, hq_id, cs_id, usr_id, srvph_validfrom, srvph_price, srvph_discount)" .
" VALUES (" . $prices_src[$i][0] . ", " . $prices_src[$i][1] . ", " . $hq_id_dest . ", " . $cs_id_dest . ", 0, '" . $srvph_validfrom . "', " . $prices_src[$i][4] . ", " . $prices_src[$i][5] . ");");
}
$msgTxt .= "" . "$i Preise gefunden" . "
\n" . $msgTxtJobs;
} else {
$msgTxt .= "" . "Für " . $cs_eid_src . " wurden keine kundenspezifischen Preise gefunden!" . "
\n";
}
} else {
$msgTxt .= "" . "Bitte beide Kundennumern eingeben!" . "
\n";
}
function getCs_id($cs_eid) {
$res = mysql_query("SELECT hq_id, cs_id FROM customer WHERE cs_eid = '$cs_eid'");
if (!$res) die (mysql_error());
$row = mysql_fetch_row($res);
return array($row[0], $row[1]);
}
function getPrices($cs_id) {
$srvpc = array();
$res = mysql_query("SELECT srvpc.srvp_id, srvpc.srvp2_id, hq_id, cs_id, srvpc_price, srvpc_discount, srvp.srvp_plz AS srvp_plz, srvp2.srvp_plz AS srvp_plz2
FROM serviceplzcustomer AS srvpc, serviceplz AS srvp, serviceplz AS srvp2
WHERE srvp.srvp_id = srvpc.srvp_id AND srvp2.srvp_id = srvp2_id AND cs_id = " . $cs_id);
if (!$res) die (mysql_error());
while ($row = mysql_fetch_assoc($res)) {
$srvpc[] = array($row["srvp_id"], $row["srvp2_id"], $row["hq_id"], $row["cs_id"], $row["srvpc_price"], $row["srvpc_discount"], $row["srvp_plz"], $row["srvp_plz2"]);
}
mysql_free_result($res);
return $srvpc;
}
function exec_query($sqlquery) {
global $msgTxtJobs, $do_it;
$msgTxtJobs .= "[" . $sqlquery . "]";
if ($do_it == "1") {
// mysql_query($sqlquery) or die($sqlquery . ": " . mysql_error());
$msgTxtJobs .= "" . " - ausgeführt!" . "";
}
$msgTxtJobs .= "
\n";
}
?>
Kopie der kompletten PLZ-Preismatrix