HillCrest Jewelers Inventory Report

' . $title . '

' . "\n" . '

' . number_format($printout[0]) . '.00' . '

' . "\n\n"); }; if ($_GET['code'] == '5306712000') { //total inventory $data = mysql_query("select sum(retail) from jewelery;"); format_data($data, "Database Retail Total"); //current inventory $data = mysql_query("select sum(retail) from jewelery where `status` != 'sold' and `status` != 'returned' or `status` is null;"); format_data($data, "Current Inventory Retail"); //Ivan Gems $data = mysql_query("select sum(retail) from jewelery where `memo` = 'IVAN' and `status` != 'sold' and `status` != 'returned';"); format_data($data, "Ivan Gems Retail"); //Northern Mines $data = mysql_query("select sum(retail) from jewelery where `status` = 'Northern Mines';"); format_data($data, "Northern Mines"); }; ?>

' . "\n"); }; foreach ($items as $title) { add_form_printout($title); }; ?>

' . "\n" . '

' . $title . '

' . "\n" . '

' . "\n" . '' . "\n"); }; if (isset($_GET['oldnumber']) && !isset($_GET['actionsubmitedit'])) { $item_data = mysql_fetch_array(mysql_query("SELECT * FROM `jewelery` WHERE `itemnumber` = '" . $_GET['oldnumber'] . "';")); if (!$item_data['itemnumber'] == "") { ?>

No Such Item'); }; }; ?>

Shape

Weight

Clairty

Color

Depth

Table

Cert

Lab

MMA

MMB

MMC

Fluoresence

Crown Angle

Pavilion Angle

Crown Height

Pavilion Depth

Girdle

Cost

Price

Status

Memo

Memo ID

Memo Status