0){ //error already exists $message['type'] = 'error'; $message['text'] = ' Product '.$specText.' already exists'; }else{ $sql='# insert new spec INSERT INTO dw_spec ( specText, specGSP, specCode, specShortDesc, specLongDesc, specExpiry, specStyle, specVersion, specUnitTypeText, specSend, specShowLoc, specEmailAddy, specActive, specModUser , specModDate, specChangeCode, specKGperPallet, specBagSize, specCSV, specSite , specPO , specRate) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , now() , ? , ? , ? , ? , ? , ? , ? )'; $types = ' s s s s s s i i s i i s i i s i i i i s d '; if(!$new_spec = savesql($link, $sql, $types, array($specText, $specGSP, $specCode, $specShortDesc, $specLongDesc, $specExpiry, $specStyle, 1 , $specUnitTypeText, $specSend, $specShowLoc, $specEmailAddy, 1 , $_SESSION['userID'], $specChangeCode, $specKGperPallet, $specBagSize, $specCSV, $_SESSION['userSite'], $specPO, $specRate), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); //need to sort out order of existing items /* ↓ Inserting before 5 1 2 3 4 5 6 7 8 select * where order>=5 1 2 3 4[5 6 7 8] set all of these to order++ 1 2 3 4[6 7 8 9] insert at 5 1 2 3 4[5]6 7 8 9 */ /* $sql2=' Select dw_spec.specID, dw_spec.specOrder From dw_spec Where dw_spec.specOrder >= ? And dw_spec.specSite = ? '; if(!$order_query = mysqli_prepared_query($link, $sql2, 'ii', array($specOrder, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql2, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); foreach($order_query as $order_row){ $sql3=' Update dw_spec Set specOrder = ? Where specID = ? '; if(!savesql($link, $sql3, 'ii', array(($order_row['specOrder']+1), $order_row['specID']), __FILE__, __LINE__)) reporterror(get_error(), $sql3, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } */ $message['type'] = 'warning'; $message['text'] = 'Do you wish to create limits for '.$specText.'?'; $message['extra'] = 'limit.php?s='.$new_spec; } }else{ if( isset($_POST['edit_delete']) && $_POST['edit_delete']!="" && $_POST['edit_delete']!=null && isset($_POST['edit_id'] ) && $_POST['edit_id' ]!="" && $_POST['edit_id' ]!=null ){ //check for duplicates $sql=' # get all cyphers that have this spec Select dw_cypher.cypherID, dw_cypher.cypherText, dw_cypher.cypherOrderID From dw_cypher Where dw_cypher.cypherSpec = ? AND dw_cypher.cypherSite = ? '; if(!$dup_query = mysqli_prepared_query($link, $sql, 'ii', array($_POST['edit_id'], $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); $num_rows = mysqli_prepared_num_rows($dup_query); if($num_rows>0){ //cannot delete $message['type'] = 'error'; if($num_rows==1){ //get the cypher $message['text'] = 'Cannot delete this product because it is used by '.$dup_query[0]['cypherText'].' '.$dup_query[0]['cypherOrderID'].'. You must delete this first'; }else{ $message['text'] = 'Cannot delete this product because it is used by '.$num_rows.' cyphers/batches. You must delete these first'; } }else{ //ok to delete $message['type'] = 'warning'; $message['text'] = 'Are you sure you want to delete? This action cannot be undone.'; $message['extra'] = clean($_POST['edit_id']); } }else{ if(isset($_POST['edit_id']) && $_POST['edit_id']!="" && $_POST['edit_id']!=null){ $sql=' UPDATE dw_spec SET specText = ?, specGSP = ?, specCode = ?, specShortDesc = ?, specLongDesc = ?, specExpiry = ?, specStyle = ?, specVersion = ?, specUnitTypeText = ?, specSend = ?, specShowLoc = ?, specEmailAddy = ?, specActive = ?, specModUser = ?, specModDate = now(), specChangeCode = ?, specKGperPallet = ?, specBagSize = ?, specCSV = ?, specPO = ?, specRate = ?, specBlurb = ? WHERE specID = ? '; if(!savesql($link, $sql, 'ssssssii siisiisiissdsi', array( clean($_POST['edit_text']), clean($_POST['edit_gsp']), clean($_POST['edit_code']), clean($_POST['edit_shortdesc']), clean($_POST['edit_longdesc']), $_POST['edit_expiry'], $_POST['edit_style'], $_POST['edit_version'], clean($_POST['edit_specunittypetext']), (isset($_POST['edit_send']) ? $_POST['edit_send'] : 0), (isset($_POST['edit_showloc']) ? $_POST['edit_showloc'] : 0), $_POST['edit_emailaddy'], (isset($_POST['edit_active']) ? $_POST['edit_active'] : 0), $_SESSION['userID'], $_POST['edit_reason'], $_POST['edit_kgperpallet'], $_POST['edit_bagsize'], $_POST['edit_csv'], $_POST['edit_specpo'], $_POST['edit_rate'], $_POST['edit_blurb'], $_POST['edit_id'] ), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); //$specOrder = $_POST['edit_order']; //$specOriginalOrder = $_POST['edit_original_order']; //if($specOrder != $specOriginalOrder){ //need to sort out order of existing items //if($specOrder > $specOriginalOrder){ /* Changing from 3 to 6 1 2(3)4 5(6)7 8 9 select * where order>3 and order<=6 1 2 3[4 5 6]7 8 9 set all of these to order-- 1 2 3[3 4 5]7 8 9 set order=6 where id=x 1 2[6]3 4 5 7 8 9 final: 1 2 3 4 5[6]7 8 9 */ /* $sql2=' Select dw_spec.specID, dw_spec.specOrder From dw_spec Where dw_spec.specOrder > ? And dw_spec.specOrder <= ? And dw_spec.specSite = ? '; if(!$order_query = mysqli_prepared_query($link, $sql2, 'iii', array($specOriginalOrder, $specOrder, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql2, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); foreach($order_query as $order_row){ $sql3=' Update dw_spec Set specOrder = ? Where specID = ? '; if(!savesql($link, $sql3, 'ii', array(($order_row['specOrder']+1), $order_row['specID']), __FILE__, __LINE__)) reporterror(get_error(), $sql3, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } */ //}else{ /* Changing from 6 to 3 1 2(3)4 5(6)7 8 9 select * where order>=3 and order<6 1 2[3 4 5]6 7 8 9 set all of these to order++ 1 2[4 5 6]6 7 8 9 set order=3 where id=x 1 2 4 5 6[3]7 8 9 final: 1 2[3]4 5 6 7 8 9 */ /* $sql4=' Select dw_spec.specID, dw_spec.specOrder From dw_spec Where dw_spec.specOrder >= ? And dw_spec.specOrder < ? And dw_spec.specSite = ? '; if(!$order_query = mysqli_prepared_query($link, $sql4, 'iii', array($specOrder, $specOriginalOrder, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql4, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); foreach($order_query as $order_row){ $sql5=' Update dw_spec Set specOrder = ? Where specID = ? '; if(!savesql($link, $sql5, 'ii', array(($order_row['specOrder']-1), $order_row['specID']), __FILE__, __LINE__)) reporterror(get_error(), $sql5, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } } } */ } } } } $title = 'Product'; require 'inc/head.php'; $menu = 'product'; require 'inc/menu.php'; if($debug) showdebug(); ?>

Please wait while loading...

Create new