@extends('layout.main')
@section('filter')

    <div id="datatable-filter" class="fixed new_filter" data-current-user="Art Ramadani" data-order-by-status="1" data-max-chat-history="25">
        <div class="filter-inner">
            <h2 class="filter-header">
                <a href="#" class="filter-close" data-animate="1"><i class="entypo-cancel"></i></a>
                <i class="fa fa-filter"></i>
                Filter
            </h2>
            <form id="subscription_filter" method="get" action="#" class="form-horizontal form-groups-bordered validate" >
                <div class="form-group">
                    <label for="field-1" class="control-label">Account</label>
                    {{ Form::select('AccountID', $accounts, $SelectedAccount->AccountID, array("id"=>"filter_AccountID", "class"=>"select2 filter_AccountID","data-allow-clear"=>"true","data-placeholder"=>"Select Account")) }}
                </div>
                <div class="form-group">
                    <label for="field-1" class="control-label">Service</label>
                    {{ Form::select('ServiceID', $services,'', array("class"=>"select2","data-allow-clear"=>"true","data-placeholder"=>"Select Service")) }}
                </div>
                <div class="form-group">
                    <label for="field-1" class="control-label">Name</label>
                    <input type="text" name="SubscriptionName" class="form-control" value="" />
                </div>
                <div class="form-group">
                    <label for="field-1" class="control-label">Active</label><br/>
                    <p class="make-switch switch-small">
                        <input id="Active" name="Active" type="checkbox" value="1" checked="checked" >
                    </p>
                </div>
                <div class="form-group">
                    <br/>
                    <button type="submit" class="btn btn-primary btn-md btn-icon icon-left" id="subscription_submit">
                        <i class="entypo-search"></i>
                        Search
                    </button>
                </div>
            </form>
        </div>
    </div>
@stop


@section('content')
<ol class="breadcrumb bc-3">
  <li> <a href="{{URL::to('dashboard')}}"><i class="entypo-home"></i>Home</a> </li>  
  <li class="active"> <strong>Account Subscriptions</strong> </li>
</ol>
<h3>Account Subscriptions</h3>
@include('includes.errors')
@include('includes.success')
<div class="clear"></div>
@if(User::checkCategoryPermission('AccountSubscription','Add'))
    <div class="text-right"> <a  id="add-subscription" class=" btn btn-primary btn-sm btn-icon icon-left"><i class="entypo-plus"></i>Add New</a>
      <div class="clear clearfix"><br>
      </div>
    </div>
@endif
<table id="table-subscription" class="table table-bordered datatable">
  <thead>
    <tr>
      <th width="3%"></th>
      <th width="5%">No</th>
      <th width="5%">Account</th>
      <th width="5%">Service</th>
      <th width="5%">Subscription</th>
      <th  width="5%">Invoice Description</th>
      <th width="5%">Qty</th>
      <th width="10%">Start Date</th>
      <th width="10%">End Date</th>
      <th width="5%">Activation Fee</th>
      <th width="5%">Daily Fee</th>
      <th width="5%">Weekly Fee</th>
      <th width="10%">Monthly Fee</th>
      <th width="10%">Quarterly Fee</th>
      <th width="10%">Yearly Fee</th>
      <th width="20%">Action</th>
    </tr>
  </thead>
  <tbody>
  </tbody>
</table>
<script type="text/javascript">
            /**
            * JQuery Plugin for dataTable
            * */
          //  var list_fields_activity  = ['SubscriptionName','InvoiceDescription','StartDate','EndDate'];      
            $("#subscription_filter").find('[name="SubscriptionName"]').val('');
            var data_table_subscription;
            var account_id=$("#subscription_filter").find('[name="AccountID"]').val();
            var update_new_url;
            var postdata;

            jQuery(document).ready(function ($) {

                $('#filter-button-toggle').show();

                $(document).on('change','#subscription-form [name="AnnuallyFee"],#subscription-form [name="QuarterlyFee"],#subscription-form [name="MonthlyFee"]',function(e){
                    e.stopPropagation();
                    var name = $(this).attr('name');
                    var Yearly = '';
                    var quarterly = '';
                    var monthly = '';
                    var decimal_places = 2;
                    if(name=='AnnuallyFee'){
                        var t = $(this).val();
                        t = parseFloat(t);
                        monthly = t/12;
                        quarterly = monthly * 3;
                    }else if(name=='QuarterlyFee'){
                        var t = $(this).val();
                        t = parseFloat(t);
                        monthly = t / 3;
                        Yearly  = monthly * 12;
                    } else if(name=='MonthlyFee'){
                        var monthly = $(this).val();
                        monthly = parseFloat(monthly);
                        Yearly  = monthly * 12;
                        quarterly = monthly * 3;
                    }

                    var weekly =  parseFloat(monthly / 30 * 7);
                    var daily = parseFloat(monthly / 30);

                    if(Yearly != '') {
                        $('#subscription-form [name="AnnuallyFee"]').val(Yearly.toFixed(decimal_places));
                    }
                    if(quarterly != '') {
                        $('#subscription-form [name="QuarterlyFee"]').val(quarterly.toFixed(decimal_places));
                    }
                    if(monthly != '' && name != 'MonthlyFee') {
                        $('#subscription-form [name="MonthlyFee"]').val(monthly.toFixed(decimal_places));
                    }

                    $('#subscription-form [name="WeeklyFee"]').val(weekly.toFixed(decimal_places));
                    $('#subscription-form [name="DailyFee"]').val(daily.toFixed(decimal_places));
                });

            var list_fields  = ["AID","SequenceNo","AccountName","ServiceName", "Name", "InvoiceDescription", "Qty", "StartDate", "EndDate" ,"tblBillingSubscription.ActivationFee","tblBillingSubscription.DailyFee","tblBillingSubscription.WeeklyFee","tblBillingSubscription.MonthlyFee", "tblBillingSubscription.QuarterlyFee", "tblBillingSubscription.AnnuallyFee", "AccountSubscriptionID", "SubscriptionID","ExemptTax","AccountID",'ServiceID','Status','tblBillingSubscription.DiscountAmount','tblBillingSubscription.DiscountType'];
            public_vars.$body = $("body");
            var $search = {};
            var subscription_add_url = baseurl + "/account_subscription/{id}/store";            
            var subscription_datagrid_url = baseurl + "/account_subscription/ajax_datagrid_page";     
           
		    $("#subscription_submit").click(function(e) {                
                e.preventDefault();
                 
                    $search.Name    	=  $("#subscription_filter").find('[name="SubscriptionName"]').val();
					$search.Account 	=  $("#subscription_filter").find('[name="AccountID"]').val();
					$search.ServiceID   =  $("#subscription_filter").find('[name="ServiceID"]').val();										
                    $search.Active  	=  $("#subscription_filter").find("[name='Active']").prop("checked");
					
		 data_table  = $("#table-subscription").DataTable({
            "bDestroy": true,
            "bProcessing":true,
            "bServerSide":true,
            "sAjaxSource": subscription_datagrid_url,
            "iDisplayLength": parseInt('{{CompanyConfiguration::get('PAGE_SIZE')}}'),
            "sPaginationType": "bootstrap",
            "sDom": "<'row'<'col-xs-6 col-left '<'#selectcheckbox.col-xs-1'>'l><'col-xs-6 col-right'<'export-data'T>f>r>t<'row'<'col-xs-6 col-left'i><'col-xs-6 col-right'p>>",
            "aaSorting": [[3, 'desc']],
             "fnServerParams": function(aoData) {				
                aoData.push({"name":"Name","value":$search.Name},{"name":"AccountID","value":$search.Account},{"name":"ServiceID","value":$search.ServiceID},{"name":"Active","value":$search.Active});
                data_table_extra_params.length = 0;
                data_table_extra_params.push({"name":"Name","value":$search.Name},{"name":"AccountID","value":$search.Account},{"name":"ServiceID","value":$search.ServiceID},{"name":"Active","value":$search.Active},{ "name": "Export", "value": 1});
            },
             "aoColumns":
            [           {  "bSortable": false,
                            mRender: function(id, type, full) {
                                return '<div class="details-control subscription_'+full[0]+'" style="text-align: center; cursor: pointer;"><i class="entypo-plus-squared" style="font-size: 20px;"></i></div>';
                            }
                        },
                        {  "bSortable": true },  // 0 Sequence NO
                        {  "bSortable": true },  // 1 account						
                        {  "bSortable": true },  // 2 service
						{  "bSortable": true },  // 2 Name
						{                          // InvoiceDescription
                           "bSortable": true,
                            mRender: function ( id, type, full ) {return id.length > 50 ? (id.substring(0,50)+' ...'):id}							
                          },  // 2 InvoiceDescription
                        {  "bSortable": true },  // 3 Qty
                        {  "bSortable": true },  // 4 StartDate
                        {  "bSortable": true },  // 5 EndDate
                        {  "bSortable": true },  // 6 ActivationFee
                        {  "bSortable": true },  // 7 DailyFee
                        {  "bSortable": true },  // 8 WeeklyFee
                        {  "bSortable": true },  // 9 MonthlyFee
                        {  "bSortable": true },  // 10 QuarterlyFee
                        {  "bSortable": true },  // 11 AnnuallyFee
                        {                        // 12 Action
                           "bSortable": false,
                            mRender: function ( id, type, full ) {
								var edit_account = 0;
								
								var subscription_edit_url = baseurl + "/accounts/{AccountID}/subscription/{id}/update";
					            var subscription_delete_url = baseurl + "/accounts/{AccountID}/subscription/{id}/delete";
                                 action = '<div class = "hiddenRowData" >';
                                 for(var i = 0 ; i< list_fields.length; i++){									 
									list_fields[i] =  list_fields[i].replace("tblBillingSubscription.",'');
                                    action += '<input disabled type = "hidden"  name = "' + list_fields[i] + '"       value = "' + (full[i] != null?full[i]:'')+ '" / >';							if(list_fields[i]=='AccountID'){
										edit_account = full[i];
									}
                                 }
								 subscription_edit_url = subscription_edit_url.replace("{id}",id);
								 subscription_edit_url = subscription_edit_url.replace("{AccountID}",edit_account);
								 
								 subscription_delete_url = subscription_delete_url.replace("{id}",id);
								 subscription_delete_url = subscription_delete_url.replace("{AccountID}",edit_account);
								 
                                 action += '</div>';
                                @if(User::checkCategoryPermission('AccountSubscription','Edit'))
                                 action += ' <a href="' + subscription_edit_url+'" title="Edit" class="edit-subscription btn btn-default btn-sm"><i class="entypo-pencil"></i>&nbsp;</a>'
                                @endif
                                @if(User::checkCategoryPermission('AccountSubscription','Delete'))
                                 action += ' <a href="' + subscription_delete_url+'" title="Delete" class="delete-subscription btn btn-danger btn-sm"><i class="entypo-trash"></i></a>'
                                @endif
                                 return action;
                            }
                          }
                         ],
            "oTableTools": {
                "aButtons": [
                    {
                        "sExtends": "download",
                        "sButtonText": "EXCEL",
                        "sUrl": subscription_datagrid_url+"/xlsx", //baseurl + "/generate_xlsx.php",
                        sButtonClass: "save-collection btn-sm"
                    },
                    {
                        "sExtends": "download",
                        "sButtonText": "CSV",
                        "sUrl": subscription_datagrid_url + "/csv", //baseurl + "/generate_csv.php",
                        sButtonClass: "save-collection btn-sm"
                    }
                ]
            },
           "fnDrawCallback": function() {
                                               $(".dataTables_wrapper select").select2({
                                                   minimumResultsForSearch: -1
                                               });
                             }

        });
                          
             }); 
                    
                
                $('#subscription_submit').trigger('click');
                //inst.myMethod('I am a method');
                $('#add-subscription').click(function(ev){
                        ev.preventDefault();
                        $('#subscription-form').trigger("reset");
                        $('#modal-subscription h4').html('Add Subscription');
                        $("#subscription-form [name=SubscriptionID]").select2().select2('val',"");

                        $('#subscription-form').attr("action",subscription_add_url);
						$('#modal-subscription').find('.dropdown1').removeAttr('disabled');
						document.getElementById('subscription-form').reset();
						$('#AccountID_add_change').val($('#filter_AccountID').val()); 
						$('#ServiceID_add_change').change();
						$('#SubscriptionID_add_change').change();
						$('#AccountID_add_change').change();
						//$('.dropdown1').change();						
                        $('#modal-subscription').modal('show');                        
                });
                $('table tbody').on('click', '.edit-subscription', function (ev) {
                        ev.preventDefault();
                        console.log('status');
                        $('#modal-edit-subscription').trigger("reset");
                        var edit_url  = $(this).attr("href");
                        $('#subscription-form-edit').attr("action",edit_url);
                        var cur_obj = $(this).prev("div.hiddenRowData");
                        for(var i = 0 ; i< list_fields.length; i++){ 
                            $("#subscription-form-edit [name='"+list_fields[i]+"']").val(cur_obj.find("input[name='"+list_fields[i]+"']").val());
                            if(list_fields[i] == 'SubscriptionID'){
                                $("#subscription-form-edit [name='"+list_fields[i]+"']").select2().select2('val',cur_obj.find("input[name='"+list_fields[i]+"']").val());
                            }else if(list_fields[i] == 'ExemptTax'){
                                if(cur_obj.find("input[name='ExemptTax']").val() == 1 ){
                                    $('[name="ExemptTax"]').prop('checked',true).change();
                                }else{
                                    $('[name="ExemptTax"]').prop('checked',false).change();
                                }

                            }else if(list_fields[i] == 'Status'){
                                if(cur_obj.find("input[name='Status']").val() == 1 ){
                                    $('[name="Status"]').prop('checked',true).change();
                                }else{
                                    $('[name="Status"]').prop('checked',false).change();
                                }

                            }
                        }
                        $('#modal-edit-subscription').modal('show');
                });
                $('table tbody').on('click', '.delete-subscription', function (ev) {
                        ev.preventDefault();
                        result = confirm("Are you Sure?");
                       if(result){
                           var delete_url  = $(this).attr("href");
                           submit_ajax_datatable( delete_url,"",0,data_table);
                            //data_table_subscription.fnFilter('', 0);
                           //console.log('delete');
                          // $('#subscription_submit').trigger('click');
                       }
                       return false;
                });
				
				$(document).on("change","#AccountID_add_change",function(){
					var account_change = $(this).val();
					if(account_change){
						/*var UrlGetSubscription1 	= 	"