[motion2.git] / server / api / jscriptySessionReport / jscriptySessionReport.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x3ce9=['catch','create','body','find','describe','getQuestions','params','JscriptyQuestionReport','nolimit','SessionId','include','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','path','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','limit','offset','count','set','Content-Range','apply','update','destroy','error','stack','name','index','map','JscriptySessionReport','fieldName','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','merge','VIRTUAL','filter','options','then','includeAll','findAll','rows','show','rawAttributes'];(function(_0x3a58de,_0x5e7d69){var _0xfd2a28=function(_0x399de5){while(--_0x399de5){_0x3a58de['push'](_0x3a58de['shift']());}};_0xfd2a28(++_0x5e7d69);}(_0x3ce9,0xf8));var _0x93ce=function(_0x489ce5,_0x431c16){_0x489ce5=_0x489ce5-0x0;var _0x413132=_0x3ce9[_0x489ce5];return _0x413132;};'use strict';var emlformat=require(_0x93ce('0x0'));var rimraf=require(_0x93ce('0x1'));var zipdir=require(_0x93ce('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x93ce('0x3'));var moment=require(_0x93ce('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x93ce('0x5'));var util=require(_0x93ce('0x6'));var path=require(_0x93ce('0x7'));var sox=require('sox');var csv=require(_0x93ce('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x93ce('0x9'));var _=require(_0x93ce('0xa'));var squel=require(_0x93ce('0xb'));var crypto=require(_0x93ce('0xc'));var jsforce=require(_0x93ce('0xd'));var deskjs=require(_0x93ce('0xe'));var toCsv=require(_0x93ce('0x8'));var querystring=require(_0x93ce('0xf'));var Papa=require(_0x93ce('0x10'));var Redis=require(_0x93ce('0x11'));var authService=require(_0x93ce('0x12'));var qs=require(_0x93ce('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x93ce('0x14'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require(_0x93ce('0x15'));var licenseUtil=require(_0x93ce('0x16'));var db=require(_0x93ce('0x17'))['db'];function respondWithStatusCode(_0xb0b2b8,_0x160ed7){_0x160ed7=_0x160ed7||0xcc;return function(_0x3f6d43){if(_0x3f6d43){return _0xb0b2b8[_0x93ce('0x18')](_0x160ed7);}return _0xb0b2b8[_0x93ce('0x19')](_0x160ed7)[_0x93ce('0x1a')]();};}function respondWithResult(_0x1d1e26,_0x22cac0){_0x22cac0=_0x22cac0||0xc8;return function(_0x11b690){if(_0x11b690){return _0x1d1e26[_0x93ce('0x19')](_0x22cac0)[_0x93ce('0x1b')](_0x11b690);}};}function respondWithFilteredResult(_0x1228f0,_0x1625ef){return function(_0x349e92){if(_0x349e92){var _0x41bdc3=typeof _0x1625ef['offset']===_0x93ce('0x1c')&&typeof _0x1625ef[_0x93ce('0x1d')]==='undefined';var _0x2ce3bb=_0x349e92['count'];var _0x3b818a=_0x41bdc3?0x0:_0x1625ef[_0x93ce('0x1e')];var _0x25a762=_0x41bdc3?_0x349e92[_0x93ce('0x1f')]:_0x1625ef[_0x93ce('0x1e')]+_0x1625ef[_0x93ce('0x1d')];var _0x4b6d44;if(_0x25a762>=_0x2ce3bb){_0x25a762=_0x2ce3bb;_0x4b6d44=0xc8;}else{_0x4b6d44=0xce;}_0x1228f0[_0x93ce('0x19')](_0x4b6d44);return _0x1228f0[_0x93ce('0x20')](_0x93ce('0x21'),_0x3b818a+'-'+_0x25a762+'/'+_0x2ce3bb)['json'](_0x349e92);}return null;};}function patchUpdates(_0x108ef7){return function(_0x272444){try{jsonpatch[_0x93ce('0x22')](_0x272444,_0x108ef7,!![]);}catch(_0x526188){return BPromise['reject'](_0x526188);}return _0x272444['save']();};}function saveUpdates(_0x12a9e9,_0x50d89f){return function(_0x2a2274){if(_0x2a2274){return _0x2a2274[_0x93ce('0x23')](_0x12a9e9)['then'](function(_0x40d2e5){return _0x40d2e5;});}return null;};}function removeEntity(_0x218974,_0x2b21a2){return function(_0xd9992c){if(_0xd9992c){return _0xd9992c[_0x93ce('0x24')]()['then'](function(){_0x218974[_0x93ce('0x19')](0xcc)[_0x93ce('0x1a')]();});}};}function handleEntityNotFound(_0x5334cc,_0x118f08){return function(_0x436b38){if(!_0x436b38){_0x5334cc[_0x93ce('0x18')](0x194);}return _0x436b38;};}function handleError(_0x4c2666,_0x470a7a){_0x470a7a=_0x470a7a||0x1f4;return function(_0x58c00a){logger[_0x93ce('0x25')](_0x58c00a[_0x93ce('0x26')]);if(_0x58c00a[_0x93ce('0x27')]){delete _0x58c00a['name'];}_0x4c2666[_0x93ce('0x19')](_0x470a7a)['send'](_0x58c00a);};}exports[_0x93ce('0x28')]=function(_0x178dde,_0x1a6d7b){var _0x2f34bc={},_0x1b150e={},_0x5e06b0={'count':0x0,'rows':[]};var _0x203588=_[_0x93ce('0x29')](db[_0x93ce('0x2a')]['rawAttributes'],function(_0x5f2b90){return{'name':_0x5f2b90[_0x93ce('0x2b')],'type':_0x5f2b90[_0x93ce('0x2c')]['key']};});_0x1b150e[_0x93ce('0x2d')]=_['map'](_0x203588,'name');_0x1b150e[_0x93ce('0x2e')]=_[_0x93ce('0x2f')](_0x178dde[_0x93ce('0x2e')]);_0x1b150e[_0x93ce('0x30')]=_[_0x93ce('0x31')](_0x1b150e[_0x93ce('0x2d')],_0x1b150e[_0x93ce('0x2e')]);_0x2f34bc[_0x93ce('0x32')]=_['intersection'](_0x1b150e[_0x93ce('0x2d')],qs[_0x93ce('0x33')](_0x178dde['query']['fields']));_0x2f34bc[_0x93ce('0x32')]=_0x2f34bc['attributes'][_0x93ce('0x34')]?_0x2f34bc['attributes']:_0x1b150e[_0x93ce('0x2d')];if(!_0x178dde[_0x93ce('0x2e')][_0x93ce('0x35')]('nolimit')){_0x2f34bc['limit']=qs[_0x93ce('0x1d')](_0x178dde['query']['limit']);_0x2f34bc[_0x93ce('0x1e')]=qs[_0x93ce('0x1e')](_0x178dde[_0x93ce('0x2e')][_0x93ce('0x1e')]);}_0x2f34bc[_0x93ce('0x36')]=qs['sort'](_0x178dde['query'][_0x93ce('0x37')]);_0x2f34bc[_0x93ce('0x38')]=qs[_0x93ce('0x30')](_[_0x93ce('0x39')](_0x178dde[_0x93ce('0x2e')],_0x1b150e[_0x93ce('0x30')]),_0x203588);if(_0x178dde[_0x93ce('0x2e')]['filter']){_0x2f34bc[_0x93ce('0x38')]=_[_0x93ce('0x3a')](_0x2f34bc[_0x93ce('0x38')],{'$or':_[_0x93ce('0x29')](_0x203588,function(_0x30ac47){if(_0x30ac47[_0x93ce('0x2c')]!==_0x93ce('0x3b')){var _0x46bac1={};_0x46bac1[_0x30ac47[_0x93ce('0x27')]]={'$like':'%'+_0x178dde[_0x93ce('0x2e')][_0x93ce('0x3c')]+'%'};return _0x46bac1;}})});}_0x2f34bc=_[_0x93ce('0x3a')]({},_0x2f34bc,_0x178dde[_0x93ce('0x3d')]);var _0x388967={'where':_0x2f34bc[_0x93ce('0x38')]};return db['JscriptySessionReport']['count'](_0x388967)[_0x93ce('0x3e')](function(_0x2c676f){_0x5e06b0[_0x93ce('0x1f')]=_0x2c676f;if(_0x178dde[_0x93ce('0x2e')][_0x93ce('0x3f')]){_0x2f34bc['include']=[{'all':!![]}];}return db[_0x93ce('0x2a')][_0x93ce('0x40')](_0x2f34bc);})[_0x93ce('0x3e')](function(_0x316154){_0x5e06b0[_0x93ce('0x41')]=_0x316154;return _0x5e06b0;})[_0x93ce('0x3e')](respondWithFilteredResult(_0x1a6d7b,_0x2f34bc))['catch'](handleError(_0x1a6d7b,null));};exports[_0x93ce('0x42')]=function(_0x5a5c54,_0xd9e901){var _0x35ca6a={'raw':!![],'where':{'id':_0x5a5c54['params']['id']}},_0x3a3632={};_0x3a3632[_0x93ce('0x2d')]=_[_0x93ce('0x2f')](db[_0x93ce('0x2a')][_0x93ce('0x43')]);_0x3a3632[_0x93ce('0x2e')]=_[_0x93ce('0x2f')](_0x5a5c54[_0x93ce('0x2e')]);_0x3a3632[_0x93ce('0x30')]=_[_0x93ce('0x31')](_0x3a3632['model'],_0x3a3632['query']);_0x35ca6a[_0x93ce('0x32')]=_[_0x93ce('0x31')](_0x3a3632[_0x93ce('0x2d')],qs[_0x93ce('0x33')](_0x5a5c54[_0x93ce('0x2e')][_0x93ce('0x33')]));_0x35ca6a[_0x93ce('0x32')]=_0x35ca6a[_0x93ce('0x32')]['length']?_0x35ca6a[_0x93ce('0x32')]:_0x3a3632[_0x93ce('0x2d')];if(_0x5a5c54[_0x93ce('0x2e')][_0x93ce('0x3f')]){_0x35ca6a['include']=[{'all':!![]}];}_0x35ca6a=_[_0x93ce('0x3a')]({},_0x35ca6a,_0x5a5c54[_0x93ce('0x3d')]);return db[_0x93ce('0x2a')]['find'](_0x35ca6a)[_0x93ce('0x3e')](handleEntityNotFound(_0xd9e901,null))[_0x93ce('0x3e')](respondWithResult(_0xd9e901,null))[_0x93ce('0x44')](handleError(_0xd9e901,null));};exports['create']=function(_0x3d8526,_0x1a7998){return db[_0x93ce('0x2a')][_0x93ce('0x45')](_0x3d8526[_0x93ce('0x46')],{})[_0x93ce('0x3e')](respondWithResult(_0x1a7998,0xc9))[_0x93ce('0x44')](handleError(_0x1a7998,null));};exports[_0x93ce('0x23')]=function(_0x29e375,_0x13f2c3){if(_0x29e375['body']['id']){delete _0x29e375['body']['id'];}return db[_0x93ce('0x2a')][_0x93ce('0x47')]({'where':{'id':_0x29e375['params']['id']}})['then'](handleEntityNotFound(_0x13f2c3,null))[_0x93ce('0x3e')](saveUpdates(_0x29e375[_0x93ce('0x46')],null))[_0x93ce('0x3e')](respondWithResult(_0x13f2c3,null))[_0x93ce('0x44')](handleError(_0x13f2c3,null));};exports['destroy']=function(_0x1efff7,_0x2fc296){return db[_0x93ce('0x2a')][_0x93ce('0x47')]({'where':{'id':_0x1efff7['params']['id']}})['then'](handleEntityNotFound(_0x2fc296,null))[_0x93ce('0x3e')](removeEntity(_0x2fc296,null))['catch'](handleError(_0x2fc296,null));};exports[_0x93ce('0x48')]=function(_0x46fec0,_0x58d9e0){return db['JscriptySessionReport'][_0x93ce('0x48')]()['then'](respondWithResult(_0x58d9e0,null))[_0x93ce('0x44')](handleError(_0x58d9e0,null));};exports[_0x93ce('0x49')]=function(_0x252804,_0x406149,_0x13cca1){var _0x196473={'raw':!![],'where':{}};var _0x4dcbe6={};var _0x50afeb={'count':0x0,'rows':[]};return db[_0x93ce('0x2a')]['findOne']({'where':{'id':_0x252804[_0x93ce('0x4a')]['id']}})[_0x93ce('0x3e')](handleEntityNotFound(_0x406149,null))['then'](function(_0x3cddd4){if(_0x3cddd4){_0x4dcbe6[_0x93ce('0x2d')]=_[_0x93ce('0x2f')](db[_0x93ce('0x4b')][_0x93ce('0x43')]);_0x4dcbe6[_0x93ce('0x2e')]=_[_0x93ce('0x2f')](_0x252804[_0x93ce('0x2e')]);_0x4dcbe6[_0x93ce('0x30')]=_[_0x93ce('0x31')](_0x4dcbe6[_0x93ce('0x2d')],_0x4dcbe6[_0x93ce('0x2e')]);_0x196473['attributes']=_[_0x93ce('0x31')](_0x4dcbe6['model'],qs[_0x93ce('0x33')](_0x252804['query'][_0x93ce('0x33')]));_0x196473[_0x93ce('0x32')]=_0x196473[_0x93ce('0x32')][_0x93ce('0x34')]?_0x196473['attributes']:_0x4dcbe6[_0x93ce('0x2d')];if(!_0x252804[_0x93ce('0x2e')]['hasOwnProperty'](_0x93ce('0x4c'))){_0x196473['limit']=qs['limit'](_0x252804[_0x93ce('0x2e')][_0x93ce('0x1d')]);_0x196473[_0x93ce('0x1e')]=qs[_0x93ce('0x1e')](_0x252804[_0x93ce('0x2e')]['offset']);}_0x196473[_0x93ce('0x36')]=qs['sort'](_0x252804[_0x93ce('0x2e')][_0x93ce('0x37')]);_0x196473[_0x93ce('0x38')]=qs[_0x93ce('0x30')](_['pick'](_0x252804['query'],_0x4dcbe6[_0x93ce('0x30')]));_0x196473[_0x93ce('0x38')][_0x93ce('0x4d')]=_0x3cddd4['id'];if(_0x252804[_0x93ce('0x2e')]['filter']){_0x196473['where']=_[_0x93ce('0x3a')](_0x196473[_0x93ce('0x38')],{'$or':_[_0x93ce('0x29')](_0x196473['attributes'],function(_0x1fa696){var _0x53eb74={};_0x53eb74[_0x1fa696]={'$like':'%'+_0x252804['query'][_0x93ce('0x3c')]+'%'};return _0x53eb74;})});}_0x196473=_['merge']({},_0x196473,_0x252804['options']);return db[_0x93ce('0x4b')][_0x93ce('0x1f')]({'where':_0x196473[_0x93ce('0x38')]})['then'](function(_0x1aea2d){_0x50afeb[_0x93ce('0x1f')]=_0x1aea2d;if(_0x252804['query'][_0x93ce('0x3f')]){_0x196473[_0x93ce('0x4e')]=[{'all':!![]}];}return db[_0x93ce('0x4b')][_0x93ce('0x40')](_0x196473);})['then'](function(_0x5e7bec){_0x50afeb[_0x93ce('0x41')]=_0x5e7bec;return _0x50afeb;});}})[_0x93ce('0x3e')](respondWithFilteredResult(_0x406149,_0x196473))[_0x93ce('0x44')](handleError(_0x406149,null));};