"表单号",
"cnt" => "笔数",
"yyyymm" => "年月",
"date_seq_start" => "日期-號碼起",
"date_seq_end" => "日期-號碼止"
);
$sql_group_epo = "
SELECT
form_key ,
max(YYYYMM) yyyymm,
count(*) cnt,
min(date_seq) date_seq_start,
max(date_seq) date_seq_end
From ec_purchase_order
GROUP BY form_key";
// 用mysqli_query方法執行(sql語法)將結果存在變數中
?>
| 已上传资料明细 |
";
foreach (array_values($fields_mapping) as $val) {
echo "| $val | ";
}
echo "操作 |
";
echo " ";
?>
";
foreach (array_keys($fields_mapping) as $val) {
echo " " . $row[$val] . " | ";
}
echo "
查看
發票匯入檔下載
請款單歸入檔下載
| ";
echo " ";
}
?>