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(); } }