$value) { $p_id = (int)$value; tep_db_query("UPDATE " . TABLE_PRODUCTS. " SET products_quantity = '".$global_qty."' WHERE products_id = '".(int)$p_id."'"); } tep_redirect(tep_href_link('stockadd.php', tep_get_all_get_params(array('x','y','action')))); break; */ // LIST the stockchanges - NEW for STOCKADD // ******************** case 'list': break; // Saving the data - MODIFIED for STOCKADD // ******************** case 'save': $qtyold = (int)$_POST['qty']; $qtyadd = (int)$_POST['qtyadd']; $qtynew = $qtyold + $qtyadd; $products_id = (int)$_GET['pID']; $products_model = $_POST['products_model']; $products_name = $_POST['products_name']; $stockdate = $_POST['stockdate']; $stockinfo = $_POST['stockinfo']; tep_db_query("UPDATE " . TABLE_PRODUCTS . " SET products_quantity = '".$qtynew."' WHERE products_id = '".(int)$products_id."'"); // now add info in the database of stockchanges tep_db_query("insert into stockadd SET qtyold = '".$qtyold."', products_id = '".(int)$products_id."', products_model = '".$products_model."', products_name ='". $products_name ."', date = DATETIME('". $stockdate ."'), info ='". $stockinfo ."', qtynew = '" .$qtynew ."', qtyadd ='" .$qtyadd ."'"); tep_redirect(tep_href_link('stockadd.php', tep_get_all_get_params(array('x','y','action','pID')).'pID='.$products_id)); break; } } //define('TEXT_DISPLAY_NUMBER_OF_PRODUCTS', 'Displaying %d to %d (of %d products)'); ?> > <?php echo TITLE; ?>
$val) { if(strstr($key,'search') === false && strstr($key,'p_model') === false) echo tep_draw_hidden_field($key,$val); } echo ''; echo ''; ?>
'' . $pInfo->products_model . ': ' . $pInfo->products_name . ''); $contents = array('form' => tep_draw_form('products_edit_form', 'stockadd.php', tep_get_all_get_params(array('page','pID','action')). 'page=' . $HTTP_GET_VARS['page'] . '&pID=' . $pInfo->products_id . '&action=save')); $contents[] = array('text' => '' . tep_draw_hidden_field('products_model', $pInfo->products_model)); $contents[] = array('text' => '' . tep_draw_hidden_field('products_name', $pInfo->products_name)); $contents[] = array('text' => '' . tep_draw_hidden_field('qty', $pInfo->products_quantity)); // Change qty by +/-; The new qty will be calculated later $contents[] = array('text' => '
Change qty by +/-; The new qty will be calculated later
' . tep_draw_input_field('qtyadd', $pInfo->products_quantity_add)); // Date $contents[] = array('text' => '
Date
' . tep_draw_input_field('stockdate', $pInfo->stockdate, 'size="10"')); // Info-Text $contents[] = array('text' => '
Info
' . tep_draw_input_field('stockinfo', $pInfo->stockinfo, 'size="40" ')); $contents[] = array('align' => 'center', 'text' => '
' . tep_image_submit('button_update.gif', IMAGE_UPDATE) . ' ' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; default: if (is_object($pInfo)) { $heading[] = array('text' => '' . $pInfo->products_name . ''); $contents[] = array('align' => 'center', 'text' => '' . tep_image_button('button_edit.gif', IMAGE_EDIT) . ''); } break; } if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) { echo ' ' . "\n"; } ?>
0) { $products_query = tep_db_query($products_query_raw); while ($products = tep_db_fetch_array($products_query)) { if ((!isset($HTTP_GET_VARS['pID']) || (isset($HTTP_GET_VARS['pID']) && ($HTTP_GET_VARS['pID'] == $products['products_id']))) && !isset($pInfo) && (substr($action, 0, 3) != 'new')) { $pInfo = new objectInfo($products); } if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id) ) { echo ' ' . "\n"; $link = 'onclick="document.location.href=\'' . tep_href_link('stockadd.php', tep_get_all_get_params(array('page','pID','action')).'page=' . $HTTP_GET_VARS['page'] . '&pID=' . $pInfo->products_id . '&action=edit') . '\'"'; } else { echo ' ' . "\n"; $link = 'onclick="document.location.href=\'' . tep_href_link('stockadd.php', tep_get_all_get_params(array('page','pID','action')).'page=' . $HTTP_GET_VARS['page'] . '&pID=' . $products['products_id']) . '\'"'; } ?> '.$products['products_model'].''; echo ' '; echo ' '; echo ' '; ?>
'. $products['products_name'].''. $products['products_quantity'].''. ( (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id))?(tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif')):('' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '')).' 
display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page','action'))); ?>
' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo '