Hello again Stanislav, we are still waiting for an answer or maybe a fix for the problem mention earlier.
tks
seby
Hi Sir, it<s been a while. is there any news about the problem?
tks
Seby
Hello,
As far as I see this have been fixed in 3.5 version.
Please try again using latest files.
Kind regards,
Ilya
Hi ily, what are the main files that i should replace? cause I changed a lot lately.
tks
seby
ext/dhtmlxscheduler_editors.js file.
Best regards,
Ilya
Hi Ilya, ok I tried again with my programmer and we could not do it really. On the client dropdown menu, the only thing I have is the first record name in the database even if it’s not the selected client in database.
So in other words, when I go in edit mode of an existing event, The client field is always showinf the same name.
Tk for help
Seby
<?php
header("Content-type:text/xml");
ini_set('max_execution_time', 600);
session_start();
include ('../../../codebase/connector/scheduler_connector.php');
include ('../../common/config.php');
print("<?xml version=\"1.0\"?>");
$link = mysql_pconnect($server, $user, $pass);
$db = mysql_select_db ($db_name);
mysql_query("SET NAMES utf8");
if (!isset($_GET["pos"])) $_GET["pos"]=0;
getDataFromDB($_GET["mask"]);
mysql_close($link);
//print one level of the tree, based on parent_id
function getDataFromDB($mask){
$sql = "SELECT DISTINCT full_name, id FROM clients Where user_id = '".$_SESSION['user_id']."' AND full_name like '".mysql_real_escape_string($mask)."%'";
$sql.= " Order By full_name LIMIT ". $_GET["pos"].",20";
if ( $_GET["pos"]==0)
print("<complete>");
else
print("<complete add='true'>");
$res = mysql_query ($sql);
if($res){
while($row=mysql_fetch_array($res)){
print("<option value=\"".$row["id"]."\">");
print($row["full_name"]);
print("</option>");
}
}else{
echo mysql_errno().": ".mysql_error()." at ".__LINE__." line in ".__FILE__." file<br>";
}
print("</complete>");
}
?>Hi ilya, any idea?
tks
Seby
I really need help on tht one please.
The client field dropdown does not seems to read the right client ID from database.
tks
Seby
Hi again, I really need help on that one cause it’s really not working.
tks for your help
Seby
Can you provide a js code, which is used on client side to init scheduler and fetch options from the server side ?
What file exactly you wanna see
tks
Seby
Hi, is this what you need?
function init() {
///////////////////-------------added by sushma ////////////////
var sections=[
{key:‘Business’, label:“Business”},
{key:‘Quote’, label:“Quote”},
{key:‘Personal’, label:“Personal”}
];
scheduler.locale.labels.unit_tab = “Unit”
scheduler.locale.labels.section_custom=“Select”;
scheduler.config.details_on_create=true;
scheduler.config.details_on_dblclick=true;
scheduler.config.xml_date="%Y-%m-%d %H:%i";
scheduler.config.prevent_cache = true;
/////////////////////////////////////////////////////////////
scheduler.config.lightbox.sections=[
{name:“session”, height:20, map_to:“session_name”, type:“textarea” , focus:true},
{name:“type”, height:20, type:“select”, options:sections, map_to:“type” },
{name:“subtype”, height:20, type:“select”, map_to:“session_type”,options:scheduler.serverList(“session_type”) },
{name:“clients”, map_to:“client_id”, type:“combo”, image_path: “…/…/codebase/dhtmlxcombo/codebase/imgs/”, filtering: true, script_path: “php/complete.php”, cache: true },
{name:“place”, height:20, type:“textarea”, map_to:“session_location” },
{name:“time”, height:70, type:“calendar_time”, map_to:“auto”},
{name:“notes”, height:80, type:“textarea”, map_to:“session_notes” }
]
scheduler.config.first_hour=4;
scheduler.locale.labels.section_session=“Event Name”;
scheduler.locale.labels.section_notes=“Notes”;
scheduler.locale.labels.section_type=“Type”;
scheduler.locale.labels.section_subtype=“Sub Type”;
scheduler.locale.labels.section_place=“Place”;
scheduler.locale.labels.section_clients=“Clients”;
//top label of calendar
scheduler.templates.calendar_month = scheduler.date.date_to_str("%F %Y");
//week label of calendar
scheduler.templates.calendar_scale_date = scheduler.date.date_to_str("%D");
//date value on the event’s details form
scheduler.templates.calendar_time = scheduler.date.date_to_str("%d-%m-%Y");
scheduler.templates.event_class = function(s,e,ev){
if (ev.type == ‘Personal’) return “Personal”;
if (ev.type == ‘Business’) return “Business”;
if (ev.type == ‘Quote’) return “Quote”;
return “”;
}
//scheduler.locale.labels.section_radiotype=“Select”;
//scheduler.config.details_on_create=true;
//scheduler.config.details_on_dblclick=true;
var d = new Date();
var curr_date = d.getDate();
var curr_month = d.getMonth();
var curr_year = d.getFullYear();
scheduler.config.xml_date="%Y-%m-%d %H:%i";
scheduler.init(‘scheduler_here’,new Date(curr_year,curr_month,1),“year”);
scheduler.setLoadMode(“year”);
scheduler.load(“php/events.php”);
var dp = new dataProcessor(“php/events.php”);
dp.init(scheduler);
}
The client field is always showinf the same name.
Please try to update dhtmlxscheduler_editors.js with attached one
dhtmlxscheduler_editors.zip (1.62 KB)
Ok, i’ve replaced the file. Now, when I edit an event, the client field dropdown is empty. If I then close it and re-open it, now it shows the first record of the database.
tks for your help
Seby
Hi stanislav, My programmer and I are still waiting for an answer
tks for help
Seby
a) please try to check the response which generates server - maybe it somehow related to the server side code, and server sends only one name instead of the list of options.
b) is problematic page can be checked online ?
Hi Stanislav, I’ve sent you a private message
tks
Seby
Is there a working example somewhere so I can copy the files please.
tks
seby
Can I have an answer please. it’s been a long time. I need a working example please
tks
Seby
I am evaluating for purchase but will need similar functionality. Each event gets assigned to a technician and a customer. I would need either a way to open a look up page which would return the selected customer or some efficient way to do this without loading the entire customer list into the event box.
I’m interested to here a recommendation.
Thank you,
Sal