mysql

type BranchRepository struct {
	// contains filtered or unexported fields
}

type ClientRepository struct {
	// contains filtered or unexported fields
}

type GetClientAdminsReportDataParams struct {
	EndDate   time.Time `json:"end_date"`
	StartDate time.Time `json:"start_date"`
}

type GetClientAdminsReportDataRow struct {
	Name           string         `json:"name"`
	BranchName     sql.NullString `json:"branch_name"`
	TotalLoanGiven int64          `json:"total_loan_given"`
	DefaultedLoans int64          `json:"defaulted_loans"`
	ActiveLoans    int64          `json:"active_loans"`
	CompletedLoans int64          `json:"completed_loans"`
	InactiveLoans  int64          `json:"inactive_loans"`
	Overpayment    float64        `json:"overpayment"`
	PhoneNumber    string         `json:"phone_number"`
	TotalPaid      interface{}    `json:"total_paid"`
	TotalDisbursed interface{}    `json:"total_disbursed"`
	TotalOwed      interface{}    `json:"total_owed"`
	RateScore      interface{}    `json:"rate_score"`
	DefaultRate    interface{}    `json:"default_rate"`
}

type GetClientClientsReportDataParams struct {
	StartDate time.Time `json:"start_date"`
	EndDate   time.Time `json:"end_date"`
	ID        uint32    `json:"id"`
}

type GetClientClientsReportDataRow struct {
	Name          string         `json:"name"`
	PhoneNumber   string         `json:"phone_number"`
	IDNumber      sql.NullString `json:"id_number"`
	Dob           sql.NullTime   `json:"dob"`
	BranchName    sql.NullString `json:"branch_name"`
	AssignedStaff sql.NullString `json:"assigned_staff"`
	Active        bool           `json:"active"`
	Loans         interface{}    `json:"loans"`
	Payments      interface{}    `json:"payments"`
}

type GetLoanEventsRow struct {
	LoanID        uint32          `json:"loan_id"`
	DisbursedDate sql.NullTime    `json:"disbursed_date"`
	DueDate       sql.NullTime    `json:"due_date"`
	ClientName    string          `json:"client_name"`
	LoanAmount    float64         `json:"loan_amount"`
	PaymentDue    sql.NullFloat64 `json:"payment_due"`
}

type GetLoanReportDataByIdRow struct {
	LoanID                uint32      `json:"loan_id"`
	ClientName            string      `json:"client_name"`
	LoanAmount            float64     `json:"loan_amount"`
	RepayAmount           float64     `json:"repay_amount"`
	PaidAmount            float64     `json:"paid_amount"`
	Status                string      `json:"status"`
	TotalInstallments     int64       `json:"total_installments"`
	PaidInstallments      int64       `json:"paid_installments"`
	RemainingInstallments int64       `json:"remaining_installments"`
	InstallmentDetails    interface{} `json:"installment_details"`
}

type GetLoansReportDataParams struct {
	StartDate time.Time `json:"start_date"`
	EndDate   time.Time `json:"end_date"`
}

type GetLoansReportDataRow struct {
	LoanID            uint32       `json:"loan_id"`
	ClientName        string       `json:"client_name"`
	BranchName        string       `json:"branch_name"`
	LoanOfficer       string       `json:"loan_officer"`
	LoanAmount        float64      `json:"loan_amount"`
	RepayAmount       float64      `json:"repay_amount"`
	PaidAmount        float64      `json:"paid_amount"`
	OutstandingAmount interface{}  `json:"outstanding_amount"`
	Status            string       `json:"status"`
	TotalInstallments uint32       `json:"total_installments"`
	PaidInstallments  int64        `json:"paid_installments"`
	DueDate           sql.NullTime `json:"due_date"`
	DisbursedDate     sql.NullTime `json:"disbursed_date"`
	DefaultRisk       interface{}  `json:"default_risk"`
}

type GetProductReportDataParams struct {
	StartDate time.Time `json:"start_date"`
	EndDate   time.Time `json:"end_date"`
}

type GetProductReportDataRow struct {
	ProductName            string      `json:"product_name"`
	TotalLoansIssued       int64       `json:"total_loans_issued"`
	TotalAmountDisbursed   interface{} `json:"total_amount_disbursed"`
	TotalAmountRepaid      interface{} `json:"total_amount_repaid"`
	TotalOutstandingAmount interface{} `json:"total_outstanding_amount"`
	ActiveLoans            int64       `json:"active_loans"`
	CompletedLoans         int64       `json:"completed_loans"`
	DefaultedLoans         int64       `json:"defaulted_loans"`
	DefaultRate            interface{} `json:"default_rate"`
}

type GetUserAdminsReportDataParams struct {
	StartDate time.Time `json:"start_date"`
	EndDate   time.Time `json:"end_date"`
}

type GetUserAdminsReportDataRow struct {
	Name              string         `json:"name"`
	Role              string         `json:"role"`
	BranchName        sql.NullString `json:"branch_name"`
	ApprovedLoans     int64          `json:"approved_loans"`
	ActiveLoans       int64          `json:"active_loans"`
	CompletedLoans    int64          `json:"completed_loans"`
	DefaultRate       interface{}    `json:"default_rate"`
	ClientsRegistered int64          `json:"clients_registered"`
	PaymentsAssigned  int64          `json:"payments_assigned"`
}

type GetUserUsersReportDataParams struct {
	StartDate time.Time `json:"start_date"`
	EndDate   time.Time `json:"end_date"`
	ID        uint32    `json:"id"`
}

type GetUserUsersReportDataRow struct {
	Name                   string         `json:"name"`
	Role                   string         `json:"role"`
	Branch                 sql.NullString `json:"branch"`
	TotalClientsHandled    int64          `json:"total_clients_handled"`
	LoansApproved          int64          `json:"loans_approved"`
	TotalLoanAmountManaged interface{}    `json:"total_loan_amount_managed"`
	TotalCollectedAmount   interface{}    `json:"total_collected_amount"`
	DefaultRate            interface{}    `json:"default_rate"`
	AssignedPayments       int64          `json:"assigned_payments"`
	AssignedLoans          interface{}    `json:"assigned_loans"`
	AssignedPaymentsList   interface{}    `json:"assigned_payments_list"`
}

type HelperRepository struct {
	// contains filtered or unexported fields
}

type LoanRepository struct {
	// contains filtered or unexported fields
}

type MySQLRepo struct {
	Branches  repository.BranchRepository
	Loans     repository.LoansRepository
	Products  repository.ProductRepository
	Users     repository.UserRepository
	Clients   repository.ClientRepository
	NonPosted repository.NonPostedRepository
	Helpers   repository.HelperRepository
}

type NonPostedRepository struct {
	// contains filtered or unexported fields
}

type ProductRepository struct {
	// contains filtered or unexported fields
}

type Store struct {
	NewQuerierFn func(tx *sql.Tx) generated.Querier
	// contains filtered or unexported fields
}

type UserRepository struct {
	// contains filtered or unexported fields
}