function datatable_admin_day($con, $Table_Process, $tablename, $exclude, $today)
{
$Table_Process = new Table_Process();
$table_exclude = explode(' ', $Table_Process->create_exclude_table_statement($con, $Table_Process));
$Table_list = $Table_Process->create_table_statement_exclude($con, $table_exclude);
$querytable = $con->query("select table_name from information_schema.tables where table_schema= DATABASE() {$Table_list};");
while ($row = $querytable->fetch(PDO::FETCH_ASSOC)) {
foreach ($row as $tablename) {
$querynull = "SELECT * FROM {$tablename} WHERE `Submitted` LIKE '{$today}%';";
$nullrc = $con->query($querynull);
$null = $nullrc->rowCount();
if ($null > 0) {
$stmt_list = $Table_Process->create_statement($con, $tablename, $exclude);
print "<table border='1'>";
$tablenameucfirst = $Table_Process->titlecase($tablename);
$prettytablename = str_replace('_', ' ', $tablenameucfirst);
print "<tr><th colspan=8>{$prettytablename}</th></tr>";
$query = "SELECT {$stmt_list} FROM {$tablename} WHERE `Submitted` LIKE '{$today}%';";
$result = $con->query($query);
$row = $result->fetch(PDO::FETCH_ASSOC);
print "<tr>";
foreach ($row as $field => $value) {
$fieldnameucfirst = $Table_Process->titlecase($field);
$prettyfieldname = str_replace('_', ' ', $fieldnameucfirst);
print "<th>{$prettyfieldname}</th>";
}
print "</tr>";
$data = $con->query($query);
if ($data->rowCount() > 0) {
$data->setFetchMode(PDO::FETCH_ASSOC);
foreach ($data as $row) {
print "<tr> \n";
foreach ($row as $name => $value) {
print "<td>{$value}</td>";
}
print "</tr>";
}
}
print "</table><br />";
}
}
}
}
function datatable_department_month($con, $Table_Process, $tablename, $exclude, $today)
{
$Table_Process = new Table_Process();
$table_exclude = explode(' ', $Table_Process->create_exclude_table_statement($con, $Table_Process));
$Table_list = $Table_Process->create_table_statement_exclude($con, $Table_Process, $table_exclude);
$querytable = $con->query("select table_name from information_schema.tables where table_schema= DATABASE() \r\n\r\n{$Table_list};");
while ($row = $querytable->fetch(PDO::FETCH_ASSOC)) {
foreach ($row as $tablename) {
$querynull = "SELECT * FROM {$tablename} WHERE `Submitted` LIKE '{$today}%';";
$nullrc = $con->query($querynull);
$null = $nullrc->rowCount();
if ($null > 0) {
$stmt_list = $Table_Process->create_statement($con, $Table_Process, $tablename, $exclude);
print "<table border='1'>";
$tablenameucfirst = $Table_Process->titlecase($tablename);
$prettytablename = str_replace('_', ' ', $tablenameucfirst);
print "<tr><th colspan=8>\r\n\r\n{$prettytablename}</th></tr>";
$query = "SELECT \r\n\r\n{$stmt_list} FROM {$tablename} WHERE `Submitted` LIKE '{$today}%';";
$result = $con->query($query);
$row = $result->fetch(PDO::FETCH_ASSOC);
print "<tr>";
foreach ($row as $field => $value) {
$fieldnameucfirst = $Table_Process->titlecase($field);
$prettyfieldname = str_replace('_', ' ', $fieldnameucfirst);
print "<th>{$prettyfieldname}</th>";
}
print "</tr>";
$data = $con->query($query);
if ($data->rowCount() > 0) {
$data->setFetchMode(PDO::FETCH_ASSOC);
foreach ($data as $row) {
print "<tr> \n";
foreach ($row as $name => $value) {
print "<td>";
print "{$value}";
print "</td>";
}
print "</tr>";
}
}
$existsquery = "SHOW COLUMNS FROM {$tablename} LIKE 'Total_Items'";
$existsrc = $con->query($existsquery);
$exists = $existsrc->rowCount();
if ($exists > 0) {
$itemsquery = "SELECT SUM(`Total_Items`) AS value_month FROM {$tablename} WHERE `Submitted` LIKE '{$today}%';";
$items = $con->query($itemsquery);
$items->setFetchMode(PDO::FETCH_ASSOC);
foreach ($items as $row) {
$itemsmonth = $row['value_month'];
print "<tr><td colspan=8><b>Total Items: " . $itemsmonth . "</td></tr>";
}
}
$texistsquery = "SHOW COLUMNS FROM {$tablename} LIKE 'Total_Time'";
$texistsrc = $con->query($texistsquery);
$texists = $texistsrc->rowCount();
if ($texists > 0) {
$totaltimequery = "SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( `Total_Time` ) ) ) AS value_month FROM {$tablename} WHERE `Submitted` LIKE '{$today}%';";
$totaltime = $con->query($totaltimequery);
$totaltime->setFetchMode(PDO::FETCH_ASSOC);
foreach ($totaltime as $row) {
$timemonth = $row['value_month'];
print "<tr><td colspan=8><b>Total Time: " . $timemonth . "</td></tr>";
}
}
print "</table><br />";
}
}
}
}
