function testCountActionsPastYear() { $s = new Supporter(array('supporter_KEY' => 55)); $actions = array(array('supporter_KEY' => 55, 'action_KEY' => '123', 'Date_Created' => date('Y-m-d H:i:s', strtotime('-7 months'))), array('supporter_KEY' => 55, 'action_KEY' => '456', 'Date_Created' => date('Y-m-d H:i:s', strtotime('-9 months'))), array('supporter_KEY' => 55, 'action_KEY' => 'DuplicateKey', 'Date_Created' => date('Y-m-d H:i:s', strtotime('-13 months'))), array('supporter_KEY' => 55, 'action_KEY' => 'DuplicateKey', 'Date_Created' => date('Y-m-d H:i:s', strtotime('-18 months'))), array('supporter_KEY' => 56, 'action_KEY' => 'DuplicateKey', 'Date_Created' => date('Y-m-d H:i:s', strtotime('-7 months')))); foreach ($actions as $action_data) { $a = new SupporterAction($action_data); $a->db_insert(); } $s->updateActionCounts(); $this->assertEqual($s->data['data__action_count_past_year'], 2); }
function mark_supporter_action_new() { global $DB, $dia; if ($this->data['source_type_category'] == "Action" && $this->data['source_key']) { $row = $DB->query("SELECT * FROM supporter_action WHERE action_KEY=" . $this->data['source_key'] . " AND supporter_KEY=" . $this->data['supporter_key'] . " ORDER BY Date_Created ASC LIMIT 1"); if ($row->num_rows > 0) { $supporter_action = new SupporterAction($row->fetch_assoc); $supporter_action->data['new_supporter'] = "1"; $supporter_action->db_update(); $supporter_action->data['key'] = $supporter_action->data['supporter_action_KEY']; // $dia->save('supporter_action', $supporter_action->data); } } }