/** * Get counters for lists * * @access public * @param array $userId, User Uid * @return array * * @author Brayan Pereyra (Cochalo) <*****@*****.**> * @copyright Colosa - Bolivia */ public function getCounters($userId) { $criteria = new Criteria(); $criteria->addSelectColumn(UsersPeer::USR_TOTAL_INBOX); $criteria->addSelectColumn(UsersPeer::USR_TOTAL_DRAFT); $criteria->addSelectColumn(UsersPeer::USR_TOTAL_CANCELLED); $criteria->addSelectColumn(UsersPeer::USR_TOTAL_PARTICIPATED); $criteria->addSelectColumn(UsersPeer::USR_TOTAL_PAUSED); $criteria->addSelectColumn(UsersPeer::USR_TOTAL_COMPLETED); $criteria->add( UsersPeer::USR_UID, $userId, Criteria::EQUAL ); $dataset = UsersPeer::doSelectRS($criteria); $dataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $dataset->next(); $aRow = $dataset->getRow(); $oAppCache = new \AppCacheView(); $totalUnassigned = $oAppCache->getListCounters('selfservice', $userId, false); $response = array( array('count' => $aRow['USR_TOTAL_INBOX'], 'item' => 'CASES_INBOX'), array('count' => $aRow['USR_TOTAL_DRAFT'], 'item' => 'CASES_DRAFT'), array('count' => $aRow['USR_TOTAL_CANCELLED'], 'item' => 'CASES_CANCELLED'), array('count' => $aRow['USR_TOTAL_PARTICIPATED'], 'item' => 'CASES_SENT'), array('count' => $aRow['USR_TOTAL_PAUSED'], 'item' => 'CASES_PAUSED'), array('count' => $aRow['USR_TOTAL_COMPLETED'], 'item' => 'CASES_COMPLETED'), array('count' => $totalUnassigned, 'item' => 'CASES_SELFSERVICE') ); /*----------------------------------********---------------------------------*/ return $response; }