Ejemplo n.º 1
0
     $i = 1;
     while ($row = mysql_fetch_assoc($result)) {
         if (!isset($customer)) {
             $customer = $row['customers_id'];
         }
         if ($customer == $row['customers_id'] and $i != 1) {
             echo "<tr>";
             echo "<td class=\"text-center\"><a id=\"" . $i . "\">" . $i . "</a></td>";
             echo "<td class=\"text-center\"> </td>";
             echo "<td class=\"text-center\"><span class=\"fa fa-mobile\"></span> " . $row['nr_tel'] . "</td>";
             echo "<td class=\"text-center\">" . $row['data_zawarcia'] . "</td>";
             echo "<tr>";
         } else {
             $customer = $row['customers_id'];
             echo "<tr>";
             echo "<td colspan=\"4\"><h4><a href=\"profil.php?id=" . $row['customers_id'] . "\"><b>" . who_is_name($row['customers_id']) . "</b></a> " . who_is_number($row['customers_id']) . " <span class=\"badge\">" . how_many_number($row['customers_id']) . "</span></h4></td>";
             echo "</tr>";
             echo "<tr>";
             echo "<td class=\"text-center\"><a id=\"" . $i . "\">" . $i . "</a></td>";
             echo "<td class=\"text-center\"> </td>";
             echo "<td class=\"text-center\"><span class=\"fa fa-mobile\"></span> " . $row['nr_tel'] . "</td>";
             echo "<td class=\"text-center\">" . $row['data_zawarcia'] . "</td>";
             echo "<tr>";
         }
         $i++;
     }
     ?>
               </tbody>
            </table>
         <?php 
 } else {
Ejemplo n.º 2
0
      if (!isset($_POST['InputNrTel'])) {
          $_POST['InputNrTel'] = "";
      }
      $dlugosc = strlen($_POST['InputNrTel']);
      if ($dlugosc == 9) {
          $result = mysql_query("SELECT id, customers_id, nr_tel, data_zawarcia FROM tabela_um_an WHERE nr_tel = '" . $_POST['InputNrTel'] . "' AND  typ_uslugi = 'KUD' AND salon = '" . $_SESSION['salon'] . "';") or die(mysql_error());
      } else {
          $result = mysql_query("SELECT id, customers_id, nr_tel, data_zawarcia FROM tabela_um_an WHERE data_zawarcia >= '" . $_POST['InputDateFrom'] . "' AND data_zawarcia <= '" . $_POST['InputDateTo'] . "' AND  typ_uslugi = 'KUD' AND salon = '" . $_SESSION['salon'] . "';") or die(mysql_error());
      }
      if ($result) {
          $i = 1;
          while ($row = mysql_fetch_assoc($result)) {
              echo "<tr>";
              echo "<td>{$i}</td>";
              echo "<td><a href=\"profil.php?id=" . $row['customers_id'] . "\">" . who_is_name($row['customers_id']) . "</a></td>";
              echo "<td class=\"text-center\">" . who_is_number($row['customers_id']) . "</td>";
              echo "<td>" . $row['nr_tel'] . "</td>";
              echo "<td>" . $row['data_zawarcia'] . "</td>";
              echo "<td><a href=\"profil.php?id=" . $row['customers_id'] . "\" class=\"btn btn-info btn-xs\"><span class=\"glyphicon glyphicon-wrench\"></span> Opcje</a></td>";
              echo "</tr>";
              $i++;
          }
      }
      ?>
                   </tbody>
                </table>
             <?php 
  }
  ?>
    </div>
 </div>