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;