<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: module_activity_description.php 1724 2014-01-03 09:06:02Z hom $ */ require_once "ste.php"; $page = new PageContainer("Module activity description editor on DB {$db_name} "); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setTitle($title)->setFormAction($PHP_SELF)->setRelation('module_activity_description')->setMenuName('module_activity_description')->setKeyColumns(array('module_activity_id', 'language_id'))->setNameExpression("module_activity_id||':'||rtrim(language_id)")->setListRowTemplate(array('module_activity_id', 'language_id', 'description'))->setOrderList(array('module_activity_id', 'language_id'))->setFormTemplate('templates/module_activity_description.html')->show();
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: student_admin.php 1102 2012-02-22 21:44:36Z hom $ */ require_once "ste.php"; requireCap(CAP_LOOKUP_STUDENT); $page = new PageContainer("Student work placement address " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page, hasCap(CAP_ALTER_STUDENT)); $ste->setFormAction($PHP_SELF)->setRelation('wp_address')->setMenuName('wp_address')->setKeyColumns(array('wp_address_id'))->setFormTemplate('templates/wp_address.html')->setListRowTemplate(array('snummer', 'wp_type', 'company'))->setNameExpression("snummer||': '||wp_type||', start '||start_date||' at '||company")->show(); ?>
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: validator_regex.php 1570 2013-08-09 19:51:30Z hom $ */ require_once "ste.php"; $page = new PageContainer("Validator Regex Editor on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setTitle('Regex Editor')->setFormAction($PHP_SELF)->setRelation('validator_regex_slashed')->setMenuName('validator_regex')->setKeyColumns(array('regex_name'))->setNameExpression("rtrim(regex_name,' ')||', '||rtrim(regex,' ')")->setOrderList(array('regex_name'))->setFormTemplate('templates/validator_regex.html')->show(); ?>
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: tutor.php 1709 2013-12-08 07:56:27Z hom $ */ require_once "ste.php"; $page = new PageContainer("Nat mapper {$db_name} "); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setTitle("Map nationalities")->setFormAction($PHP_SELF)->setRelation('nat_mapper')->setMenuName('nat_mapper')->setKeyColumns(array('id'))->setNameExpression("rtrim(nation_omschr)")->setListRowTemplate(array('nation_omschr', 'nationaliteit', 'id'))->setOrderList(array('nation_omschr'))->setFormTemplate('templates/nat_mapper.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: tutor.php 1709 2013-12-08 07:56:27Z hom $ */ require_once "ste.php"; $page = new PageContainer("Hoofdgrp mapper {$db_name} "); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setTitle($title)->setFormAction($PHP_SELF)->setRelation('hoofdgrp_map')->setMenuName('hoofdgrp_map')->setKeyColumns(array('_id'))->setNameExpression("rtrim(opleiding)")->setListRowTemplate(array('instituutcode', 'hoofdgrp', 'lang', 'course'))->setOrderList(array('opleiding'))->setFormTemplate('templates/hoofdgrp_map.html')->show();
<?php /** * The simple table editor for the exam_event * @author Pieter van den Hombergh * $Id: exam_event.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; $page = new PageContainer("Exam_Event editor on DB {$db_name} "); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setTitle($title)->setFormAction($PHP_SELF)->setRelation('exam_event')->setMenuName('exam_event')->setKeyColumns(array('exam_event_id'))->setSubRel('module_part')->setSubRelJoinColumns(array('module_part_id' => 'module_part_id'))->setNameExpression("progress_code||':'||coalesce(part_description,'no description')")->setListRowTemplate(array('exam_date', 'examiner'))->setFormTemplate('templates/exam_event.php')->show();
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: known_courses2.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "peerutils.inc"; include_once 'navigation2.inc'; include_once "utils.inc"; include_once "ste.php"; $page = new PageContainer("Fontys courses in peerweb on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF); $ste->setRelation('fontys_course'); $ste->setMenuName('fontys_course')->setKeyColumns(array('course'))->setNameExpression("course||' :'||course_short||', '||rtrim(course_description)")->setOrderList(array('course', 'course_description', 'fo.faculty_id'))->setListRowTemplate(array('course', 'course_short', 'course_description', 'fo.faculty_id', 'faculty_short'))->setSubRel('faculty')->setSubRelJoinColumns(array('faculty_id' => 'faculty_id'))->setFormTemplate('templates/known_courses2.html')->show();
<?php /** * @package prafda2 * @author Pieter van den Hombergh * $Id: menu_option_queries.php 1723 2014-01-03 08:34:59Z hom $ * The simple table editor for the table menu_option_queries. Menu_option_querie is * one of the tables that support the simple table editor. It is used to define queries to * get option lists in forms. Examples are: manager in medewerkers, edit_type (in menu_item) */ require_once "ste.php"; $page = new PageContainer("Peerweb Menu option queries on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF)->setRelation('menu_option_queries')->setMenuName('option_queries')->setKeyColumns(array('menu_name', 'column_name'))->setNameExpression("rtrim(menu_name,' ')||', '||rtrim(column_name,' ')")->setOrderList(array('menu_name', 'column_name'))->setListRowTemplate(array('column_name', 'query'))->setFormTemplate('templates/menu_option_queries.html')->show(); ?>
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: class_cluster.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "ste.php"; $page = new PageContainer("Peerweb class clusters " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setFormAction($PHP_SELF)->setRelation('class_cluster')->setMenuName('class_cluster')->setKeyColumns(array('class_cluster'))->setNameExpression("rtrim(cluster_name)")->setListRowTemplate(array('cluster_name', 'cluster_description'))->setOrderList(array('sort_order'))->setFormTemplate('templates/class_cluster.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: module.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; $title = "Module editor on DB {$db_name} "; $page = new PageContainer(); $page->setTitle($title); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setTitle($title)->setFormAction($PHP_SELF)->setRelation('module')->setMenuName('module')->setKeyColumns(array('module_id'))->setNameExpression("semester||':'||rtrim(progress_code)")->setListRowTemplate(array('semester', 'module_id', 'progress_code', 'module_description'))->setOrderList(array('semester', 'progress_code', 'module_description'))->setFormTemplate('templates/module.html')->show();
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: defactivity.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; $pdj_id = 1; $milestone = 1; extract($_SESSION); $dbConn->setSqlAutoLog(true); $page = new PageContainer("Define activity " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF)->setRelation('activity')->setMenuName('activity')->setKeyColumns(array('act_id'))->setNameExpression("rtrim(short)||'*'||part||': '||rtrim(description)")->setOrderList(array('datum desc', 'start_time', 'short'))->setListRowTemplate(array('datum', 'start_time', 'act_type', 'part'))->setFormTemplate('templates/activity.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: planned_school_visit.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "peerutils.inc"; include_once 'navigation2.inc'; include_once "utils.inc"; include_once "ste.php"; requireCap(CAP_RECRUITER); $page = new PageContainer("Peerweb planned_school_visit" . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setTransactional(true)->setFormAction($PHP_SELF)->setRelation('planned_school_visit')->setMenuName('planned_school_visit')->setKeyColumns(array('planned_school_visit'))->setSubRel('transaction_operator')->setSubRelJoinColumns(array('trans_id' => 'trans_id'))->setNameExpression("rtrim(visit_short)")->setListRowTemplate(array('visit_short', 'visit_date'))->setOrderList(array('visit_date desc', 'visit_short'))->setFormTemplate('templates/planned_school_visit.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: tutor.php 1103 2012-02-23 19:22:48Z hom $ */ require_once "ste.php"; requireCap(CAP_RECRUITER); $page = new PageContainer("Peerweb verbaende on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setFormAction($PHP_SELF)->setRelation('verbaende')->setMenuName('verbaende')->setKeyColumns(array('verbaende_id'))->setNameExpression("rtrim(naam_school)")->setListRowTemplate(array('anrede', 'aan', 'adres', 'woonplaats', 'telefon', 'telefax'))->setOrderList(array('naam_school'))->setFormTemplate('templates/verbaende.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: schulen.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "ste.php"; requireCap(CAP_RECRUITER); $page = new PageContainer("Peerweb schulen in NRW on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setFormAction($PHP_SELF)->setRelation('schulen')->setMenuName('schulen')->setKeyColumns(array('schulen_id'))->setNameExpression("rtrim(naam_school)")->setListRowTemplate(array('schultyp', 'aan', 'url', 'adres', 'woonplaats', 'email', 'telefon', 'telefax'))->setOrderList(array('naam_school'))->setFormTemplate('templates/schulen.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: peer_settings.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; $navTitle = "Peerweb settings" . $PHP_SELF . " on DB " . $db_name; $page = new PageContainer(); $page->setTitle($navTitle); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setFormAction($PHP_SELF)->setRelation('peer_settings')->setMenuName('peer_settings')->setKeyColumns(array('key'))->setNameExpression("rtrim(key)")->setListRowTemplate(array('key', 'value', 'comment'))->setOrderList(array('key'))->setFormTemplate('templates/peer_settings.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: scholen_int.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "ste.php"; requireCap(CAP_RECRUITER); $page = new PageContainer("Peerweb scholen internationaal" . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setFormAction($PHP_SELF)->setRelation('scholen_int')->setMenuName('scholen_int')->setKeyColumns(array('scholen_int_id'))->setNameExpression("rtrim(naam_volledig)")->setListRowTemplate(array('naam_plaats_vest', 'naam_straat_vest', 'nr_huis_vest', 'postcode_vest'))->setOrderList(array('naam_volledig', 'naam_plaats_vest'))->setFormTemplate('templates/scholen_int.html')->show();
/** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: literature.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "peerutils.inc"; include_once 'navigation2.inc'; include_once "utils.inc"; include_once "ste.php"; $navTitle = "Course literature" . $PHP_SELF . " on DB " . $db_name; $page = new PageContainer(); $page->setTitle('Literature'); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF); $ste->setRelation('literature'); $ste->setMenuName('literature'); $ste->setKeyColumns(array('literature_id')); $ste->setNameExpression("rtrim(menu_name,' ')||', '||rtrim(column_name,' ')"); $ste->setOrderList(array('literature_code')); $ste->setFormTemplate('templates/literature.html'); $page_opening = "Literature for all courses"; $nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening); $page->addBodyComponent($nav); $ste->render(); $page->addBodyComponent(new Component('<!-- db_name=$db_name $Id: literature.php 1723 2014-01-03 08:34:59Z hom $ -->')); $page->show(); ?>
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: colloquium_speakers.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; $page = new PageContainer("Peerweb colloqium speakers" . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setFormAction($PHP_SELF)->setRelation('colloquium_speakers')->setMenuName('colloquium_speakers')->setKeyColumns(array('colloquium_speaker_id'))->setNameExpression("rtrim(speaker_org||':'||lastname)")->setListRowTemplate(array('speaker_org', 'achternaam', 'roepnaam', 'email'))->setOrderList(array('speaker_org', 'achternaam'))->setFormTemplate('templates/colloquium_speakers.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: meelopen.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; $navTitle = "Meelopen " . $PHP_SELF . " on DB " . $db_name; $page = new PageContainer(); $page->setTitle($navTitle); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF)->setRelation('meelopen')->setMenuName('meelopen')->setKeyColumns(array('meelopen_id'))->setListRowTemplate(array('email', 'taal', 'straat', 'huisnr', 'postcode', 'plaats', 'land', 'telefoon', 'participation', 'invitation', 'confirmed', 'vooropleiding'))->setOrderList(array('achternaam', 'roepnaam'))->setNameExpression("rtrim(achternaam||', '||roepnaam||coalesce(', '||tussenvoegsel,''))")->setFormTemplate('templates/meelopen.html')->show();
* The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: menu.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "peerutils.inc"; include_once 'navigation2.inc'; include_once "utils.inc"; include_once "ste.php"; $navTitle = "Peerweb testscript " . $PHP_SELF . " on DB " . $db_name; $page = new PageContainer(); $page->setTitle('Menu'); //$dbConn->setSqlAutoLog(true); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF); $ste->setRelation('menu'); $ste->setMenuName('menu'); $ste->setKeyColumns(array('menu_name', 'relation_name')); $ste->setNameExpression("rtrim(menu_name,' ')||', '||rtrim(relation_name,' ')"); $ste->setOrderList(array('menu_name', 'relation_name')); $ste->setFormTemplate('templates/menu.html'); $ste->setListRowTemplate(array('menu_name', 'relation_name')); $page_opening = "Menu"; $nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening); $page->addBodyComponent($nav); if (isset($_POST['Insert'])) { /* try to insert menu,column_names into menu_items */ $menu_name = $_POST['menu_name']; $relation_name = $_POST['relation_name'];
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: project_attributes_def.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "ste.php"; $page = new PageContainer("Project attributes and performance indicators on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setFormAction($PHP_SELF)->setRelation('project_attributes_def')->setMenuName('project_attributes')->setKeyColumns(array('project_attributes_def'))->setNameExpression("rtrim(pi_name)")->setListRowTemplate(array('project_attributes_def', 'pi_name', 'author', 'interpretation', 'prj_id'))->setOrderList(array('author', 'pi_name'))->setFormTemplate('templates/project_attributes_def.html')->show();
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: enumeraties.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; requireCap(CAP_SYSTEM); $page = new PageContainer("Set enumerations in menus " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page, hasCap(CAP_SYSTEM)); $ste->setFormAction($PHP_SELF)->setRelation('enumeraties')->setMenuName('enumeraties')->setKeyColumns(array('id'))->setFormTemplate('templates/enumeraties.html')->setListRowTemplate(array('id', 'menu_name', 'column_name', 'name', 'value', 'sort_order', 'is_default'))->setNameExpression("menu_name||', '||column_name")->show(); ?>
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: student_admin.php 1769 2014-08-01 10:04:30Z hom $ */ include_once "ste.php"; requireCap(CAP_LOOKUP_STUDENT); $page = new PageContainer("Student adminstration page " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page, hasCap(CAP_ALTER_STUDENT)); $ste->setFormAction($PHP_SELF)->setShowQuery(true)->setRelation('student_email')->setMenuName('student_admin')->setKeyColumns(array('snummer'))->setRawNames(array('snummer', 'class_id'))->setNameExpression("st_.snummer||' '||rtrim(achternaam,' ')||', '||rtrim(roepnaam,' ')||coalesce(' '||trim(voorvoegsel),'')")->setOrderList(array('achternaam', 'roepnaam'))->setFormTemplate('templates/student_admin.html')->setListRowTemplate(array('st_.snummer', 'minifoto', 'email1', 'pcn', 'hoofdgrp', 'sclass', 'cohort', 'gebdat', 'slb', 'studieplan', 'phone_gsm'))->setListQueryExtension(' join minifoto fo on(st_.snummer=fo.snummer) left join student_class scn using (class_id) ')->show(); ?>
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: presse.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "ste.php"; requireCap(CAP_RECRUITER); $page = new PageContainer("Peerweb presse " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true); $ste->setFormAction($PHP_SELF); $ste->setRelation('presse'); $ste->setMenuName('presse'); $ste->setKeyColumns(array('presse_id')); $ste->setNameExpression("rtrim(firma)")->setListRowTemplate(array('firma', 'firmentype', 'ort', 'email_kontaktperson', 'telefon', 'telefax', 'website'))->setOrderList(array('firma'))->setFormTemplate('templates/presse.html')->show();
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: bigface_settings.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "ste.php"; $page = new PageContainer(); $page->setTitle("Bigface settings on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF)->setRelation('bigface_settings')->setMenuName('bigface_settings')->setKeyColumns(array('bfkey'))->setNameExpression("rtrim(bfkey)")->setListRowTemplate(array('bfkey', 'bfvalue', 'comment'))->setOrderList(array('bfkey'))->setFormTemplate('templates/bigface_settings.html')->show();
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: defproject2.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; $pdj_id = 1; $milestone = 1; extract($_SESSION); $dbConn->setSqlAutoLog(true); $page = new PageContainer("Define project " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF)->setRelation('project')->setMenuName('project')->setKeyColumns(array('prj_id'))->setNameExpression("rtrim(afko)||'-'||year||': '||rtrim(description)")->setOrderList(array('year desc', 'afko', 'description'))->setListRowTemplate(array('year', 'owner_id', 'afko', 'description', 'valid_until', 'owner_id', 'comment'))->setFormTemplate('templates/project.html')->show();
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: menu_items.php 1723 2014-01-03 08:34:59Z hom $ */ require_once "ste.php"; $page = new PageContainer("Peerweb testscript " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF)->setRelation('menu_item')->setMenuName('menu_item')->setKeyColumns(array('menu_name', 'column_name'))->setListRowTemplate(array('menu_name', 'column_name', 'edit_type', 'item_length', 'regex_name', 'placeholder', 'id'))->setNameExpression("rtrim(menu_name,' ')||', '||rtrim(column_name,' ')")->setOrderList(array('menu_name', 'column_name'))->setFormTemplate('templates/menu_item.html')->show(); ?>
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: potential.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "peerutils.inc"; requireCap(CAP_TUTOR); include_once "ste.php"; $page = new PageContainer($navTitle = "Register a potential student on DB " . $db_name); $page->setTitle($navTitle); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF)->setRelation('potentials')->setMenuName('potentials')->setKeyColumns(array('pot_id'))->setFormTemplate('templates/potential.html')->setNameExpression("rtrim(achternaam,' ')||', '||rtrim(roepnaam,' ')||'('||trim(coalesce(email,'no email'))||')'")->setOrderList(array('achternaam', 'roepnaam'))->show(); ?>
<?php /** * The simple table editor for the tutor * @author Pieter van den Hombergh * $Id: tutor.php 1769 2014-08-01 10:04:30Z hom $ */ require_once "ste.php"; $title = "Tutor editor on DB {$db_name} "; $page = new PageContainer($title); $ste = new SimpleTableEditor($dbConn, $page); $ste->setShowQuery(true)->setTitle($title)->setFormAction($PHP_SELF)->setRelation('tutor')->setMenuName('tutor')->setRawNames(array('userid'))->setKeyColumns(array('userid'))->setSubRel('student')->setSubRelJoinColumns(array('userid' => 'snummer'))->setNameExpression("rtrim(tutor)")->setNameExpression("rtrim(tutor)||':'||rtrim(sub_rel.achternaam)")->setListRowTemplate(array('tu_.faculty_id', 'sub_rel.faculty_id', 'tu_.tutor', 'userid', 'team', 'sub_rel.achternaam', 'sub_rel.roepnaam'))->setOrderList(array('sub_rel.faculty_id', 'tutor'))->setFormTemplate('templates/tutor.html')->show();
<?php /** * The simple table editor for the table menu. Menu is one of the tables that support * the simple table editor. * * @package prafda2 * @author Pieter van den Hombergh * $Id: deftask.php 1723 2014-01-03 08:34:59Z hom $ */ include_once "peerutils.inc"; include_once 'navigation2.inc'; include_once "utils.inc"; include_once "ste.php"; $pdj_id = 1; $milestone = 1; extract($_SESSION); $dbConn->setSqlAutoLog(true); $page = new PageContainer("Peerweb testscript " . $PHP_SELF . " on DB " . $db_name); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF)->setRelation('project_task')->setMenuName('project_task')->setKeyColumns(array('task_id'))->setNameExpression('name')->setOrderList(array('task_id', 'name', 'description'))->setListRowTemplate(array('description', 'prj_id'))->setFormTemplate('templates/tasks.html')->show();