format("d/m/Y"); $field_names = [ "Invoice No", "Customer", "Invoice Date", "Due Date", "Terms", "Location", "Memo", "Item (Product/Service)", "Item Description", "Item Quantity", "Item Rate", "Item Amount", "Item Tax Code", "Item Tax Amount", "Service Date", ]; fputcsv($handle, $field_names); foreach($projects as $project) { if($project->dts_finished === null) continue; $customer = $project->getCustomer(); $invoice = $project->getCustomerInvoice(); $line_items = $invoice->getLineItems(); $invoice_generated_dt = new DateTime($project->dts_finished, $utc_timezone); $invoice_date = $invoice_generated_dt->format("d/m/Y"); $invoice_generated_dt->add($invoice_interval); $invoice_due_date = $invoice_generated_dt->format("d/m/Y"); foreach($line_items as $item) { $output = []; $output[] = $invoice->getReference(); // "Invoice No", $output[] = $customer->name; // "Customer", $output[] = $invoice_date; // "Invoice Date", $output[] = $invoice_due_date; // "Due Date", $output[] = "Net 30"; // "Terms", $output[] = ""; // "Location", $output[] = "{$project->id} {$project->name}"; // "Memo", $output[] = $item->getName(); // "Item (Product/Service)", $output[] = ""; // "Item Description", $output[] = $item->getQuantity() ?: "1"; // "Item Quantity", $output[] = $item->getPrice(); // "Item Rate", $output[] = $item->getTotal(); // "Item Amount", $output[] = ($invoice->getTaxRate() * 100) . "%"; // "Item Tax Code", $output[] = $invoice->getTaxRate() * $item->getTotal(); // "Item Tax Amount", $output[] = $date; // "Service Date", fputcsv($handle, $output); } }