Modyfikacja Zapytania Opcje

[SDD]

Oto zapytanie,którepotrzebuje zmodyfikować:

Kod

<script LANGUAGE="JavaScript" RUNAT="server">
    function rsPlatnosci_onbeforeopen() {
    // ustawienie właściwgo wyrażenia SQL dla rekordsetu
    var sSQLCommand;
    
    if( Application("Platforma") == "MSSQL" )
    {    sSQLCommand =    "SELECT DateAdd(day,TrN_Data2,convert(datetime,'28-12-1800',105)) As DataDok,"+
                        " DateAdd(day,TrP_Termin,convert(datetime,'28-12-1800',105)) As DataTermin,";
    }
    else
    {    sSQLCommand =    "SELECT DateAdd(day,TrN_Data2,'1800-12-28') As DataDok,"+
                        " DateAdd(day,TrP_Termin,'1800-12-28') As DataTermin,";
    }
    
        sSQLCommand = sSQLCommand +
                        " CDN.NumerDokumentuTRN(trn_GidTyp,trn_spityp,trn_trntyp,trn_trnnumer,trn_trnrok,trn_trnseria) as NumerDokumentu, " +
                        " (TrP_Kwota * (TrP_Typ-2))+(TrP_Kwota * (TrP_Typ-1)) as TrP_Kwota,(TrP_Pozostaje * (TrP_Typ-2))+(TrP_Pozostaje * (TrP_Typ-1)) as TrP_POzostaje," +
                        " TrP_FormaNazwa, "+
                        " TrN_TrNRok, TrN_TrNSeria, TrN_TrNNumer, "+
                        " ZaN_ZamRok,ZaN_ZamSeria,ZaN_ZamNumer, isnull(Zan_GidNumer,0) as ZamGIDNumer, " +
                        " TrN_GIDTyp, TrN_GIDFirma, TrN_GIDNumer, "+
                        " Knt_MaxLimitWart, "+
                        " (Knt_MaxLimitWart*Knt_LimitPoTerminie)/100 As PoTerminie "+
                        " FROM CDN.TraPlat LEFT OUTER JOIN CDN.TraNag ON TrN_GIDTyp=TrP_GIDTyp AND TrN_GIDFirma=TrP_GIDFirma AND TrN_GIDNumer=TrP_GIDNumer"+
                        " LEFT OUTER JOIN CDN.KntKarty ON Knt_GIDTyp=TrP_KntTyp AND Knt_GIDFirma=TrP_KntFirma AND Knt_GIDNumer=TrP_KnTNumer "+
                        " LEFT OUTER JOIN CDN.ZamNag ON Trn_ZaNTyp = ZaN_GidTyp and Trn_ZaNFirma=ZaN_GidFirma and Trn_ZaNNumer=ZaN_Gidnumer "+
                          " WHERE TrP_KntFirma="+Session("KntFirma")+" AND TrP_KntNumer="+Session("KntNumer")+" AND TrP_KntTyp="+Session("KntTyp")+
                          " ORDER BY TrN_Data2, TrN_TrNRok, TrN_TrNSeria, TrN_TrNNumer";
        // podtsawienie wyrażenia SQL      
        rsPlatnosci.setSQLText(sSQLCommand);
    }
    
    function FormatujNumerDokumentu(    NumerDokumentu,
                            TrN_GIDTyp, TrN_GIDFirma, TrN_GIDNumer)
    
    {    return "<A HREF=../_Dokumenty/Faktura.asp?Typ="+TrN_GIDTyp+"&Firma="+TrN_GIDFirma+"&Numer="+TrN_GIDNumer+">"+NumerDokumentu+"</A>";        
    }
    
    function FormatujNumerZamowienia(ZamGIDNumer,ZamNumer,ZamRok,ZamSeria)
    {    
    if (ZamGIDNumer==0)
        return "<--->";
    else    
        return "<A HREF=../_Dokumenty/Zamowienie.asp?gidnumer="+ZamGIDNumer+">"+ZamNumer+"/"+ZamRok+"/"+ZamSeria+"</A>";        
    }
</SCRIPT>

Tak aby dla tabeli Zapisy, dane były wyświelane w odpowiednich rubrykach tableki:

pola tabelki:

1.Nr dokumentu

right(totext({Zapisy.KAZ_Rok},"0"),2) & '/' &
{Zapisy.KAZ_Seria} & '/'&
totext({Zapisy.KRPNumer},"0") & '/' &
totext({Zapisy.KAZ_KRPLp},"0")

2. data transakcji

totext(date(1800,12,28)+{Zapisy.KAZ_DataDokumentu},"yyyy-MM-dd")

3.do dokumentu
KAZ_NumerDokumentu

4.Kwota

if {Zapisy.KAZ_RP}=1 THEN 0-{Zapisy.KAZ_Kwota} ELSE {Zapisy.KAZ_Kwota}

5. Waluta

Zapisy.KAZ_Waluta

6. Pozostaje

if {Zapisy.KAZ_RP}=1 THEN 0-{Zapisy.KAZ_Pozostaje} ELSE {Zapisy.KAZ_Pozostaje}


kod tabelki:

Kod

<script LANGUAGE=JavaScript RUNAT=Server>
function _initgridPlatnosci()
{
gridPlatnosci.pageSize = 1000;
gridPlatnosci.setDataSource(rsPlatnosci);
gridPlatnosci.tableAttributes = 'align="center" cellpadding=2  cellspacing=1 bordercolordark=Gray bordercolorlight=Silver bgcolor=Silver border=2 cols=7 rules=ROWS';
gridPlatnosci.headerAttributes = '   bgcolor=Teal align=Left';
gridPlatnosci.headerWidth[0] = '';
gridPlatnosci.headerWidth[1] = '';
gridPlatnosci.headerWidth[2] = '';
gridPlatnosci.headerWidth[3] = '';
gridPlatnosci.headerWidth[4] = '';
gridPlatnosci.headerWidth[5] = '';
gridPlatnosci.headerWidth[6] = '';
gridPlatnosci.headerFormat = '<Font face="Tahoma" size=1 color=White> <b>';
gridPlatnosci.colHeader[0] = '\'Nr dokumentu\'';
gridPlatnosci.colHeader[1] = '\'Nr zamówienia\'';
gridPlatnosci.colHeader[2] = '\'Data transakcji\'';
gridPlatnosci.colHeader[3] = '\'Termin płatności\'';
gridPlatnosci.colHeader[4] = '\'Forma płatności\'';
gridPlatnosci.colHeader[5] = '\'Kwota transakcji\'';
gridPlatnosci.colHeader[6] = '\'Pozostaje\'';
gridPlatnosci.rowAttributes[0] = '  bgcolor = White align=Left bordercolordark=Gray bordercolorlight=Silver';
gridPlatnosci.rowFormat[0] = ' <Font face="Tahoma" size=1 color=Black >';
gridPlatnosci.colAttributes[0] = '  bgcolor=White align=Left';
gridPlatnosci.colFormat[0] = '<Font Size=1 Face="Tahoma" Color=Black >';
gridPlatnosci.colData[0] = 'FormatujNumerDokumentu(rsPlatnosci.fields.getValue(\'NumerDokumentu\'), rsPlatnosci.fields.getValue(\'TrN_GIDTyp\'), rsPlatnosci.fields.getValue(\'TrN_GIDFirma\'), rsPlatnosci.fields.getValue(\'TrN_GIDNumer\')) ';
gridPlatnosci.colAttributes[1] = '  bgcolor=White align=Center';
gridPlatnosci.colFormat[1] = '<Font Size=1 Face="Tahoma" Color=Black >';
gridPlatnosci.colData[1] = 'FormatujNumerZamowienia(rsPlatnosci.fields.getValue(\'ZamGidNumer\'),rsPlatnosci.fields.getValue(\'Zan_ZamNumer\'),rsPlatnosci.fields.getValue(\'Zan_ZamRok\'),rsPlatnosci.fields.getValue(\'Zan_ZamSeria\'))';
gridPlatnosci.colAttributes[2] = '  bgcolor=White align=Center';
gridPlatnosci.colFormat[2] = '<Font Size=1 Face="Verdana" Color=Black >';
gridPlatnosci.colData[2] = 'rsPlatnosci.fields.getValue(\'DataDok\')';
gridPlatnosci.colAttributes[3] = '  bgcolor=White align=Center';
gridPlatnosci.colFormat[3] = '<Font Size=1 Face="Verdana" Color=Black >';
gridPlatnosci.colData[3] = 'rsPlatnosci.fields.getValue(\'DataTermin\')';
gridPlatnosci.colAttributes[4] = '  bgcolor=White align=Center';
gridPlatnosci.colFormat[4] = '<Font Size=1 Face="Verdana" Color=Black >';
gridPlatnosci.colData[4] = 'rsPlatnosci.fields.getValue(\'TrP_FormaNazwa\')';
gridPlatnosci.colAttributes[5] = '  bgcolor=White align=Right';
gridPlatnosci.colFormat[5] = '<Font Size=1 Face="Verdana" Color=Black >';
gridPlatnosci.colData[5] = 'FormatujWartosc(rsPlatnosci.fields.getValue(\'TrP_Kwota\'),15)';
gridPlatnosci.colAttributes[6] = '  bgcolor=White align=Right';
gridPlatnosci.colFormat[6] = '<Font Size=1 Face="Verdana" Color=Red >';
gridPlatnosci.colData[6] = 'FormatujWartosc(rsPlatnosci.fields.getValue(\'TrP_Pozostaje\'),15)';

gridPlatnosci.hasPageNumber = true;
}
function _gridPlatnosci_ctor()
{
    CreateDataGrid('gridPlatnosci',_initgridPlatnosci);
}
</SCRIPT>