You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
93 lines
3.1 KiB
93 lines
3.1 KiB
|
|
<?php
|
|
@include('components/breadcrumb/breadcrumb.php');
|
|
setlocale(LC_MONETARY, 'it_IT.UTF-8');
|
|
|
|
if(isset($_POST['update_traking'])) {
|
|
$q = mysqli_query($conn, "UPDATE orders SET traking = '".$_POST['update_traking']."',
|
|
status = 'SHIPPED' WHERE id = ".$_POST['id']);
|
|
}
|
|
if(isset($_POST['update_status'])) {
|
|
$q = mysqli_query($conn, "UPDATE orders SET status = '".$_POST['update_status']."'
|
|
WHERE id = ".$_POST['id']);
|
|
}
|
|
?>
|
|
|
|
|
|
<div class="admin-list container py-5">
|
|
<div class="row list-row py-2 text-bold">
|
|
<div class="col-1"> Data </div>
|
|
<div class="col-3"> Articoli </div>
|
|
<div class="col-3"> Spedizione </div>
|
|
<div class="col-2"> Stato </div>
|
|
<div class="col-1"> Totale </div>
|
|
<div class="col-2"> Traking </div>
|
|
</div>
|
|
|
|
<?php
|
|
$q = mysqli_query($conn, "SELECT * FROM orders ORDER BY date DESC");
|
|
while($r = mysqli_fetch_array($q)) {
|
|
?>
|
|
|
|
<div class="row list-row py-2">
|
|
<div class="col-1 col-border">
|
|
<?= conv_date($r['date']);?>
|
|
</div>
|
|
<div class="col-3 col-border">
|
|
<?php
|
|
$items = json_decode($r['items']);
|
|
foreach($items as $item) {
|
|
$qp = mysqli_query($conn, "SELECT * FROM products WHERE id=".$item->pid);
|
|
$p = mysqli_fetch_array($qp);
|
|
?>
|
|
<div class="row">
|
|
<div class="col-6"><?= $p['name'];?></div>
|
|
<div class="col-3"><?= money_format('%.2n', $item->price);?></div>
|
|
<div class="col-3 text-right">x <?= $item->qty;?></div>
|
|
</div>
|
|
<?php
|
|
}
|
|
?>
|
|
</div>
|
|
<div class="col-3 col-border">
|
|
<?php
|
|
$shipping = json_decode($r['shipping']);
|
|
?>
|
|
<div class="row">
|
|
<div class="col-12"><?= $shipping->full_name;?></div>
|
|
<div class="col-12"><?= $shipping->address;?></div>
|
|
<div class="col-12"><?= $shipping->zip_code." - ".$shipping->city." (".$shipping->province.")";?></div>
|
|
</div>
|
|
</div>
|
|
<div class="col-2 col-border">
|
|
<form method="post">
|
|
<input type="hidden" name="id" value="<?= $r['id'];?>">
|
|
<select class="input-select input-small w-100" name="update_status" onChange="this.form.submit()">
|
|
<option value="CREATED" <?= $r['status'] == 'CREATED' ? 'selected' : '';?>>CREATED</option>
|
|
<option value="SHIPPED" <?= $r['status'] == 'SHIPPED' ? 'selected' : '';?>>SHIPPED</option>
|
|
<option value="PAID" <?= $r['status'] == 'PAID' ? 'selected' : '';?>>PAID</option>
|
|
<option value="CANCELED" <?= $r['status'] == 'CANCELED' ? 'selected' : '';?>>CANCELED</option>
|
|
</select>
|
|
</form>
|
|
</div>
|
|
<div class="col-1 col-border">
|
|
<?= money_format('%.2n', $r['total']);?>
|
|
</div>
|
|
<div class="col-2">
|
|
<form method="post">
|
|
<input type="hidden" name="id" value="<?= $r['id'];?>">
|
|
<input class="input-text input-small" type="text" name="update_traking" value="<?= $r['traking'];?>">
|
|
<button type="submit" class="button button-small button-brown w-100">Salva</button>
|
|
</form>
|
|
</div>
|
|
|
|
</div>
|
|
|
|
<?php
|
|
}
|
|
?>
|
|
|
|
</div>
|
|
</div>
|
|
|
|
|