Checks BGD submission status on passtrack.net and records receivedAtCenter per applicant.
Checkout filter selects applications that got a payment link (paymentUrl set), dated by paymentLinkTime (Dhaka tz). Uncheck to filter by createdAt instead.
Run history
Started
Mode
Range / Params
Status
Progress
Submitted
Not Sub.
Failed
Duration
Checks every applicant (main + attendees) on this application and writes their status.
Checks each BGD number on passtrack and marks SUBMITTED / NOT_SUBMITTED — nothing is written to the database. A failed check reports NOT_SUBMITTED with Check Failed in the Detail column. A CSV row that already carries a SUBMITTED/NOT_SUBMITTED status (2nd column) is skipped; blank rows and rows whose detail says Check Failed are re-checked. Download the result and re-upload it to resume — tick Recheck all to force every row.
Builds one Submission_report row per application from visa_applications (upsert by application id — re-generate any time to refresh). Submitted / Not Submitted BGDs come from the tracker's receivedAtCenter results, so run the tracker first for fresh numbers.
Reference summary — RM › Distributor › Agent (mission & visa type wise)
Reference
Mission
Visa Type
Apps
BGDs
Submitted
Not Submitted
Claim
Billable
Applicant Phone
BGD Number
Submitted BGD
Not Submitted BGD
BGD Count
IVAC Location
Visa Type
Status
State
Submission Count
Not Submission
Claim
Billable
URL No
Paid By
Invoice Link
Agent
Read-only payment history from visa_applications — one row per application with its payment link details. BGD marks (✓/✗) come from the tracker's receivedAtCenter results. Times shown in Dhaka.
SL
OTP Phone
BGD Numbers
Location
Status
Payment
Link Generated
Agent
Invoice
API key (only if the server requires X-Tracker-Key)