提交者: 商 云方
新增日期: 2009-12-26 20:58:13
解决方案：
写个函数进行统计更新:
CREATE FUNCTION cron_trackerItem_count() RETURNS integer AS 
'DECLARE 
   var_item_total int;
   var_open_count int; 
   rec record;
BEGIN 
    
  FOR rec IN (select tracker_id from tracker) LOOP
   
    select count(1) into var_item_total from tracker_item where tracker_id =
rec.tracker_id;
    select count(1) into var_open_count from tracker_item where tracker_id =
rec.tracker_id and status_id =1;
    update tracker set item_total = var_item_total,open_count=var_open_count
where tracker_id = rec.tracker_id;

  END LOOP;
 
  return 0; 

END; ' LANGUAGE plpgsql


在pending_tasks_email.php 加一句：
		//recount open item for every tracker
		$sql = "select * from cron_trackeritem_count()"
		$rs = $stmt->executeQuery($sql, ResultSet::FETCHMODE_NUM);
这样就会每天运行一次，重新统计Open的Item了。