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 _0x4223=['hasOwnProperty','nolimit','limit','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','rows','catch','show','params','rawAttributes','find','create','body','bulkCreate','update','ids','addFields','AnalyticCustomReport','findOne','sequelize','transaction','CustomReportId','findAll','eml-format','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','sox','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','Content-Range','apply','reject','save','then','destroy','error','name','send','index','map','AnalyticFieldReport','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length'];(function(_0x36ed48,_0x1ee0d4){var _0x51c63a=function(_0x2d0a40){while(--_0x2d0a40){_0x36ed48['push'](_0x36ed48['shift']());}};_0x51c63a(++_0x1ee0d4);}(_0x4223,0x71));var _0x3422=function(_0x5c9bed,_0x17fdd8){_0x5c9bed=_0x5c9bed-0x0;var _0x1c9971=_0x4223[_0x5c9bed];return _0x1c9971;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x3422('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x3422('0x1'));var jsonpatch=require(_0x3422('0x2'));var rp=require(_0x3422('0x3'));var moment=require('moment');var BPromise=require(_0x3422('0x4'));var Mustache=require(_0x3422('0x5'));var util=require(_0x3422('0x6'));var path=require('path');var sox=require(_0x3422('0x7'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x3422('0x8'));var squel=require(_0x3422('0x9'));var crypto=require(_0x3422('0xa'));var jsforce=require(_0x3422('0xb'));var deskjs=require(_0x3422('0xc'));var toCsv=require(_0x3422('0xd'));var querystring=require(_0x3422('0xe'));var Papa=require(_0x3422('0xf'));var Redis=require(_0x3422('0x10'));var authService=require(_0x3422('0x11'));var qs=require(_0x3422('0x12'));var as=require(_0x3422('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x3422('0x14'))(_0x3422('0x15'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x3422('0x16'));var db=require(_0x3422('0x17'))['db'];function respondWithStatusCode(_0x25ee03,_0x291268){_0x291268=_0x291268||0xcc;return function(_0x514928){if(_0x514928){return _0x25ee03[_0x3422('0x18')](_0x291268);}return _0x25ee03[_0x3422('0x19')](_0x291268)[_0x3422('0x1a')]();};}function respondWithResult(_0xcd2498,_0x46f6bd){_0x46f6bd=_0x46f6bd||0xc8;return function(_0x36bf36){if(_0x36bf36){return _0xcd2498[_0x3422('0x19')](_0x46f6bd)[_0x3422('0x1b')](_0x36bf36);}};}function respondWithFilteredResult(_0x1f8fe1,_0xe57b1f){return function(_0x3c1bc8){if(_0x3c1bc8){var _0x4b9239=_0x3c1bc8[_0x3422('0x1c')],_0x47cf9c=_0xe57b1f[_0x3422('0x1d')],_0xf6d2d5=_0xe57b1f['offset']+_0xe57b1f['limit'],_0x3c92d9;if(_0xf6d2d5>=_0x4b9239){_0xf6d2d5=_0x4b9239;_0x3c92d9=0xc8;}else{_0x3c92d9=0xce;}_0x1f8fe1['status'](_0x3c92d9);return _0x1f8fe1['set'](_0x3422('0x1e'),_0x47cf9c+'-'+_0xf6d2d5+'/'+_0x4b9239)[_0x3422('0x1b')](_0x3c1bc8);}return null;};}function patchUpdates(_0x55bf2f){return function(_0x47e006){try{jsonpatch[_0x3422('0x1f')](_0x47e006,_0x55bf2f,!![]);}catch(_0x462248){return BPromise[_0x3422('0x20')](_0x462248);}return _0x47e006[_0x3422('0x21')]();};}function saveUpdates(_0x6b5ad,_0xbf8768){return function(_0x1bb6fa){if(_0x1bb6fa){return _0x1bb6fa['update'](_0x6b5ad)[_0x3422('0x22')](function(_0x183f7d){return _0x183f7d;});}return null;};}function removeEntity(_0x3d5edd,_0x12af8c){return function(_0xe21ed3){if(_0xe21ed3){return _0xe21ed3[_0x3422('0x23')]()[_0x3422('0x22')](function(){_0x3d5edd[_0x3422('0x19')](0xcc)[_0x3422('0x1a')]();});}};}function handleEntityNotFound(_0xdbe028,_0x93f563){return function(_0x4bc71c){if(!_0x4bc71c){_0xdbe028[_0x3422('0x18')](0x194);}return _0x4bc71c;};}function handleError(_0x327b2e,_0x3aaaf8){_0x3aaaf8=_0x3aaaf8||0x1f4;return function(_0x580b10){logger[_0x3422('0x24')](_0x580b10['stack']);if(_0x580b10[_0x3422('0x25')]){delete _0x580b10['name'];}_0x327b2e[_0x3422('0x19')](_0x3aaaf8)[_0x3422('0x26')](_0x580b10);};}exports[_0x3422('0x27')]=function(_0x5cb716,_0x1e5701){var _0x2bc72d={},_0x2391ba={},_0x4738f8={'count':0x0,'rows':[]};var _0xbc8ded=_[_0x3422('0x28')](db[_0x3422('0x29')]['rawAttributes'],function(_0x189520){return{'name':_0x189520[_0x3422('0x2a')],'type':_0x189520[_0x3422('0x2b')][_0x3422('0x2c')]};});_0x2391ba[_0x3422('0x2d')]=_[_0x3422('0x28')](_0xbc8ded,_0x3422('0x25'));_0x2391ba[_0x3422('0x2e')]=_[_0x3422('0x2f')](_0x5cb716['query']);_0x2391ba[_0x3422('0x30')]=_[_0x3422('0x31')](_0x2391ba[_0x3422('0x2d')],_0x2391ba[_0x3422('0x2e')]);_0x2bc72d[_0x3422('0x32')]=_['intersection'](_0x2391ba[_0x3422('0x2d')],qs['fields'](_0x5cb716[_0x3422('0x2e')][_0x3422('0x33')]));_0x2bc72d[_0x3422('0x32')]=_0x2bc72d['attributes'][_0x3422('0x34')]?_0x2bc72d[_0x3422('0x32')]:_0x2391ba[_0x3422('0x2d')];if(!_0x5cb716['query'][_0x3422('0x35')](_0x3422('0x36'))){_0x2bc72d[_0x3422('0x37')]=qs[_0x3422('0x37')](_0x5cb716[_0x3422('0x2e')]['limit']);_0x2bc72d['offset']=qs[_0x3422('0x1d')](_0x5cb716['query'][_0x3422('0x1d')]);}_0x2bc72d['order']=qs[_0x3422('0x38')](_0x5cb716[_0x3422('0x2e')]['sort']);_0x2bc72d['where']=qs[_0x3422('0x30')](_[_0x3422('0x39')](_0x5cb716[_0x3422('0x2e')],_0x2391ba[_0x3422('0x30')]),_0xbc8ded);if(_0x5cb716[_0x3422('0x2e')][_0x3422('0x3a')]){_0x2bc72d[_0x3422('0x3b')]=_[_0x3422('0x3c')](_0x2bc72d['where'],{'$or':_[_0x3422('0x28')](_0xbc8ded,function(_0xd3eeb1){if(_0xd3eeb1[_0x3422('0x2b')]!==_0x3422('0x3d')){var _0x1811a7={};_0x1811a7[_0xd3eeb1['name']]={'$like':'%'+_0x5cb716['query']['filter']+'%'};return _0x1811a7;}})});}_0x2bc72d=_[_0x3422('0x3c')]({},_0x2bc72d,_0x5cb716[_0x3422('0x3e')]);var _0x489b5b={'where':_0x2bc72d[_0x3422('0x3b')]};return db[_0x3422('0x29')][_0x3422('0x1c')](_0x489b5b)[_0x3422('0x22')](function(_0x504c66){_0x4738f8[_0x3422('0x1c')]=_0x504c66;if(_0x5cb716[_0x3422('0x2e')][_0x3422('0x3f')]){_0x2bc72d[_0x3422('0x40')]=[{'all':!![]}];}return db[_0x3422('0x29')]['findAll'](_0x2bc72d);})[_0x3422('0x22')](function(_0x5431ea){_0x4738f8[_0x3422('0x41')]=_0x5431ea;return _0x4738f8;})[_0x3422('0x22')](respondWithFilteredResult(_0x1e5701,_0x2bc72d))[_0x3422('0x42')](handleError(_0x1e5701,null));};exports[_0x3422('0x43')]=function(_0x2c08d7,_0xf76b4d){var _0xa1c782={'raw':![],'where':{'id':_0x2c08d7[_0x3422('0x44')]['id']}},_0x23d6b8={};_0x23d6b8['model']=_['keys'](db[_0x3422('0x29')][_0x3422('0x45')]);_0x23d6b8[_0x3422('0x2e')]=_['keys'](_0x2c08d7[_0x3422('0x2e')]);_0x23d6b8[_0x3422('0x30')]=_[_0x3422('0x31')](_0x23d6b8['model'],_0x23d6b8[_0x3422('0x2e')]);_0xa1c782[_0x3422('0x32')]=_[_0x3422('0x31')](_0x23d6b8[_0x3422('0x2d')],qs[_0x3422('0x33')](_0x2c08d7[_0x3422('0x2e')][_0x3422('0x33')]));_0xa1c782[_0x3422('0x32')]=_0xa1c782[_0x3422('0x32')][_0x3422('0x34')]?_0xa1c782[_0x3422('0x32')]:_0x23d6b8['model'];if(_0x2c08d7['query']['includeAll']){_0xa1c782['include']=[{'all':!![]}];}_0xa1c782=_[_0x3422('0x3c')]({},_0xa1c782,_0x2c08d7[_0x3422('0x3e')]);return db['AnalyticFieldReport'][_0x3422('0x46')](_0xa1c782)[_0x3422('0x22')](handleEntityNotFound(_0xf76b4d,null))[_0x3422('0x22')](respondWithResult(_0xf76b4d,null))[_0x3422('0x42')](handleError(_0xf76b4d,null));};exports[_0x3422('0x47')]=function(_0x41dfd5,_0x3491cb){return db['AnalyticFieldReport'][_0x3422('0x47')](_0x41dfd5[_0x3422('0x48')],{})['then'](respondWithResult(_0x3491cb,0xc9))[_0x3422('0x42')](handleError(_0x3491cb,null));};exports['bulkCreate']=function(_0xefba4a,_0x48922a){return db[_0x3422('0x29')][_0x3422('0x49')](_0xefba4a[_0x3422('0x48')],{'raw':![],'individualHooks':!![]})[_0x3422('0x22')](respondWithResult(_0x48922a,0xc9))[_0x3422('0x42')](handleError(_0x48922a,null));};exports[_0x3422('0x4a')]=function(_0x4ef3f3,_0x5592cf){if(_0x4ef3f3[_0x3422('0x48')]['id']){delete _0x4ef3f3[_0x3422('0x48')]['id'];}return db[_0x3422('0x29')][_0x3422('0x46')]({'where':{'id':_0x4ef3f3[_0x3422('0x44')]['id']}})[_0x3422('0x22')](handleEntityNotFound(_0x5592cf,null))[_0x3422('0x22')](saveUpdates(_0x4ef3f3[_0x3422('0x48')],null))[_0x3422('0x22')](respondWithResult(_0x5592cf,null))[_0x3422('0x42')](handleError(_0x5592cf,null));};exports['destroy']=function(_0x565603,_0x31b96e){return db[_0x3422('0x29')][_0x3422('0x46')]({'where':{'id':_0x565603[_0x3422('0x44')]['id']}})['then'](handleEntityNotFound(_0x31b96e,null))[_0x3422('0x22')](removeEntity(_0x31b96e,null))[_0x3422('0x42')](handleError(_0x31b96e,null));};exports['bulkDestroy']=function(_0x38dc97,_0x16307b){return db[_0x3422('0x29')]['destroy']({'where':{'id':_0x38dc97['query'][_0x3422('0x4b')]||[]},'raw':![],'individualHooks':!![]})[_0x3422('0x22')](respondWithResult(_0x16307b,0xcc))[_0x3422('0x42')](handleError(_0x16307b,null));};exports[_0x3422('0x4c')]=function(_0x5673a0,_0xb90e29,_0x364524){return db[_0x3422('0x4d')][_0x3422('0x4e')]({'where':{'id':_0x5673a0[_0x3422('0x44')]['id']}})[_0x3422('0x22')](handleEntityNotFound(_0xb90e29,null))[_0x3422('0x22')](function(_0x171633){if(_0x171633){return db[_0x3422('0x4f')][_0x3422('0x50')](function(_0x2e0476){return db[_0x3422('0x29')][_0x3422('0x23')]({'where':{'CustomReportId':_0x5673a0[_0x3422('0x44')]['id']},'transaction':_0x2e0476})[_0x3422('0x22')](function(_0x769f86){var _0x9183c4=_['map'](_0x5673a0['body'],function(_0x421729){delete _0x421729['id'];_0x421729[_0x3422('0x51')]=_0x5673a0[_0x3422('0x44')]['id'];return _0x421729;});return db[_0x3422('0x29')][_0x3422('0x49')](_0x9183c4,{'transaction':_0x2e0476});});})['then'](function(){return db[_0x3422('0x29')][_0x3422('0x52')]({'where':{'CustomReportId':_0x5673a0[_0x3422('0x44')]['id']}});});}})[_0x3422('0x22')](respondWithResult(_0xb90e29,null))[_0x3422('0x42')](handleError(_0xb90e29,null));};