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'); }