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