// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xf206=['querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','jayson/promise','http','test','Sequelize','ValidationError','The\x20password\x20must\x20be\x20at\x20least\x208\x20characters\x20long\x20and\x20have\x201\x20lowercase\x20character,\x201\x20uppercase\x20character,\x201\x20number\x20and\x201\x20special\x20character\x20~!@#$%^&-_=+[{]}.','request','info','SugarcrmConfiguration,\x20%s,\x20%s','request\x20sent','debug','SugarcrmConfiguration,\x20%s,\x20%s,\x20%s','error','code','message','catch','sendStatus','status','end','json','offset','limit','set','Content-Range','apply','reject','update','then','destroy','stack','name','send','index','map','SugarcrmConfiguration','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','sort','where','pick','filter','merge','options','count','includeAll','findAll','rows','show','params','rawAttributes','find','create','body','findOne','order','nolimit','getFields','getSubjects','getDescriptions','html-pdf','eml-format','rimraf','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto'];(function(_0x502c7d,_0x2f1285){var _0x30b7ed=function(_0x2d92f3){while(--_0x2d92f3){_0x502c7d['push'](_0x502c7d['shift']());}};_0x30b7ed(++_0x2f1285);}(_0xf206,0x16d));var _0x6f20=function(_0x2984f5,_0x555e2d){_0x2984f5=_0x2984f5-0x0;var _0x334159=_0xf206[_0x2984f5];return _0x334159;};'use strict';var pdf=require(_0x6f20('0x0'));var emlformat=require(_0x6f20('0x1'));var rimraf=require(_0x6f20('0x2'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x6f20('0x3'));var moment=require(_0x6f20('0x4'));var BPromise=require(_0x6f20('0x5'));var Mustache=require(_0x6f20('0x6'));var util=require(_0x6f20('0x7'));var path=require(_0x6f20('0x8'));var sox=require(_0x6f20('0x9'));var csv=require(_0x6f20('0xa'));var ejs=require(_0x6f20('0xb'));var fs=require('fs');var _=require(_0x6f20('0xc'));var squel=require(_0x6f20('0xd'));var crypto=require(_0x6f20('0xe'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x6f20('0xa'));var querystring=require(_0x6f20('0xf'));var Papa=require(_0x6f20('0x10'));var Redis=require(_0x6f20('0x11'));var authService=require(_0x6f20('0x12'));var qs=require(_0x6f20('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x6f20('0x14'));var logger=require(_0x6f20('0x15'))(_0x6f20('0x16'));var utils=require(_0x6f20('0x17'));var config=require(_0x6f20('0x18'));var db=require(_0x6f20('0x19'))['db'];var jayson=require(_0x6f20('0x1a'));var client=jayson['client'][_0x6f20('0x1b')]({'port':0x232a});function checkPasswordPattern(_0x192c67,_0xe278c6,_0x31a7bd){if(_0x31a7bd){var _0x5c6e5d=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x5c6e5d[_0x6f20('0x1c')](_0xe278c6)){return _0x192c67;}else{throw new db[(_0x6f20('0x1d'))][(_0x6f20('0x1e'))](_0x6f20('0x1f'));}}else{return _0x192c67;}}function respondWithRpcPromise(_0x9044f3,_0x4a2655,_0x5d783f,_0x308e93){return new BPromise(function(_0x352e84,_0x2697a3){var _0x4c1d01=_0x308e93||client;return _0x4c1d01[_0x6f20('0x20')](_0x9044f3,_0x5d783f)['then'](function(_0x268ad7){logger[_0x6f20('0x21')](_0x6f20('0x22'),_0x4a2655,_0x6f20('0x23'));logger[_0x6f20('0x24')](_0x6f20('0x25'),_0x4a2655,_0x6f20('0x23'),JSON['stringify'](_0x268ad7));if(_0x268ad7[_0x6f20('0x26')]){if(_0x268ad7[_0x6f20('0x26')][_0x6f20('0x27')]===0x1f4){logger[_0x6f20('0x26')](_0x6f20('0x22'),_0x4a2655,_0x268ad7[_0x6f20('0x26')]['message']);return _0x2697a3(_0x268ad7[_0x6f20('0x26')][_0x6f20('0x28')]);}logger[_0x6f20('0x26')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x4a2655,_0x268ad7['error']['message']);return _0x352e84(_0x268ad7['error'][_0x6f20('0x28')]);}else{logger[_0x6f20('0x21')](_0x6f20('0x22'),_0x4a2655,'request\x20sent');_0x352e84(_0x268ad7['result'][_0x6f20('0x28')]);}})[_0x6f20('0x29')](function(_0x46e0dc){logger['error'](_0x6f20('0x22'),_0x4a2655,_0x46e0dc);_0x2697a3(_0x46e0dc);});});}function respondWithStatusCode(_0x213045,_0x2be44e){_0x2be44e=_0x2be44e||0xcc;return function(_0xd699ef){if(_0xd699ef){return _0x213045[_0x6f20('0x2a')](_0x2be44e);}return _0x213045[_0x6f20('0x2b')](_0x2be44e)[_0x6f20('0x2c')]();};}function respondWithResult(_0xb9c139,_0x169f5c){_0x169f5c=_0x169f5c||0xc8;return function(_0x325013){if(_0x325013){return _0xb9c139[_0x6f20('0x2b')](_0x169f5c)[_0x6f20('0x2d')](_0x325013);}};}function respondWithFilteredResult(_0xb8312e,_0xcfb932){return function(_0x3bfd45){if(_0x3bfd45){var _0xdddff1=_0x3bfd45['count'],_0x2b3ce9=_0xcfb932[_0x6f20('0x2e')],_0x1f8a18=_0xcfb932[_0x6f20('0x2e')]+_0xcfb932[_0x6f20('0x2f')],_0x3b2a45;if(_0x1f8a18>=_0xdddff1){_0x1f8a18=_0xdddff1;_0x3b2a45=0xc8;}else{_0x3b2a45=0xce;}_0xb8312e[_0x6f20('0x2b')](_0x3b2a45);return _0xb8312e[_0x6f20('0x30')](_0x6f20('0x31'),_0x2b3ce9+'-'+_0x1f8a18+'/'+_0xdddff1)['json'](_0x3bfd45);}return null;};}function patchUpdates(_0x54b83b){return function(_0xf372a){try{jsonpatch[_0x6f20('0x32')](_0xf372a,_0x54b83b,!![]);}catch(_0x2358de){return BPromise[_0x6f20('0x33')](_0x2358de);}return _0xf372a['save']();};}function saveUpdates(_0x272916,_0x33864f){return function(_0x2f0e33){if(_0x2f0e33){return _0x2f0e33[_0x6f20('0x34')](_0x272916)[_0x6f20('0x35')](function(_0x14bb99){return _0x14bb99;});}return null;};}function removeEntity(_0x457fc8,_0x3550d2){return function(_0x3c1c96){if(_0x3c1c96){return _0x3c1c96[_0x6f20('0x36')]()[_0x6f20('0x35')](function(){_0x457fc8[_0x6f20('0x2b')](0xcc)[_0x6f20('0x2c')]();});}};}function handleEntityNotFound(_0x22a7b2,_0x4263f1){return function(_0x49865d){if(!_0x49865d){_0x22a7b2[_0x6f20('0x2a')](0x194);}return _0x49865d;};}function handleError(_0x59c31b,_0x11f27a){_0x11f27a=_0x11f27a||0x1f4;return function(_0x54ad3b){logger[_0x6f20('0x26')](_0x54ad3b[_0x6f20('0x37')]);if(_0x54ad3b[_0x6f20('0x38')]){delete _0x54ad3b['name'];}_0x59c31b[_0x6f20('0x2b')](_0x11f27a)[_0x6f20('0x39')](_0x54ad3b);};}exports[_0x6f20('0x3a')]=function(_0x3d0a4a,_0x3a8940){var _0x172f97={},_0x47ec18={},_0x6b49b6={'count':0x0,'rows':[]};var _0x49706a=_[_0x6f20('0x3b')](db[_0x6f20('0x3c')]['rawAttributes'],function(_0x347652){return{'name':_0x347652[_0x6f20('0x3d')],'type':_0x347652[_0x6f20('0x3e')][_0x6f20('0x3f')]};});_0x47ec18[_0x6f20('0x40')]=_[_0x6f20('0x3b')](_0x49706a,_0x6f20('0x38'));_0x47ec18[_0x6f20('0x41')]=_[_0x6f20('0x42')](_0x3d0a4a[_0x6f20('0x41')]);_0x47ec18[_0x6f20('0x43')]=_[_0x6f20('0x44')](_0x47ec18[_0x6f20('0x40')],_0x47ec18[_0x6f20('0x41')]);_0x172f97[_0x6f20('0x45')]=_[_0x6f20('0x44')](_0x47ec18[_0x6f20('0x40')],qs[_0x6f20('0x46')](_0x3d0a4a[_0x6f20('0x41')][_0x6f20('0x46')]));_0x172f97[_0x6f20('0x45')]=_0x172f97['attributes'][_0x6f20('0x47')]?_0x172f97['attributes']:_0x47ec18[_0x6f20('0x40')];if(!_0x3d0a4a['query'][_0x6f20('0x48')]('nolimit')){_0x172f97[_0x6f20('0x2f')]=qs[_0x6f20('0x2f')](_0x3d0a4a[_0x6f20('0x41')]['limit']);_0x172f97[_0x6f20('0x2e')]=qs[_0x6f20('0x2e')](_0x3d0a4a[_0x6f20('0x41')][_0x6f20('0x2e')]);}_0x172f97['order']=qs['sort'](_0x3d0a4a[_0x6f20('0x41')][_0x6f20('0x49')]);_0x172f97[_0x6f20('0x4a')]=qs['filters'](_[_0x6f20('0x4b')](_0x3d0a4a[_0x6f20('0x41')],_0x47ec18[_0x6f20('0x43')]));if(_0x3d0a4a[_0x6f20('0x41')][_0x6f20('0x4c')]){_0x172f97[_0x6f20('0x4a')]=_[_0x6f20('0x4d')](_0x172f97[_0x6f20('0x4a')],{'$or':_['map'](_0x49706a,function(_0x47bbe0){if(_0x47bbe0[_0x6f20('0x3e')]!=='VIRTUAL'){var _0x43a8b7={};_0x43a8b7[_0x47bbe0[_0x6f20('0x38')]]={'$like':'%'+_0x3d0a4a[_0x6f20('0x41')][_0x6f20('0x4c')]+'%'};return _0x43a8b7;}})});}_0x172f97=_[_0x6f20('0x4d')]({},_0x172f97,_0x3d0a4a[_0x6f20('0x4e')]);var _0x14c42f={'where':_0x172f97['where']};return db[_0x6f20('0x3c')][_0x6f20('0x4f')](_0x14c42f)[_0x6f20('0x35')](function(_0x4caaca){_0x6b49b6[_0x6f20('0x4f')]=_0x4caaca;if(_0x3d0a4a[_0x6f20('0x41')][_0x6f20('0x50')]){_0x172f97['include']=[{'all':!![]}];}return db['SugarcrmConfiguration'][_0x6f20('0x51')](_0x172f97);})[_0x6f20('0x35')](function(_0x472e90){_0x6b49b6[_0x6f20('0x52')]=_0x472e90;return _0x6b49b6;})[_0x6f20('0x35')](respondWithFilteredResult(_0x3a8940,_0x172f97))[_0x6f20('0x29')](handleError(_0x3a8940,null));};exports[_0x6f20('0x53')]=function(_0x56cad7,_0x53a55e){var _0x49ca13={'raw':![],'where':{'id':_0x56cad7[_0x6f20('0x54')]['id']}},_0x3af32c={};_0x3af32c[_0x6f20('0x40')]=_[_0x6f20('0x42')](db[_0x6f20('0x3c')][_0x6f20('0x55')]);_0x3af32c['query']=_[_0x6f20('0x42')](_0x56cad7[_0x6f20('0x41')]);_0x3af32c[_0x6f20('0x43')]=_[_0x6f20('0x44')](_0x3af32c[_0x6f20('0x40')],_0x3af32c[_0x6f20('0x41')]);_0x49ca13[_0x6f20('0x45')]=_[_0x6f20('0x44')](_0x3af32c[_0x6f20('0x40')],qs['fields'](_0x56cad7[_0x6f20('0x41')][_0x6f20('0x46')]));_0x49ca13['attributes']=_0x49ca13[_0x6f20('0x45')][_0x6f20('0x47')]?_0x49ca13[_0x6f20('0x45')]:_0x3af32c['model'];if(_0x56cad7[_0x6f20('0x41')][_0x6f20('0x50')]){_0x49ca13['include']=[{'all':!![]}];}_0x49ca13=_['merge']({},_0x49ca13,_0x56cad7[_0x6f20('0x4e')]);return db['SugarcrmConfiguration'][_0x6f20('0x56')](_0x49ca13)[_0x6f20('0x35')](handleEntityNotFound(_0x53a55e,null))[_0x6f20('0x35')](respondWithResult(_0x53a55e,null))[_0x6f20('0x29')](handleError(_0x53a55e,null));};exports[_0x6f20('0x57')]=function(_0x2a19a9,_0x21e335){return db['SugarcrmConfiguration'][_0x6f20('0x57')](_0x2a19a9[_0x6f20('0x58')],{})[_0x6f20('0x35')](respondWithResult(_0x21e335,0xc9))[_0x6f20('0x29')](handleError(_0x21e335,null));};exports[_0x6f20('0x34')]=function(_0x2de9ad,_0x580cc1){if(_0x2de9ad[_0x6f20('0x58')]['id']){delete _0x2de9ad[_0x6f20('0x58')]['id'];}return db[_0x6f20('0x3c')]['find']({'where':{'id':_0x2de9ad['params']['id']}})[_0x6f20('0x35')](handleEntityNotFound(_0x580cc1,null))['then'](saveUpdates(_0x2de9ad[_0x6f20('0x58')],null))[_0x6f20('0x35')](respondWithResult(_0x580cc1,null))[_0x6f20('0x29')](handleError(_0x580cc1,null));};exports[_0x6f20('0x36')]=function(_0x184d2f,_0x307bf0){return db[_0x6f20('0x3c')][_0x6f20('0x56')]({'where':{'id':_0x184d2f[_0x6f20('0x54')]['id']}})[_0x6f20('0x35')](handleEntityNotFound(_0x307bf0,null))[_0x6f20('0x35')](removeEntity(_0x307bf0,null))['catch'](handleError(_0x307bf0,null));};exports['getFields']=function(_0x23c7a5,_0x4a8f64,_0x219d59){var _0x1e754f={};var _0x181d20={};var _0x5a5c23;var _0x322489;return db[_0x6f20('0x3c')][_0x6f20('0x59')]({'where':{'id':_0x23c7a5[_0x6f20('0x54')]['id']}})[_0x6f20('0x35')](handleEntityNotFound(_0x4a8f64,null))[_0x6f20('0x35')](function(_0x50af25){if(_0x50af25){_0x5a5c23=_0x50af25;_0x181d20['model']=_['keys'](db['SugarcrmField']['rawAttributes']);_0x181d20[_0x6f20('0x41')]=_[_0x6f20('0x42')](_0x23c7a5['query']);_0x181d20['filters']=_['intersection'](_0x181d20['model'],_0x181d20[_0x6f20('0x41')]);_0x1e754f[_0x6f20('0x45')]=_[_0x6f20('0x44')](_0x181d20[_0x6f20('0x40')],qs['fields'](_0x23c7a5[_0x6f20('0x41')][_0x6f20('0x46')]));_0x1e754f[_0x6f20('0x45')]=_0x1e754f['attributes'][_0x6f20('0x47')]?_0x1e754f[_0x6f20('0x45')]:_0x181d20[_0x6f20('0x40')];_0x1e754f[_0x6f20('0x5a')]=qs['sort'](_0x23c7a5[_0x6f20('0x41')]['sort']);_0x1e754f[_0x6f20('0x4a')]=qs[_0x6f20('0x43')](_['pick'](_0x23c7a5[_0x6f20('0x41')],_0x181d20[_0x6f20('0x43')]));if(_0x23c7a5[_0x6f20('0x41')][_0x6f20('0x4c')]){_0x1e754f[_0x6f20('0x4a')]=_[_0x6f20('0x4d')](_0x1e754f[_0x6f20('0x4a')],{'$or':_[_0x6f20('0x3b')](_0x1e754f[_0x6f20('0x45')],function(_0x4a4d81){var _0x7e92bf={};_0x7e92bf[_0x4a4d81]={'$like':'%'+_0x23c7a5[_0x6f20('0x41')][_0x6f20('0x4c')]+'%'};return _0x7e92bf;})});}_0x1e754f=_[_0x6f20('0x4d')]({},_0x1e754f,_0x23c7a5[_0x6f20('0x4e')]);return _0x5a5c23['getFields'](_0x1e754f);}})[_0x6f20('0x35')](function(_0x13bfaa){if(_0x13bfaa){_0x322489=_0x13bfaa[_0x6f20('0x47')];if(!_0x23c7a5[_0x6f20('0x41')][_0x6f20('0x48')](_0x6f20('0x5b'))){_0x1e754f[_0x6f20('0x2f')]=qs[_0x6f20('0x2f')](_0x23c7a5[_0x6f20('0x41')][_0x6f20('0x2f')]);_0x1e754f[_0x6f20('0x2e')]=qs['offset'](_0x23c7a5[_0x6f20('0x41')][_0x6f20('0x2e')]);}return _0x5a5c23[_0x6f20('0x5c')](_0x1e754f);}})[_0x6f20('0x35')](function(_0xe0f10f){if(_0xe0f10f){return _0xe0f10f?{'count':_0x322489,'rows':_0xe0f10f}:null;}})['then'](respondWithResult(_0x4a8f64,null))[_0x6f20('0x29')](handleError(_0x4a8f64,null));};exports[_0x6f20('0x5d')]=function(_0x2c1d57,_0x215cae,_0xe93a59){var _0xdaa7a0={};var _0x521a6f={};var _0x4cd574;var _0x1f4038;return db[_0x6f20('0x3c')][_0x6f20('0x59')]({'where':{'id':_0x2c1d57[_0x6f20('0x54')]['id']}})[_0x6f20('0x35')](handleEntityNotFound(_0x215cae,null))[_0x6f20('0x35')](function(_0x40f022){if(_0x40f022){_0x4cd574=_0x40f022;_0x521a6f[_0x6f20('0x40')]=_['keys'](db['SugarcrmField'][_0x6f20('0x55')]);_0x521a6f[_0x6f20('0x41')]=_['keys'](_0x2c1d57['query']);_0x521a6f[_0x6f20('0x43')]=_[_0x6f20('0x44')](_0x521a6f[_0x6f20('0x40')],_0x521a6f[_0x6f20('0x41')]);_0xdaa7a0[_0x6f20('0x45')]=_[_0x6f20('0x44')](_0x521a6f['model'],qs['fields'](_0x2c1d57['query'][_0x6f20('0x46')]));_0xdaa7a0[_0x6f20('0x45')]=_0xdaa7a0[_0x6f20('0x45')][_0x6f20('0x47')]?_0xdaa7a0['attributes']:_0x521a6f[_0x6f20('0x40')];_0xdaa7a0['order']=qs[_0x6f20('0x49')](_0x2c1d57[_0x6f20('0x41')][_0x6f20('0x49')]);_0xdaa7a0[_0x6f20('0x4a')]=qs[_0x6f20('0x43')](_[_0x6f20('0x4b')](_0x2c1d57[_0x6f20('0x41')],_0x521a6f[_0x6f20('0x43')]));if(_0x2c1d57[_0x6f20('0x41')][_0x6f20('0x4c')]){_0xdaa7a0[_0x6f20('0x4a')]=_[_0x6f20('0x4d')](_0xdaa7a0[_0x6f20('0x4a')],{'$or':_[_0x6f20('0x3b')](_0xdaa7a0[_0x6f20('0x45')],function(_0xbea15b){var _0x2c4797={};_0x2c4797[_0xbea15b]={'$like':'%'+_0x2c1d57[_0x6f20('0x41')][_0x6f20('0x4c')]+'%'};return _0x2c4797;})});}_0xdaa7a0=_[_0x6f20('0x4d')]({},_0xdaa7a0,_0x2c1d57['options']);return _0x4cd574[_0x6f20('0x5d')](_0xdaa7a0);}})[_0x6f20('0x35')](function(_0x44b47f){if(_0x44b47f){_0x1f4038=_0x44b47f[_0x6f20('0x47')];if(!_0x2c1d57['query'][_0x6f20('0x48')]('nolimit')){_0xdaa7a0[_0x6f20('0x2f')]=qs[_0x6f20('0x2f')](_0x2c1d57[_0x6f20('0x41')][_0x6f20('0x2f')]);_0xdaa7a0[_0x6f20('0x2e')]=qs[_0x6f20('0x2e')](_0x2c1d57['query'][_0x6f20('0x2e')]);}return _0x4cd574[_0x6f20('0x5d')](_0xdaa7a0);}})[_0x6f20('0x35')](function(_0x3951a2){if(_0x3951a2){return _0x3951a2?{'count':_0x1f4038,'rows':_0x3951a2}:null;}})['then'](respondWithResult(_0x215cae,null))[_0x6f20('0x29')](handleError(_0x215cae,null));};exports[_0x6f20('0x5e')]=function(_0x1cdfca,_0x1b56df,_0x1de7fa){var _0x16d2c4={};var _0x578730={};var _0x1b9254;var _0x516c49;return db[_0x6f20('0x3c')][_0x6f20('0x59')]({'where':{'id':_0x1cdfca[_0x6f20('0x54')]['id']}})[_0x6f20('0x35')](handleEntityNotFound(_0x1b56df,null))[_0x6f20('0x35')](function(_0xd03bd2){if(_0xd03bd2){_0x1b9254=_0xd03bd2;_0x578730['model']=_[_0x6f20('0x42')](db['SugarcrmField'][_0x6f20('0x55')]);_0x578730[_0x6f20('0x41')]=_[_0x6f20('0x42')](_0x1cdfca[_0x6f20('0x41')]);_0x578730[_0x6f20('0x43')]=_[_0x6f20('0x44')](_0x578730['model'],_0x578730[_0x6f20('0x41')]);_0x16d2c4[_0x6f20('0x45')]=_[_0x6f20('0x44')](_0x578730['model'],qs[_0x6f20('0x46')](_0x1cdfca[_0x6f20('0x41')][_0x6f20('0x46')]));_0x16d2c4[_0x6f20('0x45')]=_0x16d2c4[_0x6f20('0x45')]['length']?_0x16d2c4[_0x6f20('0x45')]:_0x578730[_0x6f20('0x40')];_0x16d2c4[_0x6f20('0x5a')]=qs[_0x6f20('0x49')](_0x1cdfca['query'][_0x6f20('0x49')]);_0x16d2c4[_0x6f20('0x4a')]=qs['filters'](_[_0x6f20('0x4b')](_0x1cdfca[_0x6f20('0x41')],_0x578730['filters']));if(_0x1cdfca[_0x6f20('0x41')][_0x6f20('0x4c')]){_0x16d2c4['where']=_['merge'](_0x16d2c4[_0x6f20('0x4a')],{'$or':_[_0x6f20('0x3b')](_0x16d2c4['attributes'],function(_0x45e1a5){var _0x5afa4a={};_0x5afa4a[_0x45e1a5]={'$like':'%'+_0x1cdfca['query'][_0x6f20('0x4c')]+'%'};return _0x5afa4a;})});}_0x16d2c4=_['merge']({},_0x16d2c4,_0x1cdfca[_0x6f20('0x4e')]);return _0x1b9254[_0x6f20('0x5e')](_0x16d2c4);}})[_0x6f20('0x35')](function(_0x41c3d6){if(_0x41c3d6){_0x516c49=_0x41c3d6[_0x6f20('0x47')];if(!_0x1cdfca[_0x6f20('0x41')]['hasOwnProperty']('nolimit')){_0x16d2c4[_0x6f20('0x2f')]=qs[_0x6f20('0x2f')](_0x1cdfca[_0x6f20('0x41')][_0x6f20('0x2f')]);_0x16d2c4['offset']=qs['offset'](_0x1cdfca[_0x6f20('0x41')][_0x6f20('0x2e')]);}return _0x1b9254['getDescriptions'](_0x16d2c4);}})[_0x6f20('0x35')](function(_0x561b14){if(_0x561b14){return _0x561b14?{'count':_0x516c49,'rows':_0x561b14}:null;}})[_0x6f20('0x35')](respondWithResult(_0x1b56df,null))[_0x6f20('0x29')](handleError(_0x1b56df,null));};
\ No newline at end of file
+var _0x18bb=['error','stack','name','index','rawAttributes','model','map','filters','intersection','query','attributes','fields','length','hasOwnProperty','order','sort','filter','where','merge','VIRTUAL','SugarcrmConfiguration','include','findAll','rows','catch','show','params','keys','includeAll','options','find','create','body','getFields','findOne','SugarcrmField','nolimit','getSubjects','pick','getDescriptions','rimraf','zip-dir','fast-json-patch','bluebird','util','path','sox','ejs','fs-extra','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','undefined','limit','count','set','Content-Range','json','reject','save','then','destroy'];(function(_0x3d9c7e,_0x2f192c){var _0x5d6c3c=function(_0x677147){while(--_0x677147){_0x3d9c7e['push'](_0x3d9c7e['shift']());}};_0x5d6c3c(++_0x2f192c);}(_0x18bb,0x10f));var _0xb18b=function(_0x47e549,_0x2e53d6){_0x47e549=_0x47e549-0x0;var _0x251374=_0x18bb[_0x47e549];return _0x251374;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xb18b('0x0'));var zipdir=require(_0xb18b('0x1'));var jsonpatch=require(_0xb18b('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xb18b('0x3'));var Mustache=require('mustache');var util=require(_0xb18b('0x4'));var path=require(_0xb18b('0x5'));var sox=require(_0xb18b('0x6'));var csv=require('to-csv');var ejs=require(_0xb18b('0x7'));var fs=require('fs');var fs_extra=require(_0xb18b('0x8'));var _=require('lodash');var squel=require(_0xb18b('0x9'));var crypto=require(_0xb18b('0xa'));var jsforce=require(_0xb18b('0xb'));var deskjs=require(_0xb18b('0xc'));var toCsv=require(_0xb18b('0xd'));var querystring=require(_0xb18b('0xe'));var Papa=require(_0xb18b('0xf'));var Redis=require('ioredis');var authService=require(_0xb18b('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0xb18b('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xb18b('0x12'))(_0xb18b('0x13'));var utils=require(_0xb18b('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0xb18b('0x15'));var db=require(_0xb18b('0x16'))['db'];function respondWithStatusCode(_0x33cf28,_0x18d74){_0x18d74=_0x18d74||0xcc;return function(_0x2557ef){if(_0x2557ef){return _0x33cf28[_0xb18b('0x17')](_0x18d74);}return _0x33cf28[_0xb18b('0x18')](_0x18d74)[_0xb18b('0x19')]();};}function respondWithResult(_0x1ec3d9,_0x2839f5){_0x2839f5=_0x2839f5||0xc8;return function(_0x3c031b){if(_0x3c031b){return _0x1ec3d9[_0xb18b('0x18')](_0x2839f5)['json'](_0x3c031b);}};}function respondWithFilteredResult(_0xf0b4b8,_0x423bf4){return function(_0x3284f4){if(_0x3284f4){var _0x244cf5=typeof _0x423bf4[_0xb18b('0x1a')]===_0xb18b('0x1b')&&typeof _0x423bf4[_0xb18b('0x1c')]==='undefined';var _0x47acaa=_0x3284f4[_0xb18b('0x1d')];var _0x22e55f=_0x244cf5?0x0:_0x423bf4[_0xb18b('0x1a')];var _0x3b9aa2=_0x244cf5?_0x3284f4[_0xb18b('0x1d')]:_0x423bf4['offset']+_0x423bf4['limit'];var _0xab9040;if(_0x3b9aa2>=_0x47acaa){_0x3b9aa2=_0x47acaa;_0xab9040=0xc8;}else{_0xab9040=0xce;}_0xf0b4b8[_0xb18b('0x18')](_0xab9040);return _0xf0b4b8[_0xb18b('0x1e')](_0xb18b('0x1f'),_0x22e55f+'-'+_0x3b9aa2+'/'+_0x47acaa)[_0xb18b('0x20')](_0x3284f4);}return null;};}function patchUpdates(_0x17005d){return function(_0x4495ac){try{jsonpatch['apply'](_0x4495ac,_0x17005d,!![]);}catch(_0x2b1b0a){return BPromise[_0xb18b('0x21')](_0x2b1b0a);}return _0x4495ac[_0xb18b('0x22')]();};}function saveUpdates(_0x1819ca,_0x17ae75){return function(_0x1a66a3){if(_0x1a66a3){return _0x1a66a3['update'](_0x1819ca)[_0xb18b('0x23')](function(_0x423b93){return _0x423b93;});}return null;};}function removeEntity(_0x4796f9,_0x104c74){return function(_0x5140ac){if(_0x5140ac){return _0x5140ac[_0xb18b('0x24')]()[_0xb18b('0x23')](function(){_0x4796f9[_0xb18b('0x18')](0xcc)[_0xb18b('0x19')]();});}};}function handleEntityNotFound(_0x1c3e72,_0x322094){return function(_0x1f3dbd){if(!_0x1f3dbd){_0x1c3e72['sendStatus'](0x194);}return _0x1f3dbd;};}function handleError(_0x199eab,_0x3ddace){_0x3ddace=_0x3ddace||0x1f4;return function(_0x362e07){logger[_0xb18b('0x25')](_0x362e07[_0xb18b('0x26')]);if(_0x362e07[_0xb18b('0x27')]){delete _0x362e07['name'];}_0x199eab[_0xb18b('0x18')](_0x3ddace)['send'](_0x362e07);};}exports[_0xb18b('0x28')]=function(_0x29ff95,_0x110665){var _0x8a0b5d={},_0x1ef6d7={},_0xc62dfe={'count':0x0,'rows':[]};var _0x25b542=_['map'](db['SugarcrmConfiguration'][_0xb18b('0x29')],function(_0x148390){return{'name':_0x148390['fieldName'],'type':_0x148390['type']['key']};});_0x1ef6d7[_0xb18b('0x2a')]=_[_0xb18b('0x2b')](_0x25b542,'name');_0x1ef6d7['query']=_['keys'](_0x29ff95['query']);_0x1ef6d7[_0xb18b('0x2c')]=_[_0xb18b('0x2d')](_0x1ef6d7[_0xb18b('0x2a')],_0x1ef6d7[_0xb18b('0x2e')]);_0x8a0b5d[_0xb18b('0x2f')]=_[_0xb18b('0x2d')](_0x1ef6d7[_0xb18b('0x2a')],qs[_0xb18b('0x30')](_0x29ff95[_0xb18b('0x2e')]['fields']));_0x8a0b5d[_0xb18b('0x2f')]=_0x8a0b5d['attributes'][_0xb18b('0x31')]?_0x8a0b5d[_0xb18b('0x2f')]:_0x1ef6d7['model'];if(!_0x29ff95[_0xb18b('0x2e')][_0xb18b('0x32')]('nolimit')){_0x8a0b5d[_0xb18b('0x1c')]=qs[_0xb18b('0x1c')](_0x29ff95[_0xb18b('0x2e')][_0xb18b('0x1c')]);_0x8a0b5d[_0xb18b('0x1a')]=qs['offset'](_0x29ff95['query'][_0xb18b('0x1a')]);}_0x8a0b5d[_0xb18b('0x33')]=qs[_0xb18b('0x34')](_0x29ff95[_0xb18b('0x2e')][_0xb18b('0x34')]);_0x8a0b5d['where']=qs['filters'](_['pick'](_0x29ff95[_0xb18b('0x2e')],_0x1ef6d7[_0xb18b('0x2c')]),_0x25b542);if(_0x29ff95[_0xb18b('0x2e')][_0xb18b('0x35')]){_0x8a0b5d[_0xb18b('0x36')]=_[_0xb18b('0x37')](_0x8a0b5d[_0xb18b('0x36')],{'$or':_['map'](_0x25b542,function(_0x21123a){if(_0x21123a['type']!==_0xb18b('0x38')){var _0x3a1378={};_0x3a1378[_0x21123a[_0xb18b('0x27')]]={'$like':'%'+_0x29ff95[_0xb18b('0x2e')]['filter']+'%'};return _0x3a1378;}})});}_0x8a0b5d=_['merge']({},_0x8a0b5d,_0x29ff95['options']);var _0x4485e1={'where':_0x8a0b5d['where']};return db[_0xb18b('0x39')][_0xb18b('0x1d')](_0x4485e1)[_0xb18b('0x23')](function(_0x1e677e){_0xc62dfe[_0xb18b('0x1d')]=_0x1e677e;if(_0x29ff95[_0xb18b('0x2e')]['includeAll']){_0x8a0b5d[_0xb18b('0x3a')]=[{'all':!![]}];}return db['SugarcrmConfiguration'][_0xb18b('0x3b')](_0x8a0b5d);})[_0xb18b('0x23')](function(_0x31d515){_0xc62dfe[_0xb18b('0x3c')]=_0x31d515;return _0xc62dfe;})[_0xb18b('0x23')](respondWithFilteredResult(_0x110665,_0x8a0b5d))[_0xb18b('0x3d')](handleError(_0x110665,null));};exports[_0xb18b('0x3e')]=function(_0x320b3a,_0x3493bc){var _0xa24a87={'raw':![],'where':{'id':_0x320b3a[_0xb18b('0x3f')]['id']}},_0x3294b3={};_0x3294b3[_0xb18b('0x2a')]=_[_0xb18b('0x40')](db['SugarcrmConfiguration'][_0xb18b('0x29')]);_0x3294b3['query']=_['keys'](_0x320b3a[_0xb18b('0x2e')]);_0x3294b3[_0xb18b('0x2c')]=_['intersection'](_0x3294b3[_0xb18b('0x2a')],_0x3294b3['query']);_0xa24a87['attributes']=_[_0xb18b('0x2d')](_0x3294b3[_0xb18b('0x2a')],qs[_0xb18b('0x30')](_0x320b3a[_0xb18b('0x2e')]['fields']));_0xa24a87[_0xb18b('0x2f')]=_0xa24a87[_0xb18b('0x2f')][_0xb18b('0x31')]?_0xa24a87[_0xb18b('0x2f')]:_0x3294b3[_0xb18b('0x2a')];if(_0x320b3a[_0xb18b('0x2e')][_0xb18b('0x41')]){_0xa24a87[_0xb18b('0x3a')]=[{'all':!![]}];}_0xa24a87=_[_0xb18b('0x37')]({},_0xa24a87,_0x320b3a[_0xb18b('0x42')]);return db[_0xb18b('0x39')][_0xb18b('0x43')](_0xa24a87)[_0xb18b('0x23')](handleEntityNotFound(_0x3493bc,null))['then'](respondWithResult(_0x3493bc,null))[_0xb18b('0x3d')](handleError(_0x3493bc,null));};exports[_0xb18b('0x44')]=function(_0xddbf3f,_0x10da4f){return db[_0xb18b('0x39')][_0xb18b('0x44')](_0xddbf3f[_0xb18b('0x45')],{})['then'](respondWithResult(_0x10da4f,0xc9))[_0xb18b('0x3d')](handleError(_0x10da4f,null));};exports['update']=function(_0xf497c2,_0x470482){if(_0xf497c2[_0xb18b('0x45')]['id']){delete _0xf497c2[_0xb18b('0x45')]['id'];}return db[_0xb18b('0x39')]['find']({'where':{'id':_0xf497c2[_0xb18b('0x3f')]['id']}})[_0xb18b('0x23')](handleEntityNotFound(_0x470482,null))['then'](saveUpdates(_0xf497c2[_0xb18b('0x45')],null))[_0xb18b('0x23')](respondWithResult(_0x470482,null))['catch'](handleError(_0x470482,null));};exports['destroy']=function(_0x2af86d,_0x856ff8){return db['SugarcrmConfiguration'][_0xb18b('0x43')]({'where':{'id':_0x2af86d[_0xb18b('0x3f')]['id']}})[_0xb18b('0x23')](handleEntityNotFound(_0x856ff8,null))[_0xb18b('0x23')](removeEntity(_0x856ff8,null))[_0xb18b('0x3d')](handleError(_0x856ff8,null));};exports[_0xb18b('0x46')]=function(_0x2e5a40,_0x337361,_0x3c0cec){var _0x4f0d0b={};var _0x3a2920={};var _0x2da5da;var _0x407999;return db[_0xb18b('0x39')][_0xb18b('0x47')]({'where':{'id':_0x2e5a40[_0xb18b('0x3f')]['id']}})[_0xb18b('0x23')](handleEntityNotFound(_0x337361,null))[_0xb18b('0x23')](function(_0x429d0c){if(_0x429d0c){_0x2da5da=_0x429d0c;_0x3a2920[_0xb18b('0x2a')]=_[_0xb18b('0x40')](db[_0xb18b('0x48')][_0xb18b('0x29')]);_0x3a2920[_0xb18b('0x2e')]=_[_0xb18b('0x40')](_0x2e5a40[_0xb18b('0x2e')]);_0x3a2920[_0xb18b('0x2c')]=_[_0xb18b('0x2d')](_0x3a2920['model'],_0x3a2920['query']);_0x4f0d0b[_0xb18b('0x2f')]=_[_0xb18b('0x2d')](_0x3a2920[_0xb18b('0x2a')],qs['fields'](_0x2e5a40[_0xb18b('0x2e')][_0xb18b('0x30')]));_0x4f0d0b[_0xb18b('0x2f')]=_0x4f0d0b[_0xb18b('0x2f')][_0xb18b('0x31')]?_0x4f0d0b['attributes']:_0x3a2920[_0xb18b('0x2a')];_0x4f0d0b[_0xb18b('0x33')]=qs['sort'](_0x2e5a40['query']['sort']);_0x4f0d0b[_0xb18b('0x36')]=qs[_0xb18b('0x2c')](_['pick'](_0x2e5a40['query'],_0x3a2920['filters']));if(_0x2e5a40['query'][_0xb18b('0x35')]){_0x4f0d0b[_0xb18b('0x36')]=_[_0xb18b('0x37')](_0x4f0d0b[_0xb18b('0x36')],{'$or':_[_0xb18b('0x2b')](_0x4f0d0b[_0xb18b('0x2f')],function(_0x4c4750){var _0x366828={};_0x366828[_0x4c4750]={'$like':'%'+_0x2e5a40['query'][_0xb18b('0x35')]+'%'};return _0x366828;})});}_0x4f0d0b=_['merge']({},_0x4f0d0b,_0x2e5a40['options']);return _0x2da5da['getFields'](_0x4f0d0b);}})[_0xb18b('0x23')](function(_0x464c9e){if(_0x464c9e){_0x407999=_0x464c9e['length'];if(!_0x2e5a40[_0xb18b('0x2e')][_0xb18b('0x32')](_0xb18b('0x49'))){_0x4f0d0b[_0xb18b('0x1c')]=qs[_0xb18b('0x1c')](_0x2e5a40[_0xb18b('0x2e')]['limit']);_0x4f0d0b[_0xb18b('0x1a')]=qs[_0xb18b('0x1a')](_0x2e5a40[_0xb18b('0x2e')][_0xb18b('0x1a')]);}return _0x2da5da['getFields'](_0x4f0d0b);}})['then'](function(_0x1cdaf1){if(_0x1cdaf1){return _0x1cdaf1?{'count':_0x407999,'rows':_0x1cdaf1}:null;}})[_0xb18b('0x23')](respondWithResult(_0x337361,null))[_0xb18b('0x3d')](handleError(_0x337361,null));};exports[_0xb18b('0x4a')]=function(_0x2f10da,_0x4f4783,_0x2d09c9){var _0x3171da={};var _0x470b38={};var _0x12783a;var _0x4fcac1;return db[_0xb18b('0x39')][_0xb18b('0x47')]({'where':{'id':_0x2f10da[_0xb18b('0x3f')]['id']}})['then'](handleEntityNotFound(_0x4f4783,null))[_0xb18b('0x23')](function(_0x159de6){if(_0x159de6){_0x12783a=_0x159de6;_0x470b38[_0xb18b('0x2a')]=_[_0xb18b('0x40')](db[_0xb18b('0x48')]['rawAttributes']);_0x470b38['query']=_[_0xb18b('0x40')](_0x2f10da['query']);_0x470b38[_0xb18b('0x2c')]=_['intersection'](_0x470b38[_0xb18b('0x2a')],_0x470b38[_0xb18b('0x2e')]);_0x3171da[_0xb18b('0x2f')]=_['intersection'](_0x470b38[_0xb18b('0x2a')],qs[_0xb18b('0x30')](_0x2f10da[_0xb18b('0x2e')][_0xb18b('0x30')]));_0x3171da['attributes']=_0x3171da[_0xb18b('0x2f')][_0xb18b('0x31')]?_0x3171da[_0xb18b('0x2f')]:_0x470b38[_0xb18b('0x2a')];_0x3171da[_0xb18b('0x33')]=qs[_0xb18b('0x34')](_0x2f10da[_0xb18b('0x2e')][_0xb18b('0x34')]);_0x3171da[_0xb18b('0x36')]=qs['filters'](_[_0xb18b('0x4b')](_0x2f10da[_0xb18b('0x2e')],_0x470b38[_0xb18b('0x2c')]));if(_0x2f10da[_0xb18b('0x2e')][_0xb18b('0x35')]){_0x3171da['where']=_[_0xb18b('0x37')](_0x3171da[_0xb18b('0x36')],{'$or':_[_0xb18b('0x2b')](_0x3171da['attributes'],function(_0x4dc266){var _0x2476eb={};_0x2476eb[_0x4dc266]={'$like':'%'+_0x2f10da['query']['filter']+'%'};return _0x2476eb;})});}_0x3171da=_[_0xb18b('0x37')]({},_0x3171da,_0x2f10da['options']);return _0x12783a[_0xb18b('0x4a')](_0x3171da);}})[_0xb18b('0x23')](function(_0x296953){if(_0x296953){_0x4fcac1=_0x296953['length'];if(!_0x2f10da[_0xb18b('0x2e')][_0xb18b('0x32')]('nolimit')){_0x3171da[_0xb18b('0x1c')]=qs[_0xb18b('0x1c')](_0x2f10da[_0xb18b('0x2e')]['limit']);_0x3171da['offset']=qs[_0xb18b('0x1a')](_0x2f10da[_0xb18b('0x2e')]['offset']);}return _0x12783a[_0xb18b('0x4a')](_0x3171da);}})[_0xb18b('0x23')](function(_0x2f8b9b){if(_0x2f8b9b){return _0x2f8b9b?{'count':_0x4fcac1,'rows':_0x2f8b9b}:null;}})[_0xb18b('0x23')](respondWithResult(_0x4f4783,null))[_0xb18b('0x3d')](handleError(_0x4f4783,null));};exports[_0xb18b('0x4c')]=function(_0x21e88c,_0x5f3ec4,_0x4a1e16){var _0x2b3ef3={};var _0x4ee020={};var _0x3b77ce;var _0xe00288;return db[_0xb18b('0x39')][_0xb18b('0x47')]({'where':{'id':_0x21e88c['params']['id']}})[_0xb18b('0x23')](handleEntityNotFound(_0x5f3ec4,null))[_0xb18b('0x23')](function(_0xc4cdf3){if(_0xc4cdf3){_0x3b77ce=_0xc4cdf3;_0x4ee020[_0xb18b('0x2a')]=_[_0xb18b('0x40')](db[_0xb18b('0x48')]['rawAttributes']);_0x4ee020[_0xb18b('0x2e')]=_[_0xb18b('0x40')](_0x21e88c['query']);_0x4ee020[_0xb18b('0x2c')]=_[_0xb18b('0x2d')](_0x4ee020[_0xb18b('0x2a')],_0x4ee020[_0xb18b('0x2e')]);_0x2b3ef3['attributes']=_[_0xb18b('0x2d')](_0x4ee020[_0xb18b('0x2a')],qs[_0xb18b('0x30')](_0x21e88c['query'][_0xb18b('0x30')]));_0x2b3ef3[_0xb18b('0x2f')]=_0x2b3ef3[_0xb18b('0x2f')][_0xb18b('0x31')]?_0x2b3ef3[_0xb18b('0x2f')]:_0x4ee020[_0xb18b('0x2a')];_0x2b3ef3[_0xb18b('0x33')]=qs[_0xb18b('0x34')](_0x21e88c[_0xb18b('0x2e')][_0xb18b('0x34')]);_0x2b3ef3[_0xb18b('0x36')]=qs[_0xb18b('0x2c')](_[_0xb18b('0x4b')](_0x21e88c['query'],_0x4ee020[_0xb18b('0x2c')]));if(_0x21e88c[_0xb18b('0x2e')][_0xb18b('0x35')]){_0x2b3ef3[_0xb18b('0x36')]=_[_0xb18b('0x37')](_0x2b3ef3['where'],{'$or':_[_0xb18b('0x2b')](_0x2b3ef3[_0xb18b('0x2f')],function(_0x216151){var _0x118f74={};_0x118f74[_0x216151]={'$like':'%'+_0x21e88c[_0xb18b('0x2e')][_0xb18b('0x35')]+'%'};return _0x118f74;})});}_0x2b3ef3=_[_0xb18b('0x37')]({},_0x2b3ef3,_0x21e88c[_0xb18b('0x42')]);return _0x3b77ce[_0xb18b('0x4c')](_0x2b3ef3);}})[_0xb18b('0x23')](function(_0x5118e5){if(_0x5118e5){_0xe00288=_0x5118e5[_0xb18b('0x31')];if(!_0x21e88c['query'][_0xb18b('0x32')](_0xb18b('0x49'))){_0x2b3ef3['limit']=qs[_0xb18b('0x1c')](_0x21e88c[_0xb18b('0x2e')][_0xb18b('0x1c')]);_0x2b3ef3[_0xb18b('0x1a')]=qs[_0xb18b('0x1a')](_0x21e88c['query']['offset']);}return _0x3b77ce[_0xb18b('0x4c')](_0x2b3ef3);}})[_0xb18b('0x23')](function(_0x155270){if(_0x155270){return _0x155270?{'count':_0xe00288,'rows':_0x155270}:null;}})[_0xb18b('0x23')](respondWithResult(_0x5f3ec4,null))['catch'](handleError(_0x5f3ec4,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff