return file_get_contents(worktable_get_safe_temp_filename($name));
}
function worktable_get_next_autoincrement_value($table, $column)
{
global $_CAMILA;
$result = $_CAMILA['db']->Execute('select max(' . $column . ') as id from ' . $table);
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
return intval($result->fields['id']) + 1;
}
function worktable_parse_default_expression($expression, $form)
{
return camila_parse_default_expression($expression, $form->fields['id']->defaultvalue);
}
if (camila_form_in_update_mode(worktable_worktable2)) {
require_once CAMILA_DIR . 'datagrid/db_form.class.php';
require_once CAMILA_DIR . 'datagrid/elements/form/hidden.php';
require_once CAMILA_DIR . 'datagrid/elements/form/static_listbox.php';
require_once CAMILA_DIR . 'datagrid/elements/form/textbox.php';
require_once CAMILA_DIR . 'datagrid/elements/form/datetime.php';
require_once CAMILA_DIR . 'datagrid/elements/form/integer.php';
require_once CAMILA_DIR . 'datagrid/elements/form/textbox.php';
require_once CAMILA_DIR . 'datagrid/elements/form/static_listbox.php';
require_once CAMILA_DIR . 'datagrid/elements/form/date.php';
require_once CAMILA_DIR . 'datagrid/elements/form/datetime.php';
require_once CAMILA_DIR . 'datagrid/elements/form/phonenumber.php';
require_once CAMILA_DIR . 'datagrid/elements/form/textarea.php';
$form = new dbform('worktable_worktable2', 'id');
if ($_CAMILA['adm_user_group'] != CAMILA_ADM_USER_GROUP) {
$form->caninsert = true;
function admin()
{
if (camila_form_in_update_mode(CAMILA_TABLE_WORKT)) {
require_once CAMILA_DIR . 'datagrid/db_form.class.php';
global $_CAMILA;
$options = ' ,';
$query = 'select short_title from ' . CAMILA_TABLE_PLANG . ' where page_url LIKE ' . $_CAMILA['db']->qstr('cf_app.php?cat%') . ' and lang=' . $_CAMILA['db']->qstr($_CAMILA['lang']) . ' order by page_url';
$result = $_CAMILA['db']->Execute($query);
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
while (!$result->EOF) {
$options .= ',' . $result->fields['short_title'];
$result->MoveNext();
}
require_once CAMILA_DIR . 'datagrid/db_form.class.php';
require_once CAMILA_DIR . 'datagrid/elements/form/hidden.php';
require_once CAMILA_DIR . 'datagrid/elements/form/textbox.php';
require_once CAMILA_DIR . 'datagrid/elements/form/integer.php';
require_once CAMILA_DIR . 'datagrid/elements/form/static_listbox.php';
$dbform = new dbform(CAMILA_TABLE_WORKT, 'id');
new form_hidden($dbform, 'id');
new form_integer($dbform, 'sequence', camila_get_translation('camila.worktable.field.sequence'), true, 3);
new form_textbox($dbform, 'short_title', camila_get_translation('camila.worktable.name'), true, 20);
new form_textbox($dbform, 'full_title', camila_get_translation('camila.worktable.desc'), true, 40, 40);
new form_static_listbox($dbform, 'category', camila_get_translation('camila.worktable.category'), $options);
new form_textbox($dbform, 'share_key', camila_get_translation('camila.worktable.share.key'), false, 40, 40);
new form_static_listbox($dbform, 'share_caninsert', camila_get_translation('camila.worktable.share.caninsert'), camila_get_translation('camila.worktable.options.noyes'));
new form_static_listbox($dbform, 'share_canupdate', camila_get_translation('camila.worktable.share.canupdate'), camila_get_translation('camila.worktable.options.noyes'));
new form_static_listbox($dbform, 'share_candelete', camila_get_translation('camila.worktable.share.candelete'), camila_get_translation('camila.worktable.options.noyes'));
$dbform->formupdatelinktext = camila_get_translation('camila.worktable.field.formupdatelinktext');
$dbform->onupdate = camila_configurator_worktable_title_db_onupdate;
$dbform->process();
$dbform->draw();
} else {
require CAMILA_DIR . 'datagrid/report.class.php';
$report_fields = 'id as camila_worktable_delete,id as camila_worktable_reconfig,id as camila_worktable_import,id as camila_worktable_rebuild,sequence,short_title,full_title,category,share_key,share_caninsert,share_canupdate,share_candelete';
$default_fields = $report_fields;
$mapping = camila_get_translation('camila.worktable.mapping.worktable.admin');
$stmt = 'select ' . $report_fields . ' from ' . CAMILA_TABLE_WORKT;
$report = new report($stmt, '', 'sequence', 'asc', $mapping, null, 'id', '', '', false, false);
$report->additional_links = array(camila_get_translation('camila.report.insertnew') => 'cf_worktable_wizard.php');
$report->process();
$report->fields['camila_worktable_reconfig']->onprint = camila_configurator_reconfig;
$report->fields['camila_worktable_reconfig']->dummy = true;
$report->fields['camila_worktable_import']->onprint = camila_configurator_import;
$report->fields['camila_worktable_import']->dummy = true;
$report->fields['camila_worktable_rebuild']->onprint = camila_configurator_rebuild;
$report->fields['camila_worktable_rebuild']->dummy = true;
$report->fields['camila_worktable_delete']->onprint = camila_configurator_delete;
$report->fields['camila_worktable_delete']->dummy = true;
//$report->fields['camila_worktable_templates']->onprint = camila_configurator_templates;
//$report->fields['camila_worktable_templates']->dummy = true;
$report->draw();
}
}
