Beispiel #1
0
 public function epayBgUpdateTransaction($orderid = '', $status = '')
 {
     $db_ext = new DbExt();
     /*dump($orderid);
      	dump($status);*/
     if ($info = $this->barclayTransactionByOrderId($orderid)) {
         //dump($info);
         $res = Yii::app()->functions->getMerchantByToken($info['token']);
         $package_id = $res['package_id'];
         switch ($info['transaction_type']) {
             case "renew":
             case "signup":
                 if ($info['transaction_type'] == "renew") {
                     $package_id = $info['param1'];
                     if ($new_info = Yii::app()->functions->getPackagesById($package_id)) {
                         $res['package_name'] = $new_info['title'];
                         $res['package_price'] = $new_info['price'];
                         if ($new_info['promo_price'] > 0) {
                             $res['package_price'] = $new_info['promo_price'];
                         }
                     }
                     $membership_info = Yii::app()->functions->upgradeMembership($res['merchant_id'], $package_id);
                     $params = array('package_id' => $package_id, 'merchant_id' => $res['merchant_id'], 'price' => $res['package_price'], 'payment_type' => Yii::app()->functions->paymentCode('paysera'), 'membership_expired' => $membership_info['membership_expired'], 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'PAYPALFULLRESPONSE' => json_encode($_POST), 'TRANSACTIONID' => $orderid, 'TOKEN' => $orderid);
                 } else {
                     $params = array('package_id' => $res['package_id'], 'merchant_id' => $res['merchant_id'], 'price' => $res['package_price'], 'payment_type' => Yii::app()->functions->paymentCode('epaybg'), 'membership_expired' => $res['membership_expired'], 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'PAYPALFULLRESPONSE' => json_encode($_POST), 'TRANSACTIONID' => $orderid, 'TOKEN' => $orderid);
                 }
                 $params['status'] = strtolower($status);
                 /*dump($params);*/
                 if (!$this->epayBGIsPaymentExist($orderid)) {
                     $db_ext->insertData("{{package_trans}}", $params);
                 }
                 break;
             case "order":
                 $params_logs = array('order_id' => $info['token'], 'payment_reference' => $orderid, 'payment_type' => Yii::app()->functions->paymentCode('epaybg'), 'raw_response' => json_encode($_POST), 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR']);
                 if (!$this->epayBgValidatePaymentOrder($info['token'], $orderid)) {
                     $db_ext->insertData("{{payment_order}}", $params_logs);
                     $params_update = array('status' => $status);
                     $db_ext->updateData("{{order}}", $params_update, 'order_id', $info['token']);
                 }
                 break;
             case "sms_purchase":
                 $payment_reference = $info['orderid'];
                 $stmt_update = "\r\n    \t\t\t    UPDATE {{sms_package_trans}}\r\n    \t\t\t    SET status=" . strtolower($this->q($status)) . "\r\n    \t\t\t    WHERE\r\n    \t\t\t    payment_reference=" . $this->q($payment_reference) . "\r\n    \t\t\t    AND\r\n    \t\t\t    sms_package_id=" . $this->q($info['param1']) . "\r\n    \t\t\t    ";
                 $db_ext->qry($stmt_update);
                 break;
             default:
                 //echo 'not found';
                 break;
         }
     }
 }
Beispiel #2
0
 public function removeLogo()
 {
     if (Yii::app()->functions->isMerchantLogin()) {
         $DbExt = new DbExt();
         $merchant_id = Yii::app()->functions->getMerchantID();
         $stmt = "SELECT * FROM\r\n\t\t    \t{{option}}\r\n\t\t    \tWHERE\r\n\t\t    \toption_name='merchant_photo'\r\n\t\t    \tAND\r\n\t\t    \tmerchant_id='{$merchant_id}'\r\n\t\t    \t";
         $DbExt->qry($stmt);
         $this->code = 1;
         $this->msg = Yii::t("default", "Successful");
     } else {
         $this->msg = Yii::t("default", "ERROR: Your session has expired.");
     }
 }
 public function alterTable($table = '', $new_field = '')
 {
     $DbExt = new DbExt();
     $prefix = Yii::app()->db->tablePrefix;
     $existing_field = '';
     if ($res = Yii::app()->functions->checkTableStructure($table)) {
         foreach ($res as $val) {
             $existing_field[$val['Field']] = $val['Field'];
         }
         foreach ($new_field as $key_new => $val_new) {
             if (!in_array($key_new, $existing_field)) {
                 echo "Creating field {$key_new} <br/>";
                 $stmt_alter = "ALTER TABLE " . $prefix . "{$table} ADD {$key_new} " . $new_field[$key_new];
                 dump($stmt_alter);
                 if ($DbExt->qry($stmt_alter)) {
                     echo "(Done)<br/>";
                 } else {
                     echo "(Failed)<br/>";
                 }
             } else {
                 echo "Field {$key_new} already exist<br/>";
             }
         }
     }
 }