PHP xt_delete_tag_catalog Examples

Example #1

File: admin_ajax.php Project: aspirin/wp-xintaoke

function xt_admin_ajax_tag_update()
{
    $result = array('code' => 0, 'msg' => '', 'result' => array());
    if (!current_user_can('manage_options')) {
        $result['code'] = 500;
        $result['msg'] = '您无权操作此功能';
    }
    if (!isset($_POST['id']) || empty($_POST['id'])) {
        $result['code'] = 500;
        $result['msg'] = '未指定标签';
    }
    if (!isset($_POST['sort']) || empty($_POST['sort'])) {
        $result['code'] = 500;
        $result['msg'] = '未指定标签排序';
    }
    $id = intval(trim($_POST['id']));
    $sort = intval($_POST['sort']);
    $cids = isset($_POST['cids']) ? $_POST['cids'] : '';
    $currentCid = intval($_POST['cid']);
    if ($result['code'] == 0) {
        global $wpdb;
        if ($currentCid > 0) {
            echo 'update:[' . $wpdb->update(XT_TABLE_SHARE_TAG_CATALOG, array('sort' => $sort), array('id' => $id, 'cid' => $currentCid)) . ']';
        } else {
            $wpdb->update(XT_TABLE_SHARE_TAG, array('sort' => $sort), array('id' => $id));
        }
        $query = "SELECT t.*, tr.id AS tag_id FROM " . XT_TABLE_CATALOG . " AS t INNER JOIN " . XT_TABLE_SHARE_TAG_CATALOG . " AS tr ON t.id = tr.cid WHERE t.type = 'share' AND tr.id =" . $id . " ORDER BY t.sort ASC,t.count DESC";
        $term = $wpdb->get_results($query);
        $old = array();
        if (!empty($term)) {
            foreach ($term as $_term) {
                $old[] = $_term->id;
            }
        }
        $cids = array_map('intval', explode(',', $cids));
        if (empty($cids)) {
            $cids = array();
        }
        $deleteIds = array_diff($old, $cids);
        //delete
        $addIds = array_diff($cids, $old);
        //add
        if (!empty($deleteIds)) {
            foreach ($deleteIds as $del) {
                xt_delete_tag_catalog($del, $id);
            }
        }
        if (!empty($addIds)) {
            foreach ($addIds as $add) {
                xt_new_tag_catalog(array('cid' => $add, 'id' => $id));
            }
        }
        $tag = xt_get_tag($id);
        if (!empty($addIds)) {
            global $wpdb;
            foreach ($addIds as $add) {
                //refresh count
                $count = xt_get_sharecount_bytagandcid($tag->title, $add);
                $wpdb->query("UPDATE " . XT_TABLE_SHARE_TAG_CATALOG . " SET count={$count} WHERE id=" . absint($id) . " AND cid=" . absint($add));
            }
        }
        $term = $wpdb->get_results($query);
        //reload
        xt_update_catalog_terms_cache($id, $term);
        //sort and count
        if ($currentCid > 0) {
            $catalog = xt_get_catalog($currentCid);
            if (!empty($catalog)) {
                global $wpdb;
                $sql = "SELECT " . XT_TABLE_SHARE_TAG_CATALOG . ".cid," . XT_TABLE_SHARE_TAG_CATALOG . ".sort," . XT_TABLE_SHARE_TAG . ".id," . XT_TABLE_SHARE_TAG . ".title," . XT_TABLE_SHARE_TAG . ".is_hot," . XT_TABLE_SHARE_TAG_CATALOG . ".count," . XT_TABLE_SHARE_TAG . ".nums FROM " . XT_TABLE_SHARE_TAG_CATALOG . " INNER JOIN " . XT_TABLE_SHARE_TAG . " ON " . XT_TABLE_SHARE_TAG . ".id=" . XT_TABLE_SHARE_TAG_CATALOG . ".id WHERE " . XT_TABLE_SHARE_TAG_CATALOG . ".id={$id} AND " . XT_TABLE_SHARE_TAG_CATALOG . ".cid={$currentCid}";
                if (isset($catalog->children) && !empty($catalog->children)) {
                    $sql = "SELECT " . XT_TABLE_SHARE_TAG_CATALOG . ".cid," . XT_TABLE_SHARE_TAG_CATALOG . ".sort AS sort,min(" . XT_TABLE_SHARE_TAG_CATALOG . ".sort) AS childSort," . XT_TABLE_SHARE_TAG . ".id," . XT_TABLE_SHARE_TAG . ".title," . XT_TABLE_SHARE_TAG . ".is_hot,max(" . XT_TABLE_SHARE_TAG_CATALOG . ".count) AS count," . XT_TABLE_SHARE_TAG . ".nums FROM " . XT_TABLE_SHARE_TAG_CATALOG . " INNER JOIN " . XT_TABLE_SHARE_TAG . " ON " . XT_TABLE_SHARE_TAG . ".id=" . XT_TABLE_SHARE_TAG_CATALOG . ".id WHERE " . XT_TABLE_SHARE_TAG_CATALOG . ".id={$id} AND " . XT_TABLE_SHARE_TAG_CATALOG . ".cid in(" . $wpdb->escape($catalog->children) . ",{$currentCid}) GROUP BY " . XT_TABLE_SHARE_TAG . ".id ORDER BY sort ASC,childSort ASC," . XT_TABLE_SHARE_TAG_CATALOG . ".count DESC";
                }
                $tag = $wpdb->get_row($sql);
            }
        }
        exit(xt_row_tag($tag, isset($_POST['alternate']) && $_POST['alternate'] ? 0 : 1, $currentCid));
    }
    exit(json_encode($result));
}

Example #2

File: query-catalog.php Project: aspirin/wp-xintaoke

function xt_catalog_delete($ids)
{
    global $wpdb;
    $ids = explode(',', $ids);
    if (!empty($ids)) {
        foreach ($ids as $id) {
            $id = intval($id);
            $_catalog = xt_get_catalog($id);
            if (!empty($_catalog)) {
                if ($_catalog->type == 'share') {
                    //删除分享与分类的关系
                    xt_delete_share_catalog($id);
                    xt_delete_tag_catalog($id);
                    //删除标签与分类的关系
                    $wpdb->query('DELETE FROM ' . XT_TABLE_CATALOG_ITEMCAT . ' WHERE id=' . $id);
                    //删除自动分类配置
                } elseif ($_catalog->type == 'album') {
                    xt_delete_album_catalog($id);
                    //删除专辑与分类的关系
                }
                $childs = $wpdb->get_col('SELECT id FROM ' . XT_TABLE_CATALOG . ' WHERE parent=' . $id);
                if (!empty($childs)) {
                    //删除子分类
                    xt_catalog_delete(implode(',', $childs));
                }
                $wpdb->delete(XT_TABLE_CATALOG, array('id' => $id));
            }
        }
    }
}