|
Lines 2010-2015
sub GetLateOrders {
Link Here
|
| 2010 |
$from .= ' AND borrowers.branchcode LIKE ? '; |
2010 |
$from .= ' AND borrowers.branchcode LIKE ? '; |
| 2011 |
push @query_params, C4::Context->userenv->{branch}; |
2011 |
push @query_params, C4::Context->userenv->{branch}; |
| 2012 |
} |
2012 |
} |
|
|
2013 |
$from .= " AND orderstatus <> 4 "; |
| 2013 |
my $query = "$select $from $having\nORDER BY latesince, basketno, borrowers.branchcode, supplier"; |
2014 |
my $query = "$select $from $having\nORDER BY latesince, basketno, borrowers.branchcode, supplier"; |
| 2014 |
$debug and print STDERR "GetLateOrders query: $query\nGetLateOrders args: " . join(" ",@query_params); |
2015 |
$debug and print STDERR "GetLateOrders query: $query\nGetLateOrders args: " . join(" ",@query_params); |
| 2015 |
my $sth = $dbh->prepare($query); |
2016 |
my $sth = $dbh->prepare($query); |
| 2016 |
- |
|
|