Built motion from commit c738b9ac.|2.6.25
[motion2.git] / server / api / intSugarcrmConfiguration / intSugarcrmConfiguration.controller.js
index 55407d3..62c6eac 100644 (file)
@@ -15,4 +15,4 @@
 // * 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 _0xdf65=['squel','crypto','jsforce','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','json','offset','undefined','limit','count','Content-Range','apply','save','update','destroy','status','error','stack','name','send','index','SugarcrmConfiguration','fieldName','type','key','model','map','keys','filters','intersection','query','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','then','include','findAll','rows','show','params','rawAttributes','fields','includeAll','options','find','create','body','catch','getFields','findOne','SugarcrmField','getSubjects','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','moment','util','path','sox','to-csv','ejs','fs-extra'];(function(_0xf3bf0b,_0x5c17ed){var _0x3e5c44=function(_0x111dd6){while(--_0x111dd6){_0xf3bf0b['push'](_0xf3bf0b['shift']());}};_0x3e5c44(++_0x5c17ed);}(_0xdf65,0x13d));var _0x5df6=function(_0x115149,_0x1fca9e){_0x115149=_0x115149-0x0;var _0x2a91dc=_0xdf65[_0x115149];return _0x2a91dc;};'use strict';var emlformat=require(_0x5df6('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x5df6('0x1'));var jsonpatch=require(_0x5df6('0x2'));var rp=require(_0x5df6('0x3'));var moment=require(_0x5df6('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x5df6('0x5'));var path=require(_0x5df6('0x6'));var sox=require(_0x5df6('0x7'));var csv=require(_0x5df6('0x8'));var ejs=require(_0x5df6('0x9'));var fs=require('fs');var fs_extra=require(_0x5df6('0xa'));var _=require('lodash');var squel=require(_0x5df6('0xb'));var crypto=require(_0x5df6('0xc'));var jsforce=require(_0x5df6('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x5df6('0x8'));var querystring=require(_0x5df6('0xe'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x5df6('0xf'));var qs=require(_0x5df6('0x10'));var as=require(_0x5df6('0x11'));var hardwareService=require(_0x5df6('0x12'));var logger=require(_0x5df6('0x13'))(_0x5df6('0x14'));var utils=require(_0x5df6('0x15'));var config=require(_0x5df6('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0x5df6('0x17'))['db'];function respondWithStatusCode(_0x10cf4f,_0xd8be85){_0xd8be85=_0xd8be85||0xcc;return function(_0x577f2a){if(_0x577f2a){return _0x10cf4f[_0x5df6('0x18')](_0xd8be85);}return _0x10cf4f['status'](_0xd8be85)[_0x5df6('0x19')]();};}function respondWithResult(_0x220aaa,_0x3b4c45){_0x3b4c45=_0x3b4c45||0xc8;return function(_0x50862c){if(_0x50862c){return _0x220aaa['status'](_0x3b4c45)[_0x5df6('0x1a')](_0x50862c);}};}function respondWithFilteredResult(_0x3aa495,_0x3ff0ad){return function(_0x4d2aa7){if(_0x4d2aa7){var _0x5281fb=typeof _0x3ff0ad[_0x5df6('0x1b')]===_0x5df6('0x1c')&&typeof _0x3ff0ad[_0x5df6('0x1d')]===_0x5df6('0x1c');var _0x339f70=_0x4d2aa7[_0x5df6('0x1e')];var _0x3827f7=_0x5281fb?0x0:_0x3ff0ad['offset'];var _0x38adc1=_0x5281fb?_0x4d2aa7['count']:_0x3ff0ad[_0x5df6('0x1b')]+_0x3ff0ad[_0x5df6('0x1d')];var _0x2e5de3;if(_0x38adc1>=_0x339f70){_0x38adc1=_0x339f70;_0x2e5de3=0xc8;}else{_0x2e5de3=0xce;}_0x3aa495['status'](_0x2e5de3);return _0x3aa495['set'](_0x5df6('0x1f'),_0x3827f7+'-'+_0x38adc1+'/'+_0x339f70)[_0x5df6('0x1a')](_0x4d2aa7);}return null;};}function patchUpdates(_0x5b3358){return function(_0x345ccc){try{jsonpatch[_0x5df6('0x20')](_0x345ccc,_0x5b3358,!![]);}catch(_0x55a71b){return BPromise['reject'](_0x55a71b);}return _0x345ccc[_0x5df6('0x21')]();};}function saveUpdates(_0x200dee,_0x19927b){return function(_0x439570){if(_0x439570){return _0x439570[_0x5df6('0x22')](_0x200dee)['then'](function(_0x338f5b){return _0x338f5b;});}return null;};}function removeEntity(_0x5851e2,_0x398539){return function(_0x2388e9){if(_0x2388e9){return _0x2388e9[_0x5df6('0x23')]()['then'](function(){_0x5851e2[_0x5df6('0x24')](0xcc)[_0x5df6('0x19')]();});}};}function handleEntityNotFound(_0x332a76,_0x242847){return function(_0x4ffbd7){if(!_0x4ffbd7){_0x332a76[_0x5df6('0x18')](0x194);}return _0x4ffbd7;};}function handleError(_0x3e61fd,_0x176495){_0x176495=_0x176495||0x1f4;return function(_0x13fbb8){logger[_0x5df6('0x25')](_0x13fbb8[_0x5df6('0x26')]);if(_0x13fbb8[_0x5df6('0x27')]){delete _0x13fbb8[_0x5df6('0x27')];}_0x3e61fd[_0x5df6('0x24')](_0x176495)[_0x5df6('0x28')](_0x13fbb8);};}exports[_0x5df6('0x29')]=function(_0x37f490,_0x60d6c8){var _0x1a4642={},_0x35a545={},_0x327f69={'count':0x0,'rows':[]};var _0x3d1dd7=_['map'](db[_0x5df6('0x2a')]['rawAttributes'],function(_0x516aea){return{'name':_0x516aea[_0x5df6('0x2b')],'type':_0x516aea[_0x5df6('0x2c')][_0x5df6('0x2d')]};});_0x35a545[_0x5df6('0x2e')]=_[_0x5df6('0x2f')](_0x3d1dd7,_0x5df6('0x27'));_0x35a545['query']=_[_0x5df6('0x30')](_0x37f490['query']);_0x35a545[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x35a545[_0x5df6('0x2e')],_0x35a545[_0x5df6('0x33')]);_0x1a4642[_0x5df6('0x34')]=_['intersection'](_0x35a545[_0x5df6('0x2e')],qs['fields'](_0x37f490['query']['fields']));_0x1a4642[_0x5df6('0x34')]=_0x1a4642[_0x5df6('0x34')][_0x5df6('0x35')]?_0x1a4642[_0x5df6('0x34')]:_0x35a545[_0x5df6('0x2e')];if(!_0x37f490[_0x5df6('0x33')][_0x5df6('0x36')](_0x5df6('0x37'))){_0x1a4642['limit']=qs[_0x5df6('0x1d')](_0x37f490['query'][_0x5df6('0x1d')]);_0x1a4642[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x37f490[_0x5df6('0x33')][_0x5df6('0x1b')]);}_0x1a4642[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x37f490['query'][_0x5df6('0x39')]);_0x1a4642[_0x5df6('0x3a')]=qs[_0x5df6('0x31')](_[_0x5df6('0x3b')](_0x37f490['query'],_0x35a545[_0x5df6('0x31')]),_0x3d1dd7);if(_0x37f490[_0x5df6('0x33')][_0x5df6('0x3c')]){_0x1a4642['where']=_['merge'](_0x1a4642[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x3d1dd7,function(_0x5ed024){if(_0x5ed024['type']!==_0x5df6('0x3d')){var _0x2c5343={};_0x2c5343[_0x5ed024[_0x5df6('0x27')]]={'$like':'%'+_0x37f490['query']['filter']+'%'};return _0x2c5343;}})});}_0x1a4642=_[_0x5df6('0x3e')]({},_0x1a4642,_0x37f490['options']);var _0x1608fb={'where':_0x1a4642[_0x5df6('0x3a')]};return db[_0x5df6('0x2a')]['count'](_0x1608fb)[_0x5df6('0x3f')](function(_0x34c152){_0x327f69[_0x5df6('0x1e')]=_0x34c152;if(_0x37f490[_0x5df6('0x33')]['includeAll']){_0x1a4642[_0x5df6('0x40')]=[{'all':!![]}];}return db[_0x5df6('0x2a')][_0x5df6('0x41')](_0x1a4642);})[_0x5df6('0x3f')](function(_0x549cc8){_0x327f69[_0x5df6('0x42')]=_0x549cc8;return _0x327f69;})[_0x5df6('0x3f')](respondWithFilteredResult(_0x60d6c8,_0x1a4642))['catch'](handleError(_0x60d6c8,null));};exports[_0x5df6('0x43')]=function(_0x49cf39,_0x52769c){var _0x5d6a66={'raw':![],'where':{'id':_0x49cf39[_0x5df6('0x44')]['id']}},_0x7f9d2={};_0x7f9d2[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db['SugarcrmConfiguration'][_0x5df6('0x45')]);_0x7f9d2[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x49cf39['query']);_0x7f9d2[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x7f9d2['model'],_0x7f9d2[_0x5df6('0x33')]);_0x5d6a66['attributes']=_[_0x5df6('0x32')](_0x7f9d2[_0x5df6('0x2e')],qs[_0x5df6('0x46')](_0x49cf39['query']['fields']));_0x5d6a66[_0x5df6('0x34')]=_0x5d6a66[_0x5df6('0x34')]['length']?_0x5d6a66[_0x5df6('0x34')]:_0x7f9d2['model'];if(_0x49cf39['query'][_0x5df6('0x47')]){_0x5d6a66[_0x5df6('0x40')]=[{'all':!![]}];}_0x5d6a66=_[_0x5df6('0x3e')]({},_0x5d6a66,_0x49cf39[_0x5df6('0x48')]);return db[_0x5df6('0x2a')][_0x5df6('0x49')](_0x5d6a66)[_0x5df6('0x3f')](handleEntityNotFound(_0x52769c,null))[_0x5df6('0x3f')](respondWithResult(_0x52769c,null))['catch'](handleError(_0x52769c,null));};exports[_0x5df6('0x4a')]=function(_0x38e7ef,_0x2c62d7){return db[_0x5df6('0x2a')][_0x5df6('0x4a')](_0x38e7ef[_0x5df6('0x4b')],{})['then'](respondWithResult(_0x2c62d7,0xc9))[_0x5df6('0x4c')](handleError(_0x2c62d7,null));};exports[_0x5df6('0x22')]=function(_0x237f4c,_0x1a783e){if(_0x237f4c['body']['id']){delete _0x237f4c[_0x5df6('0x4b')]['id'];}return db['SugarcrmConfiguration']['find']({'where':{'id':_0x237f4c[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x1a783e,null))[_0x5df6('0x3f')](saveUpdates(_0x237f4c[_0x5df6('0x4b')],null))['then'](respondWithResult(_0x1a783e,null))['catch'](handleError(_0x1a783e,null));};exports[_0x5df6('0x23')]=function(_0x1edfb7,_0x4967bb){return db[_0x5df6('0x2a')][_0x5df6('0x49')]({'where':{'id':_0x1edfb7[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x4967bb,null))[_0x5df6('0x3f')](removeEntity(_0x4967bb,null))[_0x5df6('0x4c')](handleError(_0x4967bb,null));};exports[_0x5df6('0x4d')]=function(_0x6beec1,_0x46de68,_0x1d3feb){var _0x5dc51c={};var _0x40f2e5={};var _0x1b75cc;var _0x3ca3f5;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x6beec1[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x46de68,null))['then'](function(_0x565481){if(_0x565481){_0x1b75cc=_0x565481;_0x40f2e5[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db[_0x5df6('0x4f')][_0x5df6('0x45')]);_0x40f2e5[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x6beec1[_0x5df6('0x33')]);_0x40f2e5['filters']=_[_0x5df6('0x32')](_0x40f2e5[_0x5df6('0x2e')],_0x40f2e5['query']);_0x5dc51c[_0x5df6('0x34')]=_[_0x5df6('0x32')](_0x40f2e5['model'],qs[_0x5df6('0x46')](_0x6beec1[_0x5df6('0x33')][_0x5df6('0x46')]));_0x5dc51c['attributes']=_0x5dc51c[_0x5df6('0x34')][_0x5df6('0x35')]?_0x5dc51c[_0x5df6('0x34')]:_0x40f2e5[_0x5df6('0x2e')];_0x5dc51c[_0x5df6('0x38')]=qs['sort'](_0x6beec1['query']['sort']);_0x5dc51c[_0x5df6('0x3a')]=qs[_0x5df6('0x31')](_[_0x5df6('0x3b')](_0x6beec1['query'],_0x40f2e5[_0x5df6('0x31')]));if(_0x6beec1['query'][_0x5df6('0x3c')]){_0x5dc51c[_0x5df6('0x3a')]=_[_0x5df6('0x3e')](_0x5dc51c[_0x5df6('0x3a')],{'$or':_['map'](_0x5dc51c['attributes'],function(_0x4ac672){var _0x3053c1={};_0x3053c1[_0x4ac672]={'$like':'%'+_0x6beec1[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x3053c1;})});}_0x5dc51c=_[_0x5df6('0x3e')]({},_0x5dc51c,_0x6beec1[_0x5df6('0x48')]);return _0x1b75cc[_0x5df6('0x4d')](_0x5dc51c);}})[_0x5df6('0x3f')](function(_0x348fc3){if(_0x348fc3){_0x3ca3f5=_0x348fc3['length'];if(!_0x6beec1['query'][_0x5df6('0x36')](_0x5df6('0x37'))){_0x5dc51c[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x6beec1[_0x5df6('0x33')][_0x5df6('0x1d')]);_0x5dc51c[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x6beec1[_0x5df6('0x33')]['offset']);}return _0x1b75cc['getFields'](_0x5dc51c);}})[_0x5df6('0x3f')](function(_0x97fffa){if(_0x97fffa){return _0x97fffa?{'count':_0x3ca3f5,'rows':_0x97fffa}:null;}})[_0x5df6('0x3f')](respondWithResult(_0x46de68,null))[_0x5df6('0x4c')](handleError(_0x46de68,null));};exports['getSubjects']=function(_0x5a189a,_0x3fd0b5,_0x390f9f){var _0x4b6237={};var _0x5e736e={};var _0x751c82;var _0xb273e;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x5a189a[_0x5df6('0x44')]['id']}})['then'](handleEntityNotFound(_0x3fd0b5,null))[_0x5df6('0x3f')](function(_0x41b3a7){if(_0x41b3a7){_0x751c82=_0x41b3a7;_0x5e736e[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db['SugarcrmField'][_0x5df6('0x45')]);_0x5e736e[_0x5df6('0x33')]=_[_0x5df6('0x30')](_0x5a189a['query']);_0x5e736e[_0x5df6('0x31')]=_[_0x5df6('0x32')](_0x5e736e[_0x5df6('0x2e')],_0x5e736e[_0x5df6('0x33')]);_0x4b6237['attributes']=_['intersection'](_0x5e736e[_0x5df6('0x2e')],qs[_0x5df6('0x46')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x46')]));_0x4b6237[_0x5df6('0x34')]=_0x4b6237['attributes']['length']?_0x4b6237['attributes']:_0x5e736e[_0x5df6('0x2e')];_0x4b6237[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x39')]);_0x4b6237['where']=qs['filters'](_[_0x5df6('0x3b')](_0x5a189a['query'],_0x5e736e[_0x5df6('0x31')]));if(_0x5a189a[_0x5df6('0x33')]['filter']){_0x4b6237['where']=_['merge'](_0x4b6237[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x4b6237['attributes'],function(_0x4ba447){var _0x5b8760={};_0x5b8760[_0x4ba447]={'$like':'%'+_0x5a189a[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x5b8760;})});}_0x4b6237=_[_0x5df6('0x3e')]({},_0x4b6237,_0x5a189a[_0x5df6('0x48')]);return _0x751c82[_0x5df6('0x50')](_0x4b6237);}})[_0x5df6('0x3f')](function(_0x3eebe4){if(_0x3eebe4){_0xb273e=_0x3eebe4['length'];if(!_0x5a189a[_0x5df6('0x33')]['hasOwnProperty'](_0x5df6('0x37'))){_0x4b6237[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x1d')]);_0x4b6237[_0x5df6('0x1b')]=qs[_0x5df6('0x1b')](_0x5a189a[_0x5df6('0x33')][_0x5df6('0x1b')]);}return _0x751c82[_0x5df6('0x50')](_0x4b6237);}})[_0x5df6('0x3f')](function(_0xba102c){if(_0xba102c){return _0xba102c?{'count':_0xb273e,'rows':_0xba102c}:null;}})[_0x5df6('0x3f')](respondWithResult(_0x3fd0b5,null))[_0x5df6('0x4c')](handleError(_0x3fd0b5,null));};exports[_0x5df6('0x51')]=function(_0x27e596,_0x1597a4,_0x1641cc){var _0x3aeb80={};var _0x234c1f={};var _0x52ea14;var _0x3f06e2;return db[_0x5df6('0x2a')][_0x5df6('0x4e')]({'where':{'id':_0x27e596[_0x5df6('0x44')]['id']}})[_0x5df6('0x3f')](handleEntityNotFound(_0x1597a4,null))[_0x5df6('0x3f')](function(_0x30e721){if(_0x30e721){_0x52ea14=_0x30e721;_0x234c1f[_0x5df6('0x2e')]=_[_0x5df6('0x30')](db[_0x5df6('0x4f')]['rawAttributes']);_0x234c1f['query']=_['keys'](_0x27e596['query']);_0x234c1f['filters']=_[_0x5df6('0x32')](_0x234c1f[_0x5df6('0x2e')],_0x234c1f[_0x5df6('0x33')]);_0x3aeb80[_0x5df6('0x34')]=_[_0x5df6('0x32')](_0x234c1f['model'],qs[_0x5df6('0x46')](_0x27e596['query'][_0x5df6('0x46')]));_0x3aeb80[_0x5df6('0x34')]=_0x3aeb80['attributes'][_0x5df6('0x35')]?_0x3aeb80[_0x5df6('0x34')]:_0x234c1f['model'];_0x3aeb80[_0x5df6('0x38')]=qs[_0x5df6('0x39')](_0x27e596[_0x5df6('0x33')][_0x5df6('0x39')]);_0x3aeb80[_0x5df6('0x3a')]=qs['filters'](_['pick'](_0x27e596['query'],_0x234c1f['filters']));if(_0x27e596[_0x5df6('0x33')][_0x5df6('0x3c')]){_0x3aeb80[_0x5df6('0x3a')]=_[_0x5df6('0x3e')](_0x3aeb80[_0x5df6('0x3a')],{'$or':_[_0x5df6('0x2f')](_0x3aeb80['attributes'],function(_0x14c4f1){var _0x28fc43={};_0x28fc43[_0x14c4f1]={'$like':'%'+_0x27e596[_0x5df6('0x33')][_0x5df6('0x3c')]+'%'};return _0x28fc43;})});}_0x3aeb80=_[_0x5df6('0x3e')]({},_0x3aeb80,_0x27e596['options']);return _0x52ea14[_0x5df6('0x51')](_0x3aeb80);}})[_0x5df6('0x3f')](function(_0x49125b){if(_0x49125b){_0x3f06e2=_0x49125b[_0x5df6('0x35')];if(!_0x27e596[_0x5df6('0x33')]['hasOwnProperty'](_0x5df6('0x37'))){_0x3aeb80[_0x5df6('0x1d')]=qs[_0x5df6('0x1d')](_0x27e596[_0x5df6('0x33')]['limit']);_0x3aeb80['offset']=qs['offset'](_0x27e596[_0x5df6('0x33')][_0x5df6('0x1b')]);}return _0x52ea14[_0x5df6('0x51')](_0x3aeb80);}})[_0x5df6('0x3f')](function(_0x5504c9){if(_0x5504c9){return _0x5504c9?{'count':_0x3f06e2,'rows':_0x5504c9}:null;}})['then'](respondWithResult(_0x1597a4,null))['catch'](handleError(_0x1597a4,null));};
\ No newline at end of file