".$branchName."";?>
" . $branchAddress ."";?>
TREATMENT REPORT - NO SHOW
Date Rage:
| No. | PATIENT ID | NAME OF PATIENT | SCHEDULE | TREATMENT DATE | CONFIRMED TIME | CONFIRMED BY | REASONS | Completed Tx's | Missed Tx's | "; $noshowrecord=mysql_query("SELECT * FROM `noshow` WHERE `branch_code`='$compCode' AND `date` BETWEEN '$dateFrom' AND '$dateTo' ORDER by `date` ASC"); while($row = mysql_fetch_array($noshowrecord)){ $count=$count +1; $pID =$row['patient_id']; $fName = mysql_result(mysql_query("SELECT `patient_fname` FROM `patient_list` WHERE `patient_id`='$pID'"),0); $lName = mysql_result(mysql_query("SELECT `patient_lname` FROM `patient_list` WHERE `patient_id`='$pID'"),0); echo "
|---|---|---|---|---|---|---|---|---|---|
| ".$count." | "; echo "".$row['patient_id']." | "; echo "".$fName. " ".$lName." | "; echo "".$row['batch']." | "; echo "".$row['date']." | "; echo "".$row['time']." | "; echo "".$row['by']." | "; echo "".$row['reasons']." | "; echo ""; $comTX = mysql_result(mysql_query("SELECT COUNT('session_id') FROM `treatment_session` WHERE `session_patient_id`='$pID'"),0); echo $comTX; echo " | "; echo ""; $comTX = mysql_result(mysql_query("SELECT COUNT('ref_d') FROM `noshow` WHERE `patient_id`='$pID'"),0); echo $comTX; echo " | "; echo "