You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
65 lines
1.6 KiB
65 lines
1.6 KiB
const fs=require('fs');
|
|
const moment=require('moment');
|
|
var mysql = require('mysql');
|
|
const LZString = require('lz-string');
|
|
const e = require("express");
|
|
var connection = mysql.createConnection({
|
|
host : 'localhost',
|
|
user : 'root',
|
|
password : '416416',
|
|
database : 'neigongda'
|
|
});
|
|
function decompressText(compressedText) {
|
|
return LZString.decompressFromEncodedURIComponent(compressedText);
|
|
}
|
|
connection.connect();
|
|
|
|
function qjkebiao(xuehao,start,end) {
|
|
const startxueiq=moment("2024-09-02T00:00:27+08:00");
|
|
const daystart=moment(start).diff(startxueiq,"days");
|
|
const dayend=moment(end).diff(startxueiq,"days");
|
|
console.log(daystart);
|
|
const minutestart=moment(start).minutes()+moment(start).hours()*60;
|
|
const minutesend=moment(end).minutes()+moment(end).hours()*60;
|
|
let kestart=0;
|
|
if(minutestart<500){
|
|
kestart=1;
|
|
}else if(minutestart<620){
|
|
kestart=2;
|
|
}else if(minutestart<840){
|
|
kestart=3;
|
|
}else if(minutestart<960){
|
|
kestart=4;
|
|
}else {
|
|
kestart=5;
|
|
}
|
|
let keend=0;
|
|
if(minutesend>1060){
|
|
keend=4;
|
|
}else if(minutesend<940){
|
|
keend=3;
|
|
}else if(minutesend<720){
|
|
keend=2;
|
|
}else if(minutesend<600){
|
|
keend=1;
|
|
}else {
|
|
keend=0;
|
|
}
|
|
const kaishi=daystart+kestart*4;
|
|
const jieshu=dayend+keend*4;
|
|
const sql = 'SELECT xunhuan(?,?,?)';
|
|
|
|
|
|
connection.query(sql, [kaishi,jieshu,xuehao], (error, results, fields) => {
|
|
if (error) throw error;
|
|
|
|
// 处理查询结果
|
|
console.log(results);
|
|
});
|
|
console.log(dayend);
|
|
return 0;
|
|
}
|
|
|
|
exports.qjkebiao = qjkebiao;
|
|
|