payments.php 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160
  1. <?php
  2. header("Access-Control-Allow-Origin: *");
  3. header("Content-Type: application/json; charset=UTF-8");
  4. header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
  5. header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");
  6. if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
  7. exit(0);
  8. }
  9. require_once '../config/database.php';
  10. require_once '../models/Payment.php';
  11. $database = new Database();
  12. $db = $database->getConnection();
  13. $payment = new Payment($db);
  14. $request_method = $_SERVER['REQUEST_METHOD'];
  15. switch($request_method) {
  16. case 'GET':
  17. if(isset($_GET['id'])) {
  18. $payment->id = $_GET['id'];
  19. $payment->readOne();
  20. if($payment->payment_date != null) {
  21. $payment_arr = array(
  22. "id" => $payment->id,
  23. "invoice_id" => $payment->invoice_id,
  24. "client_id" => $payment->client_id,
  25. "payment_date" => $payment->payment_date,
  26. "amount" => $payment->amount,
  27. "payment_method" => $payment->payment_method,
  28. "reference_number" => $payment->reference_number,
  29. "notes" => $payment->notes,
  30. "created_at" => $payment->created_at,
  31. "updated_at" => $payment->updated_at
  32. );
  33. http_response_code(200);
  34. echo json_encode($payment_arr);
  35. } else {
  36. http_response_code(404);
  37. echo json_encode(array("message" => "Payment not found."));
  38. }
  39. } elseif(isset($_GET['invoice_id'])) {
  40. $payment->invoice_id = $_GET['invoice_id'];
  41. $stmt = $payment->read();
  42. $num = $stmt->rowCount();
  43. if($num > 0) {
  44. $payments_arr = array();
  45. $payments_arr["records"] = array();
  46. while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  47. extract($row);
  48. $payment_item = array(
  49. "id" => $id,
  50. "invoice_id" => $invoice_id,
  51. "client_id" => $client_id,
  52. "payment_date" => $payment_date,
  53. "amount" => $amount,
  54. "payment_method" => $payment_method,
  55. "reference_number" => $reference_number,
  56. "notes" => $notes,
  57. "created_at" => $created_at,
  58. "updated_at" => $updated_at
  59. );
  60. array_push($payments_arr["records"], $payment_item);
  61. }
  62. http_response_code(200);
  63. echo json_encode($payments_arr);
  64. } else {
  65. http_response_code(200);
  66. echo json_encode(array("records" => array()));
  67. }
  68. } else {
  69. http_response_code(400);
  70. echo json_encode(array("message" => "Missing invoice_id parameter."));
  71. }
  72. break;
  73. case 'POST':
  74. $data = json_decode(file_get_contents("php://input"));
  75. if(!empty($data->client_id) && !empty($data->payment_date) && !empty($data->amount)) {
  76. $payment->client_id = $data->client_id;
  77. $payment->invoice_id = $data->invoice_id ?? null;
  78. $payment->payment_date = $data->payment_date;
  79. $payment->amount = $data->amount;
  80. $payment->payment_method = $data->payment_method ?? 'cash';
  81. $payment->reference_number = $data->reference_number ?? '';
  82. $payment->notes = $data->notes ?? '';
  83. if($payment->create()) {
  84. http_response_code(201);
  85. echo json_encode(array("message" => "Payment was created."));
  86. } else {
  87. http_response_code(503);
  88. echo json_encode(array("message" => "Unable to create payment."));
  89. }
  90. } else {
  91. http_response_code(400);
  92. echo json_encode(array("message" => "Unable to create payment. Data is incomplete."));
  93. }
  94. break;
  95. case 'PUT':
  96. $data = json_decode(file_get_contents("php://input"));
  97. if(!empty($data->id) && !empty($data->client_id) && !empty($data->payment_date) && !empty($data->amount)) {
  98. $payment->id = $data->id;
  99. $payment->client_id = $data->client_id;
  100. $payment->invoice_id = $data->invoice_id ?? null;
  101. $payment->payment_date = $data->payment_date;
  102. $payment->amount = $data->amount;
  103. $payment->payment_method = $data->payment_method ?? 'cash';
  104. $payment->reference_number = $data->reference_number ?? '';
  105. $payment->notes = $data->notes ?? '';
  106. if($payment->update()) {
  107. http_response_code(200);
  108. echo json_encode(array("message" => "Payment was updated."));
  109. } else {
  110. http_response_code(503);
  111. echo json_encode(array("message" => "Unable to update payment."));
  112. }
  113. } else {
  114. http_response_code(400);
  115. echo json_encode(array("message" => "Unable to update payment. Data is incomplete."));
  116. }
  117. break;
  118. case 'DELETE':
  119. if(isset($_GET['id'])) {
  120. $payment->id = $_GET['id'];
  121. if($payment->delete()) {
  122. http_response_code(200);
  123. echo json_encode(array("message" => "Payment was deleted."));
  124. } else {
  125. http_response_code(503);
  126. echo json_encode(array("message" => "Unable to delete payment."));
  127. }
  128. } else {
  129. http_response_code(400);
  130. echo json_encode(array("message" => "Unable to delete payment. ID is missing."));
  131. }
  132. break;
  133. default:
  134. http_response_code(405);
  135. echo json_encode(array("message" => "Method not allowed."));
  136. break;
  137. }
  138. ?>