42ce357dff2abcf80e89e7d2c9a3c868bf217320
[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 _0x78d4=['parse','JscriptyQuestionReport','-createdAt','questionId','question','starttime','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','now','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','/tmp/Jscripty_Project_%d_Summary_%s.csv','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','status','end','json','offset','count','limit','set','Content-Range','apply','reject','save','then','destroy','get','UserProfileResource','sendStatus','stack','name','merge','body','contact','message','agent','account','map','JscriptyProject','rawAttributes','type','key','model','query','keys','filters','intersection','attributes','fields','length','nolimit','order','sort','where','pick','filter','VIRTUAL','includeAll','include','findAll','rows','catch','show','params','options','find','create','user','role','Projects','UserProfileSection','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','update','getSessions','findOne','hasOwnProperty','ProjectId','getAnswers','JscriptyAnswerReport','number','fromCharCode','toString','indexOf','startTime'];(function(_0x514a38,_0x5646f2){var _0x586600=function(_0xdd31aa){while(--_0xdd31aa){_0x514a38['push'](_0x514a38['shift']());}};_0x586600(++_0x5646f2);}(_0x78d4,0x18a));var _0x478d=function(_0x38f2ea,_0x39cf0a){_0x38f2ea=_0x38f2ea-0x0;var _0x17efde=_0x78d4[_0x38f2ea];return _0x17efde;};'use strict';var emlformat=require(_0x478d('0x0'));var rimraf=require(_0x478d('0x1'));var zipdir=require(_0x478d('0x2'));var jsonpatch=require(_0x478d('0x3'));var rp=require(_0x478d('0x4'));var moment=require(_0x478d('0x5'));var BPromise=require(_0x478d('0x6'));var Mustache=require(_0x478d('0x7'));var util=require(_0x478d('0x8'));var path=require('path');var sox=require(_0x478d('0x9'));var csv=require('to-csv');var ejs=require(_0x478d('0xa'));var fs=require('fs');var fs_extra=require(_0x478d('0xb'));var _=require(_0x478d('0xc'));var squel=require(_0x478d('0xd'));var crypto=require(_0x478d('0xe'));var jsforce=require(_0x478d('0xf'));var deskjs=require(_0x478d('0x10'));var toCsv=require(_0x478d('0x11'));var querystring=require(_0x478d('0x12'));var Papa=require(_0x478d('0x13'));var Redis=require('ioredis');var authService=require(_0x478d('0x14'));var qs=require('../../components/parsers/qs');var as=require(_0x478d('0x15'));var hardwareService=require(_0x478d('0x16'));var logger=require(_0x478d('0x17'))(_0x478d('0x18'));var utils=require(_0x478d('0x19'));var config=require(_0x478d('0x1a'));var licenseUtil=require(_0x478d('0x1b'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x1b0d6e,_0x3c6304){_0x3c6304=_0x3c6304||0xcc;return function(_0x542fa1){if(_0x542fa1){return _0x1b0d6e['sendStatus'](_0x3c6304);}return _0x1b0d6e[_0x478d('0x1c')](_0x3c6304)[_0x478d('0x1d')]();};}function respondWithResult(_0x4d028a,_0x57b551){_0x57b551=_0x57b551||0xc8;return function(_0x47fa39){if(_0x47fa39){return _0x4d028a[_0x478d('0x1c')](_0x57b551)[_0x478d('0x1e')](_0x47fa39);}};}function respondWithFilteredResult(_0x4b8bc7,_0x22109f){return function(_0x35e7d6){if(_0x35e7d6){var _0x74b271=typeof _0x22109f[_0x478d('0x1f')]==='undefined'&&typeof _0x22109f['limit']==='undefined';var _0x4a76fa=_0x35e7d6[_0x478d('0x20')];var _0x5d6d78=_0x74b271?0x0:_0x22109f[_0x478d('0x1f')];var _0x57e9d8=_0x74b271?_0x35e7d6[_0x478d('0x20')]:_0x22109f[_0x478d('0x1f')]+_0x22109f[_0x478d('0x21')];var _0x82c8c1;if(_0x57e9d8>=_0x4a76fa){_0x57e9d8=_0x4a76fa;_0x82c8c1=0xc8;}else{_0x82c8c1=0xce;}_0x4b8bc7[_0x478d('0x1c')](_0x82c8c1);return _0x4b8bc7[_0x478d('0x22')](_0x478d('0x23'),_0x5d6d78+'-'+_0x57e9d8+'/'+_0x4a76fa)[_0x478d('0x1e')](_0x35e7d6);}return null;};}function patchUpdates(_0x4c108a){return function(_0x56ed75){try{jsonpatch[_0x478d('0x24')](_0x56ed75,_0x4c108a,!![]);}catch(_0x554d22){return BPromise[_0x478d('0x25')](_0x554d22);}return _0x56ed75[_0x478d('0x26')]();};}function saveUpdates(_0x5c58ca,_0x485480){return function(_0x55b63d){if(_0x55b63d){return _0x55b63d['update'](_0x5c58ca)[_0x478d('0x27')](function(_0x2bf525){return _0x2bf525;});}return null;};}function removeEntity(_0x421b7d,_0x410592){return function(_0x19ff45){if(_0x19ff45){return _0x19ff45[_0x478d('0x28')]()[_0x478d('0x27')](function(){var _0x37e164=_0x19ff45[_0x478d('0x29')]({'plain':!![]});var _0x552e69='Projects';return db[_0x478d('0x2a')][_0x478d('0x28')]({'where':{'type':_0x552e69,'resourceId':_0x37e164['id']}})['then'](function(){return _0x19ff45;});})[_0x478d('0x27')](function(){_0x421b7d[_0x478d('0x1c')](0xcc)[_0x478d('0x1d')]();});}};}function handleEntityNotFound(_0x40e0f9,_0xfa6c39){return function(_0x486ac3){if(!_0x486ac3){_0x40e0f9[_0x478d('0x2b')](0x194);}return _0x486ac3;};}function handleError(_0x492f2b,_0x520ab5){_0x520ab5=_0x520ab5||0x1f4;return function(_0x32ac06){logger['error'](_0x32ac06[_0x478d('0x2c')]);if(_0x32ac06[_0x478d('0x2d')]){delete _0x32ac06[_0x478d('0x2d')];}_0x492f2b['status'](_0x520ab5)['send'](_0x32ac06);};}function getMustacheRender(_0x35f6b6,_0x3b68f7){return Mustache['render'](_0x35f6b6,_[_0x478d('0x2e')](_0x3b68f7[_0x478d('0x2f')],{'contact':_0x3b68f7[_0x478d('0x30')],'message':_0x3b68f7[_0x478d('0x31')],'agent':_0x3b68f7[_0x478d('0x32')],'interaction':_0x3b68f7['interaction'],'account':_0x3b68f7[_0x478d('0x33')]}))||'';}exports['index']=function(_0x133f8c,_0x401cc3){var _0x14ec16={},_0x34ebd8={},_0x5127c9={'count':0x0,'rows':[]};var _0xc52814=_[_0x478d('0x34')](db[_0x478d('0x35')][_0x478d('0x36')],function(_0x3ca355){return{'name':_0x3ca355['fieldName'],'type':_0x3ca355[_0x478d('0x37')][_0x478d('0x38')]};});_0x34ebd8[_0x478d('0x39')]=_[_0x478d('0x34')](_0xc52814,_0x478d('0x2d'));_0x34ebd8[_0x478d('0x3a')]=_[_0x478d('0x3b')](_0x133f8c[_0x478d('0x3a')]);_0x34ebd8[_0x478d('0x3c')]=_[_0x478d('0x3d')](_0x34ebd8[_0x478d('0x39')],_0x34ebd8[_0x478d('0x3a')]);_0x14ec16[_0x478d('0x3e')]=_[_0x478d('0x3d')](_0x34ebd8[_0x478d('0x39')],qs['fields'](_0x133f8c[_0x478d('0x3a')][_0x478d('0x3f')]));_0x14ec16['attributes']=_0x14ec16[_0x478d('0x3e')][_0x478d('0x40')]?_0x14ec16[_0x478d('0x3e')]:_0x34ebd8[_0x478d('0x39')];if(!_0x133f8c['query']['hasOwnProperty'](_0x478d('0x41'))){_0x14ec16['limit']=qs[_0x478d('0x21')](_0x133f8c[_0x478d('0x3a')][_0x478d('0x21')]);_0x14ec16['offset']=qs[_0x478d('0x1f')](_0x133f8c[_0x478d('0x3a')][_0x478d('0x1f')]);}_0x14ec16[_0x478d('0x42')]=qs[_0x478d('0x43')](_0x133f8c[_0x478d('0x3a')][_0x478d('0x43')]);_0x14ec16[_0x478d('0x44')]=qs[_0x478d('0x3c')](_[_0x478d('0x45')](_0x133f8c['query'],_0x34ebd8['filters']),_0xc52814);if(_0x133f8c['query'][_0x478d('0x46')]){_0x14ec16[_0x478d('0x44')]=_[_0x478d('0x2e')](_0x14ec16['where'],{'$or':_[_0x478d('0x34')](_0xc52814,function(_0x56765d){if(_0x56765d[_0x478d('0x37')]!==_0x478d('0x47')){var _0x2d17d0={};_0x2d17d0[_0x56765d['name']]={'$like':'%'+_0x133f8c[_0x478d('0x3a')][_0x478d('0x46')]+'%'};return _0x2d17d0;}})});}_0x14ec16=_[_0x478d('0x2e')]({},_0x14ec16,_0x133f8c['options']);var _0xe9afc8={'where':_0x14ec16[_0x478d('0x44')]};return db[_0x478d('0x35')][_0x478d('0x20')](_0xe9afc8)[_0x478d('0x27')](function(_0x2296d8){_0x5127c9[_0x478d('0x20')]=_0x2296d8;if(_0x133f8c[_0x478d('0x3a')][_0x478d('0x48')]){_0x14ec16[_0x478d('0x49')]=[{'all':!![]}];}return db[_0x478d('0x35')][_0x478d('0x4a')](_0x14ec16);})[_0x478d('0x27')](function(_0x123d69){_0x5127c9[_0x478d('0x4b')]=_0x123d69;return _0x5127c9;})['then'](respondWithFilteredResult(_0x401cc3,_0x14ec16))[_0x478d('0x4c')](handleError(_0x401cc3,null));};exports[_0x478d('0x4d')]=function(_0x120298,_0x4be213){var _0x195b19={'raw':![],'where':{'id':_0x120298[_0x478d('0x4e')]['id']}},_0x5cccbd={};_0x5cccbd[_0x478d('0x39')]=_[_0x478d('0x3b')](db['JscriptyProject'][_0x478d('0x36')]);_0x5cccbd['query']=_[_0x478d('0x3b')](_0x120298[_0x478d('0x3a')]);_0x5cccbd[_0x478d('0x3c')]=_['intersection'](_0x5cccbd[_0x478d('0x39')],_0x5cccbd[_0x478d('0x3a')]);_0x195b19['attributes']=_['intersection'](_0x5cccbd[_0x478d('0x39')],qs[_0x478d('0x3f')](_0x120298['query'][_0x478d('0x3f')]));_0x195b19[_0x478d('0x3e')]=_0x195b19[_0x478d('0x3e')][_0x478d('0x40')]?_0x195b19[_0x478d('0x3e')]:_0x5cccbd[_0x478d('0x39')];if(_0x120298[_0x478d('0x3a')][_0x478d('0x48')]){_0x195b19[_0x478d('0x49')]=[{'all':!![]}];}_0x195b19=_[_0x478d('0x2e')]({},_0x195b19,_0x120298[_0x478d('0x4f')]);return db[_0x478d('0x35')][_0x478d('0x50')](_0x195b19)['then'](handleEntityNotFound(_0x4be213,null))[_0x478d('0x27')](respondWithResult(_0x4be213,null))[_0x478d('0x4c')](handleError(_0x4be213,null));};exports['create']=function(_0x5da92d,_0x3bd268){return db['JscriptyProject'][_0x478d('0x51')](_0x5da92d[_0x478d('0x2f')],{})[_0x478d('0x27')](function(_0x18e917){var _0x43255f=_0x5da92d[_0x478d('0x52')][_0x478d('0x29')]({'plain':!![]});if(!_0x43255f)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x43255f[_0x478d('0x53')]===_0x478d('0x52')){var _0x2e7296=_0x18e917[_0x478d('0x29')]({'plain':!![]});var _0x519dbf=_0x478d('0x54');return db[_0x478d('0x55')]['find']({'where':{'name':_0x519dbf,'userProfileId':_0x43255f[_0x478d('0x56')]},'raw':!![]})[_0x478d('0x27')](function(_0x37ce96){if(_0x37ce96&&_0x37ce96[_0x478d('0x57')]===0x0){return db[_0x478d('0x2a')]['create']({'name':_0x2e7296[_0x478d('0x2d')],'resourceId':_0x2e7296['id'],'type':_0x37ce96['name'],'sectionId':_0x37ce96['id']},{})[_0x478d('0x27')](function(){return _0x18e917;});}else{return _0x18e917;}})[_0x478d('0x4c')](function(_0x106248){logger[_0x478d('0x58')](_0x478d('0x59'),_0x106248);throw _0x106248;});}return _0x18e917;})[_0x478d('0x27')](respondWithResult(_0x3bd268,0xc9))[_0x478d('0x4c')](handleError(_0x3bd268,null));};exports[_0x478d('0x5a')]=function(_0x2f1c57,_0x824eb9){var _0x249a5e={'where':{'id':_0x2f1c57[_0x478d('0x4e')]['id']}},_0x5f5347={};_0x5f5347['model']=_[_0x478d('0x3b')](db['JscriptyProject']['rawAttributes']);_0x249a5e[_0x478d('0x3e')]=_[_0x478d('0x3d')](_0x5f5347['model'],qs['fields'](_0x2f1c57[_0x478d('0x3a')][_0x478d('0x3f')]));_0x249a5e[_0x478d('0x3e')]=_0x249a5e[_0x478d('0x3e')][_0x478d('0x40')]?_0x249a5e[_0x478d('0x3e')]:_0x5f5347[_0x478d('0x39')];if(_0x2f1c57['query'][_0x478d('0x48')]){_0x249a5e[_0x478d('0x49')]=[{'all':!![]}];}_0x249a5e=_['merge']({},_0x249a5e,_0x2f1c57[_0x478d('0x4f')]);return db[_0x478d('0x35')][_0x478d('0x50')](_0x249a5e)[_0x478d('0x27')](handleEntityNotFound(_0x824eb9,null))[_0x478d('0x27')](function(_0x58714a){if(_0x58714a){var _0x2a73eb=_0x58714a['get']({'plain':!![]});_0x2a73eb=qs['omit'](_0x2a73eb,['id','createdAt','updatedAt']);_0x2f1c57[_0x478d('0x2f')]=_[_0x478d('0x5b')](_0x2f1c57[_0x478d('0x2f')],['id',_0x478d('0x5c'),'updatedAt']);return db[_0x478d('0x35')][_0x478d('0x51')](_[_0x478d('0x2e')](_0x2a73eb,_0x2f1c57[_0x478d('0x2f')]),{'include':_0x2f1c57[_0x478d('0x3a')][_0x478d('0x48')]?[{'all':!![]}]:undefined})['then'](function(_0x1c811c){var _0x1c9967=_0x2f1c57[_0x478d('0x52')][_0x478d('0x29')]({'plain':!![]});if(!_0x1c9967)throw new Error(_0x478d('0x5d'));if(_0x1c9967[_0x478d('0x53')]===_0x478d('0x52')){var _0x190d48=_0x1c811c['get']({'plain':!![]});var _0x2dff02='Projects';return db[_0x478d('0x55')][_0x478d('0x50')]({'where':{'name':_0x2dff02,'userProfileId':_0x1c9967['userProfileId']},'raw':!![]})[_0x478d('0x27')](function(_0x327c15){if(_0x327c15&&_0x327c15[_0x478d('0x57')]===0x0){return db[_0x478d('0x2a')][_0x478d('0x51')]({'name':_0x190d48['name'],'resourceId':_0x190d48['id'],'type':_0x327c15[_0x478d('0x2d')],'sectionId':_0x327c15['id']},{})[_0x478d('0x27')](function(){return _0x1c811c;});}else{return _0x1c811c;}})[_0x478d('0x4c')](function(_0x28dedf){logger[_0x478d('0x58')](_0x478d('0x59'),_0x28dedf);throw _0x28dedf;});}return _0x1c811c;});}})[_0x478d('0x27')](respondWithResult(_0x824eb9,0xc9))['catch'](handleError(_0x824eb9,null));};exports[_0x478d('0x5e')]=function(_0x20b8d0,_0x2bce71){if(_0x20b8d0[_0x478d('0x2f')]['id']){delete _0x20b8d0[_0x478d('0x2f')]['id'];}return db[_0x478d('0x35')][_0x478d('0x50')]({'where':{'id':_0x20b8d0['params']['id']}})[_0x478d('0x27')](handleEntityNotFound(_0x2bce71,null))[_0x478d('0x27')](saveUpdates(_0x20b8d0['body'],null))[_0x478d('0x27')](respondWithResult(_0x2bce71,null))[_0x478d('0x4c')](handleError(_0x2bce71,null));};exports['destroy']=function(_0x14ddd8,_0x72ed54){return db[_0x478d('0x35')][_0x478d('0x50')]({'where':{'id':_0x14ddd8[_0x478d('0x4e')]['id']}})[_0x478d('0x27')](handleEntityNotFound(_0x72ed54,null))[_0x478d('0x27')](removeEntity(_0x72ed54,null))[_0x478d('0x4c')](handleError(_0x72ed54,null));};exports[_0x478d('0x5f')]=function(_0x12b8d6,_0xb1ed77,_0x45b49e){var _0x431084={'raw':!![],'where':{}};var _0x30c949={};var _0x1e678c={'count':0x0,'rows':[]};return db[_0x478d('0x35')][_0x478d('0x60')]({'where':{'id':_0x12b8d6[_0x478d('0x4e')]['id']}})[_0x478d('0x27')](handleEntityNotFound(_0xb1ed77,null))['then'](function(_0x53a767){if(_0x53a767){_0x30c949[_0x478d('0x39')]=_[_0x478d('0x3b')](db['JscriptySessionReport']['rawAttributes']);_0x30c949[_0x478d('0x3a')]=_[_0x478d('0x3b')](_0x12b8d6['query']);_0x30c949[_0x478d('0x3c')]=_['intersection'](_0x30c949[_0x478d('0x39')],_0x30c949[_0x478d('0x3a')]);_0x431084['attributes']=_[_0x478d('0x3d')](_0x30c949['model'],qs[_0x478d('0x3f')](_0x12b8d6[_0x478d('0x3a')][_0x478d('0x3f')]));_0x431084[_0x478d('0x3e')]=_0x431084[_0x478d('0x3e')][_0x478d('0x40')]?_0x431084[_0x478d('0x3e')]:_0x30c949['model'];if(!_0x12b8d6['query'][_0x478d('0x61')](_0x478d('0x41'))){_0x431084[_0x478d('0x21')]=qs['limit'](_0x12b8d6[_0x478d('0x3a')]['limit']);_0x431084[_0x478d('0x1f')]=qs['offset'](_0x12b8d6[_0x478d('0x3a')][_0x478d('0x1f')]);}_0x431084[_0x478d('0x42')]=qs[_0x478d('0x43')](_0x12b8d6[_0x478d('0x3a')][_0x478d('0x43')]);_0x431084[_0x478d('0x44')]=qs[_0x478d('0x3c')](_[_0x478d('0x45')](_0x12b8d6['query'],_0x30c949[_0x478d('0x3c')]));_0x431084['where'][_0x478d('0x62')]=_0x53a767['id'];if(_0x12b8d6['query']['filter']){_0x431084[_0x478d('0x44')]=_['merge'](_0x431084[_0x478d('0x44')],{'$or':_['map'](_0x431084[_0x478d('0x3e')],function(_0x35b47a){var _0x3be81c={};_0x3be81c[_0x35b47a]={'$like':'%'+_0x12b8d6[_0x478d('0x3a')]['filter']+'%'};return _0x3be81c;})});}_0x431084=_['merge']({},_0x431084,_0x12b8d6[_0x478d('0x4f')]);return db['JscriptySessionReport'][_0x478d('0x20')]({'where':_0x431084[_0x478d('0x44')]})['then'](function(_0x3bf587){_0x1e678c[_0x478d('0x20')]=_0x3bf587;if(_0x12b8d6[_0x478d('0x3a')][_0x478d('0x48')]){_0x431084[_0x478d('0x49')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x478d('0x4a')](_0x431084);})[_0x478d('0x27')](function(_0x4135bb){_0x1e678c['rows']=_0x4135bb;return _0x1e678c;});}})[_0x478d('0x27')](respondWithFilteredResult(_0xb1ed77,_0x431084))[_0x478d('0x4c')](handleError(_0xb1ed77,null));};exports[_0x478d('0x63')]=function(_0x2519f6,_0x578748,_0x5a45ef){var _0x458e6f={'raw':!![],'where':{}};var _0x283f08={};var _0x32a02b={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x478d('0x60')]({'where':{'id':_0x2519f6['params']['id']}})['then'](handleEntityNotFound(_0x578748,null))[_0x478d('0x27')](function(_0x403ca3){if(_0x403ca3){_0x283f08['model']=_[_0x478d('0x3b')](db[_0x478d('0x64')][_0x478d('0x36')]);_0x283f08['query']=_['keys'](_0x2519f6['query']);_0x283f08['filters']=_['intersection'](_0x283f08[_0x478d('0x39')],_0x283f08[_0x478d('0x3a')]);_0x458e6f['attributes']=_[_0x478d('0x3d')](_0x283f08[_0x478d('0x39')],qs[_0x478d('0x3f')](_0x2519f6[_0x478d('0x3a')]['fields']));_0x458e6f['attributes']=_0x458e6f[_0x478d('0x3e')][_0x478d('0x40')]?_0x458e6f[_0x478d('0x3e')]:_0x283f08[_0x478d('0x39')];if(!_0x2519f6['query']['hasOwnProperty'](_0x478d('0x41'))){_0x458e6f[_0x478d('0x21')]=qs['limit'](_0x2519f6[_0x478d('0x3a')][_0x478d('0x21')]);_0x458e6f[_0x478d('0x1f')]=qs[_0x478d('0x1f')](_0x2519f6[_0x478d('0x3a')][_0x478d('0x1f')]);}_0x458e6f[_0x478d('0x42')]=qs['sort'](_0x2519f6[_0x478d('0x3a')][_0x478d('0x43')]);_0x458e6f[_0x478d('0x44')]=qs[_0x478d('0x3c')](_[_0x478d('0x45')](_0x2519f6[_0x478d('0x3a')],_0x283f08[_0x478d('0x3c')]));_0x458e6f['where'][_0x478d('0x62')]=_0x403ca3['id'];if(_0x2519f6['query'][_0x478d('0x46')]){_0x458e6f['where']=_['merge'](_0x458e6f['where'],{'$or':_[_0x478d('0x34')](_0x458e6f[_0x478d('0x3e')],function(_0x23af22){var _0x139861={};_0x139861[_0x23af22]={'$like':'%'+_0x2519f6[_0x478d('0x3a')][_0x478d('0x46')]+'%'};return _0x139861;})});}_0x458e6f=_['merge']({},_0x458e6f,_0x2519f6[_0x478d('0x4f')]);return db[_0x478d('0x64')][_0x478d('0x20')]({'where':_0x458e6f['where']})[_0x478d('0x27')](function(_0x12b5bd){_0x32a02b[_0x478d('0x20')]=_0x12b5bd;if(_0x2519f6[_0x478d('0x3a')][_0x478d('0x48')]){_0x458e6f[_0x478d('0x49')]=[{'all':!![]}];}return db[_0x478d('0x64')][_0x478d('0x4a')](_0x458e6f);})[_0x478d('0x27')](function(_0x31f7bc){_0x32a02b[_0x478d('0x4b')]=_0x31f7bc;return _0x32a02b;});}})[_0x478d('0x27')](respondWithFilteredResult(_0x578748,_0x458e6f))[_0x478d('0x4c')](handleError(_0x578748,null));};function char(_0xdcfa6f){return _0x478d('0x65')===typeof _0xdcfa6f?String[_0x478d('0x66')][_0x478d('0x24')](null,arguments):_0xdcfa6f;}function needsEncapsulation(_0x210af4){return!!_0x210af4&&(_0x210af4[_0x478d('0x67')]()[_0x478d('0x68')](char(0xd))>=0x0||_0x210af4[_0x478d('0x67')]()[_0x478d('0x68')](char(0xa))>=0x0||_0x210af4[_0x478d('0x67')]()[_0x478d('0x68')](char(0x2c))>=0x0||_0x210af4['toString']()[_0x478d('0x68')](char(0x22))>=0x0);}function encapsulate(_0x15287d){var _0x4eeac5=char(0x22),_0x65f60e='\x5c'+char(0x22),_0x57246d=_0x15287d[_0x478d('0x67')]()['replace'](new RegExp(_0x4eeac5,'g'),_0x65f60e);return _0x4eeac5+_0x57246d+_0x4eeac5;}exports['getSummary']=function(_0x5d9919,_0x3398ed,_0x45274c){var _0x5e245b,_0x3c3f52;var _0x1a9e75={'where':{'ProjectId':_0x5d9919[_0x478d('0x4e')]['id']}};if(_0x5d9919[_0x478d('0x3a')][_0x478d('0x69')]){_0x1a9e75['where']['starttime']=JSON[_0x478d('0x6a')](_0x5d9919[_0x478d('0x3a')]['startTime']);}return db['JscriptySessionReport'][_0x478d('0x4a')](_0x1a9e75)[_0x478d('0x27')](handleEntityNotFound(_0x3398ed,null))['then'](function(_0x48af5d){if(_0x48af5d){_0x5e245b=_0x48af5d;return db[_0x478d('0x6b')][_0x478d('0x4a')]({'where':{'SessionId':{'$in':_[_0x478d('0x34')](_0x5e245b,'id')},'ProjectId':_0x5d9919[_0x478d('0x4e')]['id']},'order':_0x478d('0x6c')});}})[_0x478d('0x27')](handleEntityNotFound(_0x3398ed,null))['then'](function(_0x2cb45c){if(_0x2cb45c){_0x3c3f52=_0x2cb45c;var _0x496b26={};for(var _0x2e55e6=0x0,_0xa3d2ff=_0x3c3f52[_0x478d('0x40')];_0x2e55e6<_0xa3d2ff;_0x2e55e6++){if(!_0x496b26[_0x478d('0x61')](_0x3c3f52[_0x2e55e6]['questionId'])){_0x496b26[_0x3c3f52[_0x2e55e6][_0x478d('0x6d')]]=needsEncapsulation(_0x3c3f52[_0x2e55e6][_0x478d('0x6e')])?encapsulate(_0x3c3f52[_0x2e55e6][_0x478d('0x6e')]):_0x3c3f52[_0x2e55e6][_0x478d('0x6e')];}}var _0x22ec38=[],_0x536bf0={};for(var _0x3addb7=0x0,_0x10e9e8=_0x5e245b[_0x478d('0x40')];_0x3addb7<_0x10e9e8;_0x3addb7++){_0x536bf0={'ProjectId':_0x5d9919['params']['id'],'SessionId':_0x5e245b[_0x3addb7]['id'],'StartTime':moment(_0x5e245b[_0x3addb7][_0x478d('0x6f')])[_0x478d('0x70')](_0x478d('0x71'))};for(var _0x3bb38c=0x0,_0x4cc53e=_0x3c3f52['length'];_0x3bb38c<_0x4cc53e;_0x3bb38c++){if(_0x3c3f52[_0x3bb38c][_0x478d('0x72')]==_0x5e245b[_0x3addb7]['id']&&_0x496b26[_0x478d('0x61')](_0x3c3f52[_0x3bb38c][_0x478d('0x6d')])){_0x536bf0[_0x496b26[_0x3c3f52[_0x3bb38c][_0x478d('0x6d')]]]=_0x3c3f52[_0x3bb38c][_0x478d('0x73')];}}for(var _0xc803e3 in _0x496b26){if(!_0x536bf0['hasOwnProperty'](_0x496b26[_0xc803e3])){_0x536bf0[_0x496b26[_0xc803e3]]=null;}}_0x22ec38[_0x478d('0x74')](_0x536bf0);}return _0x22ec38;}})[_0x478d('0x27')](function(_0x593511){if(!_['isEmpty'](_0x593511)){var _0x33be0e=toCsv(_0x593511);var _0x5be654=Date[_0x478d('0x75')]();fs['writeFileSync'](util[_0x478d('0x70')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x5d9919[_0x478d('0x4e')]['id'],_0x5be654),_0x33be0e);_0x3398ed[_0x478d('0x76')](_0x478d('0x77'),_0x478d('0x78')+util[_0x478d('0x70')](_0x478d('0x79'),_0x5d9919['params']['id'],_0x5be654));_0x3398ed['setHeader'](_0x478d('0x7a'),_0x478d('0x7b'));return _0x3398ed['download'](util[_0x478d('0x70')](_0x478d('0x7c'),_0x5d9919[_0x478d('0x4e')]['id'],_0x5be654));}else{return _0x3398ed[_0x478d('0x2b')](0xcc);}})[_0x478d('0x4c')](handleError(_0x3398ed,null));};