/* ============================================================================ *\
|| ########################################################################## ||
|| # 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