18 var _0x3856=['index','map','SugarcrmConfiguration','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','sort','pick','where','merge','VIRTUAL','filter','options','includeAll','include','show','params','keys','find','create','body','destroy','findOne','SugarcrmField','order','getFields','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','jayson/promise','http','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~!@#$%^&-_=+[{]}.','request','then','info','SugarcrmConfiguration,\x20%s,\x20%s','request\x20sent','debug','stringify','error','code','message','result','catch','sendStatus','status','end','count','offset','set','Content-Range','json','apply','save','update','stack','name'];(function(_0x5b4d0f,_0x360126){var _0x2b9cfc=function(_0x5de52f){while(--_0x5de52f){_0x5b4d0f['push'](_0x5b4d0f['shift']());}};_0x2b9cfc(++_0x360126);}(_0x3856,0x19b));var _0x6385=function(_0x58dc25,_0x49b9d5){_0x58dc25=_0x58dc25-0x0;var _0x21b0a7=_0x3856[_0x58dc25];return _0x21b0a7;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x6385('0x0'));var rimraf=require(_0x6385('0x1'));var zipdir=require(_0x6385('0x2'));var jsonpatch=require(_0x6385('0x3'));var rp=require('request-promise');var moment=require(_0x6385('0x4'));var BPromise=require(_0x6385('0x5'));var Mustache=require(_0x6385('0x6'));var util=require(_0x6385('0x7'));var path=require(_0x6385('0x8'));var sox=require(_0x6385('0x9'));var csv=require(_0x6385('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x6385('0xb'));var squel=require(_0x6385('0xc'));var crypto=require('crypto');var jsforce=require(_0x6385('0xd'));var deskjs=require(_0x6385('0xe'));var toCsv=require(_0x6385('0xa'));var querystring=require(_0x6385('0xf'));var Papa=require(_0x6385('0x10'));var Redis=require(_0x6385('0x11'));var authService=require(_0x6385('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x6385('0x13'));var hardwareService=require(_0x6385('0x14'));var logger=require(_0x6385('0x15'))(_0x6385('0x16'));var utils=require('../../config/utils');var config=require(_0x6385('0x17'));var db=require(_0x6385('0x18'))['db'];var jayson=require(_0x6385('0x19'));var client=jayson['client'][_0x6385('0x1a')]({'port':0x232a});function checkPasswordPattern(_0x4bce49,_0x539dc4,_0x12a035){if(_0x12a035){var _0x1d5cb3=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x1d5cb3['test'](_0x539dc4)){return _0x4bce49;}else{throw new db[(_0x6385('0x1b'))]['ValidationError'](_0x6385('0x1c'));}}else{return _0x4bce49;}}function respondWithRpcPromise(_0x383e0e,_0x533ad6,_0x4772d1,_0x19d7e7){return new BPromise(function(_0x1251f0,_0x5dea05){var _0x14be06=_0x19d7e7||client;return _0x14be06[_0x6385('0x1d')](_0x383e0e,_0x4772d1)[_0x6385('0x1e')](function(_0x23354c){logger[_0x6385('0x1f')](_0x6385('0x20'),_0x533ad6,_0x6385('0x21'));logger[_0x6385('0x22')]('SugarcrmConfiguration,\x20%s,\x20%s,\x20%s',_0x533ad6,_0x6385('0x21'),JSON[_0x6385('0x23')](_0x23354c));if(_0x23354c[_0x6385('0x24')]){if(_0x23354c['error'][_0x6385('0x25')]===0x1f4){logger[_0x6385('0x24')](_0x6385('0x20'),_0x533ad6,_0x23354c[_0x6385('0x24')][_0x6385('0x26')]);return _0x5dea05(_0x23354c[_0x6385('0x24')][_0x6385('0x26')]);}logger['error'](_0x6385('0x20'),_0x533ad6,_0x23354c['error'][_0x6385('0x26')]);return _0x1251f0(_0x23354c[_0x6385('0x24')][_0x6385('0x26')]);}else{logger[_0x6385('0x1f')](_0x6385('0x20'),_0x533ad6,'request\x20sent');_0x1251f0(_0x23354c[_0x6385('0x27')][_0x6385('0x26')]);}})[_0x6385('0x28')](function(_0x429759){logger['error'](_0x6385('0x20'),_0x533ad6,_0x429759);_0x5dea05(_0x429759);});});}function respondWithStatusCode(_0x367b4f,_0x39f817){_0x39f817=_0x39f817||0xcc;return function(_0x26eb76){if(_0x26eb76){return _0x367b4f[_0x6385('0x29')](_0x39f817);}return _0x367b4f[_0x6385('0x2a')](_0x39f817)[_0x6385('0x2b')]();};}function respondWithResult(_0x51c51d,_0x4c3cd8){_0x4c3cd8=_0x4c3cd8||0xc8;return function(_0x148b13){if(_0x148b13){return _0x51c51d[_0x6385('0x2a')](_0x4c3cd8)['json'](_0x148b13);}};}function respondWithFilteredResult(_0x53522d,_0xcbedfc){return function(_0xa93f96){if(_0xa93f96){var _0x2c11ae=_0xa93f96[_0x6385('0x2c')],_0x42d001=_0xcbedfc['offset'],_0x459313=_0xcbedfc[_0x6385('0x2d')]+_0xcbedfc['limit'],_0x3b6309;if(_0x459313>=_0x2c11ae){_0x459313=_0x2c11ae;_0x3b6309=0xc8;}else{_0x3b6309=0xce;}_0x53522d[_0x6385('0x2a')](_0x3b6309);return _0x53522d[_0x6385('0x2e')](_0x6385('0x2f'),_0x42d001+'-'+_0x459313+'/'+_0x2c11ae)[_0x6385('0x30')](_0xa93f96);}return null;};}function patchUpdates(_0x2300a6){return function(_0x33944e){try{jsonpatch[_0x6385('0x31')](_0x33944e,_0x2300a6,!![]);}catch(_0x4c53ac){return BPromise['reject'](_0x4c53ac);}return _0x33944e[_0x6385('0x32')]();};}function saveUpdates(_0x561120,_0x23fae5){return function(_0x3a3b7b){if(_0x3a3b7b){return _0x3a3b7b[_0x6385('0x33')](_0x561120)[_0x6385('0x1e')](function(_0x5649c2){return _0x5649c2;});}return null;};}function removeEntity(_0x434600,_0x406d1b){return function(_0x1f04c){if(_0x1f04c){return _0x1f04c['destroy']()['then'](function(){_0x434600['status'](0xcc)[_0x6385('0x2b')]();});}};}function handleEntityNotFound(_0x44fe47,_0x40f686){return function(_0x1c7b75){if(!_0x1c7b75){_0x44fe47['sendStatus'](0x194);}return _0x1c7b75;};}function handleError(_0x40aa0a,_0x483fa0){_0x483fa0=_0x483fa0||0x1f4;return function(_0x418e18){logger[_0x6385('0x24')](_0x418e18[_0x6385('0x34')]);if(_0x418e18[_0x6385('0x35')]){delete _0x418e18[_0x6385('0x35')];}_0x40aa0a[_0x6385('0x2a')](_0x483fa0)['send'](_0x418e18);};}exports[_0x6385('0x36')]=function(_0x132c6a,_0x455bac){var _0x359745={},_0x5f9eb4={},_0x29a5ee={'count':0x0,'rows':[]};var _0x2a365a=_[_0x6385('0x37')](db[_0x6385('0x38')][_0x6385('0x39')],function(_0x1a5d05){return{'name':_0x1a5d05[_0x6385('0x3a')],'type':_0x1a5d05[_0x6385('0x3b')][_0x6385('0x3c')]};});_0x5f9eb4[_0x6385('0x3d')]=_[_0x6385('0x37')](_0x2a365a,_0x6385('0x35'));_0x5f9eb4[_0x6385('0x3e')]=_['keys'](_0x132c6a[_0x6385('0x3e')]);_0x5f9eb4[_0x6385('0x3f')]=_[_0x6385('0x40')](_0x5f9eb4['model'],_0x5f9eb4[_0x6385('0x3e')]);_0x359745[_0x6385('0x41')]=_[_0x6385('0x40')](_0x5f9eb4[_0x6385('0x3d')],qs[_0x6385('0x42')](_0x132c6a[_0x6385('0x3e')][_0x6385('0x42')]));_0x359745[_0x6385('0x41')]=_0x359745[_0x6385('0x41')][_0x6385('0x43')]?_0x359745[_0x6385('0x41')]:_0x5f9eb4[_0x6385('0x3d')];if(!_0x132c6a[_0x6385('0x3e')][_0x6385('0x44')](_0x6385('0x45'))){_0x359745[_0x6385('0x46')]=qs[_0x6385('0x46')](_0x132c6a[_0x6385('0x3e')][_0x6385('0x46')]);_0x359745[_0x6385('0x2d')]=qs[_0x6385('0x2d')](_0x132c6a['query'][_0x6385('0x2d')]);}_0x359745['order']=qs[_0x6385('0x47')](_0x132c6a[_0x6385('0x3e')]['sort']);_0x359745['where']=qs[_0x6385('0x3f')](_[_0x6385('0x48')](_0x132c6a[_0x6385('0x3e')],_0x5f9eb4[_0x6385('0x3f')]),_0x2a365a);if(_0x132c6a[_0x6385('0x3e')]['filter']){_0x359745[_0x6385('0x49')]=_[_0x6385('0x4a')](_0x359745[_0x6385('0x49')],{'$or':_['map'](_0x2a365a,function(_0x54bf35){if(_0x54bf35[_0x6385('0x3b')]!==_0x6385('0x4b')){var _0x3ef9c1={};_0x3ef9c1[_0x54bf35[_0x6385('0x35')]]={'$like':'%'+_0x132c6a[_0x6385('0x3e')][_0x6385('0x4c')]+'%'};return _0x3ef9c1;}})});}_0x359745=_[_0x6385('0x4a')]({},_0x359745,_0x132c6a[_0x6385('0x4d')]);var _0x2646ff={'where':_0x359745[_0x6385('0x49')]};return db[_0x6385('0x38')][_0x6385('0x2c')](_0x2646ff)[_0x6385('0x1e')](function(_0x1a25c8){_0x29a5ee['count']=_0x1a25c8;if(_0x132c6a['query'][_0x6385('0x4e')]){_0x359745[_0x6385('0x4f')]=[{'all':!![]}];}return db[_0x6385('0x38')]['findAll'](_0x359745);})[_0x6385('0x1e')](function(_0x4199f0){_0x29a5ee['rows']=_0x4199f0;return _0x29a5ee;})[_0x6385('0x1e')](respondWithFilteredResult(_0x455bac,_0x359745))[_0x6385('0x28')](handleError(_0x455bac,null));};exports[_0x6385('0x50')]=function(_0x5ee172,_0x3e5b73){var _0x28247b={'raw':![],'where':{'id':_0x5ee172[_0x6385('0x51')]['id']}},_0xc6364b={};_0xc6364b[_0x6385('0x3d')]=_['keys'](db[_0x6385('0x38')][_0x6385('0x39')]);_0xc6364b[_0x6385('0x3e')]=_[_0x6385('0x52')](_0x5ee172[_0x6385('0x3e')]);_0xc6364b['filters']=_[_0x6385('0x40')](_0xc6364b[_0x6385('0x3d')],_0xc6364b[_0x6385('0x3e')]);_0x28247b['attributes']=_[_0x6385('0x40')](_0xc6364b[_0x6385('0x3d')],qs[_0x6385('0x42')](_0x5ee172[_0x6385('0x3e')]['fields']));_0x28247b[_0x6385('0x41')]=_0x28247b[_0x6385('0x41')][_0x6385('0x43')]?_0x28247b['attributes']:_0xc6364b[_0x6385('0x3d')];if(_0x5ee172[_0x6385('0x3e')]['includeAll']){_0x28247b[_0x6385('0x4f')]=[{'all':!![]}];}_0x28247b=_['merge']({},_0x28247b,_0x5ee172[_0x6385('0x4d')]);return db[_0x6385('0x38')][_0x6385('0x53')](_0x28247b)[_0x6385('0x1e')](handleEntityNotFound(_0x3e5b73,null))[_0x6385('0x1e')](respondWithResult(_0x3e5b73,null))['catch'](handleError(_0x3e5b73,null));};exports[_0x6385('0x54')]=function(_0x336755,_0x1df87c){return db['SugarcrmConfiguration'][_0x6385('0x54')](_0x336755[_0x6385('0x55')],{})[_0x6385('0x1e')](respondWithResult(_0x1df87c,0xc9))[_0x6385('0x28')](handleError(_0x1df87c,null));};exports['update']=function(_0x45737a,_0x45d295){if(_0x45737a[_0x6385('0x55')]['id']){delete _0x45737a['body']['id'];}return db['SugarcrmConfiguration'][_0x6385('0x53')]({'where':{'id':_0x45737a[_0x6385('0x51')]['id']}})[_0x6385('0x1e')](handleEntityNotFound(_0x45d295,null))[_0x6385('0x1e')](saveUpdates(_0x45737a['body'],null))[_0x6385('0x1e')](respondWithResult(_0x45d295,null))[_0x6385('0x28')](handleError(_0x45d295,null));};exports[_0x6385('0x56')]=function(_0x126da0,_0x5be5a1){return db['SugarcrmConfiguration'][_0x6385('0x53')]({'where':{'id':_0x126da0[_0x6385('0x51')]['id']}})[_0x6385('0x1e')](handleEntityNotFound(_0x5be5a1,null))[_0x6385('0x1e')](removeEntity(_0x5be5a1,null))[_0x6385('0x28')](handleError(_0x5be5a1,null));};exports['getFields']=function(_0x57ac87,_0x2b5f4d,_0x48a22f){var _0x14059b={};var _0x5c012d={};var _0x4cc6a3;var _0x4cf33f;return db['SugarcrmConfiguration'][_0x6385('0x57')]({'where':{'id':_0x57ac87['params']['id']}})[_0x6385('0x1e')](handleEntityNotFound(_0x2b5f4d,null))[_0x6385('0x1e')](function(_0x45e6e9){if(_0x45e6e9){_0x4cc6a3=_0x45e6e9;_0x5c012d[_0x6385('0x3d')]=_[_0x6385('0x52')](db[_0x6385('0x58')][_0x6385('0x39')]);_0x5c012d[_0x6385('0x3e')]=_[_0x6385('0x52')](_0x57ac87[_0x6385('0x3e')]);_0x5c012d[_0x6385('0x3f')]=_[_0x6385('0x40')](_0x5c012d['model'],_0x5c012d[_0x6385('0x3e')]);_0x14059b[_0x6385('0x41')]=_[_0x6385('0x40')](_0x5c012d[_0x6385('0x3d')],qs[_0x6385('0x42')](_0x57ac87['query'][_0x6385('0x42')]));_0x14059b[_0x6385('0x41')]=_0x14059b[_0x6385('0x41')][_0x6385('0x43')]?_0x14059b[_0x6385('0x41')]:_0x5c012d[_0x6385('0x3d')];_0x14059b[_0x6385('0x59')]=qs[_0x6385('0x47')](_0x57ac87[_0x6385('0x3e')][_0x6385('0x47')]);_0x14059b[_0x6385('0x49')]=qs[_0x6385('0x3f')](_['pick'](_0x57ac87[_0x6385('0x3e')],_0x5c012d[_0x6385('0x3f')]));if(_0x57ac87[_0x6385('0x3e')][_0x6385('0x4c')]){_0x14059b[_0x6385('0x49')]=_['merge'](_0x14059b[_0x6385('0x49')],{'$or':_[_0x6385('0x37')](_0x14059b['attributes'],function(_0x1aa0d6){var _0xd2fa0f={};_0xd2fa0f[_0x1aa0d6]={'$like':'%'+_0x57ac87[_0x6385('0x3e')]['filter']+'%'};return _0xd2fa0f;})});}_0x14059b=_['merge']({},_0x14059b,_0x57ac87[_0x6385('0x4d')]);return _0x4cc6a3[_0x6385('0x5a')](_0x14059b);}})[_0x6385('0x1e')](function(_0x4aa573){if(_0x4aa573){_0x4cf33f=_0x4aa573[_0x6385('0x43')];if(!_0x57ac87[_0x6385('0x3e')][_0x6385('0x44')](_0x6385('0x45'))){_0x14059b[_0x6385('0x46')]=qs['limit'](_0x57ac87[_0x6385('0x3e')][_0x6385('0x46')]);_0x14059b[_0x6385('0x2d')]=qs[_0x6385('0x2d')](_0x57ac87[_0x6385('0x3e')][_0x6385('0x2d')]);}return _0x4cc6a3[_0x6385('0x5a')](_0x14059b);}})[_0x6385('0x1e')](function(_0x5295ce){if(_0x5295ce){return _0x5295ce?{'count':_0x4cf33f,'rows':_0x5295ce}:null;}})[_0x6385('0x1e')](respondWithResult(_0x2b5f4d,null))[_0x6385('0x28')](handleError(_0x2b5f4d,null));};exports[_0x6385('0x5b')]=function(_0x3bbdf2,_0x33221e,_0x38ca34){var _0x45fd11={};var _0x215beb={};var _0x51d795;var _0x190fe2;return db['SugarcrmConfiguration']['findOne']({'where':{'id':_0x3bbdf2[_0x6385('0x51')]['id']}})[_0x6385('0x1e')](handleEntityNotFound(_0x33221e,null))[_0x6385('0x1e')](function(_0x12be4c){if(_0x12be4c){_0x51d795=_0x12be4c;_0x215beb[_0x6385('0x3d')]=_[_0x6385('0x52')](db[_0x6385('0x58')][_0x6385('0x39')]);_0x215beb[_0x6385('0x3e')]=_[_0x6385('0x52')](_0x3bbdf2[_0x6385('0x3e')]);_0x215beb[_0x6385('0x3f')]=_[_0x6385('0x40')](_0x215beb[_0x6385('0x3d')],_0x215beb[_0x6385('0x3e')]);_0x45fd11[_0x6385('0x41')]=_[_0x6385('0x40')](_0x215beb[_0x6385('0x3d')],qs[_0x6385('0x42')](_0x3bbdf2[_0x6385('0x3e')][_0x6385('0x42')]));_0x45fd11['attributes']=_0x45fd11[_0x6385('0x41')][_0x6385('0x43')]?_0x45fd11[_0x6385('0x41')]:_0x215beb[_0x6385('0x3d')];_0x45fd11[_0x6385('0x59')]=qs[_0x6385('0x47')](_0x3bbdf2[_0x6385('0x3e')][_0x6385('0x47')]);_0x45fd11['where']=qs[_0x6385('0x3f')](_['pick'](_0x3bbdf2['query'],_0x215beb[_0x6385('0x3f')]));if(_0x3bbdf2[_0x6385('0x3e')][_0x6385('0x4c')]){_0x45fd11[_0x6385('0x49')]=_[_0x6385('0x4a')](_0x45fd11[_0x6385('0x49')],{'$or':_[_0x6385('0x37')](_0x45fd11[_0x6385('0x41')],function(_0x33614a){var _0x572d7d={};_0x572d7d[_0x33614a]={'$like':'%'+_0x3bbdf2[_0x6385('0x3e')]['filter']+'%'};return _0x572d7d;})});}_0x45fd11=_[_0x6385('0x4a')]({},_0x45fd11,_0x3bbdf2[_0x6385('0x4d')]);return _0x51d795['getSubjects'](_0x45fd11);}})[_0x6385('0x1e')](function(_0x248bb4){if(_0x248bb4){_0x190fe2=_0x248bb4[_0x6385('0x43')];if(!_0x3bbdf2[_0x6385('0x3e')][_0x6385('0x44')](_0x6385('0x45'))){_0x45fd11[_0x6385('0x46')]=qs[_0x6385('0x46')](_0x3bbdf2[_0x6385('0x3e')][_0x6385('0x46')]);_0x45fd11[_0x6385('0x2d')]=qs[_0x6385('0x2d')](_0x3bbdf2[_0x6385('0x3e')]['offset']);}return _0x51d795[_0x6385('0x5b')](_0x45fd11);}})[_0x6385('0x1e')](function(_0x493c4e){if(_0x493c4e){return _0x493c4e?{'count':_0x190fe2,'rows':_0x493c4e}:null;}})[_0x6385('0x1e')](respondWithResult(_0x33221e,null))[_0x6385('0x28')](handleError(_0x33221e,null));};exports[_0x6385('0x5c')]=function(_0x3524e3,_0x3a9543,_0x3f049a){var _0x346ff4={};var _0x59af4d={};var _0x4330f7;var _0x3d60eb;return db[_0x6385('0x38')][_0x6385('0x57')]({'where':{'id':_0x3524e3['params']['id']}})[_0x6385('0x1e')](handleEntityNotFound(_0x3a9543,null))[_0x6385('0x1e')](function(_0x285ca0){if(_0x285ca0){_0x4330f7=_0x285ca0;_0x59af4d[_0x6385('0x3d')]=_['keys'](db[_0x6385('0x58')]['rawAttributes']);_0x59af4d[_0x6385('0x3e')]=_[_0x6385('0x52')](_0x3524e3[_0x6385('0x3e')]);_0x59af4d['filters']=_[_0x6385('0x40')](_0x59af4d['model'],_0x59af4d['query']);_0x346ff4[_0x6385('0x41')]=_[_0x6385('0x40')](_0x59af4d[_0x6385('0x3d')],qs['fields'](_0x3524e3[_0x6385('0x3e')]['fields']));_0x346ff4[_0x6385('0x41')]=_0x346ff4[_0x6385('0x41')]['length']?_0x346ff4[_0x6385('0x41')]:_0x59af4d[_0x6385('0x3d')];_0x346ff4[_0x6385('0x59')]=qs['sort'](_0x3524e3[_0x6385('0x3e')][_0x6385('0x47')]);_0x346ff4[_0x6385('0x49')]=qs[_0x6385('0x3f')](_[_0x6385('0x48')](_0x3524e3['query'],_0x59af4d['filters']));if(_0x3524e3[_0x6385('0x3e')]['filter']){_0x346ff4[_0x6385('0x49')]=_['merge'](_0x346ff4[_0x6385('0x49')],{'$or':_[_0x6385('0x37')](_0x346ff4['attributes'],function(_0x15ea51){var _0x5f0dad={};_0x5f0dad[_0x15ea51]={'$like':'%'+_0x3524e3[_0x6385('0x3e')][_0x6385('0x4c')]+'%'};return _0x5f0dad;})});}_0x346ff4=_[_0x6385('0x4a')]({},_0x346ff4,_0x3524e3['options']);return _0x4330f7['getDescriptions'](_0x346ff4);}})[_0x6385('0x1e')](function(_0x44162b){if(_0x44162b){_0x3d60eb=_0x44162b[_0x6385('0x43')];if(!_0x3524e3[_0x6385('0x3e')]['hasOwnProperty'](_0x6385('0x45'))){_0x346ff4[_0x6385('0x46')]=qs[_0x6385('0x46')](_0x3524e3[_0x6385('0x3e')][_0x6385('0x46')]);_0x346ff4[_0x6385('0x2d')]=qs['offset'](_0x3524e3['query'][_0x6385('0x2d')]);}return _0x4330f7[_0x6385('0x5c')](_0x346ff4);}})[_0x6385('0x1e')](function(_0x324cd3){if(_0x324cd3){return _0x324cd3?{'count':_0x3d60eb,'rows':_0x324cd3}:null;}})['then'](respondWithResult(_0x3a9543,null))[_0x6385('0x28')](handleError(_0x3a9543,null));};
git://repos.xcallymotion.com / motion2.git / blob