Built motion from commit 3b7b4c11.|2.0.47
[motion2.git] / server / api / analyticFieldReport / analyticFieldReport.controller.js
1 var _0x38a9=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x66\x61\x73\x74\x2D\x6A\x73\x6F\x6E\x2D\x70\x61\x74\x63\x68","\x72\x65\x71\x75\x65\x73\x74\x2D\x70\x72\x6F\x6D\x69\x73\x65","\x6D\x6F\x6D\x65\x6E\x74","\x62\x6C\x75\x65\x62\x69\x72\x64","\x6D\x75\x73\x74\x61\x63\x68\x65","\x75\x74\x69\x6C","\x70\x61\x74\x68","\x73\x6F\x78","\x74\x6F\x2D\x63\x73\x76","\x65\x6A\x73","\x66\x73","\x6C\x6F\x64\x61\x73\x68","\x73\x71\x75\x65\x6C","\x63\x72\x79\x70\x74\x6F","\x6A\x73\x66\x6F\x72\x63\x65","\x64\x65\x73\x6B\x2E\x6A\x73","\x71\x75\x65\x72\x79\x73\x74\x72\x69\x6E\x67","\x2E\x2E\x2F\x2E\x2E\x2F\x63\x6F\x6D\x70\x6F\x6E\x65\x6E\x74\x73\x2F\x70\x61\x72\x73\x65\x72\x73\x2F\x71\x73","\x61\x70\x69","\x2E\x2E\x2F\x2E\x2E\x2F\x63\x6F\x6E\x66\x69\x67\x2F\x6C\x6F\x67\x67\x65\x72","\x2E\x2E\x2F\x2E\x2E\x2F\x63\x6F\x6E\x66\x69\x67\x2F\x75\x74\x69\x6C\x73","\x2E\x2E\x2F\x2E\x2E\x2F\x63\x6F\x6E\x66\x69\x67\x2F\x65\x6E\x76\x69\x72\x6F\x6E\x6D\x65\x6E\x74","\x64\x62","\x2E\x2E\x2F\x2E\x2E\x2F\x6D\x79\x73\x71\x6C\x64\x62","\x41\x6E\x61\x6C\x79\x74\x69\x63\x46\x69\x65\x6C\x64\x52\x65\x70\x6F\x72\x74\x2C\x20\x25\x73\x2C\x20\x25\x73\x2C\x20\x25\x73","\x6E\x6F\x20\x63\x6F\x6E\x74\x65\x6E\x74","\x69\x6E\x66\x6F","\x41\x6E\x61\x6C\x79\x74\x69\x63\x46\x69\x65\x6C\x64\x52\x65\x70\x6F\x72\x74\x2C\x20\x25\x73\x2C\x20\x25\x73\x2C\x20\x25\x73\x2C\x20\x25\x73","\x64\x65\x62\x75\x67","\x73\x65\x6E\x64\x53\x74\x61\x74\x75\x73","\x65\x6E\x64","\x73\x74\x61\x74\x75\x73","\x65\x6E\x74\x69\x74\x79\x20\x66\x6F\x75\x6E\x64","\x73\x74\x72\x69\x6E\x67\x69\x66\x79","\x6A\x73\x6F\x6E","\x63\x6F\x75\x6E\x74","\x6F\x66\x66\x73\x65\x74","\x6C\x69\x6D\x69\x74","\x65\x6E\x74\x69\x74\x69\x65\x73\x20\x66\x6F\x75\x6E\x64","\x43\x6F\x6E\x74\x65\x6E\x74\x2D\x52\x61\x6E\x67\x65","\x2D","\x2F","\x73\x65\x74","\x61\x70\x70\x6C\x79","\x72\x65\x6A\x65\x63\x74","\x73\x61\x76\x65","\x65\x6E\x74\x69\x74\x79\x20\x75\x70\x64\x61\x74\x65\x64","\x74\x68\x65\x6E","\x75\x70\x64\x61\x74\x65","\x65\x6E\x74\x69\x74\x79\x20\x72\x65\x6D\x6F\x76\x65\x64","\x64\x65\x73\x74\x72\x6F\x79","\x65\x6E\x74\x69\x74\x79\x20\x6E\x6F\x74\x20\x66\x6F\x75\x6E\x64","\x65\x72\x72\x6F\x72","\x69\x6E\x73\x70\x65\x63\x74","\x6E\x61\x6D\x65","\x73\x65\x6E\x64","\x69\x6E\x64\x65\x78","\x6D\x6F\x64\x65\x6C","\x72\x61\x77\x41\x74\x74\x72\x69\x62\x75\x74\x65\x73","\x41\x6E\x61\x6C\x79\x74\x69\x63\x46\x69\x65\x6C\x64\x52\x65\x70\x6F\x72\x74","\x6B\x65\x79\x73","\x64\x61\x74\x65\x53\x74\x61\x72\x74","\x71\x75\x65\x72\x79","\x64\x61\x74\x65\x45\x6E\x64","\x66\x69\x6C\x74\x65\x72\x73","\x69\x6E\x74\x65\x72\x73\x65\x63\x74\x69\x6F\x6E","\x61\x74\x74\x72\x69\x62\x75\x74\x65\x73","\x66\x69\x65\x6C\x64\x73","\x6C\x65\x6E\x67\x74\x68","\x6E\x6F\x6C\x69\x6D\x69\x74","\x68\x61\x73\x4F\x77\x6E\x50\x72\x6F\x70\x65\x72\x74\x79","\x6F\x72\x64\x65\x72","\x73\x6F\x72\x74","\x77\x68\x65\x72\x65","\x70\x69\x63\x6B","\x64\x61\x79","\x61\x64\x64","\x6D\x65\x72\x67\x65","\x66\x69\x6C\x74\x65\x72","\x25","\x6D\x61\x70","\x6F\x70\x74\x69\x6F\x6E\x73","\x63\x61\x74\x63\x68","\x72\x6F\x77\x73","\x69\x6E\x63\x6C\x75\x64\x65\x41\x6C\x6C","\x69\x6E\x63\x6C\x75\x64\x65","\x66\x69\x6E\x64\x41\x6C\x6C","\x73\x68\x6F\x77","\x69\x64","\x70\x61\x72\x61\x6D\x73","\x66\x69\x6E\x64","\x63\x72\x65\x61\x74\x65","\x62\x6F\x64\x79","\x62\x75\x6C\x6B\x43\x72\x65\x61\x74\x65","\x62\x75\x6C\x6B\x44\x65\x73\x74\x72\x6F\x79","\x69\x64\x73","\x61\x64\x64\x46\x69\x65\x6C\x64\x73","\x43\x75\x73\x74\x6F\x6D\x52\x65\x70\x6F\x72\x74\x49\x64","\x74\x72\x61\x6E\x73\x61\x63\x74\x69\x6F\x6E","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x66\x69\x6E\x64\x4F\x6E\x65","\x41\x6E\x61\x6C\x79\x74\x69\x63\x43\x75\x73\x74\x6F\x6D\x52\x65\x70\x6F\x72\x74"];_0x38a9[0];var jsonpatch=require(_0x38a9[1]);var rp=require(_0x38a9[2]);var moment=require(_0x38a9[3]);var BPromise=require(_0x38a9[4]);var Mustache=require(_0x38a9[5]);var util=require(_0x38a9[6]);var path=require(_0x38a9[7]);var sox=require(_0x38a9[8]);var csv=require(_0x38a9[9]);var ejs=require(_0x38a9[10]);var fs=require(_0x38a9[11]);var _=require(_0x38a9[12]);var squel=require(_0x38a9[13]);var crypto=require(_0x38a9[14]);var jsforce=require(_0x38a9[15]);var deskjs=require(_0x38a9[16]);var toCsv=require(_0x38a9[9]);var querystring=require(_0x38a9[17]);var qs=require(_0x38a9[18]);var logger=require(_0x38a9[20])(_0x38a9[19]);var utils=require(_0x38a9[21]);var config=require(_0x38a9[22]);var db=require(_0x38a9[24])[_0x38a9[23]];function respondWithStatusCode(_0x988dx19,_0x988dx1a,_0x988dx1b){_0x988dx1a= _0x988dx1a|| 204;return function(_0x988dx1c){if(_0x988dx1c){logger[_0x38a9[27]](_0x38a9[25],_0x988dx1b,_0x988dx1a,_0x38a9[26]);logger[_0x38a9[29]](_0x38a9[28],_0x988dx1b,_0x988dx1a,_0x38a9[26]);return _0x988dx19[_0x38a9[30]](_0x988dx1a)};return _0x988dx19[_0x38a9[32]](_0x988dx1a)[_0x38a9[31]]()}}function respondWithResult(_0x988dx19,_0x988dx1a,_0x988dx1b){_0x988dx1a= _0x988dx1a|| 200;return function(_0x988dx1c){if(_0x988dx1c){logger[_0x38a9[27]](_0x38a9[25],_0x988dx1b,_0x988dx1a,_0x38a9[33]);logger[_0x38a9[29]](_0x38a9[28],_0x988dx1b,_0x988dx1a,_0x38a9[33],JSON[_0x38a9[34]](_0x988dx1c));return _0x988dx19[_0x38a9[32]](_0x988dx1a)[_0x38a9[35]](_0x988dx1c)}}}function respondWithFilteredResult(_0x988dx19,_0x988dx1f,_0x988dx1b){return function(_0x988dx1c){if(_0x988dx1c){var _0x988dx20=_0x988dx1c[_0x38a9[36]],_0x988dx21=_0x988dx1f[_0x38a9[37]],_0x988dx22=_0x988dx1f[_0x38a9[37]]+ _0x988dx1f[_0x38a9[38]],_0x988dx1a;if(_0x988dx22>= _0x988dx20){_0x988dx22= _0x988dx20;_0x988dx1a= 200}else {_0x988dx1a= 206};_0x988dx19[_0x38a9[32]](_0x988dx1a);logger[_0x38a9[27]](_0x38a9[25],_0x988dx1b,_0x988dx1a,_0x38a9[39]);logger[_0x38a9[29]](_0x38a9[28],_0x988dx1b,_0x988dx1a,_0x38a9[33],JSON[_0x38a9[34]](_0x988dx1c));return _0x988dx19[_0x38a9[43]](_0x38a9[40],_0x988dx21+ _0x38a9[41]+ _0x988dx22+ _0x38a9[42]+ _0x988dx20)[_0x38a9[35]](_0x988dx1c)};return null}}function patchUpdates(_0x988dx24){return function(_0x988dx1c){try{jsonpatch[_0x38a9[44]](_0x988dx1c,_0x988dx24,true)}catch(err){return BPromise[_0x38a9[45]](err)};return _0x988dx1c[_0x38a9[46]]()}}function saveUpdates(_0x988dx26,_0x988dx1a,_0x988dx1b){return function(_0x988dx1c){if(_0x988dx1c){return _0x988dx1c[_0x38a9[49]](_0x988dx26)[_0x38a9[48]](function(_0x988dx27){logger[_0x38a9[27]](_0x38a9[25],_0x988dx1b,_0x988dx1a,_0x38a9[47]);logger[_0x38a9[29]](_0x38a9[28],_0x988dx1b,_0x988dx1a,_0x38a9[47],JSON[_0x38a9[34]](_0x988dx1c));return _0x988dx27})};return null}}function removeEntity(_0x988dx19,_0x988dx1a,_0x988dx1b){return function(_0x988dx1c){if(_0x988dx1c){return _0x988dx1c[_0x38a9[51]]()[_0x38a9[48]](function(){logger[_0x38a9[27]](_0x38a9[25],_0x988dx1b,_0x988dx1a,_0x38a9[50]);logger[_0x38a9[29]](_0x38a9[28],_0x988dx1b,_0x988dx1a,_0x38a9[50],JSON[_0x38a9[34]](_0x988dx1c));_0x988dx19[_0x38a9[32]](204)[_0x38a9[31]]()})}}}function handleEntityNotFound(_0x988dx19,_0x988dx1a,_0x988dx1b){return function(_0x988dx1c){if(!_0x988dx1c){logger[_0x38a9[53]](_0x38a9[25],_0x988dx1b,404,_0x38a9[52]);_0x988dx19[_0x38a9[30]](404)};return _0x988dx1c}}function handleError(_0x988dx19,_0x988dx1a,_0x988dx1b){_0x988dx1a= _0x988dx1a|| 500;return function(_0x988dx2b){logger[_0x38a9[53]](_0x38a9[25],_0x988dx1b,_0x988dx1a,util[_0x38a9[54]](_0x988dx2b,{showHidden:false,depth:null}));delete _0x988dx2b[_0x38a9[55]];_0x988dx19[_0x38a9[32]](_0x988dx1a)[_0x38a9[56]](_0x988dx2b)}}exports[_0x38a9[57]]= function(_0x988dx2c,_0x988dx19){var _0x988dx1f={},_0x988dx2d={},_0x988dx2e={count:0,rows:[]};_0x988dx2d[_0x38a9[58]]= _[_0x38a9[61]](db[_0x38a9[60]][_0x38a9[59]]);var _0x988dx2f={dateStart:_0x988dx2c[_0x38a9[63]][_0x38a9[62]],dateEnd:_0x988dx2c[_0x38a9[63]][_0x38a9[64]]};delete _0x988dx2c[_0x38a9[63]][_0x38a9[62]];delete _0x988dx2c[_0x38a9[63]][_0x38a9[64]];_0x988dx2d[_0x38a9[63]]= _[_0x38a9[61]](_0x988dx2c[_0x38a9[63]]);_0x988dx2d[_0x38a9[65]]= _[_0x38a9[66]](_0x988dx2d[_0x38a9[58]],_0x988dx2d[_0x38a9[63]]);_0x988dx1f[_0x38a9[67]]= _[_0x38a9[66]](_0x988dx2d[_0x38a9[58]],qs[_0x38a9[68]](_0x988dx2c[_0x38a9[63]][_0x38a9[68]]));_0x988dx1f[_0x38a9[67]]= (_0x988dx1f[_0x38a9[67]][_0x38a9[69]])?_0x988dx1f[_0x38a9[67]]:_0x988dx2d[_0x38a9[58]];if(!_0x988dx2c[_0x38a9[63]][_0x38a9[71]](_0x38a9[70])){_0x988dx1f[_0x38a9[38]]= qs[_0x38a9[38]](_0x988dx2c[_0x38a9[63]][_0x38a9[38]]);_0x988dx1f[_0x38a9[37]]= qs[_0x38a9[37]](_0x988dx2c[_0x38a9[63]][_0x38a9[37]])};_0x988dx1f[_0x38a9[72]]= qs[_0x38a9[73]](_0x988dx2c[_0x38a9[63]][_0x38a9[73]]);_0x988dx1f[_0x38a9[74]]= qs[_0x38a9[65]](_[_0x38a9[75]](_0x988dx2c[_0x38a9[63]],_0x988dx2d[_0x38a9[65]]));if(_0x988dx2f[_0x38a9[62]]){if(_0x988dx2f[_0x38a9[64]]){_0x988dx2f[_0x38a9[64]]= moment(_0x988dx2f[_0x38a9[64]])[_0x38a9[77]](1,_0x38a9[76])}else {_0x988dx2f[_0x38a9[64]]= moment(_0x988dx2f[_0x38a9[62]])[_0x38a9[77]](1,_0x38a9[76])};_[_0x38a9[78]](_0x988dx1f[_0x38a9[74]],{createdAt:{$gte:_0x988dx2f[_0x38a9[62]],$lte:_0x988dx2f[_0x38a9[64]]}})};if(_0x988dx2c[_0x38a9[63]][_0x38a9[79]]){_0x988dx1f[_0x38a9[74]]= _[_0x38a9[78]](_0x988dx1f[_0x38a9[74]],{$or:_[_0x38a9[81]](_0x988dx1f[_0x38a9[67]],function(_0x988dx30){var _0x988dx2e={};_0x988dx2e[_0x988dx30]= {$like:_0x38a9[80]+ _0x988dx2c[_0x38a9[63]][_0x38a9[79]]+ _0x38a9[80]};return _0x988dx2e})})};_0x988dx1f= _[_0x38a9[78]]({},_0x988dx1f,_0x988dx2c[_0x38a9[82]]);return db[_0x38a9[60]][_0x38a9[36]]({where:_0x988dx1f[_0x38a9[74]]})[_0x38a9[48]](function(_0x988dx20){_0x988dx2e[_0x38a9[36]]= _0x988dx20;if(_0x988dx2c[_0x38a9[63]][_0x38a9[85]]){_0x988dx1f[_0x38a9[86]]= [{all:true}]};return db[_0x38a9[60]][_0x38a9[87]](_0x988dx1f)})[_0x38a9[48]](function(_0x988dx31){_0x988dx2e[_0x38a9[84]]= _0x988dx31;return _0x988dx2e})[_0x38a9[48]](respondWithFilteredResult(_0x988dx19,_0x988dx1f,_0x38a9[57]))[_0x38a9[83]](handleError(_0x988dx19,null,_0x38a9[57]))};exports[_0x38a9[88]]= function(_0x988dx2c,_0x988dx19){var _0x988dx1f={raw:false,where:{id:_0x988dx2c[_0x38a9[90]][_0x38a9[89]]}},_0x988dx2d={};_0x988dx2d[_0x38a9[58]]= _[_0x38a9[61]](db[_0x38a9[60]][_0x38a9[59]]);_0x988dx2d[_0x38a9[63]]= _[_0x38a9[61]](_0x988dx2c[_0x38a9[63]]);_0x988dx2d[_0x38a9[65]]= _[_0x38a9[66]](_0x988dx2d[_0x38a9[58]],_0x988dx2d[_0x38a9[63]]);_0x988dx1f[_0x38a9[67]]= _[_0x38a9[66]](_0x988dx2d[_0x38a9[58]],qs[_0x38a9[68]](_0x988dx2c[_0x38a9[63]][_0x38a9[68]]));_0x988dx1f[_0x38a9[67]]= (_0x988dx1f[_0x38a9[67]][_0x38a9[69]])?_0x988dx1f[_0x38a9[67]]:_0x988dx2d[_0x38a9[58]];if(_0x988dx2c[_0x38a9[63]][_0x38a9[85]]){_0x988dx1f[_0x38a9[86]]= [{all:true}]};_0x988dx1f= _[_0x38a9[78]]({},_0x988dx1f,_0x988dx2c[_0x38a9[82]]);return db[_0x38a9[60]][_0x38a9[91]](_0x988dx1f)[_0x38a9[48]](handleEntityNotFound(_0x988dx19,null,_0x38a9[88]))[_0x38a9[48]](respondWithResult(_0x988dx19,null,_0x38a9[88]))[_0x38a9[83]](handleError(_0x988dx19,null,_0x38a9[88]))};exports[_0x38a9[92]]= function(_0x988dx2c,_0x988dx19){return db[_0x38a9[60]][_0x38a9[92]](_0x988dx2c[_0x38a9[93]],{})[_0x38a9[48]](respondWithResult(_0x988dx19,201,_0x38a9[92]))[_0x38a9[83]](handleError(_0x988dx19,null,_0x38a9[92]))};exports[_0x38a9[94]]= function(_0x988dx2c,_0x988dx19){return db[_0x38a9[60]][_0x38a9[94]](_0x988dx2c[_0x38a9[93]],{raw:false,individualHooks:true})[_0x38a9[48]](respondWithResult(_0x988dx19,201,_0x38a9[94]))[_0x38a9[83]](handleError(_0x988dx19,null,_0x38a9[94]))};exports[_0x38a9[49]]= function(_0x988dx2c,_0x988dx19){if(_0x988dx2c[_0x38a9[93]][_0x38a9[89]]){delete _0x988dx2c[_0x38a9[93]][_0x38a9[89]]};return db[_0x38a9[60]][_0x38a9[91]]({where:{id:_0x988dx2c[_0x38a9[90]][_0x38a9[89]]}})[_0x38a9[48]](handleEntityNotFound(_0x988dx19,null,_0x38a9[49]))[_0x38a9[48]](saveUpdates(_0x988dx2c[_0x38a9[93]],null,_0x38a9[49]))[_0x38a9[48]](respondWithResult(_0x988dx19,null,_0x38a9[49]))[_0x38a9[83]](handleError(_0x988dx19,null,_0x38a9[49]))};exports[_0x38a9[51]]= function(_0x988dx2c,_0x988dx19){return db[_0x38a9[60]][_0x38a9[91]]({where:{id:_0x988dx2c[_0x38a9[90]][_0x38a9[89]]}})[_0x38a9[48]](handleEntityNotFound(_0x988dx19,null,_0x38a9[51]))[_0x38a9[48]](removeEntity(_0x988dx19,null,_0x38a9[51]))[_0x38a9[83]](handleError(_0x988dx19,null,_0x38a9[51]))};exports[_0x38a9[95]]= function(_0x988dx2c,_0x988dx19){return db[_0x38a9[60]][_0x38a9[51]]({where:{id:_0x988dx2c[_0x38a9[63]][_0x38a9[96]]|| []},raw:false,individualHooks:true})[_0x38a9[48]](respondWithResult(_0x988dx19,204,_0x38a9[95]))[_0x38a9[83]](handleError(_0x988dx19,null,_0x38a9[95]))};exports[_0x38a9[97]]= function(_0x988dx2c,_0x988dx19,_0x988dx32){return db[_0x38a9[102]][_0x38a9[101]]({where:{id:_0x988dx2c[_0x38a9[90]][_0x38a9[89]]}})[_0x38a9[48]](handleEntityNotFound(_0x988dx19,null,_0x38a9[97]))[_0x38a9[48]](function(_0x988dx1c){if(_0x988dx1c){return db[_0x38a9[100]][_0x38a9[99]](function(_0x988dx33){return db[_0x38a9[60]][_0x38a9[51]]({where:{CustomReportId:_0x988dx2c[_0x38a9[90]][_0x38a9[89]]},transaction:_0x988dx33})[_0x38a9[48]](function(_0x988dx34){var _0x988dx35=_[_0x38a9[81]](_0x988dx2c[_0x38a9[93]],function(_0x988dx36){delete _0x988dx36[_0x38a9[89]];_0x988dx36[_0x38a9[98]]= _0x988dx2c[_0x38a9[90]][_0x38a9[89]];return _0x988dx36});return db[_0x38a9[60]][_0x38a9[94]](_0x988dx35,{transaction:_0x988dx33})})})[_0x38a9[48]](function(){return db[_0x38a9[60]][_0x38a9[87]]({where:{CustomReportId:_0x988dx2c[_0x38a9[90]][_0x38a9[89]]}})})}})[_0x38a9[48]](respondWithResult(_0x988dx19,null,_0x38a9[97]))[_0x38a9[83]](handleError(_0x988dx19,null,_0x38a9[97]))}