<?php
 include ("emenux.php"); 
 require ("conecta.php");
 $sw=$_POST['hdsw'];
 $sw2=$_POST['hdsw'];
 $cod_interno=strtoupper($_POST['cod_interno']);
 $cod_local="";
 $stock="";
 $costo_contable="";
 $stock_inicial="";
 $costo_inicial="";
 $cont=0;
 $error2= "0";
 $recomendacion2="0";
 if ($sw=="buscar"){
 $codigo=sprintf("%020d",$codigo);
  $sqlb="select * from m07005 where cod_interno = '$cod_interno' ;";
  $resb=mysql_query($sqlb,$con);
  if (mysql_num_rows($resb)>0){ 
   $sw="encontrado";
   $sw2="encontrado";
   while ($filab = mysql_fetch_row($resb)){
    $cod_local=$filab[1];
 	$stock=$filab[2];
	$costo_contable=$filab[3];
	$stock_inicial=$filab[4];
	$costo_inicial=$filab[5];
   }//while
  }else{
   $error2= "Codigo no encontrado.";
   $recomendacion2="->Agregar.";
  }//fin si
 }//fin de buscar
 if ($sw=="grabar"){
  $cod_interno=strtoupper($_POST['cod_interno']);
  $cod_local=$_POST['hdcod_local'];
  $stock=$_POST['stock'];
  $costo_contable=$_POST['costo_contable'];
  $stock_inicial=$_POST['stock_inicial'];
  $costo_inicial=$_POST['costo_inicial'];
  $sqlg="replace into m07005   (cod_interno,cod_local,stock,costo_contable,stock_inicial,costo_inicial)
   values ('$cod_interno','$cod_local','$stock','$costo_contable','$stock_inicial','$costo_inicial');";
  $resg=mysql_query($sqlg,$con); 
  $cod_local="";
  $stock="";
  $costo_contable="";
  $stock_inicial="";
  $costo_inicial="";
  $sw=""; 
 }//fin grabar 
 if ($sw=="eliminar"){
  $sqle="delete from m07005 where cod_interno='$cod_interno';";
  mysql_query($sqle,$con);
  $cod_local="";
  $stock="";
  $costo_contable="";
  $stock_inicial="";
  $costo_inicial="";
  $sw="";
 }//fin si de eliminar
// if (strlen($codcomuna)==0){$codcomuna="5406";}
// if (strlen($codcpago)==0){$codcpago="001";}
 //if (strlen($sexo)==0){$sexo="1";}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<TITLE>Maestro Existencias</TITLE>
<script language="javascript" src="fstandar.js">
</script>
<script language="javascript">
function ponelocal(){
 document.form1.hdcod_local.value=document.form1.cmblocal.value;
 window.alert(document.form1.hdcod_local.value);
}
function valida(){ 
 if (document.form1.cod_interno.value.length > 0){
  err=0;
  if (err==0){
   document.form1.hdsw.value="grabar";
   document.form1.action="M0701005.php";
   document.form1.method="post";
   document.form1.submit();
  }
 }//fin si  
}  
function buscarut(){
if (document.form1.cod_interno.value.length > 0){
//  document.form1.cod_interno.style.backgroundColor="#FFFFFF";
  document.form1.hdsw.value="buscar";
  document.form1.action="M0701005.php";
  document.form1.method="post";
  document.form1.submit();
 }
}
function eliminar(){
 if(window.confirm("Seguro desea eliminar?")==true){
  document.form1.hdsw.value="eliminar";
  document.form1.action="M0701005.php";
  document.form1.method="post";
  document.form1.submit();
 }
}//fin eliminar 
</script>
<link rel="stylesheet" href="styles.css">
<style type="text/css">
<!--
.Estilo1 {color: #FF0000}
.Estilo2 {color: #0000FF}
-->
</style>
</HEAD>
<BODY <?php
 if ($sw2=="buscar"){
  echo "onload='javascript:(document.form1.cmblocal.focus())'";
  }
 if ($sw2=="grabar" || $sw2=="eliminar"){
  echo "onload='javascript:(document.form1.cod_interno.focus())'";
  } 
 if ($sw2=="encontrado" ){
  echo "onload='javascript:(document.form1.cmdgra.focus())'";
  }  
  ?>>
<TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" align=center 
border=0>
  <TBODY>
  <TR>
    <TD vAlign=center align=middle height="100%">
      <TABLE height=400 cellSpacing=0 cellPadding=0 width=718 border=0>
        <TBODY>
        <TR>
          <TD width="718" height=22>
            <TABLE height=22 cellSpacing=0 cellPadding=0 width="100%" 
              border=0><TBODY>
              <TR>
                <TD vAlign=top align=left width=24><A 
                  href="index.php"><IMG 
                  height=22 src="images/xc_left.gif" width=24 
                  border=0></A></TD>
                <TD vAlign=top align=left width="100%"><IMG height=22 
                  src="images/xc_center.gif" width="100%" 
                border=0></TD>
              <TD vAlign=top align=right width=24><IMG height=22 
                  src="images/xc_right.gif" width=24 
              border=0></TD></TR></TBODY></TABLE></TD></TR>
        <TR>
          <TD class=BottomTable vAlign=top 
          background=images/xc_stripes.gif height="100%">
            <TABLE class=IconsTable height=33 cellSpacing=0 cellPadding=0 
            width="100%" border=0>
              <TBODY>
              <TR>
                <TD height="32"><div align="right" class="larger">
                  <div align="right">Vemol</div>
                </div></TD>
                </TR></TBODY></TABLE>
            <TABLE cellSpacing=0 cellPadding=0 width="715" 
              border=0>
              <TBODY>
              <TR>
                <TD width=23 height=18>&nbsp;</TD>
                <TD vAlign=top align=left width=180 height=18>&nbsp;</TD>
                <TD width=12 height=18>&nbsp;</TD>
                <TD width="461" height=18 class=MainMenuHead>Existencias:</TD>
                <TD width=20 height=18>&nbsp;</TD></TR>
              <TR>
                <TD width=23 height="100%">&nbsp;</TD>
                <TD vAlign=top align=left width=180 height="100%">
                  <TABLE cellSpacing=0 cellPadding=0 width="150" border=0>
                    <TBODY>
                    <TR>
                      <TD width=10 valign="top"><IMG height=12 
                        src="images/xc_dotgrey.gif" width=10></TD>
                      <TD width=4>&nbsp;</TD>
                      <TD class=LeftMenu noWrap>Ingreso de Existencias:<br />
                        -&gt;Agregar.<br />
-&gt;Modificar.<br />
-&gt;Eliminar.</TD>
                    </TR>
                    <tr>
                      <td valign="top"><img height="12" 
                        src="images/xc_dotgrey.gif" width="10" /></td>
                      <td>&nbsp;</td>
                      <td class="LeftMenu" nowrap="nowrap">Alertas:<span class="Estilo1"><br />
                            <?php echo $error2 ?></span></td>
                    </tr>
                    <tr>
                      <td valign="top"><img 
                        src="images/xc_dotgrey.gif" alt="1" width="10" height="12" /></td>
                      <td>&nbsp;</td>
                      <td class="LeftMenu" nowrap="nowrap">Se recomienda:<span class="Estilo2"><br />
                            <?php echo $recomendacion2 ?></span></td>
                    </tr>
                    </TBODY></TABLE></TD>
                <TD width=12 height="100%">&nbsp;</TD>
                <TD class=contentcell vAlign=top align=middle width=461 
                height="100%">
                  <TABLE width="100%">
                    <TBODY>
                    <TR>
                      <TD>
                        <form name="form1" method="post" action="">
                          <table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr>
                              <th scope="col"><div align="right" class="Emphasize">Codigo Interno:</div></th>
                              <th scope="col"><div align="left">
                                <input name="cod_interno" type="text" id="cod_interno" onblur="buscarut()" value="<?php echo $cod_interno ?>" size="21" maxlength="20" />
                                <input name="hdsw" type="hidden" id="hdsw" value="nada" />
                              </div></th>
                            </tr>
                            <tr>
                              <th scope="row"><div align="right"><span class="Emphasize">Local:</span></div></th>
                              <td><?php
									$sqllocal="select * from m07006 order by 2;";
									$reslocal=mysql_query($sqllocal,$con) ;				
								?>
                                <select name="cmblocal" id="cmblocal" onchange="ponelocal()">
                                  <option value="xxx">Seleccione un Local</option>
                                  <?php 
									while ($filalocal=mysql_fetch_row($reslocal)){			
									 if ($cod_local==$filalocal[0]){
									  echo "<option value=$filalocal[0] selected='selected'>$filalocal[1]</option>";
									  }else{						
									 echo "<option value=$filalocal[0]>$filalocal[1]</option>";								 
									 }//fin si
									}
								?>
                                </select>
                                <input name="hdcod_local" type="hidden" id="hdcod_local" value="<?php echo $cod_local ?>"/></td>
                            </tr>
                            <tr>
                              <th scope="row"><div align="right"><span class="Emphasize">Stock:</span></div></th>
                              <td><input name="stock" type="text" id="stock" value="<?php echo $stock ?>" size="11" maxlength="10"/></td>
                            </tr>
                            <tr>
                              <th scope="row"><label>
                                <div align="right"><span class="Emphasize">Costo Contable</span>:</div>
                                </label>                                </th>
                              <td><input name="costo_contable" type="text" id="costo_contable" value="<?php echo $costo_contable ?>" size="11" maxlength="10" /></td>
                            </tr>
                            <tr>
                              <th scope="row"><label>
                                <div align="right"><span class="Emphasize">Stock Inicial</span>:</div>
                                </label></th>
                              <td><input name="stock_inicial" type="text" id="stock_inicial" value="<?php echo $stock_inicial ?>" size="11" maxlength="10"/></td>
                            </tr>
                            <tr>
                              <th scope="row"><div align="right"><span class="Emphasize">Costo Inicial</span>:</div></th>
                              <td><input name="costo_inicial" type="text" id="costo_inicial" value="<?php echo $costo_inicial ?>" size="11" maxlength="10"/></td>
                            </tr>
                            <tr>
                              <th scope="row"><div align="right"></div></th>
                              <td><label></label></td>
                            </tr>
                            <tr>
                              <th scope="row"><div align="right" class="Emphasize"></div></th>
                              <td><label></label></td>
                            </tr>
                            <tr>
                              <th scope="row">&nbsp;</th>
                              <td>&nbsp;</td>
                            </tr>
                            <tr>
                              <th colspan="2" scope="row"><input name="cmdgra" type="button" id="cmdgra" value="Grabar" onclick="valida()" />
                              <label></label>
                                &nbsp;&nbsp;
                                <label></label>
                                <label></label>                                
                                <label></label>
                                &nbsp;&nbsp;
								<input name="cmdel" type="button" id="cmdel" value="Eliminar" onclick="eliminar()"/>								</th>
                              </tr>
                          </table>
                                </form>						</TD>
                    </TR></TBODY></TABLE></TD>
                <TD width=20 height="100%">&nbsp;</TD></TR>
              <TR>
                <TD width=23 height=8>&nbsp;</TD>
                <TD width=180 height=8>&nbsp;</TD>
                <TD width=12 height=8>&nbsp;</TD>
                <TD width="461" height=8>&nbsp;</TD>
        <TD width=20 
      height=8>&nbsp;</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY>
<!-- /Footer -->
<script language="JavaScript" src="menu.js"></script>
<script language="JavaScript" src="menu_tpl.js"></script>
<script language="JavaScript">
	new menu (MENU_ITEMS, MENU_POS);
</script>
</TABLE>
</BODY><?php
	mysql_close($con);
?>
</HTML>