MS SQL 9Fx3SO9cS81rFfHMxFxtP9HS2yhFcdOF82zohWJxZXPD0K3JYm1ByPhb7YHqAHcqxBRzz8ZME9VDTaCFTRE0G8Rw2UjIV9NFwhW9jekEYo/EetmDxkzjzXIf/exNcaB7i8TBaEsJS21pSaT4Yz0= faf5796325454ecea9d4a1479009b927 MS SQL spGetReportExtendedDocsList ReceiverUID,System.Guid ReceiverName,System.String ControlAssignmentName,System.String ViewDocCK,System.String DocNum,System.String StationID,System.Int32 BaseName,System.String FirstDate,System.String MisName,System.String CreateDate,System.String EventDate,System.String NewDate,System.String EventID,System.Int32 MinExtendedID,System.Int32 DOC_NUM,System.String DecisionName,System.String ResonExtended,System.String REG_NUM,System.String MisUID,System.String SortOrder,System.String 600 df08a4c841c14e6c81f0dbebcc6500ab spGetReportExtendedDocsList MS SQL _x0040_StartDate,usp_StartDate,4,0 _x0040_EndDate,usp_EndDate,4,0 _x0040_ViewControl,usp_ViewControl,22,0 _x0040_ViewDocCK,usp_ViewDocCK,22,0 _x0040_Execs,usp_UserStr,22,0 _x0040_MissionFailureReasons,usp_MissionFailureReasons,22,0 _x0040_user,_x0022_9901d8a1-d84f-4783-83da-fe5a227c22ce_x0022_,22,0 spGetReportExtendedDocsList StoredProcedure ViewDocCkDS ID,System.Int32 NAME,System.String 300 c9c16b5c0dbb4de6a3568e588cb27b5a ViewDocCkDS MS SQL select distinct E.ID, E.NAME from CL_ELEMENTS E where KLASS_ID = 132 and ACTIVE = 1 order by 2 ViewControlDS ID,System.Int32 Name,System.String 300 173ead8042614cc7a3bda11d04f6f79c ViewControlDS MS SQL SELECT ID, Name FROM CL_ELEMENTS WHERE Active=1 and klass_id=96 ORDER BY 2 MissionFailureReasonsDS ID,System.Int32 NAME,System.String 300 f4bad21e23c147f5bf68309677539962 MissionFailureReasonsDS MS SQL select ID, NAME from CL_ELEMENTS where KLASS_ID = 130 and ACTIVE = 1 UserStrDS ReceiverUID,System.Guid ReceiverName,System.String 300 fde5f6ef848042768333845ec5d50abd UserStrDS MS SQL select distinct s.ReceiverUID, dbo.fnGetGkSubjectName(O.UID, O.OBJ_TYPE) as ReceiverName from WF4_Stations s inner join MI_EVENTS e on e.Executor_ID = s.ID and e.PRUZ = 0 and e.EventCategory in (4,16) and CAST(e.EventDate as date) between CONVERT(DATE, '{usp_StartDate}', 104) and CONVERT(DATE, '{usp_EndDate}', 104) and e.ID in (select ID from MI_EVENTS where Executor_ID = e.Executor_ID and EventCategory in (4,16)) inner join WF4_Routes r on s.RouteID = r.ID and s.PRUZ = 0 and r.Type = 4 and r.PRUZ = 0 inner join GL_OBJECTS O on S.ReceiverUID = O.UID order by 2 DataSetListURL url,System.Object 60 4ff9d132026f49588e27f66bb4a2d251 DataSetListURL MS SQL select dbo.fnGetSettingValue('spdFASServerUrl', 'spdFASLinks') url NameReport id,System.Int32 name,System.String 30 ba272953eb534950a31d04ab62a45643 NameReport MS SQL select 1 as id, 'Ф-3. Задания, имеющие перенос сроков' as name 900 _x0039_00,usp_NameReport,Название_x0020_отчёта,NameReport,System.Int32,_x0031_,False,False,False,False,,a4c8c0a9d1dc4f359f8cb0213c591e9c 51 _x0035_1,usp_StartDate,Отчетный_x0020_период,,System.DateTime,DateSerial_x0028_Year_x0028_Today_x0029__x002C_Month_x0028_Today_x0029__x002C_1_x0029_,False,True,False,False,,_x0037_b4b96e4552141ee90a881600fca0c8e,True _x0035_1,usp_EndDate,Отчетный_x0020_период,,System.DateTime,Today,False,True,False,False,,_x0030_6b13a637a7640e9b6904b78f552d206,True 11 _x0031_1,usp_ViewControl,Вид_x0020_контроля,ViewControlDS,System.String,,False,False,False,False,,_x0036_672464653a544d9b60ad2bf2aa4199c,True _x0031_1,usp_ViewDocCK,Вид_x0020_документа,ViewDocCkDS,System.String,,False,False,False,False,,_x0032_ea6814223544bd5b5d76852e40d2784,True _x0031_1,usp_UserStr,Исполнители,UserStrDS,System.String,,False,False,False,False,,_x0030_99660452f0d431abd7ddb79454edc60,True _x0031_1,usp_MissionFailureReasons,Причины_x0020_переноса_x0020_срока,MissionFailureReasonsDS,System.String,,False,False,False,False,,c3035b5b6e464f7ca605be55c0c77be1,True EngineV2 a2deec10da6e48f4abb3be24c4b2daa1 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,27.7,1.4 White 0,0.8,27.7,1 Times New Roman,12,Bold Center 2,2,2,2 Text6 BasedOnTagMerge Ф-3. ЗАДАНИЯ, ИМЕЮЩИЕ ПЕРЕНОСЫ СРОКОВ c {usp_StartDate.ToString("dd.MM.yyyy")} по {usp_EndDate.ToString("dd.MM.yyyy")} Black Expression White 24.4,0.4,3.3,0.4 Times New Roman,9,Bold Right Text7 Ф-3 Black Expression White 20.6,0,7.1,0.4 Times New Roman,9 Right Text19 {Time} Black SystemVariables ReportTitleBand1 Transparent 0,2.6,27.7,0.6 White 2.6,0,25.1,0.6 Times New Roman,11,Bold 2,2,2,2 Text1 BasedOnTagMerge {spGetReportExtendedDocsList.ControlAssignmentName} Black Expression Center White 0,0,2.6,0.6 Times New Roman,11 2,2,2,2 Text17 Вид контроля: Black Expression Center {spGetReportExtendedDocsList.SortOrder} Table1.SortOrder False GroupHeaderBand1 True Transparent True 0,4,27.7,1.8 White 0,0,2.6,0.6 Times New Roman,11 2,2,2,2 Text18 Исполнитель: Black Expression Center White 2.6,0,25.1,0.6 Times New Roman,11,Bold 0,2,2,2 Text2 BasedOnTagMerge {spGetReportExtendedDocsList.ReceiverName} Black Expression Center All;Black;1;Solid;False;4;Black White 0,0.6,2.8,1.4 Times New Roman,10,Bold 6d21f72bc36a4872850e6a0955f07ecc Center 2,2,2,2 Text8 Вид документа, номер, дата Black Expression All;Black;1;Solid;False;4;Black White 2.8,0.6,3,1.4 Times New Roman,10,Bold c7ff9bd56a6c472087714f4fbf65fa3a Center 2,2,2,2 Text9 Заголовок документа Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White 5.8,0.6,2.4,1.4 Times New Roman,10,Bold 19453e3357234717b2badf3afd6c46a1 Center 2,2,2,2 Text10 Срок исполнения документа Black Expression All;Black;1;Solid;False;4;Black White 8.2,0.6,1.8,1.4 Times New Roman,10,Bold 23318d233f4b4528b5707bd365d1840b Center 2,2,2,2 Text11 Прил., п., п/п Black Expression All;Black;1;Solid;False;4;Black White 10,0.6,4.8,1.4 Times New Roman,10,Bold 945d4053da64472b836ac8bc6ac90139 Center 2,2,2,2 Text12 Содержание задания Black Expression All;Black;1;Solid;False;4;Black White 16.6,0.6,2,1.4 Times New Roman,10,Bold 4f7c02bc9a9b4bcd928b37b278e0678f Center 2,2,2,2 Text13 Срок исполнения задания Black Expression All;Black;1;Solid;False;4;Black White 18.6,0.6,2,1.4 Times New Roman,10,Bold 46987dea33a9482b909d8c06f6c22194 Center 2,2,2,2 Text5 Дата переноса Black Expression All;Black;1;Solid;False;4;Black White 20.6,0.6,3.8,1.4 Times New Roman,10,Bold 1879dc27f8254f42905fdb18572cbf8b Center 2,2,2,2 Text14 Кто перенес Black Expression All;Black;1;Solid;False;4;Black White 24.4,0.6,3.3,1.4 Times New Roman,10,Bold 92e6a45b3eca416f822e5ec4663ca052 Center 2,2,2,2 Text15 Причина переноса Black Expression All;Black;1;Solid;False;4;Black White 14.8,0.6,1.8,1.4 Times New Roman,10,Bold Center 2,2,2,2 Text20 Рег.номер Black Expression {spGetReportExtendedDocsList.ReceiverName} GroupHeaderBand2 True Mode Transparent 0,6.6,27.7,1 10 All;Black;1;Solid;False;4;Black White True 0,0,2.8,1 Times New Roman,10 True 5 2,2,2,2 Table1_Cell1 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID} {spGetReportExtendedDocsList.ViewDocCK} {spGetReportExtendedDocsList.DocNum} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White True 2.8,0,3,1 Times New Roman,10 True 6 2,2,2,2 Table1_Cell2 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID} {spGetReportExtendedDocsList.BaseName} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White True 5.8,0,2.4,1 Times New Roman,10 True Center 7 2,2,2,2 Table1_Cell3 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID} {spGetReportExtendedDocsList.NewDate} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White True 8.2,0,1.8,1 Times New Roman,10 True Center 8 2,2,2,2 Table1_Cell4 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID} {spGetReportExtendedDocsList.DOC_NUM} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White True 10,0,4.8,1 Times New Roman,10 True 9 2,2,2,2 Table1_Cell5 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID} {spGetReportExtendedDocsList.MisName} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White True 14.8,0,1.8,1 Times New Roman,10 True Center {DataSetListURL.url}CA/Desktop/?docuid={spGetReportExtendedDocsList.MisUID}&doctype=30 47 2,2,2,2 Table1_Cell6 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID} {spGetReportExtendedDocsList.REG_NUM} [0:23:129] ,,,,WordWrap=True,A=0 DataColumn All;Black;1;Solid;False;4;Black White True 16.6,0,2,1 Times New Roman,10 True Center 31 2,2,2,2 Table1_Cell7 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID}{spGetReportExtendedDocsList.EventID} {spGetReportExtendedDocsList.NewDate} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White True 18.6,0,2,1 Times New Roman,10 True Center 37 2,2,2,2 Table1_Cell8 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID}{spGetReportExtendedDocsList.EventID}{spGetReportExtendedDocsList.StationID} {spGetReportExtendedDocsList.EventDate} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White True 20.6,0,3.8,1 Times New Roman,10 True 35 2,2,2,2 Table1_Cell9 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID}{spGetReportExtendedDocsList.EventID}{spGetReportExtendedDocsList.StationID} {spGetReportExtendedDocsList.DecisionName} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black White True 24.4,0,3.3,1 Times New Roman,10 True 33 2,2,2,2 Table1_Cell10 BasedOnTagMerge AllowMove, AllowSelect, AllowChange {spGetReportExtendedDocsList.MisUID}{spGetReportExtendedDocsList.EventID}{spGetReportExtendedDocsList.StationID} {spGetReportExtendedDocsList.ResonExtended} Black ,,,,WordWrap=True,A=0 Expression spGetReportExtendedDocsList False False False False False Table1 48 1 ASC ViewDocCK DESC MisUID DESC REG_NUM ASC EventDate Transparent 0,8.4,27.7,0.8 White 0,0,27.7,0.6 Times New Roman,11,Bold 2,2,2,2 Text4 Итого по исполнителю: {CountDistinct(spGetReportExtendedDocsList.MisUID)} Black Expression Center GroupFooterBand2 False Transparent 0,10,27.7,0.8 White 0,0,27.7,0.6 Times New Roman,11,Bold 2,2,2,2 Text3 Итого по виду контроля: {CountDistinct(spGetReportExtendedDocsList.MisUID)} Black Expression Center GroupFooterBand1 True Transparent True 0,11.6,27.7,0.8 White 0,0,27.7,0.6 Times New Roman,11,Bold 2,2,2,2 Text16 Всего: {CountDistinct(spGetReportExtendedDocsList.EventID)} Black Expression Center False FooterBand1 d4bfe3333743454fa1b45e43c6bc4541 1,1,1,1 Page1 Landscape 17 29.7 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 4/4/2025 3:44:51 PM 12/28/2024 11:29:46 AM Ф-3. Задания, имеющие перенос сроков D:\SEDFAS\SedFas\Reports\Document\Saratov_СК\Document\ExtendedDocsList.mrt d385a021b88a4e20be1034f0883e1fc2 Report Centimeters 2024.4.2.0 True True CSharp