public function get_excel_summarize()
{
global $msg;
global $charset, $fichier_temp_nom, $titre_page;
global $cashdesk_filter, $start_date, $stop_date;
if (!count($this->cashdesk_list)) {
return "";
}
if (!$cashdesk_filter) {
$cashdesk_filter = array();
}
if (!$cashdesk_filter[0]) {
$cashdesk_filter = array();
}
$fname = tempnam("./temp", "{$fichier_temp_nom}.xls");
$workbook = new writeexcel_workbook($fname);
$worksheet =& $workbook->addworksheet();
$worksheet->write(0, 0, $titre_page);
$i = 2;
$j = 2;
$worksheet->write($i, $j++, $msg["cashdesk_edition_name"]);
$worksheet->write($i, $j++, $msg["cashdesk_edition_transac_name"]);
$worksheet->write($i, $j++, $msg["cashdesk_edition_transac_unit_price"]);
$worksheet->write($i, $j++, $msg["cashdesk_edition_transac_montant"]);
$worksheet->write($i, $j++, $msg["cashdesk_edition_transac_realisee_no"]);
$worksheet->write($i, $j++, $msg["cashdesk_edition_transac_realisee"]);
$worksheet->write($i, $j++, $msg["cashdesk_edition_transac_encaissement_no"]);
$worksheet->write($i, $j++, $msg["cashdesk_edition_transac_encaissement"]);
$i++;
foreach ($this->cashdesk_list as $index => $cashdesk) {
if (count($cashdesk_filter)) {
if (!in_array($cashdesk['id'], $cashdesk_filter)) {
continue;
}
}
$cashdesk_info = new cashdesk($cashdesk['id']);
$all_transactions = $cashdesk_info->summarize($start_date, $stop_date, $transactype, $encaissement);
if (!count($all_transactions)) {
continue;
}
foreach ($all_transactions as $transactions) {
$j = 2;
$worksheet->write($i, $j++, $cashdesk['name']);
$worksheet->write($i, $j++, $transactions['name']);
$worksheet->write($i, $j++, $transactions['unit_price']);
$worksheet->write($i, $j++, $transactions['montant']);
$worksheet->write($i, $j++, $transactions['realisee_no']);
$worksheet->write($i, $j++, $transactions['realisee']);
$worksheet->write($i, $j++, $transactions['encaissement_no']);
$worksheet->write($i, $j++, $transactions['encaissement']);
$i++;
}
}
$workbook->close();
$fh = fopen($fname, "rb");
fpassthru($fh);
unlink($fname);
}
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: cashdesk.inc.php,v 1.2 2013-12-24 13:08:33 ngantier Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
//Gestion des caisses
require_once $class_path . "/cashdesk/cashdesk_list.class.php";
require_once $class_path . "/cashdesk/cashdesk.class.php";
if (!$action) {
$cashdesk_list = new cashdesk_list();
print $cashdesk_list->get_form();
} else {
$cashdesk = new cashdesk($id);
$cashdesk->proceed();
}
