function execute($requests) { $u = $GLOBALS['KTAI_C_MEMBER_ID']; // あしあとリスト $this->set("c_ashiato_list", db_ashiato_c_ashiato_list4c_member_id($u, 20)); // 総あしあと数 $this->set("c_ashiato_num", db_ashiato_c_ashiato_num4c_member_id($u)); return 'success'; }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); $this->set('inc_navi', fetch_inc_navi("h")); $c_member = db_member_c_member4c_member_id($u); $this->set('c_member', $c_member); // あしあとリスト $this->set("c_ashiato_list", db_ashiato_c_ashiato_list4c_member_id($u, 30)); // 総あしあと数 $this->set("c_ashiato_num", db_ashiato_c_ashiato_num4c_member_id($u)); return 'success'; }
function p_h_ashiato_c_ashiato_list4c_member_id($c_member_id_to, $count) { return db_ashiato_c_ashiato_list4c_member_id($c_member_id_to, $count); }
/** * Update c_member `ashiato_count_log` and delete c_ashiato rows * * @param int $limit */ function db_ashiato_update_log($limit = 30) { $sql = 'SELECT c_member_id FROM c_member'; $c_member_id_list = db_get_col($sql); foreach ($c_member_id_list as $c_member_id) { $disp = db_ashiato_c_ashiato_list4c_member_id($c_member_id, $limit); if (!$disp) { continue; } $oldest_row = array_pop($disp); $yesterday = date('Y-m-d 00:00:00', strtotime('-1 day')); $cutline = min($oldest_row['r_datetime'], $yesterday); // delete c_ashiato rows $sql = 'DELETE FROM c_ashiato WHERE c_member_id_to = ? AND r_datetime < ?'; $params = array(intval($c_member_id), $cutline); db_query($sql, $params); $affected_rows = db_affected_rows(); // update c_member `ashiato_count_log` if ($affected_rows > 0) { $sql = 'UPDATE c_member SET ashiato_count_log = ashiato_count_log + ?' . ' WHERE c_member_id = ?'; $params = array(intval($affected_rows), intval($c_member_id)); db_query($sql, $params); } } }