/**
  * Returns the data model based on the primary key given in the GET variable.
  * If the data model is not found, an HTTP exception will be raised.
  * @param integer the ID of the model to be loaded
  */
 public function loadModel($id)
 {
     $model = StopDetails::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }
예제 #2
0
$criteria = new CDbCriteria();
$criteria->order = 'id DESC';
$total = Transportation::model()->count($criteria);
$pages = new CPagination($total);
$pages->setPageSize(Yii::app()->params['listPerPage']);
$pages->applyLimit($criteria);
// the trick is here!
$route = Transportation::model()->findAll($criteria);
$page_size = Yii::app()->params['listPerPage'];
?>
								<?php 
//$route=Transportation::model()->findAll();
if ($route) {
    foreach ($route as $route1) {
        $student = Students::model()->findByAttributes(array('id' => $route1->student_id));
        $stop = StopDetails::model()->findByAttributes(array('id' => $route1->stop_id));
        $route = RouteDetails::model()->findByAttributes(array('id' => $stop->route_id));
        ?>
	
 
                            <td align="center">
                                <?php 
        echo $student->last_name . ' ' . $student->first_name;
        ?>
                            </td>
                            <td align="center">
                                <?php 
        echo $route->route_name;
        ?>
                            </td>
                            <td align="center">
 public function actionRoutes()
 {
     if (isset($_POST['route'])) {
         $data = StopDetails::model()->findAll('route_id=:x', array(':x' => $_POST['route']));
     }
     echo CHtml::tag('option', array('value' => 0), CHtml::encode('Select'), true);
     $data = CHtml::listData($data, 'id', 'stop_name');
     foreach ($data as $value => $title) {
         echo CHtml::tag('option', array('value' => $value), CHtml::encode($title), true);
     }
 }
예제 #4
0
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
        <td width="247" valign="top">
            <?php 
$this->renderPartial('/transportation/trans_left');
?>
        </td>
        <td valign="top">
            <div class="cont_right">
                <h1>
                    <?php 
echo Yii::t('transport', 'BusLog');
?>
                </h1>
                <?php 
$driver = StopDetails::model()->findByAttributes(array('id' => $_REQUEST['id']));
$vehicle = RouteDetails::model()->findByAttributes(array('id' => $driver->route_id));
?>
<div class="pdtab_Con" >
                <table width="80%" border="0" cellspacing="0" cellpadding="0">
                    <tr class="pdtab-h">
                        <td>
                            <?php 
echo Yii::t('transport', 'Route');
?>
                        </td>
                        <td>
                            <?php 
echo Yii::t('transport', 'Stop Name');
?>
                        </td>
예제 #5
0
<?php

$this->breadcrumbs = array('Route Details' => array('/transport'), 'RouteDetails');
$form = $this->beginWidget('CActiveForm', array('id' => 'vacate-form', 'enableAjaxValidation' => false));
echo '<strong>' . CHtml::label(Yii::t('transport', 'Select Route'), '') . '</strong>';
//echo CHtml::dropDownList('routeid','',array(),array('prompt'=>'Select','id'=>'stopid'));
echo CHtml::dropDownList('routeid', '', CHtml::listData(RouteDetails::model()->findAll(), 'id', 'route_name'), array('prompt' => 'Select', 'id' => 'route_id', 'submit' => array('RouteDetails/routedetails')));
if (isset($routeid)) {
    if ($routeid == NULL) {
        echo '<div align="center">' . Yii::t('transport', 'Sorry!!&nbsp;No data available now.') . '</div>';
    } else {
        $routedetails = RouteDetails::model()->findByAttributes(array('id' => $routeid));
        $vehicle = VehicleDetails::model()->findByAttributes(array('id' => $routedetails->vehicle_id));
        $stop = StopDetails::model()->findAllByAttributes(array('route_id' => $routeid));
        if ($stop == NULL) {
            echo '<div align="center"><strong>' . Yii::t('transport', 'Sorry!!&nbsp;No data available now.') . '</strong></div>';
        } else {
            ?>
<table width="22%" border="0" cellspacing="0" cellpadding="0">
    <tr>
       
        <td><?php 
            echo Yii::t('transport', 'Route');
            ?>
</td>
        <td><?php 
            echo Yii::t('transport', 'Stop');
            ?>
</td>
        <td><?php 
            echo Yii::t('transport', 'Vehicle ID');
예제 #6
0
     <table>
     <tr>
     	<td>Add <input type="text" name="stops" id="noOfStops" style="width:40px;" />&nbsp;stops</td><td><input type="submit" value="Go" onclick="return checkStops();" /></td>
        <td>
        		<?php 
Yii::app()->clientScript->registerScript('myHideEffect', '$(".error").animate({opacity: 1.0}, 5000).fadeOut("slow");', CClientScript::POS_READY);
?>
  
                <div class="error" id="error" style="background:#FFF; color:#C00; padding-left:10px; visibility:hidden;"> 
                </div>
				
        </td>
     </tr>
     </table>
    <?php 
$stop = StopDetails::model()->findAll('route_id =:x', array(':x' => $_REQUEST['id']));
if ($stop != NULL) {
    ?>
         <div class="pdtab_Con">
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
         <tr class="pdtab-h">
        	<td align="center"><?php 
    echo Yii::t('transport', 'Stop Name');
    ?>
</td>
            <td align="center"><?php 
    echo Yii::t('transport', 'Fare');
    ?>
</td>
            <td align="center"><?php 
    echo Yii::t('transport', 'Arrival Time(Morning)');
예제 #7
0
        							<td align="center"><?php 
    echo Yii::t('transport', 'Stop');
    ?>
</td>
                                     <td align="center"><?php 
    echo Yii::t('transport', 'Action');
    ?>
</td>
        					</tr>
                                <?php 
    if ($list == NULL) {
        echo '<tr><td align="center" colspan="4"><strong>' . Yii::t('transport', 'No such student is using the transport facility.') . '</strong></td></tr>';
    } else {
        foreach ($list as $list_1) {
            $student = Students::model()->findByAttributes(array('id' => $list_1->student_id));
            $stopdetails = StopDetails::model()->findByAttributes(array('id' => $list_1->stop_id));
            $routedetails = RouteDetails::model()->findByAttributes(array('id' => $stopdetails->route_id));
            ?>
                                    <tr>
                                    	<td align="center"><?php 
            echo $student->last_name . ' ' . $student->first_name;
            ?>
 </td>
                                       <td align="center"><?php 
            echo $routedetails->route_name;
            ?>
</td>
                                        <td align="center"><?php 
            echo $stopdetails->stop_name;
            ?>
</td>