yyky/application/common/model/VisitModel.php

<?php
namespace app\common\model;

use think\Model;

/**
 * 到访记录
 *
 * @author wj
 * @date 2023-01-18
 */
class VisitModel extends Model
{

    protected $table = 't_visit';

    public function insertData($data)
    {
        $field = $this->getTableFields();
        $insertData = [];
        foreach ($field as $key => $value) {
            if (in_array($value, array_keys($data))) {
                $insertData[$value] = $data[$value];
            }
        }
        unset($insertData['id']);
        if (!isset($insertData['createtime'])) {
            $insertData['createtime'] = date("Y-m-d H:i:s");
        }
        $data = $insertData;
        $id = $this->insertGetId($data);
        return empty($id) ? false : $id;
    }

    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) {
            $sqlObj = $sqlObj->field($field)->order($order)->group($group)->page($page, $size);
            if ($row) {
                $data = $sqlObj->find();
            } else {
                $data = $sqlObj->select();
            }
        } else {
            $data = $sqlObj = $sqlObj->count();
        }
        return $data;
    }
    public function getListjoinmealcenter($where = [], $field = "*", $page = 1, $size = 10, $order = "id desc", $group = "", $row = false)
    {
        $usewhere = [];
        if (isset($where['createtime'])) {
            $usewhere[] = ['v.createtime', 'between', $where['createtime']];
        }
        if (isset($where['name']) && !empty($where['name'])) {
            $usewhere['v.name'] = ['like', "%" . $where['name'] . "%"];
        }
        if (isset($where['name_center']) && !empty($where['name_center'])) {
            $usewhere['mc.name_center'] = ['like', "%" . $where['name_center'] . "%"];
        }
        if (isset($where['telno']) && !empty($where['telno'])) {
            $usewhere['v.telno'] = ['like', "%" . $where['telno'] . "%"];
        }
        if (isset($where['is_member'])) {
            $usewhere['v.is_member'] = $where['is_member'];
        }
        if (isset($where['business_type'])) {
            $usewhere['v.business_type'] = $where['business_type'];
        }
        if (isset($where['status_delivery'])) {
            $usewhere['mo.status_delivery'] = $where['status_delivery'];
        }
        $sqlObj = $this->alias('v')->join("t_mealcenter mc", "mc.id=v.center_id")->where($usewhere);
        if ("count" != $field) {
            if ("*" == $field) {
                $field = ['v.*', 'mc.name_center'];
            }
            $sqlObj = $sqlObj->field($field)->order($order)->group($group)->page($page, $size);
            if ($row) {
                $data = $sqlObj->find();
            } else {
                $data = $sqlObj->select();
            }
        } else {
            $data = $sqlObj = $sqlObj->count();
        }
        return $data;
    }
}