How to remove equal tables

0

I would like to know if they can help me eliminate the repeated tables, all of which are busy and still appear green.

Each table that I occupy appears one more each, that is, if you only have one table occupied, there is a table 1 in red and a table in each, 2, 3 and 4 in green.

If you occupy two tables, there are 2 tables one, one to green one to red, also to table 2 and table 3 and 4 appear 2 of each to green. I do not understand what I'll get wrong.

.button {
    background-color:#60b0df;
    width:157px;
    height:95px;
    margin-right:5px;
    margin-top:5px;
    margin-bottom:5px;
    margin-left:5px;
    float:left;
}

.button1 {
    width:90px;
    height:90px;
    float:left;
    border-color:#000000;
    border-style:solid;
}

.button2 {
    margin-top:0px;
}

.button3 {
    width:100%;
    float: left;
    margin-top:15px;
    margin-left:10px;
}

.button4 {
    height:100%;
    margin-left:10px;
    float: left;
    margin-top:5px;
    position:relative;
    border-right: 4px solid;
}

.button5 {
    width:500px;
    float:left;
    position:relative;
    margin-top:20px;
    margin-left:5px;
}

.button6{
    width:100%;
    float: left;
    margin-top:15px;
}

.bt5 {
    background-color:#60b0df;
    width:157px;
    height:40px;
    margin-right:5px;
    margin-top:0px;
    margin-bottom:0px;
    float:left;
}

.bt6 {
    background-color:#60b0df;
    width:70px;
    height:40px;
    margin-right:0px;
    margin-top:0px;
    margin-bottom:0px;
    margin-left:0px;
    float: left;
}

.botao1 {
    margin-top:15px;
    background-image: url('open.png');
}

.botao2 {
    position:absolute;
    bottom:5px;
    background-image: url('trocar.png');
    width:30px;
    height:30px; 
    float:right; 
    margin-bottom:15px;
    right:5px;
    margin-top:15px;
}

.botao3 {
    margin-top:15px;
    background-image: url('save.png');
}

.botao4 {
    width:30px;
    height:30px; 
    float: right; 
    margin-bottom: 15px;
    position: absolute; 
    right: 5px; 
    bottom: 5px;
    margin-top:15px;
    background-image: url('exit.png');
}

.botao5 {
    margin-top:15px;
    background-image: url('incluirComanda.png');
}

.fonts {
    font:19px arial, sans-serif;
    padding:0px;
    text-align:center;
    color:#ffffff;
    display:flex;
    justify-content:center;
    align-items:center;
    text-decoration:none;
}

.font {
    font:12px arial, sans-serif;
    padding:0px;
    text-align:center;
    color:#000000;
    display:flex;
    justify-content:center;
    align-items:center;
}

.linha {
    background-color:#60b0df;
    width:100%;
    height:30px;
    margin-top:5px;
    margin-bottom:5px;
    margin-right:35px;
    float:left; 
}

.linhafont {
    font:15px arial, sans-serif;
    color:#ffffff;
    text-align:left;
}

.login {
    width:100%;
    height:100%;
}

.centrar {
    text-align: center ;
}

.centrar2 {
    text-align: center;
    margin-top:50px;
}

.logo1 {
    margin-top:5px;
}

.conexao {
    width:100%;
    height:100%;
}

.total {
    margin-bottom:19px;
}

.total1 {
    width:100%;
    height:100%;
    margin-left:5px;
    margin-top:5px;
    float:left;
    padding: 4px;
}

.cabecalho {
    width:100%
}

.opcao1 {
    float:left;
    color:#87CEFA;
    margin-left: 15px;
}

.mesas {
    float:left;
    text-align:center;
    margin-right:10px;
}

<?php
    include"first_connect.php";
    $id = $_GET['id'];
?>
<html>
    <head>
        <link rel="stylesheet" type="text/css" href="css/styles.css">
        <link rel="shortcut icon" href="img/erbonlogo.png"/>
        <?php
            if($id == 6) {
        ?>
                <title>Banquetes</title>
        <?php
            }

            if($id == 2) {
        ?>
                <title>Bar</title>
        <?php
            }

            if($id == 3) {
        ?>
                <title>Frigobar</title>
        <?php
            }

            if($id == 1) {
        ?>
                <title>Restaurante</title>
        <?php
            }

            if($id == 5) {
        ?>
                <title>Room Service</title>
        <?php
            }
        ?>
    </head>

<?php
    $sql = "SELECT Ac.id AS IdPointOfSaleAccount, 
            P.id AS IdPointOfSale, P.[pointOfSale] AS PointOfSaleDescription, 
            Ac.number AS Number, Ac.total AS TotalValue, Ac.isClosed AS IsClosed, Ac.isActive AS IsActive, 
            T.id AS IdTable, T.tableDescription AS TableDescription, Ac.comments AS Comments, 
            AcDetail.id AS IdDetails, AcDetail.quantity AS QuantityDetail, AcDetail.valueTotal AS ValueTotalDetails, 
            AcDetail.isActive AS IsActiveDetail, AcDetail.updatedBy AS UpdateLine, 
            S.id AS Id, S.[description] AS [Description], S.idServiceAccounts AS IdServiceAccount, 
            SR.idServiceDepartments AS IdDepartment, (CASE WHEN SR.priceSale = 0 OR SR.priceSale is null 
            THEN S.priceSale ELSE SR.priceSale END) AS Price, 
            S.icms AS Tax6, S.iss AS Tax1, S.ir AS Tax2, S.csll AS Tax3, S.pis AS Tax4, S.cofins AS Tax5, 
            S.isProductKitchen AS IsProductKitchen, S.isServiceTax AS IsServiceTax, 
            PrinterConfig.printerKitchen1 AS PrinterKitchen1, 
            PrinterConfig.printerKitchen1FonteTicket AS PrinterKitchen1Font, 
            PrinterConfig.printerKitchen2 AS PrinterKitchen2, 
            PrinterConfig.printerKitchen2FonteTicket AS PrinterKitchen2Font, 
            PrinterConfig.printerKitchen3 AS PrinterKitchen3, 
            PrinterConfig.printerKitchen3FonteTicket AS PrinterKitchen3Font 
            FROM PointOfSaleAccount Ac 
            INNER JOIN PointOfSaleAccountDetails AcDetail ON Ac.id = AcDetail.idPointOfSaleaccount 
            AND AcDetail.isActive = 1 INNER JOIN Services S ON AcDetail.idService = S.id 
            LEFT JOIN ServicesPointOfSalePrinterKitchen Printer  
            ON S.id = Printer.idProduct AND Printer.isActive = 1 AND Printer.idPointOfSale = $id 
            LEFT JOIN ServicesPrinterKitchen PrinterConfig ON Printer.idServicesPrinterKitchen = PrinterConfig.id 
            INNER JOIN ServicesDepartmentsRelationship SR ON S.id = SR.idServices AND SR.isActive = 1 
            AND SR.idServiceDepartments = (SELECT P2.idDepartment FROM PointOfSale P2 WHERE P2.id = Ac.idPointOfSale) 
            INNER JOIN PointOfSale P ON Ac.idPointOfSale = P.id LEFT JOIN PointOfSalesTables T 
            ON Ac.idPointOfSaleTable = T.id 
            WHERE Ac.isClosed = 0 AND Ac.isActive = 1 AND Ac.idPointOfSale = $id 
            ORDER BY Ac.number";

    $result = sqlsrv_query($conn, $sql);

    $sql1 = "SELECT P.id AS Id, P.pointOfSale AS [Description], P.printerExtrat1 AS PrinterExtrat1, 
             P.printerExtrat1FonteTicket AS PrinterExtrat1Font, 
             P.printerExtrat2 AS PrinterExtrat2, P.printerExtrat2FonteTicket AS PrinterExtrat2Font, 
             P.printerExtrat3 AS PrinterExtrat3, P.printerExtrat3FonteTicket AS PrinterExtrat3Font, 
             T.id AS IdTable, T.tableDescription AS TableDescription FROM PointOfSale P 
             LEFT JOIN PointOfSalesTables T ON P.id = T.idPointOfSale AND T.isActive = 1 
             WHERE P.isActive = 1 ORDER BY P.pointOfSale";

    $result1 = sqlsrv_query($conn, $sql1);

?>
    <form action="" method="post">  
        <div class="button2">
            <input type="image" src="image/trocarPDV.png" value="Trocar" name="TrocarPDV">
        </div>
        <span class="linha linhafont">
<?php
            if($id == 6) {
                echo "BANQUETES";
            }

            if($id == 2) {
                echo "BAR";
            }

            if($id == 3) {
                echo "FRIGOBAR";
            }

            if($id == 1) {
                echo "RESTAURANTE";
            }

            if($id == 5) {
                echo "ROOM SERVICE";
            }
?>
        </span>
        <div class="button7">
            <input style="float:left" type="image" src="image/incluirComanda.png" value="Incluir" name="IncluirComanda">

<?php
    if(isset($_POST["TrocarPDV"])) {
        header("Location: pag2.php");
    }

    if(isset($_POST["IncluirComanda"])) {
        header("Location: banquetes.php?id=$id");
    }

    $row[0] = "";
    $i = 0;
    $conf = 0;
    $row12[0] = "";
    $i1 = 0;
    $conf1 = 0;
    $nrow = 0;

    while($row1 = sqlsrv_fetch_array($result, SQLSRV_FETCH_NUMERIC)) {
        for($j = 0; $j < $i; $j++) {
            if($row[$j] == $row1[3]) { 
                $conf = 1;
            }

            else {
            }
        }

        if($conf == 1) { 
            $conf = 0;
        }

        else {
            $resultado3 = $row1[8];

            if($id == 2 || $id == 1) {
                if($resultado3 == "") {
                    $resultado1 = $row1[3];
                    $resultado2 = $row1[4];
                    $row[$i] = $row1[3];
?>
    <span class="button fonts"><?php echo $resultado1;echo "</br>";echo $resultado2;?></span>
            </div>
    </form>
<?php
                    $i = $i + 1;
                }

                else {
                    for($j1 = 0; $j1 < $i1; $j1++) {
                        if($row12[$j1] == $resultado3) {
                            $conf1 = 1;
                        }

                        else {
                        }
                    }

                    if($conf1 == 1) {
                        $conf1 = 0;
                    }

                    else {
                        $row12[$i1] = $resultado3;
                        $nrow = $i1;
                        $i1 = $i1 + 1;
                    }
                }
            }

            else {
                $resultado1 = $row1[3];
                $resultado2 = $row1[4];
                $row[$i] = $row1[3];
?>
    <span class="button fonts"><?php echo $resultado1;echo "</br>";echo $resultado2;?></span>
<?php           
            }
        }
    }

    if($id == 2 || $id == 1) {

?>
        <span class="linha linhafont">MESAS</span>
        <form action="" method="post">  
            <div class="button7">
<?php
        while($row2 = sqlsrv_fetch_array($result1, SQLSRV_FETCH_NUMERIC)) {
            $mesa = $row2[9];
            $id2 = $row2[0];

            if($id2 == $id) {
                for($s = 0; $s <= $nrow; $s ++) {
                    if($mesa == $row12[$s]) {
?>
                        <div class="mesas">
                        <input style="float:left" type="image" src="img/ocupada.jpg" 
                               value="<?php echo $mesa?>" name="<?php echo $mesa?>" height="100">
                        <p><?php echo $mesa;?>
                        </div>
<?php
                    }

                    else {
?>
                        <div class="mesas">
                        <input style="float:left" type="image" src="img/vazia.jpg" 
                               value=<?php echo $mesa?> name=<?php echo $mesa?> height="100">
                        <p><?php echo $mesa;?>
                        </div>
<?php
                    }
?>
            </div>
        </form>
<?php
                }
            }
        }
    }
?>
</html>

    
asked by anonymous 09.03.2018 / 12:55

1 answer

0

Friend, good morning, isolate the possible causes of this problem.

1 - Ensure that queries are not returning a larger registration number, this can occur because of a bad join. To see the data, debug with var_dump ();

2 - If the data is returning correctly, without having tables repeated, check the loops that are being made, if not a loop inside another, looking at your code seems to me that this does not happen.

I think your problem is probably related to item 1.

Getting the debug result, post to us!

    
09.03.2018 / 13:19