PHP DateField::SetIsNotNull方法代码示例

本文整理汇总了PHP中DateField::SetIsNotNull方法的典型用法代码示例。如果您正苦于以下问题：PHP DateField::SetIsNotNull方法的具体用法？PHP DateField::SetIsNotNull怎么用？PHP DateField::SetIsNotNull使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DateField的用法示例。

在下文中一共展示了DateField::SetIsNotNull方法的9个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: DoBeforeCreate

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

开发者ID:kcallow，项目名称:MatchMe，代码行数:30，代码来源:GE.EVENTO.php

示例2: 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

示例3: DoBeforeCreate

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

开发者ID:CivicInfoBC，项目名称:workplan.gov_ver_1.19，代码行数:28，代码来源:timesheet.php

示例4: DoBeforeCreate

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

开发者ID:BCDevExchange，项目名称:WORKPLAN，代码行数:59，代码来源:View_Pay_Period.php

示例5: DoBeforeCreate

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

开发者ID:CivicInfoBC，项目名称:workplan.gov_ver_1.19，代码行数:52，代码来源:Pay_Period.php

示例6: DoBeforeCreate

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

开发者ID:kcallow，项目名称:MatchMe，代码行数:23，代码来源:GE.WINK.php

示例7: DoBeforeCreate

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

开发者ID:jorgedison，项目名称:Audit-Database，代码行数:24，代码来源:Volumen.php

示例8: DoBeforeCreate

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

开发者ID:BCDevExchange，项目名称:WORKPLAN，代码行数:36，代码来源:multiple_time_entry.php

示例9: DoBeforeCreate

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

开发者ID:CivicInfoBC，项目名称:workplan.gov_ver_1.19，代码行数:25，代码来源:project.php

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