$_GET['filename'] = ''; $_GET['pdftype'] = 'onlyheader'; include("../pdfimp2.php"); $html = ""; // Initialize HTML $output = array(); $sql = "SELECT * FROM WO_bmr_process a WHERE a.product_code='" . $_GET['product_code'] . "' AND a.batch_number='" . $_GET['batch_number'] . "' AND a.work_order_no='" . $_GET['work_order_no'] . "' ORDER BY a.id DESC"; $result = $conn->query($sql); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $sql22="select *, a.product_name as productName ,c.entry_date as batchStartDate from product a left join batch_planning b on a.product_code=b.product_code left join mfg_work_order_hdr c on b.id=c.batch_plan_id WHERE a.product_code='" . $_GET['product_code'] . "' AND c.batch_number='" . $_GET['batch_number'] . "' AND c.work_order_no='" . $_GET['work_order_no'] . "' "; $result22 = $conn->query($sql22); if ($result22->num_rows > 0) { while ($row22 = $result22->fetch_assoc()) { $labelClaimData = json_decode($row22['label_claim'], true); // Decode JSON string $html.='

1. GENERAL INFORMATION

'; $html .= ''; $html .= '

GENERIC / PRODUCT NAME		' .$row22['productName']. '
LABEL CLAIM		'; if (!empty($labelClaimData)) { foreach ($labelClaimData as $item) { $html .= $item['material_name'] . ' - ' . $item['strength'] . ' ' . $item['unit'] . ' per ' . $item['dose_unit_qty'] . ' ' . $item['dose_unit_qty_unit'] . ' '; } } else { $html .= 'NA'; } $html .= '
STORAGE CONDITION		' .$row22['storage_condition']. '
PRODUCT APPEARANCE		' .$row22['apperance']. '
CHANGE CONTROL NUMBER		VERSION No:	00	EFFECTIVE DATE
		SUPERSEDES:	NA
PROCESS DETAILS		STANDARD BATCH SIZE:' .$row22['batch_size']. '			BATCH DETAILS
Date Started:	' .$row22['batchStartDate']. '				Batch No.:	' .$row22['batch_number']. '
Date Completed:					Manufacturing Date:
Total Days:					Expiry Date:
Generic Code:	' .$row22['genericProductCode']. '				Shelf Life	' .$row22['shelf_life']. '
MFR No.	' .$row22['mfr_no']. '	Manufacturing Location: ZUMA PHARMA LLC Parkent, Tashkent, Uzbekistan			Effective Batch No:	' .$row22['batch_number']. '

*Shelf life is tentative and shall be ascertained based on Accelerated and real-time stability data.

**If the filled weight (Limit: ............. to ............ )

MAH Approval

BMR ISSUED BY (QA)	BMR RECEIVED BY (PRODUCTION)

SIGN & DATE	SIGN & DATE
BMR RETURNED BY (PRODUCTION)	BMR RECEIVED BY (QA)

SIGN & DATE	SIGN & DATE

'; } } // Fetch all stages for the work_order_id $sqlTOC = "SELECT * FROM WO_bmr_process_stage WHERE WO_bmr_process_ID = '".$row["id"]."' ORDER BY id ASC"; $resultTOC = $conn->query($sqlTOC); // Initialize TOC $html .= '

2. Table of Content

'; $html .= ''; $html .= ''; $html .= ''; if ($resultTOC->num_rows > 0) { $tocIndex = 1; while ($tocRow = $resultTOC->fetch_assoc()) { $html .= ''; $html .= ''; $html .= ''; $html .= ''; $tocIndex++; } } else { $html .= ''; } $html .= '

S. No.	Content
' . $tocIndex . '	' . htmlspecialchars($tocRow['stages']) . '
No stages found.

'; $htmlBlocks = []; $sql2 = "SELECT * FROM WO_bmr_process_stage WHERE WO_bmr_process_ID = '".$row["id"]."' ORDER BY id ASC"; $result2 = $conn->query($sql2); if ($result2->num_rows > 0) { $stageIndex = 3; while ($row2 = $result2->fetch_assoc()) { $html .= '
'."

".$stageIndex.".)". $row2['stages']."

$stepNumber: ".$row3['step']."

If Inhaled::' . htmlspecialchars($row3['data'][0]['inhaled'] ?? '-') . '

In case of skin contact::' . htmlspecialchars($row3['data'][0]['skinContact'] ?? '-') . '

In case of eye contact::' . htmlspecialchars($row3['data'][0]['eyeContact'] ?? '-') . '

If swallowed::' . htmlspecialchars($row3['data'][0]['swallowed'] ?? '-') . '

Sr. No.	Material Code	Ingredients	Specification / Grade	Quantity (mg/ml)	Quantity (mg/vial)	Quantity (Kg/batch)
' . ($index + 1) . '	' . htmlspecialchars($item['material_code'] ?? '-') . '	' . htmlspecialchars($item['material_name'] ?? '-') . '	' . htmlspecialchars($item['grade'] ?? '-') . '	' . htmlspecialchars($item['qty'] ?? '-') . '	' . htmlspecialchars($item['total_qty'] ?? '-') . '	' . htmlspecialchars($item['Qty2'] ?? '-') . '

Sr. No.	Item Code Number	Primary Packing Material	Grade	Manufacturer	Unit	Standard Quantity	Quantity with 5% Excess
' . ($index + 1) . '	' . htmlspecialchars($item['material_code'] ?? '-') . '	' . htmlspecialchars($item['material_name'] ?? '-') . '	' . htmlspecialchars($item['gradeName'] ?? '-') . '	NA	' . htmlspecialchars($item['unit_name'] ?? '-') . '	' . htmlspecialchars($item['qty'] ?? '-') . '	' . htmlspecialchars($item['total_qty'] ?? '-') . '

General Instruction ' . htmlspecialchars($general_instruction ?? '-') . '

' . htmlspecialchars($data['general_instruction'] ?? '-') . '

Sr. No.	Name of the Person	Employee Code	Department
' . ($index + 1) . '	' . htmlspecialchars($data['emp_name'] ?? '-') . '	' . htmlspecialchars($data['emp_id'] ?? '-') . '	' . htmlspecialchars($data['department'] ?? '-') . '

Sr. NO.	EQUIPMENT NAME	MAKE	EQUIPMENT I.D.
' . ($index + 1) . '	' . htmlspecialchars($data['equipment_name'] ?? '-') . '	' . htmlspecialchars($data['make'] ?? '-') . '	' . htmlspecialchars($data['equipment_code'] ?? '-') . '

Sr. No	Item Code	Material Description	Specification	UOM	Standard Qty./Batch	Vendor	Issued by Stores (Sign/Date)
' . ($i + 1) . '	' . htmlspecialchars($item['material_code'] ?? '-') . '	' . htmlspecialchars($item['material_name'] ?? '-') . '	NA	' . htmlspecialchars($item['unit_name'] ?? '-') . '	' . htmlspecialchars($item['total_qty'] ?? '-') . '	' . htmlspecialchars($item['Vendor'] ?? '-') . '	' . htmlspecialchars($item['Store_personName'] ?? '-') . '

' . htmlspecialchars($data['general_instruction'] ?? '-') . '

Sr. No.	Item	Cleaning Time From (HH:MM)	Cleaning Time To (HH:MM)	Cleaning Duration	Done By	Checked By (Prod.)	Remark
' . ($i + 1) . '	' . htmlspecialchars($data['item'] ?? '-') . '	' . htmlspecialchars($data['cleaning_from'] ?? '-') . '	' . htmlspecialchars($data['cleaning_to'] ?? '-') . '	' . htmlspecialchars($data['duration'] ?? '-') . '	' . htmlspecialchars($data['done_by'] ?? '-') . '	' . htmlspecialchars($data['checked_by'] ?? '-') . '	' . htmlspecialchars($data['remark'] ?? '-') . '

Sr. No.	Item	Cleaning Time From (HH:MM)	Cleaning Time To (HH:MM)	Cleaning Duration	Done By	Checked By (Prod.)	Remark
' . ($i + 1) . '	' . htmlspecialchars($data['item'] ?? '-') . '	' . htmlspecialchars($data['cleaning_from'] ?? '-') . '	' . htmlspecialchars($data['cleaning_to'] ?? '-') . '	' . htmlspecialchars($data['duration'] ?? '-') . '	' . htmlspecialchars($data['done_by'] ?? '-') . '	' . htmlspecialchars($data['checked_by'] ?? '-') . '	' . htmlspecialchars($data['remark'] ?? '-') . '

Sr. No.	Filter Description	Make	Catalogue No.	Lot No. / Sr. No.	Location	Eq. ID	Test to be performed	Limit	Activity Date	From	To	Result* (Pass / Fail)	Done By (Prod)	Checked By (Prod)	Verified By IPQA
' . ($i + 1) . '	' . htmlspecialchars($data['filterDesc'] ?? '-') . '	' . htmlspecialchars($data['make'] ?? '-') . '	' . htmlspecialchars($data['catalogueNo'] ?? '-') . '	' . htmlspecialchars($data['lotNo'] ?? '-') . '	' . htmlspecialchars($data['location'] ?? '-') . '	' . htmlspecialchars($data['eqId'] ?? '-') . '	' . htmlspecialchars($data['test'] ?? '-') . '	' . htmlspecialchars($data['limit'] ?? '-') . '	' . htmlspecialchars($data['activityDate'] ?? '-') . '	' . htmlspecialchars($data['from'] ?? '-') . '	' . htmlspecialchars($data['to'] ?? '-') . '	' . htmlspecialchars($data['result'] ?? '-') . '	' . htmlspecialchars($data['doneBy'] ?? '-') . '	' . htmlspecialchars($data['checkedBy'] ?? '-') . '	' . htmlspecialchars($data['verifiedBy'] ?? '-') . '

Room Name:	' . htmlspecialchars($selectedStepsdatas['roomName'] ?? '-') . '
Room ID:	' . htmlspecialchars($selectedStepsdatas['roomId'] ?? '-') . '
Clearance for Product:	' . htmlspecialchars($selectedStepsdatas['clearanceProduct'] ?? '-') . '
Batch No.:	' . htmlspecialchars($selectedStepsdatas['batchNoCurrent'] ?? '-') . '
Previous Product:	' . htmlspecialchars($selectedStepsdatas['previousProduct'] ?? '-') . '
Batch No. (Previous):	' . htmlspecialchars($selectedStepsdatas['batchNoPrevious'] ?? '-') . '
Date & Time of Line Clearance:	' . htmlspecialchars($selectedStepsdatas['lineClearanceDateTime'] ?? '-') . '

Line Clearance Activities:

Sr. No.	Activity	Remark
' . ($index + 1) . '	' . htmlspecialchars($line['activity'] ?? '-') . '	' . htmlspecialchars($line['remark'] ?? '-') . '
No Line Clearance Data Found

Date	Load Pattern No.	Description	Run No.	Cycle Start Time (Hrs.)	Sterilization Hold Time (From)	Sterilization Hold Time (To)	Cycle End Time (Hrs.)	Checked by (Sign/date)	Verified by IPQA (Sign/date)
' . htmlspecialchars($data['date'] ?? '-') . '	' . htmlspecialchars($data['loadPatternNo'] ?? '-') . '	' . htmlspecialchars($data['description'] ?? '-') . '	' . htmlspecialchars($data['runNo'] ?? '-') . '	' . htmlspecialchars($data['cycleStartTime'] ?? '-') . '	' . htmlspecialchars($data['holdTimeFrom'] ?? '-') . '	' . htmlspecialchars($data['holdTimeTo'] ?? '-') . '	' . htmlspecialchars($data['cycleEndTime'] ?? '-') . '	' . htmlspecialchars($data['checkedBy'] ?? '-') . '	' . htmlspecialchars($data['verifiedBy'] ?? '-') . '

Rubber stopper and aluminium flip off seal bags should be checked. If any damage or leakage is observed, the bag shall be rejected.

Quantity of Rubber stoppers to be sterilized:	' . htmlspecialchars($selectedStepsdatas["QualityRubberStoper"] ?? '-') . '
Quantity of aluminium flip off seal to be sterilized:	' . htmlspecialchars($selectedStepsdatas["QualityAluminiumFlip"] ?? '-') . '

Record the cycle detail in below table:

Date	Load Pattern No.	Description	Run No.	Cycle Start Time (Hrs.)	Sterilization Hold Time (From)	Sterilization Hold Time (To)	Cycle End Time (Hrs.)	Checked by (Sign/date)	Verified by IPQA (Sign/date)
' . htmlspecialchars($row['date'] ?? '-') . '	' . htmlspecialchars($row['loadPatternNo'] ?? '-') . '	' . htmlspecialchars($row['description'] ?? '-') . '	' . htmlspecialchars($row['runNo'] ?? '-') . '	' . htmlspecialchars($row['cycleStartTime'] ?? '-') . '	' . htmlspecialchars($row['holdTimeFrom'] ?? '-') . '	' . htmlspecialchars($row['holdTimeTo'] ?? '-') . '	' . htmlspecialchars($row['cycleEndTime'] ?? '-') . '	' . htmlspecialchars($row['checkedBy'] ?? '-') . '	' . htmlspecialchars($row['verifiedBy'] ?? '-') . '
No sterilization cycle data available

Date	No. of Trays/ Packs	Actual Quantity	No. of Rejections	Time From	Time To	Done By Production	Checked By Production (Sign/Date)
' . htmlspecialchars($row['date'] ?? '-') . '	' . htmlspecialchars($row['noOfTraysPacks'] ?? '-') . '	' . htmlspecialchars($row['actualQty'] ?? '-') . '	' . htmlspecialchars($row['noOfRejections'] ?? '-') . '	' . htmlspecialchars($row['timeFrom'] ?? '-') . '	' . htmlspecialchars($row['timeTo'] ?? '-') . '	' . htmlspecialchars($row['doneByProduction'] ?? '-') . '	' . htmlspecialchars($row['checkedByProduction'] ?? '-') . '
No records available

Vial Washing Activity

Washing Start: ' . htmlspecialchars($selectedStepsdatas["Washing_startDate"] ?? '-') . '

Washing End: ' . htmlspecialchars($selectedStepsdatas["Washing_endDate"] ?? '-') . '

Check and ensure filter integrity of 0.2µ filters used for compressed air and WFI in vial washing machine.

Integrity of the filters shall be done as per SOP No. SOP/PR/010.

Filter Integrity Record

Filter Location	Filter Type	Integrity Done On	Done By Production (Name)	Checked By Production (Sign & Date)	Verified By IPQA (Sign & Date)
' . htmlspecialchars($data["filterLocation"] ?? '-') . '	' . htmlspecialchars($data["filterType"] ?? '-') . '	' . htmlspecialchars($data["integrityDoneOn"] ?? '-') . '	' . htmlspecialchars($data["doneByProduction"] ?? '-') . '	' . htmlspecialchars($data["checkedByProduction"] ?? '-') . '	' . htmlspecialchars($data["verifiedByIPQA"] ?? '-') . '

Operator Setting – Vial Washing

Date/Time	Recycled Water Pressure (NLT 2.0 kg/cm²)	Purified Water Pressure (NLT 2.0 kg/cm²)	WFI Pressure (NLT 2.0 kg/cm²)	Compressed Air Pressure (NLT 2.5 kg/cm²)	Needle Centering	Machine Speed (30 Vials/min)	Checked By (Sign/Date/Dept.)
' . htmlspecialchars($data["dateTime"] ?? '-') . '	' . htmlspecialchars($data["recycledWaterPressure"] ?? '-') . '	' . htmlspecialchars($data["purifiedWaterPressure"] ?? '-') . '	' . htmlspecialchars($data["wfiPressure"] ?? '-') . '	' . htmlspecialchars($data["compressedAirPressure"] ?? '-') . '	' . htmlspecialchars($data["needleCentering"] ?? '-') . '	' . htmlspecialchars($data["machineSpeed"] ?? '-') . '	' . htmlspecialchars($data["checkedBy"] ?? '-') . '

Vial Washing In-Process Check

Date	Time	Recycled Water Pressure (NLT 2.0 Kg/cm²)	WFI Limit Pressure (NLT 2.0 Kg/cm²)	Compressed Air Pressure (NLT 2.5 Kg/cm²)	Clarity of WFI (Shall be Clear)	Total No. of Vials for In Process	BP	FIBRES	GP	Broken / Damaged Vials	Checked By (Sign/Date/Dept.)
' . htmlspecialchars($data["date"] ?? '-') . '	' . htmlspecialchars($data["time"] ?? '-') . '	' . htmlspecialchars($data["recycledWaterPressure"] ?? '-') . '	' . htmlspecialchars($data["wfiLimitPressure"] ?? '-') . '	' . htmlspecialchars($data["compressedAirPressure"] ?? '-') . '	' . htmlspecialchars($data["clarityOfWFI"] ?? '-') . '	' . htmlspecialchars($data["totalNoOfVials"] ?? '-') . '	' . htmlspecialchars($data["bp"] ?? '-') . '	' . htmlspecialchars($data["fibres"] ?? '-') . '	' . htmlspecialchars($data["gp"] ?? '-') . '	' . htmlspecialchars($data["brokenDamagedVials"] ?? '-') . '	' . htmlspecialchars($data["checkedBy"] ?? '-') . '

Operator Settings - Vial Washing

Date/Time	Recycled Water Pressure (NLT 2.0 kg/cm²)	Purified Water Pressure (NLT 2.0 kg/cm²)	WFI Pressure (NLT 2.0 kg/cm²)	Compressed Air Pressure (NLT 2.5 kg/cm²)	Needle Centering	Machine Speed (30 Vials/Min.)	Checked By (Sign/Date/Dept.)
' . htmlspecialchars($data["dateTime"] ?? '-') . '	' . htmlspecialchars($data["recycledWaterPressure"] ?? '-') . '	' . htmlspecialchars($data["purifiedWaterPressure"] ?? '-') . '	' . htmlspecialchars($data["wfiPressure"] ?? '-') . '	' . htmlspecialchars($data["compressedAirPressure"] ?? '-') . '	' . htmlspecialchars($data["needleCentering"] ?? '-') . '	' . htmlspecialchars($data["machineSpeed"] ?? '-') . '	' . htmlspecialchars($data["checkedBy"] ?? '-') . '

Visual Inspection Report

Date	Time	No. of Inspected Vials	BP	WP	FIBRES	GP	Broken / Damaged Vials	WFI Clarity	External Clarity	Rejected Vials (Nos.)	Checked By (Sign/Date/Dept.)
' . htmlspecialchars($data["date"] ?? '-') . '	' . htmlspecialchars($data["time"] ?? '-') . '	' . htmlspecialchars($data["inspectedVials"] ?? '-') . '	' . htmlspecialchars($data["bp"] ?? '-') . '	' . htmlspecialchars($data["wp"] ?? '-') . '	' . htmlspecialchars($data["fibres"] ?? '-') . '	' . htmlspecialchars($data["gp"] ?? '-') . '	' . htmlspecialchars($data["brokenDamagedVials"] ?? '-') . '	' . htmlspecialchars($data["wfiClarity"] ?? '-') . '	' . htmlspecialchars($data["externalClarity"] ?? '-') . '	' . htmlspecialchars($data["rejectedVialsNos"] ?? '-') . '	' . htmlspecialchars($data["checkedBy"] ?? '-') . '

Visual Inspection Report

Date	Time	No. of Inspected Vials	BP	WP	FIBRES	GP	Broken / Damaged Vials	WFI Clarity	External Clarity	Rejected Vials (Nos.)	Checked By (Sign/Date/Dept.)
' . htmlspecialchars($data["date"] ?? '-') . '	' . htmlspecialchars($data["time"] ?? '-') . '	' . htmlspecialchars($data["inspectedVials"] ?? '-') . '	' . htmlspecialchars($data["bp"] ?? '-') . '	' . htmlspecialchars($data["wp"] ?? '-') . '	' . htmlspecialchars($data["fibres"] ?? '-') . '	' . htmlspecialchars($data["gp"] ?? '-') . '	' . htmlspecialchars($data["brokenDamagedVials"] ?? '-') . '	' . htmlspecialchars($data["wfiClarity"] ?? '-') . '	' . htmlspecialchars($data["externalClarity"] ?? '-') . '	' . htmlspecialchars($data["rejectedVialsNos"] ?? '-') . '	' . htmlspecialchars($data["checkedBy"] ?? '-') . '

Visual Inspection Report

Date	Total qty. received from Staging (A)	In process checks (B)	Rejection during Washing (C)	Samples (If any) (D)	Good quantity of vials for Tunnel (E = A – [B+C+D])	Checked by Production (Sign/Date)	Verified by QA (Sign/Date)
' . htmlspecialchars($data["date"] ?? '-') . '	' . htmlspecialchars($data["totalQtyReceived"] ?? '-') . '	' . htmlspecialchars($data["inProcessChecks"] ?? '-') . '	' . htmlspecialchars($data["rejectionDuringWashing"] ?? '-') . '	' . htmlspecialchars($data["samplesIfAny"] ?? '-') . '	' . htmlspecialchars($data["goodQtyForTunnel"] ?? '-') . '	' . htmlspecialchars($data["checkedByProduction"] ?? '-') . '	' . htmlspecialchars($data["verifiedByQA"] ?? '-') . '

Description of Utility	Date	Done By (Sign & Date)	Checked By Production (Sign & Date)
Water For Injection line	' . htmlspecialchars($selectedStepsdatas["waterInjectionTime"]) . '	' . htmlspecialchars($selectedStepsdatas["waterInjectionDoneBy"]) . '	' . htmlspecialchars($selectedStepsdatas["waterInjectionCheckedBy"]) . '
Purified Water Line	' . htmlspecialchars($selectedStepsdatas["PurifiedwaterTime"]) . '	' . htmlspecialchars($selectedStepsdatas["PurifiedwaterDoneBy"]) . '	' . htmlspecialchars($selectedStepsdatas["PurifiedwaterCheckedBy"]) . '
Recycled Water Line	' . htmlspecialchars($selectedStepsdatas["RecycledwaterTime"]) . '	' . htmlspecialchars($selectedStepsdatas["RecycledwaterDoneBy"]) . '	' . htmlspecialchars($selectedStepsdatas["RecycledwaterCheckedBy"]) . '
Compressed Air Line	' . htmlspecialchars($selectedStepsdatas["CompressedAirLineTime"]) . '	' . htmlspecialchars($selectedStepsdatas["CompressedAirLineDoneBy"]) . '	' . htmlspecialchars($selectedStepsdatas["CompressedAirLineCheckedBy"]) . '

Parameter
' . htmlspecialchars($data["parameter"]) . '

Recipe Parameters	Values for 50 mL vial	Observation	Checked by Production (Sign / Date)	Verified by IPQA (Sign / Date)
' . htmlspecialchars($data["Parameterd"]) . '	' . htmlspecialchars($data["value"]) . '	' . htmlspecialchars($data["observation"]) . '	' . htmlspecialchars($data["checkedByProduction"]) . '	' . htmlspecialchars($data["verifiedByIPQA"]) . '

Date	Time	Hot Zone Temp (NLT 300°C)	Tunnel Differential Pressure	Cool Zone Temperature	Conveyor Speed (160 mm/min)	Checked by Prod	Verified by IPQA (Sign / Date)
' . htmlspecialchars($data["date"]) . '	' . htmlspecialchars($data["time"]) . '	' . htmlspecialchars($data["hotZoneTemp"]) . '	' . htmlspecialchars($data["tunnelPressure"]) . '	' . htmlspecialchars($data["coolZoneTemp"]) . '	' . htmlspecialchars($data["conveyorSpeed"]) . '	' . htmlspecialchars($data["checkedByProd"]) . '	' . htmlspecialchars($data["verifiedByIPQA"]) . '

Filter	Make	Cat No.	Lot/Sr	Loc	Eq ID	Test	Limit	Date	From	To	Result	Done By	Checked	Verified
' . htmlspecialchars($data["filterDescription"]) . '	' . htmlspecialchars($data["make"]) . '	' . htmlspecialchars($data["catalogueNo"]) . '	' . htmlspecialchars($data["lotNo"]) . '	' . htmlspecialchars($data["location"]) . '	' . htmlspecialchars($data["equipmentId"]) . '	' . htmlspecialchars($data["test"]) . '	' . htmlspecialchars($data["limit"]) . '	' . htmlspecialchars($data["date"]) . '	' . htmlspecialchars($data["fromTime"]) . '	' . htmlspecialchars($data["toTime"]) . '	' . htmlspecialchars($data["result"]) . '	' . htmlspecialchars($data["doneBy"]) . '	' . htmlspecialchars($data["checkedBy"]) . '	' . htmlspecialchars($data["verifiedBy"]) . '

Date	AR. No.	Start Time	End Time	No. of Trays	Rejection Quantity	Good Quantity	Done By (Sign/Date)	Checked By (Sign/Date)
' . htmlspecialchars($data["date"]) . '	' . htmlspecialchars($data["arNo"]) . '	' . htmlspecialchars($data["startTime"]) . '	' . htmlspecialchars($data["endTime"]) . '	' . htmlspecialchars($data["noOfTrays"]) . '	' . htmlspecialchars($data["rejectionQty"]) . '	' . htmlspecialchars($data["goodQty"]) . '	' . htmlspecialchars($data["doneBy"]) . '	' . htmlspecialchars($data["checkedBy"]) . '
Total rejects Qty	' . htmlspecialchars($selectedStepsdatas['totalDeCartonningVialSopDatarejectionQty']) . '			Qty Transfer to Production (Nos.)				' . htmlspecialchars($selectedStepsdatas['qtyTransferProdNos']) . '

Sr. No.	Aseptic Preparation	Time (Hrs.) From	Time (Hrs.) To	Done By (Sign/Date)	Checked By (Sign/Date)
' . ($index + 1) . '	' . htmlspecialchars($data["asepticPreparation"]) . '	' . htmlspecialchars($data["fromTime"]) . '	' . htmlspecialchars($data["toTime"]) . '	' . htmlspecialchars($data["doneBy"]) . '	' . htmlspecialchars($data["checkedBy"]) . '

Date	Time	Crimping	Rolling	Colour Variation	Intact Seal	Dented	Cake Size	Other if Any	Activity	Checked by (Sign/Date/Dept.)
' . htmlspecialchars($data["date"]) . '	' . htmlspecialchars($data["time"]) . '	' . htmlspecialchars($data["crimping"]) . '	' . htmlspecialchars($data["rolling"]) . '	' . htmlspecialchars($data["colourVariation"]) . '	' . htmlspecialchars($data["intactSeal"]) . '	' . htmlspecialchars($data["dented"]) . '	' . htmlspecialchars($data["cakeSize"]) . '	' . htmlspecialchars($data["otherIfAny"]) . '	' . htmlspecialchars($data["activity"]) . '	' . htmlspecialchars($data["checkedBy"]) . '

Sr. No.	Stage of Sampling	Time of Sampling	Quantity of Sample	Collected By (Sign/Date)	Remarks
' . $srNo++ . '	' . htmlspecialchars($data["stageSampling"]) . '	' . htmlspecialchars($data["timeSampling"]) . '	' . htmlspecialchars($data["quantitySample"]) . '	' . htmlspecialchars($data["collectedBy"]) . '	' . htmlspecialchars($data["remarks"]) . '

Date	No. of Vials	Vacuum Pressure (NLT 500 mm of Hg)	Vacuum Hold (NLT 10 min)	Hold Time after Releasing Vacuum (NLT 30 min.)	Acceptance (Colour should not change)	Checked By (Production) (Sign/Date)	Checked By (IPQA) (Sign/Date)
' . htmlspecialchars($data["testDate"]) . '	' . htmlspecialchars($data["noOfVials"]) . '	' . htmlspecialchars($data["vacuumPressure"]) . '	' . htmlspecialchars($data["holdTime"]) . '	' . htmlspecialchars($data["holdTimeAfterReleasing"]) . '	' . htmlspecialchars($data["acceptance"]) . '	' . htmlspecialchars($data["checkedByProduction"]) . '	' . htmlspecialchars($data["checkedByIPQA"]) . '

Test Results (Pass/Fail)

Date	Time From	Time To	01	02	03	04	05	06	07	08	Done By (Sign / Date)	Checked By (Sign / Date)
' . htmlspecialchars($data["testDate"]) . '	' . htmlspecialchars($data["timeFrom"]) . '	' . htmlspecialchars($data["timeTo"]) . '	' . htmlspecialchars($data["test01"]) . '	' . htmlspecialchars($data["test02"]) . '	' . htmlspecialchars($data["test03"]) . '	' . htmlspecialchars($data["test04"]) . '	' . htmlspecialchars($data["test05"]) . '	' . htmlspecialchars($data["test06"]) . '	' . htmlspecialchars($data["test07"]) . '	' . htmlspecialchars($data["test08"]) . '	' . htmlspecialchars($data["doneBySignDate"]) . '	' . htmlspecialchars($data["checkedBySignDate"]) . '

Assembling and Filling Process Details

Aseptic Preparation	Date	Start Time (Hrs.)	End Time (Hrs.)	Total Time	Done By (Production)	Checked By Production (Sign/Date)
' . htmlspecialchars($data["AsepticPreparation"]) . '	' . htmlspecialchars($data["assemblingDate"]) . '	' . htmlspecialchars($data["assemblingStartTime"]) . '	' . htmlspecialchars($data["assemblingEndTime"]) . '	' . htmlspecialchars($data["assemblingTotalTime"]) . '	' . htmlspecialchars($data["assemblingDoneBy"]) . '	' . htmlspecialchars($data["assemblingCheckedBy"]) . '

Instructions:

Microbial plates should be exposed before start of the assembling.

Aseptic Preparation – Hold Time Record

Aseptic Preparation	From (Date & Time) (End of sterilization)	To (Date & Time) (End of filling)	Total Time (NMT 48 Hrs.)	Done By (Production)	Checked By (Sign/Date)
' . htmlspecialchars($data["asepticPreparation"]) . '	' . htmlspecialchars($data["holdTimeFrom"]) . '	' . htmlspecialchars($data["holdTimeTo"]) . '	' . htmlspecialchars($data["holdTimeTotal"]) . '	' . htmlspecialchars($data["holdTimeDoneBy"]) . '	' . htmlspecialchars($data["holdTimeCheckedBy"]) . '

Fill Weight Details

Filling	Fill Weight	Wt./Vial (mg)	Fill Weight
' . htmlspecialchars($index + 1) . '	' . htmlspecialchars($data["filling"]) . '	' . htmlspecialchars($data["grossFillWeight"]) . '	' . htmlspecialchars($data["wtPerVial"]) . '	' . htmlspecialchars($data["fillWeight"]) . '

Note: Target Fill Wt. = Target fill weight × wt. per gm

Initial Checks Before Filling

Sr. No.	Parameter	Limit	Observation	Done By (Production)	Checked By Production (Sign / Date)	Verified By IPQA (Sign / Date)
' . ($index + 1) . '	' . htmlspecialchars($data["Parameter"]) . '	' . htmlspecialchars($data["Limit"]) . '	' . htmlspecialchars($data["Observation"]) . '	' . htmlspecialchars($data["doneByProduction"]) . '	' . htmlspecialchars($data["checkedByProduction"]) . '	' . htmlspecialchars($data["verifiedByIPQA"]) . '

Initial Fill Weight Record

From Time	To Time	Formula	Observations of Fill Weight 01	Observations of Fill Weight 02
' . htmlspecialchars($data["fromTime"]) . '	' . htmlspecialchars($data["ToTime"]) . '	Net Fill Wt. = Gross fill Wt. - Empty Vial Wt	' . htmlspecialchars($data["observation1"]) . '	' . htmlspecialchars($data["observation2"]) . '

In-process Checks during Filling and Half Stoppering as per SOP

Date	Time	Dispensed Fill Weight		Activity	Checked by (Sign/Date/Dept.)
' . htmlspecialchars($data["date"]) . '	' . htmlspecialchars($data["time"]) . '	' . htmlspecialchars($data["dispensedFillWeight1"]) . '	' . htmlspecialchars($data["dispensedFillWeight2"]) . '	' . htmlspecialchars($data["activity"]) . '	' . htmlspecialchars($data["checkedBy"]) . '

Filling Start-Stop Sheet

Sr. No.	Filling Start Time	Filling Stop Time	Duration	Reason of Stoppage	Checked By (Production) (Sign / Date)
' . $i++ . '	' . htmlspecialchars($row["startTime"]) . '	' . htmlspecialchars($row["stopTime"]) . '	' . htmlspecialchars($row["duration"]) . '	' . htmlspecialchars($row["reason"]) . '	' . htmlspecialchars($row["checkedBy"]) . '

Reconciliation After Filling

Description	Quantity	UOM
' . htmlspecialchars($data["Description"]) . '	' . htmlspecialchars($data["Quantity"]) . '	' . htmlspecialchars($data["UOM"]) . '

Reconciliation After Sealing of Vials

Sr. No	Description	Quantity	UOM
' . ($index + 1) . '	' . htmlspecialchars($data["Description"]) . '	' . htmlspecialchars($data["Quantity"]) . '	' . htmlspecialchars($data["UOM"]) . '

Stage	Kg	No. of Units
' . htmlspecialchars($stage) . '	' . htmlspecialchars($kg) . '	' . htmlspecialchars($nos) . '

Sr. No.	Item	Qty.	Destruction Done By	Checked By
' . ($index + 1) . '	' . htmlspecialchars($item['item']) . '	' . htmlspecialchars($item['qty']) . '	' . htmlspecialchars($item['destructionDoneBy']) . '	' . htmlspecialchars($item['checkedBy']) . '

Attachment Details	Attached / Not Attached / NA	Attached By (Sign / Date)	Remarks
' . htmlspecialchars($item['attachmentDetails']) . '	' . htmlspecialchars($item['status']) . '	' . htmlspecialchars($item['attachedBy']) . '	' . htmlspecialchars($item['remarks']) . '

$substepNumber: ".$row4['substep']."

' . htmlspecialchars($data['PrecautionDispensing'] ?? '-') . '

Room Name:	' . htmlspecialchars($data['roomName'] ?? '-') . '
Room ID:	' . htmlspecialchars($data['roomId'] ?? '-') . '
Clearance for Product:	' . htmlspecialchars($data['clearanceProduct'] ?? '-') . '
Batch No.:	' . htmlspecialchars($data['batchNoCurrent'] ?? '-') . '
Previous Product:	' . htmlspecialchars($data['previousProduct'] ?? '-') . '
Batch No. (Previous):	' . htmlspecialchars($data['batchNoPrevious'] ?? '-') . '
Date & Time of Line Clearance:	' . htmlspecialchars($data['lineClearanceDateTime'] ?? '-') . '

Line Clearance Activities:

Sr. No.	Activity	Remark
' . ($index + 1) . '	' . htmlspecialchars($line['activity'] ?? '-') . '	' . htmlspecialchars($line['remark'] ?? '-') . '
No Line Clearance Data Found

Sr. No.	Item Code	Item	Specification	Std Qty	Balance ID	Tare Wt	Net Wt	Gross Wt	Mfg Date	Exp Date	AR. No.	Dispensed by Warehouse	Verified By Qa
' . ($i + 1) . '	' . htmlspecialchars($data['material_code'] ?? '-') . '	' . htmlspecialchars($data['material_name'] ?? '-') . '	' . htmlspecialchars($data['grade'] ?? '-') . '	' . htmlspecialchars($data['batch_qty'] ?? '-') . '		'; foreach ($containers as $con) { $html .= htmlspecialchars($con['tare_wt'] ?? '-') . ' '; } $html .= '	'; foreach ($containers as $con) { $html .= htmlspecialchars($con['net_weight'] ?? '-') . ' '; } $html .= '	'; foreach ($containers as $con) { $html .= htmlspecialchars($con['gross_wt'] ?? '-') . ' '; } $html .= '	'; foreach ($containers as $con) { $html .= htmlspecialchars($con['mfg_date'] ?? '-') . ' '; } $html .= '	'; foreach ($containers as $con) { $html .= htmlspecialchars($con['exp_date'] ?? '-') . ' '; } $html .= '	'; foreach ($containers as $con) { $html .= htmlspecialchars($con['ar_no'] ?? '-') . ' '; } $html .= '	' . htmlspecialchars($data['entry_by'] ?? '-') . '	' . htmlspecialchars($data['qa_approved_by'] ?? '-') . '

Sr. No.	Item Code	Item	Specification	Std Qty	Balance ID	Tare Wt	Net Wt	Gross Wt	Mfg Date	Exp Date	AR. No.	Dispensed by Warehouse	Checked By Prod	Verified By Qa
' . ($i + 1) . '	' . htmlspecialchars($data['material_code'] ?? '-') . '	' . htmlspecialchars($data['material_name'] ?? '-') . '	' . htmlspecialchars($data['grade'] ?? '-') . '	' . htmlspecialchars($data['batch_qty'] ?? '-') . '		' . columnList($containers, 'tare_wt') . '	' . columnList($containers, 'net_weight') . '	' . columnList($containers, 'gross_wt') . '	' . columnList($containers, 'mfg_date') . '	' . columnList($containers, 'exp_date') . '	' . columnList($containers, 'ar_no') . '	' . htmlspecialchars($data['entry_by'] ?? '-') . '	' . htmlspecialchars($data['checkedBy'] ?? '-') . '	' . htmlspecialchars($data['qa_approved_by'] ?? '-') . '

Date	Time	No. of Inspected Vials	Black Particle	White Particle	Fiber	Glass Particle	Color Variation	Others	Rejected Vials	Checked By (Sign / Date)
' . htmlspecialchars($record["date"]) . '	' . htmlspecialchars($record["time"]) . '	' . htmlspecialchars($record["inspectedVials"]) . '	' . htmlspecialchars($record["blackParticle"]) . '	' . htmlspecialchars($record["whiteParticle"]) . '	' . htmlspecialchars($record["fiber"]) . '	' . htmlspecialchars($record["glassParticle"]) . '	' . htmlspecialchars($record["colorVariation"]) . '	' . htmlspecialchars($record["others"]) . '	' . htmlspecialchars($record["rejectedVials"]) . '	' . htmlspecialchars($record["checkedBy"]) . '

Date	Total qty. received from washing (A)	Total qty. of depyrogenated Vials used for in-process (B)	Sample (If any) (C)	Good Quantity Transfer for Filling (D = A - (B + C))	Checked By Production (Sign & Date)	Verified By IPQA (Sign & Date)
' . htmlspecialchars($record["date"]) . '	' . htmlspecialchars($record["qtyReceived"]) . '	' . htmlspecialchars($record["qtyUsed"]) . '	' . htmlspecialchars($record["sample"]) . '	' . htmlspecialchars($record["goodQty"]) . '	' . htmlspecialchars($record["checkedBy"]) . '	' . htmlspecialchars($record["verifiedBy"]) . '

In-process at Start of Filling

Date	Time	Nitrogen Flow Rate (0–1 MPa)	Checked By
' . htmlspecialchars($record["date"]) . '	' . htmlspecialchars($record["time"]) . '	' . htmlspecialchars($record["nitrogenFlowRate"]) . '	' . htmlspecialchars($record["checkedBy"]) . '

In-process During Filling

Date	Time	Pre Nitrogen Flow Rate (0–1 MPa)	Post Nitrogen Flow Rate (0–1 MPa)	Checked By (Sign/Date/Dept.)
' . htmlspecialchars($record["date"]) . '	' . htmlspecialchars($record["time"]) . '	' . htmlspecialchars($record["preNitrogenFlow"]) . '	' . htmlspecialchars($record["postNitrogenFlow"]) . '	' . htmlspecialchars($record["checkedBy"]) . '

In-process at the End of Filling

Date	Time	Pre Nitrogen Flow Rate (0–1 MPa)	Post Nitrogen Flow Rate (0–1 MPa)	Checked By (Sign/Date/Dept.)
' . htmlspecialchars($record["date"]) . '	' . htmlspecialchars($record["time"]) . '	' . htmlspecialchars($record["preNitrogenFlow"]) . '	' . htmlspecialchars($record["postNitrogenFlow"]) . '	' . htmlspecialchars($record["checkedBy"]) . '

Date	Time	No. of Inspected Vials	Black Particle	White Particle	Fibres	Glass Particle	Others	Rejected Vials	Checked by (Sign/Date/Dept.)
' . htmlspecialchars($record["date"]) . '	' . htmlspecialchars($record["time"]) . '	' . htmlspecialchars($record["inspectedVials"]) . '	' . htmlspecialchars($record["blackParticle"]) . '	' . htmlspecialchars($record["whiteParticle"]) . '	' . htmlspecialchars($record["fibres"]) . '	' . htmlspecialchars($record["glassParticle"]) . '	' . htmlspecialchars($record["others"]) . '	' . htmlspecialchars($record["rejectedVials"]) . '	' . htmlspecialchars($record["checkedBy"]) . '

Main Transfer and Verification of Semi-Finished Goods

Material Name		' . htmlspecialchars($row4['data']['materialName']) . '
Product Name		' . htmlspecialchars($row4['data']['ProductName']) . '		Batch No.		' . htmlspecialchars($row4['data']['BatchNumber']) . '

S. No.	Date	Area	Qty. per pallet/tray	Cumulative Qty.	Transferred by	Checked by	Verified by	Remarks
' . ($index + 1) . '	' . htmlspecialchars($record['date']) . '	' . htmlspecialchars($record['area']) . '	' . htmlspecialchars($record['qtyPerPallet']) . '	' . htmlspecialchars($record['cumulativeQty']) . '	' . htmlspecialchars($record['transferredBy']) . '	' . htmlspecialchars($record['checkedBy']) . '	' . htmlspecialchars($record['verifiedBy']) . '	' . htmlspecialchars($record['remarks']) . '

Optical Inspection Record

Date	Tray No.	Total Vial/Syringes	Critical-C	Critical-SD	Critical-CV	Critical-GP	Critical-SS	Critical-Extrinsic Particular	Major-FB	Major-BP	Major-CP	Major-Low	Major-High	Minor-PD	Minor-Empty	Minor-Other	Good Syringes	Rejects	Checked By
' . htmlspecialchars($record['date']) . '	' . htmlspecialchars($record['trayNo']) . '	' . htmlspecialchars($record['totalVial']) . '	' . htmlspecialchars($record['criticalC']) . '	' . htmlspecialchars($record['criticalSD']) . '	' . htmlspecialchars($record['criticalCV']) . '	' . htmlspecialchars($record['criticalGP']) . '	' . htmlspecialchars($record['criticalSS']) . '	' . htmlspecialchars($record['criticalExtrinsic']) . '	' . htmlspecialchars($record['majorFB']) . '	' . htmlspecialchars($record['majorBP']) . '	' . htmlspecialchars($record['majorCP']) . '	' . htmlspecialchars($record['majorLow']) . '	' . htmlspecialchars($record['majorHigh']) . '	' . htmlspecialchars($record['minorPD']) . '	' . htmlspecialchars($record['minorEmpty']) . '	' . htmlspecialchars($record['minorOther']) . '	' . htmlspecialchars($record['good']) . '	' . htmlspecialchars($record['reject']) . '	' . htmlspecialchars($record['checkedBy']) . '

Date	Sample Size	Inspector Name	Critical-C	Critical-SD	Critical-CV	Critical-GP	Critical-SS	Critical-Extrinsic	Major-FB	Major-BP	Major-CP	Major-Low	Major-High	Minor-PD	Minor-Empty	Minor-Other	Good Syringes	Rejects	Checked By
' . htmlspecialchars($record['date']) . '	' . htmlspecialchars($record['sampleSize']) . '	' . htmlspecialchars($record['inspectorName']) . '	' . htmlspecialchars($record['criticalC']) . '	' . htmlspecialchars($record['criticalSD']) . '	' . htmlspecialchars($record['criticalCV']) . '	' . htmlspecialchars($record['criticalGP']) . '	' . htmlspecialchars($record['criticalSS']) . '	' . htmlspecialchars($record['criticalExtrinsic']) . '	' . htmlspecialchars($record['majorFB']) . '	' . htmlspecialchars($record['majorBP']) . '	' . htmlspecialchars($record['majorCP']) . '	' . htmlspecialchars($record['majorLow']) . '	' . htmlspecialchars($record['majorHigh']) . '	' . htmlspecialchars($record['minorPD']) . '	' . htmlspecialchars($record['minorEmpty']) . '	' . htmlspecialchars($record['minorOther']) . '	' . htmlspecialchars($record['goodVial']) . '	' . htmlspecialchars($record['rejects']) . '	' . htmlspecialchars($record['checkedBy']) . '

Date	Tray No.	Total Vial/Syringes	Critical-C	Critical-SD	Critical-CV	Critical-GP	Critical-SS	Critical-Extrinsic Particular	Major-FB	Major-BP	Major-CP	Major-Low	Major-High	Minor-PD	Minor-Empty	Minor-Other	Good Syringes	Rejects	Checked By
' . htmlspecialchars($record['date']) . '	' . htmlspecialchars($record['trayNo']) . '	' . htmlspecialchars($record['totalVial']) . '	' . htmlspecialchars($record['criticalC']) . '	' . htmlspecialchars($record['criticalSD']) . '	' . htmlspecialchars($record['criticalCV']) . '	' . htmlspecialchars($record['criticalGP']) . '	' . htmlspecialchars($record['criticalSS']) . '	' . htmlspecialchars($record['criticalExtrinsic']) . '	' . htmlspecialchars($record['majorFB']) . '	' . htmlspecialchars($record['majorBP']) . '	' . htmlspecialchars($record['majorCP']) . '	' . htmlspecialchars($record['majorLow']) . '	' . htmlspecialchars($record['majorHigh']) . '	' . htmlspecialchars($record['minorPD']) . '	' . htmlspecialchars($record['minorEmpty']) . '	' . htmlspecialchars($record['minorOther']) . '	' . htmlspecialchars($record['good']) . '	' . htmlspecialchars($record['reject']) . '	' . htmlspecialchars($record['checkedBy']) . '

Rejection Analysis

Date	Critical-C	Critical-SD	Critical-CV	Critical-GP	Critical-SS	Critical-Extrinsic Particular	Major-FB	Major-BP	Major-CP	Major-Low	Major-High	Minor-PD	Minor-Empty	Minor-Other	Total Rejects	Checked By
' . htmlspecialchars($record['date']) . '	' . htmlspecialchars($record['criticalC']) . '	' . htmlspecialchars($record['criticalSD']) . '	' . htmlspecialchars($record['criticalCV']) . '	' . htmlspecialchars($record['criticalGP']) . '	' . htmlspecialchars($record['criticalSS']) . '	' . htmlspecialchars($record['criticalExtrinsic']) . '	' . htmlspecialchars($record['majorFB']) . '	' . htmlspecialchars($record['majorBP']) . '	' . htmlspecialchars($record['majorCP']) . '	' . htmlspecialchars($record['majorLow']) . '	' . htmlspecialchars($record['majorHigh']) . '	' . htmlspecialchars($record['minorPD']) . '	' . htmlspecialchars($record['minorEmpty']) . '	' . htmlspecialchars($record['minorOther']) . '	' . htmlspecialchars($record['totalRejects']) . '	' . htmlspecialchars($record['checkedBy']) . '

Stage	Vial	RS	Seals	UOM
' . htmlspecialchars($row['stage']) . '	' . htmlspecialchars($row['vial']) . '	' . htmlspecialchars($row['rs']) . '	' . htmlspecialchars($row['seals']) . '	' . htmlspecialchars($row['uom']) . '

Description	Remark
' . htmlspecialchars($row['description']) . '	' . htmlspecialchars($row['remark']) . '

Description	Destruction Qty.
' . htmlspecialchars($row['description']) . '	' . htmlspecialchars($row['destructionQty']) . '

S. No.	Deviation No./ Incident No.	Description	Recorded by (sign & date)
' . ($index + 1) . '	' . htmlspecialchars($row['deviationNo']) . '	' . htmlspecialchars($row['description']) . '	' . htmlspecialchars($row['recordedBy']) . '

"; $stageIndex++; } } } } $pdf->writeHTML($html, true, false, true, false, ''); $pdf->Output('Dispensing Record.pdf', 'I');

1. GENERAL INFORMATION

2. Table of Content

".$stageIndex.".)". $row2['stages']."

$stepNumber: ".$row3['step']."

Record the cycle detail in below table:

Vial Washing Activity

Filter Integrity Record

Operator Setting – Vial Washing

Vial Washing In-Process Check

Operator Settings - Vial Washing

Visual Inspection Report

Visual Inspection Report

Visual Inspection Report

Test Results (Pass/Fail)

Assembling and Filling Process Details

Aseptic Preparation – Hold Time Record

Fill Weight Details

Initial Checks Before Filling

Initial Fill Weight Record

In-process Checks during Filling and Half Stoppering as per SOP

Filling Start-Stop Sheet

Reconciliation After Filling

Reconciliation After Sealing of Vials

$substepNumber: ".$row4['substep']."

In-process at Start of Filling

In-process During Filling

In-process at the End of Filling

Main Transfer and Verification of Semi-Finished Goods

Optical Inspection Record

Rejection Analysis