@($result_bymoney_w[$row_bymoney_w['itemName']]['billAmount'] += $row_bymoney_w['billAmount']);
// $result[$row['pickerCode']]['earn'] += $row['earn'];
}
$result_bymoney_w = array_values($result_bymoney_w);
$sort_bymoney_w = array();
foreach ($result_bymoney_w as $k_bymoney_w => $v_bymoney_w) {
$sort_bymoney_w['itemName'][$k_bymoney_w] = $v_bymoney_w['itemName'];
$sort_bymoney_w['billAmount'][$k_bymoney_w] = $v_bymoney_w['billAmount'];
}
# sort by event_type desc and then title asc
array_multisort($sort_bymoney_w['billAmount'], SORT_DESC, $sort_bymoney_w['itemName'], SORT_ASC, $result_bymoney_w);
$sq .= "<table border='1' width='100%' style='border-collapse:collspse;'>";
$sq .= "<tr style='background:#ccc;'><th>สินค้า</th><th>จำนวนเงินที่ได้รับ</th></tr>";
$cnt_bymoney_w = count($result_bymoney_w);
//echo $cnt_bymoney_w;
$product_bymoney_w = 0;
for ($i_bymoney_w = 0; $i_bymoney_w < $cnt_bymoney_w; $i_bymoney_w++) {
$sq .= "<tr><td>" . $sort_bymoney_w['itemName'][$i_bymoney_w] . "</td><td style='text-align:center;'>" . number_format($sort_bymoney_w['billAmount'][$i_bymoney_w]) . " บาท </td></tr>";
$product_bymoney_w += $sort_bymoney_w['billAmount'][$i_bymoney_w];
}
$sq .= "</table>";
$sq .= "<p align='right'>จำนวนเงินทั้งหมด " . number_format($product_bymoney_w) . " บาท</p>";
//echo $product_bymoney_w;
//echo $all_product;
}
pdf_title($title);
pdf_html($sq);
pdf_echo();
?>
</body>
</html>
$result_bymoney_m[$row_bymoney_m['itemName']]['itemName'] = $row_bymoney_m['itemName'];
@($result_bymoney_m[$row_bymoney_m['itemName']]['billAmount'] += $row_bymoney_m['billAmount']);
// $result[$row['pickerCode']]['earn'] += $row['earn'];
}
$result_bymoney_m = array_values($result_bymoney_m);
$sort_bymoney_m = array();
foreach ($result_bymoney_m as $k_bymoney_m => $v_bymoney_m) {
$sort_bymoney_m['itemName'][$k_bymoney_m] = $v_bymoney_m['itemName'];
$sort_bymoney_m['billAmount'][$k_bymoney_m] = $v_bymoney_m['billAmount'];
}
# sort by event_type desc and then title asc
array_multisort($sort_bymoney_m['billAmount'], SORT_DESC, $sort_bymoney_m['itemName'], SORT_ASC, $result_bymoney_m);
$report .= "<table border='1' width='100%' style='border-collapse:collspse;'>";
$report .= "<tr style='background:#ccc;'><th>สินค้า</th><th>ยอดเงินที่ได้รับ</th></tr>";
$cnt_bymoney_m = count($result_bymoney_m);
//echo $cnt_bymoney_m;
$product_bymoney_m = 0;
for ($i_bymoney_m = 0; $i_bymoney_m < $cnt_m; $i_bymoney_m++) {
$report .= "<tr><td>" . $sort_bymoney_m['itemName'][$i_bymoney_m] . "</td><td style='text-align:center;'>" . number_format($sort_bymoney_m['billAmount'][$i_bymoney_m]) . " บาท</td></tr>";
$product_bymoney_m += $sort_bymoney_m['billAmount'][$i_bymoney_m];
}
$report .= "</table>";
$report .= "<p align='right'>จำนวนเงินทั้งหมด " . number_format($product_bymoney_m) . " บาท</p>";
//echo $product_bymoney_m;
}
pdf_title($title);
pdf_html($report);
pdf_echo();
?>
</body>
</html>
