praxissemester martin amelsberg daniel finger 09. november 2004
TRANSCRIPT
![Page 1: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/1.jpg)
Praxissemesterwww.EUcoupon.de
Martin AmelsbergDaniel Finger
09. November 2004
![Page 2: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/2.jpg)
Praxissemester
Übersicht
Vorstellung der Firma Vorstellung der Mitarbeiter Beschreibung des Gesamtsystems Administrationsbereich
![Page 3: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/3.jpg)
Praxissemester
Vorstellung der Firma
SCT Research & Consulting Odenthal SAP
![Page 4: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/4.jpg)
Praxissemester
Vorstellung der Mitarbeiter
Udo und Imke Stadelmann Mike Burg Daniela Sieberer Gerd Daniels Franz Flasch (eTouris GmbH)
![Page 5: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/5.jpg)
Praxissemester
Vorstellung des Gesamtsystems (1)
Couponing-System Benutzergruppen
Anbieter Verbraucher Vertriebsmitarbeiter
![Page 6: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/6.jpg)
Praxissemester
Vorstellung des Gesamtsystems (2)
Beispiel 1 Schlachter Müller Lieschen Meyer
Beispiel 2 Ski-Ausrüstung
![Page 7: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/7.jpg)
Praxissemester
Vorstellung des Gesamtsystems (3)
![Page 8: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/8.jpg)
Praxissemester
Vorstellung des Gesamtsystems (4)
![Page 9: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/9.jpg)
Praxissemester
Administrationsbereich
Verwaltung aller Benutzergruppen Statistiken und Log-Daten Rechnungsverwaltung Textverwaltung
AGB, Datenschutz,… Applikation allgemein
![Page 10: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/10.jpg)
Praxissemester
Fragen?
![Page 11: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/11.jpg)
Praxissemester
Übersicht
Suchkriterien Suchkriterien definieren Programmier-Anforderungen Beispiel eines SQL-Befehls
![Page 12: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/12.jpg)
Praxissemester
Suchkriterien
Region Branche / Kategorie Inhalt Zeit
![Page 13: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/13.jpg)
Praxissemester
Suchkriterien definieren (1)
Region (geographische Suche)
![Page 14: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/14.jpg)
Praxissemester
Suchkriterien definieren (2)
Branche
![Page 15: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/15.jpg)
Praxissemester
Suchkriterien definieren (3)
Kategorie
![Page 16: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/16.jpg)
Praxissemester
Suchkriterien definieren (4)
Inhalt Zeit
![Page 17: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/17.jpg)
Praxissemester
Programmier-Anforderungen
Geringer Wartungsaufwand Aufteilung in Themenblöcke
Hohe Performance Alle Kriterien in einem SQL Begrenzung auf 50 Datensätze Sortiert MySQL macht die Arbeit
![Page 18: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/18.jpg)
Praxissemester
Beispiel eines SQL-Befehls
![Page 19: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/19.jpg)
Praxissemester
SELECTcoupon_id, coupon_title, coupon_cat,
coupon_branche, coupon_end, coupon_limit, coupon_typ, coupon_pcode,
coupon_value FROM
coupons_from_business, coupons_ref_business, user_business
WHERE(business_id = coupons_user_id) AND
(coupons_coupon_id = coupon_id) AND (coupon_active = '1') AND (coupon_locked = '0') AND […]
![Page 20: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/20.jpg)
Praxissemester
(coupon_limit > 0) AND ( (coupon_publ_start <= NOW()) OR (coupon_publ_start = '0000-00-00
00:00:00') ) AND ( (coupon_publ_end >= NOW()) OR
(coupon_publ_end = '0000-00-00 00:00:00') ) AND
( (coupon_end >= NOW()) OR (coupon_end = '0000-00-00 00:00:00')
) AND […]
![Page 21: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/21.jpg)
Praxissemester
(coupon_country = 'de') AND(LEFT(coupon_kgs,8) = '05374008') AND(coupon_branche = 'O') AND (coupon_cat = '444') AND
((MATCH(coupon_title) AGAINST ('Tagesblatt')) OR (MATCH(company) AGAINST ('Tagesblatt')) OR
(MATCH(coupon_detail) AGAINST ('Tagesblatt')) OR (MATCH(coupon_text) AGAINST ('Tagesblatt')))
![Page 22: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/22.jpg)
Praxissemester
AND ((UNIX_TIMESTAMP (DATE_FORMAT (coupon_start,'%Y-%m-%d 00:00:00')) <= 1099087200) AND (UNIX_TIMESTAMP (DATE_FORMAT (coupon_end,'%Y-%m-%d 23:59:59')) >= 1099087200)) AND(coupon_publ_start >= DATE_SUB(NOW(),INTERVAL 7
DAY)) ORDER BY coupon_cat LIMIT 0 , 50
![Page 23: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/23.jpg)
Praxissemester
Fragen?
![Page 24: Praxissemester Martin Amelsberg Daniel Finger 09. November 2004](https://reader036.vdokument.com/reader036/viewer/2022062312/55204d8049795902118d2860/html5/thumbnails/24.jpg)
Praxissemester
www.AmelFin.de