#=====================================================================
# 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) 2000
#
#  Author: DWS Systems Inc.
#     Web: http://www.sql-ledger.org
#
#  Contributors:
#
#======================================================================
#
# This file has undergone whitespace cleanup.
#
#======================================================================
#
# General ledger backend code
#
#======================================================================

package GL;


sub delete_transaction {

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

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

    my %audittrail = ( 
        tablename  => 'gl',
        reference  => $form->{reference},
        formname   => 'transaction',
        action     => 'deleted',
        id         => $form->{id} );

    $form->audittrail($dbh, "", \%audittrail);
    my $id = $dbh->quote($form->{id});
    my $query = qq|DELETE FROM gl WHERE id = $id|;
    $dbh->do($query) || $form->dberror($query);

    $query = qq|DELETE FROM acc_trans WHERE trans_id = $id|;
    $dbh->do($query) || $form->dberror($query);

    # commit and redirect
    my $rc = $dbh->commit;

    $rc;
}


sub post_transaction {

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

    my $null;
    my $project_id;
    my $department_id;
    my $i;

    # connect to database, turn off AutoCommit
    my $dbh = $form->{dbh};

    my $query;
    my $sth;

    my $id = $dbh->quote($form->{id});
    if ($form->{id}) {

        $query = qq|SELECT id FROM gl WHERE id = $id|;
        ($form->{id}) = $dbh->selectrow_array($query);

        if ($form->{id}) {
            # delete individual transactions
            $query = qq|
                DELETE FROM acc_trans WHERE trans_id = $id|;

            $dbh->do($query) || $form->dberror($query);
        }
    }

    if (! $form->{id}) {

        my $uid = localtime;
        $uid .= "$$";

        $query = qq|
        INSERT INTO gl (reference, employee_id)
             VALUES ('$uid', (SELECT id FROM employee
                               WHERE login = ?))|;

        $sth = $dbh->prepare($query);
        $sth->execute($form->{login}) || $form->dberror($query);

        $query = qq|
            SELECT id 
              FROM gl
             WHERE reference = '$uid'|;
    
        ($form->{id}) = $dbh->selectrow_array($query);
    }

    ($null, $department_id) = split /--/, $form->{department};
    $department_id *= 1;

    $form->{reference} = $form->update_defaults(
        $myconfig, 'glnumber', $dbh) 
            unless $form->{reference};
    $form->{reference} ||= $form->{id};

    $query = qq|
        UPDATE gl 
           SET reference = |.$dbh->quote($form->{reference}).qq|,
              description = |.$dbh->quote($form->{description}).qq|,
              notes = |.$dbh->quote($form->{notes}).qq|,
              transdate = '$form->{transdate}',
              department_id = $department_id
        WHERE id = $form->{id}|;