#=====================================================================
# LedgerSMB
# Small Medium Business Accounting software
# http://www.ledgersmb.org/
#
# Copyright (C) 2006
# This work contains copyrighted information from a number of sources all used
# with permission.
#
# This file contains source code included with or based on SQL-Ledger which
# is Copyright Dieter Simader and DWS Systems Inc. 2000-2005 and licensed
# under the GNU General Public License version 2 or, at your option, any later
# version.  For a full list including contact information of contributors,
# maintainers, and copyright holders, see the CONTRIBUTORS file.
#
# Original Copyright Notice from SQL-Ledger 2.6.17 (before the fork):
# Copyright (C) 2005
#
#  Author: DWS Systems Inc.
#     Web: http://www.sql-ledger.org
#
#  Contributors:
#
#======================================================================
#
# This file has undergone whitespace cleanup.
#
#======================================================================
#
# Job Costing
#
#======================================================================

package JC;

use LedgerSMB::IS;
use LedgerSMB::PriceMatrix;
use LedgerSMB::Sysconfig;

sub get_jcitems {
    my ( $self, $myconfig, $form ) = @_;

    # connect to database
    my $dbh = $form->{dbh};

    my $query = qq|SELECT current_date|;
    ( $form->{transdate} ) = $dbh->selectrow_array($query);

    ( $form->{employee}, $form->{employee_id} ) = $form->get_employee($dbh);

    my $dateformat = $myconfig->{dateformat};
    $dateformat =~ s/yy/yyyy/;
    $dateformat =~ s/yyyyyy/yyyy/;

    if ( $form->{id} ) {

        # retrieve timecard/storescard
        $query = qq|
            SELECT j.*, to_char(j.checkedin, 'HH24:MI:SS') 
                   AS checkedina, 
                   to_char(j.checkedout, 'HH24:MI:SS') 
                   AS checkedouta, 
                   to_char(j.checkedin, ?) AS transdate,
                   e.name AS employee, p.partnumber,
                   pr.projectnumber, 
                   pr.description AS projectdescription,
                   pr.production, pr.completed, 
                   pr.parts_id AS project
              FROM jcitems j
              JOIN employee e ON (e.id = j.employee_id)
              JOIN parts p ON (p.id = j.parts_id)
              JOIN project pr ON (pr.id = j.project_id)
             WHERE j.id = ?|;
        $sth = $dbh->prepare($query);