bafae967ef0703ad861dd557cb2d17fab0fe09d6
[motion2.git] / server / api / intZohoAccount / intZohoAccount.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 _0xa535=['limit','undefined','set','Content-Range','json','apply','reject','destroy','then','error','stack','name','send','ZohoAccount','rawAttributes','type','key','model','map','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','count','includeAll','include','catch','show','params','find','create','update','body','findOne','ZohoConfiguration','getConfigurations','addConfiguration','Subjects','getSubjects','channel','Descriptions','getDescriptions','zone','https://accounts.zoho.com','https://accounts.zoho.eu','https://accounts.zoho.in','https://accounts.zoho.com.cn','POST','refreshToken','clientId','access_token','getFields','serverUrl','code','host','com','slice','substring','lastIndexOf','Refresh\x20Token\x20not\x20available\x20for\x20the\x20account','GET','Calls','Zoho-oauthtoken\x20','response','Owner','Call_Duration','Call_Result','Call_Type','includes','api_name','system_mandatory','push','display_label','custom_field','pick_list_values','test','Wrong\x20credentials','statusCode','eml-format','zip-dir','fast-json-patch','moment','bluebird','util','path','to-csv','fs-extra','lodash','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','sendStatus','status','end','offset'];(function(_0x31bca9,_0x1fac97){var _0x54af10=function(_0x5f502b){while(--_0x5f502b){_0x31bca9['push'](_0x31bca9['shift']());}};_0x54af10(++_0x1fac97);}(_0xa535,0x145));var _0x5a53=function(_0xfbcb23,_0x56c545){_0xfbcb23=_0xfbcb23-0x0;var _0x588786=_0xa535[_0xfbcb23];return _0x588786;};'use strict';var emlformat=require(_0x5a53('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x5a53('0x1'));var jsonpatch=require(_0x5a53('0x2'));var rp=require('request-promise');var moment=require(_0x5a53('0x3'));var BPromise=require(_0x5a53('0x4'));var Mustache=require('mustache');var util=require(_0x5a53('0x5'));var path=require(_0x5a53('0x6'));var sox=require('sox');var csv=require(_0x5a53('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x5a53('0x8'));var _=require(_0x5a53('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x5a53('0xa'));var deskjs=require(_0x5a53('0xb'));var toCsv=require(_0x5a53('0x7'));var querystring=require(_0x5a53('0xc'));var Papa=require(_0x5a53('0xd'));var Redis=require('ioredis');var authService=require(_0x5a53('0xe'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x5a53('0xf'));var logger=require(_0x5a53('0x10'))('api');var utils=require(_0x5a53('0x11'));var config=require(_0x5a53('0x12'));var licenseUtil=require(_0x5a53('0x13'));var db=require(_0x5a53('0x14'))['db'];var integrations=require(_0x5a53('0x15'));function respondWithStatusCode(_0x580031,_0x4111e4){_0x4111e4=_0x4111e4||0xcc;return function(_0x5635f8){if(_0x5635f8){return _0x580031[_0x5a53('0x16')](_0x4111e4);}return _0x580031[_0x5a53('0x17')](_0x4111e4)[_0x5a53('0x18')]();};}function respondWithResult(_0x332fe6,_0x561f26){_0x561f26=_0x561f26||0xc8;return function(_0x2f4a5){if(_0x2f4a5){return _0x332fe6[_0x5a53('0x17')](_0x561f26)['json'](_0x2f4a5);}};}function respondWithFilteredResult(_0x569996,_0x2e4cfe){return function(_0x305b6c){if(_0x305b6c){var _0x2789a3=typeof _0x2e4cfe[_0x5a53('0x19')]==='undefined'&&typeof _0x2e4cfe[_0x5a53('0x1a')]===_0x5a53('0x1b');var _0x591cd3=_0x305b6c['count'];var _0x162c83=_0x2789a3?0x0:_0x2e4cfe[_0x5a53('0x19')];var _0x7be47=_0x2789a3?_0x305b6c['count']:_0x2e4cfe['offset']+_0x2e4cfe[_0x5a53('0x1a')];var _0x57d77e;if(_0x7be47>=_0x591cd3){_0x7be47=_0x591cd3;_0x57d77e=0xc8;}else{_0x57d77e=0xce;}_0x569996[_0x5a53('0x17')](_0x57d77e);return _0x569996[_0x5a53('0x1c')](_0x5a53('0x1d'),_0x162c83+'-'+_0x7be47+'/'+_0x591cd3)[_0x5a53('0x1e')](_0x305b6c);}return null;};}function patchUpdates(_0x28e364){return function(_0x1a3f6c){try{jsonpatch[_0x5a53('0x1f')](_0x1a3f6c,_0x28e364,!![]);}catch(_0x544497){return BPromise[_0x5a53('0x20')](_0x544497);}return _0x1a3f6c['save']();};}function saveUpdates(_0x68a505,_0x36fd41){return function(_0x1667c5){if(_0x1667c5){return _0x1667c5['update'](_0x68a505)['then'](function(_0x159f6b){return _0x159f6b;});}return null;};}function removeEntity(_0x235926,_0x44ec86){return function(_0x2d0949){if(_0x2d0949){return _0x2d0949[_0x5a53('0x21')]()[_0x5a53('0x22')](function(){_0x235926['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x379e79,_0x5b8ae5){return function(_0x4bfae5){if(!_0x4bfae5){_0x379e79['sendStatus'](0x194);}return _0x4bfae5;};}function handleError(_0x4015ef,_0x109a70){_0x109a70=_0x109a70||0x1f4;return function(_0x4c0dee){logger[_0x5a53('0x23')](_0x4c0dee[_0x5a53('0x24')]);if(_0x4c0dee[_0x5a53('0x25')]){delete _0x4c0dee['name'];}_0x4015ef[_0x5a53('0x17')](_0x109a70)[_0x5a53('0x26')](_0x4c0dee);};}exports['index']=function(_0x4cd3c0,_0x254305){var _0x13cecd={},_0x39ce5c={},_0x430a7b={'count':0x0,'rows':[]};var _0x22f462=_['map'](db[_0x5a53('0x27')][_0x5a53('0x28')],function(_0x42673e){return{'name':_0x42673e['fieldName'],'type':_0x42673e[_0x5a53('0x29')][_0x5a53('0x2a')]};});_0x39ce5c[_0x5a53('0x2b')]=_[_0x5a53('0x2c')](_0x22f462,_0x5a53('0x25'));_0x39ce5c[_0x5a53('0x2d')]=_[_0x5a53('0x2e')](_0x4cd3c0[_0x5a53('0x2d')]);_0x39ce5c[_0x5a53('0x2f')]=_[_0x5a53('0x30')](_0x39ce5c[_0x5a53('0x2b')],_0x39ce5c[_0x5a53('0x2d')]);_0x13cecd[_0x5a53('0x31')]=_[_0x5a53('0x30')](_0x39ce5c[_0x5a53('0x2b')],qs[_0x5a53('0x32')](_0x4cd3c0['query'][_0x5a53('0x32')]));_0x13cecd[_0x5a53('0x31')]=_0x13cecd['attributes'][_0x5a53('0x33')]?_0x13cecd[_0x5a53('0x31')]:_0x39ce5c['model'];if(!_0x4cd3c0[_0x5a53('0x2d')][_0x5a53('0x34')](_0x5a53('0x35'))){_0x13cecd[_0x5a53('0x1a')]=qs[_0x5a53('0x1a')](_0x4cd3c0[_0x5a53('0x2d')][_0x5a53('0x1a')]);_0x13cecd[_0x5a53('0x19')]=qs[_0x5a53('0x19')](_0x4cd3c0[_0x5a53('0x2d')][_0x5a53('0x19')]);}_0x13cecd[_0x5a53('0x36')]=qs[_0x5a53('0x37')](_0x4cd3c0[_0x5a53('0x2d')][_0x5a53('0x37')]);_0x13cecd[_0x5a53('0x38')]=qs['filters'](_[_0x5a53('0x39')](_0x4cd3c0[_0x5a53('0x2d')],_0x39ce5c[_0x5a53('0x2f')]),_0x22f462);if(_0x4cd3c0[_0x5a53('0x2d')][_0x5a53('0x3a')]){_0x13cecd['where']=_[_0x5a53('0x3b')](_0x13cecd[_0x5a53('0x38')],{'$or':_[_0x5a53('0x2c')](_0x22f462,function(_0x20864f){if(_0x20864f[_0x5a53('0x29')]!==_0x5a53('0x3c')){var _0x1bb544={};_0x1bb544[_0x20864f['name']]={'$like':'%'+_0x4cd3c0[_0x5a53('0x2d')][_0x5a53('0x3a')]+'%'};return _0x1bb544;}})});}_0x13cecd=_['merge']({},_0x13cecd,_0x4cd3c0[_0x5a53('0x3d')]);var _0x46e80b={'where':_0x13cecd[_0x5a53('0x38')]};return db[_0x5a53('0x27')][_0x5a53('0x3e')](_0x46e80b)['then'](function(_0x302d6c){_0x430a7b['count']=_0x302d6c;if(_0x4cd3c0[_0x5a53('0x2d')][_0x5a53('0x3f')]){_0x13cecd[_0x5a53('0x40')]=[{'all':!![]}];}return db[_0x5a53('0x27')]['findAll'](_0x13cecd);})[_0x5a53('0x22')](function(_0x182a5c){_0x430a7b['rows']=_0x182a5c;return _0x430a7b;})['then'](respondWithFilteredResult(_0x254305,_0x13cecd))[_0x5a53('0x41')](handleError(_0x254305,null));};exports[_0x5a53('0x42')]=function(_0x13d1f8,_0x4ee851){var _0xdf2ccb={'raw':![],'where':{'id':_0x13d1f8[_0x5a53('0x43')]['id']}},_0x2e4f85={};_0x2e4f85[_0x5a53('0x2b')]=_['keys'](db[_0x5a53('0x27')][_0x5a53('0x28')]);_0x2e4f85[_0x5a53('0x2d')]=_[_0x5a53('0x2e')](_0x13d1f8[_0x5a53('0x2d')]);_0x2e4f85[_0x5a53('0x2f')]=_[_0x5a53('0x30')](_0x2e4f85[_0x5a53('0x2b')],_0x2e4f85['query']);_0xdf2ccb[_0x5a53('0x31')]=_[_0x5a53('0x30')](_0x2e4f85[_0x5a53('0x2b')],qs['fields'](_0x13d1f8[_0x5a53('0x2d')][_0x5a53('0x32')]));_0xdf2ccb[_0x5a53('0x31')]=_0xdf2ccb[_0x5a53('0x31')][_0x5a53('0x33')]?_0xdf2ccb[_0x5a53('0x31')]:_0x2e4f85[_0x5a53('0x2b')];if(_0x13d1f8['query'][_0x5a53('0x3f')]){_0xdf2ccb[_0x5a53('0x40')]=[{'all':!![]}];}_0xdf2ccb=_[_0x5a53('0x3b')]({},_0xdf2ccb,_0x13d1f8[_0x5a53('0x3d')]);return db['ZohoAccount'][_0x5a53('0x44')](_0xdf2ccb)[_0x5a53('0x22')](handleEntityNotFound(_0x4ee851,null))[_0x5a53('0x22')](respondWithResult(_0x4ee851,null))['catch'](handleError(_0x4ee851,null));};exports[_0x5a53('0x45')]=function(_0x8769f3,_0x4dea91){return db['ZohoAccount'][_0x5a53('0x45')](_0x8769f3['body'],{})[_0x5a53('0x22')](respondWithResult(_0x4dea91,0xc9))[_0x5a53('0x41')](handleError(_0x4dea91,null));};exports[_0x5a53('0x46')]=function(_0x1a4672,_0x57a8c5){if(_0x1a4672[_0x5a53('0x47')]['id']){delete _0x1a4672[_0x5a53('0x47')]['id'];}return db['ZohoAccount'][_0x5a53('0x44')]({'where':{'id':_0x1a4672[_0x5a53('0x43')]['id']}})[_0x5a53('0x22')](handleEntityNotFound(_0x57a8c5,null))[_0x5a53('0x22')](saveUpdates(_0x1a4672[_0x5a53('0x47')],null))[_0x5a53('0x22')](respondWithResult(_0x57a8c5,null))['catch'](handleError(_0x57a8c5,null));};exports[_0x5a53('0x21')]=function(_0x52eba9,_0x4c08f7){return db[_0x5a53('0x27')][_0x5a53('0x44')]({'where':{'id':_0x52eba9[_0x5a53('0x43')]['id']}})[_0x5a53('0x22')](handleEntityNotFound(_0x4c08f7,null))[_0x5a53('0x22')](removeEntity(_0x4c08f7,null))['catch'](handleError(_0x4c08f7,null));};exports['getConfigurations']=function(_0x258d81,_0x47ab40,_0x3371da){var _0x6a434f={};var _0x3a8191={};var _0x21465f;var _0x185a37;return db[_0x5a53('0x27')][_0x5a53('0x48')]({'where':{'id':_0x258d81[_0x5a53('0x43')]['id']}})['then'](handleEntityNotFound(_0x47ab40,null))[_0x5a53('0x22')](function(_0x1755d9){if(_0x1755d9){_0x21465f=_0x1755d9;_0x3a8191[_0x5a53('0x2b')]=_[_0x5a53('0x2e')](db[_0x5a53('0x49')][_0x5a53('0x28')]);_0x3a8191['query']=_['keys'](_0x258d81['query']);_0x3a8191['filters']=_['intersection'](_0x3a8191['model'],_0x3a8191[_0x5a53('0x2d')]);_0x6a434f[_0x5a53('0x31')]=_[_0x5a53('0x30')](_0x3a8191[_0x5a53('0x2b')],qs['fields'](_0x258d81['query'][_0x5a53('0x32')]));_0x6a434f[_0x5a53('0x31')]=_0x6a434f['attributes'][_0x5a53('0x33')]?_0x6a434f['attributes']:_0x3a8191[_0x5a53('0x2b')];_0x6a434f['order']=qs[_0x5a53('0x37')](_0x258d81['query'][_0x5a53('0x37')]);_0x6a434f[_0x5a53('0x38')]=qs['filters'](_[_0x5a53('0x39')](_0x258d81['query'],_0x3a8191['filters']));if(_0x258d81['query']['filter']){_0x6a434f[_0x5a53('0x38')]=_[_0x5a53('0x3b')](_0x6a434f['where'],{'$or':_[_0x5a53('0x2c')](_0x6a434f[_0x5a53('0x31')],function(_0x458e0b){var _0x147cd8={};_0x147cd8[_0x458e0b]={'$like':'%'+_0x258d81[_0x5a53('0x2d')]['filter']+'%'};return _0x147cd8;})});}_0x6a434f=_[_0x5a53('0x3b')]({},_0x6a434f,_0x258d81[_0x5a53('0x3d')]);return _0x21465f[_0x5a53('0x4a')](_0x6a434f);}})[_0x5a53('0x22')](function(_0x8da35b){if(_0x8da35b){_0x185a37=_0x8da35b['length'];if(!_0x258d81[_0x5a53('0x2d')][_0x5a53('0x34')](_0x5a53('0x35'))){_0x6a434f['limit']=qs['limit'](_0x258d81[_0x5a53('0x2d')]['limit']);_0x6a434f[_0x5a53('0x19')]=qs[_0x5a53('0x19')](_0x258d81[_0x5a53('0x2d')][_0x5a53('0x19')]);}return _0x21465f[_0x5a53('0x4a')](_0x6a434f);}})['then'](function(_0x24c3b1){if(_0x24c3b1){return _0x24c3b1?{'count':_0x185a37,'rows':_0x24c3b1}:null;}})[_0x5a53('0x22')](respondWithResult(_0x47ab40,null))[_0x5a53('0x41')](handleError(_0x47ab40,null));};exports[_0x5a53('0x4b')]=function(_0x43ade0,_0x14ebff,_0x2ec368){if(_0x43ade0['body']['id']){delete _0x43ade0[_0x5a53('0x47')]['id'];}return db[_0x5a53('0x27')][_0x5a53('0x48')]({'where':{'id':_0x43ade0[_0x5a53('0x43')]['id']}})[_0x5a53('0x22')](handleEntityNotFound(_0x14ebff,null))['then'](function(_0x28306a){if(_0x28306a){_0x43ade0[_0x5a53('0x47')]['AccountId']=_0x28306a['id'];_0x43ade0[_0x5a53('0x47')][_0x5a53('0x4c')]=integrations[_0x5a53('0x4d')](_0x43ade0[_0x5a53('0x47')][_0x5a53('0x4e')],_0x43ade0[_0x5a53('0x47')][_0x5a53('0x29')]);_0x43ade0[_0x5a53('0x47')][_0x5a53('0x4f')]=integrations[_0x5a53('0x50')](_0x43ade0[_0x5a53('0x47')][_0x5a53('0x4e')],_0x43ade0['body'][_0x5a53('0x29')]);return db[_0x5a53('0x49')]['create'](_0x43ade0[_0x5a53('0x47')],{'include':[{'model':db['ZohoField'],'as':_0x5a53('0x4c')},{'model':db['ZohoField'],'as':'Descriptions'}]});}return null;})['then'](respondWithResult(_0x14ebff,null))[_0x5a53('0x41')](handleError(_0x14ebff,null));};function getAccessToken(_0x1bbece){return new Promise(function(_0x2e3263,_0x88c701){var _0xf366dc;switch(_0x1bbece[_0x5a53('0x51')]){case'US':_0xf366dc=_0x5a53('0x52');break;case'AU':_0xf366dc='https://accounts.zoho.com.au';break;case'EU':_0xf366dc=_0x5a53('0x53');break;case'IN':_0xf366dc=_0x5a53('0x54');break;case'CN':_0xf366dc=_0x5a53('0x55');break;default:_0xf366dc='https://accounts.zoho.eu';break;}var _0x485f35={'method':_0x5a53('0x56'),'uri':_0xf366dc+'/oauth/v2/token','qs':{'refresh_token':_0x1bbece[_0x5a53('0x57')],'client_id':_0x1bbece[_0x5a53('0x58')],'client_secret':_0x1bbece['clientSecret'],'grant_type':'refresh_token'},'json':!![]};return rp(_0x485f35)[_0x5a53('0x22')](function(_0x18ea4b){if(_0x18ea4b['access_token']){_0x2e3263(_0x18ea4b[_0x5a53('0x59')]);}else{_0x88c701('Unable\x20to\x20retrieve\x20the\x20access\x20token');}})['catch'](function(_0xf281eb){_0x88c701(_0xf281eb);});});}exports[_0x5a53('0x5a')]=function(_0x3a83ae,_0x3ffb3c,_0x3cec34){var _0x3f0d13,_0x100ebd,_0x5bca7b,_0x33271a,_0xd6bae6;return db[_0x5a53('0x27')][_0x5a53('0x48')]({'where':{'id':_0x3a83ae[_0x5a53('0x43')]['id']},'attributes':['id','host',_0x5a53('0x51'),_0x5a53('0x58'),'clientSecret',_0x5a53('0x5b'),_0x5a53('0x5c'),'refreshToken']})[_0x5a53('0x22')](handleEntityNotFound(_0x3ffb3c,null))[_0x5a53('0x22')](function(_0x34ce9c){_0xd6bae6=_0x34ce9c;_0x3f0d13=_0xd6bae6[_0x5a53('0x5d')];_0x100ebd=_0x3f0d13==='zoho.eu'?'eu':_0x5a53('0x5e');_0x5bca7b=_0xd6bae6[_0x5a53('0x5b')];var _0x75f323=_0x5bca7b[_0x5a53('0x5f')](-0x1);if(_0x75f323==='/'||_0x75f323==='\x5c'||_0x75f323===':'){_0x5bca7b=_0x5bca7b[_0x5a53('0x60')](0x0,_0x5bca7b[_0x5a53('0x61')](_0x75f323));}if(!_0xd6bae6['refreshToken']){throw new Error(_0x5a53('0x62'));}return getAccessToken(_0xd6bae6);})[_0x5a53('0x22')](function(_0x52cd94){if(_0x52cd94){return rp({'method':_0x5a53('0x63'),'uri':util['format']('https://www.zohoapis.%s/crm/v2/settings/fields',_0x100ebd),'qs':{'module':_0x5a53('0x64')},'headers':{'Authorization':_0x5a53('0x65')+_0x52cd94},'json':!![]});}})[_0x5a53('0x22')](function(_0x1e3735){if(_0x1e3735){if(_0x1e3735[_0x5a53('0x66')]&&_0x1e3735[_0x5a53('0x66')][_0x5a53('0x23')]){throw new Error(_0x1e3735[_0x5a53('0x66')][_0x5a53('0x23')]['message']);}var _0x32fb6d=[];var _0x5d234f=[];var _0x6484f0=[_0x5a53('0x67'),'Subject','Description','WhoId',_0x5a53('0x68'),_0x5a53('0x69'),'Call_Start_Time',_0x5a53('0x6a')];_0x5d234f=_['remove'](_0x1e3735['fields'],function(_0x1763de){return _0x6484f0[_0x5a53('0x6b')](_0x1763de[_0x5a53('0x6c')]);});for(var _0x17ff8c=0x0;_0x17ff8c<_0x5d234f[_0x5a53('0x33')];_0x17ff8c++){if(_0x5d234f[_0x17ff8c][_0x5a53('0x6d')]===![]){_0x32fb6d[_0x5a53('0x6e')]({'id':_0x5d234f[_0x17ff8c]['id'],'name':_0x5d234f[_0x17ff8c][_0x5a53('0x6f')],'custom':_0x5d234f[_0x17ff8c][_0x5a53('0x70')],'options':_0x5d234f[_0x17ff8c]['data_type']==='picklist'&&_0x5d234f[_0x17ff8c][_0x5a53('0x71')][_0x5a53('0x33')]>-0x1?_[_0x5a53('0x2c')](_0x5d234f[_0x17ff8c]['pick_list_values'],function(_0x1a0d31){return{'name':_0x1a0d31,'value':_0x1a0d31};}):[]});}}return{'count':_0x32fb6d['length'],'rows':_0x32fb6d};}else{return{'count':0x0,'rows':[]};}})[_0x5a53('0x22')](respondWithResult(_0x3ffb3c,null))[_0x5a53('0x41')](function(_0x5dd621){var _0x458e3c=_0x3a83ae[_0x5a53('0x2d')][_0x5a53('0x72')]?0x1f4:_0x5dd621['statusCode']||0x1f4;logger[_0x5a53('0x23')]('getFields,\x20%s,\x20%s,\x20%s',_0x5a53('0x5a'),_0x458e3c,JSON['stringify'](_0x5dd621));delete _0x5dd621[_0x5a53('0x25')];if(_0x458e3c===0x191){_0x458e3c=0x190;}_0x3ffb3c['status'](_0x458e3c)[_0x5a53('0x26')](_0x3a83ae[_0x5a53('0x2d')][_0x5a53('0x72')]?{'message':_0x5a53('0x73'),'statusCode':_0x5dd621[_0x5a53('0x74')]}:_0x5dd621);});};