アットウィキロゴ

70 70 php

<?php
require("calldata.php");

$sql = "SELECT * FROM ben71";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$matrix[$n][3]  =$row[2];
$matrix[$n][4]  =$row[3];
$matrix[$n][5]  =$row[4];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$year =$matrix[$n][1];
$age =$matrix[$n][2];
$ms[$year][$age] = $matrix[$n][3];
$ws[$year][$age] = $matrix[$n][4];
$ds[$year][$age] = $matrix[$n][5];
}

$sql = "SELECT * FROM data70";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {  
$x70[$n] = $matrix[$n][1];
}

for ($age=15;$age<70;$age++){
$n=3*(floor($age/5)-3)+1;
$mr[$age]=$x70[$n];
$wr[$age]=$x70[$n+1];
$dr[$age]=$x70[$n+2];
}


For ($year=5;$year<30;$year++){
$a1 =20 + 10 *($year - 5)/ 25;
$rate[$year] = 0.01 * $a1 / 20;
}

For ($year=30;$year<100;$year++){
$a1 = 30;
$rate[$year] = 0.01 * $a1 / 20;
}


for ($year=8;$year<100;$year++){
for ($age=15;$age<70;$age++){
$mal[$year][$age]=$rate[$year]*$mr[$age]*$ms[$year][$age];
$wal[$year][$age]=$rate[$year]*$wr[$age]*$ws[$year][$age];
$dal[$year][$age]=$rate[$year]*$dr[$age]*$ds[$year][$age];
}
}

$sql = "truncate ben70";
$exe= mysql_query($sql,$link);
for ($year=8;$year<100;$year++){
for ($age=15;$age<70;$age++){
$x=$mal[$year][$age];
$y=$wal[$year][$age]+$dal[$year][$age];
$sql = "insert into ben70 values($year,$age,$x,$y)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
print("70 アルバイト  計算終了");
?>
最終更新:2010年12月13日 19:37