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)); }
} $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"> <h4>快速编辑</h4> <label> <span class="title">名称</span> <span class="input-text-wrap"><input type="text" name="title" disabled class="ptitle" value="" /></span></label> </div>