#!/usr/bin/perl

#use utf8;
use strict;
use CGI;

use Opals::Context;
use Opals::Template qw(
    tmpl_read
    tmpl_write
    tmpl_preference
);

use Opals::Tb_Transactions qw(
    trans_getBalance
    
);

my $dbh = Opals::Context->dbh();
END { $dbh->disconnect(); }

my $cgi      = CGI->new;
my $input    = $cgi->Vars();

my ($second, $minute, $hour, $dayOfMonth, $month, $yearOffset, $dayOfWeek, $dayOfYear, $daylightSavings) = localtime();
my $time =sprintf("%04d-%02d-%02d %2d:%2d:%2d", $yearOffset+1900, $month+1, $dayOfMonth,$hour,$minute,$second);

my ($permission, $cookie, $template) = tmpl_read(
    {
        dbh             => $dbh,
        cgi             => $cgi,
        tmplFile        => 'txtbk/ajax/circ/getBalance.tmpl',
        reqPermission   => 'tb_circ_loan|tb_circ_return',
    }
);
if ($permission &&  ($permission->{'tb_circ_loan'}|| $permission->{'tb_circ_return'})) {
    my $uid= $input->{'uid'};
    my $balance=0;
    if($uid && $uid>0){
        $balance =trans_getBalance($dbh,$uid);
    }
    $template->param(
                uid =>$uid,
                balance=>$balance,
                time   =>$time );
}
 
tmpl_write($dbh, $cgi, $cookie, $template);
#------------------------------------------------------------------------------