public function getmyheroesdata($userid, $share) { $criteria = new CDbCriteria(); $criteria->join = ' Join fn_user_finao t1 ON t.finao_id = t1.user_finao_id '; $criteria->join .= ' JOIN fn_users t2 ON t.updateby = t2.userid'; $criteria->join .= ' JOIN fn_lookups t3 ON t.notification_action = t3.lookup_id AND t3.lookup_type = "notificationaction"'; $criteria->join .= ' JOIN fn_lookups t4 ON t1.finao_status = t4.lookup_id AND t4.lookup_type = "finaostatus" '; $criteria->join .= ' JOIN fn_user_finao_tile t5 ON t1.user_finao_id = t5.finao_id '; $criteria->order .= 't.updateddate desc'; $criteria->group = ' t.tile_id, t.finao_id ,round(UNIX_TIMESTAMP(t.updateddate) / 600) desc'; $criteria->condition = ' t.tracker_userid = ' . $userid . ' and t1.finao_status_Ispublic = 1 and t1.finao_activestatus = 1'; $criteria->select = 't.*, t1.finao_msg, t4.lookup_name as finaostatus, t1.updateddate as finaoupdateddate, t2.fname, t2.lname, t3.lookup_name, t5.tile_id '; $trackingppl = Trackingnotifications::model()->findAll($criteria); $users = $this->getfollowersdetails($userid, -1, 0, 0); $ids = ""; foreach ($trackingppl as $tppl) { $ids .= $tppl->finao_id . ","; } $ids = substr($ids, 0, strlen($ids) - 1); $uploadinfo = ""; if ($ids != "") { $sourcetypeid = Lookups::model()->findByAttributes(array('lookup_type' => 'uploadsourcetype', 'lookup_status' => 1, 'lookup_name' => 'finao')); $uploadinfo = $this->getlatestuploaddetails($ids, $sourcetypeid->lookup_id); } return array('trackingppl' => $trackingppl, 'uploadinfo' => $uploadinfo, 'users' => $users); }