pagetype = CGI.param('detail');
+%] <style> table {border-collapse:collapse;}</style> [%
SWITCH pagetype;
CASE 'myreports';
style='border-bottom:1px solid black';
END;
WRAPPER html/row;
- WRAPPER html/cell colspan=2 valign='top' style='height:200px';
+ WRAPPER html/cell colspan=2 valign='top';
INCLUDE fact_tables;
END;
END;
BLOCK show_reports;
WRAPPER html/table width='100%';
WRAPPER html/row;
- INCLUDE html/cell content='Public' nowrap='nowrap' col='lightgray';
- INCLUDE html/cell content='Report Name' nowrap='nowrap' col='lightgray';
- INCLUDE html/cell content='Created at' nowrap='nowrap' col='lightgray';
- INCLUDE html/cell content='Scheduled Run Date' nowrap='nowrap' col='lightgray';
- INCLUDE html/cell content='Recurrence' nowrap='nowrap' col='lightgray';
+ INCLUDE html/cell content='Public' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
+ INCLUDE html/cell content='Report Name' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
+ INCLUDE html/cell content='Created at' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
+ INCLUDE html/cell content='Scheduled Run Date' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
+ INCLUDE html/cell content='Recurrence' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
END;
FOR report = DBI.query(q);
bg='lightblue';
END;
WRAPPER html/row;
p = utils.JSON2perl( report.params );
- INCLUDE html/cell content=(report.pub ? 'Y' : 'N') col=bg;
- INCLUDE html/cell content=p.reportname col=bg;
- INCLUDE html/cell content=report.create_date.chunk(10).0 col=bg;
- INCLUDE html/cell content=report.runtime.chunk(10).0 col=bg;
- INCLUDE html/cell content=report.recurrence col=bg;
+ INCLUDE html/cell content=(report.pub ? 'Y' : 'N') col=bg style='border:solid gray 1px;' align='center';
+ INCLUDE html/cell content=p.reportname col=bg style='border:solid gray 1px;';
+ INCLUDE html/cell content=report.create_date.chunk(10).0 col=bg style='border:solid gray 1px;';
+ INCLUDE html/cell content=report.runtime.chunk(10).0 col=bg style='border:solid gray 1px;';
+ INCLUDE html/cell content=report.recurrence col=bg style='border:solid gray 1px;';
END;
END;
END;
END;
BLOCK show_templates;
- WRAPPER html/table width='100%';
+ WRAPPER html/table width='100%' class='withborder';
WRAPPER html/row;
- INCLUDE html/cell content='Public' nowrap='nowrap' col='lightgray';
- INCLUDE html/cell content='Template Name' nowrap='nowrap' col='lightgray';
- INCLUDE html/cell content='Created at' nowrap='nowrap' col='lightgray';
+ INCLUDE html/cell content='Public' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
+ INCLUDE html/cell content='Template Name' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
+ INCLUDE html/cell content='Created at' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
END;
FOR template = DBI.query(q);
tid = template.id;
END;
WRAPPER html/row;
p = utils.JSON2perl( template.params );
- INCLUDE html/cell content=(template.pub ? 'Y' : 'N') col=bg;
- INCLUDE html/cell content=link(content=p.templatename,href="stage2?id=$tid") col=bg;
- INCLUDE html/cell content=template.create_date.chunk(10).0 col=bg;
- INCLUDE html/cell content=template.recurrence col=bg;
+ INCLUDE html/cell content=(template.pub ? 'Y' : 'N') col=bg style='border:solid gray 1px;' align='center';
+ INCLUDE html/cell content=link(content=p.templatename,href="stage2?id=$tid") col=bg style='border:solid gray 1px;';
+ INCLUDE html/cell content=template.create_date.chunk(10).0 col=bg style='border:solid gray 1px;';
END;
END;
END;
END;
BLOCK fact_tables;
- WRAPPER html/table width='100%';
+ WRAPPER html/table width='100%' class='withborder';
WRAPPER html/row;
- INCLUDE html/cell content='Fact table' nowrap='nowrap' col='lightgray';
- INCLUDE html/cell content='Description' nowrap='nowrap' col='lightgray';
+ INCLUDE html/cell content='Fact table' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
+ INCLUDE html/cell content='Description' nowrap='nowrap' col='lightgray' style='border:solid gray 1px;';
END;
FOR tab IN config.findnodes("/reporter/tables/table[@fact-table='true']");
tid = tab.findvalue('@id');
p = utils.JSON2perl( template.params );
INCLUDE html/cell
col=bg
- content=link(content=tab.findvalue('tablename'),href="stage1?id=$tid");
- INCLUDE html/cell content=tab.findvalue('description');
+ content=link(content=tab.findvalue('tablename'),href="stage1?id=$tid") style='border:solid gray 1px;';
+ INCLUDE html/cell content=tab.findvalue('description') style='border:solid gray 1px;';
END;
END;
END;