data class VideoInfo(
    val name: String,
    val path: String,
    val size: Long,
    val duration: Long
)

fun getVideos(context: Context): List<VideoInfo> {
    val videos = mutableListOf<VideoInfo>()

    // 定義需要查詢的列
    val projection = arrayOf(
        MediaStore.Video.Media._ID,
        MediaStore.Video.Media.DISPLAY_NAME,
        MediaStore.Video.Media.DATA,
        MediaStore.Video.Media.SIZE,
        MediaStore.Video.Media.DURATION,
        MediaStore.Video.Media.DATE_MODIFIED
    )

    // 定義排序方式
    val sortOrder = "${MediaStore.Video.Media.DATE_MODIFIED} DESC"

    // 執(zhí)行查詢
    context.contentResolver.query(
        MediaStore.Video.Media.EXTERNAL_CONTENT_URI,
        projection,
        null,
        null,
        sortOrder
    )?.use { cursor ->
        val idColumn = cursor.getColumnIndexOrThrow(MediaStore.Video.Media._ID)
        val nameColumn = cursor.getColumnIndexOrThrow(MediaStore.Video.Media.DISPLAY_NAME)
        val dataColumn = cursor.getColumnIndexOrThrow(MediaStore.Video.Media.DATA)
        val sizeColumn = cursor.getColumnIndexOrThrow(MediaStore.Video.Media.SIZE)
        val durationColumn = cursor.getColumnIndexOrThrow(MediaStore.Video.Media.DURATION)

        while (cursor.moveToNext()) {
            val id = cursor.getLong(idColumn)
            val name = cursor.getString(nameColumn)
            val path = cursor.getString(dataColumn)
            val size = cursor.getLong(sizeColumn)
            val duration = cursor.getLong(durationColumn)

            val videoInfo = VideoInfo(name, path, size, duration)
            videos.add(videoInfo)
        }
    }

    return videos
}