641b47c69c999077934b310cdb41c9aeee2bac64
[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 _0x87d4=['includes','api_name','system_mandatory','display_label','picklist','pick_list_values','test','statusCode','getFields,\x20%s,\x20%s,\x20%s','stringify','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','sendStatus','end','status','json','limit','undefined','count','offset','set','Content-Range','apply','reject','save','update','then','destroy','error','name','send','index','map','ZohoAccount','fieldName','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','type','options','includeAll','include','findAll','rows','catch','show','params','rawAttributes','create','body','find','getConfigurations','ZohoConfiguration','nolimit','addConfiguration','findOne','AccountId','Subjects','getSubjects','channel','Descriptions','ZohoField','https://accounts.zoho.com','https://accounts.zoho.com.au','https://accounts.zoho.eu','https://accounts.zoho.in','https://accounts.zoho.com.cn','POST','refreshToken','clientSecret','refresh_token','access_token','Unable\x20to\x20retrieve\x20the\x20access\x20token','getFields','serverUrl','code','host','zoho.eu','com','slice','lastIndexOf','Refresh\x20Token\x20not\x20available\x20for\x20the\x20account','GET','https://www.zohoapis.%s/crm/v2/settings/fields','response','message','Owner','Description','WhoId','Call_Result','Call_Start_Time','Call_Type'];(function(_0x1f046a,_0x155189){var _0x2dd9b4=function(_0x3b6c86){while(--_0x3b6c86){_0x1f046a['push'](_0x1f046a['shift']());}};_0x2dd9b4(++_0x155189);}(_0x87d4,0x10c));var _0x487d=function(_0x1bc227,_0x29eb71){_0x1bc227=_0x1bc227-0x0;var _0xfd3e59=_0x87d4[_0x1bc227];return _0xfd3e59;};'use strict';var emlformat=require(_0x487d('0x0'));var rimraf=require(_0x487d('0x1'));var zipdir=require(_0x487d('0x2'));var jsonpatch=require(_0x487d('0x3'));var rp=require('request-promise');var moment=require(_0x487d('0x4'));var BPromise=require(_0x487d('0x5'));var Mustache=require(_0x487d('0x6'));var util=require(_0x487d('0x7'));var path=require(_0x487d('0x8'));var sox=require(_0x487d('0x9'));var csv=require(_0x487d('0xa'));var ejs=require(_0x487d('0xb'));var fs=require('fs');var fs_extra=require(_0x487d('0xc'));var _=require(_0x487d('0xd'));var squel=require(_0x487d('0xe'));var crypto=require(_0x487d('0xf'));var jsforce=require(_0x487d('0x10'));var deskjs=require('desk.js');var toCsv=require(_0x487d('0xa'));var querystring=require(_0x487d('0x11'));var Papa=require(_0x487d('0x12'));var Redis=require('ioredis');var authService=require(_0x487d('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0x487d('0x14'));var hardwareService=require(_0x487d('0x15'));var logger=require(_0x487d('0x16'))(_0x487d('0x17'));var utils=require('../../config/utils');var config=require(_0x487d('0x18'));var licenseUtil=require(_0x487d('0x19'));var db=require('../../mysqldb')['db'];var integrations=require('../../components/integrations/configuration');function respondWithStatusCode(_0x419605,_0x47e1c9){_0x47e1c9=_0x47e1c9||0xcc;return function(_0x372c55){if(_0x372c55){return _0x419605[_0x487d('0x1a')](_0x47e1c9);}return _0x419605['status'](_0x47e1c9)[_0x487d('0x1b')]();};}function respondWithResult(_0x302fa1,_0x9374f3){_0x9374f3=_0x9374f3||0xc8;return function(_0x2e4d8b){if(_0x2e4d8b){return _0x302fa1[_0x487d('0x1c')](_0x9374f3)[_0x487d('0x1d')](_0x2e4d8b);}};}function respondWithFilteredResult(_0x3b34d3,_0x4588b4){return function(_0x129929){if(_0x129929){var _0x119aa3=typeof _0x4588b4['offset']==='undefined'&&typeof _0x4588b4[_0x487d('0x1e')]===_0x487d('0x1f');var _0x4c6b47=_0x129929[_0x487d('0x20')];var _0x4d0f7f=_0x119aa3?0x0:_0x4588b4[_0x487d('0x21')];var _0x98720e=_0x119aa3?_0x129929[_0x487d('0x20')]:_0x4588b4['offset']+_0x4588b4[_0x487d('0x1e')];var _0x807a33;if(_0x98720e>=_0x4c6b47){_0x98720e=_0x4c6b47;_0x807a33=0xc8;}else{_0x807a33=0xce;}_0x3b34d3[_0x487d('0x1c')](_0x807a33);return _0x3b34d3[_0x487d('0x22')](_0x487d('0x23'),_0x4d0f7f+'-'+_0x98720e+'/'+_0x4c6b47)[_0x487d('0x1d')](_0x129929);}return null;};}function patchUpdates(_0x12f6b3){return function(_0x5e7101){try{jsonpatch[_0x487d('0x24')](_0x5e7101,_0x12f6b3,!![]);}catch(_0x1b81f6){return BPromise[_0x487d('0x25')](_0x1b81f6);}return _0x5e7101[_0x487d('0x26')]();};}function saveUpdates(_0x47d2ec,_0x2069af){return function(_0x4c21d9){if(_0x4c21d9){return _0x4c21d9[_0x487d('0x27')](_0x47d2ec)[_0x487d('0x28')](function(_0x276416){return _0x276416;});}return null;};}function removeEntity(_0x4468c8,_0x15283c){return function(_0x5e3423){if(_0x5e3423){return _0x5e3423[_0x487d('0x29')]()[_0x487d('0x28')](function(){_0x4468c8['status'](0xcc)[_0x487d('0x1b')]();});}};}function handleEntityNotFound(_0x505914,_0x81484){return function(_0x218c15){if(!_0x218c15){_0x505914['sendStatus'](0x194);}return _0x218c15;};}function handleError(_0x5a2777,_0x1ff520){_0x1ff520=_0x1ff520||0x1f4;return function(_0x5e86a2){logger[_0x487d('0x2a')](_0x5e86a2['stack']);if(_0x5e86a2[_0x487d('0x2b')]){delete _0x5e86a2[_0x487d('0x2b')];}_0x5a2777[_0x487d('0x1c')](_0x1ff520)[_0x487d('0x2c')](_0x5e86a2);};}exports[_0x487d('0x2d')]=function(_0x4138a3,_0x4299ab){var _0x315dec={},_0x33bb1b={},_0x47cb1e={'count':0x0,'rows':[]};var _0x19945f=_[_0x487d('0x2e')](db[_0x487d('0x2f')]['rawAttributes'],function(_0x16a40a){return{'name':_0x16a40a[_0x487d('0x30')],'type':_0x16a40a['type'][_0x487d('0x31')]};});_0x33bb1b[_0x487d('0x32')]=_[_0x487d('0x2e')](_0x19945f,_0x487d('0x2b'));_0x33bb1b[_0x487d('0x33')]=_[_0x487d('0x34')](_0x4138a3['query']);_0x33bb1b[_0x487d('0x35')]=_[_0x487d('0x36')](_0x33bb1b[_0x487d('0x32')],_0x33bb1b[_0x487d('0x33')]);_0x315dec[_0x487d('0x37')]=_[_0x487d('0x36')](_0x33bb1b['model'],qs[_0x487d('0x38')](_0x4138a3[_0x487d('0x33')][_0x487d('0x38')]));_0x315dec[_0x487d('0x37')]=_0x315dec[_0x487d('0x37')][_0x487d('0x39')]?_0x315dec['attributes']:_0x33bb1b[_0x487d('0x32')];if(!_0x4138a3[_0x487d('0x33')][_0x487d('0x3a')]('nolimit')){_0x315dec[_0x487d('0x1e')]=qs[_0x487d('0x1e')](_0x4138a3['query'][_0x487d('0x1e')]);_0x315dec[_0x487d('0x21')]=qs[_0x487d('0x21')](_0x4138a3[_0x487d('0x33')][_0x487d('0x21')]);}_0x315dec[_0x487d('0x3b')]=qs['sort'](_0x4138a3[_0x487d('0x33')][_0x487d('0x3c')]);_0x315dec[_0x487d('0x3d')]=qs[_0x487d('0x35')](_[_0x487d('0x3e')](_0x4138a3[_0x487d('0x33')],_0x33bb1b['filters']),_0x19945f);if(_0x4138a3['query'][_0x487d('0x3f')]){_0x315dec[_0x487d('0x3d')]=_[_0x487d('0x40')](_0x315dec[_0x487d('0x3d')],{'$or':_[_0x487d('0x2e')](_0x19945f,function(_0x2602e6){if(_0x2602e6[_0x487d('0x41')]!=='VIRTUAL'){var _0x1541de={};_0x1541de[_0x2602e6[_0x487d('0x2b')]]={'$like':'%'+_0x4138a3[_0x487d('0x33')][_0x487d('0x3f')]+'%'};return _0x1541de;}})});}_0x315dec=_[_0x487d('0x40')]({},_0x315dec,_0x4138a3[_0x487d('0x42')]);var _0x1a598e={'where':_0x315dec[_0x487d('0x3d')]};return db[_0x487d('0x2f')][_0x487d('0x20')](_0x1a598e)[_0x487d('0x28')](function(_0x146a52){_0x47cb1e[_0x487d('0x20')]=_0x146a52;if(_0x4138a3[_0x487d('0x33')][_0x487d('0x43')]){_0x315dec[_0x487d('0x44')]=[{'all':!![]}];}return db[_0x487d('0x2f')][_0x487d('0x45')](_0x315dec);})[_0x487d('0x28')](function(_0x44e9c7){_0x47cb1e[_0x487d('0x46')]=_0x44e9c7;return _0x47cb1e;})[_0x487d('0x28')](respondWithFilteredResult(_0x4299ab,_0x315dec))[_0x487d('0x47')](handleError(_0x4299ab,null));};exports[_0x487d('0x48')]=function(_0x30872d,_0x2812a3){var _0x1323b1={'raw':![],'where':{'id':_0x30872d[_0x487d('0x49')]['id']}},_0x45e3e0={};_0x45e3e0[_0x487d('0x32')]=_['keys'](db['ZohoAccount'][_0x487d('0x4a')]);_0x45e3e0['query']=_[_0x487d('0x34')](_0x30872d['query']);_0x45e3e0[_0x487d('0x35')]=_[_0x487d('0x36')](_0x45e3e0['model'],_0x45e3e0[_0x487d('0x33')]);_0x1323b1[_0x487d('0x37')]=_['intersection'](_0x45e3e0['model'],qs[_0x487d('0x38')](_0x30872d[_0x487d('0x33')][_0x487d('0x38')]));_0x1323b1[_0x487d('0x37')]=_0x1323b1[_0x487d('0x37')][_0x487d('0x39')]?_0x1323b1['attributes']:_0x45e3e0['model'];if(_0x30872d[_0x487d('0x33')][_0x487d('0x43')]){_0x1323b1[_0x487d('0x44')]=[{'all':!![]}];}_0x1323b1=_[_0x487d('0x40')]({},_0x1323b1,_0x30872d[_0x487d('0x42')]);return db['ZohoAccount']['find'](_0x1323b1)[_0x487d('0x28')](handleEntityNotFound(_0x2812a3,null))[_0x487d('0x28')](respondWithResult(_0x2812a3,null))[_0x487d('0x47')](handleError(_0x2812a3,null));};exports['create']=function(_0x553334,_0x203d4a){return db[_0x487d('0x2f')][_0x487d('0x4b')](_0x553334[_0x487d('0x4c')],{})[_0x487d('0x28')](respondWithResult(_0x203d4a,0xc9))['catch'](handleError(_0x203d4a,null));};exports[_0x487d('0x27')]=function(_0x56683c,_0x126a40){if(_0x56683c[_0x487d('0x4c')]['id']){delete _0x56683c[_0x487d('0x4c')]['id'];}return db[_0x487d('0x2f')][_0x487d('0x4d')]({'where':{'id':_0x56683c[_0x487d('0x49')]['id']}})[_0x487d('0x28')](handleEntityNotFound(_0x126a40,null))[_0x487d('0x28')](saveUpdates(_0x56683c[_0x487d('0x4c')],null))[_0x487d('0x28')](respondWithResult(_0x126a40,null))['catch'](handleError(_0x126a40,null));};exports['destroy']=function(_0x121b35,_0x1c4bd6){return db['ZohoAccount'][_0x487d('0x4d')]({'where':{'id':_0x121b35[_0x487d('0x49')]['id']}})[_0x487d('0x28')](handleEntityNotFound(_0x1c4bd6,null))[_0x487d('0x28')](removeEntity(_0x1c4bd6,null))[_0x487d('0x47')](handleError(_0x1c4bd6,null));};exports[_0x487d('0x4e')]=function(_0xcbdfe1,_0x235a65,_0x11a9ad){var _0x26eb6d={};var _0x8b630c={};var _0x5c1192;var _0x1b72af;return db[_0x487d('0x2f')]['findOne']({'where':{'id':_0xcbdfe1['params']['id']}})[_0x487d('0x28')](handleEntityNotFound(_0x235a65,null))[_0x487d('0x28')](function(_0xc6a1cf){if(_0xc6a1cf){_0x5c1192=_0xc6a1cf;_0x8b630c['model']=_[_0x487d('0x34')](db[_0x487d('0x4f')]['rawAttributes']);_0x8b630c[_0x487d('0x33')]=_[_0x487d('0x34')](_0xcbdfe1[_0x487d('0x33')]);_0x8b630c[_0x487d('0x35')]=_[_0x487d('0x36')](_0x8b630c[_0x487d('0x32')],_0x8b630c[_0x487d('0x33')]);_0x26eb6d[_0x487d('0x37')]=_[_0x487d('0x36')](_0x8b630c[_0x487d('0x32')],qs['fields'](_0xcbdfe1[_0x487d('0x33')][_0x487d('0x38')]));_0x26eb6d[_0x487d('0x37')]=_0x26eb6d[_0x487d('0x37')][_0x487d('0x39')]?_0x26eb6d[_0x487d('0x37')]:_0x8b630c[_0x487d('0x32')];_0x26eb6d[_0x487d('0x3b')]=qs['sort'](_0xcbdfe1[_0x487d('0x33')][_0x487d('0x3c')]);_0x26eb6d[_0x487d('0x3d')]=qs[_0x487d('0x35')](_[_0x487d('0x3e')](_0xcbdfe1['query'],_0x8b630c[_0x487d('0x35')]));if(_0xcbdfe1[_0x487d('0x33')][_0x487d('0x3f')]){_0x26eb6d[_0x487d('0x3d')]=_[_0x487d('0x40')](_0x26eb6d[_0x487d('0x3d')],{'$or':_[_0x487d('0x2e')](_0x26eb6d[_0x487d('0x37')],function(_0x1a354c){var _0x22d93d={};_0x22d93d[_0x1a354c]={'$like':'%'+_0xcbdfe1[_0x487d('0x33')][_0x487d('0x3f')]+'%'};return _0x22d93d;})});}_0x26eb6d=_[_0x487d('0x40')]({},_0x26eb6d,_0xcbdfe1[_0x487d('0x42')]);return _0x5c1192[_0x487d('0x4e')](_0x26eb6d);}})[_0x487d('0x28')](function(_0x1b468a){if(_0x1b468a){_0x1b72af=_0x1b468a[_0x487d('0x39')];if(!_0xcbdfe1[_0x487d('0x33')][_0x487d('0x3a')](_0x487d('0x50'))){_0x26eb6d[_0x487d('0x1e')]=qs['limit'](_0xcbdfe1['query'][_0x487d('0x1e')]);_0x26eb6d['offset']=qs[_0x487d('0x21')](_0xcbdfe1[_0x487d('0x33')][_0x487d('0x21')]);}return _0x5c1192[_0x487d('0x4e')](_0x26eb6d);}})[_0x487d('0x28')](function(_0x1edb2d){if(_0x1edb2d){return _0x1edb2d?{'count':_0x1b72af,'rows':_0x1edb2d}:null;}})[_0x487d('0x28')](respondWithResult(_0x235a65,null))[_0x487d('0x47')](handleError(_0x235a65,null));};exports[_0x487d('0x51')]=function(_0x33bb26,_0x31d976,_0x4429f6){if(_0x33bb26[_0x487d('0x4c')]['id']){delete _0x33bb26[_0x487d('0x4c')]['id'];}return db[_0x487d('0x2f')][_0x487d('0x52')]({'where':{'id':_0x33bb26[_0x487d('0x49')]['id']}})[_0x487d('0x28')](handleEntityNotFound(_0x31d976,null))[_0x487d('0x28')](function(_0x7b118e){if(_0x7b118e){_0x33bb26['body'][_0x487d('0x53')]=_0x7b118e['id'];_0x33bb26['body'][_0x487d('0x54')]=integrations[_0x487d('0x55')](_0x33bb26[_0x487d('0x4c')][_0x487d('0x56')],_0x33bb26[_0x487d('0x4c')][_0x487d('0x41')]);_0x33bb26['body'][_0x487d('0x57')]=integrations['getDescriptions'](_0x33bb26[_0x487d('0x4c')][_0x487d('0x56')],_0x33bb26[_0x487d('0x4c')][_0x487d('0x41')]);return db['ZohoConfiguration']['create'](_0x33bb26['body'],{'include':[{'model':db[_0x487d('0x58')],'as':_0x487d('0x54')},{'model':db[_0x487d('0x58')],'as':_0x487d('0x57')}]});}return null;})['then'](respondWithResult(_0x31d976,null))['catch'](handleError(_0x31d976,null));};function getAccessToken(_0x316504){return new Promise(function(_0x580747,_0x3f8141){var _0x2151ad;switch(_0x316504['zone']){case'US':_0x2151ad=_0x487d('0x59');break;case'AU':_0x2151ad=_0x487d('0x5a');break;case'EU':_0x2151ad=_0x487d('0x5b');break;case'IN':_0x2151ad=_0x487d('0x5c');break;case'CN':_0x2151ad=_0x487d('0x5d');break;default:_0x2151ad='https://accounts.zoho.eu';break;}var _0x4b8839={'method':_0x487d('0x5e'),'uri':_0x2151ad+'/oauth/v2/token','qs':{'refresh_token':_0x316504[_0x487d('0x5f')],'client_id':_0x316504['clientId'],'client_secret':_0x316504[_0x487d('0x60')],'grant_type':_0x487d('0x61')},'json':!![]};return rp(_0x4b8839)[_0x487d('0x28')](function(_0x273cc5){if(_0x273cc5[_0x487d('0x62')]){_0x580747(_0x273cc5['access_token']);}else{_0x3f8141(_0x487d('0x63'));}})['catch'](function(_0x2c05ac){_0x3f8141(_0x2c05ac);});});}exports[_0x487d('0x64')]=function(_0x145785,_0x46c235,_0x11af63){var _0x132128,_0x2d10eb,_0x318c68,_0x5e32b2,_0x2f46e6;return db[_0x487d('0x2f')][_0x487d('0x52')]({'where':{'id':_0x145785[_0x487d('0x49')]['id']},'attributes':['id','host','zone','clientId',_0x487d('0x60'),_0x487d('0x65'),_0x487d('0x66'),'refreshToken']})[_0x487d('0x28')](handleEntityNotFound(_0x46c235,null))[_0x487d('0x28')](function(_0x435e56){_0x2f46e6=_0x435e56;_0x132128=_0x2f46e6[_0x487d('0x67')];_0x2d10eb=_0x132128===_0x487d('0x68')?'eu':_0x487d('0x69');_0x318c68=_0x2f46e6[_0x487d('0x65')];var _0x5c4651=_0x318c68[_0x487d('0x6a')](-0x1);if(_0x5c4651==='/'||_0x5c4651==='\x5c'||_0x5c4651===':'){_0x318c68=_0x318c68['substring'](0x0,_0x318c68[_0x487d('0x6b')](_0x5c4651));}if(!_0x2f46e6[_0x487d('0x5f')]){throw new Error(_0x487d('0x6c'));}return getAccessToken(_0x2f46e6);})['then'](function(_0x255890){if(_0x255890){return rp({'method':_0x487d('0x6d'),'uri':util['format'](_0x487d('0x6e'),_0x2d10eb),'qs':{'module':'Calls'},'headers':{'Authorization':'Zoho-oauthtoken\x20'+_0x255890},'json':!![]});}})[_0x487d('0x28')](function(_0x42932c){if(_0x42932c){if(_0x42932c[_0x487d('0x6f')]&&_0x42932c[_0x487d('0x6f')]['error']){throw new Error(_0x42932c[_0x487d('0x6f')]['error'][_0x487d('0x70')]);}var _0x55aeca=[];var _0x53a30a=[];var _0xc11fee=[_0x487d('0x71'),'Subject',_0x487d('0x72'),_0x487d('0x73'),'Call_Duration',_0x487d('0x74'),_0x487d('0x75'),_0x487d('0x76')];_0x53a30a=_['remove'](_0x42932c[_0x487d('0x38')],function(_0x415f03){return _0xc11fee[_0x487d('0x77')](_0x415f03[_0x487d('0x78')]);});for(var _0x55bb63=0x0;_0x55bb63<_0x53a30a[_0x487d('0x39')];_0x55bb63++){if(_0x53a30a[_0x55bb63][_0x487d('0x79')]===![]){_0x55aeca['push']({'id':_0x53a30a[_0x55bb63]['id'],'name':_0x53a30a[_0x55bb63][_0x487d('0x7a')],'custom':_0x53a30a[_0x55bb63]['custom_field'],'options':_0x53a30a[_0x55bb63]['data_type']===_0x487d('0x7b')&&_0x53a30a[_0x55bb63][_0x487d('0x7c')][_0x487d('0x39')]>-0x1?_[_0x487d('0x2e')](_0x53a30a[_0x55bb63][_0x487d('0x7c')],function(_0xa3644f){return{'name':_0xa3644f,'value':_0xa3644f};}):[]});}}return{'count':_0x55aeca[_0x487d('0x39')],'rows':_0x55aeca};}else{return{'count':0x0,'rows':[]};}})['then'](respondWithResult(_0x46c235,null))[_0x487d('0x47')](function(_0x428ff4){var _0x56f6bc=_0x145785['query'][_0x487d('0x7d')]?0x1f4:_0x428ff4[_0x487d('0x7e')]||0x1f4;logger[_0x487d('0x2a')](_0x487d('0x7f'),_0x487d('0x64'),_0x56f6bc,JSON[_0x487d('0x80')](_0x428ff4));delete _0x428ff4['name'];if(_0x56f6bc===0x191){_0x56f6bc=0x190;}_0x46c235[_0x487d('0x1c')](_0x56f6bc)[_0x487d('0x2c')](_0x145785['query']['test']?{'message':'Wrong\x20credentials','statusCode':_0x428ff4['statusCode']}:_0x428ff4);});};