كود PHP:
<?
include("global.inc.php");
if ( isset($id) && !empty($id)
&& isset($report) && !empty($report) ) {
$id = (int) $id;
f_con2db();
$result = $cDB->query("SELECT * FROM " . $tbl["student"] . " WHERE std_id = '$id'");
if ( $cDB->num_rows($result) ) {
$std_inf = $cDB->result2array($result);
$subjects = f_get_subject();
$mark = $cDB->query("SELECT * FROM " . $tbl["mark"] . " WHERE std_id = '$id'");
if ( $report == 1 ) {
$cTML->TEMPLATE("REPORT:report1.tml");
$cTML->DYNAMIC_BLOCK("ROW","REPORT");
$name = $std_inf["std_name1"]
. " " . $std_inf["std_name2"]
. " " . $std_inf["std_name3"]
. " " . $std_inf["std_name4"];
$cTML->REPLACE_BLOCK("NAME", $name, "REPORT");
$nameF = $std_inf["std_name2"]
. " " . $std_inf["std_name3"]
. " " . $std_inf["std_name4"];
$cTML->REPLACE_BLOCK("NAMEF", $nameF, "REPORT");
$cTML->REPLACE_BLOCK("ID", $std_inf["std_id"], "REPORT");
while ( $row = $cDB->result2array($mark) ) {
$cTML->REPLACE_IN_DYNAMIC_BLOCK("SUBJECT" , $subjects[$row["madanum"]],"ROW");
if ( $row["madanum"] == "1" || $row["madanum"] == "11" || $row["madanum"] == "15" || $row["madanum"] == "102" || $row["madanum"] == "110")
$cTML->REPLACE_IN_DYNAMIC_BLOCK("AMALF1" ,"تقويم مستمر","ROW");
else
$cTML->REPLACE_IN_DYNAMIC_BLOCK("AMALF1" , $row["amalf1"],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("EKTBARF1" , $row["ektbarf1"],"ROW");
if ( $row["madanum"] == "1" || $row["madanum"] == "11" || $row["madanum"] == "15" || $row["madanum"] == "102" || $row["madanum"] == "110")
$cTML->REPLACE_IN_DYNAMIC_BLOCK("MRK_F1" ,"---","ROW");
else
$cTML->REPLACE_IN_DYNAMIC_BLOCK("MRK_F1" , $row["mrk_f1"],"ROW");
$sum = $row["amalf1"] + $row["ektbarf1"] +$row["mrk_f1"];
$cTML->REPLACE_IN_DYNAMIC_BLOCK("SUM" , $sum,"ROW");
$cTML->ADD_ELEMENT("ROW");
} // end while loop
$cTML->REPLACE_DYNAMIC_BLOCK("ROW","REPORT");
f_some_design($cTML->GET_TEMPLATE("REPORT"));
} elseif ( $report == 2 ) {
$cTML->TEMPLATE("REPORT:report2.tml");
$cTML->DYNAMIC_BLOCK("ROW","REPORT");
$name = $std_inf["std_name1"]
. " " . $std_inf["std_name2"]
. " " . $std_inf["std_name3"]
. " " . $std_inf["std_name4"];
$cTML->REPLACE_BLOCK("NAME", $name, "REPORT");
$nameF = $std_inf["std_name2"]
. " " . $std_inf["std_name3"]
. " " . $std_inf["std_name4"];
$cTML->REPLACE_BLOCK("NAMEF", $nameF, "REPORT");
$cTML->REPLACE_BLOCK("ID", $std_inf["std_id"], "REPORT");
while ( $row = $cDB->result2array($mark) ) {
$cTML->REPLACE_IN_DYNAMIC_BLOCK("SUBJECT" , $subjects[$row["madanum"]],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("AMALF2" , $row["amalf2"],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("EKTBARF2" , $row["ektbarf2"],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("MRK_F2" , $row["mrk_f2"],"ROW");
$sum = $row["amalf2"] + $row["ektbarf2"] +$row["mrk_f2"];
$cTML->REPLACE_IN_DYNAMIC_BLOCK("SUM" , $sum,"ROW");
$cTML->ADD_ELEMENT("ROW");
} // end while loop
$cTML->REPLACE_DYNAMIC_BLOCK("ROW","REPORT");
f_some_design($cTML->GET_TEMPLATE("REPORT"));
}else {
$cTML->TEMPLATE("REPORT:report3.tml");
$cTML->DYNAMIC_BLOCK("ROW","REPORT");
$name = $std_inf["std_name1"]
. " " . $std_inf["std_name2"]
. " " . $std_inf["std_name3"]
. " " . $std_inf["std_name4"];
$cTML->REPLACE_BLOCK("NAME", $name, "REPORT");
$nameF = $std_inf["std_name2"]
. " " . $std_inf["std_name3"]
. " " . $std_inf["std_name4"];
$cTML->REPLACE_BLOCK("NAMEF", $nameF, "REPORT");
$cTML->REPLACE_BLOCK("ID", $std_inf["std_id"], "REPORT");
while ( $row = $cDB->result2array($mark) ) {
$cTML->REPLACE_IN_DYNAMIC_BLOCK("SUBJECT" , $subjects[$row["madanum"]],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("AMALF1" , $row["amalf1"],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("AMALF2" , $row["amalf2"],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("EKTBARF1" , $row["ektbarf1"],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("EKTBARF2" , $row["ektbarf2"],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("MRK_F1" , $row["mrk_f1"],"ROW");
$cTML->REPLACE_IN_DYNAMIC_BLOCK("MRK_F2" , $row["mrk_f2"],"ROW");
$sum = $row["amalf1"] + $row["amalf2"] +$row["ektbarf1"] + $row["ektbarf2"] + $row["mrk_f1"] + $row["mrk_f2"];
$cTML->REPLACE_IN_DYNAMIC_BLOCK("SUM" , $sum,"ROW");
$sum2 = $row["amalf1"] +$row["ektbarf1"] + $row["mrk_f1"];
$cTML->REPLACE_IN_DYNAMIC_BLOCK("SUM2" , $sum2,"ROW");
$cTML->ADD_ELEMENT("ROW");
} // end while loop
$cTML->REPLACE_DYNAMIC_BLOCK("ROW","REPORT");
f_some_design($cTML->GET_TEMPLATE("REPORT"));
}// end if
} else {
f_print_msg("لايوجد في قاعدة بياناتنا طالب بهذا الرقم" . "\\n راجع إدارة المدرسة لمعرفة الرقم الخاص بك","index.php");
} // end if
} // end if
?>
ملاحظة: صاحب الموضوع الأصلي الاخ YasserNet ورابط الموضوع الأصلي: