Exemplo n.º 1
0
 /**
  * @param Purchase $purchase
  * @return Log[]
  */
 public function findByPurchase(Purchase $purchase)
 {
     $dql = "select l, u from ent:Log l left join l.user u where l.resource_id = :id and l.resource_type = :type";
     $query = $this->em()->createQuery($dql);
     $query->setParameters(['id' => $purchase->getId(), 'type' => Purchase::class]);
     return $query->getResult();
 }
Exemplo n.º 2
0
 /**
  * @param $optional
  */
 protected function assignCancelDate($optional)
 {
     if ($canceledAt = $this->getCanceledAt()) {
         if (!$canceledAt instanceof \DateTime) {
             $canceledAt = \DateTime::createFromFormat($this->getInputDateFormat(), $canceledAt);
             if (!$canceledAt instanceof \DateTime) {
                 $canceledAt = new \DateTime();
             }
         }
         $this->purchase->setCanceledAt($canceledAt);
     } else {
         if (!$this->purchase->getCanceledAt() instanceof \DateTime && !$optional) {
             $this->purchase->setCanceledAt(new \DateTime());
         }
     }
 }
Exemplo n.º 3
0
 /**
  * @return int|null
  */
 public function getRecordIdOrNull()
 {
     return $this->existingRecord ? $this->existingRecord->getId() : null;
 }
Exemplo n.º 4
0
 /**
  * Download purchase detail
  */
 public function downloadExcelAction()
 {
     try {
         $purchase = $this->getPurchaseService()->getPurchaseWithItems($this->getRequestQuery('id'));
         $account = $this->account();
         // set excel working directory
         $config = $this->getServiceManager()->get('ApplicationConfig');
         if (isset($config['cache_dir'])) {
             $this->setExcelDocsWorkingDir($config['cache_dir']);
         } else {
             $this->setExcelDocsWorkingDir(sys_get_temp_dir());
         }
         $excel = $this->createExcelDoc(function (\PHPExcel $excel) use($purchase, $account) {
             $ws = $excel->getActiveSheet();
             $ws->mergeCells('A2:F2');
             $ws->setCellValue('A2', $purchase->getTitle());
             $ws->getRowDimension(2)->setRowHeight(30);
             $ws->getStyle('A2')->getFont()->setBold(true);
             $ws->getStyle('A2')->getFont()->setSize(18);
             $ws->mergeCells('A3:F3');
             $ws->setCellValue('A3', sprintf('Status: %s', Purchase::statusToLocaleID($purchase->getStatus())));
             $ws->getStyle('A3')->getFont()->setSize(13);
             $ws->getRowDimension(3)->setRowHeight(22);
             $thRowNum = 5;
             if ($purchase->getCreator() instanceof User) {
                 $ws->mergeCells('A5:F5');
                 $ws->setCellValue('A5', sprintf('Dibuat Oleh: %s', $purchase->getCreator()->getName()));
                 $ws->getStyle('A5')->getFont()->setSize(13);
                 $ws->getRowDimension(5)->setRowHeight(22);
                 $thRowNum += 1;
             }
             if ($purchase->getCreatedAt() instanceof \DateTime) {
                 $ws->mergeCells('A6:F6');
                 $ws->setCellValue('A6', sprintf('Tgl. Dibuat: %s', $purchase->getCreatedAt()->format('d M Y')));
                 $ws->getStyle('A6')->getFont()->setSize(13);
                 $ws->getRowDimension(6)->setRowHeight(22);
                 $thRowNum += 1;
             }
             if ($purchase->getOrderedAt() instanceof \DateTime) {
                 $ws->mergeCells('A7:F7');
                 $ws->setCellValue('A7', sprintf('Tgl. Order: %s', $purchase->getOrderedAt()->format('d M Y')));
                 $ws->getStyle('A7')->getFont()->setSize(13);
                 $ws->getRowDimension(7)->setRowHeight(22);
                 $thRowNum += 2;
             }
             if ($purchase->getDeliveredAt() instanceof \DateTime) {
                 $ws->mergeCells('A8:F8');
                 $ws->setCellValue('A8', sprintf('Tgl. Diterima: %s', $purchase->getDeliveredAt()->format('d M Y')));
                 $ws->getStyle('A8')->getFont()->setSize(13);
                 $ws->getRowDimension(8)->setRowHeight(22);
                 $thRowNum += 1;
             }
             $ws->getColumnDimension('A')->setWidth(5);
             $ws->getColumnDimension('B')->setWidth(32);
             $ws->getColumnDimension('C')->setWidth(14);
             $ws->getColumnDimension('D')->setWidth(20);
             $ws->getColumnDimension('E')->setWidth(20);
             $ws->getColumnDimension('F')->setWidth(20);
             $ws->setCellValue('A' . $thRowNum, 'No');
             $ws->setCellValue('B' . $thRowNum, 'Item');
             $ws->setCellValue('C' . $thRowNum, 'Qty');
             $ws->setCellValue('D' . $thRowNum, 'Harga/Unit');
             $ws->setCellValue('E' . $thRowNum, 'Subtotal');
             $ws->setCellValue('F' . $thRowNum, 'Total');
             $ws->getRowDimension($thRowNum)->setRowHeight(22);
             $ws->getStyle(sprintf('A%d:F%d', $thRowNum, $thRowNum))->getFont()->setBold(true);
             $itemStartRow = $thRowNum + 1;
             $itemEndRow = $itemStartRow;
             foreach ($purchase->getItems() as $index => $item) {
                 $ws->setCellValue('A' . $itemEndRow, $index + 1);
                 $ws->setCellValue('B' . $itemEndRow, $item->getItemName());
                 $ws->setCellValue('C' . $itemEndRow, sprintf('%s %s', number_format($item->getQuantity(), 0), $item->getUnit()));
                 $ws->setCellValue('D' . $itemEndRow, $item->getUnitPrice());
                 $ws->setCellValue('E' . $itemEndRow, $item->getSubtotal());
                 $ws->setCellValue('F' . $itemEndRow, $item->getTotal());
                 $ws->getRowDimension($itemEndRow)->setRowHeight(22);
                 $itemEndRow++;
             }
             $rollUpRowNum = $itemEndRow;
             $ws->getRowDimension($rollUpRowNum)->setRowHeight(22);
             $ws->mergeCells(sprintf('A%d:D%d', $rollUpRowNum, $rollUpRowNum));
             $ws->setCellValue('A' . $rollUpRowNum, 'Total');
             $ws->setCellValue('E' . $rollUpRowNum, sprintf('=SUM(E%d:E%d)', $itemStartRow, $itemEndRow - 1));
             $ws->setCellValue('F' . $rollUpRowNum, sprintf('=SUM(F%d:F%d)', $itemStartRow, $itemEndRow - 1));
             $noteRowNum = $rollUpRowNum + 2;
             if ($purchase->getNote()) {
                 $ws->mergeCells(sprintf('A%d:F%d', $noteRowNum, $noteRowNum));
                 $ws->getStyle('A' . $noteRowNum)->getFont()->setSize(13);
                 $ws->setCellValue('A' . $noteRowNum, 'Catatan:');
                 $ws->mergeCells(sprintf('A%d:F%d', $noteRowNum + 1, $noteRowNum + 1));
                 $ws->getStyle('A' . ($noteRowNum + 1))->getFont()->setSize(13);
                 $ws->setCellValue('A' . ($noteRowNum + 1), $purchase->getNote());
             }
             $ws->getStyle(sprintf('A%d:F%d', $thRowNum, $rollUpRowNum))->getBorders()->getAllBorders()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);
             $ws->getStyle(sprintf('D%d:D%d', $itemStartRow, $rollUpRowNum - 1))->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
             $ws->getStyle(sprintf('E%d:E%d', $itemStartRow, $rollUpRowNum))->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
             $ws->getStyle(sprintf('F%d:F%d', $itemStartRow, $rollUpRowNum))->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
             $ws->getStyle(sprintf('D%d:D%d', $itemStartRow, $rollUpRowNum - 1))->getNumberFormat()->setFormatCode(sprintf('"%s" #,##0.00_-', $account->getDefaultCurrency()));
             $ws->getStyle(sprintf('E%d:E%d', $itemStartRow, $rollUpRowNum))->getNumberFormat()->setFormatCode(sprintf('"%s" #,##0.00_-', $account->getDefaultCurrency()));
             $ws->getStyle(sprintf('F%d:F%d', $itemStartRow, $rollUpRowNum))->getNumberFormat()->setFormatCode(sprintf('"%s" #,##0.00_-', $account->getDefaultCurrency()));
             $ws->getStyle(sprintf('A%d:F%d', $thRowNum, $rollUpRowNum))->getFont()->setSize(13);
         });
         $this->downloadExcelDoc($excel, $purchase->getTitle());
         return null;
     } catch (NoResultException $e) {
         return $this->notFoundAction();
     }
 }
Exemplo n.º 5
0
 /**
  * @param Purchase $purchase
  * @param User $corrector
  * @param array $rawItems
  */
 public function increaseStock(Purchase $purchase, User $corrector, array $rawItems)
 {
     $getStockId = function ($stock) {
         if ($stock instanceof Stock) {
             return $stock->getId();
         } else {
             if (is_numeric($stock)) {
                 return $stock;
             } else {
                 throw new \InvalidArgumentException();
             }
         }
     };
     $stocks = [];
     $unitPrices = [];
     foreach ($rawItems as $item) {
         // todo: change $items array to object? to prevent missing keys in array.
         if (isset($item['stock']) && $item['stock'] && isset($item['quantity']) && $item['quantity']) {
             try {
                 $stocks[$getStockId($item['stock'])] = $item['quantity'];
                 if (isset($item['total']) && $item['total'] && $item['quantity'] > 0) {
                     $unitPrices[$getStockId($item['stock'])] = $item['total'] / $item['quantity'];
                 }
             } catch (\Exception $e) {
                 continue;
             }
         }
     }
     /** @var Stock[] $stockEntities */
     $stockEntities = $this->findStockInIds(array_keys($stocks));
     foreach ($stockEntities as $stockEntity) {
         if (isset($stocks[$stockEntity->getId()])) {
             $quantity = $stocks[$stockEntity->getId()];
             $ratio = $stockEntity->getStockItem()->getStorageUnit()->getRatio();
             $unitQuantity = $quantity * $ratio;
             if ($unitQuantity) {
                 // create level change
                 $levelChange = new LevelChange();
                 $levelChange->setStock($stockEntity);
                 $levelChange->setCorrector($corrector);
                 $levelChange->setCurrentLevel($stockEntity->getCurrentLevel());
                 $levelChange->setType(LevelChange::TYPE_PURCHASE);
                 $levelChange->setDelta($unitQuantity);
                 $levelChange->setAuto(true);
                 $levelChange->setNote(sprintf("#%d (+%s %s)", $purchase->getId(), $quantity, $stockEntity->getStockItem()->getStorageUnit()->getName()));
                 // update stock
                 $stockEntity->setCurrentLevel($stockEntity->getCurrentLevel() + $unitQuantity);
                 $stockEntity->setLastChange(new \DateTime());
                 if (isset($unitPrices[$stockEntity->getId()])) {
                     $stockEntity->setCurrentUnitPrice($unitPrices[$stockEntity->getId()]);
                 }
                 if ($purchase->getOrderedAt() instanceof \DateTime) {
                     $stockEntity->setLastPurchase($purchase->getOrderedAt());
                 }
                 $this->em()->persist($levelChange);
                 $this->em()->persist($stockEntity);
             }
         }
     }
     $this->em()->flush();
 }