<?php
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::bmViewStatus2($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::bmViewStatus2($conditions);
}
require_once './header.php';
?>
<a href="viewstatus.php"> << Back </a>
<div class="row">
<div class="col-lg-2">
<a download="BreathefreeBMReport.xls" class="btn btn-success" href="#" onclick="return ExcellentExport.excel(this, 'datatable', 'Sheeting');">Export to Excel</a>
<!-- <input type="button" value="Export" id="export">-->
</div>
<form action="#" method="get" >
<div class="col-lg-2">
<input type="text" name="from" value="<?php
if (isset($_GET['from'])) {
<?php
session_start();
if (!isset($_SESSION['adminname'])) {
header("Location: index.php");
exit;
}
require_once "../includes/initialize.php";
$SMList = man_power::SMDropdowm();
if (isset($_GET['SM_Emp_Id'])) {
$sm_empid = $_GET['SM_Emp_Id'];
$SMList = man_power::SMDropdowm($sm_empid);
$conditions = array("WHERE rm.SM_EMP_ID = '{$sm_empid}' GROUP BY rm.BM_EMP_ID ");
$BMList = man_power::bmViewStatus2($conditions);
//var_dump($BMList);
}
if (isset($_GET['allIndia'])) {
//$sm_empid = $_POST['SM_Emp_Id'];
$conditions = array(" GROUP BY rm.BM_EMP_ID ");
$BMList = man_power::bmViewStatus2($conditions);
}
require_once './header.php';
?>
<a href="adminDashBoard.php"> << Back </a> <a href="BMreport.php" class="pull-right badge">GET BM REPORT</a>
<div class="col-lg-12 col-sm-12 col">
<div class="col-xs-12">
<form action="viewStatus.php" method="GET">
<div class="form-group">
<label class="control-label">Select SM</label>
<select class="form-control" onchange="this.form.submit()" name="SM_Emp_Id">
<?php
