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; }