StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POAm I doing Doctrine subclasses correctly? Why the Error?
primarykey
Id
1228308
data
AcceptedAnswerId
1228498
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-08-04T15:49:54.987
FavoriteCount
0
LastActivityDate
2009-08-04T17:57:15.760
LastEditDate
2009-08-04T15:55:07.987
LastEditorUserId
133935
OwnerUserId
133935
ParentId
0
PostTypeId
1
Score
0
ViewCount
2104
LastEditorDisplayName
text
Body
I started to build a POS system in Doctrine. I am getting an order, but I have no clue whether or not I even set up subclasses in the proper way for Doctrine. Here is the model I came up with for line items on an order <pre><code>lineItem: line_total, order_id, type rentLineItem: returned_date_time, item_id, sold buyLineItem: item_id </code></pre> The database looks like that. Type is either a 1 (rent) or a 2 (buy) Here is the lineItem class <pre><code>class lineItem extends Doctrine_Record { public function setTableDefinition() { $this->hasColumn('line_total','int'); $this->hasColumn('order_id','int'); $this->setSubclasses(array( 'rentLineItem' => array('type' => 1), 'buyLineItem' => array('type' => 2), ) ); } public function setUp() { $this->hasOne('order', array('local' => 'order_id', 'foreign' => 'id')); } } </code></pre> Here is the rentLineItem class (buyLineItem looks similar) <pre><code>class rentLineItem extends lineItem { public function setTableDefinition() { $this->hasColumn('returned_date_time','datetime'); $this->hasColumn('sold','tinyint', 2); // just in case it is sold at the end of the rental $this->hasColumn('item_id','int'); } public function setUp() { $this->hasOne('item', array('local' => 'item_id', 'foreign' => 'id')); } } </code></pre> Here is the code I have calling the objects <pre><code>$q = Doctrine_Query::create() ->select('*') ->from('order') ->where('DATE(creation_date_time) = \'' . $theDate . '\''); $orders = $q->execute(); $totalRents = 0; $totalSales = 0; foreach ($orders as $order) { foreach ($order->line_items as $lineItem) { if ($lineItem->type == 1) { $totalRents++; } else if ($lineItem->type == 2) { $totalSales++; } } } </code></pre> Here is the error I am getting <pre><code>Fatal error: Uncaught exception 'Doctrine_Record_UnknownPropertyException' with message 'Unknown record property / related component "type" on "lineItem"' in /Developer/Projects/VEL/lib/vendor/doctrine/Doctrine/Record/Filter/Standard.php:55 Stack trace: #0 /Developer/Projects/VEL/lib/vendor/doctrine/Doctrine/Record.php(1296): Doctrine_Record_Filter_Standard->filterGet(Object(lLineItem), 'type') #1 /Developer/Projects/VEL/lib/vendor/doctrine/Doctrine/Record.php(1255): Doctrine_Record->_get('type', true) #2 /Developer/Projects/VEL/lib/vendor/doctrine/Doctrine/Access.php(72): Doctrine_Record->get('type') #3 /Developer/Projects/VEL/manage/manage/dailyincomeexpensereport.php(29): Doctrine_Access->__get('type') #4 {main} thrown in /Developer/Projects/VEL/lib/vendor/doctrine/Doctrine/Record/Filter/Standard.php on line 55 </code></pre>
Tags
<php><mysql><doctrine><subclass>
Title
Am I doing Doctrine subclasses correctly? Why the Error?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJustin Giboney
UserOwnerUserId
1. USJustin Giboney
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.