Example #1
0
<!--<body bgcolor=#ddddff></body><font color=#hhhhhh weight="10"><center><b>Reliance Dairy Foods Ltd.,Sarsa</b></center></font><hr width="270" color=#acacff>-->
</body>
</html>

<?php 
include "rdfl_connect.inc";
global $default_dbname, $pooling_pt_table, $pooling_mem;
$link_id = db_connect($default_dbname);
if (!$link_id) {
    error_message(sql_error());
}
date_default_timezone_set("Asia/Kolkata");
$date = date("d-m-Y", time());
$hour = date("G");
$shift_options = enum_options('shift', $link_id);
$shift_status = enum_options('status', $link_id);
if ($hour >= 0 and $hour < 12) {
    $shift = $shift_options[0];
} else {
    $shift = $shift_options[1];
}
$query = "select status from {$pooling_pt_table} where date='{$date}' and shift='{$shift}'";
$result = mysql_query($query);
if (!$result) {
    error_message(sql_error());
}
$query_data = mysql_fetch_row($result);
$status1 = $query_data[0];
if ($status1 == $shift_status[1]) {
    echo "<SCRIPT>window.alert(\"{$shift} Shift For Date:{$date} Has Already Been Dispatched ?\");history.go(-1);</SCRIPT>";
}
Example #2
0
<?php

include "rdfl_connect.inc";
global $default_dbname, $pooling_pt_table, $pooling_mem_table;
$link_id = db_connect($default_dbname);
if (!$link_id) {
    error_message(sql_error());
}
$shift_options = enum_options('shift', $link_id);
mysql_close($link_id);
date_default_timezone_set("Asia/Kolkata");
$date = date("d-m-Y", time());
?>

<html>
<head>
<title>RDFL Pooling Point</title>
<link href="calendar.css" rel="stylesheet" type="text/css" media="screen">
<script language="javaScript" type="text/javascript" src="calendar.js"></script> 
</head>
<body bgcolor="#f1f1f1">
<div align="center">
<div style="margin-top=5px;width:500px;height:65px;background-image:url('images/logo_main.jpg');background-repeat:no-repeat;position:relative;" >
<img src="images\logo.gif" align="left" width="150" height="65"><br>
<center><font color=#19449b font-size="12"><b>Reliance Dairy Foods Ltd.,Sarsa</b></font><hr width="240" color=#acacff></center>
</div></div><br>
<!--<body bgcolor=#ddddff><font color=#hhhhhh weight="10"><center><b>Reliance Dairy Foods Ltd.,Sarsa</b></center></font><hr width="270" color=#acacff>-->
<form method="post" action="rdfltest1.php">
<input type="hidden" name="posted" value="true">
<table border="3" align="center">
<tr>