function getUserProperties() { $result = array(); $mainframe =& JFactory::getApplication(); $params =& ComJea::getParams(); $access =& ComJea::getAccess(); $default_limit = $params->get('list_limit', 10); $cat = $mainframe->getUserStateFromRequest('com_jea.user.properties.cat', 'cat', -1, 'int'); $limit = $mainframe->getUserStateFromRequest('com_jea.user.limit', 'limit', $default_limit, 'int'); $limitstart = JRequest::getInt('limitstart', 0); $order = $this->_db->getEscaped(JRequest::getCmd('filter_order', 'ordering')); $order_dir = $this->_db->getEscaped(JRequest::getCmd('filter_order_Dir', 'asc')); $rows = array(); if ($access->canEdit || $access->canEditOwn) { $select = $this->_getSqlBaseSelect(); $where = ''; if ($access->canEditOwn) { $user =& JFactory::getUser(); $where = ' WHERE tp.created_by=' . intval($user->get('id')); } if ($cat >= 0) { if (!empty($where)) { $where .= ' AND is_renting=' . $cat; } else { $where .= ' WHERE is_renting=' . $cat; } } $sql = $select . $where . ' ORDER BY ' . $order . ' ' . strtoupper($order_dir); //echo $sql; $rows = $this->_getList($sql, $limitstart, $limit); if ($this->_db->getErrorNum()) { JError::raiseWarning(200, $this->_db->getErrorMsg()); return false; } } $result['limitstart'] = $limitstart; $result['limit'] = $limit; $result['total'] = $this->_getListCount($sql); $result['rows'] = $rows; $result['order'] = $order; $result['order_dir'] = $order_dir; $result['cat'] = $cat; return $result; }
function deleteimg() { $access =& ComJea::getAccess(); if ($access->canEdit || $access->canEditOwn) { require_once JPATH_COMPONENT_ADMINISTRATOR . DS . 'models' . DS . 'properties.php'; $model = new JeaModelProperties(); $id = JRequest::getInt('id', 0); $Itemid = JRequest::getInt('Itemid', 0); $model->delete_img(); $this->setRedirect('index.php?option=com_jea&view=manage&' . 'layout=form&id=' . $id . '&Itemid=' . $Itemid); } }
function getUserProperties() { $result = array(); $mainframe =& JFactory::getApplication(); $params =& ComJea::getParams(); $access =& ComJea::getAccess(); $default_limit = $params->get('list_limit', 10); $user =& JFactory::getUser(); $userid = $user->get('id'); $usergid = $user->get('gid'); $cat = $mainframe->getUserStateFromRequest('com_jea.user.properties.cat', 'cat', -1, 'int'); $limit = $mainframe->getUserStateFromRequest('com_jea.user.limit', 'limit', $default_limit, 'int'); $keyserch = @JRequest::getVar(keyserch); //kiem tra xem co dieu kien serch moi khong? $limitstart = JRequest::getInt('limitstart', 0); if (@JRequest::getVar(cat) || @JRequest::getVar(published) || @JRequest::getVar(type_id) || @JRequest::getVar(keyserch)) { $limitstart = 0; } $order = $this->_db->getEscaped(JRequest::getCmd('filter_order', 'id')); $order = 'id'; $order_dir = $this->_db->getEscaped(JRequest::getCmd('filter_order_Dir', 'desc')); $types = $mainframe->getUserStateFromRequest('com_jea.user.properties.types', 'type_id', 0, 'int'); $published = $mainframe->getUserStateFromRequest('com_jea.user.properties.published', 'published', -1, 'int'); $rows = array(); //echo "type ne $types"; if ($access->canEdit || $access->canEditOwn) { $select = $this->_getSqlBaseSelect(); $where = ''; if ($access->canEditOwn) { $user =& JFactory::getUser(); $where = ' WHERE tp.created_by=' . intval($user->get('id')); } if ($cat >= 0) { if (!empty($where)) { $where .= ' AND kind_id=' . $cat; } else { $where .= ' WHERE kind_id=' . $cat; } } if ($types) { if (!empty($where)) { $where .= ' AND type_id=' . $types; } else { $where .= ' WHERE type_id=' . $types; } } if ($published != -1) { if (!empty($where)) { $where .= ' AND tp.published=' . $published; } else { $where .= ' WHERE tp.published=' . $published; } } /* hoan: nếu là admin thì sẽ hiện all else chỉ hiện của nó */ if ($usergid <= 24) { if (!empty($where)) { $where .= ' AND tp.created_by = ' . $userid; } else { $where .= ' WHERE tp.created_by =' . $userid; } } if ($keyserch != "") { if (!empty($where)) { $where .= " AND tp.ref LIKE '%{$keyserch}%'"; } else { $where .= " WHERE tp.ref LIKE '%{$keyserch}%'"; } } $sql = $select . $where . ' ORDER BY ' . $order . ' ' . strtoupper($order_dir); //echo $where; $rows = $this->_getList($sql, $limitstart, $limit); if ($this->_db->getErrorNum()) { JError::raiseWarning(200, $this->_db->getErrorMsg()); return false; } } $result['limitstart'] = $limitstart; $result['limit'] = $limit; $result['total'] = $this->_getListCount($sql); $result['rows'] = $rows; $result['order'] = $order; $result['order_dir'] = $order_dir; $result['cat'] = $cat; $result['type_id'] = $types; $result['published'] = $published; return $result; }