project_quickbooks_customer_csv.php 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  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. $time_text = $project->getTimeOfDayText();
  37. foreach($line_items as $item) {
  38. $output = [];
  39. $output[] = $invoice->getReference(); // "Invoice No",
  40. $output[] = $customer->name; // "Customer",
  41. $output[] = $invoice_date; // "Invoice Date",
  42. $output[] = $invoice_due_date; // "Due Date",
  43. $output[] = "Net 30"; // "Terms",
  44. $output[] = ""; // "Location",
  45. $output[] = "{$project->id} {$project->name} ({$time_text})"; // "Memo",
  46. $output[] = $item->getName(); // "Item (Product/Service)",
  47. $output[] = ""; // "Item Description",
  48. $output[] = $item->getQuantity() ?: "1"; // "Item Quantity",
  49. $output[] = $item->getPrice(); // "Item Rate",
  50. $output[] = $item->getTotal(); // "Item Amount",
  51. $output[] = ($invoice->getTaxRate() * 100) . "%"; // "Item Tax Code",
  52. $output[] = $invoice->getTaxRate() * $item->getTotal(); // "Item Tax Amount",
  53. $output[] = $date; // "Service Date",
  54. fputcsv($handle, $output);
  55. }
  56. }