年・月別報告書作成画面
\n");
print("
\n");
print("| \n");
$string = $year."年".$month."月1日 現在";
print($string);
$sql = "select * from zikan where z_year = $year and z_month = $month";
$result = sqlite_query($con,$sql);
$array = sqlite_fetch_array($result);
$string = " ".$array[1]."円";
print($string);
print(" | \n");
print("
\n");
print("
\n");
print("| \n");
print("カテゴリ別収支および差額[単位：円]\n");
print(" | \n");
print("
\n");
print("
\n");
print("\n");
//カテゴリ別収支一覧表表示部分start
//ヘッダ部分
print("\n");
print("\n");
print("| カテゴリ名 | \n");
print("収支 | \n");
print("支出 | \n");
print("目標額 | \n");
print("差額 | \n");
print("明細 | \n");
print(" \n");
//金額表示部分
$sql = "select * from category";
$result = sqlite_query($con,$sql);
$row = sqlite_num_rows($result);
$sum_syusi = 0;
$sum_sisyutu = 0;
for($i = 0;$i < $row;$i++){
$array2 = sqlite_fetch_array($result);
print("\n");
print("| $array2[1] | \n");
//収入表示部分
$syusi_sql = "select sum(s_kingaku) from syusi where s_kubun = 'I' and s_year = $year and s_month = $month and sc_id = $array2[0]";
$syusi_result = sqlite_query($con,$syusi_sql);
$syusi_array = sqlite_fetch_array($syusi_result);
print("$syusi_array[0] | \n");
$sum_syusi = $sum_syusi + $syusi_array[0];
//支出表示部分
$sisyutu_sql = "select sum(s_kingaku) from syusi where s_kubun = 'O' and s_year = $year and s_month = $month and sc_id = $array2[0]";
$sisyutu_result = sqlite_query($con,$sisyutu_sql);
$sisyutu_array = sqlite_fetch_array($sisyutu_result);
print("$sisyutu_array[0] | \n");
$sum_sisyutu = $sum_sisyutu + $sisyutu_array[0];
//カテゴリ別目標額表示部分
$mokuhyou_sql = "select cm_sisyutugaku from category_mokusisyutu where cmc_id = $array2[0] and cmz_code = $array[0]";
$mokuhyou_result = sqlite_query($con,$mokuhyou_sql);
$mokuhyou_array = sqlite_fetch_array($mokuhyou_result);
print("$mokuhyou_array[0] | \n");
//目標額と実際額の差額表示部分
if($mokuhyou_array[0] > 0){
$sagaku = $mokuhyou_array[0] - ($sisyutu_array[0] - $syusi_array[0]);
if($sagaku > 0){
$string = "+".$sagaku;
print("$string | \n");
}else{
print("$sagaku | \n");
}
}else{
print("- | \n");
}
print("明細 | \n");
print(" \n");
}
//合計算出部分
print("\n");
print("| 計 | \n");
print("$sum_syusi | \n");
print("$sum_sisyutu | \n");
print("- | \n");
print("- | \n");
print(" \n");
print(" \n");
//end
print(" | \n");
print("
\n");
//帳簿現金有高表示部分
print("
\n");
print("\n");
//タイトル名・金額表示部分
print("\n");
print("\n");
print("| 帳簿現金有高 | \n");
$tyobo_kingaku = $array[1] + $sum_syusi - $sum_sisyutu;
$string = $tyobo_kingaku."円";
print("$string | \n");
print(" \n");
print(" \n");
//end
print(" | \n");
print("
\n");
//実際現金有高表示部分
$search_year = $year;
$search_month = $month + 1;
if($search_month > 12){
$search_month = 1;
$search_year = $search_year + 1;
}
$zissai_sql = "select z_zkingaku from zikan where z_year = $search_year and z_month = $search_month";
$zissai_result = sqlite_query($con,$zissai_sql);
$zissai_array = sqlite_fetch_array($zissai_result);
$string = $zissai_array[0]."円";
print("
\n");
print("\n");
//タイトル名・金額表示部分
print("\n");
print("\n");
print("| 実際現金有高 | \n");
print("$string | \n");
print(" \n");
print(" \n");
//end
print(" | \n");
print("
\n");
//現金過不足表示部分
print("
\n");
print("\n");
//タイトル名・金額表示部分
print("\n");
print("\n");
$kahusoku = $zissai_array[0] - $tyobo_kingaku;
if($kahusoku > 0){
$string = "+".$kahusoku."円";
$color = "blue";
}else{
if($kahusoku == 0){
$string = $kahusoku."円";
$color = "green";
}else{
$string = $kahusoku."円";
$color = "red";
}
}
print("| 現金過不足 | \n");
print("$string | \n");
print(" \n");
print(" \n");
//end
print(" | \n");
print("
\n");
print("\n");
}
?>
収支管理システム メイン画面へ戻る