<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>