Built motion from commit 67e5df37.|2.0.63
[motion2.git] / server / api / jscriptyProject / jscriptyProject.controller.js
1 var _0x34e4=["\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","\x70\x61\x70\x61\x70\x61\x72\x73\x65","\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","\x73\x65\x6E\x64\x53\x74\x61\x74\x75\x73","\x65\x6E\x64","\x73\x74\x61\x74\x75\x73","\x6A\x73\x6F\x6E","\x63\x6F\x75\x6E\x74","\x6F\x66\x66\x73\x65\x74","\x6C\x69\x6D\x69\x74","\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","\x74\x68\x65\x6E","\x75\x70\x64\x61\x74\x65","\x64\x65\x73\x74\x72\x6F\x79","\x73\x74\x61\x63\x6B","\x65\x72\x72\x6F\x72","\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","\x4A\x73\x63\x72\x69\x70\x74\x79\x50\x72\x6F\x6A\x65\x63\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","\x63\x6C\x6F\x6E\x65","\x67\x65\x74","\x63\x72\x65\x61\x74\x65\x64\x41\x74","\x75\x70\x64\x61\x74\x65\x64\x41\x74","\x6F\x6D\x69\x74","\x67\x65\x74\x53\x65\x73\x73\x69\x6F\x6E\x73","\x4A\x73\x63\x72\x69\x70\x74\x79\x53\x65\x73\x73\x69\x6F\x6E\x52\x65\x70\x6F\x72\x74","\x50\x72\x6F\x6A\x65\x63\x74\x49\x64","\x66\x69\x6E\x64\x4F\x6E\x65","\x67\x65\x74\x41\x6E\x73\x77\x65\x72\x73","\x4A\x73\x63\x72\x69\x70\x74\x79\x41\x6E\x73\x77\x65\x72\x52\x65\x70\x6F\x72\x74","\x6E\x75\x6D\x62\x65\x72","\x66\x72\x6F\x6D\x43\x68\x61\x72\x43\x6F\x64\x65","\x69\x6E\x64\x65\x78\x4F\x66","\x5C","\x67","\x72\x65\x70\x6C\x61\x63\x65","\x67\x65\x74\x53\x75\x6D\x6D\x61\x72\x79","\x71\x75\x65\x73\x74\x69\x6F\x6E\x49\x64","\x71\x75\x65\x73\x74\x69\x6F\x6E","\x59\x59\x59\x59\x2D\x4D\x4D\x2D\x44\x44\x20\x48\x48\x3A\x6D\x6D\x3A\x73\x73","\x66\x6F\x72\x6D\x61\x74","\x73\x74\x61\x72\x74\x74\x69\x6D\x65","\x53\x65\x73\x73\x69\x6F\x6E\x49\x64","\x61\x6E\x73\x77\x65\x72","\x70\x75\x73\x68","\x6E\x6F\x77","\x2F\x74\x6D\x70\x2F\x4A\x73\x63\x72\x69\x70\x74\x79\x5F\x50\x72\x6F\x6A\x65\x63\x74\x5F\x25\x64\x5F\x53\x75\x6D\x6D\x61\x72\x79\x5F\x25\x73\x2E\x63\x73\x76","\x77\x72\x69\x74\x65\x46\x69\x6C\x65\x53\x79\x6E\x63","\x43\x6F\x6E\x74\x65\x6E\x74\x2D\x64\x69\x73\x70\x6F\x73\x69\x74\x69\x6F\x6E","\x61\x74\x74\x61\x63\x68\x6D\x65\x6E\x74\x3B\x20\x66\x69\x6C\x65\x6E\x61\x6D\x65\x3D","\x4A\x73\x63\x72\x69\x70\x74\x79\x5F\x50\x72\x6F\x6A\x65\x63\x74\x5F\x25\x64\x5F\x53\x75\x6D\x6D\x61\x72\x79\x5F\x25\x73\x2E\x63\x73\x76","\x73\x65\x74\x48\x65\x61\x64\x65\x72","\x43\x6F\x6E\x74\x65\x6E\x74\x2D\x74\x79\x70\x65","\x74\x65\x78\x74\x2F\x63\x73\x76","\x64\x6F\x77\x6E\x6C\x6F\x61\x64","\x2D\x63\x72\x65\x61\x74\x65\x64\x41\x74","\x4A\x73\x63\x72\x69\x70\x74\x79\x51\x75\x65\x73\x74\x69\x6F\x6E\x52\x65\x70\x6F\x72\x74"];_0x34e4[0];var jsonpatch=require(_0x34e4[1]);var rp=require(_0x34e4[2]);var moment=require(_0x34e4[3]);var BPromise=require(_0x34e4[4]);var Mustache=require(_0x34e4[5]);var util=require(_0x34e4[6]);var path=require(_0x34e4[7]);var sox=require(_0x34e4[8]);var csv=require(_0x34e4[9]);var ejs=require(_0x34e4[10]);var fs=require(_0x34e4[11]);var _=require(_0x34e4[12]);var squel=require(_0x34e4[13]);var crypto=require(_0x34e4[14]);var jsforce=require(_0x34e4[15]);var deskjs=require(_0x34e4[16]);var toCsv=require(_0x34e4[9]);var querystring=require(_0x34e4[17]);var Papa=require(_0x34e4[18]);var qs=require(_0x34e4[19]);var logger=require(_0x34e4[21])(_0x34e4[20]);var utils=require(_0x34e4[22]);var config=require(_0x34e4[23]);var db=require(_0x34e4[25])[_0x34e4[24]];function respondWithStatusCode(_0x382fx1a,_0x382fx1b){_0x382fx1b= _0x382fx1b|| 204;return function(_0x382fx1c){if(_0x382fx1c){return _0x382fx1a[_0x34e4[26]](_0x382fx1b)};return _0x382fx1a[_0x34e4[28]](_0x382fx1b)[_0x34e4[27]]()}}function respondWithResult(_0x382fx1a,_0x382fx1b){_0x382fx1b= _0x382fx1b|| 200;return function(_0x382fx1c){if(_0x382fx1c){return _0x382fx1a[_0x34e4[28]](_0x382fx1b)[_0x34e4[29]](_0x382fx1c)}}}function respondWithFilteredResult(_0x382fx1a,_0x382fx1f){return function(_0x382fx1c){if(_0x382fx1c){var _0x382fx20=_0x382fx1c[_0x34e4[30]],_0x382fx21=_0x382fx1f[_0x34e4[31]],_0x382fx22=_0x382fx1f[_0x34e4[31]]+ _0x382fx1f[_0x34e4[32]],_0x382fx1b;if(_0x382fx22>= _0x382fx20){_0x382fx22= _0x382fx20;_0x382fx1b= 200}else {_0x382fx1b= 206};_0x382fx1a[_0x34e4[28]](_0x382fx1b);return _0x382fx1a[_0x34e4[36]](_0x34e4[33],_0x382fx21+ _0x34e4[34]+ _0x382fx22+ _0x34e4[35]+ _0x382fx20)[_0x34e4[29]](_0x382fx1c)};return null}}function patchUpdates(_0x382fx24){return function(_0x382fx1c){try{jsonpatch[_0x34e4[37]](_0x382fx1c,_0x382fx24,true)}catch(err){return BPromise[_0x34e4[38]](err)};return _0x382fx1c[_0x34e4[39]]()}}function saveUpdates(_0x382fx26,_0x382fx1b){return function(_0x382fx1c){if(_0x382fx1c){return _0x382fx1c[_0x34e4[41]](_0x382fx26)[_0x34e4[40]](function(_0x382fx27){return _0x382fx27})};return null}}function removeEntity(_0x382fx1a,_0x382fx1b){return function(_0x382fx1c){if(_0x382fx1c){return _0x382fx1c[_0x34e4[42]]()[_0x34e4[40]](function(){_0x382fx1a[_0x34e4[28]](204)[_0x34e4[27]]()})}}}function handleEntityNotFound(_0x382fx1a,_0x382fx1b){return function(_0x382fx1c){if(!_0x382fx1c){_0x382fx1a[_0x34e4[26]](404)};return _0x382fx1c}}function handleError(_0x382fx1a,_0x382fx1b){_0x382fx1b= _0x382fx1b|| 500;return function(_0x382fx2b){logger[_0x34e4[44]](_0x382fx2b[_0x34e4[43]]);if(_0x382fx2b[_0x34e4[45]]){delete _0x382fx2b[_0x34e4[45]]};_0x382fx1a[_0x34e4[28]](_0x382fx1b)[_0x34e4[46]](_0x382fx2b)}}exports[_0x34e4[47]]= function(_0x382fx2c,_0x382fx1a){var _0x382fx1f={},_0x382fx2d={},_0x382fx2e={count:0,rows:[]};_0x382fx2d[_0x34e4[48]]= _[_0x34e4[51]](db[_0x34e4[50]][_0x34e4[49]]);var _0x382fx2f={dateStart:_0x382fx2c[_0x34e4[53]][_0x34e4[52]],dateEnd:_0x382fx2c[_0x34e4[53]][_0x34e4[54]]};delete _0x382fx2c[_0x34e4[53]][_0x34e4[52]];delete _0x382fx2c[_0x34e4[53]][_0x34e4[54]];_0x382fx2d[_0x34e4[53]]= _[_0x34e4[51]](_0x382fx2c[_0x34e4[53]]);_0x382fx2d[_0x34e4[55]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],_0x382fx2d[_0x34e4[53]]);_0x382fx1f[_0x34e4[57]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],qs[_0x34e4[58]](_0x382fx2c[_0x34e4[53]][_0x34e4[58]]));_0x382fx1f[_0x34e4[57]]= (_0x382fx1f[_0x34e4[57]][_0x34e4[59]])?_0x382fx1f[_0x34e4[57]]:_0x382fx2d[_0x34e4[48]];if(!_0x382fx2c[_0x34e4[53]][_0x34e4[61]](_0x34e4[60])){_0x382fx1f[_0x34e4[32]]= qs[_0x34e4[32]](_0x382fx2c[_0x34e4[53]][_0x34e4[32]]);_0x382fx1f[_0x34e4[31]]= qs[_0x34e4[31]](_0x382fx2c[_0x34e4[53]][_0x34e4[31]])};_0x382fx1f[_0x34e4[62]]= qs[_0x34e4[63]](_0x382fx2c[_0x34e4[53]][_0x34e4[63]]);_0x382fx1f[_0x34e4[64]]= qs[_0x34e4[55]](_[_0x34e4[65]](_0x382fx2c[_0x34e4[53]],_0x382fx2d[_0x34e4[55]]));if(_0x382fx2f[_0x34e4[52]]){if(_0x382fx2f[_0x34e4[54]]){_0x382fx2f[_0x34e4[54]]= moment(_0x382fx2f[_0x34e4[54]])[_0x34e4[67]](1,_0x34e4[66])}else {_0x382fx2f[_0x34e4[54]]= moment(_0x382fx2f[_0x34e4[52]])[_0x34e4[67]](1,_0x34e4[66])};_[_0x34e4[68]](_0x382fx1f[_0x34e4[64]],{createdAt:{$gte:_0x382fx2f[_0x34e4[52]],$lte:_0x382fx2f[_0x34e4[54]]}})};if(_0x382fx2c[_0x34e4[53]][_0x34e4[69]]){_0x382fx1f[_0x34e4[64]]= _[_0x34e4[68]](_0x382fx1f[_0x34e4[64]],{$or:_[_0x34e4[71]](_0x382fx1f[_0x34e4[57]],function(_0x382fx30){var _0x382fx2e={};_0x382fx2e[_0x382fx30]= {$like:_0x34e4[70]+ _0x382fx2c[_0x34e4[53]][_0x34e4[69]]+ _0x34e4[70]};return _0x382fx2e})})};_0x382fx1f= _[_0x34e4[68]]({},_0x382fx1f,_0x382fx2c[_0x34e4[72]]);var _0x382fx31={where:_0x382fx1f[_0x34e4[64]]};return db[_0x34e4[50]][_0x34e4[30]](_0x382fx31)[_0x34e4[40]](function(_0x382fx20){_0x382fx2e[_0x34e4[30]]= _0x382fx20;if(_0x382fx2c[_0x34e4[53]][_0x34e4[75]]){_0x382fx1f[_0x34e4[76]]= [{all:true}]};return db[_0x34e4[50]][_0x34e4[77]](_0x382fx1f)})[_0x34e4[40]](function(_0x382fx32){_0x382fx2e[_0x34e4[74]]= _0x382fx32;return _0x382fx2e})[_0x34e4[40]](respondWithFilteredResult(_0x382fx1a,_0x382fx1f))[_0x34e4[73]](handleError(_0x382fx1a,null))};exports[_0x34e4[78]]= function(_0x382fx2c,_0x382fx1a){var _0x382fx1f={raw:false,where:{id:_0x382fx2c[_0x34e4[80]][_0x34e4[79]]}},_0x382fx2d={};_0x382fx2d[_0x34e4[48]]= _[_0x34e4[51]](db[_0x34e4[50]][_0x34e4[49]]);_0x382fx2d[_0x34e4[53]]= _[_0x34e4[51]](_0x382fx2c[_0x34e4[53]]);_0x382fx2d[_0x34e4[55]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],_0x382fx2d[_0x34e4[53]]);_0x382fx1f[_0x34e4[57]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],qs[_0x34e4[58]](_0x382fx2c[_0x34e4[53]][_0x34e4[58]]));_0x382fx1f[_0x34e4[57]]= (_0x382fx1f[_0x34e4[57]][_0x34e4[59]])?_0x382fx1f[_0x34e4[57]]:_0x382fx2d[_0x34e4[48]];if(_0x382fx2c[_0x34e4[53]][_0x34e4[75]]){_0x382fx1f[_0x34e4[76]]= [{all:true}]};_0x382fx1f= _[_0x34e4[68]]({},_0x382fx1f,_0x382fx2c[_0x34e4[72]]);return db[_0x34e4[50]][_0x34e4[81]](_0x382fx1f)[_0x34e4[40]](handleEntityNotFound(_0x382fx1a,null))[_0x34e4[40]](respondWithResult(_0x382fx1a,null))[_0x34e4[73]](handleError(_0x382fx1a,null))};exports[_0x34e4[82]]= function(_0x382fx2c,_0x382fx1a){return db[_0x34e4[50]][_0x34e4[82]](_0x382fx2c[_0x34e4[83]],{})[_0x34e4[40]](respondWithResult(_0x382fx1a,201))[_0x34e4[73]](handleError(_0x382fx1a,null))};exports[_0x34e4[84]]= function(_0x382fx2c,_0x382fx1a){var _0x382fx1f={raw:false,where:{id:_0x382fx2c[_0x34e4[80]][_0x34e4[79]]}},_0x382fx2d={};_0x382fx2d[_0x34e4[48]]= _[_0x34e4[51]](db[_0x34e4[50]][_0x34e4[49]]);_0x382fx1f[_0x34e4[57]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],qs[_0x34e4[58]](_0x382fx2c[_0x34e4[53]][_0x34e4[58]]));_0x382fx1f[_0x34e4[57]]= (_0x382fx1f[_0x34e4[57]][_0x34e4[59]])?_0x382fx1f[_0x34e4[57]]:_0x382fx2d[_0x34e4[48]];if(_0x382fx2c[_0x34e4[53]][_0x34e4[75]]){_0x382fx1f[_0x34e4[76]]= [{all:true}]};_0x382fx1f= _[_0x34e4[68]]({},_0x382fx1f,_0x382fx2c[_0x34e4[72]]);return db[_0x34e4[50]][_0x34e4[81]](_0x382fx1f)[_0x34e4[40]](handleEntityNotFound(_0x382fx1a,null))[_0x34e4[40]](function(_0x382fx1c){if(_0x382fx1c){var _0x382fx33=_0x382fx1c[_0x34e4[85]]({plain:true});_0x382fx33= qs[_0x34e4[88]](_0x382fx33,[_0x34e4[79],_0x34e4[86],_0x34e4[87]]);_0x382fx2c[_0x34e4[83]]= _[_0x34e4[88]](_0x382fx2c[_0x34e4[83]],[_0x34e4[79],_0x34e4[86],_0x34e4[87]]);return db[_0x34e4[50]][_0x34e4[82]](_[_0x34e4[68]](_0x382fx33,_0x382fx2c[_0x34e4[83]]),{include:_0x382fx2c[_0x34e4[53]][_0x34e4[75]]?[{all:true}]:undefined})}})[_0x34e4[40]](respondWithResult(_0x382fx1a,201))[_0x34e4[73]](handleError(_0x382fx1a,null))};exports[_0x34e4[41]]= function(_0x382fx2c,_0x382fx1a){if(_0x382fx2c[_0x34e4[83]][_0x34e4[79]]){delete _0x382fx2c[_0x34e4[83]][_0x34e4[79]]};return db[_0x34e4[50]][_0x34e4[81]]({where:{id:_0x382fx2c[_0x34e4[80]][_0x34e4[79]]}})[_0x34e4[40]](handleEntityNotFound(_0x382fx1a,null))[_0x34e4[40]](saveUpdates(_0x382fx2c[_0x34e4[83]],null))[_0x34e4[40]](respondWithResult(_0x382fx1a,null))[_0x34e4[73]](handleError(_0x382fx1a,null))};exports[_0x34e4[42]]= function(_0x382fx2c,_0x382fx1a){return db[_0x34e4[50]][_0x34e4[81]]({where:{id:_0x382fx2c[_0x34e4[80]][_0x34e4[79]]}})[_0x34e4[40]](handleEntityNotFound(_0x382fx1a,null))[_0x34e4[40]](removeEntity(_0x382fx1a,null))[_0x34e4[73]](handleError(_0x382fx1a,null))};exports[_0x34e4[89]]= function(_0x382fx2c,_0x382fx1a,_0x382fx34){var _0x382fx1f={raw:true,where:{}};var _0x382fx2d={};var _0x382fx35={count:0,rows:[]};return db[_0x34e4[50]][_0x34e4[92]]({where:{id:_0x382fx2c[_0x34e4[80]][_0x34e4[79]]}})[_0x34e4[40]](handleEntityNotFound(_0x382fx1a,null))[_0x34e4[40]](function(_0x382fx1c){if(_0x382fx1c){_0x382fx2d[_0x34e4[48]]= _[_0x34e4[51]](db[_0x34e4[90]][_0x34e4[49]]);_0x382fx2d[_0x34e4[53]]= _[_0x34e4[51]](_0x382fx2c[_0x34e4[53]]);_0x382fx2d[_0x34e4[55]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],_0x382fx2d[_0x34e4[53]]);_0x382fx1f[_0x34e4[57]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],qs[_0x34e4[58]](_0x382fx2c[_0x34e4[53]][_0x34e4[58]]));_0x382fx1f[_0x34e4[57]]= (_0x382fx1f[_0x34e4[57]][_0x34e4[59]])?_0x382fx1f[_0x34e4[57]]:_0x382fx2d[_0x34e4[48]];if(!_0x382fx2c[_0x34e4[53]][_0x34e4[61]](_0x34e4[60])){_0x382fx1f[_0x34e4[32]]= qs[_0x34e4[32]](_0x382fx2c[_0x34e4[53]][_0x34e4[32]]);_0x382fx1f[_0x34e4[31]]= qs[_0x34e4[31]](_0x382fx2c[_0x34e4[53]][_0x34e4[31]])};_0x382fx1f[_0x34e4[62]]= qs[_0x34e4[63]](_0x382fx2c[_0x34e4[53]][_0x34e4[63]]);_0x382fx1f[_0x34e4[64]]= qs[_0x34e4[55]](_[_0x34e4[65]](_0x382fx2c[_0x34e4[53]],_0x382fx2d[_0x34e4[55]]));_0x382fx1f[_0x34e4[64]][_0x34e4[91]]= _0x382fx1c[_0x34e4[79]];if(_0x382fx2c[_0x34e4[53]][_0x34e4[69]]){_0x382fx1f[_0x34e4[64]]= _[_0x34e4[68]](_0x382fx1f[_0x34e4[64]],{$or:_[_0x34e4[71]](_0x382fx1f[_0x34e4[57]],function(_0x382fx30){var _0x382fx2e={};_0x382fx2e[_0x382fx30]= {$like:_0x34e4[70]+ _0x382fx2c[_0x34e4[53]][_0x34e4[69]]+ _0x34e4[70]};return _0x382fx2e})})};_0x382fx1f= _[_0x34e4[68]]({},_0x382fx1f,_0x382fx2c[_0x34e4[72]]);return db[_0x34e4[90]][_0x34e4[30]]({where:_0x382fx1f[_0x34e4[64]]})[_0x34e4[40]](function(_0x382fx20){_0x382fx35[_0x34e4[30]]= _0x382fx20;if(_0x382fx2c[_0x34e4[53]][_0x34e4[75]]){_0x382fx1f[_0x34e4[76]]= [{all:true}]};return db[_0x34e4[90]][_0x34e4[77]](_0x382fx1f)})[_0x34e4[40]](function(_0x382fx32){_0x382fx35[_0x34e4[74]]= _0x382fx32;return _0x382fx35})}})[_0x34e4[40]](respondWithFilteredResult(_0x382fx1a,_0x382fx1f))[_0x34e4[73]](handleError(_0x382fx1a,null))};exports[_0x34e4[93]]= function(_0x382fx2c,_0x382fx1a,_0x382fx34){var _0x382fx1f={raw:true,where:{}};var _0x382fx2d={};var _0x382fx35={count:0,rows:[]};var _0x382fx2f={dateStart:_0x382fx2c[_0x34e4[53]][_0x34e4[52]],dateEnd:_0x382fx2c[_0x34e4[53]][_0x34e4[54]]};delete _0x382fx2c[_0x34e4[53]][_0x34e4[52]];delete _0x382fx2c[_0x34e4[53]][_0x34e4[54]];return db[_0x34e4[50]][_0x34e4[92]]({where:{id:_0x382fx2c[_0x34e4[80]][_0x34e4[79]]}})[_0x34e4[40]](handleEntityNotFound(_0x382fx1a,null))[_0x34e4[40]](function(_0x382fx1c){if(_0x382fx1c){_0x382fx2d[_0x34e4[48]]= _[_0x34e4[51]](db[_0x34e4[94]][_0x34e4[49]]);_0x382fx2d[_0x34e4[53]]= _[_0x34e4[51]](_0x382fx2c[_0x34e4[53]]);_0x382fx2d[_0x34e4[55]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],_0x382fx2d[_0x34e4[53]]);_0x382fx1f[_0x34e4[57]]= _[_0x34e4[56]](_0x382fx2d[_0x34e4[48]],qs[_0x34e4[58]](_0x382fx2c[_0x34e4[53]][_0x34e4[58]]));_0x382fx1f[_0x34e4[57]]= (_0x382fx1f[_0x34e4[57]][_0x34e4[59]])?_0x382fx1f[_0x34e4[57]]:_0x382fx2d[_0x34e4[48]];if(!_0x382fx2c[_0x34e4[53]][_0x34e4[61]](_0x34e4[60])){_0x382fx1f[_0x34e4[32]]= qs[_0x34e4[32]](_0x382fx2c[_0x34e4[53]][_0x34e4[32]]);_0x382fx1f[_0x34e4[31]]= qs[_0x34e4[31]](_0x382fx2c[_0x34e4[53]][_0x34e4[31]])};_0x382fx1f[_0x34e4[62]]= qs[_0x34e4[63]](_0x382fx2c[_0x34e4[53]][_0x34e4[63]]);_0x382fx1f[_0x34e4[64]]= qs[_0x34e4[55]](_[_0x34e4[65]](_0x382fx2c[_0x34e4[53]],_0x382fx2d[_0x34e4[55]]));_0x382fx1f[_0x34e4[64]][_0x34e4[91]]= _0x382fx1c[_0x34e4[79]];if(_0x382fx2f[_0x34e4[52]]){if(_0x382fx2f[_0x34e4[54]]){_0x382fx2f[_0x34e4[54]]= moment(_0x382fx2f[_0x34e4[54]])[_0x34e4[67]](1,_0x34e4[66])}else {_0x382fx2f[_0x34e4[54]]= moment(_0x382fx2f[_0x34e4[52]])[_0x34e4[67]](1,_0x34e4[66])};_[_0x34e4[68]](_0x382fx1f[_0x34e4[64]],{createdAt:{$gte:_0x382fx2f[_0x34e4[52]],$lte:_0x382fx2f[_0x34e4[54]]}})};if(_0x382fx2c[_0x34e4[53]][_0x34e4[69]]){_0x382fx1f[_0x34e4[64]]= _[_0x34e4[68]](_0x382fx1f[_0x34e4[64]],{$or:_[_0x34e4[71]](_0x382fx1f[_0x34e4[57]],function(_0x382fx30){var _0x382fx2e={};_0x382fx2e[_0x382fx30]= {$like:_0x34e4[70]+ _0x382fx2c[_0x34e4[53]][_0x34e4[69]]+ _0x34e4[70]};return _0x382fx2e})})};_0x382fx1f= _[_0x34e4[68]]({},_0x382fx1f,_0x382fx2c[_0x34e4[72]]);return db[_0x34e4[94]][_0x34e4[30]]({where:_0x382fx1f[_0x34e4[64]]})[_0x34e4[40]](function(_0x382fx20){_0x382fx35[_0x34e4[30]]= _0x382fx20;if(_0x382fx2c[_0x34e4[53]][_0x34e4[75]]){_0x382fx1f[_0x34e4[76]]= [{all:true}]};return db[_0x34e4[94]][_0x34e4[77]](_0x382fx1f)})[_0x34e4[40]](function(_0x382fx32){_0x382fx35[_0x34e4[74]]= _0x382fx32;return _0x382fx35})}})[_0x34e4[40]](respondWithFilteredResult(_0x382fx1a,_0x382fx1f))[_0x34e4[73]](handleError(_0x382fx1a,null))};function char(_0x382fx37){return _0x34e4[95]===  typeof _0x382fx37?String[_0x34e4[96]][_0x34e4[37]](null,arguments):_0x382fx37}function needsEncapsulation(_0x382fx39){return !!_0x382fx39&& (_0x382fx39.toString()[_0x34e4[97]](char(0xd))>= 0|| _0x382fx39.toString()[_0x34e4[97]](char(0xa))>= 0|| _0x382fx39.toString()[_0x34e4[97]](char(0x2c))>= 0|| _0x382fx39.toString()[_0x34e4[97]](char(0x22))>= 0)}function encapsulate(_0x382fx39){var _0x382fx3b=char(0x22),_0x382fx3c=_0x34e4[98]+ char(0x22),_0x382fx3d=_0x382fx39.toString()[_0x34e4[100]]( new RegExp(_0x382fx3b,_0x34e4[99]),_0x382fx3c);return _0x382fx3b+ _0x382fx3d+ _0x382fx3b}exports[_0x34e4[101]]= function(_0x382fx2c,_0x382fx1a,_0x382fx34){var _0x382fx3e,_0x382fx3f;return db[_0x34e4[90]][_0x34e4[77]]({where:{ProjectId:_0x382fx2c[_0x34e4[80]][_0x34e4[79]]}})[_0x34e4[40]](handleEntityNotFound(_0x382fx1a,null))[_0x34e4[40]](function(_0x382fx1c){if(_0x382fx1c){_0x382fx3e= _0x382fx1c;return db[_0x34e4[121]][_0x34e4[77]]({where:{ProjectId:_0x382fx2c[_0x34e4[80]][_0x34e4[79]]},order:_0x34e4[120]})}})[_0x34e4[40]](handleEntityNotFound(_0x382fx1a,null))[_0x34e4[40]](function(_0x382fx1c){if(_0x382fx1c){_0x382fx3f= _0x382fx1c;var _0x382fx40={};for(var _0x382fx41=0,_0x382fx42=_0x382fx3f[_0x34e4[59]];_0x382fx41< _0x382fx42;_0x382fx41++){if(!_0x382fx40[_0x34e4[61]](_0x382fx3f[_0x382fx41][_0x34e4[102]])){_0x382fx40[_0x382fx3f[_0x382fx41][_0x34e4[102]]]= needsEncapsulation(_0x382fx3f[_0x382fx41][_0x34e4[103]])?encapsulate(_0x382fx3f[_0x382fx41][_0x34e4[103]]):_0x382fx3f[_0x382fx41][_0x34e4[103]]}};var _0x382fx43=[],_0x382fx44={};for(var _0x382fx45=0,_0x382fx46=_0x382fx3e[_0x34e4[59]];_0x382fx45< _0x382fx46;_0x382fx45++){_0x382fx44= {ProjectId:_0x382fx2c[_0x34e4[80]][_0x34e4[79]],SessionId:_0x382fx3e[_0x382fx45][_0x34e4[79]],StartTime:moment(_0x382fx3e[_0x382fx45][_0x34e4[106]])[_0x34e4[105]](_0x34e4[104])};for(var _0x382fx47=0,_0x382fx48=_0x382fx3f[_0x34e4[59]];_0x382fx47< _0x382fx48;_0x382fx47++){if(_0x382fx3f[_0x382fx47][_0x34e4[107]]== _0x382fx3e[_0x382fx45][_0x34e4[79]]&& _0x382fx40[_0x34e4[61]](_0x382fx3f[_0x382fx47][_0x34e4[102]])){_0x382fx44[_0x382fx40[_0x382fx3f[_0x382fx47][_0x34e4[102]]]]= _0x382fx3f[_0x382fx47][_0x34e4[108]]}};for(var _0x382fx49 in _0x382fx40){if(!_0x382fx44[_0x34e4[61]](_0x382fx40[_0x382fx49])){_0x382fx44[_0x382fx40[_0x382fx49]]= null}};_0x382fx43[_0x34e4[109]](_0x382fx44)};var _0x382fx4a=toCsv(_0x382fx43);var _0x382fx4b=Date[_0x34e4[110]]();fs[_0x34e4[112]](util[_0x34e4[105]](_0x34e4[111],_0x382fx2c[_0x34e4[80]][_0x34e4[79]],_0x382fx4b),_0x382fx4a);_0x382fx1a[_0x34e4[116]](_0x34e4[113],_0x34e4[114]+ util[_0x34e4[105]](_0x34e4[115],_0x382fx2c[_0x34e4[80]][_0x34e4[79]],_0x382fx4b));_0x382fx1a[_0x34e4[116]](_0x34e4[117],_0x34e4[118]);_0x382fx1a[_0x34e4[119]](util[_0x34e4[105]](_0x34e4[111],_0x382fx2c[_0x34e4[80]][_0x34e4[79]],_0x382fx4b))}})[_0x34e4[73]](handleError(_0x382fx1a,null))}