public function add_comment()
 {
     $record = RegisterRecord::find(Input::get('record_id'));
     if (!isset($record)) {
         return Response::json(array('error_code' => 2, 'message' => '无该记录'));
     }
     $user_id = RegisterAccount::find($record->account_id)->user_id;
     if ($user_id != Session::get('user.id')) {
         return Response::json(array('error_code' => 3, 'message' => '无效记录'));
     }
     if (!Input::has('content')) {
         return Response::json(array('error_code' => 4, 'message' => '请输入评价'));
     }
     $old_comment = $record->comment()->get();
     if (isset($old_comment)) {
         return Response::json(array('error_code' => 5, 'message' => '已评论'));
     }
     $comment = new Comment();
     $comment->record_id = $record->id;
     $comment->content = Input::get('content');
     if (!$comment->save()) {
         return Response::json(array('error_code' => 1, 'message' => '添加失败'));
     }
     return Response::json(array('error_code' => 0, 'message' => '添加成功'));
 }
 public function run()
 {
     DB::table('register_records')->delete();
     RegisterRecord::create(array('start' => '2015-07-02 8:30', 'status' => 0, 'fee' => 1.0, 'advice' => '', 'return_date' => '2015-08-02', 'doctor_id' => 5, 'account_id' => 1, 'user_id' => 4, 'period_id' => 1));
     RegisterRecord::create(array('start' => '2015-07-02 14:30', 'status' => 1, 'fee' => 2.0, 'advice' => '多喝水', 'return_date' => '2015-07-20', 'doctor_id' => 6, 'account_id' => 2, 'user_id' => 3, 'period_id' => 1));
     RegisterRecord::create(array('start' => '2015-07-02 16:30', 'status' => 2, 'fee' => 3.0, 'advice' => '多吃药', 'return_date' => '2015-08-20', 'doctor_id' => 7, 'account_id' => 3, 'user_id' => 2, 'period_id' => 1));
     RegisterRecord::create(array('start' => '2015-07-02 8:00', 'status' => 1, 'fee' => 4.0, 'advice' => '多运动', 'return_date' => '2015-08-01', 'doctor_id' => 8, 'account_id' => 4, 'user_id' => 1, 'period_id' => 1));
 }
 protected function insert_comments()
 {
     $records = RegisterRecord::all();
     foreach ($records as $record) {
         $comment = new Comment();
         $comment->content = $this->get_random(self::$RANDOM_ALPHA_NUM, 10, 20);
         $comment->record_id = $record->id;
         $comment->created_at = date('Y-m-d H:i:s', strtotime($record->start) + 3600);
         $comment->save();
     }
 }
 public function modify_return()
 {
     $record = RegisterRecord::find(Input::get('record_id'));
     // 是否存在该记录
     if (!isset($record)) {
         return Response::json(array('error_code' => 2, 'message' => '不存在该挂号记录'));
     }
     // 检查该就诊记录是否该医生的
     if ($record->doctor_id != Session::get('doctor.id')) {
         return Response::json(array('error_code' => 3, 'message' => '无法修改该挂号'));
     }
     // 检查就诊状态
     if (!(int) $record->status) {
         return Response::json(array('error_code' => 4, 'message' => '尚未就诊'));
     }
     $record->return_date = Input::get('date');
     $record->status = 2;
     // 修改状态 --> 2 - 需复诊
     if (!$record->save()) {
         return Response::json(array('error_code' => 1, 'message' => '设置失败'));
     }
     return Response::json(array('error_code' => 0, 'message' => '设置成功', 'return_date' => $record->return_date));
 }
 public function add_return_date()
 {
     $record = RegisterRecord::find(Input::get('record_id'));
     // 是否存在该记录
     if (!isset($record)) {
         return Response::json(array('error_code' => 2, 'message' => '不存在该挂号记录'));
     }
     $register_account = RegisterAccount::find($record->account_id);
     // 检查该就诊记录是否该用户的
     if ($register_account->user_id != Session::get('user.id')) {
         return Response::json(array('error_code' => 3, 'message' => '无法修改该挂号'));
     }
     // 检查就诊状态
     /*
     if ( !(int)($record->status) ){
         return Response::json(array( 'error_code' => 4, 'message' => '尚未就诊' ));
     }
     */
     $record->return_date = Input::get('date');
     if (!$record->save()) {
         return Response::json(array('error_code' => 1, 'message' => '设置失败'));
     }
     return Response::json(array('error_code' => 0, 'message' => '设置成功'));
 }
 public function get_null_advice()
 {
     $register_records = RegisterRecord::selectRaw('register_records.id as record_id, users.id as user_id, users.real_name as user_name')->join('doctors', 'register_records.doctor_id', '=', 'doctors.id')->join('users', 'register_records.user_id', '=', 'users.id')->where('status', '>', 0)->where('doctors.id', Session::get('doctor.id'))->Where('register_records.created_at', 'like', Input::get('date', date('Y-m')) . '%')->WhereNull('advice')->orderBy('register_records.created_at')->paginate($this->default_num_per_page);
     return Response::json(array('error_code' => 0, 'totality' => $register_records->getTotal(), 'records' => $register_records->getItems()));
 }
 public function modify_return()
 {
     $record = RegisterRecord::find(Input::get('record_id'));
     // 是否存在该记录
     if (!isset($record)) {
         return Response::json(array('error_code' => 2, 'message' => '不存在该挂号记录'));
     }
     // 检查该就诊记录是否该医生的
     if ($record->doctor_id != Session::get('doctor.id')) {
         return Response::json(array('error_code' => 3, 'message' => '无法修改该挂号'));
     }
     // 检查就诊状态
     if (!(int) $record->status) {
         return Response::json(array('error_code' => 4, 'message' => '尚未就诊'));
     }
     $record->return_date = Input::get('date');
     $record->status = 2;
     // 修改状态 --> 2 - 需复诊
     if (!$record->save()) {
         return Response::json(array('error_code' => 1, 'message' => '设置失败'));
     }
     // 通过微信公众号向永华发送模板消息
     if (isset($weixin_pay_order) && $weixin_pay_order->status == 'FINISHED') {
         $doctor = $record->doctor;
         WeixinSDK::send_template_message(['touser' => $weixin_pay_order->open_id, 'template_id' => Config::get('weixin.template.return'), 'topcolor' => '#FF00000', 'data' => array('first' => ['value' => '您好,您的复诊时间已到,请及时进行复诊。'], 'keyword1' => ['value' => $record->account->name], 'keyword2' => ['value' => $doctor->department->hospital->name], 'keyword3' => ['value' => $doctor->name], 'keyword4' => ['value' => $record->return_date], 'remark' => ['value' => '祝您身体健康!'])]);
     }
     return Response::json(array('error_code' => 0, 'message' => '设置成功', 'return_date' => $record->return_date));
 }