class 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;
    }