Exemple #1
0
<html>
<head>
<link rel="stylesheet" type="text/css" href="/Main Style.css">
<title>CoolHeat comfort CRM</title>
<link rel="shortcut icon" href="/icon.ico" />
</head>
<body>
<div id="numsect">
<?php 
session_start();
echo "your next number is:";
getnextnumber();
function getnextnumber()
{
    $idnum = $_SESSION["idnum"];
    $sql = "SELECT MIN(IDNKey),Pnumber,Fname,Lname,Address,Comments1,Comments2 FROM numbers WHERE AssignedUser='******' AND Response='booked';";
    //echo $sql;
    $conn = new mysqli($_SESSION["servername"], $_SESSION["Dusername"], $_SESSION["Dpassword"], $_SESSION["dbname"]);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) == 1) {
        $row = $result->fetch_assoc();
        echo "#" . $row["Pnumber"] . "<br>" . $row["Fname"] . "," . $row["Lname"] . "<br>" . $row["Address"] . "<br>" . $row["Comments1"] . "<br>" . $row["Comments2"];
        $_SESSION["IDNKey"] = $row["MIN(IDNKey)"];
        //echo "IDKey=".$_SESSION["IDNKey"];
    } elseif (mysqli_num_rows($result) == 0) {
        echo "Tell Aric your out of rows!";
        echo $sql;
Exemple #2
0
<body>
<div id="numsect">
<?php 
session_start();
$conn = new mysqli($_SESSION["servername"], $_SESSION["Dusername"], $_SESSION["Dpassword"], $_SESSION["dbname"]);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$idnum = $_SESSION["idnum"];
$sqlpunch = "SELECT Type FROM punches WHERE IDKey IN (SELECT MAX(IDKey) FROM punches WHERE AgentID='{$idnum}')";
$resultpunch = mysqli_query($conn, $sqlpunch);
$rowpunch = $resultpunch->fetch_assoc();
$punchedin = $rowpunch["Type"];
if ($punchedin == '0') {
    $zone = getnextnumber();
} else {
    echo "Please punch in.";
}
function getnextnumber()
{
    $idnum = $_SESSION["idnum"];
    $sql = "SELECT MIN(IDNKey),Pnumber,Fname,Lname,Address,Zone FROM numbers WHERE AssignedUser='******' AND AssignedUser<>'0' AND Response='o' AND (Length(Pnumber)='14' OR Length(Pnumber)='10');";
    //echo $sql;
    $conn = new mysqli($_SESSION["servername"], $_SESSION["Dusername"], $_SESSION["Dpassword"], $_SESSION["dbname"]);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) == 1) {