Built motion from commit e38a297d.|2.6.18
[motion2.git] / server / api / intSugarcrmConfiguration / intSugarcrmConfiguration.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 _0x0759=['fieldName','type','key','model','query','keys','filters','attributes','intersection','fields','length','nolimit','order','sort','where','pick','filter','map','VIRTUAL','options','includeAll','include','rows','catch','show','params','merge','create','body','find','getFields','findOne','SugarcrmField','hasOwnProperty','getSubjects','getDescriptions','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','set','reject','update','then','stack','name','send','index','SugarcrmConfiguration','rawAttributes'];(function(_0x47e7cb,_0x4c1b8d){var _0x2a8874=function(_0x36498f){while(--_0x36498f){_0x47e7cb['push'](_0x47e7cb['shift']());}};_0x2a8874(++_0x4c1b8d);}(_0x0759,0x111));var _0x9075=function(_0x744e36,_0x239980){_0x744e36=_0x744e36-0x0;var _0x2218f2=_0x0759[_0x744e36];return _0x2218f2;};'use strict';var emlformat=require(_0x9075('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x9075('0x1'));var jsonpatch=require(_0x9075('0x2'));var rp=require('request-promise');var moment=require(_0x9075('0x3'));var BPromise=require(_0x9075('0x4'));var Mustache=require(_0x9075('0x5'));var util=require(_0x9075('0x6'));var path=require(_0x9075('0x7'));var sox=require(_0x9075('0x8'));var csv=require(_0x9075('0x9'));var ejs=require(_0x9075('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x9075('0xb'));var squel=require(_0x9075('0xc'));var crypto=require(_0x9075('0xd'));var jsforce=require(_0x9075('0xe'));var deskjs=require(_0x9075('0xf'));var toCsv=require(_0x9075('0x9'));var querystring=require(_0x9075('0x10'));var Papa=require(_0x9075('0x11'));var Redis=require('ioredis');var authService=require(_0x9075('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x9075('0x13'));var hardwareService=require(_0x9075('0x14'));var logger=require(_0x9075('0x15'))(_0x9075('0x16'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x9075('0x17'));var db=require(_0x9075('0x18'))['db'];function respondWithStatusCode(_0x4d4dcb,_0x4c81d9){_0x4c81d9=_0x4c81d9||0xcc;return function(_0x539c86){if(_0x539c86){return _0x4d4dcb[_0x9075('0x19')](_0x4c81d9);}return _0x4d4dcb['status'](_0x4c81d9)[_0x9075('0x1a')]();};}function respondWithResult(_0x371b82,_0x19f12d){_0x19f12d=_0x19f12d||0xc8;return function(_0xd2e22a){if(_0xd2e22a){return _0x371b82[_0x9075('0x1b')](_0x19f12d)[_0x9075('0x1c')](_0xd2e22a);}};}function respondWithFilteredResult(_0x577835,_0x3fb348){return function(_0x4e7114){if(_0x4e7114){var _0x938822=typeof _0x3fb348[_0x9075('0x1d')]===_0x9075('0x1e')&&typeof _0x3fb348[_0x9075('0x1f')]===_0x9075('0x1e');var _0x1978af=_0x4e7114['count'];var _0x2fe461=_0x938822?0x0:_0x3fb348[_0x9075('0x1d')];var _0x47f873=_0x938822?_0x4e7114[_0x9075('0x20')]:_0x3fb348[_0x9075('0x1d')]+_0x3fb348[_0x9075('0x1f')];var _0x7b3b58;if(_0x47f873>=_0x1978af){_0x47f873=_0x1978af;_0x7b3b58=0xc8;}else{_0x7b3b58=0xce;}_0x577835['status'](_0x7b3b58);return _0x577835[_0x9075('0x21')]('Content-Range',_0x2fe461+'-'+_0x47f873+'/'+_0x1978af)['json'](_0x4e7114);}return null;};}function patchUpdates(_0xf3dedb){return function(_0x406e78){try{jsonpatch['apply'](_0x406e78,_0xf3dedb,!![]);}catch(_0x104e6b){return BPromise[_0x9075('0x22')](_0x104e6b);}return _0x406e78['save']();};}function saveUpdates(_0x3eea08,_0x482325){return function(_0x59aded){if(_0x59aded){return _0x59aded[_0x9075('0x23')](_0x3eea08)[_0x9075('0x24')](function(_0x3befeb){return _0x3befeb;});}return null;};}function removeEntity(_0x2bd56b,_0xe7d8b3){return function(_0x4477cd){if(_0x4477cd){return _0x4477cd['destroy']()[_0x9075('0x24')](function(){_0x2bd56b['status'](0xcc)[_0x9075('0x1a')]();});}};}function handleEntityNotFound(_0x95fb8c,_0x43299c){return function(_0x46a8fa){if(!_0x46a8fa){_0x95fb8c['sendStatus'](0x194);}return _0x46a8fa;};}function handleError(_0x4c9d78,_0x569408){_0x569408=_0x569408||0x1f4;return function(_0x4ad5ec){logger['error'](_0x4ad5ec[_0x9075('0x25')]);if(_0x4ad5ec[_0x9075('0x26')]){delete _0x4ad5ec[_0x9075('0x26')];}_0x4c9d78[_0x9075('0x1b')](_0x569408)[_0x9075('0x27')](_0x4ad5ec);};}exports[_0x9075('0x28')]=function(_0x542b65,_0x1de146){var _0x488297={},_0xec5611={},_0xabb86b={'count':0x0,'rows':[]};var _0x6e5769=_['map'](db[_0x9075('0x29')][_0x9075('0x2a')],function(_0xaa04e3){return{'name':_0xaa04e3[_0x9075('0x2b')],'type':_0xaa04e3[_0x9075('0x2c')][_0x9075('0x2d')]};});_0xec5611[_0x9075('0x2e')]=_['map'](_0x6e5769,_0x9075('0x26'));_0xec5611[_0x9075('0x2f')]=_[_0x9075('0x30')](_0x542b65[_0x9075('0x2f')]);_0xec5611[_0x9075('0x31')]=_['intersection'](_0xec5611['model'],_0xec5611[_0x9075('0x2f')]);_0x488297[_0x9075('0x32')]=_[_0x9075('0x33')](_0xec5611[_0x9075('0x2e')],qs[_0x9075('0x34')](_0x542b65[_0x9075('0x2f')][_0x9075('0x34')]));_0x488297['attributes']=_0x488297[_0x9075('0x32')][_0x9075('0x35')]?_0x488297[_0x9075('0x32')]:_0xec5611[_0x9075('0x2e')];if(!_0x542b65['query']['hasOwnProperty'](_0x9075('0x36'))){_0x488297[_0x9075('0x1f')]=qs[_0x9075('0x1f')](_0x542b65[_0x9075('0x2f')][_0x9075('0x1f')]);_0x488297[_0x9075('0x1d')]=qs[_0x9075('0x1d')](_0x542b65['query'][_0x9075('0x1d')]);}_0x488297[_0x9075('0x37')]=qs['sort'](_0x542b65[_0x9075('0x2f')][_0x9075('0x38')]);_0x488297[_0x9075('0x39')]=qs['filters'](_[_0x9075('0x3a')](_0x542b65['query'],_0xec5611[_0x9075('0x31')]),_0x6e5769);if(_0x542b65[_0x9075('0x2f')][_0x9075('0x3b')]){_0x488297['where']=_['merge'](_0x488297[_0x9075('0x39')],{'$or':_[_0x9075('0x3c')](_0x6e5769,function(_0x3856c5){if(_0x3856c5['type']!==_0x9075('0x3d')){var _0x37c190={};_0x37c190[_0x3856c5[_0x9075('0x26')]]={'$like':'%'+_0x542b65[_0x9075('0x2f')][_0x9075('0x3b')]+'%'};return _0x37c190;}})});}_0x488297=_['merge']({},_0x488297,_0x542b65[_0x9075('0x3e')]);var _0x52c856={'where':_0x488297[_0x9075('0x39')]};return db['SugarcrmConfiguration'][_0x9075('0x20')](_0x52c856)['then'](function(_0x4a97d2){_0xabb86b[_0x9075('0x20')]=_0x4a97d2;if(_0x542b65[_0x9075('0x2f')][_0x9075('0x3f')]){_0x488297[_0x9075('0x40')]=[{'all':!![]}];}return db[_0x9075('0x29')]['findAll'](_0x488297);})[_0x9075('0x24')](function(_0x4016f4){_0xabb86b[_0x9075('0x41')]=_0x4016f4;return _0xabb86b;})[_0x9075('0x24')](respondWithFilteredResult(_0x1de146,_0x488297))[_0x9075('0x42')](handleError(_0x1de146,null));};exports[_0x9075('0x43')]=function(_0x46e04a,_0x465796){var _0x4e9092={'raw':![],'where':{'id':_0x46e04a[_0x9075('0x44')]['id']}},_0x136984={};_0x136984[_0x9075('0x2e')]=_[_0x9075('0x30')](db[_0x9075('0x29')]['rawAttributes']);_0x136984[_0x9075('0x2f')]=_[_0x9075('0x30')](_0x46e04a['query']);_0x136984[_0x9075('0x31')]=_['intersection'](_0x136984[_0x9075('0x2e')],_0x136984[_0x9075('0x2f')]);_0x4e9092[_0x9075('0x32')]=_['intersection'](_0x136984[_0x9075('0x2e')],qs[_0x9075('0x34')](_0x46e04a[_0x9075('0x2f')][_0x9075('0x34')]));_0x4e9092['attributes']=_0x4e9092[_0x9075('0x32')][_0x9075('0x35')]?_0x4e9092['attributes']:_0x136984[_0x9075('0x2e')];if(_0x46e04a[_0x9075('0x2f')][_0x9075('0x3f')]){_0x4e9092[_0x9075('0x40')]=[{'all':!![]}];}_0x4e9092=_[_0x9075('0x45')]({},_0x4e9092,_0x46e04a[_0x9075('0x3e')]);return db[_0x9075('0x29')]['find'](_0x4e9092)[_0x9075('0x24')](handleEntityNotFound(_0x465796,null))[_0x9075('0x24')](respondWithResult(_0x465796,null))[_0x9075('0x42')](handleError(_0x465796,null));};exports['create']=function(_0x285f59,_0x47d977){return db[_0x9075('0x29')][_0x9075('0x46')](_0x285f59[_0x9075('0x47')],{})[_0x9075('0x24')](respondWithResult(_0x47d977,0xc9))[_0x9075('0x42')](handleError(_0x47d977,null));};exports['update']=function(_0x3cdfde,_0x2d1c01){if(_0x3cdfde[_0x9075('0x47')]['id']){delete _0x3cdfde[_0x9075('0x47')]['id'];}return db['SugarcrmConfiguration'][_0x9075('0x48')]({'where':{'id':_0x3cdfde[_0x9075('0x44')]['id']}})[_0x9075('0x24')](handleEntityNotFound(_0x2d1c01,null))[_0x9075('0x24')](saveUpdates(_0x3cdfde[_0x9075('0x47')],null))['then'](respondWithResult(_0x2d1c01,null))[_0x9075('0x42')](handleError(_0x2d1c01,null));};exports['destroy']=function(_0x4de48d,_0x5570f8){return db[_0x9075('0x29')][_0x9075('0x48')]({'where':{'id':_0x4de48d[_0x9075('0x44')]['id']}})[_0x9075('0x24')](handleEntityNotFound(_0x5570f8,null))[_0x9075('0x24')](removeEntity(_0x5570f8,null))[_0x9075('0x42')](handleError(_0x5570f8,null));};exports[_0x9075('0x49')]=function(_0x818e92,_0x27fd64,_0x4c1c0d){var _0x5a57fd={};var _0x2ee10d={};var _0x3d61c5;var _0x19cf55;return db[_0x9075('0x29')][_0x9075('0x4a')]({'where':{'id':_0x818e92[_0x9075('0x44')]['id']}})[_0x9075('0x24')](handleEntityNotFound(_0x27fd64,null))[_0x9075('0x24')](function(_0x369c5c){if(_0x369c5c){_0x3d61c5=_0x369c5c;_0x2ee10d[_0x9075('0x2e')]=_['keys'](db[_0x9075('0x4b')][_0x9075('0x2a')]);_0x2ee10d['query']=_[_0x9075('0x30')](_0x818e92['query']);_0x2ee10d[_0x9075('0x31')]=_['intersection'](_0x2ee10d[_0x9075('0x2e')],_0x2ee10d[_0x9075('0x2f')]);_0x5a57fd[_0x9075('0x32')]=_[_0x9075('0x33')](_0x2ee10d['model'],qs[_0x9075('0x34')](_0x818e92['query'][_0x9075('0x34')]));_0x5a57fd[_0x9075('0x32')]=_0x5a57fd[_0x9075('0x32')][_0x9075('0x35')]?_0x5a57fd[_0x9075('0x32')]:_0x2ee10d[_0x9075('0x2e')];_0x5a57fd[_0x9075('0x37')]=qs[_0x9075('0x38')](_0x818e92['query']['sort']);_0x5a57fd[_0x9075('0x39')]=qs['filters'](_['pick'](_0x818e92[_0x9075('0x2f')],_0x2ee10d[_0x9075('0x31')]));if(_0x818e92[_0x9075('0x2f')][_0x9075('0x3b')]){_0x5a57fd[_0x9075('0x39')]=_[_0x9075('0x45')](_0x5a57fd['where'],{'$or':_[_0x9075('0x3c')](_0x5a57fd[_0x9075('0x32')],function(_0x12344d){var _0xab90c={};_0xab90c[_0x12344d]={'$like':'%'+_0x818e92[_0x9075('0x2f')]['filter']+'%'};return _0xab90c;})});}_0x5a57fd=_['merge']({},_0x5a57fd,_0x818e92[_0x9075('0x3e')]);return _0x3d61c5[_0x9075('0x49')](_0x5a57fd);}})[_0x9075('0x24')](function(_0x1a99a6){if(_0x1a99a6){_0x19cf55=_0x1a99a6['length'];if(!_0x818e92[_0x9075('0x2f')][_0x9075('0x4c')](_0x9075('0x36'))){_0x5a57fd[_0x9075('0x1f')]=qs[_0x9075('0x1f')](_0x818e92['query'][_0x9075('0x1f')]);_0x5a57fd[_0x9075('0x1d')]=qs[_0x9075('0x1d')](_0x818e92[_0x9075('0x2f')][_0x9075('0x1d')]);}return _0x3d61c5['getFields'](_0x5a57fd);}})[_0x9075('0x24')](function(_0xe3e990){if(_0xe3e990){return _0xe3e990?{'count':_0x19cf55,'rows':_0xe3e990}:null;}})['then'](respondWithResult(_0x27fd64,null))['catch'](handleError(_0x27fd64,null));};exports[_0x9075('0x4d')]=function(_0x561441,_0x4fe0a7,_0x425489){var _0x470fa3={};var _0x3c02d7={};var _0x3b22a1;var _0x36b36d;return db[_0x9075('0x29')][_0x9075('0x4a')]({'where':{'id':_0x561441['params']['id']}})[_0x9075('0x24')](handleEntityNotFound(_0x4fe0a7,null))[_0x9075('0x24')](function(_0xfeb226){if(_0xfeb226){_0x3b22a1=_0xfeb226;_0x3c02d7[_0x9075('0x2e')]=_[_0x9075('0x30')](db[_0x9075('0x4b')][_0x9075('0x2a')]);_0x3c02d7['query']=_['keys'](_0x561441[_0x9075('0x2f')]);_0x3c02d7[_0x9075('0x31')]=_[_0x9075('0x33')](_0x3c02d7[_0x9075('0x2e')],_0x3c02d7[_0x9075('0x2f')]);_0x470fa3[_0x9075('0x32')]=_[_0x9075('0x33')](_0x3c02d7['model'],qs[_0x9075('0x34')](_0x561441[_0x9075('0x2f')]['fields']));_0x470fa3[_0x9075('0x32')]=_0x470fa3['attributes']['length']?_0x470fa3['attributes']:_0x3c02d7[_0x9075('0x2e')];_0x470fa3[_0x9075('0x37')]=qs[_0x9075('0x38')](_0x561441[_0x9075('0x2f')]['sort']);_0x470fa3['where']=qs[_0x9075('0x31')](_[_0x9075('0x3a')](_0x561441['query'],_0x3c02d7['filters']));if(_0x561441[_0x9075('0x2f')][_0x9075('0x3b')]){_0x470fa3[_0x9075('0x39')]=_['merge'](_0x470fa3[_0x9075('0x39')],{'$or':_[_0x9075('0x3c')](_0x470fa3[_0x9075('0x32')],function(_0x16e512){var _0x392624={};_0x392624[_0x16e512]={'$like':'%'+_0x561441[_0x9075('0x2f')]['filter']+'%'};return _0x392624;})});}_0x470fa3=_[_0x9075('0x45')]({},_0x470fa3,_0x561441[_0x9075('0x3e')]);return _0x3b22a1[_0x9075('0x4d')](_0x470fa3);}})[_0x9075('0x24')](function(_0x2a8274){if(_0x2a8274){_0x36b36d=_0x2a8274[_0x9075('0x35')];if(!_0x561441[_0x9075('0x2f')][_0x9075('0x4c')](_0x9075('0x36'))){_0x470fa3[_0x9075('0x1f')]=qs[_0x9075('0x1f')](_0x561441[_0x9075('0x2f')][_0x9075('0x1f')]);_0x470fa3[_0x9075('0x1d')]=qs['offset'](_0x561441[_0x9075('0x2f')][_0x9075('0x1d')]);}return _0x3b22a1[_0x9075('0x4d')](_0x470fa3);}})[_0x9075('0x24')](function(_0x32250b){if(_0x32250b){return _0x32250b?{'count':_0x36b36d,'rows':_0x32250b}:null;}})[_0x9075('0x24')](respondWithResult(_0x4fe0a7,null))[_0x9075('0x42')](handleError(_0x4fe0a7,null));};exports['getDescriptions']=function(_0x587fb0,_0x3df437,_0x40fc12){var _0x6eca58={};var _0x110593={};var _0x171901;var _0x3dc69f;return db['SugarcrmConfiguration'][_0x9075('0x4a')]({'where':{'id':_0x587fb0['params']['id']}})[_0x9075('0x24')](handleEntityNotFound(_0x3df437,null))[_0x9075('0x24')](function(_0x2e504a){if(_0x2e504a){_0x171901=_0x2e504a;_0x110593['model']=_[_0x9075('0x30')](db[_0x9075('0x4b')][_0x9075('0x2a')]);_0x110593[_0x9075('0x2f')]=_[_0x9075('0x30')](_0x587fb0[_0x9075('0x2f')]);_0x110593[_0x9075('0x31')]=_[_0x9075('0x33')](_0x110593[_0x9075('0x2e')],_0x110593[_0x9075('0x2f')]);_0x6eca58[_0x9075('0x32')]=_['intersection'](_0x110593['model'],qs[_0x9075('0x34')](_0x587fb0['query']['fields']));_0x6eca58[_0x9075('0x32')]=_0x6eca58[_0x9075('0x32')][_0x9075('0x35')]?_0x6eca58['attributes']:_0x110593[_0x9075('0x2e')];_0x6eca58[_0x9075('0x37')]=qs[_0x9075('0x38')](_0x587fb0[_0x9075('0x2f')]['sort']);_0x6eca58['where']=qs[_0x9075('0x31')](_[_0x9075('0x3a')](_0x587fb0[_0x9075('0x2f')],_0x110593[_0x9075('0x31')]));if(_0x587fb0['query'][_0x9075('0x3b')]){_0x6eca58['where']=_[_0x9075('0x45')](_0x6eca58[_0x9075('0x39')],{'$or':_[_0x9075('0x3c')](_0x6eca58[_0x9075('0x32')],function(_0x4aee7a){var _0x5ac209={};_0x5ac209[_0x4aee7a]={'$like':'%'+_0x587fb0[_0x9075('0x2f')][_0x9075('0x3b')]+'%'};return _0x5ac209;})});}_0x6eca58=_['merge']({},_0x6eca58,_0x587fb0[_0x9075('0x3e')]);return _0x171901[_0x9075('0x4e')](_0x6eca58);}})[_0x9075('0x24')](function(_0x37741b){if(_0x37741b){_0x3dc69f=_0x37741b[_0x9075('0x35')];if(!_0x587fb0[_0x9075('0x2f')]['hasOwnProperty'](_0x9075('0x36'))){_0x6eca58[_0x9075('0x1f')]=qs['limit'](_0x587fb0[_0x9075('0x2f')][_0x9075('0x1f')]);_0x6eca58[_0x9075('0x1d')]=qs['offset'](_0x587fb0[_0x9075('0x2f')][_0x9075('0x1d')]);}return _0x171901[_0x9075('0x4e')](_0x6eca58);}})[_0x9075('0x24')](function(_0x5b7ac5){if(_0x5b7ac5){return _0x5b7ac5?{'count':_0x3dc69f,'rows':_0x5b7ac5}:null;}})[_0x9075('0x24')](respondWithResult(_0x3df437,null))[_0x9075('0x42')](handleError(_0x3df437,null));};