Built motion from commit 9d0783e6.|2.6.13
[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 _0x85e7=['map','rawAttributes','fieldName','type','model','filters','intersection','attributes','fields','query','hasOwnProperty','order','sort','where','filter','merge','VIRTUAL','options','includeAll','AnalyticFieldReport','findAll','rows','catch','show','params','keys','include','find','create','body','bulkCreate','destroy','bulkDestroy','ids','addFields','findOne','sequelize','CustomReportId','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','limit','undefined','count','set','Content-Range','apply','update','then','end','error','stack','name','index'];(function(_0x17be49,_0x48e399){var _0x1c9411=function(_0x2ff174){while(--_0x2ff174){_0x17be49['push'](_0x17be49['shift']());}};_0x1c9411(++_0x48e399);}(_0x85e7,0xcc));var _0x785e=function(_0x215488,_0x497875){_0x215488=_0x215488-0x0;var _0x13db01=_0x85e7[_0x215488];return _0x13db01;};'use strict';var emlformat=require(_0x785e('0x0'));var rimraf=require(_0x785e('0x1'));var zipdir=require(_0x785e('0x2'));var jsonpatch=require(_0x785e('0x3'));var rp=require(_0x785e('0x4'));var moment=require(_0x785e('0x5'));var BPromise=require(_0x785e('0x6'));var Mustache=require(_0x785e('0x7'));var util=require(_0x785e('0x8'));var path=require(_0x785e('0x9'));var sox=require(_0x785e('0xa'));var csv=require(_0x785e('0xb'));var ejs=require(_0x785e('0xc'));var fs=require('fs');var fs_extra=require(_0x785e('0xd'));var _=require(_0x785e('0xe'));var squel=require('squel');var crypto=require(_0x785e('0xf'));var jsforce=require(_0x785e('0x10'));var deskjs=require(_0x785e('0x11'));var toCsv=require(_0x785e('0xb'));var querystring=require(_0x785e('0x12'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x785e('0x13'));var qs=require(_0x785e('0x14'));var as=require(_0x785e('0x15'));var hardwareService=require(_0x785e('0x16'));var logger=require(_0x785e('0x17'))('api');var utils=require(_0x785e('0x18'));var config=require(_0x785e('0x19'));var licenseUtil=require(_0x785e('0x1a'));var db=require(_0x785e('0x1b'))['db'];function respondWithStatusCode(_0x141ec4,_0x4cbdc7){_0x4cbdc7=_0x4cbdc7||0xcc;return function(_0x12dd94){if(_0x12dd94){return _0x141ec4[_0x785e('0x1c')](_0x4cbdc7);}return _0x141ec4[_0x785e('0x1d')](_0x4cbdc7)['end']();};}function respondWithResult(_0x174b4f,_0x59497e){_0x59497e=_0x59497e||0xc8;return function(_0x17610f){if(_0x17610f){return _0x174b4f['status'](_0x59497e)[_0x785e('0x1e')](_0x17610f);}};}function respondWithFilteredResult(_0x32fe3f,_0x5dedcb){return function(_0x46b295){if(_0x46b295){var _0x2d77cf=typeof _0x5dedcb[_0x785e('0x1f')]==='undefined'&&typeof _0x5dedcb[_0x785e('0x20')]===_0x785e('0x21');var _0x25d86d=_0x46b295[_0x785e('0x22')];var _0x72066b=_0x2d77cf?0x0:_0x5dedcb['offset'];var _0x52b92a=_0x2d77cf?_0x46b295['count']:_0x5dedcb[_0x785e('0x1f')]+_0x5dedcb[_0x785e('0x20')];var _0xeb34cf;if(_0x52b92a>=_0x25d86d){_0x52b92a=_0x25d86d;_0xeb34cf=0xc8;}else{_0xeb34cf=0xce;}_0x32fe3f[_0x785e('0x1d')](_0xeb34cf);return _0x32fe3f[_0x785e('0x23')](_0x785e('0x24'),_0x72066b+'-'+_0x52b92a+'/'+_0x25d86d)[_0x785e('0x1e')](_0x46b295);}return null;};}function patchUpdates(_0x54f10b){return function(_0x565ee6){try{jsonpatch[_0x785e('0x25')](_0x565ee6,_0x54f10b,!![]);}catch(_0x538828){return BPromise['reject'](_0x538828);}return _0x565ee6['save']();};}function saveUpdates(_0x154870,_0x13cf70){return function(_0x5aadf9){if(_0x5aadf9){return _0x5aadf9[_0x785e('0x26')](_0x154870)[_0x785e('0x27')](function(_0xd7ec06){return _0xd7ec06;});}return null;};}function removeEntity(_0x1bf307,_0x18198c){return function(_0x498ed4){if(_0x498ed4){return _0x498ed4['destroy']()[_0x785e('0x27')](function(){_0x1bf307['status'](0xcc)[_0x785e('0x28')]();});}};}function handleEntityNotFound(_0x249af1,_0x254b54){return function(_0xffa6b3){if(!_0xffa6b3){_0x249af1[_0x785e('0x1c')](0x194);}return _0xffa6b3;};}function handleError(_0x2f9522,_0x34e906){_0x34e906=_0x34e906||0x1f4;return function(_0x40a2c4){logger[_0x785e('0x29')](_0x40a2c4[_0x785e('0x2a')]);if(_0x40a2c4['name']){delete _0x40a2c4[_0x785e('0x2b')];}_0x2f9522['status'](_0x34e906)['send'](_0x40a2c4);};}exports[_0x785e('0x2c')]=function(_0x256d0d,_0x2081d5){var _0x4aa5a4={},_0x43b850={},_0x14a09c={'count':0x0,'rows':[]};var _0x5753a0=_[_0x785e('0x2d')](db['AnalyticFieldReport'][_0x785e('0x2e')],function(_0x4761c6){return{'name':_0x4761c6[_0x785e('0x2f')],'type':_0x4761c6[_0x785e('0x30')]['key']};});_0x43b850[_0x785e('0x31')]=_['map'](_0x5753a0,_0x785e('0x2b'));_0x43b850['query']=_['keys'](_0x256d0d['query']);_0x43b850[_0x785e('0x32')]=_[_0x785e('0x33')](_0x43b850[_0x785e('0x31')],_0x43b850['query']);_0x4aa5a4[_0x785e('0x34')]=_[_0x785e('0x33')](_0x43b850[_0x785e('0x31')],qs[_0x785e('0x35')](_0x256d0d['query'][_0x785e('0x35')]));_0x4aa5a4[_0x785e('0x34')]=_0x4aa5a4[_0x785e('0x34')]['length']?_0x4aa5a4[_0x785e('0x34')]:_0x43b850[_0x785e('0x31')];if(!_0x256d0d[_0x785e('0x36')][_0x785e('0x37')]('nolimit')){_0x4aa5a4[_0x785e('0x20')]=qs['limit'](_0x256d0d[_0x785e('0x36')][_0x785e('0x20')]);_0x4aa5a4['offset']=qs[_0x785e('0x1f')](_0x256d0d[_0x785e('0x36')]['offset']);}_0x4aa5a4[_0x785e('0x38')]=qs[_0x785e('0x39')](_0x256d0d[_0x785e('0x36')][_0x785e('0x39')]);_0x4aa5a4[_0x785e('0x3a')]=qs[_0x785e('0x32')](_['pick'](_0x256d0d['query'],_0x43b850['filters']),_0x5753a0);if(_0x256d0d[_0x785e('0x36')][_0x785e('0x3b')]){_0x4aa5a4[_0x785e('0x3a')]=_[_0x785e('0x3c')](_0x4aa5a4[_0x785e('0x3a')],{'$or':_[_0x785e('0x2d')](_0x5753a0,function(_0x197f56){if(_0x197f56[_0x785e('0x30')]!==_0x785e('0x3d')){var _0x172061={};_0x172061[_0x197f56['name']]={'$like':'%'+_0x256d0d[_0x785e('0x36')][_0x785e('0x3b')]+'%'};return _0x172061;}})});}_0x4aa5a4=_[_0x785e('0x3c')]({},_0x4aa5a4,_0x256d0d[_0x785e('0x3e')]);var _0x204b47={'where':_0x4aa5a4[_0x785e('0x3a')]};return db['AnalyticFieldReport'][_0x785e('0x22')](_0x204b47)[_0x785e('0x27')](function(_0x4104b2){_0x14a09c['count']=_0x4104b2;if(_0x256d0d[_0x785e('0x36')][_0x785e('0x3f')]){_0x4aa5a4['include']=[{'all':!![]}];}return db[_0x785e('0x40')][_0x785e('0x41')](_0x4aa5a4);})['then'](function(_0x3d735e){_0x14a09c[_0x785e('0x42')]=_0x3d735e;return _0x14a09c;})[_0x785e('0x27')](respondWithFilteredResult(_0x2081d5,_0x4aa5a4))[_0x785e('0x43')](handleError(_0x2081d5,null));};exports[_0x785e('0x44')]=function(_0x2e92b8,_0x328624){var _0x11929f={'raw':![],'where':{'id':_0x2e92b8[_0x785e('0x45')]['id']}},_0x489905={};_0x489905[_0x785e('0x31')]=_[_0x785e('0x46')](db['AnalyticFieldReport'][_0x785e('0x2e')]);_0x489905['query']=_['keys'](_0x2e92b8['query']);_0x489905[_0x785e('0x32')]=_[_0x785e('0x33')](_0x489905['model'],_0x489905[_0x785e('0x36')]);_0x11929f['attributes']=_[_0x785e('0x33')](_0x489905['model'],qs['fields'](_0x2e92b8[_0x785e('0x36')][_0x785e('0x35')]));_0x11929f['attributes']=_0x11929f[_0x785e('0x34')]['length']?_0x11929f[_0x785e('0x34')]:_0x489905[_0x785e('0x31')];if(_0x2e92b8[_0x785e('0x36')][_0x785e('0x3f')]){_0x11929f[_0x785e('0x47')]=[{'all':!![]}];}_0x11929f=_['merge']({},_0x11929f,_0x2e92b8['options']);return db[_0x785e('0x40')][_0x785e('0x48')](_0x11929f)[_0x785e('0x27')](handleEntityNotFound(_0x328624,null))[_0x785e('0x27')](respondWithResult(_0x328624,null))['catch'](handleError(_0x328624,null));};exports[_0x785e('0x49')]=function(_0x3a9e3e,_0x57bb16){return db[_0x785e('0x40')][_0x785e('0x49')](_0x3a9e3e[_0x785e('0x4a')],{})[_0x785e('0x27')](respondWithResult(_0x57bb16,0xc9))[_0x785e('0x43')](handleError(_0x57bb16,null));};exports['bulkCreate']=function(_0x469f74,_0x498fd9){return db[_0x785e('0x40')][_0x785e('0x4b')](_0x469f74[_0x785e('0x4a')],{'raw':![],'individualHooks':!![]})[_0x785e('0x27')](respondWithResult(_0x498fd9,0xc9))[_0x785e('0x43')](handleError(_0x498fd9,null));};exports['update']=function(_0x3a6fbf,_0x26e56a){if(_0x3a6fbf[_0x785e('0x4a')]['id']){delete _0x3a6fbf[_0x785e('0x4a')]['id'];}return db['AnalyticFieldReport']['find']({'where':{'id':_0x3a6fbf[_0x785e('0x45')]['id']}})[_0x785e('0x27')](handleEntityNotFound(_0x26e56a,null))['then'](saveUpdates(_0x3a6fbf[_0x785e('0x4a')],null))[_0x785e('0x27')](respondWithResult(_0x26e56a,null))[_0x785e('0x43')](handleError(_0x26e56a,null));};exports[_0x785e('0x4c')]=function(_0x3b09ba,_0x40fea8){return db[_0x785e('0x40')]['find']({'where':{'id':_0x3b09ba[_0x785e('0x45')]['id']}})[_0x785e('0x27')](handleEntityNotFound(_0x40fea8,null))[_0x785e('0x27')](removeEntity(_0x40fea8,null))[_0x785e('0x43')](handleError(_0x40fea8,null));};exports[_0x785e('0x4d')]=function(_0xbd09a,_0x479c5e){return db[_0x785e('0x40')][_0x785e('0x4c')]({'where':{'id':_0xbd09a[_0x785e('0x36')][_0x785e('0x4e')]||[]},'raw':![],'individualHooks':!![]})[_0x785e('0x27')](respondWithResult(_0x479c5e,0xcc))[_0x785e('0x43')](handleError(_0x479c5e,null));};exports[_0x785e('0x4f')]=function(_0x30f038,_0x24e51f,_0x188d7a){return db['AnalyticCustomReport'][_0x785e('0x50')]({'where':{'id':_0x30f038[_0x785e('0x45')]['id']}})['then'](handleEntityNotFound(_0x24e51f,null))['then'](function(_0x3a3120){if(_0x3a3120){return db[_0x785e('0x51')]['transaction'](function(_0x3e7536){return db[_0x785e('0x40')][_0x785e('0x4c')]({'where':{'CustomReportId':_0x30f038[_0x785e('0x45')]['id']},'transaction':_0x3e7536})[_0x785e('0x27')](function(_0x4c7b73){var _0x3f021d=_[_0x785e('0x2d')](_0x30f038[_0x785e('0x4a')],function(_0x1dc654){delete _0x1dc654['id'];_0x1dc654[_0x785e('0x52')]=_0x30f038[_0x785e('0x45')]['id'];return _0x1dc654;});return db[_0x785e('0x40')]['bulkCreate'](_0x3f021d,{'transaction':_0x3e7536});});})[_0x785e('0x27')](function(){return db['AnalyticFieldReport'][_0x785e('0x41')]({'where':{'CustomReportId':_0x30f038[_0x785e('0x45')]['id']}});});}})[_0x785e('0x27')](respondWithResult(_0x24e51f,null))['catch'](handleError(_0x24e51f,null));};