Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Devolucion de rutas</title>
- </head>
- <?php
- $user = "";
- $password = "";
- $server = "servidorcio";
- $BD = "SQLPRUEBA";
- $connection_string = "DRIVER={SQL Server};SERVER=$server;DATABASE=$BD";
- $conn = odbc_connect($connection_string,$user,$password);
- //if ($conn) {echo "Conexion odbc establecida"; } else {die("No se pudo establecer la conexion."); }
- ?>
- <style>
- p {
- border: 1px solid darkblue;
- padding: 1px;
- }
- body {background-color:lightgrey;}
- h1 {color:blue; text-align: left;font-size: 20px; }
- p {color:darkblue;}
- .boton{ border: 1px solid #DBE1EB;
- font-size: 18px;
- font-family: Arial, Verdana;
- padding-left: 7px;
- padding-right: 7px;
- padding-top: 5px;
- padding-bottom: 5px;
- border-radius: 10px;
- -moz-border-radius: 10px;
- -webkit-border-radius: 10px;
- -o-border-radius: 10px;
- background: #4972B5;
- background: linear-gradient(left, #4972B5, #618ACB);
- background: -moz-linear-gradient(left, #4972B5, #618ACB);
- background: -webkit-linear-gradient(left, #4972B5, #618ACB);
- background: -o-linear-gradient(left, #4972B5, #618ACB);
- color: #FFFFFF;
- }
- </style>
- <body>
- <table width="1000" border="6" >
- <tr>
- <td>
- <form id="form8" name="form8" method="post" action="">
- <h1>Fecha de Liquidacion:<input type="text" size="10" name="txtfecha" id="txtfecha" value="<?php echo date("d/m/Y"); ?>" />
- <input type="submit" name="VisRutas" id="IdVisRutas" value="Mostrar" class="boton" /> </h1>
- </form>
- </td>
- </tr>
- <td>
- <form id="form9" name="form9" method="post" action="">
- <?php
- if(isset($_POST['VisRutas'])) {
- $Fec_Liq=$_POST["txtfecha"];
- $sql= odbc_exec($conn,"select Str(IdLiquidacion)+' '+IdSector+' '+Nombre+' '+Apell_Materno+' '+Apell_Paterno AS liquidacion
- from cab_liquidacion a inner join cat_personal b on b.idpersonal=a.idvendedor
- where fec_liquidacion= '$Fec_Liq' order by idsector");
- echo '<form action="" method="post">';
- echo 'Seleccione Ruta -->';
- echo '<select name="cborutas" method="post" id="liquidacion" style="width:35%" onchange="">';
- echo '<option value="0">Seleccione Ruta</option>';
- if ($row=odbc_fetch_array($sql)) {
- do { echo '<option value= "'.$row["liquidacion"].'"> '.$row["liquidacion"].'</option>'; }
- while ($row=odbc_fetch_array($sql));
- }
- echo '</select>';
- echo '<input type="submit" name="VisProductos" id="IdVisualiza" value="Mostrar_Productos" class="boton" />';
- echo '</form>';
- }
- ?>
- </form>
- </td>
- </tr>
- <tr>
- <td><table width="1000">
- <tr>
- <?php
- if(isset($_POST['VisProductos'])) {
- echo " <th width='339' scope='col'><p>$_POST[cborutas]</p></th>
- <th width='262' scope='col'><p>Kilometraje --><input type='text' name='txtKilom' id='txtKilom' /> </p></th> ";
- }
- ?>
- </tr>
- </td>
- </table>
- <form id="form4" name="form4" method="post" action="">
- <table width="1000" class="TblDetPro" id="TblDetPro">
- <tr>
- <th scope="col"><p>TIPO</p> </th>
- <th scope="col"><p>#PROD</p></th>
- <th scope="col"><p>PRODUCTO</p></th>
- <th scope="col"><p>CANT</p></th>
- <th scope="col"><p>PCIO</p></th>
- <th scope="col"><p>D.VAC</p></th>
- <th scope="col"><p>D.LLE</p></th>
- <th scope="col"><p>RACK DEV</p></th>
- <th scope="col"><p>SG.CGA</p></th>
- <th scope="col"><p>RACK S.DIA</p></th>
- </tr>
- <?php
- if(isset($_POST['VisProductos'])) {
- $numliq = intval(substr($_POST["cborutas"],1,10));
- $sql= odbc_exec($conn,"select Case When Idtipocarga=1 Then 'Carga' Else 'Recarga' End As TipCga, A.IdProducto,Des_producto,
- cantidad,A.precio,dev_vacio,dev_lleno,rackd From Det_CargasdeRuta A
- Inner join Cat_Productos b on b.IdProducto=A.IdProducto
- where IdLiquidacion= $numliq ");
- while ($row = odbc_fetch_array($sql)) {
- echo " <tr>
- <td>$row[TipCga]</td>
- <td>$row[IdProducto]</td>
- <td>$row[Des_producto]</td>
- <td align=right>$row[cantidad]</td>
- <td align=right>$row[precio]</td>
- <td align=right><input type='text' id='coldv' size='4' maxlength='5' value=$row[dev_vacio] ></td>
- <td align=right><input type='text' id='colll' size='4' maxlength='5' value=$row[dev_lleno] ></td>
- <td><input type='text' id='colra' size='15' maxlength='15' value=$row[rackd] ></td>
- <td><input type='text' id='colsd' size='4' maxlength='5' value='0' ></td>
- <td><input type='text' id='colrsd' size='15' maxlength='15'value='' ></td>
- </tr>";
- }
- }
- ?>
- </table>
- <input type="submit" name="BtnGuardar" id="BtnGuardar" value="Guardar" class="boton" onclick="actualizabd();" />
- </form>
- </tr>
- <br><br>
- <?php $sql= odbc_exec($conn,"Select Str(IdProducto)+' '+Des_Producto As Productos From Cat_Productos Order By Des_producto "); ?>
- <form action="" method="post">
- <td><table width="1000" >
- <tr><td> <input type="text" style="visibility:hidden" name="txtliq" id="txtliq" size="1" maxlength="10" readonly="true" value="
- <?php if(isset($_POST['VisProductos'])) { echo substr($_POST["cborutas"],1,10);}?>" />
- </td></tr>
- <tr>
- <th scope="col"><p>TipCga</p></th>
- <th scope="col"><p>Producto</p></th>
- <th scope="col"><p>Cant.</p></th>
- <th scope="col"><p>Racks</p></th>
- <th scope="col"></th>
- </tr>
- <tr>
- <td>
- <select name="cbotipcga" id="cbotipcga">
- <option>Carga</option>
- <option>Recarga</option>
- </select>
- </td>
- <td>
- <select name="cboprod" id="cboprod">
- <?php
- if ($row=odbc_fetch_array($sql)) {
- do { echo '<option value= "'.$row["Productos"].'"> '.$row["Productos"].'</option>'; }
- while ($row=odbc_fetch_array($sql));
- }
- ?>
- </select>
- </td>
- <td> <input type="text" name="txtCant" id="txtCant" onKeyPress="if (event.keyCode < 48 || event.keyCode > 57)event.returnValue = false;" size="5" maxlength="5"/> </td>
- <td> <input type="text" name="TxtRack" id="TxtRack" size="35" maxlength="35"/> </td>
- <td><form id="form2" name="form2" method="post" action="">
- <input type="submit" name="BtnInsertar" id="BtnInsertar" value="Insertar" class="boton1" />
- </form></td>
- </tr>
- </table></td>
- </form>
- </table>
- </body>
- <?php
- if(isset($_POST['BtnInsertar'])) {
- if ($_POST['cbotipcga']=="Carga") {$nTipCga=1;};
- if ($_POST['cbotipcga']=="Recarga") {$nTipCga=2;};
- $nIdPr=intval(substr($_POST["cboprod"],1,10));
- $sqlprod= odbc_exec($conn,"Select precio From Cat_Productos Where IdProducto= $nIdPr");
- if ($row=odbc_fetch_array($sqlprod)) {$Precio=$row["precio"] ;}
- $numliq= $_POST['txtliq'];
- $nCant=$_POST['txtCant'];
- $cRack=$_POST['TxtRack'];
- If (strlen($nCant)>0 and strlen($cRack)>1 And $numliq>0) {
- $sql = odbc_exec($conn, "INSERT INTO Det_CargasdeRuta (Idfilial, IdCedis, IdLiquidacion,IdTipoCarga,IdProducto,Cantidad,Precio,Dev_Vacio,Dev_Lleno,RackD,RackC,IdArticulo) VALUES(1, 2, $numliq,$nTipCga,$nIdPr,$nCant,$Precio,0,0,'.',$cRack,0)");
- }
- IF (strlen($nCant)<=0 OR strlen($cRack)<=1){
- echo '<script language="javascript">alert("Datos incompletos, no se guardara");</script>'; }
- }
- ?>
- </html>
- <script>
- function actualizabd() {
- var cCelda,textos = '';
- nNumLiq=document.getElementById('txtliq').value;
- for (var i=1;i<document.getElementById('TblDetPro').rows.length;i++) {
- cCelda=document.getElementById('TblDetPro').rows[i].cells[0].innerHTML
- if (cCelda=='Carga') {nIdTipC=1}
- if (cCelda=='Recarga') {nIdTipC=2}
- nIdProd=document.getElementById('TblDetPro').rows[i].cells[1].innerHTML
- nCanti=document.getElementById('TblDetPro').rows[i].cells[3].innerHTML
- nPcio=document.getElementById('TblDetPro').rows[i].cells[4].innerHTML
- nDevVac=document.getElementById('TblDetPro').rows[i].cells[5].children[0].value
- nDevLle=document.getElementById('TblDetPro').rows[i].cells[6].children[0].value
- nRacDev=document.getElementById('TblDetPro').rows[i].cells[7].children[0].value
- actualizaDato(nDevVac,nDevLle,nRacDev,nNumLiq,nIdProd,nIdTipC,nCanti,nPcio)
- }
- alert('Actualizacion completada');
- }
- function objetoAjax(){
- var xmlhttp=false;
- try {
- xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
- } catch (e) {
- try {
- xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
- } catch (E) {
- xmlhttp = false;
- }
- }
- if (!xmlhttp && typeof XMLHttpRequest!='undefined') {
- xmlhttp = new XMLHttpRequest();
- }
- return xmlhttp;
- }
- function actualizaDato(nDevVac,nDevLle,nRacDev,nNumLiq,nIdProd,nIdTipC,nCanti,nPcio) {
- divResultado = document.getElementById('resultado');
- ajax=objetoAjax();
- ajax.open("POST", "rec.php");
- ajax.onreadystatechange=function() {
- if (ajax.readyState==4) {
- //mostrar resultados en esta capa
- divResultado.innerHTML = ajax.responseText
- }
- }
- ajax.setRequestHeader("Content-Type","application/x-www-form-urlencoded")
- ajax.send("&nDevVac="+nDevVac+"&nDevLle="+nDevLle+"&nRacDev="+nRacDev+"&nNumLiq="+nNumLiq+"&nIdProd="+nIdProd+"&nIdTipC="+nIdTipC+"&nCanti="+nCanti+"&nPcio="+nPcio)
- alert(nIdProd);
- }
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement