芝麻web文件管理V1.00

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

<?php

namespace App\Http\Controllers\Prescribe;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Hash;
use Illuminate\Validation\Rules;
use Carbon\Carbon; 
use Session;
use DB;
use SimpleSoftwareIO\QrCode\Facades\QrCode;
use App\Models\User;
use App\Models\Assistant;
use App\Models\Customer;
use App\Models\Prescription;
use App\Models\Upazila;
use App\Models\Mpo_Company;
use App\Models\Treatment;
use App\Models\Dose; 
use App\Models\Advice;
use App\Models\Duration; 
use App\Models\Ph_header;
use App\Models\Drug;
use App\Models\Disease;
use App\Models\Custom_header;
use App\Models\Setting;
use App\Models\Signature;
use App\Models\Primary;
use App\Models\Permission;
use App\Models\Patients;
use App\Models\Drspecialist;
use App\Models\OnlinePrescription;
use App\Models\BlogPost;
use App\Models\Honorarium;
use App\Models\CustomizePrescription;

class DoctorController extends Controller

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

// Prescription view, add, update, delete
    function add_prescription()
	    {

$duration = Duration::where('doctor_id', Auth::user()->customer_id)->get();
	        $druglist = Drug::select('pres_name', 'id')->get();
	        $dose = Dose::where('doctor_id', Auth::user()->customer_id)->get();
	    	$treatment = Treatment::where('doctor_id', Auth::user()->customer_id)->get();
	    	$advice = Advice::where('doctor_id', Auth::user()->customer_id)->get();

//dd($disease_condition);
	        return view('Prescribe.doctor.add_prescription', compact('druglist','treatment', 'dose', 'duration', 'advice', 'treatment'));
	    }

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_prescription(Request $request)
	    {
	    	$request->validate([
	            'patient_name' => ['required', 'string', 'max:255'],

// 'patient_age' => ['required', 'string'],
	            // 'regi_number' => ['required', 'string', 'max:255', 'unique:parent_data'],
	            // 'visit_fee' => ['required', 'string', 'max:100'],
	            // 'patient_sex' => ['required', 'string', 'max:100'],

]);

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

if(isset($doctor))
            {
            	$prescribe = Prescription::insert([

'doctor_id' => $request->doctor_id,
	            'unique_patient_id' => $request->unique_patient_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_address' => $request->patient_address,
	            'patient_type' => $request->patient_type,
	            'visit_date' => $request->visit_date,
	            'visit_fee' => $request->visit_fee,
	            'bp' => $request->bp,
	            'pulse' => $request->pulse,
	            'temp' => $request->temp,
	            'heart' => $request->heart,
	            'weight' => $request->weight,
	            'lungs' => $request->lungs,
	            'abd' => $request->abd,
	            'anaemia' => $request->anaemia,
	            'jaundice' => $request->jaundice,
	            'cyanosis' => $request->cyanosis,
	            'oedema' => $request->oedema,
	            'rr' => $request->rr,
	            'sp' => $request->sp,
	            'ix' => $request->ix,
	            'dx' => $request->dx,
	            'lmp' => $request->lmp,
	            'edd' => $request->edd,
	            'fm' => $request->fm,
	            'fhr' => $request->fhr,
	            'gravida' => $request->gravida,
	            'investigation' => $request->investigation,
	            'revision' => $request->revision,
	            'chief_complaints' => $request->chief_complaints,
	            'drug_history' => $request->drug_history,
	            'prescription' => $request->prescription,
	            'appoint_status' => $request->appoint_status + 0,
	            'prescribe_status' => $request->prescribe_status + 1,
	        ]);

Session::flash('success', 'Prescription Generated');
	        return redirect()->route('show_prescription');
                
            }elseif($last_patient_id = Patients::where('doctor_id', Auth::user()->customer_id)->orderBy('patient_id', 'DESC')->first()){

//dd($last_patient_id);
    
                $patient = Patients::insert([
                    'patient_id' => $patient_id = $last_patient_id->patient_id + 1,
		        	'doctor_id' => $doctor_id = $request->doctor_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,
	        	]);

$prescribe = Prescription::insert([
					'unique_patient_id' => $patient_id,
		            'doctor_id' => $doctor_id,
		            'regi_number' => date("ymdhis"),
		            'patient_name' => $name,
		            'patient_mobile' => $mobile,
		            'patient_age' => $age,
		            'patient_sex' => $sex,
		            'patient_type' => $request->patient_type,
		            'patient_address' => $address,
		            'visit_date' => $request->visit_date,
		            'visit_fee' => $request->visit_fee,
		            'bp' => $request->bp,
		            'pulse' => $request->pulse,
		            'temp' => $request->temp,
		            'heart' => $request->heart,
		            'weight' => $request->weight,
		            'lungs' => $request->lungs,
		            'abd' => $request->abd,
		            'anaemia' => $request->anaemia,
		            'jaundice' => $request->jaundice,
		            'cyanosis' => $request->cyanosis,
		            'oedema' => $request->oedema,
		            'rr' => $request->rr,
		            'sp' => $request->sp,
		            'ix' => $request->ix,
		            'dx' => $request->dx,
		            'lmp' => $request->lmp,
    	            'edd' => $request->edd,
    	            'fm' => $request->fm,
    	            'fhr' => $request->fhr,
    	            'gravida' => $request->gravida,
		            'investigation' => $request->investigation,
		            'revision' => $request->revision,
		            'chief_complaints' => $request->chief_complaints,
		            'drug_history' => $request->drug_history,
		            'prescription' => $request->prescription,
		            'appoint_status' => $request->appoint_status + 0,
		            'prescribe_status' => $request->prescribe_status + 1,
		        ]);

Session::flash('success', 'Prescription Generated');
	        return redirect()->route('show_prescription');

}else{
                
                $patient = Patients::insert([
                    'patient_id' => $patient_id = $request->patient_id + 1,
		        	'doctor_id' => $doctor_id = $request->doctor_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,
	        	]);

Session::flash('success', 'Prescription Generated');
	        return redirect()->route('show_prescription');
            }
	        
	    }
	function manage_prescription(Request $request)
    {
        if (isset($request->start) && isset($request->end)) {
            // If start and end dates are provided, use them
            $start = $request->start;
            $end = $request->end;
    
            // Apply date filter
            $patient = Prescription::where(['prescribe_status' => 1, 'doctor_id' => Auth::user()->customer_id])
                ->whereBetween('visit_date', [$start, $end])
                ->orderByDesc('created_at', 'DESC')
                ->cursor();  // Using lazy loading with cursor to handle large datasets efficiently
        } else {
            // No date filter, fetch all records
            $patient = Prescription::where(['prescribe_status' => 1, 'doctor_id' => Auth::user()->customer_id])
                ->orderByDesc('created_at', 'DESC')
                ->cursor();  // Using lazy loading with cursor to handle large datasets efficiently
        }
    
        $permission = Setting::where('doctor_id', Auth::user()->customer_id)
            ->where('name', 'prescription_delete')
            ->where('status', 1)
            ->first();
    
        $send_prescription = User::where('customer_id', Auth::user()->customer_id)
            ->where('role', 'assistant')
            ->first(['id']);
    
        // Pass lazy-loaded collection to the view
        return view('Prescribe.doctor.manage_prescription', compact('patient', 'permission', 'send_prescription'));
    }

function send_prescription(Request $request, $id)
		{
			$data = Prescription::where('id', $id);
			$data->update([
				'assistant_id' => $request->assistant_id,
			]);

Session::flash('success','Prescription Send Successfully.');
	    	return redirect()->route('show_prescription');

}
	function edit_prescription(Request $request, $patient_id)
		{
			$duration = Duration::where('doctor_id', Auth::user()->customer_id)->get();
	        $druglist = Drug::select('pres_name', 'id')->get();
	        $dose = Dose::where('doctor_id', Auth::user()->customer_id)->get();
	    	$treatment = Treatment::where('doctor_id', Auth::user()->customer_id)->get();
	    	$advice = Advice::where('doctor_id', Auth::user()->customer_id)->get();
	    	
			$patient = Prescription::where('id', $patient_id)->first();
			return view('Prescribe.doctor.edit_prescription', compact('patient', 'druglist','duration','dose','treatment','advice'));
		}
	function update_prescription(Request $request, $patient_id)
		{

$patient = Prescription::where('id', $patient_id);
	       	$patient->update([
	       		'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,
	            'pulse' => $request->pulse,
	            'temp' => $request->temp,
	            'heart' => $request->heart,
	            'weight' => $request->weight,
	            'lungs' => $request->lungs,
	            'abd' => $request->abd,
	            'anaemia' => $request->anaemia,
	            'jaundice' => $request->jaundice,
	            'cyanosis' => $request->cyanosis,
	            'oedema' => $request->oedema,
	            'rr' => $request->rr,
	            'sp' => $request->sp,
	            'ix' => $request->ix,
	            'dx' => $request->dx,
	            'lmp' => $request->lmp,
	            'edd' => $request->edd,
	            'fm' => $request->fm,
	            'fhr' => $request->fhr,
	            'gravida' => $request->gravida,
	            'investigation' => $request->investigation,
	            'revision' => $request->revision,
	            'chief_complaints' => $request->chief_complaints,
	            'drug_history' => $request->drug_history,
	            'prescription' => $request->prescription,
	            'appoint_status' => $request->appoint_status + 0,
	            'prescribe_status' => $request->prescribe_status + 1,
	            'updated_at' => date('Y-m-d h:i:s'),

]);
	        
	        Session::flash('success','Prescription Updated Successfully.');
	    	return redirect()->route('show_prescription');
		}
    function delete_prescription($patient_id)
    	{
    		$patient = Prescription::where('id', $patient_id);
    		$patient->delete();

Session::flash('success','Prescription Permanently Deleted');
    		return redirect()->route('show_prescription');
    	}

function print_prescription($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{
   			    $permission = Setting::where('doctor_id', Auth::user()->customer_id)
           			    ->where('name', "specialist")
           			    ->where('status', 1)->first();
   				$doctor = Ph_header::where('doctor_id', $doctor_id)->first();
   				$customizeprescription = CustomizePrescription::where('doctor_id', $doctor_id)->first();
   				return view('Prescribe.doctor.prescription_pad_default', compact('patient','doctor', 'signature', 'permission', 'customizeprescription'));
   			}
   		}
  	
  	// Appointment view, add, update, delete  
    function manage_appointment(Request $request)
	    {

if (isset($request->start) && isset($request->end)) {
		    	$start = $request->start;
		    	$end = $request->end;
	    	}else{
	    		$start = Carbon::now()->month();
				$end = Carbon::now();
	    	}
	    		$appointment = Prescription::select(
		    	'id',
		    	'unique_patient_id',
	    		'patient_name',
	    		'patient_sex',
	    		'regi_number',
	    		'patient_mobile',
	    		'patient_type',
	    		'visit_fee',
	    		'visit_date',
	    		'assistant_id'
	    		)
	    		->where(['appoint_status'=>1, 'doctor_id' => Auth::user()->customer_id])
	    		->whereBetween('visit_date', array($start, $end))
	    		->orderByDesc('visit_date', 'DESC')
	    		->get();

return view('Prescribe.doctor.manage_appointment', compact('appointment'));
	    	
	    }
    
    // Online Appointment
	function online_patient(Request $request)
		{
			if (isset($request->start) && isset($request->end)) {
		    	$start = $request->start;
		    	$end = $request->end;
	    	}else{
	    		$start = Carbon::now()->month();
				$end = Carbon::now();
	    	}
	    		$appointment = OnlinePrescription::where('doctor_id', Auth::user()->customer_id)
	    		->whereBetween('visit_date', array($start, $end))
	    		->orderByDesc('visit_date', 'DESC')
	    		->get(['id',
		    	'doctor_id',
	    		'patient_name',
	    		'patient_sex',
	    		'regi_number',
	    		'patient_mobile',
	    		'visit_date',
	    		'appoint_status']);

return view('Prescribe.doctor.appointment_online_patient', compact('appointment'));
		}

function edit_online_prescription(Request $request, $patient_id)
		{
			$duration = Duration::where('doctor_id', Auth::user()->customer_id)->get();
	        $druglist = Drug::select('pres_name', 'id')->get();
	        $dose = Dose::where('doctor_id', Auth::user()->customer_id)->get();
	    	$treatment = Treatment::where('doctor_id', Auth::user()->customer_id)->get();
	    	$advice = Advice::where('doctor_id', Auth::user()->customer_id)->get();
	    	
			$patient = OnlinePrescription::where('id', $patient_id)->first();
			return view('Prescribe.doctor.edit_online_prescription', compact('patient', 'druglist','duration','dose','treatment','advice'));
		}

function update_online_prescription(Request $request, $patient_id)
		{

$patient = OnlinePrescription::where('id', $patient_id);
	       	$patient->update([
	       		'patient_name' => $request->patient_name,
	            'patient_mobile' => $request->patient_mobile,
	            'patient_age' => $request->patient_age,
	            'patient_sex' => $request->patient_sex,
	            'patient_address' => $request->patient_address,
	            'visit_date' => $request->visit_date,
	            'bp' => $request->bp,
	            'pulse' => $request->pulse,
	            'temp' => $request->temp,
	            'heart' => $request->heart,
	            'weight' => $request->weight,
	            'lungs' => $request->lungs,
	            'abd' => $request->abd,
	            'anaemia' => $request->anaemia,
	            'jaundice' => $request->jaundice,
	            'cyanosis' => $request->cyanosis,
	            'oedema' => $request->oedema,
	            'rr' => $request->rr,
	            'sp' => $request->sp,
	            'ix' => $request->ix,
	            'dx' => $request->dx,
	            'investigation' => $request->investigation,
	            'revision' => $request->revision,
	            'chief_complaints' => $request->chief_complaints,
	            'drug_history' => $request->drug_history,
	            'prescription' => $request->prescription,
	            'appoint_status' => $request->appoint_status + 0,
	            'prescribe_status' => $request->prescribe_status + 1,
	            'updated_at' => date('Y-m-d h:i:s'),

]);
	        
	        Session::flash('success','Prescription Updated Successfully.');
	    	return redirect()->route('online_patient');
		}

function online_user_prescroption($patient_id, $doctor_id)
        {   
            
            $patient = OnlinePrescription::where('id', $patient_id)->first();

$signature = Signature::where('doctor_id',  $doctor_id)->first();
             
            $doctor = Ph_header::where('doctor_id', $doctor_id)->first();
            $customizeprescription = CustomizePrescription::where('doctor_id', $doctor_id)->first();
            return view('Prescribe.doctor.prescription_pad_default', compact('patient','doctor', 'signature', 'customizeprescription'));
            
        }

// Prescription Pad Header view, update,chnage Signature Upload

function prescription_header()
	    {	
	    	$pad = Setting::where('doctor_id', Auth::user()->customer_id)->get();
	    	//dd($pad);
	    	$size = Custom_header::where('doctor_id', Auth::user()->customer_id)->get();
	    	$specialist = Drspecialist::all(['id','specialist', 'specialist_bn']);
	    	$header = Ph_header::where(['doctor_id' => Auth::user()->customer_id])->first();
	    	$customization = CustomizePrescription::where(['doctor_id' => Auth::user()->customer_id])->first();
	        return view('Prescribe.doctor.prescription_header', compact('header', 'size','pad', 'specialist', 'customization'));
	    }
    function ph_update(Request $request, $id)
	    {
	       
	        $data = Ph_header::where('doctor_id', $id);
	        $data->update([

'name' => $request->name, 
	            'designation' => $request->designation, 
	            'specialist' => $request->specialist, 
	            'department' => $request->department, 
	            'course' => $request->course, 
	            'posting_place' => $request->posting_place, 
	            'bmdc' => $request->bmdc, 
	            'name_bn' => $request->name_bn,
	            'designation_bn' => $request->designation_bn,
	            'type' => $request->type,
	            'specialist_bn' => $request->specialist_bn,
	            'department_bn' => $request->department_bn,
	            'additional_degree' => $request->additional_degree,
	            'additional_degree_bn' => $request->additional_degree_bn,
	            'course_bn' => $request->course_bn,
	            'posting_place_bn' => $request->posting_place_bn,
	            'bmdc_bn' => $request->bmdc_bn,
	            'ch_name' => $request->ch_name,
	            'ch_address' => $request->ch_address,
	            'ch_mobile' => $request->ch_mobile,
	            'ch_day' => $request->ch_day,
	            'ch_off' => $request->ch_off,
	            'footer_text' => $request->footer_text,
	            'text1' => $request->text1,
	            'text2' => $request->text2,
	            'text3' => $request->text3,
	            'text4' => $request->text4,
	            'text5' => $request->text5,
	            'text6' => $request->text6,
	            'text7' => $request->text7,
	            'text8' => $request->text8,
	            'text9' => $request->text9,
	        ]);

$customization = CustomizePrescription::updateOrCreate(
		        ['doctor_id' => $id], // Condition to check for existing record
		        [
		            'header_color' => $request->header_color,
		            'left_color' => $request->left_color,
		            'footer_color' => $request->footer_color
		        ]
		    );

Session::flash('success','Default Pad Updated Successfully');
	      	return redirect()->route('show_pres_heaader');
	    }
	function ph_custom_update(Request $request, $id)
		{
			$size = Custom_header::where('doctor_id', $id);
			$size->update([
				'total_width' => $request->total_width,
				'total_height' => $request->total_height,
				'header_width' => $request->header_width,
				'header_height' => $request->header_height,
				'total_patient_width' => $request->total_patient_width,
				'total_patient_height' => $request->total_patient_height,
				'name' => $request->name,
				'name_content' => $request->name_content,
				'age' => $request->age,
				'age_content' => $request->age_content,
				'address' => $request->address,
				'address_content'=> $request->address_content,
				'sex' => $request->sex,
				'sex_content' => $request->sex_content,
				'date' => $request->date,
				'date_content' => $request->date_content,
				'mobile' => $request->mobile,
				'mobile_content' => $request->mobile_content,
				'body_left_height' => $request->body_left_height,
				'body_left_width' => $request->body_left_width,
				'cc_top' => $request->cc_top,
				'cc' => $request->cc,
				'cc_content' => $request->cc_content,
				'oe' => $request->oe,
				'oe_content' => $request->oe_content,
				'dh' => $request->dh,
				'dh_content' => $request->dh_content,
				'dx' => $request->dx,
				'dx_content' => $request->dx_content,
				'advice' => $request->advice,
				'advice_content' => $request->advice_content,
				'body_right_width' => $request->body_right_width,
				'body_right_height' => $request->body_right_height,
				'footer_height' => $request->footer_height,
				'footer_width' => $request->footer_width,
			]);

Session::flash('success','Custom Pad Updated Successfully');
			return redirect()->route('show_pres_heaader');
		}
	
	// MPO Request
	function mpo_requested()
		{
			$mpo_approval = DB::table('permission')
	            ->where('doctor_id', Auth::user()->customer_id)
	            ->join('customers', 'permission.mpo_id', 'customers.id')
	            ->get(['permission.*', 'customers.customer_name', 'customers.id', 'customers.customer_mobile', 'customers.customer_company','customers.end_date','customers.id', 'permission.doctor_id', 'permission.id']);
				
			return view('Prescribe.doctor.mpo_approval', compact('mpo_approval'));
		}

function mpo_enable(Request $request, $doctor_id, $mpo_id, $id)
		{
			$enable = Permission::where('doctor_id', $doctor_id)->where('mpo_id', $mpo_id)->where('id', $id);
			$enable->update([
			 	'status' => 1,
			]);
			//dd($enable);
			
			Session::flash('success', 'Request Approval');
			return redirect()->route('mpo_request');
		}

function mpo_disable(Request $request, $doctor_id, $mpo_id, $id)
		{
			$disable = Permission::where('doctor_id', $doctor_id)->where('mpo_id', $mpo_id)->where('id', $id);
			$disable->update([
			 	'status' => 0,
			]);

//dd($disable);
			
			Session::flash('success', 'Request Approval');
			return redirect()->route('mpo_request');
		}

function mpo_request_deleted($id)
		{
			$mpo = Permission::where('id', $id);
			$mpo->delete();

Session::flash('success', 'Deleted Successfully');
			return redirect()->route('mpo_request');
		}
    
    // mpo registration

function mpo_registration()
        {   
            $upazilas = Upazila::get(['id','name','url'])->sortBy('name', SORT_NATURAL);
            $company = Mpo_Company::select('company_id','company_name')->get()->sortBy('company_name', SORT_NATURAL);
            
            return view('Prescribe.doctor.mpo_registration_by_doctor', compact('upazilas', 'company'));
        }

function insert_mpo(Request $request)
    {
        $request->validate([
            'customer_name' => ['required', 'string', 'max:100'],
            'password' => ['required', 'confirmed', Rules\Password::defaults()],
            'customer_email' => ['required', 'max:150', 'unique:customers'],
            'customer_mobile' => ['required', 'max:11', 'min:10', 'unique:customers'],
            'chamber_area' => ['required'],
            'customer_company' => ['required'],
        ]);

$mpo = Customer::insert([
            'customer_name' =>$request->customer_name,
            'customer_email' => $email = $request->customer_email,
            'customer_mobile' => $request->customer_mobile,
            'customer_company' => $request->customer_company,
            'chamber_area' => $request->chamber_area,
            'monthly_charge' => 200,
            'end_date' => $request->end_date,
            'customer_type' => $role = "mpo",
        ]);

$mpo_user = Primary::insert([
            'customer_id' => DB::getPdo()->lastInsertId(),
            'name' => $request->customer_name,
            'email' => $request->customer_email,
            'password' => Hash::make($request->password),
            'role' => $role, 
        ]);

Session::flash('success', 'Registration Successfull');
        return redirect()->route('mpo_request');
    } 
	// Settings
	function settings()
		{
			$setting = Setting::where('doctor_id', Auth::user()->customer_id)->get();
		    $signature = Signature::where('doctor_id', Auth::user()->customer_id)->get();
		    $honorarium = Honorarium::where('doctor_id', Auth::user()->customer_id)->get();

return view('Prescribe.doctor.settings', compact('setting', 'signature', 'honorarium'));
		}
	function permission_swicth(Request $request, $doctor_id, $id)
		{
			$request->validate([
	            
	            'status' => ['required'],
	        ],
	    	[ 'name.required' => ':attribute']);

//dd($request->id);
			$pad = Setting::where('doctor_id', $doctor_id)->where('id', $id);
			$pad->update([
				'status' => $request->status,
			]);

Session::flash('success','Switch Successfully');
			return redirect()->route('set_module');
		}
	
	function dr_signature(Request $request, $id)
		{
			
			if($request->signature){

$logo = $request->signature;
	            $new_name = time().$logo->getClientOriginalName();
	            $image = $logo->move('signature', $new_name);

}

$signature = Signature::where('doctor_id', $id);
			$signature->update([
				'signature' => $image,
			]);

Session::flash('success','Signature Uploaded Successfully');
			return redirect()->route('set_module');
		}
		
	function insert_honorarium(Request $request)
		{
			$honorarium = Honorarium::insert([
	        	'doctor_id' => $request->doctor_id,
	            'method' => $request->method,
	            'account' => $request->account
	        ]);

Session::flash('success','Inserted Successfully');
	        return redirect()->route('set_module');
	       
		}
	
	// Doctor Assistant view, add, update, delete
    function assistant()
	    {
	    	$result = User::select(
	    		'id',
	    		'name',
	    		'customer_id',
	    		'email',
	    		'role',
	    		'created_at')

->where('customer_id', Auth::user()->customer_id)
		    	->where('role', 'assistant')
		    	->get();

return view('Prescribe.doctor.manage_assistant', compact('result'));
	    }
    function add_assistant()
	    {
	    	return view('Prescribe.doctor.add_assistant');
	    }
    function insert_assistant(Request $request)
	    {
	   // 	$check = Primary::where('customer_id', Auth::user()->customer_id)
		  //  	->where('role', 'assistant');
	    	
	   //     if(isset($check))
	   //     {
	   //     	Session::flash('danger','You can not add assistant more than one!');
	   //     	return redirect()->route('show_assistant');

//     }else{

$request->validate([
	            'assistant_name' => ['required', 'string', 'max:100'],
	            'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
	            'password' => ['required', 'confirmed', Rules\Password::defaults()],
	        ]);

$assistant = Customer::insert([
	            'customer_name' => $request->assistant_name,
	            'customer_email' => $request->email,
	            'customer_type' => $role = "assistant",
	        ]);

$assistant_user = Assistant::insert([
	        	'customer_id' => $request->customer_id,
	            'name' => $request->assistant_name,
	            'email' => $request->email,
	            'role' => $role,
	            'password' => Hash::make($request->password),
	        ]);

Session::flash('success','Inserted Successfully');
	        return redirect()->route('show_assistant');
	       // }

}
	function edit_assistant(Request $request, $assistant_id)
		{
			$assistant = Assistant::select(
				'id',
				'name',
				'email',
				'customer_id',
				'password')

->where('id', $assistant_id)->first();

return view('Prescribe.doctor.edit_assistant', compact('assistant'));
		}
	function update_assistant(Request $request, $assistant_id)
		{

$assistant = Assistant::where('id',$assistant_id);
			$assistant->update([
				'name' => $name = $request->name,
	            'email' => $email = $request->email,
	            'password' => Hash::make($request->password)
			]);

Session::flash('success','Updated Successfully');
			return redirect()->route('show_assistant');

}
 
// Template Start

// Treatment Template

function treatment()
		{

$duration = Duration::where('doctor_id', Auth::user()->customer_id)->get();
        //$druglist = Drug::select('pres_name', 'id')->get();
      
        $dose = Dose::where('doctor_id', Auth::user()->customer_id)->get();

$treatment = Treatment::where(['doctor_id' => Auth::user()->customer_id])->get();
		return view('Prescribe.doctor.template.add_treatment', compact('treatment', 'dose', 'duration'));
		}

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

if($search == ''){
		         $employees = Drug::select('pres_name', 'id')->limit(10)->get();
		      }else{
		         $employees = Drug::select('pres_name', 'id')->where('pres_name', 'like', '%' .$search . '%')->limit(10)->get();
		      }

$response = array();
		      foreach($employees as $employee){
		         $response[] = array("label"=>$employee->pres_name);
		      }

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

function insert_treatment(Request $request)
		{
			$request->validate([
		            'template_name' => ['required', 'string', 'max:255'],

]);

$treatment = Treatment::insert([
				'template_name' => $request->template_name,
				'treatment' => $request->treatment,
				'doctor_id' => $request->doctor_id,

]);

Session::flash('success','Inserted Successfully');
			return redirect()->route('show_treatment');
		}
	function edit_treatment(Request $request, $treatment_id)
		{
			$duration = Duration::get();
	        $druglist = Drug::select('pres_name', 'id')->get();
	        $dose = Dose::where('doctor_id', Auth::user()->customer_id)->get();

$treatment = Treatment::where('id', $treatment_id)->first();
			return view('Prescribe.doctor.template.edit_treatment', compact('treatment','druglist', 'dose','duration'));
		}
	function update_treatment(Request $request , $treatment_id)
		{
			$treatment = Treatment::where('id', $treatment_id);
			$treatment->update([
				'template_name' => $request->template_name,
	            'treatment' => $request->treatment,
			]);

Session::flash('success','Updated Successfully');
			return redirect()->route('show_treatment');

}
	function delete_treatment($id)
    	{
    	    $delete_advice = Treatment::where('doctor_id', Auth::user()->customer_id)->where('id', $id)->delete();
    	    return redirect()->back();
    	}

// Duration Template
	function duration()
		{
			$duration = Duration::where('doctor_id', Auth::user()->customer_id)->get();
			return view('Prescribe.doctor.template.add_duration', compact('duration'));
		}
	function insert_duration(Request $request)
		{
			$request->validate([
		        'template_name' => ['required', 'string', 'max:255'],

]);

$duration = Duration::insert([
				'doctor_id' => $request->doctor_id,
				'template_name' => $request->template_name,
				'duration' => $request->duration,				
			]);

Session::flash('success', 'Inserted Successfully');
			return redirect()->route('show_duration');
		}
	function edit_duration(Request $request, $duration_id)
		{
			$duration = Duration::where('id', $duration_id)->first();
			return view('Prescribe.doctor.template.edit_duration', compact('duration'));
		}
	function update_duration(Request $request , $duration_id)
		{
			$duration = Duration::where('id', $duration_id);
			$duration->update([
				'template_name' => $request->template_name,
	            'duration' => $request->duration,
			]);

Session::flash('success','Updated Successfully');
			return redirect()->route('show_duration');

}
    function delete_duration($id)
    	{
    	    $delete_advice = Duration::where('doctor_id', Auth::user()->customer_id)->where('id', $id)->delete();
    	    return redirect()->back();
    	}
    	
	// Dose Template
	function dose()
		{
			$dose = Dose::where(['doctor_id' => Auth::user()->customer_id])->get();
			return view('Prescribe.doctor.template.add_dose', compact('dose'));
		}
	function insert_dose(Request $request)
		{
			$request->validate([
		        'template_name' => ['required', 'string', 'max:255'],

]);

$dose = Dose::insert([
				'template_name' => $request->template_name,
				'doses' => $request->doses,
				'doctor_id' => $request->doctor_id,
				
			]);

Session::flash('success','Inserted Successfully');
			return redirect()->route('show_dose');
		}
	function edit_dose(Request $request, $dose_id)
		{
			$dose = Dose::where('id', $dose_id)->first();
			return view('Prescribe.doctor.template.edit_dose', compact('dose'));
		}
	function update_dose(Request $request , $dose_id)
		{
			$dose = Dose::where('id', $dose_id);
			$dose->update([
				'template_name' => $request->template_name,
	            'doses' => $request->doses,
			]);

Session::flash('success','Updated Successfully');
			return redirect()->route('show_dose');

}
	function delete_dose($id)
    	{
    	    $delete_advice = Dose::where('doctor_id', Auth::user()->customer_id)->where('id', $id)->delete();
    	    return redirect()->back();
    	}
		
	// End Dose Template
	
	// Advice Template
	function advice()
		{
			$advice = Advice::where(['doctor_id' => Auth::user()->customer_id])->get();
			return view('Prescribe.doctor.template.add_advice', compact('advice'));
		}
	function insert_advice(Request $request)
		{
			$request->validate([
		        'template_name' => ['required', 'string', 'max:255'],

]);

$advice = Advice::insert([
				'template_name' => $request->template_name,
				'advices' => $request->advices,
				'doctor_id' => $request->doctor_id,
				
			]);

Session::flash('success','Inserted Successfully');
			return redirect()->route('show_advice');;
		}
	function edit_advice(Request $request, $advice_id)
		{
			$advice = Advice::where('id', $advice_id)->first();
			return view('Prescribe.doctor.template.edit_advice', compact('advice'));
		}
	function update_advice(Request $request , $advice_id)
		{
			$advice = Advice::where('id', $advice_id);
			$advice->update([
				'template_name' => $request->template_name,
	            'advices' => $request->advices,
			]);

Session::flash('success','Updated Successfully');
			return redirect()->route('show_advice');

}
	function delete_advice($id)
    	{
    	    $delete_advice = Advice::where('doctor_id', Auth::user()->customer_id)->where('id', $id)->delete();
    	    return redirect()->back();
    	}

// BLog Post
	function manage_post()
		{
			$post = BlogPost::where('doctor_id', Auth::user()->customer_id)->get();
			//dd($post);
			return view('Prescribe.doctor.manage_post', compact('post'));
		}

function insert_post(Request $request)
		{

if(isset($request->image))
	        {
	            if($request->image){
	            
	            $logo = $request->image;
	            $new_name = time().$logo->getClientOriginalName();
	            $image = $logo->move('images', $new_name);

}
				
			}

$post = BlogPost::insert([
				'doctor_id' => $request->doctor_id,
				'title' => $request->title,
				'category' => $request->category,
				'content' => $request->content,
				'image' => $image
				
			]);

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

function post_enable(Request $request, $id)
		{
			$enable = BlogPost::where('id', $id);
			$enable->update([
			 	'status' => 1,
			]);
			
			Session::flash('success', 'Article Publish');
			return redirect()->route('manage_post');
		}

function post_disable(Request $request, $id)
		{
			$disable = BlogPost::where('id', $id);
			$disable->update([
			 	'status' => 0, 
			]);
			
			Session::flash('success', 'Article Draft');
			return redirect()->route('manage_post');
		}

function edit_post($id) 
		{
			$post = BlogPost::where('id', $id)->first();
			return view('Prescribe.doctor.edit_post', compact('post'));
		}
		
		function update_post(Request $request, $id)
		{

$post = BlogPost::where('id', $id);

if(isset($request->image))
	        { 
	            if($request->image){
	            
	            $logo = $request->image;
	            $new_name = time().$logo->getClientOriginalName();
	            $image = $logo->move('images', $new_name);

}

$post->update([
		
					'title' => $request->title,
					'category' => $request->category,
					'content' => $request->content,
					'image' => $image
				
				]);
	        }

$post->update([
    		'title' => $request->title,
			'category' => $request->category,
			'content' => $request->content
    	]);

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

}