PHP Model_Maincomponents Examples

Example #1

File: subcomponentsFormController.php Project: HHH333III/Schulverwaltung

<?php

$root = '../../..';
require_once $root . '/config/config.php';
require_once $root . '/core/mysql.php';
require_once $root . '/core/models/subcomponentsModel.php';
require_once $root . '/core/models/maincomponentsModel.php';
$db = getMysqlConnection();
$maincomponents = null;
$maincomponents = Model_Maincomponents::getAllMaincomponents($db);
if (isset($_POST['save'])) {
    /*
    $maincomponents = array(
    	'Beschreibung' => $_POST['beschreibung'],
    	'Seriennummer' => $_POST['seriennummer'],
    	'Gewaehrleistungsdauer' => $_POST['gewaehrleistungsdauer'],
    	'FK_Komponentenart' => $_POST['art'],
    	'FK_Raum' => $_POST['raum'],
    	'Einkaufsdatum' => $_POST['einkaufdatum'],
    	'Hersteller' => $_POST['hersteller'],
    	'FK_Lieferant' => $_POST['lieferant'],
    	'Notiz' => $_POST['notiz']
    );
    
    Model_Maincomponents::createNewMaincomponent($db, $maincomponentdata);
    */
}
$view = array('maincomponentdata' => $maincomponents, 'rootPath' => $root);
require_once $root . '/views/maincomponents/maincomponentsFormView.php';

Example #2

File: maincomponentsFormController.php Project: HHH333III/Schulverwaltung

require_once $root . '/core/models/roomsModel.php';
require_once $root . '/core/models/suppliersModel.php';
$db = getMysqlConnection();
$maincomponentdata = NULL;
$maincomponentTypes = Model_Maincomponents::getMaincomponentTypes($db);
$rooms = Model_Rooms::getAllRooms($db);
$suppliers = Model_Suppliers::getAllSuppliers($db);
if (!isset($_GET['Seriennummer'])) {
    $form = array('txtDescription' => '', 'txtSerialNumber' => '', 'txtWarrantyYears' => '', 'cmbComponentType' => '', 'cmbRoomNumber' => '', 'txtBuyDate' => '', 'txtManufacturer' => '', 'cmbSupplierID' => '', 'txtNote' => '');
} else {
    $maincomponentdata = Model_Maincomponents::getMaincomponentBySerialNumber($db, $_GET['Seriennummer']);
    $form = array('txtDescription' => $maincomponentdata['Beschreibung'], 'txtSerialNumber' => $maincomponentdata['Seriennummer'], 'txtWarrantyYears' => $maincomponentdata['Gewaehrleistungsdauer'], 'cmbComponentType' => $maincomponentdata['FK_Komponentenart'], 'cmbRoomNumber' => $maincomponentdata['FK_Raum'], 'txtBuyDate' => $maincomponentdata['Einkaufsdatum'], 'txtManufacturer' => $maincomponentdata['Hersteller'], 'cmbSupplierID' => $maincomponentdata['FK_Lieferant'], 'txtNote' => $maincomponentdata['Notiz']);
}
if (isset($_POST['btnSave'])) {
    $form['txtDescription'] = $_POST['txtDescription'];
    $form['txtSerialNumber'] = $_POST['txtSerialNumber'];
    $form['txtWarrantyYears'] = $_POST['txtWarrantyYears'];
    $form['cmbComponentType'] = $_POST['cmbComponentType'];
    $form['cmbRoomNumber'] = $_POST['cmbRoomNumber'];
    $form['txtBuyDate'] = $_POST['txtBuyDate'];
    $form['txtManufacturer'] = $_POST['txtManufacturer'];
    $form['cmbSupplierID'] = $_POST['cmbSupplierID'];
    $form['txtNote'] = $_POST['txtNote'];
    if (!isset($_GET['Seriennummer'])) {
        Model_Maincomponents::createNewMaincomponent($db, $form);
    } else {
        Model_Maincomponents::updateMaincomponent($db, $_GET['Seriennummer'], $form);
    }
}
$view = array('form' => $form, 'maincomponentTypes' => $maincomponentTypes, 'rooms' => $rooms, 'rootPath' => $root, 'suppliers' => $suppliers);
require_once $root . '/views/maincomponents/maincomponentsFormView.php';