php - 无论codeigniter中的排序如何,我都希望顶部的特定记录集
问题描述
以下函数以二维数组格式返回所有玩家。以下是功能:-
public function get_football_players($type = FOOTBALL_TEXT, $filter = '', $start = '', $limit = '', $player = '') {
$this->db->select('tblmarkets_football.*, tblmarkets.symbol, tblmarkets.type');
$this->db->from('tblmarkets_football');
$this->db->join('tblmarkets','tblmarkets.id = tblmarkets_football.market_id','left');
if($type != ''){
$this->db->where('type', $type);
}
$this->db->where('active', 1);
switch ($filter) {
case 'forward':
$this->db->where('position', 'Forward');
break;
case 'midfielders':
$this->db->where('position', 'Midfielder');
break;
case 'defenders':
$this->db->where('position', 'Defender');
break;
case 'goalkeepers':
$this->db->where('position', 'Goalkeeper');
break;
case 'highest_price':
case 'lowest_price':
$tmp = $this->external_api_model->get_filtered_football_pairs($limit, $start, $filter);
$players = json_decode($tmp, true);
$this->db->where_in('symbol', $players);
break;
}
if($player != ''){
$this->db->like('tblmarkets_football.name', $player);
}
if($filter != 'highest_price' && $filter != 'lowest_price'){
$this->db->limit($limit, $start);
}
$result = $this->db->get()->result();
return $result;
}
当有人应用最高价格过滤器时,get_filtered_football_pairs api 会以数组格式返回所有球员。我希望所有这些球员都按照我收到的顺序显示在顶部。$players
有所有球员的名字。目前它们是随机显示的。
任何帮助将不胜感激。提前致谢。
编辑
$players 将如下所示:-
Array
(
[0] => paul-pogba
[1] => neymar
[2] => kylian-mbappé
[3] => lionel-messi
[4] => jadon-sancho
[5] => eden-hazard
[6] => marcus-rashford
[7] => mohamed-salah
[8] => harry-kane
[9] => vinicius-junior
[10] => callum-hudson-odoi
[11] => raheem-sterling
[12] => ousmane-dembele
[13] => anthony-martial
[14] => paulo-dybala
[15] => gareth-bale
[16] => joshua-kimmich
[17] => cristiano-ronaldo
[18] => kai-havertz
[19] => leroy-sané
)
我希望按照这个顺序,这意味着首先它会显示保罗-博格巴,然后是内马尔等等。
解决方案
这是未经测试的,但逻辑是您转义$player
数组中的元素,然后将优先处理应用于合格symbol
值,然后将二级排序顺序提供为symbol
升序(否则在将玩家与非玩家分开后让事情变得随机.
case 'highest_price':
case 'lowest_price':
$tmp = $this->external_api_model->get_filtered_football_pairs($limit, $start, $filter);
$players = json_decode($tmp, true);
$this->db->where_in('symbol', $players);
foreach ($players as &$p) {
$p = "'" . $this->db->escape_str($p) . "'";
}
$this->db->order_by("IF(FIELD(symbol," . implode(",", $players) . ")=0,1,0),
FIELD(symbol," . implode(",", $players) . ")");
break;
这是一个 db-fiddle 演示,展示了如何执行排序:https ://www.db-fiddle.com/f/9yxTo3nEHCu9vLPW6MELy3/1
为了帮助理解我的技术:https ://dba.stackexchange.com/a/109126/157408
为了解释0,1
条款的一部分...
它将$players
非$players
. 所有$players
将在0
组中,非$players
将在1
组中。然后二次排序将按$players
您喜欢的顺序排列(打破0
平局)。
ps 我认为为空字符串设置默认值是不明智的$start
——$limit
数值似乎更适合。
我通常会尽量远离 switch 块,因为我觉得这太冗长了。另一种风格可能看起来像这样(根据您的预期输入和逻辑要求,您可以进一步简化它):
if (in_array($filter, ['forward', 'midfielders', 'defenders', 'goalkeepers'])) {
$this->db->where('position', ucfirst(rtrim($filter, 's')));
}
if (in_array($filter, ['highest_price', 'lowest_price'])) {
$tmp = $this->external_api_model->get_filtered_football_pairs($limit, $start, $filter);
$players = json_decode($tmp, true);
$this->db->where_in('symbol', $players);
foreach ($players as &$p) {
$p = "'" . $this->db->escape_str($p) . "'";
}
$this->db->order_by("IF(FIELD(symbol," . implode(",", $players) . ")=0,1,0),
FIELD(symbol," . implode(",", $players) . ")");
} else {
$this->db->limit($limit, $start);
}
if ($player != '') {
$this->db->like('tblmarkets_football.name', $player);
}
推荐阅读
- tensorflow - 在 PASCALVOC 上从模型动物园微调 EfficientDet-D0 无法识别类别标签 1(TensorFlow 对象检测 API)
- html - 将鼠标悬停在第一个孩子无法正常工作的链接上
- vue.js - 如何将本机引导程序 5 js(modal) 连接到 nuxt.js?
- machine-learning - 如何使用 FastText 查找相似的句子(词汇不足的句子)
- multithreading - 延迟初始化和可变静态借用 [Rust]
- git - 在 git diff 中,我可以只显示没有添加的删除吗?
- ruby - 为什么/如何`gem fetch -s $source`与Bundler的`source`语句不同?
- ssl - twilio 为有效的 ssl 证书提供错误
- npm - Npm 工作区:用于开发和发布的不同“主要”属性?
- github - 如何在 github CI/CD 管道中制作工作 dotnet-lambda 工具?