public function actionSavePdf($id)
{
$distribution = Distribution::model()->findByPk($id);
$html = $this->actionPrint($id);
//echo $html;
$mPDF1 = Yii::app()->ePdf->mpdf('ar', 'A4');
$mPDF1->WriteHTML($html);
$mPDF1->Output($distribution->name . '_vouchers.pdf', "D");
Yii::app()->end();
}
public function getVendor($distribution_id)
{
$distribution = Distribution::model()->findByPk($distribution_id);
if (!$distribution) {
return 0;
}
$criteria = "(0";
foreach ($distribution->subdistributions as $subdistribution) {
foreach ($subdistribution->distributionVouchers as $distributionVoucher) {
$criteria .= "," . $distributionVoucher->id;
}
}
$criteria .= ")";
$voucher = Voucher::model()->find("ben_id = " . $this->id . " and distribution_voucher_id in " . $criteria);
if ($voucher->vendor_id == null) {
return 0;
}
return $voucher->vendor_id;
}
echo $form->textArea($model, 'slogan_en');
?>
<?php
echo $form->error($model, 'slogan_en');
?>
</div><!-- row -->
<div class="row">
<?php
echo $form->labelEx($model, 'slogan_ar');
?>
<?php
echo $form->textArea($model, 'slogan_ar');
?>
<?php
echo $form->error($model, 'slogan_ar');
?>
</div><!-- row -->
<label><?php
echo GxHtml::encode($model->getRelationLabel('distributions'));
?>
</label>
<?php
echo $form->checkBoxList($model, 'distributions', GxHtml::encodeEx(GxHtml::listDataEx(Distribution::model()->findAllAttributes(null, true)), false, true));
?>
<?php
echo GxHtml::submitButton(Yii::t('app', 'Save'));
$this->endWidget();
?>
</div><!-- form -->
<?php
$this->breadcrumbs = array($model->label(2) => array('index'), Yii::t('app', 'Manage'));
$this->menu = array(array('label' => Yii::t('app', 'List') . ' ' . $model->label(2), 'url' => array('index')), array('label' => Yii::t('app', 'Create') . ' ' . $model->label(), 'url' => array('create')));
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$.fn.yiiGridView.update('subdistribution-grid', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
?>
<h1><?php
echo Yii::t('app', 'Manage') . ' ' . GxHtml::encode($model->label(2));
?>
</h1>
<p>
You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.
</p>
<?php
echo GxHtml::link(Yii::t('app', 'Advanced Search'), '#', array('class' => 'search-button'));
?>
<div class="search-form">
<?php
$this->renderPartial('_search', array('model' => $model));
?>
</div><!-- search-form -->
<?php
$this->widget('zii.widgets.grid.CGridView', array('id' => 'subdistribution-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array('id', 'code', 'start_date', 'end_date', array('name' => 'region_id', 'value' => 'GxHtml::valueEx($data->region)', 'filter' => GxHtml::listDataEx(Community::model()->findAllAttributes(null, true))), array('name' => 'distribution_id', 'value' => 'GxHtml::valueEx($data->distribution)', 'filter' => GxHtml::listDataEx(Distribution::model()->findAllAttributes(null, true))), array('class' => 'CButtonColumn'))));
public function restEvents()
{
$this->onRest('req.get.GetBeneficiaryFordistribution.render', function ($distribution_id = "", $subdistribution_id = "", $include = 1, $withall = 0, $withvendor = 0) {
$include = "not in";
$criteria = "";
if (isset($_GET['include']) and $_GET['include'] != 0) {
$include = "in";
}
if (isset($_GET['distribution_id']) and $_GET['distribution_id'] != 0) {
$distribution = Distribution::model()->findByPk($_GET['distribution_id']);
$criteria = "id " . $include . " (select distinct ben_id from voucher where distribution_voucher_id in (Select id from distribution_voucher where subdistribution_id in (SELECT id FROM `subdistribution` WHERE distribution_id = " . $_GET['distribution_id'] . ")))";
if ($_GET['withvendor'] == 1) {
$beneficiaries = Beneficiary::model()->findAll($criteria);
$count = count($beneficiaries);
$count_assigned = 0;
$returned_array = [];
foreach ($beneficiaries as $beneficiary) {
$vendor_id = $beneficiary->getVendor($_GET['distribution_id']);
$obj = new stdClass();
foreach ($beneficiary as $key => $value) {
$obj->{$key} = $value;
}
$obj->vendor = $vendor_id;
if ($obj->vendor != 0) {
$count_assigned += 1;
}
array_push($returned_array, $obj);
}
echo CJSON::encode(['count_beneficiaries' => $count, 'assigned_beneficiaries' => $count_assigned, 'Beneficiaries' => $returned_array]);
Yii::app()->end();
}
} elseif (isset($_GET['subdistribution_id']) and $_GET['subdistribution_id'] != 0 and $_GET['include'] != 0) {
$criteria = "id " . $include . " (select distinct ben_id from voucher where distribution_voucher_id in (Select id from distribution_voucher where subdistribution_id = " . $_GET['subdistribution_id'] . "))";
if ($_GET['withall'] != 0) {
$included_beneficiaries = Beneficiary::model()->findAll($criteria);
$returned_array = [];
foreach ($included_beneficiaries as $beneficiary) {
$obj = new stdClass();
foreach ($beneficiary as $key => $value) {
$obj->{$key} = $value;
}
$obj->available = "false";
array_push($returned_array, $obj);
}
$count_included = count($included_beneficiaries);
$subdistribution = Subdistribution::model()->findByPk($_GET['subdistribution_id']);
$criteria = "id not in (select distinct ben_id from voucher where distribution_voucher_id in (Select id from distribution_voucher where subdistribution_id in (SELECT id FROM `subdistribution` WHERE distribution_id = " . $subdistribution->distribution_id . ")))";
$available_beneficiaries = Beneficiary::model()->findAll($criteria);
foreach ($available_beneficiaries as $beneficiary) {
$obj = new stdClass();
foreach ($beneficiary as $key => $value) {
$obj->{$key} = $value;
}
$obj->available = "true";
array_push($returned_array, $obj);
}
$count_available = count($available_beneficiaries);
echo CJSON::encode(['available_beneficiaries' => $count_available, 'included_beneficiaries' => $count_included, 'Beneficiaries' => $returned_array]);
Yii::app()->end();
}
} elseif (isset($_GET['subdistribution_id']) and $_GET['subdistribution_id'] != 0 and $include == 0) {
$subdistribution = Subdistribution::model()->findByPk($_GET['subdistribution_id']);
$criteria = "id " . $include . " (select distinct ben_id from voucher where distribution_voucher_id in (Select id from distribution_voucher where subdistribution_id in (SELECT id FROM `subdistribution` WHERE distribution_id = " . $subdistribution->distribution_id . ")))";
}
//echo $criteria;
$beneficiaries = Beneficiary::model()->findAll($criteria);
$count = count($beneficiaries);
//$model = new Beneficiary('searchForVoucherAssignment');
//$model->unsetAttributes();
echo CJSON::encode(['count' => $count, 'Beneficiaries' => $beneficiaries]);
});
}
<div class="row">
<?php
echo $form->label($model, 'region_id');
?>
<?php
echo $form->dropDownList($model, 'region_id', GxHtml::listDataEx(Community::model()->findAllAttributes(null, true)), array('prompt' => Yii::t('app', 'All')));
?>
</div>
<div class="row">
<?php
echo $form->label($model, 'distribution_id');
?>
<?php
echo $form->dropDownList($model, 'distribution_id', GxHtml::listDataEx(Distribution::model()->findAllAttributes(null, true)), array('prompt' => Yii::t('app', 'All')));
?>
</div>
<div class="row">
<?php
echo $form->label($model, 'status_id');
?>
<?php
echo $form->dropDownList($model, 'status_id', GxHtml::listDataEx(DistributionStatus::model()->findAllAttributes(null, true)), array('prompt' => Yii::t('app', 'All')));
?>
</div>
<div class="row">
<?php
echo $form->label($model, 'create_date');
<?php echo $form->labelEx($model, 'region_id'); ?> <?php echo $form->dropDownList($model, 'region_id', GxHtml::listDataEx(Community::model()->findAllAttributes(null, true))); ?> <?php echo $form->error($model, 'region_id'); ?> </div><!-- row --> <div class="row"> <?php echo $form->labelEx($model, 'distribution_id'); ?> <?php echo $form->dropDownList($model, 'distribution_id', GxHtml::listDataEx(Distribution::model()->findAllAttributes(null, true))); ?> <?php echo $form->error($model, 'distribution_id'); ?> </div><!-- row --> <div class="row"> <?php echo $form->labelEx($model, 'status_id'); ?> <?php echo $form->dropDownList($model, 'status_id', GxHtml::listDataEx(DistributionStatus::model()->findAllAttributes(null, true))); ?> <?php echo $form->error($model, 'status_id'); ?>
public function actiondeleteVoucherVendor()
{
if (isset($_POST) && !empty($_POST)) {
$distribution = Distribution::model()->findByPk($_POST['distribution_id']);
$vendor = Vendor::model()->findByPk($_POST['vendor_id']);
$subdistributions = $distribution->subdistributions;
$criteria_string = "(0";
foreach ($subdistributions as $subdistribution) {
foreach ($subdistribution->distributionVouchers as $ditributioVoucher) {
$criteria_string = $criteria_string . ", " . $ditributioVoucher->id;
}
}
$criteria_string = $criteria_string . ")";
$criteria_string2 = "(0";
foreach ($_POST['beneficiaries'] as $ben_id) {
$criteria_string2 = $criteria_string2 . ", " . $ben_id;
}
$criteria_string2 = $criteria_string2 . ")";
$vouchers = Voucher::model()->findAll("vendor_id = " . $vendor->id . " and distribution_voucher_id in " . $criteria_string . " and ben_id in " . $criteria_string2);
foreach ($vouchers as $voucher) {
$voucher->vendor_id = NULL;
$voucher->update();
$voucher->save();
}
}
}
