echo "<table align='center' class='vertical'>"; echo "<tr><th>{$strEdit}</th><td>{$sourceservice}</td></tr>"; echo "<tr><th></th><td>"; echo "<input type='radio' name='mode' id='edit' value='edit' checked='checked' onclick=\"\$('transfersection').hide(); \$('transfersectionbtn').hide(); \$('editsection').show(); \" /> {$strEdit} "; // Only allow transfers on the same contractid $sql = "SELECT * FROM `{$dbService}` WHERE contractid = '{$contractid}' AND serviceid != {$sourceservice}"; $result = mysql_query($sql); if (mysql_error()) { trigger_error(mysql_error(), E_USER_WARNING); } if (mysql_numrows($result) > 0) { echo "<input type='radio' name='mode' id='transfer' value='transfer' onclick=\"\$('transfersection').show(); \$('transfersectionbtn').show(); \$('editsection').hide(); \" /> {$strTransfer} "; echo "</td></tr>"; echo "<tbody style='display:none' id='transfersection' >"; echo "<tr><td colspan='2'>"; if (get_service_balance($sourceservice) >= 0) { echo $strTransferExamplePositiveService; } else { $strTransferExampleNegativeService; } echo "</td></tr><tr><th>{$strDestinationService}</th>"; echo "<td>"; echo "<select name='destinationservice'>\n"; while ($obj = mysql_fetch_object($result)) { echo "<option value='{$obj->serviceid}'>{$obj->serviceid} - {$obj->enddate} {$CONFIG['currency_symbol']}{$obj->balance}</option>\n"; } echo "</select>\n"; echo "</td></tr></tbody>\n"; } else { echo "</td></tr>"; }
/** * Produces a HTML dropdown of all valid services for a site * @author Paul Heaney * @param int $contractid The contract ID to report on * @param int $name name for the dropdown * @param int $selected The service ID to select * @return string HTML for the dropdown */ function service_dropdown_site($siteid, $name, $selected = 0) { global $now, $CONFIG; $sql = "SELECT s.* FROM `{$GLOBALS['dbService']}` AS s, `{$GLOBALS['dbMaintenance']}` AS m "; $sql .= "WHERE s.contractid = m.id AND m.site = {$siteid} "; $sql .= "AND UNIX_TIMESTAMP(s.startdate) <= {$now} AND UNIX_TIMESTAMP(s.enddate) >= {$now}"; $result = mysql_query($sql); if (mysql_error()) { trigger_error("Error getting services. " . mysql_error(), E_USER_WARNING); } $html = FALSE; if (mysql_num_rows($result) > 0) { $html = "<select name='{$name}' id={$name}>\n"; $html .= "<option value='0' "; if ($selected == 0) { $html .= " selected "; } $html .= "></option>"; while ($obj = mysql_fetch_object($result)) { $html .= "<option value='{$obj->serviceid}' "; if ($selected == $obj->serviceid) { $html .= " selected "; } $html .= ">{$CONFIG['currency_symbol']}" . get_service_balance($obj->serviceid, TRUE, TRUE); $html .= " ({$obj->startdate} - {$obj->enddate})</option>"; } $html .= "</select>\n"; } else { $html = "No services currently valid"; } return $html; }