private function startFormHtml()
{
$data = $this->generateSelectQuery();
$usebbcode = false;
$result = '<div id="' . $this->uid . '" class="dbeditor-form">';
foreach ($data as $ek => $entry) {
$id = 'row_' . $ek;
$result .= '<div id="' . $id . '" class="dbeditor-row">';
foreach ($entry as $key => $value) {
$name = $ek . '_' . $key;
$result .= '<label for="' . $name . '">' . $key . '</label>: ';
if ($value['mode'] === 'htmlEdit' && $value['tag'] === 'textarea') {
$result .= '<textarea id="' . $name . '" name="' . $name . '_update" class="dbeditor-textarea-update-sceditor">' . $value['value'] . '</textarea><br/>';
$usebbcode = true;
} else {
if ($value['mode'] === 'readonly' && $value['tag'] === 'input') {
$result .= '<input id="' . $name . '" name="' . $name . '_readonly" type="text" value="' . $value['value'] . '" class="dbeditor-input-readonly" readonly/><br/>';
} else {
$result .= '<input id="' . $name . '" name="' . $name . '_update" type="text" value="' . $value['value'] . '" class="dbeditor-input-update"/><br/>';
}
}
}
$result .= '<button onclick="DBEditor.editEntry(\'' . $id . '\')"> Update Entry</button>';
$result .= '<button onclick="DBEditor.deleteEntry(\'' . $id . '\')"> Delete Entry</button>';
$result .= '</div><hr>';
}
$result .= '<div id=" add_' . $this->uid . '" class="add-field">';
$result .= $this->addForm;
$result .= '</div>';
$result .= '<button onclick="DBEditor.addEntry(\'add_' . $this->uid . '\')"> Add Entry</button>';
$result .= '</div>';
JsUtils::prepareDbEditor();
if ($usebbcode) {
JsUtils::prepareSceditor();
JsUtils::onjQueryDomReady('__initEditor = function() { $(".dbeditor-textarea-update-sceditor").sceditor({' . ' plugins: \'html\', height: \'500px\', width: \'100%\'' . '})}; __initEditor(); DBEditor.useSceditor(true);');
}
JsUtils::prepareScriptTag('DBEditor.mapping = ' . ($jstr = json_encode($this->fields) . ';'));
JsUtils::onjQueryDomReady('DBEditor.setAjaxUrl(\'' . JsUtils::getAjaxUrl('_dbedit.php') . '\'); DBEditor.setTableName(\'' . $this->tableName . '\'); DBEditor.setConnectionName(\'' . DBUtils::getActiveConnectionName() . '\')');
return $result;
}
