garyvv / node-sharp

app/model/catering/customer.js

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

This code seems to be duplicated in your project.

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

The constant config seems to be never used. Consider removing it.

const ModelBase = require('../../model/base')
const ApiError = require('../../util/api_error')

The constant ApiError seems to be never used. Consider removing it.

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
	}

}