<?php
$strTableName="Open Leads";
$_SESSION["OwnerID"] = $_SESSION["_".$strTableName."_OwnerID"];

$strOriginalTableName="lead_table";

$gstrOrderBy="ORDER BY `Approx Closure Date`, `Lead Status`";
if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
	$gstrOrderBy="order by ".$gstrOrderBy;

$g_orderindexes=array();
$g_orderindexes[] = array(7, (1 ? "ASC" : "DESC"), "`Approx Closure Date`");
$g_orderindexes[] = array(8, (1 ? "ASC" : "DESC"), "`Lead Status`");
$gsqlHead="SELECT Leadid,  Region,  `Customer Name`,  `Contact Person`,  `Lead Details`,  `Employee Name`,  `Approx Closure Date`,  `Lead Status`,  `Requirement Details`,  `Approx Value`,  `First Quote Remarks`,  `Proposed Closure Date`,  `Projected Closure QTR`,  `Proposed Solution Details`,  `Quoted Price`,  `Final Quote Remarks`,  `Discussion Highlights`,  `WIN / Lost Analysis`,  `Alligned Vendor`";
$gsqlFrom="FROM lead_table";
$gsqlWhereExpr="`Lead Status` ='Suspect' OR `Lead Status` ='prospect' OR `Lead Status` ='Review' OR `Lead Status` ='Hot' OR `Lead Status` ='Commit'";
$gsqlTail="";

include(getabspath("include/Open_Leads_settings.php"));

// alias for 'SQLQuery' object
$gQuery = &$queryData_Open_Leads;
$eventObj = &$tableEvents["Open Leads"];

$reportCaseSensitiveGroupFields = false;

$gstrSQL = gSQLWhere("");


?>