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 _0x4c6e=['sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','rows','catch','params','length','find','create','body','findOne','getFields','getSubjects','ZohoField','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','util','path','sox','ejs','fs-extra','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','sendStatus','error','stack','name','send','map','ZohoConfiguration','rawAttributes','fieldName','type','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order'];(function(_0x2eaa2d,_0xb29eb9){var _0x576fbe=function(_0x373199){while(--_0x373199){_0x2eaa2d['push'](_0x2eaa2d['shift']());}};_0x576fbe(++_0xb29eb9);}(_0x4c6e,0x1ef));var _0xe4c6=function(_0x3b6283,_0x59f8f3){_0x3b6283=_0x3b6283-0x0;var _0x28b56d=_0x4c6e[_0x3b6283];return _0x28b56d;};'use strict';var emlformat=require(_0xe4c6('0x0'));var rimraf=require(_0xe4c6('0x1'));var zipdir=require(_0xe4c6('0x2'));var jsonpatch=require(_0xe4c6('0x3'));var rp=require('request-promise');var moment=require(_0xe4c6('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xe4c6('0x5'));var util=require(_0xe4c6('0x6'));var path=require(_0xe4c6('0x7'));var sox=require(_0xe4c6('0x8'));var csv=require('to-csv');var ejs=require(_0xe4c6('0x9'));var fs=require('fs');var fs_extra=require(_0xe4c6('0xa'));var _=require('lodash');var squel=require(_0xe4c6('0xb'));var crypto=require('crypto');var jsforce=require(_0xe4c6('0xc'));var deskjs=require(_0xe4c6('0xd'));var toCsv=require('to-csv');var querystring=require(_0xe4c6('0xe'));var Papa=require(_0xe4c6('0xf'));var Redis=require(_0xe4c6('0x10'));var authService=require(_0xe4c6('0x11'));var qs=require(_0xe4c6('0x12'));var as=require(_0xe4c6('0x13'));var hardwareService=require(_0xe4c6('0x14'));var logger=require(_0xe4c6('0x15'))('api');var utils=require(_0xe4c6('0x16'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x9c414d,_0xb3e153){_0xb3e153=_0xb3e153||0xcc;return function(_0x26ed33){if(_0x26ed33){return _0x9c414d['sendStatus'](_0xb3e153);}return _0x9c414d[_0xe4c6('0x17')](_0xb3e153)[_0xe4c6('0x18')]();};}function respondWithResult(_0x4cb440,_0x14586e){_0x14586e=_0x14586e||0xc8;return function(_0x22066c){if(_0x22066c){return _0x4cb440[_0xe4c6('0x17')](_0x14586e)[_0xe4c6('0x19')](_0x22066c);}};}function respondWithFilteredResult(_0x58bb3d,_0x5f1368){return function(_0x477289){if(_0x477289){var _0x27baa4=typeof _0x5f1368[_0xe4c6('0x1a')]===_0xe4c6('0x1b')&&typeof _0x5f1368[_0xe4c6('0x1c')]===_0xe4c6('0x1b');var _0x51c5f7=_0x477289[_0xe4c6('0x1d')];var _0x5957bb=_0x27baa4?0x0:_0x5f1368[_0xe4c6('0x1a')];var _0x4b5d8f=_0x27baa4?_0x477289[_0xe4c6('0x1d')]:_0x5f1368[_0xe4c6('0x1a')]+_0x5f1368[_0xe4c6('0x1c')];var _0x219fd3;if(_0x4b5d8f>=_0x51c5f7){_0x4b5d8f=_0x51c5f7;_0x219fd3=0xc8;}else{_0x219fd3=0xce;}_0x58bb3d[_0xe4c6('0x17')](_0x219fd3);return _0x58bb3d[_0xe4c6('0x1e')](_0xe4c6('0x1f'),_0x5957bb+'-'+_0x4b5d8f+'/'+_0x51c5f7)[_0xe4c6('0x19')](_0x477289);}return null;};}function patchUpdates(_0x36c338){return function(_0x410efe){try{jsonpatch[_0xe4c6('0x20')](_0x410efe,_0x36c338,!![]);}catch(_0x3af663){return BPromise[_0xe4c6('0x21')](_0x3af663);}return _0x410efe[_0xe4c6('0x22')]();};}function saveUpdates(_0x213663,_0xe456d4){return function(_0x3672f4){if(_0x3672f4){return _0x3672f4[_0xe4c6('0x23')](_0x213663)[_0xe4c6('0x24')](function(_0x2e0fe3){return _0x2e0fe3;});}return null;};}function removeEntity(_0x2a77d1,_0x208825){return function(_0x64cf8b){if(_0x64cf8b){return _0x64cf8b[_0xe4c6('0x25')]()[_0xe4c6('0x24')](function(){_0x2a77d1[_0xe4c6('0x17')](0xcc)[_0xe4c6('0x18')]();});}};}function handleEntityNotFound(_0x5df756,_0xdc8085){return function(_0x7c09be){if(!_0x7c09be){_0x5df756[_0xe4c6('0x26')](0x194);}return _0x7c09be;};}function handleError(_0x42383b,_0x28badb){_0x28badb=_0x28badb||0x1f4;return function(_0x5cc3f5){logger[_0xe4c6('0x27')](_0x5cc3f5[_0xe4c6('0x28')]);if(_0x5cc3f5[_0xe4c6('0x29')]){delete _0x5cc3f5[_0xe4c6('0x29')];}_0x42383b[_0xe4c6('0x17')](_0x28badb)[_0xe4c6('0x2a')](_0x5cc3f5);};}exports['index']=function(_0x42e705,_0x2f6d60){var _0x536883={},_0x173c8c={},_0x1dcb97={'count':0x0,'rows':[]};var _0x572174=_[_0xe4c6('0x2b')](db[_0xe4c6('0x2c')][_0xe4c6('0x2d')],function(_0x658b22){return{'name':_0x658b22[_0xe4c6('0x2e')],'type':_0x658b22[_0xe4c6('0x2f')]['key']};});_0x173c8c[_0xe4c6('0x30')]=_[_0xe4c6('0x2b')](_0x572174,_0xe4c6('0x29'));_0x173c8c[_0xe4c6('0x31')]=_[_0xe4c6('0x32')](_0x42e705[_0xe4c6('0x31')]);_0x173c8c[_0xe4c6('0x33')]=_[_0xe4c6('0x34')](_0x173c8c[_0xe4c6('0x30')],_0x173c8c[_0xe4c6('0x31')]);_0x536883[_0xe4c6('0x35')]=_[_0xe4c6('0x34')](_0x173c8c['model'],qs[_0xe4c6('0x36')](_0x42e705[_0xe4c6('0x31')][_0xe4c6('0x36')]));_0x536883['attributes']=_0x536883[_0xe4c6('0x35')]['length']?_0x536883[_0xe4c6('0x35')]:_0x173c8c['model'];if(!_0x42e705[_0xe4c6('0x31')][_0xe4c6('0x37')](_0xe4c6('0x38'))){_0x536883[_0xe4c6('0x1c')]=qs[_0xe4c6('0x1c')](_0x42e705[_0xe4c6('0x31')]['limit']);_0x536883[_0xe4c6('0x1a')]=qs[_0xe4c6('0x1a')](_0x42e705[_0xe4c6('0x31')][_0xe4c6('0x1a')]);}_0x536883[_0xe4c6('0x39')]=qs[_0xe4c6('0x3a')](_0x42e705[_0xe4c6('0x31')]['sort']);_0x536883[_0xe4c6('0x3b')]=qs[_0xe4c6('0x33')](_[_0xe4c6('0x3c')](_0x42e705[_0xe4c6('0x31')],_0x173c8c[_0xe4c6('0x33')]),_0x572174);if(_0x42e705[_0xe4c6('0x31')][_0xe4c6('0x3d')]){_0x536883[_0xe4c6('0x3b')]=_[_0xe4c6('0x3e')](_0x536883[_0xe4c6('0x3b')],{'$or':_[_0xe4c6('0x2b')](_0x572174,function(_0x26a545){if(_0x26a545[_0xe4c6('0x2f')]!==_0xe4c6('0x3f')){var _0x2ad8ed={};_0x2ad8ed[_0x26a545['name']]={'$like':'%'+_0x42e705[_0xe4c6('0x31')][_0xe4c6('0x3d')]+'%'};return _0x2ad8ed;}})});}_0x536883=_[_0xe4c6('0x3e')]({},_0x536883,_0x42e705[_0xe4c6('0x40')]);var _0x59d196={'where':_0x536883['where']};return db[_0xe4c6('0x2c')][_0xe4c6('0x1d')](_0x59d196)[_0xe4c6('0x24')](function(_0x591df4){_0x1dcb97[_0xe4c6('0x1d')]=_0x591df4;if(_0x42e705[_0xe4c6('0x31')][_0xe4c6('0x41')]){_0x536883[_0xe4c6('0x42')]=[{'all':!![]}];}return db[_0xe4c6('0x2c')]['findAll'](_0x536883);})['then'](function(_0x37605f){_0x1dcb97[_0xe4c6('0x43')]=_0x37605f;return _0x1dcb97;})[_0xe4c6('0x24')](respondWithFilteredResult(_0x2f6d60,_0x536883))[_0xe4c6('0x44')](handleError(_0x2f6d60,null));};exports['show']=function(_0x199859,_0x3f468c){var _0x592f78={'raw':![],'where':{'id':_0x199859[_0xe4c6('0x45')]['id']}},_0x86a70c={};_0x86a70c[_0xe4c6('0x30')]=_['keys'](db[_0xe4c6('0x2c')][_0xe4c6('0x2d')]);_0x86a70c[_0xe4c6('0x31')]=_[_0xe4c6('0x32')](_0x199859[_0xe4c6('0x31')]);_0x86a70c[_0xe4c6('0x33')]=_['intersection'](_0x86a70c['model'],_0x86a70c[_0xe4c6('0x31')]);_0x592f78[_0xe4c6('0x35')]=_['intersection'](_0x86a70c['model'],qs[_0xe4c6('0x36')](_0x199859[_0xe4c6('0x31')][_0xe4c6('0x36')]));_0x592f78[_0xe4c6('0x35')]=_0x592f78['attributes'][_0xe4c6('0x46')]?_0x592f78[_0xe4c6('0x35')]:_0x86a70c['model'];if(_0x199859[_0xe4c6('0x31')][_0xe4c6('0x41')]){_0x592f78['include']=[{'all':!![]}];}_0x592f78=_[_0xe4c6('0x3e')]({},_0x592f78,_0x199859[_0xe4c6('0x40')]);return db['ZohoConfiguration'][_0xe4c6('0x47')](_0x592f78)['then'](handleEntityNotFound(_0x3f468c,null))[_0xe4c6('0x24')](respondWithResult(_0x3f468c,null))[_0xe4c6('0x44')](handleError(_0x3f468c,null));};exports[_0xe4c6('0x48')]=function(_0x4daccf,_0x3d3a33){return db[_0xe4c6('0x2c')][_0xe4c6('0x48')](_0x4daccf[_0xe4c6('0x49')],{})[_0xe4c6('0x24')](respondWithResult(_0x3d3a33,0xc9))['catch'](handleError(_0x3d3a33,null));};exports[_0xe4c6('0x23')]=function(_0x1c8cfd,_0x4dc584){if(_0x1c8cfd[_0xe4c6('0x49')]['id']){delete _0x1c8cfd[_0xe4c6('0x49')]['id'];}return db[_0xe4c6('0x2c')][_0xe4c6('0x47')]({'where':{'id':_0x1c8cfd[_0xe4c6('0x45')]['id']}})[_0xe4c6('0x24')](handleEntityNotFound(_0x4dc584,null))[_0xe4c6('0x24')](saveUpdates(_0x1c8cfd['body'],null))[_0xe4c6('0x24')](respondWithResult(_0x4dc584,null))[_0xe4c6('0x44')](handleError(_0x4dc584,null));};exports[_0xe4c6('0x25')]=function(_0x478971,_0xcb6710){return db[_0xe4c6('0x2c')][_0xe4c6('0x47')]({'where':{'id':_0x478971[_0xe4c6('0x45')]['id']}})[_0xe4c6('0x24')](handleEntityNotFound(_0xcb6710,null))[_0xe4c6('0x24')](removeEntity(_0xcb6710,null))[_0xe4c6('0x44')](handleError(_0xcb6710,null));};exports['getFields']=function(_0x2eeafc,_0x2491ab,_0x9e2e1c){var _0x3f4f50={};var _0x15faf8={};var _0x3ae7e3;var _0x960125;return db[_0xe4c6('0x2c')][_0xe4c6('0x4a')]({'where':{'id':_0x2eeafc[_0xe4c6('0x45')]['id']}})['then'](handleEntityNotFound(_0x2491ab,null))[_0xe4c6('0x24')](function(_0x44fdb3){if(_0x44fdb3){_0x3ae7e3=_0x44fdb3;_0x15faf8[_0xe4c6('0x30')]=_[_0xe4c6('0x32')](db['ZohoField'][_0xe4c6('0x2d')]);_0x15faf8['query']=_['keys'](_0x2eeafc[_0xe4c6('0x31')]);_0x15faf8['filters']=_[_0xe4c6('0x34')](_0x15faf8[_0xe4c6('0x30')],_0x15faf8[_0xe4c6('0x31')]);_0x3f4f50[_0xe4c6('0x35')]=_[_0xe4c6('0x34')](_0x15faf8[_0xe4c6('0x30')],qs[_0xe4c6('0x36')](_0x2eeafc['query']['fields']));_0x3f4f50[_0xe4c6('0x35')]=_0x3f4f50[_0xe4c6('0x35')][_0xe4c6('0x46')]?_0x3f4f50[_0xe4c6('0x35')]:_0x15faf8[_0xe4c6('0x30')];_0x3f4f50['order']=qs[_0xe4c6('0x3a')](_0x2eeafc[_0xe4c6('0x31')][_0xe4c6('0x3a')]);_0x3f4f50[_0xe4c6('0x3b')]=qs[_0xe4c6('0x33')](_['pick'](_0x2eeafc[_0xe4c6('0x31')],_0x15faf8[_0xe4c6('0x33')]));if(_0x2eeafc['query'][_0xe4c6('0x3d')]){_0x3f4f50[_0xe4c6('0x3b')]=_[_0xe4c6('0x3e')](_0x3f4f50['where'],{'$or':_['map'](_0x3f4f50['attributes'],function(_0xc42948){var _0x4fcd79={};_0x4fcd79[_0xc42948]={'$like':'%'+_0x2eeafc[_0xe4c6('0x31')]['filter']+'%'};return _0x4fcd79;})});}_0x3f4f50=_['merge']({},_0x3f4f50,_0x2eeafc[_0xe4c6('0x40')]);return _0x3ae7e3[_0xe4c6('0x4b')](_0x3f4f50);}})[_0xe4c6('0x24')](function(_0x16273b){if(_0x16273b){_0x960125=_0x16273b[_0xe4c6('0x46')];if(!_0x2eeafc[_0xe4c6('0x31')][_0xe4c6('0x37')](_0xe4c6('0x38'))){_0x3f4f50['limit']=qs[_0xe4c6('0x1c')](_0x2eeafc[_0xe4c6('0x31')][_0xe4c6('0x1c')]);_0x3f4f50[_0xe4c6('0x1a')]=qs[_0xe4c6('0x1a')](_0x2eeafc[_0xe4c6('0x31')]['offset']);}return _0x3ae7e3[_0xe4c6('0x4b')](_0x3f4f50);}})[_0xe4c6('0x24')](function(_0xe638bf){if(_0xe638bf){return _0xe638bf?{'count':_0x960125,'rows':_0xe638bf}:null;}})['then'](respondWithResult(_0x2491ab,null))['catch'](handleError(_0x2491ab,null));};exports[_0xe4c6('0x4c')]=function(_0x25fc14,_0x476662,_0x130866){var _0x363ece={};var _0x52c98b={};var _0x297b95;var _0x334c00;return db[_0xe4c6('0x2c')][_0xe4c6('0x4a')]({'where':{'id':_0x25fc14[_0xe4c6('0x45')]['id']}})[_0xe4c6('0x24')](handleEntityNotFound(_0x476662,null))[_0xe4c6('0x24')](function(_0x7d3978){if(_0x7d3978){_0x297b95=_0x7d3978;_0x52c98b[_0xe4c6('0x30')]=_[_0xe4c6('0x32')](db[_0xe4c6('0x4d')][_0xe4c6('0x2d')]);_0x52c98b[_0xe4c6('0x31')]=_['keys'](_0x25fc14['query']);_0x52c98b[_0xe4c6('0x33')]=_[_0xe4c6('0x34')](_0x52c98b['model'],_0x52c98b[_0xe4c6('0x31')]);_0x363ece[_0xe4c6('0x35')]=_[_0xe4c6('0x34')](_0x52c98b[_0xe4c6('0x30')],qs['fields'](_0x25fc14[_0xe4c6('0x31')][_0xe4c6('0x36')]));_0x363ece['attributes']=_0x363ece[_0xe4c6('0x35')][_0xe4c6('0x46')]?_0x363ece[_0xe4c6('0x35')]:_0x52c98b[_0xe4c6('0x30')];_0x363ece[_0xe4c6('0x39')]=qs['sort'](_0x25fc14[_0xe4c6('0x31')][_0xe4c6('0x3a')]);_0x363ece['where']=qs[_0xe4c6('0x33')](_[_0xe4c6('0x3c')](_0x25fc14[_0xe4c6('0x31')],_0x52c98b[_0xe4c6('0x33')]));if(_0x25fc14[_0xe4c6('0x31')]['filter']){_0x363ece[_0xe4c6('0x3b')]=_['merge'](_0x363ece[_0xe4c6('0x3b')],{'$or':_[_0xe4c6('0x2b')](_0x363ece[_0xe4c6('0x35')],function(_0x153e7e){var _0x1e1dca={};_0x1e1dca[_0x153e7e]={'$like':'%'+_0x25fc14[_0xe4c6('0x31')][_0xe4c6('0x3d')]+'%'};return _0x1e1dca;})});}_0x363ece=_[_0xe4c6('0x3e')]({},_0x363ece,_0x25fc14['options']);return _0x297b95['getSubjects'](_0x363ece);}})[_0xe4c6('0x24')](function(_0x2a0dfb){if(_0x2a0dfb){_0x334c00=_0x2a0dfb[_0xe4c6('0x46')];if(!_0x25fc14[_0xe4c6('0x31')]['hasOwnProperty'](_0xe4c6('0x38'))){_0x363ece[_0xe4c6('0x1c')]=qs['limit'](_0x25fc14[_0xe4c6('0x31')][_0xe4c6('0x1c')]);_0x363ece[_0xe4c6('0x1a')]=qs[_0xe4c6('0x1a')](_0x25fc14[_0xe4c6('0x31')][_0xe4c6('0x1a')]);}return _0x297b95['getSubjects'](_0x363ece);}})[_0xe4c6('0x24')](function(_0x595e95){if(_0x595e95){return _0x595e95?{'count':_0x334c00,'rows':_0x595e95}:null;}})[_0xe4c6('0x24')](respondWithResult(_0x476662,null))[_0xe4c6('0x44')](handleError(_0x476662,null));};exports['getDescriptions']=function(_0x480621,_0x1d66b1,_0x2344a6){var _0x22fcd0={};var _0x144fdb={};var _0xf144d8;var _0x3b7ea2;return db[_0xe4c6('0x2c')][_0xe4c6('0x4a')]({'where':{'id':_0x480621[_0xe4c6('0x45')]['id']}})[_0xe4c6('0x24')](handleEntityNotFound(_0x1d66b1,null))[_0xe4c6('0x24')](function(_0x1cb8f1){if(_0x1cb8f1){_0xf144d8=_0x1cb8f1;_0x144fdb[_0xe4c6('0x30')]=_['keys'](db[_0xe4c6('0x4d')][_0xe4c6('0x2d')]);_0x144fdb[_0xe4c6('0x31')]=_[_0xe4c6('0x32')](_0x480621['query']);_0x144fdb[_0xe4c6('0x33')]=_['intersection'](_0x144fdb[_0xe4c6('0x30')],_0x144fdb['query']);_0x22fcd0[_0xe4c6('0x35')]=_[_0xe4c6('0x34')](_0x144fdb[_0xe4c6('0x30')],qs[_0xe4c6('0x36')](_0x480621['query']['fields']));_0x22fcd0[_0xe4c6('0x35')]=_0x22fcd0[_0xe4c6('0x35')][_0xe4c6('0x46')]?_0x22fcd0['attributes']:_0x144fdb[_0xe4c6('0x30')];_0x22fcd0[_0xe4c6('0x39')]=qs[_0xe4c6('0x3a')](_0x480621['query'][_0xe4c6('0x3a')]);_0x22fcd0[_0xe4c6('0x3b')]=qs['filters'](_[_0xe4c6('0x3c')](_0x480621[_0xe4c6('0x31')],_0x144fdb[_0xe4c6('0x33')]));if(_0x480621[_0xe4c6('0x31')]['filter']){_0x22fcd0[_0xe4c6('0x3b')]=_[_0xe4c6('0x3e')](_0x22fcd0[_0xe4c6('0x3b')],{'$or':_[_0xe4c6('0x2b')](_0x22fcd0[_0xe4c6('0x35')],function(_0x1af3c6){var _0x1f8f8e={};_0x1f8f8e[_0x1af3c6]={'$like':'%'+_0x480621[_0xe4c6('0x31')][_0xe4c6('0x3d')]+'%'};return _0x1f8f8e;})});}_0x22fcd0=_[_0xe4c6('0x3e')]({},_0x22fcd0,_0x480621['options']);return _0xf144d8[_0xe4c6('0x4e')](_0x22fcd0);}})[_0xe4c6('0x24')](function(_0x18eedf){if(_0x18eedf){_0x3b7ea2=_0x18eedf['length'];if(!_0x480621[_0xe4c6('0x31')]['hasOwnProperty'](_0xe4c6('0x38'))){_0x22fcd0[_0xe4c6('0x1c')]=qs['limit'](_0x480621[_0xe4c6('0x31')][_0xe4c6('0x1c')]);_0x22fcd0[_0xe4c6('0x1a')]=qs[_0xe4c6('0x1a')](_0x480621[_0xe4c6('0x31')][_0xe4c6('0x1a')]);}return _0xf144d8[_0xe4c6('0x4e')](_0x22fcd0);}})[_0xe4c6('0x24')](function(_0x103750){if(_0x103750){return _0x103750?{'count':_0x3b7ea2,'rows':_0x103750}:null;}})['then'](respondWithResult(_0x1d66b1,null))[_0xe4c6('0x44')](handleError(_0x1d66b1,null));};