function CreateFilterSQL($filters, $nlimit = 0) { $multipleWheres = false; $sql = "SELECT "; $sql .= " ActiveWorkOrders.WID, Title, Receiver, Requestor, Project, Priority, DateNeedBy, Approved, Assigned, ApprovedByCap, Finished, Closed, Active, Revision"; $sql .= " FROM ActiveWorkOrders "; if (isset($filters["StudentAssigned"]) && $filters["StudentAssigned"] != "") { $sql .= " JOIN Assignments ON ActiveWorkOrders.WID = Assignments.WID "; $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= "Assignments.UserID = " . $filters["StudentAssigned"]; } if (isset($filters["Title"]) && $filters["Title"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= " Title = '" . $filters["Title"] . "'"; } if (isset($filters["Author"]) && $filters["Author"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= " AuthorID = " . $filters["Author"]; } if (isset($filters["Priority"]) && $filters["Priority"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= " Priority = '" . $filters["Priority"] . "'"; } if (isset($filters["DateCreatedStart"]) && isset($filters["DateCreatedEnd"]) && $filters["DateCreatedStart"] != "" && $filters["DateCreatedEnd"] != "" && $filters["DateCreatedStart"] <= $filters["DateCreatedEnd"]) { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= "(DateCreated BETWEEN '" . $filters["DateCreatedStart"] . "' AND '" . $filters["DateCreatedEnd"] . "')"; } if (isset($filters["DateNeededEnd"]) && isset($filters["DateNeededStart"]) && $filters["DateNeededStart"] != "" && $filters["DateNeededEnd"] != "" && $filters["DateNeededStart"] <= $filters["DateNeededEnd"]) { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= "(DateNeedBy BETWEEN '" . $filters["DateNeededStart"] . "' AND '" . $filters["DateNeededEnd"] . "')"; } if (isset($filters["RequestingTeam"]) && $filters["RequestingTeam"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= "Requestor = '" . $filters["RequestingTeam"] . "'"; } if (isset($filters["ReceivingTeam"]) && $filters["ReceivingTeam"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= "Receiver = '" . $filters["ReceivingTeam"] . "'"; } if (isset($filters["Project"]) && $filters["Project"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= "Project = '" . $filters["Project"] . "'"; } if (isset($filters["Assigned"]) && $filters["Assigned"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; if ($filters["Assigned"] == 0) { $sql .= " Assigned = 0 "; } else { if ($filters["Assigned"] == 1) { $sql .= " Assigned = 1 "; } } } if (isset($filters["Approved"]) && $filters["Approved"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; if ($filters["Approved"] == 0) { $sql .= " Approved = 0 "; } else { if ($filters["Approved"] == 1) { $sql .= " Approved = 1 "; } } } if (isset($filters["ApprovedByCap"]) && $filters["ApprovedByCap"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; if ($filters["ApprovedByCap"] == 0) { $sql .= " ApprovedByCap = 0 "; } else { if ($filters["ApprovedByCap"] == 1) { $sql .= " ApprovedByCap = 1 "; } } } if (isset($filters["Finished"]) && $filters["Finished"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; if ($filters["Finished"] == 0) { $sql .= " Finished = 0 "; } else { if ($filters["Finished"] == 1) { $sql .= " Finished = 1 "; } } } if (isset($filters["Closed"]) && $filters["Closed"] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; if ($filters["Closed"] == 0) { $sql .= " Closed = 0 "; } else { if ($filters["Closed"] == 1) { $sql .= " Closed = 1 "; } } } //Remove following because Active must be true in ActiveWorkOrders. //if(isset($filters["Active"]) && $filters["Active"]!="") //{ // $sql .= CheckMultipleWheres($multipleWheres); // $multipleWheres = true; // if($filters["Active"] == 0) $sql .= " Active = 0 "; // else if($filters["Active"]==1) $sql .= " Active = 1 "; //} if ($nlimit > 0) { $sql .= ' Limit ' . $nlimit; } $sql .= ";"; return $sql; }
$sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= 'AgeMax <= ' . $_POST['AgeMax']; } if (isset($_POST['MinUserRating']) && $_POST['MinUserRating'] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= 'MinUserRating >= ' . $_POST['MinUserRating']; } if (isset($_POST['Gender']) && $_POST['Gender'] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= "Gender = '" . $_POST['Gender'] . "'"; } if (isset($_POST['Gender']) && $_POST['Gender'] != "") { $sql .= CheckMultipleWheres($multipleWheres); $multipleWheres = true; $sql .= "Gender = '" . $_POST['Gender'] . "'"; } $sql .= ";"; print $sql; $result = SQLQuery($sql); $resultData = ""; if ($result != FALSE && $result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { $EventID = $row["EventID"]; $rsvpsql = 'SELECT * FROM EventRSVPs WHERE EventID = "' . $EventID . '"'; $RSVPResult = SQLQuery($rsvpsql); if ($RSVPResult->num_rows < $row["PlayerNumber"] || $_POST['OnlyNotFull'] != 'true') { $resultData .= '#,EventID::' . $row["EventID"];