File Source for class.project.php

<?php
/**
* @package linea21.modules
* @subpackage project
* @author linea21 <info@linea21.com>
* @version $id SVN
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
* Project Management
*/
class project {
/* @param
* */
var $TDB_PROJECT = T_PROJECT; // nom de la table.
var $ID;
var $PARENT_ID;
var $SCALE_ID;
var $PRIORITY_ID;
var $NAME;
var $DESCRIPTION;
var $BODY;
var $BEGIN_DATE;
var $ESTIMATED_DATE;
var $END_DATE;
var $PUBLISHED_DATE;
var $POSTED_BY;
var $DATE_CREA;
var $STATUT;
var $LAST_MODIFY;
/**
* project::_getDate()
* date courante et ajout
*
* @access private
* @param int $m chiffre des mois
* @param int $d chiffre des jours
* @param int $y chiffre des années
* @return string $format_date
* @return
*/
function _getDate($m = 0, $d = 0, $y = 0)
{
$format_date = mktime(date("H"), date("i"), date("s"), date("m") + $m, date("d") , date("Y"), -1);
$format_date = strftime('%Y-%m-%d %H:%M:%S', $format_date);
return $format_date;
}
/**
* project::CheckDataIntegrity()
* Vérification intégrité des données
*
* @access public
* @param array $table : contient les composants Nécessaires d'un projet
* @return boolean true
* si verifié, sinon string 'message d'erreur'
*/
function CheckDataIntegrity($table)
{
if (strlen($table[0]) < 3) return $GLOBALS['lang']['project']['no_name'];
if (strlen($table[1]) < 3) return $GLOBALS['lang']['project']['no_description'];
if (strlen($table[2]) < 3) return $GLOBALS['lang']['project']['no_body'];
if ($table[5] <= 0 || !is_numeric($table[5])) return $GLOBALS['lang']['project']['no_priority'];
if ($table[4] <= 0 || !is_numeric($table[4])) return $GLOBALS['lang']['project']['no_scale'];
if(!empty($table[6])) return checkdate_validity($table[6], $GLOBALS['lang']['project']['begin_date_err']);
if(!empty($table[7])) return checkdate_validity($table[7], $GLOBALS['lang']['project']['estimated_date_err']);
if(!empty($table[8])) return checkdate_validity($table[8], $GLOBALS['lang']['project']['end_date_err']);
return true;
}
/**
* project::AddProject()
* Ajout d'un projet
*
* @access public
* @param array $table_project : contient les composants d'un projet
* @param object $sql_object
* @return integer $last_id
*/
function AddProject($table_project, $sql_object)
{
$table_project=$sql_object->DBescape($table_project);
if ($table_project[0] != '') {
$this->NAME = strip_input(trim($table_project[0]), true);
}
if ($table_project[1] != '') {
$this->DESCRIPTION = strip_input(trim($table_project[1]), true);
}
if ($table_project[2] != '') {
$this->BODY = strip_input(trim($table_project[2]), true);
}
if (is_numeric($table_project[3]) && $table_project[3] != -1) {
$this->PARENT_ID = $table_project[3];
} else {
$this->PARENT_ID = 0;
}
if (is_numeric($table_project[4])) {
$this->SCALE_ID = $table_project[4];
}
if (is_numeric($table_project[5])) {
$this->PRIORITY_ID = $table_project[5];
}
if ($table_project[6] != '') {
$this->BEGIN_DATE = formatDate($table_project[6], true);
} else {
$this->BEGIN_DATE = '0001-01-01';
}
if ($table_project[7] != '') {
$this->ESTIMATED_DATE = formatDate($table_project[7], true);
} else {
$this->ESTIMATED_DATE = '0001-01-01';
}
if ($table_project[8] != '') {
$this->END_DATE = formatDate($table_project[8], true);
} else {
$this->END_DATE = '0001-01-01';
}
if (is_numeric($table_project[9])) {
$this->POSTED_BY = $table_project[9];
}
if ($table_project[10] != '') {
$this->STATUT = strtoupper($table_project[10]);
}
if ($this->STATUT == 'P') {
$this->PUBLISHED_DATE = $this->_getDate();
} else {
$this->PUBLISHED_DATE = '0001-01-01';
}
$query = "INSERT INTO " . $this->TDB_PROJECT . " (project_name, project_description, project_body, ".
"project_parent_id, project_priority_id, project_scale_id, " .
"project_begin_date, project_estimated_date, project_end_date, ".
"project_posted_by, project_published_date, " .
"project_statut, project_date_crea) " .
"VALUES('" . $this->NAME . "', '" . $this->DESCRIPTION . "', '" . $this->BODY .
"', " . $this->PARENT_ID . ", " . $this->PRIORITY_ID . ", " . $this->SCALE_ID .
", '" . $this->BEGIN_DATE . "', '" . $this->ESTIMATED_DATE . "', '" . $this->END_DATE .
"', " . $this->POSTED_BY . ", '" . $this->PUBLISHED_DATE . "' , '" . $this->STATUT .
"', now());";
echo $query;
//exit;
$last_id = $sql_object->DBInsert ($query, 1);
return $last_id;
}
/**
* project::DeleteProject()
* suppression d'un projet
*
* @access public
* @param int $ID : identifiant du projet
* @param object $sql_object
* @return bool $result
*/
function DeleteProject($ID, $sql_object)
{
$this->ID = $ID;
$query = "UPDATE " . $this->TDB_PROJECT . " set project_statut='E', project_last_modify=NOW() WHERE project_id='" . $this->ID . "';";
$result = $sql_object->DBQuery($query);
if($result) {
$requete = "SELECT project_parent_id FROM " . $this->TDB_PROJECT . " WHERE project_id=" . $this->ID . ";";
$result = $sql_object->DBSelect($requete);
$parent_id = $result[0]['project_parent_id'];
$query = "UPDATE " . $this->TDB_PROJECT . " set project_parent_id=null WHERE project_parent_id='" . $parent_id . "';";
$result = $sql_object->DBQuery($query);
}
return $result;
}
/**
* project::ModifyProject()
* modification d'un projet
*
* @access public
* @param integer $ID : identifiant du projet
* @param object $sql_object
* @param array $table_project : contient les composants d'un projet
* @return boolean $result
*/
function ModifyProject($ID, $table_project, $sql_object)
{
$table_project=$sql_object->DBescape($table_project);
if (is_numeric($ID)) {
$this->ID = $ID;
}
if ($table_project[0] != '') {
$this->NAME = strip_input(trim($table_project[0]), true);
}
if ($table_project[1] != '') {
$this->DESCRIPTION = strip_input(trim($table_project[1]), true);
}
if ($table_project[2] != '') {
$this->BODY = strip_input(trim($table_project[2]), true);
}
if (is_numeric($table_project[3]) && $table_project[3] != -1) {
$this->PARENT_ID = $table_project[3];
} else {
$this->PARENT_ID = 0;
}
if (is_numeric($table_project[4])) {
$this->SCALE_ID = $table_project[4];
}
if (is_numeric($table_project[5])) {
$this->PRIORITY_ID = $table_project[5];
}
if ($table_project[6] != '') {
$this->BEGIN_DATE = formatDate($table_project[6], true);
} else {
$this->BEGIN_DATE = '0001-01-01';
}
if ($table_project[7] != '') {
$this->ESTIMATED_DATE = formatDate($table_project[7], true);
} else {
$this->ESTIMATED_DATE = '0001-01-01';
}
if ($table_project[8] != '') {
$this->END_DATE = formatDate($table_project[8], true);
} else {
$this->END_DATE = '0001-01-01';
}
if ($table_project[9] != '') {
$this->STATUT = strtoupper($table_project[9]);
}
if ($this->STATUT == 'P') {
$this->PUBLISHED_DATE = $this->_getDate();
} else {
$this->PUBLISHED_DATE = '0001-01-01';
}
$mask = $this->_HavePublishedDate($table_project[10]);
$query = "UPDATE " . $this->TDB_PROJECT . " SET project_name='" . $this->NAME . "', project_description='" . $this->DESCRIPTION. "', project_body='" . $this->BODY . "' , project_parent_id='" . $this->PARENT_ID . "', project_scale_id='" . $this->SCALE_ID . "', project_priority_id='" . $this->PRIORITY_ID . "', project_begin_date='" . $this->BEGIN_DATE . "', project_estimated_date='" . $this->ESTIMATED_DATE . "', project_end_date='".$this->END_DATE."', project_statut='" . $this->STATUT . "', project_last_modify=NOW() " . $mask . " WHERE project_id='" . $this->ID . "';";
$result = $sql_object->DBQuery($query);
return $result;
}
/**
* project::_HavePublishedDate()
* Détermine la date de publication a inserer dans la bdd
*
* @access private
* @param string $current_status : statut actuel de l'actualité
* @return string $sql_mask
*/
function _HavePublishedDate($current_status)
{
switch ($this->STATUT) {
case 'P':
if ($current_status == 'D') $sql_mask = ", project_published_date= NOW()";
else $sql_mask = '';
break;
case 'D':
$sql_mask = ", project_published_date= '0001-01-01'";
break;
default:
$sql_mask = '';
}
return $sql_mask;
}
}
?>

Source for file class.project.php