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