# config

name: header
value:
  <html>
  <head>
  <base href="$baseurl/$current_page" />
  <title>$<project_name>: $<title></title>
  <link rel="alternate" type="application/rss+xml" title="RSS Feed"
        href="$home/timeline.rss">
  <link rel="stylesheet" href="$home/style.css?black2" type="text/css"
        media="screen">
  </head>
  <body>
  <div class="header">
    <div class="logo">
      <img src="$home/logo" alt="logo">
      <br /><nobr>$<project_name></nobr>
    </div>
    <div class="title">$<title></div>
    <div class="status"><nobr><th1>
       if {[info exists login]} {
         puts "Logged in as $login"
       } else {
         puts "Not logged in"
       }
    </th1></nobr></div>
  </div>
  <div class="mainmenu">
  <th1>
  html "<a href='$home$index_page'>Home</a>\n"
  if {[anycap jor]} {
    html "<a href='$home/timeline'>Timeline</a>\n"
  }
  if {[hascap oh]} {
    html "<a href='$home/dir?ci=tip'>Files</a>\n"
  }
  if {[hascap o]} {
    html "<a href='$home/brlist'>Branches</a>\n"
    html "<a href='$home/taglist'>Tags</a>\n"
  }
  if {[hascap r]} {
    html "<a href='$home/reportlist'>Tickets</a>\n"
  }
  if {[hascap j]} {
    html "<a href='$home/wiki'>Wiki</a>\n"
  }
  if {[hascap s]} {
    html "<a href='$home/setup'>Admin</a>\n"
  } elseif {[hascap a]} {
    html "<a href='$home/setup_ulist'>Users</a>\n"
  }
  if {[info exists login]} {
    html "<a href='$home/login'>Logout</a>\n"
  } else {
    html "<a href='$home/login'>Login</a>\n"
  }
  </th1></div>
  <div id="container">


name: css
value:
  /* General settings for the entire page */
  html {
    min-height: 100%;
  }
  body {
    margin: 0ex 1ex;
    padding: 0px;
    background-color: white;
    color: #333;
    font-family: Verdana, sans-serif;
    font-size: 0.8em;
  }

  /* The project logo in the upper left-hand corner of each page */
  div.logo {
    display: table-cell;
    text-align: right;
    vertical-align: bottom;
    font-weight: normal;
  }

  /* Widths */
  div.header, div.mainmenu, div.submenu, div.content, div.footer {
    max-width: 900px;
    margin: auto;
    padding: 3px 20px 3px 20px;
    clear: both;
  }

  /* The page title at the top of each page */
  div.title {
    display: table-cell;
    padding-left: 10px;
    font-size: 2em;
    margin: 10px 0 10px -20px;
    vertical-align: bottom;
    text-align: left;
    width: 80%;
    font-family: Verdana, sans-serif;
    font-weight: bold;
    color: #558195;
    text-shadow: 0px 2px 2px #999999;
  }

  /* The login status message in the top right-hand corner */
  div.status {
    display: table-cell;
    text-align: right;
    vertical-align: bottom;
    color: #333;
    margin-right: -20px;
  }

  /* The main menu bar that appears at the top of the page beneath
   ** the header */
  div.mainmenu {
    text-align: center;
    color: white;
    border-top-left-radius: 5px;
    border-top-right-radius: 5px;
    vertical-align: middle;
    padding-top: 8px;
    padding-bottom: 8px;
    background-color: #799649;
    box-shadow: 0px 3px 4px #333333;
  }

  /* The submenu bar that *sometimes* appears below the main menu */
  div.submenu {
    padding-top:10px;
    padding-bottom:0;
    text-align: right;
    color: #000;
    background-color: #fff;
    height: 1.5em;
    vertical-align:middle;
    box-shadow: 0px 3px 4px #999;
  }
  div.mainmenu a, div.mainmenu a:visited {
    padding: 3px 10px 3px 10px;
    color: white;
    text-decoration: none;
  }
  div.submenu a, div.submenu a:visited, a.button,
  div.sectionmenu>a.button:link, div.sectinmenu>a.button:visited {
    padding: 2px 8px;
    color: #000;
    font-family: Arial;
    text-decoration: none;
    margin:auto;
    border-radius: 5px;
    background-color: #e0e0e0 ;
    text-shadow: 0px -1px 0px #eee;
    border: 1px solid #000;
  }

  div.mainmenu a:hover {
    color: #000;
    background-color: white;
  }

  div.submenu a:hover, div.sectionmenu>a.button:hover {
    background-color: #c0c0c0 ;
  }

  /* All page content from the bottom of the menu or submenu down to
   ** the footer */
  div.content {
    background-color: #fff;
    box-shadow: 0px 3px 4px #999;
    border-bottom-right-radius: 5px;
    border-bottom-left-radius: 5px;
    padding-bottom: 1em;
    min-height:40%;
  }


  /* Some pages have section dividers */
  div.section {
    margin-bottom: 0.5em;
    margin-top: 1em;
    margin-right: auto;
    padding: 1px 1px 1px 1px;
    font-size: 1.2em;
    font-weight: bold;
    text-align: center;
    color: white;
    border-radius: 5px;
    background-color: #446979;
    box-shadow: 0px 3px 4px #333333;
  }

  /* The "Date" that occurs on the left hand side of timelines */
  div.divider {
    font-size: 1.2em;
    font-family: Georgia, serif;
    font-weight: bold;
    margin-top: 1em;
    white-space: nowrap;
  }

  /* The footer at the very bottom of the page */
  div.footer {
    font-size: 0.9em;
    text-align: right;
    margin-bottom: 1em;
    color: #666;
  }

  /* Hyperlink colors in the footer */
  div.footer a { color: white; }
  div.footer a:link { color: white; }
  div.footer a:visited { color: white; }
  div.footer a:hover { background-color: white; color: #558195; }

  /* <verbatim> blocks */
  pre.verbatim, blockquote pre {
    font-family: Dejavu Sans Mono, Monaco, Lucida Console, monospace;
    background-color: #f3f3f3;
    padding: 0.5em;
    white-space: pre-wrap;
  }

  blockquote pre {
    border: 1px #000 dashed;
  }

  /* The label/value pairs on (for example) the ci page */
  table.label-value th {
    vertical-align: top;
    text-align: right;
    padding: 0.2ex 2ex;
  }


  table.report {
    border-collapse:collapse;
    border: 1px solid #999;
    margin: 1em 0 1em 0;
  }

  table.report tr th {
    padding: 3px 5px;
    text-transform : capitalize;
  }

  table.report tr td {
    padding: 3px 5px;
  }

  textarea {
    font-size: 1em;
  }


# reportfmt

title: All Tickets
cols:
  #ffffff Key:
  #f2dcdc Active
  #e8e8e8 Review
  #cfe8bd Fixed
  #bde5d6 Tested
  #cacae5 Deferred
  #c8c8c8 Closed

sqlcode:
  SELECT
    CASE WHEN status IN ('Open','Verified') THEN '#f2dcdc'
         WHEN status='Review' THEN '#e8e8e8'
         WHEN status='Fixed' THEN '#cfe8bd'
         WHEN status='Tested' THEN '#bde5d6'
         WHEN status='Deferred' THEN '#cacae5'
         ELSE '#c8c8c8' END AS 'bgcolor',
    substr(tkt_uuid,1,10) AS '#',
    datetime(tkt_mtime) AS 'mtime',
    type,
    status,
    subsystem,
    title
  FROM ticket


