server/api/intZohoConfiguration/intZohoConfiguration.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 _0x4e15=['apply','save','update','then','destroy','sendStatus','stack','name','send','index','map','ZohoConfiguration','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','nolimit','order','where','pick','filter','VIRTUAL','merge','includeAll','include','findAll','rows','catch','show','params','rawAttributes','options','find','create','body','getFields','findOne','ZohoField','sort','hasOwnProperty','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','sox','ejs','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','status','end','undefined','limit','count','offset','set'];(function(_0x4dfd10,_0x3169d5){var _0x267950=function(_0x15b4ae){while(--_0x15b4ae){_0x4dfd10['push'](_0x4dfd10['shift']());}};_0x267950(++_0x3169d5);}(_0x4e15,0x124));var _0x54e1=function(_0x5eeefa,_0x38ee52){_0x5eeefa=_0x5eeefa-0x0;var _0x513b6b=_0x4e15[_0x5eeefa];return _0x513b6b;};'use strict';var emlformat=require(_0x54e1('0x0'));var rimraf=require(_0x54e1('0x1'));var zipdir=require(_0x54e1('0x2'));var jsonpatch=require(_0x54e1('0x3'));var rp=require(_0x54e1('0x4'));var moment=require(_0x54e1('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x54e1('0x6'));var util=require(_0x54e1('0x7'));var path=require('path');var sox=require(_0x54e1('0x8'));var csv=require('to-csv');var ejs=require(_0x54e1('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x54e1('0xa'));var squel=require(_0x54e1('0xb'));var crypto=require(_0x54e1('0xc'));var jsforce=require(_0x54e1('0xd'));var deskjs=require(_0x54e1('0xe'));var toCsv=require(_0x54e1('0xf'));var querystring=require(_0x54e1('0x10'));var Papa=require(_0x54e1('0x11'));var Redis=require(_0x54e1('0x12'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x54e1('0x13'));var logger=require('../../config/logger')(_0x54e1('0x14'));var utils=require(_0x54e1('0x15'));var config=require(_0x54e1('0x16'));var licenseUtil=require(_0x54e1('0x17'));var db=require(_0x54e1('0x18'))['db'];function respondWithStatusCode(_0x5c7166,_0x184899){_0x184899=_0x184899||0xcc;return function(_0x485d1c){if(_0x485d1c){return _0x5c7166['sendStatus'](_0x184899);}return _0x5c7166[_0x54e1('0x19')](_0x184899)[_0x54e1('0x1a')]();};}function respondWithResult(_0x16cad7,_0x2d6a61){_0x2d6a61=_0x2d6a61||0xc8;return function(_0x1db134){if(_0x1db134){return _0x16cad7[_0x54e1('0x19')](_0x2d6a61)['json'](_0x1db134);}};}function respondWithFilteredResult(_0x305b01,_0x49b9b8){return function(_0xc61967){if(_0xc61967){var _0xea0870=typeof _0x49b9b8['offset']===_0x54e1('0x1b')&&typeof _0x49b9b8[_0x54e1('0x1c')]===_0x54e1('0x1b');var _0x4bf773=_0xc61967[_0x54e1('0x1d')];var _0x5a17a1=_0xea0870?0x0:_0x49b9b8[_0x54e1('0x1e')];var _0x55a15c=_0xea0870?_0xc61967[_0x54e1('0x1d')]:_0x49b9b8['offset']+_0x49b9b8[_0x54e1('0x1c')];var _0xeb4e5d;if(_0x55a15c>=_0x4bf773){_0x55a15c=_0x4bf773;_0xeb4e5d=0xc8;}else{_0xeb4e5d=0xce;}_0x305b01[_0x54e1('0x19')](_0xeb4e5d);return _0x305b01[_0x54e1('0x1f')]('Content-Range',_0x5a17a1+'-'+_0x55a15c+'/'+_0x4bf773)['json'](_0xc61967);}return null;};}function patchUpdates(_0x5009db){return function(_0x5c53e0){try{jsonpatch[_0x54e1('0x20')](_0x5c53e0,_0x5009db,!![]);}catch(_0x6dd14d){return BPromise['reject'](_0x6dd14d);}return _0x5c53e0[_0x54e1('0x21')]();};}function saveUpdates(_0x45fce2,_0x3bdbd0){return function(_0x2b42ce){if(_0x2b42ce){return _0x2b42ce[_0x54e1('0x22')](_0x45fce2)[_0x54e1('0x23')](function(_0x47ec56){return _0x47ec56;});}return null;};}function removeEntity(_0x57c385,_0x5095b1){return function(_0x5b6e36){if(_0x5b6e36){return _0x5b6e36[_0x54e1('0x24')]()[_0x54e1('0x23')](function(){_0x57c385[_0x54e1('0x19')](0xcc)[_0x54e1('0x1a')]();});}};}function handleEntityNotFound(_0x450d4f,_0xdd1a3f){return function(_0xcca238){if(!_0xcca238){_0x450d4f[_0x54e1('0x25')](0x194);}return _0xcca238;};}function handleError(_0xe262dd,_0x20c585){_0x20c585=_0x20c585||0x1f4;return function(_0x2901e1){logger['error'](_0x2901e1[_0x54e1('0x26')]);if(_0x2901e1[_0x54e1('0x27')]){delete _0x2901e1['name'];}_0xe262dd[_0x54e1('0x19')](_0x20c585)[_0x54e1('0x28')](_0x2901e1);};}exports[_0x54e1('0x29')]=function(_0x5c2853,_0x505755){var _0x5315ce={},_0x4b6c32={},_0x389e78={'count':0x0,'rows':[]};var _0x5d1189=_[_0x54e1('0x2a')](db[_0x54e1('0x2b')]['rawAttributes'],function(_0x19061c){return{'name':_0x19061c[_0x54e1('0x2c')],'type':_0x19061c[_0x54e1('0x2d')][_0x54e1('0x2e')]};});_0x4b6c32[_0x54e1('0x2f')]=_[_0x54e1('0x2a')](_0x5d1189,_0x54e1('0x27'));_0x4b6c32[_0x54e1('0x30')]=_[_0x54e1('0x31')](_0x5c2853[_0x54e1('0x30')]);_0x4b6c32[_0x54e1('0x32')]=_[_0x54e1('0x33')](_0x4b6c32[_0x54e1('0x2f')],_0x4b6c32['query']);_0x5315ce[_0x54e1('0x34')]=_[_0x54e1('0x33')](_0x4b6c32[_0x54e1('0x2f')],qs[_0x54e1('0x35')](_0x5c2853[_0x54e1('0x30')][_0x54e1('0x35')]));_0x5315ce['attributes']=_0x5315ce['attributes'][_0x54e1('0x36')]?_0x5315ce[_0x54e1('0x34')]:_0x4b6c32['model'];if(!_0x5c2853[_0x54e1('0x30')]['hasOwnProperty'](_0x54e1('0x37'))){_0x5315ce[_0x54e1('0x1c')]=qs[_0x54e1('0x1c')](_0x5c2853[_0x54e1('0x30')]['limit']);_0x5315ce[_0x54e1('0x1e')]=qs[_0x54e1('0x1e')](_0x5c2853[_0x54e1('0x30')][_0x54e1('0x1e')]);}_0x5315ce[_0x54e1('0x38')]=qs['sort'](_0x5c2853[_0x54e1('0x30')]['sort']);_0x5315ce[_0x54e1('0x39')]=qs['filters'](_[_0x54e1('0x3a')](_0x5c2853[_0x54e1('0x30')],_0x4b6c32[_0x54e1('0x32')]),_0x5d1189);if(_0x5c2853['query'][_0x54e1('0x3b')]){_0x5315ce[_0x54e1('0x39')]=_['merge'](_0x5315ce[_0x54e1('0x39')],{'$or':_['map'](_0x5d1189,function(_0x5392ae){if(_0x5392ae['type']!==_0x54e1('0x3c')){var _0x10a16a={};_0x10a16a[_0x5392ae[_0x54e1('0x27')]]={'$like':'%'+_0x5c2853[_0x54e1('0x30')][_0x54e1('0x3b')]+'%'};return _0x10a16a;}})});}_0x5315ce=_[_0x54e1('0x3d')]({},_0x5315ce,_0x5c2853['options']);var _0x5b9044={'where':_0x5315ce[_0x54e1('0x39')]};return db[_0x54e1('0x2b')][_0x54e1('0x1d')](_0x5b9044)[_0x54e1('0x23')](function(_0x50bbad){_0x389e78[_0x54e1('0x1d')]=_0x50bbad;if(_0x5c2853['query'][_0x54e1('0x3e')]){_0x5315ce[_0x54e1('0x3f')]=[{'all':!![]}];}return db[_0x54e1('0x2b')][_0x54e1('0x40')](_0x5315ce);})[_0x54e1('0x23')](function(_0x439127){_0x389e78[_0x54e1('0x41')]=_0x439127;return _0x389e78;})[_0x54e1('0x23')](respondWithFilteredResult(_0x505755,_0x5315ce))[_0x54e1('0x42')](handleError(_0x505755,null));};exports[_0x54e1('0x43')]=function(_0x15e267,_0x4bc2a2){var _0x2aa208={'raw':![],'where':{'id':_0x15e267[_0x54e1('0x44')]['id']}},_0x44a43c={};_0x44a43c[_0x54e1('0x2f')]=_[_0x54e1('0x31')](db[_0x54e1('0x2b')][_0x54e1('0x45')]);_0x44a43c[_0x54e1('0x30')]=_[_0x54e1('0x31')](_0x15e267[_0x54e1('0x30')]);_0x44a43c['filters']=_['intersection'](_0x44a43c[_0x54e1('0x2f')],_0x44a43c[_0x54e1('0x30')]);_0x2aa208[_0x54e1('0x34')]=_['intersection'](_0x44a43c['model'],qs[_0x54e1('0x35')](_0x15e267[_0x54e1('0x30')][_0x54e1('0x35')]));_0x2aa208['attributes']=_0x2aa208[_0x54e1('0x34')][_0x54e1('0x36')]?_0x2aa208[_0x54e1('0x34')]:_0x44a43c[_0x54e1('0x2f')];if(_0x15e267[_0x54e1('0x30')][_0x54e1('0x3e')]){_0x2aa208[_0x54e1('0x3f')]=[{'all':!![]}];}_0x2aa208=_[_0x54e1('0x3d')]({},_0x2aa208,_0x15e267[_0x54e1('0x46')]);return db['ZohoConfiguration'][_0x54e1('0x47')](_0x2aa208)[_0x54e1('0x23')](handleEntityNotFound(_0x4bc2a2,null))[_0x54e1('0x23')](respondWithResult(_0x4bc2a2,null))[_0x54e1('0x42')](handleError(_0x4bc2a2,null));};exports[_0x54e1('0x48')]=function(_0x35833f,_0x2ba3f4){return db[_0x54e1('0x2b')]['create'](_0x35833f[_0x54e1('0x49')],{})[_0x54e1('0x23')](respondWithResult(_0x2ba3f4,0xc9))[_0x54e1('0x42')](handleError(_0x2ba3f4,null));};exports[_0x54e1('0x22')]=function(_0x303be1,_0x31a1dc){if(_0x303be1['body']['id']){delete _0x303be1[_0x54e1('0x49')]['id'];}return db[_0x54e1('0x2b')][_0x54e1('0x47')]({'where':{'id':_0x303be1['params']['id']}})[_0x54e1('0x23')](handleEntityNotFound(_0x31a1dc,null))[_0x54e1('0x23')](saveUpdates(_0x303be1['body'],null))['then'](respondWithResult(_0x31a1dc,null))[_0x54e1('0x42')](handleError(_0x31a1dc,null));};exports[_0x54e1('0x24')]=function(_0x496c9e,_0x400c62){return db[_0x54e1('0x2b')][_0x54e1('0x47')]({'where':{'id':_0x496c9e['params']['id']}})['then'](handleEntityNotFound(_0x400c62,null))[_0x54e1('0x23')](removeEntity(_0x400c62,null))['catch'](handleError(_0x400c62,null));};exports[_0x54e1('0x4a')]=function(_0x426088,_0x58ddb8,_0x218168){var _0x54e6b0={};var _0xbaa2e0={};var _0x1485e1;var _0x5d38bc;return db[_0x54e1('0x2b')][_0x54e1('0x4b')]({'where':{'id':_0x426088[_0x54e1('0x44')]['id']}})[_0x54e1('0x23')](handleEntityNotFound(_0x58ddb8,null))['then'](function(_0x42cb26){if(_0x42cb26){_0x1485e1=_0x42cb26;_0xbaa2e0['model']=_[_0x54e1('0x31')](db[_0x54e1('0x4c')][_0x54e1('0x45')]);_0xbaa2e0[_0x54e1('0x30')]=_['keys'](_0x426088[_0x54e1('0x30')]);_0xbaa2e0[_0x54e1('0x32')]=_[_0x54e1('0x33')](_0xbaa2e0[_0x54e1('0x2f')],_0xbaa2e0[_0x54e1('0x30')]);_0x54e6b0['attributes']=_[_0x54e1('0x33')](_0xbaa2e0['model'],qs[_0x54e1('0x35')](_0x426088[_0x54e1('0x30')][_0x54e1('0x35')]));_0x54e6b0[_0x54e1('0x34')]=_0x54e6b0[_0x54e1('0x34')][_0x54e1('0x36')]?_0x54e6b0[_0x54e1('0x34')]:_0xbaa2e0['model'];_0x54e6b0['order']=qs[_0x54e1('0x4d')](_0x426088['query']['sort']);_0x54e6b0['where']=qs[_0x54e1('0x32')](_[_0x54e1('0x3a')](_0x426088[_0x54e1('0x30')],_0xbaa2e0['filters']));if(_0x426088[_0x54e1('0x30')]['filter']){_0x54e6b0[_0x54e1('0x39')]=_[_0x54e1('0x3d')](_0x54e6b0[_0x54e1('0x39')],{'$or':_[_0x54e1('0x2a')](_0x54e6b0['attributes'],function(_0x5d0b1e){var _0xf0715c={};_0xf0715c[_0x5d0b1e]={'$like':'%'+_0x426088['query'][_0x54e1('0x3b')]+'%'};return _0xf0715c;})});}_0x54e6b0=_['merge']({},_0x54e6b0,_0x426088[_0x54e1('0x46')]);return _0x1485e1[_0x54e1('0x4a')](_0x54e6b0);}})[_0x54e1('0x23')](function(_0x5ccfd3){if(_0x5ccfd3){_0x5d38bc=_0x5ccfd3[_0x54e1('0x36')];if(!_0x426088[_0x54e1('0x30')][_0x54e1('0x4e')]('nolimit')){_0x54e6b0[_0x54e1('0x1c')]=qs[_0x54e1('0x1c')](_0x426088[_0x54e1('0x30')][_0x54e1('0x1c')]);_0x54e6b0[_0x54e1('0x1e')]=qs['offset'](_0x426088[_0x54e1('0x30')][_0x54e1('0x1e')]);}return _0x1485e1[_0x54e1('0x4a')](_0x54e6b0);}})[_0x54e1('0x23')](function(_0x4d11dc){if(_0x4d11dc){return _0x4d11dc?{'count':_0x5d38bc,'rows':_0x4d11dc}:null;}})[_0x54e1('0x23')](respondWithResult(_0x58ddb8,null))['catch'](handleError(_0x58ddb8,null));};exports[_0x54e1('0x4f')]=function(_0xfdba3c,_0x5530f8,_0x3ea2d9){var _0x37d6bd={};var _0x20ea07={};var _0x53ae37;var _0x47185c;return db[_0x54e1('0x2b')][_0x54e1('0x4b')]({'where':{'id':_0xfdba3c[_0x54e1('0x44')]['id']}})['then'](handleEntityNotFound(_0x5530f8,null))['then'](function(_0x206a26){if(_0x206a26){_0x53ae37=_0x206a26;_0x20ea07[_0x54e1('0x2f')]=_[_0x54e1('0x31')](db[_0x54e1('0x4c')][_0x54e1('0x45')]);_0x20ea07['query']=_['keys'](_0xfdba3c[_0x54e1('0x30')]);_0x20ea07['filters']=_[_0x54e1('0x33')](_0x20ea07['model'],_0x20ea07[_0x54e1('0x30')]);_0x37d6bd[_0x54e1('0x34')]=_[_0x54e1('0x33')](_0x20ea07[_0x54e1('0x2f')],qs[_0x54e1('0x35')](_0xfdba3c[_0x54e1('0x30')]['fields']));_0x37d6bd[_0x54e1('0x34')]=_0x37d6bd['attributes']['length']?_0x37d6bd[_0x54e1('0x34')]:_0x20ea07[_0x54e1('0x2f')];_0x37d6bd[_0x54e1('0x38')]=qs[_0x54e1('0x4d')](_0xfdba3c[_0x54e1('0x30')][_0x54e1('0x4d')]);_0x37d6bd['where']=qs[_0x54e1('0x32')](_[_0x54e1('0x3a')](_0xfdba3c[_0x54e1('0x30')],_0x20ea07[_0x54e1('0x32')]));if(_0xfdba3c['query'][_0x54e1('0x3b')]){_0x37d6bd['where']=_[_0x54e1('0x3d')](_0x37d6bd[_0x54e1('0x39')],{'$or':_[_0x54e1('0x2a')](_0x37d6bd['attributes'],function(_0x4c54d0){var _0x5ae987={};_0x5ae987[_0x4c54d0]={'$like':'%'+_0xfdba3c[_0x54e1('0x30')][_0x54e1('0x3b')]+'%'};return _0x5ae987;})});}_0x37d6bd=_[_0x54e1('0x3d')]({},_0x37d6bd,_0xfdba3c[_0x54e1('0x46')]);return _0x53ae37[_0x54e1('0x4f')](_0x37d6bd);}})[_0x54e1('0x23')](function(_0x51d6e6){if(_0x51d6e6){_0x47185c=_0x51d6e6[_0x54e1('0x36')];if(!_0xfdba3c[_0x54e1('0x30')][_0x54e1('0x4e')]('nolimit')){_0x37d6bd['limit']=qs['limit'](_0xfdba3c[_0x54e1('0x30')][_0x54e1('0x1c')]);_0x37d6bd[_0x54e1('0x1e')]=qs[_0x54e1('0x1e')](_0xfdba3c[_0x54e1('0x30')][_0x54e1('0x1e')]);}return _0x53ae37[_0x54e1('0x4f')](_0x37d6bd);}})[_0x54e1('0x23')](function(_0x191ba2){if(_0x191ba2){return _0x191ba2?{'count':_0x47185c,'rows':_0x191ba2}:null;}})[_0x54e1('0x23')](respondWithResult(_0x5530f8,null))[_0x54e1('0x42')](handleError(_0x5530f8,null));};exports[_0x54e1('0x50')]=function(_0x42e00d,_0x86ea96,_0x178e02){var _0x58e05b={};var _0x377f07={};var _0x23cd72;var _0xde8d03;return db[_0x54e1('0x2b')][_0x54e1('0x4b')]({'where':{'id':_0x42e00d[_0x54e1('0x44')]['id']}})[_0x54e1('0x23')](handleEntityNotFound(_0x86ea96,null))[_0x54e1('0x23')](function(_0x17fa5c){if(_0x17fa5c){_0x23cd72=_0x17fa5c;_0x377f07[_0x54e1('0x2f')]=_[_0x54e1('0x31')](db[_0x54e1('0x4c')]['rawAttributes']);_0x377f07['query']=_[_0x54e1('0x31')](_0x42e00d['query']);_0x377f07[_0x54e1('0x32')]=_[_0x54e1('0x33')](_0x377f07[_0x54e1('0x2f')],_0x377f07[_0x54e1('0x30')]);_0x58e05b[_0x54e1('0x34')]=_[_0x54e1('0x33')](_0x377f07[_0x54e1('0x2f')],qs[_0x54e1('0x35')](_0x42e00d[_0x54e1('0x30')][_0x54e1('0x35')]));_0x58e05b['attributes']=_0x58e05b['attributes'][_0x54e1('0x36')]?_0x58e05b['attributes']:_0x377f07[_0x54e1('0x2f')];_0x58e05b[_0x54e1('0x38')]=qs['sort'](_0x42e00d[_0x54e1('0x30')]['sort']);_0x58e05b[_0x54e1('0x39')]=qs[_0x54e1('0x32')](_[_0x54e1('0x3a')](_0x42e00d[_0x54e1('0x30')],_0x377f07['filters']));if(_0x42e00d[_0x54e1('0x30')][_0x54e1('0x3b')]){_0x58e05b[_0x54e1('0x39')]=_['merge'](_0x58e05b['where'],{'$or':_[_0x54e1('0x2a')](_0x58e05b['attributes'],function(_0x23c9a8){var _0x38d709={};_0x38d709[_0x23c9a8]={'$like':'%'+_0x42e00d[_0x54e1('0x30')][_0x54e1('0x3b')]+'%'};return _0x38d709;})});}_0x58e05b=_[_0x54e1('0x3d')]({},_0x58e05b,_0x42e00d['options']);return _0x23cd72['getDescriptions'](_0x58e05b);}})[_0x54e1('0x23')](function(_0x536372){if(_0x536372){_0xde8d03=_0x536372[_0x54e1('0x36')];if(!_0x42e00d['query'][_0x54e1('0x4e')]('nolimit')){_0x58e05b[_0x54e1('0x1c')]=qs['limit'](_0x42e00d[_0x54e1('0x30')][_0x54e1('0x1c')]);_0x58e05b[_0x54e1('0x1e')]=qs[_0x54e1('0x1e')](_0x42e00d[_0x54e1('0x30')][_0x54e1('0x1e')]);}return _0x23cd72[_0x54e1('0x50')](_0x58e05b);}})['then'](function(_0x3d2f5e){if(_0x3d2f5e){return _0x3d2f5e?{'count':_0xde8d03,'rows':_0x3d2f5e}:null;}})['then'](respondWithResult(_0x86ea96,null))[_0x54e1('0x42')](handleError(_0x86ea96,null));};