Built motion from commit 87cd5f02.|2.5.48
[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 _0xd686=['rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','sox','ejs','fs-extra','lodash','squel','jsforce','desk.js','to-csv','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','save','destroy','then','error','stack','name','send','index','map','AnalyticFieldReport','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','nolimit','order','sort','where','pick','filter','merge','options','includeAll','include','findAll','rows','catch','params','keys','rawAttributes','create','bulkCreate','body','find','bulkDestroy','AnalyticCustomReport','findOne','sequelize','CustomReportId','eml-format'];(function(_0x50e51a,_0x39e949){var _0xe02402=function(_0xbc177a){while(--_0xbc177a){_0x50e51a['push'](_0x50e51a['shift']());}};_0xe02402(++_0x39e949);}(_0xd686,0xf2));var _0x6d68=function(_0x23b655,_0x4feb2b){_0x23b655=_0x23b655-0x0;var _0x364b32=_0xd686[_0x23b655];return _0x364b32;};'use strict';var emlformat=require(_0x6d68('0x0'));var rimraf=require(_0x6d68('0x1'));var zipdir=require(_0x6d68('0x2'));var jsonpatch=require(_0x6d68('0x3'));var rp=require(_0x6d68('0x4'));var moment=require('moment');var BPromise=require(_0x6d68('0x5'));var Mustache=require(_0x6d68('0x6'));var util=require(_0x6d68('0x7'));var path=require('path');var sox=require(_0x6d68('0x8'));var csv=require('to-csv');var ejs=require(_0x6d68('0x9'));var fs=require('fs');var fs_extra=require(_0x6d68('0xa'));var _=require(_0x6d68('0xb'));var squel=require(_0x6d68('0xc'));var crypto=require('crypto');var jsforce=require(_0x6d68('0xd'));var deskjs=require(_0x6d68('0xe'));var toCsv=require(_0x6d68('0xf'));var querystring=require(_0x6d68('0x10'));var Papa=require(_0x6d68('0x11'));var Redis=require('ioredis');var authService=require(_0x6d68('0x12'));var qs=require(_0x6d68('0x13'));var as=require(_0x6d68('0x14'));var hardwareService=require(_0x6d68('0x15'));var logger=require(_0x6d68('0x16'))(_0x6d68('0x17'));var utils=require(_0x6d68('0x18'));var config=require('../../config/environment');var licenseUtil=require(_0x6d68('0x19'));var db=require(_0x6d68('0x1a'))['db'];function respondWithStatusCode(_0x315055,_0x2177e0){_0x2177e0=_0x2177e0||0xcc;return function(_0x2ed280){if(_0x2ed280){return _0x315055[_0x6d68('0x1b')](_0x2177e0);}return _0x315055[_0x6d68('0x1c')](_0x2177e0)[_0x6d68('0x1d')]();};}function respondWithResult(_0x237cc2,_0xca0280){_0xca0280=_0xca0280||0xc8;return function(_0x109b1c){if(_0x109b1c){return _0x237cc2[_0x6d68('0x1c')](_0xca0280)[_0x6d68('0x1e')](_0x109b1c);}};}function respondWithFilteredResult(_0x99d07d,_0x274b31){return function(_0x5de209){if(_0x5de209){var _0x22ae49=typeof _0x274b31[_0x6d68('0x1f')]===_0x6d68('0x20')&&typeof _0x274b31[_0x6d68('0x21')]==='undefined';var _0x5f7d2d=_0x5de209[_0x6d68('0x22')];var _0x38d2db=_0x22ae49?0x0:_0x274b31['offset'];var _0x5725e9=_0x22ae49?_0x5de209[_0x6d68('0x22')]:_0x274b31[_0x6d68('0x1f')]+_0x274b31[_0x6d68('0x21')];var _0x425c87;if(_0x5725e9>=_0x5f7d2d){_0x5725e9=_0x5f7d2d;_0x425c87=0xc8;}else{_0x425c87=0xce;}_0x99d07d[_0x6d68('0x1c')](_0x425c87);return _0x99d07d[_0x6d68('0x23')]('Content-Range',_0x38d2db+'-'+_0x5725e9+'/'+_0x5f7d2d)[_0x6d68('0x1e')](_0x5de209);}return null;};}function patchUpdates(_0x4798b1){return function(_0x147eb3){try{jsonpatch['apply'](_0x147eb3,_0x4798b1,!![]);}catch(_0x48b18a){return BPromise['reject'](_0x48b18a);}return _0x147eb3[_0x6d68('0x24')]();};}function saveUpdates(_0xcbe0af,_0x3371ae){return function(_0x2de9b1){if(_0x2de9b1){return _0x2de9b1['update'](_0xcbe0af)['then'](function(_0x533c8b){return _0x533c8b;});}return null;};}function removeEntity(_0x599c39,_0x2d2390){return function(_0x370438){if(_0x370438){return _0x370438[_0x6d68('0x25')]()[_0x6d68('0x26')](function(){_0x599c39[_0x6d68('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x443fe1,_0x57413a){return function(_0x3ffc8f){if(!_0x3ffc8f){_0x443fe1['sendStatus'](0x194);}return _0x3ffc8f;};}function handleError(_0x21da89,_0xede860){_0xede860=_0xede860||0x1f4;return function(_0x446bb9){logger[_0x6d68('0x27')](_0x446bb9[_0x6d68('0x28')]);if(_0x446bb9['name']){delete _0x446bb9[_0x6d68('0x29')];}_0x21da89[_0x6d68('0x1c')](_0xede860)[_0x6d68('0x2a')](_0x446bb9);};}exports[_0x6d68('0x2b')]=function(_0x34d124,_0x2bf051){var _0x249ce9={},_0x84cf08={},_0x244e9c={'count':0x0,'rows':[]};var _0x609a63=_[_0x6d68('0x2c')](db[_0x6d68('0x2d')]['rawAttributes'],function(_0x1088bd){return{'name':_0x1088bd[_0x6d68('0x2e')],'type':_0x1088bd[_0x6d68('0x2f')][_0x6d68('0x30')]};});_0x84cf08[_0x6d68('0x31')]=_[_0x6d68('0x2c')](_0x609a63,'name');_0x84cf08[_0x6d68('0x32')]=_['keys'](_0x34d124[_0x6d68('0x32')]);_0x84cf08[_0x6d68('0x33')]=_[_0x6d68('0x34')](_0x84cf08[_0x6d68('0x31')],_0x84cf08[_0x6d68('0x32')]);_0x249ce9[_0x6d68('0x35')]=_['intersection'](_0x84cf08[_0x6d68('0x31')],qs[_0x6d68('0x36')](_0x34d124['query'][_0x6d68('0x36')]));_0x249ce9[_0x6d68('0x35')]=_0x249ce9['attributes'][_0x6d68('0x37')]?_0x249ce9[_0x6d68('0x35')]:_0x84cf08[_0x6d68('0x31')];if(!_0x34d124[_0x6d68('0x32')]['hasOwnProperty'](_0x6d68('0x38'))){_0x249ce9[_0x6d68('0x21')]=qs[_0x6d68('0x21')](_0x34d124[_0x6d68('0x32')][_0x6d68('0x21')]);_0x249ce9[_0x6d68('0x1f')]=qs[_0x6d68('0x1f')](_0x34d124[_0x6d68('0x32')][_0x6d68('0x1f')]);}_0x249ce9[_0x6d68('0x39')]=qs['sort'](_0x34d124[_0x6d68('0x32')][_0x6d68('0x3a')]);_0x249ce9[_0x6d68('0x3b')]=qs['filters'](_[_0x6d68('0x3c')](_0x34d124[_0x6d68('0x32')],_0x84cf08[_0x6d68('0x33')]),_0x609a63);if(_0x34d124[_0x6d68('0x32')][_0x6d68('0x3d')]){_0x249ce9['where']=_[_0x6d68('0x3e')](_0x249ce9[_0x6d68('0x3b')],{'$or':_[_0x6d68('0x2c')](_0x609a63,function(_0x48bcd7){if(_0x48bcd7[_0x6d68('0x2f')]!=='VIRTUAL'){var _0x2fc39c={};_0x2fc39c[_0x48bcd7['name']]={'$like':'%'+_0x34d124[_0x6d68('0x32')][_0x6d68('0x3d')]+'%'};return _0x2fc39c;}})});}_0x249ce9=_[_0x6d68('0x3e')]({},_0x249ce9,_0x34d124[_0x6d68('0x3f')]);var _0x4f329c={'where':_0x249ce9['where']};return db[_0x6d68('0x2d')][_0x6d68('0x22')](_0x4f329c)['then'](function(_0x59749b){_0x244e9c[_0x6d68('0x22')]=_0x59749b;if(_0x34d124['query'][_0x6d68('0x40')]){_0x249ce9[_0x6d68('0x41')]=[{'all':!![]}];}return db['AnalyticFieldReport'][_0x6d68('0x42')](_0x249ce9);})[_0x6d68('0x26')](function(_0x477cde){_0x244e9c[_0x6d68('0x43')]=_0x477cde;return _0x244e9c;})[_0x6d68('0x26')](respondWithFilteredResult(_0x2bf051,_0x249ce9))[_0x6d68('0x44')](handleError(_0x2bf051,null));};exports['show']=function(_0x1b8089,_0x31c553){var _0x30ed30={'raw':![],'where':{'id':_0x1b8089[_0x6d68('0x45')]['id']}},_0x2d33bb={};_0x2d33bb[_0x6d68('0x31')]=_[_0x6d68('0x46')](db[_0x6d68('0x2d')][_0x6d68('0x47')]);_0x2d33bb[_0x6d68('0x32')]=_[_0x6d68('0x46')](_0x1b8089[_0x6d68('0x32')]);_0x2d33bb['filters']=_[_0x6d68('0x34')](_0x2d33bb[_0x6d68('0x31')],_0x2d33bb['query']);_0x30ed30['attributes']=_[_0x6d68('0x34')](_0x2d33bb[_0x6d68('0x31')],qs[_0x6d68('0x36')](_0x1b8089[_0x6d68('0x32')]['fields']));_0x30ed30['attributes']=_0x30ed30[_0x6d68('0x35')][_0x6d68('0x37')]?_0x30ed30[_0x6d68('0x35')]:_0x2d33bb[_0x6d68('0x31')];if(_0x1b8089[_0x6d68('0x32')][_0x6d68('0x40')]){_0x30ed30[_0x6d68('0x41')]=[{'all':!![]}];}_0x30ed30=_['merge']({},_0x30ed30,_0x1b8089[_0x6d68('0x3f')]);return db['AnalyticFieldReport']['find'](_0x30ed30)[_0x6d68('0x26')](handleEntityNotFound(_0x31c553,null))['then'](respondWithResult(_0x31c553,null))['catch'](handleError(_0x31c553,null));};exports[_0x6d68('0x48')]=function(_0x57ec0e,_0x5e4422){return db[_0x6d68('0x2d')]['create'](_0x57ec0e['body'],{})[_0x6d68('0x26')](respondWithResult(_0x5e4422,0xc9))[_0x6d68('0x44')](handleError(_0x5e4422,null));};exports[_0x6d68('0x49')]=function(_0x12dede,_0x45ab3b){return db['AnalyticFieldReport'][_0x6d68('0x49')](_0x12dede[_0x6d68('0x4a')],{'raw':![],'individualHooks':!![]})[_0x6d68('0x26')](respondWithResult(_0x45ab3b,0xc9))[_0x6d68('0x44')](handleError(_0x45ab3b,null));};exports['update']=function(_0x15e335,_0x2fa269){if(_0x15e335['body']['id']){delete _0x15e335[_0x6d68('0x4a')]['id'];}return db[_0x6d68('0x2d')][_0x6d68('0x4b')]({'where':{'id':_0x15e335[_0x6d68('0x45')]['id']}})[_0x6d68('0x26')](handleEntityNotFound(_0x2fa269,null))['then'](saveUpdates(_0x15e335[_0x6d68('0x4a')],null))[_0x6d68('0x26')](respondWithResult(_0x2fa269,null))[_0x6d68('0x44')](handleError(_0x2fa269,null));};exports[_0x6d68('0x25')]=function(_0x5622a6,_0x58bb97){return db[_0x6d68('0x2d')][_0x6d68('0x4b')]({'where':{'id':_0x5622a6['params']['id']}})[_0x6d68('0x26')](handleEntityNotFound(_0x58bb97,null))[_0x6d68('0x26')](removeEntity(_0x58bb97,null))[_0x6d68('0x44')](handleError(_0x58bb97,null));};exports[_0x6d68('0x4c')]=function(_0x57051c,_0x44b70e){return db[_0x6d68('0x2d')][_0x6d68('0x25')]({'where':{'id':_0x57051c['query']['ids']||[]},'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x44b70e,0xcc))[_0x6d68('0x44')](handleError(_0x44b70e,null));};exports['addFields']=function(_0x553f20,_0x547f81,_0x383988){return db[_0x6d68('0x4d')][_0x6d68('0x4e')]({'where':{'id':_0x553f20[_0x6d68('0x45')]['id']}})[_0x6d68('0x26')](handleEntityNotFound(_0x547f81,null))[_0x6d68('0x26')](function(_0x803fe3){if(_0x803fe3){return db[_0x6d68('0x4f')]['transaction'](function(_0x51737e){return db[_0x6d68('0x2d')][_0x6d68('0x25')]({'where':{'CustomReportId':_0x553f20[_0x6d68('0x45')]['id']},'transaction':_0x51737e})[_0x6d68('0x26')](function(_0x23c2fd){var _0x165fd1=_[_0x6d68('0x2c')](_0x553f20[_0x6d68('0x4a')],function(_0x4af0a5){delete _0x4af0a5['id'];_0x4af0a5[_0x6d68('0x50')]=_0x553f20[_0x6d68('0x45')]['id'];return _0x4af0a5;});return db['AnalyticFieldReport'][_0x6d68('0x49')](_0x165fd1,{'transaction':_0x51737e});});})['then'](function(){return db[_0x6d68('0x2d')][_0x6d68('0x42')]({'where':{'CustomReportId':_0x553f20[_0x6d68('0x45')]['id']}});});}})[_0x6d68('0x26')](respondWithResult(_0x547f81,null))[_0x6d68('0x44')](handleError(_0x547f81,null));};