Ako insertovať do dvoch tabuliek cez formulár

ondrej256 napsal(a):

Pracoval jsi už někdy v nette s databází?
Jakou používáš databázovou vstvu?
Můžeš sem přidat tvůj kód?

Hej ale až tak rozsiahle nie :)
Nette\DB

<?php
namespace App\Presenters;
use Nette;
use Nette\Utils\Html;
use Nette\Utils\Random;
use Nette\Application\UI\Form;
use Nette\Templating\FileTemplate;
use Nette\Latte\Engine;
use Nette\Templating\Helpers;
use App\Repository\ClientsRepository;
use App\Repository\MonthsRepository;
use App\Repository\PaymentsRepository;

class ZanechtujSaPresenter extends CommandPresenter {
	/** @persistent */
    public $backlink = '';

	/** @var MonthsRepository */
	public $monthsRepository;

	/** @var ClientsRepository */
	public $clientsRepository;

	/** @var PaymentsRepository */
  	public $paymentsRepository;

	public function __construct(MonthsRepository $monthsRepository, ClientsRepository $clientsRepository, PaymentsRepository $paymentsRepository) {
		$this->monthsRepository = $monthsRepository;
		$this->clientsRepository = $clientsRepository;
		$this->paymentsRepository = $paymentsRepository;
	}

	public function beforeRender() {
		$id = (int) $this->getParameter('id');
		$selectMonths = $this->monthsRepository->findAll()
		->where(':dates.months_id');
		$this->template->Months = $selectMonths;
	}

	protected function createComponentZanechtujsaForm() {
		$form = new Form;
		$form->addText('fullName', 'Meno a Priezvisko')
			 ->setRequired('Meno a Priezvisko musí byť vyplnené!')
			 ->setAttribute('class', 'form-control noRadius');
		$form->addText('email', 'Emailová adresa')
			 ->setAttribute('class', 'form-control noRadius')
			 ->addRule(Form::EMAIL, 'Zadajte platnú emailovú adresu!');
		$actions = [
		    'Klasická objednávka',
			'Akcia Nevesta',
			'Oslávenkyňa'
		];
		$form->addSelect('action', 'Akcia', array_combine($actions, $actions))
			 ->setAttribute('class', 'chosen-select noRadius');
		$services = [
			'Gelové nechty',
			'Akrilové nechty',
			'Doplnenie'
		];
		$form->addSelect('service', 'Služba', array_combine($services, $services))
			 ->setAttribute('class', 'chosen-select noRadius');
		$form->addText('dateOrder', 'Dátum objednania')
			 ->setAttribute('class', 'form-control noRadius')
			 ->setAttribute('id', 'date')
			 ->setRequired('Dátum objednania musí byť vyplnený!');
		$times = [
			'09:00 - 11:00',
			'13:00 - 15:00',
			'15:00 - 17:00'
		];
		$form->addSelect('timeOrder', 'Čas', array_combine($times, $times))
			 ->setAttribute('class', 'chosen-select noRadius');
		$form->addSubmit('sendForm', 'Odoslať');
		$form->onSuccess[] = $this->zanechtujsaFormSuccessSubmitted;
		$form->elementPrototype->novalidate("novalidate");
		return $form;
	}

	public function zanechtujsaFormSuccessSubmitted(Form $form, $id = 0) {
		$values = $form->getValues();
		$values->orderID = Random::generate(7, '0-9');
		$values->date_created = date('d.m.Y');
		$values->time_created = date('H:i:s');
		$values->status = 'Pending';
		$values->amount = '0,00';
		$values->tringelt = '0,00';
		$values->payment_status = 'Neuhradené';
		$this->clientsRepository->insert($values);

		$values->amout = '0.00';
		$values->tringelt = '0.00';
		$values->payment_status = 'Neuhradené';
		$values->clients_id = $this->clientsRepository->findAll()
		->where(':payments.clients_id');
		$values->paymentsRepository->insert($values);

		$orderID = $values->orderID;
		$fullName = $values->fullName;
		$email = $values->email;
		$action = $values->action;
		$service = $values->service;
		$dateOrder = $values->dateOrder;
		$timeOrder = $values->timeOrder;

		$this->flashMessage(
			array(
				'orderID' => $orderID,
				'fullName' => $fullName,
				'email' => $email,
				'action' => $action,
				'service' => $service,
				'dateOrder' => $dateOrder,
				'timeOrder' => $timeOrder
				), 'success');
		$this->redirect(':ZanechtujSa:success');
	}
}

David Matějka napsal(a):

metoda insert ti vrati radek s vlozenym zaznamem, takze i id

Prepáč ale teraz nerozumiem…

@SontoEremo a nezabudni si tie inserty obalit transakciou.

• https://api.nette.org/…ext.php.html#… (begin, commit, rollback).

Takhle:

$this->database->beginTransaction();
$client = $this->database->table('clients')->insert(array(...));
$payment = $this->database->table('payments')->insert(array('clients_id' => $client->id, ...));
$this->database->commit();

@Zuben45 Transakce proběhne celá nebo vůbec, tzn. pokud by jsi byl banka a někdo by zaplatil, peníze by to odečetlo. Najednou by se něco pokazilo (spadl server apod.), tak by nenastalo přičtení do druhého účtu, čímž by jsi nezaplatil, i když by byly peníze odečteny.
Když použiješ transakce, a např. server spadne, vrátí se to předešlého stavu před transakcí.

Editoval Vastlik (18. 12. 2015 16:11)

Vvdokumentaci kazdyho databazovyho systemu to je…