| | | 1 | | #include "maintenance_service.h" |
| | | 2 | | #include "db_connection.h" |
| | | 3 | | #include "logger.h" |
| | | 4 | | #include <stdio.h> |
| | | 5 | | #include <stdlib.h> |
| | | 6 | | #include <string.h> |
| | | 7 | | |
| | | 8 | | #ifndef TEST_MODE |
| | | 9 | | |
| | 3 | 10 | | bool add_maintenance_log(int machine_id, const char *technician, const char *description, double cost) { |
| | 3 | 11 | | DBConnection *conn_wrapper = db_pool_acquire(); |
| | | 12 | | |
| | 3 | 13 | | if (!conn_wrapper) { |
| | 1 | 14 | | LOG_ERROR("Could not acquire connection to add maintenance log."); |
| | 1 | 15 | | return false; |
| | | 16 | | } |
| | | 17 | | |
| | | 18 | | char query[1024]; |
| | 2 | 19 | | snprintf(query, sizeof(query), |
| | | 20 | | "INSERT INTO maintenance_logs (machine_id, performer, description, cost) " |
| | | 21 | | "VALUES (%d, '%s', '%s', %.2f);", |
| | | 22 | | machine_id, technician, description, cost); |
| | 2 | 23 | | PGresult *res = PQexec(conn_wrapper->pg_conn, query); |
| | | 24 | | |
| | 2 | 25 | | if (PQresultStatus(res) != PGRES_COMMAND_OK) { |
| | 1 | 26 | | LOG_ERROR("Failed to insert maintenance log: %s", PQerrorMessage(conn_wrapper->pg_conn)); |
| | 1 | 27 | | PQclear(res); |
| | 1 | 28 | | db_pool_release(conn_wrapper); |
| | 1 | 29 | | return false; |
| | | 30 | | } |
| | | 31 | | |
| | 1 | 32 | | PQclear(res); |
| | 1 | 33 | | db_pool_release(conn_wrapper); |
| | 1 | 34 | | LOG_INFO("Maintenance log added for Machine %d.", machine_id); |
| | 1 | 35 | | return true; |
| | | 36 | | } |
| | | 37 | | |
| | 3 | 38 | | int get_maintenance_history(int machine_id, MaintenanceLog *out_logs, int max_logs) { |
| | 3 | 39 | | DBConnection *conn_wrapper = db_pool_acquire(); |
| | | 40 | | |
| | 3 | 41 | | if (!conn_wrapper) { |
| | 1 | 42 | | LOG_ERROR("Could not acquire connection to fetch maintenance history."); |
| | 1 | 43 | | return 0; |
| | | 44 | | } |
| | | 45 | | |
| | | 46 | | char query[256]; |
| | 2 | 47 | | snprintf(query, sizeof(query), |
| | | 48 | | "SELECT id, machine_id, performer, to_char(ts, 'YYYY-MM-DD'), description, cost " |
| | | 49 | | "FROM maintenance_logs WHERE machine_id = %d ORDER BY ts DESC;", |
| | | 50 | | machine_id); |
| | 2 | 51 | | PGresult *res = PQexec(conn_wrapper->pg_conn, query); |
| | | 52 | | |
| | 2 | 53 | | if (PQresultStatus(res) != PGRES_TUPLES_OK) { |
| | 1 | 54 | | LOG_ERROR("Failed to fetch maintenance history: %s", PQerrorMessage(conn_wrapper->pg_conn)); |
| | 1 | 55 | | PQclear(res); |
| | 1 | 56 | | db_pool_release(conn_wrapper); |
| | 1 | 57 | | return 0; |
| | | 58 | | } |
| | | 59 | | |
| | 1 | 60 | | int rows = PQntuples(res); |
| | 1 | 61 | | int count = (rows < max_logs) ? rows : max_logs; |
| | | 62 | | |
| | 3 | 63 | | for (int i = 0; i < count; i++) { |
| | 2 | 64 | | out_logs[i].id = atoi(PQgetvalue(res, i, 0)); |
| | 2 | 65 | | out_logs[i].machine_id = atoi(PQgetvalue(res, i, 1)); |
| | 2 | 66 | | strncpy(out_logs[i].technician_name, PQgetvalue(res, i, 2), 99); |
| | 2 | 67 | | out_logs[i].technician_name[99] = '\0'; |
| | 2 | 68 | | strncpy(out_logs[i].log_date, PQgetvalue(res, i, 3), 31); |
| | 2 | 69 | | out_logs[i].log_date[31] = '\0'; |
| | 2 | 70 | | strncpy(out_logs[i].description, PQgetvalue(res, i, 4), 511); |
| | 2 | 71 | | out_logs[i].description[511] = '\0'; |
| | 2 | 72 | | out_logs[i].cost = atof(PQgetvalue(res, i, 5)); |
| | | 73 | | } |
| | | 74 | | |
| | 1 | 75 | | PQclear(res); |
| | 1 | 76 | | db_pool_release(conn_wrapper); |
| | 1 | 77 | | LOG_INFO("Fetched %d maintenance logs for Machine %d.", count, machine_id); |
| | 1 | 78 | | return count; |
| | | 79 | | } |
| | | 80 | | |
| | 2 | 81 | | int get_all_maintenance_logs(MaintenanceLog *out_logs, int max_logs) { |
| | 2 | 82 | | DBConnection *conn_wrapper = db_pool_acquire(); |
| | | 83 | | |
| | 2 | 84 | | if (!conn_wrapper) return 0; |
| | | 85 | | |
| | 1 | 86 | | const char *query = "SELECT id, machine_id, performer, to_char(ts, 'YYYY-MM-DD'), description, cost " |
| | | 87 | | "FROM maintenance_logs ORDER BY ts DESC;"; |
| | 1 | 88 | | PGresult *res = PQexec(conn_wrapper->pg_conn, query); |
| | | 89 | | |
| | 1 | 90 | | if (PQresultStatus(res) != PGRES_TUPLES_OK) { |
| | 0 | 91 | | PQclear(res); |
| | 0 | 92 | | db_pool_release(conn_wrapper); |
| | 0 | 93 | | return 0; |
| | | 94 | | } |
| | | 95 | | |
| | 1 | 96 | | int rows = PQntuples(res); |
| | 1 | 97 | | int count = (rows < max_logs) ? rows : max_logs; |
| | | 98 | | |
| | 2 | 99 | | for (int i = 0; i < count; i++) { |
| | 1 | 100 | | out_logs[i].id = atoi(PQgetvalue(res, i, 0)); |
| | 1 | 101 | | out_logs[i].machine_id = atoi(PQgetvalue(res, i, 1)); |
| | 1 | 102 | | strncpy(out_logs[i].technician_name, PQgetvalue(res, i, 2), 99); |
| | 1 | 103 | | out_logs[i].technician_name[99] = '\0'; |
| | 1 | 104 | | strncpy(out_logs[i].log_date, PQgetvalue(res, i, 3), 31); |
| | 1 | 105 | | out_logs[i].log_date[31] = '\0'; |
| | 1 | 106 | | strncpy(out_logs[i].description, PQgetvalue(res, i, 4), 511); |
| | 1 | 107 | | out_logs[i].description[511] = '\0'; |
| | 1 | 108 | | out_logs[i].cost = atof(PQgetvalue(res, i, 5)); |
| | | 109 | | } |
| | | 110 | | |
| | 1 | 111 | | PQclear(res); |
| | 1 | 112 | | db_pool_release(conn_wrapper); |
| | 1 | 113 | | return count; |
| | | 114 | | } |
| | | 115 | | |
| | 3 | 116 | | bool update_maintenance_log(int log_id, const char *description, double cost) { |
| | 3 | 117 | | DBConnection *conn_wrapper = db_pool_acquire(); |
| | | 118 | | |
| | 3 | 119 | | if (!conn_wrapper) return false; |
| | | 120 | | |
| | | 121 | | char query[1024]; |
| | 2 | 122 | | snprintf(query, sizeof(query), |
| | | 123 | | "UPDATE maintenance_logs SET description = '%s', cost = %.2f WHERE id = %d;", |
| | | 124 | | description, cost, log_id); |
| | 2 | 125 | | PGresult *res = PQexec(conn_wrapper->pg_conn, query); |
| | 2 | 126 | | bool success = (PQresultStatus(res) == PGRES_COMMAND_OK); |
| | | 127 | | |
| | 2 | 128 | | if (!success) { |
| | 1 | 129 | | LOG_ERROR("Failed to update log: %s", PQerrorMessage(conn_wrapper->pg_conn)); |
| | | 130 | | } else { |
| | 1 | 131 | | LOG_INFO("Maintenance log %d updated successfully.", log_id); |
| | | 132 | | } |
| | | 133 | | |
| | 2 | 134 | | PQclear(res); |
| | 2 | 135 | | db_pool_release(conn_wrapper); |
| | 2 | 136 | | return success; |
| | | 137 | | } |
| | | 138 | | |
| | 2 | 139 | | bool delete_maintenance_log(int log_id) { |
| | 2 | 140 | | DBConnection *conn_wrapper = db_pool_acquire(); |
| | | 141 | | |
| | 2 | 142 | | if (!conn_wrapper) return false; |
| | | 143 | | |
| | | 144 | | char query[128]; |
| | 1 | 145 | | snprintf(query, sizeof(query), "DELETE FROM maintenance_logs WHERE id = %d;", log_id); |
| | 1 | 146 | | PGresult *res = PQexec(conn_wrapper->pg_conn, query); |
| | 1 | 147 | | bool success = (PQresultStatus(res) == PGRES_COMMAND_OK); |
| | | 148 | | |
| | 1 | 149 | | if (!success) { |
| | 0 | 150 | | LOG_ERROR("Failed to delete log: %s", PQerrorMessage(conn_wrapper->pg_conn)); |
| | | 151 | | } else { |
| | 1 | 152 | | LOG_INFO("Maintenance log %d deleted.", log_id); |
| | | 153 | | } |
| | | 154 | | |
| | 1 | 155 | | PQclear(res); |
| | 1 | 156 | | db_pool_release(conn_wrapper); |
| | 1 | 157 | | return success; |
| | | 158 | | } |
| | | 159 | | |
| | | 160 | | #endif // TEST_MODE |
| | | 161 | | |
| | | 162 | | #ifdef TEST_MODE |
| | | 163 | | |
| | | 164 | | // ===================================== |
| | | 165 | | // MOCK IMPLEMENTATION |
| | | 166 | | // ===================================== |
| | | 167 | | |
| | | 168 | | bool add_maintenance_log(int machine_id, |
| | | 169 | | const char *technician, |
| | | 170 | | const char *description, |
| | | 171 | | double cost) { |
| | | 172 | | if (machine_id <= 0 || !technician || !description) |
| | | 173 | | return false; |
| | | 174 | | |
| | | 175 | | return true; |
| | | 176 | | } |
| | | 177 | | |
| | | 178 | | int get_maintenance_history(int machine_id, |
| | | 179 | | MaintenanceLog *logs, |
| | | 180 | | int max_count) { |
| | | 181 | | if (!logs || max_count <= 0) |
| | | 182 | | return 0; |
| | | 183 | | |
| | | 184 | | logs[0].id = 1; |
| | | 185 | | logs[0].machine_id = machine_id; |
| | | 186 | | strcpy(logs[0].technician_name, "TestTech"); |
| | | 187 | | strcpy(logs[0].log_date, "2025-01-01"); |
| | | 188 | | strcpy(logs[0].description, "Mock history"); |
| | | 189 | | logs[0].cost = 100.0; |
| | | 190 | | return 1; |
| | | 191 | | } |
| | | 192 | | |
| | | 193 | | int get_all_maintenance_logs(MaintenanceLog *logs, |
| | | 194 | | int max_count) { |
| | | 195 | | if (!logs || max_count <= 0) |
| | | 196 | | return 0; |
| | | 197 | | |
| | | 198 | | logs[0].id = 1; |
| | | 199 | | logs[0].machine_id = 1; |
| | | 200 | | strcpy(logs[0].technician_name, "Ali"); |
| | | 201 | | strcpy(logs[0].log_date, "2025-01-01"); |
| | | 202 | | strcpy(logs[0].description, "Routine oil change"); |
| | | 203 | | logs[0].cost = 150.5; |
| | | 204 | | return 1; |
| | | 205 | | } |
| | | 206 | | |
| | | 207 | | bool update_maintenance_log(int log_id, |
| | | 208 | | const char *description, |
| | | 209 | | double cost) { |
| | | 210 | | if (log_id <= 0 || !description) |
| | | 211 | | return false; |
| | | 212 | | |
| | | 213 | | return true; |
| | | 214 | | } |
| | | 215 | | |
| | | 216 | | bool delete_maintenance_log(int log_id) { |
| | | 217 | | if (log_id <= 0) |
| | | 218 | | return false; |
| | | 219 | | |
| | | 220 | | return true; |
| | | 221 | | } |
| | | 222 | | |
| | | 223 | | #endif // TEST_MODE |