protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."EVENTO"');
$field = new IntegerField('EVENTO_ID');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('NOMBRE');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new DateField('FECHA_HORA');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('LUGAR');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('DESCRIPCION');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new DateField('FEC_CREACION');
$this->dataset->AddField($field, false);
$field = new StringField('USUARIO_CREACION');
$this->dataset->AddField($field, false);
$field = new DateField('FEC_ULTIMA_MOD');
$this->dataset->AddField($field, false);
$field = new StringField('USUARIO_ULTIMA_MOD');
$this->dataset->AddField($field, false);
$field = new IntegerField('CIUDAD');
$this->dataset->AddField($field, false);
$this->dataset->AddLookupField('CIUDAD', 'GE.CIUDAD', new IntegerField('CIUDAD_ID'), new StringField('NOMBRE', 'LA1', 'LT1'), 'LT1');
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."webreports"');
$field = new IntegerField('rpt_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('rpt_name');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('rpt_title');
$this->dataset->AddField($field, false);
$field = new DateField('rpt_cdate');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new DateField('rpt_mdate');
$this->dataset->AddField($field, false);
$field = new BlobField('rpt_content');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('rpt_owner');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('rpt_status');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('rpt_type');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`timesheet`');
$field = new IntegerField('timesheet_id', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('name');
$this->dataset->AddField($field, false);
$field = new IntegerField('task_id');
$this->dataset->AddField($field, false);
$field = new StringField('hours');
$this->dataset->AddField($field, false);
$field = new StringField('notes');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('time_type');
$this->dataset->AddField($field, false);
$field = new DateField('date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('staff_id');
if (!$this->GetSecurityInfo()->AdminGrant()) {
$field->SetReadOnly(true, GetApplication()->GetCurrentUserId());
}
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$this->dataset->AddLookupField('task_id', 'task', new IntegerField('task_id', null, null, true), new StringField('task_name', 'task_id_task_name', 'task_id_task_name_task'), 'task_id_task_name_task');
}
protected function DoBeforeCreate()
{
$selectQuery = 'SELECT task.task_name,
project.project_name,
timesheet.name,
timesheet.date,
timesheet.hours,
timesheet.staff_id,
pay_period.start_date,
pay_period.end_date,
pay_period.pay_period_number,
pay_period.YEAR,
staff.position,
staff.emp_number
FROM timesheet
LEFT JOIN task ON timesheet.task_id = task.task_id
LEFT JOIN project ON task.project_id = project.project_id
LEFT JOIN staff ON timesheet.staff_id = staff.staff_id
LEFT JOIN pay_period ON timesheet.date BETWEEN pay_period.start_date AND pay_period.end_date';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'View Pay Period');
$field = new StringField('task_name');
$this->dataset->AddField($field, false);
$field = new StringField('project_name');
$this->dataset->AddField($field, false);
$field = new StringField('name');
$this->dataset->AddField($field, false);
$field = new DateField('date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('hours');
$this->dataset->AddField($field, true);
$field = new IntegerField('staff_id');
if (!$this->GetSecurityInfo()->AdminGrant()) {
$field->SetReadOnly(true, GetApplication()->GetCurrentUserId());
}
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new DateTimeField('start_date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new DateTimeField('end_date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('pay_period_number');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('YEAR');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('position');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('emp_number');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
}
protected function DoBeforeCreate()
{
$selectQuery = 'SELECT
`timesheet`.`timesheet_id`,
`timesheet`.`name`,
`timesheet`.`task_id`,
SUM(`timesheet`.`hours`) AS `total_hours`,
`timesheet`.`notes`,
`timesheet`.`date`,
`timesheet`.`staff_id`,
`timesheet`.`hours`
FROM
`timesheet`
WHERE
`timesheet`.`date` >= DATE_SUB(CURDATE(), INTERVAL 14 DAY)
GROUP BY
`timesheet`.`timesheet_id`,
`timesheet`.`name`,
`timesheet`.`task_id`,
`timesheet`.`notes`,
`timesheet`.`date`,
`timesheet`.`staff_id`,
`timesheet`.`hours`';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Pay Period');
$field = new IntegerField('timesheet_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('name');
$this->dataset->AddField($field, false);
$field = new IntegerField('task_id');
$this->dataset->AddField($field, false);
$field = new IntegerField('total_hours');
$this->dataset->AddField($field, false);
$field = new StringField('notes');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new DateField('date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('staff_id');
if (!$this->GetSecurityInfo()->AdminGrant()) {
$field->SetReadOnly(true, GetApplication()->GetCurrentUserId());
}
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('hours');
$this->dataset->AddField($field, false);
$this->dataset->AddLookupField('task_id', 'task', new IntegerField('task_id', null, null, true), new StringField('task_name', 'task_id_task_name', 'task_id_task_name_task'), 'task_id_task_name_task');
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."WINK"');
$field = new DateField('FEC_WINK');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('USERNAME_EMISOR');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('USERNAME_RECEPTOR');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new DateField('FEC_CREACION');
$this->dataset->AddField($field, false);
$field = new StringField('USUARIO_CREACION');
$this->dataset->AddField($field, false);
$field = new DateField('FEC_ULTIMA_MOD');
$this->dataset->AddField($field, false);
$field = new StringField('USUARIO_ULTIMA_MOD');
$this->dataset->AddField($field, false);
$this->dataset->AddLookupField('USERNAME_EMISOR', 'GE.PERSONA', new StringField('USERNAME'), new StringField('ES_ADMIN', 'LA1', 'LT1'), 'LT1');
$this->dataset->AddLookupField('USERNAME_RECEPTOR', 'GE.PERSONA', new StringField('USERNAME'), new StringField('ES_ADMIN', 'LA2', 'LT2'), 'LT2');
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new SqlSrvConnectionFactory(), GetConnectionOptions(), '[dbo].[TamanoBaseDatos]');
$field = new StringField('Host');
$this->dataset->AddField($field, true);
$field = new DateField('Fecha');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Nombre');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('TamanobdMB');
$this->dataset->AddField($field, true);
$field = new IntegerField('LogbdMB');
$this->dataset->AddField($field, true);
$field = new IntegerField('TotalbdMB');
$this->dataset->AddField($field, true);
$field = new IntegerField('TamanobdGB');
$this->dataset->AddField($field, true);
$field = new IntegerField('LogbdGB');
$this->dataset->AddField($field, true);
$field = new IntegerField('TotalbdGB');
$this->dataset->AddField($field, true);
}
protected function DoBeforeCreate()
{
$selectQuery = 'SELECT * FROM timesheet
ORDER BY date DESC';
$insertQuery = array('INSERT INTO timesheet (name,task_id,hours,notes,date,staff_id)
VALUES(:name,:task_id,:hours,:notes,:date,
(SELECT staff_id FROM staff WHERE username=:name))');
$updateQuery = array('UPDATE timesheet
SET task_id=:task_id,hours=:hours,notes=:notes,date=:date,staff_id=:staff_id
WHERE timesheet_id=:timesheet_id');
$deleteQuery = array('DELETE FROM timesheet
WHERE timesheet_id=:timesheet_id');
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Multiple Time Entry');
$field = new IntegerField('timesheet_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('name');
$this->dataset->AddField($field, false);
$field = new IntegerField('task_id');
$this->dataset->AddField($field, false);
$field = new StringField('hours');
$this->dataset->AddField($field, false);
$field = new StringField('notes');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('time_type');
$this->dataset->AddField($field, false);
$field = new DateField('date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('staff_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$this->dataset->AddLookupField('task_id', 'taskview', new IntegerField('task_id'), new StringField('Task', 'task_id_Task', 'task_id_Task_taskview'), 'task_id_Task_taskview');
$this->dataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), 'name=\'%CURRENT_USER_NAME%\' AND date> DATE_ADD(Now(),INTERVAL -7 DAY)'));
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`timesheet`');
$field = new IntegerField('timesheet_id', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('name');
$this->dataset->AddField($field, false);
$field = new IntegerField('task_id');
$this->dataset->AddField($field, false);
$field = new StringField('hours');
$this->dataset->AddField($field, false);
$field = new StringField('notes');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('time_type');
$this->dataset->AddField($field, false);
$field = new DateField('date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('staff_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$this->dataset->AddLookupField('task_id', 'task', new IntegerField('task_id', null, null, true), new StringField('task_name', 'task_id_task_name', 'task_id_task_name_task'), 'task_id_task_name_task');
}
