Ejemplo n.º 1
0
function Buland($land)
{
    $data = getBundesland(strtoupper($land));
    $rs = array(array('id' => '', 'val' => ''));
    foreach ($data as $row) {
        array_push($rs, array('id' => $row['id'], 'val' => $row['bundesland']));
    }
    echo json_encode($rs);
}
Ejemplo n.º 2
0
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)
}