/** * created by Yosin */ public function actionSearch() { $request = new Request(); if ($request->searchGood != "") { $minLength = 2; $select = new SelectPDO(); $select->from("lot", ["lot.*", "user.email", "user.phone"])->join("bid", "id", "lot_id")->join("user", "user_id", "id"); $results = AbstractModel::search($select, ["title", "description"], $request->searchGood, $minLength, false, true); } else { $results = []; } if (!$results) { $results = []; } $this->view->lastGoods = $results; $this->view->render('search'); $this->view->display(); }
public function searchProductWithCategory($request, $category_id) { $minLength = 2; $this->select->from("lot", ["lot.*", "user.first_name", "user.last_Name", "user.phone", "user.email", "category.name"])->where("`lot`.`category_id` = ?", array($category_id))->join("user", "user_id", "id")->join("category", "category_id", "id"); $result = AbstractModel::search($this->select, ['title', 'description'], $request->searchText, $minLength, false, true); return $result; }
/** * search product * * @param $request * @param $id * @return array|bool */ public static function searchProduct($request, $id) { $minLength = 2; $field = $request->field; if ($field == "lot") { $select = new SelectPDO(); $select->from($field, "*")->where("`user_id` = ?", [$id]); $results = AbstractModel::search($select, ["title", "description"], $request->searchText, $minLength = 2, false, true); } else { if ($field == "bid") { $select = new SelectPDO(); $select->from("lot", ["lot.*", "user.email", "user.phone"])->where("`bid`.`user_id` = ?", [$id])->join("bid", "id", "lot_id")->join("user", "user_id", "id"); $results = AbstractModel::search($select, ["title", "description"], $request->searchText, $minLength, false, true); } } return $results; }