SF.net SVN: ledger-smb:[4257] branches/1.3/LedgerSMB/OE.pm

[..hidden..]

Revision: 4257
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4257&view=rev
Author:   ehuelsmann
Date:     2012-01-08 21:16:51 +0000 (Sun, 08 Jan 2012)
Log Message:
-----------
Fix references to non-existing column 'employee_id'.

Found by Nigel Titley.

Modified Paths:
--------------
    branches/1.3/LedgerSMB/OE.pm

Modified: branches/1.3/LedgerSMB/OE.pm
===================================================================
--- branches/1.3/LedgerSMB/OE.pm	2012-01-08 21:11:30 UTC (rev 4256)
+++ branches/1.3/LedgerSMB/OE.pm	2012-01-08 21:16:51 UTC (rev 4257)
@@ -1879,7 +1879,7 @@
 				INSERT INTO inventory 
 					(parts_id, warehouse_id, qty, trans_id, 
 					orderitems_id, shippingdate, 
-					employee_id)
+					entity_id)
 				VALUES 
 					(?, ?, ?, ?, ?, ?, ?)|;
             $sth2 = $dbh->prepare($query);
@@ -2180,7 +2180,7 @@
 
     my $query = qq|
 		INSERT INTO inventory
-			(warehouse_id, parts_id, qty, shippingdate, employee_id)
+			(warehouse_id, parts_id, qty, shippingdate, entity_id)
 		VALUES (?, ?, ?, ?, ?)|;
     $sth = $dbh->prepare($query) || $form->dberror($query);
 
@@ -2486,6 +2486,7 @@
         ( $null, $department_id ) = split /--/, $form->{department};
         $department_id *= 1;
 
+
         $query = qq|
 			UPDATE oe SET
 				ordnumber = ?,
@@ -2495,7 +2496,7 @@
 				netamount = ?,
 				taxincluded = ?,
 				curr = ?,
-				employee_id = ?,
+				person_id = (select id from person where entity_id = ?),
 				department_id = ?,
 				ponumber = ?
 			WHERE id = ?|;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.