Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function get_options($select){
- $types = array('Odebrane'=>2, 'Wysłane'=>3, 'Usunięte' =>4, 'Wszystkie'=>5);
- $options =' ';
- while(list($k, $v)=each($types)){
- if($select==$v){
- $options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
- }
- else{
- $options.='<option value=" '.$v.' "> ' .$k. ' </option>';
- }
- }
- return $options;
- }
- function get_optionsS($select){
- $types_s = array( 'Wysłane'=>3, 'Odebrane'=>2, 'Usunięte' =>4, 'Wszystkie'=>5);
- $options =' ';
- while(list($k, $v)=each($types_s)){
- if($select==$v){
- $options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
- }
- else{
- $options.='<option value=" '.$v.' "> ' .$k. ' </option>';
- }
- }
- return $options;
- }
- function get_optionsA($select){
- $types_a = array('Wszystkie'=>5, 'Odebrane'=>2, 'Wysłane'=>3, 'Usunięte' =>4);
- $options =' ';
- while(list($k, $v)=each($types_a)){
- if($select==$v){
- $options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
- }
- else{
- $options.='<option value=" '.$v.' "> ' .$k. ' </option>';
- }
- }
- return $options;
- }
- function get_optionsT($select){
- $types_t = array('Usunięte' =>4,'Odebrane'=>2, 'Wysłane'=>3, 'Wszystkie'=>5);
- $options =' ';
- while(list($k, $v)=each($types_t)){
- if($select==$v){
- $options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
- }
- else{
- $options.='<option value=" '.$v.' "> ' .$k. ' </option>';
- }
- }
- return $options;
- }
- function get_options2($select){
- $types2 = array('Sortuj po'=>6, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco'=>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco'=>14);
- $options =' ';
- while(list($k, $v)=each($types2)){
- if($select==$v){
- $options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
- }
- else{
- $options.='<option value=" '.$v.' "> ' .$k. ' </option>';
- }
- }
- return $options;
- }
- ?>
- <div id="mpri-form">
- Tutaj możesz wysyłać wiadomości do innych pracowników lub właściciela - UWAGA! Tylko w obrębie Twojego obiektu noclegowego!.
- <form method="post">
- <p>
- <div id="mmsg-form1">Do:<input type="text" name="for" size="60" placeholder = "Podaj nazwę użytkownika odbiorcy"></input></div>
- <div id="mmsg-form2">Od:<input type ="text" name="from" cols="60" rows ="1" value = "<?php echo $from; ?>" readonly></input></div>
- <div id="mmsg-form3">Temat:<input type ="text" name="subject" cols="60" rows ="1" placeholder="Podaj temat wiadomości" ></input></div>
- <div id="mmsg-form4">Treść:<textarea name="content" cols="90" rows="6" placeholder="Treść wiadomości"></textarea></div>
- <div id="mmsg-form7"><input class="btn btn-primary" type="submit" value="Wyślij wiadomość" name="postsave"></div><br></p></form>
- <div id="span_msg"><span class="error"><?php echo $error;?></span></div></div>
- <table name="table" border="1" style="color:#1c4e93; position:relative; top:-120px; ">
- <thead>
- <th class = "th"><input type="hidden" name="id" value="id" /><input type="button" value="ID" name="id_user" class="btn btn-default btn-warning"></th>
- <th class = "th"><input type="hidden" name="to" value="to" /><input type="button" value="Do" name="uto" class="btn btn-default btn-warning" style="width: 222px;"></th>
- <th class = "th"><input type="hidden" name="from" value="from" /><input type="submit" value="Nadawca" name="ufor" class="btn btn-default btn-warning" style="width: 222px;"></th>
- <th class = "th"><input type="hidden" name="title" value="title" /><input type="button" value="Tytuł" name="utit" class="btn btn-default btn-warning" style="width: 222px;"></th>
- <th class = "th"><input type="hidden" name="content" value="content" /><input type="button" value="Treść wiadomości" name="ucon" class="btn btn-default btn-warning" style="width: 222px;" ></th>
- <th class = "th"><input type="hidden" name="date" value="date" /><input type="button" value="Data" name="urdat" class="btn btn-default btn-warning" style="width: 222px;" ></th>
- <th class = "th" width="120px;"><div style = "width: 120px;">Opcje</div></th>
- </tr>
- </thead>
- <tbody>
- <?php
- function show($query_disp){
- include ('/var/www/vhosts/solaris-ustronie.eu/httpdocs/joomla/administrator/modules/mod_activate/db_joomla.php');
- /* $user = JFactory::getUser();
- $id = $user->id;
- $query_disp="SELECT * FROM jos_program_prices WHERE id_owner= '$id'"; */
- //$query_d=$query_disp;
- $table ="jos_program_prices";
- $id_col="id";
- $error = $query_disp;
- $resultSet = mysql_query($query_disp, $con);
- ?>
- <div id="mmsg-form5">Pokaż tylko wiadomości:</div>
- <div id="mmsg-form14">Sortuj po:</div>
- <div id ="mmsg-form6">
- <form method ="post">
- <select name = "types" onchange = "this.form.submit();"> <?php echo get_options($selected); ?> </select>
- </form></div>
- <div id ="mmsg-form10">
- <form method ="post">
- <select name = "types2" onchange = "this.form.submit();"> <?php echo get_options2($selected); ?> </select>
- </form></div>
- <?php
- //ini_set('max_execution_time', 300);
- while($row = mysql_fetch_array($resultSet)) {
- $id= $row['id'];
- $type= $row['to_user'];
- $pricefor=$row['from_user'];
- $range =$row['title'];
- $room =$row['content'];
- $price =$row['date'];
- ?>
- <tr>
- <td class="container" width = "40px;"><center><?php echo $row['id'];?></td>
- <td class="container" ><div><input type="text" name="type" size="40;" line-height="0px" value="<?php echo $row['to_user'];?>"></input></div></td>
- <td class="container"><div class="td_div"><input type="text" name="price_for" size="40" line-height="0px" value="<?php echo $row['from_user'];?>"></input></div></td>
- <td class="container"><div><input type="text" name="range" size="40" line-height="0px" value="<?php echo $row['title'];?>"></input></div></td>
- <td class="container"><div><input type="text" name="room_type" size="40" line-height="0px" value="<?php echo $row['content'];?>"></input></div></td>
- <td class="container"><div><input type="text" name="price" size="40" line-height="0px" value="<?php echo $row['date'];?>"></input></div></td>
- <td class="container">
- <div> <input type="hidden" name="id" value="<?php echo $id; ?> " /></div>
- <div><input type="hidden" name="table" value="<?php echo $table; ?> " /></div>
- <div class="opt_btnu"> <input type="button" value="Do kosza" class="btn btn-primary" style="width: 58px;" onClick="location.href='https://www.solaris-ustronie.eu/joomla/administrator/modules/mod_activate/trash_messages.php?param=<?php echo $table;?>,<?php echo $id_col;?>,<?php echo $id;?>'"></div>
- </td>
- </tr>
- <?php } mysql_close();}
- $trash=1;
- $back =0;
- $query12="SELECT * FROM jos_program_messages WHERE owner= '$parent' AND ((to_user = '$login' AND trash_to= '$back') OR (from_user = '$login' AND trash_from = '$back')) ORDER BY date DESC"; //wszystkie
- $query0="SELECT * FROM jos_program_messages WHERE owner= '$parent' AND (to_user = '$login' AND trash_to= '$back') ORDER BY date DESC"; // odebrane
- $query13="SELECT * FROM jos_program_messages WHERE owner= '$parent' AND (from_user = '$login' AND trash_from= '$back') ORDER BY date DESC"; // wysłane
- $query7="SELECT * FROM jos_program_messages WHERE owner= '$parent' AND ((to_user = '$login' AND trash_to = '$trash') OR (from_user = '$login' AND trash_from = '$trash')) ORDER BY date DESC"; //usunięte
- $query10 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY id DESC";
- $query11 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY id ASC";
- $query14 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY date DESC";
- $query15 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY date ASC";
- $query16 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY from_user DESC";
- $query17 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY from_user ASC";
- $query18 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY title DESC";
- $query19 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY title ASC";
- if(isset($_POST['types']) || isset($_POST['types_a']) || isset($_POST['types_s']) || isset($_POST['types_t']) || isset($_POST['types2']) || isset($_POST['types3']) || isset($_POST['types4']) || isset($_POST['types5'])){
- if(isset($_POST['types'])){
- $selected = $_POST['types'];
- //$error = $selected;
- $o = 2;
- $w = 3;
- $u = 4;
- $ws = 5;
- if($selected == $w){
- $error= $selected;
- $query_disp=$query13;
- showSend($query_disp);
- }
- if($selected == $o){
- $error = $selected;
- $query_disp=$query0;
- show($query_disp);
- }
- if($selected == $u){
- $error = $selected;
- $query_disp=$query7;
- showTrash($query_disp);
- }
- if($selected == $ws){
- $error = $selected;
- $query_disp=$query12;
- showAll($query_disp);
- }
- }
- if(isset($_POST['types_a'])){
- $selected = $_POST['types_a'];
- //$error = $selected;
- $o = 2;
- $w = 3;
- $u = 4;
- $ws = 5;
- if($selected == $w){
- $error= $selected;
- $query_disp=$query13;
- showSend($query_disp);
- }
- if($selected == $o){
- $error = $selected;
- $query_disp=$query0;
- show($query_disp);
- }
- if($selected == $u){
- $error = $selected;
- $query_disp=$query7;
- showTrash($query_disp);
- }
- if($selected == $ws){
- $error = $selected;
- $query_disp=$query12;
- showAll($query_disp);
- }
- }
- if(isset($_POST['types_s'])){
- $selected = $_POST['types_s'];
- //$error = $selected;
- $o = 2;
- $w = 3;
- $u = 4;
- $ws = 5;
- if($selected == $w){
- $error= $selected;
- $query_disp=$query13;
- showSend($query_disp);
- }
- if($selected == $o){
- $error = $selected;
- $query_disp=$query0;
- show($query_disp);
- }
- if($selected == $u){
- $error = $selected;
- $query_disp=$query7;
- showTrash($query_disp);
- }
- if($selected == $ws){
- $error = $selected;
- $query_disp=$query12;
- showAll($query_disp);
- }
- }
- if(isset($_POST['types_t'])){
- $selected = $_POST['types_t'];
- //$error = $selected;
- $o = 2;
- $w = 3;
- $u = 4;
- $ws = 5;
- if($selected == $w){
- $error= $selected;
- $query_disp=$query13;
- showSend($query_disp);
- }
- if($selected == $o){
- $error = $selected;
- $query_disp=$query0;
- show($query_disp);
- }
- if($selected == $u){
- $error = $selected;
- $query_disp=$query7;
- showTrash($query_disp);
- }
- if($selected == $ws){
- $error = $selected;
- $query_disp=$query12;
- showAll($query_disp);
- }
- }
- if(isset($_POST['types2'])){
- $selected = $_POST['types2'];
- $error = $selected;
- $o7 = 7;
- $w = 3;
- $u = 4;
- $ws = 5;
- if($selected == $o7){
- //$error= $selected;
- $query_disp=$query11;
- show($query_disp);
- // $types2 = array('ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
- }
- if($selected == 8){
- $error = $selected;
- $query_disp=$query10;
- show($query_disp);
- $types2 = array( 'ID malejąco'=>8, 'ID rosnąco'=>7, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
- }
- if($selected == 9){
- $error = $selected;
- $query_disp=$query17;
- showTrash($query_disp);
- $types2 = array('Nadawca rosnąco' =>9, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
- }
- if($selected == 10){
- $error = $selected;
- $query_disp=$query16;
- show($query_disp);
- $types2 = array('Nadawca malejąco'=>10, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
- }
- if($selected == 11){
- $error = $selected;
- $query_disp=$query15;
- show($query_disp);
- $types2 = array( 'Od najnowszych'=>11, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
- }
- if($selected == 12){
- $error = $selected;
- $query_disp=$query14;
- show($query_disp);
- $types2 = array('Od najstarszych'=>12, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
- }
- if($selected == 13){
- $error = $selected;
- $query_disp=$query19;
- show($query_disp);
- $types2 = array('Tytuł rosnąco'=>13,'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł malejąco' =>14 );
- }
- if($selected == 14){
- $error = $selected;
- $query_disp=$query18;
- show($query_disp);
- $types2 = array('Tytuł malejąco' =>14, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13 );
- }
- }
- }
- else
- {
- $query_disp=$query0;
- show($query_disp);
- }
- ?>
- </tbody>
- </table>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement