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