当前位置: 首页>>代码示例>>PHP>>正文


PHP GetConnectionOptions函数代码示例

本文整理汇总了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);
 }
开发者ID:howareyoucolin,项目名称:demo,代码行数:28,代码来源:zzz.php

示例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);
 }
开发者ID:Kenovix,项目名称:san-miguel,代码行数:34,代码来源:act_ordenes.php

示例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);
 }
开发者ID:BCDevExchange,项目名称:WORKPLAN,代码行数:30,代码来源:Project_Time_Line.php

示例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);
 }
开发者ID:blakeHelm,项目名称:BallotPath,代码行数:32,代码来源:public.office.php

示例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);
 }
开发者ID:BCDevExchange,项目名称:WORKPLAN,代码行数:30,代码来源:taskview.php

示例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);
 }
开发者ID:jorgedison,项目名称:Audit-Database,代码行数:34,代码来源:Detalle+Objetos.php

示例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);
 }
开发者ID:CivicInfoBC,项目名称:workplan.gov_ver_1.19,代码行数:27,代码来源:Hours_per_project.php

示例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);
 }
开发者ID:CivicInfoBC,项目名称:workplan.gov_ver_1.19,代码行数:32,代码来源:total_allocated_hours_small.php

示例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);
 }
开发者ID:Kenovix,项目名称:san-miguel,代码行数:28,代码来源:empresa.php

示例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);
 }
开发者ID:CivicInfoBC,项目名称:workplan.gov_ver_1.19,代码行数:33,代码来源:Total_hrs_Estimated_Hrs.php

示例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);
 }
开发者ID:BCDevExchange,项目名称:WORKPLAN,代码行数:31,代码来源:staff.php

示例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);
 }
开发者ID:kcallow,项目名称:MatchMe,代码行数:29,代码来源:GE.webreports.php

示例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);
 }
开发者ID:CivicInfoBC,项目名称:workplan.gov_ver_1.19,代码行数:26,代码来源:Actual_Hours.php

示例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);
 }
开发者ID:kcallow,项目名称:MatchMe,代码行数:27,代码来源:GE.webreport_style.php

示例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);
 }
开发者ID:Kenovix,项目名称:san-miguel,代码行数:25,代码来源:kardexmercancias.php


注:本文中的GetConnectionOptions函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。