Ejemplo n.º 1
0
 public function executeDetailed(sfWebRequest $request)
 {
     $this->setLayout('layout_widgets_off');
     # validating input
     if (!$this->getKeyword()) {
         $this->redirect($request->getReferer());
     }
     # find products
     $hits = ProductTable::getLuceneIndex()->find($this->prepareLuceneQuery($this->getKeyword()));
     // searching the index
     $this->products = $this->getSearchResultsQuery($hits, 20)->execute();
     # find news
     $hits = NewItemTable::getLuceneIndex()->find($this->prepareLuceneQuery($this->getKeyword()));
     // searching the index
     $this->news = $this->getNewsSearchResultsQuery($hits, 20)->execute();
     # find structure
     $hits = StructureTable::getLuceneIndex()->find($this->prepareLuceneQuery($this->getKeyword()));
     // searching the index
     $this->nodes = $this->getStructureSearchResultsQuery($hits, 20)->execute();
     # variables for view
     $this->keyword = $this->getKeyword();
 }
 public function executeMerge(sfWebRequest $request)
 {
     $this->producttype = ProducttypeTable::fetch($request->getParameter("producttype_id"));
     $this->producttype_id = $request->getParameter("producttype_id");
     $this->duplicate_ids = $request->getParameter("duplicate_ids");
     $this->duplicateproducts = $this->producttype->getProductsByIds(explode(",", $request->getParameter("duplicate_ids")));
     $this->product = ProductTable::fetch($request->getParameter("product_id"));
     if ($request->getParameter("submit") == "Execute" or $request->getParameter("submit") == "Execute and Delete") {
         foreach ($this->duplicateproducts as $duplicate) {
             //if($product->getId()==1)die();
             foreach ($duplicate->getInvoicedetail() as $detail) {
                 $detail->setProductId($this->product->getId());
                 $detail->save();
             }
             foreach ($duplicate->getPurchasedetail() as $detail) {
                 $detail->setProductId($this->product->getId());
                 $detail->save();
             }
             if ($request->getParameter("submit") == "Execute and Delete") {
                 $duplicate->cascadeDelete();
             }
         }
         $this->redirect("producttype/view?id=" . $this->producttype_id);
     }
 }
Ejemplo n.º 3
0
<?php

include dirname(__FILE__) . '/../../bootstrap/Doctrine.php';
$t = new lime_test(8, new lime_output_color());
$t->diag("ProductTable class tests");
$prodTable = ProductTable::getInstance();
$prod_desc_price = $prodTable->retrieveDescAndPrice(1);
$t->is($prod_desc_price, array('test product 1 description', '179.54'), '->retrieveDescAndPrice(1)');
$t->is($prodTable->getReference(1), 'test product 1', '->getReference(1)');
// the way items are obtained , only relevant values are adquired
$item1 = array('id' => '1', 'quantity' => 7, 'unitary_cost' => '179.54', 'discount' => null, 'common_id' => null, 'product_id' => null, 'description' => null, 'unitary_cost' => 179.54);
$res = $prodTable->getInvoicedItems(1)->toArray();
$res = $res[0];
$t->is(array_diff_assoc($item1, $res), array(), '->getInvoicedItems(1)');
$date_range = array('from' => array('day' => 11, 'month' => 8, 'year' => 2007));
$res = $prodTable->getInvoicedItems(1, $date_range)->toArray();
$res = $res[0];
$t->is(array_diff_assoc($item1, $res), array(), '->getInvoicedItems(1,2007-8-11)');
$date_range['from']['day'] = 12;
$t->is($prodTable->getInvoicedItems(1, $date_range)->toArray(), array(), '->getInvoicedItems(1,2007-8-12)');
$t->diag("Product class tests");
$prod = ProductTable::getInstance()->findOneById(1);
$t->is($prod->getInvoicedQuantity(), 7, '->getInvoicedQuantity()');
$t->is($prod->getInvoicedSold(), 1256.78, '->getInvoicedSold()');
$t->is($prod->getInvoicedQuantity(array('from' => array('month' => 1, 'day' => 1, 'year' => 2008))), 0, '->getInvoicedQuantity(2008-01-01)');