model() public static méthode

Returns the static model of the specified AR class.
public static model ( $className = __CLASS__ ) : Referral
Résultat Referral the static model class
 public function deactivate($contractor_id)
 {
     $criteria = new CDbCriteria();
     $criteria->condition = "user_type='contractor' AND userid=" . $contractor_id;
     Affiliates::model()->deleteAll($criteria);
     Referral::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "owner_user_type='contractor' AND owner_id=" . $contractor_id;
     Answers::model()->deleteAll($criteria);
     Questions::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "user_type='contractor' AND deleted_by=" . $contractor_id;
     Messagedeleted::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "from_user_type='contractor' AND from_id=" . $contractor_id;
     Messages::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "to_user_type='contractor' AND to_id=" . $contractor_id;
     Messages::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "viewed_user_type='contractor' AND viewed_by=" . $contractor_id;
     QuestionViews::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "referred_by_type='contractor' AND referred_by=" . $contractor_id;
     Referral::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "invited_id=" . $contractor_id;
     ContractorTeam::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "contractor_id=" . $contractor_id;
     ContractorBond::model()->deleteAll($criteria);
     ContractorLicense::model()->deleteAll($criteria);
     ContractorPoints::model()->deleteAll($criteria);
     ContractorSocials::model()->deleteAll($criteria);
     ContractorTeam::model()->deleteAll($criteria);
     ContractorViews::model()->deleteAll($criteria);
     Contractorphotos::model()->deleteAll($criteria);
     Feedback::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "ContractorId=" . $contractor_id;
     self::model()->deleteAll($criteria);
     return true;
 }
 /**
  * Return the open referral choices for the patient.
  *
  * @return Referral[]
  */
 public function getReferralChoices($element = null)
 {
     $criteria = new CdbCriteria();
     $criteria->addCondition('patient_id = :pid');
     $criteria->addCondition('closed_date is null');
     $criteria->params = array('pid' => $this->patient->id);
     // if the referral has been closed but is the selected referral for the event, needs to be part of the list
     if ($element && $element->referral_id) {
         $criteria->addCondition('id = :crid', 'OR');
         $criteria->params[':crid'] = $element->referral_id;
     }
     $criteria->order = 'received_date DESC';
     return Referral::model()->findAll($criteria);
 }
 public function actionCommReportYearly()
 {
     date_default_timezone_set("Asia/Manila");
     $activity = new Activity();
     $activity->act_desc = 'Searched Yearly Committe Report per Committe';
     $activity->act_datetime = date('Y-m-d G:i:s');
     $activity->act_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
     $activity->save();
     $comm_name = '';
     $ref_id = '';
     $year = date('Y');
     if (isset($_POST['searchButton'])) {
         $comm_name = $_POST['comm_name'];
         $year = $_POST['year'];
         $x = Committee::model()->findByPK($comm_name);
         $referrals = CHtml::listData(Referral::model()->findAll(array('condition' => 'lead_committee = :lcomm', 'params' => array(':lcomm' => $x->comm_id))), 'ref_id', 'ref_id');
         $criteria = new CDbCriteria();
         $criteria->condition = "action_taken <> 0 and comm_report like :comm_rep";
         $criteria->params = array(':comm_rep' => $year . '%');
         $criteria->addInCondition("ref_id", $referrals);
         $criteria->order = 'comm_report asc';
         $dataProviderReso = new CActiveDataProvider('CommMeetingReso', array('criteria' => $criteria, 'pagination' => array('pageSize' => 20)));
         $dataProviderOrd = new CActiveDataProvider('CommMeetingOrdi', array('criteria' => $criteria, 'pagination' => array('pageSize' => 20)));
         date_default_timezone_set("Asia/Manila");
         $activity = new Activity();
         $activity->act_desc = 'Searched Yearly Committe Report of ' . $x->comm_name;
         $activity->act_datetime = date('Y-m-d G:i:s');
         $activity->act_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
         $activity->save();
     } else {
         $dataProviderReso = new CActiveDataProvider('CommMeetingReso', array('criteria' => array('condition' => 'action_taken <> 0 or comm_report = null'), 'pagination' => array('pageSize' => 20)));
         $dataProviderOrd = new CActiveDataProvider('CommMeetingOrdi', array('criteria' => array('condition' => 'action_taken <> 0 or comm_report = null'), 'pagination' => array('pageSize' => 20)));
     }
     $this->render('commReportYearly', array('comm_name' => $comm_name, 'year' => $year, 'dataProviderReso' => $dataProviderReso, 'dataProviderOrd' => $dataProviderOrd));
 }
Exemple #4
0
 public function getReferralDate($ctrl)
 {
     if ($ctrl) {
         $x = CommMeetingOrdi::model()->findByAttributes(array('meeting_ordi_id' => $ctrl))->ref_id;
         return Referral::model()->findByPK($x)->date_referred;
     } else {
         return 'No Referral Date';
     }
 }
 /**
  * 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['CommMeetingReso'])) {
         $model->attributes = $_POST['CommMeetingReso'];
         $model->archive = 0;
         $ref_id = Referral::model()->findByAttributes(array('ctrl_no' => $model->ref_id))->ref_id;
         $model->ref_id = $ref_id;
         $model->remark = 0;
         if ($model->action_taken != 0) {
             //Status::model()->updateAll(array('referral_stat' => 1), 'ctrl_no = ' . $model->ref->ctrl_no);
             Referral::model()->updateByPK($model->ref_id, array('referral_stat' => 1));
             $stat = Status::model()->findByAttributes(array('ctrl_no' => $model->ref->ctrl_no));
             $stat->ctrl_no = $model->ref->ctrl_no;
             $stat->comm_meeting_stat = 1;
             $stat->remarks = 0;
             $stat->save();
             //die('approve');
         } else {
             $stat = Status::model()->findByAttributes(array('ctrl_no' => $model->ref->ctrl_no));
             $stat->ctrl_no = $model->ref->ctrl_no;
             $stat->comm_meeting_stat = 0;
             $stat->remarks = 0;
             $stat->save();
             //die('pending');
         }
         $picture_name = '';
         $picture_file = CUploadedFile::getInstance($model, 'comm_rep_file');
         $model->comm_rep_file = $picture_file;
         $year = substr($model->ref->ctrl_no, 0, 4);
         if ($picture_file) {
             $picture_name = $picture_file->name;
             if (!is_dir(Yii::getPathOfAlias('webroot') . '/protected/document/commMeetingReso/' . $year)) {
                 mkdir(Yii::getPathOfAlias('webroot') . '/protected/document/commMeetingReso/' . $year);
                 mkdir(Yii::getPathOfAlias('webroot') . '/protected/document/commMeetingReso/' . $year . '/' . $model->ref->ctrl_no);
                 $picture_file->SaveAs(Yii::getPathOfAlias('webroot') . '/protected/document/commMeetingReso/' . $year . '/' . $model->ref->ctrl_no . '/' . $picture_file->getName());
             } else {
                 if (!file_exists(Yii::getPathOfAlias('webroot') . '/protected/document/commMeetingReso/' . $year . '/' . $model->ref->ctrl_no)) {
                     //die('exists');
                     //mkdir(Yii::getPathOfAlias('webroot').'/protected/document/commMeetingReso/'.$year.'/'.$model->ref->ctrl_no);
                     $picture_file->SaveAs(Yii::getPathOfAlias('webroot') . '/protected/document/commMeetingReso/' . $year . '/' . $model->ref->ctrl_no . '/' . $picture_file->getName());
                 } else {
                     //mkdir(Yii::getPathOfAlias('webroot').'/protected/document/commMeetingReso/'.$year.'/'.$model->ref->ctrl_no);
                     $picture_file->SaveAs(Yii::getPathOfAlias('webroot') . '/protected/document/commMeetingReso/' . $year . '/' . $model->ref->ctrl_no . '/' . $picture_file->getName());
                 }
             }
         }
         if ($model->save() && $model->validate()) {
             date_default_timezone_set("Asia/Manila");
             $activity = new Activity();
             $activity->act_desc = 'Updated Committee Meeting ID: ' . $id;
             $activity->act_datetime = date('Y-m-d G:i:s');
             $activity->act_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
             $activity->save();
             $this->redirect(array('view', 'id' => $model->meeting_reso_id));
         }
     }
     $this->render('update', array('model' => $model));
 }
          <td style="border-top-style: 1px solid black;">' . $origin . '</td>';
 $tbl .= '</tr>';
 if ($referral == '0000-00-00') {
     $tbl .= '<tr nobr="true">
              <td style="border-top-style: 1px solid black; font-size:16px; font-weight:bold;">C) Referral Date</td>
              <td style="border-top-style: 1px solid black;">: N/A</td>';
 } else {
     $tbl .= '<tr nobr="true">
              <td style="border-top-style: 1px solid black; font-size:16px; font-weight:bold;">C) Referral Date</td>
              <td style="border-top-style: 1px solid black;">' . $refer1->format('M j, Y') . '</td>';
 }
 $tbl .= '</tr>';
 $tbl .= '<tr nobr="true">
          <td style="border-top-style: 1px solid black; font-size:15px; font-weight:bold;">D) Date Meeting/s</td>';
 $meetings = '';
 $temp = Referral::model()->findByAttributes(array('ctrl_no' => $model->ctrl_no));
 if (empty($temp)) {
     $meetings = '0000-00-00';
 } else {
     $x = CommMeetingReso::model()->find(array('condition' => 'ref_id = "' . $temp->ref_id . '"'));
     if ($x == null) {
         $meetings = '0000-00-00';
     } else {
         $IAs = CommMeetingReso::model()->findAll(array('condition' => 'ref_id = "' . $temp->ref_id . '"', 'order' => 'date_meeting desc'));
         $iaName = CHtml::listData($IAs, 'date_meeting', 'date_meeting');
         foreach ($iaName as $val) {
             $meetings = $val . '' . $meetings;
         }
     }
 }
 $meetings1 = new DateTime($meetings, $timezone);
Exemple #7
0
 public function countCommMeetingOrdi()
 {
     $cat = Category::model()->findByAttributes(array('cat_name' => 'Provincial Ordinance'))->cat_id;
     $result = CHtml::listData(Communication::model()->findAll(array('condition' => 'cat_id = ' . $cat . ' and comm_stat=1')), 'ctrl_no', 'ctrl_no');
     $criteria = new CDbCriteria();
     $criteria->condition = 'archive=0 and referral_stat=0';
     $criteria->addInCondition("ctrl_no", $result);
     $criteria->compare('ctrl_no', $this->ctrl_no, true);
     return Referral::model()->findAll($criteria);
 }
Exemple #8
0
?>
<br>
<div class="span8">
<div class="wide form">

<?php 
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('action' => Yii::app()->createUrl($this->route), 'method' => 'get'));
CHtml::$afterRequiredLabel = '';
?>

	<?php 
echo $form->dropDownListRow($model, 'meeting_ordi_id', CHtml::listData(CommMeetingOrdi::model()->findAll(), 'meeting_ordi_id', 'meeting_ordi_id'), array('class' => 'span3', 'prompt' => 'Committee Meeting ID'));
?>

	<?php 
echo $form->dropDownListRow($model, 'ref_id', CHtml::listData(Referral::model()->findAll(), 'ref_id', 'ctrl_no'), array('class' => 'span3', 'prompt' => 'Control Number'));
?>

	<?php 
echo $form->dropDownListRow($model, 'action_taken', array(0 => 'Pending', 1 => 'Approved', 2 => 'Return to Origin'), array('class' => 'span3', 'prompt' => 'Action Taken'));
?>

	<?php 
echo $form->datepickerRow($model, 'date_meeting', array('prepend' => '<i class="icon-calendar"></i>', 'options' => array('format' => 'yyyy-mm-dd')));
?>

	<?php 
echo $form->datepickerRow($model, 'public_hearing', array('prepend' => '<i class="icon-calendar"></i>', 'options' => array('format' => 'yyyy-mm-dd')));
?>

 /**
  * 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 $id the ID of the model to be loaded
  * @return Referral the loaded model
  * @throws CHttpException
  */
 public function loadModel($id)
 {
     $model = Referral::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }
Exemple #10
0
 public function getTitle($d)
 {
     $x = Referral::model()->findByAttributes(array('ctrl_no' => $d));
     if (!empty($x->ref_id)) {
         if ($this->cat->cat_name == 'Provincial Ordinance') {
             $ord = CommMeetingOrdi::model()->findAll(array('condition' => 'ref_id=' . $x->ref_id, 'order' => 'date_meeting desc', 'limit' => 1));
             $y = '';
             foreach ($ord as $key) {
                 $y = $key->meeting_ordi_id;
             }
             if (!empty(Ordinance::model()->findByAttributes(array('meeting_ordi_id' => $y))->ord_no)) {
                 echo 'Ord No. ' . Ordinance::model()->findByAttributes(array('meeting_ordi_id' => $y))->ord_no;
             } else {
                 echo 'None';
             }
         } else {
             $reso = CommMeetingReso::model()->findAll(array('condition' => 'ref_id=' . $x->ref_id, 'order' => 'date_meeting desc', 'limit' => 1));
             foreach ($reso as $key) {
                 if (!empty($key->comm_report)) {
                     if (!empty(Resolution::model()->findByAttributes(array('ctrl_no' => $d))->res_no)) {
                         echo 'Res No. ' . Resolution::model()->findByAttributes(array('ctrl_no' => $d))->res_no;
                     } else {
                         echo 'None';
                     }
                 } else {
                     echo 'None';
                 }
             }
         }
     } else {
         if (!empty(Resolution::model()->findByAttributes(array('ctrl_no' => $d))->res_no)) {
             echo 'Res No. ' . Resolution::model()->findByAttributes(array('ctrl_no' => $d))->res_no;
         } else {
             echo 'None';
         }
     }
 }
 public function actionCreate($id)
 {
     $model = new Ordinance();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     $count = count(Ordinance::model()->findAll()) + 1;
     if ($count <= 99) {
         if ($count <= 9) {
             $count = '00' . $count . ' - ' . date('Y');
         } else {
             $count = '0' . $count . ' - ' . date('Y');
         }
     } else {
         $count = $count . ' - ' . date('Y');
     }
     if (isset($_POST['Ordinance'])) {
         $model->attributes = $_POST['Ordinance'];
         $x = CommMeetingOrdi::model()->find(array('condition' => 'comm_report IS NOT NULL and ref_id = ' . Referral::model()->findByAttributes(array('ctrl_no' => $model->meeting_ordi_id))->ref_id))->meeting_ordi_id;
         $model->meeting_ordi_id = $x;
         $model->archive = 0;
         $picture_name = '';
         $picture_file = CUploadedFile::getInstance($model, 'ordi_file');
         $model->ordi_file = $picture_file;
         if ($picture_file) {
             $picture_name = $picture_file->name;
             if (!is_dir(Yii::getPathOfAlias('webroot') . '/protected/document/ordinance/' . substr($model->ord_no, 6, 9))) {
                 mkdir(Yii::getPathOfAlias('webroot') . '/protected/document/ordinance/' . substr($model->ord_no, 6, 9));
             }
             if (!is_dir(Yii::getPathOfAlias('webroot') . '/protected/document/ordinance/' . substr($model->ord_no, 6, 9) . '/' . $model->ord_no)) {
                 mkdir(Yii::getPathOfAlias('webroot') . '/protected/document/ordinance/' . substr($model->ord_no, 6, 9) . '/' . $model->ord_no);
                 $picture_file->SaveAs(Yii::getPathOfAlias('webroot') . '/protected/document/ordinance/' . substr($model->ord_no, 6, 9) . '/' . $model->ord_no . '/' . $picture_file->getName());
             } else {
                 $picture_file->SaveAs(Yii::getPathOfAlias('webroot') . '/protected/document/ordinance/' . substr($model->ord_no, 6, 9) . '/' . $model->ord_no . '/' . $picture_file->getName());
             }
         }
         $model->author = implode(',', $model->author);
         $model->imp_agency = implode(',', $model->imp_agency);
         $model->input_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
         //-------------------------------------------------
         $stat = Status::model()->findByAttributes(array('ctrl_no' => $model->meetingOrdi->ref->ctrl_no));
         $stat->remarks = 1;
         $stat->save();
         CommMeetingOrdi::model()->updateByPK($model->meeting_ordi_id, array('comm_meeting_stat' => 1, 'ord_remark' => 1));
         if ($model->save() && $model->validate()) {
             date_default_timezone_set("Asia/Manila");
         }
         $activity = new Activity();
         $activity->act_desc = 'Added Another Ordinance';
         $activity->act_datetime = date('Y-m-d G:i:s');
         $activity->act_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
         $activity->save();
         $this->redirect(array('view', 'id' => $model->ord_no));
     }
     $this->render('create', array('model' => $model, 'count' => $count, 'id' => $id));
 }
 /**
  * Ensure that referral assigned to the element is for the correct patient.
  *
  * @param $attribute
  * @param $params
  *
  * @throws Exception
  */
 public function validateReferral($attribute, $params)
 {
     if (!$this->canChangeReferral() && $this->{$attribute} != $this->_original_referral_id) {
         $this->addError($attribute, 'Referral cannot be changed after an operation has been scheduled');
     } elseif ($referral_id = $this->{$attribute}) {
         if (!($referral = Referral::model()->findByPk($referral_id))) {
             throw new Exception('Invalid referral id set on ' . get_class($this));
         }
         if ($referral->patient_id != $this->getPatient()->id) {
             $this->addError($attribute, 'Referral must be for the patient of the event');
         }
     }
 }
Exemple #13
0
 public function deactivate($homeowner_id)
 {
     $criteria = new CDbCriteria();
     $criteria->condition = "user_type='homeowner' AND userid=" . $homeowner_id;
     Affiliates::model()->deleteAll($criteria);
     Referral::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "owner_user_type='homeowner' AND owner_id=" . $homeowner_id;
     Answers::model()->deleteAll($criteria);
     Questions::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "user_type='homeowner' AND deleted_by=" . $homeowner_id;
     Messagedeleted::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "from_user_type='homeowner' AND from_id=" . $homeowner_id;
     Messages::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "to_user_type='homeowner' AND to_id=" . $homeowner_id;
     Messages::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "project_id NOT IN (Select project_id from projects where homeowner_id = {$homeowner_id} )";
     Projectphotos::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "viewed_user_type='homeowner' AND viewed_by=" . $homeowner_id;
     QuestionViews::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "referred_by_type='homeowner' AND referred_by=" . $homeowner_id;
     Referral::model()->deleteAll($criteria);
     $criteria = new CDbCriteria();
     $criteria->condition = "homeowner_id=" . $homeowner_id;
     HomeownerPoints::model()->deleteAll($criteria);
     Feedback::model()->deleteAll($criteria);
     HomeownerViews::model()->deleteAll($criteria);
     Projects::model()->deleteAll($criteria);
     self::model()->deleteAll($criteria);
     return true;
 }
Exemple #14
0
$box = $this->beginWidget('bootstrap.widgets.TbBox', array('title' => 'Advanced Search', 'headerIcon' => 'icon-th-list', 'htmlOptions' => array('class' => 'bootstrap-widget-table', 'style' => 'width:98%;')));
?>
<br>
<div class="span8">
<div class="wide form">

<?php 
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('action' => Yii::app()->createUrl($this->route), 'method' => 'get'));
CHtml::$afterRequiredLabel = '';
?>
    <?php 
echo $form->dropDownListRow($model, 'meeting_reso_id', CHtml::listData(CommMeetingReso::model()->findAll(), 'meeting_reso_id', 'meeting_reso_id'), array('class' => 'span3', 'value' => ''));
?>

	<?php 
echo $form->dropDownListRow($model, 'ref_id', CHtml::listData(Referral::model()->findAll(array('condition' => 'referral_stat=0')), 'ref_id', 'ctrl_no'), array('class' => 'span3'));
?>

	<?php 
echo $form->dropDownListRow($model, 'action_taken', array(0 => 'Pending', 1 => 'Approved', 2 => 'Return to Origin'), array('class' => 'span3'));
?>

	<?php 
echo $form->datepickerRow($model, 'date_meeting', array('prepend' => '<i class="icon-calendar"></i>', 'options' => array('format' => 'yyyy-mm-dd')));
?>
	
	<?php 
echo $form->datepickerRow($model, 'comm_report', array('prepend' => '<i class="icon-calendar"></i>', 'options' => array('format' => 'yyyy-mm-dd')));
?>
	
Exemple #15
0
<?php

require Yii::getPathOfAlias('webroot') . '/protected/extensions/tcpdf/' . 'tcpdf.php';
// Data loading
$pdf = new TCPDF('L', PDF_UNIT, 'Legal', true, 'UTF-8', false);
// set document information
$referralduedateCount = count(Referral::model()->findAll(array('condition' => 'referral_stat = 0 and now() > duedate')));
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(User::model()->findByPK(Yii::app()->user->name)->emp->Fullname);
$pdf->SetTitle($referralduedateCount . '  Pending Referrals - Referrals without Committee Reports as of today');
// set default header data
$pdf->SetHeaderData('banner.jpg', PDF_HEADER_LOGO_WIDTH, 'Legislative Information System - Provincial Government of La Union v1.0');
// set header and footer fonts
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
//$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(15, $pdf->GetY() + 55, 15);
$pdf->SetHeaderMargin(10);
$pdf->SetFooterMargin(30);
$pdf->SetAutoPageBreak(true, 65);
// set auto page breaks
//$pdf->SetAutoPageBreak(FALSE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
    require_once dirname(__FILE__) . '/lang/eng.php';
    $pdf->setLanguageArray($l);
}
Exemple #16
0
 public function getCommMeetings($d)
 {
     $temp = Referral::model()->findByAttributes(array('ctrl_no' => $d));
     if (empty($temp)) {
         echo 'No Committee Meeting';
     } else {
         $x = CommMeetingReso::model()->find(array('condition' => 'ref_id = "' . $temp->ref_id . '"'));
         if ($x == null) {
             echo '0000-00-00';
         } else {
             $IAs = CommMeetingReso::model()->findAll(array('condition' => 'ref_id = "' . $temp->ref_id . '"', 'order' => 'date_meeting desc'));
             $iaName = CHtml::listData($IAs, 'date_meeting', 'date_meeting');
             foreach ($iaName as $val) {
                 echo $val . '<br/>';
             }
         }
     }
 }
Exemple #17
0
 public function CommOrdi()
 {
     $cat = Category::model()->findByAttributes(array('cat_name' => 'Provincial Ordinance'))->cat_id;
     $result = CHtml::listData(Communication::model()->findAll(array('condition' => 'cat_id = ' . $cat . ' and comm_stat=1')), 'ctrl_no', 'ctrl_no');
     $criteria = new CDbCriteria();
     $criteria->condition = "referral_stat=0";
     $criteria->addInCondition("ctrl_no", $result);
     $criteria2 = new CDbCriteria();
     $criteria2->addInCondition("ctrl_no", $result);
     return $this->isNewRecord ? CHtml::listData(Referral::model()->findAll($criteria), 'ref_id', 'ctrl_no') : CHtml::listData(Referral::model()->findAll($criteria2), 'ref_id', 'ctrl_no');
 }
 public function actionCreate($id)
 {
     $model = new Resolution();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     $count = count(Resolution::model()->findAll(array('condition' => 'res_no like "%' . date('Y') . '"'))) + 1;
     if ($count <= 99) {
         if ($count <= 9) {
             $count = '00' . $count . ' - ' . date('Y');
         } else {
             $count = '0' . $count . ' - ' . date('Y');
         }
     } else {
         $count = $count . ' - ' . date('Y');
     }
     if (isset($_POST['Resolution'])) {
         $model->attributes = $_POST['Resolution'];
         $model->archive = 0;
         $picture_name = '';
         $picture_file = CUploadedFile::getInstance($model, 'reso_file');
         $model->reso_file = $picture_file;
         if ($picture_file) {
             $picture_name = $picture_file->name;
             if (!is_dir(Yii::getPathOfAlias('webroot') . '/protected/document/resolution/' . substr($model->ctrl_no, 0, 4))) {
                 mkdir(Yii::getPathOfAlias('webroot') . '/protected/document/resolution/' . substr($model->ctrl_no, 0, 4));
             }
             if (!is_dir(Yii::getPathOfAlias('webroot') . '/protected/document/resolution/' . substr($model->ctrl_no, 0, 4) . '/' . $model->res_no)) {
                 mkdir(Yii::getPathOfAlias('webroot') . '/protected/document/resolution/' . substr($model->ctrl_no, 0, 4) . '/' . $model->res_no);
                 $picture_file->SaveAs(Yii::getPathOfAlias('webroot') . '/protected/document/resolution/' . substr($model->ctrl_no, 0, 4) . '/' . $model->res_no . '/' . $picture_file->getName());
             } else {
                 $picture_file->SaveAs(Yii::getPathOfAlias('webroot') . '/protected/document/resolution/' . substr($model->ctrl_no, 0, 4) . '/' . $model->res_no . '/' . $picture_file->getName());
             }
         }
         $model->author = implode(',', $model->author);
         $model->input_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
         //-------------------------------------------------
         $stat = Status::model()->findByAttributes(array('ctrl_no' => $model->ctrl_no));
         $stat->remarks = 1;
         $stat->save();
         if (!empty(Referral::model()->findByAttributes(array('ctrl_no' => $model->ctrl_no))->ref_id)) {
             $temp = Referral::model()->findByAttributes(array('ctrl_no' => $model->ctrl_no))->ref_id;
             $meeting = CommMeetingReso::model()->find(array('condition' => 'ref_id = ' . $temp . ' and action_taken=1 or action_taken=2'));
             $meeting->comm_meeting_stat = 1;
             $meeting->remark = 1;
             $meeting->save();
         }
         if ($model->save()) {
             date_default_timezone_set("Asia/Manila");
             $activity = new Activity();
             $activity->act_desc = 'Added Another Resolution';
             $activity->act_datetime = date('Y-m-d G:i:s');
             $activity->act_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
             $activity->save();
             $this->redirect(array('view', 'id' => $model->res_no));
         }
     }
     $this->render('create', array('model' => $model, 'count' => $count, 'id' => $id));
 }
Exemple #19
0
       
</div><!-- header -->
 
<div class="container" id="page"  >


        
    <?php 
$countNotif = count(ForumQuestion::model()->findAll(array('condition' => 'confirmation=0')));
$notif = $this->widget('bootstrap.widgets.TbBadge', array('type' => $countNotif == 0 ? 'info' : 'important', 'label' => $countNotif), true);
$receiving = count(Communication::model()->findAll(array('condition' => 'type_comm = 2 and now() >= date_agenda  ')));
$notifRC = $this->widget('bootstrap.widgets.TbBadge', array('type' => $receiving == 0 ? 'info' : 'important', 'label' => $receiving), true);
$referralCount = count(Communication::model()->findAll(array('condition' => 'archive=0 and comm_stat=0 and type_comm<>2')));
$referralduedateCount = count(Referral::model()->findAll(array('condition' => 'referral_stat = 0 and now() > duedate')));
$meetingResoCount = count(Referral::model()->countCommMeetingReso());
$meetingOrdiCount = count(Referral::model()->countCommMeetingOrdi());
$rfTotal = 0;
$rfTotal = $referralCount + $meetingOrdiCount + $meetingResoCount + $referralduedateCount;
$notifRFTotal = $this->widget('bootstrap.widgets.TbBadge', array('type' => $rfTotal == 0 ? 'info' : 'important', 'label' => $rfTotal), true);
$notifRFrefduedate = $this->widget('bootstrap.widgets.TbBadge', array('type' => $referralduedateCount == 0 ? 'info' : 'important', 'label' => $referralduedateCount), true);
$notifRFref = $this->widget('bootstrap.widgets.TbBadge', array('type' => $referralCount == 0 ? 'info' : 'important', 'label' => $referralCount), true);
$notifRFreso = $this->widget('bootstrap.widgets.TbBadge', array('type' => $meetingResoCount == 0 ? 'info' : 'important', 'label' => $meetingResoCount), true);
$notifRFordi = $this->widget('bootstrap.widgets.TbBadge', array('type' => $meetingOrdiCount == 0 ? 'info' : 'important', 'label' => $meetingOrdiCount), true);
$resoCount = count(Status::model()->countResolution());
$ordiCount = count(CommMeetingOrdi::model()->findAll(array('condition' => 'archive=0 and comm_meeting_stat=1 and ord_remark=0 and action_taken=1')));
$tTotal = 0;
$tTotal = $resoCount + $ordiCount;
$notifTtotal = $this->widget('bootstrap.widgets.TbBadge', array('type' => $tTotal == 0 ? 'info' : 'important', 'label' => $tTotal), true);
$notifTreso = $this->widget('bootstrap.widgets.TbBadge', array('type' => $resoCount == 0 ? 'info' : 'important', 'label' => $resoCount), true);
$notifTordi = $this->widget('bootstrap.widgets.TbBadge', array('type' => $ordiCount == 0 ? 'info' : 'important', 'label' => $ordiCount), true);
$role = Yii::app()->user->getState("roles");
 /**
  * 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['CommMeetingOrdi'])) {
         $model->attributes = $_POST['CommMeetingOrdi'];
         $x = Referral::model()->findByAttributes(array('ctrl_no' => $model->ref_id))->ref_id;
         $model->ref_id = $x;
         $model->archive = 0;
         $model->comm_meeting_stat = 0;
         $model->ord_remark = 0;
         if ($model->save()) {
             if ($model->action_taken != 0) {
                 $stat = Status::model()->findByAttributes(array('ctrl_no' => $model->ref->ctrl_no));
                 $stat->referral_stat = 1;
                 $stat->save();
                 Referral::model()->updateByPK($model->ref_id, array('referral_stat' => 1));
             } else {
                 $stat = Status::model()->findByAttributes(array('ctrl_no' => $model->ref->ctrl_no));
                 $stat->comm_meeting_stat = 0;
                 $stat->referral_stat = 1;
                 $stat->save();
                 Referral::model()->updateByPK($model->ref_id, array('referral_stat' => 1));
             }
         }
         date_default_timezone_set("Asia/Manila");
         $activity = new Activity();
         $activity->act_desc = 'Updated Committee Meeting ID: ' . $id;
         $activity->act_datetime = date('Y-m-d G:i:s');
         $activity->act_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
         $activity->save();
         $this->redirect(array('view', 'id' => $model->meeting_ordi_id));
     }
     $this->render('update', array('model' => $model));
 }