package psdi.app.iface.mobile;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import psdi.mbo.MboRemote;
import psdi.mbo.MboSetRemote;
import psdi.server.MXServer;
import psdi.util.MXException;
import psdi.workflow.WorkFlowServiceRemote;

import javax.ws.rs.Consumes;
import javax.ws.rs.POST;
import javax.ws.rs.Path;
import javax.ws.rs.Produces;
import javax.ws.rs.core.MediaType;
import java.rmi.RemoteException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * 缺陷管理
 * createBy liuxq  2023-5-22
 */
@Path("/udreport")
public class UdreportAppService {

    /**
     * 数据保存接口
     * @param received
     * @return
     */
    @POST
    @Path("/saveData")
    @Produces(MediaType.APPLICATION_JSON)
    @Consumes(MediaType.APPLICATION_JSON)
    public JSONObject SaveData(String received) {
        //定义返回对象
        JSONObject returnDate = new JSONObject();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String LANGCODE = "";//语言环境
        try {
            //接收app数据
            JSONObject jsonObject = JSONObject.parseObject(received);
            LANGCODE = jsonObject.getString("LANGCODE");
            Integer UDREPORTID = jsonObject.getInteger("UDREPORTID");//表ID
            String UDREPORTNUM = jsonObject.getString("UDREPORTNUM");//缺陷编号
            String ASSETNUM = jsonObject.getString("ASSETNUM");//设备编号
            String LOCATION = jsonObject.getString("LOCATION");//位置编号
            String MAJOR = jsonObject.getString("MAJOR");//所属专业
            String FAILURECODE = jsonObject.getString("FAILURECODE");//故障类
            String PROBLEMCODE = jsonObject.getString("PROBLEMCODE");//问题代码
            String FAULTCAUSE = jsonObject.getString("FAULTCAUSE");//故障原因
            String REMEDY = jsonObject.getString("REMEDY");//补救措施
            String GZREMARK = jsonObject.getString("GZREMARK");//故障备注
            String HDONGROUP = jsonObject.getString("HDONGROUP");//发现班组
            String HDDEPT = jsonObject.getString("HDDEPT");//发现部门
            String RESDEPT = jsonObject.getString("RESDEPT");//责任部门
            String DEFETYPE = jsonObject.getString("DEFETYPE");//缺陷类型
            String ISZZXQ = jsonObject.getString("ISZZXQ");//是否自主消缺
            String ISBBZ = jsonObject.getString("ISBBZ");//是否归本班组负责
            String DESCRIPTION = jsonObject.getString("DESCRIPTION");//缺陷描述
            String STATUS = jsonObject.getString("STATUS");//状态
            String CREATEBY = jsonObject.getString("CREATEBY");//创建人
            String CREATEDATEStr = jsonObject.getString("CREATEDATE");//创建时间
            Date CREATEDATE = sdf.parse(CREATEDATEStr);
            String PERSONGROUP = jsonObject.getString("PERSONGROUP");//流程执行组
            String ORGID = jsonObject.getString("ORGID");//组织
            String SITEID = jsonObject.getString("SITEID");//地点
            MboSetRemote UDREPORTSet = MXServer.getMXServer().getMboSet("UDREPORT",MXServer.getMXServer().getSystemUserInfo());
            UDREPORTSet.setWhere(" UDREPORTID="+UDREPORTID+"");
            UDREPORTSet.reset();
            MboRemote mbo = null;
            if(UDREPORTSet!=null && !UDREPORTSet.isEmpty()){
                //编辑
                mbo = UDREPORTSet.getMbo(0);
            }else{
                //新增
                mbo = UDREPORTSet.add();
                mbo.setValue("STATUS","EDIT",2L);
                System.out.println("--------ID="+mbo.getInt("UDREPORTID"));
                UDREPORTID = mbo.getInt("UDREPORTID");
            }
            mbo.setValue("ASSETNUM",ASSETNUM,2L);//2L强制插入
            mbo.setValue("LOCATION",LOCATION,2L);
            mbo.setValue("MAJOR",MAJOR,2L);
            mbo.setValue("GZREMARK",GZREMARK,2L);
            mbo.setValue("FAILURECODE",FAILURECODE,2L);
            mbo.setValue("PROBLEMCODE",PROBLEMCODE,2L);
            mbo.setValue("FAULTCAUSE",FAULTCAUSE,2L);
            mbo.setValue("REMEDY",REMEDY,2L);
            mbo.setValue("HDONGROUP",HDONGROUP,2L);
            mbo.setValue("HDDEPT",HDDEPT,2L);
            mbo.setValue("RESDEPT",RESDEPT,2L);
            mbo.setValue("DEFETYPE",DEFETYPE,2L);
            mbo.setValue("ISZZXQ",ISZZXQ,2L);
            mbo.setValue("ISBBZ",ISBBZ,2L);
            mbo.setValue("DESCRIPTION",DESCRIPTION,2L);
            mbo.setValue("CREATEBY",CREATEBY,2L);
            mbo.setValue("CREATEDATE",CREATEDATE,2L);
            mbo.setValue("ORGID",ORGID,2L);
            mbo.setValue("SITEID",SITEID,2L);
            mbo.setValue("PERSONGROUP",PERSONGROUP,2L);//流程执行组
            //保存
            mbo.getThisMboSet().save(11L);
            returnDate.put("UDREPORTID",UDREPORTID);//返回前端刷新页面
            returnDate.put("errcode","200");
//            returnDate.put("errmsg","save success");
            returnDate.put("errmsg",new AMobileConfig().getTipByLang("save","success","errmsg",LANGCODE));
        }catch (Exception e){
            System.out.println("------faileMessage----->"+e.getMessage());
            returnDate.put("errcode","500");
//            returnDate.put("errmsg","save failure");
            returnDate.put("errmsg",new AMobileConfig().getTipByLang("save","failure","errmsg",LANGCODE));
        }finally {
            return returnDate;
        }
    }

    /**
     * 数据删除 接口
     * @param received
     * @return
     */
    @POST
    @Path("/deleteData")
    @Produces(MediaType.APPLICATION_JSON)
    @Consumes(MediaType.APPLICATION_JSON)
    public JSONObject DeleteData(String received) {
        //定义返回对象
        JSONObject returnDate = new JSONObject();
        String LANGCODE = "";//语言环境
        try {
            //接收app数据
            JSONObject jsonObject = JSONObject.parseObject(received);
            Integer UDREPORTID = jsonObject.getInteger("UDREPORTID");
            MboSetRemote UDREPORTSet = MXServer.getMXServer().getMboSet("UDREPORT",MXServer.getMXServer().getSystemUserInfo());
            UDREPORTSet.setWhere(" UDREPORTID="+UDREPORTID+"");
            UDREPORTSet.reset();
            MboRemote mbo = UDREPORTSet.getMbo(0);//
            mbo.delete();//相当于delete语句，结束后，还得保存
            mbo.getThisMboSet().save();

            returnDate.put("errcode","200");
//            returnDate.put("errmsg","delete success");
            returnDate.put("errmsg",new AMobileConfig().getTipByLang("delete","success","errmsg",LANGCODE));
        }catch (Exception e){
            System.out.println("------faileMessage----->"+e.getMessage());
            returnDate.put("errcode","500");
//            returnDate.put("errmsg","delete failure");
            returnDate.put("errmsg",new AMobileConfig().getTipByLang("delete","failure","errmsg",LANGCODE));
        }finally {
            return returnDate;
        }
    }

    /**
     * 转工单按钮--往日常维修工单新增一条数据,同时将附件（图片）也转过去
     * 同时每个缺陷只能转一个日常维修工单
     * @param received
     * @return
     */
    @POST
    @Path("/createWO")
    @Produces(MediaType.APPLICATION_JSON)
    @Consumes(MediaType.APPLICATION_JSON)
    public JSONObject CreateWO(String received) {
        //定义返回对象
        JSONObject returnDate = new JSONObject();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String LANGCODE = "";//语言环境
        try {
            //接收app数据
            MboSetRemote woSet = MXServer.getMXServer().getMboSet("UDWORKORDER",MXServer.getMXServer().getSystemUserInfo());//日常维修工单
            JSONObject jsonObject = JSONObject.parseObject(received);
            LANGCODE = jsonObject.getString("LANGCODE");
            String UDREPORTID = jsonObject.getString("UDREPORTID");//缺陷单表ID
            String UDREPORTNUM = jsonObject.getString("UDREPORTNUM");//缺陷单号
            //判断--一个缺陷单只能转一个日常维修工单---这样保证缺陷和日常维修工单是一对一，从缺陷才能跳转----
            woSet.setWhere("WOREQNUM='"+UDREPORTNUM+"'");
            woSet.reset();
            if(woSet!=null && !woSet.isEmpty()){
                returnDate.put("errcode","200");
//                returnDate.put("errmsg","Already Add");
                returnDate.put("errmsg",new AMobileConfig().getTipByLang("udreport","createWO","errmsg",LANGCODE));
                return returnDate;
            }
            //-------------------
            String DESCRIPTION = jsonObject.getString("DESCRIPTION");//
            String ASSETNUM = jsonObject.getString("ASSETNUM");//资产编号
            String LOCATION = jsonObject.getString("LOCATION");//资产位置
            String STATUS = jsonObject.getString("STATUS");//状态
            String PERSONGROUP = jsonObject.getString("PERSONGROUP");//流程执行组
            String ORGID = jsonObject.getString("ORGID");//组织
            String SITEID = jsonObject.getString("SITEID");//地点
            String CREATEBY = jsonObject.getString("CREATEBY");//创建人
//            String REMARKS = jsonObject.getString("REMARKS");//备注
            String FAILURECODE = jsonObject.getString("FAILURECODE");//故障类
            String PROBLEMCODE = jsonObject.getString("PROBLEMCODE");//问题代码
            String FAULTCAUSE = jsonObject.getString("FAULTCAUSE");//原因
            String REMEDY = jsonObject.getString("REMEDY");//措施
            String GZREMARK = jsonObject.getString("GZREMARK");//故障备注
            String CREATEDATEStr = sdf.format(new Date());
            Date CREATEDATE = sdf.parse(CREATEDATEStr);
            String KOSTL = "";//成本中心
            String DEPARTMENT = "";//部门
            MboSetRemote assetSet = MXServer.getMXServer().getMboSet("ASSET",MXServer.getMXServer().getSystemUserInfo());
            assetSet.setWhere(" ASSETNUM='"+ASSETNUM+"' and orgid='"+ORGID+"' and siteid='"+SITEID+"'");
            assetSet.reset();
            if(assetSet!=null && !assetSet.isEmpty()){
                KOSTL = assetSet.getMbo(0).getString("COSTCENTER");
                DEPARTMENT = assetSet.getMbo(0).getString("SDSYBM");//使用部门
            }
            MboRemote mbo = woSet.add();//新增一条数据
            mbo.setValue("DESCRIPTION",DESCRIPTION,11L);
            mbo.setValue("WOREQNUM",UDREPORTNUM,11L);
            mbo.setValue("ASSETNUM",ASSETNUM,11L);
            mbo.setValue("REMARKS",GZREMARK,11L);
            mbo.setValue("LOCATION",LOCATION,11L);
            mbo.setValue("FAILURECODE",FAILURECODE,11L);
            mbo.setValue("PROBLEMCODE",PROBLEMCODE,11L);
            mbo.setValue("FAULTCAUSE",FAULTCAUSE,11L);
            mbo.setValue("REMEDY",REMEDY,11L);
            mbo.setValue("WORKSHOP",DEPARTMENT,11L);//部门/车间
            mbo.setValue("KOSTL",KOSTL);//成本中心
            mbo.setValue("APPNAME","UDWORKORDERAPP");//appname 给出默认值
            mbo.setValue("STATUS","EDIT",11L);//日常维修工单-编辑状态
            mbo.setValue("ORGID",ORGID,11L);
            mbo.setValue("SITEID",SITEID,11L);
            mbo.setValue("CREATEBY",CREATEBY,11L);
            mbo.setValue("CREATEDATE",CREATEDATE,11L);
            mbo.setValue("PERSONGROUP",PERSONGROUP,11L);//流程执行组
            mbo.setValue("ISSTOP","N");//是否停机
            mbo.setValue("MAINTYPE","01");//维修类型
//            mbo.getThisMboSet().save(11L);//跳过MBO的保存------这里不能保存（保存流程会失败），下面的流程自启动，会自动保存。
            returnDate.put("errcode","200");
//            returnDate.put("errmsg","add success");
            returnDate.put("errmsg",new AMobileConfig().getTipByLang("udreportcreateWO","success","errmsg",LANGCODE));
            ((WorkFlowServiceRemote) MXServer.getMXServer().lookup("WORKFLOW")).initiateWorkflow("UDWORKORDE", mbo);//流程自启动
            //----------------缺陷单的附件转到日常维修工单---liuxq------start------------------------------------------------------
              //1.查询缺陷单附件
            MboSetRemote doclinksSet = MXServer.getMXServer().getMboSet("DOCLINKS",MXServer.getMXServer().getSystemUserInfo());
            MboSetRemote docinfoSet = MXServer.getMXServer().getMboSet("DOCINFO",MXServer.getMXServer().getSystemUserInfo());
            doclinksSet.setWhere("ownertable='UDREPORT' and ownerid='"+UDREPORTID+"'");
            doclinksSet.reset();
            if(doclinksSet!=null && !doclinksSet.isEmpty()){
                for(int i=0;i<doclinksSet.count();i++){
                    MboRemote doclinkMbo = doclinksSet.getMbo(i);
                    int docinfoID = doclinkMbo.getInt("DOCINFOID");
                    docinfoSet.setWhere("DOCINFOID="+docinfoID+"");
                    docinfoSet.reset();
                    if(docinfoSet!=null && !docinfoSet.isEmpty()){
                        for(int k=0;k<docinfoSet.count();k++){
                            MboRemote docinfoMbo = docinfoSet.getMbo(k);
                            String fileName = docinfoMbo.getString("DESCRIPTION");//文件名
                            int ownerid = mbo.getInt("UDWORKORDERID");//日常维修工单的主表ID
                            String ownertable = "UDWORKORDER";//日常维修工单主表
                            String uploadPath = "/sunda/eamfile/attachments/";//linux服务器路径
                            setFileDoclink(fileName,ownerid,ownertable,uploadPath,CREATEBY,"","");//像附件表插入；
                        }
                    }
                }
            }
            //----------------缺陷单的附件转到日常维修工单---liuxq------end------------------------------------------------------
        }catch (Exception e){
            System.out.println("------faileMessage----->"+e.getMessage());
            returnDate.put("errcode","500");
//            returnDate.put("errmsg","add failure");
            returnDate.put("errmsg",new AMobileConfig().getTipByLang("udreportcreateWO","failure","errmsg",LANGCODE));
        }finally {
            return returnDate;
        }
    }

    //向附件相关表插入数据
    public void setFileDoclink(String fileName, int ownerid, String ownertable, String uploadPath, String CREATEBY, String fileType, String reference)
    {
        try {
            if ((!fileName.equalsIgnoreCase("")) && (!ownertable.equalsIgnoreCase("")) && (ownerid > 1)) {
                SimpleDateFormat ftd = new SimpleDateFormat("yyyyMMddHHmmss");
                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                Date UPLOADDATE = sdf.parse(sdf.format(new Date())); //系统生成上传日期
                MboSetRemote doclinksSet = MXServer.getMXServer().getMboSet("DOCLINKS",MXServer.getMXServer().getSystemUserInfo());
                MboSetRemote docinfoSet = MXServer.getMXServer().getMboSet("DOCINFO",MXServer.getMXServer().getSystemUserInfo());
                //-附件表插入start----------------------------------------------------------------------------------------------
                //docinfo
                MboRemote docinfoMbo = docinfoSet.add();
                Integer DOCINFOID = docinfoMbo.getInt("DOCINFOID");//表ID
                String CONTENTUID= String.valueOf(DOCINFOID);
                String LANGCODE = "ZH";
                int SHOW = 0; int USEDEFAULTFILEPATH = 0; int PRINTTHRULINKDFLT = 0;
                String DOCUMENT = CONTENTUID;//暂时这样设置
                String DESCRIPTION = fileName;//文件名
                String CHANGEBY = CREATEBY;
                String DOCTYPE = "Attachments";//固定值
                String URLTYPE = "FILE";//固定值
                String URLNAME = uploadPath+fileName;// /sunda/eamfile/attachments/企业微信截图_1694773145947.png
                docinfoMbo.setValue("CONTENTUID",CONTENTUID,11L);
                docinfoMbo.setValue("LANGCODE",LANGCODE,11L);
                docinfoMbo.setValue("SHOW",SHOW,11L);
                docinfoMbo.setValue("USEDEFAULTFILEPATH",USEDEFAULTFILEPATH,11L);
                docinfoMbo.setValue("PRINTTHRULINKDFLT",PRINTTHRULINKDFLT,11L);
                docinfoMbo.setValue("DOCUMENT",DOCUMENT,11L);
                docinfoMbo.setValue("DESCRIPTION",DESCRIPTION,11L);
                docinfoMbo.setValue("CREATEDATE",UPLOADDATE,11L);
                docinfoMbo.setValue("CHANGEDATE",UPLOADDATE,11L);
                docinfoMbo.setValue("CHANGEBY",CREATEBY,11L);
                docinfoMbo.setValue("CREATEBY",CREATEBY,11L);
                docinfoMbo.setValue("DOCTYPE",DOCTYPE,11L);
                docinfoMbo.setValue("URLTYPE",URLTYPE,11L);
                docinfoMbo.setValue("URLNAME",URLNAME,11L);
                docinfoMbo.getThisMboSet().save(11L);
                docinfoSet.close();
                //doclinks
                MboRemote doclinksMbo = doclinksSet.add();
                doclinksMbo.setValue("DOCUMENT",DOCUMENT,11L);
                doclinksMbo.setValue("OWNERTABLE",ownertable,11L);
                doclinksMbo.setValue("OWNERID",ownerid,11L);
                doclinksMbo.setValue("DOCTYPE",DOCTYPE,11L);
                doclinksMbo.setValue("GETLATESTVERSION",1,11L);
                doclinksMbo.setValue("CREATEDATE",UPLOADDATE,11L);
                doclinksMbo.setValue("CHANGEDATE",UPLOADDATE,11L);
                doclinksMbo.setValue("CHANGEBY",CREATEBY,11L);
                doclinksMbo.setValue("CREATEBY",CREATEBY,11L);
                doclinksMbo.setValue("PRINTTHRULINK",0,11L);
                doclinksMbo.setValue("COPYLINKTOWO",0,11L);
                doclinksMbo.setValue("DOCINFOID",DOCINFOID,11L);
                doclinksMbo.getThisMboSet().save(11L);
                doclinksSet.close();
                //-附件表插入end----------------------------------------------------------------------------------------------
            }
        } catch (RemoteException e) {
            e.printStackTrace();
        } catch (MXException e) {
            e.printStackTrace();
        } catch (ParseException e) {
            throw new RuntimeException(e);
        }
    }


    /**
     * APP备件清单应用获取EAM备件物资清单获取数据
     * @param received
     * @return
     */
    @POST
    @Path("/getInventData")
    @Produces(MediaType.APPLICATION_JSON)
    @Consumes(MediaType.APPLICATION_JSON)
    public JSONObject getLldYdle(String received) {
        //定义返回对象
        JSONObject returnDate = new JSONObject();
        try {
            if("".equalsIgnoreCase(received) || null==received){
                returnDate.put("code", "500");
                returnDate.put("errmsg", "参数不能为空");
                return returnDate;
            }

            //接收app数据
            JSONObject jsonObject = JSONObject.parseObject(received);
            String ORGID = jsonObject.getString("ORGID");
            if("".equalsIgnoreCase(ORGID) || null==ORGID){
                returnDate.put("code", "500");
                returnDate.put("errmsg", "ORGID参数不能为空");
                return returnDate;
            }
            String SITEID = jsonObject.getString("SITEID");//地点
            if("".equalsIgnoreCase(SITEID) || null==SITEID){
                returnDate.put("code", "500");
                returnDate.put("errmsg", "SITEID参数不能为空");
                return returnDate;
            }
            MboSetRemote UDINVENTORYSET = MXServer.getMXServer().getMboSet("UDINVENTORY",MXServer.getMXServer().getSystemUserInfo());
            String sql=" ORGID='"+ORGID+"' AND SITEID='"+SITEID+"' ";
            UDINVENTORYSET.setWhere(sql);
            UDINVENTORYSET.reset();
            if(UDINVENTORYSET!=null && !UDINVENTORYSET.isEmpty()){
                JSONArray jsonArray = new JSONArray() ;
                for (int i=0;i<UDINVENTORYSET.count();i++) {
                    net.sf.json.JSONObject jsonObject1  = new net.sf.json.JSONObject();
                    MboRemote udinvMbo=UDINVENTORYSET.getMbo(i);
                    jsonObject1.put("UDINVENTORYID", udinvMbo.getInt("UDINVENTORYID"));
                    jsonObject1.put("ORGID", ORGID);
                    jsonObject1.put("SITEID", SITEID);
                    MboSetRemote DEPTTOTALSET=udinvMbo.getMboSet("$UDMATUSETRANS", "UDMATUSETRANS", "ITEMNUM='"+udinvMbo.getString("ITEMNUM")+"'  and DEPTNUM in(SELECT DEPTNUM FROM DEPT WHERE DEPTTYPE='"+udinvMbo.getString("DEPTNUM")+"'  AND SITEID='"+udinvMbo.getString("SITEID")+"' ) AND ISJJ=0  ");
                    if(null!=DEPTTOTALSET && !DEPTTOTALSET.isEmpty()){
                        jsonObject1.put("CURBALTOTAL", DEPTTOTALSET.sum("QUANTITY"));
                    }else{
                        jsonObject1.put("CURBALTOTAL", "0");
                    }
                    //JJHSYL旧件留用数量
                    MboSetRemote JJHSYLSET=udinvMbo.getMboSet("$UDMATUSETRANS", "UDMATUSETRANS", "ITEMNUM='"+udinvMbo.getString("ITEMNUM")+"'  and DEPTNUM in(SELECT DEPTNUM FROM DEPT WHERE DEPTTYPE='"+udinvMbo.getString("DEPTNUM")+"'  AND SITEID='"+udinvMbo.getString("SITEID")+"' ) AND ISJJ=1 ");
                    if(null!=JJHSYLSET && !JJHSYLSET.isEmpty()){
                        jsonObject1.put("JJHSYL", JJHSYLSET.sum("QUANTITY"));
                    }else{
                        jsonObject1.put("JJHSYL", "0");
                    }
                    jsonObject1.put("DEPTNUM", udinvMbo.getString("DEPTNUM"));//DEPTNUM部门类
                    MboSetRemote MEINSSET=udinvMbo.getMboSet("$EAM_MARA", "EAM_MARA","MATNR='"+udinvMbo.getString("ITEMNUM")+"'");
                    if(null!=MEINSSET && !MEINSSET.isEmpty()){
                        //ITEMNUM
                        jsonObject1.put("ITEMNUM", udinvMbo.getString("ITEMNUM"));
                        //MEINS
                        jsonObject1.put("MEINS", MEINSSET.getMbo(0).getString("MEINS"));
                        //ITEMNUMDESC
                        jsonObject1.put("ITEMNUMDESC", MEINSSET.getMbo(0).getString("MAKTX"));
                    }else{
                        jsonObject1.put("MEINS", "");
                    }
                    //DEPTNUMDESC
                    MboSetRemote DEPTNUMDESCSET=udinvMbo.getMboSet("$UDDEPTCLASS", "UDDEPTCLASS ","DEPTCLASSNUM='"+udinvMbo.getString("DEPTNUM")+"' ");
                    if(null!=DEPTNUMDESCSET && !DEPTNUMDESCSET.isEmpty()){
                        jsonObject1.put("DEPTNUMDESC", DEPTNUMDESCSET.getMbo(0).getString("DESCRIPTION"));//DEPTNUMDESC部门类描述
                    }else{
                        jsonObject1.put("DEPTNUMDESC", "");//DEPTNUMDESC部门类描述
                    }
                    jsonArray.add(jsonObject1);
                }
                returnDate.put("errcode","200");
                returnDate.put("errmsg","success");
                returnDate.put("jsonArray",jsonArray);
                return returnDate;
            }else{
                returnDate.put("errcode","500");
                returnDate.put("errmsg","入参无查询结果");
                return returnDate;
            }
        }catch (Exception e){
            returnDate.put("errcode","500");
            returnDate.put("errmsg",e.getMessage());
            return returnDate;
        }
    }


}