Example #1
0
 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));
 }
Example #2
0
 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'));
     }
 }
Example #3
0
 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));
 }