<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;
use Response;

class CustomersController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function __construct(){
    }

    /**
     * Show the application dashboard.
     *
     * @return \Illuminate\Http\Response
     */
    
    /*
    | Customers view
    |--------------------------------------------------------------------------
    */
    public function get_customers(Request $request)
    {
        $data = [];
        $data['title'] = 'Customers';
        $customers = DB::table('customers');
        
        if($request->name){
            $customers = $customers->where('name', 'like', '%' . $request->name . '%');
        }
        if($request->mobile){
            $customers = $customers->where('mobile_number', 'like', '%' . $request->mobile . '%');
        }

        $customers = $customers->orderBy('id','desc')->paginate(30);

        $data['customers'] = $customers; 
        $data['customers_count'] = DB::table('customers')->count();

        return view('admin.customers.customers', $data);
    }

    /*
    | csv_customer
    |--------------------------------------------------------------------------
    */
    public function csv_customer(Request $request)
    {
        ini_set('max_execution_time', '3600');
        $customers = \App\Customers::select('mobile_number')->get();
        if(!empty($customers)){
            $filename = "customers.csv";
            $handle = fopen($filename, 'w+');
            foreach($customers as $row) {
                if ($row->mobile_number != '') {
                    fputcsv($handle, array('92'.substr($row->mobile_number, -10)));
                }
            }
            fclose($handle);
            $headers = array('Content-Type' => 'text/csv');
            return Response::download($filename, 'customers.csv', $headers);
        }else{
            $request->session()->flash('error','Customers not found!');
        }   
    }

    /*
    | Save Customers 
    |--------------------------------------------------------------------------
    */
    public function save_customer(Request $request)
    {
        if($request->id && $request->id !=""){
            //update
            $customer = \App\Customers::find($request->id);
        }else{

            if($request->email && $request->email !=''){
                $check_email = \App\Customers::where('email',$request->email)->first();
                if($check_email){
                    $request->session()->flash('error', $request->email. 'This email is already exist!');
                    return back();
                }
            }
            
            if($request->mobile_number && $request->mobile_number !=''){
                $check_mobile = \App\Customers::where('mobile_number',$request->mobile_number)->first();
                if($check_mobile){
                    $request->session()->flash('error', $request->mobile_number. 'This mobile is number already exist!');
                    return back();
                }
            }

            //add
            $customer = new \App\Customers;
        }  
          
        $customer->name = $request->name;
        $customer->email= $request->email;
        $customer->mobile_number = $request->mobile_number;
        $customer->password = Hash::make($request->password);
        $customer->address  = $request->address;
        $customer->city = $request->city;
        $customer->platform = 'admin';
        $customer->save();

        $request->session()->flash('message', 'Task was successful!');
        return back();
        
    }

    /*
    | Customer status
    |--------------------------------------------------------------------------
    */
    public function status_customer(Request $request)
    {
        if($request->id){
            if($request->status == 1){
                $status = 0;
            }else{
                $status = 1;
            }
            DB::table('customers')->where('id',$request->id)->update(['status' => $status]);
            return response()->json($status);
        }
        abort(404);
    }
    
    /*
    | Delete Customer 
    |--------------------------------------------------------------------------
    */
    public function delete_customer(Request $request)
    {
        if($request->id){
            $delete = \App\Customers::find($request->id);
            $delete->delete();
    
            $request->session()->flash('message', 'Task was successful!');
            return back();
        }
        abort(404);
    }

    /*
    | Getting Single Customer For Update
    |--------------------------------------------------------------------------
    */
    public function get_single_customer(Request $request)
    {
        if($request->id){
            $customer = \App\Customers::findorFail($request->id);
            return response()->json($customer);
        }
        abort(404);
    }

    /*
    | Customer groups view
    |--------------------------------------------------------------------------
    */
    public function get_groups()
    {
        $data = [];
        $data['title'] = 'Customers Groups';

        $data['customers'] = \App\Customers::orderBy('id','desc')->get();
        $data['default_groups'] = \App\CustomerDefaultGroups::all();
        $data['groups'] = \App\CustomerGroups::orderBy('id','desc')->get();
        return view('admin.customers.groups', $data);
    }

    /*
    | Get Customers in a group
    |--------------------------------------------------------------------------
    */
    public function get_customers_group(Request $request)
    {           
        $result = \App\CustomerGroups::select('customer_ids')->where('id',$request->id)->first();        
        $final_array = [];
        if(!empty($result)){
            $customers_array = explode(',',$result->customer_ids);
            foreach ($customers_array as $row) {
                $customer = \App\Customers::select('name')->where('id',$row)->first();
                $final_array[] = ucwords($customer->name);
            }
        }        

        ob_start();
        ?>
            <table class="table table-striped table-bordered dom-jQuery-events">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>Name</th>
                    </tr>
                </thead>
                <tbody>
                <?php $i = 1; ?>
                
                <?php foreach($final_array as $row){ ?>
                    <tr>
                        <td><?php echo $i++ ?></td>
                        <td><?php echo $row ?></td>
                     </tr>
                <?php } ?>
                
               </tbody>
            </table>
        <?php 
        $data = ob_get_contents();
        ob_get_clean();    
            
        return response($data);
    }

    /*
    | Delete Customer group
    |--------------------------------------------------------------------------
    */
    public function delete_customer_group(Request $request)
    {
        if($request->id){
            $delete_cg = \App\CustomerGroups::find($request->id);
            $delete_cg->delete();
    
            $delete_cdg = \App\Customer_groups_detail::where('customer_group_id',$request->id);
            $delete_cdg->delete();
            
            $request->session()->flash('message', 'Task was successful!');
            return back();
        }
        abort(404);
    }

    /*
    | Save Customer group
    |--------------------------------------------------------------------------
    */
    public function save_group(Request $request)
    {
        $create = new \App\CustomerGroups;
        $create->name= $request->name;
        $create->description = $request->description;
        if($request->customer_id != ''){
            $create->customer_ids = implode(',',$request->customer_id);
        }
        $create->save();
        
        $request->session()->flash('message', 'Task was successful!');
        return back();
    }

    /*
    | Customer profile
    |--------------------------------------------------------------------------
    */
    public function get_profile(Request $request)
    {
        $data['title'] = 'Profile';
        $data['customer'] = \App\Customers::find($request->id);
        $data['customer_booked_tables'] = \App\TableReservations::where('customer_id',$request->id)->orderBy('id','desc')->get();
        $data['customer_feedback'] = \App\CustomerFeedback::where('customer_id',$request->id)->orderBy('id','desc')->get();
        $data['customer_orders'] = \App\TakeawayOrders::where('customer_id',$request->id)->orderBy('id','desc')->get();
        
        return view('admin.customers.single.index', $data);
    }

    /*
    | customer order
    |--------------------------------------------------------------------------
    */
    public function get_customer_order(Request $request)
    {
        $customer_order = \App\TakeawayOrders::where('id',$request->id)->first();
        $customer_order_detail = \App\TakeawayOrderDetails::where('order_id',$customer_order->id)->get();
        $customer = \App\Customers::where('id',$customer_order->customer_id)->first();
        $feedback = \App\CustomerFeedback::where('customer_id',$customer->id)->where('order_id',$request->id)->first();

        ob_start();
        ?>

        <div class="panel-body">

            <ul class="nav nav-tabs" id="myTab" role="tablist">
                <li class="nav-item">
                    <a class="nav-link active" id="home-tab" data-toggle="tab" href="#order_tab" role="tab" aria-controls="home" aria-selected="true">Order</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" id="profile-tab" data-toggle="tab" href="#feedback_tab" role="tab" aria-controls="profile" aria-selected="false">Feedback</a>
                </li>
            </ul>

            <div class="tab-content">
                <div role="tabpanel" class="tab-pane active" id="order_tab">
                
                    <div class="row">
                        <div class="col-sm-6">
                            <h3 style="marigin-top:0px">Invoice to</h3>
                            <div id="customer_address"><address><b><?php echo ucwords($customer->name) ?></b><br><?php echo $customer->address.', '.$customer->city ?><br><?php echo $customer->mobile_number ?></address></div>
                        </div>
                        <div class="col-sm-6 m-t-15" style="text-align:right">
                            <p><b>Order ID:</b> <?php echo $customer_order->id ?></p>
                            <p><b>Order Date: </b> <?php echo date("j F Y", strtotime($customer_order->created_at)) ?></p>
                            <p><b>Order Type: </b> <?php echo ucwords($customer_order->order_type) ?></p>    
                            <p><b>Payment Type: </b> <?php echo ucwords($customer_order->payment_type) ?></p>    
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-xs-12">
                            <div class="table-responsive">
                                <table class="table table-bordered">
                                    <thead class="bg-faded">
                                        <tr><th>#</th>
                                        <th>Item</th>
                                        <th style="text-align:center">Quantity</th>
                                        <th style="text-align:right">Price</th>
                                        <th style="text-align:right">Total</th>
                                    </tr></thead>
                                    <tbody>
                                        <?php $i = 1; ?>
                                        
                                        <?php foreach ($customer_order_detail as $row) {?>
                                        <tr>
                                            <td><?php echo $i++ ?></td>
                                            <td><?php echo $row->item_name ?></td>
                                            <td style="text-align:center"><?php echo $row->quantity ?></td>
                                            <td style="text-align:right"><?php echo $row->price ?></td>
                                            <td style="text-align:right"><?php echo $row->item_total_price ?></td>
                                        </tr>
                                        
                                        <?php }?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-md-6 col-sm-6 col-xs-6">
                            <div class="clearfix m-t-30">
                                <?php
                                if($customer_order->special_instructions !=''){
                                    echo "<h4>Special Instructions</h4>";
                                    echo "<p>".$customer_order->special_instructions."</p>";
                                }
                                ?>
                            </div>
                        </div>
                        <div class="col-md-6 col-sm-6 col-xs-6">
                            <p style="text-align:right">Delivery charges : <?php echo $customer_order->delivery_charges;  ?></p>
                            <p style="text-align:right">Tax(<?php echo $customer_order->tax_rate ?>%) : <?php echo $customer_order->tax ?></p>
                            <p style="text-align:right">Subtotal : <?php echo $customer_order->subtotal ?></p>
                            <h3 style="text-align:right"><strong>Total : <?php echo $customer_order->total  ?></strong></h3>
                        </div>
                    </div>

                </div>
                
                <!-- Feedback -->
                <div role="tabpanel" class="tab-pane" id="feedback_tab">
                    
                    <div class="alert alert-success" id="feedback_success" style="display:none;"></div>
                    <div class="alert alert-danger" id="feedback_error" style="display:none;"></div>
                    
                    <form id="feedback_form">
                        
                        <input type="hidden" name="_token" value="<?php echo csrf_token() ?>">
                        <input type="hidden" name="order_id" value="<?php echo $request->id ?>">
                        <input type="hidden" name="customer_id" value="<?php echo $customer->id ?>">
                        
                        <table class="table table-striped table-bordered" style="margin-top:10px">
                            <tr>
                                <th>Quality</th>
                                <th>Servive</th>
                                <th>Value</th>
                            </tr>
                            <tr>
                                <td>
                                    <select class="form-control" name="quality">
                                        <option value="5" <?php if(isset($feedback) && $feedback->quality == 5){ echo 'selected';} ?>>Excellent</option>
                                        <option value="4" <?php if(isset($feedback) && $feedback->quality == 4){ echo 'selected';} ?>>Good</option>
                                        <option value="3" <?php if(isset($feedback) && $feedback->quality == 3){ echo 'selected';} ?>>Average</option>
                                        <option value="2" <?php if(isset($feedback) && $feedback->quality == 2){ echo 'selected';} ?>>Below Average</option>
                                        <option value="1" <?php if(isset($feedback) && $feedback->quality == 1){ echo 'selected';} ?>>Poor</option>                                    
                                    </select>
                                </td>
                                <td>
                                    <select class="form-control" name="service">
                                        <option value="5" <?php if(isset($feedback) && $feedback->service == 5){ echo 'selected';} ?>>Excellent</option>
                                        <option value="4" <?php if(isset($feedback) && $feedback->service == 4){ echo 'selected';} ?>>Good</option>
                                        <option value="3" <?php if(isset($feedback) && $feedback->service == 3){ echo 'selected';} ?>>Average</option>
                                        <option value="2" <?php if(isset($feedback) && $feedback->service == 2){ echo 'selected';} ?>>Below Average</option>
                                        <option value="1" <?php if(isset($feedback) && $feedback->service == 1){ echo 'selected';} ?>>Poor</option>                                    
                                    </select>
                                </td>
                                <td>
                                    <select class="form-control" name="value">
                                        <option value="5" <?php if(isset($feedback) && $feedback->value == 5){ echo 'selected';} ?>>Excellent</option>
                                        <option value="4" <?php if(isset($feedback) && $feedback->value == 4){ echo 'selected';} ?>>Good</option>
                                        <option value="3" <?php if(isset($feedback) && $feedback->value == 3){ echo 'selected';} ?>>Average</option>
                                        <option value="2" <?php if(isset($feedback) && $feedback->value == 2){ echo 'selected';} ?>>Below Average</option>
                                        <option value="1" <?php if(isset($feedback) && $feedback->value == 1){ echo 'selected';} ?>>Poor</option>                                    
                                    </select>
                                </td>
                            </tr>

                            <tr>
                                <th colspan="3">Feedback</th>
                            </tr>
                            <tr>
                                <td colspan="3"><textarea class="form-control" name="feedback"><?php echo isset($feedback)?$feedback->feedback:'' ?></textarea></td>
                            </tr>
                        
                        </table>
                    </form>
                </div>

            </div>

        </div>

        <?php 
        $output = ob_get_contents();
        ob_get_clean();
        return response($output);
    }

    /*
    | Customers feedback view
    |--------------------------------------------------------------------------
    */
    public function get_feedback()
    {
        $data = [];
        $data['title'] = 'Customers Feedback'; 

        $data['data'] = DB::table('customer_feedback as cf')
            ->join('customers as c', 'c.id', '=', 'cf.customer_id')->orderBy('cf.id','desc')->get();
        return view('admin.customers.feedback', $data);
    }

    /*
    | Delete feedback
    |--------------------------------------------------------------------------
    */
    public function delete_feedback(Request $request)
    {
        if($request->id){
            $delete = \App\CustomerFeedback::findorFail($request->id);
            $delete->delete();
            
            $request->session()->flash('message', 'Task was successful!');
            return back();
        }
        abort(404);
    }

    /*
    | Customer Orders Count
    |--------------------------------------------------------------------------
    */
    public function customersOrdersCount()
    {
        $data = [];
        $data['title'] = 'Customer Orders Count';
        $data['customers'] = DB::table('takeaway_orders as o')
        ->leftJoin('customers as c', 'c.id', '=', 'o.customer_id')
        ->where('o.customer_id','!=',NULL)
        ->select('customer_id','name','mobile_number','email','address',DB::raw('COUNT(customer_id) as orders'))
        ->groupBy('customer_id')
        ->orderBy('orders','desc')->paginate(50);

        return view('admin.customers.customer_orders_count', $data);
    }
    

}