58 lines
1.5 KiB
PHP
58 lines
1.5 KiB
PHP
<?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;
|
|
|
|
?>
|