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

    Copyright 2014 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

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

include(dirname(__FILE__).'/../../../config.php');
if (!class_exists('FannieAPI')) {
    include(__DIR__ . '/../../../classlib2.0/FannieAPI.php');
}

/**
*/
class WfcClassMenuTask extends FannieTask 
{
    public $name = 'WFC Class Menu Task';

    public $description = 'Build custom menu for buying class registrations.';

    public function run()
    {
        global $FANNIE_OP_DB;
        $dbc = FannieDB::get($FANNIE_OP_DB);

        $dbc->query('DELETE FROM QuickLookups WHERE lookupSet=708 AND sequence < 32766');
        $r = $dbc->query('
                    SELECT 708, u.description, p.upc, TO_DAYS(expires)-(1970*365) 
                    FROM products AS p 
                        INNER JOIN productUser AS u ON p.upc=u.upc 
                        LEFT JOIN productExpires AS e ON p.upc=e.upc 
                    WHERE p.department=708 AND CURDATE() <= e.expires
                        AND p.store_id=1
                    ORDER BY u.description');
        $insP = $dbc->prepare('
            INSERT INTO QuickLookups
            (lookupSet, label, action, sequence)
            VALUES (?, ?, ?, ?)');
        $seq = 0;
        while ($w = $dbc->fetchRow($r)) {
            $dbc->execute($insP, array(708, $w['description'], $w['upc'], $seq)); 
            $seq++;
        }

        $success = \COREPOS\Fannie\API\data\SyncLanes::pushTable('QuickLookups');
    }
}

