Built motion from commit 43538d75.|2.5.35
[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 _0xb0db=['lodash','squel','crypto','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','save','update','then','destroy','end','error','stack','name','send','index','map','rawAttributes','fieldName','type','model','query','keys','attributes','intersection','fields','nolimit','order','sort','where','filters','filter','merge','options','AnalyticFieldReport','includeAll','findAll','rows','catch','length','include','create','bulkCreate','body','find','params','bulkDestroy','ids','addFields','findOne','sequelize','transaction','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs'];(function(_0x49626c,_0x25d3d0){var _0x1979b6=function(_0x50e9e7){while(--_0x50e9e7){_0x49626c['push'](_0x49626c['shift']());}};_0x1979b6(++_0x25d3d0);}(_0xb0db,0x140));var _0xbb0d=function(_0x3d039f,_0x3aff90){_0x3d039f=_0x3d039f-0x0;var _0xc1069a=_0xb0db[_0x3d039f];return _0xc1069a;};'use strict';var emlformat=require(_0xbb0d('0x0'));var rimraf=require(_0xbb0d('0x1'));var zipdir=require(_0xbb0d('0x2'));var jsonpatch=require(_0xbb0d('0x3'));var rp=require(_0xbb0d('0x4'));var moment=require(_0xbb0d('0x5'));var BPromise=require(_0xbb0d('0x6'));var Mustache=require(_0xbb0d('0x7'));var util=require(_0xbb0d('0x8'));var path=require(_0xbb0d('0x9'));var sox=require('sox');var csv=require(_0xbb0d('0xa'));var ejs=require(_0xbb0d('0xb'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xbb0d('0xc'));var squel=require(_0xbb0d('0xd'));var crypto=require(_0xbb0d('0xe'));var jsforce=require('jsforce');var deskjs=require(_0xbb0d('0xf'));var toCsv=require(_0xbb0d('0xa'));var querystring=require('querystring');var Papa=require(_0xbb0d('0x10'));var Redis=require(_0xbb0d('0x11'));var authService=require(_0xbb0d('0x12'));var qs=require(_0xbb0d('0x13'));var as=require(_0xbb0d('0x14'));var hardwareService=require(_0xbb0d('0x15'));var logger=require(_0xbb0d('0x16'))(_0xbb0d('0x17'));var utils=require('../../config/utils');var config=require(_0xbb0d('0x18'));var licenseUtil=require(_0xbb0d('0x19'));var db=require(_0xbb0d('0x1a'))['db'];function respondWithStatusCode(_0x528a09,_0x1307ba){_0x1307ba=_0x1307ba||0xcc;return function(_0x54d24e){if(_0x54d24e){return _0x528a09[_0xbb0d('0x1b')](_0x1307ba);}return _0x528a09[_0xbb0d('0x1c')](_0x1307ba)['end']();};}function respondWithResult(_0x15dc4e,_0x414075){_0x414075=_0x414075||0xc8;return function(_0x29f80b){if(_0x29f80b){return _0x15dc4e[_0xbb0d('0x1c')](_0x414075)[_0xbb0d('0x1d')](_0x29f80b);}};}function respondWithFilteredResult(_0x50b404,_0x435e25){return function(_0x12786){if(_0x12786){var _0xd67eed=typeof _0x435e25[_0xbb0d('0x1e')]===_0xbb0d('0x1f')&&typeof _0x435e25[_0xbb0d('0x20')]===_0xbb0d('0x1f');var _0x4ccc15=_0x12786[_0xbb0d('0x21')];var _0x16ab47=_0xd67eed?0x0:_0x435e25[_0xbb0d('0x1e')];var _0x45b2d8=_0xd67eed?_0x12786['count']:_0x435e25['offset']+_0x435e25[_0xbb0d('0x20')];var _0x19a0cc;if(_0x45b2d8>=_0x4ccc15){_0x45b2d8=_0x4ccc15;_0x19a0cc=0xc8;}else{_0x19a0cc=0xce;}_0x50b404['status'](_0x19a0cc);return _0x50b404[_0xbb0d('0x22')](_0xbb0d('0x23'),_0x16ab47+'-'+_0x45b2d8+'/'+_0x4ccc15)[_0xbb0d('0x1d')](_0x12786);}return null;};}function patchUpdates(_0x51d84c){return function(_0x3908e1){try{jsonpatch[_0xbb0d('0x24')](_0x3908e1,_0x51d84c,!![]);}catch(_0x3075d0){return BPromise['reject'](_0x3075d0);}return _0x3908e1[_0xbb0d('0x25')]();};}function saveUpdates(_0x196ff5,_0x422b81){return function(_0x5d22ca){if(_0x5d22ca){return _0x5d22ca[_0xbb0d('0x26')](_0x196ff5)[_0xbb0d('0x27')](function(_0x4908e6){return _0x4908e6;});}return null;};}function removeEntity(_0x396963,_0x1257c0){return function(_0x11e6ba){if(_0x11e6ba){return _0x11e6ba[_0xbb0d('0x28')]()[_0xbb0d('0x27')](function(){_0x396963[_0xbb0d('0x1c')](0xcc)[_0xbb0d('0x29')]();});}};}function handleEntityNotFound(_0x5a87c8,_0x2c88ad){return function(_0x37a9ed){if(!_0x37a9ed){_0x5a87c8[_0xbb0d('0x1b')](0x194);}return _0x37a9ed;};}function handleError(_0x43aaeb,_0x40b445){_0x40b445=_0x40b445||0x1f4;return function(_0x1fd541){logger[_0xbb0d('0x2a')](_0x1fd541[_0xbb0d('0x2b')]);if(_0x1fd541[_0xbb0d('0x2c')]){delete _0x1fd541[_0xbb0d('0x2c')];}_0x43aaeb[_0xbb0d('0x1c')](_0x40b445)[_0xbb0d('0x2d')](_0x1fd541);};}exports[_0xbb0d('0x2e')]=function(_0x2c4a26,_0x5292d8){var _0x5c20d0={},_0x43a0ec={},_0x2f517e={'count':0x0,'rows':[]};var _0x125318=_[_0xbb0d('0x2f')](db['AnalyticFieldReport'][_0xbb0d('0x30')],function(_0x1b0af2){return{'name':_0x1b0af2[_0xbb0d('0x31')],'type':_0x1b0af2[_0xbb0d('0x32')]['key']};});_0x43a0ec[_0xbb0d('0x33')]=_[_0xbb0d('0x2f')](_0x125318,_0xbb0d('0x2c'));_0x43a0ec[_0xbb0d('0x34')]=_[_0xbb0d('0x35')](_0x2c4a26[_0xbb0d('0x34')]);_0x43a0ec['filters']=_['intersection'](_0x43a0ec['model'],_0x43a0ec['query']);_0x5c20d0[_0xbb0d('0x36')]=_[_0xbb0d('0x37')](_0x43a0ec['model'],qs[_0xbb0d('0x38')](_0x2c4a26[_0xbb0d('0x34')][_0xbb0d('0x38')]));_0x5c20d0[_0xbb0d('0x36')]=_0x5c20d0[_0xbb0d('0x36')]['length']?_0x5c20d0[_0xbb0d('0x36')]:_0x43a0ec[_0xbb0d('0x33')];if(!_0x2c4a26[_0xbb0d('0x34')]['hasOwnProperty'](_0xbb0d('0x39'))){_0x5c20d0[_0xbb0d('0x20')]=qs[_0xbb0d('0x20')](_0x2c4a26[_0xbb0d('0x34')]['limit']);_0x5c20d0[_0xbb0d('0x1e')]=qs[_0xbb0d('0x1e')](_0x2c4a26[_0xbb0d('0x34')]['offset']);}_0x5c20d0[_0xbb0d('0x3a')]=qs[_0xbb0d('0x3b')](_0x2c4a26['query'][_0xbb0d('0x3b')]);_0x5c20d0[_0xbb0d('0x3c')]=qs[_0xbb0d('0x3d')](_['pick'](_0x2c4a26[_0xbb0d('0x34')],_0x43a0ec['filters']),_0x125318);if(_0x2c4a26[_0xbb0d('0x34')][_0xbb0d('0x3e')]){_0x5c20d0[_0xbb0d('0x3c')]=_[_0xbb0d('0x3f')](_0x5c20d0[_0xbb0d('0x3c')],{'$or':_[_0xbb0d('0x2f')](_0x125318,function(_0x122d52){if(_0x122d52[_0xbb0d('0x32')]!=='VIRTUAL'){var _0x54a4dc={};_0x54a4dc[_0x122d52[_0xbb0d('0x2c')]]={'$like':'%'+_0x2c4a26[_0xbb0d('0x34')][_0xbb0d('0x3e')]+'%'};return _0x54a4dc;}})});}_0x5c20d0=_[_0xbb0d('0x3f')]({},_0x5c20d0,_0x2c4a26[_0xbb0d('0x40')]);var _0x2d1a7c={'where':_0x5c20d0[_0xbb0d('0x3c')]};return db[_0xbb0d('0x41')]['count'](_0x2d1a7c)['then'](function(_0x128fa8){_0x2f517e[_0xbb0d('0x21')]=_0x128fa8;if(_0x2c4a26['query'][_0xbb0d('0x42')]){_0x5c20d0['include']=[{'all':!![]}];}return db[_0xbb0d('0x41')][_0xbb0d('0x43')](_0x5c20d0);})['then'](function(_0x56936a){_0x2f517e[_0xbb0d('0x44')]=_0x56936a;return _0x2f517e;})[_0xbb0d('0x27')](respondWithFilteredResult(_0x5292d8,_0x5c20d0))[_0xbb0d('0x45')](handleError(_0x5292d8,null));};exports['show']=function(_0x55469f,_0x1e7d22){var _0x575fdd={'raw':![],'where':{'id':_0x55469f['params']['id']}},_0x4a68bf={};_0x4a68bf[_0xbb0d('0x33')]=_[_0xbb0d('0x35')](db[_0xbb0d('0x41')][_0xbb0d('0x30')]);_0x4a68bf[_0xbb0d('0x34')]=_[_0xbb0d('0x35')](_0x55469f[_0xbb0d('0x34')]);_0x4a68bf['filters']=_['intersection'](_0x4a68bf[_0xbb0d('0x33')],_0x4a68bf[_0xbb0d('0x34')]);_0x575fdd[_0xbb0d('0x36')]=_['intersection'](_0x4a68bf['model'],qs[_0xbb0d('0x38')](_0x55469f[_0xbb0d('0x34')][_0xbb0d('0x38')]));_0x575fdd[_0xbb0d('0x36')]=_0x575fdd['attributes'][_0xbb0d('0x46')]?_0x575fdd[_0xbb0d('0x36')]:_0x4a68bf[_0xbb0d('0x33')];if(_0x55469f['query']['includeAll']){_0x575fdd[_0xbb0d('0x47')]=[{'all':!![]}];}_0x575fdd=_[_0xbb0d('0x3f')]({},_0x575fdd,_0x55469f[_0xbb0d('0x40')]);return db['AnalyticFieldReport']['find'](_0x575fdd)[_0xbb0d('0x27')](handleEntityNotFound(_0x1e7d22,null))['then'](respondWithResult(_0x1e7d22,null))['catch'](handleError(_0x1e7d22,null));};exports['create']=function(_0x1efc7a,_0x16324c){return db[_0xbb0d('0x41')][_0xbb0d('0x48')](_0x1efc7a['body'],{})['then'](respondWithResult(_0x16324c,0xc9))['catch'](handleError(_0x16324c,null));};exports[_0xbb0d('0x49')]=function(_0x19595a,_0x171765){return db['AnalyticFieldReport'][_0xbb0d('0x49')](_0x19595a[_0xbb0d('0x4a')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x171765,0xc9))[_0xbb0d('0x45')](handleError(_0x171765,null));};exports[_0xbb0d('0x26')]=function(_0x58259a,_0x58abd3){if(_0x58259a[_0xbb0d('0x4a')]['id']){delete _0x58259a[_0xbb0d('0x4a')]['id'];}return db['AnalyticFieldReport'][_0xbb0d('0x4b')]({'where':{'id':_0x58259a[_0xbb0d('0x4c')]['id']}})['then'](handleEntityNotFound(_0x58abd3,null))['then'](saveUpdates(_0x58259a[_0xbb0d('0x4a')],null))[_0xbb0d('0x27')](respondWithResult(_0x58abd3,null))[_0xbb0d('0x45')](handleError(_0x58abd3,null));};exports[_0xbb0d('0x28')]=function(_0x5c0fe1,_0x24a133){return db[_0xbb0d('0x41')][_0xbb0d('0x4b')]({'where':{'id':_0x5c0fe1['params']['id']}})[_0xbb0d('0x27')](handleEntityNotFound(_0x24a133,null))[_0xbb0d('0x27')](removeEntity(_0x24a133,null))[_0xbb0d('0x45')](handleError(_0x24a133,null));};exports[_0xbb0d('0x4d')]=function(_0x2808ee,_0x3596bc){return db[_0xbb0d('0x41')][_0xbb0d('0x28')]({'where':{'id':_0x2808ee[_0xbb0d('0x34')][_0xbb0d('0x4e')]||[]},'raw':![],'individualHooks':!![]})[_0xbb0d('0x27')](respondWithResult(_0x3596bc,0xcc))[_0xbb0d('0x45')](handleError(_0x3596bc,null));};exports[_0xbb0d('0x4f')]=function(_0x5dc8a3,_0x447ecf,_0x46e1ba){return db['AnalyticCustomReport'][_0xbb0d('0x50')]({'where':{'id':_0x5dc8a3['params']['id']}})['then'](handleEntityNotFound(_0x447ecf,null))[_0xbb0d('0x27')](function(_0x56b44e){if(_0x56b44e){return db[_0xbb0d('0x51')][_0xbb0d('0x52')](function(_0x51d1fe){return db[_0xbb0d('0x41')][_0xbb0d('0x28')]({'where':{'CustomReportId':_0x5dc8a3[_0xbb0d('0x4c')]['id']},'transaction':_0x51d1fe})['then'](function(_0x1d7cbe){var _0x1e49a5=_[_0xbb0d('0x2f')](_0x5dc8a3['body'],function(_0x46275c){delete _0x46275c['id'];_0x46275c['CustomReportId']=_0x5dc8a3[_0xbb0d('0x4c')]['id'];return _0x46275c;});return db[_0xbb0d('0x41')][_0xbb0d('0x49')](_0x1e49a5,{'transaction':_0x51d1fe});});})['then'](function(){return db[_0xbb0d('0x41')][_0xbb0d('0x43')]({'where':{'CustomReportId':_0x5dc8a3[_0xbb0d('0x4c')]['id']}});});}})[_0xbb0d('0x27')](respondWithResult(_0x447ecf,null))[_0xbb0d('0x45')](handleError(_0x447ecf,null));};