<?php

namespace App\Models;

use CodeIgniter\Model;

class WordDetailsModel extends Model
{
    protected $table = 'ew_word_details';
    protected $primaryKey = 'id';
    protected $allowedFields = ['ew_word_pid','origin','unit_grade','mean_num','word_class','mean','is_first_row']; // 적절한 필드를 추가하세요.

    public function getWord($pid = 1)
    {
        return $this->where('id', $pid)->first();
    }

    public function getWord_detailList($ew_word_pid)
    {
        return $this->where('ew_word_pid', $ew_word_pid)
            ->orderBy('id', 'ASC')
            ->findAll();
    }

    //rand 와 limit 동시사용 오류때문에 쿼리빌더 사용못함
    public function getQuery_rand($pid)
    {
        $db = \Config\Database::connect();
        $sql = "SELECT * FROM ew_word_details WHERE ew_word_pid != ? AND is_first_row = 1 AND mean_num = 1 ORDER BY RAND() LIMIT 4";
        $query = $db->query($sql, [$pid]);
        $randomExamples = $query->getResultArray();

        return $randomExamples;
    }


}