arabiantraderoute.com

List all RFQs with related data Retrieves all RFQs with enriched data including assigned user, linked project, and counts of related entities (comments, attachments, suppliers, shipments, payments).

Create a new RFQ Creates a new Request for Quotation.

Import RFQs from legacy backend Fetches RFQs from the legacy Express backend and imports them into the PostgreSQL database.

Get a single RFQ with all related data Retrieves a single RFQ by ID with full details including all comments (with user info), attachments (with tags), suppliers, shipments, payments, and entity counts.

Update an RFQ Updates an existing RFQ.

Delete an RFQ Permanently deletes an RFQ and all related data (comments, attachments, suppliers, quotations, shipments, payments) via cascading deletes.

Update RFQ status Updates only the status field of an RFQ.

Update RFQ priority Updates only the priority field of an RFQ.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/suppliers] List suppliers for an RFQ Retrieves all suppliers assigned to an RFQ, including the full supplier record from the global Supplier directory.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/suppliers] Add a supplier to an RFQ Creates an RFQ-Supplier relationship.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/suppliers] Remove a supplier from an RFQ (via query param) Removes a supplier from an RFQ using the supplierId as a query parameter.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/suppliers/{supplierId}] Update supplier details for an RFQ Updates the RFQ-Supplier relationship fields including role, quoted price, and notes.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/quotations] List quotations for an RFQ supplier Retrieves all quotations submitted by a specific supplier for an RFQ.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/quotations] Create a new quotation with items Creates a new quotation for a supplier on an RFQ.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/quotations/{quotationId}] Get a single quotation Retrieves a specific quotation by ID with all its line items and proforma files.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/quotations/{quotationId}] Update a quotation Updates a quotation and replaces all its line items.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/quotations/{quotationId}] Delete a quotation Permanently deletes a quotation and all its line items and proforma files via cascading deletes.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/comments] List comments for an RFQ Retrieves all comments for an RFQ, including the author's user info (id, name, email).

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/comments] Create a comment on an RFQ Creates a new internal comment on an RFQ.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/comments/{commentId}] Update a comment Updates the content of an existing comment.

[DEPRECATED — use /api/internal/payment-tracker/projects/{projectId}/comments/{commentId}] Delete a comment Permanently deletes a comment from an RFQ.

List attachments for an RFQ Retrieves all file attachments for an RFQ.

Upload an attachment to an RFQ Uploads a file to MinIO storage via the backend API and stores the metadata in the database.

Delete an attachment Deletes a file attachment from both the filesystem/storage and the database.

Replace tags on an attachment Replaces all tags on an attachment.

List payments for an RFQ Retrieves all payment records for an RFQ, including a count of attachments for each payment.

Create a payment record for an RFQ Creates a new payment record for an RFQ.

Update a payment record Updates an existing payment record.

Delete a payment record Permanently deletes a payment record and all its associated attachments via cascading deletes.

List attachments for a payment Retrieves all file attachments associated with a specific payment.

Upload an attachment to a payment Uploads a file to MinIO storage via the backend API and creates a PaymentAttachment record.

Delete a payment attachment Deletes a payment attachment from both MinIO storage and the database.

List shipments for an RFQ Retrieves all shipment tracking records for an RFQ.

Create a shipment tracking record Creates a new shipment tracking record for an RFQ.

Update a shipment Updates a shipment tracking record.

Delete a shipment Permanently deletes a shipment tracking record.

List all invoices Returns a paginated list of invoices with optional filters by type, status, client name, linked RFQ, and date range.

Create a new invoice Creates a new invoice in DRAFT status.

Get a single invoice Returns the full invoice record including items, payments, and linked RFQ details.

Update an invoice Partially updates an invoice.

Delete an invoice Deletes an invoice.

Generate and download invoice PDF Generates a PDF for the invoice using react-pdf and returns the binary content as a downloadable file.

Generate and store invoice PDF Generates the PDF and stores it (future: MinIO upload).

List invoices for a payment tracker project Returns all invoices associated with a payment tracker project, ordered by date descending.

Create an invoice for a payment tracker project Creates a new invoice linked to a payment tracker project.

Update a payment tracker project invoice Partially updates a payment tracker invoice.

Delete a payment tracker project invoice Deletes a payment tracker invoice and its items.

Generate a client invoice from a payment tracker project Creates a new core Invoice (PROFORMA, DRAFT) by converting all non-cancelled line items from the payment tracker project into invoice items.

List all payment tracker projects Returns every project with a computed `_summary` block that includes the active item count, total project value, and total client payments received.

Create a new project Creates a payment tracker project.

Get a project with all related data Returns the full project record together with all child entities: line items, client payments, supplier payments, credits, shipments, invoices, and the activity log.

Update a project Partially updates a project.

Delete a project Permanently deletes a project and all related data via cascading deletes in the database.

List suppliers being considered for a project Suppliers approached for this project, each with the quotations they have submitted.

Attach a supplier to a project

Change a supplier's role or notes on a project

Detach a supplier from a project The supplier's quotations are kept and simply lose their link, so historical prices stay searchable.

List quotations on a project Every quotation with its supplier, line items and typed attributes.

Record a quotation from a supplier `totalAmount` is not accepted from the caller: the server computes it from the items and returns its own value.

Get one quotation

Correct a quotation Items carrying an `id` are updated in place, which preserves the typed attributes recorded against them; items omitted from the payload are deleted.

Delete a quotation

Accept, reject or reopen a quotation Accepting is one transaction: the quotation becomes ACCEPTED, its supplier's role becomes SELECTED unless already CONTRACTED, and that supplier's other open quotations become SUPERSEDED.

List the project discussion thread Newest first.

Add a comment to a project

Edit your own comment Only the author may edit; anyone else receives 403.

Delete your own comment

List line items for a project Returns all line items ordered by `itemNumber` ascending.

Add a line item to a project Creates a new line item.

Update a line item Partially updates a line item.

Delete a line item Permanently removes a line item and logs `line_item_deleted`.

List client payments for a project Returns all client payments ordered by `date` descending.

Record a client payment Records a payment received from the client.

Update a client payment Partially updates a client payment.

Delete a client payment Permanently removes a client payment.

List supplier payments for a project Returns all supplier payments ordered by `date` descending.

Record a supplier payment Records a payment made to the supplier.

Update a supplier payment Partially updates a supplier payment.

Delete a supplier payment Permanently removes a supplier payment.

List shipments for a project Returns all shipments ordered by `date` descending, each including its associated line item IDs.

Create a shipment Creates a shipment linking one or more line items.

Delete a shipment Deletes a shipment and reverts all associated line items back to `in_production` status.

Apply a credit to another project Marks a credit as `applied` and links it to a target project.

Revoke a previously applied credit Resets `applied` to false and clears `appliedToProjectId`.

Get activity log for a project Returns the full activity log ordered by `timestamp` descending.

Export all payment tracker data Returns every record across all PT tables in a single JSON payload.

Import payment tracker data from a backup Accepts the same structure produced by the export endpoint (with `version` and `data` keys).

Seed a project's line items from its RFQ Fills in the line items an accepted quotation implies.

Upload a base64-encoded image to storage Accepts a data-URL-encoded image (e.g.

List backlog items Returns all backlog items with optional filtering by status, priority, category, assignee, tags, and free-text search.

Create a new backlog item Creates a backlog item and logs an `item_created` activity entry inside a database transaction.

Get a single backlog item with comments and activity Returns a backlog item together with its threaded comments (top-level comments ordered newest-first, replies ordered oldest-first) and the last 50 activity log entries.

Update a backlog item Partially updates any fields on the item.

Delete a backlog item Permanently removes the item and all associated comments and activity entries.

List comments for a backlog item Returns top-level comments (newest first) with nested replies (oldest first).

Add a comment or reply to a backlog item Creates a comment on the item.

Get backlog statistics Returns aggregate counts grouped by status, priority, and category, the total item count, and the 10 most recent activity log entries.

Bulk update multiple backlog items Applies the same set of field updates to all specified items.

Reorder backlog items (drag-and-drop) Updates `sortOrder` (and optionally `status`) for a batch of items.

Generate a product catalog PDF Accepts an array of products and catalog settings, fetches any remote images server-side (converting to base64), renders the catalog using `@react-pdf/renderer` on the server, and returns the binary PDF.

Proxy an external image through the server Fetches an image from a trusted external host, detects the actual MIME type from magic bytes (to work around CDN mislabeling), and returns the raw binary.

AI-powered product data extraction Sends content (file, URL text, or plain text) to an AI provider (Gemini, OpenAI, or Ollama) to extract structured product data.

Fetch and extract text from a URL Server-side URL fetcher that retrieves the page content, strips HTML to plain text, and returns it for AI processing.

AI-powered image editing (inpainting) Performs mask-based image editing using DALL-E (OpenAI) or Gemini.

AI-powered product data cleanup Sends product data to an AI provider (Gemini or OpenAI) for automated cleanup: shortening names, removing irrelevant specifications, converting imperial units to metric, and standardising the output format.

List suppliers with optional filters Returns every supplier ordered alphabetically by name, with `_count` for rfqSuppliers, quotations, and certifications.

Create a new supplier Creates a supplier record.

Get one supplier with certifications, RFQs, and quotations Returns the supplier record plus its certifications (ordered by expiry ascending, then createdAt descending), the last 25 `RFQSupplier` join rows with their parent RFQ, and the last 25 quotations.

Partially update a supplier Any subset of Supplier fields.

Resolve a name (or alias) to an existing supplier Case-insensitive lookup: matches `Supplier.name` exactly (case-insensitive) OR any entry in `Supplier.aliases`.

List contacts for a supplier Ordered by `isDecisionMaker DESC, createdAt DESC` so the operational reader appears first.

Add a contact to a supplier Setting `emailStatus = BOUNCED` and omitting `bouncedAt` stamps `bouncedAt` to the server clock automatically — a bounce with no timestamp is worse than a bounce with an approximate one.

Get one contact

Partial update Transitioning `emailStatus` to `BOUNCED` auto-stamps `bouncedAt` when the row didn't already have one.

Delete a contact (except bounced ones — retention rule) Contacts with `emailStatus = BOUNCED` cannot be deleted; they stay searchable so a future session doesn't re-mail a dead inbox.

List certifications for a supplier Returns all certifications on file for the supplier, ordered by expiry ascending (soonest expiring first).

Add a certification to a supplier Records a certification (e.g.

Get one certification

Update a certification (partial) Partial update — every field is optional.

Delete a certification Permanently deletes the certification record.

Global feed of certifications expired or expiring within N days Cross-supplier sweep.

Record a quotation (standalone or RFQ-scoped) Creates a quotation with its line items and typed attributes in one call.

Cross-supplier price history for a product Returns line items whose parent quotations match the filters.

List market-price benchmarks External market observations, filtered by product and observation date.

Record one market benchmark

Bulk import of suppliers, contacts, certs, quotations, benchmarks Idempotent bundle import.

List tags Returns all tags ordered alphabetically.

Create a new tag Creates a tag with a unique name.

Get aggregated dashboard statistics Returns platform-wide statistics including active projects, subscriber counts, file totals, Payment Tracker financials, and Backlog Tracker metrics.

List all projects Returns all customer-facing projects.

Create a new project Creates a customer-facing project for tracking shipments and updates.

Get a project by ID or slug Retrieves a single project by its ID or slug.

Subscribe to project updates Subscribes an email address to receive notifications when the project is updated.

Unsubscribe from project updates Removes an email address from the project's notification list.

Post an update to a project Creates a new timeline update for a project.

Submit a contact form Forwards a contact form submission to the backend service.

Submit a lead from the website Forwards a lead submission to the backend `POST /api/lead` endpoint.

Submit an RFQ from the public website Accepts a multipart form data RFQ submission from the customer-facing website and forwards it to the backend.

Check upload API health Returns the status of the upload proxy and whether required environment variables (`BACKEND_URL`, `API_SECRET_KEY`) are configured.

Upload a file Proxies a file upload to the backend service.

List uploaded files Proxies to the backend `GET /api/files/files` endpoint.

Delete a file by key Deletes a file from MinIO storage via the backend proxy.

Get the current authenticated user Returns the currently authenticated user based on the `Cf-Access-Authenticated-User-Email` header set by Cloudflare Access.

Sync or create user from Cloudflare Access Creates a new user record if one does not exist for the authenticated Cloudflare Access email, or updates the existing record if the name has changed.

Create a new user account Creates a new user.

Set user password via token Sets the password for a user account using a JWT token received via email.

Send a message to the AI chatbot Sends a conversation to the Gemini 2.0 Flash model with a system prompt tailored to Arabian Trade Route.

Submit a lead captured by the chatbot Submits lead information collected during a chatbot conversation.

Generate a PDF document Generates a PDF product catalog or proposal from structured document data.

Generate HTML preview of a document Returns an HTML rendering of the document for web-based preview.

Generate mobile-optimized HTML preview Returns a mobile-optimized HTML rendering of the document.

Get default document template Returns the default template structure and company information that the document editor UI uses as a starting point.

Validate document data structure Validates the structure of document data before generating a PDF or preview.

Application health check Returns the health status of the Next.js frontend service.