// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4329=['reject','save','update','then','destroy','sendStatus','stack','name','index','map','SugarcrmConfiguration','rawAttributes','fieldName','type','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','options','include','findAll','rows','params','keys','includeAll','find','catch','create','body','getFields','findOne','SugarcrmField','order','getSubjects','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','end','json','offset','undefined','limit','count','status','set','apply'];(function(_0x3b16e1,_0x3bda3e){var _0x311d1b=function(_0x2a979b){while(--_0x2a979b){_0x3b16e1['push'](_0x3b16e1['shift']());}};_0x311d1b(++_0x3bda3e);}(_0x4329,0x169));var _0x9432=function(_0x30ae5e,_0x391fc4){_0x30ae5e=_0x30ae5e-0x0;var _0x1f2e93=_0x4329[_0x30ae5e];return _0x1f2e93;};'use strict';var emlformat=require(_0x9432('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x9432('0x1'));var jsonpatch=require(_0x9432('0x2'));var rp=require(_0x9432('0x3'));var moment=require(_0x9432('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x9432('0x5'));var util=require(_0x9432('0x6'));var path=require(_0x9432('0x7'));var sox=require(_0x9432('0x8'));var csv=require('to-csv');var ejs=require(_0x9432('0x9'));var fs=require('fs');var fs_extra=require(_0x9432('0xa'));var _=require(_0x9432('0xb'));var squel=require('squel');var crypto=require(_0x9432('0xc'));var jsforce=require(_0x9432('0xd'));var deskjs=require(_0x9432('0xe'));var toCsv=require('to-csv');var querystring=require(_0x9432('0xf'));var Papa=require(_0x9432('0x10'));var Redis=require(_0x9432('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x9432('0x12'));var as=require(_0x9432('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x9432('0x14'))(_0x9432('0x15'));var utils=require(_0x9432('0x16'));var config=require(_0x9432('0x17'));var licenseUtil=require(_0x9432('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2c8486,_0xf1547){_0xf1547=_0xf1547||0xcc;return function(_0x175f70){if(_0x175f70){return _0x2c8486['sendStatus'](_0xf1547);}return _0x2c8486['status'](_0xf1547)[_0x9432('0x19')]();};}function respondWithResult(_0x2e189c,_0x12a8db){_0x12a8db=_0x12a8db||0xc8;return function(_0x33e5e5){if(_0x33e5e5){return _0x2e189c['status'](_0x12a8db)[_0x9432('0x1a')](_0x33e5e5);}};}function respondWithFilteredResult(_0x55a561,_0x2d6aeb){return function(_0x4f6774){if(_0x4f6774){var _0x78c6e8=typeof _0x2d6aeb[_0x9432('0x1b')]===_0x9432('0x1c')&&typeof _0x2d6aeb[_0x9432('0x1d')]===_0x9432('0x1c');var _0xbc1761=_0x4f6774['count'];var _0x509cad=_0x78c6e8?0x0:_0x2d6aeb[_0x9432('0x1b')];var _0x1755ac=_0x78c6e8?_0x4f6774[_0x9432('0x1e')]:_0x2d6aeb[_0x9432('0x1b')]+_0x2d6aeb[_0x9432('0x1d')];var _0x538e08;if(_0x1755ac>=_0xbc1761){_0x1755ac=_0xbc1761;_0x538e08=0xc8;}else{_0x538e08=0xce;}_0x55a561[_0x9432('0x1f')](_0x538e08);return _0x55a561[_0x9432('0x20')]('Content-Range',_0x509cad+'-'+_0x1755ac+'/'+_0xbc1761)[_0x9432('0x1a')](_0x4f6774);}return null;};}function patchUpdates(_0x457a53){return function(_0x4ca6d3){try{jsonpatch[_0x9432('0x21')](_0x4ca6d3,_0x457a53,!![]);}catch(_0x4487a3){return BPromise[_0x9432('0x22')](_0x4487a3);}return _0x4ca6d3[_0x9432('0x23')]();};}function saveUpdates(_0x417b4c,_0x1c1545){return function(_0x1ac44d){if(_0x1ac44d){return _0x1ac44d[_0x9432('0x24')](_0x417b4c)[_0x9432('0x25')](function(_0x3fa877){return _0x3fa877;});}return null;};}function removeEntity(_0x2d024e,_0x3981e3){return function(_0x4d8c07){if(_0x4d8c07){return _0x4d8c07[_0x9432('0x26')]()[_0x9432('0x25')](function(){_0x2d024e[_0x9432('0x1f')](0xcc)[_0x9432('0x19')]();});}};}function handleEntityNotFound(_0x598173,_0x446136){return function(_0x4f931e){if(!_0x4f931e){_0x598173[_0x9432('0x27')](0x194);}return _0x4f931e;};}function handleError(_0x1ac5bc,_0xfc6ec6){_0xfc6ec6=_0xfc6ec6||0x1f4;return function(_0x10a9dc){logger['error'](_0x10a9dc[_0x9432('0x28')]);if(_0x10a9dc[_0x9432('0x29')]){delete _0x10a9dc[_0x9432('0x29')];}_0x1ac5bc[_0x9432('0x1f')](_0xfc6ec6)['send'](_0x10a9dc);};}exports[_0x9432('0x2a')]=function(_0x33c195,_0x2038bf){var _0x42a7fd={},_0x5e8431={},_0x3e642c={'count':0x0,'rows':[]};var _0x66564b=_[_0x9432('0x2b')](db[_0x9432('0x2c')][_0x9432('0x2d')],function(_0x3da176){return{'name':_0x3da176[_0x9432('0x2e')],'type':_0x3da176[_0x9432('0x2f')]['key']};});_0x5e8431[_0x9432('0x30')]=_[_0x9432('0x2b')](_0x66564b,_0x9432('0x29'));_0x5e8431[_0x9432('0x31')]=_['keys'](_0x33c195[_0x9432('0x31')]);_0x5e8431[_0x9432('0x32')]=_[_0x9432('0x33')](_0x5e8431[_0x9432('0x30')],_0x5e8431[_0x9432('0x31')]);_0x42a7fd[_0x9432('0x34')]=_['intersection'](_0x5e8431['model'],qs[_0x9432('0x35')](_0x33c195[_0x9432('0x31')][_0x9432('0x35')]));_0x42a7fd[_0x9432('0x34')]=_0x42a7fd[_0x9432('0x34')][_0x9432('0x36')]?_0x42a7fd[_0x9432('0x34')]:_0x5e8431[_0x9432('0x30')];if(!_0x33c195['query'][_0x9432('0x37')](_0x9432('0x38'))){_0x42a7fd[_0x9432('0x1d')]=qs[_0x9432('0x1d')](_0x33c195[_0x9432('0x31')][_0x9432('0x1d')]);_0x42a7fd[_0x9432('0x1b')]=qs[_0x9432('0x1b')](_0x33c195[_0x9432('0x31')][_0x9432('0x1b')]);}_0x42a7fd['order']=qs['sort'](_0x33c195[_0x9432('0x31')][_0x9432('0x39')]);_0x42a7fd[_0x9432('0x3a')]=qs[_0x9432('0x32')](_[_0x9432('0x3b')](_0x33c195[_0x9432('0x31')],_0x5e8431[_0x9432('0x32')]),_0x66564b);if(_0x33c195[_0x9432('0x31')][_0x9432('0x3c')]){_0x42a7fd['where']=_[_0x9432('0x3d')](_0x42a7fd[_0x9432('0x3a')],{'$or':_['map'](_0x66564b,function(_0x3203ab){if(_0x3203ab[_0x9432('0x2f')]!=='VIRTUAL'){var _0x2c362c={};_0x2c362c[_0x3203ab[_0x9432('0x29')]]={'$like':'%'+_0x33c195['query'][_0x9432('0x3c')]+'%'};return _0x2c362c;}})});}_0x42a7fd=_[_0x9432('0x3d')]({},_0x42a7fd,_0x33c195[_0x9432('0x3e')]);var _0x5d18cc={'where':_0x42a7fd[_0x9432('0x3a')]};return db[_0x9432('0x2c')][_0x9432('0x1e')](_0x5d18cc)[_0x9432('0x25')](function(_0x116a5e){_0x3e642c[_0x9432('0x1e')]=_0x116a5e;if(_0x33c195[_0x9432('0x31')]['includeAll']){_0x42a7fd[_0x9432('0x3f')]=[{'all':!![]}];}return db['SugarcrmConfiguration'][_0x9432('0x40')](_0x42a7fd);})[_0x9432('0x25')](function(_0x2c693c){_0x3e642c[_0x9432('0x41')]=_0x2c693c;return _0x3e642c;})['then'](respondWithFilteredResult(_0x2038bf,_0x42a7fd))['catch'](handleError(_0x2038bf,null));};exports['show']=function(_0x41cdf3,_0x58aa7a){var _0x3f7020={'raw':![],'where':{'id':_0x41cdf3[_0x9432('0x42')]['id']}},_0x404a78={};_0x404a78['model']=_[_0x9432('0x43')](db[_0x9432('0x2c')][_0x9432('0x2d')]);_0x404a78[_0x9432('0x31')]=_[_0x9432('0x43')](_0x41cdf3['query']);_0x404a78['filters']=_[_0x9432('0x33')](_0x404a78['model'],_0x404a78['query']);_0x3f7020[_0x9432('0x34')]=_[_0x9432('0x33')](_0x404a78[_0x9432('0x30')],qs[_0x9432('0x35')](_0x41cdf3['query'][_0x9432('0x35')]));_0x3f7020[_0x9432('0x34')]=_0x3f7020[_0x9432('0x34')][_0x9432('0x36')]?_0x3f7020[_0x9432('0x34')]:_0x404a78[_0x9432('0x30')];if(_0x41cdf3[_0x9432('0x31')][_0x9432('0x44')]){_0x3f7020[_0x9432('0x3f')]=[{'all':!![]}];}_0x3f7020=_['merge']({},_0x3f7020,_0x41cdf3[_0x9432('0x3e')]);return db['SugarcrmConfiguration'][_0x9432('0x45')](_0x3f7020)['then'](handleEntityNotFound(_0x58aa7a,null))[_0x9432('0x25')](respondWithResult(_0x58aa7a,null))[_0x9432('0x46')](handleError(_0x58aa7a,null));};exports[_0x9432('0x47')]=function(_0x4f251d,_0x232d74){return db[_0x9432('0x2c')][_0x9432('0x47')](_0x4f251d[_0x9432('0x48')],{})[_0x9432('0x25')](respondWithResult(_0x232d74,0xc9))[_0x9432('0x46')](handleError(_0x232d74,null));};exports[_0x9432('0x24')]=function(_0x4a729b,_0x248a63){if(_0x4a729b[_0x9432('0x48')]['id']){delete _0x4a729b[_0x9432('0x48')]['id'];}return db[_0x9432('0x2c')][_0x9432('0x45')]({'where':{'id':_0x4a729b[_0x9432('0x42')]['id']}})[_0x9432('0x25')](handleEntityNotFound(_0x248a63,null))[_0x9432('0x25')](saveUpdates(_0x4a729b[_0x9432('0x48')],null))[_0x9432('0x25')](respondWithResult(_0x248a63,null))[_0x9432('0x46')](handleError(_0x248a63,null));};exports[_0x9432('0x26')]=function(_0x51d9ed,_0x3239b2){return db[_0x9432('0x2c')]['find']({'where':{'id':_0x51d9ed[_0x9432('0x42')]['id']}})[_0x9432('0x25')](handleEntityNotFound(_0x3239b2,null))['then'](removeEntity(_0x3239b2,null))['catch'](handleError(_0x3239b2,null));};exports[_0x9432('0x49')]=function(_0x4ea5e3,_0x5c8ba6,_0x1938ea){var _0x1e6b79={};var _0x20333e={};var _0x3ee2b9;var _0x5e946b;return db[_0x9432('0x2c')][_0x9432('0x4a')]({'where':{'id':_0x4ea5e3['params']['id']}})['then'](handleEntityNotFound(_0x5c8ba6,null))['then'](function(_0x402064){if(_0x402064){_0x3ee2b9=_0x402064;_0x20333e[_0x9432('0x30')]=_[_0x9432('0x43')](db[_0x9432('0x4b')][_0x9432('0x2d')]);_0x20333e[_0x9432('0x31')]=_[_0x9432('0x43')](_0x4ea5e3[_0x9432('0x31')]);_0x20333e[_0x9432('0x32')]=_[_0x9432('0x33')](_0x20333e['model'],_0x20333e[_0x9432('0x31')]);_0x1e6b79[_0x9432('0x34')]=_[_0x9432('0x33')](_0x20333e['model'],qs[_0x9432('0x35')](_0x4ea5e3['query'][_0x9432('0x35')]));_0x1e6b79[_0x9432('0x34')]=_0x1e6b79[_0x9432('0x34')][_0x9432('0x36')]?_0x1e6b79[_0x9432('0x34')]:_0x20333e[_0x9432('0x30')];_0x1e6b79[_0x9432('0x4c')]=qs[_0x9432('0x39')](_0x4ea5e3['query']['sort']);_0x1e6b79[_0x9432('0x3a')]=qs[_0x9432('0x32')](_[_0x9432('0x3b')](_0x4ea5e3[_0x9432('0x31')],_0x20333e[_0x9432('0x32')]));if(_0x4ea5e3['query']['filter']){_0x1e6b79[_0x9432('0x3a')]=_[_0x9432('0x3d')](_0x1e6b79[_0x9432('0x3a')],{'$or':_['map'](_0x1e6b79[_0x9432('0x34')],function(_0x2b19c7){var _0x35c500={};_0x35c500[_0x2b19c7]={'$like':'%'+_0x4ea5e3[_0x9432('0x31')][_0x9432('0x3c')]+'%'};return _0x35c500;})});}_0x1e6b79=_[_0x9432('0x3d')]({},_0x1e6b79,_0x4ea5e3[_0x9432('0x3e')]);return _0x3ee2b9[_0x9432('0x49')](_0x1e6b79);}})[_0x9432('0x25')](function(_0x60b84e){if(_0x60b84e){_0x5e946b=_0x60b84e['length'];if(!_0x4ea5e3['query'][_0x9432('0x37')](_0x9432('0x38'))){_0x1e6b79['limit']=qs['limit'](_0x4ea5e3['query']['limit']);_0x1e6b79[_0x9432('0x1b')]=qs[_0x9432('0x1b')](_0x4ea5e3[_0x9432('0x31')][_0x9432('0x1b')]);}return _0x3ee2b9[_0x9432('0x49')](_0x1e6b79);}})['then'](function(_0x5a3423){if(_0x5a3423){return _0x5a3423?{'count':_0x5e946b,'rows':_0x5a3423}:null;}})[_0x9432('0x25')](respondWithResult(_0x5c8ba6,null))[_0x9432('0x46')](handleError(_0x5c8ba6,null));};exports[_0x9432('0x4d')]=function(_0x46d957,_0x70a25b,_0x40458a){var _0x4f8de4={};var _0x4a9c54={};var _0x208d86;var _0x1dc24d;return db[_0x9432('0x2c')][_0x9432('0x4a')]({'where':{'id':_0x46d957[_0x9432('0x42')]['id']}})[_0x9432('0x25')](handleEntityNotFound(_0x70a25b,null))['then'](function(_0x3590d1){if(_0x3590d1){_0x208d86=_0x3590d1;_0x4a9c54[_0x9432('0x30')]=_['keys'](db[_0x9432('0x4b')][_0x9432('0x2d')]);_0x4a9c54[_0x9432('0x31')]=_[_0x9432('0x43')](_0x46d957['query']);_0x4a9c54[_0x9432('0x32')]=_[_0x9432('0x33')](_0x4a9c54[_0x9432('0x30')],_0x4a9c54[_0x9432('0x31')]);_0x4f8de4[_0x9432('0x34')]=_[_0x9432('0x33')](_0x4a9c54[_0x9432('0x30')],qs[_0x9432('0x35')](_0x46d957[_0x9432('0x31')]['fields']));_0x4f8de4['attributes']=_0x4f8de4[_0x9432('0x34')][_0x9432('0x36')]?_0x4f8de4[_0x9432('0x34')]:_0x4a9c54[_0x9432('0x30')];_0x4f8de4[_0x9432('0x4c')]=qs[_0x9432('0x39')](_0x46d957[_0x9432('0x31')]['sort']);_0x4f8de4[_0x9432('0x3a')]=qs[_0x9432('0x32')](_[_0x9432('0x3b')](_0x46d957[_0x9432('0x31')],_0x4a9c54['filters']));if(_0x46d957[_0x9432('0x31')]['filter']){_0x4f8de4[_0x9432('0x3a')]=_[_0x9432('0x3d')](_0x4f8de4[_0x9432('0x3a')],{'$or':_[_0x9432('0x2b')](_0x4f8de4[_0x9432('0x34')],function(_0x32e9f4){var _0x2b601a={};_0x2b601a[_0x32e9f4]={'$like':'%'+_0x46d957[_0x9432('0x31')][_0x9432('0x3c')]+'%'};return _0x2b601a;})});}_0x4f8de4=_[_0x9432('0x3d')]({},_0x4f8de4,_0x46d957['options']);return _0x208d86[_0x9432('0x4d')](_0x4f8de4);}})[_0x9432('0x25')](function(_0x1f964c){if(_0x1f964c){_0x1dc24d=_0x1f964c[_0x9432('0x36')];if(!_0x46d957[_0x9432('0x31')]['hasOwnProperty'](_0x9432('0x38'))){_0x4f8de4[_0x9432('0x1d')]=qs['limit'](_0x46d957[_0x9432('0x31')][_0x9432('0x1d')]);_0x4f8de4[_0x9432('0x1b')]=qs['offset'](_0x46d957[_0x9432('0x31')][_0x9432('0x1b')]);}return _0x208d86[_0x9432('0x4d')](_0x4f8de4);}})[_0x9432('0x25')](function(_0x30ea9a){if(_0x30ea9a){return _0x30ea9a?{'count':_0x1dc24d,'rows':_0x30ea9a}:null;}})[_0x9432('0x25')](respondWithResult(_0x70a25b,null))[_0x9432('0x46')](handleError(_0x70a25b,null));};exports[_0x9432('0x4e')]=function(_0x420d78,_0x35b9e6,_0x14523b){var _0x29da8d={};var _0x5efbb2={};var _0x5b2642;var _0x1b6086;return db[_0x9432('0x2c')][_0x9432('0x4a')]({'where':{'id':_0x420d78[_0x9432('0x42')]['id']}})[_0x9432('0x25')](handleEntityNotFound(_0x35b9e6,null))[_0x9432('0x25')](function(_0x4db3fd){if(_0x4db3fd){_0x5b2642=_0x4db3fd;_0x5efbb2[_0x9432('0x30')]=_['keys'](db['SugarcrmField']['rawAttributes']);_0x5efbb2[_0x9432('0x31')]=_[_0x9432('0x43')](_0x420d78[_0x9432('0x31')]);_0x5efbb2[_0x9432('0x32')]=_[_0x9432('0x33')](_0x5efbb2[_0x9432('0x30')],_0x5efbb2['query']);_0x29da8d['attributes']=_[_0x9432('0x33')](_0x5efbb2[_0x9432('0x30')],qs[_0x9432('0x35')](_0x420d78[_0x9432('0x31')][_0x9432('0x35')]));_0x29da8d[_0x9432('0x34')]=_0x29da8d[_0x9432('0x34')]['length']?_0x29da8d[_0x9432('0x34')]:_0x5efbb2['model'];_0x29da8d['order']=qs[_0x9432('0x39')](_0x420d78['query']['sort']);_0x29da8d[_0x9432('0x3a')]=qs[_0x9432('0x32')](_[_0x9432('0x3b')](_0x420d78['query'],_0x5efbb2[_0x9432('0x32')]));if(_0x420d78[_0x9432('0x31')][_0x9432('0x3c')]){_0x29da8d[_0x9432('0x3a')]=_[_0x9432('0x3d')](_0x29da8d[_0x9432('0x3a')],{'$or':_[_0x9432('0x2b')](_0x29da8d[_0x9432('0x34')],function(_0x10332c){var _0x13f992={};_0x13f992[_0x10332c]={'$like':'%'+_0x420d78[_0x9432('0x31')][_0x9432('0x3c')]+'%'};return _0x13f992;})});}_0x29da8d=_[_0x9432('0x3d')]({},_0x29da8d,_0x420d78[_0x9432('0x3e')]);return _0x5b2642[_0x9432('0x4e')](_0x29da8d);}})['then'](function(_0x227e75){if(_0x227e75){_0x1b6086=_0x227e75[_0x9432('0x36')];if(!_0x420d78[_0x9432('0x31')][_0x9432('0x37')](_0x9432('0x38'))){_0x29da8d[_0x9432('0x1d')]=qs['limit'](_0x420d78[_0x9432('0x31')][_0x9432('0x1d')]);_0x29da8d[_0x9432('0x1b')]=qs['offset'](_0x420d78[_0x9432('0x31')][_0x9432('0x1b')]);}return _0x5b2642[_0x9432('0x4e')](_0x29da8d);}})['then'](function(_0x414ae7){if(_0x414ae7){return _0x414ae7?{'count':_0x1b6086,'rows':_0x414ae7}:null;}})[_0x9432('0x25')](respondWithResult(_0x35b9e6,null))[_0x9432('0x46')](handleError(_0x35b9e6,null));};
\ No newline at end of file
+var _0x5ef2=['error','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','keys','query','intersection','attributes','length','nolimit','order','sort','where','pick','filters','filter','VIRTUAL','merge','options','SugarcrmConfiguration','include','findAll','rows','catch','show','fields','includeAll','find','create','body','params','destroy','getFields','findOne','SugarcrmField','getSubjects','hasOwnProperty','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','status','end','json','offset','undefined','limit','count','set','Content-Range','reject','save','then','sendStatus'];(function(_0x579dad,_0x200a74){var _0x3a53fa=function(_0x373cc0){while(--_0x373cc0){_0x579dad['push'](_0x579dad['shift']());}};_0x3a53fa(++_0x200a74);}(_0x5ef2,0x81));var _0x25ef=function(_0x475080,_0x4560c5){_0x475080=_0x475080-0x0;var _0x2c756b=_0x5ef2[_0x475080];return _0x2c756b;};'use strict';var emlformat=require(_0x25ef('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x25ef('0x1'));var jsonpatch=require(_0x25ef('0x2'));var rp=require(_0x25ef('0x3'));var moment=require('moment');var BPromise=require(_0x25ef('0x4'));var Mustache=require(_0x25ef('0x5'));var util=require(_0x25ef('0x6'));var path=require(_0x25ef('0x7'));var sox=require(_0x25ef('0x8'));var csv=require('to-csv');var ejs=require(_0x25ef('0x9'));var fs=require('fs');var fs_extra=require(_0x25ef('0xa'));var _=require(_0x25ef('0xb'));var squel=require(_0x25ef('0xc'));var crypto=require(_0x25ef('0xd'));var jsforce=require(_0x25ef('0xe'));var deskjs=require(_0x25ef('0xf'));var toCsv=require(_0x25ef('0x10'));var querystring=require(_0x25ef('0x11'));var Papa=require('papaparse');var Redis=require(_0x25ef('0x12'));var authService=require(_0x25ef('0x13'));var qs=require(_0x25ef('0x14'));var as=require(_0x25ef('0x15'));var hardwareService=require(_0x25ef('0x16'));var logger=require('../../config/logger')(_0x25ef('0x17'));var utils=require(_0x25ef('0x18'));var config=require(_0x25ef('0x19'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x302bb6,_0x569b03){_0x569b03=_0x569b03||0xcc;return function(_0x3dd5f3){if(_0x3dd5f3){return _0x302bb6['sendStatus'](_0x569b03);}return _0x302bb6[_0x25ef('0x1a')](_0x569b03)[_0x25ef('0x1b')]();};}function respondWithResult(_0x1714ef,_0x4b92c8){_0x4b92c8=_0x4b92c8||0xc8;return function(_0x2ff450){if(_0x2ff450){return _0x1714ef[_0x25ef('0x1a')](_0x4b92c8)[_0x25ef('0x1c')](_0x2ff450);}};}function respondWithFilteredResult(_0x2618cc,_0x400de3){return function(_0x1ac6a6){if(_0x1ac6a6){var _0x311789=typeof _0x400de3[_0x25ef('0x1d')]===_0x25ef('0x1e')&&typeof _0x400de3[_0x25ef('0x1f')]===_0x25ef('0x1e');var _0x3aa1ce=_0x1ac6a6[_0x25ef('0x20')];var _0xd351a9=_0x311789?0x0:_0x400de3[_0x25ef('0x1d')];var _0x5c99b9=_0x311789?_0x1ac6a6['count']:_0x400de3[_0x25ef('0x1d')]+_0x400de3[_0x25ef('0x1f')];var _0x297845;if(_0x5c99b9>=_0x3aa1ce){_0x5c99b9=_0x3aa1ce;_0x297845=0xc8;}else{_0x297845=0xce;}_0x2618cc[_0x25ef('0x1a')](_0x297845);return _0x2618cc[_0x25ef('0x21')](_0x25ef('0x22'),_0xd351a9+'-'+_0x5c99b9+'/'+_0x3aa1ce)[_0x25ef('0x1c')](_0x1ac6a6);}return null;};}function patchUpdates(_0x52616c){return function(_0x3b3832){try{jsonpatch['apply'](_0x3b3832,_0x52616c,!![]);}catch(_0xc27d4f){return BPromise[_0x25ef('0x23')](_0xc27d4f);}return _0x3b3832[_0x25ef('0x24')]();};}function saveUpdates(_0x2c2ad3,_0x3de520){return function(_0x9d2882){if(_0x9d2882){return _0x9d2882['update'](_0x2c2ad3)[_0x25ef('0x25')](function(_0x10bd82){return _0x10bd82;});}return null;};}function removeEntity(_0x25bbc4,_0x56b7d4){return function(_0x57b40d){if(_0x57b40d){return _0x57b40d['destroy']()[_0x25ef('0x25')](function(){_0x25bbc4['status'](0xcc)[_0x25ef('0x1b')]();});}};}function handleEntityNotFound(_0x5e7077,_0xfa824e){return function(_0x3b6907){if(!_0x3b6907){_0x5e7077[_0x25ef('0x26')](0x194);}return _0x3b6907;};}function handleError(_0x98af3,_0x5cea07){_0x5cea07=_0x5cea07||0x1f4;return function(_0x279100){logger[_0x25ef('0x27')](_0x279100[_0x25ef('0x28')]);if(_0x279100[_0x25ef('0x29')]){delete _0x279100[_0x25ef('0x29')];}_0x98af3[_0x25ef('0x1a')](_0x5cea07)[_0x25ef('0x2a')](_0x279100);};}exports[_0x25ef('0x2b')]=function(_0xa14798,_0x3c4f57){var _0x1017d1={},_0x4010ed={},_0x32514b={'count':0x0,'rows':[]};var _0x447ff5=_[_0x25ef('0x2c')](db['SugarcrmConfiguration'][_0x25ef('0x2d')],function(_0xe54ba0){return{'name':_0xe54ba0[_0x25ef('0x2e')],'type':_0xe54ba0[_0x25ef('0x2f')][_0x25ef('0x30')]};});_0x4010ed[_0x25ef('0x31')]=_[_0x25ef('0x2c')](_0x447ff5,'name');_0x4010ed['query']=_[_0x25ef('0x32')](_0xa14798[_0x25ef('0x33')]);_0x4010ed['filters']=_[_0x25ef('0x34')](_0x4010ed['model'],_0x4010ed['query']);_0x1017d1[_0x25ef('0x35')]=_[_0x25ef('0x34')](_0x4010ed[_0x25ef('0x31')],qs['fields'](_0xa14798[_0x25ef('0x33')]['fields']));_0x1017d1[_0x25ef('0x35')]=_0x1017d1[_0x25ef('0x35')][_0x25ef('0x36')]?_0x1017d1[_0x25ef('0x35')]:_0x4010ed[_0x25ef('0x31')];if(!_0xa14798[_0x25ef('0x33')]['hasOwnProperty'](_0x25ef('0x37'))){_0x1017d1[_0x25ef('0x1f')]=qs['limit'](_0xa14798['query'][_0x25ef('0x1f')]);_0x1017d1[_0x25ef('0x1d')]=qs[_0x25ef('0x1d')](_0xa14798[_0x25ef('0x33')][_0x25ef('0x1d')]);}_0x1017d1[_0x25ef('0x38')]=qs[_0x25ef('0x39')](_0xa14798[_0x25ef('0x33')]['sort']);_0x1017d1[_0x25ef('0x3a')]=qs['filters'](_[_0x25ef('0x3b')](_0xa14798[_0x25ef('0x33')],_0x4010ed[_0x25ef('0x3c')]),_0x447ff5);if(_0xa14798['query'][_0x25ef('0x3d')]){_0x1017d1[_0x25ef('0x3a')]=_['merge'](_0x1017d1[_0x25ef('0x3a')],{'$or':_['map'](_0x447ff5,function(_0x3f4c4c){if(_0x3f4c4c[_0x25ef('0x2f')]!==_0x25ef('0x3e')){var _0x28a78c={};_0x28a78c[_0x3f4c4c['name']]={'$like':'%'+_0xa14798['query']['filter']+'%'};return _0x28a78c;}})});}_0x1017d1=_[_0x25ef('0x3f')]({},_0x1017d1,_0xa14798[_0x25ef('0x40')]);var _0x54bd1a={'where':_0x1017d1[_0x25ef('0x3a')]};return db[_0x25ef('0x41')][_0x25ef('0x20')](_0x54bd1a)['then'](function(_0x9f5439){_0x32514b[_0x25ef('0x20')]=_0x9f5439;if(_0xa14798[_0x25ef('0x33')]['includeAll']){_0x1017d1[_0x25ef('0x42')]=[{'all':!![]}];}return db['SugarcrmConfiguration'][_0x25ef('0x43')](_0x1017d1);})[_0x25ef('0x25')](function(_0x4c45ad){_0x32514b[_0x25ef('0x44')]=_0x4c45ad;return _0x32514b;})[_0x25ef('0x25')](respondWithFilteredResult(_0x3c4f57,_0x1017d1))[_0x25ef('0x45')](handleError(_0x3c4f57,null));};exports[_0x25ef('0x46')]=function(_0xaf4e6e,_0x4dc850){var _0x9cd0b3={'raw':![],'where':{'id':_0xaf4e6e['params']['id']}},_0x4343a7={};_0x4343a7[_0x25ef('0x31')]=_[_0x25ef('0x32')](db[_0x25ef('0x41')][_0x25ef('0x2d')]);_0x4343a7[_0x25ef('0x33')]=_['keys'](_0xaf4e6e[_0x25ef('0x33')]);_0x4343a7[_0x25ef('0x3c')]=_[_0x25ef('0x34')](_0x4343a7['model'],_0x4343a7[_0x25ef('0x33')]);_0x9cd0b3[_0x25ef('0x35')]=_['intersection'](_0x4343a7[_0x25ef('0x31')],qs[_0x25ef('0x47')](_0xaf4e6e['query']['fields']));_0x9cd0b3[_0x25ef('0x35')]=_0x9cd0b3['attributes']['length']?_0x9cd0b3[_0x25ef('0x35')]:_0x4343a7[_0x25ef('0x31')];if(_0xaf4e6e[_0x25ef('0x33')][_0x25ef('0x48')]){_0x9cd0b3[_0x25ef('0x42')]=[{'all':!![]}];}_0x9cd0b3=_[_0x25ef('0x3f')]({},_0x9cd0b3,_0xaf4e6e['options']);return db[_0x25ef('0x41')][_0x25ef('0x49')](_0x9cd0b3)['then'](handleEntityNotFound(_0x4dc850,null))['then'](respondWithResult(_0x4dc850,null))[_0x25ef('0x45')](handleError(_0x4dc850,null));};exports[_0x25ef('0x4a')]=function(_0x45bedf,_0x326741){return db[_0x25ef('0x41')][_0x25ef('0x4a')](_0x45bedf['body'],{})['then'](respondWithResult(_0x326741,0xc9))[_0x25ef('0x45')](handleError(_0x326741,null));};exports['update']=function(_0x2ddee7,_0x11ccbc){if(_0x2ddee7['body']['id']){delete _0x2ddee7[_0x25ef('0x4b')]['id'];}return db['SugarcrmConfiguration']['find']({'where':{'id':_0x2ddee7[_0x25ef('0x4c')]['id']}})[_0x25ef('0x25')](handleEntityNotFound(_0x11ccbc,null))[_0x25ef('0x25')](saveUpdates(_0x2ddee7['body'],null))['then'](respondWithResult(_0x11ccbc,null))[_0x25ef('0x45')](handleError(_0x11ccbc,null));};exports[_0x25ef('0x4d')]=function(_0x5b9a89,_0x3bf2e6){return db[_0x25ef('0x41')]['find']({'where':{'id':_0x5b9a89[_0x25ef('0x4c')]['id']}})[_0x25ef('0x25')](handleEntityNotFound(_0x3bf2e6,null))[_0x25ef('0x25')](removeEntity(_0x3bf2e6,null))[_0x25ef('0x45')](handleError(_0x3bf2e6,null));};exports[_0x25ef('0x4e')]=function(_0x189c04,_0x4173fe,_0x759f41){var _0x4469f1={};var _0x1e3e1c={};var _0x1f924c;var _0x588ad9;return db[_0x25ef('0x41')][_0x25ef('0x4f')]({'where':{'id':_0x189c04[_0x25ef('0x4c')]['id']}})[_0x25ef('0x25')](handleEntityNotFound(_0x4173fe,null))[_0x25ef('0x25')](function(_0x494e4d){if(_0x494e4d){_0x1f924c=_0x494e4d;_0x1e3e1c[_0x25ef('0x31')]=_['keys'](db[_0x25ef('0x50')][_0x25ef('0x2d')]);_0x1e3e1c['query']=_['keys'](_0x189c04['query']);_0x1e3e1c[_0x25ef('0x3c')]=_[_0x25ef('0x34')](_0x1e3e1c[_0x25ef('0x31')],_0x1e3e1c[_0x25ef('0x33')]);_0x4469f1[_0x25ef('0x35')]=_['intersection'](_0x1e3e1c[_0x25ef('0x31')],qs[_0x25ef('0x47')](_0x189c04[_0x25ef('0x33')][_0x25ef('0x47')]));_0x4469f1['attributes']=_0x4469f1['attributes'][_0x25ef('0x36')]?_0x4469f1[_0x25ef('0x35')]:_0x1e3e1c[_0x25ef('0x31')];_0x4469f1[_0x25ef('0x38')]=qs[_0x25ef('0x39')](_0x189c04[_0x25ef('0x33')][_0x25ef('0x39')]);_0x4469f1[_0x25ef('0x3a')]=qs['filters'](_[_0x25ef('0x3b')](_0x189c04['query'],_0x1e3e1c[_0x25ef('0x3c')]));if(_0x189c04['query'][_0x25ef('0x3d')]){_0x4469f1[_0x25ef('0x3a')]=_[_0x25ef('0x3f')](_0x4469f1[_0x25ef('0x3a')],{'$or':_[_0x25ef('0x2c')](_0x4469f1[_0x25ef('0x35')],function(_0x12b5c2){var _0x1ae841={};_0x1ae841[_0x12b5c2]={'$like':'%'+_0x189c04[_0x25ef('0x33')][_0x25ef('0x3d')]+'%'};return _0x1ae841;})});}_0x4469f1=_[_0x25ef('0x3f')]({},_0x4469f1,_0x189c04[_0x25ef('0x40')]);return _0x1f924c[_0x25ef('0x4e')](_0x4469f1);}})[_0x25ef('0x25')](function(_0x41d850){if(_0x41d850){_0x588ad9=_0x41d850[_0x25ef('0x36')];if(!_0x189c04[_0x25ef('0x33')]['hasOwnProperty']('nolimit')){_0x4469f1[_0x25ef('0x1f')]=qs[_0x25ef('0x1f')](_0x189c04[_0x25ef('0x33')][_0x25ef('0x1f')]);_0x4469f1[_0x25ef('0x1d')]=qs[_0x25ef('0x1d')](_0x189c04[_0x25ef('0x33')][_0x25ef('0x1d')]);}return _0x1f924c[_0x25ef('0x4e')](_0x4469f1);}})[_0x25ef('0x25')](function(_0x1b120f){if(_0x1b120f){return _0x1b120f?{'count':_0x588ad9,'rows':_0x1b120f}:null;}})['then'](respondWithResult(_0x4173fe,null))['catch'](handleError(_0x4173fe,null));};exports[_0x25ef('0x51')]=function(_0x4aa20d,_0x37233c,_0x385baf){var _0xa6bcf7={};var _0x2431d0={};var _0x513aa4;var _0x212863;return db[_0x25ef('0x41')][_0x25ef('0x4f')]({'where':{'id':_0x4aa20d[_0x25ef('0x4c')]['id']}})[_0x25ef('0x25')](handleEntityNotFound(_0x37233c,null))[_0x25ef('0x25')](function(_0x36ae12){if(_0x36ae12){_0x513aa4=_0x36ae12;_0x2431d0[_0x25ef('0x31')]=_['keys'](db[_0x25ef('0x50')]['rawAttributes']);_0x2431d0[_0x25ef('0x33')]=_[_0x25ef('0x32')](_0x4aa20d[_0x25ef('0x33')]);_0x2431d0[_0x25ef('0x3c')]=_[_0x25ef('0x34')](_0x2431d0['model'],_0x2431d0[_0x25ef('0x33')]);_0xa6bcf7['attributes']=_[_0x25ef('0x34')](_0x2431d0[_0x25ef('0x31')],qs[_0x25ef('0x47')](_0x4aa20d[_0x25ef('0x33')][_0x25ef('0x47')]));_0xa6bcf7[_0x25ef('0x35')]=_0xa6bcf7[_0x25ef('0x35')][_0x25ef('0x36')]?_0xa6bcf7[_0x25ef('0x35')]:_0x2431d0[_0x25ef('0x31')];_0xa6bcf7[_0x25ef('0x38')]=qs['sort'](_0x4aa20d['query']['sort']);_0xa6bcf7[_0x25ef('0x3a')]=qs['filters'](_['pick'](_0x4aa20d[_0x25ef('0x33')],_0x2431d0[_0x25ef('0x3c')]));if(_0x4aa20d[_0x25ef('0x33')][_0x25ef('0x3d')]){_0xa6bcf7[_0x25ef('0x3a')]=_[_0x25ef('0x3f')](_0xa6bcf7[_0x25ef('0x3a')],{'$or':_[_0x25ef('0x2c')](_0xa6bcf7['attributes'],function(_0x1f07a6){var _0x20d485={};_0x20d485[_0x1f07a6]={'$like':'%'+_0x4aa20d[_0x25ef('0x33')][_0x25ef('0x3d')]+'%'};return _0x20d485;})});}_0xa6bcf7=_[_0x25ef('0x3f')]({},_0xa6bcf7,_0x4aa20d[_0x25ef('0x40')]);return _0x513aa4[_0x25ef('0x51')](_0xa6bcf7);}})[_0x25ef('0x25')](function(_0x5f136b){if(_0x5f136b){_0x212863=_0x5f136b['length'];if(!_0x4aa20d[_0x25ef('0x33')][_0x25ef('0x52')](_0x25ef('0x37'))){_0xa6bcf7[_0x25ef('0x1f')]=qs[_0x25ef('0x1f')](_0x4aa20d[_0x25ef('0x33')][_0x25ef('0x1f')]);_0xa6bcf7[_0x25ef('0x1d')]=qs[_0x25ef('0x1d')](_0x4aa20d[_0x25ef('0x33')][_0x25ef('0x1d')]);}return _0x513aa4[_0x25ef('0x51')](_0xa6bcf7);}})['then'](function(_0x56bd56){if(_0x56bd56){return _0x56bd56?{'count':_0x212863,'rows':_0x56bd56}:null;}})['then'](respondWithResult(_0x37233c,null))[_0x25ef('0x45')](handleError(_0x37233c,null));};exports[_0x25ef('0x53')]=function(_0xd7d7cf,_0x1079f7,_0x206ad6){var _0x487f79={};var _0x2b305a={};var _0x40a8cd;var _0x13076e;return db[_0x25ef('0x41')][_0x25ef('0x4f')]({'where':{'id':_0xd7d7cf['params']['id']}})['then'](handleEntityNotFound(_0x1079f7,null))[_0x25ef('0x25')](function(_0x1c4eda){if(_0x1c4eda){_0x40a8cd=_0x1c4eda;_0x2b305a[_0x25ef('0x31')]=_['keys'](db[_0x25ef('0x50')]['rawAttributes']);_0x2b305a['query']=_['keys'](_0xd7d7cf[_0x25ef('0x33')]);_0x2b305a[_0x25ef('0x3c')]=_['intersection'](_0x2b305a['model'],_0x2b305a[_0x25ef('0x33')]);_0x487f79['attributes']=_[_0x25ef('0x34')](_0x2b305a['model'],qs[_0x25ef('0x47')](_0xd7d7cf[_0x25ef('0x33')]['fields']));_0x487f79['attributes']=_0x487f79['attributes'][_0x25ef('0x36')]?_0x487f79['attributes']:_0x2b305a[_0x25ef('0x31')];_0x487f79[_0x25ef('0x38')]=qs[_0x25ef('0x39')](_0xd7d7cf[_0x25ef('0x33')][_0x25ef('0x39')]);_0x487f79[_0x25ef('0x3a')]=qs[_0x25ef('0x3c')](_[_0x25ef('0x3b')](_0xd7d7cf['query'],_0x2b305a['filters']));if(_0xd7d7cf[_0x25ef('0x33')][_0x25ef('0x3d')]){_0x487f79[_0x25ef('0x3a')]=_['merge'](_0x487f79[_0x25ef('0x3a')],{'$or':_[_0x25ef('0x2c')](_0x487f79[_0x25ef('0x35')],function(_0x28ce8e){var _0x3b137d={};_0x3b137d[_0x28ce8e]={'$like':'%'+_0xd7d7cf[_0x25ef('0x33')][_0x25ef('0x3d')]+'%'};return _0x3b137d;})});}_0x487f79=_[_0x25ef('0x3f')]({},_0x487f79,_0xd7d7cf[_0x25ef('0x40')]);return _0x40a8cd[_0x25ef('0x53')](_0x487f79);}})[_0x25ef('0x25')](function(_0x1ceed9){if(_0x1ceed9){_0x13076e=_0x1ceed9[_0x25ef('0x36')];if(!_0xd7d7cf[_0x25ef('0x33')][_0x25ef('0x52')](_0x25ef('0x37'))){_0x487f79[_0x25ef('0x1f')]=qs['limit'](_0xd7d7cf[_0x25ef('0x33')][_0x25ef('0x1f')]);_0x487f79[_0x25ef('0x1d')]=qs[_0x25ef('0x1d')](_0xd7d7cf[_0x25ef('0x33')]['offset']);}return _0x40a8cd[_0x25ef('0x53')](_0x487f79);}})['then'](function(_0x4ae13c){if(_0x4ae13c){return _0x4ae13c?{'count':_0x13076e,'rows':_0x4ae13c}:null;}})['then'](respondWithResult(_0x1079f7,null))['catch'](handleError(_0x1079f7,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff