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); }