$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();
if (!empty($data["blocks"])) {
<?php
$this->query("\n ALTER TABLE `application_layout_homepage`\n ADD `use_horizontal_scroll` TINYINT(1) NOT NULL DEFAULT '0' AFTER `use_more_button`,\n ADD `order` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 AFTER `position`,\n ADD `is_active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 AFTER `order`\n ;\n");
$layout = new Application_Model_Layout_Homepage();
$layouts = $layout->findAll();
$position = 0;
$positions = array();
foreach ($layouts as $layout) {
$position += 10;
$positions[$layout->getCode()] = $position;
$layout->setOrder($position);
if ($layout->getCode() == "layout_8" and !file_exists(Core_Model_Directory::getPathTo("app/design/mobile/angular/template/home/l8/view.phtml"))) {
$layout->setIsActive(false);
}
$layout->save();
}
$layouts = array(array('name' => 'Layout 3 - Horizontal', 'visibility' => Application_Model_Layout_Homepage::VISIBILITY_HOMEPAGE, 'code' => 'layout_3_h', 'preview' => '/customization/layout/homepage/layout_3-h.png', 'use_more_button' => 0, 'use_horizontal_scroll' => 1, "number_of_displayed_icons" => 6, 'position' => "bottom", "order" => $positions["layout_3"] + 5, "is_active" => 1), array('name' => 'Layout 4 - Horizontal', 'visibility' => Application_Model_Layout_Homepage::VISIBILITY_HOMEPAGE, 'code' => 'layout_4_h', 'preview' => '/customization/layout/homepage/layout_4-h.png', 'use_more_button' => 0, 'use_horizontal_scroll' => 1, "number_of_displayed_icons" => 6, 'position' => "bottom", "order" => $positions["layout_4"] + 5, "is_active" => 1), array('name' => 'Layout 5 - Horizontal', 'visibility' => Application_Model_Layout_Homepage::VISIBILITY_HOMEPAGE, 'code' => 'layout_5_h', 'preview' => '/customization/layout/homepage/layout_5-h.png', 'use_more_button' => 0, 'use_horizontal_scroll' => 1, "number_of_displayed_icons" => 4, 'position' => "bottom", "order" => $positions["layout_5"] + 5, "is_active" => 1));
foreach ($layouts as $data) {
$layout = new Application_Model_Layout_Homepage();
$layout->setData($data)->save();
}
