TP5关联模型 一对多 字段别名 easyui tree

一、模型

1.生产计划。包括年月日 

class Plan extends Model
{
    protected $table = 'tplan';
    protected $pk = 'rd';
    public function children() { //建立一对多关联
        return $this->hasMany('PlanProduct','plan_id','rd');->field('rd,plan_id,plan_id  as id, product_id as text');//必须包含主键rd
    }//end function children
}
2.生产计划中的产品。需要生产的产品列表

class PlanProduct extends Model
{
    protected $table = 'tplanproduct';
    protected $pk = 'rd';

    public function children() {

        //建立一对一关联 让被关联的字段附在主表行上返回
        return $this->hasOne('Product','id','product_id')->bind([
                'text' =>'name',
                'id',
            ]);
    }//end function children
}

3.产品表

class Product extends Model
{
    protected $table = 'tproduct';
    protected $pk = 'rd';
}

二、控制器调用  

$list = Plan::with(['children','children.children'])
      ->Distinct(true)->field('nweek  as id, nweek  as text,nyear,nmonth,rd')
      ->order(['nyear'=>'desc','nmonth'=>'desc','nweek'=>'desc'])
      ->where(['nyear'=>'2019','nmonth'=>'3'])
      ->select();
      // dump($list);
      echo $list->toJson();

三、在浏览器上显示的结果

array(2) {
  [0] => array(6) {
    ["id"] => int(2)
    ["text"] => int(2)
    ["nyear"] => int(2019)
    ["nmonth"] => int(3)
    ["rd"] => int(7)
    ["children"] => array(0) {
    }
  }
  [1] => array(6) {
    ["id"] => int(1)
    ["text"] => int(1)
    ["nyear"] => int(2019)
    ["nmonth"] => int(3)
    ["rd"] => int(6)
    ["children"] => array(2) {
      [0] => array(9) {
        ["rd"] => int(1)
        ["plan_id"] => int(6)
        ["product_id"] => string(2) "01"
        ["order_quantity"] => int(10)
        ["order_time"] => int(0)
        ["start_time"] => int(0)
        ["end_time"] => int(0)
        ["text"] => string(5) "QTZ63"
        ["id"] => string(2) "01"
      }
      [1] => array(9) {
        ["rd"] => int(2)
        ["plan_id"] => int(6)
        ["product_id"] => string(2) "02"
        ["order_quantity"] => int(0)
        ["order_time"] => int(0)
        ["start_time"] => int(0)
        ["end_time"] => int(0)
        ["text"] => string(3) "120"
        ["id"] => string(2) "02"
      }
    }
  }
}

[{"id":2,"text":2,"nyear":2019,"nmonth":3,"rd":7,"children":[]},{"id":1,"text":1,"nyear":2019,"nmonth":3,"rd":6,"children":[{"rd":1,"plan_id":6,"product_id":"01","order_quantity":10,"order_time":0,"start_time":0,"end_time":0,"text":"QTZ63","id":"01"},{"rd":2,"plan_id":6,"product_id":"02","order_quantity":0,"order_time":0,"start_time":0,"end_time":0,"text":"120","id":"02"}]}]