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

package restcontroller.webmanage.lsak3.order;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import common.Controller;
import common.YosException;
import common.annotation.API;
import common.data.Row;
import common.data.Rows;
import restcontroller.R;

import java.util.ArrayList;

public class order extends Controller {
    /**
     * 构造函数
     *
     * @param content
     */
    public order(JSONObject content) throws YosException {
        super(content);
    }

    /**
     * 获取DRP订单
     *
     * @return
     */
    @API(title = "k3获取销售订单", apiversion = R.ID20230715090203.v1.class,accesstoken = false)
    public String getSaorder() throws  YosException{

        Rows rows = dbConnect.runSqlQuery("select t2.k3outcode fk3outcode,t1.updatek3flag fupdatek3flag,t1.sonum fsonum,t1.sa_orderid saorderid,t1.createby,t1.billdate fdate,t2.agentnum fagentnum,t1.remarks fnotes from sa_order t1 inner join sa_agents t2 on t1.sys_enterpriseid=t2.sys_enterpriseid and t1.siteid=t2.siteid  where (t1.updatek3flag='0' or t1.updatek3flag='2') and t1.createby !='LSA总0001' and t1.siteid='lsa1986'");
        for (Row row : rows) {
            String sa_orderid = row.getString("sa_orderid");
            Rows detailRows = dbConnect.runSqlQuery("select t2.k3outcode fk3outcode,t1.sa_orderitemsid saorderdetailid,convert(t1.defaultamount,char) as ftaxamount,t2.itemno fitemno,t1.qty fqty,t1.price frateprice,t1.defaultprice fprice,t1.amount famount,t1.remarks fnotes,t1.customproperties,t2.spec flong from sa_orderitems t1 inner join plm_item t2 on t1.itemid=t2.itemid where sa_orderid='" + sa_orderid + "'  and t1.siteid='lsa1986'");
            row.put("saorderdetail", detailRows.toJsonArray());
        }
        if(rows.isEmpty()) {
            JSONArray array = new JSONArray();
            return array.toString();
        }
        return rows.toJsonArray().toString();
    }

    /**
     * 获取DRP订单返回成功消息
     *
     * @return
     */
    @API(title = "获取DRP订单返回成功消息", apiversion = R.ID20230715090703.v1.class,accesstoken = false)
    public String getSaorderFeedBack() throws  YosException{
        JSONArray idsarray = content.getJSONArray("ids");
        ArrayList<String> sqllist = new ArrayList<>();
        for (Object object:idsarray) {
            String id = (String) object;
            sqllist.add("update sa_order set updatek3flag='1' where siteid='lsa' and  sa_orderid=" + id);
        }


        int count =dbConnect.runSqlUpdate(sqllist);
        JSONObject returnObject =new JSONObject();
        if (count>0) {
            returnObject.put("msg", "");
            returnObject.put("code", 1);
        } else {
            returnObject.put("msg", "true");
            returnObject.put("code", 0);
        }
        return returnObject.toString();
    }
}