/**
* 设置锁的过期时间
* @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;
}
