rendered paste bodyclass CodesController extends Zend_Controller_Action
{
public function homeAction()
{
$acl = EDM_Acl::getInstance();
$webUser = WebUser::getInstance();
$batches = array();
$pbatch = new PBatch();
$pcode = new PCode();
if (!$acl->isAllowed($webUser->acl_role_id, 'admin')) {
$select = $pbatch->select()->where('rcode_id = ?', $webUser->rcode_id)->orWhere('rcode_id = ?', 0);
} else {
$select = $pbatch->select()->where('rcode_id = ?', $webUser->rcode_id);
}
if ($pbatches = $pbatch->fetchAll($select)) {
foreach ($pbatches as $pbatch) {
$select = $pcode->select()->where('pbatch_id = ?', $pbatch->pbatch_id);
$batches[$pbatch->pbatch_id]['name'] = $pbatch->pbatch_name;
if ($pcodes = $pcode->fetchAll($select)) { //->from($pcode, array('COUNT(pcode_id) as codes'))
foreach ($pcodes as $pcode)
$batches[$pbatch->pbatch_id]['codes'][$pcode->pcode_id] = array('code'=>strtoupper($pcode->pcode_code),
'points'=>$pcode->pcode_points,
'uses'=>$pcode->pcode_uses);
//$batches[$pbatch->pbatch_id]['codes'] = $pcodes->codes;
}
}
}
//print_r($batches);
$this->view->batches = $batches;
}