DataObjectTombstoneSettingsDAO.inc.php

<?php
 
class DataObjectTombstoneSettingsDAO extends DAO {
   function &getSetting($tombstoneId, $name, $locale = null) {
      $sql = 'SELECT setting_value, setting_type   FROM data_object_tombstone_settings WHERE tombstone_id = ? AND setting_name = ?';
      $params = array((int) $tombstoneId, $name);
      if ($locale !== null) {
         $sql .= ' AND l.locale = ?';
         $params[] = $locale;
      }
      $result = $this->retrieve($sql, $params);
 
      $setting = null;
      while (!$result->EOF) {
         $row = $result->getRowAssoc(false);
         $value = $this->convertFromDB($row['setting_value'], $row['setting_type']);
         if (!array_key_exists('locale', $row) || $row['locale'] == '') $setting[$name] = $value;
         else $setting[$name][$row['locale']] = $value;
         $result->MoveNext();
      }
      $result->Close();
      return $setting;
   }
 
   function updateSetting($tombstoneId, $name, $value, $type = null, $isLocalized = false) {
      $returner = null;
 
      $keyFields = array('tombstone_id', 'setting_name', 'locale');
 
      if (!$isLocalized) {
         $value = $this->convertToDB($value, $type);
         $this->replace('data_object_tombstone_settings',
            array(
               'tombstone_id' => $tombstoneId,
               'setting_name' => $name,
               'setting_value' => $value,
               'setting_type' => $type,
               'locale' => ''
            ),
            $keyFields
         );
         $returner = true;
      } else {
         if (is_array($value)) foreach ($value as $locale => $localeValue) {
            $this->update('DELETE FROM data_object_tombstone_settings WHERE tombstone_id = ? AND setting_name = ? AND locale = ?', array((int) $tombstoneId, $name, $locale));
            if (empty($localeValue)) continue;
            $type = null;
            $returner = $this->update('INSERT INTO data_object_tombstone_settings
               (tombstone_id, setting_name, setting_value, setting_type, locale)
               VALUES (?, ?, ?, ?, ?)',
               array(
                  (int) $tombstoneId, $name, $this->convertToDB($localeValue, $type), $type, $locale
               )
            );
         }
      }
      return $returner;
   }
 
   function deleteSetting($tombstoneId, $name, $locale = null) {
      $params = array((int) $tombstoneId, $name);
      $sql = 'DELETE FROM data_object_tombstone_settings WHERE tombstone_id = ? AND setting_name = ?';
      if ($locale !== null) {
         $params[] = $locale;
         $sql .= ' AND locale = ?';
      }
      return $this->update($sql, $params);
   }
 
   function deleteSettings($tombstoneId) {
      return $this->update(
         'DELETE FROM data_object_tombstone_settings WHERE tombstone_id = ?', (int) $tombstoneId
      );
   }
}