/** * 设置锁的过期时间 * @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); }
/** * 记录日志 * * @param string $msg 记录的信息 * @param int $level * @param string $sourceName * @param string $actorName * @param string $actorId * @param mix $exts * @return boolean */ public function log($msg, $level = 0, $sourceName = "", $actorName = "", $actorId = "", $exts = null, $extsInt = null) { $rev = false; $datetime = date("Y-m-d H:i:s"); $timestamp = time(); $ip = $_SERVER['REMOTE_ADDR']; if (Watt_Session::getSession()) { //如果是岗位用户 那么还用原来的用户ID 2007-10-24 john if (@$_SESSION["shanggang"]) { $yh_id = $_SESSION["old_user_id"]; $yhs = TpmYonghuPeer::retrieveByPK($yh_id); $user_id = $yhs->getYhId(); $user_name = $yhs->getYhZhanghu(); $c = new Criteria(); $c->add(TpmYonghu2juesePeer::YH_ID, $yh_id); $jsids = TpmYonghu2juesePeer::doSelectOne($c); if ($jsids) { $js_id = $jsids->getJsId(); $c = new Criteria(); $c->add(TpmJuesePeer::JS_ID, $js_id); $jueses = TpmJuesePeer::doSelectOne($c); if ($jueses) { $user_js_id = $jueses->getJsId(); $user_js_mingcheng = $jueses->getJsMingcheng(); } } } else { $user_id = Watt_Session::getSession()->getUserId(); $user_name = Watt_Session::getSession()->getUserName(); $user_js_id = Watt_Session::getSession()->getRoleId(); $user_js_mingcheng = Watt_Session::getSession()->getRoleName(); } /*$session_id = Watt_Session::getSession()->getUserId(); $session_name = Watt_Session::getSession()->getUserName(); $js_id = Watt_Session::getSession()->getRoleId(); $js_mingcheng = Watt_Session::getSession()->getRoleName(); */ $session_id = $user_id; $session_name = $user_name ? $user_name : $actorName; $js_id = $user_js_id; $js_mingcheng = $user_js_mingcheng; } else { $session_id = ''; $session_name = $actorName; $js_id = ''; $js_mingcheng = ''; } $app = App::getApp(); $app->_add($this->_logName, array('yh_id' => $session_id, 'yh_zhanghu' => chks($session_name), 'js_id' => $js_id, 'js_mingcheng' => chks($js_mingcheng), 'rz_level' => $level, 'rz_ip' => $ip, 'rz_type' => chks($sourceName), 'rz_ruanjian' => chks($_SERVER["HTTP_USER_AGENT"]), 'rz_laiyuan' => isset($_SERVER["HTTP_REFERER"]) ? chks($_SERVER["HTTP_REFERER"]) : null, 'rz_neirong' => chks($msg), 'rz_dizhi' => chks($_SERVER['REQUEST_URI']), 'rz_qita_vchar' => chks($exts), 'rz_qita_int' => chks($extsInt), 'created_at' => $timestamp)); /* $log = new TpmRizhi(); $log->setYhId( $session_id ); //用户名 $log->setYhZhanghu( $session_name ); $log->setRzLevel( $level ); $log->setRzIp( $ip ); $log->setRzRuanjian( $_SERVER["HTTP_USER_AGENT"] ); $log->setRzType( $sourceName ); //即日志的逻辑标示 if( isset( $_SERVER["HTTP_REFERER"] ) ){ $log->setRzLaiyuan( $_SERVER["HTTP_REFERER"] ); } $log->setRzNeirong( $msg ); $log->setRzDizhi($_SERVER['REQUEST_URI']); $log->setRzQitaVchar( $exts ); $log->setCreatedAt( $timestamp ); $rev = $log->save();*/ /* rz_id yh_id yh_zhanghu rz_level rz_ip rz_type rz_ruanjian rz_laiyuan rz_neirong rz_dizhi rz_qita_vchar rz_qita_int created_at */ return $rev; }
public static function getDataByPk($tableName, $pkName, $pk) { $sql = "select * from " . $tableName . " where " . $pkName . "='" . chks($pk) . "'"; $db = Pft_Dbx::getDbx(); return $db->getRow($sql); }
private function _createSqlFromCriterion(Criterion $aCriterion) { //var_dump( $aCriterion ); //$this->_hidden_criterion->getTable() // echo $aCriterion->getColumn(); // echo $aCriterion->getValue(); // echo $aCriterion->getComparison(); // var_dump( $aCriterion->getAllTables() ); // var_dump( $aCriterion->getAttachedCriterion() ); // var_dump( $aCriterion->getTable() ); $table = $aCriterion->getTable() ? $aCriterion->getTable() . '.' : ''; $value = $aCriterion->getValue(); if (is_array($value)) { foreach ($value as $key => $val) { $value[$key] = "'" . chks($val) . "'"; } if (count($value)) { $value = '(' . implode(',', $value) . ')'; } else { $value = '( NULL )'; } } else { if (!is_null($value) && !is_numeric($value)) { $value = "'" . chks($value) . "'"; } } if (is_null($value)) { if (self::EQUAL == $aCriterion->getComparison() || self::ISNULL == $aCriterion->getComparison() || self::IN == $aCriterion->getComparison()) { $partWhere = trim($table . $aCriterion->getColumn(), '.') . " IS NULL"; } else { $partWhere = trim($table . $aCriterion->getColumn(), '.') . " IS NOT NULL"; } } else { $partWhere = trim($table . $aCriterion->getColumn(), '.') . $aCriterion->getComparison() . $value; } $clauses = $aCriterion->getClauses(); if (is_array($clauses) && count($clauses)) { $conjunctions = $aCriterion->getConjunctions(); for ($i = 0; $i < count($clauses); $i++) { $partWhere = '(' . $partWhere . ')' . $conjunctions[$i] . $this->_createSqlFromCriterion($clauses[$i]); } } return $partWhere; }