PageRenderTime 48ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

/booking/reservations/agent_calendar_by_year.php

https://bitbucket.org/anneivycat/california-tour
PHP | 333 lines | 287 code | 23 blank | 23 comment | 90 complexity | 5fb543e846821abe3e6b57dec33017e2 MD5 | raw file
    

  1. <?php
    2. 

  2. error_reporting(0);
    3. 

  3. extract($_GET);
    4. 

  4. include ("../sqlfuncs.php");
    5. 

  5. 

  6. $l = connect_to_db();
    7. 

  7. $l = select_db($l);
    8. 

  8. 

  9. if ($city=="") { $city="SF"; }
    10. 

  10. $myCities["SB"]="Santa Barbara";
    11. 

  11. $myCities["SF"]="San Francisco";
    12. 

  12. $myCities["SD"]="San Diego";
    13. 

  13. $myCities["LA"]="Los Angeles";
    14. 

  14. 

  15. $sql = 'SELECT `TOUR_TYPE` AS tt, `TOUR_NAME` AS tn
    16. 

  16. FROM `TOUR` 
    17. 

  17. ORDER BY tt;';
    18. 

  18. $r = mysql_query($sql);
    19. 

  19. $nr = mysql_num_rows($r);
    20. 

  20. for ($i=0;$i<$nr;$i++) {
    21. 

  21.  $line=mysql_fetch_array($r);
    22. 

  22.  $myTours[$line['tt']]=ucwords(strtolower($line['tn']));
    23. 

  23. // echo $line['tt']."=".$line['tn']."<br />\n";
    24. 

  24. }
    25. 

  25. ?>
    26. 

  26. 

  27. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
    28. 

  28. <HTML>
    29. 

  29. <HEAD>
    30. 

  30. <TITLE>Tours from <?php echo $myCities[$city]; ?></TITLE>
    31. 

  31. <?php if($languageUsed == "JP") { ?>
    32. 

  32. <meta http-equiv=\"Content-Type\" content="text/html; charset=x-sjis">
    33. 

  33. <?php
    34. 

  34. } else {
    35. 

  35. ?>
    36. 

  36. <meta http-equiv=\"Content-Type\" content="text/html; charset=UTF-8">
    37. 

  37. <?php
    38. 

  38. }
    39. 

  39. ?>
    40. 

  40. <style type="text/css">
    41. 

  41. BODY {
    42. 

  42. 	font: 300 10px Verdana, Arial, sans-serif;
    43. 

  43. }
    44. 

  44. A SPAN { display: none; }
    45. 

  45. A:HOVER SPAN { display: block; }
    46. 

  46. </style>
    47. 

  47. 

  48. <?php echo "<title>California Tours - Tours From $city</title>\n"; ?>
    49. 

  49. <script language="JavaScript">
    50. 

  50. <!--
    51. 

  51. 

  52. function MM_swapImgRestore() { //v3.0
    53. 

  53.  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
    54. 

  54. }
    55. 

  55. 

  56. function MM_preloadImages() { //v3.0
    57. 

  57.  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    58. 

  58.    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    59. 

  59.    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
    60. 

  60. }
    61. 

  61. 

  62. function MM_findObj(n, d) { //v4.0
    63. 

  63.  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    64. 

  64.    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
    65. 

  65.  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
    66. 

  66.  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
    67. 

  67.  if(!x && document.getElementById) x=document.getElementById(n); return x;
    68. 

  68. }
    69. 

  69. 

  70. function MM_swapImage() { //v3.0
    71. 

  71.  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
    72. 

  72.   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
    73. 

  73. }
    74. 

  74. //-->
    75. 

  75. </script>
    76. 

  76. </head>
    77. 

  77. <?php
    78. 

  78. 

  79. function getFirstWeekDay($CurrentYear,$CurrentMonth,$CurrentDay) {
    80. 

  80. /*
    81. 

  81. 	if($CurrentDay == "")
    82. 

  82. 		$CurrentDay = "1";
    83. 

  83.  $day=mktime(0, 0, 0, $CurrentMonth,$CurrentDay,$CurrentYear);
    84. 

  84.  echo "<p>day: $day; 0, 0, 0, $CurrentMonth,$CurrentDay,$CurrentYear";
    85. 

  85.  $day=date("w",$day);
    86. 

  86.  echo " date: $day</p>";
    87. 

  87.  */
    88. 

  88.  $day = date("w",strtotime("$CurrentMonth/1/$CurrentYear"));
    89. 

  89.  return ($day);
    90. 

  90. }
    91. 

  91. 

  92. function getMonthName($iMonth) {
    93. 

  93.  if ($iMonth == 1) { return("January"); }
    94. 

  94.  if ($iMonth == 2) { return("February"); }
    95. 

  95.  if ($iMonth == 3) { return("March"); }
    96. 

  96.  if ($iMonth == 4) { return("April"); }
    97. 

  97.  if ($iMonth == 5) { return("May"); }
    98. 

  98.  if ($iMonth == 6) { return("June"); }
    99. 

  99.  if ($iMonth == 7) { return("July"); }
    100. 

  100.  if ($iMonth == 8) { return("August"); }
    101. 

  101.  if ($iMonth == 9) { return("September"); }
    102. 

  102.  if ($iMonth == 10) { return("October"); }
    103. 

  103.  if ($iMonth == 11) { return("November"); }
    104. 

  104.  if ($iMonth == 12) { return("December"); }
    105. 

  105.  return("INVALID MONTH");
    106. 

  106. }
    107. 

  107. 

  108. function getDaysInMonth($CurrentYear,$CurrentMonth) {
    109. 

  109.  $iDaysInMonth = 31;
    110. 

  110.  if (getMonthName($CurrentMonth) == "January") { return(31); }
    111. 

  111.  if (getMonthName($CurrentMonth) == "March") { return(31); }
    112. 

  112.  if (getMonthName($CurrentMonth) == "April") { return(30); }
    113. 

  113.  if (getMonthName($CurrentMonth) == "May") { return(31); }
    114. 

  114.  if (getMonthName($CurrentMonth) == "June") { return(30); }
    115. 

  115.  if (getMonthName($CurrentMonth) == "July") { return(31); }
    116. 

  116.  if (getMonthName($CurrentMonth) == "August") { return(31); }
    117. 

  117.  if (getMonthName($CurrentMonth) == "September") { return(30); }
    118. 

  118.  if (getMonthName($CurrentMonth) == "October") { return(31); }
    119. 

  119.  if (getMonthName($CurrentMonth) == "November") { return(30); }
    120. 

  120.  if (getMonthName($CurrentMonth) == "December") { return(31); }
    121. 

  121.  if (getMonthName($CurrentMonth) == "February") {
    122. 

  122.   $strCurrentYear = sprintf("%s",$CurrentYear);
    123. 

  123.   if (($CurrentYear %4) == 0) {
    124. 

  124.    return(29);
    125. 

  125.   } else {
    126. 

  126.    return(28);
    127. 

  127.   }
    128. 

  128.  return ($iDaysInMonth);
    129. 

  129.  }
    130. 

  130. }
    131. 

  131. 

  132. $day="";
    133. 

  133. $dtToday = getdate(time());
    134. 

  134. if(isset($_REQUEST["year"]) && is_numeric($_REQUEST["year"]))
    135. 

  135. 	$year = $_REQUEST["year"];
    136. 

  136. else
    137. 

  137. 	$year = date("Y",time());
    138. 

  138. 	
    139. 

  139. if(isset($_REQUEST["month"]) && is_numeric($_REQUEST["month"]))
    140. 

  140. 	$month = $_REQUEST["month"];
    141. 

  141. else
    142. 

  142. 	$month = 1;
    143. 

  143. 	
    144. 

  144. if(isset($_REQUEST["day"]) && is_numeric($_REQUEST["day"]))
    145. 

  145. 	$day = $_REQUEST["day"];
    146. 

  146. else
    147. 

  147. 	$day = "";
    148. 

  148. 	
    149. 

  149. /*	
    150. 

  150. if ($year=="") {
    151. 

  151.  $year=2011;
    152. 

  152.  $month=1;
    153. 

  153.  if($year==2004) {
    154. 

  154.   $year=2005;
    155. 

  155.   $month=1;
    156. 

  156.   $day="";
    157. 

  157.  }
    158. 

  158. }
    159. 

  159. */
    160. 

  160. $dtCurrentDate = sprintf("%s/%s/%s",$month,$day,$year);
    161. 

  161. $CurrentYear = $year;
    162. 

  162. $CurrentMonth = $month;
    163. 

  163. $CurrentDay = $day;
    164. 

  164. 

  165. 

  166. echo "<table ALIGN='CENTER' BORDER='0' bgcolor= '#000000' CELLSPACING='0' WIDTH='80%'>";
    167. 

  167.  $iFirstWeekDay = getFirstWeekDay($year,$month,$day);
    168. 

  168.  $iDaysInMonth = getDaysInMonth($year,$month);
    169. 

  169.  $i=$iDaysInMonth+$iFirstWeekDay;
    170. 

  170.  for ($iLoop = $iFirstWeekDay; $iLoop < $i; $iLoop++)  {
    171. 

  171.   $aCalendarDays[$iLoop] = $iLoop+1-$iFirstWeekDay;
    172. 

  172.  }
    173. 

  173. 

  174. ?>
    175. 

  175. <STYLE TYPE="text/css">
    176. 

  176. BODY, TD {
    177. 

  177. 	font: 300 12px Verdana, Arial, sans-serif;
    178. 

  178. 	color: black;
    179. 

  179. }
    180. 

  180. .blueType {
    181. 

  181. 	color: #33F;
    182. 

  182. }
    183. 

  183. A:link {COLOR: #3366FF; TEXT-DECORATION: none}
    184. 

  184. A:visited {COLOR: #3366FF; TEXT-DECORATION: none}
    185. 

  185. A:hover {COLOR: #0000CC; TEXT-DECORATION: none}
    186. 

  186. .style1 {color: #3300FF}
    187. 

  187. .style2 {color: #0033FF}
    188. 

  188. </STYLE>
    189. 

  189. </head>
    190. 

  190. <body>
    191. 

  191. <table width="742" border="0" cellspacing="0" cellpadding="0">
    192. 

  192. <tr><td width="106">&nbsp;</td>
    193. 

  193. <td width="261"><img src="/booking/images/california_tours_logo/home153_64.gif" width="153" height="64" alt="California Tours"></td>
    194. 

  194. <td width="315" align="center"><h3><?php echo $year; ?> tours from <?php echo $myCities[$city]; ?></h3></td>
    195. 

  195. <td width="60">&nbsp;</td>
    196. 

  196. </tr>
    197. 

  197. </table>
    198. 

  198. <br>
    199. 

  199. <table width="768" border="0" cellspacing="0" cellpadding="0">
    200. 

  200. <tr align="center" valign="middle" bgcolor="#ffba3d">
    201. 

  201. <td width="31" height="13" bgcolor="#FFCC66"></td>
    202. 

  202. <td width="293" height="13" bgcolor="#FFCC66" align="left"></td>
    203. 

  203. <td width="351" height="13" bgcolor="#FFCC66" valign="middle" align="right"><a href="mailto:tours@california-tour.com"><img src="/booking/images/links_position/contact.gif" width="310" height="17" border="0" alt="California Tour"></a></td>
    204. 

  204. <td width="63" height="13" bgcolor="#FFCC66"></td>
    205. 

  205. </tr>
    206. 

  206. <tr align="center" valign="top">
    207. 

  207. <td colspan="5">
    208. 

  208. <table width="720" border="0" cellspacing="0" cellpadding="0">
    209. 

  209. <tr>
    210. 

  210. <td width="130" align="left" valign="top">
    211. 

  211. <table width="124" border="0" cellspacing="0" cellpadding="0">
    212. 

  212. <tr><td height="12" align="left" valign="top"><img src="/booking/images/spacer/120_10.gif" width="120" height="10"></td>
    213. 

  213. </tr>
    214. 

  214. <tr><td height="168" align="left" valign="top">
    215. 

  215. </td></tr></table></td>
    216. 

  216. <td width="485" align="left" valign="top">
    217. 

  217. <table width="477" border="0" cellspacing="0" cellpadding="0">
    218. 

  218. <tr><td width="8">&nbsp;</td>
    219. 

  219. <td align="left" valign="top">
    220. 

  220. <div align="center">
    221. 

  221. <br>
    222. 

  222. <font size="2" color="#006699"><strong>
    223. 

  223. <font face="Verdana, Arial, Helvetica, sans-serif" size="2">
    224. 

  224. Tours from 
    225. 

  225. <?php
    226. 

  226. echo $myCities[$city];
    227. 

  227. ?>
    228. 

  228. </strong></font>
    229. 

  229. </font>
    230. 

  230. <br />
    231. 

  231. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=1">jan</a>&nbsp;
    232. 

  232. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=2">feb</a>&nbsp;
    233. 

  233. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=3">mar</a>&nbsp;
    234. 

  234. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=4">apr</a>&nbsp;
    235. 

  235. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=5">may</a>&nbsp;
    236. 

  236. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=6">june</a>&nbsp;
    237. 

  237. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=7">july</a>&nbsp;
    238. 

  238. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=8">aug</a>&nbsp;
    239. 

  239. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=9">sept</a>&nbsp;
    240. 

  240. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=10">oct</a>&nbsp;
    241. 

  241. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=11">nov</a>&nbsp;
    242. 

  242. <a href="agent_calendar_by_year.php?city=<?php echo $city; ?>&year=<?php echo $year; ?>&month=12">dec</a>
    243. 

  243. </font>
    244. 

  244. 

  245. <br /><br />
    246. 

  246. <table width="565" cellspacing="0" cellpadding="0" style="border: 0px; padding: 2px;">
    247. 

  247. <tr bgcolor="#FFFFFF" align="center" valign="top">
    248. 

  248. <td colspan="7" height="19">
    249. 

  249. <font face="Verdana, Arial, Helvetica, sans-serif" color="#006699">
    250. 

  250. <strong><font size="2" color="#FF6600"><?php echo getMonthName($month); ?> <?php echo $year ?></font></strong>
    251. 

  251. </font>
    252. 

  252. </td></tr>
    253. 

  253. <!-- Display Days of the Week -->
    254. 

  254. <tr bgcolor="#006699" align="center" valign="middle">
    255. 

  255. <td width="80"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Sun</font></td>
    256. 

  256. <td width="80"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Mon</font></td>
    257. 

  257. <td width="80"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Tues</font></td>
    258. 

  258. <td width="80"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Wed</font></td>
    259. 

  259. <td width="80"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Thur</font></td>
    260. 

  260. <td width="83"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Fri</font></td>
    261. 

  261. <td width="82"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Sat</font></td></tr>
    262. 

  262. <!-- Display Calendar -->
    263. 

  263. <?php  for ($iDayBanner = 1; $iDayBanner <= $iColumns; $iDayBanner++) ?>
    264. 

  264. <tr align="center" valign="top">
    265. 

  265. <?php
    266. 

  266. $ImgIndex = 0;
    267. 

  267. $kk=0;
    268. 

  268. $dm=substr("000".$month,-2);
    269. 

  269. for ($i = 0; $i < 42; $i++) {
    270. 

  270.  $dd = $aCalendarDays[$i]+0;
    271. 

  271.  if ($dd == "") {
    272. 

  272.   echo"<TD BGCOLOR='WHITE' VALIGN= 'TOP' ALIGN='Left' style='width: 120px; height: 80px;'>&nbsp;</td>\n";
    273. 

  273.  } else {
    274. 

  274. //  $dd=($i-$iFirstWeekDay+1);
    275. 

  275.   $dd=substr("000".$dd,-2);
    276. 

  276.   echo"<TD BGCOLOR='WHITE' VALIGN= 'TOP' ALIGN='Left' id='tagada$dd' style='width: 120px; height: 80px;'>
    277. 

  277. <font face='arial'>".($dd+0)."<br />";
    278. 

  278.   $MonthName = getMonthName($month);
    279. 

  279.   $ShortYear = substr($year,2,2);
    280. 

  280.   $query = "SELECT SCHEDULEDTOUR_CODE, TOUR_ID
    281. 

  281. FROM SCHEDULEDTOUR
    282. 

  282. WHERE SCHEDULEDTOUR_CODE
    283. 

  283. LIKE  '%$dm$dd$ShortYear'
    284. 

  284. AND SCHEDULEDTOUR_CODE like '$city%'";
    285. 

  285. //  echo "<span style='font-size: 70%;'>$query</span><br />\n";
    286. 

  286.   $mysql_result = mysql_query($query);
    287. 

  287.   $totalnumrows = mysql_num_rows($mysql_result);
    288. 

  288.   if ($totalnumrows>0) {
    289. 

  289.    while ($row = mysql_fetch_array($mysql_result)) {
    290. 

  290.     $ScheduledTourCode = strtoupper($row[0]);
    291. 

  291.     $TourId = strtoupper($row[1]);
    292. 

  292.     $querytour = "SELECT * FROM TOUR WHERE TOUR_ID = '$TourId'";
    293. 

  293.     $mysql_result_tour = mysql_query($querytour);
    294. 

  294.     $rowtour = mysql_fetch_array($mysql_result_tour);
    295. 

  295.     $TourName = $rowtour[2];
    296. 

  296.     $ImgList = strtolower($rowtour[24]);
    297. 

  297.     if (strlen($ImgList) > 0) {
    298. 

  298.      $ImgListArray = explode(",",$ImgList);
    299. 

  299.      if ($ImgIndex >= count($ImgListArray)) {
    300. 

  300.       $ImgIndex = 0;
    301. 

  301.       $ThmImg = $ImgListArray[$ImgIndex];
    302. 

  302.      } else {
    303. 

  303.       $ThmImg = $ImgListArray[$ImgIndex];
    304. 

  304.       $ImgIndex = $ImgIndex+1;
    305. 

  305.      }
    306. 

  306.     }
    307. 

  307.     $SchedCodeLength = strlen($ScheduledTourCode);
    308. 

  308.     $ScheduledTourShortCode = substr($ScheduledTourCode,0,$SchedCodeLength - 2);
    309. 

  309.     $ScheduledTourShortCode = $ScheduledTourCode;
    310. 

  310.     $myURL="agenttoursignup.php?LocalScheduledTourCode=$ScheduledTourShortCode&languageUsed=$languageUsed&city=$city&year=$year&month=$month&day=$day&SchoolCode=$SchoolCode&UserName=$UserName";
    311. 

  311.     $ucTourName=$myTours[substr($ScheduledTourShortCode,0,4)];
    312. 

  312.     echo "\n<a href=\"$myURL\"><font face='arial' size='-1'>$ucTourName</font></a><br />\n";
    313. 

  313.    }
    314. 

  314.   }
    315. 

  315.   echo "</td>\n";
    316. 

  316.  }
    317. 

  317.  $kk+=1;
    318. 

  318.  if ($kk == 7) {
    319. 

  319.   $kk=0;
    320. 

  320.   echo "</tr>\n";
    321. 

  321.  }
    322. 

  322. }
    323. 

  323. ?>
    324. 

  324. 

  325. </table></table></table></table>
    326. 

  326. <center><FONT SIZE="1" FACE="Verdana, Arial, Helvetica, sans-serif" COLOR="#333333">Schedule subject to change.</FONT>
    327. 

  327. <br>
    328. 

  328. <br>
    329. 

  329. <hr width="99%">
    330. 

  330. </center>
    331. 

  331. </body></html>
    332. 

  332. 

  333. 

  334.