public function actionIndex()
{
$messages = [];
$tablesData = new TablesData();
$messages[] = $tablesData->createVendor();
$messages[] = $tablesData->createTransport();
$messages[] = $tablesData->createFK(['table' => 'transport', 'column' => 'id_vendor'], ['table' => 'vendor', 'column' => 'id']);
$messages[] = $tablesData->createPassport();
$messages[] = $tablesData->createFK(['table' => 'passport', 'column' => 'id_transport'], ['table' => 'transport', 'column' => 'id']);
$messages[] = $tablesData->createProperties();
$messages[] = $tablesData->createTransportProperties();
$messages[] = $tablesData->createFK(['table' => 'transport_properties', 'column' => 'id_transport'], ['table' => 'transport', 'column' => 'id']);
$messages[] = $tablesData->createFK(['table' => 'transport_properties', 'column' => 'id_properties'], ['table' => 'properties', 'column' => 'id']);
$template = $this->twig->loadTemplate('create-tables/index.tpl');
echo $template->render(array('messages' => $messages));
}
public function actionIndex()
{
$tablesData = new TablesData();
$exist = $tablesData->checkTablesExist(['transport', 'passport', 'vendor', 'properties', 'transport_properties']);
if (is_array($exist)) {
$template = $this->twig->loadTemplate('index/tables_not_exist.tpl');
echo $template->render(array('messages' => $exist));
return false;
}
$vendors = new Vendor();
$vendors = $vendors->findAll();
$template = $this->twig->loadTemplate('index/_item_vendor.tpl');
echo $template->render(array('models' => $vendors));
$properties = new Properties();
$properties = $properties->findAll();
$template = $this->twig->loadTemplate('index/_item_properties.tpl');
echo $template->render(array('models' => $properties));
$transports = new Transport();
$transports = $transports->findAll();
$template = $this->twig->loadTemplate('index/_item_transports.tpl');
echo $template->render(array('models' => $transports));
}
