public function actionShoucang($id)
{
$model = new Shoucang();
$model->uid = Yii::app()->user->id;
$model->sixiangid = $id;
$model->shoucang_time = time();
$model->save(false);
Yii::app()->user->setFlash('shoucang', '感觉收藏成功 ^_^ ');
//完善一个我的收藏页面
$this->redirect(array('article/detail', 'id' => $id));
}
echo Yii::app()->createUrl('weiyu');
?>
">我的微语</a>
</li>
<li><a href=""><span><?php
echo $sl = Album::model()->countByAttributes(array('user_id' => Yii::app()->user->id));
?>
</span></a><a href="<?php
echo Yii::app()->createUrl('album/myalbum');
?>
">我的相册</a></li>
<li><a href="./index.php?r=user/fav">
<span>
<?php
$c1 = Picshoucang::model()->countByAttributes(array('pic_uid' => Yii::app()->user->id));
$c2 = Shoucang::model()->countByAttributes(array('uid' => Yii::app()->user->id));
$num = $c1 + $c2;
echo $num;
?>
</span></a>
<a href="./index.php?r=user/fav">我的收藏</a>
</li>
<!-- <li><a href=""><span>0</span></a><a href="">小集体</a></li> -->
<li><a href="" target="_blank"><span>1</span></a><a href="./index.php?r=quiet/index" target="_blank">找自己</a></li>
<!-- <li><a href=""><span>0</span></a><a href="">电影</a></li>
<li><a href=""><span>0</span></a><a href="">音乐</a></li>
<li><a href=""><span>0</span></a><a href="">读书</a></li> -->
</ul>
</div>
</div>
?>
次
</li>
<?php
if (!Yii::app()->user->getIsGuest()) {
?>
<li class="img">
<?php
//收藏与已经收藏判断,不能放在控制器中
$userid = Yii::app()->user->id;
$sxid = $model->id;
// 联合查询同时满足同一主键的数据，如果返回为NULL就是未收藏，否则一经收藏
$sql = "select * from {{shoucang}} where uid={$userid} and sixiangid={$sxid}";
$sc_sixiang = Shoucang::model()->findAllBySql($sql);
if ($sc_sixiang == NULL) {
?>
<a href="<?php
echo Yii::app()->createUrl('article/shoucang', array('id' => $model->id));
?>
"><div>收藏</div><img src="<?php
echo $model->img;
?>
"></a>
<?php
} else {
?>
<a><div>已收藏 ^_^</div><img src="<?php
echo $model->img;
?>
public function actionQuxiao($id)
{
$model = Shoucang::model()->findByPk($id);
if ($model->delete()) {
//添加成功时候的提示信息设置
/**
*setFlash getFlash hasFlash 几个方法
*/
Yii::app()->user->setFlash('quxiao', '取消收藏成功 -_-!');
}
$this->redirect('./index.php?r=user/fav');
}
/**
* This is invoked after the record is deleted.删除文章之后删除相应的内容
*/
protected function afterDelete()
{
parent::afterDelete();
Comment::model()->deleteAll('article_id=' . $this->id);
Shoucang::model()->deleteAll('sixiangid=' . $this->id);
//Tag::model()->updateFrequency($this->tags, '');
}
?>
</td>
<td><?php
echo $_v->click;
?>
</td>
<td><?php
//统计评论数量
$pl = $_v->id;
echo $count = Comment::model()->countByAttributes(array('article_id' => $_v->id));
?>
</td>
<td><?php
//统计被收藏的数量
$sx = $_v->id;
echo $count = Shoucang::model()->countByAttributes(array('sixiangid' => $_v->id));
?>
</td>
<td><?php
date_default_timezone_set('PRC');
//设置默认时区
echo date('Y-m-d H:i:s', $_v->create_time);
//时间戳转化date()
?>
</td>
<td class="fun_con mfun">
<a class="f_edit mtop" href="<?php
echo Yii::app()->createUrl('backend/article/update', array('id' => $_v->id));
?>
" target="_blank">编辑</a>
<a class="f_delete mtop" onclick="return confirm('你确定要删除《<?php
