Built motion from commit (unavailable).|2.5.10
[motion2.git] / server / api / jscriptyProject / jscriptyProject.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0x8c2b=['writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','format','Content-type','download','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/license/util','../../mysqldb','sendStatus','end','json','count','offset','limit','status','Content-Range','apply','save','update','then','get','Projects','UserProfileResource','destroy','error','stack','name','send','index','map','JscriptyProject','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','order','where','pick','filter','merge','VIRTUAL','options','include','findAll','rows','keys','includeAll','find','catch','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','autoAssociation','clone','params','omit','createdAt','updatedAt','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getSessions','findOne','JscriptySessionReport','hasOwnProperty','nolimit','sort','ProjectId','getAnswers','JscriptyAnswerReport','fromCharCode','toString','indexOf','getSummary','startTime','starttime','parse','JscriptyQuestionReport','-createdAt','questionId','question','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','isEmpty','now'];(function(_0x337b3d,_0x1f01ef){var _0x3f215d=function(_0x4110af){while(--_0x4110af){_0x337b3d['push'](_0x337b3d['shift']());}};_0x3f215d(++_0x1f01ef);}(_0x8c2b,0x7e));var _0xb8c2=function(_0x4827a3,_0xb814c){_0x4827a3=_0x4827a3-0x0;var _0x6c6504=_0x8c2b[_0x4827a3];return _0x6c6504;};'use strict';var pdf=require(_0xb8c2('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xb8c2('0x1'));var zipdir=require(_0xb8c2('0x2'));var jsonpatch=require(_0xb8c2('0x3'));var rp=require(_0xb8c2('0x4'));var moment=require(_0xb8c2('0x5'));var BPromise=require(_0xb8c2('0x6'));var Mustache=require(_0xb8c2('0x7'));var util=require('util');var path=require(_0xb8c2('0x8'));var sox=require(_0xb8c2('0x9'));var csv=require(_0xb8c2('0xa'));var ejs=require(_0xb8c2('0xb'));var fs=require('fs');var _=require(_0xb8c2('0xc'));var squel=require('squel');var crypto=require(_0xb8c2('0xd'));var jsforce=require(_0xb8c2('0xe'));var deskjs=require(_0xb8c2('0xf'));var toCsv=require(_0xb8c2('0xa'));var querystring=require(_0xb8c2('0x10'));var Papa=require(_0xb8c2('0x11'));var Redis=require('ioredis');var authService=require(_0xb8c2('0x12'));var qs=require(_0xb8c2('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xb8c2('0x14'))(_0xb8c2('0x15'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0xb8c2('0x16'));var db=require(_0xb8c2('0x17'))['db'];function respondWithStatusCode(_0x5a6202,_0x3480d7){_0x3480d7=_0x3480d7||0xcc;return function(_0x1053b0){if(_0x1053b0){return _0x5a6202[_0xb8c2('0x18')](_0x3480d7);}return _0x5a6202['status'](_0x3480d7)[_0xb8c2('0x19')]();};}function respondWithResult(_0x13ebdf,_0x4c18ee){_0x4c18ee=_0x4c18ee||0xc8;return function(_0x5ea0ed){if(_0x5ea0ed){return _0x13ebdf['status'](_0x4c18ee)[_0xb8c2('0x1a')](_0x5ea0ed);}};}function respondWithFilteredResult(_0x1479ce,_0x2ffb74){return function(_0x5c7891){if(_0x5c7891){var _0x1b163b=_0x5c7891[_0xb8c2('0x1b')],_0x3c4b59=_0x2ffb74[_0xb8c2('0x1c')],_0x20e941=_0x2ffb74[_0xb8c2('0x1c')]+_0x2ffb74[_0xb8c2('0x1d')],_0x38a048;if(_0x20e941>=_0x1b163b){_0x20e941=_0x1b163b;_0x38a048=0xc8;}else{_0x38a048=0xce;}_0x1479ce[_0xb8c2('0x1e')](_0x38a048);return _0x1479ce['set'](_0xb8c2('0x1f'),_0x3c4b59+'-'+_0x20e941+'/'+_0x1b163b)[_0xb8c2('0x1a')](_0x5c7891);}return null;};}function patchUpdates(_0x4dd340){return function(_0x145bef){try{jsonpatch[_0xb8c2('0x20')](_0x145bef,_0x4dd340,!![]);}catch(_0x16eccf){return BPromise['reject'](_0x16eccf);}return _0x145bef[_0xb8c2('0x21')]();};}function saveUpdates(_0x3c5b38,_0x4a1423){return function(_0x45c286){if(_0x45c286){return _0x45c286[_0xb8c2('0x22')](_0x3c5b38)['then'](function(_0x35b05e){return _0x35b05e;});}return null;};}function removeEntity(_0x589b0c,_0xc80a8b){return function(_0x29f439){if(_0x29f439){return _0x29f439['destroy']()[_0xb8c2('0x23')](function(){var _0x1520a7=_0x29f439[_0xb8c2('0x24')]({'plain':!![]});var _0x530b85=_0xb8c2('0x25');return db[_0xb8c2('0x26')][_0xb8c2('0x27')]({'where':{'type':_0x530b85,'resourceId':_0x1520a7['id']}})[_0xb8c2('0x23')](function(){return _0x29f439;});})[_0xb8c2('0x23')](function(){_0x589b0c[_0xb8c2('0x1e')](0xcc)[_0xb8c2('0x19')]();});}};}function handleEntityNotFound(_0x298163,_0x74d296){return function(_0x3efe4d){if(!_0x3efe4d){_0x298163[_0xb8c2('0x18')](0x194);}return _0x3efe4d;};}function handleError(_0x2671ec,_0x292039){_0x292039=_0x292039||0x1f4;return function(_0x510424){logger[_0xb8c2('0x28')](_0x510424[_0xb8c2('0x29')]);if(_0x510424[_0xb8c2('0x2a')]){delete _0x510424['name'];}_0x2671ec['status'](_0x292039)[_0xb8c2('0x2b')](_0x510424);};}exports[_0xb8c2('0x2c')]=function(_0x5914c5,_0x3515fa){var _0x10bf76={},_0x5514bd={},_0x3efb75={'count':0x0,'rows':[]};var _0x225f61=_[_0xb8c2('0x2d')](db[_0xb8c2('0x2e')][_0xb8c2('0x2f')],function(_0x14a788){return{'name':_0x14a788[_0xb8c2('0x30')],'type':_0x14a788[_0xb8c2('0x31')][_0xb8c2('0x32')]};});_0x5514bd[_0xb8c2('0x33')]=_[_0xb8c2('0x2d')](_0x225f61,_0xb8c2('0x2a'));_0x5514bd['query']=_['keys'](_0x5914c5[_0xb8c2('0x34')]);_0x5514bd[_0xb8c2('0x35')]=_[_0xb8c2('0x36')](_0x5514bd[_0xb8c2('0x33')],_0x5514bd['query']);_0x10bf76[_0xb8c2('0x37')]=_[_0xb8c2('0x36')](_0x5514bd[_0xb8c2('0x33')],qs[_0xb8c2('0x38')](_0x5914c5[_0xb8c2('0x34')][_0xb8c2('0x38')]));_0x10bf76['attributes']=_0x10bf76[_0xb8c2('0x37')][_0xb8c2('0x39')]?_0x10bf76[_0xb8c2('0x37')]:_0x5514bd['model'];if(!_0x5914c5[_0xb8c2('0x34')]['hasOwnProperty']('nolimit')){_0x10bf76['limit']=qs[_0xb8c2('0x1d')](_0x5914c5['query'][_0xb8c2('0x1d')]);_0x10bf76[_0xb8c2('0x1c')]=qs[_0xb8c2('0x1c')](_0x5914c5[_0xb8c2('0x34')]['offset']);}_0x10bf76[_0xb8c2('0x3a')]=qs['sort'](_0x5914c5[_0xb8c2('0x34')]['sort']);_0x10bf76[_0xb8c2('0x3b')]=qs['filters'](_[_0xb8c2('0x3c')](_0x5914c5[_0xb8c2('0x34')],_0x5514bd[_0xb8c2('0x35')]),_0x225f61);if(_0x5914c5[_0xb8c2('0x34')][_0xb8c2('0x3d')]){_0x10bf76[_0xb8c2('0x3b')]=_[_0xb8c2('0x3e')](_0x10bf76[_0xb8c2('0x3b')],{'$or':_['map'](_0x225f61,function(_0x44b8f2){if(_0x44b8f2[_0xb8c2('0x31')]!==_0xb8c2('0x3f')){var _0x4aea56={};_0x4aea56[_0x44b8f2[_0xb8c2('0x2a')]]={'$like':'%'+_0x5914c5['query'][_0xb8c2('0x3d')]+'%'};return _0x4aea56;}})});}_0x10bf76=_[_0xb8c2('0x3e')]({},_0x10bf76,_0x5914c5[_0xb8c2('0x40')]);var _0x53f2a6={'where':_0x10bf76['where']};return db[_0xb8c2('0x2e')]['count'](_0x53f2a6)['then'](function(_0x2bae84){_0x3efb75[_0xb8c2('0x1b')]=_0x2bae84;if(_0x5914c5['query']['includeAll']){_0x10bf76[_0xb8c2('0x41')]=[{'all':!![]}];}return db[_0xb8c2('0x2e')][_0xb8c2('0x42')](_0x10bf76);})['then'](function(_0x5bc177){_0x3efb75[_0xb8c2('0x43')]=_0x5bc177;return _0x3efb75;})[_0xb8c2('0x23')](respondWithFilteredResult(_0x3515fa,_0x10bf76))['catch'](handleError(_0x3515fa,null));};exports['show']=function(_0x2ac2a0,_0x140930){var _0x299501={'raw':![],'where':{'id':_0x2ac2a0['params']['id']}},_0x412921={};_0x412921[_0xb8c2('0x33')]=_[_0xb8c2('0x44')](db['JscriptyProject'][_0xb8c2('0x2f')]);_0x412921[_0xb8c2('0x34')]=_['keys'](_0x2ac2a0['query']);_0x412921[_0xb8c2('0x35')]=_[_0xb8c2('0x36')](_0x412921[_0xb8c2('0x33')],_0x412921[_0xb8c2('0x34')]);_0x299501[_0xb8c2('0x37')]=_['intersection'](_0x412921[_0xb8c2('0x33')],qs[_0xb8c2('0x38')](_0x2ac2a0['query'][_0xb8c2('0x38')]));_0x299501[_0xb8c2('0x37')]=_0x299501[_0xb8c2('0x37')]['length']?_0x299501[_0xb8c2('0x37')]:_0x412921[_0xb8c2('0x33')];if(_0x2ac2a0[_0xb8c2('0x34')][_0xb8c2('0x45')]){_0x299501[_0xb8c2('0x41')]=[{'all':!![]}];}_0x299501=_[_0xb8c2('0x3e')]({},_0x299501,_0x2ac2a0[_0xb8c2('0x40')]);return db[_0xb8c2('0x2e')][_0xb8c2('0x46')](_0x299501)['then'](handleEntityNotFound(_0x140930,null))['then'](respondWithResult(_0x140930,null))[_0xb8c2('0x47')](handleError(_0x140930,null));};exports[_0xb8c2('0x48')]=function(_0x4ff7c9,_0x16cebb){return db[_0xb8c2('0x2e')][_0xb8c2('0x48')](_0x4ff7c9[_0xb8c2('0x49')],{})[_0xb8c2('0x23')](function(_0x2e0dbb){var _0x194078=_0x4ff7c9['user'][_0xb8c2('0x24')]({'plain':!![]});if(!_0x194078)throw new Error(_0xb8c2('0x4a'));if(_0x194078[_0xb8c2('0x4b')]===_0xb8c2('0x4c')){var _0x28f3e6=_0x2e0dbb[_0xb8c2('0x24')]({'plain':!![]});var _0x1ac249=_0xb8c2('0x25');return db[_0xb8c2('0x4d')][_0xb8c2('0x46')]({'where':{'name':_0x1ac249,'userProfileId':_0x194078[_0xb8c2('0x4e')]},'raw':!![]})[_0xb8c2('0x23')](function(_0x52b7c6){if(_0x52b7c6&&_0x52b7c6[_0xb8c2('0x4f')]===0x0){return db[_0xb8c2('0x26')]['create']({'name':_0x28f3e6[_0xb8c2('0x2a')],'resourceId':_0x28f3e6['id'],'type':_0x52b7c6['name'],'sectionId':_0x52b7c6['id']},{})[_0xb8c2('0x23')](function(){return _0x2e0dbb;});}else{return _0x2e0dbb;}})[_0xb8c2('0x47')](function(_0x39b217){logger[_0xb8c2('0x28')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x39b217);throw _0x39b217;});}return _0x2e0dbb;})[_0xb8c2('0x23')](respondWithResult(_0x16cebb,0xc9))[_0xb8c2('0x47')](handleError(_0x16cebb,null));};exports[_0xb8c2('0x50')]=function(_0xe7b59f,_0x482b69){var _0x33d4ed={'where':{'id':_0xe7b59f[_0xb8c2('0x51')]['id']}},_0x382aa5={};_0x382aa5['model']=_[_0xb8c2('0x44')](db['JscriptyProject'][_0xb8c2('0x2f')]);_0x33d4ed[_0xb8c2('0x37')]=_[_0xb8c2('0x36')](_0x382aa5[_0xb8c2('0x33')],qs['fields'](_0xe7b59f[_0xb8c2('0x34')][_0xb8c2('0x38')]));_0x33d4ed[_0xb8c2('0x37')]=_0x33d4ed[_0xb8c2('0x37')]['length']?_0x33d4ed[_0xb8c2('0x37')]:_0x382aa5[_0xb8c2('0x33')];if(_0xe7b59f[_0xb8c2('0x34')][_0xb8c2('0x45')]){_0x33d4ed[_0xb8c2('0x41')]=[{'all':!![]}];}_0x33d4ed=_[_0xb8c2('0x3e')]({},_0x33d4ed,_0xe7b59f[_0xb8c2('0x40')]);return db[_0xb8c2('0x2e')][_0xb8c2('0x46')](_0x33d4ed)[_0xb8c2('0x23')](handleEntityNotFound(_0x482b69,null))[_0xb8c2('0x23')](function(_0x14ace1){if(_0x14ace1){var _0x5d11fb=_0x14ace1[_0xb8c2('0x24')]({'plain':!![]});_0x5d11fb=qs[_0xb8c2('0x52')](_0x5d11fb,['id',_0xb8c2('0x53'),_0xb8c2('0x54')]);_0xe7b59f['body']=_[_0xb8c2('0x52')](_0xe7b59f[_0xb8c2('0x49')],['id',_0xb8c2('0x53'),'updatedAt']);return db[_0xb8c2('0x2e')][_0xb8c2('0x48')](_['merge'](_0x5d11fb,_0xe7b59f['body']),{'include':_0xe7b59f[_0xb8c2('0x34')][_0xb8c2('0x45')]?[{'all':!![]}]:undefined})['then'](function(_0x597a22){var _0x2e400b=_0xe7b59f[_0xb8c2('0x4c')][_0xb8c2('0x24')]({'plain':!![]});if(!_0x2e400b)throw new Error(_0xb8c2('0x4a'));if(_0x2e400b[_0xb8c2('0x4b')]===_0xb8c2('0x4c')){var _0x4134d4=_0x597a22[_0xb8c2('0x24')]({'plain':!![]});var _0x2edfd9=_0xb8c2('0x25');return db[_0xb8c2('0x4d')][_0xb8c2('0x46')]({'where':{'name':_0x2edfd9,'userProfileId':_0x2e400b[_0xb8c2('0x4e')]},'raw':!![]})[_0xb8c2('0x23')](function(_0x1e59fb){if(_0x1e59fb&&_0x1e59fb['autoAssociation']===0x0){return db['UserProfileResource'][_0xb8c2('0x48')]({'name':_0x4134d4[_0xb8c2('0x2a')],'resourceId':_0x4134d4['id'],'type':_0x1e59fb[_0xb8c2('0x2a')],'sectionId':_0x1e59fb['id']},{})[_0xb8c2('0x23')](function(){return _0x597a22;});}else{return _0x597a22;}})['catch'](function(_0x11458d){logger['error'](_0xb8c2('0x55'),_0x11458d);throw _0x11458d;});}return _0x597a22;});}})[_0xb8c2('0x23')](respondWithResult(_0x482b69,0xc9))[_0xb8c2('0x47')](handleError(_0x482b69,null));};exports['update']=function(_0x99aceb,_0x2ac108){if(_0x99aceb[_0xb8c2('0x49')]['id']){delete _0x99aceb[_0xb8c2('0x49')]['id'];}return db['JscriptyProject'][_0xb8c2('0x46')]({'where':{'id':_0x99aceb[_0xb8c2('0x51')]['id']}})[_0xb8c2('0x23')](handleEntityNotFound(_0x2ac108,null))[_0xb8c2('0x23')](saveUpdates(_0x99aceb[_0xb8c2('0x49')],null))[_0xb8c2('0x23')](respondWithResult(_0x2ac108,null))[_0xb8c2('0x47')](handleError(_0x2ac108,null));};exports[_0xb8c2('0x27')]=function(_0x39a633,_0x5e78f2){return db[_0xb8c2('0x2e')][_0xb8c2('0x46')]({'where':{'id':_0x39a633['params']['id']}})[_0xb8c2('0x23')](handleEntityNotFound(_0x5e78f2,null))[_0xb8c2('0x23')](removeEntity(_0x5e78f2,null))[_0xb8c2('0x47')](handleError(_0x5e78f2,null));};exports[_0xb8c2('0x56')]=function(_0x35fb6d,_0x43277a,_0x19a8d0){var _0x57088c={'raw':!![],'where':{}};var _0x534ad7={};var _0x4a8bca={'count':0x0,'rows':[]};return db[_0xb8c2('0x2e')][_0xb8c2('0x57')]({'where':{'id':_0x35fb6d['params']['id']}})[_0xb8c2('0x23')](handleEntityNotFound(_0x43277a,null))['then'](function(_0x4dfa68){if(_0x4dfa68){_0x534ad7[_0xb8c2('0x33')]=_[_0xb8c2('0x44')](db[_0xb8c2('0x58')][_0xb8c2('0x2f')]);_0x534ad7['query']=_[_0xb8c2('0x44')](_0x35fb6d[_0xb8c2('0x34')]);_0x534ad7[_0xb8c2('0x35')]=_[_0xb8c2('0x36')](_0x534ad7[_0xb8c2('0x33')],_0x534ad7[_0xb8c2('0x34')]);_0x57088c[_0xb8c2('0x37')]=_[_0xb8c2('0x36')](_0x534ad7['model'],qs[_0xb8c2('0x38')](_0x35fb6d[_0xb8c2('0x34')][_0xb8c2('0x38')]));_0x57088c[_0xb8c2('0x37')]=_0x57088c[_0xb8c2('0x37')]['length']?_0x57088c[_0xb8c2('0x37')]:_0x534ad7[_0xb8c2('0x33')];if(!_0x35fb6d[_0xb8c2('0x34')][_0xb8c2('0x59')](_0xb8c2('0x5a'))){_0x57088c[_0xb8c2('0x1d')]=qs['limit'](_0x35fb6d[_0xb8c2('0x34')][_0xb8c2('0x1d')]);_0x57088c[_0xb8c2('0x1c')]=qs[_0xb8c2('0x1c')](_0x35fb6d['query'][_0xb8c2('0x1c')]);}_0x57088c[_0xb8c2('0x3a')]=qs[_0xb8c2('0x5b')](_0x35fb6d[_0xb8c2('0x34')][_0xb8c2('0x5b')]);_0x57088c[_0xb8c2('0x3b')]=qs['filters'](_[_0xb8c2('0x3c')](_0x35fb6d[_0xb8c2('0x34')],_0x534ad7[_0xb8c2('0x35')]));_0x57088c[_0xb8c2('0x3b')][_0xb8c2('0x5c')]=_0x4dfa68['id'];if(_0x35fb6d['query']['filter']){_0x57088c[_0xb8c2('0x3b')]=_[_0xb8c2('0x3e')](_0x57088c['where'],{'$or':_[_0xb8c2('0x2d')](_0x57088c[_0xb8c2('0x37')],function(_0x9ddac4){var _0x1835fa={};_0x1835fa[_0x9ddac4]={'$like':'%'+_0x35fb6d[_0xb8c2('0x34')][_0xb8c2('0x3d')]+'%'};return _0x1835fa;})});}_0x57088c=_[_0xb8c2('0x3e')]({},_0x57088c,_0x35fb6d['options']);return db[_0xb8c2('0x58')][_0xb8c2('0x1b')]({'where':_0x57088c[_0xb8c2('0x3b')]})[_0xb8c2('0x23')](function(_0x24add2){_0x4a8bca[_0xb8c2('0x1b')]=_0x24add2;if(_0x35fb6d[_0xb8c2('0x34')][_0xb8c2('0x45')]){_0x57088c[_0xb8c2('0x41')]=[{'all':!![]}];}return db[_0xb8c2('0x58')][_0xb8c2('0x42')](_0x57088c);})[_0xb8c2('0x23')](function(_0x28436f){_0x4a8bca['rows']=_0x28436f;return _0x4a8bca;});}})['then'](respondWithFilteredResult(_0x43277a,_0x57088c))[_0xb8c2('0x47')](handleError(_0x43277a,null));};exports[_0xb8c2('0x5d')]=function(_0x5e46f7,_0x20de7e,_0x32a0ff){var _0x24f6e5={'raw':!![],'where':{}};var _0x46aeb8={};var _0x555a16={'count':0x0,'rows':[]};return db[_0xb8c2('0x2e')][_0xb8c2('0x57')]({'where':{'id':_0x5e46f7[_0xb8c2('0x51')]['id']}})[_0xb8c2('0x23')](handleEntityNotFound(_0x20de7e,null))[_0xb8c2('0x23')](function(_0x4ab9b6){if(_0x4ab9b6){_0x46aeb8[_0xb8c2('0x33')]=_[_0xb8c2('0x44')](db['JscriptyAnswerReport'][_0xb8c2('0x2f')]);_0x46aeb8['query']=_[_0xb8c2('0x44')](_0x5e46f7[_0xb8c2('0x34')]);_0x46aeb8[_0xb8c2('0x35')]=_[_0xb8c2('0x36')](_0x46aeb8[_0xb8c2('0x33')],_0x46aeb8[_0xb8c2('0x34')]);_0x24f6e5[_0xb8c2('0x37')]=_['intersection'](_0x46aeb8[_0xb8c2('0x33')],qs[_0xb8c2('0x38')](_0x5e46f7[_0xb8c2('0x34')][_0xb8c2('0x38')]));_0x24f6e5[_0xb8c2('0x37')]=_0x24f6e5[_0xb8c2('0x37')][_0xb8c2('0x39')]?_0x24f6e5[_0xb8c2('0x37')]:_0x46aeb8[_0xb8c2('0x33')];if(!_0x5e46f7[_0xb8c2('0x34')][_0xb8c2('0x59')]('nolimit')){_0x24f6e5[_0xb8c2('0x1d')]=qs[_0xb8c2('0x1d')](_0x5e46f7[_0xb8c2('0x34')]['limit']);_0x24f6e5[_0xb8c2('0x1c')]=qs[_0xb8c2('0x1c')](_0x5e46f7[_0xb8c2('0x34')][_0xb8c2('0x1c')]);}_0x24f6e5[_0xb8c2('0x3a')]=qs[_0xb8c2('0x5b')](_0x5e46f7[_0xb8c2('0x34')]['sort']);_0x24f6e5[_0xb8c2('0x3b')]=qs[_0xb8c2('0x35')](_[_0xb8c2('0x3c')](_0x5e46f7['query'],_0x46aeb8[_0xb8c2('0x35')]));_0x24f6e5['where'][_0xb8c2('0x5c')]=_0x4ab9b6['id'];if(_0x5e46f7[_0xb8c2('0x34')][_0xb8c2('0x3d')]){_0x24f6e5[_0xb8c2('0x3b')]=_[_0xb8c2('0x3e')](_0x24f6e5['where'],{'$or':_[_0xb8c2('0x2d')](_0x24f6e5[_0xb8c2('0x37')],function(_0x5c3bd7){var _0x556168={};_0x556168[_0x5c3bd7]={'$like':'%'+_0x5e46f7[_0xb8c2('0x34')][_0xb8c2('0x3d')]+'%'};return _0x556168;})});}_0x24f6e5=_['merge']({},_0x24f6e5,_0x5e46f7['options']);return db[_0xb8c2('0x5e')][_0xb8c2('0x1b')]({'where':_0x24f6e5['where']})[_0xb8c2('0x23')](function(_0x3de475){_0x555a16[_0xb8c2('0x1b')]=_0x3de475;if(_0x5e46f7[_0xb8c2('0x34')][_0xb8c2('0x45')]){_0x24f6e5['include']=[{'all':!![]}];}return db[_0xb8c2('0x5e')][_0xb8c2('0x42')](_0x24f6e5);})['then'](function(_0x488807){_0x555a16[_0xb8c2('0x43')]=_0x488807;return _0x555a16;});}})[_0xb8c2('0x23')](respondWithFilteredResult(_0x20de7e,_0x24f6e5))[_0xb8c2('0x47')](handleError(_0x20de7e,null));};function char(_0x425ba0){return'number'===typeof _0x425ba0?String[_0xb8c2('0x5f')][_0xb8c2('0x20')](null,arguments):_0x425ba0;}function needsEncapsulation(_0x168585){return!!_0x168585&&(_0x168585[_0xb8c2('0x60')]()[_0xb8c2('0x61')](char(0xd))>=0x0||_0x168585[_0xb8c2('0x60')]()[_0xb8c2('0x61')](char(0xa))>=0x0||_0x168585[_0xb8c2('0x60')]()[_0xb8c2('0x61')](char(0x2c))>=0x0||_0x168585[_0xb8c2('0x60')]()[_0xb8c2('0x61')](char(0x22))>=0x0);}function encapsulate(_0x2b1a5a){var _0x1f39f0=char(0x22),_0x265961='\x5c'+char(0x22),_0x5945a4=_0x2b1a5a['toString']()['replace'](new RegExp(_0x1f39f0,'g'),_0x265961);return _0x1f39f0+_0x5945a4+_0x1f39f0;}exports[_0xb8c2('0x62')]=function(_0x53c110,_0x1600a9,_0x3c9b37){var _0x50eea3,_0x1c428d;var _0x433316={'where':{'ProjectId':_0x53c110[_0xb8c2('0x51')]['id']}};if(_0x53c110[_0xb8c2('0x34')][_0xb8c2('0x63')]){_0x433316[_0xb8c2('0x3b')][_0xb8c2('0x64')]=JSON[_0xb8c2('0x65')](_0x53c110[_0xb8c2('0x34')][_0xb8c2('0x63')]);}return db[_0xb8c2('0x58')][_0xb8c2('0x42')](_0x433316)['then'](handleEntityNotFound(_0x1600a9,null))[_0xb8c2('0x23')](function(_0x445b31){if(_0x445b31){_0x50eea3=_0x445b31;return db[_0xb8c2('0x66')][_0xb8c2('0x42')]({'where':{'SessionId':{'$in':_[_0xb8c2('0x2d')](_0x50eea3,'id')},'ProjectId':_0x53c110['params']['id']},'order':_0xb8c2('0x67')});}})['then'](handleEntityNotFound(_0x1600a9,null))[_0xb8c2('0x23')](function(_0x3bff8a){if(_0x3bff8a){_0x1c428d=_0x3bff8a;var _0x484053={};for(var _0x426cd0=0x0,_0x212c8f=_0x1c428d[_0xb8c2('0x39')];_0x426cd0<_0x212c8f;_0x426cd0++){if(!_0x484053[_0xb8c2('0x59')](_0x1c428d[_0x426cd0][_0xb8c2('0x68')])){_0x484053[_0x1c428d[_0x426cd0][_0xb8c2('0x68')]]=needsEncapsulation(_0x1c428d[_0x426cd0][_0xb8c2('0x69')])?encapsulate(_0x1c428d[_0x426cd0][_0xb8c2('0x69')]):_0x1c428d[_0x426cd0][_0xb8c2('0x69')];}}var _0x371eca=[],_0x14c17a={};for(var _0x58666d=0x0,_0x1c6a01=_0x50eea3['length'];_0x58666d<_0x1c6a01;_0x58666d++){_0x14c17a={'ProjectId':_0x53c110[_0xb8c2('0x51')]['id'],'SessionId':_0x50eea3[_0x58666d]['id'],'StartTime':moment(_0x50eea3[_0x58666d][_0xb8c2('0x64')])['format'](_0xb8c2('0x6a'))};for(var _0x2d9883=0x0,_0x3c9928=_0x1c428d['length'];_0x2d9883<_0x3c9928;_0x2d9883++){if(_0x1c428d[_0x2d9883][_0xb8c2('0x6b')]==_0x50eea3[_0x58666d]['id']&&_0x484053[_0xb8c2('0x59')](_0x1c428d[_0x2d9883][_0xb8c2('0x68')])){_0x14c17a[_0x484053[_0x1c428d[_0x2d9883][_0xb8c2('0x68')]]]=_0x1c428d[_0x2d9883][_0xb8c2('0x6c')];}}for(var _0x142b15 in _0x484053){if(!_0x14c17a['hasOwnProperty'](_0x484053[_0x142b15])){_0x14c17a[_0x484053[_0x142b15]]=null;}}_0x371eca[_0xb8c2('0x6d')](_0x14c17a);}return _0x371eca;}})[_0xb8c2('0x23')](function(_0xa532fa){if(!_[_0xb8c2('0x6e')](_0xa532fa)){var _0x1ba9fa=toCsv(_0xa532fa);var _0x2233d7=Date[_0xb8c2('0x6f')]();fs[_0xb8c2('0x70')](util['format'](_0xb8c2('0x71'),_0x53c110[_0xb8c2('0x51')]['id'],_0x2233d7),_0x1ba9fa);_0x1600a9[_0xb8c2('0x72')](_0xb8c2('0x73'),'attachment;\x20filename='+util[_0xb8c2('0x74')]('Jscripty_Project_%d_Summary_%s.csv',_0x53c110[_0xb8c2('0x51')]['id'],_0x2233d7));_0x1600a9[_0xb8c2('0x72')](_0xb8c2('0x75'),'text/csv');return _0x1600a9[_0xb8c2('0x76')](util[_0xb8c2('0x74')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x53c110[_0xb8c2('0x51')]['id'],_0x2233d7));}else{return _0x1600a9['sendStatus'](0xcc);}})[_0xb8c2('0x47')](handleError(_0x1600a9,null));};