Built motion from commit e2351160.|2.5.50
[motion2.git] / 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 _0x98bd=['then','name','index','map','rawAttributes','fieldName','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','filter','where','merge','type','VIRTUAL','count','includeAll','AnalyticFieldReport','findAll','rows','catch','show','include','options','find','body','bulkCreate','params','destroy','bulkDestroy','ids','addFields','findOne','sequelize','CustomReportId','eml-format','rimraf','zip-dir','request-promise','moment','mustache','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','undefined','offset','set','Content-Range','json','apply','reject','save','update'];(function(_0x5a1b90,_0xa49811){var _0x3d468e=function(_0x39245a){while(--_0x39245a){_0x5a1b90['push'](_0x5a1b90['shift']());}};_0x3d468e(++_0xa49811);}(_0x98bd,0x1c2));var _0xd98b=function(_0xec338d,_0x26aa7c){_0xec338d=_0xec338d-0x0;var _0x510522=_0x98bd[_0xec338d];return _0x510522;};'use strict';var emlformat=require(_0xd98b('0x0'));var rimraf=require(_0xd98b('0x1'));var zipdir=require(_0xd98b('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xd98b('0x3'));var moment=require(_0xd98b('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xd98b('0x5'));var util=require('util');var path=require('path');var sox=require(_0xd98b('0x6'));var csv=require(_0xd98b('0x7'));var ejs=require(_0xd98b('0x8'));var fs=require('fs');var fs_extra=require(_0xd98b('0x9'));var _=require(_0xd98b('0xa'));var squel=require(_0xd98b('0xb'));var crypto=require(_0xd98b('0xc'));var jsforce=require(_0xd98b('0xd'));var deskjs=require(_0xd98b('0xe'));var toCsv=require(_0xd98b('0x7'));var querystring=require('querystring');var Papa=require(_0xd98b('0xf'));var Redis=require(_0xd98b('0x10'));var authService=require(_0xd98b('0x11'));var qs=require(_0xd98b('0x12'));var as=require(_0xd98b('0x13'));var hardwareService=require(_0xd98b('0x14'));var logger=require('../../config/logger')('api');var utils=require(_0xd98b('0x15'));var config=require(_0xd98b('0x16'));var licenseUtil=require(_0xd98b('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x35eabf,_0xf81c3f){_0xf81c3f=_0xf81c3f||0xcc;return function(_0x4e736d){if(_0x4e736d){return _0x35eabf[_0xd98b('0x18')](_0xf81c3f);}return _0x35eabf[_0xd98b('0x19')](_0xf81c3f)[_0xd98b('0x1a')]();};}function respondWithResult(_0x1d463c,_0x11e829){_0x11e829=_0x11e829||0xc8;return function(_0x5cf327){if(_0x5cf327){return _0x1d463c['status'](_0x11e829)['json'](_0x5cf327);}};}function respondWithFilteredResult(_0x14e3de,_0x577954){return function(_0x3a3646){if(_0x3a3646){var _0x2f5948=typeof _0x577954['offset']===_0xd98b('0x1b')&&typeof _0x577954['limit']===_0xd98b('0x1b');var _0x3fd216=_0x3a3646['count'];var _0x24c56b=_0x2f5948?0x0:_0x577954[_0xd98b('0x1c')];var _0x39f898=_0x2f5948?_0x3a3646['count']:_0x577954[_0xd98b('0x1c')]+_0x577954['limit'];var _0x2ed5e3;if(_0x39f898>=_0x3fd216){_0x39f898=_0x3fd216;_0x2ed5e3=0xc8;}else{_0x2ed5e3=0xce;}_0x14e3de[_0xd98b('0x19')](_0x2ed5e3);return _0x14e3de[_0xd98b('0x1d')](_0xd98b('0x1e'),_0x24c56b+'-'+_0x39f898+'/'+_0x3fd216)[_0xd98b('0x1f')](_0x3a3646);}return null;};}function patchUpdates(_0x5ccc3d){return function(_0x34c73b){try{jsonpatch[_0xd98b('0x20')](_0x34c73b,_0x5ccc3d,!![]);}catch(_0x184fa2){return BPromise[_0xd98b('0x21')](_0x184fa2);}return _0x34c73b[_0xd98b('0x22')]();};}function saveUpdates(_0x53209e,_0x306bff){return function(_0x373a2f){if(_0x373a2f){return _0x373a2f[_0xd98b('0x23')](_0x53209e)[_0xd98b('0x24')](function(_0x27cea3){return _0x27cea3;});}return null;};}function removeEntity(_0x27b7fc,_0x45dcfe){return function(_0x1f26f9){if(_0x1f26f9){return _0x1f26f9['destroy']()[_0xd98b('0x24')](function(){_0x27b7fc[_0xd98b('0x19')](0xcc)[_0xd98b('0x1a')]();});}};}function handleEntityNotFound(_0x33744b,_0x1c57ba){return function(_0x483693){if(!_0x483693){_0x33744b['sendStatus'](0x194);}return _0x483693;};}function handleError(_0x327cd7,_0x410b68){_0x410b68=_0x410b68||0x1f4;return function(_0x2fc06e){logger['error'](_0x2fc06e['stack']);if(_0x2fc06e[_0xd98b('0x25')]){delete _0x2fc06e['name'];}_0x327cd7[_0xd98b('0x19')](_0x410b68)['send'](_0x2fc06e);};}exports[_0xd98b('0x26')]=function(_0x4dc700,_0x1011b3){var _0x9721ae={},_0x6e940e={},_0x17c348={'count':0x0,'rows':[]};var _0x55d577=_[_0xd98b('0x27')](db['AnalyticFieldReport'][_0xd98b('0x28')],function(_0x49150b){return{'name':_0x49150b[_0xd98b('0x29')],'type':_0x49150b['type'][_0xd98b('0x2a')]};});_0x6e940e[_0xd98b('0x2b')]=_[_0xd98b('0x27')](_0x55d577,_0xd98b('0x25'));_0x6e940e['query']=_[_0xd98b('0x2c')](_0x4dc700[_0xd98b('0x2d')]);_0x6e940e[_0xd98b('0x2e')]=_[_0xd98b('0x2f')](_0x6e940e[_0xd98b('0x2b')],_0x6e940e[_0xd98b('0x2d')]);_0x9721ae[_0xd98b('0x30')]=_[_0xd98b('0x2f')](_0x6e940e['model'],qs[_0xd98b('0x31')](_0x4dc700['query'][_0xd98b('0x31')]));_0x9721ae[_0xd98b('0x30')]=_0x9721ae['attributes'][_0xd98b('0x32')]?_0x9721ae[_0xd98b('0x30')]:_0x6e940e[_0xd98b('0x2b')];if(!_0x4dc700['query'][_0xd98b('0x33')](_0xd98b('0x34'))){_0x9721ae[_0xd98b('0x35')]=qs[_0xd98b('0x35')](_0x4dc700['query'][_0xd98b('0x35')]);_0x9721ae[_0xd98b('0x1c')]=qs['offset'](_0x4dc700[_0xd98b('0x2d')]['offset']);}_0x9721ae[_0xd98b('0x36')]=qs['sort'](_0x4dc700[_0xd98b('0x2d')][_0xd98b('0x37')]);_0x9721ae['where']=qs['filters'](_['pick'](_0x4dc700[_0xd98b('0x2d')],_0x6e940e[_0xd98b('0x2e')]),_0x55d577);if(_0x4dc700['query'][_0xd98b('0x38')]){_0x9721ae[_0xd98b('0x39')]=_[_0xd98b('0x3a')](_0x9721ae['where'],{'$or':_['map'](_0x55d577,function(_0x314eb7){if(_0x314eb7[_0xd98b('0x3b')]!==_0xd98b('0x3c')){var _0x40201b={};_0x40201b[_0x314eb7[_0xd98b('0x25')]]={'$like':'%'+_0x4dc700[_0xd98b('0x2d')][_0xd98b('0x38')]+'%'};return _0x40201b;}})});}_0x9721ae=_[_0xd98b('0x3a')]({},_0x9721ae,_0x4dc700['options']);var _0x291b1b={'where':_0x9721ae['where']};return db['AnalyticFieldReport'][_0xd98b('0x3d')](_0x291b1b)['then'](function(_0x27caa0){_0x17c348['count']=_0x27caa0;if(_0x4dc700['query'][_0xd98b('0x3e')]){_0x9721ae['include']=[{'all':!![]}];}return db[_0xd98b('0x3f')][_0xd98b('0x40')](_0x9721ae);})['then'](function(_0x14e57a){_0x17c348[_0xd98b('0x41')]=_0x14e57a;return _0x17c348;})[_0xd98b('0x24')](respondWithFilteredResult(_0x1011b3,_0x9721ae))[_0xd98b('0x42')](handleError(_0x1011b3,null));};exports[_0xd98b('0x43')]=function(_0x4922ae,_0x5acab2){var _0x43ad4b={'raw':![],'where':{'id':_0x4922ae['params']['id']}},_0xbe7671={};_0xbe7671[_0xd98b('0x2b')]=_[_0xd98b('0x2c')](db[_0xd98b('0x3f')][_0xd98b('0x28')]);_0xbe7671[_0xd98b('0x2d')]=_[_0xd98b('0x2c')](_0x4922ae[_0xd98b('0x2d')]);_0xbe7671[_0xd98b('0x2e')]=_[_0xd98b('0x2f')](_0xbe7671[_0xd98b('0x2b')],_0xbe7671[_0xd98b('0x2d')]);_0x43ad4b[_0xd98b('0x30')]=_[_0xd98b('0x2f')](_0xbe7671['model'],qs[_0xd98b('0x31')](_0x4922ae[_0xd98b('0x2d')]['fields']));_0x43ad4b[_0xd98b('0x30')]=_0x43ad4b['attributes'][_0xd98b('0x32')]?_0x43ad4b[_0xd98b('0x30')]:_0xbe7671[_0xd98b('0x2b')];if(_0x4922ae[_0xd98b('0x2d')]['includeAll']){_0x43ad4b[_0xd98b('0x44')]=[{'all':!![]}];}_0x43ad4b=_[_0xd98b('0x3a')]({},_0x43ad4b,_0x4922ae[_0xd98b('0x45')]);return db['AnalyticFieldReport'][_0xd98b('0x46')](_0x43ad4b)[_0xd98b('0x24')](handleEntityNotFound(_0x5acab2,null))[_0xd98b('0x24')](respondWithResult(_0x5acab2,null))['catch'](handleError(_0x5acab2,null));};exports['create']=function(_0x3f73fa,_0x59d5e0){return db[_0xd98b('0x3f')]['create'](_0x3f73fa[_0xd98b('0x47')],{})[_0xd98b('0x24')](respondWithResult(_0x59d5e0,0xc9))[_0xd98b('0x42')](handleError(_0x59d5e0,null));};exports[_0xd98b('0x48')]=function(_0x568883,_0x42b082){return db[_0xd98b('0x3f')][_0xd98b('0x48')](_0x568883[_0xd98b('0x47')],{'raw':![],'individualHooks':!![]})[_0xd98b('0x24')](respondWithResult(_0x42b082,0xc9))[_0xd98b('0x42')](handleError(_0x42b082,null));};exports[_0xd98b('0x23')]=function(_0x439ab1,_0x4e2c24){if(_0x439ab1[_0xd98b('0x47')]['id']){delete _0x439ab1[_0xd98b('0x47')]['id'];}return db['AnalyticFieldReport'][_0xd98b('0x46')]({'where':{'id':_0x439ab1[_0xd98b('0x49')]['id']}})[_0xd98b('0x24')](handleEntityNotFound(_0x4e2c24,null))['then'](saveUpdates(_0x439ab1[_0xd98b('0x47')],null))[_0xd98b('0x24')](respondWithResult(_0x4e2c24,null))[_0xd98b('0x42')](handleError(_0x4e2c24,null));};exports[_0xd98b('0x4a')]=function(_0x469c78,_0x38e98e){return db[_0xd98b('0x3f')][_0xd98b('0x46')]({'where':{'id':_0x469c78[_0xd98b('0x49')]['id']}})['then'](handleEntityNotFound(_0x38e98e,null))[_0xd98b('0x24')](removeEntity(_0x38e98e,null))[_0xd98b('0x42')](handleError(_0x38e98e,null));};exports[_0xd98b('0x4b')]=function(_0x2e8e8f,_0x5d010d){return db[_0xd98b('0x3f')][_0xd98b('0x4a')]({'where':{'id':_0x2e8e8f[_0xd98b('0x2d')][_0xd98b('0x4c')]||[]},'raw':![],'individualHooks':!![]})[_0xd98b('0x24')](respondWithResult(_0x5d010d,0xcc))[_0xd98b('0x42')](handleError(_0x5d010d,null));};exports[_0xd98b('0x4d')]=function(_0x4d226a,_0x427eeb,_0x149769){return db['AnalyticCustomReport'][_0xd98b('0x4e')]({'where':{'id':_0x4d226a['params']['id']}})['then'](handleEntityNotFound(_0x427eeb,null))[_0xd98b('0x24')](function(_0x5903f7){if(_0x5903f7){return db[_0xd98b('0x4f')]['transaction'](function(_0x4b69c4){return db[_0xd98b('0x3f')]['destroy']({'where':{'CustomReportId':_0x4d226a[_0xd98b('0x49')]['id']},'transaction':_0x4b69c4})['then'](function(_0x27604b){var _0x59d5e8=_[_0xd98b('0x27')](_0x4d226a['body'],function(_0x481181){delete _0x481181['id'];_0x481181[_0xd98b('0x50')]=_0x4d226a[_0xd98b('0x49')]['id'];return _0x481181;});return db[_0xd98b('0x3f')]['bulkCreate'](_0x59d5e8,{'transaction':_0x4b69c4});});})[_0xd98b('0x24')](function(){return db[_0xd98b('0x3f')][_0xd98b('0x40')]({'where':{'CustomReportId':_0x4d226a[_0xd98b('0x49')]['id']}});});}})[_0xd98b('0x24')](respondWithResult(_0x427eeb,null))[_0xd98b('0x42')](handleError(_0x427eeb,null));};