function deleteClassificationElements()
{
$this->checkClassificationUsed();
DatabaseOperation::executeComplete('DELETE FROM ' . self::TABLENAME . ' WHERE ' . self::KEYNAME . '=' . $this->getKeyValue());
}
function deleteClassificationRaccourcisAssociation()
{
DatabaseOperation::executeComplete('DELETE FROM ' . self::TABLENAME . ' WHERE ' . self::KEYNAME . '=' . $this->getKeyValue());
}
/**
* Valeurs par défaut en cas de création
* d'un nouvel enregistrement
* @return mixed
*/
public static function createNewRecordset($paramForeignKeysValuesArray = NULL)
{
$pdo = DatabaseOperation::executeComplete('INSERT INTO ' . AnnexeEmballageModel::TABLENAME . '(' . AnnexeEmballageModel::FIELDNAME_ID_FTE_FOURNISSEUR . ')' . 'VALUES (' . $paramForeignKeysValuesArray[AnnexeEmballageModel::FIELDNAME_ID_FTE_FOURNISSEUR] . ')');
$key = $pdo->lastInsertId();
return $key;
}
function deleteClassificationActiviteSousFamilleArcadia()
{
DatabaseOperation::executeComplete('DELETE FROM ' . self::TABLENAME . ' WHERE ' . self::KEYNAME . '=' . $this->getKeyValue());
}
/**
* Réserve une clef dans la base de données<br>
* Pour ce faire, un enregsitrement vide est créé.
* @param string $paramTableName Nom de la table
* @return mixed Valeur de la clef réservée
*/
public static function reserveKeyDatabase($paramTableName)
{
$sqlReq = 'INSERT ' . $paramTableName . ' VALUES()';
$sqlResult = DatabaseOperation::executeComplete($sqlReq);
$return = $sqlResult->lastInsertId();
return $return;
}
/**
* Création d'une nouvelle classification et retourn sont identifiant
* @return int
*/
public static function InsertClassification()
{
$pdo = DatabaseOperation::executeComplete('INSERT INTO ' . ClassificationFta2Model::TABLENAME . ' VALUES (NULL , \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\')');
$key = $pdo->lastInsertId();
return $key;
}
/**
* Duplique la table résultat de la clé étrangère
* @param string $paramTable
* @param string $paramId
* @return int
*/
public static function duplicateRowsByIdReplaceLast($paramTable, $paramIdOLD, $paramIdNew)
{
/**
* On récupère le nom du champ primaire de la table
*/
$primaryFieldName = self::getPrimaryFieldName($paramTable);
$arrayField = DatabaseOperation::getArrayFiledsNamesTable($paramTable);
$separation = "";
$separation2 = "";
foreach ($arrayField as $nomColumn) {
if ($nomColumn != $primaryFieldName) {
$tableListeInsert .= $separation . $nomColumn;
$separation = ",";
}
if (stripos($nomColumn, self::LAST) === self::FALSE) {
if ($nomColumn == FtaModel::KEYNAME) {
$nomColumn = $paramIdNew;
}
$tableListeSelect .= $separation2 . $nomColumn;
$separation2 = ",";
}
}
$req = " INSERT INTO " . $paramTable . " (" . $tableListeInsert . ") " . " SELECT " . $tableListeSelect . " FROM " . $paramTable . " WHERE " . FtaModel::KEYNAME . "=" . $paramIdOLD;
DatabaseOperation::executeComplete($req);
}
/**
* Fonction d"insertion d'une Fta
* @param int $paramIdCreateur
* @param int $paramIdFtaEtat
* @param int $paramIdFtaWorkflow
* @param string $paramDesignationCommerciale
* @param date $paramDateCreation
* @param int $paramSiteDeProduction
* @return int
*/
public static function createFta($paramIdCreateur, $paramIdFtaEtat, $paramIdFtaWorkflow, $paramDesignationCommerciale, $paramDateCreation, $paramSiteDeProduction)
{
$Id = DatabaseOperation::executeComplete("INSERT INTO " . FtaModel::TABLENAME . " ( " . FtaModel::FIELDNAME_CREATEUR . "," . FtaModel::FIELDNAME_ID_FTA_ETAT . "," . FtaModel::FIELDNAME_DESIGNATION_COMMERCIALE . "," . FtaModel::FIELDNAME_DATE_CREATION . "," . FtaModel::FIELDNAME_SITE_PRODUCTION . "," . FtaModel::FIELDNAME_WORKFLOW . ")" . " VALUES (" . $paramIdCreateur . ", " . $paramIdFtaEtat . ", '" . addslashes($paramDesignationCommerciale) . "', " . $paramDateCreation . ", " . $paramSiteDeProduction . ", " . $paramIdFtaWorkflow . ")");
$key = $Id->lastInsertId();
return $key;
}
/**
* Ajout d'une Description
* @param string $paramNameTable
* @param string $paramNameVariable
* @return int
*/
public static function insertIntranetDescription($paramNameTable, $paramNameVariable)
{
$pdo = DatabaseOperation::executeComplete("INSERT INTO " . self::TABLENAME . "(" . self::FIELDNAME_TABLE_NAME_INTRANET_COLUMN_INFO . "," . self::FIELDNAME_COLUMN_NAME_INTRANET_COLUMN_INFO . "," . self::FIELDNAME_EXPLICATION_INTRANET_COLUMN_INFO . ")" . "VALUES ('" . $paramNameTable . "','" . $paramNameVariable . "','" . self::DEFAULT_MESSAGE . "')");
$key = $pdo->lastInsertId();
return $key;
}
/**
* Suppression d'un allergene
*/
function deleteAllergeneElements()
{
DatabaseOperation::executeComplete('DELETE FROM ' . self::TABLENAME . ' WHERE ' . self::KEYNAME . '=' . $this->getKeyValue());
}
/**
* Valeurs par défaut en cas de création
* d'un nouvel enregistrement
* @return mixed
*/
public static function createNewRecordset($paramForeignKeysValuesArray = NULL)
{
$pdo = DatabaseOperation::executeComplete('INSERT INTO ' . self::TABLENAME . '(' . self::FIELDNAME_ID_FTA . ')' . 'VALUES (' . $paramForeignKeysValuesArray[self::FIELDNAME_ID_FTA] . ')');
$key = $pdo->lastInsertId();
return $key;
}
function deleteAnnexeEmballageGroupe()
{
DatabaseOperation::executeComplete('DELETE FROM ' . self::TABLENAME . ' WHERE ' . self::KEYNAME . '=' . $this->getKeyValue());
}
public static function insertFtaComposition($paramIdFta)
{
$pdo = DatabaseOperation::executeComplete('INSERT INTO ' . self::TABLENAME . '(' . self::FIELDNAME_ID_FTA . ',' . self::FIELDNAME_IS_COMPOSITION_FTA_COMPOSANT . ',' . self::FIELDNAME_IS_NOMENCLATURE_FTA_COMPOSANT . ')' . 'VALUES (' . $paramIdFta . ',' . '1' . ',' . '0' . ')');
$key = $pdo->lastInsertId();
return $key;
}
/**
* Suppression d'un fournisseur
*/
function deleteFteFournisseurs()
{
$this->checkFteFournisseurUsed();
DatabaseOperation::executeComplete('DELETE FROM ' . self::TABLENAME . ' WHERE ' . self::KEYNAME . '=' . $this->getKeyValue());
}
/**
* Valeurs par défaut en cas de création
* d'un nouvel enregistrement
* @param array $paramForeignKeysValuesArray
* @return int
*/
public static function createNewRecordset($paramForeignKeysValuesArray = NULL)
{
$pdo = DatabaseOperation::executeComplete('INSERT INTO ' . self::TABLENAME . '(' . self::KEYNAME . ',' . self::FIELDNAME_ID_FTA . ',' . self::FIELDNAME_CODE_ARTICLE_LDC . ',' . self::FIELDNAME_TAG_TYPE_TRANSACTION . ',' . self::FIELDNAME_ACTIF . ',' . self::FIELDNAME_DATE_ENVOI . ',' . self::FIELDNAME_ID_USER . ')' . 'VALUES (' . "\"NULL\"" . ',' . "\"" . $paramForeignKeysValuesArray[self::FIELDNAME_ID_FTA] . "\"" . ',' . "\"" . $paramForeignKeysValuesArray[self::FIELDNAME_CODE_ARTICLE_LDC] . "\"" . ',' . "\"" . "\"" . ',' . "\"" . self::OUI . "\"" . ',' . "\"" . $paramForeignKeysValuesArray[self::FIELDNAME_DATE_ENVOI] . "\"" . ',' . "\"" . $paramForeignKeysValuesArray[self::FIELDNAME_ID_USER] . "\"" . ')');
$key = $pdo->lastInsertId();
return $key;
}
