Server : Apache System : Linux host44.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64 User : vapecompany ( 2719) PHP Version : 7.4.33 Disable Function : NONE Directory :  /home/vapecompany/demo.vapecompany.com.bd/resources/views/backend/exports/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<table style="table-layout: auto;width: 100%;">
	<thead>
		@if($companyInfo)
	    	<tr><td colspan="14" style="text-align: center;"> {{$companyInfo->company_name ? $companyInfo->company_name: "MAKTEL LIMITED"}}</td></tr>
	    	<tr><td colspan="14" style="text-align: center;"> {{$companyInfo->company_address ? $companyInfo->company_address : "House-277(Level-4),Lane-4,Baridhara DOHS,Dhaka-1206."}}</td></tr>
	    	<tr><td colspan="14" style="text-align: center;"> Hotline: +{{$companyInfo->company_phone ? $companyInfo->company_phone: "88 01844241530"}}</td></tr>
	    	<tr><td colspan="14" style="text-align: center;"> Email: {{$companyInfo->company_email ? $companyInfo->company_email : "info@maktel.com.bd"}}</td></tr>
	    	<tr><td colspan="14" style="text-align: center;"> Web: {{$companyInfo->company_website ? $companyInfo->company_website : "www.maktel.com.bd"}}</td></tr>
	        <tr><td colspan="14" style="text-align: center;">Facebook: {{$companyInfo->company_facebook ? $companyInfo->company_facebook : "www.facebook.com/maktel"}}</td></tr>

	      
    	@else
    		<tr><td colspan="14">MAKTEL LIMITED</td></tr>
    	 	<tr><td colspan="14">House-277(Level-4),Lane-4,Baridhara DOHS,Dhaka-1206.</td></tr>
    	 	<tr><td colspan="14">Hotline:+88 01844241530</td></tr>
    	 	<tr><td colspan="14">Email:info@maktel.com.bd</td></tr>
    	 	<tr><td colspan="14">Web:www.maktel.com.bd</td></tr>
    	 	<tr><td colspan="14">Facebook:www.facebook.com/maktel</td></tr>
        
       @endif
       </thead>
    <tbody>
    @foreach($sells as $key=> $chalans)
        <tr class="bg-secondary text-white">
            <td colspan="14" style="text-align: center;font-weight: bold;background:#6c757d;color: white;">
               @if($by_duration == 'Y-m-d' or $by_duration == '')
                    {{\Carbon\Carbon::parse($key)->format('d F,Y')}}
                @else
                    {{$key}}
                @endif
            </td>
        </tr>
		<tr >
			<td style="font-weight: bold;background:#6c757d;color: white;">SL</td>
            <td style="font-weight: bold;background:#6c757d;color: white;">Invoice Id</td>
            <td style="font-weight: bold;background:#6c757d;color: white;">Sales Date</td>
             <td style="font-weight: bold;background:#6c757d;color: white;">Customer Type</td>
            <td style="font-weight: bold;background:#6c757d;color: white;">Customer</td>
            <td style="font-weight: bold;background:#6c757d;color: white;">Region</td>
            <td style="font-weight: bold;background:#6c757d;color: white;">Division</td>
               <td style="font-weight: bold;background:#6c757d;color: white;">District</td>
            <td style="font-weight: bold;background:#6c757d;color: white;">Designation</td>
            
            <td style="font-weight: bold;background:#6c757d;color: white;">Employee</td>
         
            <td style="font-weight: bold;background:#6c757d;color: white;">Quantity</td>
            <td style="font-weight: bold;background:#6c757d;color: white;">Amount</td>
            <td style="font-weight: bold;background:#6c757d;color: white;">Paid Amount</td>

            <td style="font-weight: bold;background:#6c757d;color: white;">Incentive Amount</td>

		</tr>
	
	
          @php $i=1; $totalQ=0;$totalP=0; @endphp
        @foreach($chalans as $chalan)
               <tr>
                        <td>{{$i}}</td>
                        <td>
                            {{$chalan->invoice_number}}
                        </td>
                       
                            <td>{{$chalan->chalan_date->format('Y-m-d')}}</td>
                 

                        <td>{{$chalan->customer->type->customer_type_name}}</td>
                        <td> {{$chalan->customer->customer_name}}</td>
                        <td> {{$chalan->customer->region ? $chalan->customer->region->region_name : ''}}</td>
                        <td> {{$chalan->customer->division->division_name}}</td>
                         <td> {{$chalan->customer->district->district_name}}</td>
                        <td>{{$chalan->salesman->designation->designation_name}}</td>
                        <td>{{$chalan->salesman->employee_name}}</td>
                        
                       
                        <td> {{$chalan->total_quantity}}</td>
                        <td> {{$chalan->total_amount}}</td>
                        <td> {{$chalan->paid_amount}}</td>
                        <td> {{$chalan->incentive_amount}}</td>
                    </tr>

                  @php $i++; @endphp
        @endforeach
           
             <tr>
                        <td colspan="10" style="text-align: right;font-weight: bold;">Total</td>
                        
                        <td style="font-weight: bold;">  {{$chalans->sum('total_quantity')}}</td>
                        <td style="font-weight: bold;"> {{$chalans->sum('total_amount')}}</td>
                        <td style="font-weight: bold;">  {{$chalans->sum('paid_amount')}}</td>
                        <td style="font-weight: bold;"> {{$chalans->sum('incentive_amount')}}</td>
                    </tr>
                


                
               
        @endforeach
        </tbody>
</table>