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 _0xd502=['Content-Range','apply','reject','save','update','then','destroy','end','name','map','rawAttributes','type','key','model','query','keys','filters','intersection','attributes','fields','nolimit','sort','where','pick','filter','merge','VIRTUAL','count','includeAll','include','findAll','rows','show','params','catch','body','bulkCreate','AnalyticFieldReport','find','bulkDestroy','addFields','sequelize','transaction','CustomReportId','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','crypto','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','json','offset','undefined','limit','status','set'];(function(_0x1d3616,_0x1b1f7b){var _0x16a39d=function(_0x15d026){while(--_0x15d026){_0x1d3616['push'](_0x1d3616['shift']());}};_0x16a39d(++_0x1b1f7b);}(_0xd502,0x1b2));var _0x2d50=function(_0x3d8776,_0x5305dc){_0x3d8776=_0x3d8776-0x0;var _0x51d331=_0xd502[_0x3d8776];return _0x51d331;};'use strict';var emlformat=require(_0x2d50('0x0'));var rimraf=require(_0x2d50('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x2d50('0x2'));var rp=require(_0x2d50('0x3'));var moment=require(_0x2d50('0x4'));var BPromise=require(_0x2d50('0x5'));var Mustache=require(_0x2d50('0x6'));var util=require(_0x2d50('0x7'));var path=require(_0x2d50('0x8'));var sox=require(_0x2d50('0x9'));var csv=require('to-csv');var ejs=require(_0x2d50('0xa'));var fs=require('fs');var fs_extra=require(_0x2d50('0xb'));var _=require(_0x2d50('0xc'));var squel=require('squel');var crypto=require(_0x2d50('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x2d50('0xe'));var querystring=require(_0x2d50('0xf'));var Papa=require(_0x2d50('0x10'));var Redis=require(_0x2d50('0x11'));var authService=require(_0x2d50('0x12'));var qs=require(_0x2d50('0x13'));var as=require(_0x2d50('0x14'));var hardwareService=require(_0x2d50('0x15'));var logger=require('../../config/logger')(_0x2d50('0x16'));var utils=require(_0x2d50('0x17'));var config=require(_0x2d50('0x18'));var licenseUtil=require(_0x2d50('0x19'));var db=require(_0x2d50('0x1a'))['db'];function respondWithStatusCode(_0x9b909b,_0x540d21){_0x540d21=_0x540d21||0xcc;return function(_0x22dfc8){if(_0x22dfc8){return _0x9b909b[_0x2d50('0x1b')](_0x540d21);}return _0x9b909b['status'](_0x540d21)['end']();};}function respondWithResult(_0x9907f,_0x58b066){_0x58b066=_0x58b066||0xc8;return function(_0x5e020b){if(_0x5e020b){return _0x9907f['status'](_0x58b066)[_0x2d50('0x1c')](_0x5e020b);}};}function respondWithFilteredResult(_0x65f80c,_0x4c8f40){return function(_0x2c0bfc){if(_0x2c0bfc){var _0x32b32a=typeof _0x4c8f40[_0x2d50('0x1d')]===_0x2d50('0x1e')&&typeof _0x4c8f40[_0x2d50('0x1f')]===_0x2d50('0x1e');var _0x4b200b=_0x2c0bfc['count'];var _0x12a503=_0x32b32a?0x0:_0x4c8f40[_0x2d50('0x1d')];var _0x14765a=_0x32b32a?_0x2c0bfc['count']:_0x4c8f40['offset']+_0x4c8f40[_0x2d50('0x1f')];var _0x328a22;if(_0x14765a>=_0x4b200b){_0x14765a=_0x4b200b;_0x328a22=0xc8;}else{_0x328a22=0xce;}_0x65f80c[_0x2d50('0x20')](_0x328a22);return _0x65f80c[_0x2d50('0x21')](_0x2d50('0x22'),_0x12a503+'-'+_0x14765a+'/'+_0x4b200b)[_0x2d50('0x1c')](_0x2c0bfc);}return null;};}function patchUpdates(_0x2b6bee){return function(_0x4509f7){try{jsonpatch[_0x2d50('0x23')](_0x4509f7,_0x2b6bee,!![]);}catch(_0x13bce3){return BPromise[_0x2d50('0x24')](_0x13bce3);}return _0x4509f7[_0x2d50('0x25')]();};}function saveUpdates(_0x147add,_0x283f81){return function(_0x35f8ad){if(_0x35f8ad){return _0x35f8ad[_0x2d50('0x26')](_0x147add)[_0x2d50('0x27')](function(_0x4130b4){return _0x4130b4;});}return null;};}function removeEntity(_0x4e9f8d,_0x21257d){return function(_0x15ca13){if(_0x15ca13){return _0x15ca13[_0x2d50('0x28')]()[_0x2d50('0x27')](function(){_0x4e9f8d[_0x2d50('0x20')](0xcc)[_0x2d50('0x29')]();});}};}function handleEntityNotFound(_0x48a5d0,_0x53a99f){return function(_0x46a32d){if(!_0x46a32d){_0x48a5d0[_0x2d50('0x1b')](0x194);}return _0x46a32d;};}function handleError(_0x40750e,_0x450022){_0x450022=_0x450022||0x1f4;return function(_0x5ec86a){logger['error'](_0x5ec86a['stack']);if(_0x5ec86a[_0x2d50('0x2a')]){delete _0x5ec86a['name'];}_0x40750e[_0x2d50('0x20')](_0x450022)['send'](_0x5ec86a);};}exports['index']=function(_0x3dfd4f,_0x16aae2){var _0x184040={},_0x218cb7={},_0x1b8bb0={'count':0x0,'rows':[]};var _0x362aa9=_[_0x2d50('0x2b')](db['AnalyticFieldReport'][_0x2d50('0x2c')],function(_0x484438){return{'name':_0x484438['fieldName'],'type':_0x484438[_0x2d50('0x2d')][_0x2d50('0x2e')]};});_0x218cb7[_0x2d50('0x2f')]=_[_0x2d50('0x2b')](_0x362aa9,'name');_0x218cb7[_0x2d50('0x30')]=_[_0x2d50('0x31')](_0x3dfd4f['query']);_0x218cb7[_0x2d50('0x32')]=_[_0x2d50('0x33')](_0x218cb7[_0x2d50('0x2f')],_0x218cb7[_0x2d50('0x30')]);_0x184040[_0x2d50('0x34')]=_[_0x2d50('0x33')](_0x218cb7[_0x2d50('0x2f')],qs[_0x2d50('0x35')](_0x3dfd4f[_0x2d50('0x30')][_0x2d50('0x35')]));_0x184040[_0x2d50('0x34')]=_0x184040[_0x2d50('0x34')]['length']?_0x184040[_0x2d50('0x34')]:_0x218cb7[_0x2d50('0x2f')];if(!_0x3dfd4f[_0x2d50('0x30')]['hasOwnProperty'](_0x2d50('0x36'))){_0x184040['limit']=qs[_0x2d50('0x1f')](_0x3dfd4f['query'][_0x2d50('0x1f')]);_0x184040['offset']=qs[_0x2d50('0x1d')](_0x3dfd4f['query']['offset']);}_0x184040['order']=qs[_0x2d50('0x37')](_0x3dfd4f[_0x2d50('0x30')][_0x2d50('0x37')]);_0x184040[_0x2d50('0x38')]=qs['filters'](_[_0x2d50('0x39')](_0x3dfd4f[_0x2d50('0x30')],_0x218cb7['filters']),_0x362aa9);if(_0x3dfd4f[_0x2d50('0x30')][_0x2d50('0x3a')]){_0x184040[_0x2d50('0x38')]=_[_0x2d50('0x3b')](_0x184040[_0x2d50('0x38')],{'$or':_[_0x2d50('0x2b')](_0x362aa9,function(_0x51f11a){if(_0x51f11a['type']!==_0x2d50('0x3c')){var _0x11a7ed={};_0x11a7ed[_0x51f11a[_0x2d50('0x2a')]]={'$like':'%'+_0x3dfd4f[_0x2d50('0x30')][_0x2d50('0x3a')]+'%'};return _0x11a7ed;}})});}_0x184040=_[_0x2d50('0x3b')]({},_0x184040,_0x3dfd4f['options']);var _0x57f217={'where':_0x184040[_0x2d50('0x38')]};return db['AnalyticFieldReport'][_0x2d50('0x3d')](_0x57f217)[_0x2d50('0x27')](function(_0xd7a1cf){_0x1b8bb0[_0x2d50('0x3d')]=_0xd7a1cf;if(_0x3dfd4f[_0x2d50('0x30')][_0x2d50('0x3e')]){_0x184040[_0x2d50('0x3f')]=[{'all':!![]}];}return db['AnalyticFieldReport'][_0x2d50('0x40')](_0x184040);})['then'](function(_0x398f6f){_0x1b8bb0[_0x2d50('0x41')]=_0x398f6f;return _0x1b8bb0;})[_0x2d50('0x27')](respondWithFilteredResult(_0x16aae2,_0x184040))['catch'](handleError(_0x16aae2,null));};exports[_0x2d50('0x42')]=function(_0x2cc9df,_0xf2f54b){var _0xdb0298={'raw':![],'where':{'id':_0x2cc9df[_0x2d50('0x43')]['id']}},_0x2f05f3={};_0x2f05f3[_0x2d50('0x2f')]=_[_0x2d50('0x31')](db['AnalyticFieldReport'][_0x2d50('0x2c')]);_0x2f05f3[_0x2d50('0x30')]=_[_0x2d50('0x31')](_0x2cc9df['query']);_0x2f05f3[_0x2d50('0x32')]=_[_0x2d50('0x33')](_0x2f05f3[_0x2d50('0x2f')],_0x2f05f3[_0x2d50('0x30')]);_0xdb0298[_0x2d50('0x34')]=_[_0x2d50('0x33')](_0x2f05f3['model'],qs['fields'](_0x2cc9df[_0x2d50('0x30')]['fields']));_0xdb0298[_0x2d50('0x34')]=_0xdb0298[_0x2d50('0x34')]['length']?_0xdb0298[_0x2d50('0x34')]:_0x2f05f3['model'];if(_0x2cc9df[_0x2d50('0x30')][_0x2d50('0x3e')]){_0xdb0298['include']=[{'all':!![]}];}_0xdb0298=_['merge']({},_0xdb0298,_0x2cc9df['options']);return db['AnalyticFieldReport']['find'](_0xdb0298)[_0x2d50('0x27')](handleEntityNotFound(_0xf2f54b,null))[_0x2d50('0x27')](respondWithResult(_0xf2f54b,null))[_0x2d50('0x44')](handleError(_0xf2f54b,null));};exports['create']=function(_0x5f0d02,_0x351ed1){return db['AnalyticFieldReport']['create'](_0x5f0d02[_0x2d50('0x45')],{})['then'](respondWithResult(_0x351ed1,0xc9))[_0x2d50('0x44')](handleError(_0x351ed1,null));};exports[_0x2d50('0x46')]=function(_0x2f7c40,_0x4ad0c9){return db['AnalyticFieldReport'][_0x2d50('0x46')](_0x2f7c40[_0x2d50('0x45')],{'raw':![],'individualHooks':!![]})[_0x2d50('0x27')](respondWithResult(_0x4ad0c9,0xc9))['catch'](handleError(_0x4ad0c9,null));};exports['update']=function(_0x65e68,_0x3a957b){if(_0x65e68[_0x2d50('0x45')]['id']){delete _0x65e68[_0x2d50('0x45')]['id'];}return db[_0x2d50('0x47')][_0x2d50('0x48')]({'where':{'id':_0x65e68[_0x2d50('0x43')]['id']}})[_0x2d50('0x27')](handleEntityNotFound(_0x3a957b,null))[_0x2d50('0x27')](saveUpdates(_0x65e68[_0x2d50('0x45')],null))[_0x2d50('0x27')](respondWithResult(_0x3a957b,null))[_0x2d50('0x44')](handleError(_0x3a957b,null));};exports[_0x2d50('0x28')]=function(_0x67e300,_0x3c8143){return db['AnalyticFieldReport'][_0x2d50('0x48')]({'where':{'id':_0x67e300[_0x2d50('0x43')]['id']}})[_0x2d50('0x27')](handleEntityNotFound(_0x3c8143,null))[_0x2d50('0x27')](removeEntity(_0x3c8143,null))['catch'](handleError(_0x3c8143,null));};exports[_0x2d50('0x49')]=function(_0x3bd8a4,_0xf55e0d){return db[_0x2d50('0x47')][_0x2d50('0x28')]({'where':{'id':_0x3bd8a4[_0x2d50('0x30')]['ids']||[]},'raw':![],'individualHooks':!![]})[_0x2d50('0x27')](respondWithResult(_0xf55e0d,0xcc))['catch'](handleError(_0xf55e0d,null));};exports[_0x2d50('0x4a')]=function(_0x388333,_0x338de8,_0x4a540a){return db['AnalyticCustomReport']['findOne']({'where':{'id':_0x388333[_0x2d50('0x43')]['id']}})['then'](handleEntityNotFound(_0x338de8,null))['then'](function(_0x2a1763){if(_0x2a1763){return db[_0x2d50('0x4b')][_0x2d50('0x4c')](function(_0x3e252d){return db[_0x2d50('0x47')][_0x2d50('0x28')]({'where':{'CustomReportId':_0x388333[_0x2d50('0x43')]['id']},'transaction':_0x3e252d})['then'](function(_0x14d119){var _0x166f0f=_[_0x2d50('0x2b')](_0x388333[_0x2d50('0x45')],function(_0x2b7b9c){delete _0x2b7b9c['id'];_0x2b7b9c[_0x2d50('0x4d')]=_0x388333[_0x2d50('0x43')]['id'];return _0x2b7b9c;});return db['AnalyticFieldReport']['bulkCreate'](_0x166f0f,{'transaction':_0x3e252d});});})[_0x2d50('0x27')](function(){return db[_0x2d50('0x47')][_0x2d50('0x40')]({'where':{'CustomReportId':_0x388333[_0x2d50('0x43')]['id']}});});}})['then'](respondWithResult(_0x338de8,null))['catch'](handleError(_0x338de8,null));};