6be4e1e8972a6dd8f85109e7645b8cd9ff54ff6f
[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 _0x0d4b=['../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','sendStatus','end','status','json','offset','undefined','count','reject','save','then','destroy','error','stack','name','send','index','VtigerAccount','fieldName','type','map','keys','query','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','merge','VIRTUAL','catch','show','params','rawAttributes','includeAll','include','options','find','create','body','update','getConfigurations','VtigerConfiguration','addConfiguration','findOne','Subjects','getSubjects','channel','Descriptions','VtigerField','md5','getFields','username','description','moduleName','serverUrl','accessKey','remoteUri','slice','lastIndexOf','format','%s/webservice.php','GET','getchallenge','POST','login','token','success','result','owner','remove','includes','editable','false','label','startsWith','cf_','picklist','picklistValues','value','statusCode','getFields,\x20%s,\x20%s,\x20%s','test','Wrong\x20credentials','eml-format','rimraf','fast-json-patch','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils'];(function(_0x46c3f7,_0x5b474c){var _0x573934=function(_0x5ce446){while(--_0x5ce446){_0x46c3f7['push'](_0x46c3f7['shift']());}};_0x573934(++_0x5b474c);}(_0x0d4b,0xd6));var _0xb0d4=function(_0x6c993a,_0x5ea3ab){_0x6c993a=_0x6c993a-0x0;var _0x27f547=_0x0d4b[_0x6c993a];return _0x27f547;};'use strict';var emlformat=require(_0xb0d4('0x0'));var rimraf=require(_0xb0d4('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xb0d4('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xb0d4('0x3'));var Mustache=require(_0xb0d4('0x4'));var util=require('util');var path=require(_0xb0d4('0x5'));var sox=require(_0xb0d4('0x6'));var csv=require(_0xb0d4('0x7'));var ejs=require(_0xb0d4('0x8'));var fs=require('fs');var fs_extra=require(_0xb0d4('0x9'));var _=require(_0xb0d4('0xa'));var squel=require(_0xb0d4('0xb'));var crypto=require(_0xb0d4('0xc'));var jsforce=require(_0xb0d4('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xb0d4('0x7'));var querystring=require(_0xb0d4('0xe'));var Papa=require(_0xb0d4('0xf'));var Redis=require(_0xb0d4('0x10'));var authService=require('../../components/auth/service');var qs=require(_0xb0d4('0x11'));var as=require(_0xb0d4('0x12'));var hardwareService=require(_0xb0d4('0x13'));var logger=require('../../config/logger')(_0xb0d4('0x14'));var utils=require(_0xb0d4('0x15'));var config=require(_0xb0d4('0x16'));var licenseUtil=require(_0xb0d4('0x17'));var db=require(_0xb0d4('0x18'))['db'];var integrations=require(_0xb0d4('0x19'));function respondWithStatusCode(_0x48ce71,_0x4ffa79){_0x4ffa79=_0x4ffa79||0xcc;return function(_0x3143f2){if(_0x3143f2){return _0x48ce71[_0xb0d4('0x1a')](_0x4ffa79);}return _0x48ce71['status'](_0x4ffa79)[_0xb0d4('0x1b')]();};}function respondWithResult(_0x181214,_0x22b84c){_0x22b84c=_0x22b84c||0xc8;return function(_0x3e67dd){if(_0x3e67dd){return _0x181214[_0xb0d4('0x1c')](_0x22b84c)[_0xb0d4('0x1d')](_0x3e67dd);}};}function respondWithFilteredResult(_0x3f0a5e,_0x10e7aa){return function(_0x1c9ceb){if(_0x1c9ceb){var _0x540707=typeof _0x10e7aa[_0xb0d4('0x1e')]===_0xb0d4('0x1f')&&typeof _0x10e7aa['limit']===_0xb0d4('0x1f');var _0x1cf078=_0x1c9ceb[_0xb0d4('0x20')];var _0x395836=_0x540707?0x0:_0x10e7aa[_0xb0d4('0x1e')];var _0x3e72ee=_0x540707?_0x1c9ceb[_0xb0d4('0x20')]:_0x10e7aa[_0xb0d4('0x1e')]+_0x10e7aa['limit'];var _0x582ea5;if(_0x3e72ee>=_0x1cf078){_0x3e72ee=_0x1cf078;_0x582ea5=0xc8;}else{_0x582ea5=0xce;}_0x3f0a5e['status'](_0x582ea5);return _0x3f0a5e['set']('Content-Range',_0x395836+'-'+_0x3e72ee+'/'+_0x1cf078)[_0xb0d4('0x1d')](_0x1c9ceb);}return null;};}function patchUpdates(_0x2f2d84){return function(_0x1e9d38){try{jsonpatch['apply'](_0x1e9d38,_0x2f2d84,!![]);}catch(_0x38c971){return BPromise[_0xb0d4('0x21')](_0x38c971);}return _0x1e9d38[_0xb0d4('0x22')]();};}function saveUpdates(_0x4599c4,_0x51f7ba){return function(_0x5c610f){if(_0x5c610f){return _0x5c610f['update'](_0x4599c4)[_0xb0d4('0x23')](function(_0x191797){return _0x191797;});}return null;};}function removeEntity(_0x183a02,_0x2fb055){return function(_0xd36b28){if(_0xd36b28){return _0xd36b28[_0xb0d4('0x24')]()[_0xb0d4('0x23')](function(){_0x183a02[_0xb0d4('0x1c')](0xcc)[_0xb0d4('0x1b')]();});}};}function handleEntityNotFound(_0x463608,_0x3dfba7){return function(_0x2cf0c4){if(!_0x2cf0c4){_0x463608[_0xb0d4('0x1a')](0x194);}return _0x2cf0c4;};}function handleError(_0x15a2b9,_0x2b5cfa){_0x2b5cfa=_0x2b5cfa||0x1f4;return function(_0x46242d){logger[_0xb0d4('0x25')](_0x46242d[_0xb0d4('0x26')]);if(_0x46242d[_0xb0d4('0x27')]){delete _0x46242d[_0xb0d4('0x27')];}_0x15a2b9['status'](_0x2b5cfa)[_0xb0d4('0x28')](_0x46242d);};}exports[_0xb0d4('0x29')]=function(_0x35a810,_0x19bea6){var _0x312598={},_0x3b4d0f={},_0x31576b={'count':0x0,'rows':[]};var _0x4cf14b=_['map'](db[_0xb0d4('0x2a')]['rawAttributes'],function(_0x368ae1){return{'name':_0x368ae1[_0xb0d4('0x2b')],'type':_0x368ae1[_0xb0d4('0x2c')]['key']};});_0x3b4d0f['model']=_[_0xb0d4('0x2d')](_0x4cf14b,_0xb0d4('0x27'));_0x3b4d0f['query']=_[_0xb0d4('0x2e')](_0x35a810[_0xb0d4('0x2f')]);_0x3b4d0f[_0xb0d4('0x30')]=_[_0xb0d4('0x31')](_0x3b4d0f[_0xb0d4('0x32')],_0x3b4d0f[_0xb0d4('0x2f')]);_0x312598[_0xb0d4('0x33')]=_[_0xb0d4('0x31')](_0x3b4d0f[_0xb0d4('0x32')],qs[_0xb0d4('0x34')](_0x35a810[_0xb0d4('0x2f')][_0xb0d4('0x34')]));_0x312598[_0xb0d4('0x33')]=_0x312598[_0xb0d4('0x33')][_0xb0d4('0x35')]?_0x312598[_0xb0d4('0x33')]:_0x3b4d0f[_0xb0d4('0x32')];if(!_0x35a810[_0xb0d4('0x2f')][_0xb0d4('0x36')](_0xb0d4('0x37'))){_0x312598['limit']=qs[_0xb0d4('0x38')](_0x35a810[_0xb0d4('0x2f')][_0xb0d4('0x38')]);_0x312598[_0xb0d4('0x1e')]=qs['offset'](_0x35a810[_0xb0d4('0x2f')][_0xb0d4('0x1e')]);}_0x312598[_0xb0d4('0x39')]=qs[_0xb0d4('0x3a')](_0x35a810[_0xb0d4('0x2f')][_0xb0d4('0x3a')]);_0x312598[_0xb0d4('0x3b')]=qs[_0xb0d4('0x30')](_[_0xb0d4('0x3c')](_0x35a810['query'],_0x3b4d0f[_0xb0d4('0x30')]),_0x4cf14b);if(_0x35a810['query'][_0xb0d4('0x3d')]){_0x312598[_0xb0d4('0x3b')]=_[_0xb0d4('0x3e')](_0x312598[_0xb0d4('0x3b')],{'$or':_[_0xb0d4('0x2d')](_0x4cf14b,function(_0x27e3c0){if(_0x27e3c0[_0xb0d4('0x2c')]!==_0xb0d4('0x3f')){var _0x3d258c={};_0x3d258c[_0x27e3c0[_0xb0d4('0x27')]]={'$like':'%'+_0x35a810['query'][_0xb0d4('0x3d')]+'%'};return _0x3d258c;}})});}_0x312598=_[_0xb0d4('0x3e')]({},_0x312598,_0x35a810['options']);var _0x5f3335={'where':_0x312598[_0xb0d4('0x3b')]};return db['VtigerAccount']['count'](_0x5f3335)[_0xb0d4('0x23')](function(_0x586123){_0x31576b[_0xb0d4('0x20')]=_0x586123;if(_0x35a810[_0xb0d4('0x2f')]['includeAll']){_0x312598['include']=[{'all':!![]}];}return db[_0xb0d4('0x2a')]['findAll'](_0x312598);})[_0xb0d4('0x23')](function(_0x22bbcd){_0x31576b['rows']=_0x22bbcd;return _0x31576b;})['then'](respondWithFilteredResult(_0x19bea6,_0x312598))[_0xb0d4('0x40')](handleError(_0x19bea6,null));};exports[_0xb0d4('0x41')]=function(_0x49b645,_0x423d5d){var _0x4b3062={'raw':![],'where':{'id':_0x49b645[_0xb0d4('0x42')]['id']}},_0xe3bd35={};_0xe3bd35[_0xb0d4('0x32')]=_[_0xb0d4('0x2e')](db[_0xb0d4('0x2a')][_0xb0d4('0x43')]);_0xe3bd35[_0xb0d4('0x2f')]=_[_0xb0d4('0x2e')](_0x49b645[_0xb0d4('0x2f')]);_0xe3bd35['filters']=_[_0xb0d4('0x31')](_0xe3bd35[_0xb0d4('0x32')],_0xe3bd35['query']);_0x4b3062['attributes']=_[_0xb0d4('0x31')](_0xe3bd35[_0xb0d4('0x32')],qs['fields'](_0x49b645[_0xb0d4('0x2f')][_0xb0d4('0x34')]));_0x4b3062[_0xb0d4('0x33')]=_0x4b3062['attributes'][_0xb0d4('0x35')]?_0x4b3062[_0xb0d4('0x33')]:_0xe3bd35[_0xb0d4('0x32')];if(_0x49b645['query'][_0xb0d4('0x44')]){_0x4b3062[_0xb0d4('0x45')]=[{'all':!![]}];}_0x4b3062=_[_0xb0d4('0x3e')]({},_0x4b3062,_0x49b645[_0xb0d4('0x46')]);return db[_0xb0d4('0x2a')][_0xb0d4('0x47')](_0x4b3062)[_0xb0d4('0x23')](handleEntityNotFound(_0x423d5d,null))[_0xb0d4('0x23')](respondWithResult(_0x423d5d,null))[_0xb0d4('0x40')](handleError(_0x423d5d,null));};exports[_0xb0d4('0x48')]=function(_0x2c7013,_0x5d7e9b){return db[_0xb0d4('0x2a')][_0xb0d4('0x48')](_0x2c7013[_0xb0d4('0x49')],{})[_0xb0d4('0x23')](respondWithResult(_0x5d7e9b,0xc9))[_0xb0d4('0x40')](handleError(_0x5d7e9b,null));};exports[_0xb0d4('0x4a')]=function(_0x4d1181,_0x46c3af){if(_0x4d1181[_0xb0d4('0x49')]['id']){delete _0x4d1181[_0xb0d4('0x49')]['id'];}return db[_0xb0d4('0x2a')][_0xb0d4('0x47')]({'where':{'id':_0x4d1181[_0xb0d4('0x42')]['id']}})[_0xb0d4('0x23')](handleEntityNotFound(_0x46c3af,null))['then'](saveUpdates(_0x4d1181[_0xb0d4('0x49')],null))[_0xb0d4('0x23')](respondWithResult(_0x46c3af,null))['catch'](handleError(_0x46c3af,null));};exports['destroy']=function(_0x1673af,_0x479dee){return db[_0xb0d4('0x2a')][_0xb0d4('0x47')]({'where':{'id':_0x1673af[_0xb0d4('0x42')]['id']}})[_0xb0d4('0x23')](handleEntityNotFound(_0x479dee,null))['then'](removeEntity(_0x479dee,null))['catch'](handleError(_0x479dee,null));};exports[_0xb0d4('0x4b')]=function(_0x10d382,_0x3f2f6c,_0x221052){var _0x11cfc4={};var _0x595e45={};var _0x525e1b;var _0x58a4c5;return db['VtigerAccount']['findOne']({'where':{'id':_0x10d382[_0xb0d4('0x42')]['id']}})[_0xb0d4('0x23')](handleEntityNotFound(_0x3f2f6c,null))[_0xb0d4('0x23')](function(_0x3d72f1){if(_0x3d72f1){_0x525e1b=_0x3d72f1;_0x595e45[_0xb0d4('0x32')]=_[_0xb0d4('0x2e')](db[_0xb0d4('0x4c')]['rawAttributes']);_0x595e45['query']=_['keys'](_0x10d382[_0xb0d4('0x2f')]);_0x595e45['filters']=_['intersection'](_0x595e45['model'],_0x595e45[_0xb0d4('0x2f')]);_0x11cfc4[_0xb0d4('0x33')]=_[_0xb0d4('0x31')](_0x595e45[_0xb0d4('0x32')],qs[_0xb0d4('0x34')](_0x10d382[_0xb0d4('0x2f')]['fields']));_0x11cfc4[_0xb0d4('0x33')]=_0x11cfc4[_0xb0d4('0x33')][_0xb0d4('0x35')]?_0x11cfc4['attributes']:_0x595e45[_0xb0d4('0x32')];_0x11cfc4[_0xb0d4('0x39')]=qs[_0xb0d4('0x3a')](_0x10d382[_0xb0d4('0x2f')][_0xb0d4('0x3a')]);_0x11cfc4[_0xb0d4('0x3b')]=qs[_0xb0d4('0x30')](_[_0xb0d4('0x3c')](_0x10d382[_0xb0d4('0x2f')],_0x595e45[_0xb0d4('0x30')]));if(_0x10d382[_0xb0d4('0x2f')][_0xb0d4('0x3d')]){_0x11cfc4['where']=_['merge'](_0x11cfc4[_0xb0d4('0x3b')],{'$or':_[_0xb0d4('0x2d')](_0x11cfc4[_0xb0d4('0x33')],function(_0xa305bf){var _0x24904a={};_0x24904a[_0xa305bf]={'$like':'%'+_0x10d382['query'][_0xb0d4('0x3d')]+'%'};return _0x24904a;})});}_0x11cfc4=_[_0xb0d4('0x3e')]({},_0x11cfc4,_0x10d382[_0xb0d4('0x46')]);return _0x525e1b[_0xb0d4('0x4b')](_0x11cfc4);}})[_0xb0d4('0x23')](function(_0x58db16){if(_0x58db16){_0x58a4c5=_0x58db16[_0xb0d4('0x35')];if(!_0x10d382[_0xb0d4('0x2f')][_0xb0d4('0x36')](_0xb0d4('0x37'))){_0x11cfc4[_0xb0d4('0x38')]=qs[_0xb0d4('0x38')](_0x10d382['query'][_0xb0d4('0x38')]);_0x11cfc4[_0xb0d4('0x1e')]=qs[_0xb0d4('0x1e')](_0x10d382['query'][_0xb0d4('0x1e')]);}return _0x525e1b[_0xb0d4('0x4b')](_0x11cfc4);}})[_0xb0d4('0x23')](function(_0x2fe09a){if(_0x2fe09a){return _0x2fe09a?{'count':_0x58a4c5,'rows':_0x2fe09a}:null;}})[_0xb0d4('0x23')](respondWithResult(_0x3f2f6c,null))[_0xb0d4('0x40')](handleError(_0x3f2f6c,null));};exports[_0xb0d4('0x4d')]=function(_0x40d384,_0x44ccaf,_0x534705){if(_0x40d384[_0xb0d4('0x49')]['id']){delete _0x40d384[_0xb0d4('0x49')]['id'];}return db[_0xb0d4('0x2a')][_0xb0d4('0x4e')]({'where':{'id':_0x40d384[_0xb0d4('0x42')]['id']}})[_0xb0d4('0x23')](handleEntityNotFound(_0x44ccaf,null))['then'](function(_0x78595a){if(_0x78595a){_0x40d384[_0xb0d4('0x49')]['AccountId']=_0x78595a['id'];_0x40d384['body'][_0xb0d4('0x4f')]=integrations[_0xb0d4('0x50')](_0x40d384[_0xb0d4('0x49')][_0xb0d4('0x51')],_0x40d384[_0xb0d4('0x49')][_0xb0d4('0x2c')]);_0x40d384['body'][_0xb0d4('0x52')]=integrations['getDescriptions'](_0x40d384['body'][_0xb0d4('0x51')],_0x40d384[_0xb0d4('0x49')][_0xb0d4('0x2c')]);return db[_0xb0d4('0x4c')]['create'](_0x40d384['body'],{'include':[{'model':db[_0xb0d4('0x53')],'as':_0xb0d4('0x4f')},{'model':db[_0xb0d4('0x53')],'as':'Descriptions'}]});}return null;})[_0xb0d4('0x23')](respondWithResult(_0x44ccaf,null))[_0xb0d4('0x40')](handleError(_0x44ccaf,null));};var md5=require(_0xb0d4('0x54'));exports[_0xb0d4('0x55')]=function(_0x5afd0d,_0xac4886,_0x45a7f1){var _0x16c709=null;var _0x36a1ad=null;var _0x290bd7=null;var _0x3e6854=null;var _0x6a8dea='';return db['VtigerAccount'][_0xb0d4('0x4e')]({'where':{'id':_0x5afd0d[_0xb0d4('0x42')]['id']},'attributes':['id',_0xb0d4('0x27'),_0xb0d4('0x56'),_0xb0d4('0x57'),_0xb0d4('0x58'),'remoteUri',_0xb0d4('0x59'),_0xb0d4('0x5a')]})['then'](handleEntityNotFound(_0xac4886,null))[_0xb0d4('0x23')](function(_0x36a22f){if(_0x36a22f){_0x16c709=_0x36a22f[_0xb0d4('0x56')];_0x36a1ad=_0x36a22f[_0xb0d4('0x5a')];_0x290bd7=_0x36a22f[_0xb0d4('0x58')];_0x6a8dea=_0x36a22f[_0xb0d4('0x5b')];var _0x3cc688=_0x6a8dea[_0xb0d4('0x5c')](-0x1);if(_0x3cc688==='/'){_0x6a8dea=_0x6a8dea['substring'](0x0,_0x6a8dea[_0xb0d4('0x5d')](_0x3cc688));}_0x3e6854=util[_0xb0d4('0x5e')](_0xb0d4('0x5f'),_0x6a8dea);var _0x4e62a6={'method':_0xb0d4('0x60'),'uri':_0x3e6854,'qs':{'operation':_0xb0d4('0x61'),'username':_0x36a22f[_0xb0d4('0x56')]},'json':!![]};return rp(_0x4e62a6);}})[_0xb0d4('0x23')](function(_0x5493c3){if(_0x5493c3['success']){var _0x54a638={'method':_0xb0d4('0x62'),'uri':_0x3e6854,'form':{'operation':_0xb0d4('0x63'),'username':_0x16c709,'accessKey':md5(_0x5493c3['result'][_0xb0d4('0x64')]+_0x36a1ad)},'json':!![]};return rp(_0x54a638);}})[_0xb0d4('0x23')](function(_0x4759d5){if(_0x4759d5[_0xb0d4('0x65')]){var _0x4668a7={'method':_0xb0d4('0x60'),'uri':_0x3e6854,'qs':{'operation':'describe','username':_0x16c709,'sessionName':_0x4759d5[_0xb0d4('0x66')]['sessionName'],'elementType':_0x290bd7},'json':!![]};return rp(_0x4668a7);}})[_0xb0d4('0x23')](function(_0x2acc1b){if(_0x2acc1b[_0xb0d4('0x65')]){var _0x5976de=['autogenerated','reference',_0xb0d4('0x67')];_[_0xb0d4('0x68')](_0x2acc1b[_0xb0d4('0x66')][_0xb0d4('0x34')],function(_0x1741d0){return _0x5976de[_0xb0d4('0x69')](_0x1741d0['type']['name']);});_[_0xb0d4('0x68')](_0x2acc1b[_0xb0d4('0x66')][_0xb0d4('0x34')],function(_0x2cd1f8){return _0x2cd1f8[_0xb0d4('0x6a')]===_0xb0d4('0x6b');});return{'count':_0x2acc1b[_0xb0d4('0x66')]['fields']['length'],'rows':_[_0xb0d4('0x2d')](_0x2acc1b[_0xb0d4('0x66')][_0xb0d4('0x34')],function(_0x2d45cb){return{'id':_0x2d45cb[_0xb0d4('0x27')],'name':_0x2d45cb[_0xb0d4('0x6c')],'custom':_[_0xb0d4('0x6d')](_0x2d45cb[_0xb0d4('0x27')],_0xb0d4('0x6e'))?!![]:![],'options':_0x2d45cb['type'][_0xb0d4('0x27')]===_0xb0d4('0x6f')&&_0x2d45cb[_0xb0d4('0x2c')][_0xb0d4('0x70')][_0xb0d4('0x35')]>0x0?_['map'](_0x2d45cb[_0xb0d4('0x2c')][_0xb0d4('0x70')],function(_0x5a9cbd){return{'name':_0x5a9cbd[_0xb0d4('0x6c')],'value':_0x5a9cbd[_0xb0d4('0x71')]};}):[]};})};}})[_0xb0d4('0x23')](respondWithResult(_0xac4886,null))[_0xb0d4('0x40')](function(_0xf601d1){console['log']('vTiger\x20error:\x20'+_0xf601d1);var _0x56ade1=_0x5afd0d[_0xb0d4('0x2f')]['test']?0x1f4:_0xf601d1[_0xb0d4('0x72')]||0x1f4;logger[_0xb0d4('0x25')](_0xb0d4('0x73'),_0xb0d4('0x55'),_0x56ade1,JSON['stringify'](_0xf601d1));delete _0xf601d1['name'];if(_0x56ade1===0x191){_0x56ade1=0x190;}_0xac4886['status'](_0x56ade1)[_0xb0d4('0x28')](_0x5afd0d[_0xb0d4('0x2f')][_0xb0d4('0x74')]?{'message':_0xb0d4('0x75'),'statusCode':_0xf601d1[_0xb0d4('0x72')]}:_0xf601d1);});};