vue.js - 如何显示前几个月的开始和结束日期？

Question

我在 tbl_transaction 表中有 transaction_date。我想显示客户的所有交易都取决于日期开始和结束日期。我检查它是否有效，并在本月之前搜索上个月，但我得到一个空表，其中包含未定义的名字和姓氏，您可以看到下图。如果我的表中只有一个 transaction_date，我该怎么做？

 public function searchEndAndStartDate() {
     $date_start = date('Y-m-d', strtotime($transaction_date));
     $date_end = date('Y-m-d', strtotime($transaction_date));

    $sql = "SELECT tbl_transaction_details.details_id, 
 tbl_medicine.medicine_name, tbl_transaction_details.quantity, 
 tbl_transaction_details.price, tbl_transaction.transaction_date, 
 tbl_transaction_details.total_price, tbl_user.first_name, 
 tbl_user.last_name FROM tbl_transaction_details INNER JOIN 
 tbl_transaction ON tbl_transaction_details.transaction_id = 
 tbl_transaction.transaction_id INNER JOIN tbl_user ON 
 tbl_transaction.user_id = tbl_user.user_id INNER JOIN tbl_medicine ON 
 tbl_transaction_details.medicine_id = tbl_medicine.medicine_id WHERE 
 transaction_id > :transaction_id AND transaction_date 
 BETWEEN :date_start AND :date_end";

    $stmt = $this->connection->prepare($sql);
    $stmt->execute([
        ":date_start" => $date_start,
        ":date_end" => $date_end
    ]);
    return $stmt->fetchAll();
}

Vue JS 方法

 searchEndAndStartDate : function() {
    axios({
        method : "GET",
        url : this.urlRoot + "gulod/search_date.php?keyword=",
        params : {
            keyword : this.start_date,
            keyword : this.end_date
        }
    }).then(function (response){
        vm.gulod_transaction_details = response.data;
        console.log(response);
    });
},

标签： vue.jspdo