Example #1
0
function DisplayTable()
{
    $username = $_SESSION["username"];
    $idnum = $_SESSION["idnum"];
    $conn = new mysqli($_SESSION["servername"], $_SESSION["Dusername"], $_SESSION["Dpassword"], $_SESSION["dbname"]);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM numbers WHERE AssignedUser='******' AND Response='CB' ORDER BY CBDate;";
    $result = mysqli_query($conn, $sql);
    echo "<form action='updatecallback.php' method='post'>";
    echo "<input type='submit' value='Edit'>";
    echo "<table border='6' style='width:100%' class='sortable'>";
    if (mysqli_num_rows($result) > 0) {
        echo "<tr>";
        echo "<td>X</td>";
        echorow("First Name");
        echorow("Last Name");
        echorow("Phone#");
        echorow("Address");
        echorow("Zone");
        echorow("CB Date");
        echorow("CB time");
        echorow("Transfered");
        echorow("Notes1");
        echorow("Notes2");
        echo "</tr>";
        RowTicker("start");
        while ($row = $result->fetch_assoc()) {
            RowTicker("next");
            $idkey = $row["IDNKey"];
            echo "<td><input type='radio' name='rad' value='{$idkey}'></td>";
            $nsql = "SELECT * FROM notes WHERE IDNKey='{$idkey}' AND AgentID='{$idnum}'";
            $nresult = mysqli_query($conn, $nsql);
            $nrow = $nresult->fetch_assoc();
            $text = $nrow["Text"];
            $nrow = $nresult->fetch_assoc();
            $text2 = $nrow["Text"];
            echorow($row["Fname"]);
            echorow($row["Lname"]);
            echorow($row["Pnumber"]);
            echorow($row["Address"]);
            echorow($row["Zone"]);
            echorow($row["CBDate"]);
            echorow($row["CBTime"]);
            echorow($row["OriginalCaller"]);
            echorow($text);
            echorow($text2);
            echo "</tr>";
        }
        $_SESSION["IDNKey"] = $row["MIN(IDNKey)"];
    }
    echo "</table>";
    echo "<input type='submit' value='Edit'>";
    echo "</form>";
}
Example #2
0
}
$sql = "SELECT items.IDKey,items.Description,items.ModelNum,items.BooneKey,categories.Symbol as Csym,units.Symbol AS Usym FROM items INNER JOIN categories ON items.CatID=categories.IDKey INNER JOIN units ON items.UnitID=units.IDKey;";
$result = mysqli_query($conn, $sql);
echo "<form action='updatecallback.php' method='post'>";
echo "<table border='6' style='width:100%' class='sortable'>";
echo "<tr>";
echo "<td>X</td>";
echorow("Description");
echorow("ModelNum");
echorow("Boone ID");
echorow("Category");
echorow("Unit");
echo "</tr>";
RowTicker("start");
while ($row = $result->fetch_assoc()) {
    RowTicker("next");
    $id = $row["IDKey"];
    echo "<td><input type='radio' name='rad' value='{$id}'></td>";
    echorow($row["Description"]);
    echorow($row["ModelNum"]);
    echorow($row["BooneKey"]);
    echorow($row["Csym"]);
    echorow($row["Usym"]);
    echo "</tr>";
}
echo "</table>";
echo "<input type='submit' value='Edit'>";
echo "</form>";
function echorow($p)
{
    echo "<td>{$p}</td>";
Example #3
0
function DisplayTable($sid)
{
    $conn = new mysqli($_SESSION["servername"], $_SESSION["Dusername"], $_SESSION["Dpassword"], $_SESSION["dbname"]);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $bsql = "SELECT * FROM bookings WHERE SalesmanID='{$sid}'";
    $bresult = mysqli_query($conn, $bsql);
    echo "<table border='6' style='width:100%' class='sortable'>";
    echo "<tr>";
    echo "<td>X</td>";
    echo "<td title='Phone Number'>Pnumber</td>";
    echo "<td title='Customer First Name'>First Name</td>";
    echo "<td title='Customer Last Name'>Last Name</td>";
    echo "<td title='Customer Address'>Address</td>";
    echo "<td title='Date of the appointment'>Booking Date</td>";
    echo "<td title='Time of the Appointment'>Appointment Time</td>";
    echo "<td title='Age of the current A/C'>AC Age</td>";
    echo "<td title='Age of the current Furnace'>F Age</td>";
    echo "<td title='Whether this is a Furnace call'>F</td>";
    echo "<td title='Whether this is a A/C call'>A/C</td>";
    echo "<td title='Whether this is a Hot Water Tank call'>T</td>";
    echo "<td title='Whether this is a Boiler call'>B</td>";
    echo "<td title='Customers Cellphone Number'>CellNumber</td>";
    echo "<td title='Booking Agents Name'>First Contact</td>";
    echo "</tr>";
    RowTicker("start");
    while ($brow = $bresult->fetch_assoc()) {
        RowTicker("next");
        $appID = $brow["AppointmentID"];
        $idkey = $brow["IDKey"];
        $idnkey = $brow["IDNKey"];
        $ff = $brow["Fflag"];
        $af = $brow["Aflag"];
        $bf = $brow["Bflag"];
        $tf = $brow["Tflag"];
        $sql = "SELECT Fname,Lname,Address,Pnumber,Zone,FAge,ACAge,CellNumber,AssignedUser FROM numbers WHERE IDNKey='{$idnkey}';";
        $res2 = mysqli_query($conn, $sql);
        $row2 = $res2->fetch_assoc();
        $asql = "SELECT Date,Start,End FROM shifts WHERE IDKey='{$appID}';";
        $ares = mysqli_query($conn, $asql);
        $arow = $ares->fetch_assoc();
        $appdata = $arow["Date"] . ":" . $arow["Start"] . "-" . $arow["End"];
        $address = $row2["Address"];
        echo "<td><input type='radio' name='rad' value='{$idkey}'></td>";
        $address = "<a href='https://maps.google.com?saddr=Current+Location&daddr={$address}'>{$address}</a>";
        echorow($row2["Pnumber"]);
        echorow($row2["Fname"]);
        echorow($row2["Lname"]);
        echorow($address);
        echorow($brow["DateofBooking"]);
        echorow($appdata);
        echorow($row2["ACAge"]);
        echorow($row2["FAge"]);
        echocheck($ff);
        echocheck($af);
        echocheck($tf);
        echocheck($bf);
        echorow($row2["CellNumber"]);
        $id = $row2["AssignedUser"];
        $tsql = "SELECT FName,LName FROM agents WHERE IDKey='{$id}'";
        $res = mysqli_query($conn, $tsql);
        $trow = $res->fetch_assoc();
        echorow($trow["FName"] . $trow["LName"]);
        echo "</tr>";
    }
    echo "</table>";
}