Built motion from commit 67e5df37.|2.0.63
[motion2.git] / server / api / analyticCustomReport / analyticCustomReport.controller.js
1 var _0xb260=["\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","\x41\x6E\x61\x6C\x79\x74\x69\x63\x43\x75\x73\x74\x6F\x6D\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","\x70\x72\x65\x76\x69\x65\x77","\x6A\x6F\x69\x6E","\x6C\x65\x66\x74\x5F\x6A\x6F\x69\x6E","\x72\x69\x67\x68\x74\x5F\x6A\x6F\x69\x6E","\x6F\x75\x74\x65\x72\x5F\x6A\x6F\x69\x6E","\x63\x72\x6F\x73\x73\x5F\x6A\x6F\x69\x6E","\x53\x55\x4D\x28\x25\x73\x29","\x43\x4F\x55\x4E\x54\x28\x25\x73\x29","\x43\x4F\x55\x4E\x54\x28\x44\x49\x53\x54\x49\x4E\x43\x54\x20\x25\x73\x29","\x4D\x41\x58\x28\x25\x73\x29","\x4D\x49\x4E\x28\x25\x73\x29","\x41\x56\x47\x28\x25\x73\x29","\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x28\x25\x73\x29","\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x28\x25\x73\x20\x4F\x52\x44\x45\x52\x20\x42\x59\x20\x25\x73\x20\x41\x53\x43\x29","\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x28\x25\x73\x20\x4F\x52\x44\x45\x52\x20\x42\x59\x20\x25\x73\x20\x44\x45\x53\x43\x29","\x53\x45\x43\x5F\x54\x4F\x5F\x54\x49\x4D\x45\x28\x25\x73\x29","\x44\x41\x54\x45\x28\x25\x73\x29","\x48\x4F\x55\x52\x28\x25\x73\x29","\x52\x4F\x55\x4E\x44\x28\x25\x73\x29","\x55\x4E\x49\x58\x5F\x54\x49\x4D\x45\x53\x54\x41\x4D\x50\x28\x25\x73\x29","\x49\x53\x20\x4E\x55\x4C\x4C","\x49\x53\x20\x4E\x4F\x54\x20\x4E\x55\x4C\x4C","\x49\x53\x20\x45\x4D\x50\x54\x59","\x49\x53\x20\x4E\x4F\x54\x20\x45\x4D\x50\x54\x59","\x69\x6E\x63\x6C\x75\x64\x65\x73","\x72\x75\x6C\x65\x73","","\x28","\x20","\x6F\x70\x65\x72\x61\x74\x6F\x72","\x67\x72\x6F\x75\x70","\x66\x69\x65\x6C\x64","\x63\x6F\x6E\x64\x69\x74\x69\x6F\x6E","\x76\x61\x6C\x75\x65","\x29","\x6B\x65\x79\x42\x79","\x73\x65\x6C\x65\x63\x74","\x74\x61\x62\x6C\x65","\x66\x72\x6F\x6D","\x4D\x65\x74\x72\x69\x63\x49\x64","\x6D\x65\x74\x72\x69\x63","\x66\x75\x6E\x63\x74\x69\x6F\x6E","\x25\x73","\x72\x65\x70\x6C\x61\x63\x65","\x66\x6F\x72\x6D\x61\x74","\x67\x72\x6F\x75\x70\x42\x79","\x6F\x72\x64\x65\x72\x42\x79","\x44\x45\x53\x43","\x61\x6C\x69\x61\x73","\x6A\x6F\x69\x6E\x73","\x70\x61\x72\x73\x65","\x74\x79\x70\x65","\x70\x61\x72\x65\x6E\x74\x4B\x65\x79","\x66\x6F\x72\x65\x69\x67\x6E\x54\x61\x62\x6C\x65","\x66\x6F\x72\x65\x69\x67\x6E\x4B\x65\x79","\x25\x73\x2E\x25\x73\x20\x3D\x20\x25\x73\x2E\x25\x73","\x63\x6F\x6E\x64\x69\x74\x69\x6F\x6E\x73","\x63\x6C\x6F\x6E\x65","\x4C\x69\x6D\x69\x74\x65\x64\x20\x51\x75\x65\x72\x79\x3A","\x64\x65\x62\x75\x67","\x53\x45\x4C\x45\x43\x54","\x51\x75\x65\x72\x79\x54\x79\x70\x65\x73","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x50\x6C\x65\x61\x73\x65\x20\x69\x6E\x73\x65\x72\x74\x20\x61\x74\x20\x6C\x65\x61\x73\x74\x20\x6F\x6E\x65\x20\x66\x69\x65\x6C\x64\x21","\x53\x65\x71\x75\x65\x6C\x69\x7A\x65","\x41\x6E\x61\x6C\x79\x74\x69\x63\x4D\x65\x74\x72\x69\x63","\x67\x65\x74\x46\x69\x65\x6C\x64\x73","\x2E\x63\x72\x65\x61\x74\x65\x64\x41\x74\x20\x42\x45\x54\x57\x45\x45\x4E\x20\x3F\x20\x41\x4E\x44\x20\x3F","\x73\x74\x61\x72\x74\x44\x61\x74\x65","\x65\x6E\x64\x44\x61\x74\x65","\x52\x75\x6E\x20\x51\x75\x65\x72\x79\x3A","\x69\x6E\x66\x6F","\x2E\x2E\x2F\x2E\x2E\x2F\x63\x6F\x6D\x70\x6F\x6E\x65\x6E\x74\x73\x2F\x65\x78\x70\x6F\x72\x74\x2F","\x6F\x75\x74\x70\x75\x74","\x2E\x2E\x2F\x2E\x2E\x2F\x66\x69\x6C\x65\x73\x2F\x72\x65\x70\x6F\x72\x74\x73","\x73\x61\x76\x65\x6E\x61\x6D\x65","\x66\x6F\x72\x6B","\x63\x68\x69\x6C\x64\x5F\x70\x72\x6F\x63\x65\x73\x73","\x63\x6F\x75\x6E\x74\x54\x61\x62\x6C\x65","\x43\x4F\x55\x4E\x54\x28\x2A\x29","\x4E\x6F\x20\x44\x61\x74\x61\x21","\x77\x65\x62","\x66\x75\x6C\x6C\x50\x61\x74\x68","\x25\x73\x2D\x25\x73\x2E\x25\x73","\x67\x65\x6E\x65\x72\x61\x74\x65","\x72\x61\x6E\x64\x6F\x6D\x73\x74\x72\x69\x6E\x67","\x63\x73\x76","\x41\x6E\x61\x6C\x79\x74\x69\x63\x45\x78\x74\x72\x61\x63\x74\x65\x64\x52\x65\x70\x6F\x72\x74","\x72\x75\x6E","\x72\x75\x6E\x52\x65\x70\x6F\x72\x74"];_0xb260[0];var jsonpatch=require(_0xb260[1]);var rp=require(_0xb260[2]);var moment=require(_0xb260[3]);var BPromise=require(_0xb260[4]);var Mustache=require(_0xb260[5]);var util=require(_0xb260[6]);var path=require(_0xb260[7]);var sox=require(_0xb260[8]);var csv=require(_0xb260[9]);var ejs=require(_0xb260[10]);var fs=require(_0xb260[11]);var _=require(_0xb260[12]);var squel=require(_0xb260[13]);var crypto=require(_0xb260[14]);var jsforce=require(_0xb260[15]);var deskjs=require(_0xb260[16]);var toCsv=require(_0xb260[9]);var querystring=require(_0xb260[17]);var Papa=require(_0xb260[18]);var qs=require(_0xb260[19]);var logger=require(_0xb260[21])(_0xb260[20]);var utils=require(_0xb260[22]);var config=require(_0xb260[23]);var db=require(_0xb260[25])[_0xb260[24]];function respondWithStatusCode(_0x3c94x1a,_0x3c94x1b){_0x3c94x1b= _0x3c94x1b|| 204;return function(_0x3c94x1c){if(_0x3c94x1c){return _0x3c94x1a[_0xb260[26]](_0x3c94x1b)};return _0x3c94x1a[_0xb260[28]](_0x3c94x1b)[_0xb260[27]]()}}function respondWithResult(_0x3c94x1a,_0x3c94x1b){_0x3c94x1b= _0x3c94x1b|| 200;return function(_0x3c94x1c){if(_0x3c94x1c){return _0x3c94x1a[_0xb260[28]](_0x3c94x1b)[_0xb260[29]](_0x3c94x1c)}}}function respondWithFilteredResult(_0x3c94x1a,_0x3c94x1f){return function(_0x3c94x1c){if(_0x3c94x1c){var _0x3c94x20=_0x3c94x1c[_0xb260[30]],_0x3c94x21=_0x3c94x1f[_0xb260[31]],_0x3c94x22=_0x3c94x1f[_0xb260[31]]+ _0x3c94x1f[_0xb260[32]],_0x3c94x1b;if(_0x3c94x22>= _0x3c94x20){_0x3c94x22= _0x3c94x20;_0x3c94x1b= 200}else {_0x3c94x1b= 206};_0x3c94x1a[_0xb260[28]](_0x3c94x1b);return _0x3c94x1a[_0xb260[36]](_0xb260[33],_0x3c94x21+ _0xb260[34]+ _0x3c94x22+ _0xb260[35]+ _0x3c94x20)[_0xb260[29]](_0x3c94x1c)};return null}}function patchUpdates(_0x3c94x24){return function(_0x3c94x1c){try{jsonpatch[_0xb260[37]](_0x3c94x1c,_0x3c94x24,true)}catch(err){return BPromise[_0xb260[38]](err)};return _0x3c94x1c[_0xb260[39]]()}}function saveUpdates(_0x3c94x26,_0x3c94x1b){return function(_0x3c94x1c){if(_0x3c94x1c){return _0x3c94x1c[_0xb260[41]](_0x3c94x26)[_0xb260[40]](function(_0x3c94x27){return _0x3c94x27})};return null}}function removeEntity(_0x3c94x1a,_0x3c94x1b){return function(_0x3c94x1c){if(_0x3c94x1c){return _0x3c94x1c[_0xb260[42]]()[_0xb260[40]](function(){_0x3c94x1a[_0xb260[28]](204)[_0xb260[27]]()})}}}function handleEntityNotFound(_0x3c94x1a,_0x3c94x1b){return function(_0x3c94x1c){if(!_0x3c94x1c){_0x3c94x1a[_0xb260[26]](404)};return _0x3c94x1c}}function handleError(_0x3c94x1a,_0x3c94x1b){_0x3c94x1b= _0x3c94x1b|| 500;return function(_0x3c94x2b){logger[_0xb260[44]](_0x3c94x2b[_0xb260[43]]);if(_0x3c94x2b[_0xb260[45]]){delete _0x3c94x2b[_0xb260[45]]};_0x3c94x1a[_0xb260[28]](_0x3c94x1b)[_0xb260[46]](_0x3c94x2b)}}exports[_0xb260[47]]= function(_0x3c94x2c,_0x3c94x1a){var _0x3c94x1f={},_0x3c94x2d={},_0x3c94x2e={count:0,rows:[]};_0x3c94x2d[_0xb260[48]]= _[_0xb260[51]](db[_0xb260[50]][_0xb260[49]]);var _0x3c94x2f={dateStart:_0x3c94x2c[_0xb260[53]][_0xb260[52]],dateEnd:_0x3c94x2c[_0xb260[53]][_0xb260[54]]};delete _0x3c94x2c[_0xb260[53]][_0xb260[52]];delete _0x3c94x2c[_0xb260[53]][_0xb260[54]];_0x3c94x2d[_0xb260[53]]= _[_0xb260[51]](_0x3c94x2c[_0xb260[53]]);_0x3c94x2d[_0xb260[55]]= _[_0xb260[56]](_0x3c94x2d[_0xb260[48]],_0x3c94x2d[_0xb260[53]]);_0x3c94x1f[_0xb260[57]]= _[_0xb260[56]](_0x3c94x2d[_0xb260[48]],qs[_0xb260[58]](_0x3c94x2c[_0xb260[53]][_0xb260[58]]));_0x3c94x1f[_0xb260[57]]= (_0x3c94x1f[_0xb260[57]][_0xb260[59]])?_0x3c94x1f[_0xb260[57]]:_0x3c94x2d[_0xb260[48]];if(!_0x3c94x2c[_0xb260[53]][_0xb260[61]](_0xb260[60])){_0x3c94x1f[_0xb260[32]]= qs[_0xb260[32]](_0x3c94x2c[_0xb260[53]][_0xb260[32]]);_0x3c94x1f[_0xb260[31]]= qs[_0xb260[31]](_0x3c94x2c[_0xb260[53]][_0xb260[31]])};_0x3c94x1f[_0xb260[62]]= qs[_0xb260[63]](_0x3c94x2c[_0xb260[53]][_0xb260[63]]);_0x3c94x1f[_0xb260[64]]= qs[_0xb260[55]](_[_0xb260[65]](_0x3c94x2c[_0xb260[53]],_0x3c94x2d[_0xb260[55]]));if(_0x3c94x2f[_0xb260[52]]){if(_0x3c94x2f[_0xb260[54]]){_0x3c94x2f[_0xb260[54]]= moment(_0x3c94x2f[_0xb260[54]])[_0xb260[67]](1,_0xb260[66])}else {_0x3c94x2f[_0xb260[54]]= moment(_0x3c94x2f[_0xb260[52]])[_0xb260[67]](1,_0xb260[66])};_[_0xb260[68]](_0x3c94x1f[_0xb260[64]],{createdAt:{$gte:_0x3c94x2f[_0xb260[52]],$lte:_0x3c94x2f[_0xb260[54]]}})};if(_0x3c94x2c[_0xb260[53]][_0xb260[69]]){_0x3c94x1f[_0xb260[64]]= _[_0xb260[68]](_0x3c94x1f[_0xb260[64]],{$or:_[_0xb260[71]](_0x3c94x1f[_0xb260[57]],function(_0x3c94x30){var _0x3c94x2e={};_0x3c94x2e[_0x3c94x30]= {$like:_0xb260[70]+ _0x3c94x2c[_0xb260[53]][_0xb260[69]]+ _0xb260[70]};return _0x3c94x2e})})};_0x3c94x1f= _[_0xb260[68]]({},_0x3c94x1f,_0x3c94x2c[_0xb260[72]]);var _0x3c94x31={where:_0x3c94x1f[_0xb260[64]]};return db[_0xb260[50]][_0xb260[30]](_0x3c94x31)[_0xb260[40]](function(_0x3c94x20){_0x3c94x2e[_0xb260[30]]= _0x3c94x20;if(_0x3c94x2c[_0xb260[53]][_0xb260[75]]){_0x3c94x1f[_0xb260[76]]= [{all:true}]};return db[_0xb260[50]][_0xb260[77]](_0x3c94x1f)})[_0xb260[40]](function(_0x3c94x32){_0x3c94x2e[_0xb260[74]]= _0x3c94x32;return _0x3c94x2e})[_0xb260[40]](respondWithFilteredResult(_0x3c94x1a,_0x3c94x1f))[_0xb260[73]](handleError(_0x3c94x1a,null))};exports[_0xb260[78]]= function(_0x3c94x2c,_0x3c94x1a){var _0x3c94x1f={raw:false,where:{id:_0x3c94x2c[_0xb260[80]][_0xb260[79]]}},_0x3c94x2d={};_0x3c94x2d[_0xb260[48]]= _[_0xb260[51]](db[_0xb260[50]][_0xb260[49]]);_0x3c94x2d[_0xb260[53]]= _[_0xb260[51]](_0x3c94x2c[_0xb260[53]]);_0x3c94x2d[_0xb260[55]]= _[_0xb260[56]](_0x3c94x2d[_0xb260[48]],_0x3c94x2d[_0xb260[53]]);_0x3c94x1f[_0xb260[57]]= _[_0xb260[56]](_0x3c94x2d[_0xb260[48]],qs[_0xb260[58]](_0x3c94x2c[_0xb260[53]][_0xb260[58]]));_0x3c94x1f[_0xb260[57]]= (_0x3c94x1f[_0xb260[57]][_0xb260[59]])?_0x3c94x1f[_0xb260[57]]:_0x3c94x2d[_0xb260[48]];if(_0x3c94x2c[_0xb260[53]][_0xb260[75]]){_0x3c94x1f[_0xb260[76]]= [{all:true}]};_0x3c94x1f= _[_0xb260[68]]({},_0x3c94x1f,_0x3c94x2c[_0xb260[72]]);return db[_0xb260[50]][_0xb260[81]](_0x3c94x1f)[_0xb260[40]](handleEntityNotFound(_0x3c94x1a,null))[_0xb260[40]](respondWithResult(_0x3c94x1a,null))[_0xb260[73]](handleError(_0x3c94x1a,null))};exports[_0xb260[82]]= function(_0x3c94x2c,_0x3c94x1a){return db[_0xb260[50]][_0xb260[82]](_0x3c94x2c[_0xb260[83]],{})[_0xb260[40]](respondWithResult(_0x3c94x1a,201))[_0xb260[73]](handleError(_0x3c94x1a,null))};exports[_0xb260[41]]= function(_0x3c94x2c,_0x3c94x1a){if(_0x3c94x2c[_0xb260[83]][_0xb260[79]]){delete _0x3c94x2c[_0xb260[83]][_0xb260[79]]};return db[_0xb260[50]][_0xb260[81]]({where:{id:_0x3c94x2c[_0xb260[80]][_0xb260[79]]}})[_0xb260[40]](handleEntityNotFound(_0x3c94x1a,null))[_0xb260[40]](saveUpdates(_0x3c94x2c[_0xb260[83]],null))[_0xb260[40]](respondWithResult(_0x3c94x1a,null))[_0xb260[73]](handleError(_0x3c94x1a,null))};exports[_0xb260[42]]= function(_0x3c94x2c,_0x3c94x1a){return db[_0xb260[50]][_0xb260[81]]({where:{id:_0x3c94x2c[_0xb260[80]][_0xb260[79]]}})[_0xb260[40]](handleEntityNotFound(_0x3c94x1a,null))[_0xb260[40]](removeEntity(_0x3c94x1a,null))[_0xb260[73]](handleError(_0x3c94x1a,null))};exports[_0xb260[84]]= function(_0x3c94x2c,_0x3c94x1a){var _0x3c94x33=10;var _0x3c94x34=[_0xb260[85],_0xb260[86],_0xb260[87],_0xb260[88],_0xb260[89]];var _0x3c94x35={"\x53\x55\x4D":_0xb260[90],"\x43\x4F\x55\x4E\x54":_0xb260[91],"\x43\x4F\x55\x4E\x54\x20\x44\x49\x53\x54\x49\x4E\x43\x54":_0xb260[92],"\x4D\x41\x58":_0xb260[93],"\x4D\x49\x4E":_0xb260[94],"\x41\x56\x47":_0xb260[95],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54":_0xb260[96],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x20\x41\x53\x43":_0xb260[97],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x20\x44\x45\x53\x43":_0xb260[98]};var _0x3c94x36={"\x53\x45\x43\x5F\x54\x4F\x5F\x54\x49\x4D\x45":_0xb260[99],"\x44\x41\x54\x45":_0xb260[100],"\x48\x4F\x55\x52":_0xb260[101],"\x52\x4F\x55\x4E\x44":_0xb260[102],"\x55\x4E\x49\x58\x5F\x54\x49\x4D\x45\x53\x54\x41\x4D\x50":_0xb260[103]};var _0x3c94x37=function(_0x3c94x38){return !_[_0xb260[108]]([_0xb260[104],_0xb260[105],_0xb260[106],_0xb260[107]],_0x3c94x38)};var _0x3c94x39=function(_0x3c94x3a){if(!_0x3c94x3a||  !_0x3c94x3a[_0xb260[109]][_0xb260[59]]){return _0xb260[110]};for(var _0x3c94x3b=_0xb260[111],_0x3c94x3c=0;_0x3c94x3c< _0x3c94x3a[_0xb260[109]][_0xb260[59]];_0x3c94x3c+= 1){_0x3c94x3c> 0&& (_0x3c94x3b+= _0xb260[112]+ _0x3c94x3a[_0xb260[113]]+ _0xb260[112]);_0x3c94x3b+= _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[114]]?_0x3c94x39(_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[114]]):_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[115]]+ _0xb260[112]+ _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[116]]+ (_0x3c94x37(_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[116]])?_0xb260[112]+ _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[117]]:_0xb260[110])};return _0x3c94x3b+ _0xb260[118]};var _0x3c94x1f={where:{id:_0x3c94x2c[_0xb260[80]][_0xb260[79]]}},_0x3c94x3d,_0x3c94x3e,_0x3c94x3f,_0x3c94x40,_0x3c94x41;_0x3c94x1f= _[_0xb260[68]]({},_0x3c94x1f,_0x3c94x2c[_0xb260[72]]);return db[_0xb260[50]][_0xb260[81]](_0x3c94x1f)[_0xb260[40]](function(_0x3c94x1c){if(_0x3c94x1c){_0x3c94x3d= _0x3c94x1c;return _0x3c94x1c[_0xb260[150]]()};return null})[_0xb260[40]](function(_0x3c94x42){if(_0x3c94x42){if(!_0x3c94x42[_0xb260[59]]){throw  new db[_0xb260[148]].ValidationError(_0xb260[147])};_0x3c94x3e= _0x3c94x42;return db[_0xb260[149]][_0xb260[77]]({raw:true})};return null})[_0xb260[40]](function(_0x3c94x42){if(_0x3c94x42){_0x3c94x3f= _[_0xb260[119]](_0x3c94x42,_0xb260[79]);var _0x3c94x43;var _0x3c94x44=squel[_0xb260[120]]();_0x3c94x44[_0xb260[122]](_0x3c94x3d[_0xb260[121]]);for(var _0x3c94x3c=0;_0x3c94x3c< _0x3c94x3e[_0xb260[59]];_0x3c94x3c+= 1){_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[123]]?_0x3c94x3f[_0x3c94x3e[_0x3c94x3c][_0xb260[123]]][_0xb260[124]]:_0x3c94x3e[_0x3c94x3c][_0xb260[115]];_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[125]]?_[_0xb260[127]](_0x3c94x35[_0x3c94x3e[_0x3c94x3c][_0xb260[125]]],_0xb260[126],_0x3c94x43):_0x3c94x43;_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[128]]?_[_0xb260[127]](_0x3c94x36[_0x3c94x3e[_0x3c94x3c][_0xb260[128]]],_0xb260[126],_0x3c94x43):_0x3c94x43;if(_0x3c94x3e[_0x3c94x3c][_0xb260[129]]){_0x3c94x44[_0xb260[114]](_0x3c94x43)};_0x3c94x3e[_0x3c94x3c][_0xb260[130]]&& _0x3c94x44[_0xb260[62]](_0x3c94x43,_0x3c94x3e[_0x3c94x3c][_0xb260[130]]=== _0xb260[131]?false:true);_0x3c94x44[_0xb260[115]](_0x3c94x43,_0x3c94x3e[_0x3c94x3c][_0xb260[132]]|| _0x3c94x43)};if(_0x3c94x3d[_0xb260[133]]){_0x3c94x3d[_0xb260[133]]= JSON[_0xb260[134]](_0x3c94x3d[_0xb260[133]]);for(var _0x3c94x45=0;_0x3c94x45< _0x3c94x3d[_0xb260[133]][_0xb260[59]];_0x3c94x45+= 1){if(_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]]&& _[_0xb260[108]](_0x3c94x34,_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]])&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[136]]&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]]&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[138]]){_0x3c94x44[_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]]](_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]],null,util[_0xb260[128]](_0xb260[139],_0x3c94x3d[_0xb260[121]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[136]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[138]]))}}};if(_0x3c94x3d[_0xb260[140]]){_0x3c94x3d[_0xb260[140]]= JSON[_0xb260[134]](_0x3c94x3d[_0xb260[140]]);_0x3c94x44[_0xb260[64]](_0x3c94x39(_0x3c94x3d[_0xb260[140]][_0xb260[114]]))};_0x3c94x41= _0x3c94x44[_0xb260[141]]();_0x3c94x44[_0xb260[32]](_0x3c94x33);_0x3c94x44[_0xb260[31]](0);logger[_0xb260[143]](_0xb260[142],_0x3c94x44.toString());return db[_0xb260[146]][_0xb260[53]](_0x3c94x44.toString(),{type:db[_0xb260[146]][_0xb260[145]][_0xb260[144]]})}})[_0xb260[40]](respondWithResult(_0x3c94x1a,null))[_0xb260[73]](handleError(_0x3c94x1a,null))};function runReport(_0x3c94x47,_0x3c94x48,_0x3c94x49){var _0x3c94x4a=_0x3c94x48[_0xb260[45]];var _0x3c94x33=10;var _0x3c94x34=[_0xb260[85],_0xb260[86],_0xb260[87],_0xb260[88],_0xb260[89]];var _0x3c94x35={"\x53\x55\x4D":_0xb260[90],"\x43\x4F\x55\x4E\x54":_0xb260[91],"\x43\x4F\x55\x4E\x54\x20\x44\x49\x53\x54\x49\x4E\x43\x54":_0xb260[92],"\x4D\x41\x58":_0xb260[93],"\x4D\x49\x4E":_0xb260[94],"\x41\x56\x47":_0xb260[95],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54":_0xb260[96],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x20\x41\x53\x43":_0xb260[97],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x20\x44\x45\x53\x43":_0xb260[98]};var _0x3c94x36={"\x53\x45\x43\x5F\x54\x4F\x5F\x54\x49\x4D\x45":_0xb260[99],"\x44\x41\x54\x45":_0xb260[100],"\x48\x4F\x55\x52":_0xb260[101],"\x52\x4F\x55\x4E\x44":_0xb260[102],"\x55\x4E\x49\x58\x5F\x54\x49\x4D\x45\x53\x54\x41\x4D\x50":_0xb260[103]};var _0x3c94x37=function(_0x3c94x38){return !_[_0xb260[108]]([_0xb260[104],_0xb260[105],_0xb260[106],_0xb260[107]],_0x3c94x38)};var _0x3c94x39=function(_0x3c94x3a){if(!_0x3c94x3a||  !_0x3c94x3a[_0xb260[109]][_0xb260[59]]){return _0xb260[110]};for(var _0x3c94x3b=_0xb260[111],_0x3c94x3c=0;_0x3c94x3c< _0x3c94x3a[_0xb260[109]][_0xb260[59]];_0x3c94x3c+= 1){_0x3c94x3c> 0&& (_0x3c94x3b+= _0xb260[112]+ _0x3c94x3a[_0xb260[113]]+ _0xb260[112]);_0x3c94x3b+= _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[114]]?_0x3c94x39(_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[114]]):_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[115]]+ _0xb260[112]+ _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[116]]+ (_0x3c94x37(_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[116]])?_0xb260[112]+ _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[117]]:_0xb260[110])};return _0x3c94x3b+ _0xb260[118]};var _0x3c94x1f={where:{id:_0x3c94x47[_0xb260[79]]}},_0x3c94x3d,_0x3c94x3e,_0x3c94x3f,_0x3c94x40,_0x3c94x41;_0x3c94x1f= _[_0xb260[68]]({},_0x3c94x1f,_0x3c94x49);return db[_0xb260[50]][_0xb260[81]](_0x3c94x1f)[_0xb260[40]](function(_0x3c94x1c){if(_0x3c94x1c){_0x3c94x3d= _0x3c94x1c;return _0x3c94x1c[_0xb260[150]]()};return null})[_0xb260[40]](function(_0x3c94x42){if(_0x3c94x42){if(!_0x3c94x42[_0xb260[59]]){throw  new db[_0xb260[148]].ValidationError(_0xb260[147])};_0x3c94x3e= _0x3c94x42;return db[_0xb260[149]][_0xb260[77]]({raw:true})};return null})[_0xb260[40]](function(_0x3c94x42){if(_0x3c94x42){_0x3c94x3f= _[_0xb260[119]](_0x3c94x42,_0xb260[79]);var _0x3c94x43;var _0x3c94x44=squel[_0xb260[120]]();_0x3c94x44[_0xb260[122]](_0x3c94x3d[_0xb260[121]]);for(var _0x3c94x3c=0;_0x3c94x3c< _0x3c94x3e[_0xb260[59]];_0x3c94x3c+= 1){_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[123]]?_0x3c94x3f[_0x3c94x3e[_0x3c94x3c][_0xb260[123]]][_0xb260[124]]:_0x3c94x3e[_0x3c94x3c][_0xb260[115]];_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[125]]?_[_0xb260[127]](_0x3c94x35[_0x3c94x3e[_0x3c94x3c][_0xb260[125]]],_0xb260[126],_0x3c94x43):_0x3c94x43;_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[128]]?_[_0xb260[127]](_0x3c94x36[_0x3c94x3e[_0x3c94x3c][_0xb260[128]]],_0xb260[126],_0x3c94x43):_0x3c94x43;if(_0x3c94x3e[_0x3c94x3c][_0xb260[129]]){_0x3c94x44[_0xb260[114]](_0x3c94x43)};_0x3c94x3e[_0x3c94x3c][_0xb260[130]]&& _0x3c94x44[_0xb260[62]](_0x3c94x43,_0x3c94x3e[_0x3c94x3c][_0xb260[130]]=== _0xb260[131]?false:true);_0x3c94x44[_0xb260[115]](_0x3c94x43,_0x3c94x3e[_0x3c94x3c][_0xb260[132]]|| _0x3c94x43)};if(_0x3c94x3d[_0xb260[133]]){_0x3c94x3d[_0xb260[133]]= JSON[_0xb260[134]](_0x3c94x3d[_0xb260[133]]);for(var _0x3c94x45=0;_0x3c94x45< _0x3c94x3d[_0xb260[133]][_0xb260[59]];_0x3c94x45+= 1){if(_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]]&& _[_0xb260[108]](_0x3c94x34,_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]])&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[136]]&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]]&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[138]]){_0x3c94x44[_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]]](_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]],null,util[_0xb260[128]](_0xb260[139],_0x3c94x3d[_0xb260[121]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[136]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[138]]))}}};if(_0x3c94x3d[_0xb260[140]]){_0x3c94x3d[_0xb260[140]]= JSON[_0xb260[134]](_0x3c94x3d[_0xb260[140]]);_0x3c94x44[_0xb260[64]](_0x3c94x39(_0x3c94x3d[_0xb260[140]][_0xb260[114]]))};_0x3c94x41= _0x3c94x44[_0xb260[141]]();_0x3c94x44[_0xb260[32]](_0x3c94x33);_0x3c94x44[_0xb260[31]](0);logger[_0xb260[143]](_0xb260[142],_0x3c94x44.toString());return db[_0xb260[146]][_0xb260[53]](_0x3c94x44.toString(),{type:db[_0xb260[146]][_0xb260[145]][_0xb260[144]]})}})[_0xb260[40]](function(_0x3c94x42){if(!_0x3c94x42[_0xb260[59]]){throw  new db[_0xb260[148]].ValidationError(_0xb260[164])};if(_0x3c94x48[_0xb260[157]]=== _0xb260[165]){return null};var _0x3c94x4b=_[_0xb260[68]](_0x3c94x48,{name:_0x3c94x48[_0xb260[166]]|| _0x3c94x48[_0xb260[45]]|| _0x3c94x3d[_0xb260[45]],basename:_0x3c94x4a,savename:util[_0xb260[128]](_0xb260[167],_0x3c94x48[_0xb260[45]]|| _0x3c94x3d[_0xb260[45]],require(_0xb260[169])[_0xb260[168]](4),_0x3c94x48[_0xb260[157]]|| _0xb260[170])});return db[_0xb260[171]][_0xb260[82]](_0x3c94x4b,{raw:true})})[_0xb260[40]](function(_0x3c94x1c){_0x3c94x41[_0xb260[64]](_0x3c94x3d[_0xb260[121]]+ _0xb260[151],_0x3c94x48[_0xb260[152]],_0x3c94x48[_0xb260[153]]);if(_0x3c94x1c){logger[_0xb260[155]](_0xb260[154],_0x3c94x41.toString());require(_0xb260[161])[_0xb260[160]](path[_0xb260[85]](__dirname,_0xb260[156],_0x3c94x1c[_0xb260[157]]),[_0x3c94x1c[_0xb260[79]],_0x3c94x41.toString(),path[_0xb260[85]](__dirname,_0xb260[158],_0x3c94x1c[_0xb260[159]]),_0x3c94x4a]);return _0x3c94x1c}else {var _0x3c94x44=squel[_0xb260[120]]();_0x3c94x44[_0xb260[122]](_0xb260[111]+ _0x3c94x41.toString()+ _0xb260[118],_0xb260[162]);_0x3c94x44[_0xb260[115]](_0xb260[163],_0xb260[30]);_0x3c94x41[_0xb260[32]](_0x3c94x48[_0xb260[32]]|| _0x3c94x33);_0x3c94x41[_0xb260[31]](_0x3c94x48[_0xb260[31]]|| 0);return db[_0xb260[146]][_0xb260[53]](_0x3c94x44.toString(),{type:db[_0xb260[146]][_0xb260[145]][_0xb260[144]]})[_0xb260[40]](function(_0x3c94x42){if(!_0x3c94x42[_0xb260[59]]){_0x3c94x40= 0}else {_0x3c94x40= _0x3c94x42[0][_0xb260[30]]|| 0};return db[_0xb260[146]][_0xb260[53]](_0x3c94x41.toString(),{type:db[_0xb260[146]][_0xb260[145]][_0xb260[144]]})})[_0xb260[40]](function(_0x3c94x42){return {rows:_0x3c94x42|| [],count:_0x3c94x40}})}})}exports[_0xb260[172]]= function(_0x3c94x2c,_0x3c94x1a){return runReport(_0x3c94x2c[_0xb260[80]],_0x3c94x2c[_0xb260[53]],_0x3c94x2c[_0xb260[72]])[_0xb260[40]](respondWithResult(_0x3c94x1a,null))[_0xb260[73]](handleError(_0x3c94x1a,null))};exports[_0xb260[173]]= runReport;exports[_0xb260[53]]= function(_0x3c94x2c,_0x3c94x1a){var _0x3c94x33=10;var _0x3c94x34=[_0xb260[85],_0xb260[86],_0xb260[87],_0xb260[88],_0xb260[89]];var _0x3c94x35={"\x53\x55\x4D":_0xb260[90],"\x43\x4F\x55\x4E\x54":_0xb260[91],"\x43\x4F\x55\x4E\x54\x20\x44\x49\x53\x54\x49\x4E\x43\x54":_0xb260[92],"\x4D\x41\x58":_0xb260[93],"\x4D\x49\x4E":_0xb260[94],"\x41\x56\x47":_0xb260[95],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54":_0xb260[96],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x20\x41\x53\x43":_0xb260[97],"\x47\x52\x4F\x55\x50\x5F\x43\x4F\x4E\x43\x41\x54\x20\x44\x45\x53\x43":_0xb260[98]};var _0x3c94x36={"\x53\x45\x43\x5F\x54\x4F\x5F\x54\x49\x4D\x45":_0xb260[99],"\x44\x41\x54\x45":_0xb260[100],"\x48\x4F\x55\x52":_0xb260[101],"\x52\x4F\x55\x4E\x44":_0xb260[102],"\x55\x4E\x49\x58\x5F\x54\x49\x4D\x45\x53\x54\x41\x4D\x50":_0xb260[103]};var _0x3c94x37=function(_0x3c94x38){return !_[_0xb260[108]]([_0xb260[104],_0xb260[105],_0xb260[106],_0xb260[107]],_0x3c94x38)};var _0x3c94x39=function(_0x3c94x3a){if(!_0x3c94x3a||  !_0x3c94x3a[_0xb260[109]][_0xb260[59]]){return _0xb260[110]};for(var _0x3c94x3b=_0xb260[111],_0x3c94x3c=0;_0x3c94x3c< _0x3c94x3a[_0xb260[109]][_0xb260[59]];_0x3c94x3c+= 1){_0x3c94x3c> 0&& (_0x3c94x3b+= _0xb260[112]+ _0x3c94x3a[_0xb260[113]]+ _0xb260[112]);_0x3c94x3b+= _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[114]]?_0x3c94x39(_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[114]]):_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[115]]+ _0xb260[112]+ _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[116]]+ (_0x3c94x37(_0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[116]])?_0xb260[112]+ _0x3c94x3a[_0xb260[109]][_0x3c94x3c][_0xb260[117]]:_0xb260[110])};return _0x3c94x3b+ _0xb260[118]};var _0x3c94x1f={where:{id:_0x3c94x2c[_0xb260[80]][_0xb260[79]]}},_0x3c94x3d,_0x3c94x3e,_0x3c94x3f,_0x3c94x40,_0x3c94x41;_0x3c94x1f= _[_0xb260[68]]({},_0x3c94x1f,_0x3c94x2c[_0xb260[72]]);return db[_0xb260[50]][_0xb260[81]](_0x3c94x1f)[_0xb260[40]](function(_0x3c94x1c){if(_0x3c94x1c){_0x3c94x3d= _0x3c94x1c;return _0x3c94x1c[_0xb260[150]]()};return null})[_0xb260[40]](function(_0x3c94x42){if(_0x3c94x42){if(!_0x3c94x42[_0xb260[59]]){throw  new db[_0xb260[148]].ValidationError(_0xb260[147])};_0x3c94x3e= _0x3c94x42;return db[_0xb260[149]][_0xb260[77]]({raw:true})};return null})[_0xb260[40]](function(_0x3c94x42){if(_0x3c94x42){_0x3c94x3f= _[_0xb260[119]](_0x3c94x42,_0xb260[79]);var _0x3c94x43;var _0x3c94x44=squel[_0xb260[120]]();_0x3c94x44[_0xb260[122]](_0x3c94x3d[_0xb260[121]]);for(var _0x3c94x3c=0;_0x3c94x3c< _0x3c94x3e[_0xb260[59]];_0x3c94x3c+= 1){_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[123]]?_0x3c94x3f[_0x3c94x3e[_0x3c94x3c][_0xb260[123]]][_0xb260[124]]:_0x3c94x3e[_0x3c94x3c][_0xb260[115]];_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[125]]?_[_0xb260[127]](_0x3c94x35[_0x3c94x3e[_0x3c94x3c][_0xb260[125]]],_0xb260[126],_0x3c94x43):_0x3c94x43;_0x3c94x43= _0x3c94x3e[_0x3c94x3c][_0xb260[128]]?_[_0xb260[127]](_0x3c94x36[_0x3c94x3e[_0x3c94x3c][_0xb260[128]]],_0xb260[126],_0x3c94x43):_0x3c94x43;if(_0x3c94x3e[_0x3c94x3c][_0xb260[129]]){_0x3c94x44[_0xb260[114]](_0x3c94x43)};_0x3c94x3e[_0x3c94x3c][_0xb260[130]]&& _0x3c94x44[_0xb260[62]](_0x3c94x43,_0x3c94x3e[_0x3c94x3c][_0xb260[130]]=== _0xb260[131]?false:true);_0x3c94x44[_0xb260[115]](_0x3c94x43,_0x3c94x3e[_0x3c94x3c][_0xb260[132]]|| _0x3c94x43)};if(_0x3c94x3d[_0xb260[133]]){_0x3c94x3d[_0xb260[133]]= JSON[_0xb260[134]](_0x3c94x3d[_0xb260[133]]);for(var _0x3c94x45=0;_0x3c94x45< _0x3c94x3d[_0xb260[133]][_0xb260[59]];_0x3c94x45+= 1){if(_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]]&& _[_0xb260[108]](_0x3c94x34,_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]])&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[136]]&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]]&& _0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[138]]){_0x3c94x44[_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[135]]](_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]],null,util[_0xb260[128]](_0xb260[139],_0x3c94x3d[_0xb260[121]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[136]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[137]],_0x3c94x3d[_0xb260[133]][_0x3c94x45][_0xb260[138]]))}}};if(_0x3c94x3d[_0xb260[140]]){_0x3c94x3d[_0xb260[140]]= JSON[_0xb260[134]](_0x3c94x3d[_0xb260[140]]);_0x3c94x44[_0xb260[64]](_0x3c94x39(_0x3c94x3d[_0xb260[140]][_0xb260[114]]))};_0x3c94x41= _0x3c94x44[_0xb260[141]]();_0x3c94x44[_0xb260[32]](_0x3c94x33);_0x3c94x44[_0xb260[31]](0);logger[_0xb260[143]](_0xb260[142],_0x3c94x44.toString());return db[_0xb260[146]][_0xb260[53]](_0x3c94x44.toString(),{type:db[_0xb260[146]][_0xb260[145]][_0xb260[144]]})}})[_0xb260[40]](function(){return {sql:_0x3c94x41.toString()}})[_0xb260[40]](respondWithResult(_0x3c94x1a,null))[_0xb260[73]](handleError(_0x3c94x1a,null))}