function change_password_changepwd1_AfterUpdate(&$sender)
{
$change_password_changepwd1_AfterUpdate = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $change_password;
//Compatibility
//End change_password_changepwd1_AfterUpdate
//Custom Code @18-2A29BDB7
// -------------------------
$dbw = new clsDBconnection1();
$sql1 = "update users set user_password ='******' where user_id=" . CCGetUserID();
$dbw->query($sql1);
//$Result3 = $dbw->next_record();
if ($dbw->affected_rows() > 0) {
$change_password->changepwd1->Errors->addError('<div class="alert alert-success">DONE! Password Succesfully Changed! Login with new password to continue...</div>');
CCLogoutUser();
CCSetCookie("iRadiologyLogin", "");
} else {
$change_password->changepwd1->Errors->addError('<div class="alert">Unable to Change Password! Try Again Later!</div>');
}
// -------------------------
//End Custom Code
//DEL
//Close change_password_changepwd1_AfterUpdate @8-7BFDFC76
return $change_password_changepwd1_AfterUpdate;
}
function complete_daily_request_distribution_date_count_values_BeforeShow(&$sender)
{
$complete_daily_request_distribution_date_count_values_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $complete_daily_request_distribution;
//Compatibility
//End complete_daily_request_distribution_date_count_values_BeforeShow
//Custom Code @6-2A29BDB7
// -------------------------
$db = new clsDBconnection1();
$sql = "call patientdatecount;";
$db->query($sql);
$Result = $db->next_record();
$rs = $db->f('rs');
if ($Result) {
$complete_daily_request_distribution->date_count_values->SetValue($rs);
} else {
$complete_daily_request_distribution->date_count_values->SetValue(0);
}
$db->close();
// -------------------------
//End Custom Code
//Close complete_daily_request_distribution_date_count_values_BeforeShow @5-3607DB0E
return $complete_daily_request_distribution_date_count_values_BeforeShow;
}
function date_count_values_BeforeShow(&$sender)
{
$date_count_values_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $date_count_values;
//Compatibility
//End date_count_values_BeforeShow
//Custom Code @6-2A29BDB7
// -------------------------
$db = new clsDBconnection1();
$sql = "call patientdatecount;";
$db->query($sql);
$Result = $db->next_record();
$rs = $db->f('rs');
if ($Result) {
$date_count_values->SetValue($rs);
} else {
$date_count_values->SetValue(0);
}
$db->close();
// -------------------------
//End Custom Code
//Close date_count_values_BeforeShow @5-A61B4F44
return $date_count_values_BeforeShow;
}
function users_AfterUpdate(&$sender)
{
$users_AfterUpdate = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $users;
//Compatibility
//End users_AfterUpdate
//Custom Code @14-2A29BDB7
// -------------------------
$db = new clsDBconnection1();
if ($users->user_status_id->GetValue() == 2) {
$sql = "update users set user_status_id = 3 where users.user_id=" . CCGetParam("uid");
$db->query($sql);
$Result1 = $db->next_record();
} else {
if ($users->user_status_id->GetValue() == 3 or $users->user_status_id->GetValue() == 1) {
$sql = "update users set user_status_id = 2 where users.user_id=" . CCGetParam("uid");
$db->query($sql);
$Result1 = $db->next_record();
}
}
// -------------------------
//End Custom Code
//Close users_AfterUpdate @2-DE0947D6
return $users_AfterUpdate;
}
function new_vs_returning_returningPatient_BeforeShow(&$sender)
{
$new_vs_returning_returningPatient_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $new_vs_returning;
//Compatibility
//End new_vs_returning_returningPatient_BeforeShow
//Custom Code @10-2A29BDB7
// -------------------------
$db = new clsDBconnection1();
$sqll = "select ((count(patient_id) - count(distinct patient_id))/count(patient_id))*100 as rPc from result;";
$db->query($sqll);
$Result = $db->next_record();
$rpc = $db->f('rPc');
if ($Result) {
$new_vs_returning->returningPatient->SetValue($rpc);
} else {
$new_vs_returning->returningPatient->SetValue(0);
}
$db->close();
// -------------------------
//End Custom Code
//Close new_vs_returning_returningPatient_BeforeShow @9-0342B8F8
return $new_vs_returning_returningPatient_BeforeShow;
}
function result_AfterInsert(&$sender)
{
$result_AfterInsert = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $result;
//Compatibility
//End result_AfterInsert
//Custom Code @36-2A29BDB7
// -------------------------
global $Redirect;
$db1 = new clsDBconnection1();
$sql1 = "select max(result_id) as maxp from result";
$db1->query($sql1);
$Result1 = $db1->next_record();
$maxp = $db1->f('maxp');
$sqlp = "select department_id from result where result.result_id=" . $maxp;
$db1->query($sqlp);
$Result2 = $db1->next_record();
if ($Result1 and $Result2) {
$Redirect = "schedule_appointment.php?result_id=" . $maxp . "&department_id=" . $db1->f('department_id');
}
// -------------------------
//End Custom Code
//Close result_AfterInsert @10-30692902
return $result_AfterInsert;
}
function deptShort_BeforeShow(&$sender)
{
$deptShort_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $deptShort;
//Compatibility
//End deptShort_BeforeShow
//Custom Code @85-2A29BDB7
// -------------------------
$dbs = new clsDBconnection1();
$sqlq = "select department_id from result where result_id =" . CCGetParam("result_id");
$dbs->query($sqlq);
$Resulted = $dbs->next_record();
$deptID = $dbs->f('department_id');
if ($Resulted) {
if ($deptID == 1) {
$deptShort->SetValue("USD");
} else {
if ($deptID == 2) {
$deptShort->SetValue("X/M");
} else {
if ($deptID == 3) {
$deptShort->SetValue("FRC");
} else {
if ($deptID == 4) {
$deptShort->SetValue("CTS");
} else {
if ($deptID == 5) {
$deptShort->SetValue("MRI");
}
}
}
}
}
}
// -------------------------
//End Custom Code
//Close deptShort_BeforeShow @82-D697CAAE
return $deptShort_BeforeShow;
}
function Label1_BeforeShow(&$sender)
{
$Label1_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $Label1;
//Compatibility
//End Label1_BeforeShow
//Custom Code @7-2A29BDB7
// -------------------------
$db = new clsDBconnection1();
$sql1 = "select user_group.group from user_group inner join users on user_group.group_id=users.group_id where users.user_id=" . CCGetuserid();
$db->query($sql1);
$Result1 = $db->next_record();
$ugroup = $db->f('group');
if ($Result1) {
$Label1->SetValue(" " . $ugroup);
}
// -------------------------
//End Custom Code
//Close Label1_BeforeShow @6-B48DF954
return $Label1_BeforeShow;
}
function Label3_BeforeShow(&$sender)
{
$Label3_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $Label3;
//Compatibility
//End Label3_BeforeShow
//Custom Code @12-2A29BDB7
// -------------------------
$db = new clsDBconnection1();
$sqlq = "select department from department inner join users on department.department_id = users.department_id where user_id =" . CCGetuserid();
$db->query($sqlq);
$Resultq = $db->next_record();
$dept = $db->f('department');
if ($Resultq) {
$Label3->SetValue(" " . $dept);
}
// -------------------------
//End Custom Code
//Close Label3_BeforeShow @11-55E33DF9
return $Label3_BeforeShow;
}
function result_AfterUpdate(&$sender)
{
$result_AfterUpdate = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $result;
//Compatibility
//End result_AfterUpdate
//Custom Code @182-2A29BDB7
// -------------------------
global $Redirect;
if (is_numeric(ccgetparam('result_id'))) {
$db = new clsDBconnection1();
$sqlq = "Update result set status_id=3 where result_id=" . ccgetparam('result_id');
$db->query($sqlq);
$db->next_record();
$Redirect = "../print_report.php?result_id=" . CCGetParam("result_id", "");
}
// -------------------------
//End Custom Code
//Close result_AfterUpdate @51-FF40E88D
return $result_AfterUpdate;
}
function Label5_BeforeShow(&$sender)
{
$Label5_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $Label5;
//Compatibility
//End Label5_BeforeShow
//Custom Code @104-2A29BDB7
// -------------------------
$db = new clsDBconnection1();
$sql1 = "select patient_id from result where result_id=" . CCGetParam('result_id', '');
$db->query($sql1);
$Result1 = $db->next_record();
$pid = $db->f('patient_id');
if ($Result1) {
$Label5->SetValue($pid . "-" . CCGetParam('result_id', ''));
}
// -------------------------
//End Custom Code
//Close Label5_BeforeShow @103-AD21764F
return $Label5_BeforeShow;
}
function patient_AfterInsert(&$sender)
{
$patient_AfterInsert = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $patient;
//Compatibility
//End patient_AfterInsert
//Custom Code @83-2A29BDB7
// -------------------------
global $Redirect;
$db = new clsDBconnection1();
$sql1 = "select max(patient_id) as maxp from patient";
$db->query($sql1);
$Result1 = $db->next_record();
$maxp = $db->f('maxp');
if ($Result1) {
$Redirect = "schedule_test.php?patient_id=" . $maxp;
}
// -------------------------
//End Custom Code
//Close patient_AfterInsert @42-6AC4FF3B
return $patient_AfterInsert;
}
function users_AfterInsert(&$sender)
{
$users_AfterInsert = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $users;
//Compatibility
//End users_AfterInsert
//Custom Code @42-2A29BDB7
// -------------------------
global $Redirect;
$db = new clsDBconnection1();
$sql1 = "select max(user_id) as uid from users";
$db->query($sql1);
$Result1 = $db->next_record();
$uid = $db->f('uid');
if ($Result1) {
CCSetSession("myid", $uid);
}
$Redirect = "welcome.php";
// -------------------------
//End Custom Code
//Close users_AfterInsert @14-11208659
return $users_AfterInsert;
}
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $write_report;
//Compatibility
//End Page_BeforeShow
//Custom Code @69-2A29BDB7
// -------------------------
if (is_numeric(ccgetparam('result_id'))) {
$db = new clsDBconnection1();
$sqlq = "Update result set status_id=2 where result_id=" . ccgetparam('result_id');
$db->query($sqlq);
$db->next_record();
}
// -------------------------
//End Custom Code
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
function nop4_BeforeShow(&$sender)
{
$nop4_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $nop4;
//Compatibility
//End nop4_BeforeShow
//Custom Code @127-2A29BDB7
// -------------------------
$db = new clsDBconnection1();
$sql = "select count(weekday(appointment_date)) as Thursday from result where (WEEKOFYEAR(curdate())) = WEEKOFYEAR(appointment_date) and weekday(appointment_date) = 3 and user_id=" . CCGetUserID();
$db->query($sql);
$Result3 = $db->next_record();
$thur = $db->f('Thursday');
if ($Result3) {
$nop4->SetValue($thur);
} else {
$nop4->SetValue(0);
}
$db->close();
// -------------------------
//End Custom Code
//Close nop4_BeforeShow @123-76F12FC9
return $nop4_BeforeShow;
}
function getUserName()
{
$db = new clsDBconnection1();
$sql1 = "select first_name from users where user_id=" . ccgetuserid();
$sql2 = "select last_name from users where user_id=" . ccgetuserid();
$sql3 = "select title from title inner join users on title.title_id=users.title_id where users.user_id=" . ccgetuserid();
$db->query($sql1);
$Result1 = $db->next_record();
$firstName = $db->f('first_name');
$db->query($sql2);
$Result2 = $db->next_record();
$lastName = $db->f('last_name');
$db->query($sql3);
$Result3 = $db->next_record();
$title = $db->f('title');
if ($Result1 or $Result2 or $Result3) {
return $title . " " . $firstName . " " . $lastName;
}
}
