[Vtigercrm-developers] [PATCH 4.2.3] Search leads by Fax in advanced search

Mike Fedyk mfedyk at mikefedyk.com
Sat Feb 18 23:27:22 PST 2006


Committed.

Mike Fedyk wrote:

>Let's see if thunderbird garbles patches.
>
>Should this count as a "feature"?  I think it's a fix ready for 4.2.4.  
>Comments wanted.
>
>diff -dr -u vtiger-4.2.3-production/modules/Leads/ListView.php 
>vtiger-4.2.3-testing/modules/Leads/ListView.php
>--- vtiger-4.2.3-production/modules/Leads/ListView.php    2006-01-25 
>14:43:33.000000000 -0800
>+++ vtiger-4.2.3-testing/modules/Leads/ListView.php    2006-02-04 
>20:58:47.000000000 -0800
>@@ -69,6 +69,7 @@
>     if (isset($_REQUEST['leadsource'])) $leadsource = 
>$_REQUEST['leadsource'];
>     if (isset($_REQUEST['industry'])) $industry = $_REQUEST['industry'];
>     if (isset($_REQUEST['phone'])) $phone = $_REQUEST['phone'];
>+    if (isset($_REQUEST['fax'])) $fax = $_REQUEST['fax'];
>     if (isset($_REQUEST['email'])) $email = $_REQUEST['email'];
>     if (isset($_REQUEST['mobile'])) $mobile = $_REQUEST['mobile'];
>     if (isset($_REQUEST['lead_status'])) $leadstatus = 
>$_REQUEST['lead_status'];
>@@ -131,6 +132,10 @@
>         array_push($where_clauses, "leadaddress.phone like '%$phone%'");
>         $url_string .= "&phone=".$phone;
>     }
>+    if(isset($fax) && $fax != ""){
>+        array_push($where_clauses, "leadaddress.fax like '%$fax%'");
>+        $url_string .= "&fax=".$fax;
>+    }
>     if(isset($email) && $email != ""){
>         array_push($where_clauses, "leaddetails.email like '$email%'");
>         $url_string .= "&email=".$email;
>@@ -245,6 +250,7 @@
>         //if(isset($modified_user_id)) 
>$search_form->assign("MODIFIED_USER_ID", $modified_user_id);
>         //if(isset($do_not_call)) $search_form->assign("DO_NOT_CALL", 
>$do_not_call);
>         if(isset($phone)) $search_form->assign("PHONE", $phone);
>+        if(isset($fax)) $search_form->assign("FAX", $fax);
>         if(isset($email)) $search_form->assign("EMAIL", $email);
>         if(isset($mobile)) $search_form->assign("MOBILE", $mobile);
>         if(isset($address_street)) 
>$search_form->assign("ADDRESS_STREET", $address_street);
>diff -dr -u vtiger-4.2.3-production/modules/Leads/SearchForm.html 
>vtiger-4.2.3-testing/modules/Leads/SearchForm.html
>--- vtiger-4.2.3-production/modules/Leads/SearchForm.html    2006-01-13 
>20:46:29.000000000 -0800
>+++ vtiger-4.2.3-testing/modules/Leads/SearchForm.html    2006-02-04 
>20:56:49.000000000 -0800
>@@ -99,33 +99,33 @@
>     </tr><tr>
>     <td width="20%" class="dataLabel">{MOD.LBL_LAST_NAME}</td>
>     <td width="30%"><input name='lastname' type="text" tabindex='1' 
>size='25' maxlength='25' value="{LAST_NAME}"></td>
>-    <td width="20%" class="dataLabel">{MOD.LBL_EMAIL}</td>
>-    <td width="30%"><input name='email' type="text" tabindex='2' 
>size='35' maxlength='100' value='{EMAIL}'></td>
>+    <td width="20%" class="dataLabel">{MOD.LBL_FAX}</td>
>+    <td width="30%"><input name='fax' type="text" tabindex='2' 
>size='20' maxlength='25' value='{FAX}'></td>
>     </tr><tr>
>     <td width="20%" class="dataLabel">{MOD.LBL_COMPANY}</td>
>     <td width="30%"><input name='company' type="text" tabindex='1' 
>size='25' maxlength='100' value='{COMPANY}'></td>
>-    <td width="20%" class="dataLabel">{MOD.LBL_MOBILE}</td>
>-    <td width="30%"><input name='mobile' type="text" tabindex='2' 
>size='25' maxlength='100' value='{MOBILE}'></td>
>+    <td width="20%" class="dataLabel">{MOD.LBL_EMAIL}</td>
>+    <td width="30%"><input name='email' type="text" tabindex='2' 
>size='35' maxlength='100' value='{EMAIL}'></td>
>     </tr><tr>
>     <td width="20%" class="dataLabel">{MOD.LBL_LEAD_SOURCE}</td>
>     <td width="30%"><select name='leadsource' 
>tabindex='1'>{LEAD_SOURCE_OPTIONS}</select></td>
>-    <td width="20%" class="dataLabel">{MOD.LBL_RATING}</td>
>-    <td width="30%"><select name='rating' 
>tabindex='1'>{RATING_OPTIONS}</select></td>
>+    <td width="20%" class="dataLabel">{MOD.LBL_MOBILE}</td>
>+    <td width="30%"><input name='mobile' type="text" tabindex='2' 
>size='25' maxlength='100' value='{MOBILE}'></td>
>     </tr><tr>
>     <td width="20%" class="dataLabel">{MOD.LBL_INDUSTRY}</td>
>     <td width="30%"><select name='industry' 
>tabindex='1'>{INDUSTRY_OPTIONS}</select></td>
>-    <td width="20%" class="dataLabel">{MOD.LBL_LEAD_STATUS}</td>
>-    <td width="30%"><select name='lead_status' 
>tabindex='1'>{LEAD_STATUS_OPTIONS}</select></td>
>+    <td width="20%" class="dataLabel">{MOD.LBL_RATING}</td>
>+    <td width="30%"><select name='rating' 
>tabindex='1'>{RATING_OPTIONS}</select></td>
>     </tr><tr>
>     <td width="20%" class="dataLabel">{MOD.LBL_ADDRESS_STREET}</td>
>     <td width="30%"><input type="text" name='address_street' 
>tabindex='3' value='{ADDRESS_STREET}'></td>
>-    <td width="20%" class="dataLabel">{MOD.LBL_ADDRESS_CITY}</td>
>-    <td width="30%"><input type="text"  name='address_city' 
>tabindex='4' size='15' maxlength='100' value='{ADDRESS_CITY}'></td>
>+    <td width="20%" class="dataLabel">{MOD.LBL_LEAD_STATUS}</td>
>+    <td width="30%"><select name='lead_status' 
>tabindex='1'>{LEAD_STATUS_OPTIONS}</select></td>
>     </tr><tr>
>     <td width="20%" class="dataLabel">{MOD.LBL_ADDRESS_STATE}</td>
>     <td width="30%"><input  type="text" name='address_state' 
>tabindex='4' size='15' maxlength='100' value='{ADDRESS_STATE}'></td>
>-    <td width="20%" class="dataLabel">{MOD.LBL_ADDRESS_POSTAL_CODE}</td>
>-    <td width="30%"><input  type="text" name='address_postalcode' 
>tabindex='4' size='10' maxlength='20' value='{ADDRESS_POSTALCODE}'></td>
>+    <td width="20%" class="dataLabel">{MOD.LBL_ADDRESS_CITY}</td>
>+    <td width="30%"><input type="text"  name='address_city' 
>tabindex='4' size='15' maxlength='100' value='{ADDRESS_CITY}'></td>
>     </tr><!--tr>
>     <td width="20%" class="dataLabel">{APP.LBL_CURRENT_USER_FILTER}</td>
>     <td width="30%"><input name='current_user_only' type="checkbox" 
>{CURRENT_USER_ONLY}></td>
>@@ -134,8 +134,8 @@
>     </tr--><tr>
>     <td width="20%" class="dataLabel">{APP.LBL_ASSIGNED_TO}</td>
>     <td width="30%"><select tabindex='1' 
>name="assigned_user_id">{ASSIGNED_USER_OPTIONS}</select></td>
>-    <td width="20%" class="dataLabel">&nbsp;</td>
>-    <td width="30%">&nbsp;</td>
>+    <td width="20%" class="dataLabel">{MOD.LBL_ADDRESS_POSTAL_CODE}</td>
>+    <td width="30%"><input  type="text" name='address_postalcode' 
>tabindex='4' size='10' maxlength='20' value='{ADDRESS_POSTALCODE}'></td>
> </tr></table>
> 
> <table><tr><td width="20%">{CUSTOMFIELD}</td></tr></table>
>
>_______________________________________________
>vtigercrm-developers mailing list
>vtigercrm-developers at lists.vtigercrm.com
>http://lists.vtigercrm.com/mailman/listinfo/vtigercrm-developers
>
>  
>



More information about the vtigercrm-developers mailing list