// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xdc06=['getSubjects','findOne','pick','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','ejs','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../mysqldb','jayson/promise','client','http','Sequelize','The\x20password\x20must\x20be\x20at\x20least\x208\x20characters\x20long\x20and\x20have\x201\x20lowercase\x20character,\x201\x20uppercase\x20character,\x201\x20number\x20and\x201\x20special\x20character\x20~!@#$%^&-_=+[{]}.','request','then','SugarcrmConfiguration,\x20%s,\x20%s','debug','SugarcrmConfiguration,\x20%s,\x20%s,\x20%s','request\x20sent','stringify','error','code','message','info','result','sendStatus','status','count','offset','limit','set','json','apply','reject','save','update','destroy','end','name','send','index','map','SugarcrmConfiguration','type','model','query','keys','filters','attributes','intersection','fields','hasOwnProperty','order','sort','filter','where','VIRTUAL','merge','options','rows','catch','params','rawAttributes','length','includeAll','create','body','find','getFields','SugarcrmField','nolimit'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0xdc06,0x112));var _0x6dc0=function(_0x2cfd94,_0x27e2eb){_0x2cfd94=_0x2cfd94-0x0;var _0x5855ae=_0xdc06[_0x2cfd94];return _0x5855ae;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x6dc0('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x6dc0('0x1'));var jsonpatch=require(_0x6dc0('0x2'));var rp=require(_0x6dc0('0x3'));var moment=require(_0x6dc0('0x4'));var BPromise=require(_0x6dc0('0x5'));var Mustache=require(_0x6dc0('0x6'));var util=require('util');var path=require('path');var sox=require(_0x6dc0('0x7'));var csv=require(_0x6dc0('0x8'));var ejs=require(_0x6dc0('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x6dc0('0xa'));var crypto=require(_0x6dc0('0xb'));var jsforce=require(_0x6dc0('0xc'));var deskjs=require(_0x6dc0('0xd'));var toCsv=require(_0x6dc0('0x8'));var querystring=require(_0x6dc0('0xe'));var Papa=require(_0x6dc0('0xf'));var Redis=require(_0x6dc0('0x10'));var authService=require(_0x6dc0('0x11'));var qs=require(_0x6dc0('0x12'));var as=require(_0x6dc0('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x6dc0('0x14'))('api');var utils=require(_0x6dc0('0x15'));var config=require('../../config/environment');var db=require(_0x6dc0('0x16'))['db'];var jayson=require(_0x6dc0('0x17'));var client=jayson[_0x6dc0('0x18')][_0x6dc0('0x19')]({'port':0x232a});function checkPasswordPattern(_0x5b3452,_0x35823e,_0x2b1f45){if(_0x2b1f45){var _0x54516e=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x54516e['test'](_0x35823e)){return _0x5b3452;}else{throw new db[(_0x6dc0('0x1a'))]['ValidationError'](_0x6dc0('0x1b'));}}else{return _0x5b3452;}}function respondWithRpcPromise(_0x2805ee,_0x31e6b0,_0x1887ff,_0x10716f){return new BPromise(function(_0x31a467,_0x388ac8){var _0x1b377e=_0x10716f||client;return _0x1b377e[_0x6dc0('0x1c')](_0x2805ee,_0x1887ff)[_0x6dc0('0x1d')](function(_0x2633e6){logger['info'](_0x6dc0('0x1e'),_0x31e6b0,'request\x20sent');logger[_0x6dc0('0x1f')](_0x6dc0('0x20'),_0x31e6b0,_0x6dc0('0x21'),JSON[_0x6dc0('0x22')](_0x2633e6));if(_0x2633e6[_0x6dc0('0x23')]){if(_0x2633e6['error'][_0x6dc0('0x24')]===0x1f4){logger[_0x6dc0('0x23')](_0x6dc0('0x1e'),_0x31e6b0,_0x2633e6[_0x6dc0('0x23')][_0x6dc0('0x25')]);return _0x388ac8(_0x2633e6['error'][_0x6dc0('0x25')]);}logger[_0x6dc0('0x23')](_0x6dc0('0x1e'),_0x31e6b0,_0x2633e6[_0x6dc0('0x23')][_0x6dc0('0x25')]);return _0x31a467(_0x2633e6[_0x6dc0('0x23')]['message']);}else{logger[_0x6dc0('0x26')](_0x6dc0('0x1e'),_0x31e6b0,_0x6dc0('0x21'));_0x31a467(_0x2633e6[_0x6dc0('0x27')]['message']);}})['catch'](function(_0x4cd3c0){logger[_0x6dc0('0x23')](_0x6dc0('0x1e'),_0x31e6b0,_0x4cd3c0);_0x388ac8(_0x4cd3c0);});});}function respondWithStatusCode(_0x390d50,_0x20978d){_0x20978d=_0x20978d||0xcc;return function(_0x162425){if(_0x162425){return _0x390d50[_0x6dc0('0x28')](_0x20978d);}return _0x390d50['status'](_0x20978d)['end']();};}function respondWithResult(_0x2ce26e,_0x718a19){_0x718a19=_0x718a19||0xc8;return function(_0x1276f3){if(_0x1276f3){return _0x2ce26e[_0x6dc0('0x29')](_0x718a19)['json'](_0x1276f3);}};}function respondWithFilteredResult(_0x2c631f,_0x56a059){return function(_0x49822e){if(_0x49822e){var _0x756777=_0x49822e[_0x6dc0('0x2a')],_0x4aa0e9=_0x56a059[_0x6dc0('0x2b')],_0x304c16=_0x56a059[_0x6dc0('0x2b')]+_0x56a059[_0x6dc0('0x2c')],_0x241a74;if(_0x304c16>=_0x756777){_0x304c16=_0x756777;_0x241a74=0xc8;}else{_0x241a74=0xce;}_0x2c631f[_0x6dc0('0x29')](_0x241a74);return _0x2c631f[_0x6dc0('0x2d')]('Content-Range',_0x4aa0e9+'-'+_0x304c16+'/'+_0x756777)[_0x6dc0('0x2e')](_0x49822e);}return null;};}function patchUpdates(_0x43529d){return function(_0x4e041a){try{jsonpatch[_0x6dc0('0x2f')](_0x4e041a,_0x43529d,!![]);}catch(_0x2c5941){return BPromise[_0x6dc0('0x30')](_0x2c5941);}return _0x4e041a[_0x6dc0('0x31')]();};}function saveUpdates(_0xda3bcb,_0xce2954){return function(_0x3df2c8){if(_0x3df2c8){return _0x3df2c8[_0x6dc0('0x32')](_0xda3bcb)['then'](function(_0x18558c){return _0x18558c;});}return null;};}function removeEntity(_0x4346a5,_0x282918){return function(_0x3d3add){if(_0x3d3add){return _0x3d3add[_0x6dc0('0x33')]()[_0x6dc0('0x1d')](function(){_0x4346a5[_0x6dc0('0x29')](0xcc)[_0x6dc0('0x34')]();});}};}function handleEntityNotFound(_0x4b485a,_0x5e87a7){return function(_0x47a89a){if(!_0x47a89a){_0x4b485a['sendStatus'](0x194);}return _0x47a89a;};}function handleError(_0x1a640d,_0x57ad5d){_0x57ad5d=_0x57ad5d||0x1f4;return function(_0x144129){logger[_0x6dc0('0x23')](_0x144129['stack']);if(_0x144129[_0x6dc0('0x35')]){delete _0x144129[_0x6dc0('0x35')];}_0x1a640d[_0x6dc0('0x29')](_0x57ad5d)[_0x6dc0('0x36')](_0x144129);};}exports[_0x6dc0('0x37')]=function(_0x3324fa,_0x2c8aa8){var _0x2845c0={},_0x2149a3={},_0x39d2c0={'count':0x0,'rows':[]};var _0x299a73=_[_0x6dc0('0x38')](db[_0x6dc0('0x39')]['rawAttributes'],function(_0x1597a0){return{'name':_0x1597a0['fieldName'],'type':_0x1597a0[_0x6dc0('0x3a')]['key']};});_0x2149a3[_0x6dc0('0x3b')]=_['map'](_0x299a73,_0x6dc0('0x35'));_0x2149a3[_0x6dc0('0x3c')]=_[_0x6dc0('0x3d')](_0x3324fa[_0x6dc0('0x3c')]);_0x2149a3[_0x6dc0('0x3e')]=_['intersection'](_0x2149a3['model'],_0x2149a3['query']);_0x2845c0[_0x6dc0('0x3f')]=_[_0x6dc0('0x40')](_0x2149a3[_0x6dc0('0x3b')],qs[_0x6dc0('0x41')](_0x3324fa[_0x6dc0('0x3c')][_0x6dc0('0x41')]));_0x2845c0['attributes']=_0x2845c0[_0x6dc0('0x3f')]['length']?_0x2845c0[_0x6dc0('0x3f')]:_0x2149a3[_0x6dc0('0x3b')];if(!_0x3324fa['query'][_0x6dc0('0x42')]('nolimit')){_0x2845c0[_0x6dc0('0x2c')]=qs[_0x6dc0('0x2c')](_0x3324fa[_0x6dc0('0x3c')]['limit']);_0x2845c0[_0x6dc0('0x2b')]=qs[_0x6dc0('0x2b')](_0x3324fa[_0x6dc0('0x3c')]['offset']);}_0x2845c0[_0x6dc0('0x43')]=qs['sort'](_0x3324fa['query'][_0x6dc0('0x44')]);_0x2845c0['where']=qs['filters'](_['pick'](_0x3324fa[_0x6dc0('0x3c')],_0x2149a3[_0x6dc0('0x3e')]));if(_0x3324fa['query'][_0x6dc0('0x45')]){_0x2845c0[_0x6dc0('0x46')]=_['merge'](_0x2845c0[_0x6dc0('0x46')],{'$or':_[_0x6dc0('0x38')](_0x299a73,function(_0x2bee01){if(_0x2bee01[_0x6dc0('0x3a')]!==_0x6dc0('0x47')){var _0x5b54aa={};_0x5b54aa[_0x2bee01['name']]={'$like':'%'+_0x3324fa['query'][_0x6dc0('0x45')]+'%'};return _0x5b54aa;}})});}_0x2845c0=_[_0x6dc0('0x48')]({},_0x2845c0,_0x3324fa[_0x6dc0('0x49')]);var _0x1b915e={'where':_0x2845c0[_0x6dc0('0x46')]};return db[_0x6dc0('0x39')][_0x6dc0('0x2a')](_0x1b915e)['then'](function(_0x45a4d4){_0x39d2c0[_0x6dc0('0x2a')]=_0x45a4d4;if(_0x3324fa['query']['includeAll']){_0x2845c0['include']=[{'all':!![]}];}return db[_0x6dc0('0x39')]['findAll'](_0x2845c0);})[_0x6dc0('0x1d')](function(_0x5c75e3){_0x39d2c0[_0x6dc0('0x4a')]=_0x5c75e3;return _0x39d2c0;})[_0x6dc0('0x1d')](respondWithFilteredResult(_0x2c8aa8,_0x2845c0))[_0x6dc0('0x4b')](handleError(_0x2c8aa8,null));};exports['show']=function(_0x441b4b,_0x1b318d){var _0x58c9b2={'raw':![],'where':{'id':_0x441b4b[_0x6dc0('0x4c')]['id']}},_0x5ea9f3={};_0x5ea9f3[_0x6dc0('0x3b')]=_[_0x6dc0('0x3d')](db['SugarcrmConfiguration'][_0x6dc0('0x4d')]);_0x5ea9f3[_0x6dc0('0x3c')]=_[_0x6dc0('0x3d')](_0x441b4b[_0x6dc0('0x3c')]);_0x5ea9f3['filters']=_['intersection'](_0x5ea9f3[_0x6dc0('0x3b')],_0x5ea9f3['query']);_0x58c9b2['attributes']=_[_0x6dc0('0x40')](_0x5ea9f3['model'],qs[_0x6dc0('0x41')](_0x441b4b[_0x6dc0('0x3c')]['fields']));_0x58c9b2[_0x6dc0('0x3f')]=_0x58c9b2[_0x6dc0('0x3f')][_0x6dc0('0x4e')]?_0x58c9b2[_0x6dc0('0x3f')]:_0x5ea9f3[_0x6dc0('0x3b')];if(_0x441b4b[_0x6dc0('0x3c')][_0x6dc0('0x4f')]){_0x58c9b2['include']=[{'all':!![]}];}_0x58c9b2=_['merge']({},_0x58c9b2,_0x441b4b[_0x6dc0('0x49')]);return db[_0x6dc0('0x39')]['find'](_0x58c9b2)['then'](handleEntityNotFound(_0x1b318d,null))[_0x6dc0('0x1d')](respondWithResult(_0x1b318d,null))[_0x6dc0('0x4b')](handleError(_0x1b318d,null));};exports[_0x6dc0('0x50')]=function(_0x1ab57a,_0x315443){return db[_0x6dc0('0x39')][_0x6dc0('0x50')](_0x1ab57a[_0x6dc0('0x51')],{})[_0x6dc0('0x1d')](respondWithResult(_0x315443,0xc9))['catch'](handleError(_0x315443,null));};exports['update']=function(_0x5d18b2,_0x489014){if(_0x5d18b2['body']['id']){delete _0x5d18b2[_0x6dc0('0x51')]['id'];}return db[_0x6dc0('0x39')][_0x6dc0('0x52')]({'where':{'id':_0x5d18b2[_0x6dc0('0x4c')]['id']}})[_0x6dc0('0x1d')](handleEntityNotFound(_0x489014,null))[_0x6dc0('0x1d')](saveUpdates(_0x5d18b2[_0x6dc0('0x51')],null))[_0x6dc0('0x1d')](respondWithResult(_0x489014,null))[_0x6dc0('0x4b')](handleError(_0x489014,null));};exports[_0x6dc0('0x33')]=function(_0x472650,_0x5b6945){return db['SugarcrmConfiguration'][_0x6dc0('0x52')]({'where':{'id':_0x472650[_0x6dc0('0x4c')]['id']}})[_0x6dc0('0x1d')](handleEntityNotFound(_0x5b6945,null))['then'](removeEntity(_0x5b6945,null))[_0x6dc0('0x4b')](handleError(_0x5b6945,null));};exports[_0x6dc0('0x53')]=function(_0x1ee8d4,_0x1a5912,_0x1bc069){var _0x122306={};var _0x30e134={};var _0x124616;var _0x885fae;return db[_0x6dc0('0x39')]['findOne']({'where':{'id':_0x1ee8d4[_0x6dc0('0x4c')]['id']}})[_0x6dc0('0x1d')](handleEntityNotFound(_0x1a5912,null))['then'](function(_0x3a9c15){if(_0x3a9c15){_0x124616=_0x3a9c15;_0x30e134[_0x6dc0('0x3b')]=_['keys'](db[_0x6dc0('0x54')]['rawAttributes']);_0x30e134[_0x6dc0('0x3c')]=_[_0x6dc0('0x3d')](_0x1ee8d4[_0x6dc0('0x3c')]);_0x30e134[_0x6dc0('0x3e')]=_[_0x6dc0('0x40')](_0x30e134[_0x6dc0('0x3b')],_0x30e134['query']);_0x122306[_0x6dc0('0x3f')]=_[_0x6dc0('0x40')](_0x30e134['model'],qs['fields'](_0x1ee8d4[_0x6dc0('0x3c')][_0x6dc0('0x41')]));_0x122306[_0x6dc0('0x3f')]=_0x122306[_0x6dc0('0x3f')][_0x6dc0('0x4e')]?_0x122306[_0x6dc0('0x3f')]:_0x30e134[_0x6dc0('0x3b')];_0x122306['order']=qs[_0x6dc0('0x44')](_0x1ee8d4[_0x6dc0('0x3c')][_0x6dc0('0x44')]);_0x122306[_0x6dc0('0x46')]=qs[_0x6dc0('0x3e')](_['pick'](_0x1ee8d4['query'],_0x30e134['filters']));if(_0x1ee8d4[_0x6dc0('0x3c')][_0x6dc0('0x45')]){_0x122306[_0x6dc0('0x46')]=_[_0x6dc0('0x48')](_0x122306[_0x6dc0('0x46')],{'$or':_['map'](_0x122306[_0x6dc0('0x3f')],function(_0xf88283){var _0xc418d5={};_0xc418d5[_0xf88283]={'$like':'%'+_0x1ee8d4[_0x6dc0('0x3c')][_0x6dc0('0x45')]+'%'};return _0xc418d5;})});}_0x122306=_['merge']({},_0x122306,_0x1ee8d4[_0x6dc0('0x49')]);return _0x124616[_0x6dc0('0x53')](_0x122306);}})[_0x6dc0('0x1d')](function(_0x57e72){if(_0x57e72){_0x885fae=_0x57e72[_0x6dc0('0x4e')];if(!_0x1ee8d4[_0x6dc0('0x3c')][_0x6dc0('0x42')](_0x6dc0('0x55'))){_0x122306['limit']=qs[_0x6dc0('0x2c')](_0x1ee8d4[_0x6dc0('0x3c')]['limit']);_0x122306['offset']=qs[_0x6dc0('0x2b')](_0x1ee8d4['query'][_0x6dc0('0x2b')]);}return _0x124616[_0x6dc0('0x53')](_0x122306);}})[_0x6dc0('0x1d')](function(_0x439445){if(_0x439445){return _0x439445?{'count':_0x885fae,'rows':_0x439445}:null;}})[_0x6dc0('0x1d')](respondWithResult(_0x1a5912,null))[_0x6dc0('0x4b')](handleError(_0x1a5912,null));};exports[_0x6dc0('0x56')]=function(_0x2a4c68,_0x99682,_0x19c977){var _0x4873db={};var _0x111870={};var _0xbb733a;var _0x3cb84f;return db[_0x6dc0('0x39')][_0x6dc0('0x57')]({'where':{'id':_0x2a4c68[_0x6dc0('0x4c')]['id']}})[_0x6dc0('0x1d')](handleEntityNotFound(_0x99682,null))[_0x6dc0('0x1d')](function(_0x17aedf){if(_0x17aedf){_0xbb733a=_0x17aedf;_0x111870['model']=_['keys'](db[_0x6dc0('0x54')][_0x6dc0('0x4d')]);_0x111870['query']=_['keys'](_0x2a4c68[_0x6dc0('0x3c')]);_0x111870['filters']=_[_0x6dc0('0x40')](_0x111870[_0x6dc0('0x3b')],_0x111870[_0x6dc0('0x3c')]);_0x4873db['attributes']=_[_0x6dc0('0x40')](_0x111870[_0x6dc0('0x3b')],qs[_0x6dc0('0x41')](_0x2a4c68[_0x6dc0('0x3c')][_0x6dc0('0x41')]));_0x4873db[_0x6dc0('0x3f')]=_0x4873db[_0x6dc0('0x3f')][_0x6dc0('0x4e')]?_0x4873db[_0x6dc0('0x3f')]:_0x111870[_0x6dc0('0x3b')];_0x4873db[_0x6dc0('0x43')]=qs[_0x6dc0('0x44')](_0x2a4c68[_0x6dc0('0x3c')][_0x6dc0('0x44')]);_0x4873db[_0x6dc0('0x46')]=qs['filters'](_[_0x6dc0('0x58')](_0x2a4c68[_0x6dc0('0x3c')],_0x111870['filters']));if(_0x2a4c68[_0x6dc0('0x3c')][_0x6dc0('0x45')]){_0x4873db[_0x6dc0('0x46')]=_['merge'](_0x4873db[_0x6dc0('0x46')],{'$or':_[_0x6dc0('0x38')](_0x4873db[_0x6dc0('0x3f')],function(_0x3ff6e0){var _0xd2c4a0={};_0xd2c4a0[_0x3ff6e0]={'$like':'%'+_0x2a4c68[_0x6dc0('0x3c')][_0x6dc0('0x45')]+'%'};return _0xd2c4a0;})});}_0x4873db=_['merge']({},_0x4873db,_0x2a4c68[_0x6dc0('0x49')]);return _0xbb733a[_0x6dc0('0x56')](_0x4873db);}})[_0x6dc0('0x1d')](function(_0x3d372d){if(_0x3d372d){_0x3cb84f=_0x3d372d[_0x6dc0('0x4e')];if(!_0x2a4c68[_0x6dc0('0x3c')]['hasOwnProperty'](_0x6dc0('0x55'))){_0x4873db[_0x6dc0('0x2c')]=qs['limit'](_0x2a4c68[_0x6dc0('0x3c')][_0x6dc0('0x2c')]);_0x4873db[_0x6dc0('0x2b')]=qs[_0x6dc0('0x2b')](_0x2a4c68[_0x6dc0('0x3c')][_0x6dc0('0x2b')]);}return _0xbb733a[_0x6dc0('0x56')](_0x4873db);}})[_0x6dc0('0x1d')](function(_0x506898){if(_0x506898){return _0x506898?{'count':_0x3cb84f,'rows':_0x506898}:null;}})[_0x6dc0('0x1d')](respondWithResult(_0x99682,null))[_0x6dc0('0x4b')](handleError(_0x99682,null));};exports[_0x6dc0('0x59')]=function(_0x3dd10b,_0x58beb6,_0x37d9ff){var _0x5da1af={};var _0x489278={};var _0x1f87f8;var _0x4760a6;return db[_0x6dc0('0x39')][_0x6dc0('0x57')]({'where':{'id':_0x3dd10b[_0x6dc0('0x4c')]['id']}})[_0x6dc0('0x1d')](handleEntityNotFound(_0x58beb6,null))[_0x6dc0('0x1d')](function(_0x38b2cc){if(_0x38b2cc){_0x1f87f8=_0x38b2cc;_0x489278['model']=_['keys'](db[_0x6dc0('0x54')][_0x6dc0('0x4d')]);_0x489278['query']=_['keys'](_0x3dd10b[_0x6dc0('0x3c')]);_0x489278['filters']=_['intersection'](_0x489278[_0x6dc0('0x3b')],_0x489278[_0x6dc0('0x3c')]);_0x5da1af[_0x6dc0('0x3f')]=_['intersection'](_0x489278[_0x6dc0('0x3b')],qs[_0x6dc0('0x41')](_0x3dd10b[_0x6dc0('0x3c')][_0x6dc0('0x41')]));_0x5da1af[_0x6dc0('0x3f')]=_0x5da1af[_0x6dc0('0x3f')][_0x6dc0('0x4e')]?_0x5da1af['attributes']:_0x489278[_0x6dc0('0x3b')];_0x5da1af[_0x6dc0('0x43')]=qs[_0x6dc0('0x44')](_0x3dd10b[_0x6dc0('0x3c')]['sort']);_0x5da1af[_0x6dc0('0x46')]=qs[_0x6dc0('0x3e')](_[_0x6dc0('0x58')](_0x3dd10b[_0x6dc0('0x3c')],_0x489278['filters']));if(_0x3dd10b[_0x6dc0('0x3c')][_0x6dc0('0x45')]){_0x5da1af[_0x6dc0('0x46')]=_[_0x6dc0('0x48')](_0x5da1af[_0x6dc0('0x46')],{'$or':_['map'](_0x5da1af[_0x6dc0('0x3f')],function(_0x3a8a0a){var _0x41b182={};_0x41b182[_0x3a8a0a]={'$like':'%'+_0x3dd10b[_0x6dc0('0x3c')][_0x6dc0('0x45')]+'%'};return _0x41b182;})});}_0x5da1af=_[_0x6dc0('0x48')]({},_0x5da1af,_0x3dd10b[_0x6dc0('0x49')]);return _0x1f87f8[_0x6dc0('0x59')](_0x5da1af);}})[_0x6dc0('0x1d')](function(_0x312863){if(_0x312863){_0x4760a6=_0x312863[_0x6dc0('0x4e')];if(!_0x3dd10b[_0x6dc0('0x3c')]['hasOwnProperty']('nolimit')){_0x5da1af[_0x6dc0('0x2c')]=qs[_0x6dc0('0x2c')](_0x3dd10b[_0x6dc0('0x3c')][_0x6dc0('0x2c')]);_0x5da1af[_0x6dc0('0x2b')]=qs[_0x6dc0('0x2b')](_0x3dd10b[_0x6dc0('0x3c')]['offset']);}return _0x1f87f8[_0x6dc0('0x59')](_0x5da1af);}})['then'](function(_0x1cd52e){if(_0x1cd52e){return _0x1cd52e?{'count':_0x4760a6,'rows':_0x1cd52e}:null;}})[_0x6dc0('0x1d')](respondWithResult(_0x58beb6,null))[_0x6dc0('0x4b')](handleError(_0x58beb6,null));};
\ No newline at end of file
+var _0xc776=['fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/license/util','sendStatus','status','json','offset','undefined','limit','count','apply','reject','save','update','then','end','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','length','nolimit','order','sort','where','pick','filter','merge','options','includeAll','include','SugarcrmConfiguration','findAll','rows','catch','show','params','keys','fields','find','create','body','findOne','getFields','hasOwnProperty','SugarcrmField','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv'];(function(_0xe8717e,_0x3e4490){var _0x35fe19=function(_0x586c18){while(--_0x586c18){_0xe8717e['push'](_0xe8717e['shift']());}};_0x35fe19(++_0x3e4490);}(_0xc776,0x18a));var _0x6c77=function(_0x3fd60a,_0x217502){_0x3fd60a=_0x3fd60a-0x0;var _0x2aa415=_0xc776[_0x3fd60a];return _0x2aa415;};'use strict';var emlformat=require(_0x6c77('0x0'));var rimraf=require(_0x6c77('0x1'));var zipdir=require(_0x6c77('0x2'));var jsonpatch=require(_0x6c77('0x3'));var rp=require(_0x6c77('0x4'));var moment=require(_0x6c77('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x6c77('0x6'));var util=require(_0x6c77('0x7'));var path=require(_0x6c77('0x8'));var sox=require(_0x6c77('0x9'));var csv=require(_0x6c77('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x6c77('0xb'));var _=require(_0x6c77('0xc'));var squel=require(_0x6c77('0xd'));var crypto=require(_0x6c77('0xe'));var jsforce=require(_0x6c77('0xf'));var deskjs=require(_0x6c77('0x10'));var toCsv=require(_0x6c77('0xa'));var querystring=require(_0x6c77('0x11'));var Papa=require(_0x6c77('0x12'));var Redis=require(_0x6c77('0x13'));var authService=require(_0x6c77('0x14'));var qs=require(_0x6c77('0x15'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x6c77('0x16'))(_0x6c77('0x17'));var utils=require('../../config/utils');var config=require(_0x6c77('0x18'));var licenseUtil=require(_0x6c77('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x43bf53,_0x3fc944){_0x3fc944=_0x3fc944||0xcc;return function(_0xc9b555){if(_0xc9b555){return _0x43bf53[_0x6c77('0x1a')](_0x3fc944);}return _0x43bf53[_0x6c77('0x1b')](_0x3fc944)['end']();};}function respondWithResult(_0x45c16c,_0x3a9034){_0x3a9034=_0x3a9034||0xc8;return function(_0x5eee2a){if(_0x5eee2a){return _0x45c16c[_0x6c77('0x1b')](_0x3a9034)[_0x6c77('0x1c')](_0x5eee2a);}};}function respondWithFilteredResult(_0x3952c4,_0x26dd41){return function(_0x737a87){if(_0x737a87){var _0x44ba2b=typeof _0x26dd41[_0x6c77('0x1d')]===_0x6c77('0x1e')&&typeof _0x26dd41[_0x6c77('0x1f')]==='undefined';var _0x4fbaad=_0x737a87[_0x6c77('0x20')];var _0xc64982=_0x44ba2b?0x0:_0x26dd41[_0x6c77('0x1d')];var _0x43f4ec=_0x44ba2b?_0x737a87['count']:_0x26dd41[_0x6c77('0x1d')]+_0x26dd41[_0x6c77('0x1f')];var _0x1df74a;if(_0x43f4ec>=_0x4fbaad){_0x43f4ec=_0x4fbaad;_0x1df74a=0xc8;}else{_0x1df74a=0xce;}_0x3952c4['status'](_0x1df74a);return _0x3952c4['set']('Content-Range',_0xc64982+'-'+_0x43f4ec+'/'+_0x4fbaad)[_0x6c77('0x1c')](_0x737a87);}return null;};}function patchUpdates(_0x530ec6){return function(_0x40efa0){try{jsonpatch[_0x6c77('0x21')](_0x40efa0,_0x530ec6,!![]);}catch(_0x562b58){return BPromise[_0x6c77('0x22')](_0x562b58);}return _0x40efa0[_0x6c77('0x23')]();};}function saveUpdates(_0x358099,_0x1ba542){return function(_0x5d0de0){if(_0x5d0de0){return _0x5d0de0[_0x6c77('0x24')](_0x358099)[_0x6c77('0x25')](function(_0x1846b5){return _0x1846b5;});}return null;};}function removeEntity(_0x4e4ca4,_0x325dc1){return function(_0x33e99c){if(_0x33e99c){return _0x33e99c['destroy']()[_0x6c77('0x25')](function(){_0x4e4ca4['status'](0xcc)[_0x6c77('0x26')]();});}};}function handleEntityNotFound(_0x24566c,_0x4fd58d){return function(_0x1a412f){if(!_0x1a412f){_0x24566c[_0x6c77('0x1a')](0x194);}return _0x1a412f;};}function handleError(_0x55655f,_0x403891){_0x403891=_0x403891||0x1f4;return function(_0x509bb4){logger['error'](_0x509bb4[_0x6c77('0x27')]);if(_0x509bb4[_0x6c77('0x28')]){delete _0x509bb4[_0x6c77('0x28')];}_0x55655f[_0x6c77('0x1b')](_0x403891)[_0x6c77('0x29')](_0x509bb4);};}exports[_0x6c77('0x2a')]=function(_0x2ccb6a,_0x1c6cc6){var _0x17d88a={},_0x3d0567={},_0x166ec6={'count':0x0,'rows':[]};var _0x133a84=_[_0x6c77('0x2b')](db['SugarcrmConfiguration'][_0x6c77('0x2c')],function(_0x1118ae){return{'name':_0x1118ae[_0x6c77('0x2d')],'type':_0x1118ae[_0x6c77('0x2e')][_0x6c77('0x2f')]};});_0x3d0567[_0x6c77('0x30')]=_[_0x6c77('0x2b')](_0x133a84,_0x6c77('0x28'));_0x3d0567[_0x6c77('0x31')]=_['keys'](_0x2ccb6a[_0x6c77('0x31')]);_0x3d0567[_0x6c77('0x32')]=_[_0x6c77('0x33')](_0x3d0567[_0x6c77('0x30')],_0x3d0567[_0x6c77('0x31')]);_0x17d88a[_0x6c77('0x34')]=_[_0x6c77('0x33')](_0x3d0567[_0x6c77('0x30')],qs['fields'](_0x2ccb6a[_0x6c77('0x31')]['fields']));_0x17d88a[_0x6c77('0x34')]=_0x17d88a[_0x6c77('0x34')][_0x6c77('0x35')]?_0x17d88a[_0x6c77('0x34')]:_0x3d0567[_0x6c77('0x30')];if(!_0x2ccb6a['query']['hasOwnProperty'](_0x6c77('0x36'))){_0x17d88a['limit']=qs[_0x6c77('0x1f')](_0x2ccb6a[_0x6c77('0x31')][_0x6c77('0x1f')]);_0x17d88a[_0x6c77('0x1d')]=qs[_0x6c77('0x1d')](_0x2ccb6a[_0x6c77('0x31')][_0x6c77('0x1d')]);}_0x17d88a[_0x6c77('0x37')]=qs[_0x6c77('0x38')](_0x2ccb6a[_0x6c77('0x31')][_0x6c77('0x38')]);_0x17d88a[_0x6c77('0x39')]=qs[_0x6c77('0x32')](_[_0x6c77('0x3a')](_0x2ccb6a[_0x6c77('0x31')],_0x3d0567['filters']),_0x133a84);if(_0x2ccb6a[_0x6c77('0x31')][_0x6c77('0x3b')]){_0x17d88a[_0x6c77('0x39')]=_['merge'](_0x17d88a[_0x6c77('0x39')],{'$or':_['map'](_0x133a84,function(_0x221266){if(_0x221266[_0x6c77('0x2e')]!=='VIRTUAL'){var _0x3c048d={};_0x3c048d[_0x221266[_0x6c77('0x28')]]={'$like':'%'+_0x2ccb6a['query'][_0x6c77('0x3b')]+'%'};return _0x3c048d;}})});}_0x17d88a=_[_0x6c77('0x3c')]({},_0x17d88a,_0x2ccb6a[_0x6c77('0x3d')]);var _0x23af76={'where':_0x17d88a['where']};return db['SugarcrmConfiguration'][_0x6c77('0x20')](_0x23af76)[_0x6c77('0x25')](function(_0x512612){_0x166ec6[_0x6c77('0x20')]=_0x512612;if(_0x2ccb6a['query'][_0x6c77('0x3e')]){_0x17d88a[_0x6c77('0x3f')]=[{'all':!![]}];}return db[_0x6c77('0x40')][_0x6c77('0x41')](_0x17d88a);})['then'](function(_0x439767){_0x166ec6[_0x6c77('0x42')]=_0x439767;return _0x166ec6;})[_0x6c77('0x25')](respondWithFilteredResult(_0x1c6cc6,_0x17d88a))[_0x6c77('0x43')](handleError(_0x1c6cc6,null));};exports[_0x6c77('0x44')]=function(_0x5f39c2,_0x218e00){var _0x29609c={'raw':![],'where':{'id':_0x5f39c2[_0x6c77('0x45')]['id']}},_0x248c48={};_0x248c48[_0x6c77('0x30')]=_['keys'](db[_0x6c77('0x40')][_0x6c77('0x2c')]);_0x248c48[_0x6c77('0x31')]=_[_0x6c77('0x46')](_0x5f39c2[_0x6c77('0x31')]);_0x248c48[_0x6c77('0x32')]=_[_0x6c77('0x33')](_0x248c48[_0x6c77('0x30')],_0x248c48[_0x6c77('0x31')]);_0x29609c['attributes']=_[_0x6c77('0x33')](_0x248c48[_0x6c77('0x30')],qs['fields'](_0x5f39c2[_0x6c77('0x31')][_0x6c77('0x47')]));_0x29609c[_0x6c77('0x34')]=_0x29609c[_0x6c77('0x34')][_0x6c77('0x35')]?_0x29609c[_0x6c77('0x34')]:_0x248c48[_0x6c77('0x30')];if(_0x5f39c2[_0x6c77('0x31')]['includeAll']){_0x29609c[_0x6c77('0x3f')]=[{'all':!![]}];}_0x29609c=_[_0x6c77('0x3c')]({},_0x29609c,_0x5f39c2[_0x6c77('0x3d')]);return db['SugarcrmConfiguration'][_0x6c77('0x48')](_0x29609c)[_0x6c77('0x25')](handleEntityNotFound(_0x218e00,null))[_0x6c77('0x25')](respondWithResult(_0x218e00,null))['catch'](handleError(_0x218e00,null));};exports[_0x6c77('0x49')]=function(_0x717fa4,_0x709dbb){return db[_0x6c77('0x40')][_0x6c77('0x49')](_0x717fa4[_0x6c77('0x4a')],{})[_0x6c77('0x25')](respondWithResult(_0x709dbb,0xc9))[_0x6c77('0x43')](handleError(_0x709dbb,null));};exports[_0x6c77('0x24')]=function(_0x625a9f,_0x49bf05){if(_0x625a9f[_0x6c77('0x4a')]['id']){delete _0x625a9f[_0x6c77('0x4a')]['id'];}return db['SugarcrmConfiguration'][_0x6c77('0x48')]({'where':{'id':_0x625a9f[_0x6c77('0x45')]['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0x49bf05,null))['then'](saveUpdates(_0x625a9f['body'],null))[_0x6c77('0x25')](respondWithResult(_0x49bf05,null))[_0x6c77('0x43')](handleError(_0x49bf05,null));};exports['destroy']=function(_0x4c1f25,_0x570964){return db[_0x6c77('0x40')]['find']({'where':{'id':_0x4c1f25['params']['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0x570964,null))[_0x6c77('0x25')](removeEntity(_0x570964,null))[_0x6c77('0x43')](handleError(_0x570964,null));};exports['getFields']=function(_0x134ff9,_0x5ae7d9,_0x3477b9){var _0x316b5c={};var _0x299bcf={};var _0x4fbd6f;var _0x45116a;return db['SugarcrmConfiguration'][_0x6c77('0x4b')]({'where':{'id':_0x134ff9['params']['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0x5ae7d9,null))['then'](function(_0x189f82){if(_0x189f82){_0x4fbd6f=_0x189f82;_0x299bcf[_0x6c77('0x30')]=_[_0x6c77('0x46')](db['SugarcrmField'][_0x6c77('0x2c')]);_0x299bcf['query']=_['keys'](_0x134ff9[_0x6c77('0x31')]);_0x299bcf[_0x6c77('0x32')]=_[_0x6c77('0x33')](_0x299bcf[_0x6c77('0x30')],_0x299bcf['query']);_0x316b5c[_0x6c77('0x34')]=_[_0x6c77('0x33')](_0x299bcf[_0x6c77('0x30')],qs[_0x6c77('0x47')](_0x134ff9['query'][_0x6c77('0x47')]));_0x316b5c['attributes']=_0x316b5c[_0x6c77('0x34')][_0x6c77('0x35')]?_0x316b5c[_0x6c77('0x34')]:_0x299bcf['model'];_0x316b5c[_0x6c77('0x37')]=qs['sort'](_0x134ff9[_0x6c77('0x31')][_0x6c77('0x38')]);_0x316b5c[_0x6c77('0x39')]=qs['filters'](_[_0x6c77('0x3a')](_0x134ff9['query'],_0x299bcf[_0x6c77('0x32')]));if(_0x134ff9['query']['filter']){_0x316b5c[_0x6c77('0x39')]=_[_0x6c77('0x3c')](_0x316b5c[_0x6c77('0x39')],{'$or':_[_0x6c77('0x2b')](_0x316b5c[_0x6c77('0x34')],function(_0x53105b){var _0x1bf3f3={};_0x1bf3f3[_0x53105b]={'$like':'%'+_0x134ff9[_0x6c77('0x31')][_0x6c77('0x3b')]+'%'};return _0x1bf3f3;})});}_0x316b5c=_['merge']({},_0x316b5c,_0x134ff9['options']);return _0x4fbd6f[_0x6c77('0x4c')](_0x316b5c);}})[_0x6c77('0x25')](function(_0x4f7b3e){if(_0x4f7b3e){_0x45116a=_0x4f7b3e[_0x6c77('0x35')];if(!_0x134ff9[_0x6c77('0x31')][_0x6c77('0x4d')](_0x6c77('0x36'))){_0x316b5c[_0x6c77('0x1f')]=qs[_0x6c77('0x1f')](_0x134ff9['query'][_0x6c77('0x1f')]);_0x316b5c[_0x6c77('0x1d')]=qs[_0x6c77('0x1d')](_0x134ff9['query'][_0x6c77('0x1d')]);}return _0x4fbd6f[_0x6c77('0x4c')](_0x316b5c);}})[_0x6c77('0x25')](function(_0x52ced0){if(_0x52ced0){return _0x52ced0?{'count':_0x45116a,'rows':_0x52ced0}:null;}})[_0x6c77('0x25')](respondWithResult(_0x5ae7d9,null))[_0x6c77('0x43')](handleError(_0x5ae7d9,null));};exports['getSubjects']=function(_0x41cb8a,_0xb2f3ed,_0xd7feb){var _0x45ed05={};var _0x2fe1ff={};var _0xf10ffe;var _0x411e9e;return db[_0x6c77('0x40')]['findOne']({'where':{'id':_0x41cb8a[_0x6c77('0x45')]['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0xb2f3ed,null))[_0x6c77('0x25')](function(_0x13630f){if(_0x13630f){_0xf10ffe=_0x13630f;_0x2fe1ff[_0x6c77('0x30')]=_[_0x6c77('0x46')](db[_0x6c77('0x4e')]['rawAttributes']);_0x2fe1ff[_0x6c77('0x31')]=_[_0x6c77('0x46')](_0x41cb8a[_0x6c77('0x31')]);_0x2fe1ff['filters']=_['intersection'](_0x2fe1ff[_0x6c77('0x30')],_0x2fe1ff[_0x6c77('0x31')]);_0x45ed05['attributes']=_['intersection'](_0x2fe1ff[_0x6c77('0x30')],qs[_0x6c77('0x47')](_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x47')]));_0x45ed05[_0x6c77('0x34')]=_0x45ed05[_0x6c77('0x34')][_0x6c77('0x35')]?_0x45ed05[_0x6c77('0x34')]:_0x2fe1ff[_0x6c77('0x30')];_0x45ed05['order']=qs[_0x6c77('0x38')](_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x38')]);_0x45ed05['where']=qs[_0x6c77('0x32')](_['pick'](_0x41cb8a['query'],_0x2fe1ff[_0x6c77('0x32')]));if(_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x3b')]){_0x45ed05[_0x6c77('0x39')]=_['merge'](_0x45ed05['where'],{'$or':_[_0x6c77('0x2b')](_0x45ed05[_0x6c77('0x34')],function(_0x2c2de4){var _0x42c7a1={};_0x42c7a1[_0x2c2de4]={'$like':'%'+_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x3b')]+'%'};return _0x42c7a1;})});}_0x45ed05=_[_0x6c77('0x3c')]({},_0x45ed05,_0x41cb8a[_0x6c77('0x3d')]);return _0xf10ffe[_0x6c77('0x4f')](_0x45ed05);}})['then'](function(_0x3b8a3b){if(_0x3b8a3b){_0x411e9e=_0x3b8a3b[_0x6c77('0x35')];if(!_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x4d')](_0x6c77('0x36'))){_0x45ed05['limit']=qs[_0x6c77('0x1f')](_0x41cb8a[_0x6c77('0x31')]['limit']);_0x45ed05[_0x6c77('0x1d')]=qs[_0x6c77('0x1d')](_0x41cb8a[_0x6c77('0x31')][_0x6c77('0x1d')]);}return _0xf10ffe[_0x6c77('0x4f')](_0x45ed05);}})[_0x6c77('0x25')](function(_0x20fc0b){if(_0x20fc0b){return _0x20fc0b?{'count':_0x411e9e,'rows':_0x20fc0b}:null;}})[_0x6c77('0x25')](respondWithResult(_0xb2f3ed,null))[_0x6c77('0x43')](handleError(_0xb2f3ed,null));};exports[_0x6c77('0x50')]=function(_0x2970de,_0x2a5f0d,_0x4e7c0d){var _0x2a07df={};var _0x1b0cff={};var _0x438c10;var _0x360577;return db['SugarcrmConfiguration']['findOne']({'where':{'id':_0x2970de[_0x6c77('0x45')]['id']}})[_0x6c77('0x25')](handleEntityNotFound(_0x2a5f0d,null))['then'](function(_0xc6debb){if(_0xc6debb){_0x438c10=_0xc6debb;_0x1b0cff[_0x6c77('0x30')]=_[_0x6c77('0x46')](db['SugarcrmField'][_0x6c77('0x2c')]);_0x1b0cff[_0x6c77('0x31')]=_[_0x6c77('0x46')](_0x2970de[_0x6c77('0x31')]);_0x1b0cff['filters']=_['intersection'](_0x1b0cff['model'],_0x1b0cff[_0x6c77('0x31')]);_0x2a07df[_0x6c77('0x34')]=_[_0x6c77('0x33')](_0x1b0cff[_0x6c77('0x30')],qs[_0x6c77('0x47')](_0x2970de[_0x6c77('0x31')]['fields']));_0x2a07df['attributes']=_0x2a07df[_0x6c77('0x34')][_0x6c77('0x35')]?_0x2a07df[_0x6c77('0x34')]:_0x1b0cff[_0x6c77('0x30')];_0x2a07df['order']=qs[_0x6c77('0x38')](_0x2970de['query'][_0x6c77('0x38')]);_0x2a07df[_0x6c77('0x39')]=qs['filters'](_[_0x6c77('0x3a')](_0x2970de[_0x6c77('0x31')],_0x1b0cff[_0x6c77('0x32')]));if(_0x2970de['query'][_0x6c77('0x3b')]){_0x2a07df['where']=_[_0x6c77('0x3c')](_0x2a07df[_0x6c77('0x39')],{'$or':_['map'](_0x2a07df[_0x6c77('0x34')],function(_0x1f5856){var _0x76c9f={};_0x76c9f[_0x1f5856]={'$like':'%'+_0x2970de[_0x6c77('0x31')][_0x6c77('0x3b')]+'%'};return _0x76c9f;})});}_0x2a07df=_['merge']({},_0x2a07df,_0x2970de[_0x6c77('0x3d')]);return _0x438c10[_0x6c77('0x50')](_0x2a07df);}})[_0x6c77('0x25')](function(_0x57cf1d){if(_0x57cf1d){_0x360577=_0x57cf1d['length'];if(!_0x2970de[_0x6c77('0x31')][_0x6c77('0x4d')](_0x6c77('0x36'))){_0x2a07df[_0x6c77('0x1f')]=qs[_0x6c77('0x1f')](_0x2970de[_0x6c77('0x31')][_0x6c77('0x1f')]);_0x2a07df['offset']=qs[_0x6c77('0x1d')](_0x2970de[_0x6c77('0x31')][_0x6c77('0x1d')]);}return _0x438c10[_0x6c77('0x50')](_0x2a07df);}})['then'](function(_0x58817d){if(_0x58817d){return _0x58817d?{'count':_0x360577,'rows':_0x58817d}:null;}})[_0x6c77('0x25')](respondWithResult(_0x2a5f0d,null))['catch'](handleError(_0x2a5f0d,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff