88
<?php
require_once("../DB.php");
$customers = R::getAll('SELECT * FROM
customers');
foreach ($customers as $customer) { ?>
<option value="<?php echo
$customer['id']; ?>">
<?php echo
$customer['customername']; ?>
</option>
<?php } ?>
</select>
</div>
<button type="submit" class="btn btn-
success">Сохранить заказ</button>
<a href="orders.php" class="btn btn-info">Назад</a>
</form>
</div>
</div>
</div>
<?php require_once("../footer.php") ?>
<?php
require_once("../DB.php");
try {
if (isset($_GET['id'])) {
$id = $_GET['id'];
$orders = R::load('orders', $id);
R::trash($orders);
header('location: orders.php?msg=Запись удалена!');
}
} catch (exception $e) {
echo "Запись нельзя удалить. Есть связанные данные!";
echo "<br><a href = 'orders.php'>Назад</a>";
}
<?php $title = "Заказы"; ?>
<?php require_once("../header.php") ?>
<div class="container" style="margin-top:30px; margin-bottom:
30px;">
<div class="row">
<div class="col-md-12">
<h2><?php echo $title ?></h2>
<table class="table table-hover">
<thead>
<tr>
<th>Номер</th>
<th>Дата</th>
<th>Статус</th>
<th>Менеджер</th>
<th>Клиент</th>
89
<th></th>
</tr>
</thead>
<tbody>
<?php
require_once("../DB.php");
$orders = R::getAll('SELECT * FROM orders');
foreach ($orders as $order) {
$id = $order['id'];
$ordercustomer =
$order['customers_idcustomer'];
$ordermanager = $order['managers_idmanager'];
$managers = R::load('managers', $ordermanager);
$manager = $managers->name;
$customers = R::load('customers',
$ordercustomer);
$customer = $customers->customername;
$status = $order['status'];
switch ($status) {
case 1:
$statusvalue = "На рассмотрении";
break;
case 2:
$statusvalue = "На выполнеии";
break;
case 3:
$statusvalue = "Выполнен";
break;
case 4:
$statusvalue = "Отменен";
break;
}
echo "<tr>
<td>" . $id . "</td>
<td>" . $order['date'] . "</td>
<td>" . $statusvalue . "</td>
<td>" . $manager . "</td>
<td>" . $customer . "</td>
<td><a href='orderupdate.php?id=$id' class='btn
btn-info'>Редактировать</a>
| <a href='orderdelete.php?id=$id' class='btn
btn-warning' onclick='return confirmDelete();'>Удалить</a></td>
</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<a class="btn btn-light" href="addorder.php">Добавить заказ</a>
</div>
90
<?php require_once("../footer.php") ?>
<?php
require_once("../DB.php");
if (isset($_GET['id'])) {
$id = $_GET['id'];
$orders = R::load('orders', $id);
$date = $orders->date;
$status = $orders->status;
$managers_idmanager = $orders->managers_idmanager;
$customers_idcustomer = $orders->customers_idcustomer;
}
if ($_POST) {
$date = trim(htmlspecialchars($_POST['date']));
$status = trim(htmlspecialchars($_POST['status']));
$managers_idmanager = $_POST['managers_idmanager'];
$category_idcategory = $_POST['customers_idcustomer'];
// if (!empty($productname)) {
require_once("../DB.php");
$orders = R::load('orders', $id);
$orders->date = $date;
$orders->status = $status;
$orders->managers_idmanager = $managers_idmanager;
$orders->customers_idcustomer = $category_idcategory;
R::store($orders);
header('location: orders.php?msg=Запись успешно добавлена!');
// }
}
?>
<?php $title = "Добавить заказ"; ?>
<?php require_once("../header.php") ?>
<div class="container" style="margin-top:30px; margin-bottom:
30px;">
<div class="row">
<div class="col-md-12">
<form method="post">
<div class="form-group">
<label for="date">Дата</label>
<input type="date" class="form-control"
name="date" id="date" value="<?= $date ?>">
</div>
<label for="status">Статус</label>
<select class="form-control" name="status"
id="status">
<option value="<?= $status; ?>"
selected="selected">
<?php
switch ($status) {
case 1:
91
$statusvalue = "На
рассмотрении";
break;
case 2:
$statusvalue = "На выполнеии";
break;
case 3:
$statusvalue = "Выполнен";
break;
case 4:
$statusvalue = "Отменен";
break;
}
?>
<?= $statusvalue; ?>
</option>
<option value="1">На рассмотрении</option>
<option value="2">На выполнеии</option>
<option value="3">Выполнен</option>
<option value="4">Отменен</option>
</select>
</div>
<div class="form-group">
<label
for="managers_idmanager">Менеджер</label>
<select type="text" class="form-control"
name="managers_idmanager" id="managers_idmanager">
<?php
//
require_once("../DB.php");
$managers = R::getAll('SELECT * FROM
managers');
?>
<option value="<?= $managers_idmanager; ?>"
selected="selected">
<?php $manager = R::load('managers',
$managers_idmanager);
echo $manager->name; ?>
</option>
<?php
foreach ($managers as $manager) { ?>
<option value="<?php echo
$manager['id']; ?>">
<?php echo $manager['name']; ?>
</option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label
for="customers_idcustomer">Клиент</label>
92
<select type="text" class="form-control"
name="customers_idcustomer" id="customers_idcustomer">
<?php
require_once("../DB.php");
$customers = R::getAll('SELECT * FROM
customers');
?>
<option value="<?= $customers_idcustomer;
?>" selected="selected">
<?php $customer = R::load('customers',
$customers_idcustomer);
echo $customer->customername; ?>
</option>
<?php
foreach ($customers as $customer) { ?>
<option value="<?php echo
$customer['id']; ?>">
<?php echo
$customer['customername']; ?>
</option>
<?php } ?>
</select>
</div>
<button type="submit" class="btn btn-
success">Сохранить заказ</button>
<a href="orders.php" class="btn btn-info">Назад</a>
</form>
</div>
</div>
</div>
<?php require_once("../footer.php") ?>
<?php
if ($_POST) {
$productname = trim(htmlspecialchars($_POST['productname']));
$weight = trim(htmlspecialchars($_POST['weight'])) ?: null;
$volume = trim(htmlspecialchars($_POST['volume'])) ?: null;
$count = trim(htmlspecialchars($_POST['count'])) ?: null;
$category_idcategory = $_POST['category_idcategory'];
if (!empty($productname)) {
require_once("../DB.php");
$products = R::dispense('products');
$products->productname = $productname;
$products->weight = $weight;
$products->volume = $volume;
$products->count = $count;
$products->category_idcategory = $category_idcategory;
R::store($products);
header('location: products.php?msg=Записьуспешно добавлена!');
}
}
93
?>
<?php $title = "Добавить продукт"; ?>
<?php require_once("../header.php") ?>
<div class="container" style="margin-top:30px; margin-bottom:
30px;">
<div class="row">
<div class="col-md-12">
<form method="post">
<div class="form-group">
<label for="productname">Название
товара</label>
<input type="text" class="form-control"
name="productname" id="productname">
</div>
<div class="form-group">
<label for="weight">Вес</label>
<input type="text" class="form-control"
name="weight" id="weight">
</div>
<div class="form-group">
<label for="volume">Объем</label>
<input type="text" class="form-control"
name="volume" id="volume">
</div>
<div class="form-group">
<label for="count">Количество</label>
<input type="text" class="form-control"
name="count" id="count">
</div>
<div class="form-group">
<label
for="category_idcategory">Категория</label>
<select type="text" class="form-control"
name="category_idcategory" id="category_idcategory">
<?php
require_once("../DB.php");
$categories = R::getAll('SELECT * FROM
categories');
foreach ($categories as $category) { ?>
<option value="<?php echo
$category['id']; ?>">
<?php echo
$category['categoryname']; ?>
</option>
<?php } ?>
</select>
</div>
<button type="submit" class="btn btn-
success">Сохранить товар</button>
94
<a href="products.php" class="btn btn-
info">Назад</a>
</form>
</div>
</div>
</div>
<?php require_once("../footer.php") ?>
<?php
require_once("../DB.php");
try {
if (isset($_GET['id'])) {
$id = $_GET['id'];
$products = R::load('products', $id);
R::trash($products);
header('location: products.php?msg=Запись удалена!');
}
} catch (exception $e) {
echo "Запись нельзя удалить. Есть связанные данные!";
echo "<br><a href = 'products.php'>Назад</a>";
}
<?php $title = "Товары"; ?>
<?php require_once("../header.php") ?>
<div class="container" style="margin-top:30px; margin-bottom:
30px;">
<div class="row">
<div class="col-md-12">
<h2><?php echo $title ?></h2>
<table class="table table-hover">
<thead>
<tr>
<th>Номер</th>
<th>Наименование</th>
<th>Вес</th>
<th>Объем</th>
<th>Количество</th>
<th>Категория</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
require_once("../DB.php");
$products = R::getAll('SELECT * FROM products');
foreach ($products as $product) {
$id = $product['id'];
$prodcat = $product['category_idcategory'];
$category = R::load('categories', $prodcat);
$categoryname = $category->categoryname;
echo "<tr>
95
<td>" . $id . "</td>
<td>" . $product['productname'] . "</td>
<td>" . $product['weight'] . "</td>
<td>" . $product['volume'] . "</td>
<td>" . $product['count'] . "</td>
<td>" . $categoryname . "</td>
<td><a href='productupdate.php?id=$id'
class='btn btn-info'>Редактировать</a>
| <a href='productdelete.php?id=$id' class='btn
btn-warning' onclick='return confirmDelete();'>Удалить</a></td>
</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<a class="btn btn-light" href="addproduct.php">Добавить
товар</a>
</div>
<?php require_once("../footer.php") ?>
<?php
require_once("../DB.php");
if (isset($_GET['id'])) {
$id = $_GET['id'];
$products = R::load('products', $id);
$productname = $products->productname;
$weight = $products->weight;
$volume = $products->volume;
$count = $products->count;
$category_idcategory = $products->category_idcategory;
}
if ($_POST) {
$productname = trim(htmlspecialchars($_POST['productname']));
$weight = trim(htmlspecialchars($_POST['weight'])) ?: null;
$volume = trim(htmlspecialchars($_POST['volume'])) ?: null;
$count = trim(htmlspecialchars($_POST['count'])) ?: null;
$category_idcategory = $_POST['category_idcategory'];
if (!empty($productname)) {
require_once("../DB.php");
$category = R::load('categories', $id);
$products->productname = $productname;
$products->weight = $weight;
$products->volume = $volume;
$products->count = $count;
$products->category_idcategory = $category_idcategory;
R::store($products);
header('location: products.php?msg=Записьуспешно добавлена!');
}
96
}
?>
<?php $title = "Редактировать продукт"; ?>
<?php require_once("../header.php") ?>
<div class="container" style="margin-top:30px; margin-bottom:
30px;">
<div class="row">
<div class="col-md-12">
<form method="post">
<div class="form-group">
<label for="productname">Название
товара</label>
<input type="text" class="form-control"
name="productname" id="productname"
value="<?php echo $productname; ?>">
</div>
<div class="form-group">
<label for="weight">Вес</label>
<input type="text" class="form-control"
name="weight" id="weight" value="<?php echo $weight; ?>">
</div>
<label for="volume">Объем</label>
<input type="text" class="form-control"
name="volume" id="volume" value="<?php echo $volume; ?>">
</div>
<div class="form-group">
<label for="count">Количество</label>
<input type="text" class="form-control"
name="count" id="count" value="<?php echo $count; ?>">
</div>
<div class="form-group">
<label
for="category_idcategory">Категория</label>
<select type="text" class="form-control"
name="category_idcategory" id="category_idcategory">
<?php
require_once("../DB.php");
?>
<option value="<?php echo
$category_idcategory; ?>" selected="selected">
<?php $categories =
R::load('categories', $category_idcategory);
echo $categories->categoryname; ?>
</option>
<?php
$categories = R::getAll('SELECT * FROM
categories');
foreach ($categories as $category) { ?>
<option value="<?php echo
$category['id']; ?>">
97
<?php echo
$category['categoryname']; ?>
</option>
<?php } ?>
</select>
</div>
<button type="submit" class="btn btn-
success">Сохранить товар</button>
<a href="products.php" class="btn btn-
info">Назад</a>
</form>
</div>
</div>
</div>
<?php require_once("../footer.php") ?>
<?php
if ($_POST) {
$count = trim(htmlspecialchars($_POST['count']));
$product_idproduct = $_POST['product_idproduct'];
$orders_idorder = $_POST['orders_idorder'];
require_once("../DB.php");
$productsoforders = R::dispense('productsoforders');
$productsoforders->count = $count;
$productsoforders->product_idproduct = $product_idproduct;
$productsoforders->orders_idorder = $orders_idorder;
R::store($productsoforders);
header('location: productoforders.php?msg=Запись успешно
добавлена!');
}
?>
<?php $title = "Добавить товары в заказ"; ?>
<?php require_once("../header.php") ?>
<div class="container" style="margin-top:30px; margin-bottom:
30px;">
<div class="row">
<div class="col-md-12">
<form method="post">
<div class="form-group">
<label for="orders_idorder">Номер
заказа</label>
<select type="text" class="form-control"
name="orders_idorder" id="orders_idorder">
<?php
require_once("../DB.php");
$orders = R::getAll('SELECT * FROM orders');
foreach ($orders as $order) { ?>
<option value="<?php echo $order['id'];
?>">