<?php require '../../boot.php'; list($cmd, $supporter_KEY) = $argv; #$supporter_KEY = 48965489; $supporter_query = $db->query("SELECT * FROM supporter WHERE supporter_KEY=" . $supporter_KEY); if ($supporter_query->num_rows > 0) { while ($supporter_arr = $supporter_query->fetch_assoc()) { $supporter = new Supporter($supporter_arr); $supporter->process(); #$supporter->geovalidate(); $supporter->updateDonationCounts(); $supporter->updateActionCounts(); $supporter->updateEmailCounts(); $supporter->updateUnsubscribeInfo(); $supporter->updateSupporterTypes(); //$supporter->db_update(); $supporter->data['key'] = $supporter->data['supporter_KEY']; //$dia->save('supporter', $supporter->data); } } echo '<pre>' . print_r($supporter) . '</pre>';
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); }