a18d2286739d767a686659d10b7d047d2274fc29
[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 _0xd87a=['save','update','destroy','get','UserProfileResource','then','end','error','stack','name','send','index','map','AnalyticExtractedReport','type','key','query','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','merge','VIRTUAL','filter','options','include','rows','show','params','keys','rawAttributes','catch','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','UserProfileSection','userProfileId','find','download','savename','existsSync','join','ValidationError','Report\x20not\x20found\x20or\x20empty','exists','root','server/files/reports','format','%s.%s','basename','output','toLowerCase','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','sox','to-csv','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','count','offset','limit','apply','reject'];(function(_0x4496d4,_0x35a23c){var _0x549149=function(_0x466c13){while(--_0x466c13){_0x4496d4['push'](_0x4496d4['shift']());}};_0x549149(++_0x35a23c);}(_0xd87a,0xf3));var _0xad87=function(_0x34bc6c,_0x10d089){_0x34bc6c=_0x34bc6c-0x0;var _0x168820=_0xd87a[_0x34bc6c];return _0x168820;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xad87('0x0'));var rimraf=require(_0xad87('0x1'));var zipdir=require(_0xad87('0x2'));var jsonpatch=require(_0xad87('0x3'));var rp=require('request-promise');var moment=require(_0xad87('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xad87('0x5'));var util=require('util');var path=require('path');var sox=require(_0xad87('0x6'));var csv=require(_0xad87('0x7'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0xad87('0x8'));var jsforce=require(_0xad87('0x9'));var deskjs=require(_0xad87('0xa'));var toCsv=require('to-csv');var querystring=require(_0xad87('0xb'));var Papa=require(_0xad87('0xc'));var Redis=require(_0xad87('0xd'));var authService=require(_0xad87('0xe'));var qs=require(_0xad87('0xf'));var as=require(_0xad87('0x10'));var hardwareService=require(_0xad87('0x11'));var logger=require('../../config/logger')(_0xad87('0x12'));var utils=require(_0xad87('0x13'));var config=require(_0xad87('0x14'));var db=require(_0xad87('0x15'))['db'];function respondWithStatusCode(_0x3146f2,_0x5ed55a){_0x5ed55a=_0x5ed55a||0xcc;return function(_0x1888cd){if(_0x1888cd){return _0x3146f2[_0xad87('0x16')](_0x5ed55a);}return _0x3146f2[_0xad87('0x17')](_0x5ed55a)['end']();};}function respondWithResult(_0xc37381,_0x3fe6be){_0x3fe6be=_0x3fe6be||0xc8;return function(_0xf27024){if(_0xf27024){return _0xc37381[_0xad87('0x17')](_0x3fe6be)[_0xad87('0x18')](_0xf27024);}};}function respondWithFilteredResult(_0x2fa680,_0x4a4678){return function(_0x9aafd4){if(_0x9aafd4){var _0x48618e=_0x9aafd4[_0xad87('0x19')],_0x2f7f46=_0x4a4678[_0xad87('0x1a')],_0x5df325=_0x4a4678[_0xad87('0x1a')]+_0x4a4678[_0xad87('0x1b')],_0x3ea25b;if(_0x5df325>=_0x48618e){_0x5df325=_0x48618e;_0x3ea25b=0xc8;}else{_0x3ea25b=0xce;}_0x2fa680['status'](_0x3ea25b);return _0x2fa680['set']('Content-Range',_0x2f7f46+'-'+_0x5df325+'/'+_0x48618e)[_0xad87('0x18')](_0x9aafd4);}return null;};}function patchUpdates(_0x3aa8c1){return function(_0x89d592){try{jsonpatch[_0xad87('0x1c')](_0x89d592,_0x3aa8c1,!![]);}catch(_0x21c56f){return BPromise[_0xad87('0x1d')](_0x21c56f);}return _0x89d592[_0xad87('0x1e')]();};}function saveUpdates(_0x5f0d07,_0x1e1d02){return function(_0x2ea7e0){if(_0x2ea7e0){return _0x2ea7e0[_0xad87('0x1f')](_0x5f0d07)['then'](function(_0x3f125d){return _0x3f125d;});}return null;};}function removeEntity(_0x3f704f,_0x578d3e){return function(_0x15bad3){if(_0x15bad3){return _0x15bad3[_0xad87('0x20')]()['then'](function(){var _0x54a130=_0x15bad3[_0xad87('0x21')]({'plain':!![]});var _0x383a86='ExtractedReports';return db[_0xad87('0x22')][_0xad87('0x20')]({'where':{'type':_0x383a86,'resourceId':_0x54a130['id']}})[_0xad87('0x23')](function(){return _0x15bad3;});})['then'](function(){_0x3f704f[_0xad87('0x17')](0xcc)[_0xad87('0x24')]();});}};}function handleEntityNotFound(_0x119f4e,_0x449b96){return function(_0x1c22e6){if(!_0x1c22e6){_0x119f4e[_0xad87('0x16')](0x194);}return _0x1c22e6;};}function handleError(_0x3bb329,_0x12a456){_0x12a456=_0x12a456||0x1f4;return function(_0xa65ef8){logger[_0xad87('0x25')](_0xa65ef8[_0xad87('0x26')]);if(_0xa65ef8[_0xad87('0x27')]){delete _0xa65ef8[_0xad87('0x27')];}_0x3bb329[_0xad87('0x17')](_0x12a456)[_0xad87('0x28')](_0xa65ef8);};}exports[_0xad87('0x29')]=function(_0x30d018,_0xc7552d){var _0xc49fe1={},_0x45f588={},_0x4d8d70={'count':0x0,'rows':[]};var _0x472a6a=_[_0xad87('0x2a')](db[_0xad87('0x2b')]['rawAttributes'],function(_0x44baf1){return{'name':_0x44baf1['fieldName'],'type':_0x44baf1[_0xad87('0x2c')][_0xad87('0x2d')]};});_0x45f588['model']=_[_0xad87('0x2a')](_0x472a6a,_0xad87('0x27'));_0x45f588['query']=_['keys'](_0x30d018[_0xad87('0x2e')]);_0x45f588[_0xad87('0x2f')]=_[_0xad87('0x30')](_0x45f588['model'],_0x45f588['query']);_0xc49fe1[_0xad87('0x31')]=_[_0xad87('0x30')](_0x45f588[_0xad87('0x32')],qs[_0xad87('0x33')](_0x30d018[_0xad87('0x2e')][_0xad87('0x33')]));_0xc49fe1['attributes']=_0xc49fe1[_0xad87('0x31')][_0xad87('0x34')]?_0xc49fe1[_0xad87('0x31')]:_0x45f588[_0xad87('0x32')];if(!_0x30d018[_0xad87('0x2e')][_0xad87('0x35')](_0xad87('0x36'))){_0xc49fe1[_0xad87('0x1b')]=qs[_0xad87('0x1b')](_0x30d018[_0xad87('0x2e')][_0xad87('0x1b')]);_0xc49fe1[_0xad87('0x1a')]=qs[_0xad87('0x1a')](_0x30d018[_0xad87('0x2e')][_0xad87('0x1a')]);}_0xc49fe1[_0xad87('0x37')]=qs[_0xad87('0x38')](_0x30d018[_0xad87('0x2e')][_0xad87('0x38')]);_0xc49fe1[_0xad87('0x39')]=qs['filters'](_[_0xad87('0x3a')](_0x30d018[_0xad87('0x2e')],_0x45f588[_0xad87('0x2f')]));if(_0x30d018['query']['filter']){_0xc49fe1[_0xad87('0x39')]=_[_0xad87('0x3b')](_0xc49fe1['where'],{'$or':_['map'](_0x472a6a,function(_0x320428){if(_0x320428['type']!==_0xad87('0x3c')){var _0x386f3f={};_0x386f3f[_0x320428[_0xad87('0x27')]]={'$like':'%'+_0x30d018[_0xad87('0x2e')][_0xad87('0x3d')]+'%'};return _0x386f3f;}})});}_0xc49fe1=_[_0xad87('0x3b')]({},_0xc49fe1,_0x30d018[_0xad87('0x3e')]);var _0x13ac9e={'where':_0xc49fe1[_0xad87('0x39')]};return db['AnalyticExtractedReport'][_0xad87('0x19')](_0x13ac9e)['then'](function(_0x3afc3a){_0x4d8d70[_0xad87('0x19')]=_0x3afc3a;if(_0x30d018['query']['includeAll']){_0xc49fe1[_0xad87('0x3f')]=[{'all':!![]}];}return db[_0xad87('0x2b')]['findAll'](_0xc49fe1);})[_0xad87('0x23')](function(_0x3bafd7){_0x4d8d70[_0xad87('0x40')]=_0x3bafd7;return _0x4d8d70;})[_0xad87('0x23')](respondWithFilteredResult(_0xc7552d,_0xc49fe1))['catch'](handleError(_0xc7552d,null));};exports[_0xad87('0x41')]=function(_0x354b09,_0x485fee){var _0x203d31={'raw':!![],'where':{'id':_0x354b09[_0xad87('0x42')]['id']}},_0x4bf6e0={};_0x4bf6e0[_0xad87('0x32')]=_[_0xad87('0x43')](db[_0xad87('0x2b')][_0xad87('0x44')]);_0x4bf6e0['query']=_[_0xad87('0x43')](_0x354b09['query']);_0x4bf6e0[_0xad87('0x2f')]=_[_0xad87('0x30')](_0x4bf6e0[_0xad87('0x32')],_0x4bf6e0[_0xad87('0x2e')]);_0x203d31[_0xad87('0x31')]=_[_0xad87('0x30')](_0x4bf6e0[_0xad87('0x32')],qs[_0xad87('0x33')](_0x354b09[_0xad87('0x2e')][_0xad87('0x33')]));_0x203d31[_0xad87('0x31')]=_0x203d31['attributes'][_0xad87('0x34')]?_0x203d31[_0xad87('0x31')]:_0x4bf6e0[_0xad87('0x32')];if(_0x354b09[_0xad87('0x2e')]['includeAll']){_0x203d31[_0xad87('0x3f')]=[{'all':!![]}];}_0x203d31=_[_0xad87('0x3b')]({},_0x203d31,_0x354b09['options']);return db[_0xad87('0x2b')]['find'](_0x203d31)[_0xad87('0x23')](handleEntityNotFound(_0x485fee,null))[_0xad87('0x23')](respondWithResult(_0x485fee,null))[_0xad87('0x45')](handleError(_0x485fee,null));};exports['create']=function(_0x2a788a,_0x5f41ca){return db[_0xad87('0x2b')][_0xad87('0x46')](_0x2a788a[_0xad87('0x47')],{})[_0xad87('0x23')](function(_0x3e8c36){var _0x499fca=_0x2a788a['user'][_0xad87('0x21')]({'plain':!![]});if(!_0x499fca)throw new Error(_0xad87('0x48'));if(_0x499fca['role']===_0xad87('0x49')){var _0xf7ad6d=_0x3e8c36[_0xad87('0x21')]({'plain':!![]});var _0x19c3e3='ExtractedReports';return db[_0xad87('0x4a')]['find']({'where':{'name':_0x19c3e3,'userProfileId':_0x499fca[_0xad87('0x4b')]},'raw':!![]})[_0xad87('0x23')](function(_0x395b25){if(_0x395b25&&_0x395b25['autoAssociation']===0x0){return db['UserProfileResource'][_0xad87('0x46')]({'name':_0xf7ad6d[_0xad87('0x27')],'resourceId':_0xf7ad6d['id'],'type':_0x395b25[_0xad87('0x27')],'sectionId':_0x395b25['id']},{})[_0xad87('0x23')](function(){return _0x3e8c36;});}else{return _0x3e8c36;}})[_0xad87('0x45')](function(_0x477be7){logger[_0xad87('0x25')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x477be7);throw _0x477be7;});}return _0x3e8c36;})[_0xad87('0x23')](respondWithResult(_0x5f41ca,0xc9))[_0xad87('0x45')](handleError(_0x5f41ca,null));};exports[_0xad87('0x1f')]=function(_0x5d3524,_0x297a6d){if(_0x5d3524[_0xad87('0x47')]['id']){delete _0x5d3524[_0xad87('0x47')]['id'];}return db[_0xad87('0x2b')][_0xad87('0x4c')]({'where':{'id':_0x5d3524[_0xad87('0x42')]['id']}})[_0xad87('0x23')](handleEntityNotFound(_0x297a6d,null))[_0xad87('0x23')](saveUpdates(_0x5d3524[_0xad87('0x47')],null))[_0xad87('0x23')](respondWithResult(_0x297a6d,null))['catch'](handleError(_0x297a6d,null));};exports[_0xad87('0x20')]=function(_0x5d2c9b,_0x58d51e){return db[_0xad87('0x2b')][_0xad87('0x4c')]({'where':{'id':_0x5d2c9b['params']['id']}})[_0xad87('0x23')](handleEntityNotFound(_0x58d51e,null))[_0xad87('0x23')](removeEntity(_0x58d51e,null))[_0xad87('0x45')](handleError(_0x58d51e,null));};exports[_0xad87('0x4d')]=function(_0x2048cd,_0x140ddc,_0x1386fe){return db[_0xad87('0x2b')][_0xad87('0x4c')]({'where':{'id':_0x2048cd[_0xad87('0x42')]['id']},'attributes':[_0xad87('0x27'),'basename',_0xad87('0x4e'),'output'],'raw':!![]})[_0xad87('0x23')](handleEntityNotFound(_0x140ddc,null))[_0xad87('0x23')](function(_0x387cc7){if(_0x387cc7){if(!fs[_0xad87('0x4f')](path[_0xad87('0x50')](config['root'],'server/files/reports',_0x387cc7[_0xad87('0x4e')]))){throw new db['Sequelize'][(_0xad87('0x51'))](_0xad87('0x52'));}if(_0x2048cd[_0xad87('0x2e')][_0xad87('0x53')]){return _0x140ddc[_0xad87('0x16')](0xc8);}return _0x140ddc[_0xad87('0x4d')](path['join'](config[_0xad87('0x54')],_0xad87('0x55'),_0x387cc7[_0xad87('0x4e')]),util[_0xad87('0x56')](_0xad87('0x57'),_0x387cc7[_0xad87('0x58')]||_0x387cc7[_0xad87('0x27')],_0x387cc7[_0xad87('0x59')][_0xad87('0x5a')]()));}})[_0xad87('0x45')](handleError(_0x140ddc,null));};