Menu
Hi,
Now, I save data to database using the save button with this code:
[code]
<?php
include ‘config.php’;
$currentEmpID = $_SESSION[’empID’];
$sql = “SELECT EMP_ID, CONCAT(LNAME, ‘, ‘ , FNAME, ‘ ‘, MI) AS FULLNAME FROM PERSONAL ORDER BY LNAME ASC”;
$recPersonalNav = $conn->GetAll($sql);
$smarty->assign(‘personalAll’, $recPersonalNav);
$sql = “SELECT em.EMP_NO, p.EMP_ID, CONCAT(LNAME, ‘, ‘, FNAME, ‘ ‘, MI, ‘.’) AS FULLNAME FROM PERSONAL p, EMPLOYMENT em WHERE p.EMP_ID=’$currentEmpID’ AND em.EMP_ID = ‘$currentEmpID'”;
$recPersonalHead = $conn->Execute($sql);
$fullName = $recPersonalHead->fields[“FULLNAME”];
$empno = $recPersonalHead->fields[“EMP_NO”];
$smarty->assign(’empid’, $currentEmpID);
$smarty->assign(‘fullname’, $fullName);
$smarty->assign(’empno’, $empno);
//==============Save Other Earnings============//
$RegOTAmt = $_POST[‘RegOTAmt’];
$SunSpecHolAmt = $_POST[‘SunSpecHolAmt’];
$SunSpecHolOtAmt = $_POST[‘SunSpecHolOtAmt’];
$RegHolAmt = $_POST[‘RegHolAmt’];
$RegHolOtAmt = $_POST[‘RegHolOtAmt’];
$HolLeaveAmt = $_POST[‘HolLeaveAmt’];
$NightPremAmt = $_POST[‘NightPremAmt’];
$MealAllowAmt = $_POST[‘MealAllowAmt’];
$COLAAmt = $_POST[‘COLAAmt’];
$sql = “SELECT EMP_NO, OTReg_Amt, SunReg_Amt, OTSun_Amt, HolReg_Amt, HolRegOT_Amt, HolLeave_Amt, NP_Amt, Meal_Amt, Cola_Amt FROM other_earnings WHERE EMP_NO = ‘$empno'”;
$RsOtherEarnings = $conn2->Execute($sql);
$numrowsOtherEarnings = $RsOtherEarnings->RecordCount();
if($numrowsOtherEarnings > 0){
$saverec[‘EMP_NO’] = $empno;
$saverec[‘OTReg_Amt’] = $RegOTAmt;
$saverec[‘SunReg_Amt’] = $SunSpecHolAmt;
$saverec[‘OTSun_Amt’] = $SunSpecHolOtAmt;
$saverec[‘HolReg_Amt’] = $RegHolAmt;
$saverec[‘HolRegOT_Amt’] = $RegHolOtAmt;
$saverec[‘HolLeave_Amt’] = $HolLeaveAmt;
$saverec[‘NP_Amt’] = $NightPremAmt;
$saverec[‘Meal_Amt’] = $MealAllowAmt;
$saverec[‘Cola_Amt’] = $COLAAmt;
$updateOtherEarnings = $conn2->GetUpdateSQL($RsOtherEarnings, $saverec);
$conn2->Execute($updateOtherEarnings);
}
else{
$sql = “SELECT o.EMP_NO, o.OTReg_Amt, o.SunReg_Amt, o.OTSun_Amt, o.HolReg_Amt, o.HolRegOT_Amt, o.HolLeave_Amt, o.NP_Amt, o.Meal_Amt, o.Cola_Amt FROM $PAYROLL.other_earnings o, $ADODB_DB.employment em WHERE em.EMP_ID = ‘$currentEmpID'”;
$RsOtherEarnings = $conn2->Execute($sql);
$saverec[‘EMP_NO’] = $empno;
$saverec[‘OTReg_Amt’] = $RegOTAmt;
$saverec[‘SunReg_Amt’] = $SunSpecHolAmt;
$saverec[‘OTSun_Amt’] = $SunSpecHolOtAmt;
$saverec[‘HolReg_Amt’] = $RegHolAmt;
$saverec[‘HolRegOT_Amt’] = $RegHolOtAmt;
$saverec[‘HolLeave_Amt’] = $HolLeaveAmt;
$saverec[‘NP_Amt’] = $NightPremAmt;
$saverec[‘Meal_Amt’] = $MealAllowAmt;
$saverec[‘Cola_Amt’] = $COLAAmt;
$insertOtherEarnings = $conn2->GetInsertSQL($RsOtherEarnings, $saverec);
$conn2->Execute($insertOtherEarnings);
}
$smarty->display(‘header.tpl’);
$smarty->display(‘left.tpl’);
$smarty->display(’empPayrollData.tpl’);
$smarty->display(‘footer.tpl’);
?>
But i need to do is everytime the employee name was click and i click another employee name the data was in the first employee that I click will save.
here is my code for displaying employee name:
left.tpl
[code]
<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.0 Transitional//EN”>
<html>
<head>
<script>
function searchemppay(queryString) {
var ajaxRequest = remoteRequestObject();
ajaxRequest.onreadystatechange = function() {
if (ajaxRequest.readyState == 4 && ajaxRequest.status == 200) {
var result = ajaxRequest.responseText;
document.getElementById(‘searchpayroll’).innerHTML = result;
}
}
var url = “search.php?query=” + queryString;
ajaxRequest.open(“GET”, url, true);
ajaxRequest.setRequestHeader(“If-Modified-Since”, “Sat, 1 Jan 2000 00:00:00 GMT”);
ajaxRequest.send(null);
}
function changeEmployeePay(queryID) {
window.location = “SearchData.php?queryEmpID=” + queryID;
}
</script>
<title>Untitled</title>
</head>
<body>
<div id=”Search”>
<form>
<p class=”serif”><b>Search Lastname:</b></p>
<input type=”text” name=”search_” size=”20″ onkeyup=”searchemppay(this.value);”>
<div id=”searchpayroll” style=”overflow:auto; height:390px; width:auto; margin-left:2px” >
<hr />
<ul>
{section name=co_emp loop=$personalAll}
<li onclick=”changeEmployeePay(‘{$personalAll[co_emp].EMP_ID}’)”>{$personalAll[co_emp].FULLNAME}</li>
<hr />
{sectionelse}
<li>No records found</li>
{/section}
</ul>
</div>
</form>
</div>
</body>
</html>
search.php
[code]
<?php
session_start();
include ‘config.php’;
$queryString = $_GET[“query”];
if ($queryString == “” || $queryString == null) {
$sql = “SELECT EMP_ID, CONCAT(LNAME, ‘, ‘, FNAME, ‘ ‘, MI, ‘.’) AS FULLNAME FROM PERSONAL
ORDER BY FULLNAME ASC”;
}
else {
$sql = “SELECT EMP_ID, CONCAT(LNAME, ‘, ‘, FNAME, ‘ ‘, MI, ‘.’) AS FULLNAME FROM PERSONAL WHERE LNAME LIKE ‘” . $queryString . “%’ ORDER BY FULLNAME ASC”;
}
$recPersonalQuery = $conn->Execute($sql);
if (!$recPersonalQuery->BOF) {
$recPersonalQuery->MoveFirst();
}
echo “<hr />”;
echo “<ul>”;
while (!$recPersonalQuery->EOF) {
$empID = $recPersonalQuery->fields[“EMP_ID”];
$empFullName = $recPersonalQuery->fields[“FULLNAME”];
echo “<li onclick=changeEmployeePay(‘$empID’); style= ‘font-family:’Times New Roman’,Times,serif; font-size:10%;’>$empFullName</li>”;
echo “<hr />”;
$recPersonalQuery->MoveNext();
}
echo “</ul>”;
$recPersonalQuery->Close();
exit();
?>
SearchData.php
[code]
<?php
session_start();
$queryStr = trim($_GET[“queryEmpID”]);
$_SESSION[’empID’] = $queryStr;
session_write_close();
header(“Location:DisplayEmpPayroll.php”);
exit();
?>
DisplayEmpPayroll.php
[code]
<?php
include ‘config.php’;
$currentEmpID = $_SESSION[’empID’];
$sql = “SELECT EMP_ID, CONCAT(LNAME, ‘, ‘ , FNAME, ‘ ‘, MI) AS FULLNAME FROM PERSONAL ORDER BY LNAME ASC”;
$recPersonalNav = $conn->GetAll($sql);
$smarty->assign(‘personalAll’, $recPersonalNav);
// ========================================================================================================================
$EMP_NO = $_POST[‘EMP_NO’];
$sql = “SELECT em.EMP_NO, p.EMP_ID, CONCAT(LNAME, ‘, ‘, FNAME, ‘ ‘, MI, ‘.’) AS FULLNAME FROM PERSONAL p, EMPLOYMENT em WHERE p.EMP_ID=’$currentEmpID’ AND em.EMP_ID = ‘$currentEmpID'”;
$recPersonalHead = $conn->Execute($sql);
$fullName = $recPersonalHead->fields[“FULLNAME”];
$empno = $recPersonalHead->fields[“EMP_NO”];
$smarty->assign(’empid’, $currentEmpID);
$smarty->assign(‘fullname’, $fullName);
$smarty->assign(’empno’, $empno);
$sql = “SELECT EMP_ID, RATE FROM wage WHERE EMP_ID = ‘$currentEmpID'”;
$rsWage = $conn->Execute($sql);
$Rate = $rsWage->fields[‘RATE’];
$sql = “SELECT EMP_ID,EMP_NO, STATUS FROM employment WHERE EMP_ID = ‘$currentEmpID'”;
$rsStatus = $conn->Execute($sql);
$STATUS = $rsStatus->fields[‘STATUS’];
$EMP_ID = $rsStatus->fields[‘EMP_ID’];
if ($STATUS == ‘Regular’){
$sql = “SELECT em.EMP_NO, em.STATUS, w.RATE, r.Hours FROM $ADODB_DB.wage w, $ADODB_DB.employment em, $PAYROLL.regular_sum_hours r WHERE em.EMP_NO = r.EMP_NO AND w.EMP_ID = ‘$currentEmpID’ AND em.EMP_ID = ‘$currentEmpID’ GROUP BY r.EMP_NO”;
$RsEarnings = $conn2->Execute($sql);
$Rate = $RsEarnings->fields[‘RATE’];
$Hours = $RsEarnings->fields[‘Hours’];
$Hours = substr($Hours, 0, 5);
$Hours = str_replace(‘:’, ‘.’, $Hours);
$Amount = $_POST[“Amount”];
$Amount = round(($Hours/8)* $Rate, 2);
}
elseif($STATUS == ‘Casual’){
$sql = “SELECT em.EMP_NO, em.STATUS, w.RATE, c.Casual_Hours FROM $ADODB_DB.wage w, $ADODB_DB.employment em, $PAYROLL.casual_hours c WHERE em.EMP_NO = c.EMP_NO AND w.EMP_ID = ‘$currentEmpID’ AND em.EMP_ID = ‘$currentEmpID’ GROUP BY c.EMP_NO”;
$RsEarnings = $conn2->Execute($sql);
$Rate = $RsEarnings->fields[‘RATE’];
$Hours = $RsEarnings->fields[‘Casual_Hours’];
$Hours = substr($Hours, 0, 5);
$Hours = str_replace(‘:’, ‘.’, $Hours);
$Amount = $_POST[“Amount”];
$Amount = round(($Hours/8)* $Rate, 2);
}
else{
$Hours = (’00:00′);
$Amount = (0);
}
$smarty->assign(‘Rate’, $Rate);
$smarty->assign(‘Hours’, $Hours);
$smarty->assign(‘Amount’, $Amount);
$smarty->display(‘header.tpl’);
$smarty->display(‘left.tpl’);
$smarty->display(’empPayrollData.tpl’);
$smarty->display(‘footer.tpl’);
I don’t know how can i insert my code in saving in choosing the employee name and then it will save data when i choose another employee name.
Any help is highly appreciated..
I attach the sample image of my webpage for further understanding.
Thank you so much