Built motion from commit (unavailable).|2.5.4
[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 _0x2421=['answer','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','html-pdf','eml-format','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject','save','update','then','destroy','get','Projects','UserProfileResource','error','name','send','map','JscriptyProject','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','include','rows','catch','show','rawAttributes','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','omit','createdAt','updatedAt','getSessions','findOne','JscriptySessionReport','ProjectId','findAll','JscriptyAnswerReport','number','fromCharCode','toString','indexOf','replace','getSummary','startTime','starttime','questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','SessionId'];(function(_0x453fcd,_0x4608bb){var _0x14c9dc=function(_0x534c7a){while(--_0x534c7a){_0x453fcd['push'](_0x453fcd['shift']());}};_0x14c9dc(++_0x4608bb);}(_0x2421,0x165));var _0x1242=function(_0x59c49e,_0x5731ff){_0x59c49e=_0x59c49e-0x0;var _0x62521b=_0x2421[_0x59c49e];return _0x62521b;};'use strict';var pdf=require(_0x1242('0x0'));var emlformat=require(_0x1242('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x1242('0x2'));var rp=require(_0x1242('0x3'));var moment=require(_0x1242('0x4'));var BPromise=require(_0x1242('0x5'));var Mustache=require(_0x1242('0x6'));var util=require(_0x1242('0x7'));var path=require(_0x1242('0x8'));var sox=require('sox');var csv=require(_0x1242('0x9'));var ejs=require(_0x1242('0xa'));var fs=require('fs');var _=require(_0x1242('0xb'));var squel=require(_0x1242('0xc'));var crypto=require(_0x1242('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x1242('0xe'));var toCsv=require('to-csv');var querystring=require(_0x1242('0xf'));var Papa=require(_0x1242('0x10'));var Redis=require(_0x1242('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x1242('0x12'));var as=require(_0x1242('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x1242('0x14'))(_0x1242('0x15'));var utils=require(_0x1242('0x16'));var config=require(_0x1242('0x17'));var db=require(_0x1242('0x18'))['db'];function respondWithStatusCode(_0x19b500,_0x4095d6){_0x4095d6=_0x4095d6||0xcc;return function(_0x154f58){if(_0x154f58){return _0x19b500[_0x1242('0x19')](_0x4095d6);}return _0x19b500[_0x1242('0x1a')](_0x4095d6)[_0x1242('0x1b')]();};}function respondWithResult(_0x2221ad,_0x2f168d){_0x2f168d=_0x2f168d||0xc8;return function(_0x272e98){if(_0x272e98){return _0x2221ad['status'](_0x2f168d)[_0x1242('0x1c')](_0x272e98);}};}function respondWithFilteredResult(_0x14ebdb,_0x1431ef){return function(_0x905150){if(_0x905150){var _0x40251a=_0x905150[_0x1242('0x1d')],_0x38cf8e=_0x1431ef['offset'],_0xeb47d3=_0x1431ef[_0x1242('0x1e')]+_0x1431ef[_0x1242('0x1f')],_0x3175af;if(_0xeb47d3>=_0x40251a){_0xeb47d3=_0x40251a;_0x3175af=0xc8;}else{_0x3175af=0xce;}_0x14ebdb['status'](_0x3175af);return _0x14ebdb['set'](_0x1242('0x20'),_0x38cf8e+'-'+_0xeb47d3+'/'+_0x40251a)[_0x1242('0x1c')](_0x905150);}return null;};}function patchUpdates(_0x504287){return function(_0x400451){try{jsonpatch[_0x1242('0x21')](_0x400451,_0x504287,!![]);}catch(_0x360ce4){return BPromise[_0x1242('0x22')](_0x360ce4);}return _0x400451[_0x1242('0x23')]();};}function saveUpdates(_0x2c36fd,_0x204d77){return function(_0x4a539e){if(_0x4a539e){return _0x4a539e[_0x1242('0x24')](_0x2c36fd)[_0x1242('0x25')](function(_0x5d0440){return _0x5d0440;});}return null;};}function removeEntity(_0x50faea,_0x2995a8){return function(_0x3a1dd4){if(_0x3a1dd4){return _0x3a1dd4[_0x1242('0x26')]()[_0x1242('0x25')](function(){var _0x2f56bd=_0x3a1dd4[_0x1242('0x27')]({'plain':!![]});var _0x42706c=_0x1242('0x28');return db[_0x1242('0x29')][_0x1242('0x26')]({'where':{'type':_0x42706c,'resourceId':_0x2f56bd['id']}})[_0x1242('0x25')](function(){return _0x3a1dd4;});})[_0x1242('0x25')](function(){_0x50faea[_0x1242('0x1a')](0xcc)[_0x1242('0x1b')]();});}};}function handleEntityNotFound(_0x26af68,_0x5dd126){return function(_0x5897c2){if(!_0x5897c2){_0x26af68['sendStatus'](0x194);}return _0x5897c2;};}function handleError(_0x189e9f,_0x5df77c){_0x5df77c=_0x5df77c||0x1f4;return function(_0x4d9602){logger[_0x1242('0x2a')](_0x4d9602['stack']);if(_0x4d9602[_0x1242('0x2b')]){delete _0x4d9602[_0x1242('0x2b')];}_0x189e9f['status'](_0x5df77c)[_0x1242('0x2c')](_0x4d9602);};}exports['index']=function(_0x337b93,_0x340672){var _0x103142={},_0x5d5df7={},_0x1651d7={'count':0x0,'rows':[]};var _0x18ae03=_[_0x1242('0x2d')](db[_0x1242('0x2e')]['rawAttributes'],function(_0x1d7c32){return{'name':_0x1d7c32['fieldName'],'type':_0x1d7c32[_0x1242('0x2f')][_0x1242('0x30')]};});_0x5d5df7[_0x1242('0x31')]=_[_0x1242('0x2d')](_0x18ae03,_0x1242('0x2b'));_0x5d5df7[_0x1242('0x32')]=_[_0x1242('0x33')](_0x337b93[_0x1242('0x32')]);_0x5d5df7['filters']=_[_0x1242('0x34')](_0x5d5df7[_0x1242('0x31')],_0x5d5df7[_0x1242('0x32')]);_0x103142[_0x1242('0x35')]=_[_0x1242('0x34')](_0x5d5df7[_0x1242('0x31')],qs[_0x1242('0x36')](_0x337b93[_0x1242('0x32')][_0x1242('0x36')]));_0x103142['attributes']=_0x103142[_0x1242('0x35')][_0x1242('0x37')]?_0x103142[_0x1242('0x35')]:_0x5d5df7['model'];if(!_0x337b93[_0x1242('0x32')][_0x1242('0x38')](_0x1242('0x39'))){_0x103142[_0x1242('0x1f')]=qs[_0x1242('0x1f')](_0x337b93[_0x1242('0x32')][_0x1242('0x1f')]);_0x103142[_0x1242('0x1e')]=qs[_0x1242('0x1e')](_0x337b93['query'][_0x1242('0x1e')]);}_0x103142[_0x1242('0x3a')]=qs[_0x1242('0x3b')](_0x337b93['query']['sort']);_0x103142[_0x1242('0x3c')]=qs[_0x1242('0x3d')](_[_0x1242('0x3e')](_0x337b93[_0x1242('0x32')],_0x5d5df7[_0x1242('0x3d')]),_0x18ae03);if(_0x337b93[_0x1242('0x32')][_0x1242('0x3f')]){_0x103142[_0x1242('0x3c')]=_[_0x1242('0x40')](_0x103142[_0x1242('0x3c')],{'$or':_[_0x1242('0x2d')](_0x18ae03,function(_0x3d7f3a){if(_0x3d7f3a['type']!==_0x1242('0x41')){var _0x314f8b={};_0x314f8b[_0x3d7f3a['name']]={'$like':'%'+_0x337b93['query'][_0x1242('0x3f')]+'%'};return _0x314f8b;}})});}_0x103142=_[_0x1242('0x40')]({},_0x103142,_0x337b93[_0x1242('0x42')]);var _0x81ce93={'where':_0x103142[_0x1242('0x3c')]};return db[_0x1242('0x2e')][_0x1242('0x1d')](_0x81ce93)[_0x1242('0x25')](function(_0x505d94){_0x1651d7[_0x1242('0x1d')]=_0x505d94;if(_0x337b93[_0x1242('0x32')][_0x1242('0x43')]){_0x103142[_0x1242('0x44')]=[{'all':!![]}];}return db[_0x1242('0x2e')]['findAll'](_0x103142);})[_0x1242('0x25')](function(_0x3b6462){_0x1651d7[_0x1242('0x45')]=_0x3b6462;return _0x1651d7;})['then'](respondWithFilteredResult(_0x340672,_0x103142))[_0x1242('0x46')](handleError(_0x340672,null));};exports[_0x1242('0x47')]=function(_0x1c2ddc,_0x290c2e){var _0xb94cd={'raw':![],'where':{'id':_0x1c2ddc['params']['id']}},_0x5473f9={};_0x5473f9[_0x1242('0x31')]=_[_0x1242('0x33')](db[_0x1242('0x2e')][_0x1242('0x48')]);_0x5473f9[_0x1242('0x32')]=_[_0x1242('0x33')](_0x1c2ddc[_0x1242('0x32')]);_0x5473f9[_0x1242('0x3d')]=_[_0x1242('0x34')](_0x5473f9[_0x1242('0x31')],_0x5473f9[_0x1242('0x32')]);_0xb94cd[_0x1242('0x35')]=_[_0x1242('0x34')](_0x5473f9[_0x1242('0x31')],qs[_0x1242('0x36')](_0x1c2ddc['query'][_0x1242('0x36')]));_0xb94cd['attributes']=_0xb94cd[_0x1242('0x35')]['length']?_0xb94cd[_0x1242('0x35')]:_0x5473f9[_0x1242('0x31')];if(_0x1c2ddc[_0x1242('0x32')][_0x1242('0x43')]){_0xb94cd['include']=[{'all':!![]}];}_0xb94cd=_[_0x1242('0x40')]({},_0xb94cd,_0x1c2ddc[_0x1242('0x42')]);return db[_0x1242('0x2e')][_0x1242('0x49')](_0xb94cd)[_0x1242('0x25')](handleEntityNotFound(_0x290c2e,null))[_0x1242('0x25')](respondWithResult(_0x290c2e,null))[_0x1242('0x46')](handleError(_0x290c2e,null));};exports[_0x1242('0x4a')]=function(_0x3709fd,_0x53f9a8){return db[_0x1242('0x2e')][_0x1242('0x4a')](_0x3709fd[_0x1242('0x4b')],{})[_0x1242('0x25')](function(_0x17ce0f){var _0x1590f7=_0x3709fd[_0x1242('0x4c')][_0x1242('0x27')]({'plain':!![]});if(!_0x1590f7)throw new Error(_0x1242('0x4d'));if(_0x1590f7[_0x1242('0x4e')]==='user'){var _0x314bb1=_0x17ce0f[_0x1242('0x27')]({'plain':!![]});var _0x4e2583=_0x1242('0x28');return db[_0x1242('0x4f')]['find']({'where':{'name':_0x4e2583,'userProfileId':_0x1590f7[_0x1242('0x50')]},'raw':!![]})[_0x1242('0x25')](function(_0x5374b6){if(_0x5374b6&&_0x5374b6[_0x1242('0x51')]===0x0){return db[_0x1242('0x29')][_0x1242('0x4a')]({'name':_0x314bb1['name'],'resourceId':_0x314bb1['id'],'type':_0x5374b6[_0x1242('0x2b')],'sectionId':_0x5374b6['id']},{})['then'](function(){return _0x17ce0f;});}else{return _0x17ce0f;}})[_0x1242('0x46')](function(_0x3fffdf){logger[_0x1242('0x2a')](_0x1242('0x52'),_0x3fffdf);throw _0x3fffdf;});}return _0x17ce0f;})['then'](respondWithResult(_0x53f9a8,0xc9))[_0x1242('0x46')](handleError(_0x53f9a8,null));};exports[_0x1242('0x53')]=function(_0x2c030a,_0x1e2a94){var _0x5f0905={'where':{'id':_0x2c030a[_0x1242('0x54')]['id']}},_0x38cebf={};_0x38cebf[_0x1242('0x31')]=_[_0x1242('0x33')](db[_0x1242('0x2e')][_0x1242('0x48')]);_0x5f0905[_0x1242('0x35')]=_[_0x1242('0x34')](_0x38cebf[_0x1242('0x31')],qs[_0x1242('0x36')](_0x2c030a['query']['fields']));_0x5f0905['attributes']=_0x5f0905[_0x1242('0x35')][_0x1242('0x37')]?_0x5f0905[_0x1242('0x35')]:_0x38cebf[_0x1242('0x31')];if(_0x2c030a['query'][_0x1242('0x43')]){_0x5f0905['include']=[{'all':!![]}];}_0x5f0905=_[_0x1242('0x40')]({},_0x5f0905,_0x2c030a[_0x1242('0x42')]);return db[_0x1242('0x2e')][_0x1242('0x49')](_0x5f0905)[_0x1242('0x25')](handleEntityNotFound(_0x1e2a94,null))[_0x1242('0x25')](function(_0x1c0a2e){if(_0x1c0a2e){var _0x3fa338=_0x1c0a2e[_0x1242('0x27')]({'plain':!![]});_0x3fa338=qs[_0x1242('0x55')](_0x3fa338,['id',_0x1242('0x56'),_0x1242('0x57')]);_0x2c030a['body']=_[_0x1242('0x55')](_0x2c030a[_0x1242('0x4b')],['id','createdAt','updatedAt']);return db[_0x1242('0x2e')][_0x1242('0x4a')](_[_0x1242('0x40')](_0x3fa338,_0x2c030a[_0x1242('0x4b')]),{'include':_0x2c030a[_0x1242('0x32')][_0x1242('0x43')]?[{'all':!![]}]:undefined})['then'](function(_0x181112){var _0x532799=_0x2c030a[_0x1242('0x4c')][_0x1242('0x27')]({'plain':!![]});if(!_0x532799)throw new Error(_0x1242('0x4d'));if(_0x532799['role']===_0x1242('0x4c')){var _0x2445a0=_0x181112[_0x1242('0x27')]({'plain':!![]});var _0x10bc2d='Projects';return db[_0x1242('0x4f')]['find']({'where':{'name':_0x10bc2d,'userProfileId':_0x532799['userProfileId']},'raw':!![]})[_0x1242('0x25')](function(_0x3b6db5){if(_0x3b6db5&&_0x3b6db5[_0x1242('0x51')]===0x0){return db['UserProfileResource'][_0x1242('0x4a')]({'name':_0x2445a0[_0x1242('0x2b')],'resourceId':_0x2445a0['id'],'type':_0x3b6db5[_0x1242('0x2b')],'sectionId':_0x3b6db5['id']},{})[_0x1242('0x25')](function(){return _0x181112;});}else{return _0x181112;}})[_0x1242('0x46')](function(_0x51406e){logger[_0x1242('0x2a')](_0x1242('0x52'),_0x51406e);throw _0x51406e;});}return _0x181112;});}})[_0x1242('0x25')](respondWithResult(_0x1e2a94,0xc9))['catch'](handleError(_0x1e2a94,null));};exports['update']=function(_0x484183,_0x5d82c9){if(_0x484183[_0x1242('0x4b')]['id']){delete _0x484183[_0x1242('0x4b')]['id'];}return db[_0x1242('0x2e')][_0x1242('0x49')]({'where':{'id':_0x484183[_0x1242('0x54')]['id']}})[_0x1242('0x25')](handleEntityNotFound(_0x5d82c9,null))['then'](saveUpdates(_0x484183[_0x1242('0x4b')],null))[_0x1242('0x25')](respondWithResult(_0x5d82c9,null))[_0x1242('0x46')](handleError(_0x5d82c9,null));};exports[_0x1242('0x26')]=function(_0x3757d2,_0x2ce935){return db[_0x1242('0x2e')][_0x1242('0x49')]({'where':{'id':_0x3757d2['params']['id']}})[_0x1242('0x25')](handleEntityNotFound(_0x2ce935,null))['then'](removeEntity(_0x2ce935,null))[_0x1242('0x46')](handleError(_0x2ce935,null));};exports[_0x1242('0x58')]=function(_0x3d28d5,_0x2f554e,_0x2e5cbf){var _0x3d1c71={'raw':!![],'where':{}};var _0x4c2663={};var _0x5b0bdc={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x1242('0x59')]({'where':{'id':_0x3d28d5['params']['id']}})[_0x1242('0x25')](handleEntityNotFound(_0x2f554e,null))['then'](function(_0x325a5b){if(_0x325a5b){_0x4c2663[_0x1242('0x31')]=_[_0x1242('0x33')](db[_0x1242('0x5a')][_0x1242('0x48')]);_0x4c2663['query']=_[_0x1242('0x33')](_0x3d28d5[_0x1242('0x32')]);_0x4c2663[_0x1242('0x3d')]=_[_0x1242('0x34')](_0x4c2663[_0x1242('0x31')],_0x4c2663['query']);_0x3d1c71[_0x1242('0x35')]=_[_0x1242('0x34')](_0x4c2663[_0x1242('0x31')],qs[_0x1242('0x36')](_0x3d28d5[_0x1242('0x32')][_0x1242('0x36')]));_0x3d1c71[_0x1242('0x35')]=_0x3d1c71['attributes']['length']?_0x3d1c71[_0x1242('0x35')]:_0x4c2663['model'];if(!_0x3d28d5[_0x1242('0x32')][_0x1242('0x38')](_0x1242('0x39'))){_0x3d1c71[_0x1242('0x1f')]=qs[_0x1242('0x1f')](_0x3d28d5[_0x1242('0x32')][_0x1242('0x1f')]);_0x3d1c71[_0x1242('0x1e')]=qs[_0x1242('0x1e')](_0x3d28d5[_0x1242('0x32')][_0x1242('0x1e')]);}_0x3d1c71['order']=qs[_0x1242('0x3b')](_0x3d28d5[_0x1242('0x32')][_0x1242('0x3b')]);_0x3d1c71[_0x1242('0x3c')]=qs[_0x1242('0x3d')](_['pick'](_0x3d28d5['query'],_0x4c2663[_0x1242('0x3d')]));_0x3d1c71['where'][_0x1242('0x5b')]=_0x325a5b['id'];if(_0x3d28d5[_0x1242('0x32')][_0x1242('0x3f')]){_0x3d1c71[_0x1242('0x3c')]=_[_0x1242('0x40')](_0x3d1c71[_0x1242('0x3c')],{'$or':_[_0x1242('0x2d')](_0x3d1c71[_0x1242('0x35')],function(_0x2594ae){var _0x143a60={};_0x143a60[_0x2594ae]={'$like':'%'+_0x3d28d5[_0x1242('0x32')]['filter']+'%'};return _0x143a60;})});}_0x3d1c71=_[_0x1242('0x40')]({},_0x3d1c71,_0x3d28d5[_0x1242('0x42')]);return db[_0x1242('0x5a')][_0x1242('0x1d')]({'where':_0x3d1c71['where']})[_0x1242('0x25')](function(_0x46f2e3){_0x5b0bdc[_0x1242('0x1d')]=_0x46f2e3;if(_0x3d28d5[_0x1242('0x32')][_0x1242('0x43')]){_0x3d1c71[_0x1242('0x44')]=[{'all':!![]}];}return db[_0x1242('0x5a')][_0x1242('0x5c')](_0x3d1c71);})[_0x1242('0x25')](function(_0x4a7394){_0x5b0bdc[_0x1242('0x45')]=_0x4a7394;return _0x5b0bdc;});}})[_0x1242('0x25')](respondWithFilteredResult(_0x2f554e,_0x3d1c71))['catch'](handleError(_0x2f554e,null));};exports['getAnswers']=function(_0x5f00a1,_0xef1fca,_0xddfb0d){var _0x3fb407={'raw':!![],'where':{}};var _0x13e047={};var _0x2e58ae={'count':0x0,'rows':[]};return db[_0x1242('0x2e')][_0x1242('0x59')]({'where':{'id':_0x5f00a1[_0x1242('0x54')]['id']}})[_0x1242('0x25')](handleEntityNotFound(_0xef1fca,null))[_0x1242('0x25')](function(_0x37bb43){if(_0x37bb43){_0x13e047['model']=_[_0x1242('0x33')](db[_0x1242('0x5d')][_0x1242('0x48')]);_0x13e047[_0x1242('0x32')]=_[_0x1242('0x33')](_0x5f00a1[_0x1242('0x32')]);_0x13e047['filters']=_[_0x1242('0x34')](_0x13e047['model'],_0x13e047[_0x1242('0x32')]);_0x3fb407[_0x1242('0x35')]=_[_0x1242('0x34')](_0x13e047['model'],qs['fields'](_0x5f00a1[_0x1242('0x32')]['fields']));_0x3fb407['attributes']=_0x3fb407['attributes'][_0x1242('0x37')]?_0x3fb407[_0x1242('0x35')]:_0x13e047['model'];if(!_0x5f00a1['query'][_0x1242('0x38')]('nolimit')){_0x3fb407[_0x1242('0x1f')]=qs[_0x1242('0x1f')](_0x5f00a1['query'][_0x1242('0x1f')]);_0x3fb407[_0x1242('0x1e')]=qs[_0x1242('0x1e')](_0x5f00a1[_0x1242('0x32')][_0x1242('0x1e')]);}_0x3fb407[_0x1242('0x3a')]=qs[_0x1242('0x3b')](_0x5f00a1[_0x1242('0x32')][_0x1242('0x3b')]);_0x3fb407['where']=qs[_0x1242('0x3d')](_[_0x1242('0x3e')](_0x5f00a1['query'],_0x13e047[_0x1242('0x3d')]));_0x3fb407[_0x1242('0x3c')][_0x1242('0x5b')]=_0x37bb43['id'];if(_0x5f00a1[_0x1242('0x32')][_0x1242('0x3f')]){_0x3fb407[_0x1242('0x3c')]=_[_0x1242('0x40')](_0x3fb407[_0x1242('0x3c')],{'$or':_[_0x1242('0x2d')](_0x3fb407['attributes'],function(_0x4b0edf){var _0x269d52={};_0x269d52[_0x4b0edf]={'$like':'%'+_0x5f00a1[_0x1242('0x32')][_0x1242('0x3f')]+'%'};return _0x269d52;})});}_0x3fb407=_['merge']({},_0x3fb407,_0x5f00a1['options']);return db[_0x1242('0x5d')][_0x1242('0x1d')]({'where':_0x3fb407['where']})[_0x1242('0x25')](function(_0xd650c4){_0x2e58ae[_0x1242('0x1d')]=_0xd650c4;if(_0x5f00a1['query']['includeAll']){_0x3fb407[_0x1242('0x44')]=[{'all':!![]}];}return db[_0x1242('0x5d')][_0x1242('0x5c')](_0x3fb407);})[_0x1242('0x25')](function(_0x426840){_0x2e58ae[_0x1242('0x45')]=_0x426840;return _0x2e58ae;});}})['then'](respondWithFilteredResult(_0xef1fca,_0x3fb407))['catch'](handleError(_0xef1fca,null));};function char(_0x1caede){return _0x1242('0x5e')===typeof _0x1caede?String[_0x1242('0x5f')]['apply'](null,arguments):_0x1caede;}function needsEncapsulation(_0x19bd4e){return!!_0x19bd4e&&(_0x19bd4e[_0x1242('0x60')]()[_0x1242('0x61')](char(0xd))>=0x0||_0x19bd4e[_0x1242('0x60')]()[_0x1242('0x61')](char(0xa))>=0x0||_0x19bd4e['toString']()[_0x1242('0x61')](char(0x2c))>=0x0||_0x19bd4e[_0x1242('0x60')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x5bc012){var _0x25d858=char(0x22),_0x2efe14='\x5c'+char(0x22),_0x1e4566=_0x5bc012['toString']()[_0x1242('0x62')](new RegExp(_0x25d858,'g'),_0x2efe14);return _0x25d858+_0x1e4566+_0x25d858;}exports[_0x1242('0x63')]=function(_0x3b842e,_0xc50c4e,_0x18db4a){var _0x5b3fe0,_0x5aa49f;var _0x239606={'where':{'ProjectId':_0x3b842e[_0x1242('0x54')]['id']}};if(_0x3b842e[_0x1242('0x32')][_0x1242('0x64')]){_0x239606[_0x1242('0x3c')][_0x1242('0x65')]=JSON['parse'](_0x3b842e[_0x1242('0x32')]['startTime']);}return db[_0x1242('0x5a')][_0x1242('0x5c')](_0x239606)['then'](handleEntityNotFound(_0xc50c4e,null))['then'](function(_0x590eaf){if(_0x590eaf){_0x5b3fe0=_0x590eaf;return db['JscriptyQuestionReport'][_0x1242('0x5c')]({'where':{'SessionId':{'$in':_[_0x1242('0x2d')](_0x5b3fe0,'id')},'ProjectId':_0x3b842e[_0x1242('0x54')]['id']},'order':'-createdAt'});}})[_0x1242('0x25')](handleEntityNotFound(_0xc50c4e,null))[_0x1242('0x25')](function(_0x3d47d8){if(_0x3d47d8){_0x5aa49f=_0x3d47d8;var _0x2309c2={};for(var _0x4ca2d7=0x0,_0x3c3329=_0x5aa49f[_0x1242('0x37')];_0x4ca2d7<_0x3c3329;_0x4ca2d7++){if(!_0x2309c2[_0x1242('0x38')](_0x5aa49f[_0x4ca2d7][_0x1242('0x66')])){_0x2309c2[_0x5aa49f[_0x4ca2d7]['questionId']]=needsEncapsulation(_0x5aa49f[_0x4ca2d7]['question'])?encapsulate(_0x5aa49f[_0x4ca2d7][_0x1242('0x67')]):_0x5aa49f[_0x4ca2d7][_0x1242('0x67')];}}var _0x3c2534=[],_0x3ef695={};for(var _0xb5deb0=0x0,_0x357490=_0x5b3fe0[_0x1242('0x37')];_0xb5deb0<_0x357490;_0xb5deb0++){_0x3ef695={'ProjectId':_0x3b842e[_0x1242('0x54')]['id'],'SessionId':_0x5b3fe0[_0xb5deb0]['id'],'StartTime':moment(_0x5b3fe0[_0xb5deb0]['starttime'])[_0x1242('0x68')](_0x1242('0x69'))};for(var _0x23f655=0x0,_0x558245=_0x5aa49f[_0x1242('0x37')];_0x23f655<_0x558245;_0x23f655++){if(_0x5aa49f[_0x23f655][_0x1242('0x6a')]==_0x5b3fe0[_0xb5deb0]['id']&&_0x2309c2[_0x1242('0x38')](_0x5aa49f[_0x23f655][_0x1242('0x66')])){_0x3ef695[_0x2309c2[_0x5aa49f[_0x23f655][_0x1242('0x66')]]]=_0x5aa49f[_0x23f655][_0x1242('0x6b')];}}for(var _0x5a9458 in _0x2309c2){if(!_0x3ef695[_0x1242('0x38')](_0x2309c2[_0x5a9458])){_0x3ef695[_0x2309c2[_0x5a9458]]=null;}}_0x3c2534['push'](_0x3ef695);}return _0x3c2534;}})[_0x1242('0x25')](function(_0x46c8b9){if(!_['isEmpty'](_0x46c8b9)){var _0x1da032=toCsv(_0x46c8b9);var _0x11881f=Date[_0x1242('0x6c')]();fs[_0x1242('0x6d')](util[_0x1242('0x68')](_0x1242('0x6e'),_0x3b842e[_0x1242('0x54')]['id'],_0x11881f),_0x1da032);_0xc50c4e[_0x1242('0x6f')]('Content-disposition',_0x1242('0x70')+util[_0x1242('0x68')](_0x1242('0x71'),_0x3b842e['params']['id'],_0x11881f));_0xc50c4e[_0x1242('0x6f')](_0x1242('0x72'),_0x1242('0x73'));return _0xc50c4e['download'](util[_0x1242('0x68')](_0x1242('0x6e'),_0x3b842e[_0x1242('0x54')]['id'],_0x11881f));}else{return _0xc50c4e[_0x1242('0x19')](0xcc);}})[_0x1242('0x46')](handleError(_0xc50c4e,null));};