关于日常收费计算的代码逻辑（php）

咸鱼饭 2015-10-28 10:57:07

假设，有A,B,C三个人住在一起，需要开发一个网站来记录他们日常花费，比如买菜等等。那么数据表该怎么设计呢？另外这些数据怎么运算到每个人总共要付出多少钱呢？
以下是我的代码：
//$aData里面的每个数组表示每天的消费记录, money:当天总费用， mean：人均费用，其他的表示用户名： 1/0/-1 付钱人/不用付/要付钱人
$aData = [
['money' => 30, 'mean'=> 10, 'twl' => 1, 'xxx' => -1, 'yyy' => -1],
['money' => 10, 'mean'=> 5, 'twl' => -1, 'xxx' => 1, 'yyy' => 0],
];
$count = 0;
$aList = [];
foreach($aData as $val){
foreach($val as $k => $v){
if($k == 'money'){
$count += $val['money'];
}elseif($k != 'mean' && $k != 'boss'){
$aList[$k][] = [
'out' => $v > 0 ? $val['money'] : 0, //表示自己付出的钱
'in' => $v < 0 ? $val['mean'] : 0, //表示自己要给分担的钱
'who' => $val['boss'],
];
}
}
}

$aData = [];
foreach($aList as $k => $v){
$in = $out = 0;
foreach($v as $key => $val){
$in += $val['in'];
$out += $val['out'];
}
$aData[$k] = [
'out' => $out,
'in' => $in,
];
}

结果是

这样还是不能知道到底谁付钱给谁。求教

...全文

350 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

咸鱼饭 2015-11-03

打赏
举报

嗯，非常感谢。你的思路给了我很大的帮助。

xuzuning 2015-11-03

打赏
举报

你可以一笔一笔的算

$aData = [
 ['money' => 30, 'mean'=> 10, 'twl' => 1, 'xxx' => -1, 'yyy' => -1],  
  ['money' => 30, 'mean'=> 10, 'twl' => -1, 'xxx' => -1, 'yyy' => 1], 
 ['money' => 10, 'mean'=> 5, 'twl' => -1, 'xxx' => 1, 'yyy' => 0],
 ['money' => 20, 'mean'=> 10, 'twl' => 0, 'xxx' => 1, 'yyy' => -1],
 ['money' => 20, 'mean'=> 10, 'twl' => 0, 'xxx' => 1, 'yyy' => -1],
 ['money' => 20, 'mean'=> 10, 'twl' => 0, 'xxx' => 1, 'yyy' => -1],
];
foreach($aData as $id=>$m) {
  $u = array_diff_key($m, ['money' => 0, 'mean' => 0]);
  arsort($u);
  foreach($u as $k=>$v) {
    if($v == 0) continue;
    if($v == 1) {
      $boss = $k;
      $r[$k][] = ['id' => $id, 'out' => $m['money']];
    }else {
      $r[$k][] = ['id' => $id, 'out' => $m['mean'], 'boss' => $boss];
      $r[$boss][] = ['id' => $id, 'in' => $m['mean'], 'boss' => $k];
    }
  }
}
print_r($r);

咸鱼饭 2015-11-02

打赏
举报

差不多是这样，假设 $aData = [ ['money' => 30, 'mean'=> 10, 'twl' => 1, 'xxx' => -1, 'yyy' => -1], ['money' => 30, 'mean'=> 10, 'twl' => -1, 'xxx' => -1, 'yyy' => 1], ['money' => 10, 'mean'=> 5, 'twl' => -1, 'xxx' => 1, 'yyy' => 0], ['money' => 20, 'mean'=> 10, 'twl' => 0, 'xxx' => 1, 'yyy' => -1], ['money' => 20, 'mean'=> 10, 'twl' => 0, 'xxx' => 1, 'yyy' => -1], ['money' => 20, 'mean'=> 10, 'twl' => 0, 'xxx' => 1, 'yyy' => -1], ]; 感觉算出来的数据又不太准了

咸鱼饭 2015-10-30

打赏
举报

其实我的意思是，要在数组里再添加什么元素来标记并计算每个人相互之间应该给出多少钱给谁

xuzuning 2015-10-30

打赏
举报

这个意思？

$aData = [
 ['money' => 30, 'mean'=> 10, 'twl' => 1, 'xxx' => -1, 'yyy' => -1],  
 ['money' => 10, 'mean'=> 5, 'twl' => -1, 'xxx' => 1, 'yyy' => 0],
];
foreach($aData as $m) {
  $u = array_diff_key($m, ['money' => 0, 'mean' => 0]);
  arsort($u);
  foreach($u as $k=>$v) {
    if(!isset($r[$k])) $r[$k] = ['out' => 0, 'in' => 0, 'boss' => []];
    if($v == 0) continue;
    if($v == 1) {
      $boss = $k;
      $r[$k]['out'] += $m['money'];
    }else {
      $r[$k]['out'] += $m['mean'];
      $r[$k]['boss'][] = $boss;
      $r[$boss]['in'] += $m['mean'];
    }
  }
}
print_r($r);

Array
(
    [twl] => Array
        (
            [out] => 35
            [in] => 20
            [boss] => Array
                (
                    [0] => xxx
                )

        )

    [yyy] => Array
        (
            [out] => 10
            [in] => 0
            [boss] => Array
                (
                    [0] => twl
                )

        )

    [xxx] => Array
        (
            [out] => 20
            [in] => 5
            [boss] => Array
                (
                    [0] => twl
                )

        )

)

码无边 2015-10-29

打赏
举报

思路：用户表，用户消费记录表具体统计什么项目，根据用户消费表的项目对应。 user表 user_id username password consumption表 id user_id 用户id consumption_type 消费类型：如：电费，买菜，坐车 money 金额 createtime 时间

xuzuning 2015-10-29