protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_lectura"');
$field = new IntegerField('id_lectura', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('id_persona');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('id_lugar');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('id_origen_lectura');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new DateTimeField('fe_fecha_lectura');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('no_usuario');
$this->dataset->AddField($field, false);
$field = new StringField('ds_usuario');
$this->dataset->AddField($field, false);
$field = new IntegerField('co_lector');
$this->dataset->AddField($field, false);
$field = new StringField('ds_observaciones');
$this->dataset->AddField($field, false);
$field = new IntegerField('id_carga');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$this->dataset->AddLookupField('id_persona', 'public.ods_persona', new IntegerField('id_persona', null, null, true), new IntegerField('id_tipo_persona', 'id_persona_id_tipo_persona', 'id_persona_id_tipo_persona_public_ods_persona'), 'id_persona_id_tipo_persona_public_ods_persona');
$this->dataset->AddLookupField('id_lugar', 'public.ods_lugar', new IntegerField('id_lugar', null, null, true), new StringField('co_lugar', 'id_lugar_co_lugar', 'id_lugar_co_lugar_public_ods_lugar'), 'id_lugar_co_lugar_public_ods_lugar');
$this->dataset->AddLookupField('id_origen_lectura', 'public.ods_origen_lectura', new IntegerField('id_origen_lectura'), new StringField('co_origen_lectura', 'id_origen_lectura_co_origen_lectura', 'id_origen_lectura_co_origen_lectura_public_ods_origen_lectura'), 'id_origen_lectura_co_origen_lectura_public_ods_origen_lectura');
}
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()
{
$this->dataset = new TableDataset(new SqlSrvConnectionFactory(), GetConnectionOptions(), '[dbo].[procesosbd]');
$field = new IntegerField('Process ID');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('HostName');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('User');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Database');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Query');
$this->dataset->AddField($field, true);
$field = new StringField('Status');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('Open Transactions');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Command');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('ApplicatiON');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('Wait Time');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Wait Type');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('CPU');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('Physical IO');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('Memory Usage');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new DateTimeField('Login Time');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new DateTimeField('Last Batch');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('Blocked By');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Blocked By Query');
$this->dataset->AddField($field, true);
$field = new IntegerField('Blocking');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`pay_period`');
$field = new IntegerField('pay_period_id', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('year');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('pay_period_number');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new DateTimeField('start_date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new DateTimeField('end_date');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
