# bishe

**Repository Path**: h1984958844/bishe

## Basic Information

- **Project Name**: bishe
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2020-11-03
- **Last Updated**: 2021-01-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

城市垃圾分类及处罚系统
游客端： 法律法规，垃圾详细分类，热门问题，处罚记录
只有查询的权力

管理员：对法律法规，垃圾分类，热门问题进行增删改查

执法人员：对处罚记录进行增删改查，

统计： 统计近七天的处罚记录，统计所有处罚记录中个人和单位各占了多少

​			统计各个垃圾的收录统计

​			





统计sql

```mysql
SELECT
Count(record.p_id) AS countid,
record.p_time AS ptime
FROM
record
WHERE
record.p_time BETWEEN '2020-11-12 00:00:00'  AND  '2020-11-14 00:00:00' 
GROUP BY
record.p_time
ORDER BY
ptime ASC





//近七天的
    SELECT
    DATE_FORMAT( p_time, '%Y-%m-%d' ) as countByDay,
    count(*) as countDay
    FROM
    ( SELECT * FROM record
    WHERE DATE_SUB( CURDATE( ), INTERVAL 7 DAY ) <= date(p_time) ) as a
    GROUP BY
    countByDay;
```