[JavaScript][PHP]Kalendarz rezerwacji - Ajax Calendar Opcje

[casperii]

Panowie mam kalendarz rezerwacji nie swojego autorstwa:
Rezerwacja poszczególnego dnia wygląda w htmlu tak:

dla nie potwierdzonej rezerwacji:

[HTML] pobierz, plaintext 
<li class="booked_pr" id="date_2017-09-03" title="03/09/2017 - Niepotwierdzone" data-date="3/09/2017" style="cursor: pointer;">3</li>
[HTML] pobierz, plaintext 

dla potwierdzonej rezewacji:

[HTML] pobierz, plaintext 
<li class="booked" id="date_2017-09-03" title="03/09/2017 - Rezerwacja" data-date="3/09/2017" style="cursor: pointer;">3</li>
[HTML] pobierz, plaintext 

dla wolnego dnia:

[HTML] pobierz, plaintext 
<li class="" id="date_2017-09-03" title="03/09/2017 - Wolne" data-date="3/09/2017" style="cursor: pointer;">3</li>
[HTML] pobierz, plaintext 

tak wygląda baza:
id |desc_pl | code | state| list_order |class |show_in_key
4 | Niepotwierdzone | pr | 1 | 0 |booked_pr | 1
1 | Rezerwacja | b | 1 | 1 |booked | 1

Po kliknięciu w poszczególny dzień poprzez ajax getem jest wykonywana komenda:
update_calendar.ajax.php?id_item=2&the_date=2017-09-04&lang=pl&id_state=

tylko, że zawsze po kliknięciu nie chwyta id_state i zawsze updatuje pierwszy z bazy czyli id_state=4,
doszedłem do tego ,że za ten błąd odpowiada JS:

[HTML] pobierz, plaintext 
function update_calendar(el,date_num){
	var el=document.id(''+el.id+'');
	var id_pre_state="";
 
	if(document.id('id_predefined_state')){
		id_pre_state=$('id_predefined_state').get('value');
	}
 
	var req = new Request({
		method: 'get',
		url: url_ajax_update,
		data: {
			'id_item':id_item,
			'the_date':el.id.replace("date_",""),
			'lang':lang,
			'id_state':id_pre_state
		},
		evalScripts:true,
		onRequest: function() { 
			//	loading image				
		},
		onSuccess: function(response) {
			//	split response to get class,date and desc
			tmp=response.split('|');
 
			//	add returned class
			el.addClass(tmp[0]);			
 
			//	change title to reflect new state
			el_title=el.getProperty('title');
			new_title=tmp[1]+" - "+tmp[2];
			el.setProperty('title',new_title);
 
			//	show message
			if(show_message)	new_msg(tmp[1]+" "+tmp[2]);
		}
	}).send();
}
 
[HTML] pobierz, plaintext 

tylko skąd się to ma brać: id_predefined_state ? przecież w kodzie html nie ma tego , przypominam, że skrypt nie jest mojego autorstwa.

[casperii]

id_item to numer oferty, ja potrzebuje id_state (czyli nazwa rezerwacja / nie potwierdzona)

Nie rozumiem co robię, źle jeśli mam zwykłe mysql_query jest ok, jeśli zastąpie to pdo to tylko 1 pobiera:


działa mysql_query:

[PHP] pobierz, plaintext 
 if(!$db_lnk = mysql_connect($db_host,$db_user,$db_pass))
  {
    echo("Nie udało się nawiązać połączenia z serwerem MySQL!<br/>");
    exit;
  };
 
  if(!mysql_select_db("$db_base"))
  {
    echo("Baza danych niedostępna!<br/>");
    exit;
  };
 
$the_date	=	$_GET["the_date"];
$id_item	=	$_GET["id_item"];
 
 
if( ($_REQUEST["id_item"]=="") || ($_REQUEST["the_date"]=="")){
die("Error");
}
 
$list_states=array();
 
$sql="SELECT * FROM bookings_states WHERE state=1 ORDER BY list_order ASC";
$res=mysql_query($sql) or die("Error getting states");
while($row=mysql_fetch_assoc($res)){
	$list_states[$row["id"]]=array("class"=>"".$row["class"]."","desc"=>"".$row["desc_pl"]."");
}
 
if($_GET["id_state"]=="Wolne"){
	$update="DELETE FROM bookings WHERE id_item='".$id_item."' AND the_date='".$the_date."' LIMIT 1";
	$new_class="";
	$new_desc	=$lang["available"];
}else{
	$sql="SELECT id_state FROM bookings WHERE id_item='".$id_item."' AND the_date='".$the_date."'";
	$res=mysql_query($sql);
	if(mysql_num_rows($res)==0){
 
		if($_GET["id_state"]!="")	$new_state	=	$_GET["id_state"];
		else 						$new_state	=	key($list_states);
		if($debug) echo "<br>New state first key ".$new_state;
		$new_desc	=	$list_states[$new_state]["desc"];
		$new_class	=	$list_states[$new_state]["class"];
		$update		=	"INSERT INTO bookings SET id_item='".$id_item."',the_date='".$the_date."', id_state='".$new_state."'";
	}else{
		$row=mysql_fetch_assoc($res);
		if($debug) echo "<br>".print_r($row);
 
		$current_state_id=$row["id_state"];
		if($debug) echo "<br>Current ID: ".$current_state_id;
 
		foreach($list_states as $id=>$val){
			if($id==$current_state_id) break;
	 		next($list_states);	
		}
 
		if($_GET["id_state"]!="")	$new_state	=	$_GET["id_state"];
		else 						$new_state	=	key($list_states);
		if($debug) echo "<br>New State: ".$new_state;
		if($new_state==""){
 
			$update="DELETE FROM bookings WHERE id_item='".$id_item."' AND the_date='".$the_date."' LIMIT 1";
			$new_class="";
			$new_desc	=$lang["available"];
		}else{
			$update="UPDATE bookings SET id_state='".$new_state."' WHERE id_item='".$id_item."' AND the_date='".$the_date."' LIMIT 1";
 
			$new_desc	=	$list_states[$new_state]["desc"];
			$new_class	=	$list_states[$new_state]["class"];
		}
 
	}	
}
 
if(!mysql_query($update));
 
 
$sql="SELECT * FROM bookings_last_update WHERE id_item='".$id_item."'";
if(!$res=mysql_query($sql)) die("ERROR GETTING CHECKING UPDATE DATE.<br>".mysql_error());
if(mysql_num_rows($res)==0)	$update="INSERT INTO bookings_last_update SET id_item='".$id_item."', date_mod=now()";
else						$update="UPDATE bookings_last_update SET date_mod=now() WHERE id_item='".$id_item."' LIMIT 1";
 
mysql_query($update);
 
 
$date_bits=explode("-",$the_date);
$date_format=$date_bits[2]."/".$date_bits[1]."/".$date_bits[0];
 
echo $new_class."|".$date_format."|".$new_desc;
[PHP] pobierz, plaintext 

nie działa pdo:

[PHP] pobierz, plaintext 
$the_date	=	$_GET["the_date"];
$id_item	=	$_GET["id_item"];
 
 
if( ($_GET["id_item"]=="") || ($_GET["the_date"]=="")){
	die("Error");
}
 
$list_states=array();
$pdo = new db_connect();
$sql = $pdo->prepare("SELECT * FROM bookings_states WHERE state=1 ORDER BY list_order ASC");
$sql->execute();
while($row = $sql->fetch()){
	$list_states[$row["id"]]=array("class"=>"".$row["class"]."","desc"=>"".$row["desc_pl"]."");
}
 
if($_GET["id_state"]=="Wolne"){
	$update = $pdo->prepare("DELETE FROM bookings WHERE id_item='".$id_item."' AND the_date='".$the_date."' LIMIT 1");
	$update->execute();
	$new_class="";
	$new_desc = $lang["pl"];
}else{
	$sql = $pdo->prepare("SELECT id_state FROM bookings WHERE id_item='".$id_item."' AND the_date='".$the_date."'");
	$sql->execute();
	$res = $sql->fetchColumn();
 
	if($res==0){
		if($_GET["id_state"]!=""){
			$new_state	=	$_GET["id_state"];
		}else{						
			$new_state	=	key($list_states);
		}
		if($debug) echo "New state first key ".$new_state;
		$new_desc	=	$list_states[$new_state]["desc"];
		$new_class	=	$list_states[$new_state]["class"];
		$update		= $pdo->prepare("INSERT INTO bookings SET id_item='".$id_item."',the_date='".$the_date."', id_state='".$new_state."'");
		$update->execute();
	}else{
		$row = $sql->fetch();
		if($debug) echo "<br>".print_r($row);
 
		$current_state_id = $row["id_state"];
		if($debug) echo "Current ID: ".$current_state_id;
 
		foreach($list_states as $id=>$val){
			if($id == $current_state_id) break;
	 		next($list_states);
		}
 
		if($_GET["id_state"]!="")	
			$new_state	=	$_GET["id_state"];
		else 						
			$new_state	=	key($list_states);
		if($debug) echo "New State: ".$new_state;
 
		if($new_state==""){
			$update = $pdo->prepare("DELETE FROM bookings WHERE id_item='".$id_item."' AND the_date='".$the_date."' LIMIT 1");
			$update->execute();
			$new_class="";
			$new_desc = $lang["available"];
		}else{
			$update = $pdo->prepare("UPDATE bookings SET id_state='".$new_state."' WHERE id_item='".$id_item."' AND the_date='".$the_date."' LIMIT 1");
			$update->execute();
			$new_desc	=	$list_states[$new_state]["desc"];
			$new_class	=	$list_states[$new_state]["class"];
		}
 
	}	
}
 
$sql = $pdo->prepare("SELECT * FROM bookings_last_update WHERE id_item='".$id_item."'");
$sql->execute();
if($sql->fetchColumn() == 0){
	$update = $pdo->prepare("INSERT INTO bookings_last_update SET id_item='".$id_item."', date_mod=now()");
	$update->execute();
}else{					
	$update = $pdo->prepare("UPDATE bookings_last_update SET date_mod=now() WHERE id_item='".$id_item."' LIMIT 1");
	$update->execute();
}
 
 
 
if($debug) echo "SQL: ".$update."New Class: ";
$date_bits = explode("-",$the_date);
$date_format = $date_bits[2]."/".$date_bits[1]."/".$date_bits[0];
 
echo $new_class."|".$date_format."|".$new_desc;	
[PHP] pobierz, plaintext