Notes

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);


ob_start();
require_once('config_php.php');

if(!isset($_SESSION['logat'])) $_SESSION['logat'] = 'Nu';
if($_SESSION['logat'] != 'Da')
{
echo '<script> alert("Nu sunteti logat !");
window.location.href="../index.php";
</script>';

}
else
{
?>
<div class="container pt-2">
<h2 class="py-2">Formular de casa : </h2>
<form class="form-horizontal " name="formular" action="salvati_raport_de_casa.php" method="post">
<div class="form-group row">
<label class="control-label col-sm-2" for="u1"> Zi : </label>
<div class="col-sm-4">
<input class="form-control" type="date" name="date" id="u1" value="<?php echo date("Y-m-d");?>" required>
</div>

<div class="form-group row">
<div class="col-sm-offset-2 col-sm-10">
<button name="update" type="submit" value="Trimite" class="btn btn-primary">Vizualizati</button>
</div>
</div>

</div>
</form>
</div>

<?php
if(isset($_POST['update'])) {
//funcita aici

$today = $_POST['date'];
$tomw = $tomorrow = date("Y-m-d",strtotime($today . "+1 days"));
//echo $tomw;
$now = date("y-m-d");
$index = 1;
$total2 =0;
$total= 0 ;
$total3 = 0;
$total4 =0;
$k=1;
$sql = "SELECT * FROM Incasari where reg_date >='$now' ORDER BY id ASC ";
$export = $conn->query($sql);
while($row = mysqli_fetch_array($export)) {

if($row['bani'] > 0 and ($k==0)){
$total4 = $total4 - $row['bani'];
// echo $row['bani']. " " ;
}
if($row['bani'] < 0 and ($k==0)){
$total4 = $total4 - $row['bani'];
//echo $row['bani'] ." s";
// echo "aifiudshf";
}
if($k){
$total3= $row['bani'];
$k--;
$total4= $row['bani'];
}
}





?>
<div class="container pt-5">
<h2>Registru de casa :</h2>
<table class="raport-table my-5">
<tr>
<td></td>
<td></td>
<td>Registru de casa</td>
<td></td>
<td></td>
<td></td>
<td>Cont casa</td>
</tr>
<tr>
<td></td>
<td></td>
<td><?php echo date("Y-m-d"); ?></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>d</td>
<td>c</td>
</tr>
<tr>
<td>Nr crt</td>
<td>Data</td>
<td>Nr. act casa</td>
<td></td>
<td>Explicatii</td>
<td>Incasari</td>
<td>Plati</td>
</tr>
<tr>
<td colspan="5"> <center><?php echo " sold initial".date("Y-m-d"); ?></center></td>
<td><?php echo $total4; ?></td>
<td></td>
</tr>
<?php
$sql = "SELECT * FROM foi_raport where data >= '$today' and data <'$tomw'";
$export = $conn->query($sql);
while($row = mysqli_fetch_array($export)) {
echo '<tr>';
echo '<td>'.$index.'</td>';
echo '<td>'.$row['data'].'</td>';
echo '<td>'.$row['nr_bon'].'</td>';
echo '<td>'.'</td>';
echo '<td>'.$row['explicatii'].'</td>';
echo '<td>'.'</td>';
echo '<td>'.$row['plati'].'</td>';
$total = $total + $row['plati'] ;
echo '</tr>';
$index ++;
}

$sql = "SELECT * FROM Incasari where reg_date > '$today' and reg_date < '$tomw' and id<>1 ";

$export = $conn->query($sql);
$k=1;
while($row = mysqli_fetch_array($export)) {
// echo $row['bani'];
if($row['bani'] > 0){

echo '<tr>';
echo '<td>'.$index.'</td>';
echo '<td>'.date('Y-m-d',strtotime($row['reg_date'])).'</td>';
echo '<td>'.'Introducere numerar'.'</td>';
echo '<td>'.'</td>';
echo '<td>'.'</td>';
echo '<td>'.$row['bani'].'</td>';
$total2 = $total2 + $row['bani'];
echo '<td>'.'</td>';
echo '</tr>';
$index ++;
}
else{

}
}
?>
<tr>
<td colspan="5"><center>Total</center></td>
<td><?php echo $total4 + $total2; ?></td>
<td><?php echo $total; ?></td>
</tr>
<tr>
<td colspan="5"><center><?php echo " Sold total".date("Y-m-d"); ?></center></td>
<td><?php echo $total4 + $total2 -$total; ?></td>
<td></td>
</tr>
<tr>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>

</tr>
<tr>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
</tr>
<tr>
<td colspan="3">numele si prenumele membrilor de comisie de receptie</td>
<td>semnatura</td>
<td>numele si prenumele gestionarului</td>
<td colspan="2"><center>Semnatura</center></td>
</tr>
<tr>
<td colspan="3"> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
</tr>
<tr>
<td colspan="3"> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
<td> &nbsp </td>
</tr>
</table>
<button class="btn btn-primary" id="butonas" onclick="printpage()">Print this page</button>

</div>
<?php
} //if post
}// if logat
?>