Viewing file: curriculumMapping.php (2.88 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../include/class.mysqldb.php");
include("../include/config.inc.php");
if($_REQUEST["action"] == "insertCm"){
$sql = "INSERT INTO rg_ProgramCourses VALUES ('" . $_REQUEST["pcrCsCurId"] . "', '" . $_REQUEST["pcrCsCdId1"] . "', '" . $_REQUEST["pcrCsCdId2"] . "', '" . $_REQUEST["pcrCrsIdSelect"] . "', 'C', '" . $_REQUEST["pcrMinGrade"] . "', 'Y')";
$link->query($sql);
echo "Insert Success";
}
if($_REQUEST["action"] == "deleteCm"){
$sql = "DELETE FROM rg_ProgramCourses WHERE pcrCsCurId = '" . $_REQUEST["pcrCsCurId"] . "' AND pcrCsCdId1 = '" . $_REQUEST["pcrCsCdId1"] . "' AND pcrCsCdId2 = '" . $_REQUEST["pcrCsCdId2"] . "' AND pcrCrsId = '" . $_REQUEST["pcrCrsId"] . "'";
$link->query($sql);
echo "Data deleted.";
}
if($_REQUEST["action"] == "getCmByCurId"){
$sql = "SELECT rcs.csCurId, rcs.csCdId1, rcs.csCdId2, rcs.csSeq, rcs.csCreditTotal, rcd1.cdName as cdName1, rcd2.cdName as cdName2 FROM rg_CurriculumStructure rcs
INNER JOIN rg_Condition rcd1 ON rcd1.cdId = rcs.csCdId1
INNER JOIN rg_Condition rcd2 ON rcd2.cdId = rcs.csCdId2
WHERE rcs.csCurId = '".$_REQUEST["curId"]."'
ORDER BY rcs.csSeq";
$link->query($sql);
$i = 1;
//echo $sql;
if($link->num_rows()){
while($data = $link->getnext()){
$opt = "<button class='btn btn-primary btn-sm' data-toggle='modal' data-target='#modalAddCm' data-id='" . $data->csCurId . "' data-id2='" . $data->csCdId1 . "' data-id3='" . $data->csCdId2 . "'>Add</button>";
$json["data"][] = array("csSeq"=>$data->csSeq,"cdName1"=>$data->cdName1,"cdName2"=>$data->cdName2,"csCreditTotal"=>$data->csCreditTotal, "opt"=>$opt);
$sql = "SELECT * FROM rg_ProgramCourses rpc
LEFT JOIN rg_Course rc ON rpc.pcrCrsId = rc.crsId
WHERE rpc.pcrCsCurId = '".$data->csCurId."' AND rpc.pcrCsCdId1 = '".$data->csCdId1."' AND rpc.pcrCsCdId2 = '".$data->csCdId2."'";
//$res = mysql_query($sql);
$res = $mysqli->query($sql);
//while($rs = mysql_fetch_object($res)){
while($rs = $res->fetch_object()){
$opt = "<button class='btn btn-danger btn-sm' data-toggle='modal' data-target='#modalDelCm' data-id='" . $data->csCurId . "' data-id2='" . $data->csCdId1 . "' data-id3='" . $data->csCdId2 . "' data-id4='" . $rs->pcrCrsId . "'>Del</button>";
$json["data"][] = array("csSeq"=>"","cdName1"=>"","cdName2"=>" ".$rs->crsCode." ".$rs->crsName." (".$rs->crsCreditTotal.")","csCreditTotal"=>"", "opt"=>$opt);
}
}
}
else {
$json["data"][] = array("csSeq"=>"ไม่พบข้อมูล","cdName1"=>"ไม่พบข้อมูล","cdName2"=>"ไม่พบข้อมูล","csCreditTotal"=>"ไม่พบข้อมูล", "opt"=>"ไม่พบข้อมูล");
}
echo json_encode($json);
}
?>
|