App\Http\Controllers\EnquiriesController

Complexity

Total Complexity

12

Size/Duplication

Total Lines	164
Duplicated Lines	0 %

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	edit()	0	5	1
A	show()	0	7	1
A	index()	0	19	3
A	__construct()	0	3	1
A	update()	0	23	1
A	lost()	0	10	1
A	store()	0	63	2
A	markMember()	0	10	1
A	create()	0	3	1

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Auth;
use DB;
use Carbon\Carbon;
use App\Enquiry;
use App\Followup;
use App\Member;
use App\Plan;
use App\Subscription;
use App\Invoice;
use App\Invoice_detail;
use App\Payment_detail;
use App\Sms_trigger;
use App\Http\Requests;
use App\Http\Controllers\Controller;

class EnquiriesController extends Controller
{   
    public function __construct()
    {
        $this->middleware('auth');
    }

    public function index(Request $request)
    {
      $enquiries = Enquiry::indexQuery($request->sort_field,$request->sort_direction,$request->drp_start,$request->drp_end)->search('"'.$request->input('search').'"')->paginate(10);
      $enquiriesTotal = Enquiry::indexQuery($request->sort_field,$request->sort_direction,$request->drp_start,$request->drp_end)->search('"'.$request->input('search').'"')->get();
      $count = $enquiriesTotal->count();
     
 
      if (!$request->has('drp_start') or !$request->has('drp_end')) 
      {
        $drp_placeholder = "Select daterange filter";
      }
      else
      {
        $drp_placeholder = $request->drp_start. ' - ' .$request->drp_end;
      }

      $request->flash();
      
      return view('enquiries.index', compact('enquiries','count','drp_placeholder'));
      
    }

    public function show($id)
    {
      $enquiry = Enquiry::findOrFail($id);

      $followups = $enquiry->followups->sortByDesc('updated_at');

      return view('enquiries.show', compact('enquiry','followups'));
    }

    public function create()
    {
    	return view('enquiries.create');
    }

    public function store(Request $request)
    {
     // unique values check
     $this->validate($request, ['email' => 'unique:mst_enquiries,email',
                                'contact' => 'unique:mst_enquiries,contact']);

     // Start Transaction
        DB::beginTransaction();

        try {
                // store enquiries details
               $enquiryData = array('name'=>$request->name,
                                    'DOB'=> $request->DOB,
                                    'gender'=> $request->gender,
                                    'contact'=> $request->contact,
                                    'email'=> $request->email,
                                    'address'=> $request->address,
                                    'status'=> \constEnquiryStatus::Lead , 
                                    'pin_code'=> $request->pin_code , 
                                    'occupation'=> $request->occupation , 
                                    'start_by'=> $request->start_by , 
                                    'interested_in'=> implode(',',$request->interested_in), 
                                    'aim'=> $request->aim , 
                                    'source'=> $request->source);

              $enquiry  = new Enquiry($enquiryData);
              $enquiry->createdBy()->associate(Auth::user());
              $enquiry->updatedBy()->associate(Auth::user());
              $enquiry->save();

              //Store the followup details
              $followupData = array('enquiry_id'=>$enquiry->id,
                                     'followup_by'=>$request->followup_by,
                                     'due_date'=>$request->due_date,
                                     'status'=> \constFollowUpStatus::Pending,
                                     'outcome'=>'');

              $followup = new Followup($followupData);
              $followup->createdBy()->associate(Auth::user());
              $followup->updatedBy()->associate(Auth::user());
              $followup->save();

              // SMS Trigger
              $gym_name = \Utilities::getSetting('gym_name');
              $sender_id = \Utilities::getSetting('sms_sender_id');

              $sms_trigger = Sms_trigger::where('alias','=','enquiry_placement')->first();
              $message = $sms_trigger->message;
              $sms_text = sprintf($message,$enquiry->name,$gym_name);
              $sms_status = $sms_trigger->status;

              \Utilities::Sms($sender_id,$enquiry->contact,$sms_text,$sms_status);

              DB::commit();    
              flash()->success('Enquiry was successfully created');                         
              return redirect (action('EnquiriesController@show', ['id' => $enquiry->id]));
            } 

            catch (\Exception $e) 
            {
                DB::rollback();
                flash()->error('Error while creating the Enquiry');
                return redirect (action('EnquiriesController@index'));
            }

    } //End of store method

  	public function edit($id)
    {
      $enquiry=Enquiry::findOrFail($id);

      return view('enquiries.edit', compact('enquiry'));
    }

    public function update($id, Request $request)
    {
        $enquiry=Enquiry::findOrFail($id);

        $enquiry->name = $request->name;
        $enquiry->DOB =  $request->DOB;
        $enquiry->gender =  $request->gender;
        $enquiry->contact =  $request->contact;
        $enquiry->email =  $request->email;
        $enquiry->address =  $request->address;
        $enquiry->pin_code =  $request->pin_code; 
        $enquiry->occupation =  $request->occupation; 
        $enquiry->start_by =  $request->start_by; 
        $enquiry->interested_in =  implode(',',$request->interested_in); 
        $enquiry->aim =  $request->aim; 
        $enquiry->source =  $request->source;
        $enquiry->createdBy()->associate(Auth::user());
        $enquiry->updatedBy()->associate(Auth::user());
        $enquiry->update();

        flash()->success('Enquiry details were successfully updated');

        return redirect (action('EnquiriesController@show', ['id' => $enquiry->id]));
    }

    public function lost($id)
    {
      $enquiry=Enquiry::findOrFail($id);

      $enquiry->status = \constEnquiryStatus::Lost;
      $enquiry->updatedBy()->associate(Auth::user());
      $enquiry->update();

      flash()->success('Enquiry was marked as lost');
      return redirect('enquiries/all');
    }

    public function markMember($id)
    {
      $enquiry=Enquiry::findOrFail($id);

      $enquiry->status = \constEnquiryStatus::Member;
      $enquiry->updatedBy()->associate(Auth::user());
      $enquiry->update();

      flash()->success('Enquiry was marked as member');
      return redirect('enquiries/all');
    }

}