YuCheng Hu
9cce682da9
yuchenghu@hawebs.net git-svn-id: https://svn.code.sf.net/p/hawebs/svn@618 a2543c7e-f6e9-4f8a-8bff-1ffc34733512
173 lines
6.7 KiB
PHP
173 lines
6.7 KiB
PHP
<?php
|
|
/*********************************************************************************
|
|
* The contents of this file are subject to the SugarCRM Public License Version 1.1.2
|
|
* ("License"); You may not use this file except in compliance with the
|
|
* License. You may obtain a copy of the License at http://www.sugarcrm.com/SPL
|
|
* Software distributed under the License is distributed on an "AS IS" basis,
|
|
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
|
|
* the specific language governing rights and limitations under the License.
|
|
* The Original Code is: SugarCRM Open Source
|
|
* The Initial Developer of the Original Code is SugarCRM, Inc.
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.;
|
|
* All Rights Reserved.
|
|
* Contributor(s): ______________________________________.
|
|
********************************************************************************/
|
|
/*********************************************************************************
|
|
* modules/Leads/ListViewTop.php,v 1.22 2005/04/19 17:00:30 ray Exp $
|
|
* Description: TODO: To be written.
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
|
|
* All Rights Reserved.
|
|
* Contributor(s): ______________________________________..
|
|
********************************************************************************/
|
|
|
|
/** Function to get the 5 New Leads
|
|
*return array $values - array with the title, header and entries like Array('Title'=>$title,'Header'=>$listview_header,'Entries'=>$listview_entries) where as listview_header and listview_entries are arrays of header and entity values which are returned from function getListViewHeader and getListViewEntries
|
|
*/
|
|
function getNewLeads($maxval,$calCnt)
|
|
{
|
|
global $log;
|
|
$log->debug("Entering getNewLeads() method ...");
|
|
require_once("data/Tracker.php");
|
|
require_once("include/utils/utils.php");
|
|
|
|
global $currentModule;
|
|
|
|
global $theme;
|
|
global $focus;
|
|
global $action;
|
|
global $adb;
|
|
global $app_strings;
|
|
global $current_language;
|
|
global $current_user;
|
|
$current_module_strings = return_module_language($current_language, 'Leads');
|
|
|
|
$theme_path="themes/".$theme."/";
|
|
$image_path=$theme_path."images/";
|
|
if($_REQUEST['lead_view']=='')
|
|
{
|
|
$query = "select lead_view from vtiger_users where id =?";
|
|
$result=$adb->pquery($query, array($current_user->id));
|
|
$lead_view=$adb->query_result($result,0,'lead_view');
|
|
}
|
|
else
|
|
$lead_view=$_REQUEST['lead_view'];
|
|
|
|
$today = date("Y-m-d", time());
|
|
|
|
if($lead_view == 'Today')
|
|
{
|
|
$start_date = date("Y-m-d",strtotime("$today"));
|
|
}
|
|
else if($lead_view == 'Last 2 Days')
|
|
{
|
|
$start_date = date("Y-m-d", strtotime("-2 days"));
|
|
}
|
|
else if($lead_view == 'Last Week')
|
|
{
|
|
$start_date = date("Y-m-d", strtotime("-1 week"));
|
|
}
|
|
|
|
$list_query = 'select vtiger_leaddetails.firstname, vtiger_leaddetails.lastname, vtiger_leaddetails.leadid, vtiger_leaddetails.company
|
|
from vtiger_leaddetails inner join vtiger_crmentity on vtiger_leaddetails.leadid = vtiger_crmentity.crmid
|
|
where vtiger_crmentity.deleted =0 AND vtiger_leaddetails.converted =0 AND vtiger_leaddetails.leadid > 0 AND
|
|
vtiger_leaddetails.leadstatus not in ("Lost Lead", "Junk Lead","'.$current_module_strings['Lost Lead'].'","'.$current_module_strings['Junk Lead'].'")
|
|
AND vtiger_crmentity.createdtime >=? AND vtiger_crmentity.smownerid = ?';
|
|
|
|
$list_query .= " LIMIT 0," . $adb->sql_escape_string($maxval);
|
|
|
|
if($calCnt == 'calculateCnt') {
|
|
$list_result_rows = $adb->pquery(mkCountQuery($list_query), array($start_date, $current_user->id));
|
|
return $adb->query_result($list_result_rows, 0, 'count');
|
|
}
|
|
|
|
$list_result = $adb->pquery($list_query, array($start_date, $current_user->id));
|
|
$noofrows = $adb->num_rows($list_result);
|
|
|
|
$open_lead_list =array();
|
|
if ($noofrows > 0) {
|
|
for($i=0;$i<$noofrows && $i<$maxval;$i++)
|
|
{
|
|
$open_lead_list[] = Array('leadname' => $adb->query_result($list_result,$i,'firstname').' '.$adb->query_result($list_result,$i,'lastname'),
|
|
'company' => $adb->query_result($list_result,$i,'company'),
|
|
'id' => $adb->query_result($list_result,$i,'leadid'),
|
|
);
|
|
}
|
|
}
|
|
|
|
$title=array();
|
|
$title[]='Leads.gif';
|
|
$title[]=$current_module_strings["LBL_NEW_LEADS"];
|
|
$title[]='home_mynewlead';
|
|
$title[]=getLeadView($lead_view);
|
|
$title[]='showLeadView';
|
|
$title[]='MyNewLeadFrm';
|
|
$title[]='lead_view';
|
|
|
|
$header=array();
|
|
$header[] =$current_module_strings['LBL_LIST_LEAD_NAME'];
|
|
$header[] =$current_module_strings['Company'];
|
|
|
|
$entries=array();
|
|
foreach($open_lead_list as $lead)
|
|
{
|
|
$value=array();
|
|
$lead_fields = array(
|
|
'LEAD_NAME' => $lead['leadname'],
|
|
'COMPANY' => $lead['company'],
|
|
'LEAD_ID' => $lead['id'],
|
|
);
|
|
|
|
$Top_Leads = (strlen($lead['leadname']) > 20) ? (substr($lead['leadname'],0,20).'...') : $lead['leadname'];
|
|
$value[]= '<a href="index.php?action=DetailView&module=Leads&record='.$lead_fields['LEAD_ID'].'">'.$Top_Leads.'</a>';
|
|
$value[]=$lead_fields['COMPANY'];
|
|
|
|
$entries[$lead_fields['LEAD_ID']]=$value;
|
|
}
|
|
|
|
$search_qry = "&query=true&Fields0=leadstatus&Condition0=n&Srch_value0=Lost+Lead&Fields1=leadstatus&Condition1=n&Srch_value1=Junk+Lead&Fields2=assigned_user_id&Condition2=e&Srch_value2=".$current_user->column_fields['user_name']."&Fields3=createdtime&Condition3=h&Srch_value3=".$start_date."&searchtype=advance&search_cnt=4&matchtype=all";
|
|
|
|
$values=Array('ModuleName'=>'Leads','Title'=>$title,'Header'=>$header,'Entries'=>$entries,'search_qry'=>$search_qry);
|
|
$log->debug("Exiting getNewLeads method ...");
|
|
if (($display_empty_home_blocks && count($entries) == 0 ) || (count($entries)>0))
|
|
return $values;
|
|
}
|
|
/** Function to get the Lead View from the Combo List
|
|
* @param string $lead_view - (eg today, last 2 days)
|
|
* Returns the Lead view select option
|
|
*/
|
|
function getLeadView($lead_view)
|
|
{
|
|
global $log;
|
|
$log->debug("Entering getLeadView(".$lead_view.") method ...");
|
|
$today = date("Y-m-d", time());
|
|
|
|
if($lead_view == 'Today')
|
|
{
|
|
$selected1 = 'selected';
|
|
}
|
|
else if($lead_view == 'Last 2 Days')
|
|
{
|
|
$selected2 = 'selected';
|
|
}
|
|
else if($lead_view == 'Last Week')
|
|
{
|
|
$selected3 = 'selected';
|
|
}
|
|
|
|
$LEAD_VIEW_SELECT_OPTION = '<select class=small name="lead_view" onchange="showLeadView(this)">';
|
|
$LEAD_VIEW_SELECT_OPTION .= '<option value="Today" '.$selected1.'>';
|
|
$LEAD_VIEW_SELECT_OPTION .= 'Today';
|
|
$LEAD_VIEW_SELECT_OPTION .= '</option>';
|
|
$LEAD_VIEW_SELECT_OPTION .= '<option value="Last 2 Days" '.$selected2.'>';
|
|
$LEAD_VIEW_SELECT_OPTION .= 'Last 2 Days';
|
|
$LEAD_VIEW_SELECT_OPTION .= '</option>';
|
|
$LEAD_VIEW_SELECT_OPTION .= '<option value="Last Week" '.$selected3.'>';
|
|
$LEAD_VIEW_SELECT_OPTION .= 'Last Week';
|
|
$LEAD_VIEW_SELECT_OPTION .= '</option>';
|
|
$LEAD_VIEW_SELECT_OPTION .= '</select>';
|
|
|
|
$log->debug("Exiting getLeadView method ...");
|
|
return $LEAD_VIEW_SELECT_OPTION;
|
|
}
|
|
?>
|