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