PHP Product::search方法代码示例

 public function index()
 {
     // Check if user has sent a search query
     if ($query = Input::get('query', false)) {
         // Use the Elasticquent search method to search ElasticSearch
         $products = Product::search($query);
     } else {
         // Show all posts if no query is set
         $products = Product::all();
     }
     return View::make('products', compact('products'));
 }

 public function actionLocation()
 {
     $cat = Yii::app()->getRequest()->getQuery('cat');
     $bname = Yii::app()->getRequest()->getQuery('keyword');
     $catname = Category::model()->getCategoryName($cat);
     if ($cat == 'all' || empty($catname)) {
         $query = "SELECT *  \n\t\t\t\t\t\tFROM  `mm_product` \n\t\t\t\t\t\tWHERE  `product_name` LIKE  '" . $bname . "%' \n\t\t\t\t\t\tORDER BY `product_name` LIMIT 10";
     } else {
         $query = "SELECT *  \n\t\t\t\t\tFROM  `mm_product` \n\t\t\t\t\tWHERE  `product_name` LIKE  '%" . $bname . "%'\n\t\t\t\t\tAND\t`product_category_id` IN (SELECT entity_id FROM category WHERE  category_name LIKE '" . $catname . "')";
     }
     $command = Yii::app()->db->createCommand($query);
     $result = $command->queryAll();
     $model = new Product('search');
     $model->unsetAttributes();
     // clear any
     $model->product_name = $bname;
     $model->product_category = $catname;
     //send model object for search
     $this->render('index', array('dataProvider' => $model->search(), 'model' => $model));
     /*
     		$dataProvider=new CArrayDataProvider($result, array(
     					'sort'=>false,
     					'keyField'=>'id', //this is what will be considered your key field
     					'pagination'=>array(
     					'pageSize'=>30, //eureka! you can configure your pagination from here
                     ),
     				
                 ));
     
     		//echo '<pre>'; var_dump($pp); die();
     	
     		$this->render('index',array(
     			'dataProvider'=>$dataProvider,
     		));*/
     //throw new CHttpException(404,'The requested page does not exist.');
 }

include_once "../config/core.php";
// check if logged in as admin
include_once "login_checker.php";
// include classes
include_once '../config/database.php';
include_once '../objects/product.php';
include_once '../objects/product_image.php';
include_once '../objects/product_pdf.php';
include_once '../objects/category.php';
// get database connection
$database = new Database();
$db = $database->getConnection();
// initialize objects
$product = new Product($db);
$product_image = new ProductImage($db);
$product_pdf = new ProductPdf($db);
$category = new Category($db);
// get search term
$search_term = isset($_GET['s']) ? $_GET['s'] : '';
// set page title
$page_title = "Product Search Results";
// include page header HTML
include_once "layout_head.php";
// search products
$stmt = $product->search($search_term, $from_record_num, $records_per_page);
// count retrieved products
$num = $stmt->rowCount();
// include products table HTML template
include_once "read_products_template.php";
// include page footer HTML
include_once "layout_foot.php";

        $_SESSION['limit'] = 7;
        //���������� ��������� �������� ������ �� ���������
        $limit = $_SESSION['limit'];
    } else {
        $_SESSION['limit'] += 7;
        $limit = $_SESSION['limit'];
    }
} else {
    unset($_SESSION['limit']);
    $_SESSION['limit'] = 7;
    //���������� ��������� �������� ������ �� ���������
    $limit = $_SESSION['limit'];
}
require_once 'class.php';
$obj = new Product();
switch ($_POST["form"]) {
    case 'selectId':
        $result = $obj->selectId($_POST['id'], $_POST['category'], $limit);
        echo json_encode($result);
        break;
    case 'search':
        $result = $obj->search($_POST["id"], $_POST["capacity"], $_POST["frame"], $_POST["price"], $_POST["waterproof"], $_POST['category'], $_POST["weight"], $_POST['sort'], $limit);
        echo json_encode($result);
        break;
    case 'moreInfo':
        $result = $obj->moreInfo($_POST["id"]);
        $result[0]['attr'] = unserialize($result[0]['attr']);
        $result[0]['img'] = unserialize($result[0]['img']);
        echo json_encode($result);
        break;
}

             $item->picture = HOST . "includes/webservices/images/" . $filename . "x" . $random . ".jpg";
             $html .= "<tr>";
             $html .= "  <td><img src='" . $item->picture . "' height='40' width='40'/></td>";
             $html .= "  <td>storeid " . $item->storeid . "</td>";
             $html .= "  <td><a class='btn btn-primary' href='updatestorepic.php?id=" . $item->id . "'>Update</a></td>";
             $html .= "  <td><button class='btn btn-danger btndelete'>Delete <span hidden>" . $item->id . "</span></button></td>";
             $html .= "</tr>";
         }
         $filename = 0;
         echo $html;
     } else {
         echo "no data";
     }
 } else {
     if ($_GET['itemtype'] == "product") {
         $items = Product::search($input);
         if (count($items) > 0) {
             foreach ($items as $item) {
                 $filename++;
                 $random = rand(0, 1);
                 file_put_contents("images/" . $filename . "x" . $random . ".jpg", base64_decode($item->picture));
                 $item->picture = HOST . "includes/webservices/images/" . $filename . "x" . $random . ".jpg";
                 $html .= "<tr>";
                 $html .= "  <td><img src='" . $item->picture . "' height='40' width='40'/></td>";
                 $html .= "  <td>storeid " . $item->storeid . "</td>";
                 $html .= "  <td>" . $item->name . "</td>";
                 $html .= "  <td>" . $item->description . "</td>";
                 $html .= "  <td><a class='btn btn-primary' href='updateproduct.php?id=" . $item->id . "'>Update</a></td>";
                 $html .= "  <td><button class='btn btn-danger btndelete'>Delete <span hidden>" . $item->id . "</span></button></td>";
                 $html .= "</tr>";
             }

 * which is then json encoded and returned as a json file response
 */
$result = new stdClass();
$code = 200;
/**
 * Process the search request
 */
if (isset($_POST['form']) && $_POST['form'] == "search") {
    if (isset($_POST['search_term']) && isset($_POST['search_type'])) {
        $search_term = $_POST['search_term'];
        $search_type = $_POST['search_type'];
        $result = "";
        $filters = $_POST['filters'];
        require_once APPLICATION_PATH . MODEL_DIR . '/Product.php';
        $order = new Product('replicated');
        $result = $order->search($search_term, $filters, $search_type);
    }
} elseif (isset($_POST['form']) && $_POST['form'] == "search_by_sku") {
    require_once APPLICATION_PATH . MODEL_DIR . '/Product.php';
    $result = "";
    $item_sku = $_POST['item_sku'];
    $products = new Product('replicated');
    $result = $products->SearchItemsBySku($item_sku);
} elseif (isset($_POST['form']) && $_POST['form'] == "master_products") {
    require_once APPLICATION_PATH . MODEL_DIR . '/Product.php';
    $result = "";
    $products = new Product('replicated');
    $result = $order->getAllMasterProducts();
    header('Content-Type: application/json');
    echo json_encode(array("result" => $result));
} elseif (isset($_POST['form']) && $_POST['form'] == "get_search_history") {

<?php

require_once $libpath = substr(str_replace('\\', '/', __DIR__), 0, -29) . 'library/initialize.php';
if (isset($_POST['keyword'])) {
    $keywords = htmlentities($_POST["keyword"]);
    if ($keywords == "" && !isset($_SESSION["user_id"])) {
        redirect_to(HOME);
    } elseif ($keywords == "" && isset($_SESSION["user_id"])) {
        redirect_to(HOME . "all-products");
    }
    $products = Product::search($keywords);
    if ($products == null) {
        // No results found
        $session->message("Sorry could not find the product");
        redirect_to(HOME);
    }
} else {
    // Probably a GET request
    redirect_to(HOME);
}
global $categories;
include $dir_public . 'search.php';

<?php

// Find all the products
require_once "../../includes/initialize.php";
$str = $_GET['q'];
$products = Product::search($str);
foreach ($products as $product) {
    ?>
        <article class="productInfo"><!-- Each individual product description -->
          <div><img src="../../<?php 
    echo $product->image_path();
    ?>
"/></div>
          <p class="price"><?php 
    echo $product->name;
    ?>
</p>
          <p class="productContent"><?php 
    $cat = Category::find_by_id($product->cat_id);
    echo $cat->get_name();
    ?>
</p>
          <p class="productContent"><?php 
    $user = User::find_by_id($product->userid);
    echo $user->full_name();
    ?>
</p>
		    </article>
<?php 
}

<?php

require_once 'config/config.conf.php';
try {
    $search = Product::search($_GET);
    //echo Utils::debug($search);
    $smarty = new Smarty();
    $tpl_vars = array('pages' => $pages, 'current_page' => $current_page, 'search' => $search);
    $smarty->assign($tpl_vars);
    $smarty->display('search.tpl');
} catch (Exception $e) {
    exit($e->getMessage());
}

 /**
  * Lists all models.
  */
 public function actionIndex()
 {
     $this->layout = "column1";
     $searchModel = new Product('search');
     $dataProvider = new CActiveDataProvider('Product');
     if (isset($_GET['Product'])) {
         $searchModel->attributes = $_GET['Product'];
         $dataProvider = $searchModel->search();
     }
     $this->render('index', array('dataProvider' => $dataProvider, 'searchModel' => $searchModel));
 }

                $products = Product::search($input);
            } else {
                if ($_GET['itemtype'] == "traffic") {
                    $traffics = Traffic::search($input);
                } else {
                    if ($_GET['itemtype'] == "review") {
                        $reviews = Review::search($input);
                    }
                }
            }
        }
    }
} else {
    $users = User::search($input);
    $stores = Store::search($input);
    $products = Product::search($input);
    $traffics = Traffic::search($input);
    $reviews = Review::search($input);
}
$tables = array();
if ($users != null) {
    $table = new Table("users", $users);
    array_push($tables, $table);
}
if ($stores != null) {
    $table = new Table("stores", $stores);
    array_push($tables, $table);
}
if ($products != null) {
    $table = new Table("products", $products);
    array_push($tables, $table);

 public function collection_product_search()
 {
     $keywords = !empty($_GET['keywords']) ? $_GET['keywords'] : '';
     $collection_id = $_GET['collection_id'];
     $products = Product::search(array('limit' => 10, 'offset' => 0, 'where' => 'p.title like \'%' . $keywords . '%\' or p.description like \'%' . $keywords . '%\''));
     if ($products) {
         $output = '<ul>';
         foreach ($products as $product) {
             $output .= '<li id="possible-product-' . $product->id . '"><form id="possible-product-' . $product->id . '-form"><input type="hidden" name="ecommerce_product_collection[collection_id]" value="' . $collection_id . '" /><input type="hidden" name="ecommerce_product_collection[product_id]" value="' . $product->id . '" /></form>';
             $output .= '<a href="#" onclick="collection_product_create(' . $product->id . ');return false;">' . $product->title . '</a></li>';
         }
         $output .= '</ul>';
     } else {
         $output = '<p class="normal">No products matched your search.</p>';
     }
     echo $output;
 }

 /**
  * Displays a particular model's products as a long list.
  * @param str $slug the 'slug' identifier of the model to be displayed
  */
 public function actionList($slug)
 {
     // Retrieve the model via it's slug
     $model_localization = $this->loadLocalizationModelSlug($slug);
     $model = $model_localization->category;
     if (!$model->visible) {
         throw new CHttpException(404, Yii::t('app', 'La page demandée n\'existe pas.'));
     }
     $this->pageTitle = $model_localization->name . " - " . Yii::app()->name;
     $alternatives = array();
     foreach ($model->categoryLocalizations as $localization) {
         $alternatives[$localization->locale_id] = $this->createAbsoluteUrl("view", array("slug" => $localization->slug, "language" => $localization->locale_id));
     }
     $this->alternatives = $alternatives;
     // Generate the subcategories to display in the sidebar.
     // Generate the subcategories to display in the sidebar.
     $children_cache_id = Yii::app()->request->hostInfo . " CategoryController:[children_cats_for_cat] " . $model->id;
     $cache_duration = 300;
     $menu_array = Yii::app()->cache->get($children_cache_id);
     if (!$menu_array) {
         $menu_array = array();
         $children = new Category();
         $children->unsetAttributes();
         $children->visible = 1;
         $children->id = $model->id;
         $category_data_provider = $children->searchChildren();
         foreach ($category_data_provider->getData() as $child) {
             if ($this->isB2b()) {
                 // In a B2B store, we show a list of products so users can select many products at once
                 $menu_array[] = array('label' => $child->categoryLocalization->name, 'url' => array('category/list', "slug" => $child->categoryLocalization->slug));
             } else {
                 $menu_array[] = array('label' => $child->categoryLocalization->name, 'url' => array('category/view', "slug" => $child->categoryLocalization->slug));
             }
         }
         Yii::app()->cache->set($children_cache_id, $menu_array, $cache_duration);
     }
     $this->menu = $menu_array;
     if ($model->parent_category) {
         // This is a subcategory
         // Subcategories must display their products. They must also add their parents categories to the page's breadcrumbs
         // Display breadcrumbs in the right order (home >> root category >> subcategory 1 >> subcatory 2, etc.)
         $this->breadcrumbs = array();
         function appendMotherCatToBreadcrumbs($cat, &$breadarray, $locale)
         {
             $locale_category = CategoryLocalization::model()->find("category_id = :category AND locale_id = :locale", array(":category" => $cat->id, ":locale" => $locale));
             $breadarray[$locale_category->name] = array("category/view", "slug" => $locale_category->slug);
             if ($cat->parent_category) {
                 appendMotherCatToBreadcrumbs($cat->parentCategory, $breadarray, $locale);
             }
         }
         if ($model->parent_category) {
             appendMotherCatToBreadcrumbs($model->parentCategory, $this->breadcrumbs, Yii::app()->language);
             // The array returned is reversed (top category at the end) we need to reverse it.
             $this->breadcrumbs = array_reverse($this->breadcrumbs);
         }
         // We're at the end of the run, just append our name
         $this->breadcrumbs[] = $model_localization->name;
         // Retrieve the order's products (with the correct localization)
         $products_data_provider = null;
         $product = new Product();
         $product->unsetAttributes();
         $product->visible = 1;
         $product->discontinued = 0;
         $product->categoryId = $model->id;
         $product->restrictScopeToCurrentLocale = false;
         if ($model->is_brand) {
             $products_data_provider = $product->searchForBrand($model);
         } else {
             $products_data_provider = $product->search();
         }
         $products_data_provider->setPagination(array('pageSize' => 100));
         $this->render('list', array('model' => $model, 'localization' => $model_localization, 'products' => $products_data_provider));
     } else {
         throw new CHttpException(404, Yii::t('app', 'La page demandée n\'existe pas.'));
     }
 }