Built motion from commit 15aa0e42.|2.6.19
[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 _0x734e=['Sequelize','ValidationError','Report\x20not\x20found\x20or\x20empty','download','format','%s.%s','toLowerCase','eml-format','zip-dir','fast-json-patch','request-promise','moment','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','reject','save','then','get','ExtractedReports','UserProfileResource','error','stack','name','send','index','rawAttributes','fieldName','type','map','query','keys','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filters','filter','merge','VIRTUAL','options','AnalyticExtractedReport','includeAll','include','rows','catch','show','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','destroy','params','find','output','existsSync','join','root','server/files/reports','savename'];(function(_0x387777,_0x356171){var _0x3f84c0=function(_0x4d4423){while(--_0x4d4423){_0x387777['push'](_0x387777['shift']());}};_0x3f84c0(++_0x356171);}(_0x734e,0x18f));var _0xe734=function(_0x7dfb21,_0x54cbb5){_0x7dfb21=_0x7dfb21-0x0;var _0x544f45=_0x734e[_0x7dfb21];return _0x544f45;};'use strict';var emlformat=require(_0xe734('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xe734('0x1'));var jsonpatch=require(_0xe734('0x2'));var rp=require(_0xe734('0x3'));var moment=require(_0xe734('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0xe734('0x5'));var sox=require(_0xe734('0x6'));var csv=require('to-csv');var ejs=require(_0xe734('0x7'));var fs=require('fs');var fs_extra=require(_0xe734('0x8'));var _=require(_0xe734('0x9'));var squel=require(_0xe734('0xa'));var crypto=require(_0xe734('0xb'));var jsforce=require(_0xe734('0xc'));var deskjs=require(_0xe734('0xd'));var toCsv=require(_0xe734('0xe'));var querystring=require(_0xe734('0xf'));var Papa=require(_0xe734('0x10'));var Redis=require('ioredis');var authService=require(_0xe734('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0xe734('0x12'));var hardwareService=require(_0xe734('0x13'));var logger=require(_0xe734('0x14'))(_0xe734('0x15'));var utils=require('../../config/utils');var config=require(_0xe734('0x16'));var licenseUtil=require(_0xe734('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5e7c75,_0x1c342e){_0x1c342e=_0x1c342e||0xcc;return function(_0x36c518){if(_0x36c518){return _0x5e7c75[_0xe734('0x18')](_0x1c342e);}return _0x5e7c75[_0xe734('0x19')](_0x1c342e)[_0xe734('0x1a')]();};}function respondWithResult(_0x21e3a5,_0x1178b5){_0x1178b5=_0x1178b5||0xc8;return function(_0x2631f4){if(_0x2631f4){return _0x21e3a5[_0xe734('0x19')](_0x1178b5)[_0xe734('0x1b')](_0x2631f4);}};}function respondWithFilteredResult(_0x428671,_0x5be318){return function(_0x4d2690){if(_0x4d2690){var _0xa73ccd=typeof _0x5be318['offset']===_0xe734('0x1c')&&typeof _0x5be318[_0xe734('0x1d')]===_0xe734('0x1c');var _0x507d2a=_0x4d2690['count'];var _0xaf4f95=_0xa73ccd?0x0:_0x5be318['offset'];var _0x4291ab=_0xa73ccd?_0x4d2690[_0xe734('0x1e')]:_0x5be318[_0xe734('0x1f')]+_0x5be318[_0xe734('0x1d')];var _0x29930c;if(_0x4291ab>=_0x507d2a){_0x4291ab=_0x507d2a;_0x29930c=0xc8;}else{_0x29930c=0xce;}_0x428671[_0xe734('0x19')](_0x29930c);return _0x428671[_0xe734('0x20')](_0xe734('0x21'),_0xaf4f95+'-'+_0x4291ab+'/'+_0x507d2a)[_0xe734('0x1b')](_0x4d2690);}return null;};}function patchUpdates(_0x5191c8){return function(_0x507dc0){try{jsonpatch['apply'](_0x507dc0,_0x5191c8,!![]);}catch(_0x2dd95f){return BPromise[_0xe734('0x22')](_0x2dd95f);}return _0x507dc0[_0xe734('0x23')]();};}function saveUpdates(_0x30c315,_0xc2b02){return function(_0x2b8721){if(_0x2b8721){return _0x2b8721['update'](_0x30c315)['then'](function(_0x5be503){return _0x5be503;});}return null;};}function removeEntity(_0x52d408,_0x110c50){return function(_0xeae0b3){if(_0xeae0b3){return _0xeae0b3['destroy']()[_0xe734('0x24')](function(){var _0x44cb59=_0xeae0b3[_0xe734('0x25')]({'plain':!![]});var _0x4857d9=_0xe734('0x26');return db[_0xe734('0x27')]['destroy']({'where':{'type':_0x4857d9,'resourceId':_0x44cb59['id']}})['then'](function(){return _0xeae0b3;});})[_0xe734('0x24')](function(){_0x52d408[_0xe734('0x19')](0xcc)[_0xe734('0x1a')]();});}};}function handleEntityNotFound(_0x42e769,_0x3747b2){return function(_0x15e585){if(!_0x15e585){_0x42e769[_0xe734('0x18')](0x194);}return _0x15e585;};}function handleError(_0x56e635,_0x34166e){_0x34166e=_0x34166e||0x1f4;return function(_0x57dec1){logger[_0xe734('0x28')](_0x57dec1[_0xe734('0x29')]);if(_0x57dec1[_0xe734('0x2a')]){delete _0x57dec1[_0xe734('0x2a')];}_0x56e635['status'](_0x34166e)[_0xe734('0x2b')](_0x57dec1);};}exports[_0xe734('0x2c')]=function(_0x49cc7f,_0x81949b){var _0x5b0e4b={},_0xa1b7ee={},_0x4ca8d6={'count':0x0,'rows':[]};var _0x308d5a=_['map'](db['AnalyticExtractedReport'][_0xe734('0x2d')],function(_0x44eb14){return{'name':_0x44eb14[_0xe734('0x2e')],'type':_0x44eb14[_0xe734('0x2f')]['key']};});_0xa1b7ee['model']=_[_0xe734('0x30')](_0x308d5a,_0xe734('0x2a'));_0xa1b7ee[_0xe734('0x31')]=_[_0xe734('0x32')](_0x49cc7f[_0xe734('0x31')]);_0xa1b7ee['filters']=_[_0xe734('0x33')](_0xa1b7ee[_0xe734('0x34')],_0xa1b7ee['query']);_0x5b0e4b[_0xe734('0x35')]=_[_0xe734('0x33')](_0xa1b7ee[_0xe734('0x34')],qs[_0xe734('0x36')](_0x49cc7f[_0xe734('0x31')]['fields']));_0x5b0e4b[_0xe734('0x35')]=_0x5b0e4b['attributes'][_0xe734('0x37')]?_0x5b0e4b[_0xe734('0x35')]:_0xa1b7ee[_0xe734('0x34')];if(!_0x49cc7f['query'][_0xe734('0x38')](_0xe734('0x39'))){_0x5b0e4b[_0xe734('0x1d')]=qs[_0xe734('0x1d')](_0x49cc7f[_0xe734('0x31')][_0xe734('0x1d')]);_0x5b0e4b[_0xe734('0x1f')]=qs[_0xe734('0x1f')](_0x49cc7f['query'][_0xe734('0x1f')]);}_0x5b0e4b[_0xe734('0x3a')]=qs[_0xe734('0x3b')](_0x49cc7f[_0xe734('0x31')][_0xe734('0x3b')]);_0x5b0e4b[_0xe734('0x3c')]=qs['filters'](_[_0xe734('0x3d')](_0x49cc7f[_0xe734('0x31')],_0xa1b7ee[_0xe734('0x3e')]),_0x308d5a);if(_0x49cc7f[_0xe734('0x31')][_0xe734('0x3f')]){_0x5b0e4b[_0xe734('0x3c')]=_[_0xe734('0x40')](_0x5b0e4b[_0xe734('0x3c')],{'$or':_[_0xe734('0x30')](_0x308d5a,function(_0x3c3a7d){if(_0x3c3a7d['type']!==_0xe734('0x41')){var _0x447bd2={};_0x447bd2[_0x3c3a7d[_0xe734('0x2a')]]={'$like':'%'+_0x49cc7f['query']['filter']+'%'};return _0x447bd2;}})});}_0x5b0e4b=_['merge']({},_0x5b0e4b,_0x49cc7f[_0xe734('0x42')]);var _0x268992={'where':_0x5b0e4b[_0xe734('0x3c')]};return db[_0xe734('0x43')][_0xe734('0x1e')](_0x268992)[_0xe734('0x24')](function(_0x528580){_0x4ca8d6[_0xe734('0x1e')]=_0x528580;if(_0x49cc7f['query'][_0xe734('0x44')]){_0x5b0e4b[_0xe734('0x45')]=[{'all':!![]}];}return db['AnalyticExtractedReport']['findAll'](_0x5b0e4b);})[_0xe734('0x24')](function(_0x5b0b7e){_0x4ca8d6[_0xe734('0x46')]=_0x5b0b7e;return _0x4ca8d6;})[_0xe734('0x24')](respondWithFilteredResult(_0x81949b,_0x5b0e4b))[_0xe734('0x47')](handleError(_0x81949b,null));};exports[_0xe734('0x48')]=function(_0x1b0a08,_0x3aa32c){var _0x52b79f={'raw':!![],'where':{'id':_0x1b0a08['params']['id']}},_0x30ed05={};_0x30ed05[_0xe734('0x34')]=_['keys'](db[_0xe734('0x43')]['rawAttributes']);_0x30ed05[_0xe734('0x31')]=_[_0xe734('0x32')](_0x1b0a08[_0xe734('0x31')]);_0x30ed05['filters']=_[_0xe734('0x33')](_0x30ed05[_0xe734('0x34')],_0x30ed05[_0xe734('0x31')]);_0x52b79f[_0xe734('0x35')]=_['intersection'](_0x30ed05['model'],qs[_0xe734('0x36')](_0x1b0a08[_0xe734('0x31')][_0xe734('0x36')]));_0x52b79f[_0xe734('0x35')]=_0x52b79f['attributes'][_0xe734('0x37')]?_0x52b79f[_0xe734('0x35')]:_0x30ed05[_0xe734('0x34')];if(_0x1b0a08[_0xe734('0x31')][_0xe734('0x44')]){_0x52b79f[_0xe734('0x45')]=[{'all':!![]}];}_0x52b79f=_[_0xe734('0x40')]({},_0x52b79f,_0x1b0a08['options']);return db[_0xe734('0x43')]['find'](_0x52b79f)['then'](handleEntityNotFound(_0x3aa32c,null))[_0xe734('0x24')](respondWithResult(_0x3aa32c,null))[_0xe734('0x47')](handleError(_0x3aa32c,null));};exports[_0xe734('0x49')]=function(_0x58e972,_0x3b0255){return db[_0xe734('0x43')]['create'](_0x58e972[_0xe734('0x4a')],{})[_0xe734('0x24')](function(_0x3c40d6){var _0x4fab0a=_0x58e972[_0xe734('0x4b')]['get']({'plain':!![]});if(!_0x4fab0a)throw new Error(_0xe734('0x4c'));if(_0x4fab0a[_0xe734('0x4d')]==='user'){var _0x3626b6=_0x3c40d6[_0xe734('0x25')]({'plain':!![]});var _0x526aaa=_0xe734('0x26');return db['UserProfileSection']['find']({'where':{'name':_0x526aaa,'userProfileId':_0x4fab0a[_0xe734('0x4e')]},'raw':!![]})[_0xe734('0x24')](function(_0x3bb043){if(_0x3bb043&&_0x3bb043[_0xe734('0x4f')]===0x0){return db[_0xe734('0x27')][_0xe734('0x49')]({'name':_0x3626b6[_0xe734('0x2a')],'resourceId':_0x3626b6['id'],'type':_0x3bb043[_0xe734('0x2a')],'sectionId':_0x3bb043['id']},{})[_0xe734('0x24')](function(){return _0x3c40d6;});}else{return _0x3c40d6;}})[_0xe734('0x47')](function(_0x4c33c5){logger[_0xe734('0x28')](_0xe734('0x50'),_0x4c33c5);throw _0x4c33c5;});}return _0x3c40d6;})[_0xe734('0x24')](respondWithResult(_0x3b0255,0xc9))[_0xe734('0x47')](handleError(_0x3b0255,null));};exports[_0xe734('0x51')]=function(_0xda90e9,_0x26114e){if(_0xda90e9[_0xe734('0x4a')]['id']){delete _0xda90e9[_0xe734('0x4a')]['id'];}return db[_0xe734('0x43')]['find']({'where':{'id':_0xda90e9['params']['id']}})[_0xe734('0x24')](handleEntityNotFound(_0x26114e,null))['then'](saveUpdates(_0xda90e9['body'],null))[_0xe734('0x24')](respondWithResult(_0x26114e,null))['catch'](handleError(_0x26114e,null));};exports[_0xe734('0x52')]=function(_0x187744,_0x30db7d){return db[_0xe734('0x43')]['find']({'where':{'id':_0x187744[_0xe734('0x53')]['id']}})['then'](handleEntityNotFound(_0x30db7d,null))[_0xe734('0x24')](removeEntity(_0x30db7d,null))[_0xe734('0x47')](handleError(_0x30db7d,null));};exports['download']=function(_0x350675,_0x22ad40,_0xc2d096){return db[_0xe734('0x43')][_0xe734('0x54')]({'where':{'id':_0x350675['params']['id']},'attributes':[_0xe734('0x2a'),'basename','savename',_0xe734('0x55')],'raw':!![]})['then'](handleEntityNotFound(_0x22ad40,null))[_0xe734('0x24')](function(_0xffb35d){if(_0xffb35d){if(!fs[_0xe734('0x56')](path[_0xe734('0x57')](config[_0xe734('0x58')],_0xe734('0x59'),_0xffb35d[_0xe734('0x5a')]))){throw new db[(_0xe734('0x5b'))][(_0xe734('0x5c'))](_0xe734('0x5d'));}if(_0x350675['query']['exists']){return _0x22ad40[_0xe734('0x18')](0xc8);}return _0x22ad40[_0xe734('0x5e')](path[_0xe734('0x57')](config[_0xe734('0x58')],_0xe734('0x59'),_0xffb35d[_0xe734('0x5a')]),util[_0xe734('0x5f')](_0xe734('0x60'),_0xffb35d['basename']||_0xffb35d[_0xe734('0x2a')],_0xffb35d[_0xe734('0x55')][_0xe734('0x61')]()));}})[_0xe734('0x47')](handleError(_0x22ad40,null));};