admin/modules/deposit.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 moment = require('moment')

const mysqclass = require('./mysqli').default
/**
 * @class class to handle return functions
 */
class admindepositModule {
    /**
     * add fund Deposit
     * @param {object} items amount and data
     * @param {string} uid user id
     * @returns {object} sql response
     */
    static async addfundDeposit(items, uid) {
        const mysql = {}
        const dateNow = dateFormat(new Date(), 'yyyy-mm-dd HH:MM:ss')
        const escapeData = [
            dateNow,
            items.user_id,
            items.amount,
            items.credit_notes,
            items.employee_name,
            items.withdraw,
            items.trans_id,
            items.remove_credit,
        ]
        const strQuery = await mysqclass.mysqli(mysql, 'depositinsert')
        const dataReturn = await global.mysql.query(strQuery, escapeData)
        return dataReturn
    }
    /**
     * credits User balance
     * @param {object} items amount and data
     * @param {string} uid user id
     * @returns {object} sql response
     */
    static async creditsUserbalance(items, type) {
        const mysql = {}
        const dateNow = dateFormat(new Date(), 'yyyy-mm-dd HH:MM:ss')
        const escapeData = [items.amount, dateNow, items.user_id]
        let row = ''
        if (type === 0) {
            row = 'depositusersinsert'
        } else {
            row = 'depositusersremove'
        }
        const strQuery = await mysqclass.mysqli(mysql, row)
        const dataReturn = await global.mysql.query(strQuery, escapeData)
        return dataReturn
    }
    /**
     * credits User balance
     * @param {object} req request data
     * @param {string} uid user id
     * @returns {object} sql response
     */
    static async getUserbalance(req, uid) {
        const mysql = {}
        const escapeData = [uid]
        const strQuery = await mysqclass.mysqli(mysql, 'deposituserslist')
        const dataReturn = await global.mysql.query(strQuery, escapeData)
        return dataReturn
    }
}

module.exports.default = admindepositModule