if (!IsBlocked(BIT_BLOCK_ACCREDITATION)) {
foreach ($_REQUEST['New_Division'] as $DivKey => $DivValue) {
foreach ($_REQUEST['New_Class'] as $ClKey => $ClValue) {
$Tuple[$Tuple_Index] = "(" . "''," . StrSafe_DB($_SESSION['TourId']) . ", " . StrSafe_DB($DivValue . $ClValue) . ", " . StrSafe_DB(str_replace(",", ".", $_REQUEST['New_Price'])) . "" . ")";
$Rules[$Tuple_Index] = $DivValue . $ClValue;
++$Tuple_Index;
}
}
foreach ($Tuple as $Key => $Value) {
$Insert = "INSERT INTO AccPrice (APId,APTournament,APDivClass,APPrice) " . "VALUES" . $Value;
$RsIns = safe_w_sql($Insert);
if (debug) {
print $Insert . '<br>';
}
if (safe_w_affected_rows() == 1) {
$xml .= '<new_rule>' . $Rules[$Key] . '</new_rule>' . "\n";
}
}
}
if ($xml == '') {
$Errore = 1;
}
if (!debug) {
header('Content-Type: text/xml');
}
print '<response>' . "\n";
print '<error>' . $Errore . '</error>' . "\n";
print '<confirm_msg>' . get_text('MsgAreYouSure') . '</confirm_msg>' . "\n";
print '<new_price>' . NumFormat(str_replace(",", ".", $_REQUEST['New_Price']), 2) . '</new_price>' . "\n";
print $xml;
print '</response>' . "\n";
$TotalPrice = 0;
$ShowStatusLegend = false;
}
$pdf->SetFont($pdf->FontStd, '', 7);
$pdf->Cell(10, 4, '', 0, 0, 'C', 0);
$pdf->Cell(10, 4, $MyRow->Session, 1, 0, 'R', 0);
$pdf->Cell(15, 4, $MyRow->TargetNo, 1, 0, 'R', 0);
$pdf->Cell(10, 4, $MyRow->Bib, 1, 0, 'R', 0);
$pdf->Cell(45, 4, $MyRow->FirstName . ' ' . $MyRow->Name, 1, 0, 'L', 0);
$pdf->Cell(15, 4, $MyRow->AgeClass, 1, 0, 'C', 0);
$pdf->Cell(10, 4, $MyRow->SubClass, 1, 0, 'C', 0);
$pdf->Cell(15, 4, $MyRow->DivCode, 1, 0, 'C', 0);
$pdf->Cell(15, 4, $MyRow->ClassCode, 1, 0, 'C', 0);
//Disegna i Pallini per la partecipazione
$pdf->DrawParticipantDetails($MyRow->IC, $MyRow->IF, $MyRow->TC, $MyRow->TF, $MyRow->TM);
$pdf->SetDefaultColor();
$pdf->SetFont($pdf->FontStd, '', 7);
$ShowStatusLegend = $ShowStatusLegend || $MyRow->Status != 0;
$pdf->Cell(10, 4, $MyRow->Status == 0 ? '' : $MyRow->Status, 1, 0, 'C', 0);
$pdf->Cell(20, 4, ($MyRow->EnPays == 1 ? NumFormat($MyRow->APPrice, 2) : NumFormat(0, 2)) . " " . $pdf->writeCurrency(), 1, 1, 'R', 0);
$TotalPrice += $MyRow->EnPays == 1 ? $MyRow->APPrice : 0;
}
$pdf->SetFont($pdf->FontStd, '', 8);
$pdf->Cell(165, 15, get_text('Cash', 'Tournament') . ":", 0, 0, 'R', 0);
$pdf->SetFont($pdf->FontStd, 'B', 12);
$pdf->Cell(25, 15, NumFormat($TotalPrice, 2) . " " . $pdf->writeCurrency(), 0, 1, 'R', 0);
safe_free_result($Rs);
}
if (!isset($isCompleteResultBook)) {
$pdf->Output();
}
?>
</table>
<?php
if (!$Error) {
$rank->read();
$data = $rank->getData();
$NumDist = $data['meta']['numDist'];
$curEvent = '';
if (count($data['sections']) > 0) {
print '<form name="Frm" method="post" action="">' . "\n";
if (isset($_REQUEST['EventCode'])) {
print '<input type="hidden" name="EventCode" value="' . $_REQUEST['EventCode'] . '">' . "\n";
}
foreach ($data['sections'] as $section) {
$Colonne = 8 + $NumDist;
$PercPunti = NumFormat(55 / ($NumDist + 3));
print '<table class="Tabella">' . "\n";
print '<tr class="Divider"><td colspan="' . $Colonne . '"></td></tr>' . "\n";
print '<tr><th class="Title" colspan="' . $Colonne . '">' . $section['meta']['descr'] . ' (' . $section['meta']['event'] . ')</th></tr>';
print '<tr>';
print '<th width="5%">' . get_text('Rank') . '</th>';
print '<th width="20%">' . get_text('Archer') . '</th>';
print '<th width="20%" colspan="2">' . get_text('Country') . '</th>';
for ($i = 1; $i <= $NumDist; ++$i) {
print '<th width="8%">Score ' . $i . '</th>';
}
print '<th width="8%">' . get_text('Total') . '</th>';
print '<th width="8%">G</th>';
print '<th width="8%">X</th>';
print '<th>' . get_text('TieArrows') . '</th>';
print '</tr>' . "\n";
$pdf->Cell(30, 5, '', 0, 0, 'C', 0);
if ($isFirstTime) {
$pdf->Cell(30, 5, $MyRow->Data, 1, 0, 'R', 0);
} else {
$pdf->Cell(30, 5, '', 0, 0, 'R', 0);
}
$pdf->Cell(25, 5, $MyRow->Turno, 1, 0, 'R', 0);
$pdf->Cell(30, 5, $MyRow->Accreditati, 1, 0, 'R', 0);
$pdf->Cell(30, 5, $MyRow->Prezzo == 'NoPay' ? get_text('NoPay', 'Tournament') : $MyRow->Prezzo . " " . $pdf->writeCurrency(), 1, 0, 'R', 0);
$pdf->Cell(45, 5, NumFormat($MyRow->Totale, 2) . " " . $pdf->writeCurrency(), 1, 1, 'R', 0);
$TotalDay += $MyRow->Totale;
$Total += $MyRow->Totale;
$isFirstTime = false;
}
$pdf->SetFont($pdf->FontStd, '', 8);
$pdf->Cell(30, 6, '', 0, 0, 'L', 0);
$pdf->Cell(115, 6, get_text('Total') . " " . $OldDate, 0, 0, 'R', 0);
$pdf->SetFont($pdf->FontStd, 'B', 8);
$pdf->Cell(45, 6, NumFormat($TotalDay, 2) . " " . $pdf->writeCurrency(), 1, 1, 'R', 0);
//Totale Globale
$pdf->SetXY(10, $pdf->GetY() + 5);
$pdf->SetFont($pdf->FontStd, '', 8);
$pdf->Cell(30, 6, '', 0, 0, 'L', 0);
$pdf->Cell(115, 6, get_text('Total'), 1, 0, 'R', 1);
$pdf->SetFont($pdf->FontStd, 'B', 8);
$pdf->Cell(45, 6, NumFormat($Total, 2) . " " . $pdf->writeCurrency(), 1, 1, 'R', 0);
safe_free_result($Rs);
}
if (!isset($isCompleteResultBook)) {
$pdf->Output();
}
?>
</td>
<td class="Title" width="5%"><?php
print get_text('Div');
?>
</td>
<td class="Title" width="5%"><?php
print get_text('Cl');
?>
</td>
<td class="Title" width="5%"><?php
print get_text('Country');
?>
</td>
<?php
$PercPunti = NumFormat(45 / ($RowTour->TtNumDist + 5));
for ($i = 1; $i <= $RowTour->TtNumDist; ++$i) {
print '<td class="Title" width="' . $PercPunti . '%"><a class="LinkRevert" href="javascript:ChangeDist(' . $i . ',\'OK\');">Score (' . $i . ')</a></td>';
if ($i == $_REQUEST['x_Dist'] || $_REQUEST['x_Dist'] == -1) {
print '<td class="Title" width="' . $PercPunti . '%"><a class="LinkRevert" href="javascript:ChangeGoldXNine(\'OK\');">' . $RowTour->TtGolds . ' (' . $i . ')</a></td>';
print '<td class="Title" width="' . $PercPunti . '%"><a class="LinkRevert" href="javascript:ChangeGoldXNine(\'OK\');">' . $RowTour->TtXNine . ' (' . $i . ')</a></td>';
}
}
?>
<td class="Title" width="<?php
print $PercPunti;
?>
%">Score</td>
<td class="Title" width="<?php
print $PercPunti;
?>
/*print '<pre>';
print_r($data);
print '</pre>';exit;*/
$NumDist = 0;
if (array_key_exists('numDist', $data['meta'])) {
$NumDist = $data['meta']['numDist'];
}
$curEvent = '';
if (count($data['sections']) > 0) {
print '<form name="Frm" method="post" action="">' . "\n";
if (isset($_REQUEST['EventCode'])) {
print '<input type="hidden" name="EventCode" value="' . $_REQUEST['EventCode'] . '">' . "\n";
}
foreach ($data['sections'] as $section) {
$Colonne = 8 + $NumDist;
$PercPunti = NumFormat(40 / ($NumDist + 3));
print '<table class="Tabella">' . "\n";
print '<tr class="Divider"><td colspan="' . $Colonne . '"></td></tr>' . "\n";
print '<tr><th class="Title" colspan="' . $Colonne . '">' . $section['meta']['descr'] . ' (' . $section['meta']['event'] . ')</th></tr>';
print '<tr>';
print '<th width="5%">' . get_text('Rank') . '</th>';
print '<th width="20%">' . get_text('Archer') . '</th>';
print '<th width="20%" colspan="2">' . get_text('Country') . '</th>';
for ($i = 1; $i <= $NumDist; ++$i) {
print '<th width="' . $PercPunti . '%">Score' . ($NumDist == 0 ? '' : ' ' . $i) . '</th>';
}
print '<th width="' . $PercPunti . '%">' . get_text('Total') . '</th>';
print '<th width="' . $PercPunti . '%">G</th>';
print '<th width="' . $PercPunti . '%">X</th>';
print '<th>' . get_text('TieArrows') . '</th>';
print '</tr>' . "\n";
$RsSel = safe_r_sql($Select);
if (safe_num_rows($RsSel) > 0) {
while ($Row = safe_fetch($RsSel)) {
$ComboCl .= '<option value="' . $Row->ClId . '">' . $Row->ClId . '</option>' . "\n";
}
}
$ComboCl .= '</select>' . "\n";
// qui l'elenco dei prezzi
$Select = "SELECT AccPrice.*,ToCurrency FROM AccPrice " . "LEFT JOIN Tournament on ToId=APTournament " . "WHERE APTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "ORDER BY APId ASC ";
$Rs = safe_r_sql($Select);
// print $Select;
if (safe_num_rows($Rs) > 0) {
while ($MyRow = safe_fetch($Rs)) {
print '<tr id="Row_' . $MyRow->APDivClass . '">';
print '<td class="Center" colspan="2">' . $MyRow->APDivClass . '</td>';
print '<td class="Right">' . NumFormat($MyRow->APPrice, 2) . ' ' . $MyRow->ToCurrency . '</td>';
print '<td class="Center"><a href="javascript:DeletePrice(\'' . $MyRow->APDivClass . '\');"><img src="' . $CFG->ROOT_DIR . 'Common/Images/drop.png" border="0" alt="#" title="#"></a></td>';
print '</tr>' . "\n";
}
}
print '<tr id="RowDiv" class="Divider"><td colspan="4"></td></tr>' . "\n";
print '<tr><td colspan="4" class="Center">' . get_text('PressCtrl2SelectAll') . '</td></tr>' . "\n";
print '<tr id="NewRow">' . "\n";
print '<td class="Center" valign="top">' . $ComboDiv . '<br><br><a class="Link" href="javascript:SelectAllOpt(\'New_Division\');">' . get_text('SelectAll') . '</a></td>' . "\n";
print '<td class="Center" valign="top">' . $ComboCl . '<br><br><a class="Link" href="javascript:SelectAllOpt(\'New_Class\');">' . get_text('SelectAll') . '</a></td>' . "\n";
print '<td class="Center" valign="top"><input type="text" name="New_Price" id="New_Price" size="5" maxlength="10"></td>';
print '<td class="Center" valign="top">';
print '<input type="button" name="Command" id="Command" value="' . get_text('CmdSave') . '" onclick="javascript:AddPrice();">';
print '</td>';
print '</tr>' . "\n";
?>
if ($SetRap == 1) {
// $Select
// = "SELECT SUM(APPrice) AS Quanto "
// . "FROM "
// . "Entries INNER JOIN AccEntries ON EnId=AEId AND EnPays=1 AND EnTournament=AETournament AND EnTournament= " . StrSafe_DB($_SESSION['TourId']) . " "
// . "INNER JOIN AccPrice ON CONCAT(EnDivision,EnClass) LIKE APDivClass AND APTournament= " . StrSafe_DB($_SESSION['TourId']) . " AND AERapp='1' "
// . "WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND AEOperation=" . StrSafe_DB($_SESSION['AccOp']) . " AND AEFromIP=INET_ATON(" . StrSafe_DB($_SERVER['REMOTE_ADDR']) .") ";
// il conto vale solo per l'accredito (Operazione 1)
$Select = "SELECT SUM(APPrice) AS Quanto, ToCurrency " . "FROM " . "Entries INNER JOIN AccEntries ON EnId=AEId AND EnPays=1 AND EnTournament=AETournament AND EnTournament= " . StrSafe_DB($_SESSION['TourId']) . " " . "INNER JOIN AccPrice ON CONCAT(EnDivision,EnClass) LIKE APDivClass AND APTournament= " . StrSafe_DB($_SESSION['TourId']) . " AND AERapp='1' " . "LEFT JOIN Tournament on EnTournament=ToID " . "WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND AEOperation='1' AND AEFromIP=INET_ATON(" . StrSafe_DB($_SERVER['REMOTE_ADDR'] == '::1' ? '127.0.0.1' : $_SERVER['REMOTE_ADDR']) . ") " . "GROUP BY ToId ";
$Rs = safe_r_sql($Select);
//print $Select;exit;
if (safe_num_rows($Rs) == 1) {
$Euro = NumFormat(0, 2);
$row = safe_fetch($Rs);
if (!is_null($row->Quanto)) {
$Euro = NumFormat($row->Quanto, 2);
}
$StrConto = get_text('Bill', 'Tournament') . ': ' . $Euro . ' ' . $row->ToCurrency;
}
}
}
$ONLOAD = ' onLoad="javascript:document.Frm.bib.focus()"';
$JS_SCRIPT = array('<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Accreditation/Fun_JS.js"></script>', '<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Common/Fun_JS.inc.js"></script>');
include 'Common/Templates/head.php';
$Counter = "SELECT\r\n\t\t\tSUM(IF(AEOperation IS NULL,0,1)) as Presenti,\r\n\t\t\tSUM(IF(EnStatus=7,0,IF(AEOperation IS NULL,1,0))) as Assenti,\r\n\t\t\tSUM(IF(EnStatus=7,1,0)) as NonAccreditati,\r\n\t\t\tCOUNT(*) as Totale\r\n\t\t\tFROM Entries\r\n\t\t\tINNER JOIN Qualifications ON EnId=QuId AND EnTournament=" . StrSafe_DB($_SESSION['TourId']) . "\r\n\t\t\tLEFT JOIN AccEntries ON EnId=AEId AND EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND AEOperation=" . StrSafe_DB($_SESSION['AccOp']) . "\r\n\t\t\tLEFT JOIN Photos ON EnId=PhEnId WHERE QuSession IN (" . $Turni . ")";
$Rs = safe_r_sql($Counter);
$MyRowCounter = safe_fetch($Rs);
?>
<form name="Frm" method="get" action="">
<table class="Tabella">
<tr>
$cur = $MyRow->ToCurrency;
}
print '<tr>';
print '<td>' . $MyRow->EnCode . '</td>';
print '<td>' . $MyRow->EnFirstName . ' ' . $MyRow->EnName . '</td>';
print '<td>' . $MyRow->CoCode . ' - ' . $MyRow->CoName . '</td>';
print '<td class="Center">' . $MyRow->EnDivision . '</td>';
print '<td class="Center">' . $MyRow->EnClass . '</td>';
print '<td class="Right">' . ($MyRow->EnPays == 1 ? NumFormat($MyRow->APPrice, 2) : NumFormat(0, 2)) . ' ' . $MyRow->ToCurrency . '</td>';
print '</tr>' . "\n";
$Tot += $MyRow->EnPays == 1 ? $MyRow->APPrice : 0;
}
print '<tr>';
print '<td class="Bold" colspan="2">' . $_SESSION['TourWhere'] . ', ' . date(get_text('DateFmt')) . '</td>';
print '<td class="Bold Right" colspan="3">' . get_text('Total') . '</td>';
print '<td class="Bold Right">' . NumFormat($Tot, 2) . ' ' . $cur . '</td>';
print '</tr>' . "\n";
}
?>
<tr class="Divider"><td colspan="11"></td></tr>
<tr><td class="Center" colspan="11"><input class="noPrint" type="button" value="<?php
echo get_text('Close');
?>
" onClick="javascript:window.close();"></td></tr>
<tr><td class="Center" colspan="11"><input class="noPrint" type="button" value="<?php
echo get_text('CmdPrintBill', 'Tournament');
?>
" onClick="javascript:window.print();"></td></tr>
</table>
<?php
include 'Common/Templates/tail-popup.php';
