| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- <?php
- /**
- * @var Project[] $projects
- */
- $utc_timezone = new DateTimeZone("UTC");
- $invoice_interval = new DateInterval("P30D");
- $current_dt = new DateTime();
- $date = $current_dt->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");
- $time_text = $project->getTimeOfDayText();
- 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} ({$time_text})"; // "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);
- }
- }
|