Merge branch 'master' of github.com:webnotes/erpnext
diff --git a/public/js/utils.js b/public/js/utils.js
index b84e293..6cd2c19 100644
--- a/public/js/utils.js
+++ b/public/js/utils.js
@@ -16,7 +16,7 @@
wn.provide('erpnext.utils');
-// profile related get_query
+// searches for enabled profiles
erpnext.utils.profile_query = function() {
return "select name, concat_ws(' ', first_name, middle_name, last_name) \
from `tabProfile` where ifnull(enabled, 0)=1 and docstatus < 2 and \
@@ -25,10 +25,18 @@
order by name asc limit 50";
};
-// employee related get query
+// searches for active employees
erpnext.utils.employee_query = function() {
return "select name, employee_name from `tabEmployee` \
where status = 'Active' and docstatus < 2 and \
- (employee_name like \"%%%s\" or %(key)s like \"%s\") \
+ (%(key)s like \"%s\" or employee_name like \"%%%s\") \
order by name asc limit 50";
-};
\ No newline at end of file
+};
+
+// searches for leads which are not converted
+erpnext.utils.lead_query = function() {
+ return "select name, lead_name, company_name from `tabLead` \
+ where docstatus < 2 and ifnull(status, '') != 'Converted' and \
+ (%(key)s like \"%s\" or lead_name like \"%%%s\" or company_name like \"%%%s\") \
+ order by lead_name asc limit 50";
+};
diff --git a/selling/doctype/customer/customer.js b/selling/doctype/customer/customer.js
index 82d001f..028ad6e 100644
--- a/selling/doctype/customer/customer.js
+++ b/selling/doctype/customer/customer.js
@@ -117,12 +117,7 @@
}
-// -----
-// lead
-// -----
-cur_frm.fields_dict['lead_name'].get_query = function(doc,dt,dn){
- return 'SELECT `tabLead`.`name` FROM `tabLead` WHERE `tabLead`.`status`!="Converted" AND `tabLead`.%(key)s LIKE "%s" ORDER BY `tabLead`.`name` ASC LIMIT 50';
-}
+cur_frm.fields_dict.lead_name.get_query = erpnext.utils.lead_query;
// Transaction History
diff --git a/selling/doctype/opportunity/opportunity.js b/selling/doctype/opportunity/opportunity.js
index 0d3d431..4070f5e 100644
--- a/selling/doctype/opportunity/opportunity.js
+++ b/selling/doctype/opportunity/opportunity.js
@@ -208,4 +208,6 @@
//get query select Territory
cur_frm.fields_dict['territory'].get_query = function(doc,cdt,cdn) {
- return 'SELECT `tabTerritory`.`name`,`tabTerritory`.`parent_territory` FROM `tabTerritory` WHERE `tabTerritory`.`is_group` = "No" AND `tabTerritory`.`docstatus`!= 2 AND `tabTerritory`.%(key)s LIKE "%s" ORDER BY `tabTerritory`.`name` ASC LIMIT 50';}
\ No newline at end of file
+ return 'SELECT `tabTerritory`.`name`,`tabTerritory`.`parent_territory` FROM `tabTerritory` WHERE `tabTerritory`.`is_group` = "No" AND `tabTerritory`.`docstatus`!= 2 AND `tabTerritory`.%(key)s LIKE "%s" ORDER BY `tabTerritory`.`name` ASC LIMIT 50';}
+
+cur_frm.fields_dict.lead.get_query = erpnext.utils.lead_query;
\ No newline at end of file
diff --git a/selling/doctype/quotation/quotation.js b/selling/doctype/quotation/quotation.js
index 157ad7e..e629975 100644
--- a/selling/doctype/quotation/quotation.js
+++ b/selling/doctype/quotation/quotation.js
@@ -148,10 +148,7 @@
return 'SELECT name,CONCAT(first_name," ",ifnull(last_name,"")) As FullName,department,designation FROM tabContact WHERE customer = "'+ doc.customer +'" AND docstatus != 2 AND name LIKE "%s" ORDER BY name ASC LIMIT 50';
}
-//lead
-cur_frm.fields_dict['lead'].get_query = function(doc,cdt,cdn){
- return 'SELECT `tabLead`.name, `tabLead`.lead_name FROM `tabLead` WHERE `tabLead`.%(key)s LIKE "%s" ORDER BY `tabLead`.`name` ASC LIMIT 50';
-}
+cur_frm.fields_dict.lead.get_query = erpnext.utils.lead_query;
cur_frm.cscript.lead = function(doc, cdt, cdn) {
if(doc.lead) {
diff --git a/support/doctype/communication/communication.js b/support/doctype/communication/communication.js
index 6f9147e..76161ab 100644
--- a/support/doctype/communication/communication.js
+++ b/support/doctype/communication/communication.js
@@ -6,6 +6,14 @@
concat_ws(' ', first_name, middle_name, last_name) like \"%%%s\") \
limit 50";
};
+
+ cur_frm.fields_dict.lead.get_query = function() {
+ return "select name, lead_name from `tabLead` \
+ where docstatus < 2 and \
+ (%(key)s like \"%s\" or lead_name like \"%%%s\" or \
+ company_name like \"%%%s\") \
+ order by lead_name asc limit 50";
+ };
}
cur_frm.cscript.refresh = function(doc, dt, dn) {