clsDBhrcon::close PHP代码示例

示例#1

0

显示文件

文件： login_events_bak.php 项目： rayminami/chumanis

function Login_Button_DoLogin_OnClick(&$sender)
{
    $Login_Button_DoLogin_OnClick = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $Login;
    //Compatibility
    //End Login_Button_DoLogin_OnClick
    //Login @4-DE10C29C
    global $CCSLocales;
    global $Redirect;
    if (!CCLoginUser($Container->username->Value, $Container->password->Value)) {
        $Container->Errors->addError($CCSLocales->GetText("CCS_LoginError"));
        $Container->password->SetValue("");
        $Login_Button_DoLogin_OnClick = 0;
    } else {
        global $Redirect;
        $seshmenu = "";
        $glip = array("glyphicon-cog", "glyphicon-cog", "glyphicon-list", "glyphicon-folder-close", "glyphicon-usd", "glyphicon-gift", "glyphicon-time", "glyphicon-user", "glyphicon-log-in", "glyphicon-align-justify");
        $DBhrcon_ = new clsDBhrcon();
        $queryMD = "select p_module_id, code, description from p_module " . "where is_active='Y' order by listing_no";
        $DBhrcon_->query($queryMD);
        while ($DBhrcon_->next_record()) {
            $seshmenu = $seshmenu . "<li><a href='../main/modul.php?p_module_id=" . $DBhrcon_->f("p_module_id") . "'" . "title='" . $DBhrcon_->f("code") . "&#13;" . $DBhrcon_->f("description") . "' target=''>" . "<i class='glyphicon " . $glip[$DBhrcon_->f("p_module_id")] . "' style='font-size: 32px; border:2px solid #ffffff; padding:3px'></i>";
        }
        $DBhrcon_->close();
        CCSetSession("hmenu", $seshmenu);
        $Redirect = CCGetParam("ret_link", $Redirect);
        $Login_Button_DoLogin_OnClick = 1;
    }
    //End Login
    //Close Login_Button_DoLogin_OnClick @3-0EB5DCFE
    return $Login_Button_DoLogin_OnClick;
}

示例#2

0

显示文件

文件： p_user_pass_change_events.php 项目： rayminami/chumanis

function roleForm_Button_Insert_OnClick(&$sender)
{
    $roleForm_Button_Insert_OnClick = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $roleForm;
    //Compatibility
    //End roleForm_Button_Insert_OnClick
    //Custom Code @73-2A29BDB7
    // -------------------------
    global $CCSLocales;
    global $Redirect;
    //CCLogoutUser();
    $db = new clsDBhrcon();
    $SQL = "select * from f_changeuserpwd(" . $db->ToSQL($Container->user_name->Value, ccsText) . "," . $db->ToSQL(CCGetSession("is_new_user"), ccsText) . "," . $db->ToSQL($Container->old_password->Value, ccsText) . "," . $db->ToSQL($Container->new_password->Value, ccsText) . "," . $db->ToSQL($Container->new_password2->Value, ccsText) . ")";
    $db->query($SQL);
    $Result = $db->next_record();
    if (!$Result) {
        return;
    }
    //
    if ($db->f('o_result_int') != 1) {
        //print_r("test");exit;
        $Container->Errors->addError($db->f('o_result_msg'));
        $db->close();
    } else {
        CCLogoutUser();
        $db->close();
        print_r("<script language='JavaScript'>alert('Sukses');top.location.href='../';</script>");
    }
    //header('location:'.ServerURL . "main/login.php");
    //exit;
    // -------------------------
    //End Custom Code
    //Close roleForm_Button_Insert_OnClick @5-CEA01FFE
    return;
    //$roleForm_Button_Insert_OnClick;
}

示例#3

0

显示文件

文件： p_user_attribute_form.php 项目： rayminami/chumanis

$Tpl->SetVar("CCS_PathToMasterPage", RelativePath . $PathToCurrentMasterPage);
$Tpl->block_path = "/{$BlockToParse}";
$CCSEventResult = CCGetEvent($CCSEvents, "BeforeShow", $MainPage);
$Attributes->SetValue("pathToRoot", "../");
$Attributes->Show();
//End Initialize HTML Template
//Execute Components @1-93DAD1DB
$MasterPage->Operations();
$modal_end->Operations();
$modal_start->Operations();
$roleForm->Operation();
//End Execute Components
//Go to destination page @1-40700939
if ($Redirect) {
    $CCSEventResult = CCGetEvent($CCSEvents, "BeforeUnload", $MainPage);
    $DBhrcon->close();
    header("Location: " . $Redirect);
    unset($roleForm);
    $modal_start->Class_Terminate();
    unset($modal_start);
    $modal_end->Class_Terminate();
    unset($modal_end);
    unset($Tpl);
    exit;
}
//End Go to destination page
//Show Page @1-1919319E
$Head->Show();
$Content->Show();
$MasterPage->Tpl->SetVar("Head", $Tpl->GetVar("Panel Head"));
$MasterPage->Tpl->SetVar("Content", $Tpl->GetVar("Panel Content"));

示例#4

0

显示文件

文件： modul_events.php 项目： rayminami/chumanis

function Page_OnInitializeView(&$sender)
{
    $Page_OnInitializeView = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $modul;
    //Compatibility
    //End Page_OnInitializeView
    //Custom Code @8-2A29BDB7
    // -------------------------
    // Write your own code here.
    global $namaMD;
    $p_module_id = $_GET["p_module_id"];
    $DBhrcon_ = new clsDBhrcon();
    $queryMD = "select code from p_module where p_module_id=" . $p_module_id;
    $DBhrcon_->query($queryMD);
    if ($DBhrcon_->next_record()) {
        $namaMD = $DBhrcon_->f("code");
        CCSetSession("namamodullabel", $DBhrcon_->f("code"));
    } else {
        $namaMD = "--";
    }
    $DBhrcon_->close();
    $seslmenu = "" . "<div class='blockheader'> " . "<h3 class='t'>" . $namaMD . "</h3> " . "</div>" . "<div class='blockcontent'>" . "<div id='cssmenu'>" . "<ul id='Accordion'>";
    $queryMN = "select * from f_display_menu_tree(" . $p_module_id . ")";
    $PLevel = array(0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
    $level = 0;
    $bdmnid = -1;
    $nplevel = 0;
    $parid = -1;
    $DBhrcon_->query($queryMN);
    $curdata = "-";
    while ($DBhrcon_->next_record()) {
        if ($parid != -1) {
            if ($nplevel == $DBhrcon_->f("parent_id")) {
                $curdata = "<li class='has-sub'><a href='" . $file_name . "?idmenulabel=" . $DBhrcon_->f("p_menu_id") . "'><span>" . $mncode . "</span></a><ul>";
                $seslmenu = $seslmenu . $curdata;
                $level = $level + 1;
                $PLevel[$level] = $nplevel;
            } else {
                $curdata = "<li><a href='" . $file_name . "?idmenulabel=" . $DBhrcon_->f("p_menu_id") . "'><span>" . $mncode . "</span></a> </li> ";
                $seslmenu = $seslmenu . $curdata;
                while ($PLevel[$level] > $DBhrcon_->f("parent_id") && $level > 0) {
                    $level = $level - 1;
                    $seslmenu = $seslmenu . "</ul></li>";
                }
            }
        }
        $bdmnid = $DBhrcon_->f("p_menu_id");
        $nplevel = $DBhrcon_->f("p_menu_id");
        $parid = $DBhrcon_->f("parent_id");
        $mncode = $DBhrcon_->f("code");
        $file_name = $DBhrcon_->f("file_name");
    }
    if ($parid != -1) {
        $curdata = "<li><a href='" . $file_name . "?idmenulabel=" . $DBhrcon_->f("p_menu_id") . "'><span>" . $mncode . "</span></a> </li> ";
        $seslmenu = $seslmenu . $curdata;
        while ($PLevel[$level] > $DBhrcon_->f("parent_id") && $level > 0) {
            $level = $level - 1;
            $seslmenu = $seslmenu . "</ul></li>";
        }
    }
    $DBhrcon_->close();
    $seslmenu = $seslmenu . "</ul>" . "</div>" . "</div>";
    CCSetSession("lmenu", $seslmenu);
    // -------------------------
    //End Custom Code
    //Close Page_OnInitializeView @1-81DF8332
    return $Page_OnInitializeView;
}

示例#5

0

显示文件

文件： login_events.php 项目： rayminami/chumanis

function Login_Button_DoLogin_OnClick(&$sender)
{
    $Login_Button_DoLogin_OnClick = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $Login;
    //Compatibility
    //End Login_Button_DoLogin_OnClick
    //Login @4-DE10C29C
    global $CCSLocales;
    global $Redirect;
    CCLogoutUser();
    $db = new clsDBhrcon();
    $SQL = "select * from f_userlogin(null," . $db->ToSQL($Container->username->Value, ccsText) . "," . $db->ToSQL($Container->password->Value, ccsText) . ",'localhost')";
    // . " AND user_pwd=" . $db->ToSQL($password, ccsText);
    $db->query($SQL);
    $Result = $db->next_record();
    if ($Result) {
        CCSetSession("UserID", $db->f("p_user_id"));
        CCSetSession("UserName", $Container->username->Value);
        CCSetSession("GroupID", $db->f("p_user_id"));
        CCSetSession("UserAddr", $_SERVER["REMOTE_ADDR"]);
        CCSetSession("UserStatus", $db->f("o_is_new_user"));
    }
    //o_result_int integer,
    //o_result_msg character varying,
    //o_is_new_user character varying,
    //o_is_change_pwd character varying,
    //o_last_login_text character varying,
    //o_user_id integer)
    if ($db->f('o_result_int') != 1) {
        //$Container->Errors->addError($CCSLocales->GetText("CCS_LoginError"));
        $Container->Errors->addError($db->f('o_result_msg'));
        $Container->password->SetValue("");
        $Login_Button_DoLogin_OnClick = 0;
    } else {
        global $Redirect;
        //Add CAS
        if ($db->f('o_is_new_user') == "Y") {
            $seslmenu = "" . "<div class='blockheader'><h3 class='t'>Profile</h3></div>" . "<div class='blockcontent'>" . "<div style='position:relative; width:100%; height:100%'>" . "<img border='0' height='100' src='../images/users/" . CCGetUserLogin() . ".jpg' style='display: block; margin: 0 auto;'>" . "<p style='text-align:center'><strong>" . CCGetUserLogin() . "</strong></p></div>" . "<div id='cssmenu'>" . "<ul>" . "<li><a href='../main/home.php'><span>Task Box</span></a></li>" . "<li><a href='#'><span>User profile</span></a></li>" . "<li><a href='../admin.menu/p_user_pass_change.php'><span>Change Password</span></a></li>" . "</ul>" . "</div>" . "</div>";
            CCSetSession("lmenu", $seslmenu);
            $Redirect = "../admin.menu/p_user_pass_change.php";
        } else {
            if ($db->f('o_is_change_pwd') == "Y") {
                $seslmenu = "" . "<div class='blockheader'><h3 class='t'>Profile</h3></div>" . "<div class='blockcontent'>" . "<div style='position:relative; width:100%; height:100%'>" . "<img border='0' height='100' src='../images/users/" . CCGetUserLogin() . ".jpg' style='display: block; margin: 0 auto;'>" . "<p style='text-align:center'><strong>" . CCGetUserLogin() . "</strong></p></div>" . "<div id='cssmenu'>" . "<ul>" . "<li><a href='../main/home.php'><span>Task Box</span></a></li>" . "<li><a href='#'><span>User profile</span></a></li>" . "<li><a href='../admin.menu/p_user_pass_change.php'><span>Change Password</span></a></li>" . "</ul>" . "</div>" . "</div>";
                CCSetSession("lmenu", $seslmenu);
                $Redirect = "../admin.menu/p_user_pass_change.php";
            }
        }
        //End Add CAS
        $uid = $db->f('o_user_id');
        $seshmenu = "";
        $DBhrcon_ = new clsDBhrcon();
        //$queryMD  = "select p_module_id, code, description from p_module " .
        //            "where is_active='Y' order by listing_no";
        $lsuser = CCGetUserLogin();
        $queryMD = "select * from f_display_app('" . $lsuser . "')";
        $DBhrcon_->query($queryMD);
        while ($DBhrcon_->next_record()) {
            $param = CCAddParam("", "p_module_id", $DBhrcon_->f("p_module_id"));
            $seshmenu = $seshmenu . "<li><a href='../main/modul.php?" . $param . "'" . "title='" . $DBhrcon_->f("code") . " - " . $DBhrcon_->f("description") . "' target=''>" . "<img border='0' src='../images/menu/" . $DBhrcon_->f("p_module_id") . ".gif'></a> </li>";
        }
        include_once 'user_attribute.php';
        setUserAttrib($uid);
        $DBhrcon_->close();
        CCSetSession("hmenu", $seshmenu);
        $Redirect = CCGetParam("ret_link", $Redirect);
        $Login_Button_DoLogin_OnClick = 1;
    }
    //End Login
    //Close Login_Button_DoLogin_OnClick @3-0EB5DCFE
    return $Login_Button_DoLogin_OnClick;
}

PHP clsDBhrcon::close示例