server/api/intFreshsalesConfiguration/intFreshsalesConfiguration.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 _0x3c86=['mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','sendStatus','status','end','offset','undefined','limit','count','Content-Range','json','reject','save','update','then','destroy','error','stack','name','send','index','map','FreshsalesConfiguration','rawAttributes','fieldName','type','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','include','rows','catch','show','params','keys','length','includeAll','find','create','body','FreshsalesField','getSubjects','getDescriptions','getFields','findOne','fast-json-patch','request-promise'];(function(_0x198446,_0x119c8f){var _0x38d7b7=function(_0x293752){while(--_0x293752){_0x198446['push'](_0x198446['shift']());}};_0x38d7b7(++_0x119c8f);}(_0x3c86,0x9a));var _0x63c8=function(_0x13d5bc,_0x3fce3c){_0x13d5bc=_0x13d5bc-0x0;var _0x4b8a40=_0x3c86[_0x13d5bc];return _0x4b8a40;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x63c8('0x0'));var rp=require(_0x63c8('0x1'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x63c8('0x2'));var util=require(_0x63c8('0x3'));var path=require(_0x63c8('0x4'));var sox=require(_0x63c8('0x5'));var csv=require(_0x63c8('0x6'));var ejs=require(_0x63c8('0x7'));var fs=require('fs');var fs_extra=require(_0x63c8('0x8'));var _=require('lodash');var squel=require(_0x63c8('0x9'));var crypto=require(_0x63c8('0xa'));var jsforce=require(_0x63c8('0xb'));var deskjs=require(_0x63c8('0xc'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x63c8('0xd'));var Redis=require(_0x63c8('0xe'));var authService=require(_0x63c8('0xf'));var qs=require(_0x63c8('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x63c8('0x11'));var logger=require(_0x63c8('0x12'))(_0x63c8('0x13'));var utils=require(_0x63c8('0x14'));var config=require(_0x63c8('0x15'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2446f8,_0x3ef223){_0x3ef223=_0x3ef223||0xcc;return function(_0x10249c){if(_0x10249c){return _0x2446f8[_0x63c8('0x16')](_0x3ef223);}return _0x2446f8[_0x63c8('0x17')](_0x3ef223)[_0x63c8('0x18')]();};}function respondWithResult(_0x3e1efa,_0x4232b4){_0x4232b4=_0x4232b4||0xc8;return function(_0x1e97de){if(_0x1e97de){return _0x3e1efa[_0x63c8('0x17')](_0x4232b4)['json'](_0x1e97de);}};}function respondWithFilteredResult(_0x3305a9,_0x2de327){return function(_0x36d1a8){if(_0x36d1a8){var _0x651389=typeof _0x2de327[_0x63c8('0x19')]===_0x63c8('0x1a')&&typeof _0x2de327[_0x63c8('0x1b')]===_0x63c8('0x1a');var _0x459c86=_0x36d1a8[_0x63c8('0x1c')];var _0x10ac4a=_0x651389?0x0:_0x2de327[_0x63c8('0x19')];var _0x45b265=_0x651389?_0x36d1a8[_0x63c8('0x1c')]:_0x2de327[_0x63c8('0x19')]+_0x2de327[_0x63c8('0x1b')];var _0xd6d52f;if(_0x45b265>=_0x459c86){_0x45b265=_0x459c86;_0xd6d52f=0xc8;}else{_0xd6d52f=0xce;}_0x3305a9[_0x63c8('0x17')](_0xd6d52f);return _0x3305a9['set'](_0x63c8('0x1d'),_0x10ac4a+'-'+_0x45b265+'/'+_0x459c86)[_0x63c8('0x1e')](_0x36d1a8);}return null;};}function patchUpdates(_0x4abdb4){return function(_0x4ad88f){try{jsonpatch['apply'](_0x4ad88f,_0x4abdb4,!![]);}catch(_0x3ea4c7){return BPromise[_0x63c8('0x1f')](_0x3ea4c7);}return _0x4ad88f[_0x63c8('0x20')]();};}function saveUpdates(_0x254bd7,_0x13d620){return function(_0x303bd4){if(_0x303bd4){return _0x303bd4[_0x63c8('0x21')](_0x254bd7)[_0x63c8('0x22')](function(_0x7d97df){return _0x7d97df;});}return null;};}function removeEntity(_0x131530,_0x5598d9){return function(_0x4bccfd){if(_0x4bccfd){return _0x4bccfd[_0x63c8('0x23')]()[_0x63c8('0x22')](function(){_0x131530[_0x63c8('0x17')](0xcc)[_0x63c8('0x18')]();});}};}function handleEntityNotFound(_0x40e6e6,_0xa59cac){return function(_0x3339f4){if(!_0x3339f4){_0x40e6e6['sendStatus'](0x194);}return _0x3339f4;};}function handleError(_0x1ecc29,_0x4680ef){_0x4680ef=_0x4680ef||0x1f4;return function(_0x457ae2){logger[_0x63c8('0x24')](_0x457ae2[_0x63c8('0x25')]);if(_0x457ae2[_0x63c8('0x26')]){delete _0x457ae2['name'];}_0x1ecc29[_0x63c8('0x17')](_0x4680ef)[_0x63c8('0x27')](_0x457ae2);};}exports[_0x63c8('0x28')]=function(_0x387150,_0x1b300a){var _0xf71dfc={},_0x373cef={},_0x3419c3={'count':0x0,'rows':[]};var _0x2573da=_[_0x63c8('0x29')](db[_0x63c8('0x2a')][_0x63c8('0x2b')],function(_0x189020){return{'name':_0x189020[_0x63c8('0x2c')],'type':_0x189020[_0x63c8('0x2d')]['key']};});_0x373cef[_0x63c8('0x2e')]=_[_0x63c8('0x29')](_0x2573da,_0x63c8('0x26'));_0x373cef[_0x63c8('0x2f')]=_['keys'](_0x387150[_0x63c8('0x2f')]);_0x373cef[_0x63c8('0x30')]=_[_0x63c8('0x31')](_0x373cef[_0x63c8('0x2e')],_0x373cef['query']);_0xf71dfc[_0x63c8('0x32')]=_[_0x63c8('0x31')](_0x373cef[_0x63c8('0x2e')],qs[_0x63c8('0x33')](_0x387150[_0x63c8('0x2f')]['fields']));_0xf71dfc['attributes']=_0xf71dfc['attributes']['length']?_0xf71dfc[_0x63c8('0x32')]:_0x373cef[_0x63c8('0x2e')];if(!_0x387150[_0x63c8('0x2f')][_0x63c8('0x34')](_0x63c8('0x35'))){_0xf71dfc[_0x63c8('0x1b')]=qs[_0x63c8('0x1b')](_0x387150[_0x63c8('0x2f')]['limit']);_0xf71dfc[_0x63c8('0x19')]=qs[_0x63c8('0x19')](_0x387150[_0x63c8('0x2f')]['offset']);}_0xf71dfc[_0x63c8('0x36')]=qs['sort'](_0x387150['query'][_0x63c8('0x37')]);_0xf71dfc['where']=qs[_0x63c8('0x30')](_[_0x63c8('0x38')](_0x387150[_0x63c8('0x2f')],_0x373cef[_0x63c8('0x30')]),_0x2573da);if(_0x387150['query'][_0x63c8('0x39')]){_0xf71dfc[_0x63c8('0x3a')]=_[_0x63c8('0x3b')](_0xf71dfc[_0x63c8('0x3a')],{'$or':_[_0x63c8('0x29')](_0x2573da,function(_0x2adf5){if(_0x2adf5[_0x63c8('0x2d')]!==_0x63c8('0x3c')){var _0x3aead5={};_0x3aead5[_0x2adf5['name']]={'$like':'%'+_0x387150[_0x63c8('0x2f')][_0x63c8('0x39')]+'%'};return _0x3aead5;}})});}_0xf71dfc=_[_0x63c8('0x3b')]({},_0xf71dfc,_0x387150[_0x63c8('0x3d')]);var _0x2cd375={'where':_0xf71dfc[_0x63c8('0x3a')]};return db['FreshsalesConfiguration'][_0x63c8('0x1c')](_0x2cd375)[_0x63c8('0x22')](function(_0x47f0d2){_0x3419c3['count']=_0x47f0d2;if(_0x387150['query']['includeAll']){_0xf71dfc[_0x63c8('0x3e')]=[{'all':!![]}];}return db[_0x63c8('0x2a')]['findAll'](_0xf71dfc);})['then'](function(_0x52fce4){_0x3419c3[_0x63c8('0x3f')]=_0x52fce4;return _0x3419c3;})['then'](respondWithFilteredResult(_0x1b300a,_0xf71dfc))[_0x63c8('0x40')](handleError(_0x1b300a,null));};exports[_0x63c8('0x41')]=function(_0x4265ee,_0x4830f3){var _0x17105f={'raw':![],'where':{'id':_0x4265ee[_0x63c8('0x42')]['id']}},_0x16fd1e={};_0x16fd1e[_0x63c8('0x2e')]=_[_0x63c8('0x43')](db[_0x63c8('0x2a')]['rawAttributes']);_0x16fd1e[_0x63c8('0x2f')]=_[_0x63c8('0x43')](_0x4265ee[_0x63c8('0x2f')]);_0x16fd1e[_0x63c8('0x30')]=_[_0x63c8('0x31')](_0x16fd1e['model'],_0x16fd1e['query']);_0x17105f[_0x63c8('0x32')]=_['intersection'](_0x16fd1e[_0x63c8('0x2e')],qs[_0x63c8('0x33')](_0x4265ee[_0x63c8('0x2f')][_0x63c8('0x33')]));_0x17105f[_0x63c8('0x32')]=_0x17105f[_0x63c8('0x32')][_0x63c8('0x44')]?_0x17105f[_0x63c8('0x32')]:_0x16fd1e[_0x63c8('0x2e')];if(_0x4265ee[_0x63c8('0x2f')][_0x63c8('0x45')]){_0x17105f[_0x63c8('0x3e')]=[{'all':!![]}];}_0x17105f=_['merge']({},_0x17105f,_0x4265ee['options']);return db[_0x63c8('0x2a')][_0x63c8('0x46')](_0x17105f)[_0x63c8('0x22')](handleEntityNotFound(_0x4830f3,null))[_0x63c8('0x22')](respondWithResult(_0x4830f3,null))['catch'](handleError(_0x4830f3,null));};exports['create']=function(_0x326a36,_0x4f55dc){return db[_0x63c8('0x2a')][_0x63c8('0x47')](_0x326a36[_0x63c8('0x48')],{})['then'](respondWithResult(_0x4f55dc,0xc9))[_0x63c8('0x40')](handleError(_0x4f55dc,null));};exports[_0x63c8('0x21')]=function(_0xf4fdd4,_0x5e51e2){if(_0xf4fdd4[_0x63c8('0x48')]['id']){delete _0xf4fdd4['body']['id'];}return db[_0x63c8('0x2a')][_0x63c8('0x46')]({'where':{'id':_0xf4fdd4[_0x63c8('0x42')]['id']}})[_0x63c8('0x22')](handleEntityNotFound(_0x5e51e2,null))[_0x63c8('0x22')](saveUpdates(_0xf4fdd4['body'],null))[_0x63c8('0x22')](respondWithResult(_0x5e51e2,null))[_0x63c8('0x40')](handleError(_0x5e51e2,null));};exports[_0x63c8('0x23')]=function(_0x2c1193,_0x3dad18){return db[_0x63c8('0x2a')][_0x63c8('0x46')]({'where':{'id':_0x2c1193[_0x63c8('0x42')]['id']}})[_0x63c8('0x22')](handleEntityNotFound(_0x3dad18,null))['then'](removeEntity(_0x3dad18,null))[_0x63c8('0x40')](handleError(_0x3dad18,null));};exports['getSubjects']=function(_0x36580a,_0x41695f,_0x5377ad){var _0x24a6bf={};var _0xc93e7c={};var _0x1e6bd4;var _0x4def08;return db['FreshsalesConfiguration']['findOne']({'where':{'id':_0x36580a[_0x63c8('0x42')]['id']}})[_0x63c8('0x22')](handleEntityNotFound(_0x41695f,null))[_0x63c8('0x22')](function(_0x24705d){if(_0x24705d){_0x1e6bd4=_0x24705d;_0xc93e7c[_0x63c8('0x2e')]=_['keys'](db[_0x63c8('0x49')][_0x63c8('0x2b')]);_0xc93e7c['query']=_[_0x63c8('0x43')](_0x36580a['query']);_0xc93e7c[_0x63c8('0x30')]=_[_0x63c8('0x31')](_0xc93e7c[_0x63c8('0x2e')],_0xc93e7c[_0x63c8('0x2f')]);_0x24a6bf['attributes']=_[_0x63c8('0x31')](_0xc93e7c['model'],qs[_0x63c8('0x33')](_0x36580a[_0x63c8('0x2f')][_0x63c8('0x33')]));_0x24a6bf[_0x63c8('0x32')]=_0x24a6bf[_0x63c8('0x32')][_0x63c8('0x44')]?_0x24a6bf[_0x63c8('0x32')]:_0xc93e7c['model'];_0x24a6bf[_0x63c8('0x36')]=qs[_0x63c8('0x37')](_0x36580a[_0x63c8('0x2f')][_0x63c8('0x37')]);_0x24a6bf['where']=qs['filters'](_['pick'](_0x36580a[_0x63c8('0x2f')],_0xc93e7c[_0x63c8('0x30')]));if(_0x36580a[_0x63c8('0x2f')][_0x63c8('0x39')]){_0x24a6bf['where']=_[_0x63c8('0x3b')](_0x24a6bf[_0x63c8('0x3a')],{'$or':_[_0x63c8('0x29')](_0x24a6bf[_0x63c8('0x32')],function(_0x30a6ea){var _0x17311e={};_0x17311e[_0x30a6ea]={'$like':'%'+_0x36580a['query'][_0x63c8('0x39')]+'%'};return _0x17311e;})});}_0x24a6bf=_['merge']({},_0x24a6bf,_0x36580a[_0x63c8('0x3d')]);return _0x1e6bd4[_0x63c8('0x4a')](_0x24a6bf);}})[_0x63c8('0x22')](function(_0x25954c){if(_0x25954c){_0x4def08=_0x25954c['length'];if(!_0x36580a['query'][_0x63c8('0x34')](_0x63c8('0x35'))){_0x24a6bf[_0x63c8('0x1b')]=qs[_0x63c8('0x1b')](_0x36580a[_0x63c8('0x2f')][_0x63c8('0x1b')]);_0x24a6bf[_0x63c8('0x19')]=qs['offset'](_0x36580a[_0x63c8('0x2f')][_0x63c8('0x19')]);}return _0x1e6bd4['getSubjects'](_0x24a6bf);}})[_0x63c8('0x22')](function(_0x53e764){if(_0x53e764){return _0x53e764?{'count':_0x4def08,'rows':_0x53e764}:null;}})[_0x63c8('0x22')](respondWithResult(_0x41695f,null))['catch'](handleError(_0x41695f,null));};exports[_0x63c8('0x4b')]=function(_0x4ea20c,_0x30bae1,_0x1eb9f7){var _0x3a7554={};var _0x343abd={};var _0x59ffdb;var _0x111051;return db[_0x63c8('0x2a')]['findOne']({'where':{'id':_0x4ea20c[_0x63c8('0x42')]['id']}})[_0x63c8('0x22')](handleEntityNotFound(_0x30bae1,null))[_0x63c8('0x22')](function(_0x36d6d9){if(_0x36d6d9){_0x59ffdb=_0x36d6d9;_0x343abd[_0x63c8('0x2e')]=_['keys'](db[_0x63c8('0x49')]['rawAttributes']);_0x343abd[_0x63c8('0x2f')]=_['keys'](_0x4ea20c[_0x63c8('0x2f')]);_0x343abd[_0x63c8('0x30')]=_[_0x63c8('0x31')](_0x343abd[_0x63c8('0x2e')],_0x343abd['query']);_0x3a7554[_0x63c8('0x32')]=_['intersection'](_0x343abd[_0x63c8('0x2e')],qs[_0x63c8('0x33')](_0x4ea20c['query'][_0x63c8('0x33')]));_0x3a7554[_0x63c8('0x32')]=_0x3a7554[_0x63c8('0x32')][_0x63c8('0x44')]?_0x3a7554[_0x63c8('0x32')]:_0x343abd['model'];_0x3a7554['order']=qs[_0x63c8('0x37')](_0x4ea20c[_0x63c8('0x2f')][_0x63c8('0x37')]);_0x3a7554[_0x63c8('0x3a')]=qs[_0x63c8('0x30')](_['pick'](_0x4ea20c[_0x63c8('0x2f')],_0x343abd['filters']));if(_0x4ea20c[_0x63c8('0x2f')][_0x63c8('0x39')]){_0x3a7554[_0x63c8('0x3a')]=_['merge'](_0x3a7554['where'],{'$or':_[_0x63c8('0x29')](_0x3a7554['attributes'],function(_0x3665a3){var _0x440fa2={};_0x440fa2[_0x3665a3]={'$like':'%'+_0x4ea20c['query'][_0x63c8('0x39')]+'%'};return _0x440fa2;})});}_0x3a7554=_[_0x63c8('0x3b')]({},_0x3a7554,_0x4ea20c[_0x63c8('0x3d')]);return _0x59ffdb['getDescriptions'](_0x3a7554);}})[_0x63c8('0x22')](function(_0x2a69a0){if(_0x2a69a0){_0x111051=_0x2a69a0['length'];if(!_0x4ea20c[_0x63c8('0x2f')][_0x63c8('0x34')]('nolimit')){_0x3a7554[_0x63c8('0x1b')]=qs['limit'](_0x4ea20c['query'][_0x63c8('0x1b')]);_0x3a7554[_0x63c8('0x19')]=qs[_0x63c8('0x19')](_0x4ea20c['query'][_0x63c8('0x19')]);}return _0x59ffdb['getDescriptions'](_0x3a7554);}})[_0x63c8('0x22')](function(_0x281b72){if(_0x281b72){return _0x281b72?{'count':_0x111051,'rows':_0x281b72}:null;}})[_0x63c8('0x22')](respondWithResult(_0x30bae1,null))['catch'](handleError(_0x30bae1,null));};exports[_0x63c8('0x4c')]=function(_0x5b750d,_0x31b5f5,_0x5e0482){var _0x3e0e0f={};var _0x55a76f={};var _0x29a29b;var _0x33e9df;return db[_0x63c8('0x2a')][_0x63c8('0x4d')]({'where':{'id':_0x5b750d[_0x63c8('0x42')]['id']}})[_0x63c8('0x22')](handleEntityNotFound(_0x31b5f5,null))[_0x63c8('0x22')](function(_0x3c8cbb){if(_0x3c8cbb){_0x29a29b=_0x3c8cbb;_0x55a76f['model']=_['keys'](db[_0x63c8('0x49')][_0x63c8('0x2b')]);_0x55a76f[_0x63c8('0x2f')]=_[_0x63c8('0x43')](_0x5b750d['query']);_0x55a76f[_0x63c8('0x30')]=_['intersection'](_0x55a76f['model'],_0x55a76f[_0x63c8('0x2f')]);_0x3e0e0f[_0x63c8('0x32')]=_[_0x63c8('0x31')](_0x55a76f[_0x63c8('0x2e')],qs[_0x63c8('0x33')](_0x5b750d[_0x63c8('0x2f')][_0x63c8('0x33')]));_0x3e0e0f[_0x63c8('0x32')]=_0x3e0e0f[_0x63c8('0x32')][_0x63c8('0x44')]?_0x3e0e0f['attributes']:_0x55a76f[_0x63c8('0x2e')];_0x3e0e0f['order']=qs[_0x63c8('0x37')](_0x5b750d[_0x63c8('0x2f')]['sort']);_0x3e0e0f['where']=qs[_0x63c8('0x30')](_['pick'](_0x5b750d[_0x63c8('0x2f')],_0x55a76f[_0x63c8('0x30')]));if(_0x5b750d[_0x63c8('0x2f')][_0x63c8('0x39')]){_0x3e0e0f[_0x63c8('0x3a')]=_[_0x63c8('0x3b')](_0x3e0e0f[_0x63c8('0x3a')],{'$or':_[_0x63c8('0x29')](_0x3e0e0f['attributes'],function(_0x5523f6){var _0x5be434={};_0x5be434[_0x5523f6]={'$like':'%'+_0x5b750d[_0x63c8('0x2f')]['filter']+'%'};return _0x5be434;})});}_0x3e0e0f=_[_0x63c8('0x3b')]({},_0x3e0e0f,_0x5b750d[_0x63c8('0x3d')]);return _0x29a29b['getFields'](_0x3e0e0f);}})['then'](function(_0x562272){if(_0x562272){_0x33e9df=_0x562272['length'];if(!_0x5b750d[_0x63c8('0x2f')][_0x63c8('0x34')](_0x63c8('0x35'))){_0x3e0e0f['limit']=qs[_0x63c8('0x1b')](_0x5b750d['query']['limit']);_0x3e0e0f['offset']=qs[_0x63c8('0x19')](_0x5b750d[_0x63c8('0x2f')][_0x63c8('0x19')]);}return _0x29a29b[_0x63c8('0x4c')](_0x3e0e0f);}})[_0x63c8('0x22')](function(_0x29d90e){if(_0x29d90e){return _0x29d90e?{'count':_0x33e9df,'rows':_0x29d90e}:null;}})[_0x63c8('0x22')](respondWithResult(_0x31b5f5,null))[_0x63c8('0x40')](handleError(_0x31b5f5,null));};