/** * */ public function exportToExcelSentSamplesAction() { $params = $this->getRequest()->getParams(); $sampleShipmentQuery = SampleShipmentQuery::create()->addDescendingOrderBy(SampleShipment::ID_SAMPLE_SHIPMENT)->filter($params)->find(); $i = 1; while ($sampleShipment = $sampleShipmentQuery->read()) { $content[$i] = array('Guide', $sampleShipment->getGuide(), '', '', '', '', ''); $i++; $content[$i] = array('Courier', $sampleShipment->getCourier(), '', '', '', '', ''); $i++; $content[$i] = array('Shipment Date', $sampleShipment->getShipmentDate(), '', '', '', '', ''); $i++; $content[$i] = array('Notes', $sampleShipment->getNote(), '', '', '', '', ''); $i++; $content[$i] = array('', '', '', '', '', '', ''); $i++; $content[$i] = array('Id Npd Sheet', 'Description', 'Supplier', 'Color', 'Quantity', 'Cost', 'Ammount'); $i++; $sampleQuery = SampleQuery::create()->whereAdd(Sample::ID_SAMPLE_SHIPMENT, $sampleShipment->getIdSampleShipment())->find(); while ($sample = $sampleQuery->read()) { $npd = NpdSheetQuery::create()->findByPK($sample->getIdNpdSheet()); if (ColorQuery::create()->whereAdd(Color::ID_COLOR, $sample->getIdColor())->count()) { $color = ColorQuery::create()->findByPK($sample->getIdColor()); } else { $color = new Color(); $color->setName('Any'); } $content[$i] = array($sample->getIdNpdSheet(), $npd->getDescription(), $sample->getIdSupplier(), $color->getName(), $sample->getQuantity(), '$' . number_format($sample->getCost(), 4) . $npd->getIdCurrency(), '$' . number_format($sample->getTotalAmmount(), 4) . $npd->getIdCurrency()); $i++; } $content[$i] = array('', '', '', '', '', 'Total', '$' . number_format($sampleQuery->getTotalAmmount(), 4) . $npd->getIdCurrency()); $i++; $content[$i] = array('', '', '', '', '', '', ''); $i++; $content[$i] = array('', '', '', '', '', '', ''); $i++; } $header = array('', '', '', '', '', '', ''); $tableColumnsWidth = array('small', 'medium', 'small', 'small', 'small', 'medium', 'medium'); // $content $title = $this->i18n->_('Sent Samples Report'); $fileName = $this->i18n->_('sent_samples_report'); $report = new SimpleListReport(); $report->setTableTitle($title); $report->setTableHeaders($header); $report->setTableContent($content); $report->setTableColumnsWidth($tableColumnsWidth); $report->setFilename($fileName); $report->createSpreadsheet(); }
private function getSamplesInformation() { $this->SetFillColor(245, 245, 245); $this->SetLineWidth(0.1); $fill = true; $this->Cell(25, 10, 'Id Npd Sheet', 'TB', 0, 'C', $fill); $this->Cell(25, 10, 'Description', 'TB', 0, 'L', $fill); $this->Cell(25, 10, 'Supplier', 'TB', 0, 'R', $fill); $this->Cell(25, 10, 'Color', 'TB', 0, 'R', $fill); $this->Cell(25, 10, 'Quantity', 'TB', 0, 'R', $fill); $this->Cell(35, 10, 'Cost', 'TB', 0, 'R', $fill); $this->Cell(30, 10, 'Ammount', 'TB', 0, 'R', $fill); $this->Ln(); $fill = false; $this->SetFillColor(225, 225, 225); $borders = 'T'; $height = 6; while ($sample = $this->samples->read()) { if (NpdSheetQuery::create()->whereAdd(NpdSheet::ID_NPD_SHEET, $sample->getIdNpdSheet())->count()) { $npd = NpdSheetQuery::create()->findByPK($sample->getIdNpdSheet()); } else { $npd = new NpdSheet(); } if (ColorQuery::create()->whereAdd(Color::ID_COLOR, $sample->getIdColor())->count()) { $color = ColorQuery::create()->findByPK($sample->getIdColor()); } else { $color = new Color(); $color->setName('Any'); } $rowHeight = 0; $x = $this->GetX(); $y = $this->GetY(); $this->MultiCell(25, $height, $npd->getIdNpdSheet(), $borders, 'R', $fill, 0); $x += 25; $y2 = $this->GetY(); $this->SetXY($x, $y); $currentCellHeight = $y2 - $y; if ($rowHeight < $currentCellHeight) { $rowHeight = $currentCellHeight; } $this->MultiCell(30, $height, $npd->getName(), $borders, 'R', $fill, 0); $x += 30; $y2 = $this->GetY(); $this->SetXY($x, $y); $currentCellHeight = $y2 - $y; if ($rowHeight < $currentCellHeight) { $rowHeight = $currentCellHeight; } $this->MultiCell(20, $height, $sample->getIdSupplier(), $borders, 'R', $fill); $x += 20; $y2 = $this->GetY(); $this->SetXY($x, $y); $currentCellHeight = $y2 - $y; if ($rowHeight < $currentCellHeight) { $rowHeight = $currentCellHeight; } $this->MultiCell(25, $height, $color->getName(), $borders, 'R', $fill); $x += 25; $y2 = $this->GetY(); $this->SetXY($x, $y); $currentCellHeight = $y2 - $y; if ($rowHeight < $currentCellHeight) { $rowHeight = $currentCellHeight; } $this->MultiCell(25, $height, $sample->getQuantity(), $borders, 'R', $fill); $x += 25; $y2 = $this->GetY(); $this->SetXY($x, $y); $currentCellHeight = $y2 - $y; if ($rowHeight < $currentCellHeight) { $rowHeight = $currentCellHeight; } $this->MultiCell(35, $height, "\$" . number_format($sample->getCost(), 4) . $npd->getIdCurrency(), $borders, 'R', $fill); $x += 35; $y2 = $this->GetY(); $this->SetXY($x, $y); $currentCellHeight = $y2 - $y; if ($rowHeight < $currentCellHeight) { $rowHeight = $currentCellHeight; } $this->MultiCell(30, $height, "\$" . number_format($sample->getTotalAmmount(), 4) . $npd->getIdCurrency(), $borders, 'R', $fill); $x += 30; $y2 = $this->GetY(); $this->SetXY($x, $y); $currentCellHeight = $y2 - $y; if ($rowHeight < $currentCellHeight) { $rowHeight = $currentCellHeight; } $this->Ln($rowHeight); } $this->samples->rewind(); $this->Cell(25, $height, ' ', 'TB', 0, 'C', $fill); $this->Cell(25, $height, '', 'TB', 0, 'L', $fill); $this->Cell(25, $height, '', 'TB', 0, 'R', $fill); $this->Cell(25, $height, '', 'TB', 0, 'R', $fill); $this->Cell(25, $height, '', 'TB', 0, 'R', $fill); $this->Cell(35, $height, 'Total', 'TB', 0, 'R', $fill); $this->Cell(30, $height, "\$" . number_format($this->samples->getTotalAmmount(), 4) . $npd->getIdCurrency(), 'TB', 0, 'R', $fill); $this->Ln(); }