public static void main(String[] args) throws ActiveRecordException {
String suppId = "";
String beforeName = "";
// {"ProjectName":"企业基本信息","ChangeDate":"2019-06-21","AfterContent":"名称:厦门垒智建设有限公司,","BeforeContent":"名称:厦门科之杰建设工程有限公司,"}
String lo = "{\"ProjectName\":\"企业基本信息\",\"ChangeDate\":\"2019-06-21\",\"AfterContent\":\"名称:厦门垒智建设有限公司,\",\"BeforeContent\":\"名称:厦门科之杰建设工程有限公司,\"}";
JSONObject obj = JSONObject.parseObject(lo);
String a=obj.getString("ProjectName");
String b=obj.getString("AfterContent");
String c=obj.getString("BeforeContent");
String oo= "今天星期1";
int d=oo.lastIndexOf("星期1");
int d1=oo.lastIndexOf("8888");
int d2=oo.lastIndexOf("今天");
// if (obj.getString("ProjectName")!=null && (obj.getString("ProjectName").startsWith("名称变更") || obj.getString("ProjectName").equals("企业名称") || obj.getString("ProjectName").equals("名称"))) {
if(obj.getString("BeforeContent").lastIndexOf("企业名称")>-1)
{
String[] array = BCConvertUtils.qj2bj(obj.getString("AfterContent")).split(";");
for(String name:array)
{
if(name.lastIndexOf("企业名称")>-1)
{
name = name.replace("\n", "");
String[] nameArray = name.split(":");
beforeName = nameArray[1].trim().substring(0,nameArray[1].length() - 1);;
}
}
}
else
{
beforeName = obj.getString("BeforeContent").substring(0,obj.getString("BeforeContent").length() - 1);
}
//通过beforename查询供应商名称是否存在
Record rec = null;
rec = Db.findFirst("select uuid from biz_suppliers where sys_status=1 and suppliers_name=? ",beforeName);
if( rec ==null ){
rec = Db.findFirst("select uuid from biz_suppliers where sys_status=1 and (suppliers_name=? or suppliers_name=?)",BCConvertUtils.bj2qj(beforeName),BCConvertUtils.qj2bj(beforeName));
}
if(rec != null){
suppId = rec.getStr("uuid");
// break;
}
// }
}
public static void main2(String[] args) throws ActiveRecordException {
String suppId = "";
String beforeName = "";
// {"ProjectName":"企业基本信息","ChangeDate":"2019-06-21","AfterContent":"名称:厦门垒智建设有限公司,","BeforeContent":"名称:厦门科之杰建设工程有限公司,"}
String lo = "{\"ProjectName\":\"企业基本信息\",\"ChangeDate\":\"2019-06-21\",\"AfterContent\":\"名称:厦门垒智建设有限公司,\",\"BeforeContent\":\"名称:厦门科之杰建设工程有限公司,\"}";
JSONObject obj = JSONObject.parseObject(lo);
String a=obj.getString("ProjectName");
String b=obj.getString("AfterContent");
String c=obj.getString("BeforeContent");
String oo= "今天星期1";
int d=oo.lastIndexOf("星期1");
int d1=oo.lastIndexOf("8888");
int d2=oo.lastIndexOf("今天");
if (obj.getString("ProjectName")!=null
&& (obj.getString("ProjectName").startsWith("企业基本信息")
&& obj.getString("AfterContent").startsWith("名称:")
&& obj.getString("BeforeContent").startsWith("名称:"))) {
if(obj.getString("BeforeContent").lastIndexOf("名称")>-1){
String[] array = BCConvertUtils.qj2bj(obj.getString("BeforeContent")).split(";");
for(String name:array){
if(name.lastIndexOf("名称")>-1){
name = name.replace("\n", "");
String[] nameArray = name.split(":");
beforeName = nameArray[1].trim().substring(0,nameArray[1].length() - 1);;
}
}
}
//通过beforename查询供应商名称是否存在
Record rec = null;
rec = Db.findFirst("select uuid from biz_suppliers where sys_status=1 and suppliers_name=? ",beforeName);
if( rec ==null ){
rec = Db.findFirst("select uuid from biz_suppliers where sys_status=1 and (suppliers_name=? or suppliers_name=?)",BCConvertUtils.bj2qj(beforeName),BCConvertUtils.qj2bj(beforeName));
}
if(rec != null){
suppId = rec.getStr("uuid");
// break;
}
}
}