* * Script to duplicate BoMs. */ include('includes/session.php'); $Title = _('Copy a BOM to New Item Code'); include('includes/header.php'); include('includes/SQL_CommonFunctions.inc'); if(isset($_POST['Submit'])) { $StockID = $_POST['StockID']; $NewOrExisting = $_POST['NewOrExisting']; $NewStockID = ''; $InputError = 0; //assume the best if($NewOrExisting == 'N') { $NewStockID = $_POST['ToStockID']; if (mb_strlen($NewStockID)==0 OR $NewStockID==''){ $InputError = 1; prnMsg(_('The new item code cannot be blank. Enter a new code for the item to copy the BOM to'),'error'); } } else { $NewStockID = $_POST['ExStockID']; } if ($InputError==0){ $result = DB_Txn_Begin(); if($NewOrExisting == 'N') { /* duplicate rows into stockmaster */ $sql = "INSERT INTO stockmaster( stockid, categoryid, description, longdescription, units, mbflag, actualcost, lastcost, materialcost, labourcost, overheadcost, lowestlevel, discontinued, controlled, eoq, volume, grossweight, barcode, discountcategory, taxcatid, serialised, perishable, digitals, nextserialno, pansize, shrinkfactor, netweight ) SELECT '".$NewStockID."' AS stockid, categoryid, description, longdescription, units, mbflag, actualcost, lastcost, materialcost, labourcost, overheadcost, lowestlevel, discontinued, controlled, eoq, volume, grossweight, barcode, discountcategory, taxcatid, serialised, perishable, digitals, nextserialno, pansize, shrinkfactor, netweight FROM stockmaster WHERE stockid='".$StockID."';"; $result = DB_query($sql); } else { $sql = "SELECT lastcostupdate, actualcost, lastcost, materialcost, labourcost, overheadcost, lowestlevel FROM stockmaster WHERE stockid='".$StockID."';"; $result = DB_query($sql); $myrow = DB_fetch_row($result); $sql = "UPDATE stockmaster set lastcostupdate = '" . $myrow[0] . "', actualcost = " . $myrow[1] . ", lastcost = " . $myrow[2] . ", materialcost = " . $myrow[3] . ", labourcost = " . $myrow[4] . ", overheadcost = " . $myrow[5] . ", lowestlevel = " . $myrow[6] . " WHERE stockid='".$NewStockID."';"; $result = DB_query($sql); } $sql = "INSERT INTO bom SELECT '".$NewStockID."' AS parent, sequence, component, workcentreadded, loccode, effectiveafter, effectiveto, quantity, autoissue, remark, digitals FROM bom WHERE parent='".$StockID."';"; $result = DB_query($sql); if($NewOrExisting == 'N') { $sql = "INSERT INTO locstock (loccode, stockid, quantity, reorderlevel, bin ) SELECT loccode, '".$NewStockID."' AS stockid, 0 AS quantity, reorderlevel, bin FROM locstock WHERE stockid='".$StockID."'"; $result = DB_query($sql); } $result = DB_Txn_Commit(); UpdateCost($NewStockID); header('Location: BOMs.php?Select='.$NewStockID); ob_end_flush(); } //end if there is no input error } else { echo '

' . ' ' . $Title . '

'; echo '

'; echo ''; $sql = "SELECT stockid, description FROM stockmaster WHERE stockid IN (SELECT DISTINCT parent FROM bom) AND mbflag IN ('M', 'A', 'K', 'G');"; $result = DB_query($sql); echo ''; echo ''; echo ''; echo ''; $sql = "SELECT stockid, description FROM stockmaster WHERE stockid NOT IN (SELECT DISTINCT parent FROM bom) AND mbflag IN ('M', 'A', 'K', 'G');"; $result = DB_query($sql); if (DB_num_rows($result) > 0) { echo ''; } echo '

' . _('From Stock ID') . '
' . _(' To New Stock ID') . '
' . _('To Existing Stock ID') . '	'; echo '

'; echo '

'; include('includes/footer.php'); } ?>