wiki:WikiStart
Last modified 13 years ago

食事処

Welcome to Trac 0.12

基本設計15/100
外部設計13/100
内部設計書 12/100
単体テスト 5件/100件
結合テスト 2件/40件
システムテスト 0.5/10件

SELECT
  bug_place as "障害発生箇所",
  CASE WHEN high_count IS NULL THEN 0 ELSE high_count END as "優先度高",
  CASE WHEN low_count IS NULL THEN 0 ELSE low_count END as "優先度低"
FROM  
(SELECT
  place.value as "bug_place",
  (SELECT count(*)
     FROM ticket t
     LEFT JOIN ticket_custom p 
     ON p.ticket = t.id AND p.name='bug_place'
     WHERE t.type=$TYPE 
       AND p.value = place.value 
       AND t.priority IN ('ブロッカー','クリティカル','高')  
     GROUP BY p.value) AS "high_count",
  (SELECT count(*) FROM ticket t
     LEFT JOIN ticket_custom p 
     ON p.ticket = t.id AND p.name='bug_place'
     WHERE t.type=$TYPE 
       AND p.value = place.value 
       AND t.priority IN ('普通','低') 
     GROUP BY p.value) AS "low_count"
FROM ticket t
LEFT JOIN ticket_custom place 
ON place.ticket = t.id AND place.name='bug_place'
WHERE t.type=$TYPE
GROUP BY place.value)

test 

<?xml version="1.0" encoding="Shift_JIS"?>
<xsl:stylesheet version="1.0"  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"   xmlns="http://www.w3.org/1999/xhtml">

<xsl:template match="/">
    <html>
        <head><title>xsl:include使用例　ユリ科の植物だけを表示</title></head>
        <style>
table{
    border-top:1px solid #ccc;
    border-left:1px solid #ccc;
    border-collapse:collapse;
    border-spacing:0;
    background-color:#ffffff;
    empty-cells:show;
}
th {
    border-right:1px solid #ccc;
    border-bottom:1px solid #ccc;
    color:#000000;
    background-color:#eee;
    background-image:url(../img/table-back.gif);
    background-position:left top;
    padding:0.3em 1em;
    text-align:center;
}

td {
    border-right:1px solid #aaa;
    border-bottom:1px solid #aaa;
    padding:0.3em 1em;
}

.evenrow {
  background-color: #888;
}

.file {
  color:red;
  background-color: transparent;
  background-image: url('./Akiko_pusu.png');
  cursor:auto;
  text-decoration: none;
  display:block;
  padding-left: 40px;
  background-position: 0% 50%;
  background-repeat: no-repeat;
}
.dir {
  color:red;
  background-image: url('./Akiko_pusu.png');
  text-decoration: none;
  padding-left: 40px;
  background-position: 0% 50%;
  background-repeat: no-repeat;
}
        </style>
        <body>
         <h1>Subverison Repository</h1>
         <hr />
        <table border="1">
          <tr>
            <th>name</th><th>Rev.</th><th>author</th><th>date</th><th>size</th>
          </tr>
         <xsl:apply-templates />
         </table>
         <hr />
         Powerd by TracLightning
    </body>
    </html>
</xsl:template>

<xsl:template match="entry">
    <tr>
<xsl:call-template name="conditionalRowStyle"/>
    <td>
	<xsl:element name="a">
		<xsl:attribute name="class"><li><xsl:value-of select="@kind" /></li></xsl:attribute>
		<xsl:attribute name="href"><xsl:value-of select="name" /></xsl:attribute>
		<xsl:value-of select="name" />
	</xsl:element>
    </td>
    <td><xsl:value-of select="commit/@revision"/></td>
    <td><xsl:value-of select="commit/author"/></td>
    <td><xsl:value-of select="commit/date" /></td>
    <td><xsl:if test="size"><xsl:value-of select="size div 1000"/>k</xsl:if></td>

    </tr>
</xsl:template>
<xsl:template match="list">
<xsl:param name="url" select="list/@path" />
         <xsl:apply-templates />
</xsl:template>

<xsl:template name="conditionalRowStyle">
    <xsl:attribute name="class">
        <xsl:choose>
            <xsl:when test="(count(preceding-sibling::tr) mod 2) = 0">oddrow</xsl:when>
            <xsl:otherwise>evenrow</xsl:otherwise>
        </xsl:choose>
    </xsl:attribute>
</xsl:template>
</xsl:stylesheet>

select 
  CASE tt.status WHEN 'closed' THEN 5 WHEN 'new' THEN 3 ELSE 1 END AS __color__,
   (CASE tt.status 
      WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
      ELSE 
        (CASE tt.owner WHEN $USER THEN 'font-weight: bold' END)
    END) AS __style__,
  m.name AS __group__,
  t.id as id,
  '' as 'プロダクトバックログ',
  tt.id as ticket,
  tt.summary as 'スプリントバックログ',
  tt.owner as '担当者', 
  tt.status as '状態', 
  CASE WHEN st.child IS NULL THEN peh.value ELSE eh.value END as '見積',
  CASE WHEN st.child IS NULL THEN pth.value ELSE th.value END as '作業時間',
  '' as description
from ticket t 
  LEFT JOIN subtickets st  ON st.parent =t.id AND t.type='ﾌﾟﾛﾀﾞｸﾄﾊﾞｯｸﾛｸﾞ'
  LEFT JOIN ticket tt ON tt.id=st.child
  LEFT JOIN milestone m ON t.milestone = m.name 
  LEFT JOIN ticket_custom eh ON eh.ticket = tt.id AND eh.name = 'estimatedhours'
  LEFT JOIN ticket_custom th ON th.ticket = tt.id AND th.name = 'totalhours'
  LEFT JOIN ticket_custom peh ON peh.ticket = t.id AND peh.name = 'estimatedhours'
  LEFT JOIN ticket_custom pth ON pth.ticket = t.id AND pth.name = 'totalhours'
WHERE t.type="ﾌﾟﾛﾀﾞｸﾄﾊﾞｯｸﾛｸﾞ"  AND st.child IS NOT NULL AND t.status <> 'closed'

UNION

SELECT
  2 AS __color__,
  'color: black; font-weight: bold;text-shadow: 3px 3px 3px #e88 ;'  AS __style__,
  t.milestone AS __group__,
  t.id AS id,
  t.summary AS 'プロダクトバックログ',
  '',
  '',
  '',
  '',
  '',
  '',
  '[/newticket?type=ｽﾌﾟﾘﾝﾄﾊﾞｯｸﾛｸﾞ&parents='||t.id||'&milestone='||t.milestone||' ｽﾌﾟﾘﾝﾄﾊﾞｯｸﾛｸﾞ作成]' AS  description
FROM ticket t
WHERE t.type='ﾌﾟﾛﾀﾞｸﾄﾊﾞｯｸﾛｸﾞ' AND t.status<>'closed'
ORDER BY __group__ DESC, id,ticket DESC


/* バックログ */

.tickets tbody td.ストーリー {
  white-space: normal;
}

.tickets tbody td.タスク {
  white-space: normal;
}

/* テーマカスタイマイズ */

#mainnav {
  background: #fff;
  border: none;
}
#mainnav ul li {
  color: white ;
  text-shadow: 1px 1px 3px black;
}

/* メニュー設定 */
#mainnav :link, 
#mainnav :visited,
#mainnav .active :link,
#mainnav .active :visited {
/* メニューのスタイル */
   font-size: 10pt;
   padding: 0.75em 1em 0.75em 1em; /* メニューの大きさ */
   margin: 0px 2px 0px 2px; /*メニューの間隔 */
   border: none;
/* コーナー */
   -moz-border-radius-topleft: 15px;
   -moz-border-radius-topright: 15px;
   border-top-right-radius: 15px;
   border-top-left-radius: 15px;
}

#mainnav ul li {
/* メニューを改行したときの幅 */
  display: inline-block;
  height:3.4em;
}


/* アクティブメニュー */
#mainnav ul li.active a:visited {
  color: white; /* アクティブメニュー文字色 */
  border-bottom: 1px solid white;
  background: white; /* アクティブメニュー背景 */
  border-right: 1px solid gray;
  border-left: 1px solid gray;
  border-top: 1px solid gray;

}

#mainnav span {
   padding: 0px 0px 0px 0px;
}

#mainnav .active :link:hover,
#mainnav :link:hover,
#mainnav :visited:hover,
#mainnav .active :visited:hover {
   border-right: 1px solid lightgray;
   border-left: 1px solid lightgray;
   border-top: 1px solid lightgray;
   border-bottom: none;
   background: #fea;
}


#mainnav ul li a:link, #mainnav ul li a:visited {
/* メニュー背景 */
  background: url('SampleProject_files/menu.png');
  background: -webkit-gradient(linear, left top, left bottom, from(#fea), to(#f92));
  background: -moz-linear-gradient(top,#fea,#f92);
  color: white ;
}

Tokenizer

スタートポイント

この Wiki ページの完全なリストは、 TitleIndex をご覧下さい。

Attachments