44 lines
1.1 KiB
JavaScript
44 lines
1.1 KiB
JavaScript
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;
|