"; $str .= $titlename; $str .= ""; foreach ($info_list as $key=>$value) { if($value['fpdata'] == '') { continue; } $str .= ""; foreach ($value as $ke=>$va) { if($ke == 'shipremarks') { $va = str_replace(array('<','>'),array('<','>'),$va); } if($ke == 'orderinfo' || $ke == 'waybill') { $str .= ""; } else if($ke != 'fpdata' && $ke != 'hl' && $ke != 'currencytitle') { $str .= ""; } } $str .= ""; if($ts != 1) { $str .= ""; } $str .= "\n"; } $str .= $tail; $str .= "

".$va."

".$va."

"; $a = 0; foreach ($value['fpdata'] as $k=>$v) { $vd = ''; foreach ($v as $vv) { $vd .= ""; } $str .= "".$vd.""; $endv = is_numeric(end($v))?end($v):0; $a = $a + $endv; } $str .= " ".$vv."

".$a."

"; header( "Content-Type: application/vnd.ms-excel; name='excel'" ); header( "Content-type: application/octet-stream" ); header( "Content-Disposition: attachment; filename=".$filename ); header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); header( "Pragma: no-cache" ); header( "Expires: 0" ); exit($str); //return $str; } public function get_fz2($info_list,$titlename,$filename,$tail) { $str = " "; $str .= $titlename; $str .= ""; foreach ($info_list as $key=>$value) { $str .= ""; foreach ($value as $ke=>$va) { $tj = ''; /** if($ke == 'phone' || $ke == 'waybill') { $tj = ' '; } if($ke == 'orderinfo' || $ke == 'zipcode'|| $ke == 'paypal'|| $ke == 'rpaypal') { $str .= "";//使用文本格式 } else if($ke != 'fpdata' && $ke != 'hl' && $ke != 'currencytitle') { $str .= ""; //.$tj.$va. } **/ //文本：vnd.ms-excel.numberformat:@ //日期：vnd.ms-excel.numberformat:yyyy/mm/dd //数字：vnd.ms-excel.numberformat:#,##0.00 //货币：vnd.ms-excel.numberformat:￥#,##0.00 //百分比：vnd.ms-excel.numberformat: #0.00% if($ke == 'shipremarks') { $va = str_replace(array('<','>'),array('<','>'),$va); } if($ke == 'shouldmoney' || $ke == 'freight' || $ke == 'expressmoney' || $ke == 'budget' || $ke == 'cost' || $ke == 'refundy' || $ke == 'refundj') { $str .= "";//使用文本格式 } else if($ke == 'ts' || $ke == 'zsbjz') { $str .= ""; } else if($ke == 'zzl') { $str .= ""; } else if($ke != 'fpdata' && $ke != 'hl' && $ke != 'currencytitle' || $ke == 'orderinfo') { $str .= ""; //.$tj.$va. } } $str .= "\n"; } $str .= $tail; $str .= "

".$va."

".$tj.trim($va,' ')."

".$va."

".$va."

".$va."

".trim($va,' ')."\t"."

"; header( "Content-Type: application/vnd.ms-excel; name='excel'" ); header( "Content-type: application/octet-stream" ); header( "Content-Disposition: attachment; filename=".$filename ); header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); header( "Pragma: no-cache" ); header( "Expires: 0" ); exit($str); //return $str; } public function get_fz2_bc($info_list,$titlename,$filename,$tail) { $str = " "; $str .= $titlename; $str .= ""; foreach ($info_list as $key=>$value) { $str .= ""; foreach ($value as $ke=>$va) { $tj = ''; /** if($ke == 'phone' || $ke == 'waybill') { $tj = ' '; } if($ke == 'orderinfo' || $ke == 'zipcode'|| $ke == 'paypal'|| $ke == 'rpaypal') { $str .= "";//使用文本格式 } else if($ke != 'fpdata' && $ke != 'hl' && $ke != 'currencytitle') { $str .= ""; //.$tj.$va. } **/ //文本：vnd.ms-excel.numberformat:@ //日期：vnd.ms-excel.numberformat:yyyy/mm/dd //数字：vnd.ms-excel.numberformat:#,##0.00 //货币：vnd.ms-excel.numberformat:￥#,##0.00 //百分比：vnd.ms-excel.numberformat: #0.00% if($ke == 'shipremarks') { $va = str_replace(array('<','>'),array('<','>'),$va); } if($ke == 'shouldmoney' || $ke == 'freight' || $ke == 'expressmoney' || $ke == 'budget' || $ke == 'cost' || $ke == 'refundy' || $ke == 'refundj') { $str .= "";//使用文本格式 } else if($ke == 'ts' || $ke == 'zsbjz') { $str .= ""; } else if($ke == 'zzl') { $str .= ""; } else if($ke != 'fpdata' && $ke != 'hl' && $ke != 'currencytitle' || $ke == 'orderinfo') { if(is_string($va)) { $str .= ""; //.$tj.$va. } } } $str .= "\n"; } $str .= $tail; $str .= "

".$va."

".$tj.trim($va,' ')."

".$va."

".$va."

".$va."

".trim($va,' ')."\t"."

"; return $str; } public function get_fz3($info_list,$titlename,$filename,$tail) { $str = " "; $str .= $titlename; $str .= ""; foreach ($info_list as $key=>$value) { $str .= ""; foreach ($value as $k=>$v) { if($k == 'shipremarks') { $v = str_replace(array('<','>'),array('<','>'),$v); } $str .= ""; } $str .= "\n"; } $str .= $tail; $str .= "

".$v."

"; return $str; //return $str; } public function get_fz5($info_list,$titlename,$filename,$tail,$kong)//带空项 { $str = " "; $str .= $titlename; $str .= ""; foreach ($info_list as $key=>$value) { $str .= "";$i=0; foreach ($kong as $k=>$a) { array_splice($value,$k,0,''); } foreach ($value as $ke=>$va) { $tj = ''; /** if($ke == 'phone' || $ke == 'waybill') { $tj = ' '; } if($ke == 'orderinfo' || $ke == 'zipcode'|| $ke == 'paypal'|| $ke == 'rpaypal') { $str .= "";//使用文本格式 } else if($ke != 'fpdata' && $ke != 'hl' && $ke != 'currencytitle') { $str .= ""; //.$tj.$va. } **/ //文本：vnd.ms-excel.numberformat:@ //日期：vnd.ms-excel.numberformat:yyyy/mm/dd //数字：vnd.ms-excel.numberformat:#,##0.00 //货币：vnd.ms-excel.numberformat:￥#,##0.00 //百分比：vnd.ms-excel.numberformat: #0.00% if($ke == 'shipremarks') { $va = str_replace(array('<','>'),array('<','>'),$va); } if($ke == 'shouldmoney' || $ke == 'freight' || $ke == 'expressmoney' || $ke == 'budget' || $ke == 'cost' || $ke == 'refundy' || $ke == 'refundj') { $str .= "";//使用文本格式 } else if($ke == 'ts') { $str .= ""; } else if($ke == 'zsbjz' || $ke == 'dtsbjz' || $ke == 'insurance') { $str .= ""; } else if($ke == 'zjs' || $ke == 'ts') { $str .= ""; } else if($ke == 'zzl' || $ke == 'jweight' || $ke == 'weight') { if($ke == 'weight') { $va = trim($va,'kg'); } $str .= ""; } else if($ke != 'hl' && $ke != 'currencytitle' || $ke == 'orderinfo') { $str .= ""; } $i++; } $str .= "\n"; } $str .= $tail; $str .= "

".$va."

".$tj.trim($va,' ')."

".$va."

".$va."

".$va."

".$va."

".$va."

".trim($va,' ')."\t"."

"; header( "Content-Type: application/vnd.ms-excel; name='excel'" ); header( "Content-type: application/octet-stream" ); header( "Content-Disposition: attachment; filename=".$filename ); header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); header( "Pragma: no-cache" ); header( "Expires: 0" ); exit($str); //return $str; } public function get_fz6($info_list,$titlename,$filename) { $str = " "; $str .= $titlename; $str .= ""; foreach ($info_list as $key=>$value) { $str .= "\n"; } $str .= "

"; foreach ($value as $ke=>$va) { if($ke == 'shipremarks') { $va = str_replace(array('<','>'),array('<','>'),$va); } $str .= ""; } $str .= " ".$va[0]." ".$va[1]."

"; header( "Content-Type: application/vnd.ms-excel; name='excel'" ); header( "Content-type: application/octet-stream" ); header( "Content-Disposition: attachment; filename=".$filename ); header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); header( "Pragma: no-cache" ); header( "Expires: 0" ); exit($str); //return $str; } } //end class