this->where('kriteria', 'fakir');
$this->where('zona !=', '0');
$this->select('surveyor, zona, kriteria, area');
$this->selectCount('surveyor', 'count');
$this->selectSum('nilai', 'nilai');
$this->select("CONCAT(surveyor, '_', zona, '_', kriteria, '_', area) as custom_id", false);
$this->groupBy('surveyor');
$this->groupBy('kriteria');
$this->groupBy('area');
$this->orderBy('kriteria', 'ASC');
$this->orderBy('zona', 'ASC');
$this->orderBy('count', 'DESC');

$queryResult = $this->get()->getResult();

$selectedRow = null;

foreach ($queryResult as $row) {
    if (strpos($row->custom_id, 'desired_value') !== false) {
        $selectedRow = $row;
        break;
    }
}

This example uses the CONCAT function to concatenate the values of surveyor, zona, kriteria, and area with underscores to create a custom_id for each row. You can adjust the concatenation logic based on your requirements. In the loop, you can then use any logic to select the desired row based on this custom_id or other criteria.

字符串

要将其转换为一个完整的SQL查询，它看起来像这样：

SELECT surveyor, zona, kriteria, area, COUNT(surveyor) AS count, SUM(nilai) AS nilai
FROM your_table
WHERE kriteria = 'fakir' AND zona != '0'
GROUP BY surveyor, kriteria, area
ORDER BY kriteria ASC, zona ASC, count DESC;

字符串