yyky/application/common/model/MealcookModel.php

<?php
namespace app\common\model;

use think\Model;

/**
 * 套餐菜单
 *
 * @author wj
 * @date 2022-12-07
 */
class MealcookModel extends Model
{
    protected $table = "t_mealcook";

    public function insertData($data)
    {
        if (isset($data['id'])) {
            unset($data['id']);
        }
        $data = $this->formatData($data);
        if (empty($data)) {
            return false;
        }
        $id = $this->insertGetId($data);
        return $id ? $id : false;
    }

    /**
     * 校验入库数据
     * 20220119
     */
    private function formatData($data)
    {
        $useData = [];
        $fields = $this->getTableFields();
        foreach ($data as $key => $value) {
            if (in_array($key, $fields)) {
                $useData[$key] = $value;
            }
        }
        return $useData;
    }
    public function getInfo($where, $field = "*", $row = true)
    {
        $info = $this->field($field)->where($where);
        if ($row) {
            $info = $info->find();
        } else {
            $info = $info->select();
        }
        return empty($info) ? false : $info;
    }

    public function updateinfo($where, $updateData)
    {
        $row = $this->where($where)->update($updateData);
        return empty($row) ? false : $row;
    }

    public function deleteinfo($where)
    {
        $row = $this->where($where)->delete();
        return empty($row) ? false : $row;
    }

    public function getList($where = [], $field = "*", $page = 1, $size = 10, $order = "id desc", $group = "", $row = false)
    {
        $sqlObj = $this->where($where);
        if ("count" != $field) {
            if (empty($size)) {
                $sqlObj = $sqlObj->field($field)->order($order)->group($group);
            } else {
                $sqlObj = $sqlObj->field($field)->order($order)->group($group)->page($page, $size);
            }
            if ($row) {
                $data = $sqlObj->find();
            } else {
                $data = $sqlObj->select();
            }
        } else {
            $data = $sqlObj->count();
        }
        return $data;
    }
    /**
     * 获取列表join菜单表
     *
     * @param  array   $where
     * @param  string  $field
     * @param  integer $page
     * @param  integer $size
     * @param  string  $order
     * @param  string  $group
     * @param  boolean $row
     * @return void
     * @author wj
     * @date 2022-12-07
     */
    public function getListJoinCB($where = [], $field = "*", $page = 1, $size = 10, $order = "id desc", $group = "", $row = false)
    {
        $sqlObj = $this->alias('mc')->join("t_cookbook cb", "mc.cook_id=cb.id")->where($where);
        if ("count" != $field) {
            if (empty($size)) {
                $sqlObj = $sqlObj->field($field)->order($order)->group($group);
            } else {
                $sqlObj = $sqlObj->field($field)->order($order)->group($group)->page($page, $size);
            }
            if ($row) {
                $data = $sqlObj->find();
            } else {
                $data = $sqlObj->select();
            }
        } else {
            $data = $sqlObj->count();
        }
        return $data;
    }

    /**
     * 返回当日菜单 根据中心id和套餐id
     *
     * @param  [type] $center_id
     * @param  [type] $meal_id
     * @return void
     * @author wj
     * @date 2022-12-02
     */
    public function getcooks($center_id, $meal_id)
    {
        $week = getweek();
        $where = [
            'mc.center_id' => $center_id,
            'mc.week' => $week,
            'mc.meal_id' => $meal_id,
        ];
        $field = ['mc.meal_id', 'mc.center_id', 'mc.week', 'cb.*'];
        $list = $this->getListJoinCB($where, $field, 1, 0);
        return empty($list) ? [] : $list->toArray();
    }

    /**
     * 删除cooks
     *
     * @return void
     * @author wj
     * @date 2022-12-08
     */
    public function deletecooks($where)
    {
        $row = $this->where($where)->delete();
    }
    /**
     * 获取列表 获取全部信息
     *
     * @param  array   $where
     * @param  string  $field
     * @param  integer $page
     * @param  integer $size
     * @param  string  $order
     * @param  string  $group
     * @param  boolean $row
     * @return void
     * @author wj
     * @date 2022-12-08
     */
    public function getListJoinInfo($where = [], $field = "*", $page = 1, $size = 10, $order = "id desc", $group = "", $row = false)
    {
        $sqlObj = $this->alias('mc')
            ->join("t_cookbook cb", "mc.cook_id=cb.id")
            ->join("t_mealcenter mc1", "mc.center_id=mc1.id")
            ->join("t_meal m", "mc.meal_id=m.id")
            ->where($where);
        if ("count" != $field) {
            if ('*' == $field) {
                $field = ['mc.*', 'cb.name_cook', 'cb.show_img', 'mc1.name_center', 'm.name_meal'];
            }
            if (empty($size)) {
                $sqlObj = $sqlObj->field($field)->order($order)->group($group);
            } else {
                $sqlObj = $sqlObj->field($field)->order($order)->group($group)->page($page, $size);
            }
            if ($row) {
                $data = $sqlObj->find();
            } else {
                $data = $sqlObj->select();
            }
        } else {
            $data = $sqlObj->count();
        }
        return $data;
    }
}