Skip to content
logo
platformaerp.com

Nowy raport podłączenie

podlaczenie nowego raportu jasper

SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
INSERT INTO CONFIGURATION.PRINTOUT
(
    [documentType], [printoutName], [jasperTemplate], [jasperTemplateSystem], [CGSTemplate], [CGSTemplateSystem], [componentName], [isDefault], [printoutHeader], [printoutFooter], [printoutLogo], [printoutFilters], [test], [contentType], [onClickHandler], [reportFooter], [printOrder], [permission], [template]
)
SELECT ' ' [documentType]  -- do jakiego dokumentu  select * from document.documentType where  documentType like 'wz%'
    ,'WZ z CENAMI' printoutName
    ,null [jasperTemplate]
    ,null [jasperTemplateSystem]
    ,null [CGSTemplate]
    ,null [CGSTemplateSystem]
    ,'documentOut' compenentName -- rozne dla faktur
    ,0  [isDefault] --1 jesli domyslny
    ,null [printoutHeader]
    ,null [printoutFooter]
    ,null [printoutLogo]
    ,0 [printoutFilters]
    ,null [test]
    ,null [contentType]
    ,null [onClickHandler]
    ,null [reportFooter]
    ,null [printOrder]
    ,null [permission]
    ,'DOCUMENT_OUT_MULTI_COST_PL' template --jasper temaplte name

jasper temaplte name

dodanie raportu na podstawie innego raportu

SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
/****** Script for SeleActTopNRows command from SSMS  ******/
insert into [configuration].[printout]
([documentType]
      ,[printoutName]
      ,[template]
      ,[componentName]
      ,[isDefault]
      ,[printoutHeader]
      ,[printoutFooter]
      ,[printoutLogo]
      ,[printoutFilters]
      ,[test]
      ,[contentType]
      ,[onClickHandler]
      ,[reportFooter]
      ,[printOrder]
      ,[permission])

SELECT  [documentType]
      ,[printoutName]
      ,'DOCUMENT_OUT_MULTI_PL_NOPRICE'--[template]
      ,[componentName]
      ,[isDefault]
      ,[printoutHeader]
      ,[printoutFooter]
      ,[printoutLogo]
      ,[printoutFilters]
      ,[test]
      ,[contentType]
      ,[onClickHandler]
      ,[reportFooter]
      ,[printOrder]
      ,[permission]
  FROM [configuration].[printout]
  where documentType ='mm-'
  ```

## wywolanie

- adres faktury http://192.168.22.104/sales-met/invoice/6080f1b8-4d59-ea11-8427-7ed30a52f64f
- adres wydruku http://192.168.22.104/print/INVOICE_PL_ZALICZKA?paramID=6080f1b8-4d59-ea11-8427-7ed30a52f64f&display=True
ds

Przykłąd faktury
http://192.168.22.104/sales-met/invoice/6080f1b8-4d59-ea11-8427-7ed30a52f64f

Przykłady:

```sql

INSERT INTO configuration.printout (printout_uuid,documentType,printoutName,template,componentName,isDefault,printoutHeader,printoutFooter,printoutLogo,printoutFilters,test,contentType,onClickHandler,reportFooter,printOrder,permission,jasperTemplate,jasperTemplateSystem,[action],css,printout_status,[method]) VALUES
     (N'D0B46936-33EA-4EE9-A04C-16320B2B3BC2',N'FE',N'Rozliczenie zaliczki',N'INVOICE_EN_ZALICZKA',N'saleInvoice',0,N'Sprzedawca:
<style isBold="true" pdfFontName="Helvetica-Bold">@firmName</style>
@postCode @city
@streetName
NIP: @nip
Nr VAT UE: PL@nip
BDO 000559884
e-mail: @email
<style>@www</style>
Tel.: @phone',N'',N'D:\LISICKI_IMAGES\Logo.png',0,NULL,NULL,NULL,NULL,3,NULL,NULL,NULL,N'http://localhost:8080/jasperserver/rest_v2/reports/Reports/METALBUD/{template}.pdf?paramId={id}&username=sys&REPORT_LOCALE=pl_PL&userLocale=pl_PL&db={db}&j_username=jasperadmin&j_password=jasperadmin',NULL,NULL,NULL);