<?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']; }