/**
* Get default param for column (for observer model class)
* @param CRUD_Item_Date $item
* @return array
*/
public static function observe_param($item, $model_name)
{
$global_param = parent::observe_param($item, $model_name);
$item = $item->get_item();
$param = array('var' => 11, 'attr' => 'UNSIGNED');
return array_merge($global_param, $param);
}
/**
* Get default param for column (for observer model class)
* @param CRUD_Item $item
* @return array
*/
public static function observe_param($item, $model_name)
{
$global_param = parent::observe_param($item, $model_name);
$item = $item->get_item();
$param = array('var' => isset($item['length']['max']) ? $item['length']['max'] : 255);
return array_merge($global_param, $param);
}
/**
* Get default param for sql (for observer model class)
* @param CRUD_Item_Options $item
* @return array
*/
public static function observe_param($item, $model_name)
{
$param = parent::observe_param($item, $model_name);
$models[0] = Inflector::plural(strtolower(str_replace('Model_', '', $model_name)));
$models[1] = $item->get_name();
sort($models);
$param['sql'] = "\n" . 'CREATE TABLE IF NOT EXISTS `' . $models[0] . '_' . $models[1] . '` (' . "\n" . ' `' . Inflector::singular($models[0]) . '_id` int(10) unsigned NOT NULL,' . "\n" . ' `' . Inflector::singular($models[1]) . '_id` int(10) unsigned NOT NULL,' . "\n" . ' PRIMARY KEY (`' . Inflector::singular($models[0]) . '_id`,`' . Inflector::singular($models[1]) . '_id`),' . "\n" . ' KEY `fk_' . Inflector::singular($models[1]) . '_id` (`' . Inflector::singular($models[1]) . '_id`)' . "\n" . ') ENGINE=InnoDB DEFAULT CHARSET=utf8;' . "\n" . "\n" . 'ALTER TABLE `' . $models[0] . '_' . $models[1] . '`' . "\n" . ' ADD CONSTRAINT `' . $models[0] . '_' . $models[1] . '_ibfk_1` FOREIGN KEY (`' . Inflector::singular($models[0]) . '_id`) REFERENCES `' . $models[0] . '` (`id`) ON DELETE CASCADE,' . "\n" . ' ADD CONSTRAINT `' . $models[0] . '_' . $models[1] . '_ibfk_2` FOREIGN KEY (`' . Inflector::singular($models[1]) . '_id`) REFERENCES `' . $models[1] . '` (`id`) ON DELETE CASCADE;' . "\n";
return $param;
}
/**
* Get default param for column (for observer model class)
* @param CRUD_Item_Options $item
* @return array
*/
public static function observe_param($item, $model_name)
{
$global_param = parent::observe_param($item, $model_name);
$item = $item->get_item();
$var = null;
foreach ($item['values'] as $value) {
if ($var != null) {
$var .= ', ';
}
$var .= '\'' . $value . '\'';
}
$param = array('var' => $var);
return array_merge($global_param, $param);
}
/**
* Item manager
* @param CRUD_Item $item
* @param mixed $value
*/
public function __construct(CRUD_Item $item, &$model = null)
{
$this->item = $item->get_item();
$this->model = $model;
}
