[motion2.git] / server / api / intZohoAccount / intZohoAccount.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x34bb=['path','sox','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','status','end','json','undefined','limit','offset','count','Content-Range','apply','reject','update','destroy','then','sendStatus','error','name','send','index','ZohoAccount','rawAttributes','fieldName','type','model','map','query','intersection','attributes','fields','nolimit','order','sort','where','filters','VIRTUAL','filter','merge','options','includeAll','include','findAll','rows','catch','show','params','keys','length','find','body','getConfigurations','findOne','ZohoConfiguration','pick','hasOwnProperty','addConfiguration','Subjects','getDescriptions','channel','create','ZohoField','Descriptions','zone','https://accounts.zoho.com','https://accounts.zoho.com.au','https://accounts.zoho.eu','https://accounts.zoho.in','https://accounts.zoho.com.cn','POST','refreshToken','clientId','clientSecret','access_token','getFields','host','serverUrl','code','substring','Refresh\x20Token\x20not\x20available\x20for\x20the\x20account','GET','format','https://www.zohoapis.%s/crm/v2/settings/fields','Zoho-oauthtoken\x20','response','message','Owner','Description','WhoId','Call_Result','Call_Start_Time','remove','includes','api_name','system_mandatory','push','custom_field','picklist','pick_list_values','test','statusCode','getFields,\x20%s,\x20%s,\x20%s','stringify','Wrong\x20credentials','rimraf','zip-dir'];(function(_0x2c3e8c,_0x25ac9f){var _0x477c20=function(_0x39e2e6){while(--_0x39e2e6){_0x2c3e8c['push'](_0x2c3e8c['shift']());}};_0x477c20(++_0x25ac9f);}(_0x34bb,0x16c));var _0xb34b=function(_0x896037,_0xffe269){_0x896037=_0x896037-0x0;var _0x1cc0ba=_0x34bb[_0x896037];return _0x1cc0ba;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xb34b('0x0'));var zipdir=require(_0xb34b('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0xb34b('0x2'));var sox=require(_0xb34b('0x3'));var csv=require(_0xb34b('0x4'));var ejs=require(_0xb34b('0x5'));var fs=require('fs');var fs_extra=require(_0xb34b('0x6'));var _=require(_0xb34b('0x7'));var squel=require('squel');var crypto=require(_0xb34b('0x8'));var jsforce=require(_0xb34b('0x9'));var deskjs=require(_0xb34b('0xa'));var toCsv=require(_0xb34b('0x4'));var querystring=require(_0xb34b('0xb'));var Papa=require('papaparse');var Redis=require(_0xb34b('0xc'));var authService=require(_0xb34b('0xd'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xb34b('0xe'));var logger=require('../../config/logger')(_0xb34b('0xf'));var utils=require(_0xb34b('0x10'));var config=require(_0xb34b('0x11'));var licenseUtil=require(_0xb34b('0x12'));var db=require(_0xb34b('0x13'))['db'];var integrations=require(_0xb34b('0x14'));function respondWithStatusCode(_0x3a66f4,_0x2538fa){_0x2538fa=_0x2538fa||0xcc;return function(_0x2aaccc){if(_0x2aaccc){return _0x3a66f4['sendStatus'](_0x2538fa);}return _0x3a66f4[_0xb34b('0x15')](_0x2538fa)[_0xb34b('0x16')]();};}function respondWithResult(_0xdb70c4,_0x56bb49){_0x56bb49=_0x56bb49||0xc8;return function(_0x4554a5){if(_0x4554a5){return _0xdb70c4[_0xb34b('0x15')](_0x56bb49)[_0xb34b('0x17')](_0x4554a5);}};}function respondWithFilteredResult(_0x38aaa5,_0x1864c2){return function(_0xcb0a05){if(_0xcb0a05){var _0x25eea1=typeof _0x1864c2['offset']===_0xb34b('0x18')&&typeof _0x1864c2[_0xb34b('0x19')]===_0xb34b('0x18');var _0x5d823f=_0xcb0a05['count'];var _0x5176a7=_0x25eea1?0x0:_0x1864c2[_0xb34b('0x1a')];var _0x510536=_0x25eea1?_0xcb0a05[_0xb34b('0x1b')]:_0x1864c2[_0xb34b('0x1a')]+_0x1864c2['limit'];var _0x304120;if(_0x510536>=_0x5d823f){_0x510536=_0x5d823f;_0x304120=0xc8;}else{_0x304120=0xce;}_0x38aaa5[_0xb34b('0x15')](_0x304120);return _0x38aaa5['set'](_0xb34b('0x1c'),_0x5176a7+'-'+_0x510536+'/'+_0x5d823f)[_0xb34b('0x17')](_0xcb0a05);}return null;};}function patchUpdates(_0x3d5ca7){return function(_0x60582f){try{jsonpatch[_0xb34b('0x1d')](_0x60582f,_0x3d5ca7,!![]);}catch(_0x44518f){return BPromise[_0xb34b('0x1e')](_0x44518f);}return _0x60582f['save']();};}function saveUpdates(_0x298b97,_0x110d0f){return function(_0x51e1a4){if(_0x51e1a4){return _0x51e1a4[_0xb34b('0x1f')](_0x298b97)['then'](function(_0x20ece9){return _0x20ece9;});}return null;};}function removeEntity(_0x4b973d,_0x4511e7){return function(_0x49509b){if(_0x49509b){return _0x49509b[_0xb34b('0x20')]()[_0xb34b('0x21')](function(){_0x4b973d['status'](0xcc)[_0xb34b('0x16')]();});}};}function handleEntityNotFound(_0x1658be,_0x265e91){return function(_0x2e2689){if(!_0x2e2689){_0x1658be[_0xb34b('0x22')](0x194);}return _0x2e2689;};}function handleError(_0x294c3c,_0x4519f3){_0x4519f3=_0x4519f3||0x1f4;return function(_0x1f0ccb){logger[_0xb34b('0x23')](_0x1f0ccb['stack']);if(_0x1f0ccb[_0xb34b('0x24')]){delete _0x1f0ccb[_0xb34b('0x24')];}_0x294c3c[_0xb34b('0x15')](_0x4519f3)[_0xb34b('0x25')](_0x1f0ccb);};}exports[_0xb34b('0x26')]=function(_0xc4c80e,_0xa5b57){var _0x168d12={},_0x420ad1={},_0x5d2183={'count':0x0,'rows':[]};var _0x45cd1c=_['map'](db[_0xb34b('0x27')][_0xb34b('0x28')],function(_0x5f4337){return{'name':_0x5f4337[_0xb34b('0x29')],'type':_0x5f4337[_0xb34b('0x2a')]['key']};});_0x420ad1[_0xb34b('0x2b')]=_[_0xb34b('0x2c')](_0x45cd1c,'name');_0x420ad1[_0xb34b('0x2d')]=_['keys'](_0xc4c80e[_0xb34b('0x2d')]);_0x420ad1['filters']=_[_0xb34b('0x2e')](_0x420ad1[_0xb34b('0x2b')],_0x420ad1['query']);_0x168d12[_0xb34b('0x2f')]=_[_0xb34b('0x2e')](_0x420ad1['model'],qs[_0xb34b('0x30')](_0xc4c80e['query'][_0xb34b('0x30')]));_0x168d12[_0xb34b('0x2f')]=_0x168d12['attributes']['length']?_0x168d12[_0xb34b('0x2f')]:_0x420ad1[_0xb34b('0x2b')];if(!_0xc4c80e[_0xb34b('0x2d')]['hasOwnProperty'](_0xb34b('0x31'))){_0x168d12[_0xb34b('0x19')]=qs['limit'](_0xc4c80e[_0xb34b('0x2d')][_0xb34b('0x19')]);_0x168d12[_0xb34b('0x1a')]=qs[_0xb34b('0x1a')](_0xc4c80e[_0xb34b('0x2d')][_0xb34b('0x1a')]);}_0x168d12[_0xb34b('0x32')]=qs[_0xb34b('0x33')](_0xc4c80e[_0xb34b('0x2d')]['sort']);_0x168d12[_0xb34b('0x34')]=qs['filters'](_['pick'](_0xc4c80e[_0xb34b('0x2d')],_0x420ad1[_0xb34b('0x35')]),_0x45cd1c);if(_0xc4c80e['query']['filter']){_0x168d12['where']=_['merge'](_0x168d12[_0xb34b('0x34')],{'$or':_[_0xb34b('0x2c')](_0x45cd1c,function(_0x55572c){if(_0x55572c[_0xb34b('0x2a')]!==_0xb34b('0x36')){var _0x20293b={};_0x20293b[_0x55572c['name']]={'$like':'%'+_0xc4c80e['query'][_0xb34b('0x37')]+'%'};return _0x20293b;}})});}_0x168d12=_[_0xb34b('0x38')]({},_0x168d12,_0xc4c80e[_0xb34b('0x39')]);var _0x37ad81={'where':_0x168d12['where']};return db[_0xb34b('0x27')][_0xb34b('0x1b')](_0x37ad81)[_0xb34b('0x21')](function(_0x4fd320){_0x5d2183['count']=_0x4fd320;if(_0xc4c80e[_0xb34b('0x2d')][_0xb34b('0x3a')]){_0x168d12[_0xb34b('0x3b')]=[{'all':!![]}];}return db['ZohoAccount'][_0xb34b('0x3c')](_0x168d12);})[_0xb34b('0x21')](function(_0x17ec2b){_0x5d2183[_0xb34b('0x3d')]=_0x17ec2b;return _0x5d2183;})[_0xb34b('0x21')](respondWithFilteredResult(_0xa5b57,_0x168d12))[_0xb34b('0x3e')](handleError(_0xa5b57,null));};exports[_0xb34b('0x3f')]=function(_0x314206,_0x1f6d81){var _0xfec68d={'raw':![],'where':{'id':_0x314206[_0xb34b('0x40')]['id']}},_0x14e0b1={};_0x14e0b1[_0xb34b('0x2b')]=_[_0xb34b('0x41')](db[_0xb34b('0x27')][_0xb34b('0x28')]);_0x14e0b1[_0xb34b('0x2d')]=_[_0xb34b('0x41')](_0x314206[_0xb34b('0x2d')]);_0x14e0b1[_0xb34b('0x35')]=_['intersection'](_0x14e0b1[_0xb34b('0x2b')],_0x14e0b1['query']);_0xfec68d[_0xb34b('0x2f')]=_['intersection'](_0x14e0b1[_0xb34b('0x2b')],qs['fields'](_0x314206[_0xb34b('0x2d')]['fields']));_0xfec68d['attributes']=_0xfec68d[_0xb34b('0x2f')][_0xb34b('0x42')]?_0xfec68d[_0xb34b('0x2f')]:_0x14e0b1['model'];if(_0x314206[_0xb34b('0x2d')][_0xb34b('0x3a')]){_0xfec68d[_0xb34b('0x3b')]=[{'all':!![]}];}_0xfec68d=_['merge']({},_0xfec68d,_0x314206[_0xb34b('0x39')]);return db[_0xb34b('0x27')][_0xb34b('0x43')](_0xfec68d)[_0xb34b('0x21')](handleEntityNotFound(_0x1f6d81,null))[_0xb34b('0x21')](respondWithResult(_0x1f6d81,null))[_0xb34b('0x3e')](handleError(_0x1f6d81,null));};exports['create']=function(_0xc9ce68,_0x3ed9ce){return db[_0xb34b('0x27')]['create'](_0xc9ce68[_0xb34b('0x44')],{})[_0xb34b('0x21')](respondWithResult(_0x3ed9ce,0xc9))[_0xb34b('0x3e')](handleError(_0x3ed9ce,null));};exports[_0xb34b('0x1f')]=function(_0x1d95b7,_0x282ea8){if(_0x1d95b7[_0xb34b('0x44')]['id']){delete _0x1d95b7[_0xb34b('0x44')]['id'];}return db[_0xb34b('0x27')][_0xb34b('0x43')]({'where':{'id':_0x1d95b7[_0xb34b('0x40')]['id']}})[_0xb34b('0x21')](handleEntityNotFound(_0x282ea8,null))[_0xb34b('0x21')](saveUpdates(_0x1d95b7[_0xb34b('0x44')],null))[_0xb34b('0x21')](respondWithResult(_0x282ea8,null))[_0xb34b('0x3e')](handleError(_0x282ea8,null));};exports['destroy']=function(_0x50efee,_0x1599e2){return db[_0xb34b('0x27')]['find']({'where':{'id':_0x50efee['params']['id']}})[_0xb34b('0x21')](handleEntityNotFound(_0x1599e2,null))[_0xb34b('0x21')](removeEntity(_0x1599e2,null))['catch'](handleError(_0x1599e2,null));};exports[_0xb34b('0x45')]=function(_0x4f9f08,_0xbae95c,_0x207c93){var _0x59ef45={};var _0x34a80d={};var _0x5e6bfc;var _0x591180;return db[_0xb34b('0x27')][_0xb34b('0x46')]({'where':{'id':_0x4f9f08['params']['id']}})[_0xb34b('0x21')](handleEntityNotFound(_0xbae95c,null))[_0xb34b('0x21')](function(_0x39dae8){if(_0x39dae8){_0x5e6bfc=_0x39dae8;_0x34a80d[_0xb34b('0x2b')]=_['keys'](db[_0xb34b('0x47')][_0xb34b('0x28')]);_0x34a80d[_0xb34b('0x2d')]=_[_0xb34b('0x41')](_0x4f9f08['query']);_0x34a80d['filters']=_['intersection'](_0x34a80d[_0xb34b('0x2b')],_0x34a80d[_0xb34b('0x2d')]);_0x59ef45[_0xb34b('0x2f')]=_[_0xb34b('0x2e')](_0x34a80d[_0xb34b('0x2b')],qs[_0xb34b('0x30')](_0x4f9f08[_0xb34b('0x2d')]['fields']));_0x59ef45[_0xb34b('0x2f')]=_0x59ef45[_0xb34b('0x2f')][_0xb34b('0x42')]?_0x59ef45[_0xb34b('0x2f')]:_0x34a80d[_0xb34b('0x2b')];_0x59ef45[_0xb34b('0x32')]=qs[_0xb34b('0x33')](_0x4f9f08[_0xb34b('0x2d')][_0xb34b('0x33')]);_0x59ef45[_0xb34b('0x34')]=qs[_0xb34b('0x35')](_[_0xb34b('0x48')](_0x4f9f08[_0xb34b('0x2d')],_0x34a80d[_0xb34b('0x35')]));if(_0x4f9f08[_0xb34b('0x2d')]['filter']){_0x59ef45[_0xb34b('0x34')]=_[_0xb34b('0x38')](_0x59ef45[_0xb34b('0x34')],{'$or':_[_0xb34b('0x2c')](_0x59ef45['attributes'],function(_0x1a08bb){var _0x310d49={};_0x310d49[_0x1a08bb]={'$like':'%'+_0x4f9f08[_0xb34b('0x2d')][_0xb34b('0x37')]+'%'};return _0x310d49;})});}_0x59ef45=_['merge']({},_0x59ef45,_0x4f9f08[_0xb34b('0x39')]);return _0x5e6bfc[_0xb34b('0x45')](_0x59ef45);}})[_0xb34b('0x21')](function(_0x476f98){if(_0x476f98){_0x591180=_0x476f98[_0xb34b('0x42')];if(!_0x4f9f08[_0xb34b('0x2d')][_0xb34b('0x49')](_0xb34b('0x31'))){_0x59ef45[_0xb34b('0x19')]=qs[_0xb34b('0x19')](_0x4f9f08[_0xb34b('0x2d')][_0xb34b('0x19')]);_0x59ef45[_0xb34b('0x1a')]=qs[_0xb34b('0x1a')](_0x4f9f08[_0xb34b('0x2d')][_0xb34b('0x1a')]);}return _0x5e6bfc[_0xb34b('0x45')](_0x59ef45);}})[_0xb34b('0x21')](function(_0x4d33eb){if(_0x4d33eb){return _0x4d33eb?{'count':_0x591180,'rows':_0x4d33eb}:null;}})[_0xb34b('0x21')](respondWithResult(_0xbae95c,null))[_0xb34b('0x3e')](handleError(_0xbae95c,null));};exports[_0xb34b('0x4a')]=function(_0x3ec814,_0x31a563,_0xb8e0ea){if(_0x3ec814[_0xb34b('0x44')]['id']){delete _0x3ec814[_0xb34b('0x44')]['id'];}return db[_0xb34b('0x27')][_0xb34b('0x46')]({'where':{'id':_0x3ec814[_0xb34b('0x40')]['id']}})[_0xb34b('0x21')](handleEntityNotFound(_0x31a563,null))[_0xb34b('0x21')](function(_0x3cae03){if(_0x3cae03){_0x3ec814[_0xb34b('0x44')]['AccountId']=_0x3cae03['id'];_0x3ec814[_0xb34b('0x44')][_0xb34b('0x4b')]=integrations['getSubjects'](_0x3ec814[_0xb34b('0x44')]['channel'],_0x3ec814['body'][_0xb34b('0x2a')]);_0x3ec814[_0xb34b('0x44')]['Descriptions']=integrations[_0xb34b('0x4c')](_0x3ec814['body'][_0xb34b('0x4d')],_0x3ec814[_0xb34b('0x44')][_0xb34b('0x2a')]);return db[_0xb34b('0x47')][_0xb34b('0x4e')](_0x3ec814[_0xb34b('0x44')],{'include':[{'model':db[_0xb34b('0x4f')],'as':'Subjects'},{'model':db['ZohoField'],'as':_0xb34b('0x50')}]});}return null;})[_0xb34b('0x21')](respondWithResult(_0x31a563,null))[_0xb34b('0x3e')](handleError(_0x31a563,null));};function getAccessToken(_0xeef403){return new Promise(function(_0x1e9c57,_0x2f0ca8){var _0x4adb8e;switch(_0xeef403[_0xb34b('0x51')]){case'US':_0x4adb8e=_0xb34b('0x52');break;case'AU':_0x4adb8e=_0xb34b('0x53');break;case'EU':_0x4adb8e=_0xb34b('0x54');break;case'IN':_0x4adb8e=_0xb34b('0x55');break;case'CN':_0x4adb8e=_0xb34b('0x56');break;default:_0x4adb8e=_0xb34b('0x54');break;}var _0x3191e={'method':_0xb34b('0x57'),'uri':_0x4adb8e+'/oauth/v2/token','qs':{'refresh_token':_0xeef403[_0xb34b('0x58')],'client_id':_0xeef403[_0xb34b('0x59')],'client_secret':_0xeef403[_0xb34b('0x5a')],'grant_type':'refresh_token'},'json':!![]};return rp(_0x3191e)[_0xb34b('0x21')](function(_0x238089){if(_0x238089['access_token']){_0x1e9c57(_0x238089[_0xb34b('0x5b')]);}else{_0x2f0ca8('Unable\x20to\x20retrieve\x20the\x20access\x20token');}})['catch'](function(_0x1220b0){_0x2f0ca8(_0x1220b0);});});}exports[_0xb34b('0x5c')]=function(_0x287403,_0x5c67c1,_0xff43d){var _0xbb87a6,_0x39b151,_0xe35c05,_0x55d319,_0x18d717;return db[_0xb34b('0x27')][_0xb34b('0x46')]({'where':{'id':_0x287403[_0xb34b('0x40')]['id']},'attributes':['id',_0xb34b('0x5d'),_0xb34b('0x51'),_0xb34b('0x59'),_0xb34b('0x5a'),_0xb34b('0x5e'),_0xb34b('0x5f'),_0xb34b('0x58')]})[_0xb34b('0x21')](handleEntityNotFound(_0x5c67c1,null))[_0xb34b('0x21')](function(_0x596a46){_0x18d717=_0x596a46;_0xbb87a6=_0x18d717[_0xb34b('0x5d')];_0x39b151=_0xbb87a6==='zoho.eu'?'eu':'com';_0xe35c05=_0x18d717[_0xb34b('0x5e')];var _0x268fb1=_0xe35c05['slice'](-0x1);if(_0x268fb1==='/'||_0x268fb1==='\x5c'||_0x268fb1===':'){_0xe35c05=_0xe35c05[_0xb34b('0x60')](0x0,_0xe35c05['lastIndexOf'](_0x268fb1));}if(!_0x18d717['refreshToken']){throw new Error(_0xb34b('0x61'));}return getAccessToken(_0x18d717);})['then'](function(_0x1a7553){if(_0x1a7553){return rp({'method':_0xb34b('0x62'),'uri':util[_0xb34b('0x63')](_0xb34b('0x64'),_0x39b151),'qs':{'module':'Calls'},'headers':{'Authorization':_0xb34b('0x65')+_0x1a7553},'json':!![]});}})[_0xb34b('0x21')](function(_0x15e111){if(_0x15e111){if(_0x15e111[_0xb34b('0x66')]&&_0x15e111[_0xb34b('0x66')][_0xb34b('0x23')]){throw new Error(_0x15e111[_0xb34b('0x66')][_0xb34b('0x23')][_0xb34b('0x67')]);}var _0x2aaaf6=[];var _0x410045=[];var _0x24a4a5=[_0xb34b('0x68'),'Subject',_0xb34b('0x69'),_0xb34b('0x6a'),'Call_Duration',_0xb34b('0x6b'),_0xb34b('0x6c'),'Call_Type'];_0x410045=_[_0xb34b('0x6d')](_0x15e111[_0xb34b('0x30')],function(_0x218fb8){return _0x24a4a5[_0xb34b('0x6e')](_0x218fb8[_0xb34b('0x6f')]);});for(var _0x37056d=0x0;_0x37056d<_0x410045['length'];_0x37056d++){if(_0x410045[_0x37056d][_0xb34b('0x70')]===![]){_0x2aaaf6[_0xb34b('0x71')]({'id':_0x410045[_0x37056d]['id'],'name':_0x410045[_0x37056d]['display_label'],'custom':_0x410045[_0x37056d][_0xb34b('0x72')],'options':_0x410045[_0x37056d]['data_type']===_0xb34b('0x73')&&_0x410045[_0x37056d][_0xb34b('0x74')][_0xb34b('0x42')]>-0x1?_[_0xb34b('0x2c')](_0x410045[_0x37056d][_0xb34b('0x74')],function(_0x3df679){return{'name':_0x3df679,'value':_0x3df679};}):[]});}}return{'count':_0x2aaaf6[_0xb34b('0x42')],'rows':_0x2aaaf6};}else{return{'count':0x0,'rows':[]};}})[_0xb34b('0x21')](respondWithResult(_0x5c67c1,null))[_0xb34b('0x3e')](function(_0x1b18d2){var _0x160758=_0x287403[_0xb34b('0x2d')][_0xb34b('0x75')]?0x1f4:_0x1b18d2[_0xb34b('0x76')]||0x1f4;logger[_0xb34b('0x23')](_0xb34b('0x77'),_0xb34b('0x5c'),_0x160758,JSON[_0xb34b('0x78')](_0x1b18d2));delete _0x1b18d2[_0xb34b('0x24')];if(_0x160758===0x191){_0x160758=0x190;}_0x5c67c1['status'](_0x160758)[_0xb34b('0x25')](_0x287403[_0xb34b('0x2d')]['test']?{'message':_0xb34b('0x79'),'statusCode':_0x1b18d2[_0xb34b('0x76')]}:_0x1b18d2);});};