From 91c7ac3db95a85457522e26eb70ffd1e75ec8c16 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Thu, 8 Mar 2007 19:18:07 +0000
Subject: Moved other .pm's from 'employee' to 'employees'

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@866 4979c152-3d1c-0410-bac9-87ea11338e46
---
 LedgerSMB/HR.pm | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)

(limited to 'LedgerSMB/HR.pm')

diff --git a/LedgerSMB/HR.pm b/LedgerSMB/HR.pm
index 186ac752..6b6b6eff 100755
--- a/LedgerSMB/HR.pm
+++ b/LedgerSMB/HR.pm
@@ -45,7 +45,7 @@ sub get_employee {
 	my $notid = "";
 
 	if ($form->{id}) {
-		$query = qq|SELECT e.* FROM employee e WHERE e.id = ?|;
+		$query = qq|SELECT e.* FROM employees e WHERE e.id = ?|;
 		$sth = $dbh->prepare($query);
 		$sth->execute($form->{id}) || $form->dberror(__FILE__.':'.__LINE__.':'.$query);
   
@@ -64,7 +64,7 @@ sub get_employee {
 		# get manager
 		$form->{managerid} *= 1;
 
-		$sth = $dbh->prepare("SELECT name FROM employee WHERE id = ?");
+		$sth = $dbh->prepare("SELECT name FROM employees WHERE id = ?");
 		$sth->execute($form->{managerid});
 		($form->{manager}) = $sth->fetchrow_array;
     
@@ -110,10 +110,10 @@ sub save_employee {
 		my $uid = localtime;
 		$uid .= "$$";
 
-		$query = qq|INSERT INTO employee (name) VALUES ('$uid')|;
+		$query = qq|INSERT INTO employees (name) VALUES ('$uid')|;
 		$dbh->do($query) || $form->dberror(__FILE__.':'.__LINE__.':'.$query);
     
-		$query = qq|SELECT id FROM employee WHERE name = '$uid'|;
+		$query = qq|SELECT id FROM employees WHERE name = '$uid'|;
 		$sth = $dbh->prepare($query);
 		$sth->execute || $form->dberror(__FILE__.':'.__LINE__.':'.$query);
 
@@ -130,7 +130,7 @@ sub save_employee {
 			if ! $form->{employeenumber};
 
 	$query = qq|
-		UPDATE employee 
+		UPDATE employees 
 		   SET employeenumber = ?,
 		       name = ?,
 		       address1 = ?,
@@ -182,7 +182,7 @@ sub delete_employee {
 	# delete employee
 	
 	my $query = qq|
-		DELETE FROM employee 
+		DELETE FROM employees 
 		      WHERE id = |.$dbh->quote($form->{id});
 	$dbh->do($query) || $form->dberror(__FILE__.':'.__LINE__.':'.$query);
 
@@ -235,8 +235,8 @@ sub employees {
 
 	my $query = qq|
 		   SELECT e.*, m.name AS manager
-		     FROM employee e
-		LEFT JOIN employee m ON (m.id = e.managerid)
+		     FROM employees e
+		LEFT JOIN employees m ON (m.id = e.managerid)
 		    WHERE $where
 		 ORDER BY $sortorder|;
 
-- 
cgit v1.2.3