216 lines
11 KiB
PHP
216 lines
11 KiB
PHP
<?php
|
||
require("../inc/connect.php");
|
||
require("../inc/session.php");
|
||
|
||
if($deviceid == 0)
|
||
{
|
||
$_GET['warning'] = "No device selected";
|
||
}
|
||
|
||
$sql = "SELECT schedule.id as id, schedule.name AS aname, `time`, `duration`, stream.name AS sname, stream.id AS sid FROM `schedule`, `stream` WHERE schedule.stream = stream.id AND schedule.dev_id=$deviceid";
|
||
$query = ExecQuery($mysqli, $sql);
|
||
|
||
if($query->num_rows < 1)
|
||
{
|
||
$_GET['info'] = "No schedules found";
|
||
}
|
||
|
||
$sql = "SELECT `id`, `name` FROM `stream` WHERE `dev_id`=$deviceid";
|
||
$query2 = ExecQuery($mysqli, $sql);
|
||
|
||
if($query2->num_rows < 1)
|
||
{
|
||
$stream_edit = '<select class="form-control" disabled><option value="0">Please add a stream</option></select>';
|
||
$stream_add = '<select class="form-control" disabled><option value="0">Please add a stream</option></select>';
|
||
$stream_submit = false;
|
||
}
|
||
else
|
||
{
|
||
$stream_edit = '<select class="form-control" id="edit-schedule-stream" name="stream">';
|
||
$stream_add = '<select class="form-control" name="stream">';
|
||
|
||
while($result2 = $query2->fetch_assoc())
|
||
{
|
||
$stream_edit .= '<option value="' . $result2['id'] . '">' . $result2['name'] . '</option>';
|
||
$stream_add .= '<option value="' . $result2['id'] . '">' . $result2['name'] . '</option>';
|
||
}
|
||
|
||
$stream_edit .= '</select>';
|
||
$stream_add .= '</select>';
|
||
$stream_submit = true;
|
||
}
|
||
|
||
if($query->num_rows >= 5)
|
||
{
|
||
$new_submit = false;
|
||
}
|
||
else
|
||
{
|
||
$new_submit = true;
|
||
}
|
||
|
||
$page = 1;
|
||
require("inc/header.php");
|
||
|
||
?>
|
||
<!-- MENU SECTION END-->
|
||
<div class="row">
|
||
<div class="col-md-12">
|
||
<h4 class="page-head-line">Schedules</h4>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
<div class="row">
|
||
<div class="col-md-12">
|
||
|
||
<div class="panel panel-default">
|
||
<div class="panel-heading">
|
||
Schedules for <?php echo $device; ?>
|
||
</div>
|
||
<div class="panel-body">
|
||
<div class="table-responsive">
|
||
<table class="table table-striped table-bordered table-hover">
|
||
<thead>
|
||
<tr>
|
||
<th>Name</th>
|
||
<th>Time</th>
|
||
<th>Duration</th>
|
||
<th>Stream</th>
|
||
<th>Manage</th>
|
||
</tr>
|
||
</thead>
|
||
<tbody>
|
||
|
||
<?php while($result = $query->fetch_assoc()) { ?>
|
||
<tr>
|
||
<td class="schedule-name"><?php echo $result['aname']; ?></td>
|
||
<td class="schedule-time"><?php echo $result['time']; ?></td>
|
||
<td class="schedule-duration"><?php echo $result['duration']; ?></td>
|
||
<td class="schedule-stream"><?php echo $result['sname']; ?></td>
|
||
<td>
|
||
<a class="btn btn-default edit-button" data-toggle="modal" data-target="#edit-schedule" data-id="<?php echo $result['id']; ?>" data-stream="<?php echo $result['sid']; ?>">Edit</a>
|
||
<a class="btn btn-danger delete-button" data-toggle="modal" data-target="#delete-schedule" data-id="<?php echo $result['id']; ?>">Delete</a>
|
||
</td>
|
||
</tr>
|
||
<?php } ?>
|
||
</tbody>
|
||
</table>
|
||
</div>
|
||
</div>
|
||
<div class="panel-footer">
|
||
<p><a class="btn btn-primary" data-toggle="modal" data-target="#add-schedule">Add a schedule</a></p>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
<!-- EDIT schedule -->
|
||
<div class="modal fade" id="edit-schedule" tabindex="-1" role="dialog" aria-labelledby="edit-schedule-label" aria-hidden="true" style="display: none;">
|
||
<div class="modal-dialog">
|
||
<div class="modal-content">
|
||
<div class="modal-header">
|
||
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
|
||
<h4 class="modal-title" id="edit-schedule-label">Edit </h4>
|
||
</div>
|
||
<div class="modal-body">
|
||
<form id="edit-schedule-form" method="POST" action="php/device/schedule_edit.php">
|
||
<input type="hidden" class="form-control" name="id" id="edit-schedule-id"/>
|
||
<label>Name: </label>
|
||
<input type="text" class="form-control" name="name" id="edit-schedule-name" maxlength="16" required/>
|
||
<label>Time: </label>
|
||
<input type="text" class="form-control" name="time" id="edit-schedule-time" placeholder="00:00" pattern="\d{1,2}:\d{1,2}(:\d{1,2})?" required/>
|
||
<label>Time: </label>
|
||
<input type="text" class="form-control" name="duration" id="edit-schedule-duration" placeholder="00:00" pattern="\d{1,2}:\d{1,2}(:\d{1,2})?" required/>
|
||
<label>Stream: </label>
|
||
<?php echo $stream_edit; ?>
|
||
</form>
|
||
</div>
|
||
<div class="modal-footer">
|
||
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
|
||
<button type="submit" form="edit-schedule-form" class="btn btn-primary" <?php if(!$stream_submit){echo "disabled"; } ?>>Save changes</button>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
<!-- DELETE schedule -->
|
||
<div class="modal fade" id="delete-schedule" tabindex="-1" role="dialog" aria-labelledby="delete-schedule-label" aria-hidden="true" style="display: none;">
|
||
<div class="modal-dialog">
|
||
<div class="modal-content">
|
||
<div class="modal-header">
|
||
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
|
||
<h4 class="modal-title" id="delete-schedule-label">Delete </h4>
|
||
</div>
|
||
<div class="modal-body">
|
||
<form id="delete-schedule-form" method="POST" action="php/device/schedule_delete.php">
|
||
<input type="hidden" class="form-control" name="id" id="delete-schedule-id"/>
|
||
</form>
|
||
|
||
<p>Are you sure you want to delete this schedule?</p>
|
||
</div>
|
||
<div class="modal-footer">
|
||
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
|
||
<button type="submit" form="delete-schedule-form" class="btn btn-danger">Delete</button>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
<!-- ADD schedule -->
|
||
<div class="modal fade" id="add-schedule" tabindex="-1" role="dialog" aria-labelledby="add-schedule-label" aria-hidden="true" style="display: none;">
|
||
<div class="modal-dialog">
|
||
<div class="modal-content">
|
||
<div class="modal-header">
|
||
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
|
||
<h4 class="modal-title" id="add-schedule-label">Add a new schedule </h4>
|
||
</div>
|
||
<div class="modal-body">
|
||
<form id="add-schedule-form" method="POST" action="php/device/schedule_add.php">
|
||
<label>Name: </label>
|
||
<input type="text" class="form-control" name="name" id="add-schedule-name" maxlength="16" required/>
|
||
<label>Time: </label>
|
||
<input type="text" class="form-control" name="time" id="add-schedule-time" placeholder="00:00" pattern="\d{1,2}:\d{1,2}(:\d{1,2})?" required/>
|
||
<label>Duration: </label>
|
||
<input type="text" class="form-control" name="duration" id="add-schedule-duration" placeholder="00:00" pattern="\d{1,2}:\d{1,2}(:\d{1,2})?" required/>
|
||
<label>Stream: </label>
|
||
<?php echo $stream_add; ?>
|
||
</form>
|
||
</div>
|
||
<div class="modal-footer">
|
||
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
|
||
<button type="submit" form="add-schedule-form" class="btn btn-primary" <?php if(!$stream_submit || !$new_submit || $deviceid == 0){echo "disabled"; } ?>>Add schedule</button>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
<script>
|
||
$(".edit-button").click(function(){
|
||
var id = $( this ).data("id");
|
||
var name = $( this ).parent().parent().find(".schedule-name").html();
|
||
var time = $( this ).parent().parent().find(".schedule-time").html();
|
||
var duration = $( this ).parent().parent().find(".schedule-duration").html();
|
||
var stream = $( this ).data("stream");
|
||
|
||
$("#edit-schedule-label").html("Edit " + name);
|
||
$("#edit-schedule-id").attr("value", id);
|
||
$("#edit-schedule-name").attr("value", name);
|
||
$("#edit-schedule-time").attr("value", time);
|
||
$("#edit-schedule-duration").attr("value", duration);
|
||
$("#edit-schedule-stream").val(stream);
|
||
});
|
||
|
||
$(".delete-button").click(function(){
|
||
var id = $( this ).data("id");
|
||
var name = $( this ).parent().parent().find(".schedule-name").html();
|
||
|
||
$("#delete-schedule-label").html("Delete " + name);
|
||
$("#delete-schedule-id").attr("value", id);
|
||
});
|
||
</script>
|
||
|
||
<!-- CONTENT-WRAPPER SECTION END-->
|
||
<?php
|
||
require("inc/footer.php");
|
||
?>
|