<?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