[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 _0xd4d9=['count','set','apply','update','then','end','error','name','send','index','map','JscriptySessionReport','rawAttributes','fieldName','type','key','model','keys','query','filters','attributes','intersection','fields','length','nolimit','order','sort','where','pick','merge','filter','options','includeAll','include','findAll','rows','catch','params','find','create','body','describe','getQuestions','findOne','JscriptyQuestionReport','hasOwnProperty','SessionId','eml-format','zip-dir','fast-json-patch','request-promise','bluebird','mustache','sox','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit'];(function(_0x449d15,_0x2d9974){var _0xb952bb=function(_0x3287e7){while(--_0x3287e7){_0x449d15['push'](_0x449d15['shift']());}};_0xb952bb(++_0x2d9974);}(_0xd4d9,0x7e));var _0x9d4d=function(_0x70cb68,_0x655078){_0x70cb68=_0x70cb68-0x0;var _0x7a453c=_0xd4d9[_0x70cb68];return _0x7a453c;};'use strict';var emlformat=require(_0x9d4d('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x9d4d('0x1'));var jsonpatch=require(_0x9d4d('0x2'));var rp=require(_0x9d4d('0x3'));var moment=require('moment');var BPromise=require(_0x9d4d('0x4'));var Mustache=require(_0x9d4d('0x5'));var util=require('util');var path=require('path');var sox=require(_0x9d4d('0x6'));var csv=require(_0x9d4d('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x9d4d('0x8'));var _=require(_0x9d4d('0x9'));var squel=require(_0x9d4d('0xa'));var crypto=require(_0x9d4d('0xb'));var jsforce=require(_0x9d4d('0xc'));var deskjs=require(_0x9d4d('0xd'));var toCsv=require(_0x9d4d('0x7'));var querystring=require(_0x9d4d('0xe'));var Papa=require(_0x9d4d('0xf'));var Redis=require(_0x9d4d('0x10'));var authService=require(_0x9d4d('0x11'));var qs=require(_0x9d4d('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x9d4d('0x13'));var logger=require(_0x9d4d('0x14'))(_0x9d4d('0x15'));var utils=require(_0x9d4d('0x16'));var config=require(_0x9d4d('0x17'));var licenseUtil=require(_0x9d4d('0x18'));var db=require(_0x9d4d('0x19'))['db'];function respondWithStatusCode(_0x40b80f,_0xcdafc){_0xcdafc=_0xcdafc||0xcc;return function(_0x259fca){if(_0x259fca){return _0x40b80f[_0x9d4d('0x1a')](_0xcdafc);}return _0x40b80f[_0x9d4d('0x1b')](_0xcdafc)['end']();};}function respondWithResult(_0x9e556b,_0x4cbd35){_0x4cbd35=_0x4cbd35||0xc8;return function(_0x28ef45){if(_0x28ef45){return _0x9e556b[_0x9d4d('0x1b')](_0x4cbd35)[_0x9d4d('0x1c')](_0x28ef45);}};}function respondWithFilteredResult(_0x3d1b06,_0x3fc645){return function(_0x1ab8ad){if(_0x1ab8ad){var _0x1f68d8=typeof _0x3fc645[_0x9d4d('0x1d')]===_0x9d4d('0x1e')&&typeof _0x3fc645[_0x9d4d('0x1f')]===_0x9d4d('0x1e');var _0x2d19d2=_0x1ab8ad['count'];var _0xdbb08a=_0x1f68d8?0x0:_0x3fc645[_0x9d4d('0x1d')];var _0x2b3f8=_0x1f68d8?_0x1ab8ad[_0x9d4d('0x20')]:_0x3fc645[_0x9d4d('0x1d')]+_0x3fc645[_0x9d4d('0x1f')];var _0xd2cbad;if(_0x2b3f8>=_0x2d19d2){_0x2b3f8=_0x2d19d2;_0xd2cbad=0xc8;}else{_0xd2cbad=0xce;}_0x3d1b06[_0x9d4d('0x1b')](_0xd2cbad);return _0x3d1b06[_0x9d4d('0x21')]('Content-Range',_0xdbb08a+'-'+_0x2b3f8+'/'+_0x2d19d2)[_0x9d4d('0x1c')](_0x1ab8ad);}return null;};}function patchUpdates(_0x290fc2){return function(_0x2a8c7a){try{jsonpatch[_0x9d4d('0x22')](_0x2a8c7a,_0x290fc2,!![]);}catch(_0x309830){return BPromise['reject'](_0x309830);}return _0x2a8c7a['save']();};}function saveUpdates(_0xe0687f,_0x2b0fdc){return function(_0x3e98a2){if(_0x3e98a2){return _0x3e98a2[_0x9d4d('0x23')](_0xe0687f)[_0x9d4d('0x24')](function(_0x546837){return _0x546837;});}return null;};}function removeEntity(_0x3c7c85,_0x1b22ac){return function(_0x333a12){if(_0x333a12){return _0x333a12['destroy']()[_0x9d4d('0x24')](function(){_0x3c7c85[_0x9d4d('0x1b')](0xcc)[_0x9d4d('0x25')]();});}};}function handleEntityNotFound(_0x522403,_0x487c76){return function(_0xe2732e){if(!_0xe2732e){_0x522403[_0x9d4d('0x1a')](0x194);}return _0xe2732e;};}function handleError(_0x25c729,_0x4de29f){_0x4de29f=_0x4de29f||0x1f4;return function(_0x1d8eb5){logger[_0x9d4d('0x26')](_0x1d8eb5['stack']);if(_0x1d8eb5[_0x9d4d('0x27')]){delete _0x1d8eb5[_0x9d4d('0x27')];}_0x25c729[_0x9d4d('0x1b')](_0x4de29f)[_0x9d4d('0x28')](_0x1d8eb5);};}exports[_0x9d4d('0x29')]=function(_0x1eb9de,_0x5ed2ec){var _0x4a289d={},_0x4613f0={},_0x357c46={'count':0x0,'rows':[]};var _0x1da40b=_[_0x9d4d('0x2a')](db[_0x9d4d('0x2b')][_0x9d4d('0x2c')],function(_0x48f47e){return{'name':_0x48f47e[_0x9d4d('0x2d')],'type':_0x48f47e[_0x9d4d('0x2e')][_0x9d4d('0x2f')]};});_0x4613f0[_0x9d4d('0x30')]=_[_0x9d4d('0x2a')](_0x1da40b,_0x9d4d('0x27'));_0x4613f0['query']=_[_0x9d4d('0x31')](_0x1eb9de[_0x9d4d('0x32')]);_0x4613f0[_0x9d4d('0x33')]=_['intersection'](_0x4613f0[_0x9d4d('0x30')],_0x4613f0[_0x9d4d('0x32')]);_0x4a289d[_0x9d4d('0x34')]=_[_0x9d4d('0x35')](_0x4613f0['model'],qs[_0x9d4d('0x36')](_0x1eb9de[_0x9d4d('0x32')][_0x9d4d('0x36')]));_0x4a289d[_0x9d4d('0x34')]=_0x4a289d[_0x9d4d('0x34')][_0x9d4d('0x37')]?_0x4a289d[_0x9d4d('0x34')]:_0x4613f0['model'];if(!_0x1eb9de[_0x9d4d('0x32')]['hasOwnProperty'](_0x9d4d('0x38'))){_0x4a289d[_0x9d4d('0x1f')]=qs[_0x9d4d('0x1f')](_0x1eb9de['query']['limit']);_0x4a289d['offset']=qs[_0x9d4d('0x1d')](_0x1eb9de['query'][_0x9d4d('0x1d')]);}_0x4a289d[_0x9d4d('0x39')]=qs[_0x9d4d('0x3a')](_0x1eb9de['query']['sort']);_0x4a289d[_0x9d4d('0x3b')]=qs[_0x9d4d('0x33')](_[_0x9d4d('0x3c')](_0x1eb9de[_0x9d4d('0x32')],_0x4613f0[_0x9d4d('0x33')]),_0x1da40b);if(_0x1eb9de[_0x9d4d('0x32')]['filter']){_0x4a289d[_0x9d4d('0x3b')]=_[_0x9d4d('0x3d')](_0x4a289d['where'],{'$or':_[_0x9d4d('0x2a')](_0x1da40b,function(_0xb702ac){if(_0xb702ac[_0x9d4d('0x2e')]!=='VIRTUAL'){var _0x35bcc7={};_0x35bcc7[_0xb702ac[_0x9d4d('0x27')]]={'$like':'%'+_0x1eb9de[_0x9d4d('0x32')][_0x9d4d('0x3e')]+'%'};return _0x35bcc7;}})});}_0x4a289d=_[_0x9d4d('0x3d')]({},_0x4a289d,_0x1eb9de[_0x9d4d('0x3f')]);var _0x4ab929={'where':_0x4a289d['where']};return db[_0x9d4d('0x2b')][_0x9d4d('0x20')](_0x4ab929)[_0x9d4d('0x24')](function(_0x5d9b97){_0x357c46['count']=_0x5d9b97;if(_0x1eb9de[_0x9d4d('0x32')][_0x9d4d('0x40')]){_0x4a289d[_0x9d4d('0x41')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x9d4d('0x42')](_0x4a289d);})['then'](function(_0x2a3f79){_0x357c46[_0x9d4d('0x43')]=_0x2a3f79;return _0x357c46;})['then'](respondWithFilteredResult(_0x5ed2ec,_0x4a289d))[_0x9d4d('0x44')](handleError(_0x5ed2ec,null));};exports['show']=function(_0x17d164,_0x473ef6){var _0x571fe1={'raw':!![],'where':{'id':_0x17d164[_0x9d4d('0x45')]['id']}},_0x412cd7={};_0x412cd7[_0x9d4d('0x30')]=_[_0x9d4d('0x31')](db[_0x9d4d('0x2b')][_0x9d4d('0x2c')]);_0x412cd7['query']=_['keys'](_0x17d164[_0x9d4d('0x32')]);_0x412cd7[_0x9d4d('0x33')]=_[_0x9d4d('0x35')](_0x412cd7['model'],_0x412cd7[_0x9d4d('0x32')]);_0x571fe1[_0x9d4d('0x34')]=_[_0x9d4d('0x35')](_0x412cd7[_0x9d4d('0x30')],qs[_0x9d4d('0x36')](_0x17d164['query']['fields']));_0x571fe1['attributes']=_0x571fe1[_0x9d4d('0x34')][_0x9d4d('0x37')]?_0x571fe1['attributes']:_0x412cd7[_0x9d4d('0x30')];if(_0x17d164['query']['includeAll']){_0x571fe1['include']=[{'all':!![]}];}_0x571fe1=_[_0x9d4d('0x3d')]({},_0x571fe1,_0x17d164[_0x9d4d('0x3f')]);return db[_0x9d4d('0x2b')][_0x9d4d('0x46')](_0x571fe1)[_0x9d4d('0x24')](handleEntityNotFound(_0x473ef6,null))[_0x9d4d('0x24')](respondWithResult(_0x473ef6,null))[_0x9d4d('0x44')](handleError(_0x473ef6,null));};exports[_0x9d4d('0x47')]=function(_0x5b31b0,_0x1a897a){return db['JscriptySessionReport']['create'](_0x5b31b0[_0x9d4d('0x48')],{})['then'](respondWithResult(_0x1a897a,0xc9))[_0x9d4d('0x44')](handleError(_0x1a897a,null));};exports[_0x9d4d('0x23')]=function(_0x20dfac,_0x3ea628){if(_0x20dfac[_0x9d4d('0x48')]['id']){delete _0x20dfac[_0x9d4d('0x48')]['id'];}return db[_0x9d4d('0x2b')][_0x9d4d('0x46')]({'where':{'id':_0x20dfac[_0x9d4d('0x45')]['id']}})[_0x9d4d('0x24')](handleEntityNotFound(_0x3ea628,null))[_0x9d4d('0x24')](saveUpdates(_0x20dfac['body'],null))[_0x9d4d('0x24')](respondWithResult(_0x3ea628,null))['catch'](handleError(_0x3ea628,null));};exports['destroy']=function(_0x19da8d,_0x309f79){return db[_0x9d4d('0x2b')]['find']({'where':{'id':_0x19da8d[_0x9d4d('0x45')]['id']}})['then'](handleEntityNotFound(_0x309f79,null))[_0x9d4d('0x24')](removeEntity(_0x309f79,null))[_0x9d4d('0x44')](handleError(_0x309f79,null));};exports[_0x9d4d('0x49')]=function(_0x5d2db8,_0x5c036){return db[_0x9d4d('0x2b')][_0x9d4d('0x49')]()[_0x9d4d('0x24')](respondWithResult(_0x5c036,null))['catch'](handleError(_0x5c036,null));};exports[_0x9d4d('0x4a')]=function(_0x3b40cd,_0x44b543,_0x19c4ff){var _0x2ddfdb={'raw':!![],'where':{}};var _0x59763e={};var _0x6d32a9={'count':0x0,'rows':[]};return db[_0x9d4d('0x2b')][_0x9d4d('0x4b')]({'where':{'id':_0x3b40cd[_0x9d4d('0x45')]['id']}})['then'](handleEntityNotFound(_0x44b543,null))[_0x9d4d('0x24')](function(_0x4d4374){if(_0x4d4374){_0x59763e[_0x9d4d('0x30')]=_[_0x9d4d('0x31')](db[_0x9d4d('0x4c')]['rawAttributes']);_0x59763e[_0x9d4d('0x32')]=_[_0x9d4d('0x31')](_0x3b40cd[_0x9d4d('0x32')]);_0x59763e[_0x9d4d('0x33')]=_[_0x9d4d('0x35')](_0x59763e[_0x9d4d('0x30')],_0x59763e['query']);_0x2ddfdb[_0x9d4d('0x34')]=_['intersection'](_0x59763e[_0x9d4d('0x30')],qs['fields'](_0x3b40cd[_0x9d4d('0x32')][_0x9d4d('0x36')]));_0x2ddfdb['attributes']=_0x2ddfdb[_0x9d4d('0x34')][_0x9d4d('0x37')]?_0x2ddfdb[_0x9d4d('0x34')]:_0x59763e[_0x9d4d('0x30')];if(!_0x3b40cd['query'][_0x9d4d('0x4d')](_0x9d4d('0x38'))){_0x2ddfdb[_0x9d4d('0x1f')]=qs[_0x9d4d('0x1f')](_0x3b40cd['query']['limit']);_0x2ddfdb[_0x9d4d('0x1d')]=qs[_0x9d4d('0x1d')](_0x3b40cd[_0x9d4d('0x32')][_0x9d4d('0x1d')]);}_0x2ddfdb[_0x9d4d('0x39')]=qs[_0x9d4d('0x3a')](_0x3b40cd[_0x9d4d('0x32')][_0x9d4d('0x3a')]);_0x2ddfdb[_0x9d4d('0x3b')]=qs['filters'](_[_0x9d4d('0x3c')](_0x3b40cd[_0x9d4d('0x32')],_0x59763e[_0x9d4d('0x33')]));_0x2ddfdb[_0x9d4d('0x3b')][_0x9d4d('0x4e')]=_0x4d4374['id'];if(_0x3b40cd[_0x9d4d('0x32')][_0x9d4d('0x3e')]){_0x2ddfdb['where']=_[_0x9d4d('0x3d')](_0x2ddfdb[_0x9d4d('0x3b')],{'$or':_[_0x9d4d('0x2a')](_0x2ddfdb[_0x9d4d('0x34')],function(_0x1ce7f8){var _0x14e0a5={};_0x14e0a5[_0x1ce7f8]={'$like':'%'+_0x3b40cd[_0x9d4d('0x32')][_0x9d4d('0x3e')]+'%'};return _0x14e0a5;})});}_0x2ddfdb=_[_0x9d4d('0x3d')]({},_0x2ddfdb,_0x3b40cd[_0x9d4d('0x3f')]);return db[_0x9d4d('0x4c')][_0x9d4d('0x20')]({'where':_0x2ddfdb[_0x9d4d('0x3b')]})[_0x9d4d('0x24')](function(_0x1e6447){_0x6d32a9[_0x9d4d('0x20')]=_0x1e6447;if(_0x3b40cd['query']['includeAll']){_0x2ddfdb[_0x9d4d('0x41')]=[{'all':!![]}];}return db[_0x9d4d('0x4c')][_0x9d4d('0x42')](_0x2ddfdb);})[_0x9d4d('0x24')](function(_0x5afadf){_0x6d32a9['rows']=_0x5afadf;return _0x6d32a9;});}})['then'](respondWithFilteredResult(_0x44b543,_0x2ddfdb))[_0x9d4d('0x44')](handleError(_0x44b543,null));};