売上管理 | Life Widen

prepare("SELECT * FROM L_USER WHERE U_UUID = ?"); $stmt->execute([$_SESSION['ADMIN_SESSION_ID']]); $user_data = $stmt->fetch(PDO::FETCH_ASSOC); if (!isset($_GET['y']) || $_GET['y'] == '') { $y = date('Y'); } else { $y = $_GET['y']; } if (!isset($_GET['m']) || $_GET['m'] == '') { $m = date('n'); } else { $m = $_GET['m']; } $diff = date('Y-m-d', strtotime($y . '-' . $m . '-1')); // 売上 $dispmonth = date('m', strtotime($diff)); $P_PAYDATE_min = date('Y-m-1', strtotime($diff)); $P_PAYDATE_max = date('Y-m-t', strtotime($diff)); $stmt = $DBh->prepare('SELECT * FROM L_PAYLOG WHERE P_PAYDATE >= :P_PAYDATE_min AND P_PAYDATE <= :P_PAYDATE_max ORDER BY P_PAYDATE ASC'); $stmt->bindValue(':P_PAYDATE_min', $P_PAYDATE_min); $stmt->bindValue(':P_PAYDATE_max', $P_PAYDATE_max); $stmt->execute(); $paylist = $stmt->fetchAll(); $stmt = $DBh->prepare('SELECT U_UUID, U_NAME FROM L_USER'); $stmt->execute(); $userlist = $stmt->fetchAll(); $total = 0; // 売上合計 $fee = 0; // 会費売上 $option_pay = 0; // オプション売上 $reward = 0; // 利益 $lessonfee = 3000; // レッスン1回あたりのトレーナー取り分 $lessonfee = $lessonfee * 4; $history = ''; $count = 0; foreach($paylist as $pay_row) { if ($pay_row['P_RESULT'] == 1) { $result = '決済OK'; $errorclass = ''; $total += $pay_row['P_AMOUNT']; $fee += $pay_row['P_M_FEE']; $option_pay += $pay_row['P_COOKING']; $reward += $lessonfee + $pay_row['P_COOKING']; } elseif ($pay_row['P_RESULT'] == 2) { $result = $pay_row['P_MSG']; $errorclass = 'tx-red'; } $name = ''; foreach($userlist as $user_row) { if ($user_row['U_UUID'] == $pay_row['P_U_UUID']) { $name = $user_row['U_NAME']; continue; } } $count += 1; $history .= ' '. $count . ' '.date('Y年m月d日', strtotime($pay_row['P_PAYDATE'])).' '.$name.' '.$result.' ¥'.number_format($pay_row['P_AMOUNT']).' ¥'.number_format($pay_row['P_M_FEE']).' ¥'.number_format($pay_row['P_COOKING']).' '."\n"; } $total; // 決済額合計 $subtraction = ceil($total - ($total * 0.036)); // 決済手数料差引額 $fee; // 月会費 $option_pay; // オプション $reward; // 報酬（振込額） $profit = $subtraction - $reward; // 利益 ?> 売上管理 | Life Widen

売上管理（月）※毎月10日に反映

表示月

決済額合計	¥
決済手数料差引額（-3.6％）	¥
月会費	¥
オプション	¥
報酬（振込額）	¥
利益	¥

決済履歴

	決済日	名前	決済ステータス	決済額	会費	オプション