<?php
$columns = ['oid', ['label' => '营业厅', 'attribute' => 'office.title', 'value' => function ($model, $key, $index, $column) {
return empty($model->office->title) ? '' : $model->office->title;
}, 'filter' => false, 'headerOptions' => array('style' => 'width:80px;')], ['label' => '微信昵称', 'value' => function ($model, $key, $index, $column) {
$user = $model->user;
return empty($user) ? '' : $user->nickname;
}, 'filter' => false, 'headerOptions' => array('style' => 'width:80px;')], ['attribute' => 'detail', 'headerOptions' => array('style' => 'width:100px;')], ['attribute' => 'feesum', 'value' => function ($model, $key, $index, $column) {
return "￥" . sprintf("%0.2f", $model->feesum / 100);
}], ['attribute' => 'create_time', 'filterType' => GridView::FILTER_DATE, 'format' => 'raw', 'width' => '250px', 'filterWidgetOptions' => ['type' => \kartik\widgets\DatePicker::TYPE_RANGE, 'separator' => '至', 'attribute2' => 'create_time_2', 'pluginOptions' => ['format' => 'yyyy-mm-dd', 'language' => 'zh-CN']]], ['label' => '买家身份信息', 'value' => function ($model, $key, $index, $column) {
return "{$model->username}, {$model->userid}, {$model->usermobile}";
}, 'headerOptions' => array('style' => 'width:120px;')], ['label' => '留言', 'attribute' => 'memo'], ['label' => '备注', 'attribute' => 'memo_reply'], ['attribute' => 'status', 'value' => function ($model, $key, $index, $column) {
return $model->statusName;
}, 'filter' => MOrder::getOrderStatusName()], ['attribute' => 'pay_kind', 'label' => '付款方式', 'value' => function ($model, $key, $index, $column) {
return MOrder::getOrderPayKindOption($model->pay_kind);
}, 'filter' => MOrder::getOrderPayKindOption(), 'headerOptions' => array('style' => 'width:60px;')], ['label' => '用户', 'value' => function ($model, $key, $index, $column) {
if (!empty($model->user)) {
if ($model->user->bindMobileIsInside('wx_vip')) {
return '老';
} else {
return '新';
}
}
return '--';
}], ['class' => 'yii\\grid\\ActionColumn', 'template' => '{view} {update} {chat}', 'buttons' => ['chat' => function ($url, $model) {
return Html::a('<span class="glyphicon glyphicon-comment"></span>', $url, ['title' => Yii::t('yii', '发送消息给用户'), 'data-method' => 'post', 'data-pjax' => '0']);
}]]];
/*
echo DynaGrid::widget([
'columns'=>$columns,
'storage'=>DynaGrid::TYPE_COOKIE,
echo $order->oid;
?>
</li>
<li class="table-view-cell"><span class="orderitem">商品名称</span> <?php
echo $order->title;
?>
</li>
<li class="table-view-cell"><span class="orderitem">商品价格</span> ￥<?php
echo $order->feesum / 100;
?>
元</li>
<li class="table-view-cell"><span class="orderitem">支付方式</span>
<?php
echo MOrder::getOrderPayKindOption($order->pay_kind);
?>
</li>
<li class="table-view-cell table-view-divider">
<span class="orderitem">
<?php
if ($order->buyerCanPay()) {
//echo "<span style='color:blue' class='weixin_pay' myUrl="+n.url+"> 继续支付</span>";
echo "<span class='btn btn-positive' id='weixin_pay' myUrl=" . $order->GetOrderJsApiParameters() . ">继续支付</span>";
}
?>
public function actionOrder($filename = 'order.csv', $date = null)
{
$filepathname = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'exported_data' . DIRECTORY_SEPARATOR . $filename;
$fh = fopen($filepathname, 'w');
if (null === $date) {
$date = \app\models\U::getFirstDate(date('Y'), date('m'));
}
$total_count = \app\models\MOrder::find()->where(['>', 'create_time', $date])->count();
//$total_count = \app\models\MUser::find()->count();
$step = 300;
$start = 0;
while ($start < $total_count) {
$orders = \app\models\MOrder::find()->offset($start)->limit($step)->where(['>', 'create_time', $date])->orderBy(['create_time' => SORT_ASC])->all();
fprintf($fh, "营业厅, 订单号, 商品, 价格, 订单时间, 身份证, 用户姓名, 联系电话, 支付方式, 订单状态, 开通, 备注, 用户类型\n");
foreach ($orders as $order) {
$office = \app\models\MOffice::findOne(['office_id' => $order->office_id]);
if (!empty($office)) {
$office_title = $office->title;
} else {
$office_title = "";
}
$user = \app\models\MUser::findOne(['openid' => $order->openid]);
$customerFlag = '--';
/*
if ($user->bindMobileIsInside('wx_t1')) {
$customerFlag = '老';
} elseif ($user->bindMobileIsInside('wx_t2')) {
$customerFlag = '老';
}elseif ($user->bindMobileIsInside('wx_t3')) {
$customerFlag = '老';
} else {
$customerFlag = '新';
}
*/
if ($user->bindMobileIsInside('wx_oldcustomer')) {
$customerFlag = '老';
} else {
$customerFlag = '新';
}
$pay_kind = \app\models\MOrder::getOrderPayKindOption($order->pay_kind);
$price = $order->feesum / 100;
$paystatus = \app\models\MOrder::getOrderStatusName($order->status);
//echo $office_title."\t".$order->oid."\t".$order->title."\t".$price."\t".$order->create_time."\t".$order->userid."\t".$order->username."\t".$order->usermobile."\t".$pay_kind."\t".$order->memo."\t".$order->customerFlag."\t\n";
fprintf($fh, "%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s\n", $office_title, $order->oid, $order->title, $price, $order->create_time, $order->userid, $order->username, $order->usermobile, $pay_kind, $paystatus, $order->kaitong, $order->memo, $order->customerFlag);
}
$start += $step;
}
fclose($fh);
}
