Example #1
0
 /**
  * 更新给定日当天的访问数量
  * @author bobbing
  * @version 0.1.0
  *  2008-5-16
  * $riqi  格式应如下20080516 
  * date('Ymd',time()-86400)
  * 取前一天的ymd格式
  */
 public static function jilucishu($riqi)
 {
     $file_name = "../log/" . 'processTime' . $riqi . ".log";
     $fp = fopen($file_name, 'r');
     $fwriqi = strtotime($riqi);
     $fwtongji = array();
     while (!feof($fp)) {
         $buffer = fgets($fp, 4096);
         //echo $buffer."<br>";
         $linshi = explode('|', $buffer);
         $userid = trim(str_replace('uid:', '', $linshi[7]));
         if ($userid == '') {
         } else {
             if (array_key_exists($userid, $fwtongji)) {
                 $fwtongji[$userid] = $fwtongji[$userid] + 1;
             } else {
                 $fwtongji[$userid] = 1;
             }
         }
     }
     foreach ($fwtongji as $key => $val) {
         $sql = "select count(id) from tpm_fwcishu where yh_id = '" . $key . "' and fw_riqi = " . $fwriqi;
         if (Watt_Db::getDb()->getOne($sql) <= 0) {
             $sql = "insert into tpm_fwcishu (yh_id,fw_cishu,fw_riqi,yh_zhanghu) values ('" . $key . "','" . $val . "'," . $fwriqi . ",'" . TpmYonghuPeer::getYhZhanghuByYhId($key) . "')";
             Watt_Db::getDb()->execute($sql);
         } else {
             $sql = "update tpm_fwcishu set fw_cishu = '" . $val . "' where yh_id = '" . $key . "' and fw_riqi = " . $fwriqi;
             Watt_Db::getDb()->execute($sql);
         }
     }
     fclose($fp);
 }