public static function selectAll($inStatus, $inOwner, $inPerformer, $inMFrom, $inMTo, $inPFrom, $inPTo, $inRankFrom, $inRankTo)
{
global $connection;
$query = "SELECT Wishes.Status,\r\n\t\tWishes.WishID, \r\n\t\tWishes.OwnerID, \r\n\t\tUsers.FirstName, \r\n\t\tUsers.LastName, \r\n\t\tUsers.Rank, \r\n\t\tWishes.Description, \r\n\t\tWishes.PriceMoney, \r\n\t\tWishes.PricePoints, \r\n\t\tWishRating.PlusMinus \r\n\t\tFROM (Wishes \r\n\t\tJOIN Users ON Wishes.OwnerID=Users.UserID) \r\n\t\tLEFT JOIN WishRating ON WishRating.WishID = Wishes.WishID AND WishRating.UserID = {$_SESSION['UserID']}";
$conditions = array();
if (isset($inStatus)) {
if ($inStatus != '') {
$conditions[] = "Wishes.Status={$inStatus}";
}
}
if (isset($inOwner)) {
if ($inOwner != '') {
$conditions[] = "Wishes.OwnerID={$inOwner}";
}
}
if (isset($inPerformer)) {
if ($inPerformer != '') {
$conditions[] = "Wishes.PerformerID={$inPerformer}";
}
}
if (isset($inMFrom)) {
if ($inMFrom != '') {
$conditions[] = "Wishes.PriceMoney >={$inMFrom}";
}
}
if (isset($inMTo)) {
if ($inMTo != '') {
$conditions[] = "Wishes.PriceMoney <={$inMTo}";
}
}
if (isset($inPFrom)) {
if ($inPFrom != '') {
$conditions[] = "Wishes.PricePoints >={$inPFrom}";
}
}
if (isset($inPTo)) {
if ($inPTo != '') {
$conditions[] = "Wishes.PricePoints <={$inPTo}";
}
}
if (isset($inRFrom)) {
if ($inRFrom != '') {
$conditions[] = "Users.Rank >={$inRFrom}";
}
}
if (isset($inRTo)) {
if ($inRTo != '') {
$conditions[] = "Users.Rank <={$inRTo}";
}
}
if (count($conditions) > 0) {
$query .= " WHERE " . implode(' AND ', $conditions);
}
$query .= " ORDER BY Wishes.CreateTime LIMIT 0,20";
$result = $connection->select($query);
$resultArray = array();
while ($row = $result->fetch_assoc()) {
$resultArray[] = wishClass::create($row['WishID'], $row['Status'], $row['OwnerID'], $row['FirstName'], $row['LastName'], $row['Rank'], $row['Description'], $row['PriceMoney'], $row['PricePoints'], $row['PlusMinus']);
}
return $resultArray;
}
