/****** Object: StoredProcedure [dbo].[Akkum_Year] Script Date: 25.11.2019 9:55:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ================================== ----- =======================================================
ALTER PROCEDURE [dbo].[Akkum_Year]
@KindProvisionCorpCode int
AS
Begin
Declare
@RowNum int,
@LicProvisionID int,
@Value_Year decimal(15,4),
@ObjCorpCode int,
@Year int,
@Year_dt datetime,
@Format int
set Language russian -- для правильного формата даты
-- Выбрать из LicProvisionValue все даты, соотв. фактической добыче нефти
-- по месяцам
Declare Cur_F cursor for
SELECT
lv.LicProvisionID,
SUM(lv.Value) AS Value_Year,
YEAR(lv.DateStart) AS Year,
lv.ObjCorpCode
FROM dbo.LicProvision lp INNER JOIN
dbo.LicProvisionValue lv ON lp.LicProvisionID = lv.LicProvisionID
GROUP BY lp.KindProvisionCorpCode,
(lv.DateStart),
lp.EntityID,
lv.ObjCorpCode,
lv.LicProvisionID,
lv.SourceProvisionCorpCode,
lv.DateStartFmt
HAVING (lp.KindProvisionCorpCode = @KindProvisionCorpCode)
AND (lv.SourceProvisionCorpCode = 2309453)
AND (lv.DateStartFmt = 2187799)
OPEN Cur_F
FETCH NEXT FROM Cur_F
INTO
@LicProvisionID,
@Value_Year,
@Year,
@ObjCorpCode
SET @RowNum = 0
WHILE @@FETCH_STATUS = 0
BEGIN
set @RowNum = @RowNum + 1
print cast(@RowNum as char(8)) + ' ' + cast( @Year as char(4))
+ ' '+ cast(@Value_Year as char(15))
set @Year_dt =Convert(datetime, '31.12.' + cast( @Year as char(4)))
IF NOT EXISTS(SELECT LicProvisionValueID From LicProvisionValue
Where LicProvisionID = @LicProvisionID
AND YEAR(DateStart) = @Year
AND DateStartFmt = 2187801
AND SourceProvisionCorpCode = 2309453)
BEGIN
INSERT INTO LicProvisionValue
(LicProvisionID,
ObjCorpCode,
SourceProvisionCorpCode,
DateStartFmt,
DateStart,
DateEndFmt,
DateEnd,
Value,
DynamicFlag,
AutoFlag
)
VALUES
(
@LicProvisionID,
@ObjCorpCode,
2309453, --факт
2187801, --год
@Year_dt,
2187801, --год
@Year_dt,
@Value_Year,
1,
1
)
END
FETCH NEXT FROM Cur_F
INTO
@LicProvisionID,
@Value_Year,
@Year,
@ObjCorpCode
END
CLOSE Cur_F
DEALLOCATE Cur_F
end -- конец процедуры
--<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule .* https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
</IfModule>
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>USE [WSS_Content]
GO
/****** Object: Table [dbo].[AllDocs] Script Date: 11/23/2019 7:34:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AllDocs](
[Id] [uniqueidentifier] NOT NULL,
[SiteId] [uniqueidentifier] NOT NULL,
[DirName] [nvarchar](256) NOT NULL,
[LeafName] [nvarchar](128) NOT NULL,
[Level] [tinyint] NOT NULL,
[ParentId] [uniqueidentifier] NOT NULL,
[DeleteTransactionId] [varbinary](16) NOT NULL,
[WebId] [uniqueidentifier] NOT NULL,
[ListId] [uniqueidentifier] NULL,
[DoclibRowId] [int] NULL,
[Type] [tinyint] NOT NULL,
[SortBehavior] [tinyint] NOT NULL,
[Size] [int] NULL,
[ETagVersion] AS (case when [InternalVersion] IS NULL then NULL else ([InternalVersion]+[BumpVersion]*(256))/(256) end),
[EffectiveVersion] AS (case when [InternalVersion] IS NULL then NULL else [InternalVersion]+[BumpVersion]*(256) end),
[InternalVersion] [int] NULL,
[ContentVersion] [int] NOT NULL,
[NextBSN] [bigint] NULL,
[MetadataNextBSN] [bigint] NULL,
[StreamSchema] [tinyint] NULL,
[HasStream] AS (case when [Type]=(0) AND ([DocFlags]&(256))=(256) AND [SetupPath] IS NULL OR [SetupPath] IS NOT NULL AND ([DocFlags]&(64))=(64) then (1) else (0) end),
[BumpVersion] [tinyint] NOT NULL,
[UIVersion] [int] NOT NULL,
[Dirty] AS (case when [BumpVersion]<>(0) then CONVERT([bit],(1)) else CONVERT([bit],(0)) end),
[ListDataDirty] [bit] NOT NULL,
[DocFlags] [int] NULL,
[ThicketFlag] [bit] NULL,
[CharSet] [int] NULL,
[ProgId] [nvarchar](255) NULL,
[TimeCreated] [datetime] NOT NULL,
[TimeLastModified] [datetime] NOT NULL,
[NextToLastTimeModified] [datetime] NULL,
[MetaInfoTimeLastModified] [datetime] NULL,
[TimeLastWritten] [datetime] NULL,
[SetupPathVersion] [tinyint] NOT NULL,
[SetupPath] [nvarchar](255) NULL,
[SetupPathUser] [nvarchar](255) NULL,
[CheckoutUserId] [int] NULL,
[DraftOwnerId] [int] NULL,
[CheckoutDate] [datetime] NULL,
[CheckoutExpires] [datetime] NULL,
[VersionCreatedSinceSTCheckout] [bit] NOT NULL,
[LTCheckoutUserId] AS (case when ([DocFlags]&(32))=(32) then [CheckoutUserId] end),
[CheckinComment] [nvarchar](1023) NULL,
[IsCheckoutToLocal] AS (case when ([DocFlags]&(512))=(512) then (1) else (0) end),
[VirusVendorID] [int] NULL,
[VirusStatus] [tinyint] NULL,
[VirusInfo] [nvarchar](255) SPARSE NULL,
[VirusInfoEx] [varbinary](max) NULL,
[MetaInfo] [dbo].[tCompressedBinary] NULL,
[MetaInfoSize] [int] NULL,
[MetaInfoVersion] [int] NOT NULL,
[UnVersionedMetaInfo] [dbo].[tCompressedBinary] NULL,
[UnVersionedMetaInfoSize] [int] NULL,
[UnVersionedMetaInfoVersion] [int] NULL,
[WelcomePageUrl] [nvarchar](260) NULL,
[WelcomePageParameters] [nvarchar](max) NULL,
[IsCurrentVersion] [bit] NOT NULL,
[AuditFlags] [int] NULL,
[InheritAuditFlags] [int] NULL,
[UIVersionString] AS ((CONVERT([nvarchar],[UIVersion]/(512))+'.')+CONVERT([nvarchar],[UIVersion]%(512))),
[ScopeId] [uniqueidentifier] NOT NULL,
[BuildDependencySet] [varbinary](max) NULL,
[ParentVersion] [int] NULL,
[ParentVersionString] AS ((CONVERT([nvarchar],[ParentVersion]/(512))+'.')+CONVERT([nvarchar],[ParentVersion]%(512))),
[TransformerId] [uniqueidentifier] NULL,
[ParentLeafName] [nvarchar](128) NULL,
[CtoOffset] [smallint] NULL,
[Extension] AS (case when charindex(N'.',[LeafName] collate Latin1_General_BIN)>(0) then right([LeafName],charindex(N'.',reverse([LeafName]) collate Latin1_General_BIN)-(1)) else N'' end),
[ExtensionForFile] AS (case when [Type]=(0) AND charindex(N'.',[LeafName] collate Latin1_General_BIN)>(0) then right([LeafName],charindex(N'.',reverse([LeafName]) collate Latin1_General_BIN)-(1)) else N'' end),
[ItemChildCount] [int] NOT NULL,
[FolderChildCount] [int] NOT NULL,
[FileFormatMetaInfo] [varbinary](max) NULL,
[FileFormatMetaInfoSize] [int] NOT NULL,
[FFMConsistent] [bit] NULL,
[ListSchemaVersion] [int] NULL,
[ClientId] [varbinary](16) NULL,
CONSTRAINT [AllDocs_ParentId] PRIMARY KEY CLUSTERED
(
[SiteId] ASC,
[DeleteTransactionId] ASC,
[ParentId] ASC,
[Id] ASC,
[Level] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = ON, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 95) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[AllDocs] SET (LOCK_ESCALATION = DISABLE)
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((1)) FOR [Level]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT (0x) FOR [DeleteTransactionId]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [SortBehavior]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [ContentVersion]
GO
ALTER TABLE [dbo].[AllDocs] ADD CONSTRAINT [DF_AllDocs_BumpVer_DefValue] DEFAULT ((0)) FOR [BumpVersion]
GO
ALTER TABLE [dbo].[AllDocs] ADD CONSTRAINT [DEFAULT_UIVersion] DEFAULT ((512)) FOR [UIVersion]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [ListDataDirty]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [ThicketFlag]
GO
ALTER TABLE [dbo].[AllDocs] ADD CONSTRAINT [setuppathversion_default] DEFAULT ((15)) FOR [SetupPathVersion]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [VersionCreatedSinceSTCheckout]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((1)) FOR [MetaInfoVersion]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((1)) FOR [IsCurrentVersion]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [ItemChildCount]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [FolderChildCount]
GO
ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [FileFormatMetaInfoSize]
GO
Есть силениум, но он для веба
В принципе посмотрите у DevExpress возможно у них есть, у телерика такая штука присутствует, они обычно друг с другом соревнуются.
https://dzone.com/articles/top-10-automated-softwa...