hero.title.beforehero.title.highlighthero.title.after

import { Entity, PrimaryGeneratedColumn, Column, ManyToOne, OneToMany, JoinColumn } from 'typeorm';
        import { User } from './User';
        import { Department } from './Department';
        import { Product } from './Product';
        import { OrderItem } from './OrderItem';
        
        @Entity()
        export class Order {
          @PrimaryGeneratedColumn()
          id: number;
        
          @Column({ type: 'uuid', nullable: false })
          orderNumber: string;
        
          @Column({ type: 'timestamp', default: () => 'CURRENT_TIMESTAMP' })
          createdAt: Date;
        
          @Column({ type: 'decimal', precision: 10, scale: 2, default: 0 })
          totalAmount: number;
        
          @Column({ type: 'enum', enum: ['pending', 'processing', 'shipped', 'delivered', 'cancelled'], default: 'pending' })
          status: string;
        
          @ManyToOne(() => User, user => user.orders)
          @JoinColumn({ name: 'userId' })
          user: User;
        
          @Column({ nullable: false })
          userId: number;
        
          @ManyToOne(() => Department, department => department.orders)
          @JoinColumn({ name: 'departmentId' })
          department: Department;
          @Column({ nullable: false })
          departmentId: number;
      
        @OneToMany(() => OrderItem, orderItem => orderItem.order, {
          cascade: true,
          eager: true
        })
        items: OrderItem[];
      
        @Column({ type: 'jsonb', nullable: true })
        metadata: any;
      
        async calculateTotal() {
          if (this.items && this.items.length > 0) {
            this.totalAmount = this.items.reduce((sum, item) => {
              return sum + (item.quantity * item.unitPrice);
            }, 0);
          }
        }
      
        validateOrder() {
          if (!this.items || this.items.length === 0) {
            throw new Error('Order must contain at least one item');
          }
          
          if (!this.userId) {
            throw new Error('Order must be associated with a user');
          }
          
          return true;
        }
      }