java版Spring Cloud Mybatis uniapp 社区电商 短视频带货 直播带货商城源码 多商家入驻商城 saas电商 b2b2c电商 供应链电商 小程序电商 app电商 多支付通道

java版Spring Cloud Mybatis uniapp 社区电商 短视频带货 直播带货商城源码 多商家入驻商城 saas电商 b2b2c电商 供应链电商 小程序电商 app电商 多支付通道

@源码地址来源： .html

package com.ller;DateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.util.Map;import javax.servlet.http.HttpServletRequest;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;llect.Maps;
import com.honghu.cloud.bean.Store;
import com.de.ResponseCode;
import com.honghu.cloud.dto.AccessoryDto;
import com.honghu.cloud.dto.OrderFormDto;
import com.honghu.cloud.dto.PayoffLogDto;
import com.honghu.cloud.dto.SysConfigDto;
import com.honghu.cloud.dto.UserDto;
import com.honghu.cloud.feign.AccessoryFeignClient;
import com.honghu.cloud.feign.OrderFormFeignClient;
import com.honghu.cloud.feign.PayoffLogFeignClient;
import com.honghu.cloud.feign.SysConfigFeignClient;
import com.honghu.cloud.feign.UserFeignClient;
import com.honghu.cloud.service.impl.StoreServiceImpl;
import com.ls.QueryTools;
import com.ls.SecurityUserHolder;
import com.honghu.cloud.utils.CommUtil;import net.sf.json.JSONObject;@RestController
@CrossOrigin(origins = "*" , maxAge = 3600)
@RequestMapping("/applet/store_payoff")
public class AppletStorePayoffController {@Autowiredprivate SysConfigFeignClient sysConfigFeignClient;@Autowiredprivate StoreServiceImpl storeService;@Autowiredprivate QueryTools queryTools;@Autowiredprivate UserFeignClient userFeignClient;@Autowiredprivate PayoffLogFeignClient payoffLogFeignClient;@Autowiredprivate OrderFormFeignClient orderFormFeignClient;@Autowiredprivate AccessoryFeignClient accessoryFeignClient;/*** 结算列表页* @param request* @param response* @param currentPage* @param orderBy* @param orderType* @param beginTime* @param endTime* @param pl_sn* @param order_id* @param status* @return*/@RequestMapping(value = { "/payofflog_list" } , method = RequestMethod.POST)public Map<String , Object> payofflog_list(HttpServletRequest request,@RequestBody JSONObject json) {String currentPage = json.optString("currentPage");String orderBy = json.optString("orderBy");String orderType = json.optString("orderType");String beginTime = json.optString("beginTime"); String endTime = json.optString("endTime");String pl_sn = json.optString("pl_sn");String order_id = json.optString("order_id");String status = json.optString("status");Map<String , Object> map = wHashMap();Map<String,Object> maps= Params(currentPage,20, orderBy, orderType);if ((pl_sn != null) && (!pl_sn.equals(""))) {maps.put("pl_sn", pl_sn);map.put("pl_sn", pl_sn);}if ((order_id != null) && (!order_id.equals(""))) {maps.put("order_id", order_id);map.put("order_id", order_id);}if ((beginTime != null) && (!beginTime.equals(""))) {maps.put("add_Time_more_than_equal", CommUtil.formatDate(beginTime));map.put("beginTime", beginTime);}if ((endTime != null) && (!endTime.equals(""))) {maps.put("add_Time_less_than_equal", CommUtil.formatDate(endTime));map.put("endTime", endTime);}if ((status != null) && (!status.equals(""))) {if (status.equals("not")) {maps.put("status", 0);}if (status.equals("ok")) {maps.put("status", 1);}if (status.equals("underway")) {maps.put("status_1", 3);maps.put("status_2", 4);}if (status.equals("already")) {maps.put("status", 6);}} else {status = "not";}/*maps.put("status", Integer.valueOf(st));*/map.put("status", status);UserDto user = this.userFeignClient.CurrentUser(request).getId());if(user == null){return ResponseCode.buildReturnMap(ResponseCode.TOKEN_EXPIRE, null);}if (Parent_id()!=null) {user = this.userFeignClient.Parent_id());}Store store = this.storeService.selectByPrimaryKey(CommUtil.Store_id()));if(store == null){return ResponseCode.buildReturnMap(ResponseCode.NOTSTORE, null);}maps.put("seller_id", Id());/*IPageList pList = this.payoffLogService.list(maps);*/map.putAll(payoffLogFeignClient.list(maps));Calendar a = Instance();a.set(5, 1);a.roll(5, -1);int maxDate = a.get(5);List<Integer> list = new ArrayList<>();for (int i = 1; i <= maxDate; i++) {list.add(Integer.valueOf(i));}SysConfigDto obj = SysConfig();String select = Payoff_count());String[] str = select.split(",");String ms = "";for (int i = 0; i < str.length; i++) {if (i + 1 == str.length) {ms = ms + str[i] + "日";} else {ms = ms + str[i] + "日、";}}map.put("payoff_mag_default", "今天是"+ DateInstance(0).format(new Date())+ "，本月的结算日期为" + ms + "，请于结算日申请结算。");return ResponseCode.buildSuccessMap(map);}private String getSelectedDate(int payoff_count) {Calendar a = Instance();a.set(5, 1);a.roll(5, -1);int allDate = a.get(5);String selected = "";if (payoff_count == 1) {selected = CommUtil.null2String(Integer.valueOf(allDate));} else if (payoff_count == 2) {if (allDate == 31) {selected = "15,31";}if (allDate == 30) {selected = "15,30";}if (allDate == 29) {selected = "14,29";}if (allDate == 28) {selected = "14,28";}} else if (payoff_count == 3) {if (allDate == 31) {selected = "10,20,31";}if (allDate == 30) {selected = "10,20,30";}if (allDate == 29) {selected = "10,20,29";}if (allDate == 28) {selected = "10,20,28";}} else if (payoff_count == 4) {if (allDate == 31) {selected = "7,14,21,31";}if (allDate == 30) {selected = "7,14,21,30";}if (allDate == 29) {selected = "7,14,21,29";}if (allDate == 28) {selected = "7,14,21,28";}}return selected;}/*** 可结算列表页* @param request* @param response* @param currentPage* @param orderBy* @param orderType* @param beginTime* @param endTime* @param pl_sn* @param order_id* @return*/@RequestMapping(value = { "/payofflog_ok_list" } , method = RequestMethod.POST)public Map<String , Object> payofflog_ok_list(HttpServletRequest request,@RequestBody JSONObject json) {String currentPage = json.optString("currentPage");String orderBy = json.optString("orderBy");String orderType = json.optString("orderType");String beginTime = json.optString("beginTime"); String endTime = json.optString("endTime");String pl_sn = json.optString("pl_sn");String order_id = json.optString("order_id");Map<String , Object> data = wHashMap();Map<String,Object> maps= Params(currentPage, 20,orderBy, orderType);if ((pl_sn != null) && (!pl_sn.equals(""))) {maps.put("pl_sn", pl_sn);data.put("pl_sn", pl_sn);}if ((order_id != null) && (!order_id.equals(""))) {maps.put("order_id", order_id);data.put("order_id", order_id);}if ((beginTime != null) && (!beginTime.equals(""))) {maps.put("add_Time_more_than_equal", CommUtil.formatDate(beginTime));data.put("beginTime", beginTime);}if ((endTime != null) && (!endTime.equals(""))) {maps.put("add_Time_less_than_equal", CommUtil.formatDate(endTime));data.put("endTime", endTime);}maps.put("status" , 1); // 可结算状态UserDto user = this.userFeignClient.CurrentUser(request).getId());if(user == null){return ResponseCode.buildReturnMap(ResponseCode.TOKEN_EXPIRE, null);}if (Parent_id()!=null) {user = this.userFeignClient.Parent_id());}Store store = this.storeService.selectByPrimaryKey(CommUtil.Store_id()));if(store == null){return ResponseCode.buildReturnMap(ResponseCode.NOTSTORE, null);}maps.put("seller_id", Id());data.putAll(this.payoffLogFeignClient.list(maps));Calendar a = Instance();a.set(5, 1);a.roll(5, -1);int maxDate = a.get(5);List<Integer> list = new ArrayList<>();for (int i = 1; i <= maxDate; i++) {list.add(Integer.valueOf(i));}SysConfigDto obj = SysConfig();String select = Payoff_count());String[] str = select.split(",");String ms = "";for (int i = 0; i < str.length; i++) {if (i + 1 == str.length) {ms = ms + str[i] + "日";} else {ms = ms + str[i] + "日、";}}data.put("payoff_mag_default", "今天是"+ DateInstance(0).format(new Date())+ "，本月的结算日期为" + ms + "，请于结算日申请结算。");return ResponseCode.buildSuccessMap(data);}/*** 账单详情* @param request* @param response* @param id* @param currentPage* @param op* @return*/@RequestMapping( value = { "/payofflog_info" } , method = RequestMethod.POST)public Map<String , Object> payofflog_info(HttpServletRequest request,@RequestBody JSONObject json) {String id = json.optString("id"); String currentPage = json.optString("currentPage"); String op = json.optString("op"); if ((id != null) && (!id.equals(""))) {PayoffLogDto payofflog = this.payoffLogFeignClient.selectByPrimaryKey(Long.valueOf(Long.parseLong(id)));if (null!=payofflog&&null!&#Voucher_photo_id()) {AccessoryDto accessoryDto = accessoryFeignClient.Voucher_photo_id());payofflog.setVoucher_photo(accessoryDto);}UserDto user = this.userFeignClient.CurrentUser(request).getId());if(user == null){return ResponseCode.buildReturnMap(ResponseCode.TOKEN_EXPIRE, null);}if (Parent_id()!=null) {user = this.userFeignClient.Parent_id());}Store store = this.storeService.selectByPrimaryKey(CommUtil.Store_id()));if(store == null){return ResponseCode.buildReturnMap(ResponseCode.NOTSTORE, null);}Map<String , Object> data = wHashMap();if (Id().Seller_id())) {data.put("OrderFormDto", Order_id(),Id()));data.put("obj", payofflog);data.put("currentPage", currentPage);data.put("op", op);return ResponseCode.buildSuccessMap(data);} else {return ResponseCode.buildReturnMap(ResponseCode.PARAM_ERROR, null);}} else {return ResponseCode.buildReturnMap(ResponseCode.PARAM_ERROR, null);}}public OrderFormDto queryOrderInfo(String order_id,Long user_id) {OrderFormDto of = new OrderFormDto();if ((order_id != null) && (!order_id.equals(""))) {UserDto user = this.userFeignClient.selectByPrimaryKey(CommUtil.null2Long(user_id));Map<String, Object> params = wHashMap();params.put("order_id", order_id);params.put("store_id", Store_id());params.put("orderBy", "addTime");params.put("orderType", "asc");params.put("currentPage", 0);params.put("pageSize", 1);List<OrderFormDto> ofs = derFormFeignClient.queryPageList(params);if (null != ofs && ofs.size() > 0) {of = (0);}}return of;}/*** 账单结算* @param request* @param response* @param mulitId* @param currentPage* @return*/@RequestMapping(value = { "/payofflog_edit" } , method = RequestMethod.POST)public Map<String , Object> payofflog_edit(HttpServletRequest request,@RequestBody JSONObject json) {String mulitId = json.optString("mulitId");for (String id : mulitId.split(",")) {if ((id != null) && (!id.equals(""))) {PayoffLogDto obj = this.payoffLogFeignClient.selectByPrimaryKey(CommUtil.null2Long(id));if (obj != null) {UserDto user = this.userFeignClient.CurrentUser(request).getId());if(user == null){return ResponseCode.buildReturnMap(ResponseCode.TOKEN_EXPIRE, null);}if (Parent_id()!=null) {user = this.userFeignClient.Parent_id());}Store store = this.storeService.selectByPrimaryKey(CommUtil.Store_id()));if(store == null){return ResponseCode.buildReturnMap(ResponseCode.NOTSTORE, null);}if ((Id().toString().Seller_id().toString()))&& (Status() == 1 || Status() == 0)) {OrderFormDto of = derFormFeignClient.selectByPrimaryKey(CommUtil.O_id()));if (of != null) {boolean goods = false;//商品购买boolean group = false;//团购也就是生活类订单//of.getOrder_status() == 50 为买家评价完//of.getOrder_status() == 65 为订单不可评价if ((of.getOrder_status() == 40) || (of.getOrder_status() == 50) || (of.getOrder_status() == 65)) {goods = true;}//of.getOrder_cat() == 2 为生活类订单//of.getOrder_status() == 20为为已付款待发货if ((of.getOrder_cat() == 2) && (of.getOrder_status() == 20)) {group = true;}if ((goods) || (group)) {obj.setStatus(3);obj.setApply_time(new Date());this.payoffLogFeignClient.updateById(obj);return ResponseCode.buildSuccessMap(null);}}else{return ResponseCode.buildReturnMap(ResponseCode.ORDER_NOT_EXISTS_ERROR, null);}}}}}return ResponseCode.buildReturnMap(ResponseCode.FAILURE, null);//return ResponseCode.buildSuccessMap(null);}/*** 批量统计* @param request* @param response* @param mulitId* @throws ClassNotFoundException*/@RequestMapping(value = { "/payofflog_ajax" } , method = RequestMethod.POST)public Map<String , Object> payofflog_ajax(HttpServletRequest request,@RequestBody JSONObject json)throws ClassNotFoundException {String mulitId = json.optString("mulitId");if (mulitId == null) {mulitId = "";}String[] ids = mulitId.split(",");double order_total_price = 0.0D;double commission_amount = 0.0D;double total_amount = 0.0D;boolean error = true;for (String id : ids) {if (!id.equals("")) {PayoffLogDto obj = this.payoffLogFeignClient.selectByPrimaryKey(Long.parseLong(id));if (obj != null) {UserDto user = this.userFeignClient.CurrentUser(request).getId());if(user == null){return ResponseCode.buildReturnMap(ResponseCode.TOKEN_EXPIRE, null);}if (Parent_id()!=null) {user = this.userFeignClient.Parent_id());}Store store = this.storeService.selectByPrimaryKey(CommUtil.Store_id()));if(store == null){return ResponseCode.buildReturnMap(ResponseCode.NOTSTORE, null);}if (Id().Seller_id())) {total_amount = CommUtil.add(Double.valueOf(total_amount), Total_amount());commission_amount = CommUtil.add(Double.valueOf(commission_amount), Commission_amount());order_total_price = CommUtil.add(Double.valueOf(order_total_price), Order_total_price());} else {error = false;break;}} else {error = false;break;}}}Map<String, Object> map = wHashMap();map.put("order_total_price", Double.valueOf(order_total_price));map.put("commission_amount", Double.valueOf(commission_amount));map.put("total_amount", Double.valueOf(total_amount));map.put("error", Boolean.valueOf(error));return map;}/*** 账单数据导出* @param request* @param response* @param beginTime* @param endTime* @param pl_sn* @param order_id* @param status*//*@RequestMapping(value = { "/payofflog_excel" } ,method = RequestMethod.POST)public void payofflog_excel(HttpServletRequest request,HttpServletResponse response ,@RequestBody JSONObject json) {String beginTime = json.optString("beginTime");String endTime = json.optString("endTime");String pl_sn = json.optString("pl_sn");String order_id = json.optString("order_id");String status = json.optString("status");UserDto user = this.userFeignClient.CurrentUser(request).getId());user = Parent() == null ? user : Parent();Map<String,Object> maps= Params(null,100000, "addTime", "desc");maps.put("seller_id", Id());String status2 = "0";if ((status != null) && (!status.equals(""))) {status2 = CommUtil.null2String(status);}if ((pl_sn != null) && (!pl_sn.equals(""))) {maps.put("pl_sn", pl_sn);}if ((order_id != null) && (!order_id.equals(""))) {maps.put("order_id", order_id);}if ((beginTime != null) && (!beginTime.equals(""))) {maps.put("add_Time_more_than_equal", CommUtil.formatDate(beginTime));}if ((endTime != null) && (!endTime.equals(""))) {maps.put("add_Time_less_than_equal", CommUtil.formatDate(endTime));}int st = 0;if ((status != null) && (!status.equals(""))) {if (status.equals("not")) {st = 0;}if (status.equals("underway")) {st = 3;}if (status.equals("already")) {st = 6;}} else {status = "not";}maps.put("status", st);SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");Calendar c = Instance();c.add(2, 0);c.set(5, 1);String first = format.Time());Calendar ca = Instance();ca.set(5, ca.getActualMaximum(5));String last = format.Time());Map<String, Object> list = this.payoffLogFeignClient.list(maps);if (("result") != null) {List<PayoffLogDto> datas = (List<PayoffLogDto>) ("result");HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("结算账单");HSSFPatriarch patriarch = ateDrawingPatriarch();List<HSSFClientAnchor> anchor = new ArrayList<>();for (int i = 0; i < datas.size(); i++) {anchor.add(new HSSFClientAnchor(0, 0, 1000, 255, (short) 1,2 + i, (short) 1, 2 + i));}sheet.setColumnWidth(0, 6000);sheet.setColumnWidth(1, 4000);sheet.setColumnWidth(2, 4000);sheet.setColumnWidth(3, 6000);sheet.setColumnWidth(4, 6000);sheet.setColumnWidth(5, 6000);sheet.setColumnWidth(6, 6000);sheet.setColumnWidth(7, 6000);sheet.setColumnWidth(8, 6000);sheet.setColumnWidth(9, 6000);sheet.setColumnWidth(10, 6000);sheet.setColumnWidth(11, 8000);HSSFFont font = wb.createFont();font.setFontName("Verdana");font.setBoldweight((short) 100);font.setFontHeight((short) 300);font.setColor((short) 12);HSSFCellStyle style = wb.createCellStyle();style.setAlignment((short) 2);style.setVerticalAlignment((short) 1);style.setFillForegroundColor((short) 41);style.setFillPattern((short) 1);style.setBottomBorderColor((short) 10);style.setBorderBottom((short) 1);style.setBorderLeft((short) 1);style.setBorderRight((short) 1);style.setBorderTop((short) 1);style.setFont(font);HSSFRow row = ateRow(0);row.setHeight((short) 500);HSSFCell cell = ateCell(0);sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 11));cell.setCellStyle(style);String title = "结算账单";String time = CommUtil.null2String(CommUtil.formatDate(beginTime)+ " - " + CommUtil.formatDate(endTime));cell.setCellValue(SysConfig().getTitle()+ title + "（" + time + "）");HSSFCellStyle style1 = wb.createCellStyle();style1.BuiltinFormat("yyyy-mm-dd"));style1.setWrapText(true);style1.setAlignment((short) 2);HSSFCellStyle style2 = wb.createCellStyle();style2.setAlignment((short) 2);row = ateRow(1);cell = ateCell(0);cell.setCellStyle(style2);cell.setCellValue("账单流水号");cell = ateCell(1);cell.setCellStyle(style2);cell.setCellValue("商家名称");cell = ateCell(2);cell.setCellStyle(style2);cell.setCellValue("账单说明");cell = ateCell(3);cell.setCellStyle(style2);cell.setCellValue("账单入账时间");cell = ateCell(4);cell.setCellStyle(style2);cell.setCellValue("申请结算时间");cell = ateCell(5);cell.setCellStyle(style2);cell.setCellValue("完成结算时间");cell = ateCell(6);cell.setCellStyle(style2);cell.setCellValue("账单总金额（元）");cell = ateCell(7);cell.setCellStyle(style2);cell.setCellValue("账单总佣金（元）");cell = ateCell(8);cell.setCellStyle(style2);cell.setCellValue("账单应结算（元）");cell = ateCell(9);cell.setCellStyle(style2);cell.setCellValue("操作财务");cell = ateCell(10);cell.setCellStyle(style2);cell.setCellValue("操作管理员");cell = ateCell(11);cell.setCellStyle(style2);cell.setCellValue("结算备注");double all_order_price = 0.0D;double all_commission_amount = 0.0D;double all_total_amount = 0.0D;for (int j = 2; j <= datas.size() + 1; j++) {row = ateRow(j);int i = 0;cell = ateCell(i);cell.setCellStyle(style2);cell.setCellValue(((PayoffLogDto) (j - 2)).getPl_sn());cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(((PayoffLogDto) (j - 2)).getSeller().getUserName());cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(((PayoffLogDto) (j - 2)).getPl_info());cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(CommUtil.formatLongDate(((PayoffLogDto) (j - 2)).getAddTime()));cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(CommUtil.formatLongDate(((PayoffLogDto) (j - 2)).getApply_time()));cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(CommUtil.formatLongDate(((PayoffLogDto) (j - 2)).getComplete_time()));cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(CommUtil.null2String(((PayoffLogDto) (j - 2)).getOrder_total_price()));all_order_price = CommUtil.add(Double.valueOf(all_order_price),((PayoffLogDto) (j - 2)).getOrder_total_price());cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(CommUtil.null2String(((PayoffLogDto) (j - 2)).getCommission_amount()));all_commission_amount = CommUtil.add(Double.valueOf(all_commission_amount),((PayoffLogDto) (j - 2)).getCommission_amount());cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(CommUtil.null2String(((PayoffLogDto) (j - 2)).getTotal_amount()));all_total_amount = CommUtil.add(Double.valueOf(all_total_amount),((PayoffLogDto) (j - 2)).getTotal_amount());cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(CommUtil.null2String(((PayoffLogDto) (j - 2)).getFinance_userName()));cell = ateCell(++i);cell.setCellStyle(style2);if (((PayoffLogDto) (j - 2)).getAdmin() != null) {cell.setCellValue(CommUtil.null2String(((PayoffLogDto) (j - 2)).getAdmin().getUserName()));}cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(CommUtil.null2String(((PayoffLogDto) (j - 2)).getPayoff_remark()));}int m = datas.size() + 2;row = ateRow(m);int i = 0;cell = ateCell(i);cell.setCellStyle(style2);cell.setCellValue("总计");cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue("本次总销售金额：");cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(all_order_price);cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue("本次总销售佣金：");cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(all_commission_amount);cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue("本次总结算金额：");cell = ateCell(++i);cell.setCellStyle(style2);cell.setCellValue(all_total_amount);SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");String excel_name = sdf.format(new Date());try {String path = Session().getServletContext().getRealPath("")+ File.separator + "excel";response.setContentType("application/x-download");response.addHeader("Content-Disposition","attachment;filename=" + excel_name + ".xls");OutputStream os = OutputStream();wb.write(os);os.close();} catch (FileNotFoundException e) {} catch (IOException e) {}}}*/}