Smopp_v2/XLSList2.php

<?
header("Expires: 0");
session_start();
require_once 'PHPExcel-1.8.2/Classes/PHPExcel.php';
include 'auth.php';
include 'functions.php';

function cellColor($cells,$color){
    global $objPHPExcel;

    $objPHPExcel->getActiveSheet()->getStyle($cells)->getFill()->applyFromArray(array(
        'type' => PHPExcel_Style_Fill::FILL_SOLID,
        'startcolor' => array(
             'rgb' => $color
        )
    ));
}

$styleBorder = array(
    'borders' => array(
        'allborders' => array(
            'style' => PHPExcel_Style_Border::BORDER_THIN
        )
    )
);


foreach (array_keys($_REQUEST) as $var)
{
${$var}=$_REQUEST[$var];
//echo "<b>$var:</b> ${$var} <br>";		
}
$array_children = $_SESSION['array_children'];
$array_parent = $_SESSION['array_parent'];
$activeid = $_SESSION['actid'];
$res_parent = $array_parent[$activeid];

foreach($res_parent as $key => $r) {

    if ('type' == $key){
        $res_parent_type = $r;
    }
    if ('input_id' == $key){
        $res_parent_input_id = $r;
    }
    if ( 'created' == $key) {
        $res_parent_created = $r;
    }
}
//var_dump($res_parent_created);echo "<br>";
//exit;

$namedesc = GetTaskNameAndDesc($res_parent_type);
//$namedesc = GetTaskNameAndDesc($res_parent['type']);
$proj = GetProject($res_parent_input_id);
//$proj = GetProject($res_parent['input_id']);
$depo = $proj['depo'];
$depo_service = $proj['depo_service'];
$finished = $res_parent_created;
//$finished = $res_parent['created'];

		// Create new PHPExcel object
	$objPHPExcel = new PHPExcel();

	// Set document properties
	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
								 ->setLastModifiedBy("Maarten Balliauw")
								 ->setTitle("Office 2007 XLSX Report Document")
								 ->setSubject("Office 2007 XLSX Report Document")
								 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
								 ->setKeywords("office 2007 openxml php")
								 ->setCategory("Report result file");

	$style = array(
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
        )
    );

	$style1 = array(
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT,
        )
    );
	$style2 = array(
        'alignment' => array(
            'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER,
        )
    );
	$sheet = $objPHPExcel->getActiveSheet();
    $sheet->getDefaultStyle()->getFont()->setName('Times New Roman')->setSize(11);

  //$sheet->getStyle("A2:A9")->applyFromArray($style);
  //$sheet->getStyle("B1")->applyFromArray($style);
  $sheet->getStyle("C3")->applyFromArray($style);
  //$sheet->getStyle("B10")->applyFromArray($style);

  //$sheet->getStyle("A7:A9")->applyFromArray($style1);

  //$sheet->getDefaultStyle()->applyFromArray($style);
//	$sheet->getStyle('B11:D11')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
    $objPHPExcel->getActiveSheet()->getStyle('B11:D11')->applyFromArray($styleBorder);
	cellColor('B11:D11', 'f2f2f2');
    $sheet->getRowDimension('1')->setRowHeight(31.5);
    $sheet->getRowDimension('3')->setRowHeight(31.5);
    $sheet->getRowDimension('4')->setRowHeight(31.5);
    $sheet->getRowDimension('5')->setRowHeight(31.5);
    $sheet->getRowDimension('6')->setRowHeight(31.5);
    $sheet->getRowDimension('7')->setRowHeight(31.5);
    //$sheet->getRowDimension('1')->setRowHeight(31.5);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', 'Приложение №10 к Регламенту (Приложение №4)');
    //$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D2', 'Проект №'.$proj['id']);
	//cellColor('A1:J1', '8DB4E2');

	$sheet->getStyle('C3:C4')->getFont()->setBold(TRUE);
	$sheet->getStyle('B11:D11')->getFont()->setBold(TRUE);
	//$sheet->getStyle('B3:B6')->getFont()->setBold(TRUE);

  $sheet->setCellValue('B11', '№ п/п');
  $sheet->setCellValue('C11', 'Наименование работ');
//$sheet->setCellValue('C11', 'Дата создания задачи');
//$sheet->setCellValue('D11', 'Дата начала исполнения');
  //$sheet->setCellValue('C11', 'Описание');
$sheet->setCellValue('D11', 'Необходимые запасные части');
//  $sheet->setCellValue('D11', 'Дата завершения');
//  $sheet->setCellValue('E11', "Исполнитель");
//$sheet->setCellValue('D11', 'Замечания');
//$sheet->setCellValue('E11', "Замечания");
//  $sheet->setCellValue('F11', 'Замечания');
//  $sheet->setCellValue('G11', 'Замечания');
//  $sheet->setCellValue('H11', 'Замечания');
//  $sheet->setCellValue('I11', 'Замечания');
//    $sheet->setCellValue('J11', 'Замечания');
    //$sheet->setCellValue('K11', 'Замечания');
    //$sheet->setCellValue('L11', 'Замечания');

	//cellColor('A10:L11', 'EEEEEE');
	//$sheet->getStyle('A10:L11')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
	$sheet->getStyle('A10:L11')->getFont()->setBold(TRUE);

	//$sheet->setCellValue('A2', '№');
	//$sheet->setCellValue('A3', '1');
	//$sheet->setCellValue('A4', '2');    //имя глобала
	//$sheet->setCellValue('A5', '3');    //Депо сервисного обслуживания: Братское
	//$sheet->setCellValue('A6', '4');    //Настоящий акт подверждает, что  2018-12-12T00:00:00 на
	//$sheet->setCellValue('A7', '5');    //Локомотиве серии номер
	//$sheet->setCellValue('A8', '6');    //приписки локомотивного депо
	//$sheet->setCellValue('A9', '7');    //В ходе приемки, испытания, осмотра и ремонта  Локомотива необходимо проведение следующих работ:
	//$sheet->setCellValue('B2', 'Наименование');
    $objPHPExcel->getActiveSheet()->getStyle("C3:C4")->getFont()->setSize(18);
    //$objPHPExcel->getActiveSheet()->getStyle("C3:C4")->getFont()->setSize(18);
	$sheet->setCellValue('C3', 'Акт №');

	//$sheet->setCellValue('C4', $namedesc[0]);
    $sheet->setCellValue('C4', $namedesc[0]);
	$sheet->setCellValue('C5', "Депо сервисного обслуживания: ".$depo_service);
    $sheet->setCellValue('C6', 'Настоящий акт подверждает, что '.$finished->date);
	$sheet->setCellValue('C7', "На локомотиве серии ".$proj['loco_type']." номер ".$proj['loco_number']);
	$sheet->setCellValue('C8', "Приписки локомотивного депо: $depo");
	$sheet->setCellValue('C9', 'В ходе приемки, испытания, осмотра и ремонта  Локомотива необходимо проведение следующих работ:');
    //$sheet->getStyle('C9')->getFont()->setBold(TRUE);
	//$sheet->setCellValue('C2', 'Значение');


	//cellColor('A10:L10', '8DB4E2');

	$sheet->getStyle('B11')->getFont()->setBold(TRUE);
	$sheet->getStyle('B10')->getFont()->getColor()->setRGB('FFFFFF');

$i=12;
foreach ($array_children as $parent_id => $children)
{
    if ($activeid != $parent_id)
    {
        continue;
    }

    foreach ($children as $res1) {
        $taskid = $res1->id;
        $type = $res1->type;
        $created = $res1->created;
        $accepted = $res1->accepted_time;
        $finished = $res1->finished_time;
        $assignee = $res1->assignees_arr;
        $assignee_names = GetAccount($assignee)['name'];
        if ($finished == '')
            $finished = 'не завершена';
        if ($accepted == '')
            $accepted = 'не принята';

        $namedesc = GetTaskNameAndDesc($type);
//        $sheet->setCellValueByColumnAndRow(0, $i, $taskid);
//        $sheet->setCellValueByColumnAndRow(1, $i, $namedesc[0]);
//        $sheet->setCellValueByColumnAndRow(2, $i, $namedesc[1]);
//        $sheet->setCellValueByColumnAndRow(3, $i, $finished);
//        $sheet->setCellValueByColumnAndRow(4, $i, $assignee_names);
//        $sheet->setCellValueByColumnAndRow(5, $i, $namedesc[1]);
//        $sheet->setCellValueByColumnAndRow(6, $i, $assignee_names);
        $notes = FindTaskNotes($taskid);
        if (sizeof($notes) > 0) {
            $nn = 2;
            $num = 0;
            $notestext = "$taskid. \n";
            foreach ($notes as $note) {
                $num++;
//                if ($num == 3)
//                    break;
                $notedate = $note['date'];
                $noteid = $note['id'];
                $notetext = $note['text'];
                //$sheet->setCellValueByColumnAndRow($nn, $i, $noteid." [".$notedate."] ".$notetext);
                $sheet->getStyle('C'.$i)->getAlignment()->setWrapText(true);
                $sheet->getStyle('D'.$i)->getAlignment()->setWrapText(true);
                $sheet->getStyle('E'.$i)->getAlignment()->setWrapText(true);
                $sheet->getStyle('F'.$i)->getAlignment()->setWrapText(true);
                $sheet->getStyle('G'.$i)->getAlignment()->setWrapText(true);
                $notestext .= $num.". ".$notetext."\n";
                //$nn++;
            }
            $sheet->setCellValueByColumnAndRow($nn, $i, $notestext);
            $i++;
        }
    }
}
$sheet->getStyle("B12:D".$i)->applyFromArray($styleBorder);
$i+=2;
$sheet->getRowDimension($i)->setRowHeight(25);
$sheet->setCellValueByColumnAndRow(2, $i,  'Дата окончания осмотра: '.$finished);
$i+=2;
$sheet->getRowDimension($i)->setRowHeight(30);
$sheet->setCellValueByColumnAndRow(2, $i,  'Исполнитель: '.$assignee_names);

		// Rename worksheet
		$sheet->setTitle('Report');
		
		
		// Set active sheet index to the first sheet, so Excel opens this as the first sheet
		$objPHPExcel->setActiveSheetIndex(0);


		$sheet->getColumnDimension('A')->setWidth(17.57);
		$sheet->getColumnDimension('B')->setWidth(7.14);
		$sheet->getColumnDimension('C')->setWidth(51.29);
        $sheet->getColumnDimension('D')->setWidth(51.29);
		$sheet->getColumnDimension('E')->setWidth(51.29);
		$sheet->getColumnDimension('F')->setWidth(51.29);
		$sheet->getColumnDimension('G')->setWidth(51.29);
		$sheet->getColumnDimension('H')->setAutoSize(true);	
		$sheet->getColumnDimension('I')->setAutoSize(true);
        $sheet->getColumnDimension('J')->setAutoSize(true);
        $sheet->getColumnDimension('K')->setAutoSize(true);
        $sheet->getColumnDimension('L')->setAutoSize(true);
        $sheet->getColumnDimension('M')->setAutoSize(true);



		$objPHPExcel->getActiveSheet()->getStyle('E11')->getAlignment()->setWrapText(true);
		
		$sheet->getStyle("A10:M10")->applyFromArray($style2);
		
		$styleBorder = array('font' => array('bold' => true));
		$sheet->getStyle('B1:F1')->applyFromArray($styleBorder);
		$sheet->getStyle('A1')->getFont()->setBold(TRUE);
		//$sheet->getStyle('B1')->getFont()->getColor()->setRGB('FFFFFF');
		
		// Redirect output to a client’s web browser (Excel5)
		header('Content-Type: application/vnd.ms-excel');
$date1 = date('d.m.Y-H.i', strtotime($finished));

header('Content-Disposition: attachment;filename="'.$proj['loco_number'].'-'.$date1.'-'.$assignee_names.'.xls"');
		header('Cache-Control: max-age=0');
		// If you're serving to IE 9, then the following may be needed
		header('Cache-Control: max-age=1');
		
		// If you're serving to IE over SSL, then the following may be needed
		header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
		header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
		header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
		header ('Pragma: public'); // HTTP/1.0
		
		$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
		//$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
		$objWriter->save('php://output');

?>