1
import { Controller, Get, Post, Body, Param, Put, Delete } from '@nestjs/common';
2
import { ProjectsService } from './projects.service';
3
import { ProjectsDto } from '../entities/DTO/projects.dto';
4

5
@Controller('projects')
6
export class ProjectsController {
7
  constructor(private readonly projectsService: ProjectsService) {}
8

9
  @Get()
10
  findAll() {
11
    return this.projectsService.findAll();
12
  }
13

14
  @Get(':id')
15
  findOne(@Param('id') id: number) {
16
    return this.projectsService.findOne(id);
17
  }
18

19
  @Post()
20
  create(@Body() projectDto: ProjectsDto) {
21
    return this.projectsService.create(projectDto);
22
  }
23

24
  @Put(':id')
25
  update(@Param('id') id: number, @Body() projectDto: ProjectsDto) {
26
    return this.projectsService.update(id, projectDto);
27
  }
28

29
  @Delete(':id')
30
  delete(@Param('id') id: number) {
31
    return this.projectsService.delete(id);
32
  }
33
}

1
import { Injectable } from '@nestjs/common';
2
import { DataSource } from 'typeorm';
3
import { Project } from '../entities/projects.entity';
4
import { ProjectsDto } from '../entities/DTO/projects.dto';
5

6
@Injectable()
7
export class ProjectsService {
8
  constructor(private dataSource: DataSource) {}
9

10
  findAll() {
11
    return this.dataSource.getRepository(Project).find();
12
  }
13

14
  findOne(id: number) {
15
    return this.dataSource.getRepository(Project).findOneBy({ project_id: id });
16
  }
17

18
  create(project: ProjectsDto) {
19
    return this.dataSource.getRepository(Project).save(project);
20
  }
21

22
  update(id: number, project: ProjectsDto) {
23
    return this.dataSource.getRepository(Project).update(id, project);
24
  }
25

26
  delete(id: number) {
27
    return this.dataSource.getRepository(Project).delete(id);
28
  }
29
}

1
import { Entity, Column, PrimaryGeneratedColumn } from 'typeorm';
2

3
@Entity()
4
export class Project {
5
  @PrimaryGeneratedColumn()
6
  project_id: number;
7

8
  @Column()
9
  title: string;
10

11
  @Column()
12
  description: string;
13

14
  @Column('decimal')
15
  budget_min: number;
16

17
  @Column('decimal')
18
  budget_max: number;
19

20
  @Column('date')
21
  deadline: Date;
22

23
  @Column({ default: 'open' })
24
  status: string;
25
}

1
<div class="project-detail">
2
  <div *ngIf="loading" class="loading">
3
    ロード中...
4
  </div>
5

6
  <div *ngIf="error" class="error">
7
    {{ error }}
8
  </div>
9

10
  <div *ngIf="project && !loading" class="project-info">
11
    <h2>{{ project.title }}</h2>
12
    <div class="project-meta">
13
      <p>予算: ¥{{ project.budget_min }} - ¥{{ project.budget_max }}</p>
14
      <p>締め切り: {{ project.deadline | date }}</p>
15
      <p>ステータス: {{ project.status }}</p>
16
    </div>
17

18
    <div class="project-description">
19
      <h3>プロジェクトの説明</h3>
20
      <p>{{ project.description }}</p>
21
    </div>
22

23
    <app-bid-form
24
      *ngIf="userRole === 'bidder' && project.status === 'open'"
25
      [projectId]="project.project_id"
26
      (bidSubmitted)="loadBids(project.project_id)">
27
    </app-bid-form>
28

29
    <div class="bids-section" *ngIf="userRole === 'client' || userRole === 'admin'">
30
      <h3>入札リスト</h3>
31
      <div *ngFor="let bid of bids" class="bid-card">
32
        <p>入札者: {{ bid.bidder_id }}</p>
33
        <p>入札額: ¥{{ bid.amount }}</p>
34
        <p>入札説明: {{ bid.message }}</p>
35
        <p>状態: {{ bid.status }}</p>
36
      </div>
37
    </div>
38
  </div>
39
</div>

1
"scripts": {
2
  "test": "jest",
3
  "test:watch": "jest --watch",
4
  "test:cov": "jest --coverage"
5
},
6
"jest": {
7
  "moduleFileExtensions": ["js", "json", "ts"],
8
  "rootDir": "src",
9
  "testRegex": ".*\\\\.spec\\\\.ts$",
10
  "transform": {
11
    "^.+\\\\.(t|j)s$": "ts-jest"
12
  },
13
  "collectCoverageFrom": [
14
    "**/*.(t|j)s"
15
  ],
16
  "coverageDirectory": "../coverage",
17
  "testEnvironment": "node"
18
}

1
import { Test, TestingModule } from '@nestjs/testing';
2
import { ProjectsService } from './projects.service';
3

4
describe('ProjectsService', () => {
5
  let service: ProjectsService;
6

7
  beforeEach(async () => {
8
    const module: TestingModule = await Test.createTestingModule({
9
      providers: [ProjectsService],
10
    }).compile();
11

12
    service = module.get<ProjectsService>(ProjectsService);
13
  });
14

15
  it('should be defined', () => {
16
    expect(service).toBeDefined();
17
  });
18

19
  describe('findOne', () => {
20
    it('应该返回单个项目', async () => {
21
      const result = await service.findOne(1);
22
      expect(result).toEqual(mockProject);
23
    });
24
  });
25
});

1
module.exports = {
2
  parser: '@typescript-eslint/parser',
3
  parserOptions: {
4
    project: 'tsconfig.json',
5
    sourceType: 'module',
6
  },
7
  plugins: ['@typescript-eslint/eslint-plugin'],
8
  extends: [
9
    'plugin:@typescript-eslint/recommended',
10
    'plugin:prettier/recommended',
11
  ],
12
  root: true,
13
  env: {
14
    node: true,
15
    jest: true,
16
  },
17
  rules: {
18
    '@typescript-eslint/interface-name-prefix': 'off',
19
    '@typescript-eslint/explicit-function-return-type': 'off',
20
    '@typescript-eslint/explicit-module-boundary-types': 'off',
21
    '@typescript-eslint/no-explicit-any': 'off',
22
  },
23
};

1
"scripts": {
2
  "lint": "eslint . --ext .ts"
3
}

1
name: CI/CD Pipeline
2

3
on:
4
  push:
5
    branches:
6
      - main
7
  pull_request:
8
    branches:
9
      - main
10

11
jobs:
12
  build:
13
    runs-on: ubuntu-latest
14

15
    steps:
16
    - name: Checkout code
17
      uses: actions/checkout@v2
18

19
    - name: Set up Node.js
20
      uses: actions/setup-node@v2
21
      with:
22
        node-version: '20.18.0'
23

24
    - name: Install dependencies
25
      run: |
26
        cd backend
27
        npm install
28
        cd ../frontend
29
        npm install
30

31
    - name: Run tests
32
      run: |
33
        cd backend
34
        npm run test:cov
35
        cd ../frontend
36
        npm run test
37

38
    - name: Lint code
39
      run: |
40
        cd backend
41
        npm run lint
42
        cd ../frontend
43
        npm run lint
44

45
    - name: Build project
46
      run: |
47
        cd backend
48
        npm run build
49
        cd ../frontend
50
        npm run build
51

52
    - name: Create Release Package
53
      run: |
54
        mkdir -p build
55
        cd backend
56
        tar -czvf ../build/backend.tar.gz dist
57
        cd ../frontend
58
        tar -czvf ../build/frontend.tar.gz dist
59
        cd ..
60

61
    - name: Deploy to DigitalOcean
62
      uses: digitalocean/action-doctl@v2
63
      with:
64
        token: ${{ secrets.DIGITALOCEAN_ACCESS_TOKEN }}
65
      run: |
66
        # 部署脚本或命令