front/modules/payment/rosoom.js

/* ============================================================================ *\
|| ########################################################################## ||
|| # Auction Software Marketplace          Release: 0.6   Build 0.7         # ||
|| # ---------------------------------------------------------------------- # ||
|| # License # 35YAHCNR9344X6O666C123AB                                     # ||
|| # ---------------------------------------------------------------------- # ||
|| # Copyright ©2014–2021 Develop Scripts LLC. All Rights Reserved          # ||
|| # This file may not be redistributed in whole or significant part.       # ||
|| # ------------- AUCTION SOFTWARE IS NOT FREE SOFTWARE ------------------ # ||
|| # http://www.auctionsoftwaremarketplace.com|support@auctionsoftware.com  # ||
|| # ---------------------------------------------------------------------- # ||
|| ########################################################################## ||
\* ============================================================================ */

const dateFormat = require('dateformat')
const md5 = require('md5')
const _ = require('underscore')
const commonSQL = require('../../../common/sql').default

const mysqclass = require('../mysqli').default
/**
 * @class class to handle deposit functions
 */
class rosoomPaymentModule {
    /**
     * get rosoom payment pending
     *
     * @param {number} projectId request object
     * @param {shipping.arta.metadataTransport} method
     */
    static async getRosoomPaymentPending(projectId) {
        const mysql = {}
        const escapeData = [projectId]
        const strQuery = await mysqclass.mysqli(mysql, 'pull_cart_rosoom_pending')
        const dataReturn = await global.mysql.query(strQuery, escapeData)
        return dataReturn
    }
    /**
     * get project id from cart id
     *
     * @param {number} projectId request object
     * @param {shipping.arta.metadataTransport} method
     */
    static async getProjectIDfromCartID(cartId) {
        const mysql = {}
        console.log('req.body.cartId', cartId)
        let queryCartID = []
        if (Array.isArray(cartId)) {
            queryCartID = cartId
        } else {
            queryCartID = cartId.split(',')
        }
        const escapeData = [queryCartID]
        const strQuery = await mysqclass.mysqli(mysql, 'get_cart_project_id')
        const dataReturn = await global.mysql.query(strQuery, escapeData)
        return dataReturn
    }

    static async getCartIDfromProjectID(projectId) {
        const mysql = {}
        console.log('req.body.project ID', projectId)
        let queryProjectID = []
        if (Array.isArray(projectId)) {
            queryProjectID = projectId
        } else {
            queryProjectID = projectId.split(',')
        }
        const escapeData = [queryProjectID]
        const strQuery = await mysqclass.mysqli(mysql, 'get_all_cart_id_project')
        const dataReturn = await global.mysql.query(strQuery, escapeData)
        return dataReturn
    }

    static async insertLog(data, options, type) {
        const mysql = {}
        const escapeData = [
            data.user_id,
            data.project_id,
            type,
            JSON.stringify(options.data),
            dateFormat(new Date(), 'yyyy-mm-dd HH:MM:ss'),
        ]
        const strQuery = await mysqclass.mysqli(mysql, 'northcapital_log_insert')
        const dataReturn = await global.mysql.query(strQuery, escapeData)
        return dataReturn
    }
}

module.exports.default = rosoomPaymentModule