c04f07857485a3c98a3459be9eb74740773e1204
[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 _0x61a1=['include','findAll','rows','catch','params','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','download','savename','output','existsSync','join','server/files/reports','Sequelize','ValidationError','Report\x20not\x20found\x20or\x20empty','exists','format','%s.%s','toLowerCase','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','squel','crypto','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','offset','undefined','count','limit','set','Content-Range','apply','reject','save','update','destroy','then','ExtractedReports','UserProfileResource','end','error','stack','name','send','map','AnalyticExtractedReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL','options','includeAll'];(function(_0x3ee1c2,_0x36c4c1){var _0x77397d=function(_0x2d2808){while(--_0x2d2808){_0x3ee1c2['push'](_0x3ee1c2['shift']());}};_0x77397d(++_0x36c4c1);}(_0x61a1,0x1a0));var _0x161a=function(_0x4099ee,_0x38495a){_0x4099ee=_0x4099ee-0x0;var _0x1b7bfc=_0x61a1[_0x4099ee];return _0x1b7bfc;};'use strict';var emlformat=require(_0x161a('0x0'));var rimraf=require(_0x161a('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x161a('0x2'));var rp=require(_0x161a('0x3'));var moment=require(_0x161a('0x4'));var BPromise=require(_0x161a('0x5'));var Mustache=require('mustache');var util=require(_0x161a('0x6'));var path=require(_0x161a('0x7'));var sox=require(_0x161a('0x8'));var csv=require(_0x161a('0x9'));var ejs=require(_0x161a('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x161a('0xb'));var crypto=require(_0x161a('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x161a('0xd'));var toCsv=require(_0x161a('0x9'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x161a('0xe'));var authService=require(_0x161a('0xf'));var qs=require(_0x161a('0x10'));var as=require(_0x161a('0x11'));var hardwareService=require(_0x161a('0x12'));var logger=require(_0x161a('0x13'))(_0x161a('0x14'));var utils=require(_0x161a('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0x161a('0x16'));var db=require(_0x161a('0x17'))['db'];function respondWithStatusCode(_0x2e36dd,_0x20d672){_0x20d672=_0x20d672||0xcc;return function(_0x4a7554){if(_0x4a7554){return _0x2e36dd[_0x161a('0x18')](_0x20d672);}return _0x2e36dd[_0x161a('0x19')](_0x20d672)['end']();};}function respondWithResult(_0x4172fe,_0x4c84b5){_0x4c84b5=_0x4c84b5||0xc8;return function(_0x23b335){if(_0x23b335){return _0x4172fe[_0x161a('0x19')](_0x4c84b5)['json'](_0x23b335);}};}function respondWithFilteredResult(_0xdfb99f,_0x192ac2){return function(_0x508a70){if(_0x508a70){var _0xf95a56=typeof _0x192ac2[_0x161a('0x1a')]===_0x161a('0x1b')&&typeof _0x192ac2['limit']===_0x161a('0x1b');var _0x101ec3=_0x508a70[_0x161a('0x1c')];var _0x3953b2=_0xf95a56?0x0:_0x192ac2[_0x161a('0x1a')];var _0x53224a=_0xf95a56?_0x508a70[_0x161a('0x1c')]:_0x192ac2[_0x161a('0x1a')]+_0x192ac2[_0x161a('0x1d')];var _0x1b164b;if(_0x53224a>=_0x101ec3){_0x53224a=_0x101ec3;_0x1b164b=0xc8;}else{_0x1b164b=0xce;}_0xdfb99f[_0x161a('0x19')](_0x1b164b);return _0xdfb99f[_0x161a('0x1e')](_0x161a('0x1f'),_0x3953b2+'-'+_0x53224a+'/'+_0x101ec3)['json'](_0x508a70);}return null;};}function patchUpdates(_0x55b180){return function(_0x357a16){try{jsonpatch[_0x161a('0x20')](_0x357a16,_0x55b180,!![]);}catch(_0xe80163){return BPromise[_0x161a('0x21')](_0xe80163);}return _0x357a16[_0x161a('0x22')]();};}function saveUpdates(_0x25e89c,_0x4cc82e){return function(_0x5c33b4){if(_0x5c33b4){return _0x5c33b4[_0x161a('0x23')](_0x25e89c)['then'](function(_0x288178){return _0x288178;});}return null;};}function removeEntity(_0x1215a7,_0x1df687){return function(_0x1702e6){if(_0x1702e6){return _0x1702e6[_0x161a('0x24')]()[_0x161a('0x25')](function(){var _0x218517=_0x1702e6['get']({'plain':!![]});var _0x244246=_0x161a('0x26');return db[_0x161a('0x27')]['destroy']({'where':{'type':_0x244246,'resourceId':_0x218517['id']}})[_0x161a('0x25')](function(){return _0x1702e6;});})[_0x161a('0x25')](function(){_0x1215a7[_0x161a('0x19')](0xcc)[_0x161a('0x28')]();});}};}function handleEntityNotFound(_0x42ab8f,_0x13a868){return function(_0x1ee5fd){if(!_0x1ee5fd){_0x42ab8f[_0x161a('0x18')](0x194);}return _0x1ee5fd;};}function handleError(_0x3b1efb,_0x1c356a){_0x1c356a=_0x1c356a||0x1f4;return function(_0x56da57){logger[_0x161a('0x29')](_0x56da57[_0x161a('0x2a')]);if(_0x56da57[_0x161a('0x2b')]){delete _0x56da57[_0x161a('0x2b')];}_0x3b1efb[_0x161a('0x19')](_0x1c356a)[_0x161a('0x2c')](_0x56da57);};}exports['index']=function(_0x3f2823,_0x4b19a2){var _0xde55c1={},_0x4eb214={},_0x24b162={'count':0x0,'rows':[]};var _0xab4a4c=_[_0x161a('0x2d')](db[_0x161a('0x2e')][_0x161a('0x2f')],function(_0x2decf2){return{'name':_0x2decf2[_0x161a('0x30')],'type':_0x2decf2[_0x161a('0x31')][_0x161a('0x32')]};});_0x4eb214[_0x161a('0x33')]=_['map'](_0xab4a4c,_0x161a('0x2b'));_0x4eb214[_0x161a('0x34')]=_[_0x161a('0x35')](_0x3f2823[_0x161a('0x34')]);_0x4eb214[_0x161a('0x36')]=_[_0x161a('0x37')](_0x4eb214[_0x161a('0x33')],_0x4eb214[_0x161a('0x34')]);_0xde55c1[_0x161a('0x38')]=_[_0x161a('0x37')](_0x4eb214[_0x161a('0x33')],qs[_0x161a('0x39')](_0x3f2823['query'][_0x161a('0x39')]));_0xde55c1[_0x161a('0x38')]=_0xde55c1[_0x161a('0x38')][_0x161a('0x3a')]?_0xde55c1[_0x161a('0x38')]:_0x4eb214['model'];if(!_0x3f2823[_0x161a('0x34')][_0x161a('0x3b')](_0x161a('0x3c'))){_0xde55c1[_0x161a('0x1d')]=qs['limit'](_0x3f2823['query']['limit']);_0xde55c1['offset']=qs['offset'](_0x3f2823[_0x161a('0x34')]['offset']);}_0xde55c1['order']=qs[_0x161a('0x3d')](_0x3f2823[_0x161a('0x34')][_0x161a('0x3d')]);_0xde55c1[_0x161a('0x3e')]=qs[_0x161a('0x36')](_[_0x161a('0x3f')](_0x3f2823['query'],_0x4eb214[_0x161a('0x36')]),_0xab4a4c);if(_0x3f2823['query'][_0x161a('0x40')]){_0xde55c1[_0x161a('0x3e')]=_[_0x161a('0x41')](_0xde55c1[_0x161a('0x3e')],{'$or':_[_0x161a('0x2d')](_0xab4a4c,function(_0x4e303c){if(_0x4e303c[_0x161a('0x31')]!==_0x161a('0x42')){var _0x557d52={};_0x557d52[_0x4e303c[_0x161a('0x2b')]]={'$like':'%'+_0x3f2823[_0x161a('0x34')]['filter']+'%'};return _0x557d52;}})});}_0xde55c1=_[_0x161a('0x41')]({},_0xde55c1,_0x3f2823[_0x161a('0x43')]);var _0x34e4c1={'where':_0xde55c1[_0x161a('0x3e')]};return db['AnalyticExtractedReport'][_0x161a('0x1c')](_0x34e4c1)[_0x161a('0x25')](function(_0x3f6acb){_0x24b162[_0x161a('0x1c')]=_0x3f6acb;if(_0x3f2823[_0x161a('0x34')][_0x161a('0x44')]){_0xde55c1[_0x161a('0x45')]=[{'all':!![]}];}return db[_0x161a('0x2e')][_0x161a('0x46')](_0xde55c1);})[_0x161a('0x25')](function(_0x50df87){_0x24b162[_0x161a('0x47')]=_0x50df87;return _0x24b162;})[_0x161a('0x25')](respondWithFilteredResult(_0x4b19a2,_0xde55c1))[_0x161a('0x48')](handleError(_0x4b19a2,null));};exports['show']=function(_0x17e0f3,_0x429533){var _0x32284a={'raw':!![],'where':{'id':_0x17e0f3[_0x161a('0x49')]['id']}},_0x1cbf50={};_0x1cbf50['model']=_[_0x161a('0x35')](db[_0x161a('0x2e')][_0x161a('0x2f')]);_0x1cbf50[_0x161a('0x34')]=_[_0x161a('0x35')](_0x17e0f3[_0x161a('0x34')]);_0x1cbf50[_0x161a('0x36')]=_[_0x161a('0x37')](_0x1cbf50[_0x161a('0x33')],_0x1cbf50[_0x161a('0x34')]);_0x32284a[_0x161a('0x38')]=_[_0x161a('0x37')](_0x1cbf50[_0x161a('0x33')],qs[_0x161a('0x39')](_0x17e0f3['query']['fields']));_0x32284a['attributes']=_0x32284a['attributes']['length']?_0x32284a[_0x161a('0x38')]:_0x1cbf50['model'];if(_0x17e0f3[_0x161a('0x34')][_0x161a('0x44')]){_0x32284a['include']=[{'all':!![]}];}_0x32284a=_[_0x161a('0x41')]({},_0x32284a,_0x17e0f3[_0x161a('0x43')]);return db['AnalyticExtractedReport'][_0x161a('0x4a')](_0x32284a)[_0x161a('0x25')](handleEntityNotFound(_0x429533,null))[_0x161a('0x25')](respondWithResult(_0x429533,null))['catch'](handleError(_0x429533,null));};exports[_0x161a('0x4b')]=function(_0x210da1,_0x588b4d){return db[_0x161a('0x2e')]['create'](_0x210da1[_0x161a('0x4c')],{})['then'](function(_0x5c5c82){var _0x5912c2=_0x210da1[_0x161a('0x4d')][_0x161a('0x4e')]({'plain':!![]});if(!_0x5912c2)throw new Error(_0x161a('0x4f'));if(_0x5912c2[_0x161a('0x50')]===_0x161a('0x4d')){var _0x659b99=_0x5c5c82[_0x161a('0x4e')]({'plain':!![]});var _0x42e147=_0x161a('0x26');return db[_0x161a('0x51')][_0x161a('0x4a')]({'where':{'name':_0x42e147,'userProfileId':_0x5912c2[_0x161a('0x52')]},'raw':!![]})['then'](function(_0x228c75){if(_0x228c75&&_0x228c75['autoAssociation']===0x0){return db[_0x161a('0x27')][_0x161a('0x4b')]({'name':_0x659b99[_0x161a('0x2b')],'resourceId':_0x659b99['id'],'type':_0x228c75[_0x161a('0x2b')],'sectionId':_0x228c75['id']},{})[_0x161a('0x25')](function(){return _0x5c5c82;});}else{return _0x5c5c82;}})[_0x161a('0x48')](function(_0x4ab08e){logger[_0x161a('0x29')](_0x161a('0x53'),_0x4ab08e);throw _0x4ab08e;});}return _0x5c5c82;})[_0x161a('0x25')](respondWithResult(_0x588b4d,0xc9))['catch'](handleError(_0x588b4d,null));};exports[_0x161a('0x23')]=function(_0x3999f0,_0x2c8ede){if(_0x3999f0[_0x161a('0x4c')]['id']){delete _0x3999f0[_0x161a('0x4c')]['id'];}return db[_0x161a('0x2e')][_0x161a('0x4a')]({'where':{'id':_0x3999f0[_0x161a('0x49')]['id']}})[_0x161a('0x25')](handleEntityNotFound(_0x2c8ede,null))['then'](saveUpdates(_0x3999f0[_0x161a('0x4c')],null))[_0x161a('0x25')](respondWithResult(_0x2c8ede,null))[_0x161a('0x48')](handleError(_0x2c8ede,null));};exports[_0x161a('0x24')]=function(_0xe8431c,_0x1c8948){return db['AnalyticExtractedReport'][_0x161a('0x4a')]({'where':{'id':_0xe8431c['params']['id']}})['then'](handleEntityNotFound(_0x1c8948,null))[_0x161a('0x25')](removeEntity(_0x1c8948,null))[_0x161a('0x48')](handleError(_0x1c8948,null));};exports[_0x161a('0x54')]=function(_0x29f853,_0x2d721f,_0x57152b){return db[_0x161a('0x2e')][_0x161a('0x4a')]({'where':{'id':_0x29f853[_0x161a('0x49')]['id']},'attributes':['name','basename',_0x161a('0x55'),_0x161a('0x56')],'raw':!![]})[_0x161a('0x25')](handleEntityNotFound(_0x2d721f,null))[_0x161a('0x25')](function(_0x4c4409){if(_0x4c4409){if(!fs[_0x161a('0x57')](path[_0x161a('0x58')](config['root'],_0x161a('0x59'),_0x4c4409['savename']))){throw new db[(_0x161a('0x5a'))][(_0x161a('0x5b'))](_0x161a('0x5c'));}if(_0x29f853['query'][_0x161a('0x5d')]){return _0x2d721f['sendStatus'](0xc8);}return _0x2d721f[_0x161a('0x54')](path[_0x161a('0x58')](config['root'],'server/files/reports',_0x4c4409[_0x161a('0x55')]),util[_0x161a('0x5e')](_0x161a('0x5f'),_0x4c4409['basename']||_0x4c4409[_0x161a('0x2b')],_0x4c4409[_0x161a('0x56')][_0x161a('0x60')]()));}})[_0x161a('0x48')](handleError(_0x2d721f,null));};