function document($id = false, $fname = "", $fpath = "", $descript = "")
{
if ($this->debug) {
$this->f = fopen($_SESSION['crmpath'] . '/tmp/doc.log', "w");
}
$this->log("newDoc");
$this->db = $_SESSION["db"];
if ($id > 0) {
//Variablen mit db-Eintrag vorbelegen
getDokument($id);
} else {
$this->setDocData("name", $fname);
if (substr($fpath, -1) == "/" and $pfad != "/") {
$fpath = substr($fpath, 0, -1);
}
$this->setDocData("pfad", $fpath);
$this->setDocData("descript", $descript);
}
}
function getOneWvl($id)
{
//$sql="select W.*,C.cp_name,C.cp_givenname from wiedervorlage W left join contacts C on W.kontaktid=C.cp_id where id=$id";
$sql = "select * from wiedervorlage where id={$id}";
$rs = $_SESSION['db']->getAll($sql);
if (!$rs) {
$data = false;
} else {
switch ($rs[0]["kontakttab"]) {
case "C":
$sql = "select name,'' as sep,'' as name2 from customer where id = " . $rs[0]["kontaktid"];
$rsN = $_SESSION['db']->getAll($sql);
break;
case "V":
$sql = "select name,'' as sep,'' as name2 from vendor where id = " . $rs[0]["kontaktid"];
$rsN = $_SESSION['db']->getAll($sql);
break;
case "P":
$sql = "select cp_name as name ,', ' as sep ,cp_givenname as name2 from contacts where cp_id = " . $rs[0]["kontaktid"];
$rsN = $_SESSION['db']->getAll($sql);
break;
default:
$rsN = false;
}
if ($rs[0]["document"]) {
// gibt es ein Dokument
$datei = getDokument($rs[0]["document"]);
if ($datei) {
$pre = $datei["kunde"] > 0 ? $datei["kunde"] : $datei["employee"];
$pre = $datei["pfad"];
$name = $datei["filename"];
$path = $_SESSION["dbname"] . "/" . $pre . "/";
} else {
$name = "";
$path = "";
}
} else {
$name = "";
$path = "";
}
$data["id"] = $rs[0]["id"];
$data["Initdate"] = $rs[0]["initdate"];
$data["Change"] = $rs[0]["changedate"];
$data["Finish"] = $rs[0]["finishdate"] != "" ? db2date(substr($rs[0]["finishdate"], 0, 12)) : "";
$data["cause"] = $rs[0]["cause"];
$data["c_long"] = stripslashes(ereg_replace("<br />", "", $rs[0]["descript"]));
$data["Datei"] = $rs[0]["document"];
$data["DName"] = $name;
$data["DPath"] = $path;
$data["DCaption"] = $datei["descript"];
$data["status"] = $rs[0]["status"];
$data["CRMUSER"] = $rs[0]["employee"];
$data["InitCrm"] = $rs[0]["initemployee"];
$data["kontakt"] = $rs[0]["kontakt"];
$data["tellid"] = $rs[0]["tellid"];
$data["kontaktid"] = $rs[0]["kontaktid"];
$data["kontakttab"] = $rs[0]["kontakttab"];
$data["kontaktname"] = $rsN[0]["name"] . $rsN[0]["sep"] . $rsN[0]["name2"];
}
return $data;
}
