<?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 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: 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 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 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: 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: 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_part.php 1724 2014-01-03 09:06:02Z hom $
*/
require_once "ste.php";
$title = "Module Part Editor On DB {$db_name} ";
$page = new PageContainer("Module part on DB {$db_name} ");
$ste = new SimpleTableEditor($dbConn, $page);
$ste->setShowQuery(true)->setTitle($title)->setFormAction($PHP_SELF)->setRelation('module_part')->setMenuName('module_part')->setKeyColumns(array('module_part_id'))->setNameExpression("rtrim(progress_code)||':'||rtrim(part_description)")->setListRowTemplate(array('progress_code', 'part_description', 'credits'))->setOrderList(array('progress_code'))->setFormTemplate('templates/module_part.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: 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 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: 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 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 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();
<?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 tutor
* @author Pieter van den Hombergh
* $Id: tutor.php 1709 2013-12-08 07:56:27Z hom $
*/
require_once "ste.php";
$page = new PageContainer("Country table {$db_name} ");
$ste = new SimpleTableEditor($dbConn, $page);
$ste->setShowQuery(true)->setTitle("country codes")->setFormAction($PHP_SELF)->setRelation('iso3166')->setMenuName('iso3166')->setKeyColumns(array('number'))->setNameExpression("rtrim(country)")->setListRowTemplate(array('country', 'a2', 'a3', 'number', 'country_by_lang', 'land_nl'))->setOrderList(array('a3'))->setFormTemplate('templates/iso3166.html')->show();
