public function fetchAll() { $resultSet = $this->getDbTable()->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_Blog(); $entry->setId($row->id)->setUsername($row->user_name)->setDescription($row->description)->setTitle($row->title)->setDateCreated($row->date_created); $entries[] = $entry; } return $entries; }
public function developersAction() { $getblogs = new Application_Model_Blog($this->registry['DB']); $userid = array('abdulnizam', 's.mohamedmeeran'); $from = $this->getRequest()->getParam('from'); if (empty($from) && !(is_int($from) || ctype_digit($from))) { $from = 0; } $this->view->blogs = $getblogs->getdeveloperBlogs($userid, $from); $this->view->mydetails = $this->authIdentity; $string = md5('freniz'); if ($this->_request->isXmlHttpRequest() && $this->getRequest()->getParam('format') == 'xml' || $this->getRequest()->getParam('Accesscode') == $string) { $this->_helper->viewRenderer->renderScript('blog/blog.ajax.phtml'); } }
public static function listBlogs() { /*************************************************************** * Fetch an array with all the blogs in it. */ $blogs = Application_Model_Blog::getBlogList(); return $blogs; }
public function testShowAction() { //Grab a blog file to test with, any old random one. $blogs = Application_Model_Blog::getBlogList(); if (sizeof($blogs) < 0) { return; } $params = array('action' => 'show', 'controller' => 'Blog', 'module' => 'default', 'id' => $blogs[0]['file']); $url = $this->url($this->urlizeOptions($params)); $this->dispatch($url); // assertions $this->assertModule($params['module']); $this->assertController($params['controller']); $this->assertAction($params['action']); $this->assertQueryContentContains('div#header-logo h1', 'WebAce'); }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 3-Nov-2010 * @Description : Count number of post for a particular category with permission check * @Input : int - category id * @Return : Int - number of post */ public function countCategoryPosts($category_id) { //create database object $db = Zend_Registry::get('db'); $db->setFetchMode(Zend_Db::FETCH_OBJ); $total_blogs = 0; $sql = "SELECT b.id, b.user_id, b.status FROM blog AS b"; $sql .= " JOIN journal AS j ON j.id = b.journal_id"; //$sql .= " WHERE b.status = 5 AND b.publish = 'published'"; $sql .= " WHERE b.publish = 'published'"; $sql .= " AND j.status = 'public' AND j.publish = 'published'"; $sql .= " AND b.category_id={$category_id}"; $blogs = $db->fetchAll($sql); if (count($blogs) > 0) { $userNs = new Zend_Session_Namespace('members'); $loggedin_id = $userNs->userId; foreach ($blogs as $blog) { $view_my_journal = false; $blogM = new Application_Model_Blog(); $view_my_journal = $blogM->checkBlogPrivacySettings($blog->user_id, $loggedin_id, $blog->status); if ($view_my_journal) { $total_blogs = $total_blogs + 1; } } } return $total_blogs; }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 4-Nov-2010 * @Description: Display more post on "View More" link from User Journals section */ public function viewMorejournalsAction() { $this->view->layout()->disableLayout(); $username = $this->_getParam('username'); $user = $this->getLeftPanel($username); $this->view->userObject = $user; $userNs = new Zend_Session_Namespace('members'); $this->view->userId = $userNs->userId; /*------------------------- Set paging START------------------------*/ $settings = new Admin_Model_GlobalSettings(); $page_size = $settings->settingValue('journal_page_size'); //$page_size = 1; $page = $this->_getParam("page"); $offset = ($page - 1) * $page_size; /*------------------------- Set paging END------------------------*/ $where = "user_id='{$userNs->userId}'"; $blogm = new Application_Model_Blog(); $whereCond = "user_id='{$user->getId()}' AND status='public' AND publish='published'"; //$whereCond = "user_id='{$user->getId()}'"; $data = $blogm->fetchAll($whereCond, "addedon DESC", $page_size, $offset); $this->view->data = $data; if (count($data) == 0) { $this->_helper->viewRenderer->setNoRender(true); exit("nodata"); } }
public function getStreams($userids, $criteria = null, $maxId = 0, $minId = 0, $activitylist = null) { if (isset($this->authIdentity) && $this->authIdentity->type == 'user') { if (round((time() - $this->authIdentity->latime) / 60) > 25) { $this->authIdentity->latime = time(); $this->_db->update('user_info', array('latime' => new Zend_Db_Expr('now()')), array('userid=?' => $this->authIdentity->userid)); } /*$as=new Zend_Session_Namespace('activity'); if(!isset($as->activity_upper)){ $as->activity_upper=0; } if(!isset($as->activity_lower)){ $as->activity_lower=0; } if(!isset($as->activitylist)){ $as->activitylist=array(); } if(isset($reset) && $reset==1){ $as->activity_upper=0; $as->activity_lower=0; $as->activitylist=array(); } //return array(); */ if (empty($userids)) { $userids = array_merge($this->authIdentity->friends, array_keys($this->authIdentity->school), array_keys($this->authIdentity->college), array_keys($this->authIdentity->employer), $this->authIdentity->musics, $this->authIdentity->movies, $this->authIdentity->books, $this->authIdentity->celebrities, $this->authIdentity->games, $this->authIdentity->sports, $this->authIdentity->other); } else { $userids = explode(',', $userids); } $sub_sql = $this->_db->select()->from('activity as t', array('t.activityid', 't.userid', 't.ruserid', 't.contentid', 't.title', 't.contenttype', 't.contenturl', 't.alternate_contentid'))->joinLeft('activity as r', "t.alternate_contentid=r.alternate_contentid and r.userid in (" . $this->_db->quote($userids) . ") and t.activityid < r.activityid", '')->where("t.ruserid!='{$this->authIdentity->userid}' and t.userid in (?)", $userids); $sql = $this->_db->select()->from('activity as p', array('p.activityid', 'p.userid', 'p.ruserid', 'p.contentid', 'p.title', 'p.contenttype', 'p.contenturl', 'p.alternate_contentid', 'p.date'))->joinLeft(array('q' => new Zend_Db_Expr('(' . $sub_sql . ')')), 'q.alternate_contentid=p.alternate_contentid and p.activityid < q.activityid', '')->joinLeft('friends_vote', 'p.userid=friends_vote.userid', 'friendlist as sfriends')->where('q.activityid is null and p.ruserid!=?', $this->authIdentity->userid); if (isset($criteria)) { if ($criteria == 'higher' && !empty($maxId)) { $sql = $sql->where('p.activityid > ?', $maxId); } else { if ($criteria == 'lower' && !empty($minId)) { $sql = $sql->where('p.activityid < ?', $minId); } } if (!empty($activitylist)) { $activitylist = explode(',', $activitylist); $sql = $sql->where('p.alternate_contentid not in (?)', $activitylist); } } $sql = $sql->where('p.userid in (?)', $userids); $sql = $sql->order('p.date desc')->limit(20); $results = $this->_db->fetchAssoc($sql); $activity_mapper = array(); $posts = array(); $activity_users = array(); $activity_results = array(); $userignore = array(); $db_expr = new Zend_Db_Expr('date_sub(now(),interval 5 day)'); /*if(count($results)>=1){ $as->activity_lower=min(array_keys($results)); $as->activity_higher=max(array_keys($results)); }*/ foreach ($results as $activityid => $values) { //array_push($as->activitylist, $values['alternate_contentid']); array_push($activity_users, $values['userid']); array_push($activity_users, $values['ruserid']); if ($values['contenttype'] == 'post') { $activity_mapper['posts'][$activityid] = $values['contentid']; } else { if ($values['contenttype'] == 'stature') { $activity_mapper['statures'][$activityid] = $values['contentid']; } else { if ($values['contenttype'] == 'blog') { $activity_mapper['blogs'][$activityid] = $values['contentid']; } else { if ($values['contenttype'] == 'admire') { $activity_mapper['admires'][$activityid] = $values['contentid']; } else { if ($values['contenttype'] == 'image') { $activity_mapper['images'][$activityid] = $values['contentid']; } else { if ($values['contenttype'] == 'video') { $activity_mapper['videos'][$activityid] = $values['contentid']; } else { if ($values['contenttype'] == 'forum') { $activity_mapper['forums'][$activityid] = $values['contentid']; } else { if ($values['contenttype'] == 'user') { if (!in_array($values['ruserid'], $this->authIdentity->friends) && !in_array($this->authIdentity->userid, $userignore) && !in_array($values['userid'], $userignore)) { array_push($userignore, $values['userid']); array_push($userignore, $values['ruserid']); $activity_mapper['users'][$activityid]['recendusers'] = array($values['ruserid']); if ($values['contentid'] > 0) { $suserfriends = unserialize($values['sfriends']); $activity_results['user'][$activityid]['recendusers'] = array_slice($suserfriends, -($values['contentid'] + 1)); foreach ($activity_results['user'][$activityid]['recendusers'] as $user) { array_push($activity_users, $user); } } else { $activity_results['user'][$activityid]['recendusers'] = array(); } } else { $activity_results['user'][$activityid]['recendusers'] = array(); } } else { if ($values['contenttype'] == 'propic') { //$activity_mapper['propics'][$activityid]=$values['contentid']; $friends = array_diff($this->authIdentity->friends, array($values['userid'])); if (!empty($friends)) { $sql = $this->select()->from('activity', array('activityid', 'userid'))->where('userid in(?) and contenttype=\'propic\' and alternate_contentid=\'propic\'', $friends)->where('date > ?', $db_expr); $propic_results = $this->fetchAll($sql)->toArray(); if (!empty($propic_results)) { $activity_results['propic'][$activityid]['recendusers'] = $propic_results; foreach ($propic_results as $user) { array_push($activity_users, $user); } } else { $activity_results['propic'][$activityid]['recendusers'] = array(); } } else { $activity_results['propic'][$activityid]['recendusers'] = array(); } } else { if ($values['contenttype'] == 'basic info') { $friends = array_diff($this->authIdentity->friends, array($values['userid'])); if (!empty($friends)) { $sql = $this->select()->from('activity', array('activityid', 'userid'))->where('userid in(?) and contenttype=\'basic info\' and alternate_contentid=\'basicinfo\'', $friends)->where('date > ?', $db_expr); $propic_results = $this->fetchAll($sql)->toArray(); if (!empty($propic_results)) { $activity_results['basic info'][$activityid]['recendusers'] = $propic_results; foreach ($propic_results as $user) { array_push($activity_users, $user); } } else { $activity_results['basic info'][$activityid]['recendusers'] = array(); } } else { $activity_results['basic info'][$activityid]['recendusers'] = array(); } } else { if ($values['contenttype'] == 'personal info') { $friends = array_diff($this->authIdentity->friends, array($values['userid'])); if (!empty($friends)) { $sql = $this->select()->from('activity', array('activityid', 'userid'))->where('userid in(?) and contenttype=\'personal info\' and alternate_contentid=\'personalinfo\'', $friends)->where('date > ?', $db_expr); $propic_results = $this->fetchAll($sql)->toArray(); if (!empty($propic_results)) { $activity_results['personal info'][$activityid]['recendusers'] = $propic_results; foreach ($propic_results as $user) { array_push($activity_users, $user); } } else { $activity_results['personal info'][$activityid]['recendusers'] = array(); } } else { $activity_results['personal info'][$activityid]['recendusers'] = array(); } } else { if ($values['contenttype'] == 'mood') { $friends = array_diff($this->authIdentity->friends, array($values['userid'])); if (!empty($friends)) { $sql = $this->_db->select()->from('activity', array('activityid', 'userid'))->joinLeft('user_info', 'user_info.userid=activity.userid', 'mood')->where('activity.userid in(?) and contenttype=\'mood\' and alternate_contentid=\'mood\'', $friends)->where('activity.date > ?', $db_expr); $propic_results = $this->_db->fetchAll($sql); if (!empty($propic_results)) { $activity_results['mood'][$activityid]['recendusers'] = $propic_results; foreach ($propic_results as $user) { array_push($activity_users, $user); } } else { $activity_results['mood'][$activityid]['recendusers'] = array(); } } else { $activity_results['mood'][$activityid]['recendusers'] = array(); } } else { if ($values['contenttype'] == 'education info') { $friends = array_diff($this->authIdentity->friends, array($values['userid'])); if (!empty($friends)) { $sql = $this->select()->from('activity', array('activityid', 'userid'))->where('userid in(?) and contenttype=\'education info\' and alternate_contentid=\'edcationinfo\'', $friends)->where('date > ?', $db_expr); $propic_results = $this->fetchAll($sql)->toArray(); if (!empty($propic_results)) { $activity_results['education info'][$activityid]['recendusers'] = $propic_results; foreach ($propic_results as $user) { array_push($activity_users, $user); } } else { $activity_results['education info'][$activityid]['recendusers'] = array(); } } else { $activity_results['education info'][$activityid]['recendusers'] = array(); } } } } } } } } } } } } } } } if (!empty($activity_mapper['posts'])) { $posts = new Application_Model_Post($this->_db); $activity_results['post'] = $posts->getPosts($activity_mapper['posts']); } if (!empty($activity_mapper['statures'])) { $posts = new Application_Model_Stature($this->_db); $activity_results['stature'] = $posts->getStatures($activity_mapper['statures']); } if (!empty($activity_mapper['blogs'])) { $blogs = new Application_Model_Blog($this->_db); $activity_results['blog'] = $blogs->getBlogsArray($activity_mapper['blogs']); } if (!empty($activity_mapper['admires'])) { $admires = new Application_Model_Admiration($this->_db); $activity_results['admire'] = $admires->getAdmirationArray($activity_mapper['admires']); } if (!empty($activity_mapper['images'])) { $images = new Application_Model_Images($this->_db); $activity_results['image'] = $images->getArrayOfImages($activity_mapper['images']); } if (!empty($activity_mapper['videos'])) { $videos = new Application_Model_Videos($this->_db); $activity_results['video'] = $videos->getVideos($activity_mapper['videos']); } if (!empty($activity_mapper['forums'])) { $forums = new Application_Model_forum($this->_db); $activity_results['forum'] = $forums->getTopics($activity_mapper['forums']); } $activity_users = array_unique($activity_users); if (!empty($activity_users)) { $sql = $this->_db->select()->from('freniz', array('userid', 'username', 'user_type' => 'type', 'user_url' => 'url'))->joinLeft('user_info', 'user_info.userid=freniz.userid', array('sex', 'mood'))->joinLeft('image as user_image', 'user_info.propic=user_image.imageid', 'url as user_imageurl')->joinLeft('pages', 'pages.pageid=freniz.userid', '')->joinLeft('image as page_image', 'pages.pagepic=page_image.imageid', 'url as page_imageurl')->where('freniz.userid in (?)', $activity_users); $activity_users_minipro = $this->_db->fetchAssoc($sql); } else { $activity_users_minipro = array(); } $final_results['activity'] = $results; $final_results['results'] = $activity_results; $final_results['users'] = $activity_users_minipro; $sql = $this->_db->select()->from('commentactivity', 'max(id) as maxcomment'); $result = $this->_db->fetchRow($sql); $final_results['maxcomment'] = $result['maxcomment']; return $final_results; } }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 27-Jan-2011 * @Description : Report Journal/Wall and other items as abuse to admin */ public function reportAbuseAction() { $this->view->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); //get request parameters $item_id = $this->_getParam('item_id'); $item_type = $this->_getParam('item_type'); //get logged in user ID $usersNs = new Zend_Session_Namespace('members'); $user_id = $usersNs->userId; if ($user_id == "" || $user_id == 0) { $JsonResultArray = array('error' => 1, 'response' => "Please login to report abuse."); echo Zend_Json::encode($JsonResultArray); exit; } if ($item_id == "" || $item_id == 0) { $JsonResultArray = array('error' => 2, 'response' => "No item is selected to report abuse."); echo Zend_Json::encode($JsonResultArray); exit; } if ($item_type == "") { $JsonResultArray = array('error' => 2, 'response' => "No item type is selected to report abuse."); echo Zend_Json::encode($JsonResultArray); exit; } //Get user report abuse info for item $modelM = new Application_Model_ReportAbuse(); $modelRes = $modelM->fetchRow("item_id={$item_id} AND item_type='{$item_type}' AND user_id={$user_id}"); if ($modelRes && $modelRes->getStatus() == 1) { $JsonResultArray = array('error' => 2, 'response' => "You've already reported this as abuse."); echo Zend_Json::encode($JsonResultArray); exit; } else { $params["itemId"] = $item_id; $params["itemType"] = $item_type; $params["userId"] = $user_id; $params["comment"] = ""; $params["status"] = 1; $modelM->setOptions($params); $dbRes = $modelM->save(); if ($dbRes) { //get item type information $itemTitle = ""; $authorId = ""; $author = ""; if ($item_type == 'blog') { $blogM = new Application_Model_Blog(); $blogRes = $blogM->find($item_id); $itemTitle = $blogRes->getTitle(); $authorId = $blogRes->getUserId(); $blog_url = Zend_Registry::get('siteurl') . "/journal/view-post/blog_id/" . $item_id; $itemTitle = "<a href='" . $blog_url . "' target='_blank'>" . $itemTitle . "</a>"; } else { if ($item_type == 'wall') { $wallM = new Application_Model_Wall(); $wallRes = $wallM->find($item_id); $itemTitle = $wallRes->getStatus(); $authorId = $wallRes->getUserId(); } else { if ($item_type == 'photo') { $objModelAlbumPhoto = new Album_Model_AlbumPhoto(); $albumPhotoRes = $objModelAlbumPhoto->find($item_id); $itemTitle = $albumPhotoRes->getName(); $authorId = $albumPhotoRes->getUserId(); } } } //get Blog/Wall owner/author user information if ($authorId != "") { $useAuthor = new Application_Model_User(); $authorRes = $useAuthor->find($authorId); $author = ucfirst($authorRes->getFirstName()) . " " . ucfirst($authorRes->getLastName()) . " (" . $authorRes->getUsername() . ")"; } //get user information who is reporting abuse item $userM = new Application_Model_User(); $userR = $userM->find($user_id); $reporterName = ucfirst($userR->getFirstName()) . " " . ucfirst($userR->getLastName()) . " (" . $userR->getUsername() . ")"; $reporterEmail = $userR->getEmail(); //Now send report abuse email to Administrator $settings = new Admin_Model_GlobalSettings(); $admin_email = $settings->settingValue('report_abuse'); //$admin_email = "*****@*****.**"; $mailOptions['receiver_email'] = $admin_email; $mailOptions['item_type'] = ucfirst($item_type); $mailOptions['item_title'] = $itemTitle; $mailOptions['item_author'] = $author; $mailOptions['reporter_name'] = $reporterName; $mailOptions['reporter_email'] = $reporterEmail; //create mail class object and send the email $Mail = new Base_Mail(); $Mail->sendReportAbuseEmail($mailOptions); //send response $JsonResultArray = array('error' => 3, 'response' => "Consider it reported!"); } else { $JsonResultArray = array('error' => 2, 'response' => "Error occured, please try again later."); } } echo Zend_Json::encode($JsonResultArray); exit; }
public function deleteblogAction() { if ($this->auth->hasIdentity()) { $deleteblog = new Application_Model_Blog($this->registry['DB']); $blogid = $this->getRequest()->getParam('blogid'); $this->view->results = $deleteblog->deleteBlog($blogid); } }
public function deleteAction() { $id = $this->_getParam('id'); $model = new Application_Model_Blog(); //$model->delete("id={$id}"); //added by Mahipal Adhikari on 5-jan-2011, move Blogs to deleted table before deleting permanently $model->deleteBlog($id); //$tag = new Application_Model_BlogTag(); //$tag->delete("blog_id={$id}"); $_SESSION['errorMsg'] = "Journal post has been deleted!"; return $this->_helper->redirector('index', 'journals', "admin"); }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 1-Nov-2010 * @Description: Used to edit blog post information */ public function editBlogAction() { $request = $this->getRequest(); $form = new Application_Form_Blog(); $form->removeElement("weight"); //get blog information for edit $blog_id = $this->_getParam('id'); //$blog_id = base64_decode($blog_id); if (isset($blog_id)) { $objBlog = new Application_Model_Blog(); $blog = $objBlog->find($blog_id); //get blog tags $tag = new Application_Model_Tags(); $tags = $blog->getTags(); $tags = $tag->getTagsForEdit($blog_id); $blog_info["title"] = $blog->getTitle(); $blog_info["status"] = $blog->getStatus(); $blog_info["categoryId"] = $blog->getCategoryId(); $blog_info["location"] = $blog->getLocation(); $blog_info["tags"] = $tags; $blog_info["content"] = $blog->getContent(); $blog_info["comment"] = $blog->getComment(); $blog_info["publish"] = $blog->getPublish(); $blog_info["weight"] = $blog->getWeight(); $form->populate($blog_info); } $elements = $form->getElements(); $form->clearDecorators(); foreach ($elements as $element) { $element->removeDecorator('label'); } if ($this->getRequest()->isPost()) { $params = $request->getParams(); if ($form->isValid($params)) { $userNs = new Zend_Session_Namespace('members'); $journalM = new Application_Model_Journal(); $journal = $journalM->fetchRow("user_id='{$userNs->userId}'"); if (false !== $journal) { $params['userId'] = $userNs->userId; $params['journalId'] = $journal->getId(); $params['featured'] = $blog->getFeatured(); $params['weight'] = $blog->getWeight(); //$params['id'] = $blog_id; $blogM = new Application_Model_Blog($params); $blog = $blogM->save(); if ($blog && $blog_id != "") { //now first delete tags $albumTagM = new Application_Model_BlogTag(); //$objBlogTag = new Application_Model_BlogTag(); $albumTagM->delete("blog_id = {$blog_id}"); //insert/update blog tags if ($params['tags'] != "") { $arrTags = explode(",", $params['tags']); foreach ($arrTags as $_tag) { $_tag = trim($_tag); $tagsM = new Application_Model_Tags(); $tag = $tagsM->fetchRow("tag='{$_tag}'"); if (false === $tag) { $tagsM->setTag($_tag); $tag_id = $tagsM->save(); } else { $tag_id = $tag->getId(); } //$albumTagM=new Application_Model_BlogTag(); $albumTagM->setBlogId($blog_id); $albumTagM->setTagId($tag_id); $albumTagM->save(); } //end of foreach } //end of if /*----------tags-------*/ $_SESSION["flash_msg"] = "Journal post has been updated successfully."; $form->reset(); } else { $_SESSION["flash_msg"] = "Failed to update journal post. Please try again later."; } } else { $_SESSION["flash_msg"] = "Failed to update journal post because you have removed your journal."; } //redirect user //$this->_redirect('/journal/my-journals/'); $this->_redirect($this->view->seoUrl('/journal/my-journals/')); } //end of if } //end of if $this->view->form = $form; }
public function userLikeThisAction() { $this->_helper->layout->setLayout('journal-layout-2column'); //$item_id = $this->_getParam("blog_id"); $item_id = $this->_getParam("item_id"); $item_type = $this->_getParam("type"); //$userNs = new Zend_Session_Namespace('members'); //$this->view->userId = $userNs->userId; $item = false; $itemTypeText = ""; if ($item_type != "") { if ($item_type == 'blog') { $blogM = new Application_Model_Blog(); $this->view->blog = $item = $blogM->find($item_id); $itemTypeText = "Journal Post"; } if ($item_type == 'status_comment' || $item_type == 'blog_comment') { $commentM = new Application_Model_Comment(); $item = $commentM->find($item_id); $itemTypeText = "Comment"; $item_type = "comment"; } if ($item_type == 'status') { $wallM = new Application_Model_Wall(); $item = $wallM->find($item_id); $itemTypeText = "Wall Post"; } $this->view->itemTypeText = $itemTypeText; } //if item is not exists then redirect to Journal home page if (false === $item) { $this->_helper->redirector()->gotoUrl('/journal/index/'); exit; } //Now get all positive votes of item //$where = "item_id = $item_id AND vote=1 AND item_type='blog'"; $where = "item_id = {$item_id} AND vote=1"; if ($item_type == 'comment') { $where .= " AND (item_type='status_comment' OR item_type='blog_comment')"; } else { $where .= " AND item_type='{$item_type}'"; } $voteM = new Application_Model_Vote(); $rawdata = $voteM->fetchAll($where); //Get all users ID voted on an item if (false !== $rawdata) { $user_array = array(); foreach ($rawdata as $row) { $user_array[] = $row->getUserId(); } } //get all users information from above User Ids $this->view->totalUsers = 0; if (count($user_array) > 0) { $usrstr = implode(",", $user_array); $userM = new Application_Model_User(); $whereuser = "******"; $userData = $userM->fetchAll($whereuser, "first_name ASC"); $this->view->userData = $userData; $settings = new Admin_Model_GlobalSettings(); $page_size = $settings->settingValue('pagination_size'); //$page_size = 1; $page = $this->_getParam('page', 1); $pageObj = new Base_Paginator(); $paginator = $pageObj->fetchPageData($userM, $page, $page_size, $whereuser); $this->view->totalUsers = $pageObj->getTotalCount(); $this->view->paginator = $paginator; } }
private function setModel($row) { $user = $row->findParentRow('Application_Model_DbTable_User', 'User'); $model = new Application_Model_Blog(); $model->setId($row->id)->setTitle($row->title)->setStatus($row->status)->setWeight($row->weight)->setCategoryId($row->category_id)->setLocation($row->location)->setTags($row->tags)->setContent($row->content)->setComment($row->comment)->setPublish($row->publish)->setJournalId($row->journal_id)->setFeatured($row->featured)->setUserId($row->user_id)->setAddedon($row->addedon)->setUpdatedon($row->updatedon)->setUserObj($user); return $model; }