EVOLUTION-NINJA

Edit File: Ticket.php

<?php 
namespace App\Controllers\admin;
use App\Controllers\BaseController;
use CodeIgniter\RESTful\ResourceController;
use CodeIgniter\API\ResponseTrait;
use App\Models\CategoriesModel;
use App\Models\OrganisationModel;
use App\Models\RegisterUserModel;
use App\Models\E_LibrarySectionModel;
use App\Models\conferenceModel;
use App\Models\addPatientModel;
use App\Models\Conf_About;
use App\Models\TicketModel;

class Ticket extends BaseController{

public function index(){

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

if($dr_id ){

$model = new OrganisationModel();
    $details  = $model->get()->getResultArray();
    $data['org'] = $details;

$model1 = new TicketModel();
    $model1->where('delete_status','ACTIVE');
    $model1->orderBy('id','DESC');
    $ticketdata  = $model1->get()->getResultArray();
    $data['ticketdata'] = $ticketdata;

return view('admin/ticket-view',$data);

}else{
        return view('admin/super-admin-login');
    }
  }

public function edit_ticket(){

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

if($dr_id ){

$id = $_GET['id'];;

$model = new OrganisationModel();
    $details  = $model->get()->getResultArray();
    $data['org'] = $details;

$model1 = new TicketModel();
    $model1->where('id',$id);
    $ticketdata  = $model1->first();
    $data['ticketdata'] = $ticketdata;

return view('admin/editing-ticket-form',$data);

}else{
        return view('admin/super-admin-login');
    }
  }

public function add_ticket(){

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

if($dr_id ){

$model = new OrganisationModel();
    $details  = $model->get()->getResultArray();
    $data['org'] = $details;

return view('admin/new-ticket',$data);

}else{
        return view('admin/super-admin-login');
    }
  }

public function create_ticket(){

$org_id = session()->get('org_id');
    $dr_id = session()->get('dr_id');
    $name = session()->get('name');
    $email = session()->get('email');

$gamerid = session()->get('gamer_id');

$check_mail = new RegisterUserModel();
    $data = $check_mail->where('email',$email)->first();

$mobile =  $data['mobile'];

$email_new = $email;
  
    $request_type = $this->request->getVar('priority');
    $description = $this->request->getVar('description');

$model1 = new TicketModel();
    $details1  = $model1->orderBy('id','DESC')->get()->getResultArray();
    $t_id = ($details1[0]['id']) + 1;
    $ticket_id = 'TID'.sprintf("%'.03d", $t_id);
    // print_r($ticket_id);die();

$newName = '';

if($this->request->getFile('img_upload')){
        $img_upload = $this->request->getFile('img_upload');

if($img_upload->isValid() && !$img_upload->hasMoved()){
            $newName = $img_upload->getName();
            $path =  'public/uploads/ticketing_img';
            $img_upload->move($path,$newName);    
        }
      }
      if($newName != ''){
         $data = array(
          'dr_id' => $dr_id,
          'org_id' => $org_id,
          'ticket_id' => $ticket_id,
    
          'name' => $name,
          'email' => $email,
          'mobile'=>$mobile,
    
          'type_of_request' => $request_type,
          'img_name'=> $newName,
          'description' => $description,
          'gamerid'=>$gamerid,
    
          'status' => 'Open',
          'delete_status' => 'ACTIVE',
        );
      }
      else{
        $data = array(
          'dr_id' => $dr_id,
          'org_id' => $org_id,
          'ticket_id' => $ticket_id,
    
          'name' => $name,
          'email' => $email,
          'mobile'=>$mobile,
    
          'type_of_request' => $request_type,
          'description' => $description,
          'gamerid'=>$gamerid,
    
          'status' => 'Open',
          'delete_status' => 'ACTIVE',
        );
      }
        
        // print_r($newName);die();

$model = new TicketModel(); 
    $model->save($data);
    $insertedID = $model->insertID();

if($insertedID){

$email = \Config\Services::email();
                
          $email->setFrom("contact@medusys.in", "Medusys Ticket");
          $email->setTo('contact@medusys.in');

$email->setSubject('Medusys Ticket');

$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 .= ''.'You have recieved a new ticket from Medusys Member'.'';
 $content .= ''.'Name :'.$name.'';

$content .= ''.'Eamil :'.$email_new.'';

$content .= ''.'Phone :'.$mobile.'';

$content .= ''.'GamerId :'.$gamerid.'';

$content .= ''.'Type of Request :'.$request_type.'';
 $content .= ''.'Description :'.$description.'';
 $content .= '</div>';
 $content .= '</body>';
 $content .= '</html>';

$email->setMessage($content);
          if($email->send()){
            $a = 1;
          }else{
            $a = 2;
          }
          echo json_encode(array(
            'result'    => 1,
            'message'   => 'New Request is Added Successfully...'
          ));
    }else{
          echo json_encode(array(
            'result'    => 0,
            'message'   => 'Something went wrong....'
          ));
    }
    
    
  }

public function delete_ticket(){

$id = $_GET['id'];
    $org_id = session()->get('org_id');
    $dr_id = session()->get('dr_id');

$data = array(
      'delete_status' => 'INACTIVE',
    );

$model = new TicketModel(); 
    $model->set($data);
    $model->where('id',$id);
    $model->where('org_id',$org_id);
    $model->where('dr_id',$dr_id);
    $update1 = $model->update();

if($update1){
      echo json_encode(array(
        'result'    => 1,
        'message'	  => 'Deleted Successfully...'
      ));
    }else{
      echo json_encode(array(
        'result'    => 0,
        'message'	  => 'Something went wrong....'
      ));
    }
  }

public function ticket_details(){

$id = $_GET['id'];

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

if($dr_id ){

$model = new OrganisationModel();
    $details  = $model->get()->getResultArray();
    $data['org'] = $details;

$model1 = new TicketModel();
    $model1->where('id',$id);
    $ticketdata  = $model1->first();
    $data['ticketdata'] = $ticketdata;

return view('admin/edit-ticket',$data);

}else{
        return view('admin/super-admin-login');
    }
  }

public function update_ticket(){

$id = $this->request->getVar('id');
    $request_type = $this->request->getVar('priority');
    $description = $this->request->getVar('description');
    $admin_description = $this->request->getVar('description1');
    $status = $this->request->getVar('status');

$sub = $this->request->getVar('subject');
    $depart = $this->request->getVar('department');
    $created_by = $this->request->getVar('created_by');
    $date = $this->request->getVar('date');

// $img_upload = $this->request->getFile('img_upload');

// if($img_upload->getName()){

//   if($img_upload->isValid() && !$img_upload->hasMoved()){
    //     $newName = $img_upload->getName();
    //     $path =  'public/uploads/ticketing_img';
    //     $img_upload->move($path,$newName);    
    //   }
      
    // } else{
      
    //   $newName = $this->request->getVar('old_img');
    // }

$data = array(
      'subject' => $sub,
      'department' => $depart,
      'created_by' => $created_by,
      'status' => $status,
      'date' => $date,
      'priority' => $priority,
      'description' => $description,
      'admin_description'=>$admin_description
      //'img_upload'=> $newName
    );

$model = new TicketModel(); 
    $model->set($data);
    $model->where('id',$id);
    $update = $model->update();

if($update){
          echo json_encode(array(
            'result'    => 1,
            'message'   => 'Updated Successfully...'
          ));
    }else{
          echo json_encode(array(
            'result'    => 0,
            'message'   => 'Something went wrong....'
          ));
    }

}

public function user_create_ticket_deleted(){

$f_name = $this->request->getVar('f_name');
    $ph_no = $this->request->getVar('ph_no');
    $email = $this->request->getVar('email');
    $request_type = $this->request->getVar('priority');
    $description = $this->request->getVar('description');

if($newName != ''){
      $data = array(
                'dr_id' => 0,
                'org_id' => 0,
                'ticket_id' => $ticket_id,

'name' => $f_name,
                'email' => $email,
                'mobile' => $ph_no,

'type_of_request' => $request_type,
                'img_name'=> $newName,
                'description' => $description,

'status' => 'Open',
                'delete_status' => 'ACTIVE',
              );
    }
    else{

$data = array(
          'dr_id' => 0,
          'org_id' => 0,
          'ticket_id' => $ticket_id,

'name' => $f_name,
          'email' => $email,
          'mobile' => $ph_no,

'type_of_request' => $request_type,
          'description' => $description,

'status' => 'Open',
          'delete_status' => 'ACTIVE',
        );

}
    $email_new = $email;
    $model = new TicketModel(); 
    $model->save($data);
    $insertedID = $model->insertID();
    
    // print_r($insertedID);
    // die();

if($insertedID){
      $email = \Config\Services::email();
            
      $email->setFrom("contact@medusys.in", "Medusys Ticket");
      $email->setTo('contact@medusys.in');

$email->setSubject('Medusys Ticket');

$content .= ''.'You have recieved a new ticket from Contact us With the following Details'.'';
 $content .= ''.'Name :'.$f_name.'';

$content .= ''.'Eamil :'.$email_new.'';

$content .= ''.'Phone :'.$ph_no.'';

$email->setMessage($content);
          if($email->send()){
            $a = 1;
          }else{
            $a = 2;
          }
    }

if($insertedID){
          echo json_encode(array(
            'result'    => 1,
            'message'   => 'Your  Ticket is Added Successfully...',
            'a'   => $a
          ));
    }else{
          echo json_encode(array(
            'result'    => 0,
            'message'   => 'Something went wrong....'
          ));
    }
    
    
  }
   
}
?>