간편장부 월합계가 모두 나올 수 있을까요.
본문
물물님의 간편장부를 수정하고 있습니다.
맨 하단에 페이지합계, 전체합계 표시가 되는데..
월별합계가 바로 나오게도 할 수 있을까요?
if($_GET['sdate']) $all_add .= " and wr_datetime between '$start_datetime' and '$end_datetime' ";
이 부분을 잘 활용하면 될 듯 한데..
당췌 이것저것 넣어봐도 먹히질 않네요.
고수님들의 고견 부탁드립니다..!
<?php
//페이지 합계
for ($j=1; $j<=10; $j++)
{
if($j != 9)
{
$y = "wr_$j";
$page_add[$y] = $list[$i][$y] + $page_add[$y];
//if($list[$i][$y] != '') $list[$i][$y] = number_format($list[$i][$y]);
if($list[$i][$y] != '') $list[$i][$y] = $list[$i][$y];
}
}
}
//전체합계
$sca =$_GET['sca'];
$wr_10 = $_GET['wr_10'];
$all_add = " select sum(wr_1) as wr_1, sum(wr_2) as wr_2, sum(wr_3) as wr_3, sum(wr_4) as wr_4, sum(wr_5) as wr_5, sum(wr_6) as wr_6 from $write_table where wr_is_comment = 0 ";
if($sca) $all_add .= " and ca_name = '$sca' ";
if($wr_10) $all_add .= " and wr_10 = '$wr_10' ";
if($_GET['sdate']) $all_add .= " and wr_datetime between '$start_datetime' and '$end_datetime' ";
$all_add = sql_fetch($all_add);
?>
<?php if (count($list) == 0) { ?>
<input type='hidden' name='wr_id_up[0]' value='0' id='wr_id_0'> <!-- 데이타 없을 시 초기 wr_id 값 만들기 위해 -->
<tr><td colspan="<?php echo $colspan?>" class="empty_table">데이타가 없습니다.</td></tr>
<?php } ?>
<tr>
<td align="center" colspan='<?php echo $colspan-8;?>'><b>합계</b></td>
<td class="td_sum"><?php echo number_format($page_add[wr_1])?></td>
<td class="td_sum"><?php echo number_format($page_add[wr_2])?></td>
<td class="td_sum"><?php echo number_format($page_add[wr_3])?></td>
<td class="td_sum"><?php echo number_format($page_add[wr_4])?></td>
<td class="td_sum"><?php echo number_format($page_add[wr_5])?></td>
<td class="td_sum"><?php echo number_format($page_add[wr_6])?></td>
<td class="td_sum"></td>
<td class="td_sum"></td>
</tr>
<tr>
<td align="center" colspan='<?php echo $colspan-8;?>'><b>전체 합계</b></td>
<td class="td_sum"><?php echo number_format($all_add[wr_1])?></td>
<td class="td_sum"><?php echo number_format($all_add[wr_2])?></td>
<td class="td_sum"><?php echo number_format($all_add[wr_3])?></td>
<td class="td_sum"><?php echo number_format($all_add[wr_4])?></td>
<td class="td_sum"><?php echo number_format($all_add[wr_5])?></td>
<td class="td_sum"><?php echo number_format($all_add[wr_6])?></td>
<td class="td_sum"></td>
<td class="td_sum"></td>
</tr>