public static function addVillage_transport($obj_Village_transport) { $db = config::dbconfig(); $obj_retresult = new returnResult(); $obj_Village_transport->VillageId = DAL_manageVillage_transport::getLastVillage_transportId() + 1; $sql = "INSERT INTO tbl_village_transport (TransportId,VillageId,Description) \n\t\tVALUES (" . common::noSqlInject($obj_Village_transport->TransportId) . "," . common::noSqlInject($obj_Village_transport->VillageId) . "," . "'" . common::noSqlInject($obj_Village_transport->Description) . "'" . ");"; $rs = mysql_query($sql); if (mysql_affected_rows() > 0) { $obj_retresult->type = 1; $obj_retresult->msg = "success"; $obj_retresult->data = $obj_Village_transport; } else { $obj_retresult->type = 0; $obj_retresult->msg = "failed"; } return $obj_retresult; }
public static function isChildVillage_transport($VillageId, $ChildVillageId) { $ischild = false; $obj_retResult = DAL_manageVillage_transport::getVillage_transportListByVillageId($ChildVillageId); //get child node if ($obj_retResult->type == 1) { $arr_Village_transportList = $obj_retResult->data; $obj_Village_transport = $arr_Village_transportList[0]; $arrParentIds = explode(",", $obj_Village_transport->Url); foreach ($arrParentIds as $Village_transportParentId) { if ($Village_transportParentId == $VillageId) { $ischild = true; } } } return $ischild; }