server/api/automation/automation.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 _0x4368=['status','end','json','undefined','count','offset','limit','set','Content-Range','reject','save','update','destroy','then','sendStatus','stack','send','index','map','Automation','rawAttributes','type','model','name','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','pick','filter','where','merge','VIRTUAL','options','include','catch','show','params','includeAll','find','create','body','addConditions','Condition','ids','omit','getConditions','findOne','addActions','Action','getActions','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb'];(function(_0x16419e,_0x3f3736){var _0x2ad8d3=function(_0x7d84a7){while(--_0x7d84a7){_0x16419e['push'](_0x16419e['shift']());}};_0x2ad8d3(++_0x3f3736);}(_0x4368,0x8b));var _0x8436=function(_0x266618,_0x18f637){_0x266618=_0x266618-0x0;var _0x54dbf5=_0x4368[_0x266618];return _0x54dbf5;};'use strict';var emlformat=require(_0x8436('0x0'));var rimraf=require(_0x8436('0x1'));var zipdir=require(_0x8436('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x8436('0x3'));var moment=require(_0x8436('0x4'));var BPromise=require(_0x8436('0x5'));var Mustache=require(_0x8436('0x6'));var util=require(_0x8436('0x7'));var path=require(_0x8436('0x8'));var sox=require(_0x8436('0x9'));var csv=require(_0x8436('0xa'));var ejs=require(_0x8436('0xb'));var fs=require('fs');var fs_extra=require(_0x8436('0xc'));var _=require(_0x8436('0xd'));var squel=require(_0x8436('0xe'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x8436('0xa'));var querystring=require(_0x8436('0xf'));var Papa=require(_0x8436('0x10'));var Redis=require(_0x8436('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x8436('0x12'));var as=require(_0x8436('0x13'));var hardwareService=require(_0x8436('0x14'));var logger=require(_0x8436('0x15'))('api');var utils=require('../../config/utils');var config=require(_0x8436('0x16'));var licenseUtil=require(_0x8436('0x17'));var db=require(_0x8436('0x18'))['db'];function respondWithStatusCode(_0x8b6b1d,_0x34acf9){_0x34acf9=_0x34acf9||0xcc;return function(_0x1513e0){if(_0x1513e0){return _0x8b6b1d['sendStatus'](_0x34acf9);}return _0x8b6b1d[_0x8436('0x19')](_0x34acf9)[_0x8436('0x1a')]();};}function respondWithResult(_0x4d5f0e,_0x2fda8b){_0x2fda8b=_0x2fda8b||0xc8;return function(_0x413145){if(_0x413145){return _0x4d5f0e[_0x8436('0x19')](_0x2fda8b)[_0x8436('0x1b')](_0x413145);}};}function respondWithFilteredResult(_0x1ff9c1,_0x4a7f99){return function(_0x1efced){if(_0x1efced){var _0xf6d1b=typeof _0x4a7f99['offset']==='undefined'&&typeof _0x4a7f99['limit']===_0x8436('0x1c');var _0x53eda0=_0x1efced[_0x8436('0x1d')];var _0x4167b5=_0xf6d1b?0x0:_0x4a7f99[_0x8436('0x1e')];var _0x57f7dc=_0xf6d1b?_0x1efced[_0x8436('0x1d')]:_0x4a7f99[_0x8436('0x1e')]+_0x4a7f99[_0x8436('0x1f')];var _0x13cca4;if(_0x57f7dc>=_0x53eda0){_0x57f7dc=_0x53eda0;_0x13cca4=0xc8;}else{_0x13cca4=0xce;}_0x1ff9c1[_0x8436('0x19')](_0x13cca4);return _0x1ff9c1[_0x8436('0x20')](_0x8436('0x21'),_0x4167b5+'-'+_0x57f7dc+'/'+_0x53eda0)[_0x8436('0x1b')](_0x1efced);}return null;};}function patchUpdates(_0x56fffa){return function(_0x4ea425){try{jsonpatch['apply'](_0x4ea425,_0x56fffa,!![]);}catch(_0x34a042){return BPromise[_0x8436('0x22')](_0x34a042);}return _0x4ea425[_0x8436('0x23')]();};}function saveUpdates(_0x2bfe90,_0x2b41c7){return function(_0x390b21){if(_0x390b21){return _0x390b21[_0x8436('0x24')](_0x2bfe90)['then'](function(_0x4626c6){return _0x4626c6;});}return null;};}function removeEntity(_0x4930be,_0x5bfdfe){return function(_0x3bde4c){if(_0x3bde4c){return _0x3bde4c[_0x8436('0x25')]()[_0x8436('0x26')](function(){_0x4930be[_0x8436('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x393f86,_0x51361e){return function(_0x32080b){if(!_0x32080b){_0x393f86[_0x8436('0x27')](0x194);}return _0x32080b;};}function handleError(_0x1cb65a,_0x41ca94){_0x41ca94=_0x41ca94||0x1f4;return function(_0x59d4ae){logger['error'](_0x59d4ae[_0x8436('0x28')]);if(_0x59d4ae['name']){delete _0x59d4ae['name'];}_0x1cb65a[_0x8436('0x19')](_0x41ca94)[_0x8436('0x29')](_0x59d4ae);};}exports[_0x8436('0x2a')]=function(_0x5411ce,_0x3ae08d){var _0x2b9ff0={},_0x39c7a7={},_0x2a0075={'count':0x0,'rows':[]};var _0x34fcb5=_[_0x8436('0x2b')](db[_0x8436('0x2c')][_0x8436('0x2d')],function(_0x5c3c9c){return{'name':_0x5c3c9c['fieldName'],'type':_0x5c3c9c[_0x8436('0x2e')]['key']};});_0x39c7a7[_0x8436('0x2f')]=_['map'](_0x34fcb5,_0x8436('0x30'));_0x39c7a7[_0x8436('0x31')]=_[_0x8436('0x32')](_0x5411ce[_0x8436('0x31')]);_0x39c7a7[_0x8436('0x33')]=_[_0x8436('0x34')](_0x39c7a7[_0x8436('0x2f')],_0x39c7a7[_0x8436('0x31')]);_0x2b9ff0[_0x8436('0x35')]=_[_0x8436('0x34')](_0x39c7a7[_0x8436('0x2f')],qs[_0x8436('0x36')](_0x5411ce[_0x8436('0x31')]['fields']));_0x2b9ff0[_0x8436('0x35')]=_0x2b9ff0['attributes'][_0x8436('0x37')]?_0x2b9ff0[_0x8436('0x35')]:_0x39c7a7[_0x8436('0x2f')];if(!_0x5411ce[_0x8436('0x31')][_0x8436('0x38')](_0x8436('0x39'))){_0x2b9ff0['limit']=qs[_0x8436('0x1f')](_0x5411ce['query'][_0x8436('0x1f')]);_0x2b9ff0[_0x8436('0x1e')]=qs['offset'](_0x5411ce[_0x8436('0x31')][_0x8436('0x1e')]);}_0x2b9ff0['order']=qs['sort'](_0x5411ce['query'][_0x8436('0x3a')]);_0x2b9ff0['where']=qs['filters'](_[_0x8436('0x3b')](_0x5411ce[_0x8436('0x31')],_0x39c7a7[_0x8436('0x33')]),_0x34fcb5);if(_0x5411ce['query'][_0x8436('0x3c')]){_0x2b9ff0[_0x8436('0x3d')]=_[_0x8436('0x3e')](_0x2b9ff0[_0x8436('0x3d')],{'$or':_['map'](_0x34fcb5,function(_0x4a945f){if(_0x4a945f[_0x8436('0x2e')]!==_0x8436('0x3f')){var _0x5e574c={};_0x5e574c[_0x4a945f['name']]={'$like':'%'+_0x5411ce['query']['filter']+'%'};return _0x5e574c;}})});}_0x2b9ff0=_['merge']({},_0x2b9ff0,_0x5411ce[_0x8436('0x40')]);var _0x5adaad={'where':_0x2b9ff0[_0x8436('0x3d')]};return db[_0x8436('0x2c')][_0x8436('0x1d')](_0x5adaad)[_0x8436('0x26')](function(_0x403ea3){_0x2a0075[_0x8436('0x1d')]=_0x403ea3;if(_0x5411ce['query']['includeAll']){_0x2b9ff0[_0x8436('0x41')]=[{'all':!![]}];}return db[_0x8436('0x2c')]['findAll'](_0x2b9ff0);})['then'](function(_0x6cdffe){_0x2a0075['rows']=_0x6cdffe;return _0x2a0075;})[_0x8436('0x26')](respondWithFilteredResult(_0x3ae08d,_0x2b9ff0))[_0x8436('0x42')](handleError(_0x3ae08d,null));};exports[_0x8436('0x43')]=function(_0x1fc217,_0x3829d5){var _0x1fb58a={'raw':![],'where':{'id':_0x1fc217[_0x8436('0x44')]['id']}},_0x80d467={};_0x80d467[_0x8436('0x2f')]=_[_0x8436('0x32')](db['Automation'][_0x8436('0x2d')]);_0x80d467['query']=_[_0x8436('0x32')](_0x1fc217[_0x8436('0x31')]);_0x80d467['filters']=_[_0x8436('0x34')](_0x80d467[_0x8436('0x2f')],_0x80d467[_0x8436('0x31')]);_0x1fb58a[_0x8436('0x35')]=_[_0x8436('0x34')](_0x80d467[_0x8436('0x2f')],qs[_0x8436('0x36')](_0x1fc217[_0x8436('0x31')]['fields']));_0x1fb58a[_0x8436('0x35')]=_0x1fb58a[_0x8436('0x35')][_0x8436('0x37')]?_0x1fb58a['attributes']:_0x80d467[_0x8436('0x2f')];if(_0x1fc217[_0x8436('0x31')][_0x8436('0x45')]){_0x1fb58a[_0x8436('0x41')]=[{'all':!![]}];}_0x1fb58a=_['merge']({},_0x1fb58a,_0x1fc217[_0x8436('0x40')]);return db[_0x8436('0x2c')][_0x8436('0x46')](_0x1fb58a)['then'](handleEntityNotFound(_0x3829d5,null))[_0x8436('0x26')](respondWithResult(_0x3829d5,null))[_0x8436('0x42')](handleError(_0x3829d5,null));};exports[_0x8436('0x47')]=function(_0x13e146,_0xbf61e2){return db[_0x8436('0x2c')]['create'](_0x13e146['body'],{})[_0x8436('0x26')](respondWithResult(_0xbf61e2,0xc9))[_0x8436('0x42')](handleError(_0xbf61e2,null));};exports[_0x8436('0x24')]=function(_0x4098e7,_0x3c2164){if(_0x4098e7[_0x8436('0x48')]['id']){delete _0x4098e7[_0x8436('0x48')]['id'];}return db[_0x8436('0x2c')][_0x8436('0x46')]({'where':{'id':_0x4098e7[_0x8436('0x44')]['id']}})[_0x8436('0x26')](handleEntityNotFound(_0x3c2164,null))[_0x8436('0x26')](saveUpdates(_0x4098e7[_0x8436('0x48')],null))[_0x8436('0x26')](respondWithResult(_0x3c2164,null))[_0x8436('0x42')](handleError(_0x3c2164,null));};exports[_0x8436('0x25')]=function(_0x14eb64,_0x37137d){return db[_0x8436('0x2c')][_0x8436('0x46')]({'where':{'id':_0x14eb64[_0x8436('0x44')]['id']}})[_0x8436('0x26')](handleEntityNotFound(_0x37137d,null))[_0x8436('0x26')](removeEntity(_0x37137d,null))['catch'](handleError(_0x37137d,null));};exports[_0x8436('0x49')]=function(_0x2042e2,_0x2c671e,_0x10850a){return db[_0x8436('0x4a')][_0x8436('0x46')]({'where':{'id':_0x2042e2[_0x8436('0x44')]['id']}})['then'](handleEntityNotFound(_0x2c671e,null))[_0x8436('0x26')](function(_0x3a1558){if(_0x3a1558){return _0x3a1558[_0x8436('0x49')](_0x2042e2[_0x8436('0x48')][_0x8436('0x4b')],_[_0x8436('0x4c')](_0x2042e2[_0x8436('0x48')],['ids','id'])||{});}})[_0x8436('0x26')](respondWithResult(_0x2c671e,null))[_0x8436('0x42')](handleError(_0x2c671e,null));};exports[_0x8436('0x4d')]=function(_0x30d6d3,_0x3dcb36,_0x40b9eb){var _0x17eef6={};var _0x4d2146={};var _0x429625;var _0x4f5538;return db['Automation'][_0x8436('0x4e')]({'where':{'id':_0x30d6d3[_0x8436('0x44')]['id']}})[_0x8436('0x26')](handleEntityNotFound(_0x3dcb36,null))['then'](function(_0x4bded1){if(_0x4bded1){_0x429625=_0x4bded1;_0x4d2146[_0x8436('0x2f')]=_[_0x8436('0x32')](db[_0x8436('0x4a')][_0x8436('0x2d')]);_0x4d2146[_0x8436('0x31')]=_[_0x8436('0x32')](_0x30d6d3['query']);_0x4d2146[_0x8436('0x33')]=_['intersection'](_0x4d2146[_0x8436('0x2f')],_0x4d2146[_0x8436('0x31')]);_0x17eef6[_0x8436('0x35')]=_[_0x8436('0x34')](_0x4d2146[_0x8436('0x2f')],qs[_0x8436('0x36')](_0x30d6d3[_0x8436('0x31')][_0x8436('0x36')]));_0x17eef6['attributes']=_0x17eef6[_0x8436('0x35')][_0x8436('0x37')]?_0x17eef6['attributes']:_0x4d2146['model'];_0x17eef6['order']=qs[_0x8436('0x3a')](_0x30d6d3['query'][_0x8436('0x3a')]);_0x17eef6['where']=qs[_0x8436('0x33')](_[_0x8436('0x3b')](_0x30d6d3[_0x8436('0x31')],_0x4d2146['filters']));if(_0x30d6d3[_0x8436('0x31')]['filter']){_0x17eef6[_0x8436('0x3d')]=_[_0x8436('0x3e')](_0x17eef6[_0x8436('0x3d')],{'$or':_[_0x8436('0x2b')](_0x17eef6[_0x8436('0x35')],function(_0x909df3){var _0x46000c={};_0x46000c[_0x909df3]={'$like':'%'+_0x30d6d3[_0x8436('0x31')][_0x8436('0x3c')]+'%'};return _0x46000c;})});}_0x17eef6=_['merge']({},_0x17eef6,_0x30d6d3[_0x8436('0x40')]);return _0x429625[_0x8436('0x4d')](_0x17eef6);}})[_0x8436('0x26')](function(_0xb0b9fb){if(_0xb0b9fb){_0x4f5538=_0xb0b9fb[_0x8436('0x37')];if(!_0x30d6d3[_0x8436('0x31')]['hasOwnProperty'](_0x8436('0x39'))){_0x17eef6[_0x8436('0x1f')]=qs['limit'](_0x30d6d3['query'][_0x8436('0x1f')]);_0x17eef6[_0x8436('0x1e')]=qs[_0x8436('0x1e')](_0x30d6d3[_0x8436('0x31')][_0x8436('0x1e')]);}return _0x429625[_0x8436('0x4d')](_0x17eef6);}})[_0x8436('0x26')](function(_0x27aa79){if(_0x27aa79){return _0x27aa79?{'count':_0x4f5538,'rows':_0x27aa79}:null;}})[_0x8436('0x26')](respondWithResult(_0x3dcb36,null))[_0x8436('0x42')](handleError(_0x3dcb36,null));};exports[_0x8436('0x4f')]=function(_0x499145,_0x2b1c48,_0x3699ca){return db[_0x8436('0x50')][_0x8436('0x46')]({'where':{'id':_0x499145[_0x8436('0x44')]['id']}})['then'](handleEntityNotFound(_0x2b1c48,null))['then'](function(_0x52c246){if(_0x52c246){return _0x52c246['addActions'](_0x499145[_0x8436('0x48')][_0x8436('0x4b')],_['omit'](_0x499145[_0x8436('0x48')],[_0x8436('0x4b'),'id'])||{});}})[_0x8436('0x26')](respondWithResult(_0x2b1c48,null))[_0x8436('0x42')](handleError(_0x2b1c48,null));};exports[_0x8436('0x51')]=function(_0x3b7c20,_0x281cea,_0x4bdd3c){var _0x538afc={};var _0x3976ee={};var _0x9650b6;var _0x286958;return db[_0x8436('0x2c')]['findOne']({'where':{'id':_0x3b7c20[_0x8436('0x44')]['id']}})['then'](handleEntityNotFound(_0x281cea,null))[_0x8436('0x26')](function(_0x25b101){if(_0x25b101){_0x9650b6=_0x25b101;_0x3976ee['model']=_[_0x8436('0x32')](db['Action'][_0x8436('0x2d')]);_0x3976ee['query']=_[_0x8436('0x32')](_0x3b7c20[_0x8436('0x31')]);_0x3976ee[_0x8436('0x33')]=_[_0x8436('0x34')](_0x3976ee[_0x8436('0x2f')],_0x3976ee[_0x8436('0x31')]);_0x538afc['attributes']=_[_0x8436('0x34')](_0x3976ee['model'],qs[_0x8436('0x36')](_0x3b7c20[_0x8436('0x31')][_0x8436('0x36')]));_0x538afc[_0x8436('0x35')]=_0x538afc[_0x8436('0x35')][_0x8436('0x37')]?_0x538afc[_0x8436('0x35')]:_0x3976ee['model'];_0x538afc['order']=qs[_0x8436('0x3a')](_0x3b7c20['query'][_0x8436('0x3a')]);_0x538afc[_0x8436('0x3d')]=qs['filters'](_[_0x8436('0x3b')](_0x3b7c20[_0x8436('0x31')],_0x3976ee[_0x8436('0x33')]));if(_0x3b7c20[_0x8436('0x31')][_0x8436('0x3c')]){_0x538afc[_0x8436('0x3d')]=_[_0x8436('0x3e')](_0x538afc[_0x8436('0x3d')],{'$or':_[_0x8436('0x2b')](_0x538afc['attributes'],function(_0xd1217b){var _0x3f6b96={};_0x3f6b96[_0xd1217b]={'$like':'%'+_0x3b7c20[_0x8436('0x31')][_0x8436('0x3c')]+'%'};return _0x3f6b96;})});}_0x538afc=_[_0x8436('0x3e')]({},_0x538afc,_0x3b7c20[_0x8436('0x40')]);return _0x9650b6[_0x8436('0x51')](_0x538afc);}})[_0x8436('0x26')](function(_0x52c1e8){if(_0x52c1e8){_0x286958=_0x52c1e8[_0x8436('0x37')];if(!_0x3b7c20[_0x8436('0x31')]['hasOwnProperty'](_0x8436('0x39'))){_0x538afc[_0x8436('0x1f')]=qs[_0x8436('0x1f')](_0x3b7c20[_0x8436('0x31')][_0x8436('0x1f')]);_0x538afc['offset']=qs[_0x8436('0x1e')](_0x3b7c20[_0x8436('0x31')][_0x8436('0x1e')]);}return _0x9650b6['getActions'](_0x538afc);}})['then'](function(_0x48ca8c){if(_0x48ca8c){return _0x48ca8c?{'count':_0x286958,'rows':_0x48ca8c}:null;}})[_0x8436('0x26')](respondWithResult(_0x281cea,null))['catch'](handleError(_0x281cea,null));};