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 _0x856d=['undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','index','map','rawAttributes','type','key','model','query','keys','intersection','attributes','fields','length','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','Automation','findAll','rows','catch','show','params','filters','find','create','body','addConditions','Condition','ids','omit','findOne','getConditions','hasOwnProperty','addActions','Action','getActions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset'];(function(_0x2b8121,_0x128869){var _0xec2947=function(_0x424997){while(--_0x424997){_0x2b8121['push'](_0x2b8121['shift']());}};_0xec2947(++_0x128869);}(_0x856d,0x93));var _0xd856=function(_0x19f838,_0x5c3217){_0x19f838=_0x19f838-0x0;var _0x139ecc=_0x856d[_0x19f838];return _0x139ecc;};'use strict';var emlformat=require(_0xd856('0x0'));var rimraf=require(_0xd856('0x1'));var zipdir=require(_0xd856('0x2'));var jsonpatch=require(_0xd856('0x3'));var rp=require(_0xd856('0x4'));var moment=require(_0xd856('0x5'));var BPromise=require(_0xd856('0x6'));var Mustache=require(_0xd856('0x7'));var util=require(_0xd856('0x8'));var path=require(_0xd856('0x9'));var sox=require(_0xd856('0xa'));var csv=require(_0xd856('0xb'));var ejs=require(_0xd856('0xc'));var fs=require('fs');var fs_extra=require(_0xd856('0xd'));var _=require('lodash');var squel=require(_0xd856('0xe'));var crypto=require('crypto');var jsforce=require(_0xd856('0xf'));var deskjs=require(_0xd856('0x10'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xd856('0x11'));var Redis=require(_0xd856('0x12'));var authService=require(_0xd856('0x13'));var qs=require(_0xd856('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xd856('0x15'));var utils=require(_0xd856('0x16'));var config=require(_0xd856('0x17'));var licenseUtil=require(_0xd856('0x18'));var db=require(_0xd856('0x19'))['db'];function respondWithStatusCode(_0x326243,_0x23c161){_0x23c161=_0x23c161||0xcc;return function(_0x429628){if(_0x429628){return _0x326243[_0xd856('0x1a')](_0x23c161);}return _0x326243[_0xd856('0x1b')](_0x23c161)[_0xd856('0x1c')]();};}function respondWithResult(_0x4958a2,_0x1cad81){_0x1cad81=_0x1cad81||0xc8;return function(_0x4e6cf2){if(_0x4e6cf2){return _0x4958a2[_0xd856('0x1b')](_0x1cad81)[_0xd856('0x1d')](_0x4e6cf2);}};}function respondWithFilteredResult(_0xd0cf89,_0x2af87c){return function(_0x22d229){if(_0x22d229){var _0x383101=typeof _0x2af87c[_0xd856('0x1e')]===_0xd856('0x1f')&&typeof _0x2af87c[_0xd856('0x20')]===_0xd856('0x1f');var _0x2a2602=_0x22d229[_0xd856('0x21')];var _0x1d1201=_0x383101?0x0:_0x2af87c[_0xd856('0x1e')];var _0x33478b=_0x383101?_0x22d229['count']:_0x2af87c[_0xd856('0x1e')]+_0x2af87c[_0xd856('0x20')];var _0x1b7471;if(_0x33478b>=_0x2a2602){_0x33478b=_0x2a2602;_0x1b7471=0xc8;}else{_0x1b7471=0xce;}_0xd0cf89[_0xd856('0x1b')](_0x1b7471);return _0xd0cf89[_0xd856('0x22')](_0xd856('0x23'),_0x1d1201+'-'+_0x33478b+'/'+_0x2a2602)[_0xd856('0x1d')](_0x22d229);}return null;};}function patchUpdates(_0x5b8040){return function(_0x2f16c3){try{jsonpatch[_0xd856('0x24')](_0x2f16c3,_0x5b8040,!![]);}catch(_0x38c6a9){return BPromise[_0xd856('0x25')](_0x38c6a9);}return _0x2f16c3[_0xd856('0x26')]();};}function saveUpdates(_0x15bb9b,_0x5a2577){return function(_0x2d969e){if(_0x2d969e){return _0x2d969e[_0xd856('0x27')](_0x15bb9b)[_0xd856('0x28')](function(_0x26f230){return _0x26f230;});}return null;};}function removeEntity(_0x46f56c,_0xc57a70){return function(_0x81f125){if(_0x81f125){return _0x81f125[_0xd856('0x29')]()['then'](function(){_0x46f56c[_0xd856('0x1b')](0xcc)[_0xd856('0x1c')]();});}};}function handleEntityNotFound(_0x4198e4,_0xbbe50d){return function(_0x391619){if(!_0x391619){_0x4198e4['sendStatus'](0x194);}return _0x391619;};}function handleError(_0x1d0e2e,_0x46f5b5){_0x46f5b5=_0x46f5b5||0x1f4;return function(_0x1149d3){logger[_0xd856('0x2a')](_0x1149d3[_0xd856('0x2b')]);if(_0x1149d3[_0xd856('0x2c')]){delete _0x1149d3['name'];}_0x1d0e2e[_0xd856('0x1b')](_0x46f5b5)[_0xd856('0x2d')](_0x1149d3);};}exports[_0xd856('0x2e')]=function(_0x360c82,_0x55c19b){var _0x20bd65={},_0xabbe84={},_0x539474={'count':0x0,'rows':[]};var _0x4394d4=_[_0xd856('0x2f')](db['Automation'][_0xd856('0x30')],function(_0x8a01a7){return{'name':_0x8a01a7['fieldName'],'type':_0x8a01a7[_0xd856('0x31')][_0xd856('0x32')]};});_0xabbe84[_0xd856('0x33')]=_[_0xd856('0x2f')](_0x4394d4,_0xd856('0x2c'));_0xabbe84[_0xd856('0x34')]=_[_0xd856('0x35')](_0x360c82['query']);_0xabbe84['filters']=_[_0xd856('0x36')](_0xabbe84[_0xd856('0x33')],_0xabbe84[_0xd856('0x34')]);_0x20bd65[_0xd856('0x37')]=_[_0xd856('0x36')](_0xabbe84[_0xd856('0x33')],qs['fields'](_0x360c82['query'][_0xd856('0x38')]));_0x20bd65[_0xd856('0x37')]=_0x20bd65[_0xd856('0x37')][_0xd856('0x39')]?_0x20bd65[_0xd856('0x37')]:_0xabbe84['model'];if(!_0x360c82[_0xd856('0x34')]['hasOwnProperty'](_0xd856('0x3a'))){_0x20bd65[_0xd856('0x20')]=qs['limit'](_0x360c82[_0xd856('0x34')][_0xd856('0x20')]);_0x20bd65[_0xd856('0x1e')]=qs[_0xd856('0x1e')](_0x360c82[_0xd856('0x34')][_0xd856('0x1e')]);}_0x20bd65[_0xd856('0x3b')]=qs['sort'](_0x360c82[_0xd856('0x34')][_0xd856('0x3c')]);_0x20bd65[_0xd856('0x3d')]=qs['filters'](_[_0xd856('0x3e')](_0x360c82['query'],_0xabbe84['filters']),_0x4394d4);if(_0x360c82['query'][_0xd856('0x3f')]){_0x20bd65[_0xd856('0x3d')]=_[_0xd856('0x40')](_0x20bd65[_0xd856('0x3d')],{'$or':_[_0xd856('0x2f')](_0x4394d4,function(_0x560c7e){if(_0x560c7e['type']!==_0xd856('0x41')){var _0x4a6a56={};_0x4a6a56[_0x560c7e['name']]={'$like':'%'+_0x360c82[_0xd856('0x34')][_0xd856('0x3f')]+'%'};return _0x4a6a56;}})});}_0x20bd65=_[_0xd856('0x40')]({},_0x20bd65,_0x360c82[_0xd856('0x42')]);var _0x9df496={'where':_0x20bd65[_0xd856('0x3d')]};return db['Automation'][_0xd856('0x21')](_0x9df496)[_0xd856('0x28')](function(_0x22257b){_0x539474['count']=_0x22257b;if(_0x360c82[_0xd856('0x34')][_0xd856('0x43')]){_0x20bd65[_0xd856('0x44')]=[{'all':!![]}];}return db[_0xd856('0x45')][_0xd856('0x46')](_0x20bd65);})[_0xd856('0x28')](function(_0x2ff90c){_0x539474[_0xd856('0x47')]=_0x2ff90c;return _0x539474;})[_0xd856('0x28')](respondWithFilteredResult(_0x55c19b,_0x20bd65))[_0xd856('0x48')](handleError(_0x55c19b,null));};exports[_0xd856('0x49')]=function(_0x576032,_0x3faf16){var _0x28f39d={'raw':![],'where':{'id':_0x576032[_0xd856('0x4a')]['id']}},_0x5c875a={};_0x5c875a[_0xd856('0x33')]=_[_0xd856('0x35')](db[_0xd856('0x45')][_0xd856('0x30')]);_0x5c875a[_0xd856('0x34')]=_[_0xd856('0x35')](_0x576032[_0xd856('0x34')]);_0x5c875a[_0xd856('0x4b')]=_[_0xd856('0x36')](_0x5c875a['model'],_0x5c875a['query']);_0x28f39d['attributes']=_[_0xd856('0x36')](_0x5c875a[_0xd856('0x33')],qs['fields'](_0x576032[_0xd856('0x34')]['fields']));_0x28f39d[_0xd856('0x37')]=_0x28f39d[_0xd856('0x37')][_0xd856('0x39')]?_0x28f39d['attributes']:_0x5c875a[_0xd856('0x33')];if(_0x576032[_0xd856('0x34')][_0xd856('0x43')]){_0x28f39d[_0xd856('0x44')]=[{'all':!![]}];}_0x28f39d=_[_0xd856('0x40')]({},_0x28f39d,_0x576032[_0xd856('0x42')]);return db[_0xd856('0x45')][_0xd856('0x4c')](_0x28f39d)[_0xd856('0x28')](handleEntityNotFound(_0x3faf16,null))['then'](respondWithResult(_0x3faf16,null))[_0xd856('0x48')](handleError(_0x3faf16,null));};exports[_0xd856('0x4d')]=function(_0x3767b6,_0x8a7ad7){return db[_0xd856('0x45')][_0xd856('0x4d')](_0x3767b6[_0xd856('0x4e')],{})[_0xd856('0x28')](respondWithResult(_0x8a7ad7,0xc9))[_0xd856('0x48')](handleError(_0x8a7ad7,null));};exports[_0xd856('0x27')]=function(_0x24abe7,_0x592363){if(_0x24abe7[_0xd856('0x4e')]['id']){delete _0x24abe7[_0xd856('0x4e')]['id'];}return db[_0xd856('0x45')][_0xd856('0x4c')]({'where':{'id':_0x24abe7[_0xd856('0x4a')]['id']}})[_0xd856('0x28')](handleEntityNotFound(_0x592363,null))[_0xd856('0x28')](saveUpdates(_0x24abe7[_0xd856('0x4e')],null))['then'](respondWithResult(_0x592363,null))[_0xd856('0x48')](handleError(_0x592363,null));};exports[_0xd856('0x29')]=function(_0x227731,_0x5aaa64){return db[_0xd856('0x45')][_0xd856('0x4c')]({'where':{'id':_0x227731[_0xd856('0x4a')]['id']}})[_0xd856('0x28')](handleEntityNotFound(_0x5aaa64,null))[_0xd856('0x28')](removeEntity(_0x5aaa64,null))[_0xd856('0x48')](handleError(_0x5aaa64,null));};exports[_0xd856('0x4f')]=function(_0x9ef291,_0x37944e,_0x447544){return db[_0xd856('0x50')][_0xd856('0x4c')]({'where':{'id':_0x9ef291[_0xd856('0x4a')]['id']}})[_0xd856('0x28')](handleEntityNotFound(_0x37944e,null))[_0xd856('0x28')](function(_0x3ab4b6){if(_0x3ab4b6){return _0x3ab4b6[_0xd856('0x4f')](_0x9ef291['body'][_0xd856('0x51')],_[_0xd856('0x52')](_0x9ef291[_0xd856('0x4e')],[_0xd856('0x51'),'id'])||{});}})['then'](respondWithResult(_0x37944e,null))[_0xd856('0x48')](handleError(_0x37944e,null));};exports['getConditions']=function(_0x540124,_0x10905f,_0x592caf){var _0x45edb5={};var _0x1d146f={};var _0x79deab;var _0x43dd46;return db[_0xd856('0x45')][_0xd856('0x53')]({'where':{'id':_0x540124[_0xd856('0x4a')]['id']}})[_0xd856('0x28')](handleEntityNotFound(_0x10905f,null))[_0xd856('0x28')](function(_0x53b189){if(_0x53b189){_0x79deab=_0x53b189;_0x1d146f[_0xd856('0x33')]=_[_0xd856('0x35')](db[_0xd856('0x50')][_0xd856('0x30')]);_0x1d146f[_0xd856('0x34')]=_[_0xd856('0x35')](_0x540124[_0xd856('0x34')]);_0x1d146f[_0xd856('0x4b')]=_[_0xd856('0x36')](_0x1d146f['model'],_0x1d146f[_0xd856('0x34')]);_0x45edb5[_0xd856('0x37')]=_['intersection'](_0x1d146f[_0xd856('0x33')],qs[_0xd856('0x38')](_0x540124[_0xd856('0x34')]['fields']));_0x45edb5['attributes']=_0x45edb5[_0xd856('0x37')][_0xd856('0x39')]?_0x45edb5[_0xd856('0x37')]:_0x1d146f[_0xd856('0x33')];_0x45edb5['order']=qs['sort'](_0x540124[_0xd856('0x34')][_0xd856('0x3c')]);_0x45edb5[_0xd856('0x3d')]=qs[_0xd856('0x4b')](_['pick'](_0x540124[_0xd856('0x34')],_0x1d146f[_0xd856('0x4b')]));if(_0x540124[_0xd856('0x34')][_0xd856('0x3f')]){_0x45edb5[_0xd856('0x3d')]=_['merge'](_0x45edb5['where'],{'$or':_[_0xd856('0x2f')](_0x45edb5[_0xd856('0x37')],function(_0x1dd32e){var _0x5812d6={};_0x5812d6[_0x1dd32e]={'$like':'%'+_0x540124[_0xd856('0x34')][_0xd856('0x3f')]+'%'};return _0x5812d6;})});}_0x45edb5=_[_0xd856('0x40')]({},_0x45edb5,_0x540124[_0xd856('0x42')]);return _0x79deab[_0xd856('0x54')](_0x45edb5);}})[_0xd856('0x28')](function(_0x5b66c7){if(_0x5b66c7){_0x43dd46=_0x5b66c7[_0xd856('0x39')];if(!_0x540124[_0xd856('0x34')][_0xd856('0x55')](_0xd856('0x3a'))){_0x45edb5[_0xd856('0x20')]=qs[_0xd856('0x20')](_0x540124[_0xd856('0x34')][_0xd856('0x20')]);_0x45edb5[_0xd856('0x1e')]=qs['offset'](_0x540124['query'][_0xd856('0x1e')]);}return _0x79deab[_0xd856('0x54')](_0x45edb5);}})[_0xd856('0x28')](function(_0x402566){if(_0x402566){return _0x402566?{'count':_0x43dd46,'rows':_0x402566}:null;}})[_0xd856('0x28')](respondWithResult(_0x10905f,null))[_0xd856('0x48')](handleError(_0x10905f,null));};exports[_0xd856('0x56')]=function(_0x4a26d2,_0x36e1e4,_0xc9195){return db[_0xd856('0x57')][_0xd856('0x4c')]({'where':{'id':_0x4a26d2[_0xd856('0x4a')]['id']}})['then'](handleEntityNotFound(_0x36e1e4,null))[_0xd856('0x28')](function(_0x320c3c){if(_0x320c3c){return _0x320c3c[_0xd856('0x56')](_0x4a26d2['body'][_0xd856('0x51')],_['omit'](_0x4a26d2[_0xd856('0x4e')],[_0xd856('0x51'),'id'])||{});}})['then'](respondWithResult(_0x36e1e4,null))[_0xd856('0x48')](handleError(_0x36e1e4,null));};exports[_0xd856('0x58')]=function(_0x5009af,_0xb94712,_0x26f185){var _0x579937={};var _0x4713d5={};var _0x1ecd88;var _0x44d8f6;return db[_0xd856('0x45')][_0xd856('0x53')]({'where':{'id':_0x5009af[_0xd856('0x4a')]['id']}})[_0xd856('0x28')](handleEntityNotFound(_0xb94712,null))[_0xd856('0x28')](function(_0x28a4fc){if(_0x28a4fc){_0x1ecd88=_0x28a4fc;_0x4713d5['model']=_[_0xd856('0x35')](db[_0xd856('0x57')]['rawAttributes']);_0x4713d5['query']=_[_0xd856('0x35')](_0x5009af[_0xd856('0x34')]);_0x4713d5[_0xd856('0x4b')]=_[_0xd856('0x36')](_0x4713d5[_0xd856('0x33')],_0x4713d5[_0xd856('0x34')]);_0x579937[_0xd856('0x37')]=_['intersection'](_0x4713d5[_0xd856('0x33')],qs[_0xd856('0x38')](_0x5009af[_0xd856('0x34')]['fields']));_0x579937[_0xd856('0x37')]=_0x579937['attributes']['length']?_0x579937[_0xd856('0x37')]:_0x4713d5['model'];_0x579937[_0xd856('0x3b')]=qs[_0xd856('0x3c')](_0x5009af[_0xd856('0x34')][_0xd856('0x3c')]);_0x579937['where']=qs['filters'](_[_0xd856('0x3e')](_0x5009af[_0xd856('0x34')],_0x4713d5[_0xd856('0x4b')]));if(_0x5009af[_0xd856('0x34')]['filter']){_0x579937[_0xd856('0x3d')]=_[_0xd856('0x40')](_0x579937[_0xd856('0x3d')],{'$or':_[_0xd856('0x2f')](_0x579937['attributes'],function(_0x344d0d){var _0x40a1e2={};_0x40a1e2[_0x344d0d]={'$like':'%'+_0x5009af[_0xd856('0x34')][_0xd856('0x3f')]+'%'};return _0x40a1e2;})});}_0x579937=_[_0xd856('0x40')]({},_0x579937,_0x5009af[_0xd856('0x42')]);return _0x1ecd88[_0xd856('0x58')](_0x579937);}})[_0xd856('0x28')](function(_0x926df3){if(_0x926df3){_0x44d8f6=_0x926df3[_0xd856('0x39')];if(!_0x5009af[_0xd856('0x34')][_0xd856('0x55')](_0xd856('0x3a'))){_0x579937[_0xd856('0x20')]=qs[_0xd856('0x20')](_0x5009af[_0xd856('0x34')]['limit']);_0x579937[_0xd856('0x1e')]=qs[_0xd856('0x1e')](_0x5009af['query'][_0xd856('0x1e')]);}return _0x1ecd88[_0xd856('0x58')](_0x579937);}})[_0xd856('0x28')](function(_0x5b7bb0){if(_0x5b7bb0){return _0x5b7bb0?{'count':_0x44d8f6,'rows':_0x5b7bb0}:null;}})[_0xd856('0x28')](respondWithResult(_0xb94712,null))['catch'](handleError(_0xb94712,null));};