require 'header-store.php';
if (!isset($_SESSION['id'])) {
echo "";
exit();
}
if(!$_SESSION['verified']):
echo "";
endif;
if ($_SESSION['verified']):
$admin = ADMIN;
?>
ISTORIE DE COMANDĂ - ADMIN PAGE
$result = $db->query("SELECT * FROM customers INNER JOIN orders ON orders.customer_id = customers.id WHERE orders.status = 'Finalizata' OR orders.status = 'ANULATA' ORDER BY orders.created DESC");
if($result->num_rows > 0){
while($item = $result->fetch_assoc()){
?>
Nume: echo $item["full_name"]; ?>
Email: echo $item["email"]; ?>
Telefon: echo $item["phone"]; ?>
Metode de livrare: echo $item["metodeLivrare"]; ?>
Address: echo $item["address"]; ?>
if($item["old_livrare"] == 'none') { ?>
Cost de livrare: echo $item["livrare"]; ?>
lei
} else {?>
Cost de livrare: echo $item["livrare"]; ?>
Cost de livrare: echo $item["livrare"]; ?>
echo $item["old_livrare"]; ?>lei
Reducere: livrare gratuit!
}?>
if($item["status_promo_code"] == '0' && $item["status2"] !== 'Platit' && $item["status2"] !== 'Transfer Bancar') { ?>
PRET Total: echo $item["grand_total"]; ?>
lei
if($item["promo_code"] == 'none'){$promo_code_alert = 'alert-warning';} else { $promo_code_alert = 'alert-success'; }?>
Promo Code: echo $item["promo_code"]; ?>
}else { ?>
PRET Total: echo $item["grand_total"]; ?>
lei
echo $item["old_grand_total"]; ?>
Reducere: echo $item["discount"]; ?>%
Promo Code: echo $item["promo_code"]; ?> - folosit cu succes
} ?>
$ordersID = "";
$result2 = "";
$item2 = "";
$ordersID = $item["id"];
// Get order items from the database
$result2 = $db->query("SELECT i.*, p.product_sku, p.product_id FROM order_items as i LEFT JOIN 0_table_products as p ON p.product_id = i.product_id WHERE i.order_id = '$ordersID'");
if($result2->num_rows > 0){
while($item2 = $result2->fetch_assoc()){
$name = $item2["product_sku_orders"];
$choose_material = $item2['material'];
$check_festi_special = explode('-', $name);
$result_festi_special_0 = $check_festi_special[0];
if ($result_festi_special_0 == 'CR'){
$product_id = $name;
require 'segments/modules/real_image_SRC_festi.php';
$realImageSRC = $image_1_S;
$realImageSAS = $image_2_S;
}else {
require 'segments/modules/real_image_SRC.php';
}
if ($item2["upload_pers"] == "none" or $item2["upload_pers"] == "" ){ ?>
}else {
$item_id = $product_id;
require 'segments/modules/module_Pers_countXY.php';
$x = $x/2.5;
$y = $y/2.5;?>
} ?>
$selected_material = $item2["material"]; ?>
SKU: echo $correct_name; ?>
NUME: echo $name_txt; ?>
Tip: echo $choose_material;?>
( echo $material_explination; ?>)
if($item2["ambalaj"] == 'cadou'){ ?>
Mesaj: echo $item2["cardtext"];
$cadouambalaj = $price*0.1;
if($cadouambalaj < 20) {
$cadouambalajCount = 20;
}else {
$cadouambalajCount = $cadouambalaj;
}
$price = ($price + $cadouambalajCount);
$quantity = $item2["quantity"];
$sub_total = ($price*$quantity);
?>
Ambalaj: echo $item2["ambalaj"].'
'.$cadouambalajCount.'lei'; ?>
}else {
$quantity = $item2["quantity"];
$sub_total = ($price*$quantity);
?>
Ambalaj: echo $item2["ambalaj"]; ?>
} ?>
Margine: echo $item2["margine"]; ?>
Cantitate: echo $item2["quantity"].'
buc'; ?>
Preț: echo $sub_total.'
lei'; ?>
}
}?>
include 'segments/facturaPDF.php'; ?>
}
} else{ ?>
NU au fost găsite comenzi.
} ?>
endif; ?>
if($_SESSION['username'] !== $admin): ?>
ISTORIE DE COMANDĂ
$username = $_SESSION['username'];
$result = $db->query("SELECT * FROM customers INNER JOIN orders ON orders.customer_id = customers.id WHERE customers.user_id = '$username' && orders.status = 'Finalizata' OR customers.user_id = '$username' && orders.status = 'ANULATA' ORDER BY orders.created DESC");
if($result->num_rows > 0){
while($item = $result->fetch_assoc()){
?>
Nume: echo $item["full_name"]; ?>
Email: echo $item["email"]; ?>
Telefon: echo $item["phone"]; ?>
Metode de livrare: echo $item["metodeLivrare"]; ?>
Address: echo $item["address"]; ?>
if($item["old_livrare"] == 'none') { ?>
Cost de livrare: echo $item["livrare"]; ?>
lei
} else {?>
Cost de livrare: echo $item["livrare"]; ?>
Cost de livrare: echo $item["livrare"]; ?>
echo $item["old_livrare"]; ?>lei
Reducere: livrare gratuit!
}?>
if($item["status_promo_code"] == '0' && $item["status2"] !== 'Platit' && $item["status2"] !== 'Transfer Bancar') { ?>
PRET Total: echo $item["grand_total"]; ?>
lei
if($item["promo_code"] == 'none'){$promo_code_alert = 'alert-warning';} else { $promo_code_alert = 'alert-success'; }?>
Promo Code: echo $item["promo_code"]; ?>
}else { ?>
PRET Total: echo $item["grand_total"]; ?>
lei
echo $item["old_grand_total"]; ?>
Reducere: echo $item["discount"]; ?>%
Promo Code: echo $item["promo_code"]; ?> - folosit cu succes
} ?>
$ordersID = "";
$result2 = "";
$item2 = "";
$ordersID = $item["id"];
// Get order items from the database
$result2 = $db->query("SELECT i.*, p.product_sku, p.product_id FROM order_items as i LEFT JOIN 0_table_products as p ON p.product_id = i.product_id WHERE i.order_id = '$ordersID'");
if($result2->num_rows > 0){
while($item2 = $result2->fetch_assoc()){
$name = $item2["product_sku_orders"];
$choose_material = $item2['material'];
$check_festi_special = explode('-', $name);
$result_festi_special_0 = $check_festi_special[0];
if ($result_festi_special_0 == 'CR'){
$product_id = $name;
require 'segments/modules/real_image_SRC_festi.php';
$realImageSRC = $image_1_S;
$realImageSAS = $image_2_S;
}else {
require 'segments/modules/real_image_SRC.php';
}
if ($item2["upload_pers"] == "none" or $item2["upload_pers"] == "" ){ ?>
}else {
$item_id = $product_id;
require 'segments/modules/module_Pers_countXY.php';
$x = $x/2.5;
$y = $y/2.5;?>
} ?>
$selected_material = $item2["material"]; ?>
SKU: echo $correct_name; ?>
NUME: echo $name_txt; ?>
Tip: echo $choose_material;?>
( echo $material_explination; ?>)
if($item2["ambalaj"] == 'cadou'){ ?>
Mesaj: echo $item2["cardtext"];
$cadouambalaj = $price*0.1;
if($cadouambalaj < 20) {
$cadouambalajCount = 20;
}else {
$cadouambalajCount = $cadouambalaj;
}
$price = ($price + $cadouambalajCount);
$quantity = $item2["quantity"];
$sub_total = ($price*$quantity);
?>
Ambalaj: echo $item2["ambalaj"].'
'.$cadouambalajCount.'lei'; ?>
}else {
$quantity = $item2["quantity"];
$sub_total = ($price*$quantity);
?>
Ambalaj: echo $item2["ambalaj"]; ?>
} ?>
Margine: echo $item2["margine"]; ?>
Cantitate: echo $item2["quantity"].'
buc'; ?>
Preț: echo $sub_total.'
lei'; ?>
}
}?>
include 'segments/facturaPDF.php'; ?>
}
} else{ ?>
NU au fost găsite comenzi.
} ?>
endif; ?>
require 'footer.php';
endif;
?>