Built motion from commit 5b761a7b.|2.5.36
[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 _0x3de5=['filters','intersection','query','attributes','fields','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','includeAll','include','findAll','rows','catch','show','params','length','options','find','create','body','update','findOne','ZohoConfiguration','getConfigurations','addConfiguration','Subjects','getSubjects','getDescriptions','channel','ZohoField','Descriptions','https://accounts.zoho.com.au','https://accounts.zoho.eu','https://accounts.zoho.in','https://accounts.zoho.com.cn','POST','/oauth/v2/token','refreshToken','clientSecret','refresh_token','access_token','Unable\x20to\x20retrieve\x20the\x20access\x20token','host','zone','clientId','serverUrl','code','zoho.eu','com','slice','substring','lastIndexOf','format','https://www.zohoapis.%s/crm/v2/settings/fields','Calls','Zoho-oauthtoken\x20','Owner','Subject','Description','WhoId','Call_Duration','Call_Start_Time','remove','includes','api_name','system_mandatory','push','display_label','picklist','pick_list_values','test','statusCode','stringify','Wrong\x20credentials','rimraf','fast-json-patch','request-promise','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','sendStatus','status','end','json','undefined','limit','count','offset','Content-Range','apply','reject','save','then','destroy','error','stack','name','send','index','map','ZohoAccount','rawAttributes','type','model','keys'];(function(_0x3e29e5,_0x1cd087){var _0x37f88a=function(_0x2c6621){while(--_0x2c6621){_0x3e29e5['push'](_0x3e29e5['shift']());}};_0x37f88a(++_0x1cd087);}(_0x3de5,0x158));var _0x53de=function(_0x4e7162,_0x318933){_0x4e7162=_0x4e7162-0x0;var _0x26030f=_0x3de5[_0x4e7162];return _0x26030f;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x53de('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x53de('0x1'));var rp=require(_0x53de('0x2'));var moment=require('moment');var BPromise=require(_0x53de('0x3'));var Mustache=require('mustache');var util=require(_0x53de('0x4'));var path=require(_0x53de('0x5'));var sox=require(_0x53de('0x6'));var csv=require(_0x53de('0x7'));var ejs=require(_0x53de('0x8'));var fs=require('fs');var fs_extra=require(_0x53de('0x9'));var _=require(_0x53de('0xa'));var squel=require('squel');var crypto=require(_0x53de('0xb'));var jsforce=require(_0x53de('0xc'));var deskjs=require(_0x53de('0xd'));var toCsv=require(_0x53de('0x7'));var querystring=require(_0x53de('0xe'));var Papa=require(_0x53de('0xf'));var Redis=require(_0x53de('0x10'));var authService=require(_0x53de('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x53de('0x12'));var hardwareService=require(_0x53de('0x13'));var logger=require(_0x53de('0x14'))(_0x53de('0x15'));var utils=require(_0x53de('0x16'));var config=require(_0x53de('0x17'));var licenseUtil=require(_0x53de('0x18'));var db=require(_0x53de('0x19'))['db'];var integrations=require(_0x53de('0x1a'));function respondWithStatusCode(_0x387ee7,_0x5c80ae){_0x5c80ae=_0x5c80ae||0xcc;return function(_0x4c03a){if(_0x4c03a){return _0x387ee7[_0x53de('0x1b')](_0x5c80ae);}return _0x387ee7[_0x53de('0x1c')](_0x5c80ae)[_0x53de('0x1d')]();};}function respondWithResult(_0x4a8c5f,_0x382e51){_0x382e51=_0x382e51||0xc8;return function(_0xa31386){if(_0xa31386){return _0x4a8c5f[_0x53de('0x1c')](_0x382e51)[_0x53de('0x1e')](_0xa31386);}};}function respondWithFilteredResult(_0x51c983,_0x7cb43){return function(_0x4afc80){if(_0x4afc80){var _0x499933=typeof _0x7cb43['offset']===_0x53de('0x1f')&&typeof _0x7cb43[_0x53de('0x20')]===_0x53de('0x1f');var _0x55e035=_0x4afc80[_0x53de('0x21')];var _0x598a60=_0x499933?0x0:_0x7cb43[_0x53de('0x22')];var _0xaf91b=_0x499933?_0x4afc80[_0x53de('0x21')]:_0x7cb43[_0x53de('0x22')]+_0x7cb43[_0x53de('0x20')];var _0x394dd1;if(_0xaf91b>=_0x55e035){_0xaf91b=_0x55e035;_0x394dd1=0xc8;}else{_0x394dd1=0xce;}_0x51c983[_0x53de('0x1c')](_0x394dd1);return _0x51c983['set'](_0x53de('0x23'),_0x598a60+'-'+_0xaf91b+'/'+_0x55e035)[_0x53de('0x1e')](_0x4afc80);}return null;};}function patchUpdates(_0x5c9bdd){return function(_0x5992ef){try{jsonpatch[_0x53de('0x24')](_0x5992ef,_0x5c9bdd,!![]);}catch(_0xcdfb41){return BPromise[_0x53de('0x25')](_0xcdfb41);}return _0x5992ef[_0x53de('0x26')]();};}function saveUpdates(_0x28c204,_0x500a06){return function(_0x279a37){if(_0x279a37){return _0x279a37['update'](_0x28c204)[_0x53de('0x27')](function(_0x154ac4){return _0x154ac4;});}return null;};}function removeEntity(_0x2085e9,_0x31ac78){return function(_0x1afa08){if(_0x1afa08){return _0x1afa08[_0x53de('0x28')]()[_0x53de('0x27')](function(){_0x2085e9[_0x53de('0x1c')](0xcc)[_0x53de('0x1d')]();});}};}function handleEntityNotFound(_0x46b90f,_0x29f92a){return function(_0x417876){if(!_0x417876){_0x46b90f['sendStatus'](0x194);}return _0x417876;};}function handleError(_0x56526e,_0x5e00ce){_0x5e00ce=_0x5e00ce||0x1f4;return function(_0x99818a){logger[_0x53de('0x29')](_0x99818a[_0x53de('0x2a')]);if(_0x99818a['name']){delete _0x99818a[_0x53de('0x2b')];}_0x56526e[_0x53de('0x1c')](_0x5e00ce)[_0x53de('0x2c')](_0x99818a);};}exports[_0x53de('0x2d')]=function(_0x49cb96,_0x36ac33){var _0x58d037={},_0x2e8725={},_0xa82673={'count':0x0,'rows':[]};var _0x47c12c=_[_0x53de('0x2e')](db[_0x53de('0x2f')][_0x53de('0x30')],function(_0x1586d5){return{'name':_0x1586d5['fieldName'],'type':_0x1586d5[_0x53de('0x31')]['key']};});_0x2e8725[_0x53de('0x32')]=_[_0x53de('0x2e')](_0x47c12c,_0x53de('0x2b'));_0x2e8725['query']=_[_0x53de('0x33')](_0x49cb96['query']);_0x2e8725[_0x53de('0x34')]=_[_0x53de('0x35')](_0x2e8725['model'],_0x2e8725[_0x53de('0x36')]);_0x58d037[_0x53de('0x37')]=_[_0x53de('0x35')](_0x2e8725[_0x53de('0x32')],qs[_0x53de('0x38')](_0x49cb96[_0x53de('0x36')][_0x53de('0x38')]));_0x58d037[_0x53de('0x37')]=_0x58d037[_0x53de('0x37')]['length']?_0x58d037['attributes']:_0x2e8725[_0x53de('0x32')];if(!_0x49cb96[_0x53de('0x36')][_0x53de('0x39')](_0x53de('0x3a'))){_0x58d037['limit']=qs[_0x53de('0x20')](_0x49cb96['query'][_0x53de('0x20')]);_0x58d037[_0x53de('0x22')]=qs[_0x53de('0x22')](_0x49cb96['query'][_0x53de('0x22')]);}_0x58d037[_0x53de('0x3b')]=qs['sort'](_0x49cb96[_0x53de('0x36')][_0x53de('0x3c')]);_0x58d037['where']=qs['filters'](_[_0x53de('0x3d')](_0x49cb96[_0x53de('0x36')],_0x2e8725[_0x53de('0x34')]),_0x47c12c);if(_0x49cb96[_0x53de('0x36')][_0x53de('0x3e')]){_0x58d037[_0x53de('0x3f')]=_[_0x53de('0x40')](_0x58d037[_0x53de('0x3f')],{'$or':_['map'](_0x47c12c,function(_0x16b97e){if(_0x16b97e[_0x53de('0x31')]!==_0x53de('0x41')){var _0x747d3b={};_0x747d3b[_0x16b97e[_0x53de('0x2b')]]={'$like':'%'+_0x49cb96[_0x53de('0x36')][_0x53de('0x3e')]+'%'};return _0x747d3b;}})});}_0x58d037=_['merge']({},_0x58d037,_0x49cb96['options']);var _0x395396={'where':_0x58d037[_0x53de('0x3f')]};return db[_0x53de('0x2f')][_0x53de('0x21')](_0x395396)[_0x53de('0x27')](function(_0x4a7fa9){_0xa82673[_0x53de('0x21')]=_0x4a7fa9;if(_0x49cb96[_0x53de('0x36')][_0x53de('0x42')]){_0x58d037[_0x53de('0x43')]=[{'all':!![]}];}return db[_0x53de('0x2f')][_0x53de('0x44')](_0x58d037);})[_0x53de('0x27')](function(_0x10b876){_0xa82673[_0x53de('0x45')]=_0x10b876;return _0xa82673;})[_0x53de('0x27')](respondWithFilteredResult(_0x36ac33,_0x58d037))[_0x53de('0x46')](handleError(_0x36ac33,null));};exports[_0x53de('0x47')]=function(_0x24dc75,_0x383782){var _0x4edcb8={'raw':![],'where':{'id':_0x24dc75[_0x53de('0x48')]['id']}},_0xd4383c={};_0xd4383c[_0x53de('0x32')]=_[_0x53de('0x33')](db['ZohoAccount'][_0x53de('0x30')]);_0xd4383c[_0x53de('0x36')]=_['keys'](_0x24dc75[_0x53de('0x36')]);_0xd4383c[_0x53de('0x34')]=_[_0x53de('0x35')](_0xd4383c[_0x53de('0x32')],_0xd4383c['query']);_0x4edcb8[_0x53de('0x37')]=_[_0x53de('0x35')](_0xd4383c[_0x53de('0x32')],qs[_0x53de('0x38')](_0x24dc75[_0x53de('0x36')][_0x53de('0x38')]));_0x4edcb8[_0x53de('0x37')]=_0x4edcb8[_0x53de('0x37')][_0x53de('0x49')]?_0x4edcb8[_0x53de('0x37')]:_0xd4383c[_0x53de('0x32')];if(_0x24dc75[_0x53de('0x36')][_0x53de('0x42')]){_0x4edcb8['include']=[{'all':!![]}];}_0x4edcb8=_[_0x53de('0x40')]({},_0x4edcb8,_0x24dc75[_0x53de('0x4a')]);return db['ZohoAccount'][_0x53de('0x4b')](_0x4edcb8)['then'](handleEntityNotFound(_0x383782,null))['then'](respondWithResult(_0x383782,null))[_0x53de('0x46')](handleError(_0x383782,null));};exports[_0x53de('0x4c')]=function(_0x5d06fa,_0x3e42b0){return db['ZohoAccount'][_0x53de('0x4c')](_0x5d06fa[_0x53de('0x4d')],{})[_0x53de('0x27')](respondWithResult(_0x3e42b0,0xc9))['catch'](handleError(_0x3e42b0,null));};exports[_0x53de('0x4e')]=function(_0x4d57dd,_0xa68c17){if(_0x4d57dd[_0x53de('0x4d')]['id']){delete _0x4d57dd[_0x53de('0x4d')]['id'];}return db[_0x53de('0x2f')][_0x53de('0x4b')]({'where':{'id':_0x4d57dd[_0x53de('0x48')]['id']}})[_0x53de('0x27')](handleEntityNotFound(_0xa68c17,null))[_0x53de('0x27')](saveUpdates(_0x4d57dd['body'],null))[_0x53de('0x27')](respondWithResult(_0xa68c17,null))[_0x53de('0x46')](handleError(_0xa68c17,null));};exports[_0x53de('0x28')]=function(_0x22bba3,_0x2a48c1){return db['ZohoAccount'][_0x53de('0x4b')]({'where':{'id':_0x22bba3['params']['id']}})[_0x53de('0x27')](handleEntityNotFound(_0x2a48c1,null))[_0x53de('0x27')](removeEntity(_0x2a48c1,null))[_0x53de('0x46')](handleError(_0x2a48c1,null));};exports['getConfigurations']=function(_0x2f054b,_0x4e1f42,_0x45eb27){var _0x143442={};var _0x17300a={};var _0x498961;var _0x4ad4e0;return db[_0x53de('0x2f')][_0x53de('0x4f')]({'where':{'id':_0x2f054b[_0x53de('0x48')]['id']}})['then'](handleEntityNotFound(_0x4e1f42,null))[_0x53de('0x27')](function(_0x101d42){if(_0x101d42){_0x498961=_0x101d42;_0x17300a[_0x53de('0x32')]=_[_0x53de('0x33')](db[_0x53de('0x50')][_0x53de('0x30')]);_0x17300a[_0x53de('0x36')]=_[_0x53de('0x33')](_0x2f054b['query']);_0x17300a[_0x53de('0x34')]=_[_0x53de('0x35')](_0x17300a[_0x53de('0x32')],_0x17300a[_0x53de('0x36')]);_0x143442['attributes']=_[_0x53de('0x35')](_0x17300a[_0x53de('0x32')],qs[_0x53de('0x38')](_0x2f054b[_0x53de('0x36')]['fields']));_0x143442[_0x53de('0x37')]=_0x143442[_0x53de('0x37')][_0x53de('0x49')]?_0x143442[_0x53de('0x37')]:_0x17300a['model'];_0x143442[_0x53de('0x3b')]=qs[_0x53de('0x3c')](_0x2f054b[_0x53de('0x36')][_0x53de('0x3c')]);_0x143442[_0x53de('0x3f')]=qs[_0x53de('0x34')](_[_0x53de('0x3d')](_0x2f054b['query'],_0x17300a['filters']));if(_0x2f054b[_0x53de('0x36')][_0x53de('0x3e')]){_0x143442[_0x53de('0x3f')]=_['merge'](_0x143442[_0x53de('0x3f')],{'$or':_[_0x53de('0x2e')](_0x143442[_0x53de('0x37')],function(_0x3f374e){var _0x2c1712={};_0x2c1712[_0x3f374e]={'$like':'%'+_0x2f054b[_0x53de('0x36')][_0x53de('0x3e')]+'%'};return _0x2c1712;})});}_0x143442=_[_0x53de('0x40')]({},_0x143442,_0x2f054b['options']);return _0x498961[_0x53de('0x51')](_0x143442);}})['then'](function(_0x4564b8){if(_0x4564b8){_0x4ad4e0=_0x4564b8[_0x53de('0x49')];if(!_0x2f054b[_0x53de('0x36')][_0x53de('0x39')]('nolimit')){_0x143442[_0x53de('0x20')]=qs[_0x53de('0x20')](_0x2f054b[_0x53de('0x36')][_0x53de('0x20')]);_0x143442['offset']=qs[_0x53de('0x22')](_0x2f054b[_0x53de('0x36')][_0x53de('0x22')]);}return _0x498961['getConfigurations'](_0x143442);}})['then'](function(_0x5b3cd4){if(_0x5b3cd4){return _0x5b3cd4?{'count':_0x4ad4e0,'rows':_0x5b3cd4}:null;}})[_0x53de('0x27')](respondWithResult(_0x4e1f42,null))[_0x53de('0x46')](handleError(_0x4e1f42,null));};exports[_0x53de('0x52')]=function(_0x45b1ca,_0x4eefc1,_0x237c98){if(_0x45b1ca[_0x53de('0x4d')]['id']){delete _0x45b1ca[_0x53de('0x4d')]['id'];}return db[_0x53de('0x2f')][_0x53de('0x4f')]({'where':{'id':_0x45b1ca[_0x53de('0x48')]['id']}})[_0x53de('0x27')](handleEntityNotFound(_0x4eefc1,null))[_0x53de('0x27')](function(_0x26f81d){if(_0x26f81d){_0x45b1ca[_0x53de('0x4d')]['AccountId']=_0x26f81d['id'];_0x45b1ca[_0x53de('0x4d')][_0x53de('0x53')]=integrations[_0x53de('0x54')](_0x45b1ca['body']['channel'],_0x45b1ca[_0x53de('0x4d')][_0x53de('0x31')]);_0x45b1ca['body']['Descriptions']=integrations[_0x53de('0x55')](_0x45b1ca[_0x53de('0x4d')][_0x53de('0x56')],_0x45b1ca[_0x53de('0x4d')][_0x53de('0x31')]);return db['ZohoConfiguration'][_0x53de('0x4c')](_0x45b1ca['body'],{'include':[{'model':db[_0x53de('0x57')],'as':_0x53de('0x53')},{'model':db['ZohoField'],'as':_0x53de('0x58')}]});}return null;})['then'](respondWithResult(_0x4eefc1,null))['catch'](handleError(_0x4eefc1,null));};function getAccessToken(_0x1c24e9){return new Promise(function(_0x464909,_0x1e5fa1){var _0x30b779;switch(_0x1c24e9['zone']){case'US':_0x30b779='https://accounts.zoho.com';break;case'AU':_0x30b779=_0x53de('0x59');break;case'EU':_0x30b779=_0x53de('0x5a');break;case'IN':_0x30b779=_0x53de('0x5b');break;case'CN':_0x30b779=_0x53de('0x5c');break;default:_0x30b779=_0x53de('0x5a');break;}var _0x59871b={'method':_0x53de('0x5d'),'uri':_0x30b779+_0x53de('0x5e'),'qs':{'refresh_token':_0x1c24e9[_0x53de('0x5f')],'client_id':_0x1c24e9['clientId'],'client_secret':_0x1c24e9[_0x53de('0x60')],'grant_type':_0x53de('0x61')},'json':!![]};return rp(_0x59871b)['then'](function(_0x31a626){if(_0x31a626[_0x53de('0x62')]){_0x464909(_0x31a626[_0x53de('0x62')]);}else{_0x1e5fa1(_0x53de('0x63'));}})[_0x53de('0x46')](function(_0x530add){_0x1e5fa1(_0x530add);});});}exports['getFields']=function(_0x32f58d,_0x271f9d,_0x1f6026){var _0x5218ef,_0x2e3314,_0x37a977,_0x551424,_0x7d3861;return db[_0x53de('0x2f')][_0x53de('0x4f')]({'where':{'id':_0x32f58d[_0x53de('0x48')]['id']},'attributes':['id',_0x53de('0x64'),_0x53de('0x65'),_0x53de('0x66'),_0x53de('0x60'),_0x53de('0x67'),_0x53de('0x68'),'refreshToken']})[_0x53de('0x27')](handleEntityNotFound(_0x271f9d,null))['then'](function(_0x39fc49){_0x7d3861=_0x39fc49;_0x5218ef=_0x7d3861['host'];_0x2e3314=_0x5218ef===_0x53de('0x69')?'eu':_0x53de('0x6a');_0x37a977=_0x7d3861[_0x53de('0x67')];var _0x226527=_0x37a977[_0x53de('0x6b')](-0x1);if(_0x226527==='/'||_0x226527==='\x5c'||_0x226527===':'){_0x37a977=_0x37a977[_0x53de('0x6c')](0x0,_0x37a977[_0x53de('0x6d')](_0x226527));}if(!_0x7d3861[_0x53de('0x5f')]){throw new Error('Refresh\x20Token\x20not\x20available\x20for\x20the\x20account');}return getAccessToken(_0x7d3861);})[_0x53de('0x27')](function(_0x1b8a5b){if(_0x1b8a5b){return rp({'method':'GET','uri':util[_0x53de('0x6e')](_0x53de('0x6f'),_0x2e3314),'qs':{'module':_0x53de('0x70')},'headers':{'Authorization':_0x53de('0x71')+_0x1b8a5b},'json':!![]});}})[_0x53de('0x27')](function(_0x55ae15){if(_0x55ae15){if(_0x55ae15['response']&&_0x55ae15['response'][_0x53de('0x29')]){throw new Error(_0x55ae15['response']['error']['message']);}var _0x2f3be5=[];var _0x8f060c=[];var _0x3c95f1=[_0x53de('0x72'),_0x53de('0x73'),_0x53de('0x74'),_0x53de('0x75'),_0x53de('0x76'),'Call_Result',_0x53de('0x77'),'Call_Type'];_0x8f060c=_[_0x53de('0x78')](_0x55ae15[_0x53de('0x38')],function(_0x368bb7){return _0x3c95f1[_0x53de('0x79')](_0x368bb7[_0x53de('0x7a')]);});for(var _0x6b4518=0x0;_0x6b4518<_0x8f060c['length'];_0x6b4518++){if(_0x8f060c[_0x6b4518][_0x53de('0x7b')]===![]){_0x2f3be5[_0x53de('0x7c')]({'id':_0x8f060c[_0x6b4518]['id'],'name':_0x8f060c[_0x6b4518][_0x53de('0x7d')],'custom':_0x8f060c[_0x6b4518]['custom_field'],'options':_0x8f060c[_0x6b4518]['data_type']===_0x53de('0x7e')&&_0x8f060c[_0x6b4518][_0x53de('0x7f')][_0x53de('0x49')]>-0x1?_['map'](_0x8f060c[_0x6b4518][_0x53de('0x7f')],function(_0x172a8f){return{'name':_0x172a8f,'value':_0x172a8f};}):[]});}}return{'count':_0x2f3be5['length'],'rows':_0x2f3be5};}else{return{'count':0x0,'rows':[]};}})[_0x53de('0x27')](respondWithResult(_0x271f9d,null))['catch'](function(_0x2026f1){var _0x266d9e=_0x32f58d[_0x53de('0x36')][_0x53de('0x80')]?0x1f4:_0x2026f1[_0x53de('0x81')]||0x1f4;logger['error']('getFields,\x20%s,\x20%s,\x20%s','getFields',_0x266d9e,JSON[_0x53de('0x82')](_0x2026f1));delete _0x2026f1[_0x53de('0x2b')];if(_0x266d9e===0x191){_0x266d9e=0x190;}_0x271f9d[_0x53de('0x1c')](_0x266d9e)[_0x53de('0x2c')](_0x32f58d[_0x53de('0x36')][_0x53de('0x80')]?{'message':_0x53de('0x83'),'statusCode':_0x2026f1['statusCode']}:_0x2026f1);});};