for landingPage model make method
public function getLpBlocks()
{
}
* receive LpBlock's for LandingPage
* 1. from relations with lpWidgets
* 2. block for LandingPage it is block's LpType
what is difference these two methods
thanc you in advance
tables here
CREATE TABLE lpType
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
name
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
slug
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
rule
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
route
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
view
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
lpName
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
lpBody
text COLLATE utf8_unicode_ci,
lpMetaTitle
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
lpMetaKeywords
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
lpMetaDescription
varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id
),
UNIQUE KEY UK_slug
(slug
)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE lpWidget
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
landingPageId
int(11) unsigned DEFAULT NULL,
blockId
int(11) unsigned NOT NULL,
widgetId
int(11) unsigned NOT NULL,
sort
smallint(6) unsigned NOT NULL DEFAULT ‘0’,
options
text COLLATE utf8_unicode_ci,
PRIMARY KEY (id
),
KEY K_lpId_blockId_sort
(landingPageId
,blockId
,sort
),
KEY K_blockId
(blockId
),
KEY K_widgetId
(widgetId
),
CONSTRAINT FK_lpBlock_id
FOREIGN KEY (blockId
) REFERENCES lpBlock
(id
) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT FK_lpWidget_landingPageId
FOREIGN KEY (landingPageId
) REFERENCES landingPage
(id
) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT FK_widget_id
FOREIGN KEY (widgetId
) REFERENCES widget
(id
) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE lpBlock
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
typeId
int(11) unsigned NOT NULL,
name
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
slug
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (id
),
UNIQUE KEY UK_slug_typeId
(slug
,typeId
),
KEY K_typeId
(typeId
),
CONSTRAINT FK_lpType_id
FOREIGN KEY (typeId
) REFERENCES lpType
(id
) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE landingPage
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
lpTypeId
int(11) unsigned NOT NULL,
url
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
name
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
body
text COLLATE utf8_unicode_ci,
metaTitle
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
metaKeywords
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
metaDescription
varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
semanticKernel
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id
),
UNIQUE KEY UK_url
(url
),
KEY K_lpTypeId
(lpTypeId
),
CONSTRAINT FK_landingPage_lpTypeId
FOREIGN KEY (lpTypeId
) REFERENCES lpType
(id
) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;