我怎样才能生成月度和年度报告？ [英] How could I generate monthly and annuall reports?

问题描述

public function daily_sales($date)
	{
		$sql = "SELECT *
				FROM sales
				WHERE DATE(`sale_date_paid`) = ?
				ORDER BY sale_date_paid DESC";
		return $this->getRows($sql, [$date]);
	}//end daily_sales

我尝试过：

What I have tried:

public function daily_sales($date)
	{
		$sql = "SELECT *
				FROM sales
				WHERE DATE(`sale_date_paid`) = ?
				ORDER BY sale_date_paid DESC";
		return $this->getRows($sql, [$date]);
	}//end daily_sales

	public function monthly_sales($date){
		//kailangan ma pasa rito yung month at year
		$sql = "SELECT * FROM `sales` WHERE `sales`.`sale_date_paid` LIKE '$date%'";
		return $this->getRows($sql,[$date]);
	}

推荐答案

date）
{

date) {

sql = SELECT *
FROM sales
WHERE DATE（`sale_date_paid`）=？
ORDER BY sale_date_paid DESC;
return

this-> getRows（

this->getRows(

这篇关于我怎样才能生成月度和年度报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！