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);
}
