// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x89be=['index','map','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','merge','VIRTUAL','filter','SugarcrmConfiguration','count','include','findAll','rows','catch','show','params','keys','includeAll','options','create','body','find','getFields','pick','nolimit','getSubjects','findOne','SugarcrmField','html-pdf','eml-format','fast-json-patch','request-promise','path','ejs','lodash','crypto','jsforce','desk.js','to-csv','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','jayson/promise','client','http','request','info','SugarcrmConfiguration,\x20%s,\x20%s','debug','error','code','message','request\x20sent','result','sendStatus','status','end','offset','limit','Content-Range','apply','save','update','then','destroy','stack','name','send'];(function(_0x2b2b33,_0x56606f){var _0x229157=function(_0x52b63e){while(--_0x52b63e){_0x2b2b33['push'](_0x2b2b33['shift']());}};_0x229157(++_0x56606f);}(_0x89be,0x180));var _0xe89b=function(_0x321bb2,_0x202794){_0x321bb2=_0x321bb2-0x0;var _0x9c12ed=_0x89be[_0x321bb2];return _0x9c12ed;};'use strict';var pdf=require(_0xe89b('0x0'));var emlformat=require(_0xe89b('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xe89b('0x2'));var rp=require(_0xe89b('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0xe89b('0x4'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xe89b('0x5'));var fs=require('fs');var _=require(_0xe89b('0x6'));var squel=require('squel');var crypto=require(_0xe89b('0x7'));var jsforce=require(_0xe89b('0x8'));var deskjs=require(_0xe89b('0x9'));var toCsv=require(_0xe89b('0xa'));var querystring=require('querystring');var Papa=require(_0xe89b('0xb'));var Redis=require('ioredis');var authService=require(_0xe89b('0xc'));var qs=require('../../components/parsers/qs');var as=require(_0xe89b('0xd'));var hardwareService=require(_0xe89b('0xe'));var logger=require('../../config/logger')(_0xe89b('0xf'));var utils=require(_0xe89b('0x10'));var config=require(_0xe89b('0x11'));var licenseUtil=require(_0xe89b('0x12'));var db=require(_0xe89b('0x13'))['db'];var jayson=require(_0xe89b('0x14'));var client=jayson[_0xe89b('0x15')][_0xe89b('0x16')]({'port':0x232a});function respondWithRpcPromise(_0x5db334,_0x124fcc,_0x494ee3,_0x5f06b9){return new BPromise(function(_0x521132,_0x19123a){var _0x16da97=_0x5f06b9||client;return _0x16da97[_0xe89b('0x17')](_0x5db334,_0x494ee3)['then'](function(_0x8fa2e8){logger[_0xe89b('0x18')](_0xe89b('0x19'),_0x124fcc,'request\x20sent');logger[_0xe89b('0x1a')]('SugarcrmConfiguration,\x20%s,\x20%s,\x20%s',_0x124fcc,'request\x20sent',JSON['stringify'](_0x8fa2e8));if(_0x8fa2e8[_0xe89b('0x1b')]){if(_0x8fa2e8[_0xe89b('0x1b')][_0xe89b('0x1c')]===0x1f4){logger['error'](_0xe89b('0x19'),_0x124fcc,_0x8fa2e8[_0xe89b('0x1b')][_0xe89b('0x1d')]);return _0x19123a(_0x8fa2e8[_0xe89b('0x1b')][_0xe89b('0x1d')]);}logger[_0xe89b('0x1b')](_0xe89b('0x19'),_0x124fcc,_0x8fa2e8[_0xe89b('0x1b')][_0xe89b('0x1d')]);return _0x521132(_0x8fa2e8[_0xe89b('0x1b')][_0xe89b('0x1d')]);}else{logger[_0xe89b('0x18')](_0xe89b('0x19'),_0x124fcc,_0xe89b('0x1e'));_0x521132(_0x8fa2e8[_0xe89b('0x1f')][_0xe89b('0x1d')]);}})['catch'](function(_0x1d460b){logger[_0xe89b('0x1b')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x124fcc,_0x1d460b);_0x19123a(_0x1d460b);});});}function respondWithStatusCode(_0x79c018,_0x7eec5b){_0x7eec5b=_0x7eec5b||0xcc;return function(_0x2d32fa){if(_0x2d32fa){return _0x79c018[_0xe89b('0x20')](_0x7eec5b);}return _0x79c018[_0xe89b('0x21')](_0x7eec5b)[_0xe89b('0x22')]();};}function respondWithResult(_0x4755bf,_0xa527cb){_0xa527cb=_0xa527cb||0xc8;return function(_0x47e99f){if(_0x47e99f){return _0x4755bf[_0xe89b('0x21')](_0xa527cb)['json'](_0x47e99f);}};}function respondWithFilteredResult(_0x3834bc,_0x162902){return function(_0x2a7e69){if(_0x2a7e69){var _0x38b4c2=_0x2a7e69['count'],_0x4e45d1=_0x162902['offset'],_0x136f57=_0x162902[_0xe89b('0x23')]+_0x162902[_0xe89b('0x24')],_0x280308;if(_0x136f57>=_0x38b4c2){_0x136f57=_0x38b4c2;_0x280308=0xc8;}else{_0x280308=0xce;}_0x3834bc[_0xe89b('0x21')](_0x280308);return _0x3834bc['set'](_0xe89b('0x25'),_0x4e45d1+'-'+_0x136f57+'/'+_0x38b4c2)['json'](_0x2a7e69);}return null;};}function patchUpdates(_0x5e2f65){return function(_0x52f725){try{jsonpatch[_0xe89b('0x26')](_0x52f725,_0x5e2f65,!![]);}catch(_0x13aa53){return BPromise['reject'](_0x13aa53);}return _0x52f725[_0xe89b('0x27')]();};}function saveUpdates(_0xad98c2,_0x4890ae){return function(_0x2d73a1){if(_0x2d73a1){return _0x2d73a1[_0xe89b('0x28')](_0xad98c2)[_0xe89b('0x29')](function(_0x16191f){return _0x16191f;});}return null;};}function removeEntity(_0x3d01c6,_0x54c0e6){return function(_0x35f18a){if(_0x35f18a){return _0x35f18a[_0xe89b('0x2a')]()[_0xe89b('0x29')](function(){_0x3d01c6[_0xe89b('0x21')](0xcc)[_0xe89b('0x22')]();});}};}function handleEntityNotFound(_0x45ef4f,_0x499fb3){return function(_0x4f2680){if(!_0x4f2680){_0x45ef4f[_0xe89b('0x20')](0x194);}return _0x4f2680;};}function handleError(_0x59861a,_0x571985){_0x571985=_0x571985||0x1f4;return function(_0x3ad173){logger['error'](_0x3ad173[_0xe89b('0x2b')]);if(_0x3ad173[_0xe89b('0x2c')]){delete _0x3ad173[_0xe89b('0x2c')];}_0x59861a['status'](_0x571985)[_0xe89b('0x2d')](_0x3ad173);};}exports[_0xe89b('0x2e')]=function(_0x2458a2,_0x430e41){var _0x5f5754={},_0x557128={},_0x3ef9f7={'count':0x0,'rows':[]};var _0x1cf832=_[_0xe89b('0x2f')](db['SugarcrmConfiguration'][_0xe89b('0x30')],function(_0x3a4332){return{'name':_0x3a4332[_0xe89b('0x31')],'type':_0x3a4332[_0xe89b('0x32')][_0xe89b('0x33')]};});_0x557128[_0xe89b('0x34')]=_[_0xe89b('0x2f')](_0x1cf832,_0xe89b('0x2c'));_0x557128[_0xe89b('0x35')]=_['keys'](_0x2458a2[_0xe89b('0x35')]);_0x557128[_0xe89b('0x36')]=_[_0xe89b('0x37')](_0x557128[_0xe89b('0x34')],_0x557128[_0xe89b('0x35')]);_0x5f5754[_0xe89b('0x38')]=_[_0xe89b('0x37')](_0x557128[_0xe89b('0x34')],qs[_0xe89b('0x39')](_0x2458a2[_0xe89b('0x35')][_0xe89b('0x39')]));_0x5f5754[_0xe89b('0x38')]=_0x5f5754[_0xe89b('0x38')][_0xe89b('0x3a')]?_0x5f5754['attributes']:_0x557128[_0xe89b('0x34')];if(!_0x2458a2['query'][_0xe89b('0x3b')]('nolimit')){_0x5f5754[_0xe89b('0x24')]=qs[_0xe89b('0x24')](_0x2458a2[_0xe89b('0x35')][_0xe89b('0x24')]);_0x5f5754[_0xe89b('0x23')]=qs[_0xe89b('0x23')](_0x2458a2[_0xe89b('0x35')][_0xe89b('0x23')]);}_0x5f5754[_0xe89b('0x3c')]=qs[_0xe89b('0x3d')](_0x2458a2[_0xe89b('0x35')][_0xe89b('0x3d')]);_0x5f5754['where']=qs[_0xe89b('0x36')](_['pick'](_0x2458a2[_0xe89b('0x35')],_0x557128[_0xe89b('0x36')]),_0x1cf832);if(_0x2458a2[_0xe89b('0x35')]['filter']){_0x5f5754[_0xe89b('0x3e')]=_[_0xe89b('0x3f')](_0x5f5754['where'],{'$or':_[_0xe89b('0x2f')](_0x1cf832,function(_0x503054){if(_0x503054[_0xe89b('0x32')]!==_0xe89b('0x40')){var _0x55e336={};_0x55e336[_0x503054[_0xe89b('0x2c')]]={'$like':'%'+_0x2458a2[_0xe89b('0x35')][_0xe89b('0x41')]+'%'};return _0x55e336;}})});}_0x5f5754=_[_0xe89b('0x3f')]({},_0x5f5754,_0x2458a2['options']);var _0x5c7e12={'where':_0x5f5754[_0xe89b('0x3e')]};return db[_0xe89b('0x42')][_0xe89b('0x43')](_0x5c7e12)[_0xe89b('0x29')](function(_0x475820){_0x3ef9f7[_0xe89b('0x43')]=_0x475820;if(_0x2458a2['query']['includeAll']){_0x5f5754[_0xe89b('0x44')]=[{'all':!![]}];}return db[_0xe89b('0x42')][_0xe89b('0x45')](_0x5f5754);})[_0xe89b('0x29')](function(_0x56b231){_0x3ef9f7[_0xe89b('0x46')]=_0x56b231;return _0x3ef9f7;})[_0xe89b('0x29')](respondWithFilteredResult(_0x430e41,_0x5f5754))[_0xe89b('0x47')](handleError(_0x430e41,null));};exports[_0xe89b('0x48')]=function(_0x32256d,_0x1b0258){var _0x50a45a={'raw':![],'where':{'id':_0x32256d[_0xe89b('0x49')]['id']}},_0x53dc4d={};_0x53dc4d[_0xe89b('0x34')]=_[_0xe89b('0x4a')](db[_0xe89b('0x42')][_0xe89b('0x30')]);_0x53dc4d['query']=_[_0xe89b('0x4a')](_0x32256d[_0xe89b('0x35')]);_0x53dc4d[_0xe89b('0x36')]=_['intersection'](_0x53dc4d[_0xe89b('0x34')],_0x53dc4d['query']);_0x50a45a['attributes']=_['intersection'](_0x53dc4d[_0xe89b('0x34')],qs['fields'](_0x32256d['query']['fields']));_0x50a45a[_0xe89b('0x38')]=_0x50a45a[_0xe89b('0x38')][_0xe89b('0x3a')]?_0x50a45a[_0xe89b('0x38')]:_0x53dc4d['model'];if(_0x32256d[_0xe89b('0x35')][_0xe89b('0x4b')]){_0x50a45a['include']=[{'all':!![]}];}_0x50a45a=_[_0xe89b('0x3f')]({},_0x50a45a,_0x32256d[_0xe89b('0x4c')]);return db[_0xe89b('0x42')]['find'](_0x50a45a)['then'](handleEntityNotFound(_0x1b0258,null))['then'](respondWithResult(_0x1b0258,null))[_0xe89b('0x47')](handleError(_0x1b0258,null));};exports[_0xe89b('0x4d')]=function(_0x59f73c,_0x4a0d65){return db[_0xe89b('0x42')][_0xe89b('0x4d')](_0x59f73c['body'],{})[_0xe89b('0x29')](respondWithResult(_0x4a0d65,0xc9))[_0xe89b('0x47')](handleError(_0x4a0d65,null));};exports[_0xe89b('0x28')]=function(_0x419cfb,_0x1e94f7){if(_0x419cfb[_0xe89b('0x4e')]['id']){delete _0x419cfb[_0xe89b('0x4e')]['id'];}return db[_0xe89b('0x42')][_0xe89b('0x4f')]({'where':{'id':_0x419cfb[_0xe89b('0x49')]['id']}})['then'](handleEntityNotFound(_0x1e94f7,null))[_0xe89b('0x29')](saveUpdates(_0x419cfb[_0xe89b('0x4e')],null))[_0xe89b('0x29')](respondWithResult(_0x1e94f7,null))[_0xe89b('0x47')](handleError(_0x1e94f7,null));};exports[_0xe89b('0x2a')]=function(_0x123f21,_0x344065){return db['SugarcrmConfiguration'][_0xe89b('0x4f')]({'where':{'id':_0x123f21[_0xe89b('0x49')]['id']}})[_0xe89b('0x29')](handleEntityNotFound(_0x344065,null))['then'](removeEntity(_0x344065,null))[_0xe89b('0x47')](handleError(_0x344065,null));};exports[_0xe89b('0x50')]=function(_0x10dd57,_0x16998d,_0x21878e){var _0x4ed83d={};var _0x5d3b13={};var _0x39d949;var _0x5e69ca;return db[_0xe89b('0x42')]['findOne']({'where':{'id':_0x10dd57[_0xe89b('0x49')]['id']}})['then'](handleEntityNotFound(_0x16998d,null))[_0xe89b('0x29')](function(_0x42128a){if(_0x42128a){_0x39d949=_0x42128a;_0x5d3b13[_0xe89b('0x34')]=_[_0xe89b('0x4a')](db['SugarcrmField'][_0xe89b('0x30')]);_0x5d3b13[_0xe89b('0x35')]=_['keys'](_0x10dd57[_0xe89b('0x35')]);_0x5d3b13['filters']=_[_0xe89b('0x37')](_0x5d3b13[_0xe89b('0x34')],_0x5d3b13['query']);_0x4ed83d[_0xe89b('0x38')]=_[_0xe89b('0x37')](_0x5d3b13['model'],qs['fields'](_0x10dd57['query'][_0xe89b('0x39')]));_0x4ed83d['attributes']=_0x4ed83d[_0xe89b('0x38')][_0xe89b('0x3a')]?_0x4ed83d[_0xe89b('0x38')]:_0x5d3b13[_0xe89b('0x34')];_0x4ed83d[_0xe89b('0x3c')]=qs[_0xe89b('0x3d')](_0x10dd57[_0xe89b('0x35')][_0xe89b('0x3d')]);_0x4ed83d[_0xe89b('0x3e')]=qs['filters'](_[_0xe89b('0x51')](_0x10dd57[_0xe89b('0x35')],_0x5d3b13[_0xe89b('0x36')]));if(_0x10dd57['query']['filter']){_0x4ed83d['where']=_[_0xe89b('0x3f')](_0x4ed83d[_0xe89b('0x3e')],{'$or':_['map'](_0x4ed83d[_0xe89b('0x38')],function(_0x1fdc43){var _0x1464a7={};_0x1464a7[_0x1fdc43]={'$like':'%'+_0x10dd57[_0xe89b('0x35')][_0xe89b('0x41')]+'%'};return _0x1464a7;})});}_0x4ed83d=_['merge']({},_0x4ed83d,_0x10dd57[_0xe89b('0x4c')]);return _0x39d949[_0xe89b('0x50')](_0x4ed83d);}})[_0xe89b('0x29')](function(_0x311ef7){if(_0x311ef7){_0x5e69ca=_0x311ef7['length'];if(!_0x10dd57['query'][_0xe89b('0x3b')](_0xe89b('0x52'))){_0x4ed83d[_0xe89b('0x24')]=qs[_0xe89b('0x24')](_0x10dd57[_0xe89b('0x35')][_0xe89b('0x24')]);_0x4ed83d[_0xe89b('0x23')]=qs['offset'](_0x10dd57[_0xe89b('0x35')]['offset']);}return _0x39d949[_0xe89b('0x50')](_0x4ed83d);}})[_0xe89b('0x29')](function(_0xf2c500){if(_0xf2c500){return _0xf2c500?{'count':_0x5e69ca,'rows':_0xf2c500}:null;}})[_0xe89b('0x29')](respondWithResult(_0x16998d,null))['catch'](handleError(_0x16998d,null));};exports[_0xe89b('0x53')]=function(_0x31363a,_0x2e26b8,_0x16c8d5){var _0x2c63ad={};var _0x323da7={};var _0x13c85e;var _0x4844ad;return db[_0xe89b('0x42')][_0xe89b('0x54')]({'where':{'id':_0x31363a['params']['id']}})[_0xe89b('0x29')](handleEntityNotFound(_0x2e26b8,null))[_0xe89b('0x29')](function(_0x479782){if(_0x479782){_0x13c85e=_0x479782;_0x323da7[_0xe89b('0x34')]=_[_0xe89b('0x4a')](db[_0xe89b('0x55')][_0xe89b('0x30')]);_0x323da7['query']=_['keys'](_0x31363a[_0xe89b('0x35')]);_0x323da7[_0xe89b('0x36')]=_[_0xe89b('0x37')](_0x323da7['model'],_0x323da7[_0xe89b('0x35')]);_0x2c63ad[_0xe89b('0x38')]=_['intersection'](_0x323da7['model'],qs[_0xe89b('0x39')](_0x31363a[_0xe89b('0x35')][_0xe89b('0x39')]));_0x2c63ad['attributes']=_0x2c63ad[_0xe89b('0x38')][_0xe89b('0x3a')]?_0x2c63ad[_0xe89b('0x38')]:_0x323da7['model'];_0x2c63ad['order']=qs['sort'](_0x31363a[_0xe89b('0x35')][_0xe89b('0x3d')]);_0x2c63ad[_0xe89b('0x3e')]=qs[_0xe89b('0x36')](_[_0xe89b('0x51')](_0x31363a[_0xe89b('0x35')],_0x323da7[_0xe89b('0x36')]));if(_0x31363a[_0xe89b('0x35')]['filter']){_0x2c63ad[_0xe89b('0x3e')]=_['merge'](_0x2c63ad['where'],{'$or':_[_0xe89b('0x2f')](_0x2c63ad['attributes'],function(_0x40690d){var _0x4367fa={};_0x4367fa[_0x40690d]={'$like':'%'+_0x31363a[_0xe89b('0x35')]['filter']+'%'};return _0x4367fa;})});}_0x2c63ad=_[_0xe89b('0x3f')]({},_0x2c63ad,_0x31363a[_0xe89b('0x4c')]);return _0x13c85e[_0xe89b('0x53')](_0x2c63ad);}})[_0xe89b('0x29')](function(_0x48a374){if(_0x48a374){_0x4844ad=_0x48a374['length'];if(!_0x31363a[_0xe89b('0x35')][_0xe89b('0x3b')]('nolimit')){_0x2c63ad[_0xe89b('0x24')]=qs[_0xe89b('0x24')](_0x31363a[_0xe89b('0x35')][_0xe89b('0x24')]);_0x2c63ad['offset']=qs[_0xe89b('0x23')](_0x31363a[_0xe89b('0x35')]['offset']);}return _0x13c85e['getSubjects'](_0x2c63ad);}})['then'](function(_0x5473a3){if(_0x5473a3){return _0x5473a3?{'count':_0x4844ad,'rows':_0x5473a3}:null;}})['then'](respondWithResult(_0x2e26b8,null))[_0xe89b('0x47')](handleError(_0x2e26b8,null));};exports['getDescriptions']=function(_0x296c91,_0x4a8c97,_0x4b3ec2){var _0x334c9c={};var _0x2da568={};var _0x2e4cbe;var _0x3f2d9e;return db[_0xe89b('0x42')]['findOne']({'where':{'id':_0x296c91['params']['id']}})[_0xe89b('0x29')](handleEntityNotFound(_0x4a8c97,null))[_0xe89b('0x29')](function(_0x8a7f36){if(_0x8a7f36){_0x2e4cbe=_0x8a7f36;_0x2da568['model']=_[_0xe89b('0x4a')](db[_0xe89b('0x55')][_0xe89b('0x30')]);_0x2da568[_0xe89b('0x35')]=_['keys'](_0x296c91[_0xe89b('0x35')]);_0x2da568[_0xe89b('0x36')]=_['intersection'](_0x2da568[_0xe89b('0x34')],_0x2da568[_0xe89b('0x35')]);_0x334c9c[_0xe89b('0x38')]=_['intersection'](_0x2da568[_0xe89b('0x34')],qs['fields'](_0x296c91[_0xe89b('0x35')][_0xe89b('0x39')]));_0x334c9c['attributes']=_0x334c9c[_0xe89b('0x38')][_0xe89b('0x3a')]?_0x334c9c[_0xe89b('0x38')]:_0x2da568[_0xe89b('0x34')];_0x334c9c[_0xe89b('0x3c')]=qs['sort'](_0x296c91['query'][_0xe89b('0x3d')]);_0x334c9c['where']=qs['filters'](_[_0xe89b('0x51')](_0x296c91['query'],_0x2da568['filters']));if(_0x296c91[_0xe89b('0x35')]['filter']){_0x334c9c[_0xe89b('0x3e')]=_[_0xe89b('0x3f')](_0x334c9c[_0xe89b('0x3e')],{'$or':_[_0xe89b('0x2f')](_0x334c9c[_0xe89b('0x38')],function(_0x1d350c){var _0x136d3d={};_0x136d3d[_0x1d350c]={'$like':'%'+_0x296c91[_0xe89b('0x35')][_0xe89b('0x41')]+'%'};return _0x136d3d;})});}_0x334c9c=_[_0xe89b('0x3f')]({},_0x334c9c,_0x296c91[_0xe89b('0x4c')]);return _0x2e4cbe['getDescriptions'](_0x334c9c);}})[_0xe89b('0x29')](function(_0x2ce5c7){if(_0x2ce5c7){_0x3f2d9e=_0x2ce5c7[_0xe89b('0x3a')];if(!_0x296c91[_0xe89b('0x35')][_0xe89b('0x3b')](_0xe89b('0x52'))){_0x334c9c[_0xe89b('0x24')]=qs[_0xe89b('0x24')](_0x296c91[_0xe89b('0x35')]['limit']);_0x334c9c[_0xe89b('0x23')]=qs[_0xe89b('0x23')](_0x296c91['query'][_0xe89b('0x23')]);}return _0x2e4cbe['getDescriptions'](_0x334c9c);}})[_0xe89b('0x29')](function(_0x38dd9c){if(_0x38dd9c){return _0x38dd9c?{'count':_0x3f2d9e,'rows':_0x38dd9c}:null;}})[_0xe89b('0x29')](respondWithResult(_0x4a8c97,null))['catch'](handleError(_0x4a8c97,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