public function actionRemoveMemberObjectActionFavorite()
{
if (empty(Yii::app()->session['member']->mem_id)) {
Yii::app()->session['last_url'] = Yii::app()->createUrl('site/userfavoritelist');
echo CJSON::encode(array('status' => false, 'message' => 'กรุณา Login เข้าระบบก่อน', 'url' => Yii::app()->createUrl('site/login')));
} else {
$status = false;
if (!empty($_GET)) {
$id = $_GET['id'];
$value = $_GET['value'];
$member = Yii::app()->session['member'];
$memberObjectAction = MemberObjectAction::model()->findByAttributes(array('obj_id' => $id, 'mem_id' => $member->mem_id));
if (!$memberObjectAction) {
$memberObjectAction = new MemberObjectAction();
$memberObjectAction->mem_id = $member->mem_id;
$memberObjectAction->obj_id = $id;
$memberObjectAction->act_updatedate = new CDbExpression('NOW()');
}
$memberObjectAction->act_favorite = $value;
$status = $memberObjectAction->save(false);
echo CJSON::encode(array('status' => $status, 'action' => $memberObjectAction, 'message' => '', 'url' => ''));
}
}
}
public function actionDetail($id)
{
$criteria = new CDbCriteria();
$criteria->select = 'o.*,m.*';
$criteria->alias = 'o';
$criteria->join = 'LEFT JOIN member m ON m.mem_id = o.mem_id';
$criteria->condition = 'o.obj_id = ' . $id;
$sacredObject = SacredObject::model()->find($criteria);
$this->data['sacredObject'] = $sacredObject;
$params = array();
if (!empty($sacredObject->mem_id)) {
$params = array('mem_id' => $sacredObject->mem_id);
}
$listSacredObjectRelate = SacredObject::model()->findAllByAttributes($params);
$this->data['listSacredObjectRelate'] = $listSacredObjectRelate;
$listSacredObjectImg = SacredObjectImg::model()->findAllByAttributes(array('obj_id' => $id));
$this->data['listSacredObjectImg'] = $listSacredObjectImg;
$memberObjectAction = MemberObjectAction::model()->findByAttributes(array('obj_id' => $id, 'mem_id' => $this->member->mem_id));
if (empty($memberObjectAction)) {
$memberObjectAction = new MemberObjectAction();
}
$this->data['objectAction'] = $memberObjectAction;
//$listQuestionAction = WbQuestion::model()->findAll();
$listQuestion = Yii::app()->db->createCommand()->select('q.*,m.*')->from('wb_question q')->join('member m', 'm.mem_id = q.mem_id')->where('q.obj_id =:objId', array(':objId' => $id))->order('q.ques_updatedate desc')->queryAll();
//echo CJSON::encode($listQuestionAction);
//exit();
$this->data['listCommentQuestion'] = $listQuestion;
$this->metaDescription = $sacredObject->obj_name . ',' . $sacredObject->obj_price . ',' . $sacredObject->obj_status_desc . ',' . $sacredObject->obj_comment;
$this->metaKeywords = $sacredObject->obj_name . ',' . $sacredObject->obj_price . ',' . $sacredObject->obj_status_desc . ',' . $sacredObject->obj_comment;
$this->render('detail-sacred', $this->data);
}
