<?php $root = '../../..'; require_once $root . '/config/config.php'; require_once $root . '/core/mysql.php'; require_once $root . '/core/models/maincomponentsModel.php'; 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);
require_once $root . '/core/mysql.php'; require_once $root . '/core/models/suppliersModel.php'; $db = getMysqlConnection(); $supplierdata = NULL; if (!isset($_GET['Lieferant'])) { $form = array('Name' => '', 'Strasse' => '', 'Hausnr' => '', 'Ort' => '', 'PLZ' => '', 'Email' => '', 'Telefon' => '', 'Notiz' => ''); } else { $supplierdata = Model_Suppliers::getSupplierByName($db, $_GET['Lieferant']); $form = array('Name' => $supplierdata['Name'], 'Strasse' => $supplierdata['Strasse'], 'Hausnr' => $supplierdata['Hausnr'], 'Ort' => $supplierdata['Ort'], 'PLZ' => $supplierdata['PLZ'], 'Email' => $supplierdata['Email'], 'Telefon' => $supplierdata['Telefon'], 'Notiz' => $supplierdata['Notiz']); } if (isset($_POST['btnSave'])) { $form['Name'] = $_POST['lieferant']; $form['Strasse'] = $_POST['strasse']; $form['Hausnr'] = $_POST['hausnummer']; $form['Ort'] = $_POST['ort']; $form['PLZ'] = $_POST['plz']; $form['Email'] = $_POST['email']; $form['Telefon'] = $_POST['telefon']; $form['Notiz'] = $_POST['notiz']; if (!isset($_GET['Lieferant'])) { Model_Suppliers::createNewSupplier($db, $form); } else { Model_Suppliers::updateSuppliers($db, $_GET['Lieferant'], $form); } } if (isset($_POST['delete'])) { $form['Name'] = $_POST['lieferant']; Model_Suppliers::disableSupplier($db, $form); } $view = array('supplierdata' => $supplierdata, 'rootPath' => $root, 'form' => $form); require_once $root . '/views/personaldata/suppliers/suppliersFormView.php';
public function action_index() { $allSuppliers = Model_Suppliers::list_all(); $this->template->title = 'Example Page'; $this->template->content = \View::forge('view/list', array('suppliers' => $allSuppliers)); }