qq| a.duedate, a.netamount, a.amount, a.paid, | .
qq| a.invoice, a.datepaid, a.terms, a.notes, a.shipvia, | .
qq| a.shippingpoint, a.storno, a.globalproject_id, | .
qq| a.duedate, a.netamount, a.amount, a.paid, | .
qq| a.invoice, a.datepaid, a.terms, a.notes, a.shipvia, | .
qq| a.shippingpoint, a.storno, a.globalproject_id, | .
qq| pr.projectnumber AS globalprojectnumber, | .
qq| c.name, | .
qq| e.name AS employee | .
qq| pr.projectnumber AS globalprojectnumber, | .
qq| c.name, | .
qq| e.name AS employee | .
$where .= " AND a.department_id = ?";
push(@values, $department_id);
}
$where .= " AND a.department_id = ?";
push(@values, $department_id);
}
if ($form->{$column}) {
$where .= " AND a.$column ILIKE ?";
push(@values, $form->like($form->{$column}));
if ($form->{$column}) {
$where .= " AND a.$column ILIKE ?";
push(@values, $form->like($form->{$column}));