public function executeUpdateTimesheetItemComment($request)
{
$this->backAction = $this->getContext()->getUser()->getFlash('actionName');
$this->getContext()->getUser()->setFlash('actionName', $this->backAction);
$timesheetId = $request->getParameter('timesheetId');
$activityId = $request->getParameter('activityId');
$projectId = $this->getProjectId($activityId);
$date = $request->getParameter('date');
$comment = $request->getParameter('comment');
$csrfToken = $request->getParameter('csrfToken');
$form = new TimesheetFormToImplementCsrfTokens();
if ($form->getCSRFToken() != $csrfToken) {
return sfView::NONE;
}
$employeeId = $request->getParameter('employeeId');
$dao = new TimesheetDao();
$timesheetItem = $dao->getTimesheetItemByDateProjectId($timesheetId, $employeeId, $projectId, $activityId, $date);
if ($timesheetItem[0]->getTimesheetItemId() == null) {
$newTimesheetItem = new TimesheetItem();
$newTimesheetItem->setTimesheetId($timesheetId);
$newTimesheetItem->setDate($date);
$newTimesheetItem->setComment(trim($comment));
$newTimesheetItem->setProjectId($projectId);
$newTimesheetItem->setEmployeeId($employeeId);
$newTimesheetItem->setActivityId($activityId);
$resultItem = $dao->saveTimesheetItem($newTimesheetItem);
} else {
$timesheetItem[0]->setComment(trim($comment));
$resultItem = $dao->saveTimesheetItem($timesheetItem[0]);
}
return $this->renderText($resultItem->getTimesheetItemId());
}
public function executeUpdateTimesheetItemComment($request)
{
$this->backAction = $this->getContext()->getUser()->getFlash('actionName');
$this->getContext()->getUser()->setFlash('actionName', $this->backAction);
$timesheetId = $request->getParameter('timesheetId');
$activityId = $request->getParameter('activityId');
$projectId = $this->getProjectId($activityId);
$date = $request->getParameter('date');
$comment = $request->getParameter('comment');
$employeeId = $request->getParameter('employeeId');
$dao = new TimesheetDao();
$timesheetItem = $dao->getTimesheetItemByDateProjectId($timesheetId, $employeeId, $projectId, $activityId, $date);
if ($timesheetItem[0]->getTimesheetItemId() == null) {
$newTimesheetItem = new TimesheetItem();
$newTimesheetItem->setTimesheetId($timesheetId);
$newTimesheetItem->setDate($date);
$newTimesheetItem->setComment(trim($comment));
$newTimesheetItem->setProjectId($projectId);
$newTimesheetItem->setEmployeeId($employeeId);
$newTimesheetItem->setActivityId($activityId);
$dao->saveTimesheetItem($newTimesheetItem);
} else {
$timesheetItem[0]->setComment(trim($comment));
$dao->saveTimesheetItem($timesheetItem[0]);
}
}
/**
* Testing saveTimesheetItem method for the newly made timesheet Items
*/
public function testSaveTimesheetItemWithNewTimesheetItem()
{
TestDataService::truncateTables(array('TimesheetItem'));
$timesheetItem = new TimesheetItem();
$timesheetItem->setTimesheetId(1);
$timesheetItem->setDate("2011-04-23");
$timesheetItem->setDuration("5700");
$timesheetItem->setComment("New Timesheet Item");
$timesheetItem->setProjectId(1);
$timesheetItem->setEmployeeId(1);
$timesheetItem->setActivityId(4);
$savedNewTimesheetItem = $this->timesheetDao->saveTimesheetItem($timesheetItem);
$this->assertTrue($savedNewTimesheetItem instanceof TimesheetItem);
$this->assertEquals('001', $savedNewTimesheetItem->getTimesheetItemId());
$this->assertEquals($timesheetItem->getTimesheetId(), $savedNewTimesheetItem->getTimesheetId());
$this->assertEquals($timesheetItem->getDate(), $savedNewTimesheetItem->getDate());
$this->assertEquals($timesheetItem->getDuration(), $savedNewTimesheetItem->getDuration());
$this->assertEquals($timesheetItem->getComment(), $savedNewTimesheetItem->getComment());
$this->assertEquals($timesheetItem->getProjectId(), $savedNewTimesheetItem->getProjectId());
$this->assertEquals($timesheetItem->getEmployeeId(), $savedNewTimesheetItem->getEmployeeId());
$this->assertEquals($timesheetItem->getActivityId(), $savedNewTimesheetItem->getActivityId());
}
