<div class="control-group">
<label class="control-label" for="available">Available Quantity</label>
<div class="controls">
<input type="text" id="available" readonly="readonly" value="<?php
echo $a;
?>
" />
</div>
</div>
<div class="control-group">
<label class="control-label" for="unit_cost">Unit Cost</label>
<div class="controls">
<input type="text" id="unit_cost" name="unit_cost" readonly="readonly" value="<?php
echo DhsHelper::formatPrice($unit_cost);
?>
" />
</div>
</div>
<div class="control-group">
<label class="control-label" for="quantity">Quantity to Return</label>
<div class="controls">
<select id="quantity" name="quantity">
<option>Select Quantity</option>
<?php
for ($i = $a; $i > 0; $i--) {
?>
<option><?php
echo $i;
?>
</td>
<td><?php
echo DhsHelper::formatPrice($row['subtotal']);
?>
</td>
<td><?php
echo DhsHelper::formatDate($row['mfg_date']);
?>
</td>
<td><?php
echo DhsHelper::formatDate($row['expiry_date']);
?>
</td>
<td><?php
echo DhsHelper::formatPrice($row['total']);
?>
</td>
<td>
<?php
if ($a > 0) {
?>
<a href="<?php
echo DHS_ROOT;
?>
index.php?view=return_stock&menu=medicine&medicine_id=<?php
echo $row['medicine_id'];
?>
&inventory_id=<?php
echo $row['inventory_id'];
?>
<a href="#" class="cust_delete" data-source-id="<?php
echo $record['bill_id'];
?>
">
<i class="icon-remove"></i>
</a>
</td>
</tr>
<?php
}
?>
</table>
<div class="well well-small">
<strong>Total Sales: Rs. <?php
echo DhsHelper::formatPrice($con, $total);
?>
</strong>
</div>
<?php
if ($count > 0) {
?>
<div class="pagination text-center">
<ul>
<?php
for ($i = 0; $i < $paginationCount; $i++) {
?>
<li class="<?php
echo $page_id == $i ? 'active' : 'disabled';
?>
<div class="control-group">
<label class="control-label" for="discount">Discount:</label>
<div class="controls">
<input type="text" id="discount" name="discount" placeholder="Discount" value="<?php
echo DhsHelper::formatPrice($record['discount']);
?>
" readonly="readonly" />Rs.
</div>
</div>
<div class="control-group">
<label class="control-label" for="total">Total:</label>
<div class="controls">
<input type="text" id="total" name="total" placeholder="Total" value="<?php
echo DhsHelper::formatPrice($record['total']);
?>
" readonly="readonly">Rs.
</div>
</div>
<div class="control-group">
<label class="control-label" for="mfg_date">Manufactured Date:</label>
<div class="controls">
<input type="text" id="mfg_date" name="mfg_date" placeholder="Manufactured Date" value="<?php
echo DhsHelper::formatDate($record['mfg_date']);
?>
" readonly="readonly" />
</div>
</div>
<div class="control-group"> <label class="control-label" for="discount">Discount:</label> <div class="controls"> <input type="text" name="discount" required="" value="<?php echo DhsHelper::formatPrice($inventory['discount']); ?> "> </div> </div> <div class="control-group"> <label class="control-label" for="total">Total:</label> <div class="controls"> <input type="text" name="total" required="" value="<?php echo DhsHelper::formatPrice($inventory['total']); ?> " readonly="readonly"> </div> </div> <div class="control-group"> <label class="control-label" for="mfg_date">Manufacturing Date:</label> <div class="controls"> <div class="input-append dhs-datetimepicker" style="margin-bottom: 0;"> <input data-format="yyyy-MM-dd" type="text" name="mfg_date" id="mfg_date" required="" value="<?php echo $inventory['mfg_date']; ?> "></input> <span class="add-on"> <i data-time-icon="icon-time" data-date-icon="icon-calendar">
<td><?php
echo $row['doctor_name'];
?>
</td>
<td><?php
echo $row['mobile'];
?>
</td>
<td>
<?php
$sql = "select sum(`total`) as income, `doctor_name`, `store_key` from `cust_inventory` group by `doctor_name` having `store_key` = '{$store_key}' and `doctor_name` = " . "'" . $row['doctor_name'] . "'";
//echo $sql;
$inc = mysqli_query($con, $sql);
$income = mysqli_fetch_array($inc);
echo DhsHelper::formatPrice($income['income']);
?>
</td>
<td>
<a href="index.php?view=doctor_registration&menu=user&doctor_id=<?php
echo $row['doctor_id'];
?>
">
<i class="icon-edit"></i>
</a>
<a href="index.php?view=manage_doctor&action=delete_doctor&doctor_id=<?php
echo $row['doctor_id'];
?>
" onclick="javascript:void(0)">
<i class="icon-remove"></i>
</a>
public function inventory_details($request)
{
$compulsory = array('storeid', 'medicine_id');
$data = self::processRequestData($request, $compulsory, array());
if (!is_array($data)) {
return array('success_code' => '404', 'result' => $data);
}
$store_key = $data['storeid'];
$medicine_id = $data['medicine_id'];
$result = mysqli_query($con, "select medicine.medicine_name, inventory.* from `medicine` inner join\n\t\t\t\t(select * from inventory where `store_key` = '{$store_key}' and status = 30 and medicine_id = {$medicine_id}) as inventory \n\t\t\t\ton (medicine.`medicine_id` = inventory.`medicine_id`)");
$inventory = array();
while ($row = mysqli_fetch_array($result)) {
$barcode = $row['barcode'];
$sql = 'SELECT ';
$sql .= '( ';
$sql .= "(select COALESCE(`quantity`, 0) from `inventory` where `barcode` = {$barcode} and status = " . DHS_DISTRIBUTOR_INVENTORY_STATUS_VERIFIED . ") ";
$sql .= " - ";
$sql .= "(select COALESCE(sum(`quantity`), 0) as quantity from `cust_inventory` where `barcode` = {$barcode}) ";
$sql .= ' - ';
$sql .= "(select COALESCE(sum(`quantity`), 0) as quantity from `return_stock` where `barcode` = {$barcode} and status <> 0) ";
$sql .= ') as remaining';
$res = mysqli_query($con, $sql);
$rem = mysqli_fetch_array($res);
$i['available_quantity'] = $rem['remaining'];
$i['medicine_name'] = $row['medicine_name'];
$i['barcode'] = $row['barcode'];
$i['unit_cost'] = DhsHelper::formatPrice($row['unit_cost']);
$i['subtotal'] = DhsHelper::formatPrice($row['subtotal']);
$i['mfg_date'] = DhsHelper::formatDate($row['mfg_date']);
$i['expiry_date'] = DhsHelper::formatDate($row['expiry_date']);
$i['total'] = DhsHelper::formatPrice($row['total']);
$i['medicine_id'] = $row['medicine_id'];
$i['distributor_id'] = $row['distributor_id'];
$i['inventory_id'] = $row['inventory_id'];
$inventory[] = $i;
}
return array('success_code' => '200', 'result' => $inventory);
}
$que = $que1 . $que2;
$arr = array();
/* execute multi query */
if (mysqli_multi_query($con, $que)) {
do {
/* store first result set */
if ($result = mysqli_store_result($con)) {
while ($row = mysqli_fetch_row($result)) {
$arr[] = $row[0];
}
mysqli_free_result($result);
}
} while (mysqli_next_result($con));
}
echo ' TOTAL : ' . DhsHelper::formatPrice($con, $arr[0] == null ? 0 : $arr[0]);
echo '<br/>TODAY : ' . DhsHelper::formatPrice($con, $arr[1] == null ? 0 : $arr[1]);
?>
</div>
</div>
</div>
</a>
</div>
<div class="span2" style="background-color: #6B00B2;">
<a class="enabled" href="<?php
echo DHS_ROOT;
?>
index.php?view=paid_bills&menu=distributor">
<div class="thumbnail text-center admin-dashboard-stats-box" style="height:150px; color:#fff">
<div style="margin-top:5px;">
<strong><span style="font-size:1.25em;"> Vendor</span></strong><hr/>
<div class="row-fluid"> <div class="span8" style="text-align: right;">Tax</div> <div class="span4" style="text-align: right;"><?php echo ' Rs.' . DhsHelper::formatPrice($con, $billing[3]); ?> </div> </div> <div class="row-fluid"> <div class="span8" style="text-align: right;">Discount</div> <div class="span4" style="text-align: right;"><?php echo ' Rs.' . DhsHelper::formatPrice($con, $billing[4]); ?> </div> </div> <hr style="margin:0px; margin-bottom:10px;"> <div class="row-fluid"> <div class="span8" style="text-align: right;">Total</div> <div class="span4" style="text-align: right;"><?php echo ' Rs.' . DhsHelper::formatPrice($con, $billing[5]); ?> </div> </div> </div> </div> </body> </html>
?>
</td>
<td><?php
echo $record['quantity'];
?>
</td>
<td><?php
echo DhsHelper::formatPrice($record['purchased_price']);
?>
</td>
<td><?php
echo DhsHelper::formatPrice($record['returning_total']);
?>
</td>
<td><?php
echo DhsHelper::formatPrice($record['loss']);
?>
</td>
<td><?php
echo $record['return_date'];
?>
</td>
<td><?php
echo $users_list[$record['returned_by']];
?>
</td>
</tr>
<?php
}
?>
</tbody>
<div class="row-fluid"> <div class="span8" style="text-align: right;">Tax</div> <div class="span4" style="text-align: right;"><?php echo DhsHelper::formatPrice($billing[3]) . ' Rs'; ?> </div> </div> <div class="row-fluid"> <div class="span8" style="text-align: right;">Discount</div> <div class="span4" style="text-align: right;"><?php echo DhsHelper::formatPrice($billing[4]) . ' Rs'; ?> </div> </div> <hr style="margin:0px; margin-bottom:10px;"> <div class="row-fluid"> <div class="span8" style="text-align: right;">Total</div> <div class="span4" style="text-align: right;"><?php echo DhsHelper::formatPrice($billing[5]) . ' Rs'; ?> </div> </div> </div> </div> </body> </html>
echo DhsHelper::formatPrice($con, $row['salary']);
?>
</td>
<td><?php
echo $row['month'];
?>
</td>
<td><?php
echo $row['year'];
?>
</td>
<td><?php
echo $row['present_days'];
?>
</td>
<td><?php
echo $row['absent_days'];
?>
</td>
<td><?php
echo DhsHelper::formatPrice($con, $row['actual_payment']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</fieldset>
