时间戳

首页 > 解决方案 > Codeigniter 按今天的价格和字段查询顶级商店

codeigniter - Codeigniter 按今天的价格和字段查询顶级商店

问题描述

我是codeigniter的初学者。我有一个这样的查询，我想在 codeigniter 中使用这个查询我想通过 total_price 获取顶级 store_name

+---+------------+-------------+-------------+---------------------+
| id| store_name |  quality    | total_price |     time            |
+---+------------+-------------+-------------+---------------------+
| 1 | store_a    |     2       |   300       | 2019-06-19 08:20:57 | 
| 2 | store_b    |     1       |   100       | 2019-06-20 08:30:57 |
| 3 | store_c    |     4       |   50        | 2019-06-20 08:33:57 |
| 4 | store_b    |     2       |   300       | 2019-06-20 08:35:57 |
+---+------------+-------------+-------------+---------------------+

我试过

$this->db->select('store_name, SUM(total_price) AS  t_price', false);
$this->db->group_by('store_name');
$query = $this->db->get($this->table_name);

return $query->result();

我今天需要按日期时间输出

    +------------+-------------+-------------+---------------------+
    | store_name |  quality    | total_price |     time            |
    +------------+-------------+-------------+---------------------+
    | store_b    |     3       |   400       | 2019-06-20 08:30:57 |
    | store_c    |     4       |   50        | 2019-06-20 08:33:57 |

为我更新工作

    $date = new DateTime("now");
    $curr_date = $date->format('Y-m-d ');

    $this->db->select('store_name, SUM(total_price) AS  total_price ,SUM(quality) AS    quality', false);
    $this->db->group_by('store_name');
    $this->db->where('DATE(time)',$curr_date);
    $this->db->order_by('total_price', "DESC");
    $query = $this->db->get($this->table_name);


    return $query->result();

标签： codeigniter

解决方案

您可以针对您的问题尝试此解决方案：

$date = new DateTime("now");
$curr_date = $date->format('Y-m-d ');

$this->db->select('store_name, SUM(total_price) AS  total_price ,SUM(quality) AS    quality', false);
$this->db->where('DATE(time)',$curr_date);
$this->db->group_by('store_name');
$this->db->order_by('total_price', "DESC");
$query = $this->db->get($this->table_name);


return $query->result();

它会对你有所帮助。

推荐阅读