Help with Reservation Script
01-05-2012, 07:09 PM
|
Re: Help with Reservation Script
|
Posts: 96
Name: Joan
|
Quote:
Originally Posted by lizciz
Well, that's because the table is hard coded to go from 8am to 10pm. The code then just takes the first task, sees that it should be 5 hours long, and fills in 5 boxes. It doesn't take into account their actual times. If it should, then you need to rework the code a bit.
Either that, or make sure that tasks cannot be started before 8am...
|
Lizciz i have a major problem here :/ i'm not sure how to go about it..
i need to dynamically sort the order of the drivers with its respective reservations.. i have the table with the driver details and a priority column where the user can change the priority from 1 to 6 and then on the table i can display $driver1 = $driver_name where priority = 1
PHP Code:
//// here i get the current reservations
///////////driver 1///////////////
if ($CheckResStateCount>0){
$ResChapelNAme=CheckRsvpDriver($resStartTime,$actDate);
$sql_1="SELECT res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=1";
$result_1=mysql_query($sql_1) or die (mysql_error());
$rec_1_count=mysql_num_rows($result_1);
if ($rec_1_count>0){
$chapaleClikOne=true;
}else{ $chapaleClikOne=false;}
if ( $chapaleClikOne==true){
$item=array();
$CicketColor_1=array();
$CicketColor_1_Link=array();
$item = explode("-",$ResTime);
$count=count($item);
for ($r=0 ;$r<=14 ;$r++){
$CicketColor_1[$r]='#DBFDC4';
$CicketColor_1_Link[$r]=1;
}
for ($n=0;$n<$rec_1_count;$n++){
$MyDbResTimeStart_1=mysql_result($result_1,$n,'res_startTime');
$MyDbResTimeEnd_1=mysql_result($result_1,$n,'res_endTime');
$ResTime_1=$MyDbResTimeStart_1.'-'.$MyDbResTimeEnd_1;
$LoopStart_1=substr($MyDbResTimeStart_1,0,2);
$LoopEnd_1=substr($MyDbResTimeEnd_1,0,2);
$arraySt=$LoopStart_1-8;
$arrayEnd=$LoopEnd_1-8;
for ($m=$arraySt;$m<$arrayEnd ;$m++){
$CicketColor_1[$m]='#FF0000';
$CicketColor_1_Link[$m]=0;
}
}
}
/////////////////////////////driver id 2/////////////////////////////
$sql_2="SELECT res_startTime,res_endTime FROM reservation WHERE res_date='$actDate' AND res_driver_id=2";
$result_2=mysql_query($sql_2) or die (mysql_error());
$rec_1_count_2=mysql_num_rows($result_2);
if ($rec_1_count_2>0){
$chapaleClikTwo=true;
}else{ $chapaleClikTwo=false;}
if ( $chapaleClikTwo==true){
for ($s=0 ;$s<=14 ;$s++){
$CicketColor_2[$s]='#DBFDC4';
$CicketColor_2_Link[$s]=1;
}
for ($w=0;$w<$rec_1_count_2;$w++){
$MyDbResTimeStart_2=mysql_result($result_2,$w,'res_startTime');
$MyDbResTimeEnd_2=mysql_result($result_2,$w,'res_endTime');
$ResTime_2=$MyDbResTimeStart_2.'-'.$MyDbResTimeEnd_2;
$LoopStart_2=substr($MyDbResTimeStart_2,0,2);
$LoopEnd_2=substr($MyDbResTimeEnd_2,0,2);
$arraySt=$LoopStart_2-8;
$arrayEnd=$LoopEnd_2-8;
for ($x=$arraySt;$x<$arrayEnd ;$x++){
$CicketColor_2[$x]='#FF0000';
$CicketColor_2_Link[$x]=0;
}
}
}
////////////////////////////////driver id 3/////////////////////////////
$sql_3="SELECT res_startTime,res_endTime FROM reservation WHERE res_date='$actDate' AND res_driver_id=3";
$result_3=mysql_query($sql_3) or die (mysql_error());
$rec_3_count_3=mysql_num_rows($result_3);
if ($rec_3_count_3>0){
$chapaleClikThree=true;
}else{ $chapaleClikThree=false;}
if ( $chapaleClikThree==true){
for ($t=0 ;$t<=14 ;$t++){
$CicketColor_3[$t]='#DBFDC4';
$CicketColor_3_Link[$t]=1;
}
for ($h=0;$h<$rec_3_count_3;$h++){
$MyDbResTimeStart_3=mysql_result($result_3,$h,'res_startTime');
$MyDbResTimeEnd_3=mysql_result($result_3,$h,'res_endTime');
$ResTime_3=$MyDbResTimeStart_3.'-'.$MyDbResTimeEnd_3;
$LoopStart_3=substr($MyDbResTimeStart_3,0,2);
$LoopEnd_3=substr($MyDbResTimeEnd_3,0,2);
$arraySt=$LoopStart_3-8;
$arrayEnd=$LoopEnd_3-8;
for ($f=$arraySt;$f<$arrayEnd ;$f++){
$CicketColor_3[$f]='#FF0000';
$CicketColor_3_Link[$f]=0;
}
}
}
//this gets the driver
$sql_driver1 = "SELECT dr_id,dr_name FROM driver_details WHERE priority = '1'";
$res_driver1 = mysql_query($sql_driver1)or die(mysql_error());
$row_driver1 = mysql_fetch_array($res_driver1);
$driver1= $row_driver1['dr_name'];
///
$sql_driver2 = "SELECT dr_id,dr_name FROM driver_details WHERE priority = '2'";
$res_driver2 = mysql_query($sql_driver2)or die(mysql_error());
$row_driver2 = mysql_fetch_array($res_driver2);
$driver2= $row_driver2['dr_name'];
/////
$sql_driver3 = "SELECT dr_id,dr_name FROM driver_details WHERE priority = '3'";
$res_driver3 = mysql_query($sql_driver3)or die(mysql_error());
$row_driver3 = mysql_fetch_array($res_driver3);
$driver3= $row_driver3['dr_name'];
////
$sql_driver4 = "SELECT dr_id,dr_name FROM driver_details WHERE priority = '4'";
$res_driver4 = mysql_query($sql_driver4)or die(mysql_error());
$row_driver4 = mysql_fetch_array($res_driver4);
$driver4= $row_driver4['dr_name'];
/////
$sql_driver5 = "SELECT dr_id,dr_name FROM driver_details WHERE priority = '5'";
$res_driver5 = mysql_query($sql_driver5)or die(mysql_error());
$row_driver5 = mysql_fetch_array($res_driver5);
$driver5= $row_driver5['dr_name'];
//
$sql_driver6 = "SELECT dr_id,dr_name FROM driver_details WHERE priority = '6'";
$res_driver6 = mysql_query($sql_driver6)or die(mysql_error());
$row_driver6 = mysql_fetch_array($res_driver6);
$driver6= $row_driver6['dr_name'];
PHP Code:
//the table is displayed
<tr><?php if ($chapaleClikOne==true){?>
<td id="left" width="100"><?php echo $driver1;?> </td>
<td bgcolor="<?php echo $CicketColor_1[0];?>"><?php if ($CicketColor_1_Link[0]==1){ echo $ResTimePeriod[0]; }else{ echo $ResTimePeriod[0];}?></td>
<td bgcolor="<?php echo $CicketColor_1[1];?>"><?php if ($CicketColor_1_Link[1]==1){ echo $ResTimePeriod[1]; }else{ echo $ResTimePeriod[1];}?></td>
<td bgcolor="<?php echo $CicketColor_1[2];?>"><?php if ($CicketColor_1_Link[2]==1){ echo $ResTimePeriod[2]; }else{ echo $ResTimePeriod[2];}?></td>
<td bgcolor="<?php echo $CicketColor_1[3];?>"><?php if ($CicketColor_1_Link[3]==1){ echo $ResTimePeriod[3]; }else{ echo $ResTimePeriod[3];}?></td>
<td bgcolor="<?php echo $CicketColor_1[4];?>"><?php if ($CicketColor_1_Link[4]==1){ echo $ResTimePeriod[4]; }else{ echo $ResTimePeriod[4];}?></td>
<td bgcolor="<?php echo $CicketColor_1[5];?>"><?php if ($CicketColor_1_Link[5]==1){ echo $ResTimePeriod[5]; }else{ echo $ResTimePeriod[5];}?></td>
<td bgcolor="<?php echo $CicketColor_1[6];?>"><?php if ($CicketColor_1_Link[6]==1){ echo $ResTimePeriod[6]; }else{ echo $ResTimePeriod[6];}?></td>
<td bgcolor="<?php echo $CicketColor_1[7];?>"><?php if ($CicketColor_1_Link[7]==1){ echo $ResTimePeriod[7]; }else{ echo $ResTimePeriod[7];}?></td>
<td bgcolor="<?php echo $CicketColor_1[8];?>"><?php if ($CicketColor_1_Link[8]==1){ echo $ResTimePeriod[8]; }else{ echo $ResTimePeriod[8];}?></td>
<td bgcolor="<?php echo $CicketColor_1[9];?>"><?php if ($CicketColor_1_Link[9]==1){ echo $ResTimePeriod[9]; }else{ echo $ResTimePeriod[9];}?></td>
<td bgcolor="<?php echo $CicketColor_1[10];?>"><?php if ($CicketColor_1_Link[10]==1){ echo $ResTimePeriod[10]; }else{ echo $ResTimePeriod[10];}?></td>
<td bgcolor="<?php echo $CicketColor_1[11];?>"><?php if ($CicketColor_1_Link[11]==1){ echo $ResTimePeriod[11]; }else{ echo $ResTimePeriod[11];}?></td>
<td bgcolor="<?php echo $CicketColor_1[12];?>"><?php if ($CicketColor_1_Link[12]==1){ echo $ResTimePeriod[12]; }else{ echo $ResTimePeriod[12];}?></td>
<td bgcolor="<?php echo $CicketColor_1[13];?>"><?php if ($CicketColor_1_Link[13]==1){ echo $ResTimePeriod[13]; }else{ echo $ResTimePeriod[13];}?></td>
<td bgcolor="<?php echo $CicketColor_1[14];?>"><?php if ($CicketColor_1_Link[14]==1){ echo $ResTimePeriod[14]; }else{ echo $ResTimePeriod[14];}?></td>
<?php }else{?>
<td id="left" width="100"><?php echo $driver1;?> </td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[0];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[1];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[2];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[3];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[4];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[5];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[6];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[7];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[8];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[9];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[10];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[11];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[12];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[13];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[14];?></a></td>
<?php }?>
</tr>
<tr><?php
$sqltype ="SELECT res_caseNo,res_id,res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=1 ORDER BY res_startTime, res_date";
$result = mysql_query($sqltype);
$record_count=mysql_num_rows($result);
if($record_count>0){
//echo '<tr><td><br/></td></tr>';
$last_task = 8;
echo '<td id="left" width="100">Task:</td>'; // I added a closing </td> here
while($row1 = mysql_fetch_assoc($result)) {
$startTime = $row1['res_startTime'];
$endTime = $row1['res_endTime'];
$start_sub=substr($startTime,0,2);
$end_sub=substr($endTime,0,2);
$diff = $end_sub - $start_sub;
/*===== This is new code =====*/
$empty = $start_sub - $last_task; // you may have to subtract 1, depending on what you store in your database
if ($empty > 0) {
echo '<td colspan="' . $empty . '"> </td>';
}
$last_task = $end_sub;
/*===== New code ends here =====*/
echo '<td bgcolor="#FF0000" colspan="'.$diff.'" style="font-weight:bold; text-align:center">';
echo '<font color="white">'. $row1['type'] . '</font> ';
if($type == $row1['type']){echo '<input type="button" value="Add On" onClick="location.href=\'addon_driver.php?id='.$row1['res_id'].'&name='.$name.'&type='.$type.'\'"/>'; }
}
echo '<br/> </td>';
// echo $empty ." empty";
}else{
echo '<td><br/></td>';
}?>
</tr>
<tr>
<td id="left" width="100"><?php echo $driver2;?></td>
<?php if ($chapaleClikTwo==true){?>
<td bgcolor="<?php echo $CicketColor_2[0];?>"><?php if ($CicketColor_2_Link[0]==1){ echo $ResTimePeriod[0];?></a><?php }else{ echo $ResTimePeriod[0];}?></td>
<td bgcolor="<?php echo $CicketColor_2[1];?>"><?php if ($CicketColor_2_Link[1]==1){ echo $ResTimePeriod[1];?></a><?php }else{ echo $ResTimePeriod[1];}?></td>
<td bgcolor="<?php echo $CicketColor_2[2];?>"><?php if ($CicketColor_2_Link[2]==1){ echo $ResTimePeriod[2];?></a><?php }else{ echo $ResTimePeriod[2];}?></td>
<td bgcolor="<?php echo $CicketColor_2[3];?>"><?php if ($CicketColor_2_Link[3]==1){ echo $ResTimePeriod[3];?></a><?php }else{ echo $ResTimePeriod[3];}?></td>
<td bgcolor="<?php echo $CicketColor_2[4];?>"><?php if ($CicketColor_2_Link[4]==1){ echo $ResTimePeriod[4];?></a><?php }else{ echo $ResTimePeriod[4];}?></td>
<td bgcolor="<?php echo $CicketColor_2[5];?>"><?php if ($CicketColor_2_Link[5]==1){ echo $ResTimePeriod[5];?></a><?php }else{ echo $ResTimePeriod[5];}?></td>
<td bgcolor="<?php echo $CicketColor_2[6];?>"><?php if ($CicketColor_2_Link[6]==1){ echo $ResTimePeriod[6];?></a><?php }else{ echo $ResTimePeriod[6];}?></td>
<td bgcolor="<?php echo $CicketColor_2[7];?>"><?php if ($CicketColor_2_Link[7]==1){ echo $ResTimePeriod[7];?></a><?php }else{ echo $ResTimePeriod[7];}?></td>
<td bgcolor="<?php echo $CicketColor_2[8];?>"><?php if ($CicketColor_2_Link[8]==1){ echo $ResTimePeriod[8];?></a><?php }else{ echo $ResTimePeriod[8];}?></td>
<td bgcolor="<?php echo $CicketColor_2[9];?>"><?php if ($CicketColor_2_Link[9]==1){ echo $ResTimePeriod[9];?></a><?php }else{ echo $ResTimePeriod[9];}?></td>
<td bgcolor="<?php echo $CicketColor_2[10];?>"><?php if ($CicketColor_2_Link[10]==1){ echo $ResTimePeriod[10];?></a><?php }else{ echo $ResTimePeriod[10];}?></td>
<td bgcolor="<?php echo $CicketColor_2[11];?>"><?php if ($CicketColor_2_Link[11]==1){ echo $ResTimePeriod[11];?></a><?php }else{ echo $ResTimePeriod[11];}?></td>
<td bgcolor="<?php echo $CicketColor_2[12];?>"><?php if ($CicketColor_2_Link[12]==1){ echo $ResTimePeriod[12];?></a><?php }else{ echo $ResTimePeriod[12];}?></td>
<td bgcolor="<?php echo $CicketColor_2[13];?>"><?php if ($CicketColor_2_Link[13]==1){ echo $ResTimePeriod[13];?></a><?php }else{ echo $ResTimePeriod[13];}?></td>
<td bgcolor="<?php echo $CicketColor_2[14];?>"><?php if ($CicketColor_2_Link[14]==1){ echo $ResTimePeriod[14];?></a><?php }else{ echo $ResTimePeriod[14];}?></td>
<?php }else{?>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[0];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[1];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[2];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[3];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[4];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[5];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[6];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[7];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[8];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[9];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[10];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[11];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[12];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[13];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[14];?></a></td>
<?php } ?>
</tr>
<tr><?php
$sqltype ="SELECT res_caseNo,res_id,res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=2 ORDER BY res_startTime, res_date";
$result = mysql_query($sqltype);
$record_count=mysql_num_rows($result);
if($record_count>0){
//echo '<tr><td><br/></td></tr>';
$last_task = 8;
echo '<td id="left" width="100">Task:</td>'; // I added a closing </td> here
while($row1 = mysql_fetch_assoc($result)) {
$startTime = $row1['res_startTime'];
$endTime = $row1['res_endTime'];
$start_sub=substr($startTime,0,2);
$end_sub=substr($endTime,0,2);
$diff = $end_sub - $start_sub;
/*===== This is new code =====*/
$empty = $start_sub - $last_task; // you may have to subtract 1, depending on what you store in your database
if ($empty > 0) {
echo '<td colspan="' . $empty . '"> </td>';
}
$last_task = $end_sub;
/*===== New code ends here =====*/
echo '<td bgcolor="#FF0000" colspan="'.$diff.'" style="font-weight:bold; text-align:center">';
echo '<font color="white">'. $row1['type'] . '</font> ';
if($type == $row1['type']){echo '<input type="button" value="Add On" onClick="location.href=\'addon_driver.php?id='.$row1['res_id'].'&name='.$name.'&type='.$type.'\'"/>'; }
}
echo '<br/> </td>';
// echo $empty ." empty";
}else{
echo '<td><br/></td>';
}?>
</tr>
<tr>
<td id="left" width="100"><?php echo $driver3;?></td>
<?php if ($chapaleClikThree==true){?>
<td bgcolor="<?php echo $CicketColor_3[0];?>"><?php if ($CicketColor_3_Link[0]==1){ echo $ResTimePeriod[0];?></a><?php }else{ echo $ResTimePeriod[0];}?></td>
<td bgcolor="<?php echo $CicketColor_3[1];?>"><?php if ($CicketColor_3_Link[1]==1){ echo $ResTimePeriod[1];?></a><?php }else{ echo $ResTimePeriod[1];}?></td>
<td bgcolor="<?php echo $CicketColor_3[2];?>"><?php if ($CicketColor_3_Link[2]==1){ echo $ResTimePeriod[2];?></a><?php }else{ echo $ResTimePeriod[2];}?></td>
<td bgcolor="<?php echo $CicketColor_3[3];?>"><?php if ($CicketColor_3_Link[3]==1){ echo $ResTimePeriod[3];?></a><?php }else{ echo $ResTimePeriod[3];}?></td>
<td bgcolor="<?php echo $CicketColor_3[4];?>"><?php if ($CicketColor_3_Link[4]==1){ echo $ResTimePeriod[4];?></a><?php }else{ echo $ResTimePeriod[4];}?></td>
<td bgcolor="<?php echo $CicketColor_3[5];?>"><?php if ($CicketColor_3_Link[5]==1){ echo $ResTimePeriod[5];?></a><?php }else{ echo $ResTimePeriod[5];}?></td>
<td bgcolor="<?php echo $CicketColor_3[6];?>"><?php if ($CicketColor_3_Link[6]==1){ echo $ResTimePeriod[6];?></a><?php }else{ echo $ResTimePeriod[6];}?></td>
<td bgcolor="<?php echo $CicketColor_3[7];?>"><?php if ($CicketColor_3_Link[7]==1){ echo $ResTimePeriod[7];?></a><?php }else{ echo $ResTimePeriod[7];}?></td>
<td bgcolor="<?php echo $CicketColor_3[8];?>"><?php if ($CicketColor_3_Link[8]==1){ echo $ResTimePeriod[8];?></a><?php }else{ echo $ResTimePeriod[8];}?></td>
<td bgcolor="<?php echo $CicketColor_3[9];?>"><?php if ($CicketColor_3_Link[9]==1){ echo $ResTimePeriod[9];?></a><?php }else{ echo $ResTimePeriod[9];}?></td>
<td bgcolor="<?php echo $CicketColor_3[10];?>"><?php if ($CicketColor_3_Link[10]==1){ echo $ResTimePeriod[10];?></a><?php }else{ echo $ResTimePeriod[10];}?></td>
<td bgcolor="<?php echo $CicketColor_3[11];?>"><?php if ($CicketColor_3_Link[11]==1){ echo $ResTimePeriod[11];?></a><?php }else{ echo $ResTimePeriod[11];}?></td>
<td bgcolor="<?php echo $CicketColor_3[12];?>"><?php if ($CicketColor_3_Link[12]==1){ echo $ResTimePeriod[12];?></a><?php }else{ echo $ResTimePeriod[12];}?></td>
<td bgcolor="<?php echo $CicketColor_3[13];?>"><?php if ($CicketColor_3_Link[13]==1){ echo $ResTimePeriod[13];?></a><?php }else{ echo $ResTimePeriod[13];}?></td>
<td bgcolor="<?php echo $CicketColor_3[14];?>"><?php if ($CicketColor_3_Link[14]==1){ echo $ResTimePeriod[14];?></a><?php }else{ echo $ResTimePeriod[14];}?></td>
<?php }else{?>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[0];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[1];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[2];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[3];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[4];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[5];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[6];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[7];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[8];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[9];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[10];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[11];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[12];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[13];?></a></td>
<td bgcolor="<?php echo $GoColor;?>"><?php echo $ResTimePeriod[14];?></a></td>
<?php }?>
</tr>
<tr><?php
$sqltype ="SELECT res_caseNo,res_id,res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=3 ORDER BY res_startTime, res_date";
$result = mysql_query($sqltype);
$record_count=mysql_num_rows($result);
if($record_count>0){
//echo '<tr><td><br/></td></tr>';
$last_task = 8;
echo '<td id="left" width="100">Task:</td>'; // I added a closing </td> here
while($row1 = mysql_fetch_assoc($result)) {
$startTime = $row1['res_startTime'];
$endTime = $row1['res_endTime'];
$start_sub=substr($startTime,0,2);
$end_sub=substr($endTime,0,2);
$diff = $end_sub - $start_sub;
/*===== This is new code =====*/
$empty = $start_sub - $last_task; // you may have to subtract 1, depending on what you store in your database
if ($empty > 0) {
echo '<td colspan="' . $empty . '"> </td>';
}
$last_task = $end_sub;
/*===== New code ends here =====*/
echo '<td bgcolor="#FF0000" colspan="'.$diff.'" style="font-weight:bold; text-align:center">';
echo '<font color="white">'. $row1['type'] . '</font> ';
if($type == $row1['type']){echo '<input type="button" value="Add On" onClick="location.href=\'addon_driver.php?id='.$row1['res_id'].'&name='.$name.'&type='.$type.'\'"/>'; }
}
echo '<br/> </td>';
// echo $empty ." empty";
}else{
echo '<td><br/></td>';
}?>
</tr>
is this even possible? i don't even know how to start or how the logic works i have been trying to figure it out all day with no success :/ if you can help me please i would really appreciate it or if this is not possible it'll be nice to know too..
thanks
Last edited by stivens; 01-05-2012 at 07:11 PM..
|
|
|
|
|
01-05-2012, 07:22 PM
|
Re: Help with Reservation Script
|
Posts: 807
Name: Mattias Nordahl
Location: Sweden
|
I don't fully understand you question, but if you want to sort the output from your database, use the "order by" clause. As in
SELECT dr_id,dr_name FROM driver_details ORDER BY priority ASC
(ASC means ascending order, you can also use DESC for descending order)
__________________
Your answers will only be as good as your question. Formulate it well and give all the necessary information.
|
|
|
|
|
01-05-2012, 07:37 PM
|
Re: Help with Reservation Script
|
Posts: 96
Name: Joan
|
Quote:
Originally Posted by lizciz
I don't fully understand you question, but if you want to sort the output from your database, use the "order by" clause. As in
SELECT dr_id,dr_name FROM driver_details ORDER BY priority ASC
(ASC means ascending order, you can also use DESC for descending order)
|
but the way it color the boxes red its because its looking for reservations by driver_id.. i dont have an option to ORDER BY
PHP Code:
$ResChapelNAme=CheckRsvpDriver($resStartTime,$actDate);
$sql_1="SELECT res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=1";
$result_1=mysql_query($sql_1) or die (mysql_error());
$rec_1_count=mysql_num_rows($result_1);
if ($rec_1_count>0){
$chapaleClikOne=true;
}else{ $chapaleClikOne=false;}
if ( $chapaleClikOne==true){
$item=array();
$CicketColor_1=array();
$CicketColor_1_Link=array();
$item = explode("-",$ResTime);
$count=count($item);
for ($r=0 ;$r<=14 ;$r++){
$CicketColor_1[$r]='#DBFDC4';
$CicketColor_1_Link[$r]=1;
}
for ($n=0;$n<$rec_1_count;$n++){
$MyDbResTimeStart_1=mysql_result($result_1,$n,'res_startTime');
$MyDbResTimeEnd_1=mysql_result($result_1,$n,'res_endTime');
$ResTime_1=$MyDbResTimeStart_1.'-'.$MyDbResTimeEnd_1;
$LoopStart_1=substr($MyDbResTimeStart_1,0,2);
$LoopEnd_1=substr($MyDbResTimeEnd_1,0,2);
$arraySt=$LoopStart_1-8;
$arrayEnd=$LoopEnd_1-8;
for ($m=$arraySt;$m<$arrayEnd ;$m++){
$CicketColor_1[$m]='#FF0000';
$CicketColor_1_Link[$m]=0;
}
}
}
|
|
|
|
|
01-06-2012, 03:54 AM
|
Re: Help with Reservation Script
|
Posts: 807
Name: Mattias Nordahl
Location: Sweden
|
Again, I still don't understand what you're trying to do, but of course you can combine several clauses in your sql query
Code:
SELECT res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=1 ORDER BY priority ASC
__________________
Your answers will only be as good as your question. Formulate it well and give all the necessary information.
|
|
|
|
|
« Reply to Help with Reservation Script
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
