<?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("dbconnection.php");
include("dashboarddocument.php");
?>

<?php 
require_once("../patientmanager.php");
require_once("../DBManager.php");
include("opdtest2322.php");
if(isset($_POST[investig])) {
PatientManager::nayainvestigation("$_GET[prescriptionid]","$_GET[patientid]","$_POST[hospital_id]","$_POST[Raised_at]","$_POST[Investigation_type]","$_POST[Category]","$_POST[Sub_Category]","$_POST[Priority_slip]","$_POST[Investigation]","$_POST[ivid]","$_POST[Result]","$_POST[Evidence]","$_POST[enteredby]");
}
?>

  <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
	$sql ="DELETE FROM investigation WHERE id='$_GET[delid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</script>";
	}
}
?>
 <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
   <script>
   
function myFunction2() {
  var checkBox = document.getElementById("myCheck2");
  var text = document.getElementById("text2");
  if (checkBox.checked == true){
    text.style.display = "block";
  } else {
     text.style.display = "none";
  }
}
   
   function myFunction3() {
  var checkBox = document.getElementById("myCheck3");
  var text = document.getElementById("text3");
  if (checkBox.checked == true){
    text.style.display = "block";
  } else {
     text.style.display = "none";
  }
}
   
   
var stateObject = {
"Ultrasound & Doppler": { "HEAD & NECK": ["HEAD & NECK", "Middle Cerebral Doppler","Neck (Thyroid)"],
"BREAST": ["Breast Lesion Localization", "Breast","Breast & Axilla","Breast Core Biopsy","FNA Breast"],
"ABDOMEN": ["All Abdomen", "Upper Abdomen","Umbilical Artery Doppler","Umbilical Artery Doppler","K.U.B.","Renal Doppler","Hepatic Portal Vein Doppler","Abscess Drainage Abdomen","Ascetic Drain Placement"],
"PELVIS": ["Hip Joint", "Trans Rectal","Testis Doppler","Trans Vaginal","Fetal","Uterine Artery Doppler"],
"UPPER EXTREMITY": ["Upper Limb Doppler", "Upper Limb Arteries & Veins Doppler"],
"LOWER EXTREMITY": ["Lower Limb Doppler", "Lower Limb Arteries & Veins Doppler"],
"FINE NEEDLE ASPIRATION": ["FNA Neck", "FNA Thyroid","Guided Aspiration"],
"OTHERS": ["Echocardiography", "Skin Marking","Organ","New Marriage"],
},
"MRI": {
"HEAD & NECK": ["Brain", "Angiography (MRA) Head","Venography (MRV) BrainMDC RADIOLOGY TEST LIST","Paranasal Sinuses","Int. Auditory Meatus (IAM)","Parotid Gland","Pituitary With Contrast","Orbit","Face","Mastoids","Brachial Plexus","Temporomandibular (TM) Joint","Neck","Angiography (MRA) Neck"],
"SPINE": ["Cervical","Lumbar","Thoracic","Whole Spine"],
"CHEST": ["Chest","Breast With Contrast"],
"ABDOMEN": ["ABDOMEN -Cholangiopancreatography (MRCP)","Abdomen"],
"PELVIS": ["PELVIS", "Sacroliac Joints","Hip Joints","Fistula","CHEST - Chest"],
"UPPER EXTREMITY": ["Shoulder", "Arm","Elbow","Forearm","Wrist","Hand"],
"LOWER EXTREMITY": ["Thigh", "Femur","Knee","Leg","Ankle","Foot"],
"COMBINATION EXAMINATIONS": ["Cervical & Lumbar", "Thoracic & Lumbar","Cervical & Thoracic","Abdomen & Pelvis","Brain & Orbit"],
"Contrast": ["CONTRAST"],
}, 
"CT + 3D": {
"HEAD & NECK": ["Skull", "Brain","Paranasal Sinuses (PNS)","Orbit","Face","Mastoids","Temporal Bone","Neck"],
"SPINE": ["Cervical", "Lumbar","Thoracic","Whole Spine","Myelogram"],
"CHEST": ["Chest", "High Resolution Computed Tomography (HRCT)"],
"ABDOMEN": ["Abdomen", "K.U.B.","Urogram With Contrast","Pneumocolon With Contrast"],
"PELVIS": ["PELVIS", "Hip Joint","Sacroliac Joints","Pneumocolon With Contrast"],
"UPPER EXTREMITY": ["Shoulder", "Humerus","Elbow","Forearm","Wrist","Hand"],
"LOWER EXTREMITY": ["Femur", "Knee","Leg","Ankle","Foot"],
"CT ANGIOGRAPHY": ["Cerebral Angio", "Chest Angio","Abdomen Angio","Renal Angio","Upper Limb Angio","Lower Limb Angio"],
"OTHERS": ["Biopsy", "Scanogram"],
"COMBINATION EXAMINATIONS": ["Neck & PNS", "Abdomen & Pelvis","Chest & Abdomen Angio","Brain & PNS","Brain & Temporal Bone","PNS & Orbit","PNS & Temporal Bone","Neck & Chest & Abdomen & Pelvis","Chest & Abdomen"],
"Contrast": ["CONTRAST"],
},

"X RAYS": {
"HEAD & NECK": ["Skull", "Orbit","Facial Bone","Submentovertex (S.M.V.)","Submentovertex (S.M.V.)","Paranasal Sinuses","Post Nasal Space","Mastoid","Mandible","T.M. Joint"],
"SPINE": ["Neck Soft Tissue","Cervical", "Lumbar","Thoracic","Coccyx"],
"CHEST": ["Chest", "Apical Lordotic View","Sternum","Ribs (Oblique)"],
"ABDOMEN": ["ABDOMEN - K.U.B."],
"PELVIS": ["PELVIS", "Hip","Sacroliac Joints"],
"UPPER EXTREMITY": ["Shoulder", "Acromioclavicular (AC) Joint","Clavicle","Scaphoid Bone 5-6 Views","Humerus","Elbow","Forearm","Wrist","Hand"],
"LOWER EXTREMITY": ["Femur","Patella","Tibia","Fibula","Knee","Leg","Ankle","Foot","OTHERS - Bone Density (BMD)","Bone AgeMDC RADIOLOGY TEST LIST 6"],
},

"Fluoroscopy": {
"SPINE MYELOGRAM": ["Myelogram Cervical", "Myelogram Thoracic","Myelogram Lumbar"],
"BARIUM EXAMINATIONS": ["Barium Swallow","Barium Swallow (Gastrograph)", "Barium Meal","Barium Follow Through","Barium Enema"],
"PELVIS": ["Colostogram","Cystogram","Hysterosalpingogram (HSG)","MicturatingCystourethrogram (MCUG)","Voiding Cysto-Urethrogram (VCUG)","EXTREMITIES VENOGRAM -Venogram Upper Limbs","Venogram Lower Limbs"],
"OTHERS": ["Intravenous Pyelogram - Urogram (IVP - IVU)","Loopogram","Urethrogram","Fistulogram - Sinogram","Nephrostogram","T-Tube","Combination Examinations - Barium Swallow & Meal","Barium Meal & Follow Through"],
},
"Mammography": {
"Breast": ["Breast"],
"Localization Mammography": ["Localization Mammography"],
},
"Biometry": {
"Left eye": ["A Scan Ultrasound","IOL Master"],
"Right eye": ["A Scan Ultrasound","IOL Master"]
},
}
window.onload = function () {
var countySel = document.getElementById("countySel"),
stateSel = document.getElementById("stateSel"),
Investigation = document.getElementById("Investigation");
for (var country in stateObject) {
countySel.options[countySel.options.length] = new Option(country, country);
}
countySel.onchange = function () {
stateSel.length = 1; // remove all options bar first
Investigation.length = 1; // remove all options bar first
if (this.selectedIndex < 1) return; // done
for (var state in stateObject[this.value]) {
stateSel.options[stateSel.options.length] = new Option(state, state);
}
}
countySel.onchange(); // reset in case page is reloaded
stateSel.onchange = function () {
Investigation.length = 1; // remove all options bar first
if (this.selectedIndex < 1) return; // done
var district = stateObject[countySel.value][this.value];
for (var i = 0; i < district.length; i++) {
Investigation.options[Investigation.options.length] = new Option(district[i], district[i]);
}
}
}
</script>

 <script>
    function selection(){
	var selected=document.getElementById("select1").value;
  if(selected==0){
  	document.getElementById("input1").removeAttribute("hidden");
  }else{
  	//elsewhere actions
  }
}
</script>
    <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
  <link rel="stylesheet" href="/resources/demos/style.css">
    <title>Title of the document</title>
    <style>
      .modal {
        display: none;
        position: fixed;
        z-index: 8;
        left: 0;
        top: 0;
        width: 100%;
        height: 100%;
        overflow: auto;
        background-color: rgb(0, 0, 0);
        background-color: rgba(0, 0, 0, 0.4);
      }
      .modal-content {
        margin: 50px auto;
        border: 1px solid #999;
        width: 60%;
      }
      h2,p {
        margin: 0 0 20px;
        font-weight: 400;
  
      }     
     .form1 {
        padding: 25px;
        margin: 25px;
        box-shadow: 0 2px 5px #f5f5f5;
        background: #eee;
      }
      input,
      textarea, select {
        width: 100%;
        padding: 6px;
        margin-bottom: 20px;
        border: 1px solid #1c87c9;
        outline: none;
      }
      .contact-form button {
        width: 100%;
        padding: 10px;
        border: none;
        background: #1c87c9;
        font-size: 16px;
        font-weight: 400;
        color: #fff;
      }
      button:hover {
        background: #2371a0;
      }
      .close {
        color: #aaa;
        float: right;
        font-size: 58px;
        font-weight: bold;
      }
      .close:hover,
      .close:focus {
        color: black;
        text-decoration: none;
        cursor: pointer;
      }
      button.button {
        display: inline-block;
       
        border-bottom: #02274a 1px solid;
     
        font-size: 19px;
        cursor: pointer;
      }
      
      button.button:hover {
    
        border-bottom: #a99567 1px solid;
        color: #a99567;
      }

 
    </style>
     <script src="https://code.jquery.com/jquery-1.12.4.js"></script>
  <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
  <script>
  $( function() {
    $.widget( "custom.combobox", {
      _create: function() {
        this.wrapper = $( "<span>" )
          .addClass( "custom-combobox" )
          .insertAfter( this.element );
 
        this.element.hide();
        this._createAutocomplete();
        this._createShowAllButton();
      },
 
      _createAutocomplete: function() {
        var selected = this.element.children( ":selected" ),
          value = selected.val() ? selected.text() : "";
 
        this.input = $( "<input>" )
          .appendTo( this.wrapper )
          .val( value )
          .attr( "title", "" )
          .addClass( "custom-combobox-input ui-widget ui-widget-content ui-state-default ui-corner-left" )
          .autocomplete({
            delay: 0,
            minLength: 0,
            source: $.proxy( this, "_source" )
          })
          .tooltip({
            classes: {
              "ui-tooltip": "ui-state-highlight"
            }
          });
 
        this._on( this.input, {
          autocompleteselect: function( event, ui ) {
            ui.item.option.selected = true;
            this._trigger( "select", event, {
              item: ui.item.option
            });
          },
 
          autocompletechange: "_removeIfInvalid"
        });
      },
 
      _createShowAllButton: function() {
        var input = this.input,
          wasOpen = false;
 
        $( "<a>" )
          .attr( "tabIndex", -1 )
          .attr( "title", "Show All Items" )
          .tooltip()
          .appendTo( this.wrapper )
          .button({
            icons: {
              primary: "ui-icon-triangle-1-s"
            },
            text: false
          })
          .removeClass( "ui-corner-all" )
          .addClass( "custom-combobox-toggle ui-corner-right" )
          .on( "mousedown", function() {
            wasOpen = input.autocomplete( "widget" ).is( ":visible" );
          })
          .on( "click", function() {
            input.trigger( "focus" );
 
            // Close if already visible
            if ( wasOpen ) {
              return;
            }
 
            // Pass empty string as value to search for, displaying all results
            input.autocomplete( "search", "" );
          });
      },
 
      _source: function( request, response ) {
        var matcher = new RegExp( $.ui.autocomplete.escapeRegex(request.term), "i" );
        response( this.element.children( "option" ).map(function() {
          var text = $( this ).text();
          if ( this.value && ( !request.term || matcher.test(text) ) )
            return {
              label: text,
              value: text,
              option: this
            };
        }) );
      },
 
      _removeIfInvalid: function( event, ui ) {
 
        // Selected an item, nothing to do
        if ( ui.item ) {
          return;
        }
 
        // Search for a match (case-insensitive)
        var value = this.input.val(),
          valueLowerCase = value.toLowerCase(),
          valid = false;
        this.element.children( "option" ).each(function() {
          if ( $( this ).text().toLowerCase() === valueLowerCase ) {
            this.selected = valid = true;
            return false;
          }
        });
 
        // Found a match, nothing to do
        if ( valid ) {
          return;
        }
 
        // Remove invalid value
        this.input
          .val( "" )
          .attr( "title", value + " didn't match any item" )
          .tooltip( "open" );
        this.element.val( "" );
        this._delay(function() {
          this.input.tooltip( "close" ).attr( "title", "" );
        }, 2500 );
        this.input.autocomplete( "instance" ).term = "";
      },
 
      _destroy: function() {
        this.wrapper.remove();
        this.element.show();
      }
    });
 
    $( "#combobox" ).combobox();
    $( "#toggle" ).on( "click", function() {
      $( "#combobox" ).toggle();
    });
  } );
  </script>
   <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/js/standalone/selectize.min.js" integrity="sha256-+C0A5Ilqmu4QcSPxrlGpaZxJ04VjsRjKu+G82kl5UJk=" crossorigin="anonymous"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/css/selectize.bootstrap3.min.css" integrity="sha256-ze/OEYGcFbPRmvCnrSeKbRTtjG4vGLHXgOqsyLFTRjg=" crossorigin="anonymous" />

   	<div class='center'>
<link rel="stylesheet" href="select2.min.css" />
<style>
.select2-dropdown {top: 22px !important; left: 8px !important;}
</style>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

<h3 align="center">Investigation</h3>
<form method="post"name="investig">
	<table id="example2" class="table table-bordered table-hover">  
	<thead>
	    <input type='hidden' name='Raised_at' value='Opd Slip'>
	    <tr>
	        <td>
            <input type="checkbox" name="Investigation_type" value='Radiology' id="myCheck2" onclick="myFunction2()"><td><span>Radiology</span></td></td>
            </tr>
<tr>
	        <td>
            <input type="checkbox" name="Investigation_type" value='Pathology' id="myCheck3" onclick="myFunction3()"></td><td><span>Pathology</span></td>
            </tr>
            </table>
	
            	  <div id="text2" style="display:none">
            	<table id="example2" class="table table-bordered table-hover"> 
            
                
	    <tr>
        <td>Select Investigation</td>
        <td>
<select onchange="ivload(this.value)" name="Category">
<option value="" selected="selected">Select Investigation</option>
<option value="10">Ultrasound & Doppler</option>
<option value="11">MRI</option>
<option value="12">	CT + 3D</option>
<option value="13">	X RAYS</option>
<option value="14">	Fluoroscopy</option>
<option value="15">Mammography</option>
<option value="16">	Biometry</option>
</select>
</td></tr>
<tr><td>Body Part</td><td><div id='divdr'>
<select name="Sub_Category">
<option value="" selected="selected">Please select Investigation first</option>
</div>
</select></td></tr>

<tr>
     <td>Request Investigation</td>
     <td><div id='divbody'>
 <select name="Investigation" id="Investigation" size="1">
<option value="" selected="selected">Please select Body Part first</option>
</div></select></td></tr>

</table>
</div>
           <div id="text3" style="display:none">
               	<table id="example2" class="table table-bordered table-hover"> 
                    <tr>  <td>Request Investigation</td>
                    <td>
                        <select class='selectva' id="select12-state" name="ivid">
        	<option value="">Investigation</option>
                        <?php
include("dbconnection.php");
	$sqlpatient1 = "SELECT * FROM list_Investigation";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    echo "<option value='$rsn[ivid]'>$rsn[Investigation]</option>";
				}
	
		  ?>
</td>
</select>
        </tr>
                           <?php
    include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
	    echo"
        <input type='hidden' name='hospital_id' value='$re[entered_by]'> 
        ";
	}
        ?>
        </table>
        </div>
        	<table id="example2" class="table table-bordered table-hover"> 
        
         <tr>
          <td>Priority slip </td>
            <td><select name="Priority_slip">
                	<option value="">Priority slip </option>
	<option value="Urgent">Urgent </option>
	<option value="Normal">Normal </option>
	</td>
	</tr>
        <tr><td></td><td>
           <input type="submit" value="Add" name="investig"></td></tr>
    </form>
</div>

</table>


<table id="example2"  id ="demo" class="table table-bordered table-hover">
                  <thead>
                  <tr>
                  <div id="listingTable">
    <div class='card-header d-flex p-0'>
                    <ul class='nav nav-pills ml-auto p-2'>
         <th><strong>Date Time</strong></th>
         <th><strong>Investigation</strong></th>
          <th><strong>Result</strong></th> 
          <th><strong>Evidence</strong></th>
               <th><strong>Action</strong></th>
                       </tr>
                  </thead>
                  
               
                 
<?php
			$sql ="SELECT * FROM investigation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
            echo " <tbody>
                                                                                                                                                                
     <tr>   <td>&nbsp;$rs[created_at]</td>     
            <td>&nbsp;";
	   if (is_numeric($rs[Category]))
{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rs[Category]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[lab_department_name]";
}
   if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$rs[Sub_Category]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "-  &nbsp; $rh1[bodypart]";
}
   if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rs[Investigation]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "-  &nbsp; $rh1[Investigation]";
}
            $sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$rs[ivid]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    echo"
	    $rsn[Investigation]"; }
	    echo"</b></td>
           <td>&nbsp;$rs[Result]</td>
		   <td>&nbsp;$rs[Evidence]</td>
		 <td><a href='request.investigation.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]'>Delete</a></td>

	
          </tr>                   
          
     ";
}
?>  
   </tbody>
</table>  
</div>
<table id="example2"  id ="demo" class="table table-bordered table-hover">
<?php
			$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
            echo " <tbody>
                                              
                     
          
     ";
}
?>  
   </tbody>
</table> 

 <script>
 function ivload(drid)
{
	    if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("divdr").innerHTML = this.responseText;
            }
        };
        xmlhttp.open("GET","loadiv.php?drid="+drid,true);
        xmlhttp.send();
}
            
     
</script>
  
   <script>
 function boddyload(bodyid)
{
	    if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("divbody").innerHTML = this.responseText;
            }
        };
        xmlhttp.open("GET","loadbodyiv.php?bodyid="+bodyid,true);
        xmlhttp.send();
}
            
     
</script>
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/js/standalone/selectize.min.js" integrity="sha256-+C0A5Ilqmu4QcSPxrlGpaZxJ04VjsRjKu+G82kl5UJk=" crossorigin="anonymous"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/css/selectize.bootstrap3.min.css" integrity="sha256-ze/OEYGcFbPRmvCnrSeKbRTtjG4vGLHXgOqsyLFTRjg=" crossorigin="anonymous" />

</head>
<body>
 
  <script>
 $(document).ready(function () {
      $('select12').selectize({
          sortField: 'text'
      });
  });
  </script>
</body>
</html>