// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x2744=['intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','filters','pick','filter','merge','map','type','VIRTUAL','field','options','includeAll','include','findAll','rows','show','params','find','create','body','getFields','findOne','SugarcrmField','getSubjects','getDescriptions','order','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','sox','ejs','lodash','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../config/license/hardware','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','client','http','then','info','SugarcrmConfiguration,\x20%s,\x20%s','request\x20sent','debug','error','code','message','result','catch','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','update','destroy','name','send','index','SugarcrmConfiguration','rawAttributes','model','keys','query'];(function(_0x162aee,_0x25aa39){var _0x13a6d5=function(_0x2e9fb3){while(--_0x2e9fb3){_0x162aee['push'](_0x162aee['shift']());}};_0x13a6d5(++_0x25aa39);}(_0x2744,0xcc));var _0x4274=function(_0x20e82f,_0x5e8cce){_0x20e82f=_0x20e82f-0x0;var _0x421590=_0x2744[_0x20e82f];return _0x421590;};'use strict';var pdf=require(_0x4274('0x0'));var emlformat=require(_0x4274('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x4274('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x4274('0x3'));var moment=require(_0x4274('0x4'));var BPromise=require(_0x4274('0x5'));var Mustache=require(_0x4274('0x6'));var util=require(_0x4274('0x7'));var path=require('path');var sox=require(_0x4274('0x8'));var csv=require('to-csv');var ejs=require(_0x4274('0x9'));var fs=require('fs');var _=require(_0x4274('0xa'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x4274('0xb'));var deskjs=require(_0x4274('0xc'));var toCsv=require('to-csv');var querystring=require(_0x4274('0xd'));var Papa=require(_0x4274('0xe'));var authService=require(_0x4274('0xf'));var hardwareService=require(_0x4274('0x10'));var Redis=require('ioredis');var qs=require(_0x4274('0x11'));var logger=require(_0x4274('0x12'))(_0x4274('0x13'));var utils=require(_0x4274('0x14'));var config=require(_0x4274('0x15'));var db=require('../../mysqldb')['db'];var jayson=require('jayson/promise');var client=jayson[_0x4274('0x16')][_0x4274('0x17')]({'port':0x232a});function respondWithRpcPromise(_0x3bdbc3,_0x4dd17c,_0x525e0a,_0x347a8c){return new BPromise(function(_0x4384f4,_0x389f36){var _0x5873d9=_0x347a8c||client;return _0x5873d9['request'](_0x3bdbc3,_0x525e0a)[_0x4274('0x18')](function(_0x31e5b6){logger[_0x4274('0x19')](_0x4274('0x1a'),_0x4dd17c,_0x4274('0x1b'));logger[_0x4274('0x1c')]('SugarcrmConfiguration,\x20%s,\x20%s,\x20%s',_0x4dd17c,'request\x20sent',JSON['stringify'](_0x31e5b6));if(_0x31e5b6[_0x4274('0x1d')]){if(_0x31e5b6[_0x4274('0x1d')][_0x4274('0x1e')]===0x1f4){logger[_0x4274('0x1d')](_0x4274('0x1a'),_0x4dd17c,_0x31e5b6[_0x4274('0x1d')][_0x4274('0x1f')]);return _0x389f36(_0x31e5b6[_0x4274('0x1d')]['message']);}logger[_0x4274('0x1d')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x4dd17c,_0x31e5b6[_0x4274('0x1d')][_0x4274('0x1f')]);return _0x4384f4(_0x31e5b6[_0x4274('0x1d')][_0x4274('0x1f')]);}else{logger[_0x4274('0x19')](_0x4274('0x1a'),_0x4dd17c,'request\x20sent');_0x4384f4(_0x31e5b6[_0x4274('0x20')]['message']);}})[_0x4274('0x21')](function(_0x7d4c20){logger[_0x4274('0x1d')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x4dd17c,_0x7d4c20);_0x389f36(_0x7d4c20);});});}function respondWithStatusCode(_0x347d36,_0x306ba4){_0x306ba4=_0x306ba4||0xcc;return function(_0xd5c325){if(_0xd5c325){return _0x347d36[_0x4274('0x22')](_0x306ba4);}return _0x347d36['status'](_0x306ba4)[_0x4274('0x23')]();};}function respondWithResult(_0x22d19d,_0x23c502){_0x23c502=_0x23c502||0xc8;return function(_0x53ced9){if(_0x53ced9){return _0x22d19d[_0x4274('0x24')](_0x23c502)[_0x4274('0x25')](_0x53ced9);}};}function respondWithFilteredResult(_0x3917c0,_0x13f642){return function(_0x20a0dd){if(_0x20a0dd){var _0x38348c=_0x20a0dd[_0x4274('0x26')],_0xc99698=_0x13f642[_0x4274('0x27')],_0x58b341=_0x13f642[_0x4274('0x27')]+_0x13f642[_0x4274('0x28')],_0x6362f2;if(_0x58b341>=_0x38348c){_0x58b341=_0x38348c;_0x6362f2=0xc8;}else{_0x6362f2=0xce;}_0x3917c0[_0x4274('0x24')](_0x6362f2);return _0x3917c0[_0x4274('0x29')](_0x4274('0x2a'),_0xc99698+'-'+_0x58b341+'/'+_0x38348c)[_0x4274('0x25')](_0x20a0dd);}return null;};}function patchUpdates(_0x2f4516){return function(_0x5a3ff5){try{jsonpatch[_0x4274('0x2b')](_0x5a3ff5,_0x2f4516,!![]);}catch(_0x2be6d3){return BPromise['reject'](_0x2be6d3);}return _0x5a3ff5['save']();};}function saveUpdates(_0x46f4a4,_0x276046){return function(_0x2278df){if(_0x2278df){return _0x2278df[_0x4274('0x2c')](_0x46f4a4)['then'](function(_0x529e58){return _0x529e58;});}return null;};}function removeEntity(_0x52f2f7,_0x16f64e){return function(_0x1c5484){if(_0x1c5484){return _0x1c5484[_0x4274('0x2d')]()[_0x4274('0x18')](function(){_0x52f2f7[_0x4274('0x24')](0xcc)[_0x4274('0x23')]();});}};}function handleEntityNotFound(_0x5f545c,_0x15382b){return function(_0x4f1a0e){if(!_0x4f1a0e){_0x5f545c[_0x4274('0x22')](0x194);}return _0x4f1a0e;};}function handleError(_0x369636,_0x18cc0f){_0x18cc0f=_0x18cc0f||0x1f4;return function(_0x4a37ef){logger[_0x4274('0x1d')](_0x4a37ef['stack']);if(_0x4a37ef[_0x4274('0x2e')]){delete _0x4a37ef[_0x4274('0x2e')];}_0x369636[_0x4274('0x24')](_0x18cc0f)[_0x4274('0x2f')](_0x4a37ef);};}exports[_0x4274('0x30')]=function(_0x44e12a,_0x5b36dc){var _0x334206={},_0x1822fb={},_0x5c3910={'count':0x0,'rows':[]};var _0x48a5dc=db[_0x4274('0x31')][_0x4274('0x32')];_0x1822fb[_0x4274('0x33')]=_[_0x4274('0x34')](_0x48a5dc);_0x1822fb[_0x4274('0x35')]=_[_0x4274('0x34')](_0x44e12a['query']);_0x1822fb['filters']=_[_0x4274('0x36')](_0x1822fb[_0x4274('0x33')],_0x1822fb[_0x4274('0x35')]);_0x334206[_0x4274('0x37')]=_[_0x4274('0x36')](_0x1822fb['model'],qs[_0x4274('0x38')](_0x44e12a[_0x4274('0x35')][_0x4274('0x38')]));_0x334206[_0x4274('0x37')]=_0x334206[_0x4274('0x37')][_0x4274('0x39')]?_0x334206[_0x4274('0x37')]:_0x1822fb[_0x4274('0x33')];if(!_0x44e12a['query'][_0x4274('0x3a')](_0x4274('0x3b'))){_0x334206[_0x4274('0x28')]=qs[_0x4274('0x28')](_0x44e12a[_0x4274('0x35')]['limit']);_0x334206[_0x4274('0x27')]=qs['offset'](_0x44e12a[_0x4274('0x35')][_0x4274('0x27')]);}_0x334206['order']=qs[_0x4274('0x3c')](_0x44e12a[_0x4274('0x35')][_0x4274('0x3c')]);_0x334206[_0x4274('0x3d')]=qs[_0x4274('0x3e')](_[_0x4274('0x3f')](_0x44e12a[_0x4274('0x35')],_0x1822fb[_0x4274('0x3e')]));if(_0x44e12a[_0x4274('0x35')][_0x4274('0x40')]){_0x334206[_0x4274('0x3d')]=_[_0x4274('0x41')](_0x334206[_0x4274('0x3d')],{'$or':_[_0x4274('0x42')](_0x48a5dc,function(_0x3c65d7){if(_0x3c65d7[_0x4274('0x43')]['key']!==_0x4274('0x44')){var _0x488bbd={};_0x488bbd[_0x3c65d7[_0x4274('0x45')]]={'$like':'%'+_0x44e12a['query'][_0x4274('0x40')]+'%'};return _0x488bbd;}})});}_0x334206=_[_0x4274('0x41')]({},_0x334206,_0x44e12a[_0x4274('0x46')]);var _0x330c6f={'where':_0x334206[_0x4274('0x3d')]};return db['SugarcrmConfiguration'][_0x4274('0x26')](_0x330c6f)[_0x4274('0x18')](function(_0x3ef344){_0x5c3910[_0x4274('0x26')]=_0x3ef344;if(_0x44e12a['query'][_0x4274('0x47')]){_0x334206[_0x4274('0x48')]=[{'all':!![]}];}return db['SugarcrmConfiguration'][_0x4274('0x49')](_0x334206);})['then'](function(_0x5a04e1){_0x5c3910[_0x4274('0x4a')]=_0x5a04e1;return _0x5c3910;})[_0x4274('0x18')](respondWithFilteredResult(_0x5b36dc,_0x334206))[_0x4274('0x21')](handleError(_0x5b36dc,null));};exports[_0x4274('0x4b')]=function(_0x44fc10,_0x5868e5){var _0x7b8c95={'raw':![],'where':{'id':_0x44fc10[_0x4274('0x4c')]['id']}},_0x238c58={};_0x238c58['model']=_['keys'](db['SugarcrmConfiguration'][_0x4274('0x32')]);_0x238c58[_0x4274('0x35')]=_[_0x4274('0x34')](_0x44fc10[_0x4274('0x35')]);_0x238c58[_0x4274('0x3e')]=_['intersection'](_0x238c58['model'],_0x238c58[_0x4274('0x35')]);_0x7b8c95[_0x4274('0x37')]=_[_0x4274('0x36')](_0x238c58['model'],qs[_0x4274('0x38')](_0x44fc10[_0x4274('0x35')]['fields']));_0x7b8c95[_0x4274('0x37')]=_0x7b8c95[_0x4274('0x37')][_0x4274('0x39')]?_0x7b8c95[_0x4274('0x37')]:_0x238c58[_0x4274('0x33')];if(_0x44fc10[_0x4274('0x35')][_0x4274('0x47')]){_0x7b8c95[_0x4274('0x48')]=[{'all':!![]}];}_0x7b8c95=_['merge']({},_0x7b8c95,_0x44fc10['options']);return db[_0x4274('0x31')][_0x4274('0x4d')](_0x7b8c95)['then'](handleEntityNotFound(_0x5868e5,null))[_0x4274('0x18')](respondWithResult(_0x5868e5,null))[_0x4274('0x21')](handleError(_0x5868e5,null));};exports[_0x4274('0x4e')]=function(_0x9e3baf,_0x46eecf){return db[_0x4274('0x31')][_0x4274('0x4e')](_0x9e3baf[_0x4274('0x4f')],{})[_0x4274('0x18')](respondWithResult(_0x46eecf,0xc9))[_0x4274('0x21')](handleError(_0x46eecf,null));};exports['update']=function(_0x285a32,_0x99295c){if(_0x285a32[_0x4274('0x4f')]['id']){delete _0x285a32[_0x4274('0x4f')]['id'];}return db[_0x4274('0x31')][_0x4274('0x4d')]({'where':{'id':_0x285a32[_0x4274('0x4c')]['id']}})[_0x4274('0x18')](handleEntityNotFound(_0x99295c,null))['then'](saveUpdates(_0x285a32[_0x4274('0x4f')],null))[_0x4274('0x18')](respondWithResult(_0x99295c,null))[_0x4274('0x21')](handleError(_0x99295c,null));};exports[_0x4274('0x2d')]=function(_0x55cfa1,_0x2eb07a){return db[_0x4274('0x31')][_0x4274('0x4d')]({'where':{'id':_0x55cfa1[_0x4274('0x4c')]['id']}})[_0x4274('0x18')](handleEntityNotFound(_0x2eb07a,null))[_0x4274('0x18')](removeEntity(_0x2eb07a,null))[_0x4274('0x21')](handleError(_0x2eb07a,null));};exports[_0x4274('0x50')]=function(_0x34ec8d,_0x10ea39,_0x1ade65){var _0x573f27={};var _0x3a6c08={};var _0x41e9b7;var _0x2cd152;return db[_0x4274('0x31')][_0x4274('0x51')]({'where':{'id':_0x34ec8d[_0x4274('0x4c')]['id']}})[_0x4274('0x18')](handleEntityNotFound(_0x10ea39,null))[_0x4274('0x18')](function(_0x226fe6){if(_0x226fe6){_0x41e9b7=_0x226fe6;_0x3a6c08['model']=_['keys'](db[_0x4274('0x52')][_0x4274('0x32')]);_0x3a6c08[_0x4274('0x35')]=_[_0x4274('0x34')](_0x34ec8d[_0x4274('0x35')]);_0x3a6c08[_0x4274('0x3e')]=_[_0x4274('0x36')](_0x3a6c08[_0x4274('0x33')],_0x3a6c08[_0x4274('0x35')]);_0x573f27[_0x4274('0x37')]=_[_0x4274('0x36')](_0x3a6c08[_0x4274('0x33')],qs[_0x4274('0x38')](_0x34ec8d[_0x4274('0x35')]['fields']));_0x573f27[_0x4274('0x37')]=_0x573f27[_0x4274('0x37')][_0x4274('0x39')]?_0x573f27[_0x4274('0x37')]:_0x3a6c08[_0x4274('0x33')];_0x573f27['order']=qs['sort'](_0x34ec8d['query'][_0x4274('0x3c')]);_0x573f27['where']=qs[_0x4274('0x3e')](_[_0x4274('0x3f')](_0x34ec8d[_0x4274('0x35')],_0x3a6c08['filters']));if(_0x34ec8d['query'][_0x4274('0x40')]){_0x573f27[_0x4274('0x3d')]=_[_0x4274('0x41')](_0x573f27['where'],{'$or':_[_0x4274('0x42')](_0x573f27['attributes'],function(_0x379b96){var _0xf99cfa={};_0xf99cfa[_0x379b96]={'$like':'%'+_0x34ec8d[_0x4274('0x35')][_0x4274('0x40')]+'%'};return _0xf99cfa;})});}_0x573f27=_[_0x4274('0x41')]({},_0x573f27,_0x34ec8d['options']);return _0x41e9b7['getFields'](_0x573f27);}})['then'](function(_0x209809){if(_0x209809){_0x2cd152=_0x209809['length'];if(!_0x34ec8d[_0x4274('0x35')][_0x4274('0x3a')](_0x4274('0x3b'))){_0x573f27[_0x4274('0x28')]=qs[_0x4274('0x28')](_0x34ec8d['query']['limit']);_0x573f27[_0x4274('0x27')]=qs['offset'](_0x34ec8d[_0x4274('0x35')][_0x4274('0x27')]);}return _0x41e9b7[_0x4274('0x50')](_0x573f27);}})['then'](function(_0xc7501f){if(_0xc7501f){return _0xc7501f?{'count':_0x2cd152,'rows':_0xc7501f}:null;}})[_0x4274('0x18')](respondWithResult(_0x10ea39,null))[_0x4274('0x21')](handleError(_0x10ea39,null));};exports['getSubjects']=function(_0x1e2a1b,_0x3619e8,_0x2acb2d){var _0x19cde5={};var _0x1849f0={};var _0x12fbdb;var _0x548356;return db[_0x4274('0x31')][_0x4274('0x51')]({'where':{'id':_0x1e2a1b[_0x4274('0x4c')]['id']}})[_0x4274('0x18')](handleEntityNotFound(_0x3619e8,null))[_0x4274('0x18')](function(_0x16ee9f){if(_0x16ee9f){_0x12fbdb=_0x16ee9f;_0x1849f0[_0x4274('0x33')]=_[_0x4274('0x34')](db[_0x4274('0x52')][_0x4274('0x32')]);_0x1849f0[_0x4274('0x35')]=_[_0x4274('0x34')](_0x1e2a1b[_0x4274('0x35')]);_0x1849f0['filters']=_[_0x4274('0x36')](_0x1849f0[_0x4274('0x33')],_0x1849f0[_0x4274('0x35')]);_0x19cde5[_0x4274('0x37')]=_[_0x4274('0x36')](_0x1849f0['model'],qs[_0x4274('0x38')](_0x1e2a1b[_0x4274('0x35')][_0x4274('0x38')]));_0x19cde5[_0x4274('0x37')]=_0x19cde5['attributes'][_0x4274('0x39')]?_0x19cde5[_0x4274('0x37')]:_0x1849f0[_0x4274('0x33')];_0x19cde5['order']=qs['sort'](_0x1e2a1b[_0x4274('0x35')][_0x4274('0x3c')]);_0x19cde5[_0x4274('0x3d')]=qs[_0x4274('0x3e')](_[_0x4274('0x3f')](_0x1e2a1b[_0x4274('0x35')],_0x1849f0[_0x4274('0x3e')]));if(_0x1e2a1b['query']['filter']){_0x19cde5['where']=_['merge'](_0x19cde5['where'],{'$or':_[_0x4274('0x42')](_0x19cde5[_0x4274('0x37')],function(_0x515c03){var _0x59fde4={};_0x59fde4[_0x515c03]={'$like':'%'+_0x1e2a1b['query'][_0x4274('0x40')]+'%'};return _0x59fde4;})});}_0x19cde5=_[_0x4274('0x41')]({},_0x19cde5,_0x1e2a1b[_0x4274('0x46')]);return _0x12fbdb[_0x4274('0x53')](_0x19cde5);}})['then'](function(_0x48b4b6){if(_0x48b4b6){_0x548356=_0x48b4b6[_0x4274('0x39')];if(!_0x1e2a1b[_0x4274('0x35')][_0x4274('0x3a')](_0x4274('0x3b'))){_0x19cde5[_0x4274('0x28')]=qs[_0x4274('0x28')](_0x1e2a1b[_0x4274('0x35')][_0x4274('0x28')]);_0x19cde5[_0x4274('0x27')]=qs[_0x4274('0x27')](_0x1e2a1b[_0x4274('0x35')][_0x4274('0x27')]);}return _0x12fbdb[_0x4274('0x53')](_0x19cde5);}})[_0x4274('0x18')](function(_0x2d89c5){if(_0x2d89c5){return _0x2d89c5?{'count':_0x548356,'rows':_0x2d89c5}:null;}})['then'](respondWithResult(_0x3619e8,null))['catch'](handleError(_0x3619e8,null));};exports[_0x4274('0x54')]=function(_0x133595,_0xa0199f,_0x3adfd9){var _0x4707ff={};var _0x5ce9c4={};var _0x5c0dff;var _0x1b44cf;return db[_0x4274('0x31')][_0x4274('0x51')]({'where':{'id':_0x133595[_0x4274('0x4c')]['id']}})[_0x4274('0x18')](handleEntityNotFound(_0xa0199f,null))[_0x4274('0x18')](function(_0x5ba43e){if(_0x5ba43e){_0x5c0dff=_0x5ba43e;_0x5ce9c4[_0x4274('0x33')]=_[_0x4274('0x34')](db[_0x4274('0x52')][_0x4274('0x32')]);_0x5ce9c4[_0x4274('0x35')]=_[_0x4274('0x34')](_0x133595[_0x4274('0x35')]);_0x5ce9c4[_0x4274('0x3e')]=_[_0x4274('0x36')](_0x5ce9c4[_0x4274('0x33')],_0x5ce9c4['query']);_0x4707ff['attributes']=_[_0x4274('0x36')](_0x5ce9c4[_0x4274('0x33')],qs[_0x4274('0x38')](_0x133595['query'][_0x4274('0x38')]));_0x4707ff[_0x4274('0x37')]=_0x4707ff[_0x4274('0x37')][_0x4274('0x39')]?_0x4707ff[_0x4274('0x37')]:_0x5ce9c4[_0x4274('0x33')];_0x4707ff[_0x4274('0x55')]=qs[_0x4274('0x3c')](_0x133595['query'][_0x4274('0x3c')]);_0x4707ff[_0x4274('0x3d')]=qs[_0x4274('0x3e')](_[_0x4274('0x3f')](_0x133595[_0x4274('0x35')],_0x5ce9c4[_0x4274('0x3e')]));if(_0x133595[_0x4274('0x35')][_0x4274('0x40')]){_0x4707ff[_0x4274('0x3d')]=_['merge'](_0x4707ff['where'],{'$or':_['map'](_0x4707ff[_0x4274('0x37')],function(_0x2925d8){var _0x286d9e={};_0x286d9e[_0x2925d8]={'$like':'%'+_0x133595['query']['filter']+'%'};return _0x286d9e;})});}_0x4707ff=_[_0x4274('0x41')]({},_0x4707ff,_0x133595[_0x4274('0x46')]);return _0x5c0dff[_0x4274('0x54')](_0x4707ff);}})['then'](function(_0x21b1ab){if(_0x21b1ab){_0x1b44cf=_0x21b1ab[_0x4274('0x39')];if(!_0x133595[_0x4274('0x35')]['hasOwnProperty'](_0x4274('0x3b'))){_0x4707ff[_0x4274('0x28')]=qs[_0x4274('0x28')](_0x133595['query'][_0x4274('0x28')]);_0x4707ff['offset']=qs[_0x4274('0x27')](_0x133595[_0x4274('0x35')][_0x4274('0x27')]);}return _0x5c0dff[_0x4274('0x54')](_0x4707ff);}})[_0x4274('0x18')](function(_0x3e6799){if(_0x3e6799){return _0x3e6799?{'count':_0x1b44cf,'rows':_0x3e6799}:null;}})[_0x4274('0x18')](respondWithResult(_0xa0199f,null))[_0x4274('0x21')](handleError(_0xa0199f,null));};
\ No newline at end of file
+var _0xeb4a=['limit','set','Content-Range','json','apply','reject','update','stack','name','send','index','SugarcrmConfiguration','rawAttributes','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','map','type','key','field','count','includeAll','rows','show','params','create','body','find','destroy','getFields','SugarcrmField','pick','options','getSubjects','findOne','getDescriptions','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','to-csv','squel','crypto','jsforce','querystring','papaparse','../../components/auth/service','../../config/license/hardware','ioredis','../../config/logger','api','../../config/utils','../../config/environment','client','http','request','then','SugarcrmConfiguration,\x20%s,\x20%s','request\x20sent','debug','stringify','error','message','info','catch','sendStatus','status','end','offset'];(function(_0x1d7d3c,_0x329247){var _0x3bd0bb=function(_0x4ec79f){while(--_0x4ec79f){_0x1d7d3c['push'](_0x1d7d3c['shift']());}};_0x3bd0bb(++_0x329247);}(_0xeb4a,0xdc));var _0xaeb4=function(_0x5ad368,_0xfbed23){_0x5ad368=_0x5ad368-0x0;var _0xe04642=_0xeb4a[_0x5ad368];return _0xe04642;};'use strict';var pdf=require(_0xaeb4('0x0'));var emlformat=require(_0xaeb4('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xaeb4('0x2'));var jsonpatch=require(_0xaeb4('0x3'));var rp=require(_0xaeb4('0x4'));var moment=require(_0xaeb4('0x5'));var BPromise=require(_0xaeb4('0x6'));var Mustache=require('mustache');var util=require(_0xaeb4('0x7'));var path=require(_0xaeb4('0x8'));var sox=require('sox');var csv=require(_0xaeb4('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0xaeb4('0xa'));var crypto=require(_0xaeb4('0xb'));var jsforce=require(_0xaeb4('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xaeb4('0xd'));var Papa=require(_0xaeb4('0xe'));var authService=require(_0xaeb4('0xf'));var hardwareService=require(_0xaeb4('0x10'));var Redis=require(_0xaeb4('0x11'));var qs=require('../../components/parsers/qs');var logger=require(_0xaeb4('0x12'))(_0xaeb4('0x13'));var utils=require(_0xaeb4('0x14'));var config=require(_0xaeb4('0x15'));var db=require('../../mysqldb')['db'];var jayson=require('jayson/promise');var client=jayson[_0xaeb4('0x16')][_0xaeb4('0x17')]({'port':0x232a});function respondWithRpcPromise(_0x50877a,_0x300cf6,_0x2ac4ea,_0x314942){return new BPromise(function(_0x598c2b,_0x1fb0de){var _0x53b64a=_0x314942||client;return _0x53b64a[_0xaeb4('0x18')](_0x50877a,_0x2ac4ea)[_0xaeb4('0x19')](function(_0x3060cf){logger['info'](_0xaeb4('0x1a'),_0x300cf6,_0xaeb4('0x1b'));logger[_0xaeb4('0x1c')]('SugarcrmConfiguration,\x20%s,\x20%s,\x20%s',_0x300cf6,_0xaeb4('0x1b'),JSON[_0xaeb4('0x1d')](_0x3060cf));if(_0x3060cf['error']){if(_0x3060cf['error']['code']===0x1f4){logger[_0xaeb4('0x1e')](_0xaeb4('0x1a'),_0x300cf6,_0x3060cf[_0xaeb4('0x1e')][_0xaeb4('0x1f')]);return _0x1fb0de(_0x3060cf[_0xaeb4('0x1e')][_0xaeb4('0x1f')]);}logger[_0xaeb4('0x1e')](_0xaeb4('0x1a'),_0x300cf6,_0x3060cf[_0xaeb4('0x1e')][_0xaeb4('0x1f')]);return _0x598c2b(_0x3060cf[_0xaeb4('0x1e')]['message']);}else{logger[_0xaeb4('0x20')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x300cf6,_0xaeb4('0x1b'));_0x598c2b(_0x3060cf['result'][_0xaeb4('0x1f')]);}})[_0xaeb4('0x21')](function(_0x3dadaa){logger[_0xaeb4('0x1e')](_0xaeb4('0x1a'),_0x300cf6,_0x3dadaa);_0x1fb0de(_0x3dadaa);});});}function respondWithStatusCode(_0x331684,_0x4c61f0){_0x4c61f0=_0x4c61f0||0xcc;return function(_0x514f9c){if(_0x514f9c){return _0x331684[_0xaeb4('0x22')](_0x4c61f0);}return _0x331684[_0xaeb4('0x23')](_0x4c61f0)[_0xaeb4('0x24')]();};}function respondWithResult(_0x33ff1b,_0x3e065d){_0x3e065d=_0x3e065d||0xc8;return function(_0x3a9012){if(_0x3a9012){return _0x33ff1b[_0xaeb4('0x23')](_0x3e065d)['json'](_0x3a9012);}};}function respondWithFilteredResult(_0x317954,_0x33abed){return function(_0x4dbae5){if(_0x4dbae5){var _0x27c669=_0x4dbae5['count'],_0x1a6111=_0x33abed[_0xaeb4('0x25')],_0x313384=_0x33abed[_0xaeb4('0x25')]+_0x33abed[_0xaeb4('0x26')],_0x71a04a;if(_0x313384>=_0x27c669){_0x313384=_0x27c669;_0x71a04a=0xc8;}else{_0x71a04a=0xce;}_0x317954[_0xaeb4('0x23')](_0x71a04a);return _0x317954[_0xaeb4('0x27')](_0xaeb4('0x28'),_0x1a6111+'-'+_0x313384+'/'+_0x27c669)[_0xaeb4('0x29')](_0x4dbae5);}return null;};}function patchUpdates(_0x3722f3){return function(_0x49d9cf){try{jsonpatch[_0xaeb4('0x2a')](_0x49d9cf,_0x3722f3,!![]);}catch(_0x40cd77){return BPromise[_0xaeb4('0x2b')](_0x40cd77);}return _0x49d9cf['save']();};}function saveUpdates(_0x26b35c,_0x4fb992){return function(_0x3944bd){if(_0x3944bd){return _0x3944bd[_0xaeb4('0x2c')](_0x26b35c)[_0xaeb4('0x19')](function(_0x1da44f){return _0x1da44f;});}return null;};}function removeEntity(_0x5baa33,_0x2eee30){return function(_0x5fbe2c){if(_0x5fbe2c){return _0x5fbe2c['destroy']()[_0xaeb4('0x19')](function(){_0x5baa33['status'](0xcc)[_0xaeb4('0x24')]();});}};}function handleEntityNotFound(_0x33c8b0,_0x57604d){return function(_0x3cc493){if(!_0x3cc493){_0x33c8b0[_0xaeb4('0x22')](0x194);}return _0x3cc493;};}function handleError(_0x4fa706,_0x182282){_0x182282=_0x182282||0x1f4;return function(_0x4c3747){logger[_0xaeb4('0x1e')](_0x4c3747[_0xaeb4('0x2d')]);if(_0x4c3747[_0xaeb4('0x2e')]){delete _0x4c3747['name'];}_0x4fa706[_0xaeb4('0x23')](_0x182282)[_0xaeb4('0x2f')](_0x4c3747);};}exports[_0xaeb4('0x30')]=function(_0xc46c7c,_0x443dca){var _0x33edb1={},_0x39f659={},_0x1ccb2c={'count':0x0,'rows':[]};var _0x4635ce=db[_0xaeb4('0x31')][_0xaeb4('0x32')];_0x39f659[_0xaeb4('0x33')]=_[_0xaeb4('0x34')](_0x4635ce);_0x39f659[_0xaeb4('0x35')]=_['keys'](_0xc46c7c[_0xaeb4('0x35')]);_0x39f659[_0xaeb4('0x36')]=_[_0xaeb4('0x37')](_0x39f659[_0xaeb4('0x33')],_0x39f659[_0xaeb4('0x35')]);_0x33edb1[_0xaeb4('0x38')]=_[_0xaeb4('0x37')](_0x39f659[_0xaeb4('0x33')],qs[_0xaeb4('0x39')](_0xc46c7c['query'][_0xaeb4('0x39')]));_0x33edb1[_0xaeb4('0x38')]=_0x33edb1[_0xaeb4('0x38')][_0xaeb4('0x3a')]?_0x33edb1['attributes']:_0x39f659[_0xaeb4('0x33')];if(!_0xc46c7c['query'][_0xaeb4('0x3b')](_0xaeb4('0x3c'))){_0x33edb1[_0xaeb4('0x26')]=qs[_0xaeb4('0x26')](_0xc46c7c[_0xaeb4('0x35')]['limit']);_0x33edb1[_0xaeb4('0x25')]=qs[_0xaeb4('0x25')](_0xc46c7c[_0xaeb4('0x35')][_0xaeb4('0x25')]);}_0x33edb1[_0xaeb4('0x3d')]=qs[_0xaeb4('0x3e')](_0xc46c7c[_0xaeb4('0x35')]['sort']);_0x33edb1[_0xaeb4('0x3f')]=qs[_0xaeb4('0x36')](_['pick'](_0xc46c7c[_0xaeb4('0x35')],_0x39f659[_0xaeb4('0x36')]));if(_0xc46c7c[_0xaeb4('0x35')][_0xaeb4('0x40')]){_0x33edb1[_0xaeb4('0x3f')]=_[_0xaeb4('0x41')](_0x33edb1['where'],{'$or':_[_0xaeb4('0x42')](_0x4635ce,function(_0x5425bc){if(_0x5425bc[_0xaeb4('0x43')][_0xaeb4('0x44')]!=='VIRTUAL'){var _0x19419a={};_0x19419a[_0x5425bc[_0xaeb4('0x45')]]={'$like':'%'+_0xc46c7c['query']['filter']+'%'};return _0x19419a;}})});}_0x33edb1=_['merge']({},_0x33edb1,_0xc46c7c['options']);var _0x74f81e={'where':_0x33edb1[_0xaeb4('0x3f')]};return db[_0xaeb4('0x31')]['count'](_0x74f81e)[_0xaeb4('0x19')](function(_0x24f643){_0x1ccb2c[_0xaeb4('0x46')]=_0x24f643;if(_0xc46c7c[_0xaeb4('0x35')][_0xaeb4('0x47')]){_0x33edb1['include']=[{'all':!![]}];}return db[_0xaeb4('0x31')]['findAll'](_0x33edb1);})[_0xaeb4('0x19')](function(_0xaec641){_0x1ccb2c[_0xaeb4('0x48')]=_0xaec641;return _0x1ccb2c;})['then'](respondWithFilteredResult(_0x443dca,_0x33edb1))[_0xaeb4('0x21')](handleError(_0x443dca,null));};exports[_0xaeb4('0x49')]=function(_0x577e31,_0x57b4bf){var _0x9c00bf={'raw':![],'where':{'id':_0x577e31[_0xaeb4('0x4a')]['id']}},_0x34cbe4={};_0x34cbe4[_0xaeb4('0x33')]=_[_0xaeb4('0x34')](db[_0xaeb4('0x31')][_0xaeb4('0x32')]);_0x34cbe4[_0xaeb4('0x35')]=_[_0xaeb4('0x34')](_0x577e31[_0xaeb4('0x35')]);_0x34cbe4[_0xaeb4('0x36')]=_[_0xaeb4('0x37')](_0x34cbe4[_0xaeb4('0x33')],_0x34cbe4[_0xaeb4('0x35')]);_0x9c00bf[_0xaeb4('0x38')]=_['intersection'](_0x34cbe4[_0xaeb4('0x33')],qs['fields'](_0x577e31[_0xaeb4('0x35')][_0xaeb4('0x39')]));_0x9c00bf[_0xaeb4('0x38')]=_0x9c00bf[_0xaeb4('0x38')][_0xaeb4('0x3a')]?_0x9c00bf[_0xaeb4('0x38')]:_0x34cbe4[_0xaeb4('0x33')];if(_0x577e31[_0xaeb4('0x35')][_0xaeb4('0x47')]){_0x9c00bf['include']=[{'all':!![]}];}_0x9c00bf=_[_0xaeb4('0x41')]({},_0x9c00bf,_0x577e31['options']);return db[_0xaeb4('0x31')]['find'](_0x9c00bf)[_0xaeb4('0x19')](handleEntityNotFound(_0x57b4bf,null))[_0xaeb4('0x19')](respondWithResult(_0x57b4bf,null))[_0xaeb4('0x21')](handleError(_0x57b4bf,null));};exports[_0xaeb4('0x4b')]=function(_0x191bc8,_0x2de1bf){return db['SugarcrmConfiguration'][_0xaeb4('0x4b')](_0x191bc8[_0xaeb4('0x4c')],{})[_0xaeb4('0x19')](respondWithResult(_0x2de1bf,0xc9))[_0xaeb4('0x21')](handleError(_0x2de1bf,null));};exports['update']=function(_0x2d694a,_0x4998e4){if(_0x2d694a['body']['id']){delete _0x2d694a[_0xaeb4('0x4c')]['id'];}return db['SugarcrmConfiguration'][_0xaeb4('0x4d')]({'where':{'id':_0x2d694a['params']['id']}})['then'](handleEntityNotFound(_0x4998e4,null))[_0xaeb4('0x19')](saveUpdates(_0x2d694a[_0xaeb4('0x4c')],null))[_0xaeb4('0x19')](respondWithResult(_0x4998e4,null))[_0xaeb4('0x21')](handleError(_0x4998e4,null));};exports[_0xaeb4('0x4e')]=function(_0x517c74,_0x38929c){return db[_0xaeb4('0x31')]['find']({'where':{'id':_0x517c74[_0xaeb4('0x4a')]['id']}})[_0xaeb4('0x19')](handleEntityNotFound(_0x38929c,null))[_0xaeb4('0x19')](removeEntity(_0x38929c,null))[_0xaeb4('0x21')](handleError(_0x38929c,null));};exports[_0xaeb4('0x4f')]=function(_0x49d83c,_0x28e06b,_0x300a80){var _0x46defe={};var _0x38929f={};var _0x31b59e;var _0x1d47de;return db[_0xaeb4('0x31')]['findOne']({'where':{'id':_0x49d83c['params']['id']}})['then'](handleEntityNotFound(_0x28e06b,null))[_0xaeb4('0x19')](function(_0x44798f){if(_0x44798f){_0x31b59e=_0x44798f;_0x38929f[_0xaeb4('0x33')]=_[_0xaeb4('0x34')](db[_0xaeb4('0x50')][_0xaeb4('0x32')]);_0x38929f['query']=_[_0xaeb4('0x34')](_0x49d83c[_0xaeb4('0x35')]);_0x38929f[_0xaeb4('0x36')]=_['intersection'](_0x38929f[_0xaeb4('0x33')],_0x38929f[_0xaeb4('0x35')]);_0x46defe[_0xaeb4('0x38')]=_[_0xaeb4('0x37')](_0x38929f[_0xaeb4('0x33')],qs['fields'](_0x49d83c[_0xaeb4('0x35')][_0xaeb4('0x39')]));_0x46defe[_0xaeb4('0x38')]=_0x46defe[_0xaeb4('0x38')][_0xaeb4('0x3a')]?_0x46defe[_0xaeb4('0x38')]:_0x38929f[_0xaeb4('0x33')];_0x46defe['order']=qs['sort'](_0x49d83c[_0xaeb4('0x35')]['sort']);_0x46defe[_0xaeb4('0x3f')]=qs[_0xaeb4('0x36')](_[_0xaeb4('0x51')](_0x49d83c[_0xaeb4('0x35')],_0x38929f['filters']));if(_0x49d83c[_0xaeb4('0x35')][_0xaeb4('0x40')]){_0x46defe[_0xaeb4('0x3f')]=_[_0xaeb4('0x41')](_0x46defe[_0xaeb4('0x3f')],{'$or':_[_0xaeb4('0x42')](_0x46defe[_0xaeb4('0x38')],function(_0x35fc06){var _0x578d9b={};_0x578d9b[_0x35fc06]={'$like':'%'+_0x49d83c[_0xaeb4('0x35')][_0xaeb4('0x40')]+'%'};return _0x578d9b;})});}_0x46defe=_[_0xaeb4('0x41')]({},_0x46defe,_0x49d83c[_0xaeb4('0x52')]);return _0x31b59e['getFields'](_0x46defe);}})[_0xaeb4('0x19')](function(_0x49c0ec){if(_0x49c0ec){_0x1d47de=_0x49c0ec[_0xaeb4('0x3a')];if(!_0x49d83c[_0xaeb4('0x35')][_0xaeb4('0x3b')](_0xaeb4('0x3c'))){_0x46defe[_0xaeb4('0x26')]=qs[_0xaeb4('0x26')](_0x49d83c[_0xaeb4('0x35')][_0xaeb4('0x26')]);_0x46defe['offset']=qs[_0xaeb4('0x25')](_0x49d83c[_0xaeb4('0x35')][_0xaeb4('0x25')]);}return _0x31b59e[_0xaeb4('0x4f')](_0x46defe);}})[_0xaeb4('0x19')](function(_0x4fc386){if(_0x4fc386){return _0x4fc386?{'count':_0x1d47de,'rows':_0x4fc386}:null;}})[_0xaeb4('0x19')](respondWithResult(_0x28e06b,null))[_0xaeb4('0x21')](handleError(_0x28e06b,null));};exports[_0xaeb4('0x53')]=function(_0x312473,_0x1ba5f5,_0x421fdb){var _0x2a6a61={};var _0x14af82={};var _0x2aa865;var _0x19e577;return db[_0xaeb4('0x31')][_0xaeb4('0x54')]({'where':{'id':_0x312473[_0xaeb4('0x4a')]['id']}})['then'](handleEntityNotFound(_0x1ba5f5,null))[_0xaeb4('0x19')](function(_0xffa21e){if(_0xffa21e){_0x2aa865=_0xffa21e;_0x14af82[_0xaeb4('0x33')]=_['keys'](db[_0xaeb4('0x50')][_0xaeb4('0x32')]);_0x14af82[_0xaeb4('0x35')]=_[_0xaeb4('0x34')](_0x312473[_0xaeb4('0x35')]);_0x14af82[_0xaeb4('0x36')]=_[_0xaeb4('0x37')](_0x14af82['model'],_0x14af82[_0xaeb4('0x35')]);_0x2a6a61[_0xaeb4('0x38')]=_[_0xaeb4('0x37')](_0x14af82[_0xaeb4('0x33')],qs['fields'](_0x312473[_0xaeb4('0x35')]['fields']));_0x2a6a61['attributes']=_0x2a6a61[_0xaeb4('0x38')][_0xaeb4('0x3a')]?_0x2a6a61[_0xaeb4('0x38')]:_0x14af82['model'];_0x2a6a61['order']=qs[_0xaeb4('0x3e')](_0x312473['query'][_0xaeb4('0x3e')]);_0x2a6a61[_0xaeb4('0x3f')]=qs[_0xaeb4('0x36')](_[_0xaeb4('0x51')](_0x312473[_0xaeb4('0x35')],_0x14af82['filters']));if(_0x312473[_0xaeb4('0x35')]['filter']){_0x2a6a61['where']=_[_0xaeb4('0x41')](_0x2a6a61['where'],{'$or':_[_0xaeb4('0x42')](_0x2a6a61[_0xaeb4('0x38')],function(_0x5cefa1){var _0x3250a1={};_0x3250a1[_0x5cefa1]={'$like':'%'+_0x312473[_0xaeb4('0x35')][_0xaeb4('0x40')]+'%'};return _0x3250a1;})});}_0x2a6a61=_[_0xaeb4('0x41')]({},_0x2a6a61,_0x312473[_0xaeb4('0x52')]);return _0x2aa865['getSubjects'](_0x2a6a61);}})['then'](function(_0x1d685f){if(_0x1d685f){_0x19e577=_0x1d685f[_0xaeb4('0x3a')];if(!_0x312473[_0xaeb4('0x35')][_0xaeb4('0x3b')](_0xaeb4('0x3c'))){_0x2a6a61[_0xaeb4('0x26')]=qs[_0xaeb4('0x26')](_0x312473['query']['limit']);_0x2a6a61[_0xaeb4('0x25')]=qs[_0xaeb4('0x25')](_0x312473['query'][_0xaeb4('0x25')]);}return _0x2aa865[_0xaeb4('0x53')](_0x2a6a61);}})[_0xaeb4('0x19')](function(_0x3e70a2){if(_0x3e70a2){return _0x3e70a2?{'count':_0x19e577,'rows':_0x3e70a2}:null;}})[_0xaeb4('0x19')](respondWithResult(_0x1ba5f5,null))[_0xaeb4('0x21')](handleError(_0x1ba5f5,null));};exports[_0xaeb4('0x55')]=function(_0x40f0ac,_0x43cbc6,_0x15ea85){var _0x19a361={};var _0x255093={};var _0x4ac4e8;var _0x2b8139;return db['SugarcrmConfiguration'][_0xaeb4('0x54')]({'where':{'id':_0x40f0ac['params']['id']}})[_0xaeb4('0x19')](handleEntityNotFound(_0x43cbc6,null))['then'](function(_0x5a72bd){if(_0x5a72bd){_0x4ac4e8=_0x5a72bd;_0x255093[_0xaeb4('0x33')]=_['keys'](db[_0xaeb4('0x50')]['rawAttributes']);_0x255093['query']=_[_0xaeb4('0x34')](_0x40f0ac[_0xaeb4('0x35')]);_0x255093[_0xaeb4('0x36')]=_['intersection'](_0x255093[_0xaeb4('0x33')],_0x255093['query']);_0x19a361[_0xaeb4('0x38')]=_[_0xaeb4('0x37')](_0x255093['model'],qs['fields'](_0x40f0ac[_0xaeb4('0x35')][_0xaeb4('0x39')]));_0x19a361[_0xaeb4('0x38')]=_0x19a361[_0xaeb4('0x38')][_0xaeb4('0x3a')]?_0x19a361['attributes']:_0x255093[_0xaeb4('0x33')];_0x19a361[_0xaeb4('0x3d')]=qs[_0xaeb4('0x3e')](_0x40f0ac[_0xaeb4('0x35')][_0xaeb4('0x3e')]);_0x19a361[_0xaeb4('0x3f')]=qs[_0xaeb4('0x36')](_['pick'](_0x40f0ac[_0xaeb4('0x35')],_0x255093[_0xaeb4('0x36')]));if(_0x40f0ac[_0xaeb4('0x35')][_0xaeb4('0x40')]){_0x19a361[_0xaeb4('0x3f')]=_[_0xaeb4('0x41')](_0x19a361[_0xaeb4('0x3f')],{'$or':_['map'](_0x19a361[_0xaeb4('0x38')],function(_0x425441){var _0x3e2d07={};_0x3e2d07[_0x425441]={'$like':'%'+_0x40f0ac[_0xaeb4('0x35')][_0xaeb4('0x40')]+'%'};return _0x3e2d07;})});}_0x19a361=_[_0xaeb4('0x41')]({},_0x19a361,_0x40f0ac[_0xaeb4('0x52')]);return _0x4ac4e8['getDescriptions'](_0x19a361);}})[_0xaeb4('0x19')](function(_0x5ae88d){if(_0x5ae88d){_0x2b8139=_0x5ae88d['length'];if(!_0x40f0ac[_0xaeb4('0x35')][_0xaeb4('0x3b')](_0xaeb4('0x3c'))){_0x19a361[_0xaeb4('0x26')]=qs['limit'](_0x40f0ac[_0xaeb4('0x35')][_0xaeb4('0x26')]);_0x19a361['offset']=qs['offset'](_0x40f0ac[_0xaeb4('0x35')][_0xaeb4('0x25')]);}return _0x4ac4e8[_0xaeb4('0x55')](_0x19a361);}})[_0xaeb4('0x19')](function(_0x19e3a2){if(_0x19e3a2){return _0x19e3a2?{'count':_0x2b8139,'rows':_0x19e3a2}:null;}})[_0xaeb4('0x19')](respondWithResult(_0x43cbc6,null))['catch'](handleError(_0x43cbc6,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff