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 _0x72d9=['keys','filters','intersection','attributes','fields','nolimit','sort','where','pick','filter','VIRTUAL','merge','options','include','findAll','catch','show','params','length','includeAll','find','create','body','bulkCreate','bulkDestroy','ids','findOne','transaction','rimraf','zip-dir','moment','bluebird','mustache','util','path','sox','ejs','lodash','squel','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','undefined','limit','count','offset','set','Content-Range','json','apply','save','update','then','destroy','error','name','send','index','map','AnalyticFieldReport','rawAttributes','fieldName','type','key','model','query'];(function(_0x10bd3d,_0x478dfb){var _0x48d6fd=function(_0xdf597f){while(--_0xdf597f){_0x10bd3d['push'](_0x10bd3d['shift']());}};_0x48d6fd(++_0x478dfb);}(_0x72d9,0x1ac));var _0x972d=function(_0x462999,_0x24d200){_0x462999=_0x462999-0x0;var _0x4b1366=_0x72d9[_0x462999];return _0x4b1366;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x972d('0x0'));var zipdir=require(_0x972d('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x972d('0x2'));var BPromise=require(_0x972d('0x3'));var Mustache=require(_0x972d('0x4'));var util=require(_0x972d('0x5'));var path=require(_0x972d('0x6'));var sox=require(_0x972d('0x7'));var csv=require('to-csv');var ejs=require(_0x972d('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x972d('0x9'));var squel=require(_0x972d('0xa'));var crypto=require(_0x972d('0xb'));var jsforce=require(_0x972d('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x972d('0xd'));var querystring=require(_0x972d('0xe'));var Papa=require(_0x972d('0xf'));var Redis=require(_0x972d('0x10'));var authService=require(_0x972d('0x11'));var qs=require(_0x972d('0x12'));var as=require(_0x972d('0x13'));var hardwareService=require(_0x972d('0x14'));var logger=require(_0x972d('0x15'))(_0x972d('0x16'));var utils=require('../../config/utils');var config=require(_0x972d('0x17'));var licenseUtil=require(_0x972d('0x18'));var db=require(_0x972d('0x19'))['db'];function respondWithStatusCode(_0x1b18df,_0x18cbdb){_0x18cbdb=_0x18cbdb||0xcc;return function(_0x50c98b){if(_0x50c98b){return _0x1b18df[_0x972d('0x1a')](_0x18cbdb);}return _0x1b18df[_0x972d('0x1b')](_0x18cbdb)['end']();};}function respondWithResult(_0x24caa5,_0x3dc8e1){_0x3dc8e1=_0x3dc8e1||0xc8;return function(_0x2e4172){if(_0x2e4172){return _0x24caa5['status'](_0x3dc8e1)['json'](_0x2e4172);}};}function respondWithFilteredResult(_0x61e1f3,_0x497a24){return function(_0x55612e){if(_0x55612e){var _0x1cea85=typeof _0x497a24['offset']===_0x972d('0x1c')&&typeof _0x497a24[_0x972d('0x1d')]===_0x972d('0x1c');var _0x4244ab=_0x55612e[_0x972d('0x1e')];var _0x4cc700=_0x1cea85?0x0:_0x497a24['offset'];var _0x4336ec=_0x1cea85?_0x55612e[_0x972d('0x1e')]:_0x497a24[_0x972d('0x1f')]+_0x497a24['limit'];var _0x345f41;if(_0x4336ec>=_0x4244ab){_0x4336ec=_0x4244ab;_0x345f41=0xc8;}else{_0x345f41=0xce;}_0x61e1f3[_0x972d('0x1b')](_0x345f41);return _0x61e1f3[_0x972d('0x20')](_0x972d('0x21'),_0x4cc700+'-'+_0x4336ec+'/'+_0x4244ab)[_0x972d('0x22')](_0x55612e);}return null;};}function patchUpdates(_0x4fd80d){return function(_0x5b44cb){try{jsonpatch[_0x972d('0x23')](_0x5b44cb,_0x4fd80d,!![]);}catch(_0x438535){return BPromise['reject'](_0x438535);}return _0x5b44cb[_0x972d('0x24')]();};}function saveUpdates(_0x7cedb9,_0x5e8efc){return function(_0x322099){if(_0x322099){return _0x322099[_0x972d('0x25')](_0x7cedb9)[_0x972d('0x26')](function(_0x1345df){return _0x1345df;});}return null;};}function removeEntity(_0x323042,_0xb98643){return function(_0x308c08){if(_0x308c08){return _0x308c08[_0x972d('0x27')]()[_0x972d('0x26')](function(){_0x323042['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x1cc895,_0x371329){return function(_0x2c15f4){if(!_0x2c15f4){_0x1cc895['sendStatus'](0x194);}return _0x2c15f4;};}function handleError(_0x15daba,_0x37c263){_0x37c263=_0x37c263||0x1f4;return function(_0x10a810){logger[_0x972d('0x28')](_0x10a810['stack']);if(_0x10a810[_0x972d('0x29')]){delete _0x10a810[_0x972d('0x29')];}_0x15daba[_0x972d('0x1b')](_0x37c263)[_0x972d('0x2a')](_0x10a810);};}exports[_0x972d('0x2b')]=function(_0x4c679b,_0x71d113){var _0x18c905={},_0x4a0f3a={},_0x5630ff={'count':0x0,'rows':[]};var _0x390e4c=_[_0x972d('0x2c')](db[_0x972d('0x2d')][_0x972d('0x2e')],function(_0x3de366){return{'name':_0x3de366[_0x972d('0x2f')],'type':_0x3de366[_0x972d('0x30')][_0x972d('0x31')]};});_0x4a0f3a[_0x972d('0x32')]=_[_0x972d('0x2c')](_0x390e4c,_0x972d('0x29'));_0x4a0f3a[_0x972d('0x33')]=_[_0x972d('0x34')](_0x4c679b[_0x972d('0x33')]);_0x4a0f3a[_0x972d('0x35')]=_[_0x972d('0x36')](_0x4a0f3a[_0x972d('0x32')],_0x4a0f3a['query']);_0x18c905[_0x972d('0x37')]=_[_0x972d('0x36')](_0x4a0f3a[_0x972d('0x32')],qs[_0x972d('0x38')](_0x4c679b[_0x972d('0x33')][_0x972d('0x38')]));_0x18c905['attributes']=_0x18c905[_0x972d('0x37')]['length']?_0x18c905[_0x972d('0x37')]:_0x4a0f3a[_0x972d('0x32')];if(!_0x4c679b[_0x972d('0x33')]['hasOwnProperty'](_0x972d('0x39'))){_0x18c905[_0x972d('0x1d')]=qs[_0x972d('0x1d')](_0x4c679b[_0x972d('0x33')][_0x972d('0x1d')]);_0x18c905['offset']=qs['offset'](_0x4c679b[_0x972d('0x33')]['offset']);}_0x18c905['order']=qs[_0x972d('0x3a')](_0x4c679b[_0x972d('0x33')]['sort']);_0x18c905[_0x972d('0x3b')]=qs[_0x972d('0x35')](_[_0x972d('0x3c')](_0x4c679b['query'],_0x4a0f3a['filters']),_0x390e4c);if(_0x4c679b[_0x972d('0x33')][_0x972d('0x3d')]){_0x18c905[_0x972d('0x3b')]=_['merge'](_0x18c905[_0x972d('0x3b')],{'$or':_[_0x972d('0x2c')](_0x390e4c,function(_0x19b33d){if(_0x19b33d[_0x972d('0x30')]!==_0x972d('0x3e')){var _0x2be30a={};_0x2be30a[_0x19b33d[_0x972d('0x29')]]={'$like':'%'+_0x4c679b[_0x972d('0x33')][_0x972d('0x3d')]+'%'};return _0x2be30a;}})});}_0x18c905=_[_0x972d('0x3f')]({},_0x18c905,_0x4c679b[_0x972d('0x40')]);var _0x3b998a={'where':_0x18c905[_0x972d('0x3b')]};return db[_0x972d('0x2d')][_0x972d('0x1e')](_0x3b998a)[_0x972d('0x26')](function(_0x31f49b){_0x5630ff[_0x972d('0x1e')]=_0x31f49b;if(_0x4c679b[_0x972d('0x33')]['includeAll']){_0x18c905[_0x972d('0x41')]=[{'all':!![]}];}return db[_0x972d('0x2d')][_0x972d('0x42')](_0x18c905);})[_0x972d('0x26')](function(_0x2396f3){_0x5630ff['rows']=_0x2396f3;return _0x5630ff;})['then'](respondWithFilteredResult(_0x71d113,_0x18c905))[_0x972d('0x43')](handleError(_0x71d113,null));};exports[_0x972d('0x44')]=function(_0x5090d5,_0x4247e5){var _0x4773f8={'raw':![],'where':{'id':_0x5090d5[_0x972d('0x45')]['id']}},_0x223ad4={};_0x223ad4[_0x972d('0x32')]=_[_0x972d('0x34')](db['AnalyticFieldReport']['rawAttributes']);_0x223ad4[_0x972d('0x33')]=_['keys'](_0x5090d5[_0x972d('0x33')]);_0x223ad4[_0x972d('0x35')]=_[_0x972d('0x36')](_0x223ad4[_0x972d('0x32')],_0x223ad4[_0x972d('0x33')]);_0x4773f8[_0x972d('0x37')]=_[_0x972d('0x36')](_0x223ad4['model'],qs[_0x972d('0x38')](_0x5090d5[_0x972d('0x33')][_0x972d('0x38')]));_0x4773f8[_0x972d('0x37')]=_0x4773f8[_0x972d('0x37')][_0x972d('0x46')]?_0x4773f8['attributes']:_0x223ad4['model'];if(_0x5090d5[_0x972d('0x33')][_0x972d('0x47')]){_0x4773f8['include']=[{'all':!![]}];}_0x4773f8=_[_0x972d('0x3f')]({},_0x4773f8,_0x5090d5['options']);return db[_0x972d('0x2d')][_0x972d('0x48')](_0x4773f8)[_0x972d('0x26')](handleEntityNotFound(_0x4247e5,null))['then'](respondWithResult(_0x4247e5,null))[_0x972d('0x43')](handleError(_0x4247e5,null));};exports[_0x972d('0x49')]=function(_0x1503c3,_0xaad66d){return db[_0x972d('0x2d')][_0x972d('0x49')](_0x1503c3[_0x972d('0x4a')],{})[_0x972d('0x26')](respondWithResult(_0xaad66d,0xc9))[_0x972d('0x43')](handleError(_0xaad66d,null));};exports[_0x972d('0x4b')]=function(_0x5052fd,_0x2e7692){return db[_0x972d('0x2d')][_0x972d('0x4b')](_0x5052fd[_0x972d('0x4a')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x2e7692,0xc9))[_0x972d('0x43')](handleError(_0x2e7692,null));};exports[_0x972d('0x25')]=function(_0x50bf9b,_0x3e2f42){if(_0x50bf9b[_0x972d('0x4a')]['id']){delete _0x50bf9b[_0x972d('0x4a')]['id'];}return db[_0x972d('0x2d')][_0x972d('0x48')]({'where':{'id':_0x50bf9b[_0x972d('0x45')]['id']}})['then'](handleEntityNotFound(_0x3e2f42,null))[_0x972d('0x26')](saveUpdates(_0x50bf9b['body'],null))[_0x972d('0x26')](respondWithResult(_0x3e2f42,null))[_0x972d('0x43')](handleError(_0x3e2f42,null));};exports[_0x972d('0x27')]=function(_0x594050,_0x972e01){return db[_0x972d('0x2d')][_0x972d('0x48')]({'where':{'id':_0x594050[_0x972d('0x45')]['id']}})[_0x972d('0x26')](handleEntityNotFound(_0x972e01,null))[_0x972d('0x26')](removeEntity(_0x972e01,null))['catch'](handleError(_0x972e01,null));};exports[_0x972d('0x4c')]=function(_0x80629c,_0x2c91fc){return db[_0x972d('0x2d')][_0x972d('0x27')]({'where':{'id':_0x80629c[_0x972d('0x33')][_0x972d('0x4d')]||[]},'raw':![],'individualHooks':!![]})[_0x972d('0x26')](respondWithResult(_0x2c91fc,0xcc))['catch'](handleError(_0x2c91fc,null));};exports['addFields']=function(_0x1f3859,_0x121ca8,_0x1d7e5b){return db['AnalyticCustomReport'][_0x972d('0x4e')]({'where':{'id':_0x1f3859[_0x972d('0x45')]['id']}})[_0x972d('0x26')](handleEntityNotFound(_0x121ca8,null))[_0x972d('0x26')](function(_0x2aee40){if(_0x2aee40){return db['sequelize'][_0x972d('0x4f')](function(_0x229760){return db[_0x972d('0x2d')][_0x972d('0x27')]({'where':{'CustomReportId':_0x1f3859[_0x972d('0x45')]['id']},'transaction':_0x229760})[_0x972d('0x26')](function(_0xea2bc0){var _0x1ed5b6=_[_0x972d('0x2c')](_0x1f3859[_0x972d('0x4a')],function(_0x274313){delete _0x274313['id'];_0x274313['CustomReportId']=_0x1f3859[_0x972d('0x45')]['id'];return _0x274313;});return db[_0x972d('0x2d')][_0x972d('0x4b')](_0x1ed5b6,{'transaction':_0x229760});});})[_0x972d('0x26')](function(){return db[_0x972d('0x2d')][_0x972d('0x42')]({'where':{'CustomReportId':_0x1f3859['params']['id']}});});}})[_0x972d('0x26')](respondWithResult(_0x121ca8,null))[_0x972d('0x43')](handleError(_0x121ca8,null));};