const db = require("../config/dbproc.js");
const Adapter = require("./dbadapter.js");

class SapAdapter extends Adapter {
	constructor() {
		super();
	}

	async queryInsertSapLog(idxpr, req, req_type) {
		var apires = this.getApiResultDefined();
		try {
			const {ref_code, request, request_at, request_by, response, response_at, url} = req;

			let qry = `
				INSERT INTO tbl_sap_log
				(idxpr, created_at, ref_code, request_type, request, request_at, request_by, response, response_at, url)
				VALUES (?, NOW(), ?, ?, ?, ?, ?, ?, ?, ?)
			`;

			db.query(
				qry,
				[idxpr, ref_code, req_type, request, request_at, request_by, response, response_at, url],
				function (err, result) {
					if (err) {
						apires.meta.code = 500;
						apires.meta.message = err.toString();

                        console.log('error saving log =>', err.toString())
					} else {
						apires.success = true;
						apires.data = {insertId: result.insertId};
					}
				},
			);
		} catch (err) {
			apires.meta.code = 500;
			apires.meta.message = err.toString();
			callback("error", apires);
		}
	}
}

module.exports = SapAdapter;