Built motion from commit b0a9a629.|2.6.33
[motion2.git] / server / api / intSugarcrmConfiguration / intSugarcrmConfiguration.controller.js
index 95d83fb..326bcd3 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x0dc1=['include','findAll','rows','catch','show','params','find','create','SugarcrmConfiguration','body','getFields','findOne','SugarcrmField','order','pick','nolimit','getSubjects','getDescriptions','hasOwnProperty','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','client','test','Sequelize','The\x20password\x20must\x20be\x20at\x20least\x208\x20characters\x20long\x20and\x20have\x201\x20lowercase\x20character,\x201\x20uppercase\x20character,\x201\x20number\x20and\x201\x20special\x20character\x20~!@#$%^&-_=+[{]}.','info','request\x20sent','SugarcrmConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','SugarcrmConfiguration,\x20%s,\x20%s','message','result','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','update','destroy','then','stack','name','send','index','map','rawAttributes','type','key','model','query','keys','filters','intersection','attributes','fields','length','sort','where','filter','VIRTUAL','merge','options','includeAll'];(function(_0xf46703,_0x2a8da9){var _0x105f45=function(_0xdd09f9){while(--_0xdd09f9){_0xf46703['push'](_0xf46703['shift']());}};_0x105f45(++_0x2a8da9);}(_0x0dc1,0xd1));var _0x10dc=function(_0x8f3f8e,_0x173886){_0x8f3f8e=_0x8f3f8e-0x0;var _0x283c58=_0x0dc1[_0x8f3f8e];return _0x283c58;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x10dc('0x0'));var rimraf=require(_0x10dc('0x1'));var zipdir=require(_0x10dc('0x2'));var jsonpatch=require(_0x10dc('0x3'));var rp=require(_0x10dc('0x4'));var moment=require(_0x10dc('0x5'));var BPromise=require(_0x10dc('0x6'));var Mustache=require(_0x10dc('0x7'));var util=require(_0x10dc('0x8'));var path=require(_0x10dc('0x9'));var sox=require(_0x10dc('0xa'));var csv=require(_0x10dc('0xb'));var ejs=require(_0x10dc('0xc'));var fs=require('fs');var _=require(_0x10dc('0xd'));var squel=require(_0x10dc('0xe'));var crypto=require(_0x10dc('0xf'));var jsforce=require(_0x10dc('0x10'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x10dc('0x11'));var Papa=require(_0x10dc('0x12'));var Redis=require(_0x10dc('0x13'));var authService=require(_0x10dc('0x14'));var qs=require(_0x10dc('0x15'));var as=require(_0x10dc('0x16'));var hardwareService=require(_0x10dc('0x17'));var logger=require(_0x10dc('0x18'))('api');var utils=require('../../config/utils');var config=require(_0x10dc('0x19'));var db=require(_0x10dc('0x1a'))['db'];var jayson=require('jayson/promise');var client=jayson[_0x10dc('0x1b')]['http']({'port':0x232a});function checkPasswordPattern(_0x354ad4,_0x307c19,_0x561e2c){if(_0x561e2c){var _0x4b7289=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x4b7289[_0x10dc('0x1c')](_0x307c19)){return _0x354ad4;}else{throw new db[(_0x10dc('0x1d'))]['ValidationError'](_0x10dc('0x1e'));}}else{return _0x354ad4;}}function respondWithRpcPromise(_0x408b98,_0x59cf59,_0x29f7cf,_0x574666){return new BPromise(function(_0x362c98,_0x56e9df){var _0x363af7=_0x574666||client;return _0x363af7['request'](_0x408b98,_0x29f7cf)['then'](function(_0x3b0aa2){logger[_0x10dc('0x1f')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x59cf59,_0x10dc('0x20'));logger['debug'](_0x10dc('0x21'),_0x59cf59,_0x10dc('0x20'),JSON[_0x10dc('0x22')](_0x3b0aa2));if(_0x3b0aa2[_0x10dc('0x23')]){if(_0x3b0aa2[_0x10dc('0x23')]['code']===0x1f4){logger[_0x10dc('0x23')](_0x10dc('0x24'),_0x59cf59,_0x3b0aa2[_0x10dc('0x23')][_0x10dc('0x25')]);return _0x56e9df(_0x3b0aa2['error'][_0x10dc('0x25')]);}logger['error']('SugarcrmConfiguration,\x20%s,\x20%s',_0x59cf59,_0x3b0aa2['error'][_0x10dc('0x25')]);return _0x362c98(_0x3b0aa2['error'][_0x10dc('0x25')]);}else{logger[_0x10dc('0x1f')](_0x10dc('0x24'),_0x59cf59,_0x10dc('0x20'));_0x362c98(_0x3b0aa2[_0x10dc('0x26')]['message']);}})['catch'](function(_0x2ca7be){logger['error']('SugarcrmConfiguration,\x20%s,\x20%s',_0x59cf59,_0x2ca7be);_0x56e9df(_0x2ca7be);});});}function respondWithStatusCode(_0x212d4f,_0x1ff606){_0x1ff606=_0x1ff606||0xcc;return function(_0x2628ee){if(_0x2628ee){return _0x212d4f[_0x10dc('0x27')](_0x1ff606);}return _0x212d4f[_0x10dc('0x28')](_0x1ff606)[_0x10dc('0x29')]();};}function respondWithResult(_0x3284f9,_0x1f85af){_0x1f85af=_0x1f85af||0xc8;return function(_0x5e7643){if(_0x5e7643){return _0x3284f9[_0x10dc('0x28')](_0x1f85af)[_0x10dc('0x2a')](_0x5e7643);}};}function respondWithFilteredResult(_0x4b8a4d,_0x10c7b2){return function(_0x46e73a){if(_0x46e73a){var _0x7e9eac=_0x46e73a[_0x10dc('0x2b')],_0x1703ce=_0x10c7b2[_0x10dc('0x2c')],_0x2161e3=_0x10c7b2[_0x10dc('0x2c')]+_0x10c7b2[_0x10dc('0x2d')],_0x137576;if(_0x2161e3>=_0x7e9eac){_0x2161e3=_0x7e9eac;_0x137576=0xc8;}else{_0x137576=0xce;}_0x4b8a4d[_0x10dc('0x28')](_0x137576);return _0x4b8a4d[_0x10dc('0x2e')](_0x10dc('0x2f'),_0x1703ce+'-'+_0x2161e3+'/'+_0x7e9eac)[_0x10dc('0x2a')](_0x46e73a);}return null;};}function patchUpdates(_0x56e18a){return function(_0x233522){try{jsonpatch[_0x10dc('0x30')](_0x233522,_0x56e18a,!![]);}catch(_0x200b01){return BPromise[_0x10dc('0x31')](_0x200b01);}return _0x233522['save']();};}function saveUpdates(_0x26d877,_0x1086db){return function(_0x161636){if(_0x161636){return _0x161636[_0x10dc('0x32')](_0x26d877)['then'](function(_0xa3489e){return _0xa3489e;});}return null;};}function removeEntity(_0x274ee9,_0x13f8a1){return function(_0x54fecf){if(_0x54fecf){return _0x54fecf[_0x10dc('0x33')]()[_0x10dc('0x34')](function(){_0x274ee9[_0x10dc('0x28')](0xcc)[_0x10dc('0x29')]();});}};}function handleEntityNotFound(_0x529667,_0x5398a5){return function(_0x4ca2d4){if(!_0x4ca2d4){_0x529667[_0x10dc('0x27')](0x194);}return _0x4ca2d4;};}function handleError(_0x361acc,_0x12af26){_0x12af26=_0x12af26||0x1f4;return function(_0x4a7186){logger['error'](_0x4a7186[_0x10dc('0x35')]);if(_0x4a7186[_0x10dc('0x36')]){delete _0x4a7186[_0x10dc('0x36')];}_0x361acc[_0x10dc('0x28')](_0x12af26)[_0x10dc('0x37')](_0x4a7186);};}exports[_0x10dc('0x38')]=function(_0x4fe87c,_0x43a9bc){var _0x393f60={},_0x854b38={},_0x3116ad={'count':0x0,'rows':[]};var _0x332c56=_[_0x10dc('0x39')](db['SugarcrmConfiguration'][_0x10dc('0x3a')],function(_0x272534){return{'name':_0x272534['fieldName'],'type':_0x272534[_0x10dc('0x3b')][_0x10dc('0x3c')]};});_0x854b38[_0x10dc('0x3d')]=_[_0x10dc('0x39')](_0x332c56,_0x10dc('0x36'));_0x854b38[_0x10dc('0x3e')]=_[_0x10dc('0x3f')](_0x4fe87c['query']);_0x854b38[_0x10dc('0x40')]=_[_0x10dc('0x41')](_0x854b38['model'],_0x854b38[_0x10dc('0x3e')]);_0x393f60[_0x10dc('0x42')]=_[_0x10dc('0x41')](_0x854b38['model'],qs[_0x10dc('0x43')](_0x4fe87c[_0x10dc('0x3e')][_0x10dc('0x43')]));_0x393f60[_0x10dc('0x42')]=_0x393f60['attributes'][_0x10dc('0x44')]?_0x393f60[_0x10dc('0x42')]:_0x854b38['model'];if(!_0x4fe87c[_0x10dc('0x3e')]['hasOwnProperty']('nolimit')){_0x393f60[_0x10dc('0x2d')]=qs[_0x10dc('0x2d')](_0x4fe87c[_0x10dc('0x3e')][_0x10dc('0x2d')]);_0x393f60['offset']=qs['offset'](_0x4fe87c[_0x10dc('0x3e')][_0x10dc('0x2c')]);}_0x393f60['order']=qs[_0x10dc('0x45')](_0x4fe87c['query'][_0x10dc('0x45')]);_0x393f60[_0x10dc('0x46')]=qs['filters'](_['pick'](_0x4fe87c['query'],_0x854b38[_0x10dc('0x40')]));if(_0x4fe87c[_0x10dc('0x3e')][_0x10dc('0x47')]){_0x393f60[_0x10dc('0x46')]=_['merge'](_0x393f60[_0x10dc('0x46')],{'$or':_['map'](_0x332c56,function(_0xcd68e1){if(_0xcd68e1[_0x10dc('0x3b')]!==_0x10dc('0x48')){var _0x24c891={};_0x24c891[_0xcd68e1[_0x10dc('0x36')]]={'$like':'%'+_0x4fe87c[_0x10dc('0x3e')][_0x10dc('0x47')]+'%'};return _0x24c891;}})});}_0x393f60=_[_0x10dc('0x49')]({},_0x393f60,_0x4fe87c[_0x10dc('0x4a')]);var _0x5b9df8={'where':_0x393f60[_0x10dc('0x46')]};return db['SugarcrmConfiguration'][_0x10dc('0x2b')](_0x5b9df8)['then'](function(_0x5b56ec){_0x3116ad['count']=_0x5b56ec;if(_0x4fe87c[_0x10dc('0x3e')][_0x10dc('0x4b')]){_0x393f60[_0x10dc('0x4c')]=[{'all':!![]}];}return db['SugarcrmConfiguration'][_0x10dc('0x4d')](_0x393f60);})[_0x10dc('0x34')](function(_0x6b8e8d){_0x3116ad[_0x10dc('0x4e')]=_0x6b8e8d;return _0x3116ad;})[_0x10dc('0x34')](respondWithFilteredResult(_0x43a9bc,_0x393f60))[_0x10dc('0x4f')](handleError(_0x43a9bc,null));};exports[_0x10dc('0x50')]=function(_0x270325,_0x5a06ff){var _0x414e8a={'raw':![],'where':{'id':_0x270325[_0x10dc('0x51')]['id']}},_0xdb2eda={};_0xdb2eda[_0x10dc('0x3d')]=_[_0x10dc('0x3f')](db['SugarcrmConfiguration'][_0x10dc('0x3a')]);_0xdb2eda[_0x10dc('0x3e')]=_[_0x10dc('0x3f')](_0x270325['query']);_0xdb2eda['filters']=_['intersection'](_0xdb2eda[_0x10dc('0x3d')],_0xdb2eda['query']);_0x414e8a[_0x10dc('0x42')]=_[_0x10dc('0x41')](_0xdb2eda['model'],qs['fields'](_0x270325[_0x10dc('0x3e')][_0x10dc('0x43')]));_0x414e8a[_0x10dc('0x42')]=_0x414e8a[_0x10dc('0x42')][_0x10dc('0x44')]?_0x414e8a[_0x10dc('0x42')]:_0xdb2eda['model'];if(_0x270325[_0x10dc('0x3e')][_0x10dc('0x4b')]){_0x414e8a[_0x10dc('0x4c')]=[{'all':!![]}];}_0x414e8a=_[_0x10dc('0x49')]({},_0x414e8a,_0x270325[_0x10dc('0x4a')]);return db['SugarcrmConfiguration'][_0x10dc('0x52')](_0x414e8a)['then'](handleEntityNotFound(_0x5a06ff,null))[_0x10dc('0x34')](respondWithResult(_0x5a06ff,null))[_0x10dc('0x4f')](handleError(_0x5a06ff,null));};exports[_0x10dc('0x53')]=function(_0x1afde0,_0x3786bd){return db[_0x10dc('0x54')][_0x10dc('0x53')](_0x1afde0[_0x10dc('0x55')],{})[_0x10dc('0x34')](respondWithResult(_0x3786bd,0xc9))[_0x10dc('0x4f')](handleError(_0x3786bd,null));};exports[_0x10dc('0x32')]=function(_0x28c686,_0x3b0d89){if(_0x28c686[_0x10dc('0x55')]['id']){delete _0x28c686[_0x10dc('0x55')]['id'];}return db[_0x10dc('0x54')][_0x10dc('0x52')]({'where':{'id':_0x28c686[_0x10dc('0x51')]['id']}})[_0x10dc('0x34')](handleEntityNotFound(_0x3b0d89,null))[_0x10dc('0x34')](saveUpdates(_0x28c686[_0x10dc('0x55')],null))[_0x10dc('0x34')](respondWithResult(_0x3b0d89,null))['catch'](handleError(_0x3b0d89,null));};exports[_0x10dc('0x33')]=function(_0x57640d,_0x478f52){return db[_0x10dc('0x54')][_0x10dc('0x52')]({'where':{'id':_0x57640d[_0x10dc('0x51')]['id']}})[_0x10dc('0x34')](handleEntityNotFound(_0x478f52,null))[_0x10dc('0x34')](removeEntity(_0x478f52,null))[_0x10dc('0x4f')](handleError(_0x478f52,null));};exports[_0x10dc('0x56')]=function(_0x1ce417,_0x253a93,_0x12a520){var _0x214b81={};var _0xf32c73={};var _0x26d0d4;var _0x170ca1;return db[_0x10dc('0x54')][_0x10dc('0x57')]({'where':{'id':_0x1ce417['params']['id']}})[_0x10dc('0x34')](handleEntityNotFound(_0x253a93,null))[_0x10dc('0x34')](function(_0x15e428){if(_0x15e428){_0x26d0d4=_0x15e428;_0xf32c73[_0x10dc('0x3d')]=_['keys'](db[_0x10dc('0x58')][_0x10dc('0x3a')]);_0xf32c73['query']=_['keys'](_0x1ce417[_0x10dc('0x3e')]);_0xf32c73[_0x10dc('0x40')]=_['intersection'](_0xf32c73[_0x10dc('0x3d')],_0xf32c73[_0x10dc('0x3e')]);_0x214b81[_0x10dc('0x42')]=_[_0x10dc('0x41')](_0xf32c73[_0x10dc('0x3d')],qs[_0x10dc('0x43')](_0x1ce417[_0x10dc('0x3e')][_0x10dc('0x43')]));_0x214b81[_0x10dc('0x42')]=_0x214b81[_0x10dc('0x42')][_0x10dc('0x44')]?_0x214b81[_0x10dc('0x42')]:_0xf32c73['model'];_0x214b81[_0x10dc('0x59')]=qs[_0x10dc('0x45')](_0x1ce417[_0x10dc('0x3e')][_0x10dc('0x45')]);_0x214b81['where']=qs['filters'](_[_0x10dc('0x5a')](_0x1ce417[_0x10dc('0x3e')],_0xf32c73['filters']));if(_0x1ce417[_0x10dc('0x3e')][_0x10dc('0x47')]){_0x214b81[_0x10dc('0x46')]=_['merge'](_0x214b81[_0x10dc('0x46')],{'$or':_[_0x10dc('0x39')](_0x214b81[_0x10dc('0x42')],function(_0x575586){var _0x5b49a1={};_0x5b49a1[_0x575586]={'$like':'%'+_0x1ce417['query'][_0x10dc('0x47')]+'%'};return _0x5b49a1;})});}_0x214b81=_[_0x10dc('0x49')]({},_0x214b81,_0x1ce417[_0x10dc('0x4a')]);return _0x26d0d4[_0x10dc('0x56')](_0x214b81);}})[_0x10dc('0x34')](function(_0x56d1e5){if(_0x56d1e5){_0x170ca1=_0x56d1e5[_0x10dc('0x44')];if(!_0x1ce417[_0x10dc('0x3e')]['hasOwnProperty'](_0x10dc('0x5b'))){_0x214b81['limit']=qs['limit'](_0x1ce417[_0x10dc('0x3e')][_0x10dc('0x2d')]);_0x214b81[_0x10dc('0x2c')]=qs['offset'](_0x1ce417[_0x10dc('0x3e')][_0x10dc('0x2c')]);}return _0x26d0d4[_0x10dc('0x56')](_0x214b81);}})['then'](function(_0x40c75c){if(_0x40c75c){return _0x40c75c?{'count':_0x170ca1,'rows':_0x40c75c}:null;}})[_0x10dc('0x34')](respondWithResult(_0x253a93,null))['catch'](handleError(_0x253a93,null));};exports['getSubjects']=function(_0x3b8db6,_0xf57401,_0x3dc16e){var _0xa19540={};var _0x5a6709={};var _0x13c219;var _0x3f0217;return db[_0x10dc('0x54')][_0x10dc('0x57')]({'where':{'id':_0x3b8db6['params']['id']}})[_0x10dc('0x34')](handleEntityNotFound(_0xf57401,null))['then'](function(_0xfde82b){if(_0xfde82b){_0x13c219=_0xfde82b;_0x5a6709[_0x10dc('0x3d')]=_[_0x10dc('0x3f')](db[_0x10dc('0x58')][_0x10dc('0x3a')]);_0x5a6709[_0x10dc('0x3e')]=_['keys'](_0x3b8db6[_0x10dc('0x3e')]);_0x5a6709['filters']=_['intersection'](_0x5a6709[_0x10dc('0x3d')],_0x5a6709[_0x10dc('0x3e')]);_0xa19540[_0x10dc('0x42')]=_[_0x10dc('0x41')](_0x5a6709['model'],qs[_0x10dc('0x43')](_0x3b8db6['query']['fields']));_0xa19540[_0x10dc('0x42')]=_0xa19540[_0x10dc('0x42')]['length']?_0xa19540[_0x10dc('0x42')]:_0x5a6709['model'];_0xa19540[_0x10dc('0x59')]=qs[_0x10dc('0x45')](_0x3b8db6[_0x10dc('0x3e')][_0x10dc('0x45')]);_0xa19540[_0x10dc('0x46')]=qs[_0x10dc('0x40')](_[_0x10dc('0x5a')](_0x3b8db6[_0x10dc('0x3e')],_0x5a6709[_0x10dc('0x40')]));if(_0x3b8db6[_0x10dc('0x3e')][_0x10dc('0x47')]){_0xa19540[_0x10dc('0x46')]=_[_0x10dc('0x49')](_0xa19540[_0x10dc('0x46')],{'$or':_[_0x10dc('0x39')](_0xa19540[_0x10dc('0x42')],function(_0x6811d4){var _0x1b127a={};_0x1b127a[_0x6811d4]={'$like':'%'+_0x3b8db6[_0x10dc('0x3e')][_0x10dc('0x47')]+'%'};return _0x1b127a;})});}_0xa19540=_[_0x10dc('0x49')]({},_0xa19540,_0x3b8db6['options']);return _0x13c219[_0x10dc('0x5c')](_0xa19540);}})['then'](function(_0x30db36){if(_0x30db36){_0x3f0217=_0x30db36['length'];if(!_0x3b8db6[_0x10dc('0x3e')]['hasOwnProperty']('nolimit')){_0xa19540[_0x10dc('0x2d')]=qs['limit'](_0x3b8db6['query'][_0x10dc('0x2d')]);_0xa19540[_0x10dc('0x2c')]=qs[_0x10dc('0x2c')](_0x3b8db6[_0x10dc('0x3e')][_0x10dc('0x2c')]);}return _0x13c219[_0x10dc('0x5c')](_0xa19540);}})[_0x10dc('0x34')](function(_0x276dd9){if(_0x276dd9){return _0x276dd9?{'count':_0x3f0217,'rows':_0x276dd9}:null;}})[_0x10dc('0x34')](respondWithResult(_0xf57401,null))['catch'](handleError(_0xf57401,null));};exports[_0x10dc('0x5d')]=function(_0x24a1ca,_0x26acd9,_0x2a1637){var _0x2b6e44={};var _0x1b9837={};var _0x245bc8;var _0x36e073;return db['SugarcrmConfiguration'][_0x10dc('0x57')]({'where':{'id':_0x24a1ca[_0x10dc('0x51')]['id']}})[_0x10dc('0x34')](handleEntityNotFound(_0x26acd9,null))[_0x10dc('0x34')](function(_0x5175eb){if(_0x5175eb){_0x245bc8=_0x5175eb;_0x1b9837['model']=_[_0x10dc('0x3f')](db[_0x10dc('0x58')][_0x10dc('0x3a')]);_0x1b9837['query']=_['keys'](_0x24a1ca[_0x10dc('0x3e')]);_0x1b9837[_0x10dc('0x40')]=_['intersection'](_0x1b9837[_0x10dc('0x3d')],_0x1b9837[_0x10dc('0x3e')]);_0x2b6e44[_0x10dc('0x42')]=_['intersection'](_0x1b9837[_0x10dc('0x3d')],qs['fields'](_0x24a1ca[_0x10dc('0x3e')]['fields']));_0x2b6e44[_0x10dc('0x42')]=_0x2b6e44[_0x10dc('0x42')][_0x10dc('0x44')]?_0x2b6e44[_0x10dc('0x42')]:_0x1b9837[_0x10dc('0x3d')];_0x2b6e44[_0x10dc('0x59')]=qs['sort'](_0x24a1ca[_0x10dc('0x3e')][_0x10dc('0x45')]);_0x2b6e44[_0x10dc('0x46')]=qs['filters'](_[_0x10dc('0x5a')](_0x24a1ca[_0x10dc('0x3e')],_0x1b9837[_0x10dc('0x40')]));if(_0x24a1ca[_0x10dc('0x3e')][_0x10dc('0x47')]){_0x2b6e44[_0x10dc('0x46')]=_[_0x10dc('0x49')](_0x2b6e44['where'],{'$or':_[_0x10dc('0x39')](_0x2b6e44[_0x10dc('0x42')],function(_0x922016){var _0x3e0d76={};_0x3e0d76[_0x922016]={'$like':'%'+_0x24a1ca[_0x10dc('0x3e')]['filter']+'%'};return _0x3e0d76;})});}_0x2b6e44=_[_0x10dc('0x49')]({},_0x2b6e44,_0x24a1ca['options']);return _0x245bc8['getDescriptions'](_0x2b6e44);}})[_0x10dc('0x34')](function(_0x19f432){if(_0x19f432){_0x36e073=_0x19f432['length'];if(!_0x24a1ca[_0x10dc('0x3e')][_0x10dc('0x5e')](_0x10dc('0x5b'))){_0x2b6e44[_0x10dc('0x2d')]=qs[_0x10dc('0x2d')](_0x24a1ca[_0x10dc('0x3e')][_0x10dc('0x2d')]);_0x2b6e44['offset']=qs[_0x10dc('0x2c')](_0x24a1ca[_0x10dc('0x3e')][_0x10dc('0x2c')]);}return _0x245bc8['getDescriptions'](_0x2b6e44);}})[_0x10dc('0x34')](function(_0x1df70f){if(_0x1df70f){return _0x1df70f?{'count':_0x36e073,'rows':_0x1df70f}:null;}})[_0x10dc('0x34')](respondWithResult(_0x26acd9,null))['catch'](handleError(_0x26acd9,null));};
\ No newline at end of file
+var _0x6bb1=['getDescriptions','rimraf','zip-dir','fast-json-patch','mustache','sox','to-csv','ejs','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','json','undefined','offset','count','limit','status','set','Content-Range','apply','save','then','destroy','error','stack','name','send','index','map','SugarcrmConfiguration','rawAttributes','fieldName','type','model','keys','filters','intersection','query','attributes','length','hasOwnProperty','order','sort','where','filter','VIRTUAL','merge','options','includeAll','include','findAll','rows','catch','show','fields','find','create','body','params','getFields','findOne','SugarcrmField','pick','nolimit','getSubjects'];(function(_0x187ee1,_0x3fd1e6){var _0x388160=function(_0x542dd2){while(--_0x542dd2){_0x187ee1['push'](_0x187ee1['shift']());}};_0x388160(++_0x3fd1e6);}(_0x6bb1,0x1cf));var _0x16bb=function(_0x3bf80d,_0x2650df){_0x3bf80d=_0x3bf80d-0x0;var _0x505f21=_0x6bb1[_0x3bf80d];return _0x505f21;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x16bb('0x0'));var zipdir=require(_0x16bb('0x1'));var jsonpatch=require(_0x16bb('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x16bb('0x3'));var util=require('util');var path=require('path');var sox=require(_0x16bb('0x4'));var csv=require(_0x16bb('0x5'));var ejs=require(_0x16bb('0x6'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require('squel');var crypto=require(_0x16bb('0x7'));var jsforce=require(_0x16bb('0x8'));var deskjs=require(_0x16bb('0x9'));var toCsv=require(_0x16bb('0x5'));var querystring=require(_0x16bb('0xa'));var Papa=require(_0x16bb('0xb'));var Redis=require('ioredis');var authService=require(_0x16bb('0xc'));var qs=require(_0x16bb('0xd'));var as=require(_0x16bb('0xe'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x16bb('0xf'))('api');var utils=require(_0x16bb('0x10'));var config=require(_0x16bb('0x11'));var licenseUtil=require(_0x16bb('0x12'));var db=require(_0x16bb('0x13'))['db'];function respondWithStatusCode(_0x461c2e,_0x5c5763){_0x5c5763=_0x5c5763||0xcc;return function(_0x20fef8){if(_0x20fef8){return _0x461c2e[_0x16bb('0x14')](_0x5c5763);}return _0x461c2e['status'](_0x5c5763)[_0x16bb('0x15')]();};}function respondWithResult(_0x34d0a5,_0x1c3e6b){_0x1c3e6b=_0x1c3e6b||0xc8;return function(_0x231d61){if(_0x231d61){return _0x34d0a5['status'](_0x1c3e6b)[_0x16bb('0x16')](_0x231d61);}};}function respondWithFilteredResult(_0x2c2f45,_0x3160d2){return function(_0x16d8d8){if(_0x16d8d8){var _0xeba497=typeof _0x3160d2['offset']===_0x16bb('0x17')&&typeof _0x3160d2['limit']===_0x16bb('0x17');var _0x14bba5=_0x16d8d8['count'];var _0x34d25b=_0xeba497?0x0:_0x3160d2[_0x16bb('0x18')];var _0x4385c2=_0xeba497?_0x16d8d8[_0x16bb('0x19')]:_0x3160d2['offset']+_0x3160d2[_0x16bb('0x1a')];var _0x53bd98;if(_0x4385c2>=_0x14bba5){_0x4385c2=_0x14bba5;_0x53bd98=0xc8;}else{_0x53bd98=0xce;}_0x2c2f45[_0x16bb('0x1b')](_0x53bd98);return _0x2c2f45[_0x16bb('0x1c')](_0x16bb('0x1d'),_0x34d25b+'-'+_0x4385c2+'/'+_0x14bba5)[_0x16bb('0x16')](_0x16d8d8);}return null;};}function patchUpdates(_0x505ab2){return function(_0x3c4a07){try{jsonpatch[_0x16bb('0x1e')](_0x3c4a07,_0x505ab2,!![]);}catch(_0x3affe0){return BPromise['reject'](_0x3affe0);}return _0x3c4a07[_0x16bb('0x1f')]();};}function saveUpdates(_0x1c80a2,_0x39a881){return function(_0x4145a2){if(_0x4145a2){return _0x4145a2['update'](_0x1c80a2)[_0x16bb('0x20')](function(_0x2fb83c){return _0x2fb83c;});}return null;};}function removeEntity(_0x2c5ad6,_0x3717cc){return function(_0x46d7c8){if(_0x46d7c8){return _0x46d7c8[_0x16bb('0x21')]()[_0x16bb('0x20')](function(){_0x2c5ad6[_0x16bb('0x1b')](0xcc)[_0x16bb('0x15')]();});}};}function handleEntityNotFound(_0x14d6cb,_0x517a28){return function(_0x5b2b08){if(!_0x5b2b08){_0x14d6cb[_0x16bb('0x14')](0x194);}return _0x5b2b08;};}function handleError(_0x12f436,_0x534ac7){_0x534ac7=_0x534ac7||0x1f4;return function(_0x15dfc5){logger[_0x16bb('0x22')](_0x15dfc5[_0x16bb('0x23')]);if(_0x15dfc5[_0x16bb('0x24')]){delete _0x15dfc5[_0x16bb('0x24')];}_0x12f436[_0x16bb('0x1b')](_0x534ac7)[_0x16bb('0x25')](_0x15dfc5);};}exports[_0x16bb('0x26')]=function(_0x56a155,_0x21307b){var _0x10d324={},_0x25ca6f={},_0x554f7c={'count':0x0,'rows':[]};var _0x25a731=_[_0x16bb('0x27')](db[_0x16bb('0x28')][_0x16bb('0x29')],function(_0x1fe89f){return{'name':_0x1fe89f[_0x16bb('0x2a')],'type':_0x1fe89f[_0x16bb('0x2b')]['key']};});_0x25ca6f[_0x16bb('0x2c')]=_[_0x16bb('0x27')](_0x25a731,_0x16bb('0x24'));_0x25ca6f['query']=_[_0x16bb('0x2d')](_0x56a155['query']);_0x25ca6f[_0x16bb('0x2e')]=_[_0x16bb('0x2f')](_0x25ca6f[_0x16bb('0x2c')],_0x25ca6f[_0x16bb('0x30')]);_0x10d324[_0x16bb('0x31')]=_['intersection'](_0x25ca6f[_0x16bb('0x2c')],qs['fields'](_0x56a155['query']['fields']));_0x10d324[_0x16bb('0x31')]=_0x10d324[_0x16bb('0x31')][_0x16bb('0x32')]?_0x10d324[_0x16bb('0x31')]:_0x25ca6f[_0x16bb('0x2c')];if(!_0x56a155[_0x16bb('0x30')][_0x16bb('0x33')]('nolimit')){_0x10d324[_0x16bb('0x1a')]=qs[_0x16bb('0x1a')](_0x56a155[_0x16bb('0x30')][_0x16bb('0x1a')]);_0x10d324['offset']=qs[_0x16bb('0x18')](_0x56a155['query'][_0x16bb('0x18')]);}_0x10d324[_0x16bb('0x34')]=qs[_0x16bb('0x35')](_0x56a155[_0x16bb('0x30')][_0x16bb('0x35')]);_0x10d324[_0x16bb('0x36')]=qs[_0x16bb('0x2e')](_['pick'](_0x56a155[_0x16bb('0x30')],_0x25ca6f[_0x16bb('0x2e')]),_0x25a731);if(_0x56a155[_0x16bb('0x30')][_0x16bb('0x37')]){_0x10d324[_0x16bb('0x36')]=_['merge'](_0x10d324['where'],{'$or':_[_0x16bb('0x27')](_0x25a731,function(_0x4c5ccb){if(_0x4c5ccb[_0x16bb('0x2b')]!==_0x16bb('0x38')){var _0x2c5d1a={};_0x2c5d1a[_0x4c5ccb[_0x16bb('0x24')]]={'$like':'%'+_0x56a155[_0x16bb('0x30')]['filter']+'%'};return _0x2c5d1a;}})});}_0x10d324=_[_0x16bb('0x39')]({},_0x10d324,_0x56a155[_0x16bb('0x3a')]);var _0x5a164c={'where':_0x10d324['where']};return db[_0x16bb('0x28')]['count'](_0x5a164c)[_0x16bb('0x20')](function(_0x62e3f0){_0x554f7c[_0x16bb('0x19')]=_0x62e3f0;if(_0x56a155['query'][_0x16bb('0x3b')]){_0x10d324[_0x16bb('0x3c')]=[{'all':!![]}];}return db[_0x16bb('0x28')][_0x16bb('0x3d')](_0x10d324);})[_0x16bb('0x20')](function(_0x28ef2f){_0x554f7c[_0x16bb('0x3e')]=_0x28ef2f;return _0x554f7c;})[_0x16bb('0x20')](respondWithFilteredResult(_0x21307b,_0x10d324))[_0x16bb('0x3f')](handleError(_0x21307b,null));};exports[_0x16bb('0x40')]=function(_0x4cd7d6,_0x30332c){var _0x517bed={'raw':![],'where':{'id':_0x4cd7d6['params']['id']}},_0x387a79={};_0x387a79[_0x16bb('0x2c')]=_[_0x16bb('0x2d')](db[_0x16bb('0x28')]['rawAttributes']);_0x387a79[_0x16bb('0x30')]=_[_0x16bb('0x2d')](_0x4cd7d6[_0x16bb('0x30')]);_0x387a79[_0x16bb('0x2e')]=_[_0x16bb('0x2f')](_0x387a79[_0x16bb('0x2c')],_0x387a79[_0x16bb('0x30')]);_0x517bed[_0x16bb('0x31')]=_['intersection'](_0x387a79[_0x16bb('0x2c')],qs[_0x16bb('0x41')](_0x4cd7d6[_0x16bb('0x30')][_0x16bb('0x41')]));_0x517bed[_0x16bb('0x31')]=_0x517bed[_0x16bb('0x31')][_0x16bb('0x32')]?_0x517bed['attributes']:_0x387a79[_0x16bb('0x2c')];if(_0x4cd7d6[_0x16bb('0x30')][_0x16bb('0x3b')]){_0x517bed[_0x16bb('0x3c')]=[{'all':!![]}];}_0x517bed=_[_0x16bb('0x39')]({},_0x517bed,_0x4cd7d6[_0x16bb('0x3a')]);return db['SugarcrmConfiguration'][_0x16bb('0x42')](_0x517bed)['then'](handleEntityNotFound(_0x30332c,null))[_0x16bb('0x20')](respondWithResult(_0x30332c,null))[_0x16bb('0x3f')](handleError(_0x30332c,null));};exports['create']=function(_0x10e66e,_0x7eb48e){return db[_0x16bb('0x28')][_0x16bb('0x43')](_0x10e66e[_0x16bb('0x44')],{})[_0x16bb('0x20')](respondWithResult(_0x7eb48e,0xc9))[_0x16bb('0x3f')](handleError(_0x7eb48e,null));};exports['update']=function(_0xd4985,_0x400933){if(_0xd4985[_0x16bb('0x44')]['id']){delete _0xd4985['body']['id'];}return db[_0x16bb('0x28')][_0x16bb('0x42')]({'where':{'id':_0xd4985[_0x16bb('0x45')]['id']}})[_0x16bb('0x20')](handleEntityNotFound(_0x400933,null))['then'](saveUpdates(_0xd4985[_0x16bb('0x44')],null))[_0x16bb('0x20')](respondWithResult(_0x400933,null))[_0x16bb('0x3f')](handleError(_0x400933,null));};exports[_0x16bb('0x21')]=function(_0x4eb48f,_0x136de1){return db[_0x16bb('0x28')][_0x16bb('0x42')]({'where':{'id':_0x4eb48f['params']['id']}})[_0x16bb('0x20')](handleEntityNotFound(_0x136de1,null))[_0x16bb('0x20')](removeEntity(_0x136de1,null))[_0x16bb('0x3f')](handleError(_0x136de1,null));};exports[_0x16bb('0x46')]=function(_0x269ae3,_0x38b131,_0x37ead1){var _0x17ed8a={};var _0x224ef5={};var _0x4eede6;var _0x5abef4;return db[_0x16bb('0x28')][_0x16bb('0x47')]({'where':{'id':_0x269ae3['params']['id']}})['then'](handleEntityNotFound(_0x38b131,null))['then'](function(_0x1ea100){if(_0x1ea100){_0x4eede6=_0x1ea100;_0x224ef5[_0x16bb('0x2c')]=_[_0x16bb('0x2d')](db[_0x16bb('0x48')][_0x16bb('0x29')]);_0x224ef5[_0x16bb('0x30')]=_[_0x16bb('0x2d')](_0x269ae3[_0x16bb('0x30')]);_0x224ef5[_0x16bb('0x2e')]=_[_0x16bb('0x2f')](_0x224ef5[_0x16bb('0x2c')],_0x224ef5[_0x16bb('0x30')]);_0x17ed8a['attributes']=_[_0x16bb('0x2f')](_0x224ef5[_0x16bb('0x2c')],qs[_0x16bb('0x41')](_0x269ae3[_0x16bb('0x30')][_0x16bb('0x41')]));_0x17ed8a[_0x16bb('0x31')]=_0x17ed8a['attributes'][_0x16bb('0x32')]?_0x17ed8a[_0x16bb('0x31')]:_0x224ef5[_0x16bb('0x2c')];_0x17ed8a[_0x16bb('0x34')]=qs['sort'](_0x269ae3['query'][_0x16bb('0x35')]);_0x17ed8a[_0x16bb('0x36')]=qs[_0x16bb('0x2e')](_[_0x16bb('0x49')](_0x269ae3[_0x16bb('0x30')],_0x224ef5[_0x16bb('0x2e')]));if(_0x269ae3[_0x16bb('0x30')][_0x16bb('0x37')]){_0x17ed8a[_0x16bb('0x36')]=_[_0x16bb('0x39')](_0x17ed8a[_0x16bb('0x36')],{'$or':_['map'](_0x17ed8a[_0x16bb('0x31')],function(_0x428868){var _0x591663={};_0x591663[_0x428868]={'$like':'%'+_0x269ae3[_0x16bb('0x30')]['filter']+'%'};return _0x591663;})});}_0x17ed8a=_[_0x16bb('0x39')]({},_0x17ed8a,_0x269ae3[_0x16bb('0x3a')]);return _0x4eede6['getFields'](_0x17ed8a);}})[_0x16bb('0x20')](function(_0x720210){if(_0x720210){_0x5abef4=_0x720210['length'];if(!_0x269ae3[_0x16bb('0x30')]['hasOwnProperty'](_0x16bb('0x4a'))){_0x17ed8a[_0x16bb('0x1a')]=qs[_0x16bb('0x1a')](_0x269ae3[_0x16bb('0x30')][_0x16bb('0x1a')]);_0x17ed8a[_0x16bb('0x18')]=qs[_0x16bb('0x18')](_0x269ae3[_0x16bb('0x30')][_0x16bb('0x18')]);}return _0x4eede6[_0x16bb('0x46')](_0x17ed8a);}})[_0x16bb('0x20')](function(_0x1e1fb1){if(_0x1e1fb1){return _0x1e1fb1?{'count':_0x5abef4,'rows':_0x1e1fb1}:null;}})['then'](respondWithResult(_0x38b131,null))[_0x16bb('0x3f')](handleError(_0x38b131,null));};exports['getSubjects']=function(_0xcd21dc,_0x2b4062,_0x47387a){var _0x5a5fdd={};var _0x43cec={};var _0x27a378;var _0x466d37;return db[_0x16bb('0x28')][_0x16bb('0x47')]({'where':{'id':_0xcd21dc[_0x16bb('0x45')]['id']}})[_0x16bb('0x20')](handleEntityNotFound(_0x2b4062,null))[_0x16bb('0x20')](function(_0x573bf){if(_0x573bf){_0x27a378=_0x573bf;_0x43cec[_0x16bb('0x2c')]=_['keys'](db[_0x16bb('0x48')]['rawAttributes']);_0x43cec['query']=_['keys'](_0xcd21dc[_0x16bb('0x30')]);_0x43cec[_0x16bb('0x2e')]=_[_0x16bb('0x2f')](_0x43cec['model'],_0x43cec[_0x16bb('0x30')]);_0x5a5fdd[_0x16bb('0x31')]=_[_0x16bb('0x2f')](_0x43cec[_0x16bb('0x2c')],qs[_0x16bb('0x41')](_0xcd21dc['query'][_0x16bb('0x41')]));_0x5a5fdd[_0x16bb('0x31')]=_0x5a5fdd[_0x16bb('0x31')][_0x16bb('0x32')]?_0x5a5fdd[_0x16bb('0x31')]:_0x43cec[_0x16bb('0x2c')];_0x5a5fdd[_0x16bb('0x34')]=qs['sort'](_0xcd21dc['query'][_0x16bb('0x35')]);_0x5a5fdd['where']=qs[_0x16bb('0x2e')](_['pick'](_0xcd21dc['query'],_0x43cec['filters']));if(_0xcd21dc[_0x16bb('0x30')]['filter']){_0x5a5fdd[_0x16bb('0x36')]=_[_0x16bb('0x39')](_0x5a5fdd[_0x16bb('0x36')],{'$or':_[_0x16bb('0x27')](_0x5a5fdd[_0x16bb('0x31')],function(_0x5d626){var _0x24e521={};_0x24e521[_0x5d626]={'$like':'%'+_0xcd21dc[_0x16bb('0x30')]['filter']+'%'};return _0x24e521;})});}_0x5a5fdd=_[_0x16bb('0x39')]({},_0x5a5fdd,_0xcd21dc['options']);return _0x27a378['getSubjects'](_0x5a5fdd);}})[_0x16bb('0x20')](function(_0x499a43){if(_0x499a43){_0x466d37=_0x499a43[_0x16bb('0x32')];if(!_0xcd21dc[_0x16bb('0x30')][_0x16bb('0x33')](_0x16bb('0x4a'))){_0x5a5fdd[_0x16bb('0x1a')]=qs[_0x16bb('0x1a')](_0xcd21dc['query']['limit']);_0x5a5fdd['offset']=qs['offset'](_0xcd21dc['query'][_0x16bb('0x18')]);}return _0x27a378[_0x16bb('0x4b')](_0x5a5fdd);}})['then'](function(_0x3702d7){if(_0x3702d7){return _0x3702d7?{'count':_0x466d37,'rows':_0x3702d7}:null;}})[_0x16bb('0x20')](respondWithResult(_0x2b4062,null))[_0x16bb('0x3f')](handleError(_0x2b4062,null));};exports[_0x16bb('0x4c')]=function(_0x3ee984,_0x1a7013,_0x5c401e){var _0xf80464={};var _0x1d6d06={};var _0xd77c89;var _0x3d38b9;return db[_0x16bb('0x28')][_0x16bb('0x47')]({'where':{'id':_0x3ee984[_0x16bb('0x45')]['id']}})[_0x16bb('0x20')](handleEntityNotFound(_0x1a7013,null))[_0x16bb('0x20')](function(_0xa8e26b){if(_0xa8e26b){_0xd77c89=_0xa8e26b;_0x1d6d06[_0x16bb('0x2c')]=_['keys'](db[_0x16bb('0x48')][_0x16bb('0x29')]);_0x1d6d06[_0x16bb('0x30')]=_['keys'](_0x3ee984[_0x16bb('0x30')]);_0x1d6d06[_0x16bb('0x2e')]=_['intersection'](_0x1d6d06['model'],_0x1d6d06[_0x16bb('0x30')]);_0xf80464[_0x16bb('0x31')]=_[_0x16bb('0x2f')](_0x1d6d06['model'],qs[_0x16bb('0x41')](_0x3ee984[_0x16bb('0x30')][_0x16bb('0x41')]));_0xf80464[_0x16bb('0x31')]=_0xf80464[_0x16bb('0x31')][_0x16bb('0x32')]?_0xf80464[_0x16bb('0x31')]:_0x1d6d06[_0x16bb('0x2c')];_0xf80464['order']=qs[_0x16bb('0x35')](_0x3ee984[_0x16bb('0x30')]['sort']);_0xf80464[_0x16bb('0x36')]=qs['filters'](_[_0x16bb('0x49')](_0x3ee984['query'],_0x1d6d06['filters']));if(_0x3ee984['query'][_0x16bb('0x37')]){_0xf80464[_0x16bb('0x36')]=_[_0x16bb('0x39')](_0xf80464[_0x16bb('0x36')],{'$or':_[_0x16bb('0x27')](_0xf80464[_0x16bb('0x31')],function(_0x4ad651){var _0x527392={};_0x527392[_0x4ad651]={'$like':'%'+_0x3ee984[_0x16bb('0x30')][_0x16bb('0x37')]+'%'};return _0x527392;})});}_0xf80464=_[_0x16bb('0x39')]({},_0xf80464,_0x3ee984['options']);return _0xd77c89[_0x16bb('0x4c')](_0xf80464);}})['then'](function(_0x4a8674){if(_0x4a8674){_0x3d38b9=_0x4a8674[_0x16bb('0x32')];if(!_0x3ee984[_0x16bb('0x30')][_0x16bb('0x33')](_0x16bb('0x4a'))){_0xf80464[_0x16bb('0x1a')]=qs[_0x16bb('0x1a')](_0x3ee984[_0x16bb('0x30')][_0x16bb('0x1a')]);_0xf80464[_0x16bb('0x18')]=qs[_0x16bb('0x18')](_0x3ee984[_0x16bb('0x30')]['offset']);}return _0xd77c89[_0x16bb('0x4c')](_0xf80464);}})[_0x16bb('0x20')](function(_0x1b7cdf){if(_0x1b7cdf){return _0x1b7cdf?{'count':_0x3d38b9,'rows':_0x1b7cdf}:null;}})['then'](respondWithResult(_0x1a7013,null))[_0x16bb('0x3f')](handleError(_0x1a7013,null));};
\ No newline at end of file