/**
* Display a test((un)grouped) and specimen((un)grouped) counts.
*
*/
public function countReports()
{
$date = date('Y-m-d');
$from = Input::get('start');
if (!$from) {
$from = date('Y-m-01');
}
$to = Input::get('end');
if (!$to) {
$to = $date;
}
$toPlusOne = date_add(new DateTime($to), date_interval_create_from_date_string('1 day'));
$counts = Input::get('counts');
$accredited = array();
// Begin grouped test counts
if ($counts == trans('messages.grouped-test-counts')) {
$testCategories = TestCategory::all();
$testTypes = TestType::all();
$ageRanges = array('0-5', '5-15', '15-120');
// Age ranges - will definitely change in configurations
$gender = array(Patient::MALE, Patient::FEMALE);
// Array for gender - male/female
$perAgeRange = array();
// array for counts data for each test type and age range
$perTestType = array();
// array for counts data per testype
if (strtotime($from) > strtotime($to) || strtotime($from) > strtotime($date) || strtotime($to) > strtotime($date)) {
Session::flash('message', trans('messages.check-date-range'));
}
foreach ($testTypes as $testType) {
$countAll = $this->getGroupedTestCounts($testType, null, null, $from, $toPlusOne->format('Y-m-d H:i:s'));
$countMale = $this->getGroupedTestCounts($testType, [Patient::MALE], null, $from, $toPlusOne->format('Y-m-d H:i:s'));
$countFemale = $this->getGroupedTestCounts($testType, [Patient::FEMALE], null, $from, $toPlusOne->format('Y-m-d H:i:s'));
$perTestType[$testType->id] = ['countAll' => $countAll, 'countMale' => $countMale, 'countFemale' => $countFemale];
foreach ($ageRanges as $ageRange) {
$maleCount = $this->getGroupedTestCounts($testType, [Patient::MALE], $ageRange, $from, $toPlusOne->format('Y-m-d H:i:s'));
$femaleCount = $this->getGroupedTestCounts($testType, [Patient::FEMALE], $ageRange, $from, $toPlusOne->format('Y-m-d H:i:s'));
$perAgeRange[$testType->id][$ageRange] = ['male' => $maleCount, 'female' => $femaleCount];
}
}
return view('reports.counts.groupedTestCount')->with('testCategories', $testCategories)->with('ageRanges', $ageRanges)->with('gender', $gender)->with('perTestType', $perTestType)->with('perAgeRange', $perAgeRange)->with('accredited', $accredited)->withInput(Input::all());
} else {
if ($counts == trans('messages.ungrouped-specimen-counts')) {
if (strtotime($from) > strtotime($to) || strtotime($from) > strtotime($date) || strtotime($to) > strtotime($date)) {
Session::flash('message', trans('messages.check-date-range'));
}
$ungroupedSpecimen = array();
foreach (SpecimenType::all() as $specimenType) {
$rejected = $specimenType->countPerStatus([Specimen::REJECTED], $from, $toPlusOne->format('Y-m-d H:i:s'));
$accepted = $specimenType->countPerStatus([Specimen::ACCEPTED], $from, $toPlusOne->format('Y-m-d H:i:s'));
$total = $rejected + $accepted;
$ungroupedSpecimen[$specimenType->id] = ["total" => $total, "rejected" => $rejected, "accepted" => $accepted];
}
// $data = $data->groupBy('test_type_id')->paginate(Config::get('kblis.page-items'));
return view('reports.counts.ungroupedSpecimenCount')->with('ungroupedSpecimen', $ungroupedSpecimen)->with('accredited', $accredited)->withInput(Input::all());
} else {
if ($counts == trans('messages.grouped-specimen-counts')) {
$ageRanges = array('0-5', '5-15', '15-120');
// Age ranges - will definitely change in configurations
$gender = array(Patient::MALE, Patient::FEMALE);
// Array for gender - male/female
$perAgeRange = array();
// array for counts data for each test type and age range
$perSpecimenType = array();
// array for counts data per testype
if (strtotime($from) > strtotime($to) || strtotime($from) > strtotime($date) || strtotime($to) > strtotime($date)) {
Session::flash('message', trans('messages.check-date-range'));
}
$specimenTypes = SpecimenType::all();
foreach ($specimenTypes as $specimenType) {
$countAll = $specimenType->groupedSpecimenCount([Patient::MALE, Patient::FEMALE], null, $from, $toPlusOne->format('Y-m-d H:i:s'));
$countMale = $specimenType->groupedSpecimenCount([Patient::MALE], null, $from, $toPlusOne->format('Y-m-d H:i:s'));
$countFemale = $specimenType->groupedSpecimenCount([Patient::FEMALE], null, $from, $toPlusOne->format('Y-m-d H:i:s'));
$perSpecimenType[$specimenType->id] = ['countAll' => $countAll, 'countMale' => $countMale, 'countFemale' => $countFemale];
foreach ($ageRanges as $ageRange) {
$maleCount = $specimenType->groupedSpecimenCount([Patient::MALE], $ageRange, $from, $toPlusOne->format('Y-m-d H:i:s'));
$femaleCount = $specimenType->groupedSpecimenCount([Patient::FEMALE], $ageRange, $from, $toPlusOne->format('Y-m-d H:i:s'));
$perAgeRange[$specimenType->id][$ageRange] = ['male' => $maleCount, 'female' => $femaleCount];
}
}
return view('reports.counts.groupedSpecimenCount')->with('specimenTypes', $specimenTypes)->with('ageRanges', $ageRanges)->with('gender', $gender)->with('perSpecimenType', $perSpecimenType)->with('perAgeRange', $perAgeRange)->with('accredited', $accredited)->withInput(Input::all());
} else {
if (strtotime($from) > strtotime($to) || strtotime($from) > strtotime($date) || strtotime($to) > strtotime($date)) {
Session::flash('message', trans('messages.check-date-range'));
}
$ungroupedTests = array();
foreach (TestType::all() as $testType) {
$pending = $testType->countPerStatus([Test::PENDING, Test::STARTED], $from, $toPlusOne->format('Y-m-d H:i:s'));
$complete = $testType->countPerStatus([Test::COMPLETED, Test::VERIFIED], $from, $toPlusOne->format('Y-m-d H:i:s'));
$ungroupedTests[$testType->id] = ["complete" => $complete, "pending" => $pending];
}
// $data = $data->groupBy('test_type_id')->paginate(Config::get('kblis.page-items'));
return view('reports.counts.ungroupedTestCount')->with('ungroupedTests', $ungroupedTests)->with('accredited', $accredited)->withInput(Input::all());
}
}
}
}