mambax7 / xoops-martin

class/order.php

<?php
/**
 * $Id: order.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 MartinOrder
 */
class MartinOrder extends XoopsObject
{
    public function MartinOrder()
    {
        $this->initVar("order_id", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_type", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_mode", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_uid", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_pay_method", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_pay", XOBJ_DTYPE_TXTBOX, null, true, 25);
        $this->initVar("order_status", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_total_price", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_pay_money", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_coupon", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_sented_coupon", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_real_name", XOBJ_DTYPE_TXTBOX, null, true, 45);
        $this->initVar("order_document_type", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_document", XOBJ_DTYPE_TXTBOX, null, true, 255);
        $this->initVar("order_telephone", XOBJ_DTYPE_TXTBOX, null, true, 45);
        $this->initVar("order_phone", XOBJ_DTYPE_TXTBOX, null, true, 45);
        $this->initVar("order_extra_persons", XOBJ_DTYPE_TXTAREA, null, false);
        $this->initVar("order_note", XOBJ_DTYPE_TXTAREA, null, false);
        $this->initVar("order_status_time", XOBJ_DTYPE_INT, null, false);
        $this->initVar("order_submit_time", XOBJ_DTYPE_INT, null, false);
        //room

        //users 
        $this->initVar("uname", XOBJ_DTYPE_TXTBOX, null, true, 255);
        $this->initVar("email", XOBJ_DTYPE_TXTBOX, null, true, 255);
    }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    //rooms 

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

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

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

        return $order;
    }

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

        $criteria = new CriteriaCompo(new Criteria('order_id', $id));
        $criteria->setLimit(1);
        $obj_array = $this->getObjects('', $criteria);

        if (count($obj_array) != 1) {
            $obj =& $this->create();

            return $obj;
        }

        //var_dump($obj_array);
        //get order roooms
        $obj_array[0]->rooms  = $this->GetOrderRooms($id);
        $obj_array[0]->qrooms = $this->GetOrderQueryRooms($id);
        //not query room 
        //$obj_array[0]->rooms = empty($obj_array[0]->rooms) ? $this->GetOrderRooms($id) : $obj_array[0]->rooms;

        return $obj_array[0];
    }

    /**
     * @得到列表
     * @license   http://www.blags.org/
     * @created   :2010年05月23日 14时59分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param        $Data
     * @param int    $limit
     * @param int    $start
     * @param string $sort
     * @param string $order
     * @param bool   $id_as_key
     * @return array
     */
    public function &getOrders($Data, $limit = 0, $start = 0, $sort = 'order_id', $order = 'ASC', $id_as_key = true)

This method seems to be duplicated in your project.

    {
        $criteria = new CriteriaCompo();

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

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

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

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

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

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

        if ($order->isNew()) {

This code seems to be duplicated across your project.

            $sql = sprintf("INSERT INTO %s (
                                order_type_id,
                                order_type_name
                            ) VALUES (
                                NULL,
                                %s
                            )", $this->db->prefix('martin_hotel_order_type'), $this->db->quoteString($order_type_name));

The variable $order_type_name does not exist. Did you forget to declare it?

        } else {
            $sql = sprintf("UPDATE %s SET
                                order_type_name = %s
                            WHERE order_type_id = %u", $this->db->prefix('martin_hotel_order_type'), $this->db->quoteString($order_type_name), $order_type_id);

The variable $order_type_id does not exist. Did you forget to declare it?

        }
        //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);
        }
        if (!$result) {
            $order->setErrors('The query returned an error. ' . $this->db->error());

            return false;
        }

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

The variable $order_id does not exist. Did you forget to declare it?

    }

    /**
     * @ update order
     * @license   http://www.blags.org/
     * @created   :2010年06月09日 21时46分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param $OrderObj
     * @param $room_id
     * @return bool
     */
    public function updateOrder(&$OrderObj, $room_id)
    {
        $sql = 'UPDATE ' . $this->db->prefix("martin_order") . ' set order_status = ' . $OrderObj->order_status() . ' WHERE order_id = ' . $OrderObj->order_id();
        //echo $sql;exit;
        //update Status
        $result = true;
        if (!$this->db->queryF($sql)) {
            $result = false;
        }
        //update room price 

        if (is_array($room_id)) {
            foreach ($room_id as $key => $room_price) {
                list($id, $room_date) = explode('-', $key);
                $sql = 'UPDATE ' . $this->db->prefix("martin_order_query_room") . ' set room_price = ' . $room_price . ' WHERE order_id = ' . $OrderObj->order_id() . " AND room_id = $id AND room_date = $room_date";
                if (!$this->db->queryF($sql)) {
                    $result = false;
                }
            }
        }

        return $result;
    }

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

        global $xoopsDB;
        //delete order room relation
        $sql = "DELETE FROM " . $xoopsDB->prefix("martin_order_room") . " WHERE order_id = " . $order->order_id();
        $xoopsDB->queryF($sql);
        //delete order query room relation
        $sql = "DELETE FROM " . $xoopsDB->prefix("martin_order_query_room") . " WHERE order_id = " . $order->order_id();
        $xoopsDB->queryF($sql);
        //delete order service
        $sql = "DELETE FROM " . $xoopsDB->prefix("martin_order_service") . " WHERE order_id = " . $order->order_id();
        $xoopsDB->queryF($sql);

        $sql = "DELETE FROM " . $xoopsDB->prefix("martin_order") . " WHERE order_id = " . $order->order_id();

        if (false != $force) {

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

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

        if (!$result) {
            return false;
        }

        return true;
    }

    /**
     * delete hotel cities matching a set of conditions
     *
     * @param object $criteria {@link CriteriaElement}

Should the type for parameter $criteria not be object|null?

     * @return bool FALSE if deletion failed
     */
    public function deleteAll($criteria = null)

This method seems to be duplicated in your project.

    {
        $sql = 'DELETE FROM ' . $this->db->prefix('martin_order');
        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {

Due to PHP Bug #53727, is_subclass_of returns inconsistent results on some PHP versions for interfaces; you could instead use ReflectionClass::implementsInterface.

            $sql .= ' ' . $criteria->renderWhere();
        }
        if (!$result = $this->db->query($sql)) {
            return false;
        }

        return true;
    }

    /**
     * count hotel cities matching a condition
     *
     * @param $Data
     * @return int count of categories
     * @internal param object $criteria <a href='psi_element://CriteriaElement'>CriteriaElement</a> to match to match
     */
    public function getCount($Data)
    {
        if (is_array($Data)) {
            foreach ($Data as $key => $value) {
                ${$key} = (int)($value);
            }
        }
        $sql = 'SELECT COUNT(*) FROM ' . $this->db->prefix('martin_order') . " WHERE 1 = 1 ";
        $sql .= $order_mode > 0 ? "AND order_mode = $order_mode " : " ";

The variable $order_mode does not exist. Did you forget to declare it?

        $sql .= $order_pay_method > 0 ? "AND order_pay_method = $order_pay_method " : " ";

The variable $order_pay_method does not exist. Did you forget to declare it?

        $sql .= $order_status > 0 ? "AND order_status = $order_status " : " ";

The variable $order_status does not exist. Did you forget to declare it?

        $sql .= $order_type > 0 ? "AND order_type = $order_type " : " ";

The variable $order_type does not exist. Did you forget to declare it?

        $sql .= $hotel_id > 0 ? "AND  order_id IN (

The variable $hotel_id does not exist. Did you forget to declare it?

                SELECT order_id FROM " . $this->db->prefix('martin_order_room') . " WHERE room_id IN (
                SELECT room_id FROM " . $this->db->prefix("martin_room") . " WHERE hotel_id = $hotel_id
                )) " : " ";
        //echo $sql;
        $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 Group
     * @author    Martin <china.codehome@gmail.com>
     * @param      $Data
     * @param null $criteria
     * @param bool $id_as_key
     * @return array
     */
    public function &getObjects($Data, $criteria = null, $id_as_key = false)
    {
        if (is_array($Data)) {
            foreach ($Data as $key => $value) {
                ${$key} = (int)($value);
            }
        }

        $ret   = array();
        $limit = $start = 0;
        $sql   = 'SELECT o.*,u.* FROM ' . $this->db->prefix('martin_order') . ' o ';
        $sql .= 'LEFT JOIN ' . $this->db->prefix('users') . ' u ON ( o.order_uid = u.uid ) ';
        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement') && empty($Data)) {

Due to PHP Bug #53727, is_subclass_of returns inconsistent results on some PHP versions for interfaces; you could instead use ReflectionClass::implementsInterface.

            $sql .= ' ' . $criteria->renderWhere();
            /*if ($criteria->getSort() != '') {
                $sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder();
            }*/
            $limit = $criteria->getLimit();
            $start = $criteria->getStart();
        }
        $sql .= $Data ? ' WHERE 1 = 1 ' : " ";
        $sql .= $order_mode > 0 ? "AND order_mode = $order_mode " : " ";

The variable $order_mode does not exist. Did you forget to declare it?

        $sql .= $order_pay_method > 0 ? "AND order_pay_method = $order_pay_method " : " ";

The variable $order_pay_method does not exist. Did you forget to declare it?

        $sql .= $order_status > 0 ? "AND order_status = $order_status " : " ";

The variable $order_status does not exist. Did you forget to declare it?

        $sql .= $order_type > 0 ? "AND order_type = $order_type " : " ";

The variable $order_type does not exist. Did you forget to declare it?

        $sql .= $hotel_id > 0 ? "AND  o.order_id IN (

The variable $hotel_id does not exist. Did you forget to declare it?

                SELECT order_id FROM " . $this->db->prefix('martin_order_room') . " WHERE room_id IN (
                SELECT room_id FROM " . $this->db->prefix("martin_room") . " WHERE hotel_id = $hotel_id
                )) " : " ";
        $sql .= " ORDER BY o.order_status ASC , o.order_submit_time DESC ";
        //echo $sql;exit;

        $result = $this->db->query($sql, $limit, $start);

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

        $theObjects = array();

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

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

        //var_dump($ret);
        return $ret;
    }

    /**
     * @get       order rooms
     * @method:
     * @license   http://www.blags.org/
     * @created   :2010年06月07日 20时25分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param $order_id
     * @return array
     */
    public function GetOrderRooms($order_id)

This method seems to be duplicated in your project.

    {
        if (!$order_id) {
            return $order_id;
        }
        global $xoopsDB;
        $sql = "SELECT mor.room_id , mor.room_count ,mor.room_date , r.room_name , h.hotel_id , 
            rp.room_is_today_special,rp.room_price,rp.room_advisory_range_small,rp.room_advisory_range_max ,
            h.hotel_name,hotel_city_id ";
        $sql .= "FROM " . $xoopsDB->prefix("martin_order_room") . " mor ";

        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_room") . " r ON ( r.room_id = mor.room_id ) ";
        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_room_price") . " rp ON ( r.room_id = rp.room_id AND mor.room_date = rp.room_date ) ";
        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_hotel") . " h ON ( r.hotel_id = h.hotel_id ) ";
        $sql .= " WHERE 1 = 1 ";
        $sql .= $order_id > 0 ? " AND mor.order_id = $order_id " : " ";
        $sql .= " Group by mor.room_date order by mor.room_id DESC ";
        //echo '<pre>'.$sql;exit;
        $result = $xoopsDB->query($sql);
        $rows   = array();
        while ($row = $xoopsDB->fetchArray($result)) {
            $rows[] = $row;
        }

        return $rows;
    }

    /**
     * @get       order query rooms
     * @method:
     * @license   http://www.blags.org/
     * @created   :2010年06月07日 20时25分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param $order_id
     * @return array
     */
    public function GetOrderQueryRooms($order_id)

This method seems to be duplicated in your project.

    {
        if (!$order_id) {
            return $order_id;
        }
        global $xoopsDB;
        $sql = "SELECT mor.room_id , mor.room_count ,mor.room_date , mor.room_price , r.* , 
            rp.room_is_today_special,rp.room_advisory_range_small,rp.room_advisory_range_max ,
            h.hotel_name,hotel_city_id ";
        $sql .= "FROM " . $xoopsDB->prefix("martin_order_query_room") . " mor ";

        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_room") . " r ON ( r.room_id = mor.room_id ) ";
        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_room_price") . " rp ON ( r.room_id = rp.room_id AND mor.room_date = rp.room_date ) ";
        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_hotel") . " h ON ( r.hotel_id = h.hotel_id ) ";
        $sql .= " WHERE 1 = 1 ";
        $sql .= $order_id > 0 ? " AND mor.order_id = $order_id " : " ";
        $sql .= " Group by mor.room_date order by mor.room_id DESC ";
        //echo '<pre>'.$sql;exit;
        $result = $xoopsDB->query($sql);
        $rows   = array();
        while ($row = $xoopsDB->fetchArray($result)) {
            $rows[] = $row;
        }

        return $rows;
    }

    /**
     * @得到类别列表
     * @license   http://www.blags.org/
     * @created   :2010年05月30日 20时48分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * */
    public function GetList()

This method seems to be duplicated in your project.

    {
        $sql    = "SELECT * FROM " . $this->db->prefix("martin_order");
        $result = $this->db->query($sql);
        $rows   = array();
        while ($row = $this->db->fetchArray($result)) {
            $rows[$row['order_id']] = $row;
        }

        return $rows;
    }

    /**
     * @get       hotel list
     * @license   http://www.blags.org/
     * @created   :2010年06月10日 21时25分
     * @copyright 1997-2010 The Martin Group
     * @author    Martin <china.codehome@gmail.com>
     * @param $hotel_city_id
     * @param $hotel_star
     * @return array
     */
    public function GetSearchHotelList($hotel_city_id, $hotel_star)
    {
        global $xoopsDB;
        $sql = "select hotel_id ,hotel_name FROM {$xoopsDB->prefix('martin_hotel')} WHERE 1 = 1 ";
        $sql .= $hotel_city_id > 0 ? " and hotel_city_id = $hotel_city_id " : " ";
        $sql .= $hotel_star > 0 ? " and hotel_star = $hotel_star " : " ";
        $result   = $xoopsDB->query($sql);
        $hotelArr = array();
        while ($row = $xoopsDB->fetchArray($result)) {
            $hotelArr[$row['hotel_id']] = $row['hotel_name'];
        }

        return $hotelArr;
    }
}