function mkcontent($data)
{
$data['cnt'] = 1;
$tmp = split(' ', $data['initdate']);
$data['datum'] = db2date($tmp[0]) . "ho " . substr($tmp[1], 0, 5);
$data['content'] = stripslashes($data['content']);
if ($data['owener'] == null) {
$data['owener'] = '';
}
echo json_encode($data);
}
}
if ($thread) {
foreach ($thread as $zeile) {
$t->set_var(array(Sel => $daten["id"] == $zeile["id"] ? " selected" : "", TID => $zeile["id"]));
$t->parse("Block4", "Selectbox3", true);
}
}
//------------------------------------------- Kontakte
$i = 0;
$t->set_block("cont", "Liste", "Block");
$zeile = "";
if ($Bezug != 0) {
$calls = getAllCauseCall($Bezug);
if ($calls) {
foreach ($calls as $zeile) {
$t->set_var(array(LineCol => $zeile["bezug"] == 0 ? 4 : $i % 2 + 1, Type => $zeile["kontakt"], Datum => db2date($zeile["calldate"]) . substr($zeile["calldate"], 10, 6), Betreff => $zeile["cause"], Kontakt => $zeile["kontakt"], IID => $zeile["id"]));
$t->parse("Block", "Liste", true);
$i++;
}
}
}
//------------------------------------------- Eingabemaske
if (empty($daten["CID"])) {
$cid = empty($zeile["caller_id"]) ? "0" : $zeile["caller_id"];
} else {
$cid = $daten["CID"];
}
$cause = empty($daten["Betreff"]) ? $zeile["cause"] : $daten["Betreff"];
$deletes = getCntCallHist($Bezug, true);
$t->set_var(array(nummer => $daten["nummer"], EDIT => ($_SESSION['CallEdit'] == 't' and $_GET["hole"]) ? "visible" : "hidden", DELETE => ($_SESSION['CallDel'] == 't' and $_GET["hole"]) ? "visible" : "hidden", HISTORY => $daten["history"] > 0 ? "visible" : "hidden", HDEL => $deletes > 0 ? "visible" : "hidden", Person => $Person, NBetreff => addslashes($cause), Q => $Q, Firma => $daten["Firma"], Plz => $daten["Plz"], Ort => $daten["Ort"], NDatum => $daten["Datum"], wvl => $daten["wvldate"] ? "checked" : "", wvldate => $daten["wvldate"], WVLID => $daten["wvlid"], NZeit => $daten["Zeit"], c_long => $daten["c_long"], CID => $cid, FID => $fid, PID => $pid, INOUT . $daten["inout"] => "checked", bezug => $daten["Bezug"], Bezug => $Bezug ? $Bezug : 0, R1 => $daten["Kontakt"] == "T" ? " checked" : "", R2 => ($daten["Kontakt"] == "M" or $daten["Kontakt"] == "m") ? " checked" : "", R3 => $daten["Kontakt"] == "S" ? " checked" : "", R4 => $daten["Kontakt"] == "P" ? " checked" : "", R5 => $daten["Kontakt"] == "D" ? " checked" : "", R6 => $daten["Kontakt"] == "X" ? " checked" : "", Start => $telcall * -1, Datei => $daten["Datei"], ODatei => empty($daten["Datei"]) ? "" : "<a href='dokumente/" . $_SESSION["dbname"] . "/" . $daten["Dpfad"] . "/" . $daten["Datei"] . "' target='_blank'>" . $daten["Datei"] . "</a>", DateiID => $daten["DateiID"], Dcaption => $daten["DCaption"], ID => $daten["ID"]));
//------------------------------------------- Dateianhänge
}
$streetview = $_SESSION['streetview_default'] ? $_SESSION['streetview_man'] : $_SESSION['streetview'];
$streetview = $streetview ? $streetview : 'http://maps.google.de/maps?f=d&hl=de&saddr=Alexanderplatz+7,10178+Berlin&daddr=%TOSTREET%,%TOZIPCODE%+%TOCITY%';
//gibt es da nichts kürzeres ||=
$karte1 = str_replace(array("%TOSTREET%", "%TOZIPCODE%", "%TOCITY%"), array(strtr($fa["street"], " ", $_SESSION['planspace']), $fa["zipcode"], $fa["city"]), $streetview);
$karte2 = str_replace(array("%TOSTREET%", "%TOZIPCODE%", "%TOCITY%"), array(strtr($fa["shiptostreet"], " ", $_SESSION['planspace']), $fa["shiptozipcode"], $fa["shiptocity"]), $streetview);
if (preg_match("/%FROM/", $karte1)) {
include "inc/UserLib.php";
$user = getUserStamm($_SESSION["loginCRM"]);
if ($user["addr1"] != "" and $user["addr3"] != "" and $user["addr2"]) {
$karte1 = str_replace(array("%FROMSTREET%", "%FROMZIPCODE%", "%FROMCITY%"), array(strtr($user["addr1"], " ", $_SESSION['planspace']), $user["addr2"], $user["addr3"]), $karte1);
$karte2 = str_replace(array("%FROMSTREET%", "%FROMZIPCODE%", "%FROMCITY%"), array(strtr($user["addr1"], " ", $_SESSION['planspace']), $user["addr2"], $user["addr3"]), $karte2);
}
}
$taxzone = array("Inland", "EU mit UStId", "EU ohne UStId", "Ausland");
$sales = $Q == "C" ? "sales" : "purchase";
$request = $Q == "C" ? "sales" : "request";
$t->set_var(array('FAART' => $Q == "C" ? ".:Customer:." : ".:Vendor:.", 'CuVe' => $Q == "C" ? "customer" : "vendor", 'Q' => $Q, 'FID' => $id, 'INID' => db2date(substr($fa["itime"], 0, 10)), 'interv' => $_SESSION["interv"] * 1000, 'Fname1' => $fa["name"], 'kdnr' => $fa["nummer"], 'kdtyp' => $fa["kdtyp"], 'lead' => $fa["leadname"], 'Fdepartment_1' => $fa["department_1"], 'Fdepartment_2' => $fa["department_2"] ? $fa["department_2"] . "<br />" : "", 'Strasse' => $fa["street"], 'Land' => $fa["country"], 'Bundesland' => $fa["bundesland"], 'Plz' => $fa["zipcode"], 'Ort' => $fa["city"], 'GEODB' => $_SESSION['GEODB'] == 't' ? '1==1' : '1>2', 'Telefon' => $fa["phone"], 'Fax' => $fa["fax"], 'Fcontact' => $fa["contact"], 'eMail' => $fa["email"], 'verkaeufer' => $fa["verkaeufer"], 'bearbeiter' => $fa["bearbeiter"], 'branche' => $fa["branche"], 'sw' => $fa["sw"], 'notiz' => nl2br($fa["notes"]), 'bank' => $fa["bank"], 'directdebit' => $fa["direct_debit"] == "t" ? ".:yes:." : ".:no:.", 'blz' => $fa["bank_code"], 'konto' => $fa["account_number"], 'iban' => $fa["iban"], 'bic' => $fa["bic"], 'konzernname' => $fa["konzernname"], 'konzernmember' => $fa["konzernmember"] > 0 ? "( " . $fa["konzernmember"] . " )" : "( * )", 'konzern' => $fa["konzern"], 'Internet' => $internet, 'USTID' => $fa["ustid"], 'Steuerzone' => $fa["taxzone_id"] ? $taxzone[$fa["taxzone_id"]] : $taxzone[0], 'Taxnumber' => $fa["taxnumber"], 'rabatt' => $rab, 'headcount' => $fa["headcount"] ? $fa["headcount"] : '-', 'terms' => $fa["terms_netto"] ? $fa["terms_netto"] : "0", 'kreditlim' => sprintf("%0.2f", $fa["creditlimit"]), 'op' => $fa["op"] > 0 ? sprintf("<span class='op'>%0.2f</span>", $fa["op"]) : "0.00", 'oa' => $fa["oa"] > 0 ? sprintf("<span class='oa'>%0.2f</span>", $fa["oa"]) : "0.00", 'preisgrp' => $fa["pricegroup"], 'language' => $fa["language"], 'Sshipto_id' => $fa["shipto_id"] > 0 ? $fa["shipto_id"] : "", 'Sname1' => $fa["shiptoname"], 'Sdepartment_1' => $fa["shiptodepartment_1"], 'Sdepartment_2' => $fa["shiptodepartment_2"], 'SStrasse' => $fa["shiptostreet"], 'SLand' => $fa["shiptocountry"], 'SBundesland' => $fa["shiptobundesland"], 'SPlz' => $fa["shiptozipcode"], 'SOrt' => $fa["shiptocity"], 'STelefon' => $fa["shiptophone"], 'SFax' => $fa["shiptofax"], 'SeMail' => $fa["shiptoemail"], 'Scontact' => $fa["shiptocontact"], 'Scnt' => $fa["shiptocnt"], 'Sids' => $fa["shiptoids"], 'Cmsg' => $cmsg, 'IMG' => $Image, 'KARTE1' => $karte1, 'KARTE2' => $karte2, 'sales' => $Q == "C" ? "sales" : "purchase", 'request' => $Q == "C" ? "sales" : "request", 'apr' => $Q == "C" ? "ar" : "ap", 'loginname' => $_SESSION['login'], 'ANGEBOT_BUTTON' => $_SESSION['angebot_button'] == 't' ? '<a class="firmabutton" href="#" onClick="doOe(\'' . $sales . '_quotation\');"><img src="image/angebot.png" title="Angebot/Anfrage erstellen" border="0"></a> ' : '', 'AUFTRAG_BUTTON' => $_SESSION['auftrag_button'] == 't' ? '<a class="firmabutton" href="#" onClick="doOe(\'' . $request . '_order\');"><img src="image/auftrag.png" title="neuen Auftrag eingeben" border="0"></a> ' : '', 'LIEFER_BUTTON' => $_SESSION['liefer_button'] == 't' ? '<a class="firmabutton" href="#" onClick="doDo();"><img src="image/lieferschein.png" title="neuen Lieferschein erstellen" border="0"></a> ' : '', 'RECHNUNG_BUTTON' => $_SESSION['rechnung_button'] == 't' ? '<a class="firmabutton" href="#" onClick="doIr();"><img src="image/rechnung.png" title="neue Rechnung erstellen" border="0"></a> ' : '', 'EXTRA_BUTTON' => $_SESSION['zeige_extra'] == 't' ? '<a class="firmabutton" href="extrafelder.php?owner=' . $Q . $id . '" name="extra" target="_blank"><img src="image/extra.png" title="Extrafelder" border="0"></a> ' : '', 'KARTE_BUTTON' => $_SESSION['zeige_karte'] == 't' ? '<a class="firmabutton" href="' . $karte1 . '" name="karte" target="_blank"><img src="image/karte.png" title=".:city map:." border="0"></a> ' : '', 'ETIKETT_BUTTON' => $_SESSION['zeige_etikett'] == 't' ? '<a class="firmabutton" href="#" onCLick="anschr(1);" title=".:print label:."><img src="image/brief.png" alt=".:print label:." border="0"></a> ' : '', 'DHL_BUTTON' => $_SESSION['zeige_dhl'] == 't' ? '<a class="firmabutton" href="#" onCLick="dhl();" title="DHL"><img src="image/dhl.png" alt="DHL" border="0"></a> ' : '', 'QR_BUTTON' => '<a class="firmabutton" id="qrbutt" href="#" title="QR Code erstellen"><img src="image/qrn.png" alt=".:print qr:." border="0"></a> ', 'BRIEF_BUTTON' => '<a class="firmabutton" href="#" onClick="doIb();"><img src="image/mail.png" title="neuen Brief erstellen" border="0"></a> ', 'LxCars_BUTTON' => $_SESSION['zeige_lxcars'] == 't' && $Q == "C" ? '<a class="firmabutton" href="#" onCLick="doLxCars();" title="KFZ-Daten"><img src="image/auto.png" alt="LxCars"></a> ' : '', 'zeige_bearbeiter' => $_SESSION['zeige_bearbeiter'] == 't' ? "visible" : "hidden", 'zeige_tools' => $_SESSION['zeige_tools'] == 't' ? "visible" : "hidden", 'leadsrc' => $fa["leadsrc"], 'variablen' => $variablen, 'Vars' => $Vars, 'erstellt' => db2date($fa["itime"]), 'modify' => db2date($fa["mtime"]), 'kdviewli' => $_SESSION["kdviewli"] - 1, 'kdviewre' => $_SESSION["kdviewre"] - 1, 'zeige' => $fa["obsolete"] == "f" ? "visible" : "hidden", 'verstecke' => $fa["obsolete"] == "t" ? "visible" : "hidden", 'chelp' => $kdhelp ? "visible" : "hidden", 'none' => "visible", 'mail_pre' => $_SESSION['external_mail'] == 't' ? 'mailto:' : 'mail.php?TO=', 'mail_after' => $_SESSION['external_mail'] == 't' ? '' : '&KontaktTO=C' . $id));
$t->set_block("fa1", "Liste", "Block");
$i = 0;
$nun = date("Y-m-d H:i");
if ($kdhelp) {
$t->set_block("fa1", "kdhelp", "Block1");
$kdtmp[] = array("id" => -1, "name" => "Online Kundenhilfe");
$kdhelp = array_merge($kdtmp, $kdhelp);
foreach ($kdhelp as $col) {
$t->set_var(array('cid' => $col["id"], 'cname' => $col["name"]));
$t->parse("Block1", "kdhelp", true);
}
}
$t->Lpparse("out", array("fa1"), $_SESSION['countrycode'], "firma");
function getOneTT($id, $event = true)
{
$sql = "select t.*,v.name as vname,c.name as cname from timetrack t ";
$sql .= "left join customer c on c.id=t.fid ";
$sql .= "left join vendor v on v.id=t.fid ";
$sql .= "where t.id = {$id}";
$rs = $_SESSION['db']->getOne($sql);
$rs["name"] = $rs["tab"] == "C" ? $rs["cname"] : $rs["vname"];
$rs["startdate"] = db2date($rs["startdate"]);
$rs["stopdate"] = db2date($rs["stopdate"]);
$curr = getCurrCompany($rs['fid'], $rs['tab']);
$rs['cur'] = $curr['name'];
if ($event) {
$rs["events"] = getTTEvents($id, "o", false);
}
return $rs;
}
//$cnt=($data["mid"])?getCounter($data["mid"]):"";
$t->set_file(array("masch" => "maschinen1.tpl"));
doHeader($t);
$t->set_var(array(action => "maschine1.php", msg => $msg, disp => $disp, parts_id => $data["id"], partnumber => $data["partnumber"], description => $data["description"], notes => strtr($data["notes"], array("\n" => "<br>")), standort => $data["standort"], serialnumber => $data["serialnumber"], contractnumber => $data["contractnumber"], inspdatum => db2date($data["inspdatum"]), counter => $data['counter'], cid => $data["cid"], mid => $data["mid"] ? $data["mid"] : $data["id"], customer => $data["name"], custid => $data["customer_id"]));
$t->set_block("masch", "History", "Block1");
if ($hist) {
foreach ($hist as $zeile) {
$open = ' ';
if ($zeile["art"] == "RepAuftr") {
$open = $zeile['status'] == 2 ? 'close' : 'open';
$art = "<a href='repauftrag.php?hole=" . $zeile['bezug'] . "'>RepAuftr</a> " . $zeile['bezug'];
} else {
if ($zeile["art"] == "contsub" or $zeile["art"] == "contadd") {
$vid = suchVertrag($beschr);
$art = "<a href='vertrag3.php?vid=" . $vid[0]["cid"] . "'>" . $zeile["art"] . "</a>";
} else {
if ($zeile["art"] == "neu") {
$maschzusatz = $zeile["beschreibung"];
}
$art = $zeile["art"];
}
}
$t->set_var(array(date => db2date(substr($zeile["itime"], 0, 10)), art => $art, open => $open, beschreibung => substr($zeile["beschreibung"], 0, 40)));
$t->parse("Block1", "History", true);
}
} else {
$t->set_var(array(date => '', art => '', open => '', beschreibung => 'Kein Eintrag'));
$t->parse("Block1", "History", true);
}
$t->set_var(array(maschzusatz => $maschzusatz));
$t->pparse("out", array("masch"));
} else {
if ($row["lname"]) {
$name = $row["lname"];
$src = "V";
} else {
if ($row["pname"]) {
$name = $row["pname"];
$src = "CC";
} else {
$name = "";
$src = $_GET["Q"];
}
}
}
echo "<tr height='14px' class='bgcol" . ($i % 2 + 1) . "' onClick='showItem(" . $row["id"] . ",\"{$src}\"," . $row["caller_id"] . ");'>";
echo "<td>" . db2date($row["calldate"]) . " </td><td> " . $cause . "</td><td>";
echo "{$name}</td></tr>\n";
$i++;
if ($i >= $_SESSION['listLimit']) {
echo $_SESSION['listLimit'] . " von " . count($rs) . " Treffern";
break;
}
}
echo "</table>\n";
} else {
echo "Keine Treffer!";
}
?>
<center><a href="javascript:self.close()">close</a></center>
</body>
</html>
$vid = updateVertrag($_POST);
} else {
if (!empty($_POST["maschinen"][0][0])) {
$vid = saveNewVertrag($_POST);
}
}
}
$vorlagen = getWVorlagen();
if ($vid) {
$template = "vertrag3e.tpl";
$vertrag = getVertrag($vid);
//$maschinen=getVertragMaschinen($vertrag["contractnumber"]);
$maschinen = getVertragMaschinen($vid);
}
$t->set_file(array("vert" => $template));
$t->set_var(array(VID => $vid, vorlage_old => $vertrag["customer_id"] . "/" . $vertrag["template"], vorlage => $vertrag["template"], Notiz => $vertrag["bemerkung"], FID => $vertrag["customer_id"], KDNR => $vertrag["customernumber"], Firma => $vertrag["name"], betrag => sprintf("%0.2f", $vertrag["betrag"]), anfangdatum => db2date($vertrag["anfangdatum"]), endedatum => db2date($vertrag["endedatum"]), VertragNr => $vertrag["contractnumber"]));
$t->set_block("vert", "Vorlage", "Block1");
if ($vorlagen) {
foreach ($vorlagen as $zeile) {
if ($zeile == $vertrag["template"]) {
$sel = " selected";
} else {
$sel = "";
}
$t->set_var(array(Vsel => $sel, Vertrag => $zeile));
$t->parse("Block1", "Vorlage", true);
}
}
$t->set_block("vert", "Maschinen", "Block2");
$i = 0;
if ($maschinen) {
opener.top.main_window.location.href=link;
self.close();
}
</script>
</head>
<body>
<?php
echo "Termin: <b>" . ($privat ? "Privattermin" : $data["cause"]) . "</b><br>";
if ($data["location"]) {
echo "Ort: " . $data["location"] . "<br />";
}
if ($data["catname"]) {
echo $data["catname"] . '<br />';
}
echo db2date($data["starttag"]) . " " . $data["startzeit"] . " - ";
echo $data["stoptag"] != $data["starttag"] ? db2date($data["stoptag"]) . " " . $data["stopzeit"] : $data["stopzeit"];
echo "<br>";
echo "Wiederholung: " . $wdhlg[$data["repeat"]] . ", ";
echo $data["ft"] == 1 ? "nur Arbeitstage" : "auch Feiertage";
echo "<br>";
if ($ft[$x]) {
echo $ft[$x];
}
echo "<hr><br>";
if ($privat) {
echo "Privattermin<br />";
} else {
echo $data["c_cause"] . "<br />";
}
?>
<hr>
if ($_SESSION["termseq"] > 0) {
for ($s = $_SESSION["termseq"]; $s < 60; $s += $_SESSION["termseq"]) {
$sq = sprintf("%02d", $s);
$t->set_var(array(col => "we", zeit => sprintf("%02d:{$sq}", $i), text => $termdata["{$i}:{$sq}"], tid => $termid["{$i}:{$sq}"]));
$t->parse("Block", "Stunden", true);
}
}
}
$t->set_var(array(ERPCSS => $_SESSION['baseurl'] . 'crm/css/' . $_SESSION["stylesheet"], tag => $day . "." . $month . "." . $year, dat1 => $t1, dat2 => $t2, day => $day, month => $month, year => $year, CUID => $_GET["cuid"]));
} else {
if (substr($ansicht, 0, 1) == "K" or substr($ansicht, 0, 1) == "S") {
$data = getTerminList(substr($ansicht, 1, -1));
$t->set_file(array("term" => "terminlist.tpl"));
$t->set_block("term", "Liste", "Block");
foreach ($data as $row) {
$t->set_var(array(tid => $row["id"], start => db2date($row["starttag"]) . " " . $row["startzeit"], stop => db2date($row["stoptag"]) . " " . $row["stopzeit"], cause => $row["privat"] == 't' && $row["member"] != $_SESSION["loginCRM"] ? "Privat" : $row["cause"]));
$t->parse("Block", "Liste", true);
}
$t->set_var(array(ERPCSS => $_SESSION['baseurl'] . 'crm/css/' . $_SESSION["stylesheet"], HEADLINE => substr($ansicht, 0, 1) == "S" ? ".:search result:." : ".:conflict with termin:."));
} else {
if ($ansicht == "W") {
$kw = $_GET["kw"];
if ($_GET["year"] > 0) {
$year = $_GET["year"];
} else {
$year = substr($datum, 6, 4);
}
if (empty($kw) || $kw == 0 || $kw == "") {
list($day, $month, $year) = explode(".", $datum);
$kw = date("W", mktime(0, 0, 0, $month, $day, $year));
}
} else {
$email = "---------";
}
}
}
}
?>
<tr height="14px" class='bgcol<?php
echo $jj % 2 + 1;
?>
' onClick="showItem(<?php
echo $Q . $col['id'];
?>
);">
<td class="smal" width="100px"><?php
echo db2date(substr($col['calldate'], 0, 10));
?>
<?php
echo substr($col['calldate'], 11, 5);
?>
</td>
<td class="smal le"><?php
echo $email;
?>
</td><td class="smal le"><?php
echo $col['cause'];
?>
</td></tr>
<?php
}
}
?>
";
opener.document.formular.cp_homepage.value="<?php
echo $adress["URL"];
?>
";
opener.document.formular.name.value="<?php
echo $adress["ORG"]["FIRMA"];
?>
";
opener.document.formular.cp_abteilung.value="<?php
echo $adress["ORG"]["ABTLG"];
?>
";
opener.document.formular.cp_birthday.value="<?php
echo db2date($adress["N"]["BDAY"]);
?>
";
opener.document.formular.cp_notes.value="<?php
echo $adress["NOTE"];
?>
";
opener.document.formular.key.value="<?php
echo $adress["KEY"];
?>
";
opener.document.formular.revision.value="<?php
echo $adress["REV"];
?>
";
opener.document.formular.uid.value="<?php
$pdf->Text($wvkdnr[x], $wvkdnr[y], $firma["customernumber"]);
$pdf->Text($wvwvnr[x], $wvwvnr[y], $rep['contractnumber']);
$pdf->Text($wvstart[x], $wvstart[y], db2date($rep["anfangdatum"]));
$pdf->Text($wvende[x], $wvende[y], $ende);
$pdf->Text($wvbetrag[x], $wvbetrag[y], sprintf("%0.2f", $rep["betrag"]));
$pdf->SetFont('Helvetica', '', 10);
$bem = $rep["bemerkung"] ? utf8_decode($rep["bemerkung"]) : "Es werden keine Sondervereinbarungen getroffen";
$pdf->SetY($wvbem[y]);
$pdf->SetX($wvbem[x]);
$pdf->MultiCell(0, 6, $bem, 0);
for ($j = 2; $j <= $seiten; $j++) {
$hdl = @$pdf->ImportPage($j);
$pdf->addPage();
$pdf->useTemplate($hdl);
}
$pdf->SetFont($wvfont, '', $wvsize);
$i = 300;
$p = 1;
foreach ($masch as $row) {
if ($i > 270) {
$pdf->addPage();
$pdf->Text($wvkopf[x], $wvkopf[y], "Anhang A (Seite {$p}) zum Wartungsvertrag " . $rep['contractnumber'] . " vom " . db2date($rep["anfangdatum"]));
$i = 40;
$p++;
}
$pdf->Text($wvmasch, $i, utf8_decode($row["description"]));
$pdf->Text($wvsernr, $i, " #" . $row["serialnumber"]);
$pdf->Text($wvsort, $i + 8, utf8_decode($row["standort"]));
$i += 20;
}
$pdf->Output('Wartungsvertrag_' . $rep['contractnumber'] . '.pdf', "I");
if ($reM) {
foreach ($reM as $col) {
if (array_key_exists('invnumber', $col)) {
$typ = $Q == 'C' ? 'R' : 'V';
$renr = $col['invnumber'];
$offen = $col['amount'] == $col['paid'] ? '+' : '-';
} else {
if ($col['quotation'] == 'f') {
$typ = 'L';
$renr = $col['ordnumber'];
$offen = $col['closes'] == 't' ? 'c' : 'o';
//$offen="+";
} else {
$typ = 'A';
$renr = $col['quonumber'];
$offen = $col['closes'] == 't' ? 'c' : 'o';
}
}
$t->set_var(array('LineCol' => $i % 2 + 1, 'Datum' => db2date($col['transdate']), 'RNr' => $renr, 'RNid' => $col["id"], 'RSumme' => sprintf('%01.2f', $col['netamount']), 'RBrutto' => sprintf('%01.2f', $col['amount']), 'Curr' => $col['curr'], 'Typ' => $typ, 'offen' => $offen));
$t->parse('Block', 'Liste', true);
$i++;
}
}
}
if ($monat and !$reM) {
$t->set_block('"fa1', 'Liste', 'Block');
$i = 0;
$t->set_var(array('LineCol' => '', 'Datum' => '', 'RNr' => 'Keine ', 'RSumme' => 'Umsätze', 'Curr' => ''));
$t->parse('Block', 'Liste', true);
}
$t->Lpparse('out', array('fa1'), $_SESSION['countrycode'], 'firma');
function vartplP(&$t, $daten, $msg, $btn1, $btn2, $btn3, $fld, $bgcol, $fid, $tab, $ui = false)
{
//global $laender;
//cp_greeting raus hli
if ($daten["cp_cv_id"] && $daten["Quelle"]) {
$fa = getFirmenstamm($daten["cp_cv_id"], false, $daten["Quelle"]);
$nummer = $daten["Quelle"] == "C" ? $fa["customernumber"] : $fa["vendornumber"];
}
if (trim($daten["cp_grafik"]) != "") {
if ($nummer) {
$root = "dokumente/" . $_SESSION["dbname"] . "/" . $daten["Quelle"] . $nummer . "/" . $daten["cp_id"];
} else {
$root = "dokumente/" . $_SESSION["dbname"] . "/" . $daten["cp_id"];
}
$Image = "<img src='{$root}/kopf" . $daten["cp_id"] . "." . $daten["cp_grafik"] . "' " . $daten["icon"] . ">";
$tmp = glob("{$root}/vcard" . $daten["cp_id"] . ".*");
if ($tmp) {
foreach ($tmp as $vcard) {
$ext = explode(".", $vcard);
$ext = strtolower($ext[count($ext) - 1]);
if (in_array($ext, array("jpg", "jpeg", "gif", "png", "pdf", "ps"))) {
$VCARD = "<img src='{$root}/vcard" . $daten["cp_id"] . ".{$ext}' width='110' height='80'>";
break;
}
}
}
}
if ($ui) {
$t->set_file(array("pers1" => "persons1Result.tpl"));
} else {
$t->set_file(array("pers1" => "personen" . $tab . ".tpl"));
}
$t->set_var(array('ERPCSS' => $_SESSION['baseurl'] . 'crm/css/' . $_SESSION["stylesheet"], 'Fld' => $fld, 'JS' => "goFld();", 'color' => $bgcol, 'BgC' => $fid, 'Btn1' => $btn1, 'Btn3' => $btn3, 'Msg' => $msg, 'preon' => isset($daten["pre"]) ? "checked" : "", 'action' => "personen" . $tab . ".php", 'mtime' => $daten["mtime"], 'PID' => $daten["cp_id"], 'tabelle' => $daten["tabelle"], 'nummer' => isset($nummer) ? $nummer : '', 'cp_title' => $daten["cp_title"], 'cp_givenname' => $daten["cp_givenname"], 'cp_name' => $daten["cp_name"], 'cp_gender' . $daten["cp_gender"] => "selected", 'cp_salutation_' => isset($daten["cp_salutation_"]) ? $daten["cp_salutation_"] : '', 'cp_street' => $daten["cp_street"], 'cp_country' => $daten["cp_country"], 'cp_zipcode' => $daten["cp_zipcode"], 'cp_city' => $daten["cp_city"], 'cp_phone1' => $daten["cp_phone1"], 'cp_phone2' => $daten["cp_phone2"], 'cp_privatphone' => $daten["cp_privatphone"], 'cp_mobile1' => $daten["cp_mobile1"], 'cp_mobile2' => $daten["cp_mobile2"], 'cp_fax' => $daten["cp_fax"], 'cp_email' => $daten["cp_email"], 'cp_privatemail' => $daten["cp_privatemail"], 'cp_homepage' => $daten["cp_homepage"], 'cp_birthday' => $daten["cp_birthday"] ? db2date($daten["cp_birthday"]) : "", 'cp_beziehung' => $daten["cp_beziehung"], 'cp_abteilung' => $daten["cp_abteilung"], 'cp_position' => $daten["cp_position"], 'Firma' => $daten["Firma"], 'FID' => $daten["cp_cv_id"], 'FID1' => $fid, 'cp_stichwort1' => $daten["cp_stichwort1"], 'cp_notes' => $daten["cp_notes"], 'Quelle' => $daten["Quelle"], 'IMG' => isset($Image) ? $Image : '', 'IMG_' => $daten["cp_grafik"], 'visitenkarte' => isset($VCARD) ? $VCARD : '', 'init' => $daten["cp_employee"] ? $daten["cp_employee"] : "ERP", 'employee' => $_SESSION["loginCRM"]));
if ($daten["cp_employee"] == $_SESSION["loginCRM"]) {
$first[] = array("grpid" => "", "rechte" => "w", "grpname" => ".:public:.");
$first[] = array("grpid" => $daten["cp_employee"], "rechte" => "w", "grpname" => ".:personal:.");
$grp = getGruppen();
if ($grp) {
$user = array_merge($first, $grp);
} else {
$user = $first;
}
doBlock($t, "pers1", "OwenerListe", "OL", $user, "grpid", "grpname", $daten["cp_owener"]);
} else {
$user[0] = array("grpid" => $daten["cp_owener"], "grpname" => $daten["cp_owener"] ? getOneGrp($daten["cp_owener"]) : ".:public:.");
doBlock($t, "pers1", "OwenerListe", "OL", $user, "grpid", "grpname", $daten["cp_owener"]);
}
$anreden = getCpBriefAnreden();
doBlock($t, "pers1", "briefanred", "BA", $anreden, "cp_salutation", "cp_salutation", $daten["cp_salutation"]);
}
if (!$daten["salesman"]) {
$daten["salesman"] = $_SESSION["loginCRM"];
}
if ($salesman) {
foreach ($salesman as $row) {
$t->set_var(array(esel => $row["id"] == $daten["salesman"] ? "selected" : "", evals => $row["id"], ename => $row["name"] ? $row["name"] : $row["login"]));
$t->parse("BlockV", "salesman", true);
}
}
$t->set_block("op", "auftrag", "BlockA");
if ($daten["orders"]) {
foreach ($daten["orders"] as $row) {
$t->set_var(array(asel => $row["id"] == $daten["auftrag"] ? "selected" : "", aval => $row["id"], aname => $row["ordnumber"] . " : " . db2date($row["transdate"])));
$t->parse("BlockA", "auftrag", true);
}
}
if ($daten["fid"]) {
$backlink = "firma1.php?Q=" . $daten["tab"] . "&id=" . $daten["fid"];
}
$t->set_var(array(ERPCSS => $_SESSION['baseurl'] . 'crm/css/' . $_SESSION["stylesheet"], id => $daten["id"], oppid => $daten["oppid"], auftrag => $daten["auftrag"] > 0 ? $daten["auftrag"] : "0", auftragshow => $daten["auftrag"] > 0 ? "visible" : "hidden", tab => $daten["tab"], fid => $daten["fid"], title => $daten["title"], firma => $daten["firma"] ? $daten["firma"] : $_POST["firma"], zieldatum => $daten["zieldatum"] ? db2date($daten["zieldatum"]) : "", betrag => $daten["betrag"] ? sprintf("%0.2f", $daten["betrag"]) : "", next => $daten["next"] ? $daten["next"] : $_POST["next"], notxt => $daten["notiz"] ? nl2br($daten["notiz"]) : "---", notiz => $daten["notiz"], user => $daten["user"], chgdate => db2date($daten["itime"]), ssel . $daten["status"] => "selected", csel . $daten["chance"] => "selected", save => $save, search => $search, stamm => $stamm, block => $block, none => $none, button => $button, backlink => $backlink, blshow => $backlink ? "visible" : "hidden", msg => $msg));
$history = $daten = getOpportunityHistory($daten['oppid']);
$i = 0;
$t->set_block("op", "Liste", "Block");
if ($history) {
foreach ($history as $row) {
$t->set_var(array(nr => $i, LineCol => $i % 2 + 1, histtitle => $row["title"], histchance => $row["chance"] * 10, histbetrag => sprintf("%0.2f", $row["betrag"]), histstatus => $row["statusname"], histdatum => db2date($row["zieldatum"]), histauftrag => $row["ordnumber"], histnext => $row["next"], histnotiz => strtr($row["notiz"], array("\n" => "<br>")), user => $row["user"], chgdate => db2date($row["itime"])));
$t->parse("Block", "Liste", true);
$i++;
}
}
$t->Lpparse("out", array("op"), $_SESSION['countrycode'], "work");
$pdf->SetY($replang[x]);
$pdf->SetX($replang[y]);
$pdf->MultiCell(0, 6, utf8_decode($rep["schaden"]), 0);
$pdf->addPage();
$history = "Die letzten Ereignisse:\n";
$history .= db2date($hist[0]["datum"]);
$history .= " " . $hist[0]["art"] . " ";
if ($hist[0]["art"] == "RepAuftr") {
preg_match("/^[0-9]+\\|(.+)/", utf8_decode($hist[0]["beschreibung"]), $treffer);
$history .= $treffer[1] . "\n";
} else {
$history .= $hist[0]["beschreibung"] . "\n";
}
$history .= db2date($hist[1]["datum"]);
$history .= " " . $hist[1]["art"] . " ";
if ($hist[1]["art"] == "RepAuftr") {
preg_match("/^[0-9]+\\|(.+)/", utf8_decode($hist[1]["beschreibung"]), $treffer);
$history .= $treffer[1] . "\n";
} else {
$history .= utf8_decode($hist[1]["beschreibung"]) . "\n";
}
$history .= db2date($hist[2]["datum"]);
$history .= " " . $hist[2]["art"] . " ";
if ($hist[2]["art"] == "RepAuftr") {
preg_match("/^[0-9]+\\|(.+)/", utf8_decode($hist[2]["beschreibung"]), $treffer);
$history .= $treffer[1] . "\n";
} else {
$history .= utf8_decode($hist[2]["beschreibung"]) . "\n";
}
$pdf->MultiCell($repanl[x], $repanl[y], $history . "\nLetzte Reparatur:\n" . $rep["reparatur"] . "\n\nVerbrauchtes Material:\n" . $mat, 0);
$pdf->OutPut('Reparaturauftrag_' . $_GET["aid"] . '.pdf', "I");
function showFile($pfad, $file)
{
if (substr($pfad, -1) == "/" and $pfad != "/") {
$pfad = substr($pfad, 0, -1);
}
if (substr($pfad, 0, 2) == "//") {
$pfad = substr($pfad, 1);
}
clearstatcache();
$zeit = date("d.m.Y H:i:s", filemtime("../dokumente/" . $_SESSION["dbname"] . "/{$pfad}/{$file}"));
$size = filesize("../dokumente/" . $_SESSION["dbname"] . "/{$pfad}/{$file}");
$ext = strtoupper(substr($file, strrpos($file, ".") + 1));
$pic = "file.gif";
if ($ext == "PDF") {
$type = "PDF-File";
$pic = "pdf.png";
} else {
if (in_array($ext, array("ODT", "ODF", "SXW", "STW", "WPD", "DOC", "TXT", "RTF", "LWP", "WPS"))) {
$type = "Textdokument";
$pic = "text.png";
} else {
if (in_array($ext, array("ODS", "SXC", "STC", "VOR", "XLS", "CSV", "123"))) {
$type = "Tabellendokument";
$pic = "calc.png";
} else {
if (in_array($ext, array("ODP", "SXI", "SDP", "POT", "PPS"))) {
$type = "Präsentation";
$pic = "praesent.png";
} else {
if (in_array($ext, array("ODG", "SXD", "SDA", "SVG", "SDD", "DXF"))) {
$type = "Zeichnungen";
$pic = "zeichng.png";
} else {
if (in_array($ext, array("HTM", "HTML", "STW", "SSI", "OTH"))) {
$type = "Webseiten";
$pic = "web.png";
} else {
if (in_array($ext, array("DBF", "ODB"))) {
$type = "Datenbank";
$pic = "db.png";
} else {
if (in_array($ext, array("PS", "EPS"))) {
$type = "Postscript";
$pic = "ps.png";
} else {
if (in_array($ext, array("GZ", "TGZ", "BZ", "ZIP", "TBZ"))) {
$type = "Komprimiert";
$pic = "zip.png";
} else {
if (in_array($ext, array("MP3", "OGG", "WAV"))) {
$type = "Audiodatei";
$pic = "sound.png";
} else {
if (in_array($ext, array("BMP", "GIF", "JPG", "JPEG", "PNG", "TIF", "PGM", "PPM", "PCX", "PSD", "TIFF"))) {
$type = "Grafik-Datei";
$pic = "grafik.png";
} else {
if (in_array($ext, array("WMF", "MOV", "AVI", "VOB", "MPG", "MPEG", "WMV", "RM"))) {
$type = "Video-Datei";
$pic = "video.png";
} else {
if ($ext == "XML") {
$type = "XML-Datei";
$pic = "xml.png";
} else {
if (in_array($ext, array("SH", "BAT"))) {
$type = "Shell-Script";
$pic = "exe.png";
} else {
$type = "Unbekannt";
$pic = "foo.png";
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$info = "<br>{$pfad}" . ($pfad == "/" ? '' : '/') . "<b>{$file}</b><br><br>";
$info .= translate('.:filetyp:.', 'firma') . ": <img src='image/icon/{$pic}'> {$type}<br>";
$info .= translate('.:filesize:.', 'firma') . ": {$size}<br>" . translate('.:filetime:.', 'firma') . ": {$zeit}<br>";
$dbfile = new document();
$rs = $dbfile->searchDocument($file, $pfad);
$id = 0;
if ($rs) {
$rs = $dbfile->getDokument($rs);
if ($rs["lock"] > 0) {
$info .= "<br /><font color='red'>" . translate('.:locked:.', 'firma') . " : " . $rs["lockname"] . "</font><br />";
}
$info .= "<br>" . translate('.:Description update:.', 'firma') . ": " . db2date($rs["datum"]) . " " . $rs["zeit"] . "<br>";
$info .= translate('.:Description:.', 'firma') . ": " . nl2br($rs["descript"]) . "<br>";
$id = $rs["id"];
}
echo json_encode(array('docname' => $file, 'docoldname' => $file, 'docpfad' => $pfad, 'docid' => $id, 'docdescript' => $rs["descript"], 'fbright' => $info, 'lock' => $rs["lock"]));
}
echo $menu['pre_content'];
echo $menu['start_content'];
?>
<div class="ui-widget-content" style="height:600px">
<br />
<p class="ui-state-highlight ui-corner-all" style="margin-top: 20px; padding: 0.6em;"><?php
echo translate(".:notes:.", "work");
?>
</p>
<table >
<?php
$liste = getAllPostIt($_SESSION["loginCRM"]);
if ($liste) {
foreach ($liste as $row) {
echo "<tr class='klein'><td>";
echo db2date(substr($row["date"], 0, 10)) . " " . substr($row["date"], 11, 5);
echo "</td><td> [<a href='postit.php?hole=" . $row["id"] . "'>" . $row["cause"] . "</a>]</td></tr>\n";
}
}
?>
</table>
<form name="postit" method="post" action="postit.php">
<input type="hidden" name="id" value="<?php
echo $data["id"];
?>
">
<input type="text" name="cause" size="90" maxlength="100" value="<?php
echo $data["cause"];
?>
"><br />
<textarea class="normal" rows="7" cols="80" name="notes"><?php
function vartpl(&$t, $daten, $typ, $msg, $btn1, $btn2, $tpl, $suchmaske = false, $ui = false)
{
$jscal = "<style type='text/css'>@import url(../js/jscalendar/calendar-win2k-1.css);</style>\n";
$jscal .= "<script type='text/javascript' src='../js/jscalendar/calendar.js'></script>\n";
$jscal .= "<script type='text/javascript' src='../js/jscalendar/lang/calendar-de.js'></script>\n";
$jscal .= "<script type='text/javascript' src='../js/jscalendar/calendar-setup.js'></script>\n";
if (isset($daten["grafik"])) {
if ($typ == "C") {
$DIR = "C" . $daten["customernumber"];
} else {
$DIR = "V" . $daten["vendornumber"];
}
if (file_exists("dokumente/" . $_SESSION["dbname"] . "/{$DIR}/logo." . $daten["grafik"])) {
$Image = "<img src='dokumente/" . $_SESSION["dbname"] . "/{$DIR}/logo." . $daten["grafik"] . "' " . $daten["icon"] . ">";
} else {
$Image = "Bild ({$DIR}/logo." . $daten["grafik"] . ") nicht<br>im Verzeichnis";
}
} else {
$Image = '';
}
$tmp = false;
if (!$suchmaske) {
$tmp = getVariablen($daten["id"]);
}
$varablen = $tmp > 0 ? count($tmp) . " Variablen" : "";
if ($ui) {
$t->set_file(array("fa1" => "companies" . $tpl . ".tpl"));
} else {
$t->set_file(array("fa1" => "firmen" . $tpl . ".tpl"));
}
if (isset($daten["employee"]) and $daten['employee'] > 0) {
$employee = $daten["employee"];
} else {
if (isset($daten["modemployee"])) {
$employee = "ERP " . $daten["modemployee"];
} else {
$employee = '';
}
}
$t->set_var(array('FAART' => $typ == "C" ? ".:Customer:." : ".:Vendor:.", 'FAART2' => $typ == "C" ? ".:Customer Name:." : ".:Vendor Name:.", 'mtime' => isset($daten["mtime"]) ? $daten['mtime'] : '', 'Q' => $typ, 'Btn1' => $btn1, 'Btn2' => $btn2, 'Msg' => $msg, 'preon' => isset($daten["pre"]) ? "checked" : '', 'action' => $ui ? "" : "firmen" . $tpl . ".php?Q={$typ}", 'id' => isset($daten["id"]) ? $daten['id'] : '', 'customernumber' => isset($daten["customernumber"]) ? $daten["customernumber"] : '', 'vendornumber' => isset($daten["vendornumber"]) ? $daten["vendornumber"] : '', 'kdnr' => isset($daten["nummer"]) ? $daten["nummer"] : '', 'v_customer_id' => isset($daten["v_customer_id"]) ? $daten["v_customer_id"] : '', 'name' => isset($daten["name"]) ? $daten["name"] : '', 'greeting_' => isset($daten["greeting_"]) ? $daten["greeting_"] : '', 'department_1' => isset($daten["department_1"]) ? $daten["department_1"] : '', 'department_2' => isset($daten["department_2"]) ? $daten["department_2"] : '', 'street' => isset($daten["street"]) ? $daten["street"] : '', 'country' => isset($daten["country"]) ? $daten["country"] : '', 'zipcode' => isset($daten["zipcode"]) ? $daten["zipcode"] : '', 'city' => isset($daten["city"]) ? $daten["city"] : '', 'phone' => isset($daten["phone"]) ? $daten["phone"] : '', 'fax' => isset($daten["fax"]) ? $daten["fax"] : '', 'email' => isset($daten["email"]) ? $daten["email"] : '', 'homepage' => isset($daten["homepage"]) ? $daten["homepage"] : '', 'sw' => isset($daten["sw"]) ? $daten["sw"] : '', 'konzern' => isset($daten["konzern"]) ? $daten["konzern"] : '', 'konzernname' => isset($daten["konzernname"]) ? $daten["konzernname"] : '', 'branche_' => isset($daten["branche_"]) ? $daten["branche_"] : '', 'ustid' => isset($daten["ustid"]) ? $daten["ustid"] : '', 'taxnumber' => isset($daten["taxnumber"]) ? $daten["taxnumber"] : '', 'contact' => isset($daten["contact"]) ? $daten["contact"] : '', 'leadsrc' => isset($daten["leadsrc"]) ? $daten["leadsrc"] : '', 'notes' => isset($daten["notes"]) ? $daten["notes"] : '', 'bank' => isset($daten["bank"]) ? $daten["bank"] : '', 'bank_code' => isset($daten["bank_code"]) ? $daten["bank_code"] : '', 'iban' => isset($daten["iban"]) ? $daten["iban"] : '', 'bic' => isset($daten["bic"]) ? $daten["bic"] : '', 'headcount' => isset($daten["headcount"]) ? $daten["headcount"] : '', 'direct_debit' . (isset($daten['direct_debit']) ? $daten['direct_debit'] : '') => "checked", 'account_number' => isset($daten["account_number"]) ? $daten["account_number"] : '', 'terms' => isset($daten["terms"]) ? $daten["terms"] : '', 'kreditlim' => isset($daten["creditlimit"]) ? $daten["creditlimit"] : '', 'umsatz' => isset($daten["umsatz"]) ? $daten["umsatz"] : '', 'op' => isset($daten["op"]) ? $daten["op"] : '', 'preisgrp' => isset($daten["preisgroup"]) ? $daten["preisgroup"] : '', 'IMG' => $Image, 'grafik' => isset($daten["grafik"]) ? $daten["grafik"] : '', 'init' => $employee, 'login' => $_SESSION["login"], 'employee' => $_SESSION["loginCRM"], 'password' => isset($_SESSION["password"]) ? $_SESSION["password"] : '', 'txid' . (isset($daten["taxzone_id"]) ? $daten["taxzone_id"] : '') => "selected", 'GEODB' => $_SESSION['GEODB'] == 't' ? '1==1' : '1>2', 'GEOS' => $_SESSION['GEODB'] == 't' ? "visible" : "hidden", 'GEO1' => $_SESSION['GEODB'] == 't' ? '' : "!--", 'GEO2' => $_SESSION['GEODB'] == 't' ? '' : "--", 'BLZ1' => $_SESSION['BLZDB'] == 't' ? '' : "!--", 'BLZ2' => $_SESSION['BLZDB'] == 't' ? '' : "--", 'cvars' => isset($daten['id']) ? cvar_edit($daten["id"]) : '', 'variablen' => $varablen));
$jahre = getUmsatzJahre($typ == "C" ? "ar" : "ap");
doBlock($t, "fa1", "YearListe", "YL", $jahre, "year", "year", $daten["year"]);
$lang = getLanguage();
doBlock($t, "fa1", "LAnguage", "LA", $lang, "id", "description", $daten["language_id"]);
$kdtyp = getBusiness();
doBlock($t, "fa1", "TypListe", "BT", $kdtyp, "id", "description", $daten["business_id"]);
$lead = getLeads();
doBlock($t, "fa1", "LeadListe", "LL", $lead, "id", "lead", $daten["lead"]);
if (isset($daten['id'])) {
$shiptos = getAllShipto($daten["id"], $typ);
doBlock($t, "fa1", "shiptos", "ST", $shiptos, "shipto_id", array("shiptoname", "shiptostreet", "shiptocity"), false);
}
$anreden = getAnreden();
doBlock($t, "fa1", "anreden", "A", $anreden, "greeting", "greeting", isset($daten["greeting"]) ? $daten["greeting"] : '');
$payment = getPayment();
doBlock($t, "fa1", "payment", "P", $payment, "id", "description", isset($daten["payment_id"]) ? $daten["payment_id"] : '');
$branchen = getBranchen();
doBlock($t, "fa1", "branchen", "BR", $branchen, "branche", "branche", isset($daten["branche"]) ? $daten["branche"] : '');
$bundesland = getBundesland(strtoupper($daten["country"]));
doBlock($t, "fa1", "buland", "BL", $bundesland, "id", "bundesland", isset($daten["bland"]) ? $daten["bland"] : '');
$curr = getCurrencies();
doBlock($t, "fa1", "currency", "C", $curr, "id", "name", isset($daten["currency_id"]) ? $daten["currency_id"] : '');
$cvars = getCvars();
$t->set_block('fa1', 'cvarListe', 'BlockCV');
if ($cvars) {
$i = 1;
foreach ($cvars as $cvar) {
switch ($cvar["type"]) {
case "bool":
$fld = "<input type='checkbox' name='vc_cvar_" . $cvar["name"] . "' value='t'";
if (isset($daten["vc_cvar_" . $cvar["name"]]) and $daten["vc_cvar_" . $cvar["name"]] == "t") {
$fld .= " checked";
}
$fld .= ">";
break;
case "date":
$fld = "<input type='text' name='vc_cvar_" . $cvar["name"] . "' size='10' value='";
$fld .= db2date($daten["vc_cvar_" . $cvar["name"]]) . "' id='cvar_" . $cvar["name"] . "'>";
$fld .= "<input name='cvar_" . $cvar["name"] . "_button' id='cvar_" . $cvar["name"] . "_trigger' type='button' value='?'>";
$fld .= '<script type="text/javascript"><!-- ' . "\n";
$fld .= 'Calendar.setup({ inputField : "cvar_' . $cvar["name"] . '",';
$fld .= 'ifFormat : "%d.%m.%Y",';
$fld .= 'align : "BL",';
$fld .= 'button : "cvar_' . $cvar["name"] . '_trigger"});';
$fld .= "\n" . '--></script>' . "\n";
break;
case "select":
$o = explode("##", $cvar["options"]);
$fld = "<select name='vc_cvar_" . $cvar["name"] . "'>\n<option value=''>---------\n";
foreach ($o as $tmp) {
$fld .= "<option value='{$tmp}'";
if ($daten["vc_cvar_" . $cvar["name"]] == $tmp) {
$fld .= " selected";
}
$fld .= ">{$tmp}\n";
}
$fld .= "</select>";
break;
case "customer":
$name = getCvarName($daten['vc_cvar_' . $cvar['name']]);
$fld = "<input type='hidden' name='vc_cvar_" . $cvar["name"] . "' value='";
$fld .= $daten['vc_cvar_' . $cvar['name']] . "'>";
$fld .= $name . ' (' . $daten['vc_cvar_' . $cvar['name']] . ')';
break;
default:
$fld = '<input type="text" name="vc_cvar_' . $cvar['name'] . '" value="';
$fld .= $daten['vc_cvar_' . $cvar['name']] . '">';
}
$t->set_var(array('varlable' . $i => $cvar["description"], 'varfld' . $i => $fld));
if ($i == 1) {
$i = 2;
} else {
$i = 1;
$t->parse('BlockCV', 'cvarListe', true);
}
}
if ($i == 2) {
$t->set_var(array('varlable2' => "", 'varfld2' => ""));
$t->parse('BlockCV', 'cvarListe', true);
}
}
if (!$suchmaske) {
$bundesland = getBundesland(strtoupper($daten["shiptocountry"]));
doBlock($t, "fa1", "buland2", "BS", $bundesland, "id", "bundesland", $daten["shiptobland"]);
$employees = getAllUser(array(0 => true, 1 => "%"));
doBlock($t, "fa1", "SalesmanListe", "SM", $employees, "id", "name", $daten["salesman_id"]);
/* Check if the user is allowed to change the access group - Behaviour changed by DO:
Let (all) users change the group if none is set yet */
if (!isset($daten["employee"]) || $daten["employee"] == $_SESSION["loginCRM"] || $daten["modemployee"] == $_SESSION["loginCRM"]) {
$first[] = array("grpid" => "", "rechte" => "w", "grpname" => ".:public:.");
$first[] = array("grpid" => $_SESSION["loginCRM"], "rechte" => "w", "grpname" => ".:personal:.");
$grps = getGruppen();
if ($grps) {
$user = array_merge($first, $grps);
} else {
$user = $first;
}
doBlock($t, "fa1", "OwenerListe", "OL", $user, "grpid", "grpname", $daten["owener"]);
} else {
$user[0] = array("grpid" => $daten["owener"], "grpname" => $daten["owener"] ? getOneGrp($daten["owener"]) : ".:public:.");
doBlock($t, "fa1", "OwenerListe", "OL", $user, "grpid", "grpname", $daten["owener"]);
/*$t->set_var(array(
grpid => $daten["owener"],
Gsel => "selected",
Gname => ($daten["owener"])?getOneGrp($daten["owener"]):".:public:.",
));
$t->parse("Block","OwenerListe",true);*/
}
}
//if (!$suchmaske)
}
include "inc/FirmenLib.php";
include 'inc/phpOpenOffice.php';
if ($_GET["Q"] == "C") {
$fa = getFirmenStamm($_GET["fid"], true, "C");
$fa["number"] = $fa["customernumber"];
} else {
$fa = getFirmenStamm($_GET["fid"], true, "V");
$fa["number"] = $fa["vendornumber"];
$fa["kdtyp"] = $fa["lityp"];
}
foreach ($fa as $key => $val) {
$fa[$key] = utf8_decode($val);
}
$var = array();
if ($key == "typrabatt") {
$val = $val * 100;
}
$fa["typrabatt"] = $fa["typrabatt"] * 100;
$fa["creditlimit"] = sprintf("%0.2f", $fa["creditlimit"]);
$fa["discount"] = sprintf("%0.2f", $fa["discount"] * 100);
$fa["itime"] = db2date($fa["itime"]);
$fa["mtime"] = db2date($fa["mtime"]);
$doc = new phpOpenOffice();
if (file_exists("vorlage/firmenkartei.sxw")) {
$doc->loadDocument("vorlage/firmenkartei.sxw");
} else {
$doc->loadDocument("vorlage/firmenkartei.odt");
}
$doc->parse($fa);
$doc->download("");
$doc->clean();
?>
<html>
<head><title></title>
<!-- ERP Stylesheet -->
<?php
echo $menu['stylesheets'];
?>
<link type="text/css" REL="stylesheet" HREF="<?php
echo $_SESSION['baseurl'] . 'css/' . $_SESSION["stylesheet"];
?>
/main.css">
<body>
<!-- Hier beginnt die Karte ------------------------------------------->
<tt>
<?php
echo $header . " vom " . db2date($tmp[1]["transdate"]) . " Währung {$curr}";
?>
<br>
<?php
echo $header2;
?>
<br>
<?php
echo $header3;
?>
<br>
</tt>
<table width="100%">
<tr class='smal'><td>Rechnung Anschrift</td><td>Lieferanschrift</td><td></td></tr>
<tr class="big"><td><?php
echo $adr["name"] . "<br>" . $adr["street"] . "<br>" . $adr["zipcode"] . " " . $adr["city"];
}
if (!$rep["aid"]) {
$disp2 = "style='display:none'";
$disp3 = $disp2;
$sel1 = "checked";
$sel2 = "";
$sel3 = "";
} else {
if ($rep["status"] == 1) {
$disp3 = "style='display:none'";
$sel1 = "checked";
$sel2 = "";
$sel3 = "";
} else {
if ($rep["status"] == 2) {
$disp1 = "style='display:none'";
$sel2 = "checked";
$sel1 = "";
$sel3 = "";
} else {
if ($rep["status"] == 3) {
$disp1 = "style='display:none'";
$sel3 = "checked";
$sel1 = "";
$sel2 = "";
}
}
}
}
$t->set_var(array(action => "repauftrag.php", msg => $msg, AID => $rep["aid"], mid => $mid, name => $firma["name"], kdnr => $firma["id"], customernumber => $firma["customernumber"], strasse => $firma["street"], plz => $firma["zipcode"], ort => $firma["city"], telefon => $firma["phone"], standort => $masch["standort"], description => $masch["description"], serialnumber => $masch["serialnumber"], contractnumber => $masch["contractnumber"], cid => $masch["cid"], schaden => $rep["schaden"], behebung => $rep["reparatur"], bearbdate => db2date(substr($rep["bearbdate"], 0, 10)), cause => $rep["cause"], counter => $rep["counter"], datum => $rep["datum"], anlagedatum => db2date(substr($rep["anlagedatum"], 0, 10)), sel1 => $sel1, sel2 => $sel2, sel3 => $sel3, disp1 => $disp1, disp2 => $disp2, disp3 => $disp3));
$t->pparse("out", array("masch"));
}
if ($rc) {
$msg = "Maschine gesichert";
} else {
$msg = "Fehler beim Sichern";
}
$data = getArtikel($_POST["partnumber"]);
$data = $data[0];
$pid = $data["id"];
$nummern = getNumber($data["id"]);
$bekannt = getBekannt($data["id"]);
}
}
$t->set_file(array("masch" => "maschinen3.tpl"));
doHeader($t);
$t->set_var(array(action => "maschine3.php", msg => $msg, parts_id => $pid, mid => $data["mid"], inspdatum => db2date($data["inspdatum"]), snumber => $data["serialnumber"], partnumber => $data["partnumber"], description => $data["description"], notes => $data["notes"], beschreibung => $data["beschreibung"]));
$t->set_block("masch", "Bekannt", "Block1");
if ($bekannt) {
foreach ($bekannt as $zeile) {
$t->set_var(array(maschine => $zeile["serialnumber"]));
$t->parse("Block1", "Bekannt", true);
}
}
$t->set_block("masch", "Sernumber", "Block2");
if ($nummern) {
foreach ($nummern as $zeile) {
$t->set_var(array(Snumber => $zeile["serialnumber"]));
$t->parse("Block2", "Sernumber", true);
}
}
$t->pparse("out", array("masch"));
