[eluser]Tumac[/eluser]
I am having trouble visualizing how my results should be sent to a view to get the following result:
<table>
CustomerName1 -> colspan=6
Order1 Data Data Data Data Data
Order2 Data Data Data Data Data
Order3 Data Data Data Data Data
CustomerName2
Order1 Data Data Data Data Data
Order2 Data Data Data Data Data
.
.
CustomerNameX -> colspan=6
Order1 Data Data Data Data Data
Order2 Data Data Data Data Data
OrderX Data Data Data Data Data
</table>
MySQL VIEW:
Code:
SELECT
po_header.poID,
lu_customer_vendor.CusName,
po_mills.millName,
po_header.shipReqDate,
po_destinations.destination,
po_drying.dryDescription,
po_length.polenDesc,
po_origins.portofOrigin,
lu_contacts.conName,
po_tolerance.tolerance,
po_header.`status`,
po_terms.termDesc,
lu_contacts.fax,
po_specie.specieName
FROM
po_header
LEFT OUTER JOIN po_mills ON (po_mills.millID = po_header.millID)
LEFT OUTER JOIN po_destinations ON (po_header.destID = po_destinations.destID)
LEFT OUTER JOIN lu_customer_vendor ON (po_header.cusID = lu_customer_vendor.cusID)
LEFT OUTER JOIN po_drying ON (po_header.dryID = po_drying.dryID)
LEFT OUTER JOIN lu_contacts ON (po_header.contactID = lu_contacts.conID)
LEFT OUTER JOIN po_origins ON (po_header.originID = po_origins.originID)
LEFT OUTER JOIN po_tolerance ON (po_header.tolID = po_tolerance.tolID)
LEFT OUTER JOIN po_length ON (po_header.polenID = po_length.polenID)
LEFT OUTER JOIN po_terms ON (po_header.termID = po_terms.termID)
INNER JOIN po_specie ON (po_header.specieID = po_specie.specieID)
ORDER BY
lu_customer_vendor.CusName,
po_header.poID
CONTROLLER:
Code:
function main() {
$data=array();
if($query=$this->po_model->getPOinfo()) {
$data['records']=$query;
}
$this->load->view('po/po_main',$data);
}
MODEL:
Code:
function getPOinfo() {
$qry=$this->db->get('model_POHeader');
return $qry->result();
}
VIEW:
Code:
<?php
$this->load->view('header');
?>
<p><h2>Purchase Orders</h2></p>
<br />
<table class="tlctable">
<tr>
<th></th>
<th>PO #</th>
<th>Req Date</th>
<th>Mill</th>
<th>Contact</th>
<th>Status</th>
</tr>
<?php if(isset($records)) { ?>
<tr>
<td colspan="6"><?php echo $records["CusName"]; ?></td>
</tr>
<?php
foreach($records as $row) {
?>
<tr>
<td><?php echo form_checkbox('record','selected',FALSE); ?></td>
<td><?php echo anchor("po/viewDetail/$row->poID",$row->poID); ?></td>
<td><?php echo $row->shipReqDate; ?></td>
<td><?php echo $row->millName; ?></td>
<td><?php echo $row->conName; ?></td>
<td><?php echo $row->status; ?></td>
</tr>
<?php }
} else {
?>
No records returned
<?php
}
echo '</table>';
$this->load->view('footer');
?>
The CusName result currently returns "Undefined Index" error