mambax7 / xoops-martin

class/auction.php

<?php
/**
 * $Id: auction.php,v 1.42 2007/02/04 15:01:40 malanciault Exp $
 * Module:martin
 * Licence: GNU
 */

if (!defined("XOOPS_ROOT_PATH")) {
    die("XOOPS root path not defined");
}

include_once XOOPS_ROOT_PATH . '/modules/martin/include/common.php';

/**
 * Class MartinAuction
 */
class MartinAuction extends XoopsObject
{
    public function MartinAuction()
    {
        $this->initVar("auction_id", XOBJ_DTYPE_INT, null, false);
        $this->initVar("auction_name", XOBJ_DTYPE_TXTBOX, null, true, 255);
        $this->initVar("auction_info", XOBJ_DTYPE_TXTAREA, null, false);
        $this->initVar("check_in_date", XOBJ_DTYPE_INT, null, false);
        $this->initVar("check_out_date", XOBJ_DTYPE_INT, null, false);
        $this->initVar("apply_start_date", XOBJ_DTYPE_INT, null, false);
        $this->initVar("apply_end_date", XOBJ_DTYPE_INT, null, false);
        $this->initVar("auction_price", XOBJ_DTYPE_INT, null, false);
        $this->initVar("auction_low_price", XOBJ_DTYPE_INT, null, false);
        $this->initVar("auction_add_price", XOBJ_DTYPE_INT, null, false);
        $this->initVar("auction_can_use_coupon", XOBJ_DTYPE_INT, null, false);
        $this->initVar("auction_sented_coupon", XOBJ_DTYPE_INT, null, false);
        $this->initVar("auction_status", XOBJ_DTYPE_INT, null, false);
        $this->initVar("auction_add_time", XOBJ_DTYPE_INT, null, false);
    }

    /**
     * @return mixed
     */
    public function auction_id()
    {
        return $this->getVar("auction_id");
    }

    /**
     * @param string $format
     * @return mixed
     */
    public function auction_name($format = 'S')
    {
        return $this->getVar("auction_name", $format);
    }

    /**
     * @param string $format
     * @return mixed
     */
    public function auction_info($format = 'edit')
    {
        return $this->getVar("auction_info", $format);
    }

    /**
     * @return mixed
     */
    public function check_in_date()
    {
        return $this->getVar("check_in_date");
    }

    /**
     * @return mixed
     */
    public function check_out_date()
    {
        return $this->getVar("check_out_date");
    }

    /**
     * @return mixed
     */
    public function apply_start_date()
    {
        return $this->getVar("apply_start_date");
    }

    /**
     * @return mixed
     */
    public function apply_end_date()
    {
        return $this->getVar("apply_end_date");
    }

    /**
     * @return mixed
     */
    public function auction_price()
    {
        return $this->getVar("auction_price");
    }

    /**
     * @return mixed
     */
    public function auction_low_price()
    {
        return $this->getVar("auction_low_price");
    }

    /**
     * @return mixed
     */
    public function auction_add_price()
    {
        return $this->getVar("auction_add_price");
    }

    /**
     * @return mixed
     */
    public function auction_can_use_coupon()
    {
        return $this->getVar("auction_can_use_coupon");
    }

    /**
     * @return mixed
     */
    public function auction_sented_coupon()
    {
        return $this->getVar("auction_sented_coupon");
    }

    /**
     * @return mixed
     */
    public function auction_status()
    {
        return $this->getVar("auction_status");
    }

    /**
     * @return mixed
     */
    public function auction_add_time()
    {
        return $this->getVar("auction_add_time");
    }
}

/**
 * @method: auctionHandler
 * @license   http://www.blags.org/
 * @created   :2010年05月21日 20时40分
 * @copyright 1997-2010 The Martin auction
 * @author    Martin <china.codehome@gmail.com>
 * */
class MartinAuctionHandler extends XoopsObjectHandler
{
    /**
     * create a new hotel city
     * @param bool $isNew flag the new objects as "new"?
     * @return object auction
     */
    public function &create($isNew = true)
    {
        $auction = new MartinAuction();
        if ($isNew) {
            $auction->setNew();
        }

        return $auction;
    }

    /**
     * retrieve a hotel city
     *
     * @param int $id auctionid of the auction
     * @return mixed reference to the {@link auction} object, FALSE if failed
     */
    public function &get($id)
    {
        if ((int)($id) <= 0) {
            return false;
        }

        $criteria = new CriteriaCompo(new Criteria('auction_id', $id));
        $criteria->setLimit(1);
        $obj_array = $this->getObjects($criteria);
        if (count($obj_array) != 1) {
            $obj =& $this->create();

            return $obj;
        }

        return $obj_array[0];
    }

    /**
     * @get       rows
     * @license   http://www.blags.org/
     * @created   :2010年06月20日 13时09分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param      $sql
     * @param null $key
     * @return array
     */
    public function GetRows($sql, $key = null)
    {
        global $xoopsDB;
        $result = $xoopsDB->query($sql);
        $rows   = array();
        while ($row = $xoopsDB->fetchArray($result)) {
            if (is_null($key)) {
                $rows[] = $row;
            } else {
                $rows[$row[$key]] = $row;
            }
        }

        return $rows;
    }

    /**
     * @得到列表
     * @method:
     * @license   http://www.blags.org/
     * @created   :2010年05月23日 14时59分
     * @copyright 1997-2010 The Martin auction
     * @author    Martin <china.codehome@gmail.com>
     * @param int    $limit
     * @param int    $start
     * @param string $sort
     * @param string $order
     * @param bool   $id_as_key
     * @return array
     */
    public function &getAuctions($limit = 0, $start = 0, $sort = 'auction_add_time', $order = 'DESC', $id_as_key = true)
    {
        $criteria = new CriteriaCompo();

        $criteria->setSort($sort);
        $criteria->setOrder($order);

        $criteria->setStart($start);
        $criteria->setLimit($limit);

        return $this->getObjects($criteria, $id_as_key);
    }

    /**
     * insert a new auction in the database
     *
     * @param object $auction reference to the {@link auction} object
     * @param bool   $force
     * @return bool FALSE if failed, TRUE if already present and unchanged or successful
     */
    public function insert(&$auction, $force = false)
    {
        if (strtolower(get_class($auction)) !== 'martinauction') {
            return false;
        }

        if (!$auction->cleanVars()) {
            return false;
        }

        foreach ($auction->cleanVars as $k => $v) {
            ${$k} = $v;
        }

        if ($auction->isNew()) {
            $sql = sprintf("INSERT INTO %s (
                                auction_id,
                                auction_name,
                                auction_info,
                                check_in_date,
                                check_out_date,
                                apply_start_date,
                                apply_end_date,
                                auction_price,
                                auction_low_price,
                                auction_add_price,
                                auction_can_use_coupon,
                                auction_sented_coupon,
                                auction_status,
                                auction_add_time
                            ) VALUES (
                                NULL,
                                %s,%s,%u,%u,%u,%u,%u,%u,%u,%u,%u,%u,%u
                            )", $this->db->prefix('martin_auction'), $this->db->quoteString($auction_name), $this->db->quoteString($auction_info), $check_in_date, $check_out_date, $apply_start_date, $apply_end_date, $auction_price, $auction_low_price, $auction_add_price, $auction_can_use_coupon, $auction_sented_coupon, $auction_status, $auction_add_time);
        } else {
            $sql = sprintf("UPDATE %s SET
                                auction_name = %s,
                                auction_info = %s,
                                check_in_date = %u,
                                check_out_date = %u,
                                apply_start_date = %u,
                                apply_end_date = %u,
                                auction_price = %u,
                                auction_low_price = %u,
                                auction_add_price = %u,
                                auction_can_use_coupon = %u,
                                auction_sented_coupon = %u,
                                auction_status = %u
                            WHERE auction_id = %u", $this->db->prefix('martin_auction'), $this->db->quoteString($auction_name), $this->db->quoteString($auction_info), $check_in_date, $check_out_date, $apply_start_date, $apply_end_date, $auction_price, $auction_low_price, $auction_add_price, $auction_can_use_coupon, $auction_sented_coupon, $auction_status, $auction_id);
        }
        //echo $sql;exit;
        if (false != $force) {

It seems like you are loosely comparing two booleans. Considering using the strict comparison !== instead.

            $result = $this->db->queryF($sql);
        } else {
            $result = $this->db->query($sql);
        }

        return $auction_id > 0 ? $auction_id : $this->db->getInsertId();
    }

    /**
     * @删除一个城市
     * @method:delete(auction_id)
     * @license   http://www.blags.org/
     * @created   :2010年05月21日 20时40分
     * @copyright 1997-2010 The Martin auction
     * @author    Martin <china.codehome@gmail.com>
     * @param object $auction
     * @param bool   $force
     * @return bool|void
     */
    public function delete(&$auction, $force = false)
    {
        if (strtolower(get_class($auction)) !== 'martinauction') {
            return false;
        }

        $sql = "DELETE FROM " . $this->db->prefix("martin_auction") . " WHERE auction_id = " . $auction->auction_id();

        if (false != $force) {

It seems like you are loosely comparing two booleans. Considering using the strict comparison !== instead.

            $result = $this->db->queryF($sql);
        } else {
            $result = $this->db->query($sql);
        }

        $sql = "DELETE FROM " . $this->db->prefix("martin_auction_room") . " WHERE auction_id = " . $auction->auction_id();

        if (false != $force) {

It seems like you are loosely comparing two booleans. Considering using the strict comparison !== instead.

            $result = $this->db->queryF($sql);
        } else {
            $result = $this->db->query($sql);
        }

        if (!$result) {
            return false;
        }

        return true;
    }

    /**
     * delete hotel cities matching a set of conditions
     *
     * @param object $criteria {@link CriteriaElement}
     * @return bool FALSE if deletion failed
     */
    public function deleteAll($criteria = null)
    {
        $sql = 'DELETE FROM ' . $this->db->prefix('martin_auction');
        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
            $sql .= ' ' . $criteria->renderWhere();
        }
        if (!$result = $this->db->query($sql)) {
            return false;
        }

        return true;
    }

    /**
     * count hotel cities matching a condition
     *
     * @param object $criteria {@link CriteriaElement} to match
     * @return int count of categories
     */
    public function getCount($criteria = null)
    {
        $sql = 'SELECT COUNT(*) FROM ' . $this->db->prefix('martin_auction');
        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
            $sql .= ' ' . $criteria->renderWhere();
        }
        $result = $this->db->query($sql);
        if (!$result) {
            return 0;
        }
        list($count) = $this->db->fetchRow($result);

        return $count;
    }

    /**
     * @得到城市
     * @license   http://www.blags.org/
     * @created   :2010年05月21日 20时40分
     * @copyright 1997-2010 The Martin auction
     * @author    Martin <china.codehome@gmail.com>
     * @param null $criteria
     * @param bool $id_as_key
     * @return array
     */
    public function &getObjects($criteria = null, $id_as_key = false)
    {
        $ret   = array();
        $limit = $start = 0;
        $sql   = 'SELECT * FROM ' . $this->db->prefix('martin_auction');
        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
            $sql .= ' ' . $criteria->renderWhere();
            if ($criteria->getSort() != '') {
                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
            }
            $limit = $criteria->getLimit();
            $start = $criteria->getStart();
        }
        $sql .= " order by  apply_start_date DESC , auction_id DESC ";
        //echo "<br />" . $sql . "<br />";
        $result = $this->db->query($sql, $limit, $start);

        if (!$result) {
            return $ret;
        }

        $theObjects = array();

        while ($myrow = $this->db->fetchArray($result)) {
            $auction = new MartinAuction();
            $auction->assignVars($myrow);
            $theObjects[$myrow['auction_id']] =& $auction;
            //var_dump($auction);
            unset($auction);
        }
        //var_dump($theObjects);

        foreach ($theObjects as $theObject) {
            if (!$id_as_key) {
                $ret[] =& $theObject;
            } else {
                $ret[$theObject->auction_id()] =& $theObject;
            }
            unset($theObject);
        }

        return $ret;
    }

    /**
     * @get       room list
     * @license   http://www.blags.org/
     * @created   :2010年06月03日 20时05分
     * @copyright 1997-2010 The Martin auction
     * @author    Martin <china.codehome@gmail.com>
     * @param $auction_id
     * @return array|bool
     */
    public function getRoomList($auction_id)
    {
        global $xoopsDB;
        if (empty($auction_id)) {
            return false;
        }
        $sql    = "SELECT gr.room_id,gr.room_count,r.room_name FROM " . $xoopsDB->prefix("martin_auction_room") . " gr
            left join " . $xoopsDB->prefix("martin_room") . " r ON r.room_id = gr.room_id
            WHERE auction_id = " . $auction_id;
        $result = $xoopsDB->query($sql);
        $rows   = array();
        while ($row = $xoopsDB->fetchArray($result)) {
            $rows[] = $row;
        }

        return $rows;
    }

    /**
     * @param $auction_id
     * @param $room_ids
     * @param $room_counts
     * @param $isNew
     * @return bool
     */
    public function InsertAuctionRoom($auction_id, $room_ids, $room_counts, $isNew)
    {
        global $xoopsDB;
        if (!$auction_id || !is_array($room_ids)) {
            // delete data
            $sql = "delete FROM " . $xoopsDB->prefix("martin_auction") . " WHERE auction_id = " . $auction_id;
            if ($auction_id > 0) {
                $xoopsDB->query($sql);
            }

            return false;
        }
        $dsql = 'delete FROM ' . $xoopsDB->prefix("martin_auction_room") . " WHERE auction_id = $auction_id";
        $xoopsDB->query($dsql);

        $sql = "insert INTO " . $xoopsDB->prefix("martin_auction_room") . " (auction_id,room_id,room_count) VALUES ";
        foreach ($room_ids as $key => $room_id) {
            $room_count = $room_counts[$key];
            $sql .= $prefix . "($auction_id,$room_id,$room_count)";
            $prefix = ",";
        }

        //echo $sql;
        return $xoopsDB->query($sql);
    }

    /**
     * @get       room by hotel
     * @license   http://www.blags.org/
     * @created   :2010年06月03日 20时05分
     * @copyright 1997-2010 The Martin auction
     * @author    Martin <china.codehome@gmail.com>
     * @param $hotel_id
     * @return array
     */
    public function GetRoomListByHotel($hotel_id)
    {
        global $xoopsDB;
        $sql = "SELECT room_id,room_name FROM " . $xoopsDB->prefix("martin_auction");
        $sql .= $hotel_id > 0 ? " WHERE hotel_id = " . $hotel_id : " ";
        $result = $xoopsDB->query($sql);
        $rows   = array();
        while ($row = $xoopsDB->fetchArray($result)) {
            $rows[$row['room_id']] = $row['room_name'];
        }

        return $rows;
    }

    /**
     * @get       top aution list
     * @license   http://www.blags.org/
     * @created   :2010年06月20日 13时09分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param int $limit
     * @return array
     */
    public function GetAuctionList($limit = 6)
    {
        global $xoopsDB;
        $sql = 'SELECT * FROM ' . $xoopsDB->prefix('martin_auction') . ' WHERE auction_status = 1 AND apply_end_date > ' . time() . ' order by apply_end_date , auction_id DESC limit ' . $limit;

        return $this->GetRows($sql);
    }

    /**
     * @get       Auction rooms
     * @license   http://www.blags.org/
     * @created   :2010年06月20日 13时09分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param $auction_id
     * @return array
     */
    public function GetAuctionRooms($auction_id)
    {
        global $xoopsDB;
        if (!$auction_id) {
            return $auction_id;
        }
        $sql = 'SELECT a.*,r.*,rt.room_type_info,h.* FROM ' . $xoopsDB->prefix("martin_auction_room") . ' a ';
        $sql .= ' INNER JOIN ' . $xoopsDB->prefix('martin_room') . ' r ON ( r.room_id = a.room_id ) ';
        $sql .= ' INNER JOIN ' . $xoopsDB->prefix('martin_room_type') . ' rt ON ( r.room_type_id = rt.room_type_id ) ';
        $sql .= ' INNER JOIN ' . $xoopsDB->prefix('martin_hotel') . ' h ON ( r.hotel_id = h.hotel_id ) ';
        $sql .= ' WHERE a.auction_id = ' . $auction_id;

        //echo $sql;
        return $this->GetRows($sql);
    }

    /**
     * @add       user auction bid
     * @license   http://www.blags.org/
     * @created   :2010年06月21日 21时40分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param $Data
     * @return
     */
    public function AddUserAuction($Data)
    {
        global $xoopsDB;
        if (!is_array($Data) || empty($Data)) {
            return $Data;
        }
        $sql = 'INSERT INTO ' . $xoopsDB->prefix('martin_auction_bid') . ' (%s) VALUES (%s) ';
        foreach ($Data as $key => $value) {
            $keys .= $prefix . $key;
            $values .= $prefix . $value;
            $prefix = ',';
        }
        $sql = sprintf($sql, $keys, $values);
        //echo $sql;
        $xoopsDB->query($sql);

        return $xoopsDB->getInsertId();
    }

    /**
     * @get       auction bid list
     * @method:
     * @license   http://www.blags.org/
     * @created   :2010年06月21日 21时40分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param $auction_id
     * @return array|bool
     */
    public function getAuctionBidList($auction_id)
    {
        if (!$auction_id) {
            return false;
        }
        global $xoopsDB;
        $sql = 'SELECT b.*,u.uname FROM ' . $xoopsDB->prefix('martin_auction_bid') . ' b ';
        $sql .= 'INNER JOIN ' . $xoopsDB->prefix('users') . ' u ON (u.uid = b.uid) ';
        $sql .= 'WHERE b.auction_id = ' . $auction_id . ' ';
        $sql .= 'ORDER BY b.bid_price DESC , b.bid_id DESC ';

        return $this->GetRows($sql);
    }
}