| Anand Doshi | e65e621 | 2012-11-19 15:43:18 +0530 | [diff] [blame] | 1 | // ERPNext - web based ERP (http://erpnext.com) |
| 2 | // Copyright (C) 2012 Web Notes Technologies Pvt Ltd |
| 3 | // |
| 4 | // This program is free software: you can redistribute it and/or modify |
| 5 | // it under the terms of the GNU General Public License as published by |
| 6 | // the Free Software Foundation, either version 3 of the License, or |
| 7 | // (at your option) any later version. |
| 8 | // |
| 9 | // This program is distributed in the hope that it will be useful, |
| 10 | // but WITHOUT ANY WARRANTY; without even the implied warranty of |
| 11 | // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| 12 | // GNU General Public License for more details. |
| 13 | // |
| 14 | // You should have received a copy of the GNU General Public License |
| 15 | // along with this program. If not, see <http://www.gnu.org/licenses/>. |
| 16 | |
| 17 | wn.provide('erpnext.utils'); |
| 18 | |
| 19 | // profile related get_query |
| 20 | erpnext.utils.profile_query = function() { |
| 21 | return "select name, concat_ws(' ', first_name, middle_name, last_name) \ |
| 22 | from `tabProfile` where ifnull(enabled, 0)=1 and docstatus < 2 and \ |
| 23 | name not in ('Administrator', 'Guest') and (%(key)s like \"%s\" or \ |
| 24 | concat_ws(' ', first_name, middle_name, last_name) like \"%%%s\") \ |
| 25 | limit 50"; |
| 26 | }; |