<? include('menu_promocje_com.php'); ?>

<b>WYSZUKIWARKA PRODUKTU</b><br><br>

<form action="doznajdz_promocje_com.php" method="post">
Data od (>=):<br />
<input type="text" name="data_od" /><br />
Data do (<=):<br />
<input type="text" name="data_do" /><br />
Kwota od (>=):<br />
<input type="text" name="kwota_od" /><br />
Kwota do (<):<br />
<input type="text" name="kwota_do" /><br />

<input type="submit" value="szukaj" />
</form>

</center>
</html>

<? include('menu_promocje_com.php');


mysql_select_db("nazwa_bazy");

$data_od = $_POST['data_od'];
$data_do = $_POST['data_do'];
$kwota_od = $_POST['kwota_od'];
$kwota_do = $_POST['kwota_do'];

$query = "select * from orders where (order_date >= '$data_od' and order_date <= '$data_do' and order_sum >= '$kwota_od' and order_sum < '$kwota_do') order by order_date asc";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
    
print "<p>Ilo¶ć znalezionych klientów do promocji: ".$num_results."</p>";
        print ("<font size=2 color=yellow>Nr zam.| Nr Kl. | Imię | Nazwisko | Data zam. | Warto¶ć zam. | Notka | </font><BR>");

for ($i=0; $i <$num_results; $i++)  {
        $row = mysql_fetch_array($result);
        
        print ("<font size=2>| ");
        print stripslashes($row["order_id"]);
        print (" | ");
        print stripslashes($row["user_id"]);
        print (" | ");
        print stripslashes($row["bill_firstname"]);
        print (" | ");
        print stripslashes($row["bill_lastname"]);
        print (" | ");
        print stripslashes($row["order_date"]);
        print (" | ");
        print stripslashes($row["order_sum"]);
        print (" zł | ");
        print stripslashes($row["notes_pub"]);
        print " |</font></font><br>";

}
?>
<hr width="75%" align="CENTER" size="2" color="white">

<form action="promocja_dodana_com.php" method="post">
Tekst promocji dla wybranych wyżej klientów:<br />
<input type="text" name="promocja" size="100" /><br />
<input type="submit" value="DODAJ PROMOCJE" />
</form>

</center>
</html>

<? include('menu_promocje_com.php');

mysql_select_db("nazwa_bazy");

$promocja = $_POST['promocja'];

$query = "select * from orders where (order_date >= '$data_od' and order_date <= '$data_do' and order_sum >= '$kwota_od' and order_sum < '$kwota_do') order by order_date asc";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

for ($i=0; $i <$num_results; $i++)  {

$row = mysql_fetch_array($result);

$query2="update orders set notes_pub='$promocja' WHERE order_id='$row['order_id']'";
}
echo 'Promocja została dopisana';


?>

<hr width="75%" align="CENTER" size="2" color="white">

</center>
</html>

$data_od = $_POST['data_od'];
$data_do = $_POST['data_do'];
$kwota_od = $_POST['kwota_od'];
$kwota_do = $_POST['kwota_do'];

$promocja = $_POST['promocja'];

<? include('menu_promocje_com.php');

mysql_select_db("baza1258_s_kont");

$data_od = $_POST['data_od'];
$data_do = $_POST['data_do'];
$kwota_od = $_POST['kwota_od'];
$kwota_do = $_POST['kwota_do'];
$promocja = $_POST['promocja'];

$query2="update orders set notes_pub='$promocja' where (order_date >= '$data_od' and order_date <= '$data_do' and order_sum >= '$kwota_od' and order_sum < '$kwota_do')";
echo 'Promocja została dopisana';


?>

<hr width="75%" align="CENTER" size="2" color="white">

</center>
</html>