申请表getAll接口可以根据通行证状态查询

guoshilong

2023-01-02 c864fec5f798a1aabcde877469886dd0dc90d092

申请表getAll接口可以根据通行证状态查询

 src/main/java/org/springblade/modules/application/mapper/ApplicationMapper.xml

@@ -60,6 +60,7 @@
        FROM sys_application app
        LEFT JOIN sys_application_basic_info basic ON basic.application_id = app.id
        LEFT JOIN sys_application_car car ON car.application_id = app.id AND car.status = 1
        LEFT JOIN sys_pass pass ON pass.no = app.no AND pass.is_deleted = 0
        WHERE app.is_deleted = 0
        <if test="application.userId !=null and application.userId !=''">
            AND app.user_id = #{application.userId}
@@ -67,6 +68,9 @@
        <if test="application.status !=null and application.status !=''">
            AND app.status = #{application.status}
        </if>
        <if test="application.passStatus != null and application.passStatus !=''">
            AND pass.status = #{application.passStatus}
        </if>
    </select>



 src/main/java/org/springblade/modules/application/vo/ApplicationVO.java

@@ -78,4 +78,9 @@
     * 通行结束时间
     */
    private String endPassTime;

    /**
     * 通行证状态
     */
    private String passStatus;
}

 src/main/java/org/springblade/modules/pass/entity/PassEntity.java

@@ -37,11 +37,6 @@
public class PassEntity extends TenantEntity {

    /**
     * 名字
     */
    @ApiModelProperty(value = "名字")
    private String name;
    /**
     * 编号
     */
    @ApiModelProperty(value = "编号")

 src/main/resources/application-dev.yml

@@ -13,7 +13,7 @@
    #  commandTimeout: 5000
  datasource:
    # MySql
    url: jdbc:mysql://192.168.0.116:3306/approval-system?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
    url: jdbc:mysql://localhost:3306/approval-system?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
    username: root
    password: 123456
    # PostgreSQL