/**
* Prepare and sanitise the table data prior to saving.
*
* @param JTable $table A reference to a JTable object.
*
* @return void
*
* @since 12.2
*/
protected function prepareTable($table)
{
require_once JDeveloperLIB . "/template.php";
$type = $table->get("type", "");
$dir = JDeveloperTEMPLATES . "/fields/formfields/" . $type . ".php";
if ($table->id == 0 && JFile::exists($dir)) {
$template = new JDeveloperTemplate($dir);
$template->addAreas(array("header" => false));
$template->addPlaceholders(array("name" => $table->name), true);
$table->source = $template->getBuffer();
}
}
/**
* Initialize the template
*
* @return JDeveloperCreate this
*/
protected function initialize()
{
// standart placeholders
$this->template->addAreas($this->getDefaultAreas());
$this->template->addPlaceHolders($this->getDefaultPlaceholders(), true);
return $this;
}
/**
* Prepare and sanitise the table data prior to saving.
*
* @param JTable $table A reference to a JTable object.
*
* @return void
*
* @since 12.2
*/
protected function prepareTable($table)
{
require_once JDeveloperLIB . "/template.php";
$dir = JDeveloperTEMPLATES . "/component/admin/models/rules/rule.php";
if ($table->id == 0) {
$template = new JDeveloperTemplate($dir);
$template->addAreas(array("header" => false));
$template->addPlaceholders(array("name" => $table->name), true);
$table->source = $template->getBuffer();
}
}
public static function getTableSql($id)
{
require_once JDeveloperLIB . DS . 'template.php';
$template = new JDeveloperTemplate(JDeveloperPath::dots2ds(JDeveloperTEMPLATES . DS . 'com.admin.sql.install.mysql.utf8.create.sql'));
$table = JModelLegacy::getInstance('Table', 'JDeveloperModel')->getItem($id);
$component = JModelLegacy::getInstance('Table', 'JDeveloperModel')->getItem($table->component);
$fields = JModelLegacy::getInstance('Fields', 'JDeveloperModel')->getTableFields($table->id);
if ($component === false) {
$component = new JObject(array('name' => ''));
}
$template->addAreas(array('access' => (bool) $table->get('access', 0), 'alias' => (bool) $table->get('alias', 0), 'asset_id' => (bool) $table->get('asset_id', 0), 'catid' => (bool) $table->get('catid', 0), 'checked_out' => (bool) $table->get('checked_out', 0), 'created' => (bool) $table->get('created', 0), 'created_by' => (bool) $table->get('created_by', 0), 'created_by_alias' => (bool) $table->get('created_by_alias', 0), 'hits' => (bool) $table->get('hits', 0), 'language' => (bool) $table->get('language', 0), 'metadata' => (bool) $table->get('metadata', 0), 'metadesc' => (bool) $table->get('metadesc', 0), 'metakey' => (bool) $table->get('metakey', 0), 'modified' => (bool) $table->get('modified', 0), 'modified_by' => (bool) $table->get('modified_by', 0), 'ordering' => (bool) $table->get('ordering', 0), 'params' => !empty($table->params), 'publish' => (bool) $table->get('publish_up', 0) || (bool) $table->get('publish_down', 0), 'publish_up' => (bool) $table->get('publish_up', 0), 'publish_down' => (bool) $table->get('publish_down', 0), 'published' => (bool) $table->get('published', 0), 'tags' => false, 'version' => (bool) $table->get('version', 0)));
$template->addPlaceholders(array('table_db' => JComponentHelper::getParams('com_jdeveloper')->get('add_component_name_to_table_name') ? $component->name . '_' . $table->name : $table->name, 'pk' => $table->pk, 'sql' => '<br>' . self::sqlFields($fields)));
$buffer = $template->getBuffer();
$buffer = preg_replace('/(CREATE TABLE IF NOT EXISTS|NOT NULL|CHARACTER SET|COLLATE|AUTO_INCREMENT|PRIMARY KEY|DEFAULT|COMMENT|unsigned)/', "<span style=\"color:blue\">\$0</span>", $buffer);
$buffer = preg_replace('/`.*`/', "<span style=\"color:orange\">\$0</span>", $buffer);
$buffer = preg_replace('/\'.*\'/', "<span style=\"color:#999999\">\$0</span>", $buffer);
return $buffer;
}
