public function actionIndex()
{
$user = Yii::$app->user;
$dashboard = [];
if ($user->can('partner_view')) {
$dashboard[] = ['name' => Html::tag('b', __('Partners')), 'link' => Url::to(['partner/index']), 'count' => Partner::find()->count()];
}
if ($user->can('visit_view') || $user->can('visit_view_all')) {
$dashboard[] = ['name' => __('Visits'), 'link' => Url::to(['visit/index']), 'count' => Visit::find()->count()];
}
if ($user->can('donate_view') || $user->can('donate_view_all')) {
$dashboard[] = ['name' => __('Donates'), 'link' => Url::to(['donate/index']), 'count' => Donate::find()->count()];
}
if ($user->can('task_view') || $user->can('task_view_all')) {
$dashboard[] = ['name' => __('Tasks'), 'link' => Url::to(['task/index']), 'count' => Task::find()->count()];
}
if ($user->can('newsletter_view')) {
$dashboard[] = ['name' => __('Mailing lists'), 'link' => Url::to(['mailing-list/index']), 'count' => MailingList::find()->count()];
$dashboard[] = ['name' => __('Newsletters'), 'link' => Url::to(['newsletter/index']), 'count' => Newsletter::find()->count()];
$dashboard[] = ['name' => __('Printing templates'), 'link' => Url::to(['print-template/index']), 'count' => PrintTemplate::find()->count()];
}
if ($user->can('user_manage')) {
$dashboard[] = ['name' => __('Users'), 'link' => Url::to(['user/index']), 'count' => User::find()->count()];
}
return $this->render('index', ['dashboard' => $dashboard]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Partner::find()->joinWith('tags')->groupBy('partner.id');
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSizeLimit' => [10, 500]], 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]]]);
$params = $this->processParams($params);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['partner.id' => $this->id, 'type' => $this->type, 'status' => $this->status, 'country_id' => $this->country_id, 'state_id' => $this->state_id, 'parent_id' => $this->parent_id, 'volunteer' => $this->volunteer, 'candidate' => $this->candidate, 'partner_tag.tag_id' => $this->tag_id]);
$query->andFilterWhere(['like', 'partner.name', $this->name])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'state', $this->state])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'notes', $this->notes]);
$tags = $this->parseTagsStr([$this->publicTagsStr, $this->personalTagsStr]);
if (true) {
// AND
foreach ($tags as $tag) {
$query->andFilterWhere(['tag.name' => $tag]);
}
} else {
// OR
$query->andFilterWhere(['in', 'tag.name', $tags]);
}
if ($this->q) {
$query->orFilterWhere(['like', 'partner.name', $this->q]);
$query->orFilterWhere(['like', 'email', $this->q]);
$query->orFilterWhere(['like', 'notes', $this->q]);
}
$this->addRangeCondition($query, 'created_at');
$this->addRangeCondition($query, 'updated_at');
return $dataProvider;
}
/**
* Print
*/
public function generate()
{
$content = [];
$iteration = 0;
$partners = Partner::find()->viaMailingLists($this->mailingLists)->all();
if ($this->items_per_page) {
$page_separator = Html::tag('div', '', ['style' => ['clear' => 'both']]);
$page_begin_tag = Html::beginTag('div', ['style' => ['page-break-before' => 'always']]);
$page_end_tag = $page_separator . Html::endTag('div');
$content[] = $page_begin_tag;
}
foreach ($partners as $partner) {
$iteration++;
$content[] = $this->processContent($this->content, $partner);
if ($this->items_per_page && $iteration % $this->items_per_page == 0) {
$content[] = $page_end_tag;
$content[] = $page_begin_tag;
}
}
if ($this->items_per_page) {
$content[] = $page_end_tag;
}
$content = implode(PHP_EOL, $content);
if ($this->wrapper_enabled) {
$content = preg_replace('/\\{content\\}/Sui', $content, $this->wrapper);
}
return $content;
}
public function find()
{
if ($this->ids) {
return PartnerModel::find()->where(['id' => $this->ids])->orderBy(['created_at' => SORT_DESC]);
} else {
$search = new PartnerSearch();
$dataProvider = $search->search($this->queryParams);
$dataProvider->pagination = false;
return $dataProvider->query;
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Partner::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id]);
$query->andFilterWhere(['like', 'code', $this->code])->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Partner::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'user_creator' => $this->user_creator, 'partnership_date' => $this->partnership_date, 'tier' => $this->tier]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'url', $this->url])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'nda', $this->nda])->andFilterWhere(['like', 'msa', $this->msa])->andFilterWhere(['like', 'agreement', $this->agreement])->andFilterWhere(['like', 'tags', $this->tags])->andFilterWhere(['like', 'categories', $this->categories]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Partner::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'summary_en', $this->summary_en])->andFilterWhere(['like', 'summary_pt', $this->summary_pt])->andFilterWhere(['like', 'description_en', $this->description_en])->andFilterWhere(['like', 'description_pt', $this->description_pt])->andFilterWhere(['like', 'link', $this->link]);
return $dataProvider;
}
/**
* Ajax handler
*
* @param string $q Query
* @param boolean $organizations Include organizations flag
* @return mixed
*/
public function actionList($q, $organizations = false)
{
$partners = [];
if ($q) {
$query = Partner::find();
if ($organizations) {
$query->organizations();
}
$query->andWhere(['or', ['like', 'name', $q], ['like', 'city', $q]]);
$models = $query->limit(30)->all();
foreach ($models as $model) {
$partners[] = ['id' => $model->id, 'text' => $model->extendedName];
}
}
$this->ajaxAssign('partners', $partners);
}
// echo $this->render('_search', ['model' => $searchModel]);
?>
<div class="row">
<div class="col-md-1">
<p>
<?php
echo Html::a('รับเข้าวัสดุ ', ['create'], ['class' => 'btn btn-success fa fa-plus']);
?>
</p>
</div>
<div class="col-md-3">
<p>
<?php
echo Html::a('จ่ายพัสดุ', ['ream'], ['class' => 'btn btn-success fa fa-share']);
?>
</p>
</div>
<div class="col-md-3">
</div>
</div>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'panel' => ['before' => ' '], 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'id', ['label' => 'บริษัท', 'format' => 'raw', 'value' => 'partnername', 'filter' => Html::activeDropDownList($searchModel, 'partner_id', ArrayHelper::map(Partner::find()->asArray()->all(), 'id', 'name'), ['class' => 'form-control', 'prompt' => 'Select Category'])], ['attribute' => 'd_date', 'width' => '300px', 'filterType' => GridView::FILTER_DATE, 'filterWidgetOptions' => ['options' => ['placeholder' => 'Enter date ...'], 'type' => DatePicker::TYPE_COMPONENT_APPEND, 'pluginOptions' => ['autoclose' => true, 'format' => 'yyyy-mm-dd']]], ['attribute' => 'is_admin', 'format' => 'html', 'value' => function ($data) {
return "<a href='" . Url::to('index.php?r=site/report&id=' . $data->id) . "'>พิมพ์ใบสั่งซื้อ</a>";
}], ['class' => 'yii\\grid\\ActionColumn']]]);
?>
</div>
public function getPartnersCount()
{
return Partner::find()->joinWith('tags')->where(['tag_id' => $this->id])->count();
}
<div class="tab-content">
<div id="home" class="tab-pane fade in active">
<h3>HOME</h3>
<p>Please choose an area and complete a workflow.</p>
</div>
<div id="partners" class="tab-pane fade">
<h3>Partners</h3>
<p>A list of active partners with details, locations, and available products, services etc.</p>
<p>Partner Table: <?php
echo Html::a('Here', ['partner/index']);
?>
</p>
<ul>
<?php
foreach (Partner::find()->each() as $partner) {
echo "<li> " . Html::a($partner->name, $partner->url) . "</li>";
}
?>
</ul>
</div>
<div id="opps" class="tab-pane fade">
<h3>Opportunities</h3>
<p>A List of validated budget holders with confirmed budget sizes and purchasing priorities.</p>
<p>Opportunities Table: <?php
echo Html::a('Here', ['lead/index']);
?>
</p>
<ul>
</div>
<div class="col-md-3">
<?php
echo $form->field($model, 'bill_no')->textInput();
?>
</div>
<div class="col-md-2">
<?php
echo $form->field($model, 'budget_id')->dropdownList(ArrayHelper::map(Budget::find()->all(), 'id', 'name'), ['id' => 'budget_id', 'prompt' => '--- เลือกข้อมูล ---', 'required' => '']);
?>
</div>
</div>
<div class="row">
<div class="col-md-3">
<?php
echo $form->field($model, 'partner_id')->dropdownList(ArrayHelper::map(Partner::find()->all(), 'id', 'name'), ['id' => 'partner_id', 'prompt' => '--- เลือกข้อมูล ---', 'required' => '']);
?>
</div>
<div class="col-md-2">
</div>
</div>
<table cellpadding="6" cellspacing="1" style="width:100%" border="0" class="table table-bordered">
<tr>
<th>#</th>
<th width="700">รายการวัสดุ</th>
<th>ราคา/หน่วย</th>
<th>จำนวน</th>
<th style="text-align:right">รวม</th>
<th colspan="2"></th>
public function getPartnersCount()
{
return Partner::find()->joinWith('mailingListPartners')->where(['list_id' => $this->id])->count();
}
public function actionPartner(int $type)
{
$this->getView()->title = $type ? '合作伙伴' : '案例分析';
$partener = Partner::find()->where('type = :type', [':type' => $type])->all();
return $this->render('partner', array('parteners' => $partener, 'type' => $type));
}
