";
$searchTime = 'thisMonth';
$startTime = $get['startTime'] ?? '';
$endTime = $get['endTime'] ?? '';
$period = dateUtil::formatTime($searchTime, $startTime, $endTime, true);
$start = $period['startTime'];
$end = $period['endTime'];
$currentStartDate = date('Y-m-d', strtotime($start));
$currentEndDate = date('Y-m-d', strtotime($end));
$currentStartTime = $currentStartDate . ' 00:00:00';
$currentEndTime = $currentEndDate . ' 23:59:59';
$shopId = 763;
//$shopId = 4892;
$shop = ShopClass::getById($shopId, true);
$mainId = $shop->mainId ?? 0;
$incomeList = [];
$an = 0;
//零售开单
$hdWhere = ['mainId' => $mainId, 'status' => ['in', [HdOrderClass::ORDER_STATUS_UN_SEND, HdOrderClass::ORDER_STATUS_SENDING, HdOrderClass::ORDER_STATUS_COMPLETE]]];
$hdWhere['payTime'] = ['between', [$currentStartTime, $currentEndTime]];
$hdOrderList = HdOrderClass::getAllByCondition($hdWhere, null, '*');
foreach ($hdOrderList as $hdKey => $hdOrder) {
$payWay = $hdOrder['payWay'] ?? 0;
$mainPay = $hdOrder['mainPay'] ?? 0;
$cash = $hdOrder['cash'] ?? 0;
$actPrice = $hdOrder['mainPay'] ?? 0;
$getStaffId = $hdOrder['getStaffId'] ?? 0;
$debtPrice = $hdOrder['debtPrice'] ?? 0;
$remainDebtPrice = $hdOrder['remainDebtPrice'] ?? 0;
$onlinePay = $hdOrder['onlinePay'] ?? 0;
$fromType = $hdOrder['fromType'] ?? 0;
$an = bcadd($an, $mainPay, 2);
$an = bcadd($an,$cash,2);
if ($onlinePay == dict::getDict('onlinePay', 'yes')) {
//使用在线支付
$incomeList['system']['amount'] = bcadd($incomeList['system']['amount'], $mainPay, 2);
$incomeList['system']['num'] = bcadd($incomeList['system']['num'], 1);
$incomeList['system']['category']['ls']['amount'] = bcadd($incomeList['system']['category']['ls']['amount'], $mainPay, 2);
$incomeList['system']['category']['ls']['num'] = bcadd($incomeList['system']['category']['ls']['num'], 1);
if ($cash > 0) {
$incomeList['cash']['amount'] = bcadd($incomeList['cash']['amount'], $cash, 2);
$incomeList['cash']['num'] = bcadd($incomeList['cash']['num'], 1);
$incomeList['cash']['category']['ls']['amount'] = bcadd($incomeList['cash']['category']['ls']['amount'], $cash, 2);
$incomeList['cash']['category']['ls']['num'] = bcadd($incomeList['cash']['category']['ls']['num'], 1);
}
} else {
if ($fromType == dict::getDict('fromType', 'mt')) {
//美团!!!
$incomeList['mt']['amount'] = bcadd($incomeList['mt']['amount'], $mainPay, 2);
$incomeList['mt']['num'] = bcadd($incomeList['mt']['num'], 1);
} else {
//非美团!!!
if ($debtPrice > 0) {
if ($remainDebtPrice > 0) {
$incomeList['debt']['amount'] = bcadd($incomeList['debt']['amount'], $remainDebtPrice, 2);
$incomeList['debt']['num'] = bcadd($incomeList['debt']['num'], 1);
$incomeList['debt']['category']['ls']['amount'] = bcadd($incomeList['debt']['category']['ls']['amount'], $remainDebtPrice, 2);
$incomeList['debt']['category']['ls']['num'] = bcadd($incomeList['debt']['category']['ls']['num'], 1);
}
$clearDebt = bcsub($debtPrice, $remainDebtPrice, 2);
if ($clearDebt > 0) {
$incomeList['debtClear']['amount'] = bcadd($incomeList['debtClear']['amount'], $clearDebt, 2);
$incomeList['debtClear']['num'] = bcadd($incomeList['debtClear']['num'], 1);
$incomeList['debtClear']['category']['ls']['amount'] = bcadd($incomeList['debtClear']['category']['ls']['amount'], $clearDebt, 2);
$incomeList['debtClear']['category']['ls']['num'] = bcadd($incomeList['debtClear']['category']['ls']['num'], 1);
}
$currentAmount = bcsub($mainPay, $debtPrice, 2);
} else {
$currentAmount = $mainPay;
}
if ($currentAmount > 0) {
//使用非在线支付
switch ($payWay) {
case dict::getDict('payWay', 'wxPay'):
//员工微信总共收了多少笔多少钱
$incomeList['kfWx']['amount'] = bcadd($incomeList['kfWx']['amount'], $currentAmount, 2);
$incomeList['kfWx']['num'] = bcadd($incomeList['kfWx']['num'], 1);
//批发开单、零售开单、批发结账、零售尾款各收了多少现金
$incomeList['kfWx']['category']['ls']['amount'] = bcadd($incomeList['kfWx']['category']['ls']['amount'], $currentAmount, 2);
$incomeList['kfWx']['category']['ls']['num'] = bcadd($incomeList['kfWx']['category']['ls']['num'], 1);
//客1 客2 客3各收了多少钱
if (isset($incomeList['kfWx']['class'][$getStaffId])) {
$incomeList['kfWx']['class'][$getStaffId]['amount'] = bcadd($incomeList['kfWx']['class'][$getStaffId]['amount'], $currentAmount, 2);
$incomeList['kfWx']['class'][$getStaffId]['num'] = bcadd($incomeList['kfWx']['class'][$getStaffId]['num'], 1);
}
//每个客服收的明细
if (isset($incomeList['kfWx']['class'][$getStaffId]['itemList']['ls'])) {
$incomeList['kfWx']['class'][$getStaffId]['itemList']['ls']['amount'] = floatval(bcadd($incomeList['kfWx']['class'][$getStaffId]['itemList']['ls']['amount'], $currentAmount, 2));
$incomeList['kfWx']['class'][$getStaffId]['itemList']['ls']['num'] = bcadd($incomeList['kfWx']['class'][$getStaffId]['itemList']['ls']['num'], 1);
}
break;
case dict::getDict('payWay', 'alipay'):
$incomeList['aliPay']['amount'] = bcadd($incomeList['aliPay']['amount'], $currentAmount, 2);
$incomeList['aliPay']['num'] = bcadd($incomeList['aliPay']['num'], 1);
$incomeList['aliPay']['category']['ls']['amount'] = bcadd($incomeList['aliPay']['category']['ls']['amount'], $currentAmount, 2);
$incomeList['aliPay']['category']['ls']['num'] = bcadd($incomeList['aliPay']['category']['ls']['num'], 1);
break;
case dict::getDict('payWay', 'cash'):
$incomeList['cash']['amount'] = bcadd($incomeList['cash']['amount'], $currentAmount, 2);
$incomeList['cash']['num'] = bcadd($incomeList['cash']['num'], 1);
$incomeList['cash']['category']['ls']['amount'] = bcadd($incomeList['cash']['category']['ls']['amount'], $currentAmount, 2);
$incomeList['cash']['category']['ls']['num'] = bcadd($incomeList['cash']['category']['ls']['num'], 1);
break;
case dict::getDict('payWay', 'bankCard'):
$incomeList['bankCard']['amount'] = bcadd($incomeList['bankCard']['amount'], $currentAmount, 2);
$incomeList['bankCard']['num'] = bcadd($incomeList['bankCard']['num'], 1);
$incomeList['bankCard']['category']['ls']['amount'] = bcadd($incomeList['bankCard']['category']['ls']['amount'], $currentAmount, 2);
$incomeList['bankCard']['category']['ls']['num'] = bcadd($incomeList['bankCard']['category']['ls']['num'], 1);
break;
case dict::getDict('payWay', 'unknown'):
$incomeList['other']['amount'] = bcadd($incomeList['other']['amount'], $currentAmount, 2);
$incomeList['other']['num'] = bcadd($incomeList['other']['num'], 1);
$incomeList['other']['category']['ls']['amount'] = bcadd($incomeList['other']['category']['ls']['amount'], $currentAmount, 2);
$incomeList['other']['category']['ls']['num'] = bcadd($incomeList['other']['category']['ls']['num'], 1);
break;
default:
echo $mainPay.'--------';
}
}
}
}
}
$total = 0;
foreach ($incomeList as $i) {
$current = $i['amount'] ?? 0;
$total = bcadd($current, $total, 2);
}
echo '
零售收入:' . $total . ' ' . $an . '
';
print_r($incomeList);
die;
}
//即时配送
public function actionGetBindAccount()
{
$merchant = WxOpenClass::getGhsWxInfo();
$isOpen = 2;
$r = miniUtil::getBindAccount($merchant, $isOpen);
dd($r);
}
public function actionDada()
{
//https://github.com/wanDoubleMing/dada_openapi_php
//初始化一个配置文件
$dada = Yii::getAlias("@vendor/dada/");
require_once $dada . 'api/addOrderApi.php';
require_once $dada . 'client/dadaRequestClient.php';
require_once $dada . 'client/dadaResponse.php';
require_once $dada . 'config/config.php';
require_once $dada . 'model/orderModel.php';
// isOnline 判断是否是测试环境,会有不同的域名等
$isOnline = false;
//商户id
$sourceId = 73753;
$shopNo = 11047059;
// 初始化一个config
$config = new \Config($sourceId, $isOnline);
//3.domain文件新建一个model,并初始化
$orderModel = new \OrderModel();
$orderModel->setShopNo($shopNo);
$orderModel->setOriginId('2020043017180001');
$orderModel->setCityCode('021');
$orderModel->setCargoPrice(10);
$orderModel->setIsPrepay(0);
$orderModel->setReceiverName('测试达达');
$orderModel->setReceiverAddress('上海市崇明岛');
$orderModel->setReceiverLat(31.63);
$orderModel->setReceiverLng(121.41);
$orderModel->setReceiverPhone('15280215347');
$orderModel->setCallback('https://api.saas.huaml.com/express/callback');
// api主要有2个参数,一个是url, 一个是业务参数
$addOrderApi = new \AddOrderApi(json_encode($orderModel));
//5.初始化客户端,并调用rpc
$dada_client = new \DadaRequestClient($config, $addOrderApi);
$resp = $dada_client->makeRequest();
echo json_encode($resp);
}
public function actionRabbit()
{
$orderId = 214752;
$order = OrderService::getById($orderId);
$sjId = $order['sjId'];
$openMerchant = WxOpenService::getWxInfo();
$merchant = MerchantService::getMerchantById($sjId);
$shopId = $merchant['defaultShopId'];
$params = ['sourceType' => $order['sourceType'], 'miniAppId' => $openMerchant['miniAppId'], 'orderId' => $orderId];
$type = 'income';
InformAdminService::addInform($shopId, $type, $params);
}
//添加优惠券 ssh 2020.5.5
public function actionAddCoupon()
{
$merchant = MerchantService::getMerchantById(12358);
$user = UserService::getById(12543444);
UserService::focus($user, $merchant);
}
public function actionGetUnionId()
{
$merchant = MerchantService::getMerchantById(12358);
$extend = MerchantExtendService::getBySjId(12358);
$mcId = $extend['wxPayMerchantId'];
$orderId = '200512145420123581254345688252';
miniUtil::getPaidUnionId($merchant, 'o-hXO4qOzIVbUNVucoFzEiArOz5k', $mcId, $orderId, 0);
}
public function actionCalc()
{
$dis = mapUtil::calculateDistance('116.308479', '39.983171', '116.328479', '39.973171');
echo $dis;
}
}