<?php
if (!isset($_SESSION)) {
session_start();
}
include_once 'dados/config.php';
require_once 'dados/classes.php';
$consulta = new banco();
$email = filter_input(INPUT_POST, 'email', FILTER_SANITIZE_EMAIL);
$senha = md5(filter_input(INPUT_POST, 'senha', FILTER_SANITIZE_STRING));
$conta = $consulta->PDOQtderegistro("ZPortareLogin", "email = '" . $email . "'");
if ($conta > 0) {
$sql = $consulta->PDOSelecionar("*", "ZPortareLogin", "email = '" . $email . "'", 0, 10, "id");
$d = new ArrayIterator($sql);
$valor = $d->current();
if ($valor->senha == $senha) {
if ($valor->ativo == 0) {
echo '<div class="alert alert-dismissable alert-danger"><button type="button" class="close" data-dismiss="alert">×</button>' . 'Usuário desativado</div> ';
} else {
$_SESSION['nomelogin'] = $valor->nome;
$_SESSION['idlogin'] = $valor->id;
echo 'Por favor, aguarde enquanto é redirecionado!';
echo "<script language='javascript'>location.href='logado.php';</script>";
echo ' ';
}
} else {
echo '<div class="alert alert-dismissable alert-danger"><button type="button" class="close" data-dismiss="alert">×</button>' . 'A senha digitada é errada</div> ';
}
} else {
echo '<div class="alert alert-dismissable alert-danger"><button type="button" class="close" data-dismiss="alert">×</button>' . 'E-mail não cadastrado</div> ';
}
list($dia, $mes, $ano) = explode("/", $valor);
$condicao .= " AND A.dtorcamento >= '" . $ano . "-" . $mes . "-" . $dia . "'";
} elseif (str_replace("_", ".", $chave) == 'A.dtorcamentoFinal') {
list($dia, $mes, $ano) = explode("/", $valor);
$condicao .= " AND A.dtorcamento <= '" . $ano . "-" . $mes . "-" . $dia . "'";
} else {
$condicao .= " and " . str_replace("_", ".", $chave) . " like '%" . $valor . "%'";
}
}
}
}
}
#echo $condicao;
$dados = $consulta->PDOSelecionar("A.id, B.nome, C.NOME motorista, A.idcaminhao, A.idmov, CONVERT(VARCHAR(20), A.dtsaidaempresa, 103) dtsaida,\r\n(CONVERT(VARCHAR(20), A.dtorcamento, 103)+' '+CONVERT(VARCHAR(20), A.dtorcamento, 108)) dataorcamento, A.dtorcamento,\r\ncase status\r\n WHEN 0 THEN 'Montagem'\r\n WHEN 1 THEN 'Aguardando Resposta'\r\n WHEN 2 THEN 'Aprovado'\r\n WHEN 3 THEN 'Em Viagem'\r\n WHEN 4 THEN 'Concluído'\r\n WHEN 5 THEN 'Cancelado'\r\n WHEN 6 THEN 'Em Carregamento'\r\nEND AS situacao, A.status, A.kmsaida, A.kmchegada, A.kmpercorrido, A.observacao", "ZPortareKm A, ZPortareLogin B, PFUNC C", $condicao, $start + 1, $end, "A.dtorcamento DESC");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareKm A, ZPortareLogin B, PFUNC C", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
include "linha.php";
}
?>
</tbody>
</table>
<?php
$anterior = $pc - 1;
$proximo = $pc + 1;
echo '<ul class="pagination pagination-sm pull-right">';
if ($pc == 0 or $pc == 1) {
include_once '../../dados/config.php';
require_once '../../dados/classes.php';
$consulta = new banco();
$linkurl = explode("/", $_SERVER['SCRIPT_NAME']);
$path = $linkurl[count($linkurl) - 2];
$acao = $_REQUEST['acao'];
$pagina = $_REQUEST['pagina'];
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
$codigo = filter_input(INPUT_POST, 'codigo', FILTER_SANITIZE_STRING);
$codconta = filter_input(INPUT_POST, 'codconta', FILTER_SANITIZE_STRING);
$considerar = filter_input(INPUT_POST, 'considerar', FILTER_SANITIZE_STRING);
$tipodespesa = filter_input(INPUT_POST, 'tipodespesa', FILTER_SANITIZE_STRING);
$valorconta = str_replace(",", ".", str_replace(".", "", $_REQUEST['valorconta']));
if ($acao == 'inserir') {
#Checando se o código já existe
$qtde = $consulta->PDOQtderegistro("ZPortarePlanocontas", "codigo = '" . $codigo . "'");
if ($qtde > 0) {
echo '<script>
jQuery("#alerta").show();
</script>';
} else {
$consulta->PDOInserir("ZPortarePlanocontas", "(codconta, codigo, considerar, tipodespesa, valorconta)", "('" . $codconta . "', '" . $codigo . "', '" . $considerar . "', '" . $tipodespesa . "', " . $valorconta . ")");
echo '<script language="javascript">
carregaPagina(\'view/' . $path . '/list.php\');
jQuery("#alerta").hide();
$("#modalCadastro").modal("hide");
</script>';
}
} elseif ($acao == 'editar') {
$consulta->PDOEditar("ZPortarePlanocontas", "codconta='" . $codconta . "', codigo='" . $codigo . "', considerar='" . $considerar . "', tipodespesa='" . $tipodespesa . "', valorconta=" . $valorconta, "id = " . $id);
echo '<script language="javascript">
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("*", "ZPortareDregrupo", $condicao, $start + 1, $end, "id");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareDregrupo", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->codigo . '</td>
<td>' . $m->descricao . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
<i class="glyphicon glyphicon-edit"></i>
</a>
<a href="javascript:void(0)" class="btn btn-default btn-xs" rel="tooltip" title="Contas" onclick="abrirModal(\'montagem\', ' . $m->id . ' , \'view/dremontagem/list.php\')">
<i class="glyphicon glyphicon-saved"></i>
</a>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("A.id, (A.idmotorista+' - '+B.NOME) NOME, A.operadora, A.numero", "ZPortareTelefones A, PFUNC B", $condicao, $start + 1, $end, "B.NOME");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareTelefones A, PFUNC B", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->id . '</td>
<td>' . $m->NOME . '</td>
<td>' . $m->operadora . '</td>
<td>' . $m->numero . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
<i class="glyphicon glyphicon-edit"></i>
</a>
<a href="javascript:void(0)" class="btn btn-primary btn-xs" rel="tooltip" title="Excluir" onclick="modalExcluir(\'view/' . $path . '/actions.php\', ' . $m->id . ')">
$codigo = filter_input(INPUT_POST, 'codigo', FILTER_SANITIZE_STRING);
$descricao = filter_input(INPUT_POST, 'descricao', FILTER_SANITIZE_STRING);
if ($acao == 'inserir') {
$consulta->PDOInserir("ZPortareDregrupo", "(codigo, descricao, valor)", "('" . $codigo . "', '" . $descricao . "', 0)");
echo '<script language="javascript">
carregaPagina(\'view/' . $path . '/list.php\')
$("#modalCadastro").modal("hide");
</script>';
} elseif ($acao == 'editar') {
$consulta->PDOEditar("ZPortareDregrupo", "codigo='" . $codigo . "', descricao='" . $descricao . "'", "id = " . $id);
echo '<script language="javascript">
carregaPagina(\'view/' . $path . '/list.php\')
$("#modalCadastro").modal("hide");
</script>';
} elseif ($acao == 'excluir') {
$id = $_POST['id'];
# Tem que checar se esta seguradora não faz parte de um cliente
$checa = $consulta->PDOQtderegistro("ZPortareDremontagem", "idgrupo = " . $id);
if ($checa > 0) {
echo '<div class="alert alert-dismissable alert-danger">
<button type="button" class="close" data-dismiss="alert">×</button>' . '
Este grupo não pode ser excluído por apresentar contas vinculados!
</div>';
} else {
$consulta->PDOExcluir("ZPortareDregrupo", "id = " . $id);
echo '<script language="javascript">
$("#' . $path . $id . '").remove();
$("#modalExcluir").modal("hide");
</script>';
}
}
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("B.id, A.descricao, B.valor, CASE B.periododiario\r\n\tWHEN 365 THEN 'Anual'\r\n\tWHEN 180 THEN 'Semestral'\r\n\tWHEN 90 THEN 'Trimestral'\r\n\tWHEN 60 THEN 'Bimestral'\r\n\tWHEN 30 THEN 'Mensal'\r\n\tWHEN 1 THEN 'Diária'\r\nEND AS tipodiaria", "ZPortareDespesas A, ZPortareCaminhoesdespesas B", $condicao, $start + 1, $end, "A.descricao");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareDespesas A, ZPortareCaminhoesdespesas B", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->descricao . '</td>
<td>' . $m->tipodiaria . '</td>
<td>' . number_format($m->valor, 2, ',', '.') . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
<i class="glyphicon glyphicon-edit"></i>
</a>
<a href="javascript:void(0)" class="btn btn-primary btn-xs" rel="tooltip" title="Excluir" onclick="modalExcluir(\'view/' . $path . '/actions.php\', ' . $m->id . ')">
<i class="glyphicon glyphicon-trash"></i>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("CODCONTA, DESCRICAO", "(\r\n SELECT CODCONTA, DESCRICAO FROM CCONTA\r\n WHERE CODCONTA NOT IN (SELECT X.codconta FROM ZPortarePlanocontas X)\r\n AND ANALITICA = 1\r\n AND CODCONTA LIKE '3%'\r\n UNION\r\n SELECT CODCONTA, DESCRICAO FROM CCONTA\r\n WHERE CODCONTA NOT IN (SELECT X.codconta FROM ZPortarePlanocontas X)\r\n AND ANALITICA = 1\r\n AND CODCONTA LIKE '4%'\r\n ) AS TABELA", $condicao, $start + 1, $end, "CODCONTA");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("(\r\n SELECT CODCONTA, DESCRICAO FROM CCONTA\r\n WHERE CODCONTA NOT IN (SELECT X.codconta FROM ZPortarePlanocontas X)\r\n AND ANALITICA = 1\r\n AND CODCONTA LIKE '3%'\r\n UNION\r\n SELECT CODCONTA, DESCRICAO FROM CCONTA\r\n WHERE CODCONTA NOT IN (SELECT X.codconta FROM ZPortarePlanocontas X)\r\n AND ANALITICA = 1\r\n AND CODCONTA LIKE '4%'\r\n ) AS TABELA", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->CODCONTA . '</td>
<td>' . $m->DESCRICAO . '</td>
</tr>';
$d->next();
}
?>
</tbody>
</table>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("A.CHAPA, A.NOME, B.NOME FUNCAO", "PFUNC A, PFUNCAO B", $condicao, $start + 1, $end, "A.NOME");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("PFUNC A, PFUNCAO B", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->CHAPA . '">
<td>' . $m->CHAPA . '</td>
<td>' . $m->NOME . '</td>
<td>' . $m->FUNCAO . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Ver Detalhes">
<i class="glyphicon glyphicon-edit"></i>
</a>
</td>
</tr>';
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
$nome = filter_input(INPUT_POST, 'nome', FILTER_SANITIZE_STRING);
if ($acao == 'inserir') {
$consulta->PDOInserir("ZPortarePerfil", "(nome)", "('" . $nome . "')");
echo '<script language="javascript">
carregaPagina(\'view/' . $path . '/list.php\')
$("#modalCadastro").modal("hide");
</script>';
} elseif ($acao == 'editar') {
$consulta->PDOEditar("ZPortarePerfil", "nome='" . $nome . "'", "id = " . $id);
echo '<script language="javascript">
carregaPagina(\'view/' . $path . '/list.php\')
$("#modalCadastro").modal("hide");
</script>';
} elseif ($acao == 'excluir') {
$id = $_POST['id'];
# Tem que checar se esta seguradora não faz parte de um cliente
$checa = $consulta->PDOQtderegistro("ZPortareLogin", "idperfil = " . $id);
if ($checa > 0) {
echo '<div class="alert alert-dismissable alert-danger">
<button type="button" class="close" data-dismiss="alert">×</button>' . '
Esta PERFIL não pode ser excluído por apresentar usuário vinculados!
</div>';
} else {
$consulta->PDOExcluir("ZPortarePerfil", "id = " . $id);
echo '<script language="javascript">
$("#' . $path . $id . '").remove();
$("#modalExcluir").modal("hide");
</script>';
}
}
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("A.id, A.nome, A.email, B.nome perfil, CASE A.ativo WHEN 1 THEN 'Ativo' ELSE 'Inativo' END status", "ZPortareLogin A, ZPortarePerfil B", $condicao, $start + 1, $end, "A.nome");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareLogin A, ZPortarePerfil B", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->id . '</td>
<td>' . $m->nome . '</td>
<td>' . $m->email . '</td>
<td>' . $m->perfil . '</td>
<td>' . $m->status . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
<i class="glyphicon glyphicon-edit"></i>
</a>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("A.id, A.codconta, A.codigo, B.descricao,\r\n CASE A.considerar WHEN 'D' THEN 'Tabela DRE' WHEN 'F' THEN 'Tabela Fixa' WHEN 'P' THEN 'Folha de Pagamento' END considerar,\r\n CASE A.tipodespesa WHEN 'D' THEN 'Direta' WHEN 'I' THEN 'Indireta' END tipo", "ZPortarePlanocontas A, CCONTA B", $condicao, $start + 1, $end, "codigo");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortarePlanocontas A, CCONTA B", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->id . '</td>
<td>' . $m->considerar . '</td>
<td>' . $m->tipo . '</td>
<td>' . $m->codconta . '</td>
<td>' . $m->codigo . '</td>
<td>' . $m->descricao . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php?pagina=' . $pc . '\')">
<i class="glyphicon glyphicon-edit"></i>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("A.codconta, A.codigo, B.DESCRICAO", "ZPortarePlanocontas A WITH (NOLOCK) JOIN CCONTA B ON A.codconta = B.CODCONTA", $condicao, $start + 1, $end, "codigo");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortarePlanocontas A WITH (NOLOCK) JOIN CCONTA B ON A.codconta = B.CODCONTA", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->codconta . '</td>
<td>' . $m->codigo . '</td>
<td>' . $m->DESCRICAO . '</td>
</tr>';
$d->next();
}
?>
</tbody>
</table>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("*", "ZPortarePerfil", $condicao, $start + 1, $end, "nome");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortarePerfil", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->id . '</td>
<td>' . $m->nome . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
<i class="glyphicon glyphicon-edit"></i>
</a>
<a href="javascript:void(0)" class="btn btn-primary btn-xs" rel="tooltip" title="Excluir" onclick="modalExcluir(\'view/' . $path . '/actions.php\', ' . $m->id . ')">
<i class="glyphicon glyphicon-trash"></i>
</a>
$linkurl = explode("/", $_SERVER['SCRIPT_NAME']);
$path = $linkurl[count($linkurl) - 2];
$acao = $_REQUEST['acao'];
$tipo = $_REQUEST['tipo'];
$requisicao = $_REQUEST['requisicao'];
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
$idkm = filter_input(INPUT_POST, 'idkm', FILTER_SANITIZE_NUMBER_INT);
$valor = empty($_REQUEST['valor']) ? 0 : str_replace(",", ".", str_replace(".", "", $_REQUEST['valor']));
$litragem = empty($_REQUEST['litragem']) ? 0 : str_replace(",", ".", str_replace(".", "", $_REQUEST['litragem']));
$km = empty($_REQUEST['km']) ? 0 : str_replace(",", ".", str_replace(".", "", $_REQUEST['km']));
list($dia, $mes, $ano) = explode("/", $_REQUEST['data']);
$data = $ano . '-' . $mes . '-' . $dia;
if ($acao == 'inserir') {
# Checando se já existe Saída do caminhão
if ($tipo == 'S') {
$saida = $consulta->PDOQtderegistro("ZPortareKmAbastecimentos", "idkm = " . $idkm . " and tipo = 'S'");
if ($saida > 0) {
echo '<div class="alert alert-dismissable alert-danger">
<button type="button" class="close" data-dismiss="alert">×</button>' . '
Já existe um abastecimento do <b>tipo Saída</b>!
</div>';
exit;
}
}
if ($tipo == 'A') {
#Verificando se já existe um abastecimento de chegada para não deixar cadastrar novos abastecimentos
$chegada = $consulta->PDOQtderegistro("ZPortareKmAbastecimentos", "idkm = " . $idkm . " and tipo = 'C'");
if ($chegada > 0) {
echo '<div class="alert alert-dismissable alert-danger">
<button type="button" class="close" data-dismiss="alert">×</button>' . '
Não pode inserir abastecimento por já ter um do <b>tipo Chegada</b>!
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("CODCOLIGADA, CODCFO, NOMEFANTASIA, NOME, CGCCFO, ISNULL(VALOROP1, 0) VALOROP1, ISNULL(VALOROP2, 0) VALOROP2", "FCFO (NOLOCK)", $condicao, $start + 1, $end, "NOME");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("FCFO", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->CODCFO . '">
<td>' . $m->CODCFO . '</td>
<td>' . $m->NOMEFANTASIA . '</td>
<td>' . $m->NOME . '</td>
<td>' . $m->CGCCFO . '</td>
<td>' . $m->VALOROP1 . '</td>
<td>' . $m->VALOROP2 . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Ver Detalhes">
<i class="glyphicon glyphicon-edit"></i>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("*", "ZPortareDespesas", $condicao, $start + 1, $end, "descricao");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareDespesas", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->id . '</td>
<td>' . $m->descricao . '</td>
<td>' . number_format($m->valor, 2, ',', '.') . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php?tipo=' . $tipo . '\')">
<i class="glyphicon glyphicon-edit"></i>
</a>
<a href="javascript:void(0)" class="btn btn-primary btn-xs" rel="tooltip" title="Excluir" onclick="modalExcluir(\'view/' . $path . '/actions.php\', ' . $m->id . ')">
<i class="glyphicon glyphicon-trash"></i>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("*", "ZPortalCAMINHOES", $condicao, $start + 1, $end, "MODELO");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortalCAMINHOES", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->PLACA . '">
<td>' . $m->PLACA . '</td>
<td>' . $m->MODELO . '</td>
<td>' . $m->VENCIPVA . '</td>
<td>
<a href="javascript:void(0)" onclick="CarregarDespesas(\'' . $m->PLACA . '\')" class="btn btn-info btn-xs" rel="tooltip" title="Ver Despesas">
<i class="glyphicon glyphicon-folder-open"></i>
</a>
<a href="javascript:void(0)" onclick="CarregarAgregados(\'' . $m->PLACA . '\' , \'carretas\')" class="btn btn-warning btn-xs" rel="tooltip" title="Históricos">
<i class="glyphicon glyphicon-eye-open"></i>
# Aqui virá os filtros
/*foreach ($_POST as $chave => $valor) {
if(($chave<>'acao') and ($chave<>'tipo')){
if($valor<>'') {
if ((str_replace("_", ".", $chave)=='A.id') or (str_replace("_", ".", $chave)=='A.idservico') or (str_replace("_", ".", $chave)=='A.idcliente') or (str_replace("_", ".", $chave)=='A.idseguradora') or (str_replace("_", ".", $chave)=='A.status')) {
$condicao .= " and ". str_replace("_", ".", $chave). " = ".$valor;
} else {
$condicao .= " and ". str_replace("_", ".", $chave). " like '%".$valor."%'";
}
}
}
}
//echo $condicao;*/
$dados = $consulta->PDOSelecionar("*", "ZPortareCombustivel", $condicao, $start + 1, $end, "descricao");
$d = new ArrayIterator($dados);
$tr = $consulta->PDOQtderegistro("ZPortareCombustivel", $condicao);
// Total de registros
$tp = ceil($tr / $total_reg);
// Total de registros na página
while ($d->valid()) {
$m = $d->current();
echo '<tr id="' . $path . $m->id . '">
<td>' . $m->id . '</td>
<td>' . $m->descricao . '</td>
<td>
<a href="javascript:void(0)" class="btn btn-danger btn-xs" rel="tooltip" title="Editar" onclick="abrirModal(\'editar\', ' . $m->id . ' , \'view/' . $path . '/form.php\')">
<i class="glyphicon glyphicon-edit"></i>
</a>
<a href="javascript:void(0)" class="btn btn-primary btn-xs" rel="tooltip" title="Excluir" onclick="modalExcluir(\'view/' . $path . '/actions.php\', ' . $m->id . ')">
<i class="glyphicon glyphicon-trash"></i>
</a>
