Built motion from commit efa66e19.|2.6.22
[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 _0xe3db=['save','then','destroy','get','end','error','stack','name','send','map','AnalyticExtractedReport','fieldName','type','key','model','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','includeAll','include','findAll','catch','params','keys','rawAttributes','options','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','download','basename','savename','existsSync','join','root','ValidationError','Report\x20not\x20found\x20or\x20empty','exists','server/files/reports','format','%s.%s','output','toLowerCase','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','to-csv','ejs','fs-extra','lodash','crypto','querystring','../../config/license/hardware','api','../../config/environment','../../config/license/util','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject'];(function(_0x5c3ea4,_0x3939a9){var _0x217b91=function(_0x18d389){while(--_0x18d389){_0x5c3ea4['push'](_0x5c3ea4['shift']());}};_0x217b91(++_0x3939a9);}(_0xe3db,0x95));var _0xbe3d=function(_0x10a8da,_0xde4c4a){_0x10a8da=_0x10a8da-0x0;var _0x47b276=_0xe3db[_0x10a8da];return _0x47b276;};'use strict';var emlformat=require(_0xbe3d('0x0'));var rimraf=require(_0xbe3d('0x1'));var zipdir=require(_0xbe3d('0x2'));var jsonpatch=require(_0xbe3d('0x3'));var rp=require(_0xbe3d('0x4'));var moment=require('moment');var BPromise=require(_0xbe3d('0x5'));var Mustache=require(_0xbe3d('0x6'));var util=require(_0xbe3d('0x7'));var path=require('path');var sox=require('sox');var csv=require(_0xbe3d('0x8'));var ejs=require(_0xbe3d('0x9'));var fs=require('fs');var fs_extra=require(_0xbe3d('0xa'));var _=require(_0xbe3d('0xb'));var squel=require('squel');var crypto=require(_0xbe3d('0xc'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xbe3d('0x8'));var querystring=require(_0xbe3d('0xd'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xbe3d('0xe'));var logger=require('../../config/logger')(_0xbe3d('0xf'));var utils=require('../../config/utils');var config=require(_0xbe3d('0x10'));var licenseUtil=require(_0xbe3d('0x11'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4f719a,_0x2d606d){_0x2d606d=_0x2d606d||0xcc;return function(_0x472ec8){if(_0x472ec8){return _0x4f719a[_0xbe3d('0x12')](_0x2d606d);}return _0x4f719a[_0xbe3d('0x13')](_0x2d606d)['end']();};}function respondWithResult(_0x4ef231,_0x102d5d){_0x102d5d=_0x102d5d||0xc8;return function(_0x19537e){if(_0x19537e){return _0x4ef231[_0xbe3d('0x13')](_0x102d5d)[_0xbe3d('0x14')](_0x19537e);}};}function respondWithFilteredResult(_0x2d358f,_0x16cc0a){return function(_0x27f957){if(_0x27f957){var _0x60539b=typeof _0x16cc0a[_0xbe3d('0x15')]===_0xbe3d('0x16')&&typeof _0x16cc0a[_0xbe3d('0x17')]===_0xbe3d('0x16');var _0x491b48=_0x27f957[_0xbe3d('0x18')];var _0x2ec66d=_0x60539b?0x0:_0x16cc0a[_0xbe3d('0x15')];var _0x4d55d4=_0x60539b?_0x27f957[_0xbe3d('0x18')]:_0x16cc0a[_0xbe3d('0x15')]+_0x16cc0a[_0xbe3d('0x17')];var _0x2c3f7c;if(_0x4d55d4>=_0x491b48){_0x4d55d4=_0x491b48;_0x2c3f7c=0xc8;}else{_0x2c3f7c=0xce;}_0x2d358f[_0xbe3d('0x13')](_0x2c3f7c);return _0x2d358f[_0xbe3d('0x19')](_0xbe3d('0x1a'),_0x2ec66d+'-'+_0x4d55d4+'/'+_0x491b48)[_0xbe3d('0x14')](_0x27f957);}return null;};}function patchUpdates(_0x42c104){return function(_0x150946){try{jsonpatch[_0xbe3d('0x1b')](_0x150946,_0x42c104,!![]);}catch(_0x5b2b70){return BPromise[_0xbe3d('0x1c')](_0x5b2b70);}return _0x150946[_0xbe3d('0x1d')]();};}function saveUpdates(_0x23ae9f,_0x24d03c){return function(_0x1b17e6){if(_0x1b17e6){return _0x1b17e6['update'](_0x23ae9f)[_0xbe3d('0x1e')](function(_0x5346de){return _0x5346de;});}return null;};}function removeEntity(_0x2b7d45,_0x4a4b90){return function(_0x33029a){if(_0x33029a){return _0x33029a[_0xbe3d('0x1f')]()[_0xbe3d('0x1e')](function(){var _0x13d8de=_0x33029a[_0xbe3d('0x20')]({'plain':!![]});var _0x4c0e18='ExtractedReports';return db['UserProfileResource']['destroy']({'where':{'type':_0x4c0e18,'resourceId':_0x13d8de['id']}})[_0xbe3d('0x1e')](function(){return _0x33029a;});})['then'](function(){_0x2b7d45['status'](0xcc)[_0xbe3d('0x21')]();});}};}function handleEntityNotFound(_0x453cc3,_0x29b24c){return function(_0x34dcf8){if(!_0x34dcf8){_0x453cc3[_0xbe3d('0x12')](0x194);}return _0x34dcf8;};}function handleError(_0x3a2cb1,_0x5ce2cf){_0x5ce2cf=_0x5ce2cf||0x1f4;return function(_0x2b42e3){logger[_0xbe3d('0x22')](_0x2b42e3[_0xbe3d('0x23')]);if(_0x2b42e3[_0xbe3d('0x24')]){delete _0x2b42e3['name'];}_0x3a2cb1[_0xbe3d('0x13')](_0x5ce2cf)[_0xbe3d('0x25')](_0x2b42e3);};}exports['index']=function(_0x49f683,_0x1bb278){var _0x2f49df={},_0x597fd5={},_0xa0af23={'count':0x0,'rows':[]};var _0x368943=_[_0xbe3d('0x26')](db[_0xbe3d('0x27')]['rawAttributes'],function(_0x4ba811){return{'name':_0x4ba811[_0xbe3d('0x28')],'type':_0x4ba811[_0xbe3d('0x29')][_0xbe3d('0x2a')]};});_0x597fd5[_0xbe3d('0x2b')]=_[_0xbe3d('0x26')](_0x368943,_0xbe3d('0x24'));_0x597fd5[_0xbe3d('0x2c')]=_['keys'](_0x49f683[_0xbe3d('0x2c')]);_0x597fd5[_0xbe3d('0x2d')]=_[_0xbe3d('0x2e')](_0x597fd5[_0xbe3d('0x2b')],_0x597fd5[_0xbe3d('0x2c')]);_0x2f49df['attributes']=_['intersection'](_0x597fd5['model'],qs[_0xbe3d('0x2f')](_0x49f683[_0xbe3d('0x2c')][_0xbe3d('0x2f')]));_0x2f49df[_0xbe3d('0x30')]=_0x2f49df['attributes'][_0xbe3d('0x31')]?_0x2f49df[_0xbe3d('0x30')]:_0x597fd5[_0xbe3d('0x2b')];if(!_0x49f683['query'][_0xbe3d('0x32')](_0xbe3d('0x33'))){_0x2f49df[_0xbe3d('0x17')]=qs['limit'](_0x49f683[_0xbe3d('0x2c')][_0xbe3d('0x17')]);_0x2f49df[_0xbe3d('0x15')]=qs[_0xbe3d('0x15')](_0x49f683['query']['offset']);}_0x2f49df['order']=qs[_0xbe3d('0x34')](_0x49f683['query'][_0xbe3d('0x34')]);_0x2f49df[_0xbe3d('0x35')]=qs[_0xbe3d('0x2d')](_[_0xbe3d('0x36')](_0x49f683[_0xbe3d('0x2c')],_0x597fd5[_0xbe3d('0x2d')]),_0x368943);if(_0x49f683[_0xbe3d('0x2c')][_0xbe3d('0x37')]){_0x2f49df[_0xbe3d('0x35')]=_['merge'](_0x2f49df[_0xbe3d('0x35')],{'$or':_['map'](_0x368943,function(_0x285576){if(_0x285576['type']!=='VIRTUAL'){var _0x4af20f={};_0x4af20f[_0x285576['name']]={'$like':'%'+_0x49f683['query']['filter']+'%'};return _0x4af20f;}})});}_0x2f49df=_[_0xbe3d('0x38')]({},_0x2f49df,_0x49f683['options']);var _0x479dbd={'where':_0x2f49df[_0xbe3d('0x35')]};return db[_0xbe3d('0x27')][_0xbe3d('0x18')](_0x479dbd)[_0xbe3d('0x1e')](function(_0x4a21d8){_0xa0af23[_0xbe3d('0x18')]=_0x4a21d8;if(_0x49f683[_0xbe3d('0x2c')][_0xbe3d('0x39')]){_0x2f49df[_0xbe3d('0x3a')]=[{'all':!![]}];}return db[_0xbe3d('0x27')][_0xbe3d('0x3b')](_0x2f49df);})[_0xbe3d('0x1e')](function(_0xdd7fea){_0xa0af23['rows']=_0xdd7fea;return _0xa0af23;})['then'](respondWithFilteredResult(_0x1bb278,_0x2f49df))[_0xbe3d('0x3c')](handleError(_0x1bb278,null));};exports['show']=function(_0x4a080e,_0x16628c){var _0x24f7d2={'raw':!![],'where':{'id':_0x4a080e[_0xbe3d('0x3d')]['id']}},_0x482faa={};_0x482faa['model']=_[_0xbe3d('0x3e')](db[_0xbe3d('0x27')][_0xbe3d('0x3f')]);_0x482faa[_0xbe3d('0x2c')]=_['keys'](_0x4a080e[_0xbe3d('0x2c')]);_0x482faa[_0xbe3d('0x2d')]=_[_0xbe3d('0x2e')](_0x482faa[_0xbe3d('0x2b')],_0x482faa['query']);_0x24f7d2[_0xbe3d('0x30')]=_['intersection'](_0x482faa[_0xbe3d('0x2b')],qs[_0xbe3d('0x2f')](_0x4a080e['query'][_0xbe3d('0x2f')]));_0x24f7d2['attributes']=_0x24f7d2['attributes'][_0xbe3d('0x31')]?_0x24f7d2[_0xbe3d('0x30')]:_0x482faa[_0xbe3d('0x2b')];if(_0x4a080e[_0xbe3d('0x2c')]['includeAll']){_0x24f7d2['include']=[{'all':!![]}];}_0x24f7d2=_['merge']({},_0x24f7d2,_0x4a080e[_0xbe3d('0x40')]);return db[_0xbe3d('0x27')][_0xbe3d('0x41')](_0x24f7d2)[_0xbe3d('0x1e')](handleEntityNotFound(_0x16628c,null))['then'](respondWithResult(_0x16628c,null))['catch'](handleError(_0x16628c,null));};exports[_0xbe3d('0x42')]=function(_0x1c71fd,_0x2d11ef){return db[_0xbe3d('0x27')][_0xbe3d('0x42')](_0x1c71fd[_0xbe3d('0x43')],{})[_0xbe3d('0x1e')](function(_0x144b42){var _0x4003af=_0x1c71fd[_0xbe3d('0x44')][_0xbe3d('0x20')]({'plain':!![]});if(!_0x4003af)throw new Error(_0xbe3d('0x45'));if(_0x4003af[_0xbe3d('0x46')]===_0xbe3d('0x44')){var _0x33a86f=_0x144b42[_0xbe3d('0x20')]({'plain':!![]});var _0x287797='ExtractedReports';return db[_0xbe3d('0x47')]['find']({'where':{'name':_0x287797,'userProfileId':_0x4003af[_0xbe3d('0x48')]},'raw':!![]})[_0xbe3d('0x1e')](function(_0x3be912){if(_0x3be912&&_0x3be912['autoAssociation']===0x0){return db['UserProfileResource'][_0xbe3d('0x42')]({'name':_0x33a86f['name'],'resourceId':_0x33a86f['id'],'type':_0x3be912[_0xbe3d('0x24')],'sectionId':_0x3be912['id']},{})[_0xbe3d('0x1e')](function(){return _0x144b42;});}else{return _0x144b42;}})['catch'](function(_0x55ec4a){logger[_0xbe3d('0x22')](_0xbe3d('0x49'),_0x55ec4a);throw _0x55ec4a;});}return _0x144b42;})[_0xbe3d('0x1e')](respondWithResult(_0x2d11ef,0xc9))[_0xbe3d('0x3c')](handleError(_0x2d11ef,null));};exports[_0xbe3d('0x4a')]=function(_0x555316,_0x464248){if(_0x555316[_0xbe3d('0x43')]['id']){delete _0x555316[_0xbe3d('0x43')]['id'];}return db[_0xbe3d('0x27')][_0xbe3d('0x41')]({'where':{'id':_0x555316[_0xbe3d('0x3d')]['id']}})[_0xbe3d('0x1e')](handleEntityNotFound(_0x464248,null))[_0xbe3d('0x1e')](saveUpdates(_0x555316[_0xbe3d('0x43')],null))[_0xbe3d('0x1e')](respondWithResult(_0x464248,null))[_0xbe3d('0x3c')](handleError(_0x464248,null));};exports['destroy']=function(_0x50ca4e,_0x465488){return db['AnalyticExtractedReport'][_0xbe3d('0x41')]({'where':{'id':_0x50ca4e[_0xbe3d('0x3d')]['id']}})[_0xbe3d('0x1e')](handleEntityNotFound(_0x465488,null))[_0xbe3d('0x1e')](removeEntity(_0x465488,null))['catch'](handleError(_0x465488,null));};exports[_0xbe3d('0x4b')]=function(_0x4110d3,_0x563486,_0x678fce){return db[_0xbe3d('0x27')]['find']({'where':{'id':_0x4110d3[_0xbe3d('0x3d')]['id']},'attributes':[_0xbe3d('0x24'),_0xbe3d('0x4c'),_0xbe3d('0x4d'),'output'],'raw':!![]})[_0xbe3d('0x1e')](handleEntityNotFound(_0x563486,null))[_0xbe3d('0x1e')](function(_0x4dfa95){if(_0x4dfa95){if(!fs[_0xbe3d('0x4e')](path[_0xbe3d('0x4f')](config[_0xbe3d('0x50')],'server/files/reports',_0x4dfa95['savename']))){throw new db['Sequelize'][(_0xbe3d('0x51'))](_0xbe3d('0x52'));}if(_0x4110d3[_0xbe3d('0x2c')][_0xbe3d('0x53')]){return _0x563486['sendStatus'](0xc8);}return _0x563486[_0xbe3d('0x4b')](path[_0xbe3d('0x4f')](config[_0xbe3d('0x50')],_0xbe3d('0x54'),_0x4dfa95['savename']),util[_0xbe3d('0x55')](_0xbe3d('0x56'),_0x4dfa95[_0xbe3d('0x4c')]||_0x4dfa95[_0xbe3d('0x24')],_0x4dfa95[_0xbe3d('0x57')][_0xbe3d('0x58')]()));}})['catch'](handleError(_0x563486,null));};