18 var _0x074d=['then','destroy','error','stack','send','index','map','rawAttributes','type','model','name','keys','query','intersection','fields','attributes','length','hasOwnProperty','nolimit','limit','order','sort','filters','where','merge','VIRTUAL','filter','SugarcrmConfiguration','includeAll','include','findAll','show','params','options','find','catch','create','body','getFields','findOne','SugarcrmField','pick','getSubjects','getDescriptions','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','util','sox','to-csv','fs-extra','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','undefined','count','set','Content-Range','apply','reject','update'];(function(_0x31708d,_0x1e383d){var _0x29be7d=function(_0x36a9e8){while(--_0x36a9e8){_0x31708d['push'](_0x31708d['shift']());}};_0x29be7d(++_0x1e383d);}(_0x074d,0x11c));var _0xd074=function(_0x17d995,_0x3bd90c){_0x17d995=_0x17d995-0x0;var _0x5a1ab1=_0x074d[_0x17d995];return _0x5a1ab1;};'use strict';var emlformat=require(_0xd074('0x0'));var rimraf=require(_0xd074('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xd074('0x2'));var rp=require(_0xd074('0x3'));var moment=require(_0xd074('0x4'));var BPromise=require(_0xd074('0x5'));var Mustache=require('mustache');var util=require(_0xd074('0x6'));var path=require('path');var sox=require(_0xd074('0x7'));var csv=require(_0xd074('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xd074('0x9'));var _=require('lodash');var squel=require(_0xd074('0xa'));var crypto=require('crypto');var jsforce=require(_0xd074('0xb'));var deskjs=require(_0xd074('0xc'));var toCsv=require(_0xd074('0x8'));var querystring=require(_0xd074('0xd'));var Papa=require(_0xd074('0xe'));var Redis=require(_0xd074('0xf'));var authService=require(_0xd074('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0xd074('0x11'));var hardwareService=require(_0xd074('0x12'));var logger=require(_0xd074('0x13'))(_0xd074('0x14'));var utils=require(_0xd074('0x15'));var config=require(_0xd074('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0xd074('0x17'))['db'];function respondWithStatusCode(_0x33fbb9,_0x1805f6){_0x1805f6=_0x1805f6||0xcc;return function(_0x222863){if(_0x222863){return _0x33fbb9[_0xd074('0x18')](_0x1805f6);}return _0x33fbb9[_0xd074('0x19')](_0x1805f6)[_0xd074('0x1a')]();};}function respondWithResult(_0x2ba356,_0x35b7af){_0x35b7af=_0x35b7af||0xc8;return function(_0x21aff1){if(_0x21aff1){return _0x2ba356[_0xd074('0x19')](_0x35b7af)[_0xd074('0x1b')](_0x21aff1);}};}function respondWithFilteredResult(_0x354b86,_0x5c3d75){return function(_0x5e3c06){if(_0x5e3c06){var _0xb21db=typeof _0x5c3d75[_0xd074('0x1c')]===_0xd074('0x1d')&&typeof _0x5c3d75['limit']===_0xd074('0x1d');var _0x46af79=_0x5e3c06[_0xd074('0x1e')];var _0x2038ed=_0xb21db?0x0:_0x5c3d75[_0xd074('0x1c')];var _0x308f10=_0xb21db?_0x5e3c06[_0xd074('0x1e')]:_0x5c3d75['offset']+_0x5c3d75['limit'];var _0x159f96;if(_0x308f10>=_0x46af79){_0x308f10=_0x46af79;_0x159f96=0xc8;}else{_0x159f96=0xce;}_0x354b86[_0xd074('0x19')](_0x159f96);return _0x354b86[_0xd074('0x1f')](_0xd074('0x20'),_0x2038ed+'-'+_0x308f10+'/'+_0x46af79)[_0xd074('0x1b')](_0x5e3c06);}return null;};}function patchUpdates(_0x499c48){return function(_0x477a60){try{jsonpatch[_0xd074('0x21')](_0x477a60,_0x499c48,!![]);}catch(_0x21ffcd){return BPromise[_0xd074('0x22')](_0x21ffcd);}return _0x477a60['save']();};}function saveUpdates(_0x168195,_0xb9f2d3){return function(_0x49c6b8){if(_0x49c6b8){return _0x49c6b8[_0xd074('0x23')](_0x168195)[_0xd074('0x24')](function(_0x41dbce){return _0x41dbce;});}return null;};}function removeEntity(_0x58853d,_0x11e4bc){return function(_0x272fc3){if(_0x272fc3){return _0x272fc3[_0xd074('0x25')]()['then'](function(){_0x58853d[_0xd074('0x19')](0xcc)[_0xd074('0x1a')]();});}};}function handleEntityNotFound(_0x1c06b4,_0x54094c){return function(_0x2dd163){if(!_0x2dd163){_0x1c06b4[_0xd074('0x18')](0x194);}return _0x2dd163;};}function handleError(_0x42ffad,_0x40abec){_0x40abec=_0x40abec||0x1f4;return function(_0x1cfa5c){logger[_0xd074('0x26')](_0x1cfa5c[_0xd074('0x27')]);if(_0x1cfa5c['name']){delete _0x1cfa5c['name'];}_0x42ffad['status'](_0x40abec)[_0xd074('0x28')](_0x1cfa5c);};}exports[_0xd074('0x29')]=function(_0x1ff785,_0x2e2915){var _0x252096={},_0x407f41={},_0x489c8e={'count':0x0,'rows':[]};var _0x229d9f=_[_0xd074('0x2a')](db['SugarcrmConfiguration'][_0xd074('0x2b')],function(_0x3a57d6){return{'name':_0x3a57d6['fieldName'],'type':_0x3a57d6[_0xd074('0x2c')]['key']};});_0x407f41[_0xd074('0x2d')]=_[_0xd074('0x2a')](_0x229d9f,_0xd074('0x2e'));_0x407f41['query']=_[_0xd074('0x2f')](_0x1ff785['query']);_0x407f41['filters']=_['intersection'](_0x407f41[_0xd074('0x2d')],_0x407f41[_0xd074('0x30')]);_0x252096['attributes']=_[_0xd074('0x31')](_0x407f41[_0xd074('0x2d')],qs['fields'](_0x1ff785[_0xd074('0x30')][_0xd074('0x32')]));_0x252096[_0xd074('0x33')]=_0x252096['attributes'][_0xd074('0x34')]?_0x252096[_0xd074('0x33')]:_0x407f41[_0xd074('0x2d')];if(!_0x1ff785['query'][_0xd074('0x35')](_0xd074('0x36'))){_0x252096['limit']=qs[_0xd074('0x37')](_0x1ff785[_0xd074('0x30')]['limit']);_0x252096[_0xd074('0x1c')]=qs['offset'](_0x1ff785[_0xd074('0x30')][_0xd074('0x1c')]);}_0x252096[_0xd074('0x38')]=qs[_0xd074('0x39')](_0x1ff785[_0xd074('0x30')]['sort']);_0x252096['where']=qs[_0xd074('0x3a')](_['pick'](_0x1ff785[_0xd074('0x30')],_0x407f41[_0xd074('0x3a')]),_0x229d9f);if(_0x1ff785['query']['filter']){_0x252096[_0xd074('0x3b')]=_[_0xd074('0x3c')](_0x252096['where'],{'$or':_[_0xd074('0x2a')](_0x229d9f,function(_0x44aa4c){if(_0x44aa4c[_0xd074('0x2c')]!==_0xd074('0x3d')){var _0x3d4c0c={};_0x3d4c0c[_0x44aa4c[_0xd074('0x2e')]]={'$like':'%'+_0x1ff785[_0xd074('0x30')][_0xd074('0x3e')]+'%'};return _0x3d4c0c;}})});}_0x252096=_[_0xd074('0x3c')]({},_0x252096,_0x1ff785['options']);var _0x1dddc4={'where':_0x252096[_0xd074('0x3b')]};return db[_0xd074('0x3f')][_0xd074('0x1e')](_0x1dddc4)[_0xd074('0x24')](function(_0x54cc1c){_0x489c8e[_0xd074('0x1e')]=_0x54cc1c;if(_0x1ff785[_0xd074('0x30')][_0xd074('0x40')]){_0x252096[_0xd074('0x41')]=[{'all':!![]}];}return db[_0xd074('0x3f')][_0xd074('0x42')](_0x252096);})[_0xd074('0x24')](function(_0x257e88){_0x489c8e['rows']=_0x257e88;return _0x489c8e;})[_0xd074('0x24')](respondWithFilteredResult(_0x2e2915,_0x252096))['catch'](handleError(_0x2e2915,null));};exports[_0xd074('0x43')]=function(_0x9e20a1,_0x4b0f6d){var _0x36545b={'raw':![],'where':{'id':_0x9e20a1[_0xd074('0x44')]['id']}},_0x2e4ce2={};_0x2e4ce2[_0xd074('0x2d')]=_[_0xd074('0x2f')](db[_0xd074('0x3f')]['rawAttributes']);_0x2e4ce2[_0xd074('0x30')]=_[_0xd074('0x2f')](_0x9e20a1['query']);_0x2e4ce2[_0xd074('0x3a')]=_[_0xd074('0x31')](_0x2e4ce2[_0xd074('0x2d')],_0x2e4ce2[_0xd074('0x30')]);_0x36545b[_0xd074('0x33')]=_['intersection'](_0x2e4ce2[_0xd074('0x2d')],qs[_0xd074('0x32')](_0x9e20a1['query'][_0xd074('0x32')]));_0x36545b[_0xd074('0x33')]=_0x36545b[_0xd074('0x33')]['length']?_0x36545b[_0xd074('0x33')]:_0x2e4ce2[_0xd074('0x2d')];if(_0x9e20a1[_0xd074('0x30')][_0xd074('0x40')]){_0x36545b['include']=[{'all':!![]}];}_0x36545b=_[_0xd074('0x3c')]({},_0x36545b,_0x9e20a1[_0xd074('0x45')]);return db['SugarcrmConfiguration'][_0xd074('0x46')](_0x36545b)[_0xd074('0x24')](handleEntityNotFound(_0x4b0f6d,null))['then'](respondWithResult(_0x4b0f6d,null))[_0xd074('0x47')](handleError(_0x4b0f6d,null));};exports[_0xd074('0x48')]=function(_0x499bdd,_0x4641e7){return db['SugarcrmConfiguration']['create'](_0x499bdd['body'],{})[_0xd074('0x24')](respondWithResult(_0x4641e7,0xc9))[_0xd074('0x47')](handleError(_0x4641e7,null));};exports[_0xd074('0x23')]=function(_0x3f306c,_0x5ae0ed){if(_0x3f306c[_0xd074('0x49')]['id']){delete _0x3f306c['body']['id'];}return db[_0xd074('0x3f')]['find']({'where':{'id':_0x3f306c[_0xd074('0x44')]['id']}})[_0xd074('0x24')](handleEntityNotFound(_0x5ae0ed,null))[_0xd074('0x24')](saveUpdates(_0x3f306c['body'],null))[_0xd074('0x24')](respondWithResult(_0x5ae0ed,null))['catch'](handleError(_0x5ae0ed,null));};exports[_0xd074('0x25')]=function(_0x5a26fd,_0x1be7f1){return db[_0xd074('0x3f')][_0xd074('0x46')]({'where':{'id':_0x5a26fd[_0xd074('0x44')]['id']}})[_0xd074('0x24')](handleEntityNotFound(_0x1be7f1,null))[_0xd074('0x24')](removeEntity(_0x1be7f1,null))['catch'](handleError(_0x1be7f1,null));};exports[_0xd074('0x4a')]=function(_0x10742e,_0x586e65,_0x3a7a53){var _0x7b6061={};var _0x4d7588={};var _0x1cb7c8;var _0x3526ea;return db[_0xd074('0x3f')][_0xd074('0x4b')]({'where':{'id':_0x10742e[_0xd074('0x44')]['id']}})[_0xd074('0x24')](handleEntityNotFound(_0x586e65,null))[_0xd074('0x24')](function(_0x5a493e){if(_0x5a493e){_0x1cb7c8=_0x5a493e;_0x4d7588['model']=_[_0xd074('0x2f')](db[_0xd074('0x4c')][_0xd074('0x2b')]);_0x4d7588[_0xd074('0x30')]=_[_0xd074('0x2f')](_0x10742e[_0xd074('0x30')]);_0x4d7588[_0xd074('0x3a')]=_[_0xd074('0x31')](_0x4d7588[_0xd074('0x2d')],_0x4d7588['query']);_0x7b6061[_0xd074('0x33')]=_[_0xd074('0x31')](_0x4d7588[_0xd074('0x2d')],qs['fields'](_0x10742e[_0xd074('0x30')][_0xd074('0x32')]));_0x7b6061[_0xd074('0x33')]=_0x7b6061[_0xd074('0x33')]['length']?_0x7b6061['attributes']:_0x4d7588[_0xd074('0x2d')];_0x7b6061[_0xd074('0x38')]=qs[_0xd074('0x39')](_0x10742e[_0xd074('0x30')]['sort']);_0x7b6061['where']=qs[_0xd074('0x3a')](_[_0xd074('0x4d')](_0x10742e[_0xd074('0x30')],_0x4d7588[_0xd074('0x3a')]));if(_0x10742e[_0xd074('0x30')][_0xd074('0x3e')]){_0x7b6061[_0xd074('0x3b')]=_[_0xd074('0x3c')](_0x7b6061['where'],{'$or':_[_0xd074('0x2a')](_0x7b6061['attributes'],function(_0x48bcfb){var _0x5b67b9={};_0x5b67b9[_0x48bcfb]={'$like':'%'+_0x10742e['query'][_0xd074('0x3e')]+'%'};return _0x5b67b9;})});}_0x7b6061=_[_0xd074('0x3c')]({},_0x7b6061,_0x10742e[_0xd074('0x45')]);return _0x1cb7c8[_0xd074('0x4a')](_0x7b6061);}})[_0xd074('0x24')](function(_0x4137b0){if(_0x4137b0){_0x3526ea=_0x4137b0[_0xd074('0x34')];if(!_0x10742e[_0xd074('0x30')][_0xd074('0x35')](_0xd074('0x36'))){_0x7b6061['limit']=qs[_0xd074('0x37')](_0x10742e[_0xd074('0x30')][_0xd074('0x37')]);_0x7b6061[_0xd074('0x1c')]=qs[_0xd074('0x1c')](_0x10742e['query']['offset']);}return _0x1cb7c8[_0xd074('0x4a')](_0x7b6061);}})[_0xd074('0x24')](function(_0xedff17){if(_0xedff17){return _0xedff17?{'count':_0x3526ea,'rows':_0xedff17}:null;}})[_0xd074('0x24')](respondWithResult(_0x586e65,null))[_0xd074('0x47')](handleError(_0x586e65,null));};exports['getSubjects']=function(_0x7cdba4,_0x4b183d,_0xe3e68){var _0x5c8bec={};var _0x5dfd24={};var _0x4de1f6;var _0x4fa51c;return db[_0xd074('0x3f')]['findOne']({'where':{'id':_0x7cdba4[_0xd074('0x44')]['id']}})[_0xd074('0x24')](handleEntityNotFound(_0x4b183d,null))['then'](function(_0x32c65d){if(_0x32c65d){_0x4de1f6=_0x32c65d;_0x5dfd24[_0xd074('0x2d')]=_[_0xd074('0x2f')](db[_0xd074('0x4c')]['rawAttributes']);_0x5dfd24[_0xd074('0x30')]=_[_0xd074('0x2f')](_0x7cdba4[_0xd074('0x30')]);_0x5dfd24[_0xd074('0x3a')]=_['intersection'](_0x5dfd24[_0xd074('0x2d')],_0x5dfd24[_0xd074('0x30')]);_0x5c8bec[_0xd074('0x33')]=_[_0xd074('0x31')](_0x5dfd24[_0xd074('0x2d')],qs['fields'](_0x7cdba4['query'][_0xd074('0x32')]));_0x5c8bec[_0xd074('0x33')]=_0x5c8bec[_0xd074('0x33')]['length']?_0x5c8bec['attributes']:_0x5dfd24['model'];_0x5c8bec[_0xd074('0x38')]=qs['sort'](_0x7cdba4[_0xd074('0x30')][_0xd074('0x39')]);_0x5c8bec['where']=qs[_0xd074('0x3a')](_[_0xd074('0x4d')](_0x7cdba4['query'],_0x5dfd24['filters']));if(_0x7cdba4['query']['filter']){_0x5c8bec[_0xd074('0x3b')]=_[_0xd074('0x3c')](_0x5c8bec[_0xd074('0x3b')],{'$or':_[_0xd074('0x2a')](_0x5c8bec['attributes'],function(_0x140967){var _0x491fcb={};_0x491fcb[_0x140967]={'$like':'%'+_0x7cdba4['query']['filter']+'%'};return _0x491fcb;})});}_0x5c8bec=_[_0xd074('0x3c')]({},_0x5c8bec,_0x7cdba4[_0xd074('0x45')]);return _0x4de1f6[_0xd074('0x4e')](_0x5c8bec);}})['then'](function(_0x15d50a){if(_0x15d50a){_0x4fa51c=_0x15d50a[_0xd074('0x34')];if(!_0x7cdba4['query']['hasOwnProperty'](_0xd074('0x36'))){_0x5c8bec['limit']=qs[_0xd074('0x37')](_0x7cdba4['query'][_0xd074('0x37')]);_0x5c8bec[_0xd074('0x1c')]=qs[_0xd074('0x1c')](_0x7cdba4['query']['offset']);}return _0x4de1f6['getSubjects'](_0x5c8bec);}})[_0xd074('0x24')](function(_0x219281){if(_0x219281){return _0x219281?{'count':_0x4fa51c,'rows':_0x219281}:null;}})[_0xd074('0x24')](respondWithResult(_0x4b183d,null))[_0xd074('0x47')](handleError(_0x4b183d,null));};exports[_0xd074('0x4f')]=function(_0x30e897,_0x116fa3,_0x52c2d3){var _0x24c764={};var _0x5c17df={};var _0x45e92f;var _0x5a3009;return db['SugarcrmConfiguration'][_0xd074('0x4b')]({'where':{'id':_0x30e897[_0xd074('0x44')]['id']}})[_0xd074('0x24')](handleEntityNotFound(_0x116fa3,null))[_0xd074('0x24')](function(_0xcfa7fe){if(_0xcfa7fe){_0x45e92f=_0xcfa7fe;_0x5c17df['model']=_['keys'](db['SugarcrmField'][_0xd074('0x2b')]);_0x5c17df['query']=_[_0xd074('0x2f')](_0x30e897[_0xd074('0x30')]);_0x5c17df['filters']=_['intersection'](_0x5c17df[_0xd074('0x2d')],_0x5c17df[_0xd074('0x30')]);_0x24c764[_0xd074('0x33')]=_[_0xd074('0x31')](_0x5c17df['model'],qs[_0xd074('0x32')](_0x30e897['query'][_0xd074('0x32')]));_0x24c764['attributes']=_0x24c764[_0xd074('0x33')][_0xd074('0x34')]?_0x24c764[_0xd074('0x33')]:_0x5c17df[_0xd074('0x2d')];_0x24c764[_0xd074('0x38')]=qs[_0xd074('0x39')](_0x30e897['query']['sort']);_0x24c764[_0xd074('0x3b')]=qs[_0xd074('0x3a')](_[_0xd074('0x4d')](_0x30e897[_0xd074('0x30')],_0x5c17df[_0xd074('0x3a')]));if(_0x30e897[_0xd074('0x30')][_0xd074('0x3e')]){_0x24c764[_0xd074('0x3b')]=_['merge'](_0x24c764[_0xd074('0x3b')],{'$or':_[_0xd074('0x2a')](_0x24c764[_0xd074('0x33')],function(_0x2cd9d3){var _0x4fbfe3={};_0x4fbfe3[_0x2cd9d3]={'$like':'%'+_0x30e897[_0xd074('0x30')][_0xd074('0x3e')]+'%'};return _0x4fbfe3;})});}_0x24c764=_[_0xd074('0x3c')]({},_0x24c764,_0x30e897['options']);return _0x45e92f[_0xd074('0x4f')](_0x24c764);}})[_0xd074('0x24')](function(_0x4d26b6){if(_0x4d26b6){_0x5a3009=_0x4d26b6[_0xd074('0x34')];if(!_0x30e897['query']['hasOwnProperty'](_0xd074('0x36'))){_0x24c764[_0xd074('0x37')]=qs['limit'](_0x30e897['query'][_0xd074('0x37')]);_0x24c764[_0xd074('0x1c')]=qs['offset'](_0x30e897['query'][_0xd074('0x1c')]);}return _0x45e92f[_0xd074('0x4f')](_0x24c764);}})[_0xd074('0x24')](function(_0x4ce9c3){if(_0x4ce9c3){return _0x4ce9c3?{'count':_0x5a3009,'rows':_0x4ce9c3}:null;}})[_0xd074('0x24')](respondWithResult(_0x116fa3,null))[_0xd074('0x47')](handleError(_0x116fa3,null));};
git://repos.xcallymotion.com / motion2.git / blob