예제 #1
0
function updCall($data, $datei = false)
{
    if ($data["fid"] != $data["CID"]) {
        $pfad = "P" . $data["CID"];
        $wv["cp_cv_id"] = "P" . $data["CID"];
    } else {
        $pfad = $data["Q"][0] . $data["fid"];
        //$pfad=$data["Q"][0].$data["nummer"];
        $wv["cp_cv_id"] = $data["Q"][0] . $data["CID"];
    }
    if ($datei["Datei"]["name"][0] != "") {
        $pfad = mkPfad($pfad, $data["CRMUSER"]);
        $dat["Datei"]["name"] = $datei["Datei"]["name"][0];
        $dat["Datei"]["tmp_name"] = $datei["Datei"]["tmp_name"][0];
        $dat["Datei"]["type"] = $datei["Datei"]["type"][0];
        $dat["Datei"]["size"] = $datei["Datei"]["size"][0];
        $text = $data["DCaption"] ? $data["DCaption"] : $data["cause"];
        $dbfile = new document();
        $dbfile->setDocData("descript", $text);
        $rc = $dbfile->uploadDocument($dat, "/" . $pfad);
        $dateiID = $dbfile->id;
        $did = documenttotc($data["id"], $dateiID);
        if ($data['datei'] != '') {
            $oldfile = new document();
            $oldfile->setDocData("id", $data['datei']);
            $oldfile->setDocData("name", $data['dateiname']);
            $oldfile->setDocData("pfad", "/" . $pfad);
            $oldfile->deleteDocument();
        }
    } else {
        if ($data["datei"]) {
            $dateiID = $data["datei"];
        } else {
            $dateiID = "Null";
        }
    }
    $data['Datum'] = date2db($data['Datum']) . " " . $data['Zeit'] . ":00";
    // Postgres timestamp
    $c_cause = addslashes($data["c_cause"]);
    $c_cause = nl2br($c_cause);
    $sql = "update telcall set cause='" . $data["cause"] . "',c_long='{$c_cause}',caller_id='" . $data["CID"] . "',";
    $sql .= "calldate='" . $data['Datum'] . "',kontakt='" . $data["Kontakt"] . "',dokument={$dateiID},bezug='" . $data["bezug"] . "',";
    $sql .= "employee='" . $data["CRMUSER"] . "',inout='" . $data["inout"] . "' where id=" . $data["id"];
    $rs = $_SESSION['db']->query($sql);
    if (!$rs) {
        $id = false;
    }
    if ($data["wvldate"]) {
        $wv["c_long"] = $data["c_cause"];
        $wv["cause"] = $data["cause"];
        $wv["cp_cv_id_old"] = $wv["cp_cv_id"];
        $wv["DateiID"] = $dateiID;
        $wv["kontakt"] = $data["Kontakt"];
        $wv["status"] = "1";
        $wv["CRMUSER"] = $data["CRMUSER"];
        $wv["Finish"] = $data["wvldate"];
        $wv["tellid"] = $id;
        $wv["WVLID"] = $data["wvlid"];
        if ($data["wvlid"] && $data["wvl"]) {
            updWvl($wv, False);
        } else {
            if ($data["wvlid"] && !$data["wvl"]) {
                $wv["status"] = "0";
                updWvl($wv, False);
            } else {
                if ($data["wvldate"]) {
                    insWvl($wv, False);
                }
            }
        }
    }
    return $id;
}
예제 #2
0
// $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);
    } else {
        if (isset($_POST['task']) and $_POST['task'] == 'delmail') {
            _delMail($_POST['WVLID']);
        } else {
            if (isset($_POST['task']) and $_POST['task'] == 'mail') {
                _saveMail($_POST);
            } else {
                switch ($_GET['task']) {
                    case 'wvl':