<?php


include "../phppsycorps/common_db.inc";
include "../phppsycorps/servlist.inc";
error_reporting(0);

///////////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 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, $allowSameTime;
     $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($allowSameTime==0)
              {
               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, auth_by_3rd, invoiced, CLprov) VALUES (NULL, $Date_in_func, $add_time, $Assmt1, '$tempuserPro', NULL, '$templocation', NULL, NULL,0,0,NULL)";
          mysql_query($query);
         $result=mysql_affected_rows();
         if(!$result) {error_message(sql_error());$return_zero=1;}
          }
     if($return_zero) {return 0;}
     else {return 1;}
     }
/////////////////
function add_appt_form()  {
 //global $_SESSION['userProid'];
 global $PHP_SELF, $add_weekly_appointments, $Profprovary, $Profession;
//if(!$_POST['user_Pro_id2'])
// {
//   echo "No treatment provider specified";
 // }
//else
//  {
?>
<BODY BGCOLOR="AADDFF"><font face="helvetica, verdana, arial, sansa">
 <CENTER><H3>Add appointment(s)!</H3></CENTER> </font>
 <CENTER>You can set your weekly schedule <A HREF=<?php echo $add_weekly_appointments; 
echo "?beginmark=";
echo $_GET['beginmark'];
?>>here</A></CENTER>
<FORM METHOD="POST" ACTION="<?php echo $PHP_SELF; ?>">
 <INPUT TYPE="HIDDEN" NAME="action" VALUE="added_appt">
   <DIV ALIGN="CENTER"><CENTER><TABLE BORDER="1" WIDTH="80%" BGCOLOR="SILVER">
     <TR>
       <TH WIDTH="40%" NOWRAP>Your ID</TH>
       <TD WIDTH="60%" COLSPAN="2"><INPUT TYPE="hidden" NAME="user_Pro_id2"
                                                                       VALUE="<?php echo $_SESSION['userProid'] ?>"
 	                                                                     ><?php echo $_SESSION['userProid'] ?></TD>
     </TR>

     <TR>
       <TH WIDTH="40%" NOWRAP>Location</TH>
       <TD WIDTH="60%" COLSPAN="2"><SELECT NAME="location_input" SIZE ="1">
         <?php echo "<OPTION VALUE=\"" . $Profprovary[0] . "\">" . $Profprovary[0] . "</OPTION>";
       echo "<OPTION VALUE=\"" . $Profprovary[1] . "\">" . $Profprovary[1] . "</OPTION>";
        echo "<OPTION VALUE=\"" . $Profprovary[2] . "\">" . $Profprovary[2] . "</OPTION>"; ?>
        </TD>
     </TR>
     <TR>
       <TH WIDTH="40%" NOWRAP>Time</TH>
       <TD WIDTH="30%"><SELECT NAME="time1" SIZE ="1">
         <OPTION VALUE="08">AM 8:</OPTION>
         <OPTION VALUE="09">AM 9:</OPTION>
         <OPTION VALUE="10">AM10:</OPTION>
         <OPTION VALUE="11">AM11:</OPTION>
         <OPTION VALUE="12">PM12:</OPTION>
         <OPTION VALUE="13">PM1:</OPTION>
         <OPTION VALUE="14">PM 2:</OPTION>
         <OPTION VALUE="15">PM 3:</OPTION>
         <OPTION VALUE="16">PM 4:</OPTION>
         <OPTION VALUE="17">PM 5:</OPTION>
         <OPTION VALUE="18">PM 6:</OPTION>
         <OPTION VALUE="19">PM 7:</OPTION>
         <OPTION VALUE="20">PM 8:</OPTION>
         <OPTION VALUE="21">PM 9:</OPTION>
         <OPTION VALUE="22">PM 10:</OPTION>
         <OPTION VALUE="23">PM 11:</OPTION>
         </SELECT>
         <SELECT NAME="time2" SIZE ="1">
         <OPTION VALUE="0000">00</OPTION>
         <OPTION VALUE="1500">15</OPTION>
         <OPTION VALUE="3000">30</OPTION>
         <OPTION VALUE="4500">45</OPTION>
         </SELECT> 
         <BR/>or select multiple appts below<BR/>
         <SELECT NAME="time3" SIZE ="1">
         <OPTION VALUE="none" SELECTED>one appt only</OPTION>
         <OPTION VALUE="8:00:00X4">4 appts starting 8 AM</OPTION>
         <OPTION VALUE="9:00:00X3">3 appts starting 9 AM</OPTION>
         <OPTION VALUE="13:00:00X3">3 appts starting 1 PM</OPTION>
         <OPTION VALUE="13:00:00X4">4 appts starting 1 PM</OPTION>
         </TD>
       <TD WIDTH="30%">
        <SELECT NAME="Assmt">
        <?php
        
        service_list($Profession);
        
         ?>
         </SELECT>
      </TD></TR>
  
     <TR><TH WIDTH="40%" NOWRAP>Date</TH>
              <TD WIDTH="60%" COLSPAN="2"><SELECT NAME="Date2" 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="Date3" 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="Date1" SIZE ="1">

      
         <OPTION VALUE="04">2004</OPTION>
         <OPTION VALUE="05">2005</OPTION>
         <OPTION VALUE="06">2006</OPTION>
         <OPTION VALUE="07">2007</OPTION>
         <OPTION VALUE="08">2008</OPTION>
         <OPTION VALUE="09">2009</OPTION>
         <OPTION VALUE="10">2010</OPTION>
         <OPTION VALUE="11">2011</OPTION>
         <OPTION VALUE="12">2012</OPTION>
         </SELECT>
         </TD> 
          </TR>  


       <TR><TH WIDTH="100%" ALIGN="CENTER" COLSPAN="3" NOWRAP>
        <INPUT TYPE="SUBMIT" VALUE="Submit">
         <INPUT TYPE="RESET" VALUE="Reset">
         <?php
         echo "<font face=\"helvetica, verdana, arial, sansa\" size=\"2\"><A HREF=\"./connect-pro.html?beginmark=";
echo $_GET['beginmark'];
echo "\">Go back to appts</A></font>";
          ?>
          </TH></TR>
     </TR>
   </TABLE></CENTER></DIV>
 </FORM></BODY>
<?php 
  }/////////////////////////////end of function


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

$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']=="session"){$Assmt1=0;}
         else if($_POST['Assmt']=="Voc"){$Assmt1=2;}
         else if($_POST['Assmt']=="Neuro"){$Assmt1=3;} 
         else if($_POST['Assmt']==4){$Assmt1=4;} 
         else if($_POST['Assmt']==5){$Assmt1=5;} 
         else {$Assmt1=$_POST['Assmt'];}
         $Date_in_func = $_POST['Date1'] . $_POST['Date2'] . $_POST['Date3'];
         $tempProid2 = $_POST['user_Pro_id2'];
         $temptimeforchecking = $_POST['time1'];
         
         $temptimeforchecking .= $_POST['time2'];
         if($allowSameTime==0)
         {
         $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['time1'] . $_POST['time2'];
         $query="INSERT INTO $apptdb (appt_id, day, time, Assmt, Agent_id, client_id, 
location, lastaccess, bill_to, auth_by_3rd, invoiced, CLprov) VALUES (NULL, $Date_in_func, $temptime, $Assmt1, '$tempuserPro', NULL, '$templocation', NULL, NULL,0,0,NULL)";
         
          mysql_query($query);
         $result=mysql_affected_rows($link_id);
         if(!$result) {error_message(sql_error());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, $apptdb,$moretime_ary;
// global $_POST['Assmt'];
echo "<HEAD><META name=\"robots\" content=\"noindex\">";
echo"</HEAD>";

$Profession=lookupprofession($_SESSION['userProid']);
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";}

///////check input here
 if($Profession=="Physiotherapist"){$allowSameTime=1;}
 else if($Profession=="Occupational Rehab Program"){$allowSameTime=1;}
 else if($Profession=="Pain Program"){$allowSameTime=1;}
 else if($Profession=="Work Conditioning Program"){$allowSameTime=1;}
 else if($Profession=="Medical Rehab Program"){$allowSameTime=1;}
 else if($Profession=="Day Spa"){$allowSameTime=1;}
 else if($Profession=="Dentist"){$allowSameTime=1;}
 else if($Profession=="Laser Surgery Clinic"){$allowSameTime=1;}
 else if($Profession=="Physician"){$allowSameTime=1;}
 else if($Profession=="Naturopath"){$allowSameTime=1;}
 else if($Profession=="Voc Rehab Consultant"){$allowSameTime=1;}
 else if($_POST['Assmt']==14){$allowSameTime=1;}
 else if($_POST['Assmt']==42){$allowSameTime=1;}
 else{$allowSameTime=0;}
if($_POST['action']=="added_appt")
{$temptime3=$_POST['time3'];
 if(empty($_POST['user_Pro_id2'])) error_message("Enter your user id.");
 $poass=array($_POST['Assmt']);
 $needtime=count(array_intersect($poass,$moretime_ary));
 if($needtime){
 if($temptime3 =="8:00:00X4") error_message("Cannot book hour assessments.");
 else if($temptime3 =="9:00:00X3") error_message("Cannot book hour assessments.");
 else if($temptime3 =="13:00:00X3") error_message("Cannot book hour assessments.");
 else if($temptime3 =="13:00:00X4") error_message("Cannot book hour assessments.");
}
 $result1=enter_new_appt();
 if(!$result1) echo "Didn't work. Check enter_new_appt";
 else echo "<H2>Appointment(s) booked! Use back button to book another!</H2>";
}
else {
add_appt_form();
}
echo "<font face=\"helvetica, verdana, arial, sansa\"><P><BR/><CENTER><H3><A HREF=\"./connect-pro.html?beginmark=";
echo $_GET['beginmark'];
echo "\">Click here to go back to your appointments</A></H3><CENTER></font>";
echo "<P ALIGN=\"CENTER\"><FONT SIZE=1>Appointment booking method Patent Pending</FONT></P>";
echo "<P><BR/><CENTER><A HREF=\"http://www.zappointments.com\">zappointments.com: online booking for health professionals</A><CENTER>
<BR/><CENTER><A HREF=\"http://www.zappointments.com\"><IMG SRC=\"https://www.zappointments.com/PSYIMAGES/zapbanner.gif89a\"></A><CENTER></P>";

?>