function selectSuc($suc_id, $con_id = NULL)
{
$tab_subcontenedor = new tab_subcontenedor();
if ($con_id == NULL) {
$sql = "SELECT con_id FROM tab_subcontenedor WHERE suc_estado=1 AND suc_id={$suc_id}";
$res = $tab_subcontenedor->dbSelectBySQL($sql);
$con_id = $res[0]->con_id;
}
$sql = "SELECT suc_id, suc_codigo FROM tab_subcontenedor WHERE suc_estado=1 AND con_id={$con_id}";
$res = $tab_subcontenedor->dbSelectBySQL($sql);
$option = "";
$option .= "<option value=''>(Seleccionar)</option>";
foreach ($res as $value) {
if ($value->suc_id == $suc_id) {
$option .= "<option value='" . $value->suc_id . "' selected>" . $value->suc_codigo . "</option>";
} else {
$option .= "<option value='" . $value->suc_id . "' >" . $value->suc_codigo . "</option>";
}
}
return $option;
}
function loadAjax()
{
$con_id = $_POST["con_id"];
$sql = "SELECT *\r\n\t\tFROM\r\n\t\ttab_subcontenedor\r\n\t\tWHERE\r\n\t\ttab_subcontenedor.con_id = '{$con_id}' ";
$subcontenedor = new tab_subcontenedor();
$result = $subcontenedor->dbSelectBySQL($sql);
$res = array();
foreach ($result as $row) {
$res[$row->suc_id] = $row->suc_codigo;
}
echo json_encode($res);
}
