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