ae337f89e8b40b53750cc3d18f706766f7722597
[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 _0x1a53=['rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','to-csv','fs-extra','lodash','squel','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','../../config/license/util','sendStatus','status','json','offset','undefined','limit','count','apply','reject','then','destroy','end','stack','name','send','map','JscriptySessionReport','type','key','model','query','attributes','fields','length','nolimit','order','sort','where','filters','filter','merge','options','includeAll','findAll','rows','catch','show','params','keys','rawAttributes','intersection','include','find','create','body','update','describe','findOne','JscriptyQuestionReport','hasOwnProperty','eml-format'];(function(_0x5be795,_0x1cb1b8){var _0x4e8a3b=function(_0x5584ef){while(--_0x5584ef){_0x5be795['push'](_0x5be795['shift']());}};_0x4e8a3b(++_0x1cb1b8);}(_0x1a53,0xe6));var _0x31a5=function(_0x517337,_0x195d5e){_0x517337=_0x517337-0x0;var _0x3aaa01=_0x1a53[_0x517337];return _0x3aaa01;};'use strict';var emlformat=require(_0x31a5('0x0'));var rimraf=require(_0x31a5('0x1'));var zipdir=require(_0x31a5('0x2'));var jsonpatch=require(_0x31a5('0x3'));var rp=require(_0x31a5('0x4'));var moment=require(_0x31a5('0x5'));var BPromise=require(_0x31a5('0x6'));var Mustache=require(_0x31a5('0x7'));var util=require('util');var path=require(_0x31a5('0x8'));var sox=require('sox');var csv=require(_0x31a5('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x31a5('0xa'));var _=require(_0x31a5('0xb'));var squel=require(_0x31a5('0xc'));var crypto=require('crypto');var jsforce=require(_0x31a5('0xd'));var deskjs=require(_0x31a5('0xe'));var toCsv=require(_0x31a5('0x9'));var querystring=require(_0x31a5('0xf'));var Papa=require(_0x31a5('0x10'));var Redis=require(_0x31a5('0x11'));var authService=require(_0x31a5('0x12'));var qs=require(_0x31a5('0x13'));var as=require(_0x31a5('0x14'));var hardwareService=require(_0x31a5('0x15'));var logger=require(_0x31a5('0x16'))(_0x31a5('0x17'));var utils=require(_0x31a5('0x18'));var config=require(_0x31a5('0x19'));var licenseUtil=require(_0x31a5('0x1a'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2087cb,_0x49bc39){_0x49bc39=_0x49bc39||0xcc;return function(_0x4079da){if(_0x4079da){return _0x2087cb[_0x31a5('0x1b')](_0x49bc39);}return _0x2087cb[_0x31a5('0x1c')](_0x49bc39)['end']();};}function respondWithResult(_0x2110a0,_0x180b5b){_0x180b5b=_0x180b5b||0xc8;return function(_0x150c3e){if(_0x150c3e){return _0x2110a0[_0x31a5('0x1c')](_0x180b5b)[_0x31a5('0x1d')](_0x150c3e);}};}function respondWithFilteredResult(_0x47788e,_0x3b905d){return function(_0xe4bc13){if(_0xe4bc13){var _0x2f7830=typeof _0x3b905d[_0x31a5('0x1e')]===_0x31a5('0x1f')&&typeof _0x3b905d[_0x31a5('0x20')]==='undefined';var _0x2da66b=_0xe4bc13[_0x31a5('0x21')];var _0x476791=_0x2f7830?0x0:_0x3b905d['offset'];var _0x5c7573=_0x2f7830?_0xe4bc13[_0x31a5('0x21')]:_0x3b905d[_0x31a5('0x1e')]+_0x3b905d['limit'];var _0x1d1b6f;if(_0x5c7573>=_0x2da66b){_0x5c7573=_0x2da66b;_0x1d1b6f=0xc8;}else{_0x1d1b6f=0xce;}_0x47788e[_0x31a5('0x1c')](_0x1d1b6f);return _0x47788e['set']('Content-Range',_0x476791+'-'+_0x5c7573+'/'+_0x2da66b)['json'](_0xe4bc13);}return null;};}function patchUpdates(_0x478620){return function(_0x42b73c){try{jsonpatch[_0x31a5('0x22')](_0x42b73c,_0x478620,!![]);}catch(_0x473123){return BPromise[_0x31a5('0x23')](_0x473123);}return _0x42b73c['save']();};}function saveUpdates(_0x1ae3b6,_0x256407){return function(_0x1e74d2){if(_0x1e74d2){return _0x1e74d2['update'](_0x1ae3b6)[_0x31a5('0x24')](function(_0x3a89f4){return _0x3a89f4;});}return null;};}function removeEntity(_0x48f6c9,_0x39092d){return function(_0xbd3e09){if(_0xbd3e09){return _0xbd3e09[_0x31a5('0x25')]()[_0x31a5('0x24')](function(){_0x48f6c9[_0x31a5('0x1c')](0xcc)[_0x31a5('0x26')]();});}};}function handleEntityNotFound(_0x4f9dee,_0x3d6e83){return function(_0x19b97c){if(!_0x19b97c){_0x4f9dee['sendStatus'](0x194);}return _0x19b97c;};}function handleError(_0x1fb0cd,_0x548ae6){_0x548ae6=_0x548ae6||0x1f4;return function(_0x1395cc){logger['error'](_0x1395cc[_0x31a5('0x27')]);if(_0x1395cc['name']){delete _0x1395cc[_0x31a5('0x28')];}_0x1fb0cd[_0x31a5('0x1c')](_0x548ae6)[_0x31a5('0x29')](_0x1395cc);};}exports['index']=function(_0x567ab1,_0x476475){var _0x45ad12={},_0x138a0c={},_0x22cef1={'count':0x0,'rows':[]};var _0x1c538f=_[_0x31a5('0x2a')](db[_0x31a5('0x2b')]['rawAttributes'],function(_0x32cb55){return{'name':_0x32cb55['fieldName'],'type':_0x32cb55[_0x31a5('0x2c')][_0x31a5('0x2d')]};});_0x138a0c[_0x31a5('0x2e')]=_['map'](_0x1c538f,_0x31a5('0x28'));_0x138a0c[_0x31a5('0x2f')]=_['keys'](_0x567ab1[_0x31a5('0x2f')]);_0x138a0c['filters']=_['intersection'](_0x138a0c[_0x31a5('0x2e')],_0x138a0c[_0x31a5('0x2f')]);_0x45ad12[_0x31a5('0x30')]=_['intersection'](_0x138a0c[_0x31a5('0x2e')],qs[_0x31a5('0x31')](_0x567ab1[_0x31a5('0x2f')][_0x31a5('0x31')]));_0x45ad12[_0x31a5('0x30')]=_0x45ad12[_0x31a5('0x30')][_0x31a5('0x32')]?_0x45ad12[_0x31a5('0x30')]:_0x138a0c['model'];if(!_0x567ab1['query']['hasOwnProperty'](_0x31a5('0x33'))){_0x45ad12['limit']=qs[_0x31a5('0x20')](_0x567ab1['query'][_0x31a5('0x20')]);_0x45ad12['offset']=qs[_0x31a5('0x1e')](_0x567ab1[_0x31a5('0x2f')][_0x31a5('0x1e')]);}_0x45ad12[_0x31a5('0x34')]=qs[_0x31a5('0x35')](_0x567ab1[_0x31a5('0x2f')][_0x31a5('0x35')]);_0x45ad12[_0x31a5('0x36')]=qs[_0x31a5('0x37')](_['pick'](_0x567ab1[_0x31a5('0x2f')],_0x138a0c[_0x31a5('0x37')]),_0x1c538f);if(_0x567ab1[_0x31a5('0x2f')][_0x31a5('0x38')]){_0x45ad12[_0x31a5('0x36')]=_[_0x31a5('0x39')](_0x45ad12[_0x31a5('0x36')],{'$or':_[_0x31a5('0x2a')](_0x1c538f,function(_0x56ec54){if(_0x56ec54[_0x31a5('0x2c')]!=='VIRTUAL'){var _0x58251b={};_0x58251b[_0x56ec54['name']]={'$like':'%'+_0x567ab1[_0x31a5('0x2f')][_0x31a5('0x38')]+'%'};return _0x58251b;}})});}_0x45ad12=_[_0x31a5('0x39')]({},_0x45ad12,_0x567ab1[_0x31a5('0x3a')]);var _0x1f31c9={'where':_0x45ad12[_0x31a5('0x36')]};return db[_0x31a5('0x2b')][_0x31a5('0x21')](_0x1f31c9)[_0x31a5('0x24')](function(_0x4a5449){_0x22cef1['count']=_0x4a5449;if(_0x567ab1[_0x31a5('0x2f')][_0x31a5('0x3b')]){_0x45ad12['include']=[{'all':!![]}];}return db['JscriptySessionReport'][_0x31a5('0x3c')](_0x45ad12);})[_0x31a5('0x24')](function(_0x2b8dd0){_0x22cef1[_0x31a5('0x3d')]=_0x2b8dd0;return _0x22cef1;})[_0x31a5('0x24')](respondWithFilteredResult(_0x476475,_0x45ad12))[_0x31a5('0x3e')](handleError(_0x476475,null));};exports[_0x31a5('0x3f')]=function(_0x5f50a8,_0x13e8d8){var _0x2425ee={'raw':!![],'where':{'id':_0x5f50a8[_0x31a5('0x40')]['id']}},_0x442db0={};_0x442db0[_0x31a5('0x2e')]=_[_0x31a5('0x41')](db[_0x31a5('0x2b')][_0x31a5('0x42')]);_0x442db0[_0x31a5('0x2f')]=_[_0x31a5('0x41')](_0x5f50a8['query']);_0x442db0[_0x31a5('0x37')]=_[_0x31a5('0x43')](_0x442db0[_0x31a5('0x2e')],_0x442db0[_0x31a5('0x2f')]);_0x2425ee['attributes']=_[_0x31a5('0x43')](_0x442db0[_0x31a5('0x2e')],qs['fields'](_0x5f50a8[_0x31a5('0x2f')]['fields']));_0x2425ee[_0x31a5('0x30')]=_0x2425ee[_0x31a5('0x30')]['length']?_0x2425ee['attributes']:_0x442db0[_0x31a5('0x2e')];if(_0x5f50a8[_0x31a5('0x2f')][_0x31a5('0x3b')]){_0x2425ee[_0x31a5('0x44')]=[{'all':!![]}];}_0x2425ee=_[_0x31a5('0x39')]({},_0x2425ee,_0x5f50a8['options']);return db[_0x31a5('0x2b')][_0x31a5('0x45')](_0x2425ee)[_0x31a5('0x24')](handleEntityNotFound(_0x13e8d8,null))[_0x31a5('0x24')](respondWithResult(_0x13e8d8,null))[_0x31a5('0x3e')](handleError(_0x13e8d8,null));};exports[_0x31a5('0x46')]=function(_0x55bfa3,_0x302134){return db[_0x31a5('0x2b')][_0x31a5('0x46')](_0x55bfa3[_0x31a5('0x47')],{})['then'](respondWithResult(_0x302134,0xc9))[_0x31a5('0x3e')](handleError(_0x302134,null));};exports[_0x31a5('0x48')]=function(_0x299128,_0x31a8b7){if(_0x299128[_0x31a5('0x47')]['id']){delete _0x299128['body']['id'];}return db[_0x31a5('0x2b')][_0x31a5('0x45')]({'where':{'id':_0x299128[_0x31a5('0x40')]['id']}})[_0x31a5('0x24')](handleEntityNotFound(_0x31a8b7,null))['then'](saveUpdates(_0x299128[_0x31a5('0x47')],null))[_0x31a5('0x24')](respondWithResult(_0x31a8b7,null))['catch'](handleError(_0x31a8b7,null));};exports[_0x31a5('0x25')]=function(_0x41297e,_0x18ae39){return db['JscriptySessionReport'][_0x31a5('0x45')]({'where':{'id':_0x41297e[_0x31a5('0x40')]['id']}})[_0x31a5('0x24')](handleEntityNotFound(_0x18ae39,null))[_0x31a5('0x24')](removeEntity(_0x18ae39,null))['catch'](handleError(_0x18ae39,null));};exports[_0x31a5('0x49')]=function(_0x31de9e,_0x1c20bf){return db[_0x31a5('0x2b')][_0x31a5('0x49')]()[_0x31a5('0x24')](respondWithResult(_0x1c20bf,null))[_0x31a5('0x3e')](handleError(_0x1c20bf,null));};exports['getQuestions']=function(_0x249ed5,_0x51cea5,_0x4f6ba5){var _0x4215d3={'raw':!![],'where':{}};var _0x3340f7={};var _0x5d6d07={'count':0x0,'rows':[]};return db[_0x31a5('0x2b')][_0x31a5('0x4a')]({'where':{'id':_0x249ed5[_0x31a5('0x40')]['id']}})[_0x31a5('0x24')](handleEntityNotFound(_0x51cea5,null))[_0x31a5('0x24')](function(_0x112e35){if(_0x112e35){_0x3340f7[_0x31a5('0x2e')]=_[_0x31a5('0x41')](db[_0x31a5('0x4b')][_0x31a5('0x42')]);_0x3340f7[_0x31a5('0x2f')]=_[_0x31a5('0x41')](_0x249ed5[_0x31a5('0x2f')]);_0x3340f7['filters']=_['intersection'](_0x3340f7[_0x31a5('0x2e')],_0x3340f7[_0x31a5('0x2f')]);_0x4215d3[_0x31a5('0x30')]=_['intersection'](_0x3340f7[_0x31a5('0x2e')],qs[_0x31a5('0x31')](_0x249ed5[_0x31a5('0x2f')][_0x31a5('0x31')]));_0x4215d3[_0x31a5('0x30')]=_0x4215d3[_0x31a5('0x30')][_0x31a5('0x32')]?_0x4215d3['attributes']:_0x3340f7[_0x31a5('0x2e')];if(!_0x249ed5[_0x31a5('0x2f')][_0x31a5('0x4c')]('nolimit')){_0x4215d3['limit']=qs[_0x31a5('0x20')](_0x249ed5['query'][_0x31a5('0x20')]);_0x4215d3[_0x31a5('0x1e')]=qs[_0x31a5('0x1e')](_0x249ed5[_0x31a5('0x2f')][_0x31a5('0x1e')]);}_0x4215d3[_0x31a5('0x34')]=qs['sort'](_0x249ed5[_0x31a5('0x2f')][_0x31a5('0x35')]);_0x4215d3['where']=qs[_0x31a5('0x37')](_['pick'](_0x249ed5[_0x31a5('0x2f')],_0x3340f7[_0x31a5('0x37')]));_0x4215d3[_0x31a5('0x36')]['SessionId']=_0x112e35['id'];if(_0x249ed5[_0x31a5('0x2f')][_0x31a5('0x38')]){_0x4215d3[_0x31a5('0x36')]=_[_0x31a5('0x39')](_0x4215d3['where'],{'$or':_[_0x31a5('0x2a')](_0x4215d3[_0x31a5('0x30')],function(_0x3934cb){var _0xf4788b={};_0xf4788b[_0x3934cb]={'$like':'%'+_0x249ed5[_0x31a5('0x2f')]['filter']+'%'};return _0xf4788b;})});}_0x4215d3=_[_0x31a5('0x39')]({},_0x4215d3,_0x249ed5[_0x31a5('0x3a')]);return db[_0x31a5('0x4b')]['count']({'where':_0x4215d3[_0x31a5('0x36')]})[_0x31a5('0x24')](function(_0x2df952){_0x5d6d07['count']=_0x2df952;if(_0x249ed5[_0x31a5('0x2f')][_0x31a5('0x3b')]){_0x4215d3[_0x31a5('0x44')]=[{'all':!![]}];}return db['JscriptyQuestionReport'][_0x31a5('0x3c')](_0x4215d3);})[_0x31a5('0x24')](function(_0x37cd58){_0x5d6d07[_0x31a5('0x3d')]=_0x37cd58;return _0x5d6d07;});}})[_0x31a5('0x24')](respondWithFilteredResult(_0x51cea5,_0x4215d3))['catch'](handleError(_0x51cea5,null));};