0761b6eacd729f60ab4ef3953b13604789b48bd2
[motion2.git] / server / api / jscriptySessionReport / jscriptySessionReport.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 _0xb5cd=['getQuestions','findOne','JscriptyQuestionReport','intersection','hasOwnProperty','SessionId','eml-format','zip-dir','request-promise','bluebird','mustache','util','path','to-csv','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','limit','count','offset','set','Content-Range','apply','reject','save','destroy','then','error','stack','name','send','index','map','JscriptySessionReport','rawAttributes','fieldName','type','key','query','keys','filters','model','attributes','fields','length','nolimit','sort','where','pick','filter','merge','VIRTUAL','includeAll','include','findAll','rows','options','find','catch','create','body','params','describe'];(function(_0x5d892c,_0x47bac4){var _0x2e97a0=function(_0x4886b5){while(--_0x4886b5){_0x5d892c['push'](_0x5d892c['shift']());}};_0x2e97a0(++_0x47bac4);}(_0xb5cd,0xf3));var _0xdb5c=function(_0xf7706f,_0x27f082){_0xf7706f=_0xf7706f-0x0;var _0x448dae=_0xb5cd[_0xf7706f];return _0x448dae;};'use strict';var emlformat=require(_0xdb5c('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xdb5c('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0xdb5c('0x2'));var moment=require('moment');var BPromise=require(_0xdb5c('0x3'));var Mustache=require(_0xdb5c('0x4'));var util=require(_0xdb5c('0x5'));var path=require(_0xdb5c('0x6'));var sox=require('sox');var csv=require(_0xdb5c('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0xdb5c('0x8'));var crypto=require(_0xdb5c('0x9'));var jsforce=require(_0xdb5c('0xa'));var deskjs=require(_0xdb5c('0xb'));var toCsv=require('to-csv');var querystring=require(_0xdb5c('0xc'));var Papa=require(_0xdb5c('0xd'));var Redis=require(_0xdb5c('0xe'));var authService=require(_0xdb5c('0xf'));var qs=require(_0xdb5c('0x10'));var as=require(_0xdb5c('0x11'));var hardwareService=require(_0xdb5c('0x12'));var logger=require(_0xdb5c('0x13'))(_0xdb5c('0x14'));var utils=require(_0xdb5c('0x15'));var config=require(_0xdb5c('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0xdb5c('0x17'))['db'];function respondWithStatusCode(_0x4267f5,_0x150407){_0x150407=_0x150407||0xcc;return function(_0x1f2346){if(_0x1f2346){return _0x4267f5[_0xdb5c('0x18')](_0x150407);}return _0x4267f5[_0xdb5c('0x19')](_0x150407)['end']();};}function respondWithResult(_0x2ac0f4,_0x2a1f79){_0x2a1f79=_0x2a1f79||0xc8;return function(_0x4424ed){if(_0x4424ed){return _0x2ac0f4[_0xdb5c('0x19')](_0x2a1f79)[_0xdb5c('0x1a')](_0x4424ed);}};}function respondWithFilteredResult(_0x1c1941,_0x5a515c){return function(_0x6d4345){if(_0x6d4345){var _0x410326=typeof _0x5a515c['offset']==='undefined'&&typeof _0x5a515c[_0xdb5c('0x1b')]==='undefined';var _0x4993dc=_0x6d4345[_0xdb5c('0x1c')];var _0x29db35=_0x410326?0x0:_0x5a515c[_0xdb5c('0x1d')];var _0x16c465=_0x410326?_0x6d4345[_0xdb5c('0x1c')]:_0x5a515c['offset']+_0x5a515c[_0xdb5c('0x1b')];var _0x3e9f05;if(_0x16c465>=_0x4993dc){_0x16c465=_0x4993dc;_0x3e9f05=0xc8;}else{_0x3e9f05=0xce;}_0x1c1941['status'](_0x3e9f05);return _0x1c1941[_0xdb5c('0x1e')](_0xdb5c('0x1f'),_0x29db35+'-'+_0x16c465+'/'+_0x4993dc)[_0xdb5c('0x1a')](_0x6d4345);}return null;};}function patchUpdates(_0x4c3a1e){return function(_0x33efcd){try{jsonpatch[_0xdb5c('0x20')](_0x33efcd,_0x4c3a1e,!![]);}catch(_0x4a9de3){return BPromise[_0xdb5c('0x21')](_0x4a9de3);}return _0x33efcd[_0xdb5c('0x22')]();};}function saveUpdates(_0x305f48,_0x266e4e){return function(_0x146ac8){if(_0x146ac8){return _0x146ac8['update'](_0x305f48)['then'](function(_0x4d5f7e){return _0x4d5f7e;});}return null;};}function removeEntity(_0x41a2fc,_0x33d40f){return function(_0x16e12f){if(_0x16e12f){return _0x16e12f[_0xdb5c('0x23')]()[_0xdb5c('0x24')](function(){_0x41a2fc[_0xdb5c('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1413a2,_0x12edc1){return function(_0x36d8ed){if(!_0x36d8ed){_0x1413a2[_0xdb5c('0x18')](0x194);}return _0x36d8ed;};}function handleError(_0xecddb6,_0x36fc27){_0x36fc27=_0x36fc27||0x1f4;return function(_0x2b8e6b){logger[_0xdb5c('0x25')](_0x2b8e6b[_0xdb5c('0x26')]);if(_0x2b8e6b['name']){delete _0x2b8e6b[_0xdb5c('0x27')];}_0xecddb6['status'](_0x36fc27)[_0xdb5c('0x28')](_0x2b8e6b);};}exports[_0xdb5c('0x29')]=function(_0x26af8d,_0x54d69d){var _0x517d61={},_0x4fef95={},_0x277173={'count':0x0,'rows':[]};var _0x443fba=_[_0xdb5c('0x2a')](db[_0xdb5c('0x2b')][_0xdb5c('0x2c')],function(_0x115900){return{'name':_0x115900[_0xdb5c('0x2d')],'type':_0x115900[_0xdb5c('0x2e')][_0xdb5c('0x2f')]};});_0x4fef95['model']=_[_0xdb5c('0x2a')](_0x443fba,'name');_0x4fef95[_0xdb5c('0x30')]=_[_0xdb5c('0x31')](_0x26af8d['query']);_0x4fef95[_0xdb5c('0x32')]=_['intersection'](_0x4fef95[_0xdb5c('0x33')],_0x4fef95[_0xdb5c('0x30')]);_0x517d61[_0xdb5c('0x34')]=_['intersection'](_0x4fef95['model'],qs['fields'](_0x26af8d[_0xdb5c('0x30')][_0xdb5c('0x35')]));_0x517d61[_0xdb5c('0x34')]=_0x517d61[_0xdb5c('0x34')][_0xdb5c('0x36')]?_0x517d61[_0xdb5c('0x34')]:_0x4fef95[_0xdb5c('0x33')];if(!_0x26af8d[_0xdb5c('0x30')]['hasOwnProperty'](_0xdb5c('0x37'))){_0x517d61[_0xdb5c('0x1b')]=qs[_0xdb5c('0x1b')](_0x26af8d[_0xdb5c('0x30')][_0xdb5c('0x1b')]);_0x517d61[_0xdb5c('0x1d')]=qs[_0xdb5c('0x1d')](_0x26af8d[_0xdb5c('0x30')][_0xdb5c('0x1d')]);}_0x517d61['order']=qs['sort'](_0x26af8d[_0xdb5c('0x30')][_0xdb5c('0x38')]);_0x517d61[_0xdb5c('0x39')]=qs[_0xdb5c('0x32')](_[_0xdb5c('0x3a')](_0x26af8d[_0xdb5c('0x30')],_0x4fef95[_0xdb5c('0x32')]),_0x443fba);if(_0x26af8d[_0xdb5c('0x30')][_0xdb5c('0x3b')]){_0x517d61[_0xdb5c('0x39')]=_[_0xdb5c('0x3c')](_0x517d61['where'],{'$or':_[_0xdb5c('0x2a')](_0x443fba,function(_0x1ac797){if(_0x1ac797['type']!==_0xdb5c('0x3d')){var _0x1eafc9={};_0x1eafc9[_0x1ac797[_0xdb5c('0x27')]]={'$like':'%'+_0x26af8d[_0xdb5c('0x30')][_0xdb5c('0x3b')]+'%'};return _0x1eafc9;}})});}_0x517d61=_['merge']({},_0x517d61,_0x26af8d['options']);var _0x3c9717={'where':_0x517d61[_0xdb5c('0x39')]};return db['JscriptySessionReport'][_0xdb5c('0x1c')](_0x3c9717)['then'](function(_0x5ea75c){_0x277173[_0xdb5c('0x1c')]=_0x5ea75c;if(_0x26af8d[_0xdb5c('0x30')][_0xdb5c('0x3e')]){_0x517d61[_0xdb5c('0x3f')]=[{'all':!![]}];}return db[_0xdb5c('0x2b')][_0xdb5c('0x40')](_0x517d61);})[_0xdb5c('0x24')](function(_0x32a0dd){_0x277173[_0xdb5c('0x41')]=_0x32a0dd;return _0x277173;})[_0xdb5c('0x24')](respondWithFilteredResult(_0x54d69d,_0x517d61))['catch'](handleError(_0x54d69d,null));};exports['show']=function(_0x3da72e,_0x1682a5){var _0x1a56ba={'raw':!![],'where':{'id':_0x3da72e['params']['id']}},_0x432c9c={};_0x432c9c['model']=_[_0xdb5c('0x31')](db[_0xdb5c('0x2b')]['rawAttributes']);_0x432c9c[_0xdb5c('0x30')]=_[_0xdb5c('0x31')](_0x3da72e[_0xdb5c('0x30')]);_0x432c9c[_0xdb5c('0x32')]=_['intersection'](_0x432c9c[_0xdb5c('0x33')],_0x432c9c[_0xdb5c('0x30')]);_0x1a56ba[_0xdb5c('0x34')]=_['intersection'](_0x432c9c[_0xdb5c('0x33')],qs[_0xdb5c('0x35')](_0x3da72e[_0xdb5c('0x30')][_0xdb5c('0x35')]));_0x1a56ba[_0xdb5c('0x34')]=_0x1a56ba[_0xdb5c('0x34')][_0xdb5c('0x36')]?_0x1a56ba[_0xdb5c('0x34')]:_0x432c9c[_0xdb5c('0x33')];if(_0x3da72e['query']['includeAll']){_0x1a56ba[_0xdb5c('0x3f')]=[{'all':!![]}];}_0x1a56ba=_[_0xdb5c('0x3c')]({},_0x1a56ba,_0x3da72e[_0xdb5c('0x42')]);return db[_0xdb5c('0x2b')][_0xdb5c('0x43')](_0x1a56ba)['then'](handleEntityNotFound(_0x1682a5,null))[_0xdb5c('0x24')](respondWithResult(_0x1682a5,null))[_0xdb5c('0x44')](handleError(_0x1682a5,null));};exports[_0xdb5c('0x45')]=function(_0xc5c7e4,_0x3a5d76){return db['JscriptySessionReport'][_0xdb5c('0x45')](_0xc5c7e4[_0xdb5c('0x46')],{})[_0xdb5c('0x24')](respondWithResult(_0x3a5d76,0xc9))[_0xdb5c('0x44')](handleError(_0x3a5d76,null));};exports['update']=function(_0x376387,_0x36226c){if(_0x376387[_0xdb5c('0x46')]['id']){delete _0x376387[_0xdb5c('0x46')]['id'];}return db[_0xdb5c('0x2b')][_0xdb5c('0x43')]({'where':{'id':_0x376387[_0xdb5c('0x47')]['id']}})[_0xdb5c('0x24')](handleEntityNotFound(_0x36226c,null))[_0xdb5c('0x24')](saveUpdates(_0x376387[_0xdb5c('0x46')],null))[_0xdb5c('0x24')](respondWithResult(_0x36226c,null))[_0xdb5c('0x44')](handleError(_0x36226c,null));};exports[_0xdb5c('0x23')]=function(_0x4ffc50,_0xae80e6){return db['JscriptySessionReport'][_0xdb5c('0x43')]({'where':{'id':_0x4ffc50[_0xdb5c('0x47')]['id']}})[_0xdb5c('0x24')](handleEntityNotFound(_0xae80e6,null))[_0xdb5c('0x24')](removeEntity(_0xae80e6,null))[_0xdb5c('0x44')](handleError(_0xae80e6,null));};exports[_0xdb5c('0x48')]=function(_0x1b2787,_0x37e7e6){return db[_0xdb5c('0x2b')]['describe']()[_0xdb5c('0x24')](respondWithResult(_0x37e7e6,null))[_0xdb5c('0x44')](handleError(_0x37e7e6,null));};exports[_0xdb5c('0x49')]=function(_0x3fa718,_0x4d8fc4,_0x2a8b40){var _0x1bb024={'raw':!![],'where':{}};var _0x502c27={};var _0xbce859={'count':0x0,'rows':[]};return db[_0xdb5c('0x2b')][_0xdb5c('0x4a')]({'where':{'id':_0x3fa718['params']['id']}})[_0xdb5c('0x24')](handleEntityNotFound(_0x4d8fc4,null))[_0xdb5c('0x24')](function(_0x150788){if(_0x150788){_0x502c27[_0xdb5c('0x33')]=_['keys'](db[_0xdb5c('0x4b')][_0xdb5c('0x2c')]);_0x502c27[_0xdb5c('0x30')]=_[_0xdb5c('0x31')](_0x3fa718['query']);_0x502c27[_0xdb5c('0x32')]=_[_0xdb5c('0x4c')](_0x502c27[_0xdb5c('0x33')],_0x502c27['query']);_0x1bb024[_0xdb5c('0x34')]=_[_0xdb5c('0x4c')](_0x502c27[_0xdb5c('0x33')],qs[_0xdb5c('0x35')](_0x3fa718['query'][_0xdb5c('0x35')]));_0x1bb024['attributes']=_0x1bb024[_0xdb5c('0x34')][_0xdb5c('0x36')]?_0x1bb024['attributes']:_0x502c27['model'];if(!_0x3fa718['query'][_0xdb5c('0x4d')](_0xdb5c('0x37'))){_0x1bb024[_0xdb5c('0x1b')]=qs[_0xdb5c('0x1b')](_0x3fa718[_0xdb5c('0x30')]['limit']);_0x1bb024[_0xdb5c('0x1d')]=qs[_0xdb5c('0x1d')](_0x3fa718[_0xdb5c('0x30')][_0xdb5c('0x1d')]);}_0x1bb024['order']=qs[_0xdb5c('0x38')](_0x3fa718[_0xdb5c('0x30')][_0xdb5c('0x38')]);_0x1bb024[_0xdb5c('0x39')]=qs['filters'](_[_0xdb5c('0x3a')](_0x3fa718[_0xdb5c('0x30')],_0x502c27[_0xdb5c('0x32')]));_0x1bb024[_0xdb5c('0x39')][_0xdb5c('0x4e')]=_0x150788['id'];if(_0x3fa718[_0xdb5c('0x30')][_0xdb5c('0x3b')]){_0x1bb024[_0xdb5c('0x39')]=_[_0xdb5c('0x3c')](_0x1bb024[_0xdb5c('0x39')],{'$or':_[_0xdb5c('0x2a')](_0x1bb024['attributes'],function(_0x50d067){var _0x316031={};_0x316031[_0x50d067]={'$like':'%'+_0x3fa718[_0xdb5c('0x30')][_0xdb5c('0x3b')]+'%'};return _0x316031;})});}_0x1bb024=_['merge']({},_0x1bb024,_0x3fa718[_0xdb5c('0x42')]);return db[_0xdb5c('0x4b')][_0xdb5c('0x1c')]({'where':_0x1bb024['where']})[_0xdb5c('0x24')](function(_0xd91bde){_0xbce859[_0xdb5c('0x1c')]=_0xd91bde;if(_0x3fa718['query'][_0xdb5c('0x3e')]){_0x1bb024[_0xdb5c('0x3f')]=[{'all':!![]}];}return db['JscriptyQuestionReport']['findAll'](_0x1bb024);})[_0xdb5c('0x24')](function(_0x58b307){_0xbce859['rows']=_0x58b307;return _0xbce859;});}})[_0xdb5c('0x24')](respondWithFilteredResult(_0x4d8fc4,_0x1bb024))['catch'](handleError(_0x4d8fc4,null));};