public function getQueueTicketList($itemId, $userId,$profileId, $statusList, $startDate, $endDate) {

        $dbAccess = $this->connectMysqlDatabase();

        if (!$dbAccess['dbConnection']) {
            $logDebug = " Echec getQueueTicketList()  " . $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 = "";
/*
            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 (!empty($statusList) && is_array($statusList)) {
    $statusIn = implode(",", array_map('intval', $statusList));
    $statusSql = "AND a.status_n IN ($statusIn)";
}
			
           if($startDate != NULL ) {
			   $date1Sql = "and a.creation_datetime_d>='$startDate'" ;                    
                    
			   
		   }
		   
		   if($endDate != NULL){
			  $date2Sql = "and a.creation_datetime_d <='$endDate'" ;
		   }

           if($itemId != -1 ) {
			   $itemSql =  " and a.item_id_n = '$itemId'" ;
		   }

            $sqlQuery = "
                      
                   SELECT   a.item_id_n
						   ,date_format(a.creation_datetime_d,'%d/%m/%Y %H:%i:%s') event_datetime_d
						   ,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
                                                   ,a.service_id_n
						   ,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
						
					 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
                    order by a.creation_datetime_d  desc

                        

                ";


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

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

public function getQueueTicketListInit($itemId, $userId,$profileId, $status, $startDate, $endDate) {

        $dbAccess = $this->connectMysqlDatabase();

        if (!$dbAccess['dbConnection']) {
            $logDebug = " Echec getQueueTicketList()  " . $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 = "";
/*
            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'" ;
		   }

           if($itemId != -1 ) {
			   $itemSql =  " and a.item_id_n = '$itemId'" ;
		   }

            $sqlQuery = "
                      
                   SELECT   a.item_id_n
						   ,date_format(a.creation_datetime_d,'%d/%m/%Y %H:%i:%s') event_datetime_d
						   ,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
                                                   ,a.service_id_n
						   ,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
						
					 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
                    order by a.creation_datetime_d  desc

                        

                ";


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

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