Backend.gs

// Backend.gs - Supporting functions for UI and report execution

// Show the main sidebar (modern interface)
function showSidebar() {
  try {
    var html = HtmlService.createHtmlOutputFromFile('Sidebar')
      .setTitle('GA4 Analytics Connector')
      .setWidth(320);
    SpreadsheetApp.getUi().showSidebar(html);
    return { success: true };
  } catch (error) {
    Logger.log('Error showing sidebar: ' + error.toString());
    throw error;
  }
}

// Show the report builder modal
function showReportBuilder(existingReport) {
  try {
    var html = HtmlService.createHtmlOutputFromFile('ReportBuilder')
      .setTitle('GA4 Analytics Import')
      .setWidth(1400)  // Wider for better layout
      .setHeight(820); // Slightly taller but constrained
    
    SpreadsheetApp.getUi().showModalDialog(html, 'GA4 Analytics Import');
    return { success: true };
  } catch (error) {
    Logger.log('Error showing report builder: ' + error.toString());
    return { success: false, error: error.toString() };
  }
}


function getAuthUrl() {
  return getService().getAuthorizationUrl();
}

function isAuthorized() {
  var service = getService();
  return service && service.hasAccess();
}

function disconnectService() {
  var service = getService();
  if (service) service.reset();
  return "Disconnected";
}

function executeReportConfig(config) {
  try {
    // Validate configuration
    var validation = validateReportConfiguration(config);
    if (!validation.isValid) {
      return {
        success: false,
        error: validation.errors.join(', ')
      };
    }
    
    // Check sync limit
    var usageData = getUserUsageData();
    if (usageData.count >= usageData.limit) {
      return {
        success: false,
        error: 'Monthly sync limit exceeded',
        requiresUpgrade: true
      };
    }
    
    // Execute report
    return executeReport({
      name: config.name,
      propertyId: config.propertyId,
      dimensions: config.dimensions,
      metrics: config.metrics,
      dateRange: config.dateRange,
      limit: config.limit
    });
    
  } catch (error) {
    Logger.log('Error executing report config: ' + error.toString());
    return {
      success: false,
      error: error.toString()
    };
  }
}

// Get popular report template for saving
function getPopularReportTemplate(reportId) {
  try {
    var popularReports = getPopularReports();
    var report = null;
    
    // ES5 compatible find
    for (var i = 0; i < popularReports.length; i++) {
      if (popularReports[i].id === reportId) {
        report = popularReports[i];
        break;
      }
    }
    
    if (!report) {
      return {
        success: false,
        error: 'Popular report not found'
      };
    }
    
    // For popular reports, we need to get the user's default property
    var properties = listGA4Properties();
    if (!properties.success || properties.properties.length === 0) {
      return {
        success: false,
        error: 'No GA4 properties available'
      };
    }
    
    // Use the first available property
    report.propertyId = properties.properties[0].name.replace('properties/', '');
    
    return {
      success: true,
      report: report
    };
  } catch (error) {
    Logger.log('Error getting popular report template: ' + error.toString());
    return {
      success: false,
      error: error.toString()
    };
  }
}

// Usage tracking and billing
function initiateUpgradeFlow() {
  try {
    // For Phase 2: Integrate with Stripe
    // For now, show information dialog
    var ui = SpreadsheetApp.getUi();
    var response = ui.alert(
      'Upgrade to Pro',
      'Upgrade to Pro for unlimited syncs and advanced features!\n\n' +
      '• Unlimited monthly syncs\n' +
      '• Advanced scheduling\n' +
      '• Priority support\n' +
      '• Custom report templates\n\n' +
      'Contact us at support@your-domain.com to upgrade.',
      ui.ButtonSet.OK
    );
    
    return {
      success: true,
      message: 'Upgrade information shown'
    };
    
  } catch (error) {
    Logger.log('Error initiating upgrade: ' + error.toString());
    return {
      success: false,
      error: error.toString()
    };
  }
}



// Utility functions for UI
function formatDate(date, format) {
  try {
    format = format || 'yyyy-MM-dd';
    return Utilities.formatDate(new Date(date), Session.getScriptTimeZone(), format);
  } catch (error) {
    return date;
  }
}

function formatNumber(num, decimals) {
  try {
    decimals = decimals || 0;
    return parseFloat(num).toFixed(decimals);
  } catch (error) {
    return num;
  }
}


// Enhanced error handling and user feedback
function handleUserError(error, context) {
  var errorMessage = '';
  var suggestions = [];
  
  if (error.toString().includes('PERMISSION_DENIED')) {
    errorMessage = 'Permission denied. Please check your Google Analytics access.';
    suggestions.push('Verify you have access to the selected GA4 property');
    suggestions.push('Try disconnecting and reconnecting your account');
  } else if (error.toString().includes('QUOTA_EXCEEDED')) {
    errorMessage = 'API quota exceeded. Please try again later.';
    suggestions.push('Wait a few minutes before trying again');
    suggestions.push('Consider reducing the date range or row limit');
  } else if (error.toString().includes('INVALID_ARGUMENT')) {
    errorMessage = 'Invalid report configuration.';
    suggestions.push('Check your selected dimensions and metrics');
    suggestions.push('Ensure your date range is valid');
  } else {
    errorMessage = 'An unexpected error occurred.';
    suggestions.push('Try refreshing the add-on');
    suggestions.push('Contact support if the issue persists');
  }
  
  return {
    error: errorMessage,
    suggestions: suggestions,
    context: context,
    timestamp: new Date().toISOString()
  };
}


// Health check and diagnostics
function performHealthCheck() {
  var checks = {};
  
  try {
    // Check authentication
    var authResult = checkAuthenticationStatus();
    checks.authentication = {
      status: authResult.isConnected ? 'healthy' : 'error',
      details: authResult
    };
    
    // Check GA4 API access
    var gaResult = testGA4Connection();
    checks.ga4_api = {
      status: gaResult.success ? 'healthy' : 'error',
      details: gaResult
    };
    
    
    // Check user data
    if (authResult.isConnected) {
      try {
        var userData = getUserUsageData();
        checks.user_data = {
          status: 'healthy',
          details: userData
        };
      } catch (userError) {
        checks.user_data = {
          status: 'error',
          details: { error: userError.toString() }
        };
      }
    }
    
    // Calculate overall status (ES5 compatible)
    var overallStatus = 'healthy';
    for (var checkName in checks) {
      if (checks.hasOwnProperty(checkName) && checks[checkName].status !== 'healthy') {
        overallStatus = 'degraded';
        break;
      }
    }
    
    return {
      success: true,
      timestamp: new Date().toISOString(),
      checks: checks,
      overall_status: overallStatus
    };
    
  } catch (error) {
    Logger.log('Error performing health check: ' + error.toString());
    return {
      success: false,
      error: error.toString(),
      timestamp: new Date().toISOString()
    };
  }
}