function getInbox() { $db = JFactory::getDbo(); $user = JFactory::getUser(); $query = "SELECT * FROM #__jblance_message" . " WHERE (idTo=" . $db->quote($user->id) . " OR idFrom=" . $db->quote($user->id) . ") AND parent=0 AND deleted=0" . " ORDER BY date_sent DESC"; $db->setQuery($query); $msgs = $db->loadObjectList(); //count total received new messages $newMsg = 0; foreach ($msgs as $msg) { $newMsg += JblanceHelper::countUnreadMsg($msg->id); } $query = "SELECT * FROM #__jblance_message" . " WHERE idFrom=" . $db->quote($user->id) . " AND parent=0 AND deleted=0" . " ORDER BY date_sent DESC"; $db->setQuery($query); $out_msgs = $db->loadObjectList(); //count total sent new messages $newOutMsg = 0; foreach ($out_msgs as $out_msg) { $newOutMsg += JblanceHelper::countUnreadMsg($out_msg->id); } $return[0] = $msgs; $return[1] = $out_msgs; $return[2] = $newMsg; $return[3] = $newOutMsg; return $return; }
</td></tr> <?php } $k = 0; for ($i = 0, $x = count($this->msgs); $i < $x; $i++) { $msg = $this->msgs[$i]; $userFrom = JFactory::getUser($msg->idFrom); $userTo = JFactory::getUser($msg->idTo); //if the current user is different, then show that name if ($user->id == $msg->idFrom) { $userInfo = JFactory::getUser($msg->idTo); } else { $userInfo = JFactory::getUser($msg->idFrom); } $link_read = JRoute::_('index.php?option=com_jblance&view=message&layout=read&id=' . $msg->id); $newMsg = JblanceHelper::countUnreadMsg($msg->id); ?> <tr id="jbl_feed_item_<?php echo $msg->id; ?> "> <td><a href="<?php echo $link_read; ?> "><?php echo $userInfo->{$nameOrUsername}; ?> </a></td> <td><a href="<?php echo $link_read; ?>
*/ // no direct access defined('_JEXEC') or die('Restricted access'); //JHtml::_('bootstrap.framework'); // $document = JFactory::getDocument(); $direction = $document->getDirection(); $config = JblanceHelper::getConfig(); $user = JFactory::getUser(); if ($config->loadBootstrap) { JHtml::_('bootstrap.loadCss', true, $direction); } $limit = $config->feedLimitDashboard; $notifys = JblanceHelper::getFeeds($limit, 'notify'); //get the notificataion feeds $newMsgs = JblanceHelper::countUnreadMsg(); $link_messages = JRoute::_('index.php?option=com_jblance&view=message&layout=inbox'); $link_home = ''; $link_logout = JRoute::_('index.php?option=com_users&task=user.logout&' . JSession::getFormToken() . '=1&return=' . base64_encode($link_home)); ?> <script type="text/javascript"> <!-- function showElement(layer) { var myLayer = document.getElementById(layer); if (myLayer.style.display == "none") { myLayer.style.display = "block"; myLayer.backgroundPosition = "top"; } else { myLayer.style.display = "none"; }