/** * Get record by user id and discount id * * @param $uid * @param $did * @return mixed */ public function getRecord($uid, $did) { // get database $db = JFactory::getDBo(); $query = $db->getQuery(true); $query->select('*')->from($this->name)->where(array('user_id=' . (int) $uid, 'discount_id=' . (int) $did))->limit(1); $db->setQuery($query); return $db->loadObject(); }
/** * Get subscription by order and item * * @param int Order * @param int Item * * @return mixed */ public function getRelatedSubscription($order_id, $item_id) { $db = JFactory::getDBo(); $query = $db->getQuery(true); $query->select('*')->from($this->name)->where(array('order_id=' . (int) $order_id, 'item_id=' . (int) $item_id)); $db->setQuery($query, 0, 1); $subscription = $db->loadObject($this->class, 'id'); return $subscription; }
/** * Get email template by it's type * * @param string * @param language * * @return mixed */ public function getByType($type, $language = null) { $db = JFactory::getDBo(); $conditions = array("`type`='" . $db->escape($type) . "'"); if (!empty($language)) { $conditions[] = '`language`=' . $db->quote($language); } $query = $db->getQuery(true); $query->select('*')->from($this->name)->where($conditions); $db->setQuery($query, 0, 1); return $db->loadObjectList(); }
/** * Count addresses, related to current user: */ public function countOwn() { $count = 0; $user = $this->app->user->get(); if ($user->id) { $db = JFactory::getDBo(); $query = $db->getQuery(true); $query->select("COUNT(id)")->from($this->name)->where(array("user_id=" . (int) $user->id)); $db->setQuery($query); $count = (int) $db->loadResult(); } return $count; }
/** * Increase used field of the chosen discount * * @param $id */ public function hit($id) { $db = JFactory::getDBo(); $query = $db->getQuery(true); $query->update($this->name)->set(array('`used`=`used`+1'))->where(array('`id`=' . (int) $id)); $db->setQuery($query); $db->execute(); $discount = $this->get($id); if ($discount->hits_per_user) { $hitrow = $this->app->table->user_discount->getRecord($this->app->user->get()->id, $id); if (empty($hitrow)) { $hitrow = new stdClass(); $hitrow->user_id = (int) $this->app->user->get()->id; $hitrow->discount_id = (int) $id; $hitrow->hits = 0; } $hitrow->hits += 1; $this->app->table->user_discount->save($hitrow); } }
/** * * Get parameters from backend, prepare and execute the database queries, * and fill an array for later output in template * @param $params * @param $debugmode boolean true to output the database query and the * database error text if existent */ public static function getList(&$params, &$debugmode) { // Array for storing the e.g. results and db query clauses $elems = array(); // Retreive parameters and fill the array // Get parameters for images and fill array element $elems['allpics'] = new stdClass(); $elems['allpics']->enabled = intval($params->get('all_pics', false)); if ($elems['allpics']->enabled) { $elems['allpics']->outputtext = $params->get('all_picstext', ''); $elems['allpics']->queryselect = 'COUNT(id)'; $elems['allpics']->queryfrom = '#__joomgallery'; } // Get parameters for categories and fill array element $elems['allcats'] = new stdClass(); $elems['allcats']->enabled = intval($params->get('all_cats')); if ($elems['allcats']->enabled) { $elems['allcats']->outputtext = $params->get('all_catstext'); $elems['allcats']->queryselect = 'COUNT(cid)'; $elems['allcats']->queryfrom = '#__joomgallery_catg'; } // Get parameters for hits and fill array element $elems['allhits'] = new stdClass(); $elems['allhits']->enabled = intval($params->get('all_hits', false)); if ($elems['allhits']->enabled) { $elems['allhits']->outputtext = $params->get('all_hitstext', ''); $elems['allhits']->queryselect = 'sum(hits)'; $elems['allhits']->queryfrom = '#__joomgallery'; } // Get parameters for comments and fill array element $elems['allcomments'] = new stdClass(); $elems['allcomments']->enabled = intval($params->get('all_comments'), false); if ($elems['allcomments']->enabled) { $elems['allcomments']->outputtext = $params->get('all_commentstext', ''); $elems['allcomments']->queryselect = 'COUNT(cmtid)'; $elems['allcomments']->queryfrom = '#__joomgallery_comments'; } // Get parameters for votes and fill array element $elems['allvotes'] = new stdClass(); $elems['allvotes']->enabled = intval($params->get('all_votes', false)); if ($elems['allvotes']->enabled) { $elems['allvotes']->outputtext = $params->get('all_votestext', ''); $elems['allvotes']->queryselect = 'COUNT(voteid)'; $elems['allvotes']->queryfrom = '#__joomgallery_votes'; } // Get parameters for nametags and fill array element $elems['allnametags'] = new stdClass(); $elems['allnametags']->enabled = intval($params->get('all_nametags', false)); if ($elems['allnametags']->enabled) { $elems['allnametags']->outputtext = $params->get('all_nametagstext', ''); $elems['allnametags']->queryselect = 'COUNT(nid)'; $elems['allnametags']->queryfrom = '#__joomgallery_nameshields'; } // Get instance of database object ans set debug mode if enabled $database = JFactory::getDBo(); // Get an instance of JDatabaseQuery object and clear them initially $query = $database->getQuery(true); // Set debug mode of database to fill the log array of database object // if debug mode enabled if ($debugmode) { $database->setdebug(true); } // Iterate through array // reference to element for adding the results (possible since PHP5) foreach ($elems as &$elem) { if ($elem->enabled) { // Fill the select and from clause of query $query->select($elem->queryselect); $query->from($elem->queryfrom); // Set the query and get the result from database $database->setQuery($query); $elem->outputresult = $database->loadResult(); } // Clear the query for next element $query->clear(); } if ($debugmode) { // Get the database log array $log = $database->getLog(); // And add the text to elements $logcount = 0; foreach ($elems as &$elem) { if ($elem->enabled) { $elem->dbquerylog = '•' . nl2br($log[$logcount], true) . '•<br />'; $logcount++; } } $database->debug(0); } return $elems; }
/** * Read the last comment of images and complete the image objects * * @param array $objects */ function getLastComments($objects) { if (count($objects)) { $db = JFactory::getDBo(); $query = $db->getQuery(true); $picidsarr = array_keys($objects); $picids = '(' . implode(',', $picidsarr) . ')'; $query->select('co.cmtpic AS cocmtpic'); if ($this->getConfig('showcmttext')) { $query->select('co.cmttext'); } $query->select('co.cmtdate as cmtdate, co.userid AS cmtuserid, co.cmtname AS cmtname'); $query->from(_JOOM_TABLE_COMMENTS . ' AS co'); $query->join('LEFT', _JOOM_TABLE_COMMENTS . ' AS co2' . ' ON co.cmtpic = co2.cmtpic AND co.cmtdate < co2.cmtdate' . ' WHERE' . ' co2.cmtpic IS NULL' . ' AND' . ' co.cmtpic IN ' . $picids . ' AND ((co.published=1 AND co.approved=1) OR co.published IS NULL)'); $db->setQuery($query); $commobjects = $db->loadObjectList('cocmtpic'); // And complete objects with data of last comment foreach ($objects as $key => &$object) { $object->cmttext = isset($commobjects[$key]->cmttext) ? $commobjects[$key]->cmttext : null; $object->cmtdate = isset($commobjects[$key]->cmtdate) ? $commobjects[$key]->cmtdate : null; $object->cmtuserid = isset($commobjects[$key]->cmtuserid) ? $commobjects[$key]->cmtuserid : null; $object->cmtname = isset($commobjects[$key]->cmtname) ? $commobjects[$key]->cmtname : null; } } }
public static function getTagsByListingId($listing_id, $select = 't.*', $checkPublished = true, $checkAccess = true, $checkLanguage = true, $order = 'txref.ordering', $dir = 'ASC') { if (!$listing_id) { return array(); } if (strpos(",", $select) !== false) { $selectColumnArr = explode(",", $select); sort($selectColumnArr); $select = implode(",", $selectColumnArr); } $storeId = md5(__METHOD__ . "::{$listing_id}::{$select}::" . (int) $checkPublished . "::" . (int) $checkAccess . "::" . (int) $checkLanguage . "::{$order}::{$dir}"); if (!isset(self::$cache[$storeId])) { $db = JFactory::getDBo(); $nullDate = $db->getNullDate(); $nowDate = JFactory::getDate()->toSql(); $query = $db->getQuery(true); $query->select($select); $query->from("#__judirectory_tags AS t"); $query->join("", "#__judirectory_tags_xref txref ON t.id = txref.tag_id"); $query->where("txref.listing_id = " . $listing_id); if ($checkPublished) { $query->where('t.published = 1'); $query->where('(t.publish_up = ' . $db->quote($nullDate) . ' OR t.publish_up <= ' . $db->quote($nowDate) . ')'); $query->where('(t.publish_down = ' . $db->quote($nullDate) . ' OR t.publish_down >= ' . $db->quote($nowDate) . ')'); } if ($checkAccess) { $user = JFactory::getUser(); $levels = $user->getAuthorisedViewLevels(); $levelsStr = implode(',', $levels); $query->where('t.access IN (' . $levelsStr . ')'); } $app = JFactory::getApplication(); if ($app->isSite() && $checkLanguage) { $languageTag = JFactory::getLanguage()->getTag(); if ($app->getLanguageFilter()) { $query->where('t.language IN (' . $db->quote($languageTag) . ',' . $db->quote('*') . ',' . $db->quote('') . ')'); } } $query->order($order . ' ' . $dir); $db->setQuery($query); self::$cache[$storeId] = $db->loadObjectList(); } return self::$cache[$storeId]; }
?> <?php $registration = 'registration'; if ($regp[0] != 'joomla') { $registration .= '/' . $regp[0]; } switch ($regp[0]) { case 'joomla': $lang->load('plg_user_profile', JPATH_ADMINISTRATOR); break; case 'virtuemart': $lang->load('com_virtuemart'); break; } $db = JFactory::getDBo(); $db->setQuery(defined('DEMO') ? "SELECT fields, props FROM #__offlajn_forms WHERE id = {$params->get('regform', 1)}" : "SELECT fields, props FROM #__offlajn_forms WHERE state=1 AND type='{$registration}'"); $res = $db->loadObject(); $fields = json_decode($res->fields); foreach ($fields->page[0]->elem as $elem) { foreach ($elem as $name => $prop) { if ($name == 'jform[elem_name]') { $prop->value = $prop->value ? $prop->value : $prop->placeholder; } if ($name == 'jform[elem_type]') { $prop->value = $prop->value ? $prop->value : $prop->placeholder; } if (!isset($prop->value) || $name == 'jform[elem_pattern]' || $name == 'jform[elem_name]' || $name == 'jform[elem_type]') { continue; } if (!$prop->value) {
} } } function convertToJSON($items) { global $chartmapvlaue; for ($va = 0; $va < sizeof($items); $va++) { $item = $items[$va]; $chartmapvlaue .= '{"driver_name":"' . $item->driver_name . '" , "total_score":' . $item->total_score . ',"aggressive_score":"' . $item->aggressive_score . '","distraction_score":"' . $item->distraction_score . '"},'; } return $chartmapvlaue; } require JPATH_BASE . DS . "components" . DS . "com_fleetmatrix" . DS . "models" . DS . "calculator.php"; $calculator = new ScoreCalculator(); $user =& JFactory::getUser(); $db =& JFactory::getDBo(); if ($user) { $query = $db->getQuery(true)->select('entity_type, entity_id')->from('#__fleet_user')->where('id = "' . $user->id . '"'); $db->setQuery($query); $row = $db->loadObject(); if ($row) { $query = $db->getQuery(true)->select('id')->from("#__fleet_entity")->where('parent_entity_id = ' . $row->entity_id); $db->setQuery($query); $results = $db->loadResultArray(); switch ($row->entity_type) { case 1: // reseller foreach ($results as $id) { $GLOBALS['user_companies'][] = $id; $query = $db->getQuery(true)->select('id')->from("#__fleet_entity")->where('parent_entity_id = ' . $id); $db->setQuery($query);
function display() { /* Allow modifying of the view */ $view_type = JRequest::getCmd('view', 'fleetmatrix'); $model_type = JRequest::getCmd('model', $view_type); $GLOBALS['user_companies'] = array(); $GLOBALS['user_groups'] = array(); $user =& JFactory::getUser(); $db =& JFactory::getDBo(); if ($user) { $query = $db->getQuery(true)->select('entity_type, entity_id')->from('#__fleet_user')->where('id = "' . $user->id . '"'); $db->setQuery($query); $row = $db->loadObject(); if ($row) { $query = $db->getQuery(true)->select('id')->from("#__fleet_entity")->where('parent_entity_id = ' . $row->entity_id); $db->setQuery($query); $results = $db->loadResultArray(); switch ($row->entity_type) { case 1: // reseller foreach ($results as $id) { $GLOBALS['user_companies'][] = $id; $query = $db->getQuery(true)->select('id')->from("#__fleet_entity")->where('parent_entity_id = ' . $id); $db->setQuery($query); $groups = $db->loadResultArray(); foreach ($groups as $gid) { $GLOBALS['user_groups'][] = $gid; } } break; case 2: // company $GLOBALS['user_companies'][] = $row->entity_id; foreach ($results as $id) { $GLOBALS['user_groups'][] = $id; } break; case 3: // group $GLOBALS['user_groups'][] = $row->entity_id; break; default: // ?? shouldn't happen break; } } } if (!array_intersect($user->authorisedLevels(), array(2, 3, 4, 8, 16))) { return; } //var_dump($GLOBALS['user_companies']); //var_dump($GLOBALS['user_groups']); $layout = JRequest::getCmd('layout', 'html'); $view =& $this->getView($view_type, $layout); $model = $this->getModel($model_type); $view->setModel($model, true); $edit_model = $this->getModel($model_type . 'edit'); if ($edit_model) { $view->setEditModel($edit_model); } $list_model = $this->getModel($model_type . 'list'); if ($list_model) { $view->setListModel($list_model); } $view->display(); }