[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 _0x4df2=['send','index','map','SugarcrmConfiguration','rawAttributes','type','key','model','keys','query','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','includeAll','include','findAll','rows','catch','show','options','find','create','body','params','getFields','findOne','SugarcrmField','fields','getSubjects','getDescriptions','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','Content-Range','reject','then','destroy','error','stack','name'];(function(_0x3af893,_0x344d9e){var _0x300935=function(_0x108a78){while(--_0x108a78){_0x3af893['push'](_0x3af893['shift']());}};_0x300935(++_0x344d9e);}(_0x4df2,0x118));var _0x24df=function(_0x5529ff,_0x3c4f41){_0x5529ff=_0x5529ff-0x0;var _0x4f5dee=_0x4df2[_0x5529ff];return _0x4f5dee;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x24df('0x0'));var zipdir=require(_0x24df('0x1'));var jsonpatch=require(_0x24df('0x2'));var rp=require('request-promise');var moment=require(_0x24df('0x3'));var BPromise=require(_0x24df('0x4'));var Mustache=require(_0x24df('0x5'));var util=require('util');var path=require(_0x24df('0x6'));var sox=require(_0x24df('0x7'));var csv=require(_0x24df('0x8'));var ejs=require(_0x24df('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x24df('0xa'));var squel=require(_0x24df('0xb'));var crypto=require(_0x24df('0xc'));var jsforce=require(_0x24df('0xd'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x24df('0xe'));var Papa=require(_0x24df('0xf'));var Redis=require('ioredis');var authService=require(_0x24df('0x10'));var qs=require(_0x24df('0x11'));var as=require(_0x24df('0x12'));var hardwareService=require(_0x24df('0x13'));var logger=require(_0x24df('0x14'))(_0x24df('0x15'));var utils=require(_0x24df('0x16'));var config=require(_0x24df('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x24df('0x18'))['db'];function respondWithStatusCode(_0x19d564,_0x2dfbbc){_0x2dfbbc=_0x2dfbbc||0xcc;return function(_0x16da0f){if(_0x16da0f){return _0x19d564[_0x24df('0x19')](_0x2dfbbc);}return _0x19d564['status'](_0x2dfbbc)[_0x24df('0x1a')]();};}function respondWithResult(_0x53eea0,_0x195646){_0x195646=_0x195646||0xc8;return function(_0x56c4d8){if(_0x56c4d8){return _0x53eea0[_0x24df('0x1b')](_0x195646)[_0x24df('0x1c')](_0x56c4d8);}};}function respondWithFilteredResult(_0x56102e,_0x118c25){return function(_0x4bdf42){if(_0x4bdf42){var _0x36cfd2=typeof _0x118c25[_0x24df('0x1d')]===_0x24df('0x1e')&&typeof _0x118c25[_0x24df('0x1f')]==='undefined';var _0x5af0e8=_0x4bdf42[_0x24df('0x20')];var _0x2584ea=_0x36cfd2?0x0:_0x118c25['offset'];var _0x3c6f9a=_0x36cfd2?_0x4bdf42['count']:_0x118c25[_0x24df('0x1d')]+_0x118c25[_0x24df('0x1f')];var _0x1c57e8;if(_0x3c6f9a>=_0x5af0e8){_0x3c6f9a=_0x5af0e8;_0x1c57e8=0xc8;}else{_0x1c57e8=0xce;}_0x56102e[_0x24df('0x1b')](_0x1c57e8);return _0x56102e['set'](_0x24df('0x21'),_0x2584ea+'-'+_0x3c6f9a+'/'+_0x5af0e8)[_0x24df('0x1c')](_0x4bdf42);}return null;};}function patchUpdates(_0x3a7db0){return function(_0x483cab){try{jsonpatch['apply'](_0x483cab,_0x3a7db0,!![]);}catch(_0x112e54){return BPromise[_0x24df('0x22')](_0x112e54);}return _0x483cab['save']();};}function saveUpdates(_0x512b40,_0x2cba39){return function(_0x212bbe){if(_0x212bbe){return _0x212bbe['update'](_0x512b40)[_0x24df('0x23')](function(_0x40e3e6){return _0x40e3e6;});}return null;};}function removeEntity(_0x532fef,_0x16b416){return function(_0x8b6fc5){if(_0x8b6fc5){return _0x8b6fc5[_0x24df('0x24')]()['then'](function(){_0x532fef[_0x24df('0x1b')](0xcc)[_0x24df('0x1a')]();});}};}function handleEntityNotFound(_0x417bfb,_0x287ee3){return function(_0x30f0de){if(!_0x30f0de){_0x417bfb[_0x24df('0x19')](0x194);}return _0x30f0de;};}function handleError(_0x16ad6e,_0x3da7d7){_0x3da7d7=_0x3da7d7||0x1f4;return function(_0x2f59f7){logger[_0x24df('0x25')](_0x2f59f7[_0x24df('0x26')]);if(_0x2f59f7['name']){delete _0x2f59f7[_0x24df('0x27')];}_0x16ad6e[_0x24df('0x1b')](_0x3da7d7)[_0x24df('0x28')](_0x2f59f7);};}exports[_0x24df('0x29')]=function(_0x3a908b,_0x488875){var _0x4c8d62={},_0x3834da={},_0x425162={'count':0x0,'rows':[]};var _0x30a9c0=_[_0x24df('0x2a')](db[_0x24df('0x2b')][_0x24df('0x2c')],function(_0x3a6608){return{'name':_0x3a6608['fieldName'],'type':_0x3a6608[_0x24df('0x2d')][_0x24df('0x2e')]};});_0x3834da[_0x24df('0x2f')]=_[_0x24df('0x2a')](_0x30a9c0,'name');_0x3834da['query']=_[_0x24df('0x30')](_0x3a908b[_0x24df('0x31')]);_0x3834da['filters']=_[_0x24df('0x32')](_0x3834da[_0x24df('0x2f')],_0x3834da[_0x24df('0x31')]);_0x4c8d62[_0x24df('0x33')]=_[_0x24df('0x32')](_0x3834da['model'],qs['fields'](_0x3a908b[_0x24df('0x31')]['fields']));_0x4c8d62['attributes']=_0x4c8d62[_0x24df('0x33')][_0x24df('0x34')]?_0x4c8d62[_0x24df('0x33')]:_0x3834da[_0x24df('0x2f')];if(!_0x3a908b[_0x24df('0x31')][_0x24df('0x35')](_0x24df('0x36'))){_0x4c8d62[_0x24df('0x1f')]=qs[_0x24df('0x1f')](_0x3a908b[_0x24df('0x31')][_0x24df('0x1f')]);_0x4c8d62[_0x24df('0x1d')]=qs[_0x24df('0x1d')](_0x3a908b[_0x24df('0x31')]['offset']);}_0x4c8d62[_0x24df('0x37')]=qs['sort'](_0x3a908b[_0x24df('0x31')][_0x24df('0x38')]);_0x4c8d62[_0x24df('0x39')]=qs[_0x24df('0x3a')](_[_0x24df('0x3b')](_0x3a908b[_0x24df('0x31')],_0x3834da['filters']),_0x30a9c0);if(_0x3a908b[_0x24df('0x31')][_0x24df('0x3c')]){_0x4c8d62[_0x24df('0x39')]=_[_0x24df('0x3d')](_0x4c8d62[_0x24df('0x39')],{'$or':_['map'](_0x30a9c0,function(_0xaa10f2){if(_0xaa10f2['type']!==_0x24df('0x3e')){var _0x76f2d3={};_0x76f2d3[_0xaa10f2[_0x24df('0x27')]]={'$like':'%'+_0x3a908b[_0x24df('0x31')][_0x24df('0x3c')]+'%'};return _0x76f2d3;}})});}_0x4c8d62=_['merge']({},_0x4c8d62,_0x3a908b['options']);var _0x520b5e={'where':_0x4c8d62[_0x24df('0x39')]};return db[_0x24df('0x2b')][_0x24df('0x20')](_0x520b5e)[_0x24df('0x23')](function(_0x37336b){_0x425162[_0x24df('0x20')]=_0x37336b;if(_0x3a908b[_0x24df('0x31')][_0x24df('0x3f')]){_0x4c8d62[_0x24df('0x40')]=[{'all':!![]}];}return db[_0x24df('0x2b')][_0x24df('0x41')](_0x4c8d62);})[_0x24df('0x23')](function(_0x15427f){_0x425162[_0x24df('0x42')]=_0x15427f;return _0x425162;})[_0x24df('0x23')](respondWithFilteredResult(_0x488875,_0x4c8d62))[_0x24df('0x43')](handleError(_0x488875,null));};exports[_0x24df('0x44')]=function(_0x5ea5f0,_0x31d362){var _0x30cd6e={'raw':![],'where':{'id':_0x5ea5f0['params']['id']}},_0x520450={};_0x520450[_0x24df('0x2f')]=_[_0x24df('0x30')](db['SugarcrmConfiguration']['rawAttributes']);_0x520450['query']=_[_0x24df('0x30')](_0x5ea5f0['query']);_0x520450[_0x24df('0x3a')]=_[_0x24df('0x32')](_0x520450[_0x24df('0x2f')],_0x520450[_0x24df('0x31')]);_0x30cd6e[_0x24df('0x33')]=_[_0x24df('0x32')](_0x520450[_0x24df('0x2f')],qs['fields'](_0x5ea5f0[_0x24df('0x31')]['fields']));_0x30cd6e[_0x24df('0x33')]=_0x30cd6e[_0x24df('0x33')][_0x24df('0x34')]?_0x30cd6e['attributes']:_0x520450[_0x24df('0x2f')];if(_0x5ea5f0['query'][_0x24df('0x3f')]){_0x30cd6e['include']=[{'all':!![]}];}_0x30cd6e=_[_0x24df('0x3d')]({},_0x30cd6e,_0x5ea5f0[_0x24df('0x45')]);return db[_0x24df('0x2b')][_0x24df('0x46')](_0x30cd6e)[_0x24df('0x23')](handleEntityNotFound(_0x31d362,null))[_0x24df('0x23')](respondWithResult(_0x31d362,null))[_0x24df('0x43')](handleError(_0x31d362,null));};exports[_0x24df('0x47')]=function(_0x5bde9a,_0x5754d0){return db[_0x24df('0x2b')][_0x24df('0x47')](_0x5bde9a['body'],{})[_0x24df('0x23')](respondWithResult(_0x5754d0,0xc9))[_0x24df('0x43')](handleError(_0x5754d0,null));};exports['update']=function(_0x2c943a,_0x5a7d0c){if(_0x2c943a[_0x24df('0x48')]['id']){delete _0x2c943a[_0x24df('0x48')]['id'];}return db[_0x24df('0x2b')]['find']({'where':{'id':_0x2c943a[_0x24df('0x49')]['id']}})[_0x24df('0x23')](handleEntityNotFound(_0x5a7d0c,null))[_0x24df('0x23')](saveUpdates(_0x2c943a[_0x24df('0x48')],null))[_0x24df('0x23')](respondWithResult(_0x5a7d0c,null))[_0x24df('0x43')](handleError(_0x5a7d0c,null));};exports[_0x24df('0x24')]=function(_0xc9d710,_0x419a36){return db['SugarcrmConfiguration'][_0x24df('0x46')]({'where':{'id':_0xc9d710[_0x24df('0x49')]['id']}})[_0x24df('0x23')](handleEntityNotFound(_0x419a36,null))['then'](removeEntity(_0x419a36,null))[_0x24df('0x43')](handleError(_0x419a36,null));};exports[_0x24df('0x4a')]=function(_0x242dfb,_0x411e3c,_0x32bf5c){var _0x3a7254={};var _0x5e43f3={};var _0x1ebbf7;var _0x1dd190;return db['SugarcrmConfiguration'][_0x24df('0x4b')]({'where':{'id':_0x242dfb['params']['id']}})[_0x24df('0x23')](handleEntityNotFound(_0x411e3c,null))[_0x24df('0x23')](function(_0x282a6d){if(_0x282a6d){_0x1ebbf7=_0x282a6d;_0x5e43f3['model']=_[_0x24df('0x30')](db[_0x24df('0x4c')][_0x24df('0x2c')]);_0x5e43f3['query']=_[_0x24df('0x30')](_0x242dfb[_0x24df('0x31')]);_0x5e43f3['filters']=_[_0x24df('0x32')](_0x5e43f3[_0x24df('0x2f')],_0x5e43f3[_0x24df('0x31')]);_0x3a7254[_0x24df('0x33')]=_[_0x24df('0x32')](_0x5e43f3['model'],qs[_0x24df('0x4d')](_0x242dfb[_0x24df('0x31')][_0x24df('0x4d')]));_0x3a7254[_0x24df('0x33')]=_0x3a7254[_0x24df('0x33')][_0x24df('0x34')]?_0x3a7254[_0x24df('0x33')]:_0x5e43f3['model'];_0x3a7254[_0x24df('0x37')]=qs[_0x24df('0x38')](_0x242dfb[_0x24df('0x31')][_0x24df('0x38')]);_0x3a7254[_0x24df('0x39')]=qs[_0x24df('0x3a')](_['pick'](_0x242dfb[_0x24df('0x31')],_0x5e43f3[_0x24df('0x3a')]));if(_0x242dfb[_0x24df('0x31')][_0x24df('0x3c')]){_0x3a7254['where']=_[_0x24df('0x3d')](_0x3a7254[_0x24df('0x39')],{'$or':_['map'](_0x3a7254[_0x24df('0x33')],function(_0x43c9ef){var _0x4c23e9={};_0x4c23e9[_0x43c9ef]={'$like':'%'+_0x242dfb[_0x24df('0x31')][_0x24df('0x3c')]+'%'};return _0x4c23e9;})});}_0x3a7254=_[_0x24df('0x3d')]({},_0x3a7254,_0x242dfb[_0x24df('0x45')]);return _0x1ebbf7['getFields'](_0x3a7254);}})[_0x24df('0x23')](function(_0x5ab291){if(_0x5ab291){_0x1dd190=_0x5ab291[_0x24df('0x34')];if(!_0x242dfb['query'][_0x24df('0x35')](_0x24df('0x36'))){_0x3a7254[_0x24df('0x1f')]=qs[_0x24df('0x1f')](_0x242dfb['query'][_0x24df('0x1f')]);_0x3a7254['offset']=qs[_0x24df('0x1d')](_0x242dfb[_0x24df('0x31')][_0x24df('0x1d')]);}return _0x1ebbf7[_0x24df('0x4a')](_0x3a7254);}})['then'](function(_0x3c9f6d){if(_0x3c9f6d){return _0x3c9f6d?{'count':_0x1dd190,'rows':_0x3c9f6d}:null;}})[_0x24df('0x23')](respondWithResult(_0x411e3c,null))['catch'](handleError(_0x411e3c,null));};exports[_0x24df('0x4e')]=function(_0x149c49,_0x394e0b,_0x4d4380){var _0x52850b={};var _0x17cabb={};var _0x5ed37e;var _0x4f00ee;return db[_0x24df('0x2b')]['findOne']({'where':{'id':_0x149c49[_0x24df('0x49')]['id']}})[_0x24df('0x23')](handleEntityNotFound(_0x394e0b,null))[_0x24df('0x23')](function(_0x2d6a08){if(_0x2d6a08){_0x5ed37e=_0x2d6a08;_0x17cabb[_0x24df('0x2f')]=_[_0x24df('0x30')](db['SugarcrmField']['rawAttributes']);_0x17cabb[_0x24df('0x31')]=_[_0x24df('0x30')](_0x149c49['query']);_0x17cabb[_0x24df('0x3a')]=_['intersection'](_0x17cabb[_0x24df('0x2f')],_0x17cabb[_0x24df('0x31')]);_0x52850b[_0x24df('0x33')]=_['intersection'](_0x17cabb[_0x24df('0x2f')],qs[_0x24df('0x4d')](_0x149c49[_0x24df('0x31')][_0x24df('0x4d')]));_0x52850b[_0x24df('0x33')]=_0x52850b['attributes']['length']?_0x52850b[_0x24df('0x33')]:_0x17cabb[_0x24df('0x2f')];_0x52850b['order']=qs[_0x24df('0x38')](_0x149c49[_0x24df('0x31')][_0x24df('0x38')]);_0x52850b['where']=qs[_0x24df('0x3a')](_[_0x24df('0x3b')](_0x149c49[_0x24df('0x31')],_0x17cabb[_0x24df('0x3a')]));if(_0x149c49['query'][_0x24df('0x3c')]){_0x52850b[_0x24df('0x39')]=_[_0x24df('0x3d')](_0x52850b[_0x24df('0x39')],{'$or':_[_0x24df('0x2a')](_0x52850b[_0x24df('0x33')],function(_0x4d79b2){var _0x4eb837={};_0x4eb837[_0x4d79b2]={'$like':'%'+_0x149c49[_0x24df('0x31')][_0x24df('0x3c')]+'%'};return _0x4eb837;})});}_0x52850b=_[_0x24df('0x3d')]({},_0x52850b,_0x149c49[_0x24df('0x45')]);return _0x5ed37e[_0x24df('0x4e')](_0x52850b);}})[_0x24df('0x23')](function(_0x148ebb){if(_0x148ebb){_0x4f00ee=_0x148ebb[_0x24df('0x34')];if(!_0x149c49['query']['hasOwnProperty'](_0x24df('0x36'))){_0x52850b[_0x24df('0x1f')]=qs['limit'](_0x149c49[_0x24df('0x31')][_0x24df('0x1f')]);_0x52850b['offset']=qs[_0x24df('0x1d')](_0x149c49['query'][_0x24df('0x1d')]);}return _0x5ed37e['getSubjects'](_0x52850b);}})[_0x24df('0x23')](function(_0x497107){if(_0x497107){return _0x497107?{'count':_0x4f00ee,'rows':_0x497107}:null;}})['then'](respondWithResult(_0x394e0b,null))[_0x24df('0x43')](handleError(_0x394e0b,null));};exports['getDescriptions']=function(_0x5e531e,_0x2a1bd8,_0xe34920){var _0x3852d7={};var _0x526b79={};var _0x3abb33;var _0x512c95;return db[_0x24df('0x2b')]['findOne']({'where':{'id':_0x5e531e[_0x24df('0x49')]['id']}})[_0x24df('0x23')](handleEntityNotFound(_0x2a1bd8,null))['then'](function(_0x110d9c){if(_0x110d9c){_0x3abb33=_0x110d9c;_0x526b79[_0x24df('0x2f')]=_[_0x24df('0x30')](db['SugarcrmField'][_0x24df('0x2c')]);_0x526b79[_0x24df('0x31')]=_[_0x24df('0x30')](_0x5e531e[_0x24df('0x31')]);_0x526b79[_0x24df('0x3a')]=_[_0x24df('0x32')](_0x526b79[_0x24df('0x2f')],_0x526b79[_0x24df('0x31')]);_0x3852d7[_0x24df('0x33')]=_['intersection'](_0x526b79[_0x24df('0x2f')],qs[_0x24df('0x4d')](_0x5e531e[_0x24df('0x31')][_0x24df('0x4d')]));_0x3852d7['attributes']=_0x3852d7[_0x24df('0x33')][_0x24df('0x34')]?_0x3852d7[_0x24df('0x33')]:_0x526b79[_0x24df('0x2f')];_0x3852d7[_0x24df('0x37')]=qs[_0x24df('0x38')](_0x5e531e[_0x24df('0x31')][_0x24df('0x38')]);_0x3852d7[_0x24df('0x39')]=qs['filters'](_[_0x24df('0x3b')](_0x5e531e[_0x24df('0x31')],_0x526b79[_0x24df('0x3a')]));if(_0x5e531e['query'][_0x24df('0x3c')]){_0x3852d7[_0x24df('0x39')]=_[_0x24df('0x3d')](_0x3852d7[_0x24df('0x39')],{'$or':_[_0x24df('0x2a')](_0x3852d7['attributes'],function(_0x248bb3){var _0x5a3170={};_0x5a3170[_0x248bb3]={'$like':'%'+_0x5e531e[_0x24df('0x31')][_0x24df('0x3c')]+'%'};return _0x5a3170;})});}_0x3852d7=_['merge']({},_0x3852d7,_0x5e531e['options']);return _0x3abb33[_0x24df('0x4f')](_0x3852d7);}})['then'](function(_0x2ed6b5){if(_0x2ed6b5){_0x512c95=_0x2ed6b5[_0x24df('0x34')];if(!_0x5e531e[_0x24df('0x31')][_0x24df('0x35')](_0x24df('0x36'))){_0x3852d7[_0x24df('0x1f')]=qs['limit'](_0x5e531e['query'][_0x24df('0x1f')]);_0x3852d7[_0x24df('0x1d')]=qs[_0x24df('0x1d')](_0x5e531e[_0x24df('0x31')][_0x24df('0x1d')]);}return _0x3abb33[_0x24df('0x4f')](_0x3852d7);}})[_0x24df('0x23')](function(_0x4a9bc7){if(_0x4a9bc7){return _0x4a9bc7?{'count':_0x512c95,'rows':_0x4a9bc7}:null;}})[_0x24df('0x23')](respondWithResult(_0x2a1bd8,null))[_0x24df('0x43')](handleError(_0x2a1bd8,null));};