Deutsches Application Express Forum (ApEx) -- Installation , Engine / SQL , Anwendungen
HTMLDB Engine :  Oracle Apex The fastest message board... ever.
Alles in HTMLDB, Applikationen, Berichte, SQL ... 
Re: zeit vergleichen und background ändern report
geschrieben von: christian_goto (---.dip0.t-ipconnect.de)
Datum:

hab gerade mal firefox gestartet (mit firebug),allerdings erschlägt mich der code :) .ja, PERSO_DAT ist eine DATE spalte.


gäbe es sonst eine andere möglichkeit,die farbe in einem zeitraum anzuzeigen?
weil mein problem ist, > 3 monate ist ok.< 1 monat auch.aber wie drücke ich zwischen 3 und 1 monat aus?

gruss/chris


quellcode:

.......................................................................



<html lang="de" xmlns:htmldb="[htmldb.oracle.com">];
<head>
<title>Mitarbeiter</title>
<link rel="stylesheet" href="/i/themes/theme_15/theme_3_1.css" type="text/css" />

<script src="/i/javascript/apex_ns_3_1.js" type="text/javascript"></script>
<script src="/i/javascript/apex_3_1.js" type="text/javascript"></script>
<script src="/i/javascript/apex_get_3_1.js" type="text/javascript"></script>
<script src="/i/javascript/apex_builder.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
/*Global JS Variables*/
var htmldb_Img_Dir = "/i/";
//-->
</script>
<link rel="stylesheet" href="/i/css/apex_3_1.css" type="text/css" />
<!--[if IE]><link rel="stylesheet" href="/i/css/apex_ie_3_1.css" type="text/css" /><![endif]-->

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body ><form action="wwv_flow.accept" method="post" name="wwv_flow" id="wwvFlowForm" >
<input type="hidden" name="p_flow_id" value="100" id="pFlowId" /> <input type="hidden" name="p_flow_step_id" value="1" id="pFlowStepId" /> <input type="hidden" name="p_instance" value="2897783283946217" id="pInstance" /> <input type="hidden" name="p_page_submission_id" value="3244741221015914" id="pPageSubmissionId" /> <input type="hidden" name="p_request" value="" id="pRequest" /><table summary="" cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td><div class="t15logo"></div><br /></td>
<td width="100%" valign="top"></td>
<td><div class="t15NavBar"><span class="t15NavBarItem">MEAT_WSA</span><a href="wwv_flow_custom_auth_std.logout?p_this_flow=100&amp;p_next_flow_page_sess=100:1" class="t15NavBarItem">Abmelden</a></div><br /></td>
</tr>
</table>
<br style="clear:both;"/>
<table summary="" cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="100%" class="t15pagelinecenter"><img src="/i/themes/theme_15/page_line_center.gif" alt="" /></td>
</tr>
<tr class="t15PageTopLine">
<td><div id="R9083007127764060" class="t15breadcrumb"><ul><li class="t15Current"><span>Mitarbeiter</span></li></ul></div></td>
</tr>
</table>
<br />
<table width="100%" summary="" height="70%" cellspacing="0" cellpadding="0" border="0">
<tr>
<td class="t15PageBody"><div class="t15Messages" align="center"></div><table width="100%" border="0" cellspacing="0" cellpadding="0" id="R9079918097764025" class="t15ReportsRegion" summary="">
<tr>
<td valign="bottom" class="t15RegionHeader">MA<a class="eLink" title="Bearbeiten:&nbsp;MA" href="javascript:popupURL('f?p=4000:374:2897783283946217::::P374_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID:9079918097764025,100,1');"><img src="/i/e.gif" alt="Bearbeiten" class="eLink" /></a></td>
<td align="right" class="t15ButtonHolder"><table class="t15Button" cellspacing="0" cellpadding="0" border="0" summary=""><tr>
<td class="t15L"><img src="/i/themes/theme_15/button-l.gif" alt="" /></td>
<td class="t15C"><a href="javascript:doSubmit('RESET')">Zurücksetzen</a></td>
<td class="t15R"><img src="/i/themes/theme_15/button-r.gif" alt="" /></td>
</tr></table><a class="eLink" title="Bearbeiten" href="javascript:popupURL('f?p=4000:381:2897783283946217:::381:P381_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID:9082430347764040,100,1');" tabindex="999"><img src="/i/e.gif" alt="Bearbeiten" class="eLink" /></a>&nbsp;&nbsp;&nbsp;</td></tr>
<tr>
<td colspan="2" valign="top" class="t15Body"><table id="apex_layout_9079918097764025" class="formlayout" summary="" ><tr><td align="right"><a class="t15optionalwithhelp" href="javascript:popupFieldHelp('9082201607764040','2897783283946217')" tabindex="999">Suche</a></td>
<td colspan="1" rowspan="1" align="left"><input type="hidden" name="p_arg_names" value="9082201607764040" /><input type="text" name="p_t01" size="30" maxlength="2000" value="" onkeypress="return submitEnter(this,event)" id="P1_REPORT_SEARCH" /><a class="eLink" title="Bearbeiten" href="javascript:popupURL('f?p=4000:371:2897783283946217::::P371_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID:9082201607764040,100,1');" tabindex="999"><img src="/i/e.gif" alt="Bearbeiten" class="eLink" /></a></td><td align="right"><a class="t15optionalwithhelp" href="javascript:popupFieldHelp('9082314784764040','2897783283946217')" tabindex="999">Anzeige</a></td>
<td colspan="1" rowspan="1" align="left"><input type="hidden" name="p_arg_names" value="9082314784764040" /><select name="p_t02" size="1" id="P1_ROWS" >
<option value="10">10</option>
<option selected="selected" value="15">15</option>
<option value="20">20</option>
<option value="30">30</option>
<option value="50">50</option>
<option value="100">100</option>
<option value="200">200</option>
<option value="500">500</option>
<option value="1000">1000</option>
<option value="5000">5000</option>
</select>
<a class="eLink" title="Bearbeiten" href="javascript:popupURL('f?p=4000:371:2897783283946217::::P371_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID:9082314784764040,100,1');" tabindex="999"><img src="/i/e.gif" alt="Bearbeiten" class="eLink" /></a></td><td align="left"></td>
<td colspan="1" rowspan="1" align="left"><table class="t15Button" cellspacing="0" cellpadding="0" border="0" summary=""><tr>
<td class="t15L"><img src="/i/themes/theme_15/button-l.gif" alt="" /></td>
<td class="t15C"><a href="javascript:doSubmit('Los');">Los</a></td>
<td class="t15R"><img src="/i/themes/theme_15/button-r.gif" alt="" /></td>
</tr></table><a class="eLink" title="Bearbeiten" href="javascript:popupURL('f?p=4000:372:2897783283946217::::P372_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID:9082531267764046,100,1');" tabindex="999"><img src="/i/e.gif" alt="Bearbeiten" class="eLink" /></a></td></tr>
</table>
<div id="report_9079918097764025_catch"><table class="t15standard" summary="" id="report_R9079918097764025">
<tr ><th class="t15header" ><a href="javascript:$a_report('9079918097764025',false,false,false,'fsp_sort_1_desc')" title="Nach dieser Spalte sortieren">Personalausweis gültig bis</a><img src="/i/arrow_up_gray_dark.gif" width="13" height="12" alt="Nach dieser Spalte sortieren" /></th></tr>
<tr onmouseover="row_mouse_over9079918097764025(this, 1)" onmouseout="row_mouse_out9079918097764025(this, 1)"><td class="t15data" ><div style="background-color:green;"> 08.12.10 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 2)" onmouseout="row_mouse_out9079918097764025(this, 2)"><td class="t15data" ><div style="background-color:green;"> 10.06.10 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 3)" onmouseout="row_mouse_out9079918097764025(this, 3)"><td class="t15data" ><div style="background-color:red;"> 05.03.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 4)" onmouseout="row_mouse_out9079918097764025(this, 4)"><td class="t15data" ><div style="background-color:red;"> 13.02.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 5)" onmouseout="row_mouse_out9079918097764025(this, 5)"><td class="t15data" ><div style="background-color:red;"> 24.02.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 6)" onmouseout="row_mouse_out9079918097764025(this, 6)"><td class="t15data" ><div style="background-color:red;"> 26.02.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 7)" onmouseout="row_mouse_out9079918097764025(this, 7)"><td class="t15data" ><div style="background-color:red;"> 26.03.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 8)" onmouseout="row_mouse_out9079918097764025(this, 8)"><td class="t15data" ><div style="background-color:red;"> 26.04.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 9)" onmouseout="row_mouse_out9079918097764025(this, 9)"><td class="t15data" ><div style="background-color:red;"> 27.02.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 10)" onmouseout="row_mouse_out9079918097764025(this, 10)"><td class="t15data" ><div style="background-color:red;"> 28.02.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 11)" onmouseout="row_mouse_out9079918097764025(this, 11)"><td class="t15data" ><div style="background-color:red;"> 29.03.09 </div></td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 12)" onmouseout="row_mouse_out9079918097764025(this, 12)"><td class="t15data" >10.06.09</td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 13)" onmouseout="row_mouse_out9079918097764025(this, 13)"><td class="t15data" >&nbsp;</td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 14)" onmouseout="row_mouse_out9079918097764025(this, 14)"><td class="t15data" >&nbsp;</td></tr><tr onmouseover="row_mouse_over9079918097764025(this, 15)" onmouseout="row_mouse_out9079918097764025(this, 15)"><td class="t15data" >&nbsp;</td></tr><tr>
<td colspan="99" class="t15afterrows">
<span class="left"><a href="f?p=100:1:2897783283946217:FLOW_EXCEL_OUTPUT_R9079918097764025_de" >Arbeitsblatt</a></span>
<table style="float:right;text-align:right;" summary="pagination"><tr><td colspan="1" align="right" ><table summary=""><tr><td class="pagination"></td><td class="pagination"></td><td nowrap="nowrap" class="pagination"><span class="fielddata"><label for="X01_9079918097764025" class="hideMe508"></label><select name="X01" size="1" onchange="$a_report_Split('9079918097764025',$v(this));" id="X01_9079918097764025"><option value="current" selected="selected">Zeile(n) 1 - 15 von 28</option><option value="16_15_15">16 - 28 von 28</option></select></span></td><td class="pagination"><table border="0" cellspacing="0" cellpadding="0" summary=""><tr><td><a href="javascript:$a_report('9079918097764025','16','15','15');" class="fielddata">Weiter</a></td><td><a href="javascript:$a_report('9079918097764025','16','15','15');"><img src="/i/jtfunexe.gif" width="16" height="16" alt="Weiter" /></a></td></tr></table></td><td class="pagination"></td></tr></table></td></tr></table>
</td>
</tr></table>
<script type="text/javascript">
<!--
var rowStyle = new Array(15);
var rowActive = new Array(15);
var rowStyleHover = new Array(15);


rowStyle[1]='';
rowStyleHover[1]='';
rowActive[1]='N';
rowStyle[2]='';
rowStyleHover[2]='';
rowActive[2]='N';
rowStyle[3]='';
rowStyleHover[3]='';
rowActive[3]='N';
rowStyle[4]='';
rowStyleHover[4]='';
rowActive[4]='N';
rowStyle[5]='';
rowStyleHover[5]='';
rowActive[5]='N';
rowStyle[6]='';
rowStyleHover[6]='';
rowActive[6]='N';
rowStyle[7]='';
rowStyleHover[7]='';
rowActive[7]='N';
rowStyle[8]='';
rowStyleHover[8]='';
rowActive[8]='N';
rowStyle[9]='';
rowStyleHover[9]='';
rowActive[9]='N';
rowStyle[10]='';
rowStyleHover[10]='';
rowActive[10]='N';
rowStyle[11]='';
rowStyleHover[11]='';
rowActive[11]='N';
rowStyle[12]='';
rowStyleHover[12]='';
rowActive[12]='N';
rowStyle[13]='';
rowStyleHover[13]='';
rowActive[13]='N';
rowStyle[14]='';
rowStyleHover[14]='';
rowActive[14]='N';
rowStyle[15]='';
rowStyleHover[15]='';
rowActive[15]='N';

function row_mouse_over9079918097764025(rowNode,currentRowNum) {
rowActive = 'Y';
for( var i = 0; i < rowNode.childNodes.length; i++ ) {
if (rowNode.childNodes.tagName=='TD') {
rowStyleHover[currentRowNum] = rowNode.childNodes.style.backgroundColor;
rowNode.childNodes.style.backgroundColor = '#cfe0f1';
}
}

}
function row_mouse_out9079918097764025(rowNode,currentRowNum) {
rowActive = 'N';
for( var i = 0; i < rowNode.childNodes.length; i++ ) {
if (rowNode.childNodes.tagName=='TD') {
rowNode.childNodes.style.backgroundColor = rowStyleHover[currentRowNum];
}
}

}
// -->
</script>
</div></td>
</tr>
</table></td>
<td align="right" valign="top"><img src="/i/f_spacer.gif" width="15" height="3" alt="" /></td>
<td class="t15RightBar" align="right" valign="top"></td>
</tr>
</table><hr />
<div class="t15customize"></div>
<br />

<input type="hidden" name="p_md5_checksum" value="" /></form>
<script type="text/javascript">
<!--

//-->
</script><!-- Code generated for user with developer privileges. -->
<script type="text/javascript">
function popupInfo()
{
w = open("f?p=4000:34:2897783283946217:PAGE:NO:34:F4000_P34_SESSION,F4000_P34_FLOW,F4000_P34_PAGE:2897783283946217,100,1","winLov","Scrollbars=1,resizable=1,width=700,height=450");
if (w.opener == null)
w.opener = self;
w.focus();
}
</script><table cellpadding="0" border="0" cellspacing="0" summary="Developer Toolbar" align="center"><tbody><tr><td><a class="htmldbToolbar" href="f?p=4500:1000:2897783283946217" style="border-left:1px solid black;" title="Application Express-Homepage">Home</a></td><td><a class="htmldbToolbar" title="Anwendung 100" href="f?p=4000:1:2897783283946217::NO:1,4150,RP:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:100,1,100,1,1" style="border-left:1px solid #000000;border-right:1px solid #000000;">Anwendung 100</a></td><td><a class="htmldbToolbar" title="Seite bearbeiten 1" href="f?p=4000:4150:2897783283946217::NO:1,4150:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:100,1,100,1,1">Seite bearbeiten 1</a></td><td><a class="htmldbToolbar" href="f?p=4000:336:2897783283946217::::FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:100,1,100,1,1" style="border-left:1px solid black;" title="Erstellen">Erstellen</a></td><td><a class="htmldbToolbar" href="javascript:popupInfo()" style="border-left:1px solid black;" title="Session">Session</a></td><td><a class="htmldbToolbar" href="f?p=4000:14:2897783283946217::::FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:100,1,100,1,1" style="border-left:1px solid black;" title="Aktivität">Aktivität</a></td><td><a class="htmldbToolbar" title="Debuggen" style="border-left:1px solid black;" href="f?p=100:1:2897783283946217::YES">Debuggen</a></td><td id="hideEdit" style="display:none;"><a class="htmldbToolbar" title="Bearbeiten-Links ausblenden" href="javascript:quickLinks('HIDE');" style="border-right:1px solid #000000;border-left:1px solid black;">Bearbeiten-Links ausblenden</a></td><td id="showEdit"><a class="htmldbToolbar" title="Bearbeiten-Links anzeigen" href="javascript:quickLinks('SHOW');" style="border-right:1px solid #000000;border-left:1px solid #000000;">Bearbeiten-Links anzeigen</a></td></tr></tbody></table>
<script type="text/javascript">
if(GetCookie('ORA_WWV_QUICK_EDIT') != null){
if(GetCookie('ORA_WWV_QUICK_EDIT') == 'SHOW')
quickLinks('SHOW');
}
</script>
</body>
</html>






Thema Neugierige geschrieben von geschrieben
zeit vergleichen und background ändern report 2715 christian_goto
Re: zeit vergleichen und background ändern report 1230 cc13
Re: zeit vergleichen und background ändern report 1239 christian_goto
Re: zeit vergleichen und background ändern report 1242 christian_goto
Re: zeit vergleichen und background ändern report 1238 cc13
Re: zeit vergleichen und background ändern report 1262 christian_goto
Re: zeit vergleichen und background ändern report 1118 cc13
Re: zeit vergleichen und background ändern report 1225 christian_goto
Re: zeit vergleichen und background ändern report 1202 cc13
Re: zeit vergleichen und background ändern report 3041 christian_goto
Re: zeit vergleichen und background ändern report 1186 cc13
Re: zeit vergleichen und background ändern report 1280 christian_goto
Re: zeit vergleichen und background ändern report 1751 christian_goto
Re: zeit vergleichen und background ändern report 1236 cc13
Re: zeit vergleichen und background ändern report 1639 christian_goto
Re: zeit vergleichen und background ändern report 1393 christian_goto
Re: zeit vergleichen und background ändern report 1243 cc13


In diesem Forum dürfen nur registrierte Benutzer schreiben.
This forum powered by Phorum.