PHP ModeloVenta::getDeclarativo_value Examples

Example #1

File: ventas_listado_declarativo_excel_02.php Project: claudiospro/neointel_proyecto02

            }
        }
        $j += $row['items'];
    }
    $objPHPExcel->getActiveSheet()->getStyle(c2(1, $j, 1, 2))->applyFromArray($border_style);
    $objPHPExcel->setActiveSheetIndex(0)->getStyle(c2(1, $j, 1, 2))->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFFFBF00');
}
$i = 3;
if ($ou['body'] != null) {
    foreach ($ou['body'] as $row) {
        $j = 1;
        foreach ($row as $name => $value) {
            if (strpos($name, '_correo') !== false && $value == '') {
                $value = '*****@*****.**';
            }
            $objPHPExcel->setActiveSheetIndex(0)->setCellValue(getNameFromNumber($j) . '' . $i, $venta->getDeclarativo_value($value, $ou['info'][$name]));
            $j++;
        }
        $objPHPExcel->getActiveSheet()->getStyle(c2(1, $j, $i, $i))->applyFromArray($border_style);
        $i++;
    }
}
// -------------------------------------------------------- TEST
// Utilidades::printr($in);
// Utilidades::printr($_SESSION);
// Utilidades::printr($campos);
// Utilidades::printr($ou);
// -------------------------------------------------------- OUT
$objPHPExcel->getActiveSheet()->setTitle('Data');
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.ms-excel');