<div class="clear"></div>
</div>
<?php
if (isset($gigs)) {
foreach ($gigs as $gig) {
?>
<div class="tblrow" style="margin-top:5px;">
<div class="fleft wp15 td "> <?php
echo $gig->firstName . ' ' . $gig->lastName;
?>
</div>
<div class="fleft wp12 td center"> <?php
echo mysqlDate2UkDate($gig->eventDate);
?>
</div>
<div class="fleft 12 td center"> <?php
echo $gig->venue;
?>
</div>
<div class="clear"></div>
</div>
<?php
}
}
?>
<div class="fleft wp5 td center"><?php
echo $ev['status'];
?>
</div>
<div class="fleft wp15 td"><a href="<?php
echo my_site_url();
?>
consultant/event/<?php
echo $ev['eventID'];
?>
"><?php
echo $ev['eventType'];
?>
</a></div>
<div class="fleft wp9 td"><?php
echo mysqlDate2UkDate($ev['eventDate']);
?>
</div>
<div class="fleft wp9 td center"><a href="javascript:void(0)" id="eventls_<?php
echo $ev['eventID'];
?>
" class="jqtipsajax" >[<?php
echo $leadsinger ? $leadsinger : 'N/A';
?>
]</a><span style="display:none;"><?php
echo $leadsingertip ? $leadsingertip : 'N/A';
?>
</span></div>
<div class="fleft wp5 td center"><a href="javascript:void(0)" id="eventbs_<?php
echo $ev['eventID'];
?>
function genratePayble()
{
error_reporting(1);
$filename = "data.xls";
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename=' . $filename);
$postData = $this->input->post();
$enquries = $this->consultants->getPay($postData);
$weeks = getWeekRange();
$enqArr = array();
$evids = array();
if ($enquries && count($enquries) > 0) {
foreach ($enquries as $enq) {
$dateDiff = myDateDiff($weeks[1]['start']['date'], $enq['eventDate']);
$week = (int) ($dateDiff['days'] / 7 + 1);
$enqArr[$week][] = $enq;
$evids[] = $enq['eventID'];
}
}
$invitations = $this->consultants->getMusicianInvitationForEvent('', array('event_id' => $evids));
$invarr = array();
foreach ($invitations as $inv) {
$invarr[$inv->event_id][] = $inv;
}
$htmlcontent = "<table>";
$htmlcontent .= "<tr><th>Gig Name</th><th>Date</th><th>Day</th><th>Lead Singer</th><th>Band brand</th><th>Musician name</th><th>Paid Amount</th></tr>";
$events = $enqArr;
$eventInv = $invarr;
$awaitingDepositsList = array();
$showcaseInfo = array();
if ($events) {
foreach ($events as $week => $val) {
foreach ($val as $ev) {
$leadsinger = '';
$leadsingertip = '';
$bandsizetip = '';
$bandsize = '0';
$nrplytip = '';
$nrply = '0';
$declinedtip = '';
$declined = '0';
$musiciancost = 0;
$event = $ev['eventID'];
if (isset($eventInv[$ev['eventID']])) {
foreach ($eventInv[$ev['eventID']] as $inv) {
if ($inv->event_lead_singer) {
$lead = "Yes";
} else {
$lead = "No";
}
$musician_name = $inv->first_name . ' ' . $inv->last_name;
$band_brand = $inv->band_brand;
$musiciancost = $inv->base_cost + $inv->extra_time_cost + $inv->distance_cost;
$htmlcontent .= "<tr><td>" . $ev['firstName'] . ' ' . $ev['lastName'] . "</td><td>" . mysqlDate2UkDate($ev['eventDate']) . "</td><td>" . getDayFromMysqlDate($ev['eventDate']) . "</td><td>" . $lead . "</td><td>" . $band_brand . "</td><td>" . $musician_name . "</td><td>" . $musiciancost . "</td></tr>";
}
}
}
}
}
$htmlcontent .= "</table>";
// Create as XLS file and send to browser for download
echo $htmlcontent;
}
<div class="fleft wp15 td "> <a href="<?php
echo my_site_url();
?>
consultant/event/<?php
echo $ev['eventID'];
?>
"><?php
echo $ev['firstName'] . ' ' . $ev['lastName'];
?>
</a></div>
<div class="fleft wp12 td center"> <?php
echo mysqlDate2UkDate($ev['eventDate']);
?>
</div>
<div class="fleft 12 td center"> <?php
echo mysqlDate2UkDate($ev['holdingDate']);
?>
</div>
<div class="fleft 12 td center"> <?php
echo $ev['venueLocation'];
?>
</div>
<div class="clear"></div>
</div>
<?php
}
}
?>
</div>
} else {
if ($inv->status == 3) {
?>
<a href="javascript:void(0)" class="musician_declined">Declined</a>
<?php
}
}
}
?>
</div>
<div class="fleft td wp11"><?php
echo $inv->eventType;
?>
</div>
<div class="fleft td wp6"><?php
echo mysqlDate2UkDate($inv->eventDate);
?>
</div>
<div class="fleft td wp6"><?php
echo getDayFromMysqlDate($inv->eventDate);
?>
</div>
<div class="fleft td wp5">
<span ><?php
if (trim($loc)) {
echo $loc;
} else {
echo 'N/A';
}
?>
</span>
