# lottery-server

**Repository Path**: anyonetff/lottery-server

## Basic Information

- **Project Name**: lottery-server
- **Description**: No description available
- **Primary Language**: NodeJS
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 1
- **Created**: 2018-01-05
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 年终抽奖转盘后台服务

## 概述

## 环境安装

安装PostgreSQL数据库，并创建名为“lottery_”的数据库！修改ormconfig.json中的数据库登录密码。
```
"username": "postgres",
"password": "[密码]",
"database": "lottery_"
```

安装nodejs环境，请移步nodejs.org下载最新的node构建环境，再安装翻墙软件（或cnpm淘宝镜像）。

安装typescript依赖库：
```
npm install -g typescript
```

进入项目目录，安装项目依赖库：
```
cd lottery-server
npm install lottery-server
```

## 运行方式

点击工程目录中的run.bat即可启动后台服务，后台服务会监听8090端口！
后台服务启动后会自动创建数据表，但现在数据库里没东西，所以无法进行抽奖。

## 数据库初始化

活动管理表bingo:
```sql
INSERT INTO lottery.l_bingo(
	b_uid, b_code, b_title, b_author, b_date, b_content, b_sign_begin, b_sign_end, b_attend_begin, b_attend_end, b_desc, b_current)
	VALUES ('A', '123', '测试活动', '', '2018-01-01', '测试抽奖活动', 
            '2018-01-01', '2018-01-31', '2018-01-01', '2018-01-31', 
            '测试活动', true);
```

奖项设置prize
```sql
INSERT INTO lottery.l_prize(
	p_bid, p_pid, p_name, p_worth, p_detail, p_picture, p_amount)
	VALUES ('A', 1, '一等奖', 10000, '梦幻枕头威力加强版', 'none.png', 1);
INSERT INTO lottery.l_prize(
	p_bid, p_pid, p_name, p_worth, p_detail, p_picture, p_amount)
	VALUES ('A', 2, '二等奖', 5000, '梦幻枕头', 'none.png', 2);
```

参与人员表member
```sql
INSERT INTO lottery.l_member(
	m_uid, m_code, m_name, m_sex, 
    m_organization, m_department, m_title, m_phone, m_picture, 
    m_join, m_quit, m_valid, m_position)
	VALUES ('0000001', '01', '路飞', '', 
            '', '', '', '', '', 
            '2018-01-01', '2018-12-31', true, 1);
INSERT INTO lottery.l_member(
	m_uid, m_code, m_name, m_sex, 
    m_organization, m_department, m_title, m_phone, m_picture, 
    m_join, m_quit, m_valid, m_position)
	VALUES ('0000002', '02', '乔巴', '', 
            '', '', '', '', '', 
            '2018-01-01', '2018-12-31', true, 1);
```

中奖名单winner，抽奖后会生成数据