Subversion-Projekte lars-tiefland.content-management

Revision

Revision 1 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1 Revision 2
Zeile 30... Zeile 30...
30 
 
 30 
 
31 
        }
 31 
        }
Zeile 32... Zeile 32...
32 
    }
 32 
    }
33 
 
 33 
 
34 
    $query = "
 34 
    $query = "
35 
		select
 35 
        select
36 
			b.ID															as POOL_REFNR,
 36 
            b.ID                                                            as POOL_REFNR,
37 
			b.shops_ID														as POOL_V_ABS_REFNR,
 37 
            b.shops_ID                                                      as POOL_V_ABS_REFNR,
38 
			substring(b.Bemerkung,locate('\n',b.Bemerkung)+1)				as POOL_V_ABS_BEMERKUNG,
 38 
            substring(b.Bemerkung,locate('\n',b.Bemerkung)+1)               as POOL_V_ABS_BEMERKUNG,
39 
			'464338'														as POOL_V_MAND_REFNR,
 39 
            '464338'                                                        as POOL_V_MAND_REFNR,
40 
			if (b.liefer_Land!='',(if (b.liefer_Land='Deutschland','$POOL_VERTRAG_Inland','$POOL_VERTRAG_Ausland')),(if (l.Land='Deutschland','$POOL_VERTRAG_Inland','$POOL_VERTRAG_Ausland')))
 40 
            if (b.liefer_Land!='',(if (b.liefer_Land='Deutschland','$POOL_VERTRAG_Inland','$POOL_VERTRAG_Ausland')),(if (l.Land='Deutschland','$POOL_VERTRAG_Inland','$POOL_VERTRAG_Ausland')))
41 
																			as POOL_VERTRAG,
 41 
                                                                            as POOL_VERTRAG,
42 
			if (b.liefer_Str_Nr!='',b.liefer_Str_Nr,l.Hausnummer)			as POOL_EMPF_HAUSNUMMER,
 42 
            if (b.liefer_Str_Nr!='',b.liefer_Str_Nr,l.Hausnummer)           as POOL_EMPF_HAUSNUMMER,
43 
			floor(a.short_line_2)											as POOL_V_PRODUKT_CN,
 43 
            floor(a.short_line_2)                                           as POOL_V_PRODUKT_CN,
44 
			a.short_line_2													as POOL_V_xxxxx,
 44 
            a.short_line_2                                                  as POOL_V_xxxxx,
45 
			'EUR'															as POOL_V_NN_WAEHRUNG,
 45 
            'EUR'                                                           as POOL_V_NN_WAEHRUNG,
46 
			'EUR'															as POOL_WERT_WAEHRUNG,
 46 
            'EUR'                                                           as POOL_WERT_WAEHRUNG,
47 
			l.ID															as POOL_EMPF_REFNR,
 47 
            l.ID                                                            as POOL_EMPF_REFNR,
48 
			if (b.liefer_Name!='',(if (b.liefer_Firma='',if(b.liefer_Vorname!='',concat(b.liefer_Vorname,' ', b.liefer_Name),b.liefer_Name),b.liefer_Firma)),(if (l.Name2='',trim(concat(l.Vorname,' ',l.Name1)),l.Name2)))					as POOL_EMPF_NAME1,
 48 
            if (b.liefer_Name!='',(if (b.liefer_Firma='',if(b.liefer_Vorname!='',concat(b.liefer_Vorname,' ', b.liefer_Name),b.liefer_Name),b.liefer_Firma)),(if (l.Name2='',trim(concat(l.Vorname,' ',l.Name1)),l.Name2)))                                  as POOL_EMPF_NAME1,
49 
			if (b.liefer_Firma!='',b.liefer_Name,(if(l.Name2='',if(l.Vorname!='',concat(l.Vorname,' ',l.Name2),l.Name2),'')))							as POOL_EMPF_NAME2,
 49 
            if (b.liefer_Firma!='',b.liefer_Name,(if(l.Name2!='',if(l.Vorname!='',concat(l.Vorname,' ',l.Name1),l.Name1),'')))                                        as POOL_EMPF_NAME2,
50 
			if (b.liefer_PLZ!='',b.liefer_PLZ,l.PLZ)						as POOL_EMPF_PLZ,
 50 
            if (b.liefer_PLZ!='',b.liefer_PLZ,l.PLZ)                        as POOL_EMPF_PLZ,
51 
			if (b.liefer_Ort!='',b.liefer_Ort,l.ORT)						as POOL_EMPF_ORT,
 51 
            if (b.liefer_Ort!='',b.liefer_Ort,l.ORT)                        as POOL_EMPF_ORT,
52 
			if (b.liefer_Strasse!='',b.liefer_Strasse,l.Strasse)			as POOL_EMPF_STRASSE,
 52 
            if (b.liefer_Strasse!='',b.liefer_Strasse,l.Strasse)            as POOL_EMPF_STRASSE,
53 
			if (b.liefer_Land!='',b.liefer_Land,l.Land)						as POOL_EMPF_LANDCODE,
 53 
            if (b.liefer_Land!='',b.liefer_Land,l.Land)                     as POOL_EMPF_LANDCODE,
54 
			l.E_Mail														as POOL_EMPF_MAIL,
 54 
            l.E_Mail                                                        as POOL_EMPF_MAIL,
55 
			ab.ID															as ID,
 55 
            ab.ID                                                           as ID,
56 
			IF (ab.Bezeichnung LIKE '%Nachnahme%', CONCAT('134=',b.gesamtsumme_buffer),'') as POOL_V_EXTRASLST,
 56 
            IF (ab.Bezeichnung LIKE '%Nachnahme%', CONCAT('134=',b.gesamtsumme_buffer),'') as POOL_V_EXTRASLST,
57 
			l.Telefon														as POOL_EMPF_TEL
 57 
            l.Telefon                                                       as POOL_EMPF_TEL
58
58
59 
		from
 59 
        from
60 
			Bestellung AS b,
 60 
            Bestellung AS b,
61 
			artikel_to_Bestellung AS ab,
 61 
            artikel_to_Bestellung AS ab,
62 
			artikel AS a,
 62 
            artikel AS a,
63 
			Logins AS l
 63 
            Logins AS l
64 
		where
 64 
        where
65 
			(a.Father =-3)
 65 
            (a.Father =-3)
66 
			and
 66 
            and
67 
			(a.ID=ab.artikel)
 67 
            (a.ID=ab.artikel)
68 
			and
 68 
            and
69 
			(ab.Bestellung = b.ID)
 69 
            (ab.Bestellung = b.ID)
70 
			and
 70 
            and
71 
			(b.Login = l.ID)
 71 
            (b.Login = l.ID)
72 
			and
 72 
            and
73 
			(b.Language = a.Language)
 73 
            (b.Language = a.Language)
74 
		";
 74 
        ";
75 
    if ( $_GET[time] )
 75 
    if ( $_GET[time] )
76 
    {
 76 
    {
77 
        $query .= " and (ab.exported  = '" . $_GET[time] . "')";
 77 
        $query .= " and (ab.exported  = '" . $_GET[time] . "')";
Zeile 97... Zeile 97...
97 
            echo implode( array_keys( $zeile ), $trenner ) . "\n\n ";
 97 
            echo implode( array_keys( $zeile ), $trenner ) . "\n\n ";
98 
            $firstline = false;
 98 
            $firstline = false;
99 
        }
 99 
        }
Zeile 100... Zeile 100...
100 
 
 100 
 
101 
        $result_gesBetrag = mysql_query( "
 101 
        $result_gesBetrag = mysql_query( "
102 
			select
 102 
            select
103 
				artikel_to_Bestellung.*,
 103 
                artikel_to_Bestellung.*,
104 
				(Menge * Preis_pro_Stueck) as gesBetrag,
 104 
                (Menge * Preis_pro_Stueck) as gesBetrag,
105 
                (Menge * gewicht) as gesGewicht,
 105 
                (Menge * gewicht) as gesGewicht,
106 
				artikel.kurzbezeichnung,
 106 
                artikel.kurzbezeichnung,
107 
				artikel.Father
 107 
                artikel.Father
108 
			from
 108 
            from
109 
				artikel_to_Bestellung,
 109 
                artikel_to_Bestellung,
110 
				artikel
 110 
                artikel
111 
			where
 111 
            where
112 
				artikel_to_Bestellung.Bestellung=$zeile[POOL_REFNR]
 112 
                artikel_to_Bestellung.Bestellung=$zeile[POOL_REFNR]
113 
				and
 113 
                and
114 
				artikel_to_Bestellung.artikel = artikel.ID
 114 
                artikel_to_Bestellung.artikel = artikel.ID
115 
				and
 115 
                and
116 
				artikel.Language = 'DE'
 116 
                artikel.Language = 'DE'
117 
			order by artikel.Father desc
 117 
            order by artikel.Father desc
118 
		" ) or die( mysql_errno() . ": " . mysql_error() . "<hr>$query<hr>" );
 118 
        " ) or die( mysql_errno() . ": " . mysql_error() . "<hr>$query<hr>" );
119 
        $gesBetrag = 0;
 119 
        $gesBetrag = 0;
120 
        $gesGewicht = 0;
 120 
        $gesGewicht = 0;
121 
        $buffer = array();
 121 
        $buffer = array();
122 
        while ( $zeile_gesBetrag = mysql_fetch_assoc( $result_gesBetrag ) )
 122 
        while ( $zeile_gesBetrag = mysql_fetch_assoc( $result_gesBetrag ) )
Zeile 139... Zeile 139...
139 
            "|" . $gesGewicht;
 139 
            "|" . $gesGewicht;
Zeile 140... Zeile 140...
140 
 
 140 
 
Zeile 141... Zeile 141...
141 
        eval( "\$zeile[POOL_V_EXTRASLST]=\"$zeile[POOL_V_EXTRASLST]\";" );
 141 
        eval( "\$zeile[POOL_V_EXTRASLST]=\"$zeile[POOL_V_EXTRASLST]\";" );
142 
 
 142 
 
143 
        /*
 143 
        /*
144 
        $translate['Deutschland']		="DE";
 144 
        $translate['Deutschland']        ="DE";
145 
        $translate['Niederlande']		="NL";
 145 
        $translate['Niederlande']        ="NL";
146 
        $translate['Österreich']		="AT";
 146 
        $translate['Österreich']        ="AT";
147 
        $translate['Belgien']			="BE";
 147 
        $translate['Belgien']            ="BE";
148 
        $translate['Luxemburg']			="LU";
 148 
        $translate['Luxemburg']            ="LU";
149 
        $translate['Dänemark']			="DK";
 149 
        $translate['Dänemark']            ="DK";
150 
        $translate['Schweiz']			="CH";
 150 
        $translate['Schweiz']            ="CH";
151 
        $translate['Frankreich']		="FR";
 151 
        $translate['Frankreich']        ="FR";
152 
        $translate['Großbritannien']	="GB";
 152 
        $translate['Großbritannien']    ="GB";
153 
        $translate['Italien']			="IT";
 153 
        $translate['Italien']            ="IT";
154 
        $translate['Spanien']			="ES";
 154 
        $translate['Spanien']            ="ES";
155 
        $translate['Portugal']			="PT";
 155 
        $translate['Portugal']            ="PT";
156 
        $translate['Schweden']			="SE";
 156 
        $translate['Schweden']            ="SE";
157 
        $translate['Finnland']			="FI";
 157 
        $translate['Finnland']            ="FI";
158 
        $translate['Norwegen']			="NO";
 158 
        $translate['Norwegen']            ="NO";
159 
        $translate['Irland']			="IE";
 159 
        $translate['Irland']            ="IE";
160 
        $translate['Griechenland']		="GR";
 160 
        $translate['Griechenland']        ="GR";
161 
        $translate['Nederland']			="NL";
 161 
        $translate['Nederland']            ="NL";
Zeile 162... Zeile 162...
162 
        $zeile[POOL_EMPF_LANDCODE]=$translate[$zeile[POOL_EMPF_LANDCODE]];
 162 
        $zeile[POOL_EMPF_LANDCODE]=$translate[$zeile[POOL_EMPF_LANDCODE]];
163 
        */
 163 
        */