public function consultarPrecios($almacen, $entidad, $basedatos)
{
?>
<?php
$articulo = $_POST['nomArticulo'];
?>
<?php
if ($_GET['codigo'] and $_GET['inactiva']) {
if ($_GET['inactiva'] == "inactiva") {
$q = "UPDATE articulos set \r\n\r\n\t\tactivo='I'\r\n\t\tWHERE entidad='" . $entidad . "' AND\r\n\t\talmacen='" . $_GET['codigo'] . "'";
mysql_db_query($basedatos, $q);
echo mysql_error();
} else {
$q = "UPDATE articulos set \r\n\r\n\t\tactivo='A'\r\n\t\tWHERE entidad='" . $entidad . "' AND\r\n\t\tcodigo='" . $_GET['codigo'] . "'";
mysql_db_query($basedatos, $q);
echo mysql_error();
}
}
?>
<script language=javascript>
function ventanaSecundaria (URL){
window.open(URL,"ventana","width=350,height=189,scrollbars=YES")
}
</script>
<script language=javascript>
function ventanaSecundaria2 (URL){
window.open(URL,"ventana2","width=350,height=170,scrollbars=YES")
}
</script>
<script type="text/javascript" src="<?php
echo CONSTANT_PATH_SIMA_RAIZ;
?>
/js/wz_tooltip.js"></script>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title></title>
<?php
$estilos = new muestraEstilos();
$estilos->styles();
?>
</head>
<body>
<div class="page_right">
<h1 align="center">Médicos Precios x Departamento </h1>
<form id="form2" name="form2" method="post" action="">
<div align="center">
<table width="600" class="table-template-left">
<!--<table width="600" class="table-forma">-->
<?php
if (verificaCargoTotal::verificaCT($seguro, $basedatos)) {
?>
<?php
}
?>
<tr >
<td scope="col"> </td>
<td scope="col"><div align="left" >Todos</div></td>
<td scope="col"><div align="left">
<input name="todos" type="checkbox" id="todos" value="si" <?php
if ($_POST['todos'] == 'si') {
echo 'checked=""';
}
?>
/>
</div></td>
<td scope="col"><input name="Submit" type="submit" value="Mostrar" /></td>
</tr>
<tr >
<td width="31" scope="col"><label></label></td>
<td width="103" scope="col"><div align="left">Departamento</div></td>
<td width="347" scope="col"><div align="left">
<?php
require CONSTANT_PATH_CONFIGURACION . "/componentes/comboAlmacen.php";
$comboAlmacen = new comboAlmacen();
$comboAlmacen->despliegaAlmacen($entidad, 'style7', $almacenSolicitante, $almacenDestino, $basedatos);
?>
</div></td>
<td width="104" scope="col"> </td>
</tr>
</table>
<label></label>
</div>
<p> </p>
</form>
<p align="center" class="style14">
<?php
if ($_POST['almacenDestino']) {
$articulo = '*';
if ($articulo === '*' and !$_POST['todos']) {
$sSQL = "\r\nselect articulosPrecioNivel.codigo,articulosPrecioNivel.keyAPN,almacenes.almacenPadre,almacenes.almacen,almacenes.descripcion, articulosPrecioNivel.nivel1,articulosPrecioNivel.nivel3 \r\nfrom almacenes,articulosPrecioNivel where almacenes.medico='si'\r\nand\r\nalmacenes.almacen=articulosPrecioNivel.almacen\r\nand\r\nalmacenes.almacenPadre='" . $_POST['almacenDestino'] . "' \r\ngroup by almacenes.descripcion ASC\r\n";
} else {
$sSQL = " select * from almacenes\r\nwhere\r\nalmacenPadre='" . $_POST['almacenDestino'] . "' \r\nand\r\nmedico='si'\r\n";
}
if ($result = mysql_db_query($basedatos, $sSQL)) {
echo mysql_error();
?>
</p>
<form id="form1" name="form1" method="post" action="modificaA.php">
<p align="center"> </p>
<table width="600" class="table table-striped">
<tr>
<th width="69" scope="col"><div align="left"><span >Código</span></div></th>
<th width="321" scope="col"><div align="left"><span >Mini Almacén (Médico)</span></div></th>
<th width="74" scope="col"><div align="left"><span >Part.</span></div></th>
<th width="68" scope="col"><div align="left"><span >Aseg.</span></div></th>
<th width="41" scope="col"><div align="left"><span >Editar</span></div></th>
</tr>
<tr>
<?php
while ($myrow = mysql_fetch_array($result)) {
$totalRegistros += 1;
$sSQL5 = "SELECT *\r\nFROM\r\n `precioArticulos`\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' \r\n ";
$result5 = mysql_db_query($basedatos, $sSQL5);
$myrow5 = mysql_fetch_array($result5);
$sSQL52 = "SELECT count(*) as totalRegedit\r\nFROM\r\nexistencias\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' \r\n ";
$result52 = mysql_db_query($basedatos, $sSQL52);
$myrow52 = mysql_fetch_array($result52);
$i = $myrow52['totalRegedit'];
$sSQL51 = "SELECT *\r\nFROM\r\nexistencias\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' \r\n ";
$result51 = mysql_db_query($basedatos, $sSQL51);
$myrow51 = mysql_fetch_array($result51);
$bali = $myrow51['almacen'];
$sSQL6 = "SELECT *\r\nFROM\r\narticulosPrecioNivel\r\nWHERE entidad='" . $entidad . "' \r\nAND\r\nalmacen='" . $myrow['almacen'] . "'\r\n\r\n ";
$result6 = mysql_db_query($basedatos, $sSQL6);
$myrow6 = mysql_fetch_array($result6);
$C = $codigo = $code = $myrow6['codigo'];
if ($col) {
$color = '#FFFF99';
$col = "";
} else {
$color = '#FFFFFF';
$col = 1;
}
$Cd = $myrow['almacen'];
$sSQL7 = "SELECT *\r\nFROM\r\narticulos\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' \r\n ";
$result7 = mysql_db_query($basedatos, $sSQL7);
$myrow7 = mysql_fetch_array($result7);
?>
<td bgcolor="<?php
echo $color;
?>
" height="24" ><span >
<label><?php
echo $Cd;
?>
</label>
</span></td>
<td bgcolor="<?php
echo $color;
?>
" ><span ><?php
echo $myrow['descripcion'];
?>
<?php
if (!$bali) {
echo '<img src="' . CONSTANT_PATH_SIMA_RAIZ . '/imagenes/stop.png" alt="NO TIENE ASIGNADO NINGUN PRECIO O ALMACEN" width="13" height="13" border="0" />';
}
?>
<?php
if ($myrow['generico'] == 'si') {
?>
<blink>
<img src="../imagenes/g.jpg" alt="MEDICAMENTO GENERICO..." width="12" height="12" border="0" /> </blink>
<?php
} else {
echo '';
}
?>
</span></td>
<td bgcolor="<?php
echo $color;
?>
" >
<?php
if ($myrow6['nivel1']) {
echo "\$" . number_format($myrow6['nivel1'], 2);
} else {
echo '...';
}
?>
</td>
<td bgcolor="<?php
echo $color;
?>
" ><span >
<?php
if ($myrow6['nivel3']) {
echo "\$" . number_format($myrow6['nivel3'], 2);
} else {
echo '...';
}
?>
</span></td>
<td bgcolor="<?php
echo $color;
?>
" >
<a
onmouseover="Tip('<div class="estilo25"><?php
echo '' . $myrow['descripcion'];
?>
</div>')" onMouseOut="UnTip()"
href="javascript:ventanaSecundaria2('../ventanas/cambiarMedicos.php?nRequisicion=<?php
echo $requisicion;
?>
&almacenPadre=
<?php
echo $myrow['almacenPadre'];
?>
&keyAPN=<?php
echo $myrow['keyAPN'];
?>
&codigo=<?php
echo $C;
?>
&almacen=<?php
echo $Cd;
?>
&keyPA=<?php
echo $myrow['keyPA'];
?>
')">
<img src="../imagenes/Save.png" alt="Modificar Precios" width="12" height="12" border="0" />
</a></td>
<?php
if ($UM == 's' or $UM == 'S') {
$modifica = 'modificaP.php';
} else {
$modifica = 'modificaA.php';
}
?>
</tr>
<?php
}
}
?>
</table>
<p align="center">
<label></label>
<input name="bandera" type="hidden" id="bandera" value="<?php
echo $totalRegistros;
?>
" />
</p>
</form>
<?php
if ($totalRegistros) {
?>
<p align="center"><strong><em>Se encontraron <?php
echo $totalRegistros;
?>
registros</em></strong></p>
<?php
}
}
?>
<p> </p>
</div>
</body>
</html>
<?php
}
public function consultarArticulosxAlmacen($almacen, $entidad, $basedatos)
{
?>
<?php
$articulo = $_POST['nomArticulo'];
?>
<?php
if ($_GET['codigo'] and ($_GET['inactiva'] or $_GET['activa'])) {
if ($_GET['inactiva'] == "inactiva") {
$q = "UPDATE articulos set \r\n\r\n\t\tactivo='I'\r\n\t\tWHERE keyPA='" . $_GET['keyPA'] . "'";
mysql_db_query($basedatos, $q);
echo mysql_error();
} else {
$q = "UPDATE articulos set \r\n\r\n\t\tactivo='A'\r\n\t\tWHERE keyPA='" . $_GET['keyPA'] . "'";
mysql_db_query($basedatos, $q);
echo mysql_error();
}
}
if (!$_POST['nomArticulo']) {
$_POST['nomArticulo'] = $_GET['nomArticulo'];
}
if (!$_POST['almacenDestino']) {
$_POST['almacenDestino'] = $_GET['almacenDestino'];
}
if (!$_POST['almacenDestino1']) {
$_POST['almacenDestino1'] = $_GET['almacenDestino1'];
}
?>
<script language=javascript>
function ventanaSecundaria (URL){
window.open(URL,"ventana","width=350,height=189,scrollbars=YES")
}
</script>
<script language=javascript>
function ventanaSecundaria2 (URL){
window.open(URL,"ventana2","width=660,height=800,scrollbars=YES")
}
</script>
<script language=javascript>
function ventanaSecundaria20 (URL){
window.open(URL,"ventana20","width=350,height=170,scrollbars=YES")
}
</script>
<script language=javascript>
function ventanaSecundaria9 (URL){
window.open(URL,"ventanaSecundaria9","width=900,height=600,scrollbars=YES,resizable=YES, maximizable=YES")
}
</script>
<SCRIPT LANGUAGE="JavaScript">
function checkIt(evt) {
evt = (evt) ? evt : window.event
var charCode = (evt.which) ? evt.which : evt.keyCode
if (charCode > 31 && (charCode < 48 || charCode > 57)) {
status = "Este campo s�lo acepta n�meros."
return false
}
status = ""
return true
}
</SCRIPT>
<script type="text/javascript" src="<?php
echo CONSTANT_PATH_SIMA_RAIZ;
?>
/js/wz_tooltip.js"></script>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<?php
$estilos = new muestraEstilos();
$estilos->styles();
?>
</head>
<body>
<div class="page_right">
<h1 align="center" >Artículos/Servicios x Almacén </h1>
<form id="form2" name="form2" method="post" action="">
<!--<table width="399" class="table-forma">-->
<table width="399" class="table-template-left">
<?php
if (verificaCargoTotal::verificaCT($seguro, $basedatos)) {
?>
<?php
}
?>
<tr >
<td width="88" scope="col"><div align="left">Departamento</div></td>
<td width="301" scope="col"> <div align="left" >
<?php
require CONSTANT_PATH_CONFIGURACION . "/componentes/comboAlmacen.php";
$comboAlmacen = new comboAlmacen();
$comboAlmacen->despliegaAlmacen($entidad, 'combos', $almacenSolicitante, $almacenDestino, $basedatos);
?>
</div></td>
</tr>
<tr >
<td scope="col"><div align="left">Mini Almacén </div></td>
<td scope="col"> <div align="left" >
<?php
$comboAlmacen1 = new comboAlmacen();
if (!$almacenDestino) {
$almacenDestino = $almacenSolicitante;
}
$comboAlmacen1->despliegaMiniAlmacen($entidad, 'combos', $_POST['almacenDestino'], $almacenDestino, $basedatos);
?>
</div></td>
</tr>
</table>
<p> </p>
<!--<table width="532" class="table-forma">-->
<table width="532" class="table-template-left">
<tr>
<td height="22" scope="col"><div align="left">Título</div></td>
<td scope="col"><label>
<div align="left">
<textarea name="titulo" cols="60" wrap="virtual" id="titulo"><?php
echo $_POST['titulo'];
?>
</textarea>
</div>
</label></td>
</tr>
<tr>
<td height="22" scope="col"><div align="left">Incluir Referidos </div></td>
<td scope="col"><div align="left">
<label>
<input name="referidos" type="checkbox" id="referidos" value="si" <?php
if ($_POST['referidos']) {
echo 'checked=""';
}
?>
/>
</label>
</div></td>
</tr>
<tr>
<td height="22" align="left" scope="col">Precio</td>
<td scope="col"><div align="left">
<label>
<input type="radio" name="radio" id="asegura" value="asegura" />
</label>
Aseguradora
<label>
<input type="radio" name="radio" id="part" value="part" />
Particular</label>
<label>
<input type="radio" name="radio" id="ambos" value="ambos" />
Ambos Precios</label>
</div></td>
</tr>
<tr>
<td height="22" scope="col"><div align="left">Porcentaje % </div></td>
<td scope="col"><div align="left">
<label>
<input name="porcentaje" type="text" id="porcentaje" size="2" maxlength="2" value="<?php
echo $_POST['porcentaje'];
?>
" onkeypress="return checkIt(event)"/>
</label>
</div></td>
</tr>
<tr>
<td width="88" height="22" scope="col"> </td>
<td width="322" scope="col"><span >
</span>
<div align="left" >
<input name="buscar" type="submit" src="<?php
echo CONSTANT_PATH_SIMA_RAIZ;
?>
/imagenes/btns/searcharticles.png" id="buscar" value="buscar" />
</div> </td>
</tr>
</table>
</form>
<p align="center" >
<?php
if ($_POST['referidos'] == 'si') {
$sSQL = "\r\nSELECT \r\narticulos.codigo,articulos.keyPA,articulos.descripcion \r\nFROM articulos,existencias\r\nwhere \r\n\r\narticulos.entidad='" . $entidad . "' AND\r\narticulos.codigo=existencias.codigo\r\nand\r\nexistencias.almacen='" . $_POST['almacenDestino1'] . "'\r\n AND\r\n articulos.activo='A'\r\norder by articulos.descripcion ASC\r\n";
} else {
$sSQL = "\r\nSELECT \r\narticulos.codigo,articulos.keyPA,articulos.descripcion \r\nFROM articulos,existencias\r\nwhere \r\n\r\narticulos.entidad='" . $entidad . "' AND\r\narticulos.codigo=existencias.codigo\r\nand\r\n(articulos.laboratorioReferido='no' or articulos.laboratorioReferido='' )\r\nand\r\nexistencias.almacen='" . $_POST['almacenDestino1'] . "'\r\n AND\r\n articulos.activo='A'\r\norder by articulos.descripcion ASC\r\n";
}
if ($result = mysql_db_query($basedatos, $sSQL)) {
echo mysql_error();
?>
<br />
Listado de Servicios de: <?php
$sSQL6a = "SELECT descripcion\r\nFROM\r\n almacenes\r\nWHERE entidad='" . $entidad . "' AND\r\nalmacen='" . $_POST['almacenDestino1'] . "'\r\n ";
$result6a = mysql_db_query($basedatos, $sSQL6a);
$myrow6a = mysql_fetch_array($result6a);
echo $myrow6a['codigo'];
?>
</p>
<form id="form1" name="form1" method="post" action="">
<p> </p>
<!--<table width="500" class="table table-striped">-->
<table width="500" class="table-template-left">
<tr >
<th width="2" scope="col"><div align="left" >#</div></th>
<th width="539" scope="col"><div align="left" >Descripción</div></th>
<th width="62" scope="col"><div align="left" >Part</div></th>
<th width="59" scope="col"><div align="left" >Aseg</div></th>
</tr>
<tr >
<?php
while ($myrow = mysql_fetch_array($result)) {
$keyPA = $myrow['keyPA'];
$totalRegistros += 1;
$codigo = $code = $myrow['codigo'];
$sSQL52 = "SELECT count(*) as totalRegedit\r\nFROM\r\nexistencias\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' \r\n ";
$result52 = mysql_db_query($basedatos, $sSQL52);
$myrow52 = mysql_fetch_array($result52);
$i = $myrow52['totalRegedit'];
$sSQL5 = "SELECT *\r\nFROM\r\n `precioArticulos`\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' \r\n ";
$result5 = mysql_db_query($basedatos, $sSQL5);
$myrow5 = mysql_fetch_array($result5);
$sSQL51 = "SELECT *\r\nFROM\r\nexistencias\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' \r\n ";
$result51 = mysql_db_query($basedatos, $sSQL51);
$myrow51 = mysql_fetch_array($result51);
$bali = $myrow51['almacen'];
$sSQL6 = "SELECT *\r\nFROM\r\n `articulosPrecioNivel`\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' and\r\nalmacen='" . $_POST['almacenDestino1'] . "'\r\n ";
$result6 = mysql_db_query($basedatos, $sSQL6);
$myrow6 = mysql_fetch_array($result6);
if ($col) {
$color = '#FFFF99';
$col = "";
} else {
$color = '#FFFFFF';
$col = 1;
}
$C = $myrow['codigo'];
$sSQL7 = "SELECT activo\r\nFROM\r\narticulos\r\nWHERE entidad='" . $entidad . "' AND\r\ncodigo = '" . $code . "' \r\n ";
$result7 = mysql_db_query($basedatos, $sSQL7);
$myrow7 = mysql_fetch_array($result7);
$gpoProducto = $myrow['gpoProducto'];
$sSQL39 = "\r\n\tSELECT \r\nprefijo\r\nFROM\r\ngpoProductos\r\nWHERE codigoGP='" . $gpoProducto . "'";
$result39 = mysql_db_query($basedatos, $sSQL39);
$myrow39 = mysql_fetch_array($result39);
?>
<td height="24" ><span >
<label><?php
echo $totalRegistros;
?>
</label>
</span></td>
<td ><?php
echo $myrow['descripcion'];
?>
<?php
if (!$bali) {
echo '<img src="' . CONSTANT_PATH_SIMA_RAIZ . '/imagenes/stop.png" alt="NO TIENE ASIGNADO NINGUN PRECIO O ALMACEN" width="13" height="13" border="0" />';
}
?>
<?php
if ($myrow['generico'] == 'si') {
?>
<blink> <img src="<?php
echo CONSTANT_PATH_SIMA_RAIZ;
?>
/imagenes/g.jpg" alt="MEDICAMENTO GENERICO..." width="12" height="12" border="0" /></blink>
<?php
} else {
echo '';
}
?>
</td>
<td align="right" ><?php
if ($myrow6['nivel1']) {
echo "\$" . number_format($myrow6['nivel1'], 2);
} else {
echo '...';
}
?>
</td>
<td align="right" ><?php
if ($myrow6['nivel3']) {
echo "\$" . number_format($myrow6['nivel3'], 2);
} else {
echo '...';
}
?>
</td>
<?php
if ($UM == 's' or $UM == 'S') {
$modifica = 'modificaP.php';
} else {
$modifica = 'modificaA.php';
}
?>
</tr>
<?php
}
}
?>
</table>
<p align="center">
<label></label>
<input name="bandera" type="hidden" id="bandera" value="<?php
echo $totalRegistros;
?>
" />
<?php
if ($totalRegistros >= 1) {
?>
<a href="javascript:ventanaSecundaria9('imprimirPrecios.php?nRequisicion=<?php
echo $requisicion;
?>
&almacen=
<?php
echo $_POST['almacenDestino1'];
?>
&medico=<?php
echo $_GET['medico'];
?>
&codigo=<?php
echo $C;
?>
&almacenes=<?php
echo $Cd;
?>
&porcentaje=<?php
echo $_POST['porcentaje'];
?>
&referidos=<?php
echo $_POST['referidos'];
?>
&titulo=<?php
echo $_POST['titulo'];
?>
')"><br><img src="../imagenes/btns/printbutton.png" border="0" width="18" height="18"/></a>
<?php
}
?>
</p>
<input name="warehouse" type="hidden" value="<?php
echo $_GET['warehouse'];
?>
">
<input name="main" type="hidden" value="<?php
echo $_GET['main'];
?>
">
</form>
<?php
if ($totalRegistros) {
?>
<p align="center" ><strong><em>Se encontraron <?php
echo $totalRegistros;
?>
registros</em></strong></p>
<?php
}
?>
<p> </p>
</div>
</body>
</html>
<?php
}
