// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xca38=['filters','intersection','model','attributes','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','rows','catch','show','params','keys','fields','length','find','create','body','update','getFields','getSubjects','findOne','getDescriptions','SugarcrmField','zip-dir','fast-json-patch','request-promise','moment','mustache','path','sox','ejs','fs-extra','lodash','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','then','sendStatus','error','stack','name','index','map','SugarcrmConfiguration','rawAttributes','fieldName','type','query'];(function(_0x24fa1a,_0x16d9c2){var _0xc5621f=function(_0x5616ac){while(--_0x5616ac){_0x24fa1a['push'](_0x24fa1a['shift']());}};_0xc5621f(++_0x16d9c2);}(_0xca38,0x1ba));var _0x8ca3=function(_0x591aae,_0x1259f7){_0x591aae=_0x591aae-0x0;var _0x5d0fef=_0xca38[_0x591aae];return _0x5d0fef;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x8ca3('0x0'));var jsonpatch=require(_0x8ca3('0x1'));var rp=require(_0x8ca3('0x2'));var moment=require(_0x8ca3('0x3'));var BPromise=require('bluebird');var Mustache=require(_0x8ca3('0x4'));var util=require('util');var path=require(_0x8ca3('0x5'));var sox=require(_0x8ca3('0x6'));var csv=require('to-csv');var ejs=require(_0x8ca3('0x7'));var fs=require('fs');var fs_extra=require(_0x8ca3('0x8'));var _=require(_0x8ca3('0x9'));var squel=require('squel');var crypto=require(_0x8ca3('0xa'));var jsforce=require(_0x8ca3('0xb'));var deskjs=require(_0x8ca3('0xc'));var toCsv=require(_0x8ca3('0xd'));var querystring=require(_0x8ca3('0xe'));var Papa=require(_0x8ca3('0xf'));var Redis=require(_0x8ca3('0x10'));var authService=require(_0x8ca3('0x11'));var qs=require(_0x8ca3('0x12'));var as=require(_0x8ca3('0x13'));var hardwareService=require(_0x8ca3('0x14'));var logger=require(_0x8ca3('0x15'))(_0x8ca3('0x16'));var utils=require(_0x8ca3('0x17'));var config=require(_0x8ca3('0x18'));var licenseUtil=require(_0x8ca3('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x1e5ef3,_0x5203fb){_0x5203fb=_0x5203fb||0xcc;return function(_0x80f231){if(_0x80f231){return _0x1e5ef3['sendStatus'](_0x5203fb);}return _0x1e5ef3[_0x8ca3('0x1a')](_0x5203fb)[_0x8ca3('0x1b')]();};}function respondWithResult(_0x478f4e,_0x1002b9){_0x1002b9=_0x1002b9||0xc8;return function(_0x42f3f3){if(_0x42f3f3){return _0x478f4e[_0x8ca3('0x1a')](_0x1002b9)[_0x8ca3('0x1c')](_0x42f3f3);}};}function respondWithFilteredResult(_0x43de29,_0x1535d3){return function(_0x22bced){if(_0x22bced){var _0x345627=typeof _0x1535d3[_0x8ca3('0x1d')]===_0x8ca3('0x1e')&&typeof _0x1535d3[_0x8ca3('0x1f')]===_0x8ca3('0x1e');var _0x5177e9=_0x22bced[_0x8ca3('0x20')];var _0xdf90e6=_0x345627?0x0:_0x1535d3[_0x8ca3('0x1d')];var _0x44f964=_0x345627?_0x22bced[_0x8ca3('0x20')]:_0x1535d3[_0x8ca3('0x1d')]+_0x1535d3[_0x8ca3('0x1f')];var _0x251a88;if(_0x44f964>=_0x5177e9){_0x44f964=_0x5177e9;_0x251a88=0xc8;}else{_0x251a88=0xce;}_0x43de29[_0x8ca3('0x1a')](_0x251a88);return _0x43de29[_0x8ca3('0x21')](_0x8ca3('0x22'),_0xdf90e6+'-'+_0x44f964+'/'+_0x5177e9)[_0x8ca3('0x1c')](_0x22bced);}return null;};}function patchUpdates(_0x4ddb9f){return function(_0x2c9942){try{jsonpatch[_0x8ca3('0x23')](_0x2c9942,_0x4ddb9f,!![]);}catch(_0x4a4ded){return BPromise[_0x8ca3('0x24')](_0x4a4ded);}return _0x2c9942[_0x8ca3('0x25')]();};}function saveUpdates(_0x29f681,_0x18b0f8){return function(_0x55e599){if(_0x55e599){return _0x55e599['update'](_0x29f681)[_0x8ca3('0x26')](function(_0x93acfe){return _0x93acfe;});}return null;};}function removeEntity(_0x20b423,_0x74fee){return function(_0x526072){if(_0x526072){return _0x526072['destroy']()[_0x8ca3('0x26')](function(){_0x20b423[_0x8ca3('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0x103874,_0x5c21ab){return function(_0x25b5bb){if(!_0x25b5bb){_0x103874[_0x8ca3('0x27')](0x194);}return _0x25b5bb;};}function handleError(_0x5d1fd3,_0x565812){_0x565812=_0x565812||0x1f4;return function(_0x27d537){logger[_0x8ca3('0x28')](_0x27d537[_0x8ca3('0x29')]);if(_0x27d537[_0x8ca3('0x2a')]){delete _0x27d537[_0x8ca3('0x2a')];}_0x5d1fd3['status'](_0x565812)['send'](_0x27d537);};}exports[_0x8ca3('0x2b')]=function(_0x301a85,_0x58ba83){var _0x1e45c3={},_0x2443c3={},_0xefb575={'count':0x0,'rows':[]};var _0x19ab47=_[_0x8ca3('0x2c')](db[_0x8ca3('0x2d')][_0x8ca3('0x2e')],function(_0x154273){return{'name':_0x154273[_0x8ca3('0x2f')],'type':_0x154273[_0x8ca3('0x30')]['key']};});_0x2443c3['model']=_['map'](_0x19ab47,_0x8ca3('0x2a'));_0x2443c3[_0x8ca3('0x31')]=_['keys'](_0x301a85[_0x8ca3('0x31')]);_0x2443c3[_0x8ca3('0x32')]=_[_0x8ca3('0x33')](_0x2443c3[_0x8ca3('0x34')],_0x2443c3[_0x8ca3('0x31')]);_0x1e45c3[_0x8ca3('0x35')]=_[_0x8ca3('0x33')](_0x2443c3[_0x8ca3('0x34')],qs['fields'](_0x301a85[_0x8ca3('0x31')]['fields']));_0x1e45c3['attributes']=_0x1e45c3[_0x8ca3('0x35')]['length']?_0x1e45c3[_0x8ca3('0x35')]:_0x2443c3[_0x8ca3('0x34')];if(!_0x301a85[_0x8ca3('0x31')][_0x8ca3('0x36')](_0x8ca3('0x37'))){_0x1e45c3['limit']=qs[_0x8ca3('0x1f')](_0x301a85[_0x8ca3('0x31')]['limit']);_0x1e45c3['offset']=qs[_0x8ca3('0x1d')](_0x301a85[_0x8ca3('0x31')]['offset']);}_0x1e45c3[_0x8ca3('0x38')]=qs[_0x8ca3('0x39')](_0x301a85[_0x8ca3('0x31')][_0x8ca3('0x39')]);_0x1e45c3['where']=qs[_0x8ca3('0x32')](_[_0x8ca3('0x3a')](_0x301a85[_0x8ca3('0x31')],_0x2443c3[_0x8ca3('0x32')]),_0x19ab47);if(_0x301a85[_0x8ca3('0x31')][_0x8ca3('0x3b')]){_0x1e45c3[_0x8ca3('0x3c')]=_[_0x8ca3('0x3d')](_0x1e45c3[_0x8ca3('0x3c')],{'$or':_[_0x8ca3('0x2c')](_0x19ab47,function(_0x5a968f){if(_0x5a968f[_0x8ca3('0x30')]!==_0x8ca3('0x3e')){var _0x5b8f28={};_0x5b8f28[_0x5a968f['name']]={'$like':'%'+_0x301a85[_0x8ca3('0x31')]['filter']+'%'};return _0x5b8f28;}})});}_0x1e45c3=_[_0x8ca3('0x3d')]({},_0x1e45c3,_0x301a85[_0x8ca3('0x3f')]);var _0x56d87f={'where':_0x1e45c3['where']};return db['SugarcrmConfiguration']['count'](_0x56d87f)[_0x8ca3('0x26')](function(_0xf462a3){_0xefb575[_0x8ca3('0x20')]=_0xf462a3;if(_0x301a85['query'][_0x8ca3('0x40')]){_0x1e45c3[_0x8ca3('0x41')]=[{'all':!![]}];}return db[_0x8ca3('0x2d')]['findAll'](_0x1e45c3);})[_0x8ca3('0x26')](function(_0x1859d4){_0xefb575[_0x8ca3('0x42')]=_0x1859d4;return _0xefb575;})[_0x8ca3('0x26')](respondWithFilteredResult(_0x58ba83,_0x1e45c3))[_0x8ca3('0x43')](handleError(_0x58ba83,null));};exports[_0x8ca3('0x44')]=function(_0x511755,_0x58c8a8){var _0x52fb7f={'raw':![],'where':{'id':_0x511755[_0x8ca3('0x45')]['id']}},_0x165785={};_0x165785[_0x8ca3('0x34')]=_[_0x8ca3('0x46')](db[_0x8ca3('0x2d')][_0x8ca3('0x2e')]);_0x165785['query']=_['keys'](_0x511755[_0x8ca3('0x31')]);_0x165785[_0x8ca3('0x32')]=_[_0x8ca3('0x33')](_0x165785[_0x8ca3('0x34')],_0x165785[_0x8ca3('0x31')]);_0x52fb7f[_0x8ca3('0x35')]=_[_0x8ca3('0x33')](_0x165785[_0x8ca3('0x34')],qs[_0x8ca3('0x47')](_0x511755[_0x8ca3('0x31')][_0x8ca3('0x47')]));_0x52fb7f[_0x8ca3('0x35')]=_0x52fb7f[_0x8ca3('0x35')][_0x8ca3('0x48')]?_0x52fb7f['attributes']:_0x165785[_0x8ca3('0x34')];if(_0x511755['query'][_0x8ca3('0x40')]){_0x52fb7f[_0x8ca3('0x41')]=[{'all':!![]}];}_0x52fb7f=_[_0x8ca3('0x3d')]({},_0x52fb7f,_0x511755[_0x8ca3('0x3f')]);return db[_0x8ca3('0x2d')][_0x8ca3('0x49')](_0x52fb7f)[_0x8ca3('0x26')](handleEntityNotFound(_0x58c8a8,null))['then'](respondWithResult(_0x58c8a8,null))[_0x8ca3('0x43')](handleError(_0x58c8a8,null));};exports[_0x8ca3('0x4a')]=function(_0x84055f,_0x154a26){return db[_0x8ca3('0x2d')]['create'](_0x84055f[_0x8ca3('0x4b')],{})['then'](respondWithResult(_0x154a26,0xc9))['catch'](handleError(_0x154a26,null));};exports[_0x8ca3('0x4c')]=function(_0x301e05,_0x10f016){if(_0x301e05['body']['id']){delete _0x301e05[_0x8ca3('0x4b')]['id'];}return db['SugarcrmConfiguration'][_0x8ca3('0x49')]({'where':{'id':_0x301e05[_0x8ca3('0x45')]['id']}})[_0x8ca3('0x26')](handleEntityNotFound(_0x10f016,null))['then'](saveUpdates(_0x301e05['body'],null))['then'](respondWithResult(_0x10f016,null))[_0x8ca3('0x43')](handleError(_0x10f016,null));};exports['destroy']=function(_0x49eb9b,_0x536335){return db[_0x8ca3('0x2d')][_0x8ca3('0x49')]({'where':{'id':_0x49eb9b[_0x8ca3('0x45')]['id']}})[_0x8ca3('0x26')](handleEntityNotFound(_0x536335,null))['then'](removeEntity(_0x536335,null))[_0x8ca3('0x43')](handleError(_0x536335,null));};exports[_0x8ca3('0x4d')]=function(_0x2a6f3c,_0x5abc60,_0x286431){var _0x16d02b={};var _0x5bdd40={};var _0x3e8938;var _0x298e70;return db[_0x8ca3('0x2d')]['findOne']({'where':{'id':_0x2a6f3c[_0x8ca3('0x45')]['id']}})['then'](handleEntityNotFound(_0x5abc60,null))[_0x8ca3('0x26')](function(_0xec8b1){if(_0xec8b1){_0x3e8938=_0xec8b1;_0x5bdd40[_0x8ca3('0x34')]=_['keys'](db['SugarcrmField'][_0x8ca3('0x2e')]);_0x5bdd40[_0x8ca3('0x31')]=_[_0x8ca3('0x46')](_0x2a6f3c[_0x8ca3('0x31')]);_0x5bdd40[_0x8ca3('0x32')]=_[_0x8ca3('0x33')](_0x5bdd40[_0x8ca3('0x34')],_0x5bdd40['query']);_0x16d02b[_0x8ca3('0x35')]=_[_0x8ca3('0x33')](_0x5bdd40[_0x8ca3('0x34')],qs[_0x8ca3('0x47')](_0x2a6f3c[_0x8ca3('0x31')][_0x8ca3('0x47')]));_0x16d02b[_0x8ca3('0x35')]=_0x16d02b['attributes'][_0x8ca3('0x48')]?_0x16d02b[_0x8ca3('0x35')]:_0x5bdd40[_0x8ca3('0x34')];_0x16d02b[_0x8ca3('0x38')]=qs[_0x8ca3('0x39')](_0x2a6f3c[_0x8ca3('0x31')][_0x8ca3('0x39')]);_0x16d02b[_0x8ca3('0x3c')]=qs[_0x8ca3('0x32')](_['pick'](_0x2a6f3c[_0x8ca3('0x31')],_0x5bdd40[_0x8ca3('0x32')]));if(_0x2a6f3c[_0x8ca3('0x31')][_0x8ca3('0x3b')]){_0x16d02b[_0x8ca3('0x3c')]=_[_0x8ca3('0x3d')](_0x16d02b['where'],{'$or':_[_0x8ca3('0x2c')](_0x16d02b[_0x8ca3('0x35')],function(_0x469d33){var _0x3d0c75={};_0x3d0c75[_0x469d33]={'$like':'%'+_0x2a6f3c[_0x8ca3('0x31')][_0x8ca3('0x3b')]+'%'};return _0x3d0c75;})});}_0x16d02b=_['merge']({},_0x16d02b,_0x2a6f3c['options']);return _0x3e8938[_0x8ca3('0x4d')](_0x16d02b);}})['then'](function(_0x4320e0){if(_0x4320e0){_0x298e70=_0x4320e0[_0x8ca3('0x48')];if(!_0x2a6f3c[_0x8ca3('0x31')][_0x8ca3('0x36')](_0x8ca3('0x37'))){_0x16d02b['limit']=qs[_0x8ca3('0x1f')](_0x2a6f3c[_0x8ca3('0x31')][_0x8ca3('0x1f')]);_0x16d02b[_0x8ca3('0x1d')]=qs['offset'](_0x2a6f3c[_0x8ca3('0x31')][_0x8ca3('0x1d')]);}return _0x3e8938[_0x8ca3('0x4d')](_0x16d02b);}})[_0x8ca3('0x26')](function(_0x5450cc){if(_0x5450cc){return _0x5450cc?{'count':_0x298e70,'rows':_0x5450cc}:null;}})[_0x8ca3('0x26')](respondWithResult(_0x5abc60,null))[_0x8ca3('0x43')](handleError(_0x5abc60,null));};exports[_0x8ca3('0x4e')]=function(_0x1e1cec,_0x7c20ba,_0x16f9b2){var _0x56e888={};var _0x312d91={};var _0x2fe64a;var _0x5d070f;return db[_0x8ca3('0x2d')][_0x8ca3('0x4f')]({'where':{'id':_0x1e1cec[_0x8ca3('0x45')]['id']}})[_0x8ca3('0x26')](handleEntityNotFound(_0x7c20ba,null))[_0x8ca3('0x26')](function(_0x562286){if(_0x562286){_0x2fe64a=_0x562286;_0x312d91[_0x8ca3('0x34')]=_['keys'](db['SugarcrmField']['rawAttributes']);_0x312d91[_0x8ca3('0x31')]=_[_0x8ca3('0x46')](_0x1e1cec[_0x8ca3('0x31')]);_0x312d91[_0x8ca3('0x32')]=_[_0x8ca3('0x33')](_0x312d91[_0x8ca3('0x34')],_0x312d91['query']);_0x56e888[_0x8ca3('0x35')]=_['intersection'](_0x312d91[_0x8ca3('0x34')],qs[_0x8ca3('0x47')](_0x1e1cec['query']['fields']));_0x56e888[_0x8ca3('0x35')]=_0x56e888[_0x8ca3('0x35')][_0x8ca3('0x48')]?_0x56e888[_0x8ca3('0x35')]:_0x312d91[_0x8ca3('0x34')];_0x56e888[_0x8ca3('0x38')]=qs[_0x8ca3('0x39')](_0x1e1cec['query'][_0x8ca3('0x39')]);_0x56e888[_0x8ca3('0x3c')]=qs[_0x8ca3('0x32')](_[_0x8ca3('0x3a')](_0x1e1cec[_0x8ca3('0x31')],_0x312d91[_0x8ca3('0x32')]));if(_0x1e1cec['query'][_0x8ca3('0x3b')]){_0x56e888[_0x8ca3('0x3c')]=_[_0x8ca3('0x3d')](_0x56e888[_0x8ca3('0x3c')],{'$or':_['map'](_0x56e888['attributes'],function(_0x3eb859){var _0x49cb1d={};_0x49cb1d[_0x3eb859]={'$like':'%'+_0x1e1cec[_0x8ca3('0x31')][_0x8ca3('0x3b')]+'%'};return _0x49cb1d;})});}_0x56e888=_[_0x8ca3('0x3d')]({},_0x56e888,_0x1e1cec[_0x8ca3('0x3f')]);return _0x2fe64a[_0x8ca3('0x4e')](_0x56e888);}})['then'](function(_0x4bbaaf){if(_0x4bbaaf){_0x5d070f=_0x4bbaaf[_0x8ca3('0x48')];if(!_0x1e1cec['query'][_0x8ca3('0x36')](_0x8ca3('0x37'))){_0x56e888[_0x8ca3('0x1f')]=qs['limit'](_0x1e1cec[_0x8ca3('0x31')][_0x8ca3('0x1f')]);_0x56e888['offset']=qs[_0x8ca3('0x1d')](_0x1e1cec[_0x8ca3('0x31')][_0x8ca3('0x1d')]);}return _0x2fe64a['getSubjects'](_0x56e888);}})[_0x8ca3('0x26')](function(_0x529009){if(_0x529009){return _0x529009?{'count':_0x5d070f,'rows':_0x529009}:null;}})[_0x8ca3('0x26')](respondWithResult(_0x7c20ba,null))['catch'](handleError(_0x7c20ba,null));};exports[_0x8ca3('0x50')]=function(_0x36eff7,_0x317952,_0x4a5b91){var _0x47706d={};var _0x586526={};var _0x23de6e;var _0x50f419;return db[_0x8ca3('0x2d')][_0x8ca3('0x4f')]({'where':{'id':_0x36eff7['params']['id']}})['then'](handleEntityNotFound(_0x317952,null))[_0x8ca3('0x26')](function(_0x37a86f){if(_0x37a86f){_0x23de6e=_0x37a86f;_0x586526[_0x8ca3('0x34')]=_[_0x8ca3('0x46')](db[_0x8ca3('0x51')][_0x8ca3('0x2e')]);_0x586526['query']=_[_0x8ca3('0x46')](_0x36eff7['query']);_0x586526[_0x8ca3('0x32')]=_[_0x8ca3('0x33')](_0x586526[_0x8ca3('0x34')],_0x586526['query']);_0x47706d[_0x8ca3('0x35')]=_[_0x8ca3('0x33')](_0x586526[_0x8ca3('0x34')],qs[_0x8ca3('0x47')](_0x36eff7[_0x8ca3('0x31')][_0x8ca3('0x47')]));_0x47706d[_0x8ca3('0x35')]=_0x47706d['attributes']['length']?_0x47706d[_0x8ca3('0x35')]:_0x586526[_0x8ca3('0x34')];_0x47706d[_0x8ca3('0x38')]=qs['sort'](_0x36eff7[_0x8ca3('0x31')][_0x8ca3('0x39')]);_0x47706d[_0x8ca3('0x3c')]=qs[_0x8ca3('0x32')](_[_0x8ca3('0x3a')](_0x36eff7[_0x8ca3('0x31')],_0x586526[_0x8ca3('0x32')]));if(_0x36eff7[_0x8ca3('0x31')][_0x8ca3('0x3b')]){_0x47706d[_0x8ca3('0x3c')]=_[_0x8ca3('0x3d')](_0x47706d[_0x8ca3('0x3c')],{'$or':_[_0x8ca3('0x2c')](_0x47706d[_0x8ca3('0x35')],function(_0x16cbe5){var _0x607d8f={};_0x607d8f[_0x16cbe5]={'$like':'%'+_0x36eff7['query']['filter']+'%'};return _0x607d8f;})});}_0x47706d=_[_0x8ca3('0x3d')]({},_0x47706d,_0x36eff7[_0x8ca3('0x3f')]);return _0x23de6e[_0x8ca3('0x50')](_0x47706d);}})[_0x8ca3('0x26')](function(_0x21d809){if(_0x21d809){_0x50f419=_0x21d809[_0x8ca3('0x48')];if(!_0x36eff7[_0x8ca3('0x31')][_0x8ca3('0x36')](_0x8ca3('0x37'))){_0x47706d[_0x8ca3('0x1f')]=qs[_0x8ca3('0x1f')](_0x36eff7[_0x8ca3('0x31')][_0x8ca3('0x1f')]);_0x47706d[_0x8ca3('0x1d')]=qs['offset'](_0x36eff7['query']['offset']);}return _0x23de6e[_0x8ca3('0x50')](_0x47706d);}})[_0x8ca3('0x26')](function(_0x359285){if(_0x359285){return _0x359285?{'count':_0x50f419,'rows':_0x359285}:null;}})[_0x8ca3('0x26')](respondWithResult(_0x317952,null))[_0x8ca3('0x43')](handleError(_0x317952,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