// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xcdcb=['hasOwnProperty','nolimit','order','sort','where','filter','VIRTUAL','merge','options','count','includeAll','include','rows','catch','show','params','length','find','create','body','getFields','findOne','rawAttributes','pick','getSubjects','SugarcrmField','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','status','end','json','offset','undefined','limit','apply','save','update','then','error','stack','name','send','index','map','SugarcrmConfiguration','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields'];(function(_0x59f644,_0x4ab87f){var _0x117b65=function(_0x33d141){while(--_0x33d141){_0x59f644['push'](_0x59f644['shift']());}};_0x117b65(++_0x4ab87f);}(_0xcdcb,0x1b5));var _0xbcdc=function(_0x1eabf8,_0x100761){_0x1eabf8=_0x1eabf8-0x0;var _0x1873a1=_0xcdcb[_0x1eabf8];return _0x1873a1;};'use strict';var emlformat=require(_0xbcdc('0x0'));var rimraf=require(_0xbcdc('0x1'));var zipdir=require(_0xbcdc('0x2'));var jsonpatch=require(_0xbcdc('0x3'));var rp=require(_0xbcdc('0x4'));var moment=require(_0xbcdc('0x5'));var BPromise=require(_0xbcdc('0x6'));var Mustache=require(_0xbcdc('0x7'));var util=require(_0xbcdc('0x8'));var path=require(_0xbcdc('0x9'));var sox=require(_0xbcdc('0xa'));var csv=require(_0xbcdc('0xb'));var ejs=require(_0xbcdc('0xc'));var fs=require('fs');var fs_extra=require(_0xbcdc('0xd'));var _=require(_0xbcdc('0xe'));var squel=require(_0xbcdc('0xf'));var crypto=require(_0xbcdc('0x10'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xbcdc('0x11'));var Redis=require('ioredis');var authService=require(_0xbcdc('0x12'));var qs=require(_0xbcdc('0x13'));var as=require(_0xbcdc('0x14'));var hardwareService=require(_0xbcdc('0x15'));var logger=require(_0xbcdc('0x16'))(_0xbcdc('0x17'));var utils=require(_0xbcdc('0x18'));var config=require(_0xbcdc('0x19'));var licenseUtil=require(_0xbcdc('0x1a'));var db=require(_0xbcdc('0x1b'))['db'];function respondWithStatusCode(_0x7683a3,_0x1c2bbb){_0x1c2bbb=_0x1c2bbb||0xcc;return function(_0x50bff7){if(_0x50bff7){return _0x7683a3['sendStatus'](_0x1c2bbb);}return _0x7683a3[_0xbcdc('0x1c')](_0x1c2bbb)[_0xbcdc('0x1d')]();};}function respondWithResult(_0x5e5c00,_0x74b212){_0x74b212=_0x74b212||0xc8;return function(_0x4316a4){if(_0x4316a4){return _0x5e5c00[_0xbcdc('0x1c')](_0x74b212)[_0xbcdc('0x1e')](_0x4316a4);}};}function respondWithFilteredResult(_0x34d257,_0x24abbe){return function(_0x5f0cd3){if(_0x5f0cd3){var _0x2cdbd7=typeof _0x24abbe[_0xbcdc('0x1f')]===_0xbcdc('0x20')&&typeof _0x24abbe[_0xbcdc('0x21')]===_0xbcdc('0x20');var _0x238a7f=_0x5f0cd3['count'];var _0x293b47=_0x2cdbd7?0x0:_0x24abbe[_0xbcdc('0x1f')];var _0x2ba13e=_0x2cdbd7?_0x5f0cd3['count']:_0x24abbe[_0xbcdc('0x1f')]+_0x24abbe[_0xbcdc('0x21')];var _0x440d2f;if(_0x2ba13e>=_0x238a7f){_0x2ba13e=_0x238a7f;_0x440d2f=0xc8;}else{_0x440d2f=0xce;}_0x34d257[_0xbcdc('0x1c')](_0x440d2f);return _0x34d257['set']('Content-Range',_0x293b47+'-'+_0x2ba13e+'/'+_0x238a7f)[_0xbcdc('0x1e')](_0x5f0cd3);}return null;};}function patchUpdates(_0x1859d0){return function(_0x59d031){try{jsonpatch[_0xbcdc('0x22')](_0x59d031,_0x1859d0,!![]);}catch(_0x4d5bf9){return BPromise['reject'](_0x4d5bf9);}return _0x59d031[_0xbcdc('0x23')]();};}function saveUpdates(_0x580651,_0x1d4bff){return function(_0x4a1bd6){if(_0x4a1bd6){return _0x4a1bd6[_0xbcdc('0x24')](_0x580651)[_0xbcdc('0x25')](function(_0x3fdace){return _0x3fdace;});}return null;};}function removeEntity(_0x597f92,_0x3ff120){return function(_0x12fe09){if(_0x12fe09){return _0x12fe09['destroy']()[_0xbcdc('0x25')](function(){_0x597f92['status'](0xcc)[_0xbcdc('0x1d')]();});}};}function handleEntityNotFound(_0x2db4ea,_0x338bb8){return function(_0x48d364){if(!_0x48d364){_0x2db4ea['sendStatus'](0x194);}return _0x48d364;};}function handleError(_0x465bae,_0x2c84aa){_0x2c84aa=_0x2c84aa||0x1f4;return function(_0x1ff812){logger[_0xbcdc('0x26')](_0x1ff812[_0xbcdc('0x27')]);if(_0x1ff812['name']){delete _0x1ff812[_0xbcdc('0x28')];}_0x465bae[_0xbcdc('0x1c')](_0x2c84aa)[_0xbcdc('0x29')](_0x1ff812);};}exports[_0xbcdc('0x2a')]=function(_0x37c90d,_0x38507c){var _0x333ead={},_0x4c88fa={},_0x1aa29d={'count':0x0,'rows':[]};var _0x4dacb4=_[_0xbcdc('0x2b')](db[_0xbcdc('0x2c')]['rawAttributes'],function(_0x1fc98e){return{'name':_0x1fc98e[_0xbcdc('0x2d')],'type':_0x1fc98e[_0xbcdc('0x2e')][_0xbcdc('0x2f')]};});_0x4c88fa[_0xbcdc('0x30')]=_[_0xbcdc('0x2b')](_0x4dacb4,'name');_0x4c88fa[_0xbcdc('0x31')]=_[_0xbcdc('0x32')](_0x37c90d[_0xbcdc('0x31')]);_0x4c88fa[_0xbcdc('0x33')]=_[_0xbcdc('0x34')](_0x4c88fa[_0xbcdc('0x30')],_0x4c88fa[_0xbcdc('0x31')]);_0x333ead[_0xbcdc('0x35')]=_[_0xbcdc('0x34')](_0x4c88fa[_0xbcdc('0x30')],qs[_0xbcdc('0x36')](_0x37c90d[_0xbcdc('0x31')]['fields']));_0x333ead[_0xbcdc('0x35')]=_0x333ead[_0xbcdc('0x35')]['length']?_0x333ead['attributes']:_0x4c88fa[_0xbcdc('0x30')];if(!_0x37c90d['query'][_0xbcdc('0x37')](_0xbcdc('0x38'))){_0x333ead['limit']=qs['limit'](_0x37c90d[_0xbcdc('0x31')][_0xbcdc('0x21')]);_0x333ead[_0xbcdc('0x1f')]=qs['offset'](_0x37c90d['query'][_0xbcdc('0x1f')]);}_0x333ead[_0xbcdc('0x39')]=qs['sort'](_0x37c90d[_0xbcdc('0x31')][_0xbcdc('0x3a')]);_0x333ead[_0xbcdc('0x3b')]=qs[_0xbcdc('0x33')](_['pick'](_0x37c90d[_0xbcdc('0x31')],_0x4c88fa['filters']),_0x4dacb4);if(_0x37c90d['query'][_0xbcdc('0x3c')]){_0x333ead[_0xbcdc('0x3b')]=_['merge'](_0x333ead[_0xbcdc('0x3b')],{'$or':_[_0xbcdc('0x2b')](_0x4dacb4,function(_0x34504f){if(_0x34504f[_0xbcdc('0x2e')]!==_0xbcdc('0x3d')){var _0xcde895={};_0xcde895[_0x34504f[_0xbcdc('0x28')]]={'$like':'%'+_0x37c90d[_0xbcdc('0x31')][_0xbcdc('0x3c')]+'%'};return _0xcde895;}})});}_0x333ead=_[_0xbcdc('0x3e')]({},_0x333ead,_0x37c90d[_0xbcdc('0x3f')]);var _0x115131={'where':_0x333ead[_0xbcdc('0x3b')]};return db[_0xbcdc('0x2c')][_0xbcdc('0x40')](_0x115131)[_0xbcdc('0x25')](function(_0xe80c32){_0x1aa29d[_0xbcdc('0x40')]=_0xe80c32;if(_0x37c90d[_0xbcdc('0x31')][_0xbcdc('0x41')]){_0x333ead[_0xbcdc('0x42')]=[{'all':!![]}];}return db[_0xbcdc('0x2c')]['findAll'](_0x333ead);})[_0xbcdc('0x25')](function(_0x596730){_0x1aa29d[_0xbcdc('0x43')]=_0x596730;return _0x1aa29d;})[_0xbcdc('0x25')](respondWithFilteredResult(_0x38507c,_0x333ead))[_0xbcdc('0x44')](handleError(_0x38507c,null));};exports[_0xbcdc('0x45')]=function(_0x2a3565,_0x4e06f7){var _0x2db299={'raw':![],'where':{'id':_0x2a3565[_0xbcdc('0x46')]['id']}},_0x456510={};_0x456510[_0xbcdc('0x30')]=_[_0xbcdc('0x32')](db[_0xbcdc('0x2c')]['rawAttributes']);_0x456510[_0xbcdc('0x31')]=_[_0xbcdc('0x32')](_0x2a3565[_0xbcdc('0x31')]);_0x456510[_0xbcdc('0x33')]=_[_0xbcdc('0x34')](_0x456510['model'],_0x456510['query']);_0x2db299[_0xbcdc('0x35')]=_[_0xbcdc('0x34')](_0x456510[_0xbcdc('0x30')],qs[_0xbcdc('0x36')](_0x2a3565[_0xbcdc('0x31')][_0xbcdc('0x36')]));_0x2db299['attributes']=_0x2db299['attributes'][_0xbcdc('0x47')]?_0x2db299['attributes']:_0x456510[_0xbcdc('0x30')];if(_0x2a3565[_0xbcdc('0x31')][_0xbcdc('0x41')]){_0x2db299[_0xbcdc('0x42')]=[{'all':!![]}];}_0x2db299=_['merge']({},_0x2db299,_0x2a3565[_0xbcdc('0x3f')]);return db[_0xbcdc('0x2c')][_0xbcdc('0x48')](_0x2db299)['then'](handleEntityNotFound(_0x4e06f7,null))[_0xbcdc('0x25')](respondWithResult(_0x4e06f7,null))[_0xbcdc('0x44')](handleError(_0x4e06f7,null));};exports[_0xbcdc('0x49')]=function(_0x1032fc,_0x3a1c07){return db[_0xbcdc('0x2c')]['create'](_0x1032fc[_0xbcdc('0x4a')],{})[_0xbcdc('0x25')](respondWithResult(_0x3a1c07,0xc9))['catch'](handleError(_0x3a1c07,null));};exports[_0xbcdc('0x24')]=function(_0x4c8f41,_0x51c5aa){if(_0x4c8f41['body']['id']){delete _0x4c8f41['body']['id'];}return db[_0xbcdc('0x2c')][_0xbcdc('0x48')]({'where':{'id':_0x4c8f41[_0xbcdc('0x46')]['id']}})[_0xbcdc('0x25')](handleEntityNotFound(_0x51c5aa,null))[_0xbcdc('0x25')](saveUpdates(_0x4c8f41[_0xbcdc('0x4a')],null))[_0xbcdc('0x25')](respondWithResult(_0x51c5aa,null))[_0xbcdc('0x44')](handleError(_0x51c5aa,null));};exports['destroy']=function(_0x58410c,_0x384c34){return db[_0xbcdc('0x2c')][_0xbcdc('0x48')]({'where':{'id':_0x58410c[_0xbcdc('0x46')]['id']}})['then'](handleEntityNotFound(_0x384c34,null))[_0xbcdc('0x25')](removeEntity(_0x384c34,null))[_0xbcdc('0x44')](handleError(_0x384c34,null));};exports[_0xbcdc('0x4b')]=function(_0x2122a2,_0x3e9264,_0x3eff2d){var _0x471a3d={};var _0x18f523={};var _0x1be9e7;var _0x18bfb2;return db[_0xbcdc('0x2c')][_0xbcdc('0x4c')]({'where':{'id':_0x2122a2['params']['id']}})['then'](handleEntityNotFound(_0x3e9264,null))[_0xbcdc('0x25')](function(_0xba163a){if(_0xba163a){_0x1be9e7=_0xba163a;_0x18f523[_0xbcdc('0x30')]=_[_0xbcdc('0x32')](db['SugarcrmField'][_0xbcdc('0x4d')]);_0x18f523[_0xbcdc('0x31')]=_['keys'](_0x2122a2[_0xbcdc('0x31')]);_0x18f523[_0xbcdc('0x33')]=_[_0xbcdc('0x34')](_0x18f523['model'],_0x18f523[_0xbcdc('0x31')]);_0x471a3d[_0xbcdc('0x35')]=_[_0xbcdc('0x34')](_0x18f523['model'],qs[_0xbcdc('0x36')](_0x2122a2[_0xbcdc('0x31')][_0xbcdc('0x36')]));_0x471a3d['attributes']=_0x471a3d['attributes'][_0xbcdc('0x47')]?_0x471a3d['attributes']:_0x18f523[_0xbcdc('0x30')];_0x471a3d['order']=qs['sort'](_0x2122a2['query'][_0xbcdc('0x3a')]);_0x471a3d['where']=qs['filters'](_[_0xbcdc('0x4e')](_0x2122a2[_0xbcdc('0x31')],_0x18f523[_0xbcdc('0x33')]));if(_0x2122a2[_0xbcdc('0x31')]['filter']){_0x471a3d['where']=_[_0xbcdc('0x3e')](_0x471a3d[_0xbcdc('0x3b')],{'$or':_['map'](_0x471a3d['attributes'],function(_0x518a68){var _0x446bc8={};_0x446bc8[_0x518a68]={'$like':'%'+_0x2122a2['query']['filter']+'%'};return _0x446bc8;})});}_0x471a3d=_[_0xbcdc('0x3e')]({},_0x471a3d,_0x2122a2[_0xbcdc('0x3f')]);return _0x1be9e7[_0xbcdc('0x4b')](_0x471a3d);}})[_0xbcdc('0x25')](function(_0x33835d){if(_0x33835d){_0x18bfb2=_0x33835d[_0xbcdc('0x47')];if(!_0x2122a2['query']['hasOwnProperty'](_0xbcdc('0x38'))){_0x471a3d[_0xbcdc('0x21')]=qs[_0xbcdc('0x21')](_0x2122a2[_0xbcdc('0x31')]['limit']);_0x471a3d[_0xbcdc('0x1f')]=qs[_0xbcdc('0x1f')](_0x2122a2[_0xbcdc('0x31')]['offset']);}return _0x1be9e7['getFields'](_0x471a3d);}})['then'](function(_0x54d359){if(_0x54d359){return _0x54d359?{'count':_0x18bfb2,'rows':_0x54d359}:null;}})[_0xbcdc('0x25')](respondWithResult(_0x3e9264,null))[_0xbcdc('0x44')](handleError(_0x3e9264,null));};exports[_0xbcdc('0x4f')]=function(_0x52915c,_0x15a586,_0x177dac){var _0x2b5fa1={};var _0x2f0b5f={};var _0x249453;var _0x442406;return db[_0xbcdc('0x2c')][_0xbcdc('0x4c')]({'where':{'id':_0x52915c['params']['id']}})[_0xbcdc('0x25')](handleEntityNotFound(_0x15a586,null))[_0xbcdc('0x25')](function(_0xfa93a8){if(_0xfa93a8){_0x249453=_0xfa93a8;_0x2f0b5f[_0xbcdc('0x30')]=_[_0xbcdc('0x32')](db[_0xbcdc('0x50')]['rawAttributes']);_0x2f0b5f[_0xbcdc('0x31')]=_['keys'](_0x52915c[_0xbcdc('0x31')]);_0x2f0b5f[_0xbcdc('0x33')]=_[_0xbcdc('0x34')](_0x2f0b5f[_0xbcdc('0x30')],_0x2f0b5f[_0xbcdc('0x31')]);_0x2b5fa1[_0xbcdc('0x35')]=_[_0xbcdc('0x34')](_0x2f0b5f['model'],qs[_0xbcdc('0x36')](_0x52915c[_0xbcdc('0x31')][_0xbcdc('0x36')]));_0x2b5fa1[_0xbcdc('0x35')]=_0x2b5fa1[_0xbcdc('0x35')][_0xbcdc('0x47')]?_0x2b5fa1[_0xbcdc('0x35')]:_0x2f0b5f[_0xbcdc('0x30')];_0x2b5fa1[_0xbcdc('0x39')]=qs[_0xbcdc('0x3a')](_0x52915c[_0xbcdc('0x31')][_0xbcdc('0x3a')]);_0x2b5fa1[_0xbcdc('0x3b')]=qs[_0xbcdc('0x33')](_[_0xbcdc('0x4e')](_0x52915c[_0xbcdc('0x31')],_0x2f0b5f['filters']));if(_0x52915c[_0xbcdc('0x31')][_0xbcdc('0x3c')]){_0x2b5fa1[_0xbcdc('0x3b')]=_[_0xbcdc('0x3e')](_0x2b5fa1[_0xbcdc('0x3b')],{'$or':_[_0xbcdc('0x2b')](_0x2b5fa1[_0xbcdc('0x35')],function(_0x13287b){var _0x507734={};_0x507734[_0x13287b]={'$like':'%'+_0x52915c[_0xbcdc('0x31')][_0xbcdc('0x3c')]+'%'};return _0x507734;})});}_0x2b5fa1=_[_0xbcdc('0x3e')]({},_0x2b5fa1,_0x52915c[_0xbcdc('0x3f')]);return _0x249453[_0xbcdc('0x4f')](_0x2b5fa1);}})[_0xbcdc('0x25')](function(_0x194b61){if(_0x194b61){_0x442406=_0x194b61[_0xbcdc('0x47')];if(!_0x52915c[_0xbcdc('0x31')][_0xbcdc('0x37')](_0xbcdc('0x38'))){_0x2b5fa1[_0xbcdc('0x21')]=qs['limit'](_0x52915c[_0xbcdc('0x31')][_0xbcdc('0x21')]);_0x2b5fa1['offset']=qs[_0xbcdc('0x1f')](_0x52915c[_0xbcdc('0x31')][_0xbcdc('0x1f')]);}return _0x249453['getSubjects'](_0x2b5fa1);}})[_0xbcdc('0x25')](function(_0x542d7c){if(_0x542d7c){return _0x542d7c?{'count':_0x442406,'rows':_0x542d7c}:null;}})[_0xbcdc('0x25')](respondWithResult(_0x15a586,null))[_0xbcdc('0x44')](handleError(_0x15a586,null));};exports['getDescriptions']=function(_0x2317fe,_0xf82c41,_0x3ee0c1){var _0x2ab929={};var _0x51ecb3={};var _0x9edca9;var _0x543d8f;return db[_0xbcdc('0x2c')][_0xbcdc('0x4c')]({'where':{'id':_0x2317fe[_0xbcdc('0x46')]['id']}})[_0xbcdc('0x25')](handleEntityNotFound(_0xf82c41,null))['then'](function(_0x103e44){if(_0x103e44){_0x9edca9=_0x103e44;_0x51ecb3['model']=_['keys'](db[_0xbcdc('0x50')][_0xbcdc('0x4d')]);_0x51ecb3['query']=_[_0xbcdc('0x32')](_0x2317fe['query']);_0x51ecb3['filters']=_[_0xbcdc('0x34')](_0x51ecb3['model'],_0x51ecb3[_0xbcdc('0x31')]);_0x2ab929['attributes']=_['intersection'](_0x51ecb3[_0xbcdc('0x30')],qs[_0xbcdc('0x36')](_0x2317fe[_0xbcdc('0x31')]['fields']));_0x2ab929['attributes']=_0x2ab929['attributes'][_0xbcdc('0x47')]?_0x2ab929[_0xbcdc('0x35')]:_0x51ecb3[_0xbcdc('0x30')];_0x2ab929[_0xbcdc('0x39')]=qs[_0xbcdc('0x3a')](_0x2317fe[_0xbcdc('0x31')][_0xbcdc('0x3a')]);_0x2ab929['where']=qs[_0xbcdc('0x33')](_[_0xbcdc('0x4e')](_0x2317fe[_0xbcdc('0x31')],_0x51ecb3['filters']));if(_0x2317fe[_0xbcdc('0x31')][_0xbcdc('0x3c')]){_0x2ab929['where']=_[_0xbcdc('0x3e')](_0x2ab929[_0xbcdc('0x3b')],{'$or':_[_0xbcdc('0x2b')](_0x2ab929['attributes'],function(_0xd000b6){var _0x2e5c06={};_0x2e5c06[_0xd000b6]={'$like':'%'+_0x2317fe['query']['filter']+'%'};return _0x2e5c06;})});}_0x2ab929=_[_0xbcdc('0x3e')]({},_0x2ab929,_0x2317fe['options']);return _0x9edca9[_0xbcdc('0x51')](_0x2ab929);}})['then'](function(_0x147af6){if(_0x147af6){_0x543d8f=_0x147af6[_0xbcdc('0x47')];if(!_0x2317fe[_0xbcdc('0x31')][_0xbcdc('0x37')](_0xbcdc('0x38'))){_0x2ab929[_0xbcdc('0x21')]=qs[_0xbcdc('0x21')](_0x2317fe['query'][_0xbcdc('0x21')]);_0x2ab929['offset']=qs[_0xbcdc('0x1f')](_0x2317fe[_0xbcdc('0x31')]['offset']);}return _0x9edca9[_0xbcdc('0x51')](_0x2ab929);}})['then'](function(_0x47a30a){if(_0x47a30a){return _0x47a30a?{'count':_0x543d8f,'rows':_0x47a30a}:null;}})[_0xbcdc('0x25')](respondWithResult(_0xf82c41,null))['catch'](handleError(_0xf82c41,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