package com.webclient.beans.udkc;

import psdi.app.iface.sap.Sap2EamHandler;
import psdi.app.iface.spms.Eam2SpmsService;
import psdi.app.iface.spms.Spms2EamHandler;
import psdi.mbo.MboRemote;
import psdi.mbo.MboSetRemote;
import psdi.server.MXServer;
import psdi.util.MXException;
import psdi.webclient.system.beans.AppBean;
import psdi.webclient.system.beans.ResultsBean;

import java.io.IOException;
import java.rmi.RemoteException;

/**
 * 获取库存数据---EAM手动拉取
 * com.webclient.beans.udkc.UDKCAppBean
 */
public class UDKCAppBean extends AppBean {

    //手动拉取，根据登录人所在工厂，拉取本工厂的库存数据
    public void DGLQKC() throws IOException, MXException {
        System.out.println("--------start---------");
        MboRemote mbo = getMbo();//获取当前对象
        String SITEID = mbo.getString("SITEID");
        String ORGID = mbo.getString("ORGID");
        new Spms2EamHandler().Z_SPMS_TOTAL_STORAGE_INVENTORY_TO_EAM(SITEID,ORGID);//单个工厂
        System.out.println("-------end-------------");
    }

    //测试接口
    public void HQKC() throws IOException, MXException {
        System.out.println("--------start---------");
        //test data
        String data = "{\n" +
                "    \"IT_REQUEST\": [\n" +
                "        {\n" +
                "            \"MATNR\": \"111\",\n" +
                "            \"ISSUEUNIT\": \"210015035\",\n" +
                "            \"SITEID\": \"GF03\",\n" +
                "            \"STORELOC\": \"1006\",\n" +
                "            \"PHYSCNTTOTAL\": \"12\",\n" +
                "            \"BINNUM\": \"RA07BT02\",\n" +
                "            \"UNITCOST\": \"1\",\n" +
                "            \"LINECOST\": \"11\",\n" +
                "            \"CURRENCY\": \"YUN\"\n" +
                "        },\n" +
                "        {\n" +
                "            \"MATNR\": \"222\",\n" +
                "            \"ISSUEUNIT\": \"210015036\",\n" +
                "            \"SITEID\": \"GF03\",\n" +
                "            \"STORELOC\": \"1006\",\n" +
                "            \"PHYSCNTTOTAL\": \"12\",\n" +
                "            \"BINNUM\": \"RA07BT02\",\n" +
                "            \"UNITCOST\": \"2\",\n" +
                "            \"LINECOST\": \"22\",\n" +
                "            \"CURRENCY\": \"YUN\"\n" +
                "        }\n" +
                "    ]\n" +
                "}";
        new Eam2SpmsService().Z_SPMS_STORAGE_INVENTORY_TO_EAM(data);
        System.out.println("-------end-------------");
    }

    public void initializeApp() throws MXException, RemoteException {
        super.initializeApp();
        ResultsBean resultsbean = app.getResultsBean();
        MboSetRemote set=resultsbean.getMboSet();
        String userid=set.getUserInfo().getPersonId();
        MboSetRemote pset= MXServer.getMXServer().getMboSet("person", set.getUserInfo());
        pset.setWhere("personid='"+userid+"'");
        if(!pset.isEmpty() && pset.count()>0){
            MboRemote per=pset.getMbo(0);
            //权限等级
            String aut=per.getString("UDAUTGRADE");
            String orgid=per.getString("LOCATIONORG");
            String siteid=per.getString("LOCATIONSITE");

            if("Level 1".equalsIgnoreCase(aut)){
                set.setWhere(" 1=1 ");
            }else if("Level 2".equalsIgnoreCase(aut)){
                set.setWhere(" SITEID in(SELECT siteid FROM SITE WHERE ORGID='"+orgid+"') ");
            }else if("Level 3".equalsIgnoreCase(aut)){
                set.setWhere(" SITEID='"+siteid+"' ");
            }else{
                //没有等级
                set.setWhere("1=2");
            }
        }
        pset.close();

    }

}