<?php


namespace app\model;
use app\model\BaseModel;

class NutritionSchemeExt extends BaseModel {
    //put your code here
    public function inquiryAllInfo($where=[], $orderBy=[], $field=['*']) {
        $field = ['a.train_status','a.train_time','a.nutrition_uuid','a.use_volume','a.use_method','a.use_time',
            'b.use_number','b.use_weight','b.img_path','b.name','b.power','b.carbohydrate','b.protein','b.fat','b.sodium','b.use_weight_unit',
            'c.name use_time_cn','b.use_number_unit'];
        $rows = $this
            ->alias('a')
            ->join('nutrition b', 'b.uuid = a.nutrition_uuid', 'LEFT')
            ->join('nutrition_time c', 'c.uuid = a.use_time', 'LEFT')
            ->where($where)
            ->order('c.order_no,c.id')
            ->field($field)
            ->select()
            ->toArray();
        foreach ($rows as &$plainWeightRow) {
            $plainWeightRow = \app\common\service\NutritionPlainFloatWeight::physicalForModel($plainWeightRow, $this);
        }
        unset($plainWeightRow);
        return $rows;
    }
}