from reportlab.lib.pagesizes import A4
from reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle
from reportlab.lib.units import cm
from reportlab.lib import colors
from reportlab.platypus import (
    SimpleDocTemplate, Paragraph, Spacer, Table, TableStyle,
    PageBreak, HRFlowable, KeepTogether
)
from reportlab.lib.enums import TA_CENTER, TA_JUSTIFY, TA_LEFT
from reportlab.platypus import ListFlowable, ListItem

OUTPUT = "/tmp/workspace/pharmacy-assignment/Community_Pharmacy_Assignment.pdf"

doc = SimpleDocTemplate(
    OUTPUT,
    pagesize=A4,
    rightMargin=2.5*cm,
    leftMargin=2.5*cm,
    topMargin=2.5*cm,
    bottomMargin=2.5*cm,
    title="Retail and Wholesale Community Pharmacies",
    author="B.Pharm / D.Pharm Assignment",
)

styles = getSampleStyleSheet()

# Custom styles
cover_title = ParagraphStyle(
    'CoverTitle', parent=styles['Title'],
    fontSize=22, leading=28, alignment=TA_CENTER,
    textColor=colors.HexColor('#1a3a5c'), spaceAfter=12
)
cover_sub = ParagraphStyle(
    'CoverSub', parent=styles['Normal'],
    fontSize=13, leading=18, alignment=TA_CENTER,
    textColor=colors.HexColor('#2c6fad'), spaceAfter=8
)
cover_info = ParagraphStyle(
    'CoverInfo', parent=styles['Normal'],
    fontSize=11, leading=16, alignment=TA_CENTER,
    textColor=colors.HexColor('#444444'), spaceAfter=6
)
h1 = ParagraphStyle(
    'H1', parent=styles['Heading1'],
    fontSize=15, leading=20, textColor=colors.HexColor('#1a3a5c'),
    spaceBefore=14, spaceAfter=6, borderPad=2
)
h2 = ParagraphStyle(
    'H2', parent=styles['Heading2'],
    fontSize=12, leading=16, textColor=colors.HexColor('#2c6fad'),
    spaceBefore=10, spaceAfter=4
)
h3 = ParagraphStyle(
    'H3', parent=styles['Heading3'],
    fontSize=11, leading=14, textColor=colors.HexColor('#1a3a5c'),
    spaceBefore=7, spaceAfter=3
)
body = ParagraphStyle(
    'Body', parent=styles['Normal'],
    fontSize=10.5, leading=16, alignment=TA_JUSTIFY,
    spaceAfter=6, firstLineIndent=18
)
body_no_indent = ParagraphStyle(
    'BodyNoIndent', parent=styles['Normal'],
    fontSize=10.5, leading=16, alignment=TA_JUSTIFY, spaceAfter=6
)
bullet = ParagraphStyle(
    'Bullet', parent=styles['Normal'],
    fontSize=10.5, leading=15, leftIndent=18, spaceAfter=3,
    bulletIndent=6
)
caption = ParagraphStyle(
    'Caption', parent=styles['Normal'],
    fontSize=9.5, leading=12, alignment=TA_CENTER,
    textColor=colors.HexColor('#555555'), spaceAfter=6
)
ref_style = ParagraphStyle(
    'Ref', parent=styles['Normal'],
    fontSize=10, leading=14, leftIndent=18, spaceAfter=4
)

def B(text): return f"<b>{text}</b>"
def I(text): return f"<i>{text}</i>"

# ─────────────────────────────────────────────
# TABLE HELPER
# ─────────────────────────────────────────────
def make_table(header, rows, col_widths=None):
    data = [header] + rows
    if col_widths is None:
        col_widths = [doc.width / len(header)] * len(header)
    t = Table(data, colWidths=col_widths, repeatRows=1)
    style = TableStyle([
        ('BACKGROUND', (0,0), (-1,0), colors.HexColor('#1a3a5c')),
        ('TEXTCOLOR', (0,0), (-1,0), colors.white),
        ('FONTNAME', (0,0), (-1,0), 'Helvetica-Bold'),
        ('FONTSIZE', (0,0), (-1,0), 10),
        ('ALIGN', (0,0), (-1,0), 'CENTER'),
        ('ROWBACKGROUNDS', (0,1), (-1,-1), [colors.HexColor('#eaf1fb'), colors.white]),
        ('FONTNAME', (0,1), (-1,-1), 'Helvetica'),
        ('FONTSIZE', (0,1), (-1,-1), 9.5),
        ('ALIGN', (0,1), (0,-1), 'LEFT'),
        ('ALIGN', (1,1), (-1,-1), 'LEFT'),
        ('VALIGN', (0,0), (-1,-1), 'TOP'),
        ('GRID', (0,0), (-1,-1), 0.4, colors.HexColor('#aaaaaa')),
        ('TOPPADDING', (0,0), (-1,-1), 5),
        ('BOTTOMPADDING', (0,0), (-1,-1), 5),
        ('LEFTPADDING', (0,0), (-1,-1), 6),
        ('RIGHTPADDING', (0,0), (-1,-1), 6),
    ])
    t.setStyle(style)
    return t

# ─────────────────────────────────────────────
# BUILD STORY
# ─────────────────────────────────────────────
story = []

# ── COVER PAGE ──────────────────────────────────────────────────────────────
story.append(Spacer(1, 3*cm))
story.append(Paragraph("ASSIGNMENT", cover_sub))
story.append(Spacer(1, 0.4*cm))
story.append(HRFlowable(width="90%", thickness=2, color=colors.HexColor('#2c6fad'), spaceAfter=12))
story.append(Paragraph(
    "Retail and Wholesale Community Pharmacies",
    cover_title
))
story.append(Paragraph(
    "A Comparative Study on Organization, Legal Requirements, Infrastructure,<br/>Record Maintenance, and Dispensing Practices",
    cover_sub
))
story.append(HRFlowable(width="90%", thickness=2, color=colors.HexColor('#2c6fad'), spaceBefore=12, spaceAfter=20))
story.append(Spacer(1, 1.5*cm))

cover_table_data = [
    ["Subject", "Pharmacy Practice"],
    ["Course", "B.Pharm / D.Pharm"],
    ["Topic", "Community Pharmacy"],
    ["Date", "July 2026"],
]
ct = Table(cover_table_data, colWidths=[5*cm, 9*cm])
ct.setStyle(TableStyle([
    ('FONTNAME', (0,0), (0,-1), 'Helvetica-Bold'),
    ('FONTNAME', (1,0), (1,-1), 'Helvetica'),
    ('FONTSIZE', (0,0), (-1,-1), 11),
    ('ROWBACKGROUNDS', (0,0), (-1,-1), [colors.HexColor('#eaf1fb'), colors.white]),
    ('GRID', (0,0), (-1,-1), 0.4, colors.HexColor('#aaaaaa')),
    ('TOPPADDING', (0,0), (-1,-1), 7),
    ('BOTTOMPADDING', (0,0), (-1,-1), 7),
    ('LEFTPADDING', (0,0), (-1,-1), 10),
    ('ALIGN', (0,0), (-1,-1), 'LEFT'),
]))
story.append(ct)
story.append(PageBreak())

# ── PAGE 2: TABLE OF CONTENTS ─────────────────────────────────────────────
story.append(Paragraph("Table of Contents", h1))
story.append(HRFlowable(width="100%", thickness=1, color=colors.HexColor('#2c6fad'), spaceAfter=10))

toc_data = [
    ["No.", "Topic", "Page"],
    ["1", "Introduction", "3"],
    ["2", "Organization", "3"],
    ["2.1", "Retail Pharmacy", "3"],
    ["2.2", "Wholesale Pharmacy", "4"],
    ["3", "Legal Requirements", "4"],
    ["3.1", "Governing Legislation", "4"],
    ["3.2", "License Forms and Validity", "5"],
    ["3.3", "Technical Personnel Requirements", "5"],
    ["4", "Infrastructure / Premises", "5"],
    ["4.1", "Retail Pharmacy Infrastructure", "5"],
    ["4.2", "Wholesale Pharmacy Infrastructure", "6"],
    ["5", "Record Maintenance", "6"],
    ["5.1", "Records in Retail Pharmacy", "6"],
    ["5.2", "Records in Wholesale Pharmacy", "7"],
    ["6", "Dispensing Practices", "7"],
    ["6.1", "Dispensing in Retail Pharmacy", "7"],
    ["6.2", "Supply Practices in Wholesale Pharmacy", "8"],
    ["7", "Comparative Summary Table", "8"],
    ["8", "Conclusion", "8"],
    ["9", "References", "9"],
]
toc_t = Table(toc_data, colWidths=[1.5*cm, 12*cm, 1.5*cm])
toc_t.setStyle(TableStyle([
    ('BACKGROUND', (0,0), (-1,0), colors.HexColor('#1a3a5c')),
    ('TEXTCOLOR', (0,0), (-1,0), colors.white),
    ('FONTNAME', (0,0), (-1,0), 'Helvetica-Bold'),
    ('FONTSIZE', (0,0), (-1,0), 10),
    ('FONTNAME', (0,1), (-1,-1), 'Helvetica'),
    ('FONTSIZE', (0,1), (-1,-1), 10),
    ('ROWBACKGROUNDS', (0,1), (-1,-1), [colors.HexColor('#eaf1fb'), colors.white]),
    ('GRID', (0,0), (-1,-1), 0.4, colors.HexColor('#aaaaaa')),
    ('ALIGN', (0,0), (-1,-1), 'LEFT'),
    ('ALIGN', (2,0), (2,-1), 'CENTER'),
    ('TOPPADDING', (0,0), (-1,-1), 4),
    ('BOTTOMPADDING', (0,0), (-1,-1), 4),
    ('LEFTPADDING', (0,0), (-1,-1), 6),
]))
story.append(toc_t)
story.append(PageBreak())

# ── PAGE 3: INTRODUCTION + ORGANIZATION ──────────────────────────────────
story.append(Paragraph("1. Introduction", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))

story.append(Paragraph(
    "Community pharmacy is an integral component of the healthcare system, serving as the primary point of access where patients obtain medications, health advice, and related services. The term 'community pharmacy' broadly encompasses all pharmacy establishments that operate in the community setting, as opposed to institutional pharmacies found within hospitals. Within community pharmacies, two distinct types exist based on the level at which drugs are supplied: <b>retail pharmacies</b> and <b>wholesale pharmacies</b>.",
    body
))
story.append(Paragraph(
    "A retail pharmacy (also called a chemist shop or dispensing chemist) directly serves patients and the general public. A wholesale pharmacy, by contrast, acts as an intermediary in the pharmaceutical supply chain, distributing drugs in bulk to retailers, hospitals, dispensaries, and other licensed entities. Both types are regulated under the <b>Drugs and Cosmetics Act, 1940</b> and the <b>Drugs and Cosmetics Rules, 1945</b> in India, and must comply with the <b>Pharmacy Act, 1948</b>, which governs the registration and conduct of pharmacists.",
    body
))
story.append(Paragraph(
    "This assignment provides a detailed comparison of retail and wholesale community pharmacies with respect to their organization, legal requirements, infrastructure, record maintenance, and dispensing or supply practices.",
    body
))

story.append(Paragraph("2. Organization", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))

story.append(Paragraph("2.1 Retail Pharmacy", h2))
story.append(Paragraph(
    "A retail pharmacy is the <b>terminal point</b> in the pharmaceutical supply chain. Its primary function is to dispense prescription and over-the-counter (OTC) medications directly to patients. The retail pharmacy occupies a patient-facing role and is, therefore, organized to facilitate direct interaction between the pharmacist and the consumer.",
    body
))
story.append(Paragraph("Key organizational features of a retail pharmacy include:", body_no_indent))
for pt in [
    "<b>Proprietorship or Chain Model:</b> A retail pharmacy may be run as a sole proprietorship, partnership firm, or as part of a chain (e.g., Apollo Pharmacy, MedPlus, Medica). Chain pharmacies benefit from centralized procurement and inventory management, giving them a competitive edge over independent pharmacies.",
    "<b>Mandatory Registered Pharmacist:</b> A registered pharmacist (holding a B.Pharm or D.Pharm degree and registered with the State Pharmacy Council) must be in charge of the pharmacy and must be physically present during working hours. This is a statutory requirement under the Pharmacy Act, 1948.",
    "<b>Product Range:</b> The stock of a retail pharmacy includes Rx (prescription) drugs, OTC drugs, Schedule H, H1, and X drugs (dispensed only on prescription), Schedule C and C1 biological products (vaccines, insulin, sera), cosmetics, surgical accessories, and nutraceuticals.",
    "<b>Patient Services:</b> Beyond medication supply, modern retail pharmacies provide patient counselling, blood pressure and blood glucose monitoring, health education, and adherence support.",
    "<b>Procurement:</b> Retail pharmacies source drugs from wholesalers, authorized distributors, or directly from manufacturers. They maintain stock for immediate supply to walk-in customers.",
]:
    story.append(Paragraph(f"  \u2022  {pt}", bullet))

story.append(Spacer(1, 0.3*cm))
story.append(Paragraph("2.2 Wholesale Pharmacy", h2))
story.append(Paragraph(
    "A wholesale pharmacy serves as an <b>intermediary distributor</b> in the pharmaceutical supply chain. It procures drugs in large quantities from manufacturers or their authorized distributors and supplies them in bulk to retail pharmacies, hospitals, nursing homes, dispensaries, and other licensed healthcare establishments. It does not supply drugs directly to patients.",
    body
))
story.append(Paragraph("Key organizational features of a wholesale pharmacy include:", body_no_indent))
for pt in [
    "<b>B2B (Business-to-Business) Model:</b> All transactions are conducted with licensed entities (retailers, institutions). Supply to unlicensed persons or directly to patients is prohibited by law.",
    "<b>Technical Person:</b> A wholesale pharmacy may be managed by a registered pharmacist or a 'competent person' - defined as a graduate in science with at least one year of experience in drug dealing, or a person with an SSLC/matriculation certificate with at least four years of experience in dealing in drugs.",
    "<b>PCD Franchise Link:</b> A wholesale drug license (Forms 20B/21B) combined with GST registration is the complete legal requirement to operate a PCD (Propaganda-cum-Distribution) pharma franchise, making wholesale licenses common among pharma business operators.",
    "<b>Supply Chain Role:</b> Wholesale pharmacies ensure a steady, uninterrupted supply of pharmaceuticals, manage buffer stock, and provide critical distribution logistics including cold-chain management.",
    "<b>Bulk Procurement:</b> Purchase is made directly from pharmaceutical manufacturers or their clearing and forwarding (C&F) agents at wholesale prices, with trade margins defined under pricing regulations.",
]:
    story.append(Paragraph(f"  \u2022  {pt}", bullet))

story.append(PageBreak())

# ── PAGE 4-5: LEGAL REQUIREMENTS ─────────────────────────────────────────
story.append(Paragraph("3. Legal Requirements", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))

story.append(Paragraph("3.1 Governing Legislation", h2))
story.append(Paragraph(
    "Both retail and wholesale community pharmacies in India are governed by a common framework of legislation. The primary statutes are:",
    body_no_indent
))
leg_data = [
    [B("Legislation"), B("Relevance")],
    ["Drugs and Cosmetics Act, 1940\n& Rules, 1945",
     "Primary law governing manufacture, distribution, sale, and quality of drugs. Prescribes license conditions for retail (Forms 20/21) and wholesale (Forms 20B/21B) operations."],
    ["Pharmacy Act, 1948",
     "Regulates the profession of pharmacy; mandates registration of pharmacists with State Pharmacy Councils; requires a registered pharmacist in charge of a retail pharmacy."],
    ["NDPS Act, 1985",
     "Governs narcotic drugs and psychotropic substances; requires additional licensing and strict record-keeping for Schedule X and narcotic substances."],
    ["Drugs (Prices Control)\nOrder (DPCO)",
     "Controls the prices of essential medicines; both retail and wholesale entities must sell scheduled formulations at or below the ceiling price notified by NPPA."],
    ["Poisons Act",
     "Regulates the possession and sale of scheduled poisons (Schedule L drugs); applicable where the pharmacy stocks such substances."],
    ["GST Act, 2017",
     "Mandates GST registration for businesses above the threshold turnover; applicable to all pharmacies for billing and tax compliance."],
]
story.append(make_table(
    leg_data[0], leg_data[1:],
    col_widths=[5.5*cm, 10*cm]
))

story.append(Spacer(1, 0.4*cm))
story.append(Paragraph("3.2 License Forms, Application, and Validity", h2))
story.append(Paragraph(
    "The Drugs and Cosmetics Rules, 1945 prescribe specific forms for applying and receiving drug licenses. The common application form is <b>Form 19</b> for both retail and wholesale. Licenses are issued by the <b>State Licensing Authority (State Drugs Control Organisation)</b> after an inspection of the premises by a Drug Inspector.",
    body
))

lic_data = [
    [B("Parameter"), B("Retail Pharmacy"), B("Wholesale Pharmacy")],
    ["Application Form", "Form 19", "Form 19"],
    ["License Form\n(General Allopathic)", "Form 20", "Form 20B"],
    ["License Form\n(Schedule C & C1 drugs)", "Form 21", "Form 21B"],
    ["License Form\n(Homoeopathic - Retail)", "Form 20C", "Form 20D"],
    ["Issuing Authority", "State Licensing Authority", "State Licensing Authority"],
    ["License Validity", "Perpetual (2024 amendment); retention fee every 5 years", "Perpetual; retention fee every 5 years"],
    ["Inspection", "Drug Inspector visits premises", "Drug Inspector visits premises"],
    ["Schedule X Drugs", "Additional endorsement needed", "Separate sub-license required"],
]
story.append(make_table(
    lic_data[0], lic_data[1:],
    col_widths=[5*cm, 5.5*cm, 5*cm]
))
story.append(Paragraph(
    "Note: Prior to the 2024 amendment to Rule 63 of the Drugs and Cosmetics Rules, licenses required renewal every five years. They are now valid in perpetuity, subject to payment of a retention fee every five years.",
    caption
))

story.append(Paragraph("3.3 Technical Personnel Requirements", h2))
story.append(Paragraph(
    "The qualification of the person in charge is one of the most important legal distinctions between retail and wholesale pharmacies:",
    body_no_indent
))
for pt in [
    "<b>Retail Pharmacy:</b> Must be under the charge of a Registered Pharmacist - i.e., a person holding a degree (B.Pharm) or diploma (D.Pharm) in pharmacy from a recognized university and registered with the respective State Pharmacy Council. The pharmacist must be present in the pharmacy during business hours. In their absence, drug sales cannot be carried out legally.",
    "<b>Wholesale Pharmacy:</b> May be managed by a Registered Pharmacist OR a 'Competent Person' - defined as (a) a graduate in science, commerce, or arts with a minimum of one year's experience in dealing in drugs, OR (b) a person who has passed the SSLC/matriculation examination and has at least four years' experience in dealing in drugs. This allows wholesale pharmacies to operate under less strictly defined pharmacy professionals.",
    "<b>Schedule X / Narcotic Control:</b> For both types, handling of Schedule X drugs and narcotic substances requires additional record-keeping qualifications and adherence to NDPS Act provisions.",
]:
    story.append(Paragraph(f"  \u2022  {pt}", bullet))

story.append(PageBreak())

# ── PAGE 5-6: INFRASTRUCTURE ─────────────────────────────────────────────
story.append(Paragraph("4. Infrastructure and Premises Requirements", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))

story.append(Paragraph("4.1 Retail Pharmacy Infrastructure", h2))
story.append(Paragraph(
    "The premises of a retail pharmacy are designed to facilitate patient-facing dispensing and counselling, while ensuring safe storage of medicines. The Drugs and Cosmetics Rules specify minimum physical requirements:",
    body
))
for pt in [
    "<b>Minimum Area:</b> The premises must have a minimum floor area of <b>10 square metres</b> for a retail license alone (Form 20 or Form 21). If both a retail and wholesale license are to be held at the same premises, the minimum area required is <b>15 square metres</b>. The ceiling height must comply with the National Building Code of India, 2005.",
    "<b>Dispensing Counter:</b> A counter separating the pharmacist's working area from the patient/customer area; medicines are handed over at the counter after dispensing.",
    "<b>Storage Shelves and Racks:</b> Adequate shelving for systematic storage and display of OTC products, vitamins, health supplements, and general drugs. Drugs must be stored under conditions specified on the label (temperature, humidity).",
    "<b>Refrigerator (Mandatory):</b> A functional refrigerator is compulsory and proof of its purchase must be submitted at the time of licensing. It is required for storing cold-chain items such as vaccines, insulin, biologicals, and other Schedule C & C1 drugs at 2-8 degrees Celsius.",
    "<b>Locked Cabinet for Schedule X/H1:</b> Schedule X (habit-forming) drugs must be stored in a separate locked cabinet and dispensed only on prescription. Schedule H1 drugs also require additional controls.",
    "<b>Poison Cupboard:</b> If the pharmacy stocks Schedule L (poisons), a separate locked cupboard is mandatory.",
    "<b>Lighting and Ventilation:</b> Adequate natural or artificial lighting and proper ventilation to prevent drug degradation. Good Pharmacy Practice (GPP) guidelines recommend air-conditioned storage for temperature-sensitive drugs.",
    "<b>Counselling Area:</b> Modern pharmacies and GPP guidelines recommend a dedicated consultation/counselling area for patient privacy.",
    "<b>Emergency Kit:</b> Some regulations and professional bodies recommend maintaining a basic emergency drug kit (adrenaline, antihistamines) at the pharmacy.",
]:
    story.append(Paragraph(f"  \u2022  {pt}", bullet))

story.append(Spacer(1, 0.3*cm))
story.append(Paragraph("4.2 Wholesale Pharmacy Infrastructure", h2))
story.append(Paragraph(
    "The infrastructure of a wholesale pharmacy is oriented towards <b>bulk storage, quality assurance, and efficient logistics</b> rather than patient-facing services. Requirements include:",
    body
))
for pt in [
    "<b>Minimum Area:</b> Minimum floor area of <b>10 square metres</b> for a wholesale license alone; <b>15 square metres</b> if combined with a retail license. In practice, most wholesale outlets occupy significantly larger spaces to accommodate bulk inventory.",
    "<b>Dry Storage Area:</b> Large shelving/racking systems for organized bulk inventory storage, segregated by manufacturer or product category. Good Distribution Practice (GDP) guidelines require FEFO (First Expiry First Out) stock rotation.",
    "<b>Cold Storage / Walk-in Refrigeration:</b> For biologicals, vaccines, insulin, and other temperature-sensitive items. Temperature must be continuously monitored and logged.",
    "<b>Quarantine Area:</b> A designated area for goods pending quality check, damaged goods, near-expiry stock, and recalled products - segregated from saleable stock.",
    "<b>Receiving and Dispatch Area:</b> Separate zones for inward consignments and outward supply, facilitating smooth logistics and preventing cross-contamination.",
    "<b>Office Area:</b> For maintaining purchase-sale registers, invoices, and other mandatory records.",
    "<b>Security:</b> Premises must be secured to prevent pilferage, especially for Schedule H, H1, and X drugs.",
    "<b>No Customer Counter Required:</b> Unlike retail pharmacies, wholesale premises do not require a patient-facing dispensing counter. Operations are entirely B2B.",
]:
    story.append(Paragraph(f"  \u2022  {pt}", bullet))

story.append(PageBreak())

# ── PAGE 6-7: RECORD MAINTENANCE ─────────────────────────────────────────
story.append(Paragraph("5. Record Maintenance", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))

story.append(Paragraph(
    "Accurate and complete record keeping is a statutory obligation for all licensed drug premises under Rules 65 and 67 of the Drugs and Cosmetics Rules, 1945. Records must be available for inspection by Drug Inspectors under Section 22 of the Drugs and Cosmetics Act, 1940.",
    body
))

story.append(Paragraph("5.1 Records in Retail Pharmacy", h2))
story.append(Paragraph(
    "Retail pharmacies are required to maintain the following registers and documents:",
    body_no_indent
))

rec_retail = [
    [B("Register / Record"), B("Contents"), B("Retention Period")],
    ["Prescription Register",
     "Patient name and address; prescriber name, designation & reg. no.; drug name, form, dose, quantity dispensed; date of dispensing",
     "As per Rules (min. 3 yrs)"],
    ["Schedule H1 Register",
     "Mandatory separate register for Schedule H1 drugs (e.g., newer antibiotics, anti-TB drugs). Prescription details must be entered by the pharmacist.",
     "3 years"],
    ["Schedule X Register",
     "Separate register for habit-forming/psychotropic drugs (Schedule X); quantities purchased and sold",
     "2 years"],
    ["Narcotic Substances Register",
     "For narcotic drugs under the NDPS Act; strict account of receipts, sales, and balance",
     "3 years"],
    ["Purchase / Stock Register",
     "Supplier name, invoice number, drug name, batch number, manufacturing date, expiry date, quantity received, balance",
     "5 years (GST)"],
    ["Sales Register",
     "Daily record of all drug sales; OTC and Rx sales",
     "As per Rules"],
    ["Cold-chain / Temperature Log",
     "Daily maximum and minimum refrigerator temperature; deviations and corrective actions",
     "As per Rules"],
    ["Prescription Copies",
     "A copy (or original) of each Schedule H/H1/X prescription is retained by the pharmacist at the time of dispensing",
     "3 years"],
]
story.append(make_table(
    rec_retail[0], rec_retail[1:],
    col_widths=[4.2*cm, 8.3*cm, 3*cm]
))

story.append(Spacer(1, 0.4*cm))
story.append(Paragraph("5.2 Records in Wholesale Pharmacy", h2))
story.append(Paragraph(
    "Wholesale pharmacies maintain records focused on supply chain traceability and regulatory compliance. The records facilitate batch-level tracking required for drug recalls and inspections:",
    body_no_indent
))

rec_ws = [
    [B("Register / Record"), B("Contents"), B("Retention Period")],
    ["Purchase / Inward Register",
     "Supplier name, invoice no., drug name, batch number, manufacturing date, expiry date, quantity received, storage conditions",
     "5 years"],
    ["Sales / Outward Register",
     "Customer name, drug license number of buyer, drug name, batch no., quantity supplied, invoice number, date",
     "5 years"],
    ["Running Stock Register",
     "Opening stock, receipts, issues, and closing balance for each product and batch; FEFO compliance",
     "5 years"],
    ["Schedule H/H1 Sales Register",
     "Restricted-drug sales must be recorded separately; supply only to licensed retailers/institutions",
     "3 years"],
    ["Schedule X / Narcotic Register",
     "Batch-level records of purchase and sale of Schedule X drugs; supply only to licensed buyers",
     "3 years"],
    ["Batch Traceability Records",
     "Batch numbers, expiry dates, and supplier details for all products - essential for product recall management",
     "5 years"],
    ["Temperature / Cold-chain Logs",
     "Continuous temperature monitoring for refrigerated and frozen products",
     "As per Rules"],
    ["Delivery Challans / Tax Invoices",
     "GST-compliant invoices for all outward supplies; linked to e-Way bills for interstate movement",
     "6 years (GST)"],
]
story.append(make_table(
    rec_ws[0], rec_ws[1:],
    col_widths=[4.2*cm, 8.3*cm, 3*cm]
))

story.append(PageBreak())

# ── PAGE 7-8: DISPENSING PRACTICES ──────────────────────────────────────
story.append(Paragraph("6. Dispensing Practices", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))

story.append(Paragraph("6.1 Dispensing in Retail Pharmacy", h2))
story.append(Paragraph(
    "Dispensing is the core professional function of a retail pharmacy. It is defined as the act of interpreting a prescription and preparing and delivering a medicine to a patient along with the information needed for its safe and effective use. The process involves several steps:",
    body
))

steps = [
    ("Step 1 - Receiving and Validating the Prescription",
     "The pharmacist receives the prescription and checks for completeness: prescriber's name, qualification, registration number, address, patient name, age, weight (for children), diagnosis (if mentioned), drug name (generic or brand), dose, dosage form, frequency, duration, date, and prescriber's signature. Schedule H/H1/X prescriptions require special attention."),
    ("Step 2 - Pharmaceutical Analysis",
     "The pharmacist performs a clinical check of the prescription: verifying the drug-dose appropriateness, checking for potential drug-drug interactions, drug-disease contraindications, drug allergies, and therapeutic duplications. Dose calculation errors, especially in paediatric and geriatric prescriptions, are flagged."),
    ("Step 3 - Preparing and Labelling",
     "The correct drug, in the correct dosage form and strength, is retrieved and counted/measured. A dispensing label is prepared bearing: patient name, drug name and strength, dosage and frequency, route of administration, duration, storage instructions, dispensing date, and expiry date. For extemporaneous preparations, compounding is performed at this stage."),
    ("Step 4 - Dispensing and Handing Over",
     "The dispensed medication is handed to the patient after confirming identity. The pharmacist explains how to take the medication, the importance of adherence, common side effects to watch for, and storage requirements."),
    ("Step 5 - Patient Counselling",
     "An essential professional responsibility - the pharmacist advises the patient on the use of the medication, potential side effects, interaction with food/alcohol, missed dose policy, and the need for follow-up. This directly impacts medication adherence and therapeutic outcomes."),
    ("Step 6 - Record Entry",
     "The dispensing details are entered in the prescription register. For Schedule H1 drugs, details are also entered in the dedicated H1 register. A copy of the prescription is retained."),
]
for title, detail in steps:
    story.append(Paragraph(f"  <b>{title}:</b>  {detail}", bullet))
    story.append(Spacer(1, 0.1*cm))

story.append(Paragraph("Special Dispensing Rules:", h3))
for pt in [
    "<b>Schedule H drugs</b> can only be dispensed against a valid prescription from a Registered Medical Practitioner (RMP). The pharmacist must record the details and retain the prescription.",
    "<b>Schedule H1 drugs</b> (includes specified antibiotics, anti-TB drugs, and drugs liable to abuse) require entry in a separate H1 register with prescription details, and the prescription must be retained for three years.",
    "<b>Schedule X drugs</b> must be dispensed only against a prescription in duplicate; one copy is retained by the pharmacist for two years.",
    "<b>OTC (non-scheduled) drugs</b> may be sold without a prescription, but responsible pharmacy practice includes basic counselling.",
    "<b>Partial dispensing</b> is permitted when the full quantity is unavailable; the remaining quantity is noted on the prescription, and the patient is informed.",
    "<b>Generic substitution:</b> Pharmacists may substitute a branded drug with a generic equivalent (same active ingredient, dose, and form) unless the prescriber has indicated 'no substitution'. Jan Aushadhi stores operate on a purely generic dispensing model.",
]:
    story.append(Paragraph(f"  \u2022  {pt}", bullet))

story.append(Spacer(1, 0.3*cm))
story.append(Paragraph("6.2 Supply Practices in Wholesale Pharmacy", h2))
story.append(Paragraph(
    "A wholesale pharmacy does not 'dispense' drugs in the clinical sense. Its function is bulk distribution - supplying drugs to licensed buyers based on purchase orders. The process involves:",
    body
))
for pt in [
    "<b>Order Processing:</b> Purchase orders or indent forms received from licensed retailers, hospitals, or dispensaries are verified for validity of the buyer's drug license.",
    "<b>Quality Check on Inward Stock:</b> All incoming consignments are checked for proper labelling, intact packaging, valid batch numbers, manufacturing dates, and expiry dates. Damaged or near-expiry goods are quarantined.",
    "<b>Picking and Packing:</b> Orders are picked from stock following FEFO (First Expiry First Out) principle. Products are packed for dispatch with proper documentation.",
    "<b>Invoice and Documentation:</b> A GST-compliant tax invoice (with drug license number, batch number, expiry date, quantity, and rate) is prepared for every outward supply.",
    "<b>Cold-chain Dispatch:</b> Temperature-sensitive products are dispatched in cold boxes or refrigerated vehicles with temperature monitoring.",
    "<b>Restricted Drug Controls:</b> Schedule H, H1, and X drugs can only be supplied to licensed retail pharmacies or institutions; wholesale pharmacies cannot supply these to unlicensed persons or directly to patients.",
    "<b>Pricing:</b> Drugs are sold at prices that include the permissible trade margin as per DPCO; the final MRP printed on the pack cannot be exceeded.",
    "<b>No Patient Counselling:</b> Unlike retail pharmacies, wholesale pharmacies have no counselling or patient-care function. Their interaction is purely commercial with licensed trade entities.",
]:
    story.append(Paragraph(f"  \u2022  {pt}", bullet))

story.append(PageBreak())

# ── PAGE 8: SUMMARY TABLE + CONCLUSION + REFERENCES ──────────────────────
story.append(Paragraph("7. Comparative Summary", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))

summary = [
    [B("Feature"), B("Retail Pharmacy"), B("Wholesale Pharmacy")],
    ["Primary Function", "Dispensing drugs to patients", "Bulk distribution to licensed trade"],
    ["Customer/Client", "Patients, general public", "Retailers, hospitals, dispensaries"],
    ["License Forms", "Form 20, Form 21", "Form 20B, Form 21B"],
    ["Application Form", "Form 19", "Form 19"],
    ["Issuing Authority", "State Drugs Control Organisation", "State Drugs Control Organisation"],
    ["Technical Person", "Registered Pharmacist (mandatory)", "Pharmacist OR Competent Person"],
    ["Minimum Premises Area", "10 sq m (15 sq m if combined)", "10 sq m (15 sq m if combined)"],
    ["Key Infrastructure", "Dispensing counter, refrigerator, locked cabinet for Sch-X", "Bulk racks, cold storage, quarantine area, dispatch zone"],
    ["Patient Counselling", "Yes - mandatory professional duty", "Not applicable"],
    ["Key Records", "Prescription register, Sch H1/X registers, purchase-sales register", "Purchase-sales-stock register, batch traceability records, tax invoices"],
    ["Schedule H1 Register", "Mandatory", "Not required"],
    ["Schedule X Dispensing", "To patients on prescription only", "To licensed retailers/institutions only"],
    ["Direct Patient Supply", "Yes", "Not permitted"],
    ["Pricing Control", "DPCO ceiling price; MRP to consumers", "Trade margin rules; DPCO compliant"],
    ["Dispensing Label", "Mandatory for each dispensed item", "Not applicable"],
    ["GST Compliance", "Required above threshold", "Required above threshold"],
]
story.append(make_table(
    summary[0], summary[1:],
    col_widths=[4.5*cm, 5.8*cm, 5.2*cm]
))

story.append(Spacer(1, 0.5*cm))
story.append(Paragraph("8. Conclusion", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))
story.append(Paragraph(
    "Retail and wholesale community pharmacies play complementary but distinct roles in the pharmaceutical healthcare system. The retail pharmacy is the face of pharmacy practice - it is where professional pharmacist-patient interaction occurs, where prescriptions are interpreted and dispensed, and where patients receive guidance on medication use. The wholesale pharmacy, on the other hand, is the backbone of the pharmaceutical supply chain, ensuring that drugs manufactured at factories reach retail pharmacies, hospitals, and health facilities in adequate quantities, at the right time, and under proper storage conditions.",
    body
))
story.append(Paragraph(
    "Both types of pharmacies are governed by the same primary legislation - the Drugs and Cosmetics Act, 1940 - but differ in the forms of licenses required, the qualifications of the person in charge, the nature of their premises, the records they must maintain, and the manner in which drugs are supplied. Understanding these differences is fundamental to pharmacy practice and is essential for any pharmacist seeking to establish, manage, or inspect a community pharmacy establishment.",
    body
))
story.append(Paragraph(
    "Good Pharmacy Practice (GPP) standards, as recommended by the WHO and the Pharmacy Council of India, apply primarily to retail pharmacies and emphasize the central role of the pharmacist in patient care, medication counselling, and safe dispensing. Wholesale pharmacies must adhere to Good Distribution Practice (GDP) standards to ensure the integrity and traceability of the drug supply chain.",
    body
))

story.append(Spacer(1, 0.4*cm))
story.append(Paragraph("9. References", h1))
story.append(HRFlowable(width="100%", thickness=0.6, color=colors.HexColor('#2c6fad'), spaceAfter=8))
refs = [
    "Government of India. (1940). <i>Drugs and Cosmetics Act, 1940</i>. Ministry of Health and Family Welfare.",
    "Government of India. (1945). <i>Drugs and Cosmetics Rules, 1945</i> (as amended up to 2024). Ministry of Health and Family Welfare.",
    "Government of India. (1948). <i>Pharmacy Act, 1948</i>. Pharmacy Council of India.",
    "Government of India. (1985). <i>Narcotic Drugs and Psychotropic Substances (NDPS) Act, 1985</i>. Ministry of Finance.",
    "Vibcare Pharma. (2026). <i>Retail and Wholesale Drug License in India: Required Documents.</i> Retrieved from vibcare.co.in.",
    "Drugs Control Department, Government of NCT of Delhi. (2024). <i>Procedures for Obtaining Licences.</i> Retrieved from drugs.delhi.gov.in.",
    "Patil, A., et al. (2025). Wholesale and Retail Pharmacy Market Structure and Performance. <i>International Journal of Research in Pharmaceutical and Biomedical Sciences (IJRPR)</i>, 6(1). doi:10.37181/IJRPR37531.",
    "World Health Organization & European Observatory. (2024). <i>Community Pharmacy Regulatory and Practice Models in Eastern Europe and Central Asia.</i> WHO Regional Office for Europe.",
    "Pharmacy Council of India. (2015). <i>Education Regulations and Good Pharmacy Practice Guidelines.</i> PCI, New Delhi.",
    "Narayana Murthy, C., & Reddy, K.V. (2023). <i>Textbook of Pharmacy Practice</i> (4th ed.). Pharma Book Syndicate, Hyderabad.",
]
for i, ref in enumerate(refs, 1):
    story.append(Paragraph(f"{i}.  {ref}", ref_style))

# ── BUILD ────────────────────────────────────────────────────────────────
doc.build(story)
print(f"PDF created: {OUTPUT}")

from docx import Document
from docx.shared import Pt, Inches, RGBColor, Cm
from docx.enum.text import WD_ALIGN_PARAGRAPH
from docx.enum.table import WD_TABLE_ALIGNMENT, WD_ALIGN_VERTICAL
from docx.oxml.ns import qn
from docx.oxml import OxmlElement
import copy

OUTPUT = "/tmp/workspace/pharmacy-assignment/Community_Pharmacy_Assignment.docx"

doc = Document()

# ── PAGE SETUP (A4) ──────────────────────────────────────────────────────
section = doc.sections[0]
section.page_width  = Cm(21)
section.page_height = Cm(29.7)
section.left_margin   = Cm(2.54)
section.right_margin  = Cm(2.54)
section.top_margin    = Cm(2.54)
section.bottom_margin = Cm(2.54)

# ── BASE FONT ─────────────────────────────────────────────────────────────
normal = doc.styles["Normal"]
normal.font.name = "Times New Roman"
normal.font.size = Pt(12)

# ── HEADING STYLES ────────────────────────────────────────────────────────
h1_style = doc.styles["Heading 1"]
h1_style.font.name = "Arial"
h1_style.font.size = Pt(14)
h1_style.font.bold = True
h1_style.font.color.rgb = RGBColor(0x1a, 0x3a, 0x5c)

h2_style = doc.styles["Heading 2"]
h2_style.font.name = "Arial"
h2_style.font.size = Pt(12)
h2_style.font.bold = True
h2_style.font.color.rgb = RGBColor(0x2c, 0x6f, 0xad)

h3_style = doc.styles["Heading 3"]
h3_style.font.name = "Arial"
h3_style.font.size = Pt(11)
h3_style.font.bold = True
h3_style.font.color.rgb = RGBColor(0x1a, 0x3a, 0x5c)

# ── HELPER: shade table header row ────────────────────────────────────────
def shade_cell(cell, fill_hex):
    tc = cell._tc
    tcPr = tc.get_or_add_tcPr()
    shd = OxmlElement("w:shd")
    shd.set(qn("w:val"), "clear")
    shd.set(qn("w:color"), "auto")
    shd.set(qn("w:fill"), fill_hex)
    tcPr.append(shd)

def add_table(doc, headers, rows, col_widths_cm=None):
    num_cols = len(headers)
    t = doc.add_table(rows=1 + len(rows), cols=num_cols)
    t.style = "Table Grid"
    t.alignment = WD_TABLE_ALIGNMENT.CENTER

    # Header row
    hdr_cells = t.rows[0].cells
    for i, h in enumerate(headers):
        hdr_cells[i].text = h
        hdr_cells[i].paragraphs[0].runs[0].bold = True
        hdr_cells[i].paragraphs[0].runs[0].font.color.rgb = RGBColor(0xFF, 0xFF, 0xFF)
        hdr_cells[i].paragraphs[0].alignment = WD_ALIGN_PARAGRAPH.CENTER
        shade_cell(hdr_cells[i], "1a3a5c")
        hdr_cells[i].vertical_alignment = WD_ALIGN_VERTICAL.CENTER

    # Data rows
    for r_idx, row_data in enumerate(rows):
        row_cells = t.rows[r_idx + 1].cells
        fill = "EAF1FB" if r_idx % 2 == 0 else "FFFFFF"
        for c_idx, val in enumerate(row_data):
            row_cells[c_idx].text = val
            shade_cell(row_cells[c_idx], fill)
            row_cells[c_idx].paragraphs[0].alignment = WD_ALIGN_PARAGRAPH.LEFT

    # Column widths
    if col_widths_cm:
        for row in t.rows:
            for i, cell in enumerate(row.cells):
                cell.width = Cm(col_widths_cm[i])

    doc.add_paragraph()  # spacing after table
    return t

def add_bullet(doc, text, level=0):
    p = doc.add_paragraph(style="List Bullet")
    p.paragraph_format.left_indent = Cm(0.6 * (level + 1))
    # Bold text before colon if present
    if ":" in text:
        parts = text.split(":", 1)
        run1 = p.add_run(parts[0] + ":")
        run1.bold = True
        run1.font.name = "Times New Roman"
        run1.font.size = Pt(12)
        run2 = p.add_run(parts[1])
        run2.font.name = "Times New Roman"
        run2.font.size = Pt(12)
    else:
        run = p.add_run(text)
        run.font.name = "Times New Roman"
        run.font.size = Pt(12)
    return p

def add_body(doc, text):
    p = doc.add_paragraph(text)
    p.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY
    pf = p.paragraph_format
    pf.first_line_indent = Cm(0.6)
    pf.space_after = Pt(6)
    for run in p.runs:
        run.font.name = "Times New Roman"
        run.font.size = Pt(12)
    return p

def add_body_nb(doc, text):
    """Body paragraph, no first-line indent."""
    p = doc.add_paragraph(text)
    p.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY
    p.paragraph_format.space_after = Pt(6)
    for run in p.runs:
        run.font.name = "Times New Roman"
        run.font.size = Pt(12)
    return p

def add_note(doc, text):
    p = doc.add_paragraph(text)
    p.alignment = WD_ALIGN_PARAGRAPH.CENTER
    for run in p.runs:
        run.font.name = "Times New Roman"
        run.font.size = Pt(10)
        run.font.italic = True
        run.font.color.rgb = RGBColor(0x55, 0x55, 0x55)
    return p

# ══════════════════════════════════════════════════════════════════════════
# COVER PAGE
# ══════════════════════════════════════════════════════════════════════════
p = doc.add_paragraph()
p.alignment = WD_ALIGN_PARAGRAPH.CENTER
p.paragraph_format.space_before = Pt(72)
run = p.add_run("ASSIGNMENT")
run.font.name = "Arial"
run.font.size = Pt(13)
run.font.bold = True
run.font.color.rgb = RGBColor(0x2c, 0x6f, 0xad)

p2 = doc.add_paragraph()
p2.alignment = WD_ALIGN_PARAGRAPH.CENTER
run2 = p2.add_run("Retail and Wholesale Community Pharmacies")
run2.font.name = "Arial"
run2.font.size = Pt(20)
run2.font.bold = True
run2.font.color.rgb = RGBColor(0x1a, 0x3a, 0x5c)

p3 = doc.add_paragraph()
p3.alignment = WD_ALIGN_PARAGRAPH.CENTER
run3 = p3.add_run(
    "A Comparative Study on Organization, Legal Requirements, Infrastructure,\n"
    "Record Maintenance, and Dispensing Practices"
)
run3.font.name = "Arial"
run3.font.size = Pt(12)
run3.font.color.rgb = RGBColor(0x2c, 0x6f, 0xad)

doc.add_paragraph()

cover_info = [
    ["Subject", "Pharmacy Practice"],
    ["Course", "B.Pharm / D.Pharm"],
    ["Topic", "Community Pharmacy"],
    ["Date", "July 2026"],
]
ct = doc.add_table(rows=4, cols=2)
ct.style = "Table Grid"
ct.alignment = WD_TABLE_ALIGNMENT.CENTER
for i, (k, v) in enumerate(cover_info):
    fill = "EAF1FB" if i % 2 == 0 else "FFFFFF"
    ct.rows[i].cells[0].text = k
    ct.rows[i].cells[0].paragraphs[0].runs[0].bold = True
    shade_cell(ct.rows[i].cells[0], fill)
    ct.rows[i].cells[1].text = v
    shade_cell(ct.rows[i].cells[1], fill)
    for cell in ct.rows[i].cells:
        for run in cell.paragraphs[0].runs:
            run.font.name = "Times New Roman"
            run.font.size = Pt(12)
        cell.width = Cm(5) if cell == ct.rows[i].cells[0] else Cm(9)

doc.add_page_break()

# ══════════════════════════════════════════════════════════════════════════
# TABLE OF CONTENTS (manual)
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("Table of Contents", level=1)

toc_entries = [
    ("1.", "Introduction"),
    ("2.", "Organization"),
    ("2.1", "Retail Pharmacy"),
    ("2.2", "Wholesale Pharmacy"),
    ("3.", "Legal Requirements"),
    ("3.1", "Governing Legislation"),
    ("3.2", "License Forms and Validity"),
    ("3.3", "Technical Personnel Requirements"),
    ("4.", "Infrastructure and Premises Requirements"),
    ("4.1", "Retail Pharmacy Infrastructure"),
    ("4.2", "Wholesale Pharmacy Infrastructure"),
    ("5.", "Record Maintenance"),
    ("5.1", "Records in Retail Pharmacy"),
    ("5.2", "Records in Wholesale Pharmacy"),
    ("6.", "Dispensing Practices"),
    ("6.1", "Dispensing in Retail Pharmacy"),
    ("6.2", "Supply Practices in Wholesale Pharmacy"),
    ("7.", "Comparative Summary Table"),
    ("8.", "Conclusion"),
    ("9.", "References"),
]
for num, title in toc_entries:
    p = doc.add_paragraph()
    indent = Cm(0) if "." not in num[:-1] else Cm(0.6)
    p.paragraph_format.left_indent = indent
    p.paragraph_format.space_after = Pt(2)
    r1 = p.add_run(f"{num}  {title}")
    r1.font.name = "Times New Roman"
    r1.font.size = Pt(11)
    if "." not in num[:-1]:
        r1.bold = True

doc.add_page_break()

# ══════════════════════════════════════════════════════════════════════════
# 1. INTRODUCTION
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("1. Introduction", level=1)

add_body(doc,
    'Community pharmacy is an integral component of the healthcare system, serving as the primary point '
    'of access where patients obtain medications, health advice, and related services. The term "community '
    'pharmacy" broadly encompasses all pharmacy establishments that operate in the community setting, as '
    'opposed to institutional pharmacies found within hospitals. Within community pharmacies, two distinct '
    'types exist based on the level at which drugs are supplied: retail pharmacies and wholesale pharmacies.'
)
add_body(doc,
    'A retail pharmacy (also called a chemist shop or dispensing chemist) directly serves patients and the '
    'general public. A wholesale pharmacy, by contrast, acts as an intermediary in the pharmaceutical supply '
    'chain, distributing drugs in bulk to retailers, hospitals, dispensaries, and other licensed entities. '
    'Both types are regulated under the Drugs and Cosmetics Act, 1940 and the Drugs and Cosmetics Rules, 1945 '
    'in India, and must comply with the Pharmacy Act, 1948, which governs the registration and conduct of pharmacists.'
)
add_body(doc,
    'This assignment provides a detailed comparison of retail and wholesale community pharmacies with respect '
    'to their organization, legal requirements, infrastructure, record maintenance, and dispensing or supply practices.'
)

# ══════════════════════════════════════════════════════════════════════════
# 2. ORGANIZATION
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("2. Organization", level=1)
doc.add_heading("2.1 Retail Pharmacy", level=2)

add_body(doc,
    'A retail pharmacy is the terminal point in the pharmaceutical supply chain. Its primary function is to '
    'dispense prescription and over-the-counter (OTC) medications directly to patients. The retail pharmacy '
    'occupies a patient-facing role and is therefore organized to facilitate direct interaction between the '
    'pharmacist and the consumer.'
)
add_body_nb(doc, "Key organizational features of a retail pharmacy include:")

for item in [
    "Proprietorship or Chain Model: A retail pharmacy may be run as a sole proprietorship, partnership firm, or as part of a chain (e.g., Apollo Pharmacy, MedPlus). Chain pharmacies benefit from centralized procurement and inventory management, giving them a competitive edge over independent pharmacies.",
    "Mandatory Registered Pharmacist: A registered pharmacist (holding a B.Pharm or D.Pharm degree and registered with the State Pharmacy Council) must be in charge and must be physically present during working hours. This is a statutory requirement under the Pharmacy Act, 1948.",
    "Product Range: Stock includes Rx (prescription) drugs, OTC drugs, Schedule H/H1/X drugs (dispensed only on prescription), Schedule C and C1 biological products (vaccines, insulin, sera), cosmetics, surgical accessories, and nutraceuticals.",
    "Patient Services: Beyond medication supply, modern retail pharmacies provide patient counselling, blood pressure and blood glucose monitoring, health education, and adherence support.",
    "Procurement: Retail pharmacies source drugs from wholesalers, authorized distributors, or directly from manufacturers. They maintain stock for immediate supply to walk-in customers.",
]:
    add_bullet(doc, item)

doc.add_heading("2.2 Wholesale Pharmacy", level=2)
add_body(doc,
    'A wholesale pharmacy serves as an intermediary distributor in the pharmaceutical supply chain. It procures '
    'drugs in large quantities from manufacturers or their authorized distributors and supplies them in bulk to '
    'retail pharmacies, hospitals, nursing homes, dispensaries, and other licensed healthcare establishments. '
    'It does not supply drugs directly to patients.'
)
add_body_nb(doc, "Key organizational features of a wholesale pharmacy include:")

for item in [
    "B2B (Business-to-Business) Model: All transactions are conducted with licensed entities (retailers, institutions). Supply to unlicensed persons or directly to patients is prohibited by law.",
    "Technical Person: A wholesale pharmacy may be managed by a registered pharmacist or a 'competent person' - defined as a graduate in science with at least one year of experience in drug dealing, or a person with an SSLC/matriculation certificate with at least four years of experience in dealing in drugs.",
    "PCD Franchise Link: A wholesale drug license (Forms 20B/21B) combined with GST registration is the complete legal requirement to operate a PCD (Propaganda-cum-Distribution) pharma franchise.",
    "Supply Chain Role: Wholesale pharmacies ensure a steady, uninterrupted supply of pharmaceuticals, manage buffer stock, and provide critical distribution logistics including cold-chain management.",
    "Bulk Procurement: Purchase is made directly from pharmaceutical manufacturers or their clearing and forwarding (C&F) agents at wholesale prices, with trade margins defined under pricing regulations.",
]:
    add_bullet(doc, item)

# ══════════════════════════════════════════════════════════════════════════
# 3. LEGAL REQUIREMENTS
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("3. Legal Requirements", level=1)
doc.add_heading("3.1 Governing Legislation", level=2)

add_body_nb(doc, "Both retail and wholesale community pharmacies in India are governed by a common framework of legislation:")

add_table(doc,
    ["Legislation", "Relevance"],
    [
        ["Drugs and Cosmetics Act, 1940 & Rules, 1945",
         "Primary law governing manufacture, distribution, sale, and quality of drugs. Prescribes license conditions for retail (Forms 20/21) and wholesale (Forms 20B/21B) operations."],
        ["Pharmacy Act, 1948",
         "Regulates the profession of pharmacy; mandates registration of pharmacists with State Pharmacy Councils; requires a registered pharmacist in charge of a retail pharmacy."],
        ["NDPS Act, 1985",
         "Governs narcotic drugs and psychotropic substances; requires additional licensing and strict record-keeping for Schedule X and narcotic substances."],
        ["Drugs (Prices Control) Order (DPCO)",
         "Controls the prices of essential medicines; both retail and wholesale entities must sell scheduled formulations at or below the ceiling price notified by NPPA."],
        ["Poisons Act",
         "Regulates the possession and sale of scheduled poisons (Schedule L drugs); applicable where the pharmacy stocks such substances."],
        ["GST Act, 2017",
         "Mandates GST registration for businesses above the threshold turnover; applicable to all pharmacies for billing and tax compliance."],
    ],
    col_widths_cm=[5.5, 10.0]
)

doc.add_heading("3.2 License Forms, Application, and Validity", level=2)
add_body(doc,
    'The Drugs and Cosmetics Rules, 1945 prescribe specific forms for applying and receiving drug licenses. '
    'The common application form is Form 19 for both retail and wholesale. Licenses are issued by the '
    'State Licensing Authority (State Drugs Control Organisation) after an inspection of the premises by a Drug Inspector.'
)

add_table(doc,
    ["Parameter", "Retail Pharmacy", "Wholesale Pharmacy"],
    [
        ["Application Form", "Form 19", "Form 19"],
        ["License Form (General Allopathic)", "Form 20", "Form 20B"],
        ["License Form (Schedule C & C1 drugs)", "Form 21", "Form 21B"],
        ["License Form (Homoeopathic)", "Form 20C", "Form 20D"],
        ["Issuing Authority", "State Licensing Authority", "State Licensing Authority"],
        ["License Validity", "Perpetual (2024 amendment); retention fee every 5 years", "Perpetual; retention fee every 5 years"],
        ["Inspection", "Drug Inspector visits premises", "Drug Inspector visits premises"],
        ["Schedule X Drugs", "Additional endorsement needed", "Separate sub-license required"],
    ],
    col_widths_cm=[5.0, 5.5, 5.0]
)
add_note(doc, "Note: Prior to the 2024 amendment to Rule 63, licenses required renewal every five years. They are now valid in perpetuity, subject to payment of a retention fee every five years.")

doc.add_heading("3.3 Technical Personnel Requirements", level=2)
add_body_nb(doc, "The qualification of the person in charge is one of the most important legal distinctions:")

for item in [
    "Retail Pharmacy: Must be under the charge of a Registered Pharmacist - i.e., a person holding a B.Pharm or D.Pharm degree from a recognized university and registered with the State Pharmacy Council. The pharmacist must be present during business hours. In their absence, drug sales cannot be carried out legally.",
    "Wholesale Pharmacy: May be managed by a Registered Pharmacist OR a 'Competent Person' - defined as (a) a graduate in science, commerce, or arts with a minimum of one year's experience in dealing in drugs, OR (b) a person who has passed the SSLC/matriculation examination and has at least four years' experience in dealing in drugs.",
    "Schedule X / Narcotic Control: For both types, handling of Schedule X drugs and narcotic substances requires additional record-keeping and adherence to NDPS Act provisions.",
]:
    add_bullet(doc, item)

# ══════════════════════════════════════════════════════════════════════════
# 4. INFRASTRUCTURE
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("4. Infrastructure and Premises Requirements", level=1)
doc.add_heading("4.1 Retail Pharmacy Infrastructure", level=2)

add_body(doc,
    'The premises of a retail pharmacy are designed to facilitate patient-facing dispensing and counselling, '
    'while ensuring safe storage of medicines. The Drugs and Cosmetics Rules specify minimum physical requirements:'
)

for item in [
    "Minimum Area: The premises must have a minimum floor area of 10 square metres for a retail license alone (Form 20 or Form 21). If both retail and wholesale licenses are held at the same premises, the minimum area is 15 square metres. Ceiling height must comply with the National Building Code of India, 2005.",
    "Dispensing Counter: A counter separating the pharmacist's working area from the patient/customer area; medicines are handed over at the counter after dispensing.",
    "Storage Shelves and Racks: Adequate shelving for systematic storage and display of OTC products, vitamins, health supplements, and general drugs stored under conditions specified on the label.",
    "Refrigerator (Mandatory): A functional refrigerator is compulsory and proof of its purchase must be submitted at licensing. Required for storing cold-chain items such as vaccines, insulin, and Schedule C & C1 drugs at 2-8 degrees C.",
    "Locked Cabinet for Schedule X/H1: Schedule X (habit-forming) drugs must be stored in a separate locked cabinet and dispensed only on prescription.",
    "Poison Cupboard: If the pharmacy stocks Schedule L (poisons), a separate locked cupboard is mandatory.",
    "Lighting and Ventilation: Adequate natural or artificial lighting and proper ventilation to prevent drug degradation. GPP guidelines recommend air-conditioned storage for temperature-sensitive drugs.",
    "Counselling Area: GPP guidelines recommend a dedicated consultation/counselling area for patient privacy.",
    "Emergency Kit: Some regulations recommend maintaining a basic emergency drug kit (adrenaline, antihistamines) at the pharmacy.",
]:
    add_bullet(doc, item)

doc.add_heading("4.2 Wholesale Pharmacy Infrastructure", level=2)
add_body(doc,
    'The infrastructure of a wholesale pharmacy is oriented towards bulk storage, quality assurance, and '
    'efficient logistics rather than patient-facing services:'
)

for item in [
    "Minimum Area: Minimum floor area of 10 square metres for a wholesale license alone; 15 square metres if combined with a retail license. In practice, most wholesale outlets occupy significantly larger spaces.",
    "Dry Storage Area: Large shelving/racking systems for organized bulk inventory storage. Good Distribution Practice (GDP) guidelines require FEFO (First Expiry First Out) stock rotation.",
    "Cold Storage / Walk-in Refrigeration: For biologicals, vaccines, insulin, and other temperature-sensitive items, with continuous temperature monitoring and logging.",
    "Quarantine Area: A designated area for goods pending quality check, damaged goods, near-expiry stock, and recalled products - segregated from saleable stock.",
    "Receiving and Dispatch Area: Separate zones for inward consignments and outward supply, facilitating smooth logistics.",
    "Office Area: For maintaining purchase-sale registers, invoices, and mandatory records.",
    "Security: Premises must be secured to prevent pilferage, especially for Schedule H, H1, and X drugs.",
    "No Customer Counter Required: Wholesale premises do not require a patient-facing dispensing counter. Operations are entirely B2B.",
]:
    add_bullet(doc, item)

# ══════════════════════════════════════════════════════════════════════════
# 5. RECORD MAINTENANCE
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("5. Record Maintenance", level=1)

add_body(doc,
    'Accurate and complete record keeping is a statutory obligation for all licensed drug premises under '
    'Rules 65 and 67 of the Drugs and Cosmetics Rules, 1945. Records must be available for inspection by '
    'Drug Inspectors under Section 22 of the Drugs and Cosmetics Act, 1940.'
)

doc.add_heading("5.1 Records in Retail Pharmacy", level=2)

add_table(doc,
    ["Register / Record", "Contents", "Retention Period"],
    [
        ["Prescription Register",
         "Patient name and address; prescriber name, designation & reg. no.; drug name, form, dose, quantity dispensed; date of dispensing",
         "Min. 3 years"],
        ["Schedule H1 Register",
         "Mandatory separate register for Schedule H1 drugs (newer antibiotics, anti-TB drugs). Prescription details must be entered by the pharmacist.",
         "3 years"],
        ["Schedule X Register",
         "Separate register for habit-forming/psychotropic drugs (Schedule X); quantities purchased and sold.",
         "2 years"],
        ["Narcotic Substances Register",
         "For narcotic drugs under NDPS Act; strict account of receipts, sales, and balance.",
         "3 years"],
        ["Purchase / Stock Register",
         "Supplier name, invoice number, drug name, batch number, manufacturing date, expiry date, quantity received, balance.",
         "5 years (GST)"],
        ["Sales Register",
         "Daily record of all drug sales - OTC and Rx.",
         "As per Rules"],
        ["Cold-chain / Temperature Log",
         "Daily max and min refrigerator temperature; deviations and corrective actions.",
         "As per Rules"],
        ["Prescription Copies",
         "A copy (or original) of each Schedule H/H1/X prescription retained by the pharmacist at time of dispensing.",
         "3 years"],
    ],
    col_widths_cm=[4.2, 8.3, 3.0]
)

doc.add_heading("5.2 Records in Wholesale Pharmacy", level=2)

add_table(doc,
    ["Register / Record", "Contents", "Retention Period"],
    [
        ["Purchase / Inward Register",
         "Supplier name, invoice no., drug name, batch number, manufacturing date, expiry date, quantity received, storage conditions.",
         "5 years"],
        ["Sales / Outward Register",
         "Customer name, drug license number of buyer, drug name, batch no., quantity supplied, invoice number, date.",
         "5 years"],
        ["Running Stock Register",
         "Opening stock, receipts, issues, and closing balance for each product and batch; FEFO compliance.",
         "5 years"],
        ["Schedule H/H1 Sales Register",
         "Restricted-drug sales recorded separately; supply only to licensed retailers/institutions.",
         "3 years"],
        ["Schedule X / Narcotic Register",
         "Batch-level records of purchase and sale; supply only to licensed buyers.",
         "3 years"],
        ["Batch Traceability Records",
         "Batch numbers, expiry dates, and supplier details for all products - essential for product recall management.",
         "5 years"],
        ["Temperature / Cold-chain Logs",
         "Continuous temperature monitoring for refrigerated and frozen products.",
         "As per Rules"],
        ["Delivery Challans / Tax Invoices",
         "GST-compliant invoices for all outward supplies; linked to e-Way bills for interstate movement.",
         "6 years (GST)"],
    ],
    col_widths_cm=[4.2, 8.3, 3.0]
)

# ══════════════════════════════════════════════════════════════════════════
# 6. DISPENSING PRACTICES
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("6. Dispensing Practices", level=1)
doc.add_heading("6.1 Dispensing in Retail Pharmacy", level=2)

add_body(doc,
    'Dispensing is the core professional function of a retail pharmacy. It is defined as the act of '
    'interpreting a prescription and preparing and delivering a medicine to a patient along with the '
    'information needed for its safe and effective use. The process involves the following steps:'
)

steps = [
    ("Step 1 - Receiving and Validating the Prescription",
     "The pharmacist checks for completeness: prescriber's name, qualification, registration number, address; patient name, age, weight (for children); drug name, dose, dosage form, frequency, duration, date, and prescriber's signature. Schedule H/H1/X prescriptions require special attention."),
    ("Step 2 - Pharmaceutical Analysis",
     "The pharmacist verifies drug-dose appropriateness, checks for drug-drug interactions, drug-disease contraindications, drug allergies, and therapeutic duplications. Dose calculation errors, especially in paediatric and geriatric prescriptions, are flagged."),
    ("Step 3 - Preparing and Labelling",
     "The correct drug in the correct dosage form and strength is retrieved and counted/measured. A dispensing label is prepared bearing: patient name, drug name and strength, dosage and frequency, route of administration, duration, storage instructions, dispensing date, and expiry date."),
    ("Step 4 - Dispensing and Handing Over",
     "The dispensed medication is handed to the patient after confirming identity. The pharmacist explains how to take the medication, common side effects, and storage requirements."),
    ("Step 5 - Patient Counselling",
     "The pharmacist advises the patient on the use of the medication, potential side effects, interaction with food/alcohol, missed dose policy, and need for follow-up. This directly impacts medication adherence and therapeutic outcomes."),
    ("Step 6 - Record Entry",
     "Dispensing details are entered in the prescription register. For Schedule H1 drugs, details are also entered in the dedicated H1 register. A copy of the prescription is retained."),
]
for title, detail in steps:
    p = doc.add_paragraph(style="List Bullet")
    p.paragraph_format.left_indent = Cm(0.6)
    r1 = p.add_run(title + ":  ")
    r1.bold = True
    r1.font.name = "Times New Roman"
    r1.font.size = Pt(12)
    r2 = p.add_run(detail)
    r2.font.name = "Times New Roman"
    r2.font.size = Pt(12)

doc.add_heading("Special Dispensing Rules:", level=3)
for item in [
    "Schedule H drugs can only be dispensed against a valid prescription from a Registered Medical Practitioner (RMP). The pharmacist must record the details and retain the prescription.",
    "Schedule H1 drugs (specified antibiotics, anti-TB drugs, and drugs liable to abuse) require entry in a separate H1 register with prescription details; the prescription must be retained for three years.",
    "Schedule X drugs must be dispensed only against a prescription in duplicate; one copy is retained by the pharmacist for two years.",
    "OTC (non-scheduled) drugs may be sold without a prescription, but responsible pharmacy practice includes basic counselling.",
    "Partial dispensing is permitted when the full quantity is unavailable; the remaining quantity is noted on the prescription and the patient is informed.",
    "Generic substitution: Pharmacists may substitute a branded drug with a generic equivalent (same active ingredient, dose, and form) unless the prescriber has indicated 'no substitution'.",
]:
    add_bullet(doc, item)

doc.add_heading("6.2 Supply Practices in Wholesale Pharmacy", level=2)
add_body(doc,
    'A wholesale pharmacy does not dispense drugs in the clinical sense. Its function is bulk distribution - '
    'supplying drugs to licensed buyers based on purchase orders. The process involves:'
)

for item in [
    "Order Processing: Purchase orders received from licensed retailers, hospitals, or dispensaries are verified for validity of the buyer's drug license.",
    "Quality Check on Inward Stock: All incoming consignments are checked for proper labelling, intact packaging, valid batch numbers, manufacturing dates, and expiry dates. Damaged or near-expiry goods are quarantined.",
    "Picking and Packing: Orders are picked from stock following the FEFO (First Expiry First Out) principle. Products are packed for dispatch with proper documentation.",
    "Invoice and Documentation: A GST-compliant tax invoice (with drug license number, batch number, expiry date, quantity, and rate) is prepared for every outward supply.",
    "Cold-chain Dispatch: Temperature-sensitive products are dispatched in cold boxes or refrigerated vehicles with temperature monitoring.",
    "Restricted Drug Controls: Schedule H, H1, and X drugs can only be supplied to licensed retail pharmacies or institutions; wholesale pharmacies cannot supply these directly to patients.",
    "Pricing: Drugs are sold at prices that include the permissible trade margin as per DPCO; the final MRP printed on the pack cannot be exceeded.",
    "No Patient Counselling: Unlike retail pharmacies, wholesale pharmacies have no counselling or patient-care function. Their interaction is purely commercial.",
]:
    add_bullet(doc, item)

# ══════════════════════════════════════════════════════════════════════════
# 7. COMPARATIVE SUMMARY TABLE
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("7. Comparative Summary Table", level=1)

add_table(doc,
    ["Feature", "Retail Pharmacy", "Wholesale Pharmacy"],
    [
        ["Primary Function", "Dispensing drugs to patients", "Bulk distribution to licensed trade"],
        ["Customer/Client", "Patients, general public", "Retailers, hospitals, dispensaries"],
        ["License Forms", "Form 20, Form 21", "Form 20B, Form 21B"],
        ["Application Form", "Form 19", "Form 19"],
        ["Issuing Authority", "State Drugs Control Organisation", "State Drugs Control Organisation"],
        ["Technical Person", "Registered Pharmacist (mandatory)", "Pharmacist OR Competent Person"],
        ["Minimum Area", "10 sq m (15 sq m if combined)", "10 sq m (15 sq m if combined)"],
        ["Key Infrastructure", "Dispensing counter, refrigerator, locked cabinet for Sch-X", "Bulk racks, cold storage, quarantine area, dispatch zone"],
        ["Patient Counselling", "Yes - mandatory professional duty", "Not applicable"],
        ["Key Records", "Prescription register, Sch H1/X registers, purchase-sales register", "Purchase-sales-stock register, batch traceability records, tax invoices"],
        ["Schedule H1 Register", "Mandatory", "Not required"],
        ["Schedule X Dispensing", "To patients on prescription only", "To licensed retailers/institutions only"],
        ["Direct Patient Supply", "Yes", "Not permitted"],
        ["Pricing Control", "DPCO ceiling price; MRP to consumers", "Trade margin rules; DPCO compliant"],
        ["Dispensing Label", "Mandatory for each dispensed item", "Not applicable"],
        ["GST Compliance", "Required above threshold", "Required above threshold"],
    ],
    col_widths_cm=[4.5, 5.8, 5.2]
)

# ══════════════════════════════════════════════════════════════════════════
# 8. CONCLUSION
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("8. Conclusion", level=1)

add_body(doc,
    'Retail and wholesale community pharmacies play complementary but distinct roles in the pharmaceutical '
    'healthcare system. The retail pharmacy is the face of pharmacy practice - it is where professional '
    'pharmacist-patient interaction occurs, where prescriptions are interpreted and dispensed, and where '
    'patients receive guidance on medication use. The wholesale pharmacy, on the other hand, is the backbone '
    'of the pharmaceutical supply chain, ensuring that drugs manufactured at factories reach retail pharmacies, '
    'hospitals, and health facilities in adequate quantities, at the right time, and under proper storage conditions.'
)
add_body(doc,
    'Both types of pharmacies are governed by the same primary legislation - the Drugs and Cosmetics Act, 1940 '
    '- but differ in the forms of licenses required, the qualifications of the person in charge, the nature of '
    'their premises, the records they must maintain, and the manner in which drugs are supplied. Understanding '
    'these differences is fundamental to pharmacy practice and is essential for any pharmacist seeking to '
    'establish, manage, or inspect a community pharmacy establishment.'
)
add_body(doc,
    'Good Pharmacy Practice (GPP) standards, as recommended by the WHO and the Pharmacy Council of India, '
    'apply primarily to retail pharmacies and emphasize the central role of the pharmacist in patient care, '
    'medication counselling, and safe dispensing. Wholesale pharmacies must adhere to Good Distribution '
    'Practice (GDP) standards to ensure the integrity and traceability of the drug supply chain.'
)

# ══════════════════════════════════════════════════════════════════════════
# 9. REFERENCES
# ══════════════════════════════════════════════════════════════════════════
doc.add_heading("9. References", level=1)

refs = [
    "Government of India. (1940). Drugs and Cosmetics Act, 1940. Ministry of Health and Family Welfare.",
    "Government of India. (1945). Drugs and Cosmetics Rules, 1945 (as amended up to 2024). Ministry of Health and Family Welfare.",
    "Government of India. (1948). Pharmacy Act, 1948. Pharmacy Council of India.",
    "Government of India. (1985). Narcotic Drugs and Psychotropic Substances (NDPS) Act, 1985. Ministry of Finance.",
    "Vibcare Pharma. (2026). Retail and Wholesale Drug License in India: Required Documents. Retrieved from vibcare.co.in.",
    "Drugs Control Department, Government of NCT of Delhi. (2024). Procedures for Obtaining Licences. Retrieved from drugs.delhi.gov.in.",
    "Patil, A., et al. (2025). Wholesale and Retail Pharmacy Market Structure and Performance. International Journal of Research in Pharmaceutical and Biomedical Sciences (IJRPR), 6(1).",
    "World Health Organization. (2024). Community Pharmacy Regulatory and Practice Models in Eastern Europe and Central Asia. WHO Regional Office for Europe.",
    "Pharmacy Council of India. (2015). Good Pharmacy Practice Guidelines. PCI, New Delhi.",
    "Narayana Murthy, C., & Reddy, K.V. (2023). Textbook of Pharmacy Practice (4th ed.). Pharma Book Syndicate, Hyderabad.",
]
for i, ref in enumerate(refs, 1):
    p = doc.add_paragraph(style="List Number")
    p.paragraph_format.left_indent = Cm(0.6)
    p.paragraph_format.space_after = Pt(4)
    run = p.add_run(ref)
    run.font.name = "Times New Roman"
    run.font.size = Pt(11)

# ── SAVE ──────────────────────────────────────────────────────────────────
doc.save(OUTPUT)
print(f"Saved: {OUTPUT}")