public function executeIndex(sfWebRequest $request)
{
$this->barangs = BarangPeer::doSelect(new Criteria());
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @return Barang[]
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(BarangPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(BarangPeer::DATABASE_NAME);
$criteria->add(BarangPeer::ID, $pks, Criteria::IN);
$objs = BarangPeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeCetak(sfWebRequest $request)
{
$excel = new PHPExcel();
$query = $this->buildQuery();
$data = BarangPeer::doSelect($query);
$excel->setActiveSheetIndex(0);
$excel->getActiveSheet()->mergeCells('A1:G1');
$excel->getActiveSheet()->mergeCells('A2:G2');
$excel->getActiveSheet()->mergeCells('A3:G3');
$styleHeader = array('font' => array('bold' => true), 'borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$style = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$excel->getActiveSheet()->setCellValue('A4', "ID");
$excel->getActiveSheet()->setCellValue('B4', "NAMA BARANG");
$excel->getActiveSheet()->setCellValue('C4', "KATEGORI");
$excel->getActiveSheet()->setCellValue('D4', "STOK");
$excel->getActiveSheet()->setCellValue('E4', "KEMASAN");
$excel->getActiveSheet()->setCellValue('F4', "PRODUSEN");
$excel->getActiveSheet()->setCellValue('G4', "DESCRIPTION");
for ($i = 'A'; $i < 'H'; $i++) {
$excel->getActiveSheet()->getColumnDimension($i)->setAutoSize(true);
$excel->getActiveSheet()->getStyle($i . '4')->applyFromArray($styleHeader);
$excel->getActiveSheet()->getStyle($i . '4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
}
$i = 5;
foreach ($data as $barang) {
$excel->getActiveSheet()->setCellValue('A' . $i, $barang->getId());
$excel->getActiveSheet()->setCellValue('B' . $i, $barang->getNamaBarang());
$excel->getActiveSheet()->setCellValue('C' . $i, "" . $barang->getKategori());
$excel->getActiveSheet()->setCellValue('D' . $i, $barang->getStock());
$excel->getActiveSheet()->setCellValue('E' . $i, "" . $barang->getKemasan());
$excel->getActiveSheet()->setCellValue('F' . $i, "" . $barang->getProdusen());
$excel->getActiveSheet()->setCellValue('G' . $i, $barang->getDescription());
for ($j = 'A'; $j < 'H'; $j++) {
$excel->getActiveSheet()->getStyle($j . $i)->applyFromArray($style);
}
$i++;
}
// save to web directory
/* $objWriter = new PHPExcel_Writer_Excel2007($excel);
$objWriter->save('some_excel_file.xlsx'); */
$this->downloadExcel($excel, "stok.xls");
}
