7f7b5e16be335891723ec3575ec2c2bad24f6a57
[motion2.git] / server / api / intVtigerAccount / intVtigerAccount.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 _0x9147=['statusCode','html-pdf','eml-format','rimraf','request-promise','moment','mustache','util','path','sox','ejs','squel','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','jayson/promise','then','info','request\x20sent','debug','VtigerAccount,\x20%s,\x20%s,\x20%s','error','VtigerAccount,\x20%s,\x20%s','message','result','sendStatus','status','json','count','offset','limit','set','Content-Range','reject','save','update','destroy','stack','name','send','index','map','VtigerAccount','fieldName','type','key','keys','query','filters','intersection','model','fields','attributes','length','nolimit','order','sort','where','pick','filter','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','rawAttributes','merge','find','create','body','getConfigurations','VtigerConfiguration','hasOwnProperty','addConfiguration','findOne','AccountId','channel','Descriptions','VtigerField','md5','getFields','description','moduleName','remoteUri','serverUrl','username','accessKey','lastIndexOf','%s/webservice.php','GET','getchallenge','success','login','token','sessionName','autogenerated','reference','owner','remove','includes','editable','false','label','cf_','picklistValues','vTiger\x20error:\x20','test','getFields,\x20%s,\x20%s,\x20%s','stringify','Wrong\x20credentials'];(function(_0x3619,_0x1ac6b9){var _0x490897=function(_0x1ead4f){while(--_0x1ead4f){_0x3619['push'](_0x3619['shift']());}};_0x490897(++_0x1ac6b9);}(_0x9147,0x7f));var _0x7914=function(_0x5c351c,_0x2046d8){_0x5c351c=_0x5c351c-0x0;var _0x26f3b3=_0x9147[_0x5c351c];return _0x26f3b3;};'use strict';var pdf=require(_0x7914('0x0'));var emlformat=require(_0x7914('0x1'));var rimraf=require(_0x7914('0x2'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x7914('0x3'));var moment=require(_0x7914('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x7914('0x5'));var util=require(_0x7914('0x6'));var path=require(_0x7914('0x7'));var sox=require(_0x7914('0x8'));var csv=require('to-csv');var ejs=require(_0x7914('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x7914('0xa'));var crypto=require('crypto');var jsforce=require(_0x7914('0xb'));var deskjs=require(_0x7914('0xc'));var toCsv=require(_0x7914('0xd'));var querystring=require(_0x7914('0xe'));var Papa=require(_0x7914('0xf'));var Redis=require(_0x7914('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x7914('0x11'));var as=require(_0x7914('0x12'));var hardwareService=require(_0x7914('0x13'));var logger=require(_0x7914('0x14'))('api');var utils=require(_0x7914('0x15'));var config=require(_0x7914('0x16'));var licenseUtil=require(_0x7914('0x17'));var db=require(_0x7914('0x18'))['db'];var integrations=require(_0x7914('0x19'));var jayson=require(_0x7914('0x1a'));var client=jayson['client']['http']({'port':0x232a});function respondWithRpcPromise(_0x48bb08,_0x2089d7,_0x543680,_0x13c859){return new BPromise(function(_0x364785,_0x225a08){var _0x38da04=_0x13c859||client;return _0x38da04['request'](_0x48bb08,_0x543680)[_0x7914('0x1b')](function(_0x1be13a){logger[_0x7914('0x1c')]('VtigerAccount,\x20%s,\x20%s',_0x2089d7,_0x7914('0x1d'));logger[_0x7914('0x1e')](_0x7914('0x1f'),_0x2089d7,_0x7914('0x1d'),JSON['stringify'](_0x1be13a));if(_0x1be13a['error']){if(_0x1be13a[_0x7914('0x20')]['code']===0x1f4){logger['error'](_0x7914('0x21'),_0x2089d7,_0x1be13a[_0x7914('0x20')][_0x7914('0x22')]);return _0x225a08(_0x1be13a[_0x7914('0x20')][_0x7914('0x22')]);}logger[_0x7914('0x20')](_0x7914('0x21'),_0x2089d7,_0x1be13a[_0x7914('0x20')]['message']);return _0x364785(_0x1be13a[_0x7914('0x20')][_0x7914('0x22')]);}else{logger[_0x7914('0x1c')](_0x7914('0x21'),_0x2089d7,_0x7914('0x1d'));_0x364785(_0x1be13a[_0x7914('0x23')][_0x7914('0x22')]);}})['catch'](function(_0x274d33){logger[_0x7914('0x20')](_0x7914('0x21'),_0x2089d7,_0x274d33);_0x225a08(_0x274d33);});});}function respondWithStatusCode(_0x21763f,_0x60c7c6){_0x60c7c6=_0x60c7c6||0xcc;return function(_0x495541){if(_0x495541){return _0x21763f[_0x7914('0x24')](_0x60c7c6);}return _0x21763f[_0x7914('0x25')](_0x60c7c6)['end']();};}function respondWithResult(_0x1a27ba,_0x1d7948){_0x1d7948=_0x1d7948||0xc8;return function(_0x1786f8){if(_0x1786f8){return _0x1a27ba[_0x7914('0x25')](_0x1d7948)[_0x7914('0x26')](_0x1786f8);}};}function respondWithFilteredResult(_0x2d8ac4,_0x5f5609){return function(_0x3e1de5){if(_0x3e1de5){var _0x1adbe8=_0x3e1de5[_0x7914('0x27')],_0x3a62ff=_0x5f5609[_0x7914('0x28')],_0x124011=_0x5f5609[_0x7914('0x28')]+_0x5f5609[_0x7914('0x29')],_0x4f7281;if(_0x124011>=_0x1adbe8){_0x124011=_0x1adbe8;_0x4f7281=0xc8;}else{_0x4f7281=0xce;}_0x2d8ac4['status'](_0x4f7281);return _0x2d8ac4[_0x7914('0x2a')](_0x7914('0x2b'),_0x3a62ff+'-'+_0x124011+'/'+_0x1adbe8)[_0x7914('0x26')](_0x3e1de5);}return null;};}function patchUpdates(_0x3f59a8){return function(_0x19e237){try{jsonpatch['apply'](_0x19e237,_0x3f59a8,!![]);}catch(_0x5eaf3e){return BPromise[_0x7914('0x2c')](_0x5eaf3e);}return _0x19e237[_0x7914('0x2d')]();};}function saveUpdates(_0x1dd842,_0x57d32e){return function(_0x2d2306){if(_0x2d2306){return _0x2d2306[_0x7914('0x2e')](_0x1dd842)['then'](function(_0xf06fd2){return _0xf06fd2;});}return null;};}function removeEntity(_0x7f3742,_0x3974ce){return function(_0x497952){if(_0x497952){return _0x497952[_0x7914('0x2f')]()[_0x7914('0x1b')](function(){_0x7f3742['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x30263a,_0x23f970){return function(_0xf9384b){if(!_0xf9384b){_0x30263a['sendStatus'](0x194);}return _0xf9384b;};}function handleError(_0x5c1fce,_0x17c9ce){_0x17c9ce=_0x17c9ce||0x1f4;return function(_0x3ac08c){logger[_0x7914('0x20')](_0x3ac08c[_0x7914('0x30')]);if(_0x3ac08c[_0x7914('0x31')]){delete _0x3ac08c[_0x7914('0x31')];}_0x5c1fce[_0x7914('0x25')](_0x17c9ce)[_0x7914('0x32')](_0x3ac08c);};}exports[_0x7914('0x33')]=function(_0x55abb4,_0x35106e){var _0x3ca53a={},_0x429461={},_0x4c96ed={'count':0x0,'rows':[]};var _0xdc7085=_[_0x7914('0x34')](db[_0x7914('0x35')]['rawAttributes'],function(_0x4132d7){return{'name':_0x4132d7[_0x7914('0x36')],'type':_0x4132d7[_0x7914('0x37')][_0x7914('0x38')]};});_0x429461['model']=_[_0x7914('0x34')](_0xdc7085,_0x7914('0x31'));_0x429461['query']=_[_0x7914('0x39')](_0x55abb4[_0x7914('0x3a')]);_0x429461[_0x7914('0x3b')]=_[_0x7914('0x3c')](_0x429461[_0x7914('0x3d')],_0x429461['query']);_0x3ca53a['attributes']=_['intersection'](_0x429461[_0x7914('0x3d')],qs[_0x7914('0x3e')](_0x55abb4[_0x7914('0x3a')][_0x7914('0x3e')]));_0x3ca53a[_0x7914('0x3f')]=_0x3ca53a['attributes'][_0x7914('0x40')]?_0x3ca53a[_0x7914('0x3f')]:_0x429461[_0x7914('0x3d')];if(!_0x55abb4['query']['hasOwnProperty'](_0x7914('0x41'))){_0x3ca53a[_0x7914('0x29')]=qs[_0x7914('0x29')](_0x55abb4['query'][_0x7914('0x29')]);_0x3ca53a[_0x7914('0x28')]=qs[_0x7914('0x28')](_0x55abb4[_0x7914('0x3a')][_0x7914('0x28')]);}_0x3ca53a[_0x7914('0x42')]=qs['sort'](_0x55abb4[_0x7914('0x3a')][_0x7914('0x43')]);_0x3ca53a[_0x7914('0x44')]=qs[_0x7914('0x3b')](_[_0x7914('0x45')](_0x55abb4['query'],_0x429461[_0x7914('0x3b')]),_0xdc7085);if(_0x55abb4[_0x7914('0x3a')][_0x7914('0x46')]){_0x3ca53a[_0x7914('0x44')]=_['merge'](_0x3ca53a[_0x7914('0x44')],{'$or':_[_0x7914('0x34')](_0xdc7085,function(_0x18ef87){if(_0x18ef87[_0x7914('0x37')]!==_0x7914('0x47')){var _0x188f54={};_0x188f54[_0x18ef87[_0x7914('0x31')]]={'$like':'%'+_0x55abb4['query']['filter']+'%'};return _0x188f54;}})});}_0x3ca53a=_['merge']({},_0x3ca53a,_0x55abb4[_0x7914('0x48')]);var _0x2ce4eb={'where':_0x3ca53a[_0x7914('0x44')]};return db['VtigerAccount'][_0x7914('0x27')](_0x2ce4eb)['then'](function(_0x134aeb){_0x4c96ed[_0x7914('0x27')]=_0x134aeb;if(_0x55abb4[_0x7914('0x3a')][_0x7914('0x49')]){_0x3ca53a[_0x7914('0x4a')]=[{'all':!![]}];}return db['VtigerAccount'][_0x7914('0x4b')](_0x3ca53a);})[_0x7914('0x1b')](function(_0x448ad7){_0x4c96ed[_0x7914('0x4c')]=_0x448ad7;return _0x4c96ed;})[_0x7914('0x1b')](respondWithFilteredResult(_0x35106e,_0x3ca53a))[_0x7914('0x4d')](handleError(_0x35106e,null));};exports[_0x7914('0x4e')]=function(_0x13b8b1,_0x210c3d){var _0x2397cb={'raw':![],'where':{'id':_0x13b8b1[_0x7914('0x4f')]['id']}},_0x1a1829={};_0x1a1829[_0x7914('0x3d')]=_[_0x7914('0x39')](db[_0x7914('0x35')][_0x7914('0x50')]);_0x1a1829[_0x7914('0x3a')]=_['keys'](_0x13b8b1[_0x7914('0x3a')]);_0x1a1829[_0x7914('0x3b')]=_[_0x7914('0x3c')](_0x1a1829[_0x7914('0x3d')],_0x1a1829[_0x7914('0x3a')]);_0x2397cb[_0x7914('0x3f')]=_[_0x7914('0x3c')](_0x1a1829[_0x7914('0x3d')],qs[_0x7914('0x3e')](_0x13b8b1[_0x7914('0x3a')]['fields']));_0x2397cb[_0x7914('0x3f')]=_0x2397cb[_0x7914('0x3f')][_0x7914('0x40')]?_0x2397cb[_0x7914('0x3f')]:_0x1a1829[_0x7914('0x3d')];if(_0x13b8b1[_0x7914('0x3a')][_0x7914('0x49')]){_0x2397cb[_0x7914('0x4a')]=[{'all':!![]}];}_0x2397cb=_[_0x7914('0x51')]({},_0x2397cb,_0x13b8b1['options']);return db['VtigerAccount'][_0x7914('0x52')](_0x2397cb)['then'](handleEntityNotFound(_0x210c3d,null))[_0x7914('0x1b')](respondWithResult(_0x210c3d,null))[_0x7914('0x4d')](handleError(_0x210c3d,null));};exports[_0x7914('0x53')]=function(_0x559d03,_0x1c628e){return db[_0x7914('0x35')][_0x7914('0x53')](_0x559d03['body'],{})[_0x7914('0x1b')](respondWithResult(_0x1c628e,0xc9))[_0x7914('0x4d')](handleError(_0x1c628e,null));};exports[_0x7914('0x2e')]=function(_0x393cb1,_0x2ea909){if(_0x393cb1[_0x7914('0x54')]['id']){delete _0x393cb1['body']['id'];}return db[_0x7914('0x35')]['find']({'where':{'id':_0x393cb1['params']['id']}})['then'](handleEntityNotFound(_0x2ea909,null))[_0x7914('0x1b')](saveUpdates(_0x393cb1[_0x7914('0x54')],null))[_0x7914('0x1b')](respondWithResult(_0x2ea909,null))[_0x7914('0x4d')](handleError(_0x2ea909,null));};exports[_0x7914('0x2f')]=function(_0x5f0e10,_0x1c48bc){return db[_0x7914('0x35')][_0x7914('0x52')]({'where':{'id':_0x5f0e10[_0x7914('0x4f')]['id']}})[_0x7914('0x1b')](handleEntityNotFound(_0x1c48bc,null))[_0x7914('0x1b')](removeEntity(_0x1c48bc,null))[_0x7914('0x4d')](handleError(_0x1c48bc,null));};exports[_0x7914('0x55')]=function(_0x39d277,_0x12f4ae,_0x395760){var _0x18190c={};var _0x589086={};var _0x2086d1;var _0x583a86;return db[_0x7914('0x35')]['findOne']({'where':{'id':_0x39d277[_0x7914('0x4f')]['id']}})[_0x7914('0x1b')](handleEntityNotFound(_0x12f4ae,null))[_0x7914('0x1b')](function(_0x4affbc){if(_0x4affbc){_0x2086d1=_0x4affbc;_0x589086['model']=_[_0x7914('0x39')](db[_0x7914('0x56')]['rawAttributes']);_0x589086[_0x7914('0x3a')]=_[_0x7914('0x39')](_0x39d277['query']);_0x589086[_0x7914('0x3b')]=_['intersection'](_0x589086[_0x7914('0x3d')],_0x589086[_0x7914('0x3a')]);_0x18190c[_0x7914('0x3f')]=_[_0x7914('0x3c')](_0x589086[_0x7914('0x3d')],qs[_0x7914('0x3e')](_0x39d277[_0x7914('0x3a')][_0x7914('0x3e')]));_0x18190c[_0x7914('0x3f')]=_0x18190c['attributes']['length']?_0x18190c[_0x7914('0x3f')]:_0x589086['model'];_0x18190c['order']=qs[_0x7914('0x43')](_0x39d277['query'][_0x7914('0x43')]);_0x18190c[_0x7914('0x44')]=qs[_0x7914('0x3b')](_[_0x7914('0x45')](_0x39d277[_0x7914('0x3a')],_0x589086['filters']));if(_0x39d277['query'][_0x7914('0x46')]){_0x18190c[_0x7914('0x44')]=_['merge'](_0x18190c[_0x7914('0x44')],{'$or':_['map'](_0x18190c[_0x7914('0x3f')],function(_0x2d4ec0){var _0x5477d5={};_0x5477d5[_0x2d4ec0]={'$like':'%'+_0x39d277[_0x7914('0x3a')][_0x7914('0x46')]+'%'};return _0x5477d5;})});}_0x18190c=_['merge']({},_0x18190c,_0x39d277['options']);return _0x2086d1[_0x7914('0x55')](_0x18190c);}})['then'](function(_0x4bd0c9){if(_0x4bd0c9){_0x583a86=_0x4bd0c9['length'];if(!_0x39d277[_0x7914('0x3a')][_0x7914('0x57')](_0x7914('0x41'))){_0x18190c[_0x7914('0x29')]=qs[_0x7914('0x29')](_0x39d277[_0x7914('0x3a')][_0x7914('0x29')]);_0x18190c[_0x7914('0x28')]=qs[_0x7914('0x28')](_0x39d277[_0x7914('0x3a')]['offset']);}return _0x2086d1[_0x7914('0x55')](_0x18190c);}})[_0x7914('0x1b')](function(_0x35a783){if(_0x35a783){return _0x35a783?{'count':_0x583a86,'rows':_0x35a783}:null;}})[_0x7914('0x1b')](respondWithResult(_0x12f4ae,null))['catch'](handleError(_0x12f4ae,null));};exports[_0x7914('0x58')]=function(_0x121bfa,_0x2d3b9c,_0x2c7070){if(_0x121bfa[_0x7914('0x54')]['id']){delete _0x121bfa['body']['id'];}return db[_0x7914('0x35')][_0x7914('0x59')]({'where':{'id':_0x121bfa[_0x7914('0x4f')]['id']}})[_0x7914('0x1b')](handleEntityNotFound(_0x2d3b9c,null))[_0x7914('0x1b')](function(_0x4edede){if(_0x4edede){_0x121bfa['body'][_0x7914('0x5a')]=_0x4edede['id'];_0x121bfa['body']['Subjects']=integrations['getSubjects'](_0x121bfa['body'][_0x7914('0x5b')],_0x121bfa['body'][_0x7914('0x37')]);_0x121bfa[_0x7914('0x54')][_0x7914('0x5c')]=integrations['getDescriptions'](_0x121bfa['body'][_0x7914('0x5b')],_0x121bfa[_0x7914('0x54')][_0x7914('0x37')]);return db[_0x7914('0x56')][_0x7914('0x53')](_0x121bfa[_0x7914('0x54')],{'include':[{'model':db[_0x7914('0x5d')],'as':'Subjects'},{'model':db[_0x7914('0x5d')],'as':_0x7914('0x5c')}]});}return null;})[_0x7914('0x1b')](respondWithResult(_0x2d3b9c,null))[_0x7914('0x4d')](handleError(_0x2d3b9c,null));};var md5=require(_0x7914('0x5e'));exports[_0x7914('0x5f')]=function(_0x1f552c,_0x2e7cdf,_0x584be7){var _0x9bbc55=null;var _0x3564dd=null;var _0x1e54b0=null;var _0x210b63=null;var _0x558820='';return db[_0x7914('0x35')][_0x7914('0x59')]({'where':{'id':_0x1f552c['params']['id']},'attributes':['id',_0x7914('0x31'),'username',_0x7914('0x60'),_0x7914('0x61'),_0x7914('0x62'),_0x7914('0x63'),'accessKey']})[_0x7914('0x1b')](handleEntityNotFound(_0x2e7cdf,null))[_0x7914('0x1b')](function(_0x478365){if(_0x478365){_0x9bbc55=_0x478365[_0x7914('0x64')];_0x3564dd=_0x478365[_0x7914('0x65')];_0x1e54b0=_0x478365[_0x7914('0x61')];_0x558820=_0x478365[_0x7914('0x62')];var _0x7d0a2e=_0x558820['slice'](-0x1);if(_0x7d0a2e==='/'){_0x558820=_0x558820['substring'](0x0,_0x558820[_0x7914('0x66')](_0x7d0a2e));}_0x210b63=util['format'](_0x7914('0x67'),_0x558820);var _0x34d101={'method':_0x7914('0x68'),'uri':_0x210b63,'qs':{'operation':_0x7914('0x69'),'username':_0x478365[_0x7914('0x64')]},'json':!![]};return rp(_0x34d101);}})[_0x7914('0x1b')](function(_0x192f98){if(_0x192f98[_0x7914('0x6a')]){var _0x29964f={'method':'POST','uri':_0x210b63,'form':{'operation':_0x7914('0x6b'),'username':_0x9bbc55,'accessKey':md5(_0x192f98['result'][_0x7914('0x6c')]+_0x3564dd)},'json':!![]};return rp(_0x29964f);}})['then'](function(_0x339c49){if(_0x339c49[_0x7914('0x6a')]){var _0x196d74={'method':_0x7914('0x68'),'uri':_0x210b63,'qs':{'operation':'describe','username':_0x9bbc55,'sessionName':_0x339c49[_0x7914('0x23')][_0x7914('0x6d')],'elementType':_0x1e54b0},'json':!![]};return rp(_0x196d74);}})[_0x7914('0x1b')](function(_0x2eb3cc){if(_0x2eb3cc[_0x7914('0x6a')]){var _0x39f1ba=[_0x7914('0x6e'),_0x7914('0x6f'),_0x7914('0x70')];_[_0x7914('0x71')](_0x2eb3cc['result'][_0x7914('0x3e')],function(_0x28d006){return _0x39f1ba[_0x7914('0x72')](_0x28d006[_0x7914('0x37')][_0x7914('0x31')]);});_[_0x7914('0x71')](_0x2eb3cc[_0x7914('0x23')][_0x7914('0x3e')],function(_0xae7e2f){return _0xae7e2f[_0x7914('0x73')]===_0x7914('0x74');});return{'count':_0x2eb3cc[_0x7914('0x23')][_0x7914('0x3e')][_0x7914('0x40')],'rows':_[_0x7914('0x34')](_0x2eb3cc[_0x7914('0x23')][_0x7914('0x3e')],function(_0x1ee330){return{'id':_0x1ee330[_0x7914('0x31')],'name':_0x1ee330[_0x7914('0x75')],'custom':_['startsWith'](_0x1ee330['name'],_0x7914('0x76'))?!![]:![],'options':_0x1ee330[_0x7914('0x37')][_0x7914('0x31')]==='picklist'&&_0x1ee330[_0x7914('0x37')][_0x7914('0x77')][_0x7914('0x40')]>0x0?_['map'](_0x1ee330[_0x7914('0x37')][_0x7914('0x77')],function(_0x1c0b06){return{'name':_0x1c0b06['label'],'value':_0x1c0b06['value']};}):[]};})};}})[_0x7914('0x1b')](respondWithResult(_0x2e7cdf,null))['catch'](function(_0x3f76ef){console['log'](_0x7914('0x78')+_0x3f76ef);var _0x2129a3=_0x1f552c[_0x7914('0x3a')][_0x7914('0x79')]?0x1f4:_0x3f76ef['statusCode']||0x1f4;logger[_0x7914('0x20')](_0x7914('0x7a'),_0x7914('0x5f'),_0x2129a3,JSON[_0x7914('0x7b')](_0x3f76ef));delete _0x3f76ef[_0x7914('0x31')];if(_0x2129a3===0x191){_0x2129a3=0x190;}_0x2e7cdf['status'](_0x2129a3)[_0x7914('0x32')](_0x1f552c['query'][_0x7914('0x79')]?{'message':_0x7914('0x7c'),'statusCode':_0x3f76ef[_0x7914('0x7d')]}:_0x3f76ef);});};