public static function loadRating($userId, $photoId) { global $photocontest_ddbb; $sql = "SELECT * FROM " . $photocontest_ddbb->getTable('Rating') . " WHERE " . $photocontest_ddbb->getMapping('Rating', 'userId') . " = " . NP_DDBB::encodeSQLValue($userId, $photocontest_ddbb->getType('Rating', 'userId')) . " AND " . $photocontest_ddbb->getMapping('Rating', 'photoId') . " = " . NP_DDBB::encodeSQLValue($photoId, $photocontest_ddbb->getType('Rating', 'photoId')); $data = $photocontest_ddbb->executePKSelectQuery($sql); if ($data != null) { return new Rating($data); } else { return null; } }
function buildSQL($categoryId = null) { global $sqlProducts, $sqlCategories, $ddbb; $sqlProducts = "SELECT " . $ddbb->getMapping("Item", "id") . " FROM NPS_PRODUCTOS"; if (isset($categoryId)) { if ($categoryId == "all") { $sqlProducts .= " WHERE "; } else { if ($categoryId == "new") { $sqlProducts .= " WHERE " . $ddbb->getMapping("Item", "new") . "=" . NP_DDBB::encodeSQLValue('true', "BOOL") . " AND "; } else { $sqlProducts .= " WHERE " . $ddbb->getMapping("Item", "categoryId") . "=" . NP_DDBB::encodeSQLValue($categoryId, "STRING") . " AND "; } } } else { $sqlProducts .= " WHERE "; } $sqlProducts .= $ddbb->getMapping("Item", "retired") . "=" . NP_DDBB::encodeSQLValue('false', "BOOL") . " ORDER BY " . $ddbb->getMapping("Item", "order"); $sqlCategories = "SELECT * FROM NPS_CATEGORIAS ORDER BY 1"; }
public function delete() { global $photocontest_ddbb; $sql_1 = "DELETE FROM " . $photocontest_ddbb->getTable('Photo') . " WHERE " . $photocontest_ddbb->getMapping('Photo', 'photoId') . " = " . NP_DDBB::encodeSQLValue($this->photoId, $photocontest_ddbb->getType('Photo', 'photoId')); return $photocontest_ddbb->executeDeleteQuery($sql_1) > 0; }
function storeSpecialShippingCost($orderId, $lineNumber) { global $npshop; $sql = "INSERT INTO " . $npshop["ddbb"]["PREFIX"] . "PEDIDOSCOSTES " . " VALUES (" . NP_DDBB::encodeSQLValue($orderId, "INT") . ", " . NP_DDBB::encodeSQLValue($lineNumber, "INT") . ", " . NP_DDBB::encodeSQLValue($this->id, "STRING") . ", " . NP_DDBB::encodeSQLValue($this->quantity, "INT") . ", " . NP_DDBB::encodeSQLValue($this->specialShippingCost, "FLOAT") . ", " . NP_DDBB::encodeSQLValue($this->quantity * $this->specialShippingCost, "FLOAT") . ")"; $ddbb->executeInsertUpdateQuery($sql); }
function __createInsertValuesList($ddbb_mapping, $ddbb_types, $object, $var, $value) { $varNames = array(); $varValues = array(); $pkNames = array(); $object_name = get_class($object); if ($ddbb_mapping === null) { $ddbb_mapping = $this->getMapping($object_name, null); $ddbb_types = $this->getType($object_name, null); foreach (get_object_vars($object) as $var => $value) { if (array_key_exists($var, $ddbb_mapping)) { $data = $this->__createInsertValuesList($ddbb_mapping, $ddbb_types, $object, $var, $value); $varNames = array_merge_recursive($varNames, $data[0]); $varValues = array_merge_recursive($varValues, $data[1]); $pkNames = array_merge_recursive($pkNames, $data[2]); } } } else { if (is_array($ddbb_mapping[$var])) { $iter = is_object($value) ? get_object_vars($value) : $value; foreach ($iter as $objvar => $objvalue) { if (array_key_exists($objvar, $ddbb_mapping[$var])) { $data = $this->__createInsertValuesList($ddbb_mapping[$var], $ddbb_types[$var], $value, $objvar, $objvalue); $varNames = array_merge_recursive($varNames, $data[0]); $varValues = array_merge_recursive($varValues, $data[1]); $pkNames = array_merge_recursive($pkNames, $data[2]); } } } else { if ($value !== null) { $varNames[] = $ddbb_mapping[$var]; $varValues[] = NP_DDBB::encodeSQLValue($value, $ddbb_types[$var]); if (strlen($object_name) > 0 && array_key_exists($object_name, $this->dbSQL) && array_key_exists($var, $this->dbSQL[$object_name]) && array_key_exists("PK", $this->dbSQL[$object_name][$var]) && $this->dbSQL[$object_name][$var]["PK"]) { $pkNames[$var] = $ddbb_mapping[$var]; } } } } return array($varNames, $varValues, $pkNames); }
function _dbUpdate() { global $ddbb; $objectVars = get_object_vars($this); $first = true; $ddbb_mapping = $ddbb->getMapping("User", null); $ddbb_types = $ddbb->getType("User", null); $sql = "UPDATE " . $ddbb->getTable("User") . " SET "; foreach (array_keys($objectVars) as $var) { if (array_key_exists($var, $ddbb_mapping)) { if (is_array($ddbb_mapping[$var])) { foreach (array_keys($ddbb_mapping[$var]) as $subvar) { if (!$first) { $sql .= ", "; } else { $first = false; } //echo $var.$subvar.$ddbb_types["User"][$var][$subvar].$objectVars[$var][$subvar]."-->".encodeSQLValue($objectVars[$var][$subvar], $ddbb_types["User"][$var][$subvar])."<br>"; $sql .= $ddbb_mapping[$var][$subvar] . "=" . NP_DDBB::encodeSQLValue($objectVars[$var][$subvar], $ddbb_types[$var][$subvar]); } } else { if ($var != "id") { if (!$first) { $sql .= ", "; } else { $first = false; } $sql .= $ddbb_mapping[$var] . "=" . NP_DDBB::encodeSQLValue($objectVars[$var], $ddbb_types[$var]); } } } else { //TODO: ERROR } } $sql .= " WHERE " . $ddbb_mapping["id"] . "=" . NP_DDBB::encodeSQLValue($objectVars["id"], $ddbb_types["id"]); $ddbb->executeInsertUpdateQuery($sql); }
public function photoRatings($photoId, $userId = null) { global $photocontest_ddbb; $result = null; if ($userId !== null) { $rating = Rating::loadRating($userId, $photoId); if ($rating != null) { return $rating->rating; } else { return 0; } } else { $sql = "SELECT SUM(r." . $photocontest_ddbb->getMapping('Rating', 'rating') . ") as total_votes, count(*) number_people FROM " . $photocontest_ddbb->getTable("Rating") . " r JOIN " . $photocontest_ddbb->getTable("Photo") . " p ON r.photo_id=p.photo_id WHERE r.photo_id=" . NP_DDBB::encodeSQLValue($photoId, $photocontest_ddbb->getType('Rating', 'photoId')) . " AND p.contest_id=" . NP_DDBB::encodeSQLValue($this->contestId, $photocontest_ddbb->getType('Photo', 'contestId')); $result = $photocontest_ddbb->executePKSelectQuery($sql); if ($result['total_votes'] === null) { $result['total_votes'] = 0; } } return $result; }
function deleteOrder() { global $npshop, $ddbb; foreach ($this->items as $item) { $item->deleteFromOrder($this->orderId); } $sqlShippingCost = "DELETE FROM " . $npshop["ddbb"]["PREFIX"] . "PEDIDOSCOSTES WHERE PED_CO_CODIGO=" . NP_DDBB::encodeSQLValue($this->orderId, $ddbb->getType("Cart", "orderId")); $ddbb->executeDeleteQuery($sqlShippingCost); $sqlOrder = "DELETE FROM " . $ddbb->getTable("Cart") . " WHERE " . $ddbb->getMapping("Cart", "orderId") . "=" . NP_DDBB::encodeSQLValue($this->orderId, $ddbb->getType("Cart", "orderId")); $ddbb->executeDeleteQuery($sqlOrder); }