import {
  Column,
  DataType,
  Table,
  Model,
  ForeignKey,
  BelongsTo,
  HasOne,
} from 'sequelize-typescript';
import { OrderModel } from './order.entity';
import { ServiceItemModel } from './service-item.entity';

@Table({
  tableName: 'order_Item',
  timestamps: false,
})
export class OrderItemModel extends Model {
  @Column({
    primaryKey: true,
    allowNull: false,
    type: DataType.STRING(30),
  })
  ItemId: string;

  @ForeignKey(() => OrderModel)
  @Column({
    allowNull: false,
    type: DataType.STRING(30),
  })
  OrderNo: string;

  @Column({
    allowNull: false,
    type: DataType.STRING(50),
  })
  ItemType: string;

  @Column({
    type: DataType.CHAR(3),
    allowNull: false,
  })
  Currency: string;

  @Column({
    type: DataType.DECIMAL(10, 2),
    allowNull: false,
  })
  SalePrice: number;

  @Column({
    type: DataType.DECIMAL(10, 2),
    allowNull: false,
  })
  RetailPrice: number;

  @Column({
    type: DataType.DECIMAL(10, 2),
    allowNull: true,
  })
  TaxAmount: number;

  @Column({
    type: DataType.CHAR(2),
    allowNull: true,
  })
  TaxCode: string;

  @Column({
    type: DataType.DECIMAL(10, 2),
    allowNull: true,
  })
  TaxRate: number;

  @Column({
    type: DataType.STRING(50),
  })
  SerialNo: string;

  @Column({
    type: DataType.STRING(50),
  })
  BatchNo: string;

  @Column({
    type: DataType.STRING(100),
  })
  Description: string;

  @Column({
    type: DataType.STRING(100),
  })
  Name: string;

  @Column({
    type: DataType.INTEGER,
  })
  Quantity: number;

  @BelongsTo(() => OrderModel)
  Order: OrderModel;

  @HasOne(() => ServiceItemModel)
  ServiceItem: ServiceItemModel;
}