[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 _0x363a=['intersection','attributes','fields','nolimit','order','sort','where','pick','VIRTUAL','filter','count','includeAll','include','JscriptySessionReport','findAll','rows','catch','show','params','keys','length','merge','options','find','create','body','describe','findOne','JscriptyQuestionReport','hasOwnProperty','SessionId','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','undefined','limit','offset','set','Content-Range','reject','save','update','then','destroy','error','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','filters'];(function(_0x486061,_0x59ec2f){var _0x5ce3a7=function(_0x15efcc){while(--_0x15efcc){_0x486061['push'](_0x486061['shift']());}};_0x5ce3a7(++_0x59ec2f);}(_0x363a,0x115));var _0xa363=function(_0x7148b6,_0xa61534){_0x7148b6=_0x7148b6-0x0;var _0x111019=_0x363a[_0x7148b6];return _0x111019;};'use strict';var emlformat=require(_0xa363('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xa363('0x1'));var jsonpatch=require(_0xa363('0x2'));var rp=require(_0xa363('0x3'));var moment=require(_0xa363('0x4'));var BPromise=require(_0xa363('0x5'));var Mustache=require(_0xa363('0x6'));var util=require(_0xa363('0x7'));var path=require('path');var sox=require(_0xa363('0x8'));var csv=require(_0xa363('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xa363('0xa'));var squel=require(_0xa363('0xb'));var crypto=require(_0xa363('0xc'));var jsforce=require(_0xa363('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xa363('0x9'));var querystring=require(_0xa363('0xe'));var Papa=require(_0xa363('0xf'));var Redis=require(_0xa363('0x10'));var authService=require(_0xa363('0x11'));var qs=require(_0xa363('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xa363('0x13'))(_0xa363('0x14'));var utils=require(_0xa363('0x15'));var config=require(_0xa363('0x16'));var licenseUtil=require(_0xa363('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x24adff,_0x53a45d){_0x53a45d=_0x53a45d||0xcc;return function(_0x1a6cfe){if(_0x1a6cfe){return _0x24adff[_0xa363('0x18')](_0x53a45d);}return _0x24adff[_0xa363('0x19')](_0x53a45d)[_0xa363('0x1a')]();};}function respondWithResult(_0xbadf4a,_0x1c830a){_0x1c830a=_0x1c830a||0xc8;return function(_0x4a5b39){if(_0x4a5b39){return _0xbadf4a['status'](_0x1c830a)[_0xa363('0x1b')](_0x4a5b39);}};}function respondWithFilteredResult(_0x50001d,_0x2e6eaf){return function(_0x133349){if(_0x133349){var _0x3556d7=typeof _0x2e6eaf['offset']===_0xa363('0x1c')&&typeof _0x2e6eaf[_0xa363('0x1d')]==='undefined';var _0x2b49d6=_0x133349['count'];var _0x2ef5a0=_0x3556d7?0x0:_0x2e6eaf['offset'];var _0x1d0f2a=_0x3556d7?_0x133349['count']:_0x2e6eaf[_0xa363('0x1e')]+_0x2e6eaf[_0xa363('0x1d')];var _0x2f93a5;if(_0x1d0f2a>=_0x2b49d6){_0x1d0f2a=_0x2b49d6;_0x2f93a5=0xc8;}else{_0x2f93a5=0xce;}_0x50001d['status'](_0x2f93a5);return _0x50001d[_0xa363('0x1f')](_0xa363('0x20'),_0x2ef5a0+'-'+_0x1d0f2a+'/'+_0x2b49d6)['json'](_0x133349);}return null;};}function patchUpdates(_0x18d3fe){return function(_0x116862){try{jsonpatch['apply'](_0x116862,_0x18d3fe,!![]);}catch(_0x45f397){return BPromise[_0xa363('0x21')](_0x45f397);}return _0x116862[_0xa363('0x22')]();};}function saveUpdates(_0x3286f8,_0x14ab5c){return function(_0x4ef4f9){if(_0x4ef4f9){return _0x4ef4f9[_0xa363('0x23')](_0x3286f8)[_0xa363('0x24')](function(_0x112e67){return _0x112e67;});}return null;};}function removeEntity(_0x432e94,_0x295e0c){return function(_0x4cdcbd){if(_0x4cdcbd){return _0x4cdcbd[_0xa363('0x25')]()[_0xa363('0x24')](function(){_0x432e94[_0xa363('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x43e119,_0x37a2e7){return function(_0x8b3846){if(!_0x8b3846){_0x43e119['sendStatus'](0x194);}return _0x8b3846;};}function handleError(_0x3fcea7,_0x4a547d){_0x4a547d=_0x4a547d||0x1f4;return function(_0x38f482){logger[_0xa363('0x26')](_0x38f482[_0xa363('0x27')]);if(_0x38f482[_0xa363('0x28')]){delete _0x38f482[_0xa363('0x28')];}_0x3fcea7[_0xa363('0x19')](_0x4a547d)[_0xa363('0x29')](_0x38f482);};}exports[_0xa363('0x2a')]=function(_0x47ebf9,_0x203821){var _0x506773={},_0x4a6cc8={},_0x1a8acd={'count':0x0,'rows':[]};var _0x27febf=_[_0xa363('0x2b')](db['JscriptySessionReport'][_0xa363('0x2c')],function(_0x3206c7){return{'name':_0x3206c7[_0xa363('0x2d')],'type':_0x3206c7[_0xa363('0x2e')][_0xa363('0x2f')]};});_0x4a6cc8[_0xa363('0x30')]=_[_0xa363('0x2b')](_0x27febf,_0xa363('0x28'));_0x4a6cc8['query']=_['keys'](_0x47ebf9[_0xa363('0x31')]);_0x4a6cc8[_0xa363('0x32')]=_[_0xa363('0x33')](_0x4a6cc8[_0xa363('0x30')],_0x4a6cc8[_0xa363('0x31')]);_0x506773[_0xa363('0x34')]=_[_0xa363('0x33')](_0x4a6cc8[_0xa363('0x30')],qs[_0xa363('0x35')](_0x47ebf9[_0xa363('0x31')][_0xa363('0x35')]));_0x506773[_0xa363('0x34')]=_0x506773[_0xa363('0x34')]['length']?_0x506773['attributes']:_0x4a6cc8[_0xa363('0x30')];if(!_0x47ebf9[_0xa363('0x31')]['hasOwnProperty'](_0xa363('0x36'))){_0x506773[_0xa363('0x1d')]=qs[_0xa363('0x1d')](_0x47ebf9[_0xa363('0x31')][_0xa363('0x1d')]);_0x506773[_0xa363('0x1e')]=qs[_0xa363('0x1e')](_0x47ebf9['query']['offset']);}_0x506773[_0xa363('0x37')]=qs[_0xa363('0x38')](_0x47ebf9[_0xa363('0x31')]['sort']);_0x506773[_0xa363('0x39')]=qs[_0xa363('0x32')](_[_0xa363('0x3a')](_0x47ebf9[_0xa363('0x31')],_0x4a6cc8['filters']),_0x27febf);if(_0x47ebf9[_0xa363('0x31')]['filter']){_0x506773['where']=_['merge'](_0x506773['where'],{'$or':_[_0xa363('0x2b')](_0x27febf,function(_0x2b4aa8){if(_0x2b4aa8[_0xa363('0x2e')]!==_0xa363('0x3b')){var _0x3cee22={};_0x3cee22[_0x2b4aa8[_0xa363('0x28')]]={'$like':'%'+_0x47ebf9[_0xa363('0x31')][_0xa363('0x3c')]+'%'};return _0x3cee22;}})});}_0x506773=_['merge']({},_0x506773,_0x47ebf9['options']);var _0x33457d={'where':_0x506773[_0xa363('0x39')]};return db['JscriptySessionReport']['count'](_0x33457d)[_0xa363('0x24')](function(_0x50672a){_0x1a8acd[_0xa363('0x3d')]=_0x50672a;if(_0x47ebf9[_0xa363('0x31')][_0xa363('0x3e')]){_0x506773[_0xa363('0x3f')]=[{'all':!![]}];}return db[_0xa363('0x40')][_0xa363('0x41')](_0x506773);})[_0xa363('0x24')](function(_0x22270f){_0x1a8acd[_0xa363('0x42')]=_0x22270f;return _0x1a8acd;})[_0xa363('0x24')](respondWithFilteredResult(_0x203821,_0x506773))[_0xa363('0x43')](handleError(_0x203821,null));};exports[_0xa363('0x44')]=function(_0x436dfa,_0x488307){var _0x2465a5={'raw':!![],'where':{'id':_0x436dfa[_0xa363('0x45')]['id']}},_0x1f31f2={};_0x1f31f2['model']=_[_0xa363('0x46')](db[_0xa363('0x40')][_0xa363('0x2c')]);_0x1f31f2[_0xa363('0x31')]=_['keys'](_0x436dfa['query']);_0x1f31f2['filters']=_['intersection'](_0x1f31f2[_0xa363('0x30')],_0x1f31f2[_0xa363('0x31')]);_0x2465a5[_0xa363('0x34')]=_[_0xa363('0x33')](_0x1f31f2[_0xa363('0x30')],qs[_0xa363('0x35')](_0x436dfa[_0xa363('0x31')][_0xa363('0x35')]));_0x2465a5[_0xa363('0x34')]=_0x2465a5['attributes'][_0xa363('0x47')]?_0x2465a5[_0xa363('0x34')]:_0x1f31f2[_0xa363('0x30')];if(_0x436dfa[_0xa363('0x31')][_0xa363('0x3e')]){_0x2465a5['include']=[{'all':!![]}];}_0x2465a5=_[_0xa363('0x48')]({},_0x2465a5,_0x436dfa[_0xa363('0x49')]);return db[_0xa363('0x40')][_0xa363('0x4a')](_0x2465a5)['then'](handleEntityNotFound(_0x488307,null))[_0xa363('0x24')](respondWithResult(_0x488307,null))[_0xa363('0x43')](handleError(_0x488307,null));};exports[_0xa363('0x4b')]=function(_0x6c7f8d,_0x232eb4){return db[_0xa363('0x40')][_0xa363('0x4b')](_0x6c7f8d[_0xa363('0x4c')],{})[_0xa363('0x24')](respondWithResult(_0x232eb4,0xc9))[_0xa363('0x43')](handleError(_0x232eb4,null));};exports['update']=function(_0x47a9d2,_0x11f01f){if(_0x47a9d2[_0xa363('0x4c')]['id']){delete _0x47a9d2['body']['id'];}return db[_0xa363('0x40')][_0xa363('0x4a')]({'where':{'id':_0x47a9d2[_0xa363('0x45')]['id']}})[_0xa363('0x24')](handleEntityNotFound(_0x11f01f,null))[_0xa363('0x24')](saveUpdates(_0x47a9d2[_0xa363('0x4c')],null))[_0xa363('0x24')](respondWithResult(_0x11f01f,null))[_0xa363('0x43')](handleError(_0x11f01f,null));};exports[_0xa363('0x25')]=function(_0x283213,_0x5ce799){return db[_0xa363('0x40')][_0xa363('0x4a')]({'where':{'id':_0x283213['params']['id']}})[_0xa363('0x24')](handleEntityNotFound(_0x5ce799,null))[_0xa363('0x24')](removeEntity(_0x5ce799,null))[_0xa363('0x43')](handleError(_0x5ce799,null));};exports[_0xa363('0x4d')]=function(_0x328850,_0x5b3db6){return db[_0xa363('0x40')][_0xa363('0x4d')]()[_0xa363('0x24')](respondWithResult(_0x5b3db6,null))['catch'](handleError(_0x5b3db6,null));};exports['getQuestions']=function(_0x44366b,_0x224c41,_0x169821){var _0x37299c={'raw':!![],'where':{}};var _0x2869db={};var _0x13ca06={'count':0x0,'rows':[]};return db['JscriptySessionReport'][_0xa363('0x4e')]({'where':{'id':_0x44366b[_0xa363('0x45')]['id']}})[_0xa363('0x24')](handleEntityNotFound(_0x224c41,null))[_0xa363('0x24')](function(_0x29f962){if(_0x29f962){_0x2869db[_0xa363('0x30')]=_['keys'](db[_0xa363('0x4f')][_0xa363('0x2c')]);_0x2869db[_0xa363('0x31')]=_[_0xa363('0x46')](_0x44366b[_0xa363('0x31')]);_0x2869db[_0xa363('0x32')]=_['intersection'](_0x2869db[_0xa363('0x30')],_0x2869db['query']);_0x37299c[_0xa363('0x34')]=_['intersection'](_0x2869db[_0xa363('0x30')],qs[_0xa363('0x35')](_0x44366b[_0xa363('0x31')][_0xa363('0x35')]));_0x37299c[_0xa363('0x34')]=_0x37299c[_0xa363('0x34')][_0xa363('0x47')]?_0x37299c[_0xa363('0x34')]:_0x2869db[_0xa363('0x30')];if(!_0x44366b[_0xa363('0x31')][_0xa363('0x50')](_0xa363('0x36'))){_0x37299c['limit']=qs['limit'](_0x44366b['query'][_0xa363('0x1d')]);_0x37299c[_0xa363('0x1e')]=qs[_0xa363('0x1e')](_0x44366b[_0xa363('0x31')][_0xa363('0x1e')]);}_0x37299c[_0xa363('0x37')]=qs[_0xa363('0x38')](_0x44366b[_0xa363('0x31')][_0xa363('0x38')]);_0x37299c[_0xa363('0x39')]=qs['filters'](_[_0xa363('0x3a')](_0x44366b['query'],_0x2869db['filters']));_0x37299c[_0xa363('0x39')][_0xa363('0x51')]=_0x29f962['id'];if(_0x44366b[_0xa363('0x31')][_0xa363('0x3c')]){_0x37299c[_0xa363('0x39')]=_[_0xa363('0x48')](_0x37299c['where'],{'$or':_['map'](_0x37299c['attributes'],function(_0x219e12){var _0x107acf={};_0x107acf[_0x219e12]={'$like':'%'+_0x44366b[_0xa363('0x31')][_0xa363('0x3c')]+'%'};return _0x107acf;})});}_0x37299c=_['merge']({},_0x37299c,_0x44366b[_0xa363('0x49')]);return db['JscriptyQuestionReport']['count']({'where':_0x37299c[_0xa363('0x39')]})[_0xa363('0x24')](function(_0x18774e){_0x13ca06['count']=_0x18774e;if(_0x44366b[_0xa363('0x31')][_0xa363('0x3e')]){_0x37299c[_0xa363('0x3f')]=[{'all':!![]}];}return db[_0xa363('0x4f')][_0xa363('0x41')](_0x37299c);})[_0xa363('0x24')](function(_0xcfd6a9){_0x13ca06['rows']=_0xcfd6a9;return _0x13ca06;});}})[_0xa363('0x24')](respondWithFilteredResult(_0x224c41,_0x37299c))[_0xa363('0x43')](handleError(_0x224c41,null));};