public function alldays()
{
$controles = ControleCaixa::orderBy('IDda', 'desc')->get();
return view('alldays', ['controles' => $controles]);
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function viewday()
{
if (isset($_POST['name'])) {
$str = $_POST['name'];
//$id = "li-19-10-2015";
$dia = substr($str, 3, 2);
// returns "19"
$mes = substr($str, 6, 2);
// returns "10"
$ano = substr($str, 9, 4);
// returns "10"
$dataid = $dia . "/" . $mes . "/" . $ano;
$sql = DB::select('SELECT * FROM ControleCaixa WHERE Data="' . $dataid . '"');
if (count($sql) === 1) {
$controle = ControleCaixa::where('Data', '' . $dataid . '')->first();
$dateID = $controle->IDda;
$diatras = $dateID - 1;
$yesterday = ControleCaixa::where('IDda', '' . $diatras . '')->first();
$result = "<h3 align='center'>" . $controle->Data . "</h3>\n \n<table border='1' style='width:100%'>\n \n <thead align='left' style='display: table-header-group'>\n <tr>\n <th style='width:40%'>Abertura</th>\n <th style='width:30%'>Valor</th>\n <th style='width:30%'>Horário</th>\n </tr>\n </thead>\n \n <tbody>\n <td>" . $controle->Entrada1 . " / " . $controle->Entrada2 . "</td> \n <td><p>R\$" . $controle->ValorEntrada . ",00*</p></td>\n <td>" . $controle->timeEntrada . "</td>\n </tbody>\n\n</table> \n\n<br>\n\n<table border='1' style='width:100%'>\n\n <thead align='left' style='display: table-header-group'>\n <tr>\n <th style='width:40%'>Fechamento</th>\n <th style='width:30%'>Valor</th>\n <th style='width:30%'>Horário</th>\n </tr>\n </thead>\n \n <tbody>\n <td>" . $controle->Saida1 . " / " . $controle->Saida2 . " </td> \n <td><p>R\$" . $controle->ValorSaida . ",00</p></td>\n <td>" . $controle->timeSaida . "</td></tr> </tbody>\n\n</table>\n<br><br>\n\n<p>*Abertura do dia deve ser igual ao Fechamento do dia anterior </p>\n<table border='1' style='width:100%'>\n \n <thead align='left' style='display: table-header-group'>\n <tr>\n <th style='width:40%'>Fechamento do dia anterior</th>\n <th style='width:30%'>Abertura do dia</th>\n <th style='width:30%'>Diferença</th>\n </tr>\n </thead>\n \n <tbody>\n \n \n <td>R\$ " . $yesterday->ValorSaida . ",00</td> \n <td><p>R\$ " . $controle->ValorEntrada . ",00</p></td>\n <td style='color:red'>R\$ " . abs($controle->ValorEntrada - $yesterday->ValorSaida) . ",00</td>\n </tbody>\n\n</table>";
return $result;
} else {
$result = "<h3 align='center'>" . $dataid . "</h3>\n <br>\n <p>Não há dados para este dia. Sorry: (</p>";
return $result;
}
}
}
