server/api/intZohoConfiguration/intZohoConfiguration.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 _0xb41a=['desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','end','status','json','offset','limit','undefined','count','Content-Range','update','destroy','then','error','stack','send','index','map','rawAttributes','fieldName','type','key','model','name','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','include','ZohoConfiguration','findAll','rows','catch','show','params','includeAll','find','create','body','getFields','findOne','ZohoField','getSubjects','getDescriptions','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce'];(function(_0x397e5f,_0x454c8f){var _0x5302b8=function(_0x1a29ef){while(--_0x1a29ef){_0x397e5f['push'](_0x397e5f['shift']());}};_0x5302b8(++_0x454c8f);}(_0xb41a,0x18c));var _0xab41=function(_0x317e30,_0x32ad66){_0x317e30=_0x317e30-0x0;var _0x203788=_0xb41a[_0x317e30];return _0x203788;};'use strict';var emlformat=require(_0xab41('0x0'));var rimraf=require(_0xab41('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xab41('0x2'));var rp=require(_0xab41('0x3'));var moment=require('moment');var BPromise=require(_0xab41('0x4'));var Mustache=require(_0xab41('0x5'));var util=require(_0xab41('0x6'));var path=require('path');var sox=require('sox');var csv=require(_0xab41('0x7'));var ejs=require(_0xab41('0x8'));var fs=require('fs');var fs_extra=require(_0xab41('0x9'));var _=require(_0xab41('0xa'));var squel=require(_0xab41('0xb'));var crypto=require(_0xab41('0xc'));var jsforce=require(_0xab41('0xd'));var deskjs=require(_0xab41('0xe'));var toCsv=require('to-csv');var querystring=require(_0xab41('0xf'));var Papa=require(_0xab41('0x10'));var Redis=require(_0xab41('0x11'));var authService=require('../../components/auth/service');var qs=require(_0xab41('0x12'));var as=require(_0xab41('0x13'));var hardwareService=require(_0xab41('0x14'));var logger=require(_0xab41('0x15'))(_0xab41('0x16'));var utils=require(_0xab41('0x17'));var config=require(_0xab41('0x18'));var licenseUtil=require(_0xab41('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x412725,_0x1f946d){_0x1f946d=_0x1f946d||0xcc;return function(_0x2c00a0){if(_0x2c00a0){return _0x412725[_0xab41('0x1a')](_0x1f946d);}return _0x412725['status'](_0x1f946d)[_0xab41('0x1b')]();};}function respondWithResult(_0x1dd855,_0x45edf1){_0x45edf1=_0x45edf1||0xc8;return function(_0x24eedb){if(_0x24eedb){return _0x1dd855[_0xab41('0x1c')](_0x45edf1)[_0xab41('0x1d')](_0x24eedb);}};}function respondWithFilteredResult(_0x336b05,_0x2cc43e){return function(_0xcd38e9){if(_0xcd38e9){var _0x4db345=typeof _0x2cc43e[_0xab41('0x1e')]==='undefined'&&typeof _0x2cc43e[_0xab41('0x1f')]===_0xab41('0x20');var _0x2e18e5=_0xcd38e9[_0xab41('0x21')];var _0x5a12cb=_0x4db345?0x0:_0x2cc43e['offset'];var _0x5412e0=_0x4db345?_0xcd38e9[_0xab41('0x21')]:_0x2cc43e['offset']+_0x2cc43e[_0xab41('0x1f')];var _0x33f405;if(_0x5412e0>=_0x2e18e5){_0x5412e0=_0x2e18e5;_0x33f405=0xc8;}else{_0x33f405=0xce;}_0x336b05[_0xab41('0x1c')](_0x33f405);return _0x336b05['set'](_0xab41('0x22'),_0x5a12cb+'-'+_0x5412e0+'/'+_0x2e18e5)[_0xab41('0x1d')](_0xcd38e9);}return null;};}function patchUpdates(_0x3bd6ea){return function(_0x7d63ac){try{jsonpatch['apply'](_0x7d63ac,_0x3bd6ea,!![]);}catch(_0x3837e7){return BPromise['reject'](_0x3837e7);}return _0x7d63ac['save']();};}function saveUpdates(_0x508360,_0x95782a){return function(_0x134b14){if(_0x134b14){return _0x134b14[_0xab41('0x23')](_0x508360)['then'](function(_0x5363d0){return _0x5363d0;});}return null;};}function removeEntity(_0x1d27bb,_0x34761b){return function(_0x39fdb8){if(_0x39fdb8){return _0x39fdb8[_0xab41('0x24')]()[_0xab41('0x25')](function(){_0x1d27bb[_0xab41('0x1c')](0xcc)[_0xab41('0x1b')]();});}};}function handleEntityNotFound(_0x2b0426,_0x5e9d66){return function(_0x1a6ec3){if(!_0x1a6ec3){_0x2b0426[_0xab41('0x1a')](0x194);}return _0x1a6ec3;};}function handleError(_0x3c8e34,_0x5811a9){_0x5811a9=_0x5811a9||0x1f4;return function(_0x35d5ca){logger[_0xab41('0x26')](_0x35d5ca[_0xab41('0x27')]);if(_0x35d5ca['name']){delete _0x35d5ca['name'];}_0x3c8e34[_0xab41('0x1c')](_0x5811a9)[_0xab41('0x28')](_0x35d5ca);};}exports[_0xab41('0x29')]=function(_0x450777,_0x16dad9){var _0x15657f={},_0x12d698={},_0x4e6ce1={'count':0x0,'rows':[]};var _0x383071=_[_0xab41('0x2a')](db['ZohoConfiguration'][_0xab41('0x2b')],function(_0x55a880){return{'name':_0x55a880[_0xab41('0x2c')],'type':_0x55a880[_0xab41('0x2d')][_0xab41('0x2e')]};});_0x12d698[_0xab41('0x2f')]=_[_0xab41('0x2a')](_0x383071,_0xab41('0x30'));_0x12d698[_0xab41('0x31')]=_[_0xab41('0x32')](_0x450777[_0xab41('0x31')]);_0x12d698[_0xab41('0x33')]=_[_0xab41('0x34')](_0x12d698[_0xab41('0x2f')],_0x12d698[_0xab41('0x31')]);_0x15657f[_0xab41('0x35')]=_[_0xab41('0x34')](_0x12d698[_0xab41('0x2f')],qs['fields'](_0x450777[_0xab41('0x31')][_0xab41('0x36')]));_0x15657f[_0xab41('0x35')]=_0x15657f[_0xab41('0x35')][_0xab41('0x37')]?_0x15657f['attributes']:_0x12d698[_0xab41('0x2f')];if(!_0x450777['query'][_0xab41('0x38')](_0xab41('0x39'))){_0x15657f[_0xab41('0x1f')]=qs[_0xab41('0x1f')](_0x450777[_0xab41('0x31')]['limit']);_0x15657f[_0xab41('0x1e')]=qs['offset'](_0x450777[_0xab41('0x31')][_0xab41('0x1e')]);}_0x15657f[_0xab41('0x3a')]=qs[_0xab41('0x3b')](_0x450777[_0xab41('0x31')][_0xab41('0x3b')]);_0x15657f[_0xab41('0x3c')]=qs[_0xab41('0x33')](_[_0xab41('0x3d')](_0x450777[_0xab41('0x31')],_0x12d698['filters']),_0x383071);if(_0x450777[_0xab41('0x31')][_0xab41('0x3e')]){_0x15657f[_0xab41('0x3c')]=_[_0xab41('0x3f')](_0x15657f[_0xab41('0x3c')],{'$or':_[_0xab41('0x2a')](_0x383071,function(_0x2eb838){if(_0x2eb838[_0xab41('0x2d')]!==_0xab41('0x40')){var _0xa3f958={};_0xa3f958[_0x2eb838[_0xab41('0x30')]]={'$like':'%'+_0x450777['query']['filter']+'%'};return _0xa3f958;}})});}_0x15657f=_[_0xab41('0x3f')]({},_0x15657f,_0x450777[_0xab41('0x41')]);var _0x36ffac={'where':_0x15657f[_0xab41('0x3c')]};return db['ZohoConfiguration'][_0xab41('0x21')](_0x36ffac)[_0xab41('0x25')](function(_0x3603c6){_0x4e6ce1[_0xab41('0x21')]=_0x3603c6;if(_0x450777[_0xab41('0x31')]['includeAll']){_0x15657f[_0xab41('0x42')]=[{'all':!![]}];}return db[_0xab41('0x43')][_0xab41('0x44')](_0x15657f);})[_0xab41('0x25')](function(_0x28d624){_0x4e6ce1[_0xab41('0x45')]=_0x28d624;return _0x4e6ce1;})['then'](respondWithFilteredResult(_0x16dad9,_0x15657f))[_0xab41('0x46')](handleError(_0x16dad9,null));};exports[_0xab41('0x47')]=function(_0x324d84,_0x61051b){var _0xdacb7d={'raw':![],'where':{'id':_0x324d84[_0xab41('0x48')]['id']}},_0x15854c={};_0x15854c[_0xab41('0x2f')]=_['keys'](db[_0xab41('0x43')]['rawAttributes']);_0x15854c[_0xab41('0x31')]=_[_0xab41('0x32')](_0x324d84[_0xab41('0x31')]);_0x15854c[_0xab41('0x33')]=_[_0xab41('0x34')](_0x15854c['model'],_0x15854c['query']);_0xdacb7d[_0xab41('0x35')]=_[_0xab41('0x34')](_0x15854c[_0xab41('0x2f')],qs['fields'](_0x324d84[_0xab41('0x31')]['fields']));_0xdacb7d['attributes']=_0xdacb7d[_0xab41('0x35')][_0xab41('0x37')]?_0xdacb7d['attributes']:_0x15854c[_0xab41('0x2f')];if(_0x324d84[_0xab41('0x31')][_0xab41('0x49')]){_0xdacb7d['include']=[{'all':!![]}];}_0xdacb7d=_[_0xab41('0x3f')]({},_0xdacb7d,_0x324d84[_0xab41('0x41')]);return db[_0xab41('0x43')][_0xab41('0x4a')](_0xdacb7d)[_0xab41('0x25')](handleEntityNotFound(_0x61051b,null))[_0xab41('0x25')](respondWithResult(_0x61051b,null))[_0xab41('0x46')](handleError(_0x61051b,null));};exports[_0xab41('0x4b')]=function(_0x65fd5c,_0x56d64a){return db[_0xab41('0x43')][_0xab41('0x4b')](_0x65fd5c[_0xab41('0x4c')],{})[_0xab41('0x25')](respondWithResult(_0x56d64a,0xc9))[_0xab41('0x46')](handleError(_0x56d64a,null));};exports['update']=function(_0x1fa0f5,_0x4113cf){if(_0x1fa0f5[_0xab41('0x4c')]['id']){delete _0x1fa0f5[_0xab41('0x4c')]['id'];}return db[_0xab41('0x43')][_0xab41('0x4a')]({'where':{'id':_0x1fa0f5[_0xab41('0x48')]['id']}})[_0xab41('0x25')](handleEntityNotFound(_0x4113cf,null))[_0xab41('0x25')](saveUpdates(_0x1fa0f5[_0xab41('0x4c')],null))[_0xab41('0x25')](respondWithResult(_0x4113cf,null))['catch'](handleError(_0x4113cf,null));};exports[_0xab41('0x24')]=function(_0x17d064,_0x26b74e){return db[_0xab41('0x43')][_0xab41('0x4a')]({'where':{'id':_0x17d064['params']['id']}})[_0xab41('0x25')](handleEntityNotFound(_0x26b74e,null))[_0xab41('0x25')](removeEntity(_0x26b74e,null))[_0xab41('0x46')](handleError(_0x26b74e,null));};exports[_0xab41('0x4d')]=function(_0x2542b9,_0x28a006,_0x527691){var _0x48d9b3={};var _0xd496fc={};var _0x49c658;var _0x2f4f36;return db[_0xab41('0x43')][_0xab41('0x4e')]({'where':{'id':_0x2542b9[_0xab41('0x48')]['id']}})[_0xab41('0x25')](handleEntityNotFound(_0x28a006,null))[_0xab41('0x25')](function(_0x1189ee){if(_0x1189ee){_0x49c658=_0x1189ee;_0xd496fc['model']=_[_0xab41('0x32')](db[_0xab41('0x4f')]['rawAttributes']);_0xd496fc[_0xab41('0x31')]=_[_0xab41('0x32')](_0x2542b9['query']);_0xd496fc['filters']=_['intersection'](_0xd496fc[_0xab41('0x2f')],_0xd496fc[_0xab41('0x31')]);_0x48d9b3[_0xab41('0x35')]=_[_0xab41('0x34')](_0xd496fc[_0xab41('0x2f')],qs['fields'](_0x2542b9[_0xab41('0x31')][_0xab41('0x36')]));_0x48d9b3[_0xab41('0x35')]=_0x48d9b3['attributes']['length']?_0x48d9b3[_0xab41('0x35')]:_0xd496fc[_0xab41('0x2f')];_0x48d9b3[_0xab41('0x3a')]=qs[_0xab41('0x3b')](_0x2542b9[_0xab41('0x31')][_0xab41('0x3b')]);_0x48d9b3[_0xab41('0x3c')]=qs['filters'](_[_0xab41('0x3d')](_0x2542b9[_0xab41('0x31')],_0xd496fc[_0xab41('0x33')]));if(_0x2542b9['query'][_0xab41('0x3e')]){_0x48d9b3['where']=_['merge'](_0x48d9b3[_0xab41('0x3c')],{'$or':_['map'](_0x48d9b3[_0xab41('0x35')],function(_0x5240d9){var _0x3ed855={};_0x3ed855[_0x5240d9]={'$like':'%'+_0x2542b9[_0xab41('0x31')][_0xab41('0x3e')]+'%'};return _0x3ed855;})});}_0x48d9b3=_['merge']({},_0x48d9b3,_0x2542b9['options']);return _0x49c658[_0xab41('0x4d')](_0x48d9b3);}})[_0xab41('0x25')](function(_0x436831){if(_0x436831){_0x2f4f36=_0x436831[_0xab41('0x37')];if(!_0x2542b9[_0xab41('0x31')][_0xab41('0x38')](_0xab41('0x39'))){_0x48d9b3[_0xab41('0x1f')]=qs[_0xab41('0x1f')](_0x2542b9[_0xab41('0x31')][_0xab41('0x1f')]);_0x48d9b3[_0xab41('0x1e')]=qs[_0xab41('0x1e')](_0x2542b9['query']['offset']);}return _0x49c658['getFields'](_0x48d9b3);}})[_0xab41('0x25')](function(_0x343026){if(_0x343026){return _0x343026?{'count':_0x2f4f36,'rows':_0x343026}:null;}})['then'](respondWithResult(_0x28a006,null))[_0xab41('0x46')](handleError(_0x28a006,null));};exports[_0xab41('0x50')]=function(_0x2eab42,_0x229702,_0x51095f){var _0x111afd={};var _0x86cb68={};var _0xf08c80;var _0x2feaf2;return db[_0xab41('0x43')][_0xab41('0x4e')]({'where':{'id':_0x2eab42['params']['id']}})[_0xab41('0x25')](handleEntityNotFound(_0x229702,null))[_0xab41('0x25')](function(_0x4dbc93){if(_0x4dbc93){_0xf08c80=_0x4dbc93;_0x86cb68['model']=_[_0xab41('0x32')](db['ZohoField'][_0xab41('0x2b')]);_0x86cb68[_0xab41('0x31')]=_[_0xab41('0x32')](_0x2eab42[_0xab41('0x31')]);_0x86cb68[_0xab41('0x33')]=_['intersection'](_0x86cb68[_0xab41('0x2f')],_0x86cb68[_0xab41('0x31')]);_0x111afd[_0xab41('0x35')]=_[_0xab41('0x34')](_0x86cb68[_0xab41('0x2f')],qs[_0xab41('0x36')](_0x2eab42[_0xab41('0x31')][_0xab41('0x36')]));_0x111afd[_0xab41('0x35')]=_0x111afd['attributes']['length']?_0x111afd[_0xab41('0x35')]:_0x86cb68[_0xab41('0x2f')];_0x111afd[_0xab41('0x3a')]=qs[_0xab41('0x3b')](_0x2eab42['query'][_0xab41('0x3b')]);_0x111afd[_0xab41('0x3c')]=qs[_0xab41('0x33')](_[_0xab41('0x3d')](_0x2eab42[_0xab41('0x31')],_0x86cb68[_0xab41('0x33')]));if(_0x2eab42[_0xab41('0x31')][_0xab41('0x3e')]){_0x111afd[_0xab41('0x3c')]=_[_0xab41('0x3f')](_0x111afd[_0xab41('0x3c')],{'$or':_[_0xab41('0x2a')](_0x111afd[_0xab41('0x35')],function(_0x39eae3){var _0x12201c={};_0x12201c[_0x39eae3]={'$like':'%'+_0x2eab42[_0xab41('0x31')][_0xab41('0x3e')]+'%'};return _0x12201c;})});}_0x111afd=_[_0xab41('0x3f')]({},_0x111afd,_0x2eab42[_0xab41('0x41')]);return _0xf08c80[_0xab41('0x50')](_0x111afd);}})[_0xab41('0x25')](function(_0x27d3b2){if(_0x27d3b2){_0x2feaf2=_0x27d3b2[_0xab41('0x37')];if(!_0x2eab42['query'][_0xab41('0x38')]('nolimit')){_0x111afd[_0xab41('0x1f')]=qs[_0xab41('0x1f')](_0x2eab42[_0xab41('0x31')][_0xab41('0x1f')]);_0x111afd['offset']=qs[_0xab41('0x1e')](_0x2eab42[_0xab41('0x31')][_0xab41('0x1e')]);}return _0xf08c80[_0xab41('0x50')](_0x111afd);}})[_0xab41('0x25')](function(_0xae7cdc){if(_0xae7cdc){return _0xae7cdc?{'count':_0x2feaf2,'rows':_0xae7cdc}:null;}})[_0xab41('0x25')](respondWithResult(_0x229702,null))['catch'](handleError(_0x229702,null));};exports[_0xab41('0x51')]=function(_0x28856e,_0x5224a4,_0x1cb947){var _0x13a1cb={};var _0x39d243={};var _0x42d06b;var _0xaf77f6;return db[_0xab41('0x43')][_0xab41('0x4e')]({'where':{'id':_0x28856e['params']['id']}})[_0xab41('0x25')](handleEntityNotFound(_0x5224a4,null))['then'](function(_0x287ed9){if(_0x287ed9){_0x42d06b=_0x287ed9;_0x39d243['model']=_[_0xab41('0x32')](db[_0xab41('0x4f')][_0xab41('0x2b')]);_0x39d243['query']=_[_0xab41('0x32')](_0x28856e['query']);_0x39d243[_0xab41('0x33')]=_[_0xab41('0x34')](_0x39d243[_0xab41('0x2f')],_0x39d243['query']);_0x13a1cb[_0xab41('0x35')]=_['intersection'](_0x39d243['model'],qs['fields'](_0x28856e['query'][_0xab41('0x36')]));_0x13a1cb['attributes']=_0x13a1cb[_0xab41('0x35')][_0xab41('0x37')]?_0x13a1cb[_0xab41('0x35')]:_0x39d243[_0xab41('0x2f')];_0x13a1cb['order']=qs[_0xab41('0x3b')](_0x28856e[_0xab41('0x31')]['sort']);_0x13a1cb[_0xab41('0x3c')]=qs[_0xab41('0x33')](_[_0xab41('0x3d')](_0x28856e[_0xab41('0x31')],_0x39d243[_0xab41('0x33')]));if(_0x28856e[_0xab41('0x31')]['filter']){_0x13a1cb['where']=_[_0xab41('0x3f')](_0x13a1cb[_0xab41('0x3c')],{'$or':_['map'](_0x13a1cb['attributes'],function(_0x5c002e){var _0x59ff59={};_0x59ff59[_0x5c002e]={'$like':'%'+_0x28856e[_0xab41('0x31')][_0xab41('0x3e')]+'%'};return _0x59ff59;})});}_0x13a1cb=_[_0xab41('0x3f')]({},_0x13a1cb,_0x28856e[_0xab41('0x41')]);return _0x42d06b[_0xab41('0x51')](_0x13a1cb);}})[_0xab41('0x25')](function(_0x2aea36){if(_0x2aea36){_0xaf77f6=_0x2aea36[_0xab41('0x37')];if(!_0x28856e[_0xab41('0x31')][_0xab41('0x38')](_0xab41('0x39'))){_0x13a1cb[_0xab41('0x1f')]=qs['limit'](_0x28856e['query'][_0xab41('0x1f')]);_0x13a1cb[_0xab41('0x1e')]=qs[_0xab41('0x1e')](_0x28856e[_0xab41('0x31')][_0xab41('0x1e')]);}return _0x42d06b['getDescriptions'](_0x13a1cb);}})[_0xab41('0x25')](function(_0x50acc4){if(_0x50acc4){return _0x50acc4?{'count':_0xaf77f6,'rows':_0x50acc4}:null;}})[_0xab41('0x25')](respondWithResult(_0x5224a4,null))['catch'](handleError(_0x5224a4,null));};