将"全选"添加到筛选器

Question

我已经成功地为日历设置了一个过滤器，该过滤器显示不同用户的即将到来的工作，您可以在其中选择要查看其工作的用户。现在，我想向过滤器添加"全选"，以便它显示每个人的作业，而不仅仅是指定的用户。
我已经做了研究并发现了一个类似的问题，但它不太适用于我的情况(该问题使用输入表单字段，而我的问题使用数据库来创建过滤器，因此响应对我不起作用(，在我得到我的问题之前标记为我不相信的重复项。 这是页面代码：

if (isset($_REQUEST['id'])) {
$workDetails = GetWork($_REQUEST['id']);
$accountName = $_REQUEST['accountname'];
$accountId = $_REQUEST['accountid'];
}
if(isset($_REQUEST['inassigneduser'])){
$inassigneduser = $_REQUEST['inassigneduser'];
}else{
$inassigneduser = $_SESSION['userid'];
}
echo "<h2 class='title'>Planned Works</h2><hr class='red'/>";
?>
<table style="margin-bottom:10px;">
<tr>
<td style='width:120px;'><span class='title'>Assigned To:&nbsp;&nbsp;</span> 
</td>
<td id="plannedworkusers" style='width:170px;text-align:left;'><?php echo 
GetUserCombo($inassigneduser, true, "inassigneduser","All");?></td><td 
style='text-align:left;'></td>
<td style='text-align:left;'><a href='#' class='button' 
name='filterassigneduser' >Filter</a></td>
</tr>
</table>
<?php
echo "<div id='calendar' style='float:left; width:100%; margin-left:10px;'> 
</div>";
$events = '';
$events = GetHolidaysForCal($inassigneduser);

和我的函数.php文件：

function GetHolidaysForCal($inassigneduser)
{
mysql_connect(DB_HOST, DB_USER, DB_PASS);
mysql_select_db(DB_NAME) or die("Unable to select database");
$eventArray = array();
$sql = "SELECT w.*, c.name AS contactname, a.name AS accountname
FROM works w, contact c, account a
WHERE w.id = c.worksid
AND w.accountid = a.id
AND c.contacttype = 0
AND w.assignedtouser = $inassigneduser
AND (w.infracompletiondate != '0000-00-00'
OR w.meteringcompletiondate != '0000-00-00'
OR w.meterremovaldate != '0000-00-00'
OR w.servicedisconnectiondate != '0000-00-00'
OR w.gt1date != '0000-00-00'
OR w.sitesurveydate != '0000-00-00'
OR w.infrastructurestartdate != '0000-00-00'
OR w.liveanddeadcheckdate != '0000-00-00')
ORDER BY w.infracompletiondate ASC, w.meteringcompletiondate ASC ";
$result = mysql_query($sql);
$eventstr = "";
$color = 'black';

我希望这将提供足够的信息，有关如何添加此"全选"选项的任何帮助将不胜感激！

Answer 1

经过大量的试验和错误，我终于设法自己弄清楚了。下面是我编辑的函数.php文件的代码。

$sql = "SELECT w.*, c.name AS contactname, a.name AS accountname
FROM works w, contact c, account a
WHERE w.id = c.worksid
AND w.accountid = a.id
AND c.contacttype = 0";
//Added code
if ($inassigneduser != "all") {
$sql .= " AND w.assignedtouser = " . $inassigneduser;
}
$sql .= " AND (w.infracompletiondate != '0000-00-00'
OR w.meteringcompletiondate != '0000-00-00'
OR w.meterremovaldate != '0000-00-00'
OR w.servicedisconnectiondate != '0000-00-00'
OR w.gt1date != '0000-00-00'
OR w.sitesurveydate != '0000-00-00'
OR w.infrastructurestartdate != '0000-00-00'
OR w.liveanddeadcheckdate != '0000-00-00')
ORDER BY w.infracompletiondate ASC, w.meteringcompletiondate ASC ";