public static function getAllBidbyId($id) { $select = new SelectPDO(); $select->from("bid", ["bid.*", "lot.title", "user.first_name", "user.last_Name"])->where("`bid`.`lot_id` = ?", array($id))->join("lot", "lot_id", "id")->join("user", "user_id", "id"); $data = AbstractModel::getOnComplexQuery($select); return $data; }
/** * this function shows us our all lots * */ public function actionMyLots() { if ($this->request->order == "") { $products = MyProduct::getMyProduct($this->user->id); if (!$products) { $products = []; } $countLots = $this->user->getQuantityLots(); $countBids = $this->user->getQuantityBids(); if ($countLots == "") { $countLots = 0; } if ($countBids == "") { $countBids = 0; } $this->view->lots = $countLots; $this->view->countBids = $countBids; $this->view->user = $this->name; $this->view->products = $products; $this->view->render('mylots'); $this->view->display(); } else { $id = (int) $_POST["order"]; $fields = ["title", "description", "current_price", "id", "front_img", "created"]; $where = "user_id = ? "; $user_id = $this->user->id; $select = new SelectPDO(); $select->from("lot", $fields)->where($where, array($user_id)); switch ($id) { case '0': $select->order("current_price", false); break; case '1': $select->order("current_price", true); break; case '2': $select->order("created"); break; default: $select->order("title"); break; } $data = AbstractModel::getOnComplexQuery($select); $data = json_encode($data); echo $data; exit; $products = MyProduct::getMyProduct($this->user->id); echo json_encode($products); } }