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';