d22c86cd47589ed133807d06e4f130d653e89f5a
[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 _0xa9aa=['jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/license/util','status','json','count','offset','limit','set','Content-Range','apply','save','then','end','error','stack','name','send','index','map','fieldName','type','key','model','query','filters','intersection','fields','attributes','length','hasOwnProperty','order','sort','where','merge','filter','AnalyticFieldReport','includeAll','include','rows','catch','params','keys','options','create','body','update','find','destroy','ids','addFields','AnalyticCustomReport','findOne','CustomReportId','bulkCreate','findAll','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto'];(function(_0x411b68,_0x52e768){var _0x41ff90=function(_0x2ab602){while(--_0x2ab602){_0x411b68['push'](_0x411b68['shift']());}};_0x41ff90(++_0x52e768);}(_0xa9aa,0x8f));var _0xaa9a=function(_0x1ff5f4,_0x390e75){_0x1ff5f4=_0x1ff5f4-0x0;var _0x335ecc=_0xa9aa[_0x1ff5f4];return _0x335ecc;};'use strict';var pdf=require(_0xaa9a('0x0'));var emlformat=require(_0xaa9a('0x1'));var rimraf=require(_0xaa9a('0x2'));var zipdir=require(_0xaa9a('0x3'));var jsonpatch=require(_0xaa9a('0x4'));var rp=require(_0xaa9a('0x5'));var moment=require(_0xaa9a('0x6'));var BPromise=require(_0xaa9a('0x7'));var Mustache=require(_0xaa9a('0x8'));var util=require(_0xaa9a('0x9'));var path=require(_0xaa9a('0xa'));var sox=require(_0xaa9a('0xb'));var csv=require(_0xaa9a('0xc'));var ejs=require(_0xaa9a('0xd'));var fs=require('fs');var _=require(_0xaa9a('0xe'));var squel=require(_0xaa9a('0xf'));var crypto=require(_0xaa9a('0x10'));var jsforce=require(_0xaa9a('0x11'));var deskjs=require(_0xaa9a('0x12'));var toCsv=require(_0xaa9a('0xc'));var querystring=require(_0xaa9a('0x13'));var Papa=require('papaparse');var Redis=require(_0xaa9a('0x14'));var authService=require(_0xaa9a('0x15'));var qs=require('../../components/parsers/qs');var as=require(_0xaa9a('0x16'));var hardwareService=require(_0xaa9a('0x17'));var logger=require(_0xaa9a('0x18'))('api');var utils=require(_0xaa9a('0x19'));var config=require('../../config/environment');var licenseUtil=require(_0xaa9a('0x1a'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5982be,_0xf57552){_0xf57552=_0xf57552||0xcc;return function(_0x5bc5e5){if(_0x5bc5e5){return _0x5982be['sendStatus'](_0xf57552);}return _0x5982be[_0xaa9a('0x1b')](_0xf57552)['end']();};}function respondWithResult(_0x110452,_0x53881c){_0x53881c=_0x53881c||0xc8;return function(_0x47fb8e){if(_0x47fb8e){return _0x110452[_0xaa9a('0x1b')](_0x53881c)[_0xaa9a('0x1c')](_0x47fb8e);}};}function respondWithFilteredResult(_0x15c1f8,_0x548125){return function(_0x5ea5ce){if(_0x5ea5ce){var _0x5886e9=_0x5ea5ce[_0xaa9a('0x1d')],_0x7c627b=_0x548125[_0xaa9a('0x1e')],_0x4f4c92=_0x548125[_0xaa9a('0x1e')]+_0x548125[_0xaa9a('0x1f')],_0x1b2a2c;if(_0x4f4c92>=_0x5886e9){_0x4f4c92=_0x5886e9;_0x1b2a2c=0xc8;}else{_0x1b2a2c=0xce;}_0x15c1f8[_0xaa9a('0x1b')](_0x1b2a2c);return _0x15c1f8[_0xaa9a('0x20')](_0xaa9a('0x21'),_0x7c627b+'-'+_0x4f4c92+'/'+_0x5886e9)[_0xaa9a('0x1c')](_0x5ea5ce);}return null;};}function patchUpdates(_0x5b794d){return function(_0x10b869){try{jsonpatch[_0xaa9a('0x22')](_0x10b869,_0x5b794d,!![]);}catch(_0x51f005){return BPromise['reject'](_0x51f005);}return _0x10b869[_0xaa9a('0x23')]();};}function saveUpdates(_0x15fcb1,_0x37567d){return function(_0x42fe58){if(_0x42fe58){return _0x42fe58['update'](_0x15fcb1)[_0xaa9a('0x24')](function(_0x24b077){return _0x24b077;});}return null;};}function removeEntity(_0x2caf78,_0x233b7f){return function(_0x465343){if(_0x465343){return _0x465343['destroy']()['then'](function(){_0x2caf78[_0xaa9a('0x1b')](0xcc)[_0xaa9a('0x25')]();});}};}function handleEntityNotFound(_0x1025c4,_0x582231){return function(_0x312832){if(!_0x312832){_0x1025c4['sendStatus'](0x194);}return _0x312832;};}function handleError(_0x6146c4,_0x3144bd){_0x3144bd=_0x3144bd||0x1f4;return function(_0x294b82){logger[_0xaa9a('0x26')](_0x294b82[_0xaa9a('0x27')]);if(_0x294b82[_0xaa9a('0x28')]){delete _0x294b82[_0xaa9a('0x28')];}_0x6146c4['status'](_0x3144bd)[_0xaa9a('0x29')](_0x294b82);};}exports[_0xaa9a('0x2a')]=function(_0x4fb766,_0x2d8d68){var _0x1e7d69={},_0x2b77b9={},_0x16b93e={'count':0x0,'rows':[]};var _0x9ae522=_[_0xaa9a('0x2b')](db['AnalyticFieldReport']['rawAttributes'],function(_0x3c35c0){return{'name':_0x3c35c0[_0xaa9a('0x2c')],'type':_0x3c35c0[_0xaa9a('0x2d')][_0xaa9a('0x2e')]};});_0x2b77b9[_0xaa9a('0x2f')]=_[_0xaa9a('0x2b')](_0x9ae522,_0xaa9a('0x28'));_0x2b77b9[_0xaa9a('0x30')]=_['keys'](_0x4fb766[_0xaa9a('0x30')]);_0x2b77b9[_0xaa9a('0x31')]=_[_0xaa9a('0x32')](_0x2b77b9[_0xaa9a('0x2f')],_0x2b77b9[_0xaa9a('0x30')]);_0x1e7d69['attributes']=_[_0xaa9a('0x32')](_0x2b77b9[_0xaa9a('0x2f')],qs['fields'](_0x4fb766[_0xaa9a('0x30')][_0xaa9a('0x33')]));_0x1e7d69[_0xaa9a('0x34')]=_0x1e7d69[_0xaa9a('0x34')][_0xaa9a('0x35')]?_0x1e7d69[_0xaa9a('0x34')]:_0x2b77b9[_0xaa9a('0x2f')];if(!_0x4fb766[_0xaa9a('0x30')][_0xaa9a('0x36')]('nolimit')){_0x1e7d69[_0xaa9a('0x1f')]=qs[_0xaa9a('0x1f')](_0x4fb766['query']['limit']);_0x1e7d69[_0xaa9a('0x1e')]=qs[_0xaa9a('0x1e')](_0x4fb766['query']['offset']);}_0x1e7d69[_0xaa9a('0x37')]=qs[_0xaa9a('0x38')](_0x4fb766[_0xaa9a('0x30')][_0xaa9a('0x38')]);_0x1e7d69['where']=qs['filters'](_['pick'](_0x4fb766[_0xaa9a('0x30')],_0x2b77b9[_0xaa9a('0x31')]),_0x9ae522);if(_0x4fb766[_0xaa9a('0x30')]['filter']){_0x1e7d69[_0xaa9a('0x39')]=_[_0xaa9a('0x3a')](_0x1e7d69[_0xaa9a('0x39')],{'$or':_[_0xaa9a('0x2b')](_0x9ae522,function(_0x287a3c){if(_0x287a3c[_0xaa9a('0x2d')]!=='VIRTUAL'){var _0x43e490={};_0x43e490[_0x287a3c[_0xaa9a('0x28')]]={'$like':'%'+_0x4fb766[_0xaa9a('0x30')][_0xaa9a('0x3b')]+'%'};return _0x43e490;}})});}_0x1e7d69=_['merge']({},_0x1e7d69,_0x4fb766['options']);var _0x5cb7cc={'where':_0x1e7d69[_0xaa9a('0x39')]};return db[_0xaa9a('0x3c')][_0xaa9a('0x1d')](_0x5cb7cc)[_0xaa9a('0x24')](function(_0x3fe6f1){_0x16b93e[_0xaa9a('0x1d')]=_0x3fe6f1;if(_0x4fb766[_0xaa9a('0x30')][_0xaa9a('0x3d')]){_0x1e7d69[_0xaa9a('0x3e')]=[{'all':!![]}];}return db[_0xaa9a('0x3c')]['findAll'](_0x1e7d69);})[_0xaa9a('0x24')](function(_0x576ebc){_0x16b93e[_0xaa9a('0x3f')]=_0x576ebc;return _0x16b93e;})[_0xaa9a('0x24')](respondWithFilteredResult(_0x2d8d68,_0x1e7d69))[_0xaa9a('0x40')](handleError(_0x2d8d68,null));};exports['show']=function(_0x48f5e0,_0x25778a){var _0x5b4d38={'raw':![],'where':{'id':_0x48f5e0[_0xaa9a('0x41')]['id']}},_0x378ee6={};_0x378ee6[_0xaa9a('0x2f')]=_[_0xaa9a('0x42')](db[_0xaa9a('0x3c')]['rawAttributes']);_0x378ee6[_0xaa9a('0x30')]=_[_0xaa9a('0x42')](_0x48f5e0[_0xaa9a('0x30')]);_0x378ee6[_0xaa9a('0x31')]=_[_0xaa9a('0x32')](_0x378ee6[_0xaa9a('0x2f')],_0x378ee6[_0xaa9a('0x30')]);_0x5b4d38['attributes']=_[_0xaa9a('0x32')](_0x378ee6[_0xaa9a('0x2f')],qs[_0xaa9a('0x33')](_0x48f5e0[_0xaa9a('0x30')][_0xaa9a('0x33')]));_0x5b4d38['attributes']=_0x5b4d38['attributes']['length']?_0x5b4d38[_0xaa9a('0x34')]:_0x378ee6[_0xaa9a('0x2f')];if(_0x48f5e0['query'][_0xaa9a('0x3d')]){_0x5b4d38[_0xaa9a('0x3e')]=[{'all':!![]}];}_0x5b4d38=_[_0xaa9a('0x3a')]({},_0x5b4d38,_0x48f5e0[_0xaa9a('0x43')]);return db[_0xaa9a('0x3c')]['find'](_0x5b4d38)[_0xaa9a('0x24')](handleEntityNotFound(_0x25778a,null))['then'](respondWithResult(_0x25778a,null))[_0xaa9a('0x40')](handleError(_0x25778a,null));};exports[_0xaa9a('0x44')]=function(_0x30f1d5,_0x4c29ca){return db[_0xaa9a('0x3c')][_0xaa9a('0x44')](_0x30f1d5[_0xaa9a('0x45')],{})['then'](respondWithResult(_0x4c29ca,0xc9))[_0xaa9a('0x40')](handleError(_0x4c29ca,null));};exports['bulkCreate']=function(_0x1c99c6,_0x2dc776){return db[_0xaa9a('0x3c')]['bulkCreate'](_0x1c99c6[_0xaa9a('0x45')],{'raw':![],'individualHooks':!![]})[_0xaa9a('0x24')](respondWithResult(_0x2dc776,0xc9))[_0xaa9a('0x40')](handleError(_0x2dc776,null));};exports[_0xaa9a('0x46')]=function(_0x4b94c7,_0x30d50c){if(_0x4b94c7[_0xaa9a('0x45')]['id']){delete _0x4b94c7['body']['id'];}return db['AnalyticFieldReport'][_0xaa9a('0x47')]({'where':{'id':_0x4b94c7[_0xaa9a('0x41')]['id']}})[_0xaa9a('0x24')](handleEntityNotFound(_0x30d50c,null))[_0xaa9a('0x24')](saveUpdates(_0x4b94c7[_0xaa9a('0x45')],null))['then'](respondWithResult(_0x30d50c,null))[_0xaa9a('0x40')](handleError(_0x30d50c,null));};exports[_0xaa9a('0x48')]=function(_0x54a050,_0x9abb92){return db[_0xaa9a('0x3c')][_0xaa9a('0x47')]({'where':{'id':_0x54a050[_0xaa9a('0x41')]['id']}})[_0xaa9a('0x24')](handleEntityNotFound(_0x9abb92,null))[_0xaa9a('0x24')](removeEntity(_0x9abb92,null))[_0xaa9a('0x40')](handleError(_0x9abb92,null));};exports['bulkDestroy']=function(_0x5d910f,_0x5c268a){return db[_0xaa9a('0x3c')][_0xaa9a('0x48')]({'where':{'id':_0x5d910f[_0xaa9a('0x30')][_0xaa9a('0x49')]||[]},'raw':![],'individualHooks':!![]})[_0xaa9a('0x24')](respondWithResult(_0x5c268a,0xcc))[_0xaa9a('0x40')](handleError(_0x5c268a,null));};exports[_0xaa9a('0x4a')]=function(_0x16a9b9,_0x321c2e,_0x49b1ae){return db[_0xaa9a('0x4b')][_0xaa9a('0x4c')]({'where':{'id':_0x16a9b9['params']['id']}})['then'](handleEntityNotFound(_0x321c2e,null))[_0xaa9a('0x24')](function(_0x1a8652){if(_0x1a8652){return db['sequelize']['transaction'](function(_0x4af2fa){return db['AnalyticFieldReport']['destroy']({'where':{'CustomReportId':_0x16a9b9[_0xaa9a('0x41')]['id']},'transaction':_0x4af2fa})[_0xaa9a('0x24')](function(_0x1b8213){var _0x26be4a=_[_0xaa9a('0x2b')](_0x16a9b9[_0xaa9a('0x45')],function(_0x1e6dab){delete _0x1e6dab['id'];_0x1e6dab[_0xaa9a('0x4d')]=_0x16a9b9[_0xaa9a('0x41')]['id'];return _0x1e6dab;});return db[_0xaa9a('0x3c')][_0xaa9a('0x4e')](_0x26be4a,{'transaction':_0x4af2fa});});})[_0xaa9a('0x24')](function(){return db[_0xaa9a('0x3c')][_0xaa9a('0x4f')]({'where':{'CustomReportId':_0x16a9b9[_0xaa9a('0x41')]['id']}});});}})[_0xaa9a('0x24')](respondWithResult(_0x321c2e,null))[_0xaa9a('0x40')](handleError(_0x321c2e,null));};