zq-erp/src/main/java/com/matrix/system/hive/dao/SysOrderItemDao.java | ●●●●● patch | view | raw | blame | history | |
zq-erp/src/main/resources/mybatis/mapper/hive/SysOrderItemDao.xml | ●●●●● patch | view | raw | blame | history | |
zq-erp/src/main/resources/templates/views/admin/hive/beautySalon/order-form.html | ●●●●● patch | view | raw | blame | history | |
zq-erp/src/test/java/com/matrix/四月份家居产品业绩恢复.java | ●●●●● patch | view | raw | blame | history |
zq-erp/src/main/java/com/matrix/system/hive/dao/SysOrderItemDao.java
@@ -64,4 +64,6 @@ List<OrderDetailItemVo> selectApiOrderDetailItemsByOrderId(@Param("orderId") Long orderId); List<ErpOrderDetailItemVo> selectErpOrderItemByOrderId(String orderId); List<SysOrderItem> selectDgd(); } zq-erp/src/main/resources/mybatis/mapper/hive/SysOrderItemDao.xml
@@ -557,4 +557,11 @@ where a.ORDER_ID=#{orderId} </select> <!-- 临时数据处理sql --> <select id="selectDgd" resultMap="SysOrderItemMap"> SELECT a.* from sys_order_item a left join sys_order b on a.ORDER_ID=b.id where a.type='家居产品' and DATE_FORMAT(a.create_time,'%Y-%m')='2021-04' and b.company_id=17 and b.STATU='已付款'; </select> </mapper> zq-erp/src/main/resources/templates/views/admin/hive/beautySalon/order-form.html
@@ -947,7 +947,7 @@ // if (optionType != 1) { //直接修改支付金额不重置支付金额 item.payMoney = zkPrice * count; item.payMoney = (zkPrice * count).toFixed(2); // } _this.order.payMoney += parseFloat(item.payMoney); zq-erp/src/test/java/com/matrix/四月份家居产品业绩恢复.java
New file @@ -0,0 +1,61 @@ package com.matrix; import com.matrix.system.hive.bean.AchieveNew; import com.matrix.system.hive.bean.SysOrderItem; import com.matrix.system.hive.dao.AchieveNewDao; import com.matrix.system.hive.dao.SysOrderDao; import com.matrix.system.hive.dao.SysOrderItemDao; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import org.springframework.test.context.junit4.SpringRunner; import java.util.List; /** * 测试类示例 * * @author jiangyouyao * @email 512061637@qq.com * @date 2019年2月25日 */ @RunWith(SpringRunner.class) @SpringBootTest(classes = {ZqErpApplication.class}, webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT) public class 四月份家居产品业绩恢复 { @Autowired SysOrderDao sysOrderDao; @Autowired SysOrderItemDao itemDao; @Autowired AchieveNewDao achieveNewDao; @Test public void recoverAchieve() { AchieveNew queryAchieve=new AchieveNew(); List<SysOrderItem> items = itemDao.selectDgd(); for (SysOrderItem item : items) { if(item.getType().equals("家居产品")){ queryAchieve.setOrderItemId(item.getId()); List<AchieveNew> achieveNews = achieveNewDao.selectByModel(queryAchieve); for (AchieveNew achieve : achieveNews) { if(achieve.getHisConsume()==null){ achieve.setHisConsume(achieve.getGoodsCash()); achieveNewDao.updateByModel(achieve); System.out.println("更新业绩"+achieve.getId()); } } } } } }