From 83280d90d12545d36a301c437c7d9095f190aac3 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 21 六月 2021 08:54:16 +0800
Subject: [PATCH] 算工资
---
考勤计算的表.sql | 120 ++++++++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 104 insertions(+), 16 deletions(-)
diff --git "a/\350\200\203\345\213\244\350\256\241\347\256\227\347\232\204\350\241\250.sql" "b/\350\200\203\345\213\244\350\256\241\347\256\227\347\232\204\350\241\250.sql"
index 02e1343..014e69f 100644
--- "a/\350\200\203\345\213\244\350\256\241\347\256\227\347\232\204\350\241\250.sql"
+++ "b/\350\200\203\345\213\244\350\256\241\347\256\227\347\232\204\350\241\250.sql"
@@ -1,27 +1,113 @@
USE [zhengcaioa]
GO
+/****** Object: Table [dbo].[hr_salary] Script Date: 2021/6/10 12:54:34 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='hr_salary') --查询表名costSeparateConfig是否存在
+
+
+drop TABLE [dbo].[hr_salary]
+GO
+
+CREATE TABLE [dbo].[hr_salary](
+ [Id] [nvarchar](50) NOT NULL,
+ [Userid] [nvarchar](50) NOT NULL,
+ [year] [int] NOT NULL DEFAULT ((0)),
+ [month] [int] NOT NULL DEFAULT ((0)),
+
+
+
+
+
+ [jibengongzi] [decimal](18, 4) NULL ,
+ [baomifei] [decimal](18, 4) NULL ,
+ [gongzuobutie] [decimal](18, 4) NULL ,
+ [jiabangongzi] [decimal](18, 4) NULL ,
+ [shebao] [decimal](18, 4) NULL ,
+ [dianhuabutie] [decimal](18, 4) NULL ,
+ [quanqinjiang] [decimal](18, 4) NULL ,
+ [jiaotngbutie] [decimal](18, 4) NULL ,
+ [jixiaoticheng] [decimal](18, 4) NULL ,
+ [jiangjin] [decimal](18, 4) NULL ,
+ [bufagongzi] [decimal](18, 4) NULL ,
+
+ [shebaokou] [decimal](18, 4) NULL ,
+ [geshui] [decimal](18, 4) NULL ,
+ [dianhuafei] [decimal](18, 4) NULL ,
+ [queqin] [decimal](18, 4) NULL ,
+ [fakuan] [decimal](18, 4) NULL ,
+ [peichang] [decimal](18, 4) NULL ,
+ [jiucuo] [decimal](18, 4) NULL ,
+ [daozhanggongzi] [decimal](18, 4) NULL ,
+ [yufagongzi] [decimal](18, 4) NULL ,
+ [yufagongziheji] [decimal](18, 4) NULL ,
+
+ [islock] [nvarchar](1) NOT NULL,
+ [rec_status] [nvarchar](1) NOT NULL,
+ [creater] [nvarchar](50) NOT NULL,
+ [createtime] [datetime] NOT NULL,
+ [modifier] [nvarchar](50) NOT NULL,
+ [modifytime] [datetime] NOT NULL,
+ CONSTRAINT [PK__hr_salary] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[hr_salary] ADD DEFAULT ('D') FOR [islock]
+GO
+ALTER TABLE [dbo].[hr_salary] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[hr_salary] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[hr_salary] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[hr_salary] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[hr_salary] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
/****** Object: Table [dbo].[ADM_Attendance] Script Date: 2021/6/10 12:54:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-
+IF EXISTS(Select 1 From Sysobjects Where Name='ADM_Attendance') --查询表名costSeparateConfig是否存在
+drop TABLE [dbo].[ADM_Attendance]
+GO
CREATE TABLE [dbo].[ADM_Attendance](
[Id] [nvarchar](50) NOT NULL,
[Userid] [nvarchar](50) NOT NULL,
[year] [int] NOT NULL DEFAULT ((0)),
[month] [int] NOT NULL DEFAULT ((0)),
- [yingchuqin] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [offdays] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [shijichuqin] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [qingjia] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [jiaban] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [xiaojia] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [chidao] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [zaotui] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [kuanggong] [decimal](18, 2) NOT NULL DEFAULT ((0)),
+ [yingchuqin] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [offdays] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [shijichuqin] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [qingjia] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [jiaban] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [xiaojia] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [chidao] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [zaotui] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [kuanggong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
[islock] [nvarchar](1) NOT NULL,
[rec_status] [nvarchar](1) NOT NULL,
@@ -65,7 +151,9 @@
SET QUOTED_IDENTIFIER ON
GO
-
+IF EXISTS(Select 1 From Sysobjects Where Name='ADM_Attendance_dtl') --查询表名costSeparateConfig是否存在
+drop TABLE [dbo].[ADM_Attendance_dtl]
+GO
CREATE TABLE [dbo].[ADM_Attendance_dtl](
[Id] [nvarchar](50) NOT NULL,
[attendance_id] [nvarchar](50) NOT NULL,
@@ -76,16 +164,16 @@
[AfternoonOut] [datetime] NULL,
[OvertimeIn] [datetime] NULL,
[OvertimeOut] [datetime] NULL,
- [qingjia] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [xiaojia] [decimal](18, 2) NOT NULL DEFAULT ((0)),
+ [qingjia] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [xiaojia] [decimal](18, 4) NOT NULL DEFAULT ((0)),
[rec_status] [nvarchar](1) NOT NULL,
[creater] [nvarchar](50) NOT NULL,
[createtime] [datetime] NOT NULL,
[modifier] [nvarchar](50) NOT NULL,
[modifytime] [datetime] NOT NULL,
- [chidaofenzhong] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [zaotuifenzhong] [decimal](18, 2) NOT NULL DEFAULT ((0)),
- [kuanggongtianshu] [decimal](18, 2) NOT NULL DEFAULT ((0)),
+ [chidaofenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [zaotuifenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [kuanggongtianshu] [decimal](18, 4) NOT NULL DEFAULT ((0)),
CONSTRAINT [PK__ADM_Attendance_dtl] PRIMARY KEY CLUSTERED
(
[Id] ASC
--
Gitblit v1.9.1