3ef06cf34ff2c7155232987901c777a6fc75558b
[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 _0xbfb4=['hasOwnProperty','nolimit','sort','filters','pick','where','merge','VIRTUAL','filter','options','includeAll','findAll','rows','show','params','include','find','catch','create','body','destroy','getFields','findOne','SugarcrmField','fields','order','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','end','sendStatus','error','stack','name','send','index','map','SugarcrmConfiguration','rawAttributes','key','model','keys','query','intersection','attributes','length'];(function(_0x32d75d,_0x5b44ea){var _0x19abb5=function(_0x19c779){while(--_0x19c779){_0x32d75d['push'](_0x32d75d['shift']());}};_0x19abb5(++_0x5b44ea);}(_0xbfb4,0x170));var _0x4bfb=function(_0x4bc02b,_0x254107){_0x4bc02b=_0x4bc02b-0x0;var _0xd56bd3=_0xbfb4[_0x4bc02b];return _0xd56bd3;};'use strict';var emlformat=require(_0x4bfb('0x0'));var rimraf=require(_0x4bfb('0x1'));var zipdir=require(_0x4bfb('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x4bfb('0x3'));var moment=require(_0x4bfb('0x4'));var BPromise=require(_0x4bfb('0x5'));var Mustache=require(_0x4bfb('0x6'));var util=require('util');var path=require(_0x4bfb('0x7'));var sox=require(_0x4bfb('0x8'));var csv=require(_0x4bfb('0x9'));var ejs=require(_0x4bfb('0xa'));var fs=require('fs');var fs_extra=require(_0x4bfb('0xb'));var _=require(_0x4bfb('0xc'));var squel=require(_0x4bfb('0xd'));var crypto=require('crypto');var jsforce=require(_0x4bfb('0xe'));var deskjs=require(_0x4bfb('0xf'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x4bfb('0x10'));var Redis=require(_0x4bfb('0x11'));var authService=require(_0x4bfb('0x12'));var qs=require(_0x4bfb('0x13'));var as=require(_0x4bfb('0x14'));var hardwareService=require(_0x4bfb('0x15'));var logger=require(_0x4bfb('0x16'))(_0x4bfb('0x17'));var utils=require(_0x4bfb('0x18'));var config=require(_0x4bfb('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0x4bfb('0x1a'))['db'];function respondWithStatusCode(_0x272a4b,_0x1e3ed1){_0x1e3ed1=_0x1e3ed1||0xcc;return function(_0x27911d){if(_0x27911d){return _0x272a4b['sendStatus'](_0x1e3ed1);}return _0x272a4b[_0x4bfb('0x1b')](_0x1e3ed1)['end']();};}function respondWithResult(_0x43580a,_0xf3afba){_0xf3afba=_0xf3afba||0xc8;return function(_0x58e027){if(_0x58e027){return _0x43580a[_0x4bfb('0x1b')](_0xf3afba)[_0x4bfb('0x1c')](_0x58e027);}};}function respondWithFilteredResult(_0x1ab93f,_0x3e6e82){return function(_0x25dbab){if(_0x25dbab){var _0x30beea=typeof _0x3e6e82[_0x4bfb('0x1d')]===_0x4bfb('0x1e')&&typeof _0x3e6e82[_0x4bfb('0x1f')]==='undefined';var _0x11e73e=_0x25dbab[_0x4bfb('0x20')];var _0x55a3e0=_0x30beea?0x0:_0x3e6e82[_0x4bfb('0x1d')];var _0x4e1899=_0x30beea?_0x25dbab[_0x4bfb('0x20')]:_0x3e6e82['offset']+_0x3e6e82[_0x4bfb('0x1f')];var _0x86a61c;if(_0x4e1899>=_0x11e73e){_0x4e1899=_0x11e73e;_0x86a61c=0xc8;}else{_0x86a61c=0xce;}_0x1ab93f[_0x4bfb('0x1b')](_0x86a61c);return _0x1ab93f[_0x4bfb('0x21')](_0x4bfb('0x22'),_0x55a3e0+'-'+_0x4e1899+'/'+_0x11e73e)[_0x4bfb('0x1c')](_0x25dbab);}return null;};}function patchUpdates(_0x2541c7){return function(_0x349c29){try{jsonpatch[_0x4bfb('0x23')](_0x349c29,_0x2541c7,!![]);}catch(_0x646e24){return BPromise[_0x4bfb('0x24')](_0x646e24);}return _0x349c29[_0x4bfb('0x25')]();};}function saveUpdates(_0x4a5b74,_0x4db481){return function(_0x824aa8){if(_0x824aa8){return _0x824aa8[_0x4bfb('0x26')](_0x4a5b74)[_0x4bfb('0x27')](function(_0x3b0d1f){return _0x3b0d1f;});}return null;};}function removeEntity(_0x58af4e,_0x15184c){return function(_0xba7cfc){if(_0xba7cfc){return _0xba7cfc['destroy']()[_0x4bfb('0x27')](function(){_0x58af4e[_0x4bfb('0x1b')](0xcc)[_0x4bfb('0x28')]();});}};}function handleEntityNotFound(_0xc30732,_0xe8f58d){return function(_0x430f46){if(!_0x430f46){_0xc30732[_0x4bfb('0x29')](0x194);}return _0x430f46;};}function handleError(_0x175065,_0x549d7f){_0x549d7f=_0x549d7f||0x1f4;return function(_0x2576fa){logger[_0x4bfb('0x2a')](_0x2576fa[_0x4bfb('0x2b')]);if(_0x2576fa['name']){delete _0x2576fa[_0x4bfb('0x2c')];}_0x175065[_0x4bfb('0x1b')](_0x549d7f)[_0x4bfb('0x2d')](_0x2576fa);};}exports[_0x4bfb('0x2e')]=function(_0x425753,_0x343ee9){var _0x37f88d={},_0x4d5a99={},_0x44ba0b={'count':0x0,'rows':[]};var _0x58f4c9=_[_0x4bfb('0x2f')](db[_0x4bfb('0x30')][_0x4bfb('0x31')],function(_0x5bc7c1){return{'name':_0x5bc7c1['fieldName'],'type':_0x5bc7c1['type'][_0x4bfb('0x32')]};});_0x4d5a99[_0x4bfb('0x33')]=_['map'](_0x58f4c9,_0x4bfb('0x2c'));_0x4d5a99['query']=_[_0x4bfb('0x34')](_0x425753[_0x4bfb('0x35')]);_0x4d5a99['filters']=_[_0x4bfb('0x36')](_0x4d5a99[_0x4bfb('0x33')],_0x4d5a99[_0x4bfb('0x35')]);_0x37f88d['attributes']=_[_0x4bfb('0x36')](_0x4d5a99[_0x4bfb('0x33')],qs['fields'](_0x425753[_0x4bfb('0x35')]['fields']));_0x37f88d['attributes']=_0x37f88d[_0x4bfb('0x37')][_0x4bfb('0x38')]?_0x37f88d['attributes']:_0x4d5a99[_0x4bfb('0x33')];if(!_0x425753[_0x4bfb('0x35')][_0x4bfb('0x39')](_0x4bfb('0x3a'))){_0x37f88d[_0x4bfb('0x1f')]=qs[_0x4bfb('0x1f')](_0x425753['query'][_0x4bfb('0x1f')]);_0x37f88d['offset']=qs[_0x4bfb('0x1d')](_0x425753[_0x4bfb('0x35')]['offset']);}_0x37f88d['order']=qs[_0x4bfb('0x3b')](_0x425753['query'][_0x4bfb('0x3b')]);_0x37f88d['where']=qs[_0x4bfb('0x3c')](_[_0x4bfb('0x3d')](_0x425753[_0x4bfb('0x35')],_0x4d5a99[_0x4bfb('0x3c')]),_0x58f4c9);if(_0x425753[_0x4bfb('0x35')]['filter']){_0x37f88d[_0x4bfb('0x3e')]=_[_0x4bfb('0x3f')](_0x37f88d['where'],{'$or':_[_0x4bfb('0x2f')](_0x58f4c9,function(_0x2f4a8a){if(_0x2f4a8a['type']!==_0x4bfb('0x40')){var _0x276e4b={};_0x276e4b[_0x2f4a8a[_0x4bfb('0x2c')]]={'$like':'%'+_0x425753[_0x4bfb('0x35')][_0x4bfb('0x41')]+'%'};return _0x276e4b;}})});}_0x37f88d=_[_0x4bfb('0x3f')]({},_0x37f88d,_0x425753[_0x4bfb('0x42')]);var _0x1d1c40={'where':_0x37f88d[_0x4bfb('0x3e')]};return db[_0x4bfb('0x30')][_0x4bfb('0x20')](_0x1d1c40)['then'](function(_0x5c62e3){_0x44ba0b[_0x4bfb('0x20')]=_0x5c62e3;if(_0x425753[_0x4bfb('0x35')][_0x4bfb('0x43')]){_0x37f88d['include']=[{'all':!![]}];}return db[_0x4bfb('0x30')][_0x4bfb('0x44')](_0x37f88d);})['then'](function(_0x1c8e11){_0x44ba0b[_0x4bfb('0x45')]=_0x1c8e11;return _0x44ba0b;})[_0x4bfb('0x27')](respondWithFilteredResult(_0x343ee9,_0x37f88d))['catch'](handleError(_0x343ee9,null));};exports[_0x4bfb('0x46')]=function(_0x472e80,_0x11bc0a){var _0xcf8217={'raw':![],'where':{'id':_0x472e80[_0x4bfb('0x47')]['id']}},_0x3f7b83={};_0x3f7b83[_0x4bfb('0x33')]=_[_0x4bfb('0x34')](db[_0x4bfb('0x30')]['rawAttributes']);_0x3f7b83[_0x4bfb('0x35')]=_[_0x4bfb('0x34')](_0x472e80[_0x4bfb('0x35')]);_0x3f7b83[_0x4bfb('0x3c')]=_[_0x4bfb('0x36')](_0x3f7b83['model'],_0x3f7b83[_0x4bfb('0x35')]);_0xcf8217[_0x4bfb('0x37')]=_['intersection'](_0x3f7b83[_0x4bfb('0x33')],qs['fields'](_0x472e80['query']['fields']));_0xcf8217[_0x4bfb('0x37')]=_0xcf8217[_0x4bfb('0x37')][_0x4bfb('0x38')]?_0xcf8217['attributes']:_0x3f7b83[_0x4bfb('0x33')];if(_0x472e80[_0x4bfb('0x35')][_0x4bfb('0x43')]){_0xcf8217[_0x4bfb('0x48')]=[{'all':!![]}];}_0xcf8217=_['merge']({},_0xcf8217,_0x472e80['options']);return db[_0x4bfb('0x30')][_0x4bfb('0x49')](_0xcf8217)[_0x4bfb('0x27')](handleEntityNotFound(_0x11bc0a,null))['then'](respondWithResult(_0x11bc0a,null))[_0x4bfb('0x4a')](handleError(_0x11bc0a,null));};exports[_0x4bfb('0x4b')]=function(_0x3b2dde,_0x2d7310){return db[_0x4bfb('0x30')]['create'](_0x3b2dde['body'],{})[_0x4bfb('0x27')](respondWithResult(_0x2d7310,0xc9))[_0x4bfb('0x4a')](handleError(_0x2d7310,null));};exports['update']=function(_0x355805,_0x647474){if(_0x355805[_0x4bfb('0x4c')]['id']){delete _0x355805[_0x4bfb('0x4c')]['id'];}return db[_0x4bfb('0x30')][_0x4bfb('0x49')]({'where':{'id':_0x355805[_0x4bfb('0x47')]['id']}})['then'](handleEntityNotFound(_0x647474,null))['then'](saveUpdates(_0x355805[_0x4bfb('0x4c')],null))[_0x4bfb('0x27')](respondWithResult(_0x647474,null))['catch'](handleError(_0x647474,null));};exports[_0x4bfb('0x4d')]=function(_0xa7592b,_0x4fff05){return db[_0x4bfb('0x30')]['find']({'where':{'id':_0xa7592b[_0x4bfb('0x47')]['id']}})[_0x4bfb('0x27')](handleEntityNotFound(_0x4fff05,null))[_0x4bfb('0x27')](removeEntity(_0x4fff05,null))['catch'](handleError(_0x4fff05,null));};exports[_0x4bfb('0x4e')]=function(_0x4f9add,_0x4062de,_0x3dc5a4){var _0x27ae4b={};var _0x53aa5a={};var _0x1fd2ef;var _0x407b7d;return db[_0x4bfb('0x30')][_0x4bfb('0x4f')]({'where':{'id':_0x4f9add[_0x4bfb('0x47')]['id']}})[_0x4bfb('0x27')](handleEntityNotFound(_0x4062de,null))[_0x4bfb('0x27')](function(_0x45758a){if(_0x45758a){_0x1fd2ef=_0x45758a;_0x53aa5a[_0x4bfb('0x33')]=_[_0x4bfb('0x34')](db[_0x4bfb('0x50')][_0x4bfb('0x31')]);_0x53aa5a[_0x4bfb('0x35')]=_[_0x4bfb('0x34')](_0x4f9add['query']);_0x53aa5a[_0x4bfb('0x3c')]=_[_0x4bfb('0x36')](_0x53aa5a['model'],_0x53aa5a['query']);_0x27ae4b['attributes']=_[_0x4bfb('0x36')](_0x53aa5a[_0x4bfb('0x33')],qs[_0x4bfb('0x51')](_0x4f9add[_0x4bfb('0x35')][_0x4bfb('0x51')]));_0x27ae4b[_0x4bfb('0x37')]=_0x27ae4b['attributes'][_0x4bfb('0x38')]?_0x27ae4b[_0x4bfb('0x37')]:_0x53aa5a[_0x4bfb('0x33')];_0x27ae4b[_0x4bfb('0x52')]=qs[_0x4bfb('0x3b')](_0x4f9add['query'][_0x4bfb('0x3b')]);_0x27ae4b[_0x4bfb('0x3e')]=qs[_0x4bfb('0x3c')](_[_0x4bfb('0x3d')](_0x4f9add['query'],_0x53aa5a[_0x4bfb('0x3c')]));if(_0x4f9add[_0x4bfb('0x35')]['filter']){_0x27ae4b[_0x4bfb('0x3e')]=_[_0x4bfb('0x3f')](_0x27ae4b[_0x4bfb('0x3e')],{'$or':_[_0x4bfb('0x2f')](_0x27ae4b[_0x4bfb('0x37')],function(_0x483815){var _0x2ec755={};_0x2ec755[_0x483815]={'$like':'%'+_0x4f9add[_0x4bfb('0x35')][_0x4bfb('0x41')]+'%'};return _0x2ec755;})});}_0x27ae4b=_[_0x4bfb('0x3f')]({},_0x27ae4b,_0x4f9add['options']);return _0x1fd2ef['getFields'](_0x27ae4b);}})[_0x4bfb('0x27')](function(_0x52f10f){if(_0x52f10f){_0x407b7d=_0x52f10f[_0x4bfb('0x38')];if(!_0x4f9add[_0x4bfb('0x35')][_0x4bfb('0x39')]('nolimit')){_0x27ae4b[_0x4bfb('0x1f')]=qs[_0x4bfb('0x1f')](_0x4f9add[_0x4bfb('0x35')][_0x4bfb('0x1f')]);_0x27ae4b[_0x4bfb('0x1d')]=qs[_0x4bfb('0x1d')](_0x4f9add[_0x4bfb('0x35')]['offset']);}return _0x1fd2ef['getFields'](_0x27ae4b);}})[_0x4bfb('0x27')](function(_0x30de67){if(_0x30de67){return _0x30de67?{'count':_0x407b7d,'rows':_0x30de67}:null;}})['then'](respondWithResult(_0x4062de,null))['catch'](handleError(_0x4062de,null));};exports['getSubjects']=function(_0x293540,_0x5b5b71,_0x779f43){var _0x30921d={};var _0x39de89={};var _0x66f7d8;var _0x38dd68;return db[_0x4bfb('0x30')]['findOne']({'where':{'id':_0x293540[_0x4bfb('0x47')]['id']}})[_0x4bfb('0x27')](handleEntityNotFound(_0x5b5b71,null))[_0x4bfb('0x27')](function(_0x4ef9dc){if(_0x4ef9dc){_0x66f7d8=_0x4ef9dc;_0x39de89[_0x4bfb('0x33')]=_[_0x4bfb('0x34')](db[_0x4bfb('0x50')][_0x4bfb('0x31')]);_0x39de89[_0x4bfb('0x35')]=_[_0x4bfb('0x34')](_0x293540['query']);_0x39de89[_0x4bfb('0x3c')]=_[_0x4bfb('0x36')](_0x39de89['model'],_0x39de89['query']);_0x30921d['attributes']=_[_0x4bfb('0x36')](_0x39de89[_0x4bfb('0x33')],qs['fields'](_0x293540[_0x4bfb('0x35')][_0x4bfb('0x51')]));_0x30921d[_0x4bfb('0x37')]=_0x30921d['attributes']['length']?_0x30921d[_0x4bfb('0x37')]:_0x39de89['model'];_0x30921d[_0x4bfb('0x52')]=qs[_0x4bfb('0x3b')](_0x293540[_0x4bfb('0x35')][_0x4bfb('0x3b')]);_0x30921d['where']=qs[_0x4bfb('0x3c')](_[_0x4bfb('0x3d')](_0x293540[_0x4bfb('0x35')],_0x39de89[_0x4bfb('0x3c')]));if(_0x293540['query'][_0x4bfb('0x41')]){_0x30921d[_0x4bfb('0x3e')]=_[_0x4bfb('0x3f')](_0x30921d['where'],{'$or':_[_0x4bfb('0x2f')](_0x30921d[_0x4bfb('0x37')],function(_0x138fb8){var _0x4d3505={};_0x4d3505[_0x138fb8]={'$like':'%'+_0x293540[_0x4bfb('0x35')]['filter']+'%'};return _0x4d3505;})});}_0x30921d=_[_0x4bfb('0x3f')]({},_0x30921d,_0x293540[_0x4bfb('0x42')]);return _0x66f7d8[_0x4bfb('0x53')](_0x30921d);}})[_0x4bfb('0x27')](function(_0x5e0793){if(_0x5e0793){_0x38dd68=_0x5e0793[_0x4bfb('0x38')];if(!_0x293540[_0x4bfb('0x35')][_0x4bfb('0x39')](_0x4bfb('0x3a'))){_0x30921d[_0x4bfb('0x1f')]=qs['limit'](_0x293540[_0x4bfb('0x35')][_0x4bfb('0x1f')]);_0x30921d['offset']=qs['offset'](_0x293540['query'][_0x4bfb('0x1d')]);}return _0x66f7d8[_0x4bfb('0x53')](_0x30921d);}})[_0x4bfb('0x27')](function(_0x5865ec){if(_0x5865ec){return _0x5865ec?{'count':_0x38dd68,'rows':_0x5865ec}:null;}})[_0x4bfb('0x27')](respondWithResult(_0x5b5b71,null))[_0x4bfb('0x4a')](handleError(_0x5b5b71,null));};exports[_0x4bfb('0x54')]=function(_0x23c5d6,_0x14d682,_0x1ccf89){var _0x5985e1={};var _0x2021ca={};var _0x22bc85;var _0x12dfc5;return db[_0x4bfb('0x30')][_0x4bfb('0x4f')]({'where':{'id':_0x23c5d6[_0x4bfb('0x47')]['id']}})[_0x4bfb('0x27')](handleEntityNotFound(_0x14d682,null))['then'](function(_0x45131f){if(_0x45131f){_0x22bc85=_0x45131f;_0x2021ca['model']=_[_0x4bfb('0x34')](db[_0x4bfb('0x50')][_0x4bfb('0x31')]);_0x2021ca[_0x4bfb('0x35')]=_[_0x4bfb('0x34')](_0x23c5d6[_0x4bfb('0x35')]);_0x2021ca[_0x4bfb('0x3c')]=_[_0x4bfb('0x36')](_0x2021ca['model'],_0x2021ca[_0x4bfb('0x35')]);_0x5985e1['attributes']=_[_0x4bfb('0x36')](_0x2021ca[_0x4bfb('0x33')],qs['fields'](_0x23c5d6['query'][_0x4bfb('0x51')]));_0x5985e1[_0x4bfb('0x37')]=_0x5985e1['attributes'][_0x4bfb('0x38')]?_0x5985e1['attributes']:_0x2021ca[_0x4bfb('0x33')];_0x5985e1[_0x4bfb('0x52')]=qs[_0x4bfb('0x3b')](_0x23c5d6[_0x4bfb('0x35')][_0x4bfb('0x3b')]);_0x5985e1[_0x4bfb('0x3e')]=qs[_0x4bfb('0x3c')](_[_0x4bfb('0x3d')](_0x23c5d6[_0x4bfb('0x35')],_0x2021ca['filters']));if(_0x23c5d6['query'][_0x4bfb('0x41')]){_0x5985e1[_0x4bfb('0x3e')]=_[_0x4bfb('0x3f')](_0x5985e1['where'],{'$or':_[_0x4bfb('0x2f')](_0x5985e1['attributes'],function(_0x4f28cc){var _0x509aa0={};_0x509aa0[_0x4f28cc]={'$like':'%'+_0x23c5d6['query']['filter']+'%'};return _0x509aa0;})});}_0x5985e1=_[_0x4bfb('0x3f')]({},_0x5985e1,_0x23c5d6[_0x4bfb('0x42')]);return _0x22bc85['getDescriptions'](_0x5985e1);}})['then'](function(_0x5388f7){if(_0x5388f7){_0x12dfc5=_0x5388f7[_0x4bfb('0x38')];if(!_0x23c5d6[_0x4bfb('0x35')]['hasOwnProperty'](_0x4bfb('0x3a'))){_0x5985e1['limit']=qs['limit'](_0x23c5d6['query'][_0x4bfb('0x1f')]);_0x5985e1[_0x4bfb('0x1d')]=qs[_0x4bfb('0x1d')](_0x23c5d6[_0x4bfb('0x35')][_0x4bfb('0x1d')]);}return _0x22bc85[_0x4bfb('0x54')](_0x5985e1);}})[_0x4bfb('0x27')](function(_0x13c01b){if(_0x13c01b){return _0x13c01b?{'count':_0x12dfc5,'rows':_0x13c01b}:null;}})[_0x4bfb('0x27')](respondWithResult(_0x14d682,null))[_0x4bfb('0x4a')](handleError(_0x14d682,null));};