Skip to main content

GovernmentFiling

One government-form filing (e.g.

Tablegovernment_filing
Tenant-scopedYes — extends TenantOwned
Columns19
Relationships1
Sourcebackend/src/main/java/com/motorph/payroll/model/GovernmentFiling.java

Columns​

FieldTypeColumnNullNotes
governmentFilingIdIntegergovernment_filing_id—primary key, generated
formTypeStringform_type——
periodYearIntegerperiod_year——
periodMonthIntegerperiod_monthYes—
referenceNumberStringreference_numberYes—
amountPaidBigDecimalamount_paidYes—
filedDateLocalDatefiled_dateYes—
paidDateLocalDatepaid_dateYesThe day the money left.
paymentMethodStringpayment_methodYesBANK_TRANSFER, CASH, CHECK, E_WALLET or OTHER (PaymentMethods).
statusStringstatus—Active or Voided.
voidedAtLocalDateTimevoided_atYes—
voidedByStringvoided_byYes—
voidReasonStringvoid_reasonYes—
remarksStringremarksYes—
receiptFilenameStringreceipt_filenameYes—
receiptContentTypeStringreceipt_content_typeYes—
receiptDatabyte[]receipt_dataYes—
uploadedByStringuploaded_byYes—
createdDateLocalDateTimecreated_dateYes—

Plus tenant_id, inherited from TenantOwned. Hibernate stamps it on insert and adds where tenant_id = ? to every query, so it is never written or read by application code.

Relationships​

FieldKindTargetJoin columnRequired
paidFromAccount@ManyToOnecom.motorph.payroll.accounting.model.Accountpaid_from_account_id—

Repository​

GovernmentFilingRepository​

Declared over GovernmentFiling with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/GovernmentFilingRepository.java

MethodReturnsNotes
findAllMetadataByPeriodYear(@Param("year") int year)List<GovernmentFilingDto>explicit @Query
findAllMetadataByPeriodYearIncludingVoided(@Param("year") int year)List<GovernmentFilingDto>explicit @Query
lockById(@Param("id") Integer id)java.util.Optional<com.motorph.payroll.model.GovernmentFiling>explicit @Query
sumAmountPaid(@Param("formType") String formType, @Param("year") int year, @Param("month") int month)BigDecimalexplicit @Query

Reached by​

These controllers hold — directly or through a service they depend on — a repository over GovernmentFiling.

ControllerBase pathEndpointsModule
GovernmentFilingController/api/government-filings5PH Statutory
GovernmentFormsController/api/government-forms16PH Statutory

Generated page

This page is rebuilt from the source on every docs build by docs-site/scripts/gen-code-wiki.mjs. Editing it has no effect — change the code, or, if what you want to say is prose, write it in docs/.