/**
* Deletes an element list in database
* @param string $elementClass The element class to delete
* @param string $conditions The delete request conditions
* @return int The affected rows number
*/
public static function deleteElementList($elementClass, $conditions = null)
{
$tableName = DatabaseFactory::getElementTableName($elementClass);
// Gets database connection instance
$databaseConnection = $elementClass::getDatabaseConnection();
// Builds request string
$request = 'DELETE FROM ' . $tableName;
if ($conditions !== NULL) {
$request .= ' WHERE (' . $conditions . ')';
}
// Executes request in database
$affectedRowNumber = $databaseConnection->deleteRequest($request);
return $affectedRowNumber;
}
/**
* Property writing accessor
* @param string $propertyName The property name
* @param string $value The property value
*/
public function setProperty($propertyName, $value)
{
// Non-null value
if ($value !== NULL) {
// Numeric value
if (StringTool::isInt($value)) {
$value = StringTool::toInt($value, false);
} else {
if (StringTool::isFloat($value, FALSE)) {
$value = StringTool::toFloat($value, false);
} else {
if (StringTool::endsWith($propertyName, 'date')) {
// Date has a 10 length (YYYY-mm-dd)
if (StringTool::strlen($value) == 10) {
$value = DateTool::stringToTimestamp($value, DateTool::FORMAT_MYSQL_DATE);
} else {
$value = DateTool::stringToTimestamp($value);
}
}
}
}
// Day property type
}
// Removes table name at the beginning of field name, not for id fields nor xxx_has_xxx tables
$tableName = DatabaseFactory::getElementTableName($this->getElementClass());
if (!StringTool::contains($tableName, ElementFactory::TABLE_JOIN_SEPARATOR)) {
$tablePrefix = $tableName . '_';
$tableIdField = $tablePrefix . 'id';
if (StringTool::startsWith($propertyName, $tablePrefix) && (!StringTool::endsWith($propertyName, '_id') || $propertyName == $tableIdField)) {
$propertyName = StringTool::truncateFirstChars($propertyName, StringTool::strlen($tablePrefix));
}
}
// Updates original property list
if (!ArrayTool::array_key_exists($propertyName, $this->propertyList)) {
// It's the first time this property gets a value, it will be updated (set a null value to original property list)
$this->originalPropertyList[$propertyName] = NULL;
} else {
if (ArrayTool::array_key_exists($propertyName, $this->originalPropertyList)) {
// Attribute value had already changed (originalPropertyList already has a value for this property)
// If value has been reset to original value, removes the update of the property
if ($value == $this->originalPropertyList[$propertyName]) {
unset($this->originalPropertyList[$propertyName]);
}
} else {
if ($value !== $this->propertyList[$propertyName]) {
// If value has changed, updates original value
$this->originalPropertyList[$propertyName] = $this->propertyList[$propertyName];
}
}
}
// Sets property new value
$this->propertyList[$propertyName] = $value;
}
/**
* Gets element list link to an element
* @param string $elementClass The element class searched
* @param string $parentElement The parent element to get list of
* @param string $conditions The conditions string to apply
* @param string $orderBy The order string to apply)
* @return array The element list array
*/
public static function &getElementListFromParent($elementClass, $parentElement, $conditions = NULL, $orderBy = NULL, $join = NULL)
{
$parentClass = $parentElement->getElementClass();
$parentId = $parentElement->id;
// Builds parent id conditions
$parentIdFieldName = DatabaseFactory::getParentIdColumnName($parentClass);
$tableName = DatabaseFactory::getElementTableName($elementClass);
$parentIdCondition = $tableName . '.' . $parentIdFieldName . '=' . $parentId;
if ($conditions !== NULL && StringTool::strlen($conditions) > 0) {
$conditions = $parentIdCondition . ' AND (' . $conditions . ')';
} else {
$conditions = $parentIdCondition;
}
$elementList = ElementFactory::getElementList($elementClass, $conditions, $orderBy, $join);
return $elementList;
}
