Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
O Formulário de cadastro de produtos busca as categorias a que esses produtos pertecem, o cadastro das categorias acontece de forma normal, porem quando vou selecionar a categoria no formulario de cadastro de produtos, clico no menu drop e mostra todas as categorias mas nao me permite selecionar nenhuma das categorias exceto a primeira.
Segue o código abaixo :
CODE
<?php
/ $Revision: 1.39 $ /
$PageSecurity = 11;
include('includes/session.inc');
$title = _('Manutenção de Itens');
include('includes/header.inc');/If this form is called with the StockID then it is assumed that the stock item is to be modified /
if (isset($_GET['StockID'])){
$StockID =trim(strtoupper($_GET['StockID']));
} elseif (isset($_POST['StockID'])){
$StockID =trim(strtoupper($_POST['StockID']));
}
?>
<script LANGUAGE="JavaScript">
function ReloadForm(form)
{
document.ItemForm.submit.click();
//var val=ItemForm.StockID.value;
self.location='Stocks.php?&StockID=' + ItemForm.StockID.value;
}
</script>
<?php
echo "<A HREF='" . $rootpath . '/SelectProduct.php?' . SID . "'>" . _('Voltar Produtos') . '</A><BR>';
if (isset($_FILES['ItemPicture']) AND $_FILES['ItemPicture']['name'] !='') {
$result = $_FILES['ItemPicture']['error'];
$UploadTheFile = 'Yes'; //Assume all is well to start off with
$filename = $_SESSION['part_pics_dir'] . '/' . $StockID . '.jpg';
//But check for the worst
if (strtoupper(substr(trim($_FILES['ItemPicture']['name']),strlen($_FILES['ItemPicture']['name'])-3))!='JPG'){
prnMsg(_('Only jpg files are supported - a file extension of .jpg is expected'),'warn');
$UploadTheFile ='No';
} elseif ( $_FILES['ItemPicture']['size'] > ($_SESSION['MaxImageSize']*1024)) { //File Size Check
prnMsg(_('The file size is over the maximum allowed. The maximum size allowed in KB is') . ' ' . $_SESSION['MaxImageSize'],'warn');
$UploadTheFile ='No';
} elseif ( $_FILES['ItemPicture']['type'] == "text/plain" ) { //File Type Check
prnMsg( _('Only graphics files can be uploaded'),'warn');
$UploadTheFile ='No';
} elseif (file_exists($filename)){
prnMsg(_('Attempting to overwrite an existing item image'),'warn');
$result = unlink($filename);
if (!$result){
prnMsg(_('The existing image could not be removed'),'error');
$UploadTheFile ='No';
}
}
if ($UploadTheFile=='Yes'){
$result = move_uploaded_file($_FILES['ItemPicture']['tmp_name'], $filename);
$message = ($result)?_('File url') ."<a href='". $filename ."'>" . $filename . '</a>' : _('Something is wrong with uploading a file');
}
/* EOR Add Image upload for New Item - by Ori */
}
if (isset($_POST['submit'])) {
//initialise no input errors assumed initially before we test
$InputError = 0;
/* actions to take once the user has clicked the submit button
ie the page has called itself with some user input */
//first off validate inputs sensible
if (strlen($_POST['Description']) > 50 OR strlen($_POST['Description'])==0) {
$InputError = 1;
prnMsg (_('A DESCRICAO INFORMADA É MUITO CURTA OU MUITO LONGA') . '. ' . _('It cannot be a zero length string either') . ' - ' . _('A DESCRICAÇÃO É REQUERIDA'),'ERRO');
} elseif (strlen($_POST['LongDescription'])==0) {
$InputError = 1;
prnMsg (_('The stock item description cannot be a zero length string') . ' - ' . _('a long description is required'),'error');
} elseif (strlen($StockID) ==0) {
$InputError = 1;
prnMsg (_('The Stock Item code cannot be empty'),'error');
}elseif (strstr($StockID,' ') OR strstr($StockID,"'") OR strstr($StockID,'+') OR strstr($StockID,"\\") OR strstr($StockID,"\"") OR strstr($StockID,'&') OR strstr($StockID,'.') OR strstr($StockID,'"')) {
$InputError = 1;
prnMsg(_('The stock item code cannot contain any of the following characters') . " - ' & + \" \\ " . _('or a space'),'error');
} elseif (strlen($_POST['Units']) >20) {
$InputError = 1;
prnMsg(_('The unit of measure must be 20 characters or less long'),'error');
} elseif (strlen($_POST['BarCode']) >20) {
$InputError = 1;
prnMsg(_('The barcode must be 20 characters or less long'),'error');
} elseif (!is_numeric($_POST['Volume'])) {
$InputError = 1;
prnMsg (_('The volume of the packaged item in cubic metres must be numeric') ,'error');
} elseif ($_POST['Volume'] <0) {
$InputError = 1;
prnMsg(_('The volume of the packaged item must be a positive number'),'error');
} elseif (!is_numeric($_POST['KGS'])) {
$InputError = 1;
prnMsg(_('The weight of the packaged item in KGs must be numeric'),'error');
} elseif ($_POST['KGS'] <0) {
$InputError = 1;
prnMsg(_('The weight of the packaged item must be a positive number'),'error');
} elseif (!is_numeric($_POST['EOQ'])) {
$InputError = 1;
prnMsg(_('The economic order quantity must be numeric'),'error');
} elseif ($_POST['EOQ'] <0) {
$InputError = 1;
prnMsg (_('The economic order quantity must be a positive number'),'error');
}elseif ($_POST['Controlled']==0 AND $_POST['Serialised']==1){
$InputError = 1;
prnMsg(_('The item can only be serialised if there is lot control enabled already') . '. ' . _('Batch control') . ' - ' . _('with any number of items in a lot/bundle/roll is enabled when controlled is enabled') . '. ' . _('Serialised control requires that only one item is in the batch') . '. ' . _('For serialised control') . ', ' . _('both controlled and serialised must be enabled'),'error');
} elseif (($_POST['MBFlag']=='A' OR $_POST['MBFlag']=='K' OR $_POST['MBFlag']=='D') AND $_POST['Controlled']==1){
$InputError = 1;
prnMsg(_('Assembly/Kitset/Service items cannot also be controlled items') . '. ' . _('Assemblies/Dummies and Kitsets are not physical items and batch/serial control is therefore not appropriate'),'error');
} elseif (trim($_POST['CategoryID'])==''){
$InputError = 1;
prnMsg(_('There are no inventory categories defined. All inventory items must belong to a valid inventory category,'),'error');
}
if ($InputError !=1){
if ($_POST['Serialised']==1){ /*Not appropriate to have several dp on serial items */
$_POST['DecimalPlaces']=0;
}
if (!isset($_POST['New'])) { /*so its an existing one */
/*first check on the changes being made we must disallow:
- changes from manufactured or purchased to Service, Assembly or Kitset if there is stock - changes from manufactured, kitset or assembly where a BOM exists
*/
$sql = "SELECT mbflag,
controlled,
serialised
FROM stockmaster WHERE stockid = '$StockID'";
$MBFlagResult = DB_query($sql,$db);
$myrow = DB_fetch_row($MBFlagResult);
$OldMBFlag = $myrow[0];
$OldControlled = $myrow[1];
$OldSerialised = $myrow[2];
$sql = "SELECT SUM(locstock.quantity) FROM locstock WHERE stockid='$StockID'";
$result = DB_query($sql,$db);
$stkqtychk = DB_fetch_row($result);
if ($OldMBFlag != $_POST['MBFlag']){
if (($OldMBFlag == 'M' OR $OldMBFlag=='B') AND ($_POST['MBFlag']=='A' OR $_POST['MBFlag']=='K' OR $_POST['MBFlag']=='D')){ /*then need to check that there is no stock holding first */
if ($stkqtychk[0]!=0){
$InputError=1;
prnMsg( _('The make or buy flag cannot be changed from') . ' ' . $OldMBFlag . ' ' . _('to') . ' ' . $_POST['MBFlag'] . ' ' . _('where there is a quantity of stock on hand at any location') . '. ' . _('Currently there are') . ' ' . $stkqtychk[0] . ' ' . _('on hand') , 'errror');
}
if ($_POST['Controlled']==1){
$InputError=1;
prnMsg( _('The make or buy flag cannot be changed from') . ' ' . $OldMBFlag . ' ' . _('to') . ' ' . $_POST['MBFlag'] . ' ' . _('where the item is to be lot controlled') . '. ' . _('Kitset, dummy and assembly items cannot be lot controlled'), 'error');
}
}
/*now check that if the item is being changed to a kitset, there are no items on order sales or purchase orders*/
if ($_POST['MBFlag']=='K') {
$sql = "SELECT quantity-qtyinvoiced
FROM salesorderdetails
WHERE stkcode = '$StockID'
AND completed=0";
$result = DB_query($sql,$db);
$ChkSalesOrds = DB_fetch_row($result);
if ($ChkSalesOrds[0]!=0){
$InputError = 1;
prnMsg( _('The make or buy flag cannot be changed to a kitset where there is a quantity outstanding to be delivered on sales orders') . '. ' . _('Currently there are') .' ' . $ChkSalesOrds[0] . ' '. _('outstanding'), 'error');
}
}
/*now check that if it is to be a kitset or assembly or dummy there is no quantity on purchase orders outstanding*/
if ($_POST['MBFlag']=='K' OR $_POST['MBFlag']=='A' OR $_POST['MBFlag']=='D') {
$sql = "SELECT quantityord-quantityrecd
FROM purchorderdetails
WHERE itemcode = '$StockID'
AND completed=0";
$result = DB_query($sql,$db);
$ChkPurchOrds = DB_fetch_row($result);
if ($ChkPurchOrds[0]!=0){
$InputError = 1;
prnMsg( _('The make or buy flag cannot be changed to'). ' ' . $_POST['MBFlag'] . ' '. _('where there is a quantity outstanding to be received on purchase orders') . '. ' . _('Currently there are'). ' ' . $ChkPurchOrds[0] . ' '. _('yet to be received'). 'error');
}
}
/*now check that if it is was a Manufactured, Kitset or Assembly and is being changed to a purchased or dummy - that no BOM exists */
if (($OldMBFlag=='M' OR $OldMBFlag =='K' OR $OldMBFlag=='A') AND ($_POST['MBFlag']=='B' OR $_POST['MBFlag']=='D')) {
$sql = "SELECT COUNT(*) FROM bom WHERE parent = '$StockID'";
$result = DB_query($sql,$db);
$ChkBOM = DB_fetch_row($result);
if ($ChkBOM[0]!=0){
$InputError = 1;
prnMsg( _('The make or buy flag cannot be changed from manufactured, kitset or assembly to'). ' ' . $_POST['MBFlag'] . ' '. _('where there is a bill of material set up for the item') . '. ' . _('Bills of material are not appropriate for purchased or dummy items'), 'error');
}
}
/*now check that if it was Manufac or Purchased and is being changed to assembly or kitset, it is not a component on an existing BOM */
if (($OldMBFlag=='M' OR $OldMBFlag =='B' OR $OldMBFlag=='D') AND ($_POST['MBFlag']=='A' OR $_POST['MBFlag']=='K')) {
$sql = "SELECT COUNT(*) FROM bom WHERE component = '$StockID'";
$result = DB_query($sql,$db);
$ChkBOM = DB_fetch_row($result);
if ($ChkBOM[0]!=0){
$InputError = 1;
prnMsg( _('The make or buy flag cannot be changed from manufactured, purchased or dummy to a kitset or assembly where the item is a component in a bill of material') . '. ' . _('Assembly and kitset items are not appropriate as componennts in a bill of materials'), 'error');
}
}
}
/* Do some checks for changes in the Serial & Controlled setups */
if ($OldControlled != $_POST['Controlled'] AND $stkqtychk[0]!=0){
$InputError=1;
prnMsg( _('You can not change a Non-Controlled Item to Controlled (or back from Controlled to non-controlled when there is currently stock on hand for the item') , 'error');
}
if ($OldSerialised != $_POST['Serialised'] AND $stkqtychk[0]!=0){
$InputError=1;
prnMsg( _('You can not change a Serialised Item to Non-Serialised (or visa-versa) when there is a quantity on hand for the item') , 'error');
}
if ($InputError == 0){
$sql = "UPDATE stockmaster
SET longdescription='" . DB_escape_string($_POST['LongDescription']) . "',
description='" . DB_escape_string($_POST['Description']) . "',
discontinued=" . $_POST['Discontinued'] . ",
controlled=" . $_POST['Controlled'] . ",
serialised=" . $_POST['Serialised'].",
categoryid='" . $_POST['CategoryID'] . "',
units='" . DB_escape_string($_POST['Units']) . "',
mbflag='" . $_POST['MBFlag'] . "',
eoq=" . $_POST['EOQ'] . ",
volume=" . $_POST['Volume'] . ",
kgs=" . $_POST['KGS'] . ",
barcode='" . $_POST['BarCode'] . "',
discountcategory='" . $_POST['DiscountCategory'] . "',
taxcatid=" . $_POST['TaxCat'] . ",
decimalplaces=" . $_POST['DecimalPlaces'] . "
WHERE stockid='$StockID'";
$ErrMsg = _('The stock item could not be updated because');
$DbgMsg = _('The SQL that was used to update the stock item and failed was');
$result = DB_query($sql,$db,$ErrMsg,$DbgMsg);
//delete any properties for the item no longer relevant with the change of category
$result = DB_query("DELETE FROM stockitemproperties
WHERE stockid ='" . $StockID . "'",
$db);
//now insert any item properties
for ($i=0;$i<$_POST['PropertyCounter'];$i++){
if ($_POST['PropType' . $i] ==2){
if ($_POST['PropValue' . $i]=='on'){
$_POST['PropValue' . $i]=1;
} else {
$_POST['PropValue' . $i]=0;
}
}
$result = DB_query("INSERT INTO stockitemproperties (stockid,
stkcatpropid,
value)
VALUES ('" . $StockID . "',
" . $_POST['PropID' . $i] . ",
'" . $_POST['PropValue' . $i] . "')",
$db);
} //end of loop around properties defined for the category
prnMsg( _('Produto') . ' ' . $StockID . ' ' . _('está atualizado'), 'successo');
}
} else { //it is a NEW part
//but lets be really sure here
$result = DB_query("SELECT stockid FROM stockmaster WHERE stockid='" . $StockID ."'",$db);
if (DB_num_rows($result)==1){
prnMsg(_('The stock code entered is actually already in the database - duplicate stock codes are prohibited by the system. Try choosing an alternative stock code'),'error');
exit;
} else {
$sql = "INSERT INTO stockmaster (
stockid,
description,
longdescription,
categoryid,
units,
mbflag,
eoq,
discontinued,
controlled,
serialised,
volume,
kgs,
barcode,
discountcategory,
taxcatid,
decimalplaces)
VALUES ('$StockID',
'" . DB_escape_string($_POST['Description']) . "',
'" . DB_escape_string($_POST['LongDescription']) . "',
'" . $_POST['CategoryID'] . "',
'" . DB_escape_string($_POST['Units']) . "',
'" . $_POST['MBFlag'] . "',
" . $_POST['EOQ'] . ",
" . $_POST['Discontinued'] . ",
" . $_POST['Controlled'] . ",
" . $_POST['Serialised']. ",
" . $_POST['Volume'] . ",
" . $_POST['KGS'] . ",
'" . $_POST['BarCode'] . "',
'" . $_POST['DiscountCategory'] . "',
" . $_POST['TaxCat'] . ",
" . $_POST['DecimalPlaces']. "
)";
$ErrMsg = _('The item could not be added because');
$DbgMsg = _('The SQL that was used to add the item failed was');
$result = DB_query($sql,$db, $ErrMsg, $DbgMsg);
if (DB_error_no($db) ==0) {
$sql = "INSERT INTO locstock (loccode,
stockid)
SELECT locations.loccode,
'" . $StockID . "'
FROM locations";
$ErrMsg = _('The locations for the item') . ' ' . $myrow[0] . ' ' . _('could not be added because');
$DbgMsg = _('NB Locations records can be added by opening the utility page') . ' <i>Z_MakeStockLocns.php</i> ' . _('The SQL that was used to add the location records that failed was');
$InsResult = DB_query($sql,$db,$ErrMsg,$DbgMsg);
if (DB_error_no($db) ==0) {
prnMsg( _('New Item') .' ' . $StockID . ' '. _('has been added to the database'),'success');
unset($_POST['LongDescription']);
unset($_POST['Description']);
unset($_POST['EOQ']);
unset($_POST['CategoryID']);
unset($_POST['Units']);
unset($_POST['MBFlag']);
unset($_POST['Discontinued']);
unset($_POST['Controlled']);
unset($_POST['Serialised']);
unset($_POST['Volume']);
unset($_POST['KGS']);
unset($_POST['BarCode']);
unset($_POST['ReorderLevel']);
unset($_POST['DiscountCategory']);
unset($_POST['DecimalPlaces']);
unset($StockID);
}//ALL WORKED SO RESET THE FORM VARIABLES
}//THE INSERT OF THE NEW CODE WORKED SO BANG IN THE STOCK LOCATION RECORDS TOO
}//END CHECK FOR ALREADY EXISTING ITEM OF THE SAME CODE
}
} else {
echo '<BR>';
prnMsg( _('Validation failed, no updates or deletes took place'), 'error');
}
} elseif (isset($_POST['delete']) AND strlen($_POST['delete']) >1 ) {//the button to delete a selected record was clicked instead of the submit button
$CancelDelete = 0;
// PREVENT DELETES IF DEPENDENT RECORDS IN 'StockMoves'
$sql= "SELECT COUNT(*) FROM stockmoves WHERE stockid='$StockID'";
$result = DB_query($sql,$db);
$myrow = DB_fetch_row($result);
if ($myrow[0]>0) {
$CancelDelete = 1;
prnMsg( _('Cannot delete this stock item because there are stock movements that refer to this item'),'warn');
echo '<BR>' . _('There are') . ' ' . $myrow[0] . ' ' . _('stock movements that refer to this item');
} else {
$sql= "SELECT COUNT(*) FROM bom WHERE component='$StockID'";
$result = DB_query($sql,$db);
$myrow = DB_fetch_row($result);
if ($myrow[0]>0) {
$CancelDelete = 1;
prnMsg( _('Cannot delete this item record because there are bills of material that require this part as a component'),'warn');
echo '<br>' . _('There are') . ' ' . $myrow[0] . ' ' . _('bills of material that require this part as a component');
} else {
$sql= "SELECT COUNT(*) FROM salesorderdetails WHERE stkcode='$StockID'";
$result = DB_query($sql,$db);
$myrow = DB_fetch_row($result);
if ($myrow[0]>0) {
$CancelDelete = 1;
prnMsg( _('Cannot delete this item record because there are existing sales orders for this part'),'warn');
echo '<BR>' . _('There are') . ' ' . $myrow[0] . ' ' . _('sales order items against this part');
} else {
$sql= "SELECT COUNT(*) FROM salesanalysis WHERE stockid='$StockID'";
$result = DB_query($sql,$db);
$myrow = DB_fetch_row($result);
if ($myrow[0]>0) {
$CancelDelete = 1;
prnMsg(_('Cannot delete this item because sales analysis records exist for it'),'warn');
echo '<BR>' . _('There are') . ' ' . $myrow[0] . ' ' . _('sales analysis records against this part');
} else {
$sql= "SELECT COUNT(*) FROM purchorderdetails WHERE itemcode='$StockID'";
$result = DB_query($sql,$db);
$myrow = DB_fetch_row($result);
if ($myrow[0]>0) {
$CancelDelete = 1;
prnMsg(_('Cannot delete this item because there are existing purchase order items for it'),'warn');
echo '<BR>' . _('There are') . ' ' . $myrow[0] . ' ' . _('purchase order item record relating to this part');
} else {
$sql = "SELECT SUM(quantity) AS qoh FROM locstock WHERE stockid='$StockID'";
$result = DB_query($sql,$db);
$myrow = DB_fetch_row($result);
if ($myrow[0]!=0) {
$CancelDelete = 1;
prnMsg( _('Cannot delete this item because there is currently some stock on hand'),'warn');
echo '<BR>' . _('There are') . ' ' . $myrow[0] . ' ' . _('on hand for this part');
}
}
}
}
}
}
if ($CancelDelete==0) {
$result = DB_query('BEGIN', $db);
/*Deletes LocStock records*/
$sql ="DELETE FROM locstock WHERE stockid='$StockID'";
$result=DB_query($sql,$db,_('Could not delete the location stock records because'),'',true);
/*Deletes Price records*/
$sql ="DELETE FROM prices WHERE stockid='$StockID'";
$result=DB_query($sql,$db,_('Could not delete the prices for this stock record because'),'',true);
/*and cascade deletes in PurchData */
$sql ="DELETE FROM purchdata WHERE stockid='$StockID'";
$result=DB_query($sql,$db,_('Could not delete the purchasing data because'),'',true);
/*and cascade delete the bill of material if any */
$sql = "DELETE FROM bom WHERE parent='$StockID'";
$result=DB_query($sql,$db,_('Could not delete the bill of material because'),'',true);
$sql="DELETE FROM stockmaster WHERE stockid='$StockID'";
$result=DB_query($sql,$db, _('Could not delete the item record'),'',true);
$result = DB_query('COMMIT', $db);
prnMsg(_('Deleted the stock master record for') . ' ' . $StockID . '....' .
'<BR>. . ' . _('and all the location stock records set up for the part') .
'<BR>. . .' . _('and any bill of material that may have been set up for the part') .
'<BR> . . . .' . _('and any purchasing data that may have been set up for the part') .
'<BR> . . . . .' . _('and any prices that may have been set up for the part'),'success');
unset($_POST['LongDescription']);
unset($_POST['Description']);
unset($_POST['EOQ']);
unset($_POST['CategoryID']);
unset($_POST['Units']);
unset($_POST['MBFlag']);
unset($_POST['Discontinued']);
unset($_POST['Controlled']);
unset($_POST['Serialised']);
unset($_POST['Volume']);
unset($_POST['KGS']);
unset($_POST['BarCode']);
unset($_POST['ReorderLevel']);
unset($_POST['DiscountCategory']);
unset($_POST['TaxCat']);
unset($_POST['DecimalPlaces']);
unset($StockID);
unset($_SESSION['SelectedStockItem']);
//echo "<META HTTP-EQUIV='Refresh' CONTENT='0; URL=" . $rootpath . '/SelectProduct.php?' . SID ."'>";
} //end if Delete Part
}
echo '<form name="ItemForm" enctype="multipart/form-data" method="post" action="' . $_SERVER['PHP_SELF'] . '?' .SID .'"><center><table>
<tr><td><table>'; //Nested tableif (!isset($StockID)) {
/If the page was called without $StockID passed to page then assume a new stock item is to be entered show a form with a part Code field other wise the form showing the fields with the existing entries against the part will show for editing with only a hidden StockID field. New is set to flag that the page may have called itself and still be entering a new part, in which case the page needs to know not to go looking up details for an existing part/
$New = true;
echo '<input type="hidden" name="New" value="1">';
echo '<TR><TD>'. _('Codigo'). ':</TD><TD><INPUT TYPE="TEXT" NAME="StockID" SIZE=21 MAXLENGTH=20></TD></TR>';
} elseif (!isset($_POST['submit'])) { // Must be modifying an existing item and no changes made yet
$sql = "SELECT stockid,
description,
longdescription,
categoryid,
units,
mbflag,
discontinued,
controlled,
serialised,
eoq,
volume,
kgs,
barcode,
discountcategory,
taxcatid,
decimalplaces
FROM stockmaster
WHERE stockid = '$StockID'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_array($result);
$_POST['LongDescription'] = $myrow['longdescription'];
$_POST['Description'] = $myrow['description'];
$_POST['EOQ'] = $myrow['eoq'];
$_POST['CategoryID'] = $myrow['categoryid'];
$_POST['Units'] = $myrow['units'];
$_POST['MBFlag'] = $myrow['mbflag'];
$_POST['Discontinued'] = $myrow['discontinued'];
$_POST['Controlled'] = $myrow['controlled'];
$_POST['Serialised'] = $myrow['serialised'];
$_POST['Volume'] = $myrow['volume'];
$_POST['KGS'] = $myrow['kgs'];
$_POST['BarCode'] = $myrow['barcode'];
$_POST['DiscountCategory'] = $myrow['discountcategory'];
$_POST['TaxCat'] = $myrow['taxcatid'];
$_POST['DecimalPlaces'] = $myrow['decimalplaces'];
echo '<TR><TD>' . _('Código') . ':</TD><TD>'.$StockID.'</TD></TR>';
echo "<input type='Hidden' name='StockID' value='$StockID'>";} else { // some changes were made to the data so don't re-set form variables to DB ie the code above
echo '<TR><TD>' . _('Item Code') . ':</TD><TD>'.$StockID.'</TD></TR>';
echo "<input type='Hidden' name='StockID' value='$StockID'>";
}
echo '<TR><TD>' . _('Descricao') . ' (' . _('curta') . '):</TD><TD><input type="Text" name="Description" SIZE=52 MAXLENGTH=50 value="' . htmlentities($_POST['Description'],ENT_QUOTES,_('ISO-8859-1')) . '"></TD></TR>';
echo '<TR><TD>' . _('Descricao') . ' (' . _('longa') . '):</TD><TD><textarea name="LongDescription" cols=40 rows=4>' . htmlentities($_POST['LongDescription'],ENT_QUOTES,_('ISO-8859-1')) . '</textarea></TD></TR>';// Add image upload for New Item - by Ori
echo '<tr><td>'. _('Arquivo de Imagem (.jpg)') . ':</td><td><input type="file" id="ItemPicture" name="ItemPicture"></td></tr>';// EOR Add Image upload for New Item - by Ori
echo '<tr><td>' . _('Categoria') . ':</td><td><select name="CategoryID" onChange="ReloadForm(this.form)">';
$sql = "SELECT categoryid, categorydescription FROM stockcategory order by categoryid";
//$ErrMsg = _('The stock categories could not be retrieved because');
//$DbgMsg = _('The SQL used to retrieve stock categories and failed was');
$result = DB_query($sql,$db);
if (!isset($_POST['categoryID'])){
$_POST['categoryID'] = $_SESSION['DefaultCategory'];
}while ($myrow=DB_fetch_array($result)){
if ($_post['categoryid']==$myrow['categoryid']){
echo '<OPTION SELECTED VALUE="'. $myrow['categoryid'] . '">' . $myrow['categorydescription'];
} else {
echo '<OPTION VALUE="'. $myrow['categoryid'] . '">' . $myrow['categorydescription'];
}
}
echo '</select><a target="_blank" href="'. $rootpath . '/StockCategories.php?' . SID . '">' . _('Adicionar ou Modificar Categorias') . '</a></td></tr>';
if ($_POST['EOQ']=='' or !isset($_POST['EOQ'])){
$_POST['EOQ']=0;
}
if ($_POST['Volume']=='' OR !isset($_POST['Volume'])){
$_POST['Volume']=0;
}
if ($_POST['KGS']=='' OR !isset($_POST['KGS'])){
$_POST['KGS']=0;
}
if ($_POST['Controlled']=='' OR !isset($_POST['Controlled'])){
$_POST['Controlled']=0;
}
if ($_POST['Serialised']=='' OR !isset($_POST['Serialised']) || $_POST['Controlled']==0){
$_POST['Serialised']=0;
}
if ($_POST['DecimalPlaces']=='' OR !isset($_POST['DecimalPlaces'])){
$_POST['DecimalPlaces']=0;
}
if ($_POST['Discontinued']=='' OR !isset($_POST['Discontinued'])){
$_POST['Discontinued']=0;
}
echo '<TR><TD>' . _('Quantidade Economica') . ':</TD><TD><input type="Text" name="EOQ" SIZE=12 MAXLENGTH=10 Value="' . $_POST['EOQ'] . '"></TD></TR>';
echo '<TR><TD>' . _('Volume Pacote (mt³)') . ':</TD><TD><input type="Text" name="Volume" SIZE=12 MAXLENGTH=10 value="' . $_POST['Volume'] . '"></TD></TR>';
echo '<TR><TD>' . _('Peso Pacote (KGs)') . ':</TD><TD><input type="Text" name="KGS" SIZE=12 MAXLENGTH=10 value="' . $_POST['KGS'] . '"></TD></TR>';
echo '<TR><TD>' . _('Unidade de Medida') . ':</TD><TD><SELECT name="Units">';
$sql = 'SELECT unitname FROM unitsofmeasure ORDER by unitname';
$UOMResult = DB_query($sql,$db);while( $UOMrow = DB_fetch_array($UOMResult) ) {
if ($_POST['Units']==$UOMrow['unitname']){
echo "<OPTION SELECTED Value='" . $UOMrow['unitname'] . "'>" . $UOMrow['unitname'];
} else {
echo "<OPTION Value='" . $UOMrow['unitname'] . "'>" . $UOMrow['unitname'];
}
}
echo '</SELECT></TD></TR>';
echo '<TR><TD>' . _('Feito, Comprado, Kit ou Aglomerado') . ':</TD><TD><SELECT name="MBFlag">';
if ($_POST['MBFlag']=='A'){
echo '<OPTION SELECTED VALUE="A">' . _('Aglomerado');} else {
echo '<OPTION VALUE="A">' . _('Aglomerado');
}
if ($_POST['MBFlag']=='K'){
echo '<OPTION SELECTED VALUE="K">' . _('Kit');} else {
echo '<OPTION VALUE="K">' . _('Kit');
}
if ($_POST['MBFlag']=='M'){
echo '<OPTION SELECTED VALUE="M">' . _('Manufaturado');} else {
echo '<OPTION VALUE="M">' . _('Manufaturado');
}
if ($_POST['MBFlag']=='B' OR !isset($_POST['MBFlag']) OR $_POST['MBFlag']==''){
echo '<OPTION SELECTED VALUE="B">' . _('Comprado');} else {
echo '<OPTION VALUE="B">' . _('Comprado');
}
if ($_POST['MBFlag']=='D'){
echo '<OPTION SELECTED VALUE="D">' . _('Serviço');} else {
echo '<OPTION VALUE="D">' . _('Serviço');
}
echo '</SELECT></TD></TR>';
echo '<TR><TD>' . _('Atual ou Obsoleto') . ':</TD><TD><SELECT name="Discontinued">';
if ($_POST['Discontinued']==0){
echo '<OPTION SELECTED VALUE=0>' . _('Atual');} else {
echo '<OPTION VALUE=0>' . _('Atual');
}
if ($_POST['Discontinued']==1){
echo '<OPTION SELECTED VALUE=1>' . _('Obsoleto');} else {
echo '<OPTION VALUE=1>' . _('Obsoleto');
}
echo '</SELECT></TD></TR>';
echo '<TR><TD>' . _('Lote, Serie ou Controle') . ':</TD><TD><SELECT name="Controlled">';
if ($_POST['Controlled']==0){
echo '<OPTION SELECTED VALUE=0>' . _('Sem Controle');} else {
echo '<OPTION VALUE=0>' . _('Sem Controle');
}
if ($_POST['Controlled']==1){
echo '<OPTION SELECTED VALUE=1>' . _('Controlado');} else {
echo "<OPTION VALUE=1>" . _('Controlado');
}
echo '</SELECT></TD></TR>';
echo '<TR><TD>' . _('Serialisado') . ':</TD><TD><SELECT name="Serialised">';
if ($_POST['Serialised']==0){
echo '<OPTION SELECTED VALUE=0>' . _('Nao');} else {
echo '<OPTION VALUE=0>' . _('Nao');
}
if ($_POST['Serialised']==1){
echo '<OPTION SELECTED VALUE=1>' . _('Sim');} else {
echo '<OPTION VALUE=1>' . _('Sim');
}
echo '</SELECT><i>' . _('Obs.') . ', ' . _('Não tem nenhum efeito se o item não é controlado') . '</i></TD></TR>';
echo '<TR><TD>' . _('Casas decimais para exibir') . ':</TD><TD><input type="Text" name="DecimalPlaces" SIZE=1 MAXLENGTH=1 value="' . $_POST['DecimalPlaces'] . '"><TD></TR>';
echo '<TR><TD>' . _('Código de Barras') . ':</TD><TD><input type="Text" name="BarCode" SIZE=22 MAXLENGTH=20 value="' . $_POST['BarCode'] . '"></TD></TR>';
echo '<TR><TD>' . _('Categoria Desconto') . ':</TD><TD><input type="Text" name="DiscountCategory" SIZE=2 MAXLENGTH=2 value="' . $_POST['DiscountCategory'] . '"></TD></TR>';
echo '<TR><TD>' . _('Categoria Fiscal') . ':</TD><TD><SELECT NAME="TaxCat">';
$sql = 'SELECT taxcatid, taxcatname FROM taxcategories ORDER BY taxcatname';
$result = DB_query($sql, $db);
if (!isset($_POST['TaxCat'])){
$_POST['TaxCat'] = $_SESSION['DefaultTaxCategory'];
}while ($myrow = DB_fetch_array($result)) {
if ($_POST['TaxCat'] == $myrow['taxcatid']){
echo '<OPTION SELECTED VALUE=' . $myrow['taxcatid'] . '>' . $myrow['taxcatname'];
} else {
echo '<OPTION VALUE=' . $myrow['taxcatid'] . '>' . $myrow['taxcatname'];
}} //end while loop
echo '</SELECT></TD></TR>';
if (function_exists('imagecreatefrompng')){
$StockImgLink = '<img src="GetStockImage.php?SID&automake=1&textcolor=FFFFFF&bgcolor=CCCCCC'.
'&StockID='.urlencode($StockID).
'&text='.
'&width=64'.
'&height=64'.
'" >';} else {
if( file_exists($_SESSION['part_pics_dir'] . '/' .$StockID.'.jpg') ) {
$StockImgLink = '<img src="' . $_SESSION['part_pics_dir'] . '/' .$StockID.'.jpg" >';
} else {
$StockImgLink = _('No Image');
}
}
echo '</table></td><td><center>' . _('Image') . '<br>'.$StockImgLink . '</center></td></tr></table><center>';
if ($New) {
echo '<input type="Submit" name="submit" value="' . _('Inserir Novo Item') . '">';} else {
// Now the form to enter the item properties
echo '<table><tr><td class="tableheader" colspan="2">' . _('Propriedades da Categoria') . '</td></tr>';
$sql = "SELECT stkcatpropid,
label,
controltype,
defaultvalue
FROM stockcatproperties
WHERE categoryid ='" . DB_escape_string($_POST['CategoryID']) . "'
AND reqatsalesorder =0
ORDER BY stkcatpropid";
$PropertiesResult = DB_query($sql,$db);
$PropertyCounter = 0;
$PropertyWidth = array();
while ($PropertyRow=DB_fetch_array($PropertiesResult)){
$PropValResult = DB_query("SELECT value FROM
stockitemproperties
WHERE stockid='" . $StockID . "'
AND stkcatpropid =" . $PropertyRow['stkcatpropid'],
$db);
$PropValRow = DB_fetch_row($PropValResult);
$PropertyValue = $PropValRow[0];
echo '<input type="hidden" name="PropID' . $PropertyCounter . '" value=' .$PropertyRow['stkcatpropid'] .'>';
echo '<tr><td>' . $PropertyRow['label'] . '</td>
<td>';
switch ($PropertyRow['controltype']) {
case 0; //textbox
echo '<input type="textbox" name="PropValue' . $PropertyCounter . '" size="20" maxlength="100" value="' . $PropertyValue . '">';
break;
case 1; //select box
$OptionValues = explode(',',$PropertyRow['defaultvalue']);
echo '<select name="PropValue' . $PropertyCounter . '">';
foreach ($OptionValues as $PropertyOptionValue){
if ($PropertyOptionValue == $PropertyValue){
echo '<option selected value="' . $PropertyOptionValue . '">' . $PropertyOptionValue . '</option>';
} else {
echo '<option value="' . $PropertyOptionValue . '">' . $PropertyOptionValue . '</option>';
}
}
echo '</select>';
break;
case 2; //checkbox
echo '<input type="checkbox" name="PropValue' . $PropertyCounter . '"';
if ($PropertyValue==1){
echo '"checked"';
}
echo '>';
break;
} //end switch
echo '<input type="hidden" name="PropType' . $PropertyCounter .'" value=' . $PropertyRow['controltype'] . '>';
echo '</td></tr>';
$PropertyCounter++;
} //end loop round properties for the item category
echo '</table>';
echo '<input type="hidden" name="PropertyCounter" value=' . $PropertyCounter . '>';
echo '<input type="submit" name="submit" value="' . _('Atualizar') . '">';
echo '<P>';
prnMsg( _('Apenas clique no botão Excluir, se você tem certeza de que deseja excluir o item!') . _('Os marcadores serão feitos para garantir que não haja movimentos no estoque, análise do registro de vendas, comprar de itens') . '. ' . _('Não serão permitidas deleções'), 'warn', _('Atencao'));
echo '<P><input type="Submit" name="delete" value="' . _('Deletar este Item') . '" onclick="return confirm(\'' . _('Are You Sure?') . '\');">';
}
echo '</FORM></CENTER>';
include('includes/footer.inc');
?>Carregando comentários...