From 7b52260c2a83d23adb5447a9e9848d90b4dc018c Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 20 六月 2025 08:49:09 +0800
Subject: [PATCH] 爬虫 处理处罚
---
考勤计算的表.sql | 240 ++++++++++++++++++++++++++++++++++++++++++++----------------
1 files changed, 176 insertions(+), 64 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..06ed231 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,193 @@
USE [zhengcaioa]
GO
+/****** Object: Table [dbo].[ADM_Attendance_dtl] Script Date: 2021/6/10 13:04:31 ******/
+SET ANSI_NULLS ON
+GO
+
+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,
+ [SgninDate] [datetime] NULL,
+ [MorningIn] [datetime] NULL,
+ [MorningOut] [datetime] NULL,
+ [AfternoonIn] [datetime] NULL,
+ [AfternoonOut] [datetime] NULL,
+ [OvertimeIn] [datetime] NULL,
+ [OvertimeOut] [datetime] NULL,
+ [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,
+ [shangwuchidaofenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [xiawuchidaofenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [shangwuzaotuifenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [xiawuzaotuifenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [kuanggongtianshu] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [iswork] [nvarchar](1) NULL,
+ CONSTRAINT [PK__ADM_Attendance_dtl] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [SgninDate]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+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,
@@ -56,60 +222,6 @@
-USE [zhengcaioa]
-GO
-
-/****** Object: Table [dbo].[ADM_Attendance_dtl] Script Date: 2021/6/10 13:04:31 ******/
-SET ANSI_NULLS ON
-GO
-
-SET QUOTED_IDENTIFIER ON
-GO
-
-CREATE TABLE [dbo].[ADM_Attendance_dtl](
- [Id] [nvarchar](50) NOT NULL,
- [attendance_id] [nvarchar](50) NOT NULL,
- [SgninDate] [datetime] NULL,
- [MorningIn] [datetime] NULL,
- [MorningOut] [datetime] NULL,
- [AfternoonIn] [datetime] NULL,
- [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)),
- [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)),
- CONSTRAINT [PK__ADM_Attendance_dtl] PRIMARY KEY CLUSTERED
-(
- [Id] ASC
-)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
-) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [SgninDate]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('A') FOR [rec_status]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('1') FOR [creater]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [createtime]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('1') FOR [modifier]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [modifytime]
-GO
--
Gitblit v1.9.1