<?php echo "<td><a href='list_personal.php'>show List</a></td>"; ?> </tr> <tr> <td><hr color='black'></td> </tr> <?php endPrettyTable(); ?> </td> <td valign=top align=center width='65%'> <?php $income_salary_elements_array_desc = get_salary_elements_array("SAL_DESC", "ID_TP='I'"); $expense_salary_elements_array_desc = get_salary_elements_array("SAL_DESC", "ID_TP='E'"); $salary_elements_array_tp = get_salary_elements_array("SAL_TP"); $designation_array = get_designation_array(); openForm("editsalary", $PHP_SELF); beginPrettyTable("2", "edit Salary"); makeHiddenField("emp_id3", $emp_id3); makeHiddenField("submitnow", 0); makeStaticField("emp_name", $edit_personal["EMP_NAME"], "Employer Name"); makeStaticField("desig_desc", get_designation_of($emp_id3), "Designation"); # Income-Positions printRow(array("<div align=\"center\"><h2>INCOME</h2></div>"), "", "1,2"); foreach ($income_salary_elements_array_desc as $key => $value) { makeTextField("salary_field_" . $key, $edit_salary["{$key}"], "{$value}", 10, "onFocus=\"editIncomeField(this.value)\" onChange=\"changedIncomeField(this.value) \""); $income_sum += $edit_salary["{$key}"]; } makeStaticField("income_sum", $income_sum, "Income Sum:", "", 11); # Expense-Positions
<?php # List all Employees-salary require "accrp.php"; session_start(); require "security/secure.php"; beginDocument($lCustomerProfile, $sess_user); $db = getDBConnection(); $sal_el_array = get_salary_elements_array(); $sal_el_count = get_salary_elements_count(); reset($sal_el_array); $personal_array = get_personal_array(); beginPrettyTable("5", "PERSONAL SALARY"); #$header["EMP_ID3"] = "ID"; #$header["EMP_NAME"] = "NAME"; $query = "select * FROM PERSONAL LEFT JOIN EMP_SAL USING (EMP_ID3) ORDER BY EMP_SAL.EMP_ID3, EMP_SAL.SAL_ID"; $result = mysql_query($query, $db); $printrow = array(); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { if (!isset($emp_name)) { $emp_name = $row["EMP_NAME"]; } # ToDo: should get treated as well #if ($row["SAL_ID"]==NULL) { # #continue; # for ($i=0;$i<14;$i++) $printrow[]="0"; # printRow($printrow); # reset($sal_el_array); # unSet($printrow); # # continue;