// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xfe24=['name','send','index','map','VtigerConfiguration','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','filters','pick','where','merge','VIRTUAL','includeAll','include','findAll','show','params','length','options','find','create','body','update','getFields','findOne','VtigerField','getSubjects','filter','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','fs-extra','lodash','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','jayson/promise','http','request','then','VtigerConfiguration,\x20%s,\x20%s','debug','VtigerConfiguration,\x20%s,\x20%s,\x20%s','request\x20sent','stringify','code','error','message','info','catch','sendStatus','end','status','json','undefined','offset','count','limit','set','Content-Range','apply','reject','save','destroy'];(function(_0x54f32d,_0x39a0a5){var _0x2b73c2=function(_0x4cc816){while(--_0x4cc816){_0x54f32d['push'](_0x54f32d['shift']());}};_0x2b73c2(++_0x39a0a5);}(_0xfe24,0xe5));var _0x4fe2=function(_0x50564d,_0x1b1075){_0x50564d=_0x50564d-0x0;var _0x3699a1=_0xfe24[_0x50564d];return _0x3699a1;};'use strict';var emlformat=require(_0x4fe2('0x0'));var rimraf=require(_0x4fe2('0x1'));var zipdir=require(_0x4fe2('0x2'));var jsonpatch=require(_0x4fe2('0x3'));var rp=require(_0x4fe2('0x4'));var moment=require(_0x4fe2('0x5'));var BPromise=require(_0x4fe2('0x6'));var Mustache=require(_0x4fe2('0x7'));var util=require('util');var path=require('path');var sox=require(_0x4fe2('0x8'));var csv=require(_0x4fe2('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x4fe2('0xa'));var _=require(_0x4fe2('0xb'));var squel=require('squel');var crypto=require(_0x4fe2('0xc'));var jsforce=require(_0x4fe2('0xd'));var deskjs=require(_0x4fe2('0xe'));var toCsv=require(_0x4fe2('0x9'));var querystring=require('querystring');var Papa=require(_0x4fe2('0xf'));var Redis=require(_0x4fe2('0x10'));var authService=require(_0x4fe2('0x11'));var qs=require(_0x4fe2('0x12'));var as=require(_0x4fe2('0x13'));var hardwareService=require(_0x4fe2('0x14'));var logger=require(_0x4fe2('0x15'))(_0x4fe2('0x16'));var utils=require('../../config/utils');var config=require(_0x4fe2('0x17'));var licenseUtil=require(_0x4fe2('0x18'));var db=require('../../mysqldb')['db'];var jayson=require(_0x4fe2('0x19'));var client=jayson['client'][_0x4fe2('0x1a')]({'port':0x232a});function respondWithRpcPromise(_0x19c618,_0x360ea3,_0x570002,_0x261b0a){return new BPromise(function(_0x2dae0f,_0x881071){var _0x2378f6=_0x261b0a||client;return _0x2378f6[_0x4fe2('0x1b')](_0x19c618,_0x570002)[_0x4fe2('0x1c')](function(_0xccba4e){logger['info'](_0x4fe2('0x1d'),_0x360ea3,'request\x20sent');logger[_0x4fe2('0x1e')](_0x4fe2('0x1f'),_0x360ea3,_0x4fe2('0x20'),JSON[_0x4fe2('0x21')](_0xccba4e));if(_0xccba4e['error']){if(_0xccba4e['error'][_0x4fe2('0x22')]===0x1f4){logger[_0x4fe2('0x23')](_0x4fe2('0x1d'),_0x360ea3,_0xccba4e[_0x4fe2('0x23')][_0x4fe2('0x24')]);return _0x881071(_0xccba4e[_0x4fe2('0x23')][_0x4fe2('0x24')]);}logger[_0x4fe2('0x23')](_0x4fe2('0x1d'),_0x360ea3,_0xccba4e[_0x4fe2('0x23')][_0x4fe2('0x24')]);return _0x2dae0f(_0xccba4e[_0x4fe2('0x23')]['message']);}else{logger[_0x4fe2('0x25')]('VtigerConfiguration,\x20%s,\x20%s',_0x360ea3,'request\x20sent');_0x2dae0f(_0xccba4e['result'][_0x4fe2('0x24')]);}})[_0x4fe2('0x26')](function(_0x2fa9c5){logger[_0x4fe2('0x23')]('VtigerConfiguration,\x20%s,\x20%s',_0x360ea3,_0x2fa9c5);_0x881071(_0x2fa9c5);});});}function respondWithStatusCode(_0x54b8f6,_0x4e44bf){_0x4e44bf=_0x4e44bf||0xcc;return function(_0x13c585){if(_0x13c585){return _0x54b8f6[_0x4fe2('0x27')](_0x4e44bf);}return _0x54b8f6['status'](_0x4e44bf)[_0x4fe2('0x28')]();};}function respondWithResult(_0x12776d,_0x4c4d13){_0x4c4d13=_0x4c4d13||0xc8;return function(_0x147415){if(_0x147415){return _0x12776d[_0x4fe2('0x29')](_0x4c4d13)[_0x4fe2('0x2a')](_0x147415);}};}function respondWithFilteredResult(_0xaabe3a,_0x562b0e){return function(_0x2a3e49){if(_0x2a3e49){var _0x207deb=typeof _0x562b0e['offset']===_0x4fe2('0x2b')&&typeof _0x562b0e['limit']===_0x4fe2('0x2b');var _0x57a728=_0x2a3e49['count'];var _0x57b6fc=_0x207deb?0x0:_0x562b0e[_0x4fe2('0x2c')];var _0x3df4be=_0x207deb?_0x2a3e49[_0x4fe2('0x2d')]:_0x562b0e[_0x4fe2('0x2c')]+_0x562b0e[_0x4fe2('0x2e')];var _0x15267a;if(_0x3df4be>=_0x57a728){_0x3df4be=_0x57a728;_0x15267a=0xc8;}else{_0x15267a=0xce;}_0xaabe3a[_0x4fe2('0x29')](_0x15267a);return _0xaabe3a[_0x4fe2('0x2f')](_0x4fe2('0x30'),_0x57b6fc+'-'+_0x3df4be+'/'+_0x57a728)[_0x4fe2('0x2a')](_0x2a3e49);}return null;};}function patchUpdates(_0x309da8){return function(_0x308936){try{jsonpatch[_0x4fe2('0x31')](_0x308936,_0x309da8,!![]);}catch(_0x2badfe){return BPromise[_0x4fe2('0x32')](_0x2badfe);}return _0x308936[_0x4fe2('0x33')]();};}function saveUpdates(_0x1ae2ae,_0x3aa09d){return function(_0x299125){if(_0x299125){return _0x299125['update'](_0x1ae2ae)['then'](function(_0x5481f0){return _0x5481f0;});}return null;};}function removeEntity(_0x3e9b20,_0x3458d5){return function(_0x71c901){if(_0x71c901){return _0x71c901[_0x4fe2('0x34')]()[_0x4fe2('0x1c')](function(){_0x3e9b20[_0x4fe2('0x29')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5848bb,_0x5d8596){return function(_0xb5fb6b){if(!_0xb5fb6b){_0x5848bb[_0x4fe2('0x27')](0x194);}return _0xb5fb6b;};}function handleError(_0x57fe1c,_0x22ab46){_0x22ab46=_0x22ab46||0x1f4;return function(_0x17a6c5){logger['error'](_0x17a6c5['stack']);if(_0x17a6c5[_0x4fe2('0x35')]){delete _0x17a6c5[_0x4fe2('0x35')];}_0x57fe1c['status'](_0x22ab46)[_0x4fe2('0x36')](_0x17a6c5);};}exports[_0x4fe2('0x37')]=function(_0x3476fe,_0x32bdf9){var _0x36ea0c={},_0x37e4ef={},_0x5c6a15={'count':0x0,'rows':[]};var _0x2e9446=_[_0x4fe2('0x38')](db[_0x4fe2('0x39')][_0x4fe2('0x3a')],function(_0x43718a){return{'name':_0x43718a[_0x4fe2('0x3b')],'type':_0x43718a[_0x4fe2('0x3c')][_0x4fe2('0x3d')]};});_0x37e4ef[_0x4fe2('0x3e')]=_[_0x4fe2('0x38')](_0x2e9446,'name');_0x37e4ef[_0x4fe2('0x3f')]=_[_0x4fe2('0x40')](_0x3476fe[_0x4fe2('0x3f')]);_0x37e4ef['filters']=_[_0x4fe2('0x41')](_0x37e4ef[_0x4fe2('0x3e')],_0x37e4ef[_0x4fe2('0x3f')]);_0x36ea0c[_0x4fe2('0x42')]=_[_0x4fe2('0x41')](_0x37e4ef[_0x4fe2('0x3e')],qs[_0x4fe2('0x43')](_0x3476fe[_0x4fe2('0x3f')]['fields']));_0x36ea0c[_0x4fe2('0x42')]=_0x36ea0c['attributes']['length']?_0x36ea0c[_0x4fe2('0x42')]:_0x37e4ef[_0x4fe2('0x3e')];if(!_0x3476fe[_0x4fe2('0x3f')][_0x4fe2('0x44')](_0x4fe2('0x45'))){_0x36ea0c[_0x4fe2('0x2e')]=qs[_0x4fe2('0x2e')](_0x3476fe[_0x4fe2('0x3f')][_0x4fe2('0x2e')]);_0x36ea0c[_0x4fe2('0x2c')]=qs[_0x4fe2('0x2c')](_0x3476fe[_0x4fe2('0x3f')][_0x4fe2('0x2c')]);}_0x36ea0c[_0x4fe2('0x46')]=qs[_0x4fe2('0x47')](_0x3476fe[_0x4fe2('0x3f')][_0x4fe2('0x47')]);_0x36ea0c['where']=qs[_0x4fe2('0x48')](_[_0x4fe2('0x49')](_0x3476fe[_0x4fe2('0x3f')],_0x37e4ef['filters']),_0x2e9446);if(_0x3476fe[_0x4fe2('0x3f')]['filter']){_0x36ea0c[_0x4fe2('0x4a')]=_[_0x4fe2('0x4b')](_0x36ea0c[_0x4fe2('0x4a')],{'$or':_[_0x4fe2('0x38')](_0x2e9446,function(_0x1cfa46){if(_0x1cfa46['type']!==_0x4fe2('0x4c')){var _0x3fc2b6={};_0x3fc2b6[_0x1cfa46[_0x4fe2('0x35')]]={'$like':'%'+_0x3476fe[_0x4fe2('0x3f')]['filter']+'%'};return _0x3fc2b6;}})});}_0x36ea0c=_['merge']({},_0x36ea0c,_0x3476fe['options']);var _0x3d8449={'where':_0x36ea0c[_0x4fe2('0x4a')]};return db[_0x4fe2('0x39')][_0x4fe2('0x2d')](_0x3d8449)[_0x4fe2('0x1c')](function(_0x40e351){_0x5c6a15[_0x4fe2('0x2d')]=_0x40e351;if(_0x3476fe[_0x4fe2('0x3f')][_0x4fe2('0x4d')]){_0x36ea0c[_0x4fe2('0x4e')]=[{'all':!![]}];}return db[_0x4fe2('0x39')][_0x4fe2('0x4f')](_0x36ea0c);})[_0x4fe2('0x1c')](function(_0x1121f6){_0x5c6a15['rows']=_0x1121f6;return _0x5c6a15;})['then'](respondWithFilteredResult(_0x32bdf9,_0x36ea0c))[_0x4fe2('0x26')](handleError(_0x32bdf9,null));};exports[_0x4fe2('0x50')]=function(_0x52c6e5,_0x18c103){var _0x18c1a3={'raw':![],'where':{'id':_0x52c6e5[_0x4fe2('0x51')]['id']}},_0x3a4b06={};_0x3a4b06['model']=_[_0x4fe2('0x40')](db['VtigerConfiguration']['rawAttributes']);_0x3a4b06['query']=_[_0x4fe2('0x40')](_0x52c6e5[_0x4fe2('0x3f')]);_0x3a4b06[_0x4fe2('0x48')]=_[_0x4fe2('0x41')](_0x3a4b06['model'],_0x3a4b06[_0x4fe2('0x3f')]);_0x18c1a3[_0x4fe2('0x42')]=_[_0x4fe2('0x41')](_0x3a4b06[_0x4fe2('0x3e')],qs[_0x4fe2('0x43')](_0x52c6e5['query'][_0x4fe2('0x43')]));_0x18c1a3['attributes']=_0x18c1a3[_0x4fe2('0x42')][_0x4fe2('0x52')]?_0x18c1a3[_0x4fe2('0x42')]:_0x3a4b06[_0x4fe2('0x3e')];if(_0x52c6e5[_0x4fe2('0x3f')][_0x4fe2('0x4d')]){_0x18c1a3[_0x4fe2('0x4e')]=[{'all':!![]}];}_0x18c1a3=_[_0x4fe2('0x4b')]({},_0x18c1a3,_0x52c6e5[_0x4fe2('0x53')]);return db[_0x4fe2('0x39')][_0x4fe2('0x54')](_0x18c1a3)[_0x4fe2('0x1c')](handleEntityNotFound(_0x18c103,null))[_0x4fe2('0x1c')](respondWithResult(_0x18c103,null))['catch'](handleError(_0x18c103,null));};exports[_0x4fe2('0x55')]=function(_0x1d96a6,_0x2ec945){return db[_0x4fe2('0x39')][_0x4fe2('0x55')](_0x1d96a6[_0x4fe2('0x56')],{})[_0x4fe2('0x1c')](respondWithResult(_0x2ec945,0xc9))['catch'](handleError(_0x2ec945,null));};exports[_0x4fe2('0x57')]=function(_0x54f947,_0x4fd7e1){if(_0x54f947[_0x4fe2('0x56')]['id']){delete _0x54f947['body']['id'];}return db[_0x4fe2('0x39')][_0x4fe2('0x54')]({'where':{'id':_0x54f947['params']['id']}})['then'](handleEntityNotFound(_0x4fd7e1,null))[_0x4fe2('0x1c')](saveUpdates(_0x54f947[_0x4fe2('0x56')],null))[_0x4fe2('0x1c')](respondWithResult(_0x4fd7e1,null))['catch'](handleError(_0x4fd7e1,null));};exports[_0x4fe2('0x34')]=function(_0x57c57b,_0x19a9c9){return db[_0x4fe2('0x39')][_0x4fe2('0x54')]({'where':{'id':_0x57c57b[_0x4fe2('0x51')]['id']}})[_0x4fe2('0x1c')](handleEntityNotFound(_0x19a9c9,null))[_0x4fe2('0x1c')](removeEntity(_0x19a9c9,null))[_0x4fe2('0x26')](handleError(_0x19a9c9,null));};exports[_0x4fe2('0x58')]=function(_0x4ab597,_0x31a740,_0x594c9f){var _0x5b7d1a={};var _0x4d1590={};var _0x5f4f67;var _0x6dfa28;return db[_0x4fe2('0x39')][_0x4fe2('0x59')]({'where':{'id':_0x4ab597[_0x4fe2('0x51')]['id']}})[_0x4fe2('0x1c')](handleEntityNotFound(_0x31a740,null))[_0x4fe2('0x1c')](function(_0x1024aa){if(_0x1024aa){_0x5f4f67=_0x1024aa;_0x4d1590[_0x4fe2('0x3e')]=_[_0x4fe2('0x40')](db[_0x4fe2('0x5a')][_0x4fe2('0x3a')]);_0x4d1590[_0x4fe2('0x3f')]=_[_0x4fe2('0x40')](_0x4ab597[_0x4fe2('0x3f')]);_0x4d1590[_0x4fe2('0x48')]=_[_0x4fe2('0x41')](_0x4d1590['model'],_0x4d1590[_0x4fe2('0x3f')]);_0x5b7d1a[_0x4fe2('0x42')]=_[_0x4fe2('0x41')](_0x4d1590['model'],qs['fields'](_0x4ab597['query'][_0x4fe2('0x43')]));_0x5b7d1a[_0x4fe2('0x42')]=_0x5b7d1a['attributes'][_0x4fe2('0x52')]?_0x5b7d1a['attributes']:_0x4d1590[_0x4fe2('0x3e')];_0x5b7d1a[_0x4fe2('0x46')]=qs[_0x4fe2('0x47')](_0x4ab597[_0x4fe2('0x3f')][_0x4fe2('0x47')]);_0x5b7d1a['where']=qs['filters'](_[_0x4fe2('0x49')](_0x4ab597['query'],_0x4d1590[_0x4fe2('0x48')]));if(_0x4ab597[_0x4fe2('0x3f')]['filter']){_0x5b7d1a[_0x4fe2('0x4a')]=_[_0x4fe2('0x4b')](_0x5b7d1a[_0x4fe2('0x4a')],{'$or':_[_0x4fe2('0x38')](_0x5b7d1a['attributes'],function(_0xa4f59e){var _0x5d5327={};_0x5d5327[_0xa4f59e]={'$like':'%'+_0x4ab597[_0x4fe2('0x3f')]['filter']+'%'};return _0x5d5327;})});}_0x5b7d1a=_[_0x4fe2('0x4b')]({},_0x5b7d1a,_0x4ab597['options']);return _0x5f4f67[_0x4fe2('0x58')](_0x5b7d1a);}})[_0x4fe2('0x1c')](function(_0x23cd42){if(_0x23cd42){_0x6dfa28=_0x23cd42['length'];if(!_0x4ab597[_0x4fe2('0x3f')][_0x4fe2('0x44')](_0x4fe2('0x45'))){_0x5b7d1a[_0x4fe2('0x2e')]=qs[_0x4fe2('0x2e')](_0x4ab597[_0x4fe2('0x3f')][_0x4fe2('0x2e')]);_0x5b7d1a[_0x4fe2('0x2c')]=qs[_0x4fe2('0x2c')](_0x4ab597['query']['offset']);}return _0x5f4f67['getFields'](_0x5b7d1a);}})[_0x4fe2('0x1c')](function(_0x23bb97){if(_0x23bb97){return _0x23bb97?{'count':_0x6dfa28,'rows':_0x23bb97}:null;}})[_0x4fe2('0x1c')](respondWithResult(_0x31a740,null))[_0x4fe2('0x26')](handleError(_0x31a740,null));};exports[_0x4fe2('0x5b')]=function(_0x58254f,_0x2ea3a7,_0x44be51){var _0x52bbda={};var _0x167b82={};var _0x71ea3c;var _0x432fa8;return db[_0x4fe2('0x39')][_0x4fe2('0x59')]({'where':{'id':_0x58254f[_0x4fe2('0x51')]['id']}})[_0x4fe2('0x1c')](handleEntityNotFound(_0x2ea3a7,null))[_0x4fe2('0x1c')](function(_0x2a8156){if(_0x2a8156){_0x71ea3c=_0x2a8156;_0x167b82[_0x4fe2('0x3e')]=_[_0x4fe2('0x40')](db[_0x4fe2('0x5a')]['rawAttributes']);_0x167b82[_0x4fe2('0x3f')]=_[_0x4fe2('0x40')](_0x58254f[_0x4fe2('0x3f')]);_0x167b82[_0x4fe2('0x48')]=_[_0x4fe2('0x41')](_0x167b82[_0x4fe2('0x3e')],_0x167b82[_0x4fe2('0x3f')]);_0x52bbda[_0x4fe2('0x42')]=_[_0x4fe2('0x41')](_0x167b82['model'],qs[_0x4fe2('0x43')](_0x58254f['query'][_0x4fe2('0x43')]));_0x52bbda[_0x4fe2('0x42')]=_0x52bbda[_0x4fe2('0x42')][_0x4fe2('0x52')]?_0x52bbda[_0x4fe2('0x42')]:_0x167b82[_0x4fe2('0x3e')];_0x52bbda[_0x4fe2('0x46')]=qs[_0x4fe2('0x47')](_0x58254f[_0x4fe2('0x3f')][_0x4fe2('0x47')]);_0x52bbda[_0x4fe2('0x4a')]=qs[_0x4fe2('0x48')](_[_0x4fe2('0x49')](_0x58254f['query'],_0x167b82['filters']));if(_0x58254f[_0x4fe2('0x3f')][_0x4fe2('0x5c')]){_0x52bbda['where']=_[_0x4fe2('0x4b')](_0x52bbda['where'],{'$or':_[_0x4fe2('0x38')](_0x52bbda['attributes'],function(_0xe43ab4){var _0x25b1bb={};_0x25b1bb[_0xe43ab4]={'$like':'%'+_0x58254f['query']['filter']+'%'};return _0x25b1bb;})});}_0x52bbda=_['merge']({},_0x52bbda,_0x58254f[_0x4fe2('0x53')]);return _0x71ea3c['getSubjects'](_0x52bbda);}})[_0x4fe2('0x1c')](function(_0xfca86d){if(_0xfca86d){_0x432fa8=_0xfca86d['length'];if(!_0x58254f[_0x4fe2('0x3f')]['hasOwnProperty'](_0x4fe2('0x45'))){_0x52bbda['limit']=qs['limit'](_0x58254f[_0x4fe2('0x3f')][_0x4fe2('0x2e')]);_0x52bbda[_0x4fe2('0x2c')]=qs['offset'](_0x58254f[_0x4fe2('0x3f')][_0x4fe2('0x2c')]);}return _0x71ea3c['getSubjects'](_0x52bbda);}})[_0x4fe2('0x1c')](function(_0x11c7ea){if(_0x11c7ea){return _0x11c7ea?{'count':_0x432fa8,'rows':_0x11c7ea}:null;}})[_0x4fe2('0x1c')](respondWithResult(_0x2ea3a7,null))[_0x4fe2('0x26')](handleError(_0x2ea3a7,null));};exports['getDescriptions']=function(_0x45533b,_0x46c094,_0x3366c1){var _0x46dc61={};var _0x3b6175={};var _0x4e9642;var _0x1536fa;return db[_0x4fe2('0x39')][_0x4fe2('0x59')]({'where':{'id':_0x45533b['params']['id']}})[_0x4fe2('0x1c')](handleEntityNotFound(_0x46c094,null))[_0x4fe2('0x1c')](function(_0x133970){if(_0x133970){_0x4e9642=_0x133970;_0x3b6175['model']=_['keys'](db['VtigerField']['rawAttributes']);_0x3b6175[_0x4fe2('0x3f')]=_[_0x4fe2('0x40')](_0x45533b[_0x4fe2('0x3f')]);_0x3b6175[_0x4fe2('0x48')]=_[_0x4fe2('0x41')](_0x3b6175['model'],_0x3b6175[_0x4fe2('0x3f')]);_0x46dc61[_0x4fe2('0x42')]=_['intersection'](_0x3b6175[_0x4fe2('0x3e')],qs[_0x4fe2('0x43')](_0x45533b[_0x4fe2('0x3f')][_0x4fe2('0x43')]));_0x46dc61['attributes']=_0x46dc61[_0x4fe2('0x42')][_0x4fe2('0x52')]?_0x46dc61['attributes']:_0x3b6175[_0x4fe2('0x3e')];_0x46dc61[_0x4fe2('0x46')]=qs[_0x4fe2('0x47')](_0x45533b[_0x4fe2('0x3f')][_0x4fe2('0x47')]);_0x46dc61['where']=qs['filters'](_[_0x4fe2('0x49')](_0x45533b[_0x4fe2('0x3f')],_0x3b6175[_0x4fe2('0x48')]));if(_0x45533b[_0x4fe2('0x3f')][_0x4fe2('0x5c')]){_0x46dc61[_0x4fe2('0x4a')]=_[_0x4fe2('0x4b')](_0x46dc61['where'],{'$or':_[_0x4fe2('0x38')](_0x46dc61[_0x4fe2('0x42')],function(_0x4ec20f){var _0x472442={};_0x472442[_0x4ec20f]={'$like':'%'+_0x45533b[_0x4fe2('0x3f')][_0x4fe2('0x5c')]+'%'};return _0x472442;})});}_0x46dc61=_[_0x4fe2('0x4b')]({},_0x46dc61,_0x45533b[_0x4fe2('0x53')]);return _0x4e9642[_0x4fe2('0x5d')](_0x46dc61);}})[_0x4fe2('0x1c')](function(_0x317db7){if(_0x317db7){_0x1536fa=_0x317db7[_0x4fe2('0x52')];if(!_0x45533b[_0x4fe2('0x3f')][_0x4fe2('0x44')]('nolimit')){_0x46dc61[_0x4fe2('0x2e')]=qs[_0x4fe2('0x2e')](_0x45533b[_0x4fe2('0x3f')][_0x4fe2('0x2e')]);_0x46dc61['offset']=qs[_0x4fe2('0x2c')](_0x45533b[_0x4fe2('0x3f')][_0x4fe2('0x2c')]);}return _0x4e9642[_0x4fe2('0x5d')](_0x46dc61);}})['then'](function(_0x568001){if(_0x568001){return _0x568001?{'count':_0x1536fa,'rows':_0x568001}:null;}})[_0x4fe2('0x1c')](respondWithResult(_0x46c094,null))['catch'](handleError(_0x46c094,null));};
\ No newline at end of file
+var _0xdba8=['desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','update','then','destroy','error','stack','name','send','index','map','VtigerConfiguration','rawAttributes','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','merge','VIRTUAL','filter','options','includeAll','include','findAll','rows','show','params','find','catch','create','body','getFields','findOne','VtigerField','order','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','moment','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto'];(function(_0x55f817,_0x1dce34){var _0x316b1b=function(_0x32a4ee){while(--_0x32a4ee){_0x55f817['push'](_0x55f817['shift']());}};_0x316b1b(++_0x1dce34);}(_0xdba8,0x179));var _0x8dba=function(_0x5aa159,_0x4c7c46){_0x5aa159=_0x5aa159-0x0;var _0x1e6131=_0xdba8[_0x5aa159];return _0x1e6131;};'use strict';var emlformat=require(_0x8dba('0x0'));var rimraf=require(_0x8dba('0x1'));var zipdir=require(_0x8dba('0x2'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x8dba('0x3'));var BPromise=require('bluebird');var Mustache=require(_0x8dba('0x4'));var util=require(_0x8dba('0x5'));var path=require('path');var sox=require(_0x8dba('0x6'));var csv=require(_0x8dba('0x7'));var ejs=require(_0x8dba('0x8'));var fs=require('fs');var fs_extra=require(_0x8dba('0x9'));var _=require(_0x8dba('0xa'));var squel=require(_0x8dba('0xb'));var crypto=require(_0x8dba('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x8dba('0xd'));var toCsv=require('to-csv');var querystring=require(_0x8dba('0xe'));var Papa=require(_0x8dba('0xf'));var Redis=require('ioredis');var authService=require(_0x8dba('0x10'));var qs=require(_0x8dba('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x8dba('0x12'));var logger=require('../../config/logger')(_0x8dba('0x13'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x8dba('0x14'));var db=require(_0x8dba('0x15'))['db'];function respondWithStatusCode(_0x49a991,_0x27606a){_0x27606a=_0x27606a||0xcc;return function(_0x49e947){if(_0x49e947){return _0x49a991[_0x8dba('0x16')](_0x27606a);}return _0x49a991[_0x8dba('0x17')](_0x27606a)[_0x8dba('0x18')]();};}function respondWithResult(_0x5d630d,_0x1dbfd3){_0x1dbfd3=_0x1dbfd3||0xc8;return function(_0x447beb){if(_0x447beb){return _0x5d630d['status'](_0x1dbfd3)[_0x8dba('0x19')](_0x447beb);}};}function respondWithFilteredResult(_0x4625f2,_0x121f07){return function(_0x4ad556){if(_0x4ad556){var _0x3ceaff=typeof _0x121f07[_0x8dba('0x1a')]===_0x8dba('0x1b')&&typeof _0x121f07[_0x8dba('0x1c')]===_0x8dba('0x1b');var _0xeecd9b=_0x4ad556[_0x8dba('0x1d')];var _0x58f09f=_0x3ceaff?0x0:_0x121f07[_0x8dba('0x1a')];var _0x31fb81=_0x3ceaff?_0x4ad556['count']:_0x121f07[_0x8dba('0x1a')]+_0x121f07[_0x8dba('0x1c')];var _0x2a38aa;if(_0x31fb81>=_0xeecd9b){_0x31fb81=_0xeecd9b;_0x2a38aa=0xc8;}else{_0x2a38aa=0xce;}_0x4625f2[_0x8dba('0x17')](_0x2a38aa);return _0x4625f2[_0x8dba('0x1e')](_0x8dba('0x1f'),_0x58f09f+'-'+_0x31fb81+'/'+_0xeecd9b)[_0x8dba('0x19')](_0x4ad556);}return null;};}function patchUpdates(_0x37f1f1){return function(_0x1c431f){try{jsonpatch['apply'](_0x1c431f,_0x37f1f1,!![]);}catch(_0xc098db){return BPromise['reject'](_0xc098db);}return _0x1c431f['save']();};}function saveUpdates(_0x4e864d,_0x5e27cc){return function(_0x13d737){if(_0x13d737){return _0x13d737[_0x8dba('0x20')](_0x4e864d)[_0x8dba('0x21')](function(_0xc33041){return _0xc33041;});}return null;};}function removeEntity(_0x139c1e,_0x1b6bd9){return function(_0x11a50e){if(_0x11a50e){return _0x11a50e[_0x8dba('0x22')]()['then'](function(){_0x139c1e[_0x8dba('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3bb3d2,_0x5ba65e){return function(_0x1156c6){if(!_0x1156c6){_0x3bb3d2[_0x8dba('0x16')](0x194);}return _0x1156c6;};}function handleError(_0x5630a1,_0x55438e){_0x55438e=_0x55438e||0x1f4;return function(_0x122410){logger[_0x8dba('0x23')](_0x122410[_0x8dba('0x24')]);if(_0x122410[_0x8dba('0x25')]){delete _0x122410[_0x8dba('0x25')];}_0x5630a1[_0x8dba('0x17')](_0x55438e)[_0x8dba('0x26')](_0x122410);};}exports[_0x8dba('0x27')]=function(_0x357290,_0x409210){var _0x4fb611={},_0x5e1a4f={},_0x561dfb={'count':0x0,'rows':[]};var _0x5ed773=_[_0x8dba('0x28')](db[_0x8dba('0x29')][_0x8dba('0x2a')],function(_0xecf97e){return{'name':_0xecf97e['fieldName'],'type':_0xecf97e[_0x8dba('0x2b')][_0x8dba('0x2c')]};});_0x5e1a4f[_0x8dba('0x2d')]=_[_0x8dba('0x28')](_0x5ed773,_0x8dba('0x25'));_0x5e1a4f[_0x8dba('0x2e')]=_[_0x8dba('0x2f')](_0x357290[_0x8dba('0x2e')]);_0x5e1a4f[_0x8dba('0x30')]=_[_0x8dba('0x31')](_0x5e1a4f[_0x8dba('0x2d')],_0x5e1a4f[_0x8dba('0x2e')]);_0x4fb611[_0x8dba('0x32')]=_[_0x8dba('0x31')](_0x5e1a4f[_0x8dba('0x2d')],qs[_0x8dba('0x33')](_0x357290[_0x8dba('0x2e')][_0x8dba('0x33')]));_0x4fb611[_0x8dba('0x32')]=_0x4fb611['attributes'][_0x8dba('0x34')]?_0x4fb611[_0x8dba('0x32')]:_0x5e1a4f[_0x8dba('0x2d')];if(!_0x357290['query'][_0x8dba('0x35')](_0x8dba('0x36'))){_0x4fb611['limit']=qs[_0x8dba('0x1c')](_0x357290[_0x8dba('0x2e')][_0x8dba('0x1c')]);_0x4fb611[_0x8dba('0x1a')]=qs[_0x8dba('0x1a')](_0x357290[_0x8dba('0x2e')][_0x8dba('0x1a')]);}_0x4fb611['order']=qs['sort'](_0x357290['query'][_0x8dba('0x37')]);_0x4fb611[_0x8dba('0x38')]=qs[_0x8dba('0x30')](_[_0x8dba('0x39')](_0x357290['query'],_0x5e1a4f[_0x8dba('0x30')]),_0x5ed773);if(_0x357290[_0x8dba('0x2e')]['filter']){_0x4fb611[_0x8dba('0x38')]=_[_0x8dba('0x3a')](_0x4fb611['where'],{'$or':_['map'](_0x5ed773,function(_0x328f25){if(_0x328f25[_0x8dba('0x2b')]!==_0x8dba('0x3b')){var _0x4827dc={};_0x4827dc[_0x328f25['name']]={'$like':'%'+_0x357290[_0x8dba('0x2e')][_0x8dba('0x3c')]+'%'};return _0x4827dc;}})});}_0x4fb611=_[_0x8dba('0x3a')]({},_0x4fb611,_0x357290[_0x8dba('0x3d')]);var _0x5427bb={'where':_0x4fb611['where']};return db['VtigerConfiguration']['count'](_0x5427bb)[_0x8dba('0x21')](function(_0x5548ea){_0x561dfb['count']=_0x5548ea;if(_0x357290[_0x8dba('0x2e')][_0x8dba('0x3e')]){_0x4fb611[_0x8dba('0x3f')]=[{'all':!![]}];}return db['VtigerConfiguration'][_0x8dba('0x40')](_0x4fb611);})['then'](function(_0x140f87){_0x561dfb[_0x8dba('0x41')]=_0x140f87;return _0x561dfb;})[_0x8dba('0x21')](respondWithFilteredResult(_0x409210,_0x4fb611))['catch'](handleError(_0x409210,null));};exports[_0x8dba('0x42')]=function(_0x5ef390,_0x23e72d){var _0x95eaa={'raw':![],'where':{'id':_0x5ef390[_0x8dba('0x43')]['id']}},_0x6d3d87={};_0x6d3d87[_0x8dba('0x2d')]=_['keys'](db[_0x8dba('0x29')][_0x8dba('0x2a')]);_0x6d3d87[_0x8dba('0x2e')]=_[_0x8dba('0x2f')](_0x5ef390[_0x8dba('0x2e')]);_0x6d3d87[_0x8dba('0x30')]=_['intersection'](_0x6d3d87[_0x8dba('0x2d')],_0x6d3d87[_0x8dba('0x2e')]);_0x95eaa[_0x8dba('0x32')]=_['intersection'](_0x6d3d87[_0x8dba('0x2d')],qs[_0x8dba('0x33')](_0x5ef390[_0x8dba('0x2e')][_0x8dba('0x33')]));_0x95eaa[_0x8dba('0x32')]=_0x95eaa[_0x8dba('0x32')][_0x8dba('0x34')]?_0x95eaa['attributes']:_0x6d3d87[_0x8dba('0x2d')];if(_0x5ef390['query'][_0x8dba('0x3e')]){_0x95eaa[_0x8dba('0x3f')]=[{'all':!![]}];}_0x95eaa=_['merge']({},_0x95eaa,_0x5ef390['options']);return db[_0x8dba('0x29')][_0x8dba('0x44')](_0x95eaa)['then'](handleEntityNotFound(_0x23e72d,null))['then'](respondWithResult(_0x23e72d,null))[_0x8dba('0x45')](handleError(_0x23e72d,null));};exports[_0x8dba('0x46')]=function(_0x55701d,_0x3605e3){return db[_0x8dba('0x29')][_0x8dba('0x46')](_0x55701d['body'],{})[_0x8dba('0x21')](respondWithResult(_0x3605e3,0xc9))[_0x8dba('0x45')](handleError(_0x3605e3,null));};exports['update']=function(_0x265d99,_0x3b44b9){if(_0x265d99[_0x8dba('0x47')]['id']){delete _0x265d99['body']['id'];}return db[_0x8dba('0x29')][_0x8dba('0x44')]({'where':{'id':_0x265d99['params']['id']}})['then'](handleEntityNotFound(_0x3b44b9,null))[_0x8dba('0x21')](saveUpdates(_0x265d99[_0x8dba('0x47')],null))[_0x8dba('0x21')](respondWithResult(_0x3b44b9,null))[_0x8dba('0x45')](handleError(_0x3b44b9,null));};exports[_0x8dba('0x22')]=function(_0x3dda23,_0x7324e4){return db['VtigerConfiguration'][_0x8dba('0x44')]({'where':{'id':_0x3dda23[_0x8dba('0x43')]['id']}})[_0x8dba('0x21')](handleEntityNotFound(_0x7324e4,null))['then'](removeEntity(_0x7324e4,null))['catch'](handleError(_0x7324e4,null));};exports[_0x8dba('0x48')]=function(_0x2c4915,_0x43c282,_0x2bb848){var _0x2cd506={};var _0x44dac8={};var _0x21c4b9;var _0x2900a6;return db[_0x8dba('0x29')][_0x8dba('0x49')]({'where':{'id':_0x2c4915[_0x8dba('0x43')]['id']}})[_0x8dba('0x21')](handleEntityNotFound(_0x43c282,null))[_0x8dba('0x21')](function(_0x411dd6){if(_0x411dd6){_0x21c4b9=_0x411dd6;_0x44dac8[_0x8dba('0x2d')]=_[_0x8dba('0x2f')](db[_0x8dba('0x4a')][_0x8dba('0x2a')]);_0x44dac8[_0x8dba('0x2e')]=_[_0x8dba('0x2f')](_0x2c4915[_0x8dba('0x2e')]);_0x44dac8['filters']=_[_0x8dba('0x31')](_0x44dac8[_0x8dba('0x2d')],_0x44dac8['query']);_0x2cd506[_0x8dba('0x32')]=_[_0x8dba('0x31')](_0x44dac8[_0x8dba('0x2d')],qs[_0x8dba('0x33')](_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x33')]));_0x2cd506[_0x8dba('0x32')]=_0x2cd506['attributes'][_0x8dba('0x34')]?_0x2cd506[_0x8dba('0x32')]:_0x44dac8['model'];_0x2cd506[_0x8dba('0x4b')]=qs['sort'](_0x2c4915[_0x8dba('0x2e')]['sort']);_0x2cd506['where']=qs[_0x8dba('0x30')](_[_0x8dba('0x39')](_0x2c4915['query'],_0x44dac8[_0x8dba('0x30')]));if(_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x3c')]){_0x2cd506[_0x8dba('0x38')]=_[_0x8dba('0x3a')](_0x2cd506['where'],{'$or':_[_0x8dba('0x28')](_0x2cd506['attributes'],function(_0x6c6c7e){var _0x24c5f1={};_0x24c5f1[_0x6c6c7e]={'$like':'%'+_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x3c')]+'%'};return _0x24c5f1;})});}_0x2cd506=_[_0x8dba('0x3a')]({},_0x2cd506,_0x2c4915[_0x8dba('0x3d')]);return _0x21c4b9[_0x8dba('0x48')](_0x2cd506);}})[_0x8dba('0x21')](function(_0x4fe516){if(_0x4fe516){_0x2900a6=_0x4fe516[_0x8dba('0x34')];if(!_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x35')](_0x8dba('0x36'))){_0x2cd506['limit']=qs[_0x8dba('0x1c')](_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x1c')]);_0x2cd506['offset']=qs[_0x8dba('0x1a')](_0x2c4915['query'][_0x8dba('0x1a')]);}return _0x21c4b9[_0x8dba('0x48')](_0x2cd506);}})['then'](function(_0x489218){if(_0x489218){return _0x489218?{'count':_0x2900a6,'rows':_0x489218}:null;}})[_0x8dba('0x21')](respondWithResult(_0x43c282,null))[_0x8dba('0x45')](handleError(_0x43c282,null));};exports['getSubjects']=function(_0x541b1e,_0x1edf1e,_0x38c7ea){var _0x5eb6df={};var _0x4bae23={};var _0x4afb20;var _0x52bc7f;return db[_0x8dba('0x29')][_0x8dba('0x49')]({'where':{'id':_0x541b1e[_0x8dba('0x43')]['id']}})['then'](handleEntityNotFound(_0x1edf1e,null))[_0x8dba('0x21')](function(_0x3c4767){if(_0x3c4767){_0x4afb20=_0x3c4767;_0x4bae23['model']=_[_0x8dba('0x2f')](db[_0x8dba('0x4a')]['rawAttributes']);_0x4bae23['query']=_[_0x8dba('0x2f')](_0x541b1e[_0x8dba('0x2e')]);_0x4bae23[_0x8dba('0x30')]=_[_0x8dba('0x31')](_0x4bae23[_0x8dba('0x2d')],_0x4bae23[_0x8dba('0x2e')]);_0x5eb6df[_0x8dba('0x32')]=_[_0x8dba('0x31')](_0x4bae23[_0x8dba('0x2d')],qs[_0x8dba('0x33')](_0x541b1e['query'][_0x8dba('0x33')]));_0x5eb6df['attributes']=_0x5eb6df[_0x8dba('0x32')][_0x8dba('0x34')]?_0x5eb6df[_0x8dba('0x32')]:_0x4bae23['model'];_0x5eb6df[_0x8dba('0x4b')]=qs[_0x8dba('0x37')](_0x541b1e[_0x8dba('0x2e')][_0x8dba('0x37')]);_0x5eb6df[_0x8dba('0x38')]=qs[_0x8dba('0x30')](_[_0x8dba('0x39')](_0x541b1e[_0x8dba('0x2e')],_0x4bae23[_0x8dba('0x30')]));if(_0x541b1e['query'][_0x8dba('0x3c')]){_0x5eb6df['where']=_['merge'](_0x5eb6df[_0x8dba('0x38')],{'$or':_[_0x8dba('0x28')](_0x5eb6df[_0x8dba('0x32')],function(_0x35086f){var _0x100dfd={};_0x100dfd[_0x35086f]={'$like':'%'+_0x541b1e[_0x8dba('0x2e')][_0x8dba('0x3c')]+'%'};return _0x100dfd;})});}_0x5eb6df=_[_0x8dba('0x3a')]({},_0x5eb6df,_0x541b1e[_0x8dba('0x3d')]);return _0x4afb20['getSubjects'](_0x5eb6df);}})[_0x8dba('0x21')](function(_0xa3b078){if(_0xa3b078){_0x52bc7f=_0xa3b078[_0x8dba('0x34')];if(!_0x541b1e[_0x8dba('0x2e')][_0x8dba('0x35')]('nolimit')){_0x5eb6df[_0x8dba('0x1c')]=qs[_0x8dba('0x1c')](_0x541b1e[_0x8dba('0x2e')]['limit']);_0x5eb6df[_0x8dba('0x1a')]=qs[_0x8dba('0x1a')](_0x541b1e[_0x8dba('0x2e')]['offset']);}return _0x4afb20[_0x8dba('0x4c')](_0x5eb6df);}})[_0x8dba('0x21')](function(_0x5dfa1c){if(_0x5dfa1c){return _0x5dfa1c?{'count':_0x52bc7f,'rows':_0x5dfa1c}:null;}})[_0x8dba('0x21')](respondWithResult(_0x1edf1e,null))[_0x8dba('0x45')](handleError(_0x1edf1e,null));};exports[_0x8dba('0x4d')]=function(_0x58d207,_0x25c236,_0x29b2c1){var _0xb8de00={};var _0x35fda9={};var _0x3569d3;var _0x5adb8a;return db[_0x8dba('0x29')]['findOne']({'where':{'id':_0x58d207[_0x8dba('0x43')]['id']}})[_0x8dba('0x21')](handleEntityNotFound(_0x25c236,null))[_0x8dba('0x21')](function(_0x40d507){if(_0x40d507){_0x3569d3=_0x40d507;_0x35fda9[_0x8dba('0x2d')]=_[_0x8dba('0x2f')](db[_0x8dba('0x4a')]['rawAttributes']);_0x35fda9[_0x8dba('0x2e')]=_['keys'](_0x58d207[_0x8dba('0x2e')]);_0x35fda9[_0x8dba('0x30')]=_[_0x8dba('0x31')](_0x35fda9[_0x8dba('0x2d')],_0x35fda9[_0x8dba('0x2e')]);_0xb8de00[_0x8dba('0x32')]=_['intersection'](_0x35fda9['model'],qs['fields'](_0x58d207[_0x8dba('0x2e')][_0x8dba('0x33')]));_0xb8de00['attributes']=_0xb8de00[_0x8dba('0x32')][_0x8dba('0x34')]?_0xb8de00[_0x8dba('0x32')]:_0x35fda9[_0x8dba('0x2d')];_0xb8de00['order']=qs[_0x8dba('0x37')](_0x58d207[_0x8dba('0x2e')]['sort']);_0xb8de00['where']=qs['filters'](_[_0x8dba('0x39')](_0x58d207['query'],_0x35fda9[_0x8dba('0x30')]));if(_0x58d207[_0x8dba('0x2e')][_0x8dba('0x3c')]){_0xb8de00[_0x8dba('0x38')]=_['merge'](_0xb8de00[_0x8dba('0x38')],{'$or':_[_0x8dba('0x28')](_0xb8de00[_0x8dba('0x32')],function(_0x6e1cff){var _0x2d4ff2={};_0x2d4ff2[_0x6e1cff]={'$like':'%'+_0x58d207['query'][_0x8dba('0x3c')]+'%'};return _0x2d4ff2;})});}_0xb8de00=_[_0x8dba('0x3a')]({},_0xb8de00,_0x58d207['options']);return _0x3569d3['getDescriptions'](_0xb8de00);}})[_0x8dba('0x21')](function(_0x4ebc18){if(_0x4ebc18){_0x5adb8a=_0x4ebc18[_0x8dba('0x34')];if(!_0x58d207[_0x8dba('0x2e')][_0x8dba('0x35')](_0x8dba('0x36'))){_0xb8de00['limit']=qs['limit'](_0x58d207['query'][_0x8dba('0x1c')]);_0xb8de00[_0x8dba('0x1a')]=qs[_0x8dba('0x1a')](_0x58d207[_0x8dba('0x2e')][_0x8dba('0x1a')]);}return _0x3569d3[_0x8dba('0x4d')](_0xb8de00);}})['then'](function(_0x240355){if(_0x240355){return _0x240355?{'count':_0x5adb8a,'rows':_0x240355}:null;}})[_0x8dba('0x21')](respondWithResult(_0x25c236,null))[_0x8dba('0x45')](handleError(_0x25c236,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff