@php
    if(empty($data)){echo "No Data"; die();}
    $export_type = $_GET['export_type'];
    if($export_type=="all")
        $colom_download = $relational_column;
    else
        $colom_download = $coloms;

    $filename = "report";
    $keys = array_keys($translation_set);
        $filename = $filename.".csv";
        $file = fopen('php://output', 'w');

        header('Content-type: application/csv');
        header('Content-Disposition: attachment; filename="'.$filename.'"');
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");

        foreach($colom_download as $key => $value){
           if (in_array($value, $keys))
              $new_value = $translation_set[$value];
            else
                $new_value = $value;
            if (strpos($value, ' CASE when ') !== false || strpos($value, ' case when ') !== false){
                $new_value = explode(' as ',$value)[1];
            }
            $header[] = $new_value;
        }
        if(!empty($header))
            fputcsv($file,$header);
        foreach ($data as $row){
            $new_row = array();
            foreach($colom_download as $key => $v){
                $main_key = $v;
                if (str_contains($v, ' as ')) {
                    $col_name = explode(" as ",$v)[1];
                } else {
                    $col_name = explode(".",$v);
                    $col_name = trim($col_name[1]);
                }
                //echo $col_name;
                if(isset($get_timezone_fields[$v])){
                    $new_row[]=TableBuilderHelper::format_date(strip_tags($row->$col_name));
                } else {
                    $new_row[]=strip_tags($row->$col_name);
                }
            }
            fputcsv($file,$new_row);
        }
        fclose($file);
@endphp