/**
* 表格时间格式化
*/exportfunctionformatDate(cellValue){if(cellValue ==null|| cellValue =="")return"";var date =newDate(cellValue);var year = date.getFullYear();var month =
date.getMonth()+1<10?"0"+(date.getMonth()+1): date.getMonth()+1;var day = date.getDate()<10?"0"+ date.getDate(): date.getDate();var hours = date.getHours()<10?"0"+ date.getHours(): date.getHours();var minutes =
date.getMinutes()<10?"0"+ date.getMinutes(): date.getMinutes();var seconds =
date.getSeconds()<10?"0"+ date.getSeconds(): date.getSeconds();return(
year +"-"+ month +"-"+ day +" "+ hours +":"+ minutes +":"+ seconds
);}
2、可自定传入格式的时间转换,默认为 横杠分隔,比如“2022-08-24 14:32:00"
exportfunctionparseTime(time, pattern){if(arguments.length ===0||!time){returnnull;}const format = pattern ||"{y}-{m}-{d} {h}:{i}:{s}";let date;if(typeof time ==="object"){
date = time;}else{if(typeof time ==="string"&&/^[0-9]+$/.test(time)){
time =parseInt(time);}elseif(typeof time ==="string"){
time = time.replace(newRegExp(/-/gm),"/");}if(typeof time ==="number"&& time.toString().length ===10){
time = time *1000;}
date =newDate(time);}const formatObj ={y: date.getFullYear(),m: date.getMonth()+1,d: date.getDate(),h: date.getHours(),i: date.getMinutes(),s: date.getSeconds(),a: date.getDay()};const time_str = format.replace(/{(y|m|d|h|i|s|a)+}/g,(result, key)=>{let value = formatObj[key];// Note: getDay() returns 0 on Sundayif(key ==="a"){return["日","一","二","三","四","五","六"][value];}if(result.length >0&& value <10){
value ="0"+ value;}return value ||0;});return time_str;}// 日期格式化--- 当前时间减一天以后加 n 月exportfunctionparseTime2(time, pattern, monthNum){if(arguments.length ===0||!time){returnnull;}const format = pattern ||"{y}-{m}-{d} {h}:{i}:{s}";let date;if(typeof time ==="object"){
date = time;}else{if(typeof time ==="string"&&/^[0-9]+$/.test(time)){
time =parseInt(time);}elseif(typeof time ==="string"){
time = time.replace(newRegExp(/-/gm),"/");}if(typeof time ==="number"&& time.toString().length ===10){
time = time *1000;}
date =newDate(time);}let double =(monthNum /12).toString().split(".");let n = Math.floor(monthNum /12);const formatObj ={y: date.getFullYear()+ n,m:
double.length >1? date.getMonth()+Number(double[1])+2: date.getMonth()+1,d: date.getDate(),h: date.getHours(),i: date.getMinutes(),s: date.getSeconds(),a: date.getDay()};const time_str = format.replace(/{(y|m|d|h|i|s|a)+}/g,(result, key)=>{let value = formatObj[key];// Note: getDay() returns 0 on Sundayif(key ==="a"){return["日","一","二","三","四","五","六"][value];}if(result.length >0&& value <10){
value ="0"+ value;}return value ||0;});return time_str;}