芝麻web文件管理V1.00

编辑当前文件:/home/rejoandoctor/www/app/Http/Controllers/Prescribe/AssistantController.php

<?php

namespace App\Http\Controllers\Prescribe;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Models\Appointment;
use App\Models\Patients;
use App\Models\Setting;
use App\Models\Prescription;
use App\Models\Signature;
use App\Models\Custom_header;
use App\Models\Ph_header;
use DB;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Hash;
use Illuminate\Validation\Rules;
use Carbon\Carbon;
use Session;

class AssistantController extends Controller

{
    function __construct()
    {
        $this->middleware('auth');
    }

function appointment()
    {
       
        $setting = Setting::where('doctor_id', Auth::user()->customer_id)->get();
        //dd($setting);
    	$appointment = Appointment::select('id','doctor_id','regi_number','patient_name','patient_mobile','patient_type','visit_fee','visit_date', 'unique_patient_id', 'appoint_status','chief_complaints')
            ->where('assistant_id', Auth::user()->id)
            ->whereDate('visit_date', Carbon::today())
            ->get();

return view('Prescribe.assistant.add_appointment', compact('appointment', 'setting'));
    }

function prescription_print($patient_id, $doctor_id)
        {

$patient = Prescription::where('id', $patient_id)->first();

$setting = Setting::where('doctor_id', Auth::user()->customer_id)->get();
            $signature = Signature::where('doctor_id', Auth::user()->customer_id)->first();

if(($setting[0]->status == 1) && $setting[0]->name == 'p_pad'){

$custom = Custom_header::where('doctor_id', $doctor_id)->first();
                return view('Prescribe.doctor.prescription_pad_custom', compact('patient','custom', 'signature','setting'));
                
            }else{
                $doctor = Ph_header::where('doctor_id', $doctor_id)->first();
                return view('Prescribe.doctor.prescription_pad_default', compact('patient','doctor', 'signature'));
            }
        }

function patient_search(Request $request)
        {
             $search = $request->search;

if($search == ''){
		         $patient = Patients::select('patient_id', 'name', 'age', 'sex', 'mobile', 'address')->limit(10)->where('doctor_id', Auth::user()->customer_id)->get();
		      }else{
		         $patient = Patients::select('patient_id', 'name', 'age', 'sex', 'mobile', 'address')->where('patient_id', 'like', '%' .$search . '%')->limit(10)->where('doctor_id', Auth::user()->customer_id)->get();
		      }

$response = array();
		      foreach($patient as $patient){
		         $response[] = array("label"=>$patient->patient_id, "value_id"=>$patient->patient_id, "value_name"=>$patient->name, "value_age"=>$patient->age, "value_sex"=>$patient->sex, "value_mobile"=>$patient->mobile, "value_address"=>$patient->address);
		      }

return response()->json($response);
               
        }

function insert_appointment(Request $request) 
    {

$data = $request->unique_patient_id;
            
        $doctor = Patients::where('doctor_id', Auth::user()->customer_id)->where('patient_id', $data)->first();

//dd($doctor);

if(isset($doctor))
            {
            	$appointment = Appointment::insert([
                    'unique_patient_id' => $request->unique_patient_id,
        	    	'doctor_id' => $request->doctor_id,
        	    	'assistant_id' => $request->assistant_id,
        	        'regi_number' => date("ymdhis"),
        	        'patient_name' => $request->patient_name,
        	        'patient_mobile' => $request->patient_mobile,
        	        'patient_age' => $request->patient_age,
        	        'patient_sex' => $request->patient_sex,
        	        'patient_type' => $request->patient_type,
        	        'patient_address' => $request->patient_address,
        	        'visit_date' => $request->visit_date,
        	        'visit_fee' => $request->visit_fee,
        	        'bp' => $request->bp,
        	        'temp' => $request->temp,
        	        'heart' => $request->heart,
        	        'weight' => $request->weight,
        	        'appoint_status' => $request->appoint_status + 1,
        	        'prescribe_status' => $request->prescribe_status + 0,
            	]);

Session::flash('success', 'Appointed Successfully');
                return redirect()->route('appointment');
            }else{

$last_patient_id = Patients::where('doctor_id', Auth::user()->customer_id)->orderBy('patient_id', 'DESC')->first();
                
                $patient = Patients::insert([
                    'doctor_id' => $doctor_id = $request->doctor_id,
		        	'patient_id' => $patient_id = $last_patient_id->patient_id + 1,
                    'assistant_id' => $assistant_id = $request->assistant_id,
                    'name' => $name = $request->patient_name,
                    'age' => $age = $request->patient_age,
                    'sex' => $sex = $request->patient_sex,
                    'mobile' => $mobile = $request->patient_mobile,
                    'address' => $address = $request->patient_address,
                ]);

$appointment = Appointment::insert([

'unique_patient_id' => $patient_id,
                    'doctor_id' => $doctor_id,
                    'assistant_id' => $assistant_id,
                    'regi_number' => date("ymdhis"),
                    'patient_name' => $name,
                    'patient_mobile' => $mobile,
                    'patient_age' => $age,
                    'patient_sex' => $sex,
                    'patient_address' => $address,
                    'patient_type' => $request->patient_type,
                    'visit_date' => $request->visit_date,
                    'visit_fee' => $request->visit_fee,
                    'bp' => $request->bp,
                    'temp' => $request->temp,
                    'heart' => $request->heart,
                    'weight' => $request->weight,
                    'appoint_status' => $request->appoint_status + 1,
                    'prescribe_status' => $request->prescribe_status + 0,
                ]);

Session::flash('success', 'Appointed Successfully');
                return redirect()->route('appointment');
            }
        
    }

function edit_appointment(Request $request, $id)
    {
    	$appointment = Appointment::where('id', $id)->first();
    	return view('Prescribe.assistant.edit_appointment', compact('appointment'));
    }

function update_appointment(Request $request, $patient_id)
    {
    	$appointment = Appointment::where('id', $patient_id);
    	$appointment->update([
	        'patient_name' => $request->patient_name,
	        'patient_mobile' => $request->patient_mobile,
	        'patient_age' => $request->patient_age,
	        'patient_sex' => $request->patient_sex,
	        'chief_complaints' => $request->chief_complaints,
	        'patient_type' => $request->patient_type,
	        'patient_address' => $request->patient_address,
	        'visit_date' => $request->visit_date,
	        'visit_fee' => $request->visit_fee,
	        'bp' => $request->bp,
	        'temp' => $request->temp,
	        'heart' => $request->heart,
	        'weight' => $request->weight,
	        'pulse' => $request->pulse,
    	]);

Session::flash('success', 'updated Successfully');
    	return redirect()->route('appointment');
    }
    
    function update_visit_fee(Request $request, $id)
        {
            $fee = Appointment::where('id', $id);
            $fee->update([
                'visit_fee' => $request->visit_fee,
            ]);

Session::flash('success', 'Visit Fee Updated');
            return redirect()->route('appointment');

}
}