// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xa8c1=['sort','filter','where','merge','includeAll','include','findAll','rows','show','params','find','create','update','body','findOne','SugarcrmField','pick','options','getFields','nolimit','getSubjects','getDescriptions','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','jayson/promise','request','then','request\x20sent','SugarcrmConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','SugarcrmConfiguration,\x20%s,\x20%s','message','info','result','catch','sendStatus','status','end','json','count','offset','limit','set','apply','save','destroy','name','send','index','map','SugarcrmConfiguration','rawAttributes','fieldName','type','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','order'];(function(_0x4d7116,_0xdb8175){var _0x4593dc=function(_0x51d44e){while(--_0x51d44e){_0x4d7116['push'](_0x4d7116['shift']());}};_0x4593dc(++_0xdb8175);}(_0xa8c1,0x172));var _0x1a8c=function(_0x1c470d,_0x81d66b){_0x1c470d=_0x1c470d-0x0;var _0x12141b=_0xa8c1[_0x1c470d];return _0x12141b;};'use strict';var pdf=require(_0x1a8c('0x0'));var emlformat=require(_0x1a8c('0x1'));var rimraf=require(_0x1a8c('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x1a8c('0x3'));var rp=require(_0x1a8c('0x4'));var moment=require(_0x1a8c('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x1a8c('0x6'));var util=require(_0x1a8c('0x7'));var path=require(_0x1a8c('0x8'));var sox=require(_0x1a8c('0x9'));var csv=require(_0x1a8c('0xa'));var ejs=require(_0x1a8c('0xb'));var fs=require('fs');var _=require(_0x1a8c('0xc'));var squel=require(_0x1a8c('0xd'));var crypto=require(_0x1a8c('0xe'));var jsforce=require(_0x1a8c('0xf'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x1a8c('0x10'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x1a8c('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x1a8c('0x12'));var hardwareService=require(_0x1a8c('0x13'));var logger=require('../../config/logger')(_0x1a8c('0x14'));var utils=require(_0x1a8c('0x15'));var config=require(_0x1a8c('0x16'));var licenseUtil=require(_0x1a8c('0x17'));var db=require('../../mysqldb')['db'];var jayson=require(_0x1a8c('0x18'));var client=jayson['client']['http']({'port':0x232a});function respondWithRpcPromise(_0x2a412a,_0x335eb6,_0x1bb0bf,_0x44e0d2){return new BPromise(function(_0x28fc55,_0x267f5e){var _0x38a7a5=_0x44e0d2||client;return _0x38a7a5[_0x1a8c('0x19')](_0x2a412a,_0x1bb0bf)[_0x1a8c('0x1a')](function(_0x550443){logger['info']('SugarcrmConfiguration,\x20%s,\x20%s',_0x335eb6,_0x1a8c('0x1b'));logger['debug'](_0x1a8c('0x1c'),_0x335eb6,_0x1a8c('0x1b'),JSON[_0x1a8c('0x1d')](_0x550443));if(_0x550443['error']){if(_0x550443[_0x1a8c('0x1e')]['code']===0x1f4){logger[_0x1a8c('0x1e')](_0x1a8c('0x1f'),_0x335eb6,_0x550443['error'][_0x1a8c('0x20')]);return _0x267f5e(_0x550443[_0x1a8c('0x1e')][_0x1a8c('0x20')]);}logger[_0x1a8c('0x1e')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x335eb6,_0x550443['error'][_0x1a8c('0x20')]);return _0x28fc55(_0x550443['error'][_0x1a8c('0x20')]);}else{logger[_0x1a8c('0x21')](_0x1a8c('0x1f'),_0x335eb6,_0x1a8c('0x1b'));_0x28fc55(_0x550443[_0x1a8c('0x22')][_0x1a8c('0x20')]);}})[_0x1a8c('0x23')](function(_0x20df98){logger[_0x1a8c('0x1e')](_0x1a8c('0x1f'),_0x335eb6,_0x20df98);_0x267f5e(_0x20df98);});});}function respondWithStatusCode(_0x17411f,_0x170d95){_0x170d95=_0x170d95||0xcc;return function(_0x31532c){if(_0x31532c){return _0x17411f[_0x1a8c('0x24')](_0x170d95);}return _0x17411f[_0x1a8c('0x25')](_0x170d95)[_0x1a8c('0x26')]();};}function respondWithResult(_0x15ef1b,_0x383938){_0x383938=_0x383938||0xc8;return function(_0x355480){if(_0x355480){return _0x15ef1b[_0x1a8c('0x25')](_0x383938)[_0x1a8c('0x27')](_0x355480);}};}function respondWithFilteredResult(_0x42c890,_0x2844e2){return function(_0x5ede29){if(_0x5ede29){var _0x3d896c=_0x5ede29[_0x1a8c('0x28')],_0x25ed90=_0x2844e2[_0x1a8c('0x29')],_0x7a2f1e=_0x2844e2[_0x1a8c('0x29')]+_0x2844e2[_0x1a8c('0x2a')],_0x127808;if(_0x7a2f1e>=_0x3d896c){_0x7a2f1e=_0x3d896c;_0x127808=0xc8;}else{_0x127808=0xce;}_0x42c890[_0x1a8c('0x25')](_0x127808);return _0x42c890[_0x1a8c('0x2b')]('Content-Range',_0x25ed90+'-'+_0x7a2f1e+'/'+_0x3d896c)[_0x1a8c('0x27')](_0x5ede29);}return null;};}function patchUpdates(_0x175790){return function(_0x563f99){try{jsonpatch[_0x1a8c('0x2c')](_0x563f99,_0x175790,!![]);}catch(_0x434cec){return BPromise['reject'](_0x434cec);}return _0x563f99[_0x1a8c('0x2d')]();};}function saveUpdates(_0x2862a1,_0x415242){return function(_0x2a16dc){if(_0x2a16dc){return _0x2a16dc['update'](_0x2862a1)[_0x1a8c('0x1a')](function(_0x16e770){return _0x16e770;});}return null;};}function removeEntity(_0x149190,_0x1cd6c2){return function(_0x5868c2){if(_0x5868c2){return _0x5868c2[_0x1a8c('0x2e')]()[_0x1a8c('0x1a')](function(){_0x149190[_0x1a8c('0x25')](0xcc)[_0x1a8c('0x26')]();});}};}function handleEntityNotFound(_0x15ad47,_0xf10f58){return function(_0x219af6){if(!_0x219af6){_0x15ad47[_0x1a8c('0x24')](0x194);}return _0x219af6;};}function handleError(_0x28f9e2,_0x4ca06f){_0x4ca06f=_0x4ca06f||0x1f4;return function(_0x177637){logger[_0x1a8c('0x1e')](_0x177637['stack']);if(_0x177637[_0x1a8c('0x2f')]){delete _0x177637[_0x1a8c('0x2f')];}_0x28f9e2['status'](_0x4ca06f)[_0x1a8c('0x30')](_0x177637);};}exports[_0x1a8c('0x31')]=function(_0x48c8eb,_0x407216){var _0x3a444a={},_0x4a556c={},_0x3b1ec1={'count':0x0,'rows':[]};var _0x86e397=_[_0x1a8c('0x32')](db[_0x1a8c('0x33')][_0x1a8c('0x34')],function(_0x391694){return{'name':_0x391694[_0x1a8c('0x35')],'type':_0x391694[_0x1a8c('0x36')]['key']};});_0x4a556c['model']=_[_0x1a8c('0x32')](_0x86e397,'name');_0x4a556c[_0x1a8c('0x37')]=_[_0x1a8c('0x38')](_0x48c8eb[_0x1a8c('0x37')]);_0x4a556c[_0x1a8c('0x39')]=_[_0x1a8c('0x3a')](_0x4a556c[_0x1a8c('0x3b')],_0x4a556c[_0x1a8c('0x37')]);_0x3a444a[_0x1a8c('0x3c')]=_[_0x1a8c('0x3a')](_0x4a556c[_0x1a8c('0x3b')],qs[_0x1a8c('0x3d')](_0x48c8eb[_0x1a8c('0x37')][_0x1a8c('0x3d')]));_0x3a444a[_0x1a8c('0x3c')]=_0x3a444a[_0x1a8c('0x3c')][_0x1a8c('0x3e')]?_0x3a444a[_0x1a8c('0x3c')]:_0x4a556c[_0x1a8c('0x3b')];if(!_0x48c8eb[_0x1a8c('0x37')][_0x1a8c('0x3f')]('nolimit')){_0x3a444a['limit']=qs[_0x1a8c('0x2a')](_0x48c8eb[_0x1a8c('0x37')][_0x1a8c('0x2a')]);_0x3a444a[_0x1a8c('0x29')]=qs[_0x1a8c('0x29')](_0x48c8eb[_0x1a8c('0x37')][_0x1a8c('0x29')]);}_0x3a444a[_0x1a8c('0x40')]=qs[_0x1a8c('0x41')](_0x48c8eb['query'][_0x1a8c('0x41')]);_0x3a444a['where']=qs[_0x1a8c('0x39')](_['pick'](_0x48c8eb[_0x1a8c('0x37')],_0x4a556c[_0x1a8c('0x39')]),_0x86e397);if(_0x48c8eb[_0x1a8c('0x37')][_0x1a8c('0x42')]){_0x3a444a[_0x1a8c('0x43')]=_[_0x1a8c('0x44')](_0x3a444a[_0x1a8c('0x43')],{'$or':_[_0x1a8c('0x32')](_0x86e397,function(_0x39e11d){if(_0x39e11d[_0x1a8c('0x36')]!=='VIRTUAL'){var _0x2cda03={};_0x2cda03[_0x39e11d[_0x1a8c('0x2f')]]={'$like':'%'+_0x48c8eb[_0x1a8c('0x37')][_0x1a8c('0x42')]+'%'};return _0x2cda03;}})});}_0x3a444a=_[_0x1a8c('0x44')]({},_0x3a444a,_0x48c8eb['options']);var _0x117305={'where':_0x3a444a[_0x1a8c('0x43')]};return db[_0x1a8c('0x33')][_0x1a8c('0x28')](_0x117305)[_0x1a8c('0x1a')](function(_0x3ba2ca){_0x3b1ec1[_0x1a8c('0x28')]=_0x3ba2ca;if(_0x48c8eb[_0x1a8c('0x37')][_0x1a8c('0x45')]){_0x3a444a[_0x1a8c('0x46')]=[{'all':!![]}];}return db['SugarcrmConfiguration'][_0x1a8c('0x47')](_0x3a444a);})[_0x1a8c('0x1a')](function(_0x2b8ab4){_0x3b1ec1[_0x1a8c('0x48')]=_0x2b8ab4;return _0x3b1ec1;})[_0x1a8c('0x1a')](respondWithFilteredResult(_0x407216,_0x3a444a))[_0x1a8c('0x23')](handleError(_0x407216,null));};exports[_0x1a8c('0x49')]=function(_0x2b3cf4,_0x3e18e9){var _0x460730={'raw':![],'where':{'id':_0x2b3cf4[_0x1a8c('0x4a')]['id']}},_0x218719={};_0x218719['model']=_[_0x1a8c('0x38')](db[_0x1a8c('0x33')][_0x1a8c('0x34')]);_0x218719[_0x1a8c('0x37')]=_[_0x1a8c('0x38')](_0x2b3cf4['query']);_0x218719['filters']=_[_0x1a8c('0x3a')](_0x218719[_0x1a8c('0x3b')],_0x218719[_0x1a8c('0x37')]);_0x460730[_0x1a8c('0x3c')]=_['intersection'](_0x218719[_0x1a8c('0x3b')],qs[_0x1a8c('0x3d')](_0x2b3cf4[_0x1a8c('0x37')][_0x1a8c('0x3d')]));_0x460730[_0x1a8c('0x3c')]=_0x460730[_0x1a8c('0x3c')][_0x1a8c('0x3e')]?_0x460730['attributes']:_0x218719['model'];if(_0x2b3cf4[_0x1a8c('0x37')]['includeAll']){_0x460730[_0x1a8c('0x46')]=[{'all':!![]}];}_0x460730=_[_0x1a8c('0x44')]({},_0x460730,_0x2b3cf4['options']);return db[_0x1a8c('0x33')][_0x1a8c('0x4b')](_0x460730)[_0x1a8c('0x1a')](handleEntityNotFound(_0x3e18e9,null))['then'](respondWithResult(_0x3e18e9,null))[_0x1a8c('0x23')](handleError(_0x3e18e9,null));};exports[_0x1a8c('0x4c')]=function(_0x3e8585,_0x2249fb){return db['SugarcrmConfiguration'][_0x1a8c('0x4c')](_0x3e8585['body'],{})['then'](respondWithResult(_0x2249fb,0xc9))[_0x1a8c('0x23')](handleError(_0x2249fb,null));};exports[_0x1a8c('0x4d')]=function(_0x45855f,_0x3e3518){if(_0x45855f[_0x1a8c('0x4e')]['id']){delete _0x45855f['body']['id'];}return db[_0x1a8c('0x33')][_0x1a8c('0x4b')]({'where':{'id':_0x45855f['params']['id']}})[_0x1a8c('0x1a')](handleEntityNotFound(_0x3e3518,null))[_0x1a8c('0x1a')](saveUpdates(_0x45855f[_0x1a8c('0x4e')],null))[_0x1a8c('0x1a')](respondWithResult(_0x3e3518,null))['catch'](handleError(_0x3e3518,null));};exports[_0x1a8c('0x2e')]=function(_0x247705,_0x6c2ba1){return db[_0x1a8c('0x33')][_0x1a8c('0x4b')]({'where':{'id':_0x247705[_0x1a8c('0x4a')]['id']}})[_0x1a8c('0x1a')](handleEntityNotFound(_0x6c2ba1,null))[_0x1a8c('0x1a')](removeEntity(_0x6c2ba1,null))[_0x1a8c('0x23')](handleError(_0x6c2ba1,null));};exports['getFields']=function(_0x2ffdae,_0x3476f0,_0x5f1f89){var _0x36a3b5={};var _0x30baa8={};var _0x2e950a;var _0x314f2a;return db[_0x1a8c('0x33')][_0x1a8c('0x4f')]({'where':{'id':_0x2ffdae[_0x1a8c('0x4a')]['id']}})[_0x1a8c('0x1a')](handleEntityNotFound(_0x3476f0,null))[_0x1a8c('0x1a')](function(_0x184ad9){if(_0x184ad9){_0x2e950a=_0x184ad9;_0x30baa8['model']=_[_0x1a8c('0x38')](db[_0x1a8c('0x50')]['rawAttributes']);_0x30baa8[_0x1a8c('0x37')]=_[_0x1a8c('0x38')](_0x2ffdae[_0x1a8c('0x37')]);_0x30baa8[_0x1a8c('0x39')]=_[_0x1a8c('0x3a')](_0x30baa8[_0x1a8c('0x3b')],_0x30baa8[_0x1a8c('0x37')]);_0x36a3b5[_0x1a8c('0x3c')]=_[_0x1a8c('0x3a')](_0x30baa8['model'],qs[_0x1a8c('0x3d')](_0x2ffdae[_0x1a8c('0x37')][_0x1a8c('0x3d')]));_0x36a3b5['attributes']=_0x36a3b5['attributes'][_0x1a8c('0x3e')]?_0x36a3b5[_0x1a8c('0x3c')]:_0x30baa8[_0x1a8c('0x3b')];_0x36a3b5[_0x1a8c('0x40')]=qs['sort'](_0x2ffdae[_0x1a8c('0x37')][_0x1a8c('0x41')]);_0x36a3b5[_0x1a8c('0x43')]=qs['filters'](_[_0x1a8c('0x51')](_0x2ffdae[_0x1a8c('0x37')],_0x30baa8[_0x1a8c('0x39')]));if(_0x2ffdae[_0x1a8c('0x37')][_0x1a8c('0x42')]){_0x36a3b5[_0x1a8c('0x43')]=_[_0x1a8c('0x44')](_0x36a3b5[_0x1a8c('0x43')],{'$or':_[_0x1a8c('0x32')](_0x36a3b5[_0x1a8c('0x3c')],function(_0x1186c5){var _0x45ba91={};_0x45ba91[_0x1186c5]={'$like':'%'+_0x2ffdae['query'][_0x1a8c('0x42')]+'%'};return _0x45ba91;})});}_0x36a3b5=_[_0x1a8c('0x44')]({},_0x36a3b5,_0x2ffdae[_0x1a8c('0x52')]);return _0x2e950a[_0x1a8c('0x53')](_0x36a3b5);}})[_0x1a8c('0x1a')](function(_0x9f9d8f){if(_0x9f9d8f){_0x314f2a=_0x9f9d8f[_0x1a8c('0x3e')];if(!_0x2ffdae[_0x1a8c('0x37')][_0x1a8c('0x3f')](_0x1a8c('0x54'))){_0x36a3b5[_0x1a8c('0x2a')]=qs[_0x1a8c('0x2a')](_0x2ffdae[_0x1a8c('0x37')][_0x1a8c('0x2a')]);_0x36a3b5['offset']=qs['offset'](_0x2ffdae['query']['offset']);}return _0x2e950a[_0x1a8c('0x53')](_0x36a3b5);}})[_0x1a8c('0x1a')](function(_0x5c69a4){if(_0x5c69a4){return _0x5c69a4?{'count':_0x314f2a,'rows':_0x5c69a4}:null;}})[_0x1a8c('0x1a')](respondWithResult(_0x3476f0,null))[_0x1a8c('0x23')](handleError(_0x3476f0,null));};exports['getSubjects']=function(_0x1df5d6,_0x4e9d47,_0x3dbf25){var _0x523bb1={};var _0x70b8d={};var _0x26ee68;var _0x375adf;return db[_0x1a8c('0x33')][_0x1a8c('0x4f')]({'where':{'id':_0x1df5d6[_0x1a8c('0x4a')]['id']}})[_0x1a8c('0x1a')](handleEntityNotFound(_0x4e9d47,null))[_0x1a8c('0x1a')](function(_0x29d086){if(_0x29d086){_0x26ee68=_0x29d086;_0x70b8d['model']=_[_0x1a8c('0x38')](db[_0x1a8c('0x50')][_0x1a8c('0x34')]);_0x70b8d[_0x1a8c('0x37')]=_['keys'](_0x1df5d6[_0x1a8c('0x37')]);_0x70b8d['filters']=_[_0x1a8c('0x3a')](_0x70b8d['model'],_0x70b8d[_0x1a8c('0x37')]);_0x523bb1['attributes']=_[_0x1a8c('0x3a')](_0x70b8d[_0x1a8c('0x3b')],qs[_0x1a8c('0x3d')](_0x1df5d6['query'][_0x1a8c('0x3d')]));_0x523bb1[_0x1a8c('0x3c')]=_0x523bb1[_0x1a8c('0x3c')][_0x1a8c('0x3e')]?_0x523bb1[_0x1a8c('0x3c')]:_0x70b8d['model'];_0x523bb1[_0x1a8c('0x40')]=qs[_0x1a8c('0x41')](_0x1df5d6[_0x1a8c('0x37')][_0x1a8c('0x41')]);_0x523bb1[_0x1a8c('0x43')]=qs[_0x1a8c('0x39')](_[_0x1a8c('0x51')](_0x1df5d6[_0x1a8c('0x37')],_0x70b8d[_0x1a8c('0x39')]));if(_0x1df5d6[_0x1a8c('0x37')]['filter']){_0x523bb1[_0x1a8c('0x43')]=_['merge'](_0x523bb1[_0x1a8c('0x43')],{'$or':_[_0x1a8c('0x32')](_0x523bb1[_0x1a8c('0x3c')],function(_0x106154){var _0x55dd00={};_0x55dd00[_0x106154]={'$like':'%'+_0x1df5d6[_0x1a8c('0x37')][_0x1a8c('0x42')]+'%'};return _0x55dd00;})});}_0x523bb1=_[_0x1a8c('0x44')]({},_0x523bb1,_0x1df5d6[_0x1a8c('0x52')]);return _0x26ee68[_0x1a8c('0x55')](_0x523bb1);}})['then'](function(_0x33fe10){if(_0x33fe10){_0x375adf=_0x33fe10[_0x1a8c('0x3e')];if(!_0x1df5d6[_0x1a8c('0x37')]['hasOwnProperty'](_0x1a8c('0x54'))){_0x523bb1[_0x1a8c('0x2a')]=qs['limit'](_0x1df5d6[_0x1a8c('0x37')][_0x1a8c('0x2a')]);_0x523bb1[_0x1a8c('0x29')]=qs[_0x1a8c('0x29')](_0x1df5d6[_0x1a8c('0x37')][_0x1a8c('0x29')]);}return _0x26ee68[_0x1a8c('0x55')](_0x523bb1);}})[_0x1a8c('0x1a')](function(_0x16f3f6){if(_0x16f3f6){return _0x16f3f6?{'count':_0x375adf,'rows':_0x16f3f6}:null;}})['then'](respondWithResult(_0x4e9d47,null))[_0x1a8c('0x23')](handleError(_0x4e9d47,null));};exports[_0x1a8c('0x56')]=function(_0x3b21d1,_0x3be863,_0x4ac24d){var _0x1c18d0={};var _0x430892={};var _0x34e24f;var _0x721408;return db[_0x1a8c('0x33')][_0x1a8c('0x4f')]({'where':{'id':_0x3b21d1[_0x1a8c('0x4a')]['id']}})[_0x1a8c('0x1a')](handleEntityNotFound(_0x3be863,null))['then'](function(_0x49f327){if(_0x49f327){_0x34e24f=_0x49f327;_0x430892[_0x1a8c('0x3b')]=_[_0x1a8c('0x38')](db[_0x1a8c('0x50')]['rawAttributes']);_0x430892[_0x1a8c('0x37')]=_[_0x1a8c('0x38')](_0x3b21d1[_0x1a8c('0x37')]);_0x430892[_0x1a8c('0x39')]=_[_0x1a8c('0x3a')](_0x430892[_0x1a8c('0x3b')],_0x430892['query']);_0x1c18d0[_0x1a8c('0x3c')]=_['intersection'](_0x430892[_0x1a8c('0x3b')],qs[_0x1a8c('0x3d')](_0x3b21d1[_0x1a8c('0x37')]['fields']));_0x1c18d0[_0x1a8c('0x3c')]=_0x1c18d0[_0x1a8c('0x3c')][_0x1a8c('0x3e')]?_0x1c18d0['attributes']:_0x430892[_0x1a8c('0x3b')];_0x1c18d0[_0x1a8c('0x40')]=qs[_0x1a8c('0x41')](_0x3b21d1[_0x1a8c('0x37')][_0x1a8c('0x41')]);_0x1c18d0[_0x1a8c('0x43')]=qs[_0x1a8c('0x39')](_['pick'](_0x3b21d1[_0x1a8c('0x37')],_0x430892['filters']));if(_0x3b21d1[_0x1a8c('0x37')][_0x1a8c('0x42')]){_0x1c18d0[_0x1a8c('0x43')]=_['merge'](_0x1c18d0[_0x1a8c('0x43')],{'$or':_[_0x1a8c('0x32')](_0x1c18d0[_0x1a8c('0x3c')],function(_0x556ea5){var _0x5b56d7={};_0x5b56d7[_0x556ea5]={'$like':'%'+_0x3b21d1[_0x1a8c('0x37')]['filter']+'%'};return _0x5b56d7;})});}_0x1c18d0=_[_0x1a8c('0x44')]({},_0x1c18d0,_0x3b21d1[_0x1a8c('0x52')]);return _0x34e24f['getDescriptions'](_0x1c18d0);}})[_0x1a8c('0x1a')](function(_0x46e452){if(_0x46e452){_0x721408=_0x46e452[_0x1a8c('0x3e')];if(!_0x3b21d1[_0x1a8c('0x37')][_0x1a8c('0x3f')](_0x1a8c('0x54'))){_0x1c18d0[_0x1a8c('0x2a')]=qs[_0x1a8c('0x2a')](_0x3b21d1[_0x1a8c('0x37')]['limit']);_0x1c18d0[_0x1a8c('0x29')]=qs['offset'](_0x3b21d1[_0x1a8c('0x37')][_0x1a8c('0x29')]);}return _0x34e24f[_0x1a8c('0x56')](_0x1c18d0);}})[_0x1a8c('0x1a')](function(_0xf93b1c){if(_0xf93b1c){return _0xf93b1c?{'count':_0x721408,'rows':_0xf93b1c}:null;}})[_0x1a8c('0x1a')](respondWithResult(_0x3be863,null))['catch'](handleError(_0x3be863,null));};
\ No newline at end of file
+var _0xdf65=['squel','crypto','jsforce','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','json','offset','undefined','limit','count','Content-Range','apply','save','update','destroy','status','error','stack','name','send','index','SugarcrmConfiguration','fieldName','type','key','model','map','keys','filters','intersection','query','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','then','include','findAll','rows','show','params','rawAttributes','fields','includeAll','options','find','create','body','catch','getFields','findOne','SugarcrmField','getSubjects','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','moment','util','path','sox','to-csv','ejs','fs-extra'];(function(_0xf3bf0b,_0x5c17ed){var _0x3e5c44=function(_0x111dd6){while(--_0x111dd6){_0xf3bf0b['push'](_0xf3bf0b['shift']());}};_0x3e5c44(++_0x5c17ed);}(_0xdf65,0x13d));var _0x5df6=function(_0x115149,_0x1fca9e){_0x115149=_0x115149-0x0;var _0x2a91dc=_0xdf65[_0x115149];return _0x2a91dc;};'use strict';var emlformat=require(_0x5df6('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x5df6('0x1'));var jsonpatch=require(_0x5df6('0x2'));var rp=require(_0x5df6('0x3'));var moment=require(_0x5df6('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x5df6('0x5'));var path=require(_0x5df6('0x6'));var sox=require(_0x5df6('0x7'));var csv=require(_0x5df6('0x8'));var ejs=require(_0x5df6('0x9'));var fs=require('fs');var fs_extra=require(_0x5df6('0xa'));var _=require('lodash');var squel=require(_0x5df6('0xb'));var crypto=require(_0x5df6('0xc'));var jsforce=require(_0x5df6('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x5df6('0x8'));var querystring=require(_0x5df6('0xe'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x5df6('0xf'));var qs=require(_0x5df6('0x10'));var as=require(_0x5df6('0x11'));var hardwareService=require(_0x5df6('0x12'));var logger=require(_0x5df6('0x13'))(_0x5df6('0x14'));var utils=require(_0x5df6('0x15'));var config=require(_0x5df6('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0x5df6('0x17'))['db'];function respondWithStatusCode(_0x10cf4f,_0xd8be85){_0xd8be85=_0xd8be85||0xcc;return function(_0x577f2a){if(_0x577f2a){return _0x10cf4f[_0x5df6('0x18')](_0xd8be85);}return _0x10cf4f['status'](_0xd8be85)[_0x5df6('0x19')]();};}function respondWithResult(_0x220aaa,_0x3b4c45){_0x3b4c45=_0x3b4c45||0xc8;return function(_0x50862c){if(_0x50862c){return _0x220aaa['status'](_0x3b4c45)[_0x5df6('0x1a')](_0x50862c);}};}function respondWithFilteredResult(_0x3aa495,_0x3ff0ad){return function(_0x4d2aa7){if(_0x4d2aa7){var _0x5281fb=typeof _0x3ff0ad[_0x5df6('0x1b')]===_0x5df6('0x1c')&&typeof _0x3ff0ad[_0x5df6('0x1d')]===_0x5df6('0x1c');var _0x339f70=_0x4d2aa7[_0x5df6('0x1e')];var _0x3827f7=_0x5281fb?0x0:_0x3ff0ad['offset'];var _0x38adc1=_0x5281fb?_0x4d2aa7['count']:_0x3ff0ad[_0x5df6('0x1b')]+_0x3ff0ad[_0x5df6('0x1d')];var _0x2e5de3;if(_0x38adc1>=_0x339f70){_0x38adc1=_0x339f70;_0x2e5de3=0xc8;}else{_0x2e5de3=0xce;}_0x3aa495['status'](_0x2e5de3);return _0x3aa495['set'](_0x5df6('0x1f'),_0x3827f7+'-'+_0x38adc1+'/'+_0x339f70)[_0x5df6('0x1a')](_0x4d2aa7);}return null;};}function patchUpdates(_0x5b3358){return function(_0x345ccc){try{jsonpatch[_0x5df6('0x20')](_0x345ccc,_0x5b3358,!![]);}catch(_0x55a71b){return BPromise['reject'](_0x55a71b);}return _0x345ccc[_0x5df6('0x21')]();};}function saveUpdates(_0x200dee,_0x19927b){return function(_0x439570){if(_0x439570){return _0x439570[_0x5df6('0x22')](_0x200dee)['then'](function(_0x338f5b){return _0x338f5b;});}return null;};}function removeEntity(_0x5851e2,_0x398539){return function(_0x2388e9){if(_0x2388e9){return _0x2388e9[_0x5df6('0x23')]()['then'](function(){_0x5851e2[_0x5df6('0x24')](0xcc)[_0x5df6('0x19')]();});}};}function handleEntityNotFound(_0x332a76,_0x242847){return function(_0x4ffbd7){if(!_0x4ffbd7){_0x332a76[_0x5df6('0x18')](0x194);}return _0x4ffbd7;};}function handleError(_0x3e61fd,_0x176495){_0x176495=_0x176495||0x1f4;return function(_0x13fbb8){logger[_0x5df6('0x25')](_0x13fbb8[_0x5df6('0x26')]);if(_0x13fbb8[_0x5df6('0x27')]){delete _0x13fbb8[_0x5df6('0x27')];}_0x3e61fd[_0x5df6('0x24')](_0x176495)[_0x5df6('0x28')](_0x13fbb8);};}exports[_0x5df6('0x29')]=function(_0x37f490,_0x60d6c8){var _0x1a4642={},_0x35a545={},_0x327f69={'count':0x0,'rows':[]};var _0x3d1dd7=_['map'](db[_0x5df6('0x2a')]['rawAttributes'],function(_0x516aea){return{'name':_0x516aea[_0x5df6('0x2b')],'type':_0x516aea[_0x5df6('0x2c')][_0x5df6('0x2d')]};});_0x35a545[_0x5df6('0x2e')]=_[_0x5df6('0x2f')](_0x3d1dd7,_0x5df6('0x27'));_0x35a545['query']=_[_0x5df6('0x30')](_0x37f490['query']);_0x35a545[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x35a545[_0x5df6('0x2e')],_0x35a545[_0x5df6('0x33')]);_0x1a4642[_0x5df6('0x34')]=_['intersection'](_0x35a545[_0x5df6('0x2e')],qs['fields'](_0x37f490['query']['fields']));_0x1a4642[_0x5df6('0x34')]=_0x1a4642[_0x5df6('0x34')][_0x5df6('0x35')]?_0x1a4642[_0x5df6('0x34')]:_0x35a545[_0x5df6('0x2e')];if(!_0x37f490[_0x5df6('0x33')][_0x5df6('0x36')](_0x5df6('0x37'))){_0x1a4642['limit']=qs[_0x5df6('0x1d')](_0x37f490['query'][_0x5df6('0x1d')]);_0x1a4642[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x37f490[_0x5df6('0x33')][_0x5df6('0x1b')]);}_0x1a4642[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x37f490['query'][_0x5df6('0x39')]);_0x1a4642[_0x5df6('0x3a')]=qs[_0x5df6('0x31')](_[_0x5df6('0x3b')](_0x37f490['query'],_0x35a545[_0x5df6('0x31')]),_0x3d1dd7);if(_0x37f490[_0x5df6('0x33')][_0x5df6('0x3c')]){_0x1a4642['where']=_['merge'](_0x1a4642[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x3d1dd7,function(_0x5ed024){if(_0x5ed024['type']!==_0x5df6('0x3d')){var _0x2c5343={};_0x2c5343[_0x5ed024[_0x5df6('0x27')]]={'$like':'%'+_0x37f490['query']['filter']+'%'};return _0x2c5343;}})});}_0x1a4642=_[_0x5df6('0x3e')]({},_0x1a4642,_0x37f490['options']);var _0x1608fb={'where':_0x1a4642[_0x5df6('0x3a')]};return db[_0x5df6('0x2a')]['count'](_0x1608fb)[_0x5df6('0x3f')](function(_0x34c152){_0x327f69[_0x5df6('0x1e')]=_0x34c152;if(_0x37f490[_0x5df6('0x33')]['includeAll']){_0x1a4642[_0x5df6('0x40')]=[{'all':!![]}];}return db[_0x5df6('0x2a')][_0x5df6('0x41')](_0x1a4642);})[_0x5df6('0x3f')](function(_0x549cc8){_0x327f69[_0x5df6('0x42')]=_0x549cc8;return _0x327f69;})[_0x5df6('0x3f')](respondWithFilteredResult(_0x60d6c8,_0x1a4642))['catch'](handleError(_0x60d6c8,null));};exports[_0x5df6('0x43')]=function(_0x49cf39,_0x52769c){var _0x5d6a66={'raw':![],'where':{'id':_0x49cf39[_0x5df6('0x44')]['id']}},_0x7f9d2={};_0x7f9d2[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db['SugarcrmConfiguration'][_0x5df6('0x45')]);_0x7f9d2[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x49cf39['query']);_0x7f9d2[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x7f9d2['model'],_0x7f9d2[_0x5df6('0x33')]);_0x5d6a66['attributes']=_[_0x5df6('0x32')](_0x7f9d2[_0x5df6('0x2e')],qs[_0x5df6('0x46')](_0x49cf39['query']['fields']));_0x5d6a66[_0x5df6('0x34')]=_0x5d6a66[_0x5df6('0x34')]['length']?_0x5d6a66[_0x5df6('0x34')]:_0x7f9d2['model'];if(_0x49cf39['query'][_0x5df6('0x47')]){_0x5d6a66[_0x5df6('0x40')]=[{'all':!![]}];}_0x5d6a66=_[_0x5df6('0x3e')]({},_0x5d6a66,_0x49cf39[_0x5df6('0x48')]);return db[_0x5df6('0x2a')][_0x5df6('0x49')](_0x5d6a66)[_0x5df6('0x3f')](handleEntityNotFound(_0x52769c,null))[_0x5df6('0x3f')](respondWithResult(_0x52769c,null))['catch'](handleError(_0x52769c,null));};exports[_0x5df6('0x4a')]=function(_0x38e7ef,_0x2c62d7){return db[_0x5df6('0x2a')][_0x5df6('0x4a')](_0x38e7ef[_0x5df6('0x4b')],{})['then'](respondWithResult(_0x2c62d7,0xc9))[_0x5df6('0x4c')](handleError(_0x2c62d7,null));};exports[_0x5df6('0x22')]=function(_0x237f4c,_0x1a783e){if(_0x237f4c['body']['id']){delete _0x237f4c[_0x5df6('0x4b')]['id'];}return db['SugarcrmConfiguration']['find']({'where':{'id':_0x237f4c[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x1a783e,null))[_0x5df6('0x3f')](saveUpdates(_0x237f4c[_0x5df6('0x4b')],null))['then'](respondWithResult(_0x1a783e,null))['catch'](handleError(_0x1a783e,null));};exports[_0x5df6('0x23')]=function(_0x1edfb7,_0x4967bb){return db[_0x5df6('0x2a')][_0x5df6('0x49')]({'where':{'id':_0x1edfb7[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x4967bb,null))[_0x5df6('0x3f')](removeEntity(_0x4967bb,null))[_0x5df6('0x4c')](handleError(_0x4967bb,null));};exports[_0x5df6('0x4d')]=function(_0x6beec1,_0x46de68,_0x1d3feb){var _0x5dc51c={};var _0x40f2e5={};var _0x1b75cc;var _0x3ca3f5;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x6beec1[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x46de68,null))['then'](function(_0x565481){if(_0x565481){_0x1b75cc=_0x565481;_0x40f2e5[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db[_0x5df6('0x4f')][_0x5df6('0x45')]);_0x40f2e5[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x6beec1[_0x5df6('0x33')]);_0x40f2e5['filters']=_[_0x5df6('0x32')](_0x40f2e5[_0x5df6('0x2e')],_0x40f2e5['query']);_0x5dc51c[_0x5df6('0x34')]=_[_0x5df6('0x32')](_0x40f2e5['model'],qs[_0x5df6('0x46')](_0x6beec1[_0x5df6('0x33')][_0x5df6('0x46')]));_0x5dc51c['attributes']=_0x5dc51c[_0x5df6('0x34')][_0x5df6('0x35')]?_0x5dc51c[_0x5df6('0x34')]:_0x40f2e5[_0x5df6('0x2e')];_0x5dc51c[_0x5df6('0x38')]=qs['sort'](_0x6beec1['query']['sort']);_0x5dc51c[_0x5df6('0x3a')]=qs[_0x5df6('0x31')](_[_0x5df6('0x3b')](_0x6beec1['query'],_0x40f2e5[_0x5df6('0x31')]));if(_0x6beec1['query'][_0x5df6('0x3c')]){_0x5dc51c[_0x5df6('0x3a')]=_[_0x5df6('0x3e')](_0x5dc51c[_0x5df6('0x3a')],{'$or':_['map'](_0x5dc51c['attributes'],function(_0x4ac672){var _0x3053c1={};_0x3053c1[_0x4ac672]={'$like':'%'+_0x6beec1[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x3053c1;})});}_0x5dc51c=_[_0x5df6('0x3e')]({},_0x5dc51c,_0x6beec1[_0x5df6('0x48')]);return _0x1b75cc[_0x5df6('0x4d')](_0x5dc51c);}})[_0x5df6('0x3f')](function(_0x348fc3){if(_0x348fc3){_0x3ca3f5=_0x348fc3['length'];if(!_0x6beec1['query'][_0x5df6('0x36')](_0x5df6('0x37'))){_0x5dc51c[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x6beec1[_0x5df6('0x33')][_0x5df6('0x1d')]);_0x5dc51c[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x6beec1[_0x5df6('0x33')]['offset']);}return _0x1b75cc['getFields'](_0x5dc51c);}})[_0x5df6('0x3f')](function(_0x97fffa){if(_0x97fffa){return _0x97fffa?{'count':_0x3ca3f5,'rows':_0x97fffa}:null;}})[_0x5df6('0x3f')](respondWithResult(_0x46de68,null))[_0x5df6('0x4c')](handleError(_0x46de68,null));};exports['getSubjects']=function(_0x5a189a,_0x3fd0b5,_0x390f9f){var _0x4b6237={};var _0x5e736e={};var _0x751c82;var _0xb273e;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x5a189a[_0x5df6('0x44')]['id']}})['then'](handleEntityNotFound(_0x3fd0b5,null))[_0x5df6('0x3f')](function(_0x41b3a7){if(_0x41b3a7){_0x751c82=_0x41b3a7;_0x5e736e[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db['SugarcrmField'][_0x5df6('0x45')]);_0x5e736e[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x5a189a['query']);_0x5e736e[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x5e736e[_0x5df6('0x2e')],_0x5e736e[_0x5df6('0x33')]);_0x4b6237['attributes']=_['intersection'](_0x5e736e[_0x5df6('0x2e')],qs[_0x5df6('0x46')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x46')]));_0x4b6237[_0x5df6('0x34')]=_0x4b6237['attributes']['length']?_0x4b6237['attributes']:_0x5e736e[_0x5df6('0x2e')];_0x4b6237[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x39')]);_0x4b6237['where']=qs['filters'](_[_0x5df6('0x3b')](_0x5a189a['query'],_0x5e736e[_0x5df6('0x31')]));if(_0x5a189a[_0x5df6('0x33')]['filter']){_0x4b6237['where']=_['merge'](_0x4b6237[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x4b6237['attributes'],function(_0x4ba447){var _0x5b8760={};_0x5b8760[_0x4ba447]={'$like':'%'+_0x5a189a[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x5b8760;})});}_0x4b6237=_[_0x5df6('0x3e')]({},_0x4b6237,_0x5a189a[_0x5df6('0x48')]);return _0x751c82[_0x5df6('0x50')](_0x4b6237);}})[_0x5df6('0x3f')](function(_0x3eebe4){if(_0x3eebe4){_0xb273e=_0x3eebe4['length'];if(!_0x5a189a[_0x5df6('0x33')]['hasOwnProperty'](_0x5df6('0x37'))){_0x4b6237[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x1d')]);_0x4b6237[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x1b')]);}return _0x751c82[_0x5df6('0x50')](_0x4b6237);}})[_0x5df6('0x3f')](function(_0xba102c){if(_0xba102c){return _0xba102c?{'count':_0xb273e,'rows':_0xba102c}:null;}})[_0x5df6('0x3f')](respondWithResult(_0x3fd0b5,null))[_0x5df6('0x4c')](handleError(_0x3fd0b5,null));};exports[_0x5df6('0x51')]=function(_0x27e596,_0x1597a4,_0x1641cc){var _0x3aeb80={};var _0x234c1f={};var _0x52ea14;var _0x3f06e2;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x27e596[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x1597a4,null))[_0x5df6('0x3f')](function(_0x30e721){if(_0x30e721){_0x52ea14=_0x30e721;_0x234c1f[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db[_0x5df6('0x4f')]['rawAttributes']);_0x234c1f['query']=_['keys'](_0x27e596['query']);_0x234c1f['filters']=_[_0x5df6('0x32')](_0x234c1f[_0x5df6('0x2e')],_0x234c1f[_0x5df6('0x33')]);_0x3aeb80[_0x5df6('0x34')]=_[_0x5df6('0x32')](_0x234c1f['model'],qs[_0x5df6('0x46')](_0x27e596['query'][_0x5df6('0x46')]));_0x3aeb80[_0x5df6('0x34')]=_0x3aeb80['attributes'][_0x5df6('0x35')]?_0x3aeb80[_0x5df6('0x34')]:_0x234c1f['model'];_0x3aeb80[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x27e596[_0x5df6('0x33')][_0x5df6('0x39')]);_0x3aeb80[_0x5df6('0x3a')]=qs['filters'](_['pick'](_0x27e596['query'],_0x234c1f['filters']));if(_0x27e596[_0x5df6('0x33')][_0x5df6('0x3c')]){_0x3aeb80[_0x5df6('0x3a')]=_[_0x5df6('0x3e')](_0x3aeb80[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x3aeb80['attributes'],function(_0x14c4f1){var _0x28fc43={};_0x28fc43[_0x14c4f1]={'$like':'%'+_0x27e596[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x28fc43;})});}_0x3aeb80=_[_0x5df6('0x3e')]({},_0x3aeb80,_0x27e596['options']);return _0x52ea14[_0x5df6('0x51')](_0x3aeb80);}})[_0x5df6('0x3f')](function(_0x49125b){if(_0x49125b){_0x3f06e2=_0x49125b[_0x5df6('0x35')];if(!_0x27e596[_0x5df6('0x33')]['hasOwnProperty'](_0x5df6('0x37'))){_0x3aeb80[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x27e596[_0x5df6('0x33')]['limit']);_0x3aeb80['offset']=qs['offset'](_0x27e596[_0x5df6('0x33')][_0x5df6('0x1b')]);}return _0x52ea14[_0x5df6('0x51')](_0x3aeb80);}})[_0x5df6('0x3f')](function(_0x5504c9){if(_0x5504c9){return _0x5504c9?{'count':_0x3f06e2,'rows':_0x5504c9}:null;}})['then'](respondWithResult(_0x1597a4,null))['catch'](handleError(_0x1597a4,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff