医院预约管理系统开发 代码展示 九价疫苗接种预约功能（含小程序源代码）

news/2024/7/20 2:44:37 标签: 小程序, lavarel, 前端, 后端, php, mvc, sql

基于微信小程序的疫苗预约系统让疫苗信息，疫苗预约信息等相关信息集中在后台让管理员管理，让用户在小程序端预约疫苗，查看疫苗预约信息，该系统让信息管理变得高效，也让用户预约疫苗，查看疫苗预约等信息变得越来越方便。

一、项目简述
本系统功能包括：
1、疫苗添加、修改、删除等管理
2、接种点管理（接种点、工作人员）
3、预约跟进（预约、签到、预检、接种、留观、留观历史）
4、用户管理

1、小程序预约的界面展示

在这里插入图片描述

2、医生管理控制器

php"><?php
namespace app\store\controller;
use app\store\model\Doctors as DoctorsModel;

/**
 * 医生管理控制器
 * Class Doctors
 * @package app\store\controller
 */
class Doctors extends Controller
{
    /**
     * 医生列表
     * @return mixed
     * @throws \think\exception\DbException
     */
    public function index()
    {
        $model = new DoctorsModel;
        $list = $model->getList();
        // return json($list);
        return $this->fetch('index', compact('list'));
    }

3、添加医生

php">    /**
     * 添加医生
     * @return array|mixed
     */
    public function add()
    {
        if (!$this->request->isAjax()) {
            return $this->fetch('add');
        }
        $model = new DoctorsModel;
        if ($model->add($this->postData('doctors'))) {
            return $this->renderSuccess('添加成功', url('doctors/index'));
        }
        $error = $model->getError() ?: '添加失败';
        return $this->renderError($error);
    }

    /**
     * 删除医生
     * @param $doctors_id
     * @return array
     * @throws \think\exception\DbException
     */
    public function delete($doctors_id)
    {
        $model = DoctorsModel::get($doctors_id);
        if (!$model->remove()) {
            return $this->renderError('删除失败');
        }
        return $this->renderSuccess('删除成功');
    }

4、医生编辑

php">    /**
     * 医生编辑
     * @param $doctors_id
     * @return array|mixed
     * @throws \think\exception\DbException
     */
    public function edit($doctors_id)
    {
        // 商品详情
        $model = DoctorsModel::detail($doctors_id);
        if (!$this->request->isAjax()) {
            return $this->fetch('edit', compact('model'));
        }
        // 更新记录
        if ($model->edit($this->postData('doctors'))) {
            return $this->renderSuccess('更新成功', url('doctors/index'));
        }
        $error = $model->getError() ?: '更新失败';
        return $this->renderError($error);
    }

}

5、订单管理

php"><?php

namespace app\store\controller;

use app\store\model\Order as OrderModel;

/**
 * 订单管理
 * Class Order
 * @package app\store\controller
 */
class Order extends Controller
{
    /**
     * 待发货订单列表
     * @return mixed
     * @throws \think\exception\DbException
     */
    public function delivery_list()
    {
        return $this->getList('待发货订单列表', [
            'pay_status' => 20,
            'delivery_status' => 10
        ]);
    }

php">
    /**
     * 已付款订单列表
     * @return mixed
     * @throws \think\exception\DbException
     */
    public function receipt_list()
    {
        return $this->getList('已付款订单列表', ['status' => 1]);
    }

    /**
     * 待付款订单列表
     * @return mixed
     * @throws \think\exception\DbException
     */
    public function pay_list()
    {
        return $this->getList('待付款订单列表', ['status' => 0]);
    }

    /**
     * 已完成订单列表
     * @return mixed
     * @throws \think\exception\DbException
     */
    public function complete_list()
    {
        return $this->getList('已完成订单列表', ['status' => 2]);
    }

    /**
     * 已取消订单列表
     * @return mixed
     * @throws \think\exception\DbException
     */
    public function cancel_list()
    {
        return $this->getList('已取消订单列表', ['status' => -1]);
    }

    /**
     * 全部订单列表
     * @return mixed
     * @throws \think\exception\DbException
     */
    public function all_list()
    {
        return $this->getList('全部订单列表');
    }

6、订单列表、订单详情控制器

php">    /**
     * 订单列表
     * @param $title
     * @param $filter
     * @return mixed
     * @throws \think\exception\DbException
     */
    private function getList($title, $filter = [])
    {
        $model = new OrderModel;
        $list = $model->getList($filter);
        return $this->fetch('index', compact('title','list'));
    }

    /**
     * 订单详情
     * @param $order_id
     * @return mixed
     * @throws \think\exception\DbException
     */
    public function detail($order_id)
    {
        $detail = OrderModel::detail($order_id);
        return $this->fetch('detail', compact('detail'));
    }

7、确认发货

php">    /**
     * 确认发货
     * @param $order_id
     * @return array
     * @throws \think\exception\DbException
     */
    public function delivery($order_id)
    {
        $model = OrderModel::detail($order_id);
        if ($model->delivery($this->postData('order'))) {
            return $this->renderSuccess('发货成功');
        }
        $error = $model->getError() ?: '发货失败';
        return $this->renderError($error);
    }

}

8、在后台设置可以进行预约接种疫苗的时间段

在这里插入图片描述

9、疫苗上架的功能界面图：

在这里插入图片描述

10、订阅的用户信息管理

在这里插入图片描述

11、预约的用户信息管理

在这里插入图片描述

12、预约的用户信息管理详情页，后台管理员也可以手动为客户修改预约日期

在这里插入图片描述

13、导出订阅用户

php"><?php
namespace app\store\controller;
use think\Db;
use think\Log;

Class Output extends Controller
{
	/**
	 * 导出订阅用户
	 */
	public function outExcel(){
		vendor("PHPExcel.PHPExcel");
		//实例化phpexcel对象
		$objPHPExcel = new \PHPExcel();
		$orders = session('output_orders');
		// 给表格添加数据
		$objPHPExcel->setActiveSheetIndex(0)
		            ->setCellValue('A1', '名字')
		            ->setCellValue('B1', '排号')
		            ->setCellValue('C1', '电话')
					->setCellValue('D1', '疫苗种类')
					->setCellValue('E1', '年龄')
					->setCellValue('F1', '出生日期')
					->setCellValue('G1', '身份证号')
					->setCellValue('H1', '发货状态')
					->setCellValue('I1', '订阅时间')
					->setCellValue('J1', '发货时间')
					->setCellValue('K1', '渠道来源')
					->setCellValue('L1', '分销员');
		$arr = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L'];
		$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10);
		$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
		$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(10);
		$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(25);
		$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
		$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
		$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(15);
		for($i = 0; $i < count($arr); $i++){
			$objPHPExcel->getActiveSheet()->getStyle($arr[$i].'1')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->getStyle($arr[$i].'1')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle($arr[$i].'1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle($arr[$i].'1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		}
		$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(30);
		for($i = 2; $i <= count($orders) + 1; $i++){
			$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('C'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('C'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('D'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('D'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('E'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('E'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('F'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('F'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('K'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('K'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('L'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('L'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			if($orders[$i-2]['deliver_status'] == '1'){
				$deliver_status = "已发货";
			}elseif($orders[$i-2]['deliver_status'] == '-1'){
				$deliver_status = "已过期";
			}else{
				$deliver_status = "未发货";
			}
			$minus_time = time() - strtotime($orders[$i-2]['birthday']);
			$age = floor($minus_time/3600/24/365);
			$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $orders[$i-2]['user_name']);
			$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $orders[$i-2]['subscribe_id']);
			$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $orders[$i-2]['telephone']);
			$objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $orders[$i-2]['vaccines']);
			$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, $age);
			$objPHPExcel->getActiveSheet()->setCellValue('F' . $i, $orders[$i-2]['birthday']);
			$objPHPExcel->getActiveSheet()->setCellValue('G' . $i, $orders[$i-2]['idcard']."\t");
			$objPHPExcel->getActiveSheet()->setCellValue('H' . $i, $deliver_status);
			$objPHPExcel->getActiveSheet()->setCellValue('I' . $i, $orders[$i-2]['create_time']);
			$objPHPExcel->getActiveSheet()->setCellValue('J' . $i, $orders[$i-2]['deliver_time']);
			$objPHPExcel->getActiveSheet()->setCellValue('K' . $i, $orders[$i-2]['channel']);
			$objPHPExcel->getActiveSheet()->setCellValue('l' . $i, $orders[$i-2]['name']);
		}
		$objPHPExcel->getActiveSheet()->setTitle('订阅用户');
		//激活当前表
		$objPHPExcel->setActiveSheetIndex(0);
		ob_end_clean();//清除缓冲区,避免乱码
		$name = '订阅用户_'.date('YmdHis').'.xlsx';
		//弹出提示下载文件
		header('pragma:public');
		header("Content-Disposition:attachment;filename=".$name);
		header('Cache-Control: max-age=0');
		$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
		$objWriter->save('php://output');
	}

14、导出预约用户Excel表单

php">	/**
	 * 导出预约用户
	 */
	public function outExcel2(){
		vendor("PHPExcel.PHPExcel");
		//实例化phpexcel对象
		$objPHPExcel = new \PHPExcel();
		$orders = session('output_orders2');
		// 给表格添加数据
		$objPHPExcel->setActiveSheetIndex(0)
		            ->setCellValue('A1', '名字')
		            ->setCellValue('B1', '针次')
		            ->setCellValue('C1', '电话')
					->setCellValue('D1', '疫苗种类')
					->setCellValue('E1', '年龄')
					->setCellValue('F1', '出生日期')
					->setCellValue('G1', '身份证号')
					->setCellValue('H1', '接种状态')
					->setCellValue('I1', '下单时间')
					->setCellValue('J1', '预约日期')
					->setCellValue('K1', '预约时段')
					->setCellValue('L1', '渠道来源')
					->setCellValue('M1', '分销员');
		$arr = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M'];
		$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10);
		$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
		$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(10);
		$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(25);
		$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
		$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(15);
		for($i = 0; $i < count($arr); $i++){
			$objPHPExcel->getActiveSheet()->getStyle($arr[$i].'1')->getFont()->setBold(true);
			$objPHPExcel->getActiveSheet()->getStyle($arr[$i].'1')->getFont()->setSize(12);
			$objPHPExcel->getActiveSheet()->getStyle($arr[$i].'1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle($arr[$i].'1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		}
		$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(30);
		for($i = 2; $i <= count($orders) + 1; $i++){
			$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('C'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('C'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('D'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('D'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('E'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('E'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('F'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('F'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('K'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('K'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('L'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('L'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('M'.$i)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle('M'.$i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			if($orders[$i-2]['number'] == '1'){
				$number = "第一针";
			}elseif($orders[$i-2]['number'] == '2'){
				$number = "第二针";
			}elseif($orders[$i-2]['number'] == '3'){
				$number = "第三针";
			}
			if($orders[$i-2]['status'] == '1'){
				$status = "已完成";
			}elseif($orders[$i-2]['status'] == '2'){
				$status = "已过期";
			}elseif($orders[$i-2]['status'] == '-1'){
				$status = "已取消";
			}else{
				$status = "待接种";
			}
			$minus_time = time() - strtotime($orders[$i-2]['birthday']);
			$age = floor($minus_time/3600/24/365);
			$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $orders[$i-2]['user_name']);
			$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $number);
			$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $orders[$i-2]['telephone']);
			$objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $orders[$i-2]['vaccines']);
			$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, $age);
			$objPHPExcel->getActiveSheet()->setCellValue('F' . $i, $orders[$i-2]['birthday']);
			$objPHPExcel->getActiveSheet()->setCellValue('G' . $i, $orders[$i-2]['idcard']."\t");
			$objPHPExcel->getActiveSheet()->setCellValue('H' . $i, $status);
			$objPHPExcel->getActiveSheet()->setCellValue('I' . $i, $orders[$i-2]['order_time']);
			$objPHPExcel->getActiveSheet()->setCellValue('J' . $i, $orders[$i-2]['appoint_date']);
			$objPHPExcel->getActiveSheet()->setCellValue('K' . $i, $orders[$i-2]['appoint_time']);
			$objPHPExcel->getActiveSheet()->setCellValue('L' . $i, $orders[$i-2]['channel']);
			$objPHPExcel->getActiveSheet()->setCellValue('M' . $i, $orders[$i-2]['name']);
		}
		$objPHPExcel->getActiveSheet()->setTitle('预约用户');
		//激活当前表
		$objPHPExcel->setActiveSheetIndex(0);
		ob_end_clean();//清除缓冲区,避免乱码
		$name = '预约用户_'.date('YmdHis').'.xlsx';
		//弹出提示下载文件
		header('pragma:public');
		header("Content-Disposition:attachment;filename=".$name);
		header('Cache-Control: max-age=0');
		$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
		$objWriter->save('php://output');
	}
}

15、需要开发医院在线预约管理系统的 可以QQ扫一扫：

在这里插入图片描述


http://www.niftyadmin.cn/n/5211253.html

相关文章

[网鼎杯 2020 朱雀组]phpweb

[网鼎杯 2020 朱雀组]phpweb

看一下源码 应该是输入的date 作为函数&#xff0c;value作为内部参数的值&#xff0c;将date()函数返回的结果显示在页面上 回去看的时候&#xff0c;意外发现页面有了新的跳转&#xff0c;观察一下发现&#xff0c;页面每隔五秒就会发生一次跳转 所以就抓包看看 抓包发现po…
阅读更多...
【React】useReducer

【React】useReducer

让 React 管理多个相对关联的状态数据 import { useReducer } from "react" // 1. 定义reducer函数&#xff0c;根据不同的action返回不同的状态 function reducer(state, action) {switch (action.type) {case ADD:return state action.payloadcase SUB:return st…
阅读更多...
分享一些感恩节祝福语

分享一些感恩节祝福语

今天是感恩节&#xff0c;11月也是所有卖家冲刺年终旺季的刺激战场&#xff0c;而从感恩节开始的购物周则是欧美消费者最疯狂的购物时刻。因此关于感恩节营销&#xff0c;卖家要做的不仅仅是传达品牌温度和感恩之情&#xff0c;更要为即将开启的大促进行引流&#xff0c;吸引消…
阅读更多...
基于Java SSM 网约车司机信息系统

基于Java SSM 网约车司机信息系统

基于Java SSM 网约车司机信息系统 一、基本需求 采用java语言和SQL Sever/MySQL进行开发&#xff0c;做成网页形式&#xff0c;可进行云服务器部署。 2、 用户分类 分为司机和乘客两个用户登录&#xff0c;主要是司机为主&#xff0c;乘客为辅。 3、 系统模块设计 司机&…
阅读更多...
如何进行MySQL的主从复制（MySQL5.7）

如何进行MySQL的主从复制（MySQL5.7）

背景&#xff1a;在一些Web服务器开发中&#xff0c;系统用户在进行数据访问时&#xff0c;基本都是直接操作数据库MySQL进行访问&#xff0c;而这种情况下&#xff0c;若只有一台MySQL服务器&#xff0c;可能会存在如下问题 数据的读和写的所有压力都会由一台数据库独…
阅读更多...
Verilog基础：时序调度中的竞争（一）

Verilog基础：时序调度中的竞争（一）

相关阅读 Verilog基础https://blog.csdn.net/weixin_45791458/category_12263729.html?spm1001.2014.3001.5482 作为一个硬件描述语言&#xff0c;Verilog HDL常常需要使用语句描述并行执行的电路&#xff0c;但其实在仿真器的底层&#xff0c;这些并行执行的语句是有先后顺序…
阅读更多...
js粒子效果(二)

js粒子效果(二)

效果: 代码: <!DOCTYPE html> <html lang"en"><head><meta charset"UTF-8"><meta name"viewport" content"widthdevice-width, initial-scale1.0"><title>Particle Animation</title><…
阅读更多...
2024-NeuDS-数据库题目集

2024-NeuDS-数据库题目集

一.判断题 1.在数据库中产生数据不一致的根本原因是冗余。T 解析&#xff1a;数据冗余是数据库中产生数据不一致的根本原因&#xff0c;因为当同一数据存储在多个位置时&#xff0c;如果其中一个位置的数据被修改&#xff0c;其他位置的数据就不一致了。因此&#xff0c;在数据…
阅读更多...
最新文章

Copyright @ 2022~2023