Subversion Repositories DevTools

Rev

Rev 6876 | Rev 6879 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6876 Rev 6877
Line 634... Line 634...
634
    Response.Cookies(enum_RELMGR_COOKIE_DOMAIN)(COOKIE_HIDE_DIFF_FILTER) = Request("difilter")
634
    Response.Cookies(enum_RELMGR_COOKIE_DOMAIN)(COOKIE_HIDE_DIFF_FILTER) = Request("difilter")
635
End If
635
End If
636
 
636
 
637
Call GetDiffFilterValues ( dDiffFilter )
637
Call GetDiffFilterValues ( dDiffFilter )
638
'----------------------------------------------
638
'----------------------------------------------
-
 
639
Sub PanelA
-
 
640
 %>
-
 
641
    <!-- SELECT RELEASE A ---------------------------------------------->
-
 
642
    <table width="100%"  border="0" cellspacing="10" cellpadding="0">
-
 
643
        <tr>
-
 
644
            <td align="left" class="body_col"><img src="images/i_rtag_open_mode.gif" border="0" align="absmiddle" width="15" height="13">&nbsp;Select Release A<hr size="1px" color="Olive" noshade></td>
-
 
645
        </tr>
-
 
646
        <tr>
-
 
647
            <td align="left">
-
 
648
                <select name="projA" class="form_item" onChange="RequestReleaseCombo( '?proj_id='+ this.value, FormName.rtagA );">
-
 
649
                    <option value="">-- Select Project --</option>
-
 
650
                    <%
-
 
651
                    OraDatabase.Parameters.Add "PROJ_ID",     objRelCollectorA.Item("proj_id"),    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
652
 
-
 
653
                    Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ProjectsCombo.sql"), cint(0))
-
 
654
 
-
 
655
                    OraDatabase.Parameters.Remove "PROJ_ID"
-
 
656
 
-
 
657
                    While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-
 
658
                        <option value="<%=rsQry("proj_id")%>" <%=rsQry("selected")%>><%=rsQry("proj_name")%></option>
-
 
659
                        <%rsQry.MoveNext
-
 
660
                    WEnd
-
 
661
 
-
 
662
                    rsQry.Close
-
 
663
                    Set rsQry = Nothing
-
 
664
                    %>
-
 
665
                </select>
-
 
666
            </td>
-
 
667
        </tr>
-
 
668
        <tr>
-
 
669
            <td align="left">
-
 
670
                <select name="rtagA" id="rtagA" class="form_item">
-
 
671
                    <%
-
 
672
                    OraDatabase.Parameters.Add "PROJ_ID",     objRelCollectorA.Item("proj_id"),    ORAPARM_INPUT,  ORATYPE_NUMBER
-
 
673
                    OraDatabase.Parameters.Add "RTAG_ID",     objRelCollectorA.Item("rtag_id"),    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
674
 
-
 
675
                    Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleasesCombo.sql"), cint(0))
-
 
676
 
-
 
677
                    OraDatabase.Parameters.Remove "PROJ_ID"
-
 
678
                    OraDatabase.Parameters.Remove "RTAG_ID"
-
 
679
 
-
 
680
                    While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-
 
681
                            <option value="<%=rsQry("rtag_id")%>" <%=rsQry("selected")%>><%=rsQry("rtag_name")%></option>
-
 
682
                        <%rsQry.MoveNext
-
 
683
                    WEnd
-
 
684
 
-
 
685
                    rsQry.Close
-
 
686
                    Set rsQry = Nothing
-
 
687
                    %>
-
 
688
                </select>
-
 
689
            </td>
-
 
690
        </tr>
-
 
691
        <%If (parRtagA <> "") Then%>
-
 
692
            <tr>
-
 
693
                <td align="left"><a href="dependencies.asp?rtag_id=<%=parRtagA%>" class="body_txt_drk">Go To Release A &raquo;</a></td>
-
 
694
            </tr>
-
 
695
        <%End If%>
-
 
696
                                <tr class="body_txt">
-
 
697
                                    <td>
-
 
698
                                        <%If (parRtagA <> "") AND (parRtagB <> "")Then%>
-
 
699
                                            <!-- DIFF FILTER +++++++++++++++++++++++++++++++++++++++++++ -->
-
 
700
                                            <p>&nbsp;
-
 
701
                                            <fieldset style="width:200px;" onclick="filterClicked(event);">
-
 
702
                                                <legend class="body_txt"><%=GetIsDiffFilterInUseIcon() %>&nbsp;Filter&nbsp;Results...</legend>
-
 
703
                                                <table width="100%"  border="0" cellspacing="2" cellpadding="0" id=filterTable class="body_txt">
-
 
704
                                                    <tr >
-
 
705
                                                        <td><input id="filterFipper" name="difilter" type="checkbox" onclick="toggleFilters();"></td>
-
 
706
                                                        <td colspan=1>Hide the marked change types.</td>
-
 
707
                                                    </tr>
-
 
708
                                                    <tr>
-
 
709
                                                        <td width="1"><input name="difilter" type="checkbox" value="<%=enumDB_NUM_DIFF_UPDATED%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_UPDATED)%>></td>
-
 
710
                                                        <td width="50" nowrap class="form_field"><%=LIMG_UPDATED%>Updated</td>
-
 
711
                                                    </tr>
-
 
712
                                                    <tr>
-
 
713
                                                        <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_WARN%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_WARN)%>></td>
-
 
714
                                                        <td nowrap class="form_field"><%=LIMG_OUTDATED%>Updated with Warning</td>
-
 
715
                                                    </tr>
-
 
716
                                                    <tr>
-
 
717
                                                        <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_NEW%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_NEW)%>></td>
-
 
718
                                                        <td nowrap class="form_field"><%=LIMG_ADDED%>Added</td>
-
 
719
                                                    </tr>
-
 
720
                                                    <tr>
-
 
721
                                                        <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_REMOVED%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_REMOVED)%>></td>
-
 
722
                                                        <td nowrap class="form_field"><%=LIMG_REMOVED%>Removed</td>
-
 
723
                                                    </tr>
-
 
724
                                                    <tr>
-
 
725
                                                        <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_RIPPLE%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_RIPPLE)%>></td>
-
 
726
                                                        <td nowrap class="form_field"><%=LIMG_RIPPLED%>Rippled</td>
-
 
727
                                                    </tr>
-
 
728
                                                    <tr>
-
 
729
                                                        <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_NO_CHANGE%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_NO_CHANGE)%>></td>
-
 
730
                                                        <td nowrap class="form_field"><%=LIMG_UNCHANGED%>Unchanged</td>
-
 
731
                                                    </tr>
-
 
732
                                                    <tr>
-
 
733
                                                        <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_PENDING%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_PENDING)%>></td>
-
 
734
                                                        <td nowrap class="form_field"><%=LIMG_PENDING%>Pending</td>
-
 
735
                                                    </tr>
-
 
736
                                                    <tr>
-
 
737
                                                        <td>&nbsp;</td>
-
 
738
                                                        <td width="100%">
-
 
739
                                                            <input id=difilterBtn name="btn" type="submit" class="form_btn" value="Refresh" disabled="true">
-
 
740
                                                        </td>
-
 
741
                                                    </tr>
-
 
742
                                                </table>
-
 
743
                                                <img src onerror='initFilter();'>
-
 
744
                                            </fieldset>
-
 
745
                                            <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
-
 
746
                                        <%End If%>
-
 
747
                                    </td>
-
 
748
                                    <td></td>
-
 
749
                                </tr>
-
 
750
 
-
 
751
    </table>
-
 
752
    <!-- SELECT RELEASE A END ---------------------------------------------->
-
 
753
 <%
-
 
754
End Sub
-
 
755
Sub PanelB
-
 
756
%>
-
 
757
    <!-- SELECT RELEASE B ---------------------------------------------->
-
 
758
    <table width="100%"  border="0" cellspacing="10" cellpadding="0">
-
 
759
        <tr>
-
 
760
            <td align="left" class="body_col">
-
 
761
                <img src="images/i_rtag_open_mode.gif" border="0" align="absmiddle" width="15" height="13">&nbsp;Select Release B<hr size="1px" color="Olive" noshade>
-
 
762
            </td>
-
 
763
        </tr>
-
 
764
        <tr>
-
 
765
            <td align="left">
-
 
766
                <select name="projB" class="form_item" onChange="RequestReleaseCombo( '?proj_id='+ this.value, FormName.rtagB );">
-
 
767
                    <option value="">-- Select Project --</option>
-
 
768
                    <%
-
 
769
                    OraDatabase.Parameters.Add "PROJ_ID",     objRelCollectorB.Item("proj_id"),    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
770
 
-
 
771
                    Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ProjectsCombo.sql"), cint(0))
-
 
772
 
-
 
773
                    OraDatabase.Parameters.Remove "PROJ_ID"
-
 
774
 
-
 
775
                    While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-
 
776
                        <option value="<%=rsQry("proj_id")%>" <%=rsQry("selected")%>><%=rsQry("proj_name")%></option>
-
 
777
                        <%rsQry.MoveNext
-
 
778
                    WEnd
-
 
779
 
-
 
780
                    rsQry.Close
-
 
781
                    Set rsQry = Nothing
-
 
782
                    %>
-
 
783
                </select>
-
 
784
            </td>
-
 
785
        </tr>
-
 
786
        <tr>
-
 
787
            <td align="left">
-
 
788
                <select name="rtagB" id="rtagB" class="form_item">
-
 
789
                    <%
-
 
790
                    OraDatabase.Parameters.Add "PROJ_ID",     objRelCollectorB.Item("proj_id"),    ORAPARM_INPUT,  ORATYPE_NUMBER
-
 
791
                    OraDatabase.Parameters.Add "RTAG_ID",     objRelCollectorB.Item("rtag_id"),    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
792
 
-
 
793
                    Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleasesCombo.sql"), cint(0))
-
 
794
 
-
 
795
                    OraDatabase.Parameters.Remove "PROJ_ID"
-
 
796
                    OraDatabase.Parameters.Remove "RTAG_ID"
-
 
797
 
-
 
798
                    While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-
 
799
                            <option value="<%=rsQry("rtag_id")%>" <%=rsQry("selected")%>><%=rsQry("rtag_name")%></option>
-
 
800
                        <%rsQry.MoveNext
-
 
801
                    WEnd
-
 
802
 
-
 
803
                    rsQry.Close
-
 
804
                    Set rsQry = Nothing
-
 
805
                    %>
-
 
806
                </select>
-
 
807
            </td>
-
 
808
        </tr>
-
 
809
        <%If (parRtagB <> "") Then%>
-
 
810
            <tr>
-
 
811
                <td align="left"><a href="dependencies.asp?rtag_id=<%=parRtagB%>" class="body_txt_drk">Go To Release B &raquo;</a></td>
-
 
812
            </tr>
-
 
813
        <%End If%>
-
 
814
        <tr class="body_txt">
-
 
815
            <td>
-
 
816
            <%If (parRtagA <> "") AND (parRtagB <> "") AND isMergable Then%>
-
 
817
            <!-- Bulk Operations +++++++++++++++++++++++++++++++++++++++++++ -->
-
 
818
            <p>&nbsp;
-
 
819
            <fieldset style="width:200px;" >
-
 
820
                <legend class="body_txt">Bulk Operations</legend>
-
 
821
                <div>
-
 
822
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("UASrc");'><%=LIMG_UPDATED%>Add - Updated</button>
-
 
823
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("UWASrc");'><%=LIMG_OUTDATED%>Add - Updated with Warning</button>
-
 
824
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("RASrc");'><%=LIMG_REMOVED%>Add - Removed</button>
-
 
825
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("ABSrc");'><%=LIMG_ADDED%>Remove - Added</button>
-
 
826
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("URASrc");'><%=LIMG_RIPPLED%>Add - Rippled</button>
-
 
827
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("BBSrc");'><%=LIMG_UNCHANGED%>Remove - Unchanged</button>
-
 
828
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("APSBSrc");'><%=LIMG_PENDING%>Remove - Pending Removal</button>
-
 
829
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("APABSrc");'><%=LIMG_PENDING%>Remove - Pending Addition</button>
-
 
830
                    <button type="button" class="BulkButton form_btn_comp" onClick='processAll("undoSrc");'><%=LIMG_PENDING%>Revert All</button>
-
 
831
                </div>
-
 
832
            </fieldset>
-
 
833
        <%End If%>
-
 
834
        </td>
-
 
835
        </tr>
-
 
836
    </table>
-
 
837
    <!-- SELECT RELEASE B END ---------------------------------------------->
-
 
838
<%
-
 
839
End Sub
-
 
840
Sub CenterPanel
-
 
841
 %>
-
 
842
    <!-- DIFF -------------------------------------------------------->
-
 
843
    <table width="100%" border="0" cellspacing="10" cellpadding="0">
-
 
844
        <tr>
-
 
845
            <td>
-
 
846
                <table width="100%" border="0" cellspacing="0" cellpadding="0" class='rounded_box rounded_box_pad'>
-
 
847
                    <caption>
-
 
848
                        DIFF / MERGE RELEASE
-
 
849
                        <%If genReport Then%>
-
 
850
                            &nbsp;[Generating Report]
-
 
851
                         <%End If%>
-
 
852
                    </caption>
-
 
853
                    <tr>
-
 
854
                        <td bgcolor="#FFFFFF" valign="top" class="form_item">
-
 
855
                            <table width="100%"  border="0" cellspacing="0" cellpadding="5">
-
 
856
                                <tr>
-
 
857
                                    <td width="100%" bgcolor="#DAD7C8">
-
 
858
                                        <input type="submit" name="btn" value="Compare" class="form_btn_comp" style="margin-right:5px;">
-
 
859
                                        <input type="submit" name="btn" value="Swap Compare" class="form_btn_comp">
-
 
860
                                        <span class="body_txt">
-
 
861
                                            <input name="btn" type="submit" class="form_btn" value="Mail Me Report">
-
 
862
                                            <%'<input name="btn" type="submit" class="form_btn" value="Show Me Report">%>
-
 
863
                                        </span>
-
 
864
                                    </td>
-
 
865
                                    <td width="1" align="right" bgcolor="#DAD7C8" nowrap>
-
 
866
                                        <table width="100%"  border="0" cellspacing="0" cellpadding="0">
-
 
867
                                            <tr>
-
 
868
                                                <%
-
 
869
                                                    Dim mergeMessage, mergeDisabled
-
 
870
                                                    mergeDisabled = " disabled"
-
 
871
                                                    If (parRtagA = "") Then
-
 
872
                                                        mergeMessage = "Select Release A"
-
 
873
                                                    ElseIf (parRtagB = "") Then
-
 
874
                                                        mergeMessage = "Select Release B"
-
 
875
                                                    ElseIf NOT isMergable Then
-
 
876
                                                        mergeMessage = "Release B cannot be modified"
-
 
877
                                                    Else
-
 
878
                                                        mergeDisabled = ""
-
 
879
                                                    End If
-
 
880
                                                %>
-
 
881
                                                <td class="err_alert nowrap" style="padding-right:1em">
-
 
882
                                                    <%=mergeMessage%>
-
 
883
                                                </td>
-
 
884
                                                <td>
-
 
885
                                                    <input type="submit" name="btn" value="Merge" class="form_btn_comp" style="margin-right:10px;" <%=mergeDisabled%>>
-
 
886
                                                </td>
-
 
887
                                                <td>
-
 
888
                                                    <input type="submit" name="btn" value="Exit" class="form_btn_comp">
-
 
889
                                                </td>
-
 
890
                                            </tr>
-
 
891
                                        </table>
-
 
892
                                    </td>
-
 
893
                                </tr>
-
 
894
                            </table>
-
 
895
 
-
 
896
                            <%
-
 
897
                            ' Successfull Merge
-
 
898
                            If (Request("btn") = "Merge") Then
-
 
899
                                Call Messenger ( "Merge has completed successfully.", 3, "100%" )
-
 
900
                            End If
-
 
901
 
-
 
902
                            If genReport Then
-
 
903
                                Set FSO=Server.CreateObject("Scripting.FileSystemObject")
-
 
904
                                Set NewTextFile=FSO.CreateTextFile(reportPath, true)
-
 
905
 
-
 
906
                                Call Header()
-
 
907
                            End If
-
 
908
 
-
 
909
                            If (parRtagA <> "") AND (parRtagB <> "")Then%>
-
 
910
                                <table width="100%"  border="0" cellspacing="1" cellpadding="0">
-
 
911
                                    <tr>
-
 
912
                                        <td width="50%" bgcolor="#E4E9EC" class="body_row" nowrap><%= ReleaseIcon(objRelCollectorA.Item("official")) & objRelCollectorA.Item("location")%> </td>
-
 
913
                                        <td width="1" bgcolor="#E4E9EC"><img src="images/spacer.gif" width="20" height="1"></td>
-
 
914
                                        <td width="1" bgcolor="#E4E9EC"><img src="images/spacer.gif" width="20" height="20"></td>
-
 
915
                                        <td width="1" bgcolor="#E4E9EC"><img src="images/spacer.gif" width="20" height="1"></td>
-
 
916
                                        <td width="50%" bgcolor="#E4E9EC" class="body_row" nowrap><%= ReleaseIcon(objRelCollectorB.Item("official")) & objRelCollectorB.Item("location")%></td>
-
 
917
                                        <td width="1" bgcolor="#E4E9EC"><img src="images/spacer.gif" width="20" height="1"></td>
-
 
918
                                    </tr>
-
 
919
                                    <%
-
 
920
                                    OraDatabase.Parameters.Add "RTAG_A",     parRtagA,    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
921
                                    OraDatabase.Parameters.Add "RTAG_B",     parRtagB,    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
922
                                    OraDatabase.Parameters.Add "NO_CHANGE",  GetIsDiffFilterChecked(enumDB_NUM_DIFF_NO_CHANGE), ORAPARM_INPUT, ORATYPE_VARCHAR2
-
 
923
                                    OraDatabase.Parameters.Add "ADDED",      GetIsDiffFilterChecked(enumDB_NUM_DIFF_NEW),       ORAPARM_INPUT, ORATYPE_VARCHAR2
-
 
924
                                    OraDatabase.Parameters.Add "UPDATED",    NULL,                                              ORAPARM_INPUT, ORATYPE_VARCHAR2
-
 
925
                                    OraDatabase.Parameters.Add "REMOVED",    GetIsDiffFilterChecked(enumDB_NUM_DIFF_REMOVED),   ORAPARM_INPUT, ORATYPE_VARCHAR2
-
 
926
 
-
 
927
                                    Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleaseDiff.sql"), cint(0))
-
 
928
 
-
 
929
                                    OraDatabase.Parameters.Remove "RTAG_A"
-
 
930
                                    OraDatabase.Parameters.Remove "RTAG_B"
-
 
931
                                    OraDatabase.Parameters.Remove "NO_CHANGE"
-
 
932
                                    OraDatabase.Parameters.Remove "ADDED"
-
 
933
                                    OraDatabase.Parameters.Remove "UPDATED"
-
 
934
                                    OraDatabase.Parameters.Remove "REMOVED"
-
 
935
 
-
 
936
                                    Set rsQryA = OraDatabase.DbCreateDynaset( "SELECT RT.RTAG_NAME, PRJ.PROJ_NAME FROM RELEASE_TAGS RT, PROJECTS PRJ WHERE RTAG_ID="& parRtagA &" AND RT.PROJ_ID=PRJ.PROJ_ID", cint(0))
-
 
937
                                    Set rsQryB = OraDatabase.DbCreateDynaset( "SELECT RT.RTAG_NAME, PRJ.PROJ_NAME FROM RELEASE_TAGS RT, PROJECTS PRJ WHERE RTAG_ID="& parRtagB &" AND RT.PROJ_ID=PRJ.PROJ_ID", cint(0))
-
 
938
 
-
 
939
                                    If genReport Then
-
 
940
                                        Call Javascript()
-
 
941
                                        Call Styles()
-
 
942
 
-
 
943
                                        NewTextFile.WriteLine("<title>Difference Report Between "&rsQryA("proj_name")&" "&rsQryA("rtag_name")&" and "&rsQryB("proj_name")&" "&rsQryB("rtag_name")&"</title>")
-
 
944
                                        NewTextFile.WriteLine("<div class=""page_title"">Difference Report Between "&rsQryA("proj_name")&" "&rsQryA("rtag_name")&" and "&rsQryB("proj_name")&" "&rsQryB("rtag_name")&"</div><br>")
-
 
945
                                        NewTextFile.WriteLine("<b>Key:</b><br><blockquote>")
-
 
946
                                        NewTextFile.WriteLine("<span class=changesa><b>SOURCE CODE CHANGES</b></span><span class=texta> Indicates Changes to a Package in "& rsQryA("rtag_name") &".</span><br>")
-
 
947
                                        NewTextFile.WriteLine("<span class=changesb><b>SOURCE CODE CHANGES</b></span><span class=textb> Indicates Changes to a Package in "& rsQryB("rtag_name") &".</span><br>")
-
 
948
                                        NewTextFile.WriteLine("<span class=changesnone><b>Grey Text</b></span><span class=textnone> No Source Code Changes to a Package in either Release.</span>")
-
 
949
                                        NewTextFile.WriteLine("</blockquote>")
-
 
950
 
-
 
951
                                        NewTextFile.WriteLine("<b>Toggle Sections:</b><blockquote>")
-
 
952
                                        NewTextFile.WriteLine("<span class=pointer onClick=""MM_toggleAll('divPkgInfo','1');"">Expand All</span>")
-
 
953
                                        NewTextFile.WriteLine("<span class=pointer onClick=""MM_toggleAll('divPkgInfo','');"">Collapse All</span>")
-
 
954
                                        NewTextFile.WriteLine("</blockquote>")
-
 
955
                                    End If
-
 
956
 
-
 
957
                                    Dim currView_id
-
 
958
                                    currView_id = -1
-
 
959
 
-
 
960
                                    While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
-
 
961
                                        errormsg = false
-
 
962
                                        rowId = rsQry("pv_id_a") &"_"& rsQry("pv_id_b")
-
 
963
 
-
 
964
                                        btnMerge = LIMG_MERGE
-
 
965
                                        btnRemove = LIMG_REMOVE
-
 
966
 
-
 
967
                                        changeType = rsQry("change_type")
-
 
968
                                        isaSdk = rsQry("PKG_SDK_B")
-
 
969
 
-
 
970
                                        If changeType = "U" OR changeType = "UW" OR changeType = "UR" Then
-
 
971
                                            Dim MajorA, MajorB, MinorA, MinorB, PatchA, PatchB, BuildA, BuildB, pos, pkgVersionA, pkgVersionB, majMinA, majMinB
-
 
972
                                            MajorA = NULL
-
 
973
                                            MajorB = NULL
-
 
974
                                            MinorA = NULL
-
 
975
                                            MinorB = NULL
-
 
976
 
-
 
977
                                            pkgVersionA = rsQry("pkg_version_a")
-
 
978
                                            pkgVersionB = rsQry("pkg_version_b")
-
 
979
 
-
 
980
                                            PatchA = rsQry("patch_number_a")
-
 
981
                                            PatchB = rsQry("patch_number_b")
-
 
982
                                            BuildA = rsQry("build_number_a")
-
 
983
                                            BuildB = rsQry("build_number_b")
-
 
984
 
-
 
985
 
-
 
986
                                            ' Find the first occurence of the dot in package version A
-
 
987
                                            pos = InStr(pkgVersionA, ".")
-
 
988
                                            If pos <> 0 Then
-
 
989
                                                ' Extract the Major Version for A
-
 
990
                                                MajorA = Mid(pkgVersionA, 1, pos - 1)
-
 
991
                                                ' Delete the Major Version Value from the string to get the minor and patch version
-
 
992
                                                pkgVersionA = Mid(pkgVersionA, pos + 1, Len(pkgVersionA))
-
 
993
                                                ' Find the second occurence of the dot in package version A
-
 
994
                                                pos = InStr(pkgVersionA, ".")
-
 
995
                                                ' Extract the Minor Version for A
-
 
996
                                                If pos <> 0 Then
-
 
997
                                                    MinorA = Mid(pkgVersionA, 1, pos - 1)
-
 
998
                                                End If
-
 
999
                                            End If
-
 
1000
 
-
 
1001
                                            ' Find the first occurence of the dot in package version B
-
 
1002
                                            pos = InStr(pkgVersionB, ".")
-
 
1003
                                            If pos <> 0 Then
-
 
1004
                                                ' Extract the Major Version for B
-
 
1005
                                                MajorB = Mid(pkgVersionB, 1, pos - 1)
-
 
1006
                                                ' Delete the Major Version Value from the string to get the minor and patch version
-
 
1007
                                                pkgVersionB = Mid(pkgVersionB, pos + 1, Len(pkgVersionB))
-
 
1008
                                                ' Find the second occurence of the dot in package version B
-
 
1009
                                                pos = InStr(pkgVersionB, ".")
-
 
1010
                                                ' Extract the Minor Version for B
-
 
1011
                                                If pos <> 0 Then
-
 
1012
                                                    MinorB = Mid(pkgVersionB, 1, pos - 1)
-
 
1013
                                                End If
-
 
1014
                                            End If
-
 
1015
 
-
 
1016
                                            If MajorA = MajorB Then
-
 
1017
                                                If MinorA = MinorB Then
-
 
1018
                                                    If IsNumeric(PatchA) AND IsNumeric(PatchB) Then
-
 
1019
                                                        If CInt(PatchB) > CInt(PatchA) Then
-
 
1020
                                                            btnMerge = LIMG_MERGE_WARN
-
 
1021
                                                        Else
-
 
1022
                                                            btnMerge = LIMG_MERGE
-
 
1023
                                                        End If
-
 
1024
                                                    End If
-
 
1025
                                                Else
-
 
1026
                                                    If IsNumeric(MinorA) AND IsNumeric(MinorB) Then
-
 
1027
                                                        If CInt(MinorB) > CInt(MinorA) Then
-
 
1028
                                                            btnMerge = LIMG_MERGE_WARN
-
 
1029
                                                        Else
-
 
1030
                                                            btnMerge = LIMG_MERGE
-
 
1031
                                                        End If
-
 
1032
                                                    End If
-
 
1033
                                                End If
-
 
1034
                                            Else
-
 
1035
                                                If IsNumeric(MajorA) AND IsNumeric(MajorB) Then
-
 
1036
                                                    If     CInt(MajorB) > CInt(MajorA) Then
-
 
1037
                                                        btnMerge = LIMG_MERGE_WARN
-
 
1038
                                                    Else
-
 
1039
                                                        btnMerge = LIMG_MERGE
-
 
1040
                                                    End If
-
 
1041
                                                End If
-
 
1042
                                            End If
-
 
1043
 
-
 
1044
                                            If btnMerge = LIMG_MERGE_WARN Then
-
 
1045
                                                changeType = "UW"
-
 
1046
                                            End If
-
 
1047
                                        End If
-
 
1048
 
-
 
1049
                                        ' -------- END GROUP ------------------------
-
 
1050
                                        %>
-
 
1051
                                        <%
-
 
1052
                                        'Determine if we are dealing with a PV_ID that we have already encountered and displayed as a pending addition
-
 
1053
                                        'If we are, we do not need to display anything more about it, so skip the row.
-
 
1054
                                        ' NOTE. the result set is sorted by change type (see releasediff.sql) such that if there are multiple entries
-
 
1055
                                        '         for the same PV_ID, they are sorted in the following order: pending, unchanged, additions, removals, updates.
-
 
1056
                                        '         This is important to the row skip filtering carried out below.
-
 
1057
                                        Dim skipRow
-
 
1058
                                        If rsQry("pv_id_a") Then
-
 
1059
                                            skipRow = pkgSeen.Exists(CStr(rsQry("pv_id_a")))
-
 
1060
                                            pkgSeen.Item(CStr(rsQry("pv_id_a"))) = 1
-
 
1061
                                        Else
-
 
1062
                                            skipRow = FALSE
-
 
1063
                                        End If
-
 
1064
 
-
 
1065
                                        If GetIsDiffFilterChecked(enumDB_NUM_DIFF_PENDING) <> "" Then
-
 
1066
                                            If changeType = "APS" OR changeType = "APA" Then
-
 
1067
                                                skipRow = TRUE
-
 
1068
                                            End If
-
 
1069
                                        End If
-
 
1070
 
-
 
1071
                                        If GetIsDiffFilterChecked(enumDB_NUM_DIFF_UPDATED) <> "" Then
-
 
1072
                                            If changeType = "U" Then
-
 
1073
                                                skipRow = TRUE
-
 
1074
                                            End If
-
 
1075
                                        End If
-
 
1076
 
-
 
1077
                                        If GetIsDiffFilterChecked(enumDB_NUM_DIFF_WARN) <> "" Then
-
 
1078
                                            If changeType = "UW" Then
-
 
1079
                                                skipRow = TRUE
-
 
1080
                                            End If
-
 
1081
                                        End If
-
 
1082
 
-
 
1083
                                        If GetIsDiffFilterChecked(enumDB_NUM_DIFF_RIPPLE) <> "" Then
-
 
1084
                                            If changeType = "UR" Then
-
 
1085
                                                skipRow = TRUE
-
 
1086
                                            End If
-
 
1087
                                        End If
-
 
1088
 
-
 
1089
                                        If NOT skipRow Then
-
 
1090
                                            Call GetDiffStateIcon ( changeType, ChangeTypeIcon )
-
 
1091
 
-
 
1092
                                        colorA = LCOLOR_NOT_CHANGED
-
 
1093
                                        colorB = LCOLOR_NOT_CHANGED
-
 
1094
                                        Select Case changeType
-
 
1095
                                            Case "U"
-
 
1096
                                                colorA = LCOLOR_CHANGED
-
 
1097
                                                colorB = LCOLOR_CHANGED
-
 
1098
                                            Case "UW"
-
 
1099
                                                colorA = LCOLOR_OUTDATED
-
 
1100
                                                colorB = LCOLOR_OUTDATED
-
 
1101
                                                btnMerge = LIMG_MERGE_WARN
-
 
1102
                                            Case "UR"
-
 
1103
                                                colorA = LCOLOR_RIPPLED
-
 
1104
                                                colorB = LCOLOR_RIPPLED
-
 
1105
                                            Case "A"
-
 
1106
                                                colorA = LCOLOR_BLANK
-
 
1107
                                            Case "R"
-
 
1108
                                                colorB = LCOLOR_BLANK
-
 
1109
                                        End Select
-
 
1110
 
-
 
1111
 
-
 
1112
                                        ' -------- GROUP BY BASE VIEW  -----------------
-
 
1113
                                        If CDbl(currView_id) <> CDbl(rsQry("view_id")) Then
-
 
1114
                                        %>
-
 
1115
                                            <tr>
-
 
1116
                                                <td valign="top" nowrap class="form_ttl"><b><%=rsQry("view_name")%></b></td>
-
 
1117
                                                <td class="form_ttl">&nbsp;</td>
-
 
1118
                                                <td class="form_ttl">&nbsp;</td>
-
 
1119
                                                <td class="form_ttl">&nbsp;</td>
-
 
1120
                                                <td class="form_ttl">&nbsp;</td>
-
 
1121
                                                <td class="form_ttl">&nbsp;</td>
-
 
1122
                                            </tr>
-
 
1123
                                        <%
-
 
1124
                                            currView_id = CDbl(rsQry("view_id"))
-
 
1125
                                        End If
-
 
1126
                                        %>
-
 
1127
                                            <tr>
-
 
1128
                                                <td class="body_row" nowrap>
-
 
1129
                                                    <DIV id="PVA<%=rowId%>" style="background:<%=colorA%>; padding:5px;" data_color="<%=colorA%>">
-
 
1130
                                                        <%=rsQry("pkg_name_a") &" "& rsQry("pkg_version_a")%>
-
 
1131
                                                    </DIV>
-
 
1132
                                                </td>
-
 
1133
 
-
 
1134
                                                <%
-
 
1135
                                                Dim pkgADisplayControl
-
 
1136
                                                pkgADisplayControl = isMergable
-
 
1137
                                                Dim pkgAClass: pkgAClass = changeType & "ASrc" 
-
 
1138
 
-
 
1139
                                                If IsNull( changeType ) OR (changeType = "A")  OR (changeType = "B") OR (changeType = "APA")  OR (changeType = "APS")  Then pkgADisplayControl = FALSE
-
 
1140
                                                If isaSdk Then pkgADisplayControl = FALSE
-
 
1141
                                                %>
-
 
1142
                                                <td bgcolor="#F5F5F5">
-
 
1143
                                                    <%If pkgADisplayControl Then%>
-
 
1144
                                                        <DIV id="IMGMERGE<%=rowId%>" class='<%=pkgAClass%> pointer' onClick="MergePackage( '<%=rsQry("pv_id_a")%>', '<%=rsQry("pv_id_b")%>', '<%=rowId%>' );"><%=btnMerge%></DIV>
-
 
1145
                                                    <%End If%>
-
 
1146
                                                </td>
-
 
1147
 
-
 
1148
                                                <td bgcolor="#E4E9EC">
-
 
1149
                                                    <DIV id="IMGSTATE<%=rowId%>" DATA_CT="<%=changeType%>"><%=ChangeTypeIcon%></DIV>
-
 
1150
                                                </td>
-
 
1151
 
-
 
1152
                                                <%
-
 
1153
                                                Dim pkgBDisplayControl
-
 
1154
                                                pkgBDisplayControl = isMergable
-
 
1155
                                                Dim pkgBClass: pkgBClass = changeType & "BSrc" 
-
 
1156
                                                If changeType = "R" Then pkgBDisplayControl = FALSE
-
 
1157
                                                If isaSdk Then pkgBDisplayControl = FALSE
-
 
1158
                                                %>
-
 
1159
                                                <td bgcolor="#F5F5F5">
-
 
1160
                                                    <%If pkgBDisplayControl Then%>
-
 
1161
                                                        <DIV id="IMGREMOVE<%=rowId%>" class='<%=pkgBClass%> pointer' onClick="RemovePackage( '<%=rsQry("pv_id_a")%>', '<%=rsQry("pv_id_b")%>', '<%=rowId%>' );"><%=btnRemove%></DIV>
-
 
1162
                                                    <%ElseIf isaSdk Then %>
-
 
1163
                                                        <DIV ><%=LIMG_SDK%></DIV>
-
 
1164
                                                    <%End If%>
-
 
1165
                                                </td>
-
 
1166
 
-
 
1167
                                                <td class="body_row" nowrap>
-
 
1168
                                                    <DIV id="PVB<%=rowId%>"
-
 
1169
                                                         style="background:<%=colorB%>; padding:5px;"
-
 
1170
                                                         data_color="<%=colorB%>"
-
 
1171
                                                         data_pkg="<%=rsQry("pkg_name_b") &" "& rsQry("pkg_version_b")%>"
-
 
1172
                                                         >
-
 
1173
                                                        <%=rsQry("pkg_name_b") &" "& rsQry("pkg_version_b")%>
-
 
1174
                                                        <%If ChangeType = "APS" Then%>
-
 
1175
                                                                (removal pending<%=Quick_Help("RemovalPending")%>)
-
 
1176
                                                        <%ElseIf ChangeType = "APA" Then%>
-
 
1177
                                                                (addition pending<%=Quick_Help("AdditionPending")%>)
-
 
1178
                                                        <%End If %>
-
 
1179
                                                    </DIV>
-
 
1180
                                                    <input type="hidden" disabled="disabled" name="addpkg" id="ADDPKG_<%=rowId%>" value="">
-
 
1181
                                                    <input type="hidden" disabled="disabled" name="removepkg" id="REMOVEPKG_<%=rowId%>" value="">
-
 
1182
                                                </td>
-
 
1183
 
-
 
1184
                                                <td bgcolor="#F5F5F5">
-
 
1185
                                                    <DIV id="IMGUNDO<%=rowId%>" style="display:none;" class='undoSrc pointer' onClick="UndoPackage( '<%=rowId%>' );"><%=LIMG_UNDO%></DIV>
-
 
1186
                                                </td>
-
 
1187
                                            </tr>
-
 
1188
                                        <%End If %>
-
 
1189
 
-
 
1190
                                        <%
-
 
1191
                                        If genReport AND NOT skipRow  Then
-
 
1192
                                            If rsQry("pv_id_a") Then
-
 
1193
                                                Set rsQryCommentsA = OraDatabase.DbCreateDynaset( "SELECT COMMENTS FROM PACKAGE_VERSIONS WHERE PV_ID="& rsQry("pv_id_a"), cint(0))
-
 
1194
                                            End If
-
 
1195
 
-
 
1196
                                            If rsQry("pv_id_b") Then
-
 
1197
                                                Set rsQryCommentsB = OraDatabase.DbCreateDynaset( "SELECT COMMENTS FROM PACKAGE_VERSIONS WHERE PV_ID="& rsQry("pv_id_b"), cint(0))
-
 
1198
                                            End If
-
 
1199
 
-
 
1200
                                            pkgA = rsQry("pkg_name_a")
-
 
1201
                                            pkgB = rsQry("pkg_name_b")
-
 
1202
 
-
 
1203
                                            If pkgA <> "" then
-
 
1204
                                                pkgname = pkgA
-
 
1205
                                            Else
-
 
1206
                                                pkgname = pkgB
-
 
1207
                                            End If
-
 
1208
 
-
 
1209
                                            If changeType = "U" OR  changeType = "UW" Then
-
 
1210
                                                ChangeASource = false
-
 
1211
                                                ChangeAUpdate = false
-
 
1212
                                                ChangeBSource = false
-
 
1213
                                                ChangeBUpdate = false
-
 
1214
 
-
 
1215
                                                If genReport Then
-
 
1216
                                                    'NewTextFile.WriteLine("<br><b><font face="&chr(34)&"arial"&chr(34)&">"&pkgname&"</font></b>")
-
 
1217
                                                    NewTextFile.Write("<span class=""body_scol pointer"" onClick=""toggleSPAN('"& rowId &"');"">"& pkgname &"</span>")
-
 
1218
                                                    NewTextFile.WriteLine("<DIV class=divPkgInfo id=""spanPkgInfo"& rowId &""" name=""spanPkgInfo"" style=""display:none;"">")
-
 
1219
                                                    NewTextFile.Write(rsQryA("rtag_name")&" uses: "&rsQry("pkg_version_a")&" (")
-
 
1220
                                                    Call Release(rsQry("pv_id_a"))
-
 
1221
                                                    NewTextFile.WriteLine(")<br>")
-
 
1222
                                                    NewTextFile.Write(rsQryB("rtag_name")&" uses: "&rsQry("pkg_version_b")&" (")
-
 
1223
                                                    Call Release(rsQry("pv_id_b"))
-
 
1224
                                                    NewTextFile.WriteLine(")<br>")
-
 
1225
 
-
 
1226
                                                    a = rsQry("pv_id_a")
-
 
1227
                                                    b = rsQry("pv_id_b")
-
 
1228
                                                    c = rsQry("pv_id_a")
-
 
1229
                                                    d = rsQry("pv_id_b")
-
 
1230
 
-
 
1231
                                                    Set pvCollectionA = CreateObject("Scripting.Dictionary")
-
 
1232
                                                    Set pvCollectionB = CreateObject("Scripting.Dictionary")
-
 
1233
                                                    On Error Resume Next
-
 
1234
                                                    While CLng(a) <> CLng(b) and NOT errormsg
-
 
1235
 
-
 
1236
                                                        'NewTextFile.WriteLine("A: "&a)
-
 
1237
                                                        'NewTextFile.WriteLine("B: "&b)
-
 
1238
                                                        pvCollectionA.Add CStr(a), Empty
-
 
1239
                                                        pvCollectionB.Add CStr(b), Empty
-
 
1240
                                                        If CLng(a) > CLng(b) Then
-
 
1241
                                                            'NewTextFile.WriteLine("TestA")
-
 
1242
                                                            Call LastPvIdA(a)
-
 
1243
                                                        ElseIf CLng(b) > CLng(a) Then
-
 
1244
                                                            'NewTextFile.WriteLine("TestB")
-
 
1245
                                                            Call LastPvIdB(b)
-
 
1246
                                                        End If
-
 
1247
                                                    Wend
-
 
1248
 
-
 
1249
                                                    Set pvCollectionA = Nothing
-
 
1250
                                                    Set pvCollectionB = Nothing
-
 
1251
 
-
 
1252
                                                    Call pkg_Version(a)
-
 
1253
                                                    NewTextFile.Write("Common PARENT package version: "&pkgversion&" (")
-
 
1254
                                                    Call Release(a)
-
 
1255
                                                    NewTextFile.WriteLine(")<br><br>")
-
 
1256
                                                    NewTextFile.WriteLine()
-
 
1257
                                                    NewTextFile.WriteLine("<b>"&rsQryA("rtag_name")&"</b>")
-
 
1258
 
-
 
1259
                                                    If pkgversion <> rsQry("pkg_version_a") Then
-
 
1260
                                                        NewTextFile.WriteLine("<blockquote><b><i>Versions between "& pkgversion &" and "& rsQry("pkg_version_a")&"</i></b></blockquote>")
-
 
1261
 
-
 
1262
                                                        If errormsg Then
-
 
1263
                                                            NewTextFile.WriteLine("Error determining root!<br>")
-
 
1264
                                                            NewTextFile.WriteLine()
-
 
1265
                                                        End If
-
 
1266
 
-
 
1267
                                                        source_change = false
-
 
1268
 
-
 
1269
                                                        While CLng(a) <> CLng(c) and NOT errormsg
-
 
1270
                                                            Call Comments(c)
-
 
1271
                                                            If scFlag = TRUE Then
-
 
1272
                                                                Call GetFixedIssues(c)
-
 
1273
                                                            End If
-
 
1274
                                                            Call LastPvIdAa(c)
-
 
1275
                                                            NewTextFile.WriteLine()
-
 
1276
                                                        Wend
-
 
1277
 
-
 
1278
                                                        If source_change = false Then
-
 
1279
                                                            NewTextFile.WriteLine("<blockquote><b><i>No source changes to "& rsQryA("rtag_name")&". Only Rippled Builds.</i></b></blockquote><br>")
-
 
1280
                                                            ChangeASource = true
-
 
1281
                                                        End If
-
 
1282
 
-
 
1283
                                                        Call pkg_Version(b)
-
 
1284
                                                        NewTextFile.WriteLine()
-
 
1285
                                                        NewTextFile.WriteLine()
-
 
1286
 
-
 
1287
                                                    ElseIf pkgversion = rsQry("pkg_version_a") Then
-
 
1288
                                                        NewTextFile.WriteLine("<blockquote><b><i>No updates to "& rsQryA("rtag_name")&"</i></b></blockquote><br>")
-
 
1289
                                                        ChangeAUpdate = true
-
 
1290
                                                        NewTextFile.WriteLine()
-
 
1291
                                                    End If
-
 
1292
 
-
 
1293
                                                    NewTextFile.WriteLine("<b>"&rsQryB("rtag_name")&"</b>")
-
 
1294
 
-
 
1295
                                                    If pkgversion <> rsQry("pkg_version_b") Then
-
 
1296
                                                        NewTextFile.WriteLine("<blockquote><b><i>Versions between "& pkgversion &" and "& rsQry("pkg_version_b")&"</i></b></blockquote>")
-
 
1297
 
-
 
1298
                                                        If errormsg Then
-
 
1299
                                                            NewTextFile.WriteLine("Error determining root!<br>")
-
 
1300
                                                            NewTextFile.WriteLine()
-
 
1301
                                                        End If
-
 
1302
 
-
 
1303
                                                        source_change = false
-
 
1304
 
-
 
1305
                                                        While CLng(b) <> CLng(d) and NOT errormsg
-
 
1306
                                                            Call Comments(d)
-
 
1307
                                                            If scFlag = TRUE Then
-
 
1308
                                                                Call GetFixedIssues(d)
-
 
1309
                                                            End If
-
 
1310
                                                            Call LastPvIdBb(d)
-
 
1311
                                                            NewTextFile.WriteLine()
-
 
1312
                                                        Wend
-
 
1313
 
-
 
1314
                                                        If source_change = false Then
-
 
1315
                                                            NewTextFIle.WriteLine("<blockquote><b><i>No source changes to "& rsQryB("rtag_name")&". Only Rippled Builds.</i></b></blockquote><br>")
-
 
1316
                                                            ChangeBSource = true
-
 
1317
                                                        End If
-
 
1318
 
-
 
1319
                                                    ElseIf pkgversion = rsQry("pkg_version_b") Then
-
 
1320
                                                        NewTextFile.WriteLine("<blockquote><b><i>No updates to "& rsQryB("rtag_name")&"</i></b></blockquote><br>")
-
 
1321
                                                        ChangeBUpdate = true
-
 
1322
                                                        NewTextFile.WriteLine()
-
 
1323
                                                    End If
-
 
1324
 
-
 
1325
                                                    NewTextFile.WriteLine("</DIV>")
-
 
1326
 
-
 
1327
                                                    If ChangeASource Then
-
 
1328
                                                        If ChangeBSource Then
-
 
1329
                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": .</b class=changesnone> Ripple Builds Only.</td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &": </b class=changesnone> Ripple Builds Only.</td>  </tr></table></blockquote>")
-
 
1330
                                                        ElseIf ChangeBUpdate Then
-
 
1331
                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": </b><span class=changesnone>Ripple Builds Only.</span></td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &": </b><span class=changesnone> No Updates.</span></td>  </tr></table></blockquote>")
-
 
1332
                                                        ElseIf NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1333
                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0""><tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>Ripple Builds Only.</span></td>    <td width=""50%"">    <b>"& Ucase(rsQryB("rtag_name")) &":</b> <b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1334
                                                        End If
-
 
1335
                                                    End If
-
 
1336
 
-
 
1337
                                                    If ChangeBSource Then
-
 
1338
                                                        If NOT ChangeAUpdate Then
-
 
1339
                                                            If NOT ChangeASource AND NOT ChangeBUpdate Then
-
 
1340
                                                                NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": </b><b class=changesa> SOURCE CODE CHANGES</b>.</td>    <td width=""50%""> <b>"& Ucase(rsQryB("rtag_name")) &":</b> <span class=changesnone> Ripple Builds Only.</span></td>  </tr></table></blockquote>")
-
 
1341
                                                            End If
-
 
1342
                                                        End If
-
 
1343
                                                    End If
-
 
1344
 
-
 
1345
                                                    If NOT ChangeASource Then
-
 
1346
                                                        If NOT ChangeAUpdate Then
-
 
1347
                                                            If NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1348
                                                                NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <b class=changesa> SOURCE CODE CHANGES.</b></td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &":</b><b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1349
                                                            ElseIf ChangeBUpdate Then
-
 
1350
                                                                NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <b class=changesa> SOURCE CODE CHANGES.</b></td> <td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &":</b><span class=changesnone> No Updates.</span></td>  </tr></table></blockquote>")
-
 
1351
                                                            End If
-
 
1352
                                                        ElseIf ChangeAUpdate Then
-
 
1353
                                                            If NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1354
                                                                NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>No Updates.</span></td> <td width=""50%"">  <b></font>"& Ucase(rsQryB("rtag_name")) &":</b><b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1355
                                                            ElseIf ChangeBSource Then
-
 
1356
                                                                NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>No Updates.</span></td> <td width=""50%""> </font><b>"& Ucase(rsQryB("rtag_name")) &":</b> <span class=changesnone> Ripple Builds Only.</span></td>  </tr></table></blockquote>")
-
 
1357
                                                            End If
-
 
1358
                                                        End If
-
 
1359
                                                    End If
-
 
1360
                                                End If
-
 
1361
 
-
 
1362
                                            End If  'changeType = "U" OR  changeType = "UW"
-
 
1363
 
-
 
1364
                                        End If  'email
-
 
1365
 
-
 
1366
                                        rsQry.MoveNext
-
 
1367
                                    WEnd
-
 
1368
 
-
 
1369
                                    rsQry.Close
-
 
1370
                                    Set rsQry = Nothing
-
 
1371
                                    %>
-
 
1372
                                    <%
-
 
1373
                                    If genReport Then
-
 
1374
                                        Call Footer()
-
 
1375
                                        NewTextFile.Close
-
 
1376
                                        Set NewTextFile=Nothing
-
 
1377
                                    End If
-
 
1378
                                    %>
-
 
1379
                                </table>
-
 
1380
                                <br>
-
 
1381
                            <%Else%>
-
 
1382
                                <br>
-
 
1383
                                <%
-
 
1384
                                If (parRtagB <> "") Then
-
 
1385
                                    Call Messenger ( "Select <b>Release A</b> to compare.", 3, "100%" )
-
 
1386
                                ElseIf (parRtagA <> "") Then
-
 
1387
                                    Call Messenger ( "Select <b>Release B</b> to compare.", 3, "100%" )
-
 
1388
                                Else
-
 
1389
                                    Call Messenger ( "Select <b>Release A</b> and <b>Release B</b> to compare.", 3, "100%" )
-
 
1390
                                End If
-
 
1391
                                %>
-
 
1392
                            <%End If%>
-
 
1393
                        </td>
-
 
1394
                    </tr>
-
 
1395
                </table>
-
 
1396
            </td>
-
 
1397
        </tr>
-
 
1398
    </table>
-
 
1399
    <!-- DIFF END ---------------------------------------------------->
-
 
1400
<%
-
 
1401
End Sub
639
%>
1402
%>
640
<html>
1403
<html>
641
<head>
1404
<head>
642
<title>Release Manager</title>
1405
<title>Release Manager</title>
643
<link rel="shortcut icon" href="<%=FavIcon%>"/>
1406
<link rel="shortcut icon" href="<%=FavIcon%>"/>
Line 801... Line 1564...
801
    // Show undo button
1564
    // Show undo button
802
    SetDisplay( 'IMGUNDO' + rowId, 'none');
1565
    SetDisplay( 'IMGUNDO' + rowId, 'none');
803
}
1566
}
804
 
1567
 
805
 
1568
 
806
function MergeAll()
-
 
807
{
-
 
808
    var elem
-
 
809
 
-
 
810
    if (document.all)
-
 
811
    {
-
 
812
        // Run this for IE
-
 
813
        elem = document.all;
-
 
814
    } else {
-
 
815
        // Run this for other browsers
-
 
816
        elem = document.getElementsByTagName('div');
-
 
817
    }
-
 
818
 
-
 
819
    for (i in elem)
-
 
820
    {
-
 
821
        if (elem[i].id)
-
 
822
        {
-
 
823
            if (elem[i].id.indexOf('SHORT_') == 0) elem[i].style.display = 'none';
-
 
824
            if (elem[i].id.indexOf('LONG_') == 0) elem[i].style.display = 'block';
-
 
825
        }
-
 
826
    }
-
 
827
}
-
 
828
 
-
 
829
//  An object to contain the filter data
1569
//  An object to contain the filter data
830
var filter;
1570
var filter;
831
 
1571
 
832
// Flip the current state of each Filter check boxes
1572
// Flip the current state of each Filter check boxes
833
function initFilter() {
1573
function initFilter() {
Line 926... Line 1666...
926
{
1666
{
927
    filter.Title.checked = false;
1667
    filter.Title.checked = false;
928
    filter.Title.title = "Toggle filters: Flip, On, Off, Restore, Reset - " + filter.State;
1668
    filter.Title.title = "Toggle filters: Flip, On, Off, Restore, Reset - " + filter.State;
929
}
1669
}
930
 
1670
 
-
 
1671
function processAll(tagClass)
-
 
1672
{
-
 
1673
    var elist = document.getElementsByClassName(tagClass);
-
 
1674
    for (let item of elist) {
-
 
1675
        item.onclick.apply(item);
-
 
1676
    }
-
 
1677
}
-
 
1678
 
931
//-->
1679
//-->
932
</script>
1680
</script>
933
<style>
1681
<style>
934
#filterTable td { background-color:#E4E9EC }
1682
#filterTable td { background-color:#E4E9EC }
935
}
-
 
-
 
1683
.BulkButton {width: 100%;text-align: left; margin:1px;}
936
</style>
1684
</style>
937
</head>
1685
</head>
938
<!-- HEADER -->
1686
<!-- HEADER -->
939
<!--#include file="_header.asp"-->
1687
<!--#include file="_header.asp"-->
940
<form name="FormName" method="post" action="<%=ScriptName%>">
1688
<form name="FormName" method="post" action="<%=ScriptName%>">
941
    <!-- BODY ---->
1689
    <!-- BODY ---->
942
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
1690
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
943
        <tr>
1691
        <tr>
944
            <td width="20%">
-
 
945
            <td width="60%">
-
 
946
            <td width="20%">
-
 
947
        </tr>
-
 
948
        <tr>
-
 
949
            <td class='bg_panel'>
-
 
950
                <!-- SELECT RELEASE A ---------------------------------------------->
-
 
951
                <br>
-
 
952
                <table width="100%"  border="0" cellspacing="10" cellpadding="0">
-
 
953
                    <tr>
-
 
954
                        <td align="left" class="body_col"><img src="images/i_rtag_open_mode.gif" border="0" align="absmiddle" width="15" height="13">&nbsp;Select Release A<hr size="1px" color="Olive" noshade></td>
-
 
955
                    </tr>
-
 
956
                    <tr>
-
 
957
                        <td align="left">
-
 
958
                            <select name="projA" class="form_item" onChange="RequestReleaseCombo( '?proj_id='+ this.value, FormName.rtagA );">
-
 
959
                                <option value="">-- Select Project --</option>
-
 
960
                                <%
-
 
961
                                OraDatabase.Parameters.Add "PROJ_ID",     objRelCollectorA.Item("proj_id"),    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
962
 
-
 
963
                                Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ProjectsCombo.sql"), cint(0))
-
 
964
 
-
 
965
                                OraDatabase.Parameters.Remove "PROJ_ID"
-
 
966
 
-
 
967
                                While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-
 
968
                                    <option value="<%=rsQry("proj_id")%>" <%=rsQry("selected")%>><%=rsQry("proj_name")%></option>
-
 
969
                                    <%rsQry.MoveNext
-
 
970
                                WEnd
-
 
971
 
-
 
972
                                rsQry.Close
-
 
973
                                Set rsQry = Nothing
-
 
974
                                %>
-
 
975
                            </select>
-
 
976
                        </td>
-
 
977
                    </tr>
-
 
978
                    <tr>
-
 
979
                        <td align="left">
-
 
980
                            <select name="rtagA" id="rtagA" class="form_item">
-
 
981
                                <%
-
 
982
                                OraDatabase.Parameters.Add "PROJ_ID",     objRelCollectorA.Item("proj_id"),    ORAPARM_INPUT,  ORATYPE_NUMBER
-
 
983
                                OraDatabase.Parameters.Add "RTAG_ID",     objRelCollectorA.Item("rtag_id"),    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
984
 
-
 
985
                                Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleasesCombo.sql"), cint(0))
-
 
986
 
-
 
987
                                OraDatabase.Parameters.Remove "PROJ_ID"
-
 
988
                                OraDatabase.Parameters.Remove "RTAG_ID"
-
 
989
 
-
 
990
                                While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-
 
991
                                        <option value="<%=rsQry("rtag_id")%>" <%=rsQry("selected")%>><%=rsQry("rtag_name")%></option>
-
 
992
                                    <%rsQry.MoveNext
-
 
993
                                WEnd
-
 
994
 
-
 
995
                                rsQry.Close
-
 
996
                                Set rsQry = Nothing
-
 
997
                                %>
-
 
998
                            </select>
-
 
999
                        </td>
-
 
1000
                    </tr>
-
 
1001
                    <%If (parRtagA <> "") Then%>
-
 
1002
                        <tr>
-
 
1003
                            <td align="left"><a href="dependencies.asp?rtag_id=<%=parRtagA%>" class="body_txt_drk">Go To Release A &raquo;</a></td>
-
 
1004
                        </tr>
-
 
1005
                    <%End If%>
-
 
1006
                                            <tr class="body_txt">
-
 
1007
                                                <td>
-
 
1008
                                                    <%If (parRtagA <> "") AND (parRtagB <> "")Then%>
-
 
1009
                                                        <!-- DIFF FILTER +++++++++++++++++++++++++++++++++++++++++++ -->
-
 
1010
                                                        <p>&nbsp;
-
 
1011
                                                        <fieldset style="width:200px;" onclick="filterClicked(event);">
-
 
1012
                                                            <legend class="body_txt"><%=GetIsDiffFilterInUseIcon() %>&nbsp;Filter&nbsp;Results...</legend>
-
 
1013
                                                            <table width="100%"  border="0" cellspacing="2" cellpadding="0" id=filterTable class="body_txt">
-
 
1014
                                                                <tr >
-
 
1015
                                                                    <td><input id="filterFipper" name="difilter" type="checkbox" onclick="toggleFilters();"></td>
-
 
1016
                                                                    <td colspan=1>Hide the marked change types.</td>
-
 
1017
                                                                </tr>
-
 
1018
                                                                <tr>
-
 
1019
                                                                    <td width="1"><input name="difilter" type="checkbox" value="<%=enumDB_NUM_DIFF_UPDATED%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_UPDATED)%>></td>
-
 
1020
                                                                    <td width="50" nowrap class="form_field"><%=LIMG_UPDATED%>Updated</td>
-
 
1021
                                                                </tr>
-
 
1022
                                                                <tr>
-
 
1023
                                                                    <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_WARN%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_WARN)%>></td>
-
 
1024
                                                                    <td nowrap class="form_field"><%=LIMG_OUTDATED%>Updated with Warning</td>
-
 
1025
                                                                </tr>
-
 
1026
                                                                <tr>
-
 
1027
                                                                    <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_NEW%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_NEW)%>></td>
-
 
1028
                                                                    <td nowrap class="form_field"><%=LIMG_ADDED%>Added</td>
-
 
1029
                                                                </tr>
-
 
1030
                                                                <tr>
-
 
1031
                                                                    <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_REMOVED%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_REMOVED)%>></td>
-
 
1032
                                                                    <td nowrap class="form_field"><%=LIMG_REMOVED%>Removed</td>
-
 
1033
                                                                </tr>
-
 
1034
                                                                <tr>
-
 
1035
                                                                    <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_RIPPLE%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_RIPPLE)%>></td>
-
 
1036
                                                                    <td nowrap class="form_field"><%=LIMG_RIPPLED%>Rippled</td>
-
 
1037
                                                                </tr>
-
 
1038
                                                                <tr>
-
 
1039
                                                                    <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_NO_CHANGE%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_NO_CHANGE)%>></td>
-
 
1040
                                                                    <td nowrap class="form_field"><%=LIMG_UNCHANGED%>Unchanged</td>
-
 
1041
                                                                </tr>
-
 
1042
                                                                <tr>
-
 
1043
                                                                    <td><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_PENDING%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_PENDING)%>></td>
-
 
1044
                                                                    <td nowrap class="form_field"><%=LIMG_PENDING%>Pending</td>
-
 
1045
                                                                </tr>
-
 
1046
                                                                <tr>
-
 
1047
                                                                    <td>&nbsp;</td>
-
 
1048
                                                                    <td width="100%">
-
 
1049
                                                                        <input id=difilterBtn name="btn" type="submit" class="form_btn" value="Refresh" disabled="true">
-
 
1050
                                                                    </td>
-
 
1051
                                                                </tr>
-
 
1052
                                                            </table>
-
 
1053
                                                            <img src onerror='initFilter();'>
-
 
1054
                                                        </fieldset>
-
 
1055
                                                        <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
-
 
1056
                                                    <%End If%>
-
 
1057
                                                </td>
-
 
1058
                                                <td></td>
-
 
1059
                                            </tr>
-
 
1060
 
-
 
1061
                </table>
-
 
1062
 
-
 
1063
                <!-- SELECT RELEASE A END ---------------------------------------------->
-
 
1064
            </td>
-
 
1065
 
-
 
1066
            <td rowspan="2" valign="top" background="images/bg_lght_gray.gif" align="center">
-
 
1067
                <!-- DIFF -------------------------------------------------------->
-
 
1068
                <br>
-
 
1069
                <table width="100%" border="0" cellspacing="10" cellpadding="0">
-
 
1070
                    <tr>
-
 
1071
                        <td>
-
 
1072
                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
-
 
1073
                                <tr>
-
 
1074
                                    <td width="1%"></td>
-
 
1075
                                    <td width="100%" align="left" class="form_ttl">DIFF / MERGE RELEASE
-
 
1076
                                        <%If genReport Then%>
-
 
1077
                                        &nbsp;[Generating Report]
-
 
1078
                                        <%End If%>
-
 
1079
                                        </td>
-
 
1080
                                    <td width="1%"></td>
-
 
1081
                                </tr>
-
 
1082
                                <tr>
-
 
1083
                                    <td align="left" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tl_cnr_b.gif" width="13" height="13"></td>
-
 
1084
                                    <td background="images/lbox_bg_blue.gif" align="left" class="wform_ttl">&nbsp;</td>
-
 
1085
                                    <td align="right" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tr_cnr_b.gif" width="13" height="13"></td>
-
 
1086
                                </tr>
-
 
1087
                                <tr>
-
 
1088
                                    <td width="1%" bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>
-
 
1089
                                    <td bgcolor="#FFFFFF" valign="top" class="form_item">
-
 
1090
                                        <table width="100%"  border="0" cellspacing="0" cellpadding="5">
-
 
1091
                                            <tr>
-
 
1092
                                                <td width="100%" bgcolor="#DAD7C8">
-
 
1093
                                                    <input type="submit" name="btn" value="Compare" class="form_btn_comp" style="margin-right:5px;">
-
 
1094
                                                    <input type="submit" name="btn" value="Swap Compare" class="form_btn_comp">
-
 
1095
                                                    <span class="body_txt">
-
 
1096
                                                        <input name="btn" type="submit" class="form_btn" value="Mail Me Report">
-
 
1097
                                                        <%'<input name="btn" type="submit" class="form_btn" value="Show Me Report">%>
-
 
1098
                                                    </span>
-
 
1099
                                                </td>
-
 
1100
                                                <td width="1" align="right" bgcolor="#DAD7C8" nowrap>
-
 
1101
                                                    <table width="100%"  border="0" cellspacing="0" cellpadding="0">
-
 
1102
                                                        <tr>
-
 
1103
                                                            <%
-
 
1104
                                                                Dim mergeMessage, mergeDisabled
-
 
1105
                                                                mergeDisabled = " disabled"
-
 
1106
                                                                If (parRtagA = "") Then
-
 
1107
                                                                    mergeMessage = "Select Release A"
-
 
1108
                                                                ElseIf (parRtagB = "") Then
-
 
1109
                                                                    mergeMessage = "Select Release B"
-
 
1110
                                                                ElseIf NOT isMergable Then
-
 
1111
                                                                    mergeMessage = "Release B cannot be modified"
-
 
1112
                                                                Else
-
 
1113
                                                                    mergeDisabled = ""
-
 
1114
                                                                End If
-
 
1115
                                                            %>
-
 
1116
                                                            <td class="err_alert nowrap" style="padding-right:1em">
-
 
1117
                                                                <%=mergeMessage%>
-
 
1118
                                                            </td>
-
 
1119
                                                            <td>
-
 
1120
                                                                <input type="submit" name="btn" value="Merge" class="form_btn_comp" style="margin-right:10px;" <%=mergeDisabled%>>
-
 
1121
                                                            </td>
-
 
1122
                                                            <td>
-
 
1123
                                                                <input type="submit" name="btn" value="Exit" class="form_btn_comp">
-
 
1124
                                                            </td>
-
 
1125
                                                        </tr>
-
 
1126
                                                    </table>
-
 
1127
                                                </td>
-
 
1128
                                            </tr>
-
 
1129
                                        </table>
-
 
1130
 
-
 
1131
                                        <%
-
 
1132
                                        ' Successfull Merge
-
 
1133
                                        If (Request("btn") = "Merge") Then
-
 
1134
                                            Call Messenger ( "Merge has completed successfully.", 3, "100%" )
-
 
1135
                                        End If
-
 
1136
 
-
 
1137
                                        If genReport Then
-
 
1138
                                            Set FSO=Server.CreateObject("Scripting.FileSystemObject")
-
 
1139
                                            Set NewTextFile=FSO.CreateTextFile(reportPath, true)
-
 
1140
 
-
 
1141
                                            Call Header()
-
 
1142
                                        End If
-
 
1143
 
-
 
1144
                                        If (parRtagA <> "") AND (parRtagB <> "")Then%>
-
 
1145
                                            <table width="100%"  border="0" cellspacing="1" cellpadding="0">
-
 
1146
                                                <tr>
-
 
1147
                                                    <td width="50%" bgcolor="#E4E9EC" class="body_row" nowrap><%= ReleaseIcon(objRelCollectorA.Item("official")) & objRelCollectorA.Item("location")%> </td>
-
 
1148
                                                    <td width="1" bgcolor="#E4E9EC"><img src="images/spacer.gif" width="20" height="1"></td>
-
 
1149
                                                    <td width="1" bgcolor="#E4E9EC"><img src="images/spacer.gif" width="20" height="20"></td>
-
 
1150
                                                    <td width="1" bgcolor="#E4E9EC"><img src="images/spacer.gif" width="20" height="1"></td>
-
 
1151
                                                    <td width="50%" bgcolor="#E4E9EC" class="body_row" nowrap><%= ReleaseIcon(objRelCollectorB.Item("official")) & objRelCollectorB.Item("location")%></td>
-
 
1152
                                                    <td width="1" bgcolor="#E4E9EC"><img src="images/spacer.gif" width="20" height="1"></td>
-
 
1153
                                                </tr>
-
 
1154
                                                <%
-
 
1155
                                                OraDatabase.Parameters.Add "RTAG_A",     parRtagA,    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
1156
                                                OraDatabase.Parameters.Add "RTAG_B",     parRtagB,    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
1157
                                                OraDatabase.Parameters.Add "NO_CHANGE",  GetIsDiffFilterChecked(enumDB_NUM_DIFF_NO_CHANGE), ORAPARM_INPUT, ORATYPE_VARCHAR2
-
 
1158
                                                OraDatabase.Parameters.Add "ADDED",      GetIsDiffFilterChecked(enumDB_NUM_DIFF_NEW),       ORAPARM_INPUT, ORATYPE_VARCHAR2
-
 
1159
                                                OraDatabase.Parameters.Add "UPDATED",    NULL,                                              ORAPARM_INPUT, ORATYPE_VARCHAR2
-
 
1160
                                                OraDatabase.Parameters.Add "REMOVED",    GetIsDiffFilterChecked(enumDB_NUM_DIFF_REMOVED),   ORAPARM_INPUT, ORATYPE_VARCHAR2
-
 
1161
 
-
 
1162
                                                Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleaseDiff.sql"), cint(0))
-
 
1163
 
-
 
1164
                                                OraDatabase.Parameters.Remove "RTAG_A"
-
 
1165
                                                OraDatabase.Parameters.Remove "RTAG_B"
-
 
1166
                                                OraDatabase.Parameters.Remove "NO_CHANGE"
-
 
1167
                                                OraDatabase.Parameters.Remove "ADDED"
-
 
1168
                                                OraDatabase.Parameters.Remove "UPDATED"
-
 
1169
                                                OraDatabase.Parameters.Remove "REMOVED"
-
 
1170
 
-
 
1171
                                                Set rsQryA = OraDatabase.DbCreateDynaset( "SELECT RT.RTAG_NAME, PRJ.PROJ_NAME FROM RELEASE_TAGS RT, PROJECTS PRJ WHERE RTAG_ID="& parRtagA &" AND RT.PROJ_ID=PRJ.PROJ_ID", cint(0))
-
 
1172
                                                Set rsQryB = OraDatabase.DbCreateDynaset( "SELECT RT.RTAG_NAME, PRJ.PROJ_NAME FROM RELEASE_TAGS RT, PROJECTS PRJ WHERE RTAG_ID="& parRtagB &" AND RT.PROJ_ID=PRJ.PROJ_ID", cint(0))
-
 
1173
 
-
 
1174
                                                If genReport Then
-
 
1175
                                                    Call Javascript()
-
 
1176
                                                    Call Styles()
-
 
1177
 
-
 
1178
                                                    NewTextFile.WriteLine("<title>Difference Report Between "&rsQryA("proj_name")&" "&rsQryA("rtag_name")&" and "&rsQryB("proj_name")&" "&rsQryB("rtag_name")&"</title>")
-
 
1179
                                                    NewTextFile.WriteLine("<div class=""page_title"">Difference Report Between "&rsQryA("proj_name")&" "&rsQryA("rtag_name")&" and "&rsQryB("proj_name")&" "&rsQryB("rtag_name")&"</div><br>")
-
 
1180
                                                    NewTextFile.WriteLine("<b>Key:</b><br><blockquote>")
-
 
1181
                                                    NewTextFile.WriteLine("<span class=changesa><b>SOURCE CODE CHANGES</b></span><span class=texta> Indicates Changes to a Package in "& rsQryA("rtag_name") &".</span><br>")
-
 
1182
                                                    NewTextFile.WriteLine("<span class=changesb><b>SOURCE CODE CHANGES</b></span><span class=textb> Indicates Changes to a Package in "& rsQryB("rtag_name") &".</span><br>")
-
 
1183
                                                    NewTextFile.WriteLine("<span class=changesnone><b>Grey Text</b></span><span class=textnone> No Source Code Changes to a Package in either Release.</span>")
-
 
1184
                                                    NewTextFile.WriteLine("</blockquote>")
-
 
1185
 
-
 
1186
                                                    NewTextFile.WriteLine("<b>Toggle Sections:</b><blockquote>")
-
 
1187
                                                    NewTextFile.WriteLine("<span class=pointer onClick=""MM_toggleAll('divPkgInfo','1');"">Expand All</span>")
-
 
1188
                                                    NewTextFile.WriteLine("<span class=pointer onClick=""MM_toggleAll('divPkgInfo','');"">Collapse All</span>")
-
 
1189
                                                    NewTextFile.WriteLine("</blockquote>")
-
 
1190
                                                End If
-
 
1191
 
-
 
1192
                                                Dim currView_id
-
 
1193
                                                currView_id = -1
-
 
1194
 
-
 
1195
                                                While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
-
 
1196
                                                    errormsg = false
-
 
1197
                                                    rowId = rsQry("pv_id_a") &"_"& rsQry("pv_id_b")
-
 
1198
 
-
 
1199
                                                    btnMerge = LIMG_MERGE
-
 
1200
                                                    btnRemove = LIMG_REMOVE
-
 
1201
 
-
 
1202
                                                    changeType = rsQry("change_type")
-
 
1203
                                                    isaSdk = rsQry("PKG_SDK_B")
-
 
1204
 
-
 
1205
                                                    If changeType = "U" OR changeType = "UW" OR changeType = "UR" Then
-
 
1206
                                                        Dim MajorA, MajorB, MinorA, MinorB, PatchA, PatchB, BuildA, BuildB, pos, pkgVersionA, pkgVersionB, majMinA, majMinB
-
 
1207
                                                        MajorA = NULL
-
 
1208
                                                        MajorB = NULL
-
 
1209
                                                        MinorA = NULL
-
 
1210
                                                        MinorB = NULL
-
 
1211
 
-
 
1212
                                                        pkgVersionA = rsQry("pkg_version_a")
-
 
1213
                                                        pkgVersionB = rsQry("pkg_version_b")
-
 
1214
 
-
 
1215
                                                        PatchA = rsQry("patch_number_a")
-
 
1216
                                                        PatchB = rsQry("patch_number_b")
-
 
1217
                                                        BuildA = rsQry("build_number_a")
-
 
1218
                                                        BuildB = rsQry("build_number_b")
-
 
1219
 
-
 
1220
 
-
 
1221
                                                        ' Find the first occurence of the dot in package version A
-
 
1222
                                                        pos = InStr(pkgVersionA, ".")
-
 
1223
                                                        If pos <> 0 Then
-
 
1224
                                                            ' Extract the Major Version for A
-
 
1225
                                                            MajorA = Mid(pkgVersionA, 1, pos - 1)
-
 
1226
                                                            ' Delete the Major Version Value from the string to get the minor and patch version
-
 
1227
                                                            pkgVersionA = Mid(pkgVersionA, pos + 1, Len(pkgVersionA))
-
 
1228
                                                            ' Find the second occurence of the dot in package version A
-
 
1229
                                                            pos = InStr(pkgVersionA, ".")
-
 
1230
                                                            ' Extract the Minor Version for A
-
 
1231
                                                            If pos <> 0 Then
-
 
1232
                                                                MinorA = Mid(pkgVersionA, 1, pos - 1)
-
 
1233
                                                            End If
-
 
1234
                                                        End If
-
 
1235
 
-
 
1236
                                                        ' Find the first occurence of the dot in package version B
-
 
1237
                                                        pos = InStr(pkgVersionB, ".")
-
 
1238
                                                        If pos <> 0 Then
-
 
1239
                                                            ' Extract the Major Version for B
-
 
1240
                                                            MajorB = Mid(pkgVersionB, 1, pos - 1)
-
 
1241
                                                            ' Delete the Major Version Value from the string to get the minor and patch version
-
 
1242
                                                            pkgVersionB = Mid(pkgVersionB, pos + 1, Len(pkgVersionB))
-
 
1243
                                                            ' Find the second occurence of the dot in package version B
-
 
1244
                                                            pos = InStr(pkgVersionB, ".")
-
 
1245
                                                            ' Extract the Minor Version for B
-
 
1246
                                                            If pos <> 0 Then
-
 
1247
                                                                MinorB = Mid(pkgVersionB, 1, pos - 1)
-
 
1248
                                                            End If
-
 
1249
                                                        End If
-
 
1250
 
-
 
1251
                                                        If MajorA = MajorB Then
-
 
1252
                                                            If MinorA = MinorB Then
-
 
1253
                                                                If IsNumeric(PatchA) AND IsNumeric(PatchB) Then
-
 
1254
                                                                    If CInt(PatchB) > CInt(PatchA) Then
-
 
1255
                                                                        btnMerge = LIMG_MERGE_WARN
-
 
1256
                                                                    Else
-
 
1257
                                                                        btnMerge = LIMG_MERGE
-
 
1258
                                                                    End If
-
 
1259
                                                                End If
-
 
1260
                                                            Else
-
 
1261
                                                                If IsNumeric(MinorA) AND IsNumeric(MinorB) Then
-
 
1262
                                                                    If CInt(MinorB) > CInt(MinorA) Then
-
 
1263
                                                                        btnMerge = LIMG_MERGE_WARN
-
 
1264
                                                                    Else
-
 
1265
                                                                        btnMerge = LIMG_MERGE
-
 
1266
                                                                    End If
-
 
1267
                                                                End If
-
 
1268
                                                            End If
-
 
1269
                                                        Else
-
 
1270
                                                            If IsNumeric(MajorA) AND IsNumeric(MajorB) Then
-
 
1271
                                                                If     CInt(MajorB) > CInt(MajorA) Then
-
 
1272
                                                                    btnMerge = LIMG_MERGE_WARN
-
 
1273
                                                                Else
-
 
1274
                                                                    btnMerge = LIMG_MERGE
-
 
1275
                                                                End If
-
 
1276
                                                            End If
-
 
1277
                                                        End If
-
 
1278
 
-
 
1279
                                                        If btnMerge = LIMG_MERGE_WARN Then
-
 
1280
                                                            changeType = "UW"
-
 
1281
                                                        End If
-
 
1282
                                                    End If
-
 
1283
 
-
 
1284
                                                    ' -------- END GROUP ------------------------
-
 
1285
                                                    %>
-
 
1286
                                                    <%
-
 
1287
                                                    'Determine if we are dealing with a PV_ID that we have already encountered and displayed as a pending addition
-
 
1288
                                                    'If we are, we do not need to display anything more about it, so skip the row.
-
 
1289
                                                    ' NOTE. the result set is sorted by change type (see releasediff.sql) such that if there are multiple entries
-
 
1290
                                                    '         for the same PV_ID, they are sorted in the following order: pending, unchanged, additions, removals, updates.
-
 
1291
                                                    '         This is important to the row skip filtering carried out below.
-
 
1292
                                                    Dim skipRow
-
 
1293
                                                    If rsQry("pv_id_a") Then
-
 
1294
                                                        skipRow = pkgSeen.Exists(CStr(rsQry("pv_id_a")))
-
 
1295
                                                        pkgSeen.Item(CStr(rsQry("pv_id_a"))) = 1
-
 
1296
                                                    Else
-
 
1297
                                                        skipRow = FALSE
-
 
1298
                                                    End If
-
 
1299
 
-
 
1300
                                                    If GetIsDiffFilterChecked(enumDB_NUM_DIFF_PENDING) <> "" Then
-
 
1301
                                                        If changeType = "APS" OR changeType = "APA" Then
-
 
1302
                                                            skipRow = TRUE
-
 
1303
                                                        End If
-
 
1304
                                                    End If
-
 
1305
 
-
 
1306
                                                    If GetIsDiffFilterChecked(enumDB_NUM_DIFF_UPDATED) <> "" Then
-
 
1307
                                                        If changeType = "U" Then
-
 
1308
                                                            skipRow = TRUE
-
 
1309
                                                        End If
-
 
1310
                                                    End If
-
 
1311
 
-
 
1312
                                                    If GetIsDiffFilterChecked(enumDB_NUM_DIFF_WARN) <> "" Then
-
 
1313
                                                        If changeType = "UW" Then
-
 
1314
                                                            skipRow = TRUE
-
 
1315
                                                        End If
-
 
1316
                                                    End If
-
 
1317
 
-
 
1318
                                                    If GetIsDiffFilterChecked(enumDB_NUM_DIFF_RIPPLE) <> "" Then
-
 
1319
                                                        If changeType = "UR" Then
-
 
1320
                                                            skipRow = TRUE
-
 
1321
                                                        End If
-
 
1322
                                                    End If
-
 
1323
 
-
 
1324
                                                    If NOT skipRow Then
-
 
1325
                                                        Call GetDiffStateIcon ( changeType, ChangeTypeIcon )
-
 
1326
 
-
 
1327
                                                    colorA = LCOLOR_NOT_CHANGED
-
 
1328
                                                    colorB = LCOLOR_NOT_CHANGED
-
 
1329
                                                    Select Case changeType
-
 
1330
                                                        Case "U"
-
 
1331
                                                            colorA = LCOLOR_CHANGED
-
 
1332
                                                            colorB = LCOLOR_CHANGED
-
 
1333
                                                        Case "UW"
-
 
1334
                                                            colorA = LCOLOR_OUTDATED
-
 
1335
                                                            colorB = LCOLOR_OUTDATED
-
 
1336
                                                            btnMerge = LIMG_MERGE_WARN
-
 
1337
                                                        Case "UR"
-
 
1338
                                                            colorA = LCOLOR_RIPPLED
-
 
1339
                                                            colorB = LCOLOR_RIPPLED
-
 
1340
                                                        Case "A"
-
 
1341
                                                            colorA = LCOLOR_BLANK
-
 
1342
                                                        Case "R"
-
 
1343
                                                            colorB = LCOLOR_BLANK
-
 
1344
                                                    End Select
-
 
1345
 
-
 
1346
 
-
 
1347
                                                    ' -------- GROUP BY BASE VIEW  -----------------
-
 
1348
                                                    If CDbl(currView_id) <> CDbl(rsQry("view_id")) Then
-
 
1349
                                                    %>
-
 
1350
                                                        <tr>
-
 
1351
                                                            <td valign="top" nowrap class="form_ttl"><b><%=rsQry("view_name")%></b></td>
-
 
1352
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1353
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1354
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1355
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1356
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1357
                                                        </tr>
-
 
1358
                                                    <%
-
 
1359
                                                        currView_id = CDbl(rsQry("view_id"))
-
 
1360
                                                    End If
-
 
1361
                                                    %>
-
 
1362
                                                        <tr>
-
 
1363
                                                            <td class="body_row" nowrap>
-
 
1364
                                                                <DIV id="PVA<%=rowId%>" style="background:<%=colorA%>; padding:5px;" data_color="<%=colorA%>">
-
 
1365
                                                                    <%=rsQry("pkg_name_a") &" "& rsQry("pkg_version_a")%>
-
 
1366
                                                                </DIV>
-
 
1367
                                                            </td>
-
 
1368
 
-
 
1369
                                                            <%
-
 
1370
                                                            Dim pkgADisplayControl
-
 
1371
                                                            pkgADisplayControl = isMergable
-
 
1372
                                                            If IsNull( changeType ) OR (changeType = "A")  OR (changeType = "B") OR (changeType = "APA")  OR (changeType = "APS")  Then pkgADisplayControl = FALSE
-
 
1373
                                                            If isaSdk Then pkgADisplayControl = FALSE
-
 
1374
                                                            %>
-
 
1375
                                                            <td bgcolor="#F5F5F5">
-
 
1376
                                                                <%If pkgADisplayControl Then%>
-
 
1377
                                                                    <DIV id="IMGMERGE<%=rowId%>" class=pointer onClick="MergePackage( '<%=rsQry("pv_id_a")%>', '<%=rsQry("pv_id_b")%>', '<%=rowId%>' );"><%=btnMerge%></DIV>
-
 
1378
                                                                <%End If%>
-
 
1379
                                                            </td>
-
 
1380
 
-
 
1381
                                                            <td bgcolor="#E4E9EC">
-
 
1382
                                                                <DIV id="IMGSTATE<%=rowId%>" DATA_CT="<%=changeType%>"><%=ChangeTypeIcon%></DIV>
-
 
1383
                                                            </td>
-
 
1384
 
-
 
1385
                                                            <%
-
 
1386
                                                            Dim pkgBDisplayControl
-
 
1387
                                                            pkgBDisplayControl = isMergable
-
 
1388
                                                            If changeType = "R" Then pkgBDisplayControl = FALSE
-
 
1389
                                                            If isaSdk Then pkgBDisplayControl = FALSE
-
 
1390
                                                            %>
-
 
1391
                                                            <td bgcolor="#F5F5F5">
-
 
1392
                                                                <%If pkgBDisplayControl Then%>
-
 
1393
                                                                    <DIV id="IMGREMOVE<%=rowId%>" class=pointer onClick="RemovePackage( '<%=rsQry("pv_id_a")%>', '<%=rsQry("pv_id_b")%>', '<%=rowId%>' );"><%=btnRemove%></DIV>
-
 
1394
                                                                <%ElseIf isaSdk Then %>
-
 
1395
                                                                    <DIV ><%=LIMG_SDK%></DIV>
-
 
1396
                                                                <%End If%>
-
 
1397
                                                            </td>
-
 
1398
 
-
 
1399
                                                            <td class="body_row" nowrap>
-
 
1400
                                                                <DIV id="PVB<%=rowId%>"
-
 
1401
                                                                     style="background:<%=colorB%>; padding:5px;"
-
 
1402
                                                                     data_color="<%=colorB%>"
-
 
1403
                                                                     data_pkg="<%=rsQry("pkg_name_b") &" "& rsQry("pkg_version_b")%>"
-
 
1404
                                                                     >
-
 
1405
                                                                    <%=rsQry("pkg_name_b") &" "& rsQry("pkg_version_b")%>
-
 
1406
                                                                    <%If ChangeType = "APS" Then%>
-
 
1407
                                                                            (removal pending<%=Quick_Help("RemovalPending")%>)
-
 
1408
                                                                    <%ElseIf ChangeType = "APA" Then%>
-
 
1409
                                                                            (addition pending<%=Quick_Help("AdditionPending")%>)
-
 
1410
                                                                    <%End If %>
-
 
1411
                                                                </DIV>
-
 
1412
                                                                <input type="hidden" disabled="disabled" name="addpkg" id="ADDPKG_<%=rowId%>" value="">
-
 
1413
                                                                <input type="hidden" disabled="disabled" name="removepkg" id="REMOVEPKG_<%=rowId%>" value="">
-
 
1414
                                                            </td>
-
 
1415
 
-
 
1416
                                                            <td bgcolor="#F5F5F5">
-
 
1417
                                                                <DIV id="IMGUNDO<%=rowId%>" style="display:none;" class=pointer onClick="UndoPackage( '<%=rowId%>' );"><%=LIMG_UNDO%></DIV>
-
 
1418
                                                            </td>
-
 
1419
                                                        </tr>
-
 
1420
                                                    <%End If %>
-
 
1421
 
-
 
1422
                                                    <%
-
 
1423
                                                    If genReport AND NOT skipRow  Then
-
 
1424
                                                        If rsQry("pv_id_a") Then
-
 
1425
                                                            Set rsQryCommentsA = OraDatabase.DbCreateDynaset( "SELECT COMMENTS FROM PACKAGE_VERSIONS WHERE PV_ID="& rsQry("pv_id_a"), cint(0))
-
 
1426
                                                        End If
-
 
1427
 
-
 
1428
                                                        If rsQry("pv_id_b") Then
-
 
1429
                                                            Set rsQryCommentsB = OraDatabase.DbCreateDynaset( "SELECT COMMENTS FROM PACKAGE_VERSIONS WHERE PV_ID="& rsQry("pv_id_b"), cint(0))
-
 
1430
                                                        End If
-
 
1431
 
-
 
1432
                                                        pkgA = rsQry("pkg_name_a")
-
 
1433
                                                        pkgB = rsQry("pkg_name_b")
-
 
1434
 
-
 
1435
                                                        If pkgA <> "" then
-
 
1436
                                                            pkgname = pkgA
-
 
1437
                                                        Else
-
 
1438
                                                            pkgname = pkgB
-
 
1439
                                                        End If
-
 
1440
 
-
 
1441
                                                        If changeType = "U" OR  changeType = "UW" Then
-
 
1442
                                                            ChangeASource = false
-
 
1443
                                                            ChangeAUpdate = false
-
 
1444
                                                            ChangeBSource = false
-
 
1445
                                                            ChangeBUpdate = false
-
 
1446
 
-
 
1447
                                                            If genReport Then
-
 
1448
                                                                'NewTextFile.WriteLine("<br><b><font face="&chr(34)&"arial"&chr(34)&">"&pkgname&"</font></b>")
-
 
1449
                                                                NewTextFile.Write("<span class=""body_scol pointer"" onClick=""toggleSPAN('"& rowId &"');"">"& pkgname &"</span>")
-
 
1450
                                                                NewTextFile.WriteLine("<DIV class=divPkgInfo id=""spanPkgInfo"& rowId &""" name=""spanPkgInfo"" style=""display:none;"">")
-
 
1451
                                                                NewTextFile.Write(rsQryA("rtag_name")&" uses: "&rsQry("pkg_version_a")&" (")
-
 
1452
                                                                Call Release(rsQry("pv_id_a"))
-
 
1453
                                                                NewTextFile.WriteLine(")<br>")
-
 
1454
                                                                NewTextFile.Write(rsQryB("rtag_name")&" uses: "&rsQry("pkg_version_b")&" (")
-
 
1455
                                                                Call Release(rsQry("pv_id_b"))
-
 
1456
                                                                NewTextFile.WriteLine(")<br>")
-
 
1457
 
-
 
1458
                                                                a = rsQry("pv_id_a")
-
 
1459
                                                                b = rsQry("pv_id_b")
-
 
1460
                                                                c = rsQry("pv_id_a")
-
 
1461
                                                                d = rsQry("pv_id_b")
-
 
1462
 
-
 
1463
                                                                Set pvCollectionA = CreateObject("Scripting.Dictionary")
-
 
1464
                                                                Set pvCollectionB = CreateObject("Scripting.Dictionary")
-
 
1465
                                                                On Error Resume Next
-
 
1466
                                                                While CLng(a) <> CLng(b) and NOT errormsg
-
 
1467
 
-
 
1468
                                                                    'NewTextFile.WriteLine("A: "&a)
-
 
1469
                                                                    'NewTextFile.WriteLine("B: "&b)
-
 
1470
                                                                    pvCollectionA.Add CStr(a), Empty
-
 
1471
                                                                    pvCollectionB.Add CStr(b), Empty
-
 
1472
                                                                    If CLng(a) > CLng(b) Then
-
 
1473
                                                                        'NewTextFile.WriteLine("TestA")
-
 
1474
                                                                        Call LastPvIdA(a)
-
 
1475
                                                                    ElseIf CLng(b) > CLng(a) Then
-
 
1476
                                                                        'NewTextFile.WriteLine("TestB")
-
 
1477
                                                                        Call LastPvIdB(b)
-
 
1478
                                                                    End If
-
 
1479
                                                                Wend
-
 
1480
 
-
 
1481
                                                                Set pvCollectionA = Nothing
-
 
1482
                                                                Set pvCollectionB = Nothing
-
 
1483
 
-
 
1484
                                                                Call pkg_Version(a)
-
 
1485
                                                                NewTextFile.Write("Common PARENT package version: "&pkgversion&" (")
-
 
1486
                                                                Call Release(a)
-
 
1487
                                                                NewTextFile.WriteLine(")<br><br>")
-
 
1488
                                                                NewTextFile.WriteLine()
-
 
1489
                                                                NewTextFile.WriteLine("<b>"&rsQryA("rtag_name")&"</b>")
-
 
1490
 
-
 
1491
                                                                If pkgversion <> rsQry("pkg_version_a") Then
-
 
1492
                                                                    NewTextFile.WriteLine("<blockquote><b><i>Versions between "& pkgversion &" and "& rsQry("pkg_version_a")&"</i></b></blockquote>")
-
 
1493
 
-
 
1494
                                                                    If errormsg Then
-
 
1495
                                                                        NewTextFile.WriteLine("Error determining root!<br>")
-
 
1496
                                                                        NewTextFile.WriteLine()
-
 
1497
                                                                    End If
-
 
1498
 
-
 
1499
                                                                    source_change = false
-
 
1500
 
-
 
1501
                                                                    While CLng(a) <> CLng(c) and NOT errormsg
-
 
1502
                                                                        Call Comments(c)
-
 
1503
                                                                        If scFlag = TRUE Then
-
 
1504
                                                                            Call GetFixedIssues(c)
-
 
1505
                                                                        End If
-
 
1506
                                                                        Call LastPvIdAa(c)
-
 
1507
                                                                        NewTextFile.WriteLine()
-
 
1508
                                                                    Wend
-
 
1509
 
-
 
1510
                                                                    If source_change = false Then
-
 
1511
                                                                        NewTextFile.WriteLine("<blockquote><b><i>No source changes to "& rsQryA("rtag_name")&". Only Rippled Builds.</i></b></blockquote><br>")
-
 
1512
                                                                        ChangeASource = true
-
 
1513
                                                                    End If
-
 
1514
 
-
 
1515
                                                                    Call pkg_Version(b)
-
 
1516
                                                                    NewTextFile.WriteLine()
-
 
1517
                                                                    NewTextFile.WriteLine()
-
 
1518
 
-
 
1519
                                                                ElseIf pkgversion = rsQry("pkg_version_a") Then
-
 
1520
                                                                    NewTextFile.WriteLine("<blockquote><b><i>No updates to "& rsQryA("rtag_name")&"</i></b></blockquote><br>")
-
 
1521
                                                                    ChangeAUpdate = true
-
 
1522
                                                                    NewTextFile.WriteLine()
-
 
1523
                                                                End If
-
 
1524
 
-
 
1525
                                                                NewTextFile.WriteLine("<b>"&rsQryB("rtag_name")&"</b>")
-
 
1526
 
-
 
1527
                                                                If pkgversion <> rsQry("pkg_version_b") Then
-
 
1528
                                                                    NewTextFile.WriteLine("<blockquote><b><i>Versions between "& pkgversion &" and "& rsQry("pkg_version_b")&"</i></b></blockquote>")
-
 
1529
 
-
 
1530
                                                                    If errormsg Then
-
 
1531
                                                                        NewTextFile.WriteLine("Error determining root!<br>")
-
 
1532
                                                                        NewTextFile.WriteLine()
-
 
1533
                                                                    End If
-
 
1534
 
-
 
1535
                                                                    source_change = false
-
 
1536
 
-
 
1537
                                                                    While CLng(b) <> CLng(d) and NOT errormsg
-
 
1538
                                                                        Call Comments(d)
-
 
1539
                                                                        If scFlag = TRUE Then
-
 
1540
                                                                            Call GetFixedIssues(d)
-
 
1541
                                                                        End If
-
 
1542
                                                                        Call LastPvIdBb(d)
-
 
1543
                                                                        NewTextFile.WriteLine()
-
 
1544
                                                                    Wend
-
 
1545
 
-
 
1546
                                                                    If source_change = false Then
-
 
1547
                                                                        NewTextFIle.WriteLine("<blockquote><b><i>No source changes to "& rsQryB("rtag_name")&". Only Rippled Builds.</i></b></blockquote><br>")
-
 
1548
                                                                        ChangeBSource = true
-
 
1549
                                                                    End If
-
 
1550
 
-
 
1551
                                                                ElseIf pkgversion = rsQry("pkg_version_b") Then
-
 
1552
                                                                    NewTextFile.WriteLine("<blockquote><b><i>No updates to "& rsQryB("rtag_name")&"</i></b></blockquote><br>")
-
 
1553
                                                                    ChangeBUpdate = true
-
 
1554
                                                                    NewTextFile.WriteLine()
-
 
1555
                                                                End If
-
 
1556
 
-
 
1557
                                                                NewTextFile.WriteLine("</DIV>")
-
 
1558
 
-
 
1559
                                                                If ChangeASource Then
-
 
1560
                                                                    If ChangeBSource Then
-
 
1561
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": .</b class=changesnone> Ripple Builds Only.</td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &": </b class=changesnone> Ripple Builds Only.</td>  </tr></table></blockquote>")
-
 
1562
                                                                    ElseIf ChangeBUpdate Then
-
 
1563
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": </b><span class=changesnone>Ripple Builds Only.</span></td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &": </b><span class=changesnone> No Updates.</span></td>  </tr></table></blockquote>")
1692
            <td width="20%" valign="top" class='bg_panel'><%Call PanelA%></td>
1564
                                                                    ElseIf NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1565
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0""><tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>Ripple Builds Only.</span></td>    <td width=""50%"">    <b>"& Ucase(rsQryB("rtag_name")) &":</b> <b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1566
                                                                    End If
-
 
1567
                                                                End If
-
 
1568
 
-
 
1569
                                                                If ChangeBSource Then
-
 
1570
                                                                    If NOT ChangeAUpdate Then
-
 
1571
                                                                        If NOT ChangeASource AND NOT ChangeBUpdate Then
-
 
1572
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": </b><b class=changesa> SOURCE CODE CHANGES</b>.</td>    <td width=""50%""> <b>"& Ucase(rsQryB("rtag_name")) &":</b> <span class=changesnone> Ripple Builds Only.</span></td>  </tr></table></blockquote>")
-
 
1573
                                                                        End If
-
 
1574
                                                                    End If
-
 
1575
                                                                End If
-
 
1576
 
-
 
1577
                                                                If NOT ChangeASource Then
-
 
1578
                                                                    If NOT ChangeAUpdate Then
-
 
1579
                                                                        If NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1580
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <b class=changesa> SOURCE CODE CHANGES.</b></td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &":</b><b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1581
                                                                        ElseIf ChangeBUpdate Then
-
 
1582
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <b class=changesa> SOURCE CODE CHANGES.</b></td> <td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &":</b><span class=changesnone> No Updates.</span></td>  </tr></table></blockquote>")
-
 
1583
                                                                        End If
-
 
1584
                                                                    ElseIf ChangeAUpdate Then
-
 
1585
                                                                        If NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1586
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>No Updates.</span></td> <td width=""50%"">  <b></font>"& Ucase(rsQryB("rtag_name")) &":</b><b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
1693
            <td width="60%" rowspan="2" valign="top" align="center" class='bg_grey'><%Call CenterPanel%></td>
1587
                                                                        ElseIf ChangeBSource Then
-
 
1588
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>No Updates.</span></td> <td width=""50%""> </font><b>"& Ucase(rsQryB("rtag_name")) &":</b> <span class=changesnone> Ripple Builds Only.</span></td>  </tr></table></blockquote>")
1694
            <td width="20%" valign="top" class='bg_panel'><%Call PanelB%></td>
1589
                                                                        End If
-
 
1590
                                                                    End If
-
 
1591
                                                                End If
-
 
1592
                                                            End If
-
 
1593
 
-
 
1594
                                                        End If  'changeType = "U" OR  changeType = "UW"
-
 
1595
 
-
 
1596
                                                    End If  'email
-
 
1597
 
-
 
1598
                                                    rsQry.MoveNext
-
 
1599
                                                WEnd
-
 
1600
 
-
 
1601
                                                rsQry.Close
-
 
1602
                                                Set rsQry = Nothing
-
 
1603
                                                %>
-
 
1604
                                                <%
-
 
1605
                                                If genReport Then
-
 
1606
                                                    Call Footer()
-
 
1607
                                                    NewTextFile.Close
-
 
1608
                                                    Set NewTextFile=Nothing
-
 
1609
                                                End If
-
 
1610
                                                %>
-
 
1611
                                            </table>
-
 
1612
                                            <br>
-
 
1613
                                        <%Else%>
-
 
1614
                                            <br>
-
 
1615
                                            <%
-
 
1616
                                            If (parRtagB <> "") Then
-
 
1617
                                                Call Messenger ( "Select <b>Release A</b> to compare.", 3, "100%" )
-
 
1618
                                            ElseIf (parRtagA <> "") Then
-
 
1619
                                                Call Messenger ( "Select <b>Release B</b> to compare.", 3, "100%" )
-
 
1620
                                            Else
-
 
1621
                                                Call Messenger ( "Select <b>Release A</b> and <b>Release B</b> to compare.", 3, "100%" )
-
 
1622
                                            End If
-
 
1623
                                            %>
-
 
1624
                                        <%End If%>
-
 
1625
                                    </td>
-
 
1626
                                    <td width="1%" background="images/lbox_bgside_white.gif">&nbsp;</td>
-
 
1627
                                </tr>
-
 
1628
                                <tr>
-
 
1629
                                    <td width="1%" background="images/lbox_bg_blue.gif" valign="bottom"><img src="images/lbox_bl_cnr_b.gif" width="13" height="13"></td>
-
 
1630
                                    <td background="images/lbox_bg_blue.gif"></td>
-
 
1631
                                    <td width="1%" background="images/lbox_bg_blue.gif" valign="bottom" align="right"><img src="images/lbox_br_cnr_b.gif" width="13" height="13"></td>
-
 
1632
                                </tr>
-
 
1633
                            </table>
-
 
1634
                        </td>
-
 
1635
                    </tr>
-
 
1636
                </table>
-
 
1637
                <!-- DIFF END ---------------------------------------------------->
-
 
1638
            </td>
-
 
1639
            <td class='bg_panel'>
-
 
1640
 
-
 
1641
                <!-- SELECT RELEASE B ---------------------------------------------->
-
 
1642
                <br>
-
 
1643
                <table width="100%"  border="0" cellspacing="10" cellpadding="0">
-
 
1644
                    <tr>
-
 
1645
                        <td align="left" class="body_col">
-
 
1646
                            <img src="images/i_rtag_open_mode.gif" border="0" align="absmiddle" width="15" height="13">&nbsp;Select Release B<hr size="1px" color="Olive" noshade>
-
 
1647
                        </td>
-
 
1648
                    </tr>
-
 
1649
                    <tr>
-
 
1650
                        <td align="left">
-
 
1651
                            <select name="projB" class="form_item" onChange="RequestReleaseCombo( '?proj_id='+ this.value, FormName.rtagB );">
-
 
1652
                                <option value="">-- Select Project --</option>
-
 
1653
                                <%
-
 
1654
                                OraDatabase.Parameters.Add "PROJ_ID",     objRelCollectorB.Item("proj_id"),    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
1655
 
-
 
1656
                                Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ProjectsCombo.sql"), cint(0))
-
 
1657
 
-
 
1658
                                OraDatabase.Parameters.Remove "PROJ_ID"
-
 
1659
 
-
 
1660
                                While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-
 
1661
                                    <option value="<%=rsQry("proj_id")%>" <%=rsQry("selected")%>><%=rsQry("proj_name")%></option>
-
 
1662
                                    <%rsQry.MoveNext
-
 
1663
                                WEnd
-
 
1664
 
-
 
1665
                                rsQry.Close
-
 
1666
                                Set rsQry = Nothing
-
 
1667
                                %>
-
 
1668
                            </select>
-
 
1669
                        </td>
-
 
1670
                    </tr>
-
 
1671
                    <tr>
-
 
1672
                        <td align="left">
-
 
1673
                            <select name="rtagB" id="rtagB" class="form_item">
-
 
1674
                                <%
-
 
1675
                                OraDatabase.Parameters.Add "PROJ_ID",     objRelCollectorB.Item("proj_id"),    ORAPARM_INPUT,  ORATYPE_NUMBER
-
 
1676
                                OraDatabase.Parameters.Add "RTAG_ID",     objRelCollectorB.Item("rtag_id"),    ORAPARM_INPUT, ORATYPE_NUMBER
-
 
1677
 
-
 
1678
                                Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleasesCombo.sql"), cint(0))
-
 
1679
 
-
 
1680
                                OraDatabase.Parameters.Remove "PROJ_ID"
-
 
1681
                                OraDatabase.Parameters.Remove "RTAG_ID"
-
 
1682
 
-
 
1683
                                While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-
 
1684
                                        <option value="<%=rsQry("rtag_id")%>" <%=rsQry("selected")%>><%=rsQry("rtag_name")%></option>
-
 
1685
                                    <%rsQry.MoveNext
-
 
1686
                                WEnd
-
 
1687
 
-
 
1688
                                rsQry.Close
-
 
1689
                                Set rsQry = Nothing
-
 
1690
                                %>
-
 
1691
                            </select>
-
 
1692
                        </td>
-
 
1693
                    </tr>
-
 
1694
                    <%If (parRtagB <> "") Then%>
-
 
1695
                        <tr>
-
 
1696
                            <td align="left"><a href="dependencies.asp?rtag_id=<%=parRtagB%>" class="body_txt_drk">Go To Release B &raquo;</a></td>
-
 
1697
                        </tr>
-
 
1698
                    <%End If%>
-
 
1699
                </table>
-
 
1700
                <!-- SELECT RELEASE B END ---------------------------------------------->
-
 
1701
            </td>
-
 
1702
        </tr>
1695
        </tr>
1703
        <tr>
1696
        <tr>
1704
            <td class='bg_panel_btm'>
1697
            <td class='bg_panel_btm'>
1705
                <img src="images/img_vtree.gif" width="86" height="99" vspace="20" hspace="30">
1698
                <img src="images/img_vtree.gif" width="86" height="99" vspace="20" hspace="30">
1706
            </td>
1699
            </td>