<?php
require_once "./includes/initialize.php";
session_start();
if (!isset($_SESSION['smemp'])) {
header("Location: index.php");
exit;
}
$sm_empid = $_SESSION['smemp'];
$conditions = array("WHERE rm.SM_EMP_ID = '{$sm_empid}' GROUP BY rm.BM_EMP_ID ");
$topper = man_power::bmViewStatus4($conditions);
require_once 'header.php';
?>
<script src="jquery-ui.js" type="text/javascript"></script>
<a href="SMDashboard.php"> << Back</a>
<div class="row">
<div class="col-lg-12">
<div class="col-xs-12">
<table class="table table-bordered table-stripped">
<tr style="background: #5BC6DE">
<th>BM Name</th>
<th>Doctor Converted</th>
<th>Health Device Clinic</th>
<th>RCP Drives</th>
<th>No of Rotahaler Changed</th>
<th>RCP Made</th>
</tr>
<?php
if (!empty($topper)) {
session_start();
if (!isset($_SESSION['adminname'])) {
header("Location: index.php");
exit;
}
require_once "../includes/initialize.php";
$SMList = man_power::SMDropdowm();
//$sm_empid = $_POST['SM_Emp_Id'];
$conditions = array(" GROUP BY rm.BM_EMP_ID ");
$BMList = man_power::bmViewStatus4($conditions);
if (isset($_GET['from']) && isset($_GET['to'])) {
$from = $_GET['from'];
$to = $_GET['to'];
$conditions = array(" WHERE DATE_FORMAT(act.created,'%Y-%m-%d') BETWEEN '{$from}' AND '{$to}' ", " GROUP BY rm.BM_EMP_ID ");
$BMList = man_power::bmViewStatus4($conditions);
}
require_once './header.php';
?>
<a href="viewstatus.php"> << Back </a>
<div class="row">
<div class="col-lg-2">
<a download="RespiBMReport.xls" class="btn btn-success" href="#" onclick="return ExcellentExport.excel(this, 'datatable', 'Sheeting');">Export to Excel</a>
</div>
<form action="#" method="get" >
<div class="col-lg-2">
<input type="text" name="from" value="<?php
if (isset($_GET['from'])) {
echo $_GET['from'];
}
