Built motion from commit (unavailable).|2.4.21
[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 _0xb934=['../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject','save','then','error','name','map','AnalyticFieldReport','fieldName','type','model','query','keys','filters','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','VIRTUAL','merge','options','findAll','rows','catch','show','fields','includeAll','include','find','create','body','update','params','destroy','bulkDestroy','ids','addFields','AnalyticCustomReport','findOne','sequelize','transaction','CustomReportId','bulkCreate','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis'];(function(_0x313a38,_0xb30628){var _0x503b6a=function(_0x3a59ff){while(--_0x3a59ff){_0x313a38['push'](_0x313a38['shift']());}};_0x503b6a(++_0xb30628);}(_0xb934,0x92));var _0x4b93=function(_0x38fefb,_0x2b9216){_0x38fefb=_0x38fefb-0x0;var _0x297dee=_0xb934[_0x38fefb];return _0x297dee;};'use strict';var pdf=require(_0x4b93('0x0'));var emlformat=require(_0x4b93('0x1'));var rimraf=require(_0x4b93('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x4b93('0x3'));var rp=require(_0x4b93('0x4'));var moment=require(_0x4b93('0x5'));var BPromise=require(_0x4b93('0x6'));var Mustache=require(_0x4b93('0x7'));var util=require('util');var path=require('path');var sox=require(_0x4b93('0x8'));var csv=require(_0x4b93('0x9'));var ejs=require(_0x4b93('0xa'));var fs=require('fs');var _=require(_0x4b93('0xb'));var squel=require('squel');var crypto=require(_0x4b93('0xc'));var jsforce=require(_0x4b93('0xd'));var deskjs=require(_0x4b93('0xe'));var toCsv=require(_0x4b93('0x9'));var querystring=require(_0x4b93('0xf'));var Papa=require(_0x4b93('0x10'));var Redis=require(_0x4b93('0x11'));var authService=require(_0x4b93('0x12'));var qs=require(_0x4b93('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x4b93('0x14'));var logger=require(_0x4b93('0x15'))(_0x4b93('0x16'));var utils=require(_0x4b93('0x17'));var config=require(_0x4b93('0x18'));var db=require(_0x4b93('0x19'))['db'];function respondWithStatusCode(_0x3098fd,_0x68be2e){_0x68be2e=_0x68be2e||0xcc;return function(_0xae64c){if(_0xae64c){return _0x3098fd[_0x4b93('0x1a')](_0x68be2e);}return _0x3098fd[_0x4b93('0x1b')](_0x68be2e)[_0x4b93('0x1c')]();};}function respondWithResult(_0x332359,_0x3f4db7){_0x3f4db7=_0x3f4db7||0xc8;return function(_0x11dd47){if(_0x11dd47){return _0x332359['status'](_0x3f4db7)[_0x4b93('0x1d')](_0x11dd47);}};}function respondWithFilteredResult(_0x102e58,_0xbc5eb1){return function(_0x53eb43){if(_0x53eb43){var _0x19a9d5=_0x53eb43[_0x4b93('0x1e')],_0x387a16=_0xbc5eb1['offset'],_0x2dac38=_0xbc5eb1[_0x4b93('0x1f')]+_0xbc5eb1[_0x4b93('0x20')],_0x24b583;if(_0x2dac38>=_0x19a9d5){_0x2dac38=_0x19a9d5;_0x24b583=0xc8;}else{_0x24b583=0xce;}_0x102e58['status'](_0x24b583);return _0x102e58['set'](_0x4b93('0x21'),_0x387a16+'-'+_0x2dac38+'/'+_0x19a9d5)[_0x4b93('0x1d')](_0x53eb43);}return null;};}function patchUpdates(_0x12f944){return function(_0x1b17d0){try{jsonpatch[_0x4b93('0x22')](_0x1b17d0,_0x12f944,!![]);}catch(_0xe1f7ff){return BPromise[_0x4b93('0x23')](_0xe1f7ff);}return _0x1b17d0[_0x4b93('0x24')]();};}function saveUpdates(_0x3b5d15,_0x36bf8a){return function(_0x2c750e){if(_0x2c750e){return _0x2c750e['update'](_0x3b5d15)['then'](function(_0x53fd40){return _0x53fd40;});}return null;};}function removeEntity(_0x5d8d87,_0x5b8cd6){return function(_0x15f204){if(_0x15f204){return _0x15f204['destroy']()[_0x4b93('0x25')](function(){_0x5d8d87[_0x4b93('0x1b')](0xcc)[_0x4b93('0x1c')]();});}};}function handleEntityNotFound(_0x3c443b,_0x36c610){return function(_0x135c6a){if(!_0x135c6a){_0x3c443b[_0x4b93('0x1a')](0x194);}return _0x135c6a;};}function handleError(_0x1fc609,_0x4b6b29){_0x4b6b29=_0x4b6b29||0x1f4;return function(_0x5691ba){logger[_0x4b93('0x26')](_0x5691ba['stack']);if(_0x5691ba[_0x4b93('0x27')]){delete _0x5691ba['name'];}_0x1fc609[_0x4b93('0x1b')](_0x4b6b29)['send'](_0x5691ba);};}exports['index']=function(_0x302b93,_0x66df79){var _0x311635={},_0x205e5b={},_0x3e3c0e={'count':0x0,'rows':[]};var _0x287c07=_[_0x4b93('0x28')](db[_0x4b93('0x29')]['rawAttributes'],function(_0x2bff36){return{'name':_0x2bff36[_0x4b93('0x2a')],'type':_0x2bff36[_0x4b93('0x2b')]['key']};});_0x205e5b[_0x4b93('0x2c')]=_['map'](_0x287c07,'name');_0x205e5b[_0x4b93('0x2d')]=_[_0x4b93('0x2e')](_0x302b93[_0x4b93('0x2d')]);_0x205e5b[_0x4b93('0x2f')]=_[_0x4b93('0x30')](_0x205e5b[_0x4b93('0x2c')],_0x205e5b[_0x4b93('0x2d')]);_0x311635[_0x4b93('0x31')]=_[_0x4b93('0x30')](_0x205e5b[_0x4b93('0x2c')],qs['fields'](_0x302b93[_0x4b93('0x2d')]['fields']));_0x311635['attributes']=_0x311635[_0x4b93('0x31')][_0x4b93('0x32')]?_0x311635[_0x4b93('0x31')]:_0x205e5b[_0x4b93('0x2c')];if(!_0x302b93[_0x4b93('0x2d')][_0x4b93('0x33')](_0x4b93('0x34'))){_0x311635[_0x4b93('0x20')]=qs['limit'](_0x302b93[_0x4b93('0x2d')][_0x4b93('0x20')]);_0x311635['offset']=qs['offset'](_0x302b93[_0x4b93('0x2d')][_0x4b93('0x1f')]);}_0x311635[_0x4b93('0x35')]=qs[_0x4b93('0x36')](_0x302b93[_0x4b93('0x2d')]['sort']);_0x311635[_0x4b93('0x37')]=qs[_0x4b93('0x2f')](_[_0x4b93('0x38')](_0x302b93[_0x4b93('0x2d')],_0x205e5b[_0x4b93('0x2f')]));if(_0x302b93[_0x4b93('0x2d')]['filter']){_0x311635['where']=_['merge'](_0x311635['where'],{'$or':_[_0x4b93('0x28')](_0x287c07,function(_0x40cc7a){if(_0x40cc7a['type']!==_0x4b93('0x39')){var _0x3c22bc={};_0x3c22bc[_0x40cc7a[_0x4b93('0x27')]]={'$like':'%'+_0x302b93[_0x4b93('0x2d')]['filter']+'%'};return _0x3c22bc;}})});}_0x311635=_[_0x4b93('0x3a')]({},_0x311635,_0x302b93[_0x4b93('0x3b')]);var _0x558656={'where':_0x311635[_0x4b93('0x37')]};return db['AnalyticFieldReport'][_0x4b93('0x1e')](_0x558656)['then'](function(_0x5d6f72){_0x3e3c0e[_0x4b93('0x1e')]=_0x5d6f72;if(_0x302b93[_0x4b93('0x2d')]['includeAll']){_0x311635['include']=[{'all':!![]}];}return db[_0x4b93('0x29')][_0x4b93('0x3c')](_0x311635);})[_0x4b93('0x25')](function(_0x12e193){_0x3e3c0e[_0x4b93('0x3d')]=_0x12e193;return _0x3e3c0e;})[_0x4b93('0x25')](respondWithFilteredResult(_0x66df79,_0x311635))[_0x4b93('0x3e')](handleError(_0x66df79,null));};exports[_0x4b93('0x3f')]=function(_0x52d56f,_0x2f69d7){var _0x4ff1ea={'raw':![],'where':{'id':_0x52d56f['params']['id']}},_0x10ffff={};_0x10ffff[_0x4b93('0x2c')]=_[_0x4b93('0x2e')](db[_0x4b93('0x29')]['rawAttributes']);_0x10ffff[_0x4b93('0x2d')]=_[_0x4b93('0x2e')](_0x52d56f['query']);_0x10ffff['filters']=_['intersection'](_0x10ffff['model'],_0x10ffff[_0x4b93('0x2d')]);_0x4ff1ea[_0x4b93('0x31')]=_[_0x4b93('0x30')](_0x10ffff[_0x4b93('0x2c')],qs['fields'](_0x52d56f['query'][_0x4b93('0x40')]));_0x4ff1ea[_0x4b93('0x31')]=_0x4ff1ea['attributes'][_0x4b93('0x32')]?_0x4ff1ea[_0x4b93('0x31')]:_0x10ffff['model'];if(_0x52d56f['query'][_0x4b93('0x41')]){_0x4ff1ea[_0x4b93('0x42')]=[{'all':!![]}];}_0x4ff1ea=_[_0x4b93('0x3a')]({},_0x4ff1ea,_0x52d56f[_0x4b93('0x3b')]);return db[_0x4b93('0x29')][_0x4b93('0x43')](_0x4ff1ea)[_0x4b93('0x25')](handleEntityNotFound(_0x2f69d7,null))[_0x4b93('0x25')](respondWithResult(_0x2f69d7,null))['catch'](handleError(_0x2f69d7,null));};exports[_0x4b93('0x44')]=function(_0x16646b,_0x4406d7){return db[_0x4b93('0x29')][_0x4b93('0x44')](_0x16646b[_0x4b93('0x45')],{})[_0x4b93('0x25')](respondWithResult(_0x4406d7,0xc9))['catch'](handleError(_0x4406d7,null));};exports['bulkCreate']=function(_0x30a0f9,_0x159086){return db[_0x4b93('0x29')]['bulkCreate'](_0x30a0f9[_0x4b93('0x45')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x159086,0xc9))['catch'](handleError(_0x159086,null));};exports[_0x4b93('0x46')]=function(_0x5aece5,_0x2afb9f){if(_0x5aece5[_0x4b93('0x45')]['id']){delete _0x5aece5[_0x4b93('0x45')]['id'];}return db[_0x4b93('0x29')][_0x4b93('0x43')]({'where':{'id':_0x5aece5[_0x4b93('0x47')]['id']}})[_0x4b93('0x25')](handleEntityNotFound(_0x2afb9f,null))[_0x4b93('0x25')](saveUpdates(_0x5aece5['body'],null))[_0x4b93('0x25')](respondWithResult(_0x2afb9f,null))[_0x4b93('0x3e')](handleError(_0x2afb9f,null));};exports[_0x4b93('0x48')]=function(_0x46c070,_0x59f0c3){return db[_0x4b93('0x29')][_0x4b93('0x43')]({'where':{'id':_0x46c070[_0x4b93('0x47')]['id']}})[_0x4b93('0x25')](handleEntityNotFound(_0x59f0c3,null))['then'](removeEntity(_0x59f0c3,null))['catch'](handleError(_0x59f0c3,null));};exports[_0x4b93('0x49')]=function(_0x4b7806,_0x127896){return db[_0x4b93('0x29')][_0x4b93('0x48')]({'where':{'id':_0x4b7806[_0x4b93('0x2d')][_0x4b93('0x4a')]||[]},'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x127896,0xcc))[_0x4b93('0x3e')](handleError(_0x127896,null));};exports[_0x4b93('0x4b')]=function(_0x42eb96,_0x5c1d1d,_0x102ecf){return db[_0x4b93('0x4c')][_0x4b93('0x4d')]({'where':{'id':_0x42eb96['params']['id']}})[_0x4b93('0x25')](handleEntityNotFound(_0x5c1d1d,null))[_0x4b93('0x25')](function(_0x545f54){if(_0x545f54){return db[_0x4b93('0x4e')][_0x4b93('0x4f')](function(_0xba645e){return db[_0x4b93('0x29')]['destroy']({'where':{'CustomReportId':_0x42eb96[_0x4b93('0x47')]['id']},'transaction':_0xba645e})[_0x4b93('0x25')](function(_0x26273b){var _0x2a8dd7=_[_0x4b93('0x28')](_0x42eb96[_0x4b93('0x45')],function(_0x107fdb){delete _0x107fdb['id'];_0x107fdb[_0x4b93('0x50')]=_0x42eb96['params']['id'];return _0x107fdb;});return db['AnalyticFieldReport'][_0x4b93('0x51')](_0x2a8dd7,{'transaction':_0xba645e});});})[_0x4b93('0x25')](function(){return db[_0x4b93('0x29')][_0x4b93('0x3c')]({'where':{'CustomReportId':_0x42eb96[_0x4b93('0x47')]['id']}});});}})[_0x4b93('0x25')](respondWithResult(_0x5c1d1d,null))[_0x4b93('0x3e')](handleError(_0x5c1d1d,null));};