<?php
// Checked for PHP5.6 / 8.x compatibility
include ('../../operainfo/getq3.php');
$x=getsecurity();
$companyid=safetext2(isset($_GET['companyid']) ? $_GET['companyid'] : '');
$rowid=safetext2(isset($_GET['rowid']) ? $_GET['rowid'] : '');
if ($companyid==''){
	$companyid=1;
	}
	
$output="<select id='newtypeid' >  ";

if ($global_access_staff[$companyid] > 0 ) {
$s="SELECT * FROM vmemphollogtypes  order by effectonholidays , description";	
	} else {
$s="SELECT * FROM vmemphollogtypes where 	displayotherusers='0' order by effectonholidays , description";
}
$result=sqlquery($s);
$num=mysqli_num_rows($result);
$stmt = pdoquery($s);
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
	$timetime="Does Not Affect Holidays";
	if ($row['effectonholidays'] > 0 ) {
		$timetime="Adds To Holidays";
		}
	if ($row['effectonholidays'] < 0 ) {
		$timetime="Removes from Holidays";
		}
	$output .= "<option value='".$row['id']."'>$timetime - ".$row['description']." </option>";
}

$output .= "</select><input type=button value='Update' onclick=\"updateholtypecommit('$rowid')\">";


echo $output;
?>