/**
* This is the default 'index' action that is invoked
* when an action is not explicitly requested by users.
*/
public function actionIndex()
{
// renders the view file 'protected/views/site/index.php'
// using the default layout 'protected/views/layouts/main.php'
$visitor = new Visitor();
$visitor->ip_address = $this->getRealIp();
if ($visitor->save()) {
$this->render('index');
}
}
public static function create($name, $location, $message, $tinyUrl = null)
{
$visitor = new Visitor(null);
$visitor->setName($name);
$visitor->setLocation($location);
$visitor->setMessage($message);
$visitor->setTinyUrl($tinyUrl);
$visitor->setGeneratedId($visitor->generateId());
$visitor->setId($visitor->save());
return $visitor;
}
public function postRegister(Request $request)
{
//验证
$this->validate($request, ['username' => 'required|max:255|unique:visitors', 'password' => 'required|min:6', 'email' => 'required|email|max:255|unique:visitors']);
$visitor = new Visitor();
$visitor->username = $request->input('username');
$visitor->password = bcrypt($request->input('password'));
$visitor->email = $request->input('email');
$visitor->phone = $request->input('phone');
$visitor->save();
return redirect('auth/login');
//return redirect($this->redirectPath('auth/login'))->with($this->statusVar, Lang::get('auth.addUserSuccess'));
}
public function statistics()
{
$model = new Visitor();
$model->user_type = 0;
$model->user_id = Yii::app()->user->id;
$model->user_name = Yii::app()->user->name;
$model->server_time = new CDbExpression('NOW()');
$model->page_title = $this->pageTitle;
$model->page_link = Yii::app()->request->url;
$model->browser = Yii::app()->browser->getBrowser();
$model->visitor_ip = $_SERVER['REMOTE_ADDR'];
$model->save();
}
public function executeUpdate()
{
$member_code = $this->getRequestParameter('code');
$member = MemberPeer::retrieveByCode($member_code);
$dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo');
$now = date('dmY');
$time = date('Y/m/d h:i');
$i18n = new sfI18N();
$i18n->initialize($this->getContext());
$i18n->setCulture($this->getUser()->getCulture());
$action_i18n = $i18n->globalMessageFormat->format('save as new');
$action_type = $this->getRequestParameter('action_type');
if ($member->hasVisit()) {
//$pk = $member()->getVisitorId()->getId();
//$visitor = VisitorPeer::retrieveByPk($this->getRequestParameter('id'));
$member_id = $member->getId();
$visitor = VisitorPeer::retrieveByMember($member_id);
$this->forward404Unless($visitor);
//$c = new Criteria();
//$c->add(VisitorPeer::ID, $pk);
//$visitor = VisitorPeer::doSelectOne($c);
$visitor->setTimeOut($time);
$visitor->save();
return $this->redirect('default/index2');
} else {
$visitor = new Visitor();
$visitor->setId($this->getRequestParameter('id'));
$visitor->setMemberId($member->getId());
$visitor->setTimeIn($time);
$visitor->setDepartmentId($dept->getId());
$visitor->setCode($now);
$visitor->save();
return $this->redirect('default/index2');
}
}
/**
* Add the visitor who have read this blog
* @param int $id
*/
public function addArticleVisitorInfo($id, $interval)
{
$ip = UtilNet::getClientIp();
// echo $ip;
// $qq = new QQWry(long2ip($ip));
// echo $qq->getDetailInfo();
$visitorInfo = Visitor::model()->find('ip = :ip AND aid = :aid', array(':ip' => $ip, ':aid' => $id));
// UtilHelper::dump($visitorInfo->attributes);
if ($visitorInfo) {
$visitorInfo->lasttime = time();
$visitorInfo->times++;
$visitorInfo->alltime .= '|' . time();
$visitorInfo->intervals .= '|' . $interval;
if (!Yii::app()->user->isGuest) {
$visitorInfo->uid = Yii::app()->user->id;
}
UtilHelper::writeToFile($visitorInfo->attributes);
// Yii::app()->end();
try {
$visitorInfo->save();
} catch (Exception $e) {
UtilHelper::dump($e);
}
} else {
$visitorInfo = new Visitor();
$visitorInfo->aid = $id;
$visitorInfo->ip = $ip;
$visitorInfo->lasttime = time();
$visitorInfo->times = 1;
$visitorInfo->intervals = $interval;
if (!Yii::app()->user->isGuest) {
$visitorInfo->uid = Yii::app()->user->id;
}
$visitorInfo->alltime = time();
$visitorInfo->refer = $_SERVER['HTTP_REFERER'];
$visitorInfo->terminal = $_SERVER['HTTP_USER_AGENT'];
UtilHelper::writeToFile($visitorInfo->attributes);
// Yii::app()->end();
if ($visitorInfo->save()) {
// echo "OK";
} else {
// echo "Fail";
}
}
}
function add_visitor()
{
$visitor = new Visitor();
$visitor->url_id = $this->tbl->id;
$visitor->referrer = $_SERVER["HTTP_REFERER"];
$visitor->created_by = $this->get_ip();
$visitor->created_on = date('Y-m-d H:i:s');
$visitor->save();
}
public function actionHome($uid)
{
if (Yii::app()->user->isGuest) {
$this->redirect('./index.php?r=user/login');
}
$vhid = $uid;
$user = User::model()->findByPk($uid);
$user->visitor += 1;
$user->save(false);
if ($uid != Yii::app()->user->id) {
$visit = new Visitor();
$visit->uid = Yii::app()->user->id;
$visit->toid = $uid;
$visit->time = time();
$visit->save(false);
}
//活跃用户展示
$yaya = User::model()->findAll(array('order' => 'update_time desc', 'limit' => 16));
//思想展示
$sql = "select * from {{article}} where author_id = {$uid} order by create_time desc limit 0, 20 ";
$sixiang = Article::model()->findAllBySql($sql);
//标签展示
$sq = "select * from {{usertags}} where uid = {$uid} order by create_time desc";
$bq = Usertags::model()->findAllBySql($sq);
//home页面用户关注的丫丫数量
$uf = "select * from {{follow}} where uid={$uid}";
$userfollow = count(Follow::model()->findAllBySql($uf));
//home页面粉丝数量
$fan = "select * from {{follow}} where touid={$uid}";
$fans = count(Follow::model()->findAllBySql($fan));
//访问我的主页的用户展示
$userid = Yii::app()->user->id;
$cs1 = "select *,count(distinct uid) from {{visitor}} where toid={$userid} group by uid order by time desc limit 16";
$fangwenwo = Visitor::model()->findAllBySql($cs1);
$cs2 = "select *,count(distinct toid) from {{visitor}} where uid={$vhid} group by toid order by time desc limit 16";
$visitwho = Visitor::model()->findAllBySql($cs2);
$data = array('user' => $user, 'yaya' => $yaya, 'sixiang' => $sixiang, 'bq' => $bq, 'userfollow' => $userfollow, 'fans' => $fans, 'fangwenwo' => $fangwenwo, 'visitwho' => $visitwho);
$this->render('home', $data);
}
