function JournalCount($year) {


  global $db,$ar;


  $sql6="update account set sel2=0";


  $res6=mysqli_query($db,$sql6);


  $sql3="SELECT * from action order by action_at,seq";


  $res3=mysqli_query($db,$sql3);


  while($r3=mysqli_fetch_assoc($res3)) {


      $udt3=array(


          'seq'=>$r3['seq'],


      );


      Update($db,"journal",$udt3,"action_id=".$r3['id'],0);


      Update($db,"transaction",$udt3,"action_id=".$r3['id'],0);


  }


  $sql="SELECT account_code from journal group by account_code";


  $res=mysqli_query($db,$sql);


  while($r1=mysqli_fetch_assoc($res)) {


    $sql2="SELECT * from journal where year=".$year." and account_code='".$r1['account_code']."' order by action_at asc, seq asc";


    //echo $sql2."<br>";


    $res2=mysqli_query($db,$sql2);


    $bal=0;


    $seq2=1;


    while($r2=mysqli_fetch_assoc($res2)) {


      $bal=$bal+$r2['debit']-$r2['credit'];


      $udt=array(


        'balance'=>$bal,


        'seq2'=>$seq2,


        'update_at'=>time(),


      );


      Update($db,"journal",$udt,"id=".$r2['id'],1);


      $seq2++;


    } 


    $udt4=array(


      'sel2'=>1,


    );


    Update($db,"account",$udt4,"code='".$r1['account_code']."'",0);  


  }  


}