TransWar File Browser

Path: C:\

<?php
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) {
		$result = sqlsrv_query($this->conn,$query);
		$i=1;
		while($row=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) 
			{	
						$resultset[$i]['data'] 					=	$row['data'];
						$resultset[$i]['manifesto'] 		=	$row['manifesto'];
						$resultset[$i]['transportadora']=	$row['transportadora'];
						$resultset[$i]['motorista'] 		=	$row['motorista'];
						$resultset[$i]['placa'] 				=	$row['placa'];
						$resultset[$i]['carreta'] 			=	$row['carreta'];
						$resultset[$i]['veiculo'] 			=	$row['veiculo'];
						$resultset[$i]['tipo'] 					= $row['tipo'];
						$resultset[$i]['nrNF']  				= $row['nrNF'] ;
						$resultset[$i]['documento']			= $row['documento'];
						$resultset[$i]['tipomovimento']	= $row['tipomovimento'];
						$resultset[$i]['volume'] 				= $row['volume'];
						$resultset[$i]['cliente'] 			= $row['cliente'];
				if ($row['redespacho']===null)
					{
						$resultset[$i]['local'] 				= $row['local1'];
						$resultset[$i]['endereco']			= $row['endereco1'];
						$resultset[$i]['bairro'] 				= $row['bairro1'];
						$resultset[$i]['cidade'] 				= $row['cidade1'];
						$resultset[$i]['CEP'] 					= $row['CEP1'];
					}
				else
					{
						$resultset[$i]['local'] 				= $row['local2'];
						$resultset[$i]['endereco']			= $row['endereco2'];
						$resultset[$i]['bairro'] 				= $row['bairro2'];
						$resultset[$i]['cidade'] 				= $row['cidade2'];
						$resultset[$i]['CEP'] 					= $row['CEP2'];
					}
						$resultset[$i]['Ocorrencia'] 		= $row['Ocorrencia'];
						$resultset[$i]['data2'] 				= $row['data2'];
						$resultset[$i]['hora'] 					= $row['hora'];
				if ($row['origem']=='MOBILE')
					{
						$resultset[$i]['Mobile'] 				= 'S';
					}
				else
					{
						$resultset[$i]['Mobile'] 				= 'N';
					}
				$i++;
			}
		if(!empty($resultset))
			return $resultset;
	}
}
?>