/**
* Show all knights of a letter
*/
public function actionShow()
{
//Init
$data = array('errno' => 1, 'error' => 'La letra no es válida', 'letter' => '', 'page' => 1, 'yellow_pages_total' => null, 'totalPages' => 0, 'knights_by_page' => 9, 'knights_list' => array());
//Input
if (isset($_GET['letter']) && $_GET['letter'] != '') {
//Load totalknights by letter
$data['yellow_pages_total'] = YellowPagesTotal::model()->with('letter0')->findAll();
//Check if a letter valid
foreach ($data['yellow_pages_total'] as $yellow_page_letter) {
if ($yellow_page_letter->letter0->name == $_GET['letter']) {
$data['errno'] = 0;
$data['error'] = '';
$data['letter'] = $_GET['letter'];
break;
}
}
//Load list of knights
if ($data['error'] == 0) {
//Load all knights
$data['knights_list'] = YellowPagesTotalByLetter::model()->with(array('letter0', 'knights'))->findAll(array('select' => 'knitghts.*', 'condition' => 'letter0.name = :letter', 'params' => array(':letter' => $_GET['letter']), 'limit' => $data['knights_by_page'] * ($data['page'] - 1) . ',' . $data['knights_by_page']));
//Calculate pages
$data['totalPages'] = ceil(count($data['knights_list']) / $data['knights_by_page']);
}
//Show page
$this->render('show', $data);
} else {
throw new CHttpException(404, 'The specified id cannot be found.');
}
}
