protected function genericSampleNPDNotification(NPDEvent $event, $notificationTypeId, $status)
{
$npd = $event->getNPD();
$sampleObjects = SampleQuery::create()->whereAdd(Sample::ID_NPD_SHEET, $npd->getIdNpdSheet())->whereAdd(Sample::STATUS, $status)->addAscendingOrderBy(Sample::DEADLINE)->find();
$npdSupplierIds = NpdSheetSupplierQuery::create()->addColumn(NpdSheetSupplier::ID_SUPPLIER)->whereAdd(NpdSheetSupplier::ID_NPD_SHEET, $npd->getIdNpdSheet())->fetchCol();
$suppliers = SapSupplierQuery::create()->whereAdd(SapSupplier::CARDCODE, $npdSupplierIds, SupplierQuery::IN)->find()->toCombo();
$colors = \Application\Query\ColorQuery::create()->find()->toCombo();
$samples = array();
foreach ($sampleObjects as $sample) {
if (!$sample instanceof Sample) {
$sample = new Sample();
}
$samples[] = array('Supplier' => utf8_decode($suppliers[$sample->getIdSupplier()]), 'Quantity' => $sample->getQuantity(), 'Color' => $colors[$sample->getIdColor()], 'Remarks' => utf8_decode($sample->getNotes()), 'Deadline' => $sample->getDeadline(), 'Cost' => $sample->getCost(), 'ShippedQuantity' => $sample->getShippedQuantity());
}
$vars = array('id_npd_sheet' => $npd->getIdNpdSheet(), 'creation_date' => $npd->getCreationDateAsZendDate()->get("dd-MM-yyyy HH:mm"), 'name' => utf8_decode($npd->getName()), 'description' => utf8_decode($npd->getDescription()), 'samples' => $samples);
$this->createNotification($notificationTypeId, $vars);
}
/**
*
*/
public function getListResultsAction()
{
$params = $this->getRequest()->getParams();
$samples = SampleQuery::create()->filter($params)->orderBy(Sample::ID_SAMPLE, SampleQuery::DESC)->page($params['page'], $this->getMaxPerPage())->find();
// echo SampleQuery::create()->filter($params)->orderBy(Sample::ID_SAMPLE,SampleQuery::DESC)->page($params['page'], $this->getMaxPerPage())->createSql();die;
die(json_encode($samples->toArrayForList()));
}
