// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xd9a7=['model','query','keys','filters','intersection','attributes','fields','length','nolimit','order','sort','where','pick','filter','merge','type','VIRTUAL','options','SugarcrmConfiguration','includeAll','include','rows','catch','show','params','rawAttributes','find','create','body','getFields','findOne','SugarcrmField','getSubjects','hasOwnProperty','getDescriptions','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','ejs','squel','crypto','jsforce','desk.js','querystring','papaparse','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','count','Content-Range','apply','reject','update','then','destroy','error','stack','name','index','map'];(function(_0x44c844,_0x1e3d7d){var _0x1d51b7=function(_0x575840){while(--_0x575840){_0x44c844['push'](_0x44c844['shift']());}};_0x1d51b7(++_0x1e3d7d);}(_0xd9a7,0xbb));var _0x7d9a=function(_0xa368d,_0x501d61){_0xa368d=_0xa368d-0x0;var _0x3499fa=_0xd9a7[_0xa368d];return _0x3499fa;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x7d9a('0x0'));var zipdir=require(_0x7d9a('0x1'));var jsonpatch=require(_0x7d9a('0x2'));var rp=require(_0x7d9a('0x3'));var moment=require(_0x7d9a('0x4'));var BPromise=require(_0x7d9a('0x5'));var Mustache=require('mustache');var util=require(_0x7d9a('0x6'));var path=require(_0x7d9a('0x7'));var sox=require(_0x7d9a('0x8'));var csv=require('to-csv');var ejs=require(_0x7d9a('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x7d9a('0xa'));var crypto=require(_0x7d9a('0xb'));var jsforce=require(_0x7d9a('0xc'));var deskjs=require(_0x7d9a('0xd'));var toCsv=require('to-csv');var querystring=require(_0x7d9a('0xe'));var Papa=require(_0x7d9a('0xf'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x7d9a('0x10'));var logger=require(_0x7d9a('0x11'))(_0x7d9a('0x12'));var utils=require(_0x7d9a('0x13'));var config=require(_0x7d9a('0x14'));var licenseUtil=require(_0x7d9a('0x15'));var db=require(_0x7d9a('0x16'))['db'];function respondWithStatusCode(_0x26a650,_0x362ec6){_0x362ec6=_0x362ec6||0xcc;return function(_0x3c0bdc){if(_0x3c0bdc){return _0x26a650[_0x7d9a('0x17')](_0x362ec6);}return _0x26a650[_0x7d9a('0x18')](_0x362ec6)[_0x7d9a('0x19')]();};}function respondWithResult(_0x1f7e8b,_0x16153e){_0x16153e=_0x16153e||0xc8;return function(_0x5e98b8){if(_0x5e98b8){return _0x1f7e8b[_0x7d9a('0x18')](_0x16153e)[_0x7d9a('0x1a')](_0x5e98b8);}};}function respondWithFilteredResult(_0x4f0373,_0x1dbd68){return function(_0x2964c7){if(_0x2964c7){var _0x5b1775=typeof _0x1dbd68[_0x7d9a('0x1b')]==='undefined'&&typeof _0x1dbd68[_0x7d9a('0x1c')]==='undefined';var _0x109570=_0x2964c7[_0x7d9a('0x1d')];var _0xe2f789=_0x5b1775?0x0:_0x1dbd68[_0x7d9a('0x1b')];var _0x2ae149=_0x5b1775?_0x2964c7['count']:_0x1dbd68[_0x7d9a('0x1b')]+_0x1dbd68[_0x7d9a('0x1c')];var _0x4e4c8b;if(_0x2ae149>=_0x109570){_0x2ae149=_0x109570;_0x4e4c8b=0xc8;}else{_0x4e4c8b=0xce;}_0x4f0373[_0x7d9a('0x18')](_0x4e4c8b);return _0x4f0373['set'](_0x7d9a('0x1e'),_0xe2f789+'-'+_0x2ae149+'/'+_0x109570)[_0x7d9a('0x1a')](_0x2964c7);}return null;};}function patchUpdates(_0x27629f){return function(_0x58583e){try{jsonpatch[_0x7d9a('0x1f')](_0x58583e,_0x27629f,!![]);}catch(_0x5c9093){return BPromise[_0x7d9a('0x20')](_0x5c9093);}return _0x58583e['save']();};}function saveUpdates(_0x391f90,_0x1285bd){return function(_0x331c86){if(_0x331c86){return _0x331c86[_0x7d9a('0x21')](_0x391f90)[_0x7d9a('0x22')](function(_0x2ed276){return _0x2ed276;});}return null;};}function removeEntity(_0x3a6dd6,_0x33c905){return function(_0x530d10){if(_0x530d10){return _0x530d10[_0x7d9a('0x23')]()[_0x7d9a('0x22')](function(){_0x3a6dd6[_0x7d9a('0x18')](0xcc)[_0x7d9a('0x19')]();});}};}function handleEntityNotFound(_0x22c211,_0x277d0c){return function(_0x56ad69){if(!_0x56ad69){_0x22c211['sendStatus'](0x194);}return _0x56ad69;};}function handleError(_0x49a679,_0x16a4de){_0x16a4de=_0x16a4de||0x1f4;return function(_0x1bba29){logger[_0x7d9a('0x24')](_0x1bba29[_0x7d9a('0x25')]);if(_0x1bba29[_0x7d9a('0x26')]){delete _0x1bba29[_0x7d9a('0x26')];}_0x49a679['status'](_0x16a4de)['send'](_0x1bba29);};}exports[_0x7d9a('0x27')]=function(_0x3a95a6,_0x27c134){var _0x25ed3c={},_0x179554={},_0x1d45e7={'count':0x0,'rows':[]};var _0x4b7c27=_[_0x7d9a('0x28')](db['SugarcrmConfiguration']['rawAttributes'],function(_0x15bc71){return{'name':_0x15bc71['fieldName'],'type':_0x15bc71['type']['key']};});_0x179554[_0x7d9a('0x29')]=_[_0x7d9a('0x28')](_0x4b7c27,_0x7d9a('0x26'));_0x179554[_0x7d9a('0x2a')]=_[_0x7d9a('0x2b')](_0x3a95a6[_0x7d9a('0x2a')]);_0x179554[_0x7d9a('0x2c')]=_[_0x7d9a('0x2d')](_0x179554[_0x7d9a('0x29')],_0x179554[_0x7d9a('0x2a')]);_0x25ed3c[_0x7d9a('0x2e')]=_[_0x7d9a('0x2d')](_0x179554[_0x7d9a('0x29')],qs[_0x7d9a('0x2f')](_0x3a95a6[_0x7d9a('0x2a')]['fields']));_0x25ed3c[_0x7d9a('0x2e')]=_0x25ed3c[_0x7d9a('0x2e')][_0x7d9a('0x30')]?_0x25ed3c[_0x7d9a('0x2e')]:_0x179554[_0x7d9a('0x29')];if(!_0x3a95a6[_0x7d9a('0x2a')]['hasOwnProperty'](_0x7d9a('0x31'))){_0x25ed3c[_0x7d9a('0x1c')]=qs[_0x7d9a('0x1c')](_0x3a95a6['query']['limit']);_0x25ed3c[_0x7d9a('0x1b')]=qs[_0x7d9a('0x1b')](_0x3a95a6[_0x7d9a('0x2a')][_0x7d9a('0x1b')]);}_0x25ed3c[_0x7d9a('0x32')]=qs['sort'](_0x3a95a6[_0x7d9a('0x2a')][_0x7d9a('0x33')]);_0x25ed3c[_0x7d9a('0x34')]=qs[_0x7d9a('0x2c')](_[_0x7d9a('0x35')](_0x3a95a6[_0x7d9a('0x2a')],_0x179554[_0x7d9a('0x2c')]),_0x4b7c27);if(_0x3a95a6['query'][_0x7d9a('0x36')]){_0x25ed3c[_0x7d9a('0x34')]=_[_0x7d9a('0x37')](_0x25ed3c[_0x7d9a('0x34')],{'$or':_[_0x7d9a('0x28')](_0x4b7c27,function(_0x2ecb5d){if(_0x2ecb5d[_0x7d9a('0x38')]!==_0x7d9a('0x39')){var _0x572287={};_0x572287[_0x2ecb5d[_0x7d9a('0x26')]]={'$like':'%'+_0x3a95a6['query'][_0x7d9a('0x36')]+'%'};return _0x572287;}})});}_0x25ed3c=_[_0x7d9a('0x37')]({},_0x25ed3c,_0x3a95a6[_0x7d9a('0x3a')]);var _0x1412b9={'where':_0x25ed3c['where']};return db[_0x7d9a('0x3b')]['count'](_0x1412b9)[_0x7d9a('0x22')](function(_0x46c182){_0x1d45e7['count']=_0x46c182;if(_0x3a95a6['query'][_0x7d9a('0x3c')]){_0x25ed3c[_0x7d9a('0x3d')]=[{'all':!![]}];}return db[_0x7d9a('0x3b')]['findAll'](_0x25ed3c);})[_0x7d9a('0x22')](function(_0x2b9ff8){_0x1d45e7[_0x7d9a('0x3e')]=_0x2b9ff8;return _0x1d45e7;})[_0x7d9a('0x22')](respondWithFilteredResult(_0x27c134,_0x25ed3c))[_0x7d9a('0x3f')](handleError(_0x27c134,null));};exports[_0x7d9a('0x40')]=function(_0x3e3798,_0x351e33){var _0x3f142d={'raw':![],'where':{'id':_0x3e3798[_0x7d9a('0x41')]['id']}},_0x5d8870={};_0x5d8870['model']=_[_0x7d9a('0x2b')](db['SugarcrmConfiguration'][_0x7d9a('0x42')]);_0x5d8870['query']=_[_0x7d9a('0x2b')](_0x3e3798[_0x7d9a('0x2a')]);_0x5d8870[_0x7d9a('0x2c')]=_['intersection'](_0x5d8870['model'],_0x5d8870[_0x7d9a('0x2a')]);_0x3f142d[_0x7d9a('0x2e')]=_[_0x7d9a('0x2d')](_0x5d8870['model'],qs[_0x7d9a('0x2f')](_0x3e3798['query']['fields']));_0x3f142d[_0x7d9a('0x2e')]=_0x3f142d[_0x7d9a('0x2e')][_0x7d9a('0x30')]?_0x3f142d[_0x7d9a('0x2e')]:_0x5d8870['model'];if(_0x3e3798[_0x7d9a('0x2a')][_0x7d9a('0x3c')]){_0x3f142d[_0x7d9a('0x3d')]=[{'all':!![]}];}_0x3f142d=_['merge']({},_0x3f142d,_0x3e3798[_0x7d9a('0x3a')]);return db[_0x7d9a('0x3b')][_0x7d9a('0x43')](_0x3f142d)[_0x7d9a('0x22')](handleEntityNotFound(_0x351e33,null))['then'](respondWithResult(_0x351e33,null))[_0x7d9a('0x3f')](handleError(_0x351e33,null));};exports['create']=function(_0x570932,_0x1a1fb8){return db[_0x7d9a('0x3b')][_0x7d9a('0x44')](_0x570932[_0x7d9a('0x45')],{})[_0x7d9a('0x22')](respondWithResult(_0x1a1fb8,0xc9))[_0x7d9a('0x3f')](handleError(_0x1a1fb8,null));};exports[_0x7d9a('0x21')]=function(_0x3e513d,_0x51fcf0){if(_0x3e513d[_0x7d9a('0x45')]['id']){delete _0x3e513d['body']['id'];}return db[_0x7d9a('0x3b')][_0x7d9a('0x43')]({'where':{'id':_0x3e513d[_0x7d9a('0x41')]['id']}})['then'](handleEntityNotFound(_0x51fcf0,null))[_0x7d9a('0x22')](saveUpdates(_0x3e513d[_0x7d9a('0x45')],null))[_0x7d9a('0x22')](respondWithResult(_0x51fcf0,null))[_0x7d9a('0x3f')](handleError(_0x51fcf0,null));};exports[_0x7d9a('0x23')]=function(_0x15feb2,_0x4d6c51){return db['SugarcrmConfiguration'][_0x7d9a('0x43')]({'where':{'id':_0x15feb2[_0x7d9a('0x41')]['id']}})[_0x7d9a('0x22')](handleEntityNotFound(_0x4d6c51,null))[_0x7d9a('0x22')](removeEntity(_0x4d6c51,null))['catch'](handleError(_0x4d6c51,null));};exports[_0x7d9a('0x46')]=function(_0x3be5e9,_0x248c9d,_0x49f343){var _0x260c59={};var _0x2e5941={};var _0x1bc695;var _0x58ff90;return db[_0x7d9a('0x3b')][_0x7d9a('0x47')]({'where':{'id':_0x3be5e9['params']['id']}})[_0x7d9a('0x22')](handleEntityNotFound(_0x248c9d,null))['then'](function(_0x2ffaff){if(_0x2ffaff){_0x1bc695=_0x2ffaff;_0x2e5941[_0x7d9a('0x29')]=_['keys'](db[_0x7d9a('0x48')]['rawAttributes']);_0x2e5941[_0x7d9a('0x2a')]=_['keys'](_0x3be5e9[_0x7d9a('0x2a')]);_0x2e5941[_0x7d9a('0x2c')]=_[_0x7d9a('0x2d')](_0x2e5941['model'],_0x2e5941[_0x7d9a('0x2a')]);_0x260c59['attributes']=_[_0x7d9a('0x2d')](_0x2e5941[_0x7d9a('0x29')],qs[_0x7d9a('0x2f')](_0x3be5e9[_0x7d9a('0x2a')][_0x7d9a('0x2f')]));_0x260c59[_0x7d9a('0x2e')]=_0x260c59['attributes'][_0x7d9a('0x30')]?_0x260c59[_0x7d9a('0x2e')]:_0x2e5941[_0x7d9a('0x29')];_0x260c59[_0x7d9a('0x32')]=qs[_0x7d9a('0x33')](_0x3be5e9[_0x7d9a('0x2a')][_0x7d9a('0x33')]);_0x260c59[_0x7d9a('0x34')]=qs[_0x7d9a('0x2c')](_[_0x7d9a('0x35')](_0x3be5e9[_0x7d9a('0x2a')],_0x2e5941[_0x7d9a('0x2c')]));if(_0x3be5e9['query'][_0x7d9a('0x36')]){_0x260c59['where']=_[_0x7d9a('0x37')](_0x260c59[_0x7d9a('0x34')],{'$or':_[_0x7d9a('0x28')](_0x260c59[_0x7d9a('0x2e')],function(_0x30353e){var _0x539fdd={};_0x539fdd[_0x30353e]={'$like':'%'+_0x3be5e9['query'][_0x7d9a('0x36')]+'%'};return _0x539fdd;})});}_0x260c59=_[_0x7d9a('0x37')]({},_0x260c59,_0x3be5e9[_0x7d9a('0x3a')]);return _0x1bc695['getFields'](_0x260c59);}})['then'](function(_0x55d774){if(_0x55d774){_0x58ff90=_0x55d774[_0x7d9a('0x30')];if(!_0x3be5e9[_0x7d9a('0x2a')]['hasOwnProperty']('nolimit')){_0x260c59[_0x7d9a('0x1c')]=qs[_0x7d9a('0x1c')](_0x3be5e9[_0x7d9a('0x2a')][_0x7d9a('0x1c')]);_0x260c59['offset']=qs[_0x7d9a('0x1b')](_0x3be5e9['query']['offset']);}return _0x1bc695['getFields'](_0x260c59);}})[_0x7d9a('0x22')](function(_0x19aaac){if(_0x19aaac){return _0x19aaac?{'count':_0x58ff90,'rows':_0x19aaac}:null;}})[_0x7d9a('0x22')](respondWithResult(_0x248c9d,null))['catch'](handleError(_0x248c9d,null));};exports['getSubjects']=function(_0x2f3607,_0x142e67,_0x575b79){var _0x10d0d4={};var _0x42b8b2={};var _0x2820e6;var _0x5ae0f8;return db[_0x7d9a('0x3b')][_0x7d9a('0x47')]({'where':{'id':_0x2f3607[_0x7d9a('0x41')]['id']}})[_0x7d9a('0x22')](handleEntityNotFound(_0x142e67,null))[_0x7d9a('0x22')](function(_0x361f8c){if(_0x361f8c){_0x2820e6=_0x361f8c;_0x42b8b2[_0x7d9a('0x29')]=_[_0x7d9a('0x2b')](db[_0x7d9a('0x48')]['rawAttributes']);_0x42b8b2[_0x7d9a('0x2a')]=_[_0x7d9a('0x2b')](_0x2f3607[_0x7d9a('0x2a')]);_0x42b8b2[_0x7d9a('0x2c')]=_[_0x7d9a('0x2d')](_0x42b8b2['model'],_0x42b8b2[_0x7d9a('0x2a')]);_0x10d0d4[_0x7d9a('0x2e')]=_[_0x7d9a('0x2d')](_0x42b8b2[_0x7d9a('0x29')],qs[_0x7d9a('0x2f')](_0x2f3607[_0x7d9a('0x2a')]['fields']));_0x10d0d4[_0x7d9a('0x2e')]=_0x10d0d4[_0x7d9a('0x2e')][_0x7d9a('0x30')]?_0x10d0d4[_0x7d9a('0x2e')]:_0x42b8b2['model'];_0x10d0d4[_0x7d9a('0x32')]=qs[_0x7d9a('0x33')](_0x2f3607[_0x7d9a('0x2a')][_0x7d9a('0x33')]);_0x10d0d4[_0x7d9a('0x34')]=qs[_0x7d9a('0x2c')](_['pick'](_0x2f3607['query'],_0x42b8b2[_0x7d9a('0x2c')]));if(_0x2f3607[_0x7d9a('0x2a')][_0x7d9a('0x36')]){_0x10d0d4[_0x7d9a('0x34')]=_[_0x7d9a('0x37')](_0x10d0d4[_0x7d9a('0x34')],{'$or':_[_0x7d9a('0x28')](_0x10d0d4[_0x7d9a('0x2e')],function(_0x24466a){var _0x112a34={};_0x112a34[_0x24466a]={'$like':'%'+_0x2f3607[_0x7d9a('0x2a')][_0x7d9a('0x36')]+'%'};return _0x112a34;})});}_0x10d0d4=_[_0x7d9a('0x37')]({},_0x10d0d4,_0x2f3607[_0x7d9a('0x3a')]);return _0x2820e6[_0x7d9a('0x49')](_0x10d0d4);}})[_0x7d9a('0x22')](function(_0x2b1f4e){if(_0x2b1f4e){_0x5ae0f8=_0x2b1f4e['length'];if(!_0x2f3607[_0x7d9a('0x2a')][_0x7d9a('0x4a')](_0x7d9a('0x31'))){_0x10d0d4[_0x7d9a('0x1c')]=qs[_0x7d9a('0x1c')](_0x2f3607[_0x7d9a('0x2a')]['limit']);_0x10d0d4[_0x7d9a('0x1b')]=qs[_0x7d9a('0x1b')](_0x2f3607[_0x7d9a('0x2a')][_0x7d9a('0x1b')]);}return _0x2820e6[_0x7d9a('0x49')](_0x10d0d4);}})[_0x7d9a('0x22')](function(_0x4672fe){if(_0x4672fe){return _0x4672fe?{'count':_0x5ae0f8,'rows':_0x4672fe}:null;}})[_0x7d9a('0x22')](respondWithResult(_0x142e67,null))[_0x7d9a('0x3f')](handleError(_0x142e67,null));};exports[_0x7d9a('0x4b')]=function(_0x75a4b7,_0x5ec716,_0x2adfd2){var _0x54691a={};var _0x1eb5fd={};var _0x1d6bad;var _0x2760b4;return db[_0x7d9a('0x3b')][_0x7d9a('0x47')]({'where':{'id':_0x75a4b7[_0x7d9a('0x41')]['id']}})[_0x7d9a('0x22')](handleEntityNotFound(_0x5ec716,null))[_0x7d9a('0x22')](function(_0xeee7cf){if(_0xeee7cf){_0x1d6bad=_0xeee7cf;_0x1eb5fd[_0x7d9a('0x29')]=_[_0x7d9a('0x2b')](db[_0x7d9a('0x48')][_0x7d9a('0x42')]);_0x1eb5fd[_0x7d9a('0x2a')]=_[_0x7d9a('0x2b')](_0x75a4b7[_0x7d9a('0x2a')]);_0x1eb5fd['filters']=_[_0x7d9a('0x2d')](_0x1eb5fd[_0x7d9a('0x29')],_0x1eb5fd[_0x7d9a('0x2a')]);_0x54691a[_0x7d9a('0x2e')]=_[_0x7d9a('0x2d')](_0x1eb5fd[_0x7d9a('0x29')],qs[_0x7d9a('0x2f')](_0x75a4b7[_0x7d9a('0x2a')][_0x7d9a('0x2f')]));_0x54691a[_0x7d9a('0x2e')]=_0x54691a[_0x7d9a('0x2e')]['length']?_0x54691a[_0x7d9a('0x2e')]:_0x1eb5fd['model'];_0x54691a[_0x7d9a('0x32')]=qs[_0x7d9a('0x33')](_0x75a4b7['query']['sort']);_0x54691a['where']=qs['filters'](_[_0x7d9a('0x35')](_0x75a4b7['query'],_0x1eb5fd[_0x7d9a('0x2c')]));if(_0x75a4b7['query']['filter']){_0x54691a['where']=_[_0x7d9a('0x37')](_0x54691a['where'],{'$or':_[_0x7d9a('0x28')](_0x54691a[_0x7d9a('0x2e')],function(_0x5b47c1){var _0x3a160f={};_0x3a160f[_0x5b47c1]={'$like':'%'+_0x75a4b7[_0x7d9a('0x2a')][_0x7d9a('0x36')]+'%'};return _0x3a160f;})});}_0x54691a=_[_0x7d9a('0x37')]({},_0x54691a,_0x75a4b7[_0x7d9a('0x3a')]);return _0x1d6bad['getDescriptions'](_0x54691a);}})[_0x7d9a('0x22')](function(_0x2d453b){if(_0x2d453b){_0x2760b4=_0x2d453b['length'];if(!_0x75a4b7['query'][_0x7d9a('0x4a')](_0x7d9a('0x31'))){_0x54691a[_0x7d9a('0x1c')]=qs[_0x7d9a('0x1c')](_0x75a4b7[_0x7d9a('0x2a')][_0x7d9a('0x1c')]);_0x54691a[_0x7d9a('0x1b')]=qs[_0x7d9a('0x1b')](_0x75a4b7[_0x7d9a('0x2a')][_0x7d9a('0x1b')]);}return _0x1d6bad['getDescriptions'](_0x54691a);}})[_0x7d9a('0x22')](function(_0x11bc13){if(_0x11bc13){return _0x11bc13?{'count':_0x2760b4,'rows':_0x11bc13}:null;}})[_0x7d9a('0x22')](respondWithResult(_0x5ec716,null))[_0x7d9a('0x3f')](handleError(_0x5ec716,null));};
\ No newline at end of file
+var _0x61d2=['../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','limit','undefined','count','offset','set','apply','reject','then','error','stack','name','send','index','rawAttributes','fieldName','key','model','map','query','intersection','fields','attributes','length','nolimit','sort','filters','pick','filter','where','merge','type','VIRTUAL','SugarcrmConfiguration','includeAll','include','findAll','rows','catch','show','params','keys','options','create','body','find','destroy','findOne','SugarcrmField','getFields','hasOwnProperty','order','getSubjects','getDescriptions','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','path','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware'];(function(_0x3ab51d,_0x2fa01d){var _0x29a04e=function(_0x7807b0){while(--_0x7807b0){_0x3ab51d['push'](_0x3ab51d['shift']());}};_0x29a04e(++_0x2fa01d);}(_0x61d2,0xde));var _0x261d=function(_0x468f9b,_0x5b7399){_0x468f9b=_0x468f9b-0x0;var _0x47c13e=_0x61d2[_0x468f9b];return _0x47c13e;};'use strict';var emlformat=require(_0x261d('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x261d('0x1'));var jsonpatch=require(_0x261d('0x2'));var rp=require('request-promise');var moment=require(_0x261d('0x3'));var BPromise=require(_0x261d('0x4'));var Mustache=require(_0x261d('0x5'));var util=require('util');var path=require(_0x261d('0x6'));var sox=require('sox');var csv=require(_0x261d('0x7'));var ejs=require(_0x261d('0x8'));var fs=require('fs');var fs_extra=require(_0x261d('0x9'));var _=require(_0x261d('0xa'));var squel=require('squel');var crypto=require(_0x261d('0xb'));var jsforce=require(_0x261d('0xc'));var deskjs=require(_0x261d('0xd'));var toCsv=require(_0x261d('0x7'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x261d('0xe'));var authService=require(_0x261d('0xf'));var qs=require(_0x261d('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x261d('0x11'));var logger=require(_0x261d('0x12'))(_0x261d('0x13'));var utils=require(_0x261d('0x14'));var config=require(_0x261d('0x15'));var licenseUtil=require(_0x261d('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2be62a,_0x1c0748){_0x1c0748=_0x1c0748||0xcc;return function(_0x30ad72){if(_0x30ad72){return _0x2be62a[_0x261d('0x17')](_0x1c0748);}return _0x2be62a[_0x261d('0x18')](_0x1c0748)[_0x261d('0x19')]();};}function respondWithResult(_0x4855ae,_0x2ac14d){_0x2ac14d=_0x2ac14d||0xc8;return function(_0x165b69){if(_0x165b69){return _0x4855ae[_0x261d('0x18')](_0x2ac14d)[_0x261d('0x1a')](_0x165b69);}};}function respondWithFilteredResult(_0x230c0c,_0x2483d9){return function(_0x275685){if(_0x275685){var _0x28f11e=typeof _0x2483d9['offset']==='undefined'&&typeof _0x2483d9[_0x261d('0x1b')]===_0x261d('0x1c');var _0x344c33=_0x275685[_0x261d('0x1d')];var _0xbef587=_0x28f11e?0x0:_0x2483d9[_0x261d('0x1e')];var _0x439f7f=_0x28f11e?_0x275685['count']:_0x2483d9[_0x261d('0x1e')]+_0x2483d9['limit'];var _0x2136c6;if(_0x439f7f>=_0x344c33){_0x439f7f=_0x344c33;_0x2136c6=0xc8;}else{_0x2136c6=0xce;}_0x230c0c['status'](_0x2136c6);return _0x230c0c[_0x261d('0x1f')]('Content-Range',_0xbef587+'-'+_0x439f7f+'/'+_0x344c33)['json'](_0x275685);}return null;};}function patchUpdates(_0x8c36d){return function(_0x2cd48e){try{jsonpatch[_0x261d('0x20')](_0x2cd48e,_0x8c36d,!![]);}catch(_0x545851){return BPromise[_0x261d('0x21')](_0x545851);}return _0x2cd48e['save']();};}function saveUpdates(_0x2880fc,_0x16b29f){return function(_0x1f671a){if(_0x1f671a){return _0x1f671a['update'](_0x2880fc)[_0x261d('0x22')](function(_0x58d907){return _0x58d907;});}return null;};}function removeEntity(_0x379e31,_0x40aec4){return function(_0xe1505){if(_0xe1505){return _0xe1505['destroy']()['then'](function(){_0x379e31[_0x261d('0x18')](0xcc)[_0x261d('0x19')]();});}};}function handleEntityNotFound(_0xcd269,_0x326f5e){return function(_0x4cfdbb){if(!_0x4cfdbb){_0xcd269[_0x261d('0x17')](0x194);}return _0x4cfdbb;};}function handleError(_0x5041bf,_0xe1c2bd){_0xe1c2bd=_0xe1c2bd||0x1f4;return function(_0x40f52e){logger[_0x261d('0x23')](_0x40f52e[_0x261d('0x24')]);if(_0x40f52e[_0x261d('0x25')]){delete _0x40f52e['name'];}_0x5041bf[_0x261d('0x18')](_0xe1c2bd)[_0x261d('0x26')](_0x40f52e);};}exports[_0x261d('0x27')]=function(_0x40e35b,_0x2f3428){var _0x9bcc92={},_0x2c597d={},_0x5424cf={'count':0x0,'rows':[]};var _0x3d560e=_['map'](db['SugarcrmConfiguration'][_0x261d('0x28')],function(_0x119e6a){return{'name':_0x119e6a[_0x261d('0x29')],'type':_0x119e6a['type'][_0x261d('0x2a')]};});_0x2c597d[_0x261d('0x2b')]=_[_0x261d('0x2c')](_0x3d560e,_0x261d('0x25'));_0x2c597d[_0x261d('0x2d')]=_['keys'](_0x40e35b[_0x261d('0x2d')]);_0x2c597d['filters']=_[_0x261d('0x2e')](_0x2c597d[_0x261d('0x2b')],_0x2c597d[_0x261d('0x2d')]);_0x9bcc92['attributes']=_['intersection'](_0x2c597d[_0x261d('0x2b')],qs[_0x261d('0x2f')](_0x40e35b[_0x261d('0x2d')]['fields']));_0x9bcc92[_0x261d('0x30')]=_0x9bcc92[_0x261d('0x30')][_0x261d('0x31')]?_0x9bcc92[_0x261d('0x30')]:_0x2c597d[_0x261d('0x2b')];if(!_0x40e35b[_0x261d('0x2d')]['hasOwnProperty'](_0x261d('0x32'))){_0x9bcc92['limit']=qs[_0x261d('0x1b')](_0x40e35b[_0x261d('0x2d')][_0x261d('0x1b')]);_0x9bcc92[_0x261d('0x1e')]=qs[_0x261d('0x1e')](_0x40e35b[_0x261d('0x2d')][_0x261d('0x1e')]);}_0x9bcc92['order']=qs[_0x261d('0x33')](_0x40e35b[_0x261d('0x2d')][_0x261d('0x33')]);_0x9bcc92['where']=qs[_0x261d('0x34')](_[_0x261d('0x35')](_0x40e35b[_0x261d('0x2d')],_0x2c597d['filters']),_0x3d560e);if(_0x40e35b[_0x261d('0x2d')][_0x261d('0x36')]){_0x9bcc92[_0x261d('0x37')]=_[_0x261d('0x38')](_0x9bcc92['where'],{'$or':_['map'](_0x3d560e,function(_0x15e510){if(_0x15e510[_0x261d('0x39')]!==_0x261d('0x3a')){var _0x2666b9={};_0x2666b9[_0x15e510[_0x261d('0x25')]]={'$like':'%'+_0x40e35b[_0x261d('0x2d')][_0x261d('0x36')]+'%'};return _0x2666b9;}})});}_0x9bcc92=_[_0x261d('0x38')]({},_0x9bcc92,_0x40e35b['options']);var _0x3fa1d8={'where':_0x9bcc92['where']};return db[_0x261d('0x3b')][_0x261d('0x1d')](_0x3fa1d8)[_0x261d('0x22')](function(_0x15f39c){_0x5424cf[_0x261d('0x1d')]=_0x15f39c;if(_0x40e35b[_0x261d('0x2d')][_0x261d('0x3c')]){_0x9bcc92[_0x261d('0x3d')]=[{'all':!![]}];}return db[_0x261d('0x3b')][_0x261d('0x3e')](_0x9bcc92);})[_0x261d('0x22')](function(_0x1881ec){_0x5424cf[_0x261d('0x3f')]=_0x1881ec;return _0x5424cf;})[_0x261d('0x22')](respondWithFilteredResult(_0x2f3428,_0x9bcc92))[_0x261d('0x40')](handleError(_0x2f3428,null));};exports[_0x261d('0x41')]=function(_0xd0fd5e,_0xeadf7a){var _0xe13898={'raw':![],'where':{'id':_0xd0fd5e[_0x261d('0x42')]['id']}},_0x15e67b={};_0x15e67b[_0x261d('0x2b')]=_[_0x261d('0x43')](db['SugarcrmConfiguration'][_0x261d('0x28')]);_0x15e67b[_0x261d('0x2d')]=_[_0x261d('0x43')](_0xd0fd5e[_0x261d('0x2d')]);_0x15e67b[_0x261d('0x34')]=_[_0x261d('0x2e')](_0x15e67b[_0x261d('0x2b')],_0x15e67b[_0x261d('0x2d')]);_0xe13898[_0x261d('0x30')]=_[_0x261d('0x2e')](_0x15e67b[_0x261d('0x2b')],qs['fields'](_0xd0fd5e['query']['fields']));_0xe13898[_0x261d('0x30')]=_0xe13898['attributes'][_0x261d('0x31')]?_0xe13898[_0x261d('0x30')]:_0x15e67b[_0x261d('0x2b')];if(_0xd0fd5e['query'][_0x261d('0x3c')]){_0xe13898[_0x261d('0x3d')]=[{'all':!![]}];}_0xe13898=_[_0x261d('0x38')]({},_0xe13898,_0xd0fd5e[_0x261d('0x44')]);return db[_0x261d('0x3b')]['find'](_0xe13898)[_0x261d('0x22')](handleEntityNotFound(_0xeadf7a,null))['then'](respondWithResult(_0xeadf7a,null))[_0x261d('0x40')](handleError(_0xeadf7a,null));};exports[_0x261d('0x45')]=function(_0x13039f,_0x339958){return db[_0x261d('0x3b')][_0x261d('0x45')](_0x13039f[_0x261d('0x46')],{})[_0x261d('0x22')](respondWithResult(_0x339958,0xc9))[_0x261d('0x40')](handleError(_0x339958,null));};exports['update']=function(_0x5b3127,_0x3a4292){if(_0x5b3127[_0x261d('0x46')]['id']){delete _0x5b3127[_0x261d('0x46')]['id'];}return db[_0x261d('0x3b')][_0x261d('0x47')]({'where':{'id':_0x5b3127[_0x261d('0x42')]['id']}})['then'](handleEntityNotFound(_0x3a4292,null))['then'](saveUpdates(_0x5b3127[_0x261d('0x46')],null))[_0x261d('0x22')](respondWithResult(_0x3a4292,null))[_0x261d('0x40')](handleError(_0x3a4292,null));};exports[_0x261d('0x48')]=function(_0x4624c4,_0x3fc297){return db[_0x261d('0x3b')]['find']({'where':{'id':_0x4624c4[_0x261d('0x42')]['id']}})[_0x261d('0x22')](handleEntityNotFound(_0x3fc297,null))[_0x261d('0x22')](removeEntity(_0x3fc297,null))[_0x261d('0x40')](handleError(_0x3fc297,null));};exports['getFields']=function(_0x414988,_0x3d5fbf,_0x1a6b87){var _0x3e4783={};var _0x1d00d9={};var _0x59a55f;var _0x9fe53d;return db[_0x261d('0x3b')][_0x261d('0x49')]({'where':{'id':_0x414988[_0x261d('0x42')]['id']}})['then'](handleEntityNotFound(_0x3d5fbf,null))[_0x261d('0x22')](function(_0x47267b){if(_0x47267b){_0x59a55f=_0x47267b;_0x1d00d9[_0x261d('0x2b')]=_[_0x261d('0x43')](db[_0x261d('0x4a')][_0x261d('0x28')]);_0x1d00d9['query']=_[_0x261d('0x43')](_0x414988['query']);_0x1d00d9[_0x261d('0x34')]=_[_0x261d('0x2e')](_0x1d00d9[_0x261d('0x2b')],_0x1d00d9[_0x261d('0x2d')]);_0x3e4783[_0x261d('0x30')]=_[_0x261d('0x2e')](_0x1d00d9[_0x261d('0x2b')],qs[_0x261d('0x2f')](_0x414988[_0x261d('0x2d')]['fields']));_0x3e4783[_0x261d('0x30')]=_0x3e4783[_0x261d('0x30')][_0x261d('0x31')]?_0x3e4783[_0x261d('0x30')]:_0x1d00d9['model'];_0x3e4783['order']=qs[_0x261d('0x33')](_0x414988['query'][_0x261d('0x33')]);_0x3e4783['where']=qs[_0x261d('0x34')](_[_0x261d('0x35')](_0x414988[_0x261d('0x2d')],_0x1d00d9[_0x261d('0x34')]));if(_0x414988[_0x261d('0x2d')][_0x261d('0x36')]){_0x3e4783['where']=_[_0x261d('0x38')](_0x3e4783[_0x261d('0x37')],{'$or':_[_0x261d('0x2c')](_0x3e4783[_0x261d('0x30')],function(_0x4c1047){var _0x2ff6bc={};_0x2ff6bc[_0x4c1047]={'$like':'%'+_0x414988[_0x261d('0x2d')][_0x261d('0x36')]+'%'};return _0x2ff6bc;})});}_0x3e4783=_[_0x261d('0x38')]({},_0x3e4783,_0x414988[_0x261d('0x44')]);return _0x59a55f[_0x261d('0x4b')](_0x3e4783);}})[_0x261d('0x22')](function(_0x1c1da8){if(_0x1c1da8){_0x9fe53d=_0x1c1da8[_0x261d('0x31')];if(!_0x414988[_0x261d('0x2d')][_0x261d('0x4c')]('nolimit')){_0x3e4783[_0x261d('0x1b')]=qs[_0x261d('0x1b')](_0x414988[_0x261d('0x2d')][_0x261d('0x1b')]);_0x3e4783[_0x261d('0x1e')]=qs[_0x261d('0x1e')](_0x414988[_0x261d('0x2d')][_0x261d('0x1e')]);}return _0x59a55f[_0x261d('0x4b')](_0x3e4783);}})[_0x261d('0x22')](function(_0xa3e06a){if(_0xa3e06a){return _0xa3e06a?{'count':_0x9fe53d,'rows':_0xa3e06a}:null;}})[_0x261d('0x22')](respondWithResult(_0x3d5fbf,null))[_0x261d('0x40')](handleError(_0x3d5fbf,null));};exports['getSubjects']=function(_0x4a8326,_0x126d03,_0x87b5ea){var _0x42af78={};var _0x1e2cca={};var _0x5e9c1c;var _0x1d73ef;return db[_0x261d('0x3b')][_0x261d('0x49')]({'where':{'id':_0x4a8326[_0x261d('0x42')]['id']}})['then'](handleEntityNotFound(_0x126d03,null))[_0x261d('0x22')](function(_0xddb9d){if(_0xddb9d){_0x5e9c1c=_0xddb9d;_0x1e2cca[_0x261d('0x2b')]=_[_0x261d('0x43')](db[_0x261d('0x4a')][_0x261d('0x28')]);_0x1e2cca[_0x261d('0x2d')]=_[_0x261d('0x43')](_0x4a8326[_0x261d('0x2d')]);_0x1e2cca['filters']=_[_0x261d('0x2e')](_0x1e2cca[_0x261d('0x2b')],_0x1e2cca['query']);_0x42af78[_0x261d('0x30')]=_[_0x261d('0x2e')](_0x1e2cca['model'],qs[_0x261d('0x2f')](_0x4a8326['query'][_0x261d('0x2f')]));_0x42af78['attributes']=_0x42af78[_0x261d('0x30')][_0x261d('0x31')]?_0x42af78['attributes']:_0x1e2cca[_0x261d('0x2b')];_0x42af78[_0x261d('0x4d')]=qs['sort'](_0x4a8326[_0x261d('0x2d')][_0x261d('0x33')]);_0x42af78[_0x261d('0x37')]=qs[_0x261d('0x34')](_[_0x261d('0x35')](_0x4a8326[_0x261d('0x2d')],_0x1e2cca['filters']));if(_0x4a8326[_0x261d('0x2d')][_0x261d('0x36')]){_0x42af78['where']=_[_0x261d('0x38')](_0x42af78[_0x261d('0x37')],{'$or':_['map'](_0x42af78['attributes'],function(_0x2731cd){var _0x5acda5={};_0x5acda5[_0x2731cd]={'$like':'%'+_0x4a8326[_0x261d('0x2d')][_0x261d('0x36')]+'%'};return _0x5acda5;})});}_0x42af78=_[_0x261d('0x38')]({},_0x42af78,_0x4a8326['options']);return _0x5e9c1c[_0x261d('0x4e')](_0x42af78);}})[_0x261d('0x22')](function(_0x5792a9){if(_0x5792a9){_0x1d73ef=_0x5792a9['length'];if(!_0x4a8326[_0x261d('0x2d')][_0x261d('0x4c')](_0x261d('0x32'))){_0x42af78[_0x261d('0x1b')]=qs[_0x261d('0x1b')](_0x4a8326[_0x261d('0x2d')][_0x261d('0x1b')]);_0x42af78['offset']=qs['offset'](_0x4a8326[_0x261d('0x2d')][_0x261d('0x1e')]);}return _0x5e9c1c[_0x261d('0x4e')](_0x42af78);}})[_0x261d('0x22')](function(_0x3d77fd){if(_0x3d77fd){return _0x3d77fd?{'count':_0x1d73ef,'rows':_0x3d77fd}:null;}})['then'](respondWithResult(_0x126d03,null))[_0x261d('0x40')](handleError(_0x126d03,null));};exports[_0x261d('0x4f')]=function(_0x285bbc,_0x58da23,_0x134f4a){var _0x18a7b7={};var _0x2b699e={};var _0x195e29;var _0x2ca0f9;return db[_0x261d('0x3b')][_0x261d('0x49')]({'where':{'id':_0x285bbc[_0x261d('0x42')]['id']}})[_0x261d('0x22')](handleEntityNotFound(_0x58da23,null))[_0x261d('0x22')](function(_0x1c955f){if(_0x1c955f){_0x195e29=_0x1c955f;_0x2b699e[_0x261d('0x2b')]=_[_0x261d('0x43')](db['SugarcrmField'][_0x261d('0x28')]);_0x2b699e['query']=_[_0x261d('0x43')](_0x285bbc[_0x261d('0x2d')]);_0x2b699e['filters']=_[_0x261d('0x2e')](_0x2b699e[_0x261d('0x2b')],_0x2b699e[_0x261d('0x2d')]);_0x18a7b7['attributes']=_[_0x261d('0x2e')](_0x2b699e[_0x261d('0x2b')],qs[_0x261d('0x2f')](_0x285bbc['query'][_0x261d('0x2f')]));_0x18a7b7['attributes']=_0x18a7b7['attributes']['length']?_0x18a7b7[_0x261d('0x30')]:_0x2b699e[_0x261d('0x2b')];_0x18a7b7['order']=qs['sort'](_0x285bbc[_0x261d('0x2d')][_0x261d('0x33')]);_0x18a7b7[_0x261d('0x37')]=qs['filters'](_[_0x261d('0x35')](_0x285bbc[_0x261d('0x2d')],_0x2b699e['filters']));if(_0x285bbc['query'][_0x261d('0x36')]){_0x18a7b7[_0x261d('0x37')]=_[_0x261d('0x38')](_0x18a7b7[_0x261d('0x37')],{'$or':_['map'](_0x18a7b7['attributes'],function(_0x88a4d4){var _0x40f817={};_0x40f817[_0x88a4d4]={'$like':'%'+_0x285bbc[_0x261d('0x2d')][_0x261d('0x36')]+'%'};return _0x40f817;})});}_0x18a7b7=_[_0x261d('0x38')]({},_0x18a7b7,_0x285bbc[_0x261d('0x44')]);return _0x195e29['getDescriptions'](_0x18a7b7);}})[_0x261d('0x22')](function(_0x5d318d){if(_0x5d318d){_0x2ca0f9=_0x5d318d[_0x261d('0x31')];if(!_0x285bbc['query'][_0x261d('0x4c')](_0x261d('0x32'))){_0x18a7b7['limit']=qs[_0x261d('0x1b')](_0x285bbc['query'][_0x261d('0x1b')]);_0x18a7b7['offset']=qs[_0x261d('0x1e')](_0x285bbc[_0x261d('0x2d')][_0x261d('0x1e')]);}return _0x195e29[_0x261d('0x4f')](_0x18a7b7);}})[_0x261d('0x22')](function(_0x74967c){if(_0x74967c){return _0x74967c?{'count':_0x2ca0f9,'rows':_0x74967c}:null;}})[_0x261d('0x22')](respondWithResult(_0x58da23,null))[_0x261d('0x40')](handleError(_0x58da23,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff