dongpai9986 2018-06-01 09:22
浏览 109
已采纳

Phalcon ORM字段与同一表中的另一个字段有关

I have the following table in my mysql DB

mysql

I have a model Shipment and i am using Phalcon's ORM to interact with my DB. The master_id field in this table is actually the id of another raw, but in the same table, as you can see in the picture. The id=1 is the Master Shipment and id=2 and id=3 are Subshipments.

My model right now looks like this

class Shipment extends Model
{
    protected $id;
    protected $hawb;
    protected $master_id;

    public function initialize()
    {
        parent::initialize();

        $this->hasMany(
            'id',
            'Shipment',
            'master_id'
        );
    }
    //setters and getters are here
}

When I am using $shipment = ShipmentModel::findFirst($id); in my Controller, i can see the master_id of the Shipment.

What i want to have is, call another function from my Shipment model in order to retrieve all the SubShipments as a Collection of Shipment models, or at least an array with Shipment models.

Or even better, if the ShipmentModel::findFirst($id); could populate the SubShipments automatically (if there are any) would be the best!

I don't really know if the $this->hasMany that I have is correct over there, so if someone could show me how to proceed I would be grateful :)

  • 写回答

1条回答 默认 最新

  • doulang9521 2018-06-01 10:12
    关注

    You need to provide full namespace, not just class name - to solve this Model 'Shipment' could not be loaded. Best is to add alias:

    $this->hasMany(
        'id',
        Shipment::class,
        'master_id',
        ['alias' => 'subShipments'])
    );
    

    And then just use:

    Shipment::findFirst()->getSubShipments() you can add such method if you want and do return $this->getRelated('subShipments')

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥60 pb数据库修改或者求完整pb库存系统,需为pb自带数据库
  • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路