Exemplos de clsDBconnection1::close em PHP

Exemplo n.º 1

Arquivo: complete_daily_request_distribution_events.php Projeto: Okwori/iRadiology

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

Exemplo n.º 2

Arquivo: single_free1_chartTemplate_events.php Projeto: Okwori/iRadiology

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

Exemplo n.º 3

Arquivo: new_vs_returning_events.php Projeto: Okwori/iRadiology

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

Exemplo n.º 4

Arquivo: index_events.php Projeto: Okwori/iRadiology

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