83fa5a110c49e2231f54f859765454c8d4b337bf
[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 _0x8109=['https://accounts.zoho.eu','https://accounts.zoho.in','https://accounts.zoho.com.cn','POST','/oauth/v2/token','clientSecret','Unable\x20to\x20retrieve\x20the\x20access\x20token','clientId','serverUrl','code','host','zoho.eu','com','slice','substring','lastIndexOf','refreshToken','Refresh\x20Token\x20not\x20available\x20for\x20the\x20account','GET','format','https://www.zohoapis.%s/crm/v2/settings/fields','Calls','Zoho-oauthtoken\x20','response','Owner','Description','WhoId','Call_Duration','Call_Type','remove','includes','api_name','system_mandatory','push','display_label','custom_field','pick_list_values','test','statusCode','getFields','stringify','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','sendStatus','status','end','limit','count','offset','set','Content-Range','apply','reject','save','then','error','name','send','index','map','ZohoAccount','type','model','query','keys','intersection','attributes','length','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','rawAttributes','fields','find','create','body','update','destroy','getConfigurations','findOne','filters','hasOwnProperty','AccountId','Subjects','channel','Descriptions','getDescriptions','ZohoConfiguration','ZohoField','zone','https://accounts.zoho.com'];(function(_0x3381ba,_0xfb68d3){var _0x9cc64c=function(_0x2a5eb5){while(--_0x2a5eb5){_0x3381ba['push'](_0x3381ba['shift']());}};_0x9cc64c(++_0xfb68d3);}(_0x8109,0xa9));var _0x9810=function(_0x1f7579,_0x3d829b){_0x1f7579=_0x1f7579-0x0;var _0x5072e3=_0x8109[_0x1f7579];return _0x5072e3;};'use strict';var emlformat=require(_0x9810('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x9810('0x1'));var jsonpatch=require(_0x9810('0x2'));var rp=require('request-promise');var moment=require(_0x9810('0x3'));var BPromise=require(_0x9810('0x4'));var Mustache=require(_0x9810('0x5'));var util=require(_0x9810('0x6'));var path=require(_0x9810('0x7'));var sox=require(_0x9810('0x8'));var csv=require(_0x9810('0x9'));var ejs=require(_0x9810('0xa'));var fs=require('fs');var fs_extra=require(_0x9810('0xb'));var _=require(_0x9810('0xc'));var squel=require(_0x9810('0xd'));var crypto=require('crypto');var jsforce=require(_0x9810('0xe'));var deskjs=require(_0x9810('0xf'));var toCsv=require(_0x9810('0x9'));var querystring=require(_0x9810('0x10'));var Papa=require(_0x9810('0x11'));var Redis=require('ioredis');var authService=require(_0x9810('0x12'));var qs=require(_0x9810('0x13'));var as=require(_0x9810('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x9810('0x15'))('api');var utils=require('../../config/utils');var config=require(_0x9810('0x16'));var licenseUtil=require(_0x9810('0x17'));var db=require(_0x9810('0x18'))['db'];var integrations=require(_0x9810('0x19'));function respondWithStatusCode(_0x413c7a,_0x27f957){_0x27f957=_0x27f957||0xcc;return function(_0x48ec14){if(_0x48ec14){return _0x413c7a[_0x9810('0x1a')](_0x27f957);}return _0x413c7a[_0x9810('0x1b')](_0x27f957)[_0x9810('0x1c')]();};}function respondWithResult(_0x2f6fc0,_0x2d52b1){_0x2d52b1=_0x2d52b1||0xc8;return function(_0x333ad4){if(_0x333ad4){return _0x2f6fc0[_0x9810('0x1b')](_0x2d52b1)['json'](_0x333ad4);}};}function respondWithFilteredResult(_0x3796e2,_0x1a4735){return function(_0xd6188c){if(_0xd6188c){var _0x260be2=typeof _0x1a4735['offset']==='undefined'&&typeof _0x1a4735[_0x9810('0x1d')]==='undefined';var _0x5df228=_0xd6188c[_0x9810('0x1e')];var _0x2ac66d=_0x260be2?0x0:_0x1a4735[_0x9810('0x1f')];var _0xf5f946=_0x260be2?_0xd6188c[_0x9810('0x1e')]:_0x1a4735[_0x9810('0x1f')]+_0x1a4735['limit'];var _0x54c439;if(_0xf5f946>=_0x5df228){_0xf5f946=_0x5df228;_0x54c439=0xc8;}else{_0x54c439=0xce;}_0x3796e2['status'](_0x54c439);return _0x3796e2[_0x9810('0x20')](_0x9810('0x21'),_0x2ac66d+'-'+_0xf5f946+'/'+_0x5df228)['json'](_0xd6188c);}return null;};}function patchUpdates(_0x1be8d2){return function(_0x6d3748){try{jsonpatch[_0x9810('0x22')](_0x6d3748,_0x1be8d2,!![]);}catch(_0x101ba8){return BPromise[_0x9810('0x23')](_0x101ba8);}return _0x6d3748[_0x9810('0x24')]();};}function saveUpdates(_0x4f0f55,_0x273b1b){return function(_0x164c42){if(_0x164c42){return _0x164c42['update'](_0x4f0f55)[_0x9810('0x25')](function(_0xd96d05){return _0xd96d05;});}return null;};}function removeEntity(_0xadadda,_0x4bc29a){return function(_0x44ea43){if(_0x44ea43){return _0x44ea43['destroy']()[_0x9810('0x25')](function(){_0xadadda['status'](0xcc)[_0x9810('0x1c')]();});}};}function handleEntityNotFound(_0xc0de6c,_0x18b185){return function(_0x3ed36b){if(!_0x3ed36b){_0xc0de6c['sendStatus'](0x194);}return _0x3ed36b;};}function handleError(_0x528da6,_0x539696){_0x539696=_0x539696||0x1f4;return function(_0x137b47){logger[_0x9810('0x26')](_0x137b47['stack']);if(_0x137b47[_0x9810('0x27')]){delete _0x137b47['name'];}_0x528da6['status'](_0x539696)[_0x9810('0x28')](_0x137b47);};}exports[_0x9810('0x29')]=function(_0x303727,_0x3db9a3){var _0x17f314={},_0x3a65ba={},_0x4f7c2b={'count':0x0,'rows':[]};var _0x91cfb8=_[_0x9810('0x2a')](db[_0x9810('0x2b')]['rawAttributes'],function(_0x21628b){return{'name':_0x21628b['fieldName'],'type':_0x21628b[_0x9810('0x2c')]['key']};});_0x3a65ba[_0x9810('0x2d')]=_[_0x9810('0x2a')](_0x91cfb8,_0x9810('0x27'));_0x3a65ba[_0x9810('0x2e')]=_[_0x9810('0x2f')](_0x303727[_0x9810('0x2e')]);_0x3a65ba['filters']=_[_0x9810('0x30')](_0x3a65ba[_0x9810('0x2d')],_0x3a65ba[_0x9810('0x2e')]);_0x17f314[_0x9810('0x31')]=_['intersection'](_0x3a65ba['model'],qs['fields'](_0x303727['query']['fields']));_0x17f314['attributes']=_0x17f314[_0x9810('0x31')][_0x9810('0x32')]?_0x17f314[_0x9810('0x31')]:_0x3a65ba[_0x9810('0x2d')];if(!_0x303727[_0x9810('0x2e')]['hasOwnProperty'](_0x9810('0x33'))){_0x17f314['limit']=qs[_0x9810('0x1d')](_0x303727[_0x9810('0x2e')]['limit']);_0x17f314[_0x9810('0x1f')]=qs[_0x9810('0x1f')](_0x303727[_0x9810('0x2e')][_0x9810('0x1f')]);}_0x17f314[_0x9810('0x34')]=qs[_0x9810('0x35')](_0x303727[_0x9810('0x2e')][_0x9810('0x35')]);_0x17f314[_0x9810('0x36')]=qs['filters'](_[_0x9810('0x37')](_0x303727[_0x9810('0x2e')],_0x3a65ba['filters']),_0x91cfb8);if(_0x303727[_0x9810('0x2e')][_0x9810('0x38')]){_0x17f314[_0x9810('0x36')]=_[_0x9810('0x39')](_0x17f314[_0x9810('0x36')],{'$or':_['map'](_0x91cfb8,function(_0x28a029){if(_0x28a029[_0x9810('0x2c')]!==_0x9810('0x3a')){var _0x209b5a={};_0x209b5a[_0x28a029[_0x9810('0x27')]]={'$like':'%'+_0x303727[_0x9810('0x2e')][_0x9810('0x38')]+'%'};return _0x209b5a;}})});}_0x17f314=_[_0x9810('0x39')]({},_0x17f314,_0x303727[_0x9810('0x3b')]);var _0x2d9141={'where':_0x17f314[_0x9810('0x36')]};return db['ZohoAccount'][_0x9810('0x1e')](_0x2d9141)[_0x9810('0x25')](function(_0x54bcd3){_0x4f7c2b['count']=_0x54bcd3;if(_0x303727[_0x9810('0x2e')][_0x9810('0x3c')]){_0x17f314[_0x9810('0x3d')]=[{'all':!![]}];}return db['ZohoAccount'][_0x9810('0x3e')](_0x17f314);})[_0x9810('0x25')](function(_0xf4541a){_0x4f7c2b[_0x9810('0x3f')]=_0xf4541a;return _0x4f7c2b;})[_0x9810('0x25')](respondWithFilteredResult(_0x3db9a3,_0x17f314))[_0x9810('0x40')](handleError(_0x3db9a3,null));};exports[_0x9810('0x41')]=function(_0xe818e1,_0x3c21d7){var _0x1194b6={'raw':![],'where':{'id':_0xe818e1[_0x9810('0x42')]['id']}},_0x31c349={};_0x31c349['model']=_['keys'](db[_0x9810('0x2b')][_0x9810('0x43')]);_0x31c349[_0x9810('0x2e')]=_[_0x9810('0x2f')](_0xe818e1[_0x9810('0x2e')]);_0x31c349['filters']=_[_0x9810('0x30')](_0x31c349[_0x9810('0x2d')],_0x31c349['query']);_0x1194b6[_0x9810('0x31')]=_[_0x9810('0x30')](_0x31c349[_0x9810('0x2d')],qs[_0x9810('0x44')](_0xe818e1[_0x9810('0x2e')][_0x9810('0x44')]));_0x1194b6[_0x9810('0x31')]=_0x1194b6[_0x9810('0x31')][_0x9810('0x32')]?_0x1194b6[_0x9810('0x31')]:_0x31c349[_0x9810('0x2d')];if(_0xe818e1[_0x9810('0x2e')][_0x9810('0x3c')]){_0x1194b6[_0x9810('0x3d')]=[{'all':!![]}];}_0x1194b6=_[_0x9810('0x39')]({},_0x1194b6,_0xe818e1[_0x9810('0x3b')]);return db[_0x9810('0x2b')][_0x9810('0x45')](_0x1194b6)[_0x9810('0x25')](handleEntityNotFound(_0x3c21d7,null))['then'](respondWithResult(_0x3c21d7,null))[_0x9810('0x40')](handleError(_0x3c21d7,null));};exports[_0x9810('0x46')]=function(_0x2fd6ea,_0x42db0a){return db[_0x9810('0x2b')][_0x9810('0x46')](_0x2fd6ea[_0x9810('0x47')],{})[_0x9810('0x25')](respondWithResult(_0x42db0a,0xc9))[_0x9810('0x40')](handleError(_0x42db0a,null));};exports[_0x9810('0x48')]=function(_0x3289da,_0x80fc68){if(_0x3289da[_0x9810('0x47')]['id']){delete _0x3289da[_0x9810('0x47')]['id'];}return db[_0x9810('0x2b')][_0x9810('0x45')]({'where':{'id':_0x3289da[_0x9810('0x42')]['id']}})[_0x9810('0x25')](handleEntityNotFound(_0x80fc68,null))['then'](saveUpdates(_0x3289da[_0x9810('0x47')],null))[_0x9810('0x25')](respondWithResult(_0x80fc68,null))[_0x9810('0x40')](handleError(_0x80fc68,null));};exports[_0x9810('0x49')]=function(_0x2d3a43,_0x56b8a3){return db[_0x9810('0x2b')][_0x9810('0x45')]({'where':{'id':_0x2d3a43[_0x9810('0x42')]['id']}})[_0x9810('0x25')](handleEntityNotFound(_0x56b8a3,null))['then'](removeEntity(_0x56b8a3,null))[_0x9810('0x40')](handleError(_0x56b8a3,null));};exports[_0x9810('0x4a')]=function(_0x38e181,_0x5bcc15,_0x55cf97){var _0xc62641={};var _0x16b72c={};var _0x7a5230;var _0xafef23;return db[_0x9810('0x2b')][_0x9810('0x4b')]({'where':{'id':_0x38e181[_0x9810('0x42')]['id']}})[_0x9810('0x25')](handleEntityNotFound(_0x5bcc15,null))['then'](function(_0x1ef1f2){if(_0x1ef1f2){_0x7a5230=_0x1ef1f2;_0x16b72c[_0x9810('0x2d')]=_[_0x9810('0x2f')](db['ZohoConfiguration']['rawAttributes']);_0x16b72c[_0x9810('0x2e')]=_['keys'](_0x38e181[_0x9810('0x2e')]);_0x16b72c[_0x9810('0x4c')]=_[_0x9810('0x30')](_0x16b72c['model'],_0x16b72c['query']);_0xc62641[_0x9810('0x31')]=_[_0x9810('0x30')](_0x16b72c[_0x9810('0x2d')],qs[_0x9810('0x44')](_0x38e181['query']['fields']));_0xc62641['attributes']=_0xc62641[_0x9810('0x31')][_0x9810('0x32')]?_0xc62641['attributes']:_0x16b72c[_0x9810('0x2d')];_0xc62641[_0x9810('0x34')]=qs[_0x9810('0x35')](_0x38e181[_0x9810('0x2e')][_0x9810('0x35')]);_0xc62641['where']=qs[_0x9810('0x4c')](_[_0x9810('0x37')](_0x38e181[_0x9810('0x2e')],_0x16b72c[_0x9810('0x4c')]));if(_0x38e181[_0x9810('0x2e')][_0x9810('0x38')]){_0xc62641[_0x9810('0x36')]=_[_0x9810('0x39')](_0xc62641[_0x9810('0x36')],{'$or':_[_0x9810('0x2a')](_0xc62641[_0x9810('0x31')],function(_0x17b45b){var _0x508aba={};_0x508aba[_0x17b45b]={'$like':'%'+_0x38e181[_0x9810('0x2e')][_0x9810('0x38')]+'%'};return _0x508aba;})});}_0xc62641=_[_0x9810('0x39')]({},_0xc62641,_0x38e181[_0x9810('0x3b')]);return _0x7a5230[_0x9810('0x4a')](_0xc62641);}})[_0x9810('0x25')](function(_0x55f425){if(_0x55f425){_0xafef23=_0x55f425[_0x9810('0x32')];if(!_0x38e181[_0x9810('0x2e')][_0x9810('0x4d')](_0x9810('0x33'))){_0xc62641['limit']=qs[_0x9810('0x1d')](_0x38e181['query'][_0x9810('0x1d')]);_0xc62641[_0x9810('0x1f')]=qs[_0x9810('0x1f')](_0x38e181[_0x9810('0x2e')][_0x9810('0x1f')]);}return _0x7a5230[_0x9810('0x4a')](_0xc62641);}})[_0x9810('0x25')](function(_0x2051d2){if(_0x2051d2){return _0x2051d2?{'count':_0xafef23,'rows':_0x2051d2}:null;}})[_0x9810('0x25')](respondWithResult(_0x5bcc15,null))[_0x9810('0x40')](handleError(_0x5bcc15,null));};exports['addConfiguration']=function(_0x27aade,_0x52a075,_0x16b0c3){if(_0x27aade['body']['id']){delete _0x27aade[_0x9810('0x47')]['id'];}return db['ZohoAccount'][_0x9810('0x4b')]({'where':{'id':_0x27aade['params']['id']}})[_0x9810('0x25')](handleEntityNotFound(_0x52a075,null))['then'](function(_0x10500f){if(_0x10500f){_0x27aade[_0x9810('0x47')][_0x9810('0x4e')]=_0x10500f['id'];_0x27aade[_0x9810('0x47')][_0x9810('0x4f')]=integrations['getSubjects'](_0x27aade[_0x9810('0x47')][_0x9810('0x50')],_0x27aade[_0x9810('0x47')]['type']);_0x27aade['body'][_0x9810('0x51')]=integrations[_0x9810('0x52')](_0x27aade['body'][_0x9810('0x50')],_0x27aade[_0x9810('0x47')]['type']);return db[_0x9810('0x53')][_0x9810('0x46')](_0x27aade[_0x9810('0x47')],{'include':[{'model':db[_0x9810('0x54')],'as':_0x9810('0x4f')},{'model':db[_0x9810('0x54')],'as':'Descriptions'}]});}return null;})[_0x9810('0x25')](respondWithResult(_0x52a075,null))['catch'](handleError(_0x52a075,null));};function getAccessToken(_0x462274){return new Promise(function(_0x37f1df,_0x116336){var _0x134fb8;switch(_0x462274[_0x9810('0x55')]){case'US':_0x134fb8=_0x9810('0x56');break;case'AU':_0x134fb8='https://accounts.zoho.com.au';break;case'EU':_0x134fb8=_0x9810('0x57');break;case'IN':_0x134fb8=_0x9810('0x58');break;case'CN':_0x134fb8=_0x9810('0x59');break;default:_0x134fb8=_0x9810('0x57');break;}var _0x337b50={'method':_0x9810('0x5a'),'uri':_0x134fb8+_0x9810('0x5b'),'qs':{'refresh_token':_0x462274['refreshToken'],'client_id':_0x462274['clientId'],'client_secret':_0x462274[_0x9810('0x5c')],'grant_type':'refresh_token'},'json':!![]};return rp(_0x337b50)[_0x9810('0x25')](function(_0x536def){if(_0x536def['access_token']){_0x37f1df(_0x536def['access_token']);}else{_0x116336(_0x9810('0x5d'));}})['catch'](function(_0xa50ad){_0x116336(_0xa50ad);});});}exports['getFields']=function(_0x1ef89b,_0x462af2,_0x1e7614){var _0x58c08a,_0x24128e,_0x5d9b0d,_0x253437,_0x593e30;return db[_0x9810('0x2b')]['findOne']({'where':{'id':_0x1ef89b[_0x9810('0x42')]['id']},'attributes':['id','host','zone',_0x9810('0x5e'),_0x9810('0x5c'),_0x9810('0x5f'),_0x9810('0x60'),'refreshToken']})[_0x9810('0x25')](handleEntityNotFound(_0x462af2,null))[_0x9810('0x25')](function(_0x280ef8){_0x593e30=_0x280ef8;_0x58c08a=_0x593e30[_0x9810('0x61')];_0x24128e=_0x58c08a===_0x9810('0x62')?'eu':_0x9810('0x63');_0x5d9b0d=_0x593e30[_0x9810('0x5f')];var _0x1406bf=_0x5d9b0d[_0x9810('0x64')](-0x1);if(_0x1406bf==='/'||_0x1406bf==='\x5c'||_0x1406bf===':'){_0x5d9b0d=_0x5d9b0d[_0x9810('0x65')](0x0,_0x5d9b0d[_0x9810('0x66')](_0x1406bf));}if(!_0x593e30[_0x9810('0x67')]){throw new Error(_0x9810('0x68'));}return getAccessToken(_0x593e30);})[_0x9810('0x25')](function(_0x40a2b6){if(_0x40a2b6){return rp({'method':_0x9810('0x69'),'uri':util[_0x9810('0x6a')](_0x9810('0x6b'),_0x24128e),'qs':{'module':_0x9810('0x6c')},'headers':{'Authorization':_0x9810('0x6d')+_0x40a2b6},'json':!![]});}})[_0x9810('0x25')](function(_0x21921a){if(_0x21921a){if(_0x21921a['response']&&_0x21921a[_0x9810('0x6e')][_0x9810('0x26')]){throw new Error(_0x21921a[_0x9810('0x6e')][_0x9810('0x26')]['message']);}var _0x192949=[];var _0x3d6b91=[];var _0xcee5ab=[_0x9810('0x6f'),'Subject',_0x9810('0x70'),_0x9810('0x71'),_0x9810('0x72'),'Call_Result','Call_Start_Time',_0x9810('0x73')];_0x3d6b91=_[_0x9810('0x74')](_0x21921a[_0x9810('0x44')],function(_0x40d6c5){return _0xcee5ab[_0x9810('0x75')](_0x40d6c5[_0x9810('0x76')]);});for(var _0x2f83b7=0x0;_0x2f83b7<_0x3d6b91['length'];_0x2f83b7++){if(_0x3d6b91[_0x2f83b7][_0x9810('0x77')]===![]){_0x192949[_0x9810('0x78')]({'id':_0x3d6b91[_0x2f83b7]['id'],'name':_0x3d6b91[_0x2f83b7][_0x9810('0x79')],'custom':_0x3d6b91[_0x2f83b7][_0x9810('0x7a')],'options':_0x3d6b91[_0x2f83b7]['data_type']==='picklist'&&_0x3d6b91[_0x2f83b7][_0x9810('0x7b')]['length']>-0x1?_[_0x9810('0x2a')](_0x3d6b91[_0x2f83b7][_0x9810('0x7b')],function(_0x300ca1){return{'name':_0x300ca1,'value':_0x300ca1};}):[]});}}return{'count':_0x192949[_0x9810('0x32')],'rows':_0x192949};}else{return{'count':0x0,'rows':[]};}})[_0x9810('0x25')](respondWithResult(_0x462af2,null))[_0x9810('0x40')](function(_0x334793){var _0x5eb4e7=_0x1ef89b['query'][_0x9810('0x7c')]?0x1f4:_0x334793[_0x9810('0x7d')]||0x1f4;logger[_0x9810('0x26')]('getFields,\x20%s,\x20%s,\x20%s',_0x9810('0x7e'),_0x5eb4e7,JSON[_0x9810('0x7f')](_0x334793));delete _0x334793['name'];if(_0x5eb4e7===0x191){_0x5eb4e7=0x190;}_0x462af2[_0x9810('0x1b')](_0x5eb4e7)[_0x9810('0x28')](_0x1ef89b[_0x9810('0x2e')][_0x9810('0x7c')]?{'message':'Wrong\x20credentials','statusCode':_0x334793[_0x9810('0x7d')]}:_0x334793);});};