dc49553f57310c20a9076863875e6ee920bf1958
[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 _0xaf6f=['then','ExtractedReports','UserProfileResource','destroy','sendStatus','stack','name','send','index','map','AnalyticExtractedReport','rawAttributes','fieldName','type','model','query','keys','intersection','attributes','hasOwnProperty','nolimit','order','sort','where','filters','filter','merge','VIRTUAL','options','includeAll','include','show','params','fields','catch','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','userProfileId','error','download','basename','savename','output','join','server/files/reports','ValidationError','Report\x20not\x20found\x20or\x20empty','exists','root','toLowerCase','eml-format','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','squel','jsforce','desk.js','to-csv','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','status','end','json','offset','undefined','limit','count','Content-Range','apply','reject','save','update'];(function(_0x3de8a4,_0x289a5c){var _0x4635cf=function(_0x2bddb8){while(--_0x2bddb8){_0x3de8a4['push'](_0x3de8a4['shift']());}};_0x4635cf(++_0x289a5c);}(_0xaf6f,0xf0));var _0xfaf6=function(_0x167d8a,_0xaa5f76){_0x167d8a=_0x167d8a-0x0;var _0x4966bd=_0xaf6f[_0x167d8a];return _0x4966bd;};'use strict';var emlformat=require(_0xfaf6('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xfaf6('0x1'));var rp=require(_0xfaf6('0x2'));var moment=require(_0xfaf6('0x3'));var BPromise=require(_0xfaf6('0x4'));var Mustache=require(_0xfaf6('0x5'));var util=require(_0xfaf6('0x6'));var path=require(_0xfaf6('0x7'));var sox=require(_0xfaf6('0x8'));var csv=require('to-csv');var ejs=require(_0xfaf6('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0xfaf6('0xa'));var crypto=require('crypto');var jsforce=require(_0xfaf6('0xb'));var deskjs=require(_0xfaf6('0xc'));var toCsv=require(_0xfaf6('0xd'));var querystring=require(_0xfaf6('0xe'));var Papa=require(_0xfaf6('0xf'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xfaf6('0x10'));var as=require(_0xfaf6('0x11'));var hardwareService=require(_0xfaf6('0x12'));var logger=require(_0xfaf6('0x13'))(_0xfaf6('0x14'));var utils=require('../../config/utils');var config=require(_0xfaf6('0x15'));var licenseUtil=require(_0xfaf6('0x16'));var db=require(_0xfaf6('0x17'))['db'];function respondWithStatusCode(_0x20505d,_0x453f5d){_0x453f5d=_0x453f5d||0xcc;return function(_0x53518e){if(_0x53518e){return _0x20505d['sendStatus'](_0x453f5d);}return _0x20505d[_0xfaf6('0x18')](_0x453f5d)[_0xfaf6('0x19')]();};}function respondWithResult(_0x16f43d,_0x13f4a7){_0x13f4a7=_0x13f4a7||0xc8;return function(_0x399a46){if(_0x399a46){return _0x16f43d['status'](_0x13f4a7)[_0xfaf6('0x1a')](_0x399a46);}};}function respondWithFilteredResult(_0x5265c8,_0x32d6cf){return function(_0x29d5dc){if(_0x29d5dc){var _0x4a6647=typeof _0x32d6cf[_0xfaf6('0x1b')]===_0xfaf6('0x1c')&&typeof _0x32d6cf[_0xfaf6('0x1d')]===_0xfaf6('0x1c');var _0x15f692=_0x29d5dc['count'];var _0x2529bc=_0x4a6647?0x0:_0x32d6cf['offset'];var _0xa0930b=_0x4a6647?_0x29d5dc[_0xfaf6('0x1e')]:_0x32d6cf[_0xfaf6('0x1b')]+_0x32d6cf['limit'];var _0xcaaaa;if(_0xa0930b>=_0x15f692){_0xa0930b=_0x15f692;_0xcaaaa=0xc8;}else{_0xcaaaa=0xce;}_0x5265c8[_0xfaf6('0x18')](_0xcaaaa);return _0x5265c8['set'](_0xfaf6('0x1f'),_0x2529bc+'-'+_0xa0930b+'/'+_0x15f692)[_0xfaf6('0x1a')](_0x29d5dc);}return null;};}function patchUpdates(_0x2081d8){return function(_0x3b4149){try{jsonpatch[_0xfaf6('0x20')](_0x3b4149,_0x2081d8,!![]);}catch(_0xd5be6){return BPromise[_0xfaf6('0x21')](_0xd5be6);}return _0x3b4149[_0xfaf6('0x22')]();};}function saveUpdates(_0x3b8be0,_0x17057b){return function(_0xf18018){if(_0xf18018){return _0xf18018[_0xfaf6('0x23')](_0x3b8be0)[_0xfaf6('0x24')](function(_0x179305){return _0x179305;});}return null;};}function removeEntity(_0x573538,_0x332a7d){return function(_0x410087){if(_0x410087){return _0x410087['destroy']()[_0xfaf6('0x24')](function(){var _0x2f2ed=_0x410087['get']({'plain':!![]});var _0x3c20e5=_0xfaf6('0x25');return db[_0xfaf6('0x26')][_0xfaf6('0x27')]({'where':{'type':_0x3c20e5,'resourceId':_0x2f2ed['id']}})[_0xfaf6('0x24')](function(){return _0x410087;});})[_0xfaf6('0x24')](function(){_0x573538[_0xfaf6('0x18')](0xcc)[_0xfaf6('0x19')]();});}};}function handleEntityNotFound(_0x3c768b,_0xef7b51){return function(_0xd95bb7){if(!_0xd95bb7){_0x3c768b[_0xfaf6('0x28')](0x194);}return _0xd95bb7;};}function handleError(_0x42aff1,_0x5a2a23){_0x5a2a23=_0x5a2a23||0x1f4;return function(_0x19f6fb){logger['error'](_0x19f6fb[_0xfaf6('0x29')]);if(_0x19f6fb[_0xfaf6('0x2a')]){delete _0x19f6fb[_0xfaf6('0x2a')];}_0x42aff1[_0xfaf6('0x18')](_0x5a2a23)[_0xfaf6('0x2b')](_0x19f6fb);};}exports[_0xfaf6('0x2c')]=function(_0xd6b0f5,_0x1a1522){var _0x373349={},_0x2f1fee={},_0x3bf05e={'count':0x0,'rows':[]};var _0x2065fb=_[_0xfaf6('0x2d')](db[_0xfaf6('0x2e')][_0xfaf6('0x2f')],function(_0x537971){return{'name':_0x537971[_0xfaf6('0x30')],'type':_0x537971[_0xfaf6('0x31')]['key']};});_0x2f1fee[_0xfaf6('0x32')]=_[_0xfaf6('0x2d')](_0x2065fb,_0xfaf6('0x2a'));_0x2f1fee[_0xfaf6('0x33')]=_[_0xfaf6('0x34')](_0xd6b0f5[_0xfaf6('0x33')]);_0x2f1fee['filters']=_[_0xfaf6('0x35')](_0x2f1fee['model'],_0x2f1fee[_0xfaf6('0x33')]);_0x373349[_0xfaf6('0x36')]=_[_0xfaf6('0x35')](_0x2f1fee[_0xfaf6('0x32')],qs['fields'](_0xd6b0f5['query']['fields']));_0x373349[_0xfaf6('0x36')]=_0x373349['attributes']['length']?_0x373349[_0xfaf6('0x36')]:_0x2f1fee[_0xfaf6('0x32')];if(!_0xd6b0f5[_0xfaf6('0x33')][_0xfaf6('0x37')](_0xfaf6('0x38'))){_0x373349[_0xfaf6('0x1d')]=qs[_0xfaf6('0x1d')](_0xd6b0f5['query'][_0xfaf6('0x1d')]);_0x373349[_0xfaf6('0x1b')]=qs[_0xfaf6('0x1b')](_0xd6b0f5[_0xfaf6('0x33')][_0xfaf6('0x1b')]);}_0x373349[_0xfaf6('0x39')]=qs['sort'](_0xd6b0f5[_0xfaf6('0x33')][_0xfaf6('0x3a')]);_0x373349[_0xfaf6('0x3b')]=qs[_0xfaf6('0x3c')](_['pick'](_0xd6b0f5[_0xfaf6('0x33')],_0x2f1fee[_0xfaf6('0x3c')]),_0x2065fb);if(_0xd6b0f5['query'][_0xfaf6('0x3d')]){_0x373349['where']=_[_0xfaf6('0x3e')](_0x373349[_0xfaf6('0x3b')],{'$or':_['map'](_0x2065fb,function(_0x588b01){if(_0x588b01[_0xfaf6('0x31')]!==_0xfaf6('0x3f')){var _0x14a805={};_0x14a805[_0x588b01[_0xfaf6('0x2a')]]={'$like':'%'+_0xd6b0f5[_0xfaf6('0x33')][_0xfaf6('0x3d')]+'%'};return _0x14a805;}})});}_0x373349=_['merge']({},_0x373349,_0xd6b0f5[_0xfaf6('0x40')]);var _0x381a27={'where':_0x373349[_0xfaf6('0x3b')]};return db[_0xfaf6('0x2e')][_0xfaf6('0x1e')](_0x381a27)[_0xfaf6('0x24')](function(_0x1e8988){_0x3bf05e[_0xfaf6('0x1e')]=_0x1e8988;if(_0xd6b0f5[_0xfaf6('0x33')][_0xfaf6('0x41')]){_0x373349[_0xfaf6('0x42')]=[{'all':!![]}];}return db['AnalyticExtractedReport']['findAll'](_0x373349);})[_0xfaf6('0x24')](function(_0x4db32b){_0x3bf05e['rows']=_0x4db32b;return _0x3bf05e;})[_0xfaf6('0x24')](respondWithFilteredResult(_0x1a1522,_0x373349))['catch'](handleError(_0x1a1522,null));};exports[_0xfaf6('0x43')]=function(_0x3e1442,_0x2266e9){var _0x1c6862={'raw':!![],'where':{'id':_0x3e1442[_0xfaf6('0x44')]['id']}},_0x3034c6={};_0x3034c6[_0xfaf6('0x32')]=_[_0xfaf6('0x34')](db[_0xfaf6('0x2e')][_0xfaf6('0x2f')]);_0x3034c6['query']=_[_0xfaf6('0x34')](_0x3e1442[_0xfaf6('0x33')]);_0x3034c6[_0xfaf6('0x3c')]=_[_0xfaf6('0x35')](_0x3034c6[_0xfaf6('0x32')],_0x3034c6[_0xfaf6('0x33')]);_0x1c6862[_0xfaf6('0x36')]=_[_0xfaf6('0x35')](_0x3034c6[_0xfaf6('0x32')],qs[_0xfaf6('0x45')](_0x3e1442['query'][_0xfaf6('0x45')]));_0x1c6862[_0xfaf6('0x36')]=_0x1c6862[_0xfaf6('0x36')]['length']?_0x1c6862[_0xfaf6('0x36')]:_0x3034c6[_0xfaf6('0x32')];if(_0x3e1442[_0xfaf6('0x33')][_0xfaf6('0x41')]){_0x1c6862['include']=[{'all':!![]}];}_0x1c6862=_['merge']({},_0x1c6862,_0x3e1442[_0xfaf6('0x40')]);return db['AnalyticExtractedReport']['find'](_0x1c6862)[_0xfaf6('0x24')](handleEntityNotFound(_0x2266e9,null))[_0xfaf6('0x24')](respondWithResult(_0x2266e9,null))[_0xfaf6('0x46')](handleError(_0x2266e9,null));};exports['create']=function(_0xbb7979,_0x2b2c44){return db[_0xfaf6('0x2e')][_0xfaf6('0x47')](_0xbb7979[_0xfaf6('0x48')],{})[_0xfaf6('0x24')](function(_0x5b64fd){var _0x3d01bf=_0xbb7979[_0xfaf6('0x49')][_0xfaf6('0x4a')]({'plain':!![]});if(!_0x3d01bf)throw new Error(_0xfaf6('0x4b'));if(_0x3d01bf[_0xfaf6('0x4c')]===_0xfaf6('0x49')){var _0x38606d=_0x5b64fd[_0xfaf6('0x4a')]({'plain':!![]});var _0xf1c8f5=_0xfaf6('0x25');return db[_0xfaf6('0x4d')][_0xfaf6('0x4e')]({'where':{'name':_0xf1c8f5,'userProfileId':_0x3d01bf[_0xfaf6('0x4f')]},'raw':!![]})['then'](function(_0x3c29d2){if(_0x3c29d2&&_0x3c29d2['autoAssociation']===0x0){return db[_0xfaf6('0x26')][_0xfaf6('0x47')]({'name':_0x38606d[_0xfaf6('0x2a')],'resourceId':_0x38606d['id'],'type':_0x3c29d2[_0xfaf6('0x2a')],'sectionId':_0x3c29d2['id']},{})[_0xfaf6('0x24')](function(){return _0x5b64fd;});}else{return _0x5b64fd;}})[_0xfaf6('0x46')](function(_0x439ac4){logger[_0xfaf6('0x50')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x439ac4);throw _0x439ac4;});}return _0x5b64fd;})[_0xfaf6('0x24')](respondWithResult(_0x2b2c44,0xc9))['catch'](handleError(_0x2b2c44,null));};exports['update']=function(_0x13cef8,_0x4dc5ff){if(_0x13cef8[_0xfaf6('0x48')]['id']){delete _0x13cef8[_0xfaf6('0x48')]['id'];}return db[_0xfaf6('0x2e')]['find']({'where':{'id':_0x13cef8[_0xfaf6('0x44')]['id']}})[_0xfaf6('0x24')](handleEntityNotFound(_0x4dc5ff,null))[_0xfaf6('0x24')](saveUpdates(_0x13cef8[_0xfaf6('0x48')],null))[_0xfaf6('0x24')](respondWithResult(_0x4dc5ff,null))['catch'](handleError(_0x4dc5ff,null));};exports[_0xfaf6('0x27')]=function(_0x64b922,_0x1163f2){return db[_0xfaf6('0x2e')]['find']({'where':{'id':_0x64b922[_0xfaf6('0x44')]['id']}})[_0xfaf6('0x24')](handleEntityNotFound(_0x1163f2,null))['then'](removeEntity(_0x1163f2,null))[_0xfaf6('0x46')](handleError(_0x1163f2,null));};exports[_0xfaf6('0x51')]=function(_0x599a8a,_0x4ab925,_0x4e58d1){return db[_0xfaf6('0x2e')]['find']({'where':{'id':_0x599a8a[_0xfaf6('0x44')]['id']},'attributes':[_0xfaf6('0x2a'),_0xfaf6('0x52'),_0xfaf6('0x53'),_0xfaf6('0x54')],'raw':!![]})[_0xfaf6('0x24')](handleEntityNotFound(_0x4ab925,null))['then'](function(_0x21cf61){if(_0x21cf61){if(!fs['existsSync'](path[_0xfaf6('0x55')](config['root'],_0xfaf6('0x56'),_0x21cf61['savename']))){throw new db['Sequelize'][(_0xfaf6('0x57'))](_0xfaf6('0x58'));}if(_0x599a8a[_0xfaf6('0x33')][_0xfaf6('0x59')]){return _0x4ab925[_0xfaf6('0x28')](0xc8);}return _0x4ab925[_0xfaf6('0x51')](path[_0xfaf6('0x55')](config[_0xfaf6('0x5a')],_0xfaf6('0x56'),_0x21cf61[_0xfaf6('0x53')]),util['format']('%s.%s',_0x21cf61['basename']||_0x21cf61[_0xfaf6('0x2a')],_0x21cf61[_0xfaf6('0x54')][_0xfaf6('0x5b')]()));}})['catch'](handleError(_0x4ab925,null));};