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);
}
