82 lines
3.5 KiB
JavaScript
82 lines
3.5 KiB
JavaScript
'use strict';
|
|
var mysql = require('mysql');
|
|
const random = require('random');
|
|
var fs = require("fs");
|
|
var check;
|
|
var con = mysql.createConnection({
|
|
host: "localhost",
|
|
user: "root",
|
|
password: "",
|
|
database: "intops"
|
|
});
|
|
|
|
|
|
|
|
// console.log(sql_levenshtein_cmd);
|
|
con.connect(function (err) {
|
|
if (err) throw err;
|
|
console.log("Connected!!!")
|
|
});
|
|
|
|
exports.SaveLogs = async function (req, res) {
|
|
var sql_cmd = "SELECT * FROM vehicle WHERE plate=\"" + req.body.plate + "\"";
|
|
var sql_query_cmd = "select * from vehicle where levenshtein('" + req.body.plate + "',`plate`) BETWEEN 0 AND 2";
|
|
console.log("req: ", req.body.plate);
|
|
con.connect(function (err) {
|
|
// if (err)
|
|
// throw err;
|
|
if (check != req.body.plate) {
|
|
con.query(sql_query_cmd, function (err, result, fields) {
|
|
console.log("levenshtein");
|
|
console.log(result);
|
|
var result_vehicle_id;
|
|
var sql_insert_logs_cmd, sql_insert_logs_unknow_cmd;
|
|
|
|
//if levenshtein not found plate
|
|
if (result == "") {
|
|
console.log("Nothing to show");
|
|
//timestamp in seconds
|
|
var today = new Date();
|
|
var currentTimeInInt = Math.round(today.getTime() / 1000);
|
|
sql_insert_logs_unknow_cmd = "INSERT INTO logs_unknow(`id`,`plate`,`plate_image_in`,`frame_image_in`,`time_in`,`plate_image_out`,`frame_image_out`,`time_out`,`seal_no`,`note`,`factory`) VALUES (" + random.int(1, 1000) + ",'" + req.body.plate + "','1','1'," + currentTimeInInt + ",'1','1',11,'1','1','1')";
|
|
con.query(sql_insert_logs_unknow_cmd, function (err, result, fields) {
|
|
if (err)
|
|
throw err;
|
|
});
|
|
console.log("Log unknown done");
|
|
}
|
|
|
|
//if levenshtein found plate
|
|
else {
|
|
console.log("Log to logs table");
|
|
//get vehicle id in vehicle table
|
|
con.query("SELECT id FROM vehicle where `plate`='" + result[0].plate + "'", function (err, result_vehicle_id) {
|
|
if (err)
|
|
throw err;
|
|
console.log("result_vehicle_id");
|
|
console.log(result_vehicle_id[0].id);
|
|
var today = new Date();
|
|
var currentTimeInInt = Math.round(today.getTime() / 1000);
|
|
sql_insert_logs_cmd = "INSERT INTO logs(`id`,`vehicle_id`,`plate_image_in`,`frame_image_in`,`time_in`,`plate_image_out`,`frame_image_out`,`time_out`,`seal_no`,`note`,`factory`) VALUES (" + random.int(1, 1000) + "," + result_vehicle_id[0].id + ",'1','1'," + currentTimeInInt + ",'1','1',11,'1','1','1')";
|
|
con.query(sql_insert_logs_cmd, function (err, result, fields) {
|
|
if (err)
|
|
throw err;
|
|
console.log("Log done");
|
|
});
|
|
});
|
|
}
|
|
});
|
|
const base64Image = req.body.plate_image;
|
|
const imageBuffer = new Buffer(base64Image, "base64");
|
|
fs.writeFileSync("image.jpg", imageBuffer);
|
|
console.log("wrote image");
|
|
check = req.body.plate;
|
|
}
|
|
else {
|
|
console.log("conflic plate");
|
|
}
|
|
});
|
|
|
|
res.send({ "status": "Done!" });
|
|
};
|