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 _0x0a75=['then','error','stack','name','send','index','map','JscriptySessionReport','rawAttributes','fieldName','type','key','query','keys','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','includeAll','include','findAll','rows','catch','params','options','find','create','body','update','destroy','describe','getQuestions','findOne','JscriptyQuestionReport','order','SessionId','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','ejs','squel','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save'];(function(_0x5d07bb,_0x271464){var _0x42960a=function(_0x2f0724){while(--_0x2f0724){_0x5d07bb['push'](_0x5d07bb['shift']());}};_0x42960a(++_0x271464);}(_0x0a75,0xcd));var _0x50a7=function(_0x1f1fe5,_0x132821){_0x1f1fe5=_0x1f1fe5-0x0;var _0x4693c2=_0x0a75[_0x1f1fe5];return _0x4693c2;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0x50a7('0x0'));var zipdir=require(_0x50a7('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x50a7('0x2'));var moment=require(_0x50a7('0x3'));var BPromise=require(_0x50a7('0x4'));var Mustache=require(_0x50a7('0x5'));var util=require(_0x50a7('0x6'));var path=require(_0x50a7('0x7'));var sox=require(_0x50a7('0x8'));var csv=require('to-csv');var ejs=require(_0x50a7('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x50a7('0xa'));var crypto=require(_0x50a7('0xb'));var jsforce=require(_0x50a7('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x50a7('0xd'));var querystring=require(_0x50a7('0xe'));var Papa=require(_0x50a7('0xf'));var Redis=require(_0x50a7('0x10'));var authService=require(_0x50a7('0x11'));var qs=require(_0x50a7('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x50a7('0x13'));var logger=require(_0x50a7('0x14'))('api');var utils=require(_0x50a7('0x15'));var config=require(_0x50a7('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x39d80c,_0x3e107c){_0x3e107c=_0x3e107c||0xcc;return function(_0x4439c4){if(_0x4439c4){return _0x39d80c[_0x50a7('0x17')](_0x3e107c);}return _0x39d80c[_0x50a7('0x18')](_0x3e107c)[_0x50a7('0x19')]();};}function respondWithResult(_0x4c66f0,_0x171048){_0x171048=_0x171048||0xc8;return function(_0x83677a){if(_0x83677a){return _0x4c66f0[_0x50a7('0x18')](_0x171048)[_0x50a7('0x1a')](_0x83677a);}};}function respondWithFilteredResult(_0x3b6f91,_0x5e5b7e){return function(_0x52fdb6){if(_0x52fdb6){var _0x22fc1c=_0x52fdb6[_0x50a7('0x1b')],_0x2fba50=_0x5e5b7e[_0x50a7('0x1c')],_0x100b74=_0x5e5b7e[_0x50a7('0x1c')]+_0x5e5b7e[_0x50a7('0x1d')],_0x7be5e0;if(_0x100b74>=_0x22fc1c){_0x100b74=_0x22fc1c;_0x7be5e0=0xc8;}else{_0x7be5e0=0xce;}_0x3b6f91['status'](_0x7be5e0);return _0x3b6f91[_0x50a7('0x1e')](_0x50a7('0x1f'),_0x2fba50+'-'+_0x100b74+'/'+_0x22fc1c)[_0x50a7('0x1a')](_0x52fdb6);}return null;};}function patchUpdates(_0x261ce3){return function(_0x58fef1){try{jsonpatch[_0x50a7('0x20')](_0x58fef1,_0x261ce3,!![]);}catch(_0x56cf3d){return BPromise[_0x50a7('0x21')](_0x56cf3d);}return _0x58fef1[_0x50a7('0x22')]();};}function saveUpdates(_0xa4e6dc,_0x5dede2){return function(_0x3203b1){if(_0x3203b1){return _0x3203b1['update'](_0xa4e6dc)[_0x50a7('0x23')](function(_0x287da8){return _0x287da8;});}return null;};}function removeEntity(_0x5b3e2a,_0x46b77c){return function(_0x475db5){if(_0x475db5){return _0x475db5['destroy']()[_0x50a7('0x23')](function(){_0x5b3e2a['status'](0xcc)[_0x50a7('0x19')]();});}};}function handleEntityNotFound(_0x3f713f,_0x47dcf7){return function(_0x305d77){if(!_0x305d77){_0x3f713f[_0x50a7('0x17')](0x194);}return _0x305d77;};}function handleError(_0x244344,_0x47bf09){_0x47bf09=_0x47bf09||0x1f4;return function(_0x361bd7){logger[_0x50a7('0x24')](_0x361bd7[_0x50a7('0x25')]);if(_0x361bd7['name']){delete _0x361bd7[_0x50a7('0x26')];}_0x244344['status'](_0x47bf09)[_0x50a7('0x27')](_0x361bd7);};}exports[_0x50a7('0x28')]=function(_0x2e9dbb,_0x56d649){var _0x1c870a={},_0x1b409e={},_0x46d986={'count':0x0,'rows':[]};var _0x3f6a66=_[_0x50a7('0x29')](db[_0x50a7('0x2a')][_0x50a7('0x2b')],function(_0x54d7ac){return{'name':_0x54d7ac[_0x50a7('0x2c')],'type':_0x54d7ac[_0x50a7('0x2d')][_0x50a7('0x2e')]};});_0x1b409e['model']=_[_0x50a7('0x29')](_0x3f6a66,_0x50a7('0x26'));_0x1b409e[_0x50a7('0x2f')]=_[_0x50a7('0x30')](_0x2e9dbb['query']);_0x1b409e[_0x50a7('0x31')]=_[_0x50a7('0x32')](_0x1b409e['model'],_0x1b409e[_0x50a7('0x2f')]);_0x1c870a[_0x50a7('0x33')]=_[_0x50a7('0x32')](_0x1b409e[_0x50a7('0x34')],qs[_0x50a7('0x35')](_0x2e9dbb[_0x50a7('0x2f')][_0x50a7('0x35')]));_0x1c870a[_0x50a7('0x33')]=_0x1c870a[_0x50a7('0x33')][_0x50a7('0x36')]?_0x1c870a[_0x50a7('0x33')]:_0x1b409e[_0x50a7('0x34')];if(!_0x2e9dbb[_0x50a7('0x2f')][_0x50a7('0x37')](_0x50a7('0x38'))){_0x1c870a['limit']=qs['limit'](_0x2e9dbb[_0x50a7('0x2f')]['limit']);_0x1c870a['offset']=qs[_0x50a7('0x1c')](_0x2e9dbb['query'][_0x50a7('0x1c')]);}_0x1c870a['order']=qs[_0x50a7('0x39')](_0x2e9dbb['query'][_0x50a7('0x39')]);_0x1c870a[_0x50a7('0x3a')]=qs[_0x50a7('0x31')](_[_0x50a7('0x3b')](_0x2e9dbb['query'],_0x1b409e[_0x50a7('0x31')]));if(_0x2e9dbb[_0x50a7('0x2f')][_0x50a7('0x3c')]){_0x1c870a[_0x50a7('0x3a')]=_[_0x50a7('0x3d')](_0x1c870a['where'],{'$or':_[_0x50a7('0x29')](_0x3f6a66,function(_0x25ca58){if(_0x25ca58[_0x50a7('0x2d')]!=='VIRTUAL'){var _0x2a29ab={};_0x2a29ab[_0x25ca58[_0x50a7('0x26')]]={'$like':'%'+_0x2e9dbb[_0x50a7('0x2f')][_0x50a7('0x3c')]+'%'};return _0x2a29ab;}})});}_0x1c870a=_['merge']({},_0x1c870a,_0x2e9dbb['options']);var _0x4302b1={'where':_0x1c870a[_0x50a7('0x3a')]};return db['JscriptySessionReport'][_0x50a7('0x1b')](_0x4302b1)[_0x50a7('0x23')](function(_0x999987){_0x46d986[_0x50a7('0x1b')]=_0x999987;if(_0x2e9dbb['query'][_0x50a7('0x3e')]){_0x1c870a[_0x50a7('0x3f')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x50a7('0x40')](_0x1c870a);})['then'](function(_0x532487){_0x46d986[_0x50a7('0x41')]=_0x532487;return _0x46d986;})[_0x50a7('0x23')](respondWithFilteredResult(_0x56d649,_0x1c870a))[_0x50a7('0x42')](handleError(_0x56d649,null));};exports['show']=function(_0x28c760,_0x44b1f8){var _0x9b5393={'raw':!![],'where':{'id':_0x28c760[_0x50a7('0x43')]['id']}},_0x497cd7={};_0x497cd7['model']=_['keys'](db[_0x50a7('0x2a')][_0x50a7('0x2b')]);_0x497cd7[_0x50a7('0x2f')]=_[_0x50a7('0x30')](_0x28c760['query']);_0x497cd7[_0x50a7('0x31')]=_[_0x50a7('0x32')](_0x497cd7['model'],_0x497cd7[_0x50a7('0x2f')]);_0x9b5393[_0x50a7('0x33')]=_['intersection'](_0x497cd7['model'],qs['fields'](_0x28c760[_0x50a7('0x2f')][_0x50a7('0x35')]));_0x9b5393[_0x50a7('0x33')]=_0x9b5393['attributes'][_0x50a7('0x36')]?_0x9b5393[_0x50a7('0x33')]:_0x497cd7[_0x50a7('0x34')];if(_0x28c760[_0x50a7('0x2f')][_0x50a7('0x3e')]){_0x9b5393[_0x50a7('0x3f')]=[{'all':!![]}];}_0x9b5393=_[_0x50a7('0x3d')]({},_0x9b5393,_0x28c760[_0x50a7('0x44')]);return db[_0x50a7('0x2a')][_0x50a7('0x45')](_0x9b5393)[_0x50a7('0x23')](handleEntityNotFound(_0x44b1f8,null))[_0x50a7('0x23')](respondWithResult(_0x44b1f8,null))[_0x50a7('0x42')](handleError(_0x44b1f8,null));};exports[_0x50a7('0x46')]=function(_0x4f893b,_0x1590da){return db[_0x50a7('0x2a')][_0x50a7('0x46')](_0x4f893b[_0x50a7('0x47')],{})['then'](respondWithResult(_0x1590da,0xc9))[_0x50a7('0x42')](handleError(_0x1590da,null));};exports[_0x50a7('0x48')]=function(_0x2f17c8,_0x4beb69){if(_0x2f17c8['body']['id']){delete _0x2f17c8[_0x50a7('0x47')]['id'];}return db[_0x50a7('0x2a')]['find']({'where':{'id':_0x2f17c8[_0x50a7('0x43')]['id']}})[_0x50a7('0x23')](handleEntityNotFound(_0x4beb69,null))[_0x50a7('0x23')](saveUpdates(_0x2f17c8['body'],null))[_0x50a7('0x23')](respondWithResult(_0x4beb69,null))['catch'](handleError(_0x4beb69,null));};exports[_0x50a7('0x49')]=function(_0x1645e8,_0x21f862){return db[_0x50a7('0x2a')]['find']({'where':{'id':_0x1645e8[_0x50a7('0x43')]['id']}})[_0x50a7('0x23')](handleEntityNotFound(_0x21f862,null))['then'](removeEntity(_0x21f862,null))[_0x50a7('0x42')](handleError(_0x21f862,null));};exports[_0x50a7('0x4a')]=function(_0xc796a5,_0xef5bd2){return db[_0x50a7('0x2a')]['describe']()['then'](respondWithResult(_0xef5bd2,null))[_0x50a7('0x42')](handleError(_0xef5bd2,null));};exports[_0x50a7('0x4b')]=function(_0x3c63f8,_0x1ab5f7,_0x58f58d){var _0x34353c={'raw':!![],'where':{}};var _0x475058={};var _0x1dc9c0={'count':0x0,'rows':[]};return db[_0x50a7('0x2a')][_0x50a7('0x4c')]({'where':{'id':_0x3c63f8['params']['id']}})[_0x50a7('0x23')](handleEntityNotFound(_0x1ab5f7,null))[_0x50a7('0x23')](function(_0x2e19f6){if(_0x2e19f6){_0x475058[_0x50a7('0x34')]=_[_0x50a7('0x30')](db[_0x50a7('0x4d')]['rawAttributes']);_0x475058[_0x50a7('0x2f')]=_[_0x50a7('0x30')](_0x3c63f8[_0x50a7('0x2f')]);_0x475058[_0x50a7('0x31')]=_[_0x50a7('0x32')](_0x475058[_0x50a7('0x34')],_0x475058[_0x50a7('0x2f')]);_0x34353c['attributes']=_[_0x50a7('0x32')](_0x475058[_0x50a7('0x34')],qs['fields'](_0x3c63f8[_0x50a7('0x2f')][_0x50a7('0x35')]));_0x34353c[_0x50a7('0x33')]=_0x34353c[_0x50a7('0x33')][_0x50a7('0x36')]?_0x34353c[_0x50a7('0x33')]:_0x475058[_0x50a7('0x34')];if(!_0x3c63f8['query'][_0x50a7('0x37')](_0x50a7('0x38'))){_0x34353c[_0x50a7('0x1d')]=qs['limit'](_0x3c63f8[_0x50a7('0x2f')][_0x50a7('0x1d')]);_0x34353c['offset']=qs[_0x50a7('0x1c')](_0x3c63f8[_0x50a7('0x2f')][_0x50a7('0x1c')]);}_0x34353c[_0x50a7('0x4e')]=qs['sort'](_0x3c63f8[_0x50a7('0x2f')][_0x50a7('0x39')]);_0x34353c['where']=qs[_0x50a7('0x31')](_[_0x50a7('0x3b')](_0x3c63f8[_0x50a7('0x2f')],_0x475058[_0x50a7('0x31')]));_0x34353c[_0x50a7('0x3a')][_0x50a7('0x4f')]=_0x2e19f6['id'];if(_0x3c63f8[_0x50a7('0x2f')][_0x50a7('0x3c')]){_0x34353c[_0x50a7('0x3a')]=_[_0x50a7('0x3d')](_0x34353c[_0x50a7('0x3a')],{'$or':_[_0x50a7('0x29')](_0x34353c[_0x50a7('0x33')],function(_0x369f81){var _0x596fc2={};_0x596fc2[_0x369f81]={'$like':'%'+_0x3c63f8[_0x50a7('0x2f')][_0x50a7('0x3c')]+'%'};return _0x596fc2;})});}_0x34353c=_[_0x50a7('0x3d')]({},_0x34353c,_0x3c63f8['options']);return db[_0x50a7('0x4d')][_0x50a7('0x1b')]({'where':_0x34353c[_0x50a7('0x3a')]})[_0x50a7('0x23')](function(_0x2249d4){_0x1dc9c0[_0x50a7('0x1b')]=_0x2249d4;if(_0x3c63f8[_0x50a7('0x2f')][_0x50a7('0x3e')]){_0x34353c[_0x50a7('0x3f')]=[{'all':!![]}];}return db[_0x50a7('0x4d')][_0x50a7('0x40')](_0x34353c);})[_0x50a7('0x23')](function(_0x22d6bc){_0x1dc9c0[_0x50a7('0x41')]=_0x22d6bc;return _0x1dc9c0;});}})[_0x50a7('0x23')](respondWithFilteredResult(_0x1ab5f7,_0x34353c))[_0x50a7('0x42')](handleError(_0x1ab5f7,null));};