MODEL_ADMIN::mdl_alert_table PHP Метод

mdl_alert_table() публичный Метод

修改表 升级时调用 mdl_alert_table function.
public mdl_alert_table ( ) : void
Результат void
    function mdl_alert_table()
    {
        foreach ($this->adminStatus as $_key => $_value) {
            $_arr_status[] = $_key;
        }
        $_str_status = implode("','", $_arr_status);
        foreach ($this->adminTypes as $_key => $_value) {
            $_arr_types[] = $_key;
        }
        $_str_types = implode("','", $_arr_types);
        $_arr_col = $this->mdl_column();
        $_arr_alert = array();
        if (!in_array("admin_nick", $_arr_col)) {
            $_arr_alert["admin_nick"] = array("ADD", "varchar(30) NOT NULL COMMENT '昵称'");
        }
        if (in_array("admin_id", $_arr_col)) {
            $_arr_alert["admin_id"] = array("CHANGE", "smallint NOT NULL AUTO_INCREMENT COMMENT 'ID'", "admin_id");
        }
        if (in_array("admin_status", $_arr_col)) {
            $_arr_alert["admin_status"] = array("CHANGE", "enum('" . $_str_status . "') NOT NULL COMMENT '状态'", "admin_status");
        }
        if (in_array("admin_pass", $_arr_col)) {
            $_arr_alert["admin_pass"] = array("CHANGE", "char(32) NOT NULL COMMENT '密码'", "admin_pass");
        }
        if (in_array("admin_rand", $_arr_col)) {
            $_arr_alert["admin_rand"] = array("CHANGE", "char(6) NOT NULL COMMENT '随机串'", "admin_rand");
        }
        if (!in_array("admin_type", $_arr_col)) {
            $_arr_alert["admin_type"] = array("ADD", "enum('" . $_str_types . "') NOT NULL COMMENT '状态'");
        }
        $_str_alert = "y0201111";
        if ($_arr_alert) {
            $_reselt = $this->obj_db->alert_table(BG_DB_TABLE . "admin", $_arr_alert);
            if ($_reselt) {
                $_str_alert = "y020106";
                $_arr_adminData = array("admin_status" => $_arr_status[0]);
                $this->obj_db->update(BG_DB_TABLE . "admin", $_arr_adminData, "LENGTH(admin_status)<1");
                //将 admin_status 字段为空的记录,更新为默认值
                $_arr_adminData = array("admin_type" => $_arr_types[0]);
                $this->obj_db->update(BG_DB_TABLE . "admin", $_arr_adminData, "LENGTH(admin_type)<1");
                //将 admin_type 字段为空的记录,更新为默认值
            }
        }
        return array("alert" => $_str_alert);
    }

Usage Example

Пример #1
0
 private function table_admin()
 {
     include_once BG_PATH_MODEL . "admin.class.php";
     //载入管理帐号模型
     $_mdl_admin = new MODEL_ADMIN();
     $_arr_adminTable = $_mdl_admin->mdl_alert_table();
     $this->tplData["db_alert"]["admin_table"] = array("alert" => $_arr_adminTable["alert"], "status" => substr($_arr_adminTable["alert"], 0, 1));
 }
All Usage Examples Of MODEL_ADMIN::mdl_alert_table