/** * */ public function actionDynamicrptname() { // 依傳入之areaid來查詢對應門市, 並且要已啟用 $type = TbpPerformParamRpt08Name::model()->findAllByAttributes(array(), $condition = "type_id = :id and opt1 = '1' order by id ", $params = array(':id' => (int) $_POST['rpttype'])); // 取出店編號對應店名 $data = CHtml::listData($type, 'id', 'rptname'); // 回傳至畫面 foreach ($data as $value => $name) { echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true); } }
</td> <td> <input type="submit" name="qry" value="每日報表查詢"> </td> <td> <input type="submit" name="qry2" value="合併日期查詢"> </td> </tr> <tr> <td>報表類型:<?php echo CHtml::dropDownList('rpttype', '', CHtml::listData(TbpPerformParamRpt08Type::model()->findAll(array('order' => 'id ASC', 'condition' => 'opt1=1')), 'id', 'rpttype'), array('prompt' => '選擇種類', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('tbpPerformRpt/dynamicrptname'), 'update' => '#rptname'))); ?> </td> <td>報表名稱:<?php echo CHtml::dropDownList('rptname', '', CHtml::listData(TbpPerformParamRpt08Name::model()->findAll(array('order' => 'id ASC', 'condition' => 'opt1=1')), 'id', 'rptname'), array('empty' => '選擇名稱', 'options' => array($rptname => array('selected' => 'selected')))); ?> </td> <td colspan="7"> <?php echo CHtml::htmlButton('篩選條件', array('class' => 'search-button')); ?> </td> </tr> </table>