public function action_employee()
{
$statuses = array('0option' => array('@value' => 'active', '$content' => 'Active'), '1option' => array('@value' => 'inactive', '$content' => 'Inactive'));
xml::to_XML($statuses, $this->xml_content->appendChild($this->dom->createElement('statuses')));
if (isset($_GET['id'])) {
$employee = new Employee($_GET['id']);
if (count($_POST)) {
$post = new Validation($_POST);
$post->filter('trim');
$employee->set($post->as_array());
$this->add_message('Employee ' . $_GET['id'] . ' information updated');
}
$this->set_formdata($employee->get());
xml::to_XML(array('statuses' => array('1option' => array('@value' => 'active', 'Active'), '2option' => array('@value' => 'inactive', 'Inactive'))), $this->xml_content);
xml::to_XML($employee->get(), $this->xml_content->appendChild($this->dom->createElement('employee')), NULL, 'id');
} elseif (count($_POST)) {
$post = new Validation($_POST);
$post->filter('trim');
$employee_id = Employee::new_employee($post->as_array());
$this->add_message($post->get('firstname') . ' (ID: ' . $employee_id . ') was added as employee');
} else {
$this->redirect();
}
}
public function action_index()
{
// Set the name of the template to use
$this->xslt_stylesheet = 'payslip';
if (!isset($_GET['employee_id']) || !isset($_GET['period']) || !preg_match('/^\\d{4}-\\d{1,2}$/', $_GET['period'])) {
throw new Kohana_exception('Invalid parameters');
}
$employee = new Employee($_GET['employee_id']);
xml::to_XML($employee->get(), $this->xml_content->appendChild($this->dom->createElement('employee')), NULL, 'id');
$where = '
employee_id = ' . intval($_GET['employee_id']) . ' AND
(
description = \'Social fees period ' . $_GET['period'] . '\' OR
description = \'Income taxes period ' . $_GET['period'] . '\' OR
(
description = \'Salary payout\' AND
MONTH(transfer_date) = ' . substr($_GET['period'], 5) . ' AND
YEAR(transfer_date) = ' . substr($_GET['period'], 0, 4) . '
)
)';
xml::to_XML(Transactions::get(NULL, 'accounting_date', $where), $this->xml_content->appendChild($this->dom->createElement('transactions')), 'transaction', 'id');
}
public function editEmployee()
{
$id = Input::get('editEmpID');
$employee = Employee::find($id);
$emp = Employee::get();
$isAdded = FALSE;
$validInput = TRUE;
$regex = "/^[a-zA-Z\\'\\-\\.]+( [a-zA-Z\\'\\-\\.]+)*\$/";
$regexHouse = "/[0-9a-zA-Z\\-\\s]+\$/";
$regexStreet = "/^[a-zA-Z0-9\\'\\-\\.]+( [a-zA-Z0-9\\'\\-\\.]+)*\$/";
$regexBarangay = "/^[a-zA-Z0-9\\'\\-\\.]+( [a-zA-Z0-9\\'\\-\\.]+)*\$/";
$regexCity = "/^[a-zA-Z\\'\\-]+( [a-zA-Z\\'\\-]+)*\$/";
$regexZip = "/^[0-9]+\$/";
$regexProvince = "/^[a-zA-Z\\'\\-]+( [a-zA-Z\\'\\-]+)*\$/";
if (!trim(Input::get('editFirstName')) == '' && !trim(Input::get('editLastName')) == '' && !trim(Input::get('editEmpHouseNo')) == '' && !trim(Input::get('editEmail')) == '' && !trim(Input::get('editEmpStreet')) == '' && !trim(Input::get('editEmpCity')) == '' && !trim(Input::get('editCellNo')) == '') {
$validInput = TRUE;
if (preg_match($regex, Input::get('editFirstName')) && preg_match($regex, Input::get('editLastName')) && preg_match($regexStreet, Input::get('editEmpStreet')) && !!filter_var(Input::get('editEmail'), FILTER_VALIDATE_EMAIL) && preg_match($regexHouse, Input::get('editEmpHouseNo')) && preg_match($regexCity, Input::get('editEmpCity'))) {
$validInput = TRUE;
if (!trim(Input::get('editEmpZipCode')) == '' || !trim(Input::get('editEmpProvince')) == '' || !trim(Input::get('editEmpBarangay')) == '') {
if (preg_match($regexZip, Input::get('editEmpZipCode')) || preg_match($regexProvince, Input::get('editEmpProvince')) || preg_match($regexBarangay, Input::get('editEmpBarangay'))) {
$validInput = TRUE;
} else {
$validInput = FALSE;
}
}
} else {
$validInput = FALSE;
}
} else {
$validInput = FALSE;
}
$count = 0;
$count2 = 0;
if (!($employee->strEmailAdd == trim(Input::get('editEmail')))) {
$count = DB::table('tblEmployee')->select('tblEmployee.strEmailAdd')->where('tblEmployee.strEmailAdd', '=', trim(Input::get('editEmail')))->count();
}
if (!($employee->strCellNo == trim(Input::get('editCellNo')))) {
$count2 = DB::table('tblEmployee')->select('tblEmployee.strCellNo')->where('tblEmployee.strCellNo', '=', trim(Input::get('editCellNo')))->count();
}
if ($count > 0 || $count2 > 0) {
$isAdded = TRUE;
} else {
foreach ($emp as $emp) {
if (!strcasecmp($emp->strEmployeeID, Input::get('editEmpID')) == 0 && strcasecmp($emp->strEmpFName, trim(Input::get('editFirstName'))) == 0 && strcasecmp($emp->strEmpMName, trim(Input::get('editMiddleName'))) == 0 && strcasecmp($emp->strEmpLName, trim(Input::get('editLastName'))) == 0) {
$isAdded = TRUE;
}
}
}
if ($validInput) {
if (!$isAdded) {
$employee = Employee::find($id);
$employee->strEmpFName = trim(Input::get('editFirstName'));
$employee->strEmpLName = trim(Input::get('editLastName'));
$employee->strEmpMName = trim(Input::get('editMiddleName'));
$employee->dtEmpBday = date("Y-m-d", strtotime(Input::get("editdtEmpBday")));
$employee->strSex = Input::get('editSex');
$employee->strEmpHouseNo = trim(Input::get('editEmpHouseNo'));
$employee->strEmpStreet = trim(Input::get('editEmpStreet'));
$employee->strEmpBarangay = trim(Input::get('editEmpBarangay'));
$employee->strEmpCity = trim(Input::get('editEmpCity'));
$employee->strEmpProvince = trim(Input::get('editEmpProvince'));
$employee->strEmpZipCode = trim(Input::get('editEmpZipCode'));
$employee->strRole = Input::get('editRoles');
$employee->strCellNo = trim(Input::get('editCellNo'));
$employee->strCellNoAlt = trim(Input::get('editCellNoAlt'));
$employee->strPhoneNo = trim(Input::get('editPhoneNo'));
$employee->strEmailAdd = trim(Input::get('editEmail'));
$employee->save();
return Redirect::to('/maintenance/employee?successEdit=true');
} else {
return Redirect::to('/maintenance/employee?success=duplicate');
}
} else {
return Redirect::to('/maintenance/employee?input=invalid');
}
}
echo $sid . " : " . $seed . "<br>";
echo $hash . "<br>";
?>
<p style="font-weight: bold;">Logging in... </p><p><?php
if ($employee->isRegistered($hash)) {
if ($employee->setSessionWith($hash)) {
echo "Success";
}
}
if (!$employee->isLoggedIn($hash)) {
echo "failed";
exit;
}
?>
</p><p style="font-weight: bold;">Update my details... </p><p><?php
$old_data = $employee->get();
echo "Before...<br><br>";
echo "<pre>";
print_r($old_data);
echo "</pre><br><br>";
$data = array();
$data['password'] = md5('new_passwd');
$data['phone_num'] = '+618-8463-2238';
$data['address'] = 'Lala Land';
$data['zip'] = '1100';
$data['state'] = 'Penang';
$new_employee = array();
if ($employee->update($data)) {
$new_employee = $employee->get();
echo "<pre>";
print_r($new_employee);
require_once 'includes/session.php';
require_once 'includes/db.php';
require_once 'includes/Employee.php';
require_once 'includes/Checklist.php';
if ($_SESSION['USER_GRP'] !== 1) {
header('Location: ./');
exit;
}
if (!isset($_GET['_']) || !is_numeric($_GET['_'])) {
header('Location: ./');
exit;
}
$con = connect_db();
$employee = new Employee();
$employee->id = intval($_GET['_']);
$employee->get($con);
if ($employee->un == '') {
header('Location: ./');
exit;
}
$lists = new Checklists();
$lists->get($con);
$con->close();
?>
<!DOCTYPE html>
<html>
<head>
<title>Vehicle Checklist</title>
<meta charset="utf-8" />
public function action_index()
{
// Period-stuff (Needs to be before $_POST-handling)
$year = $start_year = $current_year = date('Y', time());
$month = $start_month = $current_month = date('m', time());
foreach (Transactions::get(array('description' => 'Salary payout')) as $transaction) {
$year = $start_year = intval(substr($transaction['accounting_date'], 0, 4));
$month = $start_month = intval(substr($transaction['accounting_date'], 5, 2));
break;
}
$periods = array();
while ($year <= $current_year && $month <= $current_month) {
if ($year > $current_year) {
break;
} elseif ($year == $current_year && $month > $current_month) {
break;
}
$periods[$year . $month . 'option'] = array('@value' => $year . '-' . $month, $year . ' ' . date('F', mktime(0, 0, 0, $month, 1)));
$month++;
if ($month > 12) {
$year++;
$month = 1;
}
}
xml::to_XML($periods, $this->xml_content->appendChild($this->dom->createElement('periods')));
if (!isset($_GET['period']) || !preg_match('/^\\d{4}-\\d{1,2}$/', $_GET['period'])) {
$_GET['period'] = $start_year . '-' . $start_month;
}
$this->set_formdata(array('period' => $_GET['period']));
// End of period-stuff
if (count($_POST)) {
// Data submitted
$post = new Validation($_POST);
$post->filter('trim');
$post_array = $post->as_array();
foreach (array_keys($post_array) as $key) {
if (substr($key, 0, 13) == 'submit_button') {
$employee_id = (int) substr($key, 14);
}
}
$transaction_data = array('accounting_date' => date('Y-m-d', time()), 'transfer_date' => date('Y-m-d', time()), 'description' => 'Social fees period ' . $_GET['period'], 'journal_id' => NULL, 'vat' => 0, 'sum' => -$post_array['social_fee_cost_' . $employee_id], 'employee_id' => $employee_id);
$soc_fee = new Transaction(NULL, $transaction_data);
$transaction_data['description'] = 'Income taxes period ' . $_GET['period'];
$transaction_data['sum'] = -$post_array['income_tax_cost_' . $employee_id];
$inc_tax = new Transaction(NULL, $transaction_data);
$this->redirect();
}
// Employees_totals
$employees = array();
$where = 'description = \'Salary payout\' AND YEAR(accounting_date) = ' . substr($_GET['period'], 0, 4) . ' AND MONTH(accounting_date) = ' . substr($_GET['period'], 5);
$transactions_this_period = Transactions::get(NULL, 'accounting_date', $where);
foreach ($transactions_this_period as $transaction) {
$employee = new Employee($transaction['employee_id']);
if (!isset($employees[$transaction['employee_id']])) {
$employees[$transaction['employee_id']] = array('payout_cost' => 0, 'soc_fee_cost' => 0, 'income_tax_cost' => 0) + $employee->get();
}
$employees[$transaction['employee_id']]['payout_cost'] -= $transaction['sum'];
@(list($accounted_income_tax) = Transactions::get(NULL, 'accounting_date', ' description = \'Income taxes period ' . $_GET['period'] . '\' AND employee_id = ' . $transaction['employee_id']));
@(list($accounted_soc_fee) = Transactions::get(NULL, 'accounting_date', ' description = \'Social fees period ' . $_GET['period'] . '\' AND employee_id = ' . $transaction['employee_id']));
if ($accounted_income_tax && $accounted_soc_fee) {
// First we check the database
$employees[$transaction['employee_id']]['income_tax_cost'] = -$accounted_income_tax['sum'];
$employees[$transaction['employee_id']]['soc_fee_cost'] = -$accounted_soc_fee['sum'];
} else {
// Nothing in database, calculate
$employees[$transaction['employee_id']]['calculated'] = array();
$employees[$transaction['employee_id']]['income_tax_cost'] -= $transaction['sum'] / (100 - $employee->get('tax_level')) * 100 - $transaction['sum'];
$employees[$transaction['employee_id']]['soc_fee_cost'] -= $transaction['sum'] / (100 - $employee->get('tax_level')) * 100 * $employee->get('soc_fee_level') / 100;
}
}
// Round employee totals
foreach ($employees as $nr => $employee) {
$employees[$nr]['income_tax_cost'] = floor($employees[$nr]['income_tax_cost']);
$employees[$nr]['soc_fee_cost'] = floor($employees[$nr]['soc_fee_cost']);
}
xml::to_XML($employees, $this->xml_content->appendChild($this->dom->createElement('employees_totals')), 'employee', 'id');
// End of Employees_totals
}
