45 lines
1.7 KiB
Go
45 lines
1.7 KiB
Go
package publicreport
|
|
|
|
import (
|
|
"context"
|
|
"fmt"
|
|
|
|
"github.com/Gleipnir-Technology/bob"
|
|
"github.com/Gleipnir-Technology/bob/dialect/psql"
|
|
"github.com/Gleipnir-Technology/bob/dialect/psql/sm"
|
|
//"github.com/Gleipnir-Technology/nidus-sync/config"
|
|
"github.com/Gleipnir-Technology/nidus-sync/db"
|
|
"github.com/Gleipnir-Technology/nidus-sync/db/models"
|
|
"github.com/Gleipnir-Technology/nidus-sync/platform/types"
|
|
//"github.com/google/uuid"
|
|
//"github.com/rs/zerolog/log"
|
|
"github.com/stephenafamo/scan"
|
|
)
|
|
|
|
func compliance(ctx context.Context, public_id string, report types.PublicReport) (*types.PublicReportCompliance, error) {
|
|
row, err := bob.One(ctx, db.PGInstance.BobDB, psql.Select(
|
|
sm.Columns(
|
|
models.PublicreportCompliances.Columns.AccessInstructions,
|
|
models.PublicreportCompliances.Columns.AvailabilityNotes,
|
|
models.PublicreportCompliances.Columns.Comments,
|
|
models.PublicreportCompliances.Columns.GateCode,
|
|
models.PublicreportCompliances.Columns.HasDog,
|
|
models.PublicreportCompliances.Columns.PermissionType,
|
|
models.PublicreportCompliances.Columns.ReportID,
|
|
models.PublicreportCompliances.Columns.ReportPhoneCanText,
|
|
models.PublicreportCompliances.Columns.Submitted,
|
|
models.PublicreportCompliances.Columns.WantsScheduled,
|
|
),
|
|
//sm.From(psql.Quote("publicreport", "compliance")).As("publicreport.compliance"),
|
|
sm.From(models.PublicreportCompliances.NameAs()),
|
|
sm.Where(models.PublicreportCompliances.Columns.ReportID.EQ(
|
|
psql.Arg(report.ID),
|
|
)),
|
|
), scan.StructMapper[types.PublicReportCompliance]())
|
|
if err != nil {
|
|
return nil, fmt.Errorf("query compliance: %w", err)
|
|
}
|
|
copyReportContent(report, &row.PublicReport)
|
|
return &row, nil
|
|
|
|
}
|