示例#1
0
文件: emp.php 项目: rdnjm/ici
        echo "\$(document).ready(function(){";
        echo "\$('#emp').dataTable({";
        echo "\"pagingType\": \"full_numbers\"";
        echo "})";
        echo "});";
        echo "</script>";
        echo "<link rel='stylesheet' type='text/css' href='css/jquery.dataTables.css'>";
        echo "<table class='table table-bordered table-hover' id='emp'>";
        echo "<thead>";
        echo "<tr>";
        echo "<th>Employee Number</th>";
        echo "<th>Last Name</th>";
        echo "<th>First Name</th>";
        echo "<th>Middle Name</th>";
        echo "</tr>";
        echo "</thead>";
        $query = "SELECT empNum, LastName, FirstName, MiddleName FROM employeemasterfile.employee" or die("Error. " . mysqli_error($link));
        $result = conString($query);
        echo "<tbody>";
        while ($rows = mysqli_fetch_array($result)) {
            echo "<tr>";
            echo "<td><a href='employeemanagement.php?view=true&empNum={$rows['0']}' title='Click for more info'>{$rows['0']}</a></td>";
            echo "<td><a href='employeemanagement.php?view=true&empNum={$rows['0']}' title='Click for more info'>{$rows['1']}</a></td>";
            echo "<td><a href='employeemanagement.php?view=true&empNum={$rows['0']}' title='Click for more info'>{$rows['2']}</a></td>";
            echo "<td><a href='employeemanagement.php?view=true&empNum={$rows['0']}' title='Click for more info'>{$rows['3']}</a></td>";
            echo "</tr>";
        }
        echo "</tbody>";
        echo "</table>";
    }
}
示例#2
0
文件: getTeamData.php 项目: rdnjm/ici
         echo "</td>";
         echo "</tr>";
     }
     echo "</table>";
     echo "<input type='hidden' value='" . $_GET['ot'] . "' name='num'>";
 } else {
     if ($type == 4) {
         if ($_SESSION['posCode'] == '0003') {
             $query = "SELECT utNum, empNum, dateIssued, dateAb, timeout, status, reason, remarks, deptapproval FROM utrequest WHERE utNum ='" . $_GET['ut'] . "';" or die(mysqli_error($link));
         } else {
             $query = "SELECT utNum, empNum, dateIssued, dateAb, timeout, status, reason, remarks, hrapproval FROM utrequest WHERE utNum ='" . $_GET['ut'] . "';" or die(mysqli_error($link));
         }
         $result = conString($query);
         $rows = mysqli_fetch_array($result);
         $name = "SELECT LastName, FirstName FROM employee WHERE empNum ='" . $rows[1] . "';" or die(mysqli_error($link));
         $res = conString($name);
         $name = mysqli_fetch_array($res);
         echo "<form action='func/processUT.php' method='POST'>";
         echo "<table class='table table-bordered table-hover'>";
         echo "<tr>";
         echo "<td>Undertime Number</td>";
         echo "<td>" . $rows[0] . "</td>";
         echo "</tr>";
         echo "<tr>";
         echo "<td>Name</td>";
         echo "<td>" . $name[0] . ", " . $name[1] . "</td>";
         echo "</tr>";
         $rows[2] = dateFormat($rows[2]);
         echo "<tr>";
         echo "<td>Date Issued</td>";
         echo "<td>" . $rows[2] . "</td>";
示例#3
0
文件: checkLogin.php 项目: rdnjm/ici
                            $query = "UPDATE employeelogs SET ut='" . $compMin . "', timeout='" . $time . "' WHERE employeeNumber='" . $empNum . "' AND workDate='" . $date . "';" or die(mysqli_error($link));
                            conString($query);
                        } else {
                            echo "<br>";
                            echo "Please Apply for an Undertime Request first before going out of the company's premises.";
                        }
                    } else {
                        if ($hour > 17) {
                            $query = "SELECT status, numhours FROM otrequest WHERE status='approved' AND dateOT ='" . $date . "' AND empNum='" . $empNum . "';" or die(mysqli_error($link));
                            $result = conString($query);
                            $rows = mysqli_num_rows($result);
                            if ($rows[0] != 0) {
                                $rows = mysqli_fetch_array($result);
                                $compHour = ($hour - 17) * 60;
                                $compMin = $min + $compHour;
                                $numhours *= 60;
                                if ($numhours <= $compMin) {
                                    $compMin = $numhours;
                                }
                                $query = "UPDATE employeelogs SET ot='" . $compMin . "', timeout='" . $time . "' WHERE employeeNumber='" . $empNum . "' AND workDate='" . $date . "';" or die(mysqli_error($link));
                                conString($query);
                            } else {
                                $query = "UPDATE employeelogs set timeout='" . $time . "' WHERE employeeNumber='" . $empNum . "' AND workDate='" . $date . "';" or die(mysqli_error($link));
                            }
                        }
                    }
                }
            }
        }
    }
}
示例#4
0
文件: functions.php 项目: rdnjm/ici
function getName()
{
    $query = "SELECT LastName, FirstName FROM employee WHERE empNum='" . $_SESSION['empNum'] . "';" or die(mysqli_error($link));
    $result = conString($query);
    $rows = mysqli_fetch_array($result);
    return $rows[0] . ", " . $rows[1];
}