7205024751e433f2268344fd23165390753bd6b9
[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 _0xe2ef=['offset','Content-Range','apply','reject','save','update','then','error','name','send','rawAttributes','fieldName','type','key','model','map','query','filters','intersection','attributes','fields','length','hasOwnProperty','pick','filter','where','merge','options','AnalyticFieldReport','includeAll','findAll','rows','catch','show','params','keys','find','create','body','bulkCreate','bulkDestroy','destroy','AnalyticCustomReport','sequelize','rimraf','fast-json-patch','moment','mustache','util','path','to-csv','ejs','fs-extra','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','undefined','limit','count'];(function(_0x2cc73c,_0x465104){var _0x39d126=function(_0x7cb926){while(--_0x7cb926){_0x2cc73c['push'](_0x2cc73c['shift']());}};_0x39d126(++_0x465104);}(_0xe2ef,0x104));var _0xfe2e=function(_0x44edb6,_0x174fe7){_0x44edb6=_0x44edb6-0x0;var _0xfca19c=_0xe2ef[_0x44edb6];return _0xfca19c;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xfe2e('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xfe2e('0x1'));var rp=require('request-promise');var moment=require(_0xfe2e('0x2'));var BPromise=require('bluebird');var Mustache=require(_0xfe2e('0x3'));var util=require(_0xfe2e('0x4'));var path=require(_0xfe2e('0x5'));var sox=require('sox');var csv=require(_0xfe2e('0x6'));var ejs=require(_0xfe2e('0x7'));var fs=require('fs');var fs_extra=require(_0xfe2e('0x8'));var _=require('lodash');var squel=require(_0xfe2e('0x9'));var crypto=require('crypto');var jsforce=require(_0xfe2e('0xa'));var deskjs=require(_0xfe2e('0xb'));var toCsv=require(_0xfe2e('0x6'));var querystring=require(_0xfe2e('0xc'));var Papa=require(_0xfe2e('0xd'));var Redis=require(_0xfe2e('0xe'));var authService=require(_0xfe2e('0xf'));var qs=require('../../components/parsers/qs');var as=require(_0xfe2e('0x10'));var hardwareService=require(_0xfe2e('0x11'));var logger=require('../../config/logger')(_0xfe2e('0x12'));var utils=require('../../config/utils');var config=require(_0xfe2e('0x13'));var licenseUtil=require(_0xfe2e('0x14'));var db=require(_0xfe2e('0x15'))['db'];function respondWithStatusCode(_0x34bad4,_0x23fb29){_0x23fb29=_0x23fb29||0xcc;return function(_0x58a134){if(_0x58a134){return _0x34bad4[_0xfe2e('0x16')](_0x23fb29);}return _0x34bad4[_0xfe2e('0x17')](_0x23fb29)[_0xfe2e('0x18')]();};}function respondWithResult(_0x4fafdc,_0x34fc1c){_0x34fc1c=_0x34fc1c||0xc8;return function(_0x550769){if(_0x550769){return _0x4fafdc['status'](_0x34fc1c)['json'](_0x550769);}};}function respondWithFilteredResult(_0x265c6c,_0x3d2379){return function(_0xdae4ac){if(_0xdae4ac){var _0x4877bb=typeof _0x3d2379['offset']===_0xfe2e('0x19')&&typeof _0x3d2379[_0xfe2e('0x1a')]===_0xfe2e('0x19');var _0x3acfdf=_0xdae4ac[_0xfe2e('0x1b')];var _0x18f55b=_0x4877bb?0x0:_0x3d2379[_0xfe2e('0x1c')];var _0x5d515e=_0x4877bb?_0xdae4ac['count']:_0x3d2379[_0xfe2e('0x1c')]+_0x3d2379[_0xfe2e('0x1a')];var _0x286233;if(_0x5d515e>=_0x3acfdf){_0x5d515e=_0x3acfdf;_0x286233=0xc8;}else{_0x286233=0xce;}_0x265c6c[_0xfe2e('0x17')](_0x286233);return _0x265c6c['set'](_0xfe2e('0x1d'),_0x18f55b+'-'+_0x5d515e+'/'+_0x3acfdf)['json'](_0xdae4ac);}return null;};}function patchUpdates(_0x3d705c){return function(_0x2b6a7c){try{jsonpatch[_0xfe2e('0x1e')](_0x2b6a7c,_0x3d705c,!![]);}catch(_0x276190){return BPromise[_0xfe2e('0x1f')](_0x276190);}return _0x2b6a7c[_0xfe2e('0x20')]();};}function saveUpdates(_0x7b4add,_0x32f24){return function(_0x37626b){if(_0x37626b){return _0x37626b[_0xfe2e('0x21')](_0x7b4add)[_0xfe2e('0x22')](function(_0x5a4541){return _0x5a4541;});}return null;};}function removeEntity(_0xb17e1b,_0x1bb266){return function(_0x905eeb){if(_0x905eeb){return _0x905eeb['destroy']()[_0xfe2e('0x22')](function(){_0xb17e1b[_0xfe2e('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1b5dae,_0x36ff87){return function(_0x5e2f6d){if(!_0x5e2f6d){_0x1b5dae[_0xfe2e('0x16')](0x194);}return _0x5e2f6d;};}function handleError(_0x44b1e0,_0x5b6318){_0x5b6318=_0x5b6318||0x1f4;return function(_0x51a6e4){logger[_0xfe2e('0x23')](_0x51a6e4['stack']);if(_0x51a6e4[_0xfe2e('0x24')]){delete _0x51a6e4[_0xfe2e('0x24')];}_0x44b1e0[_0xfe2e('0x17')](_0x5b6318)[_0xfe2e('0x25')](_0x51a6e4);};}exports['index']=function(_0x5e971e,_0x435621){var _0x2131c3={},_0x143262={},_0x4b68fc={'count':0x0,'rows':[]};var _0x83487b=_['map'](db['AnalyticFieldReport'][_0xfe2e('0x26')],function(_0x527e08){return{'name':_0x527e08[_0xfe2e('0x27')],'type':_0x527e08[_0xfe2e('0x28')][_0xfe2e('0x29')]};});_0x143262[_0xfe2e('0x2a')]=_[_0xfe2e('0x2b')](_0x83487b,_0xfe2e('0x24'));_0x143262[_0xfe2e('0x2c')]=_['keys'](_0x5e971e[_0xfe2e('0x2c')]);_0x143262[_0xfe2e('0x2d')]=_[_0xfe2e('0x2e')](_0x143262[_0xfe2e('0x2a')],_0x143262[_0xfe2e('0x2c')]);_0x2131c3[_0xfe2e('0x2f')]=_['intersection'](_0x143262[_0xfe2e('0x2a')],qs[_0xfe2e('0x30')](_0x5e971e[_0xfe2e('0x2c')][_0xfe2e('0x30')]));_0x2131c3[_0xfe2e('0x2f')]=_0x2131c3[_0xfe2e('0x2f')][_0xfe2e('0x31')]?_0x2131c3[_0xfe2e('0x2f')]:_0x143262[_0xfe2e('0x2a')];if(!_0x5e971e[_0xfe2e('0x2c')][_0xfe2e('0x32')]('nolimit')){_0x2131c3['limit']=qs[_0xfe2e('0x1a')](_0x5e971e[_0xfe2e('0x2c')][_0xfe2e('0x1a')]);_0x2131c3[_0xfe2e('0x1c')]=qs[_0xfe2e('0x1c')](_0x5e971e[_0xfe2e('0x2c')][_0xfe2e('0x1c')]);}_0x2131c3['order']=qs['sort'](_0x5e971e['query']['sort']);_0x2131c3['where']=qs[_0xfe2e('0x2d')](_[_0xfe2e('0x33')](_0x5e971e['query'],_0x143262[_0xfe2e('0x2d')]),_0x83487b);if(_0x5e971e['query'][_0xfe2e('0x34')]){_0x2131c3[_0xfe2e('0x35')]=_[_0xfe2e('0x36')](_0x2131c3[_0xfe2e('0x35')],{'$or':_['map'](_0x83487b,function(_0x3a34f4){if(_0x3a34f4[_0xfe2e('0x28')]!=='VIRTUAL'){var _0x1a288b={};_0x1a288b[_0x3a34f4[_0xfe2e('0x24')]]={'$like':'%'+_0x5e971e[_0xfe2e('0x2c')]['filter']+'%'};return _0x1a288b;}})});}_0x2131c3=_[_0xfe2e('0x36')]({},_0x2131c3,_0x5e971e[_0xfe2e('0x37')]);var _0x4abf9d={'where':_0x2131c3[_0xfe2e('0x35')]};return db[_0xfe2e('0x38')]['count'](_0x4abf9d)[_0xfe2e('0x22')](function(_0x5743df){_0x4b68fc['count']=_0x5743df;if(_0x5e971e[_0xfe2e('0x2c')][_0xfe2e('0x39')]){_0x2131c3['include']=[{'all':!![]}];}return db[_0xfe2e('0x38')][_0xfe2e('0x3a')](_0x2131c3);})[_0xfe2e('0x22')](function(_0x495141){_0x4b68fc[_0xfe2e('0x3b')]=_0x495141;return _0x4b68fc;})[_0xfe2e('0x22')](respondWithFilteredResult(_0x435621,_0x2131c3))[_0xfe2e('0x3c')](handleError(_0x435621,null));};exports[_0xfe2e('0x3d')]=function(_0x5d90c1,_0x308e01){var _0xfb2e1d={'raw':![],'where':{'id':_0x5d90c1[_0xfe2e('0x3e')]['id']}},_0x42c563={};_0x42c563[_0xfe2e('0x2a')]=_[_0xfe2e('0x3f')](db[_0xfe2e('0x38')][_0xfe2e('0x26')]);_0x42c563[_0xfe2e('0x2c')]=_[_0xfe2e('0x3f')](_0x5d90c1[_0xfe2e('0x2c')]);_0x42c563[_0xfe2e('0x2d')]=_[_0xfe2e('0x2e')](_0x42c563[_0xfe2e('0x2a')],_0x42c563[_0xfe2e('0x2c')]);_0xfb2e1d[_0xfe2e('0x2f')]=_[_0xfe2e('0x2e')](_0x42c563[_0xfe2e('0x2a')],qs[_0xfe2e('0x30')](_0x5d90c1['query'][_0xfe2e('0x30')]));_0xfb2e1d[_0xfe2e('0x2f')]=_0xfb2e1d[_0xfe2e('0x2f')][_0xfe2e('0x31')]?_0xfb2e1d[_0xfe2e('0x2f')]:_0x42c563[_0xfe2e('0x2a')];if(_0x5d90c1[_0xfe2e('0x2c')][_0xfe2e('0x39')]){_0xfb2e1d['include']=[{'all':!![]}];}_0xfb2e1d=_[_0xfe2e('0x36')]({},_0xfb2e1d,_0x5d90c1['options']);return db[_0xfe2e('0x38')][_0xfe2e('0x40')](_0xfb2e1d)[_0xfe2e('0x22')](handleEntityNotFound(_0x308e01,null))[_0xfe2e('0x22')](respondWithResult(_0x308e01,null))[_0xfe2e('0x3c')](handleError(_0x308e01,null));};exports[_0xfe2e('0x41')]=function(_0x19d426,_0x3d2ce3){return db[_0xfe2e('0x38')][_0xfe2e('0x41')](_0x19d426[_0xfe2e('0x42')],{})['then'](respondWithResult(_0x3d2ce3,0xc9))[_0xfe2e('0x3c')](handleError(_0x3d2ce3,null));};exports[_0xfe2e('0x43')]=function(_0x7770f0,_0x1c4f4f){return db[_0xfe2e('0x38')][_0xfe2e('0x43')](_0x7770f0[_0xfe2e('0x42')],{'raw':![],'individualHooks':!![]})[_0xfe2e('0x22')](respondWithResult(_0x1c4f4f,0xc9))['catch'](handleError(_0x1c4f4f,null));};exports[_0xfe2e('0x21')]=function(_0x1f0f57,_0x4a4b55){if(_0x1f0f57['body']['id']){delete _0x1f0f57[_0xfe2e('0x42')]['id'];}return db['AnalyticFieldReport']['find']({'where':{'id':_0x1f0f57[_0xfe2e('0x3e')]['id']}})[_0xfe2e('0x22')](handleEntityNotFound(_0x4a4b55,null))['then'](saveUpdates(_0x1f0f57[_0xfe2e('0x42')],null))['then'](respondWithResult(_0x4a4b55,null))[_0xfe2e('0x3c')](handleError(_0x4a4b55,null));};exports['destroy']=function(_0x2f2766,_0x39cb6b){return db[_0xfe2e('0x38')][_0xfe2e('0x40')]({'where':{'id':_0x2f2766[_0xfe2e('0x3e')]['id']}})[_0xfe2e('0x22')](handleEntityNotFound(_0x39cb6b,null))[_0xfe2e('0x22')](removeEntity(_0x39cb6b,null))['catch'](handleError(_0x39cb6b,null));};exports[_0xfe2e('0x44')]=function(_0x6ebaf8,_0x16de7a){return db[_0xfe2e('0x38')][_0xfe2e('0x45')]({'where':{'id':_0x6ebaf8['query']['ids']||[]},'raw':![],'individualHooks':!![]})[_0xfe2e('0x22')](respondWithResult(_0x16de7a,0xcc))[_0xfe2e('0x3c')](handleError(_0x16de7a,null));};exports['addFields']=function(_0x50fb52,_0x1288ea,_0x5ad342){return db[_0xfe2e('0x46')]['findOne']({'where':{'id':_0x50fb52[_0xfe2e('0x3e')]['id']}})[_0xfe2e('0x22')](handleEntityNotFound(_0x1288ea,null))[_0xfe2e('0x22')](function(_0x22d1da){if(_0x22d1da){return db[_0xfe2e('0x47')]['transaction'](function(_0x178e3e){return db[_0xfe2e('0x38')][_0xfe2e('0x45')]({'where':{'CustomReportId':_0x50fb52[_0xfe2e('0x3e')]['id']},'transaction':_0x178e3e})[_0xfe2e('0x22')](function(_0x136aa2){var _0x598fbc=_['map'](_0x50fb52['body'],function(_0x437f7a){delete _0x437f7a['id'];_0x437f7a['CustomReportId']=_0x50fb52[_0xfe2e('0x3e')]['id'];return _0x437f7a;});return db[_0xfe2e('0x38')][_0xfe2e('0x43')](_0x598fbc,{'transaction':_0x178e3e});});})[_0xfe2e('0x22')](function(){return db[_0xfe2e('0x38')]['findAll']({'where':{'CustomReportId':_0x50fb52[_0xfe2e('0x3e')]['id']}});});}})[_0xfe2e('0x22')](respondWithResult(_0x1288ea,null))[_0xfe2e('0x3c')](handleError(_0x1288ea,null));};