Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by mahesh on Oct 20, 2009 00:09
open dhtmlx forum
dhtmlx scheduler and multiple resources

I have implemented multiple resources using a mysql database and php; however, after reloading website all the resourse under a different person default to the first value or key., rather than being preserved where they are placed. Any help you can give would be appreciated; The followig is my code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
    <meta http-equiv="Content-type" content="text/html; charset=utf-8">
    <title></title>
</head>
    <script src="../../codebase/dhtmlxscheduler.js" type="text/javascript" charset="utf-8"></script>
    <link rel="stylesheet" href="../../codebase/dhtmlxscheduler.css" type="text/css" title="no title" charset="utf-8">
<script src="../../codebase/dhtmlxscheduler_units.js" type="text/javascript" charset="utf-8"></script>

    
<style type="text/css" media="screen">
    html, body{
        margin:0px;
        padding:0px;
        height:100%;
        overflow:hidden;
    }    
</style>

<script type="text/javascript" charset="utf-8">
    function init() {

var sections=[
        {key:1, label:"Raymond Hung"},
        {key:2, label:"Ed Lebowitz"},
        {key:3, label:"Harry Morrison"},
        {key:4, label:"Richard Silberstein"},
{key:5, label:"Stan Zipser"}
    ];
        
        //scheduler.config.readonly=1;
scheduler.config.xml_date="%Y-%m-%d %H:%i";
scheduler.config.hour_size_px=75;
        scheduler.config.lightbox.sections=[    
            {name:"description", height:130, map_to:"text", type:"textarea" , focus:true},
{name:"custom", height:23, type:"select", options:sections, map_to:"section_id" },
            {name:"time", height:72, type:"time", map_to:"auto"}
        ]
        scheduler.config.first_hour=7;
scheduler.config.last_hour=19;
scheduler.config.hour_date="%h:%i%A";

        //scheduler.locale.labels.section_location="Location";
        //scheduler.config.details_on_create=true;
        //scheduler.config.details_on_dblclick=true;


     scheduler.createUnitsView("unit","section_id",sections);
scheduler.locale.labels.unit_tab = "Radiologist"
        scheduler.locale.labels.section_custom="Assigned to";
        scheduler.config.details_on_create=true;
        scheduler.init('scheduler_here',null,"week");
        scheduler.load("php/events.php?uid="+scheduler.uid());
        
        var dp = new dataProcessor("php/events.php");
        dp.init(scheduler);

    }
</script>

<body onload="init();">
    <div id="scheduler_here" class="dhx_cal_container" style='width:100%; height:100%;'>
        <div class="dhx_cal_navline">
            <div class="dhx_cal_prev_button"> </div>
            <div class="dhx_cal_next_button"> </div>
            <div class="dhx_cal_today_button"></div>
            <div class="dhx_cal_date"></div>
            <div class="dhx_cal_tab" name="day_tab" style="right:204px;"></div>
            <div class="dhx_cal_tab" name="week_tab" style="right:140px;"></div>
            <div class="dhx_cal_tab" name="month_tab" style="right:76px;"></div>
<div class="dhx_cal_tab" name="unit_tab" style="right:280px;"></div>
        </div>
        <div class="dhx_cal_header">
        </div>
        <div class="dhx_cal_data">
        </div>        
    </div>
</body>
Answer posted by Stanislav (support) on Oct 20, 2009 01:35
The client side code looks correct and must not produce any problems. Which code you are using in events.php , is it have modification to save section_id value to some field in DB?
Answer posted by mahesh on Oct 20, 2009 07:50

The following is my events.php code.  I am unsure as to how to revise it.  Thanks,

   -Mahesh

 

<?php

include ('../../../codebase/connector/scheduler_connector.php');

include ('../../common/config.php');

$res=mysql_connect($server, $user, $pass);

mysql_select_db($db_name);

$scheduler = new schedulerConnector($res);

//$scheduler->enable_log("log.txt",true);

$scheduler->render_table("events","event_id","start_date,end_date,event_name,details");

?>

Answer posted by Alex (support) on Oct 21, 2009 08:21

You did load section_id data from the server at all. Please check the server-side:

$scheduler->render_table("events","event_id","start_date,end_date,event_name,details,section_id");

and more over should add beforeProcessing event handler that will save section_id . 

Answer posted by mahesh on Oct 21, 2009 08:47
I got it to work.  Thanks!