<?php $x = CommMeetingOrdi::model()->findByPK($model->meeting_ordi_id); ?> <script type="text/javascript"> $(document).ready(function(){ var act = '<?php echo $x->action_taken; ?> '; var comm = '<?php echo $x->comm_report; ?> '; if((act==0)){ $('#modalButton').hide(); } else if((act!=0) && (comm.length != 0)){ $('#modalButton').hide(); } else if((comm.length!=0) && (act==0)){ $('#modalButton').hide(); }
?> <?php $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_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
$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"); switch ($role) { case 'SCR-RC': $this->widget('bootstrap.widgets.TbNavbar', array('type' => 'inverse', 'brand' => 'Home', 'fixed' => false, 'type' => 'inverse', 'items' => array(array('class' => 'bootstrap.widgets.TbMenu', 'items' => array(array('label' => 'Communications', 'url' => array('communication/viewTypeComm')), array('label' => 'Referrals', 'url' => array('referral/index')), array('label' => 'Committee Meetings', 'url' => array('#'), 'items' => array(array('label' => 'Committee Meeting for Ordinances', 'url' => array('commMeetingOrdi/index')), array('label' => 'Committee Meeting for Resolutions', 'url' => array('commMeetingReso/index')))), array('label' => 'Legislative Enactments', 'url' => array('#'), 'items' => array(array('label' => 'Resolution', 'url' => array('/resolution/index')), array('label' => 'Ordinance', 'url' => array('/ordinance/index')))), array('label' => 'Monitor Ordinances', 'url' => array('/monitorOrd/index')), array('label' => 'Reports', 'url' => array('#'), 'items' => array(array('label' => 'Resolution Reports', 'url' => array('/reportsresolution/index')), array('label' => 'Ordinance Reports', 'url' => array('/reportsordinance/index')), array('label' => 'Other Reports', 'url' => array('/reportsOthers/commReportMonthly')))), array('label' => 'Forum', 'url' => array('/site/main_forum')), array('label' => 'Gallery', 'url' => array('/site/viewphotosPage'), 'visible' => Yii::app()->user->isGuest))), array('class' => 'bootstrap.widgets.TbMenu', 'encodeLabel' => false, 'htmlOptions' => array('class' => 'pull-right'), 'items' => array(array('label' => 'Login', 'url' => array('/site/login'), 'visible' => Yii::app()->user->isGuest), array('label' => 'Logout (' . Yii::app()->user->name . ')', 'url' => array('/site/logout'), 'visible' => !Yii::app()->user->isGuest), array('label' => 'Notifications ' . $notifRC, 'url' => array('#'), 'icon' => 'icon-bell icon-white', 'items' => array(array('label' => 'For Referral ' . $notifRC, 'url' => array('/communication/viewTypeComm'))))))))); break; case 'SCR-T': $this->widget('bootstrap.widgets.TbNavbar', array('type' => 'inverse', 'fixed' => true, 'brand' => 'Home', 'items' => array(array('class' => 'bootstrap.widgets.TbMenu', 'items' => array(array('label' => 'Communications', 'url' => array('communication/index')), array('label' => 'Referrals', 'url' => array('referral/index')), array('label' => 'Committee Meetings', 'url' => array('#'), 'items' => array(array('label' => 'Committee Meeting for Ordinances', 'url' => array('commMeetingOrdi/index')), array('label' => 'Committee Meeting for Resolutions', 'url' => array('commMeetingReso/index')))), array('label' => 'Legislative Enactments', 'url' => array('#'), 'items' => array(array('label' => 'Resolution', 'url' => array('/resolution/resolutionList')), array('label' => 'Ordinance', 'url' => array('/ordinance/ordinanceList')))), array('label' => 'Monitor Ordinances', 'url' => array('/monitorOrd/index')), array('label' => 'Reports', 'url' => array('#'), 'items' => array(array('label' => 'Resolution Reports', 'url' => array('/reportsresolution/index')), array('label' => 'Ordinance Reports', 'url' => array('/reportsordinance/index')), array('label' => 'Other Reports', 'url' => array('/reportsOthers/commReportMonthly')))), array('label' => 'Forum', 'url' => array('/site/main_forum')), array('label' => 'Gallery', 'url' => array('/site/viewphotosPage'), 'visible' => Yii::app()->user->isGuest))), array('class' => 'bootstrap.widgets.TbMenu', 'encodeLabel' => false, 'htmlOptions' => array('class' => 'pull-right'), 'items' => array(array('label' => 'Login', 'url' => array('/site/login'), 'visible' => Yii::app()->user->isGuest), array('label' => 'Logout (' . Yii::app()->user->name . ')', 'url' => array('/site/logout'), 'visible' => !Yii::app()->user->isGuest), array('label' => 'Notifications ' . $notifTtotal, 'url' => array('#'), 'icon' => 'icon-bell icon-white', 'items' => array(array('label' => 'For Ordinance ' . $notifTordi, 'url' => array('/ordinance/ordinanceList')), array('label' => 'For Resolution ' . $notifTreso, 'url' => array('/resolution/resolutionList'))))))))); break; case 'SCR-RF': $this->widget('bootstrap.widgets.TbNavbar', array('type' => 'inverse', 'fixed' => false, 'brand' => 'Home', 'items' => array(array('class' => 'bootstrap.widgets.TbMenu', 'items' => array(array('label' => 'Communications', 'url' => array('communication/index')), array('label' => 'Referrals', 'url' => array('referral/referralList')), array('label' => 'Committee Meetings', 'url' => array('#'), 'items' => array(array('label' => 'Committee Meeting for Ordinances', 'url' => array('commMeetingOrdi/commMeetingList')), array('label' => 'Committee Meeting for Resolutions', 'url' => array('commMeetingReso/commMeetingList')))), array('label' => 'Legislative Enactments', 'url' => array('#'), 'items' => array(array('label' => 'Resolution', 'url' => array('/resolution/index')), array('label' => 'Ordinance', 'url' => array('/ordinance/index')))), array('label' => 'Monitor Ordinances', 'url' => array('/monitorOrd/index')), array('label' => 'Reports', 'url' => array('#'), 'items' => array(array('label' => 'Resolution Reports', 'url' => array('/reportsresolution/index')), array('label' => 'Ordinance Reports', 'url' => array('/reportsordinance/index')), array('label' => 'Other Reports', 'url' => array('/reportsOthers/commReportMonthly')))), array('label' => 'Forum', 'url' => array('/site/main_forum')), array('label' => 'Gallery', 'url' => array('/site/viewphotosPage'), 'visible' => Yii::app()->user->isGuest))), array('class' => 'bootstrap.widgets.TbMenu', 'encodeLabel' => false, 'htmlOptions' => array('class' => 'pull-right'), 'items' => array(array('label' => 'Login', 'url' => array('/site/login'), 'visible' => Yii::app()->user->isGuest), array('label' => 'Logout (' . Yii::app()->user->name . ')', 'url' => array('/site/logout'), 'visible' => !Yii::app()->user->isGuest), array('label' => 'Notifications ' . $notifRFTotal, 'url' => array('#'), 'icon' => 'icon-bell icon-white', 'items' => array(array('label' => 'For Referral ' . $notifRFref, 'url' => array('/referral/referralList')), array('label' => 'Referrals without action' . $notifRFrefduedate, 'url' => array('/referral/referraldue')), array('label' => 'Meeting for Resolution ' . $notifRFreso, 'url' => array('/commMeetingReso/commMeetingList')), array('label' => 'Meeting for Ordinance ' . $notifRFordi, 'url' => array('/commMeetingOrdi/commMeetingList')))))))));
<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, 'ord_no', CHtml::listData(Ordinance::model()->findAll(), 'ord_no', 'ord_no'), array('class' => 'span3', 'empty' => 'Choose Ordinance Number')); ?> <?php echo $form->dropDownListRow($model, 'meeting_ordi_id', $model->isNewRecord ? CHtml::listData(CommMeetingOrdi::model()->findAll(array('condition' => 'comm_meeting_stat=1 and ord_remark=0')), 'meeting_ordi_id', 'ControlNumber') : CHtml::listData(CommMeetingOrdi::model()->findAll(), 'meeting_ordi_id', 'ControlNumber'), array('class' => 'span3', 'empty' => $model->isNewRecord ? '------ Select Control No. ------' : $model->meetingOrdi->ControlNumber)); ?> <?php echo $form->textFieldRow($model, 'subj_matter', array('class' => 'span4')); ?> <?php echo $form->select2Row($model, 'author', array('asDropDownList' => true, 'data' => CHtml::listData(Officials::model()->findAll(''), 'off_id', 'Fullname'), 'multiple' => 'multiple', 'options' => array('width' => '40%', 'placeholder' => ' ------------ Choose Author ------------', 'tokenSeparators' => array(',', ' ')))); ?> <?php echo $form->select2Row($model, 'imp_agency', array('asDropDownList' => true, 'data' => CHtml::listData(Agency::model()->findAll(), 'agency_id', 'agency_name'), 'multiple' => 'multiple', 'options' => array('width' => '40%', 'placeholder' => ' ------------ Choose Agency ------------', 'tokenSeparators' => array(',', ' ')))); ?>
$meetings1 = new DateTime($meetings, $timezone); if ($meetings == '0000-00-00') { $tbl .= '<td style="border-top-style: 1px solid black;"> : N/A </td>'; } else { $tbl .= '<td style="border-top-style: 1px solid black;">: ' . $meetings1->format('M j, Y') . '</td>'; } $tbl .= '</tr>'; $tbl .= '<tr nobr="true"> <td style="border-top-style: 1px solid black; font-size:16px; font-weight:bold;">E) Public Hearing/s</td>'; $hearing = ''; if (!empty($model->meeting_ordi_id)) { $y = CommMeetingOrdi::model()->findByPK($model->meeting_ordi_id); if (!empty($y)) { $hearing = 'N/A'; } else { $phearing = CommMeetingOrdi::model()->findAll(array('condition' => 'public_hearing <> "0000-00-00" and ref_id = "' . $y->ref_id . '"', 'order' => 'date_meeting asc')); $meet = CHtml::listData($phearing, 'public_hearing', 'public_hearing'); foreach ($meet as $val) { $hearing = $val . '<br/>' . $hearing; } } if ($hearing == '0000-00-00<br/>') { $hearing = 'N/A'; } } else { $hearing = ' N/A'; } $tbl .= '<td style="border-top-style: 1px solid black;">: ' . $hearing . '</td>'; $tbl .= '</tr>'; if ($date_report == '0000-00-00') { $tbl .= '<tr nobr="true">
public function actionPrintCommReportYearly($model) { $data = explode(',', $model); $comm_name = $data[0]; $year = $data[1]; $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); $listReso = CommMeetingReso::model()->findAll($criteria); $listOrd = CommMeetingOrdi::model()->findAll($criteria); 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(); $this->renderPartial('printCommReportYearly', array('listOrd' => $listOrd, 'listReso' => $listReso, 'comm_name' => $x->comm_name, 'year' => $year)); }
public function getReportDate($ctrl) { if ($ctrl) { return CommMeetingOrdi::model()->findByAttributes(array('meeting_ordi_id' => $ctrl))->comm_report; } else { return 'No Report Date'; } }
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)); }
/** * 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 CommMeetingOrdi the loaded model * @throws CHttpException */ public function loadModel($id) { $model = CommMeetingOrdi::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }