"; $content.=""; $content.=""; //start table header $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; //end table header $content.=""; $query = "select * from visitors_employee_appointment where emp_id = '".$emp_id."' order by appointment_date desc "; if (!$result = @mysqli_query($conn,$query)) { exit(mysqli_error($conn)); } //$data = array(); $numrows=mysqli_num_rows($result) ; if($numrows > 0) { while ($row = mysqli_fetch_assoc($result)) { $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; //buttons end $content.=""; $content.=""; $content.=""; $content.=""; }//end of while }//if no records found else { $content.=""; $content.=""; $content.=""; } $content.=""; $content.="

Details

Date

Complaints/Injury Details

Examination Findings

Diagnosis/Injury Type

Treatments

Referral

Follow-up

Remarks

"; $content.="

"; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.="

"; $content.="

"; $content.=date_format(date_create($row['appointment_date']),"d-M-Y H:i A"); $content.="

".$row['complaints']."

".$row['examination_remarks']."

"; if($row['appointment_type']=='O'){ $content.=""; $content.=getCommaSeperatedValuesForInClause("select ailment_name from ailment ","ailment_id",$row['ailment_ids']); $content.=""; }else if($row['appointment_type']=='I'){ $content.=""; $content.=getCommaSeperatedValuesForInClause("select injury_type_name from injury_type","injury_type_id",$row['injury_types']); $content.=""; } $content.="

".$row['referral']."

".$row['followup']."

".$row['remarks']."

"; //buttons start $content.="

"; $content.=""; $content.=""; $content.=""; $content.="

"; $content.="

"; $content.=""; $content.=""; $content.="

"; $content.="

"; if($row['appointment_type']=='O'){ //include('opd_entry_embed.php'); //opd form $content.="

"; $content.="

"; $content.="Visit Date & Time"; $content.="

"; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=" "; $content.=""; $content.="

"; $content.="

"; $content.=" Complaints"; $content.=" "; $content.="

"; $content.="

"; $content.=" Examination Findings"; $content.=" "; $content.="

"; $content.="

"; $content.=" Diagnosis"; $content.=""; $content.="

"; $content.="

"; $content.=" Ailment Systems"; $content.=""; $content.="

"; $content.="

"; //treatment start $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $sql_treatment="select * from treatment where appointment_id='".$row['appointment_id']."' order by treatment_id"; $result_treatment = mysqli_query($conn,$sql_treatment); $num_rows_treatment=@mysqli_num_rows($result_treatment); $tCount =0; while($row_treatment=@mysqli_fetch_array($result_treatment)) { extract($row_treatment); $content.=""; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $tCount++; }//end treatment loop $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=""; $content.=" "; $content.="

Item	Dosages	For Days	Qty	Issued	Procedure
"; $content.=" "; $content.=""; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="
"; $content.=" "; $content.=" "; $content.="

"; //treatment end $content.="

"; $content.="

"; $content.=" Referral "; $content.=" "; $content.="

"; $content.="

"; $content.="Follow Up"; $content.=""; $content.="

"; $content.="

";//end col-sm-12\\ $content.="

";//end cols-sm-9 $content.="

"; $content.="

"; $content.="Is Emergency"; $content.=" "; $content.=" "; $content.="

"; $content.="

"; $content.=""; $content.=" "; $content.=""; $content.="

"; $content.="

"; $content.=" Affected Body Parts"; $content.=""; $content.="

"; $content.="

"; $content.=" Health Advices"; $content.=""; $content.="

"; $content.="

"; $content.="Additional Precautions"; $content.=""; $content.="

"; $content.="

"; $content.=""; $content.="var ailments = \"".$row['ailment_ids']."\";"; $content.="dataarray=ailments.split(\",\");"; $content.="$(\"#ailment".$row['appointment_id']."\").val(dataarray);"; $content.="var injury_parts =\" ".$row['injury_parts']."\";"; $content.=" dataarray=injury_parts.split(\",\");"; $content.="$(\"#injury_part".$row['appointment_id']."\").val(dataarray);"; $content.="var ailmentSystems = \"".$row['ailment_system_ids']."\";"; $content.="dataarray=ailmentSystems.split(\",\");"; $content.="$(\"#ailment_system".$row['appointment_id']."\").val(dataarray);"; $content.="var bodyParts = \"".$row['injury_parts']."\";"; $content.="dataarray=bodyParts.split(\",\");"; $content.="$(\"#injury_part".$row['appointment_id']."\").val(dataarray);"; $content.="var health_advices = \"".$row['health_advices']."\";"; $content.="dataarray=health_advices.split(\",\");"; $content.="$(\"#health_advice_name".$row['appointment_id']."\").val(dataarray);"; $content.="$('#appointment_date".$row['appointment_id']."').datetimepicker({"; $content.=" format: 'DD/MM/YYYY h:mm A',"; $content.=" defaultDate: new Date(\"".$row['appointment_date']."\"),"; $content.=" maxDate: new Date(),"; $content.=" icons: {"; $content.=" time: 'fa fa-clock-o',"; $content.=" date: 'fa fa-calendar',"; $content.=" up: 'fa fa-chevron-up',"; $content.=" down: 'fa fa-chevron-down',"; $content.=" previous: 'fa fa-chevron-left',"; $content.=" next: 'fa fa-chevron-right',"; $content.=" today: 'fa fa-arrows ',"; $content.=" clear: 'fa fa-trash',"; $content.=" close: 'fa fa-times'"; $content.=" }"; $content.=" }).next().on(ace.click_event, function(){"; $content.=" $(this).prev().focus();"; $content.=" });"; $content.=" $('.show-details-btn').on('click', function(e) {"; $content.="e.preventDefault();"; $content.="$(this).closest('tr').next().toggleClass('open');"; $content.="$(this).find(ace.vars['.icon']).toggleClass('fa-angle-double-down').toggleClass('fa-angle-double-up');"; $content.="});"; $content.=""; //end of opd script }else if($row['appointment_type']=='I'){ //injury form $content.="

"; $content.="

"; $content.="Reporting Time at OHC"; $content.="

"; $content.=""; $content.=""; $content.=""; $content.=""; $content.=""; $content.=" "; $content.=""; $content.="

"; $content.="

"; $content.="Injury Time"; $content.="

"; $content.=""; $content.=""; $content.=""; $content.=" "; $content.=""; $content.="

"; $content.="

"; $content.=" Injury Description"; $content.=" "; $content.="

"; $content.="

"; $content.=" On Examination Findings"; $content.=" "; $content.="

"; $content.="

"; $content.=" Incident Location"; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.="

Business Unit	Sub Unit	Section	Sub-Section
"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="

"; $content.="

"; $content.=" Injury"; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.=" "; $content.="

Type	Part	Classification
"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="

"; $content.="

"; $content.=" Procedure"; $content.=" "; $content.="

"; $content.="

Item	Dosages	For Days	Qty	Issued	Procedure
"; $content.=" "; $content.=""; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="	"; $content.=" "; $content.="
"; $content.=" "; $content.=" "; $content.="

"; //treatment end $content.="

"; $content.="

";//end col-sm-12\\ $content.="

";//end cols-sm-9 $content.="

"; $content.="

"; $content.="Is Emergency"; $content.=" "; $content.=" "; $content.="

"; $content.="

"; $content.=""; $content.=" "; $content.=""; $content.="

"; $content.="

"; $content.="Referral"; $content.=" "; $content.="

"; $content.="

"; $content.="Follow Up"; $content.=""; $content.="

"; $content.="

"; $content.=""; $content.=" injuries = \"".$row['injury_types']."\";"; $content.="dataarray=injuries.split(\",\");"; $content.="$(\"#injury_type".$row['appointment_id']."\").val(dataarray);"; $content.=" injury_parts =\"".$row['injury_parts']."\";"; $content.="dataarray=injury_parts.split(\",\");"; $content.="$(\"#injury_part".$row['appointment_id']."\").val(dataarray);"; $content.=" injury_classes = \"".$row['injury_classes']."\";"; $content.="dataarray=injury_classes.split(\",\");"; $content.="$(\"#injury_class".$row['appointment_id']."\").val(dataarray);"; $content.="$('#appointment_date".$row['appointment_id']."').datetimepicker({"; // $content.=" format: 'DD/MM/YYYY h:mm A',"; $content.=" defaultDate: new Date(\"".$row['appointment_date']."\"),"; $content.=" maxDate: new Date(),"; $content.=" icons: {"; $content.=" time: 'fa fa-clock-o',"; $content.=" date: 'fa fa-calendar',"; $content.=" up: 'fa fa-chevron-up',"; $content.=" down: 'fa fa-chevron-down',"; $content.=" previous: 'fa fa-chevron-left',"; $content.=" next: 'fa fa-chevron-right',"; $content.=" today: 'fa fa-arrows ',"; $content.=" clear: 'fa fa-trash',"; $content.=" close: 'fa fa-times'"; $content.=" }"; $content.=" }).next().on(ace.click_event, function(){"; $content.=" $(this).prev().focus();"; $content.=" });"; $content.="$('#injury_time".$row['appointment_id']."').datetimepicker({"; $content.=" format: 'DD/MM/YYYY h:mm A',"; //$content.=" defaultDate: new Date(\"".$row['injury_time']."\"),"; $content.=" maxDate: new Date(),"; $content.=" icons: {"; $content.=" time: 'fa fa-clock-o',"; $content.=" date: 'fa fa-calendar',"; $content.=" up: 'fa fa-chevron-up',"; $content.=" down: 'fa fa-chevron-down',"; $content.=" previous: 'fa fa-chevron-left',"; $content.=" next: 'fa fa-chevron-right',"; $content.=" today: 'fa fa-arrows ',"; $content.=" clear: 'fa fa-trash',"; $content.=" close: 'fa fa-times'"; $content.=" }"; $content.=" }).next().on(ace.click_event, function(){"; $content.=" $(this).prev().focus();"; $content.=" });"; $content.=""; } $content.=" "; $content.=""; $content.=""; $content.="

No Past History found for the employee

"; $content.="