Priority: '; foreach ($bugsys->datastore['priority'] AS $priority) { echo '' . $priority['priority'] . ''; } echo '

Status: '; foreach ($bugsys->datastore['status'] AS $status) { echo '' . $status['status'] . ''; } echo '

Resolution: '; foreach ($bugsys->datastore['resolution'] AS $resolution) { echo '' . $resolution['resolution'] . ''; } echo '

Assigned to: No Assignment'; foreach ($bugsys->datastore['assignto'] AS $dev) { echo '' . construct_user_display($dev, false) . ''; } echo '

'; echo ''; } // ################################################################### if ($_POST['do'] == 'updateproduct') { sanitize(array('product' => INT, 'component' => INT, 'version' => INT)); var_dump($vars); if (!$vars['product'] OR !$vars['component'] OR !$vars['version']) { echo 'there was a problem selecting the product, component, or version'; exit; } $product = $bugsys->datastore['product']["$vars[product]"]; if (!$product) { echo 'please select a valid product'; exit; } $version = $bugsys->datastore['version']["$vars[version]"]; if (!$version) { echo 'please select a valid version'; exit; } // no component if ($vars['component'] == -1) { // not global version and version.productid != product.productid if ($version['productid'] != 0 AND $version['productid'] != $product['productid']) { echo 'invalid version specified'; exit; } } // using a component else { $component = $bugsys->datastore['product']["$vars[component]"]; // component has the right mother if ($component['componentmother'] == $product['productid']) { // version.productid != {component.productid | product.productid} if (($version['productid'] != $component['productid'] AND $version['productid'] != $product['productid']) AND $version['productid'] != 0) { echo 'invalid version specified'; exit; } } else { echo 'invalid component specified'; exit; } } // good-to-go $DB_sql->query("UPDATE " . TABLE_PREFIX . "bug SET productid = $vars[product], componentid = $vars[component], versionid = $vars[version] WHERE bugid = $bug[bugid]"); echo "changed product info"; } // ################################################################### if ($_REQUEST['do'] == 'editproduct') { sanitize(array('product' => INT, 'component' => INT, 'version' => INT)); // the user can hit the back button without reposting data... if (!$vars['product'] OR !$vars['component']) { $method = 'get'; } else { $method = 'post'; } echo '

'; $do = 'editproduct'; if (!$vars['product']) { echo 'Product: '; $products = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "product WHERE !componentmother ORDER BY displayorder ASC"); while ($product = $DB_sql->fetch_array($products)) { echo "$product[title]"; } echo ''; } else if (!$vars['component']) { echo 'Component: No Component'; $components = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "product WHERE componentmother IN ($vars[product]) ORDER BY displayorder ASC"); while ($component = $DB_sql->fetch_array($components)) { echo "$component[title]"; } echo ''; echo ''; } else if (!$vars['version']) { echo 'Version: '; $versions = $DB_sql->query(" SELECT version.*, product.componentmother, product.title AS productname FROM " . TABLE_PREFIX . "version AS version LEFT JOIN " . TABLE_PREFIX . "product ON (product.productid = version.productid) WHERE version.productid IN (0, $vars[product]" . iff($vars['component'] != -1, ", $vars[component]", '') . ") ORDER BY version.productid, version.displayorder ASC" ); while ($version = $DB_sql->fetch_array($versions)) { $versionlist["$version[productid]"][] = $version; $lookup["$version[productid]"] = array('componentmother' => $version['componentmother'], 'productname' => $version['productname']); } foreach ($versionlist AS $productid => $versions) { $prepend = '-- '; // global version if ($productid == 0) { echo ''; } // component else if ($lookup["$productid"]['componentmother']) { echo ''; } else { echo ''; } foreach ($versions AS $version) { echo '' . $prepend . $version['version'] . ''; } echo ''; } echo ''; echo ''; echo ''; $do = 'updateproduct'; } echo ''; echo '

'; echo '

'; } /*=====================================================================*\ || ################################################################### || # $HeadURL$ || # $Id$ || ################################################################### \*=====================================================================*/ ?>