// HTTP 1.0.
header("Expires: 0");
// Proxies.
error_reporting(E_ALL);
ini_set("display_errors", 1);
require_once 'main.php';
require_once 'Connection.class.php';
require_once 'CustomerPaginator.class.php';
$c = new Connection();
$conn = $c->getConnection();
$limit = from_get('limit', 10);
$page = from_get('page', 1);
$links = from_get('links', 7);
$expanded = from_get('expanded', 'on');
$search_name = from_get('search_name', '');
$search_participants = from_get('search_participants', '');
$query = "SELECT DISTINCT A.id, A.name, A.email, A.phone, A.participants, A.observations, A.timestamp FROM wp_musicteach_customer A ";
$conn->set_charset("utf8");
$Paginator = new CustomerPaginator($conn, $query, $search_name, $search_participants);
$results = $Paginator->getData($limit, $page);
if (isAjaxRequest()) {
include 'include_list_customers.php';
} else {
include 'head.php';
?>
<h1 class="text-center">Cercador de famílies</h1>
<div id="form-list" class="form-list" data-model="customer">
<?php
include 'include_search_customers.php';
include 'include_list_customers.php';
?>
// Proxies.
error_reporting(E_ALL);
ini_set("display_errors", 1);
require_once 'main.php';
require_once 'Connection.class.php';
require_once 'GroupPaginator.class.php';
$c = new Connection();
$conn = $c->getConnection();
/*$limit = ( isset( $_GET['limit'] ) ) ? $_GET['limit'] : 10;
$page = ( isset( $_GET['page'] ) ) ? $_GET['page'] : 1;
$links = ( isset( $_GET['links'] ) ) ? $_GET['links'] : 7;
$expanded = ( isset( $_GET['expanded'] ) ) ? $_GET['expanded'] : 'on';*/
$limit = from_get('limit', 10);
$page = from_get('page', 1);
$links = from_get('links', 7);
$expanded = from_get('expanded', 'on');
$search_date = from_post_or_get('search_date', '');
$query = "SELECT DISTINCT A.id, A.name, A.age, A.date_start, A.date_end, A.location, A.observations, A.comments, A.timestamp FROM wp_musicteach_group A ";
$conn->set_charset("utf8");
$groupPaginator = new GroupPaginator($conn, $query, $search_date);
$results = $groupPaginator->getData($limit, $page);
include 'head.php';
?>
<h1 class="text-center">Grups</h1>
<h2>Cerca</h2>
<div>
<form action="group_list.php" class="search" method="get">
<div class="row">
<div class="col-xs-2">
require_once 'Connection.class.php';
require_once 'SchedulingDAO.class.php';
require_once 'ActivityDAO.class.php';
require_once 'SongDAO.class.php';
require_once 'ActivityPaginator.class.php';
$action = isset($_GET['action']) ? $_GET['action'] : 'new';
$id = isset($_GET['id']) ? $_GET['id'] : -1;
$limit = from_get('limit', 10);
$page = from_get('page', 1);
$links = from_get('links', 7);
$expanded = from_get('expanded', 'on');
$search_string = from_get('search_string', '');
$search_order = from_get('search_order', '');
$search_types = from_get('search_types', array());
$search_song_themes = from_get('search_song_themes', array());
$search_ages = from_get('search_ages', array());
if ($action !== 'update' && $action !== 'new') {
die('opció invalida');
exit;
}
$c = new Connection();
$conn = $c->getConnection();
if ($action === 'update') {
$activityDAO = new ActivityDAO($conn);
$schedulingDAO = new SchedulingDAO($conn);
$scheduling = $schedulingDAO->select($id);
} else {
$scheduling = array('id' => -1, 'scheduling_date_start' => '', 'scheduling_date_end' => '', 'observations' => '', 'comments' => '', 'age' => '0', 'activity' => array());
}
$title = $action === 'new' ? 'Nova planificació' : 'Modificar planificació';
$query = "SELECT DISTINCT A.id, A.activity_name, A.description, A.goals, A.materials, A.observations, A.assesment, A.comments, A.keywords, A.types, A.song_themes, A.ages, A.timestamp, group_concat(C.name separator ', ') FROM wp_musicteach_activity A LEFT JOIN wp_musicteach_activity_song B ON A.id = B.activity_id LEFT JOIN wp_musicteach_song C ON B.song_id = C.id";
ini_set("display_errors", 1);
require_once 'main.php';
require_once 'Connection.class.php';
require_once 'WorkshopPaginator.class.php';
require_once 'GroupDAO.class.php';
$c = new Connection();
$conn = $c->getConnection();
$limit = from_get('limit', 10);
$page = from_get('page', 1);
$links = from_get('links', 7);
$expanded = from_get('expanded', 'on');
$search_group = from_get('search_group', '');
$search_from_date = from_get('search_from_date', '');
$search_to_date = from_get('search_to_date', '');
$search_favourite = from_get('search_favourite', '');
$search_ages = from_get('search_ages', '');
$query = "SELECT A.id, A.workshop_date, A.group_id, A.observations, A.comments, A.favourite, A.age, A.timestamp, B.name FROM wp_musicteach_workshop A JOIN wp_musicteach_group B ON A.group_id = B.id ";
$group_by = "";
$conn->set_charset("utf8");
$groupDAO = new GroupDAO($conn);
$groups = $groupDAO->getAllGroupsKeysAndNames();
$Paginator = new WorkshopPaginator($conn, $query, $group_by, $search_group, $search_from_date, $search_to_date, $search_favourite, $search_ages);
$results = $Paginator->getData($limit, $page);
if (isAjaxRequest()) {
include 'include_list_workshops.php';
} else {
include 'head.php';
?>
<h1 class="text-center">Cercador de tallers</h1>
<div id="form-list" class="form-list" data-model="workshop">
<?php
header('Content-Type: text/html; charset=utf-8');
header("Cache-Control: no-cache, no-store, must-revalidate");
// HTTP 1.1.
header("Pragma: no-cache");
// HTTP 1.0.
header("Expires: 0");
// Proxies.
error_reporting(E_ALL);
ini_set("display_errors", 1);
require_once 'main.php';
require_once 'Connection.class.php';
require_once 'ActivityDAO.class.php';
require_once 'SongDAO.class.php';
require_once 'partial_form_track.php';
$action = from_get('action', 'new');
$id = from_get('id', -1);
if ($action !== 'update' && $action !== 'new') {
die('opció invalida');
exit;
}
if ($action === 'update') {
$c = new Connection();
$conn = $c->getConnection();
$activityDAO = new ActivityDAO($conn);
$activity = $activityDAO->select($id);
$songDAO = new SongDAO($conn);
$songs = $songDAO->selectFromActivity($id);
} else {
$activity = array('id' => -1, 'activity_name' => '', 'description' => '', 'goals' => '', 'materials' => '', 'observations' => '', 'assesment' => '', 'comments' => '', 'keywords' => '', 'types' => '', 'song_themes' => '', 'ages' => '');
$songs = array();
}
// HTTP 1.0.
header("Expires: 0");
// Proxies.
error_reporting(E_ALL);
ini_set("display_errors", 1);
require_once 'main.php';
require_once 'Connection.class.php';
require_once 'SchedulingPaginator.class.php';
$c = new Connection();
$conn = $c->getConnection();
$limit = from_get('limit', 10);
$page = from_get('page', 1);
$links = from_get('links', 7);
$expanded = from_get('expanded', 'on');
$search_date = from_get('search_date', '');
$search_age = from_get('search_age', '');
$query = "SELECT A.id, A.scheduling_date_start, A.scheduling_date_end, A.observations, A.comments, A.age, A.timestamp FROM wp_musicteach_scheduling A ";
$group_by = "";
$conn->set_charset("utf8");
$Paginator = new SchedulingPaginator($conn, $query, $group_by, $search_date, $search_age);
$results = $Paginator->getData($limit, $page);
if (isAjaxRequest()) {
include 'include_list_schedulings.php';
} else {
include 'head.php';
?>
<h1 class="text-center">Cercador de planificacions</h1>
<div id="form-list" class="form-list" data-model="scheduling">
<?php
include 'include_search_schedulings.php';
include 'include_list_schedulings.php';
