/**
  * Creates a new model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  */
 public function actionCreate()
 {
     $model = new Transportation();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     if (isset($_POST['Transportation'])) {
         $trans = Transportation::model()->findByAttributes(array('student_id' => $_POST['student_id']));
         $model->attributes = $_POST['Transportation'];
         $model->student_id = $_POST['student_id'];
         if ($trans != NULL and $_POST['student_id']) {
             $this->redirect(array('error'));
         } else {
             if (isset($_POST['student_id']) and $_POST['student_id'] != NULL) {
                 $allot = Allotment::model()->findByAttributes(array('student_id' => $_POST['student_id']));
                 if ($allot->student_id == $_POST['student_id']) {
                     $this->redirect(array('warning', 'transportation' => $_POST['Transportation'], 'student_id' => $_POST['student_id']));
                 }
             }
             if (isset($_POST['Transportation']['stop_id']) and $_POST['Transportation']['stop_id'] != NULL) {
                 $stop = StopDetails::model()->findByAttributes(array('id' => $_POST['Transportation']['stop_id']));
                 $route = RouteDetails::model()->findByAttributes(array('id' => $stop->route_id));
                 $vehicle = VehicleDetails::model()->findByAttributes(array('id' => $route->vehicle_id));
                 $connection = Yii::app()->db;
                 $sql = "SELECT t2.id FROM transportation AS t2 JOIN stop_details AS t1   WHERE t2.stop_id = t1.id AND t1.route_id= " . $stop->route_id;
                 $command = $connection->createCommand($sql);
                 $stops = $command->queryAll();
             }
             if ($vehicle->maximum_capacity >= count($stops)) {
                 if ($model->save()) {
                     $this->redirect(array('view', 'id' => $model->id));
                 }
             } else {
                 Yii::app()->user->setFlash('errorMessage', UserModule::t("No seat available in the vehicle!"));
                 $this->redirect(array('create'));
             }
         }
     }
     $this->render('create', array('model' => $model));
 }
 public function actionAssign()
 {
     $model = new DriverDetails();
     if (isset($_POST['search'])) {
         if (isset($_POST['driver_id']) and $_POST['driver_id'] != NULL) {
             $drive = DriverDetails::model()->findByAttributes(array('id' => $_POST['driver_id']));
             if (isset($_POST['vehicle_id']) and $_POST['vehicle_id'] != NULL) {
                 $vehicle = VehicleDetails::model()->findByAttributes(array('id' => $_POST['vehicle_id']));
                 if ($vehicle != NULL) {
                     $vehicle->status = 'C';
                     $vehicle->save();
                 }
                 $drive->vehicle_id = $_POST['vehicle_id'];
                 $drive->status = 'C';
                 $drive->save();
             }
             $this->render('assign', array('model' => $model, 'id' => $drive->id));
         } else {
             $this->render('error', array('model' => $model));
         }
     } else {
         $this->render('assign', array('model' => $model));
     }
 }
Beispiel #3
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', 'FuelConsumption');
?>
                </h1>
                <?php 
$driver = FuelConsumption::model()->findByAttributes(array('id' => $_REQUEST['id']));
$vehicle = VehicleDetails::model()->findByAttributes(array('id' => $driver->vehicle_id));
?>
              
			<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', 'Vehicle Code');
?>
                        </td>
                        <td align="center">
                            <?php 
echo Yii::t('transport', 'Fuel Consumed');
?>
                        </td>
Beispiel #4
0
    <td valign="top"> 
    <div class="cont_right">
     <h1><?php 
echo Yii::t('transport', 'Vehicle Details');
?>
</h1>
     <div class="edit_bttns" style="top:20px; right:20px;">
    <ul>
    <li> <?php 
echo CHtml::link('<span>' . Yii::t('transport', 'Enter Vehicle Details') . '</span>', array('/transport/vehicleDetails/create'), array('class' => 'addbttn last '));
?>
</li>
    </ul>
    </div>
    <?php 
$vehicle = VehicleDetails::model()->findAll('status=:x AND is_deleted=:y', array(':x' => 'C', ':y' => 0));
?>
         <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', 'Vehicle No.');
?>
</td>
        	<td align="center"><?php 
echo Yii::t('transport', 'no_of_seats');
?>
</td>
            <td align="center"><?php 
echo Yii::t('transport', 'maximum_capacity');
?>
 /**
  * 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 = VehicleDetails::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }
Beispiel #6
0
            <td>&nbsp;
            </td>
            <td>&nbsp;
            </td>
        </tr>
		<tr>
            <td>
                <?php 
echo $form->labelEx($model, Yii::t('transport', 'vehicle_id'));
?>
            </td>
            <td>&nbsp;
            </td>
            <td>
                <?php 
echo $form->dropDownList($model, 'vehicle_id', CHtml::listData(VehicleDetails::model()->findAll('status=:x', array(':x' => 'C')), 'id', 'vehicle_code'), array('prompt' => 'Select'));
?>
                <?php 
echo $form->error($model, 'vehicle_id');
?>
            </td>
        </tr>
        <tr>
        	<td>&nbsp;
            </td>
            <td>&nbsp;
            </td>
            <td>&nbsp;
            </td>
        </tr>
	
<?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');
Beispiel #8
0
        <tr>
            <td>
                <?php 
echo $form->labelEx($model, Yii::t('transport', 'Select Vehicle'), array('style' => 'float:left'));
?>
 <span class="required">*</span> 
            </td>
            <td>&nbsp;
            </td>
            <td>
                  <?php 
$criteria = new CDbCriteria();
$criteria->compare('is_deleted', 0);
?>
                <?php 
echo $form->dropDownList($model, 'vehicle_id', CHtml::listData(VehicleDetails::model()->findAll($criteria), 'id', 'vehicle_code'), array('prompt' => 'Select'));
?>
                <?php 
echo $form->error($model, 'vehicle_id');
?>
            </td>
        </tr>
        <tr>
        	<td>&nbsp;
            </td>
            <td>&nbsp;
            </td>
            <td>&nbsp;
            </td>
        </tr>
        <tr>
Beispiel #9
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', 'Vehicle Details');
?>
                </h1>
                <?php 
$driver = VehicleDetails::model()->findByAttributes(array('id' => $_REQUEST['id']));
?>
                <div class="pdtab_Con" >
                <table width="80%" border="0" cellspacing="0" cellpadding="0" style="text-align:center;">
                    <tr class="pdtab-h" style="font-weight:bold;">
                        <td>
                            <?php 
echo Yii::t('transport', 'Vehicle No');
?>
                        </td>
                        <td>
                            <?php 
echo Yii::t('transport', 'Vehicle Code');
?>
                        </td>
                        <td>