employee

Documentation

Index

• Constants
• type Employee
• type EmployeeInboundOrders
• type EmployeeOrderCount
• type Repository
  • func NewRepository(db *sql.DB) Repository
• type Services
  • func NewService(r Repository) Services

Constants

const (
	SqlGetAll = "SELECT * FROM employees"

	SqlGetById = "SELECT * FROM employees WHERE id=?"

	SqlCreate = "INSERT INTO employees (`card_number_id`, `first_name`, `last_name`, `warehouse_id`) VALUES (?, ?, ?, ?)"

	SqlUpdateFirstName = "UPDATE employees SET first_name=? WHERE id=?"

	SqlUpdate = "UPDATE employees SET first_name=?, last_name=?, warehouse_id=? WHERE id=?"

	SqlDelete = "DELETE FROM employees WHERE id=?"
)

Types

type Employee

type Employee struct {
	ID          int    `json:"id"`
	CardNumber  int    `json:"card_number_id"`
	FirstName   string `json:"first_name"`
	LastName    string `json:"last_name"`
	WareHouseID int    `json:"warehouse_id"`
}

type EmployeeInboundOrders

type EmployeeInboundOrders struct {
	ID                 int    `json:"id"`
	CardNumber         int    `json:"card_number_id"`
	FirstName          string `json:"first_name"`
	LastName           string `json:"last_name"`
	WareHouseID        int    `json:"warehouse_id"`
	InboundOrdersCount int    `json:"inbound_orders_count"`
}

type EmployeeOrderCount

type EmployeeOrderCount struct {
	ID          int    `json:"id"`
	CardNumber  int    `json:"card_number_id"`
	FirstName   string `json:"first_name"`
	LastName    string `json:"last_name"`
	WareHouseID int    `json:"warehouse_id"`
	Count       int    `json:"inbound_orders_count"`
}

type Repository

type Repository interface {
	Create(cardNum int, firstName string, lastName string, warehouseId int) (Employee, error)
	GetAll() ([]Employee, error)
	Delete(id int) error
	GetById(id int) (Employee, error)
	Update(id int, firstName string, lastName string, warehouseId int) (Employee, error)
}

func NewRepository

func NewRepository(db *sql.DB) Repository

type Services

type Services interface {
	Create(cardNum int, firstName string, lastName string, warehouseId int) (Employee, error)
	GetAll() ([]Employee, error)
	Delete(id int) error
	GetById(id int) (Employee, error)
	Update(emp Employee, id int) (Employee, error)
	GetCount(id, counter int) (EmployeeOrderCount, error)
}

func NewService

func NewService(r Repository) Services