function update_counts($table, $method_name, $condition) { global $db; $new = $db->query("SELECT DISTINCT supporter_KEY FROM " . $table . " WHERE " . $condition); if ($new->num_rows > 0) { while ($new_arr = $new->fetch_assoc()) { $supporter_info = $db->query("SELECT * FROM supporter WHERE supporter_KEY=" . $new_arr['supporter_KEY'])->fetch_assoc(); $supporter = new Supporter($supporter_info); $supporter->{$method_name}(); $supporter->db_update(); $supporter->data['key'] = $supporter->data['supporter_KEY']; //$dia->save('supporter', $supporter->data); } } }
#trigger_error(print_r($supporter_KEY,TRUE)); $sql = "SELECT * FROM supporter WHERE supporter_KEY=" . $supporter_KEY; $S = $db->Execute($sql) or die($db->errorMsg() . $sql); $s = $S->GetAssoc(); $x = 0; foreach ($s as $supporter_arr) { $supporter = new Supporter($supporter_arr); #$supporter->process_data_augmentation(); # $supporter->geovalidate(); if ($supporter_arr['source_processed'] != 1) { $supporter->process_source(); } $supporter->updateDonationCounts(); $supporter->updateActionCounts(); $supporter->updateEmailCounts(); $supporter->updateUnsubscribeInfo(); $supporter->updateSupporterTypes(); #update local $supporter->db_update(); #save to salsa $data = $supporter->data; $data['key'] = $supporter_arr['supporter_KEY']; unset($data['organization_KEY']); #$out = $DIA->save('supporter',$data); # echo '<pre>'; # print_r($data); # echo '</pre>'; $x++; echo 'completed' . ' '; }