/** Find/Set BPartner */
private void findBPartner() {
String query = f_name.getText();
if (query == null || query.length() == 0) return;
// unchanged
if (m_bpartner != null && m_bpartner.getName().equals(query)) return;
query = query.toUpperCase();
// Test Number
boolean allNumber = true;
boolean noNumber = true;
char[] qq = query.toCharArray();
for (int i = 0; i < qq.length; i++) {
if (Character.isDigit(qq[i])) {
noNumber = false;
break;
}
}
try {
Integer.parseInt(query);
} catch (Exception e) {
allNumber = false;
}
String Value = query;
String Name = (allNumber ? null : query);
String EMail = (query.indexOf('@') != -1 ? query : null);
String Phone = (noNumber ? null : query);
String City = null;
//
// TODO: contact have been remove from rv_bpartner
MBPartnerInfo[] results =
MBPartnerInfo.find(p_ctx, Value, Name, /*Contact, */ null, EMail, Phone, City);
// Set Result
if (results.length == 0) {
setC_BPartner_ID(0);
} else if (results.length == 1) {
setC_BPartner_ID(results[0].getC_BPartner_ID());
f_name.setText(results[0].getName());
} else // more than one
{
QueryBPartner qt = new QueryBPartner(p_posPanel);
qt.setResults(results);
qt.setVisible(true);
}
} // findBPartner
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;
}
/**
* ************************************************************************ Set BPartner
*
* @param C_BPartner_ID id
*/
public void setC_BPartner_ID(int C_BPartner_ID) {
log.debug("PosSubCustomer.setC_BPartner_ID=" + C_BPartner_ID);
if (C_BPartner_ID == 0) m_bpartner = null;
else {
m_bpartner = new MBPartner(p_ctx, C_BPartner_ID, null);
if (m_bpartner.get_ID() == 0) m_bpartner = null;
}
// Set Info
if (m_bpartner != null) {
f_name.setText(m_bpartner.getName());
} else {
f_name.setText(null);
}
// Sets Currency
m_M_PriceList_Version_ID = 0;
getM_PriceList_Version_ID();
// fillCombos();
if (p_posPanel.m_order != null && m_bpartner != null)
p_posPanel.m_order.setBPartner(
m_bpartner); // added by ConSerTi to update the client in the request
} // setC_BPartner_ID
/**
* Perform process.
*
* @return Message (clear text)
* @throws Exception if not successful
*/
protected String doIt() throws java.lang.Exception {
StringBuffer sql =
new StringBuffer(
"SELECT * "
+ "FROM S_TimeExpense e "
+ "WHERE e.Processed='Y'"
+ " AND e.AD_Client_ID=?"); // #1
if (m_C_BPartner_ID != 0) sql.append(" AND e.C_BPartner_ID=?"); // #2
if (m_DateFrom != null) sql.append(" AND e.DateReport >= ?"); // #3
if (m_DateTo != null) sql.append(" AND e.DateReport <= ?"); // #4
sql.append(
" AND EXISTS (SELECT * FROM S_TimeExpenseLine el "
+ "WHERE e.S_TimeExpense_ID=el.S_TimeExpense_ID"
+ " AND el.C_InvoiceLine_ID IS NULL"
+ " AND el.ConvertedAmt<>0) "
+ "ORDER BY e.C_BPartner_ID, e.S_TimeExpense_ID");
//
int old_BPartner_ID = -1;
MInvoice invoice = null;
//
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
pstmt = DB.prepareStatement(sql.toString(), get_TrxName());
int par = 1;
pstmt.setInt(par++, getAD_Client_ID());
if (m_C_BPartner_ID != 0) pstmt.setInt(par++, m_C_BPartner_ID);
if (m_DateFrom != null) pstmt.setTimestamp(par++, m_DateFrom);
if (m_DateTo != null) pstmt.setTimestamp(par++, m_DateTo);
rs = pstmt.executeQuery();
while (rs.next()) // ********* Expense Line Loop
{
MTimeExpense te = new MTimeExpense(getCtx(), rs, get_TrxName());
// New BPartner - New Order
if (te.getC_BPartner_ID() != old_BPartner_ID) {
completeInvoice(invoice);
MBPartner bp = new MBPartner(getCtx(), te.getC_BPartner_ID(), get_TrxName());
//
log.info("New Invoice for " + bp);
invoice = new MInvoice(getCtx(), 0, null);
invoice.setClientOrg(te.getAD_Client_ID(), te.getAD_Org_ID());
invoice.setC_DocTypeTarget_ID(MDocType.DOCBASETYPE_APInvoice); // API
invoice.setDocumentNo(te.getDocumentNo());
//
invoice.setBPartner(bp);
if (invoice.getC_BPartner_Location_ID() == 0) {
log.log(Level.SEVERE, "No BP Location: " + bp);
addLog(
0,
te.getDateReport(),
null,
"No Location: " + te.getDocumentNo() + " " + bp.getName());
invoice = null;
break;
}
invoice.setM_PriceList_ID(te.getM_PriceList_ID());
invoice.setSalesRep_ID(te.getDoc_User_ID());
String descr =
Msg.translate(getCtx(), "S_TimeExpense_ID")
+ ": "
+ te.getDocumentNo()
+ " "
+ DisplayType.getDateFormat(DisplayType.Date).format(te.getDateReport());
invoice.setDescription(descr);
if (!invoice.save()) new IllegalStateException("Cannot save Invoice");
old_BPartner_ID = bp.getC_BPartner_ID();
}
MTimeExpenseLine[] tel = te.getLines(false);
for (int i = 0; i < tel.length; i++) {
MTimeExpenseLine line = tel[i];
// Already Invoiced or nothing to be reimbursed
if (line.getC_InvoiceLine_ID() != 0
|| Env.ZERO.compareTo(line.getQtyReimbursed()) == 0
|| Env.ZERO.compareTo(line.getPriceReimbursed()) == 0) continue;
// Update Header info
if (line.getC_Activity_ID() != 0 && line.getC_Activity_ID() != invoice.getC_Activity_ID())
invoice.setC_Activity_ID(line.getC_Activity_ID());
if (line.getC_Campaign_ID() != 0 && line.getC_Campaign_ID() != invoice.getC_Campaign_ID())
invoice.setC_Campaign_ID(line.getC_Campaign_ID());
if (line.getC_Project_ID() != 0 && line.getC_Project_ID() != invoice.getC_Project_ID())
invoice.setC_Project_ID(line.getC_Project_ID());
if (!invoice.save()) new IllegalStateException("Cannot save Invoice");
// Create OrderLine
MInvoiceLine il = new MInvoiceLine(invoice);
//
if (line.getM_Product_ID() != 0) il.setM_Product_ID(line.getM_Product_ID(), true);
il.setQty(line.getQtyReimbursed()); // Entered/Invoiced
il.setDescription(line.getDescription());
//
il.setC_Project_ID(line.getC_Project_ID());
il.setC_ProjectPhase_ID(line.getC_ProjectPhase_ID());
il.setC_ProjectTask_ID(line.getC_ProjectTask_ID());
il.setC_Activity_ID(line.getC_Activity_ID());
il.setC_Campaign_ID(line.getC_Campaign_ID());
//
// il.setPrice(); // not really a list/limit price for reimbursements
il.setPrice(line.getPriceReimbursed()); //
il.setTax();
if (!il.save()) new IllegalStateException("Cannot save Invoice Line");
// Update TEL
line.setC_InvoiceLine_ID(il.getC_InvoiceLine_ID());
line.saveEx();
} // for all expense lines
} // ********* Expense Line Loop
} catch (Exception e) {
log.log(Level.SEVERE, sql.toString(), e);
} finally {
DB.close(rs, pstmt);
rs = null;
pstmt = null;
}
completeInvoice(invoice);
return "@Created@=" + m_noInvoices;
} // doIt