Ejemplo n.º 1
0
 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;
     }
 }
Ejemplo n.º 2
0
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";
}
Ejemplo n.º 3
0
 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;
 }
Ejemplo n.º 4
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);
 }
Ejemplo n.º 5
0
 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);
 }
Ejemplo n.º 6
0
 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);
 }
Ejemplo n.º 7
0
 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;
 }
Ejemplo n.º 8
0
 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);
 }