CORE-POS/IS4C

<?php
/*******************************************************************************

    Copyright 2012 Whole Foods Co-op

    This file is part of IT CORE.

    IT CORE is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    IT CORE is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    in the file license.txt along with IT CORE; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

*********************************************************************************/

namespace COREPOS\pos\parser\parse;
use COREPOS\pos\lib\Database;
use COREPOS\pos\lib\DisplayLib;
use COREPOS\pos\lib\PrehLib;
use COREPOS\pos\lib\TransRecord;
use COREPOS\pos\parser\Parser;

class LineItemDiscount extends Parser 
{
    /* Parse module matches input LD */
    function check($str)
    {
        if ($str == "LD") {
            return true;
        } elseif (strlen($str) > 2 && substr($str, 0, 2) == 'LD' && is_numeric(substr($str, 2))) {
            return true;
        }
        return false;
    }

    function parse($str)
    {
        $ret = $this->default_json();

        // this is the currently selected item
        $transID = $this->session->get("currentid");
        $row = PrehLib::peekItem(true, $transID);
        $dbc = Database::tDataConnect();

        if ($row === false) {
            // this shouldn't happen unless there's some weird session problem
            return $ret->output(DisplayLib::boxMsg(
                _("Item not found"),
                '',
                false,
                DisplayLib::standardClearButton()
            ));
        } 
        if ($row['trans_type'] != 'I' && $row['trans_type'] != 'D') {
            // only items & open rings are discountable
            return $ret->output(DisplayLib::boxMsg(
                _("Line is not discountable"),
                '',
                false,
                DisplayLib::standardClearButton()
            ));
        } 

        if ($str == 'LD') {
            if ($row['discounttype'] != 0) {
                // for simplicity, sale items cannot be discounted
                // this also prevents using this function more than
                // once on a single item
                return $ret->output(DisplayLib::boxMsg(
                    _("Item already discounted"),
                    '',
                    false,
                    DisplayLib::standardClearButton()
                ));
            } 
            // discount is simply the total times the 
            //   non-member discount percentage
            // total is discounted immediately using
            //   the non-member percentage
            // memDiscount is the difference between total
            //   member discount and the non-member discount
            //   since the non-member discount is applied 
            //   immediately
            // setting discounttype=2 makes the member discount
            //   apply when a [valid] member number is entered
            $discQ = sprintf("UPDATE localtemptrans SET
                discount=(regPrice * quantity * %f), 
                total=(total-(regPrice*quantity*%f)),
                memDiscount=((regPrice*quantity*%f) - (regPrice*quantity*%f)),
                discounttype=2
                WHERE trans_id=%d",
                $this->session->get("LineItemDiscountNonMem"),
                $this->session->get("LineItemDiscountNonMem"),
                $this->session->get("LineItemDiscountMem"),
                $this->session->get("LineItemDiscountNonMem"),
                $transID);
            $dbc->query($discQ);

            // add notification line for nonMem discount
            TransRecord::adddiscount($row['regPrice']*$row['quantity']*$this->session->get("LineItemDiscountNonMem"),
                $row['department']);
        } else {
            if ($row['charflag'] == 'PO') {
                return $ret->output(DisplayLib::boxMsg(
                    _("Item already discounted"),
                    '',
                    false,
                    DisplayLib::standardClearButton()
                ));
            } 

            $dbc = Database::pDataConnect();
            $prep = $dbc->prepare("SELECT line_item_discountable FROM products WHERE upc=?");
            $discountable = $dbc->getValue($prep, array($row['upc']));
            if (!$discountable) {
                return $ret->output(DisplayLib::boxMsg(
                    _("Item not eligible for discount"),
                    '',
                    false,
                    DisplayLib::standardClearButton()
                ));
            }

            $amt = substr($str, 2);
            $amt /= 100;
            $unitPrice = $row['unitPrice'] * (1 - $amt);
            $total = $row['quantity'] * $unitPrice;
            $dbc = Database::tDataConnect();
            $upP = $dbc->prepare("UPDATE localtemptrans
                SET charflag='PO',
                    unitPrice=?,
                    total=?
                WHERE trans_id=?");
            $dbc->execute($upP, array($unitPrice, $total, $transID));

            TransRecord::adddiscount($row['unitPrice'] * ($amt), $row['department']);
        }

        // footer should be redrawn since savings and totals
        // have changed. Output is the list of items
        $ret['redraw_footer'] = true;
        $ret['output'] = DisplayLib::lastpage();

        return $ret;
    }

    function doc(){
        return "<table cellspacing=0 cellpadding=3 border=1>
            <tr>
                <th>Input</th><th>Result</th>
            </tr>
            <tr>
                <td>LD</td>
                <td>Apply line item percent discount based on membership status</td>
            </tr>
            </table>";
    }

}