301 lines
12 KiB
PHP
301 lines
12 KiB
PHP
<?php
|
|
include 'dbconfig.php';
|
|
require("phpmailer/class.phpmailer.php");
|
|
date_default_timezone_set('America/Chicago');
|
|
// $dateToday = date('Y-m-d');
|
|
// $dateToday = '2019-08-29';
|
|
$dateToday = $_GET['d'];
|
|
$dateTimeToday = date("Y-m-d H:i:s");
|
|
|
|
|
|
function getSubItem($date){
|
|
|
|
include 'dbconfig.php';
|
|
|
|
$q = $conn->prepare("SELECT t.StoreName, o.ProductId, o.FormUsed, o.ProductName, o.Name, o.Number, o.Size, o.JerseySize, o.ShortsSize, o.Price, o.Quantity, (o.Price * o.Quantity) AS TotalPrice, ((o.Price * o.Quantity) * 0.10) AS Tax,
|
|
o.DateCreated, pd.InvoiceNumber, pd.Payer_Email FROM orders AS o
|
|
INNER JOIN payment_details AS pd ON pd.CartKey = o.CartKey
|
|
INNER JOIN teamstores AS t ON t.Id = o.StoreId
|
|
WHERE o.DateCreated BETWEEN '$date 00:00:00' AND '$date 23:59:00'
|
|
ORDER BY o.DateCreated ASC, o.Number ASC");
|
|
|
|
$q->execute();
|
|
$result = $q->fetchAll();
|
|
|
|
return $result;
|
|
}
|
|
|
|
function getItemImages($pid){
|
|
|
|
include 'dbconfig.php';
|
|
|
|
$q = $conn->prepare("SELECT * FROM teamstore_product_thumbnails WHERE ProductId = :pid ORDER BY Ordering ASC");
|
|
|
|
$q->execute(array(':pid'=>$pid));
|
|
$result = $q->fetchAll();
|
|
|
|
return $result;
|
|
}
|
|
|
|
$array_orders = getSubItem($dateToday);
|
|
// var_dump(getItemImages(88));
|
|
|
|
?>
|
|
<!doctype html>
|
|
<html>
|
|
|
|
<head>
|
|
<meta name="viewport" content="width=device-width" />
|
|
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
|
|
<title>Order Details</title>
|
|
<link rel="stylesheet" href="styles.css">
|
|
|
|
</head>
|
|
|
|
<body class="" onload="window.print()">
|
|
|
|
<table role="presentation" border="0" cellpadding="0" cellspacing="0" class="body">
|
|
<tr>
|
|
<td> </td>
|
|
<td class="container">
|
|
<div class="content">
|
|
<!-- START CENTERED WHITE CONTAINER -->
|
|
<table role="presentation" class="main">
|
|
<!-- START MAIN CONTENT AREA -->
|
|
<tr>
|
|
<td class="wrapper">
|
|
<table role="presentation" border="0" cellpadding="0" cellspacing="0">
|
|
<tr>
|
|
<td>
|
|
<h3 class="align-center" style="font-size: 15px;"><b>Daily Reports <?php echo $dateToday ?></b></h3>
|
|
<br>
|
|
<?php
|
|
$q = $conn->prepare("SELECT t.StoreName, o.ProductId, o.FormUsed, o.ProductName, o.NAME, o.NUMBER, o.Size, o.JerseySize, o.ShortsSize, o.Price, o.Quantity, (o.Price * o.Quantity) AS TotalPrice, ((o.Price * o.Quantity) * 0.10) AS Tax,
|
|
o.DateCreated, pd.InvoiceNumber, pd.Payer_Email FROM orders AS o
|
|
INNER JOIN payment_details AS pd ON pd.CartKey = o.CartKey
|
|
INNER JOIN teamstores AS t ON t.Id = o.StoreId
|
|
WHERE o.DateCreated BETWEEN '$dateToday 00:00:00' AND '$dateToday 23:59:00'
|
|
GROUP BY o.ProductId
|
|
ORDER BY o.DateCreated");
|
|
$q->execute();
|
|
$result = $q->rowCount();
|
|
|
|
if($result > 0){
|
|
while ($row = $q->fetch()) {
|
|
?>
|
|
<div class="items-parent" style="border: 1px solid #e2e2e2; padding: 10px; margin-bottom: 10px;">
|
|
<table class="items" role="presentation" border="0" cellpadding="0" cellspacing="0">
|
|
<tbody>
|
|
<tr>
|
|
<td>
|
|
<h2><b>Store: </b></h2>
|
|
</td>
|
|
<td>
|
|
<h2><?php echo $row['StoreName'] ?></h2>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2">
|
|
<div style="font-size: 12px;">
|
|
<a href="#"><?php echo $row['ProductName'] ?></a>
|
|
</div>
|
|
<div style="text-align: center;">
|
|
<?php
|
|
$itemImages = getItemImages($row['ProductId']);
|
|
foreach($itemImages as $thumb_key => $thumb_val){
|
|
echo '<img style="height: 150px; overflow: hidden; object-fit: contain;" src="https://crewsportswear.app:5955/'.$thumb_val['Image'].'"> ';
|
|
}
|
|
?>
|
|
</div>
|
|
<table id="tbl_subitem"class="table table-condensed table-bordered" style="width: 100%; border-collapse: collapse;">
|
|
<?php if($row['FormUsed']=="jersey-and-shorts-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<td><b>Name</b></td>
|
|
<td><b>Number</b></td>
|
|
<td><b>Jersey Size</b></td>
|
|
<td><b>Shorts Size</b></td>
|
|
<td><b>Quantity</b></td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="tshirt-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<td><b>Size</b></td>
|
|
<td><b>Quantity</b></td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="quantity-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<td>Quantity</b></td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="name-number-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<td><b>Name</b></td>
|
|
<td><b>Number</b></td>
|
|
<td><b>Quantity</b></td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="name-number-size-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<th>Name</th>
|
|
<th>Number</th>
|
|
<th>Size</th>
|
|
<th>Quantity</th>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="number-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<th>Number</th>
|
|
<th>Quantity</th>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="name-name2-size-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<td>Gamer Tag</td>
|
|
<td>Name</td>
|
|
<td>Size</td>
|
|
<td>Quantity</td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="name-size-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<th>Name</th>
|
|
<th>Size</th>
|
|
<th>Quantity</th>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="jersey-and-shorts-quantity-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<th>Jersey Size</th>
|
|
<th>Shorts Size</th>
|
|
<th>Quantity</th>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="number-jersey-shorts-form"){ ?>
|
|
<tr>
|
|
<td><b>#</b></td>
|
|
<td><b>Number</b></td>
|
|
<td><b>Jersey Size</b></td>
|
|
<td><b>Shorts Size</b></td>
|
|
<td><b>Quantity</b></td>
|
|
</tr>
|
|
<?php }else{ /* else */ }
|
|
|
|
$i=1;
|
|
|
|
foreach($array_orders as $key => $val){
|
|
if($val['ProductId'] == $row['ProductId']){
|
|
if($row['FormUsed']=="jersey-and-shorts-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?></td>
|
|
<td><?php echo ($val['Name'] !== "") ? : '--' ?></td>
|
|
<td><?php echo $val['Number'] ?> </td>
|
|
<td><?php echo $val['JerseySize'] ?> </td>
|
|
<td><?php echo $val['ShortsSize'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="tshirt-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?> </td>
|
|
<td><?php echo $val['Size'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="quantity-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="name-number-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?> </td>
|
|
<td><?php echo $val['Name'] ?> </td>
|
|
<td><?php echo $val['Number'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="name-number-size-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?> </td>
|
|
<td><?php echo $val['Name'] ?> </td>
|
|
<td><?php echo $val['Number'] ?> </td>
|
|
<td><?php echo $val['Size'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="number-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?> </td>
|
|
<td><?php echo $val['Number'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="name-name2-size-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?> </td>
|
|
<td><?php echo $val['Name'] ?> </td>
|
|
<td><?php echo $val['Name2'] ?> </td>
|
|
<td><?php echo $val['Size'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="name-size-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?> </td>
|
|
<td><?php echo $val['Name'] ?> </td>
|
|
<td><?php echo $val['Size'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="jersey-and-shorts-quantity-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?> </td>
|
|
<td><?php echo $val['JerseySize'] ?> </td>
|
|
<td><?php echo $val['ShortsSize'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }elseif($row['FormUsed']=="number-jersey-shorts-form"){ ?>
|
|
<tr>
|
|
<td><?php echo $i++ ?></td>
|
|
<td><?php echo $val['Number'] ?> </td>
|
|
<td><?php echo $val['JerseySize'] ?> </td>
|
|
<td><?php echo $val['ShortsSize'] ?> </td>
|
|
<td><?php echo $val['Quantity'] ?> </td>
|
|
</tr>
|
|
<?php }else{ /* else */ }
|
|
}
|
|
} ?>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<?php
|
|
}
|
|
}
|
|
?>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
<!-- END MAIN CONTENT AREA -->
|
|
</table>
|
|
<!-- END CENTERED WHITE CONTAINER -->
|
|
|
|
<!-- START FOOTER -->
|
|
<div class="footer">
|
|
<table role="presentation" border="0" cellpadding="0" cellspacing="0">
|
|
<tr>
|
|
<td class="content-block">
|
|
<span class="apple-link">Copyright © 2019 <a
|
|
href="https://crewsportswear.com">crewsportswear.com</a>. All rights
|
|
reserved.</span>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
<!-- END FOOTER -->
|
|
</div>
|
|
</td>
|
|
<td> </td>
|
|
</tr>
|
|
</table>
|
|
</body>
|
|
|
|
</html>
|