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