function updWvlERP($data)
{
if (substr($data["CRMUSER"], 0, 1) == 'G' || $data["CRMUSER"] == '') {
return -1;
}
if (!$data['WVLID']) {
$data = array_merge($data, mknewWVL(true));
}
$finish = $data["Finish"] != "" ? ", finishdate='" . date2db($data["Finish"]) . " 0:0:00'" : "";
$descript = addslashes($data["c_long"]);
$descript = nl2br($descript);
$sql = "update notes set subject='" . $data["cause"] . "',body='{$descript}', created_by=" . $_SESSION["loginCRM"];
if ($data["cp_cv_id"]) {
$sql .= ",trans_id=" . substr($data["cp_cv_id"], 1);
$sql .= ",trans_module='ct'";
} else {
$sql .= ",trans_id=" . $data["WVLID"];
$sql .= ",trans_module='fu'";
}
$sql .= " where id=" . $data["noteid"];
$rc = $_SESSION['db']->query($sql);
if (!$rc) {
$_SESSION['db']->query("ROLLBACK");
return -3;
}
$sql = "update follow_ups set created_for_user="******"CRMUSER"] . ",done='" . $data["status"] . "', ";
$sql .= "follow_up_date ='" . date2db($data["Finish"]) . "' where id = " . $data["WVLID"];
$rc = $_SESSION['db']->query($sql);
if (!$rc) {
$_SESSION['db']->query("ROLLBACK");
return -4;
}
if ($data["cp_cv_id"]) {
$sql = "select id from follow_up_links where follow_up_id = " . $data["WVLID"];
$rs = $_SESSION['db']->getOne($sql);
$rc = $_SESSION['db']->query("BEGIN");
if (!$rs) {
$sql = "insert into follow_up_links (follow_up_id,trans_id,trans_type,trans_info) values (";
$sql .= $data["WVLID"] . "," . substr($data["cp_cv_id"], 1) . ",'" . (substr($data["cp_cv_id"], 0, 1) == "C" ? "customer" : "vendor");
$sql .= "','" . $data["name"] . "')";
$rc = $_SESSION['db']->query($sql);
$rs = 1;
} else {
$sql = "update follow_up_links set trans_id=" . substr($data["cp_cv_id"], 1);
$sql .= ",trans_type='" . (substr($data["cp_cv_id"], 0, 1) == "V" ? "vendor" : "customer");
$sql .= "',trans_info='" . $data["name"] . "' where follow_up_id = " . $data["WVLID"];
$rc = $_SESSION['db']->query($sql);
}
if (!$rc) {
$_SESSION['db']->query("ROLLBACK");
return -5;
}
$rs = $_SESSION['db']->query("COMMIT");
$rs = 1;
} else {
$rs = 1;
}
return $rs;
}
function _saveWvl($data)
{
if ($data['WVLID'] < 1) {
$data = array_merge($data, mknewWVL(false));
if ($data['WVLID'] < 1) {
echo "-3";
return;
}
}
if (!$data["DCaption"]) {
$data["DCaption"] = $data["cause"];
}
if ($data['newfile'] == 1 and $data['filename'] != '') {
$src = $_SESSION['crmpath'] . '/dokumente/' . $_SESSION["dbname"] . '/' . $_SESSION['login'] . '/tmp/';
$rc = file_exists($src . $data['filename']);
if ($rc) {
if ($data["DateiID"]) {
delDokument($data["DateiID"]);
}
// ein altes löschen
require_once "documents.php";
$dest = $_SESSION['crmpath'] . '/dokumente/' . $_SESSION["dbname"] . '/' . $_SESSION["login"] . '/';
copy($src . $data['filename'], $dest . $data['filename']);
unlink($src . $data['filename']);
//Dokument in db speichern
$dbfile = new document();
$dbfile->setDocData("descript", $data["subject"]);
$dbfile->setDocData("pfad", $_SESSION["login"]);
$dbfile->setDocData("name", $data['filename']);
$dbfile->setDocData("descript", $data["DCaption"]);
$rc = $dbfile->newDocument();
$dbfile->saveDocument();
if (!$dbfile->id > 0) {
echo "-4";
return;
}
$data["DateiID"] = $dbfile->id;
} else {
echo "-5";
return;
}
}
$rc = updWvl($data);
echo $rc;
}
