/** * 更新给定日当天的访问数量 * @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); }
private function __construct($managerName = null) { $this->_managerName = $managerName; $this->_db = Watt_Db::getDb(); // 原为getDbx() 导致 Watt_db->_connection 访问出错,因此更改为getDb() }
/** * 设置锁的过期时间 * @param int $time * return int */ public function setExpireTime($time) { $sql = "UPDATE tpm_lock" . " SET life_time=" . $time . " WHERE lock_name='" . chks($this->lock_name) . "'"; return Watt_Db::getDb()->execute($sql); }
/** * 说明 * */ function GetAll($sql) { $jgsz = Watt_Db::getDb()->getAll($sql); //$jgsz = $this->db->GetAll($sql); /*$qusql = mysql_query($sql); if (!$qusql) { $this -> error .= '无法连接数据库<hr>'; return false; } else { while($jigu = @mysql_fetch_assoc($qusql)) { $jgsz[] = $jigu; } }*/ return $jgsz; }
private function _getCountWithSql() { return Watt_Db::getDb()->getOne($this->_getCountSql()); }
/** * 获取数据库所有表的记录数 * * @return unknown */ public static function getDbAllTableCount() { $re = array(); $sql = "show tables"; $dd = Watt_Db::getDb()->getAll($sql); if (is_array($dd) && count($dd)) { foreach ($dd as $k => $v) { $v_ = array_values($v); try { Watt_Db::getDb()->getAll("SHOW CREATE VIEW " . $v_[0]); } catch (Exception $e) { $sql = "select count(*) as count from " . $v_[0]; $dingdan_count = Watt_Db::getDb()->GetOne($sql); $re[$v_[0]] = $dingdan_count; } } } return $re; }
/** * 结束使用只读数据库 * * @author bobit * Mon Sep 24 16:37:49 CST 200716:37:49 */ public static function endUseReadonlyDb() { self::$_need_use_readonly_db = 0; Watt_Debug::addInfoToDefault('', 'Unset use READONLY DB server'); }
/** * 通过角色 Id 获得用户菜单 * 这个应该放到 角色的属性里 * * @param int $roleId * @return array|null */ public static function getRoleMenus($roleId) { $sql = "select menu_id,menu_parent_id,menu_name,menu_path,privilege_do \n from tpm_menu\n left join tpm_privilege using (privilege_id) \n left join tpm_role_privilege_rel using (privilege_id) \n where role_id = {$roleId} \n or tpm_menu.privilege_id = 0\n order by menu_path"; // $sql = "select * from tpm_test"; $arr_menu = Watt_Db::getDb()->getAll($sql); // var_dump( $arr_menu ); return $arr_menu; }