server/api/intSugarcrmField/intSugarcrmField.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0x98db=['querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','then','destroy','stack','name','send','index','map','SugarcrmField','fieldName','type','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','pick','filter','where','merge','VIRTUAL','options','includeAll','include','findAll','catch','show','rawAttributes','find','create','body','update','params','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','path','sox','to-csv','ejs','lodash','squel','jsforce'];(function(_0x3047dc,_0x4f88b9){var _0x14cb38=function(_0x483777){while(--_0x483777){_0x3047dc['push'](_0x3047dc['shift']());}};_0x14cb38(++_0x4f88b9);}(_0x98db,0x16a));var _0xb98d=function(_0x4b7b62,_0x4920a9){_0x4b7b62=_0x4b7b62-0x0;var _0x2280df=_0x98db[_0x4b7b62];return _0x2280df;};'use strict';var emlformat=require(_0xb98d('0x0'));var rimraf=require(_0xb98d('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xb98d('0x2'));var rp=require(_0xb98d('0x3'));var moment=require(_0xb98d('0x4'));var BPromise=require(_0xb98d('0x5'));var Mustache=require('mustache');var util=require('util');var path=require(_0xb98d('0x6'));var sox=require(_0xb98d('0x7'));var csv=require(_0xb98d('0x8'));var ejs=require(_0xb98d('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xb98d('0xa'));var squel=require(_0xb98d('0xb'));var crypto=require('crypto');var jsforce=require(_0xb98d('0xc'));var deskjs=require('desk.js');var toCsv=require(_0xb98d('0x8'));var querystring=require(_0xb98d('0xd'));var Papa=require(_0xb98d('0xe'));var Redis=require(_0xb98d('0xf'));var authService=require(_0xb98d('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0xb98d('0x11'));var hardwareService=require(_0xb98d('0x12'));var logger=require(_0xb98d('0x13'))(_0xb98d('0x14'));var utils=require(_0xb98d('0x15'));var config=require(_0xb98d('0x16'));var licenseUtil=require(_0xb98d('0x17'));var db=require(_0xb98d('0x18'))['db'];function respondWithStatusCode(_0x15ae28,_0x5e8d11){_0x5e8d11=_0x5e8d11||0xcc;return function(_0x16389c){if(_0x16389c){return _0x15ae28[_0xb98d('0x19')](_0x5e8d11);}return _0x15ae28[_0xb98d('0x1a')](_0x5e8d11)[_0xb98d('0x1b')]();};}function respondWithResult(_0x39423c,_0x341e39){_0x341e39=_0x341e39||0xc8;return function(_0x849430){if(_0x849430){return _0x39423c[_0xb98d('0x1a')](_0x341e39)[_0xb98d('0x1c')](_0x849430);}};}function respondWithFilteredResult(_0x5a15d5,_0x25722c){return function(_0x32942c){if(_0x32942c){var _0x293ade=typeof _0x25722c[_0xb98d('0x1d')]===_0xb98d('0x1e')&&typeof _0x25722c[_0xb98d('0x1f')]===_0xb98d('0x1e');var _0x215482=_0x32942c[_0xb98d('0x20')];var _0x4bd45f=_0x293ade?0x0:_0x25722c['offset'];var _0x4c52f2=_0x293ade?_0x32942c[_0xb98d('0x20')]:_0x25722c[_0xb98d('0x1d')]+_0x25722c[_0xb98d('0x1f')];var _0x130512;if(_0x4c52f2>=_0x215482){_0x4c52f2=_0x215482;_0x130512=0xc8;}else{_0x130512=0xce;}_0x5a15d5['status'](_0x130512);return _0x5a15d5[_0xb98d('0x21')](_0xb98d('0x22'),_0x4bd45f+'-'+_0x4c52f2+'/'+_0x215482)[_0xb98d('0x1c')](_0x32942c);}return null;};}function patchUpdates(_0x594677){return function(_0x2ef592){try{jsonpatch[_0xb98d('0x23')](_0x2ef592,_0x594677,!![]);}catch(_0xa59e2f){return BPromise[_0xb98d('0x24')](_0xa59e2f);}return _0x2ef592[_0xb98d('0x25')]();};}function saveUpdates(_0x3932f1,_0x11ddb8){return function(_0x4a42a7){if(_0x4a42a7){return _0x4a42a7['update'](_0x3932f1)[_0xb98d('0x26')](function(_0x1099b5){return _0x1099b5;});}return null;};}function removeEntity(_0x1f7eee,_0x4b0b0d){return function(_0x4382b2){if(_0x4382b2){return _0x4382b2[_0xb98d('0x27')]()['then'](function(){_0x1f7eee[_0xb98d('0x1a')](0xcc)[_0xb98d('0x1b')]();});}};}function handleEntityNotFound(_0x2d9419,_0x13a775){return function(_0x2db554){if(!_0x2db554){_0x2d9419['sendStatus'](0x194);}return _0x2db554;};}function handleError(_0x96678e,_0x391767){_0x391767=_0x391767||0x1f4;return function(_0x1c5013){logger['error'](_0x1c5013[_0xb98d('0x28')]);if(_0x1c5013['name']){delete _0x1c5013[_0xb98d('0x29')];}_0x96678e[_0xb98d('0x1a')](_0x391767)[_0xb98d('0x2a')](_0x1c5013);};}exports[_0xb98d('0x2b')]=function(_0x11b667,_0x389a4b){var _0x4ef002={},_0xf0216c={},_0x55714e={'count':0x0,'rows':[]};var _0x17d4ca=_[_0xb98d('0x2c')](db[_0xb98d('0x2d')]['rawAttributes'],function(_0x41d385){return{'name':_0x41d385[_0xb98d('0x2e')],'type':_0x41d385[_0xb98d('0x2f')]['key']};});_0xf0216c[_0xb98d('0x30')]=_[_0xb98d('0x2c')](_0x17d4ca,_0xb98d('0x29'));_0xf0216c[_0xb98d('0x31')]=_[_0xb98d('0x32')](_0x11b667[_0xb98d('0x31')]);_0xf0216c[_0xb98d('0x33')]=_['intersection'](_0xf0216c[_0xb98d('0x30')],_0xf0216c[_0xb98d('0x31')]);_0x4ef002[_0xb98d('0x34')]=_[_0xb98d('0x35')](_0xf0216c[_0xb98d('0x30')],qs[_0xb98d('0x36')](_0x11b667[_0xb98d('0x31')][_0xb98d('0x36')]));_0x4ef002['attributes']=_0x4ef002['attributes'][_0xb98d('0x37')]?_0x4ef002[_0xb98d('0x34')]:_0xf0216c[_0xb98d('0x30')];if(!_0x11b667[_0xb98d('0x31')][_0xb98d('0x38')](_0xb98d('0x39'))){_0x4ef002['limit']=qs[_0xb98d('0x1f')](_0x11b667[_0xb98d('0x31')][_0xb98d('0x1f')]);_0x4ef002['offset']=qs['offset'](_0x11b667[_0xb98d('0x31')][_0xb98d('0x1d')]);}_0x4ef002['order']=qs['sort'](_0x11b667[_0xb98d('0x31')]['sort']);_0x4ef002['where']=qs[_0xb98d('0x33')](_[_0xb98d('0x3a')](_0x11b667[_0xb98d('0x31')],_0xf0216c['filters']),_0x17d4ca);if(_0x11b667[_0xb98d('0x31')][_0xb98d('0x3b')]){_0x4ef002[_0xb98d('0x3c')]=_[_0xb98d('0x3d')](_0x4ef002[_0xb98d('0x3c')],{'$or':_[_0xb98d('0x2c')](_0x17d4ca,function(_0x53a934){if(_0x53a934[_0xb98d('0x2f')]!==_0xb98d('0x3e')){var _0x2ff6ba={};_0x2ff6ba[_0x53a934['name']]={'$like':'%'+_0x11b667[_0xb98d('0x31')][_0xb98d('0x3b')]+'%'};return _0x2ff6ba;}})});}_0x4ef002=_[_0xb98d('0x3d')]({},_0x4ef002,_0x11b667[_0xb98d('0x3f')]);var _0x2defa8={'where':_0x4ef002[_0xb98d('0x3c')]};return db[_0xb98d('0x2d')][_0xb98d('0x20')](_0x2defa8)['then'](function(_0x4bbde1){_0x55714e[_0xb98d('0x20')]=_0x4bbde1;if(_0x11b667[_0xb98d('0x31')][_0xb98d('0x40')]){_0x4ef002[_0xb98d('0x41')]=[{'all':!![]}];}return db[_0xb98d('0x2d')][_0xb98d('0x42')](_0x4ef002);})['then'](function(_0x39437c){_0x55714e['rows']=_0x39437c;return _0x55714e;})['then'](respondWithFilteredResult(_0x389a4b,_0x4ef002))[_0xb98d('0x43')](handleError(_0x389a4b,null));};exports[_0xb98d('0x44')]=function(_0x5106ce,_0x3bbb13){var _0x3d7d5b={'raw':!![],'where':{'id':_0x5106ce['params']['id']}},_0x3e3c05={};_0x3e3c05[_0xb98d('0x30')]=_[_0xb98d('0x32')](db[_0xb98d('0x2d')][_0xb98d('0x45')]);_0x3e3c05[_0xb98d('0x31')]=_[_0xb98d('0x32')](_0x5106ce['query']);_0x3e3c05['filters']=_[_0xb98d('0x35')](_0x3e3c05[_0xb98d('0x30')],_0x3e3c05['query']);_0x3d7d5b[_0xb98d('0x34')]=_[_0xb98d('0x35')](_0x3e3c05[_0xb98d('0x30')],qs[_0xb98d('0x36')](_0x5106ce[_0xb98d('0x31')][_0xb98d('0x36')]));_0x3d7d5b[_0xb98d('0x34')]=_0x3d7d5b[_0xb98d('0x34')][_0xb98d('0x37')]?_0x3d7d5b[_0xb98d('0x34')]:_0x3e3c05[_0xb98d('0x30')];if(_0x5106ce[_0xb98d('0x31')][_0xb98d('0x40')]){_0x3d7d5b['include']=[{'all':!![]}];}_0x3d7d5b=_['merge']({},_0x3d7d5b,_0x5106ce[_0xb98d('0x3f')]);return db[_0xb98d('0x2d')][_0xb98d('0x46')](_0x3d7d5b)['then'](handleEntityNotFound(_0x3bbb13,null))[_0xb98d('0x26')](respondWithResult(_0x3bbb13,null))[_0xb98d('0x43')](handleError(_0x3bbb13,null));};exports['create']=function(_0xccea96,_0x2905b8){return db[_0xb98d('0x2d')][_0xb98d('0x47')](_0xccea96[_0xb98d('0x48')],{})[_0xb98d('0x26')](respondWithResult(_0x2905b8,0xc9))['catch'](handleError(_0x2905b8,null));};exports[_0xb98d('0x49')]=function(_0x32569d,_0x127f34){if(_0x32569d[_0xb98d('0x48')]['id']){delete _0x32569d[_0xb98d('0x48')]['id'];}return db[_0xb98d('0x2d')]['find']({'where':{'id':_0x32569d['params']['id']}})[_0xb98d('0x26')](handleEntityNotFound(_0x127f34,null))[_0xb98d('0x26')](saveUpdates(_0x32569d[_0xb98d('0x48')],null))[_0xb98d('0x26')](respondWithResult(_0x127f34,null))[_0xb98d('0x43')](handleError(_0x127f34,null));};exports[_0xb98d('0x27')]=function(_0xb59453,_0x29eef6){return db['SugarcrmField'][_0xb98d('0x46')]({'where':{'id':_0xb59453[_0xb98d('0x4a')]['id']}})[_0xb98d('0x26')](handleEntityNotFound(_0x29eef6,null))[_0xb98d('0x26')](removeEntity(_0x29eef6,null))[_0xb98d('0x43')](handleError(_0x29eef6,null));};