if($_GET) {
        $type = cleanString($_GET['t']);
        $objPHPExcel = new PHPExcel();
        $objPHPExcel->getProperties()->setCreator("Stock (".$type.")");
        $objPHPExcel->getProperties()->setLastModifiedBy($_SESSION['user']['username']);
        $objPHPExcel->getProperties()->setTitle("Stock");
        $objPHPExcel->getProperties()->setSubject("Stock");
        $objPHPExcel->getDefaultStyle()->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);

        $objPHPExcel->setActiveSheetIndex(0);
        $objPHPExcel->getActiveSheet()->getStyle("A1:L1")->applyFromArray(array("font" => array("bold" => true)));
        $objPHPExcel->getActiveSheet()->setAutoFilter("A1:L1");
        $objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(24);
        $objPHPExcel->getActiveSheet()->getColumnDimension("B")->setWidth(24);
        $objPHPExcel->getActiveSheet()->getColumnDimension("C")->setWidth(24);
        $objPHPExcel->getActiveSheet()->getColumnDimension("D")->setWidth(40);
        $objPHPExcel->getActiveSheet()->getColumnDimension("E")->setWidth(40);
        $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(40);
        $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(40);
        $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(40);
        $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(40);
        $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(11);
        $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(14);
        $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(13);

        $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Material Code');
        $objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Description');
        $objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Picking Location');
        $objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Value');
        $objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Quantity');
        $objPHPExcel->getActiveSheet()->SetCellValue('F1', 'Category Manager');
        $objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Stock Controller');
        $objPHPExcel->getActiveSheet()->SetCellValue('H1', 'Supplier');
        $objPHPExcel->getActiveSheet()->SetCellValue('I1', 'Delivery Expected');
        $objPHPExcel->getActiveSheet()->SetCellValue('J1', 'Substitute');
        $objPHPExcel->getActiveSheet()->SetCellValue('K1', 'Comments');
        $objPHPExcel->getActiveSheet()->SetCellValue('L1', 'Status');

        $objPHPExcel->getActiveSheet()->freezePane('B2');

        $items = $db->fetchAll('SELECT
                hsbu.id,
                hsbu.material_code,
                hsbu.description,
                hsbu.pick_location,
                hsbu.value,
                hsbu.quantity,
                hsbu.category_manager,
                hsbu.stock_controller,
                hsbu.supplier,
                hsbau.delivery_expected,
                hsbau.substitute,
                hsbau.comments,
                hsbau.status,
                hsbau.prevent_order_indicator
                FROM stock'.$type.' hsbu LEFT JOIN stock_additional'.$type.' hsbau ON hsbau.material_code = hsbu.material_code ORDER BY status ASC');

        foreach($items AS $key=>$item) {
            $bk='';
            if($item->status == 0)
                $bk = 'E5F6FF;';
            elseif($item->status == 1)
                $bk = 'E9FFD0;';
            elseif($item->status == 2)
                $bk='FFF0D8;';

            $objPHPExcel->getActiveSheet()->getStyle("A1:L1")->applyFromArray(array("font" => array("bold" => true)));
            $objPHPExcel->getActiveSheet()->getStyle("A" . ($key + 2) .":L" . ($key + 2))->applyFromArray(
            array(
                "fill" => array(
                    "type" => PHPExcel_Style_Fill::FILL_SOLID,
                        "color"=>array(
                            "rgb"=>$bk
                            )
                        )
                )
            );

            $objPHPExcel->getActiveSheet()->SetCellValue('A' . ($key + 2), $item->material_code);
            $objPHPExcel->getActiveSheet()->SetCellValue('B' . ($key + 2), $item->description);
            $objPHPExcel->getActiveSheet()->SetCellValue('C' . ($key + 2), $item->pick_location);
            $objPHPExcel->getActiveSheet()->SetCellValue('D' . ($key + 2), $item->value);
            $objPHPExcel->getActiveSheet()->SetCellValue('E' . ($key + 2), $item->quantity);
            $objPHPExcel->getActiveSheet()->SetCellValue('F' . ($key + 2), $item->category_manager);
            $objPHPExcel->getActiveSheet()->SetCellValue('G' . ($key + 2), $item->stock_controller);
            $objPHPExcel->getActiveSheet()->SetCellValue('H' . ($key + 2), $item->supplier);
            $objPHPExcel->getActiveSheet()->SetCellValue('I' . ($key + 2), $item->delivery_expected);
            $objPHPExcel->getActiveSheet()->SetCellValue('J' . ($key + 2), $item->substitute);
            $objPHPExcel->getActiveSheet()->SetCellValue('K' . ($key + 2), $item->comments);
            $objPHPExcel->getActiveSheet()->SetCellValue('L' . ($key + 2), ' ' . $item->status);

        }

        $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
        $newFile = date("y-m-d") . '-' . rand(9,9999) . '-report.xls';
        header('Content-type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="'.$newFile.'"');
        header('Cache-Control: max-age=0');
        header("Pragma: no-cache");
        $objWriter->save('php://output');
        echo $newFile;
}