public function getAverageTimePeriodImmat( $profileId,$granularity, $startDate, $endDate) {

        $dbAccess = $this->connectMysqlDatabase(); 

        if (!$dbAccess['dbConnection']) {
            $logDebug = " Echec getQueueCallTopFiveReasonStats()  " . $dbAccess['errorMessage'] . "  " . $dbAccess['errorCode'] . " MSISDN :: $this->msisdn";
            $this->svaLog->writeSystemLog($logDebug);
            die("IMPOSSIBLE DE SE CONNECTER A LA BASE DE DONNEES");
        } else {

            $profileSql = "";
            $userSql = "";
            $limitSql = "";
            $statusSql = "";
            $campaignSql = "";
			$date1Sql = "";
			$date2Sql = "";
            $serviceSql = "";
		                                                      			
            $sqlQuery = "
	SELECT 
    DATE_FORMAT(a.creation_datetime_d, '$granularity') AS periode,
    TIME_FORMAT(SEC_TO_TIME(AVG(TIMESTAMPDIFF(SECOND, a.ack_datetime_d, a.close_datetime_d))), '%H:%i:%s') AS temps_moyen_traitement,
    TIME_FORMAT(SEC_TO_TIME(AVG(TIMESTAMPDIFF(SECOND, a.creation_datetime_d, a.close_datetime_d))), '%H:%i:%s') AS temps_moyen, 
    COUNT(*) AS total_tickets 
FROM queue_tickets_tab a 
WHERE a.creation_datetime_d BETWEEN '$startDate' AND '$endDate'
 AND a.status_n !=-1
GROUP BY periode
ORDER BY periode ASC, temps_moyen_traitement ASC; 

                "; 

        // echo $sqlQuery;   
            $sqlResult = mysql_query($sqlQuery, $dbAccess['dbConnection']);
            $this->closeMysqlConnection($dbAccess['dbConnection']);
        }

        return $this->mysqlRessourceJson($sqlResult);
    }

public function getAverageTimePeriodPerAgentsImmat( $profileId,$granularity, $startDate, $endDate) {

        $dbAccess = $this->connectMysqlDatabase(); 

        if (!$dbAccess['dbConnection']) {
            $logDebug = " Echec getQueueCallTopFiveReasonStats()  " . $dbAccess['errorMessage'] . "  " . $dbAccess['errorCode'] . " MSISDN :: $this->msisdn";
            $this->svaLog->writeSystemLog($logDebug);
            die("IMPOSSIBLE DE SE CONNECTER A LA BASE DE DONNEES");
        } else {

            $profileSql = "";
            $userSql = "";
            $limitSql = "";
            $statusSql = "";
            $campaignSql = "";
			$date1Sql = "";
			$date2Sql = "";
            $serviceSql = "";
		                                                      			
            $sqlQuery = "
	SELECT 
    DATE_FORMAT(a.creation_datetime_d, '$granularity') AS periode,
    b.user_name_v AS agent,
    TIME_FORMAT(SEC_TO_TIME(AVG(TIMESTAMPDIFF(SECOND, a.ack_datetime_d, a.close_datetime_d))), '%H:%i:%s') AS temps_moyen_traitement,
    TIME_FORMAT(SEC_TO_TIME(AVG(TIMESTAMPDIFF(SECOND, a.creation_datetime_d, a.close_datetime_d))), '%H:%i:%s') AS temps_moyen, 
    COUNT(*) AS total_tickets 
FROM queue_tickets_tab a
JOIN master_users_tab b ON a.user_id_n = b.user_id_n
WHERE a.creation_datetime_d BETWEEN '$startDate' AND '$endDate'
GROUP BY periode, agent
ORDER BY periode ASC, temps_moyen_traitement ASC; 
 
                "; 

        // echo $sqlQuery;   
            $sqlResult = mysql_query($sqlQuery, $dbAccess['dbConnection']);
            $this->closeMysqlConnection($dbAccess['dbConnection']);
        }

        return $this->mysqlRessourceJson($sqlResult);
    }