PHP关于时间date的查询方法

（1）如果是最后一天，则查询本月数据；如果不是，则查询上个月的数据。

	/**
	 * Returns number of locations with Service Only added latest month.
	 * @return mixed
	 */
	function get_total_service_only_latest_month()
	{
		$today = data('Y-m-d');
		$last_day = data('Y-m-t');
		if ($today == $last_day)//this month
		{
			$from = date('Y-m-01') . " 00:00:00";
			$to = $last_day . " 23:59:59";
		} else { //last month
			$from = date('Y-m-01', strtotime('-1 month')) . " 00:00:00";
			$to = date('Y-m-t', strtotime('-1 month')) . " 23:59:59";
		}
		$where = array(
			'offline' => 1,
			'service_only' => 0,
			'service_only_enable_time >=' => $from,
			'service_only_enable_time <=' => $to,
		);
		$query = $this->db->where($where)->get($this->table_name);
		return $query->num_rows();
	}