@extends('layouts.app')
@section('content')
{{-- App::VERSION() --}}
<style>
.search_options.search_options_show {
    z-index: 9;
}
</style>
<!-- Updated on 10 July 2018  -->
       <div class="page_wrapper">
        <div class="main_section">

            <div class="breadcrum">
                <button class="report_contri active">Contributors Report</button>
                <button class="report_book">Books Report</button>
                
                <?php 

                if($selected_quarter==1){
                    $selected_q = "1st Quarter";
                }
                if($selected_quarter==2){
                    $selected_q = "2nd Quarter";
                }
                if($selected_quarter==3){
                    $selected_q = "3rd Quarter";
                }
                if($selected_quarter==4){
                    $selected_q = "4th Quarter";
                }
                if($selected_quarter==5){
                    $selected_q = "Custom Quarter";
                }
                ?>
                <div class="quarter_selector">
                   

                    <!--dates-->
                    <form action="{{action('ReportController@report_multiple_action')}}" method="POST" class="order_form" style="float:right">
                    {{csrf_field()}} 
                    <div class="input_container"> 
                        <input type="hidden" name="selected_qtr" id="selected_qtr" value="{{$selected_quarter}}" >

                        <input type="hidden" name="selected_yr" id="selected_yr" value="{{$selected_year}}">
                        <div class="input-daterange">
                        <div class="btn-group bootstrap-select"><input id="date_from" class="btn dropdown-toggle btn-default" placeholder="From Date" name="from_date" value="{{$week_from}}" type="text"></div>

                        <div class="btn-group bootstrap-select"><input id="date_to" class="btn dropdown-toggle btn-default" placeholder="To Date" name="to_date" value="{{$week_to}}" type="text"></div>  
                        </div>
                      
                    </div>
                    </form>

                    
                    <!-- quarters -->
                    <form action="{{action('ReportController@report_multiple_action')}}" method="POST" class="order_form" style="float:right">
                        {{csrf_field()}} 
                        <input type="hidden" name="from_date" value="{{$week_from}}">
                        <input type="hidden" name="to_date" value="{{$week_to}}">
                        <input type="hidden" name="selected_yr" id="selected_yr" value="{{$selected_year}}">
                        
                        <div class="input_container select_box custom_filters"> 
                            <select name="selected_qtr" id="selected_quarter" class="selectpicker">
                                
                                <?php
                                    if($selected_q != '1st Quarter'){
                                        echo '<option value="1">1st Quarter</option>';
                                    }else{
                                        echo '<option value="'.$selected_quarter.'" selected="selected" class="selected">'.$selected_q.'</option>';
                                    }
                                    if($selected_q != '2nd Quarter'){
                                        echo '<option value="2">2nd Quarter</option>';
                                    }else{
                                        echo '<option value="'.$selected_quarter.'" selected="selected" class="selected">'.$selected_q.'</option>';
                                    }
                                    if($selected_q != '3rd Quarter'){
                                        echo '<option value="3">3rd Quarter</option>';
                                    }else{
                                        echo '<option value="'.$selected_quarter.'" selected="selected" class="selected">'.$selected_q.'</option>';
                                    }
                                    if($selected_q != '4th Quarter'){
                                        echo '<option value="4">4th Quarter</option>';
                                    }else{
                                        echo '<option value="'.$selected_quarter.'" selected="selected" class="selected">'.$selected_q.'</option>';
                                    }
                                    /*if($selected_q != 'Custom Quarter'){
                                        echo '<option value="5">Custom Quarter</option>';
                                    }else{
                                        echo '<option value="'.$selected_quarter.'" selected="selected" class="selected">'.$selected_q.'</option>';
                                    }*/
                                ?>
                               
                            </select>
                        </div>
                    </form>
                    <!-- year -->
                    <form action="{{action('ReportController@report_multiple_action')}}" method="POST" class="order_form" style="float:right">
                    {{csrf_field()}} 
                    <input type="hidden" name="from_date" value="{{$week_from}}">
                    <input type="hidden" name="to_date" value="{{$week_to}}">
                    <input type="hidden" name="selected_qtr" id="selected_qtr" value="{{$selected_quarter}}" >

                    <div class="input_container select_box custom_filters"> 
                        <select name="selected_yr" id="selected_year" class="selectpicker">
                            
                            <?php 
                                if(empty($years_array)){
                                    //if empty, show current year
                                    echo'<option value="'.date('Y').'" selected>'.date('Y').'</option>';

                                }else{
                                    echo $years_array;
                                }
                            ?>
                   
                        </select>
                    </div>
                    </form>

                </div>

            </div>

            <div class="navs_tabs">
                <ul class="nav nav-pills" id="myTab">
                <li class="active contri_hideshow" id="contri_hideshow"><a data-toggle="pill" href="#report_by_title">Report Detail by Title</a></li>
                <li class="book_hideshow" style="display:none;"><a data-toggle="pill" href="#book_report">Book Report</a></li>
                
                <div class="sale_button">
                    <div class="dropdown add_button_2 book_hideshow"  style="display:none;">
                    <button type="button" data-toggle="dropdown" aria-expanded="true" class="buttn"><i class="fa fa-download" aria-hidden="true"></i> Download<span class="caret"></span></button>
                        <ul  class="dropdown-menu">
                            <li id="all_books_fullsale">
                                <a><i class="fa fa-download" aria-hidden="true"></i> Full Sales</a>
                            </li>
                            <li id="all_books_report">
                                <a><i class="fa fa-download" aria-hidden="true"></i> Digital Sales</a>
                            </li>
                        
                            <li id="all_physical_books">
                                <a><i class="fa fa-download" aria-hidden="true"></i> Physical Sales</a>
                            </li>

                            <li id="book_expense_advance">
                                <a><i class="fa fa-download" aria-hidden="true"></i> Expense/Advance Sheet</a>
                            </li>
                            
                            <li id="book_expense_advance">
                                <a href="{{action('BooksalesController@all_adv_report')}}"><i class="fa fa-download" aria-hidden="true"></i> Advance report</a>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="sale_button">
                    <div class="dropdown add_button_2 book_hideshow2"  style="display:none;">
                    <button type="button" data-toggle="dropdown" aria-expanded="true" class="buttn"><i class="fa fa-download" aria-hidden="true"></i></button>
                    <a href="{{action('BooksalesController@download_royaltyreport',['containers'=>1] )}}"  target="_blank">Royalties</a>
                    </div>
                </div>
                </ul>
               
            </div>
            

          <div class="tab-content">

            <!-- First tab starts-->

            
            <div id="report_by_title" class="tab-pane fade in active">
                <div class="inner_section"> 
                    <div class="heading_area">
                        <div class="heading_left">
                            <h1>Contributors List</h1>
                        </div>
                        <div class="heading_right">

                            <!--sorter-->
                            <!-- sending values to CommonController and putting it in session -->
                            <div id="order_form"> 
                                <div class="input_container select_box custom_filters" data-toggle="tooltip" data-placement="top" data-title='Sort List' data-html="true" aria-hidden="true">  
                                    <select name="detailbytitle_order"  class="selectpicker" id="detailbytitle_order">
                                    <option value="1" disabled>Order By</option>
                                    <option value="asc">A-Z</option>
                                    <option value="desc">Z-A</option>
                                    </select>
                                </div>
                            </div>
                            <div id="order_form">
                                <div class="input_container select_box custom_filters"  data-toggle="tooltip" data-placement="top" data-title='Contributors per page' data-html="true" aria-hidden="true">  
                                    <select name="detailbytitle_items" class="selectpicker" id="detailbytitle_items">
                                    <option value="1" disabled>List Per Page</option>
                                    <option value="25">25</option>
                                    <option value="35">35</option>
                                    <option value="45">45</option>
                                    <option value="55">55</option>
                                    </select>
                                </div>
                            </div>

                            <!--search-->
                            <div class="search_section search_for_title">
                                <!--reset button-->
                                <div class="resetbutton_c1 resetbtn_class"><span data-toggle="tooltip" data-placement="top" data-title='Reset Search' data-html="true" aria-hidden="true"><i class="fa fa-refresh" aria-hidden="true"></i></span></div>

                                <div class="resetbutton_empty resetbtn_class" style="display:none"><a href="javascript:window.location.reload(true)"><span data-toggle="tooltip" data-placement="top" data-title='Reset Search' data-html="true" aria-hidden="true"><i class="fa fa-refresh" aria-hidden="true"></i></span></a></div>


                                <input placeholder="Press Enter to Search.." type="search" name="simplesearch" id="simplesearch_title"  value="<?php if(isset($_GET['simplesearch_title'])){echo $_GET['simplesearch_title'];} if(isset($searched_item1)){echo $searched_item1;} if(session()->has('searched_item1')){echo session()->get('searched_item1');}?>"/>

                                <input type="submit" value="Search" name="search_title"/>
                                <span class="search_btn"></span>
                                <div class="input_container search_container">
                                    <span class="search_span">Please add an entry</span>
                                </div>
                            </div>
                            <!--end search-->
                        </div>
                    </div>

                    <!-- for title -->
                    @if(session()->has('nothingfound_title'))
                    <div class="empty_state" >
                        <img src="images/upload.png">
                        <h4>No Data Found</h4>
                        <h5>{{ session()->get('nothingfound_title') }}</h5>
                    </div>
                    <style>
                        .paginate_title,.detailbytitle,.no_contri_assigned{display:none;}
                        .resetbutton_empty{display:inline-block !important;}
                        .resetbutton_c1{display:none!important;}
                    </style>
                    @endif
                    <!-- for no entry -->
                    @if(session()->has('emptysearch_title'))
                    <div class="empty_state" >
                        <img src="images/upload.png">
                        <h4>No Data Found</h4>
                        <h5>{{ session()->get('emptysearch_title') }}</h5>
                    </div>
                    <style>
                        .paginate_title,.detailbytitle,.no_contri_assigned_title{display:none;}
                        .resetbutton_empty{display:inline-block !important;}
                        .resetbutton_c1{display:none!important;}
                    </style>
                   @endif

                    <!-- if no contributor is found in selected quarter/year -->
                    <?php if(session()->has('no_contributors_found')) { ?>
                    <div class="empty_state no_contri_assigned_title" >
                    <img src="images/upload.png">
                    <h4>No Data Found</h4>
                    <h5><?php echo session()->get('no_contributors_found'); ?></h5>
                    </div>
                    <style>
                    .table_custom,.detailbytitle{display:none;}
                    </style>
                    <?php } ?>

                    <!--if no contributor added by publisher start-->
                    @if ($contributor_details_title->isEmpty())
                    <div class="empty_state" >
                        <img src="images/upload.png">
                        <h4>No Contributors Found</h4>
                        <h5>You haven't added any contributor yet</h5>
                    </div>
                    <style>
                        .pagination_custom,.table_custom{display:none;}
                    </style>
                    @endif
                    <!--ends-->

                    <div class="table_custom detailbytitle">

                        <table id="table_first">
                            <thead>
                                <tr>
                                    <th>Contributor Name</th>
                                    <th>Contribution Books</th>
                                    <th>Email</th>
                                    <th>Country</th>
                                    <th>Report</th>
                                </tr>
                            </thead>
                           <tbody>
                                @foreach($contributor_details_title as $details_title_first)
                                <tr>

                                    <?php
                                    $link_book =  $details_title_first->name;

                                    if(strpos($link_book, '#') !== false && strpos($link_book, '&') !== false) {
                                       $link_book =  str_replace("#", "%23", $link_book);
                                       $link_book =  str_replace("&", "%26", $link_book);
                                    }
                                    elseif(strpos($link_book, '#') !== false && strpos($link_book, '&') === false ) {

                                        $link_book =  str_replace("#", "%23", $link_book);

                                    }elseif(strpos($link_book, '&') !== false  && strpos($link_book,  '#') === false ){
                                       $link_book =  str_replace("&", "%26", $link_book);
                                    }

                                    $total_length = strlen($details_title_first->name);
                                    if($total_length > 20){ 
                                        $booktitl = substr($details_title_first->name, 0, 20);
                                    ?>

                                    <td><a class="blue_link" href="<?php echo url('/'); ?>/home?searched_val=<?php echo $link_book; ?>" target="_blank" data-toggle="tooltip" data-title="{{$details_title_first->name}}" data-html="true">{{$booktitl}}...
                                    </a></td>

                                    <?php } else { ?>

                                    <td><a class="blue_link" href="<?php echo url('/'); ?>/home?searched_val=<?php echo $link_book; ?>" target="_blank">{{ $details_title_first->name}}
                                    </a></td>

                                    <?php } ?>

                                    <td>
                                        <b> <a href="javascript:void;" data-id="{{$details_title_first->id}}" onclick="list_of_books(this);return false;" class="green_link">{{$details_title_first->contributions}}</a></b></td>
                                    <td>
                                    @if($details_title_first->email)
                                        {{ $details_title_first->email}}
                                    @else 
                                        - 
                                    @endif</td>
                                    <td>
                                    @if($details_title_first->country)
                                    {{ $details_title_first->country}}
                                    @else 
                                        - 
                                    @endif
                                    </td>
                                    <td>
                                        <div class="dropdown">
                                        <button class="buttn green_link" type="button" data-toggle="dropdown" aria-expanded="true">Action
                                        <span class="caret"></span></button>
                                        <ul class="dropdown-menu">
                                            <li>
                                                <a><span data-toggle="modal" onclick='add_comment_popup({{$details_title_first->id}})' class="addcomment">Comment</span>
                                                </a>
                                            </li>
                                            <li>
                                                <a href="{{action('BooksalesController@download_bookreport',['contri_id'=>$details_title_first->id] )}}" class=" generate_report" target="_blank">Report by Book
                                                </a>
                                            </li>
                                            <li>
                                                <a href="{{action('BooksalesController@container_contributor',['contri_id'=>$details_title_first->id] )}}" class=" generate_report" target="_blank">Summary Report
                                                </a>
                                            </li>
                                        </ul>
                                        </div>
                                    </td>
                                </tr>
                                @endforeach
                                </style>
                            </tbody>
                        </table>
                    </div>
                </div>
                <!-- <div class="pagination_custom table_first">
                    <ul class="table_first_ul">
                    </ul>
                </div> -->
                <div class="pagination_custom paginate_title">
                
                  @if ($contributor_details_title->appends(request()->except('page'))->hasPages())
                        <ul class="pagination">
                        {{-- Previous Page Link --}}
                        @if ($contributor_details_title->appends(request()->except('page'))->onFirstPage())
                            <li class="disabled"><span>&laquo;</span></li>
                        @else
                            <li><a href="{{ $contributor_details_title->appends(request()->except('page'))->previousPageUrl() }}#report_by_title" rel="prev">&laquo;</a></li>
                        @endif

                        @if($contributor_details_title->appends(request()->except('page'))->currentPage() > 3)
                            <li class="hidden-xs"><a href="{{ $contributor_details_title->appends(request()->except('page'))->url(1) }}#report_by_title">1</a></li>
                        @endif
                        @if($contributor_details_title->appends(request()->except('page'))->currentPage() > 4)
                            <li class="disabled hidden-xs"><span>...</span></li>
                        @endif
                        @foreach(range(1, $contributor_details_title->appends(request()->except('page'))->lastPage()) as $i)
                            @if($i >= $contributor_details_title->appends(request()->except('page'))->currentPage() - 2 && $i <= $contributor_details_title->appends(request()->except('page'))->currentPage() + 2)
                                @if ($i == $contributor_details_title->appends(request()->except('page'))->currentPage())
                                    <li class="active"><span>{{ $i }}</span></li>
                                @else
                                    <li><a href="{{ $contributor_details_title->appends(request()->except('page'))->url($i) }}#report_by_title">{{ $i }}</a></li>
                                @endif
                            @endif
                        @endforeach
                        @if($contributor_details_title->appends(request()->except('page'))->currentPage() < $contributor_details_title->appends(request()->except('page'))->lastPage() - 3)
                            <li class="disabled hidden-xs"><span>...</span></li>
                        @endif
                        @if($contributor_details_title->appends(request()->except('page'))->currentPage() < $contributor_details_title->appends(request()->except('page'))->lastPage() - 2)
                            <li class="hidden-xs"><a href="{{ $contributor_details_title->appends(request()->except('page'))->url($contributor_details_title->appends(request()->except('page'))->lastPage()) }}#report_by_title">{{ $contributor_details_title->appends(request()->except('page'))->lastPage() }}</a></li>
                        @endif

                        {{-- Next Page Link --}}
                        @if ($contributor_details_title->appends(request()->except('page'))->hasMorePages())
                            <li><a href="{{ $contributor_details_title->appends(request()->except('page'))->nextPageUrl() }}#report_by_title" rel="next">&raquo;</a></li>
                        @else
                            <li class="disabled"><span>&raquo;</span></li>
                        @endif
                        </ul>
                    @endif
                    <!--  <ul>
                    </ul> -->
                </div>
            </div>
            
            <!-- First tab ends -->


            <!--report book start-->
            
            <div id="book_report" class="tab-pane fade">
                <div class="inner_section"> 
                    <div class="heading_area">
                        <div class="heading_left">
                            <h1>Book List</h1>
                        </div>
                        <div class="heading_right">

                            <div id="order_form">
                                <div class="input_container select_box custom_filters" data-toggle="tooltip" data-placement="top" data-title='Select Platform' data-html="true" aria-hidden="true">  
                                    <select name="detailbybookreport_platform"  class="selectpicker" id="detailbybookreport_platform">
                                        <option value="all_platform" <?php if($platformsession=='all_platform'){echo "selected"; }?> >All Platform</option>
                                        <option value="amazon"  <?php if($platformsession=='amazon'){echo "selected"; }?>>Amazon</option>
                                        <option value="apple"  <?php if($platformsession=='apple'){echo "selected";}?>>Apple</option>
                                        <option value="barnes" <?php if($platformsession=='barnes'){echo "selected";}?>>Barnes & Nobles</option>
                                        <option value="comixology" <?php if($platformsession=='comixology'){echo "selected"; }?>>Comixology</option>
                                        <option value="comixology_sub" <?php if($platformsession=='comixology_sub'){echo "selected"; }?>>Comixology Subscription</option>
                                        <option value="diamond" <?php if($platformsession=='diamond'){echo "selected"; }?>>Diamond</option>
                                        <option value="google" <?php if($platformsession=='google'){echo "selected"; }?>>Google</option>
                                        <option value="oni_press" <?php if($platformsession=='oni_press'){echo "selected"; }?>>Oni Press</option>
                                        <option value="s_s" <?php if($platformsession=='s_s'){echo"selected"; }?>>S & S</option>
                                    </select>
                                </div>
                            </div>
                            <div id="order_form">
                                <div class="input_container select_box custom_filters" data-toggle="tooltip" data-placement="top" data-title='Sort Books' data-html="true" aria-hidden="true">  
                                    <select name="detailbybookreport_order"  class="selectpicker" id="detailbybookreport_order">
                                    <option value="1" disabled>Order By</option>
                                    <option value="asc">A-Z</option>
                                    <option value="desc">Z-A</option>
                                    </select>
                                </div>
                            </div>
                            <div id="order_form">
                                {{csrf_field()}} 
                                <div class="input_container select_box custom_filters" data-toggle="tooltip" data-placement="top" data-title='Books per page' data-html="true" aria-hidden="true">  
                                    <select name="detailbybookreport_items" class="selectpicker" id="detailbybookreport_items">
                                    <option value="1" disabled>List Per Page</option>
                                    <option value="25">25</option>
                                    <option value="35">35</option>
                                    <option value="45">45</option>
                                    <option value="55">55</option>
                                    </select>
                                </div>
                            </div>

                            <!-- search -->
                            <div class="search_section bookreport_search">

                                <!-- reset button -->
                                <div class="resetbutton resetbtn_class"><span  data-toggle="tooltip" data-placement="top" data-title='Reset Search' data-html="true"><i class="fa fa-refresh" aria-hidden="true"></i></span></div>

                                <div class="resetbutton_empty resetbtn_class" style="display:none"><a href="javascript:window.location.reload(true)"><span  data-toggle="tooltip" data-placement="top" data-title='Reset Search' data-html="true"><i class="fa fa-refresh" aria-hidden="true"></i></span></a></div>

                                <input placeholder="Press Enter to Search.." type="search" name="search" id="booksearch"  value="<?php if(isset($_GET['searched_val'])){echo $_GET['searched_val'];} if(isset($searched_item3)){echo $searched_item3;} if(session()->has('searched_item3')){echo session()->get('searched_item3');}?>"/>
                                
                                <input type="submit" value="Search" name="seachbook"/>
                                <span class="search_btn"></span>
                                <div class="input_container search_container">
                                    <span class="search_span">Please add an entry</span>
                                </div>
                            </div>
                            <!--end search-->

                        </div>
                    </div>


                    <!-- for title -->
                    @if(session()->has('nothingfound_book'))
                    <div class="empty_state" >
                        <img src="images/upload.png">
                        <h4>No Data Found1</h4>
                        <h5>{{ session()->get('nothingfound_book') }}</h5>
                    </div>
                    <style>
                        .paginate_book,.detailbybookreport,.no_contri_assigned{display:none;}
                        .resetbutton_empty{display:inline-block !important;}
                        .resetbutton{display:none!important;}
                    </style>
                    @endif
                    <!-- for no entry -->
                    @if(session()->has('emptysearch_book'))
                    <div class="empty_state" >
                        <img src="images/upload.png">
                        <h4>No Data Found2</h4>
                        <h5>{{ session()->get('emptysearch_book') }}</h5>
                    </div>
                    <style>
                        .paginate_book,.detailbybookreport,.no_contri_assigned_title{display:none;}
                        .resetbutton_empty{display:inline-block !important;}
                        .resetbutton{display:none!important;}
                    </style>
                   @endif

                    <!-- if no contributor is found in selected quarter/year -->
                    <?php if(session()->has('no_contributors_found')) { ?>
                    <div class="empty_state no_contri_assigned_title" >
                    <img src="images/upload.png">
                    <h4>No Data Found3</h4>
                    <h5><?php echo session()->get('no_contributors_found'); ?></h5>
                    </div>
                    <style>
                    .table_custom,.detailbybookreport{display:none;}
                    </style>
                    <?php } ?>

                    <!--if no books added by publisher start-->
                    @if ($reports_bookdata->isEmpty())
                    <div class="empty_state" >
                        <img src="images/upload.png">
                        <h4>No Books Found</h4>
                        <h5>You haven't added any book yet</h5>
                    </div>
                    <style>
                        .pagination_custom,.table_custom{display:none;}
                    </style>
                    @endif
                    <!--ends-->

                    <div class="table_custom detailbybookreport">

                        <table id="table_first">
                            <thead>
                                <tr>
                                    <th>Book Name</th>
                                    <th>Contributors</th>
                                    <th>ISBN Physical 13</th>
                                    <th>ISBN Digital 13</th>
                                    <th>ISBN 10</th>
                                    <th>Print Price</th>
                                    <th>Report</th>
                                </tr>
                            </thead>
                           <tbody>
                                @foreach($reports_bookdata as $reportsbookdata)
                                <tr>
                                    
                                    <?php
                                    $link_book =  $reportsbookdata->book_title;

                                    if(strpos($link_book, '#') !== false && strpos($link_book, '&') !== false) {
                                       $link_book =  str_replace("#", "%23", $link_book);
                                       $link_book =  str_replace("&", "%26", $link_book);
                                    }
                                    elseif(strpos($link_book, '#') !== false && strpos($link_book, '&') === false ) {

                                        $link_book =  str_replace("#", "%23", $link_book);

                                    }elseif(strpos($link_book, '&') !== false  && strpos($link_book,  '#') === false ){
                                       $link_book =  str_replace("&", "%26", $link_book);
                                    }

                                    $total_length = strlen($reportsbookdata->book_title);
                                    ?>
                                    
                                    <td>
                                    <!--Disabled book-->
                                    @if($reportsbookdata->disabled_book==1)
                                    <i class="fa fa-exclamation-triangle red_link" aria-hidden="true" data-toggle="tooltip" data-placement="top" data-html="true" data-title="Disabled Book." style="color:Red" data-original-title="" title=""></i>
                                    @endif

                                    <!--Out of print-->
                                    @if($reportsbookdata->out_of_print == 1)
                                    <span aria-hidden="true" data-toggle="tooltip" data-placement="top" data-title="<b>Out of Print</b> : {{$reportsbookdata->print_date}}" data-html="true" >
                                    <img src="images/out_print.png" width="20"/></span>
                                    @endif

                                    <!-- container checks starts-->
                                    @if(in_array($reportsbookdata->id, $book_contained_ids) && in_array($reportsbookdata->id, $book_container_ids))
                                    <i class="fa fa-briefcase navy_link" aria-hidden="true" data-toggle="tooltip" data-placement="top" data-html="true" data-title='<b style="text-align:left;">Main Container Items:</b><?php $i = 0; ?><ul style="list-style:none;">@foreach($book_main_container_title[$reportsbookdata->id] as $books)<?php $i++;?><li><b>{{$i}}.</b> {{$books}}</li>@endforeach</ul><b>Contained Items:</b> <?php $i = 0; ?> <ul style="list-style:none;">@foreach($book_containers_titles[$reportsbookdata->id] as $books)<?php $i++;?><li><b>{{$i}}.</b> {{$books}}</li>@endforeach</ul>'></i>
                                    
                                        
                                    @elseif(in_array($reportsbookdata->id, $book_container_ids))
                                        @if(count($book_containers_titles[$reportsbookdata->id]) > 10)
                                            <i class="fa fa-briefcase green_link" aria-hidden="true" data-toggle="tooltip" data-placement="right" data-html="true" data-title='<b>Contained Items:</b> <?php $i = 0; ?> <ul style="list-style:none;">@foreach($book_containers_titles[$reportsbookdata->id] as $books)<?php $i++;?><li><b>{{$i}}.</b> {{$books}}</li>@endforeach</ul>'></i>
                                        @else
                                            <i class="fa fa-briefcase green_link" aria-hidden="true" data-toggle="tooltip" data-placement="top" data-html="true" data-title='<b>Contained Items:</b> <?php $i = 0; ?> <ul style="list-style:none;">@foreach($book_containers_titles[$reportsbookdata->id] as $books)<?php $i++;?><li><b>{{$i}}.</b> {{$books}}</li>@endforeach</ul>'></i>
                                        @endif
                                        
                                    @elseif(in_array($reportsbookdata->id, $book_contained_ids))
                                    <i class="fa fa-briefcase red_link" aria-hidden="true" data-toggle="tooltip" data-placement="top" data-html="true" data-title='<b>Main Container Items:</b><?php $i = 0; ?><ul style="list-style:none;">@foreach($book_main_container_title[$reportsbookdata->id] as $books)<?php $i++;?><li><b>{{$i}}.</b> {{$books}}</li>@endforeach</ul>'></i>
                                        
                                    @endif

                                        <!-- container checks ends-->
                                    <?php
                                    if($total_length > 30){ 
                                        $booktitl = substr($reportsbookdata->book_title, 0, 30);
                                    ?>
                                        <a class="blue_link" href="<?php echo url('/'); ?>/booklist?searched_val=<?php echo $link_book; ?>" target="_blank" data-toggle="tooltip" data-title="{{ $reportsbookdata->book_title}}" data-html="true">{{$booktitl}}...
                                        </a>
                                    <?php }else{?>
                                   
                                        <a class="blue_link" href="<?php echo url('/'); ?>/booklist?searched_val=<?php echo $link_book; ?>" target="_blank">{{ $reportsbookdata->book_title}}
                                        </a>
                                    <?php } ?>
                                    </td>

                                    <td>
                                    @if(isset($c_names[$reportsbookdata->id]) && !empty($c_names[$reportsbookdata->id][0]))
                                    <a data-toggle="modal" data-target="#list_contributors" class="green_link contri_list" id='more_contri_{{$reportsbookdata->id}}' onclick='show_contributors({{$reportsbookdata->id}} );'>{{count($c_names[$reportsbookdata->id])}}
                                    </a>
                                    @else
                                    -
                                    @endif
                                    </td>


                                    <td>
                                    @if($reportsbookdata->isbn_code)
                                        {{ $reportsbookdata->isbn_code}}
                                    @else 
                                        - 
                                    @endif</td>
                                    <td>
                                    @if($reportsbookdata->isbn_code3)
                                        {{ $reportsbookdata->isbn_code3}}
                                    @else 
                                        - 
                                    @endif
                                    </td>
                                    <td>
                                    @if($reportsbookdata->isbn_code2)
                                        {{ $reportsbookdata->isbn_code2}}
                                    @else 
                                        - 
                                    @endif
                                    </td>
                                    <td>
                                    @if($reportsbookdata->print_price)
                                    ${{ $reportsbookdata->print_price}}
                                    @else 
                                        - 
                                    @endif
                                    </td>
                                    <td id="genreport-{{$reportsbookdata->id}}">
                                        <?php 
                                        #checking if the collection of contributors is not empty
                                        if(!empty($reportsbookdata->contri_count)){
                                            
                                            #converting it to array
                                            $contri_Arr = explode(",", $reportsbookdata->contri_count);
                                            
                                            #getting the collection of the count of assigned contributors
                                            $contri_count = count($contri_Arr);
                                            
                                            #convertion to array
                                            $merged_Arr = explode(",", $reportsbookdata->merged_sum);

                                            #getting sum of the merged collection
                                            $merged_sum = array_sum($merged_Arr);

                                        }else{
                                            $contri_count = 0;
                                            $merged_sum = 0;
                                        }

                                        ?>
                                        @if($reportsbookdata->disabled_book==1)
                                        <span class="red_link" ><a>Disabled Book</a></span>
                                        @else
                                        <div class="dropdown">
                                            <button class="buttn green_link" type="button" data-toggle="dropdown" aria-expanded="true">Sales
                                            <span class="caret"></span></button>
                                            <ul class="dropdown-menu">
                                                <li>
                                                    <a href="{{action('ReportController@download_bookdata',$reportsbookdata->id)}}" class="generate_report" target="_blank" >Raw Data Report</a>
                                                </li>
                                                @if($reportsbookdata->contri_count != "" && $contri_count >  $merged_sum)
                                                <li id="sale_report_{{$reportsbookdata->id}}">
                                                <?php 
                                                if($reportsbookdata->out_of_print != 1){ ?>

                                                <a href="{{action('BooksalesController@book_sales_first',['book_id'=>$reportsbookdata->id] )}}" id="sale_report_{{$reportsbookdata->id}}" target="_blank" data-added_by="{{Auth::user()->id}}" >Sale Report</a>

                                                <?php 
                                                }elseif($reportsbookdata->out_of_print == 1 && isset($out_print_arr[$reportsbookdata->id])){

                                                    foreach($out_print_arr[$reportsbookdata->id] as $year=> $quarter_string ) {

                                                        if( $year==$selected_year && (strpos($quarter_string, $selected_quarter) !==false)){
                                                            ?>
                                                            <a href="{{action('BooksalesController@book_sales_first',['book_id'=>$reportsbookdata->id] )}}" id="sale_report_{{$reportsbookdata->id}}" target="_blank" data-added_by="{{Auth::user()->id}}" >Sale Report</a>
                                                        <?php }else{ ?>
                                                            <a class="red_link">Out of Print</a>
                                                        <?php }
                                                    }

                                                }elseif($reportsbookdata->out_of_print == 1 && !isset($out_print_arr[$reportsbookdata->id]) ){ ?>

                                                        <a href="{{action('BooksalesController@book_sales_first',['book_id'=>$reportsbookdata->id] )}}" id="sale_report_{{$reportsbookdata->id}}" target="_blank" data-added_by="{{Auth::user()->id}}" >Sale Report</a>

                                                <?php 
                                                }
                                                ?>
                                                </li>
                                                @endif

                                                <li>
                                                    <a href="{{action('BooksalesController@advance_collection',['book_id'=>$reportsbookdata->id] )}}" generate_report">Advance Report</a>
                                                </li>
                                                
                                            </ul>
                                        </div>
                                        @endif
                                    </td>
                                </tr>
                                @endforeach
                                </style>
                            </tbody>
                        </table>
                    </div>
                </div>
               <!----Pagination------------>
                <div class="pagination_custom paginate_book">
                
                  @if ($reports_bookdata->appends(request()->except('page'))->hasPages())
                        <ul class="pagination">
                        {{-- Previous Page Link --}}
                        @if ($reports_bookdata->appends(request()->except('page'))->onFirstPage())
                            <li class="disabled"><span>&laquo;</span></li>
                        @else
                            <li><a href="{{ $reports_bookdata->appends(request()->except('page'))->previousPageUrl() }}#book_report" rel="prev">&laquo;</a></li>
                        @endif

                        @if($reports_bookdata->appends(request()->except('page'))->currentPage() > 3)
                            <li class="hidden-xs"><a href="{{ $reports_bookdata->appends(request()->except('page'))->url(1) }}#book_report">1</a></li>
                        @endif
                        @if($reports_bookdata->appends(request()->except('page'))->currentPage() > 4)
                            <li class="disabled hidden-xs"><span>...</span></li>
                        @endif
                        @foreach(range(1, $reports_bookdata->appends(request()->except('page'))->lastPage()) as $i)
                            @if($i >= $reports_bookdata->appends(request()->except('page'))->currentPage() - 2 && $i <= $reports_bookdata->appends(request()->except('page'))->currentPage() + 2)
                                @if ($i == $reports_bookdata->appends(request()->except('page'))->currentPage())
                                    <li class="active"><span>{{ $i }}</span></li>
                                @else
                                    <li><a href="{{ $reports_bookdata->appends(request()->except('page'))->url($i) }}#book_report">{{ $i }}</a></li>
                                @endif
                            @endif
                        @endforeach
                        @if($reports_bookdata->appends(request()->except('page'))->currentPage() < $reports_bookdata->appends(request()->except('page'))->lastPage() - 3)
                            <li class="disabled hidden-xs"><span>...</span></li>
                        @endif
                        @if($reports_bookdata->appends(request()->except('page'))->currentPage() < $reports_bookdata->appends(request()->except('page'))->lastPage() - 2)
                            <li class="hidden-xs"><a href="{{ $reports_bookdata->appends(request()->except('page'))->url($reports_bookdata->appends(request()->except('page'))->lastPage()) }}#book_report">{{ $reports_bookdata->appends(request()->except('page'))->lastPage() }}</a></li>
                        @endif

                        {{-- Next Page Link --}}
                        @if ($reports_bookdata->appends(request()->except('page'))->hasMorePages())
                            <li><a href="{{ $reports_bookdata->appends(request()->except('page'))->nextPageUrl() }}#report_by_title" rel="next">&raquo;</a></li>
                        @else
                            <li class="disabled"><span>&raquo;</span></li>
                        @endif
                        </ul>
                    @endif
                </div>
               <!-------End pagination---->
            </div>
            
            <!--report book end-->

        </div>
        </div>
    </div>

<!-- add comment modal -->

<div class="modal fade custom_modal" id="add_comment" class="add_comment" role="dialog">
<div class="modal-dialog modal-lg modal_custom_width_xs">
  <div class="modal-content">
    <div class="modal-header">
    <button type="button" class="close" data-dismiss="modal"><img src="images/cross.png" /></button>
       <h4 class="modal-title">Add Comment</h4>
    </div>
    <form method="POST" value="{{ csrf_token() }}" id="add_comment_function">
    {{ csrf_field() }}
        <div class="modal-body">
            <div class="contri_info">
                <h5>Contributor Name : <span class="contri_name"></span></h5>
                <input type="hidden" class="contributor_id" name="contributor_id" value="">
            </div>
            <div class="label_field">
                <label>Comment</label>
                <div class="input_container">
                   <textarea placeholder="Add Comment" name="add_comment" id="add_comment"> </textarea>
                    <div class="input_container error add_comment_error"> </div>
                </div>
                <div class="input_container error add_comment_error"></div>
            </div>
        </div>
        <div class="modal-footer">
            <input class="popup_btn " type="submit" name="add_comment_report" value="Add"/>
        </div>
    </form>
  </div>
</div>
</div>
<!--add comment popup ends-->

<!-- list of books-->
<div class="modal fade custom_modal" id="list_of_books" role="dialog">
    <div class="modal-dialog modal-md">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal"><img src="images/cross.png" /></button>
                <h4 class="modal-title">List of Books</h4>
            </div>
            {{ csrf_field() }}
            <div class="modal-body">
                <div class="contri_info"></div>
                <div class="contri_table">
                    <table class="list_book_table"><tbody></tbody></table>
                    <div class="contri_table more_table add_accord"></div>
                </div>
            </div>
            <div class="modal-footer">
                <input class="popup_btn" data-dismiss="modal" type="button" value="OK" placeholder="">
            </div>
        </div>
    </div>
</div>

<!--list of contributors on click -->

<div class="modal fade custom_modal" id="list_contributors" role="dialog">
    <div class="modal-dialog modal-md">
        <div class="modal-content">
        <div class="modal-header">
            <button type="button" class="close" data-dismiss="modal"><img src="images/cross.png" /></button>
            <h4 class="modal-title">List of Contributors</h4>
        </div>
        <div class="col-md-12 col-sm-12 col-xs-12">
            
        </div>
        <div class="modal-body">
            <div class="contri_info"></div>
            <div class="contri_table more_table" ></div>
        </div>
        <div class="modal-footer">
            <a class="edit_percentage"></a>
            <input class="popup_btn" data-dismiss="modal" type="button" value="OK" placeholder="">
        </div>
        </div>
    </div>
</div>
<!--list of contributor ends-->

<input type="hidden" class="home_url" value="<?php echo url('/');?>">

<script>
$(document).ready(function(){
/** getting the first date of the quarter**/
    function getStartDate() {
        var yearval = $('#selected_year').val();
        var quarterval = $('#selected_quarter').val();

        //if it is not a custom quarter
        if(quarterval != 5){
            quarterval = quarterval - 1;
            var firstDate = new Date(yearval, quarterval * 3);
            f_Date = (firstDate.getMonth()+1) + "/"  + firstDate.getDate() + "/"+ firstDate.getFullYear();
            return f_Date;
        }else{
            firstDate = new Date(yearval, 0, 1);
             f_Date = (firstDate.getMonth()+1) + "/"  + firstDate.getDate() + "/"+ firstDate.getFullYear()
            return f_Date;
        }
    }
    


    /** getting the last date of the quarter**/
    function getEndDate() {
        var yearval = $('#selected_year').val();
        var quarterval = $('#selected_quarter').val();

        //if it is not a custom quarter
        if(quarterval != 5){
            quarterval = quarterval - 1;
            var firstDate = new Date(yearval, quarterval * 3);
            var endDate = new Date(firstDate.getFullYear(), firstDate.getMonth() + 3, 0);
            e_Date = (endDate.getMonth()+1) + "/"  + endDate.getDate() + "/"+ endDate.getFullYear();
            return e_Date;   
        }else{
            endDate = new Date(yearval, 11, 31);
            e_Date = (endDate.getMonth()+1) + "/"  + endDate.getDate() + "/"+ endDate.getFullYear();
            return e_Date;
        }
    }

    /** putting dates in the vars **/
    var start = getStartDate();
    var end_date = getEndDate();

    /* getting the sessions dates*/
    var week_from = "";
    week_from = '<?php if(session()->has('week_from')){ echo date("n/j/Y", strtotime(session('week_from'))); }else{echo "";}?>';
    if(week_from == ""){
        week_from = getStartDate();
        $('#date_from').val(getStartDate());
    }
    

    var week_to = "";
    week_to = '<?php if(session()->has('week_to')){ echo date("n/j/Y", strtotime(session('week_to'))); }else{echo "";}?>';
    if(week_to == ""){
        week_to = getEndDate();
        $('#date_to').val(getEndDate());
    }

    //setting up the dates datepicker
    $('#date_from,#date_to').datepicker({
        startDate:start,
        endDate:end_date, 
       
    });

    /* on change of date from*/
    $('#date_from').datepicker('setDate', week_from).on('changeDate', function(e) {

        //overriding the var from new value
        var start = $('#date_from').val(); //getting the value from the field
        $('input[name="from_date"]').val(start); // for hidden text field
        //$('#date_from').val(start); //for filling up the visible text field

        /** submit form once the date fields are not empty**/
        // if(($('#date_from').val() !="") && ($('#date_to').val() !="")){ 
        //     $(this).closest('form').trigger('submit');

        // }else{
        //     return false;
        // }


        var date_to_val = $('#date_to').val();
        var date_from_val = $('#date_from').val();
        var selected_quarter_val = $('#selected_quarter').val();
        var selected_year_val = $('#selected_year').val();
        e.preventDefault();

        $.ajaxSetup({
            headers: {
            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
        });

        $.ajax({
            url: "{{action('ReportController@report_multiple_action') }}",
            type:'POST',
            headers: {'X-CSRF-TOKEN': $("input[name='_token']").val()},
            data: {date_to_val:date_to_val,date_from_val:date_from_val,selected_quarter_val:selected_quarter_val,selected_year_val:selected_year_val,},
            beforeSend:function() {
                $(".pre_loader_new").css('display','block'); 
            },
            complete: function() {
                $(".pre_loader_new").css('display','none'); 
            },
            success: function(data) {
                /********Redirect to login page when session expires*********/
                if(data.session==0){
                    parent.location=data['url'];
                }

                if (data.success == 1) {
                   console.log(data);
                    //alert("errors left");
                    $('.input-daterange').datepicker({
                        startDate:getStartDate(),
                        endDate:getEndDate(), 
                    });
                }
               
            }
        });

    });

    //$('#date_from,#date_to').bind('input change', function() {
    $('#date_to').datepicker('setDate', week_to).on('changeDate', function(e) {

        var end_date = $('#date_to').val();//getting the value from the field
        $('input[name="to_date"]').val(end_date);  // for hidden text field

        /** submit form once the date fields are not empty**/
        var date_to_val = $('#date_to').val();
        var date_from_val = $('#date_from').val();
        var selected_quarter_val = $('#selected_quarter').val();
        var selected_year_val = $('#selected_year').val();
        e.preventDefault();
        if(($('#date_from').val() !="") && ($('#date_to').val() !="") ){
            $.ajaxSetup({
                headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                }
            });
            $.ajax({
                url: "{{action('ReportController@report_multiple_action') }}",
                type:'POST',
                headers: {'X-CSRF-TOKEN': $("input[name='_token']").val()},
                data: {date_to_val:date_to_val,date_from_val:date_from_val,selected_quarter_val:selected_quarter_val,selected_year_val:selected_year_val,},
                beforeSend:function() {
                    $(".pre_loader_new").css('display','block'); 
                },
                complete: function() {
                    $(".pre_loader_new").css('display','none'); 
                },
                success: function(data) {
                    /********Redirect to login page when session expires*********/
                    if(data.session==0){
                        parent.location=data['url'];
                    }                
                    if (data.success == 1) {
                        $('.input-daterange').datepicker({
                            startDate:getStartDate(),
                            endDate:getEndDate(), 
                        });
                    }
                }
            });
        }else{
            return false;
        }
    });

    //setting up this so that we can set the range
    $('.input-daterange').datepicker({
        startDate:start,
        endDate:end_date, 
    });

    /* chaning the year and quarter**/
    $("#selected_year,#selected_quarter").change(function(e){
        /** adding these values in the hidden dates fields , as when the new quarter is selected we need new dates to be set up so we destroy and fill the values from default **/
        $('input[name="from_date"]').val(getStartDate()); 
        $('#date_from').val(getStartDate());

        $('input[name="to_date"]').val(getEndDate());
        $('#date_to').val(getEndDate());

        $('.input-daterange').datepicker("destroy");
        $('#date_to').datepicker("destroy");
        $('#date_from').datepicker("destroy");
        
        /* get values for sending in the ajax*/
        var date_to_val = $('#date_to').val();
        var date_from_val = $('#date_from').val();
        var selected_quarter_val = $('#selected_quarter').val();
        var selected_year_val = $('#selected_year').val();
        
        /** Manage Out of print starts here **/
        var op_Arr = <?php echo json_encode($out_print_arr); ?>;
        var s_yr = selected_year_val;
        var s_qtr = selected_quarter_val;
        var year_arr = '<?php echo $years_array ?>';
        var action_url = $(".home_url").val();
        var html_var  = '';
        $.each(op_Arr, function(index, value){
            $.each(value, function(key, data){

                $("#sale_report_"+index).html("");

                if(data.indexOf(s_qtr) > -1 && s_yr == key){
                    console.log("quarter found and year also");
                    html_var = '<a href="'+action_url+'/book_sales_detailed?book_id='+index+'"  target="_blank">Sale Report</a>';
                }else if(s_yr!=key && data.indexOf(s_qtr) > -1){
                    console.log("year not equal but qtr is");
                    html_var = '<a href="'+action_url+'/book_sales_detailed?book_id='+index+'"  target="_blank">Out Of Print</a>';
                
                }else if(s_yr==key && data.indexOf(s_qtr) <= -1){
                    console.log("year equal but not qtr");
                    html_var = '<a href="'+action_url+'/book_sales_detailed?book_id='+index+'"  target="_blank">Out Of Print</a>';
                }
                else if(s_yr!=key && data.indexOf(s_qtr) <= -1){
                    console.log("neither is equal");
                    html_var = '<a >Out Of Print</a>';
                }
            });
            $("#sale_report_"+index).html(html_var);
        });
        /** Manage Out of print ends here **/


        /** submit form once the date fields are not empty**/
        e.preventDefault();
        if(($('#date_from').val() !="") && ($('#date_to').val() !="") ){ 
            $.ajaxSetup({
                headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                }
            });
            $.ajax({
                url: "{{action('ReportController@report_multiple_action') }}",
                type:'POST',
                headers: {'X-CSRF-TOKEN': $("input[name='_token']").val()},
                data: {date_to_val:date_to_val,date_from_val:date_from_val,selected_quarter_val:selected_quarter_val,selected_year_val:selected_year_val,},
                beforeSend:function() {
                    $(".pre_loader_new").css('display','block'); 
                },
                complete: function() {
                    $(".pre_loader_new").css('display','none'); 
                },
                success: function(data) {
                    /********Redirect to login page when session expires*********/
                    if(data.session==0){
                        parent.location=data['url'];
                    }
                    if (data.success == 1) {
                        $('.input-daterange').datepicker({
                            startDate:getStartDate(),
                            endDate:getEndDate(), 
                        });
                    }
                }
            });
        }else{
            return false; 
        }
    });
});
</script>

@endsection