adicionar

[insert_php] error_reporting(E_ALL); ini_set(‘display_errors’, ‘on’); require ‘conn.php’; $pdo = conectar(); // header(‘Content-Type: text/html; charset=utf-8’); $empresa=1; // try { // $pdo = new PDO(“mysql:host=localhost;dbname=pedra”,”root”,””) ; // } catch(PDOException $e) { // echo $e->getMessage(); // } $data = date(“Y-m-d”); $entrada = $data; $saida = date(‘Y-m-d’, strtotime(“+1 day”)); //////////////////////// $livre = 0; if (isset($_GET[‘categoria’])) { $categoria = $_GET[‘categoria’]; // SELECT u.id, u.numero, u.categoria, u.valor, c.nome as nomecat, (SELECT COUNT(r.habitacao) FROM reserva r WHERE r.habitacao = u.numero AND ((r.dataentrada BETWEEN ‘2022-07-08 14:00:00’ AND ‘2022-07-10 14:00:00’) OR (r.datasaida BETWEEN ‘2022-07-08 12:00:00’ AND ‘2022-07-10 12:00:00’))) as livres FROM uhabitacional u LEFT JOIN categoriauh c ON (u.empresa = c.empresa AND u.categoria = c.id) WHERE u.empresa = 1 AND u.deletado = 0 AND u.categoria = 3 ORDER BY u.id $sql = $pdo->prepare(“SELECT u.id, u.numero, u.categoria, u.valor, c.nome as nomecat, (SELECT COUNT(r.habitacao) FROM reserva r WHERE r.habitacao = u.numero AND (r.dataentrada BETWEEN ‘$entrada 14:00:00’ AND ‘$saida 14:00:00’)) as livre FROM uhabitacional u LEFT JOIN categoriauh c ON (u.empresa = c.empresa AND u.categoria = c.id) WHERE u.empresa = $empresa AND u.deletado = 0 AND u.categoria = $categoria ORDER BY u.id”); // print_r($sql); // exit; $sql->execute(); // if ($sql->rowCount() > 0) { $livre = $sql->rowCount(); } while ( $dados = $sql->fetch(PDO::FETCH_ASSOC)) { if ($dados[‘livre’] == 0) { $livre += 1;} $habitacao = $dados[‘numero’]; $categoria = $dados[‘categoria’]; $preco = $dados[‘valor’]; $nomecategoria = utf8_decode($dados[‘nomecat’]); $sqlr = $pdo->prepare(“SELECT r.id FROM reserva WHERE u.empresa = $empresa AND u.deletado = 0 AND u.categoria = $categoria AND u.situacao = 1 ORDER BY u.id”); $sqlr->execute(); // switch ($categoria) { // case 1: // $img = “./images/1.png”; // break; // case 2: // $img = “./images/2.png”; // break; // case 3: // $img = “./images/3.png”; // break; // case 4: // $img = “./images/4.png”; // break; // case 5: // $img = “./images/1.png”; // break; // case 6: // $img = “./images/2.png”; // break; // case 7: // $img = “./images/3.png”; // break; // case 8: // $img = “./images/4.png”; // break; // case 9: // $img = “./images/4.png”; // break; // } } } [/insert_php]

Ir para o conteúdo