public function showChart()
{
$testID = Input::get('test');
$test = Test::find($testID)->name;
$data = array('test' => $test);
return View::make('chart', $data);
}
function delete_delete($data)
{
$sql = Test::find($data->id);
$retorno = $sql->to_json();
$sql->delete();
return '{"result": [' . $retorno . ']}';
}
/**
* Show the form for editing the specified resource.
* GET /medications/{id}/edit
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$test_items = Billing::select('id', 'item')->where('type', '=', 'Laboratory Test')->get();
$prescription_items = Billing::select('id', 'item')->where('type', '=', 'Medication')->get();
$medication = Medication::find($id);
$test = Test::find($id);
return View::make('medications.edit', compact('medication', 'test_items', 'prescription_items', 'test'));
}
function test_find_all_returns_array()
{
# create two test entries to be found
Test::create(array("dummy" => "Test 1"), array("dummy" => "Test 2"));
$result = Test::find_all(array("conditions" => "id = 1"));
$this->assertTrue(is_array($result));
$this->assertEqual(count($result), 1);
$result = Test::find("all", array("conditions" => array("id = ?", 2)));
$this->assertTrue(is_array($result));
$this->assertEqual(count($result), 1);
}
function test_has_many_with_preloaded_data()
{
setup_sqlite_test_db();
preload_sqlite_data();
$test1 = Test::find(1);
$results1 = $test1->test_results;
$this->assertEqual(count($results1), 1);
$test2 = Test::find(2);
$results2 = $test2->test_results;
$this->assertEqual(count($results2), 2);
}
public function delete_destroy($id)
{
$test = Test::find($id);
if (!$test) {
return Response::error('404');
} else {
if ($test->destroy_if_user_can(Auth::user()->id)) {
return Redirect::to_route('test_list')->with('success', 'Test deleted.');
} else {
return Response::error('403');
}
}
}
/**
* Display one result
*
* @param $id
* @param $rid
*/
public function showAction($id, $rid)
{
$test = Test::find($id);
if (is_null($test)) {
return Redirect::route('tests.index')->with('error', 'Incorrect test id');
}
$single = Result::find($rid);
if (is_null($single) || $single->test_id != $id) {
return Redirect::route('tests.index')->with('error', 'Невозможно найти результаты');
}
$results = Result::where('test_id', $id)->where('token', $single->token)->orderBy('question_id', 'asc')->get();
if (!count($results)) {
return Redirect::route('tests.index')->with('error', 'Отсутствуют результаты теста');
}
$score = 0;
$max = 0;
foreach ($results as $result) {
$score += $result->weight;
if ($max < $result->created_at->format('U')) {
$max = $result->created_at->format('U');
}
}
$weights = [];
$tw = 0;
foreach ($test->questions as $q) {
$weights[$q->id] = 0;
foreach ($q->answers as $a) {
if (!$a->is_correct) {
continue;
}
$weights[$q->id] += $a->weight;
$tw += $a->weight;
}
if ($q->type == Question::TYPE_STRING) {
$weights[$q->id] += 1;
$tw += 1;
}
}
$token = Token::where('token', $result->token)->get();
$ends = $max - $token[0]->start;
$min = (int) ($ends / 60);
$sec = $ends - $min * 60;
$ends = ($min < 10 ? '0' . $min : $min) . ':' . ($sec < 10 ? '0' . $sec : $sec);
return View::make('tests.results_show', ['token' => Token::where('token', $single->token)->get()[0], 'test' => $test, 'total_questions' => count($test->questions), 'total_weight' => $tw, 'results' => $results, 'weights' => $weights, 'score' => $score, 'duration' => $ends]);
}
function test_create()
{
setup_sqlite_test_db();
# Create a dummy test entry, ensure it is of correct type and got its
# parameters correctly saved
$dummy = Test::create(array("dummy" => "Test456"));
$this->assertEqual(strtolower(get_class($dummy)), "test");
$this->assertEqual($dummy->_base_class, "Test");
$this->assertEqual($dummy->dummy, "Test456");
$this->assertTrue($dummy->id > 0);
# Now create two test entries at once
$dummys = Test::create(array("dummy" => "Test567"), array("dummy" => "Test678"));
$this->assertEqual(count($dummys), 2);
# Return the complete table and check there is exactly one row
$all_rows = Test::find("all");
$this->assertEqual(count($all_rows), 3);
# Return the first row and check it still matches our first dummy test entry
$first = Test::find("first");
$this->assertEqual($first->dummy, "Test456");
$this->assertTrue($first->id > 0);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$action = Input::get('action');
$workUp = new Culture();
$workUp->user_id = Input::get('userId');
$workUp->test_id = Input::get('testId');
$workUp->observation = Input::get('obs');
if ($action == 'add') {
$workUp->save();
return 0;
} else {
if ($action == 'draw') {
$obsv = Test::find($workUp->test_id)->culture;
foreach ($obsv as $observation) {
$observation->user = User::find($observation->user_id)->name;
$observation->timeStamp = Culture::showTimeAgo($observation->created_at);
}
return json_encode($obsv);
}
}
}
function testTableMethods()
{
$id = $this->addRow();
$updatedRow = array('name' => 'test updated', 'id' => $id);
$this->assert(Test::update($updatedRow) === $id, "Update failed");
$this->assert(Test::find($id)->export() == $updatedRow, "Test::find failed");
$s = Test::findAll();
$sc = $s->count();
$this->assert($s->count() == 1, "Test::findAll(NO ARGUMENTS) failed (incorrect count {$sc})");
$sf = $s->export()->fetch(PDO::FETCH_ASSOC);
$this->assert($s->export()->fetch(PDO::FETCH_ASSOC) == $updatedRow, "Test::findAll(NO ARGUMENTS) failed (incorrect row " . var_export($sf, 1) . ")");
$s = Test::findAll(array('name = ?' => $updatedRow['name']));
$sc = $s->count();
$this->assert($s->count() == 1, "Test::findAll(EXISTING_ROW) failed (incorrect count {$sc})");
$sf = $s->export()->fetch(PDO::FETCH_ASSOC);
$this->assert($sf == $updatedRow, "Test::findAll(EXISTING_ROW) failed (incorrect row " . var_export($sf, 1) . ")");
$s = Test::findAll(array('name = ?' => $updatedRow['non-existing']));
$sc = $s->count();
$this->assert($s->count() == 0, "Test::findAll(NON_EXISTING_ROW) failed (incorrect count {$sc})");
$sf = $s->export()->fetch(PDO::FETCH_ASSOC);
$this->assert($sf == false, "Test::findAll(NON_EXISTING_ROW) failed (incorrect row " . var_export($sf, 1) . ")");
}
public function surveylistAction()
{
$manager = $this->session->get("Manager");
$tests = Test::find(array("school_id = :school_id:", "bind" => array("school_id" => $manager["school_id"]), "sort" => "id desc"));
$now = date("Y-m-d H:i:s");
$list = array();
foreach ($tests as $index => $test) {
/*
* status
* 0: 测试未开始
* 1: 测试正在进行中
* 2: 测试已经过期
*/
$import = Student::count(array("test_id= :test_id:", "bind" => array("test_id" => $test->t_id)));
$status = 0;
if ($now >= $test->begin_time && $now <= $test->end_time) {
$status = 1;
} else {
if ($now > $test->end_time) {
$status = 2;
}
}
$item = array("test_id" => $test->t_id, "people" => $test->people, "begin" => substr($test->begin_time, 0, strlen($test->begin_time) - 3), "end" => substr($test->end_time, 0, strlen($test->end_time) - 3), "description" => $test->description, "status" => $status, "import" => $import);
$list[$index] = $item;
}
$this->view->setVar("tests", $list);
// 设置url
$url = $this->makeurl();
$this->view->setVar("url", $url);
$this->view->setRenderLevel(\Phalcon\Mvc\View::LEVEL_ACTION_VIEW);
}
/**
* Retrieves the results and creates a JSON string
*
* @param testId the id of the test to send
* @param
*/
public function createJsonString($testId)
{
//if($comments==null or $comments==''){$comments = 'No Comments';
//We use curl to send the requests
$httpCurl = curl_init(Config::get('kblis.sanitas-url'));
curl_setopt($httpCurl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($httpCurl, CURLOPT_POST, true);
//If testID is null we cannot handle this test as we cannot know the results
if ($testId == null) {
return null;
}
//Get the test and results
$test = Test::find($testId);
$testResults = $test->testResults;
//Measures
$testTypeId = $test->testType()->get()->lists('id')[0];
$testType = TestType::find($testTypeId);
$testMeasures = $testType->measures;
//Get external requests and all its children
$externalDump = new ExternalDump();
$externRequest = ExternalDump::where('test_id', '=', $testId)->get();
if (!$externRequest->first()) {
//Not a request we can send back
return null;
}
$labNo = $externRequest->lists('lab_no')[0];
$externlabRequestTree = $externalDump->getLabRequestAndMeasures($labNo);
$interpretation = "";
//IF the test has no children prepend the status to the result
if ($externlabRequestTree->isEmpty()) {
if ($test->test_status_id == Test::COMPLETED) {
$interpretation = "Done: " . $test->interpretation;
} elseif ($test->test_status_id == Test::VERIFIED) {
$interpretation = "Tested and verified: " . $test->interpretation;
}
} else {
if ($test->test_status_id == Test::COMPLETED) {
$interpretation = "Done " . $test->interpretation;
} elseif ($test->test_status_id == Test::VERIFIED) {
$interpretation = "Tested and verified " . $test->interpretation;
}
}
//TestedBy
$tested_by = ExternalUser::where('internal_user_id', '=', $test->tested_by)->get()->first();
if ($tested_by == null) {
$tested_by = "59";
} else {
if ($tested_by->external_user_id == null) {
$tested_by = "59";
} else {
$tested_by = $tested_by->external_user_id;
}
}
if ($test->verified_by == 0 || $test->verified_by == null) {
$verified_by = "59";
} else {
$verified_by = ExternalUser::where('internal_user_id', '=', $test->verified_by)->get()->first();
if ($verified_by == null) {
$verified_by = "59";
} else {
if ($verified_by->external_user_id == null) {
$verified_by = "59";
} else {
$verified_by = $verified_by->external_user_id;
}
}
}
//TODO - relate measure to test-result
$range = Measure::getRange($test->visit->patient, $testResults->first()->measure_id);
$unit = Measure::find($testResults->first()->measure_id)->unit;
$result = $testResults->first()->result . " " . $range . " " . $unit;
$jsonResponseString = sprintf('{"labNo": "%s","requestingClinician": "%s", "result": "%s", "verifiedby": "%s", "techniciancomment": "%s"}', $labNo, $tested_by, $result, $verified_by, trim($interpretation));
$this->sendRequest($httpCurl, urlencode($jsonResponseString), $labNo);
//loop through labRequests and foreach of them get the result and put in an array
foreach ($externlabRequestTree as $key => $externlabRequest) {
$mKey = array_search($externlabRequest->investigation, $testMeasures->lists('name'));
if ($mKey === false) {
Log::error("MEASURE NOT FOUND: Measure {$externlabRequest->investigation} not found in our system");
} else {
$measureId = $testMeasures->get($mKey)->id;
$rKey = array_search($measureId, $testResults->lists('measure_id'));
$matchingResult = $testResults->get($rKey);
$range = Measure::getRange($test->visit->patient, $measureId);
$unit = Measure::find($measureId)->unit;
$result = $matchingResult->result . " " . $range . " " . $unit;
$jsonResponseString = sprintf('{"labNo": "%s","requestingClinician": "%s", "result": "%s", "verifiedby": "%s", "techniciancomment": "%s"}', $externlabRequest->lab_no, $tested_by, $result, $verified_by, "");
$this->sendRequest($httpCurl, urlencode($jsonResponseString), $externlabRequest->lab_no);
}
}
curl_close($httpCurl);
}
public function getDelete($id)
{
$row = Test::find($id);
$row->delete();
return Redirect::to('/tests')->with('success', 'Deleted Successfully');
}
/**
* Update the answers
*/
public function updateAction()
{
$data = Input::all();
$num = (int) $data['number_of_answers'];
$test = Test::find($data['test_id']);
$question = Question::find($data['id']);
if (is_null($test) || is_null($question) || $test->id != $question->test->id) {
return Redirect::route('tests.index')->with('error', 'Incorrect id');
}
$validation = Validator::make(['text' => $data['text']], Question::$rules);
if (!$validation->passes()) {
return Redirect::route('question.edit', ['id' => $question->id])->withInput()->withErrors($validation)->with('message', 'There were validation errors.');
}
$oldType = $question->type;
$question->text = $data['text'];
$question->number = $data['number'];
$question->type = $data['type'] ? $data['type'] : Question::TYPE_STRING;
$question->save();
/**
* Erase all old answers
*/
DB::table('answer')->where('question_id', $question->id)->delete();
/**
* Create answers
*/
for ($i = 1; $i <= $num; $i++) {
if (!isset($data['a_' . $i . '_text']) || !trim($data['a_' . $i . '_text'])) {
continue;
}
$answer = new Answer();
$answer->question_id = $question->id;
$answer->text = trim($data['a_' . $i . '_text']);
$answer->weight = (int) $data['a_' . $i . '_weight'];
if ($question->type == Question::TYPE_CHECKBOX) {
$answer->is_correct = isset($data['a_' . $i . '_correct']) ? true : false;
} elseif ($question->type == Question::TYPE_RADIO) {
$answer->is_correct = isset($data['a_0_correct']) && $data['a_0_correct'] == $i ? true : false;
}
if ($answer->is_correct && !$answer->weight) {
$answer->weight = 1;
}
if (!$answer->is_correct) {
$answer->weight = 0;
}
$answer->save();
}
return Redirect::route('tests.show', $test->id);
}
<?php
echo json_encode(Test::find('tests'));
/**
* Create token for the test
*
* @param $id
*/
public function createAction($id)
{
if (!Auth::user()) {
return Redirect::route('admin');
}
$test = Test::find($id);
if (is_null($test)) {
return Redirect::route('info')->with('message', 'Тест не найден');
}
$token = new Token();
$token->token = $token->generate($test->name);
$token->test_id = $id;
$token->save();
return View::make('test.token', ['token' => $token->token]);
}
/**
* Results are formatted like Measure:result Measure:result
* for each of the measure of the test
*/
public function getFormattedResults($testId)
{
$testResults = Test::find($testId)->TestResults;
$formattedResults = '';
foreach ($testResults as $testResult) {
$measureName = $testResult->measure->name;
$formattedResults .= $measureName . ' : ' . $testResult->result;
}
return $formattedResults;
}
/**
* Remove the specified resource from storage.
* DELETE /tests/{id}
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$test = Test::find($id);
Test::destroy($id);
return Redirect::route('patient-chart-get', $test->patient_id)->with('global', "Test successfully deleted");
}
/**
* Culture worksheet for Test
*
* @param
* @return
*/
public function culture()
{
$test = Test::find(Input::get('testID'));
$test->test_status_id = Test::VERIFIED;
$test->time_verified = date('Y-m-d H:i:s');
$test->verified_by = Auth::user()->id;
$test->save();
//Fire of entry verified event
Event::fire('test.verified', array($testID));
return View::make('test.viewDetails')->with('test', $test);
}
@elseif($selectedReport == 3 || $selectedReport == 4) <!-- Tests Registry Report-->
<thead>
<tr>
<th>{{Lang::choice('messages.test-id',1)}}</th>
<th>{{Lang::choice('messages.test-type',1)}}</th>
<th>{{Lang::choice('messages.patient-number',1)}}</th>
<th>{{Lang::choice('messages.patient',1)}}</th>
<th>{{Lang::choice('messages.specimen-id',1)}}</th>
<th>{{Lang::choice('messages.registration-date',1)}}</th>
</tr>
</thead>
<tbody>
@forelse($reportData as $row)
<?php
$test = Test::find($row->id);
?>
<tr>
<td>{{$test->id}}</td>
<td>{{$test->testType->name}}</td>
<td>{{$test->visit->patient->patient_number}}</td>
<td>{{$test->visit->patient->name}}</td>
<td>{{$test->specimen->id}}</td>
<td>{{$test->time_completed}}</td>
</tr>
@empty
<tr>
<td colspan='6'>{{Lang::choice('messages.no-data-found',1)}}</td>
</tr>
@endforelse
</tbody>
/**
* Delete the test
*
* @param $id
*/
public function deleteAction($id)
{
$test = Test::find($id);
if (is_null($test)) {
return Redirect::route('tests.index')->with('error', 'Incorrect test id');
}
/**
* Get the list of answers
*/
$questions = Question::where('test_id', $id)->get();
foreach ($questions as $q) {
DB::table('answer')->where('question_id', $q->id)->delete();
}
DB::table('token')->where('test_id', $id)->delete();
DB::table('result')->where('test_id', $id)->delete();
DB::table('question')->where('test_id', $id)->delete();
DB::table('test')->where('id', $id)->delete();
return Redirect::route('tests.index');
}
public function testGetTurnAroundTime()
{
$testIDs = Test::where('test_status_id', '=', Test::COMPLETED)->orWhere('test_status_id', '=', Test::VERIFIED)->lists('id');
if (count($testIDs) == 0) {
$this->assertTrue(false);
}
foreach ($testIDs as $id) {
$test = Test::find($id);
$this->assertTrue($test->getTurnaroundTime() >= 0);
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$test = Test::find($id);
$cats = $test->category;
$resp = array('test' => $test->toArray(), 'categories' => $cats);
return $this->respond($test->toArray());
}
