public function __construct()
{
$this->months = \MyHTML::initMonths();
$this->mongo = Mongo::connect();
$this->conditions = $this->_setConditions();
//$this->middleware('auth');
}
public function getData()
{
$users = User::orderby('name')->get();
return \Datatables::of($users)->addColumn('roles', function ($user) {
$roles_str = "";
foreach ($user->roles as $role) {
$roles_str .= $role->display_name . ",";
}
return trim($roles_str, ",");
})->addColumn('action', function ($user) {
$links = ['Edit' => "/admin/user_edit/{$user->id}", 'Reset Password' => "/admin/user_pass_reset/{$user->id}"];
return \MyHTML::dropdownLinks($links);
})->make(true);
}
public function getData()
{
$printed = \Request::get("printed");
$printed = empty($printed) ? 'NO' : $printed;
$results = LiveData::getResultsList($printed);
return \Datatables::of($results)->addColumn('sample_checkbox', function ($result) {
session(['facility' => $result->facility]);
return "<input type='checkbox' name='samples[]' value={$result->sample_id}>";
})->addColumn('action', function ($result) {
$url = "/result/{$result->sample_id}?printed={$result->printed}";
$links = ['Print preview' => "javascript:windPop('{$url}')", 'Download' => "{$url}&pdf=1"];
return \MyHTML::dropdownLinks($links);
})->make(true);
}
</div>
<div class="col-xs-6">
<table>
<tr>
<td>Repeat Test: </td>
<td><?php
echo MyHTML::boolean_draw($yes_no, $repeated);
?>
</td>
</tr>
<tr>
<td>Sample Rejected: </td>
<td><?php
echo MyHTML::boolean_draw($yes_no, $rejected);
?>
</td>
</tr>
</table>
</div>
</div>
If rejected Reason: <?php
echo $row_rejection_reason;
?>
</div>
<?php
if ($row_verify_outcome != "Rejected") {
?>
<link href="/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css">
<script src="/bootstrap/js/bootstrap.min.js"></script>
<div class="row">
<div class="drop_down_container col-lg-4">
<label for="b">Search worksheet:</label>
<?php
echo MyHTML::text('worksheet', '', array('class' => 'form-control input-sm input_md', 'id' => 'b', 'autocomplete' => 'off'));
?>
<div class='live_drpdwn' id="worksheet_dropdown" style='display:none'></div>
</div>
<div class="drop_down_container col-lg-4">
<label for="s">Search sample:</label>
<?php
echo MyHTML::text('sample', '', array('class' => 'form-control input-sm input_md', 'id' => 's', 'autocomplete' => 'off'));
?>
<div class='live_drpdwn'id="sample_dropdown" style='display:none'></div>
</div>
<div class="form-inline col-lg-4" >
<label>Rejected Samples</label><br>
<input type="text" id="date_rejected" class="form-control input-sm pick_date">
<button id="rjct_such" class="btn btn-primary btn-sm">Search</button>
</div>
</div>
<script type="text/javascript">
private static function districtMonthsInit()
{
$districts = Location\District::districtsArr();
$months = \MyHTML::initMonths();
$ret = [];
foreach ($districts as $dID => $d) {
$ret[$dID] = $months;
}
return $ret;
}
echo MyHTML::hidden('prev_smpl[facilityID]', $smpl_arr['facilityID']);
?>
<?php
echo MyHTML::hidden('prev_smpl[districtID]', $smpl_arr['districtID']);
?>
<?php
echo MyHTML::hidden('prev_smpl[hubID]', $smpl_arr['hubID']);
?>
<?php
echo MyHTML::hidden('prev_smpl[formNumber]', $smpl_arr['formNumber']);
?>
<?php
echo MyHTML::hidden('prev_smpl[lrEnvelopeNumber]', $smpl_arr['lrEnvelopeNumber']);
?>
<?php
echo MyHTML::hidden('prev_smpl[lrNumericID]', $smpl_arr['lrNumericID']);
?>
</td>
</tr>
<tr>
<td style="padding:20px 0px 0px 0px"><a href="/verify/">Return to Samples</a> :: <a href="/dashboard/">Return to Dashboard</a></td>
</tr>
</table>
</form>
<script type="text/javascript">
$(document).ready(function() {
$( ".date-picker" ).datepicker({
changeMonth: true,
changeYear: true,
maxDate: new Date(),
$query=0;
$query=mysqlquery("select f.*,d.district,h.hub from vl_facilities AS f
left join vl_districts AS d on f.districtID=d.id
left join vl_hubs AS h on f.hubID=h.id
where facility!='' order by facility");
$facilities_arr=array();
$facilities_arr2=array();
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
$facilities_arr[$q['id']]=array('district'=>$q['district'],'hub'=>$q['hub'],'hubID'=>$q['hubID'],'districtID'=>$q['districtID']);
$facilities_arr2[$q['id']]=$q['facility'];
}
}
?>
<?php
echo MyHTML::select('facilityID', $facilityID, $facilities_arr2, "select facility", array("id" => "fclty", "onchange" => "getHubDistrict(),loadArtHistory(document.samples.artNumber,document.samples.facilityID.value)"));
?>
<script>
// var z = dhtmlXComboFromSelect("facilityID");
// z.enableFilteringMode(true);
var facilities_json=<?php
echo json_encode($facilities_arr);
?>
;
function getHubDistrict(){
var theFacilityID=document.samples.facilityID.value;
if(!theFacilityID) theFacilityID=$("#facilityID option:selected").val();
//console.log("attempting to get ...");
var f_obj=facilities_json[theFacilityID];
public static function avPositivity2($year = "")
{
if (empty($year)) {
$year = date("Y");
}
$res = Sample::select(\DB::raw("month(date_results_entered) AS mth,count(s.id) AS num"))->from("dbs_samples AS s")->whereYear('s.date_results_entered', '=', $year)->groupby('mth')->get();
$mths_with_p_nrs = Sample::countPositives2($year);
$months = \MyHTML::initMonths();
foreach ($res as $k) {
$ttl_num = $k->num;
$ttl_pos = $mths_with_p_nrs[$k->mth];
$av = $ttl_num > 0 ? $ttl_pos / $ttl_num * 100 : 0;
$months[$k->mth] = round($av, 1);
}
return $months;
}
