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); }