Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
|
|
modellbau:hklist [2017/04/13 18:26] |
modellbau:hklist [2020/11/01 16:40] (aktuell) |
| ~~NOCACHE~~ |
| ====== HobbyKing Artikel Lister ====== |
| |
| |
| <form> |
| Action csv |
| Thanks "Danke für den Vorschlag." |
| |
| fieldset "Ein neues Produkt eintragen" |
| number "Produkt ID" |
| select "Produktkategory wählen" "sonstiges|BL|LiPo|Empfänger|Servo|Regler|Flugzeug|Sender|Sendermodul|Zubehör|keine passende Kategorie vorhanden" |
| select "Hersteller" "HobbyKing|Assan|Rhino|Turnigy|OrangeRx|HXT|Corona|Zippy|kein passender Hersteller vorhanden" |
| email "Deine email Adresse" ! |
| |
| submit |
| </form> |
| |
| |
| ====== Alle Produkte im tracking ====== |
| |
| <hktables> |
| SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc; |
| </hktables> |
| |
| ====== Produkte nach Hersteller ====== |
| ===== Assan ===== |
| |
| <hktables> |
| SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE i.vendor='Assan' AND h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc; |
| </hktables> |
| |
| |
| ===== OrangeRx ===== |
| |
| <hktables> |
| SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE i.vendor='OrangeRx' AND h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc; |
| </hktables> |