$date = strtotime($req_dt);
$sql .= " AND TO_DAYS(dtadded) = TO_DAYS(FROM_UNIXTIME('{$date}'))";
$paging->AddURLFilter("dt", $req_dt);
$display["dt"] = $req_dt;
}
else
$display["dt"] = date("m/d/Y");
//Paging
$paging->SetSQLQuery($sql);
$paging->AdditionalSQL = "ORDER BY dtadded DESC";
$paging->ApplyFilter($_POST["filter_q"], array("object"));
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl");
// Rows
$rows = $db->Execute($paging->SQL);
$added = array();
while ($row = $rows->FetchRow())
{
$row["type"] = ucfirst(strtolower($row["type"]));
$row["operation"] = ucfirst(strtolower($row["operation"]));
$display["rows"][] = $row;
}
}
require("src/append.inc.php");
$sql .= " AND ({$date_sql})";
$display["dfilter"] = true;
}
//
//Paging
//
$paging->SetSQLQuery($sql);
$paging->AdditionalSQL = "ORDER BY UNIX_TIMESTAMP(dtcreated) DESC";
$paging->ApplyFilter($_POST["filter_q"], array("description"));
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("client/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("client/inc/paging.tpl");
//
// Rows
//
foreach ((array)$db->GetAll($paging->SQL) as $k=>$row)
{
$display["rows"][$k] = $row;
$display["rows"][$k]["userinfo"] = $db->GetRow("SELECT * FROM users WHERE id='{$row['userid']}'");
$display["rows"][$k]["gatename"] = ucfirst($row["gate"]);
}
$display["dt"] = (!$_POST["dt"]) ? date("m/d/Y") : $_POST["dt"];
$display["dt2"] = (!$_POST["dt2"]) ? date("m/d/Y") : $_POST["dt2"];
$display["dfilter"] = ($_SESSION["dfilter"]) ? "i" : "";
