fae3588530f1f0535bdb8b2bf4fddcfdbbeb169e
[motion2.git] / 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 _0x9073=['status','undefined','count','offset','limit','set','json','apply','reject','save','update','then','destroy','error','name','send','map','rawAttributes','fieldName','type','model','keys','query','filters','intersection','attributes','fields','length','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','ZohoConfiguration','includeAll','findAll','rows','catch','show','params','include','options','find','create','body','findOne','ZohoField','hasOwnProperty','getFields','getSubjects','getDescriptions','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','jsforce','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus'];(function(_0x2840fd,_0x58b53b){var _0x54bfc5=function(_0x132811){while(--_0x132811){_0x2840fd['push'](_0x2840fd['shift']());}};_0x54bfc5(++_0x58b53b);}(_0x9073,0x1bc));var _0x3907=function(_0x525513,_0x44220c){_0x525513=_0x525513-0x0;var _0x17f77f=_0x9073[_0x525513];return _0x17f77f;};'use strict';var emlformat=require(_0x3907('0x0'));var rimraf=require(_0x3907('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x3907('0x2'));var rp=require(_0x3907('0x3'));var moment=require(_0x3907('0x4'));var BPromise=require(_0x3907('0x5'));var Mustache=require(_0x3907('0x6'));var util=require(_0x3907('0x7'));var path=require(_0x3907('0x8'));var sox=require('sox');var csv=require(_0x3907('0x9'));var ejs=require(_0x3907('0xa'));var fs=require('fs');var fs_extra=require(_0x3907('0xb'));var _=require(_0x3907('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x3907('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x3907('0x9'));var querystring=require(_0x3907('0xe'));var Papa=require(_0x3907('0xf'));var Redis=require(_0x3907('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x3907('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x3907('0x12'))(_0x3907('0x13'));var utils=require('../../config/utils');var config=require(_0x3907('0x14'));var licenseUtil=require(_0x3907('0x15'));var db=require(_0x3907('0x16'))['db'];function respondWithStatusCode(_0x403e5f,_0x507bb8){_0x507bb8=_0x507bb8||0xcc;return function(_0x2c85b9){if(_0x2c85b9){return _0x403e5f[_0x3907('0x17')](_0x507bb8);}return _0x403e5f[_0x3907('0x18')](_0x507bb8)['end']();};}function respondWithResult(_0x2d1bd4,_0x3134a5){_0x3134a5=_0x3134a5||0xc8;return function(_0x4ba051){if(_0x4ba051){return _0x2d1bd4[_0x3907('0x18')](_0x3134a5)['json'](_0x4ba051);}};}function respondWithFilteredResult(_0x369a34,_0x39c312){return function(_0x4ed8a2){if(_0x4ed8a2){var _0x509aa8=typeof _0x39c312['offset']===_0x3907('0x19')&&typeof _0x39c312['limit']===_0x3907('0x19');var _0x2c60b2=_0x4ed8a2[_0x3907('0x1a')];var _0x5b6728=_0x509aa8?0x0:_0x39c312[_0x3907('0x1b')];var _0x12bb9f=_0x509aa8?_0x4ed8a2[_0x3907('0x1a')]:_0x39c312[_0x3907('0x1b')]+_0x39c312[_0x3907('0x1c')];var _0x25ae86;if(_0x12bb9f>=_0x2c60b2){_0x12bb9f=_0x2c60b2;_0x25ae86=0xc8;}else{_0x25ae86=0xce;}_0x369a34[_0x3907('0x18')](_0x25ae86);return _0x369a34[_0x3907('0x1d')]('Content-Range',_0x5b6728+'-'+_0x12bb9f+'/'+_0x2c60b2)[_0x3907('0x1e')](_0x4ed8a2);}return null;};}function patchUpdates(_0x235caa){return function(_0x431156){try{jsonpatch[_0x3907('0x1f')](_0x431156,_0x235caa,!![]);}catch(_0x4ac552){return BPromise[_0x3907('0x20')](_0x4ac552);}return _0x431156[_0x3907('0x21')]();};}function saveUpdates(_0x11beb7,_0x21c287){return function(_0x295141){if(_0x295141){return _0x295141[_0x3907('0x22')](_0x11beb7)[_0x3907('0x23')](function(_0x4fcfe3){return _0x4fcfe3;});}return null;};}function removeEntity(_0x15bc00,_0x1bde35){return function(_0x1e47c9){if(_0x1e47c9){return _0x1e47c9[_0x3907('0x24')]()[_0x3907('0x23')](function(){_0x15bc00['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0xc056ce,_0x953c98){return function(_0x22e2c8){if(!_0x22e2c8){_0xc056ce['sendStatus'](0x194);}return _0x22e2c8;};}function handleError(_0x5dbae5,_0x1d974f){_0x1d974f=_0x1d974f||0x1f4;return function(_0x668b96){logger[_0x3907('0x25')](_0x668b96['stack']);if(_0x668b96[_0x3907('0x26')]){delete _0x668b96['name'];}_0x5dbae5[_0x3907('0x18')](_0x1d974f)[_0x3907('0x27')](_0x668b96);};}exports['index']=function(_0x1c5425,_0x569de1){var _0x2b26ab={},_0x348212={},_0x271d2c={'count':0x0,'rows':[]};var _0x7061f0=_[_0x3907('0x28')](db['ZohoConfiguration'][_0x3907('0x29')],function(_0x559ab0){return{'name':_0x559ab0[_0x3907('0x2a')],'type':_0x559ab0[_0x3907('0x2b')]['key']};});_0x348212[_0x3907('0x2c')]=_[_0x3907('0x28')](_0x7061f0,_0x3907('0x26'));_0x348212['query']=_[_0x3907('0x2d')](_0x1c5425[_0x3907('0x2e')]);_0x348212[_0x3907('0x2f')]=_[_0x3907('0x30')](_0x348212[_0x3907('0x2c')],_0x348212[_0x3907('0x2e')]);_0x2b26ab[_0x3907('0x31')]=_[_0x3907('0x30')](_0x348212[_0x3907('0x2c')],qs['fields'](_0x1c5425[_0x3907('0x2e')][_0x3907('0x32')]));_0x2b26ab['attributes']=_0x2b26ab[_0x3907('0x31')][_0x3907('0x33')]?_0x2b26ab['attributes']:_0x348212['model'];if(!_0x1c5425['query']['hasOwnProperty'](_0x3907('0x34'))){_0x2b26ab['limit']=qs[_0x3907('0x1c')](_0x1c5425[_0x3907('0x2e')][_0x3907('0x1c')]);_0x2b26ab[_0x3907('0x1b')]=qs[_0x3907('0x1b')](_0x1c5425['query'][_0x3907('0x1b')]);}_0x2b26ab[_0x3907('0x35')]=qs[_0x3907('0x36')](_0x1c5425[_0x3907('0x2e')][_0x3907('0x36')]);_0x2b26ab['where']=qs[_0x3907('0x2f')](_[_0x3907('0x37')](_0x1c5425['query'],_0x348212['filters']),_0x7061f0);if(_0x1c5425[_0x3907('0x2e')][_0x3907('0x38')]){_0x2b26ab[_0x3907('0x39')]=_[_0x3907('0x3a')](_0x2b26ab[_0x3907('0x39')],{'$or':_[_0x3907('0x28')](_0x7061f0,function(_0x4120b7){if(_0x4120b7[_0x3907('0x2b')]!==_0x3907('0x3b')){var _0x1a7b67={};_0x1a7b67[_0x4120b7[_0x3907('0x26')]]={'$like':'%'+_0x1c5425[_0x3907('0x2e')][_0x3907('0x38')]+'%'};return _0x1a7b67;}})});}_0x2b26ab=_['merge']({},_0x2b26ab,_0x1c5425['options']);var _0x5d3399={'where':_0x2b26ab[_0x3907('0x39')]};return db[_0x3907('0x3c')]['count'](_0x5d3399)[_0x3907('0x23')](function(_0x49408b){_0x271d2c[_0x3907('0x1a')]=_0x49408b;if(_0x1c5425[_0x3907('0x2e')][_0x3907('0x3d')]){_0x2b26ab['include']=[{'all':!![]}];}return db[_0x3907('0x3c')][_0x3907('0x3e')](_0x2b26ab);})[_0x3907('0x23')](function(_0x221559){_0x271d2c[_0x3907('0x3f')]=_0x221559;return _0x271d2c;})['then'](respondWithFilteredResult(_0x569de1,_0x2b26ab))[_0x3907('0x40')](handleError(_0x569de1,null));};exports[_0x3907('0x41')]=function(_0xd5a3c8,_0x3affd2){var _0x5530b9={'raw':![],'where':{'id':_0xd5a3c8[_0x3907('0x42')]['id']}},_0x4a655b={};_0x4a655b[_0x3907('0x2c')]=_[_0x3907('0x2d')](db[_0x3907('0x3c')]['rawAttributes']);_0x4a655b[_0x3907('0x2e')]=_[_0x3907('0x2d')](_0xd5a3c8[_0x3907('0x2e')]);_0x4a655b[_0x3907('0x2f')]=_[_0x3907('0x30')](_0x4a655b[_0x3907('0x2c')],_0x4a655b[_0x3907('0x2e')]);_0x5530b9[_0x3907('0x31')]=_['intersection'](_0x4a655b[_0x3907('0x2c')],qs[_0x3907('0x32')](_0xd5a3c8[_0x3907('0x2e')][_0x3907('0x32')]));_0x5530b9[_0x3907('0x31')]=_0x5530b9[_0x3907('0x31')][_0x3907('0x33')]?_0x5530b9[_0x3907('0x31')]:_0x4a655b[_0x3907('0x2c')];if(_0xd5a3c8[_0x3907('0x2e')]['includeAll']){_0x5530b9[_0x3907('0x43')]=[{'all':!![]}];}_0x5530b9=_[_0x3907('0x3a')]({},_0x5530b9,_0xd5a3c8[_0x3907('0x44')]);return db[_0x3907('0x3c')][_0x3907('0x45')](_0x5530b9)[_0x3907('0x23')](handleEntityNotFound(_0x3affd2,null))[_0x3907('0x23')](respondWithResult(_0x3affd2,null))['catch'](handleError(_0x3affd2,null));};exports[_0x3907('0x46')]=function(_0x19f8e3,_0x46d3de){return db['ZohoConfiguration']['create'](_0x19f8e3['body'],{})[_0x3907('0x23')](respondWithResult(_0x46d3de,0xc9))['catch'](handleError(_0x46d3de,null));};exports['update']=function(_0x4af532,_0x14504e){if(_0x4af532[_0x3907('0x47')]['id']){delete _0x4af532[_0x3907('0x47')]['id'];}return db[_0x3907('0x3c')]['find']({'where':{'id':_0x4af532[_0x3907('0x42')]['id']}})[_0x3907('0x23')](handleEntityNotFound(_0x14504e,null))['then'](saveUpdates(_0x4af532[_0x3907('0x47')],null))[_0x3907('0x23')](respondWithResult(_0x14504e,null))[_0x3907('0x40')](handleError(_0x14504e,null));};exports['destroy']=function(_0x19e02e,_0x343937){return db['ZohoConfiguration'][_0x3907('0x45')]({'where':{'id':_0x19e02e[_0x3907('0x42')]['id']}})[_0x3907('0x23')](handleEntityNotFound(_0x343937,null))[_0x3907('0x23')](removeEntity(_0x343937,null))['catch'](handleError(_0x343937,null));};exports['getFields']=function(_0x1aac89,_0x2d2ecc,_0x546e96){var _0x5af94e={};var _0x3514ef={};var _0x5e5e4f;var _0x3f78c8;return db[_0x3907('0x3c')][_0x3907('0x48')]({'where':{'id':_0x1aac89[_0x3907('0x42')]['id']}})[_0x3907('0x23')](handleEntityNotFound(_0x2d2ecc,null))['then'](function(_0x5093cc){if(_0x5093cc){_0x5e5e4f=_0x5093cc;_0x3514ef[_0x3907('0x2c')]=_[_0x3907('0x2d')](db[_0x3907('0x49')][_0x3907('0x29')]);_0x3514ef[_0x3907('0x2e')]=_[_0x3907('0x2d')](_0x1aac89['query']);_0x3514ef['filters']=_['intersection'](_0x3514ef[_0x3907('0x2c')],_0x3514ef[_0x3907('0x2e')]);_0x5af94e[_0x3907('0x31')]=_['intersection'](_0x3514ef[_0x3907('0x2c')],qs[_0x3907('0x32')](_0x1aac89[_0x3907('0x2e')]['fields']));_0x5af94e[_0x3907('0x31')]=_0x5af94e['attributes'][_0x3907('0x33')]?_0x5af94e[_0x3907('0x31')]:_0x3514ef['model'];_0x5af94e[_0x3907('0x35')]=qs[_0x3907('0x36')](_0x1aac89[_0x3907('0x2e')][_0x3907('0x36')]);_0x5af94e[_0x3907('0x39')]=qs[_0x3907('0x2f')](_[_0x3907('0x37')](_0x1aac89['query'],_0x3514ef[_0x3907('0x2f')]));if(_0x1aac89[_0x3907('0x2e')][_0x3907('0x38')]){_0x5af94e[_0x3907('0x39')]=_[_0x3907('0x3a')](_0x5af94e[_0x3907('0x39')],{'$or':_[_0x3907('0x28')](_0x5af94e[_0x3907('0x31')],function(_0x54b803){var _0x3794b9={};_0x3794b9[_0x54b803]={'$like':'%'+_0x1aac89[_0x3907('0x2e')][_0x3907('0x38')]+'%'};return _0x3794b9;})});}_0x5af94e=_[_0x3907('0x3a')]({},_0x5af94e,_0x1aac89[_0x3907('0x44')]);return _0x5e5e4f['getFields'](_0x5af94e);}})[_0x3907('0x23')](function(_0x22e557){if(_0x22e557){_0x3f78c8=_0x22e557['length'];if(!_0x1aac89[_0x3907('0x2e')][_0x3907('0x4a')](_0x3907('0x34'))){_0x5af94e[_0x3907('0x1c')]=qs[_0x3907('0x1c')](_0x1aac89[_0x3907('0x2e')][_0x3907('0x1c')]);_0x5af94e[_0x3907('0x1b')]=qs[_0x3907('0x1b')](_0x1aac89['query'][_0x3907('0x1b')]);}return _0x5e5e4f[_0x3907('0x4b')](_0x5af94e);}})['then'](function(_0xfc4ab1){if(_0xfc4ab1){return _0xfc4ab1?{'count':_0x3f78c8,'rows':_0xfc4ab1}:null;}})['then'](respondWithResult(_0x2d2ecc,null))['catch'](handleError(_0x2d2ecc,null));};exports[_0x3907('0x4c')]=function(_0x32e6e5,_0x3fcb2e,_0x38465c){var _0x33e05f={};var _0x13058a={};var _0x2da4bd;var _0x1ea06e;return db[_0x3907('0x3c')][_0x3907('0x48')]({'where':{'id':_0x32e6e5[_0x3907('0x42')]['id']}})[_0x3907('0x23')](handleEntityNotFound(_0x3fcb2e,null))['then'](function(_0x2ca312){if(_0x2ca312){_0x2da4bd=_0x2ca312;_0x13058a[_0x3907('0x2c')]=_[_0x3907('0x2d')](db[_0x3907('0x49')]['rawAttributes']);_0x13058a[_0x3907('0x2e')]=_[_0x3907('0x2d')](_0x32e6e5[_0x3907('0x2e')]);_0x13058a[_0x3907('0x2f')]=_[_0x3907('0x30')](_0x13058a[_0x3907('0x2c')],_0x13058a[_0x3907('0x2e')]);_0x33e05f[_0x3907('0x31')]=_[_0x3907('0x30')](_0x13058a[_0x3907('0x2c')],qs[_0x3907('0x32')](_0x32e6e5['query'][_0x3907('0x32')]));_0x33e05f['attributes']=_0x33e05f[_0x3907('0x31')][_0x3907('0x33')]?_0x33e05f[_0x3907('0x31')]:_0x13058a[_0x3907('0x2c')];_0x33e05f[_0x3907('0x35')]=qs[_0x3907('0x36')](_0x32e6e5[_0x3907('0x2e')][_0x3907('0x36')]);_0x33e05f[_0x3907('0x39')]=qs[_0x3907('0x2f')](_[_0x3907('0x37')](_0x32e6e5[_0x3907('0x2e')],_0x13058a['filters']));if(_0x32e6e5['query'][_0x3907('0x38')]){_0x33e05f[_0x3907('0x39')]=_['merge'](_0x33e05f[_0x3907('0x39')],{'$or':_[_0x3907('0x28')](_0x33e05f[_0x3907('0x31')],function(_0xf56fe7){var _0x400c4d={};_0x400c4d[_0xf56fe7]={'$like':'%'+_0x32e6e5['query'][_0x3907('0x38')]+'%'};return _0x400c4d;})});}_0x33e05f=_[_0x3907('0x3a')]({},_0x33e05f,_0x32e6e5[_0x3907('0x44')]);return _0x2da4bd[_0x3907('0x4c')](_0x33e05f);}})[_0x3907('0x23')](function(_0x16def2){if(_0x16def2){_0x1ea06e=_0x16def2[_0x3907('0x33')];if(!_0x32e6e5[_0x3907('0x2e')][_0x3907('0x4a')](_0x3907('0x34'))){_0x33e05f[_0x3907('0x1c')]=qs[_0x3907('0x1c')](_0x32e6e5['query'][_0x3907('0x1c')]);_0x33e05f['offset']=qs[_0x3907('0x1b')](_0x32e6e5[_0x3907('0x2e')][_0x3907('0x1b')]);}return _0x2da4bd[_0x3907('0x4c')](_0x33e05f);}})['then'](function(_0x41ff6f){if(_0x41ff6f){return _0x41ff6f?{'count':_0x1ea06e,'rows':_0x41ff6f}:null;}})[_0x3907('0x23')](respondWithResult(_0x3fcb2e,null))[_0x3907('0x40')](handleError(_0x3fcb2e,null));};exports[_0x3907('0x4d')]=function(_0x4445cf,_0x29e591,_0x28bce0){var _0xd63c67={};var _0x2d23a8={};var _0x197801;var _0x351d9a;return db[_0x3907('0x3c')][_0x3907('0x48')]({'where':{'id':_0x4445cf[_0x3907('0x42')]['id']}})[_0x3907('0x23')](handleEntityNotFound(_0x29e591,null))[_0x3907('0x23')](function(_0x4e4408){if(_0x4e4408){_0x197801=_0x4e4408;_0x2d23a8[_0x3907('0x2c')]=_['keys'](db['ZohoField'][_0x3907('0x29')]);_0x2d23a8[_0x3907('0x2e')]=_[_0x3907('0x2d')](_0x4445cf[_0x3907('0x2e')]);_0x2d23a8[_0x3907('0x2f')]=_[_0x3907('0x30')](_0x2d23a8[_0x3907('0x2c')],_0x2d23a8['query']);_0xd63c67[_0x3907('0x31')]=_[_0x3907('0x30')](_0x2d23a8[_0x3907('0x2c')],qs[_0x3907('0x32')](_0x4445cf['query'][_0x3907('0x32')]));_0xd63c67[_0x3907('0x31')]=_0xd63c67[_0x3907('0x31')][_0x3907('0x33')]?_0xd63c67[_0x3907('0x31')]:_0x2d23a8['model'];_0xd63c67[_0x3907('0x35')]=qs[_0x3907('0x36')](_0x4445cf[_0x3907('0x2e')][_0x3907('0x36')]);_0xd63c67[_0x3907('0x39')]=qs[_0x3907('0x2f')](_[_0x3907('0x37')](_0x4445cf[_0x3907('0x2e')],_0x2d23a8[_0x3907('0x2f')]));if(_0x4445cf[_0x3907('0x2e')]['filter']){_0xd63c67[_0x3907('0x39')]=_[_0x3907('0x3a')](_0xd63c67['where'],{'$or':_['map'](_0xd63c67[_0x3907('0x31')],function(_0x511022){var _0x401bde={};_0x401bde[_0x511022]={'$like':'%'+_0x4445cf['query'][_0x3907('0x38')]+'%'};return _0x401bde;})});}_0xd63c67=_['merge']({},_0xd63c67,_0x4445cf[_0x3907('0x44')]);return _0x197801[_0x3907('0x4d')](_0xd63c67);}})[_0x3907('0x23')](function(_0x38092e){if(_0x38092e){_0x351d9a=_0x38092e['length'];if(!_0x4445cf[_0x3907('0x2e')][_0x3907('0x4a')](_0x3907('0x34'))){_0xd63c67[_0x3907('0x1c')]=qs['limit'](_0x4445cf[_0x3907('0x2e')][_0x3907('0x1c')]);_0xd63c67[_0x3907('0x1b')]=qs['offset'](_0x4445cf['query'][_0x3907('0x1b')]);}return _0x197801['getDescriptions'](_0xd63c67);}})['then'](function(_0x340220){if(_0x340220){return _0x340220?{'count':_0x351d9a,'rows':_0x340220}:null;}})[_0x3907('0x23')](respondWithResult(_0x29e591,null))[_0x3907('0x40')](handleError(_0x29e591,null));};