Subversion-Projekte lars-tiefland.content-management

<?
        function getShopInfo($shopID)
        {
                static $buffer = array();
                
                if ($buffer == array())
                {
                        $result = mysql_query("select * from shops");
                        while ($r = mysql_fetch_assoc($result))
                        {
                                $buffer[$r["ID"]] = $r;
                        }
                }
                return $buffer[$shopID];
        }
        
        function gibVersandartAuswahl()
        {
                $self = basename($_SERVER[PHP_SELF]);
                $settings = &$_SESSION[$self];
                $shopData = getShopInfo($settings["shop2"]);
                $lstatus=1; // default Lieferstatus
                //pre($shopData);

                // VERSANDARTEN HOLEN


                $tabelle = "artikel";           
                if ($shopData["database"]) $tabelle = $shopData["database"] . "." . $tabelle; 

                $query = array();
                //Lieferstatus & ".$settings["Kundendaten"]["Land"]." = ".$settings["Kundendaten"]["Land"]."
                if($settings["Kundendaten"]["Land"]) $lstatus = $settings["Kundendaten"]["Land"];
                
                $query[0] = "
                        SELECT
                                ID,
                                kurzbezeichnung as kurz,
                                langbezeichnung as lang,
                                beschreibung as beschr,
                                Rang, 
                                preis1 as preis
                        FROM
                                $tabelle
                        WHERE
                                Father = -3
                        AND 
                                Language = '".$shopData["Language"]."'
                        AND 
                                Lieferstatus & ".$lstatus." = ".$lstatus."
                        ";                      

                if ($shopData["database"] == "") $query[1] = " AND status = '" . $settings["shop2"] . "'"; 

                $query[2] = " order by Rang";
                
                if ($result = mysql_query (implode(" ",$query))){
                        if (mysql_num_rows($result) == 0){
                                $query[1] = " AND status = '0'"; 
                        }
                }
                
                //pre(implode(" ",$query));
                $result = mysql_query (implode(" ",$query)); // or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");     

?><table>
        <tr>
                <td>
                        <form name="form_versandart" action="<?=$self;?>" method="POST">
                                <input type="hidden" name="submit_versandart" value="1" />
                                <select name="Versandart" onChange="javascript:kundendaten_sichern('form_versandart');form_versandart.submit()">
                                        <option value="1">--- Bitte wählen ---</option>
                                        <? while($zeile=mysql_fetch_assoc($result)) {
                                        
                                        
                                        ?>
                                        <option value="<?=$zeile[ID];?>"<? if ($settings['versandart'] == $zeile[ID]) {echo " selected"; $settings['versandpreis'] = $zeile["preis"]; } ?> /><?=$zeile[kurz];?></option>
                                        <? } ?>
                                </select>
                        </form>
                </td>
                <td>
                        <form name="form_versandpreis" action="<?=$self;?>" method="POST">
                                <input
                                        type="text"
                                        name="versandpreis"
                                        value="<?=$settings['versandpreis'];?>"
                                        size="4"
                                        onChange="javascript:kundendaten_sichern('form_versandpreis');form_versandpreis.submit()"
                                /> &euro;
                                <input
                                        type="hidden"
                                        name="submit_versandpreis"
                                        value="1"
                                />
                        </form>
                </table>
<? } ?>