msetup.java

Java写的ERP系统

//		sqlCmd.append(",C_UOM_Length_ID=");
//		sqlCmd.append(",C_UOM_Time_ID=");
		sqlCmd.append(" WHERE AD_Client_ID=").append(AD_Client_ID);
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
		{
			String err = "MSetup.createEntities - ClientInfo not updated";
			Log.error(err);
			m_info.append(err);
			return false;
		}

		/**
		 *  Other
		 */
		//  PriceList
		int M_PriceList_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "M_PriceList");
		sqlCmd = new StringBuffer ("INSERT INTO M_PriceList ");
		sqlCmd.append("(M_PriceList_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Name,C_Currency_ID,IsDefault) VALUES (");
		sqlCmd.append(M_PriceList_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(C_Currency_ID).append(",'Y')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - PriceList NOT inserted");
		//  DiscountSchema
		int M_DiscountSchema_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "M_DiscountSchema");
		sqlCmd = new StringBuffer ("INSERT INTO M_DiscountSchema ");
		sqlCmd.append("(M_DiscountSchema_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Name,ValidFrom,DiscountType, FlatDiscount) VALUES (");
		sqlCmd.append(M_DiscountSchema_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append("SysDate,'F',0)");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - DiscountSchema NOT inserted");
		//  PriceList Version
		int M_PriceList_Version_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "M_PriceList_Version");
		sqlCmd = new StringBuffer ("INSERT INTO M_PriceList_Version ");
		sqlCmd.append("(M_PriceList_Version_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Name,ValidFrom,M_PriceList_ID,M_DiscountSchema_ID) VALUES (");
		sqlCmd.append(M_PriceList_Version_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append("TO_CHAR(SysDate,'YYYY-MM-DD'),SysDate,").append(M_PriceList_ID)
			.append(",").append(M_DiscountSchema_ID).append(")");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - PriceList_Version NOT inserted");
		//  ProductPrice
		sqlCmd = new StringBuffer ("INSERT INTO M_ProductPrice ");
		sqlCmd.append("(M_PriceList_Version_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("M_Product_ID,PriceList,PriceStd,PriceLimit) VALUES (");
		sqlCmd.append(M_PriceList_Version_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append(M_Product_ID).append(",1,1,1)");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - ProductPrice NOT inserted");

		//  Location for Standard BP
		C_Location_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_Location");
		sqlCmd = new StringBuffer ("INSERT INTO C_Location ")
			.append("(C_Location_ID,").append(m_stdColumns).append(",")
			.append("City,C_Country_ID,C_Region_ID) VALUES (");
		sqlCmd.append(C_Location_ID).append(",").append(m_stdValues).append(",")
			.append("'").append(City).append("',").append(C_Country_ID).append(",");
		if (C_Region_ID != 0)
			sqlCmd.append(C_Region_ID).append(")");
		else
			sqlCmd.append("null)");

		DB.executeUpdate(sqlCmd.toString());
		int C_BPartner_Location_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_BPartner_Location");
		sqlCmd = new StringBuffer ("INSERT INTO C_BPartner_Location ");
		sqlCmd.append("(C_BPartner_Location_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("Name,C_BPartner_ID,C_Location_ID) VALUES (");
		sqlCmd.append(C_BPartner_Location_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append("'").append(City).append("',").append(C_BPartner_ID).append(",").append(C_Location_ID).append(")");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - BP_Location NOT inserted");

		//	Create Sales Rep for User
		C_BPartner_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_BPartner");
		sqlCmd = new StringBuffer ("INSERT INTO C_BPartner ");
		sqlCmd.append("(C_BPartner_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("Value,Name,C_BP_Group_ID,IsSummary,IsEmployee,IsSalesRep,IsVendor) VALUES (");
		sqlCmd.append(C_BPartner_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append("'").append(AD_User_U_Name).append("','").append(AD_User_U_Name).append("',");
		sqlCmd.append(C_BP_Group_ID).append(",'N','Y','Y','Y')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "IsSalesRep")).append("=").append(AD_User_U_Name).append("\n");
		else
			Log.error("MSetup.createEntities - SalesRep (User) NOT inserted");
		//  Update User
		sqlCmd = new StringBuffer ("UPDATE AD_User SET C_BPartner_ID=");
		sqlCmd.append(C_BPartner_ID).append(" WHERE AD_User_ID=").append(AD_User_U_ID);
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - User of SalesRep (User) NOT updated");

		//	Create Sales Rep for Admin
		C_BPartner_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_BPartner");
		sqlCmd = new StringBuffer ("INSERT INTO C_BPartner ");
		sqlCmd.append("(C_BPartner_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("Value,Name,C_BP_Group_ID,IsSummary,IsEmployee,IsSalesRep,IsVendor) VALUES (");
		sqlCmd.append(C_BPartner_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append("'").append(AD_User_Name).append("','").append(AD_User_Name).append("',");
		sqlCmd.append(C_BP_Group_ID).append(",'N','Y','Y','Y')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "IsSalesRep")).append("=").append(AD_User_Name).append("\n");
		else
			Log.error("MSetup.createEntities - SalesRep (Admin) NOT inserted");
		//  Update User
		sqlCmd = new StringBuffer ("UPDATE AD_User SET C_BPartner_ID=");
		sqlCmd.append(C_BPartner_ID).append(" WHERE AD_User_ID=").append(AD_User_ID);
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - User of SalesRep (Admin) NOT updated");

		//  Payment Term
		int C_PaymentTerm_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_PaymentTerm");
		sqlCmd = new StringBuffer ("INSERT INTO C_PaymentTerm ");
		sqlCmd.append("(C_PaymentTerm_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("Value,Name,NetDays,GraceDays,DiscountDays,Discount,DiscountDays2,Discount2,IsDefault) VALUES (");
		sqlCmd.append(C_PaymentTerm_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append("'Immediate','Immediate',0,0,0,0,0,0,'Y')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - PaymentTerm NOT inserted");

		//  Project Cycle
		C_Cycle_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_Cycle");
		sqlCmd = new StringBuffer ("INSERT INTO C_Cycle ");
		sqlCmd.append("(C_Cycle_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Name,C_Currency_ID) VALUES (");
		sqlCmd.append(C_Cycle_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(C_Currency_ID).append(")");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - Cycle NOT inserted");

		//  ProjectStatus
		int PS = createProjectStatus(110, "Prospect", "");
		createProjectStatus(120, "Qualified", "");
		createProjectStatus(130, "Opportunity", "Has Budget and Timeframe");
		createProjectStatus(140, "Solution", "Need Analysis");
		createProjectStatus(150, "Quote", "");
		createProjectStatus(160, "Close", "Contract Negotiations");
		createProjectStatus(200, "Delivery", "Delivery of Goods and Service");
		createPreference("C_ProjectStatus_ID", String.valueOf(PS), 0);

		/**
		 *  Organization level data	===========================================
		 */

		//	Create Default Project
		int C_Project_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_Project");
		sqlCmd = new StringBuffer ("INSERT INTO C_Project ");
		sqlCmd.append("(C_Project_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Value,Name,C_Currency_ID,IsSummary) VALUES (");
		sqlCmd.append(C_Project_ID).append(",").append(m_stdValuesOrg).append(", ");
		sqlCmd.append(defaultEntry).append(defaultEntry).append(C_Currency_ID).append(",'N')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "C_Project_ID")).append("=").append(defaultName).append("\n");
		else
			Log.error("MSetup.createEntities - Project NOT inserted");
		//  Default Project
		if (m_hasProject)
		{
			sqlCmd = new StringBuffer ("UPDATE C_AcctSchema_Element SET ");
			sqlCmd.append("C_Project_ID=").append(C_Project_ID);
			sqlCmd.append(" WHERE C_AcctSchema_ID=").append(C_AcctSchema_ID);
			sqlCmd.append(" AND ElementType='PJ'");
			no = DB.executeUpdate(sqlCmd.toString());
			if (no != 1)
				Log.error("MSetup.createEntities - AcctSchema ELement Project NOT updated");
		}

		//  CashBook
		int C_CashBook_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_CashBook");
		sqlCmd = new StringBuffer ("INSERT INTO C_CashBook ");
		sqlCmd.append("(C_CashBook_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Name,C_Currency_ID) VALUES (");
		sqlCmd.append(C_CashBook_ID).append(",").append(m_stdValuesOrg).append(", ");
		sqlCmd.append(defaultEntry).append(C_Currency_ID).append(")");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "C_CashBook_ID")).append("=").append(defaultName).append("\n");
		else
			Log.error("MSetup.createEntities - CashBook NOT inserted");


		//  Create Other Defaults
		try
		{
			CallableStatement cstmt = DB.prepareCall("CALL AD_Setup(?,?)");
			cstmt.setInt(1, AD_Client_ID);
			cstmt.setInt(2, AD_Org_ID);
			cstmt.execute();
			cstmt.close();
		}
		catch (SQLException e)
		{
			Log.error ("MSetup.CreateEntities - Call AD_Setup", e);
		}

		return true;
	}   //  createEntities

	/**
	 *  Create Project Status and CycleStep
	 *  @param SeqNo seq
	 *  @param Name name
	 *  @param Description description
	 *  @return C_ProjectStatus_ID
	 */
	private int createProjectStatus (int SeqNo, String Name, String Description)
	{
		int C_ProjectStatus_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_ProjectStatus");
		StringBuffer sqlCmd = new StringBuffer ("INSERT INTO C_ProjectStatus ");
		sqlCmd.append("(C_ProjectStatus_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("SeqNo,Name,Description) VALUES (");
		sqlCmd.append(C_ProjectStatus_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append(SeqNo).append(",'").append(Name).append("','").append(Description).append("')");
		int no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createProjectStatus - ProjectStatus NOT inserted - " + Name);
		//
		int C_CycleStep_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_CycleStep");
		sqlCmd = new StringBuffer ("INSERT INTO C_CycleStep ");
		sqlCmd.append("(C_CycleStep_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("C_Cycle_ID,SeqNo,C_ProjectStatus_ID,RelativeWeight) VALUES (");
		sqlCmd.append(C_CycleStep_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append(C_Cycle_ID).append(",").append(SeqNo).append(",").append(C_ProjectStatus_ID).append(",1)");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createProjectStatus - CycleStep NOT inserted - " + Name);
		//
		return C_ProjectStatus_ID;
	}   //  createProjectStatus

	/**
	 *  Create Preference
	 *  @param Attribute attribute
	 *  @param Value value
	 *  @param AD_Window_ID window
	 */
	private void createPreference (String Attribute, String Value, int AD_Window_ID)
	{
		int AD_Preference_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "AD_Preference");
		StringBuffer sqlCmd = new StringBuffer ("INSERT INTO AD_Preference ");
		sqlCmd.append("(AD_Preference_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("Attribute,Value,AD_Window_ID) VALUES (");
		sqlCmd.append(AD_Preference_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append("'").append(Attribute).append("','").append(Value).append("',");
		if (AD_Window_ID == 0)
			sqlCmd.append("NULL)");
		else
			sqlCmd.append(AD_Window_ID).append(")");
		int no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createPreference - Preference NOT inserted - " + Attribute);
	}   //  createPreference

	/*************************************************************************/

	/**
	 *  Get Client
	 *  @return AD_Client_ID
	 */
	public int getAD_Client_ID()
	{
		return AD_Client_ID;
	}
	public int getAD_Org_ID()
	{
		return AD_Org_ID;
	}
	public int getAD_User_ID()
	{
		return AD_User_ID;
	}
	public int getAD_Role_ID()
	{
		return AD_Role_ID;
	}
	public int getC_AcctSchema_ID()
	{
		return C_AcctSchema_ID;
	}
	public String getInfo()
	{
		return m_info.toString();
	}
}   //  MSetup