ThinkPHP的关联Model要注意的几点

<?php

class RoomSupplierListModel extends RelationModel {

    protected $tableName = "room_supplier";
    public $_link;

    public function __construct($name = "") {
        $this->_link = array(
            "HotelRoomSell" => array(
                "mapping_type" => HAS_MANY,
                "parent_key" => "rs_id",//parent_key一定是主键，否则会列不出子表的数据
                "foreign_key" => "hrs_rsid",
                "condition" => " hrs_checkin_date >= "" . $_POST["stime"] . "" and hrs_checkin_date <= "" . $_POST["etime"] . "" "
            
            ),
            "Suppliers" => array(
                "mapping_type" => BELONGS_TO,
                "parent_key" => "s_id",
                "foreign_key" => "rs_sid",
                "as_fields" => "s_name"
            ),
            "Hotel" => array(
                "mapping_type" => BELONGS_TO,
                "parent_key" => "h_id",
                "foreign_key" => "rs_hid",
                "as_fields" => "h_name"
            ),
            "HotelRoom" => array(
                "mapping_type" => BELONGS_TO,
                "parent_key" => "hrm_id",
                "foreign_key" => "rs_rid",
                "as_fields" => "hrm_title,hrm_issell,hrm_id"
            ),
        );
        parent::__construct($name);
    }

}

HAS_MANY的情况下

//parent_key一定是主键，否则会列不出子表的数据

多个HAS_MANY不能指定as_fields很奇怪

<?php

class OrderListModel extends RelationModel {

    protected $tableName = "hotel_room_order";
    protected $_link = array(
        "HotelRoomOrderItem" => array(
            "mapping_type" => HAS_MANY,
            "parent_key" => "hro_id",
            "foreign_key" => "hroi_hroid",
            "mapping_fields" => "hroi_nums,hroi_checkin_date,hroi_checkout_date,hroi_price,hroi_is_checkin"
        ),
        "HotelRoomOrderTicket" => array(
            "mapping_type" => HAS_MANY,
            "parent_key" => "hro_id", //当前表的ID  很坑;不看源码不可能知道的事
            "foreign_key" => "hrot_hroid", //外表的ID
//              "mapping_fields" => "hrot_use_date,hrot_nums,hrot_price,hroi_is_checkin"
        //多个HAS_MANY的时候;只能同时存在一个 mapping_fields;否则无法查出数据;
        ),
        "Hotel" => array(
            "mapping_type" => BELONGS_TO,
            "parent_key" => "h_id",
            "foreign_key" => "hro_hid",
            "as_fields" => "h_name"
        ),
        "HotelRoom" => array(
            "mapping_type" => BELONGS_TO,
            "parent_key" => "hrm_id",
            "foreign_key" => "hro_rid",
            "as_fields" => "hrm_title"
        ),
        "AgentUser" => array(
            "mapping_type" => BELONGS_TO,
            "parent_key" => "id", //外表的ID  BELONGS_TO才有parent_key属性;
            "foreign_key" => "hro_auid", //当前表的ID
            "as_fields" => "account,nickname"
        ),
        "HotelRoomOrderMember" => array(
            "mapping_type" => HAS_ONE,
            // "parent_key" => "hro_id", //HAS_ONE,默认使用主键进行关联,没有这个属性,设置了和没设一个鸟样
            "foreign_key" => "hrom_hroid",
            "as_fields" => "hrom_name,hrom_tel"
        ),
    );

}