public function getListEmployee($period_id)
{
include_once '../hr/class/Leave.php';
$leave = new Leave();
$login_user = $leave->getEmployeeId($this->updatedby);
if ($login_user > 0 && $this->isAdmin == false) {
$wherestr = " and em.employee_id = {$login_user} ";
}
$sql = "select em.*,dp.department_name,py.payslip_id,py.iscomplete,py.batch_id,py.netpayamt\r\n from {$this->tableemployee} em\r\n inner join {$this->tabledepartment} dp on dp.department_id = em.department_id\r\n left join {$this->tablepayslip} py on py.employee_id = em.employee_id and py.period_id = {$period_id}\r\n where em.employee_id > 0 and em.isactive = 1\r\n {$wherestr}\r\n group by em.employee_id \r\n order by cast(em.employee_no as signed) asc";
echo <<<EOF
<table >
<tr>
<th align="center">No</th>
<th align="center">Employee</th>
<th align="center">Employee No</th>
<th align="center">Ic No</th>
<th align="center">Department</th>
<th align="center">Amount (RM)</th>
<th align="center">Complete</th>
<th align="center">Operation</th>
</tr>
EOF;
$query = $this->xoopsDB->query($sql);
$rowtype = 0;
$i = 0;
while ($row = $this->xoopsDB->fetchArray($query)) {
$i++;
//cater for Report No: 184
$new_emp = "select count(*) as cnt from {$this->tablepayslip} where employee_id={$row['employee_id']}";
$emp_q = $this->xoopsDB->query($new_emp);
$p = $this->xoopsDB->fetchArray($emp_q);
if ($p[cnt] <= 0) {
$img = "<img src='images/new.gif' width='35' height='15'>";
} else {
$img = "";
}
$employee_id = $row['employee_id'];
$employee_name = $row['employee_name'] . " " . $img;
$employee_no = $row['employee_no'];
$employee_newicno = $row['employee_newicno'];
$department_name = $row['department_name'];
$payslip_id = $row['payslip_id'];
$iscomplete = $row['iscomplete'];
$batch_id = $row['batch_id'];
$netpayamt = $row['netpayamt'];
if ($rowtype == "even") {
$rowtype = "odd";
} else {
$rowtype = "even";
}
if ($login_user > 0 && $this->isAdmin == false) {
if ($iscomplete == "Y") {
$buttonopr = "<a href='printpayslip.php?payslip_id={$payslip_id}' target='blank'><img src='images/list.gif' title='View This Payslip'></a>";
}
} else {
if ($payslip_id <= 0) {
$rowtype = "vfocus";
$buttonopr = "<form action='payslip.php' method='POST' target='_blank'>\r\n <input type='hidden' name='action' value='processgenerate'>\r\n <input type='hidden' name='period_id' value='{$period_id}'>\r\n <input type='hidden' name='employee_id' value='{$employee_id}'>\r\n <input type='submit' value='Generate Payslip'>\r\n </form>";
} else {
if ($iscomplete == "N") {
$buttonopr = "<form action='payslip.php' method='POST' target='_blank'>\r\n <input type='hidden' name='action' value='edit'>\r\n <input type='hidden' name='payslip_id' value='{$payslip_id}'>\r\n <input type='hidden' name='employee_id' value='{$employee_id}'>\r\n <input type='submit' value='Edit Payslip'>\r\n </form>";
} else {
$buttonopr = "<form action='payslip.php' method='POST' target='_blank'>\r\n <input type='hidden' name='action' value='enable'>\r\n <input type='hidden' name='payslip_id' value='{$payslip_id}'>\r\n <input type='hidden' value='{$batch_id}' name='batch_id'>\r\n <input type='submit' value='Enable Payslip'>\r\n <a href='printpayslip.php?payslip_id={$payslip_id}' target='blank'><img src='images/list.gif' title='View This Payslip'></a>\r\n </form>";
}
}
}
if ($iscomplete == "Y") {
$iscompletename = "Y";
} else {
$iscomplete = "<font color=red><b>N</b></font>";
}
echo <<<EOF
<tr>
<td class="{$rowtype}" align="center">{$i}</td>
<td class="{$rowtype}" align="left"><a href="../simbiz/employee.php?action=view&employee_id={$employee_id}">{$employee_name}</a></td>
<td class="{$rowtype}" align="center">{$employee_no}</td>
<td class="{$rowtype}" align="center">{$employee_newicno}</td>
<td class="{$rowtype}" align="center">{$department_name}</td>
<td class="{$rowtype}" align="center">{$netpayamt}</td>
<td class="{$rowtype}" align="center">{$iscomplete}</td>
<td class="{$rowtype}" align="center">{$buttonopr}</td>
</tr>
EOF;
}
echo <<<EOF
</table>
EOF;
}
