<?php

/**
 * Class that operate on table 'quickprofitgeneral'. Database Mysql.
 *
 * @author: http://phpdao.com
 * @date: 2019-01-27 09:50
 */
class QuickprofitgeneralMySqlExtDAO extends QuickprofitgeneralMySqlDAO {

    public function insertOrUpdatePlusEX($obj) {
        $sql = " INSERT INTO quickprofitgeneral (id, netSellVal, netSellCostBuyPrice, netSellCostLastBuyPrice, netSellCostMeanBuyPrice, netSellCostLastBuyPricewithDiscount, netSellCostMeanBuyPricewithDiscount, netSellCostOverAllAveragePrice,netSellCostLastBuyPricewithTax,netSellCostMeanBuyPricewithTax)
                    VALUES (1, $obj->netSellVal, $obj->netSellCostBuyPrice, $obj->netSellCostLastBuyPrice
                    , $obj->netSellCostMeanBuyPrice, $obj->netSellCostLastBuyPricewithDiscount, $obj->netSellCostMeanBuyPricewithDiscount, $obj->netSellCostOverAllAveragePrice, $obj->netSellCostLastBuyPricewithTax, $obj->netSellCostMeanBuyPricewithTax)
                ON DUPLICATE KEY UPDATE netSellVal = netSellVal+$obj->netSellVal, netSellCostBuyPrice = netSellCostBuyPrice+$obj->netSellCostBuyPrice
                , netSellCostLastBuyPrice = netSellCostLastBuyPrice+$obj->netSellCostLastBuyPrice
                , netSellCostMeanBuyPrice = netSellCostMeanBuyPrice+$obj->netSellCostMeanBuyPrice
                , netSellCostLastBuyPricewithDiscount = netSellCostLastBuyPricewithDiscount+$obj->netSellCostLastBuyPricewithDiscount
                , netSellCostMeanBuyPricewithDiscount = netSellCostMeanBuyPricewithDiscount+$obj->netSellCostMeanBuyPricewithDiscount
                , netSellCostOverAllAveragePrice = netSellCostOverAllAveragePrice+$obj->netSellCostOverAllAveragePrice
                , netSellCostLastBuyPricewithTax = netSellCostLastBuyPricewithTax+$obj->netSellCostLastBuyPricewithTax
                , netSellCostMeanBuyPricewithTax = netSellCostMeanBuyPricewithTax+$obj->netSellCostMeanBuyPricewithTax";
        $sqlQuery = new SqlQuery($sql);
        return $this->executeUpdate($sqlQuery);
    }

    public function insertOrUpdateMinusEX($obj) {
        $sql = " INSERT INTO quickprofitgeneral (id, netSellVal, netSellCostBuyPrice, netSellCostLastBuyPrice, netSellCostMeanBuyPrice, netSellCostLastBuyPricewithDiscount, netSellCostMeanBuyPricewithDiscount, netSellCostOverAllAveragePrice,netSellCostLastBuyPricewithTax,netSellCostMeanBuyPricewithTax)
                    VALUES (1, $obj->netSellVal, $obj->netSellCostBuyPrice, $obj->netSellCostLastBuyPrice
                    , $obj->netSellCostMeanBuyPrice, $obj->netSellCostLastBuyPricewithDiscount, $obj->netSellCostMeanBuyPricewithDiscount, $obj->netSellCostOverAllAveragePrice, $obj->netSellCostLastBuyPricewithTax, $obj->netSellCostMeanBuyPricewithTax)
                ON DUPLICATE KEY UPDATE netSellVal = netSellVal-$obj->netSellVal, netSellCostBuyPrice = netSellCostBuyPrice-$obj->netSellCostBuyPrice
                , netSellCostLastBuyPrice = netSellCostLastBuyPrice-$obj->netSellCostLastBuyPrice
                , netSellCostMeanBuyPrice = netSellCostMeanBuyPrice-$obj->netSellCostMeanBuyPrice
                , netSellCostLastBuyPricewithDiscount = netSellCostLastBuyPricewithDiscount-$obj->netSellCostLastBuyPricewithDiscount
                , netSellCostMeanBuyPricewithDiscount = netSellCostMeanBuyPricewithDiscount-$obj->netSellCostMeanBuyPricewithDiscount
                , netSellCostOverAllAveragePrice = netSellCostOverAllAveragePrice-$obj->netSellCostOverAllAveragePrice
                , netSellCostLastBuyPricewithTax = netSellCostLastBuyPricewithTax-$obj->netSellCostLastBuyPricewithTax
                , netSellCostMeanBuyPricewithTax = netSellCostMeanBuyPricewithTax-$obj->netSellCostMeanBuyPricewithTax";
        $sqlQuery = new SqlQuery($sql);
        return $this->executeUpdate($sqlQuery);
    }

    public function truncate() {
        $sql = "TRUNCATE quickprofitgeneral";
        $sqlQuery = new SqlQuery($sql);
        return $this->getList($sqlQuery);
    }

}

?>