rechercher: 
getQueueDetailStats 

modifier la ligne de duration

event_datetime_d par ack_datetime_d
,SEC_TO_TIME ( TIMESTAMPDIFF ( SECOND,`ack_datetime_d`, `close_datetime_d`))  duration


public function getQueueDetailStats($userId,$profileId, $status, $serviceId, $startDate, $endDate) {

        $dbAccess = $this->connectMysqlDatabase();

        if (!$dbAccess['dbConnection']) {
            $logDebug = " Echec getQueueDetailStats()  " . $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 = "";
			$itemSql = "";
            $serviceSql = "";
            
            if($serviceId !=-1){
                
                $serviceSql =  "and a.service_id_n ='$serviceId'";
                
            }
/*
            if ($userId == -1 && $profileId == 2){
				$profileSql = "AND c.profile_id_n='$profileId' ";
			}
			elseif($userId != -1 && $profileId == 2){
				$userSql = "AND a.user_id_n='$userId' ";
			}*/
			
            if($status != -2 ){
				$statusSql= "and a.status_n='$status'";
			}
			
           if($startDate != NULL ) {
			   $date1Sql = "and a.creation_datetime_d>='$startDate'" ;                    
                    
			   
		   }
		   
		   if($endDate != NULL){
			  $date2Sql = "and a.creation_datetime_d <='$endDate'" ;
		   }

        

            $sqlQuery = "
                      
                   SELECT   a.item_id_n
						   ,date_format(a.creation_datetime_d,'%d/%m/%Y %H:%i:%s') event_datetime_d
						   ,SEC_TO_TIME ( TIMESTAMPDIFF ( SECOND,`ack_datetime_d`, `close_datetime_d`))  duration
                           ,SEC_TO_TIME ( TIMESTAMPDIFF ( SECOND,`creation_datetime_d`, `close_datetime_d`))  duration_total
						   ,a.ticket_number_n
						   ,a.customer_code_v 
						   ,a.is_played_n 
						   ,b.description_v status_n
						   ,a.ack_datetime_d
						   ,a.close_datetime_d
						   ,a.request_details_v
						   ,a.agent_response_v
						   ,d.service_name_v
						   ,d.service_desc_v
						   ,a.status_n statut
						   ,d.service_code_v
						   ,b.description_v  status_n
						   ,(select concat(object_name_v ,' N°',object_number_n) from queue_objects_tab s, queue_object_dls_tab r,   master_users_tab m where s.object_id_n =r.object_id_n and r.user_id_n = m.user_id_n and m.user_id_n = a.user_id_n ) object_name_v
						   , ( select m.motif_name_v from master_motifs_tab m where m.motif_id_n = a.call_reason_n) motif_name_v
					 FROM  queue_tickets_tab a
						  ,queue_services_tab d
						  ,master_status_tab b
					WHERE  a.service_id_n = d.service_id_n
					and a.status_n = b.status_n	
					$itemSql	
					$date1Sql
					$date2Sql
					$statusSql
                    $profileSql
                    $userSql
                    $serviceSql
                    order by a.creation_datetime_d  desc

                        

                ";


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

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