بسم الله الرحمن الرحيم
إخواني
قمت بالتعديل والتطوير الكثيير في التصميم والشكل على برنامج معارف 2 نت
والبرنامج هذا لإستخراج النتائج من برنامج معارف " البرنامج المستخدم لرصد درجات الطلاب في السعودية"
وهو يستخدم لغة PhP
وأنا أريد طريقة أحسب فيها التقدير والمجموع والنسبة
علما بأن التقدير يختلف بين المواد العلمية والأدبية
وهذه برمجة الكود
كود 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 ورابط الموضوع الأصلي:
http://www.phpvillage.org/community/...c=5804.new#new
طلب مني أن أضيف الموضوع هنا لأنه لا يملك عضوية في سوالف
يرجى إضافة الردود هنا أو في الموضوع الأصلي لمن يعرف
تحياتي
