<?php
require_once __DIR__.'/auth_guard.php';
include '../config.php';
session_name($CFG->sessionname);
session_start();
if(!isset($_SESSION['usersession'])){
    header("Location: ".$CFG->wwwroot);
}

dbConnect();


    global $link;
    
$sqlusers  = "SELECT
    categoria.nombre
FROM
    categoria
WHERE
    habilitado = 1 AND padre = 0";

$resultados = mysqli_query($link, $sqlusers);
function cleanData(&$str)
  {
    $str = mb_convert_encoding($str , 'UTF-16LE' ,'UTF-8');
    $str = preg_replace("/\t/", "\\t", $str);
    $str = preg_replace("/\r?\n/", "\\n", $str);
    if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';
    
  }


  // filename for download
$filename = "template_asignacion_" . date('Ymd') . ".csv";

header("Content-Disposition: attachment; filename=\"$filename\"");
header("Content-Type: text/csv");
$out = fopen("php://output", 'w');
$flag = false;
    
    $columnas = ['numempl'];
    while ($row = mysqli_fetch_array ($resultados)){
        array_push($columnas,$row['nombre']);
    }
    //$encabezados = ["numempl","Bievennido a bordo","Ciclos Operativos en Estafeta","Punto de Venta","Tu paquete mi paquete"];
    $encabezados = $columnas;
array_walk($encabezados, __NAMESPACE__ . '\cleanData');
fputcsv($out, array_values($encabezados), ',', '"');
//while ($row = mysqli_fetch_array  ($resultados, MYSQLI_NUM)) {
    //array_walk($row, __NAMESPACE__ . '\cleanData');
    //fputcsv($out, array_values($row), ',', '"');
//}
 
 fclose($out);
 exit;

?>