PHP get_salary_elements_array Examples

Example #1

File: enter_personal_salary.php Project: k9ert/ac4ngos

	    <?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

Example #2

File: list_personal_salary.php Project: k9ert/ac4ngos

<?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;