public static function is_watch_list_eligible($pet_wk, $watch_list_wk)
{
global $session;
global $database;
$pet = Pet::find_by_id($pet_wk);
$watch_list_detail = Watch_List_Detail::find_by_sql("SELECT * FROM `watch_list_detail` WHERE `watch_list_wk` = " . $watch_list_wk . ";");
//echo '<pre>' . var_export($watch_list_detail, true) . '</pre>'; //debug
//generate the dynamic MySQL statement
$sql = "SELECT `p`.* FROM `pet` AS `p` ";
$sql .= "INNER JOIN `breed` AS `b` ON `b`.`breed_wk` = `p`.`breed_wk` ";
$sql .= "INNER JOIN `pet_type` AS `pt` ON `pt`.`pet_type_wk` = `b`.`pet_type_wk` ";
$sql .= "WHERE `p`.`is_deleted` = 0 AND `p`.`pet_wk` = " . $pet_wk . " ";
//loop through each criteria, determine if it's eligible
foreach ($watch_list_detail as $item) {
//if one of the min or max fields
if (in_array($item->column_name, array('age_min', 'age_max', 'weight_min', 'weight_max'))) {
if ($item->column_name == 'age_min') {
$sql .= "AND `age` >= " . $item->value . " ";
} else {
if ($item->column_name == 'age_max') {
$sql .= "AND `age` <= " . $item->value . " ";
} else {
if ($item->column_name == 'weight_min') {
$sql .= "AND `weight` >= " . $item->value . " ";
} else {
if ($item->column_name == 'weight_max') {
$sql .= "AND `weight` <= " . $item->value . " ";
}
}
}
}
} else {
//not one of the min or max fields
$sql .= "AND " . ($item->column_name == 'pet_type' ? '`pt`' : '`p`') . ".`" . $item->column_name . "_wk` = " . $item->value . " ";
}
}
$sql .= ";";
$result = Pet::find_by_sql($sql);
//if the count of animals returned is 1, return true
//else, return false
if (count($result) == 1) {
return true;
} else {
return false;
}
}
//first thing's first, make the watch list entry
$new_watch_list = new Watch_List();
$new_watch_list->name = $_POST['name'];
$new_watch_list->user_wk = $user->user_wk;
if (!$new_watch_list->save()) {
$session->message("There was an issue, please try again.");
redirect_head(current_url());
}
$new_watch_list->watch_list_wk = $database->insert_id();
foreach ($_POST as $key => $value) {
//skip the submit field and name field
if ($key != 'submit' && $key != 'name') {
if (!empty($value)) {
//only process if the value is not empty
//instantiate the new object
$new_value = new Watch_List_Detail();
//set it the watch list key
$new_value->watch_list_wk = $new_watch_list->watch_list_wk;
//set it the column name
$new_value->column_name = $key;
if (is_array($value)) {
//the value we're processing is an array
//loop through the array of values
foreach ($value as $items) {
//set the value
$new_value->value = $items;
//save it
$new_value->save();
}
} else {
//the value we're processing is not an array
