数字化医疗：如何利用云计算提高医疗服务质量

    electronic_medical_record/
    │
    ├── app/
    │   ├── controllers/
    │   ├── models/
    │   ├── views/
    │   └── routes/
    │
    ├── config/
    │   └── database.php
    │
    ├── public/
    │   └── index.php
    │
    └── resources/
    └── lang/
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    
    代码解读

    CREATE TABLE `patients` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) NOT NULL,
      `gender` varchar(10) NOT NULL,
      `age` int(3) NOT NULL,
      `birthday` date NOT NULL,
      `address` varchar(255) NOT NULL,
      `phone` varchar(20) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    CREATE TABLE `medical_records` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `patient_id` int(11) NOT NULL,
      `doctor` varchar(255) NOT NULL,
      `department` varchar(255) NOT NULL,
      `diagnosis` text NOT NULL,
      `treatment` text NOT NULL,
      `prescription` text NOT NULL,
      `admission_date` date NOT NULL,
      `discharge_date` date NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    
    代码解读

    // app/controllers/PatientController.php
    class PatientController extends BaseController {
    public function index() {
        $patients = Patient::all();
        return View::make('patients.index', compact('patients'));
    }
    
    public function create() {
        return View::make('patients.create');
    }
    
    public function store() {
        $patient = new Patient(Input::all());
        $patient->save();
        return Redirect::to('patients');
    }
    
    public function show($id) {
        $patient = Patient::find($id);
        return View::make('patients.show', compact('patient'));
    }
    
    public function edit($id) {
        $patient = Patient::find($id);
        return View::make('patients.edit', compact('patient'));
    }
    
    public function update($id) {
        $patient = Patient::find($id);
        $patient->update(Input::all());
        return Redirect::to('patients');
    }
    
    public function destroy($id) {
        $patient = Patient::find($id);
        $patient->delete();
        return Redirect::to('patients');
    }
    }
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    
    代码解读

    // app/models/Patient.php
    class Patient extends Eloquent {
    protected $table = 'patients';
    protected $fillable = array('name', 'gender', 'age', 'birthday', 'address', 'phone');
    }
    
    // app/models/MedicalRecord.php
    class MedicalRecord extends Eloquent {
    protected $table = 'medical_records';
    protected $fillable = array('patient_id', 'doctor', 'department', 'diagnosis', 'treatment', 'prescription', 'admission_date', 'discharge_date');
    }
    
      
      
      
      
      
      
      
      
      
      
    
    代码解读

    <!-- app/views/patients/index.blade.php -->
    @extends('layouts.master')
    
    @section('content')
    <h1>患者信息</h1>
    <a href="{{ URL::to('patients/create') }}">添加新患者</a>
    <table>
        <thead>
            <tr>
                <th>ID</th>
                <th>姓名</th>
                <th>性别</th>
                <th>年龄</th>
                <th>出生日期</th>
                <th>地址</th>
                <th>电话</th>
                <th>操作</th>
            </tr>
        </thead>
        <tbody>
            @foreach($patients as $patient)
            <tr>
                <td>{{ $patient->id }}</td>
                <td>{{ $patient->name }}</td>
                <td>{{ $patient->gender }}</td>
                <td>{{ $patient->age }}</td>
                <td>{{ $patient->birthday }}</td>
                <td>{{ $patient->address }}</td>
                <td>{{ $patient->phone }}</td>
                <td>
                    <a href="{{ URL::to('patients/' . $patient->id . '/edit') }}">编辑</a>
                    <a href="{{ URL::to('patients/' . $patient->id . '/delete') }}">删除</a>
                </td>
            </tr>
            @endforeach
        </tbody>
    </table>
    @stop
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    
    代码解读

    // app/routes.php
    Route::get('/', function() {
    return Redirect::to('patients');
    });
    
    Route::get('/patients', 'PatientController@index');
    Route::post('/patients', 'PatientController@store');
    Route::get('/patients/create', 'PatientController@create');
    Route::get('/patients/{id}', 'PatientController@show');
    Route::get('/patients/{id}/edit', 'PatientController@edit');
    Route::put('/patients/{id}', 'PatientController@update');
    Route::delete('/patients/{id}', 'PatientController@destroy');
    
      
      
      
      
      
      
      
      
      
      
      
    
    代码解读

    // public/index.php
    <?php
    require 'app/start/global.php';
    
    Route::controllers();
    
      
      
      
      
    
    代码解读

    // config/database.php
    return array(
    'connections' => array(
        'mysql' => array(
            'driver'    => 'mysql',
            'host'      => 'localhost',
            'database'  => 'electronic_medical_record',
            'username'  => 'root',
            'password'  => '',
            'charset'   => 'utf8',
            'collation' => 'utf8_general_ci',
        ),
    ),
    );
    
      
      
      
      
      
      
      
      
      
      
      
      
      
    
    代码解读