<?php
function generar_contact_excel_page()
{
  //Variables
  $post_type = 'post_contact';

  // Incluir PhpSpreadSheet
  require_once(CBXPHPSPREADSHEET_ROOT_PATH . 'lib/vendor/autoload.php');
  // Crear una instancia del objeto Spreadsheet
  global $wp_filesystem;
  WP_Filesystem();
  $content_directory = $wp_filesystem->wp_content_dir() . 'uploads/excel/';
  $wp_filesystem->mkdir($content_directory);
  $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

  // Eliminar todos los archivos en la carpeta
  $files = glob($content_directory . 'contact*');
  foreach ($files as $file) {
    if (is_file($file)) {
      unlink($file);
    }
  }

  // Obtener los datos del custom post type
  $args = array(
    'post_type' => $post_type,
    'posts_per_page' => -1,
  );
  $query = new WP_Query($args);
  $posts = $query->get_posts();

  // Crear una hoja de cálculo y agregar los datos
  $sheet = $spreadsheet->getActiveSheet();
  $sheet->setCellValue('A1', 'Título');
  $sheet->setCellValue('B1', 'Asunto');
  $sheet->setCellValue('C1', 'Nombre');
  $sheet->setCellValue('D1', 'Correo');
  $sheet->setCellValue('E1', 'Mensaje');


  foreach ($posts as $post_index => $post) {
    $sheet->setCellValue('A' . ($post_index + 2), $post->post_title);
    $lines = explode("\n", $post->post_content);

    foreach ($posts as $post_index => $post) {
      $sheet->setCellValue('A' . ($post_index + 2), $post->post_title);
      $lines = explode("\n", $post->post_content);

      foreach ($lines as $line_index => $line) {
        $parts = explode(':', $line, 2);
        $value = count($parts) === 2 ? trim($parts[1], ";\r"): trim($parts[0], ";\r");
        $column = $line_index + 2;
        $sheet->setCellValueByColumnAndRow($column, ($post_index + 2), $value);
      }
    }
  }

  date_default_timezone_set('America/Mexico_City');
  $filename = 'contact_' . date('Ymd_His',) . '.xlsx';
  $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
  $writer->save($content_directory . $filename);
?>

  <div style="margin: 60px;">
    <a href="<?php echo get_home_url() . '/wp-content/uploads/excel/' . $filename ?>">
      Descargar Contact en Excel
    </a>
  </div>
<?php
}

function agregar_menu_generar_contact_excel()
{
  add_menu_page('Descargar Contact Excel', 'Descargar Contact Excel', 'manage_options', 'generar_contact_excel_page', 'generar_contact_excel_page');
}
add_action('admin_menu', 'agregar_menu_generar_contact_excel');