lsa_YOS/src/custom/restcontroller/webmanage/lsak3/item/item.java

package restcontroller.webmanage.lsak3.item;

import com.alibaba.fastjson.JSONObject;
import common.Controller;
import common.YosException;
import common.annotation.API;
import common.data.Rows;
import common.data.RowsMap;
import common.data.SQLFactory;
import restcontroller.R;
import restcontroller.webmanage.sale.item.Item;

import java.util.ArrayList;

public class item extends Controller {
    /**
     * 构造函数
     *
     * @param content
     */
    public item(JSONObject content) throws YosException {
        super(content);
    }
    /**
     * 更新YOS商品档案
     *
     * @return
     */
    @API(title = "更新YOS商品档案", apiversion = R.ID20230715111203.v1.class,accesstoken = false)
    public String updateItem() throws YosException{
        String msg = "";
        int code = 1;
        ArrayList<String> sqllist = new ArrayList<>();
        //单位
        Rows unitRows = dbConnect.runSqlQuery("SELECT unitid,unitname from  plm_unit WHERE siteid = 'lsa'");
        RowsMap unitRowsMap = unitRows.toRowsMap("unitname");
        try {
            // 商品编号
            String fitemno = content.getString("fitemno");
            // k3内码
            String fitemid = content.getString("fitemid");
            // k3外码
            String foutitemno = content.getString("foutitemno");
            // 是否删除
            String isdelete = content.getString("isdelete");
            // 商品名称
            String fitemname = content.getString("fitemname");
            // 规格尺寸
            String fspec = content.getString("fspec");
            // 型号
            String fmodel = content.getString("fmodel");
            // 包装数量
            String fpackingqty = content.getString("fpackingqty");
            if("0".equals(fpackingqty)||"null".equals(fpackingqty)||fpackingqty==null) {
                fpackingqty="1";
            }
            // 保修期
            String fwarrantyday = content.getString("fwarrantyday");
            if("0".equals(fwarrantyday)||"null".equals(fwarrantyday)||fwarrantyday==null) {
                fwarrantyday="0";
            }
            // 存货类别
            String fitemclsnum = content.getString("fitemclsnum");
            // 存货名称
            String fitemclsname = content.getString("fitemclsname");
            // 单位编码
            String funitid = content.getString("funitid");
            // 单位名称
            String funitname = content.getString("funitname");
            // 净重
            String fnetweight = content.getString("fnetweight");
            // 毛重
            String fgrossweight = content.getString("fgrossweight");
            // 是否启用
            String fisused = content.getString("fisused");
            // 营销类别
            String fsaleclsnum = content.getString("fsaleclsnum");
            // 营销类别 编号
            String fsaleclsname = content.getString("fsaleclsname");

            // 创建人
            String createby = content.getString("createby");
            // 创建日期
            String createdate = content.getStringValue("createdate");

            // 审核人
            String checkby = content.getString("checkby");
            // 审核日期
            String checkdate = content.getStringValue("checkdate");
            // 修改人
            String changeby = content.getString("changeby");
            // 修改日期
            String changedate = content.getStringValue("changedate");

            //长度
            String fdzprice = content.getString("fdzprice");
            //长度
            String flong = content.getString("flong");
            //颜色
            String fcolour = content.getString("fcolour");
            //版型
            String fbx = content.getString("fbx");
            //边框
            String fbk = content.getString("fbk");
            //是否定制尺寸
            String fisdz = content.getString("fisdz");
            //功率
            String fgl = content.getString("fgl");

            Rows itemRows = dbConnect.runSqlQuery("select * from plm_item where siteid='lsa' and itemno='"+fitemno+"'");
            SQLFactory sqlFactory;
            if(itemRows.isEmpty()){
                long itemid = createTableID("plm_item");
                sqlFactory = new SQLFactory(this,"货品档案新增");
                sqlFactory.addParameter("itemid",itemid);
                sqlFactory.addParameter("sa_customschemeid", 0);
                // 货品档案扩展属性字段表
                SQLFactory sqlFactory1 = new SQLFactory(this, "货品档案-扩展新增");
                sqlFactory1.addParameter("siteid", "lsa");
                sqlFactory1.addParameter("userid", 1);
                sqlFactory1.addParameter("username", createby);
                sqlFactory1.addParameter("plm_itemextendid", createTableID("plm_itemextend"));
                sqlFactory1.addParameter("itemid", itemid);
                sqlFactory1.addParameter("material",fbx);
                sqlFactory1.addParameter("pressure", "");
                sqlFactory1.addParameter("caliber", "");
                sqlFactory1.addParameter("butterflyplatedrive", "");
                sqlFactory1.addParameter("connection", "");
                sqlFactory1.addParameter("valveplatematerial", "");
                sqlFactory1.addParameter("bodymaterial", "");
                sqlFactory1.addParameter("actuatortype", "");
                sqlFactory1.addParameter("actuatorbrand", "");
                sqlFactory1.addParameter("isbutterfly", 0);
                sqlFactory1.addParameter("erpitemno", fitemno);
                sqlFactory1.addParameter("erpitemname",fitemname);
                sqlFactory1.addParameter("specalnote","");
                sqlFactory1.addParameter("prodline", "");
                sqlFactory1.addParameter("device", "");

                SQLFactory sqlFactorytradefield = new SQLFactory(this,"货品档案领域新增");
                sqlFactorytradefield.addParameter("siteid", "lsa");
                sqlFactorytradefield.addParameter("plm_item_tradefieldid", createTableID("plm_item_tradefield"));
                sqlFactorytradefield.addParameter("userid", 1);
                sqlFactorytradefield.addParameter("itemid", itemid);
                sqlFactorytradefield.addParameter("tradefield", "建材家居");
                sqllist.add(sqlFactorytradefield.getSQL());

                sqllist.add(sqlFactory1.getSQL());
            }else {
                long itemid = itemRows.get(0).getLong("itemid");
                sqlFactory = new SQLFactory(this,"货品档案更新");
                sqlFactory.addParameter("itemid",itemid);
                sqlFactory.addParameter("sa_customschemeid", itemRows.get(0).getLong("sa_customschemeid"));
                Rows itemextendRows= dbConnect.runSqlQuery("select * from plm_itemextend where siteid='lsa' and itemid="+itemid);
                SQLFactory sqlFactory1;
                if(itemextendRows.isEmpty()){
                    sqlFactory1 = new SQLFactory(this, "货品档案-扩展新增");
                    sqlFactory1.addParameter("plm_itemextendid", createTableID("plm_itemextend"));
                }else {
                    sqlFactory1 = new SQLFactory(this, "货品档案-扩展更新");
                    sqlFactory1.addParameter("plm_itemextendid",itemextendRows.get(0).getLong("plm_itemextendid"));
                }
                sqlFactory1.addParameter("siteid", "lsa");
                sqlFactory1.addParameter("userid", 1);
                sqlFactory1.addParameter("username", createby);
                sqlFactory1.addParameter("itemid", itemid);
                sqlFactory1.addParameter("material", fbx);
                sqlFactory1.addParameter("pressure", "");
                sqlFactory1.addParameter("caliber", "");
                sqlFactory1.addParameter("butterflyplatedrive", "");
                sqlFactory1.addParameter("connection", "");
                sqlFactory1.addParameter("valveplatematerial", "");
                sqlFactory1.addParameter("bodymaterial", "");
                sqlFactory1.addParameter("actuatortype", "");
                sqlFactory1.addParameter("actuatorbrand", "");
                sqlFactory1.addParameter("isbutterfly", 0);
                sqlFactory1.addParameter("erpitemno",fitemno);
                sqlFactory1.addParameter("erpitemname", fitemname);
                sqlFactory1.addParameter("specalnote","");
                sqlFactory1.addParameter("prodline", "");
                sqlFactory1.addParameter("device", "");
                sqllist.add(sqlFactory1.getSQL());

            }
            sqlFactory.addParameter("siteid", "lsa");
            sqlFactory.addParameter("username",checkby);
            sqlFactory.addParameter("userid", 1);
            sqlFactory.addParameter("itemno", fitemno);
            if(unitRowsMap.containsKey(funitname)){
                sqlFactory.addParameter("unitid", unitRowsMap.get(funitname).get(0).getLong("unitid"));
            }else {
                sqlFactory.addParameter("unitid", 0);
            }
            sqlFactory.addParameter("isauxunit", 0);
            sqlFactory.addParameter("unitgroupid","null");

            sqlFactory.addParameter("itemname", fitemname);
            sqlFactory.addParameter("isonsale", 0);
            sqlFactory.addParameter("model", fmodel);
            sqlFactory.addParameter("spec", flong);
            // 订单起订量
            sqlFactory.addParameter("orderminqty", 1);
            // 订单增量
            sqlFactory.addParameter("orderaddqty", 1);
            // 订单起订量控制单位（0:主单位；1:辅助单位）
            sqlFactory.addParameter("orderminqty_auxunit", 0);
            // 订单增量控制单位（0:主单位；1:辅助单位）
            sqlFactory.addParameter("orderaddqty_auxunit", 0);
            // 说明
            sqlFactory.addParameter("remarks", "");
            // 商品条形码
            sqlFactory.addParameter("barcode", "");
            // 是否单品管理
            sqlFactory.addParameter("skucontrol",0);
            // 是否批次管理
            sqlFactory.addParameter("batchcontrol",0);
            // 毛重(g)
            sqlFactory.addParameter("grossweight", fgrossweight);
            // 净重(g)
            sqlFactory.addParameter("weight", fnetweight);
            // 高度(mm)
            sqlFactory.addParameter("height", 0);
            // 宽度(mm)
            sqlFactory.addParameter("width", 0);
            // 长度(mm)
            sqlFactory.addParameter("length", 0);
            // 交期
            sqlFactory.addParameter("delivery", 1);
            // 牌价
            sqlFactory.addParameter("marketprice", 0);
            // 是否工具
            sqlFactory.addParameter("istool", 0);
            // 产品标准
            sqlFactory.addParameter("standards",fspec);
            // 库存缺货标准
            sqlFactory.addParameter("stockstatus2", 1);
            // 库存充足标准
            sqlFactory.addParameter("stockstatus1", 1);
            // 保修期（年）
            sqlFactory.addParameter("warrantyday", fwarrantyday);
            // 是否营销物料
            sqlFactory.addParameter("iswuliao",1);
            // 是否服务物料
            sqlFactory.addParameter("isservice", 0);

            sqlFactory.addParameter("color", fcolour);
            sqlFactory.addParameter("cheek", fbk);
            sqlFactory.addParameter("iscustomsize", fisdz);

            sqlFactory.addParameter("delistingstatus","");
            sqlFactory.addParameter("marketingcategory","");
            sqlFactory.addParameter("customprice",0);


            sqlFactory.addParameter("ismodule", 0);
            sqlFactory.addParameter("packageqty", fpackingqty);
            sqlFactory.addParameter("iswoodproducts", 0);

            sqlFactory.addParameter("financeclasstype","");
            sqlFactory.addParameter("stockno","");
            sqlFactory.addParameter("volume", 0);
            sqlFactory.addParameter("k3outcode", foutitemno);

            if(fisdz.equals("1")){
                sqlFactory.addParameter("widthschemeid",1);
                sqlFactory.addParameter("lengthschemeid", 1);
                sqlFactory.addParameter("pricingmetod", 1);

            }else{
                sqlFactory.addParameter("widthschemeid",0);
                sqlFactory.addParameter("lengthschemeid", 0);
                sqlFactory.addParameter("pricingmetod", 2);

            }
            if ("1".equals(isdelete)) {
                sqlFactory.addParameter("remarks", "K3已删除");
            } else {
                sqlFactory.addParameter("remarks", "");
            }
            sqlFactory.addParameter("description", "K3");
            sqllist.add(sqlFactory.getSQL());
        } catch (Exception e) {
            e.printStackTrace();
            msg = e.getMessage();
            code = 0;
        }
        dbConnect.runSqlUpdate(sqllist);

        JSONObject returnObject=new JSONObject();
        returnObject.put("msg", msg);
        returnObject.put("code", code);
        return returnObject.toString();
    }
}