 |
|
|
 |
 |
|
ช่วยหน่อยครับ
|
 |
 |
 |
 |
| Date :
2010-02-23 14:15:51 |
By :
oasiis |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
mysql> SELECT YEAR(whn) AS yr
-> ,SUM(CASE WHEN MONTH(whn) IN (1,2,3) THEN amount END) AS Q1
-> ,SUM(CASE WHEN MONTH(whn) IN (4,5,6) THEN amount END) AS Q2
-> ,SUM(CASE WHEN MONTH(whn) IN (7,8,9) THEN amount END) AS Q3
-> ,SUM(CASE WHEN MONTH(whn) IN (10,11,12) THEN amount END) AS Q4
-> FROM sale
-> GROUP BY YEAR(whn);
+------+------+------+------+------+
| yr | Q1 | Q2 | Q3 | Q4 |
+------+------+------+------+------+
| 2005 | 10 | 40 | 80 | 660 |
| 2006 | 30 | 20 | NULL | NULL |
+------+------+------+------+------+
|
| |
|
|
| |
| Date :
2010-02-23 14:17:02 |
By :
superpheak |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ถ้าเป็น mysql ใช้
mysql> SELECT QUARTER(whn)
-> ,SUM(CASE WHEN YEAR(whn)=2005 THEN amount END) AS Y2005
-> ,SUM(CASE WHEN YEAR(whn)=2006 THEN amount END) AS Y2006
-> FROM sale
-> GROUP BY QUARTER(whn);
|
| |
|
|
| |
| Date :
2010-02-23 14:18:44 |
By :
superpheak |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ถ้าใช้โค้ด php ในการแบ่งไตรมาสล่ะครับ
คือเขียนโค้ดเองอ่ะครับ
|
| |
|
|
| |
| Date :
2010-02-23 15:42:30 |
By :
oasiis |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
for ($i=1;$i<=12;$i++){
$n = $i > 3 ? ( $i > 6 ? ($i > 9 ? 'T4' : 'T3') : 'T2') : 'T1';
echo $i.' ... '.$n,'<br>';
}
|
| |
|
|
| |
| Date :
2010-02-23 20:13:52 |
By :
num |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณมากครับพี่หนุ่ม
|
| |
|
|
| |
| Date :
2010-02-24 08:20:18 |
By :
oasiis |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
แล้วนำมาใช้ยังไงครับ
|
| |
|
|
| |
| Date :
2010-02-24 10:57:48 |
By :
oasiis |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
<?php
function trimas($month_number){
return $i > 3 ? ( $i > 6 ? ($i > 9 ? 'T4' : 'T3') : 'T2') : 'T1';
}
$d = '2009-01-01';
$m = date('n',strtotime($d));
echo trimas($m);
?>
|
| |
|
|
| |
| Date :
2010-02-24 11:06:55 |
By :
num |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
แก้ครับข้างบนโค้ดผิด
<?php
function trimas($i){
return $i > 3 ? ( $i > 6 ? ($i > 9 ? 'T4' : 'T3') : 'T2') : 'T1';
}
$d = '2009-01-01';
$m = date('n',strtotime($d));
echo trimas($m);
?>
|
| |
|
|
| |
| Date :
2010-02-24 11:07:36 |
By :
num |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณอีกครั้งนะครับ
|
| |
|
|
| |
| Date :
2010-02-24 11:37:32 |
By :
oasiis |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
สั้นได้ใจครับพี่หนุ่ม เหมือนการแยกพจน์เลยอ่ะ ดีจริงๆ 
|
| |
|
|
| |
| Date :
2010-02-24 11:53:00 |
By :
peterXP |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
function trimas($i){
return 'T'.ceil($i/3);
}
|
| |
|
|
| |
| Date :
2010-02-24 20:06:47 |
By :
num |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
