$circut_id = $_POST['circut_id'];
$remote_id = $_POST['remote_id'];
$ddns_text = $_POST['ddns_text'];
$ddns_fwd_name = $_POST['ddns_fwd_name'];
$ddns_client_fqdn = $_POST['ddns_client_fqdn'];
$ddns_rev_name = $_POST['ddns_rev_name'];
$search = $_POST['search'];
$startdate = $_POST['startdate'];
$enddate = $_POST['enddate'];
// perform search if not empty
if (!empty($_POST['SrchLeases'])) {
if (empty($search) && empty($startdate) && empty($enddate)) {
$error = $err->GenerateErrorLink("help/help.html", "#lease_search", $defined['error'], "Empty search fields, please enter an IP or Hostname to search or enter a start and end date for a list of leases between those dates", NULL, NULL);
} else {
// perform validation on search string(s)
if ($val->ValidateIPv4($search) !== -1 || $val->ValidateMACFormats($search) !== -1 || $val->ValidateHostname($search) !== -1 && $val->ValidateDate($startdate) !== -1 && $val->ValidateDate($enddate) !== -1) {
/* define our search query */
if ($group !== "admin") {
$having = " HAVING `group` = \"" . $group . "\"";
}
// search by dates
if (!empty($startdate) || !empty($enddate)) {
$dates = " `start` > \"" . $startdate . "\" AND `end` < \"" . $enddate . "\"";
}
// provide fields search
if (!empty($search)) {
$main = "`hostname` LIKE \"" . $search . "\" OR `hardware` LIKE \"" . $search . "\" OR `ip` LIKE \"" . $search . "\"";
}
// and apply the attributes
$query = "SELECT * FROM `conf_leases` WHERE {$main}{$dates}{$having} ORDER BY `hostname` ASC";
// process our query
