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 _0xaa90=['desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','json','offset','limit','count','status','set','Content-Range','apply','reject','save','update','destroy','then','error','stack','name','index','map','AnalyticFieldReport','rawAttributes','type','key','model','query','keys','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','create','body','bulkCreate','find','ids','addFields','AnalyticCustomReport','sequelize','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','fs-extra','lodash','crypto','jsforce'];(function(_0xaad329,_0x842897){var _0x3c7540=function(_0x82b87){while(--_0x82b87){_0xaad329['push'](_0xaad329['shift']());}};_0x3c7540(++_0x842897);}(_0xaa90,0x96));var _0x0aa9=function(_0x208cce,_0x31fe39){_0x208cce=_0x208cce-0x0;var _0x300943=_0xaa90[_0x208cce];return _0x300943;};'use strict';var emlformat=require(_0x0aa9('0x0'));var rimraf=require(_0x0aa9('0x1'));var zipdir=require(_0x0aa9('0x2'));var jsonpatch=require(_0x0aa9('0x3'));var rp=require(_0x0aa9('0x4'));var moment=require(_0x0aa9('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x0aa9('0x6'));var util=require(_0x0aa9('0x7'));var path=require(_0x0aa9('0x8'));var sox=require('sox');var csv=require(_0x0aa9('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x0aa9('0xa'));var _=require(_0x0aa9('0xb'));var squel=require('squel');var crypto=require(_0x0aa9('0xc'));var jsforce=require(_0x0aa9('0xd'));var deskjs=require(_0x0aa9('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x0aa9('0xf'));var Redis=require(_0x0aa9('0x10'));var authService=require(_0x0aa9('0x11'));var qs=require(_0x0aa9('0x12'));var as=require(_0x0aa9('0x13'));var hardwareService=require(_0x0aa9('0x14'));var logger=require(_0x0aa9('0x15'))(_0x0aa9('0x16'));var utils=require('../../config/utils');var config=require(_0x0aa9('0x17'));var licenseUtil=require(_0x0aa9('0x18'));var db=require(_0x0aa9('0x19'))['db'];function respondWithStatusCode(_0x180a9c,_0xc57710){_0xc57710=_0xc57710||0xcc;return function(_0x287c99){if(_0x287c99){return _0x180a9c[_0x0aa9('0x1a')](_0xc57710);}return _0x180a9c['status'](_0xc57710)[_0x0aa9('0x1b')]();};}function respondWithResult(_0x174519,_0x4cf59f){_0x4cf59f=_0x4cf59f||0xc8;return function(_0x292811){if(_0x292811){return _0x174519['status'](_0x4cf59f)[_0x0aa9('0x1c')](_0x292811);}};}function respondWithFilteredResult(_0x55b427,_0x4171f2){return function(_0x4e2d46){if(_0x4e2d46){var _0x150443=typeof _0x4171f2[_0x0aa9('0x1d')]==='undefined'&&typeof _0x4171f2[_0x0aa9('0x1e')]==='undefined';var _0x22eabd=_0x4e2d46['count'];var _0x17a140=_0x150443?0x0:_0x4171f2['offset'];var _0x1fc321=_0x150443?_0x4e2d46[_0x0aa9('0x1f')]:_0x4171f2[_0x0aa9('0x1d')]+_0x4171f2[_0x0aa9('0x1e')];var _0x2713fc;if(_0x1fc321>=_0x22eabd){_0x1fc321=_0x22eabd;_0x2713fc=0xc8;}else{_0x2713fc=0xce;}_0x55b427[_0x0aa9('0x20')](_0x2713fc);return _0x55b427[_0x0aa9('0x21')](_0x0aa9('0x22'),_0x17a140+'-'+_0x1fc321+'/'+_0x22eabd)[_0x0aa9('0x1c')](_0x4e2d46);}return null;};}function patchUpdates(_0x85a7){return function(_0x466da5){try{jsonpatch[_0x0aa9('0x23')](_0x466da5,_0x85a7,!![]);}catch(_0x111870){return BPromise[_0x0aa9('0x24')](_0x111870);}return _0x466da5[_0x0aa9('0x25')]();};}function saveUpdates(_0x1f456b,_0x2388e1){return function(_0x5c7ab5){if(_0x5c7ab5){return _0x5c7ab5[_0x0aa9('0x26')](_0x1f456b)['then'](function(_0x4f82f0){return _0x4f82f0;});}return null;};}function removeEntity(_0x5c3657,_0x3dab14){return function(_0x3cb25a){if(_0x3cb25a){return _0x3cb25a[_0x0aa9('0x27')]()[_0x0aa9('0x28')](function(){_0x5c3657[_0x0aa9('0x20')](0xcc)[_0x0aa9('0x1b')]();});}};}function handleEntityNotFound(_0x198950,_0x561fe5){return function(_0x684e7b){if(!_0x684e7b){_0x198950[_0x0aa9('0x1a')](0x194);}return _0x684e7b;};}function handleError(_0x4ab14c,_0x11d550){_0x11d550=_0x11d550||0x1f4;return function(_0x26b93d){logger[_0x0aa9('0x29')](_0x26b93d[_0x0aa9('0x2a')]);if(_0x26b93d['name']){delete _0x26b93d[_0x0aa9('0x2b')];}_0x4ab14c['status'](_0x11d550)['send'](_0x26b93d);};}exports[_0x0aa9('0x2c')]=function(_0x3afaab,_0x1a3bae){var _0x3e9596={},_0x287495={},_0x5bd214={'count':0x0,'rows':[]};var _0x3afddb=_[_0x0aa9('0x2d')](db[_0x0aa9('0x2e')][_0x0aa9('0x2f')],function(_0x3020bd){return{'name':_0x3020bd['fieldName'],'type':_0x3020bd[_0x0aa9('0x30')][_0x0aa9('0x31')]};});_0x287495[_0x0aa9('0x32')]=_[_0x0aa9('0x2d')](_0x3afddb,_0x0aa9('0x2b'));_0x287495[_0x0aa9('0x33')]=_[_0x0aa9('0x34')](_0x3afaab['query']);_0x287495['filters']=_['intersection'](_0x287495[_0x0aa9('0x32')],_0x287495[_0x0aa9('0x33')]);_0x3e9596[_0x0aa9('0x35')]=_[_0x0aa9('0x36')](_0x287495[_0x0aa9('0x32')],qs[_0x0aa9('0x37')](_0x3afaab[_0x0aa9('0x33')][_0x0aa9('0x37')]));_0x3e9596[_0x0aa9('0x35')]=_0x3e9596[_0x0aa9('0x35')][_0x0aa9('0x38')]?_0x3e9596['attributes']:_0x287495[_0x0aa9('0x32')];if(!_0x3afaab[_0x0aa9('0x33')][_0x0aa9('0x39')](_0x0aa9('0x3a'))){_0x3e9596[_0x0aa9('0x1e')]=qs[_0x0aa9('0x1e')](_0x3afaab['query'][_0x0aa9('0x1e')]);_0x3e9596[_0x0aa9('0x1d')]=qs['offset'](_0x3afaab[_0x0aa9('0x33')][_0x0aa9('0x1d')]);}_0x3e9596[_0x0aa9('0x3b')]=qs['sort'](_0x3afaab[_0x0aa9('0x33')][_0x0aa9('0x3c')]);_0x3e9596[_0x0aa9('0x3d')]=qs[_0x0aa9('0x3e')](_[_0x0aa9('0x3f')](_0x3afaab['query'],_0x287495['filters']),_0x3afddb);if(_0x3afaab['query'][_0x0aa9('0x40')]){_0x3e9596['where']=_[_0x0aa9('0x41')](_0x3e9596['where'],{'$or':_[_0x0aa9('0x2d')](_0x3afddb,function(_0x4329a0){if(_0x4329a0[_0x0aa9('0x30')]!==_0x0aa9('0x42')){var _0x2d6110={};_0x2d6110[_0x4329a0[_0x0aa9('0x2b')]]={'$like':'%'+_0x3afaab[_0x0aa9('0x33')][_0x0aa9('0x40')]+'%'};return _0x2d6110;}})});}_0x3e9596=_[_0x0aa9('0x41')]({},_0x3e9596,_0x3afaab[_0x0aa9('0x43')]);var _0x238d17={'where':_0x3e9596[_0x0aa9('0x3d')]};return db[_0x0aa9('0x2e')][_0x0aa9('0x1f')](_0x238d17)[_0x0aa9('0x28')](function(_0x2f4615){_0x5bd214['count']=_0x2f4615;if(_0x3afaab[_0x0aa9('0x33')][_0x0aa9('0x44')]){_0x3e9596['include']=[{'all':!![]}];}return db[_0x0aa9('0x2e')][_0x0aa9('0x45')](_0x3e9596);})[_0x0aa9('0x28')](function(_0x542b72){_0x5bd214[_0x0aa9('0x46')]=_0x542b72;return _0x5bd214;})[_0x0aa9('0x28')](respondWithFilteredResult(_0x1a3bae,_0x3e9596))[_0x0aa9('0x47')](handleError(_0x1a3bae,null));};exports[_0x0aa9('0x48')]=function(_0x54c3c0,_0x5477e0){var _0x13b573={'raw':![],'where':{'id':_0x54c3c0[_0x0aa9('0x49')]['id']}},_0x3eeb53={};_0x3eeb53[_0x0aa9('0x32')]=_[_0x0aa9('0x34')](db[_0x0aa9('0x2e')][_0x0aa9('0x2f')]);_0x3eeb53['query']=_[_0x0aa9('0x34')](_0x54c3c0[_0x0aa9('0x33')]);_0x3eeb53[_0x0aa9('0x3e')]=_[_0x0aa9('0x36')](_0x3eeb53[_0x0aa9('0x32')],_0x3eeb53[_0x0aa9('0x33')]);_0x13b573[_0x0aa9('0x35')]=_[_0x0aa9('0x36')](_0x3eeb53[_0x0aa9('0x32')],qs[_0x0aa9('0x37')](_0x54c3c0[_0x0aa9('0x33')][_0x0aa9('0x37')]));_0x13b573[_0x0aa9('0x35')]=_0x13b573['attributes'][_0x0aa9('0x38')]?_0x13b573['attributes']:_0x3eeb53['model'];if(_0x54c3c0[_0x0aa9('0x33')][_0x0aa9('0x44')]){_0x13b573['include']=[{'all':!![]}];}_0x13b573=_[_0x0aa9('0x41')]({},_0x13b573,_0x54c3c0[_0x0aa9('0x43')]);return db[_0x0aa9('0x2e')]['find'](_0x13b573)['then'](handleEntityNotFound(_0x5477e0,null))[_0x0aa9('0x28')](respondWithResult(_0x5477e0,null))[_0x0aa9('0x47')](handleError(_0x5477e0,null));};exports[_0x0aa9('0x4a')]=function(_0x3455ab,_0x503f9c){return db[_0x0aa9('0x2e')][_0x0aa9('0x4a')](_0x3455ab[_0x0aa9('0x4b')],{})[_0x0aa9('0x28')](respondWithResult(_0x503f9c,0xc9))[_0x0aa9('0x47')](handleError(_0x503f9c,null));};exports[_0x0aa9('0x4c')]=function(_0x418007,_0x4ab1fe){return db[_0x0aa9('0x2e')][_0x0aa9('0x4c')](_0x418007[_0x0aa9('0x4b')],{'raw':![],'individualHooks':!![]})[_0x0aa9('0x28')](respondWithResult(_0x4ab1fe,0xc9))[_0x0aa9('0x47')](handleError(_0x4ab1fe,null));};exports['update']=function(_0x2450a6,_0x5c029d){if(_0x2450a6['body']['id']){delete _0x2450a6[_0x0aa9('0x4b')]['id'];}return db['AnalyticFieldReport'][_0x0aa9('0x4d')]({'where':{'id':_0x2450a6[_0x0aa9('0x49')]['id']}})['then'](handleEntityNotFound(_0x5c029d,null))['then'](saveUpdates(_0x2450a6[_0x0aa9('0x4b')],null))['then'](respondWithResult(_0x5c029d,null))[_0x0aa9('0x47')](handleError(_0x5c029d,null));};exports[_0x0aa9('0x27')]=function(_0x225616,_0x4e37de){return db[_0x0aa9('0x2e')][_0x0aa9('0x4d')]({'where':{'id':_0x225616[_0x0aa9('0x49')]['id']}})['then'](handleEntityNotFound(_0x4e37de,null))[_0x0aa9('0x28')](removeEntity(_0x4e37de,null))[_0x0aa9('0x47')](handleError(_0x4e37de,null));};exports['bulkDestroy']=function(_0x316119,_0x13471a){return db['AnalyticFieldReport']['destroy']({'where':{'id':_0x316119[_0x0aa9('0x33')][_0x0aa9('0x4e')]||[]},'raw':![],'individualHooks':!![]})[_0x0aa9('0x28')](respondWithResult(_0x13471a,0xcc))[_0x0aa9('0x47')](handleError(_0x13471a,null));};exports[_0x0aa9('0x4f')]=function(_0x30ad53,_0x290976,_0xb171bc){return db[_0x0aa9('0x50')]['findOne']({'where':{'id':_0x30ad53[_0x0aa9('0x49')]['id']}})[_0x0aa9('0x28')](handleEntityNotFound(_0x290976,null))[_0x0aa9('0x28')](function(_0x5864e0){if(_0x5864e0){return db[_0x0aa9('0x51')]['transaction'](function(_0x270d28){return db[_0x0aa9('0x2e')][_0x0aa9('0x27')]({'where':{'CustomReportId':_0x30ad53['params']['id']},'transaction':_0x270d28})['then'](function(_0x1c69c7){var _0x56a510=_['map'](_0x30ad53[_0x0aa9('0x4b')],function(_0x14a2c6){delete _0x14a2c6['id'];_0x14a2c6['CustomReportId']=_0x30ad53[_0x0aa9('0x49')]['id'];return _0x14a2c6;});return db[_0x0aa9('0x2e')][_0x0aa9('0x4c')](_0x56a510,{'transaction':_0x270d28});});})[_0x0aa9('0x28')](function(){return db[_0x0aa9('0x2e')]['findAll']({'where':{'CustomReportId':_0x30ad53[_0x0aa9('0x49')]['id']}});});}})[_0x0aa9('0x28')](respondWithResult(_0x290976,null))['catch'](handleError(_0x290976,null));};