当前位置: 首页>>代码示例>>PHP>>正文


PHP VmTable::delete方法代码示例

本文整理汇总了PHP中VmTable::delete方法的典型用法代码示例。如果您正苦于以下问题:PHP VmTable::delete方法的具体用法?PHP VmTable::delete怎么用?PHP VmTable::delete使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在VmTable的用法示例。


在下文中一共展示了VmTable::delete方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: delete

    /**
     * Overloaded delete() to delete records from order_userinfo and order payment as well,
     * and write a record to the order history (TODO Or should the hist table be cleaned as well?)
     *
     * @var integer Order id
     * @return boolean True on success
     * @author Oscar van Eijk
     * @author Kohl Patrick
     */
    function delete($id = null, $where = 0)
    {
        $this->_db->setQuery('DELETE from `#__virtuemart_order_userinfos` WHERE `virtuemart_order_id` = ' . $id);
        if ($this->_db->query() === false) {
            vmError($this->_db->getError());
            return false;
        }
        /*vm_order_payment NOT EXIST  have to find the table name*/
        $this->_db->setQuery('SELECT `payment_element` FROM `#__virtuemart_paymentmethods` , `#__virtuemart_orders`
			WHERE `#__virtuemart_paymentmethods`.`virtuemart_paymentmethod_id` = `#__virtuemart_orders`.`virtuemart_paymentmethod_id` AND `virtuemart_order_id` = ' . $id);
        $paymentTable = '#__virtuemart_payment_plg_' . $this->_db->loadResult();
        $this->_db->setQuery('DELETE from `' . $paymentTable . '` WHERE `virtuemart_order_id` = ' . $id);
        if ($this->_db->query() === false) {
            vmError($this->_db->getError());
            return false;
        }
        /*vm_order_shipment NOT EXIST  have to find the table name*/
        $this->_db->setQuery('SELECT `shipment_element` FROM `#__virtuemart_shipmentmethods` , `#__virtuemart_orders`
			WHERE `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id` = `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` AND `virtuemart_order_id` = ' . $id);
        $shipmentName = $this->_db->loadResult();
        if (empty($shipmentName)) {
            vmError('Seems the used shipmentmethod got deleted');
            //Can we securely prevent this just using
            //	'SELECT `shipment_element` FROM `#__virtuemart_shipmentmethods` , `#__virtuemart_orders`
            //	WHERE `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id` = `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` AND `virtuemart_order_id` = ' . $id );
        } else {
            $shipmentTable = '#__virtuemart_shipment_plg_' . $shipmentName;
            $this->_db->setQuery('DELETE from `' . $shipmentTable . '` WHERE `virtuemart_order_id` = ' . $id);
            if ($this->_db->query() === false) {
                vmError('TableOrders delete Order shipmentTable = ' . $shipmentTable . ' `virtuemart_order_id` = ' . $id . ' dbErrorMsg ' . $this->_db->getError());
                return false;
            }
        }
        $_q = 'INSERT INTO `#__virtuemart_order_histories` (' . ' virtuemart_order_history_id' . ',virtuemart_order_id' . ',order_status_code' . ',created_on' . ',customer_notified' . ',comments' . ') VALUES (' . ' NULL' . ',' . $id . ",'-'" . ',NOW()' . ',0' . ",'Order deleted'" . ')';
        $this->_db->setQuery($_q);
        $this->_db->query();
        // Ignore error here
        return parent::delete($id);
    }
开发者ID:Roma48,项目名称:abazherka_old,代码行数:48,代码来源:orders.php

示例2: delete

    /**
     * Overloaded delete() to delete records from order_userinfo and order payment as well,
     * and write a record to the order history (TODO Or should the hist table be cleaned as well?)
     *
     * @var integer Order id
     * @return boolean True on success
     * @author Oscar van Eijk
     * @author Kohl Patrick
     */
    function delete($id)
    {
        $this->_db->setQuery('DELETE from `#__virtuemart_order_userinfos` WHERE `virtuemart_order_id` = ' . $id);
        if ($this->_db->query() === false) {
            vmError($this->_db->getError());
            return false;
        }
        /*vm_order_payment NOT EXIST  have to find the table name*/
        $this->_db->setQuery('SELECT `payment_element` FROM `#__virtuemart_paymentmethods` , `#__virtuemart_orders`
			WHERE `#__virtuemart_paymentmethods`.`virtuemart_paymentmethod_id` = `#__virtuemart_orders`.`virtuemart_paymentmethod_id` AND `virtuemart_order_id` = ' . $id);
        $paymentTable = '#__virtuemart_payment_plg_' . $this->_db->loadResult();
        $this->_db->setQuery('DELETE from `' . $paymentTable . '` WHERE `virtuemart_order_id` = ' . $id);
        if ($this->_db->query() === false) {
            vmError($this->_db->getError());
            return false;
        }
        /*vm_order_shipment NOT EXIST  have to find the table name*/
        $this->_db->setQuery('SELECT `shipment_element` FROM `#__virtuemart_shipmentmethods` , `#__virtuemart_orders`
			WHERE `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id` = `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` AND `virtuemart_order_id` = ' . $id);
        $shipmentTable = '#__virtuemart_shipment_plg_' . $this->_db->loadResult();
        $this->_db->setQuery('DELETE from `' . $shipmentTable . '` WHERE `virtuemart_order_id` = ' . $id);
        if ($this->_db->query() === false) {
            vmError($this->_db->getError());
            return false;
        }
        $_q = 'INSERT INTO `#__virtuemart_order_histories` (' . ' virtuemart_order_history_id' . ',virtuemart_order_id' . ',order_status_code' . ',created_on' . ',customer_notified' . ',comments' . ') VALUES (' . ' NULL' . ',' . $id . ",'-'" . ',NOW()' . ',0' . ",'Order deleted'" . ')';
        $this->_db->setQuery($_q);
        $this->_db->query();
        // Ignore error here
        return parent::delete($id);
    }
开发者ID:joselapria,项目名称:virtuemart,代码行数:40,代码来源:orders.php


注:本文中的VmTable::delete方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。