protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`zzz`');
$field = new IntegerField('id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('TravelPlan');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('OnePerson');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('TwoPeople');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('TwoPlusChild');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('TwoPlusAdult');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('ThreePlusChild');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('ThreePlusAdult');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`act_ordenes`');
$field = new IntegerField('idAct_Ordenes', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('NumOrden');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('idAct_Movimiento');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('Fecha');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('Entrega');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('Recibe');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('Usuarios_idUsuarios');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('Origen');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('Destino');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('Cerrada');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$selectQuery = 'SELECT
`project`.`project_name`,
`project`.`date_start`,
`project`.`date_end`,
`project`.`lead`,
`project`.`progress`,
`project`.`project_id`
FROM
`project`';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Project Time Line');
$field = new StringField('project_name');
$this->dataset->AddField($field, false);
$field = new DateField('date_start');
$this->dataset->AddField($field, false);
$field = new DateField('date_end');
$this->dataset->AddField($field, false);
$field = new StringField('lead');
$this->dataset->AddField($field, false);
$field = new StringField('progress');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('project_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."office"');
$field = new IntegerField('id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('title');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('num_positions');
$this->dataset->AddField($field, false);
$field = new StringField('responsibilities');
$this->dataset->AddField($field, false);
$field = new IntegerField('term_length_months');
$this->dataset->AddField($field, false);
$field = new StringField('filing_fee');
$this->dataset->AddField($field, false);
$field = new BooleanField('partisan');
$this->dataset->AddField($field, false);
$field = new StringField('age_requirements');
$this->dataset->AddField($field, false);
$field = new StringField('res_requirements');
$this->dataset->AddField($field, false);
$field = new StringField('prof_requirements');
$this->dataset->AddField($field, false);
$field = new IntegerField('salary');
$this->dataset->AddField($field, false);
$field = new StringField('notes');
$this->dataset->AddField($field, false);
$field = new IntegerField('office_rank');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`taskview`');
$field = new IntegerField('task_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('project_id');
$this->dataset->AddField($field, true);
$field = new StringField('assigned_to');
$this->dataset->AddField($field, true);
$field = new DateField('date_start');
$this->dataset->AddField($field, true);
$field = new DateField('date_end');
$this->dataset->AddField($field, true);
$field = new StringField('task_name');
$this->dataset->AddField($field, true);
$field = new StringField('notes');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('hrs');
$this->dataset->AddField($field, true);
$field = new StringField('wo');
$this->dataset->AddField($field, true);
$field = new IntegerField('staff_id');
$this->dataset->AddField($field, true);
$field = new StringField('Task');
$this->dataset->AddField($field, false);
$field = new StringField('Assigned');
$this->dataset->AddField($field, true);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new SqlSrvConnectionFactory(), GetConnectionOptions(), '[dbo].[AlterLog]');
$field = new IntegerField('Id', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('EventType');
$this->dataset->AddField($field, false);
$field = new StringField('ObjectName');
$this->dataset->AddField($field, false);
$field = new StringField('ObjectType');
$this->dataset->AddField($field, false);
$field = new StringField('TSQLCommand');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new DateTimeField('EventTime');
$this->dataset->AddField($field, false);
$field = new StringField('LoginName');
$this->dataset->AddField($field, false);
$field = new StringField('ServerName');
$this->dataset->AddField($field, false);
$field = new StringField('DatabaseName');
$this->dataset->AddField($field, false);
$field = new StringField('SchemaName');
$this->dataset->AddField($field, false);
$field = new StringField('HostName');
$this->dataset->AddField($field, false);
$field = new StringField('IPAddress');
$this->dataset->AddField($field, false);
$field = new StringField('ProgramName');
$this->dataset->AddField($field, false);
$field = new StringField('IPAddressClient');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$selectQuery = 'SELECT SUM(ts.total_hours) AS `total_hours`,
p.`project_name`,
SUM(t.`hrs`) AS `assigned_hours`,`task_name`
FROM `task` t INNER JOIN
`project` p
ON t.`project_id` = p.`project_id` INNER JOIN
(select ts.task_id, sum(ts.hours) as total_hours
from `timesheet` ts
group by ts.task_id
) ts
ON t.`task_id` = ts.`task_id`
GROUP BY p.`project_name`';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Hours per project');
$field = new IntegerField('total_hours');
$this->dataset->AddField($field, true);
$field = new StringField('project_name');
$this->dataset->AddField($field, false);
$field = new StringField('assigned_hours');
$this->dataset->AddField($field, true);
$field = new StringField('task_name');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$selectQuery = 'SELECT DISTINCT
`task`.`assigned_to`,
SUM(`task`.`hrs`) AS `total_hrs`,
`staff`.`username`,`staff`.`staff_id`
FROM
`staff`,
`task`
WHERE
`staff`.`staff_id` = `task`.`assigned_to`
GROUP BY
`staff`.`username`';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'total allocated hours small');
$field = new StringField('assigned_to');
$this->dataset->AddField($field, false);
$field = new StringField('total_hrs');
$this->dataset->AddField($field, false);
$field = new StringField('username');
$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, true);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`empresa`');
$field = new IntegerField('id', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('habilitacion');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('nit');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('nombre');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('tipo');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('direccion');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('telefono');
$this->dataset->AddField($field, false);
$field = new StringField('depto');
$this->dataset->AddField($field, false);
$field = new StringField('mupio');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$selectQuery = 'SELECT `x`.*
, SUM(`task`.`hrs`)AS `assigned_hrs`
FROM
( SELECT `staff_id`
, `name`
, SUM(`hours`) AS `actual_hours`
FROM `timesheet`
GROUP
BY `timesheet`.`staff_id`
) `x`
JOIN `task`
ON `assigned_to` = `x`.`staff_id`
GROUP
BY `staff_id`';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Total hrs Estimated Hrs');
$field = new IntegerField('staff_id');
if (!$this->GetSecurityInfo()->AdminGrant()) {
$field->SetReadOnly(true, GetApplication()->GetCurrentUserId());
}
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('name');
$this->dataset->AddField($field, false);
$field = new IntegerField('actual_hours');
$this->dataset->AddField($field, true);
$field = new StringField('assigned_hrs');
$this->dataset->AddField($field, true);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`staff`');
$field = new IntegerField('staff_id', null, null, true);
if (!$this->GetSecurityInfo()->AdminGrant()) {
$field->SetReadOnly(true, GetApplication()->GetCurrentUserId());
}
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('username');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('email');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('picture');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('password');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('dept_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('position');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('emp_number');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
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()
{
$selectQuery = 'SELECT DISTINCT
`timesheet`.`name`,
SUM(`timesheet`.`hours`) AS `total_hours`,
`project`.`project_name`,
`task`.`task_name`
FROM
`task`
INNER JOIN `project` ON (`task`.`project_id` = `project`.`project_id`)
INNER JOIN `timesheet` ON (`task`.`task_id` = `timesheet`.`task_id`)
GROUP BY
`timesheet`.`name`';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Actual Hours');
$field = new StringField('name');
$this->dataset->AddField($field, false);
$field = new IntegerField('total_hours');
$this->dataset->AddField($field, true);
$field = new StringField('project_name');
$this->dataset->AddField($field, false);
$field = new StringField('task_name');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."webreport_style"');
$field = new IntegerField('report_style_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('type');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('field');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('group');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new BlobField('style_str');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('uniq');
$this->dataset->AddField($field, false);
$field = new StringField('repname');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('styletype');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`kardexmercancias`');
$field = new IntegerField('idKardexMercancias', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Fecha');
$this->dataset->AddField($field, false);
$field = new StringField('Movimiento');
$this->dataset->AddField($field, false);
$field = new StringField('Detalle');
$this->dataset->AddField($field, false);
$field = new StringField('idDocumento');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('Cantidad');
$this->dataset->AddField($field, false);
$field = new StringField('ValorUnitario');
$this->dataset->AddField($field, false);
$field = new StringField('ValorTotal');
$this->dataset->AddField($field, false);
$field = new IntegerField('ProductosVenta_idProductosVenta');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MySqlIConnectionFactory(), GetConnectionOptions(), '`objeto_refactorizacion`');
$field = new IntegerField('id', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('id_paquete');
$this->dataset->AddField($field, false);
$field = new StringField('ruta');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('nombre');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('tipo');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('aplicacion');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('nuevo');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('id_noconforme');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`listino_voci`');
$field = new IntegerField('id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('ivo-codart');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('ivo-codvoc');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('ivo-przunit');
$this->dataset->AddField($field, false);
$field = new StringField('ivo-flagart');
$this->dataset->AddField($field, false);
$field = new StringField('ivo-flagsmu');
$this->dataset->AddField($field, false);
$field = new StringField('ivo-tiposmu');
$this->dataset->AddField($field, false);
$field = new DateTimeField('ivo-dataini');
$this->dataset->AddField($field, false);
$field = new DateTimeField('ivo-datafin');
$this->dataset->AddField($field, false);
$field = new DateTimeField('datains');
$this->dataset->AddField($field, false);
$field = new DateTimeField('datamod');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$selectQuery = 'SELECT `timesheet`.`name`,`timesheet`.`staff_id`,
SUM(`timesheet`.`hours`) AS `total_hours`,
`project`.`project_name`,
`task`.`task_name`,
SUM(`task`.`hrs`) AS `assigned_hours`
FROM
`task`
INNER JOIN `project` ON (`task`.`project_id` = `project`.`project_id`)
INNER JOIN `timesheet` ON (`task`.`task_id` = `timesheet`.`task_id`)
GROUP BY
`timesheet`.`name`,`project`.`project_name`';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Hours per Project by user');
$field = new StringField('name');
$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, true);
$field = new IntegerField('total_hours');
$this->dataset->AddField($field, false);
$field = new StringField('project_name');
$this->dataset->AddField($field, false);
$field = new StringField('task_name');
$this->dataset->AddField($field, false);
$field = new StringField('assigned_hours');
$this->dataset->AddField($field, false);
}
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()
{
$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
`project`.`project_name`,
`project`.`date_start` AS project_date_start,
`project`.`date_end` AS project_date_end,
`project`.`lead`,
`project`.`year`,
`project`.`progress`,
`project`.`project_id`,
`task`.`task_id`,
`task`.`project_id` AS task_project_id,
`task`.`assigned_to`,
`task`.`date_start` AS task_date_start,
`task`.`date_end` AS task_date_end,
`task`.`task_name`,
`task`.`staff_id`
FROM
`project`
INNER JOIN `task` ON (`project`.`project_id` = `task`.`project_id`)';
$insertQuery = array();
$updateQuery = array();
$deleteQuery = array();
$this->dataset = new QueryDataset(new MyConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'project_timeline_detail');
$field = new StringField('project_name');
$this->dataset->AddField($field, false);
$field = new DateField('project_date_start');
$this->dataset->AddField($field, false);
$field = new DateField('project_date_end');
$this->dataset->AddField($field, false);
$field = new StringField('lead');
$this->dataset->AddField($field, false);
$field = new StringField('year');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new StringField('progress');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
$field = new IntegerField('project_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('task_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('task_project_id');
$this->dataset->AddField($field, false);
$field = new StringField('assigned_to');
$this->dataset->AddField($field, false);
$field = new DateField('task_date_start');
$this->dataset->AddField($field, false);
$field = new DateField('task_date_end');
$this->dataset->AddField($field, false);
$field = new StringField('task_name');
$this->dataset->AddField($field, false);
$field = new IntegerField('staff_id');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`elenco_articoli_view`');
$field = new StringField('art-codart');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('descrizione');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`Priority`');
$field = new IntegerField('id', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Name');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`ProjectView`');
$field = new IntegerField('project_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('project_type');
$this->dataset->AddField($field, true);
$field = new StringField('project_name');
$this->dataset->AddField($field, true);
$field = new DateField('date_start');
$this->dataset->AddField($field, true);
$field = new DateField('date_end');
$this->dataset->AddField($field, true);
$field = new StringField('year');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Objective');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('priority');
$this->dataset->AddField($field, true);
$field = new StringField('project_lead');
$this->dataset->AddField($field, true);
$field = new IntegerField('approved_budget');
$this->dataset->AddField($field, true);
$field = new IntegerField('budget_spent');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('multi_year');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('public_engagement');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('level_of_service');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('approved_by_cao');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('progress');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('DEPARTMENT');
$this->dataset->AddField($field, true);
$field = new IntegerField('total_hours');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('assigned_hours');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new IntegerField('assigned_progress');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`');
$field = new IntegerField('Cod_dpto');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('Nombre');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_empresa"');
$field = new IntegerField('id_empresa', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('no_empresa');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."webreport_sql"');
$field = new IntegerField('id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('sqlname');
$this->dataset->AddField($field, false);
$field = new BlobField('sqlcontent');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MySqlIConnectionFactory(), GetConnectionOptions(), '`phpgen_users`');
$field = new IntegerField('user_id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('user_name');
$this->dataset->AddField($field, false);
$field = new StringField('user_password');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`listini`');
$field = new IntegerField('id', null, null, true);
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('codice');
$this->dataset->AddField($field, false);
$field = new StringField('descrizione');
$this->dataset->AddField($field, false);
}
protected function DoBeforeCreate()
{
$this->dataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."level"');
$field = new StringField('id');
$field->SetIsNotNull(true);
$this->dataset->AddField($field, true);
$field = new StringField('name');
$this->dataset->AddField($field, false);
$field = new IntegerField('rank');
$this->dataset->AddField($field, false);
}