function DelExclusiveLead()
{
    $log =& LoggerManager::getLogger('ClickATell');
    $log->debug('Update exclusive counts start.');
    $tablePrefix = 'vtiger_';
    $assigned_user_id = trim($_REQUEST['assigned_user_id']);
    $record = trim($_REQUEST['record']);
    $userid = $assigned_user_id ? $assigned_user_id : $_SESSION['authenticated_user_id'];
    $leadid = $record ? $record : '';
    $result = array('success' => false, 'message' => '');
    if (!empty($userid)) {
        $adb = PearDatabase::getInstance();
        $leadCfSQL = "UPDATE vtiger_leadscf ";
        $leadCfSQL .= "LEFT JOIN " . $tablePrefix . "lead_exclusives ON vtiger_leadscf.leadid=" . $tablePrefix . "lead_exclusives.leadid ";
        $leadCfSQL .= "SET vtiger_leadscf.cf_833='未独占' ";
        $leadCfSQL .= "WHERE userid=" . $userid . " AND datediff(NOW(), " . $tablePrefix . "lead_exclusives.created) >=" . MAX_TTME;
        $resultLeadCf = $adb->query($leadCfSQL);
        if ($resultLeadCf) {
            $log->debug('Update vtiger_leadscf status success.' . $leadCfSQL);
            $sql = "DELETE FROM " . $tablePrefix . "lead_exclusives WHERE userid=" . $userid . " AND leadid=" . $leadid;
            $result = $adb->query($sql);
            if ($result) {
                $log->debug('Update exclusive counts success .' . json_encode($result));
            }
            $counts = GetExclusiveCounts($userid);
            $result = array('success' => true, 'message' => $counts);
        } else {
            $log->debug('Update vtiger_leadscf status failed.' . $leadCfSQL);
            $counts = GetExclusiveCounts($userid);
            $result = array('success' => false, 'message' => $counts);
        }
    }
    $log->debug('Update exclusive counts end. SQL:' . $sql);
    return $result;
}

function DelExclusiveLeadByTime()
{
    $log =& LoggerManager::getLogger('ClickATell');
    $log->debug('update exclusive status start.');
    $tablePrefix = 'vtiger_';
    $result = array('success' => false, 'message' => '', 'tip' => '');
    $adb = PearDatabase::getInstance();
    $leadExclusivesTable = $tablePrefix . 'lead_exclusives';
    $leadCfSQL = "UPDATE vtiger_leadscf ";
    $leadCfSQL .= "LEFT JOIN {$leadExclusivesTable} ON {$leadExclusivesTable}.leadid = vtiger_leadscf.leadid ";
    $leadCfSQL .= "SET vtiger_leadscf.cf_833='未独占' ";
    $leadCfSQL .= "WHERE datediff(NOW(), {$leadExclusivesTable}.created) >=" . MAX_TTME;
    $resultLeadCf = $adb->query($leadCfSQL);
    if ($resultLeadCf) {
        $result = array('success' => true, 'message' => $leadCfSQL);
        $log->debug('Update vtiger_leadscf status success. SQL:' . $leadCfSQL);
        $delSQL = "DELETE FROM {$leadExclusivesTable} WHERE datediff(NOW(), created) >=" . MAX_TTME;
        $resultDelSQL = $adb->query($delSQL);
        if ($resultDelSQL) {
            $result = array('success' => true, 'tip' => $delSQL);
            $log->debug('DEL exclusive counts success.');
        } else {
            $log->debug('DEL exclusive failed.SQL:' . $delSQL);
        }
    } else {
        $log->debug('Update vtiger_leadscf status failed.SQL:' . $leadCfSQL);
    }
    $log->debug('update exclusive status end.');
    return $result;
}

 /**
  * Creates a new file in the directory
  *
  * Data will either be supplied as a stream resource, or in certain cases
  * as a string. Keep in mind that you may have to support either.
  *
  * After successful creation of the file, you may choose to return the ETag
  * of the new file here.
  *
  * The returned ETag must be surrounded by double-quotes (The quotes should
  * be part of the actual string).
  *
  * If you cannot accurately determine the ETag, you should not return it.
  * If you don't store the file exactly as-is (you're transforming it
  * somehow) you should also not return an ETag.
  *
  * This means that if a subsequent GET to this new file does not exactly
  * return the same contents of what was submitted here, you are strongly
  * recommended to omit the ETag.
  *
  * @param string $name Name of the file
  * @param resource|string $data Initial payload
  * @return null|string
  */
 function createFile($name, $data = null)
 {
     include_once 'include/main/WebUI.php';
     global $log, $adb, $current_user;
     $adb = \PearDatabase::getInstance();
     $log = \LoggerManager::getLogger('DavToCRM');
     $user = new \Users();
     $current_user = $user->retrieveCurrentUserInfoFromFile($this->exData->crmUserId);
     $path = trim($this->path, 'files') . '/' . $name;
     $hash = sha1($path);
     $pathParts = pathinfo($path);
     $localPath = $this->localPath . $name;
     $stmt = $this->exData->pdo->prepare('SELECT crmid, smownerid, deleted FROM vtiger_files INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_files.filesid WHERE vtiger_files.hash = ?;');
     $stmt->execute([$hash]);
     $rows = $stmt->fetch(\PDO::FETCH_ASSOC);
     if ($rows != false && ($rows['smownerid'] != $this->exData->crmUserId || $rows['deleted'] == 1)) {
         throw new DAV\Exception\Conflict('File with name ' . $file . ' could not be located');
     }
     file_put_contents($this->exData->localStorageDir . $localPath, $data);
     if ($rows) {
         $rekord = \Vtiger_Record_Model::getInstanceById($rows['crmid'], 'Files');
         $rekord->set('mode', 'edit');
     } else {
         $rekord = \Vtiger_Record_Model::getCleanInstance('Files');
         $rekord->set('assigned_user_id', $this->exData->crmUserId);
     }
     $rekord->set('title', $pathParts['filename']);
     $rekord->set('name', $pathParts['filename']);
     $rekord->set('path', $localPath);
     $rekord->save();
     $id = $rekord->getId();
     $stmt = $this->exData->pdo->prepare('UPDATE vtiger_files SET dirid=?,extension=?,size=?,hash=?,ctime=? WHERE filesid=?;');
     $stmt->execute([$this->dirid, $pathParts['extension'], filesize($this->exData->localStorageDir . $localPath), $hash, date('Y-m-d H:i:s'), $id]);
 }

 static function getInstance()
 {
     if (self::$loggerCache) {
         return self::$loggerCache;
     }
     return LoggerManager::getLogger();
 }

 /**
  * コンストラクタ
  *
  */
 public function __construct()
 {
     $this->log = LoggerManager::getLogger(get_class($this));
     $request = array_merge($_POST, $_GET);
     if (get_magic_quotes_gpc()) {
         $request = $this->_stripSlashesDeep($request);
     }
     if (!ini_get("mbstring.encoding_translation") && INPUT_CODE != INTERNAL_CODE) {
         mb_convert_variables(INTERNAL_CODE, INPUT_CODE, $request);
     }
     // action:~ではじまるパラメータがあればactionMethodをセットする
     $methodName = "execute";
     $key = NULL;
     foreach ($request as $k => $val) {
         if (preg_match('/^action:(.+)$/', $k, $m)) {
             $methodName = $m[1];
             $this->log->debug("actionMethodが指定されました。 {$methodName}");
             $key = $k;
             break;
         }
     }
     $this->actionMethod = $methodName;
     if ($key != NULL) {
         unset($request[$key]);
     }
     $this->_params = $request;
     return;
 }

 public function __construct(MappedClassLoader $mappedClassLoader, SerializationPolicyProvider $serializationPolicyProvider)
 {
     $this->mappedClassLoader = $mappedClassLoader;
     $this->serializationPolicyProvider = $serializationPolicyProvider;
     $this->serializationPolicy = RPC::getDefaultSerializationPolicy();
     $this->logger = LoggerManager::getLogger('gwtphp.rpc.impl.ServerSerializationStreamReader');
 }

function dashboardDisplayCall($type, $Chart_Type, $from_page)
{
    global $app_strings;
    global $app_list_strings;
    global $mod_strings;
    global $currentModule;
    global $theme;
    $theme_path = "themes/" . $theme . "/";
    $image_path = $theme_path . "images/";
    require_once $theme_path . 'layout_utils.php';
    require_once 'include/logging.php';
    $graph_array = array("leadsource" => $mod_strings['leadsource'], "leadstatus" => $mod_strings['leadstatus'], "leadindustry" => $mod_strings['leadindustry'], "salesbyleadsource" => $mod_strings['salesbyleadsource'], "salesbyaccount" => $mod_strings['salesbyaccount'], "salesbyuser" => $mod_strings['salesbyuser'], "salesbyteam" => $mod_strings['salesbyteam'], "accountindustry" => $mod_strings['accountindustry'], "productcategory" => $mod_strings['productcategory'], "productbyqtyinstock" => $mod_strings['productbyqtyinstock'], "productbypo" => $mod_strings['productbypo'], "productbyquotes" => $mod_strings['productbyquotes'], "productbyinvoice" => $mod_strings['productbyinvoice'], "sobyaccounts" => $mod_strings['sobyaccounts'], "sobystatus" => $mod_strings['sobystatus'], "pobystatus" => $mod_strings['pobystatus'], "quotesbyaccounts" => $mod_strings['quotesbyaccounts'], "quotesbystage" => $mod_strings['quotesbystage'], "invoicebyacnts" => $mod_strings['invoicebyacnts'], "invoicebystatus" => $mod_strings['invoicebystatus'], "ticketsbystatus" => $mod_strings['ticketsbystatus'], "ticketsbypriority" => $mod_strings['ticketsbypriority'], "ticketsbycategory" => $mod_strings['ticketsbycategory'], "ticketsbyuser" => $mod_strings['ticketsbyuser'], "ticketsbyteam" => $mod_strings['ticketsbyteam'], "ticketsbyproduct" => $mod_strings['ticketsbyproduct'], "contactbycampaign" => $mod_strings['contactbycampaign'], "ticketsbyaccount" => $mod_strings['ticketsbyaccount'], "ticketsbycontact" => $mod_strings['ticketsbycontact']);
    $log = LoggerManager::getLogger('dashboard');
    if (isset($type) && $type != '') {
        $dashboard_type = $type;
    } else {
        $dashboard_type = 'DashboardHome';
    }
    if (!isset($type)) {
    } else {
        require_once 'modules/Dashboard/display_charts.php';
        $_REQUEST['type'] = $type;
        $_REQUEST['Chart_Type'] = $Chart_Type;
        $_REQUEST['from_page'] = 'HomePage';
        $dashval = dashBoardDisplayChart();
        return $dashval;
    }
}

function getTopAccounts($maxval, $calCnt)
{
    $log = LoggerManager::getLogger('top accounts_list');
    $log->debug("Entering getTopAccounts() method ...");
    require_once "data/Tracker.php";
    require_once 'modules/Potentials/Potentials.php';
    require_once 'include/logging.php';
    require_once 'include/ListView/ListView.php';
    global $app_strings;
    global $adb;
    global $current_language;
    global $current_user;
    $current_module_strings = return_module_language($current_language, "Accounts");
    require 'user_privileges/user_privileges_' . $current_user->id . '.php';
    require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
    $list_query = "select vtiger_account.accountid, vtiger_account.accountname, vtiger_account.tickersymbol, sum(vtiger_potential.amount) as amount from vtiger_potential inner join vtiger_crmentity on (vtiger_potential.potentialid=vtiger_crmentity.crmid) left join vtiger_account on (vtiger_potential.related_to=vtiger_account.accountid) left join vtiger_groups on (vtiger_groups.groupid = vtiger_crmentity.smownerid) where vtiger_crmentity.deleted=0 AND vtiger_crmentity.smownerid='" . $current_user->id . "' and vtiger_potential.sales_stage not in ('Closed Won', 'Closed Lost','" . $app_strings['LBL_CLOSE_WON'] . "','" . $app_strings['LBL_CLOSE_LOST'] . "')";
    if ($is_admin == false && $profileGlobalPermission[1] == 1 && $profileGlobalPermission[2] == 1 && $defaultOrgSharingPermission[6] == 3) {
        $sec_parameter = getListViewSecurityParameter('Accounts');
        $list_query .= $sec_parameter;
    }
    $list_query .= " group by vtiger_account.accountid, vtiger_account.accountname, vtiger_account.tickersymbol order by amount desc";
    $list_query .= " LIMIT 0," . $adb->sql_escape_string($maxval);
    if ($calCnt == 'calculateCnt') {
        $list_result_rows = $adb->query(mkCountQuery($list_query));
        return $adb->query_result($list_result_rows, 0, 'count');
    }
    $list_result = $adb->query($list_query);
    $open_accounts_list = array();
    $noofrows = $adb->num_rows($list_result);
    if ($noofrows) {
        for ($i = 0; $i < $noofrows; $i++) {
            $open_accounts_list[] = array('accountid' => $adb->query_result($list_result, $i, 'accountid'), 'accountname' => $adb->query_result($list_result, $i, 'accountname'), 'amount' => $adb->query_result($list_result, $i, 'amount'), 'tickersymbol' => $adb->query_result($list_result, $i, 'tickersymbol'));
        }
    }
    $title = array();
    $title[] = 'myTopAccounts.gif';
    $title[] = $current_module_strings['LBL_TOP_ACCOUNTS'];
    $title[] = 'home_myaccount';
    $header = array();
    $header[] = $current_module_strings['LBL_LIST_ACCOUNT_NAME'];
    $currencyid = fetchCurrency($current_user->id);
    $rate_symbol = getCurrencySymbolandCRate($currencyid);
    $rate = $rate_symbol['rate'];
    $curr_symbol = $rate_symbol['symbol'];
    $header[] = $current_module_strings['LBL_LIST_AMOUNT'] . '(' . $curr_symbol . ')';
    $entries = array();
    foreach ($open_accounts_list as $account) {
        $value = array();
        $account_fields = array('ACCOUNT_ID' => $account['accountid'], 'ACCOUNT_NAME' => $account['accountname'], 'AMOUNT' => $account['amount']);
        $Top_Accounts = strlen($account['accountname']) > 20 ? substr($account['accountname'], 0, 20) . '...' : $account['accountname'];
        $value[] = '<a href="index.php?action=DetailView&module=Accounts&record=' . $account['accountid'] . '">' . $Top_Accounts . '</a>';
        $value[] = convertFromDollar($account['amount'], $rate);
        $entries[$account['accountid']] = $value;
    }
    $values = array('ModuleName' => 'Accounts', 'Title' => $title, 'Header' => $header, 'Entries' => $entries);
    $log->debug("Exiting getTopAccounts method ...");
    if ($display_empty_home_blocks && count($entries) == 0 || count($entries) > 0) {
        return $values;
    }
}

 function Tracker()
 {
     $this->log = LoggerManager::getLogger('Tracker');
     // $this->db = PearDatabase::getInstance();
     $adb = PearDatabase::getInstance();
     $this->db = $adb;
 }

 /**
  * Constructor. 
  *
  * @param templateFile Complete path to the template file we are going to render
  */
 function Template($templateFile)
 {
     // initialize logging
     $this->log =& LoggerManager::getLogger("default");
     // create the Smarty object and set the security values
     $this->Smarty();
     $this->caching = false;
     //$this->cache_lifetime =  $cacheLifetime;
     $config =& Config::getConfig();
     $this->cache_dir = $config->getValue('temp_folder');
     $this->_templateFile = $templateFile;
     // enable the security settings
     $this->php_handling = false;
     // code is not allowed in the templates by default, unless specified otherwise
     /*if( $config->getValue( 'allow_php_code_in_templates', false ))
       	$this->security = true;
       else
       	$this->security = false;*/
     $this->security = (bool) (!$config->getValue('allow_php_code_in_templates', false));
     //$this->security = true;
     $this->secure_dir = array("./templates/admin", "./templates/");
     // default folders
     $this->compile_dir = $config->getValue('temp_folder');
     $this->template_dir = $config->getValue('template_folder');
     $this->compile_check = $config->getValue('template_compile_check', true);
     // this helps if php is running in 'safe_mode'
     $this->use_sub_dirs = false;
     // register dynamic block for every template instance
     $this->register_block('dynamic', 'smarty_block_dynamic', false);
 }

 function Webmails($mbox = '', $mailid = '')
 {
     $this->db = PearDatabase::getInstance();
     $this->db->println("Entering Webmail({$mbox},{$mailid})");
     $this->log =& LoggerManager::getLogger('WEBMAILS');
     $this->mbox = $mbox;
     $this->mailid = $mailid;
     $this->headers = $this->load_headers();
     $this->to = $this->headers["theader"]["to"];
     $this->to_name = $this->headers["theader"]["to_name"];
     $this->db->println("Webmail TO:");
     $this->db->println($this->to);
     $this->from = $this->headers["theader"]["from"];
     $this->fromname = $this->headers["theader"]["from_name"];
     $this->fromaddr = $this->headers["theader"]["fromaddr"];
     $this->reply_to = $this->headers["theader"]["reply_to"];
     $this->reply_to_name = $this->headers["theader"]["reply_to_name"];
     $this->cc_list = $this->headers["cc_list"];
     $this->cc_list_name = $this->headers["cc_list_name"];
     $this->subject = $this->headers["theader"]["subject"];
     $this->date = $this->headers["theader"]["date"];
     $this->has_attachments = $this->get_attachments();
     $this->db->println("Exiting Webmail({$mbox},{$mailid})");
     $this->relationship = $this->find_relationships();
     // Added by Puneeth for 5231
 }

 function Tracker()
 {
     $this->log = LoggerManager::getLogger('Tracker');
     //$this->db = & getSingleDBInstance();
     global $adb;
     $this->db = $adb;
 }

 /**
  * Constructor
  * @ignore 
  */
 function __construct()
 {
     $this->Logger = LoggerManager::getLogger('SignalHandler');
     if (!function_exists("pcntl_signal")) {
         self::RaiseError("Function pcntl_signal() not found. PCNTL must be enabled in PHP.", E_ERROR);
     }
 }

function getTopPotentials($maxval, $calCnt)
{
    $log = LoggerManager::getLogger('top opportunity_list');
    $log->debug("Entering getTopPotentials() method ...");
    require_once "data/Tracker.php";
    require_once 'modules/Potentials/Potentials.php';
    require_once 'include/logging.php';
    require_once 'include/ListView/ListView.php';
    global $app_strings;
    global $adb;
    global $current_language;
    global $current_user;
    $current_module_strings = return_module_language($current_language, "Potentials");
    $title = array();
    $title[] = 'myTopOpenPotentials.gif';
    $title[] = $current_module_strings['LBL_TOP_OPPORTUNITIES'];
    $title[] = 'home_mypot';
    $where = "AND vtiger_potential.potentialid > 0 AND vtiger_potential.sales_stage not in ('Closed Won','Closed Lost','" . $current_module_strings['Closed Won'] . "','" . $current_module_strings['Closed Lost'] . "') AND vtiger_crmentity.smownerid='" . $current_user->id . "' AND vtiger_potential.amount > 0";
    $header = array();
    $header[] = $current_module_strings['LBL_LIST_OPPORTUNITY_NAME'];
    //$header[]=$current_module_strings['LBL_LIST_ACCOUNT_NAME'];
    $currencyid = fetchCurrency($current_user->id);
    $rate_symbol = getCurrencySymbolandCRate($currencyid);
    $rate = $rate_symbol['rate'];
    $curr_symbol = $rate_symbol['symbol'];
    $header[] = $current_module_strings['LBL_LIST_AMOUNT'] . '(' . $curr_symbol . ')';
    $list_query = "SELECT vtiger_crmentity.crmid, vtiger_potential.potentialname,\n\t\t\tvtiger_potential.amount, potentialid\n\t\t\tFROM vtiger_potential\n\t\t\tIGNORE INDEX(PRIMARY) INNER JOIN vtiger_crmentity\n\t\t\t\tON vtiger_crmentity.crmid = vtiger_potential.potentialid";
    $list_query .= getNonAdminAccessControlQuery('Potentials', $current_user);
    $list_query .= "WHERE vtiger_crmentity.deleted = 0 " . $where;
    $list_query .= " ORDER BY amount DESC";
    $list_query .= " LIMIT " . $adb->sql_escape_string($maxval);
    if ($calCnt == 'calculateCnt') {
        $list_result_rows = $adb->query(mkCountQuery($list_query));
        return $adb->query_result($list_result_rows, 0, 'count');
    }
    $list_result = $adb->query($list_query);
    $open_potentials_list = array();
    $noofrows = $adb->num_rows($list_result);
    $entries = array();
    if ($noofrows) {
        for ($i = 0; $i < $noofrows; $i++) {
            $open_potentials_list[] = array('name' => $adb->query_result($list_result, $i, 'potentialname'), 'id' => $adb->query_result($list_result, $i, 'potentialid'), 'amount' => $adb->query_result($list_result, $i, 'amount'));
            $potentialid = $adb->query_result($list_result, $i, 'potentialid');
            $potentialname = $adb->query_result($list_result, $i, 'potentialname');
            $Top_Potential = strlen($potentialname) > 20 ? substr($potentialname, 0, 20) . '...' : $potentialname;
            $value = array();
            $value[] = '<a href="index.php?action=DetailView&module=Potentials&record=' . $potentialid . '">' . $Top_Potential . '</a>';
            $value[] = CurrencyField::convertToUserFormat($adb->query_result($list_result, $i, 'amount'));
            $entries[$potentialid] = $value;
        }
    }
    $advft_criteria_groups = array('1' => array('groupcondition' => null));
    $advft_criteria = array(array('groupid' => 1, 'columnname' => 'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V', 'comparator' => 'k', 'value' => 'closed', 'columncondition' => 'and'), array('groupid' => 1, 'columnname' => 'vtiger_potential:amount:amount:Potentials_Amount:N', 'comparator' => 'g', 'value' => '0', 'columncondition' => 'and'), array('groupid' => 1, 'columnname' => 'vtiger_crmentity:smownerid:assigned_user_id:Leads_Assigned_To:V', 'comparator' => 'e', 'value' => getFullNameFromArray('Users', $current_user->column_fields), 'columncondition' => null));
    $search_qry = '&advft_criteria=' . Zend_Json::encode($advft_criteria) . '&advft_criteria_groups=' . Zend_Json::encode($advft_criteria_groups) . '&searchtype=advance&query=true';
    $values = array('ModuleName' => 'Potentials', 'Title' => $title, 'Header' => $header, 'Entries' => $entries, 'search_qry' => $search_qry);
    if (count($open_potentials_list) == 0 || count($open_potentials_list) > 0) {
        $log->debug("Exiting getTopPotentials method ...");
        return $values;
    }
}

 /** constructor function for the main user class
             instantiates the Logger class and PearDatabase Class	
   	  *
  	*/
 function Users()
 {
     $this->log = LoggerManager::getLogger('user');
     $this->log->debug("Entering Users() method ...");
     $this->db =& getSingleDBInstance();
     $this->log->debug("Exiting Users() method ...");
 }

 /**
  * Construction of a DBO object
  * @param String table name of the Dbo
  * @param array the initial row value of the Dbo
  */
 public function __construct()
 {
     $this->logger =& LoggerManager::getLogger(get_class($this));
     $this->dbHandler = CalemFactory::getDbHandler();
     $this->conn = $this->dbHandler->getCalemConnection();
     $this->resourceMgr = CalemFactory::getResourceManager();
 }

 public function __construct()
 {
     $this->logger =& LoggerManager::getLogger("CalemSchedulerJobBo");
     $this->dbo = CalemFactory::getDbo('scheduler_job');
     $this->dboRun = CalemFactory::getDbo('scheduler_job_log');
     $this->taskDbo = CalemFactory::getDbo('scheduler_task');
 }

/** to get the details of a KeyMetrics on Home page 
 * @returns  $customviewlist Array in the following format
 * $values = Array('Title'=>Array(0=>'image name',
 *				 1=>'Key Metrics',
 *			 	 2=>'home_metrics'
 *			 	),
 *		  'Header'=>Array(0=>'Metrics',
 *	  			  1=>'Count'
 *			  	),
 *		  'Entries'=>Array($cvid=>Array(
 *			  			0=>$customview name,
 *						1=>$no of records for the view
 *					       ),
 *				   $cvid=>Array(
 *                                               0=>$customview name,
 *                                               1=>$no of records for the view
 *                                              ),
 *					|
 *					|
 *				   $cvid=>Array(
 *                                               0=>$customview name,
 *                                               1=>$no of records for the view
 *                                              )	
 *				  )
 *
 */
function getKeyMetrics()
{
    require_once "data/Tracker.php";
    require_once 'modules/CustomView/CustomView.php';
    require_once 'include/logging.php';
    require_once 'include/ListView/ListView.php';
    global $app_strings;
    global $adb;
    global $log;
    global $current_language;
    $metricviewnames = "'Hot Leads'";
    $current_module_strings = return_module_language($current_language, "CustomView");
    $log = LoggerManager::getLogger('metrics');
    $metriclists = getMetricList();
    $log->info("Metrics :: Successfully got MetricList to be displayed");
    if (isset($metriclists)) {
        foreach ($metriclists as $key => $metriclist) {
            $listquery = getListQuery($metriclist['module']);
            if (empty($listquery)) {
                if (is_file("modules/" . $metriclist['module'] . "/" . $metriclist['module'] . ".php")) {
                    include_once "modules/" . $metriclist['module'] . "/" . $metriclist['module'] . ".php";
                    $metric_focus = new $metriclist['module']();
                    $listquery = $metric_focus->getListQuery('');
                }
            }
            $oCustomView = new CustomView($metriclist['module']);
            $metricsql = $oCustomView->getMetricsCvListQuery($metriclist['id'], $listquery, $metriclist['module']);
            $metricresult = $adb->query($metricsql);
            if ($metricresult) {
                $rowcount = $adb->fetch_array($metricresult);
                if (isset($rowcount)) {
                    $metriclists[$key]['count'] = $rowcount['count'];
                }
            }
        }
        $log->info("Metrics :: Successfully build the Metrics");
    }
    $title = array();
    $title[] = 'keyMetrics.gif';
    $title[] = $app_strings['LBL_HOME_KEY_METRICS'];
    $title[] = 'home_metrics';
    $header = array();
    $header[] = $app_strings['LBL_HOME_METRICS'];
    $header[] = $app_strings['LBL_HOME_COUNT'];
    $entries = array();
    if (isset($metriclists)) {
        $oddRow = true;
        foreach ($metriclists as $metriclist) {
            $value = array();
            $metric_fields = array('ID' => $metriclist['id'], 'NAME' => $metriclist['name'], 'COUNT' => $metriclist['count'], 'MODULE' => $metriclist['module']);
            $value[] = '<a href="index.php?action=index&module=' . $metriclist['module'] . '&viewname=' . $metriclist['id'] . '">' . $metriclist['name'] . '</a>';
            $value[] = '<a href="index.php?action=index&module=' . $metriclist['module'] . '&viewname=' . $metriclist['id'] . '">' . $metriclist['count'] . '</a>';
            $entries[$metriclist['id']] = $value;
        }
    }
    $values = array('Title' => $title, 'Header' => $header, 'Entries' => $entries);
    //if ( ($display_empty_home_blocks ) || (count($value)!= 0) )
    return $values;
}

 function listViewProcess()
 {
     $GLOBALS['log'] = LoggerManager::getLogger('SugarCRM');
     global $sugar_config;
     global $current_user;
     global $app_strings;
     global $timedate;
     $type = clean_string($_REQUEST['module']);
     $db = DBManagerFactory::getInstance();
     /* $query = $_REQUEST['query'];
        if($query){
            $ret_array = generateSearchWhere($type, $_REQUEST['current_post']);
            $w = $ret_array['where'];
            $where = "IN ( SELECT id from grouplists WHERE ".$w .")";  
        }
        else{
            $where = '';
        } */
     /*$ids = $_REQUEST['uid']; 
                 if($ids) {
                     $ids = explode(',', $ids);
                     $ids = "'" . implode("','", $ids) . "'";
                     $where = "in ($ids)";
                 } 
                 else if (isset($_REQUEST['all']) ){
                         $where = '';//get all
     
                     } else {
                         if(!empty($_REQUEST['current_post'])) {
                             $ret_array = generateSearchWhere($type, $_REQUEST['current_post']);
     
                             $w = $ret_array['where'];
                             $where = "IN ( SELECT id from grouplists WHERE ".$w .")";
     
                         } else {
                             $where = '';
                         }
                 }*/
     $focus = new GroupLists();
     // $query = $focus->create_new_list_query($order_by, $where,$filter=array(),$params=array(), $show_deleted = 0,$join_type='', $return_array = false, $parentbean=null, $singleSelect = false);
     $query = $focus->{$start_date} = $_REQUEST['start_date'];
     $end_date = $_REQUEST['end_date'];
     $template = file_get_contents('modules/GroupLists/tpls/report.tpl');
     $template = str_replace('{START}', $start_date, $template);
     $template = str_replace('{END}', $end_date, $template);
     $template = str_replace('{LIST_GIT}', $focus->get_GIT_to_report($where), $template);
     $template = str_replace('{LIST_FIT}', $focus->get_FIT_to_report($where), $template);
     $size = strlen($template);
     $filename = "DS KHACH DI TOUR TU " . $start_date . " DEN " . $end_date . ".doc";
     ob_end_clean();
     header("Cache-Control: private");
     header("Content-Type: application/force-download;");
     header("Content-Disposition:attachment; filename=\"{$filename}\"");
     header("Content-length:{$size}");
     echo $template;
     ob_flush();
     //    header("Location: index.php?module=GroupLists&action=index");
     sugar_cleanup(true);
 }

 /**	Constructor which will set the column_fields in this object
  */
 function Vendors()
 {
     $this->log = LoggerManager::getLogger('vendor');
     $this->log->debug("Entering Vendors() method ...");
     $this->db = PearDatabase::getInstance();
     $this->column_fields = getColumnFields('Vendors');
     $this->log->debug("Exiting Vendor method ...");
 }