if ( ! defined( $record->{$_} ) || $record->{$_} eq '' ) {
if ( $op eq '=' ) {
if ( driver_name eq 'Pg' ) {
- qq-( $column IS NULL OR $column = '' )-;
+ if ( $dbdef->table($table)->column($column)->type =~ /(int)/i ) {
+ qq-( $column IS NULL )-;
+ } else {
+ qq-( $column IS NULL OR $column = '' )-;
+ }
} else {
qq-( $column IS NULL OR $column = "" )-;
}
} elsif ( $op eq '!=' ) {
if ( driver_name eq 'Pg' ) {
- qq-( $column IS NOT NULL AND $column != '' )-;
+ if ( $dbdef->table($table)->column($column)->type =~ /(int)/i ) {
+ qq-( $column IS NOT NULL )-;
+ } else {
+ qq-( $column IS NOT NULL AND $column != '' )-;
+ }
} else {
qq-( $column IS NOT NULL AND $column != "" )-;
}
<li><a href="upgrade7.html">Upgrading from 1.3.0 to 1.3.1</a>
<li><a href="upgrade8.html">Upgrading from 1.3.1 to 1.4.0</a>
<li><a href="upgrade9.html">Upgrading from 1.4.0 to 1.4.1</a>
+ <li><a href="upgrade10.html">Upgrading from 1.4.1 (or 1.4.2?) to 1.5.0</a>
<!--
<li><a href="config.html">Configuration files</a>
!-->
+<pre>
this is very incomplete
+install NetAddr::IP and Chart
+
CREATE TABLE cust_bill_pkg_detail (
detailnum serial,
pkgnum int NOT NULL,
);
CREATE INDEX cust_bill_pkg_detail1 ON cust_bill_pkg_detail ( pkgnum, invnum );
+create all of the new broadband tables
+
+</pre>
if ( @packages ) {
#formatting
+
+ my $colspan = $packages[0]->dbdef_table->column('last_bill') ? 6 : 5;
+
print &table(), "\n",
- qq!<TR><TH COLSPAN=2 ROWSPAN=2>Package</TH><TH COLSPAN=5>!,
+ qq!<TR><TH COLSPAN=2 ROWSPAN=2>Package</TH><TH COLSPAN=$colspan>!,
qq!Dates</TH><TH COLSPAN=2 ROWSPAN=2>Services</TH></TR>\n<TR>!,
qq!<TH><FONT SIZE=-1>Setup</FONT></TH>!;
print qq!<TH><FONT SIZE=-1>Next bill</FONT></TH>!,
qq!<TH><FONT SIZE=-1>Susp.</FONT></TH>!,
- qq!<TH><FONT SIZE=-1>Expire!</FONT></TH>!,
+ qq!<TH><FONT SIZE=-1>Expire</FONT></TH>!,
qq!<TH><FONT SIZE=-1>Cancel</FONT></TH>!,
qq!</TR>\n!;
}