Codeigniter 显示产品有效期而不是库存

Question

我想代替库存提醒产品，显示到期日期提醒产品。

<?php

                foreach ($stock as $item) {

                    echo '<li class="list-group-item"><span class="badge badge-danger float-xs-right">' . +$item['qty'] . ' ' . $item['unit'] . '</span> <a href="' . base_url() . 'products/edit?id=' . $item['pid'] . '">' . $item['product_name'] . '  </a><small class="purple"> <i class="ft-map-pin"></i> ' . $item['title'] . '</small>

                            </li>';

                } ?>

和

    public function stock()

{

    $whr = '';

            if ($this->aauth->get_user()->loc) {

     $whr = ' AND (lmpos_warehouse.loc=' . $this->aauth->get_user()->loc . ')';

    } elseif (!BDATA) {

     $whr = ' AND (lmpos_warehouse.loc=0)';

    }

    $query = $this->db->query("SELECT lmpos_products.*,lmpos_warehouse.title FROM lmpos_products LEFT JOIN lmpos_warehouse ON lmpos_products.warehouse=lmpos_warehouse.id  WHERE (lmpos_products.qty<=lmpos_products.alert) $whr ORDER BY lmpos_products.product_name ASC LIMIT 10");

    return $query->result_array();

}

注意：在数据库中的产品表中，每个产品都有一个有效期

您可以在这张照片中看到当前结果

Answer 1

例如，您有一个名为 的到期日期的数据库表列exp，只需将徽章代码从更改+$item['qty'] . ' ' . $item['unit']为date("F jS, Y", strtotime($item['exp'])：&nbsp; &nbsp; foreach ($stock as $item) {&nbsp; &nbsp; &nbsp; &nbsp; echo '<li class="list-group-item"><span class="badge badge-danger float-xs-right">' . date("F jS, Y", strtotime($item['exp']) . '</span> <a href="' . base_url() . 'products/edit?id=' . $item['pid'] . '">' . $item['product_name'] . '&nbsp; </a><small class="purple"> <i class="ft-map-pin"></i> ' . $item['title'] . '</small>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </li>';&nbsp; &nbsp; }这将以人类可读的格式显示到期日期