php - 使用 if else 条件时我的数据表不起作用
问题描述
掌握
我在代码点火器和 sbadmin 2 主题上创建了一个配备 jquery 数据表的表，并使用 if else 条件来区分管理表和用户表。
对于 admin 表，它工作正常，但对于 user 表，奇怪的是我的数据表没有出现。
这是我的 js 来调用我的数据表：
<script>
$(document).ready(function() {
$('.dataTables').DataTable({
responsive: true
});
});
</script>
这是我的视图代码：
<table class="table table-hover dataTables">
<thead class="thead-dark text-center">
<tr>
<th scope="col">No</th>
<th scope="col">Tanggal</th>
<th scope="col">NIK</th>
<th scope="col">User Name</th>
<th scope="col">Room Name</th>
<th scope="col">Meeting Start</th>
<th scope="col">Meeting End</th>
<th scope="col">Status</th>
<th scope="col">Description</th>
<th scope="col">Action</th>
</tr>
</thead>
<tbody>
<!-- no urutan table -->
<?php $i = 1; ?>
<?php foreach ($reserve->result_array() as $loopReserve) :
$id_ruangan = $loopReserve['id_ruangan'];
$nama_ruangan = $loopReserve['nama_ruangan'];
$nik = $loopReserve['nik'];
$user_id = $loopReserve['user_id'];
$nama_depan = $loopReserve['nama_depan'];
$nama_belakang = $loopReserve['nama_belakang'];
$meeting_start = $loopReserve['meeting_start'];
$meeting_end = $loopReserve['meeting_end'];
$keterangan = $loopReserve['keterangan'];
$is_cancel = $loopReserve['is_cancel'];
$cancel_by = $loopReserve['cancel_by'];
$cancel_date = $loopReserve['cancel_date'];
$alasan = $loopReserve['alasan'];
$created_date = $loopReserve['created_date']
?>
<tr class="text-center">
<?php if ($user['user_id'] == $user_id) : ?>
<th scope="row"><?php echo $i++; ?></th>
<td><?php echo date('m/d/Y', $created_date); ?></td>
<td><?php echo $nik; ?></td>
<td><?php echo $nama_depan . ' ' . $nama_belakang; ?></td>
<td>
<?php echo $nama_ruangan; ?>
</td>
<td><?php echo date('m/d/Y H:i', $meeting_start); ?></td>
<td><?php echo date('m/d/Y H:i', $meeting_end); ?></td>
<td>
<?php if (date('m/d/Y') == date('m/d/Y', $meeting_start)) : ?>
<?php if (date('m/d/Y H:i') < date('m/d/Y H:i', $meeting_start)) : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-warning">Noted</div>
<?php endif; ?>
<?php elseif (date('m/d/Y H:i') >= date('m/d/Y H:i', $meeting_start) && date('m/d/Y H:i') <= date('m/d/Y H:i', $meeting_end)) : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-primary">Progress</div>
<?php endif; ?>
<?php else : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-success">Done</div>
<?php endif; ?>
<?php endif; ?>
<?php elseif (date('m/d/Y') > date('m/d/Y', $meeting_end)) : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-success">Done</div>
<?php endif; ?>
<?php else : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-warning">Noted</div>
<?php endif ?>
<?php endif; ?>
</td>
<td>
<p class="text-break mx-0"><?php echo $keterangan; ?></p>
</td>
<td>
<?php if ($user['level_id'] == 1) : ?>
<?php if ($is_cancel == 1) : ?>
<div class="row justify-content-center">
<a href="#">
<button class="btn btn-warning px-2 py-0 mb-1" data-toggle="modal" data-target="#ViewReserveModal<?php echo $id_ruangan ?>"><small><i class="far fa-fw fa-eye"></i><span class="d-none d-xl-inline"> View</span></small></button>
</a>
<a href="#">
<button class="btn btn-primary ml-2 px-2 py-0 d-none d-xl-inline mb-1" data-toggle="modal" data-target="#EditReserveModal<?php echo $id_ruangan ?>"><small><i class="fas fa-fw fa-edit"></i><span class="d-none d-xl-inline"> Edit</span></small></button>
</a>
</div>
<?php else : ?>
<div class="row justify-content-center">
<a href="#">
<button class="btn btn-warning px-2 py-0 d-xl-inline mb-1" data-toggle="modal" data-target="#ViewReserveModal<?php echo $id_ruangan ?>"><small><i class="far fa-fw fa-eye"></i><span class="d-none d-xl-inline"> View</span></small></button>
</a>
<a href="#">
<button class="btn btn-primary ml-2 px-2 py-0 d-none d-xl-inline mb-1" data-toggle="modal" data-target="#EditReserveModal<?php echo $id_ruangan ?>"><small><i class="fas fa-fw fa-edit"></i><span class="d-none d-xl-inline"> Edit</span></small></button>
</a>
<a href="#">
<button class="btn btn-danger ml-2 px-2 py-0 d-none d-xl-inline" data-toggle="modal" data-target="#CancelModal<?php echo $id_ruangan ?>"><small><i class="fas fa-fw fa-ban"></i><span class="d-none d-xl-inline"> Cancel</span></small></button>
</a>
</div>
<?php endif; ?>
<?php else : ?>
<?php if ($is_cancel == 1) : ?>
<div class="row justify-content-center">
<a href="#">
<button class="btn btn-warning px-2 py-0 mb-1" data-toggle="modal" data-target="#ViewReserveModal<?php echo $id_ruangan ?>"><small><i class="far fa-fw fa-eye"></i><span class="d-none d-xl-inline"> View</span></small></button>
</a>
</div>
<?php else : ?>
<div class="row justify-content-center">
<a href="#">
<button class="btn btn-warning px-2 py-0 d-xl-inline mb-1" data-toggle="modal" data-target="#ViewReserveModal<?php echo $id_ruangan ?>"><small><i class="far fa-fw fa-eye"></i><span class="d-none d-xl-inline"> View</span></small></button>
</a>
<a href="#">
<button class="btn btn-danger ml-2 px-2 py-0 d-none d-xl-inline" data-toggle="modal" data-target="#CancelModal<?php echo $id_ruangan ?>"><small><i class="fas fa-fw fa-ban"></i><span class="d-none d-xl-inline"> Cancel</span></small></button>
</a>
</div>
<?php endif; ?>
<?php endif; ?>
</td>
<?php elseif ($user['level_id'] == 1) : ?>
<th scope="row"><?php echo $i++; ?></th>
<td><?php echo date('m/d/Y', $created_date); ?></td>
<td><?php echo $nik; ?></td>
<td><?php echo $nama_depan . ' ' . $nama_belakang; ?></td>
<td>
<?php echo $nama_ruangan; ?>
</td>
<td><?php echo date('m/d/Y H:i', $meeting_start); ?></td>
<td><?php echo date('m/d/Y H:i', $meeting_end); ?></td>
<td>
<?php if (date('m/d/Y') == date('m/d/Y', $meeting_start)) : ?>
<?php if (date('m/d/Y H:i') < date('m/d/Y H:i', $meeting_start)) : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-warning">Noted</div>
<?php endif; ?>
<?php elseif (date('m/d/Y H:i') >= date('m/d/Y H:i', $meeting_start) && date('m/d/Y H:i') <= date('m/d/Y H:i', $meeting_end)) : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-primary">Progress</div>
<?php endif; ?>
<?php else : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-success">Done</div>
<?php endif; ?>
<?php endif; ?>
<?php elseif (date('m/d/Y') > date('m/d/Y', $meeting_end)) : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-success">Done</div>
<?php endif; ?>
<?php else : ?>
<?php if ($is_cancel == 1) : ?>
<div class="badge badge-danger">Cancel by <?php echo $cancel_by; ?></div>
<?php else : ?>
<div class="badge badge-warning">Noted</div>
<?php endif ?>
<?php endif; ?>
</td>
<td>
<p class="text-break mx-0"><?php echo $keterangan; ?></p>
</td>
<td>
<?php if ($user['level_id'] == 1) : ?>
<?php if ($is_cancel == 1) : ?>
<div class="row justify-content-center">
<a href="#">
<button class="btn btn-warning px-2 py-0 mb-1" data-toggle="modal" data-target="#ViewReserveModal<?php echo $id_ruangan ?>"><small><i class="far fa-fw fa-eye"></i><span class="d-none d-xl-inline"> View</span></small></button>
</a>
<a href="#">
<button class="btn btn-primary ml-2 px-2 py-0 d-none d-xl-inline mb-1" data-toggle="modal" data-target="#EditReserveModal<?php echo $id_ruangan ?>"><small><i class="fas fa-fw fa-edit"></i><span class="d-none d-xl-inline"> Edit</span></small></button>
</a>
</div>
<?php else : ?>
<div class="row justify-content-center">
<a href="#">
<button class="btn btn-warning px-2 py-0 d-xl-inline mb-1" data-toggle="modal" data-target="#ViewReserveModal<?php echo $id_ruangan ?>"><small><i class="far fa-fw fa-eye"></i><span class="d-none d-xl-inline"> View</span></small></button>
</a>
<a href="#">
<button class="btn btn-primary ml-2 px-2 py-0 d-none d-xl-inline mb-1" data-toggle="modal" data-target="#EditReserveModal<?php echo $id_ruangan ?>"><small><i class="fas fa-fw fa-edit"></i><span class="d-none d-xl-inline"> Edit</span></small></button>
</a>
<a href="#">
<button class="btn btn-danger ml-2 px-2 py-0 d-none d-xl-inline" data-toggle="modal" data-target="#CancelModal<?php echo $id_ruangan ?>"><small><i class="fas fa-fw fa-ban"></i><span class="d-none d-xl-inline"> Cancel</span></small></button>
</a>
</div>
<?php endif; ?>
<?php else : ?>
<?php if ($is_cancel == 1) : ?>
<div class="row justify-content-center">
<a href="#">
<button class="btn btn-warning px-2 py-0 mb-1" data-toggle="modal" data-target="#ViewReserveModal<?php echo $id_ruangan ?>"><small><i class="far fa-fw fa-eye"></i><span class="d-none d-xl-inline"> View</span></small></button>
</a>
</div>
<?php else : ?>
<div class="row justify-content-center">
<a href="#">
<button class="btn btn-warning px-2 py-0 d-xl-inline mb-1" data-toggle="modal" data-target="#ViewReserveModal<?php echo $id_ruangan ?>"><small><i class="far fa-fw fa-eye"></i><span class="d-none d-xl-inline"> View</span></small></button>
</a>
<a href="#">
<button class="btn btn-danger ml-2 px-2 py-0 d-none d-xl-inline" data-toggle="modal" data-target="#CancelModal<?php echo $id_ruangan ?>"><small><i class="fas fa-fw fa-ban"></i><span class="d-none d-xl-inline"> Cancel</span></small></button>
</a>
</div>
<?php endif; ?>
<?php endif; ?>
</td>
<?php endif; ?>
</tr>
<?php endforeach; ?>
</tbody>
</table>
这是我的控制器：
public function reserve()
{
$data['user'] = $this->db->get_where('user', ['nik' =>
$this->session->userdata('nik')])->row_array();
$data['reserve'] = $this->Model_reserve->getReserve();
$data['username'] = $this->Model_reserve->getUser();
$data['meeting'] = $this->Model_reserve->viewMr();
$data['title'] = 'Reserve';
$this->form_validation->set_rules('date', 'Date', 'required|trim');
if ($this->form_validation->run() == false) {
$this->load->view('template/header', $data);
$this->load->view('template/sidebar', $data);
$this->load->view('template/topbar', $data);
$this->load->view('menu/reserve', $data);
$this->load->view('template/footer');
} else {
$this->myReservation();
}
}
这是我的模型：
public function getReserve()
{
$result = $this->db->query("SELECT ruang_meeting.*, user.nama_depan, user.nama_belakang FROM ruang_meeting
JOIN user ON ruang_meeting.user_id = user.user_id ORDER BY ruang_meeting.id_ruangan DESC");
return $result;
}
我不知道我的代码有什么问题，请帮助我。谢谢你
解决方案
您是否有从管理员到用户的单独表格？如果是这样，请检查您的 DataTable 初始化位置。
//管理表代码。
<table id="adminTable" class="dataTables"/>
// 数据表初始化
<script>
$(document).ready(function() {
$('.dataTables').DataTable({
responsive: true
});
});
</script>
//用户表代码。
<table id="userTable" class="dataTables"/>
推荐阅读
- python - 如何检查矩阵是否在矩阵列表中 Python
- sql - 如果，PL SQL 中的 ELSIF 和 ELSE 条件不起作用
- javascript - 如何使用 libphonenumber AsYouTypeFormatter 处理退格
- ruby-on-rails - 带有“if”语句的嵌套循环
- c++ - C/C++ 位数组分辨率变换算法
- c++ - 软件预取和反向循环
- android - 如何将 .class 库导入 Android Studio 上的项目？
- javascript - 云功能 - 看不到我的功能部署到 Firebase 控制台
- python - python OpenAI gym monitor在录制目录下创建json文件
- sql-server - 键入 SQL 查询时，如何修改下拉列表