@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.opportunities') }}</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.opportunities') }}</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.expected_closing") }} ] :</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.expected_closing") }} ] :</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.Name")}}:</strong>
                                            {!! Form::text('name',null, array('placeholder'=>__("application.Name"),'class' => 'form-control')) !!}
                                        </div>
                                    </div>
									<div class="col-md-6">
                                        <div class="form-group">
                                            <strong>{{__("application.sale_person")}}:</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-6">
                                        <div class="form-group">
                                            <strong>{{ __('application.Type') }}:</strong>
											{!! Form::select('customer_type',['1'=>'Company','2'=>'Individual'],null, ['class' => 'form-control select2','placeholder'=>__("application.Please Select")]) !!}
                                        </div>
                                    </div>
									<div class="col-md-6">
                                        <div class="form-group">
                                            <strong>{{__("application.source")}}:</strong>
											<div class="input-group">
												{!! Form::select('source_id',getMarketing(),null, array('placeholder' => __("application.Please Select"),'class' => 'form-control select2')) !!}
											</div>
                                        </div>
                                    </div>
									<div class="col-md-6">
                                        <div class="form-group">
                                            <strong>{{ __('application.priority') }}:</strong>
											{!! Form::select('priority',getPriority(),null, ['placeholder' => __('application.Please Select'), 'class' => 'form-control select2']) !!}
                                        </div>
                                    </div>
									<div class="col-md-12">
                                        <div class="form-group">
                                            <strong>{{ __('application.stage') }}:</strong>
											{!! Form::select('stage_id',getStage(),null, ['placeholder'=>__("application.Please Select"),'class' => 'form-control select2','required']) !!}
                                        </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.Name') }}</th>
										<th>{{ __("application.probability") }}</th>
										<th>{{ __("application.expected_closing") }}</th>
										<th>{{ __('application.sale_person') }}</th>
										<th>{{ __('application.Customer') }}</th>
										<th>{{ __('application.customer_type') }}</th>
										<th>{{ __('application.Phone') }}</th>
										{{-- <th>{{ __('application.contact_person_name') }}</th>
										<th>{{ __('application.Phone') }}</th>
										<th>{{ __('application.Position') }}</th> --}}
										<th>{{ __('application.source') }}</th>
										<th>{{ __('application.priority') }}</th>
										<th>{{ __('application.stage') }}</th>
										<th>{{ __('application.expected_revenue') }}</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('opportunities.opportunities_reporting') }}",
                    type:"GET",
                    data:function(d){
                        d.name = $("input[name=name]").val();
                        d.saleperson_id = $("select[name=saleperson_id]").val();
                        d.customer_id = $("select[name=customer_id]").val();
                        d.customer_type = $("select[name=customer_type]").val();
						d.source_id = $("select[name=source_id]").val();
						d.priority = $("select[name=priority]").val();
						d.stage_id = $("select[name=stage_id]").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:"lead_name", name:"crm_pipeline.name"},
					{data:"probability",name:"crm_pipeline.probability"},
					{data:"date_expected_closing",name:"crm_pipeline.date_expected_closing"},
                    {data:"saleperson_name", name:"users.name_kh"},
                    {data:"customer_name_kh", name:"crm_customer.name_kh"},
                    {data:"customer_type", name:"crm_customer.type"},
					{data:"customer_phone", name:"crm_customer.phone_number"},
					// {data:"contact_name", name:"crm_contact_person.name_kh"},
					// {data:"contact_phone", name:"crm_contact_person.phone_number"},
					// {data:"position", name:"crm_contact_person.job_position"},
					{data:"source_name", name:"crm_marketing.name"},
                    {data:"priority", searchable:"false"},
					{data:"stage_name",name:'crm_stages.name'},
					{data:"expected_revenue", searchable:"false"}
                ],

                "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.opportunities') }} {{ __('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