function updWvl($data, $datei = "")
{
$nun = date("Y-m-d H:i:00");
$dateiID = $data["DateiID"];
if (empty($dateiID)) {
$dateiID = 0;
}
$finish = $data["Finish"] != "" ? ", finishdate='" . date2db($data["Finish"]) . " 0:0:00'" : "";
$descript = addslashes($data["c_long"]);
$descript = nl2br($descript);
if ($data["kontakt"] == "F") {
$rs = updWvlERP($data);
} else {
if ($data['status'] == '' || $data['status'] < 0 || $data['status'] > 3) {
$data['status'] = 1;
}
$sql = "update wiedervorlage set cause='" . $data["cause"] . "', descript='{$descript}', ";
$sql .= "document={$dateiID}, status=" . $data["status"] . ",kontakt='" . $data["kontakt"] . "',changedate='{$nun}'" . $finish;
if ($data["tellid"]) {
$sql .= ",kontaktid=" . substr($data["cp_cv_id"], 1) . ",kontakttab='" . substr($data["cp_cv_id"], 0, 1) . "'";
$sql .= ",tellid=" . $data["tellid"];
}
if ($data['CRMUSER']) {
if (substr($data["CRMUSER"], 0, 1) == 'G') {
$sql .= ",gruppe=true, ";
$data["CRMUSER"] = substr($data["CRMUSER"], 1);
}
$sql .= ",employee=" . $data["CRMUSER"];
}
$sql .= " where id=" . $data["WVLID"];
$rs = $_SESSION['db']->query($sql);
if (!$rs) {
$rs = -7;
} else {
$rs = $data["WVLID"];
}
if ($data["cp_cv_id"] != $data["cp_cv_id_old"] or $data["status"] < 1) {
// es wurde eine neue Zuweisung an einen Kunden gemacht
$id = kontaktWvl($data["WVLID"], $data["cp_cv_id"], $pfad);
if ($id) {
$rs = $data["WVLID"];
} else {
$rs = -8;
}
}
}
return $rs;
}
$data["DateiID"] = $dbfile->id;
} else {
echo "-5";
return;
}
}
$rc = updWvl($data);
echo $rc;
}
// $f=fopen('/tmp/wvl','a');
// fputs($f,print_r($_POST,true));
// fputs($f,print_r($_GET,true));
// fclose($f);
if (isset($_POST['task']) and $_POST['task'] == 'erp') {
if ($_POST['kontakt'] == 'F') {
echo updWvlERP($_POST);
return;
} else {
if ($_POST["WVLID"] > 0) {
$ok = updWvl($_POST, $f);
} else {
if ($_POST["mail"]) {
$ok = insWvlM($_POST, $_SESSION['MailFlag'], $_SESSION['Expunge']);
} else {
$ok = insWvl($_POST, $f);
}
}
}
} else {
if (isset($_POST['task']) and $_POST['task'] == 'wvl') {
_saveWvl($_POST);
