d8d05c87bfd109f5018e9e4f2652676a9ff9857e
[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 _0x71e2=['count','set','apply','reject','update','destroy','then','sendStatus','name','send','index','map','SugarcrmConfiguration','type','model','keys','query','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','filter','merge','VIRTUAL','includeAll','include','catch','show','params','rawAttributes','find','create','body','getFields','findOne','pick','options','SugarcrmField','getDescriptions','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','status','end','json','offset','limit','undefined'];(function(_0x911a74,_0x5e89cd){var _0x461b01=function(_0x3a1fc4){while(--_0x3a1fc4){_0x911a74['push'](_0x911a74['shift']());}};_0x461b01(++_0x5e89cd);}(_0x71e2,0x1a9));var _0x271e=function(_0x9b6e9,_0x31a4f4){_0x9b6e9=_0x9b6e9-0x0;var _0x5b6967=_0x71e2[_0x9b6e9];return _0x5b6967;};'use strict';var emlformat=require(_0x271e('0x0'));var rimraf=require(_0x271e('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x271e('0x2'));var rp=require(_0x271e('0x3'));var moment=require(_0x271e('0x4'));var BPromise=require(_0x271e('0x5'));var Mustache=require(_0x271e('0x6'));var util=require(_0x271e('0x7'));var path=require(_0x271e('0x8'));var sox=require(_0x271e('0x9'));var csv=require(_0x271e('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x271e('0xb'));var _=require('lodash');var squel=require(_0x271e('0xc'));var crypto=require(_0x271e('0xd'));var jsforce=require(_0x271e('0xe'));var deskjs=require(_0x271e('0xf'));var toCsv=require(_0x271e('0xa'));var querystring=require('querystring');var Papa=require(_0x271e('0x10'));var Redis=require(_0x271e('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x271e('0x12'));var as=require(_0x271e('0x13'));var hardwareService=require(_0x271e('0x14'));var logger=require('../../config/logger')(_0x271e('0x15'));var utils=require('../../config/utils');var config=require(_0x271e('0x16'));var licenseUtil=require(_0x271e('0x17'));var db=require(_0x271e('0x18'))['db'];function respondWithStatusCode(_0x3e9b8f,_0x4f4707){_0x4f4707=_0x4f4707||0xcc;return function(_0x2760fc){if(_0x2760fc){return _0x3e9b8f['sendStatus'](_0x4f4707);}return _0x3e9b8f[_0x271e('0x19')](_0x4f4707)[_0x271e('0x1a')]();};}function respondWithResult(_0x18badb,_0x962e65){_0x962e65=_0x962e65||0xc8;return function(_0x57a5d8){if(_0x57a5d8){return _0x18badb[_0x271e('0x19')](_0x962e65)[_0x271e('0x1b')](_0x57a5d8);}};}function respondWithFilteredResult(_0x251145,_0x210257){return function(_0x4b254a){if(_0x4b254a){var _0x218ed9=typeof _0x210257[_0x271e('0x1c')]==='undefined'&&typeof _0x210257[_0x271e('0x1d')]===_0x271e('0x1e');var _0x53f6ff=_0x4b254a['count'];var _0xec47a1=_0x218ed9?0x0:_0x210257[_0x271e('0x1c')];var _0x21af2a=_0x218ed9?_0x4b254a[_0x271e('0x1f')]:_0x210257[_0x271e('0x1c')]+_0x210257[_0x271e('0x1d')];var _0x1fc022;if(_0x21af2a>=_0x53f6ff){_0x21af2a=_0x53f6ff;_0x1fc022=0xc8;}else{_0x1fc022=0xce;}_0x251145[_0x271e('0x19')](_0x1fc022);return _0x251145[_0x271e('0x20')]('Content-Range',_0xec47a1+'-'+_0x21af2a+'/'+_0x53f6ff)[_0x271e('0x1b')](_0x4b254a);}return null;};}function patchUpdates(_0x3bbfa8){return function(_0x22d40e){try{jsonpatch[_0x271e('0x21')](_0x22d40e,_0x3bbfa8,!![]);}catch(_0x546676){return BPromise[_0x271e('0x22')](_0x546676);}return _0x22d40e['save']();};}function saveUpdates(_0x5271b2,_0x20e5f5){return function(_0x47662a){if(_0x47662a){return _0x47662a[_0x271e('0x23')](_0x5271b2)['then'](function(_0x1a67b4){return _0x1a67b4;});}return null;};}function removeEntity(_0x38b2d6,_0x286326){return function(_0x5295d8){if(_0x5295d8){return _0x5295d8[_0x271e('0x24')]()[_0x271e('0x25')](function(){_0x38b2d6['status'](0xcc)[_0x271e('0x1a')]();});}};}function handleEntityNotFound(_0x280521,_0xe3a628){return function(_0x410189){if(!_0x410189){_0x280521[_0x271e('0x26')](0x194);}return _0x410189;};}function handleError(_0x1db5d6,_0x2df9cc){_0x2df9cc=_0x2df9cc||0x1f4;return function(_0x94a68a){logger['error'](_0x94a68a['stack']);if(_0x94a68a[_0x271e('0x27')]){delete _0x94a68a['name'];}_0x1db5d6[_0x271e('0x19')](_0x2df9cc)[_0x271e('0x28')](_0x94a68a);};}exports[_0x271e('0x29')]=function(_0x372326,_0x43febb){var _0x16a557={},_0x4aef60={},_0x11359f={'count':0x0,'rows':[]};var _0x271ed7=_[_0x271e('0x2a')](db[_0x271e('0x2b')]['rawAttributes'],function(_0x50583b){return{'name':_0x50583b['fieldName'],'type':_0x50583b[_0x271e('0x2c')]['key']};});_0x4aef60[_0x271e('0x2d')]=_[_0x271e('0x2a')](_0x271ed7,_0x271e('0x27'));_0x4aef60['query']=_[_0x271e('0x2e')](_0x372326[_0x271e('0x2f')]);_0x4aef60['filters']=_[_0x271e('0x30')](_0x4aef60['model'],_0x4aef60['query']);_0x16a557['attributes']=_[_0x271e('0x30')](_0x4aef60[_0x271e('0x2d')],qs[_0x271e('0x31')](_0x372326[_0x271e('0x2f')][_0x271e('0x31')]));_0x16a557['attributes']=_0x16a557[_0x271e('0x32')][_0x271e('0x33')]?_0x16a557['attributes']:_0x4aef60[_0x271e('0x2d')];if(!_0x372326[_0x271e('0x2f')][_0x271e('0x34')](_0x271e('0x35'))){_0x16a557[_0x271e('0x1d')]=qs['limit'](_0x372326[_0x271e('0x2f')][_0x271e('0x1d')]);_0x16a557[_0x271e('0x1c')]=qs['offset'](_0x372326[_0x271e('0x2f')][_0x271e('0x1c')]);}_0x16a557[_0x271e('0x36')]=qs[_0x271e('0x37')](_0x372326['query']['sort']);_0x16a557[_0x271e('0x38')]=qs[_0x271e('0x39')](_['pick'](_0x372326[_0x271e('0x2f')],_0x4aef60[_0x271e('0x39')]),_0x271ed7);if(_0x372326[_0x271e('0x2f')][_0x271e('0x3a')]){_0x16a557[_0x271e('0x38')]=_[_0x271e('0x3b')](_0x16a557[_0x271e('0x38')],{'$or':_['map'](_0x271ed7,function(_0x5e4baa){if(_0x5e4baa[_0x271e('0x2c')]!==_0x271e('0x3c')){var _0x202e34={};_0x202e34[_0x5e4baa[_0x271e('0x27')]]={'$like':'%'+_0x372326[_0x271e('0x2f')]['filter']+'%'};return _0x202e34;}})});}_0x16a557=_[_0x271e('0x3b')]({},_0x16a557,_0x372326['options']);var _0x390346={'where':_0x16a557[_0x271e('0x38')]};return db['SugarcrmConfiguration'][_0x271e('0x1f')](_0x390346)[_0x271e('0x25')](function(_0xee0a5){_0x11359f['count']=_0xee0a5;if(_0x372326[_0x271e('0x2f')][_0x271e('0x3d')]){_0x16a557[_0x271e('0x3e')]=[{'all':!![]}];}return db[_0x271e('0x2b')]['findAll'](_0x16a557);})['then'](function(_0x5d48e5){_0x11359f['rows']=_0x5d48e5;return _0x11359f;})['then'](respondWithFilteredResult(_0x43febb,_0x16a557))[_0x271e('0x3f')](handleError(_0x43febb,null));};exports[_0x271e('0x40')]=function(_0x249191,_0x52bf60){var _0x38ada7={'raw':![],'where':{'id':_0x249191[_0x271e('0x41')]['id']}},_0x5659e5={};_0x5659e5[_0x271e('0x2d')]=_[_0x271e('0x2e')](db[_0x271e('0x2b')][_0x271e('0x42')]);_0x5659e5[_0x271e('0x2f')]=_[_0x271e('0x2e')](_0x249191[_0x271e('0x2f')]);_0x5659e5[_0x271e('0x39')]=_[_0x271e('0x30')](_0x5659e5[_0x271e('0x2d')],_0x5659e5[_0x271e('0x2f')]);_0x38ada7[_0x271e('0x32')]=_['intersection'](_0x5659e5[_0x271e('0x2d')],qs[_0x271e('0x31')](_0x249191['query']['fields']));_0x38ada7['attributes']=_0x38ada7[_0x271e('0x32')][_0x271e('0x33')]?_0x38ada7[_0x271e('0x32')]:_0x5659e5['model'];if(_0x249191[_0x271e('0x2f')]['includeAll']){_0x38ada7[_0x271e('0x3e')]=[{'all':!![]}];}_0x38ada7=_[_0x271e('0x3b')]({},_0x38ada7,_0x249191['options']);return db[_0x271e('0x2b')][_0x271e('0x43')](_0x38ada7)['then'](handleEntityNotFound(_0x52bf60,null))[_0x271e('0x25')](respondWithResult(_0x52bf60,null))[_0x271e('0x3f')](handleError(_0x52bf60,null));};exports['create']=function(_0x48d26f,_0x5d8bf6){return db['SugarcrmConfiguration'][_0x271e('0x44')](_0x48d26f['body'],{})[_0x271e('0x25')](respondWithResult(_0x5d8bf6,0xc9))[_0x271e('0x3f')](handleError(_0x5d8bf6,null));};exports[_0x271e('0x23')]=function(_0x4d2c25,_0x15e54c){if(_0x4d2c25['body']['id']){delete _0x4d2c25[_0x271e('0x45')]['id'];}return db[_0x271e('0x2b')]['find']({'where':{'id':_0x4d2c25[_0x271e('0x41')]['id']}})[_0x271e('0x25')](handleEntityNotFound(_0x15e54c,null))['then'](saveUpdates(_0x4d2c25[_0x271e('0x45')],null))[_0x271e('0x25')](respondWithResult(_0x15e54c,null))[_0x271e('0x3f')](handleError(_0x15e54c,null));};exports[_0x271e('0x24')]=function(_0x13885e,_0x45e9f3){return db[_0x271e('0x2b')][_0x271e('0x43')]({'where':{'id':_0x13885e[_0x271e('0x41')]['id']}})['then'](handleEntityNotFound(_0x45e9f3,null))[_0x271e('0x25')](removeEntity(_0x45e9f3,null))[_0x271e('0x3f')](handleError(_0x45e9f3,null));};exports[_0x271e('0x46')]=function(_0x592dbe,_0x512c4a,_0x286880){var _0x317d9a={};var _0x3d8b9a={};var _0x340321;var _0x22b342;return db[_0x271e('0x2b')][_0x271e('0x47')]({'where':{'id':_0x592dbe[_0x271e('0x41')]['id']}})[_0x271e('0x25')](handleEntityNotFound(_0x512c4a,null))[_0x271e('0x25')](function(_0x3239ff){if(_0x3239ff){_0x340321=_0x3239ff;_0x3d8b9a['model']=_[_0x271e('0x2e')](db['SugarcrmField'][_0x271e('0x42')]);_0x3d8b9a[_0x271e('0x2f')]=_[_0x271e('0x2e')](_0x592dbe[_0x271e('0x2f')]);_0x3d8b9a['filters']=_[_0x271e('0x30')](_0x3d8b9a['model'],_0x3d8b9a['query']);_0x317d9a[_0x271e('0x32')]=_[_0x271e('0x30')](_0x3d8b9a[_0x271e('0x2d')],qs[_0x271e('0x31')](_0x592dbe[_0x271e('0x2f')][_0x271e('0x31')]));_0x317d9a[_0x271e('0x32')]=_0x317d9a[_0x271e('0x32')]['length']?_0x317d9a[_0x271e('0x32')]:_0x3d8b9a['model'];_0x317d9a[_0x271e('0x36')]=qs[_0x271e('0x37')](_0x592dbe[_0x271e('0x2f')][_0x271e('0x37')]);_0x317d9a['where']=qs[_0x271e('0x39')](_[_0x271e('0x48')](_0x592dbe[_0x271e('0x2f')],_0x3d8b9a[_0x271e('0x39')]));if(_0x592dbe[_0x271e('0x2f')][_0x271e('0x3a')]){_0x317d9a[_0x271e('0x38')]=_['merge'](_0x317d9a[_0x271e('0x38')],{'$or':_[_0x271e('0x2a')](_0x317d9a['attributes'],function(_0x3b358f){var _0x37705a={};_0x37705a[_0x3b358f]={'$like':'%'+_0x592dbe[_0x271e('0x2f')]['filter']+'%'};return _0x37705a;})});}_0x317d9a=_['merge']({},_0x317d9a,_0x592dbe[_0x271e('0x49')]);return _0x340321[_0x271e('0x46')](_0x317d9a);}})[_0x271e('0x25')](function(_0xa7da30){if(_0xa7da30){_0x22b342=_0xa7da30[_0x271e('0x33')];if(!_0x592dbe[_0x271e('0x2f')]['hasOwnProperty'](_0x271e('0x35'))){_0x317d9a['limit']=qs[_0x271e('0x1d')](_0x592dbe[_0x271e('0x2f')][_0x271e('0x1d')]);_0x317d9a[_0x271e('0x1c')]=qs[_0x271e('0x1c')](_0x592dbe[_0x271e('0x2f')][_0x271e('0x1c')]);}return _0x340321['getFields'](_0x317d9a);}})[_0x271e('0x25')](function(_0x525c5b){if(_0x525c5b){return _0x525c5b?{'count':_0x22b342,'rows':_0x525c5b}:null;}})[_0x271e('0x25')](respondWithResult(_0x512c4a,null))[_0x271e('0x3f')](handleError(_0x512c4a,null));};exports['getSubjects']=function(_0x5d56fd,_0x4d5ad3,_0x18c7d9){var _0xaa79c9={};var _0x3a20f9={};var _0x77fee;var _0x29c4e5;return db[_0x271e('0x2b')][_0x271e('0x47')]({'where':{'id':_0x5d56fd[_0x271e('0x41')]['id']}})['then'](handleEntityNotFound(_0x4d5ad3,null))[_0x271e('0x25')](function(_0x581558){if(_0x581558){_0x77fee=_0x581558;_0x3a20f9[_0x271e('0x2d')]=_[_0x271e('0x2e')](db['SugarcrmField'][_0x271e('0x42')]);_0x3a20f9[_0x271e('0x2f')]=_[_0x271e('0x2e')](_0x5d56fd[_0x271e('0x2f')]);_0x3a20f9[_0x271e('0x39')]=_[_0x271e('0x30')](_0x3a20f9['model'],_0x3a20f9[_0x271e('0x2f')]);_0xaa79c9[_0x271e('0x32')]=_[_0x271e('0x30')](_0x3a20f9[_0x271e('0x2d')],qs['fields'](_0x5d56fd[_0x271e('0x2f')][_0x271e('0x31')]));_0xaa79c9[_0x271e('0x32')]=_0xaa79c9[_0x271e('0x32')][_0x271e('0x33')]?_0xaa79c9['attributes']:_0x3a20f9[_0x271e('0x2d')];_0xaa79c9[_0x271e('0x36')]=qs[_0x271e('0x37')](_0x5d56fd[_0x271e('0x2f')]['sort']);_0xaa79c9['where']=qs['filters'](_[_0x271e('0x48')](_0x5d56fd[_0x271e('0x2f')],_0x3a20f9[_0x271e('0x39')]));if(_0x5d56fd['query'][_0x271e('0x3a')]){_0xaa79c9['where']=_[_0x271e('0x3b')](_0xaa79c9['where'],{'$or':_[_0x271e('0x2a')](_0xaa79c9[_0x271e('0x32')],function(_0x11e935){var _0x5cc805={};_0x5cc805[_0x11e935]={'$like':'%'+_0x5d56fd[_0x271e('0x2f')]['filter']+'%'};return _0x5cc805;})});}_0xaa79c9=_[_0x271e('0x3b')]({},_0xaa79c9,_0x5d56fd[_0x271e('0x49')]);return _0x77fee['getSubjects'](_0xaa79c9);}})['then'](function(_0xc1a8f8){if(_0xc1a8f8){_0x29c4e5=_0xc1a8f8['length'];if(!_0x5d56fd['query'][_0x271e('0x34')](_0x271e('0x35'))){_0xaa79c9['limit']=qs[_0x271e('0x1d')](_0x5d56fd['query'][_0x271e('0x1d')]);_0xaa79c9['offset']=qs['offset'](_0x5d56fd[_0x271e('0x2f')][_0x271e('0x1c')]);}return _0x77fee['getSubjects'](_0xaa79c9);}})[_0x271e('0x25')](function(_0x1407e0){if(_0x1407e0){return _0x1407e0?{'count':_0x29c4e5,'rows':_0x1407e0}:null;}})[_0x271e('0x25')](respondWithResult(_0x4d5ad3,null))['catch'](handleError(_0x4d5ad3,null));};exports['getDescriptions']=function(_0xe6e04d,_0x525fc7,_0x2f2eb9){var _0x806609={};var _0x278b2e={};var _0x37d535;var _0x5f201d;return db[_0x271e('0x2b')][_0x271e('0x47')]({'where':{'id':_0xe6e04d[_0x271e('0x41')]['id']}})['then'](handleEntityNotFound(_0x525fc7,null))['then'](function(_0x510212){if(_0x510212){_0x37d535=_0x510212;_0x278b2e[_0x271e('0x2d')]=_[_0x271e('0x2e')](db[_0x271e('0x4a')][_0x271e('0x42')]);_0x278b2e[_0x271e('0x2f')]=_['keys'](_0xe6e04d[_0x271e('0x2f')]);_0x278b2e[_0x271e('0x39')]=_[_0x271e('0x30')](_0x278b2e[_0x271e('0x2d')],_0x278b2e[_0x271e('0x2f')]);_0x806609[_0x271e('0x32')]=_[_0x271e('0x30')](_0x278b2e[_0x271e('0x2d')],qs[_0x271e('0x31')](_0xe6e04d[_0x271e('0x2f')][_0x271e('0x31')]));_0x806609[_0x271e('0x32')]=_0x806609['attributes']['length']?_0x806609[_0x271e('0x32')]:_0x278b2e[_0x271e('0x2d')];_0x806609['order']=qs[_0x271e('0x37')](_0xe6e04d['query'][_0x271e('0x37')]);_0x806609[_0x271e('0x38')]=qs[_0x271e('0x39')](_[_0x271e('0x48')](_0xe6e04d[_0x271e('0x2f')],_0x278b2e[_0x271e('0x39')]));if(_0xe6e04d['query']['filter']){_0x806609[_0x271e('0x38')]=_[_0x271e('0x3b')](_0x806609[_0x271e('0x38')],{'$or':_[_0x271e('0x2a')](_0x806609['attributes'],function(_0x3e451d){var _0xd40a6c={};_0xd40a6c[_0x3e451d]={'$like':'%'+_0xe6e04d['query'][_0x271e('0x3a')]+'%'};return _0xd40a6c;})});}_0x806609=_[_0x271e('0x3b')]({},_0x806609,_0xe6e04d[_0x271e('0x49')]);return _0x37d535[_0x271e('0x4b')](_0x806609);}})[_0x271e('0x25')](function(_0x3f4419){if(_0x3f4419){_0x5f201d=_0x3f4419[_0x271e('0x33')];if(!_0xe6e04d[_0x271e('0x2f')]['hasOwnProperty'](_0x271e('0x35'))){_0x806609[_0x271e('0x1d')]=qs[_0x271e('0x1d')](_0xe6e04d['query'][_0x271e('0x1d')]);_0x806609[_0x271e('0x1c')]=qs[_0x271e('0x1c')](_0xe6e04d[_0x271e('0x2f')][_0x271e('0x1c')]);}return _0x37d535[_0x271e('0x4b')](_0x806609);}})[_0x271e('0x25')](function(_0xcf043e){if(_0xcf043e){return _0xcf043e?{'count':_0x5f201d,'rows':_0xcf043e}:null;}})[_0x271e('0x25')](respondWithResult(_0x525fc7,null))[_0x271e('0x3f')](handleError(_0x525fc7,null));};