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