Built motion from commit 3e059bc2.|2.5.32
[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 _0xdd02=['util','path','sox','to-csv','fs-extra','lodash','squel','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','status','end','json','offset','undefined','limit','count','set','Content-Range','save','update','then','destroy','sendStatus','error','stack','name','map','VtigerAccount','rawAttributes','model','keys','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','where','filter','merge','type','VIRTUAL','includeAll','include','findAll','catch','show','params','options','find','create','body','getConfigurations','findOne','VtigerConfiguration','order','pick','addConfiguration','AccountId','getSubjects','Descriptions','getDescriptions','channel','VtigerField','Subjects','getFields','username','description','moduleName','remoteUri','accessKey','slice','substring','format','GET','getchallenge','success','login','result','token','describe','autogenerated','reference','owner','remove','includes','false','label','cf_','picklist','picklistValues','value','log','test','statusCode','getFields,\x20%s,\x20%s,\x20%s','stringify','send','Wrong\x20credentials','eml-format','zip-dir','fast-json-patch','mustache'];(function(_0x2dafbe,_0x5d04de){var _0x58a45a=function(_0x50ac96){while(--_0x50ac96){_0x2dafbe['push'](_0x2dafbe['shift']());}};_0x58a45a(++_0x5d04de);}(_0xdd02,0x71));var _0x2dd0=function(_0x486348,_0x59d0cd){_0x486348=_0x486348-0x0;var _0x2ca3fd=_0xdd02[_0x486348];return _0x2ca3fd;};'use strict';var emlformat=require(_0x2dd0('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x2dd0('0x1'));var jsonpatch=require(_0x2dd0('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x2dd0('0x3'));var util=require(_0x2dd0('0x4'));var path=require(_0x2dd0('0x5'));var sox=require(_0x2dd0('0x6'));var csv=require(_0x2dd0('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x2dd0('0x8'));var _=require(_0x2dd0('0x9'));var squel=require(_0x2dd0('0xa'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x2dd0('0xb'));var toCsv=require('to-csv');var querystring=require(_0x2dd0('0xc'));var Papa=require(_0x2dd0('0xd'));var Redis=require(_0x2dd0('0xe'));var authService=require(_0x2dd0('0xf'));var qs=require(_0x2dd0('0x10'));var as=require(_0x2dd0('0x11'));var hardwareService=require(_0x2dd0('0x12'));var logger=require('../../config/logger')('api');var utils=require(_0x2dd0('0x13'));var config=require(_0x2dd0('0x14'));var licenseUtil=require(_0x2dd0('0x15'));var db=require(_0x2dd0('0x16'))['db'];var integrations=require(_0x2dd0('0x17'));function respondWithStatusCode(_0x5a37ba,_0x1e0e11){_0x1e0e11=_0x1e0e11||0xcc;return function(_0xdba658){if(_0xdba658){return _0x5a37ba['sendStatus'](_0x1e0e11);}return _0x5a37ba[_0x2dd0('0x18')](_0x1e0e11)[_0x2dd0('0x19')]();};}function respondWithResult(_0xc597a4,_0x5473d4){_0x5473d4=_0x5473d4||0xc8;return function(_0x45238b){if(_0x45238b){return _0xc597a4['status'](_0x5473d4)[_0x2dd0('0x1a')](_0x45238b);}};}function respondWithFilteredResult(_0x1def14,_0x4c62de){return function(_0x56017c){if(_0x56017c){var _0x529b0e=typeof _0x4c62de[_0x2dd0('0x1b')]===_0x2dd0('0x1c')&&typeof _0x4c62de[_0x2dd0('0x1d')]===_0x2dd0('0x1c');var _0x4a7f81=_0x56017c[_0x2dd0('0x1e')];var _0x1d3dd0=_0x529b0e?0x0:_0x4c62de[_0x2dd0('0x1b')];var _0x8c6b77=_0x529b0e?_0x56017c[_0x2dd0('0x1e')]:_0x4c62de[_0x2dd0('0x1b')]+_0x4c62de[_0x2dd0('0x1d')];var _0x572b33;if(_0x8c6b77>=_0x4a7f81){_0x8c6b77=_0x4a7f81;_0x572b33=0xc8;}else{_0x572b33=0xce;}_0x1def14[_0x2dd0('0x18')](_0x572b33);return _0x1def14[_0x2dd0('0x1f')](_0x2dd0('0x20'),_0x1d3dd0+'-'+_0x8c6b77+'/'+_0x4a7f81)[_0x2dd0('0x1a')](_0x56017c);}return null;};}function patchUpdates(_0x27e0ae){return function(_0xed1cf4){try{jsonpatch['apply'](_0xed1cf4,_0x27e0ae,!![]);}catch(_0x354b82){return BPromise['reject'](_0x354b82);}return _0xed1cf4[_0x2dd0('0x21')]();};}function saveUpdates(_0x162a7a,_0x1839e0){return function(_0x391c41){if(_0x391c41){return _0x391c41[_0x2dd0('0x22')](_0x162a7a)[_0x2dd0('0x23')](function(_0x5c754a){return _0x5c754a;});}return null;};}function removeEntity(_0x2ea02c,_0x2fc10d){return function(_0xbb6544){if(_0xbb6544){return _0xbb6544[_0x2dd0('0x24')]()[_0x2dd0('0x23')](function(){_0x2ea02c['status'](0xcc)[_0x2dd0('0x19')]();});}};}function handleEntityNotFound(_0x19ed4e,_0x57224d){return function(_0x5b5c0e){if(!_0x5b5c0e){_0x19ed4e[_0x2dd0('0x25')](0x194);}return _0x5b5c0e;};}function handleError(_0x5a40f0,_0x5c91fb){_0x5c91fb=_0x5c91fb||0x1f4;return function(_0x5728a3){logger[_0x2dd0('0x26')](_0x5728a3[_0x2dd0('0x27')]);if(_0x5728a3[_0x2dd0('0x28')]){delete _0x5728a3[_0x2dd0('0x28')];}_0x5a40f0[_0x2dd0('0x18')](_0x5c91fb)['send'](_0x5728a3);};}exports['index']=function(_0x3a0d90,_0x173210){var _0x2dc190={},_0x51ea08={},_0x2c28cd={'count':0x0,'rows':[]};var _0x3affc4=_[_0x2dd0('0x29')](db[_0x2dd0('0x2a')][_0x2dd0('0x2b')],function(_0x11ec9b){return{'name':_0x11ec9b['fieldName'],'type':_0x11ec9b['type']['key']};});_0x51ea08[_0x2dd0('0x2c')]=_[_0x2dd0('0x29')](_0x3affc4,_0x2dd0('0x28'));_0x51ea08['query']=_[_0x2dd0('0x2d')](_0x3a0d90[_0x2dd0('0x2e')]);_0x51ea08[_0x2dd0('0x2f')]=_[_0x2dd0('0x30')](_0x51ea08[_0x2dd0('0x2c')],_0x51ea08['query']);_0x2dc190['attributes']=_[_0x2dd0('0x30')](_0x51ea08[_0x2dd0('0x2c')],qs[_0x2dd0('0x31')](_0x3a0d90[_0x2dd0('0x2e')][_0x2dd0('0x31')]));_0x2dc190['attributes']=_0x2dc190[_0x2dd0('0x32')][_0x2dd0('0x33')]?_0x2dc190[_0x2dd0('0x32')]:_0x51ea08[_0x2dd0('0x2c')];if(!_0x3a0d90[_0x2dd0('0x2e')][_0x2dd0('0x34')](_0x2dd0('0x35'))){_0x2dc190[_0x2dd0('0x1d')]=qs[_0x2dd0('0x1d')](_0x3a0d90[_0x2dd0('0x2e')]['limit']);_0x2dc190[_0x2dd0('0x1b')]=qs[_0x2dd0('0x1b')](_0x3a0d90[_0x2dd0('0x2e')][_0x2dd0('0x1b')]);}_0x2dc190['order']=qs[_0x2dd0('0x36')](_0x3a0d90['query'][_0x2dd0('0x36')]);_0x2dc190[_0x2dd0('0x37')]=qs['filters'](_['pick'](_0x3a0d90[_0x2dd0('0x2e')],_0x51ea08[_0x2dd0('0x2f')]),_0x3affc4);if(_0x3a0d90[_0x2dd0('0x2e')][_0x2dd0('0x38')]){_0x2dc190[_0x2dd0('0x37')]=_[_0x2dd0('0x39')](_0x2dc190[_0x2dd0('0x37')],{'$or':_[_0x2dd0('0x29')](_0x3affc4,function(_0x45902c){if(_0x45902c[_0x2dd0('0x3a')]!==_0x2dd0('0x3b')){var _0x538304={};_0x538304[_0x45902c[_0x2dd0('0x28')]]={'$like':'%'+_0x3a0d90[_0x2dd0('0x2e')][_0x2dd0('0x38')]+'%'};return _0x538304;}})});}_0x2dc190=_[_0x2dd0('0x39')]({},_0x2dc190,_0x3a0d90['options']);var _0x51a2ce={'where':_0x2dc190[_0x2dd0('0x37')]};return db[_0x2dd0('0x2a')][_0x2dd0('0x1e')](_0x51a2ce)[_0x2dd0('0x23')](function(_0x234070){_0x2c28cd[_0x2dd0('0x1e')]=_0x234070;if(_0x3a0d90[_0x2dd0('0x2e')][_0x2dd0('0x3c')]){_0x2dc190[_0x2dd0('0x3d')]=[{'all':!![]}];}return db[_0x2dd0('0x2a')][_0x2dd0('0x3e')](_0x2dc190);})[_0x2dd0('0x23')](function(_0x4e6829){_0x2c28cd['rows']=_0x4e6829;return _0x2c28cd;})[_0x2dd0('0x23')](respondWithFilteredResult(_0x173210,_0x2dc190))[_0x2dd0('0x3f')](handleError(_0x173210,null));};exports[_0x2dd0('0x40')]=function(_0x32adda,_0x521c97){var _0x3475d7={'raw':![],'where':{'id':_0x32adda[_0x2dd0('0x41')]['id']}},_0x3394a2={};_0x3394a2[_0x2dd0('0x2c')]=_[_0x2dd0('0x2d')](db['VtigerAccount'][_0x2dd0('0x2b')]);_0x3394a2[_0x2dd0('0x2e')]=_[_0x2dd0('0x2d')](_0x32adda[_0x2dd0('0x2e')]);_0x3394a2[_0x2dd0('0x2f')]=_[_0x2dd0('0x30')](_0x3394a2[_0x2dd0('0x2c')],_0x3394a2[_0x2dd0('0x2e')]);_0x3475d7[_0x2dd0('0x32')]=_[_0x2dd0('0x30')](_0x3394a2[_0x2dd0('0x2c')],qs[_0x2dd0('0x31')](_0x32adda['query'][_0x2dd0('0x31')]));_0x3475d7[_0x2dd0('0x32')]=_0x3475d7[_0x2dd0('0x32')][_0x2dd0('0x33')]?_0x3475d7[_0x2dd0('0x32')]:_0x3394a2[_0x2dd0('0x2c')];if(_0x32adda['query'][_0x2dd0('0x3c')]){_0x3475d7[_0x2dd0('0x3d')]=[{'all':!![]}];}_0x3475d7=_[_0x2dd0('0x39')]({},_0x3475d7,_0x32adda[_0x2dd0('0x42')]);return db[_0x2dd0('0x2a')][_0x2dd0('0x43')](_0x3475d7)[_0x2dd0('0x23')](handleEntityNotFound(_0x521c97,null))[_0x2dd0('0x23')](respondWithResult(_0x521c97,null))['catch'](handleError(_0x521c97,null));};exports['create']=function(_0x773c81,_0x156926){return db[_0x2dd0('0x2a')][_0x2dd0('0x44')](_0x773c81[_0x2dd0('0x45')],{})[_0x2dd0('0x23')](respondWithResult(_0x156926,0xc9))[_0x2dd0('0x3f')](handleError(_0x156926,null));};exports[_0x2dd0('0x22')]=function(_0x58175b,_0x1f8cd8){if(_0x58175b[_0x2dd0('0x45')]['id']){delete _0x58175b[_0x2dd0('0x45')]['id'];}return db[_0x2dd0('0x2a')][_0x2dd0('0x43')]({'where':{'id':_0x58175b[_0x2dd0('0x41')]['id']}})[_0x2dd0('0x23')](handleEntityNotFound(_0x1f8cd8,null))['then'](saveUpdates(_0x58175b['body'],null))['then'](respondWithResult(_0x1f8cd8,null))['catch'](handleError(_0x1f8cd8,null));};exports[_0x2dd0('0x24')]=function(_0x407a1a,_0x45ac23){return db['VtigerAccount'][_0x2dd0('0x43')]({'where':{'id':_0x407a1a[_0x2dd0('0x41')]['id']}})[_0x2dd0('0x23')](handleEntityNotFound(_0x45ac23,null))[_0x2dd0('0x23')](removeEntity(_0x45ac23,null))[_0x2dd0('0x3f')](handleError(_0x45ac23,null));};exports[_0x2dd0('0x46')]=function(_0x3aee5f,_0x7b8e2d,_0x2ee065){var _0x1849d2={};var _0x386d54={};var _0x35dbb6;var _0x41fbef;return db[_0x2dd0('0x2a')][_0x2dd0('0x47')]({'where':{'id':_0x3aee5f[_0x2dd0('0x41')]['id']}})[_0x2dd0('0x23')](handleEntityNotFound(_0x7b8e2d,null))[_0x2dd0('0x23')](function(_0x329098){if(_0x329098){_0x35dbb6=_0x329098;_0x386d54[_0x2dd0('0x2c')]=_[_0x2dd0('0x2d')](db[_0x2dd0('0x48')][_0x2dd0('0x2b')]);_0x386d54[_0x2dd0('0x2e')]=_[_0x2dd0('0x2d')](_0x3aee5f[_0x2dd0('0x2e')]);_0x386d54[_0x2dd0('0x2f')]=_[_0x2dd0('0x30')](_0x386d54['model'],_0x386d54[_0x2dd0('0x2e')]);_0x1849d2[_0x2dd0('0x32')]=_[_0x2dd0('0x30')](_0x386d54[_0x2dd0('0x2c')],qs['fields'](_0x3aee5f[_0x2dd0('0x2e')]['fields']));_0x1849d2[_0x2dd0('0x32')]=_0x1849d2[_0x2dd0('0x32')][_0x2dd0('0x33')]?_0x1849d2[_0x2dd0('0x32')]:_0x386d54[_0x2dd0('0x2c')];_0x1849d2[_0x2dd0('0x49')]=qs['sort'](_0x3aee5f[_0x2dd0('0x2e')]['sort']);_0x1849d2[_0x2dd0('0x37')]=qs[_0x2dd0('0x2f')](_[_0x2dd0('0x4a')](_0x3aee5f['query'],_0x386d54[_0x2dd0('0x2f')]));if(_0x3aee5f[_0x2dd0('0x2e')][_0x2dd0('0x38')]){_0x1849d2['where']=_[_0x2dd0('0x39')](_0x1849d2[_0x2dd0('0x37')],{'$or':_[_0x2dd0('0x29')](_0x1849d2['attributes'],function(_0x4a1ef6){var _0x494552={};_0x494552[_0x4a1ef6]={'$like':'%'+_0x3aee5f[_0x2dd0('0x2e')][_0x2dd0('0x38')]+'%'};return _0x494552;})});}_0x1849d2=_[_0x2dd0('0x39')]({},_0x1849d2,_0x3aee5f[_0x2dd0('0x42')]);return _0x35dbb6[_0x2dd0('0x46')](_0x1849d2);}})[_0x2dd0('0x23')](function(_0x48125c){if(_0x48125c){_0x41fbef=_0x48125c['length'];if(!_0x3aee5f['query'][_0x2dd0('0x34')](_0x2dd0('0x35'))){_0x1849d2[_0x2dd0('0x1d')]=qs['limit'](_0x3aee5f[_0x2dd0('0x2e')][_0x2dd0('0x1d')]);_0x1849d2[_0x2dd0('0x1b')]=qs[_0x2dd0('0x1b')](_0x3aee5f[_0x2dd0('0x2e')][_0x2dd0('0x1b')]);}return _0x35dbb6['getConfigurations'](_0x1849d2);}})[_0x2dd0('0x23')](function(_0x4fefab){if(_0x4fefab){return _0x4fefab?{'count':_0x41fbef,'rows':_0x4fefab}:null;}})['then'](respondWithResult(_0x7b8e2d,null))[_0x2dd0('0x3f')](handleError(_0x7b8e2d,null));};exports[_0x2dd0('0x4b')]=function(_0x13453f,_0x9ef0af,_0x56428d){if(_0x13453f[_0x2dd0('0x45')]['id']){delete _0x13453f[_0x2dd0('0x45')]['id'];}return db[_0x2dd0('0x2a')][_0x2dd0('0x47')]({'where':{'id':_0x13453f[_0x2dd0('0x41')]['id']}})[_0x2dd0('0x23')](handleEntityNotFound(_0x9ef0af,null))[_0x2dd0('0x23')](function(_0x250ffa){if(_0x250ffa){_0x13453f[_0x2dd0('0x45')][_0x2dd0('0x4c')]=_0x250ffa['id'];_0x13453f[_0x2dd0('0x45')]['Subjects']=integrations[_0x2dd0('0x4d')](_0x13453f[_0x2dd0('0x45')]['channel'],_0x13453f[_0x2dd0('0x45')][_0x2dd0('0x3a')]);_0x13453f[_0x2dd0('0x45')][_0x2dd0('0x4e')]=integrations[_0x2dd0('0x4f')](_0x13453f[_0x2dd0('0x45')][_0x2dd0('0x50')],_0x13453f['body'][_0x2dd0('0x3a')]);return db[_0x2dd0('0x48')][_0x2dd0('0x44')](_0x13453f[_0x2dd0('0x45')],{'include':[{'model':db[_0x2dd0('0x51')],'as':_0x2dd0('0x52')},{'model':db[_0x2dd0('0x51')],'as':_0x2dd0('0x4e')}]});}return null;})[_0x2dd0('0x23')](respondWithResult(_0x9ef0af,null))[_0x2dd0('0x3f')](handleError(_0x9ef0af,null));};var md5=require('md5');exports[_0x2dd0('0x53')]=function(_0x266e50,_0x1f0c87,_0x29f0ef){var _0x55e21c=null;var _0x3e3526=null;var _0x5b283d=null;var _0x5e2811=null;var _0x2ccfd5='';return db['VtigerAccount']['findOne']({'where':{'id':_0x266e50[_0x2dd0('0x41')]['id']},'attributes':['id','name',_0x2dd0('0x54'),_0x2dd0('0x55'),_0x2dd0('0x56'),_0x2dd0('0x57'),'serverUrl',_0x2dd0('0x58')]})[_0x2dd0('0x23')](handleEntityNotFound(_0x1f0c87,null))[_0x2dd0('0x23')](function(_0x1e8262){if(_0x1e8262){_0x55e21c=_0x1e8262['username'];_0x3e3526=_0x1e8262[_0x2dd0('0x58')];_0x5b283d=_0x1e8262[_0x2dd0('0x56')];_0x2ccfd5=_0x1e8262[_0x2dd0('0x57')];var _0x358130=_0x2ccfd5[_0x2dd0('0x59')](-0x1);if(_0x358130==='/'){_0x2ccfd5=_0x2ccfd5[_0x2dd0('0x5a')](0x0,_0x2ccfd5['lastIndexOf'](_0x358130));}_0x5e2811=util[_0x2dd0('0x5b')]('%s/webservice.php',_0x2ccfd5);var _0xae52ab={'method':_0x2dd0('0x5c'),'uri':_0x5e2811,'qs':{'operation':_0x2dd0('0x5d'),'username':_0x1e8262[_0x2dd0('0x54')]},'json':!![]};return rp(_0xae52ab);}})[_0x2dd0('0x23')](function(_0x26795d){if(_0x26795d[_0x2dd0('0x5e')]){var _0x50c4b4={'method':'POST','uri':_0x5e2811,'form':{'operation':_0x2dd0('0x5f'),'username':_0x55e21c,'accessKey':md5(_0x26795d[_0x2dd0('0x60')][_0x2dd0('0x61')]+_0x3e3526)},'json':!![]};return rp(_0x50c4b4);}})[_0x2dd0('0x23')](function(_0x374aa0){if(_0x374aa0[_0x2dd0('0x5e')]){var _0x253501={'method':_0x2dd0('0x5c'),'uri':_0x5e2811,'qs':{'operation':_0x2dd0('0x62'),'username':_0x55e21c,'sessionName':_0x374aa0[_0x2dd0('0x60')]['sessionName'],'elementType':_0x5b283d},'json':!![]};return rp(_0x253501);}})['then'](function(_0x1c915c){if(_0x1c915c[_0x2dd0('0x5e')]){var _0x2892ad=[_0x2dd0('0x63'),_0x2dd0('0x64'),_0x2dd0('0x65')];_[_0x2dd0('0x66')](_0x1c915c[_0x2dd0('0x60')]['fields'],function(_0x129d21){return _0x2892ad[_0x2dd0('0x67')](_0x129d21[_0x2dd0('0x3a')]['name']);});_['remove'](_0x1c915c[_0x2dd0('0x60')][_0x2dd0('0x31')],function(_0x15463f){return _0x15463f['editable']===_0x2dd0('0x68');});return{'count':_0x1c915c[_0x2dd0('0x60')][_0x2dd0('0x31')][_0x2dd0('0x33')],'rows':_[_0x2dd0('0x29')](_0x1c915c[_0x2dd0('0x60')]['fields'],function(_0x5a9545){return{'id':_0x5a9545[_0x2dd0('0x28')],'name':_0x5a9545[_0x2dd0('0x69')],'custom':_['startsWith'](_0x5a9545[_0x2dd0('0x28')],_0x2dd0('0x6a'))?!![]:![],'options':_0x5a9545[_0x2dd0('0x3a')][_0x2dd0('0x28')]===_0x2dd0('0x6b')&&_0x5a9545['type'][_0x2dd0('0x6c')][_0x2dd0('0x33')]>0x0?_['map'](_0x5a9545[_0x2dd0('0x3a')]['picklistValues'],function(_0x2578dd){return{'name':_0x2578dd[_0x2dd0('0x69')],'value':_0x2578dd[_0x2dd0('0x6d')]};}):[]};})};}})[_0x2dd0('0x23')](respondWithResult(_0x1f0c87,null))[_0x2dd0('0x3f')](function(_0x323b95){console[_0x2dd0('0x6e')]('vTiger\x20error:\x20'+_0x323b95);var _0x58462e=_0x266e50[_0x2dd0('0x2e')][_0x2dd0('0x6f')]?0x1f4:_0x323b95[_0x2dd0('0x70')]||0x1f4;logger[_0x2dd0('0x26')](_0x2dd0('0x71'),'getFields',_0x58462e,JSON[_0x2dd0('0x72')](_0x323b95));delete _0x323b95[_0x2dd0('0x28')];if(_0x58462e===0x191){_0x58462e=0x190;}_0x1f0c87[_0x2dd0('0x18')](_0x58462e)[_0x2dd0('0x73')](_0x266e50[_0x2dd0('0x2e')]['test']?{'message':_0x2dd0('0x74'),'statusCode':_0x323b95[_0x2dd0('0x70')]}:_0x323b95);});};