@extends("layouts.master-report")
@section('content')
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h4>{{ __('application.activities') }}</h4>
                    </div>
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                            <li class="breadcrumb-item"><a
                                    href="{{ route('home') }}">{{ __('application.Dashboard') }}</a>
                            </li>
                            <li class="breadcrumb-item active">{{ __('application.crm') }} {{ __('application.reporting') }}</li>
							<li class="breadcrumb-item active">{{ __('application.activities') }}</li>
                        </ol>
                    </div>
                </div>
            </div><!-- /.container-fluid -->
        </section>
        <!-- Main content -->
        <section class="content">
            <div class="row">
                <div class="col-12">
                    <div class="card">
						<div class="card-header" id="card-search-report" style="margin-top: 20px;">
                            <div class="pull-left">
                                <div class="row">
									<div class="col-md-6">
                                        <div class="form-group">
                                            <strong>{{__("application.Start")}} {{__("application.Date")}} [ {{ __('application.Due Date') }} ] :</strong>
                                            {!! Form::text('start_date',null, array('placeholder'=>__("application.Date"),'class' => 'form-control date_picker')) !!}
                                        </div>
                                    </div>
                                    <!-- /.col -->
                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <strong>{{__("application.End")}} {{__("application.Date")}} [ {{ __('application.Due Date') }} ] :</strong>
                                            {!! Form::text('end_date',null, array('placeholder'=>__("application.Date"),'class' => 'form-control date_picker')) !!}
                                        </div>
                                    </div>
									<div class="col-md-6">
                                        <div class="form-group">
                                            <strong>{{__("application.assigned_to")}}:</strong>
                                            {!! Form::select('saleperson_id',getSalemember(),null, ['placeholder' => __('application.Please Select'), 'class' => 'form-control select2']) !!}
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <strong>{{__("application.Customer")}}:</strong>
                                            {!! Form::select('customer_id',getCustomersCrm(),null, ['placeholder' => __('application.Please Select'), 'class' => 'form-control select2']) !!}
                                        </div>
                                    </div>
                                    <!-- /.col -->
                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <strong>{{ __('application.Status') }}:</strong>
											{!! Form::select('activity_status',['1'=>'Pending','2'=>'Done'],null, ['class' => 'form-control select2','placeholder'=>__("application.Please Select")]) !!}
                                        </div>
                                    </div>
                                    <!-- /.col -->
                                    <div class="col-md-6">
                                        <button class="btn btn-success btn-sm" id="search-form">{{__("application.Search")}}</button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="card-body table-responsive">
                            <table id="datable-report-print" class="table table-bordered table-hover nowrap">
                                <thead>
                                    <tr>
										<th>{{ __('application.No') }}</th>
										<th>{{ __('application.Due Date') }}</th>
										<th>{{ __('application.Type') }}</th>
										<th>{{ __('application.summary') }}</th>
										<th>{{ __('application.assigned_to') }}</th>
										<th>{{ __('application.opportunities') }}</th>
										<th>{{ __('application.Customer') }}</th>
										<th>{{ __('application.Description') }}</th>
										<th>{{ __('application.Feedback') }}</th>
										<th>{{ __('application.Status') }}</th>
									</tr>
                                </thead>
                                <tbody>
                                </tbody>
                                {{-- <tfoot1>
                                    <tr id='footer-data'>
                                        <th colspan="11" class="text-center">Total</th>
										<th id="expected_revenue"></th>
                                    </tr>
                                </tfoot1> --}}
                            </table>
                          </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->
@endsection
@section('js')
    <script>
        $(document).ready(function() {
            $('.main-spinner').show();
            datatable = $('#datable-report-print').DataTable({  
                "autoWidth": false,
                ordering: true,
                serverSide: true,
                responsive: false, 
                "searching": true,
                lengthMenu: [[20, 30, 50, 100,200,500,1000], [20, 30, 50, 100,200,500,1000]],
                dom: 'Blfrtip',
                buttons: [
                    {
                        text:      '<i class="fa fa-search"></i>',
                        titleAttr: 'Filter',
                        className: "btn btn-default btn-md",
                        attr:  {
                            id: 'btn-search',
                            onclick:"search_report(this)",
                            style:"background-color:#88B21F;color:white"

                        }
                    },
                    {
                        extend:    'excelHtml5',
                        text:      '<i class="far fa-file-excel"></i>',
                        titleAttr: 'Excel',
                        className: "btn btn-info btn-md"
                    },
                    {
                        text:      '<i class="fa fa-print"></i>',
                        titleAttr: 'Print',
                        className: "btn btn-success btn-md",
                        attr:  {
                            id: 'print-report-id',
                            onclick:"print(this)"
                        }
                    },
                ],
                ajax:{
                    url:"{{ route('activities.activities_reporting') }}",
                    type:"GET",
                    data:function(d){
                        d.saleperson_id = $("select[name=saleperson_id]").val();
                        d.customer_id = $("select[name=customer_id]").val();
						d.activity_status = $("select[name=activity_status]").val();
						d.start_date = $("input[name=start_date]").val();
						d.end_date = $("input[name=end_date]").val();
                    }
                },
                columns: 
                [
                    {data: 'DT_RowIndex','searchable': false,orderable: false},
                    {data:"due_date", name:"crm_activity.due_date"},
					{data:"activity_type",name:"crm_activity_types.name"},
					{data:"summary_note",name:"crm_activity.summary_note"},
                    {data:"sale_person_name", name:"sale_person.name_kh"},
                    {data:"pipeline_name",name:"crm_pipeline.name"},
                    {data:"customer_name",name:"crm_customer.name_kh"},
					{data:"log_note", name:"crm_activity.log_note"},
					{data:"feedback", name:"crm_activity.feedback"},
                    {data:"activity_status", name:"crm_activity.activity_status"}
                ],

                "initComplete": function(settings, json) {
                    $('.main-spinner').hide();
                },
                /*'footerCallback': function ( row, data, start, end, display ) {
                    var api = this.api(), data;
                    var intVal = function ( i ) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '')*1 :
                            typeof i === 'number' ?
                                i : 0;
                    };
        

                    expected_revenue = api
                        .column( 11 )
                        .data()
                        .reduce( function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0 );

                    var currentcyFormat = $.fn.dataTable.render.number( '\,', '.', 2, '$' ).display;
                    $("#expected_revenue").html(currentcyFormat(expected_revenue));
                }*/
            }); 
            $.fn.dataTable.ext.errMode = 'throw';
        });
        function print(){
            var title=`{{ __('application.activities') }} {{ __('application.reporting') }}`;
            var user_name = "{{Auth::user()->name_kh}}";
            var date = "{{\Globals::date_khmers(date('d-m-Y'))}}";
            var table_data = $("#datable-report-print").html();
            let p_name = '';let image = '';let company_name = "";
            @php
                $compay_logo = get_compay_logo();
            @endphp
            @if(!empty(@$compay_logo->company_logo))
                image = `{{ asset('assets/img/upload/'.@$compay_logo->company_logo) }}`;
            @endif

            @if(!empty(@$compay_logo->company_name_kh))
                company_name = "{{ @$compay_logo->company_name_kh }}";
            @endif

            print_report_operation(title,table_data,user_name,date,p_name,image,company_name);// Refference at master page
        }
    </script>
@endsection