commit 632fb3879eca970660230281525967309100bcea
author Rushabh Mehta <rmehta@gmail.com> Tue May 19 11:00:10 2015 +0530
committer Rushabh Mehta <rmehta@gmail.com> Tue May 19 11:00:10 2015 +0530
tree 9cfb3640bfee9a8a427b6259c3292089353c412b
parent df2491f6cf91213c3ca3bd61ae973c277b7bec28

[fix] sms center, fixes #3274

erpnext/selling/doctype/sms_center/sms_center.py

diff --git a/erpnext/selling/doctype/sms_center/sms_center.py b/erpnext/selling/doctype/sms_center/sms_center.py
index 77a18b6..112693a 100644
--- a/erpnext/selling/doctype/sms_center/sms_center.py
+++ b/erpnext/selling/doctype/sms_center/sms_center.py
@@ -44,8 +44,10 @@
 				ifnull(cell_number,'')!='' %s""" % where_clause)
 
 		elif self.send_to == 'All Sales Person':
-			rec = frappe.db.sql("""select sales_person_name, mobile_no from
-				`tabSales Person` where docstatus!=2 and ifnull(mobile_no,'')!=''""")
+			rec = frappe.db.sql("""select sales_person_name, tabEmployee.cell_number from
+				`tabSales Person`, tabEmployee
+				and `tabSales Person`.employee = tabEmployee.name
+				where ifnull(tabEmployee.cell_number,'')!=''""")
 
 		rec_list = ''