Пример #1
0
function cloud_export_skebby()
{
    global $wpdb;
    $rows = cloud_lista_ordini();
    $separator = ";";
    $end_line = "\r\n";
    $export = "";
    $export .= "nome" . $separator;
    $export .= "cognome" . $separator;
    $export .= "soprannome" . $separator;
    $export .= "email" . $separator;
    $export .= "sesso" . $separator;
    $export .= "compleanno" . $separator;
    $export .= "indirizzo" . $separator;
    $export .= "citta" . $separator;
    $export .= "stato" . $separator;
    $export .= "cap" . $separator;
    $export .= "note" . $separator;
    $export .= "var1" . $separator;
    $export .= "var2" . $separator;
    $export .= "var3" . $separator;
    $export .= "numero" . $separator;
    $export .= "gruppi" . $separator;
    $export .= "altro numero" . $end_line;
    if (!empty($rows)) {
        foreach ($rows as $row) {
            $export .= $row->nominativo . $separator;
            $export .= $separator;
            $export .= $separator;
            $export .= $row->mail . $separator;
            $export .= $separator;
            $export .= $row->data_nascita_b . $separator;
            $export .= $row->indirizzo . $separator;
            $export .= $row->localita . ' - ' . $row->provincia . $separator;
            $export .= $separator;
            $export .= $separator;
            $export .= $separator;
            $export .= $separator;
            $export .= $separator;
            $export .= $row->mail . $separator;
            $export .= $row->telefono . $separator;
            $export .= $separator;
            $export .= $separator;
            $export .= $end_line;
        }
        //foreach
    }
    //empty
    header("Content-type: application/csv;charset=UTF-8");
    header("Content-Disposition: inline; filename=lista_contatti_skebby.csv");
    echo $export;
    exit;
}
<style>
.dataTables_filter{		text-align:right;	}
.dataTables_paginate{	text-align:center;	}
.dataTables_paginate a{		margin:5px;	}
.wp-list-table tr:hover{	background-color:#eeeeee;	}
</style>

<h1>Lista ordini</h1>



<?php 
$rows = cloud_lista_ordini();
?>

<table id='tbl_lista_ordini' class="wp-list-table widefat fixed posts">
	<thead>
        <tr>
            <th>Stato</th>
            <th>Servizio</th>
				<th>Dettaglio serv.</th>
            <th>Data</th>
            <th>Bambino</th>
            <!-- th>Genitore</th>
            <th>Telefono</th -->
				<th>Catering</th>
				<th>Servizi</th>
				<th>Ultima modifica</th>
            <th></th>
        </tr>
    </thead>