TransWar File Browser

Path: C:\

<?php
ini_set('max_execution_time',259200); 
ini_set ('memory_limit','-1');
date_default_timezone_set('America/Fortaleza');
class Conexao {
	private $conn = "";
	private $host = "srvtms";
	private $connectionOptions = array("Database" => "dtbtransporte", "UID" => "sa", "PWD" => "13509","CharacterSet" => "UTF-8");
	function __construct() {
		$conn = $this->connectDB();
		if(!empty($conn)) {
			$this->conn = $conn;			
		}
	}

	function connectDB() {
		$conn = sqlsrv_connect($this->host, $this->connectionOptions);
		return $conn;
	}

	function executeSelectQuery($query){
		$currentDate = date("Ymd");
		$currentDate1 = date("d/m/Y");
		$result = sqlsrv_query($this->conn,$query);
		$i=1;
		while($row=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) 
			{		
					$resultset[$i][0]								=	$row['data'];
					$resultset[$i][1] 					=	$row['manifesto'];
					$resultset[$i][2]			=	$row['transportadora'];
					$resultset[$i][3] 					=	$row['motorista'];
					$resultset[$i][4] 						=	$row['veiculo'];
					$resultset[$i][5] 							=	$row['placa'];
					$resultset[$i][6] 						=	$row['carreta'];
					$resultset[$i][7] 								= $row['tipo'];
					$resultset[$i][8] 							= $row['volume'];
					$resultset[$i][9]  						= $row['nrNF'] ;
					$resultset[$i][10]  					= $row['vlrNF'] ;
					$resultset[$i][11]  				= $row['vlrFrete'] ;
					$resultset[$i][12]						= $row['documento'];
					$resultset[$i][13]			= $row['tipomovimento'];
					$resultset[$i][14]							=	str_replace('&', 'e',$row['cliente'] );
					$resultset[$i][15]					=	str_replace('&', 'e',$row['local2'] );
					$resultset[$i][16]			= $row['endereco2'];
					$resultset[$i][17] 			= $row['bairro2'];
					$resultset[$i][18]		= $row['cidade2'];
					$resultset[$i][19] 					= $row['cep2'];
					$resultset[$i][20]				=	str_replace('&', 'e',$row['local1'] );
					$resultset[$i][21]						= $row['endereco1'];
					$resultset[$i][22] 							= $row['bairro1'];
					$resultset[$i][23] 					= $row['cidade1'];
					$resultset[$i][24] 								= $row['cep1'];
					$resultset[$i][25] 					= $row['id_Ocorre'];
					$resultset[$i][26] 					= $row['ocorrencia'];
					$resultset[$i][27] 								= $row['data2'];
					$resultset[$i][28] 						= $row['hora'];
					if ($row['origem']=='MOBILE')
						{
							$resultset[$i][29] 					= 'S';
						}
					else
						{
							$resultset[$i][29] 					= 'N';
						}
					$resultset[$i][30] 							= $row['limite'];
					$Comentário 										= $row['coment'];
					$resultset[$i][31]  	= preg_replace("/\r?\n/","", $Comentário);
					$resultset[$i][32] 						= $row['status1'];
					$resultset[$i][33] 						= $row['status2'];
					$resultset[$i][34] 						= $row['status3'];
					if ($resultset[$i][20]==$resultset[$i][15])
						{	
							$resultset[$i][15]='';
							$resultset[$i][16]='';
							$resultset[$i][17]='';
							$resultset[$i][18]='';
							$resultset[$i][19]='';
						}
					if ($row['tipo']=='COLETA' and $row['ocorrencia']===null)
						{	if ($row['status1']=='N' and $row['status2']=='N' and $row['status3']=='N')
								{	$resultset[$i][26]='PENDENTE';$resultset[$i][25]='146';}
							if ($row['status1']=='A' and ($row['status2']=='N' and $row['status3']=='N'))
								{	$resultset[$i][26]='ALOCADO';$resultset[$i][25]='149';}
							if ($row['status1']=='A' and ($row['status2']=='N' and $row['status3']=='S'))
								{	$resultset[$i][26]='ALOCADO';$resultset[$i][25]='149';}
							if ($row['status1']=='N' and ($row['status2']=='S' and $row['status3']=='S'))
								{	$resultset[$i][26]='LIBERADO';$resultset[$i][25]='148';}
							if ($row['status1']=='N' and ($row['status2']=='S' and $row['status3']=='N'))
								{	$resultset[$i][26]='LIBERADO';$resultset[$i][25]='148';}
							if ($row['status1']=='S')
								{	$resultset[$i][26]='COLETADA (SEM OCORRÊNCIA)';$resultset[$i][25]='32';}
						}
					if ($row['tipo']=='COLETA' and $row['id_Ocorre']<>32 and $row['manifesto']<>null and ($resultset[$i][26]=='ALOCADA' or $resultset[$i][26]=='LIBERADO' or $resultset[$i][26]=='PENDENTE'))
						{	$resultset[$i][26]='EM ROTA DE COLETA';$resultset[$i][25]='147';}
					$resultset[$i][35] 								= $row['data3'];
					$resultset[$i][36] 								= $row['data4'];
					if ($resultset[$i][27]=='')
					{	if ($resultset[$i][36]<>''){$resultset[$i][27]=$row['data4a'];$resultset[$i][35]=$row['data4'];}
						else
						{
							if ($resultset[$i][26]=='COLETADA (SEM OCORRÊNCIA)'){$resultset[$i][27]=$row['data'];$resultset[$i][35]=$row['datab'];}
							if ($resultset[$i][26]=='PENDENTE' or $resultset[$i][26]=='LIBERADO' or $resultset[$i][26]=='ALOCADO'){$resultset[$i][27]=$currentDate1;$resultset[$i][35]=$currentDate;}
						}
					}
					$i++;
			}
		if(!empty($resultset))
			return $resultset;
	}
}
?>