<?php require_once "../inc/stdLib.php"; $history_data = accessHistory(); $liste = ''; if ($history_data) { foreach ($history_data as $key => $value) { $liste .= '<li id="' . $value[2] . $value[0] . '"><a href="javascript:void(0);">' . $value[1] . '</a></li>'; } } echo $liste;
function getFirmenStamm($id, $ws = true, $tab = 'C', $cvar = true) { if ($tab == "C") { // Umsätze holen $sql = "select sum(amount) from oe where customer_id={$id} and quotation='f' and closed = 'f'"; $rs = $_SESSION['db']->getOne($sql); $oa = $rs["sum"]; $sql = "select sum(amount) from ar where customer_id={$id} and amount<>paid"; $rs = $_SESSION['db']->getOne($sql); $op = $rs["sum"]; $sql = "select C.*,E.name as verkaeufer,EMP.name as bearbeiter,B.description as kdtyp,B.discount as typrabatt,P.pricegroup,"; $sql .= "L.lead as leadname,BL.bundesland,T.terms_netto,LA.description as language from customer C "; $sql .= "left join employee E on C.salesman_id=E.id left join employee EMP on C.employee=EMP.id "; $sql .= "left join business B on B.id=C.business_id left join bundesland BL on BL.id=C.bland "; $sql .= "left join payment_terms T on T.id=C.payment_id left join pricegroup P on P.id=C.klass "; $sql .= "left join leads L on C.lead=L.id left join language LA on LA.id = C.language_id "; $sql .= "where C.id={$id}"; } else { if ($tab == "V") { // Umsätze holen $sql = "select sum(amount) as summe from ap where vendor_id={$id} and amount<>paid"; $rs = $_SESSION['db']->getOne($sql); $op = $rs["summe"]; $sql = "select sum(amount) from oe where vendor_id={$id} and quotation='f' and closed = 'f'"; $rs = $_SESSION['db']->getOne($sql); $oa = $rs["sum"]; $sql = "select C.*,E.name as verkaeufer,EMP.name as bearbeiter,B.description as kdtyp,B.discount as typrabatt,BL.bundesland,"; $sql .= "L.lead as leadname,LA.description as language from vendor C left join employee EMP on C.employee=EMP.id "; $sql .= "left join employee E on C.salesman_id=E.id left join business B on B.id=C.business_id "; $sql .= "left join language LA on LA.id = C.language_id left join leads L on C.lead=L.id "; $sql .= "left join bundesland BL on BL.id=C.bland "; $sql .= "where C.id={$id}"; } else { return false; } } $row = $_SESSION['db']->getOne($sql); // Rechnungsanschrift if (!$row) { return false; } else { /* history_erp wird wohl nicht richtig gepflegt, also erst einmal raus if ($row["mtime"]=="") { $sql = "select * from history_erp where trans_id = $id and snumbers like '%rnumber_%' order by itime desc limit 1"; $rs2 = $_SESSION['db']->getOne($sql); // Rechnungsanschrift if ($rs2) if ($rs2["itime"]<>$row["itime"]) $row["mtime"] = $rs2["itime"]; $row["modemployee"] = $rs2["employee_id"]; } else { $row["modemployee"] = $row["employee"]; }*/ $row["modemployee"] = $row["employee"]; if ($row["konzern"]) { $sql = "select name from %s where id = %d"; if ($tab == "C") { $krs = $_SESSION['db']->getOne(sprintf($sql, "customer", $row["konzern"])); } else { $krs = $_SESSION['db']->getOne(sprintf($sql, "vendor", $row["konzern"])); } if ($krs) { $row["konzernname"] = $krs["name"]; } } else { $row["konzernname"] = ''; } if ($tab == "C") { $sql = "select count(*) from customer where konzern = " . $id; } else { $sql = "select count(*) from vendor where konzern = " . $id; } $knr = $_SESSION['db']->getOne($sql); $row["konzernmember"] = $knr["count"]; if ($tab == "C") { $nummer = $row["customernumber"]; } else { $nummer = $row["vendornumber"]; } if ($row["grafik"]) { $DIR = $tab . $nummer; $image = "./dokumente/" . $_SESSION["dbname"] . "/{$DIR}/logo." . $row["grafik"]; if (file_exists($image)) { $size = @getimagesize($image); $row["size"] = $size[3]; if ($size[1] > $size[0]) { $faktor = ceil($size[1] / 70); } else { $faktor = ceil($size[0] / 120); } $breite = floor($size[0] / $faktor); $hoehe = floor($size[1] / $faktor); $row["icon"] = "width=\"{$breite}\" height=\"{$hoehe}\""; } else { $daten["name"] = getcwd() . " {$image}: not found"; } } $rs3 = getAllShipto($id, $tab); $shipcnt = count($rs3); $shipids = array(); if ($shipcnt > 0) { for ($sc = 0; $sc < $shipcnt; $sc++) { $shipids[] = "'" . $rs3[$sc]["shipto_id"] . "'"; } $shipids = implode(",", $shipids); } else { $shipids = "0"; } if (empty($rs3)) { // es ist keine abweichende Anschrift da if ($ws) { // soll dann aber mit Re-Anschrift gefüllt werden $row2 = array('shiptoname' => $row["name"], 'shiptodepartment_1' => $row["department_1"], 'shiptodepartment_2' => $row["department_2"], 'shiptostreet' => $row["street"], 'shiptozipcode' => $row["zipcode"], 'shiptocity' => $row["city"], 'shiptocountry' => $row["country"], 'shiptobundesland' => $row["bundesland"], 'shiptocontact' => "", 'shiptophone' => $row["phone"], 'shiptofax' => $row["fax"], 'shiptoemail' => $row["email"], 'shiptocountry' => $row["country"], 'shipto_id' => -1); } else { // leeres Array bilden $row2 = array('shiptoname' => "", 'shiptodepartment_1' => "", 'shiptodepartment_2' => "", 'shiptostreet' => "", 'shiptozipcode' => "", 'shiptocity' => "", 'shiptocountry' => "", 'shiptobundesland' => "", 'shiptocontact' => "", 'shiptophone' => "", 'shiptofax' => "", 'shiptoemail' => "", 'shiptocountrycountry' => "", 'shipto_id' => ""); } } else { $row2 = $rs3[0]; } $daten = array_merge($row2, $row); } //benutzerdef. Variablen: if ($cvar) { $cvars = getFirmaCVars($id); if ($cvars) { $daten = array_merge($daten, $cvars); } } $daten["shiptocnt"] = $shipcnt > 0 ? $shipcnt : 0; $daten["shiptoids"] = $shipids; $daten["op"] = $op; $daten["oa"] = $oa; $daten["nummer"] = $nummer; accessHistory(array($id, $daten['name'], $tab)); return $daten; }