server/api/analyticFieldReport/analyticFieldReport.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 _0xbd70=['path','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','undefined','limit','count','offset','set','Content-Range','reject','save','update','then','destroy','error','stack','name','index','map','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','where','filters','merge','VIRTUAL','options','AnalyticFieldReport','includeAll','include','find','catch','create','bulkCreate','body','params','sequelize','transaction','findAll','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','util'];(function(_0x469329,_0x302c37){var _0x305fe6=function(_0x420784){while(--_0x420784){_0x469329['push'](_0x469329['shift']());}};_0x305fe6(++_0x302c37);}(_0xbd70,0x93));var _0x0bd7=function(_0x4fc9e6,_0xc51915){_0x4fc9e6=_0x4fc9e6-0x0;var _0x551d28=_0xbd70[_0x4fc9e6];return _0x551d28;};'use strict';var emlformat=require(_0x0bd7('0x0'));var rimraf=require(_0x0bd7('0x1'));var zipdir=require(_0x0bd7('0x2'));var jsonpatch=require(_0x0bd7('0x3'));var rp=require('request-promise');var moment=require(_0x0bd7('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x0bd7('0x5'));var util=require(_0x0bd7('0x6'));var path=require(_0x0bd7('0x7'));var sox=require('sox');var csv=require(_0x0bd7('0x8'));var ejs=require(_0x0bd7('0x9'));var fs=require('fs');var fs_extra=require(_0x0bd7('0xa'));var _=require(_0x0bd7('0xb'));var squel=require(_0x0bd7('0xc'));var crypto=require(_0x0bd7('0xd'));var jsforce=require(_0x0bd7('0xe'));var deskjs=require(_0x0bd7('0xf'));var toCsv=require(_0x0bd7('0x8'));var querystring=require(_0x0bd7('0x10'));var Papa=require(_0x0bd7('0x11'));var Redis=require('ioredis');var authService=require(_0x0bd7('0x12'));var qs=require(_0x0bd7('0x13'));var as=require(_0x0bd7('0x14'));var hardwareService=require(_0x0bd7('0x15'));var logger=require(_0x0bd7('0x16'))('api');var utils=require(_0x0bd7('0x17'));var config=require(_0x0bd7('0x18'));var licenseUtil=require(_0x0bd7('0x19'));var db=require(_0x0bd7('0x1a'))['db'];function respondWithStatusCode(_0x183683,_0x3515c7){_0x3515c7=_0x3515c7||0xcc;return function(_0x1a5af4){if(_0x1a5af4){return _0x183683[_0x0bd7('0x1b')](_0x3515c7);}return _0x183683[_0x0bd7('0x1c')](_0x3515c7)[_0x0bd7('0x1d')]();};}function respondWithResult(_0x5ef084,_0x279c86){_0x279c86=_0x279c86||0xc8;return function(_0x477c9e){if(_0x477c9e){return _0x5ef084[_0x0bd7('0x1c')](_0x279c86)['json'](_0x477c9e);}};}function respondWithFilteredResult(_0x1d8dbd,_0x2bc532){return function(_0x313217){if(_0x313217){var _0x1ca11a=typeof _0x2bc532['offset']===_0x0bd7('0x1e')&&typeof _0x2bc532[_0x0bd7('0x1f')]===_0x0bd7('0x1e');var _0x22e014=_0x313217[_0x0bd7('0x20')];var _0x1040bd=_0x1ca11a?0x0:_0x2bc532[_0x0bd7('0x21')];var _0x266f2d=_0x1ca11a?_0x313217[_0x0bd7('0x20')]:_0x2bc532['offset']+_0x2bc532[_0x0bd7('0x1f')];var _0x3678c2;if(_0x266f2d>=_0x22e014){_0x266f2d=_0x22e014;_0x3678c2=0xc8;}else{_0x3678c2=0xce;}_0x1d8dbd['status'](_0x3678c2);return _0x1d8dbd[_0x0bd7('0x22')](_0x0bd7('0x23'),_0x1040bd+'-'+_0x266f2d+'/'+_0x22e014)['json'](_0x313217);}return null;};}function patchUpdates(_0x3afca8){return function(_0xe59cbc){try{jsonpatch['apply'](_0xe59cbc,_0x3afca8,!![]);}catch(_0x2fae5b){return BPromise[_0x0bd7('0x24')](_0x2fae5b);}return _0xe59cbc[_0x0bd7('0x25')]();};}function saveUpdates(_0x156351,_0x38e0ce){return function(_0x7b991c){if(_0x7b991c){return _0x7b991c[_0x0bd7('0x26')](_0x156351)[_0x0bd7('0x27')](function(_0x55a572){return _0x55a572;});}return null;};}function removeEntity(_0x1aef92,_0x170460){return function(_0x12bcd9){if(_0x12bcd9){return _0x12bcd9[_0x0bd7('0x28')]()[_0x0bd7('0x27')](function(){_0x1aef92[_0x0bd7('0x1c')](0xcc)[_0x0bd7('0x1d')]();});}};}function handleEntityNotFound(_0x5834c5,_0x3757b0){return function(_0x276e7f){if(!_0x276e7f){_0x5834c5[_0x0bd7('0x1b')](0x194);}return _0x276e7f;};}function handleError(_0x5d76ca,_0xcc8dce){_0xcc8dce=_0xcc8dce||0x1f4;return function(_0x25fa72){logger[_0x0bd7('0x29')](_0x25fa72[_0x0bd7('0x2a')]);if(_0x25fa72[_0x0bd7('0x2b')]){delete _0x25fa72[_0x0bd7('0x2b')];}_0x5d76ca[_0x0bd7('0x1c')](_0xcc8dce)['send'](_0x25fa72);};}exports[_0x0bd7('0x2c')]=function(_0x65d8e2,_0x1eee18){var _0x2f18bc={},_0x3f01ad={},_0x529f76={'count':0x0,'rows':[]};var _0x401e69=_[_0x0bd7('0x2d')](db['AnalyticFieldReport'][_0x0bd7('0x2e')],function(_0x1160b5){return{'name':_0x1160b5[_0x0bd7('0x2f')],'type':_0x1160b5[_0x0bd7('0x30')][_0x0bd7('0x31')]};});_0x3f01ad[_0x0bd7('0x32')]=_['map'](_0x401e69,_0x0bd7('0x2b'));_0x3f01ad[_0x0bd7('0x33')]=_[_0x0bd7('0x34')](_0x65d8e2[_0x0bd7('0x33')]);_0x3f01ad['filters']=_[_0x0bd7('0x35')](_0x3f01ad['model'],_0x3f01ad[_0x0bd7('0x33')]);_0x2f18bc[_0x0bd7('0x36')]=_['intersection'](_0x3f01ad[_0x0bd7('0x32')],qs[_0x0bd7('0x37')](_0x65d8e2['query']['fields']));_0x2f18bc[_0x0bd7('0x36')]=_0x2f18bc[_0x0bd7('0x36')][_0x0bd7('0x38')]?_0x2f18bc[_0x0bd7('0x36')]:_0x3f01ad[_0x0bd7('0x32')];if(!_0x65d8e2[_0x0bd7('0x33')][_0x0bd7('0x39')](_0x0bd7('0x3a'))){_0x2f18bc[_0x0bd7('0x1f')]=qs[_0x0bd7('0x1f')](_0x65d8e2[_0x0bd7('0x33')][_0x0bd7('0x1f')]);_0x2f18bc[_0x0bd7('0x21')]=qs[_0x0bd7('0x21')](_0x65d8e2[_0x0bd7('0x33')][_0x0bd7('0x21')]);}_0x2f18bc[_0x0bd7('0x3b')]=qs['sort'](_0x65d8e2[_0x0bd7('0x33')]['sort']);_0x2f18bc[_0x0bd7('0x3c')]=qs[_0x0bd7('0x3d')](_['pick'](_0x65d8e2[_0x0bd7('0x33')],_0x3f01ad[_0x0bd7('0x3d')]),_0x401e69);if(_0x65d8e2[_0x0bd7('0x33')]['filter']){_0x2f18bc[_0x0bd7('0x3c')]=_[_0x0bd7('0x3e')](_0x2f18bc[_0x0bd7('0x3c')],{'$or':_['map'](_0x401e69,function(_0x3b84dc){if(_0x3b84dc[_0x0bd7('0x30')]!==_0x0bd7('0x3f')){var _0x5aa0dc={};_0x5aa0dc[_0x3b84dc[_0x0bd7('0x2b')]]={'$like':'%'+_0x65d8e2[_0x0bd7('0x33')]['filter']+'%'};return _0x5aa0dc;}})});}_0x2f18bc=_[_0x0bd7('0x3e')]({},_0x2f18bc,_0x65d8e2[_0x0bd7('0x40')]);var _0x5ec77f={'where':_0x2f18bc[_0x0bd7('0x3c')]};return db[_0x0bd7('0x41')][_0x0bd7('0x20')](_0x5ec77f)['then'](function(_0x52c610){_0x529f76[_0x0bd7('0x20')]=_0x52c610;if(_0x65d8e2['query'][_0x0bd7('0x42')]){_0x2f18bc['include']=[{'all':!![]}];}return db[_0x0bd7('0x41')]['findAll'](_0x2f18bc);})['then'](function(_0x562e7f){_0x529f76['rows']=_0x562e7f;return _0x529f76;})['then'](respondWithFilteredResult(_0x1eee18,_0x2f18bc))['catch'](handleError(_0x1eee18,null));};exports['show']=function(_0x58939d,_0x31354b){var _0x1bfac4={'raw':![],'where':{'id':_0x58939d['params']['id']}},_0x4907e7={};_0x4907e7['model']=_[_0x0bd7('0x34')](db[_0x0bd7('0x41')][_0x0bd7('0x2e')]);_0x4907e7['query']=_['keys'](_0x58939d[_0x0bd7('0x33')]);_0x4907e7[_0x0bd7('0x3d')]=_[_0x0bd7('0x35')](_0x4907e7['model'],_0x4907e7[_0x0bd7('0x33')]);_0x1bfac4[_0x0bd7('0x36')]=_[_0x0bd7('0x35')](_0x4907e7[_0x0bd7('0x32')],qs['fields'](_0x58939d[_0x0bd7('0x33')][_0x0bd7('0x37')]));_0x1bfac4[_0x0bd7('0x36')]=_0x1bfac4['attributes']['length']?_0x1bfac4['attributes']:_0x4907e7['model'];if(_0x58939d[_0x0bd7('0x33')]['includeAll']){_0x1bfac4[_0x0bd7('0x43')]=[{'all':!![]}];}_0x1bfac4=_[_0x0bd7('0x3e')]({},_0x1bfac4,_0x58939d['options']);return db[_0x0bd7('0x41')][_0x0bd7('0x44')](_0x1bfac4)[_0x0bd7('0x27')](handleEntityNotFound(_0x31354b,null))[_0x0bd7('0x27')](respondWithResult(_0x31354b,null))[_0x0bd7('0x45')](handleError(_0x31354b,null));};exports['create']=function(_0x330249,_0x295a06){return db[_0x0bd7('0x41')][_0x0bd7('0x46')](_0x330249['body'],{})[_0x0bd7('0x27')](respondWithResult(_0x295a06,0xc9))[_0x0bd7('0x45')](handleError(_0x295a06,null));};exports['bulkCreate']=function(_0x401ccb,_0x400d1c){return db[_0x0bd7('0x41')][_0x0bd7('0x47')](_0x401ccb['body'],{'raw':![],'individualHooks':!![]})[_0x0bd7('0x27')](respondWithResult(_0x400d1c,0xc9))[_0x0bd7('0x45')](handleError(_0x400d1c,null));};exports[_0x0bd7('0x26')]=function(_0x1cdf99,_0x11526e){if(_0x1cdf99[_0x0bd7('0x48')]['id']){delete _0x1cdf99['body']['id'];}return db[_0x0bd7('0x41')]['find']({'where':{'id':_0x1cdf99[_0x0bd7('0x49')]['id']}})[_0x0bd7('0x27')](handleEntityNotFound(_0x11526e,null))[_0x0bd7('0x27')](saveUpdates(_0x1cdf99[_0x0bd7('0x48')],null))[_0x0bd7('0x27')](respondWithResult(_0x11526e,null))[_0x0bd7('0x45')](handleError(_0x11526e,null));};exports[_0x0bd7('0x28')]=function(_0x147f22,_0x16459f){return db['AnalyticFieldReport'][_0x0bd7('0x44')]({'where':{'id':_0x147f22[_0x0bd7('0x49')]['id']}})[_0x0bd7('0x27')](handleEntityNotFound(_0x16459f,null))[_0x0bd7('0x27')](removeEntity(_0x16459f,null))[_0x0bd7('0x45')](handleError(_0x16459f,null));};exports['bulkDestroy']=function(_0x4655ef,_0x179e34){return db['AnalyticFieldReport'][_0x0bd7('0x28')]({'where':{'id':_0x4655ef['query']['ids']||[]},'raw':![],'individualHooks':!![]})[_0x0bd7('0x27')](respondWithResult(_0x179e34,0xcc))[_0x0bd7('0x45')](handleError(_0x179e34,null));};exports['addFields']=function(_0x5a0374,_0x16f61f,_0x3e79e7){return db['AnalyticCustomReport']['findOne']({'where':{'id':_0x5a0374[_0x0bd7('0x49')]['id']}})[_0x0bd7('0x27')](handleEntityNotFound(_0x16f61f,null))[_0x0bd7('0x27')](function(_0x15a2a8){if(_0x15a2a8){return db[_0x0bd7('0x4a')][_0x0bd7('0x4b')](function(_0x23ae8b){return db[_0x0bd7('0x41')][_0x0bd7('0x28')]({'where':{'CustomReportId':_0x5a0374[_0x0bd7('0x49')]['id']},'transaction':_0x23ae8b})['then'](function(_0x1170aa){var _0x34a91e=_[_0x0bd7('0x2d')](_0x5a0374['body'],function(_0x791401){delete _0x791401['id'];_0x791401['CustomReportId']=_0x5a0374['params']['id'];return _0x791401;});return db[_0x0bd7('0x41')][_0x0bd7('0x47')](_0x34a91e,{'transaction':_0x23ae8b});});})[_0x0bd7('0x27')](function(){return db[_0x0bd7('0x41')][_0x0bd7('0x4c')]({'where':{'CustomReportId':_0x5a0374[_0x0bd7('0x49')]['id']}});});}})[_0x0bd7('0x27')](respondWithResult(_0x16f61f,null))[_0x0bd7('0x45')](handleError(_0x16f61f,null));};