<?php $__env->startSection('content'); ?>
<?php
use App\Models\GeneralDaily;
$total=0;
use App\Models\CompanyData;
use App\Models\DefaultDataShowHide;
$Def=CompanyData::orderBy('id','desc')->first();
$show=DefaultDataShowHide::orderBy('id','desc')->first();
?>
 <title><?php echo e(trans('admin.IncomListReport')); ?></title>
 <style>
     table { page-break-inside:auto }
tr    { page-break-inside:avoid; page-break-after:auto }
thead { display:table-header-group; }
tfoot { display:table-footer-group; }
@page  { 
    size: auto;
    margin: 20mm 0 10mm 0;
}
body {
    margin:0;
    padding:0;
}
@page{
    size: 8.27in 11.69in; 
    margin: .5in .5in .5in .5in; 
    mso-header-margin: .5in; 
    mso-footer-margin: .5in; 
    mso-paper-source: 0;
}
@media  print {
   body {
       display: table;
       /*table-layout: fixed;*/
      
       /*padding-bottom: 2.5cm;*/
       /*height: auto;*/
   }
}
 </style>
               
     <main id="js-page-content" role="main" class="page-content">
                    <ol class="breadcrumb page-breadcrumb">
                        <li class="breadcrumb-item"><a href="javascript:void(0);"><?php echo e(trans('admin.Report')); ?></a></li>
                        <li class="breadcrumb-item active"> <?php echo e(trans('admin.IncomListReport')); ?> </li>
                        <li class="position-absolute pos-top pos-right d-none d-sm-block">
                        <span class="js-get-date"></span></li>
                    </ol>
                    
                    <!-- data entry -->
          
                    <div class="row hide-table">
                        <div class="col-xl-12">
                            <div id="panel-1" class="panel">
                                 <div class="modal-body">
                                    <div data-size="A4">
                                       <div class="row invoive-info">
                                            <div style="text-align: center;" class="col-md-4 col-sm-4 col-4 invoice-client-info">
                                                <div class="style-info">
                                                    <h1 style="text-align: center;" class="m-0">
                                               <?php if(!empty($Def->Name)): ?>
                   <?php echo e(app()->getLocale() == 'ar' ?$Def->Name :$Def->NameEn); ?>

                      <?php else: ?>
                       <?php echo e(trans('admin.Klar')); ?>

                      <?php endif; ?>         
                                                    </h1>
                              <h3 style="text-align: center;" class="m-10">
                         <?php if(!empty($Def->Print_Text)): ?>
                       <?php echo e(app()->getLocale() == 'ar' ?$Def->Print_Text :$Def->Print_Text_En); ?>     
                      <?php endif; ?>                
                                                    </h3>
                                                </div>
                                            </div>
                                            <div style="text-align: center;" class="col-md-4 col-sm-4 col-4 invoice-client-info">
             
              <h1><?php echo e(trans('admin.ExpensesList')); ?></h1>
                   
                                            </div>
                                   <div style="text-align: center;" class="col-md-4 col-sm-4 col-4 invoice-client-info">
                         <div class="style-info">
                       <?php if(!empty($Def->Logo)): ?>         
    <img style="height: 50px; width: 150px;" class="img-fluid" src="<?php echo e(URL::to($Def->Logo)); ?>" alt="Logo" />
                                       
                    <?php else: ?>  
 <img style="height: 50px; width: 150px;" class="img-fluid" src="https://klarerp.com/site/img/theme/logo.png" alt="Logo" />
                      <?php endif; ?>
               
                             
            <input type="checkbox" id="CHANGE" class="form-control m-2 m2 no-print" onclick="ChangeClass()"><span class="no-print"><?php echo e(trans('admin.PrintDetails')); ?>  </span>              
                                       </div>
                                            </div>
                                        </div>
                                        <hr />
                                        <div class="row"></div>
                                      
                                        <div class="row">
                                            <div class="col-sm-12">
                                                <div class="table-responsive-lg">
                                      <div class="over-flow">
                                        <table 
                                            class="table table-bordered table-hover table-striped">
                                            <thead class="bg-highlight">
                                                <tr>
                                                       <th><?php echo e(trans('admin.Name')); ?> </th>
                                                       <th><?php echo e(trans('admin.Total')); ?> </th>
                                                        
                                                </tr>
          
                                            </thead>
                                        
                                            <tbody>
                                                <?php $__currentLoopData = $items; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $item): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                             <?php
                                  $subAccount=$item->id;
                                              $lists=GeneralDaily::whereBetween('Date',[$from,$to]) 
                                
                                     
                               ->when(!empty($subAccount), function ($query) use ($subAccount) {
                                            return $query->where('Account', $subAccount);
                                        }) 
                                                
                                    ->whereIn('Type',['سند قبض','دفع شيك وارد','القيود اليومية','تحويلات الخزائن'])                
                    
                                                ->get();
                                                
                                $TotD=GeneralDaily::whereBetween('Date',[$from,$to]) 
                                
                                     
                               ->when(!empty($subAccount), function ($query) use ($subAccount) {
                                            return $query->where('Account', $subAccount);
                                        }) 
                                                
                       ->whereIn('Type',['سند قبض','دفع شيك وارد','القيود اليومية','تحويلات الخزائن'])
                                                ->get()->sum('Debitor_Coin');
                                                
                                              $TotC=GeneralDaily::whereBetween('Date',[$from,$to]) 
                                
                                     
                               ->when(!empty($subAccount), function ($query) use ($subAccount) {
                                            return $query->where('Account', $subAccount);
                                        }) 
                                                
                       ->whereIn('Type',['سند قبض','دفع شيك وارد','القيود اليومية','تحويلات الخزائن'])
                                                ->get()->sum('Creditor_Coin');             
                                                
                                                
                                               
                                                ?>
                                                <tr>
                                                           <td> <?php echo e(app()->getLocale() == 'ar' ?$item->Name :$item->NameEn); ?></td>
                                                    <td><?php echo e($TotD - $TotC); ?></td>
                                   
                                                </tr>
                                                  <tr class="X no-print">  
                              <td colspan="23"> 
                              
                                       <table class="" style="background: grey">
                                                        
                                                            <tr>
                                                   
                                                                <th><?php echo e(trans('admin.Code')); ?></th>
                                                                <th><?php echo e(trans('admin.Date')); ?></th>
                                                                <th><?php echo e(trans('admin.Type')); ?></th>
                                                                <th><?php echo e(trans('admin.Code_Type')); ?></th>
                                                                <th><?php echo e(trans('admin.Debitor')); ?></th>
                                                                <th><?php echo e(trans('admin.Creditor')); ?></th>
                                                                <th><?php echo e(trans('admin.Statement')); ?></th>
                                                                <th><?php echo e(trans('admin.Draw')); ?></th>
                                                                <th><?php echo e(trans('admin.Debitor_Coin')); ?></th>
                                                                <th><?php echo e(trans('admin.Creditor_Coin')); ?></th>
                                                                <th><?php echo e(trans('admin.Account')); ?></th>
                                                                <th><?php echo e(trans('admin.Coin')); ?></th>
                                                
                                                            </tr>
                                                       
                                                        <tbody>
                                                            <?php $__currentLoopData = $lists; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $detail): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                                                       <tr>
                                                    <td><?php echo e($detail->Code); ?></td>
                                                   <td><?php echo e($detail->Date); ?></td>
                                                   <td><?php echo e(app()->getLocale() == 'ar' ?$detail->Type :$detail->TypeEn); ?></td>
                                                  <td><?php echo e($detail->Code_Type); ?></td>
                                                  <td><?php echo e($detail->Debitor); ?></td>
                                                  <td><?php echo e($detail->Creditor); ?></td>
                                                  <td><?php echo e($detail->Statement); ?></td>
                                                  <td><?php echo e($detail->Draw); ?></td>
                                                  <td><?php echo e($detail->Debitor_Coin); ?></td>
                                                  <td><?php echo e($detail->Creditor_Coin); ?></td>
        <td><?php echo e(app()->getLocale() == 'ar' ?$detail->Account()->first()->Name :$detail->Account()->first()->NameEn); ?></td>
        <td><?php echo e(app()->getLocale() == 'ar' ?$detail->Coin()->first()->Arabic_Name :$detail->Coin()->first()->English_Name); ?></td>
                  </tr>
                                                            <?php  $total += $detail->Debitor ;  ?>
                                                            <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                                        </tbody>
                                                    </table>
                                            
                                   </td>
                           </tr> 
                                                <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                                            </tbody>
                                        </table>
                                        </div>
                 <?php echo e($items->Links()); ?>

                  <!-- datatable end -->
                   
                               <div class="over-flow">
                                        <table class="table table-bordered table-hover table-striped ">
                                            <tbody>
                                                <tr>
                                                    <td><?php echo e(trans('admin.Total_Debiator')); ?></td>
                                                    <td><?php echo e($total); ?></td>
                                            
                                                </tr>
                                              
                                            </tbody>
                                        </table>
                                        </div>
                                  
                                                </div>
                                            </div>
                                        </div>
                                        
                         
                                    </div>
                                </div>
                                
                                  <?php if($show->Text == 1): ?>  
                                                   <div class="row">
                                       
                                             <?php if(!empty($Def->Print_Text_Footer)): ?>
            
                  <?php echo app()->getLocale() == 'ar' ?$Def->Print_Text_Footer :$Def->Print_Text_Footer_En; ?>

                      <?php endif; ?>          
                                        </div>  
                                <?php endif; ?>
                                
           
                                 
                     
                                <div class="modal-footer">
                <a href="<?php echo e(url('KlarAdmin')); ?>" class="btn btn-secondary" data-dismiss="modal"><?php echo e(trans('admin.Back')); ?></a>
             <button type="button" class="btn btn-default" onclick="window.print()"><i class="fal fa-print"></i></button>  
                                </div>
                                
                            </div>
                        </div>
         </div>
</main>

       


<?php $__env->stopSection(); ?>
<?php $__env->startPush('js'); ?>
    <link rel="stylesheet" media="screen, print" href="<?php echo e(asset('Admin/css/datagrid/datatables/datatables.bundle.css')); ?>">
    <link rel="stylesheet" media="screen, print" href="<?php echo e(asset('Admin/css/formplugins/summernote/summernote.css')); ?>">
    <link rel="stylesheet" media="screen, print" href="<?php echo e(asset('Admin/css/formplugins/select2/select2.bundle.css')); ?>">


    <style>
        th{
            width:135px!important;
        }
    </style>

 <script src="<?php echo e(asset('Admin/js/datagrid/datatables/datatables.export.js')); ?>"></script>
    <script src="<?php echo e(asset('Admin/js/datagrid/datatables/datatables.bundle.js')); ?>"></script>
    <script src="<?php echo e(asset('Admin/js/formplugins/summernote/summernote.js')); ?>"></script>
    <script src="<?php echo e(asset('Admin/js/formplugins/select2/select2.bundle.js')); ?>"></script>
    <script>
        //_fnFeatureHtmlLength();
        $(document).ready(function () {
            // Setup - add a text input to each footer cell
            $('#dt-basic-example thead tr').clone(true).appendTo('#dt-basic-example thead');
            $('#dt-basic-example thead tr:eq(1) th').each(function (i) {
                var title = $(this).text();
                $(this).html('<input type="text" class="form-control form-control-sm" placeholder="Search ' + title + '" />');

                $('input', this).on('keyup change', function () {
                    if (table.column(i).search() !== this.value) {
                        table
                            .column(i)
                            .search(this.value)
                            .draw();
                    }
                });
            });
            var table = $('#dt-basic-example').DataTable(
                {
                    responsive: true,
                    orderCellsTop: true,
                    fixedHeader: true,
                    lengthChange: true,

                    dom: "<'row mb-3'<'col-sm-12 col-md-3 d-flex align-items-center justify-content-start'f><'col-sm-12 col-md-9 d-flex align-items-center justify-content-end'B>>" +
                        "<'row'<'col-sm-12'tr>>" +
                        "<'row'<'col-sm-12 col-md-5'i><'col-sm-12 col-md-7'p>>",

                    buttons: [
                        {
                            extend: 'pageLength',
                            className: 'btn-outline-default'
                        },
                        {
                            extend: 'colvis',
                            text: 'Column Visibility',
                            titleAttr: 'Col visibility',
                            className: 'btn-outline-default'
                        },
                        {
                            extend: 'pdfHtml5',
                            text: 'PDF',
                            titleAttr: 'Generate PDF',
                            className: 'btn-outline-danger btn-sm mr-1'
                        },
                        {
                            extend: 'excelHtml5',
                            text: 'Excel',
                            titleAttr: 'Generate Excel',
                            className: 'btn-outline-success btn-sm mr-1'
                        },
                        {
                            extend: 'csvHtml5',
                            text: 'CSV',
                            titleAttr: 'Generate CSV',
                            className: 'btn-outline-primary btn-sm mr-1'
                        },
                        {
                            extend: 'copyHtml5',
                            text: 'Copy',
                            titleAttr: 'Copy to clipboard',
                            className: 'btn-outline-primary btn-sm mr-1'
                        },
                        {
                            extend: 'print',
                            text: 'Print',
                            titleAttr: 'Print Table',
                            className: 'btn-outline-primary btn-sm'
                        }
                    ],
                });
            $('.js-thead-colors a').on('click', function () {
                var theadColor = $(this).attr("data-bg");
                console.log(theadColor);
                $('#dt-basic-example thead').removeClassPrefix('bg-').addClass(theadColor);
            });

            $('.js-tbody-colors a').on('click', function () {
                var theadColor = $(this).attr("data-bg");
                console.log(theadColor);
                $('#dt-basic-example').removeClassPrefix('bg-').addClass(theadColor);
            });

        });

    </script>
  
  <script>
    $(document).ready(function()
    {
        $(function()
        {
            $('.select2').select2();

            $(".select2-placeholder-multiple").select2(
            {
                placeholder: "Select State"
            });
            $(".js-hide-search").select2(
            {
                minimumResultsForSearch: 1 / 0
            });
            $(".js-max-length").select2(
            {
                maximumSelectionLength: 2,
                placeholder: "Select maximum 2 items"
            });
            $(".select2-placeholder").select2(
            {
                placeholder: "Select a state",
                allowClear: true
            });

            $(".js-select2-icons").select2(
            {
                minimumResultsForSearch: 1 / 0,
                templateResult: icon,
                templateSelection: icon,
                escapeMarkup: function(elm)
                {
                    return elm
                }
            });

            function icon(elm)
            {
                elm.element;
                return elm.id ? "<i class='" + $(elm.element).data("icon") + " mr-2'></i>" + elm.text : elm.text
            }

            $(".js-data-example-ajax").select2(
            {
                ajax:
                {
                    url: "https://api.github.com/search/repositories",
                    dataType: 'json',
                    delay: 250,
                    data: function(params)
                    {
                        return {
                            q: params.term, // search term
                            page: params.page
                        };
                    },
                    processResults: function(data, params)
                    {
                        // parse the results into the format expected by Select2
                        // since we are using custom formatting functions we do not need to
                        // alter the remote JSON data, except to indicate that infinite
                        // scrolling can be used
                        params.page = params.page || 1;

                        return {
                            results: data.items,
                            pagination:
                            {
                                more: (params.page * 30) < data.total_count
                            }
                        };
                    },
                    cache: true
                },
                placeholder: 'Search for a repository',
                escapeMarkup: function(markup)
                {
                    return markup;
                }, // let our custom formatter work
                minimumInputLength: 1,
                templateResult: formatRepo,
                templateSelection: formatRepoSelection
            });

            function formatRepo(repo)
            {
                if (repo.loading)
                {
                    return repo.text;
                }

                var markup = "<div class='select2-result-repository clearfix d-flex'>" +
                    "<div class='select2-result-repository__avatar mr-2'><img src='" + repo.owner.avatar_url + "' class='width-2 height-2 mt-1 rounded' /></div>" +
                    "<div class='select2-result-repository__meta'>" +
                    "<div class='select2-result-repository__title fs-lg fw-500'>" + repo.full_name + "</div>";

                if (repo.description)
                {
                    markup += "<div class='select2-result-repository__description fs-xs opacity-80 mb-1'>" + repo.description + "</div>";
                }

                markup += "<div class='select2-result-repository__statistics d-flex fs-sm'>" +
                    "<div class='select2-result-repository__forks mr-2'><i class='fal fa-lightbulb'></i> " + repo.forks_count + " Forks</div>" +
                    "<div class='select2-result-repository__stargazers mr-2'><i class='fal fa-star'></i> " + repo.stargazers_count + " Stars</div>" +
                    "<div class='select2-result-repository__watchers mr-2'><i class='fal fa-eye'></i> " + repo.watchers_count + " Watchers</div>" +
                    "</div>" +
                    "</div></div>";

                return markup;
            }

            function formatRepoSelection(repo)
            {
                return repo.full_name || repo.text;
            }
        });
    });

</script>
<script>
    var autoSave = $('#autoSave');
    var interval;
    var timer = function()
    {
        interval = setInterval(function()
        {
            //start slide...
            if (autoSave.prop('checked'))
                saveToLocal();

            clearInterval(interval);
        }, 3000);
    };

    //save
    var saveToLocal = function()
    {
        localStorage.setItem('summernoteData', $('#saveToLocal').summernote("code"));
        console.log("saved");
    }

    //delete 
    var removeFromLocal = function()
    {
        localStorage.removeItem("summernoteData");
        $('#saveToLocal').summernote('reset');
    }

    $(document).ready(function()
    {
        //init default
        $('.js-summernote').summernote(
        {
            height: 200,
            tabsize: 2,
            placeholder: "Type here...",
            dialogsFade: true,
            toolbar: [
                ['style', ['style']],
                ['font', ['strikethrough', 'superscript', 'subscript']],
                ['font', ['bold', 'italic', 'underline', 'clear']],
                ['fontsize', ['fontsize']],
                ['fontname', ['fontname']],
                ['color', ['color']],
                ['para', ['ul', 'ol', 'paragraph']],
                ['height', ['height']]
                ['table', ['table']],
                ['insert', ['link', 'picture', 'video']],
                ['view', ['fullscreen', 'codeview', 'help']]
            ],
            callbacks:
            {
                //restore from localStorage
                onInit: function(e)
                {
                    $('.js-summernote').summernote("code", localStorage.getItem("summernoteData"));
                },
                onChange: function(contents, $editable)
                {
                    clearInterval(interval);
                    timer();
                }
            }
        });

        //load emojis
        $.ajax(
        {
            url: 'https://api.github.com/emojis',
            async: false
        }).then(function(data)
        {
            window.emojis = Object.keys(data);
            window.emojiUrls = data;
        });

        //init emoji example
        $(".js-hint2emoji").summernote(
        {
            height: 100,
            toolbar: false,
            placeholder: 'type starting with : and any alphabet',
            hint:
            {
                match: /:([\-+\w]+)$/,
                search: function(keyword, callback)
                {
                    callback($.grep(emojis, function(item)
                    {
                        return item.indexOf(keyword) === 0;
                    }));
                },
                template: function(item)
                {
                    var content = emojiUrls[item];
                    return '<img src="' + content + '" width="20" /> :' + item + ':';
                },
                content: function(item)
                {
                    var url = emojiUrls[item];
                    if (url)
                    {
                        return $('<img />').attr('src', url).css('width', 20)[0];
                    }
                    return '';
                }
            }
        });

        //init mentions example
        $(".js-hint2mention").summernote(
        {
            height: 100,
            toolbar: false,
            placeholder: "type starting with @",
            hint:
            {
                mentions: ['jayden', 'sam', 'alvin', 'david'],
                match: /\B@(\w*)$/,
                search: function(keyword, callback)
                {
                    callback($.grep(this.mentions, function(item)
                    {
                        return item.indexOf(keyword) == 0;
                    }));
                },
                content: function(item)
                {
                    return '@' + item;
                }
            }
        });

    });

</script>
<script type="text/javascript">


    $(".show-table").click(function(){
        $(".hide-table").show();
    });
    
</script>

	<style>
	@media  print {
		body * {
			visibility: hidden;
		}
		.modal-body * {
			visibility: visible;
			overflow: visible;
		}
		
        

	}
	</style>

<script>
function ChangeClass(){
    
   var $a1Check  = $('#CHANGE').is(':checked');

   
    if($a1Check){

  $(".X").removeClass("no-print");
 
        
    }
    else{
     
 $(".X").addClass("no-print");
     
        
        
    }    
    
    
    

    
}
</script>

<?php $__env->stopPush(); ?>
<?php echo $__env->make('admin.index', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?><?php /**PATH /Applications/MAMP/htdocs/laravel/ERP/resources/views/admin/Reports/IncomListReportPrint.blade.php ENDPATH**/ ?>