public Vector<Vector<Object>> getParentData(MBPartner bpartner) {
Vector<Vector<Object>> data = new Vector<Vector<Object>>();
Vector<Object> line = new Vector<Object>();
List<MBPartner> students =
new Query(
ctx,
MBPartner.Table_Name,
"C_BPartner_ID <> ? AND C_BPartner_ID IN (Select C_BPartner_ID from AD_User where BPartner_Parent_ID=?)",
null) // missing contact clauses
.setParameters(bpartner.get_ID(), bpartner.get_ID())
.list();
for (MBPartner student : students) {
studentList.put(student.getValue(), student);
findPaymentSchedule(student);
line.add(student.getValue());
line.add(student.getName());
line.add("0000"); // replace by SecureCode
line.add("0000"); // replace by Enrollment
line.add("0000"); // replace by Transport Code
String whereClause =
"AD_User_ID IN (Select AD_User_ID from AD_User where BPartner_Parent_ID=? AND C_BPartner_ID=? AND ISPAYMENTRESPONSIBLE=? )";
MUser contact =
new Query(ctx, MUser.Table_Name, whereClause, null)
.setParameters(bpartner.get_ID(), student.get_ID(), true)
.first();
line.add(contact != null ? true : false);
data.add(line);
line = new Vector<Object>();
}
return data;
}
