PHP SendHeaders Examples

Example #1

File: xls4.php Project: clagiordano/weblibs

<?php

$root = substr($_SERVER["DOCUMENT_ROOT"], 0, -1);
require_once "{$root}/Class/Database.php";
require_once "{$root}/Function/DataTime.php";
require_once "{$root}/Class/XlsExport.php";
$d = new Database("localhost", "gestore", "polipo", "gestione");
$r = $d->GetRows("*", "view_call", "", "", "data_att limit 50", 1);
SendHeaders("my_name.xls");
// XLS Data Cell
xlsBOF();
xlsWriteLabel(0, 0, "N.Call");
xlsWriteLabel(0, 1, "Data Chisura");
xlsWriteLabel(0, 2, "Cliente");
xlsWriteLabel(0, 3, "CITY");
xlsWriteLabel(0, 4, "Tecnico");
xlsWriteLabel(0, 5, "Tipo Call");
xlsWriteLabel(0, 6, "Note");
xlsWriteLabel(0, 7, "Economico");
$xlsRow = 1;
$tot_economico = 0;
foreach ($r as $key => $field) {
    if ($field['n_pdl'] > "1") {
        $economico = floatval($field['econ']) * floatval($field['n_pdl']);
        $compenso = floatval($field['prz']) * floatval($field['n_pdl']);
    } else {
        $economico = floatval($field['econ']);
        $compenso = floatval($field['prz']);
    }
    xlsWriteLabel($xlsRow, 0, $field['n_call']);
    xlsWriteLabel($xlsRow, 1, Inverti_Data($field['data_att']));

Example #2

File: frm_xls_giacenza_rollout.php Project: clagiordano/weblibs

<?php

session_start();
$root = substr($_SERVER["DOCUMENT_ROOT"], 0, -1);
require_once "connection.php";
require_once "{$root}/Class/XlsExport.php";
SendHeaders("Giacenza_hw_nuovo_" . date('d-m-Y') . ".xls");
$hw_new = $d->GetRows("*", "view_macchine", "provenienza = 'FORNITORE'", "id_macchina");
xlsBOF();
xlsWriteLabel(0, 0, "PROGRESSIVO");
// contatore base 1
xlsWriteLabel(0, 1, "TIPO /  PROVENIENZA");
xlsWriteLabel(0, 2, "DDT Arrivo e/o REQUEST NUMBER (x resi e dismesse)");
xlsWriteLabel(0, 3, "Rif.Ordine o Req. Number In (x Resi)");
xlsWriteLabel(0, 4, "Nome Filiale Citta ( solo x dismessi)");
xlsWriteLabel(0, 5, "DATA IN");
xlsWriteLabel(0, 6, "ORDINE OUT (Utilizzato x l- uscita della merce)");
xlsWriteLabel(0, 7, "DATA STAGING");
xlsWriteLabel(0, 8, "DATA OUT");
xlsWriteLabel(0, 9, "Filiale di Destinazione");
// den filiale
xlsWriteLabel(0, 10, "Codice Filiale");
// cod_fil filiale
xlsWriteLabel(0, 11, "Formattazione e allestimento Kit Accessori e cavetteria");
xlsWriteLabel(0, 12, "NOTE  Accessori Mancanti");
xlsWriteLabel(0, 13, "TIPOLOGIA APPARATO");
xlsWriteLabel(0, 14, "CODICE ARTICOLO");
xlsWriteLabel(0, 15, "MARCA");
xlsWriteLabel(0, 16, "MODELLO");
xlsWriteLabel(0, 17, "CLASSIFICAZIONE HW");
xlsWriteLabel(0, 18, "CONTROLLO VISIVO");