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