public function findById($wishListId) { $where = []; $where['sql'] = 'WHERE fk_wish_list_product_version_wish_list = ?'; $where['datatypes'] = 'i'; $where['values'] = [$wishListId]; $join = []; $join['product_version'] = ['fk_product_version_base_product', 'base_product_id']; $join['wish_list_product_version'] = ['fk_wish_list_product_version_product_version', 'product_version_id']; $join['wish_list'] = ['fk_wish_list_product_version_wish_list', 'wish_list_id']; require_once '../app/models/Product.php'; $wishList = Product::findProducts($where, $join); if (count($wishList) == 0) { $sql = 'SELECT * FROM wish_list WHERE wish_list_id = ?'; $datatypes = 'i'; $params = [$wishListId]; $wishListInfo = Model::buildAndRunPreparedStatement($sql, $datatypes, $params); $wishListInfo = Model::createResultsArray($wishListInfo); $wishList['listInfo'] = $wishListInfo[0]; } return $wishList; }
public function addToJoinTable($propertiesList, $table) { if (isset($this->id)) { $datatypes = ''; $params = []; $sql = 'INSERT INTO ' . $table . ' (fk_' . $table . '_' . get_class($this) . ', '; foreach (array_keys($propertiesList[0]) as $colName) { $sql .= $this->toCamelCase($colName) . ", "; } $sql = substr($sql, 0, -2) . ") VALUES "; foreach ($propertiesList as $key => $value) { $sql .= "(?, "; $datatypes .= 's'; $params[] = $this->id; foreach ($value as $colValue) { $sql .= "?, "; $datatypes .= 's'; $params[] = $colValue; } $sql = substr($sql, 0, -2) . "), "; } $sql = substr($sql, 0, -2); #echo $sql;die; Model::buildAndRunPreparedStatement($sql, $datatypes, $params); } }
public function findProductVersions($baseProductId) { $sql = "SELECT product_version_id, platform, product_price FROM product_version " . "JOIN base_product on fk_product_version_base_product = base_product_id " . "WHERE base_product_id = ?"; $datatypes = 'i'; $params = [$baseProductId]; $results = Model::buildAndRunPreparedStatement($sql, $datatypes, $params); return Model::createResultsArray($results); }