PHP oseDB::update方法代码示例

 function update()
 {
     $vals = $this->toArray();
     //$vals['id'] = $this->get('id');
     //$vals['subject'] = $this->get('subject');
     //$vals['body'] = $this->get('body');
     unset($vals['emailParams']);
     unset($vals['contentVars']);
     $vals['params'] = oseJson::encode($this->get('params'));
     return oseDB::update($this->table, 'id', $vals);
 }

	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'];
		$order_item_id = $params['order_item_id'];
		
		$payment= oseRegistry :: call('payment');
		$orderInfo= $payment->getInstance('Order')->getOrder(array("order_id = {$order_id}"), 'obj');
		$orderInfoParams = oseJson::decode($orderInfo->params);
		
		$array = array();
		$array['id'] = $orderInfoParams->coupon_user_id;
		
		if(!empty($array['id']))
		{
			$array['paid'] = 1;
			$array['user_id'] = $member_id;
			$updated = oseDB::update('#__osemsc_coupon_user','id',$array);
		}
		
		return $result;
	}

 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);
 }

						$emailObj->subject= $mailsubject;
						$emailObj->body= $mailbody;
						$apiEmail->sendToAdminGroup($emailObj, $oseMscConfig->admin_group);

					}
					else
					{
						$ini_txn_id = $process->get('init_txn_id');
						if(!empty($ini_txn_id))
						{
							$transactions = oseJson::decode(oseObject::getValue($orderInfo,'transactions','[]'));
							$transactions[] = $process->get('init_txn_id');
							$transactions = oseJson::encode($transactions);
							oseDB::update('#__osemsc_order','order_id',array(
								'order_id'=>$order_id
								,'order_status'=>'confirmed','transactions'=>$transactions
							));
							//$paymentOrder->updateOrder($order_id, "confirmed",array('transactions'=>$transactions));
							//$oseMscConfig = oseMscConfig::getConfig('payment','obj');
							if(oseObject::getValue($oseMscConfig,'paypal_pro_access','instant') == 'instant')
							{
								// confirm
								//self::confirmOrder($order_id, $params);
							}
							else
							{
								// confirm until paid
								$paymentOrder->confirmOrder($order_id);
							}
							
							$process->set('txn_id',$process->get('recurring_payment_id'));

 function update()
 {
     $vals = $this->getProperties();
     return oseDB::update($this->_table, 'id', $vals);
 }

//.........这里部分代码省略.........
		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($params)
	{
		$result = array();

		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();
		$order_id = $params['order_id'];
		$order_item_id = $params['order_item_id'];
		$msc_id = $params['msc_id'];
		$member_id = $params['member_id'];

		if(empty($msc_id))
		{
			$result['success'] = false;
			$result['title'] = 'Error';
			$result['content'] = JText::_("Join Msc: No Msc ID");
			return $result;
		}
		
		$query = " SELECT * FROM `#__osemsc_order`"
				." WHERE `order_id` = '{$order_id}'"
				;
		$db->setQuery($query);
		$order = oseDB::loadItem('obj');
		$oParams = oseJson::decode($order->params);
		//$msc_option = $oParams->msc_option;
		
		$query = " SELECT * FROM `#__osemsc_order_item`"
				." WHERE `order_id` = '{$order_id}'"
				;
		$db->setQuery($query);
		$order_item = oseDB::loadItem('obj');
		$iParams = oseJson::decode($order_item->params);
		$msc_option = $iParams->msc_option;

		if(oseGetValue($oParams,'isLicensee',0))
		{
			$result['success'] = true;
			$result['title'] = JText::_('Done');
			$result['content'] = JText::_("Done");
			
			return $result;
		}
		
		$query = " SELECT * FROM `#__osemsc_ext`"
				." WHERE `id` = '{$msc_id}' AND `type` = 'oselic'"
				;
		$db->setQuery($query);
		$data = oseDB::loadItem('obj');
		$data = oseJson::decode($data->params);
		$data = oseObject::getValue($data,$msc_option,array());
		
		if( oseObject::getValue($data,'enable_license') )
		{
			oseRegistry :: register('user2', 'user2');
			oseRegistry :: register('lic', 'lic');
			oseRegistry :: register('email', 'email');
			oseRegistry :: register('locale', 'locale');
			$user = oseCall('user2')->instance( $member_id,'lic');
			$user->join( $data->license_id );
			
			
			$query = " SELECT * FROM `#__oselic_type_license`"
					." WHERE `user_id` = '{$member_id}'"
					." ORDER BY `id` DESC"
					." LIMIT 1"
					;
			$db->setQuery($query);
			$license = oseDB::loadItem('obj');
			$oParams->license_id = $license->id;
			
			$vals = array();
			$vals['order_id'] = $order_id;
			$vals['params'] = oseJson::encode($oParams);
			oseDB::update('#__osemsc_order','order_id',$vals);
			
			if( oseObject::getValue($data,'member_expiry_mode') == 1 )
			{
				$query = " SELECT * FROM `#__osemsc_member`"
						." WHERE `msc_id` = '{$msc_id}' AND `member_id` = '{$member_id}'"
						;
				$db->setQuery($query);
				$memInfo = oseDB::loadItem('obj');
				
				$vals = array();
				$vals['id'] = $license->id;
				$vals['expiry_date'] = $memInfo->expired_date;
				oseDB::update('#__oselic_type_license','id',$vals);
			}
			elseif( oseObject::getValue($data,'member_expiry_mode') == 2 )
			{
				$vals = array();
//.........这里部分代码省略.........

 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 update($var)
 {
     //$db = oseDB::instance();
     return oseDB::update('#__osemsc_acl', 'id', $var);
 }

 function markuseless()
 {
     $db = oseDB::instance();
     $result = array();
     $id = JRequest::getInt('id');
     $vals = array();
     $vals['order_id'] = $id;
     $vals['order_status'] = 'expired';
     oseDB::update('#__osemsc_order', 'order_id', $vals);
     $result['success'] = true;
     $result['title'] = JText::_('SUCCESS');
     $result['content'] = JText::_('SUCCESS');
     oseExit(oseJson::encode($result));
 }

 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);
 }

 function update()
 {
     $vals = $this->toArray();
     $vals['params'] = oseJson::encode($vals['params']);
     return oseDB::update($this->table, 'id', $vals);
 }

 function updateMemRecurrence()
 {
     $result = array();
     $db = oseDB::instance();
     $msc_member_id = JRequest::getInt('msc_member_id', 0);
     $startDate = JRequest::getString('start_date', 0);
     $startTime = JRequest::getString('start_time', 0);
     $expDate = JRequest::getString('exp_date', 0);
     $expTime = JRequest::getString('exp_time', 0);
     $start_date = date_create($startDate . $startTime);
     $expired_date = date_create($expDate . $expTime);
     $start_date = date_format($start_date, 'Y-m-d H:i:s');
     $expired_date = date_format($expired_date, 'Y-m-d H:i:s');
     $now = date_create(oseHtml::getDateTime());
     $now = date_format($now, 'Y-m-d H:i:s');
     $vals = array();
     if ($now > $expired_date) {
         $vals['status'] = 0;
         $query = "SELECT * FROM `#__osemsc_member` WHERE `id` = " . $msc_member_id;
         $db->setQuery($query);
         $obj = oseDB::loadItem('obj');
         $msc_id = $obj->msc_id;
         $member_id = $obj->member_id;
         $member = oseRegistry::call('member');
         $member->instance($member_id);
         $userInfo = $member->getUserInfo('obj');
         $params = $member->getAddonParams($msc_id, $member_id, 0, $params = array());
         $list = oseMscAddon::getAddonList('join', true, 1, 'obj');
         foreach ($list as $addon) {
             $result = oseMscAddon::runAction('join.' . $addon->name . '.cancel', $params);
             if (!$result['success']) {
                 return $result;
             }
         }
         $msc = oseRegistry::call('msc');
         $ext = $msc->getExtInfo($msc_id, 'msc', 'obj');
         if (!empty($ext->exp_email)) {
             $order_id = $params['order_id'];
             $email = $member->getInstance('email');
             $emailTempDetail = $email->getDoc($ext->exp_email, 'obj');
             $variables = $email->getEmailVariablesExpire($member_id, $msc_id);
             $emailParams = $email->buildEmailParams($emailTempDetail->type);
             $emailDetail = $email->transEmail($emailTempDetail, $variables, $emailParams);
             $email->sendEmail($emailDetail, $userInfo->email);
             $emailConfig = oseMscConfig::getConfig('email', 'obj');
             if ($emailConfig->sendExp2Admin) {
                 $email->sendToAdminGroup($emailDetail, $emailConfig->admin_group);
             }
         }
     } else {
         $vals['status'] = 1;
     }
     $db = oseDB::instance();
     $vals['start_date'] = $start_date;
     $vals['expired_date'] = $expired_date;
     $vals['id'] = $msc_member_id;
     /*$query = " UPDATE `#__osemsc_member`"
      			." SET start_date = {$start_date}, expired_date = {$expired_date}"
      			." WHERE id = {$msc_member_id}"
      			;
      	
      	$db->setQuery($query);*/
     //if(oseDB::query())
     if (oseDB::update('#__osemsc_member', 'id', $vals)) {
         $result['success'] = true;
         $result['title'] = JText::_('DONE');
         $result['content'] = JText::_('UPDATED');
     } else {
         $result['success'] = false;
         $result['title'] = JText::_('ERROR');
         $result['content'] = JText::_('FAIL_UPDATING');
     }
     return $result;
 }

 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()";
//.........这里部分代码省略.........