[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.

[trueblue]

W 6-tej linijce pobierana jest wartość elementu o id=id_predefined_state (z jakiegoś inputa).
Gdybyś wskazał na źródło tego kalendarza, byłoby łatwiej.

[casperii]

kalendarz jest generowany poprzez php:

[PHP] pobierz, plaintext 
function draw_cal($id_item, $month, $year, $manage_type="Wolne"){
	global $lang;
 
	$month=sprintf("%02s", $month);
	$today_timestamp	=   mktime(0,0,0,date('m'),date('d'),date('Y'));
	$this_month 		= 	getDate(mktime(0, 0, 0, $month, 1, $year));
	$first_week_day 	= $this_month["wday"];
	$days_in_this_month = cal_days_in_month(CAL_GREGORIAN, $month, $year);
	$day_counter_tot	=	0;
 
 
	$month_last	= $month - 1;
	$year_last	= $year;
	if($month_last < 1){
		$month_last = 12;
		$year_last = $year - 1;	
	}
	$days_in_last_month = cal_days_in_month(CAL_GREGORIAN, $month_last, $year_last);
 
	if($show_week_num)	$list_day_titles='<li class="weeknum_spacer"></li>';
 
	if(AC_START_DAY=="sun"){
		for($k=0; $k<7; $k++){
			$weekday = mb_substr($lang["day_".$k.""],0,1,'UTF-8');
			$list_day_titles.='<li class="cal_weekday"> '.$weekday.'</li>';
		}
	}else{
		if ($first_week_day == 0)	$first_week_day =7;
		for($k=1; $k<=7; $k++){
			if($k==7) 	$weekday = mb_substr($lang["day_0"][0],0,1,'UTF-8');
			else		$weekday = mb_substr($lang["day_".$k.""],0,1,'UTF-8');
			$list_day_titles.='<li title="'.$lang["day_".$k.""].'"> '.$weekday.'</li>';
		}
	}
 
	$j=1;
	if(AC_START_DAY=="sun")	
		$first_week_day_start = $first_week_day;	# start niedziela
 
	else
		$first_week_day = $first_week_day-1;	# start poniedziałek
 
	$row_counter=0;
 
	if($first_week_day!=7){
		if($show_week_num)	$list_days.='<li class="weeknum">-</li>';
		$last_month_start_num=$days_in_last_month-$first_week_day+1;
		for($week_day = 0; $week_day < $first_week_day; $week_day++){
			$list_days.='<li class="cal_empty">'.$last_month_start_num.'</li>';   
			++$last_month_start_num;
			++$j;
			++$day_counter_tot;
 
			if($day_counter_tot % 7==1) ++$row_counter;
		}
	}
	$week_day=$j;
 
	$booked_days=array();
	$pdo = new db_connect();
	$sql = $pdo->prepare("
	SELECT 
		t1.the_date,
		t2.class,
		t2.desc_pl AS the_state
	FROM 
		bookings AS t1
		LEFT JOIN bookings_states AS t2 ON t2.id=t1.id_state
	WHERE 
		t1.id_item=".$id_item." 
		AND MONTH(t1.the_date)=".$month." 
		AND YEAR(t1.the_date)=".$year."
	");
	$sql->execute();
 
	while($row = $sql->fetch()){
		$booked_days[$row["the_date"]]=array("class"=>$row["class"],"state"=>$row["the_state"]);
	}
 
 
	for($day_counter = 1; $day_counter <= $days_in_this_month; $day_counter++){
 
		$day_classes 	=	"";
		$day_title_state=	" - ".$lang["available"];
 
		$day_classes.=' clickable';
		$date_timestamp =   mktime(0,0,0, $month,($day_counter),$year);
 
		$week_num=date("W",$date_timestamp);
		if($week_num!=$last_week_num){
		}
 
		if($date_timestamp==$today_timestamp)	$day_classes.=' today';
 
		$date_db		=	$year."-".sprintf("%02s",$month)."-".sprintf("%02s",$day_counter);
 
        if(AC_DATE_DISPLAY_FORMAT=="us")	$date_format	=	$month."/".$day_counter."/".$year;
        else 			        			$date_format	=	$day_counter."/".$month."/".$year;
 
		if(array_key_exists($date_db,$booked_days)){
			$day_classes.=" ".$booked_days[$date_db]["class"];
			$day_title_state=" - ".$booked_days[$date_db]["state"];
		}		
 
		if( $date_timestamp<$today_timestamp){
			$day_classes.=" past";
 
			if(AC_ACTIVE_PAST_DATES=="off"){
				$day_classes=str_replace(' clickable','',$day_classes);
			}
		}
 
		$getdate=getdate($date_timestamp);
		$day_num=$getdate["wday"]+1;
		if ($day_num % 7 == 1)		$day_classes.=' weekend';
		elseif ($day_num % 6 == 1)	$day_classes.=' weekend';
 
		$list_days .= '
		<li class="'.$day_classes.' "  id="date_'.$date_db.'" title="'.$date_format.$day_title_state.'" data-date="'.$date_format.'">'.$day_counter.'</li>';
 
		$week_day %= 7;
		++$week_day;
		++$day_counter_tot;
 
		if($show_week_num){
			if ($week_day==1) $list_days .= '<li class="weeknum">'.$week_num.'</li>';
		}
		$last_week_num=$week_num;
		if($day_counter_tot % 7==1) ++$row_counter;
	}
	$next_month_day=1;
 
	while($row_counter<6){
 
		for($till_day = $week_day; $till_day <=7; $till_day++){
			$list_days .= '<li class="cal_empty">'.$next_month_day.'</li>'; 
			++$next_month_day;  
			++$day_counter_tot;
 
		if($day_counter_tot % 7==1) ++$row_counter;
		}
		$week_day=1;
 
	}
 
	if($week_day > 1){
		for($till_day = $week_day; $till_day <=7; $till_day++){
			$list_days .= '<li class="cal_empty">'.$next_month_day.'</li>'; 
			++$next_month_day;  
			++$day_counter_tot;
		}
	}
 
	$the_cal='
	<div id="'.$month.'_'.$year.'" class="cal_title">'.$lang["month_".$month.""].' '.$year.'</div>
	<ul class="cal_weekday">
		'.$list_day_titles.'
	</ul>
	<ul>
		'.$list_days.'
	</ul>
	<div class="clear"></div>
	';
	return $the_cal;
}
[PHP] pobierz, plaintext 

Nie widzę, tutaj inputa
Źródło: link

Ten post edytował casperii 2.07.2017, 13:12:54

[trueblue]

Miałem na myśli pochodzenie tego kalendarza, link. Ale wygląda na to, że to jakiś customowy skrypt.
Input nie musi być w kodzie PHP, może być wstrzykiwany dynamicznie w JS. Kod JS, który pokazałeś na pewno nie jest cały, widać to chociażby po tym, że w requeście przesyłane są zmienne, które w tym fragmencie nie są pobierane (id_item czy lang). Poszukaj id_predefined_state gdzieś w pozostałej części kodu JS.

[casperii]

@trueblue źródlo podałem wyżej:
lang , item pobieram są tutaj i pchane do js.

[HTML] pobierz, plaintext 
 
<script type="text/javascript" src="/js/calendar/mootools-core-1.3.2-full-compat-yc.js"></script>
	<script type="text/javascript" src="/js/calendar/mootools-cal-admin.js"></script>
<script type="text/javascript">
	var date_hover 	= true;
	var show_message = true;
	var lang	=	'pl';
	var url_ajax_cal 	= '/calendar.ajax.php';
	var url_ajax_update = '/update_calendar.ajax.php';
	var img_loading_day		= '../images/calendar/ajax-loader-day.gif';
	var img_loading_month	= '../images/calendar/ajax-loader-month.gif';
	var id_item = '2';
	var months_to_show	= 5;
	var clickable_past		= 'on';
	</script>
[HTML] pobierz, plaintext 

Przeszukałem wszystkie JS i nie ma: id_predefined_state

Ten post edytował casperii 2.07.2017, 13:24:38

[trueblue]

Jest <select> o takim id w \ac-admin\bookings.admin.php
A swoją drogą, czy Tobie nie jest potrzebne id_item do identyfikacji rekordu, a nie id_predefined_state?

[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