Example #1
0
			<div class="tblrow th">
				<div class="fleft wp15 th center">Status</div>
				<div class="fleft wp15 th center">Gig Name</div>
				<div class="fleft wp12 th center">Date</div>
				<div class="fleft wp12 th center">Hold Until Date</div>
				<div class="fleft wp12 th center">Vanue</div>
				<div class="clear"></div>
			</div>
			<?php 
if ($showcaseInfo) {
    foreach ($showcaseInfo as $ev) {
        ?>
		
					<div class="tblrow" style="margin-top:5px;">
						<div class="fleft wp15 td ">&nbsp;<?php 
        echo eventStatusList($ev['status']);
        ?>
</div>
						<div class="fleft wp15 td ">&nbsp;<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">&nbsp;<?php 
        echo mysqlDate2UkDate($ev['eventDate']);
        ?>
Example #2
0
echo getImage('ajax-loader.gif');
?>
" />
							<div style="float:right;width:50%;">
								<span id="showcase_blockmsg"></span>
							</div>
							<div class="clear"></div>
					
					</div>
					<div class="clear"></div>
					<div class="row">
							<label>Status:</label>
							<div class="inputs" >
								<select name ="status" id="gnenqstatus">
								<?php 
foreach (eventStatusList() as $key => $es) {
    $sel = '';
    if ($key == $event['status']) {
        $sel = 'selected';
    }
    echo '<option value=' . $key . ' ' . $sel . '>' . $es . '</option>';
}
?>
								</select>
							</div>
							<label>Consultant Name:</label>
							<div class="inputs" >
								<select name="consultant">
									<option value="Alen">Alen</option>
									
								</select>
Example #3
0
 function genraterecive()
 {
     $filename = "data.xls";
     header('Content-type: application/ms-excel');
     header('Content-Disposition: attachment; filename=' . $filename);
     $postData = $this->input->post();
     $enquries = $this->consultants->getrecive($postData);
     $weeks = getWeekRange();
     $enqArr = array();
     $evids = array();
     $invarr = 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>Status</th><th>Gig Name</th><th>Date</th><th>Day</th><th>Lead Singer</th><th>band size</th><th>Declined</th></tr>";
     $events = $enqArr;
     $eventInv = $invarr;
     //echo '<pre>';
     //print_r($enquries);
     //die;
     $awaitingDepositsList = array();
     $showcaseInfo = array();
     //echo '<pre>';
     //print_r($events);
     //die;
     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) {
                         $cls = $inv->status == '1' ? 'yellow' : ($inv->status == '2' ? "white" : "red");
                         $status = $inv->status == '1' ? 'Invited' : ($inv->status == '2' ? "Accepted" : "Declined");
                         if ($inv->event_lead_singer) {
                             if ($leadsinger == '') {
                                 $leadsinger = $inv->first_name . ' ' . $inv->last_name;
                             }
                             $leadsingertip .= '<span class=' . $cls . '>' . $inv->first_name . ' ' . $inv->last_name;
                             $leadsingertip .= ' | ' . $status . '</span><br />';
                         }
                         if ($inv->status == '1') {
                             $nrplytip .= '<span class=' . $cls . '>' . $inv->first_name . ' ' . $inv->last_name;
                             $nrplytip .= $inv->instrument ? ' | ' . $inv->instrument : ' | N/A';
                             $nrplytip .= ' | ' . $status . '</span><br />';
                             $nrply++;
                         } else {
                             if ($inv->status == '3') {
                                 $declinedtip .= '<span class=' . $cls . '>' . $inv->first_name . ' ' . $inv->last_name;
                                 $declinedtip .= $inv->instrument ? ' | ' . $inv->instrument : ' | N/A';
                                 $declinedtip .= ' | ' . $status . '</span><br />';
                                 $declined++;
                             }
                         }
                         $bandsizetip .= '<span class=' . $cls . '>' . $inv->first_name . ' ' . $inv->last_name;
                         $bandsizetip .= $inv->instrument ? ' | ' . $inv->instrument : ' | N/A';
                         $bandsizetip .= ' | ' . $status . '</span><br />';
                         $bandsize++;
                         $musiciancost += $inv->base_cost + $inv->extra_time_cost + $inv->distance_cost;
                     }
                 }
                 $htmlcontent .= "<tr><td>" . eventStatusList($ev['status']) . "</td><td>" . $ev['firstName'] . ' ' . $ev['lastName'] . "</td><td>" . mysqlDate2UkDate($ev['eventDate']) . "</td><td>" . getDayFromMysqlDate($ev['eventDate']) . "</td><td>" . $leadsinger . "</td><td>" . $bandsize . "</td><td>" . $declined . "</td></tr>";
             }
         }
     }
     $htmlcontent .= "</table>";
     // Create as XLS file and send to browser for download
     echo $htmlcontent;
 }