<!--<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>"; }
<?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>