<?php
include('verifica_login.php');
include('header.php');
function convertDecimal($floatNumber = 0){
	return number_format($floatNumber, 2, ',', '.');
}



function dateConverter ($dateArray = []):string{
	 //ano, mes, dia, eu acho para to_date('01-02-2018','dd-mm-rrrr');
	return (string)$dateArray[2]."-".$dateArray[1]."-".$dateArray[0];
}

/*
SELECT t.codfilial,t.numped,t.codcli,e.cliente,t.duplic,t.prest,t.valor,t.codcob,t.dtemissao,t.codusur,u.nome,t.numcheckout,t.codfunccheckout,
t.numtransvenda,T.VPAGO AS BAIXADO,T.DTBAIXA AS DT_BAIXA, T.DTULTALTER
FROM pcprest t,pcclient e,pcusuari u
  where  t.codusur = u.codusur
     and t.codcli = e.codcli
AND T.DTEMISSAO between to_date(:DATAINI,'dd-mm-rrrr') and to_date (:DATAFIM,'dd-mm-rrrr')
AND T.CODCOB IN (:CODCOB)
AND T.NUMCHECKOUT IN (:NUMCHECKOUT)
AND T.CODFUNCCHEKOUT IN (:CODFUNCCHEKOUT)
AND T.CODCLI IN (:CODCLI)
AND T.NUMPED IN (:NUMPED)

ORDER BY DUPLIC

*/



/*

$sql = "SELECT * FROM ( select row_number() OVER (order by dtemissao desc) linha, t.codfilial,t.numped,t.codcli,e.cliente,t.duplic,t.prest,t.valor, t.codcob,t.dtemissao,t.codusur,u.nome,t.numcheckout,t.codfunccheckout,
t.numtransvenda,T.VPAGO AS BAIXADO,T.DTBAIXA AS DT_BAIXA, T.DTULTALTER
FROM pcprest t, pcclient e,pcusuari u where t.codusur = u.codusur
and t.codcli = e.codcli";




*/




$sql = "SELECT * FROM ( select row_number() OVER (order by DUPLIC) linha, t.codfilial,t.numped,t.codcli,e.cliente,t.duplic,t.prest,t.valor, t.codcob,t.dtemissao,t.codusur,u.nome,t.numcheckout,t.codfunccheckout,
t.numtransvenda,T.VPAGO AS BAIXADO,T.DTBAIXA AS DT_BAIXA, T.DTULTALTER
FROM pcprest t, pcclient e,pcusuari u where t.codusur = u.codusur
and t.codcli = e.codcli";



if(isset($_POST['CODCOB']) && strlen(((string) $_POST['CODCOB'])) > 0){
	 $CODCOB = $_POST ['CODCOB'];
	 $sql .= " and T.CODCOB IN ('$CODCOB')";
}

if(isset($_POST['NUMPED']) && ((int)($_POST['NUMPED'])) > 0){
	 $NUMPED = $_POST ['NUMPED'];

	 $sql .= " and T.NUMPED = $NUMPED";
}

if(isset($_POST['CODCLI']) && ((int)($_POST['CODCLI'])) > 0){
	 $CODCLI = $_POST ['CODCLI'];

	 $sql .= " and T.CODCLI = $CODCLI";
}

if(isset($_POST['NUMCHECKOUT']) && ((int)($_POST['NUMCHECKOUT'])) > 0){
	 $NUMCHECKOUT = $_POST ['NUMCHECKOUT'];

	 $sql .= " and T.NUMCHECKOUT = $NUMCHECKOUT";

}




if(isset($_POST['DTEMISSAO']) && strlen(((string) $_POST['DTEMISSAO'])) > 0){
	$DTEMISSAO = $_POST ['DTEMISSAO'];
	$explodedDate = explode("-", $DTEMISSAO);
	$stringDate = dateConverter($explodedDate);

	$sql .= " and T.DTEMISSAO = to_date('$stringDate','dd-mm-rrrr')";
}

if(isset($_POST['CODUSUR']) && strlen(((string) $_POST['CODUSUR'])) > 0){
	$CODUSUR = $_POST ['CODUSUR'];
	 $sql .= " and T.CODUSUR = $CODUSUR";
}


















 $atualPage = $page = isset($_GET['page']) ? $_GET['page'] : 1;

$page = $atualPage+1;

$qtdItensInicio = (($atualPage - 1) * 20); // se for pagina 1, 1-1 == 0, ent?o 0*20 == 0; ent?o ele limita em 20 itens, buscando desde o 0;
$qtdItensFim = $qtdItensInicio + 20;
$sql .= " ) WHERE linha BETWEEN $qtdItensInicio AND $qtdItensFim";




 ?>

 <div class="control-group">


 <form method="POST" class="tab-pane active" action="8022.php">
    <br>

<input class="span2" type="text" id="NUMPED" name="NUMPED" placeholder="NUMERO DO PEDIDO...">
<input class="span2" type="text" id="CODUSUR" name="CODUSUR" placeholder="COD USUARIO...">

<input class="span2" type="text" id="CODCLI" name="CODCLI" placeholder="CODIGO DO CLIENTE...">

<input class="span2" type="text" id="NUMCHECKOUT" name="NUMCHECKOUT" placeholder="NUM CHECKOUT...">










<input type="date"  id="DTEMISSAO" name="DTEMISSAO" pattern="dd/MM/yyyy"/>

<input class="span2" type="text" id="CODCOB" name="CODCOB" placeholder="COD COB...">









<input class="btn_textcenter bg-white " type="submit" class="solid" value="Buscar">
<!--  <a class="btn btn-danger" href="logout.php" style="float:right">SAIR X</a> !-->

  </form>

  </div>

<?php



$user = ""; $pass = ""; $name = ""; $host = "";

$tns = " (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = ".$host.")(PORT = )))(CONNECT_DATA = (SID = ".$name.")))";


try {
$senha="";
$db = new PDO("oci:dbname=".$tns,$user,$pass);
 } catch (PDOException $e) {
    echo $e->getMessage();
	exit;
 }



$stmt = $db->prepare($sql);
$stmt->execute();






$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sum = "SELECT SUM(VALOR) as total
FROM pcprest T
WHERE T.DTEMISSAO = to_date('$stringDate','dd-mm-rrrr') AND T.CODCOB IN ('$CODCOB') AND T.NUMCHECKOUT IN ($NUMCHECKOUT)";
$soma = $db->query($sum)->fetchColumn();




//imprime com as pontuação e virgula


if ($NUMCHECKOUT == 10){
	$cg = 'AÇO BRAZIL';
}

if ($NUMCHECKOUT == 20){
	$cg = 'AÇO BOMPREÇO';
}

if ($NUMCHECKOUT == 30){
	$cg = 'AÇO CAMPINA';
}

if ($NUMCHECKOUT == 40){
	$cg = 'AÇO PARAIBA';
}

if ($NUMCHECKOUT == 50){
	$cg = 'AÇO BRAZIL INDUSTRIA';
}

if ($NUMCHECKOUT == 60){
	$cg = 'AÇO BRAZ';
}



echo '<div class="container" style=" border-style: solid; border-color: #000; "><h2>CAIXA: '.$cg.'<br> TOTAL: R$ '.$soma.'<br>COBRANÇA: '.$CODCOB.'<br>DATA: '.$stringDate.'
 </h2></div>';

	echo '<table class="table">
  <thead>
    <tr>

	  <th scope="col">CODFILIAL</th>
      <th scope="col">PEDIDO</th>
      <th scope="col">NUMCHECKOUT</th>
      <th scope="col">COD. CLIENTE</th>
      <th scope="col">CLIENTE</th>
	  <th scope="col">DUPLIC</th>
      <th scope="col">VALOR</th>
	  <th scope="col">CODCOB</th>
	  <th scope="col">DTEMISSAO</th>
	  <th scope="col">CODUSR</th>
	  <th scope="col">VENDEDOR</th>
	  <th scope="col">DTULTALTER</th>
	  <th scope="col">BAIXADO</th>
	  <th scope="col">DTBAIXA</th>

    </tr>
  </thead>';

while($reg = $stmt->fetch(PDO::FETCH_OBJ))
{

echo '
  <tbody>
    <tr>
	  <td>'.$reg->CODFILIAL.'</td>
      <td>'.$reg->NUMPED.'</td>
      <td>'.$reg->NUMCHECKOUT.'</td>
	  <td>'.$reg->CODCLI.'</td>
	  <td>'.$reg->CLIENTE.'</td>
	  <td>'.$reg->DUPLIC.'</td>
	  <td>'.$reg->VALOR.'</td>
	  <td>'.$reg->CODCOB.'</td>
	  <td>'.$reg->DTEMISSAO.'</td>
	  <td>'.$reg->CODUSUR.'</td>
	  <td>'.$reg->NOME.'</td>
	  <td>'.$reg->DTULTALTER.'</td>
	  <td>'.$reg->BAIXADO.'</td>
	  <td>'.$reg->DT_BAIXA.'</td>


    </tr>

  </tbody>';
}



echo '
	<a href="/painel/acobrazil/8022.php?page='.$page.'">Proxima pagina</a>
';

//echo '<h2>FILIAL Nº'; echo $reg->CODFILIAL."<br />"."CODIGOPRODUTO:"; echo $reg->CODPROD."<br />"."QT DISPONIVEL:".
//$reg->QTDISP."<br/>"."QT UNITARIA:"; echo $reg->QTUNITP."<br/>";


/*
$totaldisp = $mysqli->query("SELECT sum(total) FROM recibo WHERE mes = 'Setembro'");
        while ($linha = mysqli_fetch_assoc($totaldisp)){
    $total = $linha['sum(total)'];
    }*/




?>