コード例 #1
0
 public function service()
 {
     if (isset(NGS()->args()->id)) {
         $purchaseOrderId = NGS()->args()->id;
     } else {
         $_SESSION['error_message'] = 'Purchase Order ID is missing';
         $this->redirect('purchase/list');
     }
     $purchaseOrderManager = PurchaseOrderManager::getInstance();
     $purchaseOrderDto = $purchaseOrderManager->selectByPK($purchaseOrderId);
     if (!isset($purchaseOrderDto)) {
         $_SESSION['error_message'] = 'Purchase Order with ID ' . NGS()->args()->id . ' does not exists.';
         $this->redirect('purchase/list');
     }
     if ($purchaseOrderDto->getCancelled() == 1) {
         $_SESSION['error_message'] = 'Purchase Order with ID ' . NGS()->args()->id . ' is already cancelled.';
         $this->redirect('purchase/list');
     }
     $note = NGS()->args()->note;
     $purchaseOrderManager->cancelPurchaseOrder($purchaseOrderId, $note);
     try {
         PurchaseOrderManager::getInstance()->updateAllDependingSaleOrderLines($purchaseOrderId);
         $_SESSION['success_message'] = 'Purchase Order Successfully cancelled!';
     } catch (InsufficientProductException $exc) {
         $purchaseOrderManager->restorePurchaseOrder($purchaseOrderId);
         $productDto = ProductManager::getInstance()->selectByPK($exc->getProductId());
         $_SESSION['error_message'] = $productDto->getName() . ' product insufficient!';
     }
     $this->redirectToReferer();
 }
コード例 #2
0
 public function service()
 {
     if (isset(NGS()->args()->id)) {
         $productId = NGS()->args()->id;
     } else {
         $_SESSION['error_message'] = 'Product ID is missing';
         $this->redirect('product/list');
     }
     $productManager = ProductManager::getInstance();
     $productDto = $productManager->selectByPK($productId);
     if (!isset($productDto)) {
         $_SESSION['error_message'] = 'Product with ID ' . NGS()->args()->id . ' does not exists.';
         $this->redirect('product/list');
     }
     $res = $productManager->safeDeleteProduct($productId);
     if ($res) {
         $_SESSION['success_message'] = 'Product Successfully deleted!';
     } else {
         $_SESSION['error_message'] = 'Product can not be deleted. There are Sale and/or Purchase Order(s) that contains this product.';
         $this->redirect('product/list');
     }
     if (strpos($_SERVER['HTTP_REFERER'], 'product/list') === false) {
         $this->redirect('product/list');
     } else {
         $this->redirectToReferer();
     }
 }
コード例 #3
0
ファイル: CreateLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $this->initErrorMessages();
     $this->initSuccessMessages();
     $this->addParam('req', isset($_SESSION['action_request']) ? $_SESSION['action_request'] : []);
     $this->addParam('products', ProductManager::getInstance()->selectAdvance('*', [], ['name']));
     unset($_SESSION['action_request']);
     $this->addParam('uoms', UomManager::getInstance()->selectAdvance('*', [], ['name']));
     $this->addParam('manufacturers', ManufacturerManager::getInstance()->selectAdvance('*', [], ['name']));
     $this->addParam('defaultCurrencyId', SettingManager::getInstance()->getSetting('default_currency_id'));
     $this->addParam('defaultUomId', SettingManager::getInstance()->getSetting('default_uom_id'));
 }
コード例 #4
0
ファイル: WarehouseLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $productsQuantity = WarehouseManager::getInstance()->getAllProductsQuantity();
     $products = ProductManager::getInstance()->getProductListFull([], 'name', 'ASC');
     $productIds = ProductManager::getDtosIdsArray($products);
     $productsPurchaseOrders = PurchaseOrderLineManager::getInstance()->getProductsPurchaseOrders($productIds);
     $productsSaleOrders = SaleOrderLineManager::getInstance()->getProductsSaleOrders($productIds);
     $this->addParam('products', $products);
     $this->addParam('productsQuantity', $productsQuantity);
     $this->addParam('productsPurchaseOrder', $productsPurchaseOrders);
     $this->addParam('productsSaleOrder', $productsSaleOrders);
 }
コード例 #5
0
 public function service()
 {
     if (!isset(NGS()->args()->product_id)) {
         new NgsErrorException('Missing Product ID!');
     }
     $product_id = intval(NGS()->args()->product_id);
     $productDto = ProductManager::getInstance()->selectByPK($product_id);
     if (!isset($productDto)) {
         new NgsErrorException('Product does not exist with given ID: ' . NGS()->args()->product_id);
     }
     $productQuantityInStock = ProductManager::getInstance()->calculateProductQuantityInStock($product_id);
     $this->addParam('quantity', $productQuantityInStock);
 }
コード例 #6
0
ファイル: OpenLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $this->initErrorMessages();
     $this->initSuccessMessages();
     $this->addParam('products', ProductManager::getInstance()->selectAdvance('*', [], ['name']));
     $this->addParam('currencies', CurrencyManager::getInstance()->selectAdvance('*', ['active', '=', 1], ['name']));
     $paymentId = NGS()->args()->id;
     $purchaseOrders = PurchaseOrderManager::getInstance()->getPurchaseOrdersFull(['id', '=', $paymentId]);
     if (!empty($purchaseOrders)) {
         $purchaseOrder = $purchaseOrders[0];
         $this->addParam('purchaseOrder', $purchaseOrder);
     }
 }
コード例 #7
0
 public function service()
 {
     try {
         list($id, $name, $model, $manufacturerId, $uomId) = $this->getFormData();
     } catch (RedirectException $exc) {
         $_SESSION['error_message'] = $exc->getMessage();
         $_SESSION['action_request'] = $_REQUEST;
         $this->redirect($exc->getRedirectTo());
     }
     ProductManager::getInstance()->updateProduct($id, $name, $model, $manufacturerId, $uomId);
     unset($_SESSION['action_request']);
     $_SESSION['success_message'] = 'Product Successfully updated!';
     $this->redirect('product/' . $id);
 }
コード例 #8
0
ファイル: OpenLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $this->initErrorMessages();
     $this->initSuccessMessages();
     $productId = NGS()->args()->id;
     $products = ProductManager::getInstance()->getProductListFull(['id', '=', $productId]);
     if (!empty($products)) {
         $productSaleQuantity = SaleOrderLineManager::getInstance()->getProductCountInNonCancelledSaleOrders($productId);
         $productPurchaseQuantity = PurchaseOrderLineManager::getInstance()->getProductCountInNonCancelledPurchaseOrders($productId);
         $productQuantity = $productPurchaseQuantity - $productSaleQuantity;
         $product = $products[0];
         $this->addParam('product', $product);
         $this->addParam('productQuantity', $productQuantity);
     }
 }
コード例 #9
0
 public function service()
 {
     if (!isset(NGS()->args()->sale_order_id)) {
         $_SESSION['error_message'] = 'Sale Order ID is missing';
         $this->redirect('sale/list');
     }
     $saleOrderId = intval(NGS()->args()->sale_order_id);
     try {
         SaleOrderLineManager::getInstance()->startTransaction();
         if (isset(NGS()->args()->lines)) {
             $jsonLinesArray = NGS()->args()->lines;
             $linesIdsToNotDelete = [];
             if (!empty($jsonLinesArray)) {
                 foreach ($jsonLinesArray as $jsonLine) {
                     $line = json_decode($jsonLine);
                     if (isset($line->line_id)) {
                         $linesIdsToNotDelete[] = $line->line_id;
                         SaleOrderLineManager::getInstance()->updateSaleOrderLine($saleOrderId, $line->line_id, $line->product_id, $line->quantity, $line->unit_price, $line->currency_id);
                     } else {
                         $newLineId = SaleOrderLineManager::getInstance()->createSaleOrderLine($saleOrderId, $line->product_id, $line->quantity, $line->unit_price, $line->currency_id);
                         $linesIdsToNotDelete[] = $newLineId;
                     }
                 }
             }
             SaleOrderLineManager::getInstance()->deleteWhereIdNotIdIds($saleOrderId, $linesIdsToNotDelete);
         } else {
             SaleOrderLineManager::getInstance()->deleteByField('sale_order_id', $saleOrderId);
         }
         SaleOrderManager::getInstance()->updateAllDependingSaleOrderLines($saleOrderId);
         SaleOrderManager::getInstance()->commitTransaction();
     } catch (InsufficientProductException $exc) {
         SaleOrderManager::getInstance()->rollbackTransaction();
         $product = \crm\managers\ProductManager::getInstance()->selectByPK($exc->getProductId());
         $productInfo = $product->getId();
         if (isset($product)) {
             $productInfo = $product->getName() . " (" . $product->getId() . ")";
         }
         $_SESSION['error_message'] = "Insufficient Product: " . $productInfo;
         $this->redirect('sale/' . $saleOrderId);
     } catch (Exception $exc) {
         SaleOrderManager::getInstance()->rollbackTransaction();
         $_SESSION['error_message'] = $exc->getMessage();
         $this->redirect('sale/' . $saleOrderId);
     }
     $this->redirect('sale/warranty/' . $saleOrderId);
 }
コード例 #10
0
ファイル: SearchListLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $products = [];
     if (!empty($_REQUEST['searchText'])) {
         $searchText = $_REQUEST['searchText'];
         $words = explode(' ', $searchText);
         $whereArray = [];
         foreach ($words as $key => $word) {
             $whereArray[] = 'name';
             $whereArray[] = 'like';
             $whereArray[] = "'%" . $word . "%'";
             if ($key < count($words) - 1) {
                 $whereArray[] = 'AND';
             }
         }
         $products = ProductManager::getInstance()->selectAdvance('*', $whereArray, 'name', 'ASC', 0, 1000);
     }
     $this->addParam('products', $products);
 }
コード例 #11
0
ファイル: UpdateLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $this->initErrorMessages();
     $this->initSuccessMessages();
     $id = intval(NGS()->args()->id);
     $product = ProductManager::getInstance()->selectByPK($id);
     if ($product) {
         $this->addParam('product', $product);
         if (!isset($_SESSION['action_request'])) {
             $_SESSION['action_request'] = ['name' => $product->getName(), 'model' => $product->getModel(), 'manufacturerId' => $product->getManufacturerId(), 'uomId' => $product->getUomId()];
         }
         $this->addParam('req', $_SESSION['action_request']);
         unset($_SESSION['action_request']);
         $this->addParam('uoms', UomManager::getInstance()->selectAdvance('*', [], ['name']));
         $this->addParam('manufacturers', ManufacturerManager::getInstance()->selectAdvance('*', [], ['name']));
         $this->addParam('defaultCurrencyId', SettingManager::getInstance()->getSetting('default_currency_id'));
         $this->addParam('defaultUomId', SettingManager::getInstance()->getSetting('default_uom_id'));
     }
 }
コード例 #12
0
 public function service()
 {
     if (!isset(NGS()->args()->product_id)) {
         new NgsErrorException('Missing Product ID!');
     }
     if (!isset(NGS()->args()->quantity)) {
         new NgsErrorException('Missing Product Quantity!');
     }
     $quantity = floatval(NGS()->args()->quantity);
     $product_id = intval(NGS()->args()->product_id);
     $productDto = ProductManager::getInstance()->selectByPK($product_id);
     if (!isset($productDto)) {
         new NgsErrorException('Product does not exist with given ID: ' . NGS()->args()->product_id);
     }
     $productQuantityInStock = ProductManager::getInstance()->calculateProductQuantityInStock($product_id);
     if ($quantity > $productQuantityInStock) {
         new NgsErrorException('Not sufficient product in stock. There is ' . $productQuantityInStock . ' in stock');
     }
 }
コード例 #13
0
ファイル: ListLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $this->initErrorMessages();
     $this->initSuccessMessages();
     $limit = 100;
     list($offset, $sortByFieldName, $selectedFilterSortByAscDesc) = $this->initFilters($limit);
     $products = ProductManager::getInstance()->getProductListFull([], $sortByFieldName, $selectedFilterSortByAscDesc, $offset, $limit);
     $productIds = ProductManager::getDtosIdsArray($products);
     $productsPurchaseOrder = PurchaseOrderLineManager::getInstance()->getProductsPurchaseOrders($productIds);
     $productsSaleOrder = SaleOrderLineManager::getInstance()->getProductsSaleOrders($productIds);
     $this->addParam('productsPurchaseOrder', $productsPurchaseOrder);
     $this->addParam('productsSaleOrder', $productsSaleOrder);
     $this->addParam('products', $products);
     $count = ProductManager::getInstance()->getLastSelectAdvanceRowsCount();
     if (count($products) == 0 && $count > 0) {
         $this->redirectIncludedParamsExeptPaging();
     }
     $pagesCount = ceil($count / $limit);
     $this->addParam('pagesCount', $pagesCount);
 }
コード例 #14
0
ファイル: ListLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $this->initErrorMessages();
     $this->initSuccessMessages();
     $this->addParam('payment_methods', PaymentMethodManager::getInstance()->selectAdvance('*', ['active', '=', 1], ['name']));
     $this->addParam('partners', PartnerManager::getInstance()->selectAdvance('*', [], ['name']));
     $this->addParam('products', ProductManager::getInstance()->selectAdvance('*', [], ['name']));
     $limit = 100;
     list($where, $offset, $sortByFieldName, $selectedFilterSortByAscDesc) = $this->initFilters($limit);
     $saleOrders = SaleOrderManager::getInstance()->getSaleOrdersFull($where, $sortByFieldName, $selectedFilterSortByAscDesc, $offset, $limit);
     $this->addParam('saleOrders', $saleOrders);
     $count = SaleOrderManager::getInstance()->getLastSelectAdvanceRowsCount();
     if (count($saleOrders) == 0 && $count > 0) {
         $this->redirectIncludedParamsExeptPaging();
     }
     $pagesCount = ceil($count / $limit);
     $this->addParam('pagesCount', $pagesCount);
     $currencyManager = CurrencyManager::getInstance();
     $this->addParam('currencies', $currencyManager->mapDtosById($currencyManager->selectAdvance('*', ['active', '=', 1])));
 }
コード例 #15
0
ファイル: OpenLoad.class.php プロジェクト: pars5555/crm
 public function load()
 {
     $this->initErrorMessages();
     $this->initSuccessMessages();
     $this->addParam('products', ProductManager::getInstance()->selectAdvance('*', [], ['name']));
     $this->addParam('currencies', CurrencyManager::getInstance()->selectAdvance('*', ['active', '=', 1], ['name']));
     $paymentId = NGS()->args()->id;
     $saleOrders = SaleOrderManager::getInstance()->getSaleOrdersFull(['id', '=', $paymentId]);
     if (!empty($saleOrders)) {
         $saleOrder = $saleOrders[0];
         $this->addParam('saleOrder', $saleOrder);
     }
     $polSerialNumbersDtos = [];
     $saleOrderLineIds = $this->getSaleOrderLineIds($saleOrders);
     if (!empty($saleOrderLineIds)) {
         $saleOrderLineIdsSql = '(' . implode(',', $saleOrderLineIds) . ')';
         $polSerialNumbersDtos = SaleOrderLineSerialNumberManager::getInstance()->selectAdvance('*', ['line_id', 'IN', $saleOrderLineIdsSql]);
         $polSerialNumbersDtos = $this->mapDtosByLineId($polSerialNumbersDtos);
     }
     $this->addParam("polSerialNumbersDtos", $polSerialNumbersDtos);
 }
コード例 #16
0
ファイル: ProductManager.class.php プロジェクト: pars5555/crm
 public function updateProductCostForOneUnit($productId)
 {
     $productUnitCostInBaseCurrency = ProductManager::getInstance()->calculateProductCost($productId, 1, 0);
     $productDto = ProductManager::getInstance()->selectByPK($productId);
     $productDto->setUnitCost($this->calculateProductTotalCost($productUnitCostInBaseCurrency));
     ProductManager::getInstance()->updateByPK($productDto);
 }
コード例 #17
0
 public function createPurchaseOrderLine($purchaseOrderId, $productId, $quantity, $unitPrice, $currencyId)
 {
     $dto = $this->createDto();
     $dto->setPurchaseOrderId($purchaseOrderId);
     $dto->setProductId($productId);
     $dto->setQuantity($quantity);
     $dto->setUnitPrice($unitPrice);
     $dto->setCurrencyId($currencyId);
     $orderDate = PurchaseOrderManager::getInstance()->selectByPK($purchaseOrderId)->getOrderDate();
     $rate = CurrencyRateManager::getInstance()->getCurrencyRateByDate($orderDate, $currencyId);
     $dto->setCurrencyRate($rate);
     ProductManager::getInstance()->updateProductCostForOneUnit($productId);
     return $this->insertDto($dto);
 }
コード例 #18
0
 public function getSaleOrderLinesFull($where = [], $orderByFieldsArray = null, $orderByAscDesc = "ASC", $offset = null, $limit = null)
 {
     $rows = $this->selectAdvance('*', $where, $orderByFieldsArray, $orderByAscDesc, $offset, $limit);
     $productIds = array();
     $currencyIds = array();
     foreach ($rows as $row) {
         $productIds[] = $row->getProductId();
         $currencyIds[] = $row->getCurrencyId();
     }
     $productIds = array_unique($productIds);
     $currencyIds = array_unique($currencyIds);
     $productDtos = ProductManager::getInstance()->selectByPKs($productIds, true);
     $currencyDtos = CurrencyManager::getInstance()->selectByPKs($currencyIds, true);
     foreach ($rows as $row) {
         $row->setProductDto($productDtos[$row->getProductId()]);
         $row->setCurrencyDto($currencyDtos[$row->getCurrencyId()]);
     }
     return $rows;
 }