public function doreks()
{
define('PERSON_PER_PAGE', 20
);
$page = isset($_GET['page']) ?
intval($_GET['page']) : 1; $stan=NULL;
$tmp = $this->db->query("SELECT * FROM doreks WHERE stan='$stan' ORDER BY id ASC LIMIT " . ($page -1) * PERSON_PER_PAGE . ', ' . PERSON_PER_PAGE);
$r = $this->db->query("SELECT * FROM doreks WHERE stan='$stan'");
if (!$tmp->num_rows) {
return false;
}
while($row = mysqli_fetch_array($tmp)) {
if(isset($_GET['info']) && $_GET['info'] == 'usun.id'.$row['id'].''){
$id = $row['id'];
$this->db->query("DELETE FROM doreks WHERE id='$id'") ;
header('Location: ../CokPanel/dor-eks.php'); exit; }
if(isset($_GET['info']) && $_GET['info'] == 'zatwierdz.id'.$row['id'].''){
$id = $row['id'];
$osoba = $_POST['osoba'];
$doradca = $_POST['doradca'];
$ekspert = $_POST['ekspert'];
$data_przek = $_POST['data_przek'];
$termin_kon = $_POST['termin_kon'];
$tel = $_POST['tel'];
$mail = $_POST['mail'];
//$mail_kl= $_POST['mail_kl'];
//$zglosz = $_POST['zglosz'];
//$telcok = $_POST['telcok'];
//$koneks = $_POST['koneks'];
if(!empty($_POST['uwagi'])){ $uwagi = $row['uwagi'].' '.$_POST['uwagi'].'</br><i>'.date('h:i \ d-m-Y').'</i></br></br>'; }else{
$uwagi = $row['uwagi'];
}
$this->db->query("UPDATE doreks SET osoba='$osoba', doradca='$doradca', ekspert='$ekspert', data_przek='$data_przek', termin_kon='$termin_kon', tel='$tel', mail='$mail', mail_kl='$mail_kl', zglosz='$zglosz', telcok='$telcok', koneks='$koneks', uwagi='$uwagi' WHERE id='$id'") ;
//header('Location: ../CokPanel/dor-eks.php'); exit;
}
// Zakladanie kary klienta
if(isset($_GET['info']) && $_GET['info'] == 'karta.id'.$row['id'].''){ $id = $row['id'];
$this->db->query("UPDATE doreks SET stan='1' WHERE id='$id'");
header('Location: ../CokPanel/dor-eks.php'); exit; }
if(isset($_GET['info']) && $_GET['info'] == 'edytuj.id'.$row['id'].''){
if($row['mail_kl']==1){
$check1="checked";
}else{
$check1="";
}
if($row['telcok']==1){
$check2="checked";
}else{
$check2="";
}
if($row['koneks']==1){
$check3="checked";
}else{
$check3="";
}
if($row['zglosz']==1){
$check4="checked";
}else{
$check4="";
}
<script>
function alert() {
if(confirm("Czy napewno chcesz usunąć tego klienta?")){
window.location = "dor-eks.php?info=usun.id'.$row['id'].'";
}
else
{
window.location = "dor-eks.php?info=edytuj.id'.$row['id'].'";
}
}
function karta() {
if(confirm("Czy napewno chcesz zakończyć proces?")){
window.location = "dor-eks.php?info=karta.id'.$row['id'].'";
}
else
{
window.location = "dor-eks.php?info=edytuj.id'.$row['id'].'";
}
}
</script>
<form action="dor-eks.php?info=zatwierdz.id'.$row['id'].'" method="POST">
<div class="box-body">
<label for="osoba">Imię i Nazwisko:<input class="form-control" type="text" name="osoba" value="'.$row['osoba'].'" id="osoba" required></label>
<label for="doradca">Doradca:<input class="form-control" type="text" value="'.$row['doradca'].'" name="doradca" id="doradca"></label>
<label for="ekspert">Ekspert:<input class="form-control" type="text" value="'.$row['ekspert'].'" name="ekspert" id="ekspert"></label>
<label for="data_przek">Data Przekazania:<input class="form-control" type="data" value="'.$row['data_przek'].'" name="data_przek" id="data_przek"></label>
<label for="termin_kon">Termin Kontaktu:<input class="form-control" type="data" name="termin_kon" value="'.$row['termin_kon'].'" id="termin_kon" ></label>
<label for="tel">Telefon:<input class="form-control" type="text" name="tel" value="'.$row['tel'].'" id="tel" ></label>
<label for="mail">Mail:<input class="form-control" type="text" name="mail" id="mail" value="'.$row['mail'].'"> </label>
</br>
<span style="margin: 1.3%; color: green;" ><i class="fa fa-envelope" ></i></span>
<span style="margin: 1.2%; color: blue;" ><i class="fa fa-phone" ></i></span>
<span style="margin: 1.7%; color: purple;" ><i class="fa fa-phone-square" ></i></span>
<span style="margin: 0.9%; color: red;" ><i class="fa fa-exclamation-triangle" ></i></span>
</br>
<span style="margin: 1%;" ><input type="checkbox" name="mail_kl" value="1" class="flat-g" '.$check1.' /></span>
<span style="margin: 1%;" ><input type="checkbox" name="telcok" value="1" id="telcok" class="flat-g" '.$check2.'/></span>
<span style="margin: 1%;" ><input type="checkbox" name="koneks" value="1" id="koneks" class="flat-g" '.$check3.'/></span>
<span style="margin: 1%;" ><input type="checkbox" name="zglosz" value="1" id="zglosz" class="flat-g" '.$check4.'/></span>
</br></br>
<p>'.$row['uwagi'].'</p>
<label for="uwagi">Uwagi:</label>
<textarea class="form-control" name="uwagi" id="uwagi" rows="2" cols="50"></textarea>
</br>
<input class="btn btn-success" type="submit" value="Edytuj" />
<a class="btn btn-primary" onclick="karta()">Zamknij Proces</a>
<a class="btn btn-primary" href="dor-eks.php">Cofnij</a>
<a class="btn btn-danger" onclick="alert()">Usuń</a>
</div>
</from>
';
}
else
{
if($row['mail_kl'] == 1){
$atrybuty[]='<span style="margin: 4%; color: green;" ><i class="fa fa-envelope" ></i></span>';
}
if($row['telcok'] == 1){
$atrybuty[]='<span style="margin: 4%; color: blue;" ><i class="fa fa-phone" ></i></span>';
}
if($row['koneks'] == 1){
$atrybuty[]='<span style="margin: 4%; color: purple;" ><i class="fa fa-phone-square" ></i></span>';
}
if($row['zglosz'] == 1){
$atrybuty[]='<span style="margin: 4%; color: red;" ><i class="fa fa-exclamation-triangle" ></i></span>';
}
<tr>
<td>'.$row['osoba'].'</td>
<td>'.$row['doradca'].'</td>
<td>'.$row['ekspert'].'</td>
<td>'.$row['data_przek'].'</td>
<td>';
for ($i=0;$i<$n; $i++)
</td>
<td><a class="btn btn-primary" href="dor-eks.php?info=edytuj.id'.$row['id'].'#'.$row['id'].'">Wiecej</a></td>
</tr>
';
}
}
$articles = mysqli_num_rows($r);
$pages = ceil($articles / PERSON_PER_PAGE
);
<div class="box-tools">
<div class="box-tools pull-right">
<ul class="pagination pagination-sm inline">
';
if($pages > 1
&& $page != 1
) echo '<li><a href="dor-eks.php?page=' . (intval($page) - 1) . ' class="active"">«</a></li>'; // for($i = 1; $i <= $pages; $i++) echo '<li><a href="baza.php?page=' . $i . '">' . $i . '</a><li>';
echo '<li class="disabled"><a>'.$page.'</a></li>'; if($pages > 1
&& $page != $pages) echo '<li><a href="dor-eks.php?page=' . (intval($page) + 1) . '">»</a><li>'; </ul>
</div>
</div>';
}
Miałem też przypuszczenia że w momencie wysyłania/przekierowywania te checkboxy się odznaczają same ale nie wiem czy to wgl możliwe 