public function actionIndex() { $this->layout = "column2"; $yearSelectRange = array(); $yearSelectRange = YearRangeCollection::getCollection(); $dateFrom = date("Y-m-d H:i:s", strtotime(sprintf("first day of October %s", date("Y")))); $dateTo = date("Y-m-d H:i:s", strtotime(sprintf("last day of September %s", intval(date("Y")) + 1))); if (Yii::app()->request->isPostRequest) { $searchRange = $_POST['searchRange']; $dateFrom = date("Y-m-d H:i:s", strtotime(sprintf("first day of October %s", $searchRange))); $dateTo = date("Y-m-d H:i:s", strtotime(sprintf("last day of September %s", intval($searchRange) + 1))); } $criteria = new CDbCriteria(); $criteria->addCondition("DATE(term_from) between :dateFrom and :dateTo"); $criteria->params = array(":dateFrom" => $dateFrom, ":dateTo" => $dateTo); $barangayOfficialsModels = BarangayOfficials::model()->findAll($criteria); $this->render('index', compact('yearSelectRange', 'dateFrom', 'dateTo', 'barangayOfficialsModels')); }
public function actionBarangayClearance() { $model = Residents::model()->findByAttributes(array('username' => Yii::app()->user->id)); $criteriaPunongbarangay = new CDbCriteria(); $criteriaPunongbarangay->compare("position", 'punong barangay'); $criteriaPunongbarangay->order = "date_record_created DESC"; $criteriaSecretary = new CDbCriteria(); $criteriaSecretary->compare("position", 'secretary'); $criteriaSecretary->order = "date_record_created DESC"; $punongBarangaMdl = BarangayOfficials::model()->find($criteriaPunongbarangay); $secretary = BarangayOfficials::model()->find($criteriaSecretary); $punongbarangayFull = sprintf("%s %s", $punongBarangaMdl->firstname, $punongBarangaMdl->lastname); $secretaryFull = sprintf("%s %s", $secretary->firstname, $secretary->lastname); header("Content-type:application/pdf"); header("Content-Disposition:attachment;filename='Barangay_Clearance.pdf'"); $dompdf = new DOMPDF(); $output1 = $this->renderPartial("barangayclearance", compact('model', 'punongbarangayFull', 'secretaryFull'), true); $dompdf->load_html($output1); $dompdf->render(); $dompdf->stream("Barangay_Clearance.pdf"); }
/** * This is the default 'index' action that is invoked * when an action is not explicitly requested by users. */ public function actionIndex() { $this->layout = "column2"; $punongbarangay = ""; $secretary = ""; $criteriaPunongbarangay = new CDbCriteria(); $criteriaPunongbarangay->compare("position", 'punong barangay'); $criteriaPunongbarangay->order = "date_record_created DESC"; $criteriaSecretary = new CDbCriteria(); $criteriaSecretary->compare("position", 'secretary'); $criteriaSecretary->order = "date_record_created DESC"; $punongBarangaMdl = BarangayOfficials::model()->find($criteriaPunongbarangay); $secretary = BarangayOfficials::model()->find($criteriaSecretary); if (!$punongBarangaMdl) { $barangayOfficialsLink = CHtml::link('Click here', array('/barangayOfficials')); throw new CHttpException(404, "Cant find punong barangay record." . "Please register a <strong>punong barangay</strong> official. <br>" . $barangayOfficialsLink); } if (!$secretary) { $barangayOfficialsLink = CHtml::link('Click here', array('/barangayOfficials')); throw new CHttpException(404, "Cant find secretary record." . "Please register a <strong>secretary</strong> official. <br>" . $barangayOfficialsLink); } $this->render('index'); }
public function actionView($id) { $model = BarangayOfficials::model()->findByPk($id); if (!$model) { throw new CHttpException(404, "Sorry we cant find that barangay official's record"); } $this->render("view", compact("model")); }