PHP nv_fix_organ_order示例

示例#1

文件： organ_action.php 项目： ngoctu2008/nv4_module_laws

    echo nv_admin_theme($contents);
    include NV_ROOTDIR . "/includes/footer.php";
    exit;
} elseif ($ac == 'weight') {
    $value = $nv_Request->get_int('value', 'post', 0);
    $organid = $nv_Request->get_int('organid', 'post', 0);
    $data = array();
    if ($organid > 0) {
        if (empty($global_array_organ[$organid])) {
            die('stop!!');
        } else {
            $data = $global_array_organ[$organid];
        }
    }
    $query = "SELECT organid FROM " . NV_PREFIXLANG . "_" . $module_data . "_organ WHERE organid!=" . $organid . " AND parentid=" . $data['parentid'] . " ORDER BY weight ASC";
    $result = $db->query($query);
    $weight = 0;
    while ($row = $result->fetch()) {
        $weight++;
        if ($weight == $value) {
            $weight++;
        }
        $sql = "UPDATE " . NV_PREFIXLANG . "_" . $module_data . "_organ SET weight='" . $weight . "' WHERE organid='" . intval($row['organid']) . "'";
        $db->query($sql);
    }
    $sql = "UPDATE " . NV_PREFIXLANG . "_" . $module_data . "_organ SET weight='" . $value . "' WHERE organid='" . intval($organid) . "'";
    $db->query($sql);
    nv_fix_organ_order();
    nv_insert_logs(NV_LANG_DATA, $module_name, 'change weight', $value, $admin_info['userid']);
    die($data['parentid']);
}

示例#2

文件： admin.functions.php 项目： ngoctu2008/nv4_module_laws

function nv_fix_organ_order($parentid = 0, $order = 0, $lev = 0)
{
    global $db, $db_config, $lang_module, $lang_global, $module_name, $module_data, $op;
    $query = "SELECT organid, parentid FROM " . NV_PREFIXLANG . "_" . $module_data . "_organ WHERE parentid='" . $parentid . "' ORDER BY weight ASC";
    $result = $db->query($query);
    $array_organ_order = array();
    while ($row = $result->fetch()) {
        $array_organ_order[] = $row['organid'];
    }
    $db->sqlreset();
    $weight = 0;
    if ($parentid > 0) {
        $lev++;
    } else {
        $lev = 0;
    }
    foreach ($array_organ_order as $organid_i) {
        $order++;
        $weight++;
        $sql = "UPDATE " . NV_PREFIXLANG . "_" . $module_data . "_organ SET weight='" . $weight . "', orders='" . $order . "', lev='" . $lev . "' WHERE organid='" . intval($organid_i) . "'";
        $db->query($sql);
        $order = nv_fix_organ_order($organid_i, $order, $lev);
    }
    $numsuborgan = $weight;
    if ($parentid > 0) {
        $sql = "UPDATE " . NV_PREFIXLANG . "_" . $module_data . "_organ SET numsuborgan='" . $numsuborgan . "'";
        if ($numsuborgan == 0) {
            $sql .= ",suborganid=''";
        } else {
            $sql .= ",suborganid='" . implode(",", $array_organ_order) . "'";
        }
        $sql .= " WHERE organid='" . intval($parentid) . "'";
        $db->query($sql);
    }
    return $order;
}