function loadcompetitorforeditcompetition()
{
if (!($this->session->userdata('UserType') == 'E')) {
$path = base_url() . 'admin/home/evenadminlogout/';
redirect($path);
exit;
}
$DivisionICode = $_POST['DivisionICode'];
if (!empty($DivisionICode)) {
$WhereFieldValue = "DivisionICode IN (" . $DivisionICode . ") AND IsDeleted ='0' AND CreatedBy = '" . $this->session->userdata('LoginUserICode') . "'";
$OrderFiledValue = "FullName ASC";
$CompetitorDetails = $this->home->getAllDetails('competitor_master', $WhereFieldValue, $OrderFiledValue);
} else {
$CompetitorDetails = '';
}
$CompetitionICode = 1;
$WhereFieldValue = "CompetitionICode = '" . $CompetitionICode . "'";
$CompetitorICode = $this->home->getAllIdInArrayFormate('competition_competitor', $WhereFieldValue, 'CompetitorICode');
$CcompetitorArray = $CompetitorICode;
$table = '<table width="100%" border="0" cellspacing="0" cellpadding="0">';
if (!empty($CompetitorDetails) > 0) {
$Cnt = count($CompetitorDetails);
$table .= '<tr>
<td width="8%" align="left"><input type="checkbox" name="chckHead" id="chckHead" value="" onclick="toggleChecked(this.checked)"/></td>
<td width="71%" align="left"><span class="box_title" style="font-weight:bold;">Competitor Name</span></td>
<td width="21%" align="left"><span class="box_title" style="font-weight:bold;">Order</span><input type="hidden" name="TotalCheckBox" value="' . $Cnt . '" id="TotalCheckBox"><input type="hidden" name="SelectOrder" value="" id="SelectOrder"></td>
</tr>';
$z = 0;
foreach ($CompetitorDetails as $row) {
$SingleWhere = "CompetitorICode = '" . $row['CompetitorICode'] . "' AND CompetitionICode = '" . $CompetitionICode . "'";
$TCnt = $this->home->getTotalCountOfRecords('competition_competitor', $SingleWhere);
if ($TCnt > 0) {
$val = $this->home->getSingleFieldValue('competition_competitor', 'CompetitorOrder', $SingleWhere);
} else {
$val = '';
}
if (in_array($row['CompetitorICode'], $CcompetitorArray)) {
$Sel = "checked";
} else {
$Sel = "";
}
$table .= '<tr>
<td align="left" height="28px;"><input type="checkbox" name="CompetitorICode[]" id="CompetitorICode' . $z . '" value="' . $row['CompetitorICode'] . '_' . $z . '" class="checkbox" tabindex="15" ' . $Sel . ' onclick="chkMainBox();"/></td>
<td align="left"><span class="box_title">' . getMaxFieldLength(ucwords($row['FullName']), 23) . '</span></td>
<td align="left">
<select class="simpledrop" name="OrderList' . $z . '" id="OrderList' . $z . '" tabindex="16"><option value="">Order</option>';
for ($i = 1; $i <= $Cnt; $i++) {
if ($val == $i) {
$VSel = "selected";
} else {
$VSel = "";
}
$table .= '<option value="' . $i . '" ' . $VSel . '>' . $i . '</option>';
}
$table .= '</select></td>
</tr>';
$z++;
}
} else {
$table .= '<tr>
<td><span class="box_title">No Records</span></td>
</tr>';
}
$table .= '</table>';
echo $table;
}
<div class="judges_div2" id="particularCompetitor" >
<div>
<!-- this code is edited by bernazzyk -->
<div>
<div colspan="2" align="left" height="15"><b>Competitor Name</b></div>
</div>
<?php
if (!empty($CompetitorDetails)) {
foreach ($CompetitorDetails as $rowCompetitor) {
?>
<div style="padding-left: 20px;">
<div align="left">
<span class="box_title"><?php
echo getMaxFieldLength(ucwords($rowCompetitor['FullName']), 23);
?>
</span>
<div class="competitor" id="competitor<?php
echo $rowCompetitor['CompetitorICode'];
?>
">
</div>
</div>
</div>
<?php
}
} else {
?>
<thead>
<tr>
<th width="43%" height="32" align="left">Competition Name</th>
<th width="26%" align="left">Competition Date</th>
<th width="20%" align="left">Created Date
<td width="11%" align="center" class="th_css">Action</td>
</tr>
</thead>
<tbody>
<?php
if (count($CompetitionDetails) > 0) {
foreach ($CompetitionDetails as $row) {
?>
<tr class="gradeC">
<td class="left"><?php
echo getMaxFieldLength(ucwords($row['CompetitionName']), 25);
?>
</td>
<td class="left"><?php
echo getDateDisplay($row['CompetitionDate']);
?>
</td>
<td class="left"><?php
echo getDateDisplay($row['CreatedDate']);
?>
</td>
<td class="center" id="ActionICon<?php
echo $row['CompetitionICode'];
?>
">
<?php
<th width="38%" align="left" >Percentage</th>
<!--td width="15%" align="center" class="th_css">Status</td-->
<td width="13%" align="center" class="th_css">Delete</td>
</tr>
</thead>
<tbody>
<?php
if (!empty($ResAnalysisDetails)) {
foreach ($ResAnalysisDetails as $row) {
$SectionICode = $row['SectionICode'];
$SingleWhere = "SectionICode = '" . $row['SectionICode'] . "'";
$SectionName = $this->home->getSingleFieldValue('section_master', 'SectionName', $SingleWhere);
?>
<tr class="gradeC">
<td class="left"><?php
echo getMaxFieldLength(ucwords($SectionName), 22);
?>
</td>
<td class="left"><?php
echo $row['TotalPercentage'];
?>
</td>
<!--td class="center" id="status<?php
echo $row['CompetitonResultAnalysisICode'];
?>
"><?php
echo getUserStatus($row['IsActive'], 'competitionresult_analysis', $row['CompetitonResultAnalysisICode'], 'section', 'CompetitonResultAnalysisICode');
?>
</td-->
<td class="center"><img src="<?php
echo base_url();
<td id="subSectionTable"><table cellpadding="0" cellspacing="0" border="0" class="display" id="tablegrid1" width="100%">
<thead>
<tr>
<th width="71%" height="32" align="left">Sub Section Name </th>
<td width="14%" align="center" class="th_css">Status</th>
<td width="15%" align="center" class="th_css">Action</td>
</tr>
</thead>
<tbody>
<?php
if (count($SubsectionDetails) > 0) {
foreach ($SubsectionDetails as $row) {
?>
<tr class="gradeC">
<td class="left"><?php
echo getMaxFieldLength(ucwords($row['SubsectionName']), 40);
//echo substr(ucwords($DivisionName), 0, 25);
?>
</td>
<td class="center" id="status<?php
echo $row['TempSubsectionICode'];
?>
"><?php
echo getUserStatus($row['IsActive'], 'temp_subsection', $row['TempSubsectionICode'], 'sub-section', 'TempSubsectionICode');
?>
</td>
<td class="center"><img src="<?php
echo base_url();
?>
images/edit.png" border="0" width="16" height="16" alt="Edit Sub Section" title="Edit Sub Section" style="cursor:pointer;" onclick="editsubsectiondata('<?php
<tr>
<td width="449" valign="top"><table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" height="30"><span class="Rtitle">Competitor Name </span></td>
<td width="4%"><span class="Rtitle">:</span></td>
<td width="66%" class="Rstitle"><?php
echo getMaxFieldLength(ucwords($TitleDetails['FullName']), 40);
?>
</td>
</tr>
<tr>
<td height="30"><span class="Rtitle">Division Name</span></td>
<td><span class="Rtitle">:</span></td>
<td class="Rstitle"><?php
echo getMaxFieldLength(ucwords($TitleDetails['DivisionName']), 40);
?>
</td>
</tr>
<tr>
<td height="30"><span class="Rtitle">Order Number</span></td>
<td><span class="Rtitle">:</span></td>
<td class="Rstitle"><?php
echo $TitleDetails['CompetitorOrder'];
?>
</td>
</tr>
</table></td>
<td width="271" valign="top"><table width="98%" height="42" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" align="center">
function subsectiontableforedit($SectionICode)
{
//load temp table data
$WhereFieldValue = "SectionICode = '" . $SectionICode . "' AND CreatedBy = '" . $this->session->userdata('LoginUserICode') . "'";
$OrderFiledValue = "SubsectionName ASC";
$SubsectionDetails = $this->home->getAllDetails('subsection_master', $WhereFieldValue, $OrderFiledValue);
$table = '<table cellpadding="0" cellspacing="0" border="0" class="display" id="tablegrid1" width="100%">
<thead>
<tr>
<th width="66%" height="32" align="left">Sub Section Name </th>
<td width="17%" align="center" class="th_css">Status</th>
<td width="17%" align="center" class="th_css">Action</td>
</tr>
</thead>
<tbody>';
if (count($SubsectionDetails) > 0) {
foreach ($SubsectionDetails as $row) {
$table .= '<tr class="gradeC">
<td class="left">' . getMaxFieldLength(ucwords($row['SubsectionName']), 30) . '</td>
<td class="center" id="status' . $row['SubsectionICode'] . '">' . getUserStatus($row['IsActive'], 'subsection_master', $row['SubsectionICode'], 'sub-section', 'SubsectionICode') . '</td>
<td class="center"><img src="' . base_url() . 'images/edit.png" border="0" width="16" height="16" alt="Edit Sub Section" title="Edit Sub Section" style="cursor:pointer;" onclick="editsubsectiondata(\'' . $row['SubsectionName'] . '\', \'' . $row['SubsectionICode'] . '\');"/>
<img src="' . base_url() . 'images/delete.png" border="0" width="16" height="16" alt="Delete Sub Section" title="Delete Sub Section" style="cursor:pointer; padding-left:25px;" onclick="deleteSubSection(\'' . $row['SubsectionICode'] . '\', \'' . $SectionICode . '\');"/></td>
</tr>';
}
}
$table .= '</tbody>
</table>';
echo $table;
?>
<link href="<?php
echo base_url();
?>
css/themes/smoothness/jquery-ui-1.8.4.custom.css" rel="stylesheet" type="text/css" >
<link href="<?php
echo base_url();
?>
css/demo_table_jui.css" rel="stylesheet" type="text/css" >
<script type="text/javascript" src="<?php
echo base_url();
?>
js/dataTable.js"></script>
<script language="javascript">
$(document).ready(function() {
oTable = $('#tablegrid1').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"aoColumns": [ null ]
});
});
</script>
<?php
}
</tr>
<tr>
<td height="30"><span class="Rtitle">Division Name</span></td>
<td><span class="Rtitle">:</span></td>
<td><?php
echo getMaxFieldLength(ucwords($TitleDetails['DivisionName']), 25);
?>
</td>
</tr>
</table></td>
<td width="360"><table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%" height="30"><span class="Rtitle">Competitor Name </span></td>
<td width="3%"><span class="Rtitle">:</span></td>
<td width="64%"><?php
echo getMaxFieldLength(ucwords($TitleDetails['FullName']), 25);
?>
</td>
</tr>
<tr>
<td height="30"><span class="Rtitle">Order Number</span></td>
<td><span class="Rtitle">:</span></td>
<td><?php
echo $TitleDetails['CompetitorOrder'];
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" colspan="2"> </td>
function competitionresult_analysistable($ChampionshipICode, $DivisionICode)
{
$Fields = "CompetitonResultAnalysisICode, ChampionshipICode, DivisionICode, SectionICode, TotalPercentage, IsActive";
$WhereFieldValue = "ChampionshipICode = '" . $ChampionshipICode . "' AND DivisionICode = '" . $DivisionICode . "' AND CreatedBy = '" . $this->session->userdata('LoginUserICode') . "'";
$ResultconfigDetails = $this->home->getParticularResults('competitionresult_analysis', $Fields, $WhereFieldValue);
$table = '<table cellpadding="0" cellspacing="0" border="0" class="display" id="tablegrid1" width="100%">
<thead>
<tr>
<th width="34%" height="32" align="left"> Section Name </th>
<th width="38%" align="left" >Percentage</th>
<!--td width="15%" align="center" class="th_css">Status</td-->
<td width="13%" align="center" class="th_css">Delete</td>
</tr>
</thead>
<tbody>';
if (!empty($ResultconfigDetails)) {
foreach ($ResultconfigDetails as $row) {
$SectionICode = $row['SectionICode'];
$SingleWhere = "SectionICode = '" . $row['SectionICode'] . "'";
$SectionName = $this->home->getSingleFieldValue('section_master', 'SectionName', $SingleWhere);
$table .= '<tr class="gradeC">
<td class="left">' . getMaxFieldLength(ucwords($SectionName), 22) . '</td>
<td class="left">' . $row['TotalPercentage'] . '</td>
<!--td class="center" id="status' . $row['CompetitonResultAnalysisICode'] . '">' . getUserStatus($row['IsActive'], 'competitionresult_analysis', $row['CompetitonResultAnalysisICode'], 'section', 'CompetitonResultAnalysisICode') . '</td-->
<td class="center"><img src="' . base_url() . 'images/delete.png" border="0" width="16" height="16" alt="Delete" title="Delete" style="cursor:pointer;" onclick="deleteResultConfig(\'' . $row['CompetitonResultAnalysisICode'] . '\', \'' . $row['ChampionshipICode'] . '\', \'' . $row['DivisionICode'] . '\');"/></td>
</tr>';
}
}
$table .= '</tbody>
</table>';
echo $table;
?>
<link href="<?php
echo base_url();
?>
css/themes/smoothness/jquery-ui-1.8.4.custom.css" rel="stylesheet" type="text/css" >
<link href="<?php
echo base_url();
?>
css/demo_table_jui.css" rel="stylesheet" type="text/css" >
<script type="text/javascript" src="<?php
echo base_url();
?>
js/dataTable.js"></script>
<script language="javascript">
$(document).ready(function() {
oTable = $('#tablegrid1').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"aoColumns": [ null, null ]
});
});
</script>
<?php
}
<tbody>
<?php
if (count($EventAdminDetails) > 0) {
foreach ($EventAdminDetails as $row) {
?>
<tr class="gradeC">
<td class="left"><?php
echo getMaxFieldLength(ucwords($row['FirstName']), 20);
?>
</td>
<td class="left"><?php
echo getMaxFieldLength(ucwords($row['LastName']), 20);
?>
</td>
<td class="left"><?php
echo getMaxFieldLength($row['EmailAddress'], 40);
?>
</td>
<td class="left"><?php
echo getDateDisplay($row['CreatedDate']);
?>
</td>
<!--td class="center">07/06/2010</td-->
<td class="center" id="status<?php
echo $row['EventAdminICode'];
?>
"><?php
echo getUserStatus($row['IsActive'], 'event_admin_master', $row['EventAdminICode'], 'user', 'EventAdminICode');
?>
</td>
<thead>
<tr>
<th width="61%" height="32" align="left">Division Name</th>
<th width="15%" align="left">Created Date</th>
<td width="9%" align="center" class="th_css">Status</th>
<td width="15%" align="center" class="th_css">Action</td>
</tr>
</thead>
<tbody>
<?php
if (count($DivisionDetails) > 0) {
foreach ($DivisionDetails as $row) {
?>
<tr class="gradeC">
<td class="left"><?php
echo getMaxFieldLength(ucwords($row['DivisionName']), 45);
?>
</td>
<td class="center"><?php
echo getDateDisplay($row['CreatedDate']);
?>
</td>
<!--td class="center">07/06/2010</td-->
<td class="center" id="status<?php
echo $row['DivisionICode'];
?>
"><?php
echo getUserStatus($row['IsActive'], 'division_master', $row['DivisionICode'], 'division', 'DivisionICode');
?>
</td>
<tbody>
<?php
if (!empty($CompetitionDetails)) {
foreach ($CompetitionDetails as $row) {
$SingleWhere = "DivisionICode = '" . $row['DivisionICode'] . "'";
$DivisionName = $this->home->getSingleFieldValue('division_master', 'DivisionName', $SingleWhere);
$SingleWhere = "ChampionshipICode = '" . $row['ChampionshipICode'] . "'";
$ChampionshipName = $this->home->getSingleFieldValue('championship', 'ChampionshipName', $SingleWhere);
?>
<tr class="gradeC">
<td class="left"><?php
echo getMaxFieldLength(ucwords($DivisionName), 20);
?>
</td>
<td class="left"><?php
echo getMaxFieldLength(ucwords($ChampionshipName), 20);
?>
</td>
<td class="left"><?php
echo getDateDisplay($row['CreatedDate']);
?>
</td>
<td class="center"><a href="<?php
echo base_url();
?>
admin/result/editresultconfiguration/<?php
echo $row['ChampionshipICode'];
?>
/<?php
echo $row['DivisionICode'];
?>
//get competitor name
//$CompetitorName = $this->home->getSingleFieldValue();
$SingleWhere = "CompetitorICode = '" . $row['CompetitorICode'] . "'";
$CompetitorName = $this->home->getSingleFieldValue('competitor_master', 'FullName', $SingleWhere);
$Starthour = date('G', strtotime($row['CompetitionStartTime']));
$Startmin = date('i', strtotime($row['CompetitionStartTime']));
$Endhour = date('G', strtotime($row['CompetitionEndTime']));
$Endmin = date('i', strtotime($row['CompetitionEndTime']));
?>
<tr class="gradeC">
<td height="39" class="left"><?php
echo $row['CompetitorOrder'];
?>
</td>
<td height="39" class="left"><?php
echo getMaxFieldLength(ucwords($CompetitorName), 25);
?>
</td>
<td height="39" class="left"><?php
echo getDateDisplay($row['CompetitionDate']);
?>
</td>
<td class="left" id="StartTimeId<?php
echo $row['CompetitionCompetitorICode'];
?>
">
<select name='CompetitionStartTimeHour<?php
echo $row['CompetitionCompetitorICode'];
?>
' id='CompetitionStartTimeHour<?php
echo $row['CompetitionCompetitorICode'];
<th width="38%" height="32" align="left">Section Name</th>
<th width="12%" align="left">Min Point</th>
<th width="12%" align="left">Max Point</th>
<th width="17%" align="left">Created Date</th>
<td width="10%" align="center" class="th_css">Status</th>
<td width="11%" align="center" class="th_css">Action</td>
</tr>
</thead>
<tbody>
<?php
if (count($SectionDetails) > 0) {
foreach ($SectionDetails as $row) {
?>
<tr class="gradeC">
<td class="left"><?php
echo getMaxFieldLength(ucwords($row['SectionName']), 22);
?>
</td>
<td class="left"><?php
echo $row['MinPoint'];
?>
</td>
<td class="left"><?php
echo $row['MaxPoint'];
?>
</td>
<td class="left"><?php
echo getDateDisplay($row['CreatedDate']);
?>
</td>
<td class="center" id="status<?php
<tr>
<td> </td>
</tr>
<tr>
<td><table width="720" border="0" cellspacing="0" cellpadding="0" align="right">
<tr>
<td width="442" valign="top"><table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" height="30"><span class="Rtitle">Competitor Name </span></td>
<td width="4%"><span class="Rtitle">:</span></td>
<td width="66%" class="Rstitle"><?php echo getMaxFieldLength(ucwords($TitleDetails['FullName']), 40); ?></td>
</tr>
<tr>
<td height="30"><span class="Rtitle">Division Name</span></td>
<td><span class="Rtitle">:</span></td>
<td class="Rstitle"><?php echo getMaxFieldLength(ucwords($TitleDetails['DivisionName']), 40); ?></td>
</tr>
<tr>
<td height="30"><span class="Rtitle">Order Number</span></td>
<td><span class="Rtitle">:</span></td>
<td class="Rstitle"><?php echo $TitleDetails['CompetitorOrder'];?></td>
</tr>
</table></td>
<td width="278" valign="top"><table width="98%" height="42" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" align="center">
<?php if(!empty($TitleDetails['ProfileImage']) && file_exists("./uploads/CompetitiorImages/".$TitleDetails['ProfileImage'])){?>
<img src="<?php echo base_url(); ?>uploads/CompetitiorImages/<?php echo $TitleDetails['ProfileImage'];?>" width="150px" height="150px" border="0" title="<?php echo ucwords($TitleDetails['FullName']);?>"/>
<?php } else {?>
<img src="<?php echo base_url(); ?>images/NoPhoto.jpg" width="150px" height="150px" border="0" title="No Image"/>
<?php } ?> </td>