old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
| | |
|---|
| | | const Koa = require("koa");
|
|---|
| | | const Koa = require("koa");
|
|---|
| | | const app = new Koa();
|
|---|
| | | const views = require("koa-views");
|
|---|
| | | const router = require('koa-router');
|
|---|
| | |
|---|
| | | cors({
|
|---|
| | | origin: function(ctx) {
|
|---|
| | | const whiteList = [
|
|---|
| | | "http://192.168.119.100:8080",
|
|---|
| | | "http://192.168.119.100",
|
|---|
| | | "http://192.168.0.8:8080",
|
|---|
| | | "http://192.168.0.8",
|
|---|
| | | "http://localhost:8080",
|
|---|
| | | "http://localhost",
|
|---|
| | | "http://localhost:9380",
|
|---|
| | | "http://127.0.0.1",
|
|---|
| | | "http://127.0.0.1:8080",
|
|---|
| | | "http://resgis.sh.cn",
|
|---|
| | | "http://223.167.111.168:7001",
|
|---|
| | | "http://223.167.111.168:7002",
|
|---|
| | | "http://223.167.111.168:8004",
|
|---|
| | | "http://223.167.111.168:7001/",
|
|---|
| | | "http://223.167.111.168:7002/",
|
|---|
| | | "http://223.167.111.168:8004/",
|
|---|
| | | ];
|
|---|
| | | if (ctx.url === "/user/") {
|
|---|
| | | return "*"; //Â å
许æ¥èªææåå请æ±
|
|---|
| | |
|---|
| | | );
|
|---|
| | |
|
|---|
| | | // logger
|
|---|
| | | const logsUtil = require("./utils/logs.js");
|
|---|
| | | //const logsUtil = require("./utils/logs.js");
|
|---|
| | | app.use(async (ctx, next) => {
|
|---|
| | | console.log("------------------------------");
|
|---|
| | | console.log(ctx);
|
|---|
| | |
|---|
| | | try {
|
|---|
| | | await next();
|
|---|
| | | intervals = new Date() - start;
|
|---|
| | | logsUtil.logResponse(ctx, intervals); //è®°å½ååºæ¥å¿
|
|---|
| | | //logsUtil.logResponse(ctx, intervals); //è®°å½ååºæ¥å¿
|
|---|
| | | } catch (error) {
|
|---|
| | | intervals = new Date() - start;
|
|---|
| | | logsUtil.logError(ctx, error, intervals); //è®°å½å¼å¸¸æ¥å¿
|
|---|
| | | //logsUtil.logError(ctx, error, intervals); //è®°å½å¼å¸¸æ¥å¿
|
|---|
| | | }
|
|---|
| | | });
|
|---|
| | |
|
|---|
| | | /*
|
|---|
| | | const server = require("http").Server(app.callback());
|
|---|
| | | const io = require("socket.io")(server);
|
|---|
| | | io.on("connection", (socket) => {
|
|---|
| | |
|---|
| | | }, 3000000);
|
|---|
| | |
|
|---|
| | | server.listen(3030);
|
|---|
| | | */
|
|---|
| | |
|
|---|
| | | const schedule_ = require("./models/taskSchedule.js");
|
|---|
| | | schedule_.job_();
|
|---|
old mode 100644
new mode 100755
old mode 100644
new mode 100755
| | |
|---|
| | | module.exports = {
|
|---|
| | | mysql_config: {
|
|---|
| | | host: '58.246.27.194',
|
|---|
| | | host: '192.168.0.8',
|
|---|
| | | database: 'sxyd',
|
|---|
| | | port: '6002',
|
|---|
| | | user: 'genpang',
|
|---|
| | | password: 'genpang@123'
|
|---|
| | | port: '3306',
|
|---|
| | | user: 'root',
|
|---|
| | | password: 'SX64955008HB'
|
|---|
| | | },
|
|---|
| | | db_remote: {
|
|---|
| | | host: '58.246.27.194',
|
|---|
| | | host: '192.168.0.8',
|
|---|
| | | database: 'sxyd',
|
|---|
| | | port: '6002',
|
|---|
| | | user: 'genpang',
|
|---|
| | | password: 'genpang@123'
|
|---|
| | | port: '3306',
|
|---|
| | | user: 'root',
|
|---|
| | | password: 'SX64955008HB'
|
|---|
| | | },
|
|---|
| | | db_remote_server: {
|
|---|
| | | host: '58.246.27.194',
|
|---|
| | | host: '192.168.0.8',
|
|---|
| | | database: 'sxyd',
|
|---|
| | | port: '6002',
|
|---|
| | | user: 'genpang',
|
|---|
| | | password: 'genpang@123'
|
|---|
| | | port: '3306',
|
|---|
| | | user: 'root',
|
|---|
| | | password: 'SX64955008HB'
|
|---|
| | | }
|
|---|
| | | // mysql_config: {
|
|---|
| | | // host: '127.0.0.1',
|
|---|
| | | // database: 'sxyd',
|
|---|
| | | // port: '20210',
|
|---|
| | | // user: 'root',
|
|---|
| | | // password: 'qwer%1234'
|
|---|
| | | // },
|
|---|
| | | // db_remote: {
|
|---|
| | | // host: '127.0.0.1',
|
|---|
| | | // database: 'sxyd',
|
|---|
| | | // port: '20210',
|
|---|
| | | // user: 'root',
|
|---|
| | | // password: 'qwer%1234'
|
|---|
| | | // },
|
|---|
| | | // db_remote_server: {
|
|---|
| | | // host: '127.0.0.1',
|
|---|
| | | // database: 'sxyd',
|
|---|
| | | // port: '20210',
|
|---|
| | | // user: 'root',
|
|---|
| | | // password: 'qwer%1234'
|
|---|
| | | // },
|
|---|
| | | //223.167.111.168 10026 root SX64955008HB
|
|---|
| | | //58.246.27.194 6002 sxyd genpang@123
|
|---|
| | | }
|
|---|
| | |
|
|---|
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
Binary files differ
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
| | |
|---|
| | | var jsonData = '';//åå¨å¤©æ°ä¿¡æ¯
|
|---|
| | | // å®ä¹è§å
|
|---|
| | | let rule = new schedule.RecurrenceRule();
|
|---|
| | | rule.minute = [15,30,45,55]
|
|---|
| | | rule.minute = [1,6,11,16,21,26,31,36,41,46,51,56]
|
|---|
| | | //rule.second = [30, 60]; // æ¯é 10 ç§æ§è¡ä¸æ¬¡
|
|---|
| | |
|
|---|
| | |
|
|---|
| | |
|---|
| | |
|
|---|
| | | schedule.scheduleJob(rule, async () => {//æ¯å°æ¶å®æ¶å天æ°æ°æ®
|
|---|
| | | //https://devapi.heweather.net/v7/weather/now?location=101021700&key=495b433d21c84986a99c4ac52d42fd3b
|
|---|
| | | let urlstr = "https://devapi.heweather.net/v7/weather/now?location=location_code&key=fca708c817034474b6969579ab61a380";
|
|---|
| | | // 1. æ£æµå½åæ¯å¦å·²æ天æ°æ°æ®
|
|---|
| | | let sqlstr = `select count(1) as counter from t_d_weather_hour where TO_DAYS(now())=TO_DAYS(posttime) and HOUR(now())=hour(posttime) and posttime> date_sub(now(), interval 1 hour)`;
|
|---|
| | | let lastdata_times = await mysql.query_data(sqlstr, 'master', null);
|
|---|
| | | if( lastdata_times[0].counter > 0 ) { return ;}
|
|---|
| | | // 2.è¥å½åæ 天æ°æ°æ®ï¼éæ°æå
|
|---|
| | | let urlstr = "https://devapi.heweather.net/v7/weather/now?location=location_code&key=495b433d21c84986a99c4ac52d42fd3b";
|
|---|
| | | sqlstr = `select * from t_s_weather_city order by code`;
|
|---|
| | | let data_rets = await mysql.query_data(sqlstr, 'master', null)
|
|---|
| | | for (let index = 0; index < data_rets.length; index++) {
|
|---|
| | | let element = data_rets[index];
|
|---|
| | | // æ£æµå½åæ¯å¦å·²æ天æ°æ°æ®
|
|---|
| | | let sqlstr = `select count(1) as counter from t_d_weather_hour where citycode='`+element.code+`' and TO_DAYS(now())=TO_DAYS(posttime) and HOUR(now())=hour(posttime) `;
|
|---|
| | | let lastdata_times = await mysql.query_data(sqlstr, 'master', null);
|
|---|
| | | console.log(lastdata_times[0].counter);
|
|---|
| | | console.log(lastdata_times[0].counter > 0)
|
|---|
| | | if( lastdata_times[0].counter > 0 ) { continue ;}
|
|---|
| | | // è¥å½åæ 天æ°æ°æ®ï¼éæ°æå |
|---|
| | | axios.get(urlstr.replace('location_code', element.code)).then(response => {
|
|---|
| | | console.log(response.data)
|
|---|
| | | if(response.data.now) {
|
|---|
| | | let w = response.data.now;
|
|---|
| | | let posttime_ = w.obsTime.replace('T',' ').substr(0,13)+ ':00:00';
|
|---|
| | | let currHours = (new Date()).getHours();
|
|---|
| | | let postHours = (new Date(posttime_)).getHours();
|
|---|
| | | if(postHours == currHours) {
|
|---|
| | | let sql_ = `insert into t_d_weather_hour (type,citycode,cityname,posttime,temp,feelsLike,icon,text,wind360,windDir,windScale,windSpeed,humidity,precip,pressure,vis,cloud,dew,responsedata) |
|---|
| | | values ('${element.type}','${element.code}','${element.name}','${posttime_}','${w.temp}','${w.feelsLike}','${w.icon}','${w.text}','${w.wind360}',
|
|---|
| | | '${w.windDir}','${w.windScale}','${w.windSpeed}','${w.humidity}','${w.precip}','${w.pressure}','${w.vis}','${w.cloud}','${w.dew}','${JSON.stringify(response.data)}'
|
|---|
| | | )`;
|
|---|
| | | mysql.query_data(sql_, 'master', null)
|
|---|
| | | }
|
|---|
| | | let sql_ = `insert into t_d_weather_hour (type,citycode,cityname,posttime,temp,feelsLike,icon,text,wind360,windDir,windScale,windSpeed,humidity,precip,pressure,vis,cloud,dew,responsedata) |
|---|
| | | values ('${element.type}','${element.code}','${element.name}','${posttime_}','${w.temp}','${w.feelsLike}','${w.icon}','${w.text}','${w.wind360}',
|
|---|
| | | '${w.windDir}','${w.windScale}','${w.windSpeed}','${w.humidity}','${w.precip}','${w.pressure}','${w.vis}','${w.cloud}','${w.dew}','${JSON.stringify(response.data)}'
|
|---|
| | | )`;
|
|---|
| | | mysql.query_data(sql_, 'master', null)
|
|---|
| | | }
|
|---|
| | | }).catch(error => {
|
|---|
| | | console.log(error);
|
|---|
| | |
|---|
| | |
|
|---|
| | | schedule.scheduleJob(rule, async () => {//æ¯å¤©å®æ¶æ´æ°å¤©æ°æ°æ®
|
|---|
| | | //https://devapi.qweather.com/v7/weather/3d?location=101021700&key=495b433d21c84986a99c4ac52d42fd3b
|
|---|
| | | |
|---|
| | | let urlstr = "https://devapi.qweather.com/v7/weather/3d?location=location_code&key=fca708c817034474b6969579ab61a380";
|
|---|
| | | // 1. æ£æµå½åæ¯å¦å·²æ天æ°æ°æ®
|
|---|
| | | let sqlstr = `select count(1) as counter from t_d_weather_day where TO_DAYS(now())=TO_DAYS(posttime)`;
|
|---|
| | | let lastdata_times = await mysql.query_data(sqlstr, 'master', null);
|
|---|
| | | if( lastdata_times[0].counter > 0 ) { return ;}
|
|---|
| | | // 2.è¥å½åæ 天æ°æ°æ®ï¼éæ°æå
|
|---|
| | | let urlstr = "https://devapi.qweather.com/v7/weather/3d?location=location_code&key=495b433d21c84986a99c4ac52d42fd3b";
|
|---|
| | | sqlstr = `select * from t_s_weather_city order by code`;
|
|---|
| | | let data_rets = await mysql.query_data(sqlstr, 'master', null)
|
|---|
| | | for (let index = 0; index < data_rets.length; index++) {
|
|---|
| | | let element = data_rets[index];
|
|---|
| | | // æ£æµå½åæ¯å¦å·²æ天æ°æ°æ®
|
|---|
| | | let sqlstr = `select count(1) as counter from t_d_weather_day where citycode='`+element.code+`' and TO_DAYS(now())=TO_DAYS(posttime)`;
|
|---|
| | | let lastdata_times = await mysql.query_data(sqlstr, 'master', null);
|
|---|
| | | if( lastdata_times[0].counter > 0 ) { continue ;} |
|---|
| | | // è¥å½åæ 天æ°æ°æ®ï¼éæ°æå
|
|---|
| | | axios.get(urlstr.replace('location_code', element.code)).then(response => {
|
|---|
| | | if(response.data.daily) {
|
|---|
| | | let w = response.data.daily[0];
|
|---|
| | | let posttime_ = w.fxDate+ ' 00:00:00';
|
|---|
| | | let currdate = (new Date()).getDate();
|
|---|
| | | let postdate = (new Date(posttime_)).getDate();
|
|---|
| | | if (currdate == postdate) { |
|---|
| | | let sql_ = `insert into t_d_weather_day (type,citycode,cityname,posttime,iconNight,iconDay,humidity,precip,pressure,vis,cloud,
|
|---|
| | | moonPhase,moonPhaseIcon,moonrise,moonset,sunrise,sunset,tempMax,tempMin,textDay,textNight,uvIndex,
|
|---|
| | | wind360Day,windDirDay,wind360Night,windDirNight,windScaleDay,windScaleNight,windSpeedDay,windSpeedNight,responsedata) |
|---|
| | | values ('${element.type}','${element.code}','${element.name}','${posttime_}','${w.iconNight}','${w.iconDay}','${w.humidity}','${w.precip}','${w.pressure}','${w.vis}',
|
|---|
| | | '${w.cloud}','${w.moonPhase}','${w.moonPhaseIcon}','${w.moonrise}','${w.moonset}','${w.sunrise}','${w.sunset}','${w.tempMax}','${w.tempMin}','${w.textDay}','${w.textNight}','${w.uvIndex}',
|
|---|
| | | '${w.wind360Day}','${w.windDirDay}','${w.wind360Night}','${w.windDirNight}','${w.windScaleDay}','${w.windScaleNight}','${w.windSpeedDay}','${w.windSpeedNight}',
|
|---|
| | | '${JSON.stringify(response.data)}'
|
|---|
| | | )`;
|
|---|
| | | mysql.query_data(sql_, 'master', null)
|
|---|
| | | }
|
|---|
| | | let sql_ = `insert into t_d_weather_day (type,citycode,cityname,posttime,iconNight,iconDay,humidity,precip,pressure,vis,cloud,
|
|---|
| | | moonPhase,moonPhaseIcon,moonrise,moonset,sunrise,sunset,tempMax,tempMin,textDay,textNight,uvIndex,
|
|---|
| | | wind360Day,windDirDay,wind360Night,windDirNight,windScaleDay,windScaleNight,windSpeedDay,windSpeedNight,responsedata) |
|---|
| | | values ('${element.type}','${element.code}','${element.name}','${posttime_}','${w.iconNight}','${w.iconDay}','${w.humidity}','${w.precip}','${w.pressure}','${w.vis}',
|
|---|
| | | '${w.cloud}','${w.moonPhase}','${w.moonPhaseIcon}','${w.moonrise}','${w.moonset}','${w.sunrise}','${w.sunset}','${w.tempMax}','${w.tempMin}','${w.textDay}','${w.textNight}','${w.uvIndex}',
|
|---|
| | | '${w.wind360Day}','${w.windDirDay}','${w.wind360Night}','${w.windDirNight}','${w.windScaleDay}','${w.windScaleNight}','${w.windSpeedDay}','${w.windSpeedNight}',
|
|---|
| | | '${JSON.stringify(response.data)}'
|
|---|
| | | )`;
|
|---|
| | | mysql.query_data(sql_, 'master', null)
|
|---|
| | | }
|
|---|
| | | }).catch(error => {
|
|---|
| | | console.log(error);
|
|---|
old mode 100644
new mode 100755
old mode 100644
new mode 100755
| | |
|---|
| | | "deep-extend": {
|
|---|
| | | "version": "0.6.0",
|
|---|
| | | "resolved": "https://registry.npmjs.org/deep-extend/-/deep-extend-0.6.0.tgz",
|
|---|
| | | "integrity": "sha512-LOHxIOaPYdHlJRtCQfDIVZtfw/ufM8+rVj649RIHzcm/vGwQRXFt6OPqIFWsm2XEMrNIEtWR64sY1LEKD2vAOA==",
|
|---|
| | | "dev": true
|
|---|
| | | "integrity": "sha512-LOHxIOaPYdHlJRtCQfDIVZtfw/ufM8+rVj649RIHzcm/vGwQRXFt6OPqIFWsm2XEMrNIEtWR64sY1LEKD2vAOA=="
|
|---|
| | | },
|
|---|
| | | "deep-is": {
|
|---|
| | | "version": "0.1.4",
|
|---|
| | |
|---|
| | | "integrity": "sha1-SMptcvbGo68Aqa1K5odr44ieKwk=",
|
|---|
| | | "dev": true
|
|---|
| | | },
|
|---|
| | | "ignore-walk": {
|
|---|
| | | "version": "3.0.4",
|
|---|
| | | "resolved": "https://registry.npmjs.org/ignore-walk/-/ignore-walk-3.0.4.tgz",
|
|---|
| | | "integrity": "sha512-PY6Ii8o1jMRA1z4F2hRkH/xN59ox43DavKvD3oDpfurRlOJyAHpifIwpbdv1n4jt4ov0jSpw3kQ4GhJnpBL6WQ==",
|
|---|
| | | "requires": {
|
|---|
| | | "minimatch": "^3.0.4"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "immediate": {
|
|---|
| | | "version": "3.0.6",
|
|---|
| | | "resolved": "https://registry.npmjs.org/immediate/-/immediate-3.0.6.tgz",
|
|---|
| | |
|---|
| | | "ini": {
|
|---|
| | | "version": "1.3.7",
|
|---|
| | | "resolved": "https://registry.npmjs.org/ini/-/ini-1.3.7.tgz",
|
|---|
| | | "integrity": "sha512-iKpRpXP+CrP2jyrxvg1kMUpXDyRUFDWurxbnVT1vQPx+Wz9uCYsMIqYuSBLV+PAaZG/d7kRLKRFc9oDMsH+mFQ==",
|
|---|
| | | "dev": true
|
|---|
| | | "integrity": "sha512-iKpRpXP+CrP2jyrxvg1kMUpXDyRUFDWurxbnVT1vQPx+Wz9uCYsMIqYuSBLV+PAaZG/d7kRLKRFc9oDMsH+mFQ=="
|
|---|
| | | },
|
|---|
| | | "ip": {
|
|---|
| | | "version": "1.1.5",
|
|---|
| | |
|---|
| | | "resolved": "https://registry.npmjs.org/lodash.union/-/lodash.union-4.6.0.tgz",
|
|---|
| | | "integrity": "sha1-SLtQiECfFvGCFmZkHETdGqrjzYg="
|
|---|
| | | },
|
|---|
| | | "log4js": {
|
|---|
| | | "version": "4.4.0",
|
|---|
| | | "resolved": "https://registry.npmjs.org/log4js/-/log4js-4.4.0.tgz",
|
|---|
| | | "integrity": "sha512-xwRvmxFsq8Hb7YeS+XKfvCrsH114bXex6mIwJ2+KmYVi23pB3+hlzyGq1JPycSFTJWNLhD/7PCtM0RfPy6/2yg==",
|
|---|
| | | "requires": {
|
|---|
| | | "date-format": "^2.0.0",
|
|---|
| | | "debug": "^4.1.1",
|
|---|
| | | "flatted": "^2.0.0",
|
|---|
| | | "rfdc": "^1.1.4",
|
|---|
| | | "streamroller": "^1.0.5"
|
|---|
| | | },
|
|---|
| | | "dependencies": {
|
|---|
| | | "debug": {
|
|---|
| | | "version": "4.1.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/debug/-/debug-4.1.1.tgz",
|
|---|
| | | "integrity": "sha512-pYAIzeRo8J6KPEaJ0VWOh5Pzkbw/RetuzehGM7QRRX5he4fPHx2rdKMB256ehJCkX+XRQm16eZLqLNS8RSZXZw==",
|
|---|
| | | "requires": {
|
|---|
| | | "ms": "^2.1.1"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "ms": {
|
|---|
| | | "version": "2.1.2",
|
|---|
| | | "resolved": "https://registry.npmjs.org/ms/-/ms-2.1.2.tgz",
|
|---|
| | | "integrity": "sha512-sGkPx+VjMtmA6MX27oA4FBFELFCZZ4S4XqeGOXCv68tT+jb3vk/RyaKWP0PTKyWtmLSM0b+adUTEvbs1PEaH2w=="
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "long-timeout": {
|
|---|
| | | "version": "0.1.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/long-timeout/-/long-timeout-0.1.1.tgz",
|
|---|
| | |
|---|
| | | "resolved": "https://registry.npmjs.org/ncp/-/ncp-0.6.0.tgz",
|
|---|
| | | "integrity": "sha1-34zgIeJiviG1L+s9Plz6qxJJHw0="
|
|---|
| | | },
|
|---|
| | | "needle": {
|
|---|
| | | "version": "2.9.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/needle/-/needle-2.9.1.tgz",
|
|---|
| | | "integrity": "sha512-6R9fqJ5Zcmf+uYaFgdIHmLwNldn5HbK8L5ybn7Uz+ylX/rnOsSp1AHcvQSrCaFN+qNM1wpymHqD7mVasEOlHGQ==",
|
|---|
| | | "requires": {
|
|---|
| | | "debug": "^3.2.6",
|
|---|
| | | "iconv-lite": "^0.4.4",
|
|---|
| | | "sax": "^1.2.4"
|
|---|
| | | },
|
|---|
| | | "dependencies": {
|
|---|
| | | "debug": {
|
|---|
| | | "version": "3.2.7",
|
|---|
| | | "resolved": "https://registry.npmjs.org/debug/-/debug-3.2.7.tgz",
|
|---|
| | | "integrity": "sha512-CFjzYYAi4ThfiQvizrFQevTTXHtnCqWfe7x1AhgEscTz6ZbLbfoLRLPugTQyBth6f8ZERVUSyWHFD/7Wu4t1XQ==",
|
|---|
| | | "requires": {
|
|---|
| | | "ms": "^2.1.1"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "ms": {
|
|---|
| | | "version": "2.1.3",
|
|---|
| | | "resolved": "https://registry.npmjs.org/ms/-/ms-2.1.3.tgz",
|
|---|
| | | "integrity": "sha512-6FlzubTLZG3J2a/NVCAleEhjzq5oxgHyaCU9yYXvcLsvoVaHJq/s5xXI6/XXP6tz7R9xAOtHnSO/tXtF3WRTlA=="
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "negotiator": {
|
|---|
| | | "version": "0.6.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/negotiator/-/negotiator-0.6.1.tgz",
|
|---|
| | |
|---|
| | | "version": "4.0.0",
|
|---|
| | | "resolved": "https://registry.npmjs.org/yallist/-/yallist-4.0.0.tgz",
|
|---|
| | | "integrity": "sha512-3wdGidZyq5PB084XLES5TpOSRA3wjXAlIWMhum2kRcv/41Sn2emQ0dycQW4uZXLejwKvg6EsvbdlVL+FYEct7A=="
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "node-pre-gyp": {
|
|---|
| | | "version": "0.17.0",
|
|---|
| | | "resolved": "https://registry.npmjs.org/node-pre-gyp/-/node-pre-gyp-0.17.0.tgz",
|
|---|
| | | "integrity": "sha512-abzZt1hmOjkZez29ppg+5gGqdPLUuJeAEwVPtHYEJgx0qzttCbcKFpxrCQn2HYbwCv2c+7JwH4BgEzFkUGpn4A==",
|
|---|
| | | "requires": {
|
|---|
| | | "detect-libc": "^1.0.3",
|
|---|
| | | "mkdirp": "^0.5.5",
|
|---|
| | | "needle": "^2.5.2",
|
|---|
| | | "nopt": "^4.0.3",
|
|---|
| | | "npm-packlist": "^1.4.8",
|
|---|
| | | "npmlog": "^4.1.2",
|
|---|
| | | "rc": "^1.2.8",
|
|---|
| | | "rimraf": "^2.7.1",
|
|---|
| | | "semver": "^5.7.1",
|
|---|
| | | "tar": "^4.4.13"
|
|---|
| | | },
|
|---|
| | | "dependencies": {
|
|---|
| | | "chownr": {
|
|---|
| | | "version": "1.1.4",
|
|---|
| | | "resolved": "https://registry.npmjs.org/chownr/-/chownr-1.1.4.tgz",
|
|---|
| | | "integrity": "sha512-jJ0bqzaylmJtVnNgzTeSOs8DPavpbYgEr/b0YL8/2GO3xJEhInFmhKMUnEJQjZumK7KXGFhUy89PrsJWlakBVg=="
|
|---|
| | | },
|
|---|
| | | "fs-minipass": {
|
|---|
| | | "version": "1.2.7",
|
|---|
| | | "resolved": "https://registry.npmjs.org/fs-minipass/-/fs-minipass-1.2.7.tgz",
|
|---|
| | | "integrity": "sha512-GWSSJGFy4e9GUeCcbIkED+bgAoFyj7XF1mV8rma3QW4NIqX9Kyx79N/PF61H5udOV3aY1IaMLs6pGbH71nlCTA==",
|
|---|
| | | "requires": {
|
|---|
| | | "minipass": "^2.6.0"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "minipass": {
|
|---|
| | | "version": "2.9.0",
|
|---|
| | | "resolved": "https://registry.npmjs.org/minipass/-/minipass-2.9.0.tgz",
|
|---|
| | | "integrity": "sha512-wxfUjg9WebH+CUDX/CdbRlh5SmfZiy/hpkxaRI16Y9W56Pa75sWgd/rvFilSgrauD9NyFymP/+JFV3KwzIsJeg==",
|
|---|
| | | "requires": {
|
|---|
| | | "safe-buffer": "^5.1.2",
|
|---|
| | | "yallist": "^3.0.0"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "minizlib": {
|
|---|
| | | "version": "1.3.3",
|
|---|
| | | "resolved": "https://registry.npmjs.org/minizlib/-/minizlib-1.3.3.tgz",
|
|---|
| | | "integrity": "sha512-6ZYMOEnmVsdCeTJVE0W9ZD+pVnE8h9Hma/iOwwRDsdQoePpoX56/8B6z3P9VNwppJuBKNRuFDRNRqRWexT9G9Q==",
|
|---|
| | | "requires": {
|
|---|
| | | "minipass": "^2.9.0"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "nopt": {
|
|---|
| | | "version": "4.0.3",
|
|---|
| | | "resolved": "https://registry.npmjs.org/nopt/-/nopt-4.0.3.tgz",
|
|---|
| | | "integrity": "sha512-CvaGwVMztSMJLOeXPrez7fyfObdZqNUK1cPAEzLHrTybIua9pMdmmPR5YwtfNftIOMv3DPUhFaxsZMNTQO20Kg==",
|
|---|
| | | "requires": {
|
|---|
| | | "abbrev": "1",
|
|---|
| | | "osenv": "^0.1.4"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "rimraf": {
|
|---|
| | | "version": "2.7.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/rimraf/-/rimraf-2.7.1.tgz",
|
|---|
| | | "integrity": "sha512-uWjbaKIK3T1OSVptzX7Nl6PvQ3qAGtKEtVRjRuazjfL3Bx5eI409VZSqgND+4UNnmzLVdPj9FqFJNPqBZFve4w==",
|
|---|
| | | "requires": {
|
|---|
| | | "glob": "^7.1.3"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "safe-buffer": {
|
|---|
| | | "version": "5.2.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/safe-buffer/-/safe-buffer-5.2.1.tgz",
|
|---|
| | | "integrity": "sha512-rp3So07KcdmmKbGvgaNxQSJr7bGVSVk5S9Eq1F+ppbRo70+YeaDxkw5Dd8NPN+GD6bjnYm2VuPuCXmpuYvmCXQ=="
|
|---|
| | | },
|
|---|
| | | "semver": {
|
|---|
| | | "version": "5.7.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/semver/-/semver-5.7.1.tgz",
|
|---|
| | | "integrity": "sha512-sauaDf/PZdVgrLTNYHRtpXa1iRiKcaebiKQ1BJdpQlWH2lCvexQdX55snPFyK7QzpudqbCI0qXFfOasHdyNDGQ=="
|
|---|
| | | },
|
|---|
| | | "tar": {
|
|---|
| | | "version": "4.4.19",
|
|---|
| | | "resolved": "https://registry.npmjs.org/tar/-/tar-4.4.19.tgz",
|
|---|
| | | "integrity": "sha512-a20gEsvHnWe0ygBY8JbxoM4w3SJdhc7ZAuxkLqh+nvNQN2IOt0B5lLgM490X5Hl8FF0dl0tOf2ewFYAlIFgzVA==",
|
|---|
| | | "requires": {
|
|---|
| | | "chownr": "^1.1.4",
|
|---|
| | | "fs-minipass": "^1.2.7",
|
|---|
| | | "minipass": "^2.9.0",
|
|---|
| | | "minizlib": "^1.3.3",
|
|---|
| | | "mkdirp": "^0.5.5",
|
|---|
| | | "safe-buffer": "^5.2.1",
|
|---|
| | | "yallist": "^3.1.1"
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | |
|---|
| | | "resolved": "https://registry.npmjs.org/normalize-url/-/normalize-url-4.5.1.tgz",
|
|---|
| | | "integrity": "sha512-9UZCFRHQdNrfTpGg8+1INIg93B6zE0aXMVFkw1WFwvO4SlZywU6aLg5Of0Ap/PgcbSw4LNxvMWXMeugwMCX0AA==",
|
|---|
| | | "dev": true
|
|---|
| | | },
|
|---|
| | | "npm-bundled": {
|
|---|
| | | "version": "1.1.2",
|
|---|
| | | "resolved": "https://registry.npmjs.org/npm-bundled/-/npm-bundled-1.1.2.tgz",
|
|---|
| | | "integrity": "sha512-x5DHup0SuyQcmL3s7Rx/YQ8sbw/Hzg0rj48eN0dV7hf5cmQq5PXIeioroH3raV1QC1yh3uTYuMThvEQF3iKgGQ==",
|
|---|
| | | "requires": {
|
|---|
| | | "npm-normalize-package-bin": "^1.0.1"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "npm-normalize-package-bin": {
|
|---|
| | | "version": "1.0.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/npm-normalize-package-bin/-/npm-normalize-package-bin-1.0.1.tgz",
|
|---|
| | | "integrity": "sha512-EPfafl6JL5/rU+ot6P3gRSCpPDW5VmIzX959Ob1+ySFUuuYHWHekXpwdUZcKP5C+DS4GEtdJluwBjnsNDl+fSA=="
|
|---|
| | | },
|
|---|
| | | "npm-packlist": {
|
|---|
| | | "version": "1.4.8",
|
|---|
| | | "resolved": "https://registry.npmjs.org/npm-packlist/-/npm-packlist-1.4.8.tgz",
|
|---|
| | | "integrity": "sha512-5+AZgwru5IevF5ZdnFglB5wNlHG1AOOuw28WhUq8/8emhBmLv6jX5by4WJCh7lW0uSYZYS6DXqIsyZVIXRZU9A==",
|
|---|
| | | "requires": {
|
|---|
| | | "ignore-walk": "^3.0.1",
|
|---|
| | | "npm-bundled": "^1.0.1",
|
|---|
| | | "npm-normalize-package-bin": "^1.0.1"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "npmlog": {
|
|---|
| | | "version": "4.1.2",
|
|---|
| | |
|---|
| | | "resolved": "https://registry.npmjs.org/options/-/options-0.0.6.tgz",
|
|---|
| | | "integrity": "sha1-7CLTEoBrtT5zF3Pnza788cZDEo8="
|
|---|
| | | },
|
|---|
| | | "os-homedir": {
|
|---|
| | | "version": "1.0.2",
|
|---|
| | | "resolved": "https://registry.npmjs.org/os-homedir/-/os-homedir-1.0.2.tgz",
|
|---|
| | | "integrity": "sha512-B5JU3cabzk8c67mRRd3ECmROafjYMXbuzlwtqdM8IbS8ktlTix8aFGb2bAGKrSRIlnfKwovGUUr72JUPyOb6kQ=="
|
|---|
| | | },
|
|---|
| | | "os-name": {
|
|---|
| | | "version": "1.0.3",
|
|---|
| | | "resolved": "https://registry.npmjs.org/os-name/-/os-name-1.0.3.tgz",
|
|---|
| | |
|---|
| | | "requires": {
|
|---|
| | | "osx-release": "^1.0.0",
|
|---|
| | | "win-release": "^1.0.0"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "os-tmpdir": {
|
|---|
| | | "version": "1.0.2",
|
|---|
| | | "resolved": "https://registry.npmjs.org/os-tmpdir/-/os-tmpdir-1.0.2.tgz",
|
|---|
| | | "integrity": "sha512-D2FR03Vir7FIu45XBY20mTb+/ZSWB00sjU9jdQXt83gDrI4Ztz5Fs7/yy74g2N5SVQY4xY1qDr4rNddwYRVX0g=="
|
|---|
| | | },
|
|---|
| | | "osenv": {
|
|---|
| | | "version": "0.1.5",
|
|---|
| | | "resolved": "https://registry.npmjs.org/osenv/-/osenv-0.1.5.tgz",
|
|---|
| | | "integrity": "sha512-0CWcCECdMVc2Rw3U5w9ZjqX6ga6ubk1xDVKxtBQPK7wis/0F2r9T6k4ydGYhecl7YUBxBVxhL5oisPsNxAPe2g==",
|
|---|
| | | "requires": {
|
|---|
| | | "os-homedir": "^1.0.0",
|
|---|
| | | "os-tmpdir": "^1.0.0"
|
|---|
| | | }
|
|---|
| | | },
|
|---|
| | | "osx-release": {
|
|---|
| | |
|---|
| | | "version": "1.2.8",
|
|---|
| | | "resolved": "https://registry.npmjs.org/rc/-/rc-1.2.8.tgz",
|
|---|
| | | "integrity": "sha512-y3bGgqKj3QBdxLbLkomlohkvsA8gdAiUQlSBJnBhfn+BPxg4bc62d8TcBW15wavDfgexCgccckhcZvywyQYPOw==",
|
|---|
| | | "dev": true,
|
|---|
| | | "requires": {
|
|---|
| | | "deep-extend": "^0.6.0",
|
|---|
| | | "ini": "~1.3.0",
|
|---|
| | |
|---|
| | | "strip-json-comments": {
|
|---|
| | | "version": "2.0.1",
|
|---|
| | | "resolved": "https://registry.npmjs.org/strip-json-comments/-/strip-json-comments-2.0.1.tgz",
|
|---|
| | | "integrity": "sha1-PFMZQukIwml8DsNEhYwobHygpgo=",
|
|---|
| | | "dev": true
|
|---|
| | | "integrity": "sha1-PFMZQukIwml8DsNEhYwobHygpgo="
|
|---|
| | | },
|
|---|
| | | "supports-color": {
|
|---|
| | | "version": "2.0.0",
|
|---|
old mode 100644
new mode 100755
| | |
|---|
| | | "name": "am_server",
|
|---|
| | | "version": "0.1.0",
|
|---|
| | | "private": true,
|
|---|
| | | "bin": "./bin/www",
|
|---|
| | | "scripts": {
|
|---|
| | | "start": "nodemon ./bin/www",
|
|---|
| | | "test": "npm run nodemon --ignore ./package.json --exec electron .",
|
|---|
| | | "dev": "./node_modules/.bin/nodemon bin/www",
|
|---|
| | | "prd": "pm2 start bin/www",
|
|---|
| | | "test": "echo \"Error: no test specified\" && exit 1"
|
|---|
| | | "build": "electron-builder --win --x64",
|
|---|
| | | "pkg": "pkg . --out-path=./dist/",
|
|---|
| | | "package": "electron-builder build --win --x64"
|
|---|
| | | },
|
|---|
| | | "dependencies": {
|
|---|
| | | "@alicloud/pop-core": "^1.7.10",
|
|---|
| | | "@alicloud/sms-sdk": "^1.1.6",
|
|---|
| | | "async": "^3.1.0",
|
|---|
| | | "async": "^3.2.4",
|
|---|
| | | "await-busboy": "^1.0.3",
|
|---|
| | | "axios": "^0.21.4",
|
|---|
| | | "baidu-aip-sdk": "^2.0.2",
|
|---|
| | | "bcrypt": "^5.0.1",
|
|---|
| | | "crypto-js": "^4.0.0",
|
|---|
| | | "debug": "^2.6.3",
|
|---|
| | | "express": "^4.18.2",
|
|---|
| | | "formidable": "^1.2.2",
|
|---|
| | | "jpush-async": "^4.0.2",
|
|---|
| | | "jsonwebtoken": "^8.5.0",
|
|---|
| | |
|---|
| | | "koa-static": "^3.0.0",
|
|---|
| | | "koa-views": "^5.2.1",
|
|---|
| | | "koa2-cors": "^2.0.6",
|
|---|
| | | "log4js": "^4.4.0",
|
|---|
| | | "log4js": "^6.4.4",
|
|---|
| | | "node-gyp": "^8.2.0",
|
|---|
| | | "node-schedule": "^1.3.2",
|
|---|
| | | "node-uuid": "^1.4.8",
|
|---|
| | | "nodemailer": "^6.6.0",
|
|---|
| | | "officegen": "^0.6.3",
|
|---|
| | | "nodemailer": "^6.7.3",
|
|---|
| | | "officegen": "^0.6.5",
|
|---|
| | | "protobufjs": "^6.11.3",
|
|---|
| | | "pug": "^3.0.2",
|
|---|
| | | "request": "^2.88.2",
|
|---|
| | | "socket.io": "^4.1.2",
|
|---|
| | | "socket.io": "^4.4.1",
|
|---|
| | | "solarlunar": "^2.0.7",
|
|---|
| | | "ueditor": "^1.2.3"
|
|---|
| | | },
|
|---|
| | | "devDependencies": {
|
|---|
| | | "nodemon": "^2.0.7"
|
|---|
| | | "electron": "^8.2.0",
|
|---|
| | | "electron-builder": "^22.4.1",
|
|---|
| | | "nodemon": "^2.0.20",
|
|---|
| | | "webpack": "^5.74.0",
|
|---|
| | | "webpack-cli": "^4.10.0"
|
|---|
| | | },
|
|---|
| | | "build": {
|
|---|
| | | "electronDownload": {
|
|---|
| | | "mirror": "https://npm.taobao.org/mirrors/electron"
|
|---|
| | | },
|
|---|
| | | "productName": "åºç¨æå¡åå°",
|
|---|
| | | "appID": "com.sn.appnet",
|
|---|
| | | "copyright": "copyright @2021 wr",
|
|---|
| | | "extends": null,
|
|---|
| | | "directories": {
|
|---|
| | | "output": "release"
|
|---|
| | | },
|
|---|
| | | "mac": {
|
|---|
| | | "category": "public.app-category.developer-tools",
|
|---|
| | | "target": "default",
|
|---|
| | | "icon": "./public/icon.icns"
|
|---|
| | | },
|
|---|
| | | "win": {
|
|---|
| | | "icon": "./public/icon.ico",
|
|---|
| | | "target": [
|
|---|
| | | {
|
|---|
| | | "icon": "./public/icon.ico",
|
|---|
| | | "target": [
|
|---|
| | | {
|
|---|
| | | "target": "nsis",
|
|---|
| | | "arch": [
|
|---|
| | | "x64"
|
|---|
| | | ]
|
|---|
| | | }
|
|---|
| | | ]
|
|---|
| | | }
|
|---|
| | | ]
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | }
|
|---|
old mode 100644
new mode 100755
Binary files differ
old mode 100644
new mode 100755
old mode 100644
new mode 100755
| | |
|---|
| | | const bcrypt = require('bcrypt')
|
|---|
| | | const jwt = require('jsonwebtoken')
|
|---|
| | | const util = require('util')
|
|---|
| | | const logs = require('../utils/logs')
|
|---|
| | | const verify = util.promisify(jwt.verify)
|
|---|
| | | let secret = 'FM_Monitor'
|
|---|
| | | router.prefix('/apiSDK')
|
|---|
| | |
|---|
| | | let params = {
|
|---|
| | | RegionId: 'cn-shanghai',
|
|---|
| | | PhoneNumbers: data.phone,
|
|---|
| | | SignName: 'éæ³å¹¿æçæµç³»ç»ç»å½',
|
|---|
| | | SignName: 'ç³»ç»ç»å½',
|
|---|
| | | TemplateCode: 'SMS_175075457',
|
|---|
| | | TemplateParam: `{'code':'${code}'}`
|
|---|
| | | }
|
|---|
| | |
|---|
| | | const ms = new Date() - start //ååºæ¶é´
|
|---|
| | |
|
|---|
| | | data.logDes = `${user[0].user_name}ç»å½`
|
|---|
| | | logs.logLogin(ctx, ms, user[0].user_name)
|
|---|
| | | return (ctx.body = {
|
|---|
| | | code: 20000,
|
|---|
| | | token: token
|
|---|
old mode 100644
new mode 100755
old mode 100644
new mode 100755
| | |
|---|
| | | const router = require('koa-router')()
|
|---|
| | | const base = require('../models/base')
|
|---|
| | | const upload = require('../utils/upload')
|
|---|
| | | const recordAnalysis = require('../utils/recordAnalysis')
|
|---|
| | | const path = require('path')
|
|---|
| | | router.prefix('/base')
|
|---|
| | |
|
|---|
| | |
|---|
| | |
|
|---|
| | | //æ ¹æ®ä¸ä¼ 设å¤çç©çç¼å·ï¼æè¦æ±ç»ä¸åæ¾è®¾å¤å½é³æ件
|
|---|
| | | let filePathByDeviceId =
|
|---|
| | | path.join(__dirname, '../public/record') + `/${ctx.request.body.deviceId}`
|
|---|
| | | path.join(__dirname, '../public') + `/${ctx.request.body.deviceId}`
|
|---|
| | | if (!fs.existsSync(filePathByDeviceId)) {
|
|---|
| | | fs.mkdirSync(filePathByDeviceId)
|
|---|
| | | }
|
|---|
| | |
|---|
| | | code: 20000
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | // let voice = fs.readFileSync(path.resolve(__dirname,'../public/record/123.wav'));
|
|---|
| | | // let voiceBuffer = new Buffer(voice);
|
|---|
| | |
|
|---|
| | | // // è¯å«æ¬å°æ件ï¼é带åæ°
|
|---|
| | | // recordAnalysis.client.recognize(voiceBuffer, 'wav', 8000, {dev_pid: '1537', cuid:"15001307"}).then(function (result) {
|
|---|
| | | // console.log('<recognize>: ' + JSON.stringify(result));
|
|---|
| | | // // console.log(result);
|
|---|
| | | // }, function(err) {
|
|---|
| | | // console.log(err);
|
|---|
| | | // });
|
|---|
| | | })
|
|---|
| | |
|
|---|
| | | module.exports = router
|
|---|
old mode 100644
new mode 100755
old mode 100644
new mode 100755
| | |
|---|
| | | let secret = 'FM_Monitor'
|
|---|
| | | const users = require('../models/user')
|
|---|
| | | const mysql = require('../utils/mysql_db') //æµè¯ï¼ä½¿ç¨å®å é¤
|
|---|
| | | const logs = require('../utils/logs')
|
|---|
| | | const crypto = require('../utils/crypto')
|
|---|
| | | router.prefix('/user')
|
|---|
| | |
|
|---|
| | |
|---|
| | | const ms = new Date() - start //ååºæ¶é´
|
|---|
| | |
|
|---|
| | | data.logDes = `${user[0].user_name}ç»å½`
|
|---|
| | | logs.logLogin(ctx, ms, user[0].user_name)
|
|---|
| | | return (ctx.body = {
|
|---|
| | | code: 20000,
|
|---|
| | | token: token
|
|---|
| | |
|---|
| | | payload = await verify(token, secret)
|
|---|
| | | const ms = new Date() - start //ååºæ¶é´
|
|---|
| | | ctx.request.body.logDes = `${payload.user_name}éåºç»å½`
|
|---|
| | | logs.logLogin(ctx, ms, payload.user_name)
|
|---|
| | | ctx.body = {
|
|---|
| | | code: 20000,
|
|---|
| | | data: 'success'
|
|---|
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
| | |
|---|
| | | let create_sql = function(obj,pagesize_,pageindex_) {
|
|---|
| | | let str_select_ = [];
|
|---|
| | | let str_select_count = [];
|
|---|
| | | str_select_.push(obj.select_ + ' ' + obj.from_ + ' ' + obj.where_ + ' ' + obj.order_);
|
|---|
| | | str_select_count.push('select count(1) as counter '+obj.from_ +' ' + obj.where_ + ' ' + obj.order_);
|
|---|
| | | try {
|
|---|
| | | if (pagesize_ && Number(pagesize_)>=0) {
|
|---|
| | | let pageindex = (Number(pageindex_)>=0) ? Number(pageindex_) : 1;
|
|---|
| | | let pagesize = (Number(pagesize_)>=0) ? Number(pagesize_) : 10;
|
|---|
| | | str_select_.push(' limit ')
|
|---|
| | | str_select_.push((pageindex-1)*pagesize)
|
|---|
| | | str_select_.push(', ')
|
|---|
| | | str_select_.push(pagesize);
|
|---|
| | | }
|
|---|
| | | } catch (error) {
|
|---|
| | | |
|---|
| | | str_select_.push(obj.select_ + obj.from_ + obj.where_ + obj.order_);
|
|---|
| | | str_select_count.push('select count(1) as counter from ('+obj.select_+obj.from_ + obj.where_ + obj.order_+') count_');
|
|---|
| | | if (obj.server_paging == '1') {
|
|---|
| | | let pageindex = (Number(pageindex_)>=0) ? Number(pageindex_) : 1;
|
|---|
| | | let pagesize = (Number(pagesize_)>=0) ? Number(pagesize_) : 10;
|
|---|
| | | str_select_.push(' limit ')
|
|---|
| | | str_select_.push((pageindex-1)*pagesize)
|
|---|
| | | str_select_.push(', ')
|
|---|
| | | str_select_.push(pagesize);
|
|---|
| | | }
|
|---|
| | | return [str_select_count.join(''),str_select_.join('')]
|
|---|
| | | }
|
|---|
| | |
|---|
| | | let create_sync_sql = function(obj) {
|
|---|
| | | let str_select_ = [];
|
|---|
| | | let str_sync = [];
|
|---|
| | | str_select_.push(obj.select_ + ' ' + obj.from_ + ' ' + obj.where_ + ' ' + obj.order_);
|
|---|
| | | str_sync.push(obj.insert_ + ' ' + obj.column_ + ' ' + obj.values_ + ' ' + obj.updateDuplicate_);
|
|---|
| | | str_select_.push(obj.select_ + obj.from_ + obj.where_ + obj.order_);
|
|---|
| | | str_sync.push(obj.insert_ + obj.column_ + obj.values_ + obj.updateDuplicate_);
|
|---|
| | |
|
|---|
| | | return [str_select_.join(''),str_sync.join('')]
|
|---|
| | | }
|
|---|
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
old mode 100644
new mode 100755
