javascript - 我无法运行条件 IF
问题描述
我有按日期过滤的代码,我有 2 个条件,
- 第一个条件:从日期选择器中获取“tanggal”
- 第二个条件:变量 'tanggal' isNull
但是,代码只运行第二个条件,即使给定了条件变量 date
这是代码:
看法:
.... some code ....
<form method="POST">
<div class="form-group">
<label>Date</label>
<div class="input-group date">
<div class="input-group-addon">
<span class="glyphicon glyphicon-th"></span>
</div>
<form method="get">
<input type="date" name="tanggal">
<input type="submit" value="FILTER">
</form>
.... some code ....
<tbody>
<?php
foreach ((array)$getDepartDetail as $us) { ?>
<tr>
<td><?php echo $us->Name ?></td>
<td><?php echo $us->NIK ?></td>
<td><?php echo $us->gender ?></td>
<td><?php echo $us->PositionDesc ?></td>
<td><?php echo $us->Shift ?></td>
<td><?php echo $us->tgl ?></td>
<td><?php echo $us->Attendance ?></td>
<td><a class="btn btn-info" href="<?php echo site_url('data_detail/detail_datas/vieworc/' . $us->NIK); ?>">Detail</a></td>
</tr>
<?php } ?>
</tbody>
.... some code ....
模型:
.... some code ....
public function get_allDprtDetail($DepartmentID)
{
if(isset($_GET['tanggal'])){
$tgl = $_GET['tanggal'];
$datas = "
SELECT DISTINCT
.... some code ....
FROM
emp0001
INNER JOIN emp0003 ON emp0003.DepartmentID = emp0001.DepartmentID
LEFT JOIN v_dvc0004_test ON emp0003.NIK = v_dvc0004_test.NIK
AND DATE(v_dvc0004_test.Enroll) = '$tgl'
JOIN emp0002 ON emp0002.PositionID = emp0003.PositionID
LEFT JOIN shift ON emp0003.Shift_ID = shift.Shift_ID
WHERE
emp0001.DepartmentID = '$DepartmentID'
AND emp0003.IsActive = 'T'
ORDER BY
v_dvc0004_test.Enroll ASC
";}
else{
$datas = "
SELECT DISTINCT
.... some code ....
}
$query = $this->db->query($datas);
return $query->result()
;}
解决方案
首先,您应该添加对结果计数的检查...
<tbody>
<?php if(count($getDepartDetail)> 0){ ?>
<?php foreach ($getDepartDetail as $us) { ?>
<tr>
<td><?php echo $us->Name ?></td>
<td><?php echo $us->NIK ?></td>
<td><?php echo $us->gender ?></td>
<td><?php echo $us->PositionDesc ?></td>
<td><?php echo $us->Shift ?></td>
<td><?php echo $us->tgl ?></td>
<td><?php echo $us->Attendance ?></td>
<td><a class="btn btn-info" href="<?php echo site_url('data_detail/detail_datas/vieworc/' . $us->NIK); ?>">Detail</a></td>
</tr>
<?php } ?>
<?php } ?>
</tbody>
推荐阅读
- python - 使用 NN 进行聚类识别
- typescript - 如何用常量定义对象的通用接口?
- android - Android webview没有将地理位置发送到javascript
- sql - 使用 GTFS 提要检测停止类型
- perl - 无法在未定义的值上调用方法“发送” - Net::SSH::Expect Perl 错误
- javascript - @aspnet/signalr 与 @microsoft/signalr javascript 库
- java - 如何根据 xslt 中的特定值检查所有 listnode 字段?
- angular - 如何使用 Nginx 将 Angular8 SSR 部署到 Ec2?
- laravel - 作曲家需要 laravel/passport 在 laravel 5.8 中不起作用
- ms-access - 排序访问联合查询 SQL