93 lines
2.8 KiB
PHP
93 lines
2.8 KiB
PHP
<?php
|
|
|
|
namespace App\Controllers;
|
|
|
|
class Equipment extends BaseController {
|
|
|
|
public function index() {
|
|
$db = \Config\Database::connect();
|
|
return view('equipment_index.php');
|
|
}
|
|
|
|
public function edit($instid) {
|
|
// $data = array();
|
|
// if ($instid != 0) {
|
|
// $db = \Config\Database::connect();
|
|
// $sql = "SELECT * FROM dict_insts where instid='$instid'";
|
|
// $query = $db->query($sql);
|
|
// $results = $query->getResultArray();
|
|
// $data['insts'] = $results;
|
|
// }
|
|
// if ($this->request->getMethod() === 'post') {
|
|
// // $rules = [ 'instname' => 'required' ];
|
|
// // $instname = $this->request->getPost('instname');
|
|
// if($this->validate($rules)){
|
|
// if($instid == 0 ) {
|
|
// $db = \Config\Database::connect();
|
|
// $sql = "insert into dict_insts(instname, createdate) values ('$instname', NOW())";
|
|
// $query = $db->query($sql);
|
|
// return redirect()->to('/insts');
|
|
// } else {
|
|
// $db = \Config\Database::connect();
|
|
// $sql = "update dict_insts set instname='$instname' where instid='$instid'";
|
|
// $query = $db->query($sql);
|
|
// return redirect()->to('/insts');
|
|
// }
|
|
// } else {
|
|
// $data['validation'] = $this->validator;
|
|
// return view('insts_editor',$data);
|
|
// }
|
|
// } else {
|
|
// return view('equipment_editor');
|
|
// }
|
|
|
|
return view('equipment_editor');
|
|
}
|
|
|
|
public function detailInstrumentTest($EquipmentID) {
|
|
|
|
$data['EquipmentID'] = $EquipmentID;
|
|
|
|
$db = \Config\Database::connect();
|
|
|
|
$sql = "SELECT COUNT(*) as testcount
|
|
FROM patres
|
|
WHERE EquipmentID='$EquipmentID'";
|
|
$query = $db->query($sql);
|
|
$results = $query->getResultArray();
|
|
$data['testcount'] = $results[0]['testcount'];
|
|
|
|
$sql = "SELECT DATEDIFF(
|
|
MAX(ResultDateTime),
|
|
MIN(ResultDateTime)) as days,
|
|
MIN(ResultDateTime) as firstdate,
|
|
MAX(ResultDateTime) as lastdate
|
|
FROM patres
|
|
WHERE EquipmentID='$EquipmentID';";
|
|
$query = $db->query($sql);
|
|
$results = $query->getResultArray();
|
|
$data['days'] = $results[0]['days'];
|
|
$data['firstdate'] = $results[0]['firstdate'];
|
|
$data['lastdate'] = $results[0]['lastdate'];
|
|
|
|
$sql = "SELECT YEAR(ResultDateTime) AS year, MONTH(ResultDateTime) AS month, COUNT(*) AS count
|
|
FROM patres
|
|
WHERE EquipmentID = '$EquipmentID'
|
|
GROUP BY YEAR(ResultDateTime), MONTH(ResultDateTime)
|
|
ORDER BY YEAR(ResultDateTime), MONTH(ResultDateTime);";
|
|
$query = $db->query($sql);
|
|
$results = $query->getResultArray();
|
|
$data['counts'] = $results;
|
|
|
|
$sql = "SELECT SampleID,TestTechCode,Result,ResultDateTime,CreateDate FROM patres
|
|
WHERE EquipmentID='$EquipmentID'
|
|
ORDER BY ResultID DESC
|
|
LIMIT 3000";
|
|
$query = $db->query($sql);
|
|
$results = $query->getResultArray();
|
|
$data['testData'] = $results;
|
|
|
|
return view('equipment_detail_test', $data);
|
|
}
|
|
}
|