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"));
}
