if (!$q_data) {
die_well(__LINE__, mysql_error());
}
while ($rowData = mysql_fetch_row($q_data)) {
$i_projectID = $rowData[0];
$s_project = $rowData[1];
$i_active = $rowData[2];
}
echo '<a href="' . $s_fileName . '" target="_top"><img src="../../images/Button-Info-16x16.png" border="0" height="12" width="12" title="List"></a>';
echo '<form id="frmForm" name="frmForm" action="' . $s_fileName . '" method="post">';
echo '<input type="hidden" name="page_task" id="page_task" value="' . $page_task . '">';
echo '<table style="border-collapse: collapse;">' . $g_break;
echo row_input_text($s_fieldName = "projectID", $i_fieldSize = 5, $s_data = $i_projectID, $left_class = "odd", $right_class = "even", $s_fieldString = "Project ID", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo row_input_text($s_fieldName = "projectCode", $i_fieldSize = 10, $s_data = trim($s_projectCode), $left_class = "odd", $right_class = "even", $s_fieldString = "Project Code") . $g_break;
echo row_input_text($s_fieldName = "project", $i_fieldSize = 30, $s_data = trim($s_project), $left_class = "odd", $right_class = "even", $s_fieldString = "Project") . $g_break;
echo row_input_text($s_fieldName = "active", $i_fieldSize = 5, $s_data = $i_active, $left_class = "odd", $right_class = "even", $s_fieldString = "Active") . $g_break;
if ($i_projectID > 0) {
$s_text = "Save";
} else {
$s_text = "Add";
}
echo '<tr>' . $g_break;
echo '<td class="odd"> </td>' . $g_break;
echo '<td class="even"><input type="submit" id="submit_form" name="submit_form" value="' . $s_text . '"></td>' . $g_break;
echo '</tr>' . $g_break;
echo '</table>' . $g_break;
echo '</form>';
break;
}
echo '</table>';
echo '<script language="javascript">' . $g_break;
} echo '<a href="' . $s_fileName . '" target="_top"><img src="../../images/Button-Info-16x16.png" border="0" height="12" width="12" title="List"></a>'; echo '<form id="frmForm" name="frmForm" action="' . $s_fileName . '" method="post">'; echo '<input type="hidden" name="page_task" id="page_task" value="' . $page_task . '">'; echo '<input type="hidden" name="pid" id="pid" value="' . $s_publicID . '">'; echo '<table style="border-collapse: collapse;">' . $g_break; echo '<tr>' . $g_break; echo '<td class="accentrow">Order Information</td>' . $g_break; echo '<td class="body" style="width:75px;"> </td>' . $g_break; echo '</tr>' . $g_break; echo row_input_text($s_fieldName = "orderID", $i_fieldSize = 5, $s_data = $i_orderID, $left_class = "odd", $right_class = "even", $s_fieldString = "Order ID", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break; $s_sel = "select statusID, status from braddoro.cfg_eve_mining_order_status where active = 1 order by status"; echo row_input_select($s_fieldName = "orderStatusID", $s_sel, $i_orderStatusID, $left_class = "odd", $right_class = "even", $s_fieldString = "Status") . $g_break; $s_sel = "select priorityID, priority from braddoro.cfg_eve_mining_priority where active = 1 order by displayOrder"; echo row_input_select($s_fieldName = "priorityID", $s_sel, $i_priorityID, $left_class = "odd", $right_class = "even", $s_fieldString = "Priority") . $g_break; echo row_input_text($s_fieldName = "client", $i_fieldSize = 30, $s_data = trim($s_client), $left_class = "odd", $right_class = "even", $s_fieldString = "Client") . $g_break; echo '<tr>' . $g_break; echo '<td class="odd">Order Date</td>' . $g_break; echo '<td class="even"><input id="orderDate" name="orderDate" type="text" value="' . strtotime($s_orderDate) . '" class="date demo_vista" /></td>'; echo '</tr>' . $g_break; echo '<tr>' . $g_break; echo '<td class="odd">Due Date</td>' . $g_break; echo '<td class="even"><input id="dueDate" name="dueDate" type="text" value="' . strtotime($s_dueDate) . '" class="date demo_vista"/></td>' . $g_break; echo '</tr>' . $g_break; echo '<tr>' . $g_break; echo '<td class="odd">Lead Miner</td>' . $g_break; echo '<td class="even"><input id="leadMiner" name="leadMiner" type="text" value="' . $s_leadMiner . '" class="fields"/></td>'; echo '</tr>' . $g_break; echo '<tr>' . $g_break; echo '<td class="odd">Deliver To</td>' . $g_break; echo '<td class="even"><input id="deliverySystem" name="deliverySystem" type="text" value="' . $s_deliverySystem . '" class="fields"/></td>';
die_well(__LINE__, mysql_error(), $s_sql);
}
echo row_input_select($q_list = $q_list, $s_fieldName = "projectID", $i_items = 0, $i_data = $i_projectID, $left_class = "odd", $right_class = "even", $s_fieldString = "Project", $use_input = 1, $use_hidden = 0, $value_only = 0) . $g_break;
mysql_free_result($q_list);
$s_sql = 'select timeTypeID, timeType from cms.cfg_time_types where active = 1 order by timeType;';
$q_list = mysql_query($s_sql);
if (!$q_list) {
die_well(__LINE__, mysql_error(), $s_sql);
}
echo row_input_select($q_list = $q_list, $s_fieldName = "timeTypeID", $i_items = 0, $i_data = $i_timeTypeID, $left_class = "odd", $right_class = "even", $s_fieldString = "Action", $use_input = 1, $use_hidden = 0, $value_only = 0) . $g_break;
mysql_free_result($q_list);
echo row_input_text($s_fieldName = "actionDateTime", $i_fieldSize = 20, $s_data = $s_actionDateTime, $left_class = "odd", $right_class = "even", $s_fieldString = "Action Date/Time", $use_input = 1, $use_hidden = 0, $value_only = 0) . $g_break;
echo row_input_text($s_fieldName = "duration", $i_fieldSize = 5, $s_data = $i_duration, $left_class = "odd", $right_class = "even", $s_fieldString = "Duration", $use_input = 1, $use_hidden = 0, $value_only = 0) . $g_break;
echo row_input_text($s_fieldName = "action", $i_fieldSize = 50, $s_data = $s_action, $left_class = "odd", $right_class = "even", $s_fieldString = "Action", $use_input = 1, $use_hidden = 0, $value_only = 0) . $g_break;
echo row_input_memo($s_fieldName = "description", $i_rows = 10, $i_cols = 80, $s_data = $s_description, $left_class = "odd", $right_class = "even", $s_fieldString = "Description", $use_input = 1, $use_hidden = 0, $value_only = 0) . $g_break;
echo row_input_text($s_fieldName = "miles", $i_fieldSize = 5, $s_data = $i_miles, $left_class = "odd", $right_class = "even", $s_fieldString = "Miles", $use_input = 1, $use_hidden = 0, $value_only = 0) . $g_break;
if ($i_actionID > 0) {
$s_text = "Save";
} else {
$s_text = "Add";
}
echo '<tr>' . $g_break;
echo '<td class="odd"> </td>' . $g_break;
echo '<td class="even"><input type="submit" id="submit_form" name="submit_form" value="' . $s_text . '"></td>' . $g_break;
echo '</tr>' . $g_break;
echo '</table>' . $g_break;
echo '</form>';
break;
case "report":
echo $s_header;
$s_sql = 'select min(actionDateTime), max(actionDateTime) from cms.log_timetrack where yearweek(actionDateTime,0) = ' . $s_week . ';';
$i_moon = $rowData[4];
$i_active = $rowData[5];
$i_ownerID = $rowData[6];
}
echo '<a href="' . $s_fileName . '&pid=' . $s_pid . '" target="_top"><img src="../../images/Button-Info-16x16.png" border="0" height="12" width="12" title="List"></a>';
echo '<form id="frmForm" name="frmForm" action="' . $s_fileName . '" method="post">';
echo '<input type="hidden" name="page_task" id="page_task" value="' . $page_task . '">';
echo '<input type="hidden" name="pid" id="pid" value="' . $s_pid . '">';
echo '<table style="border-collapse: collapse;">' . $g_break;
echo row_input_text($s_fieldName = "towerID", $i_fieldSize = 5, $s_data = $i_towerID, $left_class = "odd", $right_class = "even", $s_fieldString = "Tower ID", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo row_input_text($s_fieldName = "towerTypeID", $i_fieldSize = 5, $s_data = $i_towerTypeID, $left_class = "odd", $right_class = "even", $s_fieldString = "Tower Size") . $g_break;
echo row_input_text($s_fieldName = "system", $i_fieldSize = 30, $s_data = trim($s_system), $left_class = "odd", $right_class = "even", $s_fieldString = "System") . $g_break;
echo row_input_text($s_fieldName = "planet", $i_fieldSize = 5, $s_data = $i_planet, $left_class = "odd", $right_class = "even", $s_fieldString = "Planet") . $g_break;
echo row_input_text($s_fieldName = "moon", $i_fieldSize = 5, $s_data = $i_moon, $left_class = "odd", $right_class = "even", $s_fieldString = "Moon") . $g_break;
echo row_input_text($s_fieldName = "active", $i_fieldSize = 5, $s_data = $i_active, $left_class = "odd", $right_class = "even", $s_fieldString = "Active") . $g_break;
echo row_input_text($s_fieldName = "ownerID", $i_fieldSize = 5, $s_data = $i_ownerID, $left_class = "odd", $right_class = "even", $s_fieldString = "Owner ID") . $g_break;
if ($i_towerID > 0) {
$s_text = "Save";
} else {
$s_text = "Add";
}
echo '<tr>' . $g_break;
echo '<td class="odd"> </td>' . $g_break;
echo '<td class="even"><input type="submit" id="submit_form" name="submit_form" value="' . $s_text . '"></td>' . $g_break;
echo '</tr>' . $g_break;
echo '</table>' . $g_break;
echo '</form>';
break;
}
echo '</table>';
echo '<script language="javascript">' . $g_break;
$s_size = $rowData[6];
$i_reactionID = $rowData[7];
$i_towerID = $rowData[8];
}
echo '<a href="' . $s_fileName . '?pid=' . $s_pid . '" target="_top"><img src="../../images/Button-Info-16x16.png" border="0" height="12" width="12" title="List"></a>';
echo '<form id="frmForm" name="frmForm" action="' . $s_fileName . '" method="post">';
echo '<input type="hidden" name="page_task" id="page_task" value="' . $page_task . '">';
echo '<input type="hidden" name="pid" id="pid" value="' . $s_pid . '">';
echo '<table style="border-collapse: collapse;">' . $g_break;
echo row_input_text($s_fieldName = "", $i_fieldSize = 5, $s_data = $s_owner, $left_class = "odd", $right_class = "accentrow", $s_fieldString = "Owner", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo row_input_text($s_fieldName = "", $i_fieldSize = 5, $s_data = $s_system, $left_class = "odd", $right_class = "accentrow", $s_fieldString = "System", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo row_input_text($s_fieldName = "", $i_fieldSize = 5, $s_data = $i_planet, $left_class = "odd", $right_class = "accentrow", $s_fieldString = "Planet", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo row_input_text($s_fieldName = "", $i_fieldSize = 5, $s_data = $i_moon, $left_class = "odd", $right_class = "accentrow", $s_fieldString = "Moon", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo row_input_text($s_fieldName = "", $i_fieldSize = 5, $s_data = $s_race, $left_class = "odd", $right_class = "accentrow", $s_fieldString = "Race", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo row_input_text($s_fieldName = "", $i_fieldSize = 5, $s_data = $s_size, $left_class = "odd", $right_class = "accentrow", $s_fieldString = "Size", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo row_input_text($s_fieldName = "xrefID", $i_fieldSize = 5, $s_data = $i_xrefID, $left_class = "odd", $right_class = "even", $s_fieldString = "xref ID", $use_input = 0, $use_hidden = 1, $value_only = 1) . $g_break;
echo '<tr>' . $g_break;
echo '<td class="odd">Tower</td>' . $g_break;
echo '<td class="even">' . $g_break;
$s_sql = 'select T.towerID, T.system, T.planet, T.moon from dyn_pos_tower T order by T.system, T.planet, T.moon;';
$q_list = mysql_query($s_sql);
if (!$q_list) {
die_well(__LINE__, mysql_error());
}
echo '<select id="towerID" name="towerID">' . $g_break;
echo '<option value="0">Select an Option</option>' . $g_break;
while ($listrow = mysql_fetch_row($q_list)) {
$i_loop = $listrow[0];
$s_string = $listrow[1] . ' ' . $listrow[2] . '-' . $listrow[3];
if ($i_loop == $i_towerID) {
$s_sel = " SELECTED";
