Giant Dad

switch ($modx->event->name){
    case 'msOnCreateOrder':
        $cart = $order->ms2->cart->get();
        foreach($cart as $item){
            $modx->log(1, print_r($item['options']['modification'],1));
        }
        break;
}

&sortby=`{"COALESCE(NULLIF(price,0),0)":"DESC"}`

&sortby=`{"COALESCE(NULLIF(price,0),9999999)":"ASC"}`

/assets/components/minishop2/payment/epayhalykbank.php

<?php

const MODX_API_MODE = true;
/** @noinspection PhpIncludeInspection */
require dirname(__FILE__, 5) . '/index.php';

/** @var modX $modx */
$modx->getService('error', 'error.modError');
$modx->setLogLevel(modX::LOG_LEVEL_ERROR);
$modx->setLogTarget('FILE');


$isJsonRequest = (json_decode(file_get_contents('php://input')) != NULL) ? true : false;

if ($_SERVER['REQUEST_METHOD'] === 'POST' && $isJsonRequest) {

    // $modx->log(modX::LOG_LEVEL_ERROR,'ЗАШЛИ ');

    $requestData = json_decode(file_get_contents('php://input'), true);

    $get_array = array();
    
    parse_str($requestData['data'], $get_array);
    
    $requestData['data'] = $get_array;


    if(isset($requestData['invoiceId']) && !empty($requestData['invoiceId']) && isset($requestData['data']) && !empty($requestData['data']) && isset($requestData['data']['orderId']) && !empty($requestData['data']['orderId']) && isset($requestData['data']['orderHash']) && !empty($requestData['data']['orderHash'])){
        /** @var miniShop2 $miniShop2 */
        $miniShop2 = $modx->getService('miniShop2');
        $miniShop2->loadCustomClasses('payment');



        if (!class_exists('EpayHalykBank')) {
            exit('Error payment not exist');
        }


        /** @var msOrder $order */
        $order = $modx->newObject('msOrder');    
        $handler = new EpayHalykBank($order);

        $orderId = $requestData['data']['orderId'];
        $orderHash = $requestData['data']['orderHash'];
        $paymentInvocieId = $requestData['invoiceId'];

        if ($order = $modx->getObject('msOrder', array('id' => $orderId, 'order_hash' => $orderHash))) {
            /** @var msPaymentInterface|EpayHalykBank $handler */
            $verifyingOrderPayment = $handler->handlePaymentVerification($order, array(
                'invoiceID' => $paymentInvocieId,
                'orderID' => $orderId,
                'orderHash' => $orderId,
            ));
            if(!$verifyingOrderPayment){
                die('Error when continuing order');
            }
            die('True');
        } else {
            exit('Error when continuing order, cannot get order');
        }

    }



}

exit('Access Denied');

<?php

if (!class_exists('msPaymentInterface')) {
    require_once dirname(__FILE__, 3) . '/handlers/mspaymenthandler.class.php';
}


class EpayHalykBank extends msPaymentHandler implements msPaymentInterface
{

    /**
    * EpayHalykBank constructor.
    *
    * @param xPDOObject $object
    * @param array $config
    */
    function __construct(xPDOObject $object, $config = array())
    {
        parent::__construct($object, $config);

        $siteUrl = $this->modx->getOption('site_url');
        $assetsUrl = $this->modx->getOption('assets_url') . 'components/minishop2/';
        $this->$paymentUrl = $siteUrl . substr($assetsUrl, 1) . 'payment/epayhalykbank.php';
        $this->debugPayment = $this->modx->getOption('epay_debug');

        $this->config = array_merge(array(
            'grant_type' => 'client_credentials',
            'epayTokenAuthUrl' => $this->debugPayment == 1 ? $this->modx->getOption('epay_test_auth_url') : $this->modx->getOption('epay_prod_auth_url'),
            'payPageUrl' => $this->debugPayment == 1 ? $this->modx->getOption('epay_test_pay_page_url') : $this->modx->getOption('epay_pay_page_url'),
            'scope' => 'webapi usermanagement email_send verification statement statistics payment',
            'client_id' => $this->modx->getOption('epay_client_id'),
            'client_secret' => $this->modx->getOption('epay_client_secret'),
            'currency' => $this->modx->getOption('epay_payment_currency'),
            'terminal_id' => $this->modx->getOption('epay_terminal_id'),
            'transactionCheckStatusUrl' =>  $this->debugPayment == 1 ? $this->modx->getOption('transaction_chech_test_url') : $this->modx->getOption('transaction_chech_prod_url'),
            'postLink' => $this->modx->makeUrl((int) $this->modx->getOption('epay_post_success_page_id'), '', '', 'full'),
            'failurePostLink' => $this->modx->makeUrl((int) $this->modx->getOption('epay_post_error_page_id'), '', '', 'full')
        ), $config);
    }


    public function getOrderHashOld(msOrder $order)
    {
        
        return md5(
            $order->get('id') .
            $order->get('num') .
            $order->get('createdon') .
            $order->get('cart_cost') .
            $order->get('delivery_cost')
        );
        
    }

    public function getOrderHash(msOrder $order)
    {
        
        return substr(preg_replace('/[^0-9]/', '', md5(
            $order->get('id') .
            $order->get('num') .
            $order->get('createdon') .
            $order->get('cart_cost') .
            $order->get('delivery_cost')
        )), 0, 15);
        
    }


    /**
    * @param msOrder $order
    * @param array params
    *
    * @return array|string
    */
    public function handlePaymentVerification(msOrder $order, $params = array()){

        if(isset($params['invoiceID']) && !empty($params['invoiceID'])){

            $generateOrderInoiceId = $this->getOrderHash($order);

            if($params['invoiceID'] == $generateOrderInoiceId){

                $authResponse = $this->paymentAuth($order);
                $verifiedResponse = false;

                if($authResponse['access_token']){
                    $getPaymentStatus = $this->jwt_request(
                        $this->config['transactionCheckStatusUrl'].$generateOrderInoiceId,
                        $authResponse['access_token']
                    );

                    $verifiedResponse = $getPaymentStatus;


                }



                return $this->receive($order, array(
                    'verifyedResponse' => $verifiedResponse
                ));
            }


        }

        return false;

    }




    /**
    * @param msOrder $order
    * @param array $params
    *
    * @return bool
    */
    public function receive(msOrder $order, $params = array())
    {
        if(!empty($params['verifyedResponse']) && !empty($params['verifyedResponse'])  && !empty($params['verifyedResponse']['resultCode'])){

            if ($params['verifyedResponse']['resultCode'] == '100') {
                $this->ms2->changeOrderStatus($order->get('id'), 2); // Set status "paid"
                return true;
            } else {
                $this->ms2->changeOrderStatus($order->get('id'), 1002); // Set status "Payment error"

                $msOrder->set('payment_response_status', $result);
                $msOrder->save();
                return false;
            }

        }



        return false;
    }



    /**
    * @param msOrder $order
    *
    * @return array|string
    */
    public function send(msOrder $order)
    {
        if ($order->get('status') > 1) {
            return $this->error('ms2_err_status_wrong');
        }



        $authResponse = $this->paymentAuth($order);


        if (is_array($authResponse) && !empty($authResponse['access_token'])) {
            // $this->modx->log(1, 'OPLATA_NACHALAS');

            $msAddress = $order->getOne('Address');
            $orderPhone = $msAddress->get('phone');
            $orderEmail = $msAddress->get('email');
            $orderReceiver = $msAddress->get('receiver');

            if(substr($orderPhone, 0, 1) == '7'){
                $orderPhone = '+' . $orderPhone;
            }

            $orderHash = $this->getOrderHash($order);

            // $this->modx->log(1, $this->getOrderHash($order));
            
            $backLinkParams = '&msorder='.$order->get('id').'&mscode='.$this->getOrderHashOld($order).'&invoice_id='.$orderHash;
            

            $reqParams = array(
                'invoiceId' => $orderHash,
                'backLink' => $this->config['postLink'].'?action=success'.$backLinkParams,
                'failureBackLink' => $this->$paymentUrl,
                'postLink' => $this->$paymentUrl,
                'failurePostLink' => $this->$paymentUrl,
                'language' => 'rus',
                'description' => 'Оплата в интернет магазине',
                'accountId' => $this->config['client_id'],
                'terminal' => $this->config['terminal_id'],
                'amount' => $order->get('cost'),
                'data' => array(
                    'name' => $orderReceiver,
                    'orderId' => $order->get('id'),
                    'orderHash' => $this->getOrderHashOld($order),
                    'invoiceId' => $orderHash,
                    'phone' => $orderPhone,
                    'email' => $orderEmail
                ),
                'currency' => $this->config['currency'],
                'phone' => $orderPhone,
                'email' => $orderEmail,
                'cardSave' => true,
                'auth' => $authResponse

            );

            return $this->success('', array('payment_response' => $reqParams));
        } else {
            $this->modx->log(
                modX::LOG_LEVEL_ERROR,
                '[miniShop2] Payment error while request. Request: ' . print_r(
                    $params,
                    1
                ) . ', authResponse: ' . print_r(
                    $authResponse,
                    1
                )
            );

            return $this->success('', array('msorder' => $order->get('id')));
        }
    }




    private function jwt_request($url, $token) {

        header('Content-Type: application/json'); // Specify the type of data
        $ch = curl_init($url); // Initialise cURL
        $authorization = "Authorization: Bearer ".$token; // Prepare the authorisation token
        curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json' , $authorization )); // Inject the token into the header
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); // This will follow any redirects
        $result = curl_exec($ch); // Execute the cURL statement
        curl_close($ch); // Close the cURL connection
        return json_decode($result, true); // Return the received data

    }


    /**
    * Create Auth Token
    *
    * @param 
    *
    * @return string
    */
    public function paymentAuth(msOrder $order)
    {
        $authUrl = $this->config['epayTokenAuthUrl'];
        
        $params = array(
            'grant_type' => $this->config['grant_type'],
            'scope' => $this->config['scope'],
            'client_id' => $this->config['client_id'],
            'client_secret' => $this->config['client_secret'],
            'invoiceID' => $this->getOrderHash($order),
            'amount' => $order->get('cost'),
            'currency' => $this->config['currency'],
            'terminal' => $this->config['terminal_id'],
            'postLink' => $this->$paymentUrl,
            'failurePostLink' => $this->$paymentUrl
        );

        $myCurl = curl_init();
        curl_setopt_array($myCurl, array(
            CURLOPT_URL => $authUrl,
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_POST => true,
            CURLOPT_POSTFIELDS => http_build_query($params)
        ));

        $response = curl_exec($myCurl);
        curl_close($myCurl);
        // $this->modx->log(1, $response);
        return json_decode($response, true);

    }


    /**
    * Returns a direct link for continue payment process of existing order
    *
    * @param msOrder $order
    *
    * @return string
    */
    public function getPaymentLink(msOrder $order)
    {

        $redirectPaymentUrl = $this->config['payPageUrl'];

        return $redirectPaymentUrl;
    }
}

'where' => ['Data.old_price > Data.price AND Data.internet_magazin = 1']