myguel99
Power Member
Boa noite trago aqui mais uma duvida que me surgiu em um projeto.
Basicamente tenho um plugin em php de uma clínica e preciso de aplicar uma condição na agenda.
Pretende que quando for marcada uma consulta a determinado dia e hora, seja feita uma verificação se nessa data o medico ou a sala estão ocupados.
segue o template:
class appointment
obrigado.
Basicamente tenho um plugin em php de uma clínica e preciso de aplicar uma condição na agenda.
Pretende que quando for marcada uma consulta a determinado dia e hora, seja feita uma verificação se nessa data o medico ou a sala estão ocupados.
segue o template:
PHP:
<?php
$appointment_data = $obj_hospital->appointmentGRL;
$appointment_array = array ();
if (! empty ( $appointment_data )) {
foreach ( $appointment_data as $appointment ) {
$consulta=$appointment->appointment_id;
$trat=$appointment->tratamento;
if($appointment->patient_id>0){
$patient_data = get_user_detail_byid($appointment->patient_id);
//$patient_name = $patient_data['first_name']." ".$patient_data['last_name']."(".$patient_data['patient_id'].")";
$patient_name = $patient_data['first_name']." ".$patient_data['last_name']; // add by Rui
}else{
$patient_name = "";
}
$doctor_data = get_user_detail_byid($appointment->doctor_id);
$doctor_name = $doctor_data['first_name']." ".$doctor_data['last_name'];
$sala_name = ($appointment->sala_id);
if($sala_name==1) $sala_cor="#de6461";
elseif($sala_name==2) $sala_cor="#6ccd97";
elseif($sala_name==3) $sala_cor="#3a87ad";
elseif($sala_name==4) $sala_cor="#feda50";
elseif($sala_name==5) $sala_cor="#6b5136";
$conteudo= " S: ".$sala_name;
if($patient_name!=""){
$conteudo.= " P: ".$patient_name;
}
if($appointment->doctor_id>0){
$conteudo.= " D: ".$doctor_name;
}
if($trat!=""){
$conteudo.= " T: ".$trat;
}
$appointment_start_date=date('Y-m-d H:i:s',strtotime($appointment->appointment_time_string));
$appointment_enddate = date('Y-m-d H:i:s',strtotime($appointment_start_date) + 900);
$i=1;
/*
if (isset($appointment_array[$appointment->appointment_time_string])) {
if (isset($appointment_array[$appointment->sala_id])) {
if (isset($appointment_array[$appointment->doctor_id])){
echo"dd";
}
}
}
else {
//
} testes sem sucesso*/
$appointment_array [] = array (
'title' =>' ',
'start' => $appointment_start_date,
'end' =>$appointment_enddate,
'conteudo' =>$conteudo,
'sala_name' =>$sala_name,
'sala_cor' =>$sala_cor,
'consulta' =>$consulta
);
}
}?>
class appointment
PHP:
<?php //$user = new WP_User($user_id);
class Hmgt_appointment{ //Medicine Category
public function hmgt_add_appointment($data) {
global $wpdb;
$table_appointment = $wpdb->prefix. 'hmgt_appointment';
//-------usersmeta table data--------------
$appointmentdata['appointment_time_string']=$data['appointment_date']." ".$data['appointment_time'];
//$appointmentdata['appointment_time_string']=$data['appointment_date']."   ".$data['appointment_time']." ".$data['appointment_time_fim']; //add by Rui
$appointmentdata['patient_id']=$data['patient_id'];
$appointmentdata['sala_id']=$data['sala_id']; //add by natalia
$appointmentdata['doctor_id']=$data['doctor_id'];
$appointmentdata['appointment_date']=$data['appointment_date'];
$appointmentdata['appointment_time']=$data['appointment_time'];
$appointmentdata['appointment_time_fim']=$data['appointment_time_fim']; //add by Rui
$appointmentdata['tratamento']=$data['tratamento'];
$appointmentdata['nome']=$data['nome'];
$appointmentdata['appoint_create_date']=date("Y-m-d");
$appointmentdata['appoint_create_by']=get_current_user_id();
if($data['action']=='edit') {
$appointment_id['appointment_id']=$data['appointment_id'];
$result=$wpdb->update( $table_appointment, $appointmentdata ,$appointment_id);
hmgt_append_audit_log('Update appointment ',get_current_user_id());
return $result;
}else{
$result=$wpdb->insert( $table_appointment, $appointmentdata );
hmgt_append_audit_log('Add new appointment ',get_current_user_id());
return $result;
}
}
obrigado.