PHP.38-TP Framework Mall Application Example-backstage 15-commodity properties vs. stock 1-Different products (unique attributes, optional attributes), property type

Source: Internet
Author: User
Tags value store


1, different products belong to different types, such as: mobile phones, clothing, computers and other types

2. Different types have different attributes, which are divided into unique attributes and optional attributes, such as clothing: Optional attribute {size: s,m,l ...; Color: white, black ... } Unique Properties: Material

First, associate the type with the attribute.

1. Build a table

Type table {P39_type}

if exists p39_type;create table P39_type (    null auto_increment comment ' Id ',    type_name varchar (null comment ' type name ',    key  (ID)) enginedefault Charset=utf8 comment ' type ';

property sheet {P39_attribute}

drop tableifexists p39_attribute;create table P39_attribute (id mediumint unsigned notNULLAuto_increment comment ' Id ',attr_name varchar (() notNULLComment ' attribute name ',attr_type enum (' Unique ', ' optional ') notNULLComment ' attribute type ',attr_option_values varchar () notNULL default"comment" attribute optional value, separated by commas multiple values ',type_id mediumint unsigned unsigned notNULLComment ' belongs to type ',PrimaryKey(ID),Keytype_id (type_id)) engine=innodbdefaultCharset=utf8 Comment ' attribute table ';

2. GII automatically generates two-sheet operation codes


1, before generating the type table code, in the configuration file p39_type.php, be careful to add verification that checks whether the type name is duplicated, and does not require the search function "type data level is small"

2 , before generating the property sheet code, in the configuration file P39_arrtribute, delete the unnecessary search field

3. Adjust the generated code to make it more suitable

1, the type changed to drop-down box, applicable to the pre-packaged drop-down function buildselect (' table name ', ' drop-down box name ', ' drop-down box ' value [table field] ', ' table field text ', ' optional value ')

functionBuildselect ($tableName,$selectName,$valueFieldName,$textFieldName,$selectedValue= ' ')    {        $model= D ($tableName); $data=$model->field ("$valueFieldName,$textFieldName")->select ();//take two field values as needed        $select= "<select name="$selectName' ><option value= ' > Please select </option> ";//The drop-down box name is stored in the table field        foreach($data  as $k=$v)        {            $value=$v[$valueFieldName];//Value <= field value "Table ID"            $text=$v[$textFieldName];//Display content <= field value Store content            if($selectedValue&&$selectedValue==$value)//decide whether to select                $selected= ' selected= ' selected "'; Else                $selected= ' '; $select. = ' <option '.$selected. ' Value= '.$value.‘" > '.$text.‘ </option> '; }        $select. = ' </select> '; Echo $select; }

2, the property optional value of the Chinese comma case processing

Delete Type

When you delete a type, all properties under the corresponding type are deleted

idea: Delete all properties {_before_delete ()} before deleting the type code TypeModel.class.php execution

PHP.38-TP Framework Mall Application Example-backstage 15-commodity properties vs. stock 1-Different products (unique attributes, optional attributes), property type

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.