<?php 

$lang			= 'en';
$content        = $lang.'_content';
$dateformat 	= 'd M Y';

 /**********************************************************

FUNCTION README :  /ci/application/controllers/remote/get_content.php
 get_content/new/{LANG}/{YEAR}/{TYPE}/{LIMIT}
**********************************************************/
$link           = $topVar['site_path']."/ci/index.php/remote/get_content/bulk_fleet";
$cms_json_data  = file_get_contents($link);	
$data           = json_decode($cms_json_data,true);


$link            = $topVar['site_path']."/ci/index.php/remote/get_content/fleet_summary/{$lang}/bulk";
$cms_json_data   = file_get_contents($link);	
$summary_arr     = json_decode($cms_json_data,true);
$summary_content = $summary_arr[0][$content];


$fleet = new fleet;
$theader_map = array(
    'fleet_name'    => array('name' => 'Name'       ,'attr'=>'width="150"'),
    'dwt'           => array('name' => 'DWT(mt)'    ,'attr'=>'width="60"'),
    'draft'         => array('name' => 'Draft(m)'   ,'attr'=>'width="60"'),
    'yr_blt'        => array('name' => 'Year Built' ,'attr'=>'width="60"'),
    'yard'          => array('name' => 'Yard'       ,'attr'=>'width="100"'),
    'grainLBale'    => array('name' => 'Grain / Bale','attr'=>'width="100"'),
    'cranes'        => array('name' => 'Cranes'     ,'attr'=>'width="60"'),
    'features'      => array('name' => 'Features'   ,'attr'=>'width="200"')
    );
    
$format_t_map =  array('Owned' => 'Owned', 'Chartered' => 'Chartered  ≧ 1 year' );

$table_title_map = array('Handysize'                => 'Handysize',
                         'Handysize New Buildings'  => 'Handysize Newbuildings',
                         'Supramax'                 => 'Supramax',
                         'Supramax New Buildings'   => 'Supramax Newbuildings',
                         'Post-panamax'             => 'Post Panamax'   
                );
 
  

?>
	<script src="https://cdn.sheetjs.com/xlsx-latest/package/dist/xlsx.full.min.js"></script>
<script>
function exportTableWithImage() {
    // 1. Get the HTML table object
    const table = document.getElementById("myTable");

    // 2. Generate the SheetJS WorkBook object from the table
    // Important options:
    // display: true => Tries to include images/links
    const wb = XLSX.utils.table_to_book(table, { 
        display: true, // Crucial for including some objects
        sheet: "InventoryData" // Name the sheet
    });

    // 3. (Optional) Force the image data. 
    // In many modern versions of SheetJS, step 2 is sufficient for embedded Base64,
    // but if it fails, you must manually iterate through the sheet object (wb.Sheets)
    // and manually inject the drawing objects.

    // 4. Save and Download the .xlsx File
    XLSX.writeFile(wb, "InventoryReport.xlsx");
}
</script>
			<div class="row fleetTable">

				<div class="col-sm-10 col-sm-offset-1 col-lg-10 col-lg-offset-1" style="margin-top: 60px;">
					<div class="full-width-tabs">
						<ul class="nav nav-tabs nav-justified" role="tablist">
							<li class="active"><a href="#handysize" aria-controls="home" role="tab" data-toggle="tab">Handysize</a></li>
							<li><a href="#supramax" aria-controls="home" role="tab" data-toggle="tab">Supramax</a></li>
						</ul>
						<div class="tab-arrow visible-xs"><i class="zmdi zmdi-caret-down-circle zmdi-hc-fw"></i></div>
						<div class="tab-content">
							
							<div role="tabpanel" class="tab-pane active" id="handysize">
								<div class="table-responsive">
								<?
								$tab_content    = $fleet->get_tab($data[0]);
								$table          = $tab_content['table'];
								$remark_table   = $tab_content['remark_table'];
								$total_row      = $tab_content['total_row'];
								?>
								
								<!--<p><?= $remark_table['last_updated'];?><BR></p>
								<p class="clearfix">
                                	<a class="btn btn-primary btn-lg pull-right" href="../fleet/fleetmanagement.php" role="button" style="margin-bottom: 0; margin-left:10px;">Fleet Management, Safety & Quality</a>
                                    <a class="btn btn-primary btn-lg pull-right" href="../fleet/fleet_download.php" role="button" style="margin-bottom: 0; margin-left:10px;">Fleet Download</a>
                                	
                                </p>-->
                                <div class="fleetDL">
                                	<div><?= $remark_table['last_updated'];?></div>
                                	<div class=""><a class="btn btn-primary btn-lg" href="../fleet/fleet_download.php" role="button">Fleet Download <i class="zmdi zmdi-hc-fw"></i></a></div>
                                </div>
                                
								
								<h3> Handysize Core Fleet <!--- <?=$total_row?>--></h3>
								   Comprising owned vessels and ships chartered in for 1 year or longer
								   	<hr class='dash'>
									<h4 style="color:#1c2c50">FILTER BY: </h4>
									<div class="checkbox-panel">
										<input type="checkbox" class='hs_filter' id="hs_semi_box" value="hs_semi_box" checked="checked" autocomplete="off" style="background:#00b8f1;border:1px solid #00b8f1"/> 
										<img style='margin:0' src='../images/fleet/icon/semi_box.png' />
										<span class="label">Semi Box </span>
										<input type="checkbox" class='hs_filter' id="hs_open_hatch" value="hs_open_hatch" checked="checked" autocomplete="off"/> 
										<img style='margin:0' src='../images/fleet/icon/open_hatch.png' /> 
										<span class="label">Open Hatch</span>
										<input type="checkbox" class='hs_filter' id="hs_logs_fitted" value="hs_logs_fitted" checked="checked" autocomplete="off"/> 
										<img style='margin:0' src='../images/fleet/icon/logs_fitted.png' /> 
										<span class="label">Logs Fitted</span>
										<input type="checkbox" class='hs_filter' id="hs_a60" value="hs_a60" checked="checked" autocomplete="off"/> 
										<img style='margin:0' src='../images/fleet/icon/a60.png' /> 
										<span class="label">A60	</span>
										<input type="checkbox" class='hs_filter' id="hs_co2" value="hs_co2" checked="checked" autocomplete="off"/> 
										<img style='margin:0' src='../images/fleet/icon/co2.png' />
										<span class="label"> CO2	</span>
										<input type="checkbox" class='hs_filter' id="hs_mech_vent" value="hs_mech_vent" checked="checked" autocomplete="off"/> 
										<img style='margin:0' src='../images/fleet/icon/mech_vent.png' /> <span class="label">Mech Vent	</span>
									</div>
									
									<div class="statistic-container">
										<div class="statistic"><span class="title">TOTAL</span> <span class="num hs_count_total">0</span></div>
										<div class="statistic"><span class="title">OWNED</span> <span class="num hs_count_owner">0</span></div>
										<div class="statistic" style="border:none;"><span class="title">CHARTERED</span> <span class="num hs_count_chartered">0</span></div>
										<div style="clear: both"></div>
									</div>
									
									
								  <?=$table?>
								  <p>&nbsp;</p>
	 
							
							
								   <div class="fleetSum_notes remark">
									<table>
									  <tbody>
										<tr>
										  <td>Notes:</td>
										  <td>&nbsp;</td>
										</tr>
									   <?= $remark_table['td'];?>
									  </tbody>
									</table>
								  </div>
								</div>
							</div>
							<div role="tabpanel" class="tab-pane" id="supramax">
							
							
							
							
								<?
							
								$tab_content    = $fleet->get_tab($data[1]);
								$table          = $tab_content['table'];
								$remark_table   = $tab_content['remark_table'];
								$total_row      = $tab_content['total_row'];
								?>
			

<br>
<button onclick="exportTableWithImage()">Export</button>



								<!--<p><?= $remark_table['last_updated'];?><BR></p>
								<p class="clearfix"><a class="btn btn-primary btn-lg pull-right" href="#" role="button" style="margin-bottom: 0;">Fleet Download</a></p>-->
								<div class="fleetDL">
									<div><?= $remark_table['last_updated'];?></div>
									<div><a class="btn btn-primary btn-lg" href="../fleet/fleet_download.php" role="button">Fleet Download <i class="zmdi zmdi-hc-fw"></i></a></div>
								</div>
								<h3> Supramax Core Fleet <!--- <?=$total_row?>--></h3>
								Comprising owned vessels and ships chartered in for 1 year or longer
								<hr class='dash'>
								<h4 style="color:#1c2c50">FILTER BY: </h4>
								<div class="checkbox-panel">
									<input type="checkbox" class='sm_filter' id="sm_semi_box" value="sm_semi_box" checked="checked" autocomplete="off" style="background:#00b8f1;border:1px solid #00b8f1"/> 
									<img style='margin:0' src='../images/fleet/icon/semi_box.png' />
									<span class="label">Semi Box</span>
									<input type="checkbox" class='sm_filter' id="sm_open_hatch" value="sm_open_hatch" checked="checked" autocomplete="off"/> 
									<img style='margin:0' src='../images/fleet/icon/open_hatch.png' />
									<span class="label">Open Hatch</span>
									<input type="checkbox" class='sm_filter' id="sm_logs_fitted" value="sm_logs_fitted" checked="checked" autocomplete="off"/> 
									<img style='margin:0' src='../images/fleet/icon/logs_fitted.png' />
									<span class="label">Logs Fitted</span>
									<input type="checkbox" class='sm_filter' id="sm_a60" value="sm_a60" checked="checked" autocomplete="off"/> 
									<img style='margin:0' src='../images/fleet/icon/a60.png' />
									<span class="label">A60</span>
									<input type="checkbox" class='sm_filter' id="sm_co2" value="sm_co2" checked="checked" autocomplete="off"/> 
									<img style='margin:0' src='../images/fleet/icon/co2.png' />
									<span class="label">CO2</span>
									<input type="checkbox" class='sm_filter' id="sm_mech_vent" value="sm_mech_vent" checked="checked" autocomplete="off"/> 
									<img style='margin:0' src='../images/fleet/icon/mech_vent.png' /> 
									<span class="label">Mech Vent</span>
                                    <input type="checkbox" class='sm_filter' id="sm_grab_fitted" value="sm_grab_fitted" checked="checked" autocomplete="off"/> 
									<img style='margin:0' src='../images/fleet/icon/grab_fitted.png' /> 
									<span class="label">Grab Fitted</span>
								</div>
									
								<div class="statistic-container">
									<div class="statistic"><span class="title">TOTAL</span> <span class="num sm_count_total">0</span> </div>
									<div class="statistic"><span class="title">OWNED</span> <span class="num sm_count_owner">0</span></div>
									<div class="statistic" style="border: none;"><span class="title">CHARTERED</span> <span class="num sm_count_chartered">0</span></div>
									<div style="clear: both"></div>
								</div>
									
								<?=$table?>
				
								<p>&nbsp;</p>  
			
								<?
								$tab_content    = $fleet->get_tab($data[2]);
								$table          = $tab_content['table'];
								$remark_table   = $tab_content['remark_table'];
								$total_row      = $tab_content['total_row'];
								?>
								<h3> Capesize Core Fleet <!--- <?=$total_row?>--></h3>
								<?=$table?>

			
								<p>&nbsp;</p>
						
								<div class="fleetSum_notes remark">
									<table>
									  <tbody>
										<tr>
										  <td>Notes:</td>
										  <td>&nbsp;</td>
										</tr>
									   <?= $remark_table['td'];?>
									  </tbody>
									</table>
								</div>

							</div>
						</div>
					</div>	
				
	

				</div>
			</div>








<?php 

/*  CLASS fleet (handy / supramax table generator) */


class fleet {

function get_tab($data_array){
    $table          = '';
    $remark_table   = array('td'=>'','last_updated'=>'');
    $total_row      = 0;
    $last_updated   = '';
	//echo "<!--";
	//print_r($data_array);
	//echo "-->";
    FOREACH($data_array AS $k => $v){
        if($k>=0){
            $split_table = $this->split_owned($v);
            $table_name = $v[0]['fleet_type'];

            $table.='<div class="fleetTable">';
			
			if(sizeof($split_table['o'])!=0){
            $table.='<p class="table_title">'.PHP_EOL
                .$this->get_table_title($table_name,'Owned').'</p>'.PHP_EOL
				.'<div class="owned_table">'
                .$this->gen_table($split_table['o'],$table_name)
				.'</div>';
			}
			if(sizeof($split_table['star'])!=0){
            $table.='<p class="table_title">'.$this->get_table_title($table_name,'Chartered')
                .'</p>'.PHP_EOL
				.'<div class="chartered_table">'
                .$this->gen_table($split_table['star'],$table_name)
				.'</div>';
			}
            $table.='</div>';
            $total_row+=count($v);
        }else{
            $remark_table = $this->gen_remark_table($v);
        }	
    }

    return array('table' => $table ,'total_row' => $total_row ,'remark_table' => $remark_table);

} 


function split_owned($array){

    $table = array('o'=>array(),'star'=>array());
    foreach($array AS $k => $v2){
        
             if($v2['owned'] == 'O'){
               $table['o'][] = $v2;
             }else{
                $table['star'][] = $v2;
             }
     
    }
    return $table;
}


function gen_table($array,$table_name){
	$isHanySize = (($table_name=="Handysize" || $table_name=="Handysize New Buildings")?true:false);
    global $theader_map;
    $theader_each = array();
    $theader_each['default'] = array('fleet_name','dwt','draft','yr_blt',
                                        'yard','grainLBale','cranes','features');
    $theader_each['Handysize'] = array('fleet_name','dwt','draft','yr_blt',
                                        'yard','grainLBale','cranes','features');
    $theader_each['Handysize New Buildings'] = array('fleet_name','dwt','draft','yr_blt',
                                                     'yard','grainLBale','cranes','features');
        
    if(!array_key_exists($table_name,$theader_each)){
        $table_name = 'default';
    }

    $row = '';
    $rownbsp = '';
    $row = '<table width="100%" id="myTable" class="tablesorter fleetsort" style="min-width:750px">'.PHP_EOL
                  .'<thead>'.PHP_EOL
                    .'<tr>';
                    
   foreach($theader_each[$table_name] AS $v){
        $row        .= "<td {$theader_map[$v]['attr']}></td>";
        $rownbsp    .= "<th {$theader_map[$v]['attr']} style='text-align:left;'>{$theader_map[$v]['name']}</th>";
   }             
    $row .="</tr><tr>{$rownbsp}</tr></thead>";

    foreach($array AS $k2 => $v2){
			$class=str_replace(', ',',',strtolower($v2['features']));
			$class=str_replace(' ','_',strtolower($class));
			if($isHanySize){
			$class=str_replace(',',' hs_',$class);
            $row    .= '<tr class="hs_tr hs_'.$class.'">'.PHP_EOL;
			}else{
			$class=str_replace(',',' sm_',$class);
            $row    .= '<tr class="sm_tr sm_'.$class.'">'.PHP_EOL;
			}
		
        foreach($theader_each[$table_name] AS $v){
            if($v == 'dwt'){
                $v2[$v] = number_format($v2[$v]);
            }
            if($v == 'fleet_name'){
                $star  = '';
                $star .= $v2['owned'] =='*'               ? ' *':'';
                $star .= $v2['Owned_Type'] == 'Owned LTO' ? '#' :'';
                $star .= $v2['Owned_Type'] == 'Owned BB'  ? '^' :'';
                
                
                
                $row .= "<th>".PHP_EOL;
                if($v2['pdf']){
                $row .= $v2['pdf']?"<a href='/upload/fleet/drybulk/pdf/".$v2['pdf']."' target='_blank'>":'';
                }
                $row .= "{$v2[$v]}{$star}";
                if($v2['pdf']){
                 $row .= $v2->pdf?"</a>".PHP_EOL:'';
                 }
                 $row .="</th>";
                        
            }else if($v == 'grainLBale'){ 
                $row.="<td>".str_replace("\\","",$v2[$v])."</td>";
            }else{
				if($v == 'features'){ // For replace feature to icon
					$string_to_icon = str_replace(",","",$v2[$v]);
					$string_to_icon = str_replace("Logs Fitted","<img style='margin:0' src='../images/fleet/icon/logs_fitted.png' />",$string_to_icon);
					$string_to_icon = str_replace("Semi Box","<img style='margin:0' src='../images/fleet/icon/semi_box.png' />",$string_to_icon);
					$string_to_icon = str_replace("A60","<img style='margin:0' src='../images/fleet/icon/a60.png' />",$string_to_icon);
					$string_to_icon = str_replace("CO2","<img style='margin:0' src='../images/fleet/icon/co2.png' />",$string_to_icon);
					$string_to_icon = str_replace("Open Hatch","<img style='margin:0' src='../images/fleet/icon/open_hatch.png' />",$string_to_icon);		
					$string_to_icon = str_replace("Mech Vent","<img style='margin:0'  src='../images/fleet/icon/mech_vent.png' />",$string_to_icon);	
					$string_to_icon = str_replace("Grab Fitted","<img style='margin:0'  src='../images/fleet/icon/grab_fitted.png' />",$string_to_icon);				
					$row.="<td>{$string_to_icon}</td>";
				}else{
					$row.="<td>{$v2[$v]}</td>";
				}
            }
        }
    }
    $row .= '</tr>';
    return "{$row}</table>";
}


function gen_remark_table($arr){
    global $lang;

    $remark_lang_map = array(
        'en' => 'fleet_name',
        'tc' => 'dwt',
        'sc' => 'draft',
        'jp' => 'yr_blt'
    );

    $remark_table_td = '';
    $last_updated = '';
    foreach($arr as $k => $v){
        if($v['tab_section'] == 'N'){
            $remark_table_td .= "<tr>".PHP_EOL
                                ."<td>{$v['fleet_type']}</td>".PHP_EOL
                                ."<td>{$v[$remark_lang_map[$lang]]}</td>".PHP_EOL
                                ."</tr>";
        }else{
            $last_updated = $v[$remark_lang_map[$lang]];
        }
    }
    return array('td' => $remark_table_td,'last_updated' => $last_updated);
}


function get_table_title($n,$t){
    global $format_t_map,$table_title_map;
    
   // return $n;
   
    if(!array_key_exists($t,$format_t_map) || !array_key_exists($n,$table_title_map)){
       return '';
    }
    
    $real_title = $table_title_map[$n];
    $real_type  = $format_t_map[$t];
    
    return "{$real_title} <span class=\"brackets\">(</span>{$real_type}<span class=\"brackets\">)</span>";  
} 


}

?>