<?php

//incl common_db.inc
include "../phppsycorps/common_db.inc";
include "../phppsycorps/servlist.inc";
error_reporting(0);
$Moncolor="#112233";
$Tuescolor="#222233";
$Wedcolor="#222222";
$Thurscolor="#111111";
$Fricolor="#050505";
$Satcolor="#051111";
$Suncolor="#110515";
///////////functions////////////////
function lookupprofession($Proid)
{
global $Profprovary;
$link_id = db_connect();
if(!$link_id) die(sql_error());
if($_SESSION['userProprov']=="BC"){$servProdb="service_providers";}
else if($_SESSION['userProprov']=="AB"){$servProdb="service_providers_ab";}
else if($_SESSION['userProprov']=="SK"){$servProdb="service_providers_sk";}
else if($_SESSION['userProprov']=="MB"){$servProdb="service_providers_mb";}
else if($_SESSION['userProprov']=="ON"){$servProdb="service_providers_on";}
else if($_SESSION['userProprov']=="QC"){$servProdb="service_providers_qc";}
else if($_SESSION['userProprov']=="NS"){$servProdb="service_providers_ns";}
else if($_SESSION['userProprov']=="NB"){$servProdb="service_providers_nb";}
else if($_SESSION['userProprov']=="PE"){$servProdb="service_providers_pe";}
else if($_SESSION['userProprov']=="NL"){$servProdb="service_providers_nl";}
else if($_SESSION['userProprov']=="YK"){$servProdb="service_providers_yk";}
else if($_SESSION['userProprov']=="NW"){$servProdb="service_providers_nw";}
else if($_SESSION['userProprov']=="NV"){$servProdb="service_providers_nv";}
$Profquery="SELECT Pro_type, Procity, ProcityA, ProcityB FROM $servProdb WHERE Pro_id='$Proid'";
$Profresult=mysql_query($Profquery);
if(!$Profresult){error_message(sql_error());}
else {
        $Profarray=mysql_fetch_array($Profresult);
        $Profession=$Profarray['Pro_type'];
        $Procity=$Profarray['Procity'];
        $ProcityA=$Profarray['ProcityA'];
        $ProcityB=$Profarray['ProcityB'];
        $Profprovary=array($Procity,$ProcityA,$ProcityB);
        if($Profession==1){$Profession_type="Psychologist";}
        else if($Profession==2){$Profession_type="Physiotherapist";}
        else if($Profession==3){$Profession_type="Chiropractor";}
        else if($Profession==4){$Profession_type="Chinese Med Prac/Acupuncturist";}
        else if($Profession==5){$Profession_type="Occupational Therapist";}
        else if($Profession==6){$Profession_type="Occupational Rehab Program";}
        else if($Profession==7){$Profession_type="Pain Program";}
        else if($Profession==8){$Profession_type="Work Conditioning Program";}
        else if($Profession==9){$Profession_type="Massage Therapist";}
        else if($Profession==10){$Profession_type="Counsellor";}
        else if($Profession==11){$Profession_type="Medical Rehab Program";}
        else if($Profession==12){$Profession_type="Day Spa";}
        else if($Profession==13){$Profession_type="Dentist";}
        else if($Profession==14){$Profession_type="Laser Surgery Clinic";}
        else if($Profession==15){$Profession_type="Physician";}
        else if($Profession==16){$Profession_type="Naturopath";}
        else if($Profession==17){$Profession_type="Voc Rehab Consultant";}
        return $Profession_type;
       }
}
function eastr_date($Yeare) 
{
    $G = $Yeare % 19;
    $C = (int)($Yeare / 100);
    $H = (int)($C - ($C/4) - ((8 * $C+13)/25) + 19 * $G +15) % 30;
    $I = (int)$H - (int)($H/28) * (1 - (int)($H/28) * (int)(29/($H + 1))*((int)(21 - $G)/11));
    $J = ($Yeare + (int)($Yeare/4) + $I + 2 - $C + (int)($C/4)) % 7;
    $L = $I - $J;
    $m = 3 + (int)(($L + 40) / 44);
    $d = $L + 28 - 31 * ((int)($m/4));
    $y = $Yeare;
    $E = mktime(0,0,0, $m, $d, $y);
    return $E;    
}

function ordinalDay($ord, $day, $month, $year)
  {
  $firstOfMonth = strtotime("$year-$month-01");
  $lastOfMonth  = $firstOfMonth + date("t", $firstOfMonth) * 86400;
  $dayOccurs = 0;
	
  for ($i = $firstOfMonth; $i < $lastOfMonth ; $i += 86400)
     {
     if (date("D", $i) == $day)
       {
       $dayOccurs++;
       if ($dayOccurs == $ord)
         { $ordDay = $i; } 
       }
     }
  return $ordDay;
  }  /////////////////// End function ordinalDay()
  
function get_holidays($start_year, $end_year)
{
$years_subtracted=$end_year - $start_year;
$years_subtracted++;
//echo $years_subtracted;
$holidays=array();
$current_year=$start_year;
for($counter=0; $counter < $years_subtracted; $counter++)
   {
    $new_years=$current_year;
    $new_years .="-01-01";
    //echo $new_years;
    $holidays[]=$new_years;
    
    $eastertimestamp=eastr_date($current_year);
    $Easter=strftime("%Y-%m-%d" , $eastertimestamp);
    
    $holidays[]=$Easter;
    $EasterMonOff=$_POST['EasterMonOff'];
    if($EasterMonOff)
      {
      $eastertimestampM=$eastertimestamp + 86400;
      $EasterMon=strftime("%Y-%m-%d" , $eastertimestampM);
      $holidays[]=$EasterMon;
      }
    $eastertimestamp1 = $eastertimestamp - 172800;
    $GoodFriday=strftime("%Y-%m-%d" , $eastertimestamp1);
    //echo "<br/>Good Friday is ";
    //echo $GoodFriday;
    $holidays[]=$GoodFriday;
    /*
    Victoria Day 4th or 3rd Mon if < 24
    */
    $VictoriaMonts=ordinalDay(4, 'Mon', 5, $current_year);
    $dayFourthMon=strftime("%d",$VictoriaMonts);
    //echo $dayFourthMon;
    if($dayFourthMon > 24)
    {
    $VictoriaMonts=ordinalDay(3, 'Mon', 5, $current_year);
    }
    $VictoriaDay=strftime("%Y-%m-%d" , $VictoriaMonts);
    $holidays[]=$VictoriaDay;
    $July1=$current_year;
    $July1 .= "-07-01";
    $holidays[]=$July1;
    /*
    BC day
    */
    $BCDayts=ordinalDay(1, 'Mon', 8, $current_year);
    $BCDay=strftime("%Y-%m-%d" , $BCDayts);
    $holidays[]=$BCDay;
    $LabourDayts=ordinalDay(1, 'Mon', 9, $current_year);
    $LabourDay=strftime("%Y-%m-%d" , $LabourDayts);
    $holidays[]=$LabourDay;
    /*
    Thanksgiving
    */
    $Thanksgivingts=ordinalDay(2, 'Mon', 10, $current_year);
    $Thanksgiving=strftime("%Y-%m-%d" , $Thanksgivingts);
    $holidays[]=$Thanksgiving;
    /*
    Nov 11
    */
    $RemembranceDay=$current_year;
    $RemembranceDay .= "-11-11";
    $holidays[]=$RemembranceDay;
    /*
    Dec 25 26
*/
    $Christmas=$current_year;
    $Christmas .= "-12-25";
    $holidays[]=$Christmas;
    $BoxingDay=$current_year;
    $BoxingDay .= "-12-26";
    $holidays[]=$BoxingDay;
    $current_year++;
   }/////end of for loop
   
return $holidays;
}/////end function get_holidays

function appointment_input($day_of_week, $counter)
{
global $Profession, $Profprovary, $Moncolor, $Tuescolor, $Wedcolor, $Thurscolor, $Fricolor, $Satcolor, $Suncolor;
       echo "<TD WIDTH=\"25%\"";
       if($day_of_week=="Mon"){$backg=$Moncolor ;}
       else if($day_of_week=="Tues"){$backg=$Tuescolor ;}
       else if($day_of_week=="Wed"){$backg=$Wedcolor ;}
       else if($day_of_week=="Thu"){$backg=$Thurscolor ;}
       else if($day_of_week=="Fri"){$backg=$Fricolor ;}
       else if($day_of_week=="Sat"){$backg=$Satcolor ;}
       else if($day_of_week=="Sun"){$backg=$Suncolor ;}
       echo " BGCOLOR=\"$backg\"";
       echo ">";
       echo "Location ";
       echo "<SELECT NAME=\"" . $day_of_week . "location_input[]" . "\">";
    
        
       $Profp0=$Profprovary[0];
       $Profp1=$Profprovary[1];
       $Profp2=$Profprovary[2];
       echo "<OPTION VALUE=\"" . $Profp0 . "\">" . $Profp0 . "</OPTION>";
       echo "<OPTION VALUE=\"" . $Profp1 . "\">" . $Profp1 . "</OPTION>";
        echo "<OPTION VALUE=\"" . $Profp2 . "\">" . $Profp2 . "</OPTION>";
        
       echo "</SELECT>";
       
        echo "</TD>";
        echo "<TD WIDTH=\"25%\"";
        
       echo " BGCOLOR=\"" . $backg . "\"";
       echo ">";
       
       echo "<SELECT NAME=\"";
       echo $day_of_week;
        
        echo "time1[]\" SIZE=\"1";
        echo "\">";
        echo "<OPTION VALUE=\"99\">--:</OPTION>";
         echo "<OPTION VALUE=\"08\">AM 8:</OPTION>";
         echo "<OPTION VALUE=\"09\">AM 9:</OPTION>";
         echo "<OPTION VALUE=\"10\">AM10:</OPTION>";
         echo "<OPTION VALUE=\"11\">AM11:</OPTION>";
         echo "<OPTION VALUE=\"12\">PM12:</OPTION>";
         echo "<OPTION VALUE=\"13\">PM1:</OPTION>";
         echo "<OPTION VALUE=\"14\">PM 2:</OPTION>";
         echo "<OPTION VALUE=\"15\">PM 3:</OPTION>";
         echo "<OPTION VALUE=\"16\">PM 4:</OPTION>";
         echo "<OPTION VALUE=\"17\">PM 5:</OPTION>";
         echo "<OPTION VALUE=\"18\">PM 6:</OPTION>";
         echo "<OPTION VALUE=\"19\">PM 7:</OPTION>";
         echo "<OPTION VALUE=\"20\">PM 8:</OPTION>";
         echo "</SELECT>";
         echo "<SELECT NAME=\"";
         echo $day_of_week;
         echo "time2[]\" SIZE=\"1\">";
         echo "<OPTION VALUE=\"0000\">00</OPTION>";
         echo "<OPTION VALUE=\"0500\">05</OPTION>";
         echo "<OPTION VALUE=\"1000\">10</OPTION>";
         echo "<OPTION VALUE=\"1500\">15</OPTION>";
         echo "<OPTION VALUE=\"2000\">20</OPTION>";
         echo "<OPTION VALUE=\"2500\">25</OPTION>";
         echo "<OPTION VALUE=\"3000\">30</OPTION>";
         echo "<OPTION VALUE=\"3500\">35</OPTION>";
         echo "<OPTION VALUE=\"4000\">40</OPTION>";
         echo "<OPTION VALUE=\"4500\">45</OPTION>";
         echo "<OPTION VALUE=\"5000\">50</OPTION>";
         echo "<OPTION VALUE=\"5500\">55</OPTION>";
         echo "</SELECT>"; 
        
        echo "</TD>";
       
       echo "<TD WIDTH=\"25%\"";
       echo " BGCOLOR=\"" . $backg . "\"";
       echo ">";
        echo "<SELECT NAME=\"";
        echo $day_of_week;
        echo "Assmt[]\">";
        service_list($Profession);
        echo "</SELECT>";
       echo "<INPUT TYPE=\"hidden\" NAME=\"";
      echo $day_of_week;
      echo "k[]";
       echo "\" VALUE=\"";
       echo $counter;
      echo "\">";
      
       echo "</TD></TR><TR>";
     
}
function check_dupe_appointments($service_provider21, $day21, $time21)
{
global $dbhost, $apptdb;

$link_id = db_connect();
if(!$link_id) die(sql_error());

$query="SELECT appt_id, client_id, location, bill_to, lastaccess
              FROM $apptdb WHERE Agent_id = '$service_provider21' AND day = '$day21' AND
              time = '$time21'";
$result_id=mysql_query($query);
if(!mysql_num_rows($result_id)) {return 0;}////return zero if no prob
else {return 1;}////returns one if there is duplicate
}
//////////////////
function many_appts_one_day($start_time, $no_appts)
    {
    global $apptdb;
     //global $Date1, $Date2, $Date3;
     $Assmt1=0;
     $return_zero=0;
     $Date_in_func = $_POST['Date1'] . $_POST['Date2'] . $_POST['Date3'];
     for ($counter=0; $counter < $no_appts; $counter++)
         {
          $time_to_add0=$counter * 10000;
          $add_time0 = $start_time + $time_to_add0;
          //////check_dupe_appointments($_POST['user_Pro_id2'], $day, $time_to_add0);
          if( check_dupe_appointments($_POST['user_Pro_id2'], $Date_in_func, $add_time0)) error_message("Cannot book duplicate appointments.");///isnt working
          }
     for ($counter=0; $counter < $no_appts; $counter++)
         {
          $tempuserPro=$_POST['user_Pro_id2'];
          $time_to_add=$counter * 10000;
          $add_time = $start_time + $time_to_add;
          $templocation=$_POST['location_input'];
          $query="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, $Date_in_func, $add_time, $Assmt1, '$tempuserPro', NULL, '$templocation', NULL, NULL)";
          mysql_query($query);
         $result=mysql_affected_rows();
         if(!$result) {$return_zero=1;}
          }
     if($return_zero) {return 0;}
     else {return 1;}
     }
/////////////////
function add_appt_form()  {

 global $PHP_SELF, $Profession, $noApps, $Moncolor, $Tuescolor, $Wedcolor, $Thurscolor, $Fricolor, $Satcolor, $Suncolor;

?>

 <CENTER><H3>Set your regular appointments (or <a href="<?php echo $add_appointment; ?>">add one appointment at a time <u>here</u></a>)!<br/>
<font face="helvetica, verdana, arial, sansa"><BR/><CENTER><H3>
<?php
echo "<A HREF=\"./connect-pro.html?beginmark=";
echo $_GET['beginmark'];
echo "\">Click here to go back to your appointments</A></H3><CENTER></font>";
?>
</H3><br />If there are not enough slots, you can use this page a number of times and set groups of appointments each time (for example, mornings and then afternoons).</CENTER> 
<FORM METHOD="POST" ACTION="<?php echo $_SERVER['PHP_SELF']; ?>">
 <INPUT TYPE="HIDDEN" NAME="action" VALUE="added_appt">
   <CENTER><TABLE BORDER="1" WIDTH="95%" BGCOLOR="#111111">
     <TR>
       <TD WIDTH="25%" NOWRAP>Your ID</TD>
       <TD WIDTH="70%" COLSPAN="3"><INPUT TYPE="hidden" NAME="user_Pro_id2"
                                                                       VALUE="<?php echo $_SESSION['userProid']; ?>"
 	                                                                    > <?php echo $_SESSION['userProid']; ?> </TD>
     </TR>
     <TR><TD>Dates</TD>
     <TD WIDTH="75%" COLSPAN="3">  From <SELECT NAME="DateFrom2" SIZE="1">
         <OPTION VALUE="01">Jan</OPTION>
         <OPTION VALUE="02">Feb</OPTION>
         <OPTION VALUE="03">Mar</OPTION>
         <OPTION VALUE="04">Apr</OPTION>
         <OPTION VALUE="05">May</OPTION>
         <OPTION VALUE="06">June</OPTION>
         <OPTION VALUE="07">July</OPTION>
         <OPTION VALUE="08">Aug</OPTION>
         <OPTION VALUE="09">Sep</OPTION>
         <OPTION VALUE="10">Oct</OPTION>
         <OPTION VALUE="11">Nov</OPTION>
         <OPTION VALUE="12">Dec</OPTION>
         </SELECT>

          <SELECT NAME="DateFrom3" SIZE="1">
         <OPTION VALUE="01">01</OPTION>
         <OPTION VALUE="02">02</OPTION>
         <OPTION VALUE="03">03</OPTION>
         <OPTION VALUE="04">04</OPTION>
         <OPTION VALUE="05">05</OPTION>
         <OPTION VALUE="06">06</OPTION>
         <OPTION VALUE="07">07</OPTION>
         <OPTION VALUE="08">08</OPTION>
         <OPTION VALUE="09">09</OPTION>
         <OPTION VALUE="10">10</OPTION>
         <OPTION VALUE="11">11</OPTION>
         <OPTION VALUE="12">12</OPTION>
         <OPTION VALUE="13">13</OPTION>
         <OPTION VALUE="14">14</OPTION>
         <OPTION VALUE="15">15</OPTION>
         <OPTION VALUE="16">16</OPTION>
         <OPTION VALUE="17">17</OPTION>
         <OPTION VALUE="18">18</OPTION>
         <OPTION VALUE="19">19</OPTION>
         <OPTION VALUE="20">20</OPTION>
         <OPTION VALUE="21">21</OPTION>
         <OPTION VALUE="22">22</OPTION>
         <OPTION VALUE="23">23</OPTION>
         <OPTION VALUE="24">24</OPTION>
         <OPTION VALUE="25">25</OPTION>
         <OPTION VALUE="26">26</OPTION>
         <OPTION VALUE="27">27</OPTION>
         <OPTION VALUE="28">28</OPTION>
         <OPTION VALUE="29">29</OPTION>
         <OPTION VALUE="30">30</OPTION>
         <OPTION VALUE="31">31</OPTION>
         
         </SELECT>
          <SELECT NAME="DateFrom1" SIZE="1">

      
         <OPTION VALUE="2004">2004</OPTION>
         <OPTION VALUE="2005">2005</OPTION>
         <OPTION VALUE="2006">2006</OPTION>
         <OPTION VALUE="2007">2007</OPTION>
         <OPTION VALUE="2008">2008</OPTION>
                  <OPTION VALUE="2009">2009</OPTION>
          <OPTION VALUE="2010">2010</OPTION>
          <OPTION VALUE="2011">2011</OPTION>
          <OPTION VALUE="2012">2012</OPTION>
         </SELECT>
       
          to <SELECT NAME="DateTo2" SIZE="1">
         <OPTION VALUE="01">Jan</OPTION>
         <OPTION VALUE="02">Feb</OPTION>
         <OPTION VALUE="03">Mar</OPTION>
         <OPTION VALUE="04">Apr</OPTION>
         <OPTION VALUE="05">May</OPTION>
         <OPTION VALUE="06">June</OPTION>
         <OPTION VALUE="07">July</OPTION>
         <OPTION VALUE="08">Aug</OPTION>
         <OPTION VALUE="09">Sep</OPTION>
         <OPTION VALUE="10">Oct</OPTION>
         <OPTION VALUE="11">Nov</OPTION>
         <OPTION VALUE="12">Dec</OPTION>
         </SELECT>

          <SELECT NAME="DateTo3" SIZE="1">
         <OPTION VALUE="01">01</OPTION>
         <OPTION VALUE="02">02</OPTION>
         <OPTION VALUE="03">03</OPTION>
         <OPTION VALUE="04">04</OPTION>
         <OPTION VALUE="05">05</OPTION>
         <OPTION VALUE="06">06</OPTION>
         <OPTION VALUE="07">07</OPTION>
         <OPTION VALUE="08">08</OPTION>
         <OPTION VALUE="09">09</OPTION>
         <OPTION VALUE="10">10</OPTION>
         <OPTION VALUE="11">11</OPTION>
         <OPTION VALUE="12">12</OPTION>
         <OPTION VALUE="13">13</OPTION>
         <OPTION VALUE="14">14</OPTION>
         <OPTION VALUE="15">15</OPTION>
         <OPTION VALUE="16">16</OPTION>
         <OPTION VALUE="17">17</OPTION>
         <OPTION VALUE="18">18</OPTION>
         <OPTION VALUE="19">19</OPTION>
         <OPTION VALUE="20">20</OPTION>
         <OPTION VALUE="21">21</OPTION>
         <OPTION VALUE="22">22</OPTION>
         <OPTION VALUE="23">23</OPTION>
         <OPTION VALUE="24">24</OPTION>
         <OPTION VALUE="25">25</OPTION>
         <OPTION VALUE="26">26</OPTION>
         <OPTION VALUE="27">27</OPTION>
         <OPTION VALUE="28">28</OPTION>
         <OPTION VALUE="29">29</OPTION>
         <OPTION VALUE="30">30</OPTION>
         <OPTION VALUE="31">31</OPTION>
         
         </SELECT>
          <SELECT NAME="DateTo1" SIZE="1">

      
         <OPTION VALUE="2004">2004</OPTION>
         <OPTION VALUE="2005">2005</OPTION>
         <OPTION VALUE="2006">2006</OPTION>
         <OPTION VALUE="2007">2007</OPTION>
         <OPTION VALUE="2008">2008</OPTION>
                  <OPTION VALUE="2009">2009</OPTION>
          <OPTION VALUE="2010">2010</OPTION>
          <OPTION VALUE="2011">2011</OPTION>
          <OPTION VALUE="2012">2012</OPTION>
         </SELECT>
         </TD> 
     </TR>
     <TR>
       <TD COLSPAN="4"><CENTER>Give me Easter Monday off &nbsp;<INPUT TYPE="CHECKBOX" NAME="EasterMonOff"></CENTER>
       </TD>
     </TR>
     <?php 
     echo "<TR BGCOLOR=\"" . $Moncolor . "\">";
       echo "<TD ALIGN=\"CENTER\" WIDTH=\"25%\" NOWRAP ROWSPAN=\"" . $noApps . "\"><h2>Mondays</h2></TD>";
       for($counter=0; $counter < $noApps; $counter++)
       {
       appointment_input(Mon, $counter);
      }
       
       echo "<TR BGCOLOR=$Tuescolor>";
       echo "<TD ALIGN=\"CENTER\" WIDTH=\"25%\" NOWRAP ROWSPAN=\"" . $noApps . "\"><h2>Tuesdays</h2></TD>";
     
     for($counter=0; $counter < $noApps; $counter++)
       {
       appointment_input(Tues, $counter);
      }
          echo "<TR BGCOLOR=\"" . $Wedcolor . "\">";
       echo "<TD ALIGN=\"CENTER\" WIDTH=\"25%\" NOWRAP ROWSPAN=\"" . $noApps . "\"><h2>Wednesdays</h2></TD>";
     
     for($counter=0; $counter < $noApps; $counter++)
       {
       appointment_input(Wed, $counter);
      }
                echo "<TR BGCOLOR=\"" . $Thurscolor . "\">";
       echo "<TD ALIGN=\"CENTER\" WIDTH=\"25%\" NOWRAP ROWSPAN=\"" . $noApps .  "\"><h2>Thursdays</h2></TD>";
     
     for($counter=0; $counter < $noApps; $counter++)
       {
       appointment_input(Thu, $counter);
      }
                echo "<TR BGCOLOR=\"" . $Fricolor . "\">";
       echo "<TD ALIGN=\"CENTER\" WIDTH=\"25%\" NOWRAP ROWSPAN=\"" . $noApps . "\"><h2>Fridays</h2></TD>";
     
     for($counter=0; $counter < $noApps; $counter++)
       {
       appointment_input(Fri, $counter);
      }
                echo "<TR BGCOLOR=\"" . $Satcolor . "\">";
      echo "<TD ALIGN=\"CENTER\" WIDTH=\"25%\" NOWRAP ROWSPAN=\"" . $noApps . "\"><h2>Saturdays</h2></TD>";
     
     for($counter=0; $counter < $noApps; $counter++)
       {
       appointment_input(Sat, $counter);
      }
                    echo "<TR BGCOLOR=\"" . $Suncolor . "\">";
          echo "<TD ALIGN=\"CENTER\" WIDTH=\"25%\" NOWRAP ROWSPAN=\"" . $noApps . "\"><h2>Sundays</h2></TD>";
     
     for($counter=0; $counter < $noApps; $counter++)
       {
       appointment_input(Sun, $counter);
      }
          //echo "<TR>";
      ?>

       <nowrap><TD WIDTH="100%" ALIGN="CENTER" COLSPAN="4" NOWRAP>
        <INPUT TYPE="SUBMIT" VALUE="Submit">
        <INPUT TYPE="RESET" VALUE="Reset">
         <?php
         echo "<A HREF=\"./connect-pro.html?beginmark=";
echo $_GET['beginmark'];
echo "\">Back to appts</A><CENTER>";
          ?>
          
         </nowrap>
          </TD>
     </TR>
   </TABLE></CENTER>
 </FORM>
<?php 
  }/////////////////////////////end of function


function enter_new_appt()
{
global $dbhost, $apptdb;

$link_id = db_connect();
if(!$link_id) die(sql_error());

if ($_POST['time3']=="8:00:00X4")
       {
        $resultmany=many_appts_one_day('080000', 4);
        if(!$resultmany) {echo "no resultmany"; return 0;} 
        else return 1;
         }
else if ($_POST['time3']=="9:00:00X3")
       {
        $resultmany=many_appts_one_day('090000', 3);
        if(!$resultmany) {echo "no resultmany"; return 0;} 
        else return 1;
        }
else if ($_POST['time3']=="13:00:00X3")
       { $resultmany=many_appts_one_day('130000', 3);
        if(!$resultmany) {echo "no resultmany"; return 0;} 
        else return 1;}
else if ($_POST['time3']=="13:00:00X4")
       { $resultmany=many_appts_one_day('130000', 4);
        if(!$resultmany) {echo "no resultmany"; return 0;} 
        else return 1;}
else {
         if($_POST['Assmt']=="Assmt"){$Assmt1=1;} 
         else if($_POST['Assmt']=="Voc"){$Assmt1=2;}
         else if($_POST['Assmt']=="Neuro"){$Assmt1=3;} 
         else {$Assmt1=$_POST['Assmt'];}
         $Date_in_func = $_POST['Date1'] . $_POST['Date2'] . $_POST['Date3'];
         $tempProid2 = $_POST['user_Pro_id2'];
         if($Profession != "Physiotherapist")//////////////////CHANGE FOR CHECKING VARIABLE
          {
           $temptimeforchecking = $_POST['time1'];
           $temptimeforchecking .= $_POST['time2'];
           $checking = check_dupe_appointments($tempProid2, $Date_in_func, $temptimeforchecking);
           if($checking) {error_message("Cannot book duplicate appointments.");}
           }
         $tempuserPro=$_POST['user_Pro_id2'];
         $templocation=$_POST['location_input'];
         $temptime=$_POST['time'];
         $query="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, $Date_in_func, $temptime, $Assmt1, '$tempuserPro', NULL, '$templocation', NULL, NULL)";
          mysql_query($query);
         $result=mysql_affected_rows($link_id);
         if(!$result) {return 0;}
         else return 1;
        }
}

//////////body//////
session_start();
//session_register("user3id1");
//session_register("userCLid");
//session_register("userProid");

//$_SESSION['user3id1'];
//$_SESSION['userCLid'];
//$_SESSION['userProid1'];
 global $PHP_SELF, $Profprovary;
if(empty($_SESSION['userProprov']) || empty($_SESSION['userProid']))
{
error_message("No provider logged on");
}
else {
if(empty($_SESSION['userProprov']))
{
error_message("No provider logged on");
}
else if($_SESSION['userProprov']=="BC"){$apptdb="appointments";}
else if($_SESSION['userProprov']=="AB"){$apptdb="appointments_ab";}
else if($_SESSION['userProprov']=="SK"){$apptdb="appointments_sk";}
else if($_SESSION['userProprov']=="MB"){$apptdb="appointments_mb";}
else if($_SESSION['userProprov']=="ON"){$apptdb="appointments_on";}
else if($_SESSION['userProprov']=="QC"){$apptdb="appointments_qc";}
else if($_SESSION['userProprov']=="NS"){$apptdb="appointments_ns";}
else if($_SESSION['userProprov']=="NB"){$apptdb="appointments_nb";}
else if($_SESSION['userProprov']=="PE"){$apptdb="appointments_pe";}
else if($_SESSION['userProprov']=="NL"){$apptdb="appointments_nl";}
else if($_SESSION['userProprov']=="YK"){$apptdb="appointments_yk";}
else if($_SESSION['userProprov']=="NW"){$apptdb="appointments_nw";}
else if($_SESSION['userProprov']=="NV"){$apptdb="appointments_nv";}
 

$Profession=lookupprofession($_SESSION['userProid']);//

 $noApps=12;
 if($Profession=="Physiotherapist"){$noApps=35;$allowSameTime=1;}
 else if($Profession=="Occupational Rehab Program"){$noApps=16;$allowSameTime=1;}
 else if($Profession=="Pain Program"){$noApps=12;$allowSameTime=1;}
 else if($Profession=="Work Conditioning Program"){$noApps=25;$allowSameTime=1;}
 else if($Profession=="Medical Rehab Program"){$noApps=16;$allowSameTime=1;}
 else if($Profession=="Day Spa"){$noApps=35;$allowSameTime=1;}
 else if($Profession=="Laser Surgery Clinic"){$noApps=25;$allowSameTime=1;}
 else if($Profession=="Physician"){$noApps=35;$allowSameTime=1;}
 else if($Profession=="Naturopath"){$noApps=25;$allowSameTime=1;}
 else if($Profession=="Voc Rehab Consultant"){$noApps=15;$allowSameTime=1;}
 else{$allowSameTime=0;}
// global $_POST['Assmt'];

// echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">";
echo "<HTML><HEAD><META name=\"robots\" content=\"noindex\">";
echo"</HEAD>";
   echo "<BODY BGCOLOR=\"#000000\" text=\"#FFFFFF\" link=\"#AAFFFF\" vlink=\"#99A5A8\" alink=\"#99A5A8\" leftmargin=\"0\" topmargin=\"0\" marginheight=\"0\" marginwidth=\"0\">";
echo "<P ALIGN=\"CENTER\"><FONT face=\"Arial, Helvetica, sans-serif\" SIZE=1>Appointment booking method Patent Pending</FONT>";
echo "&nbsp; &nbsp; &nbsp; <FONT face=\"Arial, Helvetica, sans-serif\" SIZE=\"2\"><A HREF=\"$logout_script\">LOGOUT</A></P>";

echo "<style> <!-- a:hover{color:FF2200; } --> </style>";
//echo "<style> <!-- a{text-decoration:none;} --> </style>";
echo "<BR/>";
echo "<P><CENTER><H2>This page will take some time to load</H2></CENTER></P>";
echo "<P><CENTER><A HREF=\"https://www.zappointments.com\">Back to zappointments.com home page</CENTER></A></P>";
echo "<P><CENTER><A HREF=\"$root_page\"><IMG SRC=\"./PSYIMAGES/zaphome.gif89a\"></A></CENTER></P>";

if($_POST['action']=="added_appt")
{
$DateFrom=$_POST['DateFrom1'] . "-" . $_POST['DateFrom2'] . "-" . $_POST['DateFrom3'];
$DateTo=$_POST['DateTo1'] . "-" . $_POST['DateTo2'] . "-" . $_POST['DateTo3'];
$start_day=strtotime($DateFrom);
$end_day=strtotime($DateTo);
 $start_day_of_week = date( "D", $start_day);
 if($start_day_of_week=='Mon'){$day_of_week_no=1;}
  if($start_day_of_week=='Tue'){$day_of_week_no=2;}
   if($start_day_of_week=='Wed'){$day_of_week_no=3;}
    if($start_day_of_week=='Thu'){$day_of_week_no=4;}
     if($start_day_of_week=='Fri'){$day_of_week_no=5;}
      if($start_day_of_week=='Sat'){$day_of_week_no=6;}
       if($start_day_of_week=='Sun'){$day_of_week_no=7;}
  $yearone=$_POST['DateFrom1'];
  $yearlast=$_POST['DateTo1'];
  $holidays=get_holidays($yearone,$yearlast);
  $num_of_appts_booked=0;
   /*while(list(,$holiday_date)=each($holidays))
     {
      echo $holiday_date;
      echo "<br/>";
     }*/
 $tempuserPro=$_POST['user_Pro_id2'];
 $Date_of_appts=$DateFrom;
 $currentday=$start_day;
 $dayflag=0;
 $link_id = db_connect();
if(!$link_id) die(sql_error());
$Date_of_appts_array=array($Date_of_appts);
$end_day += 82800;
 while($currentday <= $end_day)
 {
 $Date_of_appts_array=array($Date_of_appts);
 $intersect_array=array_intersect($holidays, $Date_of_appts_array);
 //echo "Intersect array is ";
 //echo $intersect_array;
 if(count($intersect_array)==0)
 {
 $Date_of_appts_array=array($Date_of_appts);
 //echo "currentday is " . $currentday . " end_day is " . $end_day;
 if($day_of_week_no==1){$dayflag=1;}
 if(($dayflag==1)&&($day_of_week_no==1))
   {
    for($counting=0; $counting < $noApps; $counting++)  
      {
      $arrayMontime1=$_POST['Montime1'];
      $arrayMontime2=$_POST['Montime2'];
      $arrayMonAssmt=$_POST['MonAssmt'];
      $arrayMonlocation=$_POST['Monlocation_input'];
       if($arrayMontime1[$counting]!='99')
           {
           $Montime=$arrayMontime1[$counting] . $arrayMontime2[$counting];
            $MonAssmt=$arrayMonAssmt[$counting];
            if($MonAssmt==14){$allowSameTime2=1;}
            else if($MonAssmt==42){$allowSameTime2=1;}
            else {$allowSameTime2=0;}
          $templocation=$arrayMonlocation[$counting];
          if(($allowSameTime==0) && ($allowSameTime2==0))
          {
          $Monquerypre="SELECT * FROM $apptdb where ((day='$Date_of_appts' && time='$Montime') && Agent_id='$tempuserPro')";
          $Monresultpre=mysql_query($Monquerypre);
          $Monresultpre1=mysql_num_rows($Monresultpre);
          } else {$Monresultpre1=0;}
          if($Monresultpre1==0)
              {
              $Monquery="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, '$Date_of_appts', '$Montime', '$MonAssmt', '$tempuserPro', NULL, '$templocation', NULL, NULL)";
              $nowresult=mysql_query($Monquery);
             if(!$nowresult) {echo "Error at ". $Montime . " on " . $Date_of_appts . "<br/>";}
             else {$num_of_appts_booked++;}
             }else{echo "Already had an appointment at " . $Montime . " on " . $Date_of_appts . "<BR/>";}
           }
      }
   }
if($day_of_week_no==2){$dayflag=1;} 
 if(($dayflag==1)&&($day_of_week_no==2))
 {   
    for($counting=0; $counting < $noApps; $counting++)  
       {
        $arrayTuestime1=$_POST['Tuestime1'];
        $arrayTuestime2=$_POST['Tuestime2'];
        $arrayTuesAssmt=$_POST['TuesAssmt'];
        $arrayTueslocation=$_POST['Tueslocation_input'];
         if($arrayTuestime1[$counting]!='99')
           {
           $Tuestime=$arrayTuestime1[$counting] . $arrayTuestime2[$counting];
            $TuesAssmt=$arrayTuesAssmt[$counting];
            if($TuesAssmt==14){$allowSameTime2=1;}
            else if($TuesAssmt==42){$allowSameTime2=1;}
            else {$allowSameTime2=0;}
          $templocation=$arrayTueslocation[$counting];
         if(($allowSameTime==0) && ($allowSameTime2==0))
          {
        $Tuesquerypre="SELECT * FROM $apptdb where ((day='$Date_of_appts' && time='$Tuestime') && Agent_id='$tempuserPro')";
          $Tuesresultpre=mysql_query($Tuesquerypre);
          $Tuesresultpre1=mysql_num_rows($Tuesresultpre);
          } else {$Tuesresultpre1=0;}
          if($Tuesresultpre1==0)
                {
                 $Tuesquery="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, '$Date_of_appts', '$Tuestime', '$TuesAssmt', '$tempuserPro', NULL, '$templocation', NULL, NULL)";
                 $nowresult=mysql_query($Tuesquery);
             if(!$nowresult) {echo "Error at ". $Tuestime . " on " . $Date_of_appts . "<br/>";}
              else {$num_of_appts_booked++;}
                }else{echo "Already had an appointment at " . $Tuestime . " on " . $Date_of_appts . "<BR/>";}
            }   
         }
  }   
  if($day_of_week_no==3){$dayflag=1;} 
 if(($dayflag==1)&&($day_of_week_no==3))
 {   
    for($counting=0; $counting < $noApps; $counting++)  
       {
        $arrayWedtime1=$_POST['Wedtime1'];
        $arrayWedtime2=$_POST['Wedtime2'];
        $arrayWedAssmt=$_POST['WedAssmt'];
        $arrayWedlocation=$_POST['Wedlocation_input'];
         if($arrayWedtime1[$counting]!='99')
           {
            $Wedtime=$arrayWedtime1[$counting] . $arrayWedtime2[$counting];$WedAssmt=$arrayWedAssmt[$counting];
            
            if($WedAssmt==14){$allowSameTime2=1;}
            else if($WedAssmt==42){$allowSameTime2=1;}
            else {$allowSameTime2=0;}
           $templocation=$arrayWedlocation[$counting];
          if(($allowSameTime==0) && ($allowSameTime2==0))
          {
           $Wedquerypre="SELECT * FROM $apptdb where ((day='$Date_of_appts' && time='$Wedtime') && Agent_id='$tempuserPro')";
          $Wedresultpre=mysql_query($Wedquerypre);
          $Wedresultpre1=mysql_num_rows($Wedresultpre);
          } else {$Wedresultpre1=0;}
          if($Wedresultpre1==0)
                {$Wedquery="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, '$Date_of_appts', '$Wedtime', '$WedAssmt', '$tempuserPro', NULL, '$templocation', NULL, NULL)";
            $nowresult=mysql_query($Wedquery);
             if(!$nowresult) {echo "Error at ". $Wedtime . " on " . $Date_of_appts . "<br/>";}
              else {$num_of_appts_booked++;}
             }else{echo "Already had an appointment at " . $Wedtime . " on " . $Date_of_appts . "<BR/>";}
          } 
      }
 }
    if($day_of_week_no==4){$dayflag=1;} 
 if(($dayflag==1)&&($day_of_week_no==4))
 {   
    for($counting=0; $counting < $noApps; $counting++)  
       {
        $arrayThutime1=$_POST['Thutime1'];
        $arrayThutime2=$_POST['Thutime2'];
        $arrayThuAssmt=$_POST['ThuAssmt'];
        $arrayThulocation=$_POST['Thulocation_input'];
         if($arrayThutime1[$counting]!='99')
           {
            $Thutime=$arrayThutime1[$counting] . $arrayThutime2[$counting];$ThuAssmt=$arrayThuAssmt[$counting];
            if($ThuAssmt==14){$allowSameTime2=1;}
            else if($ThuAssmt==42){$allowSameTime2=1;}
            else {$allowSameTime2=0;}
           $templocation=$arrayThulocation[$counting];
          if(($allowSameTime==0) && ($allowSameTime2==0))
          {
            $Thuquerypre="SELECT * FROM $apptdb where ((day='$Date_of_appts' && time='$Thutime') && Agent_id='$tempuserPro')";
          $Thuresultpre=mysql_query($Thuquerypre);
          $Thuresultpre1=mysql_num_rows($Thuresultpre);
          } else{$Thuresultpre1=0;}
          if($Thuresultpre1==0)
                {$Thuquery="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, '$Date_of_appts', '$Thutime', '$ThuAssmt', '$tempuserPro', NULL, '$templocation', NULL, NULL)";
            $nowresult=mysql_query($Thuquery);
             if(!$nowresult) {echo "Error at ". $Thutime . " on " . $Date_of_appts . "<br/>";}
              else {$num_of_appts_booked++;}
            }else{echo "Already had an appointment at " . $Thutime . " on " . $Date_of_appts . "<BR/>";}
          } 
      }
  }
      if($day_of_week_no==5){$dayflag=1;} 
 if(($dayflag==1)&&($day_of_week_no==5))
 {   
    for($counting=0; $counting < $noApps; $counting++)  
       {
        $arrayFritime1=$_POST['Fritime1'];
        $arrayFritime2=$_POST['Fritime2'];
        $arrayFriAssmt=$_POST['FriAssmt'];
        $arrayFrilocation=$_POST['Frilocation_input'];
         if($arrayFritime1[$counting]!='99')
           {
            $Fritime=$arrayFritime1[$counting] . $arrayFritime2[$counting];$FriAssmt=$arrayFriAssmt[$counting];
            if($FriAssmt==14){$allowSameTime2=1;}
            else if($FriAssmt==42){$allowSameTime2=1;}
            else {$allowSameTime2=0;}
           $templocation=$arrayFrilocation[$counting];
          if(($allowSameTime==0) && ($allowSameTime2==0))
          {
           $Friquerypre="SELECT * FROM $apptdb where ((day='$Date_of_appts' && time='$Fritime') && Agent_id='$tempuserPro')";
          $Friresultpre=mysql_query($Friquerypre);
          $Friresultpre1=mysql_num_rows($Friresultpre);
          } else {$Friresultpre1=0;}
          if($Friresultpre1==0)
                {$Friquery="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, '$Date_of_appts', '$Fritime', '$FriAssmt', '$tempuserPro', NULL, '$templocation', NULL, NULL)";
            $nowresult=mysql_query($Friquery);
             if(!$nowresult) {echo "Error at ". $Fritime . " on " . $Date_of_appts . "<br/>";}
             else {$num_of_appts_booked++;}
            }else{echo "Already had an appointment at " . $Fritime . " on " . $Date_of_appts . "<BR/>";}
         } 
      }
  }

          if($day_of_week_no==6){$dayflag=1;} 
 if(($dayflag==1)&&($day_of_week_no==6))
 {   
    for($counting=0; $counting < $noApps; $counting++)  
       {
        $arraySattime1=$_POST['Sattime1'];
        $arraySattime2=$_POST['Sattime2'];
        $arraySatAssmt=$_POST['SatAssmt'];
        $arraySatlocation=$_POST['Satlocation_input'];
         if($arraySattime1[$counting]!='99')
           {
            $Sattime=$arraySattime1[$counting] . $arraySattime2[$counting];$SatAssmt=$arraySatAssmt[$counting];
            if($SatAssmt==14){$allowSameTime2=1;}
            else if($SatAssmt==42){$allowSameTime2=1;}
            else {$allowSameTime2=0;}
           $templocation=$arraySatlocation[$counting];
          if(($allowSameTime==0) && ($allowSameTime2==0))
          {
           $Satquerypre="SELECT * FROM $apptdb where ((day='$Date_of_appts' && time='$Sattime') && Agent_id='$tempuserPro')";
          $Satresultpre=mysql_query($Satquerypre);
          $Satresultpre1=mysql_num_rows($Satresultpre);
          } else {$Satresultpre1=0;}
          if($Satresultpre1==0)
                {$Satquery="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, '$Date_of_appts', '$Sattime', '$SatAssmt', '$tempuserPro', NULL, '$templocation', NULL, NULL)";
            $nowresult=mysql_query($Satquery);
             if(!$nowresult) {echo "Error at ". $Sattime . " on " . $Date_of_appts . "<br/>";}
              else {$num_of_appts_booked++;}
            }else{echo "Already had an appointment at " . $Sattime . " on " . $Date_of_appts . "<BR/>";}
         } 
      }
  }
          if($day_of_week_no==7){$dayflag=1;} 
 if(($dayflag==1)&&($day_of_week_no==7))
 {   
    for($counting=0; $counting < $noApps; $counting++)  
       {
        $arraySuntime1=$_POST['Suntime1'];
        $arraySuntime2=$_POST['Suntime2'];
        $arraySunAssmt=$_POST['SunAssmt'];
        $arraySunlocation=$_POST['Sunlocation_input'];
         if($arraySuntime1[$counting]!='99')
           {
            $Suntime=$arraySuntime1[$counting] . $arraySuntime2[$counting];$SunAssmt=$arraySunAssmt[$counting];
            if($SunAssmt==14){$allowSameTime2=1;}
            else if($SunAssmt==42){$allowSameTime2=1;}
            else {$allowSameTime2=0;}
           $templocation=$arraySunlocation[$counting];
          if(($allowSameTime==0) && ($allowSameTime2==0))
          {
           $Sunquerypre="SELECT * FROM $apptdb where ((day='$Date_of_appts' && time='$Suntime') && Agent_id='$tempuserPro')";
          $Sunresultpre=mysql_query($Sunquerypre);
          $Sunresultpre1=mysql_num_rows($Sunresultpre);
          } else {$Sunresultpre1=0;}
          if($Sunresultpre1==0)
                {$Sunquery="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to) VALUES (NULL, '$Date_of_appts', '$Suntime', '$SunAssmt', '$tempuserPro', NULL, '$templocation', NULL, NULL)";
            $nowresult=mysql_query($Sunquery);
             if(!$nowresult) {echo "Error at ". $Suntime . " on " . $Date_of_appts . "<br/>";}
              else {$num_of_appts_booked++;}
            }else{echo "Already had an appointment at " . $Suntime . " on " . $Date_of_appts . "<BR/>";}
         } 
      }
   }//////end of if
  
   }///////end of big if
    else{
   echo "<br/>Skipped holiday on " . $Date_of_appts;
   }
     $currentday=strtotime($Date_of_appts);
     $dalightbefore = date('I', $currentday);
     $currentday += 86400;  ////this is one day
     $dalightafter = date('I', $currentday);
     if($dalightbefore - $dalightafter == 1) {$currentday += 3600;}
     if($dalightbefore - $dalightafter == -1) {$currentday -=3600;}
     $Date_of_appts = strftime("%Y-%m-%d", $currentday);
     if($day_of_week_no < 7){$day_of_week_no++;}
     else{$day_of_week_no=1;}
     //echo "day of week number is " . $day_of_week_no;
     
 }///////end of while
 echo "<H2>";echo $num_of_appts_booked . " empty appointment(s) set! Use back button to set more!</H2>";
 //$result1=enter_new_appt();
 
}
else {
add_appt_form();
}
}///end of else
echo "<P ALIGN=\"CENTER\"><FONT SIZE=1>Appointment booking method Patent Pending</FONT></P>";
echo "<P><BR/><CENTER><A HREF=\"https://www.zappointments.com\">zappointments.com: online booking for health professionals</A><CENTER>
<BR/><CENTER><A HREF=\"https://www.zappointments.com\"><IMG SRC=\"https://www.zappointments.com/PSYIMAGES/zapbanner.gif89a\"></A><CENTER></P>";
echo "</BODY></HTML>";
?>