Built motion from commit 42801a18.|2.6.28
[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 _0x988c=['filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','include','rows','catch','show','params','keys','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','find','userProfileId','autoAssociation','clone','omit','createdAt','updatedAt','role','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getSessions','findOne','JscriptySessionReport','ProjectId','findAll','getAnswers','JscriptyAnswerReport','number','apply','toString','indexOf','replace','getSummary','startTime','parse','-createdAt','questionId','question','starttime','SessionId','isEmpty','now','format','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','text/csv','download','eml-format','request-promise','moment','bluebird','sox','to-csv','ejs','lodash','squel','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','json','offset','undefined','limit','count','set','reject','save','update','then','get','Projects','UserProfileResource','destroy','status','error','stack','name','index','map','JscriptyProject','rawAttributes','fieldName','type','key','model','query'];(function(_0x243b9c,_0x5a499f){var _0x523a25=function(_0x2172ea){while(--_0x2172ea){_0x243b9c['push'](_0x243b9c['shift']());}};_0x523a25(++_0x5a499f);}(_0x988c,0x19e));var _0xc988=function(_0x60a543,_0x109533){_0x60a543=_0x60a543-0x0;var _0x1be64c=_0x988c[_0x60a543];return _0x1be64c;};'use strict';var emlformat=require(_0xc988('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xc988('0x1'));var moment=require(_0xc988('0x2'));var BPromise=require(_0xc988('0x3'));var Mustache=require('mustache');var util=require('util');var path=require('path');var sox=require(_0xc988('0x4'));var csv=require(_0xc988('0x5'));var ejs=require(_0xc988('0x6'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xc988('0x7'));var squel=require(_0xc988('0x8'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xc988('0x9'));var toCsv=require(_0xc988('0x5'));var querystring=require(_0xc988('0xa'));var Papa=require(_0xc988('0xb'));var Redis=require(_0xc988('0xc'));var authService=require('../../components/auth/service');var qs=require(_0xc988('0xd'));var as=require(_0xc988('0xe'));var hardwareService=require(_0xc988('0xf'));var logger=require(_0xc988('0x10'))(_0xc988('0x11'));var utils=require('../../config/utils');var config=require(_0xc988('0x12'));var licenseUtil=require(_0xc988('0x13'));var db=require(_0xc988('0x14'))['db'];function respondWithStatusCode(_0x4d5a67,_0x1dfd2b){_0x1dfd2b=_0x1dfd2b||0xcc;return function(_0x56cdba){if(_0x56cdba){return _0x4d5a67[_0xc988('0x15')](_0x1dfd2b);}return _0x4d5a67['status'](_0x1dfd2b)[_0xc988('0x16')]();};}function respondWithResult(_0xe65f24,_0x1bb5c7){_0x1bb5c7=_0x1bb5c7||0xc8;return function(_0x217096){if(_0x217096){return _0xe65f24['status'](_0x1bb5c7)[_0xc988('0x17')](_0x217096);}};}function respondWithFilteredResult(_0x35c0b4,_0x2a906e){return function(_0x26c251){if(_0x26c251){var _0x3f41d5=typeof _0x2a906e[_0xc988('0x18')]===_0xc988('0x19')&&typeof _0x2a906e[_0xc988('0x1a')]===_0xc988('0x19');var _0x5df82e=_0x26c251[_0xc988('0x1b')];var _0x49738a=_0x3f41d5?0x0:_0x2a906e[_0xc988('0x18')];var _0x23677f=_0x3f41d5?_0x26c251[_0xc988('0x1b')]:_0x2a906e[_0xc988('0x18')]+_0x2a906e[_0xc988('0x1a')];var _0x4bc5da;if(_0x23677f>=_0x5df82e){_0x23677f=_0x5df82e;_0x4bc5da=0xc8;}else{_0x4bc5da=0xce;}_0x35c0b4['status'](_0x4bc5da);return _0x35c0b4[_0xc988('0x1c')]('Content-Range',_0x49738a+'-'+_0x23677f+'/'+_0x5df82e)[_0xc988('0x17')](_0x26c251);}return null;};}function patchUpdates(_0x3cad71){return function(_0x5eceb1){try{jsonpatch['apply'](_0x5eceb1,_0x3cad71,!![]);}catch(_0x7e68df){return BPromise[_0xc988('0x1d')](_0x7e68df);}return _0x5eceb1[_0xc988('0x1e')]();};}function saveUpdates(_0x58b646,_0xc5754d){return function(_0x12dc1e){if(_0x12dc1e){return _0x12dc1e[_0xc988('0x1f')](_0x58b646)['then'](function(_0x3b6e47){return _0x3b6e47;});}return null;};}function removeEntity(_0xc57267,_0x188685){return function(_0x5b4555){if(_0x5b4555){return _0x5b4555['destroy']()[_0xc988('0x20')](function(){var _0x3ca571=_0x5b4555[_0xc988('0x21')]({'plain':!![]});var _0x2e8351=_0xc988('0x22');return db[_0xc988('0x23')][_0xc988('0x24')]({'where':{'type':_0x2e8351,'resourceId':_0x3ca571['id']}})[_0xc988('0x20')](function(){return _0x5b4555;});})['then'](function(){_0xc57267[_0xc988('0x25')](0xcc)[_0xc988('0x16')]();});}};}function handleEntityNotFound(_0xf5b3ef,_0x3f8b9a){return function(_0x38bcee){if(!_0x38bcee){_0xf5b3ef[_0xc988('0x15')](0x194);}return _0x38bcee;};}function handleError(_0x3d0834,_0xd97eff){_0xd97eff=_0xd97eff||0x1f4;return function(_0x495b1a){logger[_0xc988('0x26')](_0x495b1a[_0xc988('0x27')]);if(_0x495b1a[_0xc988('0x28')]){delete _0x495b1a[_0xc988('0x28')];}_0x3d0834['status'](_0xd97eff)['send'](_0x495b1a);};}exports[_0xc988('0x29')]=function(_0x11d51f,_0x20aaab){var _0x4b954a={},_0x117ec8={},_0x2da62e={'count':0x0,'rows':[]};var _0x324e85=_[_0xc988('0x2a')](db[_0xc988('0x2b')][_0xc988('0x2c')],function(_0x3a798f){return{'name':_0x3a798f[_0xc988('0x2d')],'type':_0x3a798f[_0xc988('0x2e')][_0xc988('0x2f')]};});_0x117ec8[_0xc988('0x30')]=_[_0xc988('0x2a')](_0x324e85,_0xc988('0x28'));_0x117ec8[_0xc988('0x31')]=_['keys'](_0x11d51f['query']);_0x117ec8[_0xc988('0x32')]=_[_0xc988('0x33')](_0x117ec8['model'],_0x117ec8[_0xc988('0x31')]);_0x4b954a[_0xc988('0x34')]=_['intersection'](_0x117ec8[_0xc988('0x30')],qs[_0xc988('0x35')](_0x11d51f[_0xc988('0x31')]['fields']));_0x4b954a['attributes']=_0x4b954a[_0xc988('0x34')][_0xc988('0x36')]?_0x4b954a[_0xc988('0x34')]:_0x117ec8[_0xc988('0x30')];if(!_0x11d51f[_0xc988('0x31')][_0xc988('0x37')](_0xc988('0x38'))){_0x4b954a[_0xc988('0x1a')]=qs[_0xc988('0x1a')](_0x11d51f[_0xc988('0x31')]['limit']);_0x4b954a[_0xc988('0x18')]=qs[_0xc988('0x18')](_0x11d51f[_0xc988('0x31')]['offset']);}_0x4b954a[_0xc988('0x39')]=qs[_0xc988('0x3a')](_0x11d51f['query'][_0xc988('0x3a')]);_0x4b954a[_0xc988('0x3b')]=qs['filters'](_[_0xc988('0x3c')](_0x11d51f[_0xc988('0x31')],_0x117ec8['filters']),_0x324e85);if(_0x11d51f[_0xc988('0x31')][_0xc988('0x3d')]){_0x4b954a[_0xc988('0x3b')]=_['merge'](_0x4b954a[_0xc988('0x3b')],{'$or':_[_0xc988('0x2a')](_0x324e85,function(_0x4f50cf){if(_0x4f50cf[_0xc988('0x2e')]!==_0xc988('0x3e')){var _0x4cefe6={};_0x4cefe6[_0x4f50cf[_0xc988('0x28')]]={'$like':'%'+_0x11d51f[_0xc988('0x31')][_0xc988('0x3d')]+'%'};return _0x4cefe6;}})});}_0x4b954a=_[_0xc988('0x3f')]({},_0x4b954a,_0x11d51f[_0xc988('0x40')]);var _0x13bf37={'where':_0x4b954a['where']};return db[_0xc988('0x2b')]['count'](_0x13bf37)[_0xc988('0x20')](function(_0x21df84){_0x2da62e['count']=_0x21df84;if(_0x11d51f[_0xc988('0x31')][_0xc988('0x41')]){_0x4b954a[_0xc988('0x42')]=[{'all':!![]}];}return db['JscriptyProject']['findAll'](_0x4b954a);})[_0xc988('0x20')](function(_0x4a6470){_0x2da62e[_0xc988('0x43')]=_0x4a6470;return _0x2da62e;})[_0xc988('0x20')](respondWithFilteredResult(_0x20aaab,_0x4b954a))[_0xc988('0x44')](handleError(_0x20aaab,null));};exports[_0xc988('0x45')]=function(_0x1a6b57,_0x463142){var _0x54ba85={'raw':![],'where':{'id':_0x1a6b57[_0xc988('0x46')]['id']}},_0x3f606e={};_0x3f606e[_0xc988('0x30')]=_[_0xc988('0x47')](db[_0xc988('0x2b')][_0xc988('0x2c')]);_0x3f606e[_0xc988('0x31')]=_['keys'](_0x1a6b57['query']);_0x3f606e['filters']=_[_0xc988('0x33')](_0x3f606e['model'],_0x3f606e[_0xc988('0x31')]);_0x54ba85[_0xc988('0x34')]=_[_0xc988('0x33')](_0x3f606e[_0xc988('0x30')],qs[_0xc988('0x35')](_0x1a6b57[_0xc988('0x31')]['fields']));_0x54ba85[_0xc988('0x34')]=_0x54ba85[_0xc988('0x34')][_0xc988('0x36')]?_0x54ba85[_0xc988('0x34')]:_0x3f606e[_0xc988('0x30')];if(_0x1a6b57['query'][_0xc988('0x41')]){_0x54ba85['include']=[{'all':!![]}];}_0x54ba85=_[_0xc988('0x3f')]({},_0x54ba85,_0x1a6b57[_0xc988('0x40')]);return db['JscriptyProject']['find'](_0x54ba85)[_0xc988('0x20')](handleEntityNotFound(_0x463142,null))[_0xc988('0x20')](respondWithResult(_0x463142,null))[_0xc988('0x44')](handleError(_0x463142,null));};exports[_0xc988('0x48')]=function(_0x37b40f,_0x29afbe){return db['JscriptyProject'][_0xc988('0x48')](_0x37b40f[_0xc988('0x49')],{})['then'](function(_0x101ce1){var _0xf14893=_0x37b40f[_0xc988('0x4a')][_0xc988('0x21')]({'plain':!![]});if(!_0xf14893)throw new Error(_0xc988('0x4b'));if(_0xf14893['role']==='user'){var _0x2901cc=_0x101ce1[_0xc988('0x21')]({'plain':!![]});var _0x2dfb6d='Projects';return db[_0xc988('0x4c')][_0xc988('0x4d')]({'where':{'name':_0x2dfb6d,'userProfileId':_0xf14893[_0xc988('0x4e')]},'raw':!![]})[_0xc988('0x20')](function(_0x150dfd){if(_0x150dfd&&_0x150dfd[_0xc988('0x4f')]===0x0){return db[_0xc988('0x23')][_0xc988('0x48')]({'name':_0x2901cc['name'],'resourceId':_0x2901cc['id'],'type':_0x150dfd[_0xc988('0x28')],'sectionId':_0x150dfd['id']},{})[_0xc988('0x20')](function(){return _0x101ce1;});}else{return _0x101ce1;}})[_0xc988('0x44')](function(_0x8f511f){logger[_0xc988('0x26')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x8f511f);throw _0x8f511f;});}return _0x101ce1;})[_0xc988('0x20')](respondWithResult(_0x29afbe,0xc9))[_0xc988('0x44')](handleError(_0x29afbe,null));};exports[_0xc988('0x50')]=function(_0x2e3d9c,_0x46e27e){var _0x264dbf={'where':{'id':_0x2e3d9c['params']['id']}},_0xe3a192={};_0xe3a192[_0xc988('0x30')]=_[_0xc988('0x47')](db['JscriptyProject']['rawAttributes']);_0x264dbf['attributes']=_[_0xc988('0x33')](_0xe3a192['model'],qs[_0xc988('0x35')](_0x2e3d9c[_0xc988('0x31')][_0xc988('0x35')]));_0x264dbf[_0xc988('0x34')]=_0x264dbf[_0xc988('0x34')][_0xc988('0x36')]?_0x264dbf[_0xc988('0x34')]:_0xe3a192[_0xc988('0x30')];if(_0x2e3d9c['query'][_0xc988('0x41')]){_0x264dbf['include']=[{'all':!![]}];}_0x264dbf=_['merge']({},_0x264dbf,_0x2e3d9c[_0xc988('0x40')]);return db[_0xc988('0x2b')]['find'](_0x264dbf)[_0xc988('0x20')](handleEntityNotFound(_0x46e27e,null))[_0xc988('0x20')](function(_0x2e1c49){if(_0x2e1c49){var _0x497c29=_0x2e1c49['get']({'plain':!![]});_0x497c29=qs[_0xc988('0x51')](_0x497c29,['id',_0xc988('0x52'),'updatedAt']);_0x2e3d9c[_0xc988('0x49')]=_[_0xc988('0x51')](_0x2e3d9c[_0xc988('0x49')],['id',_0xc988('0x52'),_0xc988('0x53')]);return db[_0xc988('0x2b')][_0xc988('0x48')](_[_0xc988('0x3f')](_0x497c29,_0x2e3d9c[_0xc988('0x49')]),{'include':_0x2e3d9c[_0xc988('0x31')][_0xc988('0x41')]?[{'all':!![]}]:undefined})[_0xc988('0x20')](function(_0x1b793b){var _0xb2563f=_0x2e3d9c['user']['get']({'plain':!![]});if(!_0xb2563f)throw new Error(_0xc988('0x4b'));if(_0xb2563f[_0xc988('0x54')]===_0xc988('0x4a')){var _0x2e2e77=_0x1b793b['get']({'plain':!![]});var _0x1f2212=_0xc988('0x22');return db[_0xc988('0x4c')][_0xc988('0x4d')]({'where':{'name':_0x1f2212,'userProfileId':_0xb2563f[_0xc988('0x4e')]},'raw':!![]})[_0xc988('0x20')](function(_0x2828b6){if(_0x2828b6&&_0x2828b6['autoAssociation']===0x0){return db[_0xc988('0x23')][_0xc988('0x48')]({'name':_0x2e2e77['name'],'resourceId':_0x2e2e77['id'],'type':_0x2828b6[_0xc988('0x28')],'sectionId':_0x2828b6['id']},{})['then'](function(){return _0x1b793b;});}else{return _0x1b793b;}})[_0xc988('0x44')](function(_0x44e53c){logger['error'](_0xc988('0x55'),_0x44e53c);throw _0x44e53c;});}return _0x1b793b;});}})[_0xc988('0x20')](respondWithResult(_0x46e27e,0xc9))[_0xc988('0x44')](handleError(_0x46e27e,null));};exports[_0xc988('0x1f')]=function(_0x1500fc,_0x30808f){if(_0x1500fc[_0xc988('0x49')]['id']){delete _0x1500fc[_0xc988('0x49')]['id'];}return db[_0xc988('0x2b')][_0xc988('0x4d')]({'where':{'id':_0x1500fc[_0xc988('0x46')]['id']}})[_0xc988('0x20')](handleEntityNotFound(_0x30808f,null))[_0xc988('0x20')](saveUpdates(_0x1500fc[_0xc988('0x49')],null))[_0xc988('0x20')](respondWithResult(_0x30808f,null))[_0xc988('0x44')](handleError(_0x30808f,null));};exports['destroy']=function(_0x1c40f7,_0x140613){return db[_0xc988('0x2b')][_0xc988('0x4d')]({'where':{'id':_0x1c40f7[_0xc988('0x46')]['id']}})[_0xc988('0x20')](handleEntityNotFound(_0x140613,null))[_0xc988('0x20')](removeEntity(_0x140613,null))[_0xc988('0x44')](handleError(_0x140613,null));};exports[_0xc988('0x56')]=function(_0x3c625e,_0x1736dd,_0x102524){var _0x470575={'raw':!![],'where':{}};var _0x375b89={};var _0x5bf477={'count':0x0,'rows':[]};return db['JscriptyProject'][_0xc988('0x57')]({'where':{'id':_0x3c625e['params']['id']}})[_0xc988('0x20')](handleEntityNotFound(_0x1736dd,null))[_0xc988('0x20')](function(_0x4e9560){if(_0x4e9560){_0x375b89[_0xc988('0x30')]=_['keys'](db[_0xc988('0x58')][_0xc988('0x2c')]);_0x375b89['query']=_['keys'](_0x3c625e[_0xc988('0x31')]);_0x375b89[_0xc988('0x32')]=_[_0xc988('0x33')](_0x375b89[_0xc988('0x30')],_0x375b89[_0xc988('0x31')]);_0x470575[_0xc988('0x34')]=_[_0xc988('0x33')](_0x375b89[_0xc988('0x30')],qs['fields'](_0x3c625e[_0xc988('0x31')][_0xc988('0x35')]));_0x470575[_0xc988('0x34')]=_0x470575[_0xc988('0x34')][_0xc988('0x36')]?_0x470575[_0xc988('0x34')]:_0x375b89['model'];if(!_0x3c625e['query'][_0xc988('0x37')]('nolimit')){_0x470575[_0xc988('0x1a')]=qs['limit'](_0x3c625e[_0xc988('0x31')][_0xc988('0x1a')]);_0x470575[_0xc988('0x18')]=qs['offset'](_0x3c625e[_0xc988('0x31')][_0xc988('0x18')]);}_0x470575[_0xc988('0x39')]=qs[_0xc988('0x3a')](_0x3c625e[_0xc988('0x31')]['sort']);_0x470575[_0xc988('0x3b')]=qs[_0xc988('0x32')](_[_0xc988('0x3c')](_0x3c625e['query'],_0x375b89[_0xc988('0x32')]));_0x470575['where'][_0xc988('0x59')]=_0x4e9560['id'];if(_0x3c625e['query'][_0xc988('0x3d')]){_0x470575[_0xc988('0x3b')]=_['merge'](_0x470575['where'],{'$or':_[_0xc988('0x2a')](_0x470575[_0xc988('0x34')],function(_0x548104){var _0x2f4a41={};_0x2f4a41[_0x548104]={'$like':'%'+_0x3c625e['query'][_0xc988('0x3d')]+'%'};return _0x2f4a41;})});}_0x470575=_['merge']({},_0x470575,_0x3c625e[_0xc988('0x40')]);return db[_0xc988('0x58')][_0xc988('0x1b')]({'where':_0x470575[_0xc988('0x3b')]})[_0xc988('0x20')](function(_0x3f379e){_0x5bf477['count']=_0x3f379e;if(_0x3c625e[_0xc988('0x31')]['includeAll']){_0x470575[_0xc988('0x42')]=[{'all':!![]}];}return db[_0xc988('0x58')][_0xc988('0x5a')](_0x470575);})[_0xc988('0x20')](function(_0x412e79){_0x5bf477['rows']=_0x412e79;return _0x5bf477;});}})[_0xc988('0x20')](respondWithFilteredResult(_0x1736dd,_0x470575))[_0xc988('0x44')](handleError(_0x1736dd,null));};exports[_0xc988('0x5b')]=function(_0x5f25f4,_0x5b1da8,_0x4b09b7){var _0x262613={'raw':!![],'where':{}};var _0x2f10b1={};var _0x493d7c={'count':0x0,'rows':[]};return db[_0xc988('0x2b')][_0xc988('0x57')]({'where':{'id':_0x5f25f4['params']['id']}})[_0xc988('0x20')](handleEntityNotFound(_0x5b1da8,null))[_0xc988('0x20')](function(_0xb8c2c9){if(_0xb8c2c9){_0x2f10b1['model']=_['keys'](db[_0xc988('0x5c')][_0xc988('0x2c')]);_0x2f10b1[_0xc988('0x31')]=_[_0xc988('0x47')](_0x5f25f4[_0xc988('0x31')]);_0x2f10b1[_0xc988('0x32')]=_['intersection'](_0x2f10b1[_0xc988('0x30')],_0x2f10b1[_0xc988('0x31')]);_0x262613['attributes']=_[_0xc988('0x33')](_0x2f10b1[_0xc988('0x30')],qs['fields'](_0x5f25f4[_0xc988('0x31')]['fields']));_0x262613['attributes']=_0x262613['attributes'][_0xc988('0x36')]?_0x262613['attributes']:_0x2f10b1[_0xc988('0x30')];if(!_0x5f25f4[_0xc988('0x31')]['hasOwnProperty']('nolimit')){_0x262613[_0xc988('0x1a')]=qs[_0xc988('0x1a')](_0x5f25f4[_0xc988('0x31')]['limit']);_0x262613[_0xc988('0x18')]=qs[_0xc988('0x18')](_0x5f25f4[_0xc988('0x31')][_0xc988('0x18')]);}_0x262613[_0xc988('0x39')]=qs[_0xc988('0x3a')](_0x5f25f4[_0xc988('0x31')][_0xc988('0x3a')]);_0x262613['where']=qs[_0xc988('0x32')](_[_0xc988('0x3c')](_0x5f25f4[_0xc988('0x31')],_0x2f10b1[_0xc988('0x32')]));_0x262613['where'][_0xc988('0x59')]=_0xb8c2c9['id'];if(_0x5f25f4[_0xc988('0x31')][_0xc988('0x3d')]){_0x262613['where']=_['merge'](_0x262613[_0xc988('0x3b')],{'$or':_[_0xc988('0x2a')](_0x262613[_0xc988('0x34')],function(_0xae2eb2){var _0x142385={};_0x142385[_0xae2eb2]={'$like':'%'+_0x5f25f4[_0xc988('0x31')][_0xc988('0x3d')]+'%'};return _0x142385;})});}_0x262613=_[_0xc988('0x3f')]({},_0x262613,_0x5f25f4[_0xc988('0x40')]);return db[_0xc988('0x5c')]['count']({'where':_0x262613[_0xc988('0x3b')]})[_0xc988('0x20')](function(_0x3f1354){_0x493d7c[_0xc988('0x1b')]=_0x3f1354;if(_0x5f25f4['query'][_0xc988('0x41')]){_0x262613[_0xc988('0x42')]=[{'all':!![]}];}return db['JscriptyAnswerReport'][_0xc988('0x5a')](_0x262613);})[_0xc988('0x20')](function(_0x1664d9){_0x493d7c[_0xc988('0x43')]=_0x1664d9;return _0x493d7c;});}})[_0xc988('0x20')](respondWithFilteredResult(_0x5b1da8,_0x262613))[_0xc988('0x44')](handleError(_0x5b1da8,null));};function char(_0x2bb864){return _0xc988('0x5d')===typeof _0x2bb864?String['fromCharCode'][_0xc988('0x5e')](null,arguments):_0x2bb864;}function needsEncapsulation(_0x1a8d1f){return!!_0x1a8d1f&&(_0x1a8d1f[_0xc988('0x5f')]()[_0xc988('0x60')](char(0xd))>=0x0||_0x1a8d1f[_0xc988('0x5f')]()['indexOf'](char(0xa))>=0x0||_0x1a8d1f[_0xc988('0x5f')]()[_0xc988('0x60')](char(0x2c))>=0x0||_0x1a8d1f[_0xc988('0x5f')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x1c73d7){var _0x1c2af5=char(0x22),_0x42109c='\x5c'+char(0x22),_0x6942ef=_0x1c73d7['toString']()[_0xc988('0x61')](new RegExp(_0x1c2af5,'g'),_0x42109c);return _0x1c2af5+_0x6942ef+_0x1c2af5;}exports[_0xc988('0x62')]=function(_0x4b409e,_0x322432,_0x302b95){var _0x3d7deb,_0x44a951;var _0x4a8a98={'where':{'ProjectId':_0x4b409e[_0xc988('0x46')]['id']}};if(_0x4b409e[_0xc988('0x31')][_0xc988('0x63')]){_0x4a8a98[_0xc988('0x3b')]['starttime']=JSON[_0xc988('0x64')](_0x4b409e[_0xc988('0x31')][_0xc988('0x63')]);}return db[_0xc988('0x58')][_0xc988('0x5a')](_0x4a8a98)[_0xc988('0x20')](handleEntityNotFound(_0x322432,null))[_0xc988('0x20')](function(_0x305167){if(_0x305167){_0x3d7deb=_0x305167;return db['JscriptyQuestionReport'][_0xc988('0x5a')]({'where':{'SessionId':{'$in':_[_0xc988('0x2a')](_0x3d7deb,'id')},'ProjectId':_0x4b409e[_0xc988('0x46')]['id']},'order':_0xc988('0x65')});}})['then'](handleEntityNotFound(_0x322432,null))[_0xc988('0x20')](function(_0x442a29){if(_0x442a29){_0x44a951=_0x442a29;var _0x487114={};for(var _0xaac99a=0x0,_0x165553=_0x44a951[_0xc988('0x36')];_0xaac99a<_0x165553;_0xaac99a++){if(!_0x487114[_0xc988('0x37')](_0x44a951[_0xaac99a][_0xc988('0x66')])){_0x487114[_0x44a951[_0xaac99a]['questionId']]=needsEncapsulation(_0x44a951[_0xaac99a][_0xc988('0x67')])?encapsulate(_0x44a951[_0xaac99a][_0xc988('0x67')]):_0x44a951[_0xaac99a][_0xc988('0x67')];}}var _0x322e86=[],_0x564369={};for(var _0x1fcc55=0x0,_0x41a09d=_0x3d7deb['length'];_0x1fcc55<_0x41a09d;_0x1fcc55++){_0x564369={'ProjectId':_0x4b409e['params']['id'],'SessionId':_0x3d7deb[_0x1fcc55]['id'],'StartTime':moment(_0x3d7deb[_0x1fcc55][_0xc988('0x68')])['format']('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x8006c3=0x0,_0x172747=_0x44a951['length'];_0x8006c3<_0x172747;_0x8006c3++){if(_0x44a951[_0x8006c3][_0xc988('0x69')]==_0x3d7deb[_0x1fcc55]['id']&&_0x487114[_0xc988('0x37')](_0x44a951[_0x8006c3][_0xc988('0x66')])){_0x564369[_0x487114[_0x44a951[_0x8006c3][_0xc988('0x66')]]]=_0x44a951[_0x8006c3]['answer'];}}for(var _0x3d543b in _0x487114){if(!_0x564369[_0xc988('0x37')](_0x487114[_0x3d543b])){_0x564369[_0x487114[_0x3d543b]]=null;}}_0x322e86['push'](_0x564369);}return _0x322e86;}})[_0xc988('0x20')](function(_0x4597c2){if(!_[_0xc988('0x6a')](_0x4597c2)){var _0x47b6c3=toCsv(_0x4597c2);var _0x47e19d=Date[_0xc988('0x6b')]();fs['writeFileSync'](util[_0xc988('0x6c')](_0xc988('0x6d'),_0x4b409e['params']['id'],_0x47e19d),_0x47b6c3);_0x322432[_0xc988('0x6e')](_0xc988('0x6f'),_0xc988('0x70')+util[_0xc988('0x6c')](_0xc988('0x71'),_0x4b409e[_0xc988('0x46')]['id'],_0x47e19d));_0x322432[_0xc988('0x6e')]('Content-type',_0xc988('0x72'));return _0x322432[_0xc988('0x73')](util[_0xc988('0x6c')](_0xc988('0x6d'),_0x4b409e[_0xc988('0x46')]['id'],_0x47e19d));}else{return _0x322432[_0xc988('0x15')](0xcc);}})[_0xc988('0x44')](handleError(_0x322432,null));};