87 lines
4.0 KiB
PHP
87 lines
4.0 KiB
PHP
<?php
|
|
|
|
include ('pdf_header_reverse.php');?>
|
|
|
|
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
|
|
|
|
<body>
|
|
<br><br>
|
|
<table width="100%">
|
|
<tr>
|
|
<div style="font-size: 12px">
|
|
<td width="25%" align="left"> Run Date : <?php echo date("d-M-Y"); ?></td>
|
|
<td width="50%" align="center" style="font-size: 30px"><strong>Stock
|
|
Issue Report</strong></td>
|
|
<td width="25%" align="left"> User : <?php echo $username ?></td>
|
|
<?php if(isset($from_date) && isset($to_date)){?>
|
|
<td width="25%" align="right"> Range : <?php echo $from_date; ?> to <?php echo $to_date ;?></td>
|
|
<?php }?>
|
|
</tr>
|
|
</table>
|
|
<br><br><br>
|
|
<table width="100%" border="1">
|
|
<tr>
|
|
<th width="2%" align="left">Sr</th>
|
|
|
|
<th align="left" width="30%">Item</th>
|
|
<th align="left" width="10%">Batch No</th>
|
|
<th width="10%" align="left">Stock qty</th>
|
|
<th width="10%" align="left">Issue qty</th>
|
|
|
|
|
|
</tr>
|
|
<?php
|
|
|
|
$from_date = $_REQUEST['startDate2'];
|
|
$to_date = $_REQUEST['endDate2'];
|
|
/*$sql_stock = "select * from appointment_stock_history ash inner join employee_appointment ep on ep.appointment_id=ash.appointment_id order by ep.appointment_date DESC ";
|
|
if(isset($from_date) && isset($to_date)){
|
|
$sql_stock="select * from appointment_stock_history ash inner join employee_appointment ep on ep.appointment_id=ash.appointment_id where
|
|
date_format(date(ep.appointment_date),'%Y-%m-%d') between STR_TO_DATE('".$from_date."', '%d-%m-%Y') AND STR_TO_DATE('".$to_date."', '%d-%m-%Y') order by ep.appointment_date DESC ";
|
|
|
|
}
|
|
$results_stock = mysqli_query($conn,$sql_stock);
|
|
$count = 0;
|
|
while ($row_stock = mysqli_fetch_array($results_stock)) {
|
|
// $issue_date=$row_stock[];
|
|
$item_desc = getTableFieldValue('tbl_items', 'item_name', 'item_id', $row_stock['item_id']);
|
|
$emp_id = getTableFieldValue('employee_appointment', 'emp_id', 'appointment_id', $row_stock['appointment_id']);
|
|
$issue_datetime = getTableFieldValue('employee_appointment', 'appointment_date', 'appointment_id', $row_stock['appointment_id']);
|
|
$issue_date = new DateTime($issue_datetime);
|
|
|
|
$employee_name = getTableFieldValue('employee', "CONCAT(fname, ' ', lname)", 'id', $emp_id);
|
|
$issue_qty = $row_stock['issued_qty'];
|
|
// $employee_name=$row_stock[];
|
|
$issue_price = $row_stock['price'];
|
|
?><tr>
|
|
<td><?php echo ++$count?></td>
|
|
<td><?php echo $issue_date->format('d/m/Y');?></td>
|
|
<td><?php echo $item_desc?></td>
|
|
<td><?php echo $employee_name?></td>
|
|
<td><?php echo $issue_qty?></td>
|
|
<td><?php echo $issue_price?></td>
|
|
</tr><?php
|
|
}*/
|
|
$count = 0;
|
|
$sql_stock_issue="SELECT sum(issue_qty) as total_qty,item_id,item_batch_no FROM `stock_issue_items` a inner join stock_issue b on a.stock_issue_id=b.stock_issue_id where b.issue_date between STR_TO_DATE('".$from_date."', '%d-%m-%Y') AND STR_TO_DATE('".$to_date."', '%d-%m-%Y') and a.issue_ohc_type_id='".$_SESSION['current_ohcttype']."' and a.item_id in (SELECT item_id from tbl_items) group by item_id,item_batch_no ";
|
|
$results_stock_issue = mysqli_query($conn,$sql_stock_issue);
|
|
while ($row_stock_issue = mysqli_fetch_array($results_stock_issue)) {
|
|
$item_desc = getTableFieldValue('tbl_items', 'item_name', 'item_id', $row_stock_issue['item_id']);
|
|
$stock_qty = getTableFieldValue('item_stock', 'stock_qty', 'item_id', $row_stock_issue['item_id'],'item_batch_no',"'".$row_stock_issue['item_batch_no']."'" );
|
|
?><tr>
|
|
<td><?php echo ++$count?></td>
|
|
<td><?php echo $item_desc?></td>
|
|
<td><?php echo $row_stock_issue['item_batch_no'];?></td>
|
|
<td><?php echo $stock_qty?></td>
|
|
<td><?php echo $row_stock_issue['total_qty']?></td>
|
|
|
|
</tr><?php
|
|
|
|
}
|
|
|
|
?>
|
|
|
|
</table>
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|