56 lines
1.8 KiB
PHP
56 lines
1.8 KiB
PHP
|
|
<?php require_once('Connections/bkngstm.php'); ?>
|
|
<?php require_once('webassist/mysqli/rsobj.php'); ?>
|
|
<?php require_once('webassist/mysqli/queryobj.php'); ?>
|
|
<?php if (isset($_POST['propagateenddate'])) { $propagateenddate=$_POST['propagateenddate']; } ?>
|
|
<?php if (isset($_POST['idservice'])) { $idservice=$_POST['idservice']; } ?>
|
|
<?php if (isset($_POST['dayclass'])) { $dayclass=$_POST['dayclass']; } ?>
|
|
<?php if (isset($_POST['timeclass'])) { $timeclass=$_POST['timeclass']; } ?>
|
|
<?php if (isset($_POST['durationtime'])) { $durationtime=$_POST['durationtime']; } ?>
|
|
<?php //propagate classes
|
|
|
|
// Create connection
|
|
$conn = new mysqli($servername, $username, $password, $dbname);
|
|
?>
|
|
<?php //fake variable
|
|
$propagateenddate="2024-12-01";
|
|
$dayclass="Tuesday";
|
|
$idservice="1";
|
|
$timeclass="18:30";
|
|
$durationtime="1";
|
|
?>
|
|
<?php
|
|
|
|
//define next day
|
|
|
|
//timestamp
|
|
$nextClassDay = strtotime('next Tuesday');
|
|
//date
|
|
$datenext=date('Y-m-d', $nextClassDay);
|
|
|
|
while ($datenext < $propagateenddate) {
|
|
// merge time with date
|
|
$datenextschedule=$datenext.' '.$timeclass;
|
|
echo $datenextschedule;
|
|
|
|
//query to check if present
|
|
$checkdateclass = new WA_MySQLi_RS("checkdateclass",$bkngstm,0);
|
|
$checkdateclass->setQuery("SELECT * FROM serviceschedule WHERE serviceschedule.dateschedule='$datenextschedule'");
|
|
$checkdateclass->execute();
|
|
if (empty($checkdateclass->getColumnVal("idserviceschedule"))) {
|
|
|
|
$sql = "INSERT INTO serviceschedule (idservice, dateschedule, scheduleday, startingtime, durationtime)
|
|
VALUES ($idservice, '$datenextschedule', '$dayclass', '$timeclass', $durationtime)";
|
|
echo $sql;
|
|
if ($conn->query($sql) === TRUE) {
|
|
echo "New record created successfully";
|
|
} else {
|
|
echo "Error: " . $sql . "<br>" . $conn->error;
|
|
}
|
|
|
|
}$nextClassDay =strtotime("+7 day", $nextClassDay);
|
|
$datenext=date('Y-m-d', $nextClassDay);
|
|
echo $nextClassDay;
|
|
echo $datenext;
|
|
}
|
|
?>
|