function create($xtype = false, $config = array())
{
$vals = $this->toArray();
unset($vals['id']);
$vals['params'] = oseJson::encode($vals['params']);
return oseDB::insert($this->table, $vals);
}
function save()
{
$result = array();
$post = JRequest::get('post');
$post = oseMscAddon::getPost('licseat_', $post);
if (!isset($post['contact_send'])) {
$post['contact_send'] = 0;
}
if (!isset($post['internal_contact_send'])) {
$post['internal_contact_send'] = 0;
}
$db = oseDB::instance();
$msc_id = JRequest::getInt('msc_id', 0);
$member_id = JRequest::getInt('member_id', 0);
//$member = oseRegistry::call('member');
//$member->instance($member_id);
//$memInfo = $member->getMembership($msc_id,'obj');
//$memInfoParams = oseObject::getParams($memInfo);
$mscLicInfo = oseRegistry::call('msc')->getExtInfo($msc_id, 'lic', 'obj');
$mscLicInfoParams = oseObject::getParams($mscLicInfo);
$where = array();
$where[] = "license_user_id = '{$member_id}'";
$post['id'] = $item->id;
$post['license_user_id'] = $member_id;
if (empty($post['id'])) {
$updated = oseDB::insert('#__oselic_license_seat', $post);
} else {
$updated = oseDB::update('#__oselic_license_seat', 'id', $post);
}
if (!$updated) {
$result['success'] = false;
$result['title'] = 'Error';
$result['content'] = JText::_('Fail Saving OSEMSC User Info.');
$result['member_id'] = '';
} else {
$result['success'] = true;
$result['title'] = 'Done';
$result['content'] = JText::_('Saved Joomla User Info.');
}
return $result;
}
function save()
{
$id = JRequest::getInt('id', 0);
//$domain = JRequest::getString('domain','','post', JREQUEST_ALLOWRAW);
$domain = JRequest::getString('domain');
$user_id = JRequest::getInt('user_id');
$msc_id = JRequest::getInt('msc_id');
$start_date = JRequest::getString('start_date');
//$start_date = date('Y-m-d H:i:s',strtotime($start_date));;
$end_date = JRequest::getString('end_date');
//$end_date = date('Y-m-d H:i:s',strtotime($end_date));;
//$data = JRequest::getString('data');
$vals = array();
$vals['id'] = $id;
$vals['userID'] = $user_id;
$vals['domain'] = $domain;
$vals['mscID'] = $msc_id;
$vals['start_date'] = $start_date;
$vals['end_date'] = $end_date;
if (empty($id)) {
unset($vals['id']);
$updated = oseDB::insert($this->table, $vals);
} else {
$updated = oseDB::update($this->table, 'id', $vals);
}
if ($updated) {
$result['success'] = true;
$result['title'] = JText::_('SUCCESS');
$result['content'] = JText::_('Saved');
} else {
$result['success'] = false;
$result['title'] = JText::_('ERROR');
$result['content'] = JText::_('Fail Saving');
}
$result = oseJSON::encode($result);
oseExit($result);
}
function create()
{
$db = oseDB::instance();
$query = " SELECT COUNT(*) FROM `{$this->_table}`";
$db->setQuery($query);
$num = $db->loadResult();
if ($num > 0) {
$this->set('lft', $num * 2 + 1);
$this->set('rgt', $num * 2 + 2);
$this->set('ordering', $num + 1);
}
$vals = $this->getProperties();
$updated = oseDB::insert($this->_table, $vals);
if ($updated) {
$this->set('id', $updated);
foreach ($this->_type as $k => $o) {
$class = $this->getTypeItem($o->id);
}
$this->__construct();
return $updated;
} else {
return false;
}
}
function insertSubmit($args, $params = array())
{
$db = oseDB::instance();
$sql = $args;
$sql['id'] = null;
$sql['entry_id'] = null;
$sql['entry_type'] = 'credit_submit';
$sql['status'] = 1;
if (!empty($params)) {
$sql['credit'] = $params['credit_amount'];
$sql['params'] = oseJson::encode($params);
}
$keys = array();
$values = array();
$inserted_id = oseDB::insert($this->table, $sql);
$args = array();
$args['id'] = $inserted_id;
$args['content_id'] = $inserted_id;
$item = $this->getItemSubmit($inserted_id);
$result = $this->updateSubmit($item, $args, $params = array());
return $result;
}
function create()
{
$vals = $this->toArray();
unset($vals['id']);
$vals['params'] = oseJson::encode($this->get('params'));
return oseDB::insert($this->table, $vals);
}
protected function addOrderInfoFix($order_id)
{
$result = array();
$db = oseDB::instance();
$query = " SELECT * FROM `#__osemsc_order_fix`" . " WHERE `order_id` = '{$order_id}'";
$db->setQuery($query);
$item = oseDB::loadItem('obj');
if (empty($item)) {
$query = " SELECT b.*,a.entry_id,a.order_item_id" . " FROM `#__osemsc_order_item` AS a" . " INNER JOIN `#__osemsc_order` AS b ON b.order_id = a.order_id" . " WHERE a.`order_id` = '{$order_id}'";
$db->setQuery($query);
$oInfo = oseDB::loadItem('obj');
$query = " SELECT * FROM `#__osemsc_member`" . " WHERE `msc_id` = '{$oInfo->entry_id}' AND `member_id`='{$oInfo->user_id}'";
$db->setQuery($query);
$mItem = oseDB::loadItem('obj');
if (!empty($mItem)) {
// update the order paypal status
$ofVals = array();
$ofVals['order_id'] = $oInfo->order_id;
$ofVals['order_item_id'] = $oInfo->order_item_id;
$ofVals['member_id'] = $mItem->id;
$ofVals['msc_id'] = $mItem->msc_id;
$ofVals['user_id'] = $mItem->member_id;
$ofVals['hasParams'] = 1;
$ofVals['payment_method'] = $oInfo->payment_method;
$ofVals['payment_mode'] = 'a';
$ofVals['status'] = 'updated';
$ofVals['create_date'] = oseHtml::getDateTime();
$ofVals['params'] = $oInfo->params;
$user = JFactory::getUser($mItem->member_id);
$ofVals['email'] = $user->email;
oseDB::insert("#__osemsc_order_fix", $ofVals);
}
}
}
function create()
{
$vals = $this->getProperties();
return oseDB::insert($this->_table, $vals);
}
public static function save()
{
$result = array();
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_('Saved User Billing Info.');
$post = JRequest::get('post');
$user = oseMscPublic::getUser();
$member_id = $user->id;
if(!empty($post['juser_firstname']))
{
$post['bill_firstname'] = $post['juser_firstname'];
}
if(!empty($post['juser_lastname']))
{
$post['bill_lastname'] = $post['juser_lastname'];
}
$billinfo = array();
foreach($post as $key => $value)
{
if(strstr($key,'bill_'))
{
$billKey = str_replace('bill_','',$key);
$billinfo[$billKey] = $value;
}
}
if(empty($billinfo))
{
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_('Nothing need to save!');
}
//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();
$fields = $db->getTableFields('#__osemsc_billinginfo');
foreach($billinfo as $key => $value)
{
$my = JFactory::getUser();
if(!isset($fields['#__osemsc_billinginfo'][$key]))
{
if(oseMscPublic::isUserAdmin($my))
{
$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
{
//unset($billinfo[$key]);
}
}
}
if (empty ($num)) {
$keys = array_keys($billinfo);
$keys = '`'.implode('`,`',$keys).'`';
/*
foreach($billinfo as $key => $value)
{
$billinfo[$key] = $db->Quote($value);
}
$values = implode(',',$billinfo);
if (empty($values))
{
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_('Nothing need to save!');
}
$query = "INSERT INTO `#__osemsc_billinginfo` (`user_id`,{$keys}) VALUES ('{$member_id}',{$values});";
$db->setQuery($query);
*/
$billinfo['user_id'] = $user->id;
if (!oseDB::insert('#__osemsc_billinginfo',$billinfo)) {
$result['success'] = false;
$result['title'] = JText::_('Error');
$result['content'] = JText::_('Fail Saving Joomla User Info.');
}
} else {
if(count($billinfo) > 0)
{
/*
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}"
;
$db->setQuery($query);
*/
$billinfo['user_id'] = $user->id;
if (!oseDB::update('#__osemsc_billinginfo','user_id',$billinfo)) {
$result['success'] = false;
$result['title'] = JText::_('Error');
$result['content'] = JText::_('Fail Saving Joomla User Info.');
}
}
}
//echo $query;exit;
return $result;
}
public static function save($app = 'msc', $config_type, $vals)
{
$db = oseDB::instance();
$config = self::load($app, $config_type, 'obj');
$updated = true;
foreach ($vals as $k => $v) {
$where = array();
$where[] = '`app`=' . $db->Quote($app);
$where[] = '`type`=' . $db->Quote($config_type);
$where[] = '`key`=' . $db->Quote($k);
$where = oseDB::implodeWhere($where);
$query = " SELECT COUNT(id) FROM `#__ose_app_config`" . $where;
$db->setQuery($query);
$total = $db->loadResult();
if ($total > 0) {
$iVals = array();
$iVals['id'] = $total;
$iVals['value'] = $v;
$updated = oseDB::update('#__ose_app_config', 'id', $iVals);
} else {
$iVals = array();
$iVals['app'] = $app;
$iVals['type'] = $config_type;
$iVals['key'] = $k;
$iVals['value'] = $v;
$updated = oseDB::insert('#__ose_app_config', $iVals);
}
}
return $updated;
}
function checkTableInfo()
{
$db = oseDB::instance();
// check billing
$query = " SELECT COUNT(*) FROM `#__osemsc_billinginfo`" . " WHERE `user_id` = '{$this->member_id}'";
$db->setQuery($query);
$result = $db->loadResult();
if ($result <= 0) {
$user = new JUser($this->member_id);
$names = explode(' ', $user->name);
$firstname = $names[0];
$lastname = count($names) > 1 ? $names[1] : '';
oseDB::insert('#__osemsc_billinginfo', array('user_id' => $this->member_id, 'firstname' => $firstname, 'lastname' => $lastname));
}
// check user info
$query = " SELECT COUNT(*) FROM `#__osemsc_userinfo`" . " WHERE `user_id` = '{$this->member_id}'";
$db->setQuery($query);
$result = $db->loadResult();
if ($result <= 0) {
$user = new JUser($this->member_id);
$names = explode(' ', $user->name);
$firstname = $names[0];
$lastname = count($names) > 1 ? $names[1] : '';
oseDB::insert('#__osemsc_userinfo', array('user_id' => $this->member_id, 'firstname' => $firstname, 'lastname' => $lastname));
}
return true;
}
private function updateCoupon($item,$coupon_number = null)
{
$db = oseDB::instance();
$user = oseMscPublic::getUser();
$coupon_id = oseObject::getValue($item,'id',0);
$where = array();
if($user->guest)
{
$where[] = "coupon_number = '{$coupon_number}'";
}
else
{
$where[] = "user_id = '{$user->id}'";
}
$where[] = "`coupon_id` = '{$coupon_id}'";
$where[] = "`paid` = 0";
$where = oseDB::implodeWhere($where);
$query = " SELECT * FROM `#__osemsc_coupon_user`"
. $where
." ORDER BY `id` DESC"
;
$db->setQuery($query);
$obj = oseDB::loadItem('obj');
$array = array();
if(empty($obj))
{
$array['coupon_id'] = $coupon_id;
$array['user_id'] = $user->id;
$array['msc_id'] = 0;
$array['coupon_number'] = $coupon_number;
$updated = oseDB::insert('#__osemsc_coupon_user',$array);
$coupon_user_id = $updated;
if(!$updated)
{
return false;
}
if(oseObject::getValue($item,'amount_infinity') == 0)
{
$couponParams = oseJson::decode($item->params);
$couponParams->amount_left--;
$couponParams = oseJson::encode($couponParams);
$array = array();
$array['id'] = $coupon_id;
$array['params'] = $couponParams;
//oseExit($couponParams);
$updated = oseDB::update('#__osemsc_coupon','id',$array);
if(!$updated)
{
return false;
}
}
}
else
{
$array['id'] = $obj->id;
$array['coupon_id'] = $coupon_id;
$array['user_id'] = $user->id;
$array['msc_id'] = 0;
$coupon_user_id = $obj->id;
$updated = oseDB::update('#__osemsc_coupon_user','id',$array);
}
if($updated)
{
$updated = $coupon_user_id;
}
return $updated;
}
function saveState()
{
$db = oseDB::instance();
$post = JRequest::get('post');
$state_id = JRequest::getInt('state_id', 0);
$country_id = JRequest::getInt('country_id', 0);
$state_name = JRequest::getCmd('state_name', null);
$state_3_code = JRequest::getCmd('state_3_code', null);
$state_2_code = JRequest::getCmd('state_2_code', null);
$where = array();
//$where[] = '`State_3_code` ='.$db->Quote($State_3_code);
//$where[] = '`State_2_code` ='.$db->Quote($State_2_code);
$where[] = '`state_id` =' . $db->Quote($state_id);
$where = oseDB::implodeWhere($where);
$query = "SELECT * FROM `#__osemsc_state`" . $where . ' LIMIT 1';
$db->setQuery($query);
$item = oseDB::loadItem('obj');
if (!empty($item)) {
$id = $item->state_id;
} else {
$id = $state_id;
}
if (empty($id)) {
$updated = oseDB::insert('#__osemsc_state', $post);
} else {
$updated = oseDB::update('#__osemsc_state', 'state_id', $post);
}
if ($updated) {
$result['success'] = true;
$result['title'] = JText::_('DONE');
$result['content'] = JText::_('SAVE_SUCCESSFULLY');
} else {
$result['success'] = false;
$result['title'] = JText::_('ERROR');
$result['content'] = JText::_('ERROR');
}
$result = oseJson::encode($result);
oseExit($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']);
if($params['join_from'] != 'payment')
{
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_("Success");
return $result;
}
$db = oseDB::instance();
$msc_id = oseObject::getValue($params,'msc_id');
$member_id = oseObject::getValue($params,'member_id');
$mscLicInfo = oseRegistry::call('msc')->getExtInfo($msc_id,'lic','obj');
$mscLicSeatInfo = oseRegistry::call('msc')->getExtInfo($msc_id,'licseat','obj');
if(!oseObject::getValue($mscLicSeatInfo,'enabled',false))
{
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_("Success");
return $result;
}
if(empty($mscLicSeatInfo) || empty($mscLicInfo->license_id))
{
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_("Success");
return $result;
}
$lic_id = $mscLicInfo->license_id;
$user = new JUser($member_id);
$post = array();
$post['license_id'] = $lic_id;
$post['licenser_id'] = $member_id;
$post['seat_number'] = $mscLicSeatInfo->seat_number;
$post['contact_send'] = $mscLicSeatInfo->contact_send;
$post['internal_contact_send'] = $mscLicSeatInfo->internal_contact_send;
$post['contact'] = $user->email;
$post['internal_contact'] = $user->email;
$order_id = oseObject::getValue($params,'order_id');
$order_item_id = oseObject::getValue($params,'order_item_id');
$where = array();
$where[] = 'order_item_id = '.$db->Quote($order_item_id);
$orderInfo = oseRegistry::call('payment')->getOrderItem($where,'obj');
if($orderInfo->entry_type == 'license')
{
$updated = oseDB::insert('#__oselic_license_seat',$post);
if($updated)
{
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_("Success");
}
else
{
$result['success'] = false;
$result['title'] = JText::_('Error');
$result['content'] = JText::_("Error: License Seat Addon Fail");
}
}
else
{
$result['success'] = true;
$result['title'] = JText::_('Done');
$result['content'] = JText::_("Success");
}
return $result;
}
function createChild($vals)
{
$db = oseDB::instance();
$level = $this->getNodeLevel();
$vals['level'] = $level + 1;
$children = $this->getChildren();
$childrenTotal = count($children);
if ($childrenTotal > 0) {
$child = $children[$childrenTotal - 1];
$query = " UPDATE `{$this->_table}` AS acl2 SET acl2.rgt = acl2.rgt + 2 " . " WHERE acl2.rgt > {$child->rgt} ";
$db->setQuery($query);
if (!oseDB::query()) {
return false;
}
$query = " UPDATE `{$this->_table}` AS acl2 SET acl2.lft = acl2.lft + 2 " . " WHERE acl2.lft > {$child->rgt} ";
$db->setQuery($query);
if (!oseDB::query()) {
return false;
}
$vals['lft'] = $child->rgt + 1;
$vals['rgt'] = $child->rgt + 2;
$vals['ordering'] = $child->ordering + 1;
$updated = oseDB::insert($this->_table, $vals);
if ($updated) {
$this->load();
}
return $updated;
} else {
// make two vacancy for the new item
$query = " UPDATE `{$this->_table}` SET rgt = rgt + 2 " . " WHERE rgt > {$this->lft} ";
$db->setQuery($query);
if (!oseDB::query()) {
return false;
}
$query = " UPDATE `{$this->_table}` AS acl2 SET acl2.lft = acl2.lft + 2 " . " WHERE acl2.lft > {$this->lft} ";
$db->setQuery($query);
if (!oseDB::query()) {
return false;
}
$vals['lft'] = $this->lft + 1;
$vals['rgt'] = $this->rgt + 1;
$updated = oseDB::insert($this->_table, $vals);
if ($updated) {
$this->load();
}
return $updated;
}
}
