18 var _0x6866=['attributes','length','nolimit','order','sort','where','pick','add','day','merge','map','filter','options','includeAll','include','findAll','rows','show','params','find','create','catch','update','body','getFields','getSubjects','findOne','SugarcrmField','hasOwnProperty','getDescriptions','fast-json-patch','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','jsforce','desk.js','querystring','../../components/parsers/qs','../../config/logger','api','../../config/environment','jayson/promise','http','request','then','info','SugarcrmConfiguration,\x20%s,\x20%s','request\x20sent','SugarcrmConfiguration,\x20%s,\x20%s,\x20%s','error','code','message','result','sendStatus','end','count','offset','limit','status','set','Content-Range','json','apply','destroy','stack','name','send','index','model','keys','SugarcrmConfiguration','rawAttributes','dateStart','query','dateEnd','filters','intersection','fields'];(function(_0x1bf002,_0x564016){var _0x101820=function(_0x5b6c02){while(--_0x5b6c02){_0x1bf002['push'](_0x1bf002['shift']());}};_0x101820(++_0x564016);}(_0x6866,0x1bd));var _0x6686=function(_0x5447fd,_0x52a6b5){_0x5447fd=_0x5447fd-0x0;var _0x15b28a=_0x6866[_0x5447fd];return _0x15b28a;};'use strict';var jsonpatch=require(_0x6686('0x0'));var rp=require('request-promise');var moment=require(_0x6686('0x1'));var BPromise=require(_0x6686('0x2'));var Mustache=require(_0x6686('0x3'));var util=require('util');var path=require(_0x6686('0x4'));var sox=require(_0x6686('0x5'));var csv=require(_0x6686('0x6'));var ejs=require(_0x6686('0x7'));var fs=require('fs');var _=require(_0x6686('0x8'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x6686('0x9'));var deskjs=require(_0x6686('0xa'));var toCsv=require(_0x6686('0x6'));var querystring=require(_0x6686('0xb'));var Papa=require('papaparse');var qs=require(_0x6686('0xc'));var logger=require(_0x6686('0xd'))(_0x6686('0xe'));var utils=require('../../config/utils');var config=require(_0x6686('0xf'));var db=require('../../mysqldb')['db'];var jayson=require(_0x6686('0x10'));var client=jayson['client'][_0x6686('0x11')]({'port':0x232a});function respondWithRpcPromise(_0x42735a,_0x18280a,_0x21b47f,_0x571954){return new BPromise(function(_0x479aed,_0x5a427b){var _0x472935=_0x571954||client;return _0x472935[_0x6686('0x12')](_0x42735a,_0x21b47f)[_0x6686('0x13')](function(_0x37bacc){logger[_0x6686('0x14')](_0x6686('0x15'),_0x18280a,_0x6686('0x16'));logger['debug'](_0x6686('0x17'),_0x18280a,_0x6686('0x16'),JSON['stringify'](_0x37bacc));if(_0x37bacc[_0x6686('0x18')]){if(_0x37bacc['error'][_0x6686('0x19')]===0x1f4){logger['error'](_0x6686('0x15'),_0x18280a,_0x37bacc[_0x6686('0x18')][_0x6686('0x1a')]);return _0x5a427b(_0x37bacc[_0x6686('0x18')][_0x6686('0x1a')]);}logger['error'](_0x6686('0x15'),_0x18280a,_0x37bacc[_0x6686('0x18')][_0x6686('0x1a')]);return _0x479aed(_0x37bacc[_0x6686('0x18')][_0x6686('0x1a')]);}else{logger[_0x6686('0x14')](_0x6686('0x15'),_0x18280a,_0x6686('0x16'));_0x479aed(_0x37bacc[_0x6686('0x1b')]['message']);}})['catch'](function(_0x43dabc){logger[_0x6686('0x18')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x18280a,_0x43dabc);_0x5a427b(_0x43dabc);});});}function respondWithStatusCode(_0x14c1c8,_0x43c39b){_0x43c39b=_0x43c39b||0xcc;return function(_0x2b23ad){if(_0x2b23ad){return _0x14c1c8[_0x6686('0x1c')](_0x43c39b);}return _0x14c1c8['status'](_0x43c39b)[_0x6686('0x1d')]();};}function respondWithResult(_0x406d58,_0x33ca37){_0x33ca37=_0x33ca37||0xc8;return function(_0x1ff7e0){if(_0x1ff7e0){return _0x406d58['status'](_0x33ca37)['json'](_0x1ff7e0);}};}function respondWithFilteredResult(_0x2ef707,_0x5b674b){return function(_0x56a896){if(_0x56a896){var _0x14c2d8=_0x56a896[_0x6686('0x1e')],_0x2ba214=_0x5b674b[_0x6686('0x1f')],_0x57bcad=_0x5b674b['offset']+_0x5b674b[_0x6686('0x20')],_0x5a0a9b;if(_0x57bcad>=_0x14c2d8){_0x57bcad=_0x14c2d8;_0x5a0a9b=0xc8;}else{_0x5a0a9b=0xce;}_0x2ef707[_0x6686('0x21')](_0x5a0a9b);return _0x2ef707[_0x6686('0x22')](_0x6686('0x23'),_0x2ba214+'-'+_0x57bcad+'/'+_0x14c2d8)[_0x6686('0x24')](_0x56a896);}return null;};}function patchUpdates(_0x3bb254){return function(_0x26d710){try{jsonpatch[_0x6686('0x25')](_0x26d710,_0x3bb254,!![]);}catch(_0x1a7e94){return BPromise['reject'](_0x1a7e94);}return _0x26d710['save']();};}function saveUpdates(_0x4844e6,_0x2dee04){return function(_0x522d63){if(_0x522d63){return _0x522d63['update'](_0x4844e6)[_0x6686('0x13')](function(_0x543925){return _0x543925;});}return null;};}function removeEntity(_0x54fa74,_0x4ffc8){return function(_0x2680d1){if(_0x2680d1){return _0x2680d1[_0x6686('0x26')]()[_0x6686('0x13')](function(){_0x54fa74[_0x6686('0x21')](0xcc)['end']();});}};}function handleEntityNotFound(_0xb768b,_0x566149){return function(_0x25c866){if(!_0x25c866){_0xb768b[_0x6686('0x1c')](0x194);}return _0x25c866;};}function handleError(_0x30cf75,_0x237e04){_0x237e04=_0x237e04||0x1f4;return function(_0x194977){logger[_0x6686('0x18')](_0x194977[_0x6686('0x27')]);if(_0x194977[_0x6686('0x28')]){delete _0x194977[_0x6686('0x28')];}_0x30cf75[_0x6686('0x21')](_0x237e04)[_0x6686('0x29')](_0x194977);};}exports[_0x6686('0x2a')]=function(_0x13579b,_0x5eabcd){var _0x23de17={},_0xd226a0={},_0x3010c7={'count':0x0,'rows':[]};_0xd226a0[_0x6686('0x2b')]=_[_0x6686('0x2c')](db[_0x6686('0x2d')][_0x6686('0x2e')]);var _0x2ac637={'dateStart':_0x13579b['query'][_0x6686('0x2f')],'dateEnd':_0x13579b[_0x6686('0x30')][_0x6686('0x31')]};delete _0x13579b['query'][_0x6686('0x2f')];delete _0x13579b[_0x6686('0x30')]['dateEnd'];_0xd226a0[_0x6686('0x30')]=_[_0x6686('0x2c')](_0x13579b[_0x6686('0x30')]);_0xd226a0[_0x6686('0x32')]=_[_0x6686('0x33')](_0xd226a0['model'],_0xd226a0[_0x6686('0x30')]);_0x23de17['attributes']=_[_0x6686('0x33')](_0xd226a0[_0x6686('0x2b')],qs[_0x6686('0x34')](_0x13579b[_0x6686('0x30')][_0x6686('0x34')]));_0x23de17[_0x6686('0x35')]=_0x23de17[_0x6686('0x35')][_0x6686('0x36')]?_0x23de17[_0x6686('0x35')]:_0xd226a0['model'];if(!_0x13579b[_0x6686('0x30')]['hasOwnProperty'](_0x6686('0x37'))){_0x23de17[_0x6686('0x20')]=qs[_0x6686('0x20')](_0x13579b[_0x6686('0x30')][_0x6686('0x20')]);_0x23de17[_0x6686('0x1f')]=qs[_0x6686('0x1f')](_0x13579b[_0x6686('0x30')][_0x6686('0x1f')]);}_0x23de17[_0x6686('0x38')]=qs[_0x6686('0x39')](_0x13579b['query'][_0x6686('0x39')]);_0x23de17[_0x6686('0x3a')]=qs['filters'](_[_0x6686('0x3b')](_0x13579b[_0x6686('0x30')],_0xd226a0['filters']));if(_0x2ac637['dateStart']){if(_0x2ac637[_0x6686('0x31')]){_0x2ac637['dateEnd']=moment(_0x2ac637['dateEnd'])['add'](0x1,'day');}else{_0x2ac637[_0x6686('0x31')]=moment(_0x2ac637['dateStart'])[_0x6686('0x3c')](0x1,_0x6686('0x3d'));}_[_0x6686('0x3e')](_0x23de17[_0x6686('0x3a')],{'createdAt':{'$gte':_0x2ac637[_0x6686('0x2f')],'$lte':_0x2ac637[_0x6686('0x31')]}});}if(_0x13579b[_0x6686('0x30')]['filter']){_0x23de17[_0x6686('0x3a')]=_[_0x6686('0x3e')](_0x23de17[_0x6686('0x3a')],{'$or':_[_0x6686('0x3f')](_0x23de17['attributes'],function(_0x556188){var _0x4c94d8={};_0x4c94d8[_0x556188]={'$like':'%'+_0x13579b[_0x6686('0x30')][_0x6686('0x40')]+'%'};return _0x4c94d8;})});}_0x23de17=_[_0x6686('0x3e')]({},_0x23de17,_0x13579b[_0x6686('0x41')]);var _0x4dc36f={'where':_0x23de17['where']};return db[_0x6686('0x2d')]['count'](_0x4dc36f)[_0x6686('0x13')](function(_0x41feba){_0x3010c7[_0x6686('0x1e')]=_0x41feba;if(_0x13579b[_0x6686('0x30')][_0x6686('0x42')]){_0x23de17[_0x6686('0x43')]=[{'all':!![]}];}return db[_0x6686('0x2d')][_0x6686('0x44')](_0x23de17);})[_0x6686('0x13')](function(_0x1fc729){_0x3010c7[_0x6686('0x45')]=_0x1fc729;return _0x3010c7;})[_0x6686('0x13')](respondWithFilteredResult(_0x5eabcd,_0x23de17))['catch'](handleError(_0x5eabcd,null));};exports[_0x6686('0x46')]=function(_0x2404e8,_0x555469){var _0x1a6f07={'raw':![],'where':{'id':_0x2404e8[_0x6686('0x47')]['id']}},_0x4cfc0b={};_0x4cfc0b[_0x6686('0x2b')]=_['keys'](db[_0x6686('0x2d')][_0x6686('0x2e')]);_0x4cfc0b['query']=_[_0x6686('0x2c')](_0x2404e8[_0x6686('0x30')]);_0x4cfc0b[_0x6686('0x32')]=_['intersection'](_0x4cfc0b[_0x6686('0x2b')],_0x4cfc0b[_0x6686('0x30')]);_0x1a6f07['attributes']=_[_0x6686('0x33')](_0x4cfc0b[_0x6686('0x2b')],qs[_0x6686('0x34')](_0x2404e8[_0x6686('0x30')]['fields']));_0x1a6f07['attributes']=_0x1a6f07[_0x6686('0x35')][_0x6686('0x36')]?_0x1a6f07[_0x6686('0x35')]:_0x4cfc0b['model'];if(_0x2404e8['query'][_0x6686('0x42')]){_0x1a6f07['include']=[{'all':!![]}];}_0x1a6f07=_[_0x6686('0x3e')]({},_0x1a6f07,_0x2404e8[_0x6686('0x41')]);return db[_0x6686('0x2d')][_0x6686('0x48')](_0x1a6f07)[_0x6686('0x13')](handleEntityNotFound(_0x555469,null))[_0x6686('0x13')](respondWithResult(_0x555469,null))['catch'](handleError(_0x555469,null));};exports[_0x6686('0x49')]=function(_0x4fd86b,_0x5f4cab){return db[_0x6686('0x2d')][_0x6686('0x49')](_0x4fd86b['body'],{})[_0x6686('0x13')](respondWithResult(_0x5f4cab,0xc9))[_0x6686('0x4a')](handleError(_0x5f4cab,null));};exports[_0x6686('0x4b')]=function(_0x5e35e5,_0x5541fc){if(_0x5e35e5['body']['id']){delete _0x5e35e5['body']['id'];}return db[_0x6686('0x2d')]['find']({'where':{'id':_0x5e35e5['params']['id']}})[_0x6686('0x13')](handleEntityNotFound(_0x5541fc,null))['then'](saveUpdates(_0x5e35e5[_0x6686('0x4c')],null))['then'](respondWithResult(_0x5541fc,null))[_0x6686('0x4a')](handleError(_0x5541fc,null));};exports[_0x6686('0x26')]=function(_0xeb9727,_0x13241d){return db[_0x6686('0x2d')][_0x6686('0x48')]({'where':{'id':_0xeb9727[_0x6686('0x47')]['id']}})[_0x6686('0x13')](handleEntityNotFound(_0x13241d,null))[_0x6686('0x13')](removeEntity(_0x13241d,null))[_0x6686('0x4a')](handleError(_0x13241d,null));};exports[_0x6686('0x4d')]=function(_0x5c3ad5,_0x53c726,_0x2533d9){var _0x3e2268={};var _0x604f14={};var _0xf1f721;var _0x54b157;return db[_0x6686('0x2d')]['findOne']({'where':{'id':_0x5c3ad5['params']['id']}})[_0x6686('0x13')](handleEntityNotFound(_0x53c726,null))[_0x6686('0x13')](function(_0x2a3f98){if(_0x2a3f98){_0xf1f721=_0x2a3f98;_0x604f14[_0x6686('0x2b')]=_['keys'](db['SugarcrmField'][_0x6686('0x2e')]);_0x604f14[_0x6686('0x30')]=_['keys'](_0x5c3ad5[_0x6686('0x30')]);_0x604f14[_0x6686('0x32')]=_[_0x6686('0x33')](_0x604f14['model'],_0x604f14[_0x6686('0x30')]);_0x3e2268[_0x6686('0x35')]=_[_0x6686('0x33')](_0x604f14['model'],qs[_0x6686('0x34')](_0x5c3ad5[_0x6686('0x30')]['fields']));_0x3e2268[_0x6686('0x35')]=_0x3e2268['attributes']['length']?_0x3e2268['attributes']:_0x604f14[_0x6686('0x2b')];_0x3e2268[_0x6686('0x38')]=qs['sort'](_0x5c3ad5[_0x6686('0x30')][_0x6686('0x39')]);_0x3e2268['where']=qs['filters'](_[_0x6686('0x3b')](_0x5c3ad5['query'],_0x604f14[_0x6686('0x32')]));if(_0x5c3ad5[_0x6686('0x30')]['filter']){_0x3e2268['where']=_[_0x6686('0x3e')](_0x3e2268[_0x6686('0x3a')],{'$or':_[_0x6686('0x3f')](_0x3e2268['attributes'],function(_0x5f7d47){var _0x314a6f={};_0x314a6f[_0x5f7d47]={'$like':'%'+_0x5c3ad5[_0x6686('0x30')][_0x6686('0x40')]+'%'};return _0x314a6f;})});}_0x3e2268=_[_0x6686('0x3e')]({},_0x3e2268,_0x5c3ad5['options']);return _0xf1f721['getFields'](_0x3e2268);}})[_0x6686('0x13')](function(_0x143704){if(_0x143704){_0x54b157=_0x143704[_0x6686('0x36')];if(!_0x5c3ad5[_0x6686('0x30')]['hasOwnProperty'](_0x6686('0x37'))){_0x3e2268['limit']=qs[_0x6686('0x20')](_0x5c3ad5[_0x6686('0x30')][_0x6686('0x20')]);_0x3e2268[_0x6686('0x1f')]=qs['offset'](_0x5c3ad5[_0x6686('0x30')][_0x6686('0x1f')]);}return _0xf1f721[_0x6686('0x4d')](_0x3e2268);}})[_0x6686('0x13')](function(_0x441ef2){if(_0x441ef2){return _0x441ef2?{'count':_0x54b157,'rows':_0x441ef2}:null;}})['then'](respondWithResult(_0x53c726,null))[_0x6686('0x4a')](handleError(_0x53c726,null));};exports[_0x6686('0x4e')]=function(_0x3b0050,_0x5b0c5c,_0x289468){var _0x361732={};var _0x54e74f={};var _0x5c2ad9;var _0x44c1ef;return db[_0x6686('0x2d')][_0x6686('0x4f')]({'where':{'id':_0x3b0050['params']['id']}})[_0x6686('0x13')](handleEntityNotFound(_0x5b0c5c,null))[_0x6686('0x13')](function(_0x385518){if(_0x385518){_0x5c2ad9=_0x385518;_0x54e74f[_0x6686('0x2b')]=_[_0x6686('0x2c')](db[_0x6686('0x50')][_0x6686('0x2e')]);_0x54e74f['query']=_[_0x6686('0x2c')](_0x3b0050[_0x6686('0x30')]);_0x54e74f[_0x6686('0x32')]=_[_0x6686('0x33')](_0x54e74f['model'],_0x54e74f['query']);_0x361732['attributes']=_[_0x6686('0x33')](_0x54e74f[_0x6686('0x2b')],qs[_0x6686('0x34')](_0x3b0050['query'][_0x6686('0x34')]));_0x361732[_0x6686('0x35')]=_0x361732[_0x6686('0x35')][_0x6686('0x36')]?_0x361732[_0x6686('0x35')]:_0x54e74f[_0x6686('0x2b')];_0x361732[_0x6686('0x38')]=qs[_0x6686('0x39')](_0x3b0050[_0x6686('0x30')][_0x6686('0x39')]);_0x361732[_0x6686('0x3a')]=qs['filters'](_[_0x6686('0x3b')](_0x3b0050['query'],_0x54e74f[_0x6686('0x32')]));if(_0x3b0050[_0x6686('0x30')][_0x6686('0x40')]){_0x361732[_0x6686('0x3a')]=_[_0x6686('0x3e')](_0x361732[_0x6686('0x3a')],{'$or':_['map'](_0x361732[_0x6686('0x35')],function(_0x5d59f7){var _0x3b1c70={};_0x3b1c70[_0x5d59f7]={'$like':'%'+_0x3b0050[_0x6686('0x30')][_0x6686('0x40')]+'%'};return _0x3b1c70;})});}_0x361732=_[_0x6686('0x3e')]({},_0x361732,_0x3b0050[_0x6686('0x41')]);return _0x5c2ad9[_0x6686('0x4e')](_0x361732);}})[_0x6686('0x13')](function(_0x14d226){if(_0x14d226){_0x44c1ef=_0x14d226[_0x6686('0x36')];if(!_0x3b0050[_0x6686('0x30')][_0x6686('0x51')](_0x6686('0x37'))){_0x361732[_0x6686('0x20')]=qs[_0x6686('0x20')](_0x3b0050['query']['limit']);_0x361732[_0x6686('0x1f')]=qs[_0x6686('0x1f')](_0x3b0050[_0x6686('0x30')]['offset']);}return _0x5c2ad9['getSubjects'](_0x361732);}})[_0x6686('0x13')](function(_0x242de0){if(_0x242de0){return _0x242de0?{'count':_0x44c1ef,'rows':_0x242de0}:null;}})[_0x6686('0x13')](respondWithResult(_0x5b0c5c,null))[_0x6686('0x4a')](handleError(_0x5b0c5c,null));};exports[_0x6686('0x52')]=function(_0x388c64,_0x1bc191,_0x1cd461){var _0x2a0bad={};var _0x5c1ccc={};var _0x2cad31;var _0x569dfb;return db['SugarcrmConfiguration'][_0x6686('0x4f')]({'where':{'id':_0x388c64[_0x6686('0x47')]['id']}})[_0x6686('0x13')](handleEntityNotFound(_0x1bc191,null))['then'](function(_0x5b7176){if(_0x5b7176){_0x2cad31=_0x5b7176;_0x5c1ccc['model']=_[_0x6686('0x2c')](db[_0x6686('0x50')][_0x6686('0x2e')]);_0x5c1ccc[_0x6686('0x30')]=_[_0x6686('0x2c')](_0x388c64['query']);_0x5c1ccc[_0x6686('0x32')]=_[_0x6686('0x33')](_0x5c1ccc[_0x6686('0x2b')],_0x5c1ccc[_0x6686('0x30')]);_0x2a0bad[_0x6686('0x35')]=_['intersection'](_0x5c1ccc[_0x6686('0x2b')],qs['fields'](_0x388c64[_0x6686('0x30')]['fields']));_0x2a0bad[_0x6686('0x35')]=_0x2a0bad['attributes'][_0x6686('0x36')]?_0x2a0bad[_0x6686('0x35')]:_0x5c1ccc[_0x6686('0x2b')];_0x2a0bad[_0x6686('0x38')]=qs[_0x6686('0x39')](_0x388c64[_0x6686('0x30')]['sort']);_0x2a0bad[_0x6686('0x3a')]=qs['filters'](_[_0x6686('0x3b')](_0x388c64[_0x6686('0x30')],_0x5c1ccc['filters']));if(_0x388c64['query'][_0x6686('0x40')]){_0x2a0bad[_0x6686('0x3a')]=_[_0x6686('0x3e')](_0x2a0bad[_0x6686('0x3a')],{'$or':_['map'](_0x2a0bad[_0x6686('0x35')],function(_0x42fbf4){var _0x20a29f={};_0x20a29f[_0x42fbf4]={'$like':'%'+_0x388c64[_0x6686('0x30')][_0x6686('0x40')]+'%'};return _0x20a29f;})});}_0x2a0bad=_['merge']({},_0x2a0bad,_0x388c64[_0x6686('0x41')]);return _0x2cad31[_0x6686('0x52')](_0x2a0bad);}})[_0x6686('0x13')](function(_0x1c6050){if(_0x1c6050){_0x569dfb=_0x1c6050['length'];if(!_0x388c64['query'][_0x6686('0x51')]('nolimit')){_0x2a0bad['limit']=qs['limit'](_0x388c64[_0x6686('0x30')][_0x6686('0x20')]);_0x2a0bad[_0x6686('0x1f')]=qs['offset'](_0x388c64['query'][_0x6686('0x1f')]);}return _0x2cad31[_0x6686('0x52')](_0x2a0bad);}})[_0x6686('0x13')](function(_0x101878){if(_0x101878){return _0x101878?{'count':_0x569dfb,'rows':_0x101878}:null;}})[_0x6686('0x13')](respondWithResult(_0x1bc191,null))['catch'](handleError(_0x1bc191,null));};
git://repos.xcallymotion.com / motion2.git / blob