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 _0x5141=['fieldName','key','model','keys','query','intersection','fields','attributes','length','hasOwnProperty','order','sort','where','filters','merge','map','type','filter','options','includeAll','include','findAll','rows','catch','params','find','create','body','bulkCreate','update','ids','addFields','AnalyticCustomReport','findOne','sequelize','transaction','CustomReportId','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','undefined','limit','count','apply','then','destroy','error','name','send','index','AnalyticFieldReport','rawAttributes'];(function(_0x53e8ab,_0x46a20a){var _0x5c58fb=function(_0x1eaa03){while(--_0x1eaa03){_0x53e8ab['push'](_0x53e8ab['shift']());}};_0x5c58fb(++_0x46a20a);}(_0x5141,0xc5));var _0x1514=function(_0x729980,_0x30010f){_0x729980=_0x729980-0x0;var _0x14138=_0x5141[_0x729980];return _0x14138;};'use strict';var emlformat=require(_0x1514('0x0'));var rimraf=require(_0x1514('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x1514('0x2'));var rp=require(_0x1514('0x3'));var moment=require(_0x1514('0x4'));var BPromise=require(_0x1514('0x5'));var Mustache=require(_0x1514('0x6'));var util=require('util');var path=require('path');var sox=require(_0x1514('0x7'));var csv=require(_0x1514('0x8'));var ejs=require(_0x1514('0x9'));var fs=require('fs');var fs_extra=require(_0x1514('0xa'));var _=require(_0x1514('0xb'));var squel=require(_0x1514('0xc'));var crypto=require(_0x1514('0xd'));var jsforce=require(_0x1514('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x1514('0x8'));var querystring=require(_0x1514('0xf'));var Papa=require(_0x1514('0x10'));var Redis=require(_0x1514('0x11'));var authService=require(_0x1514('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x1514('0x13'));var hardwareService=require(_0x1514('0x14'));var logger=require(_0x1514('0x15'))(_0x1514('0x16'));var utils=require(_0x1514('0x17'));var config=require(_0x1514('0x18'));var licenseUtil=require(_0x1514('0x19'));var db=require(_0x1514('0x1a'))['db'];function respondWithStatusCode(_0x24c962,_0x465bda){_0x465bda=_0x465bda||0xcc;return function(_0x5a3dcb){if(_0x5a3dcb){return _0x24c962[_0x1514('0x1b')](_0x465bda);}return _0x24c962[_0x1514('0x1c')](_0x465bda)[_0x1514('0x1d')]();};}function respondWithResult(_0x249078,_0x374347){_0x374347=_0x374347||0xc8;return function(_0x185f1a){if(_0x185f1a){return _0x249078['status'](_0x374347)['json'](_0x185f1a);}};}function respondWithFilteredResult(_0x5a9871,_0x4bb835){return function(_0x1e6e60){if(_0x1e6e60){var _0x5a06a7=typeof _0x4bb835[_0x1514('0x1e')]===_0x1514('0x1f')&&typeof _0x4bb835[_0x1514('0x20')]==='undefined';var _0x45aec4=_0x1e6e60['count'];var _0xbec769=_0x5a06a7?0x0:_0x4bb835['offset'];var _0x20445d=_0x5a06a7?_0x1e6e60[_0x1514('0x21')]:_0x4bb835[_0x1514('0x1e')]+_0x4bb835[_0x1514('0x20')];var _0x13b481;if(_0x20445d>=_0x45aec4){_0x20445d=_0x45aec4;_0x13b481=0xc8;}else{_0x13b481=0xce;}_0x5a9871['status'](_0x13b481);return _0x5a9871['set']('Content-Range',_0xbec769+'-'+_0x20445d+'/'+_0x45aec4)['json'](_0x1e6e60);}return null;};}function patchUpdates(_0x406fb4){return function(_0xdaa790){try{jsonpatch[_0x1514('0x22')](_0xdaa790,_0x406fb4,!![]);}catch(_0x4e404d){return BPromise['reject'](_0x4e404d);}return _0xdaa790['save']();};}function saveUpdates(_0x596f50,_0x54f726){return function(_0xa78976){if(_0xa78976){return _0xa78976['update'](_0x596f50)[_0x1514('0x23')](function(_0x27d76b){return _0x27d76b;});}return null;};}function removeEntity(_0x47305d,_0x165b27){return function(_0x3a5246){if(_0x3a5246){return _0x3a5246[_0x1514('0x24')]()['then'](function(){_0x47305d['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x2b2bf1,_0x431878){return function(_0x13b302){if(!_0x13b302){_0x2b2bf1['sendStatus'](0x194);}return _0x13b302;};}function handleError(_0x18962f,_0x1822bf){_0x1822bf=_0x1822bf||0x1f4;return function(_0x2567bd){logger[_0x1514('0x25')](_0x2567bd['stack']);if(_0x2567bd[_0x1514('0x26')]){delete _0x2567bd[_0x1514('0x26')];}_0x18962f[_0x1514('0x1c')](_0x1822bf)[_0x1514('0x27')](_0x2567bd);};}exports[_0x1514('0x28')]=function(_0x263ee9,_0x49ba1b){var _0x2a08ab={},_0x2a625d={},_0x508ab5={'count':0x0,'rows':[]};var _0x1b5a45=_['map'](db[_0x1514('0x29')][_0x1514('0x2a')],function(_0x466289){return{'name':_0x466289[_0x1514('0x2b')],'type':_0x466289['type'][_0x1514('0x2c')]};});_0x2a625d[_0x1514('0x2d')]=_['map'](_0x1b5a45,'name');_0x2a625d['query']=_[_0x1514('0x2e')](_0x263ee9[_0x1514('0x2f')]);_0x2a625d['filters']=_[_0x1514('0x30')](_0x2a625d[_0x1514('0x2d')],_0x2a625d[_0x1514('0x2f')]);_0x2a08ab['attributes']=_[_0x1514('0x30')](_0x2a625d[_0x1514('0x2d')],qs[_0x1514('0x31')](_0x263ee9[_0x1514('0x2f')][_0x1514('0x31')]));_0x2a08ab[_0x1514('0x32')]=_0x2a08ab[_0x1514('0x32')][_0x1514('0x33')]?_0x2a08ab[_0x1514('0x32')]:_0x2a625d[_0x1514('0x2d')];if(!_0x263ee9['query'][_0x1514('0x34')]('nolimit')){_0x2a08ab[_0x1514('0x20')]=qs[_0x1514('0x20')](_0x263ee9['query'][_0x1514('0x20')]);_0x2a08ab[_0x1514('0x1e')]=qs[_0x1514('0x1e')](_0x263ee9[_0x1514('0x2f')]['offset']);}_0x2a08ab[_0x1514('0x35')]=qs[_0x1514('0x36')](_0x263ee9[_0x1514('0x2f')]['sort']);_0x2a08ab[_0x1514('0x37')]=qs[_0x1514('0x38')](_['pick'](_0x263ee9['query'],_0x2a625d[_0x1514('0x38')]),_0x1b5a45);if(_0x263ee9[_0x1514('0x2f')]['filter']){_0x2a08ab['where']=_[_0x1514('0x39')](_0x2a08ab['where'],{'$or':_[_0x1514('0x3a')](_0x1b5a45,function(_0x44a936){if(_0x44a936[_0x1514('0x3b')]!=='VIRTUAL'){var _0x3cab2c={};_0x3cab2c[_0x44a936[_0x1514('0x26')]]={'$like':'%'+_0x263ee9[_0x1514('0x2f')][_0x1514('0x3c')]+'%'};return _0x3cab2c;}})});}_0x2a08ab=_[_0x1514('0x39')]({},_0x2a08ab,_0x263ee9[_0x1514('0x3d')]);var _0x5ecaf8={'where':_0x2a08ab[_0x1514('0x37')]};return db[_0x1514('0x29')][_0x1514('0x21')](_0x5ecaf8)[_0x1514('0x23')](function(_0x2be658){_0x508ab5[_0x1514('0x21')]=_0x2be658;if(_0x263ee9['query'][_0x1514('0x3e')]){_0x2a08ab[_0x1514('0x3f')]=[{'all':!![]}];}return db[_0x1514('0x29')][_0x1514('0x40')](_0x2a08ab);})[_0x1514('0x23')](function(_0x3ff5b7){_0x508ab5[_0x1514('0x41')]=_0x3ff5b7;return _0x508ab5;})[_0x1514('0x23')](respondWithFilteredResult(_0x49ba1b,_0x2a08ab))[_0x1514('0x42')](handleError(_0x49ba1b,null));};exports['show']=function(_0xa6f70,_0x2f2516){var _0x184e69={'raw':![],'where':{'id':_0xa6f70[_0x1514('0x43')]['id']}},_0x4305a3={};_0x4305a3['model']=_[_0x1514('0x2e')](db['AnalyticFieldReport'][_0x1514('0x2a')]);_0x4305a3[_0x1514('0x2f')]=_[_0x1514('0x2e')](_0xa6f70['query']);_0x4305a3[_0x1514('0x38')]=_[_0x1514('0x30')](_0x4305a3[_0x1514('0x2d')],_0x4305a3['query']);_0x184e69[_0x1514('0x32')]=_[_0x1514('0x30')](_0x4305a3[_0x1514('0x2d')],qs['fields'](_0xa6f70[_0x1514('0x2f')][_0x1514('0x31')]));_0x184e69[_0x1514('0x32')]=_0x184e69[_0x1514('0x32')][_0x1514('0x33')]?_0x184e69[_0x1514('0x32')]:_0x4305a3[_0x1514('0x2d')];if(_0xa6f70[_0x1514('0x2f')][_0x1514('0x3e')]){_0x184e69[_0x1514('0x3f')]=[{'all':!![]}];}_0x184e69=_[_0x1514('0x39')]({},_0x184e69,_0xa6f70['options']);return db[_0x1514('0x29')][_0x1514('0x44')](_0x184e69)['then'](handleEntityNotFound(_0x2f2516,null))['then'](respondWithResult(_0x2f2516,null))[_0x1514('0x42')](handleError(_0x2f2516,null));};exports[_0x1514('0x45')]=function(_0xd0960d,_0xb846ea){return db[_0x1514('0x29')][_0x1514('0x45')](_0xd0960d[_0x1514('0x46')],{})[_0x1514('0x23')](respondWithResult(_0xb846ea,0xc9))[_0x1514('0x42')](handleError(_0xb846ea,null));};exports[_0x1514('0x47')]=function(_0x55438f,_0x5b7884){return db['AnalyticFieldReport'][_0x1514('0x47')](_0x55438f[_0x1514('0x46')],{'raw':![],'individualHooks':!![]})[_0x1514('0x23')](respondWithResult(_0x5b7884,0xc9))['catch'](handleError(_0x5b7884,null));};exports[_0x1514('0x48')]=function(_0x303f71,_0x499e3a){if(_0x303f71[_0x1514('0x46')]['id']){delete _0x303f71[_0x1514('0x46')]['id'];}return db[_0x1514('0x29')][_0x1514('0x44')]({'where':{'id':_0x303f71[_0x1514('0x43')]['id']}})[_0x1514('0x23')](handleEntityNotFound(_0x499e3a,null))[_0x1514('0x23')](saveUpdates(_0x303f71['body'],null))[_0x1514('0x23')](respondWithResult(_0x499e3a,null))[_0x1514('0x42')](handleError(_0x499e3a,null));};exports[_0x1514('0x24')]=function(_0x47a513,_0x38fc17){return db[_0x1514('0x29')][_0x1514('0x44')]({'where':{'id':_0x47a513[_0x1514('0x43')]['id']}})[_0x1514('0x23')](handleEntityNotFound(_0x38fc17,null))[_0x1514('0x23')](removeEntity(_0x38fc17,null))[_0x1514('0x42')](handleError(_0x38fc17,null));};exports['bulkDestroy']=function(_0x391397,_0x1fcec7){return db[_0x1514('0x29')][_0x1514('0x24')]({'where':{'id':_0x391397[_0x1514('0x2f')][_0x1514('0x49')]||[]},'raw':![],'individualHooks':!![]})[_0x1514('0x23')](respondWithResult(_0x1fcec7,0xcc))['catch'](handleError(_0x1fcec7,null));};exports[_0x1514('0x4a')]=function(_0x39c2d9,_0x56273b,_0x3e2b1f){return db[_0x1514('0x4b')][_0x1514('0x4c')]({'where':{'id':_0x39c2d9[_0x1514('0x43')]['id']}})[_0x1514('0x23')](handleEntityNotFound(_0x56273b,null))['then'](function(_0x472588){if(_0x472588){return db[_0x1514('0x4d')][_0x1514('0x4e')](function(_0x455dd8){return db[_0x1514('0x29')]['destroy']({'where':{'CustomReportId':_0x39c2d9[_0x1514('0x43')]['id']},'transaction':_0x455dd8})[_0x1514('0x23')](function(_0x14c546){var _0x2ed3eb=_[_0x1514('0x3a')](_0x39c2d9[_0x1514('0x46')],function(_0x34f937){delete _0x34f937['id'];_0x34f937[_0x1514('0x4f')]=_0x39c2d9[_0x1514('0x43')]['id'];return _0x34f937;});return db[_0x1514('0x29')][_0x1514('0x47')](_0x2ed3eb,{'transaction':_0x455dd8});});})['then'](function(){return db[_0x1514('0x29')][_0x1514('0x40')]({'where':{'CustomReportId':_0x39c2d9[_0x1514('0x43')]['id']}});});}})[_0x1514('0x23')](respondWithResult(_0x56273b,null))['catch'](handleError(_0x56273b,null));};