1016 Phone Bills

博客提及了15分的代码、22分的代码以及AC代码,还提到参考了柳神的代码,体现出与大佬代码水平的差距。

15分的代码

#include<bits/stdc++.h>
using namespace std;
struct Node{
	string name;
	int month;
	int time;
	int flag;
};
int ansday=0;
vector<int> rate;
bool cmp(Node a,Node b){
	if(a.name!=b.name) return a.name<b.name;
	else return a.time<b.time;
}
double getmoney(int start,int end){
	int day1=start/(24*60);
	int hour1=start%(24*60)/60;
	int minute1=start%(24*60)%60;
	int day2=end/(24*60);
	int hour2=end%(24*60)/60;
	int minute2=end%(24*60)%60;
	double ans=0;
	if(day1==day2){
		for(int i=hour1;i<=hour2;i++){
			if(i==hour1){
				ans+=rate[i]*(60-minute1);
			}else if(i!=hour2){
				ans+=rate[i]*60;
			}else if(i==hour2){
				ans+=rate[i]*minute2;
			}
		}
		return ans/(100*1.0);
	}else{
		if(end-start>(24*60)){
			ans+=(end-start)/(24*60)*ansday;
			for(int i=hour1;i<=hour2;i++){
				if(i==hour1){
					ans+=rate[i]*(60-minute1);
				}else if(i!=hour2){
					ans+=rate[i]*60;
				}else if(i==hour2){
					ans+=rate[i]*minute2;
				}
			}
			return ans/(100*1.0);
		}else if(end-start==(24*60)){
			ans+=(end-start)/(24*60)*ansday;
			return ans/(100*1.0);
		}else if(end-start<(24*60)){
			for(int i=hour2;i<=hour1;i++){
				if(i==hour2){
					ans+=rate[i]*(60-minute2);
				}else if(i!=hour1){
					ans+=rate[i]*60;
				}else if(i==hour1){
					ans+=rate[i]*minute1;
				}
			}
			return ans/(100*1.0);
		}
	}
	
}
int main()
{
	freopen("in.txt","r",stdin);//freopen("out.txt","w",stdout);
	rate.resize(24);
	for(int i=0;i<24;i++){
		cin>>rate[i];
		ansday+=rate[i]*60;
	}
	int n;cin>>n;vector<Node> ppp;ppp.resize(n);
	for(int i=0;i<n;i++){
		cin>>ppp[i].name;
		int month1,day1,hour1,minute1;
		scanf("%d:%d:%d:%d",&month1,&day1,&hour1,&minute1);
		ppp[i].month=month1;
		ppp[i].time=day1*24*60+hour1*60+minute1;
		string status;
		cin>>status;
		if(status=="on-line"){
			ppp[i].flag=1;
		}else{
			ppp[i].flag=0;
		}
	}
	sort(ppp.begin(),ppp.end(),cmp);
	vector<Node> temp;
	for(int i=1;i<ppp.size();i++){
		if(ppp[i].name==ppp[i-1].name&&(ppp[i-1].flag==1&&ppp[i].flag==0)){
			temp.push_back(ppp[i-1]);
			temp.push_back(ppp[i]);
		}
	}
	map<string,int> sign;
    map<string,double> hash;int sign1=0;
	for(int i=0;i<temp.size();i+=2){
		if(sign[temp[i].name]==0){
			cout<<temp[i].name;printf(" %02d\n",temp[i].month);
			sign[temp[i].name]=1;
		}
		printf("%02d:%02d:%02d %02d:%02d:%02d ",temp[i].time/(24*60),temp[i].time%(24*60)/60,temp[i].time%(24*60)%60,temp[i+1].time/(24*60),temp[i+1].time%(24*60)/60,temp[i+1].time%(24*60)%60);
		printf("%d $%.2lf\n",temp[i+1].time-temp[i].time,getmoney(temp[i].time,temp[i+1].time));
        hash[temp[i].name]+=getmoney(temp[i].time,temp[i+1].time);
        if(i+2<temp.size()&&hash[temp[i+2].name]==0){
            printf("Total amount: $%.2lf\n",hash[temp[i].name]);sign1=1;
        }
        if(i==temp.size()-2&&sign1==1){
            printf("Total amount: $%.2lf\n",getmoney(temp[i].time,temp[i+1].time));
        }
	}
	return 0;
}

22分的代码

#include<bits/stdc++.h>
using namespace std;
struct Node{
	string name;
	int month;
	int time;
	int flag;
};
int ansday=0;
vector<int> rate;
bool cmp(Node a,Node b){
	if(a.name!=b.name) return a.name<b.name;
	else return a.time<b.time;
}
double getmoney(int start,int end){
	int day1=start/(24*60);
	int hour1=start%(24*60)/60;
	int minute1=start%(24*60)%60;
	int day2=end/(24*60);
	int hour2=end%(24*60)/60;
	int minute2=end%(24*60)%60;
	double ans=0,ans1=0,ans2=0;
	ans1+=rate[hour1]*minute1+ansday*day1;
	ans2+=rate[hour2]*minute2+ansday*day2;
	for(int i=0;i<hour1;i++){
		ans1+=rate[i]*60;
	}
	for(int i=0;i<hour2;i++){
		ans2+=rate[i]*60;
	}
	return (ans2-ans1)/100.0;
}
int main()
{
	freopen("in.txt","r",stdin);//freopen("out.txt","w",stdout);
	rate.resize(24);
	for(int i=0;i<24;i++){
		cin>>rate[i];
		ansday+=rate[i]*60;
	}
	int n;cin>>n;vector<Node> ppp;ppp.resize(n);
	for(int i=0;i<n;i++){
		cin>>ppp[i].name;
		int month1,day1,hour1,minute1;
		scanf("%d:%d:%d:%d",&month1,&day1,&hour1,&minute1);
		ppp[i].month=month1;
		ppp[i].time=day1*24*60+hour1*60+minute1;
		string status;
		cin>>status;
		if(status=="on-line"){
			ppp[i].flag=1;
		}else{
			ppp[i].flag=0;
		}
	}
	sort(ppp.begin(),ppp.end(),cmp);
	vector<Node> temp;
	for(int i=1;i<ppp.size();i++){
		if(ppp[i].name==ppp[i-1].name&&(ppp[i-1].flag==1&&ppp[i].flag==0)){
			temp.push_back(ppp[i-1]);
			temp.push_back(ppp[i]);
		}
	}
	map<string,int> sign;
    map<string,double> hash;int sign1=0;
	for(int i=0;i<temp.size();i+=2){
		if(sign[temp[i].name]==0){
			cout<<temp[i].name;printf(" %02d\n",temp[i].month);
			sign[temp[i].name]=1;
		}
		printf("%02d:%02d:%02d %02d:%02d:%02d ",temp[i].time/(24*60),temp[i].time%(24*60)/60,temp[i].time%(24*60)%60,temp[i+1].time/(24*60),temp[i+1].time%(24*60)/60,temp[i+1].time%(24*60)%60);
		printf("%d $%.2lf\n",temp[i+1].time-temp[i].time,getmoney(temp[i].time,temp[i+1].time));
        hash[temp[i].name]+=getmoney(temp[i].time,temp[i+1].time);
        if(i+2<temp.size()&&hash[temp[i+2].name]==0){
            printf("Total amount: $%.2lf\n",hash[temp[i].name]);sign1=1;
        }
        if(i==temp.size()-2&&sign1==1){
            printf("Total amount: $%.2lf\n",getmoney(temp[i].time,temp[i+1].time));
        }
	}
	return 0;
}

AC代码

#include<bits/stdc++.h>
using namespace std;
struct Node{
	string name;
	int month;
	int time;
	int flag;
};
int ansday=0;
vector<int> rate;
bool cmp(Node a,Node b){
	if(a.name!=b.name) return a.name<b.name;
	else return a.time<b.time;
}
double getmoney(int start,int end){
	int day1=start/(24*60);
	int hour1=start%(24*60)/60;
	int minute1=start%(24*60)%60;
	int day2=end/(24*60);
	int hour2=end%(24*60)/60;
	int minute2=end%(24*60)%60;
	double ans=0,ans1=0,ans2=0;
	ans1+=rate[hour1]*minute1+ansday*day1;
	ans2+=rate[hour2]*minute2+ansday*day2;
	for(int i=0;i<hour1;i++){
		ans1+=rate[i]*60;
	}
	for(int i=0;i<hour2;i++){
		ans2+=rate[i]*60;
	}
	return (ans2-ans1)/100.0;
}
int main()
{
	freopen("in.txt","r",stdin);//freopen("out.txt","w",stdout);
	rate.resize(24);
	for(int i=0;i<24;i++){
		cin>>rate[i];
		ansday+=rate[i]*60;
	}
	int n;cin>>n;vector<Node> ppp;ppp.resize(n);
	for(int i=0;i<n;i++){
		cin>>ppp[i].name;
		int month1,day1,hour1,minute1;
		scanf("%d:%d:%d:%d",&month1,&day1,&hour1,&minute1);
		ppp[i].month=month1;
		ppp[i].time=day1*24*60+hour1*60+minute1;
		string status;
		cin>>status;
		if(status=="on-line"){
			ppp[i].flag=1;
		}else{
			ppp[i].flag=0;
		}
	}
	sort(ppp.begin(),ppp.end(),cmp);
	vector<Node> temp;map<string,vector<Node> > mp;
	for(int i=1;i<ppp.size();i++){
		if(ppp[i].name==ppp[i-1].name&&(ppp[i-1].flag==1&&ppp[i].flag==0)){
			temp.push_back(ppp[i-1]);
			temp.push_back(ppp[i]);
			mp[ppp[i].name].push_back(ppp[i-1]);
			mp[ppp[i].name].push_back(ppp[i]);
		}
	}
	for(auto it:mp){
		double tttt=0;
		cout<<it.first<<' ';
		vector<Node> temp=it.second;
		printf("%02d\n",temp[0].month);
		for(int i=0;i<temp.size();i+=2){
			printf("%02d:%02d:%02d %02d:%02d:%02d ",temp[i].time/(24*60),temp[i].time%(24*60)/60,temp[i].time%(24*60)%60,temp[i+1].time/(24*60),temp[i+1].time%(24*60)/60,temp[i+1].time%(24*60)%60);
			printf("%d $%.2lf\n",temp[i+1].time-temp[i].time,getmoney(temp[i].time,temp[i+1].time));
			tttt+=getmoney(temp[i].time,temp[i+1].time);
		}
		printf("Total amount: $%.2lf\n",tttt);
	}
	/*map<string,int> sign;
    map<string,double> hash;int sign1=0;
	for(int i=0;i<temp.size();i+=2){
		if(sign[temp[i].name]==0){
			cout<<temp[i].name;printf(" %02d\n",temp[i].month);
			sign[temp[i].name]=1;
		}
		printf("%02d:%02d:%02d %02d:%02d:%02d ",temp[i].time/(24*60),temp[i].time%(24*60)/60,temp[i].time%(24*60)%60,temp[i+1].time/(24*60),temp[i+1].time%(24*60)/60,temp[i+1].time%(24*60)%60);
		printf("%d $%.2lf\n",temp[i+1].time-temp[i].time,getmoney(temp[i].time,temp[i+1].time));
        hash[temp[i].name]+=getmoney(temp[i].time,temp[i+1].time);
        if(i+2<temp.size()&&hash[temp[i+2].name]==0){
            printf("Total amount: $%.2lf\n",hash[temp[i].name]);sign1=1;
        }
        if(i==temp.size()-2&&sign1==1){
            printf("Total amount: $%.2lf\n",getmoney(temp[i].time,temp[i+1].time));
        }
	}*/
	return 0;
}

参考柳神的代码(我与大佬差的不是一点,是两点~)

const handleExport = async () => { try { loading.value = true; // 格式化日期参数 const params = { billType: searchForm.billType, paymentStatus: searchForm.paymentStatus, accountId: searchForm.accountId, startDate: searchForm.dateRange?.[0] ? dayjs(searchForm.dateRange[0]).format("YYYY-MM-DD") : undefined, endDate: searchForm.dateRange?.[1] ? dayjs(searchForm.dateRange[1]).format("YYYY-MM-DD") : undefined, }; console.log("导出参数:", params); const response = await exportBill(params); console.log("响应数据:", response); // 处理Blob数据 const blob = new Blob([response.data], { type: response.headers["content-type"] || "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", }); // 创建下载链接 const url = window.URL.createObjectURL(blob); const link = document.createElement("a"); link.href = url; link.setAttribute( "download", `账单_${new Date().toISOString().slice(0, 10)}.xlsx` ); document.body.appendChild(link); link.click(); // 清理 setTimeout(() => { document.body.removeChild(link); window.URL.revokeObjectURL(url); }, 100); ElMessage.success("导出成功"); } catch (error) { console.error("导出错误详情:", error); // 处理后端返回的JSON错误信息 if ( error.response && error.response.data && error.response.data instanceof Blob ) { const reader = new FileReader(); reader.onload = () => { try { const errMsg = JSON.parse(reader.result).message; ElMessage.error(`导出失败: ${errMsg}`); } catch (e) { ElMessage.error("导出失败: 未知错误"); } }; reader.readAsText(error.response.data); } else { ElMessage.error(`导出失败: ${error.message || "未知错误"}`); } } finally { loading.value = false; } };@GetMapping("/exportBill") public void exportBill( @RequestParam(required = false) Integer billType, @RequestParam(required = false) Integer paymentStatus, @RequestParam(required = false) Long accountId, @RequestParam(required = false) String startDate, @RequestParam(required = false) String endDate, HttpServletResponse response) throws IOException { log.info("导出参数: billType={}, paymentStatus={}, accountId={}, startDate={}, endDate={}", billType, paymentStatus, accountId, startDate, endDate); try { // 1. 构建查询参数 BillExportReqDTO exportDTO = new BillExportReqDTO(); exportDTO.setBillType(billType); exportDTO.setPaymentStatus(paymentStatus); exportDTO.setAccountId(accountId); // 日期转换处理 if (StringUtils.isNotBlank(startDate)) { exportDTO.setStartDate(Date.valueOf(startDate)); } if (StringUtils.isNotBlank(endDate)) { exportDTO.setEndDate(Date.valueOf(endDate)); } // 2. 设置响应头 String fileName = "账单_" + LocalDate.now() + ".xlsx"; response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); response.setCharacterEncoding("UTF-8"); response.setHeader("Content-Disposition", "attachment;filename*=UTF-8''" + URLEncoder.encode(fileName, "UTF-8")); // 3. 导出Excel billService.exportBill(exportDTO, response.getOutputStream()); } catch (Exception e) { log.error("导出Excel失败", e); response.reset(); response.setContentType("application/json"); response.setCharacterEncoding("UTF-8"); response.getWriter().write(String.valueOf(Result.error("导出失败: " + e.getMessage()))); } } @Override public void exportBill(BillExportReqDTO exportDTO, OutputStream outputStream) { // 1. 查询数据 List<bills> bills = billMapper.selectBillsForExport(exportDTO); if (CollectionUtils.isEmpty(bills)) { throw new RuntimeException("没有可导出的数据"); } // 2. 导出Excel try (ExcelWriter excelWriter = EasyExcel.write(outputStream) .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) // 自动列宽 .build()) { WriteSheet writeSheet = EasyExcel.writerSheet("账单数据") .head(BillExcelRespDTO.class) .registerWriteHandler(new HorizontalCellStyleStrategy( getHeaderStyle(), getContentStyle())) // 自定义样式 .build(); // 3. 数据转换并写入Excel excelWriter.write(convertToExcelVO(bills), writeSheet); excelWriter.finish(); // 确保写入完成 } } private List<BillExcelRespDTO> convertToExcelVO(List<bills> bills) { return bills.stream().map(bill -> { BillExcelRespDTO vo = new BillExcelRespDTO(); // 这里进行属性拷贝 BeanUtils.copyProperties(bill, vo); // 特殊字段处理 vo.setPaymentStatus(String.valueOf(bill.getPaymentStatus())); return vo; }).collect(Collectors.toList()); } // 内容单元格样式 private WriteCellStyle getContentStyle() { WriteCellStyle style = new WriteCellStyle(); // 1. 对齐方式 style.setHorizontalAlignment(HorizontalAlignment.CENTER); // 水平居中 style.setVerticalAlignment(VerticalAlignment.CENTER); // 垂直居中 // 2. 边框设置 style.setBorderLeft(BorderStyle.THIN); // 左边框 style.setBorderRight(BorderStyle.THIN); // 右边框 style.setBorderTop(BorderStyle.THIN); // 上边框 style.setBorderBottom(BorderStyle.THIN); // 下边框 style.setLeftBorderColor(IndexedColors.GREY_50_PERCENT.getIndex()); // 边框颜色 style.setRightBorderColor(IndexedColors.GREY_50_PERCENT.getIndex()); style.setTopBorderColor(IndexedColors.GREY_50_PERCENT.getIndex()); style.setBottomBorderColor(IndexedColors.GREY_50_PERCENT.getIndex()); // 3. 背景色(默认白色,可不设置) style.setFillPatternType(FillPatternType.SOLID_FOREGROUND); style.setFillForegroundColor(IndexedColors.WHITE.getIndex()); // 4. 字体样式 WriteFont font = new WriteFont(); font.setFontName("宋体"); // 字体 font.setFontHeightInPoints((short) 11); // 字号 font.setColor(IndexedColors.BLACK.getIndex()); // 字体颜色 style.setWriteFont(font); // 5. 自动换行(根据需求) style.setWrapped(true); return style; } // 自定义表头样式 private WriteCellStyle getHeaderStyle() { WriteCellStyle style = new WriteCellStyle(); style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); style.setHorizontalAlignment(HorizontalAlignment.CENTER); // 其他样式设置... return style; }, <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.example.bankmanage.mapper.BillMapper"> <select id="selectBillsForExport" resultType="com.example.bankmanage.entity.bills"> SELECT * FROM bills <where> <if test="billType != null"> AND bill_type = #{billType} </if> <if test="paymentStatus != null"> AND payment_status = #{paymentStatus} </if> <if test="accountId != null"> AND account_id = #{accountId} </if> <if test="startDate != null"> AND due_date >= #{startDate} </if> <if test="endDate != null"> AND due_date <![CDATA[<=]]> #{endDate} </if> </where> ORDER BY due_date DESC </select> </mapper> package com.example.bankmanage.dto.resq; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.format.DateTimeFormat; import lombok.AllArgsConstructor; import lombok.Builder; import lombok.Data; import lombok.NoArgsConstructor; import java.math.BigDecimal; import java.sql.Date; @Data @NoArgsConstructor @AllArgsConstructor @Builder @SuppressWarnings("all") public class BillExcelRespDTO { @ExcelProperty("账单编号") private String billNo; @ExcelProperty("账户ID") private Long accountId; @ExcelProperty("账单类型") private String billType; @ExcelProperty("金额") private BigDecimal amount; @ExcelProperty("支付状态") private String paymentStatus; @ExcelProperty("创建时间") @DateTimeFormat("yyyy-MM-dd HH:mm:ss") private Date createTime; @ExcelProperty("支付时间") @DateTimeFormat("yyyy-MM-dd HH:mm:ss") private Date paymentTime; } 根据以上代码为什么我Excel导出指令不成功,请给我一个修正版
06-06
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值