Built motion from commit da617fac.|2.6.6
[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 _0xe738=['query','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filters','pick','type','VIRTUAL','filter','options','then','includeAll','include','findAll','rows','catch','show','params','keys','merge','find','create','body','bulkCreate','ids','addFields','AnalyticCustomReport','findOne','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','count','set','Content-Range','update','destroy','stack','name','send','index','map','AnalyticFieldReport','key','model'];(function(_0x65e1d5,_0x463f69){var _0x1aaa37=function(_0x4579ad){while(--_0x4579ad){_0x65e1d5['push'](_0x65e1d5['shift']());}};_0x1aaa37(++_0x463f69);}(_0xe738,0x113));var _0x8e73=function(_0x19950b,_0x53d0d7){_0x19950b=_0x19950b-0x0;var _0x3c6b41=_0xe738[_0x19950b];return _0x3c6b41;};'use strict';var emlformat=require(_0x8e73('0x0'));var rimraf=require(_0x8e73('0x1'));var zipdir=require(_0x8e73('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x8e73('0x3'));var moment=require(_0x8e73('0x4'));var BPromise=require(_0x8e73('0x5'));var Mustache=require(_0x8e73('0x6'));var util=require(_0x8e73('0x7'));var path=require(_0x8e73('0x8'));var sox=require('sox');var csv=require(_0x8e73('0x9'));var ejs=require(_0x8e73('0xa'));var fs=require('fs');var fs_extra=require(_0x8e73('0xb'));var _=require(_0x8e73('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x8e73('0xd'));var deskjs=require(_0x8e73('0xe'));var toCsv=require(_0x8e73('0x9'));var querystring=require('querystring');var Papa=require(_0x8e73('0xf'));var Redis=require(_0x8e73('0x10'));var authService=require(_0x8e73('0x11'));var qs=require(_0x8e73('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x8e73('0x13'));var logger=require(_0x8e73('0x14'))(_0x8e73('0x15'));var utils=require(_0x8e73('0x16'));var config=require(_0x8e73('0x17'));var licenseUtil=require(_0x8e73('0x18'));var db=require(_0x8e73('0x19'))['db'];function respondWithStatusCode(_0x1503bb,_0x5dbd00){_0x5dbd00=_0x5dbd00||0xcc;return function(_0x206780){if(_0x206780){return _0x1503bb[_0x8e73('0x1a')](_0x5dbd00);}return _0x1503bb['status'](_0x5dbd00)[_0x8e73('0x1b')]();};}function respondWithResult(_0x5bbe06,_0x3ecd98){_0x3ecd98=_0x3ecd98||0xc8;return function(_0x529106){if(_0x529106){return _0x5bbe06[_0x8e73('0x1c')](_0x3ecd98)[_0x8e73('0x1d')](_0x529106);}};}function respondWithFilteredResult(_0x53d523,_0x5cf330){return function(_0x5aa3f4){if(_0x5aa3f4){var _0x10c24e=typeof _0x5cf330[_0x8e73('0x1e')]===_0x8e73('0x1f')&&typeof _0x5cf330['limit']===_0x8e73('0x1f');var _0x2ce77c=_0x5aa3f4['count'];var _0x186e33=_0x10c24e?0x0:_0x5cf330[_0x8e73('0x1e')];var _0x3dc6f2=_0x10c24e?_0x5aa3f4[_0x8e73('0x20')]:_0x5cf330['offset']+_0x5cf330['limit'];var _0x2eacad;if(_0x3dc6f2>=_0x2ce77c){_0x3dc6f2=_0x2ce77c;_0x2eacad=0xc8;}else{_0x2eacad=0xce;}_0x53d523[_0x8e73('0x1c')](_0x2eacad);return _0x53d523[_0x8e73('0x21')](_0x8e73('0x22'),_0x186e33+'-'+_0x3dc6f2+'/'+_0x2ce77c)['json'](_0x5aa3f4);}return null;};}function patchUpdates(_0x5e0791){return function(_0x10f76e){try{jsonpatch['apply'](_0x10f76e,_0x5e0791,!![]);}catch(_0x58b25e){return BPromise['reject'](_0x58b25e);}return _0x10f76e['save']();};}function saveUpdates(_0x38fbd5,_0x382511){return function(_0x2154f9){if(_0x2154f9){return _0x2154f9[_0x8e73('0x23')](_0x38fbd5)['then'](function(_0x11f9a2){return _0x11f9a2;});}return null;};}function removeEntity(_0x51bee3,_0x48aec9){return function(_0x1f7e9b){if(_0x1f7e9b){return _0x1f7e9b[_0x8e73('0x24')]()['then'](function(){_0x51bee3[_0x8e73('0x1c')](0xcc)[_0x8e73('0x1b')]();});}};}function handleEntityNotFound(_0x278147,_0x584ecd){return function(_0x1ca89a){if(!_0x1ca89a){_0x278147[_0x8e73('0x1a')](0x194);}return _0x1ca89a;};}function handleError(_0x2ea916,_0x3f4a2e){_0x3f4a2e=_0x3f4a2e||0x1f4;return function(_0x4a804f){logger['error'](_0x4a804f[_0x8e73('0x25')]);if(_0x4a804f[_0x8e73('0x26')]){delete _0x4a804f[_0x8e73('0x26')];}_0x2ea916[_0x8e73('0x1c')](_0x3f4a2e)[_0x8e73('0x27')](_0x4a804f);};}exports[_0x8e73('0x28')]=function(_0x2d2e7a,_0x33b4c9){var _0x42f36a={},_0x5f525a={},_0x395835={'count':0x0,'rows':[]};var _0x4f0662=_[_0x8e73('0x29')](db[_0x8e73('0x2a')]['rawAttributes'],function(_0x5527a0){return{'name':_0x5527a0['fieldName'],'type':_0x5527a0['type'][_0x8e73('0x2b')]};});_0x5f525a[_0x8e73('0x2c')]=_['map'](_0x4f0662,_0x8e73('0x26'));_0x5f525a['query']=_['keys'](_0x2d2e7a[_0x8e73('0x2d')]);_0x5f525a['filters']=_[_0x8e73('0x2e')](_0x5f525a[_0x8e73('0x2c')],_0x5f525a[_0x8e73('0x2d')]);_0x42f36a[_0x8e73('0x2f')]=_[_0x8e73('0x2e')](_0x5f525a[_0x8e73('0x2c')],qs['fields'](_0x2d2e7a['query'][_0x8e73('0x30')]));_0x42f36a[_0x8e73('0x2f')]=_0x42f36a[_0x8e73('0x2f')][_0x8e73('0x31')]?_0x42f36a['attributes']:_0x5f525a[_0x8e73('0x2c')];if(!_0x2d2e7a['query'][_0x8e73('0x32')](_0x8e73('0x33'))){_0x42f36a[_0x8e73('0x34')]=qs['limit'](_0x2d2e7a['query'][_0x8e73('0x34')]);_0x42f36a[_0x8e73('0x1e')]=qs[_0x8e73('0x1e')](_0x2d2e7a['query']['offset']);}_0x42f36a[_0x8e73('0x35')]=qs[_0x8e73('0x36')](_0x2d2e7a[_0x8e73('0x2d')]['sort']);_0x42f36a[_0x8e73('0x37')]=qs[_0x8e73('0x38')](_[_0x8e73('0x39')](_0x2d2e7a['query'],_0x5f525a[_0x8e73('0x38')]),_0x4f0662);if(_0x2d2e7a[_0x8e73('0x2d')]['filter']){_0x42f36a[_0x8e73('0x37')]=_['merge'](_0x42f36a[_0x8e73('0x37')],{'$or':_[_0x8e73('0x29')](_0x4f0662,function(_0x3a4b64){if(_0x3a4b64[_0x8e73('0x3a')]!==_0x8e73('0x3b')){var _0x110d69={};_0x110d69[_0x3a4b64[_0x8e73('0x26')]]={'$like':'%'+_0x2d2e7a[_0x8e73('0x2d')][_0x8e73('0x3c')]+'%'};return _0x110d69;}})});}_0x42f36a=_['merge']({},_0x42f36a,_0x2d2e7a[_0x8e73('0x3d')]);var _0x4d6d35={'where':_0x42f36a[_0x8e73('0x37')]};return db[_0x8e73('0x2a')][_0x8e73('0x20')](_0x4d6d35)[_0x8e73('0x3e')](function(_0x16ca68){_0x395835[_0x8e73('0x20')]=_0x16ca68;if(_0x2d2e7a[_0x8e73('0x2d')][_0x8e73('0x3f')]){_0x42f36a[_0x8e73('0x40')]=[{'all':!![]}];}return db['AnalyticFieldReport'][_0x8e73('0x41')](_0x42f36a);})[_0x8e73('0x3e')](function(_0x4264a6){_0x395835[_0x8e73('0x42')]=_0x4264a6;return _0x395835;})[_0x8e73('0x3e')](respondWithFilteredResult(_0x33b4c9,_0x42f36a))[_0x8e73('0x43')](handleError(_0x33b4c9,null));};exports[_0x8e73('0x44')]=function(_0x108b52,_0xb1fda8){var _0x39dfca={'raw':![],'where':{'id':_0x108b52[_0x8e73('0x45')]['id']}},_0x3cc006={};_0x3cc006[_0x8e73('0x2c')]=_[_0x8e73('0x46')](db['AnalyticFieldReport']['rawAttributes']);_0x3cc006[_0x8e73('0x2d')]=_[_0x8e73('0x46')](_0x108b52[_0x8e73('0x2d')]);_0x3cc006[_0x8e73('0x38')]=_[_0x8e73('0x2e')](_0x3cc006[_0x8e73('0x2c')],_0x3cc006['query']);_0x39dfca['attributes']=_[_0x8e73('0x2e')](_0x3cc006[_0x8e73('0x2c')],qs[_0x8e73('0x30')](_0x108b52[_0x8e73('0x2d')]['fields']));_0x39dfca[_0x8e73('0x2f')]=_0x39dfca[_0x8e73('0x2f')][_0x8e73('0x31')]?_0x39dfca[_0x8e73('0x2f')]:_0x3cc006[_0x8e73('0x2c')];if(_0x108b52[_0x8e73('0x2d')][_0x8e73('0x3f')]){_0x39dfca[_0x8e73('0x40')]=[{'all':!![]}];}_0x39dfca=_[_0x8e73('0x47')]({},_0x39dfca,_0x108b52[_0x8e73('0x3d')]);return db[_0x8e73('0x2a')][_0x8e73('0x48')](_0x39dfca)[_0x8e73('0x3e')](handleEntityNotFound(_0xb1fda8,null))[_0x8e73('0x3e')](respondWithResult(_0xb1fda8,null))[_0x8e73('0x43')](handleError(_0xb1fda8,null));};exports['create']=function(_0x27b343,_0x2a80dd){return db[_0x8e73('0x2a')][_0x8e73('0x49')](_0x27b343[_0x8e73('0x4a')],{})[_0x8e73('0x3e')](respondWithResult(_0x2a80dd,0xc9))[_0x8e73('0x43')](handleError(_0x2a80dd,null));};exports[_0x8e73('0x4b')]=function(_0x5d82fe,_0x481a03){return db[_0x8e73('0x2a')][_0x8e73('0x4b')](_0x5d82fe['body'],{'raw':![],'individualHooks':!![]})[_0x8e73('0x3e')](respondWithResult(_0x481a03,0xc9))[_0x8e73('0x43')](handleError(_0x481a03,null));};exports[_0x8e73('0x23')]=function(_0x3ee027,_0x5d4352){if(_0x3ee027[_0x8e73('0x4a')]['id']){delete _0x3ee027['body']['id'];}return db[_0x8e73('0x2a')][_0x8e73('0x48')]({'where':{'id':_0x3ee027[_0x8e73('0x45')]['id']}})[_0x8e73('0x3e')](handleEntityNotFound(_0x5d4352,null))[_0x8e73('0x3e')](saveUpdates(_0x3ee027[_0x8e73('0x4a')],null))[_0x8e73('0x3e')](respondWithResult(_0x5d4352,null))[_0x8e73('0x43')](handleError(_0x5d4352,null));};exports[_0x8e73('0x24')]=function(_0x2f1d0f,_0x4d239c){return db[_0x8e73('0x2a')][_0x8e73('0x48')]({'where':{'id':_0x2f1d0f['params']['id']}})[_0x8e73('0x3e')](handleEntityNotFound(_0x4d239c,null))['then'](removeEntity(_0x4d239c,null))[_0x8e73('0x43')](handleError(_0x4d239c,null));};exports['bulkDestroy']=function(_0x4efb02,_0x4a0e18){return db['AnalyticFieldReport'][_0x8e73('0x24')]({'where':{'id':_0x4efb02[_0x8e73('0x2d')][_0x8e73('0x4c')]||[]},'raw':![],'individualHooks':!![]})[_0x8e73('0x3e')](respondWithResult(_0x4a0e18,0xcc))['catch'](handleError(_0x4a0e18,null));};exports[_0x8e73('0x4d')]=function(_0x23a6ad,_0x4a0fb9,_0x20cf36){return db[_0x8e73('0x4e')][_0x8e73('0x4f')]({'where':{'id':_0x23a6ad['params']['id']}})[_0x8e73('0x3e')](handleEntityNotFound(_0x4a0fb9,null))[_0x8e73('0x3e')](function(_0x11653a){if(_0x11653a){return db['sequelize']['transaction'](function(_0x25020b){return db['AnalyticFieldReport'][_0x8e73('0x24')]({'where':{'CustomReportId':_0x23a6ad[_0x8e73('0x45')]['id']},'transaction':_0x25020b})['then'](function(_0x226f0c){var _0x427f42=_[_0x8e73('0x29')](_0x23a6ad['body'],function(_0x3044d5){delete _0x3044d5['id'];_0x3044d5['CustomReportId']=_0x23a6ad[_0x8e73('0x45')]['id'];return _0x3044d5;});return db[_0x8e73('0x2a')][_0x8e73('0x4b')](_0x427f42,{'transaction':_0x25020b});});})['then'](function(){return db[_0x8e73('0x2a')][_0x8e73('0x41')]({'where':{'CustomReportId':_0x23a6ad['params']['id']}});});}})[_0x8e73('0x3e')](respondWithResult(_0x4a0fb9,null))['catch'](handleError(_0x4a0fb9,null));};