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 _0xce76=['squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','sendStatus','status','end','count','offset','limit','set','Content-Range','json','apply','reject','save','update','then','error','stack','name','index','map','rawAttributes','fieldName','type','key','query','keys','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','VIRTUAL','filter','merge','AnalyticFieldReport','includeAll','include','findAll','catch','show','params','options','find','create','bulkCreate','body','bulkDestroy','destroy','ids','AnalyticCustomReport','findOne','sequelize','transaction','CustomReportId','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','mustache','util','sox','to-csv','ejs','lodash'];(function(_0x263c9d,_0x432714){var _0x3eba60=function(_0x814ad2){while(--_0x814ad2){_0x263c9d['push'](_0x263c9d['shift']());}};_0x3eba60(++_0x432714);}(_0xce76,0xa2));var _0x6ce7=function(_0x36a6d7,_0x5bf4e0){_0x36a6d7=_0x36a6d7-0x0;var _0x5763a1=_0xce76[_0x36a6d7];return _0x5763a1;};'use strict';var pdf=require(_0x6ce7('0x0'));var emlformat=require(_0x6ce7('0x1'));var rimraf=require(_0x6ce7('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x6ce7('0x3'));var rp=require(_0x6ce7('0x4'));var moment=require(_0x6ce7('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x6ce7('0x6'));var util=require(_0x6ce7('0x7'));var path=require('path');var sox=require(_0x6ce7('0x8'));var csv=require(_0x6ce7('0x9'));var ejs=require(_0x6ce7('0xa'));var fs=require('fs');var _=require(_0x6ce7('0xb'));var squel=require(_0x6ce7('0xc'));var crypto=require(_0x6ce7('0xd'));var jsforce=require(_0x6ce7('0xe'));var deskjs=require(_0x6ce7('0xf'));var toCsv=require(_0x6ce7('0x9'));var querystring=require(_0x6ce7('0x10'));var Papa=require(_0x6ce7('0x11'));var Redis=require(_0x6ce7('0x12'));var authService=require(_0x6ce7('0x13'));var qs=require(_0x6ce7('0x14'));var as=require(_0x6ce7('0x15'));var hardwareService=require(_0x6ce7('0x16'));var logger=require(_0x6ce7('0x17'))(_0x6ce7('0x18'));var utils=require(_0x6ce7('0x19'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x6ce7('0x1a'))['db'];function respondWithStatusCode(_0x27c1f3,_0xe5bae0){_0xe5bae0=_0xe5bae0||0xcc;return function(_0x3f63e3){if(_0x3f63e3){return _0x27c1f3[_0x6ce7('0x1b')](_0xe5bae0);}return _0x27c1f3[_0x6ce7('0x1c')](_0xe5bae0)[_0x6ce7('0x1d')]();};}function respondWithResult(_0x4647e0,_0x202773){_0x202773=_0x202773||0xc8;return function(_0x28426f){if(_0x28426f){return _0x4647e0[_0x6ce7('0x1c')](_0x202773)['json'](_0x28426f);}};}function respondWithFilteredResult(_0x1d9fa2,_0x34cb6c){return function(_0x223348){if(_0x223348){var _0x14c48c=_0x223348[_0x6ce7('0x1e')],_0x2e07f6=_0x34cb6c[_0x6ce7('0x1f')],_0x112e0c=_0x34cb6c[_0x6ce7('0x1f')]+_0x34cb6c[_0x6ce7('0x20')],_0x2ca56a;if(_0x112e0c>=_0x14c48c){_0x112e0c=_0x14c48c;_0x2ca56a=0xc8;}else{_0x2ca56a=0xce;}_0x1d9fa2[_0x6ce7('0x1c')](_0x2ca56a);return _0x1d9fa2[_0x6ce7('0x21')](_0x6ce7('0x22'),_0x2e07f6+'-'+_0x112e0c+'/'+_0x14c48c)[_0x6ce7('0x23')](_0x223348);}return null;};}function patchUpdates(_0x43bbc0){return function(_0x15af46){try{jsonpatch[_0x6ce7('0x24')](_0x15af46,_0x43bbc0,!![]);}catch(_0x414f24){return BPromise[_0x6ce7('0x25')](_0x414f24);}return _0x15af46[_0x6ce7('0x26')]();};}function saveUpdates(_0x317a29,_0x2f1795){return function(_0x5b9fa7){if(_0x5b9fa7){return _0x5b9fa7[_0x6ce7('0x27')](_0x317a29)[_0x6ce7('0x28')](function(_0x2a8800){return _0x2a8800;});}return null;};}function removeEntity(_0x259f80,_0x360420){return function(_0x4fb5a4){if(_0x4fb5a4){return _0x4fb5a4['destroy']()['then'](function(){_0x259f80[_0x6ce7('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x59676d,_0x54d796){return function(_0x6fbeff){if(!_0x6fbeff){_0x59676d[_0x6ce7('0x1b')](0x194);}return _0x6fbeff;};}function handleError(_0x1c93f3,_0x397fd4){_0x397fd4=_0x397fd4||0x1f4;return function(_0x388784){logger[_0x6ce7('0x29')](_0x388784[_0x6ce7('0x2a')]);if(_0x388784[_0x6ce7('0x2b')]){delete _0x388784[_0x6ce7('0x2b')];}_0x1c93f3[_0x6ce7('0x1c')](_0x397fd4)['send'](_0x388784);};}exports[_0x6ce7('0x2c')]=function(_0x3d4f34,_0x1f4e94){var _0x465755={},_0x4f9a01={},_0x5b2add={'count':0x0,'rows':[]};var _0xfdd0a2=_[_0x6ce7('0x2d')](db['AnalyticFieldReport'][_0x6ce7('0x2e')],function(_0x585a3c){return{'name':_0x585a3c[_0x6ce7('0x2f')],'type':_0x585a3c[_0x6ce7('0x30')][_0x6ce7('0x31')]};});_0x4f9a01['model']=_['map'](_0xfdd0a2,_0x6ce7('0x2b'));_0x4f9a01[_0x6ce7('0x32')]=_[_0x6ce7('0x33')](_0x3d4f34[_0x6ce7('0x32')]);_0x4f9a01[_0x6ce7('0x34')]=_[_0x6ce7('0x35')](_0x4f9a01['model'],_0x4f9a01[_0x6ce7('0x32')]);_0x465755[_0x6ce7('0x36')]=_['intersection'](_0x4f9a01[_0x6ce7('0x37')],qs[_0x6ce7('0x38')](_0x3d4f34['query'][_0x6ce7('0x38')]));_0x465755[_0x6ce7('0x36')]=_0x465755['attributes'][_0x6ce7('0x39')]?_0x465755[_0x6ce7('0x36')]:_0x4f9a01[_0x6ce7('0x37')];if(!_0x3d4f34[_0x6ce7('0x32')][_0x6ce7('0x3a')](_0x6ce7('0x3b'))){_0x465755[_0x6ce7('0x20')]=qs[_0x6ce7('0x20')](_0x3d4f34[_0x6ce7('0x32')][_0x6ce7('0x20')]);_0x465755[_0x6ce7('0x1f')]=qs[_0x6ce7('0x1f')](_0x3d4f34['query']['offset']);}_0x465755[_0x6ce7('0x3c')]=qs[_0x6ce7('0x3d')](_0x3d4f34[_0x6ce7('0x32')][_0x6ce7('0x3d')]);_0x465755[_0x6ce7('0x3e')]=qs[_0x6ce7('0x34')](_[_0x6ce7('0x3f')](_0x3d4f34[_0x6ce7('0x32')],_0x4f9a01[_0x6ce7('0x34')]),_0xfdd0a2);if(_0x3d4f34['query']['filter']){_0x465755[_0x6ce7('0x3e')]=_['merge'](_0x465755[_0x6ce7('0x3e')],{'$or':_['map'](_0xfdd0a2,function(_0x58979a){if(_0x58979a['type']!==_0x6ce7('0x40')){var _0xffa62e={};_0xffa62e[_0x58979a[_0x6ce7('0x2b')]]={'$like':'%'+_0x3d4f34[_0x6ce7('0x32')][_0x6ce7('0x41')]+'%'};return _0xffa62e;}})});}_0x465755=_[_0x6ce7('0x42')]({},_0x465755,_0x3d4f34['options']);var _0x594673={'where':_0x465755[_0x6ce7('0x3e')]};return db[_0x6ce7('0x43')][_0x6ce7('0x1e')](_0x594673)[_0x6ce7('0x28')](function(_0x2064bf){_0x5b2add['count']=_0x2064bf;if(_0x3d4f34[_0x6ce7('0x32')][_0x6ce7('0x44')]){_0x465755[_0x6ce7('0x45')]=[{'all':!![]}];}return db['AnalyticFieldReport'][_0x6ce7('0x46')](_0x465755);})[_0x6ce7('0x28')](function(_0xadc702){_0x5b2add['rows']=_0xadc702;return _0x5b2add;})[_0x6ce7('0x28')](respondWithFilteredResult(_0x1f4e94,_0x465755))[_0x6ce7('0x47')](handleError(_0x1f4e94,null));};exports[_0x6ce7('0x48')]=function(_0x51d277,_0x4456a6){var _0xaaf540={'raw':![],'where':{'id':_0x51d277[_0x6ce7('0x49')]['id']}},_0x390c03={};_0x390c03[_0x6ce7('0x37')]=_[_0x6ce7('0x33')](db[_0x6ce7('0x43')][_0x6ce7('0x2e')]);_0x390c03[_0x6ce7('0x32')]=_[_0x6ce7('0x33')](_0x51d277[_0x6ce7('0x32')]);_0x390c03[_0x6ce7('0x34')]=_[_0x6ce7('0x35')](_0x390c03[_0x6ce7('0x37')],_0x390c03[_0x6ce7('0x32')]);_0xaaf540[_0x6ce7('0x36')]=_[_0x6ce7('0x35')](_0x390c03['model'],qs[_0x6ce7('0x38')](_0x51d277['query'][_0x6ce7('0x38')]));_0xaaf540[_0x6ce7('0x36')]=_0xaaf540[_0x6ce7('0x36')][_0x6ce7('0x39')]?_0xaaf540['attributes']:_0x390c03['model'];if(_0x51d277[_0x6ce7('0x32')][_0x6ce7('0x44')]){_0xaaf540[_0x6ce7('0x45')]=[{'all':!![]}];}_0xaaf540=_['merge']({},_0xaaf540,_0x51d277[_0x6ce7('0x4a')]);return db[_0x6ce7('0x43')][_0x6ce7('0x4b')](_0xaaf540)['then'](handleEntityNotFound(_0x4456a6,null))[_0x6ce7('0x28')](respondWithResult(_0x4456a6,null))[_0x6ce7('0x47')](handleError(_0x4456a6,null));};exports[_0x6ce7('0x4c')]=function(_0x3f4300,_0x1f66e4){return db['AnalyticFieldReport'][_0x6ce7('0x4c')](_0x3f4300['body'],{})[_0x6ce7('0x28')](respondWithResult(_0x1f66e4,0xc9))[_0x6ce7('0x47')](handleError(_0x1f66e4,null));};exports[_0x6ce7('0x4d')]=function(_0x1a7d8c,_0x30552a){return db['AnalyticFieldReport'][_0x6ce7('0x4d')](_0x1a7d8c[_0x6ce7('0x4e')],{'raw':![],'individualHooks':!![]})[_0x6ce7('0x28')](respondWithResult(_0x30552a,0xc9))[_0x6ce7('0x47')](handleError(_0x30552a,null));};exports[_0x6ce7('0x27')]=function(_0x2a7c89,_0x380d05){if(_0x2a7c89[_0x6ce7('0x4e')]['id']){delete _0x2a7c89[_0x6ce7('0x4e')]['id'];}return db[_0x6ce7('0x43')]['find']({'where':{'id':_0x2a7c89[_0x6ce7('0x49')]['id']}})[_0x6ce7('0x28')](handleEntityNotFound(_0x380d05,null))['then'](saveUpdates(_0x2a7c89[_0x6ce7('0x4e')],null))[_0x6ce7('0x28')](respondWithResult(_0x380d05,null))[_0x6ce7('0x47')](handleError(_0x380d05,null));};exports['destroy']=function(_0x525052,_0x1006e6){return db[_0x6ce7('0x43')][_0x6ce7('0x4b')]({'where':{'id':_0x525052[_0x6ce7('0x49')]['id']}})[_0x6ce7('0x28')](handleEntityNotFound(_0x1006e6,null))[_0x6ce7('0x28')](removeEntity(_0x1006e6,null))['catch'](handleError(_0x1006e6,null));};exports[_0x6ce7('0x4f')]=function(_0x345c05,_0x4feee6){return db[_0x6ce7('0x43')][_0x6ce7('0x50')]({'where':{'id':_0x345c05['query'][_0x6ce7('0x51')]||[]},'raw':![],'individualHooks':!![]})[_0x6ce7('0x28')](respondWithResult(_0x4feee6,0xcc))[_0x6ce7('0x47')](handleError(_0x4feee6,null));};exports['addFields']=function(_0x1fe4be,_0x4b4068,_0x4caf19){return db[_0x6ce7('0x52')][_0x6ce7('0x53')]({'where':{'id':_0x1fe4be['params']['id']}})[_0x6ce7('0x28')](handleEntityNotFound(_0x4b4068,null))[_0x6ce7('0x28')](function(_0xcc92b5){if(_0xcc92b5){return db[_0x6ce7('0x54')][_0x6ce7('0x55')](function(_0x321e97){return db[_0x6ce7('0x43')][_0x6ce7('0x50')]({'where':{'CustomReportId':_0x1fe4be[_0x6ce7('0x49')]['id']},'transaction':_0x321e97})[_0x6ce7('0x28')](function(_0x13bd7f){var _0x140cb9=_[_0x6ce7('0x2d')](_0x1fe4be[_0x6ce7('0x4e')],function(_0x5477eb){delete _0x5477eb['id'];_0x5477eb[_0x6ce7('0x56')]=_0x1fe4be[_0x6ce7('0x49')]['id'];return _0x5477eb;});return db['AnalyticFieldReport'][_0x6ce7('0x4d')](_0x140cb9,{'transaction':_0x321e97});});})[_0x6ce7('0x28')](function(){return db['AnalyticFieldReport'][_0x6ce7('0x46')]({'where':{'CustomReportId':_0x1fe4be[_0x6ce7('0x49')]['id']}});});}})[_0x6ce7('0x28')](respondWithResult(_0x4b4068,null))[_0x6ce7('0x47')](handleError(_0x4b4068,null));};