br {mso-data-placement:same-cell;} "; echo ""; $t_field = []; foreach ($resHeader as $ha => $h) { $t_field[] = $ha; echo ""; } echo ""; foreach ($resData as $dd => $d) { echo ""; foreach ($t_field as $td => $t) { //判断是否合并单元格 echo '"; //判断是否拆分单元格 if (is_array($d[$t])) { echo '

" . $h . "

'; foreach ($d[$t] as $rowValue) { echo ''; } echo '

' . $rowValue . '

'; } else { echo $d[$t]; } echo ""; } echo ""; } echo ""; exit; } } /** * CSV导出 * @param $file_name * @param $header * @param $list */ function exportCsv($header, $list, $file_name) { static $source = ''; if (empty($source)) { header('Content-type: text/csv; charset=utf-8'); header('Content-Disposition: attachment;filename="' . $file_name . '.csv"'); header('Cache-Control: max-age=0'); // PHP文件句柄，php://output 表示直接输出到浏览器 $source = fopen('php://output', 'a'); // 写入列头 foreach ($header as $k => $v) { // CSV的Excel支持GBK编码，一定要转换，否则乱码 //$header[$k] = iconv('utf-8', 'gbk', $v); $header[$k] = $v; } fputcsv($source, $header); } foreach ($list as $key => $value) { $temp = []; foreach ($header as $k => $v) { //$temp[$k] = "\t" . iconv('utf-8', 'gbk', $value[$k]); $temp[$k] = "\t" . $value[$k]; } fputcsv($source, $temp); ob_flush(); flush(); } } /* * 生成随机字符串 * * $length 字符串长度 */ function randomStr($length) { // 密码字符集，可任意添加你需要的字符 $chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $str = ''; for ($i = 0; $i < $length; $i++) { $str .= $chars[mt_rand(0, strlen($chars) - 1)]; } return $str; } function get_image_url($file) { if (strpos($file, "http") === 0) { return $file; } else if (strpos($file, "/") === 0) { return cmf_get_domain() . cmf_get_root() . $file; } else { $storage = \cmf\lib\Storage::instance(); return $storage->getPreviewUrl($file); } } /** * 生成唯一的订单号 20110809111259232312 * 2011-年日期 * 08-月份 * 09-日期 * 11-小时 * 12-分 * 59-秒 * 2323-微秒 * 12-随机值 * @return string */ function get_trade_no() { list($usec, $sec) = explode(" ", microtime()); $usec = substr(str_replace('0.', '', $usec), 0, 4); $str = rand(10, 99); return date("YmdHis") . $usec . $str; }