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 getFullTree($start, $limit) { $msc = oseRegistry::call('msc'); $return = array(); $items = array(); $items = $msc->retrieveTree(); $return['total'] = count($items); $list = array_slice($items, $start, $limit); foreach ($list as $key => $item) { $members = $msc->getMembers(oseObject::getValue($item, 'id'), 0, 0, 0, 'obj'); $totalExp = oseObject::getValue($members, 'total', 0); $members = $msc->getMembers(oseObject::getValue($item, 'id'), 1, 0, 0, 'obj'); $totalAct = oseObject::getValue($members, 'total', 0); $total = $totalAct + $totalExp; $item = oseObject::setValue($item, 'total', $total); $item = oseObject::setValue($item, 'totalExp', $totalExp); $item = oseObject::setValue($item, 'totalAct', $totalAct); $list[$key] = $item; } $return['results'] = $list; return $return; }
public static function getJoinHistory() { $db= oseDB :: instance(); $my = JFactory::getUser(); $member_id = $my->id; $msc_id = JRequest :: getInt('msc_id', '0'); $start = JRequest::getInt('start',0); $limit = JRequest::getInt('limit',20); $query = " SELECT COUNT(*) FROM `#__osemsc_member_history` " ." WHERE `msc_id` = '{$msc_id}' AND `member_id` = '{$member_id}'" ; $db->setQuery($query); $total = $db->loadResult(); $query = " SELECT * FROM `#__osemsc_member_history` " ." WHERE `msc_id` = '{$msc_id}' AND `member_id` = '{$member_id}'" ." ORDER BY id DESC" ; $db->setQuery($query,$start,$limit); $items = oseDB :: loadList(); foreach($items as $key => $item) { $globalConfig = oseRegistry::call('msc')->getConfig('global','obj'); if(!empty($globalConfig->DateFormat)) { $items[$key]= oseObject::setValue($item,'date',date($globalConfig->DateFormat,strtotime($item['date']))); } } $result = array(); $result['total'] = $total; $result['results'] = $items; $result = oseJson :: encode($result); oseExit($result); }
public function getOrdersMobile() { $db = oseDB::instance(); $my = JFactory::getUser(); $start = JRequest::getInt('start',0); $limit = JRequest::getInt('limit',999); $where = array(); $where[] = "o.user_id = '{$my->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},999 " ; $db->setQuery($query); //oseExit($db->_sql); //oseExit($db->getQuery()); $items = oseDB::loadList(); $gw = oseRegistry::call('payment')->getInstance('GateWay'); foreach($items as $key => $item) { $gwInfo = $gw->getGWInfo(oseObject::getValue($item,'payment_method')); if(oseObject::getValue($gwInfo,'is_cc',0) == 1) { $items[$key] = oseObject::setValue($item,'payment_method','Credit Card'); } if ($item['order_status']=='confirmed' || $item['order_status']=='pending') { $items[$key]=oseObject::setValue($item,'order_status',JText::_(strtoupper($items[$key]['order_status']))); } if (isset($item['payment_method'])) { $items[$key]=oseObject::setValue($item,'payment_method',JText::_(strtoupper($items[$key]['payment_method']))); } $globalConfig = oseRegistry::call('msc')->getConfig('global','obj'); if(!empty($globalConfig->DateFormat)) { $items[$key]= oseObject::setValue($item,'create_date',date($globalConfig->DateFormat,strtotime($item['create_date']))); } } $result = array(); $result['total'] = $this->getTotal(); $result['results'] = $items; return $result; }
function getMscList_M() { $cartItems = oseMscPublic::getCartItems(); ///$item = $items[0]; $db = oseDB::instance(); $where = array(); $where[] = "published = 1"; $msc_option = 0; if(!empty($items[0])) { $msc_id = oseObject::getValue($items[0],'entry_id'); if(!empty($msc_id)) { $where[] = "id = {$msc_id}"; } $msc_option = oseObject::getValue($items[0],'msc_option'); } $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) { if(empty($msc_option)) { $paymentInfos = oseRegistry::call('msc')->getExtInfo($obj->id,'payment','array'); //oseExit($paymentInfos); foreach($paymentInfos as $key => $paymentInfo) { $fItem = oseRegistry::call('msc')->getPaymentMscInfo($obj->id,$osePaymentCurrency,$key); $fItem = oseObject::setValue($fItem,'msc_option',$key); $items[] = $fItem; } } else { $fItem = oseRegistry::call('msc')->getPaymentMscInfo($obj->id,$osePaymentCurrency,$msc_option); $fItem = oseObject::setValue($fItem,'msc_option',$msc_option); $items[] = $fItem; } } $total = count($items); $result = array(); if($total > 0) { $result['total'] = $total; $result['results'] = $items; } $result = oseJson::encode($result); oseExit($result); }
private function ordering($id, $msc_id, $orderingChange) { $db = oseDB::instance(); //$post = JRequest::get('post'); $extItem = oseRegistry::call('msc')->getExtInfoItem($msc_id, 'payment', 'obj'); $extItem->params = empty($extItem->params) ? array() : $extItem->params; $items = oseJson::decode($extItem->params, true); // if no ordering exists, resort it. $i = 1; foreach ($items as $key => $item) { if (!oseObject::getValue($item, 'ordering', 0)) { $item = oseObject::setValue($item, 'ordering', $i); $items[$key] = $item; } else { break; } $i++; } if (oseObject::getValue($items[$id], 'ordering') == 1 && $orderingChange < 0) { return true; } if (oseObject::getValue($items[$id], 'ordering') == count($items) && $orderingChange > 0) { return true; } // get new array by ordering $nItems = array(); foreach ($items as $key => $item) { $ordering = oseObject::getValue($item, 'ordering'); $nItems[$ordering] = $item; } ksort($nItems); $curOrdering = oseObject::getValue($items[$id], 'ordering'); $curItem = $nItems[$curOrdering]; $toOrdering = $curOrdering + $orderingChange; $toItem = $nItems[$toOrdering]; // resort the ordering $i = 1; $rItems = array(); foreach ($nItems as $key => $item) { if ($i == $curOrdering) { $rItems[$i] = $toItem; } elseif ($i == $toOrdering) { $rItems[$i] = $curItem; } else { $rItems[$i] = $item; } $i++; } // restore key: id $i = 1; $items = array(); foreach ($rItems as $key => $item) { $nkey = oseObject::getValue($item, 'id'); $items[$nkey] = oseObject::setValue($item, 'ordering', $key); } $where = array(); $where[] = 'id = ' . $db->Quote($msc_id); $where[] = 'type = ' . $db->Quote('payment'); $newParams = $db->Quote(oseJson::encode($items)); $where = oseDB::implodeWhere($where); $query = " UPDATE `#__osemsc_ext` " . " SET " . " params = {$newParams} " . $where; $db->setQuery($query); if (oseDB::query()) { return true; } else { return false; } }
public static function getItems($params = array()) { $my = JFactory::getUser(); $member_id = $my->id; $member = oseRegistry::call('member'); $member->instance($member_id); $items = array(); $memAllInfos = $member->getAllOwnedMsc(true,0,'obj'); $db = oseDB::instance(); $query = " SELECT * FROM `#__osemsc_acl`" //." WHERE `published` = 1" ; $db->setQuery($query); $objs = oseDB::loadList('obj'); $mscIds = array(); foreach($objs as $obj) { $mscIds[] = $obj->id; } foreach($memAllInfos as $key => $memAllInfo) { if(!in_array($memAllInfo->msc_id,$mscIds)) { unset($memAllInfos[$key]); continue; } $memParams = oseJson::decode($memAllInfo->params); if( $memParams->payment_mode == 'a' ) { if($memAllInfo->status == 0) { $items[] = $memAllInfo; } } else { $items[] = $memAllInfo; } } foreach($items as $item) { $mscInfo = oseRegistry::call('msc')->getInfo($item->msc_id,'obj'); $item = oseObject::setValue($item,'msc_name',$mscInfo->title); } $result = array(); if(count($items) < 1) { $result['total'] = 0; $result['results'] = ''; } else { $result['total'] = count($items); $result['results'] = $items; } return $result; }
function setExchangeRateList($rateList) { $rateList = oseObject::setValue($rateList, $this->pCurrency, array('currency' => $this->pCurrency, 'rate' => 1)); $this->rateList = $rateList; }
function updateOrderParams($orderInfo, $params) { $orderInfoParams = oseObject::getValue($orderInfo, 'params'); $orderInfoParams = oseJson::decode($orderInfoParams); if (!is_Array($params)) { $params = (array) $params; } foreach ($params as $key => $value) { $orderInfoParams = oseObject::setValue($orderInfoParams, $key, $value); } $orderInfoParams = oseJson::encode($orderInfoParams); $orderInfo = oseObject::setValue($orderInfo, 'params', $orderInfoParams); return $orderInfo; }
function getUsersTable($id) { $db = oseDB::instance(); $where = array(); $where[] = "c.`coupon_id` = '{$id}'"; $where = oseDB::implodeWhere($where); $query = " SELECT c.* FROM `#__osemsc_coupon_user` AS c " . $where; $db->setQuery($query); //oseExit($db->_sql); $items = oseDB::loadList(); //oseExit($items); foreach ($items as $key => $item) { $user_id = oseObject::getValue($item, 'user_id'); $query = " SELECT * FROM `#__users`" . " WHERE `id` = '{$user_id}'"; $db->setQuery($query); $obj = oseDB::loadItem('obj'); $item = oseObject::setValue($item, 'username', oseObject::getValue($obj, 'username')); $items[$key] = $item; } $html = $this->generateTable($items); return $html; }
public static function getMscInfo($params = array()) { $my = JFactory::getUser(); $msc_id = JRequest::getInt('msc_id', 0); $member_id = $my->id; $db = oseDB::instance(); $query = " SELECT * FROM `#__osemsc_member`" . " WHERE member_id = {$member_id} AND msc_id = {$msc_id}"; $db->setQuery($query); $item = oseDB::loadItem('obj'); $memParams = oseJson::decode($item->params); //order $orderId = oseObject::getValue($memParams, 'order_id'); $orderInfo = oseRegistry::call('payment')->getInstance('Order')->getOrder(array('order_id = ' . $orderId), 'obj'); //order item $orderItemId = oseObject::getValue($memParams, 'order_item_id', 'm'); $orderItemInfo = oseRegistry::call('payment')->getInstance('Order')->getOrderItem(array('0' => 'order_item_id = ' . $orderItemId), 'obj'); $orderItemInfoParams = oseJson::decode($orderItemInfo->params); $msc = oseRegistry::call('msc'); $node = $msc->getInfo($msc_id, 'obj'); $paymentInfos = $msc->getExtInfo($msc_id, 'payment'); $paymentInfo = $paymentInfos[oseObject::getValue($orderItemInfoParams, 'msc_option')]; $option = oseMscPublic::generatePriceOption($node, array($paymentInfo), 'USD'); if (oseObject::getValue($memParams, 'payment_mode', 'm') == 'm') { $titlePaymentMode = JText::_('MANUAL_BILLING'); $query = " SELECT acl.*,mem.*, (SELECT DATEDIFF(mem.expired_date,NOW())) AS days_left " . " ,mem.`expired_date` AS `real_expired_date`" . " FROM `#__osemsc_member` AS mem " . " INNER JOIN `#__osemsc_acl` AS acl ON acl.id = mem.msc_id" . " WHERE mem.member_id = {$member_id} AND mem.msc_id = {$msc_id}"; } else { $titlePaymentMode = JText::_('AUTOMATIC_BILLING'); $query = " SELECT acl.*,mem.*, (SELECT DATEDIFF(mem.expired_date,NOW()) - 1) AS days_left " . " ,DATE_SUB(mem.`expired_date`,INTERVAL 1 DAY) AS `real_expired_date`" . " FROM `#__osemsc_member` AS mem " . " INNER JOIN `#__osemsc_acl` AS acl ON acl.id = mem.msc_id" . " WHERE mem.member_id = {$member_id} AND mem.msc_id = {$msc_id}"; } $db->setQuery($query); $item = oseDB::loadItem(); $globalConfig = oseRegistry::call('msc')->getConfig('global', 'obj'); if ($item['start_date'] != '0000-00-00 00:00:00' && !empty($globalConfig->DateFormat)) { $item = oseObject::setValue($item, 'start_date', date($globalConfig->DateFormat, strtotime($item['start_date']))); } if ($item['real_expired_date'] != '0000-00-00 00:00:00' && !empty($globalConfig->DateFormat)) { $item = oseObject::setValue($item, 'real_expired_date', date($globalConfig->DateFormat, strtotime($item['real_expired_date']))); } if (oseObject::getValue($item, 'eternal', false)) { $item = oseObject::setValue($item, 'real_expired_date', JText::_('LIFE_TIME')); $item = oseObject::setValue($item, 'days_left', JText::_('INFINITED')); } $result = array(); if (empty($item)) { $result['total'] = 0; $result['result'] = array(); } else { $item['title'] = oseObject::getValue($option[0], 'title') . "({$titlePaymentMode})"; $item['msc_option'] = oseObject::getValue($orderItemInfoParams, 'msc_option'); $item['expired_date'] = $item['real_expired_date']; $item['params'] = oseJson::decode($item['params']); if ($item['status'] == 1) { $exp_text = ''; if (oseObject::getValue($memParams, 'payment_mode', 'm') == 'a') { if (in_array($orderInfo->order_status, array('cancelled'))) { $exp_text = ' until ' . $item['expired_date']; } } $item['status'] = JText::_('ACTIVE') . ' ' . $exp_text; } else { $item['status'] = JText::_('INACTIVE'); } $item['payment_mode_text'] = ($item['params']->payment_mode == 'm') ? JText::_('MANUAL_RENEWING') : JText::_('AUTOMATIC_RENEWING'); if (empty($paymentInfo)) { $item['interval'] = '--'; } else { $item['interval'] = oseObject::getValue($paymentInfo, 'p3') . ' ' . JText::_(strtoupper(oseObject::getValue($paymentInfo, 't3'))) . '(s)'; } $result['total'] = 1; $result['result'] = $item; } return $result; }
public static function getExtInfo($msc_id, $xtype, $type = 'array') { $db = oseDB::instance(); $query = " SELECT * FROM `#__osemsc_ext` " . " WHERE id={$msc_id} AND type= " . $db->Quote($xtype); $db->setQuery($query); $item = oseDB::loadItem($type); $isData = $type == 'array' ? true : false; $extParams = oseObject::getValue($item, 'params'); $data = oseJson::decode($extParams, $isData); $data = oseObject::setValue($data, 'id', $msc_id); return $data; }
private function sendEmail($user) { if (file_exists(JPATH_SITE.DS.'components'.DS.'com_osemsc'.DS.'init.php') && file_exists(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_ose_cpu'.DS.'define.php') && !file_exists(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_osemsc'.DS.'installer.dummy.ini')) { require_once(JPATH_SITE.DS.'components'.DS.'com_osemsc'.DS.'init.php'); } $emailConfig = oseMscConfig::getConfig('email', 'obj'); if (!empty($emailConfig->default_reg_email)) { $member = oseRegistry::call('member'); $email = $member->getInstance('email'); $emailTempDetail = $email->getDoc($emailConfig->default_reg_email, 'obj'); if (!empty($emailTempDetail)) { $variables = $email->getEmailVariablesRegistration($user->id); $variables['user'] = oseObject::setValue($variables['user'], 'password', $user->password_clear); $emailParams = $email->buildEmailParams($emailTempDetail->type); $emailDetail = $email->transEmail($emailTempDetail, $variables, $emailParams); $email->sendEmail($emailDetail, $user->email); if ($emailConfig->sendReg2Admin) { $email->sendToAdminGroup($emailDetail, $emailConfig->admin_group); } } } }
function updateTaxParams($key, $value) { $params = $this->get('tax'); $params = oseObject::setValue($params, $key, $value); $this->set('tax', $params); }
function getExtSpecificPayment($node, $msc_id, $type, $osePaymentCurrency, $option) { $payment = oseRegistry::call('msc')->getExtInfo($msc_id, 'payment', 'array'); //$payment = oseJson::decode($payment->params,true); if (empty($payment)) { return false; } if (empty($option)) { $options = array_keys($payment); $option = $options[0]; } else { $options = array_keys($payment); //print_r($options); oseExit($option); if (count($options) > 0) { if (!in_array($option, $options)) { $option = $options[0]; } } else { return false; } } if (!isset($payment[$option])) { return false; } $payment = $payment[$option]; $node = oseObject::setValue($node, 'msc_option', $option); if (oseObject::getValue($payment, 'payment_mode') != $type && oseObject::getValue($payment, 'payment_mode') != 'b') { $type = oseObject::getValue($payment, 'payment_mode'); } $node = oseObject::setValue($node, 'has_trial', oseObject::getValue($payment, 'has_trial')); $node = oseObject::setValue($node, 'recurrence_mode', oseObject::getValue($payment, 'recurrence_mode')); $node = $this->getPriceStandard($node, $payment, $osePaymentCurrency); if (oseObject::getValue($payment, 'recurrence_mode') == 'fixed') { //$period = oseHtml::date( oseObject::getValue($payment,'start_date')).' - '. oseHtml::date( oseObject::getValue($payment,'expired_date')); $start_date = date("l,d F Y", strtotime(oseObject::getValue($payment, 'start_date'))); $expired_date = date("l,d F Y", strtotime(oseObject::getValue($payment, 'expired_date'))); if ($start_date == $expired_date) { $period = $start_date; } else { $period = $start_date . ' - ' . $expired_date; } $node = oseObject::setValue($node, 'standard_recurrence', $period); $node = oseObject::setValue($node, 'first_raw_price', oseObject::getValue($node, 'standard_raw_price')); $node = oseObject::setValue($node, 'second_raw_price', oseObject::getValue($node, 'standard_raw_price')); $node = oseObject::setValue($node, 'first_price', oseObject::getValue($node, 'standard_price')); $node = oseObject::setValue($node, 'second_price', $osePaymentCurrency . ' ' . oseObject::getValue($node, 'standard_raw_price')); $node = oseObject::setValue($node, 'p3', 0); $node = oseObject::setValue($node, 't3', 'week'); $node = oseObject::setValue($node, 'eternal', 0); $node = oseObject::setValue($node, 'start_date', oseObject::getValue($payment, 'start_date')); $node = oseObject::setValue($node, 'expired_date', oseObject::getValue($payment, 'expired_date')); } else { if (oseObject::getValue($payment, 'has_trial')) { $node = $this->getPriceTrial($node, $payment, $osePaymentCurrency); $node = oseObject::setValue($node, 'first_raw_price', oseObject::getValue($node, 'trial_raw_price')); $node = oseObject::setValue($node, 'second_raw_price', oseObject::getValue($node, 'standard_raw_price')); $node = oseObject::setValue($node, 'first_price', oseObject::getValue($node, 'trial_price')); $node = oseObject::setValue($node, 'second_price', oseObject::getValue($node, 'standard_price')); $node = oseObject::setValue($node, 'p1', oseObject::getValue($payment, 'p1')); $node = oseObject::setValue($node, 't1', oseObject::getValue($payment, 't1')); } else { $node = oseObject::setValue($node, 'first_raw_price', oseObject::getValue($node, 'standard_raw_price')); $node = oseObject::setValue($node, 'second_raw_price', oseObject::getValue($node, 'standard_raw_price')); $node = oseObject::setValue($node, 'first_price', oseObject::getValue($node, 'standard_price')); $node = oseObject::setValue($node, 'second_price', $osePaymentCurrency . ' ' . oseObject::getValue($node, 'standard_raw_price')); } $node = oseObject::setValue($node, 'p3', oseObject::getValue($payment, 'p3')); $node = oseObject::setValue($node, 't3', oseObject::getValue($payment, 't3')); $node = oseObject::setValue($node, 'eternal', oseObject::getValue($payment, 'eternal', 0)); } return $node; }
function saveCart($post) { $result = array(); $result['success'] = true; $result['reload'] = false; $result['script'] = false; $result['title'] = JText::_('SUCCESSFUL_ACTIVATION'); $result['content'] = JText::_('MEMBERSHIP_ACTIVATED_CONTINUE'); $juser = oseMscAddon::getPost('juser_', $post); $password1 = JRequest::getString('juser_password1', '', 'post', JREQUEST_ALLOWRAW); $password2 = JRequest::getString('juser_password2', '', 'post', JREQUEST_ALLOWRAW); if (oseObject::getValue($juser, 'firstname', false) && oseObject::getValue($juser, 'lastname', false)) { $juser['name'] = oseObject::getValue($juser, 'firstname', '') . ' ' . oseObject::getValue($juser, 'lastname', ''); } else { $juser['name'] = oseObject::getValue($juser, 'username', false); } $juser['password'] = $juser['password1'] = $password1; $juser['password2'] = $password2; $juser['email1'] = $juser['email']; $juser['email2'] = $juser['email']; // check unique username $list = oseMscAddon::getAddonList('registerOS_body', false, 1, 'obj'); foreach ($list as $addon) { $action_name = oseMscAddon::getActionName($addon, 'formValidate', 'register'); $updated = oseMscAddon::runAction($action_name, array('inner' => true)); if (!$updated['success']) { return $updated; } } if (!$updated['success']) { return $updated; } // check empty password if (empty($juser['password'])) { $result['success'] = false; $result['title'] = 'Error'; $result['content'] = JText::_('MUST_SUPPLY_PASSWORD'); return $result; } $register = oseMscPublic::juserRegister($juser); if (!oseObject::getValue($register, 'success', false)) { return $register; } else { $memConfig = oseMscConfig::getConfig('register', 'obj'); if ($memConfig->auto_login) { $result['reload'] = true; } $list1 = oseMscAddon::getAddonList('registerOS_header', false, 1, 'obj'); $list2 = oseMscAddon::getAddonList('registerOS_body', false, 1, 'obj'); $list3 = oseMscAddon::getAddonList('registerOS_footer', false, 1, 'obj'); $list = array_merge($list1, $list2, $list3); $user = oseObject::getValue($register, 'user'); $cart = oseMscPublic::getCart(); $items = $cart->get('items'); $item = $items[0]; $params = array(); $params['msc_id'] = oseMscPublic::getEntryMscId($item); $params['msc_option'] = oseObject::getValue($item, 'msc_option'); $params['payment_mode'] = $post['payment_payment_mode']; $params['member_id'] = $user->id; $params['payment_method'] = $post['payment_method']; foreach ($list as $addon) { $action_name = oseMscAddon::getActionName($addon, 'save', 'register'); $updated = oseMscAddon::runAction($action_name, $params); if (!$updated['success']) { return $updated; } } $emailConfig = oseMscConfig::getConfig('email', 'obj'); if (!empty($emailConfig->default_reg_email)) { $member = oseRegistry::call('member'); $email = $member->getInstance('email'); $emailTempDetail = $email->getDoc($emailConfig->default_reg_email, 'obj'); if (!empty($emailTempDetail)) { $variables = $email->getEmailVariablesRegistration($user->id); $variables['user'] = oseObject::setValue($variables['user'], 'password', $juser['password1']); $emailParams = $email->buildEmailParams($emailTempDetail->type); $emailDetail = $email->transEmail($emailTempDetail, $variables, $emailParams); $email->sendEmail($emailDetail, $user->email); if ($emailConfig->sendReg2Admin) { $email->sendToAdminGroup($emailDetail, $emailConfig->admin_group); } } } if ($memConfig->auto_login) { $isLogin = $this->login($juser['username'], $juser['password']); if (!$isLogin['success']) { $session = JFactory::getSession(); $return = $session->get('oseReturnUrl', base64_encode('index.php?option=com_osemsc&view=login')); $result['success'] = false; $result['title'] = 'Error'; $result['content'] = $isLogin['content']; $result['returnUrl'] = $return; return $result; } } return $result; } }
function getBillingInfo($type = 'array') { $db = oseDB::instance(); $query = " SELECT c.*,u.username,u.name,u.name AS jname, u.email AS user_email,u.id FROM `#__users` AS u" . " LEFT JOIN `#__osemsc_billinginfo` AS c ON c.user_id = u.id" . " WHERE u.id = " . (int) $this->user_id; $db->setQuery($query); $item = oseDB::loadItem($type); $item = oseObject::setValue($item, 'user_id', oseObject::getValue($item, 'id', 0)); return $item; }
function getEmails($email_type, $start, $limit, $type = 'array') { $db = oseDB::instance(); $where = array(); $items = array(); $item = $type == 'array' ? array() : new stdClass(); $item = oseObject::setValue($item, 'id', '0'); $item = oseObject::setValue($item, 'subject', 'None'); $items[] = $item; if (!empty($email_type)) { $where[] = ' type = ' . $db->Quote($email_type); } $where = oseDB::implodeWhere($where); $query = " SELECT * FROM `#__osemsc_email` " . $where; $db->setQuery($query, $start, $limit); $items = oseDB::loadList($type); $result = array(); $result['total'] = $this->getTotal($email_type); $result['results'] = $items; return $result; }
function setCartItems($items, $vkey, $value) { if (count($items) > 0) { foreach ($items as $key => $item) { $item = oseObject::setValue($item, $vkey, $value); $items[$key] = $item; } } $this->set('items', $items); }