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; } } }