session_start();
if(!isset($_SESSION['udesig']) || $_SESSION['udesig']!="admin")
header("Location:loginmain.php");
include "head.inc";
if(!isset($_POST["Submit"]))
{
$usstates = array("AL","AK","AS","AZ","AR","CA","CO","CT","DE","DC","FM","FL","GA","GU","HI","ID","IL","IN","IA","KS","KY","LA","ME","MH","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","MP","OH","OK","OR","PW","PA","PR","RI","SC","SD","TN","TX","UT","VT","VI","VA","WA","WV","WI","WY");
?>
| ::. ADMINISTRATOR>>MAIN>>SEARCH ORDERS |
|
|
}
else
{
include "common.php";
dbconnect();
$dt = date("Y-m-d",mktime(0,0,0,$_POST['m'],$_POST['d'],$_POST['y'])) ;
$dt2 = date("Y-m-d",mktime(0,0,0,$_POST['m2'],$_POST['d2'],$_POST['y2']));
$customercode = trim($_POST["customercode"]);
$orderno = trim($_POST["orderno"]);
$orderstatus = trim($_POST["orderstatus"]);
$sql = "select * from order_details where order_Date >= '$dt' and order_Date<= '$dt2'";
if($customercode!="")
$sql.=" and cust_Code like '%$customercode%'";
if($orderno!="")
$sql.=" and order_Number like '%$orderno%'";
if($orderstatus!="0")
$sql.=" and order_Status = '$orderstatus'";
$sql.=" order by order_Date ASC";
$result = @mysql_query($sql);
if($result)
{
$numrows = mysql_num_rows($result);
?>
| ::. ADMINISTRATOR>>MAIN>>SEARCH RESULT(ORDERS) |
if($numrows<1)
{
?>
| No records available !! |
exit;
}
else
{
?>
| Order No |
Customer Code |
Date of Transaction |
Order Status |
Last Update |
Notes |
while($row=mysql_fetch_row($result))
{
?>
| =$row[0]?> |
=$row[1]?> |
dateflip($row[2]) ?> |
=$row[3]?> |
dateflip($row[4]) ?> |
=$row[5]?> |
}
}
?>
|
|
}
else
{
print_msg("Process failed !!".mysql_error(),"admin_main.php");
}
}
include "foot.inc";
?>