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 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 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 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 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; } }