project_quickbooks_customer_csv.php 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. <?php
  2. /**
  3. * @var Project[] $projects
  4. */
  5. $utc_timezone = new DateTimeZone("UTC");
  6. $invoice_interval = new DateInterval("P30D");
  7. $current_dt = new DateTime();
  8. $date = $current_dt->format("d/m/Y");
  9. $field_names = [
  10. "Invoice No",
  11. "Customer",
  12. "Invoice Date",
  13. "Due Date",
  14. "Terms",
  15. "Location",
  16. "Memo",
  17. "Item (Product/Service)",
  18. "Item Description",
  19. "Item Quantity",
  20. "Item Rate",
  21. "Item Amount",
  22. "Item Tax Code",
  23. "Item Tax Amount",
  24. "Service Date",
  25. ];
  26. fputcsv($handle, $field_names);
  27. foreach($projects as $project) {
  28. if($project->dts_finished === null) continue;
  29. $customer = $project->getCustomer();
  30. $invoice = $project->getCustomerInvoice();
  31. $line_items = $invoice->getLineItems();
  32. $invoice_generated_dt = new DateTime($project->dts_finished, $utc_timezone);
  33. $invoice_date = $invoice_generated_dt->format("d/m/Y");
  34. $invoice_generated_dt->add($invoice_interval);
  35. $invoice_due_date = $invoice_generated_dt->format("d/m/Y");
  36. foreach($line_items as $item) {
  37. $output = [];
  38. $output[] = $invoice->getReference(); // "Invoice No",
  39. $output[] = $customer->name; // "Customer",
  40. $output[] = $invoice_date; // "Invoice Date",
  41. $output[] = $invoice_due_date; // "Due Date",
  42. $output[] = "Net 30"; // "Terms",
  43. $output[] = ""; // "Location",
  44. $output[] = "{$project->id} {$project->name}"; // "Memo",
  45. $output[] = $item->getName(); // "Item (Product/Service)",
  46. $output[] = ""; // "Item Description",
  47. $output[] = $item->getQuantity() ?: "1"; // "Item Quantity",
  48. $output[] = $item->getPrice(); // "Item Rate",
  49. $output[] = $item->getTotal(); // "Item Amount",
  50. $output[] = ($invoice->getTaxRate() * 100) . "%"; // "Item Tax Code",
  51. $output[] = $invoice->getTaxRate() * $item->getTotal(); // "Item Tax Amount",
  52. $output[] = $date; // "Service Date",
  53. fputcsv($handle, $output);
  54. }
  55. }