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

$strOriginalTableName="lead_table";

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

$g_orderindexes=array();
$g_orderindexes[] = array(6, (1 ? "ASC" : "DESC"), "`Lead Status`");
$gsqlHead="SELECT Leadid,  `Customer Name`,  `Contact Person`,  `Lead Details`,  `Approx Closure Date`,  `Lead Status`,  `WIN / Lost Analysis`,  `Employee Name`";
$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="GROUP BY Leadid, `Customer Name`, `Contact Person`, `Lead Details`, `Approx Closure Date`, `Lead Status`, `WIN / Lost Analysis`, `Employee Name`";

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

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

$reportCaseSensitiveGroupFields = false;

$gstrSQL = gSQLWhere("");


?>