ddd4074131897211cd71717189baa8d3c5a16843
[motion2.git] / server / api / intSugarcrmConfiguration / intSugarcrmConfiguration.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 _0x1fa7=['includeAll','create','body','find','getFields','getSubjects','findOne','options','hasOwnProperty','getDescriptions','SugarcrmField','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','destroy','sendStatus','error','name','send','SugarcrmConfiguration','fieldName','type','model','map','query','keys','filters','attributes','length','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','include','rows','catch','show','params','rawAttributes','intersection','fields'];(function(_0x3c0db9,_0x56eca0){var _0x1c7e29=function(_0x408ff6){while(--_0x408ff6){_0x3c0db9['push'](_0x3c0db9['shift']());}};_0x1c7e29(++_0x56eca0);}(_0x1fa7,0x19b));var _0x71fa=function(_0x1460ba,_0x1f211e){_0x1460ba=_0x1460ba-0x0;var _0x40f26a=_0x1fa7[_0x1460ba];return _0x40f26a;};'use strict';var emlformat=require(_0x71fa('0x0'));var rimraf=require(_0x71fa('0x1'));var zipdir=require(_0x71fa('0x2'));var jsonpatch=require(_0x71fa('0x3'));var rp=require(_0x71fa('0x4'));var moment=require(_0x71fa('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x71fa('0x6'));var util=require(_0x71fa('0x7'));var path=require(_0x71fa('0x8'));var sox=require('sox');var csv=require(_0x71fa('0x9'));var ejs=require(_0x71fa('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x71fa('0xb'));var squel=require(_0x71fa('0xc'));var crypto=require(_0x71fa('0xd'));var jsforce=require(_0x71fa('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x71fa('0x9'));var querystring=require(_0x71fa('0xf'));var Papa=require(_0x71fa('0x10'));var Redis=require(_0x71fa('0x11'));var authService=require(_0x71fa('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x71fa('0x13'));var hardwareService=require(_0x71fa('0x14'));var logger=require('../../config/logger')(_0x71fa('0x15'));var utils=require(_0x71fa('0x16'));var config=require(_0x71fa('0x17'));var licenseUtil=require(_0x71fa('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5bbef9,_0x189d4d){_0x189d4d=_0x189d4d||0xcc;return function(_0x50a225){if(_0x50a225){return _0x5bbef9['sendStatus'](_0x189d4d);}return _0x5bbef9[_0x71fa('0x19')](_0x189d4d)[_0x71fa('0x1a')]();};}function respondWithResult(_0xfe34f9,_0x53dec7){_0x53dec7=_0x53dec7||0xc8;return function(_0x36dc04){if(_0x36dc04){return _0xfe34f9[_0x71fa('0x19')](_0x53dec7)[_0x71fa('0x1b')](_0x36dc04);}};}function respondWithFilteredResult(_0x51147f,_0x5ab131){return function(_0x544134){if(_0x544134){var _0x58aa04=typeof _0x5ab131[_0x71fa('0x1c')]===_0x71fa('0x1d')&&typeof _0x5ab131[_0x71fa('0x1e')]===_0x71fa('0x1d');var _0x3aa313=_0x544134['count'];var _0x17e688=_0x58aa04?0x0:_0x5ab131[_0x71fa('0x1c')];var _0x57ab96=_0x58aa04?_0x544134[_0x71fa('0x1f')]:_0x5ab131[_0x71fa('0x1c')]+_0x5ab131[_0x71fa('0x1e')];var _0x58decb;if(_0x57ab96>=_0x3aa313){_0x57ab96=_0x3aa313;_0x58decb=0xc8;}else{_0x58decb=0xce;}_0x51147f[_0x71fa('0x19')](_0x58decb);return _0x51147f[_0x71fa('0x20')](_0x71fa('0x21'),_0x17e688+'-'+_0x57ab96+'/'+_0x3aa313)[_0x71fa('0x1b')](_0x544134);}return null;};}function patchUpdates(_0x56ff3b){return function(_0x307288){try{jsonpatch[_0x71fa('0x22')](_0x307288,_0x56ff3b,!![]);}catch(_0x376ee3){return BPromise[_0x71fa('0x23')](_0x376ee3);}return _0x307288['save']();};}function saveUpdates(_0x25c052,_0x5c503f){return function(_0x2f6e6d){if(_0x2f6e6d){return _0x2f6e6d[_0x71fa('0x24')](_0x25c052)[_0x71fa('0x25')](function(_0x55f6df){return _0x55f6df;});}return null;};}function removeEntity(_0x3b7da5,_0x965544){return function(_0x40445b){if(_0x40445b){return _0x40445b[_0x71fa('0x26')]()[_0x71fa('0x25')](function(){_0x3b7da5[_0x71fa('0x19')](0xcc)[_0x71fa('0x1a')]();});}};}function handleEntityNotFound(_0x1736a9,_0x4c2513){return function(_0x1230c0){if(!_0x1230c0){_0x1736a9[_0x71fa('0x27')](0x194);}return _0x1230c0;};}function handleError(_0x46d9de,_0x288c0d){_0x288c0d=_0x288c0d||0x1f4;return function(_0x244095){logger[_0x71fa('0x28')](_0x244095['stack']);if(_0x244095['name']){delete _0x244095[_0x71fa('0x29')];}_0x46d9de[_0x71fa('0x19')](_0x288c0d)[_0x71fa('0x2a')](_0x244095);};}exports['index']=function(_0x9d632,_0x459902){var _0x55985c={},_0x3bb487={},_0x19edac={'count':0x0,'rows':[]};var _0x3bc31c=_['map'](db[_0x71fa('0x2b')]['rawAttributes'],function(_0x4969b1){return{'name':_0x4969b1[_0x71fa('0x2c')],'type':_0x4969b1[_0x71fa('0x2d')]['key']};});_0x3bb487[_0x71fa('0x2e')]=_[_0x71fa('0x2f')](_0x3bc31c,_0x71fa('0x29'));_0x3bb487[_0x71fa('0x30')]=_[_0x71fa('0x31')](_0x9d632['query']);_0x3bb487[_0x71fa('0x32')]=_['intersection'](_0x3bb487['model'],_0x3bb487['query']);_0x55985c[_0x71fa('0x33')]=_['intersection'](_0x3bb487[_0x71fa('0x2e')],qs['fields'](_0x9d632[_0x71fa('0x30')]['fields']));_0x55985c[_0x71fa('0x33')]=_0x55985c[_0x71fa('0x33')][_0x71fa('0x34')]?_0x55985c[_0x71fa('0x33')]:_0x3bb487[_0x71fa('0x2e')];if(!_0x9d632[_0x71fa('0x30')]['hasOwnProperty'](_0x71fa('0x35'))){_0x55985c[_0x71fa('0x1e')]=qs[_0x71fa('0x1e')](_0x9d632[_0x71fa('0x30')]['limit']);_0x55985c[_0x71fa('0x1c')]=qs['offset'](_0x9d632[_0x71fa('0x30')][_0x71fa('0x1c')]);}_0x55985c[_0x71fa('0x36')]=qs[_0x71fa('0x37')](_0x9d632['query']['sort']);_0x55985c[_0x71fa('0x38')]=qs[_0x71fa('0x32')](_[_0x71fa('0x39')](_0x9d632[_0x71fa('0x30')],_0x3bb487[_0x71fa('0x32')]),_0x3bc31c);if(_0x9d632['query'][_0x71fa('0x3a')]){_0x55985c[_0x71fa('0x38')]=_[_0x71fa('0x3b')](_0x55985c[_0x71fa('0x38')],{'$or':_[_0x71fa('0x2f')](_0x3bc31c,function(_0x1a4e67){if(_0x1a4e67[_0x71fa('0x2d')]!==_0x71fa('0x3c')){var _0x204c65={};_0x204c65[_0x1a4e67[_0x71fa('0x29')]]={'$like':'%'+_0x9d632[_0x71fa('0x30')][_0x71fa('0x3a')]+'%'};return _0x204c65;}})});}_0x55985c=_[_0x71fa('0x3b')]({},_0x55985c,_0x9d632['options']);var _0x414ff3={'where':_0x55985c[_0x71fa('0x38')]};return db[_0x71fa('0x2b')][_0x71fa('0x1f')](_0x414ff3)[_0x71fa('0x25')](function(_0x3225b7){_0x19edac[_0x71fa('0x1f')]=_0x3225b7;if(_0x9d632[_0x71fa('0x30')]['includeAll']){_0x55985c[_0x71fa('0x3d')]=[{'all':!![]}];}return db[_0x71fa('0x2b')]['findAll'](_0x55985c);})[_0x71fa('0x25')](function(_0x5be8b3){_0x19edac[_0x71fa('0x3e')]=_0x5be8b3;return _0x19edac;})[_0x71fa('0x25')](respondWithFilteredResult(_0x459902,_0x55985c))[_0x71fa('0x3f')](handleError(_0x459902,null));};exports[_0x71fa('0x40')]=function(_0x41adca,_0x19952b){var _0x573f5e={'raw':![],'where':{'id':_0x41adca[_0x71fa('0x41')]['id']}},_0x9ec18={};_0x9ec18[_0x71fa('0x2e')]=_['keys'](db[_0x71fa('0x2b')][_0x71fa('0x42')]);_0x9ec18[_0x71fa('0x30')]=_[_0x71fa('0x31')](_0x41adca[_0x71fa('0x30')]);_0x9ec18[_0x71fa('0x32')]=_[_0x71fa('0x43')](_0x9ec18[_0x71fa('0x2e')],_0x9ec18[_0x71fa('0x30')]);_0x573f5e['attributes']=_[_0x71fa('0x43')](_0x9ec18[_0x71fa('0x2e')],qs[_0x71fa('0x44')](_0x41adca[_0x71fa('0x30')][_0x71fa('0x44')]));_0x573f5e['attributes']=_0x573f5e['attributes'][_0x71fa('0x34')]?_0x573f5e[_0x71fa('0x33')]:_0x9ec18['model'];if(_0x41adca[_0x71fa('0x30')][_0x71fa('0x45')]){_0x573f5e[_0x71fa('0x3d')]=[{'all':!![]}];}_0x573f5e=_['merge']({},_0x573f5e,_0x41adca['options']);return db[_0x71fa('0x2b')]['find'](_0x573f5e)[_0x71fa('0x25')](handleEntityNotFound(_0x19952b,null))[_0x71fa('0x25')](respondWithResult(_0x19952b,null))['catch'](handleError(_0x19952b,null));};exports[_0x71fa('0x46')]=function(_0x5a894c,_0x440c80){return db[_0x71fa('0x2b')][_0x71fa('0x46')](_0x5a894c[_0x71fa('0x47')],{})[_0x71fa('0x25')](respondWithResult(_0x440c80,0xc9))['catch'](handleError(_0x440c80,null));};exports[_0x71fa('0x24')]=function(_0x2effe5,_0x58fdc7){if(_0x2effe5['body']['id']){delete _0x2effe5[_0x71fa('0x47')]['id'];}return db['SugarcrmConfiguration'][_0x71fa('0x48')]({'where':{'id':_0x2effe5[_0x71fa('0x41')]['id']}})[_0x71fa('0x25')](handleEntityNotFound(_0x58fdc7,null))[_0x71fa('0x25')](saveUpdates(_0x2effe5['body'],null))['then'](respondWithResult(_0x58fdc7,null))[_0x71fa('0x3f')](handleError(_0x58fdc7,null));};exports[_0x71fa('0x26')]=function(_0x4d4965,_0x52ab59){return db[_0x71fa('0x2b')]['find']({'where':{'id':_0x4d4965['params']['id']}})[_0x71fa('0x25')](handleEntityNotFound(_0x52ab59,null))[_0x71fa('0x25')](removeEntity(_0x52ab59,null))[_0x71fa('0x3f')](handleError(_0x52ab59,null));};exports[_0x71fa('0x49')]=function(_0x8b919e,_0x2b9eb2,_0x5c3993){var _0x3d5386={};var _0x3ce5d7={};var _0x156199;var _0x53c704;return db[_0x71fa('0x2b')]['findOne']({'where':{'id':_0x8b919e['params']['id']}})[_0x71fa('0x25')](handleEntityNotFound(_0x2b9eb2,null))['then'](function(_0xa45d2a){if(_0xa45d2a){_0x156199=_0xa45d2a;_0x3ce5d7[_0x71fa('0x2e')]=_['keys'](db['SugarcrmField'][_0x71fa('0x42')]);_0x3ce5d7[_0x71fa('0x30')]=_[_0x71fa('0x31')](_0x8b919e[_0x71fa('0x30')]);_0x3ce5d7['filters']=_[_0x71fa('0x43')](_0x3ce5d7[_0x71fa('0x2e')],_0x3ce5d7[_0x71fa('0x30')]);_0x3d5386[_0x71fa('0x33')]=_[_0x71fa('0x43')](_0x3ce5d7[_0x71fa('0x2e')],qs['fields'](_0x8b919e[_0x71fa('0x30')][_0x71fa('0x44')]));_0x3d5386['attributes']=_0x3d5386[_0x71fa('0x33')][_0x71fa('0x34')]?_0x3d5386[_0x71fa('0x33')]:_0x3ce5d7['model'];_0x3d5386[_0x71fa('0x36')]=qs['sort'](_0x8b919e['query']['sort']);_0x3d5386['where']=qs['filters'](_['pick'](_0x8b919e[_0x71fa('0x30')],_0x3ce5d7[_0x71fa('0x32')]));if(_0x8b919e[_0x71fa('0x30')]['filter']){_0x3d5386[_0x71fa('0x38')]=_[_0x71fa('0x3b')](_0x3d5386[_0x71fa('0x38')],{'$or':_[_0x71fa('0x2f')](_0x3d5386[_0x71fa('0x33')],function(_0x595cfa){var _0x3ed231={};_0x3ed231[_0x595cfa]={'$like':'%'+_0x8b919e[_0x71fa('0x30')][_0x71fa('0x3a')]+'%'};return _0x3ed231;})});}_0x3d5386=_[_0x71fa('0x3b')]({},_0x3d5386,_0x8b919e['options']);return _0x156199[_0x71fa('0x49')](_0x3d5386);}})['then'](function(_0x4edbfa){if(_0x4edbfa){_0x53c704=_0x4edbfa[_0x71fa('0x34')];if(!_0x8b919e[_0x71fa('0x30')]['hasOwnProperty'](_0x71fa('0x35'))){_0x3d5386[_0x71fa('0x1e')]=qs[_0x71fa('0x1e')](_0x8b919e['query'][_0x71fa('0x1e')]);_0x3d5386[_0x71fa('0x1c')]=qs[_0x71fa('0x1c')](_0x8b919e[_0x71fa('0x30')]['offset']);}return _0x156199[_0x71fa('0x49')](_0x3d5386);}})[_0x71fa('0x25')](function(_0x8e8b7c){if(_0x8e8b7c){return _0x8e8b7c?{'count':_0x53c704,'rows':_0x8e8b7c}:null;}})[_0x71fa('0x25')](respondWithResult(_0x2b9eb2,null))[_0x71fa('0x3f')](handleError(_0x2b9eb2,null));};exports[_0x71fa('0x4a')]=function(_0x570eda,_0x44aa4d,_0x198fe5){var _0x1e8196={};var _0x1e5f6f={};var _0x543dbf;var _0x32dfe8;return db[_0x71fa('0x2b')][_0x71fa('0x4b')]({'where':{'id':_0x570eda['params']['id']}})[_0x71fa('0x25')](handleEntityNotFound(_0x44aa4d,null))[_0x71fa('0x25')](function(_0x57727e){if(_0x57727e){_0x543dbf=_0x57727e;_0x1e5f6f[_0x71fa('0x2e')]=_[_0x71fa('0x31')](db['SugarcrmField']['rawAttributes']);_0x1e5f6f[_0x71fa('0x30')]=_[_0x71fa('0x31')](_0x570eda[_0x71fa('0x30')]);_0x1e5f6f[_0x71fa('0x32')]=_['intersection'](_0x1e5f6f['model'],_0x1e5f6f[_0x71fa('0x30')]);_0x1e8196[_0x71fa('0x33')]=_[_0x71fa('0x43')](_0x1e5f6f['model'],qs[_0x71fa('0x44')](_0x570eda['query']['fields']));_0x1e8196[_0x71fa('0x33')]=_0x1e8196['attributes'][_0x71fa('0x34')]?_0x1e8196['attributes']:_0x1e5f6f[_0x71fa('0x2e')];_0x1e8196['order']=qs[_0x71fa('0x37')](_0x570eda[_0x71fa('0x30')]['sort']);_0x1e8196[_0x71fa('0x38')]=qs[_0x71fa('0x32')](_['pick'](_0x570eda[_0x71fa('0x30')],_0x1e5f6f[_0x71fa('0x32')]));if(_0x570eda['query'][_0x71fa('0x3a')]){_0x1e8196[_0x71fa('0x38')]=_[_0x71fa('0x3b')](_0x1e8196['where'],{'$or':_[_0x71fa('0x2f')](_0x1e8196[_0x71fa('0x33')],function(_0x25bba2){var _0x2999a5={};_0x2999a5[_0x25bba2]={'$like':'%'+_0x570eda[_0x71fa('0x30')][_0x71fa('0x3a')]+'%'};return _0x2999a5;})});}_0x1e8196=_[_0x71fa('0x3b')]({},_0x1e8196,_0x570eda[_0x71fa('0x4c')]);return _0x543dbf['getSubjects'](_0x1e8196);}})[_0x71fa('0x25')](function(_0x3ae926){if(_0x3ae926){_0x32dfe8=_0x3ae926[_0x71fa('0x34')];if(!_0x570eda[_0x71fa('0x30')][_0x71fa('0x4d')](_0x71fa('0x35'))){_0x1e8196[_0x71fa('0x1e')]=qs[_0x71fa('0x1e')](_0x570eda[_0x71fa('0x30')][_0x71fa('0x1e')]);_0x1e8196[_0x71fa('0x1c')]=qs['offset'](_0x570eda[_0x71fa('0x30')][_0x71fa('0x1c')]);}return _0x543dbf[_0x71fa('0x4a')](_0x1e8196);}})[_0x71fa('0x25')](function(_0x66907){if(_0x66907){return _0x66907?{'count':_0x32dfe8,'rows':_0x66907}:null;}})[_0x71fa('0x25')](respondWithResult(_0x44aa4d,null))[_0x71fa('0x3f')](handleError(_0x44aa4d,null));};exports[_0x71fa('0x4e')]=function(_0x3d98d5,_0x4dc510,_0x14793c){var _0x129b9f={};var _0x2a3bbc={};var _0x422502;var _0x4810e7;return db[_0x71fa('0x2b')][_0x71fa('0x4b')]({'where':{'id':_0x3d98d5[_0x71fa('0x41')]['id']}})[_0x71fa('0x25')](handleEntityNotFound(_0x4dc510,null))[_0x71fa('0x25')](function(_0x50d02f){if(_0x50d02f){_0x422502=_0x50d02f;_0x2a3bbc['model']=_[_0x71fa('0x31')](db[_0x71fa('0x4f')][_0x71fa('0x42')]);_0x2a3bbc[_0x71fa('0x30')]=_[_0x71fa('0x31')](_0x3d98d5[_0x71fa('0x30')]);_0x2a3bbc['filters']=_[_0x71fa('0x43')](_0x2a3bbc['model'],_0x2a3bbc['query']);_0x129b9f['attributes']=_[_0x71fa('0x43')](_0x2a3bbc[_0x71fa('0x2e')],qs['fields'](_0x3d98d5['query'][_0x71fa('0x44')]));_0x129b9f['attributes']=_0x129b9f['attributes']['length']?_0x129b9f[_0x71fa('0x33')]:_0x2a3bbc['model'];_0x129b9f[_0x71fa('0x36')]=qs['sort'](_0x3d98d5[_0x71fa('0x30')]['sort']);_0x129b9f['where']=qs['filters'](_['pick'](_0x3d98d5['query'],_0x2a3bbc[_0x71fa('0x32')]));if(_0x3d98d5['query'][_0x71fa('0x3a')]){_0x129b9f[_0x71fa('0x38')]=_[_0x71fa('0x3b')](_0x129b9f[_0x71fa('0x38')],{'$or':_[_0x71fa('0x2f')](_0x129b9f[_0x71fa('0x33')],function(_0x48673c){var _0x399092={};_0x399092[_0x48673c]={'$like':'%'+_0x3d98d5[_0x71fa('0x30')][_0x71fa('0x3a')]+'%'};return _0x399092;})});}_0x129b9f=_['merge']({},_0x129b9f,_0x3d98d5[_0x71fa('0x4c')]);return _0x422502['getDescriptions'](_0x129b9f);}})['then'](function(_0x5cf3f5){if(_0x5cf3f5){_0x4810e7=_0x5cf3f5[_0x71fa('0x34')];if(!_0x3d98d5['query'][_0x71fa('0x4d')]('nolimit')){_0x129b9f[_0x71fa('0x1e')]=qs[_0x71fa('0x1e')](_0x3d98d5[_0x71fa('0x30')]['limit']);_0x129b9f['offset']=qs[_0x71fa('0x1c')](_0x3d98d5[_0x71fa('0x30')]['offset']);}return _0x422502[_0x71fa('0x4e')](_0x129b9f);}})[_0x71fa('0x25')](function(_0x1c6b17){if(_0x1c6b17){return _0x1c6b17?{'count':_0x4810e7,'rows':_0x1c6b17}:null;}})[_0x71fa('0x25')](respondWithResult(_0x4dc510,null))[_0x71fa('0x3f')](handleError(_0x4dc510,null));};