1629 lines
69 KiB
PHP
1629 lines
69 KiB
PHP
<?php
|
|
|
|
namespace app\controllers\admin;
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
use Yii;
|
|
use yii\web\Controller;
|
|
use app\models\common\Config;
|
|
use app\controllers\common\FuiouController;
|
|
|
|
class ApplyController extends CommonController
|
|
{
|
|
public $enableCsrfValidation = false;
|
|
private $pay_radio_arr = array(
|
|
['radio'=>'0%','radio_num'=>'0.0'],
|
|
['radio'=>'10%','radio_num'=>'0.1'],
|
|
['radio'=>'20%','radio_num'=>'0.2'],
|
|
['radio'=>'30%','radio_num'=>'0.3'],
|
|
['radio'=>'40%','radio_num'=>'0.4'],
|
|
['radio'=>'50%','radio_num'=>'0.5'],
|
|
['radio'=>'60%','radio_num'=>'0.6'],
|
|
['radio'=>'70%','radio_num'=>'0.7'],
|
|
['radio'=>'80%','radio_num'=>'0.8'],
|
|
['radio'=>'90%','radio_num'=>'0.9'],
|
|
['radio'=>'100%','radio_num'=>'1'],
|
|
);
|
|
|
|
//通过自增id获取平台列表的信息
|
|
public function actionApplyDetails()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$id = Yii::$app->request->get('id');
|
|
$data = (new \yii\db\Query())
|
|
->select('sort,apply_name,apply_image,apply_qr_code,apply_type,channel_str,use_str,plug_str,dt_operdate,time_type,time_type,end_time')
|
|
->from('{{%ybwm_apply}}')
|
|
->where(['id' => $id])
|
|
->orderBy(['id' => 'asc'])
|
|
->one();
|
|
//var_dump($re);die;
|
|
$row = getSysInfo();
|
|
$channelArr = $row['authData']['channel'];
|
|
$plugArr = $row['authData']['plug'];
|
|
$channelConfig = Config::channelConfig();
|
|
foreach ($channelConfig as $v) {
|
|
if (in_array($v['name'], $channelArr)) {
|
|
$channel_list[] = $v;
|
|
}
|
|
}
|
|
$data['channel_list'] = $channel_list;
|
|
|
|
$plug_list = [];
|
|
$plugConfig = Config::plugConfig();
|
|
foreach ($plugConfig as $v) {
|
|
if (in_array($v['name'], $plugArr)) {
|
|
$plug_list[] = $v;
|
|
}
|
|
}
|
|
$data['plug_list'] = $plug_list;
|
|
$data['service_list'] = Config::serviceConfig();
|
|
$data['use_list'] = Config::menuConfig();
|
|
|
|
$data['app_name'] = $row['appName'];
|
|
|
|
$sysInfo = Config::getSystemSet('sysTopImage', $id);
|
|
$data['channel_str'] = $sysInfo['channel_arr'] ?: $row['authData']['channel'];
|
|
$data['plug_str'] = $sysInfo['plug_str'] ?: [];
|
|
$data['instore'] = $sysInfo['instore'] ?: '2';
|
|
$data['takeout'] = $sysInfo['takeout'] ?: '1';
|
|
$data['use_str'] = $sysInfo['use_str'] ?: [];
|
|
$data['service'] = $row['authData']['service'];
|
|
//$data['service']=$sysInfo['service']?:$row['authData']['service'];
|
|
$data['shopModel'] = $sysInfo['shopModel'] ?: 2;
|
|
$data['shopNum'] = $sysInfo['shopNum'] ?: 0;
|
|
$data['deliveryMode'] = $sysInfo['deliveryMode'] ?: [];
|
|
$superPowerData = Config::getSystemSet('sysTopImage', $id);
|
|
if (!$superPowerData) {
|
|
$superPowerData = Config::getSystemSet('superPower', 0);
|
|
}
|
|
$data['deliveryModeData'] = array(
|
|
array(
|
|
'value' => '9',
|
|
'name' => $superPowerData['yunbeiName'] ?: '云贝配送'
|
|
),
|
|
array(
|
|
'value' => '2',
|
|
'name' => '达达配送'
|
|
),
|
|
array(
|
|
'value' => '3',
|
|
'name' => '点我达'
|
|
),
|
|
array(
|
|
'value' => '5',
|
|
'name' => '顺丰同城'
|
|
),
|
|
array(
|
|
'value' => '6',
|
|
'name' => '蜂鸟即配'
|
|
),
|
|
array(
|
|
'value' => '7',
|
|
'name' => '闪送'
|
|
),
|
|
array(
|
|
'value' => '8',
|
|
'name' => 'uu跑腿'
|
|
),
|
|
array(
|
|
'value' => '4',
|
|
'name' => $superPowerData['makeName'] ?: '码科配送'
|
|
),
|
|
array(
|
|
'value' => '1',
|
|
'name' => '商家配送'
|
|
),
|
|
);
|
|
return $this->result(1, '成功', $data);
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//获取可用插件
|
|
public function actionGetplug_str()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$sql = 'select * from {{%ybwm_plug_unit}} where status=1';
|
|
$page = Yii::$app->request->get('page') ? Yii::$app->request->get('page') : 1;
|
|
$num = 10 * $page;
|
|
if ($page == 1) {
|
|
$sql .= " limit 10";
|
|
} else {
|
|
$sql .= " limit 10,$num";
|
|
}
|
|
$re = YII::$app->db->createCommand($sql)->queryAll();
|
|
return $this->result(1, '成功', $re);
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//获取可用渠道
|
|
public function actionGetchannel_str()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$re = YII::$app->db->createCommand('select * from {{%ybwm_channel_list}} where status=:status', ['status' => 1])->queryAll();
|
|
return $this->result(1, '成功', $re);
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//添加平台表单页面
|
|
public function actionPlatform_add()
|
|
{
|
|
|
|
// if('192.168.3.14' == $_SERVER['REMOTE_ADDR']){
|
|
// $this->actionPassivescanpay();
|
|
// }
|
|
// $data=array('web_url'=>Yii::$app->request->hostInfo,'status'=>1);
|
|
// //获取项目的应用列表
|
|
// $url=Yii::$app->params['domain_url'].'/cloud/upgraded/getapp';
|
|
// $data=json_decode(httpRequest($url,$data));
|
|
|
|
return $this->renderpartial('platform_add');
|
|
}
|
|
//门店列表页面
|
|
public function actionPlatform_storelist()
|
|
{
|
|
$id = '';
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$result = axios_request();
|
|
$id = $result['id'];
|
|
}
|
|
return $this->renderpartial('platform_storelist',['id'=>$id]);
|
|
}
|
|
|
|
//门店列表
|
|
public function actionGetstorelist()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$result = axios_request();
|
|
$id = $result['id'];
|
|
$page = Yii::$app->request->get('page') ? Yii::$app->request->get('page') : 1;
|
|
$num = ($page - 1) * 10;
|
|
$limit = 10;
|
|
$query = (new \yii\db\Query())
|
|
// ->select('a.id as store_id,a.uniacid as apply_id,a.name as store_name, b.apply_name,sp.channel_id')
|
|
->select('a.id as store_id,a.uniacid as apply_id,a.name as store_name, b.apply_name')
|
|
->from('{{%ybwm_store}} a')
|
|
->leftJoin('{{%ybwm_apply}} b', 'b.id=a.uniacid')
|
|
// ->leftJoin('{{%ybwm_store_paychannel}} sp', 'sp.apply_id=a.uniacid and a.id=sp.store_id')
|
|
// ->leftJoin('{{%ybwm_pay_channel}} pc', 'pc.channel_id=sp.channel_id')
|
|
->where(['a.uniacid' => $id]);
|
|
$count = count($query->all());
|
|
$re = $query->offset($num)
|
|
->limit($limit)
|
|
->all();
|
|
if($re){
|
|
$store_id_arr = array_column($re,'store_id');
|
|
$store_id_str = implode(',',$store_id_arr);
|
|
$sql = "select pc.channel_name as channel_name,sp.channel_radio as channel_radio
|
|
from {{%ybwm_store_paychannel}} as sp
|
|
join {{%ybwm_pay_channel}} as pc on sp.channel_id = pc.channel_id
|
|
where sp.is_del = 0 and sp.store_id in ($store_id_str)";
|
|
$channel_data = Yii::$app->db->createCommand($sql)->queryAll();
|
|
if($channel_data){
|
|
$temp = [];
|
|
foreach ($channel_data as $val){
|
|
$temp[] = $val['channel_name'] . ($val['channel_radio'] >= 0 ? ('(' . $val['channel_radio']*100 . '%)') : '') ;
|
|
}
|
|
}
|
|
foreach ($re as $key=>$val){
|
|
$temp = [];
|
|
if(!empty($val['store_id'])){
|
|
$sql = "select pc.channel_name as channel_name,sp.channel_radio as channel_radio
|
|
from {{%ybwm_store_paychannel}} as sp
|
|
join {{%ybwm_pay_channel}} as pc on sp.channel_id = pc.channel_id
|
|
where sp.is_del = 0 and sp.store_id = '{$val['store_id']}'";
|
|
$channel_data = Yii::$app->db->createCommand($sql)->queryAll();
|
|
if($channel_data){
|
|
foreach ($channel_data as $c_val){
|
|
$temp[] = $c_val['channel_name'] . (($c_val['channel_radio'] >=0) ? '(' . $c_val['channel_radio']*100 . '%)' : '');
|
|
}
|
|
}
|
|
}
|
|
$re[$key]['channel_name'] = $temp ? implode(' , ',$temp) : '';
|
|
}
|
|
}
|
|
echo json_encode(['code' => 1, 'msg' => '成功', 'data' => $re, 'count' => intval($count)]);
|
|
die;
|
|
}
|
|
}
|
|
|
|
//通道配置保存
|
|
public function actionPaymentstoresave()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$connection = Yii::$app->db;
|
|
$store_id = $result['store_id'];
|
|
$apply_id = $result['apply_id'];
|
|
$bind_id_arr = $result['bind_id'];
|
|
$channel_select_arr = array_filter($result['channel_select']);
|
|
$public_key_arr = array_filter($result['public_key']);
|
|
$private_key_arr = array_filter($result['private_key']);
|
|
$ins_num_arr = array_filter($result['ins_num']);
|
|
$merchant_num_arr = array_filter($result['merchant_num']);
|
|
$channel_select_arr_len = count($channel_select_arr);
|
|
$public_key_arr_len = count($public_key_arr);
|
|
$private_key_arr_len = count($private_key_arr);
|
|
$ins_num_arr_len = count($ins_num_arr);
|
|
$merchant_num_arr_len = count($merchant_num_arr);
|
|
$num_arr = [$channel_select_arr_len,$public_key_arr_len,$private_key_arr_len,$ins_num_arr_len,$merchant_num_arr_len];
|
|
$unique_num_arr = array_unique($num_arr);
|
|
if(empty($store_id) || empty($apply_id)){
|
|
return $this->result(2, '参数错误，请重新加载页面尝试！');
|
|
}
|
|
if(count($unique_num_arr) != 1) {
|
|
return $this->result(2, '请完成信息的填写！');
|
|
}
|
|
|
|
if(empty($store_id) || empty($apply_id)){
|
|
return $this->result(2, '参数错误，请重新加载页面尝试！');
|
|
}
|
|
|
|
$channel_select_arrs = [];
|
|
foreach ($channel_select_arr as $key=>$val){
|
|
$channel_select_arrs[$key] = '"'.$val.'"';
|
|
}
|
|
$channel_select_str = implode(',',$channel_select_arrs);
|
|
$channel_all_data = $connection->createCommand("select * from {{%ybwm_pay_channel}} where status=1 and channel_name in ({$channel_select_str})")->queryAll();
|
|
$channel_all_data_arr = [];
|
|
foreach ($channel_all_data as $key=>$val){
|
|
$channel_all_data_arr[$val['channel_name']] = $val['channel_id'];
|
|
}
|
|
|
|
|
|
$info_data = [];
|
|
for($i=0;$i<$channel_select_arr_len;$i++){
|
|
if(!isset($channel_all_data_arr[$channel_select_arr[$i]])){
|
|
return $this->result(2, '参数错误，请重新加载页面尝试！');
|
|
}
|
|
$tem['bind_id'] = $bind_id_arr[$i];
|
|
$tem['channel_id'] = $channel_all_data_arr[$channel_select_arr[$i]];
|
|
$tem['public_key'] = $public_key_arr[$i];
|
|
$tem['private_key'] = $private_key_arr[$i];
|
|
$tem['ins_num'] = $ins_num_arr[$i];
|
|
$tem['merchant_num'] = $merchant_num_arr[$i];
|
|
$info_data[] = $tem;
|
|
}
|
|
|
|
$is_exist_data = $connection->createCommand("select * from {{%ybwm_store_paychannel}} where is_del = 0 and store_id='{$store_id}' and apply_id = '{$apply_id}'")->queryAll();
|
|
if($is_exist_data){
|
|
$transaction = Yii::$app->db->beginTransaction();
|
|
try {
|
|
|
|
foreach ($info_data as $info_key=>$info_val) {
|
|
$ins_data['apply_id'] = $apply_id;
|
|
$ins_data['store_id'] = $store_id;
|
|
$ins_data['channel_id'] = $info_val['channel_id'];
|
|
$ins_data['public_key'] = $info_val['public_key'];
|
|
$ins_data['private_key'] = $info_val['private_key'];
|
|
$ins_data['ins_num'] = $info_val['ins_num'];
|
|
$ins_data['merchant_num'] = $info_val['merchant_num'];
|
|
if($info_val['bind_id']){//更新
|
|
$ins_data['update_time'] = time();
|
|
$ins_data['update_user_id'] = $this->getUserId();
|
|
$connection->createCommand()->update('{{%ybwm_store_paychannel}}', $ins_data, 'id=:id', ['id' => $info_val['bind_id']])->execute();
|
|
} else {//新加
|
|
$ins_data['create_time'] = time();
|
|
$ins_data['create_user_id'] = $this->getUserId();
|
|
$connection->createCommand()->insert('{{%ybwm_store_paychannel}}', $ins_data)->execute();
|
|
}
|
|
}
|
|
$transaction->commit(); //只有执行了commit(),对于上面数据库的操作才会真正执行
|
|
return $this->result(1, '操作成功');
|
|
}
|
|
catch (Exception $e) {
|
|
$error = $e->getMessage(); //获取抛出的错误
|
|
$transaction->rollBack();
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
} else {//新增
|
|
$transaction = Yii::$app->db->beginTransaction();
|
|
try {
|
|
foreach ($info_data as $info_key=>$info_val) {
|
|
$ins_data = [];
|
|
$ins_data['apply_id'] = $apply_id;
|
|
$ins_data['store_id'] = $store_id;
|
|
$ins_data['channel_id'] = $info_val['channel_id'];
|
|
$ins_data['public_key'] = $info_val['public_key'];
|
|
$ins_data['private_key'] = $info_val['private_key'];
|
|
$ins_data['ins_num'] = $info_val['ins_num'];
|
|
$ins_data['merchant_num'] = $info_val['merchant_num'];
|
|
$ins_data['create_time'] = time();
|
|
$ins_data['create_user_id'] = $this->getUserId();
|
|
$connection->createCommand()->insert('{{%ybwm_store_paychannel}}', $ins_data)->execute();
|
|
}
|
|
$transaction->commit(); //只有执行了commit(),对于上面数据库的操作才会真正执行
|
|
return $this->result(1, '操作成功');
|
|
}
|
|
catch (Exception $e) {
|
|
$error = $e->getMessage(); //获取抛出的错误
|
|
$transaction->rollBack();
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
}
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
//通道设置-获取已设置通道
|
|
function actionGetPaymentList(){
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$result = axios_request();
|
|
$store_id = $result['store_id'];
|
|
$res = (new \yii\db\Query())
|
|
// ->select('channel_id,channel_radio')
|
|
->from('{{%ybwm_store_paychannel}}')
|
|
->where(['store_id' => $store_id,'is_del'=>0])
|
|
->all();
|
|
}
|
|
$data = (new \yii\db\Query())
|
|
->select('channel_id,channel_name')
|
|
->from('{{%ybwm_pay_channel}}')
|
|
->where(['status' => 1])
|
|
->orderBy(['channel_id' => 'asc'])
|
|
->all();
|
|
$select_data_len = empty($res) ? [1] : range(1,count($res));
|
|
return $this->renderpartial('payment_store',
|
|
[
|
|
'data'=>json_encode($data,true),
|
|
'select_data'=>json_encode($res,true),
|
|
'select_data_len'=>json_encode($select_data_len,true),
|
|
]
|
|
);
|
|
}
|
|
//规则设置-获取已设置的通道规则（交易占比）
|
|
function actionGetBindChannelList(){
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$result = axios_request();
|
|
$store_id = $result['store_id'];
|
|
$res = (new \yii\db\Query())
|
|
// ->select('channel_id,channel_radio')
|
|
->from('{{%ybwm_store_paychannel}}')
|
|
->where(['store_id' => $store_id,'is_del'=>0])
|
|
->all();
|
|
}
|
|
$data = (new \yii\db\Query())
|
|
->select('channel_id,channel_name')
|
|
->from('{{%ybwm_pay_channel}}')
|
|
->where(['status' => 1])
|
|
->orderBy(['channel_id' => 'asc'])
|
|
->all();
|
|
$select_data_len = empty($res) ? [1] : range(1,count($res));
|
|
return $this->renderpartial('payment_rulesetting',
|
|
[
|
|
'data'=>json_encode($data,true),
|
|
'select_data'=>json_encode($res,true),
|
|
'select_data_len'=>json_encode($select_data_len,true),
|
|
]
|
|
);
|
|
}
|
|
//规则设置-保存设置的交易占比规则
|
|
public function actionPaymentRadioSave()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$connection = Yii::$app->db;
|
|
$store_id = $result['store_id'];
|
|
$apply_id = $result['apply_id'];
|
|
$bind_id_arr = array_filter($result['bind_id']);
|
|
$channel_radio_arr = $result['channel_radio'];
|
|
$bind_id_arr_len = count($bind_id_arr);
|
|
$channel_radio_arr_len = count($channel_radio_arr);
|
|
if(empty($store_id) || empty($apply_id) || ($channel_radio_arr_len != $bind_id_arr_len)){
|
|
return $this->result(2, '参数错误，请重新加载页面尝试！');
|
|
}
|
|
$radio_arr = [];
|
|
$store_channel_radio_data = [];
|
|
for ($i=0;$i<$bind_id_arr_len;$i++){
|
|
$radio_arr[] = (int)($channel_radio_arr[$i]*100);
|
|
$temp['bind_id'] = $bind_id_arr[$i];
|
|
$temp['channel_radio'] = $channel_radio_arr[$i];
|
|
$store_channel_radio_data[] = $temp;
|
|
|
|
}
|
|
if(array_sum($radio_arr) != 100) {
|
|
return $this->result(2, '交易占比之和必须为1');
|
|
}
|
|
$transaction = Yii::$app->db->beginTransaction();
|
|
try {
|
|
foreach ($store_channel_radio_data as $key=>$val){
|
|
$sql = "select * from {{%ybwm_store_paychannel}} where is_del=0 and id = '{$val['bind_id']}'";
|
|
$is_exist_data = $connection->createCommand($sql)->queryone();
|
|
if($is_exist_data && $is_exist_data['channel_radio'] != $val['channel_radio']){
|
|
$up_data['channel_radio'] = $val['channel_radio'];
|
|
$up_data['update_time'] = time();
|
|
$up_data['update_user_id'] = $val['channel_radio'];
|
|
$re = $connection->createCommand()->update('{{%ybwm_store_paychannel}}', $up_data, ['id' => $val['bind_id']])->execute();
|
|
}
|
|
}
|
|
$transaction->commit(); //只有执行了commit(),对于上面数据库的操作才会真正执行
|
|
return $this->result(1, '操作成功');
|
|
}
|
|
catch (Exception $e) {
|
|
$error = $e->getMessage(); //获取抛出的错误
|
|
$transaction->rollBack();
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
//规则通道
|
|
function actionGetPaymentList1(){
|
|
$request = Yii::$app->request;
|
|
$bind_channel_id = '';
|
|
if ($request->isGet) {
|
|
$result = axios_request();
|
|
$store_id = $result['store_id'];
|
|
$res = (new \yii\db\Query())
|
|
->select('channel_id,channel_radio')
|
|
->from('{{%ybwm_store_paychannel}}')
|
|
->where(['store_id' => $store_id,'is_del'=>0])
|
|
->one();
|
|
if($res){
|
|
$bind_channel_id = $res['channel_id'] ? explode(',',$res['channel_id']) : '';
|
|
$channel_radio_data = json_decode($res['channel_radio'],true);
|
|
if($channel_radio_data){
|
|
foreach ($channel_radio_data as $key=>$val){
|
|
$channel_radio_data[$key]['pay_radio'] = $val['pay_radio']*100 .'%';
|
|
}
|
|
}
|
|
}
|
|
}
|
|
$data = (new \yii\db\Query())
|
|
->select('channel_id,channel_name')
|
|
->from('{{%ybwm_pay_channel}}')
|
|
->where(['status' => 1])
|
|
->orderBy(['channel_id' => 'asc'])
|
|
->all();
|
|
$channel_radio_data = empty($channel_radio_data) ? [1] : $channel_radio_data;
|
|
return $this->renderpartial('payment_store',
|
|
[
|
|
'data'=>json_encode($data,true),
|
|
'bind_store_id'=>json_encode($bind_channel_id,true),
|
|
'pay_radio_arr'=>json_encode($this->pay_radio_arr,true),
|
|
'channel_radio_data'=>json_encode($channel_radio_data,true),
|
|
]
|
|
);
|
|
}
|
|
//门店列表根据条件搜索出结果
|
|
public function actionStorebysearch()
|
|
{
|
|
$request = Yii::$app->request;
|
|
|
|
if ($request->isPost) {
|
|
$request = axios_request();
|
|
$store_id = trim($request['store_id']);
|
|
$apply_id = $request['apply_id'];
|
|
$store_name = trim($request['store_name']);
|
|
$start_time = $request['start_time'] ? strtotime($request['start_time']) : '';
|
|
$end_time = $request['end_time'] ? strtotime($request['end_time'])+86399 : '';
|
|
if(!$apply_id){
|
|
return $this->result(2, '参数错误请重试！');
|
|
}
|
|
$page = Yii::$app->request->get('page') ? Yii::$app->request->get('page') : 1;
|
|
$num = ($page - 1) * 10;
|
|
$limit = 10;
|
|
$query = (new \yii\db\Query())
|
|
->select('a.id as store_id,a.uniacid as apply_id,a.name as store_name, b.apply_name,pc.channel_name'
|
|
)
|
|
->from('{{%ybwm_store}} a')
|
|
->leftJoin('{{%ybwm_apply}} b', 'b.id=a.uniacid')
|
|
->leftJoin('{{%ybwm_store_paychannel}} sp', 'sp.apply_id=a.uniacid and a.id=sp.store_id')
|
|
->leftJoin('{{%ybwm_pay_channel}} pc', 'pc.channel_id=sp.channel_id')
|
|
->andWhere(['a.uniacid'=>$apply_id,'sp.is_del'=>0]);
|
|
|
|
if ($store_id) {
|
|
$query->andWhere(['a.id'=>$store_id]);
|
|
}
|
|
if ($store_name) {
|
|
$query->andWhere(['like', 'a.name', $store_name]);
|
|
}
|
|
if ($start_time && $end_time) {
|
|
$query->andWhere(['between', 'create_time',$start_time,$end_time]);
|
|
}
|
|
if ($page == 1) {
|
|
$query->limit($limit);
|
|
} else {
|
|
$query->limit($limit, $num);
|
|
}
|
|
|
|
$count = count($query->all());
|
|
$re = $query->all();
|
|
return $this->result(1, '成功', $re, intval($count));
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
public function actionGetApplyStoreInfo()
|
|
{
|
|
$request = Yii::$app->request;
|
|
$sql = "
|
|
select a.id as apply_id,a.apply_name,b.id as store_id,b.name as store_name
|
|
from {{%ybwm_apply}} a
|
|
left join {{%ybwm_store}} b on a.id = b.uniacid
|
|
where a.status = 1 and b.display = 1
|
|
order by a.id asc
|
|
";
|
|
$data = Yii::$app->db->createCommand($sql)->queryAll();
|
|
$apply_data = $store_data = [];
|
|
if (!empty($data)) {
|
|
foreach ($data as $key => $val) {
|
|
$temp['store_id'] = $val['store_id'];
|
|
$temp['store_name'] = $val['store_name'];
|
|
$temp['apply_name'] = $val['apply_name'];
|
|
$store_data[] = $temp;
|
|
// if (!isset($apply_data[$val['apply_id']])) {
|
|
// $apply_data[$val['apply_id']] = $val['apply_name'];
|
|
// }
|
|
// $temp['store_id'] = $val['store_id'];
|
|
// $temp['store_name'] = $val['store_name'];
|
|
// $store_data[$val['apply_name']][] = $temp;
|
|
}
|
|
}
|
|
// $res['apply_data'] = $apply_data;
|
|
$res['store_data'] = $store_data;
|
|
return $this->result(1, '成功', $res);
|
|
}
|
|
|
|
|
|
//获取应用版本 插件 渠道 列表
|
|
public function actionGetAppInfo()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
//$data=array('web_url'=>Yii::$app->request->hostInfo,'status'=>$result['status']);
|
|
//获取项目的应用列表
|
|
$res = getSysInfo();
|
|
$channelArr = $res['authData']['channel'];
|
|
$plugArr = $res['authData']['plug'];
|
|
$channel_list = [];
|
|
//获取可用渠道
|
|
$channelConfig = Config::channelConfig();
|
|
foreach ($channelConfig as $v) {
|
|
if (in_array($v['name'], $channelArr)) {
|
|
$channel_list[] = $v;
|
|
}
|
|
}
|
|
$plug_list = [];
|
|
$plugConfig = Config::plugConfig();
|
|
foreach ($plugConfig as $v) {
|
|
if (in_array($v['name'], $plugArr)) {
|
|
$plug_list[] = $v;
|
|
}
|
|
}
|
|
//获取连锁版的证书配置
|
|
$appConfig = Config::appConfig();
|
|
foreach ($appConfig as $v) {
|
|
if ($v['use_name'] == $res['appName']) {
|
|
$app_list[] = $v;
|
|
}
|
|
}
|
|
$superPowerData = Config::getSystemSet('superPower', 0);
|
|
$data['deliveryMode'] = array(
|
|
array(
|
|
'value' => '9',
|
|
'name' => $superPowerData['yunbeiName'] ?: '云贝配送'
|
|
),
|
|
array(
|
|
'value' => '2',
|
|
'name' => '达达配送'
|
|
),
|
|
array(
|
|
'value' => '3',
|
|
'name' => '点我达'
|
|
),
|
|
array(
|
|
'value' => '5',
|
|
'name' => '顺丰同城'
|
|
),
|
|
array(
|
|
'value' => '6',
|
|
'name' => '蜂鸟即配'
|
|
),
|
|
array(
|
|
'value' => '7',
|
|
'name' => '闪送'
|
|
),
|
|
array(
|
|
'value' => '8',
|
|
'name' => 'uu跑腿'
|
|
),
|
|
array(
|
|
'value' => '4',
|
|
'name' => $superPowerData['makeName'] ?: '码科配送'
|
|
),
|
|
array(
|
|
'value' => '1',
|
|
'name' => '商家配送'
|
|
),
|
|
);
|
|
$data['app'] = $app_list;
|
|
$data['channel_list'] = $channel_list;
|
|
$data['use_list'] = Config::menuConfig();
|
|
$data['plug_list'] = $plug_list;
|
|
$data['service_list'] = Config::serviceConfig();
|
|
$data['service'] = $res['authData']['service'];
|
|
// $url=Yii::$app->params['domain_url'].'/cloud/upgraded/getapp';
|
|
// $data=httpRequest($url,$data);
|
|
|
|
return $this->result(1, '成功', $data);
|
|
//echo $app_data;die;
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
public function actionPlatform_recycle()
|
|
{
|
|
return $this->renderpartial('platform_recycle');
|
|
}
|
|
|
|
//平台应用添加
|
|
public function actionApplyadd()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$connection = Yii::$app->db;
|
|
$apply_name = $result['apply_name'];
|
|
$command = $connection->createCommand("select * from {{%ybwm_apply}} where apply_name='$apply_name'");
|
|
$re = $command->queryOne();
|
|
if ($re) {
|
|
return $this->result(2, '平台名称已存在');
|
|
}
|
|
$time_type = $result['time_type'];
|
|
if ($time_type == 2) {
|
|
$result['end_time'] = '3000-12-31 23:59:59';
|
|
}
|
|
$data = array(
|
|
'sort' => $result['sort'],
|
|
'apply_name' => $result['apply_name'],
|
|
'apply_type' => $result['apply_type'],
|
|
'create_shop_count' => $result['create_shop_count'],
|
|
'end_time' => $result['end_time'],
|
|
'start_time' => $result['end_time'],
|
|
'dt_operdate' => date('Y-m-d H:i:s', time()),
|
|
'plug_str' => json_encode($result['plug_str']) ?: '',
|
|
'time_type' => $time_type,
|
|
'channel_str' => json_encode($result['channel_str']) ?: '',
|
|
'use_str' => json_encode($result['use_str']) ?: '',
|
|
);
|
|
$data['apply_image'] = $result['apply_image'];
|
|
$data['apply_qr_code'] = $result['apply_qr_code'];
|
|
$res = $connection->createCommand()->insert('{{%ybwm_apply}}', $data)->execute();
|
|
$id = Yii::$app->db->getLastInsertID();
|
|
//保存权限到设置表
|
|
$plug = getSysInformation();
|
|
$superData = array(
|
|
'channel_arr' => $result['channel_str'] ?: '',
|
|
'plug_str' => $result['plug_str'] ?: '',
|
|
'use_str' => $result['use_str'] ?: '',
|
|
'app' => $plug['appData'],
|
|
'shopModel' => $result['shopModel'],
|
|
'shopNum' => $result['shopNum'],
|
|
'instore' => $result['instore'],
|
|
'deliveryMode' => $result['deliveryMode'],
|
|
'cashierName' => $result['cashierName'],
|
|
'cashierIcon' => $result['cashierIcon'],
|
|
'cashierBg' => $result['cashierBg'],
|
|
'takeout' => $result['takeout'],
|
|
);
|
|
Config::saveSystemSet($superData, 'sysTopImage', $id, '网站头部LOGO');
|
|
|
|
if ($res) {
|
|
return $this->result(1, '成功', $id);
|
|
} else {
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//平台应用修改
|
|
public function actionApplyusave()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$config = getSysInfo();
|
|
$time_type = $result['time_type'];
|
|
if ($time_type == 2) {
|
|
$result['end_time'] = '3000-12-31 23:59:59';
|
|
}
|
|
$data = array(
|
|
'sort' => $result['sort'],
|
|
'apply_name' => $result['apply_name'],
|
|
'apply_type' => $result['apply_type'],
|
|
'channel_str' => json_encode($result['channel_str']) ?: '',
|
|
'plug_str' => json_encode($result['plug_str']) ?: '',
|
|
'use_str' => json_encode($result['use_str']) ?: '',
|
|
'create_shop_count' => $result['create_shop_count'],
|
|
'start_time' => $result['end_time'],
|
|
'end_time' => $result['end_time'],
|
|
'up_operdate' => date('Y-m-d H:i:s', time()),
|
|
'time_type' => $time_type,
|
|
'apply_image' => $result['apply_image'],
|
|
'apply_qr_code' => $result['apply_qr_code'],
|
|
);
|
|
//保存权限到设置表
|
|
|
|
$superData = Config::getSystemSet('sysTopImage', $result['id']);
|
|
$superData['channel_arr'] = $result['channel_str'] ?: '';
|
|
$superData['plug_str'] = $result['plug_str'] ?: '';
|
|
$superData['use_str'] = $result['use_str'] ?: '';
|
|
$superData['service'] = $config['authData']['service'];
|
|
$superData['shopModel'] = $result['shopModel'];
|
|
$superData['shopNum'] = $result['shopNum'];
|
|
$superData['instore'] = $result['instore'];
|
|
$superData['deliveryMode'] = $result['deliveryMode'];
|
|
$superData['cashierName'] = $result['cashierName'];
|
|
$superData['cashierIcon'] = $result['cashierIcon'];
|
|
$superData['cashierBg'] = $result['cashierBg'];
|
|
$superData['takeout'] = $result['takeout'];
|
|
Config::saveSystemSet($superData, 'sysTopImage', $result['id'], '网站头部LOGO');
|
|
|
|
$res = YII::$app->db->createCommand()->update('{{%ybwm_apply}}', $data, 'id=:id', ['id' => $result['id']])->execute();
|
|
if ($res !== false) {
|
|
return $this->result(1, '成功');
|
|
} else {
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//平台列表
|
|
public function actionApplylist()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$keyword = $result['apply_name'];
|
|
$satus = $result['status'] ? $result['status'] : 2;
|
|
$sql = "select *,count(*)as count from {{%ybwm_users}} where status='$satus'";
|
|
if ($keyword) {
|
|
$sql .= " and CONCAT(IFNULL(username,''),IFNULL(phone,'')) LIKE CONCAT('%','$keyword','%')";
|
|
}
|
|
$page = $result['page'] ? $result['page'] : 1;
|
|
$num = 10 * $page;
|
|
if ($page == 1) {
|
|
$sql .= " limit 10";
|
|
} else {
|
|
$sql .= " limit 10,$num";
|
|
}
|
|
$data = YII::$app->db->createCommand($sql)->queryAll();
|
|
if ($data) {
|
|
$count = count($data);
|
|
echo json_encode(['code' => 1, 'msg' => $data, 'count' => $count]);
|
|
} else {
|
|
echo json_encode(['code' => 2, 'msg' => '没有您搜索的条件']);
|
|
}
|
|
}
|
|
}
|
|
|
|
//停用平台
|
|
public function actionDelapply()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$status = $result['status'];
|
|
$id = $result['id'];
|
|
if (is_string($id)) {
|
|
$res = YII::$app->db->createCommand("select * from {{%ybwm_apply}} where id='$id'")->queryOne();
|
|
}
|
|
if (is_array($id)) {
|
|
$where = '(' . implode(',', $id) . ')';
|
|
$res = YII::$app->db->createCommand("select * from {{%ybwm_apply}} where id in" . $where)->queryOne();
|
|
}
|
|
|
|
if (!$res) {
|
|
return $this->result(2, '平台信息不存在');
|
|
} else {
|
|
if (is_array($id)) {
|
|
|
|
if ($status < 3) {
|
|
$re = YII::$app->db->createCommand()->update('{{%ybwm_apply}}', ['status' => $status, 'up_operdate' => date('Y-m-d H:i:s', time())], "id in $where")->execute();
|
|
|
|
}
|
|
if ($status == 3) {
|
|
$re = YII::$app->db->createCommand()->delete('{{%ybwm_apply}}', ['in', 'id', $id])->execute();
|
|
Yii::$app->db->createCommand()
|
|
->delete('{{%ybwm_users}}', ['in', 'uniacid', $id])
|
|
->execute();
|
|
}
|
|
|
|
} else {
|
|
if ($status < 3) {
|
|
$re = YII::$app->db->createCommand()->update('{{%ybwm_apply}}', ['status' => $status, 'up_operdate' => date('Y-m-d H:i:s', time())], ['id' => $id])->execute();
|
|
}
|
|
if ($status == 3) {
|
|
$re = YII::$app->db->createCommand()->delete('{{%ybwm_apply}}', ['id' => $id])->execute();
|
|
Yii::$app->db->createCommand()
|
|
->delete('{{%ybwm_users}}', 'uniacid=:uniacid', [':uniacid' => $id])
|
|
->execute();
|
|
}
|
|
}
|
|
if ($re !== false) {
|
|
return $this->result(1, '成功');
|
|
}
|
|
}
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//平台列表展示页面
|
|
public function actionPlatform_management()
|
|
{
|
|
//同步网站名称
|
|
// $fileData=file_get_contents('./web/secret.json');
|
|
// $jsonData=json_decode(ybwmDecrypt($fileData,Yii::$app->params['channel_model_name']),true);
|
|
// if(!$jsonData['domainName']){
|
|
// $re=(new \yii\db\Query())
|
|
// ->from('{{%ybwm_admin}}')
|
|
// ->one();
|
|
// $data=array(
|
|
// 'domainName'=>$re['domainName'],
|
|
// 'domainUrl'=>Yii::$app->request->hostInfo,
|
|
// 'isDev'=>Yii::$app->params['isDev']
|
|
// );
|
|
// $url=Yii::$app->params['domain_url'].'/cloud/safe/sendDomainName';
|
|
// $file_arr=httpRequest($url,$data);
|
|
// }
|
|
//$domianInfo=getVersion();
|
|
$fileData = file_get_contents('./web/secret.json');
|
|
$domianInfo = json_decode(ybwmDecrypt($fileData, Yii::$app->params['channel_model_name']), true);
|
|
|
|
//dd($domianInfo);die;
|
|
if (Yii::$app->session->get('adminInfo')['loginType'] <> 2) {
|
|
$table = (new \yii\db\Query())
|
|
->from('{{%ybwm_apply}}');
|
|
$data['created'] = $table
|
|
->where('status=1 AND end_time>:end_time', [':end_time' => date("Y-m-d H:i:s")])
|
|
->count();
|
|
$data['recycle'] = $table
|
|
->where('status=2')
|
|
->count();
|
|
$data['expire'] = $table
|
|
->where('status=1 AND end_time<:end_time', [':end_time' => date("Y-m-d H:i:s")])
|
|
->count();
|
|
if ($domianInfo['account_type'] == 1) {
|
|
$data['surplus'] = '无限';
|
|
} else {
|
|
$all = $table
|
|
->where('status!=3')
|
|
->count();
|
|
if ($domianInfo['account_type'] == 2) {
|
|
$num = bcsub($domianInfo['account_number'], $all, 0);
|
|
if ($num > 0) {
|
|
$data['surplus'] = $num;
|
|
} else {
|
|
$data['surplus'] = 0;
|
|
}
|
|
} else {
|
|
$data['surplus'] = '无限';
|
|
}
|
|
|
|
}
|
|
} else {
|
|
$phone = Yii::$app->session->get('adminInfo')['phone'];
|
|
$table = (new \yii\db\Query())
|
|
->from('{{%ybwm_apply}} a')
|
|
->leftJoin('{{%ybwm_users}} b', 'a.id=b.uniacid');
|
|
$data['created'] = $table
|
|
->where('a.status=1 and b.type=1 and b.phone=' . $phone)
|
|
->count();
|
|
|
|
$data['recycle'] = $table
|
|
->where('a.status=2 and b.type=1 and b.phone=' . $phone)
|
|
->count();
|
|
$data['expire'] = $table
|
|
->where('a.status=1 and b.type=1 and b.phone=' . $phone . ' AND end_time<:end_time', [':end_time' => date("Y-m-d H:i:s")])
|
|
->count();
|
|
if ($domianInfo['account_type'] == 1) {
|
|
$data['surplus'] = '无限';
|
|
} else {
|
|
$all = $table
|
|
->where('a.status!=3 and b.type=1 and b.phone=' . $phone)
|
|
->count();
|
|
if ($domianInfo['account_type'] == 2) {
|
|
$num = bcsub($domianInfo['account_number'], $all, 0);
|
|
if ($num > 0) {
|
|
$data['surplus'] = $num;
|
|
} else {
|
|
$data['surplus'] = 0;
|
|
}
|
|
} else {
|
|
$data['surplus'] = '无限';
|
|
}
|
|
|
|
}
|
|
|
|
$applyOper = (new \yii\db\Query())
|
|
->from('{{%ybwm_users}}')
|
|
->where(['phone' => Yii::$app->session->get('adminInfo')['phone'], 'type' => 1])->one();
|
|
|
|
$data['surplus'] = $applyOper['appNum'] - $data['created'];
|
|
}
|
|
$this->view->params['userType'] = Yii::$app->session->get('adminInfo')['userType'];
|
|
//dd($domianInfo);die;
|
|
return $this->renderPartial('platform_management', ['data' => $data]);
|
|
}
|
|
|
|
//支付通道列表展示页面
|
|
public function actionPlatform_payment() {
|
|
return $this->renderPartial('platform_payment', ['data' => '']);
|
|
}
|
|
|
|
//支付通道添加
|
|
public function actionPayment_add()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$connection = Yii::$app->db;
|
|
$channel_name = $result['channel_name'];
|
|
$command = $connection->createCommand("select * from {{%ybwm_pay_channel}} where channel_name='{$channel_name}' and status = 1");
|
|
$re = $command->queryOne();
|
|
if ($re) {
|
|
return $this->result(2, '支付通道已存在！');
|
|
}
|
|
$now_time = time();
|
|
$data = array(
|
|
'channel_name' => $result['channel_name'],
|
|
'status' => $result['status'],
|
|
'create_time' => $now_time,
|
|
'create_user_id' => $this->getUserId(),
|
|
);
|
|
if(isset($result['store_id'])) {
|
|
$store_ids_str = trim($result['store_id']);
|
|
$store_data = $connection->createCommand("select uniacid,id as store_id from {{%ybwm_store}} where id in ({$store_ids_str})")->queryAll();
|
|
$store_data_arr = [];
|
|
if(!empty($store_data)){
|
|
foreach ($store_data as $val){
|
|
$store_data_arr[$val['store_id']] = $val['uniacid'];
|
|
}
|
|
}
|
|
$store_id_arr = explode(',',$store_ids_str);
|
|
$transaction = Yii::$app->db->beginTransaction();
|
|
try {
|
|
$res = $connection->createCommand()->insert('{{%ybwm_pay_channel}}', $data)->execute();
|
|
//如果执行失败则抛出错误
|
|
if($res == false) {
|
|
throw new \Exception('操作失败');
|
|
}
|
|
$id = Yii::$app->db->getLastInsertID();
|
|
$bind_data['channel_id'] = $id;
|
|
$bind_data['create_time'] = $now_time;
|
|
$bind_data['create_user_id'] = $this->getUserId();
|
|
|
|
foreach ($store_id_arr as $store_id){
|
|
$bind_data['apply_id'] = $store_data_arr[$store_id];
|
|
$bind_data['store_id'] = $store_id;
|
|
$res2 = $connection->createCommand()->insert('{{%ybwm_store_paychannel}}', $bind_data)->execute();
|
|
}
|
|
$transaction->commit(); //只有执行了commit(),对于上面数据库的操作才会真正执行
|
|
return $this->result(1, '成功');
|
|
}
|
|
catch (Exception $e) {
|
|
$error = $e->getMessage(); //获取抛出的错误
|
|
$transaction->rollBack();
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
} else {
|
|
if($connection->createCommand()->insert('{{%ybwm_pay_channel}}', $data)->execute()){
|
|
return $this->result(1, '成功');
|
|
}
|
|
}
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
return $this->renderPartial('payment_add' );
|
|
}
|
|
|
|
//获取支付渠道列表
|
|
public function actionGetpaychannellist()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$page = Yii::$app->request->get('page') ? Yii::$app->request->get('page') : 1;
|
|
$num = ($page - 1) * 10;
|
|
$limit = 10;
|
|
$query = (new \yii\db\Query())
|
|
->select("channel_id,channel_name,status,create_time")
|
|
->from('{{%ybwm_pay_channel}}') ;
|
|
$count = count($query->all());
|
|
$res = $query->offset($num)
|
|
->limit($limit)
|
|
->orderBy('channel_id desc')
|
|
->all();
|
|
if($res){
|
|
foreach ($res as $key=>$val){
|
|
$res[$key]['status_name'] = $val['status'] == 1 ? '启用' : '禁用';
|
|
$res[$key]['create_time'] = $val['create_time'] ? date('Y-m-d H:i:s',$val['create_time']) : '';
|
|
}
|
|
}
|
|
echo json_encode(['code' => 1, 'msg' => '成功', 'data' => $res, 'count' => intval($count)]);
|
|
die;
|
|
}
|
|
}
|
|
|
|
//删除店铺绑定的支付通道
|
|
function actionDelpaychannel(){
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$store_id = $result['store_id'];
|
|
$id = $result['id'];
|
|
if(!$id || !$store_id) {
|
|
return $this->result(2, '参数错误请重新尝试！');
|
|
}
|
|
$data = YII::$app->db->createCommand("select * from {{%ybwm_store_paychannel}} where id='{$id}' and store_id = '{$store_id}' and is_del=0")->queryOne();
|
|
$up_data['is_del'] = 1;
|
|
$up_data['update_time'] = time();
|
|
$up_data['update_user_id'] = $this->getUserId();
|
|
if($data){
|
|
$res = YII::$app->db->createCommand()->update('{{%ybwm_store_paychannel}}', $up_data,['id' => $id])->execute();
|
|
if($res){
|
|
return $this->result(1, '删除成功');
|
|
} else {
|
|
return $this->result(2, '删除失败，请稍后重试！');
|
|
}
|
|
} else {
|
|
return $this->result(2, '数据不存在，删除失败！');
|
|
}
|
|
}
|
|
}
|
|
|
|
//停用支付通道
|
|
public function actionStoppaychannel()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$status = $result['status'];
|
|
$id = $result['id'];
|
|
if (is_string($id)) {
|
|
$res = YII::$app->db->createCommand("select * from {{%ybwm_pay_channel}} where channel_id='$id'")->queryOne();
|
|
}
|
|
if (is_array($id)) {
|
|
$where = '(' . implode(',', $id) . ')';
|
|
$res = YII::$app->db->createCommand("select * from {{%ybwm_pay_channel}} where channel_id in" . $where)->queryOne();
|
|
}
|
|
$now_time = time();
|
|
if (!$res) {
|
|
return $this->result(2, '支付渠道不存在不存在');
|
|
} else {
|
|
$update_data = [
|
|
'status' => $status,
|
|
'update_time' => $now_time,
|
|
'update_user_id'=>$this->getUserId()
|
|
];
|
|
if (is_array($id)) {
|
|
$re = YII::$app->db->createCommand()->update('{{%ybwm_pay_channel}}',$update_data , "channel_id in $where")->execute();
|
|
} else {
|
|
$re = YII::$app->db->createCommand()->update('{{%ybwm_pay_channel}}', $update_data, ['channel_id' => $id])->execute();
|
|
}
|
|
if ($re !== false) {
|
|
return $this->result(1, '成功');
|
|
}
|
|
}
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
//平台列表根据条件搜索出结果
|
|
public function actionPaychennelbysearch()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$request = axios_request();
|
|
$sql = (new \yii\db\Query())->from('{{%ybwm_pay_channel}}')
|
|
->select('channel_id,channel_name,status,create_time');
|
|
$channel_name = $request['channel_name'];
|
|
$start_time = $request['start_time'] ? strtotime($request['start_time']) : '';
|
|
$end_time = $request['end_time'] ? strtotime($request['end_time']) + 86399 : '';
|
|
if ($channel_name) {
|
|
$sql->andWhere(['like', 'channel_name', $channel_name]);
|
|
}
|
|
if ($start_time && $end_time) {
|
|
|
|
$sql->andWhere(['between', 'create_time',$start_time,$end_time]);
|
|
}
|
|
$desc = $request['desc'] ?: 'desc';
|
|
|
|
if ($desc) {
|
|
$sql->orderBy('channel_id ' . $desc);
|
|
}
|
|
$page = $request['page'] ? $request['page'] : 1;
|
|
$num = 10 * $page;
|
|
if ($page == 1) {
|
|
$sql->limit(10);
|
|
} else {
|
|
$sql->limit(10, $num);
|
|
}
|
|
$count = count($sql->all());
|
|
$res = $sql->all();
|
|
if($res){
|
|
foreach ($res as $key=>$val){
|
|
$res[$key]['status_name'] = $val['status'] == 1 ? '启用' : '禁用';
|
|
$res[$key]['create_time'] = $val['create_time'] ? date('Y-m-d H:i:s',$val['create_time']) : '';
|
|
}
|
|
}
|
|
return $this->result(1, '成功', $res, intval($count));
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//支付通道修改跳转指定页面
|
|
public function actionPayment_edit(){
|
|
return $this->renderpartial('payment_edit');
|
|
}
|
|
//通过自增id获取修改的的详细信息
|
|
public function actionPaymentDetails()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$channel_id = Yii::$app->request->get('channel_id');
|
|
$data = (new \yii\db\Query())
|
|
->select('channel_id,channel_name,status')
|
|
->from('{{%ybwm_pay_channel}}')
|
|
->where(['channel_id' => $channel_id])
|
|
->one();
|
|
if($data){
|
|
$sql = "
|
|
select a.store_id,s.name as store_name
|
|
from {{%ybwm_store_paychannel}} a
|
|
left join {{%ybwm_store}} s on a.store_id=s.id
|
|
where a.channel_id='$channel_id' and a.is_del = 0
|
|
order by a.store_id asc
|
|
";
|
|
$bind_data = YII::$app->db->createCommand($sql)->queryAll();
|
|
$temp = [];
|
|
if($bind_data){
|
|
foreach ($bind_data as $val){
|
|
$temp[] = $val['store_id'];
|
|
}
|
|
}
|
|
$data['bind_data'] = $temp;
|
|
}
|
|
return $this->result(1, '成功', $data);
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//支付通道修改保存
|
|
public function actionPaychannelsave()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$connection = Yii::$app->db;
|
|
$channel_id = $result['channel_id'];
|
|
if(empty($channel_id)){
|
|
return $this->result(2, '参数错误，请重新加载页面尝试！');
|
|
}
|
|
$channel_name = $result['channel_name'];
|
|
$sql = "select * from {{%ybwm_pay_channel}} where channel_name='{$channel_name}' and status = 1 and channel_id != '{$channel_id}'";
|
|
$re = $connection->createCommand($sql)->queryOne();
|
|
if ($re) {
|
|
return $this->result(2, '支付通道已存在！');
|
|
}
|
|
$now_time = time();
|
|
$data = array(
|
|
'channel_name' => $result['channel_name'],
|
|
'status' => $result['status'],
|
|
'update_time' => $now_time,
|
|
'update_user_id' => $this->getUserId(),
|
|
);
|
|
|
|
$res = $connection->createCommand()->update('{{%ybwm_pay_channel}}', $data,['channel_id' => $channel_id])->execute();
|
|
if($res){
|
|
return $this->result(1, '操作成功');
|
|
}
|
|
|
|
// $store_ids_str = trim($result['store_id']);
|
|
// $store_id_arr = explode(',',$store_ids_str);
|
|
// if(!empty($result['store_id'])) {
|
|
// $store_data = $connection->createCommand("select uniacid,id as store_id from {{%ybwm_store}} where id in ({$store_ids_str})")->queryAll();
|
|
// $store_data_arr = [];
|
|
// if(!empty($store_data)){
|
|
// foreach ($store_data as $val){
|
|
// $store_data_arr[$val['store_id']] = $val['uniacid'];
|
|
// }
|
|
// }
|
|
// $transaction = Yii::$app->db->beginTransaction();
|
|
// try {
|
|
// $is_exist_data = $connection->createCommand("select * from {{%ybwm_store_paychannel}} where channel_id ='{$channel_id}' ")->queryAll();
|
|
// //若绑定店铺存在，先删除原来绑定的，在重新入库
|
|
// if($is_exist_data){
|
|
// $del_res = YII::$app->db->createCommand()->delete('{{%ybwm_store_paychannel}}', "channel_id = {$channel_id}")->execute();
|
|
// if(!$del_res){
|
|
// throw new \Exception('操作失败1');
|
|
// }
|
|
// }
|
|
// $res = $connection->createCommand()->update('{{%ybwm_pay_channel}}', $data,['channel_id' => $channel_id])->execute();
|
|
// //如果执行失败则抛出错误
|
|
// if($res == false) {
|
|
// throw new \Exception('操作失败');
|
|
// }
|
|
// $bind_data['channel_id'] = $channel_id;
|
|
// $bind_data['create_time'] = $now_time;
|
|
// $bind_data['create_user_id'] = $this->getUserId();
|
|
//
|
|
// foreach ($store_id_arr as $store_id){
|
|
// $bind_data['apply_id'] = $store_data_arr[$store_id];
|
|
// $bind_data['store_id'] = $store_id;
|
|
// $res2 = $connection->createCommand()->insert('{{%ybwm_store_paychannel}}', $bind_data)->execute();
|
|
// }
|
|
// $transaction->commit(); //只有执行了commit(),对于上面数据库的操作才会真正执行
|
|
// return $this->result(1, '修改成功');
|
|
// }
|
|
// catch (Exception $e) {
|
|
// $error = $e->getMessage(); //获取抛出的错误
|
|
// $transaction->rollBack();
|
|
// return $this->result(2, '网络异常,请稍后再试');
|
|
// }
|
|
// } else {
|
|
// $transaction = Yii::$app->db->beginTransaction();
|
|
// try {
|
|
// //修改如果没有绑定店铺，则表示删除了绑定店铺
|
|
// $is_exist_data = $connection->createCommand("select * from {{%ybwm_store_paychannel}} where channel_id ='{$channel_id}' ")->queryAll();
|
|
// //若绑定店铺存在，先删除原来绑定的，在重新入库
|
|
// if($is_exist_data){
|
|
// $del_res = YII::$app->db->createCommand()->delete('{{%ybwm_store_paychannel}}', "channel_id = {$channel_id}")->execute();
|
|
// if(!$del_res){
|
|
// throw new \Exception('操作失败1');
|
|
// }
|
|
// }
|
|
// $res = $connection->createCommand()->update('{{%ybwm_pay_channel}}', $data,['channel_id' => $channel_id])->execute();
|
|
// $transaction->commit(); //只有执行了commit(),对于上面数据库的操作才会真正执行
|
|
// return $this->result(1, '修改成功');
|
|
// }
|
|
// catch (Exception $e) {
|
|
// $error = $e->getMessage(); //获取抛出的错误
|
|
// $transaction->rollBack();
|
|
// return $this->result(2, '网络异常,请稍后再试');
|
|
// }
|
|
// }
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//启用支付通道
|
|
public function actionOpenpaychannel()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$result = axios_request();
|
|
$status = $result['status'];
|
|
$id = $result['id'];
|
|
if (is_string($id)) {
|
|
$res = YII::$app->db->createCommand("select * from {{%ybwm_pay_channel}} where channel_id='$id'")->queryOne();
|
|
}
|
|
if (is_array($id)) {
|
|
$where = '(' . implode(',', $id) . ')';
|
|
$res = YII::$app->db->createCommand("select * from {{%ybwm_pay_channel}} where channel_id in" . $where)->queryOne();
|
|
}
|
|
$now_time = time();
|
|
if (!$res) {
|
|
return $this->result(2, '支付渠道不存在不存在');
|
|
} else {
|
|
$update_data = [
|
|
'status' => $status,
|
|
'update_time' => $now_time,
|
|
'update_user_id'=>$this->getUserId()
|
|
];
|
|
if (is_array($id)) {
|
|
$re = YII::$app->db->createCommand()->update('{{%ybwm_pay_channel}}',$update_data , "channel_id in $where")->execute();
|
|
} else {
|
|
$re = YII::$app->db->createCommand()->update('{{%ybwm_pay_channel}}', $update_data, ['channel_id' => $id])->execute();
|
|
}
|
|
if ($re !== false) {
|
|
return $this->result(1, '成功');
|
|
}
|
|
}
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
//获取平台列表所有信息
|
|
public function actionGetapplylist()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isGet) {
|
|
$page = Yii::$app->request->get('page') ? Yii::$app->request->get('page') : 1;
|
|
$num = ($page - 1) * 10;
|
|
$limit = 10;
|
|
$query = (new \yii\db\Query())
|
|
->select('a.id,a.dt_operdate,a.apply_type,a.apply_image,a.apply_name,a.time_type,a.end_time,
|
|
(SELECT id FROM {{%ybwm_users}} b WHERE type = 1 AND b.uniacid = a.id limit 1) AS userId,
|
|
(SELECT userName FROM {{%ybwm_users}} b WHERE type = 1 AND b.uniacid = a.id limit 1) AS userName,
|
|
(SELECT phone FROM {{%ybwm_users}} b WHERE type = 1 AND b.uniacid = a.id limit 1) AS phone'
|
|
)
|
|
->from('{{%ybwm_apply}} a')
|
|
->where(['a.status' => 1]);
|
|
|
|
$userType = 0;
|
|
// dd(Yii::$app->session->get('adminInfo')['loginType']);die;
|
|
if (Yii::$app->session->get('adminInfo')['loginType'] == 3) {
|
|
$userType = 1;
|
|
$count = count($query->all());
|
|
//var_dump(ddSql($query));die;
|
|
$re = $query->offset($num)
|
|
->limit($limit)
|
|
->orderBy('a.sort asc,a.id desc')
|
|
->all();
|
|
}
|
|
|
|
if (Yii::$app->session->get('adminInfo')['loginType'] == 1) {
|
|
$query = '';
|
|
$query = (new \yii\db\Query())->from('{{%ybwm_apply}} a')
|
|
->select('a.id,b.phone,apply_type,apply_image,apply_name,time_type,start_time,end_time,b.id userId,b.userName')
|
|
->leftJoin('{{%ybwm_users}} b', 'a.id=b.uniacid')
|
|
->where(['a.status' => 1, 'userName' => Yii::$app->session->get('adminInfo')['userName'], 'b.type' => 1])
|
|
->andWhere(['>=', 'a.end_time', date('Y-m-d H:i:s', time())]);
|
|
$count = count($query->all());
|
|
$re = $query->offset($num)
|
|
->limit($limit)
|
|
->orderBy('a.sort asc,a.id desc')
|
|
->all();
|
|
}
|
|
if (Yii::$app->session->get('adminInfo')['loginType'] == 2) {
|
|
$query = '';
|
|
$query = (new \yii\db\Query())->from('{{%ybwm_apply}} a')
|
|
->select('b.appNum,a.id,b.phone,apply_type,apply_image,apply_name,time_type,start_time,end_time,b.id userId,b.userName')
|
|
->leftJoin('{{%ybwm_users}} b', 'a.id=b.uniacid')
|
|
->where(['a.status' => 1, 'phone' => Yii::$app->session->get('adminInfo')['phone'], 'b.type' => 1])
|
|
->andWhere(['>=', 'a.end_time', date('Y-m-d H:i:s', time())]);;
|
|
//var_dump(ddSql($query));die;
|
|
$count = count($query->all());
|
|
$appNumRe = (new \yii\db\Query())->from('{{%ybwm_users}}')->where(['phone' => Yii::$app->session->get('adminInfo')['phone']])->one();
|
|
if ($appNumRe['appNum'] > $count) {
|
|
$userType = 1;
|
|
}
|
|
$re = $query->offset($num)
|
|
->limit($limit)
|
|
->orderBy('a.sort asc,a.id desc')
|
|
->all();
|
|
|
|
}
|
|
foreach ($re as $k => $v) {
|
|
if ($v['time_type'] == 1 && strtotime($v['end_time']) < time()) {
|
|
$re[$k]['status'] = 2;
|
|
} else {
|
|
$re[$k]['status'] = 1;
|
|
}
|
|
}
|
|
|
|
echo json_encode(['code' => 1, 'msg' => '成功', 'data' => $re, 'count' => intval($count), 'userType' => $userType]);
|
|
die;
|
|
}
|
|
}
|
|
|
|
//平台列表根据条件搜索出结果
|
|
public function actionApplybysearch()
|
|
{
|
|
$request = Yii::$app->request;
|
|
|
|
if ($request->isPost) {
|
|
$request = axios_request();
|
|
$status = $request['apply_status'] ?: 1;
|
|
$sql = (new \yii\db\Query())->from('{{%ybwm_apply}} a')
|
|
->select('a.*,b.userName,b.id userId')
|
|
->leftJoin('{{%ybwm_users}} b', 'a.id=b.uniacid')
|
|
->where(['a.status' => $status, 'type' => 1]);
|
|
$apply_type = $request['apply_type'];
|
|
$apply_name = $request['apply_name'];
|
|
$start_time = $request['start_time'];
|
|
$end_time = $request['end_time'];
|
|
$phone = $request['phone'];
|
|
if ($apply_type) {
|
|
$sql->andWhere(['a.apply_type' => $apply_type]);
|
|
}
|
|
if ($apply_name) {
|
|
$sql->andWhere(['like', 'a.apply_name', $apply_name]);
|
|
}
|
|
if ($phone) {
|
|
$sql->andWhere(['b.user_phone' => $phone]);
|
|
}
|
|
if ($start_time && $end_time) {
|
|
$sql->andWhere(['>=', 'a.dt_operdate' => $phone])->andWhere(['<=', 'a.dt_operdate' => $phone]);
|
|
}
|
|
if (!Yii::$app->session->get('adminInfo')['userType']) {
|
|
$phone = Yii::$app->session->get('adminInfo')['phone'];
|
|
$sql->andWhere(['b.phone' => $phone])->andWhere(['b.type' => 1])->andWhere(['>', 'b.phone', '']);
|
|
}
|
|
$desc = $request['desc'] ?: 'desc';
|
|
|
|
if ($desc) {
|
|
$sql->orderBy('a.dt_operdate ' . $desc);
|
|
}
|
|
$page = $request['page'] ? $request['page'] : 1;
|
|
$num = 10 * $page;
|
|
if ($page == 1) {
|
|
$sql->limit(10);
|
|
} else {
|
|
$sql->limit(10, $num);
|
|
}
|
|
|
|
$count = count($sql->all());
|
|
$re = $sql->all();
|
|
return $this->result(1, '成功', $re, intval($count));
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//获取平台回收站的数据
|
|
public function actionGetrecycle()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$sessionData = Yii::$app->session->get('adminInfo');
|
|
$request = axios_request();
|
|
// $sql="select * from {{%ybwm_apply}} where status=2";
|
|
$sql = "select a.*,b.userName,b.phone from {{%ybwm_apply}} a left join {{%ybwm_users}} b on a.id=b.uniacid where a.status=2";
|
|
//dd($sql);die;
|
|
$apply_type = $request['apply_type'];
|
|
$apply_name = $request['apply_name'];
|
|
if ($apply_type) {
|
|
$sql = " and apply_type='$apply_type'";
|
|
}
|
|
if ($apply_name) {
|
|
$sql = " and apply_name='$apply_name'";
|
|
}
|
|
//var_dump(Yii::$app->session->get('adminInfo')['loginType']);die;
|
|
if (Yii::$app->session->get('adminInfo')['loginType'] < 3) {
|
|
$phone = Yii::$app->session->get('adminInfo')['phone'];
|
|
$sql .= " and b.phone=$phone and b.type=1";
|
|
}
|
|
|
|
$count = count(Yii::$app->db->createCommand($sql)->queryAll());
|
|
|
|
$page = $request['page'] ? $request['page'] : 1;
|
|
$num = 10 * $page;
|
|
if ($page == 1) {
|
|
$sql .= " order by a.dt_operdate desc limit 10";
|
|
} else {
|
|
$sql .= " order by a.dt_operdate desc limit 10,$num";
|
|
}
|
|
$re = Yii::$app->db->createCommand($sql)->queryAll();
|
|
return $this->result(1, '成功', $re, intval($count));
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//平台回收站恢复
|
|
public function actionRecovery()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$request = axios_request();
|
|
//$status 1恢复平台 3删除平台
|
|
$status = $request['status'];
|
|
$id = $request['id'];
|
|
$res = YII::$app->db->createCommand()->update('{{%ybwm_apply}}', ['status' => $status, 'up_operdate' => date('Y-m-d H:i:s', time())], 'id=:id', ['id' => $id])->execute();
|
|
if ($res !== false) {
|
|
return $this->result(1, '成功');
|
|
} else {
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
//平台应用后台业务管理员添加
|
|
public function actionPlatform_userm()
|
|
{
|
|
$this->view->params['userType'] = Yii::$app->session->get('adminInfo')['userType'];
|
|
return $this->renderpartial('platform_userm');
|
|
}
|
|
|
|
//平台应用修改页面
|
|
public function actionPlatform_edit()
|
|
{
|
|
if (!Yii::$app->session->get('adminInfo')['userType']) {
|
|
$request = axios_request();
|
|
Yii::$app->response->redirect(['admin/apply/platform_userm', 'id' => $request['id']], 301)->send();
|
|
die;
|
|
}
|
|
return $this->renderpartial('platform_edit');
|
|
}
|
|
|
|
//平台应用后台业务管理员添加
|
|
public function actionUseradd()
|
|
{
|
|
$request = Yii::$app->request;
|
|
if ($request->isPost) {
|
|
$request = axios_request();
|
|
$connection = Yii::$app->db;
|
|
$user_name = $request['user_name'];
|
|
$command = $connection->createCommand("select * from {{%ybwm_users}} where userName='$user_name'");
|
|
$re = $command->queryOne();
|
|
if ($re) {
|
|
return $this->result(2, '用户已存在');
|
|
}
|
|
$salt = random(8);
|
|
$auth_key = Yii::$app->params['authkey'];
|
|
if (!$request['unionid']) {
|
|
$request['unionid'] = $connection->createCommand("select * from {{%ybwm_apply}} where user_bind='0'")->queryOne()['id'];
|
|
}
|
|
$data = array(
|
|
'uniacid' => $request['unionid'],
|
|
'userName' => $request['user_name'],
|
|
'passWord' => sha1($request['password'] . '--' . $salt . '--' . $auth_key),
|
|
'salt' => $salt,
|
|
'createdAt' => time(),
|
|
'phone' => $request['user_phone'],
|
|
);
|
|
$res = $connection->createCommand()->insert('{{%ybwm_users}}', $data)->execute();
|
|
if ($res) {
|
|
$connection->createCommand()->update('{{%ybwm_apply}}', ['user_bind' => 1], ['id' => $request['unionid']])->execute();
|
|
|
|
return $this->result(1, '成功');
|
|
} else {
|
|
return $this->result(2, '网络异常,请稍后再试');
|
|
}
|
|
}
|
|
return $this->result(2, '请求异常');
|
|
}
|
|
|
|
|
|
public function actionCeshidemo()
|
|
{
|
|
// Yii::$app->session['var']='viva';
|
|
echo Yii::$app->request->referrer;
|
|
|
|
}
|
|
public function actionPlatform_enclosure()
|
|
{
|
|
return $this->renderpartial('platform_enclosure');
|
|
}
|
|
|
|
public function actionOther_set()
|
|
{
|
|
if (!Yii::$app->session->get('adminInfo')['userType']) {
|
|
Yii::$app->response->redirect(['admin/apply/platform_management'], 301)->send();
|
|
die;
|
|
}
|
|
return $this->renderpartial('other_set');
|
|
}
|
|
|
|
public function menuConfig()
|
|
{
|
|
$data = [
|
|
[
|
|
'id' => 1,
|
|
'use_name' => '堂食'
|
|
],
|
|
[
|
|
'id' => 2,
|
|
'use_name' => '会员卡'
|
|
],
|
|
[
|
|
'id' => 3,
|
|
'use_name' => '会员储值'
|
|
],
|
|
[
|
|
'id' => 4,
|
|
'use_name' => '积分签到'
|
|
],
|
|
[
|
|
'id' => 5,
|
|
'use_name' => '积分商城'
|
|
],
|
|
];
|
|
return $data;
|
|
}
|
|
|
|
}
|