request(query, function (error, response, body) {
if (!error && response.statusCode === 200) {
var wthr=JSON.parse(response.body);
console.log("weathr"+JSON.stringify(wthr));
if(rows.length!==0) {
var input = new Array();
input['x'] = new Array(); input['y'] = new Array();
var estimationInput = new Array();
estimationInput['x'] = new Array();
estimationInput['y'] = new Array();
for(var i in rows) {
input['x'][i] =rows[i].temp_out;
if(req.session.details==='admin'){
rows[i].usg=rows[i].usg*12;
}
input['y'][i] =rows[i].usg;
for(j=0;j<7;j++){
estimationInput['x'][j] = Math.round((9/5)*(wthr.list[j].temp.max - 273) + 32+10);
}
}
var estimateData = Lyric.applyModel(estimationInput, Lyric.buildModel(input));
console.log("data : "+estimateData);
for(i in estimateData){
a[i]=estimateData[i].y;
}
res.send(a);
}
else
{
console.log("error data : "+JSON.stringify(rows));
}
}
});
connection.query(query,function(err,rows,fields){
if (err)
{
console.log("ERROR: " + err.message);
}
else
{
if(rows.length!==0)
{
var input = new Array();
input['x'] = new Array(); input['y'] = new Array();
var estimationInput = new Array();
estimationInput['x'] = new Array();
estimationInput['y'] = new Array();
for(var i in rows) {
input['x'][i]=rows[i].tusage;
input['y'][i]=rows[i].price;
}
k=0;
for(var i in rows) {
estimationInput['x'][i]=rows[i].tusage+0.29;
k++;
if(k>5){
k=0;
}
}
var estimateData = Lyric.applyModel(estimationInput, Lyric.buildModel(input));
console.log("rows : "+JSON.stringify(rows));
console.log("data : "+JSON.stringify(estimateData));
res.send(estimateData);
}
else
{
console.log("error data : "+JSON.stringify(rows));
}
}
});
connection.query(query,function(err,rows,fields){
if (err)
{
console.log("ERROR: " + err.message);
}
else
{
if(rows.length!==0)
{var input = new Array();
input['x'] = new Array(); input['y'] = new Array();
var estimationInput = new Array();
estimationInput['x'] = new Array();
estimationInput['y'] = new Array();
for(var i in rows) {
a[i]= rows[i].tusage;
input['x'][i] =i;
if(req.session.details==='admin'){
rows[i].tusage=rows[i].tusage*12;
}
input['y'][i] =rows[i].tusage;
estimationInput['x'][i] = i;
}
var estimateData = Lyric.applyModel(estimationInput, Lyric.buildModel(input));
console.log("data : "+estimateData);
for(i in estimateData){
a[i]=estimateData[i].y;
}
res.send(a);
}
else
{
console.log("error data : "+JSON.stringify(rows));
}
}
});
connection.query(query,function(err,rows,fields){
if (err)
{
console.log("ERROR: " + err.message);
}
else
{
if(rows.length!==0)
{
var input = new Array();
input['x'] = new Array(); input['y'] = new Array();
var estimationInput = new Array();
estimationInput['x'] = new Array();
estimationInput['y'] = new Array();
for(var i in rows) {
d= rows[i].date;
rows[i].date= d.getTime();
var dt=d.getUTCFullYear();
var s='-';
var dm=JSON.stringify(d.getUTCMonth());
if(dm.length===1){
dm ='0'+d.getUTCMonth();
}
if(dm==='00'){
dm='12';
}
input['x'][i]=dt+s+dm+s+d.getUTCDate();
//input['x'][i]=rows[i].usg;
if(dm!=='12'){
dt=dt+1;
}
estimationInput['x'][i]=dt+s+dm+s+d.getUTCDate();
//estimationInput['x'][i]=rows[i].usg+1;
if(req.session.details==='admin'){
rows[i].price=rows[i].price*12;
}
input['y'][i]=rows[i].price;
// data= JSON.parse(a[i]);
}
console.log('input '+input['x']);
console.log('input '+input['y']);
console.log('estimationInput '+estimationInput['x']);
var ordinalInput = Lyric.ordinalize(input);
console.log('ordinalInput x '+ordinalInput['x']);
var estInput = Lyric.ordinalize(estimationInput);
console.log('estInput '+estInput['x']);
var estimateData = Lyric.applyModel( estInput, Lyric.buildModel(ordinalInput));
//var estimateData = Lyric.applyModel(estimationInput, Lyric.buildModel(input));
console.log("DATA : "+JSON.stringify(estimateData));
console.log("DATA : "+JSON.stringify(estimateData[0].x));
for(i in estimateData){
d= new Date(estimateData[i].x);
fd= d.getTime();
a[i]=[fd,estimateData[i].y,rows[i].price]
}
console.log("A :"+a);
res.send(a);
}
else
{
console.log("error data : "+JSON.stringify(rows));
}
}
});