<td><b>First Name<br>
<input type="text" name="sfn" onkeyup="this.value=this.value.toUpperCase();" size="15" value="<?php
echo $sh[SHIPPING_NAME];
?>
">
</b></td>
<td><b>Last Name<br>
<input type="text" name="sln" onkeyup="this.value=this.value.toUpperCase();" size="15" value="<?php
echo $sh[SHIPPING_LAST_NAME];
?>
">
</b></td>
<td><b>Country <br>
<select name="scountry" onchange="CargarSTATES(this.options[this.selectedIndex].value,document.ca.sstate);">
<option value=""></option>
<? SelecTable($db,"COUNTRIES","ID_COUNTRY","COUNTRY","",$sh[SHIPPING_ID_COUNTRY]) ?>
</select>
</b></td>
<td><b>State <br>
<select name="sstate">
<option value="0"></option>
</select>
</b></td>
</tr>
<tr>
<td><b>Address <br>
<input type="text" name="sad" size="25" onkeyup="this.value=this.value.toUpperCase();" value="<?php
echo $sh[SHIPPING_ADDRESS];
?>
">
</b></td>
<td><input name="ddate2" type="text" id="ddate2" value="<?php
echo $ddate2;
?>
" size="10" readonly="true" /></td>
<td><A href="javascript:show_calendar('form2.ddate2');"><IMG
src="../images/calendario.gif"
align=center border=0></A> </td>
<td><input name="sdate2" type="text" id="sdate2" value="<?echo $sdate2; ?>" size="10" /></td>
<td><A href="javascript:show_calendar('form2.sdate2');"><IMG
src="../images/calendario.gif"
align=center border=0></A> </td>
<td>Status</td>
<td><select name="status" id="status">
<option value="">Select Status</option>
<?php
SelecTable($database, 'ORDERS_STATUS', 'ID_ORDER_STATUS', "ORDER_STATUS", "", "{$status}");
?>
</select></td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td>
<form id="form1" name="form1" method="post" action="<? echo $PHP_SELF."?status=$status"; ?>">
<table border="0" align="center" cellpadding="1" cellspacing="0" class="table">
<?php
if ($totalRows) {
?>
<tr>
<td colspan="5"><div align="center"><a href="../reports.php">Go Back to Main Menu</a></div></td>
<select name="pt" onchange="this.form.submit()">
<option value="">ALL PRODUCT </option>
<? SelecTable($db,'TIPO_PRODUCTOS','ID_TIPO_PRODUCTO','TIPO_PRODUCTO',"",$pt) ?>
</select>
<select name="st" onchange="this.form.submit()">
<option value="">ALL SUB TYPES </option>
<? SelecTable($db,'SUB_TIPO_PRODUCTOS','ID_SUB_TIPO_PRODUCTO','SUB_TIPO_PRODUCTO'," WHERE ID_TIPO_PRODUCTO=$pt ",$st) ?>
</select>
<select name="sz" onchange="this.form.submit()">
<option value="">ALL SIZES </option>
<? SelecTable($db,'SIZES','ID_SIZE','SIZE_LONG_DESC',"",$sz) ?>
</select>
<select name="sx" onchange="this.form.submit()">
<option value="">ALL STATUS</option>
<option value="2" <? if ($sx==2) { echo " selected";} ?>>Enable</option>
<option value="1" <? if ($sx==1) { echo " selected";} ?>>Disable</option>
</select>
<select name="public" onchange="this.form.submit()">
<option value="" SELECTED>ALL MARKETS</option>
<option value="1" <? if ($public=="1") { echo " selected";} ?>>Public</option>
<option value="0" <? if ($public=="0") { echo " selected";} ?>>No Public</option>
</td>
<td>Card Number</td>
<td> <nobr>
<input type="text" name="ccn" value="<?echo $credit_card_number?>">
CVN: <input type="text" name="cvn" value="<?echo $cvn?>" size=4>
</td>
</tr>
<tr>
<td>Credit Card Type</td>
<td>
<select name="cct">
<?
SelecTable($database,'CREDIT_CARD_TYPES','ID_CREDIT_CARD_TYPE','CREDIT_CARD_TYPE',"", $fila_factura["ID_CREDIT_CARD_TYPE"]);
?>
</select>
</td>
<td>Expiry Date</td>
<td>
<A href="javascript:show_calendar('x.cce');">
<IMG src="../images/calendario.gif" align=center border=0></A>
<input type="text" name="cce" value="<?echo $credit_card_expiry?>">
</td>
</tr>
<tr>
<td colspan=4 align=center> Comments: <br>
<textarea cols=85 rows=3 name=ccc><?echo $comments?></textarea>
}
}
</script>
<form method=POST name=px onsubmit="return Validar()">
<table border="0" cellpadding=3 cellspacing=1>
<tr>
<td colspan="3"> Product Description<br>
<input type="text" name="desc" size="80">
</td>
</tr>
<tr>
<td> Size<br>
<select name="size">
<option value=""></option>
<? SelecTable($database,'SIZES','SIZE',"SIZE","",$size) ?>
</select>
</td>
<td> Price<br>
<input type="text" name="price" size="4">
</td>
<td> Qty Ordered<br>
<input type="text" name="qty" size="4" maxlength="3">
</td>
</tr>
<tr>
<td colspan="2"> Delivery<br>
<select name="dd">
<option value="">Select an Arrival Date</option>
<?
<b><?echo $dt["PRICE_BUNCH"]?>
<input type=hidden name=id[] value="<?echo $dt["ID_PRODUCTO"]?>">
</td>
<td align=right><font color=brown><b>$<?echo number_format($dt["BUNCHES_BOX"]*$dt["PRICE_BUNCH"],2,".",",")?></td>
</tr>
<? } ?>
</table>
<p>
<form method="post" action="./activate_market.php?source=<?php
echo $PHP_SELF;
?>
">
<select name="market">
<? SelecTable($db,'MARKETS','ID_MARKET','MARKET',"","") ?>
</select>
<input name="producto" type="hidden" value="<?echo $id?>">
<input type="submit" value="Add Market">
</form>
</center>
<br>
<? }
include('../end_admin.php');
if ($sz) { $ssz = " AND P.ID_SIZE=$sz"; }
if ($sx) { $ssx = " AND P.ID_PRODUCT_STATUS=($sx-1)"; }
$qry = "SELECT P.*,S.SIZE,TP.TIPO_PRODUCTO,ST.SUB_TIPO_PRODUCTO,M.MARKET FROM PRODUCTOS P, SIZES S,
TIPO_PRODUCTOS TP, SUB_TIPO_PRODUCTOS ST, MARKETS M WHERE TP.ID_TIPO_PRODUCTO=P.ID_TIPO_PRODUCTO AND ST.ID_SUB_TIPO_PRODUCTO=P.ID_SUB_TIPO_PRODUCTO AND P.ID_MARKET=M.ID_MARKET AND P.ID_SIZE=S.ID_SIZE $smk $spt $sst $ssz $ssx ORDER BY P.ID_TIPO_PRODUCTO,P.ID_SUB_TIPO_PRODUCTO,P.ID_MARKET";
}
$rs = mysql_query($qry,$rosefarms) or die("Unable to load products, error: ".mysql_error());
$dt = mysql_fetch_array($rs);
?>
<form action="change_market.php" method="post" name="form2" id="form2" >
<table cellpadding=3 cellspacing=1 border="0" bgcolor=cecece>
<tr bgcolor="#FFFFFF">
<th colspan="10"> <div align="left">
<select name="nmk" id="nmk">
<option value="">Select Market</option>
<? SelecTable($db,'MARKETS','ID_MARKET','MARKET','','') ?>
</select>
<input name="Button2" type="button" value="Process Changes" onclick="valida();" />
</div></th>
</tr>
<tr>
<th width="25">ID</th>
<th width="52">Market</th>
<th>Product</td>
<th width="27">Size</td>
<th width="42">Status</td>
<th width="79">Stems/Buch</td>
<th width="88">Bunches/Box</td>
<th width="54">Bunch Price</td>
<th>
QBCODE
</form> </td>
</tr>
<tr>
<td>
<form id="form1" name="form1" method="post" action="<? echo $PHP_SELF."?status=$status"; ?>">
<table border="0" align="center" cellpadding="1" cellspacing="0" class="table">
<?php
if ($totalRows) {
?>
<tr>
<td colspan="2"><div align="left"><a href="../reports.php">Go Back to Main Menu</a></div></td>
<td>For Listed Orders </td>
<td colspan="3"><select name="new_status" id="new_status">
<option>Select Status</option>
<?php
SelecTable($database, 'ORDERS_STATUS', 'ID_ORDER_STATUS', "ORDER_STATUS", " {$arr_stat} ", "");
?>
</select> </td>
</tr>
<tr>
<th>Order Id </th>
<th>Client/Shipping to </th>
<th>Delivery</th>
<th>Ammount</th>
<th>Status</th>
<th><a href="javascript:Mark_all()" >All</a></th>
</tr>
<?php
$class = "";
do {
<!-- CONTENIDO -->
<script>
function Validar()
{
if (document.fm.nombre.value=="")
{ alert ('All data are required'); return false; }
}
</script>
<center>
<form>
<select name="pt" onchange="this.form.submit()">
<option value="">SELECT A PRODUCT TYPE </option>
<? SelecTable($db,'TIPO_PRODUCTOS','ID_TIPO_PRODUCTO','TIPO_PRODUCTO',"",$pt) ?>
</select>
</form>
<!-- CREAR -->
<? if($pt) { ?>
<table border="0" cellpadding=2 cellspacing=2>
<tr bgcolor=ffffff>
<form name=fm action="./admin_sproducts2x.php" onsubmit="return Validar()">
<!-- <td valign=top><b>CODE</b><br>
<input type="text" name="cod" size=5 maxlength=5>
</td> -->
<td valign=top><b>SubProduct</b><br>
