[motion2.git] / server / api / intSugarcrmConfiguration / intSugarcrmConfiguration.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x6e9f=['offset','status','Content-Range','apply','reject','update','then','error','name','map','rawAttributes','fieldName','type','key','keys','query','filters','model','fields','attributes','length','sort','where','pick','filter','merge','options','includeAll','SugarcrmConfiguration','findAll','show','params','intersection','include','find','catch','create','body','SugarcrmField','order','hasOwnProperty','nolimit','getSubjects','findOne','getDescriptions','eml-format','fast-json-patch','request-promise','moment','mustache','path','sox','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','sendStatus','end','json','limit','undefined','count'];(function(_0x513c98,_0x36d3c1){var _0x59d12f=function(_0x27ca1e){while(--_0x27ca1e){_0x513c98['push'](_0x513c98['shift']());}};_0x59d12f(++_0x36d3c1);}(_0x6e9f,0x195));var _0xf6e9=function(_0x705dc,_0x333cb5){_0x705dc=_0x705dc-0x0;var _0x26c704=_0x6e9f[_0x705dc];return _0x26c704;};'use strict';var emlformat=require(_0xf6e9('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xf6e9('0x1'));var rp=require(_0xf6e9('0x2'));var moment=require(_0xf6e9('0x3'));var BPromise=require('bluebird');var Mustache=require(_0xf6e9('0x4'));var util=require('util');var path=require(_0xf6e9('0x5'));var sox=require(_0xf6e9('0x6'));var csv=require('to-csv');var ejs=require(_0xf6e9('0x7'));var fs=require('fs');var fs_extra=require(_0xf6e9('0x8'));var _=require(_0xf6e9('0x9'));var squel=require(_0xf6e9('0xa'));var crypto=require('crypto');var jsforce=require(_0xf6e9('0xb'));var deskjs=require(_0xf6e9('0xc'));var toCsv=require('to-csv');var querystring=require(_0xf6e9('0xd'));var Papa=require(_0xf6e9('0xe'));var Redis=require(_0xf6e9('0xf'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xf6e9('0x10'));var logger=require(_0xf6e9('0x11'))('api');var utils=require(_0xf6e9('0x12'));var config=require(_0xf6e9('0x13'));var licenseUtil=require(_0xf6e9('0x14'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x43ecd6,_0x30c8f2){_0x30c8f2=_0x30c8f2||0xcc;return function(_0x1db4f0){if(_0x1db4f0){return _0x43ecd6[_0xf6e9('0x15')](_0x30c8f2);}return _0x43ecd6['status'](_0x30c8f2)[_0xf6e9('0x16')]();};}function respondWithResult(_0x5b3f5f,_0x3265df){_0x3265df=_0x3265df||0xc8;return function(_0x32147b){if(_0x32147b){return _0x5b3f5f['status'](_0x3265df)[_0xf6e9('0x17')](_0x32147b);}};}function respondWithFilteredResult(_0x7095dc,_0xf5a243){return function(_0x3488a2){if(_0x3488a2){var _0x1d40d0=typeof _0xf5a243['offset']==='undefined'&&typeof _0xf5a243[_0xf6e9('0x18')]===_0xf6e9('0x19');var _0x2bc780=_0x3488a2[_0xf6e9('0x1a')];var _0x20db99=_0x1d40d0?0x0:_0xf5a243[_0xf6e9('0x1b')];var _0x19d4ac=_0x1d40d0?_0x3488a2[_0xf6e9('0x1a')]:_0xf5a243['offset']+_0xf5a243[_0xf6e9('0x18')];var _0x3eb59f;if(_0x19d4ac>=_0x2bc780){_0x19d4ac=_0x2bc780;_0x3eb59f=0xc8;}else{_0x3eb59f=0xce;}_0x7095dc[_0xf6e9('0x1c')](_0x3eb59f);return _0x7095dc['set'](_0xf6e9('0x1d'),_0x20db99+'-'+_0x19d4ac+'/'+_0x2bc780)[_0xf6e9('0x17')](_0x3488a2);}return null;};}function patchUpdates(_0x5aa697){return function(_0x4bc264){try{jsonpatch[_0xf6e9('0x1e')](_0x4bc264,_0x5aa697,!![]);}catch(_0x3429f1){return BPromise[_0xf6e9('0x1f')](_0x3429f1);}return _0x4bc264['save']();};}function saveUpdates(_0x535b29,_0x44a86b){return function(_0x228b99){if(_0x228b99){return _0x228b99[_0xf6e9('0x20')](_0x535b29)[_0xf6e9('0x21')](function(_0x1ad623){return _0x1ad623;});}return null;};}function removeEntity(_0x51becb,_0x24b3b6){return function(_0x3f608a){if(_0x3f608a){return _0x3f608a['destroy']()[_0xf6e9('0x21')](function(){_0x51becb['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0xba714e,_0x2d549d){return function(_0x59cc36){if(!_0x59cc36){_0xba714e[_0xf6e9('0x15')](0x194);}return _0x59cc36;};}function handleError(_0x5943ba,_0x187f8f){_0x187f8f=_0x187f8f||0x1f4;return function(_0x1eb97c){logger[_0xf6e9('0x22')](_0x1eb97c['stack']);if(_0x1eb97c['name']){delete _0x1eb97c[_0xf6e9('0x23')];}_0x5943ba[_0xf6e9('0x1c')](_0x187f8f)['send'](_0x1eb97c);};}exports['index']=function(_0x3201eb,_0x2d3509){var _0x166d27={},_0x58f3a8={},_0x79acc2={'count':0x0,'rows':[]};var _0x4e96=_[_0xf6e9('0x24')](db['SugarcrmConfiguration'][_0xf6e9('0x25')],function(_0x10b826){return{'name':_0x10b826[_0xf6e9('0x26')],'type':_0x10b826[_0xf6e9('0x27')][_0xf6e9('0x28')]};});_0x58f3a8['model']=_[_0xf6e9('0x24')](_0x4e96,_0xf6e9('0x23'));_0x58f3a8['query']=_[_0xf6e9('0x29')](_0x3201eb[_0xf6e9('0x2a')]);_0x58f3a8[_0xf6e9('0x2b')]=_['intersection'](_0x58f3a8[_0xf6e9('0x2c')],_0x58f3a8[_0xf6e9('0x2a')]);_0x166d27['attributes']=_['intersection'](_0x58f3a8[_0xf6e9('0x2c')],qs[_0xf6e9('0x2d')](_0x3201eb['query'][_0xf6e9('0x2d')]));_0x166d27[_0xf6e9('0x2e')]=_0x166d27[_0xf6e9('0x2e')][_0xf6e9('0x2f')]?_0x166d27['attributes']:_0x58f3a8[_0xf6e9('0x2c')];if(!_0x3201eb[_0xf6e9('0x2a')]['hasOwnProperty']('nolimit')){_0x166d27[_0xf6e9('0x18')]=qs['limit'](_0x3201eb[_0xf6e9('0x2a')]['limit']);_0x166d27[_0xf6e9('0x1b')]=qs[_0xf6e9('0x1b')](_0x3201eb[_0xf6e9('0x2a')]['offset']);}_0x166d27['order']=qs[_0xf6e9('0x30')](_0x3201eb[_0xf6e9('0x2a')][_0xf6e9('0x30')]);_0x166d27[_0xf6e9('0x31')]=qs[_0xf6e9('0x2b')](_[_0xf6e9('0x32')](_0x3201eb[_0xf6e9('0x2a')],_0x58f3a8[_0xf6e9('0x2b')]),_0x4e96);if(_0x3201eb[_0xf6e9('0x2a')][_0xf6e9('0x33')]){_0x166d27[_0xf6e9('0x31')]=_[_0xf6e9('0x34')](_0x166d27[_0xf6e9('0x31')],{'$or':_[_0xf6e9('0x24')](_0x4e96,function(_0x2bcec2){if(_0x2bcec2[_0xf6e9('0x27')]!=='VIRTUAL'){var _0x3ad289={};_0x3ad289[_0x2bcec2[_0xf6e9('0x23')]]={'$like':'%'+_0x3201eb[_0xf6e9('0x2a')][_0xf6e9('0x33')]+'%'};return _0x3ad289;}})});}_0x166d27=_[_0xf6e9('0x34')]({},_0x166d27,_0x3201eb[_0xf6e9('0x35')]);var _0x4882f2={'where':_0x166d27[_0xf6e9('0x31')]};return db['SugarcrmConfiguration'][_0xf6e9('0x1a')](_0x4882f2)['then'](function(_0x283bef){_0x79acc2[_0xf6e9('0x1a')]=_0x283bef;if(_0x3201eb[_0xf6e9('0x2a')][_0xf6e9('0x36')]){_0x166d27['include']=[{'all':!![]}];}return db[_0xf6e9('0x37')][_0xf6e9('0x38')](_0x166d27);})[_0xf6e9('0x21')](function(_0x30aadf){_0x79acc2['rows']=_0x30aadf;return _0x79acc2;})[_0xf6e9('0x21')](respondWithFilteredResult(_0x2d3509,_0x166d27))['catch'](handleError(_0x2d3509,null));};exports[_0xf6e9('0x39')]=function(_0x30f68d,_0x434faf){var _0x13a67a={'raw':![],'where':{'id':_0x30f68d[_0xf6e9('0x3a')]['id']}},_0x24527b={};_0x24527b[_0xf6e9('0x2c')]=_[_0xf6e9('0x29')](db[_0xf6e9('0x37')]['rawAttributes']);_0x24527b['query']=_[_0xf6e9('0x29')](_0x30f68d[_0xf6e9('0x2a')]);_0x24527b['filters']=_['intersection'](_0x24527b[_0xf6e9('0x2c')],_0x24527b[_0xf6e9('0x2a')]);_0x13a67a['attributes']=_[_0xf6e9('0x3b')](_0x24527b[_0xf6e9('0x2c')],qs[_0xf6e9('0x2d')](_0x30f68d[_0xf6e9('0x2a')][_0xf6e9('0x2d')]));_0x13a67a['attributes']=_0x13a67a[_0xf6e9('0x2e')][_0xf6e9('0x2f')]?_0x13a67a[_0xf6e9('0x2e')]:_0x24527b[_0xf6e9('0x2c')];if(_0x30f68d[_0xf6e9('0x2a')][_0xf6e9('0x36')]){_0x13a67a[_0xf6e9('0x3c')]=[{'all':!![]}];}_0x13a67a=_['merge']({},_0x13a67a,_0x30f68d[_0xf6e9('0x35')]);return db[_0xf6e9('0x37')][_0xf6e9('0x3d')](_0x13a67a)[_0xf6e9('0x21')](handleEntityNotFound(_0x434faf,null))[_0xf6e9('0x21')](respondWithResult(_0x434faf,null))[_0xf6e9('0x3e')](handleError(_0x434faf,null));};exports[_0xf6e9('0x3f')]=function(_0xaa3b44,_0x44eea4){return db['SugarcrmConfiguration']['create'](_0xaa3b44['body'],{})[_0xf6e9('0x21')](respondWithResult(_0x44eea4,0xc9))[_0xf6e9('0x3e')](handleError(_0x44eea4,null));};exports[_0xf6e9('0x20')]=function(_0x3d67aa,_0x1d5856){if(_0x3d67aa[_0xf6e9('0x40')]['id']){delete _0x3d67aa[_0xf6e9('0x40')]['id'];}return db[_0xf6e9('0x37')][_0xf6e9('0x3d')]({'where':{'id':_0x3d67aa[_0xf6e9('0x3a')]['id']}})[_0xf6e9('0x21')](handleEntityNotFound(_0x1d5856,null))['then'](saveUpdates(_0x3d67aa[_0xf6e9('0x40')],null))[_0xf6e9('0x21')](respondWithResult(_0x1d5856,null))[_0xf6e9('0x3e')](handleError(_0x1d5856,null));};exports['destroy']=function(_0x62ce89,_0x345f31){return db[_0xf6e9('0x37')][_0xf6e9('0x3d')]({'where':{'id':_0x62ce89['params']['id']}})[_0xf6e9('0x21')](handleEntityNotFound(_0x345f31,null))[_0xf6e9('0x21')](removeEntity(_0x345f31,null))['catch'](handleError(_0x345f31,null));};exports['getFields']=function(_0x7e2608,_0x593f25,_0xfaa01c){var _0x9ec935={};var _0x17f074={};var _0x41a3e2;var _0x126f77;return db['SugarcrmConfiguration']['findOne']({'where':{'id':_0x7e2608[_0xf6e9('0x3a')]['id']}})['then'](handleEntityNotFound(_0x593f25,null))[_0xf6e9('0x21')](function(_0x82fe64){if(_0x82fe64){_0x41a3e2=_0x82fe64;_0x17f074[_0xf6e9('0x2c')]=_['keys'](db[_0xf6e9('0x41')][_0xf6e9('0x25')]);_0x17f074['query']=_[_0xf6e9('0x29')](_0x7e2608[_0xf6e9('0x2a')]);_0x17f074[_0xf6e9('0x2b')]=_[_0xf6e9('0x3b')](_0x17f074['model'],_0x17f074['query']);_0x9ec935['attributes']=_[_0xf6e9('0x3b')](_0x17f074['model'],qs[_0xf6e9('0x2d')](_0x7e2608['query'][_0xf6e9('0x2d')]));_0x9ec935['attributes']=_0x9ec935[_0xf6e9('0x2e')][_0xf6e9('0x2f')]?_0x9ec935[_0xf6e9('0x2e')]:_0x17f074['model'];_0x9ec935[_0xf6e9('0x42')]=qs['sort'](_0x7e2608['query'][_0xf6e9('0x30')]);_0x9ec935[_0xf6e9('0x31')]=qs[_0xf6e9('0x2b')](_['pick'](_0x7e2608['query'],_0x17f074[_0xf6e9('0x2b')]));if(_0x7e2608[_0xf6e9('0x2a')][_0xf6e9('0x33')]){_0x9ec935[_0xf6e9('0x31')]=_[_0xf6e9('0x34')](_0x9ec935[_0xf6e9('0x31')],{'$or':_[_0xf6e9('0x24')](_0x9ec935[_0xf6e9('0x2e')],function(_0x5a71e9){var _0x5e76e1={};_0x5e76e1[_0x5a71e9]={'$like':'%'+_0x7e2608['query'][_0xf6e9('0x33')]+'%'};return _0x5e76e1;})});}_0x9ec935=_['merge']({},_0x9ec935,_0x7e2608[_0xf6e9('0x35')]);return _0x41a3e2['getFields'](_0x9ec935);}})[_0xf6e9('0x21')](function(_0x1f732d){if(_0x1f732d){_0x126f77=_0x1f732d[_0xf6e9('0x2f')];if(!_0x7e2608[_0xf6e9('0x2a')][_0xf6e9('0x43')](_0xf6e9('0x44'))){_0x9ec935[_0xf6e9('0x18')]=qs[_0xf6e9('0x18')](_0x7e2608[_0xf6e9('0x2a')][_0xf6e9('0x18')]);_0x9ec935[_0xf6e9('0x1b')]=qs['offset'](_0x7e2608['query'][_0xf6e9('0x1b')]);}return _0x41a3e2['getFields'](_0x9ec935);}})[_0xf6e9('0x21')](function(_0x4139ff){if(_0x4139ff){return _0x4139ff?{'count':_0x126f77,'rows':_0x4139ff}:null;}})['then'](respondWithResult(_0x593f25,null))[_0xf6e9('0x3e')](handleError(_0x593f25,null));};exports[_0xf6e9('0x45')]=function(_0x49f99a,_0x194a6c,_0x56fb8a){var _0x5dab5d={};var _0x91030f={};var _0x446a3a;var _0x4ccfcf;return db[_0xf6e9('0x37')][_0xf6e9('0x46')]({'where':{'id':_0x49f99a[_0xf6e9('0x3a')]['id']}})[_0xf6e9('0x21')](handleEntityNotFound(_0x194a6c,null))[_0xf6e9('0x21')](function(_0x21a6ae){if(_0x21a6ae){_0x446a3a=_0x21a6ae;_0x91030f[_0xf6e9('0x2c')]=_[_0xf6e9('0x29')](db[_0xf6e9('0x41')][_0xf6e9('0x25')]);_0x91030f[_0xf6e9('0x2a')]=_[_0xf6e9('0x29')](_0x49f99a[_0xf6e9('0x2a')]);_0x91030f[_0xf6e9('0x2b')]=_[_0xf6e9('0x3b')](_0x91030f[_0xf6e9('0x2c')],_0x91030f[_0xf6e9('0x2a')]);_0x5dab5d[_0xf6e9('0x2e')]=_[_0xf6e9('0x3b')](_0x91030f['model'],qs['fields'](_0x49f99a[_0xf6e9('0x2a')][_0xf6e9('0x2d')]));_0x5dab5d[_0xf6e9('0x2e')]=_0x5dab5d['attributes'][_0xf6e9('0x2f')]?_0x5dab5d['attributes']:_0x91030f[_0xf6e9('0x2c')];_0x5dab5d[_0xf6e9('0x42')]=qs[_0xf6e9('0x30')](_0x49f99a[_0xf6e9('0x2a')]['sort']);_0x5dab5d['where']=qs['filters'](_[_0xf6e9('0x32')](_0x49f99a['query'],_0x91030f['filters']));if(_0x49f99a[_0xf6e9('0x2a')]['filter']){_0x5dab5d[_0xf6e9('0x31')]=_[_0xf6e9('0x34')](_0x5dab5d['where'],{'$or':_[_0xf6e9('0x24')](_0x5dab5d[_0xf6e9('0x2e')],function(_0x268fd5){var _0x3e9df0={};_0x3e9df0[_0x268fd5]={'$like':'%'+_0x49f99a[_0xf6e9('0x2a')]['filter']+'%'};return _0x3e9df0;})});}_0x5dab5d=_[_0xf6e9('0x34')]({},_0x5dab5d,_0x49f99a[_0xf6e9('0x35')]);return _0x446a3a[_0xf6e9('0x45')](_0x5dab5d);}})[_0xf6e9('0x21')](function(_0x49b6a6){if(_0x49b6a6){_0x4ccfcf=_0x49b6a6[_0xf6e9('0x2f')];if(!_0x49f99a['query'][_0xf6e9('0x43')](_0xf6e9('0x44'))){_0x5dab5d[_0xf6e9('0x18')]=qs[_0xf6e9('0x18')](_0x49f99a[_0xf6e9('0x2a')]['limit']);_0x5dab5d[_0xf6e9('0x1b')]=qs[_0xf6e9('0x1b')](_0x49f99a[_0xf6e9('0x2a')][_0xf6e9('0x1b')]);}return _0x446a3a['getSubjects'](_0x5dab5d);}})[_0xf6e9('0x21')](function(_0x3b12d0){if(_0x3b12d0){return _0x3b12d0?{'count':_0x4ccfcf,'rows':_0x3b12d0}:null;}})['then'](respondWithResult(_0x194a6c,null))[_0xf6e9('0x3e')](handleError(_0x194a6c,null));};exports[_0xf6e9('0x47')]=function(_0x3276ee,_0x147fe7,_0x329f85){var _0x411bfe={};var _0x12d76a={};var _0x459d63;var _0x15356a;return db[_0xf6e9('0x37')]['findOne']({'where':{'id':_0x3276ee['params']['id']}})['then'](handleEntityNotFound(_0x147fe7,null))[_0xf6e9('0x21')](function(_0x65ea16){if(_0x65ea16){_0x459d63=_0x65ea16;_0x12d76a[_0xf6e9('0x2c')]=_[_0xf6e9('0x29')](db['SugarcrmField'][_0xf6e9('0x25')]);_0x12d76a[_0xf6e9('0x2a')]=_[_0xf6e9('0x29')](_0x3276ee[_0xf6e9('0x2a')]);_0x12d76a['filters']=_['intersection'](_0x12d76a[_0xf6e9('0x2c')],_0x12d76a[_0xf6e9('0x2a')]);_0x411bfe[_0xf6e9('0x2e')]=_['intersection'](_0x12d76a[_0xf6e9('0x2c')],qs[_0xf6e9('0x2d')](_0x3276ee[_0xf6e9('0x2a')]['fields']));_0x411bfe[_0xf6e9('0x2e')]=_0x411bfe[_0xf6e9('0x2e')][_0xf6e9('0x2f')]?_0x411bfe[_0xf6e9('0x2e')]:_0x12d76a[_0xf6e9('0x2c')];_0x411bfe[_0xf6e9('0x42')]=qs[_0xf6e9('0x30')](_0x3276ee[_0xf6e9('0x2a')][_0xf6e9('0x30')]);_0x411bfe[_0xf6e9('0x31')]=qs['filters'](_[_0xf6e9('0x32')](_0x3276ee[_0xf6e9('0x2a')],_0x12d76a[_0xf6e9('0x2b')]));if(_0x3276ee[_0xf6e9('0x2a')][_0xf6e9('0x33')]){_0x411bfe[_0xf6e9('0x31')]=_['merge'](_0x411bfe[_0xf6e9('0x31')],{'$or':_[_0xf6e9('0x24')](_0x411bfe[_0xf6e9('0x2e')],function(_0x10f57f){var _0x47c32e={};_0x47c32e[_0x10f57f]={'$like':'%'+_0x3276ee['query']['filter']+'%'};return _0x47c32e;})});}_0x411bfe=_[_0xf6e9('0x34')]({},_0x411bfe,_0x3276ee[_0xf6e9('0x35')]);return _0x459d63[_0xf6e9('0x47')](_0x411bfe);}})[_0xf6e9('0x21')](function(_0x4a57c1){if(_0x4a57c1){_0x15356a=_0x4a57c1[_0xf6e9('0x2f')];if(!_0x3276ee[_0xf6e9('0x2a')][_0xf6e9('0x43')](_0xf6e9('0x44'))){_0x411bfe['limit']=qs[_0xf6e9('0x18')](_0x3276ee[_0xf6e9('0x2a')][_0xf6e9('0x18')]);_0x411bfe['offset']=qs[_0xf6e9('0x1b')](_0x3276ee['query'][_0xf6e9('0x1b')]);}return _0x459d63[_0xf6e9('0x47')](_0x411bfe);}})[_0xf6e9('0x21')](function(_0x11c882){if(_0x11c882){return _0x11c882?{'count':_0x15356a,'rows':_0x11c882}:null;}})['then'](respondWithResult(_0x147fe7,null))[_0xf6e9('0x3e')](handleError(_0x147fe7,null));};