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 _0xfe5e=['sendStatus','error','stack','name','send','index','map','AnalyticFieldReport','rawAttributes','fieldName','type','key','query','model','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','VIRTUAL','merge','includeAll','include','findAll','catch','show','params','keys','options','find','create','body','bulkCreate','bulkDestroy','ids','addFields','findOne','sequelize','CustomReportId','rimraf','fast-json-patch','request-promise','moment','bluebird','sox','ejs','fs-extra','lodash','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/environment','../../config/license/util','../../mysqldb','status','end','undefined','limit','offset','count','set','Content-Range','apply','save','update','then','destroy'];(function(_0x3be6af,_0x22fece){var _0x60f1b3=function(_0x29ecb5){while(--_0x29ecb5){_0x3be6af['push'](_0x3be6af['shift']());}};_0x60f1b3(++_0x22fece);}(_0xfe5e,0x176));var _0xefe5=function(_0x3a1cca,_0xf9cf7e){_0x3a1cca=_0x3a1cca-0x0;var _0x53b71c=_0xfe5e[_0x3a1cca];return _0x53b71c;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xefe5('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xefe5('0x1'));var rp=require(_0xefe5('0x2'));var moment=require(_0xefe5('0x3'));var BPromise=require(_0xefe5('0x4'));var Mustache=require('mustache');var util=require('util');var path=require('path');var sox=require(_0xefe5('0x5'));var csv=require('to-csv');var ejs=require(_0xefe5('0x6'));var fs=require('fs');var fs_extra=require(_0xefe5('0x7'));var _=require(_0xefe5('0x8'));var squel=require('squel');var crypto=require(_0xefe5('0x9'));var jsforce=require(_0xefe5('0xa'));var deskjs=require(_0xefe5('0xb'));var toCsv=require(_0xefe5('0xc'));var querystring=require(_0xefe5('0xd'));var Papa=require(_0xefe5('0xe'));var Redis=require(_0xefe5('0xf'));var authService=require(_0xefe5('0x10'));var qs=require(_0xefe5('0x11'));var as=require(_0xefe5('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xefe5('0x13'));var utils=require('../../config/utils');var config=require(_0xefe5('0x14'));var licenseUtil=require(_0xefe5('0x15'));var db=require(_0xefe5('0x16'))['db'];function respondWithStatusCode(_0x507e54,_0x5cbb14){_0x5cbb14=_0x5cbb14||0xcc;return function(_0x5a581d){if(_0x5a581d){return _0x507e54['sendStatus'](_0x5cbb14);}return _0x507e54[_0xefe5('0x17')](_0x5cbb14)[_0xefe5('0x18')]();};}function respondWithResult(_0x102f1f,_0x36f185){_0x36f185=_0x36f185||0xc8;return function(_0x133161){if(_0x133161){return _0x102f1f[_0xefe5('0x17')](_0x36f185)['json'](_0x133161);}};}function respondWithFilteredResult(_0x931bc9,_0x268e50){return function(_0x313dd6){if(_0x313dd6){var _0x35ff98=typeof _0x268e50['offset']===_0xefe5('0x19')&&typeof _0x268e50[_0xefe5('0x1a')]===_0xefe5('0x19');var _0xa171a3=_0x313dd6['count'];var _0x2289ee=_0x35ff98?0x0:_0x268e50[_0xefe5('0x1b')];var _0x241bd3=_0x35ff98?_0x313dd6[_0xefe5('0x1c')]:_0x268e50['offset']+_0x268e50['limit'];var _0x7c41bf;if(_0x241bd3>=_0xa171a3){_0x241bd3=_0xa171a3;_0x7c41bf=0xc8;}else{_0x7c41bf=0xce;}_0x931bc9[_0xefe5('0x17')](_0x7c41bf);return _0x931bc9[_0xefe5('0x1d')](_0xefe5('0x1e'),_0x2289ee+'-'+_0x241bd3+'/'+_0xa171a3)['json'](_0x313dd6);}return null;};}function patchUpdates(_0xd8bd7d){return function(_0x4490fd){try{jsonpatch[_0xefe5('0x1f')](_0x4490fd,_0xd8bd7d,!![]);}catch(_0x21e1c3){return BPromise['reject'](_0x21e1c3);}return _0x4490fd[_0xefe5('0x20')]();};}function saveUpdates(_0x91140,_0x27f15f){return function(_0x2a8a1){if(_0x2a8a1){return _0x2a8a1[_0xefe5('0x21')](_0x91140)[_0xefe5('0x22')](function(_0x3d86ea){return _0x3d86ea;});}return null;};}function removeEntity(_0x2e7ecd,_0x98e1cb){return function(_0x4e0c50){if(_0x4e0c50){return _0x4e0c50[_0xefe5('0x23')]()[_0xefe5('0x22')](function(){_0x2e7ecd[_0xefe5('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x314e76,_0x2d667d){return function(_0x15cb76){if(!_0x15cb76){_0x314e76[_0xefe5('0x24')](0x194);}return _0x15cb76;};}function handleError(_0x26e48a,_0x50f854){_0x50f854=_0x50f854||0x1f4;return function(_0x56e49b){logger[_0xefe5('0x25')](_0x56e49b[_0xefe5('0x26')]);if(_0x56e49b[_0xefe5('0x27')]){delete _0x56e49b[_0xefe5('0x27')];}_0x26e48a[_0xefe5('0x17')](_0x50f854)[_0xefe5('0x28')](_0x56e49b);};}exports[_0xefe5('0x29')]=function(_0x8f541c,_0x36a7b8){var _0x3ec5b1={},_0x26241a={},_0x40540b={'count':0x0,'rows':[]};var _0x19e427=_[_0xefe5('0x2a')](db[_0xefe5('0x2b')][_0xefe5('0x2c')],function(_0x643a86){return{'name':_0x643a86[_0xefe5('0x2d')],'type':_0x643a86[_0xefe5('0x2e')][_0xefe5('0x2f')]};});_0x26241a['model']=_[_0xefe5('0x2a')](_0x19e427,_0xefe5('0x27'));_0x26241a[_0xefe5('0x30')]=_['keys'](_0x8f541c[_0xefe5('0x30')]);_0x26241a['filters']=_['intersection'](_0x26241a[_0xefe5('0x31')],_0x26241a[_0xefe5('0x30')]);_0x3ec5b1[_0xefe5('0x32')]=_[_0xefe5('0x33')](_0x26241a['model'],qs[_0xefe5('0x34')](_0x8f541c[_0xefe5('0x30')]['fields']));_0x3ec5b1[_0xefe5('0x32')]=_0x3ec5b1[_0xefe5('0x32')][_0xefe5('0x35')]?_0x3ec5b1[_0xefe5('0x32')]:_0x26241a[_0xefe5('0x31')];if(!_0x8f541c[_0xefe5('0x30')][_0xefe5('0x36')](_0xefe5('0x37'))){_0x3ec5b1['limit']=qs[_0xefe5('0x1a')](_0x8f541c['query']['limit']);_0x3ec5b1[_0xefe5('0x1b')]=qs['offset'](_0x8f541c['query']['offset']);}_0x3ec5b1[_0xefe5('0x38')]=qs[_0xefe5('0x39')](_0x8f541c[_0xefe5('0x30')][_0xefe5('0x39')]);_0x3ec5b1[_0xefe5('0x3a')]=qs[_0xefe5('0x3b')](_[_0xefe5('0x3c')](_0x8f541c[_0xefe5('0x30')],_0x26241a[_0xefe5('0x3b')]),_0x19e427);if(_0x8f541c['query'][_0xefe5('0x3d')]){_0x3ec5b1[_0xefe5('0x3a')]=_['merge'](_0x3ec5b1['where'],{'$or':_['map'](_0x19e427,function(_0x1a14fa){if(_0x1a14fa['type']!==_0xefe5('0x3e')){var _0x22c93d={};_0x22c93d[_0x1a14fa[_0xefe5('0x27')]]={'$like':'%'+_0x8f541c[_0xefe5('0x30')]['filter']+'%'};return _0x22c93d;}})});}_0x3ec5b1=_[_0xefe5('0x3f')]({},_0x3ec5b1,_0x8f541c['options']);var _0x3fe309={'where':_0x3ec5b1['where']};return db[_0xefe5('0x2b')][_0xefe5('0x1c')](_0x3fe309)[_0xefe5('0x22')](function(_0x18373f){_0x40540b[_0xefe5('0x1c')]=_0x18373f;if(_0x8f541c['query'][_0xefe5('0x40')]){_0x3ec5b1[_0xefe5('0x41')]=[{'all':!![]}];}return db[_0xefe5('0x2b')][_0xefe5('0x42')](_0x3ec5b1);})[_0xefe5('0x22')](function(_0x5e5a70){_0x40540b['rows']=_0x5e5a70;return _0x40540b;})['then'](respondWithFilteredResult(_0x36a7b8,_0x3ec5b1))[_0xefe5('0x43')](handleError(_0x36a7b8,null));};exports[_0xefe5('0x44')]=function(_0x3436d1,_0x257c3a){var _0x403664={'raw':![],'where':{'id':_0x3436d1[_0xefe5('0x45')]['id']}},_0x4bb47c={};_0x4bb47c[_0xefe5('0x31')]=_[_0xefe5('0x46')](db[_0xefe5('0x2b')][_0xefe5('0x2c')]);_0x4bb47c[_0xefe5('0x30')]=_[_0xefe5('0x46')](_0x3436d1[_0xefe5('0x30')]);_0x4bb47c[_0xefe5('0x3b')]=_['intersection'](_0x4bb47c['model'],_0x4bb47c['query']);_0x403664[_0xefe5('0x32')]=_[_0xefe5('0x33')](_0x4bb47c['model'],qs[_0xefe5('0x34')](_0x3436d1['query'][_0xefe5('0x34')]));_0x403664['attributes']=_0x403664[_0xefe5('0x32')][_0xefe5('0x35')]?_0x403664['attributes']:_0x4bb47c[_0xefe5('0x31')];if(_0x3436d1[_0xefe5('0x30')][_0xefe5('0x40')]){_0x403664['include']=[{'all':!![]}];}_0x403664=_[_0xefe5('0x3f')]({},_0x403664,_0x3436d1[_0xefe5('0x47')]);return db[_0xefe5('0x2b')][_0xefe5('0x48')](_0x403664)[_0xefe5('0x22')](handleEntityNotFound(_0x257c3a,null))[_0xefe5('0x22')](respondWithResult(_0x257c3a,null))[_0xefe5('0x43')](handleError(_0x257c3a,null));};exports[_0xefe5('0x49')]=function(_0x207f98,_0x2e2386){return db[_0xefe5('0x2b')]['create'](_0x207f98[_0xefe5('0x4a')],{})[_0xefe5('0x22')](respondWithResult(_0x2e2386,0xc9))[_0xefe5('0x43')](handleError(_0x2e2386,null));};exports['bulkCreate']=function(_0x4e4c88,_0x5b75bd){return db[_0xefe5('0x2b')][_0xefe5('0x4b')](_0x4e4c88[_0xefe5('0x4a')],{'raw':![],'individualHooks':!![]})[_0xefe5('0x22')](respondWithResult(_0x5b75bd,0xc9))[_0xefe5('0x43')](handleError(_0x5b75bd,null));};exports[_0xefe5('0x21')]=function(_0xd04075,_0x3ce317){if(_0xd04075[_0xefe5('0x4a')]['id']){delete _0xd04075[_0xefe5('0x4a')]['id'];}return db[_0xefe5('0x2b')][_0xefe5('0x48')]({'where':{'id':_0xd04075[_0xefe5('0x45')]['id']}})['then'](handleEntityNotFound(_0x3ce317,null))['then'](saveUpdates(_0xd04075['body'],null))['then'](respondWithResult(_0x3ce317,null))['catch'](handleError(_0x3ce317,null));};exports[_0xefe5('0x23')]=function(_0x169fb6,_0x504192){return db['AnalyticFieldReport'][_0xefe5('0x48')]({'where':{'id':_0x169fb6[_0xefe5('0x45')]['id']}})[_0xefe5('0x22')](handleEntityNotFound(_0x504192,null))['then'](removeEntity(_0x504192,null))['catch'](handleError(_0x504192,null));};exports[_0xefe5('0x4c')]=function(_0x3fe824,_0x4f6d23){return db['AnalyticFieldReport']['destroy']({'where':{'id':_0x3fe824['query'][_0xefe5('0x4d')]||[]},'raw':![],'individualHooks':!![]})[_0xefe5('0x22')](respondWithResult(_0x4f6d23,0xcc))[_0xefe5('0x43')](handleError(_0x4f6d23,null));};exports[_0xefe5('0x4e')]=function(_0x860e95,_0xc9b29f,_0x3460a5){return db['AnalyticCustomReport'][_0xefe5('0x4f')]({'where':{'id':_0x860e95[_0xefe5('0x45')]['id']}})[_0xefe5('0x22')](handleEntityNotFound(_0xc9b29f,null))[_0xefe5('0x22')](function(_0x4ef5a8){if(_0x4ef5a8){return db[_0xefe5('0x50')]['transaction'](function(_0x43d32e){return db[_0xefe5('0x2b')][_0xefe5('0x23')]({'where':{'CustomReportId':_0x860e95[_0xefe5('0x45')]['id']},'transaction':_0x43d32e})['then'](function(_0x3692d2){var _0xb93963=_[_0xefe5('0x2a')](_0x860e95['body'],function(_0x57a4f2){delete _0x57a4f2['id'];_0x57a4f2[_0xefe5('0x51')]=_0x860e95[_0xefe5('0x45')]['id'];return _0x57a4f2;});return db['AnalyticFieldReport']['bulkCreate'](_0xb93963,{'transaction':_0x43d32e});});})['then'](function(){return db[_0xefe5('0x2b')][_0xefe5('0x42')]({'where':{'CustomReportId':_0x860e95[_0xefe5('0x45')]['id']}});});}})[_0xefe5('0x22')](respondWithResult(_0xc9b29f,null))[_0xefe5('0x43')](handleError(_0xc9b29f,null));};