Built motion from commit da617fac.|2.6.6
[motion2.git] / server / api / analyticExtractedReport / analyticExtractedReport.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 _0x3f1a=['hasOwnProperty','nolimit','limit','order','sort','filters','pick','filter','merge','where','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','autoAssociation','error','basename','output','existsSync','join','root','server/files/reports','Report\x20not\x20found\x20or\x20empty','exists','download','savename','format','%s.%s','toLowerCase','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/license/util','../../mysqldb','sendStatus','end','status','json','undefined','count','offset','set','Content-Range','save','update','then','destroy','get','UserProfileResource','stack','name','send','index','map','AnalyticExtractedReport','type','key','model','query','keys','intersection','attributes','fields','length'];(function(_0xd93406,_0x5041d2){var _0x258da5=function(_0x3b50f1){while(--_0x3b50f1){_0xd93406['push'](_0xd93406['shift']());}};_0x258da5(++_0x5041d2);}(_0x3f1a,0x1b2));var _0xa3f1=function(_0x2099ec,_0x1954b2){_0x2099ec=_0x2099ec-0x0;var _0x5b3621=_0x3f1a[_0x2099ec];return _0x5b3621;};'use strict';var emlformat=require(_0xa3f1('0x0'));var rimraf=require(_0xa3f1('0x1'));var zipdir=require(_0xa3f1('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xa3f1('0x3'));var moment=require(_0xa3f1('0x4'));var BPromise=require(_0xa3f1('0x5'));var Mustache=require(_0xa3f1('0x6'));var util=require(_0xa3f1('0x7'));var path=require(_0xa3f1('0x8'));var sox=require('sox');var csv=require(_0xa3f1('0x9'));var ejs=require(_0xa3f1('0xa'));var fs=require('fs');var fs_extra=require(_0xa3f1('0xb'));var _=require(_0xa3f1('0xc'));var squel=require(_0xa3f1('0xd'));var crypto=require('crypto');var jsforce=require(_0xa3f1('0xe'));var deskjs=require(_0xa3f1('0xf'));var toCsv=require(_0xa3f1('0x9'));var querystring=require(_0xa3f1('0x10'));var Papa=require(_0xa3f1('0x11'));var Redis=require(_0xa3f1('0x12'));var authService=require(_0xa3f1('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0xa3f1('0x14'));var hardwareService=require(_0xa3f1('0x15'));var logger=require(_0xa3f1('0x16'))(_0xa3f1('0x17'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0xa3f1('0x18'));var db=require(_0xa3f1('0x19'))['db'];function respondWithStatusCode(_0xd16f29,_0xcefc64){_0xcefc64=_0xcefc64||0xcc;return function(_0xc2e808){if(_0xc2e808){return _0xd16f29[_0xa3f1('0x1a')](_0xcefc64);}return _0xd16f29['status'](_0xcefc64)[_0xa3f1('0x1b')]();};}function respondWithResult(_0xa06aee,_0x2ad459){_0x2ad459=_0x2ad459||0xc8;return function(_0x3fb889){if(_0x3fb889){return _0xa06aee[_0xa3f1('0x1c')](_0x2ad459)[_0xa3f1('0x1d')](_0x3fb889);}};}function respondWithFilteredResult(_0x170e4d,_0x3ae8bf){return function(_0x3cff6e){if(_0x3cff6e){var _0x54e89e=typeof _0x3ae8bf['offset']===_0xa3f1('0x1e')&&typeof _0x3ae8bf['limit']===_0xa3f1('0x1e');var _0x2f7d35=_0x3cff6e[_0xa3f1('0x1f')];var _0x1684fe=_0x54e89e?0x0:_0x3ae8bf[_0xa3f1('0x20')];var _0x1b929d=_0x54e89e?_0x3cff6e['count']:_0x3ae8bf[_0xa3f1('0x20')]+_0x3ae8bf['limit'];var _0xe02917;if(_0x1b929d>=_0x2f7d35){_0x1b929d=_0x2f7d35;_0xe02917=0xc8;}else{_0xe02917=0xce;}_0x170e4d['status'](_0xe02917);return _0x170e4d[_0xa3f1('0x21')](_0xa3f1('0x22'),_0x1684fe+'-'+_0x1b929d+'/'+_0x2f7d35)[_0xa3f1('0x1d')](_0x3cff6e);}return null;};}function patchUpdates(_0x213810){return function(_0x3ebde3){try{jsonpatch['apply'](_0x3ebde3,_0x213810,!![]);}catch(_0x2520d2){return BPromise['reject'](_0x2520d2);}return _0x3ebde3[_0xa3f1('0x23')]();};}function saveUpdates(_0xadb0eb,_0x28ec44){return function(_0x35d607){if(_0x35d607){return _0x35d607[_0xa3f1('0x24')](_0xadb0eb)[_0xa3f1('0x25')](function(_0x19523f){return _0x19523f;});}return null;};}function removeEntity(_0x18f312,_0xb77088){return function(_0x416e92){if(_0x416e92){return _0x416e92[_0xa3f1('0x26')]()[_0xa3f1('0x25')](function(){var _0x2e6a0c=_0x416e92[_0xa3f1('0x27')]({'plain':!![]});var _0x3bd138='ExtractedReports';return db[_0xa3f1('0x28')]['destroy']({'where':{'type':_0x3bd138,'resourceId':_0x2e6a0c['id']}})[_0xa3f1('0x25')](function(){return _0x416e92;});})[_0xa3f1('0x25')](function(){_0x18f312[_0xa3f1('0x1c')](0xcc)[_0xa3f1('0x1b')]();});}};}function handleEntityNotFound(_0x36bef3,_0x5e9603){return function(_0x4d0ca3){if(!_0x4d0ca3){_0x36bef3['sendStatus'](0x194);}return _0x4d0ca3;};}function handleError(_0x33d7ce,_0x29a961){_0x29a961=_0x29a961||0x1f4;return function(_0x105548){logger['error'](_0x105548[_0xa3f1('0x29')]);if(_0x105548[_0xa3f1('0x2a')]){delete _0x105548[_0xa3f1('0x2a')];}_0x33d7ce[_0xa3f1('0x1c')](_0x29a961)[_0xa3f1('0x2b')](_0x105548);};}exports[_0xa3f1('0x2c')]=function(_0x5e159b,_0x328af3){var _0x546b70={},_0x1f323e={},_0x4c2e68={'count':0x0,'rows':[]};var _0x309e07=_[_0xa3f1('0x2d')](db[_0xa3f1('0x2e')]['rawAttributes'],function(_0x2eb10b){return{'name':_0x2eb10b['fieldName'],'type':_0x2eb10b[_0xa3f1('0x2f')][_0xa3f1('0x30')]};});_0x1f323e[_0xa3f1('0x31')]=_[_0xa3f1('0x2d')](_0x309e07,_0xa3f1('0x2a'));_0x1f323e[_0xa3f1('0x32')]=_[_0xa3f1('0x33')](_0x5e159b[_0xa3f1('0x32')]);_0x1f323e['filters']=_[_0xa3f1('0x34')](_0x1f323e[_0xa3f1('0x31')],_0x1f323e[_0xa3f1('0x32')]);_0x546b70[_0xa3f1('0x35')]=_[_0xa3f1('0x34')](_0x1f323e['model'],qs[_0xa3f1('0x36')](_0x5e159b[_0xa3f1('0x32')][_0xa3f1('0x36')]));_0x546b70['attributes']=_0x546b70[_0xa3f1('0x35')][_0xa3f1('0x37')]?_0x546b70['attributes']:_0x1f323e[_0xa3f1('0x31')];if(!_0x5e159b[_0xa3f1('0x32')][_0xa3f1('0x38')](_0xa3f1('0x39'))){_0x546b70['limit']=qs['limit'](_0x5e159b[_0xa3f1('0x32')][_0xa3f1('0x3a')]);_0x546b70[_0xa3f1('0x20')]=qs[_0xa3f1('0x20')](_0x5e159b[_0xa3f1('0x32')][_0xa3f1('0x20')]);}_0x546b70[_0xa3f1('0x3b')]=qs[_0xa3f1('0x3c')](_0x5e159b['query'][_0xa3f1('0x3c')]);_0x546b70['where']=qs[_0xa3f1('0x3d')](_[_0xa3f1('0x3e')](_0x5e159b[_0xa3f1('0x32')],_0x1f323e[_0xa3f1('0x3d')]),_0x309e07);if(_0x5e159b[_0xa3f1('0x32')][_0xa3f1('0x3f')]){_0x546b70['where']=_[_0xa3f1('0x40')](_0x546b70[_0xa3f1('0x41')],{'$or':_['map'](_0x309e07,function(_0x2ccb49){if(_0x2ccb49[_0xa3f1('0x2f')]!==_0xa3f1('0x42')){var _0x247895={};_0x247895[_0x2ccb49['name']]={'$like':'%'+_0x5e159b[_0xa3f1('0x32')][_0xa3f1('0x3f')]+'%'};return _0x247895;}})});}_0x546b70=_[_0xa3f1('0x40')]({},_0x546b70,_0x5e159b[_0xa3f1('0x43')]);var _0x30fdd3={'where':_0x546b70[_0xa3f1('0x41')]};return db['AnalyticExtractedReport'][_0xa3f1('0x1f')](_0x30fdd3)['then'](function(_0x36dcc7){_0x4c2e68[_0xa3f1('0x1f')]=_0x36dcc7;if(_0x5e159b[_0xa3f1('0x32')][_0xa3f1('0x44')]){_0x546b70[_0xa3f1('0x45')]=[{'all':!![]}];}return db[_0xa3f1('0x2e')][_0xa3f1('0x46')](_0x546b70);})[_0xa3f1('0x25')](function(_0xc3c43a){_0x4c2e68[_0xa3f1('0x47')]=_0xc3c43a;return _0x4c2e68;})[_0xa3f1('0x25')](respondWithFilteredResult(_0x328af3,_0x546b70))[_0xa3f1('0x48')](handleError(_0x328af3,null));};exports[_0xa3f1('0x49')]=function(_0x3c73c7,_0x3c073d){var _0x9c49c0={'raw':!![],'where':{'id':_0x3c73c7[_0xa3f1('0x4a')]['id']}},_0x1b1f09={};_0x1b1f09[_0xa3f1('0x31')]=_[_0xa3f1('0x33')](db[_0xa3f1('0x2e')]['rawAttributes']);_0x1b1f09['query']=_[_0xa3f1('0x33')](_0x3c73c7['query']);_0x1b1f09[_0xa3f1('0x3d')]=_[_0xa3f1('0x34')](_0x1b1f09[_0xa3f1('0x31')],_0x1b1f09[_0xa3f1('0x32')]);_0x9c49c0['attributes']=_['intersection'](_0x1b1f09[_0xa3f1('0x31')],qs['fields'](_0x3c73c7[_0xa3f1('0x32')][_0xa3f1('0x36')]));_0x9c49c0[_0xa3f1('0x35')]=_0x9c49c0['attributes'][_0xa3f1('0x37')]?_0x9c49c0[_0xa3f1('0x35')]:_0x1b1f09[_0xa3f1('0x31')];if(_0x3c73c7[_0xa3f1('0x32')][_0xa3f1('0x44')]){_0x9c49c0['include']=[{'all':!![]}];}_0x9c49c0=_[_0xa3f1('0x40')]({},_0x9c49c0,_0x3c73c7[_0xa3f1('0x43')]);return db[_0xa3f1('0x2e')][_0xa3f1('0x4b')](_0x9c49c0)[_0xa3f1('0x25')](handleEntityNotFound(_0x3c073d,null))[_0xa3f1('0x25')](respondWithResult(_0x3c073d,null))[_0xa3f1('0x48')](handleError(_0x3c073d,null));};exports['create']=function(_0x59cd9e,_0x13abcf){return db['AnalyticExtractedReport'][_0xa3f1('0x4c')](_0x59cd9e[_0xa3f1('0x4d')],{})[_0xa3f1('0x25')](function(_0x14c64c){var _0x5b0904=_0x59cd9e['user'][_0xa3f1('0x27')]({'plain':!![]});if(!_0x5b0904)throw new Error(_0xa3f1('0x4e'));if(_0x5b0904[_0xa3f1('0x4f')]===_0xa3f1('0x50')){var _0x12e091=_0x14c64c['get']({'plain':!![]});var _0x2af8d0='ExtractedReports';return db[_0xa3f1('0x51')]['find']({'where':{'name':_0x2af8d0,'userProfileId':_0x5b0904[_0xa3f1('0x52')]},'raw':!![]})[_0xa3f1('0x25')](function(_0x5afc96){if(_0x5afc96&&_0x5afc96[_0xa3f1('0x53')]===0x0){return db[_0xa3f1('0x28')][_0xa3f1('0x4c')]({'name':_0x12e091[_0xa3f1('0x2a')],'resourceId':_0x12e091['id'],'type':_0x5afc96['name'],'sectionId':_0x5afc96['id']},{})[_0xa3f1('0x25')](function(){return _0x14c64c;});}else{return _0x14c64c;}})[_0xa3f1('0x48')](function(_0x1d19e0){logger[_0xa3f1('0x54')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x1d19e0);throw _0x1d19e0;});}return _0x14c64c;})['then'](respondWithResult(_0x13abcf,0xc9))[_0xa3f1('0x48')](handleError(_0x13abcf,null));};exports[_0xa3f1('0x24')]=function(_0x142964,_0x157f41){if(_0x142964[_0xa3f1('0x4d')]['id']){delete _0x142964[_0xa3f1('0x4d')]['id'];}return db[_0xa3f1('0x2e')][_0xa3f1('0x4b')]({'where':{'id':_0x142964[_0xa3f1('0x4a')]['id']}})[_0xa3f1('0x25')](handleEntityNotFound(_0x157f41,null))['then'](saveUpdates(_0x142964['body'],null))[_0xa3f1('0x25')](respondWithResult(_0x157f41,null))[_0xa3f1('0x48')](handleError(_0x157f41,null));};exports['destroy']=function(_0x19d8c9,_0xfe8255){return db[_0xa3f1('0x2e')][_0xa3f1('0x4b')]({'where':{'id':_0x19d8c9[_0xa3f1('0x4a')]['id']}})[_0xa3f1('0x25')](handleEntityNotFound(_0xfe8255,null))[_0xa3f1('0x25')](removeEntity(_0xfe8255,null))[_0xa3f1('0x48')](handleError(_0xfe8255,null));};exports['download']=function(_0x54e20b,_0x232392,_0x35f344){return db['AnalyticExtractedReport'][_0xa3f1('0x4b')]({'where':{'id':_0x54e20b[_0xa3f1('0x4a')]['id']},'attributes':[_0xa3f1('0x2a'),_0xa3f1('0x55'),'savename',_0xa3f1('0x56')],'raw':!![]})[_0xa3f1('0x25')](handleEntityNotFound(_0x232392,null))['then'](function(_0x43f0f4){if(_0x43f0f4){if(!fs[_0xa3f1('0x57')](path[_0xa3f1('0x58')](config[_0xa3f1('0x59')],_0xa3f1('0x5a'),_0x43f0f4['savename']))){throw new db['Sequelize']['ValidationError'](_0xa3f1('0x5b'));}if(_0x54e20b[_0xa3f1('0x32')][_0xa3f1('0x5c')]){return _0x232392[_0xa3f1('0x1a')](0xc8);}return _0x232392[_0xa3f1('0x5d')](path[_0xa3f1('0x58')](config[_0xa3f1('0x59')],_0xa3f1('0x5a'),_0x43f0f4[_0xa3f1('0x5e')]),util[_0xa3f1('0x5f')](_0xa3f1('0x60'),_0x43f0f4['basename']||_0x43f0f4[_0xa3f1('0x2a')],_0x43f0f4[_0xa3f1('0x56')][_0xa3f1('0x61')]()));}})['catch'](handleError(_0x232392,null));};