Question

我正试图为我的用户实施简单的信息发布系统。

我不是一位惯常的专家,因此任何援助都将受到赞赏。

在这方面,我要提出任何建议! (cake1.3)

CREATE TABLE IF NOT EXISTS `app_messages` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `from_user_id` int(8) unsigned DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `body` text,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `app_messages_users` (
  `id` int(8) unsigned NOT NULL,
  `message_id` int(8) unsigned NOT NULL,
  `to_user_id` int(8) unsigned NOT NULL,
  `read` tinyint(1) DEFAULT  0 ,
  `replied` tinyint(1) NOT NULL DEFAULT  0 ,
  `trash` tinyint(1) NOT NULL DEFAULT  0 ,
  PRIMARY KEY (`id`)
);

Message.php
var $hasAndBelongsToMany = array(
         User  =>
            array(
                 className               =>  User ,
                 joinTable               =>  messages_users ,
                 foreignKey              =>  message_id ,
                 associationForeignKey   =>  to_user_id ,
                 unique                  => true
            )
    );


User.php
var $hasMany = array(        
         Message  => array(            
             className  =>  message ,            
             foreignKey  =>  from_user_id ,
             dependent      => true       
        )

因此,我现在的问题是,我这样做吗?

How do I go around creating a SEND MESSAGE function, to insert correct values to both tables? I am a total noob regarding HABTM relationships, but I am trying to learn. Have spent several hours reading about it on the web, but still, need to ask if I am going the right way.

Thanks for your time!! -Tom

Answer 1

鉴于您的加入表有其他领域(read,replied,trash),你不应使用现金转拨系统关系。如果是的话,你一定能够从你的申请中获取。因此,你应该通过新的模式,召集两个慈善协会。详细解释如下:here in the CookBook 。

因此,你不得不放弃这样的东西:

// User.php
class User extends AppModel {
    public $hasMany = array(
         MessageUser  /* you can call this  SentMessage  or something that makes more sense */
    );
}

// Message.php

class Message extends AppModel {
    public $hasMany = array(
         MessageUser 
    );
}

// MessageUser.php

class MessageUser extends AppModel {
    public $belongsTo = array(
         User ,  Message 
    );
}

友情链接