<?
include("../settings.php");
/* Connecting, selecting database */
or
die("Could not connect");
$query = "SELECT kunde,projektnr from emp_kunde";
{
}
$query = "SELECT hvorgang,uvorgang,status,soll from emp_details ";
{
}
if (isset($HTTP_POST_VARS["datum"])) {
$nr = $HTTP_POST_VARS["nr"];
$datum = $HTTP_POST_VARS["datum"];
$von = $HTTP_POST_VARS["von"];
$bis = $HTTP_POST_VARS["bis"];
$kunde = $HTTP_POST_VARS["kunde"];
$projekt = $HTTP_POST_VARS["projekt"];
$hVorgang = $HTTP_POST_VARS["hvorgang"];
$uVorgang = $HTTP_POST_VARS["uvorgang"];
$text = $HTTP_POST_VARS["text"];
$ist = $HTTP_POST_VARS["ist"];
$soll = $HTTP_POST_VARS["soll"];
$status = $HTTP_POST_VARS["status"];
$query = "INSERT INTO t_emp";
$query.="(nr,datum,von,bis,kunde,projekt,hvorgang,uvorgang, text,ist,soll,status) values ";
$query.="('$nr','$datum','$von','$bis','$kunde','$projekt', '$hVorgang','$uVorgang','$text','$ist','$soll','$s tatus')";
$updatePK = "UPDATE key_generator set id = $nr where name = 't_emp'";
mysql_query($updatePK) or
die("Query failed: Update field 'nr' (PK)");
}
/// this is the place to get soll value but problem is nr. filed always incremented by 2
$query = "SELECT * FROM t_emp order by nr DESC";
$query = "SELECT id from key_generator where name = 't_emp'";
$pk = $row[id];
$pk++;
function fillDD($min, $max, $selected) //selected format 12:30
{
$sel_bits =
explode(":",
$selected);
for($i=$min; $i<24; $i++) {
//$i = sprintf('%02d', $i); # set $i to be padded with a 0's up to 2 characters
for($j=$max; $j<60; $j+=5) {
$j =
sprintf('%02d',
$j);
# set $j to be padded with a 0's up to 2 characters if($i == $sel_bits[0] && $j == $sel_bits[1]) {
print("<option SELECTED value='$i:$j'>$i:$j</option>n");
}
else {
print("<option value='$i:$j'>$i:$j</option>n");
}
}//for($j)
} //for($i)
}
$arrDay =
array ("So",
"Mo",
"Di",
"Mi",
"Do",
"Fr",
"Sa");
?>
<html>
<head>
<title>Log-Zeiterfassung</title>
<link rel="stylesheet" type="text/css" href="../styles/styles.css" />
<script language="JavaScript" src="date-picker.js"></script>
<SCRIPT LANGUAGE="JavaScript" src="log.js"></script>
<SCRIPT language="JavaScript">
function calculateIst()
{
var time =document.forms
["tstest"].elements
["von"].value.
split(":");
vontime=parseInt
(time[0]*
60)+parseInt
(time[1]);
var time1 =document.forms
["tstest"].elements
["bis"].value.
split(":");
bistime=parseInt(time1[0]*60) +parseInt(time1[1])
diff=(bistime-vontime)
if(diff<0){
alert("assure that bis is greater than von")
return false
}
if (hrs<=9)
hrs="0"+hrs
if(min<=9)
document.forms
["tstest"].elements
["ist"].value =hrs +
":" +
min;
}
</script>
</head>
<form name="tstest" action="log.phtml" method="post">
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" class="mybar">
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 width=100% name="rsTable" id=rsTable cols=12>
<tr bgcolor="#cccccc">
<!--<th> </th> -->
<!--<th nowrap>Nr.</th>-->
<th nowrap>Datum</th>
<th nowrap>Von</th>
<th nowrap>Bis</th>
<th nowrap>Kunde</th>
<th nowrap>Projekt</th>
<th nowrap>H-Vorgang</th>
<th nowrap>U-Vorgang</th>
<th nowrap>Text</th>
<th nowrap>IST</th>
<th nowrap>Soll</th>
<th nowrap>Status</th>
<th nowrap> </th>
</tr>
<? if (!
isset($HTTP_POST_VARS["Save"])) { ?> <tr>
<!--<td><a href=
"edit.phtml"><img src=
"../img/edit.gif" border=
"1"></a></td> -->
<input size="1" type="hidden" name="nr" value="<?= $pk ?>">
<td nowrap align="center">
<input size="7" type="text" name="datum" value="<?=$D?> <?= date("d.m.y") ?>">
<a href=
"javascript:show_calendar('tstest.datum');"><img src=
"../img/cal.gif" width=
"16" height=
"16" border=
"0" alt=
"Click Here to Pick up the date"></a>
</td>
<td nowrap align="center">
<select name="von">
fillDD(0, 0, $bis);
}else{
//Lets try & select the closest time to now.
$mins -= ($mins % 5); //subtracts the remainder when divided by 5, from the original number
fillDD
(0,
0,
date('H') .
":" .
$mins);
} ?>
</select>
<input type="button" name="now" size="1" value=">" onclick="inputTime();calculateIst()">
</td>
<td nowrap align="center">
<!--<input type="text" size="1" class="button" name="clock">-->
<select name="bis" onchange="calculateIst()">
<option value=
"<?=date('H:i')?>"><?
echo (date('H:i')); ?></option>
<? fillDD(0, 0, -1); ?>
</select>
<input type="button" name="now" size="1" value=">" onclick="insertTime();calculateIst()">
</td>
<td align="center">
<select name="kunde" onchange="redirect(this.options.selectedIndex)">
<? foreach($kunden as $value) { ?>
<option value="<?= $value ?>"><?= $value ?></option>
<? } ?>
</select>
</td>
<td align="center">
<select name="projekt">
<? foreach($hprojekt as $value) {
if ($value == "<?= $value ?>") { #set Uncle to the value that you want selected.
echo "<option value="$value" selected="selected
">$value</option>";
}
else {
echo "<option value="$value">$value</option>";
}
} ?>
</select>
</td>
<td align="center">
<select name="hvorgang" onchange="redirect1(this.options.selectedIndex)">
<? foreach($haupt as $value) { ?>
<option value="<?= $value ?>"><?= $value ?></option>
<? } ?>
</select>
</td>
<td align="center">
<select name="uvorgang">
<? foreach($unter as $value) { ?>
<option value="<?= $value ?>"><?= $value ?></option>
<? } ?>
</select>
</td>
<td align="center">
<textarea name="text" class="mybar" id="tar" cols="15" rows="1" onfocus="tarea();" onblur="tarea();" title=""></textarea>
<input type="hidden" size="1" name="remLen" value="20">
<img src="../img/edit.gif" onclick="window.open('thewindow.html','newWin','width=150,h eight=130,top=525,left=800,dependent=yes,alwaysRai sed=yes,resizable=1')" width="16" height="16" border="0" alt="Edit Text"></a>
</td>
<td bgcolor="#cccccc" align="center"><input size="1" type="text" value="00:00" name="ist" readonly></td>
<td bgcolor="#cccccc" align="center"><input size="1" type="text" name="soll" value="<?= $getrow["soll"] ?>" readonly></td>
<td align="center">
<select name="status">
<? foreach($hstatus as $value) { ?>
<option selected value="<?= $value ?>"><?= $value ?></option>
<? } ?>
</select>
</td>
<td align="center">
<input type="button" value="S" name="Save" border="1" onclick="go();">
</td>
</tr>
<? } ?>
<!--
<? $date =
explode(' ',
$line["datum"]); ?>-->
<tr bgcolor="#FACB84">
<!--<td> </td>-->
<!-- <td><?= $line["nr"] ?></td> -->
<td nowrap align="center"><?= $line["datum"] ?></td>
<td nowrap align="center"><?= $line["von"] ?></td>
<td nowrap align="center"><?= $line["bis"] ?></td>
<td nowrap align="center"><?= $line["kunde"] ?></td>
<td nowrap align="center"><?= $line["projekt"] ?></td>
<td nowrap align="center"><?= $line["hvorgang"] ?></td>
<td nowrap align="center"><?= $line["uvorgang"] ?></td>
<td align="center"><?= $line["text"] ?></td>
<td nowrap align="center"><?= $line["ist"] ?></td>
<td nowrap align="center"><?= $line["soll"] ?></td>
<td nowrap align="center"><?= $line["status"] ?></td>
</tr>
<? } ?>
</table>
</body>
<script language="javascript" src="triplecombo.js"></script>
</form>
<script language="JavaScript">
function go(){
var myindex=document.forms["tstest"].bis.selectedIndex;
if (myindex==0) {
alert("nPlease be sure that time from bis drop-down menu is selected.");
}
else {
document.tstest.submit(); }
}//submit go()
/*var times = new Array ();
function createArray() {
for (i=0; i<document.tstest.bis.length; i++) {
times[times.length] = new Option(document.tstest.bis[i].value, document.tstest.bis[i].value);
}
} */
var x = 0;
function insertTime() {
minute =
time.getMinutes
();
hour =
time.getHours
().toString
().length <
2 ?
"0"+hour : hour;
minute = minute.toString().length < 2 ? "0"+minute : minute;
if (x==1) {
document.tstest.bis.options[document.tstest.bis.length-1] = null;
}
var anOption = new Option(hour+":"+minute, hour+":"+minute);
document.tstest.bis.options[document.tstest.bis.options.length] = anOption
x = 1;
document.tstest.bis.options.selectedIndex = document.tstest.bis.options.length-1;
}
var y = 0;
function inputTime() {
minute =
time.getMinutes
();
hour =
time.getHours
().toString
().length <
2 ?
"0"+hour : hour;
minute = minute.toString().length < 2 ? "0"+minute : minute;
if (y==1) {
document.tstest.von.options[document.tstest.von.length-1] = null;
}
var anOption = new Option(hour+":"+minute, hour+":"+minute);
document.tstest.von.options[document.tstest.von.options.length] = anOption
y = 1;
document.tstest.von.options.selectedIndex = document.tstest.von.options.length-1;
}
function tarea()
{
if(document.getElementById)
{
if(document.getElementById("tar").rows == 3)
{
document.getElementById("tar").rows = 1
a = document.getElementById("tar").value
//a = a.substring(10)
if(a)
{
document.getElementById("tar").title = a
}
else
{
document.getElementById("tar").title = ''
}
}
else
{
document.getElementById("tar").rows = 3
document.getElementById("tar").title = ''
}
}
}
</script>
</html>
<?
?>
Codewalkers Forums Sponsor:
July 19th, 2003, 02:26 PM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
