9147cb7057ab8db648c677342878329b62a7dd44
[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 _0xedcb=['nolimit','order','sort','where','filters','pick','filter','VIRTUAL','options','JscriptySessionReport','includeAll','include','findAll','rows','catch','show','find','create','params','destroy','describe','findOne','JscriptyQuestionReport','rawAttributes','SessionId','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','apply','save','update','then','error','stack','name','send','render','merge','body','contact','message','agent','account','index','map','fieldName','type','model','keys','query','attributes','intersection','fields','length','hasOwnProperty'];(function(_0x3ab51d,_0x2fa01d){var _0x29a04e=function(_0x7807b0){while(--_0x7807b0){_0x3ab51d['push'](_0x3ab51d['shift']());}};_0x29a04e(++_0x2fa01d);}(_0xedcb,0x1c2));var _0xbedc=function(_0x8ae996,_0x520674){_0x8ae996=_0x8ae996-0x0;var _0x1e0e68=_0xedcb[_0x8ae996];return _0x1e0e68;};'use strict';var emlformat=require(_0xbedc('0x0'));var rimraf=require(_0xbedc('0x1'));var zipdir=require(_0xbedc('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xbedc('0x3'));var moment=require(_0xbedc('0x4'));var BPromise=require(_0xbedc('0x5'));var Mustache=require(_0xbedc('0x6'));var util=require('util');var path=require(_0xbedc('0x7'));var sox=require('sox');var csv=require(_0xbedc('0x8'));var ejs=require(_0xbedc('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xbedc('0xa'));var squel=require(_0xbedc('0xb'));var crypto=require(_0xbedc('0xc'));var jsforce=require(_0xbedc('0xd'));var deskjs=require(_0xbedc('0xe'));var toCsv=require('to-csv');var querystring=require(_0xbedc('0xf'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xbedc('0x10'));var as=require(_0xbedc('0x11'));var hardwareService=require(_0xbedc('0x12'));var logger=require(_0xbedc('0x13'))(_0xbedc('0x14'));var utils=require(_0xbedc('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0xbedc('0x16'));var db=require(_0xbedc('0x17'))['db'];function respondWithStatusCode(_0x3b7ebd,_0x3c322d){_0x3c322d=_0x3c322d||0xcc;return function(_0x14bc25){if(_0x14bc25){return _0x3b7ebd[_0xbedc('0x18')](_0x3c322d);}return _0x3b7ebd[_0xbedc('0x19')](_0x3c322d)[_0xbedc('0x1a')]();};}function respondWithResult(_0x5d50fa,_0x37f55f){_0x37f55f=_0x37f55f||0xc8;return function(_0x5a33d5){if(_0x5a33d5){return _0x5d50fa[_0xbedc('0x19')](_0x37f55f)[_0xbedc('0x1b')](_0x5a33d5);}};}function respondWithFilteredResult(_0xd2cfe2,_0x135eee){return function(_0x275f48){if(_0x275f48){var _0x51c6d7=typeof _0x135eee[_0xbedc('0x1c')]===_0xbedc('0x1d')&&typeof _0x135eee[_0xbedc('0x1e')]===_0xbedc('0x1d');var _0x37c0e0=_0x275f48['count'];var _0x5f31a4=_0x51c6d7?0x0:_0x135eee['offset'];var _0x2011e1=_0x51c6d7?_0x275f48[_0xbedc('0x1f')]:_0x135eee[_0xbedc('0x1c')]+_0x135eee[_0xbedc('0x1e')];var _0x1aac00;if(_0x2011e1>=_0x37c0e0){_0x2011e1=_0x37c0e0;_0x1aac00=0xc8;}else{_0x1aac00=0xce;}_0xd2cfe2[_0xbedc('0x19')](_0x1aac00);return _0xd2cfe2[_0xbedc('0x20')]('Content-Range',_0x5f31a4+'-'+_0x2011e1+'/'+_0x37c0e0)[_0xbedc('0x1b')](_0x275f48);}return null;};}function patchUpdates(_0x2fc884){return function(_0xd26c03){try{jsonpatch[_0xbedc('0x21')](_0xd26c03,_0x2fc884,!![]);}catch(_0x4873a4){return BPromise['reject'](_0x4873a4);}return _0xd26c03[_0xbedc('0x22')]();};}function saveUpdates(_0x577b54,_0x2f9160){return function(_0x317c67){if(_0x317c67){return _0x317c67[_0xbedc('0x23')](_0x577b54)['then'](function(_0x432b84){return _0x432b84;});}return null;};}function removeEntity(_0x565286,_0x5b0369){return function(_0x4725a7){if(_0x4725a7){return _0x4725a7['destroy']()[_0xbedc('0x24')](function(){_0x565286[_0xbedc('0x19')](0xcc)[_0xbedc('0x1a')]();});}};}function handleEntityNotFound(_0x439978,_0x170b10){return function(_0x3f11d0){if(!_0x3f11d0){_0x439978[_0xbedc('0x18')](0x194);}return _0x3f11d0;};}function handleError(_0x1069e0,_0x1b50be){_0x1b50be=_0x1b50be||0x1f4;return function(_0x3623a4){logger[_0xbedc('0x25')](_0x3623a4[_0xbedc('0x26')]);if(_0x3623a4['name']){delete _0x3623a4[_0xbedc('0x27')];}_0x1069e0[_0xbedc('0x19')](_0x1b50be)[_0xbedc('0x28')](_0x3623a4);};}function getMustacheRender(_0x46d02f,_0x24bb70){return Mustache[_0xbedc('0x29')](_0x46d02f,_[_0xbedc('0x2a')](_0x24bb70[_0xbedc('0x2b')],{'contact':_0x24bb70[_0xbedc('0x2c')],'message':_0x24bb70[_0xbedc('0x2d')],'agent':_0x24bb70[_0xbedc('0x2e')],'interaction':_0x24bb70['interaction'],'account':_0x24bb70[_0xbedc('0x2f')]}))||'';}exports[_0xbedc('0x30')]=function(_0x5815b1,_0x37a20e){var _0x2cd9dc={},_0x461cd0={},_0x38753b={'count':0x0,'rows':[]};var _0x367a87=_[_0xbedc('0x31')](db['JscriptySessionReport']['rawAttributes'],function(_0x6db44d){return{'name':_0x6db44d[_0xbedc('0x32')],'type':_0x6db44d[_0xbedc('0x33')]['key']};});_0x461cd0[_0xbedc('0x34')]=_[_0xbedc('0x31')](_0x367a87,_0xbedc('0x27'));_0x461cd0['query']=_[_0xbedc('0x35')](_0x5815b1[_0xbedc('0x36')]);_0x461cd0['filters']=_['intersection'](_0x461cd0['model'],_0x461cd0[_0xbedc('0x36')]);_0x2cd9dc[_0xbedc('0x37')]=_[_0xbedc('0x38')](_0x461cd0[_0xbedc('0x34')],qs[_0xbedc('0x39')](_0x5815b1[_0xbedc('0x36')][_0xbedc('0x39')]));_0x2cd9dc[_0xbedc('0x37')]=_0x2cd9dc['attributes'][_0xbedc('0x3a')]?_0x2cd9dc[_0xbedc('0x37')]:_0x461cd0[_0xbedc('0x34')];if(!_0x5815b1['query'][_0xbedc('0x3b')](_0xbedc('0x3c'))){_0x2cd9dc[_0xbedc('0x1e')]=qs['limit'](_0x5815b1[_0xbedc('0x36')][_0xbedc('0x1e')]);_0x2cd9dc['offset']=qs[_0xbedc('0x1c')](_0x5815b1[_0xbedc('0x36')]['offset']);}_0x2cd9dc[_0xbedc('0x3d')]=qs[_0xbedc('0x3e')](_0x5815b1['query']['sort']);_0x2cd9dc[_0xbedc('0x3f')]=qs[_0xbedc('0x40')](_[_0xbedc('0x41')](_0x5815b1[_0xbedc('0x36')],_0x461cd0[_0xbedc('0x40')]),_0x367a87);if(_0x5815b1[_0xbedc('0x36')][_0xbedc('0x42')]){_0x2cd9dc[_0xbedc('0x3f')]=_[_0xbedc('0x2a')](_0x2cd9dc[_0xbedc('0x3f')],{'$or':_[_0xbedc('0x31')](_0x367a87,function(_0x3d1ff3){if(_0x3d1ff3[_0xbedc('0x33')]!==_0xbedc('0x43')){var _0x5568b9={};_0x5568b9[_0x3d1ff3[_0xbedc('0x27')]]={'$like':'%'+_0x5815b1['query']['filter']+'%'};return _0x5568b9;}})});}_0x2cd9dc=_['merge']({},_0x2cd9dc,_0x5815b1[_0xbedc('0x44')]);var _0xebacfd={'where':_0x2cd9dc[_0xbedc('0x3f')]};return db[_0xbedc('0x45')][_0xbedc('0x1f')](_0xebacfd)['then'](function(_0x8f59d4){_0x38753b[_0xbedc('0x1f')]=_0x8f59d4;if(_0x5815b1['query'][_0xbedc('0x46')]){_0x2cd9dc[_0xbedc('0x47')]=[{'all':!![]}];}return db[_0xbedc('0x45')][_0xbedc('0x48')](_0x2cd9dc);})[_0xbedc('0x24')](function(_0xcdce58){_0x38753b[_0xbedc('0x49')]=_0xcdce58;return _0x38753b;})[_0xbedc('0x24')](respondWithFilteredResult(_0x37a20e,_0x2cd9dc))[_0xbedc('0x4a')](handleError(_0x37a20e,null));};exports[_0xbedc('0x4b')]=function(_0x1f6ccb,_0x77674f){var _0xd363de={'raw':!![],'where':{'id':_0x1f6ccb['params']['id']}},_0x59906b={};_0x59906b[_0xbedc('0x34')]=_[_0xbedc('0x35')](db[_0xbedc('0x45')]['rawAttributes']);_0x59906b[_0xbedc('0x36')]=_['keys'](_0x1f6ccb[_0xbedc('0x36')]);_0x59906b[_0xbedc('0x40')]=_[_0xbedc('0x38')](_0x59906b[_0xbedc('0x34')],_0x59906b['query']);_0xd363de[_0xbedc('0x37')]=_[_0xbedc('0x38')](_0x59906b[_0xbedc('0x34')],qs[_0xbedc('0x39')](_0x1f6ccb['query']['fields']));_0xd363de[_0xbedc('0x37')]=_0xd363de[_0xbedc('0x37')][_0xbedc('0x3a')]?_0xd363de['attributes']:_0x59906b[_0xbedc('0x34')];if(_0x1f6ccb[_0xbedc('0x36')][_0xbedc('0x46')]){_0xd363de[_0xbedc('0x47')]=[{'all':!![]}];}_0xd363de=_[_0xbedc('0x2a')]({},_0xd363de,_0x1f6ccb[_0xbedc('0x44')]);return db['JscriptySessionReport'][_0xbedc('0x4c')](_0xd363de)[_0xbedc('0x24')](handleEntityNotFound(_0x77674f,null))['then'](respondWithResult(_0x77674f,null))['catch'](handleError(_0x77674f,null));};exports[_0xbedc('0x4d')]=function(_0x5f7ba2,_0x1b5117){return db[_0xbedc('0x45')][_0xbedc('0x4d')](_0x5f7ba2[_0xbedc('0x2b')],{})['then'](respondWithResult(_0x1b5117,0xc9))['catch'](handleError(_0x1b5117,null));};exports[_0xbedc('0x23')]=function(_0x39fbff,_0x562e5b){if(_0x39fbff[_0xbedc('0x2b')]['id']){delete _0x39fbff[_0xbedc('0x2b')]['id'];}return db[_0xbedc('0x45')]['find']({'where':{'id':_0x39fbff[_0xbedc('0x4e')]['id']}})[_0xbedc('0x24')](handleEntityNotFound(_0x562e5b,null))[_0xbedc('0x24')](saveUpdates(_0x39fbff[_0xbedc('0x2b')],null))['then'](respondWithResult(_0x562e5b,null))['catch'](handleError(_0x562e5b,null));};exports[_0xbedc('0x4f')]=function(_0x526d3f,_0x4a528f){return db[_0xbedc('0x45')][_0xbedc('0x4c')]({'where':{'id':_0x526d3f[_0xbedc('0x4e')]['id']}})['then'](handleEntityNotFound(_0x4a528f,null))[_0xbedc('0x24')](removeEntity(_0x4a528f,null))[_0xbedc('0x4a')](handleError(_0x4a528f,null));};exports[_0xbedc('0x50')]=function(_0x3b078a,_0x19afbf){return db['JscriptySessionReport'][_0xbedc('0x50')]()[_0xbedc('0x24')](respondWithResult(_0x19afbf,null))[_0xbedc('0x4a')](handleError(_0x19afbf,null));};exports['getQuestions']=function(_0x2af901,_0x13c003,_0x1cbb6a){var _0x46ea70={'raw':!![],'where':{}};var _0x39024d={};var _0x345830={'count':0x0,'rows':[]};return db[_0xbedc('0x45')][_0xbedc('0x51')]({'where':{'id':_0x2af901[_0xbedc('0x4e')]['id']}})[_0xbedc('0x24')](handleEntityNotFound(_0x13c003,null))['then'](function(_0x4ee4c4){if(_0x4ee4c4){_0x39024d['model']=_[_0xbedc('0x35')](db[_0xbedc('0x52')][_0xbedc('0x53')]);_0x39024d[_0xbedc('0x36')]=_[_0xbedc('0x35')](_0x2af901[_0xbedc('0x36')]);_0x39024d[_0xbedc('0x40')]=_[_0xbedc('0x38')](_0x39024d['model'],_0x39024d['query']);_0x46ea70[_0xbedc('0x37')]=_[_0xbedc('0x38')](_0x39024d['model'],qs[_0xbedc('0x39')](_0x2af901[_0xbedc('0x36')][_0xbedc('0x39')]));_0x46ea70['attributes']=_0x46ea70[_0xbedc('0x37')][_0xbedc('0x3a')]?_0x46ea70[_0xbedc('0x37')]:_0x39024d[_0xbedc('0x34')];if(!_0x2af901['query'][_0xbedc('0x3b')](_0xbedc('0x3c'))){_0x46ea70[_0xbedc('0x1e')]=qs[_0xbedc('0x1e')](_0x2af901[_0xbedc('0x36')][_0xbedc('0x1e')]);_0x46ea70[_0xbedc('0x1c')]=qs[_0xbedc('0x1c')](_0x2af901[_0xbedc('0x36')][_0xbedc('0x1c')]);}_0x46ea70[_0xbedc('0x3d')]=qs['sort'](_0x2af901[_0xbedc('0x36')]['sort']);_0x46ea70['where']=qs[_0xbedc('0x40')](_[_0xbedc('0x41')](_0x2af901['query'],_0x39024d[_0xbedc('0x40')]));_0x46ea70[_0xbedc('0x3f')][_0xbedc('0x54')]=_0x4ee4c4['id'];if(_0x2af901['query']['filter']){_0x46ea70['where']=_[_0xbedc('0x2a')](_0x46ea70[_0xbedc('0x3f')],{'$or':_[_0xbedc('0x31')](_0x46ea70[_0xbedc('0x37')],function(_0x436572){var _0x3a5385={};_0x3a5385[_0x436572]={'$like':'%'+_0x2af901['query']['filter']+'%'};return _0x3a5385;})});}_0x46ea70=_['merge']({},_0x46ea70,_0x2af901[_0xbedc('0x44')]);return db['JscriptyQuestionReport'][_0xbedc('0x1f')]({'where':_0x46ea70[_0xbedc('0x3f')]})[_0xbedc('0x24')](function(_0x79f170){_0x345830['count']=_0x79f170;if(_0x2af901[_0xbedc('0x36')][_0xbedc('0x46')]){_0x46ea70['include']=[{'all':!![]}];}return db['JscriptyQuestionReport'][_0xbedc('0x48')](_0x46ea70);})[_0xbedc('0x24')](function(_0x395efb){_0x345830[_0xbedc('0x49')]=_0x395efb;return _0x345830;});}})[_0xbedc('0x24')](respondWithFilteredResult(_0x13c003,_0x46ea70))[_0xbedc('0x4a')](handleError(_0x13c003,null));};