| Rushabh Mehta | a75efa7 | 2013-03-19 17:59:49 +0530 | [diff] [blame^] | 1 | # Copyright (c) 2012 Web Notes Technologies Pvt Ltd. |
| 2 | # License: GNU General Public License (v3). For more information see license.txt |
| 3 | |
| 4 | from __future__ import unicode_literals |
| 5 | |
| 6 | import webnotes |
| 7 | from webnotes.utils import cstr |
| 8 | |
| 9 | @webnotes.whitelist() |
| 10 | def get_orders(): |
| 11 | # find customer id |
| 12 | customer = webnotes.conn.get_value("Contact", {"email_id": webnotes.session.user}, |
| 13 | "customer") |
| 14 | |
| 15 | if customer: |
| 16 | orders = webnotes.conn.sql("""select name, creation, currency from `tabSales Order` |
| 17 | where customer=%s""", customer, as_dict=1) |
| 18 | for order in orders: |
| 19 | order.items = webnotes.conn.sql("""select item_name, qty, export_rate, delivered_qty |
| 20 | from `tabSales Order Item` where parent=%s order by idx""", order.name, as_dict=1) |
| 21 | return orders |
| 22 | else: |
| 23 | return [] |