<?PHP
if($_SESSION['user']){
}
else{
}
$username = $_SESSION['user'];
$class = $_SESSION['class'];
require 'home.php';
?>
<html>
<head>
<title><?=$config['title']?></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
</head>
<body>
<table border="2" align="center">
<tr>
<td align="center" >id</td>
<td align="center">Номер документа</td>
<td align="center">Номер договора</td>
<td align="center">Имя клиента</td>
<td align="center">Основание</td>
<td align="center" size="5">Приход</td>
<td align="center" size="5">Расход</td>
<td align="center">Тело кредита</td>
<td align="center">%</td>
<td align="center">Штраф</td>
<td align="center">НУ</td>
<form method="POST">
<td align="center"><input type="date" name="needdate" value="<?php echo $_POST['needdate']?>"/></td> <!--ввожу нужную переменную-->
<td align="center"><input type="submit" name="ondate" value="На дату"/></th> <!--кнопка после которой начинаеться обработка-->
</form>
<td></td>
<td align="center">ФИО кассира</td>
<td align="center">Название офиса</td>
</tr>
<?php // остановился тут !!!
if(isset($_POST['ondate'])) //условия о кнопки если она нажата {
$needdate = trim($_POST['needdate']); // приравниваяю данные из переменной print_r('переменная 1 : '. $_POST['needdate']); // вывожу для себя визуально переменную переменная 1 $needdate $where = !empty($needdate) ? "AND `date` = '" . $needdate . "'" : ''; //формирую дополнение к запросу sql где таблице ищю столбец с заголовком `cratedate` и в нем пытаюсь найти полученную переменную '$needdate' print_r(' переменная 2 : '.$where); // вывожу визуально для себя этот запрос переменная 2 $where $result = mysqli_query($connection, "SELECT kassa.id, kassa.numberdocument, kassa.numberagreement, kassa.nameofclient, kassa.base, kassa.coming, kassa.consumption, kassa.bodyloan, kassa.interest, kassa.fine, kassa.well, kassa.date, kassa.idofoffice, kassa.idofuser, kassa.dateofpost, users.user, office.nameofoffice FROM kassa INNER JOIN users ON users.id = kassa.idofuser INNER JOIN office ON office.idofoffice = kassa.idofoffice WHERE office.idofoffice = $class " . $where . " "); //запрос на вывод данных из таблицы $sum4 += $row['coming'];
$sum5 += $row['consumption'];
$sum6 += $row['bodyloan'];
$sum7 += $row['interest'];
$sum8 += $row['fine'];
$sum9 += $row['well'];
Print '<tr>';
Print '<td align="center">'. $row['id'] . "</td>";
Print '<td align="center">'. $row['numberdocument'] . "</td>";
Print '<td align="center">'. $row['numberagreement'] . "</td>";
Print '<td align="center">'. $row['nameofclient'] . "</td>";
Print '<td align="center" size="5">'. $row['base'] . "</td>";
Print '<td align="center" size="5">'. $row['coming'] . "</td>";
Print '<td align="center">'. $row['consumption'] . "</td>";
Print '<td align="center">'. $row['bodyloan'] . "</td>";
Print '<td align="center">'. $row['interest'] . "</td>";
Print '<td align="center">'. $row['fine'] . "</td>";
Print '<td align="center">'. $row['well'] . "</td>";
Print '<td align="center">'. $row['date'] . "</td>";
Print '<td align="center"><a href="editkassa.php?id='. $row['id'] .'">edit</a> </td>';
Print '<td align="center"><a href="#" onclick="myFunction('.$row['id'].')">delete</a> </td>';
Print '<td align="center">'. $row['user'] . "</td>";
Print '<td align="center">'. $row['nameofoffice'] . "</td>";
Print '</tr>';
endwhile;
}
else {
$result = mysqli_query($connection, "SELECT kassa.id, kassa.numberdocument, kassa.numberagreement, kassa.nameofclient, kassa.base, kassa.coming, kassa.consumption, kassa.bodyloan, kassa.interest, kassa.fine, kassa.well, kassa.date, kassa.idofoffice, kassa.idofuser, kassa.dateofpost, users.user, office.nameofoffice FROM kassa INNER JOIN users ON users.id = kassa.idofuser INNER JOIN office ON office.idofoffice = kassa.idofoffice WHERE office.idofoffice = $class "); $sum4 += $row['coming'];
$sum5 += $row['consumption'];
$sum6 += $row['bodyloan'];
$sum7 += $row['interest'];
$sum8 += $row['fine'];
$sum9 += $row['well'];
Print '<tr>';
Print '<td align="center">'. $row['id'] . "</td>";
Print '<td align="center">'. $row['numberdocument'] . "</td>";
Print '<td align="center">'. $row['numberagreement'] . "</td>";
Print '<td align="center">'. $row['nameofclient'] . "</td>";
Print '<td align="center" size="5">'. $row['base'] . "</td>";
Print '<td align="center" size="5">'. $row['coming'] . "</td>";
Print '<td align="center">'. $row['consumption'] . "</td>";
Print '<td align="center">'. $row['bodyloan'] . "</td>";
Print '<td align="center">'. $row['interest'] . "</td>";
Print '<td align="center">'. $row['fine'] . "</td>";
Print '<td align="center">'. $row['well'] . "</td>";
Print '<td align="center">'. $row['date'] . "</td>";
Print '<td align="center"><a href="editkassa.php?id='. $row['id'] .'">edit</a> </td>';
Print '<td align="center"><a href="#" onclick="myFunction('.$row['id'].')">delete</a> </td>';
Print '<td align="center">'. $row['user'] . "</td>";
Print '<td align="center">'. $row['nameofoffice'] . "</td>";
Print '</tr>';
endwhile;
}
?>
<form method="POST" action="/addkassa.php">
<tr>
<th>#</th>
<th><input type="text" name="numberdocument" size="5" value="<?=$numberdocument?>"/><br/></th>
<th><input type="text" name="numberagreement" step="1" size="15" value="<?=$numberagreement?>"/><br/></th>
<th><input type="text" name="nameofclient" step="1" value="<?=$nameofclient?>"/><br/></th>
<th><select>
<option name="base" value="<?=$row['idofbase']?>"><?=$row['nameofbase']?></option>
<? endwhile?>
</select></th>
<!--<input type="text" name="base" size="5" step="1" required="1" value="<?=$base?>"/><br/>-->
<th><input type="number" name="coming" size="5" step="1" value="<?=$coming?>"/><br/></th>
<th><input type="number" name="consumption" step="1" value="<?=$consumption?>"/><br/></th>
<th><input type="number" name="bodyloan" step="1" value="<?=$bodyloan?>"/><br/></th>
<th><input type="number" name="interest" step="1" value="<?=$interest?>"/><br/></th>
<th><input type="number" name="fine" step="1" value="<?=$fine?>"/><br/></th>
<th><input type="number" name="well" step="1" value="<?=$well?>"/><br/></th>
<th><input type="date" name="date" size="5" value="<?php echo($curedate);?>"/><br/></th>
<th><input type="submit" name="add" value="Добавить"/></th>
</tr>
</form>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td>Cуммма:</td>
<td><?=$sum4?></td>
<td><?=$sum5?></td>
<td><?=$sum6?></td>
<td><?=$sum7?></td>
<td><?=$sum8?></td>
<td><?=$sum9?></td>
<td></td>
</tr>
</table>
<script>
function myFunction(id)
{
var r=confirm("Удалить?");
if (r==true)
{
window.location.assign("deletekassa.php?id=" + id);
}
}
</script>
</body>
</html>