PHP AcademicTerm::model方法代码示例

 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search()
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $acdm_terms = AcademicTerm::model()->findAll('current_sem=1');
     $data = array();
     foreach ($acdm_terms as $list) {
         $data[] = $list['academic_term_id'];
     }
     $criteria->addInCondition('t.academic_name_id', $data, 'OR');
     $criteria->with = array('rel_batch_academic_period_id', 'rel_batch_academic_id', 'rel_division');
     $criteria->compare('rel_division.division_code', $this->division_code, true);
     //
     $criteria->compare('rel_batch_academic_period_id.academic_term_period', $this->academic_term_period, true);
     $criteria->compare('rel_batch_academic_id.academic_term_name', $this->academic_term_name, true);
     $criteria->compare('batch_id', $this->batch_id);
     $criteria->compare('batch_organization_id', $this->batch_organization_id);
     $criteria->compare('batch_created_by', $this->batch_created_by);
     $criteria->compare('batch_creation_date', $this->batch_creation_date, true);
     $criteria->compare('batch_code', $this->batch_code);
     $criteria->compare('t.branch_id', $this->branch_id);
     $criteria->compare('div_id', $this->div_id);
     $criteria->compare('academic_period_id', $this->academic_period_id);
     $criteria->compare('academic_name_id', $this->academic_name_id);
     $batch_data = new CActiveDataProvider(get_class($this), array('criteria' => $criteria));
     $_SESSION['batch_records'] = $batch_data;
     return $batch_data;
 }

 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search()
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $acdm_terms = AcademicTerm::model()->findAll('current_sem=1');
     //print_r($acdm_terms);exit;
     $data = array();
     foreach ($acdm_terms as $list) {
         $data[] = $list['academic_term_id'];
     }
     $criteria = new CDbCriteria();
     $criteria->select = array('distinct(student_fees_master_student_transaction_id), fees_master_table_id, student_info.student_enroll_no,student_info.student_roll_no,student_info.student_enroll_no,student_info.student_first_name,fees_master.fees_master_name');
     $criteria->join = 'LEFT JOIN student_info ON (student_info.student_info_transaction_id = t.student_fees_master_student_transaction_id) LEFT JOIN fees_master ON (fees_master.fees_master_id = t.fees_master_table_id) ';
     $criteria->addInCondition('fees_master.fees_academic_term_name_id', $data, 'OR');
     $criteria->compare('student_fees_master_id', $this->student_fees_master_id);
     $criteria->compare('student_fees_master_student_transaction_id', $this->student_fees_master_student_transaction_id);
     $criteria->compare('student_info.student_first_name', $this->student_first_name, true);
     $criteria->compare('student_info.student_enroll_no', $this->student_enroll_no, true);
     $criteria->compare('student_info.student_roll_no', $this->student_roll_no, true);
     $criteria->compare('fees_master_table_id', $this->fees_master_table_id);
     $criteria->compare('fees_master.fees_master_name', $this->fees_master_name, true);
     $criteria->compare('student_fees_master_details_id', $this->student_fees_master_details_id);
     $criteria->compare('fees_details_amount', $this->fees_details_amount);
     $criteria->compare('student_fees_master_org_id', $this->student_fees_master_org_id);
     $criteria->compare('student_fees_master_created_by', $this->student_fees_master_created_by);
     $criteria->compare('student_fees_master_creation_date', $this->student_fees_master_creation_date, true);
     $dp = new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'student_fees_master_id DESC')));
     $dp->setTotalItemCount(count($this->findAll($criteria)));
     return $dp;
 }

 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search()
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $acdm_terms = AcademicTerm::model()->findAll('current_sem=1');
     $data = array();
     foreach ($acdm_terms as $list) {
         $data[] = $list['academic_term_id'];
     }
     $criteria = new CDbCriteria();
     $criteria->with = array('Rel_Stud_Info', 'Rel_Status', 'Rel_Division', 'Rel_language', 'Rel_user');
     $criteria->addInCondition('student_academic_term_name_id', $data, 'OR');
     $criteria->addNotInCondition('student_transaction_detain_student_flag', array('1', '2'));
     $criteria->compare('student_transaction_id', $this->student_transaction_id);
     $criteria->compare('student_transaction_detain_student_flag', $this->student_transaction_detain_student_flag);
     $criteria->compare('student_transaction_user_id', $this->student_transaction_user_id);
     $criteria->compare('student_transaction_student_id', $this->student_transaction_student_id);
     $criteria->compare('student_transaction_branch_id', $this->student_transaction_branch_id, true);
     $criteria->compare('student_transaction_category_id', $this->student_transaction_category_id);
     $criteria->compare('student_transaction_organization_id', $this->student_transaction_organization_id);
     $criteria->compare('student_transaction_student_address_id', $this->student_transaction_student_address_id);
     $criteria->compare('student_transaction_nationality_id', $this->student_transaction_nationality_id);
     $criteria->compare('student_transaction_quota_id', $this->student_transaction_quota_id);
     $criteria->compare('student_transaction_religion_id', $this->student_transaction_religion_id);
     $criteria->compare('student_transaction_shift_id', $this->student_transaction_shift_id);
     $criteria->compare('student_transaction_languages_known_id', $this->student_transaction_languages_known_id);
     $criteria->compare('student_transaction_student_photos_id', $this->student_transaction_student_photos_id);
     $criteria->compare('student_transaction_division_id', $this->student_transaction_division_id);
     $criteria->compare('student_transaction_batch_id', $this->student_transaction_batch_id);
     $criteria->compare('student_academic_term_period_tran_id', $this->student_academic_term_period_tran_id);
     $criteria->compare('student_academic_term_name_id', $this->student_academic_term_name_id);
     $criteria->compare('Rel_user.user_organization_email_id', $this->user_organization_email_id, true);
     //$criteria->compare('Rel_Branch.branch_name',$this->branch_name,true);
     $criteria->compare('Rel_Stud_Info.student_first_name', $this->student_first_name, true);
     $criteria->compare('Rel_Stud_Info.student_living_status', $this->student_living_status, true);
     $criteria->compare('Rel_Stud_Info.student_enroll_no', $this->student_enroll_no, true);
     $criteria->compare('Rel_Stud_Info.student_roll_no', $this->student_roll_no, true);
     $criteria->compare('Rel_Stud_Info.student_middle_name', $this->student_middle_name, true);
     $criteria->compare('Rel_Stud_Info.student_last_name', $this->student_last_name, true);
     $criteria->compare('Rel_Stud_Info.student_dtod_regular_status', $this->student_dtod_regular_status, true);
     $criteria->compare('Rel_Division.division_name', $this->division_name, true);
     $criteria->compare('Rel_Status.status_name', $this->status_name, true);
     $criteria->compare('Rel_Stud_Info.student_mobile_no', $this->student_mobile_no, true);
     $criteria->compare('Rel_Stud_Info.student_email_id_1', $this->student_email_id_1, true);
     $stud_data = new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'student_transaction_id DESC')));
     $_SESSION['Student_records'] = $stud_data;
     return $stud_data;
 }

	public function actiongetAllStud()
        {
           // $data=  AcademicTerm::model()->findAll('academic_term_period_id=:academic_term_period_id',
		// array(':academic_term_period_id'=>(int) $_REQUEST['StudentTransaction']['student_academic_term_period_tran_id']));

		$data=  AcademicTerm::model()->findAll();
                  
        $data=CHtml::listData($data,'academic_term_id','academic_term_name');
	echo "<option value=''>Select Semester</option>";
  
          foreach($data as $value=>$name)
            {
                echo CHtml::tag('option',
                        array('value'=>$value),CHtml::encode('Sem-'.$name),true);
            }
        }

 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search()
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $acdm_terms = AcademicTerm::model()->findAll('current_sem=1');
     $data = array();
     foreach ($acdm_terms as $list) {
         $data[] = $list['academic_term_id'];
     }
     $criteria->addInCondition('academic_name_id', $data, 'OR');
     $criteria->compare('division_id', $this->division_id);
     $criteria->compare('division_name', $this->division_name, true);
     $criteria->compare('division_organization_id', $this->division_organization_id);
     $criteria->compare('division_created_by', $this->division_created_by);
     $criteria->compare('division_creation_date', $this->division_creation_date, true);
     $criteria->compare('branch_id', $this->branch_id, true);
     $criteria->compare('academic_period_id', $this->academic_period_id);
     $criteria->compare('academic_name_id', $this->academic_name_id);
     $criteria->compare('division_code', $this->division_code);
     $division_data = new CActiveDataProvider(get_class($this), array('criteria' => $criteria, 'sort' => array('attributes' => array('branch_name' => array('asc' => 'Rel_Branch.branch_name', 'desc' => 'Rel_Branch.branch_name DESC'), '*'))));
     $_SESSION['division_data'] = $division_data;
     return $division_data;
 }

<?php

$this->breadcrumbs = array('Chart Report');
echo CHtml::link('GO BACK', Yii::app()->createUrl('attendence/ChartReport'));
?>

<?php 
$acdm_name = AcademicTerm::model()->findAll(array('condition' => 'academic_term_period_id=' . $acdm_period . ' and  academic_term_organization_id=' . Yii::app()->user->getState('org_id')));
//print_r($acdm_name);
//exit;
$branch = Attendence::model()->findAll(array('select' => 'branch_id', 'condition' => 'sem_id=' . $acdm_period . ' and attendence_organization_id=' . Yii::app()->user->getState('org_id'), 'distinct' => true));
$m = 1;
if ($branch) {
    ?>

<table class="table_data" align=center border="1" style="width:960px; font-size:12px;">
	
<th colspan="11" style="font-size: 18px; color: rgb(255, 255, 255);">
		Attendance Chart Table


        </th>	
<tr class="table_header">
<th>Branch Name\Semester</th>
<?php 
    foreach ($acdm_name as $ac) {
        ?>

<th>
<?php 
        echo "Sem-" . $ac['academic_term_name'];

<th>Bank Name</th>
<th>Cheque No</th>
<th>Receipt No</th>
<th>Amount</th>
</tr>


<?php 
    foreach ($var as $list) {
        $stud_data = StudentTransaction::model()->findByPk($list['fees_student_id']);
        echo '<tr><td>' . $i . '</td>';
        echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_enroll_no . '</td>';
        echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_roll_no . '</td>';
        echo '<td>' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_first_name . ' ' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_middle_name . ' ' . StudentInfo::model()->findByPk($stud_data->student_transaction_student_id)->student_last_name . '</td>';
        echo '<td>' . Branch::model()->findByPk($stud_data->student_transaction_branch_id)->branch_name . '</td>';
        echo '<td>' . AcademicTerm::model()->findByPk($stud_data->student_academic_term_name_id)->academic_term_name . '</td>';
        echo '<td>' . AcademicTermPeriod::model()->findByPk($stud_data->student_academic_term_period_tran_id)->academic_term_period . '</td>';
        echo '<td>' . Division::model()->findByPk($stud_data->student_transaction_division_id)->division_name . '</td>';
        echo '<td>' . $list['fees_received_date'] . '</td>';
        $rec_no = FeesReceipt::model()->findByPk($list['fees_receipt_id'])->fees_receipt_number;
        if ($list['fees_payment_method_id'] == '1') {
            $cash_id = $list['fees_payment_cash_cheque_id'];
            $amunt = FeesPaymentCash::model()->findByPk($cash_id)->fees_payment_cash_amount;
            $final_total += $amunt;
            $type = "Cash";
            echo '<td>' . $type . '</td>';
            echo '<td>-</td>';
            echo '<td>-</td>';
            echo '<td>' . $rec_no . '</td>';
            echo '<td>' . $amunt . '</td>';
        } else {

 /**
  * Updates a particular model.
  * If update is successful, the browser will be redirected to the 'view' page.
  * @param integer $id the ID of the model to be updated
  */
 public function actionUpdate($id)
 {
     $model = $this->loadModel($id);
     // Uncomment the following line if AJAX validation is needed
     $this->performAjaxValidation($model);
     if (isset($_POST['Division'])) {
         $model->attributes = $_POST['Division'];
         $model->division_code = '';
         $divname = $model->division_name;
         $branch_code = Branch::model()->findByPk($model->branch_id)->branch_alias;
         $acdm_name = AcademicTerm::model()->findByPk($model->academic_name_id)->academic_term_name;
         $concatdivname = $divname . '-' . $branch_code . '-' . $acdm_name;
         $model->division_code = $concatdivname;
         if ($model->save()) {
             $this->redirect(array('admin'));
         }
         //$this->redirect(array('view','id'=>$model->division_id));
     }
     $this->render('update', array('model' => $model));
 }

	}
	table tr:nth-child(odd) { /*(odd) or (2n 1)*/
		background: white;
	}
	th{text-align:left;font-weight:normal;color:#990a10;width:110px;border:0.4px solid #74b9f0;height:24px;}
	.title{color:seagreen;}
	td{border:0.4px solid #74b9f0;height:24px;}
	.label{text-align:left;font-weight:normal;color:#990a10;width:110px;height:24px;}
	
	
	
</style>
<?php
$StudentInfo = StudentInfo::model()->findByPk($student_transaction[0]->student_transaction_student_id);
$AcademicTermPeriod = AcademicTermPeriod::model()->findByPk($student_transaction[0]->academic_term_period_id);
$AcademicTerm = AcademicTerm::model()->findByPk($student_transaction[0]->academic_term_id);
if($student_transaction[0]->student_transaction_nationality_id != null)
$Nationality = Nationality::model()->findByPk($student_transaction[0]->student_transaction_nationality_id);
else
$Nationality = new Nationality;
$Batch = Batch::model()->findByPk($student_transaction[0]->student_transaction_batch_id);
$Course = Course::model()->findByPk($student_transaction[0]->course_id);
if($student_transaction[0]->student_transaction_languages_known_id != null)
$LanguagesKnown = LanguagesKnown::model()->findByPk($student_transaction[0]->student_transaction_languages_known_id);
if($student_transaction[0]->student_transaction_student_address_id != null)
$StudentAddress = StudentAddress::model()->findByPk($student_transaction[0]->student_transaction_student_address_id);
else
$StudentAddress = new StudentAddress;
if($student_transaction[0]->student_transaction_parent_id != null || $student_transaction[0]->student_transaction_parent_id != 0)
$parent = ParentLogin::model()->findByPk($student_transaction[0]->student_transaction_parent_id);
else

			$payType='';
		 if($details['fees_payment'] == 1)
			  $payType='Credit';
		 if($details['fees_payment'] == 2) 
			$payType='Outstanding';
		 if($details['fees_payment'] == 3)
			  $payType='Advance';
		if(!empty($assignFees[0]['student_fees_master_sem_id']))
		{
			if($paid_amount==0)
			{
				$myclass = $paid_amount == 0 ? 'red' : 'black';
				echo "<b style=color:$myclass>".'Sem-'.AcademicTerm::model()->findByPk($assignFees[0]['student_fees_master_sem_id'])->academic_term_name.'  '.$paid_amount.' (Not Paid)'."</b></br>";	
			}
			else	
	     		 echo 'Sem-'.AcademicTerm::model()->findByPk($assignFees[0]['student_fees_master_sem_id'])->academic_term_name.'  '.$paid_amount.' ('.$payType.')'."</br>";
		}
		else
			echo '-';
		$paidAmt+=$paid_amount;
		}	
		echo "</td>";		
     		}
     	        else
	        {
		   echo '<td>-</td>';
	        }
          }	 
  	echo '<td>'.$paidAmt.'</td>';	
     }   // student loop
}   //branch loop

 foreach ($fees_student as $data) {
     //$stud_trans = StudentTransaction::model()->findByPk($data['fees_student_id']);
     if (!empty($branch1)) {
         if (!empty($div)) {
             $stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id'], 'student_transaction_branch_id' => $branch1, 'student_transaction_division_id' => $div));
         } else {
             $stud_trans = StudentTransaction::model()->findByAttributes(array('student_transaction_id' => $data['fees_student_id'], 'student_transaction_branch_id' => $branch1));
         }
     } else {
         $stud_trans = StudentTransaction::model()->findByPk($data['fees_student_id']);
     }
     if (empty($stud_trans)) {
         continue;
     }
     $stud_model = StudentInfo::model()->findByAttributes(array('student_id' => $stud_trans['student_transaction_student_id']));
     $sem_name = AcademicTerm::model()->findByPk($data['fees_academic_term_id']);
     $branch = Branch::model()->findByPk($stud_trans['student_transaction_branch_id']);
     $acd_term = AcademicTermPeriod::model()->findByPk($data['fees_academic_period_id']);
     $field1 = '-';
     $field2 = '-';
     $field3 = '-';
     $field4 = '-';
     $field5 = 'CASH';
     if ($data['fees_payment_method_id'] == 1) {
         $cash_amt = FeesPaymentCash::model()->findByPk($data['fees_payment_cash_cheque_id']);
         $amount = $cash_amt->fees_payment_cash_amount;
     } else {
         $cash_amt = FeesPaymentCheque::model()->findByPk($data['fees_payment_cash_cheque_id']);
         $amount = $cash_amt->fees_payment_cheque_amount;
         $field1 = $cash_amt->fees_payment_cheque_number;
         $date = date_create($cash_amt->fees_payment_cheque_date);

 filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=3);
writing-mode: lr-tb;
 width:100%;
 overflow:inherit;
    }
</style>
<?php 
if(isset($div_id))
{
 
$month_value = $month;
$div_model = Division::model()->findByPk($div_id);
$num = cal_days_in_month(CAL_GREGORIAN, $month_value, date('Y')); 
$colspan=$num+7;
$branch_model=Branch::model()->findByPk($branch_id);
 $acd_model = AcademicTerm::model()->findByPk($sem);
$sub = SubjectMaster::model()->findByPk($selsub);
?>
<?php
 $org = Organization::model()->findAll();
 $org_data=$org[0];

echo '<table border="2" > ';
	echo "<tr align=center> <th  colspan = 15 style=text-align:left;> ".CHtml::image(Yii::app()->controller->createUrl('/site/loadImage', array('id'=>$org_data->organization_id)),'No Image',array('width'=>80,'height'=>55,'style'=>'float:left;margin-left:200px;')) ."
	 <big> <b>".$org_data->organization_name ."</big><br>". $org_data->address_line1." ".$org_data->address_line2."</br>"  . City::model()->findBypk($org_data->city)->city_name.", ".State::model()->findBypk($org_data->state)->state_name.", ".Country::model()->findBypk($org_data->country)->name."." ." </th> <br>	 </tr>";
?>

<?php //echo "<td colspan=$colspan>";
echo "<tr><th colspan=20><h3> Branch  of ".$branch_model->branch_name." Students of Semester-".$acd_model->academic_term_name." , Subject-".$sub->subject_master_name ."  In Month - ". date("F", mktime(0,0,0,$month)) ." Attendence Report</h3></th> </tr>";

		{?>
			<tr class="<?php echo $class;?>">
				<td><?php echo ++$i;?></td>
				<td><?php echo AcademicTermPeriod::model()->findByPk($if_detain['academic_term_period_id'])->academic_term_period; ?></td>
				<td><?php echo "Sem-".AcademicTerm::model()->findByPk($if_detain['sem'])->academic_term_name; ?></td>
				<td>Detain</td>
			</tr>
		<?php $m++; $st="Rejoin/Regular";
		}
		$if_stud_arch = StudentArchiveTable::model()->findByAttributes(array('student_archive_stud_tran_id'=>$stud_trans[0]['student_transaction_id'],'student_archive_ac_t_n_id'=>$data['academic_term_id']));
		if($if_stud_arch)
		{?>
			<tr class="<?php echo $class;?>">
				<td><?php echo ++$i;?></td>
				<td><?php echo AcademicTermPeriod::model()->findByPk($if_stud_arch['student_archive_ac_t_p_id'])->academic_term_period; ?></td>
				<td><?php echo "Sem-".AcademicTerm::model()->findByPk($if_stud_arch['student_archive_ac_t_n_id'])->academic_term_name; ?></td>
				<td><?php echo $st;?></td>
			</tr>
				
		<?php $m++; }
	
	}
	

?>

</table>

<?php } ?>
<?php
/*   $stud_inf_id = $stud_trans[0]['student_id'];

	array('label'=>'List StudentFeesMaster', 'url'=>array('index')),
	array('label'=>'Create StudentFeesMaster', 'url'=>array('create')),
	array('label'=>'View StudentFeesMaster', 'url'=>array('view', 'id'=>$model->student_fees_master_id)),
	array('label'=>'Manage StudentFeesMaster', 'url'=>array('admin')),
);*/
?>

<h1>Edit Student Fees  <?php 
//echo $model->student_fees_master_id;
?>
</h1></br>
<?php 
$stud_info = StudentInfo::model()->findByAttributes(array('student_info_transaction_id' => $model->student_fees_master_student_transaction_id));
$stud_tran_info = StudentTransaction::model()->findByPk($model->student_fees_master_student_transaction_id);
$academic_period = AcademicTermPeriod::model()->findByPk($stud_tran_info->student_academic_term_period_tran_id)->academic_term_period;
$semester = AcademicTerm::model()->findByPk($stud_tran_info->student_academic_term_name_id)->academic_term_name;
?>
<table  border="2px" id="twoColThinTable">
<tr class="row">
	<td class="col1">Name </td>
	<td class="col2"><?php 
echo $stud_info->student_first_name . ' ' . $stud_info->student_middle_name . ' ' . $stud_info->student_last_name;
?>
</td>
</tr>	

<tr class="row">	
	<td class="col1">Enrollment No. </td> 
	<td class="col2"><?php 
echo $stud_info->student_enroll_no;
?>

<?php

$this->breadcrumbs = array('Division Report');
?>


<?php 
echo CHtml::link('GO BACK', Yii::app()->createUrl('/student/attendence/attendencedivisionreport'));
$m = 1;
if ($subject) {
    $this->menu[] = array('label' => '', 'url' => array('attendencedivisionreport', 'pdf' => 'pdf', 'div_id' => $div_id), 'linkOptions' => array('class' => 'export-pdf', 'title' => 'Export to PDF', 'target' => '_blank'));
    $this->menu[] = array('label' => '', 'url' => array('attendencedivisionreport', 'excel' => 'excel', 'div_id' => $div_id), 'linkOptions' => array('class' => 'export-excel', 'title' => 'Export to Excel', 'target' => '_blank'));
    $div_model = Division::model()->findByPk($div_id);
    $acd_model = AcademicTerm::model()->findByPk($div_model->academic_name_id);
    ?>
<table  border="2px" id="twoColThinTable">
<tr class="row">	
	<td class="col1">Division </td> 
	<td class="col2"><?php 
    echo $div_model->division_code;
    ?>
</td>
</tr>	
<tr class="row">
	<td class="col1">Semester </td> 
	<td class="col2"> <?php 
    echo $acd_model->academic_term_name;
    ?>
</td>
</tr>
	<tr class="row">