// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4aa1=['rawAttributes','fieldName','type','key','model','map','name','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','includeAll','include','SugarcrmConfiguration','findAll','rows','show','params','find','catch','create','body','findOne','SugarcrmField','getSubjects','getDescriptions','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../mysqldb','jayson/promise','http','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','result','sendStatus','status','count','offset','limit','set','Content-Range','json','apply','reject','save','update','then','end','send','index'];(function(_0xd72a8c,_0x4252bd){var _0x1afd68=function(_0x34c666){while(--_0x34c666){_0xd72a8c['push'](_0xd72a8c['shift']());}};_0x1afd68(++_0x4252bd);}(_0x4aa1,0x13a));var _0x14aa=function(_0x451d29,_0x187163){_0x451d29=_0x451d29-0x0;var _0x87fea5=_0x4aa1[_0x451d29];return _0x87fea5;};'use strict';var pdf=require(_0x14aa('0x0'));var emlformat=require(_0x14aa('0x1'));var rimraf=require(_0x14aa('0x2'));var zipdir=require(_0x14aa('0x3'));var jsonpatch=require(_0x14aa('0x4'));var rp=require(_0x14aa('0x5'));var moment=require(_0x14aa('0x6'));var BPromise=require(_0x14aa('0x7'));var Mustache=require(_0x14aa('0x8'));var util=require(_0x14aa('0x9'));var path=require('path');var sox=require(_0x14aa('0xa'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x14aa('0xb'));var squel=require(_0x14aa('0xc'));var crypto=require(_0x14aa('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x14aa('0xe'));var toCsv=require('to-csv');var querystring=require(_0x14aa('0xf'));var Papa=require(_0x14aa('0x10'));var Redis=require(_0x14aa('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x14aa('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x14aa('0x13'));var logger=require(_0x14aa('0x14'))(_0x14aa('0x15'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require(_0x14aa('0x16'))['db'];var jayson=require(_0x14aa('0x17'));var client=jayson['client'][_0x14aa('0x18')]({'port':0x232a});function checkPasswordPattern(_0x3f2e7a,_0x50a8c5,_0x2889e8){if(_0x2889e8){var _0x3364e8=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x3364e8['test'](_0x50a8c5)){return _0x3f2e7a;}else{throw new db[(_0x14aa('0x19'))][(_0x14aa('0x1a'))](_0x14aa('0x1b'));}}else{return _0x3f2e7a;}}function respondWithRpcPromise(_0x4e52f2,_0x4f5579,_0xc9a045,_0x2cb9b6){return new BPromise(function(_0x42f0aa,_0x5288f1){var _0x1b38df=_0x2cb9b6||client;return _0x1b38df[_0x14aa('0x1c')](_0x4e52f2,_0xc9a045)['then'](function(_0x6a069b){logger[_0x14aa('0x1d')](_0x14aa('0x1e'),_0x4f5579,_0x14aa('0x1f'));logger[_0x14aa('0x20')](_0x14aa('0x21'),_0x4f5579,_0x14aa('0x1f'),JSON['stringify'](_0x6a069b));if(_0x6a069b[_0x14aa('0x22')]){if(_0x6a069b['error'][_0x14aa('0x23')]===0x1f4){logger[_0x14aa('0x22')](_0x14aa('0x1e'),_0x4f5579,_0x6a069b[_0x14aa('0x22')][_0x14aa('0x24')]);return _0x5288f1(_0x6a069b['error']['message']);}logger[_0x14aa('0x22')](_0x14aa('0x1e'),_0x4f5579,_0x6a069b[_0x14aa('0x22')][_0x14aa('0x24')]);return _0x42f0aa(_0x6a069b[_0x14aa('0x22')][_0x14aa('0x24')]);}else{logger['info'](_0x14aa('0x1e'),_0x4f5579,_0x14aa('0x1f'));_0x42f0aa(_0x6a069b[_0x14aa('0x25')][_0x14aa('0x24')]);}})['catch'](function(_0x3ea819){logger[_0x14aa('0x22')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x4f5579,_0x3ea819);_0x5288f1(_0x3ea819);});});}function respondWithStatusCode(_0x106e2d,_0xa6679f){_0xa6679f=_0xa6679f||0xcc;return function(_0x1f3d1e){if(_0x1f3d1e){return _0x106e2d[_0x14aa('0x26')](_0xa6679f);}return _0x106e2d[_0x14aa('0x27')](_0xa6679f)['end']();};}function respondWithResult(_0x31ed50,_0x3625e5){_0x3625e5=_0x3625e5||0xc8;return function(_0x3b7787){if(_0x3b7787){return _0x31ed50[_0x14aa('0x27')](_0x3625e5)['json'](_0x3b7787);}};}function respondWithFilteredResult(_0x597fa0,_0x176bd7){return function(_0x1c3fe4){if(_0x1c3fe4){var _0x52f05c=_0x1c3fe4[_0x14aa('0x28')],_0x52b275=_0x176bd7[_0x14aa('0x29')],_0x59f4d3=_0x176bd7[_0x14aa('0x29')]+_0x176bd7[_0x14aa('0x2a')],_0x1208e9;if(_0x59f4d3>=_0x52f05c){_0x59f4d3=_0x52f05c;_0x1208e9=0xc8;}else{_0x1208e9=0xce;}_0x597fa0[_0x14aa('0x27')](_0x1208e9);return _0x597fa0[_0x14aa('0x2b')](_0x14aa('0x2c'),_0x52b275+'-'+_0x59f4d3+'/'+_0x52f05c)[_0x14aa('0x2d')](_0x1c3fe4);}return null;};}function patchUpdates(_0x49e7f5){return function(_0x5539e5){try{jsonpatch[_0x14aa('0x2e')](_0x5539e5,_0x49e7f5,!![]);}catch(_0x518992){return BPromise[_0x14aa('0x2f')](_0x518992);}return _0x5539e5[_0x14aa('0x30')]();};}function saveUpdates(_0x198f86,_0x476f65){return function(_0x5915f2){if(_0x5915f2){return _0x5915f2[_0x14aa('0x31')](_0x198f86)[_0x14aa('0x32')](function(_0x44b3ab){return _0x44b3ab;});}return null;};}function removeEntity(_0x2bcec8,_0x350e81){return function(_0x51fbd4){if(_0x51fbd4){return _0x51fbd4['destroy']()[_0x14aa('0x32')](function(){_0x2bcec8[_0x14aa('0x27')](0xcc)[_0x14aa('0x33')]();});}};}function handleEntityNotFound(_0x39ea99,_0x375a3e){return function(_0x434a7a){if(!_0x434a7a){_0x39ea99['sendStatus'](0x194);}return _0x434a7a;};}function handleError(_0x2fbe04,_0x5d65ad){_0x5d65ad=_0x5d65ad||0x1f4;return function(_0x402838){logger['error'](_0x402838['stack']);if(_0x402838['name']){delete _0x402838['name'];}_0x2fbe04['status'](_0x5d65ad)[_0x14aa('0x34')](_0x402838);};}exports[_0x14aa('0x35')]=function(_0x19ee6d,_0x4e3a8d){var _0xf4638b={},_0x7700ac={},_0x3ce1fb={'count':0x0,'rows':[]};var _0x440ba2=_['map'](db['SugarcrmConfiguration'][_0x14aa('0x36')],function(_0x18d644){return{'name':_0x18d644[_0x14aa('0x37')],'type':_0x18d644[_0x14aa('0x38')][_0x14aa('0x39')]};});_0x7700ac[_0x14aa('0x3a')]=_[_0x14aa('0x3b')](_0x440ba2,_0x14aa('0x3c'));_0x7700ac[_0x14aa('0x3d')]=_[_0x14aa('0x3e')](_0x19ee6d['query']);_0x7700ac[_0x14aa('0x3f')]=_['intersection'](_0x7700ac[_0x14aa('0x3a')],_0x7700ac['query']);_0xf4638b['attributes']=_[_0x14aa('0x40')](_0x7700ac[_0x14aa('0x3a')],qs[_0x14aa('0x41')](_0x19ee6d['query'][_0x14aa('0x41')]));_0xf4638b[_0x14aa('0x42')]=_0xf4638b['attributes'][_0x14aa('0x43')]?_0xf4638b[_0x14aa('0x42')]:_0x7700ac[_0x14aa('0x3a')];if(!_0x19ee6d[_0x14aa('0x3d')][_0x14aa('0x44')](_0x14aa('0x45'))){_0xf4638b[_0x14aa('0x2a')]=qs[_0x14aa('0x2a')](_0x19ee6d[_0x14aa('0x3d')][_0x14aa('0x2a')]);_0xf4638b[_0x14aa('0x29')]=qs[_0x14aa('0x29')](_0x19ee6d[_0x14aa('0x3d')][_0x14aa('0x29')]);}_0xf4638b[_0x14aa('0x46')]=qs[_0x14aa('0x47')](_0x19ee6d[_0x14aa('0x3d')]['sort']);_0xf4638b[_0x14aa('0x48')]=qs[_0x14aa('0x3f')](_[_0x14aa('0x49')](_0x19ee6d['query'],_0x7700ac[_0x14aa('0x3f')]),_0x440ba2);if(_0x19ee6d[_0x14aa('0x3d')][_0x14aa('0x4a')]){_0xf4638b[_0x14aa('0x48')]=_[_0x14aa('0x4b')](_0xf4638b[_0x14aa('0x48')],{'$or':_[_0x14aa('0x3b')](_0x440ba2,function(_0x5c9dc8){if(_0x5c9dc8[_0x14aa('0x38')]!=='VIRTUAL'){var _0x551fd8={};_0x551fd8[_0x5c9dc8['name']]={'$like':'%'+_0x19ee6d[_0x14aa('0x3d')][_0x14aa('0x4a')]+'%'};return _0x551fd8;}})});}_0xf4638b=_[_0x14aa('0x4b')]({},_0xf4638b,_0x19ee6d[_0x14aa('0x4c')]);var _0x3ce31f={'where':_0xf4638b[_0x14aa('0x48')]};return db['SugarcrmConfiguration']['count'](_0x3ce31f)[_0x14aa('0x32')](function(_0x33e5b5){_0x3ce1fb[_0x14aa('0x28')]=_0x33e5b5;if(_0x19ee6d[_0x14aa('0x3d')][_0x14aa('0x4d')]){_0xf4638b[_0x14aa('0x4e')]=[{'all':!![]}];}return db[_0x14aa('0x4f')][_0x14aa('0x50')](_0xf4638b);})[_0x14aa('0x32')](function(_0xa84b2d){_0x3ce1fb[_0x14aa('0x51')]=_0xa84b2d;return _0x3ce1fb;})[_0x14aa('0x32')](respondWithFilteredResult(_0x4e3a8d,_0xf4638b))['catch'](handleError(_0x4e3a8d,null));};exports[_0x14aa('0x52')]=function(_0x2da832,_0x414144){var _0x1b8d83={'raw':![],'where':{'id':_0x2da832[_0x14aa('0x53')]['id']}},_0x413966={};_0x413966[_0x14aa('0x3a')]=_[_0x14aa('0x3e')](db[_0x14aa('0x4f')]['rawAttributes']);_0x413966['query']=_[_0x14aa('0x3e')](_0x2da832[_0x14aa('0x3d')]);_0x413966[_0x14aa('0x3f')]=_[_0x14aa('0x40')](_0x413966['model'],_0x413966[_0x14aa('0x3d')]);_0x1b8d83[_0x14aa('0x42')]=_[_0x14aa('0x40')](_0x413966[_0x14aa('0x3a')],qs[_0x14aa('0x41')](_0x2da832['query'][_0x14aa('0x41')]));_0x1b8d83[_0x14aa('0x42')]=_0x1b8d83['attributes'][_0x14aa('0x43')]?_0x1b8d83[_0x14aa('0x42')]:_0x413966[_0x14aa('0x3a')];if(_0x2da832[_0x14aa('0x3d')][_0x14aa('0x4d')]){_0x1b8d83['include']=[{'all':!![]}];}_0x1b8d83=_[_0x14aa('0x4b')]({},_0x1b8d83,_0x2da832['options']);return db['SugarcrmConfiguration'][_0x14aa('0x54')](_0x1b8d83)[_0x14aa('0x32')](handleEntityNotFound(_0x414144,null))[_0x14aa('0x32')](respondWithResult(_0x414144,null))[_0x14aa('0x55')](handleError(_0x414144,null));};exports[_0x14aa('0x56')]=function(_0x13ca05,_0x1b1b89){return db[_0x14aa('0x4f')][_0x14aa('0x56')](_0x13ca05[_0x14aa('0x57')],{})['then'](respondWithResult(_0x1b1b89,0xc9))[_0x14aa('0x55')](handleError(_0x1b1b89,null));};exports[_0x14aa('0x31')]=function(_0x71143,_0xe1731b){if(_0x71143[_0x14aa('0x57')]['id']){delete _0x71143[_0x14aa('0x57')]['id'];}return db[_0x14aa('0x4f')]['find']({'where':{'id':_0x71143[_0x14aa('0x53')]['id']}})[_0x14aa('0x32')](handleEntityNotFound(_0xe1731b,null))[_0x14aa('0x32')](saveUpdates(_0x71143['body'],null))[_0x14aa('0x32')](respondWithResult(_0xe1731b,null))[_0x14aa('0x55')](handleError(_0xe1731b,null));};exports['destroy']=function(_0x30abd0,_0x585eee){return db[_0x14aa('0x4f')][_0x14aa('0x54')]({'where':{'id':_0x30abd0[_0x14aa('0x53')]['id']}})[_0x14aa('0x32')](handleEntityNotFound(_0x585eee,null))['then'](removeEntity(_0x585eee,null))['catch'](handleError(_0x585eee,null));};exports['getFields']=function(_0x1f3095,_0x3962a8,_0x527fd8){var _0x58bbe7={};var _0x55bc0e={};var _0x47be4f;var _0x45a781;return db['SugarcrmConfiguration'][_0x14aa('0x58')]({'where':{'id':_0x1f3095[_0x14aa('0x53')]['id']}})[_0x14aa('0x32')](handleEntityNotFound(_0x3962a8,null))[_0x14aa('0x32')](function(_0x226928){if(_0x226928){_0x47be4f=_0x226928;_0x55bc0e[_0x14aa('0x3a')]=_[_0x14aa('0x3e')](db[_0x14aa('0x59')]['rawAttributes']);_0x55bc0e[_0x14aa('0x3d')]=_['keys'](_0x1f3095['query']);_0x55bc0e[_0x14aa('0x3f')]=_[_0x14aa('0x40')](_0x55bc0e['model'],_0x55bc0e['query']);_0x58bbe7[_0x14aa('0x42')]=_[_0x14aa('0x40')](_0x55bc0e[_0x14aa('0x3a')],qs['fields'](_0x1f3095['query'][_0x14aa('0x41')]));_0x58bbe7[_0x14aa('0x42')]=_0x58bbe7[_0x14aa('0x42')][_0x14aa('0x43')]?_0x58bbe7[_0x14aa('0x42')]:_0x55bc0e[_0x14aa('0x3a')];_0x58bbe7[_0x14aa('0x46')]=qs[_0x14aa('0x47')](_0x1f3095[_0x14aa('0x3d')]['sort']);_0x58bbe7['where']=qs[_0x14aa('0x3f')](_[_0x14aa('0x49')](_0x1f3095[_0x14aa('0x3d')],_0x55bc0e[_0x14aa('0x3f')]));if(_0x1f3095[_0x14aa('0x3d')][_0x14aa('0x4a')]){_0x58bbe7[_0x14aa('0x48')]=_[_0x14aa('0x4b')](_0x58bbe7['where'],{'$or':_[_0x14aa('0x3b')](_0x58bbe7[_0x14aa('0x42')],function(_0x55fd80){var _0x4fe7a8={};_0x4fe7a8[_0x55fd80]={'$like':'%'+_0x1f3095[_0x14aa('0x3d')][_0x14aa('0x4a')]+'%'};return _0x4fe7a8;})});}_0x58bbe7=_['merge']({},_0x58bbe7,_0x1f3095[_0x14aa('0x4c')]);return _0x47be4f['getFields'](_0x58bbe7);}})['then'](function(_0xb2550d){if(_0xb2550d){_0x45a781=_0xb2550d[_0x14aa('0x43')];if(!_0x1f3095[_0x14aa('0x3d')][_0x14aa('0x44')]('nolimit')){_0x58bbe7[_0x14aa('0x2a')]=qs[_0x14aa('0x2a')](_0x1f3095[_0x14aa('0x3d')][_0x14aa('0x2a')]);_0x58bbe7[_0x14aa('0x29')]=qs[_0x14aa('0x29')](_0x1f3095[_0x14aa('0x3d')][_0x14aa('0x29')]);}return _0x47be4f['getFields'](_0x58bbe7);}})[_0x14aa('0x32')](function(_0x23bee8){if(_0x23bee8){return _0x23bee8?{'count':_0x45a781,'rows':_0x23bee8}:null;}})['then'](respondWithResult(_0x3962a8,null))[_0x14aa('0x55')](handleError(_0x3962a8,null));};exports['getSubjects']=function(_0x47ae67,_0x5692cd,_0x1e587e){var _0x40ed71={};var _0x17d414={};var _0x5bdc53;var _0x2b4dc2;return db[_0x14aa('0x4f')]['findOne']({'where':{'id':_0x47ae67[_0x14aa('0x53')]['id']}})[_0x14aa('0x32')](handleEntityNotFound(_0x5692cd,null))[_0x14aa('0x32')](function(_0x48ba75){if(_0x48ba75){_0x5bdc53=_0x48ba75;_0x17d414[_0x14aa('0x3a')]=_[_0x14aa('0x3e')](db[_0x14aa('0x59')][_0x14aa('0x36')]);_0x17d414['query']=_[_0x14aa('0x3e')](_0x47ae67[_0x14aa('0x3d')]);_0x17d414['filters']=_['intersection'](_0x17d414['model'],_0x17d414[_0x14aa('0x3d')]);_0x40ed71[_0x14aa('0x42')]=_[_0x14aa('0x40')](_0x17d414[_0x14aa('0x3a')],qs[_0x14aa('0x41')](_0x47ae67['query'][_0x14aa('0x41')]));_0x40ed71[_0x14aa('0x42')]=_0x40ed71['attributes'][_0x14aa('0x43')]?_0x40ed71['attributes']:_0x17d414[_0x14aa('0x3a')];_0x40ed71[_0x14aa('0x46')]=qs[_0x14aa('0x47')](_0x47ae67['query']['sort']);_0x40ed71[_0x14aa('0x48')]=qs['filters'](_[_0x14aa('0x49')](_0x47ae67['query'],_0x17d414['filters']));if(_0x47ae67[_0x14aa('0x3d')][_0x14aa('0x4a')]){_0x40ed71['where']=_[_0x14aa('0x4b')](_0x40ed71['where'],{'$or':_[_0x14aa('0x3b')](_0x40ed71[_0x14aa('0x42')],function(_0x280c5d){var _0x4fc75c={};_0x4fc75c[_0x280c5d]={'$like':'%'+_0x47ae67[_0x14aa('0x3d')][_0x14aa('0x4a')]+'%'};return _0x4fc75c;})});}_0x40ed71=_[_0x14aa('0x4b')]({},_0x40ed71,_0x47ae67[_0x14aa('0x4c')]);return _0x5bdc53['getSubjects'](_0x40ed71);}})['then'](function(_0x3e61d1){if(_0x3e61d1){_0x2b4dc2=_0x3e61d1[_0x14aa('0x43')];if(!_0x47ae67[_0x14aa('0x3d')][_0x14aa('0x44')](_0x14aa('0x45'))){_0x40ed71['limit']=qs[_0x14aa('0x2a')](_0x47ae67[_0x14aa('0x3d')][_0x14aa('0x2a')]);_0x40ed71['offset']=qs[_0x14aa('0x29')](_0x47ae67['query']['offset']);}return _0x5bdc53[_0x14aa('0x5a')](_0x40ed71);}})[_0x14aa('0x32')](function(_0x531ebd){if(_0x531ebd){return _0x531ebd?{'count':_0x2b4dc2,'rows':_0x531ebd}:null;}})[_0x14aa('0x32')](respondWithResult(_0x5692cd,null))[_0x14aa('0x55')](handleError(_0x5692cd,null));};exports[_0x14aa('0x5b')]=function(_0x9176c2,_0xc0df2,_0x49fe15){var _0x3b36eb={};var _0x407763={};var _0x186a0a;var _0x181934;return db[_0x14aa('0x4f')][_0x14aa('0x58')]({'where':{'id':_0x9176c2['params']['id']}})[_0x14aa('0x32')](handleEntityNotFound(_0xc0df2,null))[_0x14aa('0x32')](function(_0x44e108){if(_0x44e108){_0x186a0a=_0x44e108;_0x407763[_0x14aa('0x3a')]=_[_0x14aa('0x3e')](db[_0x14aa('0x59')][_0x14aa('0x36')]);_0x407763[_0x14aa('0x3d')]=_[_0x14aa('0x3e')](_0x9176c2[_0x14aa('0x3d')]);_0x407763[_0x14aa('0x3f')]=_[_0x14aa('0x40')](_0x407763['model'],_0x407763['query']);_0x3b36eb[_0x14aa('0x42')]=_[_0x14aa('0x40')](_0x407763[_0x14aa('0x3a')],qs['fields'](_0x9176c2[_0x14aa('0x3d')]['fields']));_0x3b36eb['attributes']=_0x3b36eb[_0x14aa('0x42')][_0x14aa('0x43')]?_0x3b36eb[_0x14aa('0x42')]:_0x407763[_0x14aa('0x3a')];_0x3b36eb[_0x14aa('0x46')]=qs[_0x14aa('0x47')](_0x9176c2['query']['sort']);_0x3b36eb['where']=qs[_0x14aa('0x3f')](_[_0x14aa('0x49')](_0x9176c2[_0x14aa('0x3d')],_0x407763[_0x14aa('0x3f')]));if(_0x9176c2[_0x14aa('0x3d')][_0x14aa('0x4a')]){_0x3b36eb['where']=_[_0x14aa('0x4b')](_0x3b36eb[_0x14aa('0x48')],{'$or':_[_0x14aa('0x3b')](_0x3b36eb[_0x14aa('0x42')],function(_0x221e2d){var _0x37b6ef={};_0x37b6ef[_0x221e2d]={'$like':'%'+_0x9176c2[_0x14aa('0x3d')][_0x14aa('0x4a')]+'%'};return _0x37b6ef;})});}_0x3b36eb=_[_0x14aa('0x4b')]({},_0x3b36eb,_0x9176c2[_0x14aa('0x4c')]);return _0x186a0a[_0x14aa('0x5b')](_0x3b36eb);}})[_0x14aa('0x32')](function(_0x381d6b){if(_0x381d6b){_0x181934=_0x381d6b[_0x14aa('0x43')];if(!_0x9176c2[_0x14aa('0x3d')][_0x14aa('0x44')](_0x14aa('0x45'))){_0x3b36eb[_0x14aa('0x2a')]=qs[_0x14aa('0x2a')](_0x9176c2[_0x14aa('0x3d')]['limit']);_0x3b36eb[_0x14aa('0x29')]=qs['offset'](_0x9176c2[_0x14aa('0x3d')][_0x14aa('0x29')]);}return _0x186a0a[_0x14aa('0x5b')](_0x3b36eb);}})[_0x14aa('0x32')](function(_0x17bb6e){if(_0x17bb6e){return _0x17bb6e?{'count':_0x181934,'rows':_0x17bb6e}:null;}})[_0x14aa('0x32')](respondWithResult(_0xc0df2,null))[_0x14aa('0x55')](handleError(_0xc0df2,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