public static function save($params) {
$result = array();
$post = JRequest::get('post');
$member_id = $params['member_id'];
JRequest::setVar('member_id', $member_id);
if (empty($member_id)) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error');
return $result;
}
$db = oseDB::instance();
$firstname = $db->Quote(oseObject::getValue($post, 'juser_firstname', $post['juser_username']));
$lastname = $db->Quote(oseObject::getValue($post, 'juser_lastname'));
$query = " SELECT COUNT(*) FROM `#__osemsc_userinfo` WHERE user_id = ". (int)$member_id;
$db->setQuery($query);
$exists = ($db->loadResult() > 0) ? true : false;
if ($exists) {
return array('success' => true);
} else {
$query = " INSERT INTO `#__osemsc_userinfo` (user_id,firstname,lastname)"
. " VALUES" . " ({$member_id},{$firstname},{$lastname})";
$db->setQuery($query);
if (!oseDB::query()) {
$result = array();
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Fail Saving OSE User Info.');
return $result;
}
return array('success' => true);
}
}
function add($level_name)
{
$db = oseDB::instance();
$level_name = $db->Quote($level_name);
$query = "SELECT * FROM `#__groups` WHERE `name` = " . $level_name;
$db->setQuery($query);
$item = $db->loadObject();
$result = array();
if (empty($item)) {
$query = " SELECT id FROM `#__groups` " . " ORDER BY id DESC";
$db->setQuery($query);
$oid = $db->loadResult();
$nid = $oid + 1;
$query = "INSERT INTO `#__groups` (`id`,`name`) VALUES ({$nid}, {$level_name});";
$db->setQuery($query);
if (oseDB::query()) {
$result['success'] = true;
$result['title'] = 'Done';
$result['content'] = JText::_("Added successfully");
} else {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_("Failed adding ACL group.");
}
} else {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_("Failed adding ACL group.");
}
return $result;
}
function save($post)
{
$post = JRequest::get('post');
$addon_id = JRequest::getInt('addon_id', 0);
unset($post['addon_id']);
$addon = array();
foreach ($post as $key => $value) {
if (strstr($key, 'addon_')) {
$billKey = preg_replace('/addon_/', '', $key, 1);
$addon[$billKey] = $value;
}
}
//oseExit($company);
$db = oseDB::instance();
if (empty($addon_id)) {
$keys = array_keys($addon);
$keys = '`' . implode('`,`', $keys) . '`';
$fields = $db->getTableFields('#__osemsc_addon');
foreach ($addon as $key => $value) {
if (!isset($fields['#__osemsc_addon'][$key])) {
/*
$query = "ALTER TABLE `#__osemsc_billinginfo` ADD `{$key}` TEXT NULL DEFAULT NULL";
$db->setQuery($query);
if (!$db->query())
{
return false;
}
*/
unset($addon[$key]);
}
}
foreach ($addon as $key => $value) {
$addon[$key] = $db->Quote($value);
}
$values = implode(',', $addon);
$query = "INSERT INTO `#__osemsc_addon` ({$keys}) VALUES ({$values});";
$db->setQuery($query);
if (!oseDB::query()) {
$result = array();
return false;
}
oseMscAddon::reorder($post['addon_type']);
} else {
foreach ($addon as $key => $value) {
$addon[$key] = "`{$key}`=" . $db->Quote($value);
}
$values = implode(',', $addon);
$query = " UPDATE `#__osemsc_addon` SET {$values}" . " WHERE `id` ={$addon_id}";
$db->setQuery($query);
if (!oseDB::query()) {
$result = array();
return false;
}
$ordering = JRequest::getInt('ordering', 0);
$this->updateOrder($addon_id, $ordering);
}
//echo $query;exit;
return true;
}
public static function save($params) {
$result = array();
$result['success'] = true;
if (empty($params['allow_work'])) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error Join.Order.1');
return $result;
}
unset($params['allow_work']);
if ($params['join_from'] != 'payment') {
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_('Done Join.Order');
return $result;
}
$db = oseDB::instance();
$msc_id = $params['msc_id'];
$member_id = $params['member_id'];
$order_id = $params['order_id'];
$order_item_id = $params['order_item_id'];
$where = array();
$where[] = "order_id = {$order_id}";
$payment = oseRegistry::call('payment');
$curOrder = $payment->getOrder($where, 'obj');
$member = oseRegistry::call('member');
$member->instance($member_id);
$memParams = $member->getMemberInfo($msc_id, 'obj')->memParams;
if (empty($memParams)) {
$memParams = new stdClass();
} else {
$memParams = oseJSON::decode($memParams);
}
$memParams->order_id = $order_id;
$memParams->payment_mode = $curOrder->payment_mode;
$memParams->order_item_id = $order_item_id;
// Order problem for system add
$memParams = oseJSON::encode($memParams);
$query = " UPDATE `#__osemsc_member`" . " SET `params` = " . $db->Quote($memParams) . " WHERE msc_id = {$msc_id} AND member_id = {$member_id}";
$memConfig = oseMscConfig::getConfig('register', 'obj');
$db->setQuery($query);
if (!oseDB::query()) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error Join.Order.2');
}
// User activation function;
$params = JComponentHelper::getParams('com_users');
$useractivation = $params->get('useractivation');
if (oseObject::getValue($memConfig, 'disabled_non_paid', false) == true) {
if ($useractivation == 0) {
$query = " UPDATE `#__users` SET `block` = 0 where `id` = " . $member_id;
$db->setQuery($query);
$db->query();
}
}
return $result;
}
public static function save($params)
{
$result = array();
$result['success'] = true;
if(empty($params['allow_work']))
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_("Error");
return $result;
}
unset($params['allow_work']);
//oseExit($params);
$db = oseDB::instance();
$post = JRequest::get('post');
$msc_id = $params['msc_id'];
$member_id = $params['member_id'];
if(empty($msc_id))
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_("Join History: No Membership ");
}
$history = oseRegistry::call('member')->getInstance('History');
$updated = $history->record($msc_id,$member_id,'join');
if(!$updated)
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_(" Fail Record Member's Footprint! ");
}
// Order problem for system add
$hisParams = oseJSON::encode(array('order_id' => $params['order_id']));
$query = " UPDATE `#__osemsc_member_history`"
." SET params = ".$db->Quote($hisParams)
." WHERE id = {$updated}"
;
$db->setQuery($query);
//oseExit($db->_sql);
if(!oseDB::query())
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error Join.Order.2');
}
return $result;
}
public static function save($params = array())
{
$db = oseDB::instance();
$post = JRequest::get('post');
$id = JRequest::getCmd('id', null);
$msc_id = JRequest::getInt('msc_id', 0);
if (empty($id)) {
$id = uniqid();
}
$extItem = oseRegistry::call('msc')->getExtInfoItem($msc_id, 'acymailing2', 'obj');
$extItem->params = empty($extItem->params) ? '{}' : $extItem->params;
$items = oseJson::decode($extItem->params, true);
$where = array();
$msc_id = isset($msc_id) ? $msc_id : null;
if (empty($msc_id)) {
return false;
// No membership exists in the addon
} else {
unset($post['msc_id']);
$where[] = 'id = ' . $db->Quote($msc_id);
}
$where[] = 'type = ' . $db->Quote('acymailing2');
$params = array();
$prefix = 'acymailing2_';
foreach ($post as $key => $value) {
if (strstr($key, $prefix)) {
$newKey = preg_replace("/{$prefix}/", '', $key, 1);
$params[$newKey] = $value;
}
}
ksort($params);
$params['id'] = $id;
$items[$id] = $params;
$newParams = $db->Quote(oseJson::encode($items));
$where = oseDB::implodeWhere($where);
$query = " SELECT * FROM `#__osemsc_ext` " . $where;
$db->setQuery($query);
$obj = oseDB::loadItem('obj');
if (empty($obj)) {
$query = " INSERT INTO `#__osemsc_ext` " . " (id,type,params)" . " VALUES " . " ({$msc_id}," . $db->Quote('acymailing2') . ",{$newParams}) ";
$db->setQuery($query);
//oseExit($db->_sql);
} else {
$query = " UPDATE `#__osemsc_ext` " . " SET " . " params = {$newParams} " . " WHERE id = {$obj->id}" . " AND type = " . $db->Quote('acymailing2');
$db->setQuery($query);
}
if (oseDB::query()) {
$result['success'] = true;
$result['title'] = JText::_('Finished');
$result['content'] = JText::_('Save Successfully!');
} else {
$result['success'] = false;
$result['title'] = JText::_('Error');
$result['content'] = JText::_('Error in Saving License Parameters');
}
return $result;
}
function remove($id)
{
$db = oseDB::instance();
$query = " DELETE FROM `#__osemsc_coupon` " . " WHERE id = '{$id}'";
$db->setQuery($query);
if (oseDB::query()) {
$query = " DELETE FROM `#__osemsc_coupon_user` " . " WHERE coupon_id = '{$id}'";
$db->setQuery($query);
return oseDB::query();
} else {
return false;
}
}
public static function archive($msc_id, $member_id, $action)
{
$db = oseDB::instance();
$date = oseHTML::getDateTime();
$date = $db->Quote($date);
$query = " INSERT INTO `#__osemsc_member_history` " . " (`msc_id`,`member_id`,`action`,`date`, `accumulated`) " . " VALUES " . " ({$msc_id},{$member_id},'{$action}',{$date}, '0') ";
$db->setQuery($query);
if (oseDB::query()) {
return $db->insertid();
} else {
return false;
}
}
function getUserInfo()
{
$db = oseDB::instance();
$query = " SELECT * FROM `#__osemsc_userinfo_view` WHERE `user_id` = " . (int) $this->user_id;
$db->setQuery($query);
$item = oseDB::loadItem('obj');
if (empty($item)) {
$query = " INSERT INTO `#__osemsc_userinfo` (`user_id`) VALUES (" . (int) $this->user_id . ")";
$db->setQuery($query);
oseDB::query();
$item = self::getUserInfo();
}
return $item;
}
public static function companySave($params)
{
if (empty($params['allow_work'])) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_("Error");
return $result;
}
unset($params['allow_work']);
$db = oseDB::instance();
$post = JRequest::get('post');
$member_id = $params['member_id'];
//JRequest::setVar('member_id',$member_id);
if (empty($member_id)) {
return false;
}
$company = array();
foreach ($post as $key => $value) {
if (strstr($key, 'company_')) {
$billKey = preg_replace('/company_/', '', $key, 1);
$company[$billKey] = $value;
}
}
//get vm country code
$query = " SELECT country_3_code FROM `#__vm_country` WHERE `country_2_code` = '{$company['country']}'";
$db->setQuery($query);
$country_code = $db->loadResult();
$company['country'] = empty($country_code) ? $company['country'] : $country_code;
//get vm state code
$query = " SELECT state_2_code FROM `#__vm_state` WHERE `state_name` = '{$company['state']}'";
$db->setQuery($query);
$state_code = $db->loadResult();
$company['state'] = empty($state_code) ? $company['state'] : $state_code;
$query = " UPDATE `#__vm_user_info` " . " SET `company` = '{$company['company']}', `phone_1` = '{$company['telephone']}', `address_1` = '{$company['addr1']}', `address_2` = '{$company['addr2']}', `city` = '{$company['city']}', `state` = '{$company['state']}', `country` = '{$company['country']}', `zip` = '{$company['postcode']}' " . " WHERE `user_id` = '{$member_id}' AND `address_type` = 'BT' ";
$db->setQuery($query);
if (!oseDB::query()) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Fail Saving Company info.');
return $result;
}
$result = array();
$result['success'] = true;
$result['title'] = 'Done';
$result['content'] = JText::_('Saved Company Info.');
return $result;
}
public static function save($params)
{
$result = array();
$result['success'] = true;
//oseExit($params);
if (empty($params['allow_work'])) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error Join.Order.1');
return $result;
}
unset($params['allow_work']);
if ($params['join_from'] != 'payment') {
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_('Done Join.Order');
return $result;
}
$db = oseDB::instance();
//$post = JRequest::get('post');
$msc_id = $params['msc_id'];
$member_id = $params['member_id'];
$order_id = $params['order_id'];
$where = array();
$where[] = "order_id = {$order_id}";
$payment = oseRegistry::call('payment');
$curOrder = $payment->getOrder($where, 'obj');
$member = oseRegistry::call('member');
$member->instance($member_id);
$memParams = $member->getMemberInfo($msc_id, 'obj')->memParams;
$memParams = oseJSON::decode($memParams);
$memParams->order_id = $order_id;
$memParams->payment_mode = $curOrder->payment_mode;
// Order problem for system add
$memParams = oseJSON::encode($memParams);
$query = " UPDATE `#__osemsc_member`" . " SET params = " . $db->Quote($memParams) . " WHERE msc_id = {$msc_id} AND member_id = {$member_id}";
$db->setQuery($query);
//oseExit($db->_sql);
if (!oseDB::query()) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error Join.Order.2');
}
return $result;
}
public static function renew($params)
{
$result = array();
$result['success'] = true;
if (empty($params['allow_work'])) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error Renew.Order');
return $result;
}
unset($params['allow_work']);
if ($params['join_from'] != 'payment') {
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_("Success");
return $result;
}
$db = oseDB::instance();
$msc_id = $params['msc_id'];
$member_id = $params['member_id'];
$query = " SELECT mm.link_id " . " FROM `#__osemsc_mtrel` AS mm" . " INNER JOIN `#__osemsc_directory` AS directory ON directory.directory_id = mm.directory_id" . " INNER JOIN `#__oselic_cs_company` AS lcc ON lcc.company_id = directory.company_id" . " WHERE lcc.user_id = {$member_id}";
$db->setQuery($query);
$link_id = $db->loadResult();
//oseExit($db->_sql);
if (empty($link_id)) {
return $result;
}
$member = oseRegistry::call('member');
$member->instance($member_id);
$memInfo = $member->getMemberInfo($msc_id, 'obj');
$query = " UPDATE `#__mt_links`" . " SET `publish_down` = " . $db->Quote($memInfo->expired_date) . " WHERE link_id = {$link_id}";
$db->setQuery($query);
if (oseDB::query()) {
return $result;
} else {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_("cancel.directory");
return $result;
}
}
private static function joinInAutomaticMode($msc_id, $member_id, $orderInfo)
{
$db = oseDB::instance();
$result = array();
$result['success'] = true;
$orderParams = oseJSON::decode($orderInfo->params);
$start_date = oseHTML::getDateTime();
$start_date = $db->Quote($start_date);
if ($orderParams->has_trial) {
$recurrence_num = $orderParams->p1 + 1;
$recurrence_unit = $orderParams->t1;
} else {
$recurrence_num = $orderParams->p3 + 1;
$recurrence_unit = $orderParams->t3;
}
$expired_date = " DATE_ADD({$start_date},INTERVAL {$recurrence_num} {$recurrence_unit}) ";
$query = " UPDATE `#__osemsc_member` " . " SET start_date = {$start_date} , expired_date = {$expired_date}" . " WHERE member_id = {$member_id} AND msc_id = {$msc_id} ";
$db->setQuery($query);
if (!oseDB::query()) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_(' Fail Updated Member\'s Recurrence ');
return $result;
}
return $result;
}
function delete()
{
$db = oseDB::instance();
$query = " SELECT `id` FROM `{$this->_table}`" . " WHERE lft BETWEEN {$this->lft} AND {$this->rgt}";
$db->setQuery($query);
$ids = $db->loadResultArray();
JArrayHelper::toInteger($ids);
$ids = implode(',', $ids);
$updated = parent::delete();
if ($updated) {
foreach ($this->_type as $k => $o) {
$class = $this->getTypeItem($o->id);
$query = " DELETE FROM `" . $class->get('_table') . "`" . " WHERE `plan_id` IN ({$ids})";
$db->setQuery($query);
oseDB::query();
}
}
return $updated;
/*
$updated = oseDB::delete($this->_table,array('id'=>$this->get('id')));
if($updated)
{
foreach($this->_type as $k => $o)
{
$class = $this->getTypeItem($o->id);
$class->delete();
}
}
return $updated;*/
}
public static function save($params)
{
if(!class_exists('oseMscPublic'))
{
require_once(OSEMSC_F_HELPER.DS.'oseMscPublic.php');
}
$result = array();
$result['success'] = true;
//oseExit($params);
if(empty($params['allow_work']))
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error Join.PAP');
return $result;
}
unset($params['allow_work']);
/* Offline payments should be counted as well; removed from v 6.0.5
if( $params['join_from'] != 'payment')
{
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_('Done Join.Order');
return $result;
}
*/
$oseMscConfig = oseRegistry::call('msc')->getConfig('thirdparty','obj');
if(empty($oseMscConfig->pap_enable))
{
return $result;
}
if(empty($oseMscConfig->pap_url))
{
return $result;
}
$db = oseDB::instance();
//$post = JRequest::get('post');
$msc_id = $params['msc_id'];
$member_id = $params['member_id'];
$order_id = $params['order_id'];
$order_item_id = $params['order_item_id'];
$where = array();
$where[] = "order_id = {$order_id}";
$payment = oseRegistry::call('payment');
$curOrder = $payment->getOrder($where,'obj');
$curOrderParams = oseJson::decode($curOrder->params);
$recurrence_times = ($curOrderParams->has_trial)?$curOrderParams->recurrence_times+1:$curOrderParams->recurrence_times;
$member = oseRegistry::call('member');
$member->instance($member_id);
$userInfo = $member->getUserInfo('obj');
$memParams = $member->getMemberInfo($msc_id,'obj')->memParams;
$memParams = oseJSON::decode($memParams);
$memParams->first_ip = oseObject::getValue($curOrderParams,'first_ip');;
if(empty($curOrderParams->pap_visitorid))
{
return $result;
//$memParams->pap_visitorid = 'paypal';
}
else
{
$memParams->pap_visitorid = $curOrderParams->pap_visitorid;
//$memParams->pap_visitorid = $_COOKIE['PAPVisitorId'];
}
$memParams_encode = oseJSON::encode($memParams);
$query = " UPDATE `#__osemsc_member`"
." SET params = ".$db->Quote($memParams_encode)
." WHERE msc_id = {$msc_id} AND member_id = {$member_id}"
;
$db->setQuery($query);
//oseExit($db->_sql);
if(!oseDB::query())
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error Join.Order.2');
return $result;
}
try {
require_once(OSEMSC_B_LIB.DS.'PapApi.class.php');
$saleTracker = new Pap_Api_SaleTracker($oseMscConfig->pap_url.'/scripts/sale.php');
$saleTracker->setAccountId(oseObject::getValue($oseMscConfig,'pap_account_id','default1'));
$saleTracker->setVisitorId($memParams->pap_visitorid);
$sale1 = $saleTracker->createSale();
$msc = oseRegistry::call('msc');
$where = array();
$where[] = "`order_item_id` = '{$order_item_id}'";
$curOrderItem = $payment->getInstance('Order')->getOrderItem($where,'obj');
$curOrderItemParams = oseJson::decode($curOrderItem->params);
$node = $msc->getInfo($msc_id,'obj');
$paymentInfos = $msc->getExtInfo($msc_id,'payment');
foreach($paymentInfos as $key => $paymentInfo)
{
if($key != $curOrderItemParams->msc_option)
{
unset($paymentInfos[$key]);
}
}
$cart = oseMscPublic::getCart();
$osePaymentCurrency = $cart->get('currency');
$items = $cart->get('items');
$options = oseMscPublic::generatePriceOption($node,$paymentInfos,$osePaymentCurrency);
$sale1->setTotalCost($curOrder->payment_price);
$sale1->setOrderID($order_id);
$sale1->setProductID("{$node->title}-{$options[0]['title']}");
$sale1->setData1($userInfo->email);
$sale1->setData2($userInfo->jname);
$sale1->setData3($memParams->first_ip);
$sale1->setData4($curOrder->payment_serial_number);
$sale1->setData5("{$curOrder->order_id}-{$node->title}-{$options[0]['title']}-#recurrence:{$recurrence_times}");
$saleTracker->register();
//$memParams->pap_affiliate_id = $sale1->getAffiliateId();
//$memParams->pap_campaign_id = $sale1->getCampaignId();
//$memParams->pap_banner_id = $sale1->getBannerId();
// Order problem for system add
return $result;
} catch (Exception $e) {
return $result;
}
}
function removeAllCurrency()
{
$db = oseDB::instance();
$query = " SELECT * FROM `#__osemsc_configuration`" . " WHERE `key` = 'primary_currency' AND `type` = 'currency'";
$db->setQuery($query);
$item = oseDB::loadItem('obj');
//$currencyInfos = oseJson::decode($item->default,true);
//unset($currencyInfos[$currency]);
$currencyInfos = oseJson::encode(null);
$query = " UPDATE `#__osemsc_configuration`" . " SET `default` = " . $db->Quote($currencyInfos) . " WHERE `id` = '{$item->id}'";
$db->setQuery($query);
return oseDB::query();
}
public static function removeMtCat()
{
$result = array();
$cl_id = JRequest::getInt('cl_id', 0);
$cat_id = JRequest::getInt('cat_id', 0);
$db = oseDB::instance();
$query = " DELETE FROM `#__mt_cl`" . " WHERE `cl_id` = '{$cl_id}'";
$db->setQuery($query);
if (!oseDB::query()) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error.');
} else {
$result['success'] = true;
$result['title'] = 'Done';
$result['content'] = JText::_('Deleted.');
}
return $result;
}
public static function save()
{
$post = JRequest::get('post');
if (!empty($post['firstname'])) {
$post['bill_firstname'] = $post['firstname'];
}
if (!empty($post['lastname'])) {
$post['bill_lastname'] = $post['lastname'];
}
$member_id = JRequest::getInt('member_id', 0);
$billinfo = array();
foreach ($post as $key => $value) {
if (strstr($key, 'bill_')) {
$billKey = str_replace('bill_', '', $key);
$billinfo[$billKey] = $value;
}
}
//oseExit($billinfo);
$db = oseDB::instance();
$query = " SELECT count(*) FROM `#__osemsc_billinginfo` WHERE user_id='{$member_id}'";
$db->setQuery($query);
$num = $db->loadResult();
$my = JFactory::getUser();
if (empty($num)) {
$keys = array_keys($billinfo);
$keys = '`' . implode('`,`', $keys) . '`';
$fields = oseDB::getDBFields('#__osemsc_billinginfo');
foreach ($billinfo as $key => $value) {
if (!isset($fields['#__osemsc_billinginfo'][$key])) {
if ($my->get('gid') == 24 || $my->get('gid') == 25) {
$query = "ALTER TABLE `#__osemsc_billinginfo` ADD `{$key}` TEXT NULL DEFAULT NULL";
$db->setQuery($query);
if (!oseDB::query()) {
$result['success'] = false;
$result['title'] = JText::_('ERROR');
$result['content'] = JText::_('FAIL_SAVING_OSEMSC_USER_INFO');
}
} else {
unset($billinfo[$key]);
}
}
}
foreach ($billinfo as $key => $value) {
$billinfo[$key] = !empty($value) ? $db->Quote($value) : null;
}
$values = implode(',', $billinfo);
$query = "INSERT INTO `#__osemsc_billinginfo` (`user_id`,{$keys}) VALUES ('{$member_id}',{$values});";
} else {
foreach ($billinfo as $key => $value) {
$billinfo[$key] = "`{$key}`=" . $db->Quote($value);
}
$values = implode(',', $billinfo);
$query = " UPDATE `#__osemsc_billinginfo` SET {$values}" . " WHERE `user_id` ={$member_id}";
}
//echo $query;exit;
$db->setQuery($query);
if (!oseDB::query()) {
$result = array();
$result['success'] = true;
$result['title'] = JText::_('DONE');
$result['content'] = JText::_('FAIL_SAVING_OSEMSC_USER_INFO');
} else {
$result = array();
$result['success'] = true;
$result['title'] = JText::_('DONE');
$result['content'] = JText::_('SAVED_USER_BILLING_INFO');
}
return $result;
}
function updateMembership($msc_id, $user_id, $order_id, $payment_mode)
{
$db = oseDB::instance();
$params['order_id'] = $order_id;
$params['payment_mode'] = $payment_mode;
$params = oseJSON::encode($params);
$query = " UPDATE `#__osemsc_member` SET `params`='{$params}' WHERE `msc_id` = '{$msc_id}' AND `member_id` = '{$user_id}'";
$db->setQuery($query);
if (oseDB::query()) {
return true;
} else {
return false;
}
}
public static function licSave($params = array())
{
$post = $params;
$my = JFactory::getUser();
$member_id = $post['member_id'];
$billinfo = array();
foreach ($post as $key => $value) {
if (strstr($key, 'bill_')) {
$billKey = str_replace('bill_', '', $key);
$billinfo[$billKey] = $value;
}
}
//oseExit($billinfo);
$db = oseDB::instance();
$member_id = JRequest::getInt('member_id', 0);
$query = " SELECT count(*) FROM `#__osemsc_billinginfo` WHERE user_id='{$member_id}'";
$db->setQuery($query);
$num = $db->loadResult();
if (empty($num)) {
$keys = array_keys($billinfo);
$keys = '`' . implode('`,`', $keys) . '`';
$fields = $db->getTableFields('#__osemsc_billinginfo');
foreach ($billinfo as $key => $value) {
if (!isset($fields['#__osemsc_billinginfo'][$key])) {
$query = "ALTER TABLE `#__osemsc_billinginfo` ADD `{$key}` TEXT NULL DEFAULT NULL";
$db->setQuery($query);
if (!$db->query()) {
return false;
}
}
}
foreach ($billinfo as $key => $value) {
$billinfo[$key] = $db->Quote($value);
}
$values = implode(',', $billinfo);
$query = "INSERT INTO `#__osemsc_billinginfo` (`user_id`,{$keys}) VALUES ('{$member_id}',{$values});";
} else {
foreach ($billinfo as $key => $value) {
$billinfo[$key] = "`{$key}`=" . $db->Quote($value);
}
$values = implode(',', $billinfo);
$query = " UPDATE `#__osemsc_billinginfo` SET {$values}" . " WHERE `user_id` ={$member_id}";
}
//echo $query;exit;
$db->setQuery($query);
return oseDB::query();
}
protected function apiCheck($oItem)
{
$result = array();
$db = oseDB::instance();
static $arb;
$oseMscConfig = oseMscConfig::getConfig('payment', 'obj');
// Authorize setting
if (!defined('AUTHORIZENET_API_LOGIN_ID')) {
define("AUTHORIZENET_API_LOGIN_ID", oseObject::getValue($oseMscConfig, 'an_loginid'));
}
if (!defined('AUTHORIZENET_TRANSACTION_KEY')) {
define("AUTHORIZENET_TRANSACTION_KEY", oseObject::getValue($oseMscConfig, 'an_transkey'));
}
if (!$arb instanceof AuthnetARB) {
$arb = new AuthnetARB();
$arb->url = "apitest.authorize.net";
$arb->login = AUTHORIZENET_API_LOGIN_ID;
$arb->transkey = AUTHORIZENET_TRANSACTION_KEY;
}
// End
// init Beanstream
// End
$oParams = oseJson::decode($oItem->params);
if ($oItem->payment_method == 'paypal') {
$user = JFactory::getUser($oItem->user_id);
$postVar = array();
//$start_time_o = '2012-05-01 00:00:00';
$start_time = strtotime("-1 year");
$iso_start = date('Y-m-d\\T00:00:00\\Z', $start_time);
$end_time = strtotime('2011-04-01 00:00:00');
$iso_end = date('Y-m-d\\T24:00:00\\Z', $end_time);
$postVar['METHOD'] = 'TransactionSearch';
$postVar['STARTDATE'] = $iso_start;
//$postVar['INVNUM'] = $oItem->order_number;
$postVar['EMAIL'] = empty($oItem->email) ? $user->email : $oItem->email;
//oseExit($postVar);
$postString = null;
foreach ($postVar as $key => $val) {
$postString .= "&" . urlencode($key) . "=" . urlencode($val);
}
$resArray = self::PaypalAPIConnect($postString);
//$resArray1= self :: PaypalAPIConnect1($postString);
//if( in_array('Failure',array($resArray['ACK'],$resArray1['ACK']) ))
if (in_array('Failure', array($resArray['ACK']))) {
$result['finish'] = false;
$result['success'] = false;
$result['title'] = JText::_('ERROR');
$result['content'] = urldecode($resArray['L_LONGMESSAGE0']);
return $result;
}
/*if(!empty($resArray['L_STATUS0']))
{
if( !empty($resArray1['L_STATUS0']) )
{
$ed = date_create( urldecode($resArray['L_TIMESTAMP0'] ));
$ed = date_format($ed, 'Y-m-d H:i:s');
$ed1 = date_create( urldecode($resArray1['L_TIMESTAMP0'] ));
$ed1 = date_format($ed1, 'Y-m-d H:i:s');
if($ed < $ed1)
{
$resArray = $resArray1;
}
}
}
elseif( !empty($resArray1['L_STATUS0']) )
{
$resArray = $resArray1;
}*/
//oseExit($resArray);
if (!empty($resArray['L_STATUS0'])) {
$trnArray = array();
foreach ($resArray as $k => $v) {
if (strpos($k, 'L_STATUS') !== false) {
$trnArray[$k] = $v;
} else {
continue;
}
}
$success = false;
$next = false;
foreach ($trnArray as $k => $v) {
if ($next) {
$next = false;
continue;
}
$nk = str_replace('L_STATUS', '', $k);
if ($v == 'Completed' || $v == 'Unclaimed') {
$success = true;
$expDate = urldecode($resArray['L_TIMESTAMP' . $nk]);
$expDate = new DateTime($expDate);
$expired_date = $expDate->format('Y-m-d H:i:s');
$recurrence_num = oseObject::getValue($oParams, 'p3');
$recurrence_unit = oseObject::getValue($oParams, 't3');
$expired_date = " DATE_ADD('{$expired_date}' ,INTERVAL {$recurrence_num} {$recurrence_unit}) ";
$query = " UPDATE `#__osemsc_member` " . " SET `eternal`=0, `expired_date` = {$expired_date}" . " WHERE `id` = '{$oItem->member_id}'";
$db->setQuery($query);
$updated = oseDB::query();
$query = " UPDATE `#__osemsc_member` " . " SET `status` = 1 " . " WHERE `id` = '{$oItem->member_id}' AND `expired_date` > NOW()";
$db->setQuery($query);
$updated = oseDB::query();
$ofVals = array();
$ofVals['id'] = $oItem->fix_id;
$ofVals['status'] = 'fixed';
oseDB::update("#__osemsc_order_fix", 'id', $ofVals);
$ofVals = array();
$ofVals['order_id'] = $oItem->order_id;
$query = " SELECT COUNT(*) FROM `#__osemsc_member`" . " WHERE `id` = '{$oItem->member_id}' AND `expired_date` > NOW()";
$db->setQuery($query);
$needChanged = $db->loadResult();
if ($needChanged > 0 && $v == 'Completed') {
$ofVals['order_status'] = 'confirmed';
} elseif ($v == 'Unclaimed') {
$ofVals['order_status'] = 'confirmed';
} else {
$ofVals['order_status'] = 'skipped';
}
oseDB::update("#__osemsc_order", 'order_id', $ofVals);
$result['finish'] = true;
$result['success'] = true;
$result['title'] = JText::_('SUCCESS');
$result['content'] = JText::_('SUCCESS');
break;
} elseif ($v == 'Unclaimed1') {
if ($k == 0) {
$ofVals = array();
$ofVals['order_id'] = $oItem->order_id;
$ofVals['order_status'] = 'skipped';
oseDB::update("#__osemsc_order", 'order_id', $ofVals);
}
continue;
} else {
if ($k == 0) {
$ofVals = array();
$ofVals['order_id'] = $oItem->order_id;
$ofVals['order_status'] = 'skipped';
//oseDB::update("#__osemsc_order",'order_id',$ofVals);
}
continue;
$next = true;
}
}
if (!$success) {
$vals['id'] = $obj->id;
$vals['virtual_status'] = 0;
//$vals['status'] = 0;
$vals['eternal'] = 0;
$vals['expired_date'] = oseHtml::getDateTime();
//oseDB::update('#__osemsc_member','id',$vals);
$result['finish'] = true;
$result['success'] = false;
$result['title'] = JText::_('ERROR');
if (count($trnArray) > 3) {
$result['content'] = JText::_('Maybe the subscription is cancelled');
} elseif (count($trnArray) == 3) {
$result['content'] = JText::_('Maybe the first payment is cancelled');
} else {
$vals = array();
$vals['id'] = $oItem->member_id;
$vals['virtual_status'] = 0;
//$vals['status'] = 0;
$vals['eternal'] = 0;
//$vals['expired_date'] = oseHtml::getDateTime();
oseDB::update('#__osemsc_member', 'id', $vals);
$result['content'] = JText::_('No Success Payment has been searched from ') . $start_time;
}
}
/*
if( $resArray['L_STATUS0'] == 'Completed' )
{
$expDate = urldecode($resArray['L_TIMESTAMP0']);
$expDate = new DateTime($expDate);
$expired_date = $expDate->format('Y-m-d H:i:s');
$recurrence_num = oseObject::getValue($oParams, 'p3');
$recurrence_unit = oseObject::getValue($oParams, 't3');
$expired_date = " DATE_ADD('{$expired_date}' ,INTERVAL {$recurrence_num} {$recurrence_unit}) ";
//oseExit($expired_date);
$query = " UPDATE `#__osemsc_member` "
." SET `status` = 1 ,`eternal`=0, `expired_date` = {$expired_date}"
." WHERE `id` = '{$oItem->member_id}'"
;
$db->setQuery($query);
$updated = oseDB::query();
$ofVals = array();
$ofVals['id'] = $oItem->fix_id;
$ofVals['status'] = 'fixed';
oseDB::update("#__osemsc_order_fix",'id',$ofVals);
$result['finish'] = false;
$result['success'] = true;
$result['title'] = JText::_('SUCCESS');
$result['content'] = JText::_('SUCCESS');
}
// mark it expired
else
{
$vals['id'] = $obj->id;
$vals['virtual_status'] = 0;
//$vals['status'] = 0;
$vals['eternal'] = 0;
$vals['expired_date'] = oseHtml::getDateTime();
//oseDB::update('#__osemsc_member','id',$vals);
$result['finish'] = true;
$result['success'] = true;
$result['title'] = JText::_('SUCCESS');
$result['content'] = JText::_('SUCCESS');
}*/
} else {
// mark it expired
$vals['id'] = $obj->id;
$vals['virtual_status'] = 0;
//$vals['status'] = 0;
$vals['eternal'] = 0;
$vals['expired_date'] = oseHtml::getDateTime();
//oseDB::update('#__osemsc_member','id',$vals);
$result['finish'] = true;
$result['success'] = true;
$result['title'] = JText::_('SUCCESS');
$result['content'] = JText::_('SUCCESS');
}
return $result;
} else {
$result['success'] = false;
$result['title'] = JText::_('ERROR');
$result['content'] = JText::_('Only Support Paypal Recurring Payment');
return $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 save( $params )
{
//$post = JRequest::get('post');
$member_id = $params['member_id'];
if(empty($member_id))
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText :: _('Error');
return $result;
}
$post = JRequest::get('post');
$bill = array();
foreach($post as $key => $value)
{
if(strstr($key,'bill_'))
{
$billKey = preg_replace('/bill_/','',$key,1);
$bill[$billKey] = $value;
}
}
$bill['firstname'] = $post['juser_firstname'];
$bill['lastname'] = $post['juser_lastname'];
//oseExit($billinfo);
$db = oseDB::instance();
$query = " SELECT count(*) FROM `#__osemsc_billinginfo` WHERE user_id='{$member_id}'";
$db->setQuery($query);
$num = $db->loadResult();
//oseExit($db->_sql);
if (empty ($num)) {
$keys = array_keys($bill);
$keys = '`'.implode('`,`',$keys).'`';
$fields = $db->getTableFields('#__osemsc_billinginfo');
foreach($bill as $key => $value)
{
$my = JFactory::getUser();
if(oseMscPublic::isUserAdmin($my))
{
if(!isset($fields['#__osemsc_billinginfo'][$key]))
{
$query = "ALTER TABLE `#__osemsc_billinginfo` ADD `{$key}` TEXT NULL DEFAULT NULL";
$db->setQuery($query);
if (!oseDB::query())
{
$result['success'] = false;
$result['title'] = JText::_('Error');
$result['content'] = JText::_('Fail Saving Joomla User Info.');
}
}
}
else
{
if($key == 'vat_number')
{
if(!isset($fields['#__osemsc_billinginfo']['vat_number']))
{
$query = "ALTER TABLE `#__osemsc_billinginfo` ADD `{$key}` TEXT NULL DEFAULT NULL";
$db->setQuery($query);
if (!oseDB::query())
{
$result['success'] = false;
$result['title'] = JText::_('Error');
$result['content'] = JText::_('Fail Saving Joomla User Info.');
}
}
}
}
}
$values = array();
foreach($bill as $key => $value)
{
$values[] = $db->Quote($value);
}
$values = implode(',',$values);
$query = "INSERT INTO `#__osemsc_billinginfo` (`user_id`,{$keys}) VALUES ('{$member_id}',{$values});";
} else {
foreach($bill as $key => $value)
{
$values[] = "`{$key}`=".$db->Quote($value);
}
$values = implode(',',$values);
$query = " UPDATE `#__osemsc_billinginfo` SET {$values}"
." WHERE `user_id` ={$member_id}"
;
}
//echo $query;exit;
$db->setQuery($query);
if (!oseDB::query()) {
$result['success'] = false;
$result['title'] = JText::_('Error');
$result['content'] = JText::_('Fail Saving Joomla User Info.');
} else {
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_('Saved User Billing Info.');
}
return $result;
}
function join($id, $amount = 1, $entry_type = 'msc', $entry_option = null)
{
//oseAppConfig::load('mscv5');
oseRegistry::register('email', 'email');
oseRegistry::register('msc', 'membership');
oseRegistry::register('user', 'user');
oseRegistry::quickRequire('user');
oseRegistry::register('member', 'member');
$this->generateOrder($id, $entry_option);
$msc_id = $id;
$user_id = $this->user_id;
$order_id = $this->order_id;
$order_item_id = $this->order_item_id;
$member = oseCall('member');
$member->instance($user_id);
$params = $member->getAddonParams($msc_id, $user_id, $order_id, array('order_item_id' => $order_item_id));
// is Member, renew... else join.
$memMscInfo = $member->getMembership($msc_id, 'obj');
if (empty($memMscInfo)) {
$msc = oseCall('msc');
$updated = $this->joinFromPayment($params);
} else {
// renew
if ($memMscInfo->status) {
$memParams = oseJson::decode($memMscInfo->params);
$msc = oseCall('msc');
$updated = $this->renewMsc($params);
} else {
$msc = oseCall('msc');
$updated = $this->activateMsc($params);
}
}
$db = oseDB::instance();
$query = " UPDATE `#__osemsc_member`" . " SET `expired_date` = '{$this->expired_date}'" . " WHERE `msc_id` = '{$msc_id}' AND `member_id` = '{$user_id}'";
$db->setQuery($query);
oseDB::query();
return $updated;
}
private static function activateInAutomaticMode($msc_id,$member_id,$orderInfo,$ext)
{
$db = oseDB::instance();
$result = array();
$result['success'] = true;
$orderParams = oseJSON::decode($orderInfo->params);
$start_date = oseHTML::getDateTime();
$start_date = $db->Quote($start_date);
$recurrence_num = $orderParams->p3;
$recurrence_unit = $orderParams->t3;
$expired_date = " DATE_ADD({$start_date},INTERVAL {$recurrence_num} {$recurrence_unit}) ";
$query = " UPDATE `#__osemsc_member` "
." SET expired_date = {$expired_date}"
." WHERE member_id = {$member_id} AND msc_id = {$msc_id} "
;
$db->setQuery($query);
//oseExit($db->_sql);
if(!oseDB::query())
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_(' Fail Updated Member\'s Recurrence ');
return $result;
}
$query = " SELECT expired_date FROM `#__osemsc_member` "
." WHERE member_id = {$member_id} AND msc_id = {$msc_id} "
;
$db->setQuery($query);
$end_date = $db->loadResult();
$end_date = $db->Quote($end_date);
$expired_date = " DATE_ADD({$end_date},INTERVAL 1 DAY) ";
if(oseObject::getValue($orderParams,'recurrence_times',0) > 1)
{
}
else
{
$query = " UPDATE `#__osemsc_member` "
." SET expired_date = {$expired_date}"
." WHERE member_id = {$member_id} AND msc_id = {$msc_id} "
;
$db->setQuery($query);
//oseExit($db->_sql);
if(!oseDB::query())
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_(' Fail Updated Member\'s Recurrence ');
return $result;
}
}
return $result;
}
private function addVmOrder($msc_id, $member_id, $params, $order_number)
{
if (empty($member_id)) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error');
return $result;
}
// Get the IP Address
if (!empty($_SERVER['REMOTE_ADDR'])) {
$ip = $_SERVER['REMOTE_ADDR'];
} else {
$ip = 'unknown';
}
$post = JRequest::get('post');
$payment_mode = $params['payment_mode'];
$payment_method = $params['payment_method'];
//Insert the vm order table(#__vm_orders)
$order = array();
//get membership price
$payment = oseRegistry::call('payment');
$paymentInfo = oseMscAddon::getExtInfo($msc_id, 'payment', 'obj');
if ($payment_mode == 'm') {
$order_subtotal = $paymentInfo->price;
} else {
$order_subtotal = empty($paymentInfo->has_trial) ? $paymentInfo->a3 : $paymentInfo->a1;
}
$order['order_subtotal'] = $params['payment_price'];
$order_total = $params['payment_price'];
$order['order_total'] = $order_total;
$db = oseDB::instance();
//$order['order_tax'] = '0.00';
$query = "SELECT user_info_id FROM `#__vm_user_info` WHERE `user_id` = '" . (int) $member_id . "' AND (`address_type` = 'BT' OR `address_type` IS NULL)";
$db->setQuery($query);
$result = $db->loadResult();
$hash_secret = "VirtueMartIsCool";
$user_info_id = empty($result) ? md5(uniqid($hash_secret)) : $result;
$vendor_id = '1';
$order['user_id'] = $member_id;
$order['vendor_id'] = $vendor_id;
$order['user_info_id'] = $user_info_id;
$order['order_number'] = $order_number;
$order['order_currency'] = !empty($payment->currency) ? $payment->currency : "USD";
$order['order_status'] = 'C';
$order['cdate'] = time();
$order['ip_address'] = $ip;
$keys = array_keys($order);
$keys = '`' . implode('`,`', $keys) . '`';
foreach ($order as $key => $value) {
$order[$key] = $db->Quote($value);
}
$values = implode(',', $order);
$query = "INSERT INTO `#__vm_orders` ({$keys}) VALUES ({$values});";
$db->setQuery($query);
if (!oseDB::query()) {
$result = array();
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error');
}
//Insert the #__vm_order_history table
$order_id = $db->insertid();
$history = array();
$history['order_id'] = $order_id;
$history['order_status_code'] = 'C';
$history['date_added'] = date("Y-m-d G:i:s", time());
$history['customer_notified'] = '1';
$keys = array_keys($history);
$keys = '`' . implode('`,`', $keys) . '`';
foreach ($history as $key => $value) {
$history[$key] = $db->Quote($value);
}
$values = implode(',', $history);
$query = "INSERT INTO `#__vm_order_history` ({$keys}) VALUES ({$values});";
$db->setQuery($query);
if (!oseDB::query()) {
$result = array();
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error');
}
//Insert the Order payment info
$payment = array();
$payment['order_id'] = $order_id;
$payment['payment_method_id'] = $payment_method;
if ($payment_method == 'authorize') {
}
//Insert the User Bill
$bill = array();
$query = " SELECT * FROM `#__osemsc_billinginfo`" . " WHERE user_id = {$member_id}";
$db->setQuery($query);
$billInfo = oseDB::loadItem();
if (isset($billInfo)) {
$bill['company'] = $billInfo['company'];
$bill['address_1'] = $billInfo['addr1'];
$bill['address_2'] = $billInfo['addr2'];
$bill['city'] = $billInfo['city'];
$bill['state'] = $billInfo['state'];
$bill['country'] = $billInfo['country'];
//get vm country code
$query = " SELECT country_3_code FROM `#__vm_country` WHERE `country_2_code` = '{$bill['country']}' ";
$db->setQuery($query);
$country_code = $db->loadResult();
$bill['country'] = empty($country_code) ? $bill['country'] : $country_code;
//get vm state code
$query = " SELECT state_2_code FROM `#__vm_state` WHERE `state_name` = '{$bill['state']}' ";
$db->setQuery($query);
$state_code = $db->loadResult();
$bill['state'] = empty($state_code) ? $bill['state'] : $state_code;
$bill['zip'] = $billInfo['postcode'];
$bill['phone_1'] = $billInfo['telephone'];
}
$query = " SELECT * FROM `#__osemsc_userinfo_view`" . " WHERE user_id = {$member_id}";
$db->setQuery($query);
$userInfo = oseDB::loadItem();
$bill['order_id'] = $order_id;
$bill['user_id'] = $member_id;
$bill['address_type'] = 'BT';
$bill['address_type_name'] = '-default-';
$bill['last_name'] = $userInfo['lastname'];
$bill['first_name'] = $userInfo['firstname'];
$bill['user_email'] = $userInfo['email'];
$keys = array_keys($bill);
$keys = '`' . implode('`,`', $keys) . '`';
foreach ($bill as $key => $value) {
$bill[$key] = $db->Quote($value);
}
$values = implode(',', $bill);
$query = "INSERT INTO `#__vm_order_user_info` ({$keys}) VALUES ({$values});";
$db->setQuery($query);
if (!oseDB::query()) {
$result = array();
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error');
}
//Insert the itme table(#__vm_order_item)
$item = array();
$item['order_id'] = $order_id;
$item['user_info_id'] = $user_info_id;
$item['vendor_id'] = $vendor_id;
//get the product info
$vm = oseMscAddon::getExtInfo($msc_id, 'vm', 'obj');
$query = " SELECT * FROM `#__vm_product` WHERE `product_id` = '{$vm->product_id}' ";
$db->setQuery($query);
$product = $db->loadObject();
$item['product_id'] = $vm->product_id;
$item['order_item_sku'] = $product->product_sku;
$item['order_item_name'] = $product->product_name;
$item['product_quantity'] = '1';
$item['product_item_price'] = $order_subtotal;
$item['product_final_price'] = $order_total;
$item['order_item_currency'] = !empty($payment->currency) ? $payment->currency : "USD";
$item['order_status'] = 'C';
$item['cdate'] = time();
$keys = array_keys($item);
$keys = '`' . implode('`,`', $keys) . '`';
foreach ($item as $key => $value) {
$item[$key] = $db->Quote($value);
}
$values = implode(',', $item);
$query = "INSERT INTO `#__vm_order_item` ({$keys}) VALUES ({$values});";
$db->setQuery($query);
if (!oseDB::query()) {
$result = array();
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Error');
}
$result = array();
$result['success'] = true;
$result['title'] = 'Done';
$result['content'] = JText::_('Done');
return $result;
}
function remove($email_id)
{
$db = oseDB::instance();
$query = " DELETE FROM `#__osemsc_email`" . " WHERE id = {$email_id}";
$db->setQuery($query);
return oseDB::query();
}
function updateSubmit($item, $args, $params = array())
{
$db = oseDB::instance();
$where = array();
$where[] = "`id` = " . (int) $args['id'];
$where[] = "`entry_type` = " . $db->Quote('credit_submit');
$where = oseDB::implodeWhere($where);
$sql = array();
foreach ($args as $key => $value) {
if (!in_array($key, array('id', 'credit_amount'))) {
$sql[] = "`" . $key . "`" . "=" . $db->Quote($value);
}
}
if (!empty($params)) {
$params = $db->Quote(oseJson::encode($params));
$sql[] = "`params` = " . $params;
}
$sql = implode(",", $sql);
$query = " UPDATE `{$this->table}`" . " SET " . $sql . $where;
$db->setQuery($query);
return oseDB::query();
}
public function remove($params)
{
$result = array();
$result['success'] = true;
if(empty($params['allow_work']))
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_("Error");
return $result;
}
unset($params['allow_work']);
$db = oseDB::instance();
$member_id = $params['member_id'];
$query = " SELECT mm.link_id "
." FROM `#__osemsc_mtrel` AS mm"
." INNER JOIN `#__osemsc_directory` AS directory ON directory.directory_id = mm.directory_id"
." INNER JOIN `#__oselic_cs_keys_view` AS luv ON luv.company_id = directory.company_id"
." WHERE luv.user_id = {$member_id}";
;
$db->setQuery($query);
$link_id = $db->loadResult();
if(empty($link_id))
{
return $result;
}
$query = " DELETE FROM `#__osemsc_mtrel`"
." WHERE link_id = {$link_id}"
;
$db->setQuery($query);
if(oseDB::query())
{
return $result;
}
else
{
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_("remove.directory");
return $result;
}
}
function isAllowed2Join()
{
$db = oseDB::instance();
$total = $this->getTotal();
$now = oseHtml2::getDateTime();
// before validate the access, we delete the useless data first
$query = " DELETE FROM `#__osemsc_member_join_session`" . " WHERE `msc_id`='{$this->id}' AND `start_date` < DATE_SUB('{$now}',INTERVAL 30 MINUTE)";
$db->setQuery($query);
oseDB::query();
// detect whether it is full
if ($total == $this->restricted_number) {
return false;
}
// default half an hour
$query = "SELECT COUNT(*) FROM `#__osemsc_member_join_session`" . " WHERE `msc_id`='{$this->id}' AND `start_date` > DATE_SUB('{$now}',INTERVAL 30 MINUTE)";
$db->setQuery($query);
$temporary = $db->loadResult();
$nowTotal = $total + $temporary;
if ($nowTotal >= $this->restricted_number) {
return false;
} else {
return true;
}
}
