<?php
header("Expires: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Cache-Control: post-check=0, pre-check=0");

include "../phppsycorps/common_db.inc";
include "../phppsycorps/servlist.inc";
include "../phppsycorps/servlist2.inc";
error_reporting(0);
function lookupprofession($Proid)
{
global $Profprovary;
$link_id = db_connect("appointments_db");
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";}
        return $Profession_type;
       }
}
session_start();
if(empty($_SESSION['userProprov'])){error_message("Cannot read province. Log out and then log back in, please!");}
else if($_SESSION['userProprov']=="BC"){$apptdb="appointments";$vendornodb="vendor_nos";$pro_ratedb="pro_rate";}
else if($_SESSION['userProprov']=="AB"){$apptdb="appointments_ab";$vendornodb="vendor_nos_ab";$pro_ratedb="pro_rate_ab";}
else if($_SESSION['userProprov']=="SK"){$apptdb="appointments_sk";$vendornodb="vendor_nos_sk";$pro_ratedb="pro_rate_sk";}
else if($_SESSION['userProprov']=="MB"){$apptdb="appointments_mb";$vendornodb="vendor_nos_mb";$pro_ratedb="pro_rate_mb";}
else if($_SESSION['userProprov']=="ON"){$apptdb="appointments_on";$vendornodb="vendor_nos_on";$pro_ratedb="pro_rate_on";}
else if($_SESSION['userProprov']=="QC"){$apptdb="appointments_qc";$vendornodb="vendor_nos_qc";$pro_ratedb="pro_rate_qc";}
else if($_SESSION['userProprov']=="NS"){$apptdb="appointments_ns";$vendornodb="vendor_nos_ns";$pro_ratedb="pro_rate_ns";}
else if($_SESSION['userProprov']=="NB"){$apptdb="appointments_nb";$vendornodb="vendor_nos_nb";$pro_ratedb="pro_rate_nb";}
else if($_SESSION['userProprov']=="PE"){$apptdb="appointments_pe";$vendornodb="vendor_nos_pe";$pro_ratedb="pro_rate_pe";}
else if($_SESSION['userProprov']=="NL"){$apptdb="appointments_nl";$vendornodb="vendor_nos_nl";$pro_ratedb="pro_rate_nl";}
else if($_SESSION['userProprov']=="YK"){$apptdb="appointments_yk";$vendornodb="vendor_nos_yk";$pro_ratedb="pro_rate_yk";}
else if($_SESSION['userProprov']=="NW"){$apptdb="appointments_nw";$vendornodb="vendor_nos_nw";$pro_ratedb="pro_rate_nw";}
else if($_SESSION['userProprov']=="NV"){$apptdb="appointments_nv";$vendornodb="vendor_nos_nv";$pro_ratedb="pro_rate_nv";}
echo "<html><head><title>Change your rates</title></head><body>";
echo "<center><h2>Change your default rates</h2></center>";
$provider=$_SESSION['userProid'];
$ProType=lookupprofession($provider);
$link_id = db_connect("appointments_db");

if($_POST)
{
   $actione=$_POST['action'];
   switch($actione)
      {
      case $actione=="change":
           while(list($akey, $avalue)=each($HTTP_POST_VARS))
              {
              if($akey=='action'){}
              else
                   {
                   $akey=str_replace('service','', $akey);
                   $achangin_q="UPDATE $pro_ratedb set price='$avalue' where Pro_id='$provider' and Assmt='$akey'";
                   $achangin_r=mysql_query($achangin_q);
                   }
              }
          
          break;
      case $actione=="add":
            $nameOfService=$_POST['addserv'];
            $prixOfService=number_format($_POST['servprix'],2,'.','');
            $achangin_chk="SELECT price FROM $pro_ratedb WHERE Pro_id='$provider' AND Assmt=$nameOfService";
            $achangin_rchk=mysql_query($achangin_chk);
            $achangin_rows=mysql_num_rows($achangin_rchk);
            
            if($achangin_rows != 0){echo "<font color=\"red\"><center>You already have a default price for that service, please try using the change rates form.</center></font>";}
            else 
            {
            $achangin_q="INSERT INTO $pro_ratedb (Pro_id, Assmt, price) VALUES('$provider', $nameOfService, '$prixOfService')";
            $achangin_r=mysql_query($achangin_q);
            }
            
          break;
      }
     // autoreload();
}
echo "<center><form action=\"$PHP_SELF\" method=\"post\"><table width=\"50%\" bgcolor=\"silver\">";
echo "<input type=\"hidden\" name=\"action\" value=\"change\">";
  $queryprorate = "SELECT Assmt, price FROM $pro_ratedb WHERE Pro_id='$provider'";
  $resultprorate = mysql_query($queryprorate);
  while(list($key, $value)=mysql_fetch_array($resultprorate))
    {
     echo "<tr><td align=\"center\">";
     echo service_list3($key);
     echo "</td><td align=\"center\">";
     echo "<input type=\"text\" name=\"service" . $key . "\" value=\"" . $value . "\"></td></tr>";
    }
 echo "<tr><td colspan=2 align=\"center\"><input type=\"submit\" value=\"change rates\"></td></tr>";
echo "</table></form></center>";

echo "<center><h2>Add a default rate</h2></center>";
echo "<center><form action=\"$PHP_SELF\" method=\"post\"><table width=\"50%\" bgcolor=\"silver\">";
echo "<input type=\"hidden\" name=\"action\" value=\"add\">";
echo "<tr><td><select name=\"addserv\">";
service_list($ProType);
echo "</select>";
echo "</td><td>";
echo "<input type=\"text\" name=\"servprix\">";
echo "</td></tr>";
echo "<tr><td colspan=2 align=\"center\"><input type=\"submit\" value=\"add default rate\"></td></tr>";
echo "</table></form></center>";
echo "</table></form></center>";
echo "</body></html>";
?>