예제 #1
0
 /**
  * This function generates and return the rotation by family
  * (This function generate the math of Claculo ABC x Sfam in new_rotation workset Excel Document)
  *
  * @author Erick Guevara Mart�nez
  * @param InventoryRotationCollection $inventory
  * @param ProductCollection $products
  */
 public function generateRotationByFamily(InventoryRotationCollection $inventory, ProductCollection $products)
 {
     // Init a new stock
     $stockByFamily = new FamilyStock();
     // Read all inventory lines to get the family stock rotation
     $inventory->rewind();
     while ($inventory->valid()) {
         $productInventory = $inventory->read();
         $product = $products->getByPK($productInventory->getItemCode());
         // If the product exist in own catalog then constinue
         if ($product instanceof Product && $product->isLine()) {
             // If the family product exist in the stock then get the family line and increment the total sale
             if ($stockByFamily->existIndex(substr($product->getItemCode(), 0, 3))) {
                 $familyLine = $stockByFamily->getByIndex(substr($product->getItemCode(), 0, 3));
                 $familyLine->setTotalSale($familyLine->getTotalSale() + $productInventory->getTVTA());
                 // If the family product not exist in the stock, then create it
             } else {
                 $familyLine = new FamilyLine();
                 $familyLine->setIdFamily(substr($product->getItemCode(), 0, 3))->setTotalSale($productInventory->getTVTA());
             }
             // Add the family line into stock
             $stockByFamily->addStockable($familyLine);
         }
     }
     // Create a ABC classification by sale and return the stock
     return $stockByFamily->ABCClassmentBySale();
 }
 /**
  *
  * @param InventoryRotationCollection $inventory
  * @param KeyMotherStock $stockByKeyMother
  * @param FamilyStock $stockByFamily
  * @param unknown_type $products
  * @param FreightFareCollection $freightFares
  */
 public function generateMinMaxPurchase(InventoryRotationCollection $inventory, KeyMotherStock $stockByKeyMother, FamilyStock $stockByFamily, ProductCollection $products, FreightFareCollection $freightFares)
 {
     // Generates a new min/max purchase list
     $productMinMaxPurchaseList = new ProductMinMaxPurchaseList();
     // Process each products in the inventory
     $inventory->rewind();
     while ($inventory->valid()) {
         // Get the inventory line and product
         $inventoryLine = $inventory->read();
         $product = $products->getByPK($inventoryLine->getItemCode());
         // If the product exist in own catalog and your status is restockable then continue
         if ($product instanceof Product && ($product->isLine() || $product->isHold() && $product->hasRestockRequiredInformation())) {
             // Get the product default freight fare
             $freightFare = $freightFares->getByPkOrElse($product->getDefaultFreightFare(), new FreightFare());
             // Get the correcponging family rotation line
             $familyLine = $stockByFamily->getByIndex(substr($product->getItemCode(), 0, 3));
             // Get the correcesponging key mother rotation line
             $keyMotherLine = $stockByKeyMother->getByIndex($product->getKeyMother());
             // Get ABC Mix
             $abcMix = $this->getABCMix($familyLine, $keyMotherLine);
             // Get the percent min max inventory by abc
             // The min max percent inventory represent the extra inventory to keep (safely stock)
             $percentMinMax = $this->getMinMaxPercentPurchase()->getByPK($abcMix->getIdRestockAbcClass());
             // Generate the min max purchase line for each allowed product
             $productMinMaxPurchase = new ProductMinMaxPurchaseLine();
             // Set the basic data to generate all calcs of VIM excel worksheet ("recompra" document)
             $productMinMaxPurchase->setIdProduct($product->getItemCode())->setABCMix($abcMix->getIdRestockAbcClass())->setManualRestock($product->needManualRestock() ? 1 : 0)->setManualVIM($product->getIndividualVim())->setPercentMax($percentMinMax->getMaxPurchasePercent())->setPercentMin($percentMinMax->getMinPurchasePercent())->setPrice7($inventoryLine->getPRC7())->setReleaseTime(ceil(($product->getLeadTime() + $freightFare->getTt()) / 7));
             // Append the line into list
             $productMinMaxPurchaseList->appendLine($productMinMaxPurchase);
         }
     }
     // Return min max purchase list
     return $productMinMaxPurchaseList;
 }