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 _0x26e4=['request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','offset','limit','set','Content-Range','apply','update','destroy','then','end','stack','name','send','index','map','AnalyticFieldReport','fieldName','type','model','query','keys','filters','intersection','attributes','fields','nolimit','order','sort','pick','filter','where','merge','options','count','findAll','catch','show','params','rawAttributes','length','includeAll','include','find','create','body','bulkCreate','ids','addFields','AnalyticCustomReport','findOne','sequelize','transaction','CustomReportId','html-pdf','rimraf','zip-dir','fast-json-patch'];(function(_0x91ff52,_0x2cde3c){var _0x37d193=function(_0x5cb450){while(--_0x5cb450){_0x91ff52['push'](_0x91ff52['shift']());}};_0x37d193(++_0x2cde3c);}(_0x26e4,0x1ee));var _0x426e=function(_0x501510,_0x61caa9){_0x501510=_0x501510-0x0;var _0x1e6ee5=_0x26e4[_0x501510];return _0x1e6ee5;};'use strict';var pdf=require(_0x426e('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x426e('0x1'));var zipdir=require(_0x426e('0x2'));var jsonpatch=require(_0x426e('0x3'));var rp=require(_0x426e('0x4'));var moment=require(_0x426e('0x5'));var BPromise=require(_0x426e('0x6'));var Mustache=require(_0x426e('0x7'));var util=require(_0x426e('0x8'));var path=require(_0x426e('0x9'));var sox=require(_0x426e('0xa'));var csv=require(_0x426e('0xb'));var ejs=require(_0x426e('0xc'));var fs=require('fs');var _=require(_0x426e('0xd'));var squel=require(_0x426e('0xe'));var crypto=require(_0x426e('0xf'));var jsforce=require(_0x426e('0x10'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x426e('0x11'));var Redis=require(_0x426e('0x12'));var authService=require(_0x426e('0x13'));var qs=require(_0x426e('0x14'));var as=require(_0x426e('0x15'));var hardwareService=require(_0x426e('0x16'));var logger=require(_0x426e('0x17'))(_0x426e('0x18'));var utils=require(_0x426e('0x19'));var config=require(_0x426e('0x1a'));var licenseUtil=require('../../config/license/util');var db=require(_0x426e('0x1b'))['db'];function respondWithStatusCode(_0x5bfccf,_0x3a32d0){_0x3a32d0=_0x3a32d0||0xcc;return function(_0x2c4845){if(_0x2c4845){return _0x5bfccf[_0x426e('0x1c')](_0x3a32d0);}return _0x5bfccf[_0x426e('0x1d')](_0x3a32d0)['end']();};}function respondWithResult(_0x499bb4,_0x5293a5){_0x5293a5=_0x5293a5||0xc8;return function(_0xde7647){if(_0xde7647){return _0x499bb4[_0x426e('0x1d')](_0x5293a5)[_0x426e('0x1e')](_0xde7647);}};}function respondWithFilteredResult(_0x18b0e3,_0x1975c2){return function(_0x16d844){if(_0x16d844){var _0x394881=_0x16d844['count'],_0x2b15f7=_0x1975c2[_0x426e('0x1f')],_0x3a2cf7=_0x1975c2[_0x426e('0x1f')]+_0x1975c2[_0x426e('0x20')],_0x280f41;if(_0x3a2cf7>=_0x394881){_0x3a2cf7=_0x394881;_0x280f41=0xc8;}else{_0x280f41=0xce;}_0x18b0e3['status'](_0x280f41);return _0x18b0e3[_0x426e('0x21')](_0x426e('0x22'),_0x2b15f7+'-'+_0x3a2cf7+'/'+_0x394881)[_0x426e('0x1e')](_0x16d844);}return null;};}function patchUpdates(_0x5b2506){return function(_0x15d372){try{jsonpatch[_0x426e('0x23')](_0x15d372,_0x5b2506,!![]);}catch(_0x43212f){return BPromise['reject'](_0x43212f);}return _0x15d372['save']();};}function saveUpdates(_0x2f4f05,_0x390ae3){return function(_0x5a3ff6){if(_0x5a3ff6){return _0x5a3ff6[_0x426e('0x24')](_0x2f4f05)['then'](function(_0x188b5c){return _0x188b5c;});}return null;};}function removeEntity(_0x42677d,_0x53dab5){return function(_0x2af2a2){if(_0x2af2a2){return _0x2af2a2[_0x426e('0x25')]()[_0x426e('0x26')](function(){_0x42677d['status'](0xcc)[_0x426e('0x27')]();});}};}function handleEntityNotFound(_0x2018ee,_0x32e82c){return function(_0x26ade4){if(!_0x26ade4){_0x2018ee[_0x426e('0x1c')](0x194);}return _0x26ade4;};}function handleError(_0x445cdc,_0xe00a2d){_0xe00a2d=_0xe00a2d||0x1f4;return function(_0x21b10b){logger['error'](_0x21b10b[_0x426e('0x28')]);if(_0x21b10b['name']){delete _0x21b10b[_0x426e('0x29')];}_0x445cdc[_0x426e('0x1d')](_0xe00a2d)[_0x426e('0x2a')](_0x21b10b);};}exports[_0x426e('0x2b')]=function(_0x129b3f,_0x2f0c1c){var _0x542034={},_0x12af6f={},_0x5d0c47={'count':0x0,'rows':[]};var _0x3982ea=_[_0x426e('0x2c')](db[_0x426e('0x2d')]['rawAttributes'],function(_0x1caaf0){return{'name':_0x1caaf0[_0x426e('0x2e')],'type':_0x1caaf0[_0x426e('0x2f')]['key']};});_0x12af6f[_0x426e('0x30')]=_['map'](_0x3982ea,_0x426e('0x29'));_0x12af6f[_0x426e('0x31')]=_[_0x426e('0x32')](_0x129b3f[_0x426e('0x31')]);_0x12af6f[_0x426e('0x33')]=_[_0x426e('0x34')](_0x12af6f['model'],_0x12af6f[_0x426e('0x31')]);_0x542034[_0x426e('0x35')]=_[_0x426e('0x34')](_0x12af6f[_0x426e('0x30')],qs[_0x426e('0x36')](_0x129b3f['query']['fields']));_0x542034[_0x426e('0x35')]=_0x542034['attributes']['length']?_0x542034[_0x426e('0x35')]:_0x12af6f[_0x426e('0x30')];if(!_0x129b3f[_0x426e('0x31')]['hasOwnProperty'](_0x426e('0x37'))){_0x542034[_0x426e('0x20')]=qs[_0x426e('0x20')](_0x129b3f['query'][_0x426e('0x20')]);_0x542034[_0x426e('0x1f')]=qs['offset'](_0x129b3f[_0x426e('0x31')][_0x426e('0x1f')]);}_0x542034[_0x426e('0x38')]=qs[_0x426e('0x39')](_0x129b3f[_0x426e('0x31')][_0x426e('0x39')]);_0x542034['where']=qs['filters'](_[_0x426e('0x3a')](_0x129b3f[_0x426e('0x31')],_0x12af6f[_0x426e('0x33')]),_0x3982ea);if(_0x129b3f[_0x426e('0x31')][_0x426e('0x3b')]){_0x542034[_0x426e('0x3c')]=_[_0x426e('0x3d')](_0x542034[_0x426e('0x3c')],{'$or':_[_0x426e('0x2c')](_0x3982ea,function(_0x448b9a){if(_0x448b9a[_0x426e('0x2f')]!=='VIRTUAL'){var _0xfc7e0d={};_0xfc7e0d[_0x448b9a[_0x426e('0x29')]]={'$like':'%'+_0x129b3f[_0x426e('0x31')][_0x426e('0x3b')]+'%'};return _0xfc7e0d;}})});}_0x542034=_[_0x426e('0x3d')]({},_0x542034,_0x129b3f[_0x426e('0x3e')]);var _0x479544={'where':_0x542034[_0x426e('0x3c')]};return db[_0x426e('0x2d')][_0x426e('0x3f')](_0x479544)[_0x426e('0x26')](function(_0x5028c8){_0x5d0c47['count']=_0x5028c8;if(_0x129b3f[_0x426e('0x31')]['includeAll']){_0x542034['include']=[{'all':!![]}];}return db[_0x426e('0x2d')][_0x426e('0x40')](_0x542034);})[_0x426e('0x26')](function(_0x169b97){_0x5d0c47['rows']=_0x169b97;return _0x5d0c47;})['then'](respondWithFilteredResult(_0x2f0c1c,_0x542034))[_0x426e('0x41')](handleError(_0x2f0c1c,null));};exports[_0x426e('0x42')]=function(_0x3b95e9,_0x1ee88d){var _0x1acd5f={'raw':![],'where':{'id':_0x3b95e9[_0x426e('0x43')]['id']}},_0x3329ef={};_0x3329ef[_0x426e('0x30')]=_['keys'](db[_0x426e('0x2d')][_0x426e('0x44')]);_0x3329ef[_0x426e('0x31')]=_['keys'](_0x3b95e9[_0x426e('0x31')]);_0x3329ef[_0x426e('0x33')]=_['intersection'](_0x3329ef[_0x426e('0x30')],_0x3329ef[_0x426e('0x31')]);_0x1acd5f[_0x426e('0x35')]=_[_0x426e('0x34')](_0x3329ef[_0x426e('0x30')],qs['fields'](_0x3b95e9['query'][_0x426e('0x36')]));_0x1acd5f['attributes']=_0x1acd5f[_0x426e('0x35')][_0x426e('0x45')]?_0x1acd5f[_0x426e('0x35')]:_0x3329ef[_0x426e('0x30')];if(_0x3b95e9[_0x426e('0x31')][_0x426e('0x46')]){_0x1acd5f[_0x426e('0x47')]=[{'all':!![]}];}_0x1acd5f=_[_0x426e('0x3d')]({},_0x1acd5f,_0x3b95e9[_0x426e('0x3e')]);return db[_0x426e('0x2d')][_0x426e('0x48')](_0x1acd5f)[_0x426e('0x26')](handleEntityNotFound(_0x1ee88d,null))[_0x426e('0x26')](respondWithResult(_0x1ee88d,null))[_0x426e('0x41')](handleError(_0x1ee88d,null));};exports[_0x426e('0x49')]=function(_0x23d5cc,_0x450d63){return db[_0x426e('0x2d')][_0x426e('0x49')](_0x23d5cc[_0x426e('0x4a')],{})[_0x426e('0x26')](respondWithResult(_0x450d63,0xc9))['catch'](handleError(_0x450d63,null));};exports[_0x426e('0x4b')]=function(_0x113c3a,_0x56126c){return db[_0x426e('0x2d')][_0x426e('0x4b')](_0x113c3a[_0x426e('0x4a')],{'raw':![],'individualHooks':!![]})[_0x426e('0x26')](respondWithResult(_0x56126c,0xc9))[_0x426e('0x41')](handleError(_0x56126c,null));};exports[_0x426e('0x24')]=function(_0x107f43,_0x27de0c){if(_0x107f43['body']['id']){delete _0x107f43[_0x426e('0x4a')]['id'];}return db[_0x426e('0x2d')][_0x426e('0x48')]({'where':{'id':_0x107f43['params']['id']}})[_0x426e('0x26')](handleEntityNotFound(_0x27de0c,null))[_0x426e('0x26')](saveUpdates(_0x107f43[_0x426e('0x4a')],null))[_0x426e('0x26')](respondWithResult(_0x27de0c,null))[_0x426e('0x41')](handleError(_0x27de0c,null));};exports['destroy']=function(_0x118095,_0x3be4f9){return db[_0x426e('0x2d')][_0x426e('0x48')]({'where':{'id':_0x118095[_0x426e('0x43')]['id']}})['then'](handleEntityNotFound(_0x3be4f9,null))[_0x426e('0x26')](removeEntity(_0x3be4f9,null))[_0x426e('0x41')](handleError(_0x3be4f9,null));};exports['bulkDestroy']=function(_0x47a4d0,_0x2108b3){return db[_0x426e('0x2d')]['destroy']({'where':{'id':_0x47a4d0[_0x426e('0x31')][_0x426e('0x4c')]||[]},'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x2108b3,0xcc))[_0x426e('0x41')](handleError(_0x2108b3,null));};exports[_0x426e('0x4d')]=function(_0x122b58,_0xac5a00,_0x555e9b){return db[_0x426e('0x4e')][_0x426e('0x4f')]({'where':{'id':_0x122b58[_0x426e('0x43')]['id']}})[_0x426e('0x26')](handleEntityNotFound(_0xac5a00,null))['then'](function(_0x291e3c){if(_0x291e3c){return db[_0x426e('0x50')][_0x426e('0x51')](function(_0x23a59c){return db['AnalyticFieldReport'][_0x426e('0x25')]({'where':{'CustomReportId':_0x122b58[_0x426e('0x43')]['id']},'transaction':_0x23a59c})[_0x426e('0x26')](function(_0x52ce49){var _0x471039=_[_0x426e('0x2c')](_0x122b58[_0x426e('0x4a')],function(_0x58c43a){delete _0x58c43a['id'];_0x58c43a[_0x426e('0x52')]=_0x122b58[_0x426e('0x43')]['id'];return _0x58c43a;});return db[_0x426e('0x2d')][_0x426e('0x4b')](_0x471039,{'transaction':_0x23a59c});});})[_0x426e('0x26')](function(){return db[_0x426e('0x2d')]['findAll']({'where':{'CustomReportId':_0x122b58['params']['id']}});});}})[_0x426e('0x26')](respondWithResult(_0xac5a00,null))[_0x426e('0x41')](handleError(_0xac5a00,null));};