given the follwing (partial) schema...
<table name="Consumer" skipSql="null" abstract="null">
<column name="id" autoIncrement="true" type="INTEGER"
required="true" primaryKey="true" autoincrement="true" />
<column name="first_name" type="VARCHAR" size="255" />
<column name="last_name" type="VARCHAR" size="255" />
....
</table>
<table name="Activity" skipSql="null" abstract="null">
<column name="id" autoIncrement="true" type="INTEGER"
required="true" primaryKey="true" autoincrement="true" />
<column name="activitytype_id" type="INTEGER" />
<foreign-key foreignTable="ActivityType" onDelete="none"
onUpdate="none">
<reference local="activitytype_id" foreign="id" />
</foreign-key>
<column name="day" type="INTEGER" />
<column name="hours" type="FLOAT" />
<column name="log_id" type="INTEGER" />
<foreign-key foreignTable="Activitylog">
<reference local="log_id" foreign="id" />
</foreign-key>
</table>
<table name="Activitylog" skipSql="null" abstract="null">
<column name="id" autoIncrement="true" type="INTEGER"
required="true" />
<column name="consumer_id" primaryKey="true" type="INTEGER" />
<foreign-key foreignTable="Consumer">
<reference local="consumer_id" foreign="id" />
</foreign-key>
<column name="staff_id" primaryKey="true" type="INTEGER" />
<foreign-key foreignTable="Contact" onDelete="none"
onUpdate="none">
<reference local="staff_id" foreign="id" />
</foreign-key>
<column name="startdate" primaryKey="true" type="DATE" />
</table>
I have in Consumer.php
public function getActivitylogsformonth($year = '2008')
{
$criteria = new Criteria();
$criteria->add(ActivitylogPeer::STARTDATE,
sfTime::firstDayOfMonth(mktime(0,0,0, $this->month,1,$year)),
Criteria::GREATER_THAN);
$criteria->addAnd(ActivitylogPeer::STARTDATE,
sfTime::finalDayOfMonth(mktime(0,0,0,$this->month,1,$year)),
Criteria::LESS_THAN);
$criteria->addAscendingOrderByColumn(ActivitylogPeer::STARTDATE);
return parent::getActivitylogs($criteria);
}
but I need it to be an object, so that I can do $consumer-
>getActivitylogsformonth()->getActivitys()
Any pointers
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
