@($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>