<?php
/**
* Entier Studio
*
* LICENSE
*
* Copyright 2006 Entier Studio team.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* @package entier.office
* @copyright Copyright (c) 2006 Entier Studio team. All rights reserved.
* @version $Id: data.DirectoryTeam.php 81 2008-01-17 23:08:21Z yannromefort $
*/
//-----------------------------------------------------------------------------
// namespace
if (!defined("DefDirectoryTeam")) {
//-------------------------------------------------------------------------
// Define
define("DefDirectoryTeam", "1");
//-------------------------------------------------------------------------
// Include
@require_once (FRAMEWORK_DIR . DATAROWOBJECT);
//-------------------------------------------------------------------------
// Class
class DirectoryTeam extends DataRow {
/*
*
*
* @see index.php
/
//---------------------------------------------------------------------
// Constructor
/**
*
* @param integer DirectoryTeam pkid // primary key
*/
function DirectoryTeam($DIRUNITPKID = 0) {
//
$this->m_tableSet[PRIMARYKEY] = "tbl_directory_unit";
$this->m_indexSet[PRIMARYKEY] = "DIRUNITPKID";
$this->m_indexSet[FOREIGNKEY] = "DIRECTOPKID";
//
$this->m_fieldSet["DIRUNITPKID"] = $DIRUNITPKID;
}
//-------------------------------------------------------------------------
// Methods
/**
*
* @access protected
*
* @param integer index type
*/
function getUpdateQuery($indexType = PRIMARYKEY) {
//
$table = $this->m_tableSet[PRIMARYKEY];
//
switch ($indexType) {
case PRIMARYKEY:
/*
* UPDATE
* tbl_directory_unit
* ON
* DIRUSERPKID
*
*/
//
$field = $this->m_indexSet[PRIMARYKEY];
$index = $this->m_fieldSet["$field"];
if ($index != 0) {
//
$updateSQL = "UPDATE $table SET ";
// DIRUNITNAME = DirectoryTeam login
$value = FilterFormInput::filter($this->m_fieldSet["DIRUNITNAME"]);
if (!empty($value)) $updateSQL.= " DIRUNITNAME=$value";
else {
$this->m_errorSet["DIRUNITNAME"] = true;
return ("");
}
// DIRUNITSTAT = DirectoryTeam status
$value = 2;
if (!empty($value)) $updateSQL.= ",DIRUNITSTAT=$value";
// DIRUNITDATE = DirectoryTeam creation date
$value = Date("Y-m-d H:i:s");
if (!empty($value)) $updateSQL.= ",DIRUNITDATE=\"$value\"";
//
return ($updateSQL . " WHERE $field=$index");
}
break;
}
//
return ("");
}
};
// Class
//-------------------------------------------------------------------------
}
// namespace
//-----------------------------------------------------------------------------
?>