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_OnValidate(&$sender) { $change_password_changepwd1_OnValidate = true; $Component =& $sender; $Container =& CCGetParentContainer($sender); global $change_password; //Compatibility //End change_password_changepwd1_OnValidate //Custom Code @13-2A29BDB7 // ------------------------- if ($change_password->changepwd1->newpwd->GetValue() != $change_password->changepwd1->confirmpwd->GetValue()) { $change_password->changepwd1->Errors->addError("New Password and Confirm Password Mismatch!"); return; } $db = new clsDBconnection1(); $sqll = "select user_password from users where user_id =" . ccgetuserid(); $db->query($sqll); $Result = $db->next_record(); $upwd = $db->f('user_password'); if ($Result and $change_password->changepwd1->oldpwd->GetValue() != $upwd) { $change_password->changepwd1->Errors->addError("Old Password is incorrect!"); return; } // ------------------------- //End Custom Code //Close change_password_changepwd1_OnValidate @8-91FAC17C return $change_password_changepwd1_OnValidate; }
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_patName_BeforeShow(&$sender) { $result_patName_BeforeShow = true; $Component =& $sender; $Container =& CCGetParentContainer($sender); global $result; //Compatibility //End result_patName_BeforeShow //Custom Code @181-2A29BDB7 // ------------------------- $db = new clsDBconnection1(); $sql11 = "select concat_ws(' ',surname,other_names) as names from patient inner join result on patient.patient_id = result.patient_id where result_id=" . ccgetparam("result_id"); $db->query($sql11); $Result21 = $db->next_record(); $names = $db->f('names'); if ($Result21) { $result->patName->SetValue(" " . $names); } // ------------------------- //End Custom Code //Close result_patName_BeforeShow @167-4F33EC17 return $result_patName_BeforeShow; }
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 result_Label2_BeforeShow(&$sender) { $result_Label2_BeforeShow = true; $Component =& $sender; $Container =& CCGetParentContainer($sender); global $result; //Compatibility //End result_Label2_BeforeShow //Custom Code @62-2A29BDB7 // ------------------------- $dbw = new clsDBconnection1(); $sqll = "select sub_dept from sub_dept where sub_dept_id =" . $result->sup_dept_id->GetValue(); $dbw->query($sqll); $Result3 = $dbw->next_record(); $sub_dept = $dbw->f('sub_dept'); if ($Result3) { $result->Label2->SetValue("" . $sub_dept); } // ------------------------- //End Custom Code //Close result_Label2_BeforeShow @61-0C4D2E04 return $result_Label2_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; } }