修改weaponSkinModel.js

1.1 修改weaponSkinModel.js
在weaponSkinModel.js中添加分页查询方法，支持筛选条件
JavaScript
运行代码
复制代码
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
// model/weaponSkinModel.js
}

// 类别筛选
if (category && category.length > 0) {
  const categoryMap = {
    'weapon_skin': '武器皮肤',
    'sticker': '印花',
    'glove': '手套',
    'knife': '刀具',
    'music_kit': '音乐盒'
  };
  const categoryValues = category.map(val => categoryMap[val] || val).filter(Boolean);
  if (categoryValues.length > 0) {
    conditions.push(`category IN (${categoryValues.map(() => '?').join(',')})`);
    params.push(...categoryValues);
  }
}

// 品质筛选
if (quality && quality.length > 0) {
  const qualityMap = {
    'consumer': '消费级',
    'industrial': '工业级',
    'milspec': '军规级',
    'restricted': '受限',
    'classified': '保密',
    'covert': '隐秘',
    'exceedingly_rare': '非凡'
  };
  const qualityValues = quality.map(val => qualityMap[val] || val).filter(Boolean);
  if (qualityValues.length > 0) {
    conditions.push(`quality IN (${qualityValues.map(() => '?').join(',')})`);
    params.push(...qualityValues);
  }
}

// 收藏品筛选
if (isCollectible !== null && isCollectible !== '') {
  conditions.push('isCollectible = ?');
  params.push(isCollectible === true || isCollectible === 'true' || isCollectible === 1 ? 1 : 0);
}

// 基础武器筛选
if (baseWeapon && baseWeapon.length > 0) {
  conditions.push(`baseWeapon IN (${baseWeapon.map(() => '?').join(',')})`);
  params.push(...baseWeapon);
}

// 构建 WHERE 子句
const whereClause = conditions.length > 0 ? `WHERE ${conditions.join(' AND ')}` : '';

// 计算偏移量
const offset = (page - 1) * pageSize;

// 查询总数
const [countResult] = await pool.execute(
  `SELECT COUNT(*) as total FROM weapon_skins ${whereClause}`,
  params
);
const total = countResult[0].total;

// 查询数据
const [rows] = await pool.execute(
  `SELECT * FROM weapon_skins ${whereClause} ORDER BY id DESC LIMIT ? OFFSET ?`,
  [...params, pageSize, offset]
);

// 计算总页数
const totalPages = Math.ceil(total / pageSize);

return {
  success: true,
  data: rows,
  pagination: {
    page: parseInt(page),
    pageSize: parseInt(pageSize),
    total: total,
    totalPages: totalPages,
    hasNext: page < totalPages,
    hasPrev: page > 1
  }
};

} catch (error) {
console.error('❌ 分页查询失败：', error.message);
throw error;
}
}

// 只暴露当前开发的功能
module.exports = {
getAllWeaponSkins,
addWeaponSkin,
deleteWeaponSkin,
updateWeaponSkinPrice,
getWeaponSkinsWithPagination
};