//exit;
//echo $sql;
$result = mysql_query($sql);
if (mysql_num_rows($result) != 0) {
$row = mysql_fetch_array($result);
$ordernumber = $row["order_id"];
$username = $row["user_name"];
if ($row['vorder_currency'] != $sellerCurrency and $row['vorder_currency'] != "USD") {
$get_conversion_price = getCurrencyrate($sellerCurrency);
$ordertotal = $row["total"];
} else {
$ordertotal = $row["total"];
}
$taxtotal = $row["taxtotal"];
//$ordertotal+=$row["taxrate"];
$orderstatus = getArtistOrderStatus($orderid, $artistid);
$orderdate = $row["order_date"];
$orderdate = dateFormat($orderdate, "Y-m-d", "m/d/Y");
$userid = $row["user_id"];
}
//$statlist= getStatusList();
$statlist = array();
if ($orderstatus == "Cancelled") {
$statlist[2] = "Cancelled";
} else {
if ($orderstatus == "Shipped") {
$statlist[3] = "Shipped";
} else {
if ($orderstatus == "Delivered") {
$statlist[4] = "Delivered";
} else {
<tr>
<td colspan='3'>
Order Part # <?php
echo $i + 1;
?>
<table width='100%' border='0' cellpadding='0' cellspacing='0' class="cart_listingtbl2" >
<tr class="whitebg">
<td width='100%' colspan='7' align="left" ><b><?php
echo TEXT_VENDOR;
?>
: <font color='RED'><?php
echo stripslashes(getArtistCompanyName($artists[$i]));
?>
</font></b> Order Status: <b><font color='RED'><?php
echo getArtistOrderStatus($orderid, $artists[$i]);
?>
</font></b></td>
</tr>
<tr><td width='100%' colspan='7'>
<table BORDER="0" width="100%" cellpadding="0" cellspacing="0" class="cart_listingtbl" >
<tr>
<th width='4%' align="center"><b>#</b></th>
<th width='39%' align="center"><b>Product Name</b></th>
<th width='12%' align="center"><b>Code</b></th>
<th width='10%' align="center"><b>Rate</b></th>
<th width='6%' align="center"><b>Qty</b></th>
<td><?php
echo $link . htmlentities($row["email"]) . "</a>";
?>
</td>
<td align="center"><?php
echo $link . dateFormat($row["order_date"], "Y-m-d", "m/d/Y") . "</a>";
?>
</td>
<td><?php
echo $link . $adminCurrency["currency_symbol"] . " " . htmlentities(number_format($ordertotal, 2, '.', '')) . "</a>";
?>
</td>
<td><?php
echo $link . htmlentities(getArtistOrderStatus($row["order_id"], $artistid)) . "</a>";
?>
</td>
</tr>
<?php
$i++;
}
?>
<?php
if (isNotNull($check)) {
?>
<tr>
<td colspan="6" align="center"><input type="submit" name="btnRequestForPayment" value="Request For Payment" class="button">
</td>
</tr>
<?php
</td>
<td valign="top" align="left"><?php
echo htmlentities($rw["order_status"]);
?>
</td>
</tr>
<?php
$k++;
}
?>
<?php
$orderpartialStatus = getArtistOrderStatus($orderid, $artists[$i]);
if ($orderpartialStatus != 'Delivered') {
?>
<tr class="brdr_new">
<td height="37" colspan="5" align="left"> <?php
echo $rw['item_status'];
?>
Change status to: <?php
echo $ddl;
?>
<span class="btn_gotbl">
<input name="chkStatus" type="checkbox" id="chkStatus" value="Y">
Inform Order Status Change To Buyer </span> <?php
echo $btn;
}
}
$orderTotal += $totalshippingcost;
$link = 'vieworder.php?orderid=' . $ordRow["order_id"];
?>
<tr>
<td valign="top" align="left"><?php
echo htmlentities($ordRow["order_id"]);
?>
</td>
<td valign="top" align="left"><?php
echo htmlentities($ordRow["user_name"]);
?>
</td>
<td valign="top" align="left"><?php
echo getArtistOrderStatus($ordRow["order_id"], $artistid);
?>
</td>
<td valign="top" align="left"><?php
echo dateFormat($ordRow["order_date"], "Y-m-d", "m/d/Y");
?>
</td>
<td valign="top" align="left">$<?php
echo htmlentities(number_format($orderTotal, 2, '.', ''));
?>
</td>
<td><a href="<?php
echo $link;
?>
">View</a></td>