public function showUploadedRecord( Request $request ){



        //add sort order if it does not exists or remove sort if it exists
        $full_path = url()->full();
        $url_array_full = parse_url($full_path);



        if( !empty($url_array_full['query'])){

            //it already has sorted column and order
            if( $request->has('column') && $request->has('order') && !empty($request->column) && !empty($request->order) ){

                parse_str($url_array_full['query'], $output_array);

                unset($output_array['column']);
                unset($output_array['order']);
                $queries = http_build_query($output_array);



                $port = !empty($url_array_full['port']) ? $url_array_full['port'] : '';

                if(!empty( $queries )){
                    $sort_path = $url_array_full['scheme'] . '://' . $url_array_full['host'] .':'. $port . $url_array_full['path'] .'?'. $queries .'&';
                }else{
                    $sort_path = $url_array_full['scheme'] . '://' . $url_array_full['host'] .':'. $port . $url_array_full['path'] .'?'. $queries;
                }


            }else{
                $sort_path = $full_path.'&';
            }
        }else{
            $sort_path = $full_path.'?';
        }


        //DB::connection()->enableQueryLog();
        $query = DB::table('shipment_data');




        $columns = array('Amazon order id', 'Merchant order id', 'Shipment id', 'Shipment item id', 'Amazon order item id', 'Merchant order item id', 'Purchase date', 'Payments date', 'Shipment date', 'Reporting date', 'Buyer email', 'Buyer name', 'Buyer phone number', 'Sku', 'Product name', 'Quantity shipped', 'Currency', 'Item price','Item tax', 'Shipping price', 'Shipping tax', 'Gift wrap price', 'Gift wrap tax', 'Ship service level', 'Recipient name', 'Ship address 1', 'Ship address 2','Ship address 3','Ship city', 'Ship state', 'Ship postal code', 'Ship country','Ship phone number', 'Bill address 1', 'Bill address 2', 'Bill address 3', 'Bill city', 'Bill state', 'Bill postal code', 'Bill country', 'Item promotion discount', 'Ship promotion discount', 'Carrier', 'Estimated arrival date', 'Fulfillment center id', 'Fulfillment channel', 'Sales channel', 'Date Created', 'Date Modified','Brand');

        $column = $request->has('column') && in_array($request->column, $columns) ? $request->column : $columns[6];
        $sort_order = $request->has('order') && strtolower($request->order) == 'desc' ? 'DESC' : 'ASC';

        $up_or_down = str_replace(array('ASC','DESC'), array('up','down'), $sort_order);
        $asc_or_desc = $sort_order == 'ASC' ? 'desc' : 'asc';






        $upload_id = $request->upload_id;
        if( $upload_id == 'kabaflair' ){
            $brand_id = '1';
        }elseif( $upload_id == 'lightningfast' ){
            $brand_id = '2';
        }


        $query->selectRaw('*, shipment_data.id AS secret_id');
        $query->leftJoin('csv_data', 'csv_data.id', '=', 'csv_data_id');
        $query->leftJoin('brands', 'brands.id', '=', 'shipment_data.brand_id');


        $where_array = array();

        if( $upload_id == 'kabaflair' || $upload_id == 'lightningfast') {
            $where_array[] = ['shipment_data.brand_id', '=', $brand_id];
        }else{
            $where_array[] = ['csv_data_id', '=', $upload_id];
        }

        //set default filters after filter submission
        $filters_array = array();
        var_dump($filters_array);




        if( $request->has('filters') && !empty($request->filters)){

            foreach( $request->filters as $key => $value ){
                $db_column = strtolower($value);
                $db_column = str_replace(' ', '_', $db_column);
                $filters_array[$key]['filter'] = $value;
                echo $key;
                echo $value;
                if( strpos( strtolower($value), "date" ) != false ){
                    $date_start = $request->date_start[$key];
                    $date_end = $request->date_end[$key];

                    $filters_array[$key]['date_start'] = $date_start;
                    $filters_array[$key]['date_end'] = $date_end;



                    //if dates are provided check if start date is greater than end date
                    if( $date_start > $date_end){
                        return redirect()->back()->withErrors(['Start date should be before or same as end date']);
                    }elseif( $date_start == $date_end ){
                        $query->whereRaw('CAST( `'.$db_column.'` as DATE) = ?' ,[$date_start]);
                    }else{

                        $query->whereRaw('CAST( `'.$db_column.'` as DATE) BETWEEN ? AND ?' ,[$date_start, $date_end]);
                    }

                }else{
                    if( !empty($request->search[$key]) ){
                        $search = $request->search[$key];
                        if( $db_column == 'buyer_name' ){
                            $where_array[] = [$db_column, 'like', '%'.$search.'%'];
                        }else{

                            //$filters_array[$key]['search'] = $date_end;
                            $where_array[] = [$db_column, '=', $search];
                        }

                    }

                }

            }
        }



        $where_array[] = ['deleted', '=', '0'];
        $query->where($where_array);


        if( $request->has('column') && $request->has('order') && !empty($request->column) && !empty($request->order) ){

            $order_column = strtolower($request->column);
            $order_column = str_replace(' ', '_', $order_column);


            if( $order_column == 'brand' ){
                $order_column = 'shipment_data.brand_id';
            }
            $order = $request->order;
        }else{
            $order_column = 'purchase_date';
            $order = 'desc';
        }

        //get filtered ids ready for multiple deletion
        $filtered_ids = array();
        if( $request->has('filters') && !empty($request->filters)){
            $filtered_ids = $query->pluck('shipment_data.secret_id');
        }


        $query->orderBy( $order_column, $order);
        $records = $query->paginate(50);




        //var_dump($records);
       //var_dump(DB::getQueryLog());

        return view( 'pages/show_records', compact('records', 'upload_id', 'up_or_down','asc_or_desc', 'column', 'sort_path', 'filters_array', 'filtered_ids') );

    }