public function getAverageTimeServicePeriodImmat( $profileId,$granularity,$serviceId,$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 = "";

            if($serviceId !=-1){
                
                $serviceSql =  "and a.service_id_n ='$serviceId'";
                
            }
		                                                      			
            $sqlQuery = "
	SELECT 
    DATE_FORMAT(a.creation_datetime_d, '$granularity') AS periode,
    d.service_name_v as service,
    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 
        ,queue_services_tab d
    WHERE a.service_id_n = d.service_id_n
    AND a.creation_datetime_d BETWEEN '$startDate' AND '$endDate'
    AND a.close_datetime_d IS NOT NULL
    AND a.status_n =3 
    $serviceSql
    GROUP BY periode,service
    ORDER BY periode ASC, temps_moyen_traitement ASC; 

                "; 

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

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