def get(self,ids=[]):
dao = OrderItemDao()
rows = dao.get(ids)
orderItems = []
for row in rows:
orderItems.append(OrderItem(row[0],row[1],row[2],row[3],row[4],row[5],row[6],row[7],row[8],row[9],row[10],row[11],row[12],row[13],row[14],row[15],row[16]))
return orderItems
def insert(self , orderItems):
dao = OrderItemDao()
values = [(oi.supplier_id,oi.csp_id,oi.csp_contact_id,oi.owner_id,oi.airline_id,
oi.csp_po_number,oi.supplier_invoice_number, # oi.owner_po_number,
oi.title,oi.comments,oi.start_date,oi.end_date,oi.unit_price, oi.units,
oi.delivery_format, oi.total_price,oi.delivery_date) for oi in orderItems]
ids = dao.insert(values)
newOrderItems = self.get(ids)
#set the default phone and email types
return newOrderItems
def update(self, orderItems):
dao = OrderItemDao()
values = [(oi.id, oi.supplier_id,oi.csp_id,oi.csp_contact_id,oi.owner_id,oi.airline_id,
oi.csp_po_number,oi.supplier_invoice_number, #oi.owner_po_number,
oi.title,oi.comments,oi.start_date,oi.end_date,oi.unit_price, oi.units,
oi.delivery_format, oi.total_price,oi.delivery_date) for oi in orderItems]
dao.update(values)
ids = [(oi.id) for oi in orderItems]
updatedOrderItems = self.get(ids)
return updatedOrderItems
