<?php
require_once '../class.db.php';
isset($_REQUEST['id_pool']) ? $id_pool = $_REQUEST['id_pool'] : ($id_pool = "");
isset($_REQUEST['id_saison']) ? $id_saison = $_REQUEST['id_saison'] : ($id_saison = "");
isset($_REQUEST['poolName']) ? $poolName = $_REQUEST['poolName'] : ($poolName = "");
isset($_REQUEST['gerant']) ? $gerant = $_REQUEST['gerant'] : ($gerant = "");
isset($_REQUEST['periode']) ? $periode = $_REQUEST['periode'] : ($periode = "");
isset($_REQUEST['func']) ? $func = $_REQUEST['func'] : ($func = "");
isset($_REQUEST['id_player']) ? $id_player = $_REQUEST['id_player'] : ($id_player = "");
isset($_REQUEST['injured']) ? $injured = $_REQUEST['injured'] : ($injured = "");
isset($_REQUEST['force_injury']) ? $force_injury = $_REQUEST['force_injury'] : ($force_injury = "");
isset($_REQUEST['force_injury_raison']) ? $force_injury_raison = $_REQUEST['force_injury_raison'] : ($force_injury_raison = "");
echo "func: {$func}";
DB::dbConnect(strtolower($poolName));
switch ($func) {
case "chgPlayerInjuryStatus":
$q = "update joueurs_nhl set injured='{$injured}',force_injury='{$force_injury}',force_injury_raison=\"{$force_injury_raison}\"\n where\n id_pool = {$id_pool}\n and saison_id = {$id_saison}\n and periode >= {$periode}\n and id_player = {$id_player}";
//echo $q;
DB::dbUpdate($q);
$q = "update joueurs_nhl_1st_day set injured='{$injured}',force_injury='{$force_injury}',force_injury_raison=\"{$force_injury_raison}\"\n where\n id_pool = {$id_pool}\n and saison_id = {$id_saison}\n and periode >= {$periode}\n and id_player = {$id_player}";
DB::dbUpdate($q);
break;
}
require_once '../lib/db.php';
require_once '../lib/admin.php';
require_once '../lib/html.php';
session_start();
$db = new DB();
$admin = new ADMIN();
$html = new HTML();
//print_r($_REQUEST);
//--> Add
if ($_REQUEST['action'] == "add" && $_REQUEST['frm_supplier_name'] && $_REQUEST['frm_supplier_phone_number']) {
// filter input
if (!$_REQUEST['frm_supplier_active']) {
$_REQUEST['frm_supplier_active'] = "no";
}
// the query
$db->dbConnect();
$query = "INSERT INTO `mbs_suppliers` (`supplier_id`, \n\t\t\t\t\t\t\t\t\t\t `supplier_name`, \n\t\t\t\t\t\t\t\t\t\t `supplier_email`, \n\t\t\t\t\t\t\t\t\t\t `supplier_phone_number`, \n\t\t\t\t\t\t\t\t\t\t `supplier_postal_address`, \n\t\t\t\t\t\t\t\t\t\t `supplier_last_year_purchase`, \n\t\t\t\t\t\t\t\t\t\t `supplier_target`, \n\t\t\t\t\t\t\t\t\t\t `supplier_growth_incentives`, \n\t\t\t\t\t\t\t\t\t\t `supplier_budget`, \n\t\t\t\t\t\t\t\t\t\t `supplier_po_ref_number`, \n\t\t\t\t\t\t\t\t\t\t `supplier_active`, \n\t\t\t\t\t\t\t\t\t\t `supplier_created_date`, \n\t\t\t\t\t\t\t\t\t\t `supplier_created_by`, \n\t\t\t\t\t\t\t\t\t\t `supplier_modified_date`, \n\t\t\t\t\t\t\t\t\t\t `supplier_modified_by`) \n\n\t\t\t\tVALUES (NULL, \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_name']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_email']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_phone_number']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_postal_address']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_last_year_purchase']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_target']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_growth_incentives']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_budget']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_po_ref_number']) . "', \n\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_active']) . "', \n\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "', \n\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "',\n\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "', \n\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "')";
$result = mysql_query($query);
$intID = mysql_insert_id();
if ($result) {
// Insert the Marketing Contact
if ($intID && $_REQUEST['frm_supplier_contact_name']) {
$queryContact = "INSERT INTO `mbs_suppliers_marketing_contacts` (`supplier_contact_id`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_id`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_name`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_position`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_email`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_phone_number`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_mobile_number`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_postal_address`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_active`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_created_date`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_created_by`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_modified_date`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_contact_modified_by`) \n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (NULL, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . $intID . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_contact_name']) . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_contact_position']) . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_contact_email']) . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_contact_phone_number']) . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_contact_mobile_number']) . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_contact_postal_address']) . "', \t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'yes', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "')";
$resultContact = mysql_query($queryContact);
}
// if ($intID && $_REQUEST['frm_supplier_contact_name'])
// Insert the Account Contact
if ($intID && $_REQUEST['frm_supplier_account_name']) {
$queryAccount = "INSERT INTO `mbs_suppliers_account_contacts` (`supplier_account_id`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_id`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_name`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_email`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_phone_number`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_postal_address`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_active`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_created_date`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_created_by`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_modified_date`, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `supplier_account_modified_by`) \n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (NULL, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . $intID . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_account_name']) . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_account_email']) . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_account_phone_number']) . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . mysql_real_escape_string($_REQUEST['frm_supplier_account_postal_address']) . "', \t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'yes', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "', \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "')";
$resultAccount = mysql_query($queryAccount);
}
## Modification:
##
## 2014-08-27: Modification du format html des pages webs
## -------------------------------------------------------------------------------
##################################################################################
require_once '/data/disk1/www/interPool/src/class.db.php';
require_once '/data/disk1/www/interPool/admin_scripts/init.php';
/*----------------------------
MAIN
*/
$logFile = "/data/disk1/www/interPool/logs/update_id_capgeek.log";
$DESTDIR = "/data/disk1/www/interPool/downloads/capgeek";
$DESTDIR_PLAYER = "{$DESTDIR}/players";
$INSERTFILE = "/data/disk1/www/interPool/sql/upd_id_capgeek_doinsert.sql";
@unlink($INSERTFILE);
DB::dbConnect();
foreach (glob("{$DESTDIR}/*.html") as $item) {
writelog($logFile, "info", "Analyzing file '{$item}'");
unset($linesA);
$linesA = file($item);
foreach ($linesA as $line_number => $line) {
if (preg_match("/href=\"\\/player\\//", $line, $matches, PREG_OFFSET_CAPTURE)) {
$id_capgeek = 0;
//echo $line;
$ar1 = explode(">", $line);
$ar2 = explode("/", $ar1[1]);
$id_capgeek = substr($ar2[2], 0, strlen($ar2[2]) - 1);
$player_lastname = $ar1[2];
$player_lastname = trim($player_lastname);
$player_lastname = substr($player_lastname, 0, strlen($player_lastname) - 1);
// prénom du joueur
<?php
require_once 'config.DB_eSession.php';
require_once 'class.DB_eSession.php';
require_once '../class.interpool.php';
require_once '../class.db.php';
require_once '../browser_detection.php';
$sess_param['name'] = "DRAFT_INTERPOOL";
$sess = new DB_eSession($sess_param);
// session_start() done.
// récupérer certaines informations de la session
$id_pool = $sess->getSessVar('id_pool', 0);
$id_saison = $sess->getSessVar('id_saison', 0);
$gerant = $sess->getSessVar('gerant', 0);
$poolName = $sess->getSessVar('poolName', 0);
$pool = new interPool();
// Connexion a la bd
DB::dbConnect(strtolower($poolName)) or die("Erreur de connexion à la bd '{$poolName}'");
//$pool->dbConnect(strtolower($poolName)) or die("Erreur de connexion à la bd '$poolName'");
$query = "select do_refresh\r\n from\r\n draft_refresh_screen\r\n where\r\n id_pool = {$id_pool}\r\n and saison_id = {$id_saison}\r\n and id_gerant = {$gerant}";
$data = DB::dbSelect($query);
$data = $data[0];
$do_refresh = $data['do_refresh'];
if ($do_refresh != 0) {
$query = "update draft_refresh_screen set do_refresh=0\r\n where\r\n id_pool = {$id_pool}\r\n and saison_id = {$id_saison}\r\n and id_gerant = {$gerant}";
DB::dbUpdate($query);
}
//$pool -> dbClose();
DB::dbClose();
echo $do_refresh;
unset($query, $resultID, $message, $pool, $id_pool, $id_saison, $poolName, $gerant, $sess, $data, $do_refresh);
DB::dbConnect();
$q = "SELECT id,name,toUpdate,saison FROM pools where toUpdate = 'Y'";
$data = DB::dbSelect($q);
DB::dbClose();
foreach ($data as $item) {
$id_pool = $item['id'];
$name = $item['name'];
$toUpdate = $item['toUpdate'];
$id_saison = $item['saison'];
//if ($id_pool != 8) continue;
if ($toUpdate != 'Y') {
writelog($logFile, strtoupper($name), "toUpdate of pool '{$name}' (id={$id_pool}) is set to 'N'");
continue;
}
writelog($logFile, strtoupper($name), "Pool {$name} ({$id_pool})");
DB::dbConnect(strtolower($name));
$configA = $upd->getPoolConfig($id_pool, $id_saison);
$date_debut_saison = $configA['date_debut_saison'];
$pts_but_f = $configA['pts_but_f'];
$pts_passe_f = $configA['pts_passe_f'];
$pts_but_d = $configA['pts_but_d'];
$pts_passe_d = $configA['pts_passe_d'];
$pts_win = $configA['pts_victoire_gardien'];
$pts_loss = $configA['pts_defaite_gardien'];
$pts_tie = $configA['pts_nulle_gardien'];
$pts_shutout = $configA['pts_blanc_gardien'];
$periode = $upd->getPeriode($id_pool, $id_saison, $today);
$date_begin_per = $upd->getPeriodeDateDebut($id_pool, $id_saison, $periode);
$date_begin_per == $today ? $view2use = "view_alignementGerant_1st_day" : ($view2use = "view_alignementGerant");
$q = "select id,real_name_abrege from accounts\n where\n id_pool = {$id_pool}\n and saison_id = {$id_saison}";
$data2 = DB::dbSelect($q);
function checkSupplierCatalogueStock($intSupplierId, $text, $strYear, $strMonth)
{
$conn = DB::dbConnect();
$maxSpot = 384;
$spot;
$theme;
if (strpos($text, "Catalogue - IN 2 Health") !== false) {
$theme = "Catalogue - IN 2 Health";
} else {
if (strpos($text, "Catalogue - Pharmacy4Less") !== false) {
$theme = "Catalogue - Pharmacy4Less";
} else {
if (strpos($text, "Catalogue - Roy Young") !== false) {
$theme = "Catalogue - Roy Young";
} else {
if (strpos($text, "Themed Catalogue - Pharmacy4Less") !== false) {
$theme = "Themed Catalogue - Pharmacy4Less";
} else {
if (strpos($text, "Themed Catalogue - Roy Young") !== false) {
$theme = "Themed Catalogue - Roy Young";
}
}
}
}
}
if (strpos($text, "Double Spot") !== false) {
$spot = 2;
} else {
if (strpos($text, "Full Page") !== false) {
$spot = 16;
} else {
if (strpos($text, "8 Spots") !== false) {
$spot = 8;
} else {
if (strpos($text, "4 Spots") !== false) {
$spot = 4;
} else {
if (strpos($text, "Single Spot") !== false) {
$spot = 1;
} else {
if (strpos($text, "Themed Supplementary") !== false) {
$spot = 2;
}
}
}
}
}
}
$query = "SELECT \n\t\t\t\t\tSUM(\n\t\t\t\t\t\tCASE\n\t\t\t\t \t\tWHEN LOCATE('Double Spot',activity.activity_name)>0 THEN '2'\n\t\t\t\t\t\t\tWHEN LOCATE('Full Page',activity.activity_name)>0 THEN '16'\n\t\t\t\t\t\t\tWHEN LOCATE('8 Spots',activity.activity_name)>0 THEN '8'\n\t\t\t\t\t\t\tWHEN LOCATE('4 Spots',activity.activity_name)>0 THEN '4'\n\t\t\t\t\t\t\tWHEN LOCATE('Single Spot',activity.activity_name)>0 THEN '1'\n\t\t\t\t\t\t\tWHEN LOCATE('Themed Supplementary',activity.activity_name)>0 THEN '2'\n\t\t\t\t \tEND\n\t\t\t\t\t) AS stock\n\t\t\t\tFROM \n\t\t\t\t\tmbs_bookings_activities AS booking \n\t\t\t\tINNER JOIN \n\t\t\t\t\tmbs_activities AS activity \n\t\t\t\t\tON activity.activity_id = booking.activity_id \n\t\t\t\tWHERE \n\t\t\t\t\tactivity.activity_name like '%" . $theme . "%'\n\t\t\t\t\tAND booking_activity_month = '" . $strMonth . "' \n\t\t\t\t\tAND booking_activity_year = '" . $strYear . "'";
$result = mysql_query($query, $conn);
$row = mysql_fetch_assoc($result);
if ($row['stock'] + $spot <= 384) {
return TRUE;
} else {
return FALSE;
}
}
function affichage_scoreboard($ptr_pool, $ptr_sess)
{
/*
Je vais le faire de la manière suivante: avant 10h00 am, je vais afficher les résultats de la veille et le clic du match
ira sur la page de tous les scores de la veille.
Après 10h00, je vais afficher les matchs du jour, que ce soit en cours, à venir ou terminé.
Une fois les matchs du jour terminé, j'afficherai les matchs à venir.
*/
echo "<div id=\"gameReel\">\n";
echo "<div id=\"hdrSB\">";
echo "<div class=\"hdrSBLeftRule\"></div>\n";
$SB_max = 14;
$compteur_SB = 0;
$id_pool = $ptr_sess->getSessVar('id_pool', 0);
$id_saison = $ptr_sess->getSessVar('id_saison', '0');
$poolName = $ptr_sess->getSessVar('poolName', '');
DB::dbConnect(strtolower($poolName));
// quelle ronde somme-nous rendus?
$query = "select * from playoffs2_config\n where\n id_pool = {$id_pool}\n and saison_id = {$id_saison}";
$data = DB::dbSelect($query);
$data = $data[0];
$ronde_nhl = $data['ronde_nhl'];
switch ($ronde_nhl) {
case 1:
$date_debut_ronde = $data['date_debut_series'];
break;
case 2:
$date_debut_ronde = $data['date_debut_ronde2'];
break;
case 3:
$date_debut_ronde = $data['date_debut_ronde3'];
break;
case 4:
$date_debut_ronde = $data['date_debut_ronde4'];
break;
}
$q = "select a.home,a.visitor,a.game_result\n from schedule_playoffs a,playoffs_series_nhl b\n where\n (a.home = b.team1 or a.home = b.team2)\n and a.date >= b.date_debut_ronde\n and a.game_result != '-'\n and b.saison_id = {$id_saison}\n and b.ronde = {$ronde_nhl}";
$data = DB::dbSelect($q);
foreach ($data as $item) {
$home = $item['home'];
$visitor = $item['visitor'];
$game_result = $item['game_result'];
list($visitor_score, $toto, $home_score, $ot) = explode(" ", $game_result);
if ($visitor_score > $home_score) {
isset($teamWins[$visitor]) ? $teamWins[$visitor]++ : ($teamWins[$visitor] = 1);
} else {
isset($teamWins[$home]) ? $teamWins[$home]++ : ($teamWins[$home] = 1);
}
}
if ($ptr_pool->todayDate->format('H') <= "06") {
$today = $ptr_pool->yesterday;
$link_to_gs = "individuel";
$journee = "Aujourd'hui";
} elseif ($ptr_pool->todayDate->format('H') <= "09") {
$today = $ptr_pool->yesterday;
$link_to_gs = "global";
$journee = "Hier";
} else {
$today = $ptr_pool->today;
$journee = "Aujourd'hui";
}
if ($journee == "Hier") {
// premièrement, affichage des résultats de la veille...
$query = "select home,visitor,time,game_result\n from schedule_playoffs\n where date = '{$today}'\n order by time asc";
$resultID = mysql_query($query, $ptr_pool->handle);
while ($data = mysql_fetch_array($resultID, MYSQL_ASSOC)) {
$home_team = $data['home'];
$visitor_team = $data['visitor'];
$game_time = $data['time'];
$game_result = $data[game_result];
// abbréviation des équipes...
$query2 = "select abbr from teams where id = {$home_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_home = $data2['abbr'];
$query2 = "select abbr from teams where id = {$visitor_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_visitor = $data2['abbr'];
$game_resultA = split(" ", $game_result);
$goals_visitor = $game_resultA[0];
$goals_home = $game_resultA[2];
$ot_str = $game_resultA[3];
isset($teamWins[$home_team]) ? $home_wins = $teamWins[$home_team] : ($home_wins = 0);
isset($teamWins[$visitor_team]) ? $visitor_wins = $teamWins[$visitor_team] : ($visitor_wins = 0);
if ($home_wins > $visitor_wins) {
$str_series = "{$abbr_home} mène {$home_wins}-{$visitor_wins}";
} elseif ($visitor_wins > $home_wins) {
$str_series = "{$abbr_visitor} mène {$visitor_wins}-{$home_wins}";
} else {
$str_series = "Égal {$home_wins}-{$visitor_wins}";
}
echo "<div class=\"hdrSBFinalGame\" onmouseover=\"this.style.cursor='pointer';\" " . "onclick=\"window.open('http://www.nhl.com/scores/index.html','NHL GS','resizable=yes,scrollbars=yes,status=no');\">\n";
echo "<table cellpadding=0 cellspacing=0 border=0 width=90%>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"bottom\" class=\"hdrSBLink\"><span class=\"hdrSBRed\">{$journee}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_visitor}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">{$goals_visitor}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_home}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">{$goals_home}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"top\"><span class=\"hdrSBRed\">FINAL {$ot_str}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"top\"><span class=\"hdrSBStrg\">{$str_series}</span></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</div>\n";
$compteur_SB++;
unset($ot_str, $game_time);
}
mysql_free_result($resultID);
if ($compteur_SB > 0) {
echo "<div class=\"hdrSBRule\"></div>\n";
echo "<div class=\"hdrSBRule\"></div>\n";
}
// Ensuite, les matchs du jour
$query = "select home,visitor,time,match_no\n from schedule_playoffs\n where date = '{$ptr_pool->today}'\n order by time asc";
$resultID = mysql_query($query, $ptr_pool->handle);
while ($data = mysql_fetch_array($resultID, MYSQL_ASSOC)) {
if ($compteur_SB > $SB_max) {
break;
}
$home_team = $data['home'];
$visitor_team = $data['visitor'];
$game_timeA = split(" ", $data['time']);
$game_time = $game_timeA[0];
$match_no = $data['match_no'];
// abbréviation des équipes...
$query2 = "select abbr from teams where id = {$home_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_home = $data2['abbr'];
$query2 = "select abbr from teams where id = {$visitor_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_visitor = $data2['abbr'];
isset($teamWins[$home_team]) ? $home_wins = $teamWins[$home_team] : ($home_wins = 0);
isset($teamWins[$visitor_team]) ? $visitor_wins = $teamWins[$visitor_team] : ($visitor_wins = 0);
if ($home_wins > $visitor_wins) {
$str_series = "{$abbr_home} mène {$home_wins}-{$visitor_wins}";
} elseif ($visitor_wins > $home_wins) {
$str_series = "{$abbr_visitor} mène {$visitor_wins}-{$home_wins}";
} else {
$str_series = "Égal {$home_wins}-{$visitor_wins}";
}
echo "<div class=\"hdrSBTodayGame\" onmouseover=\"this.style.cursor='pointer';\" " . "onclick=\"window.open('http://www.nhl.com/scores/index.html','NHL GS','width=640,height=480,resizable=yes,scrollbars=yes,status=no');\">\n";
echo "<table cellpadding=0 cellspacing=0 border=0 width=90%>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"bottom\" class=\"hdrSBLink\"><span class=\"hdrSBYellow\">Aujourd'hui</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_visitor}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">-</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_home}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">-</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBYellow\">{$game_time} (#{$match_no})</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBStrg\">{$str_series}</span></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</div>\n";
$compteur_SB++;
unset($ot_str, $game_time);
}
mysql_free_result($resultID);
// Finalement, si le compteur du scoreboard n'est pas à son maximum, on affiche les matchs
// à venir jusqu'à la limite du compteur.
if ($compteur_SB < $SB_max) {
echo "<div class=\"hdrSBRule\"></div>\n";
echo "<div class=\"hdrSBRule\"></div>\n";
$nbre_de_sb_a_ajouter = $SB_max - $compteur_SB;
if ($ptr_pool->todayDate->format('H') <= "09") {
list($year, $month, $day) = split("-", $ptr_pool->today);
$_mydate = Datetime::createFromFormat('Y-m-d', $ptr_pool->today, $ptr_pool->timeZone);
$_mydate->modify("+1 day");
$tomorrow = $_mydate->format('Y-m-d');
} else {
list($year, $month, $day) = split("-", $today);
$_mydate = Datetime::createFromFormat('Y-m-d', $today, $ptr_pool->timeZone);
$_mydate->modify("+1 day");
$tomorrow = $_mydate->format('Y-m-d');
}
//$tomorrow = date("Y-m-d",((mktime(10,0,0,$month,$day,$year)) + 86400));
$query = "select home,visitor,time,date,match_no\n from schedule_playoffs\n where date >= '{$tomorrow}'\n order by date asc,time asc\n limit {$nbre_de_sb_a_ajouter}";
$resultID = mysql_query($query, $ptr_pool->handle);
$date_en_traitement = "";
while ($data = mysql_fetch_array($resultID, MYSQL_ASSOC)) {
$home_team = $data['home'];
$visitor_team = $data['visitor'];
$game_timeA = split(" ", $data['time']);
$game_time = $game_timeA[0];
$game_date = $data['date'];
$match_no = $data['match_no'];
if ($game_time == "") {
$game_time = "TBD";
}
// abbréviation des équipes...
$query2 = "select abbr from teams where id = {$home_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_home = $data2['abbr'];
$query2 = "select abbr from teams where id = {$visitor_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_visitor = $data2['abbr'];
if ($date_en_traitement == "") {
$date_en_traitement = $game_date;
}
if ("{$game_date}" != "{$date_en_traitement}") {
echo "<div class=\"hdrSBRule\"></div>\n";
echo "<div class=\"hdrSBRule\"></div>\n";
$date_en_traitement = $game_date;
}
$_mydate = Datetime::createFromFormat('Y-m-d', $game_date, $ptr_pool->timeZone);
$day = $_mydate->format("j");
$day_str = $_mydate->format("D");
$month = $_mydate->format("m");
switch ($day_str) {
case "Mon":
$day_str = "Lun";
break;
case "Tue":
$day_str = "Mar";
break;
case "Wed":
$day_str = "Mer";
break;
case "Thu":
$day_str = "Jeu";
break;
case "Fri":
$day_str = "Ven";
break;
case "Sat":
$day_str = "Sam";
break;
case "Sun":
$day_str = "Dim";
break;
}
isset($teamWins[$home_team]) ? $home_wins = $teamWins[$home_team] : ($home_wins = 0);
isset($teamWins[$visitor_team]) ? $visitor_wins = $teamWins[$visitor_team] : ($visitor_wins = 0);
if ($home_wins > $visitor_wins) {
$str_series = "{$abbr_home} mène {$home_wins}-{$visitor_wins}";
} elseif ($visitor_wins > $home_wins) {
$str_series = "{$abbr_visitor} mène {$visitor_wins}-{$home_wins}";
} else {
$str_series = "Égal {$home_wins}-{$visitor_wins}";
}
echo "<div class=\"hdrSBFutureGame\" onmouseover=\"this.style.cursor='pointer';\" " . "onclick=\"window.open('http://www.nhl.com/scores/index.html','NHL GS','width=640,height=480,resizable=yes,scrollbars=yes,status=no');\">\n";
echo "<table cellpadding=0 cellspacing=0 border=0 width=90%>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"bottom\" class=\"hdrSBLink\"><span class=\"hdrSBGrey\">{$day_str} {$day}/{$month}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_visitor}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">-</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_home}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">-</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBGrey\">{$game_time} (#{$match_no})</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBStrg\">{$str_series}</span></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</div>\n";
$compteur_SB++;
unset($ot_str, $game_time);
}
}
} else {
// schedule du jour
$query = "select home,visitor,time,match_no\n from schedule_playoffs\n where date = '{$today}'\n order by time asc";
$resultID = mysql_query($query, $ptr_pool->handle);
//Pour avoir les parties terminées en premier, suivi des parties en cours et finalement,
// les parties qui vont se jouer plus tard, on va créer des arrays afin de vérifier
// les données de la tables 'live'. Les games finished seront placées au début d'une nouvelle
// array et c'est cette dernière que je vais traiter par la suite.
while ($data = mysql_fetch_array($resultID, MYSQL_ASSOC)) {
$home_team = $data['home'];
$visitor_team = $data['visitor'];
$game_timeA = split(" ", $data['time']);
$game_time = $game_timeA[0];
$match_no = $data['match_no'];
$homeTeamA[] = $home_team;
$visitorTeamA[] = $visitor_team;
$gameTimeA[] = $game_time;
$match_noA[] = $match_no;
}
mysql_free_result($resultID);
unset($homeTeamBonOrderA, $visitorTeamBonOrdreA, $gameTimeBonOrdreA);
$index_array = 20;
$first_index_array = 20;
if (count($homeTeamA) > 0) {
foreach ($homeTeamA as $index => $home_team) {
$query = "select temps_ecoule\n from live_stats.statsPlayers_live\n where id_team = {$home_team}\n limit 1";
$resultID = mysql_query($query, $ptr_pool->handle);
$data = mysql_fetch_array($resultID, MYSQL_ASSOC);
mysql_free_result($resultID);
if (eregi("Final", $data[temps_ecoule])) {
$first_index_array--;
$homeTeamBonOrderA[$first_index_array] = $home_team;
$visitorTeamBonOrdreA[$first_index_array] = $visitorTeamA[$index];
$gameTimeBonOrdreA[$first_index_array] = $gameTimeA[$index];
$match_noBonOrdreA[$first_index_array] = $match_noA[$index];
} else {
$homeTeamBonOrderA[$index_array] = $home_team;
$visitorTeamBonOrdreA[$index_array] = $visitorTeamA[$index];
$gameTimeBonOrdreA[$index_array] = $gameTimeA[$index];
$match_noBonOrdreA[$index_array] = $match_noA[$index];
$index_array++;
}
}
ksort($homeTeamBonOrderA);
ksort($visitorTeamBonOrdreA);
ksort($gameTimeBonOrdreA);
ksort($match_noBonOrdreA);
foreach ($homeTeamBonOrderA as $index => $home_team) {
$visitor_team = $visitorTeamBonOrdreA[$index];
$game_time = $gameTimeBonOrdreA[$index];
$match_no = $match_noBonOrdreA[$index];
// abbréviation des équipes...
$query2 = "select abbr from teams where id = {$home_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_home = $data2['abbr'];
$query2 = "select abbr from teams where id = {$visitor_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_visitor = $data2['abbr'];
// si l'heure actuelle est plus petite que l'heure du match...
list($heure, $minute) = split(":", $game_time);
if ($ptr_pool->todayDate->format('H') < "{$heure}" || $ptr_pool->todayDate->format('H') == "{$heure}" && $ptr_pool->todayDate->format('i') < "{$minute}") {
if ($previous_game_was_finished != "") {
echo "<div class=\"hdrSBRule\"></div>\n";
echo "<div class=\"hdrSBRule\"></div>\n";
$previous_game_was_finished = "";
}
isset($teamWins[$home_team]) ? $home_wins = $teamWins[$home_team] : ($home_wins = 0);
isset($teamWins[$visitor_team]) ? $visitor_wins = $teamWins[$visitor_team] : ($visitor_wins = 0);
if ($home_wins > $visitor_wins) {
$str_series = "{$abbr_home} mène {$home_wins}-{$visitor_wins}";
} elseif ($visitor_wins > $home_wins) {
$str_series = "{$abbr_visitor} mène {$visitor_wins}-{$home_wins}";
} else {
$str_series = "Égal {$home_wins}-{$visitor_wins}";
}
echo "<div class=\"hdrSBTodayGame\" onmouseover=\"this.style.cursor='pointer';\" " . "onclick=\"window.open('http://www.nhl.com/scores/index.html','NHL GS','width=640,height=480,resizable=yes,scrollbars=yes,status=no');\">\n";
echo "<table cellpadding=0 cellspacing=0 border=0 width=90%>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"bottom\" class=\"hdrSBLink\"><span class=\"hdrSBYellow\">Aujourd'hui</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_visitor}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">-</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_home}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">-</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBYellow\">{$game_time} (#{$match_no})</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBStrg\">{$str_series}</span></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</div>\n";
} else {
// le match est soit en cours, soit terminé.
$query = "select team_goals,adv_goals,temps_ecoule,gs_link\n from live_stats.statsPlayers_live\n where id_team = {$home_team}\n limit 1";
$resultID = mysql_query($query, $ptr_pool->handle);
$data = mysql_fetch_array($resultID, MYSQL_ASSOC);
mysql_free_result($resultID);
$my_team_goals = $data['team_goals'];
$my_adv_goals = $data['adv_goals'];
$my_temps_ecoule = $data['temps_ecoule'];
$my_gs_link = $data['gs_link'];
if (eregi("Final", $my_temps_ecoule)) {
$previous_game_was_finished = "oui";
isset($teamWins[$home_team]) ? $home_wins = $teamWins[$home_team] : ($home_wins = 0);
isset($teamWins[$visitor_team]) ? $visitor_wins = $teamWins[$visitor_team] : ($visitor_wins = 0);
// on ajoute la victoire du jour...
if ($my_adv_goals > $my_team_goals) {
$visitor_wins++;
} else {
$home_wins++;
}
if ($home_wins > $visitor_wins) {
$str_series = "{$abbr_home} mène {$home_wins}-{$visitor_wins}";
} elseif ($visitor_wins > $home_wins) {
$str_series = "{$abbr_visitor} mène {$visitor_wins}-{$home_wins}";
} else {
$str_series = "Égal {$home_wins}-{$visitor_wins}";
}
echo "<div class=\"hdrSBFinalGame\" onmouseover=\"this.style.cursor='pointer';\" " . "onclick=\"window.open('{$my_gs_link}','NHL GS','resizable=yes,scrollbars=yes,status=no');\">\n";
echo "<table cellpadding=0 cellspacing=0 border=0 width=90%>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"bottom\" class=\"hdrSBLink\"><span class=\"hdrSBRed\">Aujourd'hui</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_visitor}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">{$my_adv_goals}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_home}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">{$my_team_goals}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"top\"><span class=\"hdrSBRed\">" . $my_temps_ecoule . "</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBStrg\">{$str_series}</span></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</div>\n";
} else {
// le match est en cours...
if ($previous_game_was_finished != "") {
echo "<div class=\"hdrSBRule\"></div>\n";
echo "<div class=\"hdrSBRule\"></div>\n";
$previous_game_was_finished = "";
}
$str_temps_ecoule = "";
if ($my_temps_ecoule == "") {
$str_temps_ecoule = "???";
$period = 0;
} else {
$str_temps_ecoule = $my_temps_ecoule;
}
/*
if (eregi("remaining",$my_temps_ecoule)) {
$totoA = split(" ",$my_temps_ecoule);
if ($totoA[0] == "Period") {
$period = $totoA[1];
$time_remaining = $totoA[2];
} else {
$period = $totoA[0];
$time_remaining = $totoA[1];
}
$time_remaining = substr($time_remaining,1,strlen($time_remaining)-1);
$str_temps_ecoule = "$time_remaining ";
}
if (eregi("end of",$my_temps_ecoule)) {
$totoA = split(" ",$my_temps_ecoule);
$period = $totoA[count($totoA)-1];
$str_temps_ecoule = "END ";
}
switch($period) {
case "0":
break;
case "1":
$str_temps_ecoule .= "1st";
break;
case "2":
$str_temps_ecoule .= "2nd";
break;
case "3":
$str_temps_ecoule .= "3rd";
break;
case "4":
$str_temps_ecoule .= "1st OT";
break;
case "5":
$str_temps_ecoule .= "2nd OT";
break;
case "6":
$str_temps_ecoule .= "3rd OT";
break;
case "7":
$str_temps_ecoule .= "4th OT";
break;
case "8":
$str_temps_ecoule .= "5th OT";
break;
case "9":
$str_temps_ecoule .= "6th OT";
break;
default:
$str_temps_ecoule .= "OT";
break;
}
*/
isset($teamWins[$home_team]) ? $home_wins = $teamWins[$home_team] : ($home_wins = 0);
isset($teamWins[$visitor_team]) ? $visitor_wins = $teamWins[$visitor_team] : ($visitor_wins = 0);
if ($home_wins > $visitor_wins) {
$str_series = "{$abbr_home} mène {$home_wins}-{$visitor_wins}";
} elseif ($visitor_wins > $home_wins) {
$str_series = "{$abbr_visitor} mène {$visitor_wins}-{$home_wins}";
} else {
$str_series = "Égal {$home_wins}-{$visitor_wins}";
}
echo "<div class=\"hdrSBTodayGame\" onmouseover=\"this.style.cursor='pointer';\" " . "onclick=\"window.open('{$my_gs_link}','NHL GS','resizable=yes,scrollbars=yes,status=no');\">\n";
echo "<table cellpadding=0 cellspacing=0 border=0 width=90%>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"bottom\" class=\"hdrSBLink\"><span class=\"hdrSBYellow\">En cours...</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_visitor}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">{$my_adv_goals}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_home}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">{$my_team_goals}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"top\"><span class=\"hdrSBYellow\">{$str_temps_ecoule}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"top\"><span class=\"hdrSBStrg\">{$str_series}</span></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</div>\n";
}
}
$compteur_SB++;
unset($ot_str, $journee, $game_time);
}
}
// Finalement, si le compteur du scoreboard n'est pas à son maximum, on affiche les matchs
// à venir jusqu'à la limite du compteur.
if ($compteur_SB < $SB_max) {
if ($compteur_SB > 0) {
echo "<div class=\"hdrSBRule\"></div>\n";
echo "<div class=\"hdrSBRule\"></div>\n";
}
$nbre_de_sb_a_ajouter = $SB_max - $compteur_SB;
list($year, $month, $day) = split("-", $today);
$_mydate = Datetime::createFromFormat('Y-m-d', $today, $ptr_pool->timeZone);
$_mydate->modify("+1 day");
$tomorrow = $_mydate->format('Y-m-d');
$query = "select home,visitor,time,date,match_no\n from schedule_playoffs\n where date >= '{$tomorrow}'\n order by date asc,time asc\n limit {$nbre_de_sb_a_ajouter}";
$resultID = mysql_query($query, $ptr_pool->handle);
$date_en_traitement = "";
while ($data = mysql_fetch_array($resultID, MYSQL_ASSOC)) {
$home_team = $data['home'];
$visitor_team = $data['visitor'];
$game_timeA = split(" ", $data['time']);
$game_time = $game_timeA[0];
$game_date = $data['date'];
$match_no = $data['match_no'];
if ($game_time == "") {
$game_time = "TBD";
}
// abbréviation des équipes...
$query2 = "select abbr from teams where id = {$home_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_home = $data2['abbr'];
$query2 = "select abbr from teams where id = {$visitor_team}";
$resultID2 = mysql_query($query2, $ptr_pool->handle);
$data2 = mysql_fetch_array($resultID2, MYSQL_ASSOC);
mysql_free_result($resultID2);
$abbr_visitor = $data2['abbr'];
if ($date_en_traitement == "") {
$date_en_traitement = $game_date;
}
if ("{$game_date}" != "{$date_en_traitement}") {
echo "<div class=\"hdrSBRule\"></div>\n";
echo "<div class=\"hdrSBRule\"></div>\n";
$date_en_traitement = $game_date;
}
$_mydate = Datetime::createFromFormat('Y-m-d', $game_date, $ptr_pool->timeZone);
$day = $_mydate->format("j");
$day_str = $_mydate->format("D");
$month = $_mydate->format("m");
switch ($day_str) {
case "Mon":
$day_str = "Lun";
break;
case "Tue":
$day_str = "Mar";
break;
case "Wed":
$day_str = "Mer";
break;
case "Thu":
$day_str = "Jeu";
break;
case "Fri":
$day_str = "Ven";
break;
case "Sat":
$day_str = "Sam";
break;
case "Sun":
$day_str = "Dim";
break;
}
isset($teamWins[$home_team]) ? $home_wins = $teamWins[$home_team] : ($home_wins = 0);
isset($teamWins[$visitor_team]) ? $visitor_wins = $teamWins[$visitor_team] : ($visitor_wins = 0);
if ($home_wins > $visitor_wins) {
$str_series = "{$abbr_home} mène {$home_wins}-{$visitor_wins}";
} elseif ($visitor_wins > $home_wins) {
$str_series = "{$abbr_visitor} mène {$visitor_wins}-{$home_wins}";
} else {
$str_series = "Égal {$home_wins}-{$visitor_wins}";
}
echo "<div class=\"hdrSBFutureGame\" onmouseover=\"this.style.cursor='pointer';\" " . "onclick=\"window.open('http://www.nhl.com/scores/index.html','NHL GS','resizable=yes,scrollbars=yes,status=no');\">\n";
echo "<table cellpadding=0 cellspacing=0 border=0 width=90%>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"bottom\" class=\"hdrSBLink\"><span class=\"hdrSBGrey\">{$day_str} {$day}/{$month}</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_visitor}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">-</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><span class=\"hdrSBStrg\">{$abbr_home}</span></td>\n";
echo "<td align=\"right\"><span class=\"hdrSBStrg\">-</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBGrey\">{$game_time} (#{$match_no})</span></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td nowrap colspan=2 valign=\"top\"><span class=\"hdrSBStrg\">{$str_series}</span></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</div>\n";
$compteur_SB++;
unset($ot_str, $journee, $game_time);
}
}
}
echo "<div class=\"hdrSBRule\"></div>\n";
echo "</div>\n";
echo "</div>\n";
DB::dbClose();
}
function showReportGeneralMonthly($intMonth, $intYear)
{
global $STR_URL;
// vars
$intMinBookingTime = 3600 * 24 * 7;
// 3600 seconds * 24 hours * 14 days
DB::dbConnect();
?>
<script type="text/javascript" src="<?php
echo $STR_URL;
?>
js/jqplot/jquery.jqplot.min.js"></script>
<script type="text/javascript" src="<?php
echo $STR_URL;
?>
js/jqplot/plugins/jqplot.pieRenderer.min.js"></script>
<div align="center" style="margin-top:20px;">
<form id="frm_report_date" method="get" action="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<select id="month" name="month" class="input-medium">
<?php
for ($i = 1; $i <= 12; $i++) {
?>
<option value="<?php
echo $i;
?>
"<?php
if ($_REQUEST['month'] && $_REQUEST['month'] == $i) {
?>
selected="selected"<?php
} elseif (!$_REQUEST['month'] && date('n') == $i) {
?>
selected="selected"<?php
}
?>
><?php
echo HTML::getMonthName($i);
?>
</option>
<?php
}
?>
</select>
<select id="year" name="year" class="input-small">
<?php
for ($i = date('Y') - 1; $i < date('Y') + 4; $i++) {
?>
<option value="<?php
echo $i;
?>
"<?php
if ($_REQUEST['year'] && $_REQUEST['year'] == $i) {
?>
selected="selected"<?php
} elseif (!$_REQUEST['year'] && date('Y') == $i) {
?>
selected="selected"<?php
}
?>
><?php
echo $i;
?>
</option>
<?php
}
?>
</select><br />
<input class="btn" type="submit" value="Submit" />
</form>
</div>
<div style="text-align:center;clear:both;"><h2>General Report (<?php
echo HTML::getMonthName($intMonth) . " " . $intYear;
?>
)</h2></div>
<!-- In-Store -->
<div style="clear:both;"><h3 style="font-size:1.3em;">In-Store</h3></div>
<table class="table table-bordered table-hover">
<thead class="well">
<tr>
<th style="text-align:center;width:20%;"><strong>Store</strong></th>
<?php
// Get the In-Store activities
$queryInStore = "SELECT * FROM `mbs_activities` WHERE `activity_category` = 'in-store' AND `activity_store_related` = 'yes' ORDER BY `activity_name`";
$resultInStore = mysql_query($queryInStore);
$intCountIntStore = mysql_num_rows($resultInStore);
$arrDataInStoreAct = array();
while ($rowInStore = mysql_fetch_assoc($resultInStore)) {
$arrDataInStoreAct[] = $rowInStore;
?>
<th style="text-align:center;"><strong><?php
echo htmlspecialchars($rowInStore['activity_name']);
?>
</strong></th>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
$queryStore = "SELECT * FROM `mbs_stores` ORDER BY `store_name`";
$resultStore = mysql_query($queryStore);
while ($rowStore = mysql_fetch_assoc($resultStore)) {
?>
<tr>
<td><div style="text-align:left;"><?php
echo htmlspecialchars($rowStore['store_name']);
?>
</div></td>
<?php
for ($i = 0; $i < $intCountIntStore; $i++) {
$arrInStoreResult = DB::checkActivityInStoreByDateTime($arrDataInStoreAct[$i]['activity_id'], $rowStore['store_id'], $intYear, $intMonth);
$strBookingCode = DB::dbIDToField('mbs_bookings', 'booking_id', $arrInStoreResult['booking_id'], 'booking_code');
$strBookingName = DB::dbIDToField('mbs_bookings', 'booking_id', $arrInStoreResult['booking_id'], 'booking_name');
?>
<td style="background-color:<?php
if (count($arrInStoreResult) > 1) {
?>
#f2dede<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
#ddd<?php
} else {
?>
#dff0d8<?php
}
?>
;">
<div style="text-align:center;font-size:0.8em;">
<?php
if (count($arrInStoreResult) > 1) {
?>
<a href="booking_view.php?booking_id=<?php
echo $arrInStoreResult['booking_id'];
?>
&action=view#id<?php
echo $arrInStoreResult['booking_activity_id'];
?>
" title="<?php
echo htmlspecialchars($strBookingCode);
?>
/ <?php
echo htmlspecialchars($strBookingName);
?>
"><em><?php
echo htmlspecialchars($strBookingCode);
?>
</em></a>
<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
N/A
<?php
} else {
?>
<a href="booking.php?action=add&frm_activity_id=<?php
echo $arrDataInStoreAct[$i]['activity_id'];
?>
&frm_store_id=<?php
echo $rowStore['store_id'];
?>
" style="color:#468847;">Available</a>
<?php
}
?>
</div>
</td>
<?php
}
?>
</tr>
<?php
}
// while ($rowStore = mysql_fetch_assoc($resultStore))
?>
</tbody>
<tfoot>
<!--Sub Total-->
<tr>
<td><div style="text-align:right;"><strong>Sub-Total</strong></div></td>
<?php
for ($i = 0; $i < $intCountIntStore; $i++) {
$arrInStoreSubTotal = DB::getActivityInStoreTotalByDateTime($arrDataInStoreAct[$i]['activity_id'], $intYear, $intMonth);
$strInStoreSubTotal = $arrInStoreSubTotal['booking_activity_price_total'];
$strInStoreSubTotal = $strInStoreSubTotal;
$strInStoreTotal += $strInStoreSubTotal;
?>
<td><div style="text-align:right;">$<?php
echo htmlspecialchars(number_format($strInStoreSubTotal, 2));
?>
</div></td>
<?php
}
?>
</tr>
<!-- Total -->
<tr>
<td colspan="<?php
echo $intCountIntStore;
?>
"><div style="text-align:right;"><strong>Total</strong></div></td>
<td style="background-color:#ddd;"><div style="text-align:right;"><strong>$<?php
echo htmlspecialchars(number_format($strInStoreTotal, 2));
?>
</strong></div></td>
</tr>
</tfoot>
</table>
<!-- Catalogue -->
<div style="clear:both;"><h3 style="font-size:1.3em;">Catalogue</h3></div>
<table class="table table-bordered table-hover">
<thead class="well">
<tr>
<th style="text-align:center;width:20%;"><strong>Size/Spot</strong></th>
<th style="text-align:center;"><strong>Booking</strong></th>
<th style="text-align:center;width:20%;"><strong>Total</strong></th>
</tr>
</thead>
<tbody>
<?php
$queryCatalogue = "SELECT * FROM `mbs_activities` WHERE `activity_category` = 'catalogue' ORDER BY `activity_name`";
$resultCatalogue = mysql_query($queryCatalogue);
while ($rowCatalogue = mysql_fetch_assoc($resultCatalogue)) {
$arrCatalogue = DB::getActivityByDateTime($rowCatalogue['activity_id'], $intYear, $intMonth);
$strBookingCode = DB::dbIDToField('mbs_bookings', 'booking_id', $arrCatalogue['booking_id'], 'booking_code');
$strBookingName = DB::dbIDToField('mbs_bookings', 'booking_id', $arrCatalogue['booking_id'], 'booking_name');
$strCataloguePrice = $arrCatalogue['booking_activity_price_total'];
$strCataloguePriceTotal += $strCataloguePrice;
?>
<tr>
<td><div style="text-align:left;"><?php
echo htmlspecialchars($rowCatalogue['activity_name']);
?>
</div></td>
<td style="background-color:<?php
if (count($arrCatalogue) > 1) {
?>
#f2dede<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
#ddd<?php
} else {
?>
#dff0d8<?php
}
?>
;">
<div style="text-align:center;">
<?php
if (count($arrCatalogue) > 1) {
?>
<a href="booking_view.php?booking_id=<?php
echo $arrCatalogue['booking_id'];
?>
&action=view#id<?php
echo $arrCatalogue['booking_activity_id'];
?>
" title="<?php
echo htmlspecialchars($strBookingCode);
?>
/ <?php
echo htmlspecialchars($strBookingName);
?>
"><em><?php
echo htmlspecialchars($strBookingCode);
?>
</em></a>
<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
N/A
<?php
} else {
?>
<a href="booking.php?action=add&frm_activity_id=<?php
echo $rowCatalogue['activity_id'];
?>
" style="color:#468847;">Available</a>
<?php
}
?>
</div>
</td>
<td><div style="text-align:right;">$<?php
echo htmlspecialchars(number_format($strCataloguePrice));
?>
</div></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<td colspan="2"><div style="text-align:right;"><strong>Total</strong></div></td>
<td style="background-color:#ddd;"><div style="text-align:right;"><strong>$<?php
echo htmlspecialchars(number_format($strCataloguePriceTotal, 2));
?>
</strong></div></td>
</tfoot>
</table>
<!-- Newspaper -->
<div style="clear:both;"><h3 style="font-size:1.3em;">Newspaper</h3></div>
<table class="table table-bordered table-hover">
<thead class="well">
<tr>
<th style="text-align:center;width:20%;"><strong>Size/Spot</strong></th>
<th style="text-align:center;"><strong>Booking</strong></th>
<th style="text-align:center;width:20%;"><strong>Total</strong></th>
</tr>
</thead>
<tbody>
<?php
$queryNewspaper = "SELECT * FROM `mbs_activities` WHERE `activity_category` = 'newspaper' ORDER BY `activity_name`";
$resultNewspaper = mysql_query($queryNewspaper);
while ($rowNewspaper = mysql_fetch_assoc($resultNewspaper)) {
$arrNewspaper = DB::getActivityByDateTime($rowNewspaper['activity_id'], $intYear, $intMonth);
$strBookingCode = DB::dbIDToField('mbs_bookings', 'booking_id', $arrNewspaper['booking_id'], 'booking_code');
$strBookingName = DB::dbIDToField('mbs_bookings', 'booking_id', $arrNewspaper['booking_id'], 'booking_name');
$strNewspaperPrice = $arrNewspaper['booking_activity_price_total'];
$strNewspaperPriceTotal += $strNewspaperPrice;
?>
<tr>
<td><div style="text-align:left;"><?php
echo htmlspecialchars($rowNewspaper['activity_name']);
?>
</div></td>
<td style="background-color:<?php
if (count($arrNewspaper) > 1) {
?>
#f2dede<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
#ddd<?php
} else {
?>
#dff0d8<?php
}
?>
;">
<div style="text-align:center;">
<?php
if (count($arrNewspaper) > 1) {
?>
<a href="booking_view.php?booking_id=<?php
echo $arrNewspaper['booking_id'];
?>
&action=view#id<?php
echo $arrNewspaper['booking_activity_id'];
?>
" title="<?php
echo htmlspecialchars($strBookingCode);
?>
/ <?php
echo htmlspecialchars($strBookingName);
?>
"><em><?php
echo htmlspecialchars($strBookingCode);
?>
</em></a>
<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
N/A
<?php
} else {
?>
<a href="booking.php?action=add&frm_activity_id=<?php
echo $rowNewspaper['activity_id'];
?>
" style="color:#468847;">Available</a>
<?php
}
?>
</div>
</td>
<td><div style="text-align:right;">$<?php
echo htmlspecialchars(number_format($strNewspaperPrice));
?>
</div></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<td colspan="2"><div style="text-align:right;"><strong>Total</strong></div></td>
<td style="background-color:#ddd;"><div style="text-align:right;"><strong>$<?php
echo htmlspecialchars(number_format($strNewspaperPriceTotal, 2));
?>
</strong></div></td>
</tfoot>
</table>
<!-- Email -->
<div style="clear:both;"><h3 style="font-size:1.3em;">4 YOU Email</h3></div>
<table class="table table-bordered table-hover">
<thead class="well">
<tr>
<th style="text-align:center;width:20%;"><strong>Size/Spot</strong></th>
<th style="text-align:center;"><strong>Booking</strong></th>
<th style="text-align:center;width:20%;"><strong>Total</strong></th>
</tr>
</thead>
<tbody>
<?php
$queryEmail = "SELECT * FROM `mbs_activities` WHERE `activity_category` = 'email' ORDER BY `activity_name`";
$resultEmail = mysql_query($queryEmail);
while ($rowEmail = mysql_fetch_assoc($resultEmail)) {
$arrEmail = DB::getActivityByDateTime($rowEmail['activity_id'], $intYear, $intMonth);
$strBookingCode = DB::dbIDToField('mbs_bookings', 'booking_id', $arrEmail['booking_id'], 'booking_code');
$strBookingName = DB::dbIDToField('mbs_bookings', 'booking_id', $arrEmail['booking_id'], 'booking_name');
$strEmailPrice = $arrEmail['booking_activity_price_total'];
$strEmailPriceTotal += $strEmailPrice;
?>
<tr>
<td><div style="text-align:left;"><?php
echo htmlspecialchars($rowEmail['activity_name']);
?>
</div></td>
<td style="background-color:<?php
if (count($arrEmail) > 1) {
?>
#f2dede<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
#ddd<?php
} else {
?>
#dff0d8<?php
}
?>
;">
<div style="text-align:center;">
<?php
if (count($arrEmail) > 1) {
?>
<a href="booking_view.php?booking_id=<?php
echo $arrEmail['booking_id'];
?>
&action=view#id<?php
echo $arrEmail['booking_activity_id'];
?>
" title="<?php
echo htmlspecialchars($strBookingCode);
?>
/ <?php
echo htmlspecialchars($strBookingName);
?>
"><em><?php
echo htmlspecialchars($strBookingCode);
?>
</em></a>
<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
N/A
<?php
} else {
?>
<a href="booking.php?action=add&frm_activity_id=<?php
echo $rowEmail['activity_id'];
?>
" style="color:#468847;">Available</a>
<?php
}
?>
</div>
</td>
<td><div style="text-align:right;">$<?php
echo htmlspecialchars(number_format($strEmailPrice));
?>
</div></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<td colspan="2"><div style="text-align:right;"><strong>Total</strong></div></td>
<td style="background-color:#ddd;"><div style="text-align:right;"><strong>$<?php
echo htmlspecialchars(number_format($strEmailPriceTotal, 2));
?>
</strong></div></td>
</tfoot>
</table>
<!-- Other -->
<div style="clear:both;"><h3 style="font-size:1.3em;">Other</h3></div>
<table class="table table-bordered table-hover">
<thead class="well">
<tr>
<th style="text-align:center;width:20%;"><strong>Activity</strong></th>
<th style="text-align:center;"><strong>Booking</strong></th>
<th style="text-align:center;width:20%;"><strong>Total</strong></th>
</tr>
</thead>
<tbody>
<?php
$queryOther = "SELECT * FROM `mbs_activities` WHERE `activity_category` = 'other' ORDER BY `activity_name`";
$resultOther = mysql_query($queryOther);
while ($rowOther = mysql_fetch_assoc($resultOther)) {
$arrOther = DB::getActivityByDateTime($rowOther['activity_id'], $intYear, $intMonth);
$strBookingCode = DB::dbIDToField('mbs_bookings', 'booking_id', $arrOther['booking_id'], 'booking_code');
$strBookingName = DB::dbIDToField('mbs_bookings', 'booking_id', $arrOther['booking_id'], 'booking_name');
$strOtherPrice = $arrOther['booking_activity_price_total'];
$strOtherPriceTotal += $strOtherPrice;
?>
<tr>
<td><div style="text-align:left;"><?php
echo htmlspecialchars($rowOther['activity_name']);
?>
</div></td>
<td style="background-color:<?php
if (count($arrOther) > 1) {
?>
#f2dede<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
#ddd<?php
} else {
?>
#dff0d8<?php
}
?>
;">
<div style="text-align:center;">
<?php
if (count($arrOther) > 1) {
?>
<a href="booking_view.php?booking_id=<?php
echo $arrOther['booking_id'];
?>
&action=view#id<?php
echo $arrOther['booking_activity_id'];
?>
" title="<?php
echo htmlspecialchars($strBookingCode);
?>
/ <?php
echo htmlspecialchars($strBookingName);
?>
"><em><?php
echo htmlspecialchars($strBookingCode);
?>
</em></a>
<?php
} elseif (mktime(0, 0, 0, $intMonth, 1, $intYear) < time() + $intMinBookingTime) {
?>
N/A
<?php
} else {
?>
<a href="booking.php?action=add&frm_activity_id=<?php
echo $rowOther['activity_id'];
?>
" style="color:#468847;">Available</a>
<?php
}
?>
</div>
</td>
<td><div style="text-align:right;">$<?php
echo htmlspecialchars(number_format($strOtherPrice));
?>
</div></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<td colspan="2"><div style="text-align:right;"><strong>Total</strong></div></td>
<td style="background-color:#ddd;"><div style="text-align:right;"><strong>$<?php
echo htmlspecialchars(number_format($strOtherPriceTotal, 2));
?>
</strong></div></td>
</tfoot>
</table>
<div style="clear:both;"><h3 style="font-size:1.3em;">Summary</h3></div>
<table class="table table-bordered table-hover">
<thead class="well">
<tr>
<th style="text-align:center;width:20%;"><strong>Summary</strong></th>
<th style="text-align:center;width:20%;"><strong>Data</strong></th>
<th style="text-align:center;"><strong>Chart</strong></th>
</tr>
</thead>
<tbody>
<?php
$strTotal = $strInStoreTotal + $strCataloguePriceTotal + $strNewspaperPriceTotal + $strEmailPriceTotal + $strOtherPriceTotal;
?>
<tr>
<td><div style="text-align:left;">In-Store</div></td>
<td><div style="text-align:right;"><strong>$<?php
echo number_format($strInStoreTotal);
?>
</strong></div></td>
<td rowspan="6"><div id="chart"></div></td>
</tr>
<tr>
<td><div style="text-align:left;">Catalogue</div></td>
<td><div style="text-align:right;"><strong>$<?php
echo number_format($strCataloguePriceTotal);
?>
</strong></div></td>
</tr>
<tr>
<td><div style="text-align:left;">Newspaper</div></td>
<td><div style="text-align:right;"><strong>$<?php
echo number_format($strNewspaperPriceTotal);
?>
</strong></div></td>
</tr>
<tr>
<td><div style="text-align:left;">4 YOU Email</div></td>
<td><div style="text-align:right;"><strong>$<?php
echo number_format($strEmailPriceTotal);
?>
</strong></div></td>
</tr>
<tr>
<td><div style="text-align:left;">Other</div></td>
<td><div style="text-align:right;"><strong>$<?php
echo number_format($strOtherPriceTotal);
?>
</strong></div></td>
</tr>
<tr>
<td><div style="text-align:left;"><strong>Total Amount</strong></div></td>
<td style="background-color:#ccc;">
<div style="text-align:right;"><strong>$<?php
echo number_format($strTotal);
?>
</strong></div>
</td>
</tr>
</tbody>
<tfoot>
</tfoot>
</table>
<script>
$(document).ready(function(){
var data = [
['In-Store', <?php
echo $strInStoreTotal;
?>
],['Catalogue', <?php
echo $strCataloguePriceTotal;
?>
], ['Newspaper', <?php
echo $strNewspaperPriceTotal;
?>
],
['4 You Email', <?php
echo $strEmailPriceTotal;
?>
],['Other', <?php
echo $strOtherPriceTotal;
?>
]
];
var plot = jQuery.jqplot ('chart', [data],
{
seriesDefaults: {
// Make this a pie chart.
renderer: jQuery.jqplot.PieRenderer,
rendererOptions: {
// Put data labels on the pie slices.
// By default, labels show the percentage of the slice.
showDataLabels: true
}
},
title: 'Revenue <?php
echo HTML::getMonthName($intMonth) . " " . $intYear;
?>
',
grid: {
drawBorder: false,
drawGridlines: false,
background: '#ffffff',
shadow:false
},
seriesColors:['#f00', '#0f0', '#00f', '#fa0', '#b51be0'],
legend: { show:true, location: 'e' }
}
);
});
</script>
<?php
// The Log
$strLog = "View monthly General Report for \"" . HTML::getMonthName($intMonth) . " " . $intYear . "\"";
$queryLog = "INSERT INTO `logs` (`log_id`, \n\t\t\t\t\t\t\t\t\t\t `log_user`, \n\t\t\t\t\t\t\t\t\t\t `log_action`, \n\t\t\t\t\t\t\t\t\t\t `log_time`, \n\t\t\t\t\t\t\t\t\t\t `log_from`, \n\t\t\t\t\t\t\t\t\t\t `log_logout`)\n\n\t\t\t\t\tVALUES (NULL, \n\t\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($strLog) . "',\n\t\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "',\n\t\t\t\t\t\t\t'" . $_SESSION['user']['ip_address'] . "', \n\t\t\t\t\t\t\tNULL)";
$resultLog = mysql_query($queryLog);
#echo "<div class='well' style=''>";
#echo "<strong>Debug:</strong><br />";
#print_r($_REQUEST);
#echo "</div>";
}
function generateBookingCode()
{
DB::dbConnect();
$query = "SHOW TABLE STATUS LIKE 'mbs_bookings'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$intIncrement = $row['Auto_increment'];
$intIncrementLength = strlen($intIncrement);
$strResult = "P4L";
$intCount = 12 - intval(strlen($strResult)) - intval($intIncrementLength);
for ($i = 0; $i < $intCount; $i++) {
$strResult .= "0";
}
$strResult .= $intIncrement;
return $strResult;
}
function saveLoginInfo($logID)
{
$this->conn = DB::dbConnect();
$query = "UPDATE `logs` \n\t\t \t SET `log_logout` = '" . date("Y-m-d H:i:s") . "' \n\t\t\t\t WHERE `log_id` = '" . $logID . "'";
$result = mysql_query($query);
// update user table
$query2 = "UPDATE `users` SET `user_last_login_time` = '" . $_SESSION['user']['login_time'] . "', \n\t\t\t\t\t\t\t\t\t `user_last_login_from` = '" . $_SESSION['user']['ip_address'] . "' \n\t\t\t\t\t\t\t\tWHERE `user_id` = '" . $_SESSION['user']['id'] . "' LIMIT 1";
$result2 = mysql_query($query2);
/* add log table */
$result3 = mysql_query("INSERT INTO `logs` \n\t\t\t\t\t\t\t\t(log_user,\n\t\t\t\t\t\t\t\t log_action,\n\t\t\t\t\t\t\t\t log_time,\n\t\t\t\t\t\t\t\t log_from)\n\t\n\t\t\t\t\t\t\t\t VALUES ('" . $_SESSION['user']['login_name'] . "',\n\t\t\t\t\t\t\t\t 'Logout successfully from " . $_SESSION['user']['ip_address'] . "',\n\t\t\t\t\t\t\t\t\t\t '" . date('Y-m-d H:i:s') . "',\n\t\t\t\t\t\t\t\t\t\t '" . $_SESSION['user']['ip_address'] . "')");
if ($result) {
return 1;
} else {
return 0;
}
}
function viewEmail()
{
$this->conn = DB::dbConnect();
$query = "SELECT mbs_emails.email_created_date,mbs_emails.email_created_by,mbs_emails.email_modified_date,mbs_emails.email_modified_by,mbs_emails.email_id, mbs_emails.email_name, mbs_emails.email_address, mbs_emails.email_id, mbs_stores.store_name FROM (mbs_emails left join mbs_stores on mbs_emails.store_id = mbs_stores.store_id)\n\n\t\t WHERE mbs_emails.email_id = '" . $_REQUEST['email_id'] . "' LIMIT 1";
//$query = "SELECT * FROM `mbs_emails` WHERE `email_id` = '" . $_REQUEST['email_id'] . "' LIMIT 1";
$result = mysql_query($query);
if ($result) {
$row = mysql_fetch_assoc($result);
?>
<h2>Email Information » <?php
echo stripslashes($row['email_name']);
?>
</h2>
<table cellpadding="5" cellspacing="1" border="0">
<tr>
<td colspan="2">
<div align="left">
<?php
if ($_SESSION['user']['type'] == 'admin') {
?>
<a class="btn" href="email_add.php" title="New Email"><img src="<?php
echo $STR_URL;
?>
img/add_icon.png" /> New Email</a> <a class="btn" href="email_edit.php?email_id=<?php
echo $row['email_id'];
?>
" title="Edit Email"><img src="<?php
echo $STR_URL;
?>
img/edit_icon.png" /> Edit</a> <a class="btn" href="email_delete.php?email_id=<?php
echo $row['email_id'];
?>
&action=delete" title="Delete Email" onclick="return confirmDeleteEmail(this.form)"><img src="<?php
echo $STR_URL;
?>
img/delete_icon.png" /> Delete</a> <a class="btn" href="email_list.php" title="Email List"><img src="<?php
echo $STR_URL;
?>
img/list_icon.png" /> List</a><?php
} else {
echo ' ';
}
?>
</div>
</td>
</tr>
<tr>
<td width="30%"><strong>Store</strong></td>
<td>: <strong><?php
echo stripslashes($row['store_name']);
?>
</strong></td>
</tr>
<tr>
<td width="30%"><strong>Name</strong></td>
<td>: <strong><?php
echo stripslashes($row['email_name']);
?>
</strong></td>
</tr>
<tr>
<td><strong>Email Address</strong></td>
<td>: <?php
echo stripslashes($row['email_address']);
?>
</td>
</tr>
</table>
<ul>
<li><strong>Created on:</strong> <?php
echo HTML::convertDateTime($row['email_created_date']);
?>
by <strong><?php
echo stripslashes($row['email_created_by']);
?>
</strong></li>
<li><strong>Last modified on:</strong> <?php
echo HTML::convertDateTime($row['email_modified_date']);
?>
by <strong><?php
echo stripslashes($row['email_modified_by']);
?>
</strong></li>
</ul>
<?php
} else {
echo "<div align=\"center\"><p><strong>Found no data!</strong></p></div>";
}
?>
<div align="center">
<form name="myform" action="<?php
if (preg_match("/_exec/", $_SERVER['HTTP_REFERER'])) {
if ($_SESSION['user']['type'] == 'admin') {
echo "email_list.php";
} else {
echo "email_list.php";
}
} else {
echo $_SERVER['HTTP_REFERER'];
}
?>
">
<input class="btn" type="submit" value="Back">
</form>
</div>
<?php
}
function listBooking()
{
global $arrSiteConfig;
global $STR_URL;
global $TABLE_MAX_ROW_PER_PAGE;
DB::dbConnect();
// If page number not set, set it to 1
if (!$_REQUEST['page_num']) {
$_REQUEST['page_num'] = 1;
}
// Setting queries and pages
$offset = ($_REQUEST['page_num'] - 1) * $TABLE_MAX_ROW_PER_PAGE;
$this->conn = DB::dbConnect();
$strSearchText = stripslashes($_REQUEST['frm_search_text']);
// sort variables
if (!$_REQUEST['sortmode']) {
$_REQUEST['sortmode'] = "asc";
}
$strSortMode = $_REQUEST['sortmode'];
if ($_REQUEST['frm_search_text']) {
// search query *********************************************************************************
$query = "SELECT * FROM `mbs_bookings` \n\t\t\t\t\t \t\t WHERE (`booking_name` LIKE '%" . mysql_real_escape_string($strSearchText) . "%'\n\t\t\t\t\t \t\t \t\t OR `booking_code` LIKE '%" . mysql_real_escape_string($strSearchText) . "%' \n\t\t\t\t\t \t\t\t OR `booking_description` LIKE '%" . mysql_real_escape_string($strSearchText) . "%')\n\t\t\t\t\t \t\t\t ORDER BY ";
if ($_REQUEST['sortby']) {
$query .= "`" . mysql_real_escape_string($_REQUEST['sortby']) . "` " . $strSortMode . ", `booking_id`";
} else {
$query .= "`booking_code` ASC, `booking_name` ASC, `booking_created_date` DESC";
}
$query .= " LIMIT " . $offset . "," . $TABLE_MAX_ROW_PER_PAGE;
// search query total ***************************************************************************
$queryTotal = "SELECT COUNT(*) FROM `mbs_bookings` \n\t\t\t\t\t \t\t\t WHERE (`booking_name` LIKE '%" . mysql_real_escape_string($strSearchText) . "%' \n\t\t\t\t\t \t\t\t \t OR `booking_code` LIKE '%" . mysql_real_escape_string($strSearchText) . "%'\n\t\t\t\t\t \t\t\t OR `booking_description` LIKE '%" . mysql_real_escape_string($strSearchText) . "%')";
} else {
// the query ************************************************************************************
$query = "SELECT * FROM `mbs_bookings` ORDER BY ";
if ($_REQUEST['sortby']) {
$query .= " `" . mysql_real_escape_string($_REQUEST['sortby']) . "` " . $strSortMode . ", `booking_id`";
} else {
$query .= " `booking_code`, `booking_name`";
}
$query .= " LIMIT " . $offset . "," . $TABLE_MAX_ROW_PER_PAGE;
// the query total ******************************************************************************
$queryTotal = "SELECT COUNT(*) FROM `mbs_bookings`";
}
$result = mysql_query($query, $this->conn);
$resultTotal = mysql_query($queryTotal, $this->conn);
$rowTotal = mysql_fetch_row($resultTotal);
$totalPage = ceil($rowTotal[0] / $TABLE_MAX_ROW_PER_PAGE);
$strResult = "";
#echo "<div style=\"padding:15px; background-color:#eee;\">";
#echo "<strong>Query:</strong> " . $query . "<br /><br />";
#echo "<strong>Query Total:</strong> " . $queryTotal . "<br /><br />";
#echo "</div>";
// javascript to pop up message
$strResult .= "\n\t\t\n\t\t\t\t\t";
// search form
$strResult .= "\n\t\t\t<form name=\"search_booking_data\" method=\"post\" action=\"" . $STR_URL . "booking_list.php\">\n\t\t\t\t<input type=\"hidden\" name=\"frm_search_referer\" value=\"" . $_SERVER['PHP_SELF'] . "\" />\n\t\t\t\t<input type=\"text\" name=\"frm_search_text\" size=\"40\" maxlength=\"128\" value=\"";
if ($_REQUEST['frm_search_text']) {
$strResult .= stripslashes($_REQUEST['frm_search_text']);
}
$strResult .= "\" />\t\t\t\t\n\t\t\t\t<input class=\"btn\" type=\"submit\" name=\"frm_search_submit\" value=\"Search Bookings\" onclick=\"return validateSearch(this.form)\" /><br />\n\t\t\t</form>\n\t\t\t";
// the form
$strResult .= "\n\t\t\t<form id=\"frm_booking\" method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\" />\n\t\t\t";
$strResult .= "<div align=\"right\">";
// the refresh link
if ($_SESSION['user']['type'] == 'admin' || ADMIN::getModulePrivilege('bookings', 'list') !== 0) {
$strResult .= "<a class=\"btn\" href=\"" . $STR_URL . ADMIN::getModuleFile('bookings', 'list') . "\" title=\"Booking List\"><img src=\"" . $STR_URL . "img/refresh_icon.png\" /> Refresh</a>";
}
$strResult .= " ";
// the add link
if ($_SESSION['user']['type'] == 'admin' || ADMIN::getModulePrivilege('bookings', 'add') !== 0) {
$strResult .= "<a class=\"btn ajax callbacks cboxElement\" href=\"" . $STR_URL . ADMIN::getModuleFile('bookings', 'add') . "?pop=yes\" title=\"New Booking\"><img src=\"" . $STR_URL . "img/add_icon.png\" /> New Booking</a>";
}
$strResult .= "\t</div>";
if ($strSortMode == "asc") {
$strSortMode = "desc";
} elseif ($strSortMode == "desc") {
$strSortMode = "asc";
}
// the table
$strResult .= "\t\t\t\n\t\t\t<div align=\"center\"><h2>Booking List</h2></div>\n\t\t\t<div align=\"right\">" . HTML::showPaging($rowTotal[0], $totalPage, 4, array(array('frm_search_text', urlencode($_REQUEST['frm_search_text'])), array('pop', urlencode('yes')), array('sortby', urlencode($_REQUEST['sortby'])), array('sortmode', urlencode($_REQUEST['sortmode'])))) . "</div>\n\n\t\t\t<section id=\"table_booking_list\">\n\t\t\t<table class=\"table table-bordered table-hover\" summary=\"Booking List\">\n\t\t\t<caption>Booking List</caption>\n\t\t\t<thead>\n\t\t\t\t<tr>\t\t\t\t\t\n\t\t\t\t\t<th scope=\"col\" width=\"5%\"><div align=\"center\">No</div></th>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t<th scope=\"col\"><div align=\"center\"><a href=\"" . $_SERVER['PHP_SELF'] . "?page_num=" . intval($_REQUEST['page_num']) . "&frm_search_text=" . urlencode($_REQUEST['frm_search_text']) . "&sortby=booking_name&sortmode=" . $strSortMode . "\">Code/Name</a></div></th>\n\t\t\t\t\t<th scope=\"col\"><div align=\"center\"><a href=\"" . $_SERVER['PHP_SELF'] . "?page_num=" . intval($_REQUEST['page_num']) . "&frm_search_text=" . urlencode($_REQUEST['frm_search_text']) . "&sortby=booking_normal_retail_price&sortmode=" . $strSortMode . "\">Normal Retail Price</a></div></th>\n\t\t\t\t\t<th scope=\"col\"><div align=\"center\"><a href=\"" . $_SERVER['PHP_SELF'] . "?page_num=" . intval($_REQUEST['page_num']) . "&frm_search_text=" . urlencode($_REQUEST['frm_search_text']) . "&sortby=booking_promo_price&sortmode=" . $strSortMode . "\">Promo Price</a></div></th>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t";
// edit / delete column
if ($_SESSION['user']['type'] == 'admin' || ADMIN::getModulePrivilege('bookings', 'edit') !== 0 && $_SESSION['user']['type'] == 'user' || ADMIN::getModulePrivilege('bookings', 'delete') !== 0 && $_SESSION['user']['type'] == 'user') {
$strResult .= "\t\n\t\t\t\t\t<th scope=\"col\" width=\"20%\"><div align=\"center\">Edit/Delete</div></th>\n\t\t\t\t\t";
}
$strResult .= "\n\t\t\t\t</tr>\n\t\t\t</thead>\t\n\t\t\t\n\t\t\t<tbody>\n\t\t\t";
if ($rowTotal[0] > 0) {
$no = $offset;
while ($row = mysql_fetch_assoc($result)) {
$no++;
// link
$strLink = ADMIN::getModuleFile('bookings', 'view') . "?booking_id=" . urlencode($row['booking_id']) . "&frm_search_text=" . urlencode($_REQUEST['frm_search_text']) . "&page_num=" . $_REQUEST['page_num'] . "&pop=yes";
$strResult .= "\n\t\t\t\t\t\t<tr ";
if ($no % 2 == 0) {
$strResult .= "class=\"odd\"";
}
$strResult .= ">\n\t\t\t\t\t\t\t<td id=\"r" . $row['booking_id'] . "\"><div align=\"right\">" . $no . ".</div></td>\t\t\t\t\t\t\n\t\t\t\t\t\t\t<td><div align=\"left\">";
if ($_SESSION['user']['type'] == 'admin' || $strPrivView == "yes") {
$strResult .= "<a class=\"ajax callbacks cboxElement\" href=\"" . $STR_URL . $strLink . "\" title=\"" . html_entity_decode(strtoupper($row['booking_name'])) . "\">";
}
$strResult .= "<strong>" . html_entity_decode(stripslashes($row['booking_code'])) . " / " . html_entity_decode(stripslashes($row['booking_name'])) . "</strong>";
if ($_SESSION['user']['type'] == 'admin' || $strPrivView == "yes") {
"</a>";
}
$strResult .= "</div></td>\n\t\t\t\t\t\t\t<td><div align=\"right\"><strong>\$" . html_entity_decode(stripslashes($row['booking_normal_retail_price'])) . "</strong></div></td>\n\t\t\t\t\t\t\t<td><div align=\"right\"><strong>\$" . html_entity_decode(stripslashes($row['booking_promo_price'])) . "</strong></div></td>\t\t\t\t\t\t\t\n\t\t\t\t\t\t";
// action column
if ($_SESSION['user']['type'] == 'admin' || ADMIN::getModulePrivilege('bookings', 'edit') !== 0 && $_SESSION['user']['type'] == 'user' || ADMIN::getModulePrivilege('bookings', 'delete') !== 0 && $_SESSION['user']['type'] == 'user') {
$strResult .= "<td><div align=\"center\">";
// edit
if ($_SESSION['user']['type'] == 'admin' || ADMIN::getModulePrivilege('bookings', 'edit') !== 0 && $_SESSION['user']['type'] == 'user') {
$strResult .= "<a class=\"btn ajax callbacks cboxElement\" href=\"" . $STR_URL . "booking.php?booking_id=" . html_entity_decode($row['booking_id']) . "&action=edit&pop=yes\" title=\"Edit Booking\"><img src=\"" . $STR_URL . "img/edit_icon.png\" /> Edit</a>";
}
$strResult .= " ";
// delete
if ($_SESSION['user']['type'] == 'admin' || ADMIN::getModulePrivilege('bookings', 'delete') !== 0 && $_SESSION['user']['type'] == 'user') {
$strResult .= "<a id=\"frm_delete_button_" . $row['booking_id'] . "\" class=\"btn\" href=\"" . $STR_URL . "booking_list.php?booking_id=" . $row['booking_id'] . "&action=delete\" title=\"Delete Booking\"><img src=\"" . $STR_URL . "img/delete_icon.png\" /> Delete</a> ";
}
$strResult .= "</div></td>";
}
$strResult .= "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
// end while($row = )
} else {
$strResult .= "<tr><td colspan=\"5\"><div align=\"center\">Found no data</div></td></tr>";
}
$strResult .= "\n\t\t\t</tbody>\n\t\t\t<tfoot>\n\t\t\t\t<tr>\n\t\t\t\t\t<th scope=\"row\" colspan=\"2\">Total: " . $rowTotal[0] . "</th>\t\t\t\t\t\n\t\t\t\t\t<td colspan=\"3\">" . HTML::showPaging($rowTotal[0], $totalPage, 4, array(array('frm_search_text', urlencode($_REQUEST['frm_search_text'])), array('pop', urlencode('yes')), array('sortby', urlencode($_REQUEST['sortby'])), array('sortmode', urlencode($_REQUEST['sortmode'])))) . "</td>\n\t\t\t\t</tr>\n\t\t\t</tfoot>\n\t\t\t</table>\n\t\t\t</section>\n\t\t\t</form>\n\t\t\t<a class=\"btn\" href=\"#content\"><i class=\"icon-arrow-up\"></i> Back to top</a>\n\n\n\t\t\t<script>\n\t\t\t\t\$(document).ready(function () {\n\t\t\t\t\tvar strID;\n\t\t\t\t\tvar intID;\n\t\t\t\t\tvar deleteConf;\t\n\t\t\t\n\t\t\t\t\t\$('a').click(function(event) {\n \t\t\t\tstrID = event.target.id; \t\t\t\t \t\t\t\t\n\t\t\t\t\t\tintID = strID.replace('frm_delete_button_', '');\t\t\t\t\t\t\n\n\t\t\t\t\t\tif (intID && intID !== '')\n\t\t\t\t\t\t{\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tif (confirmDeleteBooking())\n\t\t\t\t\t\t\t{\n\t\t\t\t\t\t\t\t\$(this).closest('tr').remove();\t\n\n\t\t\t\t\t\t\t\tvar dataString = 'action=delete&booking_id=' + intID;\t\t\t\t\t\t\t\n\t\t \t\t\t\t \n\t\t\t\t\t\t\t\tvar request = \$.ajax({\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\turl: 'ajax/booking_proc.php',\n\t\t\t\t\t\t\t\t\ttype: 'post', \n\t\t\t\t\t\t\t\t\tdata: dataString,\n\t\t\t\t\t\t\t\t\tsuccess: function(msg) {\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\$.gritter.add({\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\ttitle: 'Info',\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\ttext: '<p>' + msg + '</p>',\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\timage: '" . $STR_URL . "img/accepted.png',\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\tsticky: false,\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\ttime: '3000'\n\t\t\t\t\t\t\t\t\t\t});\n\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t});\t\t\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t}\n\n\t\t\t\t\t\t\treturn false;\t\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t}\t\t\t\n\t\t\t\t\t\t\n \t\t\t\t});\n \n\t\t\t\t});\n\t\t\t</script>\n\t\t\t";
// The Log
$strLog = "View the Booking List";
$queryLog = "INSERT INTO `logs` (`log_id`, \n\t\t\t\t\t\t\t\t\t\t `log_user`, \n\t\t\t\t\t\t\t\t\t\t `log_action`, \n\t\t\t\t\t\t\t\t\t\t `log_time`, \n\t\t\t\t\t\t\t\t\t\t `log_from`, \n\t\t\t\t\t\t\t\t\t\t `log_logout`)\n\n\t\t\t\t\tVALUES (NULL, \n\t\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($strLog) . "',\n\t\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "',\n\t\t\t\t\t\t\t'" . $_SESSION['user']['ip_address'] . "', \n\t\t\t\t\t\t\tNULL)";
$resultLog = mysql_query($queryLog);
echo $strResult;
}
