46 lines
1.9 KiB
PHP
46 lines
1.9 KiB
PHP
|
|
<?php
|
|
|
|
|
|
?>
|
|
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
|
|
//include('pop_up_top.php');
|
|
?>
|
|
|
|
<body>
|
|
<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:40px"><strong>Stock Report</strong></td>
|
|
<td width="25%" align="left"> User : <?php echo $username ?></td>
|
|
</tr>
|
|
</table>
|
|
<table width="100%" border="1" >
|
|
<tr><th width="2%" align="left">Sr </th><th align="left" width="50%">Brand Name </th>
|
|
<th align="left" width="10%">Basic Rate</th>
|
|
<th align="left" width="10%">Expiry Date</th>
|
|
<th align="left" width="10%">Openeing Balance</th><th align="left" width="10%">Received</th>
|
|
</tr>
|
|
<?php
|
|
|
|
/*$sql_stock="select distinct(a.item_id) from appointment_stock_history a inner join employee_appointment b on a.appointment_id=b.appointment_id where date(appointment_date) between '".date("Y-m-d", strtotime($_REQUEST['startDate1']))."' and '".date("Y-m-d", strtotime($_REQUEST['endDate1']))."' ";
|
|
$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']);
|
|
// $issue_qty=getTableFieldValue('appointment_stock_history','issued_qty','item_id',$row_stock['item_id']);
|
|
$sql_qty_sum="select sum(a.issued_qty) as total_sum from appointment_stock_history a inner join employee_appointment b on a.appointment_id=b.appointment_id where item_id='".$row_stock['item_id']."' and date(appointment_date) between '".date("Y-m-d", strtotime($_REQUEST['startDate1']))."' and '".date("Y-m-d", strtotime($_REQUEST['endDate1']))."' ";
|
|
$results_qty_sum=mysqli_query($conn,$sql_qty_sum);
|
|
$row_qty_sum=mysqli_fetch_array($results_qty_sum);*/
|
|
|
|
|
|
?>
|
|
|
|
|
|
</table>
|