<?php
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
date_default_timezone_set("Asia/Kolkata");
include('log_entry.php');
include_once('includes/config/config.php');
error_reporting(0);

function updatePatientHealthInfo($patient_id, $problem_code, $problem_arr, $diagnosis_date, $remission_date,$flag)
{
    begin();
	$problem_arr=explode(',',$problem_arr);
    $pid = getFieldFromTable('pid', 'problem_master', 'pcode', trim($problem_code));

    // check if patient has some data already 
    $checkSql = "select * from problem_response where patient_id='" . $patient_id . "' and pid ='" . $pid . "'";
    $result = mysqli_query($GLOBALS['conn'], $checkSql);
    $row = mysqli_fetch_assoc($result);
    $num_rows = mysqli_num_rows($result);

    if ($num_rows > 0) {
        $rid = $row['rid'];
    } else {
        $insertNewPatient = "insert into problem_response set pid ='" . $pid . "',patient_id='" . $patient_id . "'";

        error_log("inserting new patient details " . $insertNewPatient);

        if (!mysqli_query($GLOBALS['conn'], $insertNewPatient)) {
            error_log("error in inserting new patient details " . mysqli_error($GLOBALS['conn']) . " query  is " . $insertNewPatient);
            rollback();
        } else {
            $rid = mysqli_insert_id($GLOBALS['conn']); // Get the last inserted row ID
        }
    }

    for ($i = 0; $i < sizeof($problem_arr); $i++) {
        // Check if the value already exists for the same rid
        $checkValueSql = "SELECT COUNT(*) FROM problem_response_details WHERE rid = '" . $rid . "' AND rvalue = '" . mysqli_real_escape_string($GLOBALS['conn'], $problem_arr[$i]) . "'";
        $valueExistsResult = mysqli_query($GLOBALS['conn'], $checkValueSql);
        $valueExistsRow = mysqli_fetch_assoc($valueExistsResult);
        $valueExists = $valueExistsRow['COUNT(*)'];

        if ($valueExists == 0) {
            // $diagnosis_date_formatted = !empty($diagnosis_date) ? date('Y-m-d', strtotime($diagnosis_date)) : null;
            $remission_date_formatted = !empty($remission_date) ? date('Y-m-d', strtotime($remission_date)) : null;

            $updateSql = "insert into problem_response_details set rid = '" . $rid . "', diagnosis_date=";
            $updateSql .=  "STR_TO_DATE('" . $diagnosis_date . "','%d/%m/%Y %h:%i %p')";
            $updateSql .= ", remission_date=";
            $updateSql .= $remission_date_formatted ? "STR_TO_DATE('" . $remission_date_formatted . "','%Y-%m-%d')" : "NULL";
            $updateSql .= ", rvalue='" . mysqli_real_escape_string($GLOBALS['conn'], $problem_arr[$i]) . "'";

            error_log("updating or inserting new problem " . mysqli_error($GLOBALS['conn']) . " query  is " . $updateSql);

            if (!mysqli_query($GLOBALS['conn'], $updateSql)) {
                error_log("error in updating or inserting the problem " . mysqli_error($GLOBALS['conn']) . " query  is " . $updateSql);
                rollback();
            }
        }else{
			if($flag == 1){
				$remission_date_formatted = !empty($remission_date) ? date('Y-m-d', strtotime($remission_date)) : null;

				$updateSql = "update problem_response_details set diagnosis_date=";
				$updateSql .=  "STR_TO_DATE('" . $diagnosis_date . "','%d/%m/%Y %h:%i %p')";
				$updateSql .= ", remission_date=";
				$updateSql .= $remission_date_formatted ? "STR_TO_DATE('" . $remission_date_formatted . "','%Y-%m-%d')" : "NULL";
				$updateSql .= ", rvalue='" . mysqli_real_escape_string($GLOBALS['conn'], $problem_arr[$i]) . "' where rid = '" . $rid . "'";

				error_log("updating or inserting new problem " . mysqli_error($GLOBALS['conn']) . " query  is " . $updateSql);

				if (!mysqli_query($GLOBALS['conn'], $updateSql)) {
					error_log("error in updating or inserting the problem " . mysqli_error($GLOBALS['conn']) . " query  is " . $updateSql);
					rollback();
				}
			}
		}
    }

    commit();
}
function updatePatientDetails($patientId, $height, $weight , $bmi) {
    global $mysqli;


    $bmi = calculateBMI($height, $weight);


    $updateQuery = "UPDATE patient_master SET height = $height, weight = $weight, bmi = $bmi WHERE patient_id = $patientId";

    if ($mysqli->query($updateQuery) === TRUE) {
        echo "Patient details updated successfully!";
    } else {
        echo "Error updating patient details: " . $mysqli->error;
    }
}

function getChronicIllness($emp_id){
	$value = array();
	$query = "select distinct diseases  from prescription_master where emp_id = '" . $emp_id . "' and (COALESCE(`remission_date`, '0000-00-00') = '0000-00-00' OR `remission_date` IS NULL)  ";

	error_log("query to get emp chronic illness for opd injury  " . $query);

	if (!$result = @mysqli_query($GLOBALS['conn'], $query)) {
		error_log("error " . mysqli_error($GLOBALS['conn']));
		exit(mysqli_error($GLOBALS['conn']));
	}
	if (mysqli_num_rows($result) > 0) {
		while ($row = mysqli_fetch_assoc($result)) {
			array_push($value, getTableFieldValue("abnormality", "abnormality_name", "abnormality_id", $row['diseases']));
		}
	}
	error_log("final data ".print_r($value,true));
	return $value;
}

function updatePatientAbnormalityInfo($patient_id,$problem_arr,$diagnosis_date){
	begin();

	$problem_arr = explode(',',$problem_arr);

	error_log("abnormality data ".print_r($problem_arr,true));

	for($i=0; $i<sizeof($problem_arr);$i++){

		$exists = "select * from prescription_master where emp_id='".$patient_id."' and diseases='".trim($problem_arr[$i])."'";

		error_log("checking for existing record in  prescription master " .$exists);

		$exitsResult = mysqli_query($GLOBALS['conn'],$exists);
		if(mysqli_num_rows($exitsResult) > 0){
			// record exists do nothing
		}else{
			// record is not present insert it

			$insert="insert into prescription_master set emp_id='".$patient_id."' , diseases='".trim($problem_arr[$i])."',diagnosis_date=STR_TO_DATE('" . $diagnosis_date . "','%d/%m/%Y %h:%i %p')";

			error_log("recording the illness in prescription master " .$insert);

			if(!$result = mysqli_query($GLOBALS['conn'],$insert)){
				error_log("error in recording the illness in prescription master" . mysqli_error($GLOBALS['conn']). " query ".$insert);
				rollback();
			}
		}
	}

	commit();
}

function resetOPDConsumablesStoreItemsStock($opd_id, $ohc_location_id)
{
	$query_for_treatment = " select issued_qty,medicine from  opd_consumables where consume_id='" . $opd_id . "' ";
	$result_for_treatemt = mysqli_query($GLOBALS['conn'], $query_for_treatment);
	while ($row_for_treatemnt = mysqli_fetch_array($result_for_treatemt)) {
		$issued_qty = $row_for_treatemnt['issued_qty'];
		$item_id = $row_for_treatemnt['medicine'];
		$consum_item_batch_no = $row_for_treatemnt['consum_item_batch_no'];
		$stock_qty = getStockQtyAtStoreLevel($item_id, $ohc_location_id,$consum_item_batch_no);
		$total_qty = floatval($stock_qty) + floatval($issued_qty);
		$query_for_reset_item_dispensary_stock = " update item_stock set stock_qty= $total_qty where item_id=$item_id and ohc_type_id=$ohc_location_id ";
		mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock);
	}
}

function getDateInDbFormat($inputDate){
	error_log("date we getting in function 2 ".$inputDate);
	$date = date_create_from_format('d/m/Y', $inputDate);

    if ($date === false) {
        $date = date_create_from_format('Y/m/d', $inputDate);
    }

    if ($date === false) {
        $date = date_create_from_format('d-m-Y', $inputDate);
    }

    if ($date === false) {
        $date = date_create_from_format('Y-m-d', $inputDate);
    }

    if ($date !== false) {
        return $date->format('Y-m-d');
    } else {
        return 'Invalid date format';
    }
}

function saveHighlightedParams($medical_exam_id, $highlight_color, $hiddenHighlighter)
{
	$rows_highlighted = " DELETE FROM medical_examination_highlighted where medical_exam_id = '" . $medical_exam_id ."' ";

	error_log("deleteHighlightedParams Query: " . $rows_highlighted);

	if(!$result_highlight = mysqli_query($GLOBALS['conn'], $rows_highlighted)){
		error_log("deleteHighlightedParams:" . mysqli_error($GLOBALS['conn']) . "Failed Query:" . $rows_highlighted);
	}

	$keys = array_keys($highlight_color);
	error_log("array keys  for highlighted param " . print_r($keys,true));

	for($i=0; $i<sizeof($keys); $i++){
		$color_query = "insert into medical_examination_highlighted set medical_exam_id='" . $medical_exam_id . "', highlighted_fields='" . $keys[$i] . "', highlighted_color ='".$highlight_color[$keys[$i]]."' ";
		error_log("color query" . $color_query);
		if (!$result = @mysqli_query($GLOBALS['conn'], $color_query)) {
			error_log("saveHighlightedParams:" . mysqli_error($GLOBALS['conn']) . "Failed Query:" . $color_query);
			exit(mysqli_error($GLOBALS['conn']));
		}
	}
}

function calculateHealthIndex($bp1,$bp2,$bmi,$sugar,$cholestrol){
		$bp_score = 0;
		$bmi_score = 0;
		$sugar_score = 0;
		$cholestrol_score = 0;
		$total_score = 0;
		if ($bp1 > 140 && $bp2 > 90) {
			$bp_score = 4;
		} else if ($bp1 > 120 && $bp1 < 140 && $bp2 > 80 && $bp2 < 90) {
			$bp_score = 2;
		} else {
			$bp_score = 0;
		}

		error_log("bp score" . $bp_score);

		if ($sugar > 200) {
			$sugar_score = 4;
		} else if ($sugar > 139 && $sugar < 200) {
			$sugar_score = 2;
		} else {
			$sugar_score = 0;
		}

		error_log("sugar score" . $sugar_score);

		if ($bmi > 30) {
			$bmi_score = 4;
		} else if ($bmi > 25 && $bmi < 30) {
			$bmi_score = 2;
		} else {
			$bmi_score = 0;
		}

		error_log("bmi score" . $bmi_score);

		if ($cholestrol > 240) {
			$cholestrol_score = 4;
		} else if ($cholestrol > 200 && $cholestrol < 240) {
			$cholestrol_score = 2;
		} else {
			$cholestrol_score = 0;
		}

		error_log("cholestrol score" . $cholestrol_score);

		$total_score =$bp_score +$bmi_score +$sugar_score + $cholestrol_score;

		return$total_score;
}


function getBreadCrumbs()

{
	$filename = basename($_SERVER['REQUEST_URI']);

	$sql_root = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id,m.icon_text  from assign_menu a, menu_master m where a.menu_id= m.menu_id and upper(m.menu_url) like upper('%" . $filename . "') and a.role_id='" . $_SESSION['RoleId'] . "' ";

	// echo $sql_master;

	$res_root = mysqli_query($GLOBALS['conn'], $sql_root);

	$breadcrum_str = "";

	$num_rows_root = @mysqli_num_rows($res_root);

	if ($num_rows_root == 1) {

		if ($root_rowmaster = @mysqli_fetch_array($res_root)) {

			$child_last_menu_id = $root_rowmaster['menu_id'];

			$child_last_menu_url = $root_rowmaster['menu_url'];

			$child_last_menu_name = $root_rowmaster['menu_name'];

			$child_last_parent_menuid = $root_rowmaster['parent_id'];

			$breadcrum_str = "<li class='active'><a href='" . $child_last_menu_url . "'>" . $child_last_menu_name . "</a></li>" . $breadcrum_str;

			if ($child_last_parent_menuid > 0) {

				$sql_level1 = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id,m.icon_text  from assign_menu a, menu_master m where a.menu_id= m.menu_id and  cast(m.menu_id AS DECIMAL(12,2)) = cast('" . $child_last_parent_menuid . "' AS DECIMAL(12,2))  ";

				// echo $sql_level1;

				$res_level1 = mysqli_query($GLOBALS['conn'], $sql_level1);

				$num_rows_level1 = @mysqli_num_rows($res_level1);

				if ($num_rows_level1 == 1) {

					if ($level1_rowmaster = @mysqli_fetch_array($res_level1)) {

						$level1_menu_id = $level1_rowmaster['menu_id'];

						$level1_menu_url = $level1_rowmaster['menu_url'];

						$level1_menu_name = $level1_rowmaster['menu_name'];

						$level1_parent_menuid = $level1_rowmaster['parent_id'];

						$breadcrum_str = "<li class=''><a href='" . $level1_menu_url . "'>" . $level1_menu_name . "</a></li>" . $breadcrum_str;

						if ($level1_parent_menuid > 0) {

							$sql_level2 = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id,m.icon_text  from assign_menu a, menu_master m where a.menu_id= m.menu_id and cast(m.menu_id AS DECIMAL(12,2)) = cast('" . $level1_parent_menuid . "' AS DECIMAL(12,2)) ";

							// echo $sql_level2;

							$res_level2 = mysqli_query($GLOBALS['conn'], $sql_level2);

							$num_rows_level2 = @mysqli_num_rows($res_level2);

							if ($num_rows_level2 == 1) {

								if ($level2_rowmaster = @mysqli_fetch_array($res_level2)) {

									$level2_menu_id = $level2_rowmaster['menu_id'];

									$level2_menu_url = $level2_rowmaster['menu_url'];

									$level2_menu_name = $level2_rowmaster['menu_name'];

									$level2_parent_menuid = $level2_rowmaster['parent_id'];

									$level2_icon_text = $level2_rowmaster['icon_text'];

									$breadcrum_str = "<li class=''><a href='" . $level2_menu_url . "'><i class='" . $level2_icon_text . "'></i>" . $level2_menu_name . "</a></li>" . $breadcrum_str;
								}
							}
						}
					}
				}
			}
		}
	}

	$breadcrum_str = "<ul class=\"breadcrumb\">" . $breadcrum_str . "</ul>";

	return $breadcrum_str;
}
function isAccessible($roleId, $menu_key, $operationType)

{
	if ($menu_key == null || $menu_key == '') {

		$menu_key = $_SESSION['menu_key'];
		error_log("menu key:".$menu_key);
	}
	error_log("menu key:".$menu_key);
	$accessLevel = getaccesslevel($roleId, $menu_key);

	// echo "accessLevel:".$accessLevel;

	$accessLevelNumValue = ($accessLevel == 'E') ? 3 : (($accessLevel == 'W') ? 2 : (($accessLevel == 'R') ? 1 : 0));

	// echo "accessLevelNumValue:".$accessLevelNumValue;

	$operationTypeNumValue = ($operationType == 'E') ? 3 : (($operationType == 'W') ? 2 : (($operationType == 'R') ? 1 : 0));

	// echo "operationTypeNumValue:".$operationTypeNumValue;

	// echo $operationTypeNumValue<=$accessLevelNumValue;

	if ($operationTypeNumValue <= $accessLevelNumValue) {

		// echo "returning true";

		return true;
	} else {

		// echo "returning false";

		return false;
	}
}


function getTodayProcurementCount()

{
	$sql_division = "select count(procurement_id) count from procurement where DATE(procurement_date) = CURDATE() and ohc_type_id='".$_SESSION['current_ohcttype']."'";

	error_log("row count:" . $sql_division);

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayIssueCount()

{
	$sql_division = "select count(stock_issue_id) count from stock_issue where DATE(issue_date) = CURDATE() and issue_ohc_type_id='".$_SESSION['current_ohcttype']."'";

	error_log("row count:" . $sql_division);

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getExpiredMedCount()

{
	$sql_division = "select count(id) count from cleanup_item_stock where ohc_type_id='".$_SESSION['current_ohcttype']."'";

	error_log("row count:" . $sql_division);

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getIndentCount()

{
	$sql_division = "select count(indent_id) count from indent_master where year(indent_date)=year(NOW())";

	error_log("row count:" . $sql_division);

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTotalStockCount()

{
	$sql_division = "select count(distinct item_id) count from item_stock where stock_qty>0 and ohc_type_id='".$_SESSION['current_ohcttype']."'";

	error_log("row count:" . $sql_division);

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayHealthSurvellianceCount()
{
    $sql_division = "select count(checkup_id) count from checkup_form where is_test_completed='Y' and  DATE(checkup_date) = CURDATE() and (current_status!='MRP' and current_status!='MRA') and ohc_type_id='".$_SESSION['current_ohcttype']."' ";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}

function getTodayappointment_detailsCount()
{
    $sql_division = "select count(id) count from appointment_details where   DATE(date) = CURDATE()  and ohc_type_id='".$_SESSION['current_ohcttype']."' ";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}

function getTodayappointment_details_pending_Count()
{
    $sql_division = "select count(id) count from appointment_details where   DATE(date) = CURDATE()  and status='BOOKED' and ohc_type_id='".$_SESSION['current_ohcttype']."' ";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}
function getTodayLabSurvellianceCount(){
	$sql_division_count = "select count(checkup_id) as count from checkup_form where DATE(checkup_date) = CURDATE() and current_status='MRA' and ohc_type_id='".$_SESSION['current_ohcttype']."' ";
    $result_name_count = mysqli_query($GLOBALS['conn'],$sql_division_count);
    if ($row_name_count = @mysqli_fetch_array($result_name_count)) {
        return $row_name_count['count'];
    }
}
function getTodayVendorRateApprovalCount(){
$user_id=($_SESSION['user_id']);
   
$contractor_id=getTableFieldValue('tbl_users','vendor_id','user_id',$user_id);

	$sql_division_count = "select count((indent_id)) as count from indent_master  where DATE(indent_date) = CURDATE() and status in ('APPROVED_LEVEL_2','PENDING_RATE','DRAFT_VENDOR_RATE') and indent_id in ( select indent_id from indent_items where vendor_id='$contractor_id' and status in ('',null) ) ";
    $result_name_count = mysqli_query($GLOBALS['conn'],$sql_division_count);
    if ($row_name_count = @mysqli_fetch_array($result_name_count)) {
        return $row_name_count['count'];
    }
}

function getpendingIndentCountLeve1(){
	$sql_pending_indent_count = "select count(indent_id) as count from indent_master where  status='APPROVED_LEVEL_1'";
    $result_pending_indent_count = mysqli_query($GLOBALS['conn'],$sql_pending_indent_count);
    if ($row_pending_indent_count = @mysqli_fetch_array($result_pending_indent_count)) {
        return $row_pending_indent_count['count'];
    }
}

function getpendingIndentCountLeve2(){
	$sql_pending_indent_count = "select count(indent_id) as count from indent_master where  status='APPROVED_LEVEL_2'";
    $result_pending_indent_count = mysqli_query($GLOBALS['conn'],$sql_pending_indent_count);
    if ($row_pending_indent_count = @mysqli_fetch_array($result_pending_indent_count)) {
        return $row_pending_indent_count['count'];
    }
}
function getcreatedIndentCountLeve2($status){
	$sql_pending_indent_count = "select count(indent_id) as count from indent_master  where  indent_id in (select indent_id from indent_items where status='$status')";
   error_log('count quotation'.$sql_pending_indent_count);
	$result_pending_indent_count = mysqli_query($GLOBALS['conn'],$sql_pending_indent_count);
    if ($row_pending_indent_count = @mysqli_fetch_array($result_pending_indent_count)) {
        return $row_pending_indent_count['count'];
    }
}
function getGRN(){
	$sql_pending_indent_count = "select count(*) as count from indent_master where indent_id in  (select DISTINCT(indent_id) from indent_items where status in ('DISPATCHE','PENDING_DISPATCH')) ";
    $result_pending_indent_count = mysqli_query($GLOBALS['conn'],$sql_pending_indent_count);
    if ($row_pending_indent_count = @mysqli_fetch_array($result_pending_indent_count)) {
        return $row_pending_indent_count['count'];
    }
}

function getTodayffiSurvellianceCount(){
	$sql_division = "select count(response_id) count from questionaire_master_response where form_type='ffi' and  DATE(screen_date) = CURDATE() ";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}

function getTodaydlfSurvellianceCount(){
	$sql_division = "select count(response_id) coun from questionaire_master_response where form_type='dlf' and  DATE(screen_date) = CURDATE() ";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}

function getTodaychsSurvellianceCount(){
	$sql_division = "select count(response_id) count from questionaire_master_response where form_type='chs' and  DATE(screen_date) = CURDATE() ";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}
function getTodaykhsSurvellianceCount(){
	$sql_division = "select count(response_id) count from questionaire_master_response where form_type='khs' and  DATE(screen_date) = CURDATE() ";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}

function getHealthSurvellianceCount()
{
    $sql_division = "select count(checkup_id) count from checkup_form where current_status='Approved' and  DATE(checkup_date) = CURDATE()";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}


function getPending_doctor_HealthSurvellianceCount()
{
    // $sql_division = "select count(checkup_id) count from checkup_form where is_test_completed!='Y'";
    $sql_division = "SELECT count(checkup_id) FROM checkup_form  where current_status='DRP' and DATE(checkup_date) = CURDATE()";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        error_log('pending' . print_r($row_name, true));
        return $row_name['0'];
    }
}
function getPending_Medical_HealthSurvellianceCount()
{
    // $sql_division = "select count(checkup_id) count from checkup_form where is_test_completed!='Y'";
    $sql_division = "SELECT count(checkup_id) FROM checkup_form  where current_status='MDP' and DATE(checkup_date) = CURDATE() and ohc_type_id='".$_SESSION['current_ohcttype']."'";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        error_log('pending' . print_r($row_name, true));
        return $row_name['0'];
    }
}

function getPending_Lab_HealthSurvellianceCount(){
	$sql_division = "SELECT count(checkup_id) FROM checkup_form  where current_status='MRP' and DATE(checkup_date) = CURDATE() and ohc_type_id='".$_SESSION['current_ohcttype']."'";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        error_log('pending' . print_r($row_name, true));
        return $row_name['0'];
    }
}
function getPendingHIRAFormCount(){
    $sql_division = "SELECT  count(id) count from hazard_observation where status='Pending'" ;
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        return $row_name['count'];
    }
}

// Function to get the count of today's HIRA Form cases
function getTodayHIRAFormCount(){
    $hazard_id =  $row_hira['id']; // Assuming you have a user ID stored in the session
    $sql = "SELECT COUNT(*) as count FROM hazard_observation WHERE id = $hazard_id";
    $result = mysqli_query($GLOBALS['conn'], $sql);

    if ($row = @mysqli_fetch_array($result)) {
        return $row['count'];
    }
}

function getPendingDISPATCHECount(){
	$user_id=$_SESSION['user_id'];
error_log('xxxxxxxxx'.$user_id);

$contractor_id=getTableFieldValue('tbl_users','vendor_id','user_id',$user_id);

	$sql_division = "SELECT count(indent_id) FROM indent_master where status not in ('DISPATCHE','REJECTED') and indent_id in (select distinct(indent_id) from indent_items where  vendor_id='".$contractor_id."' and status in ('APPROVED','REJECTED','PENDING_DISPATCH','DRAFT_DISPATCH','GRN_APPROVED','COMPLETED'))  ";
 error_log('dispatch count'.$sql_division);
	$result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        error_log('pending' . print_r($row_name, true));
        return $row_name['0'];
    }
}
function getYearlyApprovedIndentCount(){
	
	$month_indent=date("m");

	if($month_indent<=3)$year_indent=(date("Y")-1);
	else $year_indent=date("Y");
	$sql_division = "SELECT count(indent_id) FROM indent_master  where status NOT IN ('draft','','PENDING','APPROVED_LEVEL_1') and DATE(indent_date) between STR_TO_DATE('01/04/" . $year_indent . "','%d/%m/%Y')  and date(now())";
    $result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
        error_log('pending' . print_r($row_name, true));
        return $row_name['0'];
    }
}
function getYearlyApprovedIndentCountSuperviser(){
	
	$month_indent=date("m");

	if($month_indent<=3)$year_indent=(date("Y")-1);
	else $year_indent=date("Y");
	$sql_division = "SELECT count(indent_id) FROM indent_master  where status NOT IN ('draft','','PENDING','APPROVED_LEVEL_1','APPROVED_LEVEL_2') and DATE(indent_date) between STR_TO_DATE('01/04/" . $year_indent . "','%d/%m/%Y')  and date(now())";
	error_log('pending' . $sql_division);

	$result_name = mysqli_query($GLOBALS['conn'],$sql_division);
    if ($row_name = @mysqli_fetch_array($result_name)) {
               return $row_name['0'];
    }
}

function getTodayTotalcase($type){
	$sql_division = "SELECT count(*) FROM questionaire_master_response where  DATE(screen_date) = CURDATE()  AND  form_type = '".$type."'";
    error_log("total".$sql_division);
	$result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}
function getPending_infection(){
	$sql_division = "SELECT count(*) FROM questionaire_master_response where DATE(screen_date) = CURDATE() AND approval_status = 'N' AND f_status = 'DRP' AND form_type = 'ffi'";
    error_log("ffi".$sql_division);
	$result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}

function getapproval_infection(){
	$sql_division = "SELECT count(*) FROM questionaire_master_response where DATE(screen_date) = CURDATE() AND approval_status = 'Y' AND f_status = 'DRP' AND form_type = 'ffi'";
    $result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}
function getPending_dlf(){
	$sql_division = "SELECT count(*) FROM questionaire_master_response where DATE(screen_date) = CURDATE() AND approval_status = 'N' AND f_status = 'DRP' AND form_type = 'dlf'";
   error_log("dlf pe".$sql_division);
	$result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}

function getapproval_dlf(){
	$sql_division = "SELECT count(*)  FROM questionaire_master_response where DATE(screen_date) = CURDATE() AND approval_status = 'Y' AND f_status = 'DRP' AND form_type = 'dlf'";

	$result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}

function getPending_canteen(){
	
	 $sql_division = "SELECT count(*) FROM questionaire_master_response  where DATE(screen_date) = CURDATE() AND approval_status = 'N' AND f_status = 'DRP' AND form_type = 'chs'";
    $result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}

function getapproval_canteen(){
$sql_division = "SELECT count(*) FROM questionaire_master_response where DATE(screen_date) = CURDATE()  AND approval_status = 'Y' AND f_status = 'DRP' AND form_type = 'chs'";
    $result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}
function getPending_kitchen(){
	 $sql_division = "SELECT count(*) FROM questionaire_master_response where DATE(screen_date) = CURDATE() AND approval_status = 'N' AND f_status = 'DRP' AND form_type = 'khs'";
    $result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}
function getPending_indent(){
	$sql_division = "SELECT count(*) FROM indent_master where DATE(indent_date) = CURDATE() AND status in ('PENDING','REJECTED')   and ohc_type_id = '" . $_SESSION['current_ohcttype'] . "'";
   $result = mysqli_query($GLOBALS['conn'],$sql_division);
   $row= mysqli_fetch_row($result);
return $row[0];
}

function getTodayapproval_indent(){
	$sql_division = "SELECT count(*) FROM indent_master where DATE(indent_date) = CURDATE() and ohc_type_id = '" . $_SESSION['current_ohcttype'] . "' ";
   $result = mysqli_query($GLOBALS['conn'],$sql_division);
   $row= mysqli_fetch_row($result);
return $row[0];
}

function getPending_inventory_checklist_status(){
	$sql_division = "SELECT count(*) FROM inventory_checklist_status where DATE(approve_date) = CURDATE() AND status = 'PENDING' and ohc_type_id='" . $_SESSION ['current_ohcttype'] . "'";
   $result = mysqli_query($GLOBALS['conn'],$sql_division);
   $row= mysqli_fetch_row($result);
return $row[0];
}


function getTodayapproval_inventory_checklist_status(){
	$sql_division = "SELECT count(*) FROM inventory_checklist_status where DATE(approve_date) = CURDATE()  and ohc_type_id='" . $_SESSION ['current_ohcttype'] . "' ";
   $result = mysqli_query($GLOBALS['conn'],$sql_division);
   $row= mysqli_fetch_row($result);
return $row[0];
}
function getapproval_kitchen(){
$sql_division = "SELECT count(*) FROM questionaire_master_response where DATE(screen_date) = CURDATE() AND approval_status = 'Y' AND f_status = 'DRP' AND form_type = 'khs'";
    $result = mysqli_query($GLOBALS['conn'],$sql_division);
	$row= mysqli_fetch_row($result);
return $row[0];
}

function getaccesslevel($Role_id, $menu_id)

{
	$sql_role = " select access_level from assign_menu where role_id='" . $Role_id . "' and menu_id= '" . $menu_id . "' ";

	$res = mysqli_query($GLOBALS['conn'], $sql_role);
	error_log("access level:".$sql_role);

	$accesslevel = "";

	if ($row = @mysqli_fetch_array($res)) {

		@extract($row);

		$accesslevel = $row['access_level'];
	}

	return $accesslevel;
}
function generate_options($sql, $selIndx = '', $option_id, $option_name, $chk_id = '', $dis)

{
	$res = @mysqli_query($GLOBALS['conn'], $sql);
	error_log("field by" . $sql);
	while ($rows = @mysqli_fetch_array($res)) {

		if ($chk_id == '' || $chk_id != $rows[$option_id]) {

			if ($rows[$option_id] == $selIndx) {

				echo "<option value='" . $rows[$option_id] . "' selected>" . $rows[$option_name] . "</option>";
			} else if ($rows[$option_id] == '1' && $dis == 'div') {

				echo "<option value='" . $rows[$option_id] . "' disabled>" . $rows[$option_name] . "</option>";
			} else {

				echo "<option value='" . $rows[$option_id] . "'>" . $rows[$option_name] . "</option>";

				// error_log("echo "."<option value='" . $rows[$option_id] . "'>" . $rows[$option_name] . "</option>");
			}
		}
	}
}
function getTreatmentText($appointment_id)

{
	$sql = "select t.item_id, item_name, for_days, dosage from treatment t, tbl_items i where t.item_id=i.item_id and t.appointment_id='" . $appointment_id . "' and is_display!='N'";

	$res = @mysqli_query($GLOBALS['conn'], $sql);

	$returnStr = "";

	while ($rows = @mysqli_fetch_array($res)) {

		extract($rows);

		$returnStr .= getItemWithFormName($rows['item_id']) . " " . $rows['dosage'] . " for " . $rows['for_days'] . " days" . "<br>";
	}

	return $returnStr;
}

function getTreatmentTextPdf($appointment_id)

{
	$sql = "select t.item_id, item_name, for_days, dosage from treatment t, tbl_items i where t.item_id=i.item_id and t.appointment_id='" . $appointment_id . "' and is_display!='N'";

	$res = @mysqli_query($GLOBALS['conn'], $sql);

	$returnStr = "";

	while ($rows = @mysqli_fetch_array($res)) {

		extract($rows);

		$returnStr .= getItemWithFormNamePdf($rows['item_id']) . " " . $rows['dosage'] . " for " . $rows['for_days'] . " days" . "<br>";
	}

	return $returnStr;
}
function getTreatmentTextForGuest($appointment_id)

{
	$sql = "select t.item_id, item_name, for_days, dosage from guest_treatment t, tbl_items i where t.item_id=i.item_id and t.appointment_id='" . $appointment_id . "'";

	$res = @mysqli_query($GLOBALS['conn'], $sql);

	$returnStr = "";

	while ($rows = @mysqli_fetch_array($res)) {

		extract($rows);

		$returnStr .= $rows['item_name'] . " " . $rows['dosage'] . " for " . $rows['for_days'] . " days" . "<br>";
	}

	return $returnStr;
}
function getCommaSeperatedValuesForInClause($sql, $whereColforIn, $commaSeperatedValuesForIn)

{
	$realArray = explode(',', $commaSeperatedValuesForIn);

	$stringForIn = "'" . implode("','", $realArray) . "'";

	$sql .= " where " . $whereColforIn . " in (" . $stringForIn . ")";

	// return $sql;

	$res = @mysqli_query($GLOBALS['conn'], $sql);

	$returnStr = "";

	while ($rows = @mysqli_fetch_array($res)) {

		extract($rows);

		$returnStr .= $rows[0] . ", ";
	}

	if (strlen($returnStr) == 0) {

		return $returnStr;
	}

	return substr($returnStr, 0, strlen($returnStr) - 2);
}

function getCommaSeperatedValuesForInClauseWithSpace($sql, $whereColforIn, $commaSeperatedValuesForIn)

{
	$realArray = explode(', ', $commaSeperatedValuesForIn);

	$stringForIn = "'" . implode("','", $realArray) . "'";

	$sql .= " where " . $whereColforIn . " in (" . $stringForIn . ")";

	// return $sql;

	$res = @mysqli_query($GLOBALS['conn'], $sql);

	$returnStr = "";

	while ($rows = @mysqli_fetch_array($res)) {

		extract($rows);

		$returnStr .= $rows[0] . ",";
	}

	if (strlen($returnStr) == 0) {

		return $returnStr;
	}

	return substr($returnStr, 0, strlen($returnStr) - 2);
}
function getCommaSeperatedValuesToInClause($commaSeperatedValuesForIn)

{
	$realArray = explode(',', $commaSeperatedValuesForIn);

	$stringForIn = "'" . implode("','", $realArray) . "'";

	$returnStr = " (" . $stringForIn . ")";

	return $returnStr;
}
function generate_Firm($sql, $selIndx = '', $option_id, $option_name, $chk_id = '')

{
	$res = mysqli_query($GLOBALS['conn'], $sql);

	while ($rows = mysqli_fetch_array($res)) {

		if ($chk_id == '' || $chk_id != $rows[$option_id]) {

			if ($rows[$option_id] == $selIndx) {

				echo "<option value='" . $rows[$option_id] . "' >" . $rows[$option_name] . "</option>";
			} else {

				echo "<option value='" . $rows[$option_id] . "'>" . $rows[$option_name] . "</option>";
			}
		}
	}
}

// ***************************** FUNCTION TO CONVERT DATE FROM ONE FORMAT TO ANOTHER ************************//
function date_conversion($date_str, $sourse_format, $desired_format)

{
	$source_day = "";

	$source_month = "";

	$source_year = "";

	switch ($sourse_format) {

		case "Y-m-d":

			$sourse_arr = split('[-/]', $date_str);

			$source_day = $sourse_arr[2];

			$source_month = $sourse_arr[1];

			$source_year = $sourse_arr[0];

			break;

		case "y-m-d":

			$sourse_arr = split('[-/]', $date_str);

			$source_day = $sourse_arr[2];

			$source_month = $sourse_arr[1];

			$source_year = $sourse_arr[0];

			break;

		case "d-m-Y":

			$sourse_arr = @split('[-/]', $date_str);

			$source_day = $sourse_arr[0];

			$source_month = $sourse_arr[1];

			$source_year = $sourse_arr[2];

			break;

		case "d-m-Y":

			$sourse_arr = @split('[-/]', $date_str);

			$source_day = $sourse_arr[0];

			$source_month = $sourse_arr[1];

			$source_year = $sourse_arr[2];

			break;

		case "m-d-Y":

			$sourse_arr = split('[-/]', $date_str);

			$source_day = $sourse_arr[1];

			$source_month = $sourse_arr[0];

			$source_year = $sourse_arr[2];

			break;
	}

	if ($source_month >= 1 && $source_day >= 1 && $source_year >= 1970) {

		$result_date = date($desired_format, mktime(0, 0, 0, $source_month, $source_day, $source_year));
	} else {

		$result_date = "";
	}

	return $result_date;
}

// *************************************** END FUNCTION *****************************************************//
function generateOptionForMultiple($tableName, $nameCol, $idCol, $selectedId, $dis)

{
	$sql = "select $nameCol,$idCol from $tableName order by $nameCol ";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		$selectedIdArray = explode(",", $selectedId);

		$flag = 0;

		for ($i = 0; $i < count($selectedIdArray); $i++) {

			if ($row[$idCol] == $selectedIdArray[$i]) {

				$flag = 1;
			}
		}

		if ($flag == 1) {

			$optionValue .= "<option value='" . $row[$idCol] . "' selected=selected>" . $row[$nameCol] . "</option>";
		} else {

			$optionValue .= "<option value='" . $row[$idCol] . "' >" . $row[$nameCol] . "</option>";
		}
	}

	return $optionValue;
}

function generateOptionWithWhereClauseOrderBy($tableName, $nameCol, $idCol, $selectedId, $dis, $whereCol, $whereVal, $order)

{
	$sql = "select $nameCol,$idCol from $tableName where $whereCol=$whereVal  order by $order ";
	error_log($sql);
	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value='" . $row[$idCol] . "' selected=selected>" . $row[$nameCol] . "</option>";

		else if ($dis == 'div' && $row[$idCol] == '1') {

			$optionValue .= "<option value='" . $row[$idCol] . "' disabled >" . $row[$nameCol] . "</option>";
		} else

			$optionValue .= "<option value='" . $row[$idCol] . "'>" . $row[$nameCol] . "</option>";
	}

	return $optionValue;
}


function generateOptionForMultipleActive($tableName, $nameCol, $idCol, $selectedId, $dis)

{
	$sql = "select $nameCol,$idCol from $tableName where is_active='Y' order by $nameCol ";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		$selectedIdArray = explode(",", $selectedId);

		$flag = 0;

		for ($i = 0; $i < count($selectedIdArray); $i++) {

			if ($row[$idCol] == $selectedIdArray[$i]) {

				$flag = 1;
			}
		}

		if ($flag == 1) {

			$optionValue .= "<option value='" . $row[$idCol] . "' selected=selected>" . $row[$nameCol] . "</option>";
		} else {

			$optionValue .= "<option value='" . $row[$idCol] . "' >" . $row[$nameCol] . "</option>";
		}
	}

	return $optionValue;
}

function generateOption($tableName, $nameCol, $idCol, $selectedId, $dis)

{
	$sql = "select $nameCol,$idCol from $tableName order by $nameCol ";
	error_log('xxx'.$selectedId);
	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value='" . $row[$idCol] . "' selected=selected>" . $row[$nameCol] . "</option>";

		else if ($dis == 'div' && $row[$idCol] == '1') {

			$optionValue .= "<option value='" . $row[$idCol] . "' disabled >" . $row[$nameCol] . "</option>";
		} else

			$optionValue .= "<option value='" . $row[$idCol] . "'>" . $row[$nameCol] . "</option>";
	}

	return $optionValue;
}
function generateOptionWithWhereClause($tableName, $nameCol, $idCol, $selectedId, $dis, $whereCol, $whereVal)

{
	$sql = "select $nameCol,$idCol from $tableName where $whereCol=$whereVal  order by $nameCol ";
	error_log($sql."sql");

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value='" . $row[$idCol] . "' selected=selected>" . $row[$nameCol] . "</option>";

		else if ($dis == 'div' && $row[$idCol] == '1') {

			$optionValue .= "<option value='" . $row[$idCol] . "' disabled >" . $row[$nameCol] . "</option>";
		} else

			$optionValue .= "<option value='" . $row[$idCol] . "'>" . $row[$nameCol] . "</option>";
	}

	return $optionValue;
}
function generateOptionWithWhereClauseWithIn($tableName, $nameCol, $idCol, $selectedId, $dis, $whereCol, $whereVal)

{
	$sql = "select $nameCol,$idCol from $tableName where $whereCol in $whereVal  order by $nameCol ";
error_log($whereVal.'fun query'.$sql);
	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value='" . $row[$idCol] . "' selected=selected>" . $row[$nameCol] . "</option>";

		else if ($dis == 'div' && $row[$idCol] == '1') {

			$optionValue .= "<option value='" . $row[$idCol] . "' disabled >" . $row[$nameCol] . "</option>";
		} else

			$optionValue .= "<option value='" . $row[$idCol] . "'>" . $row[$nameCol] . "</option>";
	}

	return $optionValue;
}
function generateOptionWithWhereClause1($tableName, $nameCol, $idCol, $selectedId, $dis, $whereCol, $whereVal)

{
	$sql = "select $nameCol,$idCol from $tableName where $whereCol='" . $whereVal . "'  order by $nameCol ";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);
	// error_log("fhshrfhfhsrhshr" . $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value='" . $row[$idCol] . "' selected=selected>" . $row[$nameCol] . "</option>";

		else if ($dis == 'div' && $row[$idCol] == '1') {

			$optionValue .= "<option value='" . $row[$idCol] . "' disabled >" . $row[$nameCol] . "</option>";
		} else

			$optionValue .= "<option value='" . $row[$idCol] . "'>" . $row[$nameCol] . "</option>";
	}

	return $optionValue;
}

function generateCheckupOptionsAccToOhc($tableName, $nameCol, $idCol, $selectedId, $dis,$whereCol,$whereVal, $sessionOHCTypeId)
{
    $sql = "SELECT $nameCol, $idCol, ohc_ids FROM $tableName WHERE FIND_IN_SET('$sessionOHCTypeId', ohc_ids) > 0 and $whereCol = '$whereVal' ORDER BY $nameCol";
    
    $resultSet = mysqli_query($GLOBALS['conn'], $sql);

	error_log("generate checkup query ".$sql);
    
    $optionValue = ''; // Initialize the option values
    
    while ($row = mysqli_fetch_array($resultSet)) {
        if ($row[$idCol] == $selectedId) {
            $optionValue .= "<option value='" . $row[$idCol] . "' selected='selected'>" . $row[$nameCol] . "</option>";
        } else if ($dis == 'div' && $row[$idCol] == '1') {
            $optionValue .= "<option value='" . $row[$idCol] . "' disabled>" . $row[$nameCol] . "</option>";
        } else {
            $optionValue .= "<option value='" . $row[$idCol] . "'>" . $row[$nameCol] . "</option>";
        }
    }
    
    return $optionValue;
}

function generateMedicineOptions($selectedId, $dis)

{
	$sql = "SELECT item_name,form_name, item_id from tbl_items i, medicine_form m where i.item_form_id=m.form_id order by m.form_name ";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row['item_id'] == $selectedId)

			$optionValue .= "<option value='" . $row['item_id'] . "' selected=selected>" . $row['form_name'] . " " . $row['item_name'] . "</option>";

		else if ($dis == 'div' && $row[$idCol] == '1') {

			$optionValue .= "<option value='" . $row['item_id'] . "' disabled >" . $row['form_name'] . " " . $row['item_name'] . "</option>";
		} else

			$optionValue .= "<option value='" . $row['item_id'] . "'>" . $row['form_name'] . " " . $row['item_name'] . "</option>";
	}

	return $optionValue;
}
function generateOptForVender($tableName, $nameCol, $idCol, $selectedId)

{
	$sql = "select $nameCol,$idCol from $tableName where purchase='Y' order by $nameCol asc";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value=" . $row[$idCol] . " selected=selected>" . $row[$nameCol] . "</option>";

		else

			$optionValue .= "<option value=" . $row[$idCol] . " >" . $row[$nameCol] . "</option>";
	}

	return $optionValue;
}
function generateDetailOption($tableName, $nameCol, $idCol, $selectedId)

{
	$sql = "select $nameCol,$idCol from $tableName order by $idCol asc ";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value=" . preg_replace('/[\r\n]+/', "", $row[$idCol]) . " selected=selected>" . preg_replace('/[\r\n]+/', "", $row[$idCol]) . "</option>";

		else

			$optionValue .= "<option value=" . preg_replace('/[\r\n]+/', "", $row[$idCol]) . ">" . preg_replace('/[\r\n]+/', "", $row[$idCol]) . "</option>";
	}

	return $optionValue;
}
function generateDetailOptionForCode($tableName, $nameCol, $idCol, $selectedId)

{
	$sql = "select $nameCol,$idCol from $tableName ";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		$optionValue .= "<option  >" . preg_replace('/[^a-zA-Z0-9\']+/', "", $row[$nameCol]) . "</option>";
	}

	return $optionValue;
}
function getDetailOption($tableName, $nameCol, $idCol, $selectedId)

{
	$sql = "select $nameCol,$idCol from $tableName order by $idCol asc ";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value=" . preg_replace('/[\r\n]+/', "", $row[$idCol]) . " selected=selected>" . preg_replace('/[\r\n]+/', "", $row[$nameCol]) . "</option>";

		else

			$optionValue .= "<option value=" . preg_replace('/[\r\n]+/', "", $row[$idCol]) . ">" . preg_replace('/[\r\n]+/', "", $row[$nameCol]) . "</option>";
	}

	return $optionValue;
}
function generateItemOptions($tableName, $nameCol, $idCol, $selectedId)

{
	$sql = "select item_id, item_desc from tbl_items order by item_desc asc";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		$str_desc = $row['item_desc'];

		list($item_name, $mat, $submat, $spec) = split("-", $str_desc);

		$sql_mat = "select cat_name from tbl_categories where cat_id='" . $mat . "'";

		$rs_mat = mysqli_query($GLOBALS['conn'], $sql_mat);

		$row_mat = mysqli_fetch_array($rs_mat);

		$mat = $row_mat['cat_name'];

		$sql_smat = "select cat_name from tbl_categories where cat_id='" . $submat . "'";

		$rs_smat = mysqli_query($GLOBALS['conn'], $sql_smat);

		$row_smat = mysqli_fetch_array($rs_smat);

		$submat = $row_smat['cat_name'];

		if ($submat != "") {

			$submat = "-" . $submat;
		}

		$item_name = htmlentities($item_name);

		$spec = htmlentities($spec);

		$str_desc = $item_name . "-" . $spec;

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value=" . $row[$idCol] . " selected=selected>" . $str_desc . "</option>";

		else

			$optionValue .= "<option value=" . $row[$idCol] . " >" . $str_desc . "</option>";
	}

	return $optionValue;
}
function has_amendments($po_no)

{
	$sql_has_amendments = "select count(amendment_no) as amendment_no from purchase_order_master_amendment where purchase_order_no='" . $po_no . "'  ";

	$res_has_amendments = @mysqli_query($GLOBALS['conn'], $sql_has_amendments);

	$num_has_amendments = @mysqli_fetch_array($res_has_amendments);

	if ($num_has_amendments['amendment_no'] > 0) {

		return true;
	} else {

		return false;
	}
}
function getLatestAmendmentNo($po_no)

{
	$sql_has_amendments = "select max(amendment_no) as amendment_no from purchase_order_master_amendment where purchase_order_no='" . $po_no . "'";

	$res_has_amendments = @mysqli_query($GLOBALS['conn'], $sql_has_amendments);

	if ($row = @mysqli_fetch_array($res_has_amendments)) {

		return $row['amendment_no'];
	} else {

		return "NIL";
	}
}
function getDrawingDetail($drawing_id)

{
	$sql = "select drawing_details from tbl_drawing_detail where drawing_id='" . $drawing_id . "'";

	$res = @mysqli_query($GLOBALS['conn'], $sql);

	if ($row = @mysqli_fetch_array($res)) {

		return $row['drawing_details'];
	} else {

		return "NIL";
	}
}
function marked_qty($po_no = '', $item_desc = '', $id = '')

{
	$sql_bal = "SELECT sum(qty_offered) as qty_offered from order_item_marking where (po_no='" . $po_no . "' and item_desc='" . addslashes($item_desc) . "') or id ='" . $id . "'";

	$result_bal = mysqli_query($GLOBALS['conn'], $sql_bal);

	if ($row_bal = @mysqli_fetch_array($result_bal)) {

		extract($row_bal);

		if ($qty_offered) {

			return $qty_offered;
		} else {

			return 0;
		}
	}
}
function runSql($sql)

{
	$result_bal = mysqli_query($GLOBALS['conn'], $sql);

	if ($result_bal)

		if ($row_bal = @mysqli_fetch_array($result_bal)) {

			@extract($row_bal);

			if ($qty_produced) {

				echo $qty_produced;
			} else {

				// echo '0';
			}
		}
}
function getTableFieldValue($table_name, $field_name, $where1 = '', $val1 = '', $where2 = '', $val2 = '', $where3 = '', $val3 = '', $where4 = '', $val4 = '', $where5 = '', $val5 = '')

{
	$sql_bal = "SELECT " . $field_name . " as field_value from " . $table_name;

	$where_clause = " where ";

	if ($where1 != '') {

		$where_clause .= " " . $where1 . " = " . $val1;
	}

	if ($where2 != '') {

		$where_clause .= " and " . $where2 . " = " . $val2;
	}

	if ($where3 != '') {

		$where_clause .= " and " . $where3 . " = " . $val3;
	}

	if ($where4 != '') {

		$where_clause .= " and " . $where4 . " = " . $val4;
	}

	if ($where5 != '') {

		$where_clause .= " and " . $where5 . " = " . $val5;
	}

	if (strlen($where_clause) > 8) {

		$sql_bal .= $where_clause;
	}

	error_log("sql dipak ".$sql_bal);


	$result_bal = mysqli_query($GLOBALS['conn'], $sql_bal);

	if ($result_bal) {

		if ($row_bal = @mysqli_fetch_array($result_bal)) {

			extract($row_bal);

			if ($field_value) {

				return $field_value;
			} else {

				return "";
			}
		}
	} else {

		return "";
	}
}
function getItemBatch($item_id,$used_batch){
	$batch=array();
	$batch_filter="";
	if($used_batch!='' && $used_batch!=null ){
		$batch_filter=" and item_batch_no!='".$used_batch."' ";
	}

	$ohc_type_id=$_SESSION['current_ohcttype'];
	$current_stock__query = "select item_batch_no,expiry_date from item_stock  where item_id='".$item_id."' and  stock_qty>0 and item_batch_no!='' and  ohc_type_id='" . $ohc_type_id . "' $batch_filter order by expiry_date  ";
	

	if (!$results_stock__query = mysqli_query($GLOBALS['conn'], $current_stock__query)) {
		error_log("Error Occurred:" . mysqli_error($GLOBALS['conn']) . "Query:" . $current_stock__query);
	} else {

		while($row_stocks = mysqli_fetch_row($results_stock__query)){
			// error_log("item_batch of :" .print_r($row_stocks ,true));		
			if($row_stocks[1]!="0000-00-00" && $row_stocks[1]!="" && $row_stocks[1]!=null){
				$date= date('Y-m-d', strtotime($row_stocks[1])) ;
				$date_today= date("Y-m-d");            
			
			if($date>=$date_today){
				array_push($batch,$row_stocks[0]);
			}
			}else{
				array_push($batch,$row_stocks[0]);
			}

			
		}
	}
	 error_log("item_batch of :" . $current_stock__query . " " .print_r($batch,true));
return $batch;
}
function getBatchStock($item_id,$item_batch_no){
	$qty=0;
	$ohc_type_id=$_SESSION['current_ohcttype'];
	$current_stock__query = "select stock_qty from item_stock where item_id=$item_id and item_batch_no='" . $item_batch_no . "' and  ohc_type_id='$ohc_type_id' ";
	// echo $current_stock__query;

	if (!$results_stock__query = mysqli_query($GLOBALS['conn'], $current_stock__query)) {
		error_log("Error Occurred:" . mysqli_error($GLOBALS['conn']) . "Query:" . $current_stock__query);
	} else {

		$row_stocks = mysqli_fetch_row($results_stock__query);
		$qty=$row_stocks[0];

	}
	error_log("stock of :" . $current_stock__query . " " . $qty );
return $qty;
}
function getFieldFromTable($field, $tableName, $clause, $clause_value)

{
	$sql_bal = "SELECT " . $field . " as field_value from " . $tableName . " where " . $clause . "='" . $clause_value . "'";

	// echo $sql_bal;
	error_log('getFieldFromTable: '.$sql_bal);

	// return $sql_bal;

	$result_bal = mysqli_query($GLOBALS['conn'], $sql_bal);

	if ($row_bal = @mysqli_fetch_array($result_bal)) {

		@extract($row_bal);

		if ($field_value) {

			// error_log('getFieldFromTable return value: '.$field_value);
			return $field_value;
		} else {

			// error_log('getFieldFromTable return value: Nothing');
			return "";
		}
	}
}
function generateOpt1($tableName, $nameCol, $selectedId)

{
	$sql = "select $nameCol from $tableName group by $nameCol";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$nameCol] == $selectedId)

			$optionValue .= "<option value=" . $row[$nameCol] . " selected=selected>" . $row[$nameCol] . "</option>";

		else

			$optionValue .= "<option value='" . $row[$nameCol] . "' >" . $row[$nameCol] . "</option>";
	}

	return $optionValue;
}

$nwords = array(

	"",

	"one",

	"two",

	"three",

	"four",

	"five",

	"six",

	"seven",

	"eight",

	"nine",

	"ten",

	"eleven",

	"twelve",

	"thirteen",

	"fourteen",

	"fifteen",

	"sixteen",

	"seventeen",

	"eightteen",

	"nineteen",

	"twenty",

	0 => "zero",

	30 => "thirty",

	40 => "fourty",

	50 => "fifty",

	60 => "sixty",

	70 => "seventy",

	80 => "eigthy",

	90 => "ninety"
);
function number_to_words($x)

{
	global $nwords;

	if (!is_numeric($x)) {

		$w = '#';
	} else {

		$x = floor($x);

		if ($x < 0) {

			$w = 'minus ';

			$x = -$x;
		} else {

			$w = '';
		}

		if ($x < 21) {

			$w .= $nwords[$x];
		} else if ($x < 100) {

			$w .= $nwords[10 * floor($x / 10)];

			$r = fmod($x, 10);

			if ($r > 0) {

				$w .= ' ' . $nwords[$r];
			}
		} else if ($x < 1000) {

			$w .= $nwords[floor($x / 100)] . ' hundred';

			$r = fmod($x, 100);

			if ($r > 0) {

				$w .= ' ' . number_to_words($r);
			}
		} else if ($x < 1000000) {

			$w .= number_to_words(floor($x / 1000)) . ' thousand';

			$r = fmod($x, 1000);

			if ($r > 0) {

				$w .= ' ';

				if ($r < 100) {

					$w .= ' ';
				}

				$w .= number_to_words($r);
			}
		} else {

			$w .= number_to_words(floor($x / 1000000)) . ' million';

			$r = fmod($x, 1000000);

			if ($r > 0) {

				$w .= ' ';

				if ($r < 100) {

					$word .= ' ';
				}

				$w .= number_to_words($r);
			}
		}
	}

	return $w;
}
function number_to_rupees($chk)

{
	$rs = number_to_words($chk);

	$paise = strstr($chk, '.') * 100;

	$ps = number_to_words($paise);

	if ($paise > 0) {

		$final = "(Rupees " . $rs . ", paise " . $ps . " only)";
	} else {

		$final = "(Rupees " . $rs . " only)";
	}

	return $final;
}
function getUserInfo($user_id)

{
	$sql_bal = "SELECT user_name from tbl_users where user_id='" . $user_id . "'";

	$result_bal = mysqli_query($GLOBALS['conn'], $sql_bal);

	if ($row_bal = @mysqli_fetch_array($result_bal)) {

		return $row_bal['user_name'];
	}
}
function getFirmInfo($firm_id)

{
	$sql_bal = "SELECT firm_name from tbl_firms where firm_id='" . $firm_id . "'";

	$result_bal = mysqli_query($GLOBALS['conn'], $sql_bal);

	if ($row_bal = @mysqli_fetch_array($result_bal)) {

		return $row_bal['firm_name'];
	}
}
function getUnitName($unit_id)

{
	$sql_bal = "SELECT unit_name from unit_master where unit_id='" . $unit_id . "'";

	$result_bal = mysqli_query($GLOBALS['conn'], $sql_bal);

	if ($row_bal = @mysqli_fetch_array($result_bal)) {

		return $row_bal['unit_name'];
	}
}
function getItemName($item_id)

{
	$sql_bal = "SELECT item_name from tbl_items where item_id='" . $item_id . "'";

	$result_bal = mysqli_query($GLOBALS['conn'], $sql_bal);

	if ($row_bal = @mysqli_fetch_array($result_bal)) {

		return $row_bal['item_name'];
	}
}
function getAccessView($category)

{
	$sql = "SELECT acc_view FROM rights_access where user_id='" . $_SESSION['user_id'] . "' and category='$category'";

	$res = mysqli_query($GLOBALS['conn'], $sql);

	if ($res) {

		if ($row = @mysqli_fetch_array($res))

			return $row['acc_view'];
	} else {

		return "";
	}
}
function generateOption1($tableName, $nameCol, $idCol, $selectedId)

{
	$sql = "select $nameCol,$idCol from $tableName ORDER BY $nameCol ASC";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value=" . $row[$idCol] . " selected=selected>" . $row[$nameCol] . "</option>";

		else

			$optionValue .= "<option value=" . $row[$idCol] . " >" . $row[$nameCol] . "</option>";
	}

	return $optionValue;
}

// to be used for purchase order view/delete/update onwards for filtering yearwise data display

//
function roman($arabic)

//

{

	//
	$fractions = array(

		"",

		"•",

		"••",

		"•••",

		"••••",

		"•••••",

		"S",

		"S•",

		"S••",

		"S•••",

		"S••••",

		"S•••••",

		"I"
	);

	//

	$ones = array(

		"",

		"I",

		"II",

		"III",

		"IV",

		"V",

		"VI",

		"VII",

		"VIII",

		"IX"
	);

	//

	$tens = array(

		"",

		"X",

		"XX",

		"XXX",

		"XL",

		"L",

		"LX",

		"LXX",

		"LXXX",

		"XC"
	);

	//

	$hundreds = array(

		"",

		"C",

		"CC",

		"CCC",

		"CD",

		"D",

		"DC",

		"DCC",

		"DCCC",

		"CM"
	);

	//

	$thousands = array(

		"",

		"M",

		"MM",

		"MMM",

		"MMMM"
	);

	//

	//

	if ($arabic > 4999)

	//

	{

		//

		// For large numbers (five thousand and above), a bar is placed above a base numeral to indicate multiplication by 1000.

		//

		// Since it is not possible to illustrate this in plain ASCII, this function will refuse to convert numbers above 4999.

		//

		die("Cannot represent numbers larger than 4999 in plain ASCII.");

		//
	} //

	elseif ($arabic == 0)

	//

	{

		//

		// About 725, Bede or one of his colleagues used the letter N, the initial of nullae,

		//

		// in a table of epacts, all written in Roman numerals, to indicate zero.

		//

		return "N";

		//
	}  //

	else //

	{

		//

		// Handle fractions that will round up to 1.

		//

		if (round(fmod($arabic, 1) * 12) == 12)

		//

		{

			//

			$arabic = round($arabic);

			//
		}

		//

		//

		// With special cases out of the way, we can proceed.

		//

		// NOTE: modulous operator (%) only supports integers, so fmod() had to be used instead to support floating point.

		//

		$roman = $thousands[($arabic - fmod($arabic, 1000)) / 1000];

		//

		$arabic = fmod($arabic, 1000);

		//

		$roman .= $hundreds[($arabic - fmod($arabic, 100)) / 100];

		//

		$arabic = fmod($arabic, 100);

		//

		$roman .= $tens[($arabic - fmod($arabic, 10)) / 10];

		//

		$arabic = fmod($arabic, 10);

		//

		$roman .= $ones[($arabic - fmod($arabic, 1)) / 1];

		//

		$arabic = fmod($arabic, 1);

		//

		//

		// Handling for fractions.

		//

		if ($arabic > 0)

		//

		{

			//

			$roman .= $fractions[round($arabic * 12)];

			//
		}

		//

		//

		return $roman;

		//
	}

	//
}

// function for checking access
function checkaccesslevel($access_level, $user_acn)

{
	if (!isset($user_acn) || $user_acn == '' || $access_level == 'E') { //removing delete access temporarily for all users

		return;
	}

	$access_level = getaccesslevel($_SESSION['RoleId'], $menu_id);

	// echo "access_level=".$access_level.",Menu_id:".$menu_id."useracn=".$user_acn;

	if ((($access_level == 'R' || $access_level == 'W' || $access_level == 'E') && ($user_acn == 'view' || $user_acn == '')) || (($access_level == 'W' || $access_level == 'E') && $user_acn == 'update') || ($access_level == 'E' && $user_acn == 'delete')) {

		return;
	} else {

		// echo "<script>location.replace('accessdenied.php')</script>";
	}
}
function acceseLevel($user_id)

{
	$sql = "select a.access_level from assign_menu a left join tbl_users b on a.role_id=b.role_id where b.user_id='$user_id'";

	$res = @mysqli_query($GLOBALS['conn'], $sql);

	$row = @mysqli_fetch_array($res);

	$access_level = $row['access_level'];

	return $access_level;
}
function acceseLevel_change($user_id, $pagekey)

{
	$sql = "SELECT a.access_level

FROM assign_menu a

LEFT JOIN tbl_users b ON a.role_id = b.role_id

WHERE b.user_id =  '" . $user_id . "'

AND a.menu_id =  '" . $pagekey . "'";

	$res = @mysqli_query($GLOBALS['conn'], $sql);

	$row = @mysqli_fetch_array($res);

	$access_level = $row['access_level'];

	return $access_level;
}
function getDivisionTypeById($divisionId)

{
	$sql_division = "select division_name from divisions where division_id='" . $divisionId . "'";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['division_name'];
	}
}
function getTodayOpdCount()

{
	$count=0;
	$sql_division = "select count(appointment_id) count from employee_appointment where appointment_type='O' and DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'  ";

	error_log("row count:" . $sql_division);

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {
		$count+=$row_name['count'];

	}
	// $sql_division_1 = "select count(followup_id) count from followup_details where appointment_type='O' and DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'  ";

	// error_log("row count:" . $sql_division_1);

	// $result_name_1 = mysqli_query($GLOBALS['conn'], $sql_division_1);

	// if ($row_name_1 = @mysqli_fetch_array($result_name_1)) {
	// 	$count+=$row_name_1['count'];

	// }
	return $count;
}

function getTodayfollowupCount()

{
	$count=0;
	// $sql_division = "select count(appointment_id) count from employee_appointment where appointment_type='O' and DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'  ";

	// error_log("row count:" . $sql_division);

	// $result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	// if ($row_name = @mysqli_fetch_array($result_name)) {
	// 	$count+=$row_name['count'];

	// }
	$sql_division_1 = "select count(followup_id) count from followup_details where  DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'  ";

	error_log("row count:" . $sql_division_1);

	$result_name_1 = mysqli_query($GLOBALS['conn'], $sql_division_1);

	if ($row_name_1 = @mysqli_fetch_array($result_name_1)) {
		$count+=$row_name_1['count'];

	}
	return $count;
}
function getTodayVisitorCount()
{
	$sql_division = "select count(appointment_id) from visitors_employee_appointment where DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'  ";
	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);
	error_log($sql_division);
	if ($row_name = @mysqli_fetch_array($result_name)) {
		return $row_name[0];
	}
}
function visitorOpdCount()
{
	$sql_division = "select count(appointment_id) count from visitors_employee_appointment where appointment_type='VO' and DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayPEMECount()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='D' and    task='peme' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayPEMEShortCount()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='D' and   task='peme_short' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayPOHCHalfCount()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='D' and    task='pohc_half' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayPOHCCount()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='D' and   task='pohc' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayFoodHandCount()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='D' and   task='foodhand_exam' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayEyeCheckCount()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='D' and   task='eye_check' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayCovidCount()

{
	$sql_division = "select count(test_id) count from covid_screening_details where DATE(test_date) = CURDATE()";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayCovidMonitoringCount()

{
	$sql_division = "select count(id) as count from covid_monitoring where DATE(date_added) = CURDATE()";

	error_log("message" . $sql_division);

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayWahCount()

{
	$sql_division = "select count(wah_id) count from work_at_height_details_new where DATE(last_modified) = CURDATE()";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayPMECountByMedical()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='D' and task='pme' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayPMECountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='A' and task='pme' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayIMELongTermCount()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  task='ime_long' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayIMELongTermCountByMedical()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='D' and task='ime_long' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayIMELongTermCountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='A' and task='ime_long' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayIMEShortTermCount()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where    task='ime_short' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayIMEShortTermCountByMedical()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='D' and task='ime_short' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayIMEShortTermCountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='A' and task='ime_short' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayPEMECountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='A' and task='peme' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayPEMEShortCountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='A' and task='peme_short' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayPOHCHalfCountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='A' and task='pohc_half' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayPOHCCountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='A' and task='pohc' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayFoodHandCountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='A' and   task='foodhand_exam' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayEyeCheckCountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where forward_status='A' and   task='eye_check' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayAMEAbove40Count()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  task='ame_greater_40'  and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayAMEAbove40CountByMedical()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='D' and task='ame_greater_40'  and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayAMEAbove40CountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='A' and task='ame_greater_40'  and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayAMEBelow40Count()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  task='ame_less_40' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayAMEBelow40CountByMedical()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='D' and task='ame_less_40' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayAMEBelow40CountByDoctor()

{
	$sql_division = "select count(medical_exam_id) count from medical_examination where  forward_status='A' and task='ame_less_40' and DATE(medical_entry_date) = CURDATE() and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayOpdPendingCosultationCount()

{
	$sql_division = "select count(appointment_id) count from employee_appointment where appointment_type='O' and DATE(appointment_date) = CURDATE() and   attended_status='DRP' and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'    ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}

function getTodayOpdPendingPharamacyCount()

{
	$count=0;
	$sql_division = "select count(appointment_id) count from employee_appointment where appointment_type='O' and DATE(appointment_date) = CURDATE()  and   attended_status='PHP' and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'   ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		$count+= $row_name['count'];
	}
	$sql_division_f = "select count(followup_id) count from followup_details where appointment_type='O' and DATE(appointment_date) = CURDATE()  and   attended_status='PHP' and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'   ";

	$result_name_f = mysqli_query($GLOBALS['conn'], $sql_division_f);

	if ($row_name_f = @mysqli_fetch_array($result_name_f)) {

		$count+= $row_name_f['count'];
	}
	return $count;
}
function getTodayfollowupPendingCosultationCount()

{
	$sql_division = "select count(followup_id) count from followup_details where  and DATE(appointment_date) = CURDATE() and   attended_status='DRP' and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'    ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
	else return 0;
}
function getTodayVisitorOpdPendingPharamacyCount()
{
	$sql_division = "select count(appointment_id) count from visitors_employee_appointment where appointment_type='VO' and DATE(appointment_date) = CURDATE()  and   attended_status='PHP' and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'   ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayInjuryCount()

{
	$count=0;
	$sql_division = "select count(appointment_id) count from employee_appointment where appointment_type='I' and DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "' ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		$count+= $row_name['count'];
	}
	// $sql_division_f = "select count(followup_id) count from followup_details where appointment_type='I' and DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "' ";

	// $result_name_f = mysqli_query($GLOBALS['conn'], $sql_division_f);

	// if ($row_name_f = @mysqli_fetch_array($result_name_f)) {

	// 	$count+= $row_name_f['count'];
	// }
	 return $count;
}
function getTodayVisitorInjuryCount()
{
	$sql_division = "select count(appointment_id) count from visitors_employee_appointment where appointment_type='I' and DATE(appointment_date) = CURDATE() and ohc_type_id='" . $_SESSION['current_ohcttype'] . "' ";
	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {
		return $row_name['count'];
	}
}
function getTodayInjuryPendingCosultationCount()

{
	$sql_division = "select count(appointment_id) count from employee_appointment where appointment_type='I' and DATE(appointment_date) = CURDATE() and doctor_attended_flag='N' and   attended_status='DRP'  and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayInjuryPendingPharamacyCount()

{
	$count=0;
	$sql_division = "select count(appointment_id) count from employee_appointment where appointment_type='I' and DATE(appointment_date) = CURDATE() and  attended_status='PHP' and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'   ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {
		$count+=$row_name['count'];
	
	}
	$sql_division_f = "select count(followup_id) count from followup_details where appointment_type='I' and DATE(appointment_date) = CURDATE() and  attended_status='PHP' and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'   ";

	$result_name_f = mysqli_query($GLOBALS['conn'], $sql_division_f);

	if ($row_name_f = @mysqli_fetch_array($result_name_f)) {

		$count+= $row_name_f['count'];
	}
	return $count;
}
function getTodayGuestCount()

{
	$sql_division = "select count(appointment_id) count from guest_appointment where DATE(appointment_date) = CURDATE()  ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodayCheckupCount()

{
	$sql_division = "select count(checkup_id) count from checkup_form where DATE(checkup_date) = CURDATE() ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getTodaySicknessCount()

{
	$sql_division = "select count(sickness_id) count from sickness where  DATE(sickness_date) = CURDATE() and ohc_type_id='".$_SESSION['current_ohcttype']."'   ";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function getCurrentShift()
{

	$sql_division = "select * from shift_status_details where current_status='R' and ohc_location_id='" . $_SESSION['current_ohcttype'] . "'";
	$result_name = @mysqli_query($GLOBALS['conn'], $sql_division);
	$row_name = @mysqli_fetch_assoc($result_name);

	$shift = getFieldFromTable('status_name', 'shift_status', 'shift_status_id', $row_name['shift_id']);
	if ($shift == '' || $shift == null) {
		return $shift = "NO SHIFT";
	} else {
		return $shift;
	}
}


function getTodaySicknessCountByMedical()
{
	$sql_division = "select count(sickness_id) count from sickness where  DATE(sickness_date) = CURDATE() AND attended_status !='DRA' and ohc_type_id='".$_SESSION['current_ohcttype']."'   ";
	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);
	if ($row_name = @mysqli_fetch_array($result_name)) {
		return $row_name['count'];
	}
}
function getGroupItems($group_id)
{
	$sql_for_group_items = "select *  from group_items where group_id=$group_id ";
	// echo $sql_for_group_items;
	$result_for_group_items = mysqli_query($GLOBALS['conn'], $sql_for_group_items);

	return $result_for_group_items;
}
function updateGroupItemFlagByItemId($item_id, $group_item_status)
{
	$sql_update_group_item_flag = " update tbl_items set is_group_item='$group_item_status' where item_id=$item_id";
	mysqli_query($GLOBALS['conn'], $sql_update_group_item_flag);
}
function updatePackagingItemFlagByItemId($item_id, $packaging_item_status)
{
	$sql_update_group_item_flag = " update tbl_items set is_packaging_item='$packaging_item_status' where item_id=$item_id";
	mysqli_query($GLOBALS['conn'], $sql_update_group_item_flag);
}
function updateTable($table, $field_name, $field_value, $cond, $value)
{
	$sql_update_group_item_flag = " update $table set $field_name='$field_value' where $cond=$value";
	// echo $sql_update_group_item_flag;
	mysqli_query($GLOBALS['conn'], $sql_update_group_item_flag);
}
function updateItemStockAtDispensaryLevel($ohc_location, $item_id, $issue_qty)
{
	// echo $ohc_location;
	$is_group_item = getTableFieldValue('tbl_items', 'is_group_item', 'item_id', $item_id);
	// echo $is_group_item;
	if ($is_group_item == 'P') {

		$result_for_group_items = getGroupItems($item_id);

		// echo "shu". mysqli_num_rows($result_for_group_items);
		while ($row_for_group_items = mysqli_fetch_array($result_for_group_items)) {
			$used_qty = $row_for_group_items['qty'];

			resetItemStockAtDispensaryLevelForGroupItems(-$used_qty, $row_for_group_items['item_id'], $ohc_location);
		}
	} else {
		// $item_batch_no=getMinExpiaryDateItem($ohc_location, $item_id);
		$current_stock_qty = getStockQtyAtDispensaryLevel($item_id, $ohc_location);
		// echo $current_stock_qty;
		$stock_qty = floatval($current_stock_qty) - (floatval($issue_qty));
		// echo $stock_qty;
		// echo $issue_qty ;
		$current_stock_query = "update item_stock_dispensary  set stock_qty='" . $stock_qty . "' where item_id='" . $item_id . "'   and ohc_location_id=$ohc_location ";
		// echo $current_stock_query;
		if (!mysqli_query($GLOBALS['conn'], $current_stock_query)) {
			rollback();
			exit(mysqli_error($GLOBALS['conn']));
		}
	}
}
function updateItemStockAtStoreLevel($ohc_location, $item_id, $issue_qty,$item_batch_no)
{
	// echo $ohc_location;
	$is_group_item = getTableFieldValue('tbl_items', 'is_group_item', 'item_id', $item_id);
	// echo $is_group_item;
	if ($is_group_item == 'P') {

		$result_for_group_items = getGroupItems($item_id);

		// echo "shu". mysqli_num_rows($result_for_group_items);
		while ($row_for_group_items = mysqli_fetch_array($result_for_group_items)) {
			$used_qty = $row_for_group_items['qty'];

			resetItemStockAtStoreLevelForGroupItems(-$used_qty, $row_for_group_items['item_id'], $ohc_location,$item_batch_no);
		}
	} else {
		// $item_batch_no=getMinExpiaryDateItem($ohc_location, $item_id);
		$current_stock_qty = getStockQtyAtStoreLevel($item_id, $ohc_location,$item_batch_no);
		// echo $current_stock_qty;
		$stock_qty = floatval($current_stock_qty) - (floatval($issue_qty));
		// echo $stock_qty;
		// echo $issue_qty ;
		$current_stock_query = "update item_stock  set stock_qty='" . $stock_qty . "' where item_id='" . $item_id . "'   and ohc_type_id=$ohc_location and item_batch_no='$item_batch_no' ";
		// echo $current_stock_query;
		if (!mysqli_query($GLOBALS['conn'], $current_stock_query)) {
			rollback();
			exit(mysqli_error($GLOBALS['conn']));
		}
	}
}


function resetItemStockAtDispensaryLevelForGroupItems($used_qty, $item_id, $ohc_location_id)
{
	// echo "used_qty".$used_qty."item_id".$item_id."location".$ohc_location_id;

	// $batch_no=getMinExpiaryDateItem($ohc_location_id,$item_id);
	$stock_qty = getStockQtyAtDispensaryLevel($item_id, $ohc_location_id);
	$total_qty = floatval($stock_qty) + floatval($used_qty);

	// echo $batch_no;
	$query_for_reset_item_dispensary_stock = " update item_stock_dispensary set stock_qty=$total_qty where item_id=$item_id and ohc_location_id=$ohc_location_id  ";
	// echo $query_for_reset_item_dispensary_stock;
	if (!mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock)) {
		error_log("Failed to execute query_for_reset_item_dispensary_stock. Failing query:" . $query_for_reset_item_dispensary_stock);
		rollback();
		exit(mysqli_error($GLOBALS['conn']));
	}
}
function resetItemStockAtStoreLevelForGroupItems($used_qty, $item_id, $ohc_location_id,$item_batch_no)
{
	// echo "used_qty".$used_qty."item_id".$item_id."location".$ohc_location_id;

	// $batch_no=getMinExpiaryDateItem($ohc_location_id,$item_id);
	$stock_qty = getStockQtyAtStoreLevel($item_id, $ohc_location_id,$item_batch_no);
	$total_qty = floatval($stock_qty) + floatval($used_qty);

	// echo $batch_no;
	$query_for_reset_item_Store_stock = " update item_stock set stock_qty=$total_qty where item_id=$item_id and ohc_type_id=$ohc_location_id and item_batch_no='$item_batch_no' ";
	// echo $query_for_reset_item_dispensary_stock;
	if (!mysqli_query($GLOBALS['conn'], $query_for_reset_item_Store_stock)) {
		error_log("Failed to execute query_for_reset_item_Store_stock. Failing query:" . $query_for_reset_item_Store_stock);
		rollback();
		exit(mysqli_error($GLOBALS['conn']));
	}
}
function resetItemStockAtDispensaryLevel($appointment_id, $ohc_location_id)
{
	$query_for_treatment = " select issued_qty,item_id from  treatment where appointment_id='" . $appointment_id . "' ";

	error_log("query_for_treatment:" . $query_for_treatment);
	$result_for_treatemt = mysqli_query($GLOBALS['conn'], $query_for_treatment);

	while ($row_for_treatemnt = mysqli_fetch_array($result_for_treatemt)) {

		$issued_qty = $row_for_treatemnt['issued_qty'];
		$item_id = $row_for_treatemnt['item_id'];
		$is_group_item = getTableFieldValue('tbl_items', 'is_group_item', 'item_id', $item_id);
		if ($is_group_item == 'C') {
			resetItemStockAtDispensaryLevelForGroupItems($issued_qty, $item_id, $ohc_location_id);
			/*
			 * $result_for_group_items = getGroupItems($item_id);
			 *
			 * while ($row_for_group_items = mysqli_fetch_array($result_for_group_items)) {
			 *
			 * $used_qty = $row_for_group_items['qty'];
			 *
			 * $item_id = $row_for_group_items['item_id'];
			 *
			 * resetItemStockAtDispensaryLevelForGroupItems($used_qty, $item_id, $ohc_location_id);
			 *
			 * }
			 */
		} else if ($is_group_item == 'N') {

			// $batch_no = getMinExpiaryDateItem($ohc_location_id, $item_id);

			// echo "b".$batch_no;

			$stock_qty = getStockQtyAtDispensaryLevel($item_id, $ohc_location_id);
			$total_qty = floatval($stock_qty) + floatval($issued_qty);
			error_log("stock_qty:" . $stock_qty);
			error_log("issued_qty:" . $issued_qty);
			error_log("total_qty:" . $total_qty);

			$query_for_reset_item_dispensary_stock = " update item_stock_dispensary set stock_qty= $total_qty where item_id=$item_id and ohc_location_id=$ohc_location_id ";

			error_log("query_for_reset_item_dispensary_stock:" . $query_for_reset_item_dispensary_stock);
			if (!mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock)) {
				error_log("failed to reset dispensary stock:" . mysqli_error($GLOBALS['conn']) . " Failing Query:" . $query_for_reset_item_dispensary_stock);
				rollback();
				exit(mysqli_error($GLOBALS['conn']));
			}
		}
	}
}
function updaterItemStock($ohc, $item, $qty,$batch){
	if($_SESSION['RoleCode']=='DIS'){
	updateItemStockAtDispensaryLevel($ohc, $item, $qty);
	}else{
		updateItemStockAtStoreLevel($ohc, $item, $qty,$batch);	
	}

}

function resetItemStockAtStoreLevel($appointment_id, $ohc_location_id)
{
	$query_for_treatment = " select issued_qty,item_id,item_batch_no from  treatment where appointment_id='" . $appointment_id . "' ";

	error_log("query_for_treatment:" . $query_for_treatment);
	$result_for_treatemt = mysqli_query($GLOBALS['conn'], $query_for_treatment);

	while ($row_for_treatemnt = mysqli_fetch_array($result_for_treatemt)) {

		$issued_qty = $row_for_treatemnt['issued_qty'];
		$item_id = $row_for_treatemnt['item_id'];
		$item_batch_no = $row_for_treatemnt['item_batch_no'];
		$is_group_item = getTableFieldValue('tbl_items', 'is_group_item', 'item_id', $item_id);
		if ($is_group_item == 'C') {
			resetItemStockAtStoreLevelForGroupItems($issued_qty, $item_id, $ohc_location_id,$item_batch_no);
			/*
			 * $result_for_group_items = getGroupItems($item_id);
			 *
			 * while ($row_for_group_items = mysqli_fetch_array($result_for_group_items)) {
			 *
			 * $used_qty = $row_for_group_items['qty'];
			 *
			 * $item_id = $row_for_group_items['item_id'];
			 *
			 * resetItemStockAtStoreLevelForGroupItems($used_qty, $item_id, $ohc_location_id);
			 *
			 * }
			 */
		} else if ($is_group_item == 'N') {

			// $batch_no = getMinExpiaryDateItem($ohc_location_id, $item_id);

			// echo "b".$batch_no;

			$stock_qty = getStockQtyAtStoreLevel($item_id, $ohc_location_id,$item_batch_no);
			$total_qty = floatval($stock_qty) + floatval($issued_qty);
			error_log("stock_qty:" . $stock_qty);
			error_log("issued_qty:" . $issued_qty);
			error_log("total_qty:" . $total_qty);
			error_log("Batch:" . $item_batch_no);
			
			$query_for_reset_item_Store_stock = " update item_stock set stock_qty= $total_qty where item_id=$item_id and ohc_type_id=$ohc_location_id and item_batch_no='$item_batch_no' ";

			error_log("query_for_reset_item_Store_stock:" . $query_for_reset_item_Store_stock);
			if (!mysqli_query($GLOBALS['conn'], $query_for_reset_item_Store_stock)) {
				error_log("failed to reset Store stock:" . mysqli_error($GLOBALS['conn']) . " Failing Query:" . $query_for_reset_item_Store_stock);
				rollback();
				exit(mysqli_error($GLOBALS['conn']));
			}
		}
	}
}

function resetIPDDispensaryItemsStock($ipd_id, $ohc_location_id)
{
	$query_for_treatment = " select issued_qty,medicine from  detention_intake where det_id='" . $ipd_id . "' ";
	$result_for_treatemt = mysqli_query($GLOBALS['conn'], $query_for_treatment);
	while ($row_for_treatemnt = mysqli_fetch_array($result_for_treatemt)) {
		$issued_qty = $row_for_treatemnt['issued_qty'];
		$item_id = $row_for_treatemnt['medicine'];
		$stock_qty = getStockQtyAtDispensaryLevel($item_id, $ohc_location_id);
		$total_qty = floatval($stock_qty) + floatval($issued_qty);
		$query_for_reset_item_dispensary_stock = " update item_stock_dispensary set stock_qty= $total_qty where item_id=$item_id and ohc_location_id=$ohc_location_id ";
		mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock);
	}
}

function resetDirectMedicineDispensaryItemsStock($issue_id, $ohc_location_id)
{
	$query_for_treatment = " select issue_qty,item_id from  direct_medicine_issue_log_details where issue_log_id='" . $issue_id . "' ";
	error_log("cdklfjckld" . $query_for_treatment);
	$result_for_treatemt = mysqli_query($GLOBALS['conn'], $query_for_treatment);
	while ($row_for_treatemnt = mysqli_fetch_array($result_for_treatemt)) {
		$issued_qty = $row_for_treatemnt['issue_qty'];
		$item_id = $row_for_treatemnt['item_id'];
		$stock_qty = getStockQtyAtDispensaryLevel($item_id, $ohc_location_id);
		$total_qty = floatval($stock_qty) + floatval($issued_qty);
		$query_for_reset_item_dispensary_stock = " update item_stock_dispensary set stock_qty= $total_qty where item_id=$item_id and ohc_location_id=$ohc_location_id ";
		error_log("fdkhfvkjnfk" . $query_for_reset_item_dispensary_stock);
		mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock);
	}
}

function resetOPDConsumablesDispensaryItemsStock($opd_id, $ohc_location_id)
{
	$query_for_treatment = " select issued_qty,medicine from  opd_consumables where consume_id='" . $opd_id . "' ";
	$result_for_treatemt = mysqli_query($GLOBALS['conn'], $query_for_treatment);
	while ($row_for_treatemnt = mysqli_fetch_array($result_for_treatemt)) {
		$issued_qty = $row_for_treatemnt['issued_qty'];
		$item_id = $row_for_treatemnt['medicine'];
		$stock_qty = getStockQtyAtDispensaryLevel($item_id, $ohc_location_id);
		$total_qty = floatval($stock_qty) + floatval($issued_qty);
		$query_for_reset_item_dispensary_stock = " update item_stock_dispensary set stock_qty= $total_qty where item_id=$item_id and ohc_location_id=$ohc_location_id ";
		mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock);
	}
}

function getMinExpiaryDateItem($ohc_location_id, $item_id)
{
	$sql_min_expiry_date_item = "select min(expiry_date),item_batch_no  from item_stock_dispensary where ohc_location_id=$ohc_location_id  and item_id=$item_id and  (stock_qty>0) ";
	// echo $sql_min_expiry_date_item;
	$result_min_expiry_date_item = mysqli_query($GLOBALS['conn'], $sql_min_expiry_date_item);

	if ($row_min_expiry_date_item = @mysqli_fetch_array($result_min_expiry_date_item)) {

		return $row_min_expiry_date_item['item_batch_no'];
	}
}
function toCheckDressingItem($item_id)
{
	return getTableFieldValue('tbl_items', 'is_group_item', 'item_id', $item_id);
}
function getStockQtyAtDispensaryLevel($itemId, $ohc_location_id)
{
	$current_stock_query_at_dispensary_level = "select stock_qty from item_stock_dispensary where item_id=$itemId  and ohc_location_id=$ohc_location_id ";
	error_log("checking item stock dispensary:" . $current_stock_query_at_dispensary_level);
	$results_stock_query = @mysqli_query($GLOBALS['conn'], $current_stock_query_at_dispensary_level);
	if ($row_stocks = @mysqli_fetch_array($results_stock_query)) {
		error_log("returned stockqty:" . $row_stocks['stock_qty']);
		return $row_stocks['stock_qty'];
	}
	return null;
}

function getStockQtyAtStoreLevel($itemId, $ohc_location_id,$item_batch_no)
{
	$batch_q='';
	if($item_batch_no!='' || $item_batch_no!=null){
		$batch_q=" and item_batch_no='".$item_batch_no."'";
	}
	$current_stock_query_at_Store_level = "select stock_qty from item_stock where item_id=$itemId  and ohc_type_id=$ohc_location_id $batch_q";
	error_log("checking item stock Store:" . $current_stock_query_at_Store_level);
	$results_stock_query = @mysqli_query($GLOBALS['conn'], $current_stock_query_at_Store_level);
	if ($row_stocks = @mysqli_fetch_array($results_stock_query)) {
		error_log("returned stockqty:" . $row_stocks['stock_qty']);
		return $row_stocks['stock_qty'];
	}
	return null;
}

/*
 * function getStockQtyAtDispensaryLevel($itemId,$ohc_location_id){
 *
 * $query = "select sum(stock_qty) as total_qty from item_stock_dispensary where item_id = '".$itemId."' and ohc_location_id=$ohc_location_id ";
 *
 * if (!$result = @mysqli_query($GLOBALS['conn'],$query)) {
 * exit(mysqli_error($GLOBALS['conn']));
 * }
 * $data = array();
 * if(mysqli_num_rows($result) > 0) {
 * while ($row = mysqli_fetch_assoc($result)) {
 * $data['current_stock_level'] = $row['total_qty'];
 * }
 * }
 * else
 * {
 * $data['status'] = 200;
 * $data['message'] = "Data not found!";
 * }
 * return $data;
 * }
 */

/* update Dispesary Stock For Dispensary Item Inward */
function updateDispensaryStockForItemInward($ohc_location_id, $item_id, $inward_qty)
{
	$stock_qty = getStockQtyAtDispensaryLevel($item_id, $ohc_location_id);
	if ($stock_qty != null && $stock_qty != "") {
		$total_qty = floatval($stock_qty) + floatval($inward_qty);
		$query_for_reset_item_dispensary_stock = " update item_stock_dispensary set stock_qty=$total_qty where item_id=$item_id and ohc_location_id=$ohc_location_id  ";
	} else {
		$query_for_reset_item_dispensary_stock = " insert into item_stock_dispensary set stock_qty=$inward_qty ,item_id=$item_id , ohc_location_id=$ohc_location_id  ";
		// echo $query_for_reset_item_dispensary_stock;
	}
	error_log("updateDispensaryStockForItemInward:" . $query_for_reset_item_dispensary_stock);
	if (!mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock)) {
		error_log("Error Occurred:" . mysqli_error($GLOBALS['conn']) . "Query:" . $query_for_reset_item_dispensary_stock);
		rollback();
		exit(mysqli_error($GLOBALS['conn']));
	}
	// echo $batch_no;
}
function resetDispensaryItemStockForItemInward($ohc_location_id, $received_id)
{
	$query_for_item_inward = " select * from  received_issue_items where received_id='" . $received_id . "' ";
	error_log("resetDispensaryItemStockForItemInward:" . $query_for_item_inward);
	$result_for_for_item_inward = mysqli_query($GLOBALS['conn'], $query_for_item_inward);
	while ($row_for_item_inward = mysqli_fetch_array($result_for_for_item_inward)) {
		$is_packaging_item = $row_for_item_inward['$is_packaging_item'];
		if ($is_packaging_item == 'Y') {
			updateDispensaryStockForItemInward($ohc_location_id, $row_for_item_inward['dispensary_item'], -$row_for_item_inward['dis_item_qty']);
		} else {
			updateDispensaryStockForItemInward($ohc_location_id, $row_for_item_inward['item_id'], -$row_for_item_inward['received_qty']);
		}
	}
}
function resetStockAtStoreLevelForStore($issue_id)
{
	$sql_for_issue_items = " select * from stock_issue_items where stock_issue_id=$issue_id ";
	$results_issue_items = mysqli_query($GLOBALS['conn'], $sql_for_issue_items);
	while ($row_issue_items = mysqli_fetch_assoc($results_issue_items)) {
		updateStockAtStoreLevel($row_issue_items['item_id'], $row_issue_items['item_batch_no'], -$row_issue_items['issue_qty']);
		error_log("row_issue_items['item_id']" . $row_issue_items['item_id']);
		error_log("row_issue_items['item_batch_no']" . $row_issue_items['item_batch_no']);
		error_log("row_issue_items['issue_qty']" . $row_issue_items['issue_qty']);
	}
}
function getStoreItemExpiryDate($item_id, $batch_no)
{
	$sql_min_expiry_date_item = "select expiry_date from item_stock where  item_id='" . $item_id . "' and item_batch_no='" . $batch_no . "' ";
	// echo $sql_min_expiry_date_item;
	$result_min_expiry_date_item = mysqli_query($GLOBALS['conn'], $sql_min_expiry_date_item);

	if ($row_min_expiry_date_item = @mysqli_fetch_array($result_min_expiry_date_item)) {

		return $row_min_expiry_date_item['expiry_date'];
	}
}
function updateStockAtStoreLevel($item_id, $batch_no, $qty)
{
	// $query_for_stock_update="update "
	$ohc_type_id=$_SESSION['current_ohcttype'];
	$current_stock__query = "select stock_qty from item_stock where item_id='".$item_id."' and item_batch_no='" . $batch_no . "' and  ohc_type_id='".$ohc_type_id."' ";
	// echo $current_stock__query;

	error_log("stock updating vs:" . $current_stock__query . " " . $item_id . " " . $qty);

	if (!$results_stock__query = mysqli_query($GLOBALS['conn'], $current_stock__query)) {
		error_log("Error Occurred:" . mysqli_error($GLOBALS['conn']) . "Query:" . $current_stock__query);
	} else {

		$row_stocks = mysqli_fetch_row($results_stock__query);
		$current_stock = $row_stocks[0];
		$update_qty = floatval($current_stock) - floatval($qty);

		$query_for_stock_update = "update item_stock set stock_qty=$update_qty where item_id=$item_id and item_batch_no='" . $batch_no . "' and ohc_type_id='$ohc_type_id' ";
		// echo $query_for_stock_update;
		if (!mysqli_query($GLOBALS['conn'], $query_for_stock_update)) {
			error_log("Error Occurred:" . mysqli_error($GLOBALS['conn']) . "Query:" . $query_for_stock_update);
			rollback();
			exit(mysqli_error($GLOBALS['conn']));
		}
	}
}
function begin()
{
	mysqli_query($GLOBALS['conn'], "BEGIN");
}
function commit()
{
	mysqli_query($GLOBALS['conn'], "COMMIT");
}
function rollback()
{
	mysqli_query($GLOBALS['conn'], "ROLLBACK");
}
function getRecentPatients()

{

	/*
	 *
	 * $sql_division = "select count(appointment_id) count FROM (select curdate() as day
	 *
	 * union select curdate() - interval 1 day
	 *
	 * union select curdate() - interval 2 day
	 *
	 * union select curdate() - interval 3 day
	 *
	 * union select curdate() - interval 4 day
	 *
	 * union select curdate() - interval 5 day
	 *
	 * union select curdate() - interval 6 day
	 *
	 * ) days
	 *
	 * left join employee_appointment
	 *
	 * on days.day = Date(employee_appointment.appointment_date)
	 *
	 * group by
	 *
	 * days.day";
	 *
	 */
	$sql_division = "select count(appointment_id) count  FROM  (select curdate() as day
   union select curdate() - interval 1 day
   union select curdate() - interval 2 day
   union select curdate() - interval 3 day
  ) days
  left join employee_appointment
   on days.day = Date(employee_appointment.appointment_date)
group by
  days.day";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	$data = array();

	while ($row_name = @mysqli_fetch_array($result_name)) {

		$data[] = $row_name['count'];
	}

	return implode(', ', $data);
}
function getTodayStockCount()

{
	$sql_division = "select sum(current_stock_level) count from tbl_items";

	$result_name = mysqli_query($GLOBALS['conn'], $sql_division);

	if ($row_name = @mysqli_fetch_array($result_name)) {

		return $row_name['count'];
	}
}
function validateRequest()

{
	$special_chars = "'^�$%()}{~><>,|=_+�-"; // all the special characters you want to check for

	$return = array();

	$return['msg'] = "Internal Server Error";

	foreach ($_REQUEST as $formKey => $formKeyVal) {

		if (preg_match('/' . $special_chars . '/', $formKeyVal) || preg_match('/' . $special_chars . '/', $formKey)) {

			// echo "<script>alert('Manoj'+'".$formKey."=".$formKeyVal."')</script>";

			if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && $_SERVER['HTTP_X_REQUESTED_WITH'] == 'XMLHttpRequest') {

				header('Cache-Control: no-cache, must-revalidate');

				header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');

				header('Content-type: application/json');

				die(json_encode($return));
			}

			echo "<script>location.href='error.php'</script>";
		}
	}
}

/**
 *
 * Takes input as array suitable for multiselect form attributes
 *
 * Removes the duplicates and returns a string.
 *
 *
 *
 * @param
 *        	Returns a clear comma seperated value string
 *        	
 * @return string
 *
 */
function getMultiValuedSelectData($attr)

{
	$attr = implode(',', $attr);

	$explodedArray = array_unique(explode(",", $attr));

	if (($key = array_search('', $explodedArray)) !== false) {

		unset($explodedArray[$key]);
	}

	$attr = implode(',', $explodedArray);

	return $attr;
}

/**
 *
 * The method takes input an array of text values for master tables
 *
 * Searches those already existing and adds the new entries and returns the ids for all master entries.
 *
 *
 *
 * @param
 *        	Name of table $tableName
 *        	
 * @param
 *        	Name of the column for which values are being passed as input $fieldName
 *        	
 * @param
 *        	Name of the key column for the table $keyFieldName
 *        	
 * @param
 *        	Array of colum for the values being sent as input $userEntriesArray
 *        	
 * @return
 *
 */
function handleDynamicMasterInsert($tableName, $fieldName, $keyFieldName, $userEntriesCommaSeperated, $needIds = "0")

{
	$userEntriesArray = explode(",", $userEntriesCommaSeperated);
	$userEntriesArray = array_map('trim', $userEntriesArray);

	error_log("user entries array" . $userEntriesArray);

	$sql_existing_entries = "SELECT " . $fieldName . " as field_value from " . $tableName . " where " . $fieldName . " in('" . join("','", $userEntriesArray) . "')";

	error_log("existing entries query:" . $sql_existing_entries);

	if (!$result_existing_entries = @mysqli_query($GLOBALS['conn'], $sql_existing_entries)) {
		error_log("error retrieving:" . mysqli_error($GLOBALS['conn']) . " sql_existing_entries:" . $sql_existing_entries);
	}

	$existingEntries = array();

	error_log("NO. OF COMPLAINTS::" .mysqli_num_rows($result_existing_entries));

	if (mysqli_num_rows($result_existing_entries) > 0) {

		while ($row = mysqli_fetch_assoc($result_existing_entries)) {

			$existingEntries[] = $row['field_value'];

		}
	}


	error_log("Existing Entries:" . $existingEntries);

	$newEntries = array_diff($userEntriesArray, $existingEntries);

	error_log("New Entries Count:" . sizeOf($newEntries));

	if (sizeof($newEntries) > 0) {

		for ($i = 0; $i < sizeOf($userEntriesArray); $i++) {

			if ($newEntries[$i] != null && $newEntries[$i] != '') {

				error_log("NEW ENTRY::" .$newEntries[$i]);

				$sql = "insert into " . $tableName . "(" . $fieldName . ",modified_by) values('" . strtoupper(trim($newEntries[$i])) . "'," . $_SESSION['user_id'] . ")";

				error_log("INSERTION QUERY::" .$sql);

				if (!$result = @mysqli_query($GLOBALS['conn'], $sql)) {
					error_log("fail insert query:" . mysqli_error($GLOBALS['conn']));
					error_log("failed query:" . $sql);
					exit(mysqli_error($GLOBALS['conn']));
				}
			}
		}
	}

	//if ($needIds != '0') {

	// Now return the list of all IDs for both new and old ones to calling system for reference.
	$userEntriesArray = array_map('trim', $userEntriesArray);

	$query = "select " . $keyFieldName . " as key_id from " . $tableName . " where " . $fieldName . "  in('" . join("','", $userEntriesArray) . "')";
	error_log(" extraction query:" . $query);

	if (!$result = @mysqli_query($GLOBALS['conn'], $query)) {

		error_log("error retrieving udpated:" . mysqli_error($GLOBALS['conn']) . " query:" . $query);
		//exit ( mysqli_error($GLOBALS['conn']) );
	}

	$data = array();

	if (mysqli_num_rows($result) > 0) {

		while ($row = mysqli_fetch_assoc($result)) {

			$data[] = $row['key_id'];
		}
	}
	error_log("return data" . $data);
	return $data;
	//}
}
function handleDynamicMasterInsertModified($tableName, $fieldName, $keyFieldName, $userEntriesCommaSeperated, $needIds = "0")

{
	$userEntriesArray = explode(",", $userEntriesCommaSeperated);
	$userEntriesArray = array_map('trim', $userEntriesArray);

	error_log("user entries array" . print_r($userEntriesArray,true));

	$sql_existing_entries = "SELECT " . $fieldName . " as field_value from " . $tableName . " where " . $fieldName . " in('" . join("','", $userEntriesArray) . "') and is_active='Y'";

	error_log("existing entries query:" . $sql_existing_entries);

	if (!$result_existing_entries = @mysqli_query($GLOBALS['conn'], $sql_existing_entries)) {
		error_log("error retrieving:" . mysqli_error($GLOBALS['conn']) . " sql_existing_entries:" . $sql_existing_entries);
	}

	$existingEntries = array();

	error_log("NO. OF COMPLAINTS::" .mysqli_num_rows($result_existing_entries));

	if (mysqli_num_rows($result_existing_entries) > 0) {

		while ($row = mysqli_fetch_assoc($result_existing_entries)) {

			$existingEntries[] = $row['field_value'];

		}
	}


	error_log("Existing Entries:" . $existingEntries);

	$newEntries = array_diff($userEntriesArray, $existingEntries);

	error_log("New Entries Count:" . sizeOf($newEntries));

	if (sizeof($newEntries) > 0) {

		for ($i = 0; $i < sizeOf($userEntriesArray); $i++) {

			if ($newEntries[$i] != null && $newEntries[$i] != '') {

				error_log("NEW ENTRY::" .$newEntries[$i]);

				$sql = "insert into " . $tableName . "(" . $fieldName . ",modified_by,is_active) values('" . strtoupper(trim($newEntries[$i])) . "'," . $_SESSION['user_id'] . ",'Y')";

				error_log("INSERTION QUERY::" .$sql);

				if (!$result = @mysqli_query($GLOBALS['conn'], $sql)) {
					error_log("fail insert query:" . mysqli_error($GLOBALS['conn']));
					error_log("failed query:" . $sql);
					exit(mysqli_error($GLOBALS['conn']));
				}
			}
		}
	}

	//if ($needIds != '0') {

	// Now return the list of all IDs for both new and old ones to calling system for reference.
	$userEntriesArray = array_map('trim', $userEntriesArray);

	$query = "select " . $keyFieldName . " as key_id from " . $tableName . " where " . $fieldName . "  in('" . join("','", $userEntriesArray) . "') and is_active='Y'";
	error_log(" extraction query:" . $query);

	if (!$result = @mysqli_query($GLOBALS['conn'], $query)) {

		error_log("error retrieving udpated:" . mysqli_error($GLOBALS['conn']) . " query:" . $query);
		//exit ( mysqli_error($GLOBALS['conn']) );
	}

	$data = array();

	if (mysqli_num_rows($result) > 0) {

		while ($row = mysqli_fetch_assoc($result)) {

			$data[] = $row['key_id'];
		}
	}
	error_log("return data" . $data);
	return $data;
	//}
}

function determineDataFormat($data)
{
    if (preg_match('/^\d+$/', $data)) {
        error_log("data is id " . $data);
        return getFieldFromTable('section_name', 'checkup_form_section', 'section_id', $data);
    } elseif (preg_match('/^\d+(,\d+)*$/', $data)) {
        error_log("data is ids " . $data);
        return getCommaSeperatedValuesForInClause('select section_name from checkup_form_section', 'section_id', $data);
    } else {
        return $data;
    }
}


function getItemWithFormName($itemid)
{
	$item_result = mysqli_query($GLOBALS['conn'], "SELECT item_id,trim(concat(ifnull(item_code,''),' ',item_name)) item_name FROM tbl_items i left join medicine_form f on i.item_form_id=f.form_id  where i.item_id=$itemid");
	if ($item_result) {
		if ($row_item = @mysqli_fetch_array($item_result)) {
			@extract($row_item);
			return $row_item['item_name'];
		}
	}
}

function getItemWithFormNamePdf($itemid)
{
	$item_result = mysqli_query($GLOBALS['conn'], "SELECT item_id,item_name FROM tbl_items i left join medicine_form f on i.item_form_id=f.form_id  where i.item_id=$itemid");
	if ($item_result) {
		if ($row_item = @mysqli_fetch_array($item_result)) {
			@extract($row_item);
			return $row_item['item_name'];
		}
	}
}
function getGroupItemsList()
{
	$resultArry = array();
	$item_result = mysqli_query($GLOBALS['conn'], "SELECT item_id from tbl_items where is_group_item='P'");
	if ($item_result) {
		while ($row_item = @mysqli_fetch_array($item_result)) {
			@extract($row_item);
			$resultArry[] = $row_item['item_id'];
		}
	}
	return $resultArry;
}
function getKeyValueMap($tableName, $keyColumn, $valueColumn)
{
	$resultArry = array();
	$keys = array();
	$values = array();
	$item_result = mysqli_query($GLOBALS['conn'], "SELECT $keyColumn, $valueColumn from $tableName ");
	if ($item_result) {
		while ($row_item = @mysqli_fetch_array($item_result)) {
			@extract($row_item);
			$keys[] = $row_item[$keyColumn];
			$values[] = $row_item[$valueColumn];
		}
	}
	$resultArry = array_combine($keys, $values);
	return $resultArry;
}
function getKeyValueMapWithWhere($tableName, $keyColumn, $valueColumn, $where_col, $where_value)
{
	$resultArry = array();
	$keys = array();
	$values = array();
	$item_result = mysqli_query($GLOBALS['conn'], "SELECT $keyColumn, $valueColumn from $tableName where $where_col='" . $where_value . "'  ");
	if ($item_result) {
		while ($row_item = @mysqli_fetch_array($item_result)) {
			@extract($row_item);
			$keys[] = $row_item[$keyColumn];
			$values[] = $row_item[$valueColumn];
		}
	}
	$resultArry = array_combine($keys, $values);
	return $resultArry;
}
function creatingTicketNoOPD()
{
	$month = date('n');
	$year = date('Y');

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
	}
	$ohc_type = $_SESSION['current_ohcttype'];
	$ohc_type_code = getTableFieldValue('ohc_type', 'ohc_code', 'ohc_type_id', $ohc_type);
	$query_ticket_no = "select  max( CAST(substring(ticket_no,locate('-',ticket_no)+1,length(ticket_no)-(5+locate('-',ticket_no))) as UNSIGNED) ) from employee_appointment where ticket_no like '%$year' and appointment_type='O' ";
	// echo $query_req_ref_no;
	$result_ticket_no = @mysqli_query($GLOBALS['conn'], $query_ticket_no);
	$row_ticket_no = mysqli_fetch_row($result_ticket_no);
	return $ticket_no = 'Illness' . '-' . ($row_ticket_no[0] + 1) . '-' . $year;
}
function creatingProcurementNo()
{
	$month = date('n');
	$year = date('Y');

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
	}
	$ohc_type = $_SESSION['current_ohcttype'];
	$ohc_type_code = getTableFieldValue('ohc_type', 'ohc_code', 'ohc_type_id', $ohc_type);
	$query_ticket_no = "select  max( CAST(substring(procurement_refno,locate('-',procurement_refno)+1,length(procurement_refno)-(5+locate('-',procurement_refno))) as UNSIGNED) ) from procurement where procurement_refno like '%$year'";
	// echo $query_req_ref_no;
	$result_ticket_no = @mysqli_query($GLOBALS['conn'], $query_ticket_no);
	$row_ticket_no = mysqli_fetch_row($result_ticket_no);
	return $ticket_no = 'PMT' . '-' . ($row_ticket_no[0] + 1) . '-' . $year;
}
function getPreEmployeeEmpCode(){
	
	
	$query_ticket_no = "SELECT  MAX( CAST(SUBSTRING(emp_code,LOCATE('pre',emp_code)+3,LENGTH(emp_code)) AS UNSIGNED) ) FROM patient_master WHERE emp_code LIKE 'pre%'  
";
	// echo $query_req_ref_no;
	$result_ticket_no = @mysqli_query($GLOBALS['conn'], $query_ticket_no);
	$row_ticket_no = mysqli_fetch_row($result_ticket_no);
	return $ticket_no = 'pre' .($row_ticket_no[0] + 1);
}
function creatingTicketNoFollowup()
{
	$month = date('n');
	$year = date('Y');

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
	}
	$ohc_type = $_SESSION['current_ohcttype'];
	$ohc_type_code = getTableFieldValue('ohc_type', 'ohc_code', 'ohc_type_id', $ohc_type);
	$query_ticket_no = "select  max( CAST(substring(ticket_no,locate('-',ticket_no)+1,length(ticket_no)-(5+locate('-',ticket_no))) as UNSIGNED) ) from followup_details where ticket_no like '%$year' and appointment_type='O' ";
	// echo $query_req_ref_no;
	$result_ticket_no = @mysqli_query($GLOBALS['conn'], $query_ticket_no);
	$row_ticket_no = mysqli_fetch_row($result_ticket_no);
	return $ticket_no = 'FP' . '-' . ($row_ticket_no[0] + 1) . '-' . $year;
}

function creatingTicketNoInjury()
{
	$month = date('n');
	$year = date('Y');

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
	}
	$ohc_type = $_SESSION['current_ohcttype'];
	$ohc_type_code = getTableFieldValue('ohc_type', 'ohc_code', 'ohc_type_id', $ohc_type);
	$query_ticket_no = "select  max( CAST(substring(ticket_no,locate('-',ticket_no)+1,length(ticket_no)-(5+locate('-',ticket_no))) as UNSIGNED) ) from employee_appointment where ticket_no like '%$year' and appointment_type='I' ";
	// echo $query_req_ref_no;
	$result_ticket_no = @mysqli_query($GLOBALS['conn'], $query_ticket_no);
	$row_ticket_no = mysqli_fetch_row($result_ticket_no);
	return $ticket_no = 'IR' . '-' . ($row_ticket_no[0] + 1) . '-' . $year;
}

function creatingTicketNofitness()
{
	$month = date('n');
	$year = date('Y');

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
	}
	$ohc_type = $_SESSION['current_ohcttype'];
	$ohc_type_code = getTableFieldValue('ohc_type', 'ohc_code', 'ohc_type_id', $ohc_type);
	$query_ticket_no = "select  max( CAST(substring(ticket_no,locate('-',ticket_no)+1,length(ticket_no)-(5+locate('-',ticket_no))) as UNSIGNED) ) from sickness where ticket_no like '%$year' and ohc_type_id=$ohc_type ";
	error_log($query_ticket_no);
	$result_ticket_no = @mysqli_query($GLOBALS['conn'], $query_ticket_no);
	$row_ticket_no = mysqli_fetch_row($result_ticket_no);
	return $ticket_no = 'FITNO' . '-' . ($row_ticket_no[0] + 1) . '-' . $year;
}


function creatingPEMENo()
{
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;
	$query_peme_no = "select task,  max( CAST(substring(peme_no,locate('PEME/',peme_no)+5,(locate('/$year',peme_no))) as UNSIGNED) ) from medical_examination where peme_no like '%$fy' and ohc_location_id = '$ohc'";


	error_log("PEME::" . $query_peme_no);
	// echo $query_req_ref_no;
	$result_peme_no = @mysqli_query($GLOBALS['conn'], $query_peme_no);
	$row_peme_no = mysqli_fetch_array($result_peme_no);

	$peme_no = 'TML/PEME/' . ($row_peme_no[1] + 1) . '/' . $year . '-' . $year1;
	error_log("PEME NO." . $peme_no);
	return $peme_no;
}

function creatingCheckupTicketNo()
{
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;

	$query_ticket_no = "select max( CAST(substring(ticket_no,locate('TCKT/',ticket_no)+5,(locate('/$year',ticket_no))) as UNSIGNED) ) from checkup_form where ticket_no like '%$fy' and ohc_type_id = '$ohc' ";

	error_log("tickt generate query " . $query_ticket_no);

	$result_ticket_no = @mysqli_query($GLOBALS['conn'], $query_ticket_no);
	$row_ticket_no = mysqli_fetch_array($result_ticket_no);
	$ticket_no = 'SOS/TCKT/' . ($row_ticket_no[0] + 1) . '/' . $year . '-' . $year1;
	error_log("medical ticket NO." . $ticket_no);
	return $ticket_no;
}

function generateOption2($tableName, $nameCol, $idCol, $selectedId, $dis)

{
	$optionValue='';
    $sql = "select $nameCol,$idCol from $tableName";
    error_log("query::::::".$sql);
    $resultSet = @mysqli_query($GLOBALS['conn'], $sql );
    
    while ( $row = mysqli_fetch_array ( $resultSet ) ) {
        
        if ($row [$idCol] == $selectedId){
            
            $optionValue .= "<option value='" . $row [$idCol] . "' selected=selected>" . $row [$nameCol] . "</option>";
            
         } else if ($dis == 'div' && $row [$idCol] == '1') {
                
                $optionValue .= "<option value='" . $row [$idCol] . "' disabled >" . $row [$nameCol] . "</option>";
            } else{
                
                $optionValue .= "<option value='" . $row [$idCol] . "'>" . $row [$nameCol] . "</option>";
            }
    }
    error_log("option value ".$optionValue);
    return $optionValue;
}
function getsearchOptionsSpe($roleId)
{
	$optionValue='';
    $sql = "select distinct(m.menu_id),m.parent_id,m.menu_name,m.menu_description,m.menu_url,m.parent_id,m.icon_text  from assign_menu a, menu_master m  where a.menu_id= m.menu_id and m.parent_id!='0.00' and   
	a.role_id='" . $roleId . "'   and (m.menu_url!='' or  m.menu_url!=null or m.menu_url!='NA') order by disp_seq";
    error_log("query::::::".$sql);
    $resultSet = @mysqli_query($GLOBALS['conn'], $sql );
    
    while ( $row = mysqli_fetch_array ( $resultSet ) ) {
        
            $optionValue .= "<option value='" . $row ["menu_url"] . "' >" . $row ["menu_name"] . "</option>";
            
        
    }
    error_log("option value ".$optionValue);
    return $optionValue;
}
function getsearchOptions($roleId)
{
	$optionValue='';
    $sql = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id,m.icon_text  from assign_menu a, menu_master m  where a.menu_id= m.menu_id and   
	a.role_id='" . $roleId . "'   and (m.menu_url!='' or  m.menu_url!=null or m.menu_url!='NA') order by disp_seq";
    error_log("query::::::".$sql);
    $resultSet = @mysqli_query($GLOBALS['conn'], $sql );
    
    while ( $row = mysqli_fetch_array ( $resultSet ) ) {
        
            $optionValue .= "<option value='" . $row ["menu_url"] . "' >" . $row ["menu_name"] . "</option>";
            
        
    }
    error_log("option value ".$optionValue);
    return $optionValue;
}


function creatingPOHCNo()
{
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;
	$query_pohc_no = "select task,  max( CAST(substring(pohc_no,locate('POHC/',pohc_no)+5,(locate('/$year',pohc_no))) as UNSIGNED) ) from medical_examination where pohc_no like '%$fy' and ohc_location_id = '$ohc'";


	error_log("pohc" . $query_pohc_no);
	// echo $query_req_ref_no;
	$result_pohc_no = @mysqli_query($GLOBALS['conn'], $query_pohc_no);
	$row_pohc_no = mysqli_fetch_array($result_pohc_no);

	$pohc_no = 'TML/POHC/' . ($row_pohc_no[1] + 1) . '/' . $year . '-' . $year1;
	error_log("immmmmmmmme" . $pohc_no);
	return $pohc_no;
}

function creatingCylinderNo()
{


	$query_cylinder_no = "select max(cast(substring(oxygen_kit_no,17,100) as unsigned)) from oxygen_cylinder where oxygen_kit_no like '%KIT/%'";


	error_log("cylinder" . $query_cylinder_no);
	// echo $query_req_ref_no;
	$result_cylinder_no = @mysqli_query($GLOBALS['conn'], $query_cylinder_no);
	$row_cylinder_no = mysqli_fetch_array($result_cylinder_no);

	$cylinder_no = 'TML/MED/OXY/KIT/' . ($row_cylinder_no[0] + 1);
	error_log("CYLINDER NO." . $cylinder_no);

	return $cylinder_no;
}


function creatingCOVNo()
{
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;

	$query_cov_no = "select task,  max( CAST(substring(cov_no,locate('COV/',cov_no)+4,(4+locate('/$year',cov_no))) as UNSIGNED) ) from medical_examination where cov_no like '%$fy' and ohc_location_id = '$ohc'";


	error_log("COV" . $query_cov_no);
	// echo $query_req_ref_no;
	$result_cov_no = @mysqli_query($GLOBALS['conn'], $query_cov_no);
	$row_cov_no = mysqli_fetch_array($result_cov_no);

	$cov_no = 'TML/COV/' . ($row_cov_no[1] + 1) . '/' . $year . '-' . $year1;
	error_log("COV NO" . $cov_no);
	return $cov_no;
}


function creatingWAHNo()
{
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;

	$query_wah_no = "select task,  max( CAST(substring(wah_no,locate('WAH/',wah_no)+4,(4+locate('/$year',wah_no))) as UNSIGNED) ) from medical_examination where wah_no like '%$fy' and ohc_location_id = '$ohc'";


	error_log("WAH" . $query_wah_no);
	// echo $query_req_ref_no;
	$result_wah_no = @mysqli_query($GLOBALS['conn'], $query_wah_no);
	$row_wah_no = mysqli_fetch_array($result_wah_no);

	$wah_no = 'FIA/WAH/' . ($row_wah_no[1] + 1) . '/' . $year . '-' . $year1;
	error_log("WAH NO." . $wah_no);
	return $wah_no;
}

function creatingFFINo()
{
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;

	$query_ffi_no = "select max( CAST(substring(medical_examination_no,locate('FFI/',medical_examination_no)+4,(4+locate('/$year',medical_examination_no))) as UNSIGNED) ) as max from questionaire_master_response where medical_examination_no like '%$fy' and ohc_type_id = '$ohc'";

	error_log("FFI generate" . $query_ffi_no);
	// echo $query_req_ref_no;
	$result_ffi_no = @mysqli_query($GLOBALS['conn'], $query_ffi_no);
	$row_ffi_no = mysqli_fetch_array($result_ffi_no);

	$ffi_no = 'FIA/FFI/' . ($row_ffi_no['max'] + 1) . '/' . $year . '-' . $year1;
	error_log("FFI NO." . $ffi_no);
	return $ffi_no;
}
function creatingDLFNo()
{ 
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;

	$query_dlf_no = "select max( CAST(substring(medical_examination_no,locate('dlf/',medical_examination_no)+4,(4+locate('/$year',medical_examination_no))) as UNSIGNED) ) as max from questionaire_master_response where medical_examination_no like '%$fy' and ohc_type_id = '$ohc'";

	error_log("dlf generate **************" . $query_dlf_no);
	// echo $query_req_ref_no;
	$result_dlf_no = @mysqli_query($GLOBALS['conn'], $query_dlf_no);
	$row_dlf_no = mysqli_fetch_array($result_dlf_no);
	error_log("dlf row_dlf_no". " ----------------- ". $row_dlf_no);
	$dlf_no = 'DLFF/DLF/' . ($row_dlf_no['max'] + 1) . '/' . $year . '-' . $year1;
	error_log("DLF NO." . $dlf_no);
	return $dlf_no;
}

function creatingCHSNo()
{
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;

	$query_chs_no = "select max( CAST(substring(medical_examination_no,locate('chs/',medical_examination_no)+4,(4+locate('/$year',medical_examination_no))) as UNSIGNED) ) as max from questionaire_master_response where medical_examination_no like '%$fy' and ohc_type_id = '$ohc'";

	error_log("CHS generate **************" . $query_chs_no);
	// echo $query_req_ref_no;
	$result_chs_no = @mysqli_query($GLOBALS['conn'], $query_chs_no);
	$row_chs_no = mysqli_fetch_array($result_chs_no);
	error_log("CHS row_chs_no". " ----------------- ". $row_chs_no);
	$chs_no = 'CHSF/CHS/' . ($row_chs_no['max'] + 1) . '/' . $year . '-' . $year1;
	error_log("CHS NO." . $chs_no);
	return $chs_no;
}


		function creatinggrnNo()
		{
			$month=date('n');
			$year = date ( 'Y' );
			
			if ($month > 3) {
				$year = $year;
			} else {
				$year = $year - 1;
			}
			
			$query_indent_ref_no = "select  max( CAST(substring(item_grn_no,locate('-',item_grn_no)+1,length(item_grn_no)-(5+locate('-',item_grn_no))) as UNSIGNED) ) from grn_master where item_grn_no like '%$year%'";
			$result_indent_ref_no = @mysqli_query($GLOBALS['conn'],$query_indent_ref_no );
			$row_indent_ref_no = mysqli_fetch_row ( $result_indent_ref_no );
			$ref_no = 'GRN-' . ($row_indent_ref_no [0] + 1) . '-' . $year;
				error_log("GRN NO." . $ref_no);
			return $ref_no;
		}
		function creatingPoNo()
		{
			$month=date('n');
			$year = date ( 'Y' );
			
			if ($month > 3) {
				$year = $year;
			} else {
				$year = $year - 1;
			}
			
			$query_indent_ref_no = "select  max( CAST(substring(item_po_no,locate('-',item_po_no)+1,length(item_po_no)-(5+locate('-',item_po_no))) as UNSIGNED) ) from indent_items where item_po_no like '%$year%'";
			$result_indent_ref_no = @mysqli_query($GLOBALS['conn'],$query_indent_ref_no );
			$row_indent_ref_no = mysqli_fetch_row ( $result_indent_ref_no );
			$ref_no = 'PO-' . ($row_indent_ref_no [0] + 1) . '-' . $year;
				error_log("PO NO." . $ref_no);
			return $ref_no;
		}
function creatingKHSNo()
{
	$month = date('n');
	$year = date('Y');
	$year1 = $year + 1;
	$ohc = $_SESSION['current_ohcttype'];

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
		$year1 = date('Y');
	}
	$fy = $year . '-' . $year1;

	$query_khs_no = "select max( CAST(substring(medical_examination_no,locate('khs/',medical_examination_no)+4,(4+locate('/$year',medical_examination_no))) as UNSIGNED) ) as max from questionaire_master_response where medical_examination_no like '%$fy' and ohc_type_id = '$ohc'";

	error_log("khs generate **************" . $query_khs_no);
	// echo $query_req_ref_no;
	$result_khs_no = @mysqli_query($GLOBALS['conn'], $query_khs_no);
	$row_khs_no = mysqli_fetch_array($result_khs_no);
	error_log("khs row_khs_no". " ----------------- ". $row_khs_no);
	$khs_no = 'KHSF/khs/' . ($row_khs_no['max'] + 1) . '/' . $year . '-' . $year1;
	error_log("khs NO." . $khs_no);
	return $khs_no;
}

function getVisitorTicketNo()
{
	$month = date('n');
	$year = date('Y');

	if ($month > 3) {
		$year = $year;
	} else {
		$year = $year - 1;
	}
	$ohc_type = $_SESSION['current_ohcttype'];
	$ohc_type_code = getTableFieldValue('ohc_type', 'ohc_code', 'ohc_type_id', $ohc_type);
	$query_ticket_no = "select  max( CAST(substring(ticket_no,locate('-',ticket_no)+1,length(ticket_no)-(5+locate('-',ticket_no))) as UNSIGNED) ) from visitors_employee_appointment where ticket_no like '%$year' and ohc_type_id=$ohc_type ";
	// echo $query_ticket_no;
	$result_ticket_no = @mysqli_query($GLOBALS['conn'], $query_ticket_no);
	if ($row_ticket_no = mysqli_fetch_row($result_ticket_no));
	return $ticket_no = 'TCKT' . $ohc_type_code . '-' . ($row_ticket_no[0] + 1) . '-' . $year;
}
function getAilmentNamesFromIds($ailment_names_ids)
{
	$ailment_names_ids = $rows_emp_appoint['ailments_new'];
	$ailment_names_ids_array = array();
	$ailment_names_ids_array = explode(",", $ailment_names_ids);
	$ailment_names = "";
	for ($i = 0; $i < count($ailment_names_ids_array); $i++) {
		if ($i == 0) {
			$ailment_names = getTableFieldValue('ailment', 'ailment_name', 'ailment_id', $ailment_names_ids_array[$i]);
		} else {
			$ailment_names = $ailment_names . "," . getTableFieldValue('ailment', 'ailment_name', 'ailment_id', $ailment_names_ids_array[$i]);
		}
	}
	return $ailment_names;
}
function getAilmentSystemNamesFromIds($ailment_system_ids)
{
	$ailment_system_ids_array = array();
	$ailment_system_ids_array = explode(",", $ailment_system_ids);
	$ailment_systems = "";
	for ($i = 0; $i < count($ailment_system_ids_array); $i++) {
		if ($i == 0) {
			$ailment_systems = getTableFieldValue('ailment_system', 'ailment_sys_name', 'ailment_sys_id', $ailment_system_ids_array[$i]);
		} else {
			$ailment_systems = $ailment_systems . "," . getTableFieldValue('ailment_system', 'ailment_sys_name', 'ailment_sys_id', $ailment_system_ids_array[$i]);
		}
	}
	return $ailment_systems;
}
function getTotalEmployeeBySurveyAssignId($survey_assign_id)
{
	$sql_for_emp_survey = "select count(emp_survey_id)  count from emp_survey where survey_assign_id=$survey_assign_id";

	$result_for_emp_survey = mysqli_query($GLOBALS['conn'], $sql_for_emp_survey);

	if ($row_for_emp_survey = @mysqli_fetch_array($result_for_emp_survey)) {

		if ($row_for_emp_survey['count'] != null && $row_for_emp_survey['count'] != '')
			return $row_for_emp_survey['count'];
		else
			return 0;
	}
}
function getAttemptEmployeeBySurveyAssignId($survey_assign_id)
{
	$sql_for_attempt_emp_survey = "select count(distinct(emp_id))  count from emp_survey_answer where survey_assign_id=$survey_assign_id";

	$result_for_attempt_emp_survey = mysqli_query($GLOBALS['conn'], $sql_for_attempt_emp_survey);

	if ($row_for_attempt_emp_survey = @mysqli_fetch_array($result_for_attempt_emp_survey)) {

		if ($row_for_attempt_emp_survey['count'] != null && $row_for_attempt_emp_survey['count'] != '')
			return $row_for_attempt_emp_survey['count'];
		else
			return 0;
	}
}
function generateOptionForSingleColumn($tableName, $nameCol, $idCol, $selectedId)

{
	echo $sql = "select $nameCol,$idCol from $tableName order by $idCol ";

	$resultSet = mysqli_query($GLOBALS['conn'], $sql);

	while ($row = mysqli_fetch_array($resultSet)) {

		if ($row[$idCol] == $selectedId)

			$optionValue .= "<option value='" . $row[$idCol] . "' selected=selected>" . $row[$idCol] . "</option>";

		else if ($dis == 'div' && $row[$idCol] == '1') {

			$optionValue .= "<option value='" . $row[$idCol] . "' disabled >" . $row[$idCol] . "</option>";
		} else

			$optionValue .= "<option value='" . $row[$idCol] . "'>" . $row[$idCol] . "</option>";
	}

	return $optionValue;
}
function getCalculatedDOBFromAge($age)
{
	$current_year = date("Y");
	$birthYear = $current_year - $age;
	$time = strtotime('01/01/' . $birthYear);

	$birthDate = date('d-m-Y', $time);


	return $birthDate;
}
function getCalculatedBMIFromweight($weight,$height)
{
	$w = $weight;
	$h= $height/100;
	$BMI = $w/($h*$h);
	
	
	return $BMI;
}
function ageCalculator($dob)
{
	if (!empty($dob)) {
		$birthdate = new DateTime($dob);
		$today = new DateTime('today');
		$age = $birthdate->diff($today)->y;
		return $age;
	} else {
		return 0;
	}
}
function runSqlGenericSingleRow($sql)
{
	error_log("runSqlGenericSingleRow:" . $sql);
	$item_result = mysqli_query($GLOBALS['conn'], $sql);
	if ($row_item = @mysqli_fetch_array($item_result)) {
		@extract($row_item);
		return $row_item;
	}

	return $null;
}
function runSqlGenericFullResult($sql)
{
	$item_result = mysqli_query($GLOBALS['conn'], $sql);
	return $row_item;
}

function getHoursLapsed($eventTime)
{
	$totaldelay = time() - strtotime($eventTime);
	if ($totaldelay <= 0) {
		return 0;
	} else {
		$hours = floor($totaldelay / 3600);
	}
	return $hours;
}

function getElapsedTime($eventTime)
{
	$totaldelay = time() - strtotime($eventTime);
	if ($totaldelay <= 0) {
		return '';
	} else {
		if ($days = floor($totaldelay / 86400)) {
			$totaldelay = $totaldelay % 86400;
			return $days . ' days ago.';
		}
		if ($hours = floor($totaldelay / 3600)) {
			$totaldelay = $totaldelay % 3600;
			return $hours . ' hours ago.';
		}
		if ($minutes = floor($totaldelay / 60)) {
			$totaldelay = $totaldelay % 60;
			return $minutes . ' minutes ago.';
		}
		if ($seconds = floor($totaldelay / 1)) {
			$totaldelay = $totaldelay % 1;
			return $seconds . ' seconds ago.';
		}
	}
}


function getDispensaryDailyItemBalance($ohc_id, $item_id, $date_of_enquiry)
{
	$sqlb = "select balance from stock_balance_dispensary where item_id = '$item_id' and ohc_location_id = '$ohc_id' and enquiry_date = '$date_of_enquiry' ";
	$resultb = mysqli_query($GLOBALS['conn'], $sqlb);

	error_log("enquiry_date" . $sqlb);

	return $b;
}


function setDispensaryDailyItemBalance($ohc_id, $item_id, $date_of_enquiry, $item_balance)
{


	$sqlb = "insert into stock_balance_dispensary set item_id = '$id',ohc_location_id = '',balance='$b',modified_by='" .  $_SESSION['user_id'] . "',enquiry_date = '$d' ";
	$resultb = mysqli_query($GLOBALS['conn'], $sqlb);

	error_log("gkjhgjfnnnnnn" . $sqlb);

	return $b;
}


function getDailyDispensaryItemConsumption($ohc_id, $item_id, $date_of_enquiry)
{


	$sql_consume = "select  sum(issued_qty) as issued_total from treatment where item_id = '$item_id'  and appointment_id in (select appointment_id employee_appointment where ohc_location_id = '$ohc_id' and date_format(date(appointment_date),'%d-%m-%Y') = '$date_of_enquiry'  ";

	error_log("cccccccons" . $sql_consume);

	$result_consume = mysqli_query($GLOBALS['conn'], $sql_consume);


	if ($row_consume = mysqli_fetch_array($result_consume)) {

		$issued_qty_total = $row_consume['issued_total'];
	}

	return  $issued_qty_total;
}
function updateItemStockDispensaryShiftBalance($ohc_id, $shift_id, $shift_start_date)
{
	mysqli_query($GLOBALS['conn'],"BEGIN");
	error_log("param ohc_location:" . $ohc_id);
	error_log("DATE" . $shift_start_date);
	$sql_existing_today_balance = "select * from item_stock_dispensary_shift_balance where record_date = '" . $shift_start_date . "' and ohc_location_id = '$ohc_id' and shift_id=$shift_id  ";
	error_log("query" . $sql_existing_today_balance);
	$num_rows_existing = mysqli_num_rows(mysqli_query($GLOBALS['conn'],$sql_existing_today_balance));
	error_log("query" . $num_rows_existing);
	if ($num_rows_existing != 0) {
		$delete_existing_today_balance = "delete from item_stock_dispensary_shift_balance where record_date = '" . $shift_start_date . "' and ohc_location_id = '$ohc_id' and shift_id=$shift_id  ";
		error_log("query" . $delete_existing_today_balance);

		if (!mysqli_query($GLOBALS['conn'],$delete_existing_today_balance)) {
			error_log("Failed to clear existing:" . mysqli_error($GLOBALS['conn']) . " failing query:" . $delete_existing_today_balance);
		}
	}


	if (!$result = mysqli_query($GLOBALS['conn'],"CALL insertShiftData('$shift_id','$ohc_id','$shift_start_date')")) {
		error_log("Failed to update Shift Balance:" . mysqli_error($GLOBALS['conn']));
	}
	// $sql_bulk_insert = "";
	// $sql_existing_today_balance = "select * from item_stock_dispensary where ohc_location_id = '$ohc_id'  ";
	//error_log ( mysql_num_rows ( mysql_query ( $sql_existing_today_balance ) ) );`
	//error_log ( "$sql_existing_today_balance" );
	// if (! $result_today_bal = mysql_query ( $sql_existing_today_balance )) {
	// 	error_log ( "Failed to get Shift Balance:".mysql_error()." sql_existing_shift_balance:" . $sql_existing_today_balance );
	// }
	// $sql_bulk_insert .= "insert into item_stock_dispensary_shift_balance(item_id,item_batch_no,ohc_location_id,expiry_date,stock_qty,record_date,shift_id) values";

	// while ( $row_bal = @mysql_fetch_array ( $result_today_bal ) ) {
	// 	@extract ( $row_bal );

	// 	$sql_bulk_insert .= "('" . $row_bal ['item_id'] . "','" . $row_bal ['item_batch_no'] . "','" . $row_bal ['ohc_location_id'] . "','" . $row_bal ['expiry_date'] . "','" . $row_bal ['stock_qty'] . "','" . $shift_start_date . "',$shift_id),";
	// }
	// $sql_bulk_insert=substr($sql_bulk_insert, 0, -1);

	// error_log ( "bulk Insert shift Query:" . $sql_bulk_insert );

	// $mysqli = new mysqli ( "localhost", "root", "", "mpbirla_live" );

	// if ($mysqli->connect_errno) {
	// 	error_log ( "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error );
	// }

	// if (! $mysqli->multi_query ( $sql_bulk_insert )) {
	// 	error_log( "Multi shift query failed: (" . $mysqli->errno . ") " . $mysqli->error);
	// }
	// $mysqli->commit ();
	mysqli_query($GLOBALS['conn'],"COMMIT");
}

function updateItemStockStoreShiftBalance($shift_id, $shift_start_date)
{
	error_log("sdhsdgaeragsdshts:" . $shift_id);
	mysqli_query($GLOBALS['conn'], "BEGIN");
	error_log("Store Stock shift Balance Record");
	$sql_existing_today_balance = "select * from item_stock_store_shift_balance where record_date = '" . $shift_start_date . "' and shift_id=$shift_id  ";
	error_log("query" . $sql_existing_today_balance);
	$num_rows_existing = mysqli_num_rows(mysqli_query($GLOBALS['conn'], $sql_existing_today_balance));
	if ($num_rows_existing != 0) {
		$delete_existing_today_balance = "delete from item_stock_store_shift_balance where record_date = '" . $shift_start_date . "' and shift_id=$shift_id  ";
		error_log("query" . $delete_existing_today_balance);
		// echo $delete_existing_today_balance;
		// if (! mysqli_query($GLOBALS['conn'], $delete_existing_today_balance )) {
		// 	error_log("Failed to clear existing shift records:".mysqli_error($GLOBALS['conn'])." failing query:".$delete_existing_today_balance);


		// }
	}

	$sql_bulk_insert = "";
	$sql_existing_today_balance = "select * from item_stock ";
	error_log("$sql_existing_today_balance");
	if (!$result_today_bal = mysqli_query($GLOBALS['conn'], $sql_existing_today_balance)) {
		error_log("sql_existing_shift_balance:" . $sql_existing_today_balance);
	}
	while ($row_bal = @mysqli_fetch_array($result_today_bal)) {
		@extract($row_bal);
		$sql_bulk_insert .= "insert into item_stock_store_shift_balance(item_id,item_batch_no,expiry_date,stock_qty,record_date,shift_id) values(";
		$sql_bulk_insert .= "'" . $row_bal['item_id'] . "','" . $row_bal['item_batch_no'] . "','" . $row_bal['expiry_date'] . "','" . $row_bal['stock_qty'] . "','" . $shift_start_date . "', $shift_id);";
	}
	error_log("bulk Insert Query Store Shift:" . $sql_bulk_insert);


	$mysqli = new mysqli("localhost", "root", "", "tatametaliks_live");

	if ($mysqli->connect_errno) {
		error_log("Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error);
	}

	if (!$mysqli->multi_query($sql_bulk_insert)) {
		echo "Multi Shift query failed: (" . $mysqli->errno . ") " . $mysqli->error;
	}
	$mysqli->commit();
	mysqli_query($GLOBALS['conn'], "COMMIT");
}

function hasChildData($tableName, $nameCol, $selectedId)
{
	$sql = " select $nameCol from $tableName where $nameCol='" . $selectedId . "'  ";

	error_log("**" . $sql);

	$results = mysqli_query($GLOBALS['conn'], $sql);


	if ($row_consume = mysqli_fetch_array($results)) {
		return true;
	}

	return  false;
}
function save_log($requestStr, $feature_name, $feature_action, $file_name)
{
	$sql = "insert into audit_log(request_param,feature_name,feature_action,file_name,modified_by) values ('$requestStr','$feature_name','$feature_action','$file_name','" . $_SESSION['user_id'] . "' )";
	$results = mysqli_query($GLOBALS['conn'], $sql);
	error_log("audit-log:" . $sql);
}

function datediff($date){
date_default_timezone_set('Asia/Kolkata');
$bday = new DateTime($date);
$today = new Datetime(date('d-m-Y'));
$diff = $today->diff($bday);
return $diff->y." Years";
}

function getTodayapproval($type){
	
	$sql = "SELECT count(*) FROM questionaire_master_response where screen_date ='".date('Y-m-d')."' AND form_type ='$type' And approval_status = 'Y' ";
    error_log("total".$sql);
	$result = mysqli_query($GLOBALS['conn'],$sql);
	$row= mysqli_fetch_row($result);
return $row[0];
}


function resetItemStockAtDispensaryLevelForFollowup($appointment_id, $ohc_location_id,$followup_id)
{
	$query_for_treatment = " select issued_qty,item_id from  treatment where appointment_id='" . $appointment_id . "' and followup_id='".$followup_id."' ";

	error_log("query_for_treatment:" . $query_for_treatment);
	$result_for_treatemt = mysqli_query($GLOBALS['conn'], $query_for_treatment);

	while ($row_for_treatemnt = mysqli_fetch_array($result_for_treatemt)) {

		$issued_qty = $row_for_treatemnt['issued_qty'];
		$item_id = $row_for_treatemnt['item_id'];
		$is_group_item = getTableFieldValue('tbl_items', 'is_group_item', 'item_id', $item_id);
		if ($is_group_item == 'C') {
			resetItemStockAtDispensaryLevelForGroupItems($issued_qty, $item_id, $ohc_location_id);
			/*
			 * $result_for_group_items = getGroupItems($item_id);
			 *
			 * while ($row_for_group_items = mysqli_fetch_array($result_for_group_items)) {
			 *
			 * $used_qty = $row_for_group_items['qty'];
			 *
			 * $item_id = $row_for_group_items['item_id'];
			 *
			 * resetItemStockAtDispensaryLevelForGroupItems($used_qty, $item_id, $ohc_location_id);
			 *
			 * }
			 */
		} else if ($is_group_item == 'N') {

			// $batch_no = getMinExpiaryDateItem($ohc_location_id, $item_id);

			// echo "b".$batch_no;

			$stock_qty = getStockQtyAtDispensaryLevel($item_id, $ohc_location_id);
			$total_qty = floatval($stock_qty) + floatval($issued_qty);
			error_log("stock_qty:" . $stock_qty);
			error_log("issued_qty:" . $issued_qty);
			error_log("total_qty:" . $total_qty);

			$query_for_reset_item_dispensary_stock = " update item_stock_dispensary set stock_qty= $total_qty where item_id=$item_id and ohc_location_id=$ohc_location_id ";

			error_log("query_for_reset_item_dispensary_stock:" . $query_for_reset_item_dispensary_stock);
			if (!mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock)) {
				error_log("failed to reset dispensary stock:" . mysqli_error($GLOBALS['conn']) . " Failing Query:" . $query_for_reset_item_dispensary_stock);
				rollback();
				exit(mysqli_error($GLOBALS['conn']));
			}
		}
	}
}

function resetItemStockAtStoreLevelForFollowup($appointment_id, $ohc_location_id,$followup_id)
{
	$query_for_treatment = " select issued_qty,item_id,item_batch_no from  treatment where appointment_id='" . $appointment_id . "' and followup_id='".$followup_id."' ";

	error_log("query_for_treatment:" . $query_for_treatment);
	$result_for_treatemt = mysqli_query($GLOBALS['conn'], $query_for_treatment);

	while ($row_for_treatemnt = mysqli_fetch_array($result_for_treatemt)) {

		$issued_qty = $row_for_treatemnt['issued_qty'];
		$item_id = $row_for_treatemnt['item_id'];
		$item_batch_no = $row_for_treatemnt['item_batch_no'];
		$is_group_item = getTableFieldValue('tbl_items', 'is_group_item', 'item_id', $item_id);
		if ($is_group_item == 'C') {
			resetItemStockAtStoreLevelForGroupItems($issued_qty, $item_id, $ohc_location_id,$item_batch_no);
			/*
			 * $result_for_group_items = getGroupItems($item_id);
			 *
			 * while ($row_for_group_items = mysqli_fetch_array($result_for_group_items)) {
			 *
			 * $used_qty = $row_for_group_items['qty'];
			 *
			 * $item_id = $row_for_group_items['item_id'];
			 *
			 * resetItemStockAtDispensaryLevelForGroupItems($used_qty, $item_id, $ohc_location_id);
			 *
			 * }
			 */
		} else if ($is_group_item == 'N') {

			// $batch_no = getMinExpiaryDateItem($ohc_location_id, $item_id);

			// echo "b".$batch_no;

			$stock_qty = getStockQtyAtStoreLevel($item_id, $ohc_location_id,$item_batch_no);
			$total_qty = floatval($stock_qty) + floatval($issued_qty);
			error_log("stock_qty:" . $stock_qty);
			error_log("issued_qty:" . $issued_qty);
			error_log("total_qty:" . $total_qty);

			$query_for_reset_item_dispensary_stock = " update item_stock set stock_qty= $total_qty where item_id=$item_id and ohc_type_id=$ohc_location_id  and item_batch_no='".$item_batch_no."'";

			error_log("query_for_reset_item_dispensary_stock:" . $query_for_reset_item_dispensary_stock);
			if (!mysqli_query($GLOBALS['conn'], $query_for_reset_item_dispensary_stock)) {
				error_log("failed to reset dispensary stock:" . mysqli_error($GLOBALS['conn']) . " Failing Query:" . $query_for_reset_item_dispensary_stock);
				rollback();
				exit(mysqli_error($GLOBALS['conn']));
			}
		}
	}
}

function updateBookedAppointment($app_type,$emp_id,$date,$app_id){
	$date=explode(' ',$date);
	$date=$date[0];
	$query_rem = "update appointment_details set app_id= '".$app_id."',status='DRA' where emp_id = '$emp_id' and app_type='$app_type' and date(date)=STR_TO_DATE('" . $date . "','%d/%m/%Y') and ohc_type_id='".$_SESSION['current_ohcttype']."'";

	error_log("update appointment_details " . $query_rem);
	error_log($query_rem . "update appointment_details");
	if (!$result_rem = @mysqli_query($GLOBALS['conn'], $query_rem)) {
		rollback();
		exit(error_log(mysqli_error($GLOBALS['conn'])));
	}

}