EVOLUTION-NINJA

Edit File: E_Feedback.php

<?php namespace App\Controllers\labour;
use App\Controllers\BaseController;
use CodeIgniter\RESTful\ResourceController;
use CodeIgniter\API\ResponseTrait;
use App\Models\addPatientModel;

use App\Models\labour_EFeedbackModel;
use App\Models\labour_FeedbackModel;
use App\Models\labour_SpinalModel;
use App\Models\labour_EpiduralModel;
use App\Models\labour_combinedSpinalEpiduralModel;
use App\Models\labour_FollowupCumulativeModel;
use App\Models\labour_CSA_Model;
use App\Models\labour_PreProcedureModel;
use App\Models\labour_post_procedureModel;
use App\Models\labour_FollowupModel;
use App\Models\labour_e_consentModel;
use App\Models\RegisterUserModel;

class E_Feedback extends BaseController
{ 
    public function index()
    {   
        $dr_id = session()->get('dr_id');
        $patient_id = session()->get('id');

// if($dr_id){        
            $email1 = session()->get('patient_email_id');
            // $email1 = 'rahul.j.b789@gmail.com';
            $pass = substr(str_shuffle("0123456789abcdefghijklmnopqrstvwxyz"), 0, 6); 
            
            $email = \Config\Services::email();
            
            $email->setFrom("Contact@medusys.in", "E_Feedback");
            $email->setTo($email1);

$email->setSubject('Online feedback');
            $href = 'https://medusys.in/l_e_feedback_mail?id='.$pass.'';           
                
                $find_dr = new RegisterUserModel();
                $z = $find_dr->where('id',$dr_id)->first();
                $hospital = $z['hospital'];

// print_r($hospital);die();

$content .= '<html>';
                $content .= '<head>';
                $content .= '<title></title>';
                $content .= '</head>';
                $content .= '<body>';
                $content .= '<div class="main_one" style="width: 900px; background: #F1F4F8; margin: auto; left: 0; right: 0; padding-top: 40px; padding-bottom: 40px;" >';
                $content .= '<div class="main" style="width: 700px; background: white; margin: auto; left: 0; right: 0;">';
                // $content .= '<div class="img1" style="text-align: center;">';
                // $content .= '<img src="'.$href.'/assets/images/'.$upload_logo.'" style="padding: 30px 0px; width:15%;">';
                // $content .= '</div>';
                // $content .= '<div class="img2">';
                // $content .= '<img src="'.$href.'/assets/images/Thanks.png" style="width: 100%">';
                // $content .= '</div>';
                $content .= '<div class="cont">';
                $content .= '<h2 style="text-align: center; color: #003188; font-weight: bold; font-size: 45px;">We Appreciate your <br> feedback!</h2>';
                $content .= '<p style="text-align: justify; padding: 0px 15px;line-height: 1.6; font-size: 19px;">Your anaesthetist is the specialist doctor responsible for your safety and comfort during and immediately after your surgery. Your feedback will be highly appreciated by our anaesthetist and anaesthesia team.<br>
                The entire survey should only take about 5 minutes to complete and the purpose of the survey is to identify areas of improvement and focus on professional development. We would appreciate your time and rest assured that your feedback will remain anonymous.</p>';
                $content .= '<p style="text-align:center !important;"><a href="'.$href.'" style="background: #F8B370;color: white;padding: 15px 60px;border-radius: 30px;text-decoration: none;font-size: 27px;">CLICK HERE</a></p>'; 
                $content .= '<p style="text-align: justify; padding: 0px 15px;line-height: 1.6; font-size: 19px;" >Best Regards,<br>'.$hospital.'</p>';
                $content .= '</div>';
                
                // $content .= '<div class="last" style="text-align: center; padding-bottom: 10px; border-top: 1px solid #0000006b; padding-top: 30px; margin-top: 25px;">';
                // $content .= '<img src="'.$href.'/assets/images/'.$upload_logo.'" style="width:15%;">';
                // $content .= '</div>';
                /*$content .= '<div class="last2" style="text-align: center;">';
                $content .= '<img src="'.$href.'/assets/images/twitter.png" style="width: 5%;">';
                $content .= '<img src="'.$href.'/assets/images/facebook.png"  style="width: 5%;">';
                $content .= '<img src="'.$href.'/assets/images/instagram.png"  style="width: 5%;">';
                $content .= '<img src="'.$href.'/assets/images/linkedin.png"  style="width: 5%;">';
                $content .= '</div>';*/
                $content .= '<div  style="width: 100%; clear: both; height: 85px; padding-top: 20px; ">';
                $content .= '<div style="width: 50%; float: left; padding-left: 15px; font-size: 19px;">';
                $content .= '<p>Hospital Name: '.$hospital.'</p>';
                // $content .= '<p>Address :<br> '.$res->hospital_address.'</p>';
                $content .= '</div>';

// $content .= '<div style="width: 40%; float: right; font-size: 19px;">';
                // $content .= '<p>email id:<br>'.$res->hospital_email.'</p>';
                // $content .= '</div>';
                $content .= '</div>';

$content .= '<div  style="width: 100%; clear: both; height: 85px; padding-top: 0px; padding-bottom: 30px;">';
                // $content .= '<div style="width: 60%; float: left; font-size: 19px;">';
                // $content .= '<p style="margin-top:0px !important; padding-left:15px;">Website:<br>'.$res->website.'</p>';
                // $content .= '</div>';
                // $content .= '<div style="width: 40%; float: left; font-size: 19px;">';
                // $content .= '<p style="margin-top:0px !important;">Phone number:<br>'.$res->hospital_contact_number.'</p>';
                // $content .= '</div>';
                $content .= '</div>';
                $content .= '</div>';
                $content .= '</div>';
                $content .= '</body>';
                $content .= '</html>';

$email->setMessage($content);
        
            
            if($email->send()){
                $efModel = new labour_EFeedbackModel();
                $data = [
                    'track' => $pass,
                    'flag'  => 1,
                    'patient_id'=>$patient_id,
                    'dr_id'=>$dr_id
                ];
                $efModel->insert($data);
                $insertID = $efModel->insertID();

return json_encode(array(
                    'result'    => 1
                ));
            }else{
                return json_encode(array(
                    'result'    => 0,
                    'message'   => 'Something went wrong.....'
                ));
            }
        // }else{
        //     return view('login');
        // }
        
    }
    public function view_feedback()
    {

// print_r
        $dr_id = session()->get('dr_id');
        // if($dr_id){        
            $tra = $this->request->getVar('id');
            $qq = (array)$tra;
            $data['track'] = $qq;

$patient_id = session()->get('id');
            $model  = new labour_EFeedbackModel();
            $data1  = $model->where('track',$tra)->first();
            $data['test'] = $data1;
            // print_r($data1); die();

return view('labour/e-feedback', $data);
        // }else{
        //     return view('login');
        // }
    }
    public function show_feedback()
    {
        $dr_id = session()->get('dr_id');
        $patient_id = session()->get('id');
        
        // if($dr_id){        
            $Model = new labour_EFeedbackModel(); 
            $Model->where('flag',0);
            $data1  = $Model->where('patient_id',$patient_id)->first();
            $efeed_id = $data1['id'];

$model = new addPatientModel();        
            $details  = $model->get()->getResultArray();
            $data['patient'] = $details;
            
            $model1 = new labour_EFeedbackModel(); 
            $detail = $model1->where('id',$efeed_id)->first();
            $data['info'] = $detail;
        
            $fbk=['s,t,u'];
            $data['feed'] = $fbk;

return view('labour/e-feedbackdetails',$data);
        // }else{
        //     return view('login');
        // }
    }

public function resend()
    {
        $patient_id = session()->get('id');
        $dr_id = session()->get('dr_id');

$email1 = session()->get('patient_email_id');
        $pass = substr(str_shuffle("0123456789abcdefghijklmnopqrstvwxyz"), 0, 6);
        $efModel = new labour_EFeedbackModel();
        $efModel->set('track',  $pass);
        $efModel->where('patient_id',$patient_id);
        $update = $efModel->update(); 
        if($update){
            $email = \Config\Services::email();
           
            $email->setFrom("Contact@medusys.in", "E_Feedback");
            $email->setTo($email1);
            $email->setSubject('Online feedback');

$href = 'https://medusys.in/public/labour/E_Feedback/view_feedback?id='.$pass.'';           
            
            $find_dr = new RegisterUserModel();
            $z = $find_dr->where('id',$dr_id)->first();
            $hospital = $z['hospital'];

// print_r($hospital);die();

$content .= '<html>';
            $content .= '<head>';
            $content .= '<title></title>';
            $content .= '</head>';
            $content .= '<body>';
            $content .= '<div class="main_one" style="width: 900px; background: #F1F4F8; margin: auto; left: 0; right: 0; padding-top: 40px; padding-bottom: 40px;" >';
            $content .= '<div class="main" style="width: 700px; background: white; margin: auto; left: 0; right: 0;">';
            // $content .= '<div class="img1" style="text-align: center;">';
            // $content .= '<img src="'.$href.'/assets/images/'.$upload_logo.'" style="padding: 30px 0px; width:15%;">';
            // $content .= '</div>';
            // $content .= '<div class="img2">';
            // $content .= '<img src="'.$href.'/assets/images/Thanks.png" style="width: 100%">';
            // $content .= '</div>';
            $content .= '<div class="cont">';
            $content .= '<h2 style="text-align: center; color: #003188; font-weight: bold; font-size: 45px;">We Appreciate your <br> feedback!</h2>';
            $content .= '<p style="text-align: justify; padding: 0px 15px;line-height: 1.6; font-size: 19px;">Your anaesthetist is the specialist doctor responsible for your safety and comfort during and immediately after your surgery. Your feedback will be highly appreciated by our anaesthetist and anaesthesia team.<br>
            The entire survey should only take about 5 minutes to complete and the purpose of the survey is to identify areas of improvement and focus on professional development. We would appreciate your time and rest assured that your feedback will remain anonymous.</p>';
            $content .= '<p style="text-align:center !important;"><a href="'.$href.'" style="background: #F8B370;color: white;padding: 15px 60px;border-radius: 30px;text-decoration: none;font-size: 27px;">CLICK HERE</a></p>'; 
            $content .= '<p style="text-align: justify; padding: 0px 15px;line-height: 1.6; font-size: 19px;" >Best Regards,<br>'.$hospital.'</p>';
            $content .= '</div>';
            
            // $content .= '<div class="last" style="text-align: center; padding-bottom: 10px; border-top: 1px solid #0000006b; padding-top: 30px; margin-top: 25px;">';
            // $content .= '<img src="'.$href.'/assets/images/'.$upload_logo.'" style="width:15%;">';
            // $content .= '</div>';
            /*$content .= '<div class="last2" style="text-align: center;">';
            $content .= '<img src="'.$href.'/assets/images/twitter.png" style="width: 5%;">';
            $content .= '<img src="'.$href.'/assets/images/facebook.png"  style="width: 5%;">';
            $content .= '<img src="'.$href.'/assets/images/instagram.png"  style="width: 5%;">';
            $content .= '<img src="'.$href.'/assets/images/linkedin.png"  style="width: 5%;">';
            $content .= '</div>';*/
            $content .= '<div  style="width: 100%; clear: both; height: 85px; padding-top: 20px; ">';
            $content .= '<div style="width: 50%; float: left; padding-left: 15px; font-size: 19px;">';
            $content .= '<p>Hospital Name: '.$hospital.'</p>';
            // $content .= '<p>Address :<br> '.$res->hospital_address.'</p>';
            $content .= '</div>';

// $content .= '<div style="width: 40%; float: right; font-size: 19px;">';
            // $content .= '<p>email id:<br>'.$res->hospital_email.'</p>';
            // $content .= '</div>';
            $content .= '</div>';

$content .= '<div  style="width: 100%; clear: both; height: 85px; padding-top: 0px; padding-bottom: 30px;">';
            // $content .= '<div style="width: 60%; float: left; font-size: 19px;">';
            // $content .= '<p style="margin-top:0px !important; padding-left:15px;">Website:<br>'.$res->website.'</p>';
            // $content .= '</div>';
            // $content .= '<div style="width: 40%; float: left; font-size: 19px;">';
            // $content .= '<p style="margin-top:0px !important;">Phone number:<br>'.$res->hospital_contact_number.'</p>';
            // $content .= '</div>';
            $content .= '</div>';
            $content .= '</div>';
            $content .= '</div>';
            $content .= '</body>';
            $content .= '</html>';

$email->setMessage($content);
            if($email->send()){
                return json_encode(array(
                    'result'    => 1
                ));
            }else{
                return json_encode(array(
                    'result'    => 0,
                    'message'   => 'Something went wrong.....'
                ));
            }
        }
    }
    public function add_efeed(){

$track_id = $this->request->getVar('track_id'); //url track
        $drowsiness = $this->request->getVar('option1');
        $thirst = $this->request->getVar('option3'); 
        $nausea_vomiting = $this->request->getVar('option6');
        $feeling_cold = $this->request->getVar('option7');
        $confusion_disorientation = $this->request->getVar('option8');
        $backpain = $this->request->getVar('option9');
        $shivering = $this->request->getVar('option10');
        $anaesthesist_time = $this->request->getVar('option14');
        $regional_anaesthesia_info = $this->request->getVar('option15');
        $anaesthesia_satisfaction = $this->request->getVar('option16');
        $pain_therapy_satisfaction = $this->request->getVar('option17');
        $numbness_limb_bothering = $this->request->getVar('option19');
        $numbness_pain_experience = $this->request->getVar('option20');
        $overall_satisfaction = $this->request->getVar('overall_satisfaction');
        $any_suggestions = $this->request->getVar('any_suggestions');

$dr_id = session()->get('dr_id');
        $patient_id = session()->get('id');

$efeedData = array( 
            'drowsiness'=> $drowsiness,
            // 'pain_at_surgery'=> $pain_at_surgery, 
            'thirst'=>$thirst,
            // 'hoarseness'=>$hoarseness,
            // 'sore_throat'=> $sore_throat,
            'nausea_vomiting'=> $nausea_vomiting,
            'feeling_cold'=> $feeling_cold,
            'confusion_disorientation' => $confusion_disorientation,
            'backpain'=> $backpain,
            'shivering'=> $shivering,          
            // 'pain_before_surgery'=> $pain_before_surgery, 
            // 'anaesthesist_involved'=> $anaesthesist_involved, 
            // 'well_managed'=> $well_managed,
            'anaesthesist_time'=> $anaesthesist_time,  
            'regional_anaesthesia_info'=>$regional_anaesthesia_info,  
            'anaesthesia_satisfaction'=> $anaesthesia_satisfaction,  
                            //   'pain_therapy_satisfaction'=> $pain_therapy_satisfaction,
            // 'nausea_vomit_satisfaction'=> $nausea_vomit_satisfaction,
            'numbness_limb_bothering'=> $numbness_limb_bothering,
            'numbness_pain_experience'=> $numbness_pain_experience,
            // 'similar_op_again'=> $similar_op_again,
            'overall_satisfaction'=> $overall_satisfaction,
            'any_suggestions'=> $any_suggestions,
            'submission'=>1,
            'flag'=>0,
            'upload_patient_status' => 1

);
        $model  = new labour_EFeedbackModel();
        $data  = $model->where('track',$track_id)->where('submission',0)->first();
        if($data){
            $efeedModel = new labour_EFeedbackModel(); 
            $efeedModel->set($efeedData);
            $efeedModel->where('track',$track_id);
            $update = $efeedModel->update(); 
            if($update){
                $model = new addPatientModel();
                $models = new labour_e_consentModel(); 
                $model1 = new labour_PreProcedureModel();
                $cseModel = new labour_combinedSpinalEpiduralModel();
                $epiModel = new labour_EpiduralModel();
                $spinModel = new labour_SpinalModel();
                $csaModel = new labour_CSA_Model();
                $model2 = new labour_post_procedureModel();
                $model3 = new labour_FollowupModel();
                $models3 = new labour_FollowupCumulativeModel();
                $Models = new labour_FeedbackModel();
                $data = [
                    'upload_patient_status' => 1
                ];
                $data_labour = array(
                    'upload_patient_status_labour' => 1
                );
                $model->set($data_labour);
                $model->where('dr_id',$dr_id)->where('id', $patient_id);
                $insertID1 = $model->update();
                $models->set($data);
                $models->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID2 = $models->update();
                $model1->set($data);
                $model1->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID3 = $model1->update();
                $cseModel->set($data);
                $cseModel->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID4 = $cseModel->update();
                $epiModel->set($data);
                $epiModel->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID5 = $epiModel->update();
                $spinModel->set($data);
                $spinModel->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID6 = $spinModel->update();
                $csaModel->set($data);
                $csaModel->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID7 = $csaModel->update();
                $model2->set($data);
                $model2->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID8 = $model2->update();
                $model3->set($data);
                $model3->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID9 = $model3->update();
                $models3->set($data);
                $models3->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID10 = $models3->update();
                $Models->set($data);
                $Models->where('dr_id',$dr_id)->where('patient_id', $patient_id);
                $insertID11 = $Models->update();
                return json_encode(array(
                    'result'    => 1,
                    'message'   => 'E-Feedback data Added Successfully.....'
                ));
            }
            else{
                return json_encode(array(
                    'result'    => 0,
                    'message'   => 'Something went wrong.....'
                ));
            }
        }
        else{
            return json_encode(array(
                'result'    => 2,
                'message'   => 'Patient already exists.....'
            ));
        }
    }
}
?>