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 _0x9530=['query','keys','filters','model','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','VIRTUAL','filter','merge','options','AnalyticFieldReport','includeAll','include','findAll','rows','show','params','intersection','find','create','body','catch','bulkCreate','destroy','bulkDestroy','ids','addFields','AnalyticCustomReport','findOne','sequelize','transaction','CustomReportId','eml-format','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','status','end','offset','undefined','limit','count','set','Content-Range','json','update','then','error','stack','name','send','map','rawAttributes','fieldName','type','key'];(function(_0x321bb2,_0x202794){var _0x9c12ed=function(_0x263dd3){while(--_0x263dd3){_0x321bb2['push'](_0x321bb2['shift']());}};_0x9c12ed(++_0x202794);}(_0x9530,0x1d5));var _0x0953=function(_0x502ac8,_0x4def23){_0x502ac8=_0x502ac8-0x0;var _0x40bbb1=_0x9530[_0x502ac8];return _0x40bbb1;};'use strict';var emlformat=require(_0x0953('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x0953('0x1'));var jsonpatch=require(_0x0953('0x2'));var rp=require(_0x0953('0x3'));var moment=require('moment');var BPromise=require(_0x0953('0x4'));var Mustache=require(_0x0953('0x5'));var util=require(_0x0953('0x6'));var path=require(_0x0953('0x7'));var sox=require(_0x0953('0x8'));var csv=require(_0x0953('0x9'));var ejs=require(_0x0953('0xa'));var fs=require('fs');var fs_extra=require(_0x0953('0xb'));var _=require(_0x0953('0xc'));var squel=require(_0x0953('0xd'));var crypto=require(_0x0953('0xe'));var jsforce=require(_0x0953('0xf'));var deskjs=require(_0x0953('0x10'));var toCsv=require(_0x0953('0x9'));var querystring=require(_0x0953('0x11'));var Papa=require(_0x0953('0x12'));var Redis=require(_0x0953('0x13'));var authService=require(_0x0953('0x14'));var qs=require(_0x0953('0x15'));var as=require(_0x0953('0x16'));var hardwareService=require(_0x0953('0x17'));var logger=require(_0x0953('0x18'))('api');var utils=require('../../config/utils');var config=require(_0x0953('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0x0953('0x1a'))['db'];function respondWithStatusCode(_0x1666a0,_0x18e417){_0x18e417=_0x18e417||0xcc;return function(_0x2ff5f6){if(_0x2ff5f6){return _0x1666a0['sendStatus'](_0x18e417);}return _0x1666a0[_0x0953('0x1b')](_0x18e417)[_0x0953('0x1c')]();};}function respondWithResult(_0x43411c,_0x147680){_0x147680=_0x147680||0xc8;return function(_0x276673){if(_0x276673){return _0x43411c[_0x0953('0x1b')](_0x147680)['json'](_0x276673);}};}function respondWithFilteredResult(_0xfd45ae,_0x5e9309){return function(_0x4aaced){if(_0x4aaced){var _0x42af19=typeof _0x5e9309[_0x0953('0x1d')]===_0x0953('0x1e')&&typeof _0x5e9309[_0x0953('0x1f')]===_0x0953('0x1e');var _0x30deb9=_0x4aaced[_0x0953('0x20')];var _0x2940b0=_0x42af19?0x0:_0x5e9309[_0x0953('0x1d')];var _0x1e67fa=_0x42af19?_0x4aaced[_0x0953('0x20')]:_0x5e9309[_0x0953('0x1d')]+_0x5e9309[_0x0953('0x1f')];var _0x30abfc;if(_0x1e67fa>=_0x30deb9){_0x1e67fa=_0x30deb9;_0x30abfc=0xc8;}else{_0x30abfc=0xce;}_0xfd45ae[_0x0953('0x1b')](_0x30abfc);return _0xfd45ae[_0x0953('0x21')](_0x0953('0x22'),_0x2940b0+'-'+_0x1e67fa+'/'+_0x30deb9)[_0x0953('0x23')](_0x4aaced);}return null;};}function patchUpdates(_0x564d52){return function(_0x1764da){try{jsonpatch['apply'](_0x1764da,_0x564d52,!![]);}catch(_0xe666b8){return BPromise['reject'](_0xe666b8);}return _0x1764da['save']();};}function saveUpdates(_0x48da5f,_0x135136){return function(_0x322c42){if(_0x322c42){return _0x322c42[_0x0953('0x24')](_0x48da5f)[_0x0953('0x25')](function(_0x2e685c){return _0x2e685c;});}return null;};}function removeEntity(_0x3e59c2,_0x78b2be){return function(_0x354a8b){if(_0x354a8b){return _0x354a8b['destroy']()[_0x0953('0x25')](function(){_0x3e59c2[_0x0953('0x1b')](0xcc)[_0x0953('0x1c')]();});}};}function handleEntityNotFound(_0x1227e9,_0x53ef7d){return function(_0x27726f){if(!_0x27726f){_0x1227e9['sendStatus'](0x194);}return _0x27726f;};}function handleError(_0x48d17b,_0x330fcc){_0x330fcc=_0x330fcc||0x1f4;return function(_0x310301){logger[_0x0953('0x26')](_0x310301[_0x0953('0x27')]);if(_0x310301[_0x0953('0x28')]){delete _0x310301['name'];}_0x48d17b[_0x0953('0x1b')](_0x330fcc)[_0x0953('0x29')](_0x310301);};}exports['index']=function(_0x5391bd,_0x3e09b6){var _0x1dd448={},_0x5a352c={},_0x30c1ca={'count':0x0,'rows':[]};var _0x4b6737=_[_0x0953('0x2a')](db['AnalyticFieldReport'][_0x0953('0x2b')],function(_0x4e2f41){return{'name':_0x4e2f41[_0x0953('0x2c')],'type':_0x4e2f41[_0x0953('0x2d')][_0x0953('0x2e')]};});_0x5a352c['model']=_[_0x0953('0x2a')](_0x4b6737,_0x0953('0x28'));_0x5a352c[_0x0953('0x2f')]=_[_0x0953('0x30')](_0x5391bd[_0x0953('0x2f')]);_0x5a352c[_0x0953('0x31')]=_['intersection'](_0x5a352c[_0x0953('0x32')],_0x5a352c['query']);_0x1dd448['attributes']=_['intersection'](_0x5a352c[_0x0953('0x32')],qs[_0x0953('0x33')](_0x5391bd[_0x0953('0x2f')][_0x0953('0x33')]));_0x1dd448[_0x0953('0x34')]=_0x1dd448[_0x0953('0x34')][_0x0953('0x35')]?_0x1dd448[_0x0953('0x34')]:_0x5a352c[_0x0953('0x32')];if(!_0x5391bd['query'][_0x0953('0x36')](_0x0953('0x37'))){_0x1dd448[_0x0953('0x1f')]=qs[_0x0953('0x1f')](_0x5391bd['query'][_0x0953('0x1f')]);_0x1dd448['offset']=qs[_0x0953('0x1d')](_0x5391bd[_0x0953('0x2f')]['offset']);}_0x1dd448[_0x0953('0x38')]=qs['sort'](_0x5391bd[_0x0953('0x2f')][_0x0953('0x39')]);_0x1dd448[_0x0953('0x3a')]=qs[_0x0953('0x31')](_[_0x0953('0x3b')](_0x5391bd['query'],_0x5a352c['filters']),_0x4b6737);if(_0x5391bd[_0x0953('0x2f')]['filter']){_0x1dd448[_0x0953('0x3a')]=_['merge'](_0x1dd448[_0x0953('0x3a')],{'$or':_['map'](_0x4b6737,function(_0x458b39){if(_0x458b39[_0x0953('0x2d')]!==_0x0953('0x3c')){var _0x3fb589={};_0x3fb589[_0x458b39['name']]={'$like':'%'+_0x5391bd[_0x0953('0x2f')][_0x0953('0x3d')]+'%'};return _0x3fb589;}})});}_0x1dd448=_[_0x0953('0x3e')]({},_0x1dd448,_0x5391bd[_0x0953('0x3f')]);var _0x2a837a={'where':_0x1dd448[_0x0953('0x3a')]};return db[_0x0953('0x40')]['count'](_0x2a837a)[_0x0953('0x25')](function(_0x2271b7){_0x30c1ca[_0x0953('0x20')]=_0x2271b7;if(_0x5391bd[_0x0953('0x2f')][_0x0953('0x41')]){_0x1dd448[_0x0953('0x42')]=[{'all':!![]}];}return db[_0x0953('0x40')][_0x0953('0x43')](_0x1dd448);})[_0x0953('0x25')](function(_0x56bfb1){_0x30c1ca[_0x0953('0x44')]=_0x56bfb1;return _0x30c1ca;})[_0x0953('0x25')](respondWithFilteredResult(_0x3e09b6,_0x1dd448))['catch'](handleError(_0x3e09b6,null));};exports[_0x0953('0x45')]=function(_0x30139b,_0x52d200){var _0x2e2570={'raw':![],'where':{'id':_0x30139b[_0x0953('0x46')]['id']}},_0xb8c82a={};_0xb8c82a[_0x0953('0x32')]=_['keys'](db[_0x0953('0x40')]['rawAttributes']);_0xb8c82a['query']=_['keys'](_0x30139b[_0x0953('0x2f')]);_0xb8c82a[_0x0953('0x31')]=_[_0x0953('0x47')](_0xb8c82a['model'],_0xb8c82a[_0x0953('0x2f')]);_0x2e2570[_0x0953('0x34')]=_[_0x0953('0x47')](_0xb8c82a[_0x0953('0x32')],qs[_0x0953('0x33')](_0x30139b[_0x0953('0x2f')][_0x0953('0x33')]));_0x2e2570[_0x0953('0x34')]=_0x2e2570[_0x0953('0x34')][_0x0953('0x35')]?_0x2e2570['attributes']:_0xb8c82a[_0x0953('0x32')];if(_0x30139b[_0x0953('0x2f')][_0x0953('0x41')]){_0x2e2570[_0x0953('0x42')]=[{'all':!![]}];}_0x2e2570=_[_0x0953('0x3e')]({},_0x2e2570,_0x30139b[_0x0953('0x3f')]);return db[_0x0953('0x40')][_0x0953('0x48')](_0x2e2570)[_0x0953('0x25')](handleEntityNotFound(_0x52d200,null))[_0x0953('0x25')](respondWithResult(_0x52d200,null))['catch'](handleError(_0x52d200,null));};exports[_0x0953('0x49')]=function(_0xd7aeb8,_0x3563b3){return db[_0x0953('0x40')][_0x0953('0x49')](_0xd7aeb8[_0x0953('0x4a')],{})[_0x0953('0x25')](respondWithResult(_0x3563b3,0xc9))[_0x0953('0x4b')](handleError(_0x3563b3,null));};exports['bulkCreate']=function(_0x1e4128,_0x585cd0){return db['AnalyticFieldReport'][_0x0953('0x4c')](_0x1e4128[_0x0953('0x4a')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x585cd0,0xc9))[_0x0953('0x4b')](handleError(_0x585cd0,null));};exports['update']=function(_0x6ec40c,_0x5b2b4c){if(_0x6ec40c['body']['id']){delete _0x6ec40c[_0x0953('0x4a')]['id'];}return db[_0x0953('0x40')][_0x0953('0x48')]({'where':{'id':_0x6ec40c[_0x0953('0x46')]['id']}})[_0x0953('0x25')](handleEntityNotFound(_0x5b2b4c,null))['then'](saveUpdates(_0x6ec40c['body'],null))['then'](respondWithResult(_0x5b2b4c,null))['catch'](handleError(_0x5b2b4c,null));};exports[_0x0953('0x4d')]=function(_0x52fe65,_0x16a00c){return db[_0x0953('0x40')]['find']({'where':{'id':_0x52fe65[_0x0953('0x46')]['id']}})[_0x0953('0x25')](handleEntityNotFound(_0x16a00c,null))['then'](removeEntity(_0x16a00c,null))[_0x0953('0x4b')](handleError(_0x16a00c,null));};exports[_0x0953('0x4e')]=function(_0x32c5e5,_0x59e430){return db[_0x0953('0x40')][_0x0953('0x4d')]({'where':{'id':_0x32c5e5[_0x0953('0x2f')][_0x0953('0x4f')]||[]},'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x59e430,0xcc))[_0x0953('0x4b')](handleError(_0x59e430,null));};exports[_0x0953('0x50')]=function(_0x331d05,_0x2274f8,_0x4c0c3f){return db[_0x0953('0x51')][_0x0953('0x52')]({'where':{'id':_0x331d05[_0x0953('0x46')]['id']}})[_0x0953('0x25')](handleEntityNotFound(_0x2274f8,null))[_0x0953('0x25')](function(_0x3babeb){if(_0x3babeb){return db[_0x0953('0x53')][_0x0953('0x54')](function(_0x9cb9de){return db[_0x0953('0x40')][_0x0953('0x4d')]({'where':{'CustomReportId':_0x331d05[_0x0953('0x46')]['id']},'transaction':_0x9cb9de})[_0x0953('0x25')](function(_0xdf559f){var _0x29657d=_[_0x0953('0x2a')](_0x331d05[_0x0953('0x4a')],function(_0x4d9c71){delete _0x4d9c71['id'];_0x4d9c71[_0x0953('0x55')]=_0x331d05[_0x0953('0x46')]['id'];return _0x4d9c71;});return db[_0x0953('0x40')][_0x0953('0x4c')](_0x29657d,{'transaction':_0x9cb9de});});})[_0x0953('0x25')](function(){return db['AnalyticFieldReport'][_0x0953('0x43')]({'where':{'CustomReportId':_0x331d05[_0x0953('0x46')]['id']}});});}})[_0x0953('0x25')](respondWithResult(_0x2274f8,null))['catch'](handleError(_0x2274f8,null));};