public function run() { if ($sourcetype == '') { $sourcetype = 37; } $connection = yii::app()->db; $tracked_userid = Yii::app()->session['login']['id']; $Criteria = new CDbCriteria(); $Criteria->condition = "upload_sourceid = '" . $this->sourceid . "' AND tracked_userid ='" . $tracked_userid . "'and upload_sourcetype='" . $this->sourcetype . "' and view_status=0 and block_status=0"; $Criteria->order = "note_id DESC"; $note = Notess::model()->findAll($Criteria); foreach ($note as $notes) { $ids[] = $notes->tracker_userid; } $Criteria->join = 'join fn_users as t1 on t1.userid = t.tracker_userid '; $Criteria->join .= 'join fn_contentnote as t2 on t2.id = t.contentnote_id '; $Criteria->addInCondition('t.tracker_userid', $ids); //$Criteria->group = 't.tracker_userid'; $Criteria->select = "t.*,t1.fname,t2.name"; $note = Notess::model()->findAll($Criteria); $content_note = Contentnote::model()->findAll(); //echo $content_note->contentnote_id; //print_r($content_note); /*SELECT t.*,t1.fname FROM `fn_notes` as t join fn_users as t1 on t1.userid = t.tracker_userid WHERE t.`tracker_userid` in (616,115) group by t.`tracker_userid`*/ //echo count($note); $this->render('_note', array('type' => $this->widgettype, 'i' => $this->i, 'sourceid' => $this->sourceid, 'userid' => $this->userid, 'uname' => $this->uname, 'sourcetype' => $this->sourcetype, 'notek' => $note, 'result' => $content_note)); }
public function actionDeleteNote() { $val = $_POST['deletenote']; if (isset($_POST['delete_note'])) { $delid = Notess::model()->findByPk($val); if (isset($delid) && !empty($delid)) { $delid->delete(); } $this->redirect(array('/home')); } if (isset($_POST['block_note'])) { $val = $_POST['deletenote']; $delid = Notess::model()->findByPk($val); if (isset($delid) && !empty($delid)) { $delid->block_status = 1; $delid->save(); } $this->redirect(array('/home')); } }
public function actionNotifications() { $userid = Yii::app()->session['login']['id']; // old code /*$criteria = new CDbCriteria(); $criteria->join = " join fn_user_finao_tile t1 on t.tracked_tileid = t1.tile_id and t.tracker_userid = t1.userid "; $criteria->join .= " join fn_user_finao t2 on t1.finao_id = t2.user_finao_id and finao_activestatus = 1 and finao_status_Ispublic = 1 and Iscompleted = 0 "; $criteria->group = " t1.tile_id, t1.tile_name,t1.userid"; $criteria->condition = " t.tracked_userid = ".$userid." and t.status = 0"; $criteria->select = "t.*, t1.tile_name"; //print_r($criteria);exit; $tileform2 = Tracking::model()->findAll($criteria); $this->renderPartial('notifications',array('tiles'=>$tileform2,'userid'=>$userid));*/ //old code end $Criteria = new CDbCriteria(); $Criteria->condition = "tracked_userid = '" . $userid . "' AND status = '1' and view_status='0'"; $Criteria->order = "tracking_id desc"; $tileforms = Tracking::model()->findAll($Criteria); //$notes = Notess::model()->findByAttributes(array('tracker_userid'=>$userid,'view_status'=>0)); $notes = new CDbCriteria(); $notes->condition = "tracked_userid = '" . $userid . "' and view_status='0'"; $notes->order = "note_id desc"; $notes = Notess::model()->findAll($notes); //$tileforms= Tracking::model()->findAllByAttributes(array('tracked_userid'=>$userid ,'status'=>1)); //echo $tileforms[0]['tracking_id'];exit; $this->renderPartial('notifications', array('tiles' => $tileforms, 'userid' => $userid, 'notes' => $notes)); // print_r($tileform2);exit; //$this->renderPartial('notifications',array('tiles'=>$tileform2,'userid'=>$userid)); }