// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x5546=['error','code','message','result','catch','sendStatus','status','end','json','offset','limit','Content-Range','reject','save','update','destroy','name','index','SugarcrmConfiguration','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','count','includeAll','include','rows','show','params','find','create','body','getFields','getSubjects','findOne','getDescriptions','SugarcrmField','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','util','path','to-csv','ejs','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','client','http','then','info','SugarcrmConfiguration,\x20%s,\x20%s','request\x20sent','debug','SugarcrmConfiguration,\x20%s,\x20%s,\x20%s'];(function(_0x48849f,_0x5e6632){var _0x3c1d82=function(_0x5a0123){while(--_0x5a0123){_0x48849f['push'](_0x48849f['shift']());}};_0x3c1d82(++_0x5e6632);}(_0x5546,0x8e));var _0x6554=function(_0x4e2e49,_0x5a7f98){_0x4e2e49=_0x4e2e49-0x0;var _0x8a22ec=_0x5546[_0x4e2e49];return _0x8a22ec;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x6554('0x0'));var rimraf=require(_0x6554('0x1'));var zipdir=require(_0x6554('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x6554('0x3'));var moment=require(_0x6554('0x4'));var BPromise=require(_0x6554('0x5'));var Mustache=require('mustache');var util=require(_0x6554('0x6'));var path=require(_0x6554('0x7'));var sox=require('sox');var csv=require(_0x6554('0x8'));var ejs=require(_0x6554('0x9'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x6554('0xa'));var deskjs=require(_0x6554('0xb'));var toCsv=require(_0x6554('0x8'));var querystring=require(_0x6554('0xc'));var Papa=require(_0x6554('0xd'));var Redis=require(_0x6554('0xe'));var authService=require('../../components/auth/service');var qs=require(_0x6554('0xf'));var as=require(_0x6554('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x6554('0x11'));var utils=require(_0x6554('0x12'));var config=require(_0x6554('0x13'));var licenseUtil=require(_0x6554('0x14'));var db=require(_0x6554('0x15'))['db'];var jayson=require('jayson/promise');var client=jayson[_0x6554('0x16')][_0x6554('0x17')]({'port':0x232a});function respondWithRpcPromise(_0x2f4c45,_0x14cf9e,_0x1ed7cc,_0x17e4c6){return new BPromise(function(_0x366d09,_0x1948aa){var _0x323a3a=_0x17e4c6||client;return _0x323a3a['request'](_0x2f4c45,_0x1ed7cc)[_0x6554('0x18')](function(_0x94c91e){logger[_0x6554('0x19')](_0x6554('0x1a'),_0x14cf9e,_0x6554('0x1b'));logger[_0x6554('0x1c')](_0x6554('0x1d'),_0x14cf9e,_0x6554('0x1b'),JSON['stringify'](_0x94c91e));if(_0x94c91e[_0x6554('0x1e')]){if(_0x94c91e[_0x6554('0x1e')][_0x6554('0x1f')]===0x1f4){logger[_0x6554('0x1e')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x14cf9e,_0x94c91e[_0x6554('0x1e')]['message']);return _0x1948aa(_0x94c91e[_0x6554('0x1e')][_0x6554('0x20')]);}logger[_0x6554('0x1e')](_0x6554('0x1a'),_0x14cf9e,_0x94c91e['error']['message']);return _0x366d09(_0x94c91e[_0x6554('0x1e')]['message']);}else{logger[_0x6554('0x19')](_0x6554('0x1a'),_0x14cf9e,_0x6554('0x1b'));_0x366d09(_0x94c91e[_0x6554('0x21')]['message']);}})[_0x6554('0x22')](function(_0x3296b4){logger[_0x6554('0x1e')](_0x6554('0x1a'),_0x14cf9e,_0x3296b4);_0x1948aa(_0x3296b4);});});}function respondWithStatusCode(_0x528a97,_0x35f944){_0x35f944=_0x35f944||0xcc;return function(_0x581ef3){if(_0x581ef3){return _0x528a97[_0x6554('0x23')](_0x35f944);}return _0x528a97[_0x6554('0x24')](_0x35f944)[_0x6554('0x25')]();};}function respondWithResult(_0x433893,_0x22a7a0){_0x22a7a0=_0x22a7a0||0xc8;return function(_0x64fcf0){if(_0x64fcf0){return _0x433893['status'](_0x22a7a0)[_0x6554('0x26')](_0x64fcf0);}};}function respondWithFilteredResult(_0x7473a7,_0x3c5236){return function(_0x30b1a9){if(_0x30b1a9){var _0x45b3b3=_0x30b1a9['count'],_0xa16d65=_0x3c5236[_0x6554('0x27')],_0x37e4d7=_0x3c5236['offset']+_0x3c5236[_0x6554('0x28')],_0x56660d;if(_0x37e4d7>=_0x45b3b3){_0x37e4d7=_0x45b3b3;_0x56660d=0xc8;}else{_0x56660d=0xce;}_0x7473a7[_0x6554('0x24')](_0x56660d);return _0x7473a7['set'](_0x6554('0x29'),_0xa16d65+'-'+_0x37e4d7+'/'+_0x45b3b3)['json'](_0x30b1a9);}return null;};}function patchUpdates(_0x3bb19d){return function(_0x25f6ca){try{jsonpatch['apply'](_0x25f6ca,_0x3bb19d,!![]);}catch(_0x5b43d0){return BPromise[_0x6554('0x2a')](_0x5b43d0);}return _0x25f6ca[_0x6554('0x2b')]();};}function saveUpdates(_0x1ff3eb,_0x4a3f62){return function(_0x387592){if(_0x387592){return _0x387592[_0x6554('0x2c')](_0x1ff3eb)[_0x6554('0x18')](function(_0x48bd20){return _0x48bd20;});}return null;};}function removeEntity(_0x4feb85,_0x2e155e){return function(_0x3d5034){if(_0x3d5034){return _0x3d5034[_0x6554('0x2d')]()[_0x6554('0x18')](function(){_0x4feb85[_0x6554('0x24')](0xcc)[_0x6554('0x25')]();});}};}function handleEntityNotFound(_0x52f670,_0x470c78){return function(_0x2ad8cc){if(!_0x2ad8cc){_0x52f670['sendStatus'](0x194);}return _0x2ad8cc;};}function handleError(_0x39d165,_0x21d2ec){_0x21d2ec=_0x21d2ec||0x1f4;return function(_0x17c1c4){logger[_0x6554('0x1e')](_0x17c1c4['stack']);if(_0x17c1c4[_0x6554('0x2e')]){delete _0x17c1c4[_0x6554('0x2e')];}_0x39d165[_0x6554('0x24')](_0x21d2ec)['send'](_0x17c1c4);};}exports[_0x6554('0x2f')]=function(_0x5354cf,_0x1f2058){var _0x498a89={},_0x255b09={},_0xcc9bd2={'count':0x0,'rows':[]};var _0x506de9=_['map'](db[_0x6554('0x30')][_0x6554('0x31')],function(_0x4cc981){return{'name':_0x4cc981[_0x6554('0x32')],'type':_0x4cc981[_0x6554('0x33')][_0x6554('0x34')]};});_0x255b09[_0x6554('0x35')]=_[_0x6554('0x36')](_0x506de9,_0x6554('0x2e'));_0x255b09[_0x6554('0x37')]=_[_0x6554('0x38')](_0x5354cf[_0x6554('0x37')]);_0x255b09[_0x6554('0x39')]=_[_0x6554('0x3a')](_0x255b09[_0x6554('0x35')],_0x255b09[_0x6554('0x37')]);_0x498a89[_0x6554('0x3b')]=_[_0x6554('0x3a')](_0x255b09[_0x6554('0x35')],qs[_0x6554('0x3c')](_0x5354cf[_0x6554('0x37')][_0x6554('0x3c')]));_0x498a89[_0x6554('0x3b')]=_0x498a89[_0x6554('0x3b')][_0x6554('0x3d')]?_0x498a89[_0x6554('0x3b')]:_0x255b09[_0x6554('0x35')];if(!_0x5354cf[_0x6554('0x37')][_0x6554('0x3e')](_0x6554('0x3f'))){_0x498a89[_0x6554('0x28')]=qs[_0x6554('0x28')](_0x5354cf[_0x6554('0x37')][_0x6554('0x28')]);_0x498a89[_0x6554('0x27')]=qs[_0x6554('0x27')](_0x5354cf[_0x6554('0x37')][_0x6554('0x27')]);}_0x498a89[_0x6554('0x40')]=qs['sort'](_0x5354cf['query'][_0x6554('0x41')]);_0x498a89['where']=qs[_0x6554('0x39')](_[_0x6554('0x42')](_0x5354cf[_0x6554('0x37')],_0x255b09[_0x6554('0x39')]),_0x506de9);if(_0x5354cf[_0x6554('0x37')][_0x6554('0x43')]){_0x498a89[_0x6554('0x44')]=_[_0x6554('0x45')](_0x498a89[_0x6554('0x44')],{'$or':_[_0x6554('0x36')](_0x506de9,function(_0xc2ddb3){if(_0xc2ddb3['type']!==_0x6554('0x46')){var _0x5657d9={};_0x5657d9[_0xc2ddb3['name']]={'$like':'%'+_0x5354cf[_0x6554('0x37')][_0x6554('0x43')]+'%'};return _0x5657d9;}})});}_0x498a89=_['merge']({},_0x498a89,_0x5354cf[_0x6554('0x47')]);var _0x438fcb={'where':_0x498a89['where']};return db[_0x6554('0x30')][_0x6554('0x48')](_0x438fcb)[_0x6554('0x18')](function(_0x4b0933){_0xcc9bd2['count']=_0x4b0933;if(_0x5354cf[_0x6554('0x37')][_0x6554('0x49')]){_0x498a89[_0x6554('0x4a')]=[{'all':!![]}];}return db[_0x6554('0x30')]['findAll'](_0x498a89);})[_0x6554('0x18')](function(_0x3d411c){_0xcc9bd2[_0x6554('0x4b')]=_0x3d411c;return _0xcc9bd2;})[_0x6554('0x18')](respondWithFilteredResult(_0x1f2058,_0x498a89))['catch'](handleError(_0x1f2058,null));};exports[_0x6554('0x4c')]=function(_0x218466,_0x439647){var _0x5ede28={'raw':![],'where':{'id':_0x218466[_0x6554('0x4d')]['id']}},_0x21bd02={};_0x21bd02[_0x6554('0x35')]=_[_0x6554('0x38')](db[_0x6554('0x30')]['rawAttributes']);_0x21bd02[_0x6554('0x37')]=_[_0x6554('0x38')](_0x218466['query']);_0x21bd02[_0x6554('0x39')]=_[_0x6554('0x3a')](_0x21bd02[_0x6554('0x35')],_0x21bd02['query']);_0x5ede28['attributes']=_[_0x6554('0x3a')](_0x21bd02['model'],qs[_0x6554('0x3c')](_0x218466[_0x6554('0x37')][_0x6554('0x3c')]));_0x5ede28[_0x6554('0x3b')]=_0x5ede28[_0x6554('0x3b')]['length']?_0x5ede28['attributes']:_0x21bd02[_0x6554('0x35')];if(_0x218466[_0x6554('0x37')][_0x6554('0x49')]){_0x5ede28[_0x6554('0x4a')]=[{'all':!![]}];}_0x5ede28=_[_0x6554('0x45')]({},_0x5ede28,_0x218466[_0x6554('0x47')]);return db[_0x6554('0x30')][_0x6554('0x4e')](_0x5ede28)[_0x6554('0x18')](handleEntityNotFound(_0x439647,null))[_0x6554('0x18')](respondWithResult(_0x439647,null))[_0x6554('0x22')](handleError(_0x439647,null));};exports[_0x6554('0x4f')]=function(_0x50610d,_0x4ab1fc){return db[_0x6554('0x30')]['create'](_0x50610d[_0x6554('0x50')],{})[_0x6554('0x18')](respondWithResult(_0x4ab1fc,0xc9))[_0x6554('0x22')](handleError(_0x4ab1fc,null));};exports['update']=function(_0x552805,_0x214cc1){if(_0x552805['body']['id']){delete _0x552805[_0x6554('0x50')]['id'];}return db[_0x6554('0x30')]['find']({'where':{'id':_0x552805['params']['id']}})[_0x6554('0x18')](handleEntityNotFound(_0x214cc1,null))[_0x6554('0x18')](saveUpdates(_0x552805[_0x6554('0x50')],null))[_0x6554('0x18')](respondWithResult(_0x214cc1,null))[_0x6554('0x22')](handleError(_0x214cc1,null));};exports[_0x6554('0x2d')]=function(_0x261699,_0x2786c6){return db[_0x6554('0x30')][_0x6554('0x4e')]({'where':{'id':_0x261699[_0x6554('0x4d')]['id']}})['then'](handleEntityNotFound(_0x2786c6,null))[_0x6554('0x18')](removeEntity(_0x2786c6,null))[_0x6554('0x22')](handleError(_0x2786c6,null));};exports['getFields']=function(_0x3021b2,_0x4a1717,_0x330cbe){var _0x2b3eed={};var _0x2db378={};var _0x1a0500;var _0x5d0e3a;return db[_0x6554('0x30')]['findOne']({'where':{'id':_0x3021b2[_0x6554('0x4d')]['id']}})['then'](handleEntityNotFound(_0x4a1717,null))[_0x6554('0x18')](function(_0x5c2f62){if(_0x5c2f62){_0x1a0500=_0x5c2f62;_0x2db378[_0x6554('0x35')]=_[_0x6554('0x38')](db['SugarcrmField']['rawAttributes']);_0x2db378[_0x6554('0x37')]=_[_0x6554('0x38')](_0x3021b2[_0x6554('0x37')]);_0x2db378['filters']=_[_0x6554('0x3a')](_0x2db378['model'],_0x2db378[_0x6554('0x37')]);_0x2b3eed[_0x6554('0x3b')]=_[_0x6554('0x3a')](_0x2db378[_0x6554('0x35')],qs[_0x6554('0x3c')](_0x3021b2[_0x6554('0x37')]['fields']));_0x2b3eed['attributes']=_0x2b3eed['attributes'][_0x6554('0x3d')]?_0x2b3eed[_0x6554('0x3b')]:_0x2db378[_0x6554('0x35')];_0x2b3eed[_0x6554('0x40')]=qs['sort'](_0x3021b2[_0x6554('0x37')][_0x6554('0x41')]);_0x2b3eed['where']=qs[_0x6554('0x39')](_['pick'](_0x3021b2[_0x6554('0x37')],_0x2db378[_0x6554('0x39')]));if(_0x3021b2['query']['filter']){_0x2b3eed[_0x6554('0x44')]=_[_0x6554('0x45')](_0x2b3eed[_0x6554('0x44')],{'$or':_[_0x6554('0x36')](_0x2b3eed[_0x6554('0x3b')],function(_0x3324f6){var _0x250e78={};_0x250e78[_0x3324f6]={'$like':'%'+_0x3021b2[_0x6554('0x37')]['filter']+'%'};return _0x250e78;})});}_0x2b3eed=_[_0x6554('0x45')]({},_0x2b3eed,_0x3021b2['options']);return _0x1a0500[_0x6554('0x51')](_0x2b3eed);}})[_0x6554('0x18')](function(_0x45ea3f){if(_0x45ea3f){_0x5d0e3a=_0x45ea3f[_0x6554('0x3d')];if(!_0x3021b2['query'][_0x6554('0x3e')](_0x6554('0x3f'))){_0x2b3eed[_0x6554('0x28')]=qs[_0x6554('0x28')](_0x3021b2[_0x6554('0x37')][_0x6554('0x28')]);_0x2b3eed[_0x6554('0x27')]=qs[_0x6554('0x27')](_0x3021b2[_0x6554('0x37')][_0x6554('0x27')]);}return _0x1a0500['getFields'](_0x2b3eed);}})[_0x6554('0x18')](function(_0xc6fd8b){if(_0xc6fd8b){return _0xc6fd8b?{'count':_0x5d0e3a,'rows':_0xc6fd8b}:null;}})['then'](respondWithResult(_0x4a1717,null))[_0x6554('0x22')](handleError(_0x4a1717,null));};exports[_0x6554('0x52')]=function(_0x5510a9,_0x3be5a9,_0x595979){var _0x37d50b={};var _0xd6c54b={};var _0x3f4ae2;var _0x2b52c2;return db[_0x6554('0x30')][_0x6554('0x53')]({'where':{'id':_0x5510a9[_0x6554('0x4d')]['id']}})[_0x6554('0x18')](handleEntityNotFound(_0x3be5a9,null))[_0x6554('0x18')](function(_0x495d8a){if(_0x495d8a){_0x3f4ae2=_0x495d8a;_0xd6c54b[_0x6554('0x35')]=_[_0x6554('0x38')](db['SugarcrmField']['rawAttributes']);_0xd6c54b[_0x6554('0x37')]=_[_0x6554('0x38')](_0x5510a9[_0x6554('0x37')]);_0xd6c54b[_0x6554('0x39')]=_['intersection'](_0xd6c54b['model'],_0xd6c54b[_0x6554('0x37')]);_0x37d50b[_0x6554('0x3b')]=_[_0x6554('0x3a')](_0xd6c54b[_0x6554('0x35')],qs[_0x6554('0x3c')](_0x5510a9[_0x6554('0x37')][_0x6554('0x3c')]));_0x37d50b['attributes']=_0x37d50b[_0x6554('0x3b')][_0x6554('0x3d')]?_0x37d50b[_0x6554('0x3b')]:_0xd6c54b[_0x6554('0x35')];_0x37d50b['order']=qs[_0x6554('0x41')](_0x5510a9[_0x6554('0x37')][_0x6554('0x41')]);_0x37d50b[_0x6554('0x44')]=qs[_0x6554('0x39')](_[_0x6554('0x42')](_0x5510a9[_0x6554('0x37')],_0xd6c54b[_0x6554('0x39')]));if(_0x5510a9[_0x6554('0x37')]['filter']){_0x37d50b[_0x6554('0x44')]=_['merge'](_0x37d50b[_0x6554('0x44')],{'$or':_[_0x6554('0x36')](_0x37d50b[_0x6554('0x3b')],function(_0x1e5196){var _0x41180b={};_0x41180b[_0x1e5196]={'$like':'%'+_0x5510a9['query'][_0x6554('0x43')]+'%'};return _0x41180b;})});}_0x37d50b=_[_0x6554('0x45')]({},_0x37d50b,_0x5510a9[_0x6554('0x47')]);return _0x3f4ae2[_0x6554('0x52')](_0x37d50b);}})[_0x6554('0x18')](function(_0x520323){if(_0x520323){_0x2b52c2=_0x520323[_0x6554('0x3d')];if(!_0x5510a9[_0x6554('0x37')][_0x6554('0x3e')](_0x6554('0x3f'))){_0x37d50b[_0x6554('0x28')]=qs[_0x6554('0x28')](_0x5510a9[_0x6554('0x37')][_0x6554('0x28')]);_0x37d50b['offset']=qs['offset'](_0x5510a9[_0x6554('0x37')][_0x6554('0x27')]);}return _0x3f4ae2[_0x6554('0x52')](_0x37d50b);}})[_0x6554('0x18')](function(_0x3c2ed7){if(_0x3c2ed7){return _0x3c2ed7?{'count':_0x2b52c2,'rows':_0x3c2ed7}:null;}})[_0x6554('0x18')](respondWithResult(_0x3be5a9,null))[_0x6554('0x22')](handleError(_0x3be5a9,null));};exports[_0x6554('0x54')]=function(_0x531779,_0x22bf3b,_0x3952a3){var _0x32012e={};var _0x31111d={};var _0x1cdc31;var _0x443522;return db[_0x6554('0x30')][_0x6554('0x53')]({'where':{'id':_0x531779[_0x6554('0x4d')]['id']}})['then'](handleEntityNotFound(_0x22bf3b,null))[_0x6554('0x18')](function(_0x5b7022){if(_0x5b7022){_0x1cdc31=_0x5b7022;_0x31111d[_0x6554('0x35')]=_[_0x6554('0x38')](db[_0x6554('0x55')][_0x6554('0x31')]);_0x31111d['query']=_[_0x6554('0x38')](_0x531779[_0x6554('0x37')]);_0x31111d['filters']=_[_0x6554('0x3a')](_0x31111d['model'],_0x31111d[_0x6554('0x37')]);_0x32012e[_0x6554('0x3b')]=_[_0x6554('0x3a')](_0x31111d[_0x6554('0x35')],qs[_0x6554('0x3c')](_0x531779[_0x6554('0x37')][_0x6554('0x3c')]));_0x32012e[_0x6554('0x3b')]=_0x32012e[_0x6554('0x3b')][_0x6554('0x3d')]?_0x32012e[_0x6554('0x3b')]:_0x31111d[_0x6554('0x35')];_0x32012e['order']=qs[_0x6554('0x41')](_0x531779[_0x6554('0x37')][_0x6554('0x41')]);_0x32012e[_0x6554('0x44')]=qs['filters'](_[_0x6554('0x42')](_0x531779[_0x6554('0x37')],_0x31111d[_0x6554('0x39')]));if(_0x531779[_0x6554('0x37')][_0x6554('0x43')]){_0x32012e[_0x6554('0x44')]=_[_0x6554('0x45')](_0x32012e[_0x6554('0x44')],{'$or':_[_0x6554('0x36')](_0x32012e[_0x6554('0x3b')],function(_0x3fc57f){var _0x4febca={};_0x4febca[_0x3fc57f]={'$like':'%'+_0x531779['query']['filter']+'%'};return _0x4febca;})});}_0x32012e=_[_0x6554('0x45')]({},_0x32012e,_0x531779['options']);return _0x1cdc31[_0x6554('0x54')](_0x32012e);}})['then'](function(_0x3cd73e){if(_0x3cd73e){_0x443522=_0x3cd73e[_0x6554('0x3d')];if(!_0x531779['query'][_0x6554('0x3e')](_0x6554('0x3f'))){_0x32012e[_0x6554('0x28')]=qs[_0x6554('0x28')](_0x531779[_0x6554('0x37')][_0x6554('0x28')]);_0x32012e[_0x6554('0x27')]=qs['offset'](_0x531779['query']['offset']);}return _0x1cdc31[_0x6554('0x54')](_0x32012e);}})[_0x6554('0x18')](function(_0x808b66){if(_0x808b66){return _0x808b66?{'count':_0x443522,'rows':_0x808b66}:null;}})[_0x6554('0x18')](respondWithResult(_0x22bf3b,null))[_0x6554('0x22')](handleError(_0x22bf3b,null));};
\ No newline at end of file
+var _0xc776=['fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/license/util','sendStatus','status','json','offset','undefined','limit','count','apply','reject','save','update','then','end','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','length','nolimit','order','sort','where','pick','filter','merge','options','includeAll','include','SugarcrmConfiguration','findAll','rows','catch','show','params','keys','fields','find','create','body','findOne','getFields','hasOwnProperty','SugarcrmField','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv'];(function(_0xe8717e,_0x3e4490){var _0x35fe19=function(_0x586c18){while(--_0x586c18){_0xe8717e['push'](_0xe8717e['shift']());}};_0x35fe19(++_0x3e4490);}(_0xc776,0x18a));var _0x6c77=function(_0x3fd60a,_0x217502){_0x3fd60a=_0x3fd60a-0x0;var _0x2aa415=_0xc776[_0x3fd60a];return _0x2aa415;};'use strict';var emlformat=require(_0x6c77('0x0'));var rimraf=require(_0x6c77('0x1'));var zipdir=require(_0x6c77('0x2'));var jsonpatch=require(_0x6c77('0x3'));var rp=require(_0x6c77('0x4'));var moment=require(_0x6c77('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x6c77('0x6'));var util=require(_0x6c77('0x7'));var path=require(_0x6c77('0x8'));var sox=require(_0x6c77('0x9'));var csv=require(_0x6c77('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x6c77('0xb'));var _=require(_0x6c77('0xc'));var squel=require(_0x6c77('0xd'));var crypto=require(_0x6c77('0xe'));var jsforce=require(_0x6c77('0xf'));var deskjs=require(_0x6c77('0x10'));var toCsv=require(_0x6c77('0xa'));var querystring=require(_0x6c77('0x11'));var Papa=require(_0x6c77('0x12'));var Redis=require(_0x6c77('0x13'));var authService=require(_0x6c77('0x14'));var qs=require(_0x6c77('0x15'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x6c77('0x16'))(_0x6c77('0x17'));var utils=require('../../config/utils');var config=require(_0x6c77('0x18'));var licenseUtil=require(_0x6c77('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x43bf53,_0x3fc944){_0x3fc944=_0x3fc944||0xcc;return function(_0xc9b555){if(_0xc9b555){return _0x43bf53[_0x6c77('0x1a')](_0x3fc944);}return _0x43bf53[_0x6c77('0x1b')](_0x3fc944)['end']();};}function respondWithResult(_0x45c16c,_0x3a9034){_0x3a9034=_0x3a9034||0xc8;return function(_0x5eee2a){if(_0x5eee2a){return _0x45c16c[_0x6c77('0x1b')](_0x3a9034)[_0x6c77('0x1c')](_0x5eee2a);}};}function respondWithFilteredResult(_0x3952c4,_0x26dd41){return function(_0x737a87){if(_0x737a87){var _0x44ba2b=typeof _0x26dd41[_0x6c77('0x1d')]===_0x6c77('0x1e')&&typeof _0x26dd41[_0x6c77('0x1f')]==='undefined';var _0x4fbaad=_0x737a87[_0x6c77('0x20')];var _0xc64982=_0x44ba2b?0x0:_0x26dd41[_0x6c77('0x1d')];var _0x43f4ec=_0x44ba2b?_0x737a87['count']:_0x26dd41[_0x6c77('0x1d')]+_0x26dd41[_0x6c77('0x1f')];var _0x1df74a;if(_0x43f4ec>=_0x4fbaad){_0x43f4ec=_0x4fbaad;_0x1df74a=0xc8;}else{_0x1df74a=0xce;}_0x3952c4['status'](_0x1df74a);return _0x3952c4['set']('Content-Range',_0xc64982+'-'+_0x43f4ec+'/'+_0x4fbaad)[_0x6c77('0x1c')](_0x737a87);}return null;};}function patchUpdates(_0x530ec6){return function(_0x40efa0){try{jsonpatch[_0x6c77('0x21')](_0x40efa0,_0x530ec6,!![]);}catch(_0x562b58){return BPromise[_0x6c77('0x22')](_0x562b58);}return _0x40efa0[_0x6c77('0x23')]();};}function saveUpdates(_0x358099,_0x1ba542){return function(_0x5d0de0){if(_0x5d0de0){return _0x5d0de0[_0x6c77('0x24')](_0x358099)[_0x6c77('0x25')](function(_0x1846b5){return _0x1846b5;});}return null;};}function removeEntity(_0x4e4ca4,_0x325dc1){return function(_0x33e99c){if(_0x33e99c){return _0x33e99c['destroy']()[_0x6c77('0x25')](function(){_0x4e4ca4['status'](0xcc)[_0x6c77('0x26')]();});}};}function handleEntityNotFound(_0x24566c,_0x4fd58d){return function(_0x1a412f){if(!_0x1a412f){_0x24566c[_0x6c77('0x1a')](0x194);}return _0x1a412f;};}function handleError(_0x55655f,_0x403891){_0x403891=_0x403891||0x1f4;return function(_0x509bb4){logger['error'](_0x509bb4[_0x6c77('0x27')]);if(_0x509bb4[_0x6c77('0x28')]){delete _0x509bb4[_0x6c77('0x28')];}_0x55655f[_0x6c77('0x1b')](_0x403891)[_0x6c77('0x29')](_0x509bb4);};}exports[_0x6c77('0x2a')]=function(_0x2ccb6a,_0x1c6cc6){var _0x17d88a={},_0x3d0567={},_0x166ec6={'count':0x0,'rows':[]};var _0x133a84=_[_0x6c77('0x2b')](db['SugarcrmConfiguration'][_0x6c77('0x2c')],function(_0x1118ae){return{'name':_0x1118ae[_0x6c77('0x2d')],'type':_0x1118ae[_0x6c77('0x2e')][_0x6c77('0x2f')]};});_0x3d0567[_0x6c77('0x30')]=_[_0x6c77('0x2b')](_0x133a84,_0x6c77('0x28'));_0x3d0567[_0x6c77('0x31')]=_['keys'](_0x2ccb6a[_0x6c77('0x31')]);_0x3d0567[_0x6c77('0x32')]=_[_0x6c77('0x33')](_0x3d0567[_0x6c77('0x30')],_0x3d0567[_0x6c77('0x31')]);_0x17d88a[_0x6c77('0x34')]=_[_0x6c77('0x33')](_0x3d0567[_0x6c77('0x30')],qs['fields'](_0x2ccb6a[_0x6c77('0x31')]['fields']));_0x17d88a[_0x6c77('0x34')]=_0x17d88a[_0x6c77('0x34')][_0x6c77('0x35')]?_0x17d88a[_0x6c77('0x34')]:_0x3d0567[_0x6c77('0x30')];if(!_0x2ccb6a['query']['hasOwnProperty'](_0x6c77('0x36'))){_0x17d88a['limit']=qs[_0x6c77('0x1f')](_0x2ccb6a[_0x6c77('0x31')][_0x6c77('0x1f')]);_0x17d88a[_0x6c77('0x1d')]=qs[_0x6c77('0x1d')](_0x2ccb6a[_0x6c77('0x31')][_0x6c77('0x1d')]);}_0x17d88a[_0x6c77('0x37')]=qs[_0x6c77('0x38')](_0x2ccb6a[_0x6c77('0x31')][_0x6c77('0x38')]);_0x17d88a[_0x6c77('0x39')]=qs[_0x6c77('0x32')](_[_0x6c77('0x3a')](_0x2ccb6a[_0x6c77('0x31')],_0x3d0567['filters']),_0x133a84);if(_0x2ccb6a[_0x6c77('0x31')][_0x6c77('0x3b')]){_0x17d88a[_0x6c77('0x39')]=_['merge'](_0x17d88a[_0x6c77('0x39')],{'$or':_['map'](_0x133a84,function(_0x221266){if(_0x221266[_0x6c77('0x2e')]!=='VIRTUAL'){var _0x3c048d={};_0x3c048d[_0x221266[_0x6c77('0x28')]]={'$like':'%'+_0x2ccb6a['query'][_0x6c77('0x3b')]+'%'};return _0x3c048d;}})});}_0x17d88a=_[_0x6c77('0x3c')]({},_0x17d88a,_0x2ccb6a[_0x6c77('0x3d')]);var _0x23af76={'where':_0x17d88a['where']};return db['SugarcrmConfiguration'][_0x6c77('0x20')](_0x23af76)[_0x6c77('0x25')](function(_0x512612){_0x166ec6[_0x6c77('0x20')]=_0x512612;if(_0x2ccb6a['query'][_0x6c77('0x3e')]){_0x17d88a[_0x6c77('0x3f')]=[{'all':!![]}];}return db[_0x6c77('0x40')][_0x6c77('0x41')](_0x17d88a);})['then'](function(_0x439767){_0x166ec6[_0x6c77('0x42')]=_0x439767;return _0x166ec6;})[_0x6c77('0x25')](respondWithFilteredResult(_0x1c6cc6,_0x17d88a))[_0x6c77('0x43')](handleError(_0x1c6cc6,null));};exports[_0x6c77('0x44')]=function(_0x5f39c2,_0x218e00){var _0x29609c={'raw':![],'where':{'id':_0x5f39c2[_0x6c77('0x45')]['id']}},_0x248c48={};_0x248c48[_0x6c77('0x30')]=_['keys'](db[_0x6c77('0x40')][_0x6c77('0x2c')]);_0x248c48[_0x6c77('0x31')]=_[_0x6c77('0x46')](_0x5f39c2[_0x6c77('0x31')]);_0x248c48[_0x6c77('0x32')]=_[_0x6c77('0x33')](_0x248c48[_0x6c77('0x30')],_0x248c48[_0x6c77('0x31')]);_0x29609c['attributes']=_[_0x6c77('0x33')](_0x248c48[_0x6c77('0x30')],qs['fields'](_0x5f39c2[_0x6c77('0x31')][_0x6c77('0x47')]));_0x29609c[_0x6c77('0x34')]=_0x29609c[_0x6c77('0x34')][_0x6c77('0x35')]?_0x29609c[_0x6c77('0x34')]:_0x248c48[_0x6c77('0x30')];if(_0x5f39c2[_0x6c77('0x31')]['includeAll']){_0x29609c[_0x6c77('0x3f')]=[{'all':!![]}];}_0x29609c=_[_0x6c77('0x3c')]({},_0x29609c,_0x5f39c2[_0x6c77('0x3d')]);return db['SugarcrmConfiguration'][_0x6c77('0x48')](_0x29609c)[_0x6c77('0x25')](handleEntityNotFound(_0x218e00,null))[_0x6c77('0x25')](respondWithResult(_0x218e00,null))['catch'](handleError(_0x218e00,null));};exports[_0x6c77('0x49')]=function(_0x717fa4,_0x709dbb){return db[_0x6c77('0x40')][_0x6c77('0x49')](_0x717fa4[_0x6c77('0x4a')],{})[_0x6c77('0x25')](respondWithResult(_0x709dbb,0xc9))[_0x6c77('0x43')](handleError(_0x709dbb,null));};exports[_0x6c77('0x24')]=function(_0x625a9f,_0x49bf05){if(_0x625a9f[_0x6c77('0x4a')]['id']){delete _0x625a9f[_0x6c77('0x4a')]['id'];}return db['SugarcrmConfiguration'][_0x6c77('0x48')]({'where':{'id':_0x625a9f[_0x6c77('0x45')]['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0x49bf05,null))['then'](saveUpdates(_0x625a9f['body'],null))[_0x6c77('0x25')](respondWithResult(_0x49bf05,null))[_0x6c77('0x43')](handleError(_0x49bf05,null));};exports['destroy']=function(_0x4c1f25,_0x570964){return db[_0x6c77('0x40')]['find']({'where':{'id':_0x4c1f25['params']['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0x570964,null))[_0x6c77('0x25')](removeEntity(_0x570964,null))[_0x6c77('0x43')](handleError(_0x570964,null));};exports['getFields']=function(_0x134ff9,_0x5ae7d9,_0x3477b9){var _0x316b5c={};var _0x299bcf={};var _0x4fbd6f;var _0x45116a;return db['SugarcrmConfiguration'][_0x6c77('0x4b')]({'where':{'id':_0x134ff9['params']['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0x5ae7d9,null))['then'](function(_0x189f82){if(_0x189f82){_0x4fbd6f=_0x189f82;_0x299bcf[_0x6c77('0x30')]=_[_0x6c77('0x46')](db['SugarcrmField'][_0x6c77('0x2c')]);_0x299bcf['query']=_['keys'](_0x134ff9[_0x6c77('0x31')]);_0x299bcf[_0x6c77('0x32')]=_[_0x6c77('0x33')](_0x299bcf[_0x6c77('0x30')],_0x299bcf['query']);_0x316b5c[_0x6c77('0x34')]=_[_0x6c77('0x33')](_0x299bcf[_0x6c77('0x30')],qs[_0x6c77('0x47')](_0x134ff9['query'][_0x6c77('0x47')]));_0x316b5c['attributes']=_0x316b5c[_0x6c77('0x34')][_0x6c77('0x35')]?_0x316b5c[_0x6c77('0x34')]:_0x299bcf['model'];_0x316b5c[_0x6c77('0x37')]=qs['sort'](_0x134ff9[_0x6c77('0x31')][_0x6c77('0x38')]);_0x316b5c[_0x6c77('0x39')]=qs['filters'](_[_0x6c77('0x3a')](_0x134ff9['query'],_0x299bcf[_0x6c77('0x32')]));if(_0x134ff9['query']['filter']){_0x316b5c[_0x6c77('0x39')]=_[_0x6c77('0x3c')](_0x316b5c[_0x6c77('0x39')],{'$or':_[_0x6c77('0x2b')](_0x316b5c[_0x6c77('0x34')],function(_0x53105b){var _0x1bf3f3={};_0x1bf3f3[_0x53105b]={'$like':'%'+_0x134ff9[_0x6c77('0x31')][_0x6c77('0x3b')]+'%'};return _0x1bf3f3;})});}_0x316b5c=_['merge']({},_0x316b5c,_0x134ff9['options']);return _0x4fbd6f[_0x6c77('0x4c')](_0x316b5c);}})[_0x6c77('0x25')](function(_0x4f7b3e){if(_0x4f7b3e){_0x45116a=_0x4f7b3e[_0x6c77('0x35')];if(!_0x134ff9[_0x6c77('0x31')][_0x6c77('0x4d')](_0x6c77('0x36'))){_0x316b5c[_0x6c77('0x1f')]=qs[_0x6c77('0x1f')](_0x134ff9['query'][_0x6c77('0x1f')]);_0x316b5c[_0x6c77('0x1d')]=qs[_0x6c77('0x1d')](_0x134ff9['query'][_0x6c77('0x1d')]);}return _0x4fbd6f[_0x6c77('0x4c')](_0x316b5c);}})[_0x6c77('0x25')](function(_0x52ced0){if(_0x52ced0){return _0x52ced0?{'count':_0x45116a,'rows':_0x52ced0}:null;}})[_0x6c77('0x25')](respondWithResult(_0x5ae7d9,null))[_0x6c77('0x43')](handleError(_0x5ae7d9,null));};exports['getSubjects']=function(_0x41cb8a,_0xb2f3ed,_0xd7feb){var _0x45ed05={};var _0x2fe1ff={};var _0xf10ffe;var _0x411e9e;return db[_0x6c77('0x40')]['findOne']({'where':{'id':_0x41cb8a[_0x6c77('0x45')]['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0xb2f3ed,null))[_0x6c77('0x25')](function(_0x13630f){if(_0x13630f){_0xf10ffe=_0x13630f;_0x2fe1ff[_0x6c77('0x30')]=_[_0x6c77('0x46')](db[_0x6c77('0x4e')]['rawAttributes']);_0x2fe1ff[_0x6c77('0x31')]=_[_0x6c77('0x46')](_0x41cb8a[_0x6c77('0x31')]);_0x2fe1ff['filters']=_['intersection'](_0x2fe1ff[_0x6c77('0x30')],_0x2fe1ff[_0x6c77('0x31')]);_0x45ed05['attributes']=_['intersection'](_0x2fe1ff[_0x6c77('0x30')],qs[_0x6c77('0x47')](_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x47')]));_0x45ed05[_0x6c77('0x34')]=_0x45ed05[_0x6c77('0x34')][_0x6c77('0x35')]?_0x45ed05[_0x6c77('0x34')]:_0x2fe1ff[_0x6c77('0x30')];_0x45ed05['order']=qs[_0x6c77('0x38')](_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x38')]);_0x45ed05['where']=qs[_0x6c77('0x32')](_['pick'](_0x41cb8a['query'],_0x2fe1ff[_0x6c77('0x32')]));if(_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x3b')]){_0x45ed05[_0x6c77('0x39')]=_['merge'](_0x45ed05['where'],{'$or':_[_0x6c77('0x2b')](_0x45ed05[_0x6c77('0x34')],function(_0x2c2de4){var _0x42c7a1={};_0x42c7a1[_0x2c2de4]={'$like':'%'+_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x3b')]+'%'};return _0x42c7a1;})});}_0x45ed05=_[_0x6c77('0x3c')]({},_0x45ed05,_0x41cb8a[_0x6c77('0x3d')]);return _0xf10ffe[_0x6c77('0x4f')](_0x45ed05);}})['then'](function(_0x3b8a3b){if(_0x3b8a3b){_0x411e9e=_0x3b8a3b[_0x6c77('0x35')];if(!_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x4d')](_0x6c77('0x36'))){_0x45ed05['limit']=qs[_0x6c77('0x1f')](_0x41cb8a[_0x6c77('0x31')]['limit']);_0x45ed05[_0x6c77('0x1d')]=qs[_0x6c77('0x1d')](_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x1d')]);}return _0xf10ffe[_0x6c77('0x4f')](_0x45ed05);}})[_0x6c77('0x25')](function(_0x20fc0b){if(_0x20fc0b){return _0x20fc0b?{'count':_0x411e9e,'rows':_0x20fc0b}:null;}})[_0x6c77('0x25')](respondWithResult(_0xb2f3ed,null))[_0x6c77('0x43')](handleError(_0xb2f3ed,null));};exports[_0x6c77('0x50')]=function(_0x2970de,_0x2a5f0d,_0x4e7c0d){var _0x2a07df={};var _0x1b0cff={};var _0x438c10;var _0x360577;return db['SugarcrmConfiguration']['findOne']({'where':{'id':_0x2970de[_0x6c77('0x45')]['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0x2a5f0d,null))['then'](function(_0xc6debb){if(_0xc6debb){_0x438c10=_0xc6debb;_0x1b0cff[_0x6c77('0x30')]=_[_0x6c77('0x46')](db['SugarcrmField'][_0x6c77('0x2c')]);_0x1b0cff[_0x6c77('0x31')]=_[_0x6c77('0x46')](_0x2970de[_0x6c77('0x31')]);_0x1b0cff['filters']=_['intersection'](_0x1b0cff['model'],_0x1b0cff[_0x6c77('0x31')]);_0x2a07df[_0x6c77('0x34')]=_[_0x6c77('0x33')](_0x1b0cff[_0x6c77('0x30')],qs[_0x6c77('0x47')](_0x2970de[_0x6c77('0x31')]['fields']));_0x2a07df['attributes']=_0x2a07df[_0x6c77('0x34')][_0x6c77('0x35')]?_0x2a07df[_0x6c77('0x34')]:_0x1b0cff[_0x6c77('0x30')];_0x2a07df['order']=qs[_0x6c77('0x38')](_0x2970de['query'][_0x6c77('0x38')]);_0x2a07df[_0x6c77('0x39')]=qs['filters'](_[_0x6c77('0x3a')](_0x2970de[_0x6c77('0x31')],_0x1b0cff[_0x6c77('0x32')]));if(_0x2970de['query'][_0x6c77('0x3b')]){_0x2a07df['where']=_[_0x6c77('0x3c')](_0x2a07df[_0x6c77('0x39')],{'$or':_['map'](_0x2a07df[_0x6c77('0x34')],function(_0x1f5856){var _0x76c9f={};_0x76c9f[_0x1f5856]={'$like':'%'+_0x2970de[_0x6c77('0x31')][_0x6c77('0x3b')]+'%'};return _0x76c9f;})});}_0x2a07df=_['merge']({},_0x2a07df,_0x2970de[_0x6c77('0x3d')]);return _0x438c10[_0x6c77('0x50')](_0x2a07df);}})[_0x6c77('0x25')](function(_0x57cf1d){if(_0x57cf1d){_0x360577=_0x57cf1d['length'];if(!_0x2970de[_0x6c77('0x31')][_0x6c77('0x4d')](_0x6c77('0x36'))){_0x2a07df[_0x6c77('0x1f')]=qs[_0x6c77('0x1f')](_0x2970de[_0x6c77('0x31')][_0x6c77('0x1f')]);_0x2a07df['offset']=qs[_0x6c77('0x1d')](_0x2970de[_0x6c77('0x31')][_0x6c77('0x1d')]);}return _0x438c10[_0x6c77('0x50')](_0x2a07df);}})['then'](function(_0x58817d){if(_0x58817d){return _0x58817d?{'count':_0x360577,'rows':_0x58817d}:null;}})[_0x6c77('0x25')](respondWithResult(_0x2a5f0d,null))['catch'](handleError(_0x2a5f0d,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff