Live in Production · SaaS Platform

Veterinary
Prescription
Management

A full-stack SaaS platform bridging pet owners, veterinary clinics, and pharmacy operations — automating prescription approvals end-to-end with zero manual intervention.

Live Platform See How It Works
3
User Roles
48h
Auto-Retry Window
6
Rx Status States
100%
Automated Fax
Prescription Dashboard — Live
142
Rx Requests Today
89%
Approval Rate
7
Awaiting Fax Reply
38
Synced to NetSuite
Vetmedin 5mg — Buddy (Labrador)
Riverside Animal Hospital · Dr. Carter
Approved
Apoquel 16mg — Luna (Golden)
VetCare Clinic · Dr. Patel
Fax Retry 2/3
Prednisone 20mg — Max (Beagle)
Paws & Claws Vet · Dr. Singh
Fax Sent
Approved & Synced
Auto-Fax Active
3
User Portals
30min
NetSuite Sync Interval
3×
Fax Retry Attempts
6h
Lookback Window
CodeIgniter 3 PHP 7.4 MySQL NetSuite SOAP SRFax API AWS SES DOMPDF
System Overview

One Platform.
Three Stakeholders. Zero Manual Steps.

Built from scratch because no off-the-shelf tool could handle the three-way sync between a pharmacy, dozens of veterinary clinics, and thousands of pet owners — with full ERP integration.

Automated Prescription Workflow

Orders import from NetSuite automatically every 30 minutes. Prescription items are split into individual approval requests, faxed to vets, tracked in real time, and synced back — all without a human touching anything.

  • Datasync_v2.php pulls orders via NetSuite SOAP API
  • 6-hour lookback window for redundant reliability
  • Three-layer duplicate prevention (in-memory + INSERT IGNORE + parsed2 flag)
  • splitApprovalRequests() per medication per order
  • Rx status: New → Faxed → Retry → Approved → Synced

Smart Fax + Email System

Fax PDFs are generated via DOMPDF, transmitted via SRFax API with automatic delivery polling. Up to 3 retries over 48 hours. Simultaneously, pet owners receive branded email notifications via AWS SES at every status change.

  • DOMPDF + Roboto font for professional Rx PDFs
  • SRFax API with delivery status polling loop
  • Auto-retry schedule: 0h → 24h → 48h
  • AWS SES (us-west-1) — custom branded templates
  • Email triggers: request sent, approved, declined

Vet Approval Portal

Veterinary clinics get a dedicated 24/7 web portal to review, approve, or decline prescriptions — no fax machine required. Admins manage hospital and vet records; team members handle intake, fax follow-up, and escalations.

  • Vetportal.php — dedicated vet-facing interface
  • Role-based access: Admins (vetpsignup) + Team (vet_sub_ph)
  • Complete audit trail per prescription decision
  • Manual fax fallback for problematic records
  • Real-time status visible to all three portals simultaneously
Prescription Lifecycle

Order to Approval.
Fully Automated.

Every prescription request follows a strict, auditable path from NetSuite import through fax delivery, vet response, ERP sync, and owner notification — with no manual steps required.

Imported→
Faxed→
Retry→
Approved→
Synced→
Notified
NetSuite SOAP Sync — Every 30 Minutes
Datasync_v2.php runs on cron, pulling orders from NetSuite via SOAP/OAuth with a 6-hour lookback window. processOrder() handles new records; splitApprovalRequests() creates per-medication Rx entries in pet_rx_req.
Automated Fax with 3-Attempt Retry
Each Rx triggers a DOMPDF-generated fax PDF sent via SRFax API. Delivery status is polled at intervals. If no response within 24h, an automatic retry fires — up to 3 attempts over 48 hours before escalation.
Vet Response via Portal or Fax-Back
Vets approve or decline via the online portal (Vetportal.php) or fax back using the traditional method. Both paths update the same pet_rx_req record. Role-based access ensures clinic privacy and accountability.
Real-Time ERP Sync + Owner Email
Approval decisions instantly sync back to NetSuite via SOAP API, updating the order status. AWS SES simultaneously fires a branded transactional email to the pet owner confirming the outcome — zero delay, zero manual work.
CodeIgniter 3 NetSuite SOAP/OAuth SRFax API DOMPDF AWS SES SDK PHP 7.4 MySQL
⟳ SOAP NetSuite SOAP Import Datasync_v2.php · 30min cron · 6h lookback ⊕ Split Approval Requests splitApprovalRequests() · pet_rx_req table · dedup FAX Generate & Transmit Fax PDF DOMPDF · SRFax API · 3×retry over 48h ✓ Vet Approves / Declines Vetportal.php · online portal or fax-back ↩ Sync to NetSuite + Email Owner SOAP write-back · AWS SES notification
Integrations

Four APIs.
Seamlessly Connected.

Pawsitive Cloud integrates with four external systems — each chosen specifically for reliability in a healthcare-adjacent, prescription-critical workflow.

NetSuite (SOAP)
Order import + approval write-back via SOAP/OAuth1. 6-hour lookback ensures zero missed prescriptions.
SRFax API
Enterprise fax transmission with delivery status polling and 3-attempt auto-retry over 48 hours.
AWS SES
Transactional email via us-west-1. Branded templates sent on every status change to pet owners.
DOMPDF
Server-side Rx PDF generation with Roboto font. Fax-ready output stored at /media/pharmacy/fax.
Cron Sync Logic
Every 30min · lookback: -6 hours
processOrder() → splitApprovalRequests()
Three-layer dedup: in-memory set → INSERT IGNORE with unique composite key → parsed2='Y' flag. Guarantees no duplicate Rx records regardless of cron overlap.
🐾 Pawsitive Cloud CodeIgniter 3 · PHP 7.4 · MySQL LIVE ⚙ NetSuite ERP SOAP/OAuth · Orders 📠 SRFax API 3× retry · 48h window ✉ AWS SES us-west-1 · Branded 📄 DOMPDF Rx PDF generation Vet Approval Portal Vetportal.php · 24/7 APPROVE · DECLINE · REVIEW
For Veterinary Clinics

Built for Busy Vet Practices

  • Approve or decline prescriptions in one click from any device
  • No more phone tag or hunting through fax queues
  • Complete audit trail per prescription decision
  • 24/7 portal access — approve on your schedule
  • Role-based access for your entire clinic team
Visit Live Platform
For Pet Owners

Peace of Mind for Your Pet's Health

  • Real-time email updates at every stage of approval
  • No more calling in to check on your prescription status
  • Professional branded confirmations when approved
  • Fast processing so pets get their medications on time
  • Transparent, trustworthy automated workflow
See Pawsitive Cloud
Technology & Trust

Enterprise-Grade Infrastructure
You Can Trust.

Built on proven, secure technologies. Prescription data is protected at every step — from transmission to storage to delivery.

Cloud Hosted

Fully managed cloud infrastructure with high availability, automatic backups, and zero downtime deployments.

End-to-End Encryption

All data in transit and at rest is fully encrypted. Prescription data is private and protected at every step of the workflow.

Secure Fax Communications

Fax transmissions via enterprise-grade SRFax network with full delivery confirmation and audit logging per send.

Audit Logs & Compliance

Complete activity logs for every prescription action — who approved what, when, and through which channel.

AWS SES Email
SRFax Network
NetSuite Integrated
SSL Secured
99.9% Uptime
Technical Deep Dive

How It Was Built

Every component was chosen deliberately. The stack handles real prescription approvals in a production healthcare-adjacent environment.

DataSync Engine
Datasync_v2.php · Cron-driven
Runs every 30 minutes via cron job. Pulls prescription orders from NetSuite via SOAP/OAuth with a 6-hour lookback window — intentionally over-engineered for a system replacing production code where missing an Rx order is not an option. Three-layer duplicate prevention ensures clean data regardless of cron overlap or API retries.
PHP 7.4 NetSuite SOAP OAuth1 INSERT IGNORE Cron
Fax Automation
SRFax API + DOMPDF
DOMPDF generates professional Rx PDFs with Roboto font, stored server-side. SRFax API transmits with full delivery status polling. Auto-retry fires at 24h and 48h if no response. Manual fallback available for problematic records (e.g., missing or invalid vet fax numbers). Fax audit trail stored per Rx request.
DOMPDF SRFax API Delivery Polling Auto-Retry PDF Storage
Email Notification System
AWS SES SDK · PHP
Migrated from Office365 SMTP to AWS SES (us-west-1) for reliability and scale. Custom-branded HTML email templates sent at each prescription status change. AWS SDK deprecation warnings for PHP 7.4 suppressed via config flag. Session management uses CodeIgniter with cookie_secure hardcoded TRUE for load-balancer reliability.
AWS SES us-west-1 AWS SDK PHP HTML Templates CKEditor
Application Architecture
CodeIgniter 3 · MVC · Bootstrap 5
CodeIgniter 3 MVC with deliberate design choices to differentiate from the source system: pet_* table prefixes vs pharm_*, renamed form fields, self-invoking JS patterns, Pet_model instead of Ord_model. Two-level navigation hierarchy, async function pairs for DataTables, Bootstrap 5 card styling. Hosted on AWS EC2 Ubuntu with Apache virtual hosts and SSL.
CodeIgniter 3 Bootstrap 5 Chart.js AWS EC2 Apache Composer

A Production-Grade Platform
Built End-to-End.

Pawsitive Cloud is live, handling real veterinary prescriptions — from NetSuite import through fax delivery to vet approval and owner notification, fully automated.

Visit Live Platform Back to Portfolio