Built motion from commit 192134f6.|2.6.25
[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 _0x4329=['reject','save','update','then','destroy','sendStatus','stack','name','index','map','SugarcrmConfiguration','rawAttributes','fieldName','type','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','options','include','findAll','rows','params','keys','includeAll','find','catch','create','body','getFields','findOne','SugarcrmField','order','getSubjects','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','end','json','offset','undefined','limit','count','status','set','apply'];(function(_0x3b16e1,_0x3bda3e){var _0x311d1b=function(_0x2a979b){while(--_0x2a979b){_0x3b16e1['push'](_0x3b16e1['shift']());}};_0x311d1b(++_0x3bda3e);}(_0x4329,0x169));var _0x9432=function(_0x30ae5e,_0x391fc4){_0x30ae5e=_0x30ae5e-0x0;var _0x1f2e93=_0x4329[_0x30ae5e];return _0x1f2e93;};'use strict';var emlformat=require(_0x9432('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x9432('0x1'));var jsonpatch=require(_0x9432('0x2'));var rp=require(_0x9432('0x3'));var moment=require(_0x9432('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x9432('0x5'));var util=require(_0x9432('0x6'));var path=require(_0x9432('0x7'));var sox=require(_0x9432('0x8'));var csv=require('to-csv');var ejs=require(_0x9432('0x9'));var fs=require('fs');var fs_extra=require(_0x9432('0xa'));var _=require(_0x9432('0xb'));var squel=require('squel');var crypto=require(_0x9432('0xc'));var jsforce=require(_0x9432('0xd'));var deskjs=require(_0x9432('0xe'));var toCsv=require('to-csv');var querystring=require(_0x9432('0xf'));var Papa=require(_0x9432('0x10'));var Redis=require(_0x9432('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x9432('0x12'));var as=require(_0x9432('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x9432('0x14'))(_0x9432('0x15'));var utils=require(_0x9432('0x16'));var config=require(_0x9432('0x17'));var licenseUtil=require(_0x9432('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2c8486,_0xf1547){_0xf1547=_0xf1547||0xcc;return function(_0x175f70){if(_0x175f70){return _0x2c8486['sendStatus'](_0xf1547);}return _0x2c8486['status'](_0xf1547)[_0x9432('0x19')]();};}function respondWithResult(_0x2e189c,_0x12a8db){_0x12a8db=_0x12a8db||0xc8;return function(_0x33e5e5){if(_0x33e5e5){return _0x2e189c['status'](_0x12a8db)[_0x9432('0x1a')](_0x33e5e5);}};}function respondWithFilteredResult(_0x55a561,_0x2d6aeb){return function(_0x4f6774){if(_0x4f6774){var _0x78c6e8=typeof _0x2d6aeb[_0x9432('0x1b')]===_0x9432('0x1c')&&typeof _0x2d6aeb[_0x9432('0x1d')]===_0x9432('0x1c');var _0xbc1761=_0x4f6774['count'];var _0x509cad=_0x78c6e8?0x0:_0x2d6aeb[_0x9432('0x1b')];var _0x1755ac=_0x78c6e8?_0x4f6774[_0x9432('0x1e')]:_0x2d6aeb[_0x9432('0x1b')]+_0x2d6aeb[_0x9432('0x1d')];var _0x538e08;if(_0x1755ac>=_0xbc1761){_0x1755ac=_0xbc1761;_0x538e08=0xc8;}else{_0x538e08=0xce;}_0x55a561[_0x9432('0x1f')](_0x538e08);return _0x55a561[_0x9432('0x20')]('Content-Range',_0x509cad+'-'+_0x1755ac+'/'+_0xbc1761)[_0x9432('0x1a')](_0x4f6774);}return null;};}function patchUpdates(_0x457a53){return function(_0x4ca6d3){try{jsonpatch[_0x9432('0x21')](_0x4ca6d3,_0x457a53,!![]);}catch(_0x4487a3){return BPromise[_0x9432('0x22')](_0x4487a3);}return _0x4ca6d3[_0x9432('0x23')]();};}function saveUpdates(_0x417b4c,_0x1c1545){return function(_0x1ac44d){if(_0x1ac44d){return _0x1ac44d[_0x9432('0x24')](_0x417b4c)[_0x9432('0x25')](function(_0x3fa877){return _0x3fa877;});}return null;};}function removeEntity(_0x2d024e,_0x3981e3){return function(_0x4d8c07){if(_0x4d8c07){return _0x4d8c07[_0x9432('0x26')]()[_0x9432('0x25')](function(){_0x2d024e[_0x9432('0x1f')](0xcc)[_0x9432('0x19')]();});}};}function handleEntityNotFound(_0x598173,_0x446136){return function(_0x4f931e){if(!_0x4f931e){_0x598173[_0x9432('0x27')](0x194);}return _0x4f931e;};}function handleError(_0x1ac5bc,_0xfc6ec6){_0xfc6ec6=_0xfc6ec6||0x1f4;return function(_0x10a9dc){logger['error'](_0x10a9dc[_0x9432('0x28')]);if(_0x10a9dc[_0x9432('0x29')]){delete _0x10a9dc[_0x9432('0x29')];}_0x1ac5bc[_0x9432('0x1f')](_0xfc6ec6)['send'](_0x10a9dc);};}exports[_0x9432('0x2a')]=function(_0x33c195,_0x2038bf){var _0x42a7fd={},_0x5e8431={},_0x3e642c={'count':0x0,'rows':[]};var _0x66564b=_[_0x9432('0x2b')](db[_0x9432('0x2c')][_0x9432('0x2d')],function(_0x3da176){return{'name':_0x3da176[_0x9432('0x2e')],'type':_0x3da176[_0x9432('0x2f')]['key']};});_0x5e8431[_0x9432('0x30')]=_[_0x9432('0x2b')](_0x66564b,_0x9432('0x29'));_0x5e8431[_0x9432('0x31')]=_['keys'](_0x33c195[_0x9432('0x31')]);_0x5e8431[_0x9432('0x32')]=_[_0x9432('0x33')](_0x5e8431[_0x9432('0x30')],_0x5e8431[_0x9432('0x31')]);_0x42a7fd[_0x9432('0x34')]=_['intersection'](_0x5e8431['model'],qs[_0x9432('0x35')](_0x33c195[_0x9432('0x31')][_0x9432('0x35')]));_0x42a7fd[_0x9432('0x34')]=_0x42a7fd[_0x9432('0x34')][_0x9432('0x36')]?_0x42a7fd[_0x9432('0x34')]:_0x5e8431[_0x9432('0x30')];if(!_0x33c195['query'][_0x9432('0x37')](_0x9432('0x38'))){_0x42a7fd[_0x9432('0x1d')]=qs[_0x9432('0x1d')](_0x33c195[_0x9432('0x31')][_0x9432('0x1d')]);_0x42a7fd[_0x9432('0x1b')]=qs[_0x9432('0x1b')](_0x33c195[_0x9432('0x31')][_0x9432('0x1b')]);}_0x42a7fd['order']=qs['sort'](_0x33c195[_0x9432('0x31')][_0x9432('0x39')]);_0x42a7fd[_0x9432('0x3a')]=qs[_0x9432('0x32')](_[_0x9432('0x3b')](_0x33c195[_0x9432('0x31')],_0x5e8431[_0x9432('0x32')]),_0x66564b);if(_0x33c195[_0x9432('0x31')][_0x9432('0x3c')]){_0x42a7fd['where']=_[_0x9432('0x3d')](_0x42a7fd[_0x9432('0x3a')],{'$or':_['map'](_0x66564b,function(_0x3203ab){if(_0x3203ab[_0x9432('0x2f')]!=='VIRTUAL'){var _0x2c362c={};_0x2c362c[_0x3203ab[_0x9432('0x29')]]={'$like':'%'+_0x33c195['query'][_0x9432('0x3c')]+'%'};return _0x2c362c;}})});}_0x42a7fd=_[_0x9432('0x3d')]({},_0x42a7fd,_0x33c195[_0x9432('0x3e')]);var _0x5d18cc={'where':_0x42a7fd[_0x9432('0x3a')]};return db[_0x9432('0x2c')][_0x9432('0x1e')](_0x5d18cc)[_0x9432('0x25')](function(_0x116a5e){_0x3e642c[_0x9432('0x1e')]=_0x116a5e;if(_0x33c195[_0x9432('0x31')]['includeAll']){_0x42a7fd[_0x9432('0x3f')]=[{'all':!![]}];}return db['SugarcrmConfiguration'][_0x9432('0x40')](_0x42a7fd);})[_0x9432('0x25')](function(_0x2c693c){_0x3e642c[_0x9432('0x41')]=_0x2c693c;return _0x3e642c;})['then'](respondWithFilteredResult(_0x2038bf,_0x42a7fd))['catch'](handleError(_0x2038bf,null));};exports['show']=function(_0x41cdf3,_0x58aa7a){var _0x3f7020={'raw':![],'where':{'id':_0x41cdf3[_0x9432('0x42')]['id']}},_0x404a78={};_0x404a78['model']=_[_0x9432('0x43')](db[_0x9432('0x2c')][_0x9432('0x2d')]);_0x404a78[_0x9432('0x31')]=_[_0x9432('0x43')](_0x41cdf3['query']);_0x404a78['filters']=_[_0x9432('0x33')](_0x404a78['model'],_0x404a78['query']);_0x3f7020[_0x9432('0x34')]=_[_0x9432('0x33')](_0x404a78[_0x9432('0x30')],qs[_0x9432('0x35')](_0x41cdf3['query'][_0x9432('0x35')]));_0x3f7020[_0x9432('0x34')]=_0x3f7020[_0x9432('0x34')][_0x9432('0x36')]?_0x3f7020[_0x9432('0x34')]:_0x404a78[_0x9432('0x30')];if(_0x41cdf3[_0x9432('0x31')][_0x9432('0x44')]){_0x3f7020[_0x9432('0x3f')]=[{'all':!![]}];}_0x3f7020=_['merge']({},_0x3f7020,_0x41cdf3[_0x9432('0x3e')]);return db['SugarcrmConfiguration'][_0x9432('0x45')](_0x3f7020)['then'](handleEntityNotFound(_0x58aa7a,null))[_0x9432('0x25')](respondWithResult(_0x58aa7a,null))[_0x9432('0x46')](handleError(_0x58aa7a,null));};exports[_0x9432('0x47')]=function(_0x4f251d,_0x232d74){return db[_0x9432('0x2c')][_0x9432('0x47')](_0x4f251d[_0x9432('0x48')],{})[_0x9432('0x25')](respondWithResult(_0x232d74,0xc9))[_0x9432('0x46')](handleError(_0x232d74,null));};exports[_0x9432('0x24')]=function(_0x4a729b,_0x248a63){if(_0x4a729b[_0x9432('0x48')]['id']){delete _0x4a729b[_0x9432('0x48')]['id'];}return db[_0x9432('0x2c')][_0x9432('0x45')]({'where':{'id':_0x4a729b[_0x9432('0x42')]['id']}})[_0x9432('0x25')](handleEntityNotFound(_0x248a63,null))[_0x9432('0x25')](saveUpdates(_0x4a729b[_0x9432('0x48')],null))[_0x9432('0x25')](respondWithResult(_0x248a63,null))[_0x9432('0x46')](handleError(_0x248a63,null));};exports[_0x9432('0x26')]=function(_0x51d9ed,_0x3239b2){return db[_0x9432('0x2c')]['find']({'where':{'id':_0x51d9ed[_0x9432('0x42')]['id']}})[_0x9432('0x25')](handleEntityNotFound(_0x3239b2,null))['then'](removeEntity(_0x3239b2,null))['catch'](handleError(_0x3239b2,null));};exports[_0x9432('0x49')]=function(_0x4ea5e3,_0x5c8ba6,_0x1938ea){var _0x1e6b79={};var _0x20333e={};var _0x3ee2b9;var _0x5e946b;return db[_0x9432('0x2c')][_0x9432('0x4a')]({'where':{'id':_0x4ea5e3['params']['id']}})['then'](handleEntityNotFound(_0x5c8ba6,null))['then'](function(_0x402064){if(_0x402064){_0x3ee2b9=_0x402064;_0x20333e[_0x9432('0x30')]=_[_0x9432('0x43')](db[_0x9432('0x4b')][_0x9432('0x2d')]);_0x20333e[_0x9432('0x31')]=_[_0x9432('0x43')](_0x4ea5e3[_0x9432('0x31')]);_0x20333e[_0x9432('0x32')]=_[_0x9432('0x33')](_0x20333e['model'],_0x20333e[_0x9432('0x31')]);_0x1e6b79[_0x9432('0x34')]=_[_0x9432('0x33')](_0x20333e['model'],qs[_0x9432('0x35')](_0x4ea5e3['query'][_0x9432('0x35')]));_0x1e6b79[_0x9432('0x34')]=_0x1e6b79[_0x9432('0x34')][_0x9432('0x36')]?_0x1e6b79[_0x9432('0x34')]:_0x20333e[_0x9432('0x30')];_0x1e6b79[_0x9432('0x4c')]=qs[_0x9432('0x39')](_0x4ea5e3['query']['sort']);_0x1e6b79[_0x9432('0x3a')]=qs[_0x9432('0x32')](_[_0x9432('0x3b')](_0x4ea5e3[_0x9432('0x31')],_0x20333e[_0x9432('0x32')]));if(_0x4ea5e3['query']['filter']){_0x1e6b79[_0x9432('0x3a')]=_[_0x9432('0x3d')](_0x1e6b79[_0x9432('0x3a')],{'$or':_['map'](_0x1e6b79[_0x9432('0x34')],function(_0x2b19c7){var _0x35c500={};_0x35c500[_0x2b19c7]={'$like':'%'+_0x4ea5e3[_0x9432('0x31')][_0x9432('0x3c')]+'%'};return _0x35c500;})});}_0x1e6b79=_[_0x9432('0x3d')]({},_0x1e6b79,_0x4ea5e3[_0x9432('0x3e')]);return _0x3ee2b9[_0x9432('0x49')](_0x1e6b79);}})[_0x9432('0x25')](function(_0x60b84e){if(_0x60b84e){_0x5e946b=_0x60b84e['length'];if(!_0x4ea5e3['query'][_0x9432('0x37')](_0x9432('0x38'))){_0x1e6b79['limit']=qs['limit'](_0x4ea5e3['query']['limit']);_0x1e6b79[_0x9432('0x1b')]=qs[_0x9432('0x1b')](_0x4ea5e3[_0x9432('0x31')][_0x9432('0x1b')]);}return _0x3ee2b9[_0x9432('0x49')](_0x1e6b79);}})['then'](function(_0x5a3423){if(_0x5a3423){return _0x5a3423?{'count':_0x5e946b,'rows':_0x5a3423}:null;}})[_0x9432('0x25')](respondWithResult(_0x5c8ba6,null))[_0x9432('0x46')](handleError(_0x5c8ba6,null));};exports[_0x9432('0x4d')]=function(_0x46d957,_0x70a25b,_0x40458a){var _0x4f8de4={};var _0x4a9c54={};var _0x208d86;var _0x1dc24d;return db[_0x9432('0x2c')][_0x9432('0x4a')]({'where':{'id':_0x46d957[_0x9432('0x42')]['id']}})[_0x9432('0x25')](handleEntityNotFound(_0x70a25b,null))['then'](function(_0x3590d1){if(_0x3590d1){_0x208d86=_0x3590d1;_0x4a9c54[_0x9432('0x30')]=_['keys'](db[_0x9432('0x4b')][_0x9432('0x2d')]);_0x4a9c54[_0x9432('0x31')]=_[_0x9432('0x43')](_0x46d957['query']);_0x4a9c54[_0x9432('0x32')]=_[_0x9432('0x33')](_0x4a9c54[_0x9432('0x30')],_0x4a9c54[_0x9432('0x31')]);_0x4f8de4[_0x9432('0x34')]=_[_0x9432('0x33')](_0x4a9c54[_0x9432('0x30')],qs[_0x9432('0x35')](_0x46d957[_0x9432('0x31')]['fields']));_0x4f8de4['attributes']=_0x4f8de4[_0x9432('0x34')][_0x9432('0x36')]?_0x4f8de4[_0x9432('0x34')]:_0x4a9c54[_0x9432('0x30')];_0x4f8de4[_0x9432('0x4c')]=qs[_0x9432('0x39')](_0x46d957[_0x9432('0x31')]['sort']);_0x4f8de4[_0x9432('0x3a')]=qs[_0x9432('0x32')](_[_0x9432('0x3b')](_0x46d957[_0x9432('0x31')],_0x4a9c54['filters']));if(_0x46d957[_0x9432('0x31')]['filter']){_0x4f8de4[_0x9432('0x3a')]=_[_0x9432('0x3d')](_0x4f8de4[_0x9432('0x3a')],{'$or':_[_0x9432('0x2b')](_0x4f8de4[_0x9432('0x34')],function(_0x32e9f4){var _0x2b601a={};_0x2b601a[_0x32e9f4]={'$like':'%'+_0x46d957[_0x9432('0x31')][_0x9432('0x3c')]+'%'};return _0x2b601a;})});}_0x4f8de4=_[_0x9432('0x3d')]({},_0x4f8de4,_0x46d957['options']);return _0x208d86[_0x9432('0x4d')](_0x4f8de4);}})[_0x9432('0x25')](function(_0x1f964c){if(_0x1f964c){_0x1dc24d=_0x1f964c[_0x9432('0x36')];if(!_0x46d957[_0x9432('0x31')]['hasOwnProperty'](_0x9432('0x38'))){_0x4f8de4[_0x9432('0x1d')]=qs['limit'](_0x46d957[_0x9432('0x31')][_0x9432('0x1d')]);_0x4f8de4[_0x9432('0x1b')]=qs['offset'](_0x46d957[_0x9432('0x31')][_0x9432('0x1b')]);}return _0x208d86[_0x9432('0x4d')](_0x4f8de4);}})[_0x9432('0x25')](function(_0x30ea9a){if(_0x30ea9a){return _0x30ea9a?{'count':_0x1dc24d,'rows':_0x30ea9a}:null;}})[_0x9432('0x25')](respondWithResult(_0x70a25b,null))[_0x9432('0x46')](handleError(_0x70a25b,null));};exports[_0x9432('0x4e')]=function(_0x420d78,_0x35b9e6,_0x14523b){var _0x29da8d={};var _0x5efbb2={};var _0x5b2642;var _0x1b6086;return db[_0x9432('0x2c')][_0x9432('0x4a')]({'where':{'id':_0x420d78[_0x9432('0x42')]['id']}})[_0x9432('0x25')](handleEntityNotFound(_0x35b9e6,null))[_0x9432('0x25')](function(_0x4db3fd){if(_0x4db3fd){_0x5b2642=_0x4db3fd;_0x5efbb2[_0x9432('0x30')]=_['keys'](db['SugarcrmField']['rawAttributes']);_0x5efbb2[_0x9432('0x31')]=_[_0x9432('0x43')](_0x420d78[_0x9432('0x31')]);_0x5efbb2[_0x9432('0x32')]=_[_0x9432('0x33')](_0x5efbb2[_0x9432('0x30')],_0x5efbb2['query']);_0x29da8d['attributes']=_[_0x9432('0x33')](_0x5efbb2[_0x9432('0x30')],qs[_0x9432('0x35')](_0x420d78[_0x9432('0x31')][_0x9432('0x35')]));_0x29da8d[_0x9432('0x34')]=_0x29da8d[_0x9432('0x34')]['length']?_0x29da8d[_0x9432('0x34')]:_0x5efbb2['model'];_0x29da8d['order']=qs[_0x9432('0x39')](_0x420d78['query']['sort']);_0x29da8d[_0x9432('0x3a')]=qs[_0x9432('0x32')](_[_0x9432('0x3b')](_0x420d78['query'],_0x5efbb2[_0x9432('0x32')]));if(_0x420d78[_0x9432('0x31')][_0x9432('0x3c')]){_0x29da8d[_0x9432('0x3a')]=_[_0x9432('0x3d')](_0x29da8d[_0x9432('0x3a')],{'$or':_[_0x9432('0x2b')](_0x29da8d[_0x9432('0x34')],function(_0x10332c){var _0x13f992={};_0x13f992[_0x10332c]={'$like':'%'+_0x420d78[_0x9432('0x31')][_0x9432('0x3c')]+'%'};return _0x13f992;})});}_0x29da8d=_[_0x9432('0x3d')]({},_0x29da8d,_0x420d78[_0x9432('0x3e')]);return _0x5b2642[_0x9432('0x4e')](_0x29da8d);}})['then'](function(_0x227e75){if(_0x227e75){_0x1b6086=_0x227e75[_0x9432('0x36')];if(!_0x420d78[_0x9432('0x31')][_0x9432('0x37')](_0x9432('0x38'))){_0x29da8d[_0x9432('0x1d')]=qs['limit'](_0x420d78[_0x9432('0x31')][_0x9432('0x1d')]);_0x29da8d[_0x9432('0x1b')]=qs['offset'](_0x420d78[_0x9432('0x31')][_0x9432('0x1b')]);}return _0x5b2642[_0x9432('0x4e')](_0x29da8d);}})['then'](function(_0x414ae7){if(_0x414ae7){return _0x414ae7?{'count':_0x1b6086,'rows':_0x414ae7}:null;}})[_0x9432('0x25')](respondWithResult(_0x35b9e6,null))[_0x9432('0x46')](handleError(_0x35b9e6,null));};