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