';
$content .= theme( 'table', array(
'header' => $table_headers,
'rows' => $table_rows,
));
$content .= '
';
return $content;
}
/*
* theme_add_parts_table_callback()
*
* AJAX call from the browser, only replaces the existing table
* Does not refresh the whole screen
* Rebuilds the table display when a part record is added or deleted.
* No DB interaction, strictly theme formatting
* Data is retained in a hidden textfield
*/
function theme_add_parts_table_callback() {
// break parts list into individual part records '|' delimited
// each part record is further delimited by '~' for part_no + ~ + quantity + ~ + description
$pl = trim($_POST['parts_list']);
$part_list = array();
$table_rows = array();
if ( strlen($pl) > 0 ) {
$part_list = explode('|', $pl);
}
$i = 0;
foreach($part_list as $precord) {
$link_options = l( t('Delete'), "", array('attributes' => array('class' => array('qms-parts-delete'),
'row' => $i)) ) ;
$part_array = explode('~', $precord);
// combine descrip, SN IN and SN Out into one field
// unset individ cols
$descrip = $part_array[2] . '
' .
t('S/N In') . ': ' . $part_array[3] . '
' .
t('S/N Out') . ': ' . $part_array[4];
$part_array[2] = $descrip;
unset($part_array[3]);
unset($part_array[4]);
$part_array[] = $link_options;
$table_rows[] = array('data' => $part_array);
unset($part_array);
}
$table_header =
array(
array('data' => t('Part No'), 'class' => array('qms-parts-tbl-col1')),
array('data' => t('Qty'), 'class' => array('qms-parts-tbl-col2')),
array('data' => t('Description'), 'class' => array('qms-parts-tbl-col3')),
array('data' => t('Options'), 'class' => array('qms-parts-tbl-col4')),
);
// rebuild table
$content = '
';
$content .= theme( 'table', array(
'header' => $table_header,
'rows' => $table_rows,
'empty' => t('None'),
));
$content .= '
';
die($content);
}
/*
* _get_discrepancy_parts($discrepancy_id)
*/
function _get_discrepancy_parts($discrepancy_id) {
try {
if ( $discrepancy_id == 0 ) {
return array();
}
$sql = "SELECT part_id, part_no, quantity, description,
serial_number_in, serial_number_out
FROM {qms_discrepancy_parts} p
WHERE discrepancy_id = :did ORDER BY part_id";
return db_query($sql, array(':did' => $discrepancy_id))->fetchAll();
}
catch (Exception $e) {
watchdog('sabreQMS', '_get_discrepancy_parts()' . $e->getMessage(),
array(), WATCHDOG_ERROR);
}
}
/*
* _get_discrepancy_part($part_id)
*/
function _get_discrepancy_part($part_id) {
try {
$part = (object) Null;
if ( $part_id == 0 ) {
return $part;
}
$sql = "SELECT part_id, part_no, quantity, description,
serial_number_in, serial_number_out
FROM {qms_discrepancy_parts} p
WHERE part_id = :pid";
$result = db_query($sql, array(':pid' => $part_id));
if ( $result->rowCount() ) {
$part = $result->fetchObject();
}
return $part;
}
catch (Exception $e) {
watchdog('sabreQMS', '_get_discrepancy_part()' . $e->getMessage(),
array(), WATCHDOG_ERROR);
}
}