PHP xt_update_catalog_terms_cache Examples

Example #1

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

    $object_ids = array();
    foreach ($_shares as $share) {
        $object_ids[] = $share->id;
    }
    $object_ids = implode(',', $object_ids);
    $query = "SELECT t.*, tr.id AS share_id FROM " . XT_TABLE_CATALOG . " AS t INNER JOIN " . XT_TABLE_SHARE_CATALOG . " AS tr ON t.id = tr.cid WHERE t.type = 'share' AND tr.id IN ({$object_ids}) ORDER BY t.sort ASC,t.count DESC";
    global $wpdb;
    $terms = $wpdb->get_results($query);
    $_terms = array();
    foreach ($terms as $term) {
        $_term = isset($_terms[$term->share_id]) ? $_terms[$term->share_id] : array();
        $_term[] = $term;
        $_terms[$term->share_id] = $_term;
    }
    foreach ($_terms as $_share_id => $_term) {
        xt_update_catalog_terms_cache($_share_id, $_term, 'share');
    }
    foreach ($_shares as $share) {
        xt_row_share($share, $_share_count);
        $_share_count++;
    }
}
?>
    </tbody>
</table>
<table style="display: none">
    <tbody>
        <tr id="inline-edit" class="inline-edit-row">
            <td colspan="7" class="colspanchange">
                <fieldset class="inline-edit-col-left" style="width:40%;">
                    <div class="inline-edit-col">

Example #2

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

function xt_admin_ajax_album_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'] = '未指定专辑';
    }
    $id = intval(trim($_POST['id']));
    $cids = isset($_POST['cids']) ? $_POST['cids'] : '';
    if ($result['code'] == 0) {
        global $wpdb;
        $query = "SELECT t.*, tr.id AS album_id FROM " . XT_TABLE_CATALOG . " AS t INNER JOIN " . XT_TABLE_ALBUM_CATALOG . " AS tr ON t.id = tr.cid WHERE t.type = 'album' 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_album_catalog($del, $id);
            }
        }
        if (!empty($addIds)) {
            foreach ($addIds as $add) {
                xt_new_album_catalog(array('cid' => $add, 'id' => $id));
            }
        }
        $album = xt_get_album($id);
        $term = $wpdb->get_results($query);
        //reload
        xt_update_catalog_terms_cache($id, $term, 'album');
        exit(xt_row_album($album, isset($_POST['alternate']) && $_POST['alternate'] ? 0 : 1));
    }
    exit(json_encode($result));
}

Example #3

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

    $object_ids = array();
    foreach ($_tags as $tag) {
        $object_ids[] = $tag->id;
    }
    $object_ids = implode(',', $object_ids);
    $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 IN ({$object_ids}) ORDER BY t.sort ASC,t.count DESC";
    global $wpdb;
    $terms = $wpdb->get_results($query);
    $_terms = array();
    foreach ($terms as $term) {
        $_term = isset($_terms[$term->tag_id]) ? $_terms[$term->tag_id] : array();
        $_term[] = $term;
        $_terms[$term->tag_id] = $_term;
    }
    foreach ($_terms as $_tag_id => $_term) {
        xt_update_catalog_terms_cache($_tag_id, $_term);
    }
    foreach ($_tags as $tag) {
        xt_row_tag($tag, $_tag_count, $cid);
        $_tag_count++;
    }
}
?>
            </tbody>
        </table>
        <table style="display: none">
            <tbody>
                <tr id="inline-edit" class="inline-edit-row">
                    <td colspan="5" class="colspanchange">
                        <fieldset class="inline-edit-col-left" style="width:40%;">
                            <div class="inline-edit-col">

Example #4

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

    $object_ids = array();
    foreach ($_albums as $album) {
        $object_ids[] = $album->id;
    }
    $object_ids = implode(',', $object_ids);
    $query = "SELECT t.*, tr.id AS album_id FROM " . XT_TABLE_CATALOG . " AS t INNER JOIN " . XT_TABLE_ALBUM_CATALOG . " AS tr ON t.id = tr.cid WHERE t.type = 'album' AND tr.id IN ({$object_ids}) ORDER BY t.sort ASC,t.count DESC";
    global $wpdb;
    $terms = $wpdb->get_results($query);
    $_terms = array();
    foreach ($terms as $term) {
        $_term = isset($_terms[$term->album_id]) ? $_terms[$term->album_id] : array();
        $_term[] = $term;
        $_terms[$term->album_id] = $_term;
    }
    foreach ($_terms as $_album_id => $_term) {
        xt_update_catalog_terms_cache($_album_id, $_term, 'album');
    }
    foreach ($_albums as $album) {
        xt_row_album($album, $_album_count);
        $_album_count++;
    }
}
?>
    </tbody>
</table>
<table style="display: none">
    <tbody>
        <tr id="inline-edit" class="inline-edit-row">
            <td colspan="7" class="colspanchange">
                <fieldset class="inline-edit-col-left" style="width:40%;">
                    <div class="inline-edit-col">