$this->query("\n ALTER TABLE `template_design_content`\n ADD CONSTRAINT `FK_TEMPLATE_DESIGN_CONTENT_DESIGN_ID` FOREIGN KEY (`design_id`) REFERENCES `template_design` (`design_id`)\n ON DELETE CASCADE ON UPDATE CASCADE;\n"); $this->query("\n ALTER TABLE `template_design_content`\n ADD CONSTRAINT `FK_TEMPLATE_DESIGN_CONTENT_OPTION_ID` FOREIGN KEY (`option_id`) REFERENCES `application_option` (`option_id`)\n ON DELETE CASCADE ON UPDATE CASCADE;\n"); // Inserting categories in 'template_category' table $categories = array("Entertainment", "Local Business", "Music"); foreach ($categories as $category_name) { $category_data = array(); $category_data['name'] = $category_name; $category_data['code'] = preg_replace('/[&\\s]+/', "_", strtolower($category_name)); $category = new Template_Model_Category(); $category->find($category_data['code'], "code"); $category->setData($category_data)->save(); } // Listing all layouts $layouts = array(); $layout = new Application_Model_Layout_Homepage(); foreach ($layout->findAll() as $layout) { $layouts[$layout->getCode()] = $layout; } // Listings all block ids $block_ids = array(); $block = new Template_Model_Block(); foreach ($block->findAll() as $block) { $block_ids[$block->getCode()] = $block->getId(); } // Inserting designs with blocks $designs = array("fairground" => array("layout_id" => $layouts["layout_3"]->getId(), "name" => "Fairground", "overview" => "/fairground/overview.png", "background_image" => "/../../images/templates/fairground/640x1136.jpg", "background_image_hd" => "/../../images/templates/fairground/1242x2208.jpg", "background_image_tablet" => "/../../images/templates/fairground/1536x2048.jpg", "icon" => "/../../images/templates/fairground/180x180.png", "startup_image" => "/../../images/templates/fairground/640x960.png", "startup_image_retina" => "/../../images/templates/fairground/640x1136.jpg", "startup_image_iphone_6" => "/../../images/templates/fairground/750x1334.png", "startup_image_iphone_6_plus" => "/../../images/templates/fairground/1242x2208.jpg", "startup_image_ipad_retina" => "/../../images/templates/fairground/1536x2048.jpg", "blocks" => array("header" => array("color" => "#323b40", "background_color" => "#ee4b63"), "subheader" => array("color" => "#323b40", "background_color" => "#fdc32f"), "connect_button" => array("color" => "#323b40", "background_color" => "#6fb7b1"), "background" => array("color" => "#323b40", "background_color" => "#f9e4d1"), "discount" => array("color" => "#ee4b63", "background_color" => "#f9e4d1"), "button" => array("color" => "#323b40", "background_color" => "#6fb7b1"), "news" => array("color" => "#323b40", "background_color" => "#f9e4d1"), "comments" => array("color" => "#", "background_color" => "#fdc32f"), "tabbar" => array("color" => "#ee4b63", "background_color" => "transparent", "image_color" => "#ee4b63"))), "pizza" => array("layout_id" => $layouts["layout_9"]->getId(), "layout_visibility" => "toggle", "name" => "Pizza", "overview" => "/pizza/overview.png", "background_image" => "/../../images/templates/pizza/640x1136.jpg", "background_image_hd" => "/../../images/templates/pizza/1242x2208.jpg", "background_image_tablet" => "/../../images/templates/pizza/1536x2048.jpg", "icon" => "/../../images/templates/pizza/180x180.png", "startup_image" => "/../../images/templates/pizza/640x960.png", "startup_image_retina" => "/../../images/templates/pizza/640x1136.jpg", "startup_image_iphone_6" => "/../../images/templates/pizza/750x1334.png", "startup_image_iphone_6_plus" => "/../../images/templates/pizza/1242x2208.jpg", "startup_image_ipad_retina" => "/../../images/templates/pizza/1536x2048.jpg", "blocks" => array("header" => array("color" => "#ffffff", "background_color" => "#00a72d"), "subheader" => array("color" => "#ffffff", "background_color" => "#e50017"), "connect_button" => array("color" => "#ffffff", "background_color" => "#00a72d"), "background" => array("color" => "#00a72d", "background_color" => "#ffffff"), "discount" => array("color" => "#ffffff", "background_color" => "#e50017"), "button" => array("color" => "#ffffff", "background_color" => "#00a72d"), "news" => array("color" => "#00a72d", "background_color" => "#ffffff"), "comments" => array("color" => "#ffffff", "background_color" => "#00a72d"), "tabbar" => array("color" => "#00a72d", "background_color" => "#ffffff", "image_color" => "#00a72d"))), "dj" => array("layout_id" => $layouts["layout_2"]->getId(), "name" => "DJ", "overview" => "/dj/overview.png", "background_image" => "/../../images/templates/dj/640x1136.jpg", "background_image_hd" => "/../../images/templates/dj/1242x2208.jpg", "background_image_tablet" => "/../../images/templates/dj/1536x2048.jpg", "icon" => "/../../images/templates/dj/180x180.png", "startup_image" => "/../../images/templates/dj/640x960.png", "startup_image_retina" => "/../../images/templates/dj/640x1136.jpg", "startup_image_iphone_6" => "/../../images/templates/dj/750x1334.png", "startup_image_iphone_6_plus" => "/../../images/templates/dj/1242x2208.jpg", "startup_image_ipad_retina" => "/../../images/templates/dj/1536x2048.jpg", "blocks" => array("header" => array("color" => "#404040", "background_color" => "#e0c341"), "subheader" => array("color" => "#404040", "background_color" => "#f0d970"), "connect_button" => array("color" => "#404040", "background_color" => "#e0c341"), "background" => array("color" => "#f0d970", "background_color" => "#b65c12"), "discount" => array("color" => "#404040", "background_color" => "#e0c341"), "button" => array("color" => "#b65c12", "background_color" => "#e0c341"), "news" => array("color" => "#f0d970", "background_color" => "#b65c12"), "comments" => array("color" => "#404040", "background_color" => "#e0c341"), "tabbar" => array("color" => "#e0c341", "background_color" => "transparent", "image_color" => "#e0c341"))), "blank" => array("layout_id" => $layouts["layout_1"]->getId(), "name" => "Blank", "overview" => "/blank/overview.png", "background_image" => "/../../images/application/placeholder/no-background.jpg", "background_image_hd" => "/../../images/application/placeholder/no-background-hd.jpg", "background_image_tablet" => "/../../images/application/placeholder/no-background-tablet.jpg", "icon" => "/../../images/application/placeholder/no-image.png", "startup_image" => "/../../images/application/placeholder/no-startupimage.png", "startup_image_retina" => "/../../images/application/placeholder/no-startupimage-retina.png", "startup_image_iphone_6" => "/../../images/application/placeholder/no-startupimage-iphone-6.png", "startup_image_iphone_6_plus" => "/../../images/application/placeholder/no-startupimage-iphone-6-plus.png", "startup_image_ipad_retina" => "/../../images/application/placeholder/no-startupimage-tablet.png")); foreach ($designs as $code => $data) { $design = new Template_Model_Design(); $design->find($code, "code"); if (!$design->getId()) { $design->setData($data)->setCode($code)->save();
<?php $this->query("\n ALTER TABLE `application_layout_homepage`\n ADD `code` VARCHAR(10) NOT NULL AFTER `layout_id`;\n"); $layout = new Application_Model_Layout_Homepage(); $layouts = $layout->findAll(); foreach ($layouts as $key => $layout) { $layout->setCode("layout_" . $key)->setName("Layout " . $key)->save(); } $layout = new Application_Model_Layout_Homepage(); $layout->setData(array('code' => 'layout_8', 'name' => 'Layout 8', 'preview' => '/customization/layout/homepage/layout_8.png', 'use_more_button' => 0, 'position' => 80))->save();