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 :  /proc/thread-self/root/home/vapecompany/demo.vapecompany.com.bd/resources/views/backend/exports/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<table style="table-layout: auto;widtd: 100%;">
	<thead>
		@if($companyInfo)
	    	<tr><td colspan="17" style="text-align: center;"> {{$companyInfo->company_name ? $companyInfo->company_name: "MAKTEL LIMITED"}}</td></tr>
	    	<tr><td colspan="17" 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="17" style="text-align: center;"> Hotline: +{{$companyInfo->company_phone ? $companyInfo->company_phone: "88 01844241530"}}</td></tr>
	    	<tr><td colspan="17" style="text-align: center;"> Email: {{$companyInfo->company_email ? $companyInfo->company_email : "info@maktel.com.bd"}}</td></tr>
	    	<tr><td colspan="17" style="text-align: center;"> Web: {{$companyInfo->company_website ? $companyInfo->company_website : "www.maktel.com.bd"}}</td></tr>
	        <tr><td colspan="17" style="text-align: center;">Facebook: {{$companyInfo->company_facebook ? $companyInfo->company_facebook : "www.facebook.com/maktel"}}</td></tr>

	      
    	@else
    		<tr><td colspan="17">MAKTEL LIMITED</td></tr>
    	 	<tr><td colspan="17">House-277(Level-4),Lane-4,Baridhara DOHS,Dhaka-1206.</td></tr>
    	 	<tr><td colspan="17">Hotline:+88 01844241530</td></tr>
    	 	<tr><td colspan="17">Email:info@maktel.com.bd</td></tr>
    	 	<tr><td colspan="17">Web:www.maktel.com.bd</td></tr>
    	 	<tr><td colspan="17">Facebook:www.facebook.com/maktel</td></tr>
        
       @endif
		<tr>
			 <th>SL</th>
                <th class="not-mobile">Month</th>
                  <th >Employee Name</th>
                <th class="not-mobile">Designation</th>
                <th class="not-mobile">Region</th>
                <th class="not-mobile">Division</th>
                <th class="not-mobile">District</th>
                 <th class="not-mobile">Target Product</th>
                <th class="not-mobile">Target Quantity</th>
                <th class="not-mobile">Total Target Quantity</th>
                <th class="not-mobile">Target Value</th>
                <th class="not-mobile">Total Target Value</th>
                <th class="not-mobile">Sales Quantity</th>
                <th class="not-mobile">Total Sales Quantity</th>
                <th class="not-mobile">Sales Value</th>
                <th class="not-mobile">Total Sales Value</th>
                <th class="not-mobile">Progress</th>
		</tr>
	</thead>
	   <tbody>
          @foreach($sales_target as $sales)
            @php

           
               
                $m=str_split($sales->month,4);

                $d=date('M',strtotime($m[0].'-'.$m[1].'-01')); 
                       
                    
             @endphp
             @foreach($sales->details as $k=>$detail)
            @php
             if($detail->target_quantity > $detail->sales_quantity){
                    $percentage=($detail->sales_quantity/$detail->target_quantity)*100;
                }else{
                    $percentage=100;
                }
            @endphp
              @if($k == 0)
                <tr >
                @else
                <tr>
                @endif
                @if($k == 0)
                 <td rowspan="{{$sales->details->count()}}">{{$sales->sale_target_id}}</td>
                                            <td rowspan="{{$sales->details->count()}}">{{$d.','.$m[0]}}</td>
                                            <td rowspan="{{$sales->details->count()}}">{{$sales->employee->employee_name}}</td>
                                            <td rowspan="{{$sales->details->count()}}">{{$sales->designation ? $sales->designation->designation_name : ''}}</td>
                                             <td rowspan="{{$sales->details->count()}}">{{$sales->region->region_name}}</td>
                                            <td rowspan="{{$sales->details->count()}}">@php
                                                $c=json_decode($sales->division_id);
                                                $division="";
                                                $i=0;
                                               foreach($c as $key => $value){
                                                    if($i == 0){

                                                        $division .= \App\Models\Division::where('division_id',$value)->first()->division_name;
                                                    }else{
                                                        $division .= ','; 
                                                        $division .=\App\Models\Division::where('division_id',$value)->first()->division_name;
                                                    }
                                                    $i++;
                                                }
                                                
                                                @endphp
                                                {{$division}}</td>
                                            <td rowspan="{{$sales->details->count()}}">@php
                                                $c=json_decode($sales->district);
                                                $district="";
                                                $i=0;
                                               foreach ($c as $key => $value) {
                                                    if($i == 0){

                                                        $district .= \App\Models\District::where('district_id',$value)->first()->district_name;
                                                    }else{
                                                        $district .= ','; 
                                                        $district .=\App\Models\District::where('district_id',$value)->first()->district_name;
                                                    }
                                                    $i++;
                                                }
                                                
                                                @endphp
                                                {{$district}}
                                            </td>
                @endif
                <td >{{$detail->product->product_name}}</td>
                <td>{{$detail->target_quantity}}</td>
                @if($k == 0)
                <td rowspan="{{$sales->details->count()}}">{{$sales->details->sum('target_quantity')}}</td>
                @endif
                <td>{{$detail->target_amount}}</td>
                @if($k == 0)
                <td rowspan="{{$sales->details->count()}}">{{$sales->details->sum('target_amount')}}</td>
                @endif
                 <td>{{$detail->sales_quantity}}</td>
                 @if($k == 0)
                <td rowspan="{{$sales->details->count()}}">{{$sales->details->sum('sales_quantity')}}</td>
                @endif
                 <td>{{$detail->sales_amount}}</td>
                @if($k == 0)
                <td rowspan="{{$sales->details->count()}}">{{$sales->details->sum('sales_amount')}}</td>
                @endif 
                <td>
                    
                    <div class="bar-one bar-con">
                        <div class="bar" data-percent="{{$percentage}}">{{$percentage}}%</div>
                    </div>      
                </td>
               
            </tr>
            @endforeach
            @endforeach
        </tbody>
</table>