~~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>