public static function getItem($params = array()) { $user = JFactory::getUser(); $member_id = $user->id; $db = oseDB::instance(); $query = " SELECT company.* FROM `#__oselic_cs_company` AS company " ." INNER JOIN `#__oselic_cs_keys_view` AS lic_view ON lic_view.company_id = company.company_id" ." WHERE lic_view.user_id = {$member_id}"; ; $db->setQuery($query); //oseExit($db->_sql); $info = oseDB::loadList(); //$member = oseRegistry::call('member'); //$member->instance($member_id); //$info = $member->getBillingInfo(); $result['success'] = true; if(empty($info)) { $result['total'] = 0; $result['result'] = ''; } else { $result['total'] = 1; $result['result'] = $info; } return $result; }
public function getList($type, $backend = false) { $db = oseDB::instance(); $where = array(); if ('member' == substr($type, 0, 6)) { $where[] = "a.`type` LIKE 'member_%'"; } else { $where[] = "a.`type` = " . $db->Quote($type); } $where[] = "b.`enabled` = 1 "; $where = oseDB::implodeWhere($where); $query = " SELECT a.*,b.enabled,b.custom,b.backend AS custom_backend, b.backend_enabled AS custom_backend_enabled,b.frontend AS custom_frontend, b.frontend_enabled AS custom_frontend_enabled" . " FROM `#__osemsc_addon` AS a" . " INNER JOIN `#__osemsc_addon_applied` AS b ON b.addon_id =a.id" . $where; $db->setQuery($query); $types = oseDB::loadList('array', 'name'); foreach ($types as $key => $type) { $valid = $this->authorize($type['type'], $type['name'], $backend); if (!$valid) { unset($types[$key]); continue; } if ($type['custom']) { $type['backend'] = $type['custom_backend']; $type['frontend'] = $type['custom_frontend']; $type['backend_enabled'] = $type['custom_backend_enabled']; $type['frontend_enabled'] = $type['custom_frontend_enabled']; } if ($type['action'] == 1) { $type['action'] = "{$type['type']}.{$type['name']}"; } $types[$key] = $type; } //$types = array_values($types); return $types; }
public static function getMSCs() { $my = JFactory::getUser(); $member_id = $my->id; $result = array(); $db= oseDB :: instance(); $query= " SELECT acl.id, acl.title FROM `#__osemsc_member_history` AS omh" ." INNER JOIN `#__osemsc_acl` AS acl" ." ON omh.`msc_id` = acl.`id`" ." WHERE omh.`member_id` = '{$member_id}'" ." GROUP BY acl.`id`"; $db->setQuery($query); $items = oseDB :: loadList(); if(count($items) < 1) { $result['total'] = 0; $result['results'] = ''; }else { $result['total'] = count($items); $result['results'] = $items; } $result = oseJson :: encode($result); oseExit($result); }
function getMap() { // get License $db = oseDB::instance(); // active $where = array(); $where[] = "`member_id` = '{$this->user_id}'"; $where[] = "`status` = 1"; $where = oseDB::implodeWhere($where); $query = " SELECT * FROM `{$this->_table}`" . $where . " ORDER BY `id` ASC"; $db->setQuery($query); $items = oseDB::loadList('obj', 'msc_id'); $this->set('active_membership', $items); //expired $where = array(); $where[] = "`member_id` = '{$this->user_id}'"; $where[] = "`status` = 0"; $where = oseDB::implodeWhere($where); $query = " SELECT * FROM `{$this->_table}`" . $where . " ORDER BY `id` ASC"; $db->setQuery($query); $items = oseDB::loadList('obj', 'msc_id'); $this->set('expired_membership', $items); //suspend $where = array(); $where[] = "`member_id` = '{$this->user_id}'"; $where[] = "`status` = 3"; $where = oseDB::implodeWhere($where); $query = " SELECT * FROM `{$this->_table}`" . $where . " ORDER BY `id` ASC"; $db->setQuery($query); $items = oseDB::loadList('obj', 'msc_id'); $this->set('suspend_membership', $items); }
function getList() { $db = oseDB::instance(); $query = 'SELECT * FROM `#__groups` AS a ORDER by a.id ASC'; $db->setQuery($query); $results = oseDB::loadList(); return $results; }
function getUsers($where = null, $start = 0, $limit = 20, $type = 'array') { $db = oseDB::instance(); $query = " SELECT u.username,u.name,u.email,u.id FROM `#__users` AS u" . $where; $db->setQuery($query, $start, $limit); $items = oseDB::loadList($type); //oseExit($db->_sql); return $items; }
function getOwnMsc() { $member = oseRegistry::call('member'); $user = JFactory::getUser(); $member->instance($user->id); $db = oseDB::instance(); $query = " SELECT acl.*,mem.*, (SELECT DATEDIFF(mem.expired_date,NOW())) AS days_left FROM `#__osemsc_member` AS mem " . " INNER JOIN `#__osemsc_acl` AS acl ON acl.id = mem.msc_id" . " WHERE member_id = {$user->id}"; $db->setQuery($query); return oseDB::loadList(); }
public static function load($app = 'msc', $config_type = null, $type = 'array') { static $sApp, $objs; if ($sApp != $app) { $db = oseDB::instance(); $where = array(); if (!empty($config_type)) { if (is_array($config_type)) { $values = array(); foreach ($config_type as $configType) { $values[] = $db->Quote($configType); } } else { } } $where[] = '`app`=' . $db->Quote($app); $where = oseDB::implodeWhere($where); $query = " SELECT * FROM `#__ose_app_config` " . $where; $db->setQuery($query); $objs = oseDB::loadList('obj'); } if ($type == 'array') { $config = array(); } else { $config = new stdClass(); } if (empty($objs)) { return false; } foreach ($objs as $obj) { if (is_array($config_type)) { if (!in_array($obj->type, $config_type)) { continue; } } else { if ($obj->type != $config_type && !empty($config_type)) { continue; } } if (is_float($obj->value)) { $config = oseSetValue($config, $obj->key, (double) $obj->value); } elseif (is_numeric($obj->value)) { $config = oseSetValue($config, $obj->key, (int) $obj->value); } else { $config = oseSetValue($config, $obj->key, $obj->value); } } $config = oseSetValue($config, 'id', 1); $sApp = $app; return $config; }
public function getOrders($type, $start, $limit) { $db = oseDB::instance(); $where = array(); $search_order = JRequest::getString('search_order', null); $search_order = JString::strtolower($search_order); $search_user = JRequest::getString('search_user', null); $search_user = JString::strtolower($search_user); $filterStatus = JRequest::getString('filter_status', null); if (!empty($search_order)) { $searchQuery = $db->Quote('%' . $search_order . '%'); $where[] = "o.payment_serial_number LIKE {$searchQuery} OR o.order_id =" . (int) $search_order . " OR o.order_number LIKE {$searchQuery}"; } if (!empty($search_user)) { $searchQuery = $db->Quote('%' . $search_user . '%'); $where[] = "u.username LIKE {$searchQuery} OR u.name LIKE {$searchQuery} OR u.email LIKE {$searchQuery} OR u.id=" . (int) $search_user; } /*if (isset( $search ) && $search!= '') { $searchEscaped = $db->Quote('%'.$search.'%'); $where[] = " u.username LIKE {$searchEscaped} OR u.name LIKE {$searchEscaped}"; }*/ if (!empty($filterStatus)) { $where[] = "o.order_status = " . $db->Quote($filterStatus); } $where[] = "o.entry_type IN ('msc','msc_list')"; $where[] = "o.payment_from != 'system_admin'"; $where = oseDB::implodeWhere($where); $query = " SELECT COUNT(*) " . " FROM `#__osemsc_order` AS o " . " INNER JOIN `#__users` AS u ON u.id = o.user_id" . $where; $db->setQuery($query); //oseExit($db->getQuery()); $total = $db->loadResult(); $query = " SELECT CONCAT('Order:',o.order_id) AS title, u.username,u.name, o.* " . " FROM `#__osemsc_order` AS o " . " INNER JOIN `#__users` AS u ON u.id = o.user_id" . $where . " ORDER BY o.create_date DESC"; $db->setQuery($query, $start, $limit); //oseExit($db->getQuery()); $items = oseDB::loadList(); $return = array(); $i = 0; foreach ($items as $item) { $item['mscTitle'] = self::getMSCTitle($item['order_id']); $item['name'] = $item['user_id'] . ' - ' . $item['name']; $item['title'] = $item['title'] . ' - ' . $item['mscTitle']; $return[$i] = $item; $i++; } $result = array(); $result['total'] = $total; //$this->getTotal(); $result['results'] = $return; return $result; }
public static function getHistory($msc_id, $member_id, $action = null) { $db = oseDB::instance(); $where = array(); if (!empty($action)) { $where[] = " `action` = '{$action}'"; } $where[] = " `msc_id` = '{$msc_id}'"; $where[] = " `member_id` = '{$member_id}'"; $where = oseDB::implodeWhere($where); $query = " SELECT * FROM `#__osemsc_member_history` " . $where . " ORDER BY date DESC"; $db->setQuery($query); $objs = oseDB::loadList('obj'); return $objs; }
function &getList() { $db = oseDB::instance(); $search = JRequest::getString('search', null); $search = JString::strtolower($search); $msc_id = JRequest::getInt('msc_id', 0); $start = JRequest::getInt('start', 0); $limit = JRequest::getInt('limit', 20); $levellimit = JRequest::getInt('levellimit', 10); $where = array(); $where[] = 'rok.`folder` = 1'; $where[] = 'rok.`published` = 1'; if ($search) { $searchQuery = ' LOWER(rok.`name`) LIKE ' . $db->Quote('%' . $search . '%'); $where[] = $searchQuery; } $access = oseMscJaccess::get_msc_aid(25); if (!empty($access)) { //$where[] = "m.access <= {$access} "; } //Added in V 4.4, menu access levels // Generate where query $where = count($where) ? ' WHERE (' . implode(') AND (', $where) . ')' : ''; $query = ' SELECT rok.*' . ' FROM `#__rokdownloads` AS rok' . $where . ' ORDER BY rok.id'; $db->setQuery($query); //oseExit($db->_sql); $rows = oseDB::loadList('obj'); $total = count($rows); // slice out elements based on limits $list = array_slice($rows, $start, $limit); foreach ($list as $item) { $obj = oseRegistry::call('content')->getInstance('msc')->getItem('rokdownload', 'category', $item->id, 'msc', $msc_id, null, 'obj'); $item->type = empty($obj->content_type) ? 'category' : $obj->content_type; $controlled = empty($obj) ? 0 : $obj->status; if ($controlled == '1') { $item->controlled = JText::_('SHOW_TO_MEMBERS'); } elseif ($controlled == '-1') { $item->controlled = JText::_('HIDE_TO_MEMBERS'); } else { $item->controlled = JText::_('SHOW_TO_ALL'); } } $items = array_values($list); $result = array(); $result['total'] = $total; $result['results'] = $items; return $result; }
public static function getList($params = array()) { $db = oseDB::instance(); $query = "SELECT * FROM `#__acymailing_list` WHERE `type`= 'list'"; $db->setQuery($query); $planArray = oseDB::loadList(); $result = array(); if (count($planArray) < 1) { $result['total'] = 0; $result['results'] = ''; } else { $result['total'] = count($planArray); $result['results'] = $planArray; } return $result; }
public static function getGroups($params = array()) { $db = oseDB::instance(); $query = " SELECT id,name FROM `#__k2_user_groups` ORDER BY `name` ASC "; $db->setQuery($query); $items = oseDB::loadList(); $result = array(); if (count($items) < 1) { $result['total'] = 0; $result['results'] = ''; } else { $result['total'] = count($items); $result['results'] = $items; } return $result; }
public static function getProfileFields($params = array()) { $db = oseDB::instance(); $query = " SELECT id,name FROM `#__osemsc_fields` WHERE `published` = 1 ORDER BY `ordering` ASC "; $db->setQuery($query); $items = oseDB::loadList(); $result = array(); if (count($items) < 1) { $result['total'] = 0; $result['results'] = ''; } else { $result['total'] = count($items); $result['results'] = $items; } return $result; }
public static function getPlans($params = array()) { $db = oseDB::instance(); $query = " SELECT id,title FROM `#__ose_credit_plan` ORDER BY `title` ASC "; $db->setQuery($query); $items = oseDB::loadList(); $result = array(); if (count($items) < 1) { $result['total'] = 0; $result['results'] = ''; } else { $result['total'] = count($items); $result['results'] = $items; } return $result; }
public static function getField($params = array()) { $db = oseDB::instance(); $query = " SELECT tabid,tablecolumns,name FROM `#__comprofiler_fields` ORDER BY `fieldid` ASC "; $db->setQuery($query); $items = oseDB::loadList(); $result = array(); if (count($items) < 1) { $result['total'] = 0; $result['results'] = ''; } else { $result['total'] = count($items); $result['results'] = $items; } return $result; }
function getProfile() { $db = oseDB::instance(); $query = "SELECT * FROM `#__osemsc_fields` WHERE `published` = '1' ORDER BY `ordering`"; $db->setQuery($query); $items = oseDB::loadList('obj'); $return = array(); $i = 0; if (!empty($items)) { foreach ($items as $item) { $return[$i]['name'] = 'custom.' . strtolower(str_replace(" ", "_", $item->name)); $query = "SELECT value FROM `#__osemsc_fields_values` WHERE `field_id` = " . (int) $item->id . " AND `member_id` = " . (int) $this->user_id; $db->setQuery($query); $return[$i]['value'] = $db->loadResult(); $i++; } } return $return; }
public function getOrders() { $db = oseDB::instance(); //$my = JFactory::getUser(); $member_id = JRequest::getInt('member_id', 0); $start = JRequest::getInt('start', 0); $limit = JRequest::getInt('limit', 20); $where = array(); $where[] = "o.user_id = '{$member_id}'"; $where[] = "o.entry_type IN ('msc','msc_list')"; $where = oseDB::implodeWhere($where); $query = " SELECT u.username,u.name, o.* " . " FROM `#__osemsc_order` AS o " . " INNER JOIN `#__users` AS u ON u.id = o.user_id" . $where . " LIMIT {$start},{$limit} "; $db->setQuery($query); //oseExit($db->_sql); //oseExit($db->_sql); $items = oseDB::loadList(); $result = array(); $result['total'] = $this->getTotal(); $result['results'] = $items; return $result; }
function __construct($p = array()) { parent::__construct($p); if (count($this->get('_type')) < 1) { $db = oseDB::instance(); $query = " SELECT * FROM `{$this->_tableType}`"; $db->setQuery($query); $this->set('_type', oseDB::loadList('obj', 'id')); } if ($this->get('id', 0) > 0) { $info = $this->getTypeInfo(); unset($info['id']); if (isset($info['params'])) { $info['typeParams'] = oseGetValue($info, 'params'); unset($info['params']); } $this->setProperties($info); } else { $this->set('_isNew', true); } }
function &getList() { $db = oseDB::instance(); $search = JRequest::getString('search', null); $search = JString::strtolower($search); $msc_id = JRequest::getInt('msc_id', 0); $start = JRequest::getInt('start', 0); $limit = JRequest::getInt('limit', 20); $where = array(); if ($search) { $searchQuery = ' LOWER(aqc.`CategoryName`) LIKE ' . $db->Quote('%' . $search . '%'); $where[] = $searchQuery; } $where = count($where) ? ' WHERE (' . implode(') AND (', $where) . ')' : ''; // Generate where query $query = ' SELECT aqc.CategoryId AS id, aqc.CategoryName AS name' . ' FROM `#__ariquizcategory` AS aqc' . $where . ' ORDER BY aqc.`CategoryId`'; $db->setQuery($query); //oseExit($db->_sql); $rows = oseDB::loadList('obj'); $total = count($rows); // slice out elements based on limits $list = array_slice($rows, $start, $limit); foreach ($list as $item) { $obj = oseRegistry::call('content')->getInstance('msc')->getItem('ariquiz', 'category', $item->id, 'msc', $msc_id, null, 'obj'); $item->type = empty($obj->content_type) ? 'category' : $obj->content_type; $controlled = empty($obj) ? 0 : $obj->status; if ($controlled == '1') { $item->controlled = JText::_('SHOW_TO_MEMBERS'); } elseif ($controlled == '-1') { $item->controlled = JText::_('HIDE_TO_MEMBERS'); } else { $item->controlled = JText::_('SHOW_TO_ALL'); } } $items = array_values($list); $result = array(); $result['total'] = $total; $result['results'] = $items; return $result; }
static function getConfig($config_type = null, $type = 'array') { $db = oseDB::instance(); $where = array(); if (!empty($config_type)) { if (is_array($config_type)) { $values = array(); foreach ($config_type as $configType) { $values[] = $db->Quote($configType); } $where[] = 'type IN (' . implode(',', $values) . ')'; } else { $where[] = 'type=' . $db->Quote($config_type); } } $where = oseDB::implodeWhere($where); $query = " SELECT * FROM `#__osemsc_configuration` " . $where; $db->setQuery($query); $objs = oseDB::loadList('obj'); if ($type == 'array') { $config = array(); foreach ($objs as $obj) { $config[$obj->key] = $obj->value; //oseObject::setValue($config,$obj->key,$obj->value); } } else { $config = new stdClass(); foreach ($objs as $obj) { $config->{$obj->key} = $obj->value; //oseObject::setValue($config,$obj->key,$obj->value); } } /*foreach($objs as $obj) { $config = oseObject::setValue($config,$obj->key,$obj->value); }*/ $config = oseObject::setValue($config, 'id', 1); return $config; }
function getList() { $model = $this->getModel('members'); $msc_id = JRequest::getVar('msc_id', array(), 'post'); if (empty($msc_id[0])) { $db = oseDB::instance(); $query = "SELECT * FROM `#__osemsc_acl`"; $db->setQuery($query); $objs = oseDB::loadList('obj'); $msc_id = array(); foreach ($objs as $obj) { $msc_id[] = $obj->id; } } $result = $model->getList($msc_id); if ($result['total'] < 1) { $result['total'] = 0; } $result = oseJSON::encode($result); echo $result; exit; }
function getFaiths() { $db= oseDB::instance(); $query = " SELECT * FROM `#__osemsc_email` " ." WHERE type = 'faith' " ; $db->setQuery($query); $terms = oseDB::loadList(); $total = count($terms); $result = array(); $result['total'] = $total; $result['results'] = $terms; $result = oseJson::encode($result); oseExit($result); }
public function getList() { $db = oseDB::instance(); $search = JRequest::getString('search', null); $search = JString::strtolower($search); $start = JRequest::getInt('start', 0); $limit = JRequest::getInt('limit', 20); $dir = JRequest::getCmd('dir', 'ASC'); $sortField = JRequest::getCmd('sort', 'domain'); $msc_id = JRequest::getInt('msc_id'); $user_id = JRequest::getInt('user_id'); $where = array(); $where[] = "`mscID` = '{$msc_id}'"; $where[] = "`userID` = '{$user_id}'"; if (!empty($search)) { $searchQuery = $db->Quote('%' . $search . '%'); $where[] = "`domain` LIKE {$searchQuery}"; } $where = oseDB::implodeWhere($where); $query = " SELECT COUNT(*) " . " FROM `#__osetickets_domains` " . $where; $db->setQuery($query); $total = $db->loadResult(); $query = " SELECT *" . " FROM `#__osetickets_domains` " . $where . " ORDER BY {$sortField} {$dir}"; if ($start >= 0 && $limit >= 0) { $db->setQuery($query, $start, $limit); } else { $db->setQuery($query); } $items = oseDB::loadList('obj'); $list = array(); foreach ($items as $key => $item) { $list[$key] = $item; } $resul = array(); $result['total'] = $total; $result['results'] = $list; oseExit(oseJson::encode($result)); }
function getCurrencyList() { $db = oseDB::instance(); $query = " SELECT * FROM `#__osemsc_configuration` WHERE `key` = 'primary_currency'"; $db->setQuery($query); $objs = oseDB::loadList('obj'); $currency = array(); $currency[0]['title'] = $objs[0]->value; $currency[0]['value'] = $objs[0]->value; $others = oseJSON::decode($objs[0]->default); $i = 1; if (!empty($others)) { foreach ($others as $key => $value) { $currency[$i]['title'] = $key; $currency[$i]['value'] = $key; $i++; } } $result = array(); $result['results'] = $currency; $result['total'] = count($result['results']); $result = oseJson::encode($result); oseExit($result); }
public static function updateLocationInfo($params = array()) { $db = oseDB::instance(); $post = JRequest::get('post'); $result = array(); $result['success'] = true; $result['title'] = 'Done'; $result['content'] = JText::_('Saved Directory Info.'); $directory = array(); foreach ($post as $key => $value) { if (strstr($key, 'directory_')) { $billKey = preg_replace('/directory_/', '', $key, 1); $directory[$billKey] = $value; } } //$directory['directory_id'] = $directory['id']; $directory_id = $directory['id']; unset($directory['id']); //$user = JFactory::getUser(); $location_id = JRequest::getInt('location_id', 0); // Add to Mt Link /* $query = " SELECT directory.* FROM `#__osemsc_directory` AS directory " ." INNER JOIN `#__oselic_cs_keys_view` AS luv ON luv.company_id = directory.company_id" ." WHERE luv.location_id = {$location_id}"; ; $db->setQuery($query); $item = oseDB::loadItem('obj'); $directory_id = $item->directory_id; */ /* $query = " SELECT directory_id FROM `#__osemsc_location` " ." WHERE location_id = {$location_id}" ; $db->setQuery($query); $item = oseDB::loadItem('obj'); */ $query = " SELECT * FROM `#__oselic_cs_company_view` AS lcc " . " INNER JOIN `#__oselic_cs_keys_view` AS luv ON luv.company_id = lcc.company_id" . " WHERE lcc.directory_id = {$directory_id} " . " ORDER BY lcc.location_id"; $db->setQuery($query); $objs = oseDB::loadList('obj'); //$location_id = JRequest::getInt('location_id',0); if (count($objs) < 1) { self::addToMtLink($directory_id, $directory); } else { if (!empty($location_id) && $location_id == $objs[0]->location_id) { self::addToMtLink($directory_id, $directory); } } // Add ends if (empty($location_id)) { $keys = array_keys($directory); $keys = '`' . implode('`,`', $keys) . '`'; $fields = $db->getTableFields('#__osemsc_location'); foreach ($directory as $key => $value) { if (!isset($fields['#__osemsc_location'][$key])) { /* $query = "ALTER TABLE `#__osemsc_billinginfo` ADD `{$key}` TEXT NULL DEFAULT NULL"; $db->setQuery($query); if (!$db->query()) { return false; } */ unset($directory[$key]); } } $values = array(); foreach ($directory as $key => $value) { $values[$key] = $db->Quote($value); } $values = implode(',', $values); $query = "INSERT INTO `#__osemsc_location` (`directory_id`,{$keys}) VALUES ('{$directory_id}',{$values});"; } else { foreach ($directory as $key => $value) { $company[$key] = "`{$key}`=" . $db->Quote($value); } $values = implode(',', $company); $query = " UPDATE `#__osemsc_location` SET {$values}" . " WHERE `location_id` ={$location_id}"; } //echo $query;exit; $db->setQuery($query); $result = array(); if (!oseDB::query()) { $result['success'] = false; $result['title'] = JText::_('Error'); $result['content'] = JText::_('Fail Saving Directory Info.'); } else { $result['success'] = true; $result['title'] = JText::_('Done'); $result['content'] = JText::_('Saved Directory Info.'); } return $result; }
$query = "SELECT `payment_serial_number` FROM `#__osemsc_order` WHERE `order_id` = ".(int)$order_id; $db->setQuery($query); $tmpresult = $db->loadResult(); if (empty($tmpresult)) { $subID = $process->get('subscr_id'); $txnID = $process->get('txn_id'); $referenceID = (!empty($subID))?$subID:$txnID; $query = " UPDATE `#__osemsc_order` SET `payment_serial_number` = ". $db->Quote($referenceID); $db->setQuery($query); $db->query(); } $query= " SELECT * FROM `#__osemsc_order_item`". " WHERE order_id = '{$order_id}'"; $db->setQuery($query); $orderItems= oseDB :: loadList('obj'); // $msc_id = $orderInfo->entry_id; // remove post headers if present. //OSE pending $res= preg_replace("'Content-type: text/plain'si", "", $res); //------------------------------------------- // ...read the results of the verification... // If VERIFIED = continue to process the TX... //------------------------------------------- if(eregi("VERIFIED", $res)) { // check the invoice $isValid= false; if(!$process->checkInvoice()) { $payment_status= "Failed"; $mailsubject= "PayPal IPN Transaction on your site: Order ID not found"; $mailbody= "The right order_id wasn't found during a PayPal transaction on your website.
function generateOrderTable($order_id, $user_id) { $db = oseDB::instance(); $payment = oseRegistry::call('payment'); $where = array(); $where[] = "order_id = {$order_id}"; $orderInfo = $payment->getOrder($where, 'obj'); $orderInfoParams = oseJson::decode($orderInfo->params); $query = " SELECT * FROM `#__osemsc_order_item`" . " WHERE `order_id` = '{$order_id}'"; $db->setQuery($query); $objs = oseDB::loadList('obj'); $table = array(); $tHeads = array(); $tHeads[] = '<thead>'; $tHeads[] = '<tr>'; $tHeads[] = '<th>' . JText::_('MEMBERSHIP_PLAN') . '</th>'; $tHeads[] = '<th>' . JText::_('START_DATE') . '</th>'; $tHeads[] = '<th>' . JText::_('EXPIRED_DATE') . '</th>'; $tHeads[] = '<th>' . JText::_('PRICE') . '</th>'; $tHeads[] = '</tr>'; $tHeads[] = '</thead>'; $tBody = array(); $tBody[] = '<tbody>'; foreach ($objs as $obj) { switch ($obj->entry_type) { case 'msc': $obj->payment_price = $orderInfoParams->recurrence_times > 1 ? $orderInfoParams->next_total : $orderInfoParams->total; $msc_id = $obj->entry_id; break; case 'license': $params = oseJson::decode($obj->params); $msc_id = $params->msc_id; break; } $query = " SELECT *,DATE_SUB(`expired_date`,INTERVAL 1 DAY) AS `real_expired_date` " . " FROM `#__osemsc_member`" . " WHERE member_id = {$user_id} AND msc_id={$msc_id}"; $db->setQuery($query); $memberInfo = oseDB::loadItem('obj'); $globalConfig = oseRegistry::call('msc')->getConfig('global', 'obj'); if (!empty($globalConfig->DateFormat)) { $memberInfo->start_date = date($globalConfig->DateFormat, strtotime($memberInfo->start_date)); if ($memberInfo->expired_date != '0000-00-00 00:00:00') { $memberInfo->expired_date = date($globalConfig->DateFormat, strtotime($memberInfo->expired_date)); } if ($memberInfo->real_expired_date != '0000-00-00 00:00:00') { $memberInfo->real_expired_date = date($globalConfig->DateFormat, strtotime($memberInfo->real_expired_date)); } } $query = " SELECT * FROM `#__osemsc_acl`" . " WHERE id = '{$msc_id}'"; $db->setQuery($query); $item = oseDB::loadItem('obj'); $tr = '<tr>'; $tr .= "<td>{$item->title}</td>"; $tr .= "<td>{$memberInfo->start_date}</td>"; if ($obj->payment_mode == 'a') { $tr .= "<td>{$memberInfo->real_expired_date}</td>"; } else { if ($memberInfo->eternal) { $memberInfo->expired_date = 'Life Time'; } $tr .= "<td>{$memberInfo->expired_date}</td>"; } $tr .= "<td>{$obj->payment_currency} {$obj->payment_price}</td>"; $tr .= '</tr>'; $tBody[] = $tr; } $tBody[] = '</tbody>'; $table[] = '<table width="100%">'; $table[] = implode("\r\n", $tHeads); $table[] = implode("\r\n", $tBody); $table[] = '</table>'; $html = implode("\r\n", $table); return $html; }
function refundOrder($order_id, $params = array()) { $db = oseDB::instance(); $this->updateOrder($order_id, "refunded", $params); $where = array(); $where[] = '`order_id` = ' . $db->Quote($order_id); $orderInfo = $this->getOrder($where, 'obj'); $user_id = $orderInfo->user_id; $query = " SELECT * FROM `#__osemsc_order_item`" . " WHERE `order_id` = '{$orderInfo->order_id}'"; $db->setQuery($query); $items = oseDB::loadList('obj'); foreach ($items as $item) { switch ($item->entry_type) { case 'license': $license = oseRegistry::call('lic')->getInstance(0); $licenseInfo = $license->getKeyInfo($item->entry_id, 'obj'); $licenseInfoParams = oseJson::decode($licenseInfo->params); $msc_id = $licenseInfoParams->msc_id; $updated = $this->cancelMsc($order_id, $item->order_item_id, $msc_id, $user_id); break; default: case 'msc': $updated = $this->cancelMsc($order_id, $item->order_item_id, $item->entry_id, $user_id); break; } if (!$updated['success']) { return $updated; } } $return['success'] = true; $return['title'] = JText::_('Success'); $return['content'] = JText::_('Refunded Successfully'); $session = JFactory::getSession(); $session->set('osecart', array()); return $return; }
function getMscList($msc_id = 0) { $db = oseDB::instance(); $where = array(); $where[] = "published = 1"; if (!empty($msc_id)) { $where[] = "id = {$msc_id}"; } $where = oseDB::implodeWhere($where); $query = " SELECT * FROM `#__osemsc_acl`" . $where . " ORDER BY lft ASC"; $db->setQuery($query); $objs = oseDB::loadList('obj'); $mscExtend = oseRegistry::call('msc')->getConfig('global', 'obj')->msc_extend; $items = array(); $session = JFactory::getSession(); $osePaymentCurrency = $session->get('osePaymentCurrency', oseRegistry::call('msc')->getConfig('currency', 'obj')->primary_currency); foreach ($objs as $obj) { $paymentInfos = oseRegistry::call('msc')->getExtInfo($obj->id, 'payment', 'array'); foreach ($paymentInfos as $key => $paymentInfo) { if (!empty($mscExtend)) { $ext = oseRegistry::call($mscExtend); $item = oseRegistry::call('payment')->getInstance('View')->getMscInfo($obj->id, $osePaymentCurrency, oseObject::getValue($paymentInfo, 'id')); $itemExtend = $ext->getMscExtendInfo($obj->id); $fItem = (object) array_merge((array) $item, (array) $itemExtend); } else { $item = oseRegistry::call('payment')->getInstance('View')->getMscInfo($obj->id, $osePaymentCurrency, oseObject::getValue($paymentInfo, 'id')); $fItem = $item; } $items[] = $fItem; } } return $items; }