Ejemplo n.º 1
0
 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;
     }
 }
Ejemplo n.º 2
0
 //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