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 _0x6976=['ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','destroy','then','error','stack','name','send','index','map','AnalyticFieldReport','rawAttributes','fieldName','type','key','model','keys','filters','intersection','query','attributes','fields','length','hasOwnProperty','nolimit','sort','where','VIRTUAL','filter','merge','options','findAll','catch','show','params','find','create','bulkCreate','body','bulkDestroy','addFields','AnalyticCustomReport','sequelize','CustomReportId','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse'];(function(_0x4a5494,_0x3ad336){var _0x57cbb5=function(_0xa5a1ac){while(--_0xa5a1ac){_0x4a5494['push'](_0x4a5494['shift']());}};_0x57cbb5(++_0x3ad336);}(_0x6976,0x8e));var _0x6697=function(_0xa3f1fe,_0x5b7976){_0xa3f1fe=_0xa3f1fe-0x0;var _0x3e555d=_0x6976[_0xa3f1fe];return _0x3e555d;};'use strict';var pdf=require(_0x6697('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x6697('0x1'));var zipdir=require(_0x6697('0x2'));var jsonpatch=require(_0x6697('0x3'));var rp=require(_0x6697('0x4'));var moment=require(_0x6697('0x5'));var BPromise=require(_0x6697('0x6'));var Mustache=require(_0x6697('0x7'));var util=require('util');var path=require(_0x6697('0x8'));var sox=require(_0x6697('0x9'));var csv=require(_0x6697('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x6697('0xb'));var squel=require(_0x6697('0xc'));var crypto=require(_0x6697('0xd'));var jsforce=require(_0x6697('0xe'));var deskjs=require(_0x6697('0xf'));var toCsv=require(_0x6697('0xa'));var querystring=require(_0x6697('0x10'));var Papa=require(_0x6697('0x11'));var Redis=require(_0x6697('0x12'));var authService=require('../../components/auth/service');var qs=require(_0x6697('0x13'));var as=require(_0x6697('0x14'));var hardwareService=require(_0x6697('0x15'));var logger=require(_0x6697('0x16'))('api');var utils=require(_0x6697('0x17'));var config=require(_0x6697('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0x6697('0x19'))['db'];function respondWithStatusCode(_0x245ac1,_0x371618){_0x371618=_0x371618||0xcc;return function(_0x5c362e){if(_0x5c362e){return _0x245ac1[_0x6697('0x1a')](_0x371618);}return _0x245ac1[_0x6697('0x1b')](_0x371618)[_0x6697('0x1c')]();};}function respondWithResult(_0x567b42,_0x1d8184){_0x1d8184=_0x1d8184||0xc8;return function(_0x1b53ba){if(_0x1b53ba){return _0x567b42[_0x6697('0x1b')](_0x1d8184)[_0x6697('0x1d')](_0x1b53ba);}};}function respondWithFilteredResult(_0x4707ee,_0x4bd1b4){return function(_0x46ad80){if(_0x46ad80){var _0x12306e=_0x46ad80[_0x6697('0x1e')],_0x4aeea4=_0x4bd1b4['offset'],_0xc205b1=_0x4bd1b4[_0x6697('0x1f')]+_0x4bd1b4[_0x6697('0x20')],_0x82760f;if(_0xc205b1>=_0x12306e){_0xc205b1=_0x12306e;_0x82760f=0xc8;}else{_0x82760f=0xce;}_0x4707ee[_0x6697('0x1b')](_0x82760f);return _0x4707ee[_0x6697('0x21')](_0x6697('0x22'),_0x4aeea4+'-'+_0xc205b1+'/'+_0x12306e)[_0x6697('0x1d')](_0x46ad80);}return null;};}function patchUpdates(_0x579cab){return function(_0x5e6027){try{jsonpatch['apply'](_0x5e6027,_0x579cab,!![]);}catch(_0x17c1e6){return BPromise[_0x6697('0x23')](_0x17c1e6);}return _0x5e6027[_0x6697('0x24')]();};}function saveUpdates(_0x2a5d3d,_0x242cd4){return function(_0x136039){if(_0x136039){return _0x136039[_0x6697('0x25')](_0x2a5d3d)['then'](function(_0x243f1d){return _0x243f1d;});}return null;};}function removeEntity(_0x1000be,_0x4b238e){return function(_0x280260){if(_0x280260){return _0x280260[_0x6697('0x26')]()[_0x6697('0x27')](function(){_0x1000be[_0x6697('0x1b')](0xcc)[_0x6697('0x1c')]();});}};}function handleEntityNotFound(_0x4f4207,_0x1e9c11){return function(_0x1e5cdb){if(!_0x1e5cdb){_0x4f4207[_0x6697('0x1a')](0x194);}return _0x1e5cdb;};}function handleError(_0x4898e2,_0x4115eb){_0x4115eb=_0x4115eb||0x1f4;return function(_0x2a88e1){logger[_0x6697('0x28')](_0x2a88e1[_0x6697('0x29')]);if(_0x2a88e1[_0x6697('0x2a')]){delete _0x2a88e1[_0x6697('0x2a')];}_0x4898e2[_0x6697('0x1b')](_0x4115eb)[_0x6697('0x2b')](_0x2a88e1);};}exports[_0x6697('0x2c')]=function(_0x48d11d,_0xf74636){var _0x1260c1={},_0x3068ff={},_0xae44f4={'count':0x0,'rows':[]};var _0x37893f=_[_0x6697('0x2d')](db[_0x6697('0x2e')][_0x6697('0x2f')],function(_0x49d4ad){return{'name':_0x49d4ad[_0x6697('0x30')],'type':_0x49d4ad[_0x6697('0x31')][_0x6697('0x32')]};});_0x3068ff[_0x6697('0x33')]=_['map'](_0x37893f,'name');_0x3068ff['query']=_[_0x6697('0x34')](_0x48d11d['query']);_0x3068ff[_0x6697('0x35')]=_[_0x6697('0x36')](_0x3068ff['model'],_0x3068ff[_0x6697('0x37')]);_0x1260c1[_0x6697('0x38')]=_[_0x6697('0x36')](_0x3068ff[_0x6697('0x33')],qs[_0x6697('0x39')](_0x48d11d['query']['fields']));_0x1260c1[_0x6697('0x38')]=_0x1260c1[_0x6697('0x38')][_0x6697('0x3a')]?_0x1260c1['attributes']:_0x3068ff[_0x6697('0x33')];if(!_0x48d11d[_0x6697('0x37')][_0x6697('0x3b')](_0x6697('0x3c'))){_0x1260c1[_0x6697('0x20')]=qs[_0x6697('0x20')](_0x48d11d[_0x6697('0x37')][_0x6697('0x20')]);_0x1260c1[_0x6697('0x1f')]=qs[_0x6697('0x1f')](_0x48d11d[_0x6697('0x37')]['offset']);}_0x1260c1['order']=qs[_0x6697('0x3d')](_0x48d11d[_0x6697('0x37')][_0x6697('0x3d')]);_0x1260c1[_0x6697('0x3e')]=qs[_0x6697('0x35')](_['pick'](_0x48d11d[_0x6697('0x37')],_0x3068ff['filters']),_0x37893f);if(_0x48d11d['query']['filter']){_0x1260c1[_0x6697('0x3e')]=_['merge'](_0x1260c1['where'],{'$or':_[_0x6697('0x2d')](_0x37893f,function(_0x530d9d){if(_0x530d9d[_0x6697('0x31')]!==_0x6697('0x3f')){var _0x2cfc64={};_0x2cfc64[_0x530d9d[_0x6697('0x2a')]]={'$like':'%'+_0x48d11d[_0x6697('0x37')][_0x6697('0x40')]+'%'};return _0x2cfc64;}})});}_0x1260c1=_[_0x6697('0x41')]({},_0x1260c1,_0x48d11d[_0x6697('0x42')]);var _0x182a22={'where':_0x1260c1[_0x6697('0x3e')]};return db[_0x6697('0x2e')][_0x6697('0x1e')](_0x182a22)[_0x6697('0x27')](function(_0x3b163e){_0xae44f4[_0x6697('0x1e')]=_0x3b163e;if(_0x48d11d['query']['includeAll']){_0x1260c1['include']=[{'all':!![]}];}return db[_0x6697('0x2e')][_0x6697('0x43')](_0x1260c1);})[_0x6697('0x27')](function(_0x1edf5f){_0xae44f4['rows']=_0x1edf5f;return _0xae44f4;})[_0x6697('0x27')](respondWithFilteredResult(_0xf74636,_0x1260c1))[_0x6697('0x44')](handleError(_0xf74636,null));};exports[_0x6697('0x45')]=function(_0x165209,_0x1a30c6){var _0x35a90f={'raw':![],'where':{'id':_0x165209[_0x6697('0x46')]['id']}},_0x50b1a0={};_0x50b1a0[_0x6697('0x33')]=_[_0x6697('0x34')](db['AnalyticFieldReport'][_0x6697('0x2f')]);_0x50b1a0[_0x6697('0x37')]=_[_0x6697('0x34')](_0x165209['query']);_0x50b1a0['filters']=_[_0x6697('0x36')](_0x50b1a0[_0x6697('0x33')],_0x50b1a0[_0x6697('0x37')]);_0x35a90f[_0x6697('0x38')]=_[_0x6697('0x36')](_0x50b1a0[_0x6697('0x33')],qs[_0x6697('0x39')](_0x165209[_0x6697('0x37')][_0x6697('0x39')]));_0x35a90f[_0x6697('0x38')]=_0x35a90f[_0x6697('0x38')][_0x6697('0x3a')]?_0x35a90f[_0x6697('0x38')]:_0x50b1a0['model'];if(_0x165209[_0x6697('0x37')]['includeAll']){_0x35a90f['include']=[{'all':!![]}];}_0x35a90f=_[_0x6697('0x41')]({},_0x35a90f,_0x165209[_0x6697('0x42')]);return db[_0x6697('0x2e')][_0x6697('0x47')](_0x35a90f)['then'](handleEntityNotFound(_0x1a30c6,null))[_0x6697('0x27')](respondWithResult(_0x1a30c6,null))[_0x6697('0x44')](handleError(_0x1a30c6,null));};exports[_0x6697('0x48')]=function(_0xa9f983,_0x2ac192){return db[_0x6697('0x2e')][_0x6697('0x48')](_0xa9f983['body'],{})['then'](respondWithResult(_0x2ac192,0xc9))[_0x6697('0x44')](handleError(_0x2ac192,null));};exports['bulkCreate']=function(_0x527f78,_0x5a66bf){return db[_0x6697('0x2e')][_0x6697('0x49')](_0x527f78[_0x6697('0x4a')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x5a66bf,0xc9))[_0x6697('0x44')](handleError(_0x5a66bf,null));};exports[_0x6697('0x25')]=function(_0x1fcdfe,_0x527d97){if(_0x1fcdfe[_0x6697('0x4a')]['id']){delete _0x1fcdfe[_0x6697('0x4a')]['id'];}return db[_0x6697('0x2e')][_0x6697('0x47')]({'where':{'id':_0x1fcdfe[_0x6697('0x46')]['id']}})[_0x6697('0x27')](handleEntityNotFound(_0x527d97,null))['then'](saveUpdates(_0x1fcdfe['body'],null))[_0x6697('0x27')](respondWithResult(_0x527d97,null))[_0x6697('0x44')](handleError(_0x527d97,null));};exports[_0x6697('0x26')]=function(_0x5041b2,_0x350243){return db[_0x6697('0x2e')][_0x6697('0x47')]({'where':{'id':_0x5041b2[_0x6697('0x46')]['id']}})[_0x6697('0x27')](handleEntityNotFound(_0x350243,null))['then'](removeEntity(_0x350243,null))[_0x6697('0x44')](handleError(_0x350243,null));};exports[_0x6697('0x4b')]=function(_0x23347b,_0x38d65a){return db[_0x6697('0x2e')][_0x6697('0x26')]({'where':{'id':_0x23347b[_0x6697('0x37')]['ids']||[]},'raw':![],'individualHooks':!![]})[_0x6697('0x27')](respondWithResult(_0x38d65a,0xcc))['catch'](handleError(_0x38d65a,null));};exports[_0x6697('0x4c')]=function(_0x32ad2d,_0x1639be,_0x534f30){return db[_0x6697('0x4d')]['findOne']({'where':{'id':_0x32ad2d[_0x6697('0x46')]['id']}})[_0x6697('0x27')](handleEntityNotFound(_0x1639be,null))[_0x6697('0x27')](function(_0x12aeb9){if(_0x12aeb9){return db[_0x6697('0x4e')]['transaction'](function(_0x3f84e2){return db[_0x6697('0x2e')][_0x6697('0x26')]({'where':{'CustomReportId':_0x32ad2d[_0x6697('0x46')]['id']},'transaction':_0x3f84e2})[_0x6697('0x27')](function(_0x33d571){var _0xc8a5e2=_[_0x6697('0x2d')](_0x32ad2d['body'],function(_0x9a11cc){delete _0x9a11cc['id'];_0x9a11cc[_0x6697('0x4f')]=_0x32ad2d[_0x6697('0x46')]['id'];return _0x9a11cc;});return db[_0x6697('0x2e')][_0x6697('0x49')](_0xc8a5e2,{'transaction':_0x3f84e2});});})[_0x6697('0x27')](function(){return db[_0x6697('0x2e')][_0x6697('0x43')]({'where':{'CustomReportId':_0x32ad2d[_0x6697('0x46')]['id']}});});}})[_0x6697('0x27')](respondWithResult(_0x1639be,null))[_0x6697('0x44')](handleError(_0x1639be,null));};