800fd8df4ea9cc4950eb2762168b8deb41159a5d
[motion2.git] / server / api / intSalesforceConfiguration / intSalesforceConfiguration.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 _0x9936=['save','destroy','sendStatus','stack','name','send','index','map','SalesforceConfiguration','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','merge','options','includeAll','include','findAll','rows','catch','show','params','rawAttributes','find','create','body','update','getFields','pick','filter','getSubjects','SalesforceField','findOne','getDescriptions','html-pdf','eml-format','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','squel','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','jayson/promise','http','then','info','SalesforceConfiguration,\x20%s,\x20%s','request\x20sent','debug','SalesforceConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','message','status','end','json','count','offset','limit','set','Content-Range','apply','reject'];(function(_0x5e29e6,_0x19f937){var _0x42e866=function(_0xfd86f9){while(--_0xfd86f9){_0x5e29e6['push'](_0x5e29e6['shift']());}};_0x42e866(++_0x19f937);}(_0x9936,0x13c));var _0x6993=function(_0x25aaec,_0x159e5b){_0x25aaec=_0x25aaec-0x0;var _0x293c2f=_0x9936[_0x25aaec];return _0x293c2f;};'use strict';var pdf=require(_0x6993('0x0'));var emlformat=require(_0x6993('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x6993('0x2'));var moment=require(_0x6993('0x3'));var BPromise=require(_0x6993('0x4'));var Mustache=require('mustache');var util=require(_0x6993('0x5'));var path=require(_0x6993('0x6'));var sox=require(_0x6993('0x7'));var csv=require(_0x6993('0x8'));var ejs=require(_0x6993('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x6993('0xa'));var crypto=require('crypto');var jsforce=require(_0x6993('0xb'));var deskjs=require(_0x6993('0xc'));var toCsv=require(_0x6993('0x8'));var querystring=require(_0x6993('0xd'));var Papa=require(_0x6993('0xe'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x6993('0xf'));var as=require(_0x6993('0x10'));var hardwareService=require(_0x6993('0x11'));var logger=require(_0x6993('0x12'))(_0x6993('0x13'));var utils=require(_0x6993('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x6993('0x15'));var db=require(_0x6993('0x16'))['db'];var jayson=require(_0x6993('0x17'));var client=jayson['client'][_0x6993('0x18')]({'port':0x232a});function respondWithRpcPromise(_0x2d5224,_0x2104de,_0x3ffede,_0x2b94fd){return new BPromise(function(_0x1b5e2d,_0xbb0f55){var _0x2787e9=_0x2b94fd||client;return _0x2787e9['request'](_0x2d5224,_0x3ffede)[_0x6993('0x19')](function(_0x4ed0c5){logger[_0x6993('0x1a')](_0x6993('0x1b'),_0x2104de,_0x6993('0x1c'));logger[_0x6993('0x1d')](_0x6993('0x1e'),_0x2104de,_0x6993('0x1c'),JSON[_0x6993('0x1f')](_0x4ed0c5));if(_0x4ed0c5[_0x6993('0x20')]){if(_0x4ed0c5[_0x6993('0x20')]['code']===0x1f4){logger[_0x6993('0x20')](_0x6993('0x1b'),_0x2104de,_0x4ed0c5[_0x6993('0x20')][_0x6993('0x21')]);return _0xbb0f55(_0x4ed0c5[_0x6993('0x20')][_0x6993('0x21')]);}logger[_0x6993('0x20')]('SalesforceConfiguration,\x20%s,\x20%s',_0x2104de,_0x4ed0c5['error'][_0x6993('0x21')]);return _0x1b5e2d(_0x4ed0c5[_0x6993('0x20')][_0x6993('0x21')]);}else{logger['info'](_0x6993('0x1b'),_0x2104de,_0x6993('0x1c'));_0x1b5e2d(_0x4ed0c5['result'][_0x6993('0x21')]);}})['catch'](function(_0x476827){logger['error']('SalesforceConfiguration,\x20%s,\x20%s',_0x2104de,_0x476827);_0xbb0f55(_0x476827);});});}function respondWithStatusCode(_0x868019,_0xed5ab6){_0xed5ab6=_0xed5ab6||0xcc;return function(_0x57a83c){if(_0x57a83c){return _0x868019['sendStatus'](_0xed5ab6);}return _0x868019[_0x6993('0x22')](_0xed5ab6)[_0x6993('0x23')]();};}function respondWithResult(_0x140b93,_0x5e299f){_0x5e299f=_0x5e299f||0xc8;return function(_0xf06b59){if(_0xf06b59){return _0x140b93[_0x6993('0x22')](_0x5e299f)[_0x6993('0x24')](_0xf06b59);}};}function respondWithFilteredResult(_0x153f20,_0x3bd24e){return function(_0x21decf){if(_0x21decf){var _0x3c0497=_0x21decf[_0x6993('0x25')],_0x325e53=_0x3bd24e[_0x6993('0x26')],_0x3cdfad=_0x3bd24e['offset']+_0x3bd24e[_0x6993('0x27')],_0x4f2a06;if(_0x3cdfad>=_0x3c0497){_0x3cdfad=_0x3c0497;_0x4f2a06=0xc8;}else{_0x4f2a06=0xce;}_0x153f20[_0x6993('0x22')](_0x4f2a06);return _0x153f20[_0x6993('0x28')](_0x6993('0x29'),_0x325e53+'-'+_0x3cdfad+'/'+_0x3c0497)[_0x6993('0x24')](_0x21decf);}return null;};}function patchUpdates(_0xfa4273){return function(_0x3e71a1){try{jsonpatch[_0x6993('0x2a')](_0x3e71a1,_0xfa4273,!![]);}catch(_0x34228b){return BPromise[_0x6993('0x2b')](_0x34228b);}return _0x3e71a1[_0x6993('0x2c')]();};}function saveUpdates(_0x4c89c8,_0x56cbb9){return function(_0x52ef23){if(_0x52ef23){return _0x52ef23['update'](_0x4c89c8)[_0x6993('0x19')](function(_0x548c83){return _0x548c83;});}return null;};}function removeEntity(_0x1bcdcb,_0x34fc1e){return function(_0x293239){if(_0x293239){return _0x293239[_0x6993('0x2d')]()[_0x6993('0x19')](function(){_0x1bcdcb['status'](0xcc)[_0x6993('0x23')]();});}};}function handleEntityNotFound(_0x1c45a2,_0x4904cc){return function(_0x37460c){if(!_0x37460c){_0x1c45a2[_0x6993('0x2e')](0x194);}return _0x37460c;};}function handleError(_0x446949,_0x3704e1){_0x3704e1=_0x3704e1||0x1f4;return function(_0x986fbf){logger[_0x6993('0x20')](_0x986fbf[_0x6993('0x2f')]);if(_0x986fbf['name']){delete _0x986fbf[_0x6993('0x30')];}_0x446949[_0x6993('0x22')](_0x3704e1)[_0x6993('0x31')](_0x986fbf);};}exports[_0x6993('0x32')]=function(_0x2e6be5,_0x36853a){var _0x1b9093={},_0x145a23={},_0x38c82b={'count':0x0,'rows':[]};var _0x4b5b4d=_[_0x6993('0x33')](db[_0x6993('0x34')]['rawAttributes'],function(_0x2a6d3e){return{'name':_0x2a6d3e[_0x6993('0x35')],'type':_0x2a6d3e[_0x6993('0x36')][_0x6993('0x37')]};});_0x145a23[_0x6993('0x38')]=_[_0x6993('0x33')](_0x4b5b4d,'name');_0x145a23['query']=_[_0x6993('0x39')](_0x2e6be5[_0x6993('0x3a')]);_0x145a23[_0x6993('0x3b')]=_[_0x6993('0x3c')](_0x145a23[_0x6993('0x38')],_0x145a23[_0x6993('0x3a')]);_0x1b9093[_0x6993('0x3d')]=_[_0x6993('0x3c')](_0x145a23[_0x6993('0x38')],qs[_0x6993('0x3e')](_0x2e6be5['query'][_0x6993('0x3e')]));_0x1b9093['attributes']=_0x1b9093['attributes'][_0x6993('0x3f')]?_0x1b9093[_0x6993('0x3d')]:_0x145a23[_0x6993('0x38')];if(!_0x2e6be5[_0x6993('0x3a')][_0x6993('0x40')](_0x6993('0x41'))){_0x1b9093[_0x6993('0x27')]=qs[_0x6993('0x27')](_0x2e6be5[_0x6993('0x3a')]['limit']);_0x1b9093[_0x6993('0x26')]=qs[_0x6993('0x26')](_0x2e6be5[_0x6993('0x3a')][_0x6993('0x26')]);}_0x1b9093[_0x6993('0x42')]=qs[_0x6993('0x43')](_0x2e6be5[_0x6993('0x3a')][_0x6993('0x43')]);_0x1b9093[_0x6993('0x44')]=qs[_0x6993('0x3b')](_['pick'](_0x2e6be5[_0x6993('0x3a')],_0x145a23['filters']),_0x4b5b4d);if(_0x2e6be5['query']['filter']){_0x1b9093[_0x6993('0x44')]=_[_0x6993('0x45')](_0x1b9093['where'],{'$or':_[_0x6993('0x33')](_0x4b5b4d,function(_0x5d9f1d){if(_0x5d9f1d[_0x6993('0x36')]!=='VIRTUAL'){var _0x59ac9c={};_0x59ac9c[_0x5d9f1d[_0x6993('0x30')]]={'$like':'%'+_0x2e6be5[_0x6993('0x3a')]['filter']+'%'};return _0x59ac9c;}})});}_0x1b9093=_[_0x6993('0x45')]({},_0x1b9093,_0x2e6be5[_0x6993('0x46')]);var _0x107fb9={'where':_0x1b9093[_0x6993('0x44')]};return db[_0x6993('0x34')][_0x6993('0x25')](_0x107fb9)[_0x6993('0x19')](function(_0x12919d){_0x38c82b['count']=_0x12919d;if(_0x2e6be5[_0x6993('0x3a')][_0x6993('0x47')]){_0x1b9093[_0x6993('0x48')]=[{'all':!![]}];}return db[_0x6993('0x34')][_0x6993('0x49')](_0x1b9093);})['then'](function(_0x28f24a){_0x38c82b[_0x6993('0x4a')]=_0x28f24a;return _0x38c82b;})[_0x6993('0x19')](respondWithFilteredResult(_0x36853a,_0x1b9093))[_0x6993('0x4b')](handleError(_0x36853a,null));};exports[_0x6993('0x4c')]=function(_0x5b3d4b,_0x47a0d0){var _0x4f532e={'raw':![],'where':{'id':_0x5b3d4b[_0x6993('0x4d')]['id']}},_0x36042b={};_0x36042b[_0x6993('0x38')]=_['keys'](db[_0x6993('0x34')][_0x6993('0x4e')]);_0x36042b[_0x6993('0x3a')]=_[_0x6993('0x39')](_0x5b3d4b[_0x6993('0x3a')]);_0x36042b[_0x6993('0x3b')]=_[_0x6993('0x3c')](_0x36042b[_0x6993('0x38')],_0x36042b[_0x6993('0x3a')]);_0x4f532e['attributes']=_[_0x6993('0x3c')](_0x36042b['model'],qs[_0x6993('0x3e')](_0x5b3d4b[_0x6993('0x3a')][_0x6993('0x3e')]));_0x4f532e[_0x6993('0x3d')]=_0x4f532e[_0x6993('0x3d')][_0x6993('0x3f')]?_0x4f532e[_0x6993('0x3d')]:_0x36042b[_0x6993('0x38')];if(_0x5b3d4b[_0x6993('0x3a')][_0x6993('0x47')]){_0x4f532e[_0x6993('0x48')]=[{'all':!![]}];}_0x4f532e=_[_0x6993('0x45')]({},_0x4f532e,_0x5b3d4b[_0x6993('0x46')]);return db[_0x6993('0x34')][_0x6993('0x4f')](_0x4f532e)[_0x6993('0x19')](handleEntityNotFound(_0x47a0d0,null))[_0x6993('0x19')](respondWithResult(_0x47a0d0,null))[_0x6993('0x4b')](handleError(_0x47a0d0,null));};exports[_0x6993('0x50')]=function(_0x18f296,_0x54674f){return db[_0x6993('0x34')][_0x6993('0x50')](_0x18f296[_0x6993('0x51')],{})[_0x6993('0x19')](respondWithResult(_0x54674f,0xc9))[_0x6993('0x4b')](handleError(_0x54674f,null));};exports[_0x6993('0x52')]=function(_0x17915c,_0x347e57){if(_0x17915c[_0x6993('0x51')]['id']){delete _0x17915c[_0x6993('0x51')]['id'];}return db['SalesforceConfiguration']['find']({'where':{'id':_0x17915c[_0x6993('0x4d')]['id']}})[_0x6993('0x19')](handleEntityNotFound(_0x347e57,null))[_0x6993('0x19')](saveUpdates(_0x17915c[_0x6993('0x51')],null))['then'](respondWithResult(_0x347e57,null))['catch'](handleError(_0x347e57,null));};exports['destroy']=function(_0x355de4,_0x2f2b0b){return db[_0x6993('0x34')]['find']({'where':{'id':_0x355de4[_0x6993('0x4d')]['id']}})[_0x6993('0x19')](handleEntityNotFound(_0x2f2b0b,null))[_0x6993('0x19')](removeEntity(_0x2f2b0b,null))[_0x6993('0x4b')](handleError(_0x2f2b0b,null));};exports[_0x6993('0x53')]=function(_0x52c4c1,_0x1e3815,_0x2a6358){var _0x5d0d5b={};var _0x5c804a={};var _0x3ebcc0;var _0x192489;return db[_0x6993('0x34')]['findOne']({'where':{'id':_0x52c4c1['params']['id']}})[_0x6993('0x19')](handleEntityNotFound(_0x1e3815,null))[_0x6993('0x19')](function(_0x5ac7c1){if(_0x5ac7c1){_0x3ebcc0=_0x5ac7c1;_0x5c804a[_0x6993('0x38')]=_[_0x6993('0x39')](db['SalesforceField'][_0x6993('0x4e')]);_0x5c804a[_0x6993('0x3a')]=_[_0x6993('0x39')](_0x52c4c1['query']);_0x5c804a[_0x6993('0x3b')]=_[_0x6993('0x3c')](_0x5c804a[_0x6993('0x38')],_0x5c804a[_0x6993('0x3a')]);_0x5d0d5b[_0x6993('0x3d')]=_[_0x6993('0x3c')](_0x5c804a[_0x6993('0x38')],qs[_0x6993('0x3e')](_0x52c4c1[_0x6993('0x3a')][_0x6993('0x3e')]));_0x5d0d5b[_0x6993('0x3d')]=_0x5d0d5b[_0x6993('0x3d')][_0x6993('0x3f')]?_0x5d0d5b[_0x6993('0x3d')]:_0x5c804a[_0x6993('0x38')];_0x5d0d5b['order']=qs[_0x6993('0x43')](_0x52c4c1[_0x6993('0x3a')][_0x6993('0x43')]);_0x5d0d5b[_0x6993('0x44')]=qs[_0x6993('0x3b')](_[_0x6993('0x54')](_0x52c4c1[_0x6993('0x3a')],_0x5c804a[_0x6993('0x3b')]));if(_0x52c4c1[_0x6993('0x3a')][_0x6993('0x55')]){_0x5d0d5b['where']=_[_0x6993('0x45')](_0x5d0d5b[_0x6993('0x44')],{'$or':_[_0x6993('0x33')](_0x5d0d5b[_0x6993('0x3d')],function(_0x33be7e){var _0x137dc2={};_0x137dc2[_0x33be7e]={'$like':'%'+_0x52c4c1[_0x6993('0x3a')][_0x6993('0x55')]+'%'};return _0x137dc2;})});}_0x5d0d5b=_['merge']({},_0x5d0d5b,_0x52c4c1['options']);return _0x3ebcc0[_0x6993('0x53')](_0x5d0d5b);}})['then'](function(_0x22982d){if(_0x22982d){_0x192489=_0x22982d[_0x6993('0x3f')];if(!_0x52c4c1[_0x6993('0x3a')][_0x6993('0x40')](_0x6993('0x41'))){_0x5d0d5b['limit']=qs[_0x6993('0x27')](_0x52c4c1[_0x6993('0x3a')][_0x6993('0x27')]);_0x5d0d5b['offset']=qs['offset'](_0x52c4c1[_0x6993('0x3a')][_0x6993('0x26')]);}return _0x3ebcc0[_0x6993('0x53')](_0x5d0d5b);}})[_0x6993('0x19')](function(_0x56e61a){if(_0x56e61a){return _0x56e61a?{'count':_0x192489,'rows':_0x56e61a}:null;}})[_0x6993('0x19')](respondWithResult(_0x1e3815,null))['catch'](handleError(_0x1e3815,null));};exports[_0x6993('0x56')]=function(_0x28103f,_0x394744,_0x2ed897){var _0x4dfe56={};var _0x68f0d1={};var _0x2feb63;var _0x439165;return db[_0x6993('0x34')]['findOne']({'where':{'id':_0x28103f['params']['id']}})[_0x6993('0x19')](handleEntityNotFound(_0x394744,null))['then'](function(_0x4015a1){if(_0x4015a1){_0x2feb63=_0x4015a1;_0x68f0d1['model']=_[_0x6993('0x39')](db[_0x6993('0x57')][_0x6993('0x4e')]);_0x68f0d1[_0x6993('0x3a')]=_[_0x6993('0x39')](_0x28103f[_0x6993('0x3a')]);_0x68f0d1['filters']=_[_0x6993('0x3c')](_0x68f0d1[_0x6993('0x38')],_0x68f0d1[_0x6993('0x3a')]);_0x4dfe56[_0x6993('0x3d')]=_[_0x6993('0x3c')](_0x68f0d1[_0x6993('0x38')],qs[_0x6993('0x3e')](_0x28103f['query']['fields']));_0x4dfe56[_0x6993('0x3d')]=_0x4dfe56[_0x6993('0x3d')][_0x6993('0x3f')]?_0x4dfe56['attributes']:_0x68f0d1[_0x6993('0x38')];_0x4dfe56[_0x6993('0x42')]=qs[_0x6993('0x43')](_0x28103f[_0x6993('0x3a')]['sort']);_0x4dfe56['where']=qs['filters'](_[_0x6993('0x54')](_0x28103f['query'],_0x68f0d1[_0x6993('0x3b')]));if(_0x28103f[_0x6993('0x3a')][_0x6993('0x55')]){_0x4dfe56[_0x6993('0x44')]=_[_0x6993('0x45')](_0x4dfe56[_0x6993('0x44')],{'$or':_[_0x6993('0x33')](_0x4dfe56[_0x6993('0x3d')],function(_0x5ed6bb){var _0x2c0388={};_0x2c0388[_0x5ed6bb]={'$like':'%'+_0x28103f[_0x6993('0x3a')][_0x6993('0x55')]+'%'};return _0x2c0388;})});}_0x4dfe56=_[_0x6993('0x45')]({},_0x4dfe56,_0x28103f['options']);return _0x2feb63[_0x6993('0x56')](_0x4dfe56);}})[_0x6993('0x19')](function(_0x292b70){if(_0x292b70){_0x439165=_0x292b70['length'];if(!_0x28103f[_0x6993('0x3a')][_0x6993('0x40')](_0x6993('0x41'))){_0x4dfe56['limit']=qs[_0x6993('0x27')](_0x28103f[_0x6993('0x3a')][_0x6993('0x27')]);_0x4dfe56['offset']=qs[_0x6993('0x26')](_0x28103f[_0x6993('0x3a')][_0x6993('0x26')]);}return _0x2feb63[_0x6993('0x56')](_0x4dfe56);}})[_0x6993('0x19')](function(_0x2ec97b){if(_0x2ec97b){return _0x2ec97b?{'count':_0x439165,'rows':_0x2ec97b}:null;}})[_0x6993('0x19')](respondWithResult(_0x394744,null))[_0x6993('0x4b')](handleError(_0x394744,null));};exports['getDescriptions']=function(_0x3042a5,_0x33b6e0,_0x22e1d8){var _0x108457={};var _0x358ca9={};var _0x29bebd;var _0x3da67f;return db[_0x6993('0x34')][_0x6993('0x58')]({'where':{'id':_0x3042a5['params']['id']}})['then'](handleEntityNotFound(_0x33b6e0,null))['then'](function(_0xc43757){if(_0xc43757){_0x29bebd=_0xc43757;_0x358ca9[_0x6993('0x38')]=_['keys'](db[_0x6993('0x57')]['rawAttributes']);_0x358ca9[_0x6993('0x3a')]=_['keys'](_0x3042a5[_0x6993('0x3a')]);_0x358ca9[_0x6993('0x3b')]=_[_0x6993('0x3c')](_0x358ca9[_0x6993('0x38')],_0x358ca9[_0x6993('0x3a')]);_0x108457[_0x6993('0x3d')]=_['intersection'](_0x358ca9['model'],qs[_0x6993('0x3e')](_0x3042a5[_0x6993('0x3a')][_0x6993('0x3e')]));_0x108457[_0x6993('0x3d')]=_0x108457[_0x6993('0x3d')][_0x6993('0x3f')]?_0x108457[_0x6993('0x3d')]:_0x358ca9[_0x6993('0x38')];_0x108457['order']=qs['sort'](_0x3042a5['query'][_0x6993('0x43')]);_0x108457[_0x6993('0x44')]=qs[_0x6993('0x3b')](_['pick'](_0x3042a5['query'],_0x358ca9['filters']));if(_0x3042a5['query'][_0x6993('0x55')]){_0x108457[_0x6993('0x44')]=_[_0x6993('0x45')](_0x108457[_0x6993('0x44')],{'$or':_['map'](_0x108457['attributes'],function(_0x2d9c09){var _0x3e529f={};_0x3e529f[_0x2d9c09]={'$like':'%'+_0x3042a5[_0x6993('0x3a')][_0x6993('0x55')]+'%'};return _0x3e529f;})});}_0x108457=_['merge']({},_0x108457,_0x3042a5[_0x6993('0x46')]);return _0x29bebd[_0x6993('0x59')](_0x108457);}})[_0x6993('0x19')](function(_0x31f203){if(_0x31f203){_0x3da67f=_0x31f203[_0x6993('0x3f')];if(!_0x3042a5[_0x6993('0x3a')][_0x6993('0x40')](_0x6993('0x41'))){_0x108457['limit']=qs[_0x6993('0x27')](_0x3042a5['query'][_0x6993('0x27')]);_0x108457['offset']=qs['offset'](_0x3042a5['query']['offset']);}return _0x29bebd[_0x6993('0x59')](_0x108457);}})[_0x6993('0x19')](function(_0x8fabf4){if(_0x8fabf4){return _0x8fabf4?{'count':_0x3da67f,'rows':_0x8fabf4}:null;}})[_0x6993('0x19')](respondWithResult(_0x33b6e0,null))['catch'](handleError(_0x33b6e0,null));};