Built motion from commit (unavailable).|2.5.9
[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 _0xbc51=['length','hasOwnProperty','nolimit','order','sort','where','pick','filter','options','AnalyticFieldReport','includeAll','findAll','rows','catch','show','params','keys','include','merge','find','create','body','bulkCreate','update','bulkDestroy','destroy','ids','addFields','findOne','sequelize','CustomReportId','html-pdf','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','squel','crypto','jsforce','papaparse','ioredis','../../components/auth/service','../../config/logger','api','../../config/environment','../../mysqldb','status','end','json','count','offset','limit','Content-Range','apply','reject','then','sendStatus','error','name','send','index','map','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields'];(function(_0x5b7f97,_0xdae988){var _0x5769c1=function(_0x478e11){while(--_0x478e11){_0x5b7f97['push'](_0x5b7f97['shift']());}};_0x5769c1(++_0xdae988);}(_0xbc51,0x1a5));var _0x1bc5=function(_0x1d8119,_0xc98f17){_0x1d8119=_0x1d8119-0x0;var _0x3e30f6=_0xbc51[_0x1d8119];return _0x3e30f6;};'use strict';var pdf=require(_0x1bc5('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x1bc5('0x1'));var zipdir=require(_0x1bc5('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x1bc5('0x3'));var moment=require(_0x1bc5('0x4'));var BPromise=require(_0x1bc5('0x5'));var Mustache=require(_0x1bc5('0x6'));var util=require(_0x1bc5('0x7'));var path=require(_0x1bc5('0x8'));var sox=require('sox');var csv=require(_0x1bc5('0x9'));var ejs=require(_0x1bc5('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x1bc5('0xb'));var crypto=require(_0x1bc5('0xc'));var jsforce=require(_0x1bc5('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x1bc5('0x9'));var querystring=require('querystring');var Papa=require(_0x1bc5('0xe'));var Redis=require(_0x1bc5('0xf'));var authService=require(_0x1bc5('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x1bc5('0x11'))(_0x1bc5('0x12'));var utils=require('../../config/utils');var config=require(_0x1bc5('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0x1bc5('0x14'))['db'];function respondWithStatusCode(_0x128c42,_0x1e26d5){_0x1e26d5=_0x1e26d5||0xcc;return function(_0xad1d7d){if(_0xad1d7d){return _0x128c42['sendStatus'](_0x1e26d5);}return _0x128c42[_0x1bc5('0x15')](_0x1e26d5)[_0x1bc5('0x16')]();};}function respondWithResult(_0x8ab625,_0x484c75){_0x484c75=_0x484c75||0xc8;return function(_0x5b75ca){if(_0x5b75ca){return _0x8ab625[_0x1bc5('0x15')](_0x484c75)[_0x1bc5('0x17')](_0x5b75ca);}};}function respondWithFilteredResult(_0x42d1d2,_0x3a390f){return function(_0x139d0f){if(_0x139d0f){var _0x52b6cd=_0x139d0f[_0x1bc5('0x18')],_0x3fbc42=_0x3a390f[_0x1bc5('0x19')],_0x2fe69f=_0x3a390f[_0x1bc5('0x19')]+_0x3a390f[_0x1bc5('0x1a')],_0x1eec88;if(_0x2fe69f>=_0x52b6cd){_0x2fe69f=_0x52b6cd;_0x1eec88=0xc8;}else{_0x1eec88=0xce;}_0x42d1d2[_0x1bc5('0x15')](_0x1eec88);return _0x42d1d2['set'](_0x1bc5('0x1b'),_0x3fbc42+'-'+_0x2fe69f+'/'+_0x52b6cd)[_0x1bc5('0x17')](_0x139d0f);}return null;};}function patchUpdates(_0x5ee9f2){return function(_0x11fb18){try{jsonpatch[_0x1bc5('0x1c')](_0x11fb18,_0x5ee9f2,!![]);}catch(_0x3bf2ae){return BPromise[_0x1bc5('0x1d')](_0x3bf2ae);}return _0x11fb18['save']();};}function saveUpdates(_0x26d33d,_0x5825a6){return function(_0x30e521){if(_0x30e521){return _0x30e521['update'](_0x26d33d)['then'](function(_0x156721){return _0x156721;});}return null;};}function removeEntity(_0x19dc4f,_0x26923f){return function(_0x34fa1a){if(_0x34fa1a){return _0x34fa1a['destroy']()[_0x1bc5('0x1e')](function(){_0x19dc4f['status'](0xcc)[_0x1bc5('0x16')]();});}};}function handleEntityNotFound(_0x45dd78,_0x573eb6){return function(_0x35bbe8){if(!_0x35bbe8){_0x45dd78[_0x1bc5('0x1f')](0x194);}return _0x35bbe8;};}function handleError(_0x1e7d0c,_0x401af2){_0x401af2=_0x401af2||0x1f4;return function(_0x36e4af){logger[_0x1bc5('0x20')](_0x36e4af['stack']);if(_0x36e4af[_0x1bc5('0x21')]){delete _0x36e4af[_0x1bc5('0x21')];}_0x1e7d0c[_0x1bc5('0x15')](_0x401af2)[_0x1bc5('0x22')](_0x36e4af);};}exports[_0x1bc5('0x23')]=function(_0x2d2ffb,_0x344282){var _0x4c8837={},_0x4ac8a3={},_0x237f1c={'count':0x0,'rows':[]};var _0x6f378f=_[_0x1bc5('0x24')](db['AnalyticFieldReport'][_0x1bc5('0x25')],function(_0xfa6bbe){return{'name':_0xfa6bbe[_0x1bc5('0x26')],'type':_0xfa6bbe[_0x1bc5('0x27')][_0x1bc5('0x28')]};});_0x4ac8a3[_0x1bc5('0x29')]=_['map'](_0x6f378f,'name');_0x4ac8a3['query']=_['keys'](_0x2d2ffb[_0x1bc5('0x2a')]);_0x4ac8a3[_0x1bc5('0x2b')]=_[_0x1bc5('0x2c')](_0x4ac8a3['model'],_0x4ac8a3[_0x1bc5('0x2a')]);_0x4c8837[_0x1bc5('0x2d')]=_[_0x1bc5('0x2c')](_0x4ac8a3[_0x1bc5('0x29')],qs[_0x1bc5('0x2e')](_0x2d2ffb[_0x1bc5('0x2a')]['fields']));_0x4c8837[_0x1bc5('0x2d')]=_0x4c8837['attributes'][_0x1bc5('0x2f')]?_0x4c8837[_0x1bc5('0x2d')]:_0x4ac8a3['model'];if(!_0x2d2ffb[_0x1bc5('0x2a')][_0x1bc5('0x30')](_0x1bc5('0x31'))){_0x4c8837[_0x1bc5('0x1a')]=qs[_0x1bc5('0x1a')](_0x2d2ffb['query']['limit']);_0x4c8837[_0x1bc5('0x19')]=qs[_0x1bc5('0x19')](_0x2d2ffb[_0x1bc5('0x2a')]['offset']);}_0x4c8837[_0x1bc5('0x32')]=qs[_0x1bc5('0x33')](_0x2d2ffb[_0x1bc5('0x2a')]['sort']);_0x4c8837[_0x1bc5('0x34')]=qs[_0x1bc5('0x2b')](_[_0x1bc5('0x35')](_0x2d2ffb['query'],_0x4ac8a3[_0x1bc5('0x2b')]),_0x6f378f);if(_0x2d2ffb[_0x1bc5('0x2a')][_0x1bc5('0x36')]){_0x4c8837[_0x1bc5('0x34')]=_['merge'](_0x4c8837[_0x1bc5('0x34')],{'$or':_[_0x1bc5('0x24')](_0x6f378f,function(_0xafa92d){if(_0xafa92d[_0x1bc5('0x27')]!=='VIRTUAL'){var _0x2966ff={};_0x2966ff[_0xafa92d[_0x1bc5('0x21')]]={'$like':'%'+_0x2d2ffb[_0x1bc5('0x2a')]['filter']+'%'};return _0x2966ff;}})});}_0x4c8837=_['merge']({},_0x4c8837,_0x2d2ffb[_0x1bc5('0x37')]);var _0x591538={'where':_0x4c8837[_0x1bc5('0x34')]};return db[_0x1bc5('0x38')]['count'](_0x591538)[_0x1bc5('0x1e')](function(_0x249705){_0x237f1c['count']=_0x249705;if(_0x2d2ffb[_0x1bc5('0x2a')][_0x1bc5('0x39')]){_0x4c8837['include']=[{'all':!![]}];}return db[_0x1bc5('0x38')][_0x1bc5('0x3a')](_0x4c8837);})[_0x1bc5('0x1e')](function(_0x55cf61){_0x237f1c[_0x1bc5('0x3b')]=_0x55cf61;return _0x237f1c;})[_0x1bc5('0x1e')](respondWithFilteredResult(_0x344282,_0x4c8837))[_0x1bc5('0x3c')](handleError(_0x344282,null));};exports[_0x1bc5('0x3d')]=function(_0x458162,_0x5c14e7){var _0x449eec={'raw':![],'where':{'id':_0x458162[_0x1bc5('0x3e')]['id']}},_0x4b40e5={};_0x4b40e5[_0x1bc5('0x29')]=_[_0x1bc5('0x3f')](db[_0x1bc5('0x38')]['rawAttributes']);_0x4b40e5[_0x1bc5('0x2a')]=_[_0x1bc5('0x3f')](_0x458162[_0x1bc5('0x2a')]);_0x4b40e5[_0x1bc5('0x2b')]=_[_0x1bc5('0x2c')](_0x4b40e5[_0x1bc5('0x29')],_0x4b40e5[_0x1bc5('0x2a')]);_0x449eec['attributes']=_['intersection'](_0x4b40e5[_0x1bc5('0x29')],qs['fields'](_0x458162[_0x1bc5('0x2a')][_0x1bc5('0x2e')]));_0x449eec['attributes']=_0x449eec[_0x1bc5('0x2d')][_0x1bc5('0x2f')]?_0x449eec['attributes']:_0x4b40e5['model'];if(_0x458162[_0x1bc5('0x2a')][_0x1bc5('0x39')]){_0x449eec[_0x1bc5('0x40')]=[{'all':!![]}];}_0x449eec=_[_0x1bc5('0x41')]({},_0x449eec,_0x458162[_0x1bc5('0x37')]);return db[_0x1bc5('0x38')][_0x1bc5('0x42')](_0x449eec)[_0x1bc5('0x1e')](handleEntityNotFound(_0x5c14e7,null))['then'](respondWithResult(_0x5c14e7,null))[_0x1bc5('0x3c')](handleError(_0x5c14e7,null));};exports[_0x1bc5('0x43')]=function(_0x518595,_0x38443b){return db[_0x1bc5('0x38')][_0x1bc5('0x43')](_0x518595[_0x1bc5('0x44')],{})[_0x1bc5('0x1e')](respondWithResult(_0x38443b,0xc9))[_0x1bc5('0x3c')](handleError(_0x38443b,null));};exports[_0x1bc5('0x45')]=function(_0x1708b9,_0x542143){return db[_0x1bc5('0x38')][_0x1bc5('0x45')](_0x1708b9[_0x1bc5('0x44')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x542143,0xc9))['catch'](handleError(_0x542143,null));};exports[_0x1bc5('0x46')]=function(_0xbece27,_0x5a922c){if(_0xbece27[_0x1bc5('0x44')]['id']){delete _0xbece27[_0x1bc5('0x44')]['id'];}return db[_0x1bc5('0x38')][_0x1bc5('0x42')]({'where':{'id':_0xbece27[_0x1bc5('0x3e')]['id']}})[_0x1bc5('0x1e')](handleEntityNotFound(_0x5a922c,null))[_0x1bc5('0x1e')](saveUpdates(_0xbece27[_0x1bc5('0x44')],null))[_0x1bc5('0x1e')](respondWithResult(_0x5a922c,null))[_0x1bc5('0x3c')](handleError(_0x5a922c,null));};exports['destroy']=function(_0x4bf1fd,_0x575b8e){return db['AnalyticFieldReport']['find']({'where':{'id':_0x4bf1fd['params']['id']}})[_0x1bc5('0x1e')](handleEntityNotFound(_0x575b8e,null))['then'](removeEntity(_0x575b8e,null))[_0x1bc5('0x3c')](handleError(_0x575b8e,null));};exports[_0x1bc5('0x47')]=function(_0x4bd77b,_0x332be7){return db['AnalyticFieldReport'][_0x1bc5('0x48')]({'where':{'id':_0x4bd77b[_0x1bc5('0x2a')][_0x1bc5('0x49')]||[]},'raw':![],'individualHooks':!![]})[_0x1bc5('0x1e')](respondWithResult(_0x332be7,0xcc))['catch'](handleError(_0x332be7,null));};exports[_0x1bc5('0x4a')]=function(_0x5add2a,_0x578b82,_0x21b64e){return db['AnalyticCustomReport'][_0x1bc5('0x4b')]({'where':{'id':_0x5add2a[_0x1bc5('0x3e')]['id']}})['then'](handleEntityNotFound(_0x578b82,null))['then'](function(_0x55bd53){if(_0x55bd53){return db[_0x1bc5('0x4c')]['transaction'](function(_0x386222){return db['AnalyticFieldReport'][_0x1bc5('0x48')]({'where':{'CustomReportId':_0x5add2a[_0x1bc5('0x3e')]['id']},'transaction':_0x386222})[_0x1bc5('0x1e')](function(_0x3936c2){var _0x2956f9=_['map'](_0x5add2a['body'],function(_0x566275){delete _0x566275['id'];_0x566275[_0x1bc5('0x4d')]=_0x5add2a[_0x1bc5('0x3e')]['id'];return _0x566275;});return db[_0x1bc5('0x38')][_0x1bc5('0x45')](_0x2956f9,{'transaction':_0x386222});});})[_0x1bc5('0x1e')](function(){return db['AnalyticFieldReport'][_0x1bc5('0x3a')]({'where':{'CustomReportId':_0x5add2a[_0x1bc5('0x3e')]['id']}});});}})[_0x1bc5('0x1e')](respondWithResult(_0x578b82,null))[_0x1bc5('0x3c')](handleError(_0x578b82,null));};