本文整理汇总了PHP中GetConnectionOptions函数的典型用法代码示例。如果您正苦于以下问题:PHP GetConnectionOptions函数的具体用法?PHP GetConnectionOptions怎么用?PHP GetConnectionOptions使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了GetConnectionOptions函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: DoBeforeCreate
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);
}
示例2: DoBeforeCreate
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);
}
示例3: DoBeforeCreate
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);
}
示例4: DoBeforeCreate
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);
}
示例5: DoBeforeCreate
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);
}
示例6: DoBeforeCreate
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);
}
示例7: DoBeforeCreate
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);
}
示例8: DoBeforeCreate
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);
}
示例9: DoBeforeCreate
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);
}
示例10: DoBeforeCreate
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);
}
示例11: DoBeforeCreate
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);
}
示例12: DoBeforeCreate
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);
}
示例13: DoBeforeCreate
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);
}
示例14: DoBeforeCreate
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);
}
示例15: DoBeforeCreate
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);
}