garyvv / node-sharp

const DB = require('../libraries/db')

const ModelBase = require('./base')

let table = 'fc_users'

module.exports = {

	getUserByOpenId: async function (openid) {

		let user = DB.readMysql.first(

			'*'

		)

			.from(table)

			.where('openid', openid)

		return await user

	},

	getUser: async function (uid) {

		let user = DB.readMysql.first(

			'*'

		)

			.from(table)

			.where('id', uid)

		return await user

	},

	addUser: async function (data) {

		let result = await ModelBase.execInsert(table, data)

		return await result

	},

	editUser: async function (data, where, notWhere = {}) {

		let result = await ModelBase.execUpdate(table, data, where, notWhere)

		return await result

	}

}

const DB = require('../../libraries/db')

const config = require('../../../config/config')

const ModelBase = require('../../model/base')

const ApiError = require('../../util/api_error')

const table = 'mist_customer'

module.exports = {

    add: async function (data) {

        let res = await ModelBase.execInsert(table, data)

        return res;

    },

	getCustomerByOpenId: async function (openid) {

		let user = await DB.readMysql.first(

			'*'

		)

			.from(table)

			.where('openid', openid)

		return user

	},

	first: async function (customerId) {

		let user = await DB.readMysql.first(

			'*'

		)

			.from(table)

			.where('id', customerId)

		return user

	},

	edit: async function (data, where, notWhere = {}) {

		let result = await ModelBase.execUpdate(table, data, where, notWhere)

		return result

	}

}

const DB = require('../../libraries/db')

const ModelBase = require('../../model/base')

const table = 'mist_desk'

module.exports = {

    add: async function (data) {

        let res = await ModelBase.execInsert(table, data)

        return res;

    },

	list: async function (storeId) {

		let result = await DB.readMysql.select(

			'*'

		)

			.from(table)

			.where('store_id', storeId)

			.where('status', '!=', -1)

		return result

	},

	first: async function (id) {

		let result = await DB.readMysql.first(

			'*'

		)

			.from(table)

			.where('id', id)

		return result

	},

	edit: async function (data, where, notWhere = {}) {

		let result = await ModelBase.execUpdate(table, data, where, notWhere)

		return result

	}

}

const DB = require('../../libraries/db')

const ModelBase = require('../../model/base')

const table = 'mist_seller'

module.exports = {

    add: async function (data) {

        let res = ModelBase.execInsert(table, data)

        return await res;

    },

	list: async function (kid) {

		let result = DB.readMysql.select(

			'*'

		)

			.from(table)

			.where('kid', kid)

			.where('status', '!=', -1)

		return await result

	},

	first: async function (id) {

		let result = DB.readMysql.first(

			'*'

		)

			.from(table)

			.where('seller_id', id)

		return await result

	},

	edit: async function (data, where, notWhere = {}) {

		let result = ModelBase.execUpdate(table, data, where, notWhere)

		return await result

	}

}

const DB = require('../../libraries/db')

const ModelBase = require('../../model/base')

const table = 'mist_store'

module.exports = {

    add: async function (data) {

        let res = await ModelBase.execInsert(table, data)

        return res;

    },

	first: async function (id) {

		let result = DB.readMysql.first(

			'*'

		)

			.from(table)

			.where('id', id)

		return await result

	},

	getSellerStores: async function (sellerId) {

		let result = DB.readMysql.select(

			'*'

		)

			.from(table)

			.where('seller_id', sellerId)

		return await result

	},

	edit: async function (data, where, notWhere = {}) {

		let result = ModelBase.execUpdate(table, data, where, notWhere)

		return await result

	}

}