// * 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 _0x6bb1=['getDescriptions','rimraf','zip-dir','fast-json-patch','mustache','sox','to-csv','ejs','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','json','undefined','offset','count','limit','status','set','Content-Range','apply','save','then','destroy','error','stack','name','send','index','map','SugarcrmConfiguration','rawAttributes','fieldName','type','model','keys','filters','intersection','query','attributes','length','hasOwnProperty','order','sort','where','filter','VIRTUAL','merge','options','includeAll','include','findAll','rows','catch','show','fields','find','create','body','params','getFields','findOne','SugarcrmField','pick','nolimit','getSubjects'];(function(_0x187ee1,_0x3fd1e6){var _0x388160=function(_0x542dd2){while(--_0x542dd2){_0x187ee1['push'](_0x187ee1['shift']());}};_0x388160(++_0x3fd1e6);}(_0x6bb1,0x1cf));var _0x16bb=function(_0x3bf80d,_0x2650df){_0x3bf80d=_0x3bf80d-0x0;var _0x505f21=_0x6bb1[_0x3bf80d];return _0x505f21;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x16bb('0x0'));var zipdir=require(_0x16bb('0x1'));var jsonpatch=require(_0x16bb('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x16bb('0x3'));var util=require('util');var path=require('path');var sox=require(_0x16bb('0x4'));var csv=require(_0x16bb('0x5'));var ejs=require(_0x16bb('0x6'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require('squel');var crypto=require(_0x16bb('0x7'));var jsforce=require(_0x16bb('0x8'));var deskjs=require(_0x16bb('0x9'));var toCsv=require(_0x16bb('0x5'));var querystring=require(_0x16bb('0xa'));var Papa=require(_0x16bb('0xb'));var Redis=require('ioredis');var authService=require(_0x16bb('0xc'));var qs=require(_0x16bb('0xd'));var as=require(_0x16bb('0xe'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x16bb('0xf'))('api');var utils=require(_0x16bb('0x10'));var config=require(_0x16bb('0x11'));var licenseUtil=require(_0x16bb('0x12'));var db=require(_0x16bb('0x13'))['db'];function respondWithStatusCode(_0x461c2e,_0x5c5763){_0x5c5763=_0x5c5763||0xcc;return function(_0x20fef8){if(_0x20fef8){return _0x461c2e[_0x16bb('0x14')](_0x5c5763);}return _0x461c2e['status'](_0x5c5763)[_0x16bb('0x15')]();};}function respondWithResult(_0x34d0a5,_0x1c3e6b){_0x1c3e6b=_0x1c3e6b||0xc8;return function(_0x231d61){if(_0x231d61){return _0x34d0a5['status'](_0x1c3e6b)[_0x16bb('0x16')](_0x231d61);}};}function respondWithFilteredResult(_0x2c2f45,_0x3160d2){return function(_0x16d8d8){if(_0x16d8d8){var _0xeba497=typeof _0x3160d2['offset']===_0x16bb('0x17')&&typeof _0x3160d2['limit']===_0x16bb('0x17');var _0x14bba5=_0x16d8d8['count'];var _0x34d25b=_0xeba497?0x0:_0x3160d2[_0x16bb('0x18')];var _0x4385c2=_0xeba497?_0x16d8d8[_0x16bb('0x19')]:_0x3160d2['offset']+_0x3160d2[_0x16bb('0x1a')];var _0x53bd98;if(_0x4385c2>=_0x14bba5){_0x4385c2=_0x14bba5;_0x53bd98=0xc8;}else{_0x53bd98=0xce;}_0x2c2f45[_0x16bb('0x1b')](_0x53bd98);return _0x2c2f45[_0x16bb('0x1c')](_0x16bb('0x1d'),_0x34d25b+'-'+_0x4385c2+'/'+_0x14bba5)[_0x16bb('0x16')](_0x16d8d8);}return null;};}function patchUpdates(_0x505ab2){return function(_0x3c4a07){try{jsonpatch[_0x16bb('0x1e')](_0x3c4a07,_0x505ab2,!![]);}catch(_0x3affe0){return BPromise['reject'](_0x3affe0);}return _0x3c4a07[_0x16bb('0x1f')]();};}function saveUpdates(_0x1c80a2,_0x39a881){return function(_0x4145a2){if(_0x4145a2){return _0x4145a2['update'](_0x1c80a2)[_0x16bb('0x20')](function(_0x2fb83c){return _0x2fb83c;});}return null;};}function removeEntity(_0x2c5ad6,_0x3717cc){return function(_0x46d7c8){if(_0x46d7c8){return _0x46d7c8[_0x16bb('0x21')]()[_0x16bb('0x20')](function(){_0x2c5ad6[_0x16bb('0x1b')](0xcc)[_0x16bb('0x15')]();});}};}function handleEntityNotFound(_0x14d6cb,_0x517a28){return function(_0x5b2b08){if(!_0x5b2b08){_0x14d6cb[_0x16bb('0x14')](0x194);}return _0x5b2b08;};}function handleError(_0x12f436,_0x534ac7){_0x534ac7=_0x534ac7||0x1f4;return function(_0x15dfc5){logger[_0x16bb('0x22')](_0x15dfc5[_0x16bb('0x23')]);if(_0x15dfc5[_0x16bb('0x24')]){delete _0x15dfc5[_0x16bb('0x24')];}_0x12f436[_0x16bb('0x1b')](_0x534ac7)[_0x16bb('0x25')](_0x15dfc5);};}exports[_0x16bb('0x26')]=function(_0x56a155,_0x21307b){var _0x10d324={},_0x25ca6f={},_0x554f7c={'count':0x0,'rows':[]};var _0x25a731=_[_0x16bb('0x27')](db[_0x16bb('0x28')][_0x16bb('0x29')],function(_0x1fe89f){return{'name':_0x1fe89f[_0x16bb('0x2a')],'type':_0x1fe89f[_0x16bb('0x2b')]['key']};});_0x25ca6f[_0x16bb('0x2c')]=_[_0x16bb('0x27')](_0x25a731,_0x16bb('0x24'));_0x25ca6f['query']=_[_0x16bb('0x2d')](_0x56a155['query']);_0x25ca6f[_0x16bb('0x2e')]=_[_0x16bb('0x2f')](_0x25ca6f[_0x16bb('0x2c')],_0x25ca6f[_0x16bb('0x30')]);_0x10d324[_0x16bb('0x31')]=_['intersection'](_0x25ca6f[_0x16bb('0x2c')],qs['fields'](_0x56a155['query']['fields']));_0x10d324[_0x16bb('0x31')]=_0x10d324[_0x16bb('0x31')][_0x16bb('0x32')]?_0x10d324[_0x16bb('0x31')]:_0x25ca6f[_0x16bb('0x2c')];if(!_0x56a155[_0x16bb('0x30')][_0x16bb('0x33')]('nolimit')){_0x10d324[_0x16bb('0x1a')]=qs[_0x16bb('0x1a')](_0x56a155[_0x16bb('0x30')][_0x16bb('0x1a')]);_0x10d324['offset']=qs[_0x16bb('0x18')](_0x56a155['query'][_0x16bb('0x18')]);}_0x10d324[_0x16bb('0x34')]=qs[_0x16bb('0x35')](_0x56a155[_0x16bb('0x30')][_0x16bb('0x35')]);_0x10d324[_0x16bb('0x36')]=qs[_0x16bb('0x2e')](_['pick'](_0x56a155[_0x16bb('0x30')],_0x25ca6f[_0x16bb('0x2e')]),_0x25a731);if(_0x56a155[_0x16bb('0x30')][_0x16bb('0x37')]){_0x10d324[_0x16bb('0x36')]=_['merge'](_0x10d324['where'],{'$or':_[_0x16bb('0x27')](_0x25a731,function(_0x4c5ccb){if(_0x4c5ccb[_0x16bb('0x2b')]!==_0x16bb('0x38')){var _0x2c5d1a={};_0x2c5d1a[_0x4c5ccb[_0x16bb('0x24')]]={'$like':'%'+_0x56a155[_0x16bb('0x30')]['filter']+'%'};return _0x2c5d1a;}})});}_0x10d324=_[_0x16bb('0x39')]({},_0x10d324,_0x56a155[_0x16bb('0x3a')]);var _0x5a164c={'where':_0x10d324['where']};return db[_0x16bb('0x28')]['count'](_0x5a164c)[_0x16bb('0x20')](function(_0x62e3f0){_0x554f7c[_0x16bb('0x19')]=_0x62e3f0;if(_0x56a155['query'][_0x16bb('0x3b')]){_0x10d324[_0x16bb('0x3c')]=[{'all':!![]}];}return db[_0x16bb('0x28')][_0x16bb('0x3d')](_0x10d324);})[_0x16bb('0x20')](function(_0x28ef2f){_0x554f7c[_0x16bb('0x3e')]=_0x28ef2f;return _0x554f7c;})[_0x16bb('0x20')](respondWithFilteredResult(_0x21307b,_0x10d324))[_0x16bb('0x3f')](handleError(_0x21307b,null));};exports[_0x16bb('0x40')]=function(_0x4cd7d6,_0x30332c){var _0x517bed={'raw':![],'where':{'id':_0x4cd7d6['params']['id']}},_0x387a79={};_0x387a79[_0x16bb('0x2c')]=_[_0x16bb('0x2d')](db[_0x16bb('0x28')]['rawAttributes']);_0x387a79[_0x16bb('0x30')]=_[_0x16bb('0x2d')](_0x4cd7d6[_0x16bb('0x30')]);_0x387a79[_0x16bb('0x2e')]=_[_0x16bb('0x2f')](_0x387a79[_0x16bb('0x2c')],_0x387a79[_0x16bb('0x30')]);_0x517bed[_0x16bb('0x31')]=_['intersection'](_0x387a79[_0x16bb('0x2c')],qs[_0x16bb('0x41')](_0x4cd7d6[_0x16bb('0x30')][_0x16bb('0x41')]));_0x517bed[_0x16bb('0x31')]=_0x517bed[_0x16bb('0x31')][_0x16bb('0x32')]?_0x517bed['attributes']:_0x387a79[_0x16bb('0x2c')];if(_0x4cd7d6[_0x16bb('0x30')][_0x16bb('0x3b')]){_0x517bed[_0x16bb('0x3c')]=[{'all':!![]}];}_0x517bed=_[_0x16bb('0x39')]({},_0x517bed,_0x4cd7d6[_0x16bb('0x3a')]);return db['SugarcrmConfiguration'][_0x16bb('0x42')](_0x517bed)['then'](handleEntityNotFound(_0x30332c,null))[_0x16bb('0x20')](respondWithResult(_0x30332c,null))[_0x16bb('0x3f')](handleError(_0x30332c,null));};exports['create']=function(_0x10e66e,_0x7eb48e){return db[_0x16bb('0x28')][_0x16bb('0x43')](_0x10e66e[_0x16bb('0x44')],{})[_0x16bb('0x20')](respondWithResult(_0x7eb48e,0xc9))[_0x16bb('0x3f')](handleError(_0x7eb48e,null));};exports['update']=function(_0xd4985,_0x400933){if(_0xd4985[_0x16bb('0x44')]['id']){delete _0xd4985['body']['id'];}return db[_0x16bb('0x28')][_0x16bb('0x42')]({'where':{'id':_0xd4985[_0x16bb('0x45')]['id']}})[_0x16bb('0x20')](handleEntityNotFound(_0x400933,null))['then'](saveUpdates(_0xd4985[_0x16bb('0x44')],null))[_0x16bb('0x20')](respondWithResult(_0x400933,null))[_0x16bb('0x3f')](handleError(_0x400933,null));};exports[_0x16bb('0x21')]=function(_0x4eb48f,_0x136de1){return db[_0x16bb('0x28')][_0x16bb('0x42')]({'where':{'id':_0x4eb48f['params']['id']}})[_0x16bb('0x20')](handleEntityNotFound(_0x136de1,null))[_0x16bb('0x20')](removeEntity(_0x136de1,null))[_0x16bb('0x3f')](handleError(_0x136de1,null));};exports[_0x16bb('0x46')]=function(_0x269ae3,_0x38b131,_0x37ead1){var _0x17ed8a={};var _0x224ef5={};var _0x4eede6;var _0x5abef4;return db[_0x16bb('0x28')][_0x16bb('0x47')]({'where':{'id':_0x269ae3['params']['id']}})['then'](handleEntityNotFound(_0x38b131,null))['then'](function(_0x1ea100){if(_0x1ea100){_0x4eede6=_0x1ea100;_0x224ef5[_0x16bb('0x2c')]=_[_0x16bb('0x2d')](db[_0x16bb('0x48')][_0x16bb('0x29')]);_0x224ef5[_0x16bb('0x30')]=_[_0x16bb('0x2d')](_0x269ae3[_0x16bb('0x30')]);_0x224ef5[_0x16bb('0x2e')]=_[_0x16bb('0x2f')](_0x224ef5[_0x16bb('0x2c')],_0x224ef5[_0x16bb('0x30')]);_0x17ed8a['attributes']=_[_0x16bb('0x2f')](_0x224ef5[_0x16bb('0x2c')],qs[_0x16bb('0x41')](_0x269ae3[_0x16bb('0x30')][_0x16bb('0x41')]));_0x17ed8a[_0x16bb('0x31')]=_0x17ed8a['attributes'][_0x16bb('0x32')]?_0x17ed8a[_0x16bb('0x31')]:_0x224ef5[_0x16bb('0x2c')];_0x17ed8a[_0x16bb('0x34')]=qs['sort'](_0x269ae3['query'][_0x16bb('0x35')]);_0x17ed8a[_0x16bb('0x36')]=qs[_0x16bb('0x2e')](_[_0x16bb('0x49')](_0x269ae3[_0x16bb('0x30')],_0x224ef5[_0x16bb('0x2e')]));if(_0x269ae3[_0x16bb('0x30')][_0x16bb('0x37')]){_0x17ed8a[_0x16bb('0x36')]=_[_0x16bb('0x39')](_0x17ed8a[_0x16bb('0x36')],{'$or':_['map'](_0x17ed8a[_0x16bb('0x31')],function(_0x428868){var _0x591663={};_0x591663[_0x428868]={'$like':'%'+_0x269ae3[_0x16bb('0x30')]['filter']+'%'};return _0x591663;})});}_0x17ed8a=_[_0x16bb('0x39')]({},_0x17ed8a,_0x269ae3[_0x16bb('0x3a')]);return _0x4eede6['getFields'](_0x17ed8a);}})[_0x16bb('0x20')](function(_0x720210){if(_0x720210){_0x5abef4=_0x720210['length'];if(!_0x269ae3[_0x16bb('0x30')]['hasOwnProperty'](_0x16bb('0x4a'))){_0x17ed8a[_0x16bb('0x1a')]=qs[_0x16bb('0x1a')](_0x269ae3[_0x16bb('0x30')][_0x16bb('0x1a')]);_0x17ed8a[_0x16bb('0x18')]=qs[_0x16bb('0x18')](_0x269ae3[_0x16bb('0x30')][_0x16bb('0x18')]);}return _0x4eede6[_0x16bb('0x46')](_0x17ed8a);}})[_0x16bb('0x20')](function(_0x1e1fb1){if(_0x1e1fb1){return _0x1e1fb1?{'count':_0x5abef4,'rows':_0x1e1fb1}:null;}})['then'](respondWithResult(_0x38b131,null))[_0x16bb('0x3f')](handleError(_0x38b131,null));};exports['getSubjects']=function(_0xcd21dc,_0x2b4062,_0x47387a){var _0x5a5fdd={};var _0x43cec={};var _0x27a378;var _0x466d37;return db[_0x16bb('0x28')][_0x16bb('0x47')]({'where':{'id':_0xcd21dc[_0x16bb('0x45')]['id']}})[_0x16bb('0x20')](handleEntityNotFound(_0x2b4062,null))[_0x16bb('0x20')](function(_0x573bf){if(_0x573bf){_0x27a378=_0x573bf;_0x43cec[_0x16bb('0x2c')]=_['keys'](db[_0x16bb('0x48')]['rawAttributes']);_0x43cec['query']=_['keys'](_0xcd21dc[_0x16bb('0x30')]);_0x43cec[_0x16bb('0x2e')]=_[_0x16bb('0x2f')](_0x43cec['model'],_0x43cec[_0x16bb('0x30')]);_0x5a5fdd[_0x16bb('0x31')]=_[_0x16bb('0x2f')](_0x43cec[_0x16bb('0x2c')],qs[_0x16bb('0x41')](_0xcd21dc['query'][_0x16bb('0x41')]));_0x5a5fdd[_0x16bb('0x31')]=_0x5a5fdd[_0x16bb('0x31')][_0x16bb('0x32')]?_0x5a5fdd[_0x16bb('0x31')]:_0x43cec[_0x16bb('0x2c')];_0x5a5fdd[_0x16bb('0x34')]=qs['sort'](_0xcd21dc['query'][_0x16bb('0x35')]);_0x5a5fdd['where']=qs[_0x16bb('0x2e')](_['pick'](_0xcd21dc['query'],_0x43cec['filters']));if(_0xcd21dc[_0x16bb('0x30')]['filter']){_0x5a5fdd[_0x16bb('0x36')]=_[_0x16bb('0x39')](_0x5a5fdd[_0x16bb('0x36')],{'$or':_[_0x16bb('0x27')](_0x5a5fdd[_0x16bb('0x31')],function(_0x5d626){var _0x24e521={};_0x24e521[_0x5d626]={'$like':'%'+_0xcd21dc[_0x16bb('0x30')]['filter']+'%'};return _0x24e521;})});}_0x5a5fdd=_[_0x16bb('0x39')]({},_0x5a5fdd,_0xcd21dc['options']);return _0x27a378['getSubjects'](_0x5a5fdd);}})[_0x16bb('0x20')](function(_0x499a43){if(_0x499a43){_0x466d37=_0x499a43[_0x16bb('0x32')];if(!_0xcd21dc[_0x16bb('0x30')][_0x16bb('0x33')](_0x16bb('0x4a'))){_0x5a5fdd[_0x16bb('0x1a')]=qs[_0x16bb('0x1a')](_0xcd21dc['query']['limit']);_0x5a5fdd['offset']=qs['offset'](_0xcd21dc['query'][_0x16bb('0x18')]);}return _0x27a378[_0x16bb('0x4b')](_0x5a5fdd);}})['then'](function(_0x3702d7){if(_0x3702d7){return _0x3702d7?{'count':_0x466d37,'rows':_0x3702d7}:null;}})[_0x16bb('0x20')](respondWithResult(_0x2b4062,null))[_0x16bb('0x3f')](handleError(_0x2b4062,null));};exports[_0x16bb('0x4c')]=function(_0x3ee984,_0x1a7013,_0x5c401e){var _0xf80464={};var _0x1d6d06={};var _0xd77c89;var _0x3d38b9;return db[_0x16bb('0x28')][_0x16bb('0x47')]({'where':{'id':_0x3ee984[_0x16bb('0x45')]['id']}})[_0x16bb('0x20')](handleEntityNotFound(_0x1a7013,null))[_0x16bb('0x20')](function(_0xa8e26b){if(_0xa8e26b){_0xd77c89=_0xa8e26b;_0x1d6d06[_0x16bb('0x2c')]=_['keys'](db[_0x16bb('0x48')][_0x16bb('0x29')]);_0x1d6d06[_0x16bb('0x30')]=_['keys'](_0x3ee984[_0x16bb('0x30')]);_0x1d6d06[_0x16bb('0x2e')]=_['intersection'](_0x1d6d06['model'],_0x1d6d06[_0x16bb('0x30')]);_0xf80464[_0x16bb('0x31')]=_[_0x16bb('0x2f')](_0x1d6d06['model'],qs[_0x16bb('0x41')](_0x3ee984[_0x16bb('0x30')][_0x16bb('0x41')]));_0xf80464[_0x16bb('0x31')]=_0xf80464[_0x16bb('0x31')][_0x16bb('0x32')]?_0xf80464[_0x16bb('0x31')]:_0x1d6d06[_0x16bb('0x2c')];_0xf80464['order']=qs[_0x16bb('0x35')](_0x3ee984[_0x16bb('0x30')]['sort']);_0xf80464[_0x16bb('0x36')]=qs['filters'](_[_0x16bb('0x49')](_0x3ee984['query'],_0x1d6d06['filters']));if(_0x3ee984['query'][_0x16bb('0x37')]){_0xf80464[_0x16bb('0x36')]=_[_0x16bb('0x39')](_0xf80464[_0x16bb('0x36')],{'$or':_[_0x16bb('0x27')](_0xf80464[_0x16bb('0x31')],function(_0x4ad651){var _0x527392={};_0x527392[_0x4ad651]={'$like':'%'+_0x3ee984[_0x16bb('0x30')][_0x16bb('0x37')]+'%'};return _0x527392;})});}_0xf80464=_[_0x16bb('0x39')]({},_0xf80464,_0x3ee984['options']);return _0xd77c89[_0x16bb('0x4c')](_0xf80464);}})['then'](function(_0x4a8674){if(_0x4a8674){_0x3d38b9=_0x4a8674[_0x16bb('0x32')];if(!_0x3ee984[_0x16bb('0x30')][_0x16bb('0x33')](_0x16bb('0x4a'))){_0xf80464[_0x16bb('0x1a')]=qs[_0x16bb('0x1a')](_0x3ee984[_0x16bb('0x30')][_0x16bb('0x1a')]);_0xf80464[_0x16bb('0x18')]=qs[_0x16bb('0x18')](_0x3ee984[_0x16bb('0x30')]['offset']);}return _0xd77c89[_0x16bb('0x4c')](_0xf80464);}})[_0x16bb('0x20')](function(_0x1b7cdf){if(_0x1b7cdf){return _0x1b7cdf?{'count':_0x3d38b9,'rows':_0x1b7cdf}:null;}})['then'](respondWithResult(_0x1a7013,null))[_0x16bb('0x3f')](handleError(_0x1a7013,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff