TransWar File Browser

Path: C:\

<?php
ini_set('max_execution_time',259200); 
ini_set ('memory_limit','1536M');
date_default_timezone_set('America/Sao_Paulo');
class Conexao {
	private $conn = "";
	private $host = "192.168.0.201";
	private $connectionOptions = array("Database" => "dtbtransporte", "UID" => "bi", "PWD" => "BI@Consult@","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]							= substr($row['documento'], 5, 8);
					$resultset[$i][13]							= $row['tipomovimento'];
					$resultset[$i][14]							=	str_replace('&', 'e',$row['cliente']);
					$resultset[$i][14]							=	str_replace(',', ' ',$resultset[$i][14]);
					$resultset[$i][15]							=	str_replace('&', 'e',$row['local2']);
					$resultset[$i][15]							=	str_replace(',', ' ',$resultset[$i][15]);
					$resultset[$i][16]							= str_replace(',', ' ',$row['endereco2']);
					$resultset[$i][17] 							= str_replace(',', ' ',$row['bairro2']);
					$resultset[$i][18]							= $row['cidade2'];
					$resultset[$i][19] 							= $row['cep2'];
					$resultset[$i][20]							=	str_replace('&', 'e',$row['local1']);
					$resultset[$i][20]							=	str_replace(',', ' ',$resultset[$i][20]);
					$resultset[$i][21]							= str_replace(',', ' ',$row['endereco1']);
					$resultset[$i][22] 							= str_replace(',', ' ',$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'];
					$resultset[$i][35] 							= $row['data3'];
					$resultset[$i][36] 							= $row['data4'];
					$resultset[$i][37] 							= $row['Data_Coleta'];
					$resultset[$i][38] 							= $row['Situacao'];
					$resultset[$i][39] 							= $row['CentroCusto'];
					$resultset[$i][40] 							= $row['sequencia'];
					$resultset[$i][41] 							= $row['clirem'];
					$resultset[$i][42] 							= $row['complemento'];
					$resultset[$i][43] 							= $row['peso'];
					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';}
					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;
	}
}
?>